APPS.PO_CONTROL_ACTION_VALIDATIONS dependencies on PO_TBL_NUMBER

Line 4940: l_line_loc_id_tbl po_tbl_number;

4936: d_api_version CONSTANT NUMBER := 1.0;
4937: d_module CONSTANT VARCHAR2(100) := g_pkg_name || d_api_name;
4938:
4939: l_progress VARCHAR2(3) := '000' ;
4940: l_line_loc_id_tbl po_tbl_number;
4941: l_line_id_tbl po_tbl_number;
4942: l_sequence po_online_report_text.sequence%TYPE;
4943: l_line_token VARCHAR2(20);
4944: l_ship_token VARCHAR2(20);

Line 4941: l_line_id_tbl po_tbl_number;

4937: d_module CONSTANT VARCHAR2(100) := g_pkg_name || d_api_name;
4938:
4939: l_progress VARCHAR2(3) := '000' ;
4940: l_line_loc_id_tbl po_tbl_number;
4941: l_line_id_tbl po_tbl_number;
4942: l_sequence po_online_report_text.sequence%TYPE;
4943: l_line_token VARCHAR2(20);
4944: l_ship_token VARCHAR2(20);
4945: l_amt_token VARCHAR2(20);

Line 5059: FROM TABLE (CAST (l_line_loc_id_tbl AS po_tbl_number)));

5055: WHERE poall.line_location_id =poll.line_location_id
5056: AND poall.latest_external_flag ='Y')
5057: WHERE line_location_id IN
5058: (SELECT *
5059: FROM TABLE (CAST (l_line_loc_id_tbl AS po_tbl_number)));
5060:
5061:
5062: -- Reverting back the Lines Quantity and amount
5063: UPDATE po_lines pol

Line 5081: FROM TABLE (CAST (l_line_id_tbl AS po_tbl_number)));

5077:
5078: FROM po_line_locations POLL
5079: WHERE poll.po_line_id = pol.po_line_id)
5080: WHERE po_line_id IN (SELECT *
5081: FROM TABLE (CAST (l_line_id_tbl AS po_tbl_number)));
5082:
5083: -- Bug 14580278 :Updating Price for Non Complex SPO Lines
5084:
5085: UPDATE po_lines pol

Line 5096: FROM TABLE (CAST (l_line_loc_id_tbl AS po_tbl_number)))

5092: FROM po_line_locations poll
5093: WHERE poll.payment_type IS NULL
5094: AND line_location_id IN
5095: (SELECT *
5096: FROM TABLE (CAST (l_line_loc_id_tbl AS po_tbl_number)))
5097: );
5098:
5099:
5100:

Line 5113: FROM TABLE (CAST (l_line_loc_id_tbl AS po_tbl_number)))

5109: FROM po_line_locations poll
5110: WHERE poll.payment_type IS NOT NULL
5111: AND line_location_id IN
5112: (SELECT *
5113: FROM TABLE (CAST (l_line_loc_id_tbl AS po_tbl_number)))
5114: );
5115:
5116: --Gt Table Columns Mapping
5117: --num1 - entity_id

Line 5202: FROM TABLE (CAST (l_line_loc_id_tbl AS po_tbl_number)))

5198: AND gt.char1 <> PO_Document_Cancel_PVT.c_doc_type_PA
5199: AND poll.po_line_id = pol.po_line_id
5200: AND poll.line_location_id IN
5201: (SELECT line_location_id
5202: FROM TABLE (CAST (l_line_loc_id_tbl AS po_tbl_number)))
5203: AND ( (poll.line_location_id=gt.num1
5204: AND gt.char3=PO_Document_Cancel_PVT.c_entity_level_SHIPMENT)
5205: OR(poll.po_line_id=gt.num1
5206: AND gt.char3=PO_Document_Cancel_PVT.c_entity_level_LINE)

Line 5298: p_line_loc_id_tbl po_tbl_number;

5294: d_api_name CONSTANT VARCHAR2(30) := 'check_revert_pending_changes.';
5295: d_module CONSTANT VARCHAR2(100) := g_pkg_name || d_api_name;
5296:
5297: l_progress VARCHAR2(3) := '000' ;
5298: p_line_loc_id_tbl po_tbl_number;
5299: p_line_id_tbl po_tbl_number;
5300: l_line_token VARCHAR2(20);
5301: l_ship_token VARCHAR2(20);
5302: l_amt_token VARCHAR2(20);

Line 5299: p_line_id_tbl po_tbl_number;

5295: d_module CONSTANT VARCHAR2(100) := g_pkg_name || d_api_name;
5296:
5297: l_progress VARCHAR2(3) := '000' ;
5298: p_line_loc_id_tbl po_tbl_number;
5299: p_line_id_tbl po_tbl_number;
5300: l_line_token VARCHAR2(20);
5301: l_ship_token VARCHAR2(20);
5302: l_amt_token VARCHAR2(20);
5303: l_qty_token VARCHAR2(20);

Line 6269: l_doc_id_tbl po_tbl_number :=PO_TBL_NUMBER();

6265: l_entity_rec_tbl po_document_action_pvt.entity_dtl_rec_type_tbl;
6266: l_cbc_enabled VARCHAR2(1);
6267: l_action_date DATE;
6268: id_count NUMBER :=0;
6269: l_doc_id_tbl po_tbl_number :=PO_TBL_NUMBER();
6270: l_source VARCHAR2(50);
6271:
6272:
6273: BEGIN