[Home] [Help]
PACKAGE: APPS.OKE_DELIVERABLE_UTILS_PKG
Source
1 package OKE_DELIVERABLE_UTILS_PKG 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;