[Home] [Help]
PACKAGE: APPS.OKE_DELIVERABLE_UTILS_PUB
Source
1 PACKAGE OKE_DELIVERABLE_UTILS_PUB AS
2 /* $Header: OKEPDUTS.pls 120.0 2005/05/25 17:52:22 appldev noship $ */
3
4 --
5 -- Name : MDS_Initiated_Yn
6 -- Pre-reqs : N/A
7 -- Function : This function returns result to indicate whether certain
8 -- Action has been executed
9 --
10 --
11 -- Parameters :
12 -- IN : P_Action_ID Deliverable action ID
13 -- OUT : None
14 --
15 -- Returns : VARCHAR2
16 --
17
18 FUNCTION MDS_Initiated_Yn ( P_Action_ID NUMBER ) RETURN VARCHAR2;
19
20 --
21 -- Name : WSH_Initiated_Yn
22 -- Pre-reqs : N/A
23 -- Function : This function returns result to indicate whether shipping
24 -- Action has been executed
25 --
26 --
27 -- Parameters :
28 -- IN : P_Action_ID Deliverable action ID
29 -- OUT : None
30 --
31 -- Returns : VARCHAR2
32 --
33
34 FUNCTION WSH_Initiated_Yn ( P_Action_ID NUMBER ) RETURN VARCHAR2;
35
36 --
37 -- Name : REQ_Initiated_Yn
38 -- Pre-reqs : N/A
39 -- Function : This function returns result to indicate whether procure
40 -- Action has been executed
41 --
42 --
43 -- Parameters :
44 -- IN : P_Action_ID Deliverable action ID
45 -- OUT : None
46 --
47 -- Returns : VARCHAR2
48 --
49
50 FUNCTION REQ_Initiated_Yn ( P_Action_ID NUMBER ) RETURN VARCHAR2;
51
52 --
53 -- Name : Item_Defined_Yn
54 -- Pre-reqs : N/A
55 -- Function : This function returns result to indicate whether item
56 -- has been defined for the action
57 --
58 --
59 -- Parameters :
60 -- IN : P_Action_ID Deliverable action ID
61 -- OUT : None
62 --
63 -- Returns : VARCHAR2
64 --
65
66 FUNCTION Item_Defined_Yn ( P_Deliverable_ID NUMBER ) RETURN VARCHAR2;
67
68
69 --
70 -- Name : Item_Exist_Yn
71 -- Pre-reqs : N/A
72 -- Function : This function returns result to indicate whether item
73 -- has been created for the deliverable
74 --
75 --
76 -- Parameters :
77 -- IN : P_Deliverable_ID PA Deliverable Version ID
78 -- OUT : None
79 --
80 -- Returns : VARCHAR2
81 --
82
83 FUNCTION Item_Exist_Yn ( P_Deliverable_ID NUMBER ) RETURN VARCHAR2;
84
85 --
86 -- Name : Ready_To_Ship_Yn
87 -- Pre-reqs : N/A
88 -- Function : This function returns result to indicate whether ready_to_ship
89 -- has been checked for the action
90 --
91 --
92 -- Parameters :
93 -- IN : P_Action_ID Deliverable action ID
94 -- OUT : None
95 --
96 -- Returns : VARCHAR2
97 --
98
99 FUNCTION Ready_To_Ship_Yn ( P_Action_ID NUMBER ) RETURN VARCHAR2;
100
101 --
102 -- Name : Ready_To_Procure_Yn
103 -- Pre-reqs : N/A
104 -- Function : This function returns result to indicate whether ready_to_procure
105 -- has been checked for the action
106 --
107 --
108 -- Parameters :
109 -- IN : P_Action_ID Deliverable action ID
110 -- OUT : None
111 --
112 -- Returns : VARCHAR2
113 --
114
115 FUNCTION Ready_To_Procure_Yn ( P_Action_ID NUMBER ) RETURN VARCHAR2;
116
117 --
118 -- Name : Item_Shippable_Yn
119 -- Pre-reqs : N/A
120 -- Function : This function returns result to indicate whether item
121 -- is shippable
122 --
123 --
124 -- Parameters :
125 -- IN : P_Deliverable_ID Deliverable ID
126 -- OUT : None
127 --
128 -- Returns : VARCHAR2
129 --
130
131 FUNCTION Item_Shippable_Yn ( P_Deliverable_ID NUMBER ) RETURN VARCHAR2;
132
133
134 --
135 -- Name : Item_Billable_Yn
136 -- Pre-reqs : N/A
137 -- Function : This function returns result to indicate whether item
138 -- is billable
139 --
140 --
141 -- Parameters :
142 -- IN : P_Deliverable_ID Deliverable ID
143 -- OUT : None
144 --
145 -- Returns : VARCHAR2
146 --
147
148 FUNCTION Item_Billable_Yn ( P_Deliverable_ID NUMBER ) RETURN VARCHAR2;
149
150 --
151 -- Name : Item_Purchasable_Yn
152 -- Pre-reqs : N/A
153 -- Function : This function returns result to indicate whether item
154 -- is purchasable
155 --
156 --
157 -- Parameters :
158 -- IN : P_Deliverable_ID Deliverable ID
159 -- OUT : None
160 --
161 -- Returns : VARCHAR2
162 --
163
164 FUNCTION Item_Purchasable_Yn ( P_Deliverable_ID NUMBER ) RETURN VARCHAR2;
165
166 --
167 -- Name : Action_Deletable_Yn
168 -- Pre-reqs : N/A
169 -- Function : This function returns result to indicate whether action
170 -- is deletable
171 --
172 --
173 -- Parameters :
174 -- IN : P_Action_ID Action ID
175 -- OUT : None
176 --
177 -- Returns : VARCHAR2
178 --
179
180 FUNCTION Action_Deletable_Yn ( P_Action_ID NUMBER ) RETURN VARCHAR2;
181
182 --
183 -- Name : Copy_Item
184 -- Pre-reqs : N/A
185 -- Function : This procedure copies item info between deliverables
186 --
187 --
188 -- Parameters :
189 -- IN : SOURCE_PROJECT_ID
190 -- IN : TARGET_PROJECT_ID
191 -- IN : SOURCE_DELIVERABLE_ID
192 -- IN : TARGET_DELIVERABLE_ID
193 -- IN : TARGET_DELIVERABLE_NUMBER
194 -- IN : P_COPY_ITEM_DETAILS_FLAG
195 -- OUT : X_RETURN_STATUS
196 -- OUT : X_MSG_COUNT
197 -- OUT : X_MSG_DATA
198 --
199 -- Returns : N/A
200 --
201 PROCEDURE Copy_Item ( P_Source_Project_ID NUMBER
202 , P_Target_Project_ID NUMBER
203 , P_Source_Deliverable_ID NUMBER
204 , P_Target_Deliverable_ID NUMBER
205 , P_Target_Deliverable_Number VARCHAR2
206 , P_Copy_Item_Details_Flag VARCHAR2
207 , X_Return_Status OUT NOCOPY VARCHAR2
208 , X_Msg_Count OUT NOCOPY NUMBER
209 , X_Msg_Data OUT NOCOPY VARCHAR2 );
210 --
211 -- Name : Copy_Action
212 -- Pre-reqs : N/A
213 -- Function : This procedure copies action info between deliverables
214 --
215 --
216 -- Parameters :
217 -- IN : SOURCE_PROJECT_ID
218 -- IN : TARGET_PROJECT_ID
219 -- IN : SOURCE_DELIVERABLE_ID
220 -- IN : TARGET_DELIVERABLE_ID
221 -- IN : SOURCE_ACTION_ID
222 -- IN : TARGET_ACTION_ID
223 -- IN : TARGET_ACTION_NAME
224 -- OUT : X_RETURN_STATUS
225 -- OUT : X_MSG_COUNT
226 -- OUT : X_MSG_DATA
227 --
228 -- Returns : N/A
229 --
230 PROCEDURE Copy_Action ( P_Source_Project_ID NUMBER
231 , P_Target_Project_ID NUMBER
232 , P_Source_Deliverable_ID NUMBER
233 , P_Target_Deliverable_ID NUMBER
234 , P_Source_Action_ID NUMBER
235 , P_Target_Action_ID NUMBER
236 , P_Target_Action_Name VARCHAR2
237 , P_Target_Action_Date DATE
238 , X_Return_Status OUT NOCOPY VARCHAR2
239 , X_Msg_Count OUT NOCOPY NUMBER
240 , X_Msg_Data OUT NOCOPY VARCHAR2);
241
242 FUNCTION Unit_Price ( P_Item_ID NUMBER, P_Org_ID NUMBER )
243 RETURN NUMBER;
244
245
246 FUNCTION Currency_Code ( P_Item_ID NUMBER, P_Org_ID NUMBER )
247 RETURN VARCHAR2;
248
249 --
250 -- Name : Delete_Deliverable
251 -- Pre-reqs : N/A
252 -- Function : This procedure delete deliverable based on id
253 --
254 --
255 -- Parameters :
256 -- IN : P_DELIVERABLE_ID
257 -- OUT : X_RETURN_STATUS
258 -- OUT : X_MSG_COUNT
259 -- OUT : X_MSG_DATA
260 --
261 -- Returns : N/A
262 --
263
264 PROCEDURE Delete_Deliverable ( P_Deliverable_ID NUMBER
265 , X_Return_Status OUT NOCOPY VARCHAR2
266 , X_Msg_Count OUT NOCOPY NUMBER
267 , X_Msg_Data OUT NOCOPY VARCHAR2 );
268
269
270 --
271 -- Name : Delete_Action
272 -- Pre-reqs : N/A
273 -- Function : This procedure delete action based on action_id
274 --
275 --
276 -- Parameters :
277 -- IN : P_ACTION_ID - PA_ACTION_ID
278 -- OUT : X_RETURN_STATUS
279 -- OUT : X_MSG_COUNT
280 -- OUT : X_MSG_DATA
281 --
282 -- Returns : N/A
283 --
284
285 PROCEDURE Delete_Action ( P_Action_ID NUMBER
286 , X_Return_Status OUT NOCOPY VARCHAR2
287 , X_Msg_Count OUT NOCOPY NUMBER
288 , X_Msg_Data OUT NOCOPY VARCHAR2 );
289
290
291 --
292 -- Name : Delete_Demand
293 -- Pre-reqs : N/A
294 -- Function : This procedure delete Demand for shipping
295 -- action based on action_id (not Pa_Action_Id)
296 -- if it was initiated
297 -- Parameters :
298 -- IN : P_ACTION_ID - OKE Action_ID for Shipping action
299 -- OUT : X_RETURN_STATUS
300 -- OUT : X_MSG_COUNT
301 -- OUT : X_MSG_DATA
302 --
303 -- Returns : N/A
304 --
305
306 PROCEDURE Delete_Demand ( P_Action_ID NUMBER
307 , X_Return_Status OUT NOCOPY VARCHAR2
308 , X_Msg_Count OUT NOCOPY NUMBER
309 , X_Msg_Data OUT NOCOPY VARCHAR2 );
310
311 --
312 -- Name : WSH_Initiated_Yn
313 -- Pre-reqs : N/A
314 -- Function : Batch initiate demand for deliverables not initiated
315 -- demand.
316 -- If no project specified, batch all eligible, else
317 -- batch within the project. If task is specified for the
318 -- project, batch within the task.
319 --
320 --
321 -- Parameters :
322 -- IN : P_Action_ID Deliverable action ID
323 -- OUT : None
324 --
325 -- Returns : VARCHAR2
326 --
327 PROCEDURE Batch_MDS ( P_Project_ID NUMBER
328 , P_Task_ID NUMBER
329 , P_Init_Msg_List VARCHAR2
330 , X_Return_Status OUT NOCOPY VARCHAR2
331 , X_Msg_Count OUT NOCOPY NUMBER
332 , X_Msg_Data OUT NOCOPY VARCHAR2 );
333
334 --
335 -- Name : Batch_Wsh
336 -- Pre-reqs : N/A
337 -- Function : Batch initiate requisition for deliverables not initiated
338 -- shipmentt.
339 -- If no project specified, batch all eligible, else
340 -- batch within the project. If task is specified for the
341 -- project, batch within the task
342 --
343 --
344 -- Parameters :
345 -- IN :
346 -- OUT :
347 --
348 -- Returns :
349 --
350 PROCEDURE Batch_WSH ( P_Project_ID NUMBER
351 , P_Task_ID NUMBER
352 , P_Init_Msg_List VARCHAR2
353 , X_Return_Status OUT NOCOPY VARCHAR2
354 , X_Msg_Count OUT NOCOPY NUMBER
355 , X_Msg_Data OUT NOCOPY VARCHAR2 );
356
357 --
358 -- Name : Batch_Req
359 -- Pre-reqs : N/A
360 -- Function : Batch initiate requisition for new deliverables and those
361 -- had initiated requisition previously but failed in req
362 -- import. If no project specified, batch all eligible, else
363 -- batch within the project. If task is specified, batch
364 -- within the task
365 --
366 -- Parameters :
367 -- IN :
368 --
369 -- OUT :
370 --
371 -- Returns : VARCHAR2
372 --
373 PROCEDURE Batch_REQ ( P_Project_ID NUMBER
374 , P_Task_ID NUMBER
375 , P_Init_Msg_List VARCHAR2
376 , X_Return_Status OUT NOCOPY VARCHAR2
377 , X_Msg_Count OUT NOCOPY NUMBER
378 , X_Msg_Data OUT NOCOPY VARCHAR2 );
379
380 --
381 -- Name : Default_Action
382 -- Pre-reqs : N/A
383 -- Function : Default dummy actions when source actions
384 -- are defaulted
385 --
386 -- Parameters :
387 -- IN : P_Source_Code 'PA' for Projects
388 -- : P_Action_Type 'REQ' for Requisition
389 -- 'WSH' for Shipping
390 -- 'MDS' for Demand
391 -- : P_Source_Action_Name
392 -- : P_Source_Deliverable_ID
393 -- : P_Source_Action_ID
394 --
395 -- OUT :
396 --
397 -- Returns : VARCHAR2
398 --
399 PROCEDURE Default_Action ( P_Source_Code VARCHAR2
400 , P_Action_Type VARCHAR2
401 , P_Source_Action_Name VARCHAR2
402 , P_Source_Deliverable_ID NUMBER
403 , P_Source_Action_ID NUMBER
404 , P_Action_Date DATE );
405
406 FUNCTION Task_Used_In_Wsh ( P_Task_ID NUMBER ) RETURN VARCHAR2;
407
408 FUNCTION Task_Used_In_Req ( P_Task_ID NUMBER ) RETURN VARCHAR2;
409
410
411 END;