APPS.PO_PDOI_MAINPROC_PVT dependencies on PO_LINE_LOCATIONS_INTERFACE

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

460: );
461:
462: d_position := 50;
463:
464: -- delete all locations from po_line_locations_interface that are obsoleted
465: DELETE FROM po_line_locations_interface
466: WHERE process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_OBSOLETE
467: AND processing_id = PO_PDOI_PARAMS.g_processing_id;
468:

Line 465: DELETE FROM po_line_locations_interface

461:
462: d_position := 50;
463:
464: -- delete all locations from po_line_locations_interface that are obsoleted
465: DELETE FROM po_line_locations_interface
466: WHERE process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_OBSOLETE
467: AND processing_id = PO_PDOI_PARAMS.g_processing_id;
468:
469: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_LINE_PROCESS);

Line 1495: -- from po_line_locations_interface table

1491: --Locks:
1492: -- None
1493: --Function:
1494: -- handle the logic to derive, default, validate and insert records
1495: -- from po_line_locations_interface table
1496: --Parameters:
1497: --IN: None
1498: --IN OUT: None
1499: --OUT: None

Line 1672: -- update po_line_locations_interface with line_location_id

1668: );
1669:
1670: d_position := 80;
1671:
1672: -- update po_line_locations_interface with line_location_id
1673: PO_PDOI_LINE_LOC_PROCESS_PVT.update_line_loc_interface
1674: (
1675: p_intf_line_loc_id_tbl => l_line_locs.intf_line_loc_id_tbl,
1676: p_line_loc_id_tbl => l_line_locs.line_loc_id_tbl,