APPS.PO_GML_CONV_MIG dependencies on PO_LINE_LOCATIONS_ALL

Line 35: -- and secondary_quantity_shipped in PO_LINE_LOCATIONS_ALL by converting

31: -- update_po_shipment
32: --
33: -- DESCRIPTION:
34: -- This PL/SQL procedure is used to Update secondary_quantity_shipped
35: -- and secondary_quantity_shipped in PO_LINE_LOCATIONS_ALL by converting
36: -- respective transaction quantities.
37: -- PARAMETERS:
38: -- None
39: --

Line 58: from po_line_locations_all pll,

54: pll.po_line_id,
55: pll.line_location_id,
56: pll.quantity_shipped,
57: pll.quantity_cancelled
58: from po_line_locations_all pll,
59: po_lines_all pl,
60: mtl_parameters mp
61: where pll.secondary_unit_of_measure is not null
62: AND pll.po_header_id = pll.po_header_id

Line 121: UPDATE po_line_locations_all

117: raise po_shipment_data_err;
118: End If;
119: END IF;
120:
121: UPDATE po_line_locations_all
122: SET secondary_quantity_shipped = nvl(l_secondary_quantity_shipped,secondary_quantity_shipped),
123: secondary_quantity_cancelled = nvl(l_secondary_quantity_cancelled,secondary_quantity_cancelled)
124: WHERE CURRENT OF cr_shipments;
125:

Line 135: 'SECONDARY_QUANTITY_SHIPPED','PO_LINE_LOCATIONS_ALL',

131: column_name,table_name,error_message,
132: creation_date,last_update_date)
133: values ('CONVERGENCE',cr_rec.po_header_id,cr_rec.po_line_id,cr_rec.line_location_id,
134: NULL, NULL, NULL,
135: 'SECONDARY_QUANTITY_SHIPPED','PO_LINE_LOCATIONS_ALL',
136: 'ERROR DERIVING SECONDARY QUANTITY SHIPPED FROM QUANTITY SHIPPED',sysdate,sysdate);
137: END;
138: END LOOP;
139: Commit;