APPS.PO_LINE_LOCATIONS_PKG_S3 dependencies on PO_LINE_LOCATIONS

Line 1: PACKAGE BODY PO_LINE_LOCATIONS_PKG_S3 as

1: PACKAGE BODY PO_LINE_LOCATIONS_PKG_S3 as
2: /* $Header: POXP4PSB.pls 115.4 2004/03/09 23:28:47 dreddy ship $ */
3:
4: /*========================================================================
5: ** PROCEDURE NAME : check_unique

Line 37: FROM po_line_locations

33: SELECT 1
34: INTO dummy
35: FROM DUAL
36: WHERE not exists (SELECT 1
37: FROM po_line_locations
38: WHERE po_release_id = X_po_release_id
39: AND shipment_type = X_shipment_type
40: AND shipment_num = X_shipment_num
41: AND ((X_rowid is null) or

Line 55: FROM po_line_locations

51: SELECT 1
52: INTO dummy
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)

Line 72: FROM po_line_locations

68: SELECT 1
69: INTO dummy
70: FROM DUAL
71: WHERE not exists (SELECT 1
72: FROM po_line_locations
73: WHERE po_line_id = X_po_line_id
74: AND shipment_type = X_shipment_type
75: AND shipment_num = X_shipment_num
76: AND ((X_rowid IS NULL)

Line 87: FROM po_line_locations

83: SELECT 1
84: INTO dummy
85: FROM DUAL
86: WHERE not exists (SELECT 1
87: FROM po_line_locations
88: WHERE po_line_id = X_po_line_id
89: AND shipment_type = 'PRICE BREAK'
90: AND shipment_num = X_shipment_num
91: AND ((X_rowid <> rowid)

Line 125: FROM po_line_locations

121: SELECT 1
122: INTO dummy
123: FROM DUAL
124: WHERE not exists (SELECT 1
125: FROM po_line_locations
126: WHERE po_line_id = X_po_line_id
127: AND shipment_type = X_shipment_type
128: AND shipment_num = X_shipment_num);
129:

Line 162: FROM po_line_locations

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
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

Line 169: FROM po_line_locations

165:
166: elsif (X_shipment_type IN ('RFQ', 'QUOTATION')) then
167: SELECT nvl(max(shipment_num),0)
168: INTO X_max_shipment_num
169: FROM po_line_locations
170: WHERE po_line_id = X_po_line_id
171: AND shipment_type = X_shipment_type;
172:
173: elsif (X_shipment_type = 'PRICE BREAK') then

Line 176: FROM po_line_locations

172:
173: elsif (X_shipment_type = 'PRICE BREAK') then
174: SELECT nvl(max(shipment_num),0)
175: INTO X_max_shipment_num
176: FROM po_line_locations
177: WHERE po_line_id = X_po_line_id
178: AND shipment_type = 'PRICE BREAK';
179:
180: elsif ((X_shipment_type = 'SCHEDULED') OR

Line 185: FROM po_line_locations

181: (X_shipment_type = 'BLANKET')) then
182:
183: SELECT nvl(max(shipment_num),0)
184: INTO X_max_shipment_num
185: FROM po_line_locations
186: WHERE po_release_id = X_po_release_id ;
187:
188: end if;
189:

Line 221: from po_line_locations

217: */
218:
219: select nvl(sum((nvl(quantity,0)-nvl(quantity_cancelled,0))*nvl(price_override,0)),0)
220: into X_rel_total
221: from po_line_locations
222: where po_release_id = X_po_release_id;
223:
224: return(X_rel_total);
225:

Line 234: END PO_LINE_LOCATIONS_PKG_S3;

230: -- po_message_s.sql_error('select_summary',X_Progress,sqlcode);
231: raise;
232: end select_summary;
233:
234: END PO_LINE_LOCATIONS_PKG_S3;