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 61: from po_line_locations_all pll,

57: pll.line_location_id,
58: pll.quantity_shipped,
59: pll.ship_to_organization_id, /* Added for 10243209 */
60: pll.quantity_cancelled
61: from po_line_locations_all pll,
62: po_lines_all pl,
63: mtl_parameters mp
64: where pll.secondary_unit_of_measure is not null
65: AND pll.po_header_id = pll.po_header_id

Line 146: UPDATE po_line_locations_all

142: OPEN cr_new_org(cr_rec.ship_to_organization_id) ;
143: FETCH cr_new_org into l_migrated_org_id ;
144: CLOSE cr_new_org ;
145:
146: UPDATE po_line_locations_all
147: SET secondary_quantity_shipped = nvl(l_secondary_quantity_shipped,secondary_quantity_shipped),
148: secondary_quantity_cancelled = nvl(l_secondary_quantity_cancelled,secondary_quantity_cancelled),
149: ship_to_organization_id = nvl(l_migrated_org_id, ship_to_organization_id) /* 10243209 */
150: WHERE CURRENT OF cr_shipments;

Line 161: 'SECONDARY_QUANTITY_SHIPPED','PO_LINE_LOCATIONS_ALL',

157: column_name,table_name,error_message,
158: creation_date,last_update_date)
159: values ('CONVERGENCE',cr_rec.po_header_id,cr_rec.po_line_id,cr_rec.line_location_id,
160: NULL, NULL, NULL,
161: 'SECONDARY_QUANTITY_SHIPPED','PO_LINE_LOCATIONS_ALL',
162: 'ERROR DERIVING SECONDARY QUANTITY SHIPPED FROM QUANTITY SHIPPED',sysdate,sysdate);
163: END;
164: END LOOP;
165: Commit;