[Home] [Help]
PACKAGE: APPS.AHL_PRD_WORKORDER_PVT
Source
1 PACKAGE AHL_PRD_WORKORDER_PVT AS
2 /* $Header: AHLVPRJS.pls 120.2.12010000.2 2008/12/15 01:27:30 sracha ship $ */
3 TYPE PRD_WORKOPERATION_REC IS RECORD
4 (
5 WORKORDER_OPERATION_ID NUMBER,
6 ORGANIZATION_ID NUMBER,
7 OPERATION_SEQUENCE_NUM NUMBER,
8 OPERATION_DESCRIPTION VARCHAR2(500),
9 WORKORDER_ID NUMBER,
10 WIP_ENTITY_ID NUMBER,
11 ROUTE_ID NUMBER,
12 OBJECT_VERSION_NUMBER NUMBER,
13 LAST_UPDATE_DATE DATE ,
14 LAST_UPDATED_BY NUMBER,
15 CREATION_DATE DATE,
16 CREATED_BY NUMBER,
17 LAST_UPDATE_LOGIN NUMBER,
18 DEPARTMENT_ID NUMBER,
19 DEPARTMENT_NAME VARCHAR2(240),
20 STATUS_CODE VARCHAR2(30),
21 STATUS_MEANING VARCHAR2(80),
22 OPERATION_ID NUMBER,
23 OPERATION_CODE VARCHAR2(500),
24 OPERATION_TYPE_CODE VARCHAR2(30),
25 OPERATION_TYPE VARCHAR2(80),
26 REPLENISH VARCHAR2(1),
27 MINIMUM_TRANSFER_QUANTITY NUMBER,
28 COUNT_POINT_TYPE NUMBER,
29 SCHEDULED_START_DATE DATE,
30 SCHEDULED_START_HR NUMBER,
31 SCHEDULED_START_MI NUMBER,
32 SCHEDULED_END_DATE DATE,
33 SCHEDULED_END_HR NUMBER,
34 SCHEDULED_END_MI NUMBER,
35 ACTUAL_START_DATE DATE,
36 ACTUAL_START_HR NUMBER,
37 ACTUAL_START_MI NUMBER,
38 ACTUAL_END_DATE DATE,
39 ACTUAL_END_HR NUMBER,
40 ACTUAL_END_MI NUMBER,
41 PLAN_ID NUMBER,
42 COLLECTION_ID NUMBER,
43 PROPAGATE_FLAG VARCHAR2(1),
44 SECURITY_GROUP_ID NUMBER,
45 ATTRIBUTE_CATEGORY VARCHAR2(30),
46 ATTRIBUTE1 VARCHAR2(150),
47 ATTRIBUTE2 VARCHAR2(150),
48 ATTRIBUTE3 VARCHAR2(150),
49 ATTRIBUTE4 VARCHAR2(150),
50 ATTRIBUTE5 VARCHAR2(150),
51 ATTRIBUTE6 VARCHAR2(150),
52 ATTRIBUTE7 VARCHAR2(150),
53 ATTRIBUTE8 VARCHAR2(150),
54 ATTRIBUTE9 VARCHAR2(150),
55 ATTRIBUTE10 VARCHAR2(150),
56 ATTRIBUTE11 VARCHAR2(150),
57 ATTRIBUTE12 VARCHAR2(150),
58 ATTRIBUTE13 VARCHAR2(150),
59 ATTRIBUTE14 VARCHAR2(150),
60 ATTRIBUTE15 VARCHAR2(150),
61 DML_OPERATION VARCHAR2(1)
62 );
63
64 TYPE PRD_WORKOPER_TBL IS TABLE OF PRD_WORKOPERATION_REC INDEX BY BINARY_INTEGER;
65
66 TYPE PRD_WORKORDER_REC IS RECORD
67 (
68 BATCH_ID NUMBER,
69 HEADER_ID NUMBER,
70 WORKORDER_ID NUMBER,
71 WIP_ENTITY_ID NUMBER,
72 OBJECT_VERSION_NUMBER NUMBER,
73 JOB_NUMBER VARCHAR2(80),
74 JOB_DESCRIPTION VARCHAR2(240),
75 ORGANIZATION_ID NUMBER,
76 ORGANIZATION_NAME VARCHAR2(60),
77 ORGANIZATION_CODE VARCHAR2(10),
78 DEPARTMENT_NAME VARCHAR2(240),
79 DEPARTMENT_ID NUMBER,
80 DEPARTMENT_CLASS_CODE VARCHAR2(10),
81 STATUS_CODE VARCHAR2(30),
82 STATUS_MEANING VARCHAR2(80),
83 SCHEDULED_START_DATE DATE,
84 SCHEDULED_START_HR NUMBER,
85 SCHEDULED_START_MI NUMBER,
86 SCHEDULED_END_DATE DATE,
87 SCHEDULED_END_HR NUMBER,
88 SCHEDULED_END_MI NUMBER,
89 ACTUAL_START_DATE DATE,
90 ACTUAL_START_HR NUMBER,
91 ACTUAL_START_MI NUMBER,
92 ACTUAL_END_DATE DATE,
93 ACTUAL_END_HR NUMBER,
94 ACTUAL_END_MI NUMBER,
95 INVENTORY_ITEM_ID NUMBER,
96 ITEM_INSTANCE_ID NUMBER,
97 UNIT_NAME VARCHAR2(80),
98 ITEM_INSTANCE_NUMBER VARCHAR2(30),
99 WO_PART_NUMBER VARCHAR2(40),
100 ITEM_DESCRIPTION VARCHAR2(240),
101 SERIAL_NUMBER VARCHAR2(30),
102 ITEM_INSTANCE_UOM VARCHAR2(3),
103 COMPLETION_SUBINVENTORY VARCHAR2(10),
104 COMPLETION_LOCATOR_ID NUMBER,
105 COMPLETION_LOCATOR_NAME VARCHAR2(204),
106 WIP_SUPPLY_TYPE NUMBER,
107 WIP_SUPPLY_MEANING VARCHAR2(80),
108 FIRM_PLANNED_FLAG NUMBER,
109 MASTER_WORKORDER_FLAG VARCHAR2(1),
110 VISIT_ID NUMBER,
111 VISIT_NUMBER NUMBER,
112 VISIT_NAME VARCHAR2(80),
113 VISIT_TASK_ID NUMBER,
114 MR_HEADER_ID NUMBER,
115 VISIT_TASK_NUMBER NUMBER,
116 MR_TITLE VARCHAR2(80),
117 MR_ROUTE_ID NUMBER,
118 ROUTE_ID NUMBER,
119 CONFIRM_FAILURE_FLAG VARCHAR2(1),
120 PROPAGATE_FLAG VARCHAR2(1),
121 SERVICE_ITEM_ID NUMBER,
122 SERVICE_ITEM_ORG_ID NUMBER,
123 SERVICE_ITEM_DESCRIPTION VARCHAR2(240),
124 SERVICE_ITEM_NUMBER VARCHAR2(40),
125 SERVICE_ITEM_UOM VARCHAR2(3),
126 PROJECT_ID NUMBER,
127 PROJECT_TASK_ID NUMBER,
128 QUANTITY NUMBER,
129 MRP_QUANTITY NUMBER,
130 INCIDENT_ID NUMBER,
131 ORIGINATION_TASK_ID NUMBER,
132 PARENT_ID NUMBER,
133 TASK_MOTIVE_STATUS_ID NUMBER,
134 ALLOW_EXPLOSION VARCHAR2(1),
135 CLASS_CODE VARCHAR2(10),
136 JOB_PRIORITY NUMBER,
137 JOB_PRIORITY_MEANING VARCHAR2(30),
138 CONFIRMED_FAILURE_FLAG NUMBER,
139 UNIT_EFFECTIVITY_ID NUMBER,
140 PLAN_ID NUMBER,
141 COLLECTION_ID NUMBER,
142 SUB_INVENTORY VARCHAR2(10),
143 LOCATOR_ID NUMBER,
144 SECURITY_GROUP_ID NUMBER,
145 ATTRIBUTE_CATEGORY VARCHAR2(30),
146 ATTRIBUTE1 VARCHAR2(150),
147 ATTRIBUTE2 VARCHAR2(150),
148 ATTRIBUTE3 VARCHAR2(150),
149 ATTRIBUTE4 VARCHAR2(150),
150 ATTRIBUTE5 VARCHAR2(150),
151 ATTRIBUTE6 VARCHAR2(150),
152 ATTRIBUTE7 VARCHAR2(150),
153 ATTRIBUTE8 VARCHAR2(150),
154 ATTRIBUTE9 VARCHAR2(150),
155 ATTRIBUTE10 VARCHAR2(150),
156 ATTRIBUTE11 VARCHAR2(150),
157 ATTRIBUTE12 VARCHAR2(150),
158 ATTRIBUTE13 VARCHAR2(150),
159 ATTRIBUTE14 VARCHAR2(150),
160 ATTRIBUTE15 VARCHAR2(150),
161 LAST_UPDATE_DATE DATE,
162 LAST_UPDATED_BY NUMBER,
163 CREATION_DATE DATE,
164 CREATED_BY NUMBER,
165 LAST_UPDATE_LOGIN NUMBER,
166 DML_OPERATION VARCHAR2(1),
167 HOLD_REASON_CODE VARCHAR2(30),
168 HOLD_REASON VARCHAR2(80)
169 );
170
171 TYPE PRD_WORKORDER_TBL IS TABLE OF PRD_WORKORDER_REC INDEX BY BINARY_INTEGER;
172
173 TYPE PRD_WORKORDER_REL_REC IS RECORD
174 (
175 batch_id NUMBER,
176 wo_relationship_id NUMBER,
177 parent_header_id NUMBER,
178 parent_wip_entity_id NUMBER,
179 child_header_id NUMBER,
180 child_wip_entity_id NUMBER,
181 relationship_type NUMBER,
182 dml_operation VARCHAR2(1)
183 );
184
185 TYPE PRD_WORKORDER_REL_TBL IS TABLE OF PRD_WORKORDER_REL_REC INDEX BY BINARY_INTEGER;
186
187 PROCEDURE process_jobs
188 (
189 p_api_version IN NUMBER := 1.0,
190 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
191 p_commit IN VARCHAR2 := FND_API.G_FALSE,
192 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
193 p_default IN VARCHAR2 := FND_API.G_FALSE,
194 p_module_type IN VARCHAR2,
195 x_return_status OUT NOCOPY VARCHAR2,
196 x_msg_count OUT NOCOPY NUMBER,
197 x_msg_data OUT NOCOPY VARCHAR2,
198 p_x_prd_workorder_tbl IN OUT NOCOPY PRD_WORKORDER_TBL,
199 p_prd_workorder_rel_tbl IN PRD_WORKORDER_REL_TBL
200 );
201
202 PROCEDURE update_job
203 (
204 p_api_version IN NUMBER := 1.0,
205 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
206 p_commit IN VARCHAR2 := FND_API.G_FALSE,
207 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
208 p_default IN VARCHAR2 := FND_API.G_FALSE,
209 p_module_type IN VARCHAR2,
210 x_return_status OUT NOCOPY VARCHAR2,
211 x_msg_count OUT NOCOPY NUMBER,
212 x_msg_data OUT NOCOPY VARCHAR2,
213 p_wip_load_flag IN VARCHAR2 := 'Y',
214 p_x_prd_workorder_rec IN OUT NOCOPY PRD_WORKORDER_REC,
215 p_x_prd_workoper_tbl IN OUT NOCOPY PRD_WORKOPER_TBL
216 );
217
218 PROCEDURE release_visit_jobs
219 (
220 p_api_version IN NUMBER := 1.0,
221 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
222 p_commit IN VARCHAR2 := FND_API.G_FALSE,
223 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
224 p_default IN VARCHAR2 := FND_API.G_FALSE,
225 p_module_type IN VARCHAR2 := NULL,
226 x_return_status OUT NOCOPY VARCHAR2,
227 x_msg_count OUT NOCOPY NUMBER,
228 x_msg_data OUT NOCOPY VARCHAR2,
229 p_visit_id IN NUMBER,
230 p_unit_effectivity_id IN NUMBER,
231 p_workorder_id IN NUMBER
232 );
233
234 PROCEDURE cancel_visit_jobs
235 (
236 p_api_version IN NUMBER := 1.0,
237 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
238 p_commit IN VARCHAR2 := FND_API.G_FALSE,
239 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
240 p_default IN VARCHAR2 := FND_API.G_FALSE,
241 p_module_type IN VARCHAR2 := NULL,
242 x_return_status OUT NOCOPY VARCHAR2,
243 x_msg_count OUT NOCOPY NUMBER,
244 x_msg_data OUT NOCOPY VARCHAR2,
245 p_visit_id IN NUMBER,
246 p_unit_effectivity_id IN NUMBER,
247 p_workorder_id IN NUMBER
248 );
249
250 PROCEDURE validate_dependencies
251 (
252 p_api_version IN NUMBER := 1.0,
253 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
254 p_commit IN VARCHAR2 := FND_API.G_FALSE,
255 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
256 p_default IN VARCHAR2 := FND_API.G_FALSE,
257 p_module_type IN VARCHAR2 := NULL,
258 x_return_status OUT NOCOPY VARCHAR2,
259 x_msg_count OUT NOCOPY NUMBER,
260 x_msg_data OUT NOCOPY VARCHAR2,
261 p_visit_id IN NUMBER,
262 p_unit_effectivity_id IN NUMBER,
263 p_workorder_id IN NUMBER
264 );
265
266 PROCEDURE reschedule_visit_jobs
267 (
268 p_api_version IN NUMBER := 1.0 ,
269 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
270 p_commit IN VARCHAR2 := FND_API.G_FALSE,
271 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
272 p_default IN VARCHAR2 := FND_API.G_FALSE,
273 p_module_type IN VARCHAR2 := Null,
274 x_return_status OUT NOCOPY VARCHAR2,
275 x_msg_count OUT NOCOPY NUMBER,
276 x_msg_data OUT NOCOPY VARCHAR2,
277 p_visit_id IN NUMBER,
278 p_x_scheduled_start_date IN OUT NOCOPY DATE,
279 p_x_scheduled_end_date IN OUT NOCOPY DATE
280 );
281
282 TYPE TURNOVER_NOTES_REC_TYPE IS RECORD
283 (
284 jtf_note_id NUMBER,
285 source_object_id NUMBER,
286 source_object_code VARCHAR2(30),
287 notes VARCHAR2(2000),
288 employee_id NUMBER,--PERSON ID in PER_PEOPLE_F
289 employee_name VARCHAR2(240),--FULL_NAME in PER_PEOPLE_F
290 entered_date DATE,
291 org_id NUMBER
292 );
293
294 TYPE TURNOVER_NOTES_TBL_TYPE IS TABLE OF TURNOVER_NOTES_REC_TYPE INDEX BY BINARY_INTEGER;
295
296 PROCEDURE INSERT_TURNOVER_NOTES
297 (
298 p_api_version IN NUMBER := 1.0 ,
299 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
300 p_commit IN VARCHAR2 := FND_API.G_FALSE,
301 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
302 p_default IN VARCHAR2 := FND_API.G_FALSE,
303 p_module_type IN VARCHAR2 := Null,
304 x_return_status OUT NOCOPY VARCHAR2,
305 x_msg_count OUT NOCOPY NUMBER,
306 x_msg_data OUT NOCOPY VARCHAR2,
307 p_trunover_notes_tbl IN OUT NOCOPY AHL_PRD_WORKORDER_PVT.turnover_notes_tbl_type
308
309 );
310
311 END AHL_PRD_WORKORDER_PVT;