1196: NULL,
1197: X_JOB_ID,
1198: nvl(x_matching_basis, 'QUANTITY'),
1199: l_country_of_origin 1200: FROM dual; 1201:
1202:
1203: exception
1204: when others THEN
Line 1484: FROM sys.dual;
1480: /* Get the shipment Header id */
1481:
1482: SELECT rcv_shipment_headers_s.nextval
1483: INTO X_shipment_header_id 1484: FROM sys.dual; 1485:
1486:
1487: /* For every unique Org_id, Vendor_id combination,
1488: ** create a header */