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 551: p_rtg_header_rec.eng_routing_flag = FND_API.G_MISS_NUM )

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

Line 565: OR p_rtg_header_rec.CFM_Routing_Flag = FND_API.G_MISS_NUM

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

Line 572: OR p_rtg_header_rec.Mixed_Model_Map_Flag = FND_API.G_MISS_NUM

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

Line 579: OR p_rtg_header_rec.CTP_Flag = FND_API.G_MISS_NUM

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

Line 607: p_rtg_header_rec.attribute_category = FND_API.G_MISS_CHAR

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

Line 614: IF /p_rtg_header_rec.attribute1 = FND_API.G_MISS_CHAR OR /Commented condition bug 7581065*/

610: p_old_rtg_header_rec.attribute_category;
611:
612: END IF;
613:
614: IF /*p_rtg_header_rec.attribute1 = FND_API.G_MISS_CHAR OR /*Commented condition bug 7581065*/
615: p_rtg_header_rec.attribute1 IS NULL
616: THEN
617: x_rtg_header_rec.attribute1 :=
618: p_old_rtg_header_rec.attribute1;

Line 621: IF /p_rtg_header_rec.attribute2 = FND_API.G_MISS_CHAR OR/Commented condition bug 7581065*/

617: x_rtg_header_rec.attribute1 :=
618: p_old_rtg_header_rec.attribute1;
619: END IF;
620:
621: IF /*p_rtg_header_rec.attribute2 = FND_API.G_MISS_CHAR OR/*Commented condition bug 7581065*/
622: p_rtg_header_rec.attribute2 IS NULL
623: THEN
624: x_rtg_header_rec.attribute2 :=
625: p_old_rtg_header_rec.attribute2;

Line 628: IF /p_rtg_header_rec.attribute3 = FND_API.G_MISS_CHAR OR/Commented condition bug 7581065*/

624: x_rtg_header_rec.attribute2 :=
625: p_old_rtg_header_rec.attribute2;
626: END IF;
627:
628: IF /*p_rtg_header_rec.attribute3 = FND_API.G_MISS_CHAR OR/*Commented condition bug 7581065*/
629: p_rtg_header_rec.attribute3 IS NULL
630: THEN
631: x_rtg_header_rec.attribute3 :=
632: p_old_rtg_header_rec.attribute3;

Line 635: IF /p_rtg_header_rec.attribute4 = FND_API.G_MISS_CHAR OR/Commented condition bug 7581065*/

631: x_rtg_header_rec.attribute3 :=
632: p_old_rtg_header_rec.attribute3;
633: END IF;
634:
635: IF /*p_rtg_header_rec.attribute4 = FND_API.G_MISS_CHAR OR/*Commented condition bug 7581065*/
636: p_rtg_header_rec.attribute4 IS NULL
637: THEN
638: x_rtg_header_rec.attribute4 :=
639: p_old_rtg_header_rec.attribute4;

Line 642: IF /p_rtg_header_rec.attribute5 = FND_API.G_MISS_CHAR OR/Commented condition bug 7581065*/

638: x_rtg_header_rec.attribute4 :=
639: p_old_rtg_header_rec.attribute4;
640: END IF;
641:
642: IF /*p_rtg_header_rec.attribute5 = FND_API.G_MISS_CHAR OR/*Commented condition bug 7581065*/
643: p_rtg_header_rec.attribute5 IS NULL
644: THEN
645: x_rtg_header_rec.attribute5 :=
646: p_old_rtg_header_rec.attribute5;

Line 649: IF /p_rtg_header_rec.attribute6 = FND_API.G_MISS_CHAR OR/Commented condition bug 7581065*/

645: x_rtg_header_rec.attribute5 :=
646: p_old_rtg_header_rec.attribute5;
647: END IF;
648:
649: IF /*p_rtg_header_rec.attribute6 = FND_API.G_MISS_CHAR OR/*Commented condition bug 7581065*/
650: p_rtg_header_rec.attribute6 IS NULL
651: THEN
652: x_rtg_header_rec.attribute6 :=
653: p_old_rtg_header_rec.attribute6;

Line 656: IF /p_rtg_header_rec.attribute7 = FND_API.G_MISS_CHAR OR/Commented condition bug 7581065*/

652: x_rtg_header_rec.attribute6 :=
653: p_old_rtg_header_rec.attribute6;
654: END IF;
655:
656: IF /*p_rtg_header_rec.attribute7 = FND_API.G_MISS_CHAR OR/*Commented condition bug 7581065*/
657: p_rtg_header_rec.attribute7 IS NULL
658: THEN
659: x_rtg_header_rec.attribute7 :=
660: p_old_rtg_header_rec.attribute7;

Line 663: IF /p_rtg_header_rec.attribute8 = FND_API.G_MISS_CHAR OR/Commented condition bug 7581065*/

659: x_rtg_header_rec.attribute7 :=
660: p_old_rtg_header_rec.attribute7;
661: END IF;
662:
663: IF /*p_rtg_header_rec.attribute8 = FND_API.G_MISS_CHAR OR/*Commented condition bug 7581065*/
664: p_rtg_header_rec.attribute8 IS NULL
665: THEN
666: x_rtg_header_rec.attribute8 :=
667: p_old_rtg_header_rec.attribute8;

Line 670: IF /p_rtg_header_rec.attribute9 = FND_API.G_MISS_CHAR OR/Commented condition bug 7581065*/

666: x_rtg_header_rec.attribute8 :=
667: p_old_rtg_header_rec.attribute8;
668: END IF;
669:
670: IF /*p_rtg_header_rec.attribute9 = FND_API.G_MISS_CHAR OR/*Commented condition bug 7581065*/
671: p_rtg_header_rec.attribute9 IS NULL
672: THEN
673: x_rtg_header_rec.attribute9 :=
674: p_old_rtg_header_rec.attribute9;

Line 677: IF /p_rtg_header_rec.attribute10 = FND_API.G_MISS_CHAR OR/Commented condition bug 7581065*/

673: x_rtg_header_rec.attribute9 :=
674: p_old_rtg_header_rec.attribute9;
675: END IF;
676:
677: IF /*p_rtg_header_rec.attribute10 = FND_API.G_MISS_CHAR OR/*Commented condition bug 7581065*/
678: p_rtg_header_rec.attribute10 IS NULL
679: THEN
680: x_rtg_header_rec.attribute10 :=
681: p_old_rtg_header_rec.attribute10;

Line 684: IF /p_rtg_header_rec.attribute11 = FND_API.G_MISS_CHAR OR/Commented condition bug 7581065*/

680: x_rtg_header_rec.attribute10 :=
681: p_old_rtg_header_rec.attribute10;
682: END IF;
683:
684: IF /*p_rtg_header_rec.attribute11 = FND_API.G_MISS_CHAR OR/*Commented condition bug 7581065*/
685: p_rtg_header_rec.attribute11 IS NULL
686: THEN
687: x_rtg_header_rec.attribute11 :=
688: p_old_rtg_header_rec.attribute11;

Line 691: IF /p_rtg_header_rec.attribute12 = FND_API.G_MISS_CHAR OR/Commented condition bug 7581065*/

687: x_rtg_header_rec.attribute11 :=
688: p_old_rtg_header_rec.attribute11;
689: END IF;
690:
691: IF /*p_rtg_header_rec.attribute12 = FND_API.G_MISS_CHAR OR/*Commented condition bug 7581065*/
692: p_rtg_header_rec.attribute12 IS NULL
693: THEN
694: x_rtg_header_rec.attribute12 :=
695: p_old_rtg_header_rec.attribute12;

Line 698: IF /p_rtg_header_rec.attribute13 = FND_API.G_MISS_CHAR OR/Commented condition bug 7581065*/

694: x_rtg_header_rec.attribute12 :=
695: p_old_rtg_header_rec.attribute12;
696: END IF;
697:
698: IF /*p_rtg_header_rec.attribute13 = FND_API.G_MISS_CHAR OR/*Commented condition bug 7581065*/
699: p_rtg_header_rec.attribute13 IS NULL
700: THEN
701: x_rtg_header_rec.attribute13 :=
702: p_old_rtg_header_rec.attribute13;

Line 705: IF /p_rtg_header_rec.attribute14 = FND_API.G_MISS_CHAR OR/Commented condition bug 7581065*/

701: x_rtg_header_rec.attribute13 :=
702: p_old_rtg_header_rec.attribute13;
703: END IF;
704:
705: IF /*p_rtg_header_rec.attribute14 = FND_API.G_MISS_CHAR OR/*Commented condition bug 7581065*/
706: p_rtg_header_rec.attribute14 IS NULL
707: THEN
708: x_rtg_header_rec.attribute14 :=
709: p_old_rtg_header_rec.attribute14;

Line 712: IF /p_rtg_header_rec.attribute15 = FND_API.G_MISS_CHAR OR/Commented condition bug 7581065*/

708: x_rtg_header_rec.attribute14 :=
709: p_old_rtg_header_rec.attribute14;
710: END IF;
711:
712: IF /*p_rtg_header_rec.attribute15 = FND_API.G_MISS_CHAR OR/*Commented condition bug 7581065*/
713: p_rtg_header_rec.attribute15 IS NULL
714: THEN
715: x_rtg_header_rec.attribute15 :=
716: 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