[Home] [Help]
PACKAGE: APPS.RCV_TRANSACTIONS_INTERFACE_SV
Source
1 PACKAGE RCV_TRANSACTIONS_INTERFACE_SV AS
2 /* $Header: RCVTISVS.pls 120.0.12000000.1 2007/01/16 23:32:46 appldev ship $*/
3
4 /* ksareddy - Porting changes by bao in branch for caching sob */
5 x_set_of_books_id NUMBER := NULL;
6
7
8 /*===========================================================================
9 PACKAGE NAME: rcv_transactions_interface_sv
10
11 DESCRIPTION: Contains the server side APIs high-level record types
12 and record type variables.
13
14 CLIENT/SERVER: Server
15
16 LIBRARY NAME NONE
17
18 OWNER: DFong
19
20 PROCEDURES/FUNCTIONS: create()
21
22 ===========================================================================*/
23
24 /*===========================================================================
25 PROCEDURE NAME: derive_shipment_line()
26
27 DESCRIPTION: Derives the rcv_transactions_interface row by first
28 getting id values and then retrieving rows from po_line_locations
29 until the quantity_shipped is consumed.
30
31 PARAMETERS:
32
33 DESIGN REFERENCES:
34
35 ALGORITHM:
36
37 NOTES:
38
39 OPEN ISSUES:
40
41 CLOSED ISSUES:
42
43 CHANGE HISTORY: DFong 09/24/96 Created
44 ===========================================================================*/
45 PROCEDURE derive_shipment_line (X_cascaded_table IN OUT NOCOPY rcv_shipment_object_sv.cascaded_trans_tab_type,
46 n IN OUT NOCOPY binary_integer,
47 temp_cascaded_table IN OUT NOCOPY rcv_shipment_object_sv.cascaded_trans_tab_type,
48 X_header_record IN rcv_shipment_header_sv.headerrectype);
49
50 /*===========================================================================
51 PROCEDURE NAME: default_shipment_line()
52
53 DESCRIPTION:
54
55 PARAMETERS:
56
57 DESIGN REFERENCES:
58
59 ALGORITHM:
60
61 NOTES:
62
63 OPEN ISSUES:
64
65 CLOSED ISSUES:
66
67 CHANGE HISTORY: DFong 09/24/96 Created
68 ===========================================================================*/
69 PROCEDURE default_shipment_line (X_cascaded_table IN OUT NOCOPY rcv_shipment_object_sv.cascaded_trans_tab_type,
70 n IN binary_integer,
71 X_header_id IN rcv_headers_interface.header_interface_id%type,
72 X_header_record IN rcv_shipment_header_sv.headerrectype);
73
74 /*===========================================================================
75 PROCEDURE NAME: validate_shipment_line()
76
77 DESCRIPTION:
78
79 PARAMETERS:
80
81 DESIGN REFERENCES:
82
83 ALGORITHM:
84
85 NOTES:
86
87 OPEN ISSUES:
88
89 CLOSED ISSUES:
90
91 CHANGE HISTORY: DFong 09/24/96 Created
92 ===========================================================================*/
93
94 PROCEDURE validate_shipment_line (X_cascaded_table IN OUT NOCOPY rcv_shipment_object_sv.cascaded_trans_tab_type,
95 n IN binary_integer,
96 X_asn_type IN rcv_headers_interface.asn_type%type,
97 X_header_record IN rcv_shipment_header_sv.headerrectype);
98
99 /*===========================================================================
100 PROCEDURE NAME: get_location_id()
101
102 DESCRIPTION:
103
104 PARAMETERS:
105
106 DESIGN REFERENCES:
107
108 ALGORITHM:
109
110 NOTES:
111
112 OPEN ISSUES:
113
114 CLOSED ISSUES:
115
116 CHANGE HISTORY: DFong 09/24/96 Created
117 ===========================================================================*/
118
119 PROCEDURE get_location_id (X_location_id_record IN OUT NOCOPY rcv_shipment_object_sv.location_id_record_type);
120
121 /*===========================================================================
122 PROCEDURE NAME: get_locator_id()
123
124 Bug 724495, add procedure get_locator_id to derive locator_id from locator
125
126 CHANGE HISTORY: NWang 09/3/98 Created
127 ===========================================================================*/
128
129 PROCEDURE get_locator_id (X_locator_id_record IN OUT NOCOPY rcv_shipment_line_sv.locator_id_record_type);
130
131 /*===========================================================================
132 PROCEDURE NAME: get_category_id()
133
134 DESCRIPTION:
135
136 PARAMETERS:
137
138 DESIGN REFERENCES:
139
140 ALGORITHM:
141
142 NOTES:
143
144 OPEN ISSUES:
145
146 CLOSED ISSUES:
147
148 CHANGE HISTORY: DFong 09/24/96 Created
149 ===========================================================================*/
150
151 -- PROCEDURE get_category_id (X_category_id_record IN rcv_shipment_line_sv.category_id_record_type);
152
153 /*===========================================================================
154 PROCEDURE NAME: get_routing_header_id()
155
156 DESCRIPTION:
157
158 PARAMETERS:
159
160 DESIGN REFERENCES:
161
162 ALGORITHM:
163
164 NOTES:
165
166 OPEN ISSUES:
167
168 CLOSED ISSUES:
169
170 CHANGE HISTORY: DFong 09/24/96 Created
171 ===========================================================================*/
172
173 PROCEDURE get_routing_header_id
174 (X_routing_header_id_record IN OUT NOCOPY rcv_shipment_line_sv.routing_header_id_rec_type);
175 /*===========================================================================
176 PROCEDURE NAME: get_routing_step_id()
177
178 DESCRIPTION:
179
180 PARAMETERS:
181
182 DESIGN REFERENCES:
183
184 ALGORITHM:
185
186 NOTES:
187
188 OPEN ISSUES:
189
190 CLOSED ISSUES:
191
192 CHANGE HISTORY: DFong 09/24/96 Created
193 ===========================================================================*/
194
195 PROCEDURE get_routing_step_id
196 (X_routing_step_id_record IN OUT NOCOPY rcv_shipment_line_sv.routing_step_id_rec_type);
197
198 /*===========================================================================
199 PROCEDURE NAME: get_reason_id()
200
201 DESCRIPTION:
202
203 PARAMETERS:
204
205 DESIGN REFERENCES:
206
207 ALGORITHM:
208
209 NOTES:
210
211 OPEN ISSUES:
212
213 CLOSED ISSUES:
214
215 CHANGE HISTORY: DFong 09/24/96 Created
216 ===========================================================================*/
217
218 PROCEDURE get_reason_id
219 (X_reason_id_record IN OUT NOCOPY rcv_shipment_line_sv.reason_id_record_type);
220
221 /*===========================================================================
222 PROCEDURE NAME: default_item_revision()
223
224 DESCRIPTION:
225
226 PARAMETERS:
227
228 DESIGN REFERENCES:
229
230 ALGORITHM:
231
232 NOTES:
233
234 OPEN ISSUES:
235
236 CLOSED ISSUES:
237
238 CHANGE HISTORY: DFong 09/24/96 Created
239 ===========================================================================*/
240
241 PROCEDURE default_item_revision
242 (x_item_revision_record IN OUT NOCOPY rcv_shipment_line_sv.item_id_record_type);
243
244 PROCEDURE check_date_tolerance (expected_receipt_date in date,
245 promised_date in date,
246 days_early_receipt_allowed in number,
247 days_late_receipt_allowed in number,
248 receipt_days_exception_code in out NOCOPY varchar2);
249
250 PROCEDURE check_shipto_enforcement (po_ship_to_location_id in number,
251 asn_ship_to_location_id in number,
252 enforce_ship_to_location_code in out NOCOPY varchar2);
253
254 PROCEDURE EXCHANGE_SUB_ITEM (V_cascaded_table IN OUT NOCOPY rcv_shipment_object_sv.cascaded_trans_tab_type,
255 n IN binary_integer);
256
257 FUNCTION convert_into_correct_qty(source_qty in number,
258 source_uom in varchar2,
259 item_id in number,
260 dest_uom in varchar2)
261 RETURN NUMBER;
262
263
264 /*===========================================================================
265 PROCEDURE NAME: get_po_header_id ()
266
267 DESCRIPTION: This procedure obtains the po_header_id
268 given the document number.
269
270 PARAMETERS: x_doc_num IN OUT VARCHAR2
271 x_header_id IN NUMBER
272
273 DESIGN REFERENCES:
274
275 ALGORITHM:
276
277 NOTES:
278
279 OPEN ISSUES:
280
281 CLOSED ISSUES:
282
283 CHANGE HISTORY: DFONG 12/6/96 Created
284 ===========================================================================*/
285 procedure get_po_header_id (X_po_header_id_record IN OUT NOCOPY rcv_shipment_line_sv.document_num_record_type);
286
287 /*===========================================================================
288 PROCEDURE NAME: get_item_id ()
289
290 DESCRIPTION:
291
292 PARAMETERS: X_item_id_record
293
294
295 DESIGN REFERENCES:
296
297 ALGORITHM:
298
299 NOTES:
300
301 OPEN ISSUES:
302
303 CLOSED ISSUES:
304
305 CHANGE HISTORY: DFONG 12/6/96 Created
306 ===========================================================================*/
307 -- moved here from POXPOLIB.pls to avoid compatibility issues with REL 11
308
309 PROCEDURE get_item_id(x_item_id_record IN OUT NOCOPY rcv_shipment_line_sv.item_id_record_type);
310
311 /*===========================================================================
312 PROCEDURE NAME: get_sub_item_id ()
313
314 DESCRIPTION:
315
316 PARAMETERS: X_sub_item_id_record
317
318
319 DESIGN REFERENCES:
320
321 ALGORITHM:
322
323 NOTES:
324
325 OPEN ISSUES:
326
327 CLOSED ISSUES:
328
329 CHANGE HISTORY: DFONG 12/6/96 Created
330 ===========================================================================*/
331
332 -- moved here from POXPOLIB.pls to avoid compatibility issues with REL 11
333
334 PROCEDURE get_sub_item_id(x_sub_item_id_record IN OUT NOCOPY rcv_shipment_line_sv.sub_item_id_record_type);
335
336 /*===========================================================================
337 PROCEDURE NAME: get_po_line_id ()
338
339 DESCRIPTION:
340
341 PARAMETERS: X_po_line_id_record
342
343
344 DESIGN REFERENCES:
345
346 ALGORITHM:
347
348 NOTES:
349
350 OPEN ISSUES:
351
352 CLOSED ISSUES:
353
354 CHANGE HISTORY: DFONG 12/6/96 Created
355 ===========================================================================*/
356
357 -- moved here from POXPOLIB.pls to avoid compatibility issues with REL 11
358
359 PROCEDURE get_po_line_id(x_po_line_id_record IN OUT NOCOPY rcv_shipment_line_sv.po_line_id_record_type);
360
361
362
363 -- API call done by EDI to obtain the org_id
364 PROCEDURE get_org_id_from_hr_loc_id (p_hr_location_id IN NUMBER, x_organization_id OUT NOCOPY NUMBER);
365
366 END RCV_TRANSACTIONS_INTERFACE_SV;