DBA Data[Home] [Help]

APPS.POS_ASN_REVIEW_PKG dependencies on POS_ASN

Line 1: PACKAGE BODY pos_asn_review_pkg AS

1: PACKAGE BODY pos_asn_review_pkg AS
2: /* $Header: POSASNRB.pls 115.1 99/10/14 16:18:39 porting shi $ */
3:
4: g_header_results_table ak_query_pkg.results_table_type;
5: g_header_items_table ak_query_pkg.items_table_type;

Line 81: pos_asn.submit;

77: htp.headClose;
78:
79: if p_submit = 'Y' then
80:
81: pos_asn.submit;
82:
83: htp.p(' 84: '''' || pos_asn.sub_state || '''' || ',' ||
85: '''' || pos_asn.error_message || '''' || ',' ||
86: '''' || pos_asn.but1 || '''' || ',' ||
87: '''' || pos_asn.but2 || '''' || ',' ||
88: '''' || pos_asn.but3 || '''' ||

Line 85: '''' || pos_asn.error_message || '''' || ',' ||

81: pos_asn.submit;
82:
83: htp.p('');

Line 86: '''' || pos_asn.but1 || '''' || ',' ||

82:
83: htp.p('');
90: else

Line 87: '''' || pos_asn.but2 || '''' || ',' ||

83: htp.p('');
90: else
91:

Line 88: '''' || pos_asn.but3 || '''' ||

84: '''' || pos_asn.sub_state || '''' || ',' ||
85: '''' || pos_asn.error_message || '''' || ',' ||
86: '''' || pos_asn.but1 || '''' || ',' ||
87: '''' || pos_asn.but2 || '''' || ',' ||
88: '''' || pos_asn.but3 || '''' ||
89: ')">');
90: else
91:
92: htp.p('');

Line 96: htp.p('
');

92: htp.p('');
93:
94: end if;
95:
96: htp.p('');
97:
98: htp.p('');
99:
100: htp.p('');

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;