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.

APPS.BOM_DEFAULT_RTG_HEADER dependencies on FND_API

Line 60: IF p_rtg_header_rec.attribute_category =FND_API.G_MISS_CHAR THEN

56:
57: -- In the future call Flex APIs for defaults
58: x_rtg_header_rec := p_rtg_header_rec;
59:
60: IF p_rtg_header_rec.attribute_category =FND_API.G_MISS_CHAR THEN
61: x_rtg_header_rec.attribute_category := NULL;
62: END IF;
63:
64: IF p_rtg_header_rec.attribute1 = FND_API.G_MISS_CHAR THEN

Line 64: IF p_rtg_header_rec.attribute1 = FND_API.G_MISS_CHAR THEN

60: IF p_rtg_header_rec.attribute_category =FND_API.G_MISS_CHAR THEN
61: x_rtg_header_rec.attribute_category := NULL;
62: END IF;
63:
64: IF p_rtg_header_rec.attribute1 = FND_API.G_MISS_CHAR THEN
65: x_rtg_header_rec.attribute1 := NULL;
66: END IF;
67:
68: IF p_rtg_header_rec.attribute2 = FND_API.G_MISS_CHAR THEN

Line 68: IF p_rtg_header_rec.attribute2 = FND_API.G_MISS_CHAR THEN

64: IF p_rtg_header_rec.attribute1 = FND_API.G_MISS_CHAR THEN
65: x_rtg_header_rec.attribute1 := NULL;
66: END IF;
67:
68: IF p_rtg_header_rec.attribute2 = FND_API.G_MISS_CHAR THEN
69: x_rtg_header_rec.attribute2 := NULL;
70: END IF;
71:
72: IF p_rtg_header_rec.attribute3 = FND_API.G_MISS_CHAR THEN

Line 72: IF p_rtg_header_rec.attribute3 = FND_API.G_MISS_CHAR THEN

68: IF p_rtg_header_rec.attribute2 = FND_API.G_MISS_CHAR THEN
69: x_rtg_header_rec.attribute2 := NULL;
70: END IF;
71:
72: IF p_rtg_header_rec.attribute3 = FND_API.G_MISS_CHAR THEN
73: x_rtg_header_rec.attribute3 := NULL;
74: END IF;
75:
76: IF p_rtg_header_rec.attribute4 = FND_API.G_MISS_CHAR THEN

Line 76: IF p_rtg_header_rec.attribute4 = FND_API.G_MISS_CHAR THEN

72: IF p_rtg_header_rec.attribute3 = FND_API.G_MISS_CHAR THEN
73: x_rtg_header_rec.attribute3 := NULL;
74: END IF;
75:
76: IF p_rtg_header_rec.attribute4 = FND_API.G_MISS_CHAR THEN
77: x_rtg_header_rec.attribute4 := NULL;
78: END IF;
79:
80: IF p_rtg_header_rec.attribute5 = FND_API.G_MISS_CHAR THEN

Line 80: IF p_rtg_header_rec.attribute5 = FND_API.G_MISS_CHAR THEN

76: IF p_rtg_header_rec.attribute4 = FND_API.G_MISS_CHAR THEN
77: x_rtg_header_rec.attribute4 := NULL;
78: END IF;
79:
80: IF p_rtg_header_rec.attribute5 = FND_API.G_MISS_CHAR THEN
81: x_rtg_header_rec.attribute5 := NULL;
82: END IF;
83:
84: IF p_rtg_header_rec.attribute6 = FND_API.G_MISS_CHAR THEN

Line 84: IF p_rtg_header_rec.attribute6 = FND_API.G_MISS_CHAR THEN

80: IF p_rtg_header_rec.attribute5 = FND_API.G_MISS_CHAR THEN
81: x_rtg_header_rec.attribute5 := NULL;
82: END IF;
83:
84: IF p_rtg_header_rec.attribute6 = FND_API.G_MISS_CHAR THEN
85: x_rtg_header_rec.attribute6 := NULL;
86: END IF;
87:
88: IF p_rtg_header_rec.attribute7 = FND_API.G_MISS_CHAR THEN

Line 88: IF p_rtg_header_rec.attribute7 = FND_API.G_MISS_CHAR THEN

84: IF p_rtg_header_rec.attribute6 = FND_API.G_MISS_CHAR THEN
85: x_rtg_header_rec.attribute6 := NULL;
86: END IF;
87:
88: IF p_rtg_header_rec.attribute7 = FND_API.G_MISS_CHAR THEN
89: x_rtg_header_rec.attribute7 := NULL;
90: END IF;
91:
92: IF p_rtg_header_rec.attribute8 = FND_API.G_MISS_CHAR THEN

