142:
143: DupResultTable(ak_query_pkg.g_results_table, g_header_results_table);
144: DupItemTable(ak_query_pkg.g_items_table, g_header_items_table);
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,
163: IF l_total_rows = 1 THEN
164:
165: PrintResult(g_header_results_table.FIRST, g_header_results_table, g_header_items_table);
166:
167: IF FND_FUNCTION.TEST('ICX_DISABLE_ASBN') and valid_invoice_num(l_session_id) THEN
168:
169: htp.p('
226:
227: DupResultTable(ak_query_pkg.g_results_table, g_ship_results_table);
228: DupItemTable(ak_query_pkg.g_items_table, g_ship_items_table);
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,
273: htp.p('