[Home] [Help]
PACKAGE: APPS.PO_LINES_SV4
Source
1 PACKAGE PO_LINES_SV4 AUTHID CURRENT_USER as
2 /* $Header: POXPOL4S.pls 115.10 2003/10/24 06:03:11 pthapliy ship $ */
3
4 FUNCTION get_line_num -- <GA FPI>
5 ( p_po_line_id PO_LINES_ALL.po_line_id%TYPE
6 ) RETURN PO_LINES_ALL.line_num%TYPE;
7
8 FUNCTION is_cumulative_pricing -- <GA FPI>
9 ( p_po_line_id PO_LINES_ALL.po_line_id%TYPE
10 ) RETURN BOOLEAN;
11
12 FUNCTION effective_dates_exist -- <GA FPI>
13 ( p_po_line_id PO_LINES_ALL.po_line_id%TYPE
14 ) RETURN BOOLEAN;
15
16 FUNCTION allow_price_override -- <2716528>
17 ( p_po_line_id PO_LINES_ALL.po_line_id%TYPE
18 ) RETURN BOOLEAN;
19
20 /*===========================================================================
21 PROCEDURE NAME: get_ship_dist_num()
22
23 DESCRIPTION: This procedure gets the no. of shipments and distributions
24 associated with a line. In addition it also gets the
25 promised date, need-by date and the charge account that
26 have been rolled up from these entities to the line.
27
28 PARAMETERS:
29
30 DESIGN REFERENCES:
31
32 ALGORITHM:
33
34 NOTES:
35
36 OPEN ISSUES:
37
38 CLOSED ISSUES:
39
40 CHANGE HISTORY: Created 08/08/95 SIYER
41 ===========================================================================*/
42 procedure get_ship_dist_num(X_po_line_id IN NUMBER,
43 X_num_of_ship IN OUT NOCOPY NUMBER,
44 --< NBD TZ/Timestamp FPJ Start >
45 --X_promised_date IN OUT NOCOPY VARCHAR2,
46 --X_need_by IN OUT NOCOPY VARCHAR2,
47 X_promised_date IN OUT NOCOPY DATE,
48 X_need_by IN OUT NOCOPY DATE,
49 --< NBD TZ/Timestamp FPJ End >
50 X_num_of_dist IN OUT NOCOPY NUMBER,
51 X_code_combination_id IN OUT NOCOPY NUMBER);
52
53
54 /*===========================================================================
55 FUNCTION NAME: get_encumbered_quantity
56
57 DESCRIPTION: Gets the total encumbered quantity for a Standard
58 or Planned purchase order line.
59
60 PARAMETERS: X_po_line_id IN NUMBER,
61 X_encumbered_quantity RETURN NUMBER
62
63 DESIGN REFERENCES:
64
65
66 ALGORITHM:
67
68 NOTES:
69
70 OPEN ISSUES:
71
72 CLOSED ISSUES:
73
74 CHANGE HISTORY: WLAU 11/1 Created
75
76 ===========================================================================*/
77
78 FUNCTION get_encumbered_quantity (X_po_line_id IN NUMBER)
79 RETURN NUMBER;
80
81
82 /*===========================================================================
83 FUNCTION NAME: get_receipt_required_flag
84
85 DESCRIPTION: Gets the receipt_required_flag for a purchase order line.
86
87
88 PARAMETERS: X_line_type_id IN NUMBER,
89 X_item_id IN NUMBER,
90 X_inventory_ord_id IN NUMBER,
91
92 X_receipt_required_flag RETURN VARCHAR2
93
94 DESIGN REFERENCES:
95
96
97 ALGORITHM:
98
99 NOTES:
100
101 OPEN ISSUES:
102
103 CLOSED ISSUES:
104
105 CHANGE HISTORY: WLAU 11/1 Created
106
107 ===========================================================================*/
108
109 FUNCTION get_receipt_required_flag (X_line_type_id IN NUMBER,
110 X_item_id IN NUMBER,
111 X_inventory_org_id IN NUMBER)
112 RETURN VARCHAR2;
113
114
115 /*===========================================================================
116 PROCEDURE NAME: get_ship_dist_info()
117
118 DESCRIPTION: This procedure gets the total of shipments quantity_received
119 and quantity_billed for a Standard/Planned PO line.
120 In addition it also gets the encumbered_flag from shipments,
121 online_req_flag, prevent_price_update_flag from distributions.
122
123
124 PARAMETERS: X_po_line_id IN NUMBER,
125 X_quantity_received IN OUT NUMBER,
126 X_quantity_billed IN OUT NUMBER,
127 X_encumbered_flag IN OUT VARCHAR2,
128 X_prevent_price_update_flag IN OUT VARCHAR2,
129 X_online_req_flag IN OUT VARCHAR2
130
131 DESIGN REFERENCES:
132
133 ALGORITHM:
134
135 NOTES:
136
137 OPEN ISSUES:
138
139 CLOSED ISSUES:
140
141 CHANGE HISTORY: WLAU 11/01/95 Created
142 SIYER 02/15/96 Added more params
143 ===========================================================================*/
144 procedure get_ship_quantity_info(X_po_line_id IN NUMBER,
145 X_expense_accrual_code IN VARCHAR2,
146 X_po_header_id IN NUMBER,
147 X_type_lookup_code IN VARCHAR2,
148 X_quantity_received IN OUT NOCOPY NUMBER,
149 X_quantity_billed IN OUT NOCOPY NUMBER,
150 X_encumbered_flag IN OUT NOCOPY VARCHAR2,
151 X_prevent_price_update_flag IN OUT NOCOPY VARCHAR2,
152 X_online_req_flag IN OUT NOCOPY VARCHAR2,
153 X_quantity_released IN OUT NOCOPY NUMBER,
154 X_amount_released IN OUT NOCOPY NUMBER);
155
156
157 /*===========================================================================
158 PROCEDURE NAME: get_quotation_info()
159
160 DESCRIPTION: This procedure gets the quotation details information
161 that are related to a purchase order line.
162
163 PARAMETERS: X_from_header_id IN NUMBER,
164 X_from_line_id IN NUMBER,
165 X_quotation_number IN OUT VARCHAR2,
166 X_quotation_line IN OUT NUMBER,
167 X_quotation_type IN OUT VARCHAR2,
168 X_vendor_quotation_number IN OUT VARCHAR2.
169
170 DESIGN REFERENCES:
171
172 ALGORITHM:
173
174 NOTES:
175
176 OPEN ISSUES:
177
178 CLOSED ISSUES:
179
180 CHANGE HISTORY: WLAU 11/01/95 Created
181 SIYER 3/29/96 Removed the from_type_lookup_code
182 parameter.
183 ===========================================================================*/
184 procedure get_quotation_info (X_from_header_id IN NUMBER,
185 X_from_line_id IN NUMBER,
186 X_quotation_number IN OUT NOCOPY VARCHAR2,
187 X_quotation_line IN OUT NOCOPY NUMBER,
188 X_quotation_type IN OUT NOCOPY VARCHAR2,
189 X_vendor_quotation_number IN OUT NOCOPY VARCHAR2,
190 x_quote_terms_id IN OUT NOCOPY NUMBER,
191 x_quote_ship_via_lookup_code IN OUT NOCOPY VARCHAR2,
192 x_quote_fob_lookup_code IN OUT NOCOPY VARCHAR2,
193 x_quote_freight_terms IN OUT NOCOPY VARCHAR2);
194
195
196 /*===========================================================================
197 PROCEDURE NAME: get_lookup_code_dsp ()
198
199 DESCRIPTION: This procedure gets the po lookup codes displayed value.
200
201 PARAMETERS: X_lookup_type IN VARCHAR2,
202 X_lookup_code IN VARCHAR2,
203 X_displayed_field IN OUT VARCHAR2
204
205
206 DESIGN REFERENCES:
207
208 ALGORITHM:
209
210 NOTES:
211
212 OPEN ISSUES:
213
214 CLOSED ISSUES:
215
216 CHANGE HISTORY: WLAU 11/06/95 Created
217 ===========================================================================*/
218 procedure get_lookup_code_dsp (X_lookup_type IN VARCHAR2,
219 X_lookup_code IN VARCHAR2,
220 X_displayed_field IN OUT NOCOPY VARCHAR2);
221
222 /*===========================================================================
223 PROCEDURE NAME: online_req ()
224
225 DESCRIPTION:
226
227 PARAMETERS: X_po_line_id
228
229
230 DESIGN REFERENCES:
231
232 ALGORITHM:
233
234 NOTES:
235
236 OPEN ISSUES:
237
238 CLOSED ISSUES:
239
240 CHANGE HISTORY: CMOK 04/1/96 Created
241 ===========================================================================*/
242
243 FUNCTION online_req(x_po_line_id IN NUMBER) return BOOLEAN;
244
245 /*===========================================================================
246 PROCEDURE NAME: get_item_id ()
247
248 DESCRIPTION:
249
250 PARAMETERS: X_item_id_record
251
252
253 DESIGN REFERENCES:
254
255 ALGORITHM:
256
257 NOTES:
258
259 OPEN ISSUES:
260
261 CLOSED ISSUES:
262
263 CHANGE HISTORY: DFONG 12/6/96 Created
264 ===========================================================================*/
265 -- moved this to RCVTISVS.pls
266
267 /* PROCEDURE get_item_id(x_item_id_record IN OUT rcv_shipment_line_sv.item_id_record_type); */
268
269 /*===========================================================================
270 PROCEDURE NAME: get_sub_item_id ()
271
272 DESCRIPTION:
273
274 PARAMETERS: X_sub_item_id_record
275
276
277 DESIGN REFERENCES:
278
279 ALGORITHM:
280
281 NOTES:
282
283 OPEN ISSUES:
284
285 CLOSED ISSUES:
286
287 CHANGE HISTORY: DFONG 12/6/96 Created
288 ===========================================================================*/
289
290 -- moved this to RCVTISVS.pls
291
292 /* PROCEDURE get_sub_item_id(x_sub_item_id_record IN OUT rcv_shipment_line_sv.sub_item_id_record_type); */
293
294 /*===========================================================================
295 PROCEDURE NAME: get_po_line_id ()
296
297 DESCRIPTION:
298
299 PARAMETERS: X_po_line_id_record
300
301
302 DESIGN REFERENCES:
303
304 ALGORITHM:
305
306 NOTES:
307
308 OPEN ISSUES:
309
310 CLOSED ISSUES:
311
312 CHANGE HISTORY: DFONG 12/6/96 Created
313 ===========================================================================*/
314
315 -- Moved this to RCVTISVS.pls
316
317 /* PROCEDURE get_po_line_id(x_po_line_id_record IN OUT rcv_shipment_line_sv.po_line_id_record_type); */
318
319 /*===========================================================================
320 PROCEDURE NAME: get_oke_contract_header_info ()
321
322 DESCRIPTION: This procedure gets the oke_header_num to display in the form.
323
324 PARAMETERS: X_oke_contract_header_id IN NUMBER
325 X_oke_contract_num IN OUT VARCHAR2
326
327 DESIGN REFERENCES:
328
329 ALGORITHM:
330
331 NOTES: Called by po_lines_sv5.post_query(); file POXPOL5B.pls
332
333 OPEN ISSUES:
334
335 CLOSED ISSUES:
336
337 CHANGE HISTORY: togeorge 10/03/2000 Created
338 ===========================================================================*/
339 PROCEDURE get_oke_contract_header_info(
340 X_oke_contract_header_id IN NUMBER,
341 X_oke_contract_num IN OUT NOCOPY VARCHAR2
342 );
343
344 --Bug# 1625462
345 --togeorge 01/30/2001
346 --Now displaying translated values for uom.
347 procedure get_unit_meas_lookup_code_tl(
348 X_unit_meas_lookup_code IN VARCHAR2,
349 X_unit_meas_lookup_code_tl IN OUT NOCOPY VARCHAR2
350 );
351
352 --Bug# 1751180
353 --togeorge 04/27/2001
354 --This procedure would select the translated uom using uom_code since om stores uom_code unlike units_of_measure as po.
355 procedure get_om_uom_tl(
356 X_uom_code IN VARCHAR2,
357 X_unit_meas_lookup_code_tl IN OUT NOCOPY VARCHAR2
358 );
359
360 END PO_LINES_SV4;