APPS.PO_LINE_LOCATIONS_PKG_S3 dependencies on STANDARD

Line 44: elsif ((X_shipment_type = 'STANDARD') OR

40: AND shipment_num = X_shipment_num
41: AND ((X_rowid is null) or
42: (X_rowid <> rowid)));
43:
44: elsif ((X_shipment_type = 'STANDARD') OR
45: (X_shipment_type = 'PLANNED')) then
46:
47:
48: /* This is checking the uniques for Purchase Order Shipments

Line 49: ** of STANDARD AND PLANNED POS */

45: (X_shipment_type = 'PLANNED')) then
46:
47:
48: /* This is checking the uniques for Purchase Order Shipments
49: ** of STANDARD AND PLANNED POS */
50:
51: SELECT 1
52: INTO dummy
53: FROM DUAL

Line 57: AND shipment_type in ('STANDARD','PLANNED')

53: FROM DUAL
54: WHERE not exists (SELECT 1
55: FROM po_line_locations
56: WHERE po_line_id = X_po_line_id
57: AND shipment_type in ('STANDARD','PLANNED')
58: AND shipment_num = X_shipment_num
59: AND ((X_rowid IS NULL)
60: OR (X_rowid <> rowid)));
61:

Line 158: if ((X_shipment_type = 'STANDARD') OR

154:
155: BEGIN
156: X_Progress := '010';
157:
158: if ((X_shipment_type = 'STANDARD') OR
159: (X_shipment_type = 'PLANNED')) then
160: SELECT nvl(max(shipment_num),0)
161: INTO X_max_shipment_num
162: FROM po_line_locations

Line 164: AND shipment_type IN ('STANDARD','PLANNED');

160: SELECT nvl(max(shipment_num),0)
161: INTO X_max_shipment_num
162: FROM po_line_locations
163: WHERE po_line_id = X_po_line_id
164: AND shipment_type IN ('STANDARD','PLANNED');
165:
166: elsif (X_shipment_type IN ('RFQ', 'QUOTATION')) then
167: SELECT nvl(max(shipment_num),0)
168: INTO X_max_shipment_num