78: l_rev_op_resource_rec := p_rev_op_resource_rec ;
79:
80: -- In the future call Flex APIs for defaults
81:
82: IF l_rev_op_resource_rec.attribute_category = FND_API.G_MISS_CHAR THEN
83: l_rev_op_resource_rec.attribute_category := NULL;
84: END IF;
85:
86: IF l_rev_op_resource_rec.attribute1 = FND_API.G_MISS_CHAR THEN
82: IF l_rev_op_resource_rec.attribute_category = FND_API.G_MISS_CHAR THEN
83: l_rev_op_resource_rec.attribute_category := NULL;
84: END IF;
85:
86: IF l_rev_op_resource_rec.attribute1 = FND_API.G_MISS_CHAR THEN
87: l_rev_op_resource_rec.attribute1 := NULL;
88: END IF;
89:
90: IF l_rev_op_resource_rec.attribute2 = FND_API.G_MISS_CHAR THEN
86: IF l_rev_op_resource_rec.attribute1 = FND_API.G_MISS_CHAR THEN
87: l_rev_op_resource_rec.attribute1 := NULL;
88: END IF;
89:
90: IF l_rev_op_resource_rec.attribute2 = FND_API.G_MISS_CHAR THEN
91: l_rev_op_resource_rec.attribute2 := NULL;
92: END IF;
93:
94: IF l_rev_op_resource_rec.attribute3 = FND_API.G_MISS_CHAR THEN
90: IF l_rev_op_resource_rec.attribute2 = FND_API.G_MISS_CHAR THEN
91: l_rev_op_resource_rec.attribute2 := NULL;
92: END IF;
93:
94: IF l_rev_op_resource_rec.attribute3 = FND_API.G_MISS_CHAR THEN
95: l_rev_op_resource_rec.attribute3 := NULL;
96: END IF;
97:
98: IF l_rev_op_resource_rec.attribute4 = FND_API.G_MISS_CHAR THEN
94: IF l_rev_op_resource_rec.attribute3 = FND_API.G_MISS_CHAR THEN
95: l_rev_op_resource_rec.attribute3 := NULL;
96: END IF;
97:
98: IF l_rev_op_resource_rec.attribute4 = FND_API.G_MISS_CHAR THEN
99: l_rev_op_resource_rec.attribute4 := NULL;
100: END IF;
101:
102: IF l_rev_op_resource_rec.attribute5 = FND_API.G_MISS_CHAR THEN
98: IF l_rev_op_resource_rec.attribute4 = FND_API.G_MISS_CHAR THEN
99: l_rev_op_resource_rec.attribute4 := NULL;
100: END IF;
101:
102: IF l_rev_op_resource_rec.attribute5 = FND_API.G_MISS_CHAR THEN
103: l_rev_op_resource_rec.attribute5 := NULL;
104: END IF;
105:
106: IF l_rev_op_resource_rec.attribute6 = FND_API.G_MISS_CHAR THEN
102: IF l_rev_op_resource_rec.attribute5 = FND_API.G_MISS_CHAR THEN
103: l_rev_op_resource_rec.attribute5 := NULL;
104: END IF;
105:
106: IF l_rev_op_resource_rec.attribute6 = FND_API.G_MISS_CHAR THEN
107: l_rev_op_resource_rec.attribute6 := NULL;
108: END IF;
109:
110: IF l_rev_op_resource_rec.attribute7 = FND_API.G_MISS_CHAR THEN
106: IF l_rev_op_resource_rec.attribute6 = FND_API.G_MISS_CHAR THEN
107: l_rev_op_resource_rec.attribute6 := NULL;
108: END IF;
109:
110: IF l_rev_op_resource_rec.attribute7 = FND_API.G_MISS_CHAR THEN
111: l_rev_op_resource_rec.attribute7 := NULL;
112: END IF;
113:
114: IF l_rev_op_resource_rec.attribute8 = FND_API.G_MISS_CHAR THEN
110: IF l_rev_op_resource_rec.attribute7 = FND_API.G_MISS_CHAR THEN
111: l_rev_op_resource_rec.attribute7 := NULL;
112: END IF;
113:
114: IF l_rev_op_resource_rec.attribute8 = FND_API.G_MISS_CHAR THEN
115: l_rev_op_resource_rec.attribute8 := NULL;
116: END IF;
117:
118: IF l_rev_op_resource_rec.attribute9 = FND_API.G_MISS_CHAR THEN
114: IF l_rev_op_resource_rec.attribute8 = FND_API.G_MISS_CHAR THEN
115: l_rev_op_resource_rec.attribute8 := NULL;
116: END IF;
117:
118: IF l_rev_op_resource_rec.attribute9 = FND_API.G_MISS_CHAR THEN
119: l_rev_op_resource_rec.attribute9 := NULL;
120: END IF;
121:
122: IF l_rev_op_resource_rec.attribute10 = FND_API.G_MISS_CHAR THEN
118: IF l_rev_op_resource_rec.attribute9 = FND_API.G_MISS_CHAR THEN
119: l_rev_op_resource_rec.attribute9 := NULL;
120: END IF;
121:
122: IF l_rev_op_resource_rec.attribute10 = FND_API.G_MISS_CHAR THEN
123: l_rev_op_resource_rec.attribute10 := NULL;
124: END IF;
125:
126: IF l_rev_op_resource_rec.attribute11 = FND_API.G_MISS_CHAR THEN
122: IF l_rev_op_resource_rec.attribute10 = FND_API.G_MISS_CHAR THEN
123: l_rev_op_resource_rec.attribute10 := NULL;
124: END IF;
125:
126: IF l_rev_op_resource_rec.attribute11 = FND_API.G_MISS_CHAR THEN
127: l_rev_op_resource_rec.attribute11 := NULL;
128: END IF;
129:
130: IF l_rev_op_resource_rec.attribute12 = FND_API.G_MISS_CHAR THEN
126: IF l_rev_op_resource_rec.attribute11 = FND_API.G_MISS_CHAR THEN
127: l_rev_op_resource_rec.attribute11 := NULL;
128: END IF;
129:
130: IF l_rev_op_resource_rec.attribute12 = FND_API.G_MISS_CHAR THEN
131: l_rev_op_resource_rec.attribute12 := NULL;
132: END IF;
133:
134: IF l_rev_op_resource_rec.attribute13 = FND_API.G_MISS_CHAR THEN
130: IF l_rev_op_resource_rec.attribute12 = FND_API.G_MISS_CHAR THEN
131: l_rev_op_resource_rec.attribute12 := NULL;
132: END IF;
133:
134: IF l_rev_op_resource_rec.attribute13 = FND_API.G_MISS_CHAR THEN
135: l_rev_op_resource_rec.attribute13 := NULL;
136: END IF;
137:
138: IF l_rev_op_resource_rec.attribute14 = FND_API.G_MISS_CHAR THEN
134: IF l_rev_op_resource_rec.attribute13 = FND_API.G_MISS_CHAR THEN
135: l_rev_op_resource_rec.attribute13 := NULL;
136: END IF;
137:
138: IF l_rev_op_resource_rec.attribute14 = FND_API.G_MISS_CHAR THEN
139: l_rev_op_resource_rec.attribute14 := NULL;
140: END IF;
141:
142: IF l_rev_op_resource_rec.attribute15 = FND_API.G_MISS_CHAR THEN
138: IF l_rev_op_resource_rec.attribute14 = FND_API.G_MISS_CHAR THEN
139: l_rev_op_resource_rec.attribute14 := NULL;
140: END IF;
141:
142: IF l_rev_op_resource_rec.attribute15 = FND_API.G_MISS_CHAR THEN
143: l_rev_op_resource_rec.attribute15 := NULL;
144: END IF;
145:
146: x_rev_op_resource_rec := l_rev_op_resource_rec ;
161: x_usage_inverse NUMBER := NULL ;
162:
163: BEGIN
164:
165: IF ( ( NVL(p_usage_rate_or_amount, FND_API.G_MISS_NUM)
166: = FND_API.G_MISS_NUM )
167: AND ( NVL(p_usage_rate_or_amount_inverse, FND_API.G_MISS_NUM)
168: = FND_API.G_MISS_NUM)
169: )
162:
163: BEGIN
164:
165: IF ( ( NVL(p_usage_rate_or_amount, FND_API.G_MISS_NUM)
166: = FND_API.G_MISS_NUM )
167: AND ( NVL(p_usage_rate_or_amount_inverse, FND_API.G_MISS_NUM)
168: = FND_API.G_MISS_NUM)
169: )
170: THEN
163: BEGIN
164:
165: IF ( ( NVL(p_usage_rate_or_amount, FND_API.G_MISS_NUM)
166: = FND_API.G_MISS_NUM )
167: AND ( NVL(p_usage_rate_or_amount_inverse, FND_API.G_MISS_NUM)
168: = FND_API.G_MISS_NUM)
169: )
170: THEN
171: x_usage_rate_or_amount := 1 ;
164:
165: IF ( ( NVL(p_usage_rate_or_amount, FND_API.G_MISS_NUM)
166: = FND_API.G_MISS_NUM )
167: AND ( NVL(p_usage_rate_or_amount_inverse, FND_API.G_MISS_NUM)
168: = FND_API.G_MISS_NUM)
169: )
170: THEN
171: x_usage_rate_or_amount := 1 ;
172: x_usage_rate_or_amount_inverse := 1 ;
172: x_usage_rate_or_amount_inverse := 1 ;
173:
174: ELSIF
175: ( p_usage_rate_or_amount_inverse IS NULL )
176: OR ((p_usage_rate_or_amount_inverse = FND_API.G_MISS_NUM)
177: AND(p_usage_rate_or_amount <> FND_API.G_MISS_NUM)
178: )
179: THEN
180: IF p_usage_rate_or_amount = 0 THEN
173:
174: ELSIF
175: ( p_usage_rate_or_amount_inverse IS NULL )
176: OR ((p_usage_rate_or_amount_inverse = FND_API.G_MISS_NUM)
177: AND(p_usage_rate_or_amount <> FND_API.G_MISS_NUM)
178: )
179: THEN
180: IF p_usage_rate_or_amount = 0 THEN
181: x_usage_rate_or_amount := p_usage_rate_or_amount ;
200: END IF ;
201:
202: ELSIF
203: ( p_usage_rate_or_amount IS NULL )
204: OR ((p_usage_rate_or_amount = FND_API.G_MISS_NUM)
205: AND(p_usage_rate_or_amount_inverse <> FND_API.G_MISS_NUM )
206: )
207: THEN
208: IF p_usage_rate_or_amount_inverse = 0 THEN
201:
202: ELSIF
203: ( p_usage_rate_or_amount IS NULL )
204: OR ((p_usage_rate_or_amount = FND_API.G_MISS_NUM)
205: AND(p_usage_rate_or_amount_inverse <> FND_API.G_MISS_NUM )
206: )
207: THEN
208: IF p_usage_rate_or_amount_inverse = 0 THEN
209: x_usage_rate_or_amount := 0 ;
273: BEGIN
274: FOR l_res_attr_rec IN l_res_attr_csr ( p_op_seq_id => p_operation_sequence_id
275: , p_res_id => p_resource_id )
276: LOOP
277: IF ( p_activity_id IS NULL OR p_activity_id = FND_API.G_MISS_NUM )
278: THEN
279: x_activity_id := l_res_attr_rec.activity_id ;
280: ELSE
281: x_activity_id := p_activity_id ;
280: ELSE
281: x_activity_id := p_activity_id ;
282: END IF ;
283:
284: IF p_autocharge_type IS NULL OR p_autocharge_type = FND_API.G_MISS_NUM
285: THEN
286: x_autocharge_type := l_res_attr_rec.default_autocharge ;
287: ELSE
288: x_autocharge_type := p_autocharge_type ;
287: ELSE
288: x_autocharge_type := p_autocharge_type ;
289: END IF ;
290:
291: IF p_basis_type IS NULL OR p_basis_type = FND_API.G_MISS_NUM
292: THEN
293: x_basis_type := NVL(l_res_attr_rec.default_basis_type,1) ;
294: ELSE
295: x_basis_type := p_basis_type ;
294: ELSE
295: x_basis_type := p_basis_type ;
296: END IF ;
297:
298: IF p_standard_rate_flag IS NULL OR p_standard_rate_flag = FND_API.G_MISS_NUM
299: THEN
300:
301: x_standard_rate_flag := NVL(l_res_attr_rec.standard_rate_flag,1) ;
302:
384: l_rev_op_res_unexp_rec Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type ;
385:
386: BEGIN
387:
388: x_return_status := FND_API.G_RET_STS_SUCCESS;
389:
390: -- Convert Routing Op Resource to ECO Op Resource
391: Bom_Rtg_Pub.Convert_RtgRes_To_EcoRes
392: ( p_rtg_op_resource_rec => p_op_resource_rec
458: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug
459: ('Within the Operation Resource Attr. Defaulting...') ;
460: END IF ;
461:
462: x_return_status := FND_API.G_RET_STS_SUCCESS ;
463:
464: -- Initialize operation exp and unexp record
465: l_rev_op_resource_rec := p_rev_op_resource_rec ;
466: l_rev_op_res_unexp_rec := p_rev_op_res_unexp_rec ;
471: -- Default Assigned_Units
472: --
473: ***********************************************************/
474: IF l_rev_op_resource_rec.assigned_units IS NULL OR
475: l_rev_op_resource_rec.assigned_units = FND_API.G_MISS_NUM
476: THEN
477: l_rev_op_resource_rec.assigned_units :=
478: Get_Assigned_Units ;
479: END IF ;
486: --
487: ***********************************************************/
488:
489: IF l_rev_op_resource_rec.schedule_flag IS NULL OR
490: l_rev_op_resource_rec.schedule_flag = FND_API.G_MISS_NUM
491: THEN
492: l_rev_op_resource_rec.schedule_flag :=
493: Get_Schedule_Flag ;
494: END IF;
499: --
500: ************************************************************/
501:
502: IF l_rev_op_resource_rec.principle_flag IS NULL OR
503: l_rev_op_resource_rec.principle_flag = FND_API.G_MISS_NUM
504: THEN
505: l_rev_op_resource_rec.principle_flag :=
506: Get_Principle_Flag ;
507: END IF;
513: -- Default Operation Sequence's FlexFields
514: --
515: ************************************************************/
516:
517: IF l_rev_op_resource_rec.attribute_category = FND_API.G_MISS_CHAR
518: OR l_rev_op_resource_rec.attribute1 = FND_API.G_MISS_CHAR
519: OR l_rev_op_resource_rec.attribute2 = FND_API.G_MISS_CHAR
520: OR l_rev_op_resource_rec.attribute3 = FND_API.G_MISS_CHAR
521: OR l_rev_op_resource_rec.attribute4 = FND_API.G_MISS_CHAR
514: --
515: ************************************************************/
516:
517: IF l_rev_op_resource_rec.attribute_category = FND_API.G_MISS_CHAR
518: OR l_rev_op_resource_rec.attribute1 = FND_API.G_MISS_CHAR
519: OR l_rev_op_resource_rec.attribute2 = FND_API.G_MISS_CHAR
520: OR l_rev_op_resource_rec.attribute3 = FND_API.G_MISS_CHAR
521: OR l_rev_op_resource_rec.attribute4 = FND_API.G_MISS_CHAR
522: OR l_rev_op_resource_rec.attribute5 = FND_API.G_MISS_CHAR
515: ************************************************************/
516:
517: IF l_rev_op_resource_rec.attribute_category = FND_API.G_MISS_CHAR
518: OR l_rev_op_resource_rec.attribute1 = FND_API.G_MISS_CHAR
519: OR l_rev_op_resource_rec.attribute2 = FND_API.G_MISS_CHAR
520: OR l_rev_op_resource_rec.attribute3 = FND_API.G_MISS_CHAR
521: OR l_rev_op_resource_rec.attribute4 = FND_API.G_MISS_CHAR
522: OR l_rev_op_resource_rec.attribute5 = FND_API.G_MISS_CHAR
523: OR l_rev_op_resource_rec.attribute6 = FND_API.G_MISS_CHAR
516:
517: IF l_rev_op_resource_rec.attribute_category = FND_API.G_MISS_CHAR
518: OR l_rev_op_resource_rec.attribute1 = FND_API.G_MISS_CHAR
519: OR l_rev_op_resource_rec.attribute2 = FND_API.G_MISS_CHAR
520: OR l_rev_op_resource_rec.attribute3 = FND_API.G_MISS_CHAR
521: OR l_rev_op_resource_rec.attribute4 = FND_API.G_MISS_CHAR
522: OR l_rev_op_resource_rec.attribute5 = FND_API.G_MISS_CHAR
523: OR l_rev_op_resource_rec.attribute6 = FND_API.G_MISS_CHAR
524: OR l_rev_op_resource_rec.attribute7 = FND_API.G_MISS_CHAR
517: IF l_rev_op_resource_rec.attribute_category = FND_API.G_MISS_CHAR
518: OR l_rev_op_resource_rec.attribute1 = FND_API.G_MISS_CHAR
519: OR l_rev_op_resource_rec.attribute2 = FND_API.G_MISS_CHAR
520: OR l_rev_op_resource_rec.attribute3 = FND_API.G_MISS_CHAR
521: OR l_rev_op_resource_rec.attribute4 = FND_API.G_MISS_CHAR
522: OR l_rev_op_resource_rec.attribute5 = FND_API.G_MISS_CHAR
523: OR l_rev_op_resource_rec.attribute6 = FND_API.G_MISS_CHAR
524: OR l_rev_op_resource_rec.attribute7 = FND_API.G_MISS_CHAR
525: OR l_rev_op_resource_rec.attribute8 = FND_API.G_MISS_CHAR
518: OR l_rev_op_resource_rec.attribute1 = FND_API.G_MISS_CHAR
519: OR l_rev_op_resource_rec.attribute2 = FND_API.G_MISS_CHAR
520: OR l_rev_op_resource_rec.attribute3 = FND_API.G_MISS_CHAR
521: OR l_rev_op_resource_rec.attribute4 = FND_API.G_MISS_CHAR
522: OR l_rev_op_resource_rec.attribute5 = FND_API.G_MISS_CHAR
523: OR l_rev_op_resource_rec.attribute6 = FND_API.G_MISS_CHAR
524: OR l_rev_op_resource_rec.attribute7 = FND_API.G_MISS_CHAR
525: OR l_rev_op_resource_rec.attribute8 = FND_API.G_MISS_CHAR
526: OR l_rev_op_resource_rec.attribute9 = FND_API.G_MISS_CHAR
519: OR l_rev_op_resource_rec.attribute2 = FND_API.G_MISS_CHAR
520: OR l_rev_op_resource_rec.attribute3 = FND_API.G_MISS_CHAR
521: OR l_rev_op_resource_rec.attribute4 = FND_API.G_MISS_CHAR
522: OR l_rev_op_resource_rec.attribute5 = FND_API.G_MISS_CHAR
523: OR l_rev_op_resource_rec.attribute6 = FND_API.G_MISS_CHAR
524: OR l_rev_op_resource_rec.attribute7 = FND_API.G_MISS_CHAR
525: OR l_rev_op_resource_rec.attribute8 = FND_API.G_MISS_CHAR
526: OR l_rev_op_resource_rec.attribute9 = FND_API.G_MISS_CHAR
527: OR l_rev_op_resource_rec.attribute10 = FND_API.G_MISS_CHAR
520: OR l_rev_op_resource_rec.attribute3 = FND_API.G_MISS_CHAR
521: OR l_rev_op_resource_rec.attribute4 = FND_API.G_MISS_CHAR
522: OR l_rev_op_resource_rec.attribute5 = FND_API.G_MISS_CHAR
523: OR l_rev_op_resource_rec.attribute6 = FND_API.G_MISS_CHAR
524: OR l_rev_op_resource_rec.attribute7 = FND_API.G_MISS_CHAR
525: OR l_rev_op_resource_rec.attribute8 = FND_API.G_MISS_CHAR
526: OR l_rev_op_resource_rec.attribute9 = FND_API.G_MISS_CHAR
527: OR l_rev_op_resource_rec.attribute10 = FND_API.G_MISS_CHAR
528: OR l_rev_op_resource_rec.attribute11 = FND_API.G_MISS_CHAR
521: OR l_rev_op_resource_rec.attribute4 = FND_API.G_MISS_CHAR
522: OR l_rev_op_resource_rec.attribute5 = FND_API.G_MISS_CHAR
523: OR l_rev_op_resource_rec.attribute6 = FND_API.G_MISS_CHAR
524: OR l_rev_op_resource_rec.attribute7 = FND_API.G_MISS_CHAR
525: OR l_rev_op_resource_rec.attribute8 = FND_API.G_MISS_CHAR
526: OR l_rev_op_resource_rec.attribute9 = FND_API.G_MISS_CHAR
527: OR l_rev_op_resource_rec.attribute10 = FND_API.G_MISS_CHAR
528: OR l_rev_op_resource_rec.attribute11 = FND_API.G_MISS_CHAR
529: OR l_rev_op_resource_rec.attribute12 = FND_API.G_MISS_CHAR
522: OR l_rev_op_resource_rec.attribute5 = FND_API.G_MISS_CHAR
523: OR l_rev_op_resource_rec.attribute6 = FND_API.G_MISS_CHAR
524: OR l_rev_op_resource_rec.attribute7 = FND_API.G_MISS_CHAR
525: OR l_rev_op_resource_rec.attribute8 = FND_API.G_MISS_CHAR
526: OR l_rev_op_resource_rec.attribute9 = FND_API.G_MISS_CHAR
527: OR l_rev_op_resource_rec.attribute10 = FND_API.G_MISS_CHAR
528: OR l_rev_op_resource_rec.attribute11 = FND_API.G_MISS_CHAR
529: OR l_rev_op_resource_rec.attribute12 = FND_API.G_MISS_CHAR
530: OR l_rev_op_resource_rec.attribute13 = FND_API.G_MISS_CHAR
523: OR l_rev_op_resource_rec.attribute6 = FND_API.G_MISS_CHAR
524: OR l_rev_op_resource_rec.attribute7 = FND_API.G_MISS_CHAR
525: OR l_rev_op_resource_rec.attribute8 = FND_API.G_MISS_CHAR
526: OR l_rev_op_resource_rec.attribute9 = FND_API.G_MISS_CHAR
527: OR l_rev_op_resource_rec.attribute10 = FND_API.G_MISS_CHAR
528: OR l_rev_op_resource_rec.attribute11 = FND_API.G_MISS_CHAR
529: OR l_rev_op_resource_rec.attribute12 = FND_API.G_MISS_CHAR
530: OR l_rev_op_resource_rec.attribute13 = FND_API.G_MISS_CHAR
531: OR l_rev_op_resource_rec.attribute14 = FND_API.G_MISS_CHAR
524: OR l_rev_op_resource_rec.attribute7 = FND_API.G_MISS_CHAR
525: OR l_rev_op_resource_rec.attribute8 = FND_API.G_MISS_CHAR
526: OR l_rev_op_resource_rec.attribute9 = FND_API.G_MISS_CHAR
527: OR l_rev_op_resource_rec.attribute10 = FND_API.G_MISS_CHAR
528: OR l_rev_op_resource_rec.attribute11 = FND_API.G_MISS_CHAR
529: OR l_rev_op_resource_rec.attribute12 = FND_API.G_MISS_CHAR
530: OR l_rev_op_resource_rec.attribute13 = FND_API.G_MISS_CHAR
531: OR l_rev_op_resource_rec.attribute14 = FND_API.G_MISS_CHAR
532: OR l_rev_op_resource_rec.attribute15 = FND_API.G_MISS_CHAR
525: OR l_rev_op_resource_rec.attribute8 = FND_API.G_MISS_CHAR
526: OR l_rev_op_resource_rec.attribute9 = FND_API.G_MISS_CHAR
527: OR l_rev_op_resource_rec.attribute10 = FND_API.G_MISS_CHAR
528: OR l_rev_op_resource_rec.attribute11 = FND_API.G_MISS_CHAR
529: OR l_rev_op_resource_rec.attribute12 = FND_API.G_MISS_CHAR
530: OR l_rev_op_resource_rec.attribute13 = FND_API.G_MISS_CHAR
531: OR l_rev_op_resource_rec.attribute14 = FND_API.G_MISS_CHAR
532: OR l_rev_op_resource_rec.attribute15 = FND_API.G_MISS_CHAR
533: THEN
526: OR l_rev_op_resource_rec.attribute9 = FND_API.G_MISS_CHAR
527: OR l_rev_op_resource_rec.attribute10 = FND_API.G_MISS_CHAR
528: OR l_rev_op_resource_rec.attribute11 = FND_API.G_MISS_CHAR
529: OR l_rev_op_resource_rec.attribute12 = FND_API.G_MISS_CHAR
530: OR l_rev_op_resource_rec.attribute13 = FND_API.G_MISS_CHAR
531: OR l_rev_op_resource_rec.attribute14 = FND_API.G_MISS_CHAR
532: OR l_rev_op_resource_rec.attribute15 = FND_API.G_MISS_CHAR
533: THEN
534:
527: OR l_rev_op_resource_rec.attribute10 = FND_API.G_MISS_CHAR
528: OR l_rev_op_resource_rec.attribute11 = FND_API.G_MISS_CHAR
529: OR l_rev_op_resource_rec.attribute12 = FND_API.G_MISS_CHAR
530: OR l_rev_op_resource_rec.attribute13 = FND_API.G_MISS_CHAR
531: OR l_rev_op_resource_rec.attribute14 = FND_API.G_MISS_CHAR
532: OR l_rev_op_resource_rec.attribute15 = FND_API.G_MISS_CHAR
533: THEN
534:
535: Get_Flex_Op_Res( p_rev_op_resource_rec => l_rev_op_resource_rec
528: OR l_rev_op_resource_rec.attribute11 = FND_API.G_MISS_CHAR
529: OR l_rev_op_resource_rec.attribute12 = FND_API.G_MISS_CHAR
530: OR l_rev_op_resource_rec.attribute13 = FND_API.G_MISS_CHAR
531: OR l_rev_op_resource_rec.attribute14 = FND_API.G_MISS_CHAR
532: OR l_rev_op_resource_rec.attribute15 = FND_API.G_MISS_CHAR
533: THEN
534:
535: Get_Flex_Op_Res( p_rev_op_resource_rec => l_rev_op_resource_rec
536: , x_rev_op_resource_rec => l_rev_op_resource_rec ) ;
563: , x_mesg_token_tbl => l_mesg_token_tbl
564: ) ;
565:
566: -- Return the status and message table.
567: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
568: x_mesg_token_tbl := l_mesg_token_tbl ;
569:
570:
571: END Attribute_Defaulting ;
878: END IF;
879:
880:
881: IF l_rev_op_resource_rec.Substitute_Group_Number IS NULL
882: OR l_rev_op_resource_rec.Substitute_Group_Number = FND_API.G_MISS_NUM
883: THEN
884: l_rev_op_resource_rec.Substitute_Group_Number
885: := p_old_rev_op_resource_rec.Substitute_Group_Number ;
886: END IF ;
886: END IF ;
887: l_rev_op_res_unexp_rec.Substitute_Group_Number := l_rev_op_resource_rec.Substitute_Group_Number;
888:
889: IF l_rev_op_res_unexp_rec.Resource_Id IS NULL
890: OR l_rev_op_res_unexp_rec.Resource_Id = FND_API.G_MISS_NUM
891: THEN
892: l_rev_op_res_unexp_rec.Resource_Id
893: := p_old_rev_op_res_unexp_rec.Resource_Id ;
894: END IF ;
893: := p_old_rev_op_res_unexp_rec.Resource_Id ;
894: END IF ;
895:
896: IF l_rev_op_res_unexp_rec.Activity_Id IS NULL
897: OR l_rev_op_res_unexp_rec.Activity_Id = FND_API.G_MISS_NUM
898: THEN
899: l_rev_op_res_unexp_rec.Activity_Id
900: := p_old_rev_op_res_unexp_rec.Activity_Id ;
901: END IF ;
901: END IF ;
902:
903:
904: IF l_rev_op_res_unexp_rec.Setup_Id IS NULL
905: OR l_rev_op_res_unexp_rec.Setup_Id = FND_API.G_MISS_NUM
906: THEN
907: l_rev_op_res_unexp_rec.Setup_Id
908: := p_old_rev_op_res_unexp_rec.Setup_Id ;
909: END IF ;
946: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
947:
948: BEGIN
949:
950: x_return_status := FND_API.G_RET_STS_SUCCESS;
951:
952: --
953: -- The record definition of Revised Op Resource in ECO BO is
954: -- slightly different than the Op Resource definition of RTG BO
1026: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug
1027: ('Within the Operation Resource Entity Defaulting...') ;
1028: END IF ;
1029:
1030: l_return_status := FND_API.G_RET_STS_SUCCESS;
1031: x_return_status := FND_API.G_RET_STS_SUCCESS;
1032:
1033: -- Initialize operation exp and unexp record
1034: l_rev_op_resource_rec := p_rev_op_resource_rec ;
1027: ('Within the Operation Resource Entity Defaulting...') ;
1028: END IF ;
1029:
1030: l_return_status := FND_API.G_RET_STS_SUCCESS;
1031: x_return_status := FND_API.G_RET_STS_SUCCESS;
1032:
1033: -- Initialize operation exp and unexp record
1034: l_rev_op_resource_rec := p_rev_op_resource_rec ;
1035: l_rev_op_res_unexp_rec := p_rev_op_res_unexp_rec ;
1040: -- Default Schedule_Sequence_Number and Substitute_Group_Number
1041: -- ( Copy from Schedule_Sequence_Number )
1042: ************************************************************/
1043:
1044: IF l_rev_op_resource_rec.schedule_sequence_number = FND_API.G_MISS_NUM
1045: THEN
1046: l_rev_op_resource_rec.schedule_sequence_number := NULL ;
1047: END IF ;
1048: l_rev_op_res_unexp_rec.substitute_group_number := l_rev_op_resource_rec.substitute_group_number;
1077: ************************************************************/
1078: IF l_rev_op_resource_rec.transaction_type = BOM_Rtg_Globals.G_OPR_CREATE
1079: AND
1080: ( l_rev_op_res_unexp_rec.activity_id IS NULL OR
1081: l_rev_op_res_unexp_rec.activity_id = FND_API.G_MISS_NUM OR
1082: l_rev_op_resource_rec.autocharge_type IS NULL OR
1083: l_rev_op_resource_rec.autocharge_type = FND_API.G_MISS_NUM OR
1084: l_rev_op_resource_rec.basis_type IS NULL OR
1085: l_rev_op_resource_rec.basis_type = FND_API.G_MISS_NUM OR
1079: AND
1080: ( l_rev_op_res_unexp_rec.activity_id IS NULL OR
1081: l_rev_op_res_unexp_rec.activity_id = FND_API.G_MISS_NUM OR
1082: l_rev_op_resource_rec.autocharge_type IS NULL OR
1083: l_rev_op_resource_rec.autocharge_type = FND_API.G_MISS_NUM OR
1084: l_rev_op_resource_rec.basis_type IS NULL OR
1085: l_rev_op_resource_rec.basis_type = FND_API.G_MISS_NUM OR
1086: l_rev_op_resource_rec.standard_rate_flag IS NULL OR
1087: l_rev_op_resource_rec.standard_rate_flag = FND_API.G_MISS_NUM
1081: l_rev_op_res_unexp_rec.activity_id = FND_API.G_MISS_NUM OR
1082: l_rev_op_resource_rec.autocharge_type IS NULL OR
1083: l_rev_op_resource_rec.autocharge_type = FND_API.G_MISS_NUM OR
1084: l_rev_op_resource_rec.basis_type IS NULL OR
1085: l_rev_op_resource_rec.basis_type = FND_API.G_MISS_NUM OR
1086: l_rev_op_resource_rec.standard_rate_flag IS NULL OR
1087: l_rev_op_resource_rec.standard_rate_flag = FND_API.G_MISS_NUM
1088: )
1089: THEN
1083: l_rev_op_resource_rec.autocharge_type = FND_API.G_MISS_NUM OR
1084: l_rev_op_resource_rec.basis_type IS NULL OR
1085: l_rev_op_resource_rec.basis_type = FND_API.G_MISS_NUM OR
1086: l_rev_op_resource_rec.standard_rate_flag IS NULL OR
1087: l_rev_op_resource_rec.standard_rate_flag = FND_API.G_MISS_NUM
1088: )
1089: THEN
1090: Get_Res_Attributes
1091: ( p_operation_sequence_id => l_rev_op_res_unexp_rec.operation_sequence_id
1190: --
1191: -- Set missing column values to Null
1192: --
1193: ************************************************************/
1194: IF l_rev_op_resource_rec.activity = FND_API.G_MISS_CHAR
1195: OR l_rev_op_res_unexp_rec.activity_id = FND_API.G_MISS_NUM
1196: THEN
1197: l_rev_op_resource_rec.activity := NULL ;
1198: l_rev_op_res_unexp_rec.activity_id := NULL ;
1191: -- Set missing column values to Null
1192: --
1193: ************************************************************/
1194: IF l_rev_op_resource_rec.activity = FND_API.G_MISS_CHAR
1195: OR l_rev_op_res_unexp_rec.activity_id = FND_API.G_MISS_NUM
1196: THEN
1197: l_rev_op_resource_rec.activity := NULL ;
1198: l_rev_op_res_unexp_rec.activity_id := NULL ;
1199: END IF ;
1198: l_rev_op_res_unexp_rec.activity_id := NULL ;
1199: END IF ;
1200:
1201:
1202: IF l_rev_op_resource_rec.setup_type = FND_API.G_MISS_CHAR
1203: OR l_rev_op_res_unexp_rec.setup_id = FND_API.G_MISS_NUM
1204: THEN
1205: l_rev_op_resource_rec.setup_type := NULL ;
1206: l_rev_op_res_unexp_rec.setup_id := NULL ;
1199: END IF ;
1200:
1201:
1202: IF l_rev_op_resource_rec.setup_type = FND_API.G_MISS_CHAR
1203: OR l_rev_op_res_unexp_rec.setup_id = FND_API.G_MISS_NUM
1204: THEN
1205: l_rev_op_resource_rec.setup_type := NULL ;
1206: l_rev_op_res_unexp_rec.setup_id := NULL ;
1207: END IF ;
1206: l_rev_op_res_unexp_rec.setup_id := NULL ;
1207: END IF ;
1208:
1209:
1210: IF l_rev_op_resource_rec.resource_offset_percent = FND_API.G_MISS_NUM
1211: THEN
1212: l_rev_op_resource_rec.resource_offset_percent := NULL ;
1213: END IF ;
1214:
1211: THEN
1212: l_rev_op_resource_rec.resource_offset_percent := NULL ;
1213: END IF ;
1214:
1215: IF l_rev_op_resource_rec.principle_flag = FND_API.G_MISS_NUM
1216: THEN
1217: l_rev_op_resource_rec.principle_flag := NULL ;
1218: END IF ;
1219:
1218: END IF ;
1219:
1220:
1221: -- FlexFields
1222: IF l_rev_op_resource_rec.attribute_category = FND_API.G_MISS_CHAR THEN
1223: l_rev_op_resource_rec.attribute_category := NULL ;
1224: END IF;
1225:
1226: IF l_rev_op_resource_rec.attribute1 = FND_API.G_MISS_CHAR THEN
1222: IF l_rev_op_resource_rec.attribute_category = FND_API.G_MISS_CHAR THEN
1223: l_rev_op_resource_rec.attribute_category := NULL ;
1224: END IF;
1225:
1226: IF l_rev_op_resource_rec.attribute1 = FND_API.G_MISS_CHAR THEN
1227: l_rev_op_resource_rec.attribute1 := NULL ;
1228: END IF;
1229:
1230: IF l_rev_op_resource_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1226: IF l_rev_op_resource_rec.attribute1 = FND_API.G_MISS_CHAR THEN
1227: l_rev_op_resource_rec.attribute1 := NULL ;
1228: END IF;
1229:
1230: IF l_rev_op_resource_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1231: l_rev_op_resource_rec.attribute2 := NULL ;
1232: END IF;
1233:
1234: IF l_rev_op_resource_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1230: IF l_rev_op_resource_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1231: l_rev_op_resource_rec.attribute2 := NULL ;
1232: END IF;
1233:
1234: IF l_rev_op_resource_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1235: l_rev_op_resource_rec.attribute3 := NULL ;
1236: END IF;
1237:
1238: IF l_rev_op_resource_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1234: IF l_rev_op_resource_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1235: l_rev_op_resource_rec.attribute3 := NULL ;
1236: END IF;
1237:
1238: IF l_rev_op_resource_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1239: l_rev_op_resource_rec.attribute4 := NULL ;
1240: END IF;
1241:
1242: IF l_rev_op_resource_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1238: IF l_rev_op_resource_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1239: l_rev_op_resource_rec.attribute4 := NULL ;
1240: END IF;
1241:
1242: IF l_rev_op_resource_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1243: l_rev_op_resource_rec.attribute5 := NULL ;
1244: END IF;
1245:
1246: IF l_rev_op_resource_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1242: IF l_rev_op_resource_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1243: l_rev_op_resource_rec.attribute5 := NULL ;
1244: END IF;
1245:
1246: IF l_rev_op_resource_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1247: l_rev_op_resource_rec.attribute6 := NULL ;
1248: END IF;
1249:
1250: IF l_rev_op_resource_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1246: IF l_rev_op_resource_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1247: l_rev_op_resource_rec.attribute6 := NULL ;
1248: END IF;
1249:
1250: IF l_rev_op_resource_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1251: l_rev_op_resource_rec.attribute7 := NULL ;
1252: END IF;
1253:
1254: IF l_rev_op_resource_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1250: IF l_rev_op_resource_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1251: l_rev_op_resource_rec.attribute7 := NULL ;
1252: END IF;
1253:
1254: IF l_rev_op_resource_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1255: l_rev_op_resource_rec.attribute8 := NULL ;
1256: END IF;
1257:
1258: IF l_rev_op_resource_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1254: IF l_rev_op_resource_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1255: l_rev_op_resource_rec.attribute8 := NULL ;
1256: END IF;
1257:
1258: IF l_rev_op_resource_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1259: l_rev_op_resource_rec.attribute9 := NULL ;
1260: END IF;
1261:
1262: IF l_rev_op_resource_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1258: IF l_rev_op_resource_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1259: l_rev_op_resource_rec.attribute9 := NULL ;
1260: END IF;
1261:
1262: IF l_rev_op_resource_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1263: l_rev_op_resource_rec.attribute10 := NULL ;
1264: END IF;
1265:
1266: IF l_rev_op_resource_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1262: IF l_rev_op_resource_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1263: l_rev_op_resource_rec.attribute10 := NULL ;
1264: END IF;
1265:
1266: IF l_rev_op_resource_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1267: l_rev_op_resource_rec.attribute11 := NULL ;
1268: END IF;
1269:
1270: IF l_rev_op_resource_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1266: IF l_rev_op_resource_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1267: l_rev_op_resource_rec.attribute11 := NULL ;
1268: END IF;
1269:
1270: IF l_rev_op_resource_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1271: l_rev_op_resource_rec.attribute12 := NULL ;
1272: END IF;
1273:
1274: IF l_rev_op_resource_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1270: IF l_rev_op_resource_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1271: l_rev_op_resource_rec.attribute12 := NULL ;
1272: END IF;
1273:
1274: IF l_rev_op_resource_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1275: l_rev_op_resource_rec.attribute13 := NULL ;
1276: END IF;
1277:
1278: IF l_rev_op_resource_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1274: IF l_rev_op_resource_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1275: l_rev_op_resource_rec.attribute13 := NULL ;
1276: END IF;
1277:
1278: IF l_rev_op_resource_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1279: l_rev_op_resource_rec.attribute14 := NULL ;
1280: END IF;
1281:
1282: IF l_rev_op_resource_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1278: IF l_rev_op_resource_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1279: l_rev_op_resource_rec.attribute14 := NULL ;
1280: END IF;
1281:
1282: IF l_rev_op_resource_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1283: l_rev_op_resource_rec.attribute15 := NULL ;
1284: END IF;
1285:
1286: -- Return the status and message table.
1309: , x_mesg_token_tbl => l_mesg_token_tbl
1310: ) ;
1311:
1312: -- Return the status and message table.
1313: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1314: x_mesg_token_tbl := l_mesg_token_tbl ;
1315:
1316: END Entity_Defaulting ;
1317: