APPS.POS_ACK_SEARCH dependencies on POS_ACK_SELECT

Line 218:

214: frameborder=no
215: scrolling=no>');
216: htp.p('
217:
218: 219: NAME="upperbanner" MARGINWIDTH="0" MARGINHEIGHT="0" frameborder=no SCROLLING=NO>
220:
221:
222:

Line 451: fnd_message.get_string('ICX', 'ICX_POS_ACK_SELECT_RESULT') ||

447: htp.p('
448:
449:
453:

450: ' || 451: fnd_message.get_string('ICX', 'ICX_POS_ACK_SELECT_RESULT') || 452: '

454: ' || 455: l_msg || Line 913: delete from pos_ack_select; 909: l_Document_Type_Code => pos_ack_sr_doc_type 910: ); 911: exception 912: when others then 913: delete from pos_ack_select; 914: end; 915: l_start_row := 1; 916: l_end_row := 99999; 917: --l_end_row := 25; Line 1036: from pos_ack_select; 1032: 1033: -- Header End 1034: /* 1035: select count(*) into l_count 1036: from pos_ack_select; 1037: */ 1038: ak_query_pkg.exec_query(p_parent_region_appl_id => 178, 1039: p_parent_region_code => 'POS_ACK_EDIT_R', 1040: p_where_clause => '', Line 1189: from pos_ack_select; 1185: js.scriptClose; 1186: htp.headClose; 1187: 1188: select count(*) into l_count 1189: from pos_ack_select; 1190: 1191: l_msg1 := fnd_message.get_string('ICX','ICX_POS_ACK_TOTAL_PO_SUB2'); 1192: l_msg1 := replace(l_msg1, '&TOTAL', to_char(l_rows_inserted)); 1193: Line 1766: from pos_ack_select_v 1762: l_session_id number; 1763: 1764: CURSOR l_cursor IS 1765: select * 1766: from pos_ack_select_v 1767: where 1768: acceptance_status = nvl(l_acceptance_status, acceptance_status) 1769: and acceptance_required = nvl(l_Acceptance_Reqd_Flag, acceptance_required) 1770: -- and acceptance_required_by between nvl(l_Start_Date, acceptance_required_by) and nvl(l_End_Date, acceptance_required_by) Line 1786: delete from pos_ack_select; 1782: Veera_Debug('Acceptance Required:' || l_Acceptance_Reqd_Flag); 1783: Veera_Debug('Acceptance Required By:' || l_start_date || 'to' || l_end_date); 1784: Veera_Debug('supplier_site_id :' || l_Supplier_Site_Id); 1785: Veera_Debug('Document Type :' || l_Document_Type_Code); 1786: delete from pos_ack_select; 1787: 1788: l_temp1 := fnd_message.get_string('ICX','ICX_POS_ACK_YES'); 1789: l_temp2 := fnd_message.get_string('ICX','ICX_POS_ACK_NO'); 1790: Line 1807: insert into pos_ack_select 1803: LOOP 1804: fetch l_cursor into l_po_rec; 1805: EXIT WHEN l_cursor%NOTFOUND; 1806: 1807: insert into pos_ack_select 1808: ( 1809: acceptance_flag, 1810: accept, 1811: reject, Line 2042: delete from pos_ack_select 2038: ItemKey => l_item_key ); 2039: 2040: 2041: 2042: delete from pos_ack_select 2043: where row_num = to_number(pos_ack_row_num(l_counter)); 2044: POS_WF_PO_ACKNOWLEDGE.Abort_Notification(l_doc_id, l_revision_num, l_doc_type); 2045: else 2046: l_error := -1; Line 2049: delete from pos_ack_select 2045: else 2046: l_error := -1; 2047: end if; 2048: else 2049: delete from pos_ack_select 2050: where row_num = to_number(pos_ack_row_num(l_counter)); 2051: end if; 2052: END LOOP; 2053: veera_debug('Rows Inserted in PO ACKs :' || to_char(l_rows_inserted));