DBA Data[Home] [Help]

APPS.ICX_REQ_CATEGORIES dependencies on ICX_PARAMETERS

Line 776: SELECT QUERY_SET INTO c_query_size FROM ICX_PARAMETERS;

772: c_query_size number;
773:
774: begin
775:
776: SELECT QUERY_SET INTO c_query_size FROM ICX_PARAMETERS;
777:
778: v_lang := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
779: htp.p('');
780:

Line 912: select QUERY_SET into c_query_size from ICX_PARAMETERS;

908: --order_by_clause can be done through ON
909: --order_by_clause := 'sequence_num, item_number, item_description';
910:
911: --get number of rows to display
912: select QUERY_SET into c_query_size from ICX_PARAMETERS;
913:
914: --set up end rows to display
915: if p_end_row is null then
916: end_row := c_query_size;