[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
X_Operation_Seq_Num NUMBER,
X_Component_Item_Id NUMBER,
X_Last_Update_Date DATE,
X_Last_Updated_By NUMBER,
X_Creation_Date DATE,
X_Created_By NUMBER,
X_Last_Update_Login NUMBER,
X_Item_Num NUMBER,
X_Basis_Type NUMBER,
X_Component_Quantity NUMBER,
X_Component_Yield_Factor NUMBER,
X_Disable_Date DATE,
X_To_End_Item_Unit_Number VARCHAR2,
X_Attribute_Category VARCHAR2,
X_Attribute1 VARCHAR2,
X_Attribute2 VARCHAR2,
X_Attribute3 VARCHAR2,
X_Attribute4 VARCHAR2,
X_Attribute5 VARCHAR2,
X_Attribute6 VARCHAR2,
X_Attribute7 VARCHAR2,
X_Attribute8 VARCHAR2,
X_Attribute9 VARCHAR2,
X_Attribute10 VARCHAR2,
X_Attribute11 VARCHAR2,
X_Attribute12 VARCHAR2,
X_Attribute13 VARCHAR2,
X_Attribute14 VARCHAR2,
X_Attribute15 VARCHAR2,
X_Planning_Factor NUMBER,
X_Quantity_Related NUMBER,
X_So_Basis NUMBER,
X_Optional NUMBER,
X_Mutually_Exclusive_Options NUMBER,
X_Include_In_Cost_Rollup NUMBER,
X_Check_Atp NUMBER,
X_Shipping_Allowed NUMBER,
X_Required_To_Ship NUMBER,
X_Required_For_Revenue NUMBER,
X_Include_On_Ship_Docs NUMBER,
X_Include_On_Bill_Docs NUMBER,
X_Low_Quantity NUMBER,
X_High_Quantity NUMBER,
X_Acd_Type NUMBER,
X_Old_Component_Sequence_Id NUMBER,
X_Component_Sequence_Id NUMBER,
X_Wip_Supply_Type NUMBER,
X_Supply_Subinventory VARCHAR2,
X_Supply_Locator_Id NUMBER,
X_Revised_Item_Sequence_Id NUMBER,
X_Cost_Factor NUMBER
) IS
-- This table has no primary key
l_Basis_Type NUMBER; -- 5214239
CURSOR C IS SELECT rowid FROM BOM_INVENTORY_COMPS_INTERFACE
WHERE component_sequence_id = X_Component_Sequence_Id;
INSERT INTO BOM_INVENTORY_COMPS_INTERFACE(
operation_seq_num,
component_item_id,
last_update_date,
last_updated_by,
creation_date,
created_by,
last_update_login,
item_num,
basis_type,
component_quantity,
component_yield_factor,
disable_date,
to_end_item_unit_number,
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
planning_factor,
quantity_related,
so_basis,
optional,
mutually_exclusive_options,
include_in_cost_rollup,
check_atp,
shipping_allowed,
required_to_ship,
required_for_revenue,
include_on_ship_docs,
include_on_bill_docs,
low_quantity,
high_quantity,
acd_type,
old_component_sequence_id,
component_sequence_id,
wip_supply_type,
supply_subinventory,
supply_locator_id,
revised_item_sequence_id,
cost_factor
) VALUES (
X_Operation_Seq_Num,
X_Component_Item_Id,
X_Last_Update_Date,
X_Last_Updated_By,
X_Creation_Date,
X_Created_By,
X_Last_Update_Login,
X_Item_Num,
l_Basis_Type, -- 5214239 X_Basis_Type,
X_Component_Quantity,
X_Component_Yield_Factor,
X_Disable_Date,
X_To_End_Item_Unit_Number,
X_Attribute_Category,
X_Attribute1,
X_Attribute2,
X_Attribute3,
X_Attribute4,
X_Attribute5,
X_Attribute6,
X_Attribute7,
X_Attribute8,
X_Attribute9,
X_Attribute10,
X_Attribute11,
X_Attribute12,
X_Attribute13,
X_Attribute14,
X_Attribute15,
X_Planning_Factor,
X_Quantity_Related,
X_So_Basis,
X_Optional,
X_Mutually_Exclusive_Options,
X_Include_In_Cost_Rollup,
X_Check_Atp,
X_Shipping_Allowed,
X_Required_To_Ship,
X_Required_For_Revenue,
X_Include_On_Ship_Docs,
X_Include_On_Bill_Docs,
X_Low_Quantity,
X_High_Quantity,
X_Acd_Type,
X_Old_Component_Sequence_Id,
X_Component_Sequence_Id,
X_Wip_Supply_Type,
X_Supply_Subinventory,
X_Supply_Locator_Id,
X_Revised_Item_Sequence_Id,
X_Cost_Factor
);
END Insert_Row;
SELECT Operation_Seq_Num,
Component_Item_Id,
Item_Num,
Decode(basis_type,FND_API.G_MISS_NUM,1,basis_type) basis_type, /* bug 9079784*/
Component_Quantity,
Component_Yield_Factor,
Disable_Date,
To_End_Item_Unit_Number,
Attribute_Category,
Attribute1,
Attribute2,
Attribute3,
Attribute4,
Attribute5,
Attribute6,
Attribute7,
Attribute8,
Attribute9,
Attribute10,
Attribute11,
Attribute12,
Attribute13,
Attribute14,
Attribute15,
Planning_Factor,
Quantity_Related,
So_Basis,
Optional,
Mutually_Exclusive_Options,
Include_In_Cost_Rollup,
Check_Atp,
Shipping_Allowed,
Required_To_Ship,
Required_For_Revenue,
Include_On_Ship_Docs,
Include_On_Bill_Docs,
Low_Quantity,
High_Quantity,
Acd_Type,
Old_Component_Sequence_Id,
Component_Sequence_Id,
Wip_Supply_Type,
Supply_Subinventory,
Supply_Locator_Id,
Revised_Item_Sequence_Id,
Cost_Factor
FROM bom_inventory_comps_interface
WHERE rowid = X_Rowid
FOR UPDATE OF Acd_Type NOWAIT;
FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
PROCEDURE Update_Row(X_Rowid VARCHAR2,
X_Operation_Seq_Num NUMBER,
X_Component_Item_Id NUMBER,
X_Last_Update_Date DATE,
X_Last_Updated_By NUMBER,
X_Last_Update_Login NUMBER,
X_Item_Num NUMBER,
X_Basis_Type NUMBER,
X_Component_Quantity NUMBER,
X_Component_Yield_Factor NUMBER,
X_Disable_Date DATE,
X_To_End_Item_Unit_Number VARCHAR2,
X_Attribute_Category VARCHAR2,
X_Attribute1 VARCHAR2,
X_Attribute2 VARCHAR2,
X_Attribute3 VARCHAR2,
X_Attribute4 VARCHAR2,
X_Attribute5 VARCHAR2,
X_Attribute6 VARCHAR2,
X_Attribute7 VARCHAR2,
X_Attribute8 VARCHAR2,
X_Attribute9 VARCHAR2,
X_Attribute10 VARCHAR2,
X_Attribute11 VARCHAR2,
X_Attribute12 VARCHAR2,
X_Attribute13 VARCHAR2,
X_Attribute14 VARCHAR2,
X_Attribute15 VARCHAR2,
X_Planning_Factor NUMBER,
X_Quantity_Related NUMBER,
X_So_Basis NUMBER,
X_Optional NUMBER,
X_Mutually_Exclusive_Options NUMBER,
X_Include_In_Cost_Rollup NUMBER,
X_Check_Atp NUMBER,
X_Shipping_Allowed NUMBER,
X_Required_To_Ship NUMBER,
X_Required_For_Revenue NUMBER,
X_Include_On_Ship_Docs NUMBER,
X_Include_On_Bill_Docs NUMBER,
X_Low_Quantity NUMBER,
X_High_Quantity NUMBER,
X_Acd_Type NUMBER,
X_Old_Component_Sequence_Id NUMBER,
X_Component_Sequence_Id NUMBER,
X_Wip_Supply_Type NUMBER,
X_Supply_Subinventory VARCHAR2,
X_Supply_Locator_Id NUMBER,
X_Revised_Item_Sequence_Id NUMBER,
X_Cost_Factor NUMBER
) IS
l_Basis_Type NUMBER; -- 5214239
UPDATE BOM_INVENTORY_COMPS_INTERFACE
SET
operation_seq_num = X_Operation_Seq_Num,
component_item_id = X_Component_Item_Id,
last_update_date = X_Last_Update_Date,
last_updated_by = X_Last_Updated_By,
last_update_login = X_Last_Update_Login,
item_num = X_Item_Num,
basis_type = l_Basis_Type, --5214239
component_quantity = X_Component_Quantity,
component_yield_factor = X_Component_Yield_Factor,
disable_date = X_Disable_Date,
to_end_item_unit_number = X_To_End_Item_Unit_Number,
attribute_category = X_Attribute_Category,
attribute1 = X_Attribute1,
attribute2 = X_Attribute2,
attribute3 = X_Attribute3,
attribute4 = X_Attribute4,
attribute5 = X_Attribute5,
attribute6 = X_Attribute6,
attribute7 = X_Attribute7,
attribute8 = X_Attribute8,
attribute9 = X_Attribute9,
attribute10 = X_Attribute10,
attribute11 = X_Attribute11,
attribute12 = X_Attribute12,
attribute13 = X_Attribute13,
attribute14 = X_Attribute14,
attribute15 = X_Attribute15,
planning_factor = X_Planning_Factor,
quantity_related = X_Quantity_Related,
so_basis = X_So_Basis,
optional = X_Optional,
mutually_exclusive_options = X_Mutually_Exclusive_Options,
include_in_cost_rollup = X_Include_In_Cost_Rollup,
check_atp = X_Check_Atp,
shipping_allowed = X_Shipping_Allowed,
required_to_ship = X_Required_To_Ship,
required_for_revenue = X_Required_For_Revenue,
include_on_ship_docs = X_Include_On_Ship_Docs,
include_on_bill_docs = X_Include_On_Bill_Docs,
low_quantity = X_Low_Quantity,
high_quantity = X_High_Quantity,
acd_type = X_Acd_Type,
old_component_sequence_id = X_Old_Component_Sequence_Id,
component_sequence_id = X_Component_Sequence_Id,
wip_supply_type = X_Wip_Supply_Type,
supply_subinventory = X_Supply_Subinventory,
supply_locator_id = X_Supply_Locator_Id,
revised_item_sequence_id = X_Revised_Item_Sequence_Id,
cost_factor = X_Cost_Factor
WHERE rowid = X_Rowid;
END Update_Row;
PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
BEGIN
DELETE FROM BOM_INVENTORY_COMPS_INTERFACE
WHERE rowid = X_Rowid;
END Delete_Row;