Require the collections.js javascript file.

AJAX_COLLECTION_PRC create or replace PROCEDURE "AJAX_COLLECTION_PRC" AS begin /* create collection id add has been called but no collection */ if(upper(v('AJAX_CURRENT_COLLECTION_ACTION'))='ADD' and wwv_flow_collection.collection_exists(p_collection_name=>upper(v('AJAX_CURRENT_COLLECTION'))) = false) then HTMLDB_COLLECTION.CREATE_OR_TRUNCATE_COLLECTION(p_collection_name=>upper(v('AJAX_CURRENT_COLLECTION'))); end if; if(wwv_flow_collection.collection_exists(p_collection_name=>upper(v('AJAX_CURRENT_COLLECTION'))))then if(upper(v('AJAX_CURRENT_COLLECTION_ACTION'))='DELETE') then HTMLDB_COLLECTION.DELETE_COLLECTION(p_collection_name=>upper(v('AJAX_CURRENT_COLLECTION'))); elsif(upper(v('AJAX_CURRENT_COLLECTION_ACTION'))='TRUNCATE') then HTMLDB_COLLECTION.CREATE_OR_TRUNCATE_COLLECTION(p_collection_name=>upper(v('AJAX_CURRENT_COLLECTION'))); elsif(upper(v('AJAX_CURRENT_COLLECTION_ACTION'))='SORT') then HTMLDB_COLLECTION.SORT_MEMBERS(p_collection_name=>upper(v('AJAX_CURRENT_COLLECTION')),p_sort_on_column_number => 1); elsif(upper(v('AJAX_CURRENT_COLLECTION_ACTION'))='CREATE_COLLECTION_FROM_QUERY') then if(wwv_flow_collection.collection_exists(p_collection_name=>upper(v('AJAX_CURRENT_COLLECTION'))) = true) then HTMLDB_COLLECTION.DELETE_COLLECTION(p_collection_name=>upper(v('AJAX_CURRENT_COLLECTION'))); end if; elsif(upper(v('AJAX_CURRENT_COLLECTION_ACTION'))='ADD') then HTMLDB_COLLECTION.ADD_MEMBER(p_collection_name =>upper(v('AJAX_CURRENT_COLLECTION')),p_c001 =>v('AJAX_CURRENT_COLLECTION_ITEM')); end if; htp.p(upper(v('AJAX_CURRENT_COLLECTION_ACTION'))); if(upper(v('AJAX_COLLECTION_FORMAT'))!='NONE' and wwv_flow_collection.collection_exists(p_collection_name=>upper(v('AJAX_CURRENT_COLLECTION'))))then /*add extra output options here*/ if(upper(v('AJAX_COLLECTION_FORMAT'))='XML')then owa_util.mime_header('text/xml', FALSE ); htp.p('Cache-Control: no-cache'); htp.p('Pragma: no-cache'); owa_util.http_header_close; htp.p('<collection id="'||upper(v('AJAX_CURRENT_COLLECTION'))||'">'); for rec in (SELECT * FROM htmldb_collections WHERE collection_name = upper(v('AJAX_CURRENT_COLLECTION'))) loop htp.prn('<row><item>' || rec.c001 || '</item></row>'); end loop; htp.p('</collection>'); else htp.p('<table cellpadding="0" border="0" cellspacing="0" summary="" id="'||upper(v('AJAX_CURRENT_COLLECTION'))||'">'); htp.p('<tr><th>'||upper(v('AJAX_CURRENT_COLLECTION'))||'</th></tr>'); for rec in (SELECT * FROM htmldb_collections WHERE collection_name = upper(v('AJAX_CURRENT_COLLECTION'))) loop htp.prn('<tr>'); htp.prn('<td>' || rec.c001 || '</td>'); htp.prn('</tr>'); end loop; htp.p('</table>'); end if; end if; end if; /*clear all values from app level items*/ HTMLDB_UTIL.SET_SESSION_STATE('AJAX_COLLECTION_FORMAT',null); HTMLDB_UTIL.SET_SESSION_STATE('AJAX_CURRENT_COLLECTION_ACTION',null); HTMLDB_UTIL.SET_SESSION_STATE('AJAX_CURRENT_COLLECTION',null); HTMLDB_UTIL.SET_SESSION_STATE('AJAX_CURRENT_COLLECTION_ITEM',null); end;