APPS.PO_PDOI_PREPROC_PVT dependencies on PO_LINE_LOCATIONS_INTERFACE

Line 454: UPDATE po_line_locations_interface

450: END IF;
451:
452: d_position := 50;
453: FORALL i IN 1..l_intf_line_id_tbl.COUNT
454: UPDATE po_line_locations_interface
455: SET processing_id = PO_PDOI_PARAMS.g_processing_id
456: WHERE interface_line_id = l_intf_line_id_tbl(i);
457:
458: IF (PO_LOG.d_stmt) THEN

Line 1913: FROM po_line_locations_interface PLLI,

1909: -- lines interface records.
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';

Line 1947: INSERT INTO po_line_locations_interface

1943: l_rowid_tbl.COUNT);
1944: END IF;
1945:
1946: FORALL i IN 1..l_rowid_tbl.COUNT
1947: INSERT INTO po_line_locations_interface
1948: (
1949: interface_line_location_id,
1950: interface_header_id,
1951: interface_line_id,

Line 2028: SELECT po_line_locations_interface_s.nextval,

2024: tax_code_id,
2025: tax_name,
2026: qty_rcv_tolerance
2027: )
2028: SELECT po_line_locations_interface_s.nextval,
2029: PLI.interface_header_id,
2030: PLI.interface_line_id,
2031: PLI.processing_id,
2032: PLI.process_code,