eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.OKE_DELIVERABLE_UTILS_PKG

Source


1 package OKE_DELIVERABLE_UTILS_PKG AUTHID CURRENT_USER as
2 /* $Header: OKEDTSUS.pls 120.0 2005/05/25 17:55:05 appldev noship $ */
3 
4 /*
5  * Procedure Name:  Create_deliverable
6  * Usage:           To create a dummy deliverable for non-item
7  *                  based deliverable
8  * Parameters (IN):
9  *                  X_DELIVERABLE_NUM        Deliverable number
10  *                  X_SOURCE_CODE            Deliverable source
11  *                  X_SOURCE_HEADER_ID       Source header ID
12  *                  X_SOURCE_DELIVERABLE_ID  Source deliverable ID
13  *                  X_CURRENCY_CODE          Currency code
14  *
15  *           (OUT): X_DELIVERABLE_ID         Deliverable ID
16  */
17 
18 procedure CREATE_DELIVERABLE (
19   X_DELIVERABLE_NUM in VARCHAR2,
20   X_SOURCE_CODE in VARCHAR2,
21   X_SOURCE_HEADER_ID in NUMBER,
22   X_SOURCE_DELIVERABLE_ID in NUMBER,
23   X_CURRENCY_CODE in VARCHAR2,
24   X_DELIVERABLE_ID out NOCOPY NUMBER
25   );
26 
27 
28 /*
29  * Procedure Name:  Default_Ship_Deliverable
30  * Usage:           To get item-based deliverable information for shipping action
31  *
32  * Parameters (IN):
33  *                  X_SOURCE_CODE            Deliverable source
34  *                  X_SOURCE_HEADER_ID       Source header ID
35  *                  X_SOURCE_DELIVERABLE_ID  Source deliverable ID
36  *
37  *           (OUT): X_SHIP_FROM_ORG_ID       Ship from org ID
38  *                  X_SHIP_FROM_LOCATION_ID  Ship from location ID
39  *                  X_SHIP_FROM_ORG          Ship from org
40  *                  X_SHIP_FROM_LOCATION     Ship from location
41  *                  X_DELIVERABLE_ID         Deliverable ID
42  *                  X_QUANTITY               Quantity
43  *                  X_UOM                    Uom Code
44  */
45 
46 procedure DEFAULT_SHIP_DELIVERABLE (
47   X_SOURCE_CODE in VARCHAR2,
48   X_SOURCE_HEADER_ID in NUMBER,
49   X_SOURCE_DELIVERABLE_ID in NUMBER,
50   X_SHIP_FROM_ORG_ID out NOCOPY NUMBER,
51   X_SHIP_FROM_LOCATION_ID out NOCOPY NUMBER,
52   X_SHIP_FROM_ORG out NOCOPY VARCHAR2,
53   X_SHIP_FROM_LOCATION out NOCOPY VARCHAR2,
54   X_DELIVERABLE_ID out NOCOPY NUMBER,
55   X_QUANTITY out NOCOPY NUMBER,
56   X_UOM out NOCOPY VARCHAR2
57   );
58 
59 
60 /*
61  * Procedure Name:  Check_flag
62  * Usage:           To check the ready flag in action table
63  *                  for a deliverable
64  * Parameters (IN):
65  *                  X_DELIVERABLE_ID         Deliverable ID
66  *
67  *           (OUT): X_FLAG                   Ready flag
68  */
69 
70 procedure CHECK_FLAG (
71   X_DELIVERABLE_ID in NUMBER,
72   X_FLAG out NOCOPY VARCHAR2
73   );
74 
75 
76 /*
77  * Procedure Name:  Update_qty
78  * Usage:           To update the quantity in deliverable table
79  *                  for a non-item based deliverable
80  * Parameters (IN):
81  *                  X_QUANTITY               Quantity
82  *                  X_SOURCE_CODE            Deliverable source
83  *                  X_SOURCE_HEADER_ID       Source header ID
84  *                  X_SOURCE_DELIVERABLE_ID  Source deliverable ID
85  */
86 
87 procedure UPDATE_QTY (
88   X_QUANTITY in NUMBER,
89   X_SOURCE_CODE in VARCHAR2,
90   X_SOURCE_HEADER_ID in NUMBER,
91   X_SOURCE_DELIVERABLE_ID in NUMBER
92   );
93 
94 
95 /*
96  * Procedure Name:  Get_deliverable
97  * Usage:           To get deliverable information
98  * Parameters (IN):
99  *                  X_SOURCE_CODE            Deliverable source
100  *                  X_SOURCE_HEADER_ID       Source header ID
101  *                  X_SOURCE_DELIVERABLE_ID  Source deliverable ID
102  *
103  *           (OUT): X_DELIVERABLE_ID         Deliverable ID
104  *                  X_QUANTITY               Quantity
105  *                  X_UNIT_PRICE             Unit price
106  *                  X_UOM_CODE               Uom Code
107  *                  X_SHIP_TO_ORG_ID         Ship to org ID
108  *                  X_SHIP_TO_ORG            Ship to org
109  *                  X_CURRENCY_CODE          Currency code
110  */
111 
112 procedure GET_DELIVERABLE (
113   X_SOURCE_CODE in VARCHAR2,
114   X_SOURCE_HEADER_ID in NUMBER,
115   X_SOURCE_DELIVERABLE_ID in NUMBER,
116   X_DELIVERABLE_ID out NOCOPY NUMBER,
117   X_QUANTITY out NOCOPY NUMBER,
118   X_UNIT_PRICE out NOCOPY NUMBER,
119   X_UOM_CODE out NOCOPY VARCHAR2,
120   X_SHIP_TO_ORG_ID out NOCOPY NUMBER,
121   X_SHIP_TO_ORG out NOCOPY VARCHAR2,
122   X_CURRENCY_CODE out NOCOPY VARCHAR2
123   );
124 
125 
126 /*
127  * Procedure Name:  Get_deliverable_id
128  * Usage:           To get deliverable_id
129  * Parameters (IN):
130  *                  X_SOURCE_CODE            Deliverable source
131  *                  X_SOURCE_HEADER_ID       Source header ID
132  *                  X_SOURCE_DELIVERABLE_ID  Source deliverable ID
133  *
134  *           (OUT): X_DELIVERABLE_ID         Deliverable ID
135  *                  X_CURRENCY_CODE          Currency code
136  */
137 
138 procedure GET_DELIVERABLE_ID (
139   X_SOURCE_CODE in VARCHAR2,
140   X_SOURCE_HEADER_ID in NUMBER,
141   X_SOURCE_DELIVERABLE_ID in NUMBER,
142   X_DELIVERABLE_ID out NOCOPY NUMBER,
143   X_CURRENCY_CODE out NOCOPY VARCHAR2
144   );
145 
146 
147 
148 /*
149  * Procedure Name:  Check_action
150  * Usage:           To the existance of the action record
151  * Parameters (IN):
152  *                  X_X_SOURCE_CODE          Deliverable source
153  *                  X_SOURCE_HEADER_ID       Source header ID
154  *                  X_SOURCE_DELIVERABLE_ID  Source deliverable ID
155  *                  X_ACTION_TYPE            Action type
156  *
157  *           (OUT): X_flag                   Existance flag
158  */
159 
160 procedure CHECK_ACTION (
161   X_SOURCE_CODE in VARCHAR2,
162   X_SOURCE_HEADER_ID in NUMBER,
163   X_SOURCE_DELIVERABLE_ID in NUMBER,
164   X_ACTION_TYPE in VARCHAR2,
165   X_FLAG out NOCOPY VARCHAR2
166   );
167 
168 
169 /*
170  * Procedure Name:  Update_currency
171  * Usage:           To update the currency in deliverable table
172  *                  for a non-item based deliverable
173  * Parameters (IN):
174  *                  X_CURRENCY_CODE          Currency code
175  *                  X_SOURCE_CODE            Deliverable source
176  *                  X_SOURCE_HEADER_ID       Source header ID
177  *                  X_SOURCE_DELIVERABLE_ID  Source deliverable ID
178  */
179 
180 procedure UPDATE_CURRENCY (
181   X_CURRENCY_CODE in VARCHAR2,
182   X_SOURCE_CODE in VARCHAR2,
183   X_SOURCE_HEADER_ID in NUMBER,
184   X_SOURCE_DELIVERABLE_ID in NUMBER
185   );
186 
187 /*
188  * Procedure Name:  Update_price
189  * Usage:           To update the unit price in deliverable table
190  *                  for a non-item based deliverable
191  * Parameters (IN):
192  *                  X_UNIT_PRICE             Unit price
193  *                  X_SOURCE_CODE            Deliverable source
194  *                  X_SOURCE_HEADER_ID       Source header ID
195  *                  X_SOURCE_DELIVERABLE_ID  Source deliverable ID
196  */
197 
198 procedure UPDATE_PRICE (
199   X_UNIT_PRICE in NUMBER,
200   X_SOURCE_CODE in VARCHAR2,
201   X_SOURCE_HEADER_ID in NUMBER,
202   X_SOURCE_DELIVERABLE_ID in NUMBER
203   );
204 
205 /*
206  * Procedure Name:  Insert_Row
207  * Usage:           To insert a row in oke_deliverables_b
208  *
209  */
210 
211 procedure INSERT_ROW (
212   X_ROWID in out NOCOPY VARCHAR2,
213   X_DELIVERABLE_ID in NUMBER,
214   X_DELIVERABLE_NUMBER in VARCHAR2,
215   X_SOURCE_CODE in VARCHAR2,
216   X_UNIT_PRICE in NUMBER,
217   X_UOM_CODE in VARCHAR2,
218   X_QUANTITY in NUMBER,
219   X_UNIT_NUMBER in VARCHAR2,
220   X_ATTRIBUTE_CATEGORY in VARCHAR2,
221   X_ATTRIBUTE1 in VARCHAR2,
222   X_ATTRIBUTE2 in VARCHAR2,
223   X_ATTRIBUTE3 in VARCHAR2,
224   X_ATTRIBUTE4 in VARCHAR2,
225   X_ATTRIBUTE5 in VARCHAR2,
226   X_ATTRIBUTE6 in VARCHAR2,
227   X_ATTRIBUTE7 in VARCHAR2,
228   X_ATTRIBUTE8 in VARCHAR2,
229   X_ATTRIBUTE9 in VARCHAR2,
230   X_ATTRIBUTE10 in VARCHAR2,
231   X_ATTRIBUTE11 in VARCHAR2,
232   X_ATTRIBUTE12 in VARCHAR2,
233   X_ATTRIBUTE13 in VARCHAR2,
234   X_ATTRIBUTE14 in VARCHAR2,
235   X_ATTRIBUTE15 in VARCHAR2,
236   X_SOURCE_HEADER_ID in NUMBER,
237   X_SOURCE_LINE_ID in NUMBER,
238   X_SOURCE_DELIVERABLE_ID in NUMBER,
239   X_PROJECT_ID in NUMBER,
240   X_CURRENCY_CODE in VARCHAR2,
241   X_INVENTORY_ORG_ID in NUMBER,
242   X_DELIVERY_DATE in DATE,
243   X_ITEM_ID in NUMBER,
244   X_DESCRIPTION in VARCHAR2,
245   X_COMMENTS in VARCHAR2,
246   X_CREATION_DATE in DATE,
247   X_CREATED_BY in NUMBER,
248   X_LAST_UPDATE_DATE in DATE,
249   X_LAST_UPDATED_BY in NUMBER,
250   X_LAST_UPDATE_LOGIN in NUMBER);
251 
252 /*
253  * Procedure Name:  Update_Row
254  * Usage:           To update a row in oke_deliverables_b
255  *
256  */
257 
258 procedure UPDATE_ROW (
259   X_DELIVERABLE_ID in NUMBER,
260   X_DELIVERABLE_NUMBER in VARCHAR2,
261   X_SOURCE_CODE in VARCHAR2,
262   X_UNIT_PRICE in NUMBER,
263   X_UOM_CODE in VARCHAR2,
264   X_QUANTITY in NUMBER,
265   X_UNIT_NUMBER in VARCHAR2,
266   X_ATTRIBUTE_CATEGORY in VARCHAR2,
267   X_ATTRIBUTE1 in VARCHAR2,
268   X_ATTRIBUTE2 in VARCHAR2,
269   X_ATTRIBUTE3 in VARCHAR2,
270   X_ATTRIBUTE4 in VARCHAR2,
271   X_ATTRIBUTE5 in VARCHAR2,
272   X_ATTRIBUTE6 in VARCHAR2,
273   X_ATTRIBUTE7 in VARCHAR2,
274   X_ATTRIBUTE8 in VARCHAR2,
275   X_ATTRIBUTE9 in VARCHAR2,
276   X_ATTRIBUTE10 in VARCHAR2,
277   X_ATTRIBUTE11 in VARCHAR2,
278   X_ATTRIBUTE12 in VARCHAR2,
279   X_ATTRIBUTE13 in VARCHAR2,
280   X_ATTRIBUTE14 in VARCHAR2,
281   X_ATTRIBUTE15 in VARCHAR2,
282   X_SOURCE_HEADER_ID in NUMBER,
283   X_SOURCE_LINE_ID in NUMBER,
284   X_SOURCE_DELIVERABLE_ID in NUMBER,
285   X_PROJECT_ID in NUMBER,
286   X_CURRENCY_CODE in VARCHAR2,
287   X_INVENTORY_ORG_ID in NUMBER,
288   X_DELIVERY_DATE in DATE,
289   X_ITEM_ID in NUMBER,
290   X_DESCRIPTION in VARCHAR2,
291   X_COMMENTS in VARCHAR2,
292   X_LAST_UPDATE_DATE in DATE,
293   X_LAST_UPDATED_BY in NUMBER,
294   X_LAST_UPDATE_LOGIN in NUMBER
295 );
296 
297 /*
298  * Procedure Name:  Lock_Row
299  * Usage:           To lock a row in oke_deliverables_b
300  *
301  */
302 
303 procedure LOCK_ROW (
304   X_DELIVERABLE_ID in NUMBER,
305   X_DELIVERABLE_NUMBER in VARCHAR2,
306   X_SOURCE_CODE in VARCHAR2,
307   X_UNIT_PRICE in NUMBER,
308   X_UOM_CODE in VARCHAR2,
309   X_QUANTITY in NUMBER,
310   X_UNIT_NUMBER in VARCHAR2,
311   X_ATTRIBUTE_CATEGORY in VARCHAR2,
312   X_ATTRIBUTE1 in VARCHAR2,
313   X_ATTRIBUTE2 in VARCHAR2,
314   X_ATTRIBUTE3 in VARCHAR2,
315   X_ATTRIBUTE4 in VARCHAR2,
316   X_ATTRIBUTE5 in VARCHAR2,
317   X_ATTRIBUTE6 in VARCHAR2,
318   X_ATTRIBUTE7 in VARCHAR2,
319   X_ATTRIBUTE8 in VARCHAR2,
320   X_ATTRIBUTE9 in VARCHAR2,
321   X_ATTRIBUTE10 in VARCHAR2,
322   X_ATTRIBUTE11 in VARCHAR2,
323   X_ATTRIBUTE12 in VARCHAR2,
324   X_ATTRIBUTE13 in VARCHAR2,
325   X_ATTRIBUTE14 in VARCHAR2,
326   X_ATTRIBUTE15 in VARCHAR2,
327   X_SOURCE_HEADER_ID in NUMBER,
328   X_SOURCE_LINE_ID in NUMBER,
329   X_SOURCE_DELIVERABLE_ID in NUMBER,
330   X_PROJECT_ID in NUMBER,
331   X_CURRENCY_CODE in VARCHAR2,
332   X_INVENTORY_ORG_ID in NUMBER,
333   X_DELIVERY_DATE in DATE,
334   X_ITEM_ID in NUMBER,
335   X_DESCRIPTION in VARCHAR2,
336   X_COMMENTS in VARCHAR2
337 );
338 
339 /*
340  * Procedure Name:  Delete_Row
341  * Usage:           To delete a row in oke_deliverables_b
342  *
343  */
344 
345 procedure DELETE_ROW (
346   X_DELIVERABLE_ID in NUMBER
347 );
348 
349 /*
350  * Procedure Name:  Add_Language
351  * Usage:           Add rows to deliverable translated table
352  *
353  */
354 
355 procedure ADD_LANGUAGE;
356 
357 function Update_Expected_Date (
358   p_pa_action_id    in NUMBER,
359   p_expected_date  in DATE
360 ) return Varchar2;
361 
362 end OKE_DELIVERABLE_UTILS_PKG;