eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ICX_REQ_SPECIAL_ORD dependencies on AK_QUERY_PKG

Line 116: -- save space. Using global variables in ak_query_pkg instead.

112: v_attribute varchar2(240);
113: v_table_attribute varchar2(240);
114:
115: -- (MC) removed local variables v_results_table and v_regions_table to
116: -- save space. Using global variables in ak_query_pkg instead.
117:
118: v_items_table ak_query_pkg.items_table_type;
119:
120:

Line 118: v_items_table ak_query_pkg.items_table_type;

114:
115: -- (MC) removed local variables v_results_table and v_regions_table to
116: -- save space. Using global variables in ak_query_pkg instead.
117:
118: v_items_table ak_query_pkg.items_table_type;
119:
120:
121: v_vendor_on_flag varchar2(1);
122: v_dcdName VARCHAR2(1000);

Line 156: ak_query_pkg.exec_query(P_PARENT_REGION_APPL_ID => 601,

152: -- Special Order Related Object Navigator
153: -- Just get the structure, NO DATA i.e. P_RETURN_PARENTS => 'F'
154:
155: -- (MC) Use exec_query instead of execute_query to improve performance
156: ak_query_pkg.exec_query(P_PARENT_REGION_APPL_ID => 601,
157: P_PARENT_REGION_CODE => 'ICX_REQ_SPECIAL_ORDER',
158: P_RESPONSIBILITY_ID => icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID),
159: P_USER_ID => icx_sec.getID(icx_sec.PV_WEB_USER_ID),
160: P_RETURN_PARENTS => 'F',

Line 166: v_items_table := ak_query_pkg.g_items_table;

162:
163:
164: -- Make a copy of v_items_table b/c it will be overwritten by the second
165: -- exec_query;
166: v_items_table := ak_query_pkg.g_items_table;
167:
168: htp.htmlOpen;
169: htp.headOpen;
170: icx_util.copyright;

Line 425: ak_query_pkg.exec_query(P_PARENT_REGION_APPL_ID => 178,

421: UPPER(v_items_table(i).item_style) = 'POPLIST' THEN
422:
423: -- No Hierarchy setup; show regular categories
424:
425: ak_query_pkg.exec_query(P_PARENT_REGION_APPL_ID => 178,
426: P_PARENT_REGION_CODE => 'ICX_REQ_CATEGORIES',
427: P_RESPONSIBILITY_ID => icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID),
428: P_USER_ID => icx_sec.getID(icx_sec.PV_WEB_USER_ID),
429: P_WHERE_CLAUSE => ' FUNCTIONAL_AREA_ID = 2',

Line 434: IF ak_query_pkg.g_results_table.count > 0 THEN

430:
431: P_RETURN_PARENTS => 'T',
432: P_RETURN_CHILDREN => 'F');
433:
434: IF ak_query_pkg.g_results_table.count > 0 THEN
435: FOR i IN ak_query_pkg.g_results_table.FIRST .. ak_query_pkg.g_results_table.LAST LOOP
436: -- Category Id
437: v_category_id := ak_query_pkg.g_results_table(i).value3;
438: -- Category Name

Line 435: FOR i IN ak_query_pkg.g_results_table.FIRST .. ak_query_pkg.g_results_table.LAST LOOP

431: P_RETURN_PARENTS => 'T',
432: P_RETURN_CHILDREN => 'F');
433:
434: IF ak_query_pkg.g_results_table.count > 0 THEN
435: FOR i IN ak_query_pkg.g_results_table.FIRST .. ak_query_pkg.g_results_table.LAST LOOP
436: -- Category Id
437: v_category_id := ak_query_pkg.g_results_table(i).value3;
438: -- Category Name
439: v_category_name :=ak_query_pkg.g_results_table(i).value1;

Line 437: v_category_id := ak_query_pkg.g_results_table(i).value3;

433:
434: IF ak_query_pkg.g_results_table.count > 0 THEN
435: FOR i IN ak_query_pkg.g_results_table.FIRST .. ak_query_pkg.g_results_table.LAST LOOP
436: -- Category Id
437: v_category_id := ak_query_pkg.g_results_table(i).value3;
438: -- Category Name
439: v_category_name :=ak_query_pkg.g_results_table(i).value1;
440: v_select_text := v_select_text || '

Line 439: v_category_name :=ak_query_pkg.g_results_table(i).value1;

435: FOR i IN ak_query_pkg.g_results_table.FIRST .. ak_query_pkg.g_results_table.LAST LOOP
436: -- Category Id
437: v_category_id := ak_query_pkg.g_results_table(i).value3;
438: -- Category Name
439: v_category_name :=ak_query_pkg.g_results_table(i).value1;
440: v_select_text := v_select_text || '

Line 442: END IF; /* ak_query_pkg... .count > 0 */

438: -- Category Name
439: v_category_name :=ak_query_pkg.g_results_table(i).value1;
440: v_select_text := v_select_text || '

Line 924: procedure chk_vendor_on(v_items_table IN ak_query_pkg.items_table_type,

920:
921:
922: -- to remove later the following procedure
923: ------------------------------------------------------------------------
924: procedure chk_vendor_on(v_items_table IN ak_query_pkg.items_table_type,
925: v_on OUT varchar2) is
926: ------------------------------------------------------------------------
927:
928: v_vendor_on_flag varchar2(1);