');
Line 136: p_parent_region_code=>'POS_ASN_REVIEW_HEADERS_R',
132:
133: l_where_clause := 'SESSION_ID = ' || to_char(l_session_id);
134:
135: ak_query_pkg.exec_query(p_parent_region_appl_id=>178,
136: p_parent_region_code=>'POS_ASN_REVIEW_HEADERS_R',
137: p_where_clause=>l_where_clause,
138: p_responsibility_id=>icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID),
139: p_user_id=>icx_sec.getID(icx_sec.PV_WEB_USER_ID),
140: p_return_parents=>'T',
Line 149: p_parent_region_code=>'POS_ASN_REVIEW_INV_HDR_R',
145:
146: IF FND_FUNCTION.TEST('ICX_DISABLE_ASBN') and valid_invoice_num(l_session_id) THEN
147:
148: ak_query_pkg.exec_query(p_parent_region_appl_id=>178,
149: p_parent_region_code=>'POS_ASN_REVIEW_INV_HDR_R',
150: p_where_clause=>l_where_clause,
151: p_responsibility_id=>icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID),
152: p_user_id=>icx_sec.getID(icx_sec.PV_WEB_USER_ID),
153: p_return_parents=>'T',
Line 198: p_parent_region_code=>'POS_ASN_REVIEW_DETAILS_SEQ_R',
194:
195: l_where_clause := 'SESSION_ID = ' || to_char(l_session_id);
196:
197: ak_query_pkg.exec_query(p_parent_region_appl_id=>178,
198: p_parent_region_code=>'POS_ASN_REVIEW_DETAILS_SEQ_R',
199: p_where_clause=>l_where_clause,
200: p_responsibility_id=>icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID),
201: p_user_id=>icx_sec.getID(icx_sec.PV_WEB_USER_ID),
202: p_return_parents=>'T',
Line 209: p_parent_region_code=>'POS_ASN_REVIEW_PO_DETAILS_R',
205: DupResultTable(ak_query_pkg.g_results_table, g_seq_results_table);
206: DupItemTable(ak_query_pkg.g_items_table, g_seq_items_table);
207:
208: ak_query_pkg.exec_query(p_parent_region_appl_id=>178,
209: p_parent_region_code=>'POS_ASN_REVIEW_PO_DETAILS_R',
210: p_where_clause=>l_where_clause,
211: p_responsibility_id=>icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID),
212: p_user_id=>icx_sec.getID(icx_sec.PV_WEB_USER_ID),
213: p_return_parents=>'T',
Line 220: p_parent_region_code=>'POS_ASN_REVIEW_SHIP_DETAILS_R',
216: DupResultTable(ak_query_pkg.g_results_table, g_lines_results_table);
217: DupItemTable(ak_query_pkg.g_items_table, g_lines_items_table);
218:
219: ak_query_pkg.exec_query(p_parent_region_appl_id=>178,
220: p_parent_region_code=>'POS_ASN_REVIEW_SHIP_DETAILS_R',
221: p_where_clause=>l_where_clause,
222: p_responsibility_id=>icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID),
223: p_user_id=>icx_sec.getID(icx_sec.PV_WEB_USER_ID),
224: p_return_parents=>'T',
Line 233: p_parent_region_code=>'POS_ASN_REVIEW_INV_DETAILS_R',
229:
230: IF FND_FUNCTION.TEST('ICX_DISABLE_ASBN') and valid_invoice_num(l_session_id) THEN
231:
232: ak_query_pkg.exec_query(p_parent_region_appl_id=>178,
233: p_parent_region_code=>'POS_ASN_REVIEW_INV_DETAILS_R',
234: p_where_clause=>l_where_clause,
235: p_responsibility_id=>icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID),
236: p_user_id=>icx_sec.getID(icx_sec.PV_WEB_USER_ID),
237: p_return_parents=>'T',
Line 430: pos_asn_review_pkg.g_temp_table := p_table;
426: BEGIN
427:
428: IF p_table.count > 0 THEN
429:
430: pos_asn_review_pkg.g_temp_table := p_table;
431:
432: sql_statement := 'begin ' ||
433: ':l_result := pos_asn_review_pkg.g_temp_table(:p_index).value' ||
434: to_char(p_col) || '; ' ||
Line 433: ':l_result := pos_asn_review_pkg.g_temp_table(:p_index).value' ||
429:
430: pos_asn_review_pkg.g_temp_table := p_table;
431:
432: sql_statement := 'begin ' ||
433: ':l_result := pos_asn_review_pkg.g_temp_table(:p_index).value' ||
434: to_char(p_col) || '; ' ||
435: ' end;';
436:
437: l_cursor := dbms_sql.open_cursor;
Line 463: from pos_asn_shop_cart_headers
459: begin
460:
461: select invoice_num
462: into l_num
463: from pos_asn_shop_cart_headers
464: where session_id = p_session_id;
465:
466: if l_num is not null then
467: return true;
Line 478: END pos_asn_review_pkg;
474: return false;
475:
476: end valid_invoice_num;
477:
478: END pos_asn_review_pkg;