[Home] [Help]
PACKAGE BODY: APPS.WIP_SHOPFLOORMOVE_UTIL
Source
1 PACKAGE BODY WIP_Shopfloormove_Util AS
2 /* $Header: WIPUSFMB.pls 115.13 2003/10/06 20:40:29 kboonyap ship $ */
3
4 -- Global constant holding the package name
5
6 G_PKG_NAME CONSTANT VARCHAR2(30) := 'WIP_Shopfloormove_Util';
7
8
9 -- Function Complete_Record
10
11 FUNCTION Complete_Record
12 ( p_ShopFloorMove_rec IN WIP_Transaction_PUB.Shopfloormove_Rec_Type
13 , p_old_ShopFloorMove_rec IN WIP_Transaction_PUB.Shopfloormove_Rec_Type
14 ) RETURN WIP_Transaction_PUB.Shopfloormove_Rec_Type
15 IS
16 l_ShopFloorMove_rec WIP_Transaction_PUB.Shopfloormove_Rec_Type := p_ShopFloorMove_rec;
17 BEGIN
18
19 IF l_ShopFloorMove_rec.acct_period_id = FND_API.G_MISS_NUM THEN
20 l_ShopFloorMove_rec.acct_period_id := p_old_ShopFloorMove_rec.acct_period_id;
21 END IF;
22
23 IF l_ShopFloorMove_rec.attribute1 = FND_API.G_MISS_CHAR THEN
24 l_ShopFloorMove_rec.attribute1 := p_old_ShopFloorMove_rec.attribute1;
25 END IF;
26
27 IF l_ShopFloorMove_rec.attribute10 = FND_API.G_MISS_CHAR THEN
28 l_ShopFloorMove_rec.attribute10 := p_old_ShopFloorMove_rec.attribute10;
29 END IF;
30
31 IF l_ShopFloorMove_rec.attribute11 = FND_API.G_MISS_CHAR THEN
32 l_ShopFloorMove_rec.attribute11 := p_old_ShopFloorMove_rec.attribute11;
33 END IF;
34
35 IF l_ShopFloorMove_rec.attribute12 = FND_API.G_MISS_CHAR THEN
36 l_ShopFloorMove_rec.attribute12 := p_old_ShopFloorMove_rec.attribute12;
37 END IF;
38
39 IF l_ShopFloorMove_rec.attribute13 = FND_API.G_MISS_CHAR THEN
40 l_ShopFloorMove_rec.attribute13 := p_old_ShopFloorMove_rec.attribute13;
41 END IF;
42
43 IF l_ShopFloorMove_rec.attribute14 = FND_API.G_MISS_CHAR THEN
44 l_ShopFloorMove_rec.attribute14 := p_old_ShopFloorMove_rec.attribute14;
45 END IF;
46
47 IF l_ShopFloorMove_rec.attribute15 = FND_API.G_MISS_CHAR THEN
48 l_ShopFloorMove_rec.attribute15 := p_old_ShopFloorMove_rec.attribute15;
49 END IF;
50
51 IF l_ShopFloorMove_rec.attribute2 = FND_API.G_MISS_CHAR THEN
52 l_ShopFloorMove_rec.attribute2 := p_old_ShopFloorMove_rec.attribute2;
53 END IF;
54
55 IF l_ShopFloorMove_rec.attribute3 = FND_API.G_MISS_CHAR THEN
56 l_ShopFloorMove_rec.attribute3 := p_old_ShopFloorMove_rec.attribute3;
57 END IF;
58
59 IF l_ShopFloorMove_rec.attribute4 = FND_API.G_MISS_CHAR THEN
60 l_ShopFloorMove_rec.attribute4 := p_old_ShopFloorMove_rec.attribute4;
61 END IF;
62
63 IF l_ShopFloorMove_rec.attribute5 = FND_API.G_MISS_CHAR THEN
64 l_ShopFloorMove_rec.attribute5 := p_old_ShopFloorMove_rec.attribute5;
65 END IF;
66
67 IF l_ShopFloorMove_rec.attribute6 = FND_API.G_MISS_CHAR THEN
68 l_ShopFloorMove_rec.attribute6 := p_old_ShopFloorMove_rec.attribute6;
69 END IF;
70
71 IF l_ShopFloorMove_rec.attribute7 = FND_API.G_MISS_CHAR THEN
72 l_ShopFloorMove_rec.attribute7 := p_old_ShopFloorMove_rec.attribute7;
73 END IF;
74
75 IF l_ShopFloorMove_rec.attribute8 = FND_API.G_MISS_CHAR THEN
76 l_ShopFloorMove_rec.attribute8 := p_old_ShopFloorMove_rec.attribute8;
77 END IF;
78
79 IF l_ShopFloorMove_rec.attribute9 = FND_API.G_MISS_CHAR THEN
80 l_ShopFloorMove_rec.attribute9 := p_old_ShopFloorMove_rec.attribute9;
81 END IF;
82
83 IF l_ShopFloorMove_rec.attribute_category = FND_API.G_MISS_CHAR THEN
84 l_ShopFloorMove_rec.attribute_category := p_old_ShopFloorMove_rec.attribute_category;
85 END IF;
86
87 IF l_ShopFloorMove_rec.created_by = FND_API.G_MISS_NUM THEN
88 l_ShopFloorMove_rec.created_by := p_old_ShopFloorMove_rec.created_by;
89 END IF;
90
91 IF l_ShopFloorMove_rec.created_by_name = FND_API.G_MISS_CHAR THEN
92 l_ShopFloorMove_rec.created_by_name := p_old_ShopFloorMove_rec.created_by_name;
93 END IF;
94
95 IF l_ShopFloorMove_rec.creation_date = FND_API.G_MISS_DATE THEN
96 l_ShopFloorMove_rec.creation_date := p_old_ShopFloorMove_rec.creation_date;
97 END IF;
98
99 IF l_ShopFloorMove_rec.entity_type = FND_API.G_MISS_NUM THEN
100 l_ShopFloorMove_rec.entity_type := p_old_ShopFloorMove_rec.entity_type;
101 END IF;
102
103 IF l_ShopFloorMove_rec.fm_department_code = FND_API.G_MISS_CHAR THEN
104 l_ShopFloorMove_rec.fm_department_code := p_old_ShopFloorMove_rec.fm_department_code;
105 END IF;
106
107 IF l_ShopFloorMove_rec.fm_department_id = FND_API.G_MISS_NUM THEN
108 l_ShopFloorMove_rec.fm_department_id := p_old_ShopFloorMove_rec.fm_department_id;
109 END IF;
110
111 IF l_ShopFloorMove_rec.fm_intraop_step_type = FND_API.G_MISS_NUM THEN
112 l_ShopFloorMove_rec.fm_intraop_step_type := p_old_ShopFloorMove_rec.fm_intraop_step_type;
113 END IF;
114
115 IF l_ShopFloorMove_rec.fm_operation_code = FND_API.G_MISS_CHAR THEN
116 l_ShopFloorMove_rec.fm_operation_code := p_old_ShopFloorMove_rec.fm_operation_code;
117 END IF;
118
119 IF l_ShopFloorMove_rec.fm_operation_seq_num = FND_API.G_MISS_NUM THEN
120 l_ShopFloorMove_rec.fm_operation_seq_num := p_old_ShopFloorMove_rec.fm_operation_seq_num;
121 END IF;
122
123 IF l_ShopFloorMove_rec.group_id = FND_API.G_MISS_NUM THEN
124 l_ShopFloorMove_rec.group_id := p_old_ShopFloorMove_rec.group_id;
125 END IF;
126
127 IF l_ShopFloorMove_rec.kanban_card_id = FND_API.G_MISS_NUM THEN
128 l_ShopFloorMove_rec.kanban_card_id := p_old_ShopFloorMove_rec.kanban_card_id;
129 END IF;
130
131 IF l_ShopFloorMove_rec.last_updated_by = FND_API.G_MISS_NUM THEN
132 l_ShopFloorMove_rec.last_updated_by := p_old_ShopFloorMove_rec.last_updated_by;
133 END IF;
134
135 IF l_ShopFloorMove_rec.last_updated_by_name = FND_API.G_MISS_CHAR THEN
136 l_ShopFloorMove_rec.last_updated_by_name := p_old_ShopFloorMove_rec.last_updated_by_name;
137 END IF;
138
139 IF l_ShopFloorMove_rec.last_update_date = FND_API.G_MISS_DATE THEN
140 l_ShopFloorMove_rec.last_update_date := p_old_ShopFloorMove_rec.last_update_date;
141 END IF;
142
143 IF l_ShopFloorMove_rec.last_update_login = FND_API.G_MISS_NUM THEN
144 l_ShopFloorMove_rec.last_update_login := p_old_ShopFloorMove_rec.last_update_login;
145 END IF;
146
147 IF l_ShopFloorMove_rec.line_code = FND_API.G_MISS_CHAR THEN
148 l_ShopFloorMove_rec.line_code := p_old_ShopFloorMove_rec.line_code;
149 END IF;
150
151 IF l_ShopFloorMove_rec.line_id = FND_API.G_MISS_NUM THEN
152 l_ShopFloorMove_rec.line_id := p_old_ShopFloorMove_rec.line_id;
153 END IF;
154
155 IF l_ShopFloorMove_rec.organization_code = FND_API.G_MISS_CHAR THEN
156 l_ShopFloorMove_rec.organization_code := p_old_ShopFloorMove_rec.organization_code;
157 END IF;
158
159 IF l_ShopFloorMove_rec.organization_id = FND_API.G_MISS_NUM THEN
160 l_ShopFloorMove_rec.organization_id := p_old_ShopFloorMove_rec.organization_id;
161 END IF;
162
163 IF l_ShopFloorMove_rec.overcpl_primary_qty = FND_API.G_MISS_NUM THEN
164 l_ShopFloorMove_rec.overcpl_primary_qty := p_old_ShopFloorMove_rec.overcpl_primary_qty;
165 END IF;
166
167 IF l_ShopFloorMove_rec.overcpl_transaction_id = FND_API.G_MISS_NUM THEN
168 l_ShopFloorMove_rec.overcpl_transaction_id := p_old_ShopFloorMove_rec.overcpl_transaction_id;
169 END IF;
170
171 IF l_ShopFloorMove_rec.overcpl_transaction_qty = FND_API.G_MISS_NUM THEN
172 l_ShopFloorMove_rec.overcpl_transaction_qty := p_old_ShopFloorMove_rec.overcpl_transaction_qty;
173 END IF;
174
175 IF l_ShopFloorMove_rec.primary_item_id = FND_API.G_MISS_NUM THEN
176 l_ShopFloorMove_rec.primary_item_id := p_old_ShopFloorMove_rec.primary_item_id;
177 END IF;
178
179 IF l_ShopFloorMove_rec.primary_quantity = FND_API.G_MISS_NUM THEN
180 l_ShopFloorMove_rec.primary_quantity := p_old_ShopFloorMove_rec.primary_quantity;
181 END IF;
182
183 IF l_ShopFloorMove_rec.primary_uom = FND_API.G_MISS_CHAR THEN
184 l_ShopFloorMove_rec.primary_uom := p_old_ShopFloorMove_rec.primary_uom;
185 END IF;
186
187 IF l_ShopFloorMove_rec.process_phase = FND_API.G_MISS_NUM THEN
188 l_ShopFloorMove_rec.process_phase := p_old_ShopFloorMove_rec.process_phase;
189 END IF;
190
191 IF l_ShopFloorMove_rec.process_status = FND_API.G_MISS_NUM THEN
192 l_ShopFloorMove_rec.process_status := p_old_ShopFloorMove_rec.process_status;
193 END IF;
194
195 IF l_ShopFloorMove_rec.program_application_id = FND_API.G_MISS_NUM THEN
196 l_ShopFloorMove_rec.program_application_id := p_old_ShopFloorMove_rec.program_application_id;
197 END IF;
198
199 IF l_ShopFloorMove_rec.program_id = FND_API.G_MISS_NUM THEN
200 l_ShopFloorMove_rec.program_id := p_old_ShopFloorMove_rec.program_id;
201 END IF;
202
203 IF l_ShopFloorMove_rec.program_update_date = FND_API.G_MISS_DATE THEN
204 l_ShopFloorMove_rec.program_update_date := p_old_ShopFloorMove_rec.program_update_date;
205 END IF;
206
207 IF l_ShopFloorMove_rec.qa_collection_id = FND_API.G_MISS_NUM THEN
208 l_ShopFloorMove_rec.qa_collection_id := p_old_ShopFloorMove_rec.qa_collection_id;
209 END IF;
210
211 IF l_ShopFloorMove_rec.reason_id = FND_API.G_MISS_NUM THEN
212 l_ShopFloorMove_rec.reason_id := p_old_ShopFloorMove_rec.reason_id;
213 END IF;
214
215 IF l_ShopFloorMove_rec.reason_name = FND_API.G_MISS_CHAR THEN
216 l_ShopFloorMove_rec.reason_name := p_old_ShopFloorMove_rec.reason_name;
217 END IF;
218
219 IF l_ShopFloorMove_rec.reference = FND_API.G_MISS_CHAR THEN
220 l_ShopFloorMove_rec.reference := p_old_ShopFloorMove_rec.reference;
221 END IF;
222
223 IF l_ShopFloorMove_rec.repetitive_schedule_id = FND_API.G_MISS_NUM THEN
224 l_ShopFloorMove_rec.repetitive_schedule_id := p_old_ShopFloorMove_rec.repetitive_schedule_id;
225 END IF;
226
227 IF l_ShopFloorMove_rec.request_id = FND_API.G_MISS_NUM THEN
228 l_ShopFloorMove_rec.request_id := p_old_ShopFloorMove_rec.request_id;
229 END IF;
230
231 IF l_ShopFloorMove_rec.scrap_account_id = FND_API.G_MISS_NUM THEN
232 l_ShopFloorMove_rec.scrap_account_id := p_old_ShopFloorMove_rec.scrap_account_id;
233 END IF;
234
235 IF l_ShopFloorMove_rec.source_code = FND_API.G_MISS_CHAR THEN
236 l_ShopFloorMove_rec.source_code := p_old_ShopFloorMove_rec.source_code;
237 END IF;
238
239 IF l_ShopFloorMove_rec.source_line_id = FND_API.G_MISS_NUM THEN
240 l_ShopFloorMove_rec.source_line_id := p_old_ShopFloorMove_rec.source_line_id;
241 END IF;
242
243 IF l_ShopFloorMove_rec.to_department_code = FND_API.G_MISS_CHAR THEN
244 l_ShopFloorMove_rec.to_department_code := p_old_ShopFloorMove_rec.to_department_code;
245 END IF;
246
247 IF l_ShopFloorMove_rec.to_department_id = FND_API.G_MISS_NUM THEN
248 l_ShopFloorMove_rec.to_department_id := p_old_ShopFloorMove_rec.to_department_id;
249 END IF;
250
251 IF l_ShopFloorMove_rec.to_intraop_step_type = FND_API.G_MISS_NUM THEN
252 l_ShopFloorMove_rec.to_intraop_step_type := p_old_ShopFloorMove_rec.to_intraop_step_type;
253 END IF;
254
255 IF l_ShopFloorMove_rec.to_operation_code = FND_API.G_MISS_CHAR THEN
256 l_ShopFloorMove_rec.to_operation_code := p_old_ShopFloorMove_rec.to_operation_code;
257 END IF;
258
259 IF l_ShopFloorMove_rec.to_operation_seq_num = FND_API.G_MISS_NUM THEN
260 l_ShopFloorMove_rec.to_operation_seq_num := p_old_ShopFloorMove_rec.to_operation_seq_num;
261 END IF;
262
263 IF l_ShopFloorMove_rec.transaction_date = FND_API.G_MISS_DATE THEN
264 l_ShopFloorMove_rec.transaction_date := p_old_ShopFloorMove_rec.transaction_date;
265 END IF;
266
267 IF l_ShopFloorMove_rec.transaction_id = FND_API.G_MISS_NUM THEN
268 l_ShopFloorMove_rec.transaction_id := p_old_ShopFloorMove_rec.transaction_id;
269 END IF;
270
271 IF l_ShopFloorMove_rec.transaction_quantity = FND_API.G_MISS_NUM THEN
272 l_ShopFloorMove_rec.transaction_quantity := p_old_ShopFloorMove_rec.transaction_quantity;
273 END IF;
274
275 IF l_ShopFloorMove_rec.transaction_type = FND_API.G_MISS_NUM THEN
276 l_ShopFloorMove_rec.transaction_type := p_old_ShopFloorMove_rec.transaction_type;
277 END IF;
278
279 IF l_ShopFloorMove_rec.transaction_uom = FND_API.G_MISS_CHAR THEN
280 l_ShopFloorMove_rec.transaction_uom := p_old_ShopFloorMove_rec.transaction_uom;
281 END IF;
282
283 IF l_ShopFloorMove_rec.wip_entity_id = FND_API.G_MISS_NUM THEN
284 l_ShopFloorMove_rec.wip_entity_id := p_old_ShopFloorMove_rec.wip_entity_id;
285 END IF;
286
287 IF l_ShopFloorMove_rec.wip_entity_name = FND_API.G_MISS_CHAR THEN
288 l_ShopFloorMove_rec.wip_entity_name := p_old_ShopFloorMove_rec.wip_entity_name;
289 END IF;
290
291 RETURN l_ShopFloorMove_rec;
292
293 END Complete_Record;
294
295 -- Function Convert_Miss_To_Null
296
297 FUNCTION Convert_Miss_To_Null
298 ( p_ShopFloorMove_rec IN WIP_Transaction_PUB.Shopfloormove_Rec_Type
299 ) RETURN WIP_Transaction_PUB.Shopfloormove_Rec_Type
300 IS
301 l_ShopFloorMove_rec WIP_Transaction_PUB.Shopfloormove_Rec_Type := p_ShopFloorMove_rec;
302 BEGIN
303
304 IF l_ShopFloorMove_rec.acct_period_id = FND_API.G_MISS_NUM THEN
305 l_ShopFloorMove_rec.acct_period_id := NULL;
306 END IF;
307
308 IF l_ShopFloorMove_rec.attribute1 = FND_API.G_MISS_CHAR THEN
309 l_ShopFloorMove_rec.attribute1 := NULL;
310 END IF;
311
312 IF l_ShopFloorMove_rec.attribute10 = FND_API.G_MISS_CHAR THEN
313 l_ShopFloorMove_rec.attribute10 := NULL;
314 END IF;
315
316 IF l_ShopFloorMove_rec.attribute11 = FND_API.G_MISS_CHAR THEN
317 l_ShopFloorMove_rec.attribute11 := NULL;
318 END IF;
319
320 IF l_ShopFloorMove_rec.attribute12 = FND_API.G_MISS_CHAR THEN
321 l_ShopFloorMove_rec.attribute12 := NULL;
322 END IF;
323
324 IF l_ShopFloorMove_rec.attribute13 = FND_API.G_MISS_CHAR THEN
325 l_ShopFloorMove_rec.attribute13 := NULL;
326 END IF;
327
328 IF l_ShopFloorMove_rec.attribute14 = FND_API.G_MISS_CHAR THEN
329 l_ShopFloorMove_rec.attribute14 := NULL;
330 END IF;
331
332 IF l_ShopFloorMove_rec.attribute15 = FND_API.G_MISS_CHAR THEN
333 l_ShopFloorMove_rec.attribute15 := NULL;
334 END IF;
335
336 IF l_ShopFloorMove_rec.attribute2 = FND_API.G_MISS_CHAR THEN
337 l_ShopFloorMove_rec.attribute2 := NULL;
338 END IF;
339
340 IF l_ShopFloorMove_rec.attribute3 = FND_API.G_MISS_CHAR THEN
341 l_ShopFloorMove_rec.attribute3 := NULL;
342 END IF;
343
344 IF l_ShopFloorMove_rec.attribute4 = FND_API.G_MISS_CHAR THEN
345 l_ShopFloorMove_rec.attribute4 := NULL;
346 END IF;
347
348 IF l_ShopFloorMove_rec.attribute5 = FND_API.G_MISS_CHAR THEN
349 l_ShopFloorMove_rec.attribute5 := NULL;
350 END IF;
351
352 IF l_ShopFloorMove_rec.attribute6 = FND_API.G_MISS_CHAR THEN
353 l_ShopFloorMove_rec.attribute6 := NULL;
354 END IF;
355
356 IF l_ShopFloorMove_rec.attribute7 = FND_API.G_MISS_CHAR THEN
357 l_ShopFloorMove_rec.attribute7 := NULL;
358 END IF;
359
360 IF l_ShopFloorMove_rec.attribute8 = FND_API.G_MISS_CHAR THEN
361 l_ShopFloorMove_rec.attribute8 := NULL;
362 END IF;
363
364 IF l_ShopFloorMove_rec.attribute9 = FND_API.G_MISS_CHAR THEN
365 l_ShopFloorMove_rec.attribute9 := NULL;
366 END IF;
367
368 IF l_ShopFloorMove_rec.attribute_category = FND_API.G_MISS_CHAR THEN
369 l_ShopFloorMove_rec.attribute_category := NULL;
370 END IF;
371
372 IF l_ShopFloorMove_rec.created_by = FND_API.G_MISS_NUM THEN
373 l_ShopFloorMove_rec.created_by := NULL;
374 END IF;
375
376 IF l_ShopFloorMove_rec.created_by_name = FND_API.G_MISS_CHAR THEN
380 IF l_ShopFloorMove_rec.creation_date = FND_API.G_MISS_DATE THEN
377 l_ShopFloorMove_rec.created_by_name := NULL;
378 END IF;
379
381 l_ShopFloorMove_rec.creation_date := NULL;
382 END IF;
383
384 IF l_ShopFloorMove_rec.entity_type = FND_API.G_MISS_NUM THEN
385 l_ShopFloorMove_rec.entity_type := NULL;
386 END IF;
387
388 IF l_ShopFloorMove_rec.fm_department_code = FND_API.G_MISS_CHAR THEN
389 l_ShopFloorMove_rec.fm_department_code := NULL;
390 END IF;
391
392 IF l_ShopFloorMove_rec.fm_department_id = FND_API.G_MISS_NUM THEN
393 l_ShopFloorMove_rec.fm_department_id := NULL;
394 END IF;
395
396 IF l_ShopFloorMove_rec.fm_intraop_step_type = FND_API.G_MISS_NUM THEN
397 l_ShopFloorMove_rec.fm_intraop_step_type := NULL;
398 END IF;
399
400 IF l_ShopFloorMove_rec.fm_operation_code = FND_API.G_MISS_CHAR THEN
401 l_ShopFloorMove_rec.fm_operation_code := NULL;
402 END IF;
403
404 IF l_ShopFloorMove_rec.fm_operation_seq_num = FND_API.G_MISS_NUM THEN
405 l_ShopFloorMove_rec.fm_operation_seq_num := NULL;
406 END IF;
407
408 IF l_ShopFloorMove_rec.group_id = FND_API.G_MISS_NUM THEN
409 l_ShopFloorMove_rec.group_id := NULL;
410 END IF;
411
412 IF l_ShopFloorMove_rec.kanban_card_id = FND_API.G_MISS_NUM THEN
413 l_ShopFloorMove_rec.kanban_card_id := NULL;
414 END IF;
415
416 IF l_ShopFloorMove_rec.last_updated_by = FND_API.G_MISS_NUM THEN
417 l_ShopFloorMove_rec.last_updated_by := NULL;
418 END IF;
419
420 IF l_ShopFloorMove_rec.last_updated_by_name = FND_API.G_MISS_CHAR THEN
421 l_ShopFloorMove_rec.last_updated_by_name := NULL;
422 END IF;
423
424 IF l_ShopFloorMove_rec.last_update_date = FND_API.G_MISS_DATE THEN
425 l_ShopFloorMove_rec.last_update_date := NULL;
426 END IF;
427
428 IF l_ShopFloorMove_rec.last_update_login = FND_API.G_MISS_NUM THEN
429 l_ShopFloorMove_rec.last_update_login := NULL;
430 END IF;
431
432 IF l_ShopFloorMove_rec.line_code = FND_API.G_MISS_CHAR THEN
433 l_ShopFloorMove_rec.line_code := NULL;
434 END IF;
435
436 IF l_ShopFloorMove_rec.line_id = FND_API.G_MISS_NUM THEN
437 l_ShopFloorMove_rec.line_id := NULL;
438 END IF;
439
440 IF l_ShopFloorMove_rec.organization_code = FND_API.G_MISS_CHAR THEN
441 l_ShopFloorMove_rec.organization_code := NULL;
442 END IF;
443
444 IF l_ShopFloorMove_rec.organization_id = FND_API.G_MISS_NUM THEN
445 l_ShopFloorMove_rec.organization_id := NULL;
446 END IF;
447
448 IF l_ShopFloorMove_rec.overcpl_primary_qty = FND_API.G_MISS_NUM THEN
449 l_ShopFloorMove_rec.overcpl_primary_qty := NULL;
450 END IF;
451
452 IF l_ShopFloorMove_rec.overcpl_transaction_id = FND_API.G_MISS_NUM THEN
453 l_ShopFloorMove_rec.overcpl_transaction_id := NULL;
454 END IF;
455
456 IF l_ShopFloorMove_rec.overcpl_transaction_qty = FND_API.G_MISS_NUM THEN
457 l_ShopFloorMove_rec.overcpl_transaction_qty := NULL;
458 END IF;
459
460 IF l_ShopFloorMove_rec.primary_item_id = FND_API.G_MISS_NUM THEN
461 l_ShopFloorMove_rec.primary_item_id := NULL;
462 END IF;
463
464 IF l_ShopFloorMove_rec.primary_quantity = FND_API.G_MISS_NUM THEN
465 l_ShopFloorMove_rec.primary_quantity := NULL;
466 END IF;
467
468 IF l_ShopFloorMove_rec.primary_uom = FND_API.G_MISS_CHAR THEN
469 l_ShopFloorMove_rec.primary_uom := NULL;
470 END IF;
471
472 IF l_ShopFloorMove_rec.process_phase = FND_API.G_MISS_NUM THEN
473 l_ShopFloorMove_rec.process_phase := NULL;
474 END IF;
475
476 IF l_ShopFloorMove_rec.process_status = FND_API.G_MISS_NUM THEN
477 l_ShopFloorMove_rec.process_status := NULL;
478 END IF;
479
480 IF l_ShopFloorMove_rec.program_application_id = FND_API.G_MISS_NUM THEN
481 l_ShopFloorMove_rec.program_application_id := NULL;
482 END IF;
483
484 IF l_ShopFloorMove_rec.program_id = FND_API.G_MISS_NUM THEN
485 l_ShopFloorMove_rec.program_id := NULL;
486 END IF;
487
488 IF l_ShopFloorMove_rec.program_update_date = FND_API.G_MISS_DATE THEN
489 l_ShopFloorMove_rec.program_update_date := NULL;
490 END IF;
491
492 IF l_ShopFloorMove_rec.qa_collection_id = FND_API.G_MISS_NUM THEN
493 l_ShopFloorMove_rec.qa_collection_id := NULL;
494 END IF;
495
496 IF l_ShopFloorMove_rec.reason_id = FND_API.G_MISS_NUM THEN
497 l_ShopFloorMove_rec.reason_id := NULL;
498 END IF;
499
500 IF l_ShopFloorMove_rec.reason_name = FND_API.G_MISS_CHAR THEN
501 l_ShopFloorMove_rec.reason_name := NULL;
502 END IF;
503
504 IF l_ShopFloorMove_rec.reference = FND_API.G_MISS_CHAR THEN
505 l_ShopFloorMove_rec.reference := NULL;
506 END IF;
507
508 IF l_ShopFloorMove_rec.repetitive_schedule_id = FND_API.G_MISS_NUM THEN
509 l_ShopFloorMove_rec.repetitive_schedule_id := NULL;
510 END IF;
511
512 IF l_ShopFloorMove_rec.request_id = FND_API.G_MISS_NUM THEN
516 IF l_ShopFloorMove_rec.scrap_account_id = FND_API.G_MISS_NUM THEN
513 l_ShopFloorMove_rec.request_id := NULL;
514 END IF;
515
517 l_ShopFloorMove_rec.scrap_account_id := NULL;
518 END IF;
519
520 IF l_ShopFloorMove_rec.source_code = FND_API.G_MISS_CHAR THEN
521 l_ShopFloorMove_rec.source_code := NULL;
522 END IF;
523
524 IF l_ShopFloorMove_rec.source_line_id = FND_API.G_MISS_NUM THEN
525 l_ShopFloorMove_rec.source_line_id := NULL;
526 END IF;
527
528 IF l_ShopFloorMove_rec.to_department_code = FND_API.G_MISS_CHAR THEN
529 l_ShopFloorMove_rec.to_department_code := NULL;
530 END IF;
531
532 IF l_ShopFloorMove_rec.to_department_id = FND_API.G_MISS_NUM THEN
533 l_ShopFloorMove_rec.to_department_id := NULL;
534 END IF;
535
536 IF l_ShopFloorMove_rec.to_intraop_step_type = FND_API.G_MISS_NUM THEN
537 l_ShopFloorMove_rec.to_intraop_step_type := NULL;
538 END IF;
539
540 IF l_ShopFloorMove_rec.to_operation_code = FND_API.G_MISS_CHAR THEN
541 l_ShopFloorMove_rec.to_operation_code := NULL;
542 END IF;
543
544 IF l_ShopFloorMove_rec.to_operation_seq_num = FND_API.G_MISS_NUM THEN
545 l_ShopFloorMove_rec.to_operation_seq_num := NULL;
546 END IF;
547
548 IF l_ShopFloorMove_rec.transaction_date = FND_API.G_MISS_DATE THEN
549 l_ShopFloorMove_rec.transaction_date := NULL;
550 END IF;
551
552 IF l_ShopFloorMove_rec.transaction_id = FND_API.G_MISS_NUM THEN
553 l_ShopFloorMove_rec.transaction_id := NULL;
554 END IF;
555
556 IF l_ShopFloorMove_rec.transaction_quantity = FND_API.G_MISS_NUM THEN
557 l_ShopFloorMove_rec.transaction_quantity := NULL;
558 END IF;
559
560 IF l_ShopFloorMove_rec.transaction_type = FND_API.G_MISS_NUM THEN
561 l_ShopFloorMove_rec.transaction_type := NULL;
562 END IF;
563
564 IF l_ShopFloorMove_rec.transaction_uom = FND_API.G_MISS_CHAR THEN
565 l_ShopFloorMove_rec.transaction_uom := NULL;
566 END IF;
567
568 IF l_ShopFloorMove_rec.wip_entity_id = FND_API.G_MISS_NUM THEN
569 l_ShopFloorMove_rec.wip_entity_id := NULL;
570 END IF;
571
572 IF l_ShopFloorMove_rec.wip_entity_name = FND_API.G_MISS_CHAR THEN
573 l_ShopFloorMove_rec.wip_entity_name := NULL;
574 END IF;
575
576 RETURN l_ShopFloorMove_rec;
577
578 END Convert_Miss_To_Null;
579
580 -- Procedure Update_Row
581
582
583 -- Procedure Insert_Row
584
585 PROCEDURE Insert_Row
586 ( p_ShopFloorMove_rec IN WIP_Transaction_PUB.Shopfloormove_Rec_Type
587 )
588 IS
589 BEGIN
590
591 INSERT INTO WIP_MOVE_TXN_INTERFACE
592 ( ACCT_PERIOD_ID
593 , ATTRIBUTE1
594 , ATTRIBUTE10
595 , ATTRIBUTE11
596 , ATTRIBUTE12
597 , ATTRIBUTE13
598 , ATTRIBUTE14
599 , ATTRIBUTE15
600 , ATTRIBUTE2
601 , ATTRIBUTE3
602 , ATTRIBUTE4
603 , ATTRIBUTE5
604 , ATTRIBUTE6
605 , ATTRIBUTE7
606 , ATTRIBUTE8
607 , ATTRIBUTE9
608 , ATTRIBUTE_CATEGORY
609 , CREATED_BY
610 , CREATED_BY_NAME
611 , CREATION_DATE
612 , ENTITY_TYPE
613 , FM_DEPARTMENT_CODE
614 , FM_DEPARTMENT_ID
615 , FM_INTRAOPERATION_STEP_TYPE
616 , FM_OPERATION_CODE
617 , FM_OPERATION_SEQ_NUM
618 , GROUP_ID
619 , KANBAN_CARD_ID
620 , LAST_UPDATED_BY
621 , LAST_UPDATED_BY_NAME
622 , LAST_UPDATE_DATE
623 , LAST_UPDATE_LOGIN
624 , LINE_CODE
625 , LINE_ID
626 , ORGANIZATION_CODE
627 , ORGANIZATION_ID
628 , OVERCOMPLETION_PRIMARY_QTY
629 , OVERCOMPLETION_TRANSACTION_ID
630 , OVERCOMPLETION_TRANSACTION_QTY
631 , PRIMARY_ITEM_ID
632 , PRIMARY_QUANTITY
633 , PRIMARY_UOM
634 , PROCESS_PHASE
635 , PROCESS_STATUS
636 , PROGRAM_APPLICATION_ID
637 , PROGRAM_ID
638 , PROGRAM_UPDATE_DATE
639 , QA_COLLECTION_ID
640 , REASON_ID
641 , REASON_NAME
642 , REFERENCE
643 , REPETITIVE_SCHEDULE_ID
644 , REQUEST_ID
645 , SCRAP_ACCOUNT_ID
646 , SOURCE_CODE
647 , SOURCE_LINE_ID
648 , TO_DEPARTMENT_CODE
649 , TO_DEPARTMENT_ID
650 , TO_INTRAOPERATION_STEP_TYPE
651 , TO_OPERATION_CODE
652 , TO_OPERATION_SEQ_NUM
653 , TRANSACTION_DATE
654 , TRANSACTION_ID
655 , TRANSACTION_QUANTITY
656 , TRANSACTION_TYPE
657 , TRANSACTION_UOM
658 , WIP_ENTITY_ID
659 , WIP_ENTITY_NAME
660 )
661 VALUES
662 ( p_ShopFloorMove_rec.acct_period_id
663 , p_ShopFloorMove_rec.attribute1
667 , p_ShopFloorMove_rec.attribute13
664 , p_ShopFloorMove_rec.attribute10
665 , p_ShopFloorMove_rec.attribute11
666 , p_ShopFloorMove_rec.attribute12
668 , p_ShopFloorMove_rec.attribute14
669 , p_ShopFloorMove_rec.attribute15
670 , p_ShopFloorMove_rec.attribute2
671 , p_ShopFloorMove_rec.attribute3
672 , p_ShopFloorMove_rec.attribute4
673 , p_ShopFloorMove_rec.attribute5
674 , p_ShopFloorMove_rec.attribute6
675 , p_ShopFloorMove_rec.attribute7
676 , p_ShopFloorMove_rec.attribute8
677 , p_ShopFloorMove_rec.attribute9
678 , p_ShopFloorMove_rec.attribute_category
679 , p_ShopFloorMove_rec.created_by
680 , p_ShopFloorMove_rec.created_by_name
681 , p_ShopFloorMove_rec.creation_date
682 , p_ShopFloorMove_rec.entity_type
683 , p_ShopFloorMove_rec.fm_department_code
684 , p_ShopFloorMove_rec.fm_department_id
685 , p_ShopFloorMove_rec.fm_intraop_step_type
686 , p_ShopFloorMove_rec.fm_operation_code
687 , p_ShopFloorMove_rec.fm_operation_seq_num
688 , p_ShopFloorMove_rec.group_id
689 , p_ShopFloorMove_rec.kanban_card_id
690 , p_ShopFloorMove_rec.last_updated_by
691 , p_ShopFloorMove_rec.last_updated_by_name
692 , p_ShopFloorMove_rec.last_update_date
693 , p_ShopFloorMove_rec.last_update_login
694 , p_ShopFloorMove_rec.line_code
695 , p_ShopFloorMove_rec.line_id
696 , p_ShopFloorMove_rec.organization_code
697 , p_ShopFloorMove_rec.organization_id
698 , p_ShopFloorMove_rec.overcpl_primary_qty
699 , p_ShopFloorMove_rec.overcpl_transaction_id
700 , p_ShopFloorMove_rec.overcpl_transaction_qty
701 , p_ShopFloorMove_rec.primary_item_id
702 , p_ShopFloorMove_rec.primary_quantity
703 , p_ShopFloorMove_rec.primary_uom
704 , p_ShopFloorMove_rec.process_phase
705 , p_ShopFloorMove_rec.process_status
706 , p_ShopFloorMove_rec.program_application_id
707 , p_ShopFloorMove_rec.program_id
708 , p_ShopFloorMove_rec.program_update_date
709 , p_ShopFloorMove_rec.qa_collection_id
710 , p_ShopFloorMove_rec.reason_id
711 , p_ShopFloorMove_rec.reason_name
712 , p_ShopFloorMove_rec.reference
713 , p_ShopFloorMove_rec.repetitive_schedule_id
714 , p_ShopFloorMove_rec.request_id
715 , p_ShopFloorMove_rec.scrap_account_id
716 , p_ShopFloorMove_rec.source_code
717 , p_ShopFloorMove_rec.source_line_id
718 , p_ShopFloorMove_rec.to_department_code
719 , p_ShopFloorMove_rec.to_department_id
720 , p_ShopFloorMove_rec.to_intraop_step_type
721 , p_ShopFloorMove_rec.to_operation_code
722 , p_ShopFloorMove_rec.to_operation_seq_num
723 , p_ShopFloorMove_rec.transaction_date
724 , p_ShopFloorMove_rec.transaction_id
725 , p_ShopFloorMove_rec.transaction_quantity
726 , p_ShopFloorMove_rec.transaction_type
727 , p_ShopFloorMove_rec.transaction_uom
728 , p_ShopFloorMove_rec.wip_entity_id
729 , p_ShopFloorMove_rec.wip_entity_name
730 );
731
732 EXCEPTION
733
734 WHEN OTHERS THEN
735
736 IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
737 THEN
738 FND_MSG_PUB.Add_Exc_Msg
739 ( G_PKG_NAME
740 , 'Insert_Row'
741 );
742 END IF;
743
744 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
745
746 END Insert_Row;
747
748 -- Procedure Delete_Row
749
750 PROCEDURE Delete_Row
751 ( p_transaction_id IN NUMBER
752 )
753 IS
754 BEGIN
755
756 DELETE FROM WIP_MOVE_TXN_INTERFACE
757 WHERE TRANSACTION_ID = p_transaction_id
758 ;
759
760 EXCEPTION
761
762 WHEN OTHERS THEN
763
764 IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
765 THEN
766 FND_MSG_PUB.Add_Exc_Msg
767 ( G_PKG_NAME
768 , 'Delete_Row'
769 );
770 END IF;
771
772 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
773
774 END Delete_Row;
775
776 FUNCTION Query_Row
777 ( p_transaction_id IN NUMBER
778 ) RETURN WIP_Transaction_PUB.Shopfloormove_Rec_Type
779 IS
780 BEGIN
781
782 RETURN Query_Rows
783 ( p_transaction_id => p_transaction_id
784 )(1);
785
786 END Query_Row;
787
788 -- Function Query_Rows
789
790 --
791
792 FUNCTION Query_Rows
793 ( p_transaction_id IN NUMBER :=
794 NULL
795 , p_dummy IN VARCHAR2 :=
796 NULL
797 ) RETURN WIP_Transaction_PUB.Shopfloormove_Tbl_Type
798 IS
799 l_ShopFloorMove_rec WIP_Transaction_PUB.Shopfloormove_Rec_Type;
800 l_ShopFloorMove_tbl WIP_Transaction_PUB.Shopfloormove_Tbl_Type;
804 , ATTRIBUTE1
801
802 CURSOR l_ShopFloorMove_csr IS
803 SELECT ACCT_PERIOD_ID
805 , ATTRIBUTE10
806 , ATTRIBUTE11
807 , ATTRIBUTE12
808 , ATTRIBUTE13
809 , ATTRIBUTE14
810 , ATTRIBUTE15
811 , ATTRIBUTE2
812 , ATTRIBUTE3
813 , ATTRIBUTE4
814 , ATTRIBUTE5
815 , ATTRIBUTE6
816 , ATTRIBUTE7
817 , ATTRIBUTE8
818 , ATTRIBUTE9
819 , ATTRIBUTE_CATEGORY
820 , CREATED_BY
821 , CREATED_BY_NAME
822 , CREATION_DATE
823 , ENTITY_TYPE
824 , FM_DEPARTMENT_CODE
825 , FM_DEPARTMENT_ID
826 , FM_INTRAOPERATION_STEP_TYPE
827 , FM_OPERATION_CODE
828 , FM_OPERATION_SEQ_NUM
829 , GROUP_ID
830 , KANBAN_CARD_ID
831 , LAST_UPDATED_BY
832 , LAST_UPDATED_BY_NAME
833 , LAST_UPDATE_DATE
834 , LAST_UPDATE_LOGIN
835 , LINE_CODE
836 , LINE_ID
837 , ORGANIZATION_CODE
838 , ORGANIZATION_ID
839 , OVERCOMPLETION_PRIMARY_QTY
840 , OVERCOMPLETION_TRANSACTION_ID
841 , OVERCOMPLETION_TRANSACTION_QTY
842 , PRIMARY_ITEM_ID
843 , PRIMARY_QUANTITY
844 , PRIMARY_UOM
845 , PROCESS_PHASE
846 , PROCESS_STATUS
847 , PROGRAM_APPLICATION_ID
848 , PROGRAM_ID
849 , PROGRAM_UPDATE_DATE
850 , QA_COLLECTION_ID
851 , REASON_ID
852 , REASON_NAME
853 , REFERENCE
854 , REPETITIVE_SCHEDULE_ID
855 , REQUEST_ID
856 , SCRAP_ACCOUNT_ID
857 , SOURCE_CODE
858 , SOURCE_LINE_ID
859 , TO_DEPARTMENT_CODE
860 , TO_DEPARTMENT_ID
861 , TO_INTRAOPERATION_STEP_TYPE
862 , TO_OPERATION_CODE
863 , TO_OPERATION_SEQ_NUM
864 , TRANSACTION_DATE
865 , TRANSACTION_ID
866 , TRANSACTION_QUANTITY
867 , TRANSACTION_TYPE
868 , TRANSACTION_UOM
869 , WIP_ENTITY_ID
870 , WIP_ENTITY_NAME
871 FROM WIP_MOVE_TXN_INTERFACE
872 WHERE ( TRANSACTION_ID = nvl(p_transaction_id,FND_API.G_MISS_NUM)
873 );
874
875 BEGIN
876
877
878 -- Loop over fetched records
879
880 FOR l_implicit_rec IN l_ShopFloorMove_csr LOOP
881
882 l_ShopFloorMove_rec.acct_period_id := l_implicit_rec.ACCT_PERIOD_ID;
883 l_ShopFloorMove_rec.attribute1 := l_implicit_rec.ATTRIBUTE1;
884 l_ShopFloorMove_rec.attribute10 := l_implicit_rec.ATTRIBUTE10;
885 l_ShopFloorMove_rec.attribute11 := l_implicit_rec.ATTRIBUTE11;
886 l_ShopFloorMove_rec.attribute12 := l_implicit_rec.ATTRIBUTE12;
887 l_ShopFloorMove_rec.attribute13 := l_implicit_rec.ATTRIBUTE13;
888 l_ShopFloorMove_rec.attribute14 := l_implicit_rec.ATTRIBUTE14;
889 l_ShopFloorMove_rec.attribute15 := l_implicit_rec.ATTRIBUTE15;
890 l_ShopFloorMove_rec.attribute2 := l_implicit_rec.ATTRIBUTE2;
891 l_ShopFloorMove_rec.attribute3 := l_implicit_rec.ATTRIBUTE3;
892 l_ShopFloorMove_rec.attribute4 := l_implicit_rec.ATTRIBUTE4;
893 l_ShopFloorMove_rec.attribute5 := l_implicit_rec.ATTRIBUTE5;
894 l_ShopFloorMove_rec.attribute6 := l_implicit_rec.ATTRIBUTE6;
895 l_ShopFloorMove_rec.attribute7 := l_implicit_rec.ATTRIBUTE7;
896 l_ShopFloorMove_rec.attribute8 := l_implicit_rec.ATTRIBUTE8;
897 l_ShopFloorMove_rec.attribute9 := l_implicit_rec.ATTRIBUTE9;
898 l_ShopFloorMove_rec.attribute_category := l_implicit_rec.ATTRIBUTE_CATEGORY;
899 l_ShopFloorMove_rec.created_by := l_implicit_rec.CREATED_BY;
900 l_ShopFloorMove_rec.created_by_name := l_implicit_rec.CREATED_BY_NAME;
901 l_ShopFloorMove_rec.creation_date := l_implicit_rec.CREATION_DATE;
902 l_ShopFloorMove_rec.entity_type := l_implicit_rec.ENTITY_TYPE;
903 l_ShopFloorMove_rec.fm_department_code := l_implicit_rec.FM_DEPARTMENT_CODE;
904 l_ShopFloorMove_rec.fm_department_id := l_implicit_rec.FM_DEPARTMENT_ID;
905 l_ShopFloorMove_rec.fm_intraop_step_type := l_implicit_rec.FM_INTRAOPERATION_STEP_TYPE;
906 l_ShopFloorMove_rec.fm_operation_code := l_implicit_rec.FM_OPERATION_CODE;
907 l_ShopFloorMove_rec.fm_operation_seq_num := l_implicit_rec.FM_OPERATION_SEQ_NUM;
908 l_ShopFloorMove_rec.group_id := l_implicit_rec.GROUP_ID;
909 l_ShopFloorMove_rec.kanban_card_id := l_implicit_rec.KANBAN_CARD_ID;
910 l_ShopFloorMove_rec.last_updated_by := l_implicit_rec.LAST_UPDATED_BY;
911 l_ShopFloorMove_rec.last_updated_by_name := l_implicit_rec.LAST_UPDATED_BY_NAME;
912 l_ShopFloorMove_rec.last_update_date := l_implicit_rec.LAST_UPDATE_DATE;
913 l_ShopFloorMove_rec.last_update_login := l_implicit_rec.LAST_UPDATE_LOGIN;
914 l_ShopFloorMove_rec.line_code := l_implicit_rec.LINE_CODE;
915 l_ShopFloorMove_rec.line_id := l_implicit_rec.LINE_ID;
916 l_ShopFloorMove_rec.organization_code := l_implicit_rec.ORGANIZATION_CODE;
917 l_ShopFloorMove_rec.organization_id := l_implicit_rec.ORGANIZATION_ID;
918 l_ShopFloorMove_rec.overcpl_primary_qty := l_implicit_rec.OVERCOMPLETION_PRIMARY_QTY;
919 l_ShopFloorMove_rec.overcpl_transaction_id := l_implicit_rec.OVERCOMPLETION_TRANSACTION_ID;
923 l_ShopFloorMove_rec.primary_uom := l_implicit_rec.PRIMARY_UOM;
920 l_ShopFloorMove_rec.overcpl_transaction_qty := l_implicit_rec.OVERCOMPLETION_TRANSACTION_QTY;
921 l_ShopFloorMove_rec.primary_item_id := l_implicit_rec.PRIMARY_ITEM_ID;
922 l_ShopFloorMove_rec.primary_quantity := l_implicit_rec.PRIMARY_QUANTITY;
924 l_ShopFloorMove_rec.process_phase := l_implicit_rec.PROCESS_PHASE;
925 l_ShopFloorMove_rec.process_status := l_implicit_rec.PROCESS_STATUS;
926 l_ShopFloorMove_rec.program_application_id := l_implicit_rec.PROGRAM_APPLICATION_ID;
927 l_ShopFloorMove_rec.program_id := l_implicit_rec.PROGRAM_ID;
928 l_ShopFloorMove_rec.program_update_date := l_implicit_rec.PROGRAM_UPDATE_DATE;
929 l_ShopFloorMove_rec.qa_collection_id := l_implicit_rec.QA_COLLECTION_ID;
930 l_ShopFloorMove_rec.reason_id := l_implicit_rec.REASON_ID;
931 l_ShopFloorMove_rec.reason_name := l_implicit_rec.REASON_NAME;
932 l_ShopFloorMove_rec.reference := l_implicit_rec.REFERENCE;
933 l_ShopFloorMove_rec.repetitive_schedule_id := l_implicit_rec.REPETITIVE_SCHEDULE_ID;
934 l_ShopFloorMove_rec.request_id := l_implicit_rec.REQUEST_ID;
935 l_ShopFloorMove_rec.scrap_account_id := l_implicit_rec.SCRAP_ACCOUNT_ID;
936 l_ShopFloorMove_rec.source_code := l_implicit_rec.SOURCE_CODE;
937 l_ShopFloorMove_rec.source_line_id := l_implicit_rec.SOURCE_LINE_ID;
938 l_ShopFloorMove_rec.to_department_code := l_implicit_rec.TO_DEPARTMENT_CODE;
939 l_ShopFloorMove_rec.to_department_id := l_implicit_rec.TO_DEPARTMENT_ID;
940 l_ShopFloorMove_rec.to_intraop_step_type := l_implicit_rec.TO_INTRAOPERATION_STEP_TYPE;
941 l_ShopFloorMove_rec.to_operation_code := l_implicit_rec.TO_OPERATION_CODE;
942 l_ShopFloorMove_rec.to_operation_seq_num := l_implicit_rec.TO_OPERATION_SEQ_NUM;
943 l_ShopFloorMove_rec.transaction_date := l_implicit_rec.TRANSACTION_DATE;
944 l_ShopFloorMove_rec.transaction_id := l_implicit_rec.TRANSACTION_ID;
945 l_ShopFloorMove_rec.transaction_quantity := l_implicit_rec.TRANSACTION_QUANTITY;
946 l_ShopFloorMove_rec.transaction_type := l_implicit_rec.TRANSACTION_TYPE;
947 l_ShopFloorMove_rec.transaction_uom := l_implicit_rec.TRANSACTION_UOM;
948 l_ShopFloorMove_rec.wip_entity_id := l_implicit_rec.WIP_ENTITY_ID;
949 l_ShopFloorMove_rec.wip_entity_name := l_implicit_rec.WIP_ENTITY_NAME;
950
951 l_ShopFloorMove_tbl(l_ShopFloorMove_tbl.COUNT + 1) := l_ShopFloorMove_rec;
952
953 END LOOP;
954
955
956 -- PK sent and no rows found
957
958 IF
959 (p_transaction_id IS NOT NULL
960 AND
961 p_transaction_id <> FND_API.G_MISS_NUM)
962 AND
963 (l_ShopFloorMove_tbl.COUNT = 0)
964 THEN
965 RAISE NO_DATA_FOUND;
966 END IF;
967
968
969 -- Return fetched table
970
971 RETURN l_ShopFloorMove_tbl;
972
973 EXCEPTION
974
975 WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
976
977 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
978
979 WHEN OTHERS THEN
980
981 IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
982 THEN
983 FND_MSG_PUB.Add_Exc_Msg
984 ( G_PKG_NAME
985 , 'Query_Rows'
986 );
987 END IF;
988
989 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
990
991 END Query_Rows;
992
993
994 PROCEDURE print_record(p_ShopFloorMove_rec IN WIP_Transaction_PUB.ShopFloorMove_Rec_Type)
995 IS
996 BEGIN
997
998 null;
999 -- dbms_output.put_line(' ');
1000 -- dbms_output.put_line('ShopFloorMove Record*********************************');
1001
1002 -- dbms_output.put_line('acct_period_id ' || p_ShopFloorMove_rec.Acct_Period_id);
1003 -- dbms_output.put_line('created_by_name ' || p_ShopFloorMove_rec.Created_By_Name);
1004 -- dbms_output.put_line('entity_type ' || p_ShopFloorMove_rec.Entity_Type);
1005 -- dbms_output.put_line('fm_department_code ' || p_ShopFloorMove_rec.Fm_Department_Code);
1006 -- dbms_output.put_line('fm_department_id ' || p_ShopFloorMove_rec.Fm_Department_Id);
1007 -- dbms_output.put_line('fm_intraop_step_type ' || p_ShopFloorMove_rec.Fm_Intraop_Step_Type);
1008 -- dbms_output.put_line('fm_operation_code ' || p_ShopFloorMove_rec.Fm_Operation_code);
1009 -- dbms_output.put_line('fm_operation_seq_num ' || p_ShopFloorMove_rec.Fm_Operation_Seq_Num);
1010 -- dbms_output.put_line('group_id ' || p_ShopFloorMove_rec.Group_id);
1011 -- dbms_output.put_line('last_updated_by_name ' || p_ShopFloorMove_rec.Last_Updated_By_Name);
1012 -- dbms_output.put_line('line_code ' || p_ShopFloorMove_rec.Line_Code);
1013 -- dbms_output.put_line('line_id ' || p_ShopFloorMove_rec.Line_Id);
1014 -- dbms_output.put_line('organization_code ' || p_ShopFloorMove_rec.Organization_Code);
1015 -- dbms_output.put_line('organization_id ' || p_ShopFloorMove_rec.Organization_Id);
1016 -- dbms_output.put_line('overcpl_primary_qty ' || p_ShopFloorMove_rec.Overcpl_Primary_Qty);
1017 -- dbms_output.put_line('overcpl_transaction_id ' || p_ShopFloorMove_rec.Overcpl_Transaction_id);
1018 -- dbms_output.put_line('overcpl_transaction_qty ' || p_ShopFloorMove_rec.Overcpl_Transaction_Qty);
1019 -- dbms_output.put_line('primary_item_id ' || p_ShopFloorMove_rec.Primary_Item_id);
1020 -- dbms_output.put_line('primary_quantity ' || p_ShopFloorMove_rec.Primary_Quantity);
1021 -- dbms_output.put_line('primary_uom ' || p_ShopFloorMove_rec.Primary_Uom);
1022 -- dbms_output.put_line('process_phase ' || p_ShopFloorMove_rec.Process_Phase);
1026 -- dbms_output.put_line('program_update_date ' || p_ShopFloorMove_rec.program_update_date);
1023 -- dbms_output.put_line('process_status ' || p_ShopFloorMove_rec.Process_Status);
1024 -- dbms_output.put_line('program_application_id ' || p_ShopFloorMove_rec.program_application_id);
1025 -- dbms_output.put_line('program_id ' || p_ShopFloorMove_rec.program_id);
1027 -- dbms_output.put_line('qa_collection_id ' || p_ShopFloorMove_rec.Qa_Collection_id);
1028 -- dbms_output.put_line('reason_id ' || p_ShopFloorMove_rec.Reason_id);
1029 -- dbms_output.put_line('reason_name ' || p_ShopFloorMove_rec.Reason_Name);
1030 -- dbms_output.put_line('reference ' || p_ShopFloorMove_rec.Reference);
1031 -- dbms_output.put_line('repetitive_schedule_id ' || p_ShopFloorMove_rec.Repetitive_Schedule_id);
1032 -- dbms_output.put_line('request_id ' || p_ShopFloorMove_rec.request_id);
1033 -- dbms_output.put_line('scrap_account_id ' || p_ShopFloorMove_rec.Scrap_Account_id);
1034 -- dbms_output.put_line('source_code ' || p_ShopFloorMove_rec.Source_code);
1035 -- dbms_output.put_line('source_line_id ' || p_ShopFloorMove_rec.Source_Line_id);
1036 -- dbms_output.put_line('to_department_code ' || p_ShopFloorMove_rec.To_Department_Code);
1037 -- dbms_output.put_line('to_department_id ' || p_ShopFloorMove_rec.To_Department_Id);
1038 -- dbms_output.put_line('to_intraop_step_type ' || p_ShopFloorMove_rec.To_Intraop_Step_Type);
1039 -- dbms_output.put_line('to_operation_code ' || p_ShopFloorMove_rec.To_Operation_code);
1040 -- dbms_output.put_line('to_operation_seq_num ' || p_ShopFloorMove_rec.To_Operation_Seq_Num);
1041 -- dbms_output.put_line('transaction_date ' || p_ShopFloorMove_rec.Transaction_Date);
1042 -- dbms_output.put_line('transaction_id ' || p_ShopFloorMove_rec.Transaction_id);
1043 -- dbms_output.put_line('transaction_quantity ' || p_ShopFloorMove_rec.Transaction_Quantity);
1044 -- dbms_output.put_line('transaction_type ' || p_ShopFloorMove_rec.Transaction_Type);
1045 -- dbms_output.put_line('transaction_uom ' || p_ShopFloorMove_rec.Transaction_Uom);
1046 -- dbms_output.put_line('wip_entity_id ' || p_ShopFloorMove_rec.Wip_Entity_id);
1047 -- dbms_output.put_line('wip_entity_name ' || p_ShopFloorMove_rec.Wip_Entity_Name);
1048
1049
1050 END print_record;
1051
1052 END WIP_Shopfloormove_Util;