DBA Data[Home] [Help]

APPS.ICX_REQ_COPY_REQ dependencies on ICX_ON_UTILITIES

Line 161: icx_on_utilities.FindPage(p_flow_appl_id => '',

157: v_help_url := '/OA_DOC/' || v_language_code ||'/awe' || '/icxhlprq.htm';
158:
159: -- Call the Findpage function to paint the find page. (AK flow)
160:
161: icx_on_utilities.FindPage(p_flow_appl_id => '',
162: p_flow_code => '',
163: p_page_appl_id => '',
164: p_page_code => '',
165: p_region_appl_id => 178,

Line 254: v_where_clause := icx_on_utilities.whereSegment(a_1, c_1, i_1,

250: if p_where IS NOT NULL THEN
251: v_where_clause := icx_call.decrypt2(p_where);
252: ELSE
253: -- generate the where clause
254: v_where_clause := icx_on_utilities.whereSegment(a_1, c_1, i_1,
255: a_2, c_2, i_2,
256: a_3, c_3, i_3,
257: a_4, c_4, i_4,
258: a_5, c_5, i_5,

Line 283: icx_on_utilities.unpack_whereSegment(v_where_clause, l_where_clause, l_where_binds);

279: END IF;
280:
281: /* added to take care of Bind vars Bug **/
282:
283: icx_on_utilities.unpack_whereSegment(v_where_clause, l_where_clause, l_where_binds);
284:
285: ak_query_pkg.exec_query(P_PARENT_REGION_APPL_ID => 178,
286: P_PARENT_REGION_CODE => 'ICX_PO_REQ_HEAD_SUM_R',
287: P_RESPONSIBILITY_ID => icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID),

Line 295: -- icx_on_utilities2.printPLSQLtables;

291: P_RETURN_CHILDREN => 'F',
292: P_WHERE_BINDS => l_where_binds );
293:
294: -- test - dump the plsql tables for debug purpose only!
295: -- icx_on_utilities2.printPLSQLtables;
296:
297: -- get the total number of rows
298: v_total_rows := ak_query_pkg.g_results_table.count;
299:

Line 358: icx_on_utilities2.displaySetIcons(v_language_code,

354: htp.br;
355:
356: IF(v_total_rows > 5)
357: THEN
358: icx_on_utilities2.displaySetIcons(v_language_code,
359: 'icx_req_copy_req.display_reqs',
360: p_start_row,
361: v_end_row,
362: v_encrypted_where,

Line 429: icx_on_utilities2.displaySetIcons(v_language_code,

425: htp.br;
426:
427: IF(v_total_rows > 5)
428: THEN
429: icx_on_utilities2.displaySetIcons(v_language_code,
430: 'icx_req_copy_req.display_reqs',
431: p_start_row,
432: v_end_row,
433: v_encrypted_where,