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.AHL_PRD_WORKORDER_PUB

Source


1 PACKAGE AHL_PRD_WORKORDER_PUB AUTHID CURRENT_USER AS
2  /* $Header: AHLPWOSS.pls 120.2.12020000.2 2012/12/10 16:37:32 prakkum ship $ */
3 /*#
4  * This is the public interface to fetch and update work order details
5  * details include operations/quality/parts change/resource transactions
6  * @rep:scope public
7  * @rep:product AHL
8  * @rep:displayname Maintenance Workorder
9  * @rep:lifecycle active
10  * @rep:category BUSINESS_ENTITY AHL_MAINT_WORKORDER
11  */
12 TYPE WORKORDER_REC_TYPE IS RECORD
13 (
14   Workorder_Id NUMBER,
15   Object_Version_Number NUMBER,
16   Wip_Entity_Id  NUMBER,
17   Batch_Id      NUMBER,
18   Header_Id     NUMBER,
19   Workorder_Number VARCHAR2(80),
20   Description VARCHAR2(240),
21   Status_Code VARCHAR2(30),
22   Status VARCHAR2(80),
23   Hold_Reason_Code VARCHAR2(30),
24   Hold_Reason VARCHAR2(80),
25   Priority_Code NUMBER,
26   Priority VARCHAR2(30),
27   Organization_Id NUMBER,
28   Organization_Code VARCHAR2(30),
29   Organization_Name VARCHAR2(240),
30   Department_Id NUMBER,
31   Department_Name VARCHAR2(240),
32   Department_Class_Code VARCHAR2(10),
33   Scheduled_Start_Date DATE,
34   Scheduled_End_Date DATE,
35   Actual_Start_Date DATE,
36   Actual_End_Date DATE,
37   Unit_Header_Id NUMBER,
38   Unit_Name VARCHAR2(80),
39   Workorder_Item_Number VARCHAR2(40),
40   INVENTORY_ITEM_ID                                  NUMBER,
41   ITEM_INSTANCE_ID                                   NUMBER,
42   Item_Instance_Number VARCHAR2(30),
43   Item_Description VARCHAR2(240),
44   Serial_Number VARCHAR2(30),
45   Lot_Number VARCHAR2(80),
46   Visit_Id NUMBER,
47   Visit_Number NUMBER,
48   Visit_Name   VARCHAR2(80),
49   Visit_Task_Id NUMBER,
50   Visit_Task_Number NUMBER,
51   Visit_Status_Code VARCHAR2(30),
52   Visit_Start_Date DATE,
53   Visit_End_Date DATE,
54   Mr_Header_Id NUMBER,
55   Mr_Title VARCHAR2(80),
56   Mr_RouteId NUMBER,
57   Route_Id NUMBER,
58   Route_Title VARCHAR2(2000),
59   Route_Number VARCHAR2(30),
60   Project_Id NUMBER,
61   Project_Name VARCHAR2(30),
62   Project_Task_Id NUMBER,
63   Project_Task_Name VARCHAR2(20),
64   Unit_Effectivity_Id NUMBER,
65   Non_Routine_Id NUMBER,--same as cs_incident_id
66   Non_Routine_Number VARCHAR2(64),
67   Completion_Subinventory VARCHAR2(10),
68   Completion_Locator_Id  NUMBER,
69   Completion_Locator_Name VARCHAR2(100),
70   Wip_Supply_Type VARCHAR2(100),
71   Wip_Supply_Meaning VARCHAR2(100),
72   Firm_Plan_Flag     VARCHAR2(1),
73   Master_WorkOrder_Flag VARCHAR2(1),
74   Confirm_Failure_Flag  VARCHAR2(1),
75   Origination_Task_Id NUMBER,
76   Wip_Accounting_Class_Code VARCHAR2(10),
77   Plan_Id NUMBER,
78   Collection_Id NUMBER,
79   Sub_Inventory VARCHAR2(10),
80   Locator_Id NUMBER,
81   PROPAGATE_FLAG                                     VARCHAR2(1),
82   SERVICE_ITEM_ID                                    NUMBER,
83   SERVICE_ITEM_ORG_ID                                NUMBER,
84   SERVICE_ITEM_DESCRIPTION                           VARCHAR2(240),
85   SERVICE_ITEM_NUMBER                                VARCHAR2(40),
86   SERVICE_ITEM_UOM                                   VARCHAR2(3),
87   QUANTITY                  NUMBER,
88   MRP_QUANTITY              NUMBER,
89   PARENT_ID                                          NUMBER,
90   TASK_MOTIVE_STATUS_ID                              NUMBER,
91   ALLOW_EXPLOSION                                    VARCHAR2(1),
92   UNCLOSE_WORKORDER_FLAG                             VARCHAR2(1),
93   LAST_UPDATE_LOGIN         NUMBER,
94   LAST_UPDATED_DATE         DATE,
95   LAST_UPDATED_BY           NUMBER,
96   CREATION_DATE             DATE,
97   CREATED_BY                NUMBER,
98   ATTRIBUTE_CATEGORY        VARCHAR2(30),
99   ATTRIBUTE1                VARCHAR2(150),
100   ATTRIBUTE2                VARCHAR2(150),
101   ATTRIBUTE3                VARCHAR2(150),
102   ATTRIBUTE4                VARCHAR2(150),
103   ATTRIBUTE5                VARCHAR2(150),
104   ATTRIBUTE6                VARCHAR2(150),
105   ATTRIBUTE7                VARCHAR2(150),
106   ATTRIBUTE8                VARCHAR2(150),
107   ATTRIBUTE9                VARCHAR2(150),
108   ATTRIBUTE10               VARCHAR2(150),
109   ATTRIBUTE11               VARCHAR2(150),
110   ATTRIBUTE12               VARCHAR2(150),
111   ATTRIBUTE13               VARCHAR2(150),
112   ATTRIBUTE14               VARCHAR2(150),
113   ATTRIBUTE15               VARCHAR2(150)
114  );
115 
116 
117 
118 TYPE MTL_REQMTS_REC_TYPE IS RECORD
119 (
120   Scheduled_Material_Id NUMBER,
121   Object_Version_Number NUMBER,
122   Workorder_Id NUMBER,
123   Operation_Sequence_Number NUMBER,
124   Workorder_Operation_Id NUMBER,
125   Inventory_Item_Id NUMBER,
126   Item_Number VARCHAR2(40),
127   Item_Description VARCHAR2(240),
128   Required_Quantity NUMBER,
129   Part_UOM_Code VARCHAR2(3),
130   Part_UOM VARCHAR2(30),
131   Required_Date DATE,
132   Scheduled_Quantity NUMBER,
133   Scheduled_Date DATE,
134   Issued_Quantity NUMBER,
135   LAST_UPDATED_DATE         DATE,
136   ATTRIBUTE_CATEGORY        VARCHAR2(30),
137   ATTRIBUTE1                VARCHAR2(150),
138   ATTRIBUTE2                VARCHAR2(150),
139   ATTRIBUTE3                VARCHAR2(150),
140   ATTRIBUTE4                VARCHAR2(150),
141   ATTRIBUTE5                VARCHAR2(150),
142   ATTRIBUTE6                VARCHAR2(150),
143   ATTRIBUTE7                VARCHAR2(150),
144   ATTRIBUTE8                VARCHAR2(150),
145   ATTRIBUTE9                VARCHAR2(150),
146   ATTRIBUTE10               VARCHAR2(150),
147   ATTRIBUTE11               VARCHAR2(150),
148   ATTRIBUTE12               VARCHAR2(150),
149   ATTRIBUTE13               VARCHAR2(150),
150   ATTRIBUTE14               VARCHAR2(150),
151   ATTRIBUTE15               VARCHAR2(150),
152   OPERATION_FLAG            VARCHAR2(1),
153   --sukhwsin: Added attributes for SB Effectivity - starts
154   MC_HEADER_ID		    NUMBER,
155   MC_NAME		    VARCHAR2(80),
156   MC_POSITION_KEY	    NUMBER,
157   MC_POSITION		    VARCHAR2(80),
158   ITEM_GROUP_ID		    NUMBER,
159   ITEM_GROUP_NAME	    VARCHAR2(80)
160   --sukhwsin: Added attributes for SB Effectivity - ends
161  );
162 
163 TYPE MTL_REQMTS_TBL_TYPE IS TABLE OF MTL_REQMTS_REC_TYPE INDEX BY BINARY_INTEGER;
164 
165 
166 
167 TYPE RES_TXNS_REC_TYPE IS RECORD
168 (
169 WORKORDER_ID            NUMBER,
170 WORKORDER_OPERATION_ID  NUMBER,
171 OPERATION_RESOURCE_ID   NUMBER,
172 ORGANIZATION_ID         NUMBER,
173 OPERATION_SEQUENCE_NUM  NUMBER,
174 RESOURCE_SEQUENCE_NUM   NUMBER,
175 RESOURCE_NAME           VARCHAR2(240),
176 RESOURCE_ID             NUMBER,
177 EMPLOYEE_NUM            VARCHAR2(30),
178 EMPLOYEE_NAME           VARCHAR2(240),
179 PERSON_ID               NUMBER,
180 DEPARTMENT_CODE         VARCHAR2(80),
181 DEPARTMENT_ID           NUMBER,
182 SERIAL_NUMBER           VARCHAR2(30),
183 INSTANCE_ID             NUMBER,
184 QTY                     NUMBER,
185 UOM_CODE                VARCHAR2(30),
186 UOM_MEANING             VARCHAR2(80),
187 ACTIVITY_MEANING        VARCHAR2(80),
188 ACTIVITY_ID             NUMBER,
189 REASON_ID               NUMBER,
190 REASON                  VARCHAR2(80),
191 REFERENCE               VARCHAR2(30),
192 DML_OPERATION           VARCHAR2(1),
193 RESOURCE_TYPE_CODE      VARCHAR2(30),
194 RESOURCE_TYPE_NAME      VARCHAR2(80),
195 DEPARTMENT_NAME         VARCHAR2(240),
196 TRANSACTION_DATE        DATE,
197 END_DATE                DATE
198  );
199 
200 TYPE RES_TXNS_TBL_TYPE IS TABLE OF RES_TXNS_REC_TYPE INDEX BY BINARY_INTEGER;
201 
202 
203 TYPE QA_PLAN_ATR_REC_TYPE IS RECORD
204 (
205    Char_Id NUMBER,
206    Prompt_Sequence NUMBER,
207    Prompt VARCHAR2(240),
208    Default_Value VARCHAR2(240),
209    Is_ListOfValue VARCHAR2(1),
210    Is_Displayed VARCHAR2(1),
211    Is_Mandatory VARCHAR2(1),
212    Is_ReadOnly  VARCHAR2(1),
213    Display_Length NUMBER,
214    DataType VARCHAR2(30)
215  );
216 
217 TYPE QA_PLAN_ATR_TBL_TYPE IS TABLE OF QA_PLAN_ATR_REC_TYPE INDEX BY BINARY_INTEGER;
218 
219 TYPE QA_PLAN_REC_TYPE IS RECORD
220 (
221     Plan_Id NUMBER,
222     Organization_Id NUMBER,
223     Plan_Name VARCHAR2(80),
224     Plan_Description VARCHAR2(240),
225     QA_PLAN_ATR_TBL QA_PLAN_ATR_TBL_TYPE
226 );
227 
228 TYPE QA_PLAN_ATRVAL_REC_TYPE IS RECORD
229 (
230    Char_Id NUMBER,
231    Attribute_Value VARCHAR2(4000)
232  );
233 
234 TYPE QA_PLAN_ATRVAL_TBL_TYPE IS TABLE OF QA_PLAN_ATRVAL_REC_TYPE INDEX BY BINARY_INTEGER;
235 
236 TYPE QA_RESULT_REC_TYPE IS RECORD
237 (
238     Occurence NUMBER,
239     QA_PLAN_ATRVAL_TBL QA_PLAN_ATRVAL_TBL_TYPE
240 );
241 
242 TYPE QA_RESULT_TBL_TYPE IS TABLE OF QA_RESULT_REC_TYPE INDEX BY BINARY_INTEGER;
243 
244 TYPE QA_RESULTS_REC_TYPE IS RECORD
245 (
246     Collection_Id NUMBER,
247     Plan_Id NUMBER,
248     QA_RESULT_TBL QA_RESULT_TBL_TYPE
249 );
250 
251 TYPE OPERATION_REC_TYPE IS RECORD
252 (
253   Workorder_Operation_Id NUMBER,
254   Object_Version_Number NUMBER,
255   Operation_Sequence_Number NUMBER,
256   Workorder_Id NUMBER,
257   Wip_Entity_Id NUMBER,
258   Route_Id     NUMBER,
259   Organization_Id NUMBER,
260   Operation_Id NUMBER,
261   Operation_Code VARCHAR2(500),
262   Description VARCHAR2(500),
263   Status_Code VARCHAR2(30),
264   Status VARCHAR2(80),
265   Operation_Type_Code VARCHAR2(40),
266   Operation_Type VARCHAR2(80),
267   Department_Id NUMBER,
268   Department_Name VARCHAR2(240),
269   Scheduled_Start_Date DATE,
270   Scheduled_End_Date DATE,
271   Actual_Start_Date DATE,
272   Actual_End_Date DATE,
273   Plan_Id        NUMBER,
274   Collection_Id  NUMBER,
275   LAST_UPDATE_LOGIN         NUMBER,
276   LAST_UPDATED_DATE         DATE,
277   LAST_UPDATED_BY           NUMBER,
278   CREATION_DATE             DATE,
279   CREATED_BY                NUMBER,
280   ATTRIBUTE_CATEGORY        VARCHAR2(30),
281   ATTRIBUTE1                VARCHAR2(150),
282   ATTRIBUTE2                VARCHAR2(150),
283   ATTRIBUTE3                VARCHAR2(150),
284   ATTRIBUTE4                VARCHAR2(150),
285   ATTRIBUTE5                VARCHAR2(150),
286   ATTRIBUTE6                VARCHAR2(150),
287   ATTRIBUTE7                VARCHAR2(150),
288   ATTRIBUTE8                VARCHAR2(150),
289   ATTRIBUTE9                VARCHAR2(150),
290   ATTRIBUTE10               VARCHAR2(150),
291   ATTRIBUTE11               VARCHAR2(150),
292   ATTRIBUTE12               VARCHAR2(150),
293   ATTRIBUTE13               VARCHAR2(150),
294   ATTRIBUTE14               VARCHAR2(150),
295   ATTRIBUTE15               VARCHAR2(150),
296   OPERATION_FLAG            VARCHAR2(1),
297   QAResults      QA_RESULTS_REC_TYPE
298  );
299 
300 TYPE OPERATIONS_TBL_TYPE IS TABLE OF OPERATION_REC_TYPE INDEX BY BINARY_INTEGER;
301 
302 TYPE RES_ASSIGNMENT_REC_TYPE IS RECORD
303 (
304   Assignment_Id  NUMBER,
305   Object_Version_Number NUMBER,
306   Workorder_Id   NUMBER,
307   Workorder_Operation_Id NUMBER,
308   Wip_Entity_Id NUMBER,
309   Organization_Id NUMBER,
310   Department_Id  NUMBER,
311   Department_Name VARCHAR2(240),
312   Operation_Sequence_Number NUMBER,
313   Resource_Sequence_Number NUMBER,
314   Operation_Resource_Id NUMBER,
315   Resource_Id NUMBER,
316   Resource_Code VARCHAR2(10),
317   Resource_Description VARCHAR2(240),
318   Resource_Type VARCHAR2(80),
319   Resource_Type_Code NUMBER,
320   Employee_Id NUMBER,
321   Employee_Number VARCHAR2(30),
322   Employee_Name VARCHAR2(240),
323   Serial_Number VARCHAR2(30),
324   Inventory_Item_Id NUMBER,
325   Item_Organization_Id NUMBER,
326   Instance_Id NUMBER,
327   Assignment_Start_Date DATE,
328   Assignment_End_Date DATE,
329   LAST_UPDATE_LOGIN         NUMBER,
330   LAST_UPDATED_DATE         DATE,
331   LAST_UPDATED_BY           NUMBER,
332   CREATION_DATE             DATE,
333   CREATED_BY                NUMBER,
334   ATTRIBUTE_CATEGORY        VARCHAR2(30),
335   ATTRIBUTE1                VARCHAR2(150),
336   ATTRIBUTE2                VARCHAR2(150),
337   ATTRIBUTE3                VARCHAR2(150),
338   ATTRIBUTE4                VARCHAR2(150),
339   ATTRIBUTE5                VARCHAR2(150),
340   ATTRIBUTE6                VARCHAR2(150),
341   ATTRIBUTE7                VARCHAR2(150),
342   ATTRIBUTE8                VARCHAR2(150),
343   ATTRIBUTE9                VARCHAR2(150),
344   ATTRIBUTE10               VARCHAR2(150),
345   ATTRIBUTE11               VARCHAR2(150),
346   ATTRIBUTE12               VARCHAR2(150),
347   ATTRIBUTE13               VARCHAR2(150),
348   ATTRIBUTE14               VARCHAR2(150),
349   ATTRIBUTE15               VARCHAR2(150),
350   OPERATION_FLAG            VARCHAR2(1)
351 );
352 
353 TYPE RES_ASSIGNMENTS_TBL_TYPE IS TABLE OF RES_ASSIGNMENT_REC_TYPE INDEX BY BINARY_INTEGER;
354 
355 TYPE RES_REQUIREMENT_REC_TYPE  IS RECORD (
356   Operation_Resource_Id     NUMBER,
357   Object_Version_Number NUMBER,
358   Resource_Sequence_Number NUMBER,
359   Operation_Sequence_Number NUMBER,
360   Workorder_Id   NUMBER,
361   Workorder_Number VARCHAR2(80),
362   Wip_Entity_Id NUMBER,
363   Workorder_Operation_Id NUMBER,
364   Organization_Id NUMBER,
365   Department_Id  NUMBER,
366   Department_Name VARCHAR2(240),
367   Resource_Type VARCHAR2(80),
368   Resource_Type_Code NUMBER,
369   Resource_Id NUMBER,
370   Resource_Code VARCHAR2(80),
371   Resource_Description VARCHAR2(240),
372   Operation_Start_Date DATE,
373   Operation_End_Date DATE,
374   Duration NUMBER,
375   Quantity NUMBER,
376   Set_Up    NUMBER,
377   UOM_Code  VARCHAR2(3),
378   UOM VARCHAR2(30),
379   Cost_Basis_Code NUMBER,
380   Cost_Basis_Name VARCHAR2(80),
381   Charge_Type_Code NUMBER,
382   Charge_Type_Name VARCHAR2(80),
383   Scheduled_Type_Code NUMBER,
384   Scheduled_Type_Name VARCHAR2(80),
385   Std_Rate_Flag_Code NUMBER,
386   Std_Rate_Flag_Name VARCHAR2(80),
387   Total_Required NUMBER,
388   Applied_Number NUMBER,
389   Open_Number    NUMBER,
390   Requirement_Start_Date  DATE,
391   Requirement_End_Date  DATE,
392   LAST_UPDATE_LOGIN         NUMBER,
393   LAST_UPDATED_DATE         DATE,
394   LAST_UPDATED_BY           NUMBER,
395   CREATION_DATE             DATE,
396   CREATED_BY                NUMBER,
397   ATTRIBUTE_CATEGORY        VARCHAR2(30),
398   ATTRIBUTE1                VARCHAR2(150),
399   ATTRIBUTE2                VARCHAR2(150),
400   ATTRIBUTE3                VARCHAR2(150),
401   ATTRIBUTE4                VARCHAR2(150),
402   ATTRIBUTE5                VARCHAR2(150),
403   ATTRIBUTE6                VARCHAR2(150),
404   ATTRIBUTE7                VARCHAR2(150),
405   ATTRIBUTE8                VARCHAR2(150),
406   ATTRIBUTE9                VARCHAR2(150),
407   ATTRIBUTE10               VARCHAR2(150),
408   ATTRIBUTE11               VARCHAR2(150),
409   ATTRIBUTE12               VARCHAR2(150),
410   ATTRIBUTE13               VARCHAR2(150),
411   ATTRIBUTE14               VARCHAR2(150),
412   ATTRIBUTE15               VARCHAR2(150),
413   OPERATION_FLAG            VARCHAR2(1)
414 );
415 
416 TYPE RES_REQUIREMENTS_TBL_TYPE IS TABLE OF RES_REQUIREMENT_REC_TYPE INDEX BY BINARY_INTEGER;
417 
418 
419 /*#
420  * Process Work Order Updates Work Order, Operations, Quality, Mtl Requirements, Resource Requirements/Assignments/Transactions
421  * @param p_api_version Api Version Number
422  * @param p_init_msg_list Initialize the message stack, default value FND_API.G_TRUE
423  * @param p_commit to decide whether to commit the transaction or not, default value FND_API.G_FALSE
424  * @param p_validation_level validation level, default value FND_API.G_VALID_LEVEL_FULL
425  * @param p_default Defaulting level, default value FND_API.G_FALSE
426  * @param p_module_type Module Type 'API','BPEL,'JSP'
427  * @param p_x_workorder_rec  Work Order Details,
428  * @param p_x_Operations      Operations Details and Operation Quality
429  * @param p_x_MaterialRequirements Material Requirements
430  * @param p_x_WO_QaResults    Work Order Quality
431  * @param p_x_ResourceRequirements    Resource Requirements
432  * @param p_x_ResourceAssignments    Resource Assignments
433  * @param p_x_ResourceTransactions    Resource Transactions
434  * @param x_return_status return status
435  * @param x_msg_count return message count
436  * @param x_msg_data return message data
437  * @rep:scope public
438  * @rep:lifecycle active
439  * @rep:displayname Process Work Order
440  */
441 PROCEDURE process_workorder
442 (
443  p_api_version             IN            NUMBER     := 1.0,
444  p_init_msg_list           IN            VARCHAR2   := FND_API.G_TRUE,
445  p_commit                  IN            VARCHAR2   := FND_API.G_FALSE,
446  p_validation_level        IN            NUMBER     := FND_API.G_VALID_LEVEL_FULL,
447  p_default                 IN            VARCHAR2   := FND_API.G_FALSE,
448  p_module_type             IN            VARCHAR2,
449  p_x_workorder_rec         IN OUT NOCOPY WORKORDER_REC_TYPE,
450  p_x_Operations            IN OUT NOCOPY OPERATIONS_TBL_TYPE,
451  p_x_MaterialRequirements  IN OUT NOCOPY MTL_REQMTS_TBL_TYPE,
452  p_x_WO_QaResults          IN OUT NOCOPY QA_RESULTS_REC_TYPE,
453  p_x_ResourceRequirements  IN OUT NOCOPY RES_REQUIREMENTS_TBL_TYPE,
454  p_x_ResourceAssignments   IN OUT NOCOPY RES_ASSIGNMENTS_TBL_TYPE,
455  p_x_ResourceTransactions  IN OUT NOCOPY RES_TXNS_TBL_TYPE,
456  x_return_status           OUT NOCOPY    VARCHAR2,
457  x_msg_count               OUT NOCOPY    NUMBER,
458  x_msg_data                OUT NOCOPY    VARCHAR2
459 );
460 END AHL_PRD_WORKORDER_PUB; -- Package spec