APPS.PO_PDOI_LINE_PROCESS_PVT dependencies on PO_LINE_LOCATIONS

Line 3065: UPDATE po_line_locations_interface

3061: d_position := 30;
3062:
3063: -- obsolete the location lines that have been marked
3064: FORALL i IN 1..l_obsoleted_loc_tbl.COUNT
3065: UPDATE po_line_locations_interface
3066: SET process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_OBSOLETE
3067: WHERE interface_line_id = l_obsoleted_loc_tbl(i);
3068:
3069: /*

Line 3374: FROM po_line_locations

3370: AND txn_lines.unit_meas_lookup_code IS NOT NULL
3371: AND txn_lines.unit_meas_lookup_code <>
3372: x_lines.unit_of_measure_tbl(i)
3373: AND (EXISTS (SELECT 1
3374: FROM po_line_locations
3375: WHERE po_line_id = txn_lines.po_line_id
3376: AND shipment_type = 'BLANKET')
3377: OR
3378: EXISTS (SELECT 1

Line 5710: -- to group the po lines and po line locations.

5706: --Name: match_lines_on_line_num
5707: --Function:
5708: -- If header action is 'ORIGINAL', 'REPLACE' or
5709: -- 'UPDATE SPO', this procedure will be called
5710: -- to group the po lines and po line locations.
5711: -- The first criteria used is line_num
5712: --Parameters:
5713: --IN:
5714: -- p_index_tbl

Line 5859: -- po lines and po line locations.

5855: --Name: match_lines_on_item_info
5856: --Function:
5857: -- If header action is 'ORIGINAL', or 'REPLACE',
5858: -- this procedure will be called to group the
5859: -- po lines and po line locations.
5860: -- this procedure match the lines based on
5861: -- item related info.
5862: --Parameters:
5863: --IN: