APPS.PO_PDOI_MAINPROC_PVT dependencies on PO_LINE_LOCATIONS_INTERFACE

Line 597: -- delete all locations from po_line_locations_interface that are obsoleted

593: gather_stats('PO_LINES_DRAFT_ALL',d_api_name,d_position);
594: END IF;
595: --Bug13343886
596:
597: -- delete all locations from po_line_locations_interface that are obsoleted
598: DELETE FROM po_line_locations_interface
599: WHERE process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_OBSOLETE
600: AND processing_id = PO_PDOI_PARAMS.g_processing_id;
601:

Line 598: DELETE FROM po_line_locations_interface

594: END IF;
595: --Bug13343886
596:
597: -- delete all locations from po_line_locations_interface that are obsoleted
598: DELETE FROM po_line_locations_interface
599: WHERE process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_OBSOLETE
600: AND processing_id = PO_PDOI_PARAMS.g_processing_id;
601:
602: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_LINE_PROCESS);

Line 1658: -- from po_line_locations_interface table

1654: --Locks:
1655: -- None
1656: --Function:
1657: -- handle the logic to derive, default, validate and insert records
1658: -- from po_line_locations_interface table
1659: --Parameters:
1660: --IN: None
1661: --IN OUT: None
1662: --OUT: None

Line 1835: -- update po_line_locations_interface with line_location_id

1831: );
1832:
1833: d_position := 80;
1834:
1835: -- update po_line_locations_interface with line_location_id
1836: PO_PDOI_LINE_LOC_PROCESS_PVT.update_line_loc_interface
1837: (
1838: p_intf_line_loc_id_tbl => l_line_locs.intf_line_loc_id_tbl,
1839: p_line_loc_id_tbl => l_line_locs.line_loc_id_tbl,