64:
65: BEGIN
66:
67: IF (X_Basis_Type <> 2) THEN -- 5214239
68: l_Basis_Type := FND_API.G_MISS_NUM;
69: ELSE l_Basis_Type := X_Basis_Type;
70: END IF;
71:
72: INSERT INTO BOM_INVENTORY_COMPS_INTERFACE(
236: CURSOR C IS
237: SELECT Operation_Seq_Num,
238: Component_Item_Id,
239: Item_Num,
240: Decode(basis_type,FND_API.G_MISS_NUM,1,basis_type) basis_type, /* bug 9079784*/
241: Component_Quantity,
242: Component_Yield_Factor,
243: Disable_Date,
244: To_End_Item_Unit_Number,
498: l_Basis_Type NUMBER; -- 5214239
499:
500: BEGIN
501: IF (X_Basis_Type <> 2) THEN -- 5214239
502: l_Basis_Type := FND_API.G_MISS_NUM;
503: ELSE l_Basis_Type := X_Basis_Type;
504: END IF;
505:
506: UPDATE BOM_INVENTORY_COMPS_INTERFACE