APPS.PO_PDOI_PREPROC_PVT dependencies on PO_LINES_INTERFACE

Line 191: FROM po_lines_interface

187: BULK COLLECT
188: INTO l_intf_line_id_tbl,
189: l_price_chg_accept_flag_tbl,
190: l_price_break_flag_tbl
191: FROM po_lines_interface
192: WHERE interface_header_id = PO_PDOI_PARAMS.g_request.interface_header_id
193: AND NVL(process_code, PO_PDOI_CONSTANTS.g_process_code_PENDING) =
194: PO_PDOI_CONSTANTS.g_process_code_NOTIFIED
195: ORDER BY po_line_id, interface_line_id;

Line 227: UPDATE po_lines_interface

223:
224: -- update price change accept flag for price break lines
225: IF (l_update_flag_value_idx_tbl.COUNT > 0) THEN
226: FORALL i IN VALUES OF l_update_flag_value_idx_tbl
227: UPDATE po_lines_interface
228: SET price_chg_accept_flag = l_price_chg_accept_flag_tbl(i)
229: WHERE interface_line_id = l_intf_line_id_tbl(i);
230: END IF;
231:

Line 240: UPDATE po_lines_interface lines

236:
237: -- bug5149827
238: -- Set the acceptance status of the child record to be the same as
239: -- the parent
240: UPDATE po_lines_interface lines
241: SET lines.price_chg_accept_flag =
242: ( SELECT parent_lines.price_chg_accept_flag
243: FROM po_lines_interface parent_lines
244: WHERE lines.parent_interface_line_id =

Line 243: FROM po_lines_interface parent_lines

239: -- the parent
240: UPDATE po_lines_interface lines
241: SET lines.price_chg_accept_flag =
242: ( SELECT parent_lines.price_chg_accept_flag
243: FROM po_lines_interface parent_lines
244: WHERE lines.parent_interface_line_id =
245: parent_lines.interface_line_id )
246: WHERE lines.interface_header_id = PO_PDOI_PARAMS.g_request.interface_header_id
247: AND NVL(lines.process_code, PO_PDOI_CONSTANTS.g_process_code_PENDING) =

Line 259: UPDATE po_lines_interface

255:
256: d_position := 40;
257:
258: -- Reject all records that have not been accepted
259: UPDATE po_lines_interface
260: SET process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_REJECTED
261: WHERE interface_header_id = PO_PDOI_PARAMS.g_request.interface_header_id
262: AND process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED
263: AND price_chg_accept_flag = 'N';

Line 419: UPDATE po_lines_interface

415:
416: d_position := 40;
417: -- Line level assignment
418: FORALL i IN 1..l_intf_header_id_tbl.COUNT
419: UPDATE po_lines_interface
420: SET processing_id = PO_PDOI_PARAMS.g_processing_id,
421: action = DECODE (action,
422: PO_PDOI_CONSTANTS.g_action_ADD, action,
423: NULL), -- null out process code unless it is force add

Line 1902: FROM po_lines_interface

1898: -- case we need to populate the information to line location information
1899: -- for processing later on
1900: CURSOR c_line_intf IS
1901: SELECT rowid
1902: FROM po_lines_interface
1903: WHERE processing_id = PO_PDOI_PARAMS.g_processing_id
1904: AND NVL(line_loc_populated_flag, 'N') = 'N';
1905:
1906: --SQL What: Get line location records that are just being populated

Line 1914: po_lines_interface PLI

1910: CURSOR c_line_loc_intf IS
1911: SELECT PLLI.interface_line_id,
1912: PLLI.interface_line_location_id
1913: FROM po_line_locations_interface PLLI,
1914: po_lines_interface PLI
1915: WHERE PLLI.processing_id = PO_PDOI_PARAMS.g_processing_id
1916: AND PLLI.interface_line_id = PLI.interface_line_id
1917: AND NVL(PLI.line_loc_populated_flag, 'N') = 'N';
1918:

Line 2106: FROM po_lines_interface PLI

2102: PLI.taxable_flag,
2103: PLI.tax_code_id,
2104: PLI.tax_name,
2105: PLI.qty_rcv_tolerance
2106: FROM po_lines_interface PLI
2107: WHERE PLI.rowid = l_rowid_tbl(i);
2108:
2109: END LOOP;
2110:

Line 2147: UPDATE po_lines_interface

2143: d_position := 50;
2144:
2145: -- Since the default line location has been populated,
2146: -- populate 'S' to line_loc_populated_flag
2147: UPDATE po_lines_interface
2148: SET line_loc_populated_flag = 'S'
2149: WHERE processing_id = PO_PDOI_PARAMS.g_processing_id
2150: AND NVL(line_loc_populated_flag, 'N') = 'N';
2151: