APPS.PO_PDOI_LINE_PROCESS_PVT dependencies on PO_LINE_LOCATIONS

Line 3961: UPDATE po_line_locations_interface

3957: d_position := 30;
3958:
3959: -- obsolete the location lines that have been marked
3960: FORALL i IN 1..l_obsoleted_loc_tbl.COUNT
3961: UPDATE po_line_locations_interface
3962: SET process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_OBSOLETE
3963: WHERE interface_line_id = l_obsoleted_loc_tbl(i);
3964:
3965: /*

Line 4273: FROM po_line_locations

4269: AND txn_lines.unit_meas_lookup_code IS NOT NULL
4270: AND txn_lines.unit_meas_lookup_code <>
4271: x_lines.unit_of_measure_tbl(i)
4272: AND (EXISTS (SELECT 1
4273: FROM po_line_locations
4274: WHERE po_line_id = txn_lines.po_line_id
4275: AND shipment_type = 'BLANKET')
4276: OR
4277: EXISTS (SELECT 1

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

6628: --Name: match_lines_on_line_num
6629: --Function:
6630: -- If header action is 'ORIGINAL', 'REPLACE' or
6631: -- 'UPDATE SPO', this procedure will be called
6632: -- to group the po lines and po line locations.
6633: -- The first criteria used is line_num
6634: --Parameters:
6635: --IN:
6636: -- p_index_tbl

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

6780: --Name: match_lines_on_item_info
6781: --Function:
6782: -- If header action is 'ORIGINAL', or 'REPLACE',
6783: -- this procedure will be called to group the
6784: -- po lines and po line locations.
6785: -- this procedure match the lines based on
6786: -- item related info.
6787: --Parameters:
6788: --IN: