72: 'Substitute Component Attribute Validation ' ||
73: TO_CHAR(SQLCODE) || ' ' || SUBSTR(SQLERRM, 1, 100)
74: );
75: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
76: RETURN FND_API.G_RET_STS_UNEXP_ERROR;
77:
78: END Get_Substitute_Item_Quantity;
79:
80: PROCEDURE Get_Flex_Sub_Component
82: BEGIN
83:
84: -- In the future call Flex APIs for defaults
85:
86: IF g_sub_component_rec.attribute_category = FND_API.G_MISS_CHAR THEN
87: g_sub_component_rec.attribute_category := NULL;
88: END IF;
89:
90: IF g_sub_component_rec.attribute1 = FND_API.G_MISS_CHAR THEN
86: IF g_sub_component_rec.attribute_category = FND_API.G_MISS_CHAR THEN
87: g_sub_component_rec.attribute_category := NULL;
88: END IF;
89:
90: IF g_sub_component_rec.attribute1 = FND_API.G_MISS_CHAR THEN
91: g_sub_component_rec.attribute1 := NULL;
92: END IF;
93:
94: IF g_sub_component_rec.attribute2 = FND_API.G_MISS_CHAR THEN
90: IF g_sub_component_rec.attribute1 = FND_API.G_MISS_CHAR THEN
91: g_sub_component_rec.attribute1 := NULL;
92: END IF;
93:
94: IF g_sub_component_rec.attribute2 = FND_API.G_MISS_CHAR THEN
95: g_sub_component_rec.attribute2 := NULL;
96: END IF;
97:
98: IF g_sub_component_rec.attribute4 = FND_API.G_MISS_CHAR THEN
94: IF g_sub_component_rec.attribute2 = FND_API.G_MISS_CHAR THEN
95: g_sub_component_rec.attribute2 := NULL;
96: END IF;
97:
98: IF g_sub_component_rec.attribute4 = FND_API.G_MISS_CHAR THEN
99: g_sub_component_rec.attribute4 := NULL;
100: END IF;
101:
102: IF g_sub_component_rec.attribute5 = FND_API.G_MISS_CHAR THEN
98: IF g_sub_component_rec.attribute4 = FND_API.G_MISS_CHAR THEN
99: g_sub_component_rec.attribute4 := NULL;
100: END IF;
101:
102: IF g_sub_component_rec.attribute5 = FND_API.G_MISS_CHAR THEN
103: g_sub_component_rec.attribute5 := NULL;
104: END IF;
105:
106: IF g_sub_component_rec.attribute6 = FND_API.G_MISS_CHAR THEN
102: IF g_sub_component_rec.attribute5 = FND_API.G_MISS_CHAR THEN
103: g_sub_component_rec.attribute5 := NULL;
104: END IF;
105:
106: IF g_sub_component_rec.attribute6 = FND_API.G_MISS_CHAR THEN
107: g_sub_component_rec.attribute6 := NULL;
108: END IF;
109:
110: IF g_sub_component_rec.attribute8 = FND_API.G_MISS_CHAR THEN
106: IF g_sub_component_rec.attribute6 = FND_API.G_MISS_CHAR THEN
107: g_sub_component_rec.attribute6 := NULL;
108: END IF;
109:
110: IF g_sub_component_rec.attribute8 = FND_API.G_MISS_CHAR THEN
111: g_sub_component_rec.attribute8 := NULL;
112: END IF;
113:
114: IF g_sub_component_rec.attribute9 = FND_API.G_MISS_CHAR THEN
110: IF g_sub_component_rec.attribute8 = FND_API.G_MISS_CHAR THEN
111: g_sub_component_rec.attribute8 := NULL;
112: END IF;
113:
114: IF g_sub_component_rec.attribute9 = FND_API.G_MISS_CHAR THEN
115: g_sub_component_rec.attribute9 := NULL;
116: END IF;
117:
118: IF g_sub_component_rec.attribute10 = FND_API.G_MISS_CHAR THEN
114: IF g_sub_component_rec.attribute9 = FND_API.G_MISS_CHAR THEN
115: g_sub_component_rec.attribute9 := NULL;
116: END IF;
117:
118: IF g_sub_component_rec.attribute10 = FND_API.G_MISS_CHAR THEN
119: g_sub_component_rec.attribute10 := NULL;
120: END IF;
121:
122: IF g_sub_component_rec.attribute12 = FND_API.G_MISS_CHAR THEN
118: IF g_sub_component_rec.attribute10 = FND_API.G_MISS_CHAR THEN
119: g_sub_component_rec.attribute10 := NULL;
120: END IF;
121:
122: IF g_sub_component_rec.attribute12 = FND_API.G_MISS_CHAR THEN
123: g_sub_component_rec.attribute12 := NULL;
124: END IF;
125:
126: IF g_sub_component_rec.attribute13 = FND_API.G_MISS_CHAR THEN
122: IF g_sub_component_rec.attribute12 = FND_API.G_MISS_CHAR THEN
123: g_sub_component_rec.attribute12 := NULL;
124: END IF;
125:
126: IF g_sub_component_rec.attribute13 = FND_API.G_MISS_CHAR THEN
127: g_sub_component_rec.attribute13 := NULL;
128: END IF;
129:
130: IF g_sub_component_rec.attribute14 = FND_API.G_MISS_CHAR THEN
126: IF g_sub_component_rec.attribute13 = FND_API.G_MISS_CHAR THEN
127: g_sub_component_rec.attribute13 := NULL;
128: END IF;
129:
130: IF g_sub_component_rec.attribute14 = FND_API.G_MISS_CHAR THEN
131: g_sub_component_rec.attribute14 := NULL;
132: END IF;
133:
134: IF g_sub_component_rec.attribute15 = FND_API.G_MISS_CHAR THEN
130: IF g_sub_component_rec.attribute14 = FND_API.G_MISS_CHAR THEN
131: g_sub_component_rec.attribute14 := NULL;
132: END IF;
133:
134: IF g_sub_component_rec.attribute15 = FND_API.G_MISS_CHAR THEN
135: g_sub_component_rec.attribute15 := NULL;
136: END IF;
137:
138: IF g_sub_component_rec.attribute3 = FND_API.G_MISS_CHAR THEN
134: IF g_sub_component_rec.attribute15 = FND_API.G_MISS_CHAR THEN
135: g_sub_component_rec.attribute15 := NULL;
136: END IF;
137:
138: IF g_sub_component_rec.attribute3 = FND_API.G_MISS_CHAR THEN
139: g_sub_component_rec.attribute3 := NULL;
140: END IF;
141:
142: IF g_sub_component_rec.attribute7 = FND_API.G_MISS_CHAR THEN
138: IF g_sub_component_rec.attribute3 = FND_API.G_MISS_CHAR THEN
139: g_sub_component_rec.attribute3 := NULL;
140: END IF;
141:
142: IF g_sub_component_rec.attribute7 = FND_API.G_MISS_CHAR THEN
143: g_sub_component_rec.attribute7 := NULL;
144: END IF;
145:
146: IF g_sub_component_rec.attribute11 = FND_API.G_MISS_CHAR THEN
142: IF g_sub_component_rec.attribute7 = FND_API.G_MISS_CHAR THEN
143: g_sub_component_rec.attribute7 := NULL;
144: END IF;
145:
146: IF g_sub_component_rec.attribute11 = FND_API.G_MISS_CHAR THEN
147: g_sub_component_rec.attribute11 := NULL;
148: END IF;
149:
150: END Get_Flex_Sub_Component;
205: BEGIN
206:
207: -- Initialize g_sub_component_rec
208:
209: x_return_status := FND_API.G_RET_STS_SUCCESS;
210:
211:
212: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Comp Seq in attrib Defaulting ' || p_Sub_Comp_Unexp_Rec.component_sequence_id); END IF;
213:
220: x_sub_comp_unexp_rec.enforce_int_requirements_code := 0;
221: END IF;
222:
223: stmt_num := 2;
224: IF g_sub_component_rec.substitute_item_quantity = FND_API.G_MISS_NUM OR
225: g_sub_component_rec.substitute_item_quantity IS NULL THEN
226:
227: -- Check if Inverse_Quanity value is available. If not default it from component.
228: IF g_sub_component_rec.Inverse_Quantity = FND_API.G_MISS_NUM OR
224: IF g_sub_component_rec.substitute_item_quantity = FND_API.G_MISS_NUM OR
225: g_sub_component_rec.substitute_item_quantity IS NULL THEN
226:
227: -- Check if Inverse_Quanity value is available. If not default it from component.
228: IF g_sub_component_rec.Inverse_Quantity = FND_API.G_MISS_NUM OR
229: g_sub_component_rec.Inverse_Quantity IS NULL THEN
230:
231: g_sub_component_rec.substitute_item_quantity :=
232: Get_Substitute_Item_Quantity
236: );
237: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Quantity Defaulted to : ' || to_char(g_sub_component_rec.substitute_item_quantity)); END IF;
238:
239:
240: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
241: g_sub_component_rec.substitute_item_quantity := 0;
242: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
243: END IF;
244: ELSE
238:
239:
240: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
241: g_sub_component_rec.substitute_item_quantity := 0;
242: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
243: END IF;
244: ELSE
245: IF g_sub_component_rec.Inverse_Quantity = 0 THEN
246: g_sub_component_rec.substitute_item_quantity := 0;
249: END IF;
250: END IF;
251: END IF;
252:
253: IF g_sub_component_rec.acd_type = FND_API.G_MISS_NUM THEN
254: g_sub_component_rec.acd_type := NULL;
255: END IF;
256: /* bug2758790, form defaults the enforce req code to 0 and value to 'none' */
257:
254: g_sub_component_rec.acd_type := NULL;
255: END IF;
256: /* bug2758790, form defaults the enforce req code to 0 and value to 'none' */
257:
258: IF (g_sub_component_rec.enforce_int_requirements = FND_API.G_MISS_CHAR
259: or g_sub_component_rec.enforce_int_requirements is NULL )THEN
260: g_sub_component_rec.enforce_int_requirements :=
261: Get_EnforceInteger_Value(p_enforce_integer => 0);
262: END IF;
262: END IF;
263:
264:
265: stmt_num :=3;
266: IF g_sub_component_rec.attribute_category = FND_API.G_MISS_CHAR
267: OR g_sub_component_rec.attribute1 = FND_API.G_MISS_CHAR
268: OR g_sub_component_rec.attribute2 = FND_API.G_MISS_CHAR
269: OR g_sub_component_rec.attribute4 = FND_API.G_MISS_CHAR
270: OR g_sub_component_rec.attribute5 = FND_API.G_MISS_CHAR
263:
264:
265: stmt_num :=3;
266: IF g_sub_component_rec.attribute_category = FND_API.G_MISS_CHAR
267: OR g_sub_component_rec.attribute1 = FND_API.G_MISS_CHAR
268: OR g_sub_component_rec.attribute2 = FND_API.G_MISS_CHAR
269: OR g_sub_component_rec.attribute4 = FND_API.G_MISS_CHAR
270: OR g_sub_component_rec.attribute5 = FND_API.G_MISS_CHAR
271: OR g_sub_component_rec.attribute6 = FND_API.G_MISS_CHAR
264:
265: stmt_num :=3;
266: IF g_sub_component_rec.attribute_category = FND_API.G_MISS_CHAR
267: OR g_sub_component_rec.attribute1 = FND_API.G_MISS_CHAR
268: OR g_sub_component_rec.attribute2 = FND_API.G_MISS_CHAR
269: OR g_sub_component_rec.attribute4 = FND_API.G_MISS_CHAR
270: OR g_sub_component_rec.attribute5 = FND_API.G_MISS_CHAR
271: OR g_sub_component_rec.attribute6 = FND_API.G_MISS_CHAR
272: OR g_sub_component_rec.attribute8 = FND_API.G_MISS_CHAR
265: stmt_num :=3;
266: IF g_sub_component_rec.attribute_category = FND_API.G_MISS_CHAR
267: OR g_sub_component_rec.attribute1 = FND_API.G_MISS_CHAR
268: OR g_sub_component_rec.attribute2 = FND_API.G_MISS_CHAR
269: OR g_sub_component_rec.attribute4 = FND_API.G_MISS_CHAR
270: OR g_sub_component_rec.attribute5 = FND_API.G_MISS_CHAR
271: OR g_sub_component_rec.attribute6 = FND_API.G_MISS_CHAR
272: OR g_sub_component_rec.attribute8 = FND_API.G_MISS_CHAR
273: OR g_sub_component_rec.attribute9 = FND_API.G_MISS_CHAR
266: IF g_sub_component_rec.attribute_category = FND_API.G_MISS_CHAR
267: OR g_sub_component_rec.attribute1 = FND_API.G_MISS_CHAR
268: OR g_sub_component_rec.attribute2 = FND_API.G_MISS_CHAR
269: OR g_sub_component_rec.attribute4 = FND_API.G_MISS_CHAR
270: OR g_sub_component_rec.attribute5 = FND_API.G_MISS_CHAR
271: OR g_sub_component_rec.attribute6 = FND_API.G_MISS_CHAR
272: OR g_sub_component_rec.attribute8 = FND_API.G_MISS_CHAR
273: OR g_sub_component_rec.attribute9 = FND_API.G_MISS_CHAR
274: OR g_sub_component_rec.attribute10 = FND_API.G_MISS_CHAR
267: OR g_sub_component_rec.attribute1 = FND_API.G_MISS_CHAR
268: OR g_sub_component_rec.attribute2 = FND_API.G_MISS_CHAR
269: OR g_sub_component_rec.attribute4 = FND_API.G_MISS_CHAR
270: OR g_sub_component_rec.attribute5 = FND_API.G_MISS_CHAR
271: OR g_sub_component_rec.attribute6 = FND_API.G_MISS_CHAR
272: OR g_sub_component_rec.attribute8 = FND_API.G_MISS_CHAR
273: OR g_sub_component_rec.attribute9 = FND_API.G_MISS_CHAR
274: OR g_sub_component_rec.attribute10 = FND_API.G_MISS_CHAR
275: OR g_sub_component_rec.attribute12 = FND_API.G_MISS_CHAR
268: OR g_sub_component_rec.attribute2 = FND_API.G_MISS_CHAR
269: OR g_sub_component_rec.attribute4 = FND_API.G_MISS_CHAR
270: OR g_sub_component_rec.attribute5 = FND_API.G_MISS_CHAR
271: OR g_sub_component_rec.attribute6 = FND_API.G_MISS_CHAR
272: OR g_sub_component_rec.attribute8 = FND_API.G_MISS_CHAR
273: OR g_sub_component_rec.attribute9 = FND_API.G_MISS_CHAR
274: OR g_sub_component_rec.attribute10 = FND_API.G_MISS_CHAR
275: OR g_sub_component_rec.attribute12 = FND_API.G_MISS_CHAR
276: OR g_sub_component_rec.attribute13 = FND_API.G_MISS_CHAR
269: OR g_sub_component_rec.attribute4 = FND_API.G_MISS_CHAR
270: OR g_sub_component_rec.attribute5 = FND_API.G_MISS_CHAR
271: OR g_sub_component_rec.attribute6 = FND_API.G_MISS_CHAR
272: OR g_sub_component_rec.attribute8 = FND_API.G_MISS_CHAR
273: OR g_sub_component_rec.attribute9 = FND_API.G_MISS_CHAR
274: OR g_sub_component_rec.attribute10 = FND_API.G_MISS_CHAR
275: OR g_sub_component_rec.attribute12 = FND_API.G_MISS_CHAR
276: OR g_sub_component_rec.attribute13 = FND_API.G_MISS_CHAR
277: OR g_sub_component_rec.attribute14 = FND_API.G_MISS_CHAR
270: OR g_sub_component_rec.attribute5 = FND_API.G_MISS_CHAR
271: OR g_sub_component_rec.attribute6 = FND_API.G_MISS_CHAR
272: OR g_sub_component_rec.attribute8 = FND_API.G_MISS_CHAR
273: OR g_sub_component_rec.attribute9 = FND_API.G_MISS_CHAR
274: OR g_sub_component_rec.attribute10 = FND_API.G_MISS_CHAR
275: OR g_sub_component_rec.attribute12 = FND_API.G_MISS_CHAR
276: OR g_sub_component_rec.attribute13 = FND_API.G_MISS_CHAR
277: OR g_sub_component_rec.attribute14 = FND_API.G_MISS_CHAR
278: OR g_sub_component_rec.attribute15 = FND_API.G_MISS_CHAR
271: OR g_sub_component_rec.attribute6 = FND_API.G_MISS_CHAR
272: OR g_sub_component_rec.attribute8 = FND_API.G_MISS_CHAR
273: OR g_sub_component_rec.attribute9 = FND_API.G_MISS_CHAR
274: OR g_sub_component_rec.attribute10 = FND_API.G_MISS_CHAR
275: OR g_sub_component_rec.attribute12 = FND_API.G_MISS_CHAR
276: OR g_sub_component_rec.attribute13 = FND_API.G_MISS_CHAR
277: OR g_sub_component_rec.attribute14 = FND_API.G_MISS_CHAR
278: OR g_sub_component_rec.attribute15 = FND_API.G_MISS_CHAR
279: OR g_sub_component_rec.attribute3 = FND_API.G_MISS_CHAR
272: OR g_sub_component_rec.attribute8 = FND_API.G_MISS_CHAR
273: OR g_sub_component_rec.attribute9 = FND_API.G_MISS_CHAR
274: OR g_sub_component_rec.attribute10 = FND_API.G_MISS_CHAR
275: OR g_sub_component_rec.attribute12 = FND_API.G_MISS_CHAR
276: OR g_sub_component_rec.attribute13 = FND_API.G_MISS_CHAR
277: OR g_sub_component_rec.attribute14 = FND_API.G_MISS_CHAR
278: OR g_sub_component_rec.attribute15 = FND_API.G_MISS_CHAR
279: OR g_sub_component_rec.attribute3 = FND_API.G_MISS_CHAR
280: OR g_sub_component_rec.attribute7 = FND_API.G_MISS_CHAR
273: OR g_sub_component_rec.attribute9 = FND_API.G_MISS_CHAR
274: OR g_sub_component_rec.attribute10 = FND_API.G_MISS_CHAR
275: OR g_sub_component_rec.attribute12 = FND_API.G_MISS_CHAR
276: OR g_sub_component_rec.attribute13 = FND_API.G_MISS_CHAR
277: OR g_sub_component_rec.attribute14 = FND_API.G_MISS_CHAR
278: OR g_sub_component_rec.attribute15 = FND_API.G_MISS_CHAR
279: OR g_sub_component_rec.attribute3 = FND_API.G_MISS_CHAR
280: OR g_sub_component_rec.attribute7 = FND_API.G_MISS_CHAR
281: OR g_sub_component_rec.attribute11 = FND_API.G_MISS_CHAR
274: OR g_sub_component_rec.attribute10 = FND_API.G_MISS_CHAR
275: OR g_sub_component_rec.attribute12 = FND_API.G_MISS_CHAR
276: OR g_sub_component_rec.attribute13 = FND_API.G_MISS_CHAR
277: OR g_sub_component_rec.attribute14 = FND_API.G_MISS_CHAR
278: OR g_sub_component_rec.attribute15 = FND_API.G_MISS_CHAR
279: OR g_sub_component_rec.attribute3 = FND_API.G_MISS_CHAR
280: OR g_sub_component_rec.attribute7 = FND_API.G_MISS_CHAR
281: OR g_sub_component_rec.attribute11 = FND_API.G_MISS_CHAR
282: THEN
275: OR g_sub_component_rec.attribute12 = FND_API.G_MISS_CHAR
276: OR g_sub_component_rec.attribute13 = FND_API.G_MISS_CHAR
277: OR g_sub_component_rec.attribute14 = FND_API.G_MISS_CHAR
278: OR g_sub_component_rec.attribute15 = FND_API.G_MISS_CHAR
279: OR g_sub_component_rec.attribute3 = FND_API.G_MISS_CHAR
280: OR g_sub_component_rec.attribute7 = FND_API.G_MISS_CHAR
281: OR g_sub_component_rec.attribute11 = FND_API.G_MISS_CHAR
282: THEN
283:
276: OR g_sub_component_rec.attribute13 = FND_API.G_MISS_CHAR
277: OR g_sub_component_rec.attribute14 = FND_API.G_MISS_CHAR
278: OR g_sub_component_rec.attribute15 = FND_API.G_MISS_CHAR
279: OR g_sub_component_rec.attribute3 = FND_API.G_MISS_CHAR
280: OR g_sub_component_rec.attribute7 = FND_API.G_MISS_CHAR
281: OR g_sub_component_rec.attribute11 = FND_API.G_MISS_CHAR
282: THEN
283:
284: Get_Flex_Sub_Component;
277: OR g_sub_component_rec.attribute14 = FND_API.G_MISS_CHAR
278: OR g_sub_component_rec.attribute15 = FND_API.G_MISS_CHAR
279: OR g_sub_component_rec.attribute3 = FND_API.G_MISS_CHAR
280: OR g_sub_component_rec.attribute7 = FND_API.G_MISS_CHAR
281: OR g_sub_component_rec.attribute11 = FND_API.G_MISS_CHAR
282: THEN
283:
284: Get_Flex_Sub_Component;
285:
292: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Sub Comps Attrib Defaulting Done . . .'); END IF;
293:
294: EXCEPTION
295:
296: WHEN FND_API.G_EXC_ERROR THEN
297: -- dbms_output.put_line('default sub_comp : ' || to_char(stmt_num));
298: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
299: x_return_status := FND_API.G_RET_STS_ERROR;
300:
295:
296: WHEN FND_API.G_EXC_ERROR THEN
297: -- dbms_output.put_line('default sub_comp : ' || to_char(stmt_num));
298: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
299: x_return_status := FND_API.G_RET_STS_ERROR;
300:
301: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
302: -- dbms_output.put_line('default sub_comp : ' || to_char(stmt_num));
303: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
297: -- dbms_output.put_line('default sub_comp : ' || to_char(stmt_num));
298: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
299: x_return_status := FND_API.G_RET_STS_ERROR;
300:
301: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
302: -- dbms_output.put_line('default sub_comp : ' || to_char(stmt_num));
303: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
304: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
305:
300:
301: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
302: -- dbms_output.put_line('default sub_comp : ' || to_char(stmt_num));
303: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
304: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
305:
306: WHEN OTHERS THEN
307: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
308: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
303: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
304: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
305:
306: WHEN OTHERS THEN
307: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
308: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
309: -- dbms_output.put_line('default sub_comp : ' || to_char(stmt_num));
310:
311: END Attribute_Defaulting;
337: l_sub_comp_Unexp_rec Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type :=
338: p_old_sub_comp_Unexp_rec;
339: BEGIN
340:
341: IF (l_sub_component_rec.substitute_item_quantity = FND_API.G_MISS_NUM OR
342: l_sub_component_rec.substitute_item_quantity IS NULL)
343: THEN
344: IF (l_sub_component_rec.Inverse_Quantity = FND_API.G_MISS_NUM OR
345: l_sub_component_rec.Inverse_Quantity IS NULL)
340:
341: IF (l_sub_component_rec.substitute_item_quantity = FND_API.G_MISS_NUM OR
342: l_sub_component_rec.substitute_item_quantity IS NULL)
343: THEN
344: IF (l_sub_component_rec.Inverse_Quantity = FND_API.G_MISS_NUM OR
345: l_sub_component_rec.Inverse_Quantity IS NULL)
346: THEN
347: l_sub_component_rec.substitute_item_quantity :=
348: p_old_sub_component_rec.substitute_item_quantity;
439: If(p_sub_comp_unexp_rec.new_substitute_component_id is not null) then
440: l_sub_comp_unexp_rec.new_substitute_component_id :=p_sub_comp_unexp_rec.new_substitute_component_id;
441: end if;
442:
443: IF l_sub_component_rec.enforce_int_requirements = FND_API.G_MISS_CHAR THEN
444: l_sub_comp_unexp_rec.enforce_int_requirements_code := NULL;
445: l_sub_component_rec.enforce_int_requirements := NULL;
446: ELSIF l_sub_component_rec.enforce_int_requirements IS NULL THEN
447: l_sub_comp_unexp_rec.enforce_int_requirements_code := p_old_sub_comp_unexp_rec.enforce_int_requirements_code;