Line 92: IF p_rtg_header_rec.attribute8 = FND_API.G_MISS_CHAR THEN

88: IF p_rtg_header_rec.attribute7 = FND_API.G_MISS_CHAR THEN
89: x_rtg_header_rec.attribute7 := NULL;
90: END IF;
91:
92: IF p_rtg_header_rec.attribute8 = FND_API.G_MISS_CHAR THEN
93: x_rtg_header_rec.attribute8 := NULL;
94: END IF;
95:
96: IF p_rtg_header_rec.attribute9 = FND_API.G_MISS_CHAR THEN

Line 96: IF p_rtg_header_rec.attribute9 = FND_API.G_MISS_CHAR THEN

92: IF p_rtg_header_rec.attribute8 = FND_API.G_MISS_CHAR THEN
93: x_rtg_header_rec.attribute8 := NULL;
94: END IF;
95:
96: IF p_rtg_header_rec.attribute9 = FND_API.G_MISS_CHAR THEN
97: x_rtg_header_rec.attribute9 := NULL;
98: END IF;
99:
100: IF p_rtg_header_rec.attribute10 = FND_API.G_MISS_CHAR THEN

Line 100: IF p_rtg_header_rec.attribute10 = FND_API.G_MISS_CHAR THEN

96: IF p_rtg_header_rec.attribute9 = FND_API.G_MISS_CHAR THEN
97: x_rtg_header_rec.attribute9 := NULL;
98: END IF;
99:
100: IF p_rtg_header_rec.attribute10 = FND_API.G_MISS_CHAR THEN
101: x_rtg_header_rec.attribute10 := NULL;
102: END IF;
103:
104: IF p_rtg_header_rec.attribute11 = FND_API.G_MISS_CHAR THEN

Line 104: IF p_rtg_header_rec.attribute11 = FND_API.G_MISS_CHAR THEN

100: IF p_rtg_header_rec.attribute10 = FND_API.G_MISS_CHAR THEN
101: x_rtg_header_rec.attribute10 := NULL;
102: END IF;
103:
104: IF p_rtg_header_rec.attribute11 = FND_API.G_MISS_CHAR THEN
105: x_rtg_header_rec.attribute11 := NULL;
106: END IF;
107:
108: IF p_rtg_header_rec.attribute12 = FND_API.G_MISS_CHAR THEN

Line 108: IF p_rtg_header_rec.attribute12 = FND_API.G_MISS_CHAR THEN

104: IF p_rtg_header_rec.attribute11 = FND_API.G_MISS_CHAR THEN
105: x_rtg_header_rec.attribute11 := NULL;
106: END IF;
107:
108: IF p_rtg_header_rec.attribute12 = FND_API.G_MISS_CHAR THEN
109: x_rtg_header_rec.attribute12 := NULL;
110: END IF;
111:
112: IF p_rtg_header_rec.attribute13 = FND_API.G_MISS_CHAR THEN

Line 112: IF p_rtg_header_rec.attribute13 = FND_API.G_MISS_CHAR THEN

108: IF p_rtg_header_rec.attribute12 = FND_API.G_MISS_CHAR THEN
109: x_rtg_header_rec.attribute12 := NULL;
110: END IF;
111:
112: IF p_rtg_header_rec.attribute13 = FND_API.G_MISS_CHAR THEN
113: x_rtg_header_rec.attribute13 := NULL;
114: END IF;
115:
116: IF p_rtg_header_rec.attribute14 = FND_API.G_MISS_CHAR THEN

Line 116: IF p_rtg_header_rec.attribute14 = FND_API.G_MISS_CHAR THEN

112: IF p_rtg_header_rec.attribute13 = FND_API.G_MISS_CHAR THEN
113: x_rtg_header_rec.attribute13 := NULL;
114: END IF;
115:
116: IF p_rtg_header_rec.attribute14 = FND_API.G_MISS_CHAR THEN
117: x_rtg_header_rec.attribute14 := NULL;
118: END IF;
119:
120: IF p_rtg_header_rec.attribute15 = FND_API.G_MISS_CHAR THEN

Line 120: IF p_rtg_header_rec.attribute15 = FND_API.G_MISS_CHAR THEN

116: IF p_rtg_header_rec.attribute14 = FND_API.G_MISS_CHAR THEN
117: x_rtg_header_rec.attribute14 := NULL;
118: END IF;
119:
120: IF p_rtg_header_rec.attribute15 = FND_API.G_MISS_CHAR THEN
121: x_rtg_header_rec.attribute15 := NULL;
122: END IF;
123:
124:

Line 248: x_return_status := FND_API.G_RET_STS_SUCCESS;

244: BEGIN
245:
246: x_rtg_header_rec := p_rtg_header_rec;
247: x_rtg_header_unexp_rec := p_rtg_header_unexp_rec;
248: x_return_status := FND_API.G_RET_STS_SUCCESS;
249:
250: IF p_rtg_header_unexp_rec.routing_sequence_id IS NULL OR
251: p_rtg_header_unexp_rec.routing_sequence_id = FND_API.G_MISS_NUM
252: THEN

Line 251: p_rtg_header_unexp_rec.routing_sequence_id = FND_API.G_MISS_NUM

247: x_rtg_header_unexp_rec := p_rtg_header_unexp_rec;
248: x_return_status := FND_API.G_RET_STS_SUCCESS;
249:
250: IF p_rtg_header_unexp_rec.routing_sequence_id IS NULL OR
251: p_rtg_header_unexp_rec.routing_sequence_id = FND_API.G_MISS_NUM
252: THEN
253: x_rtg_header_unexp_rec.routing_sequence_id :=
254: Get_Routing_Sequence;
255:

Line 263: IF p_rtg_header_rec.cfm_routing_flag = FND_API.G_MISS_NUM

259: END IF;
260:
261: END IF;
262:
263: IF p_rtg_header_rec.cfm_routing_flag = FND_API.G_MISS_NUM
264: OR p_rtg_header_rec.cfm_routing_flag IS NULL
265: THEN
266: x_rtg_header_rec.cfm_routing_flag := Get_Cfm_Routing_Flag ;
267: END IF;

Line 269: IF p_rtg_header_rec.mixed_model_map_flag =FND_API.G_MISS_NUM

265: THEN
266: x_rtg_header_rec.cfm_routing_flag := Get_Cfm_Routing_Flag ;
267: END IF;
268:
269: IF p_rtg_header_rec.mixed_model_map_flag =FND_API.G_MISS_NUM
270: OR p_rtg_header_rec.mixed_model_map_flag IS NULL
271: THEN
272: x_rtg_header_rec.mixed_model_map_flag := Get_Mixed_Model_Map_Flag ;
273: END IF;

Line 275: IF p_rtg_header_rec.ctp_flag =FND_API.G_MISS_NUM

271: THEN
272: x_rtg_header_rec.mixed_model_map_flag := Get_Mixed_Model_Map_Flag ;
273: END IF;
274:
275: IF p_rtg_header_rec.ctp_flag =FND_API.G_MISS_NUM
276: OR p_rtg_header_rec.ctp_flag IS NULL
277: THEN
278: x_rtg_header_rec.ctp_flag := Get_Ctp_Flag ;
279: END IF;

Line 281: IF p_rtg_header_rec.eng_routing_flag = FND_API.G_MISS_NUM

277: THEN
278: x_rtg_header_rec.ctp_flag := Get_Ctp_Flag ;
279: END IF;
280:
281: IF p_rtg_header_rec.eng_routing_flag = FND_API.G_MISS_NUM
282: OR p_rtg_header_rec.eng_routing_flag IS NULL
283: THEN
284: x_rtg_header_rec.eng_routing_flag
285: := Get_Eng_Routing_Flag

Line 291: IF p_rtg_header_rec.total_cycle_time = FND_API.G_MISS_NUM THEN

287: , p_org_id => p_rtg_header_unexp_rec.organization_id ) ;
288:
289: END IF ;
290:
291: IF p_rtg_header_rec.total_cycle_time = FND_API.G_MISS_NUM THEN
292: x_rtg_header_rec.total_cycle_time := NULL ;
293: END IF;
294:
295: Get_Flex_Rtg_Header( p_rtg_header_rec => x_rtg_header_rec

Line 303: IF NVL(p_rtg_header_unexp_rec.common_routing_sequence_id, FND_API.G_MISS_NUM) <>

299: --bug:4285921 begins
300: -- Called for CREATE.
301: -- Take values of completion_subinventory and completion_locator_id
302: -- from input if specified, else take it from common routing.
303: IF NVL(p_rtg_header_unexp_rec.common_routing_sequence_id, FND_API.G_MISS_NUM) <>
304: FND_API.G_MISS_NUM
305: THEN
306: FOR l_CommonRtg_rec IN
307: l_CommonRtg_csr

Line 304: FND_API.G_MISS_NUM

300: -- Called for CREATE.
301: -- Take values of completion_subinventory and completion_locator_id
302: -- from input if specified, else take it from common routing.
303: IF NVL(p_rtg_header_unexp_rec.common_routing_sequence_id, FND_API.G_MISS_NUM) <>
304: FND_API.G_MISS_NUM
305: THEN
306: FOR l_CommonRtg_rec IN
307: l_CommonRtg_csr
308: (

Line 352: x_return_status := FND_API.G_RET_STS_SUCCESS;

348: BEGIN
349:
350: x_rtg_header_rec := p_rtg_header_rec;
351: x_rtg_header_unexp_rec := p_rtg_header_unexp_rec;
352: x_return_status := FND_API.G_RET_STS_SUCCESS;
353:
354: IF (p_rtg_header_unexp_rec.routing_sequence_id IS NOT NULL
355: AND p_rtg_header_unexp_rec.routing_sequence_id <> FND_API.G_MISS_NUM)
356: AND ( p_rtg_header_unexp_rec.common_routing_sequence_id IS NULL

Line 355: AND p_rtg_header_unexp_rec.routing_sequence_id <> FND_API.G_MISS_NUM)

351: x_rtg_header_unexp_rec := p_rtg_header_unexp_rec;
352: x_return_status := FND_API.G_RET_STS_SUCCESS;
353:
354: IF (p_rtg_header_unexp_rec.routing_sequence_id IS NOT NULL
355: AND p_rtg_header_unexp_rec.routing_sequence_id <> FND_API.G_MISS_NUM)
356: AND ( p_rtg_header_unexp_rec.common_routing_sequence_id IS NULL
357: OR p_rtg_header_unexp_rec.common_routing_sequence_id
358: = FND_API.G_MISS_NUM )
359: THEN

Line 358: = FND_API.G_MISS_NUM )

354: IF (p_rtg_header_unexp_rec.routing_sequence_id IS NOT NULL
355: AND p_rtg_header_unexp_rec.routing_sequence_id <> FND_API.G_MISS_NUM)
356: AND ( p_rtg_header_unexp_rec.common_routing_sequence_id IS NULL
357: OR p_rtg_header_unexp_rec.common_routing_sequence_id
358: = FND_API.G_MISS_NUM )
359: THEN
360: x_rtg_header_unexp_rec.common_routing_sequence_id :=
361: p_rtg_header_unexp_rec.routing_sequence_id;
362: END IF;

Line 369: ELSIF p_rtg_header_unexp_rec.common_assembly_item_id = FND_API.G_MISS_NUM

365: = p_rtg_header_unexp_rec.routing_sequence_id
366: THEN
367: x_rtg_header_unexp_rec.common_assembly_item_id := NULL ;
368:
369: ELSIF p_rtg_header_unexp_rec.common_assembly_item_id = FND_API.G_MISS_NUM
370: THEN
371: x_rtg_header_unexp_rec.common_assembly_item_id := NULL ;
372: END IF ;
373:

Line 375: AND p_rtg_header_rec.eng_routing_flag <> FND_API.G_MISS_NUM

371: x_rtg_header_unexp_rec.common_assembly_item_id := NULL ;
372: END IF ;
373:
374: IF p_rtg_header_rec.eng_routing_flag IS NOT NULL
375: AND p_rtg_header_rec.eng_routing_flag <> FND_API.G_MISS_NUM
376: AND ( p_rtg_header_unexp_rec.routing_type IS NULL
377: OR p_rtg_header_unexp_rec.routing_type = FND_API.G_MISS_NUM)
378: THEN
379: SELECT DECODE(p_rtg_header_rec.eng_routing_flag, 1, 2, 1)

Line 377: OR p_rtg_header_unexp_rec.routing_type = FND_API.G_MISS_NUM)

373:
374: IF p_rtg_header_rec.eng_routing_flag IS NOT NULL
375: AND p_rtg_header_rec.eng_routing_flag <> FND_API.G_MISS_NUM
376: AND ( p_rtg_header_unexp_rec.routing_type IS NULL
377: OR p_rtg_header_unexp_rec.routing_type = FND_API.G_MISS_NUM)
378: THEN
379: SELECT DECODE(p_rtg_header_rec.eng_routing_flag, 1, 2, 1)
380: INTO x_rtg_header_unexp_rec.routing_type
381: FROM SYS.DUAL ;

Line 385: IF p_rtg_header_rec.total_cycle_time = FND_API.G_MISS_NUM THEN

381: FROM SYS.DUAL ;
382: END IF;
383:
384:
385: IF p_rtg_header_rec.total_cycle_time = FND_API.G_MISS_NUM THEN
386: x_rtg_header_rec.total_cycle_time := NULL ;
387: END IF;
388:
389: IF p_rtg_header_rec.alternate_routing_code = FND_API.G_MISS_CHAR

Line 389: IF p_rtg_header_rec.alternate_routing_code = FND_API.G_MISS_CHAR

385: IF p_rtg_header_rec.total_cycle_time = FND_API.G_MISS_NUM THEN
386: x_rtg_header_rec.total_cycle_time := NULL ;
387: END IF;
388:
389: IF p_rtg_header_rec.alternate_routing_code = FND_API.G_MISS_CHAR
390: THEN
391: x_rtg_header_rec.alternate_routing_code := NULL ;
392: END IF ;
393:

Line 394: IF p_rtg_header_rec.completion_subinventory = FND_API.G_MISS_CHAR

390: THEN
391: x_rtg_header_rec.alternate_routing_code := NULL ;
392: END IF ;
393:
394: IF p_rtg_header_rec.completion_subinventory = FND_API.G_MISS_CHAR
395: THEN
396: x_rtg_header_rec.completion_subinventory := NULL ;
397: END IF ;
398:

Line 399: IF p_rtg_header_unexp_rec.completion_locator_id = FND_API.G_MISS_NUM

395: THEN
396: x_rtg_header_rec.completion_subinventory := NULL ;
397: END IF ;
398:
399: IF p_rtg_header_unexp_rec.completion_locator_id = FND_API.G_MISS_NUM
400: THEN
401: x_rtg_header_unexp_rec.completion_locator_id := NULL ;
402: END IF ;
403:

Line 404: IF p_rtg_header_unexp_rec.line_id = FND_API.G_MISS_NUM

400: THEN
401: x_rtg_header_unexp_rec.completion_locator_id := NULL ;
402: END IF ;
403:
404: IF p_rtg_header_unexp_rec.line_id = FND_API.G_MISS_NUM
405: OR p_rtg_header_unexp_rec.line_id IS NULL
406: THEN
407: x_rtg_header_unexp_rec.line_id := NULL ;
408: x_rtg_header_rec.line_code := NULL ;

Line 411: IF p_rtg_header_rec.priority = FND_API.G_MISS_NUM THEN

407: x_rtg_header_unexp_rec.line_id := NULL ;
408: x_rtg_header_rec.line_code := NULL ;
409: END IF ;
410:
411: IF p_rtg_header_rec.priority = FND_API.G_MISS_NUM THEN
412: x_rtg_header_rec.priority := NULL ;
413: END IF ;
414:
415: IF p_rtg_header_rec.total_cycle_time = FND_API.G_MISS_NUM THEN

Line 415: IF p_rtg_header_rec.total_cycle_time = FND_API.G_MISS_NUM THEN

411: IF p_rtg_header_rec.priority = FND_API.G_MISS_NUM THEN
412: x_rtg_header_rec.priority := NULL ;
413: END IF ;
414:
415: IF p_rtg_header_rec.total_cycle_time = FND_API.G_MISS_NUM THEN
416: x_rtg_header_rec.total_cycle_time := NULL ;
417: END IF ;
418:
419: IF p_rtg_header_rec.routing_comment = FND_API.G_MISS_CHAR

Line 419: IF p_rtg_header_rec.routing_comment = FND_API.G_MISS_CHAR

415: IF p_rtg_header_rec.total_cycle_time = FND_API.G_MISS_NUM THEN
416: x_rtg_header_rec.total_cycle_time := NULL ;
417: END IF ;
418:
419: IF p_rtg_header_rec.routing_comment = FND_API.G_MISS_CHAR
420: THEN
421: x_rtg_header_rec.routing_comment := NULL ;
422: END IF ;
423:

Line 424: IF p_rtg_header_rec.ser_start_op_seq = FND_API.G_MISS_NUM -- Added for SSOS (bug 2689249)

420: THEN
421: x_rtg_header_rec.routing_comment := NULL ;
422: END IF ;
423:
424: IF p_rtg_header_rec.ser_start_op_seq = FND_API.G_MISS_NUM -- Added for SSOS (bug 2689249)
425: THEN
426: x_rtg_header_rec.ser_start_op_seq := NULL ;
427: ELSIF p_rtg_header_rec.ser_start_op_seq IS NOT NULL THEN
428: --bug:5137686 Allow SSOS for network routing also.

Line 550: p_rtg_header_rec.eng_routing_flag = FND_API.G_MISS_NUM )

546: x_rtg_header_unexp_rec := p_rtg_header_unexp_rec;
547:
548:
549: IF( p_rtg_header_rec.eng_routing_flag IS NULL OR
550: p_rtg_header_rec.eng_routing_flag = FND_API.G_MISS_NUM )
551: THEN
552: x_rtg_header_unexp_rec.routing_type :=
553: p_old_rtg_header_unexp_rec.routing_type ;
554: END IF;

Line 564: OR p_rtg_header_rec.CFM_Routing_Flag = FND_API.G_MISS_NUM

560: p_old_rtg_header_rec.Routing_Comment ;
561: END IF;
562:
563: IF p_rtg_header_rec.CFM_Routing_Flag IS NULL
564: OR p_rtg_header_rec.CFM_Routing_Flag = FND_API.G_MISS_NUM
565: THEN
566: x_rtg_header_rec.CFM_Routing_Flag :=
567: p_old_rtg_header_rec.CFM_Routing_Flag ;
568: END IF ;

Line 571: OR p_rtg_header_rec.Mixed_Model_Map_Flag = FND_API.G_MISS_NUM

567: p_old_rtg_header_rec.CFM_Routing_Flag ;
568: END IF ;
569:
570: IF p_rtg_header_rec.Mixed_Model_Map_Flag IS NULL
571: OR p_rtg_header_rec.Mixed_Model_Map_Flag = FND_API.G_MISS_NUM
572: THEN
573: x_rtg_header_rec.Mixed_Model_Map_Flag :=
574: p_old_rtg_header_rec.Mixed_Model_Map_Flag ;
575: END IF ;

Line 578: OR p_rtg_header_rec.CTP_Flag = FND_API.G_MISS_NUM

574: p_old_rtg_header_rec.Mixed_Model_Map_Flag ;
575: END IF ;
576:
577: IF p_rtg_header_rec.CTP_Flag IS NULL
578: OR p_rtg_header_rec.CTP_Flag = FND_API.G_MISS_NUM
579: THEN
580: x_rtg_header_rec.CTP_Flag :=
581: p_old_rtg_header_rec.CTP_Flag ;
582: END IF ;

Line 606: p_rtg_header_rec.attribute_category = FND_API.G_MISS_CHAR

602: --
603: -- Populate Null or missng flex field columns
604: --
605: IF p_rtg_header_rec.attribute_category IS NULL OR
606: p_rtg_header_rec.attribute_category = FND_API.G_MISS_CHAR
607: THEN
608: x_rtg_header_rec.attribute_category :=
609: p_old_rtg_header_rec.attribute_category;
610:

Line 613: IF p_rtg_header_rec.attribute1 = FND_API.G_MISS_CHAR OR

609: p_old_rtg_header_rec.attribute_category;
610:
611: END IF;
612:
613: IF p_rtg_header_rec.attribute1 = FND_API.G_MISS_CHAR OR
614: p_rtg_header_rec.attribute1 IS NULL
615: THEN
616: x_rtg_header_rec.attribute1 :=
617: p_old_rtg_header_rec.attribute1;

Line 620: IF p_rtg_header_rec.attribute2 = FND_API.G_MISS_CHAR OR

616: x_rtg_header_rec.attribute1 :=
617: p_old_rtg_header_rec.attribute1;
618: END IF;
619:
620: IF p_rtg_header_rec.attribute2 = FND_API.G_MISS_CHAR OR
621: p_rtg_header_rec.attribute2 IS NULL
622: THEN
623: x_rtg_header_rec.attribute2 :=
624: p_old_rtg_header_rec.attribute2;

Line 627: IF p_rtg_header_rec.attribute3 = FND_API.G_MISS_CHAR OR

623: x_rtg_header_rec.attribute2 :=
624: p_old_rtg_header_rec.attribute2;
625: END IF;
626:
627: IF p_rtg_header_rec.attribute3 = FND_API.G_MISS_CHAR OR
628: p_rtg_header_rec.attribute3 IS NULL
629: THEN
630: x_rtg_header_rec.attribute3 :=
631: p_old_rtg_header_rec.attribute3;

Line 634: IF p_rtg_header_rec.attribute4 = FND_API.G_MISS_CHAR OR

630: x_rtg_header_rec.attribute3 :=
631: p_old_rtg_header_rec.attribute3;
632: END IF;
633:
634: IF p_rtg_header_rec.attribute4 = FND_API.G_MISS_CHAR OR
635: p_rtg_header_rec.attribute4 IS NULL
636: THEN
637: x_rtg_header_rec.attribute4 :=
638: p_old_rtg_header_rec.attribute4;

Line 641: IF p_rtg_header_rec.attribute5 = FND_API.G_MISS_CHAR OR

637: x_rtg_header_rec.attribute4 :=
638: p_old_rtg_header_rec.attribute4;
639: END IF;
640:
641: IF p_rtg_header_rec.attribute5 = FND_API.G_MISS_CHAR OR
642: p_rtg_header_rec.attribute5 IS NULL
643: THEN
644: x_rtg_header_rec.attribute5 :=
645: p_old_rtg_header_rec.attribute5;

Line 648: IF p_rtg_header_rec.attribute6 = FND_API.G_MISS_CHAR OR

644: x_rtg_header_rec.attribute5 :=
645: p_old_rtg_header_rec.attribute5;
646: END IF;
647:
648: IF p_rtg_header_rec.attribute6 = FND_API.G_MISS_CHAR OR
649: p_rtg_header_rec.attribute6 IS NULL
650: THEN
651: x_rtg_header_rec.attribute6 :=
652: p_old_rtg_header_rec.attribute6;

Line 655: IF p_rtg_header_rec.attribute7 = FND_API.G_MISS_CHAR OR

651: x_rtg_header_rec.attribute6 :=
652: p_old_rtg_header_rec.attribute6;
653: END IF;
654:
655: IF p_rtg_header_rec.attribute7 = FND_API.G_MISS_CHAR OR
656: p_rtg_header_rec.attribute7 IS NULL
657: THEN
658: x_rtg_header_rec.attribute7 :=
659: p_old_rtg_header_rec.attribute7;

Line 662: IF p_rtg_header_rec.attribute8 = FND_API.G_MISS_CHAR OR

658: x_rtg_header_rec.attribute7 :=
659: p_old_rtg_header_rec.attribute7;
660: END IF;
661:
662: IF p_rtg_header_rec.attribute8 = FND_API.G_MISS_CHAR OR
663: p_rtg_header_rec.attribute8 IS NULL
664: THEN
665: x_rtg_header_rec.attribute8 :=
666: p_old_rtg_header_rec.attribute8;

Line 669: IF p_rtg_header_rec.attribute9 = FND_API.G_MISS_CHAR OR

665: x_rtg_header_rec.attribute8 :=
666: p_old_rtg_header_rec.attribute8;
667: END IF;
668:
669: IF p_rtg_header_rec.attribute9 = FND_API.G_MISS_CHAR OR
670: p_rtg_header_rec.attribute9 IS NULL
671: THEN
672: x_rtg_header_rec.attribute9 :=
673: p_old_rtg_header_rec.attribute9;

Line 676: IF p_rtg_header_rec.attribute10 = FND_API.G_MISS_CHAR OR

672: x_rtg_header_rec.attribute9 :=
673: p_old_rtg_header_rec.attribute9;
674: END IF;
675:
676: IF p_rtg_header_rec.attribute10 = FND_API.G_MISS_CHAR OR
677: p_rtg_header_rec.attribute10 IS NULL
678: THEN
679: x_rtg_header_rec.attribute10 :=
680: p_old_rtg_header_rec.attribute10;

Line 683: IF p_rtg_header_rec.attribute11 = FND_API.G_MISS_CHAR OR

679: x_rtg_header_rec.attribute10 :=
680: p_old_rtg_header_rec.attribute10;
681: END IF;
682:
683: IF p_rtg_header_rec.attribute11 = FND_API.G_MISS_CHAR OR
684: p_rtg_header_rec.attribute11 IS NULL
685: THEN
686: x_rtg_header_rec.attribute11 :=
687: p_old_rtg_header_rec.attribute11;

Line 690: IF p_rtg_header_rec.attribute12 = FND_API.G_MISS_CHAR OR

686: x_rtg_header_rec.attribute11 :=
687: p_old_rtg_header_rec.attribute11;
688: END IF;
689:
690: IF p_rtg_header_rec.attribute12 = FND_API.G_MISS_CHAR OR
691: p_rtg_header_rec.attribute12 IS NULL
692: THEN
693: x_rtg_header_rec.attribute12 :=
694: p_old_rtg_header_rec.attribute12;

Line 697: IF p_rtg_header_rec.attribute13 = FND_API.G_MISS_CHAR OR

693: x_rtg_header_rec.attribute12 :=
694: p_old_rtg_header_rec.attribute12;
695: END IF;
696:
697: IF p_rtg_header_rec.attribute13 = FND_API.G_MISS_CHAR OR
698: p_rtg_header_rec.attribute13 IS NULL
699: THEN
700: x_rtg_header_rec.attribute13 :=
701: p_old_rtg_header_rec.attribute13;

Line 704: IF p_rtg_header_rec.attribute14 = FND_API.G_MISS_CHAR OR

700: x_rtg_header_rec.attribute13 :=
701: p_old_rtg_header_rec.attribute13;
702: END IF;
703:
704: IF p_rtg_header_rec.attribute14 = FND_API.G_MISS_CHAR OR
705: p_rtg_header_rec.attribute14 IS NULL
706: THEN
707: x_rtg_header_rec.attribute14 :=
708: p_old_rtg_header_rec.attribute14;

Line 711: IF p_rtg_header_rec.attribute15 = FND_API.G_MISS_CHAR OR

707: x_rtg_header_rec.attribute14 :=
708: p_old_rtg_header_rec.attribute14;
709: END IF;
710:
711: IF p_rtg_header_rec.attribute15 = FND_API.G_MISS_CHAR OR
712: p_rtg_header_rec.attribute15 IS NULL
713: THEN
714: x_rtg_header_rec.attribute15 :=
715: p_old_rtg_header_rec.attribute15;

Line 725: IF p_rtg_header_unexp_rec.Common_Assembly_Item_Id = FND_API.G_MISS_NUM

721: --
722: x_rtg_header_unexp_rec.routing_sequence_id
723: := p_old_rtg_header_unexp_rec.routing_sequence_id;
724:
725: IF p_rtg_header_unexp_rec.Common_Assembly_Item_Id = FND_API.G_MISS_NUM
726: OR p_rtg_header_unexp_rec.Common_Assembly_Item_Id IS NULL
727: THEN
728: x_rtg_header_unexp_rec.Common_Assembly_Item_Id
729: := p_old_rtg_header_unexp_rec.Common_Assembly_Item_Id ;

Line 732: IF p_rtg_header_unexp_rec.Common_Routing_Sequence_Id = FND_API.G_MISS_NUM

728: x_rtg_header_unexp_rec.Common_Assembly_Item_Id
729: := p_old_rtg_header_unexp_rec.Common_Assembly_Item_Id ;
730: END IF ;
731:
732: IF p_rtg_header_unexp_rec.Common_Routing_Sequence_Id = FND_API.G_MISS_NUM
733: OR p_rtg_header_unexp_rec.Common_Routing_Sequence_Id IS NULL
734: THEN
735: x_rtg_header_unexp_rec.Common_Routing_Sequence_Id
736: := p_old_rtg_header_unexp_rec.Common_Routing_Sequence_Id ;

Line 739: IF p_rtg_header_unexp_rec.Line_Id = FND_API.G_MISS_NUM

735: x_rtg_header_unexp_rec.Common_Routing_Sequence_Id
736: := p_old_rtg_header_unexp_rec.Common_Routing_Sequence_Id ;
737: END IF ;
738:
739: IF p_rtg_header_unexp_rec.Line_Id = FND_API.G_MISS_NUM
740: OR p_rtg_header_unexp_rec.Line_Id IS NULL
741: THEN
742:
743: x_rtg_header_unexp_rec.Line_Id

Line 780: AND p_rtg_header_unexp_rec.Completion_Locator_Id = FND_API.G_MISS_NUM

776: p_old_rtg_header_unexp_rec.Completion_Locator_Id
777: OR
778: (
779: p_rtg_header_unexp_rec.Completion_Locator_Id IS NOT NULL
780: AND p_rtg_header_unexp_rec.Completion_Locator_Id = FND_API.G_MISS_NUM
781: )
782: )
783: )
784: THEN

Line 791: AND p_rtg_header_unexp_rec.Completion_Locator_Id = FND_API.G_MISS_NUM

787: (
788: p_rtg_header_rec.Completion_Subinventory IS NOT NULL
789: AND p_rtg_header_rec.Completion_Subinventory <>
790: p_old_rtg_header_rec.Completion_Subinventory
791: AND p_rtg_header_unexp_rec.Completion_Locator_Id = FND_API.G_MISS_NUM
792: )
793: THEN
794: x_rtg_header_unexp_rec.Completion_Locator_Id := NULL;
795: ELSIF