[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
X_Cycle_Count_Entry_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_Count_List_Sequence NUMBER,
X_Count_Date_First DATE,
X_Count_Date_Current DATE,
X_Count_Date_Prior DATE,
X_Count_Date_Dummy DATE,
X_Counted_By_Employee_Id_First NUMBER,
X_Counted_By_Employee_Id_Curr NUMBER,
X_Counted_By_Employee_Id_Prior NUMBER,
X_Counted_By_Employee_Id_Dummy NUMBER,
X_Count_Uom_First VARCHAR2,
X_Count_Uom_Current VARCHAR2,
X_Count_Uom_Prior VARCHAR2,
X_Count_Quantity_First NUMBER,
X_Count_Quantity_Current NUMBER,
X_Count_Quantity_Prior NUMBER,
X_Inventory_Item_Id NUMBER,
X_Subinventory VARCHAR2,
X_Entry_Status_Code NUMBER,
X_Count_Due_Date DATE,
X_Organization_Id NUMBER,
X_Cycle_Count_Header_Id NUMBER,
X_Number_Of_Counts NUMBER,
X_Locator_Id NUMBER,
X_Adjustment_Quantity NUMBER,
X_Adjustment_Date DATE,
X_Adjustment_Amount NUMBER,
X_Item_Unit_Cost NUMBER,
X_Inventory_Adjustment_Account NUMBER,
X_Approval_Date DATE,
X_Approver_Employee_Id NUMBER,
X_Revision VARCHAR2,
X_Lot_Number VARCHAR2,
X_Lot_Control VARCHAR2,
X_System_Quantity_First NUMBER,
X_System_Quantity_Current NUMBER,
X_System_Quantity_Prior NUMBER,
X_Reference_First VARCHAR2,
X_Reference_Current VARCHAR2,
X_Reference_Prior VARCHAR2,
X_Primary_Uom_Quantity_First NUMBER,
X_Primary_Uom_Quantity_Current NUMBER,
X_Primary_Uom_Quantity_Prior NUMBER,
X_Count_Type_Code NUMBER,
X_Transaction_Reason_Id NUMBER,
X_Approval_Type NUMBER,
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_Serial_Number VARCHAR2,
X_Serial_Detail NUMBER,
X_Approval_Condition NUMBER,
X_Neg_Adjustment_Quantity NUMBER,
X_Neg_Adjustment_Amount NUMBER,
X_Outermost_Lpn_ID NUMBER DEFAULT NULL,
X_Parent_Lpn_ID NUMBER DEFAULT NULL,
X_Cost_Group_ID NUMBER DEFAULT NULL,
-- BEGIN INVCONV
X_Count_Secondary_Uom_First VARCHAR2 DEFAULT NULL,
X_Count_Secondary_Uom_Current VARCHAR2 DEFAULT NULL,
X_Count_Secondary_Uom_Prior VARCHAR2 DEFAULT NULL,
X_Secondary_Uom_Quantity_First NUMBER DEFAULT NULL,
X_Secondary_Uom_Quantity_Curr NUMBER DEFAULT NULL,
X_Secondary_Uom_Quantity_Prior NUMBER DEFAULT NULL,
X_Secondary_System_Qty_First NUMBER DEFAULT NULL,
X_Secondary_System_Qty_Current NUMBER DEFAULT NULL,
X_Secondary_System_Qty_Prior NUMBER DEFAULT NULL,
X_Secondary_Adjustment_Qty NUMBER DEFAULT NULL
-- END INVCONV
) IS
CURSOR C IS SELECT rowid FROM mtl_cycle_count_entries
WHERE ( (cycle_count_header_id = X_Cycle_Count_Header_Id)
or (cycle_count_header_id is NULL and X_Cycle_Count_Header_Id is NULL));
INSERT INTO mtl_cycle_count_entries(
cycle_count_entry_id,
last_update_date,
last_updated_by,
creation_date,
created_by,
last_update_login,
count_list_sequence,
count_date_first,
count_date_current,
count_date_prior,
count_date_dummy,
counted_by_employee_id_first,
counted_by_employee_id_current,
counted_by_employee_id_prior,
counted_by_employee_id_dummy,
count_uom_first,
count_uom_current,
count_uom_prior,
count_quantity_first,
count_quantity_current,
count_quantity_prior,
inventory_item_id,
subinventory,
entry_status_code,
count_due_date,
organization_id,
cycle_count_header_id,
number_of_counts,
locator_id,
adjustment_quantity,
adjustment_date,
adjustment_amount,
item_unit_cost,
inventory_adjustment_account,
approval_date,
approver_employee_id,
revision,
lot_number,
lot_control,
system_quantity_first,
system_quantity_current,
system_quantity_prior,
reference_first,
reference_current,
reference_prior,
primary_uom_quantity_first,
primary_uom_quantity_current,
primary_uom_quantity_prior,
count_type_code,
transaction_reason_id,
approval_type,
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
serial_number,
serial_detail,
approval_condition,
neg_adjustment_quantity,
neg_adjustment_amount,
outermost_lpn_id,
parent_lpn_id,
cost_group_id,
-- BEGIN INVCONV
Count_Secondary_Uom_First,
Count_Secondary_Uom_Current,
Count_Secondary_Uom_Prior,
Secondary_Uom_Quantity_First,
Secondary_Uom_Quantity_Current,
Secondary_Uom_Quantity_Prior,
Secondary_System_Qty_First,
Secondary_System_Qty_Current,
Secondary_System_Qty_Prior,
Secondary_Adjustment_Quantity
-- END INVCONV
)
VALUES (
X_Cycle_Count_Entry_Id,
X_Last_Update_Date,
X_Last_Updated_By,
X_Creation_Date,
X_Created_By,
X_Last_Update_Login,
X_Count_List_Sequence,
X_Count_Date_First,
X_Count_Date_Current,
X_Count_Date_Prior,
X_Count_Date_Dummy,
X_Counted_By_Employee_Id_First,
X_Counted_By_Employee_Id_Curr,
X_Counted_By_Employee_Id_Prior,
X_Counted_By_Employee_Id_Dummy,
X_Count_Uom_First,
X_Count_Uom_Current,
X_Count_Uom_Prior,
X_Count_Quantity_First,
X_Count_Quantity_Current,
X_Count_Quantity_Prior,
X_Inventory_Item_Id,
X_Subinventory,
X_Entry_Status_Code,
X_Count_Due_Date,
X_Organization_Id,
X_Cycle_Count_Header_Id,
X_Number_Of_Counts,
X_Locator_Id,
X_Adjustment_Quantity,
X_Adjustment_Date,
X_Adjustment_Amount,
X_Item_Unit_Cost,
X_Inventory_Adjustment_Account,
X_Approval_Date,
X_Approver_Employee_Id,
X_Revision,
X_Lot_Number,
X_Lot_Control,
X_System_Quantity_First,
X_System_Quantity_Current,
X_System_Quantity_Prior,
X_Reference_First,
X_Reference_Current,
X_Reference_Prior,
X_Primary_Uom_Quantity_First,
X_Primary_Uom_Quantity_Current,
X_Primary_Uom_Quantity_Prior,
X_Count_Type_Code,
X_Transaction_Reason_Id,
X_Approval_Type,
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_Serial_Number,
X_Serial_Detail,
X_Approval_Condition,
X_Neg_Adjustment_Quantity,
X_Neg_Adjustment_Amount,
X_Outermost_Lpn_ID,
X_Parent_Lpn_ID,
X_Cost_Group_ID,
-- BEGIN INVCONV
X_Count_Secondary_Uom_First,
X_Count_Secondary_Uom_Current,
X_Count_Secondary_Uom_Prior,
X_Secondary_Uom_Quantity_First,
X_Secondary_Uom_Quantity_Curr,
X_Secondary_Uom_Quantity_Prior,
X_Secondary_System_Qty_First,
X_Secondary_System_Qty_Current,
X_Secondary_System_Qty_Prior,
X_Secondary_Adjustment_Qty
-- END INVCONV
);
END Insert_Row;
SELECT *
FROM mtl_cycle_count_entries
WHERE rowid = X_Rowid
FOR UPDATE of Cycle_Count_Header_Id NOWAIT;
FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
PROCEDURE Update_Row(X_Rowid VARCHAR2,
X_Cycle_Count_Entry_Id NUMBER,
X_Last_Update_Date DATE,
X_Last_Updated_By NUMBER,
X_Last_Update_Login NUMBER,
X_Count_List_Sequence NUMBER,
X_Count_Date_First DATE,
X_Count_Date_Current DATE,
X_Count_Date_Prior DATE,
X_Count_Date_Dummy DATE,
X_Counted_By_Employee_Id_First NUMBER,
X_Counted_By_Employee_Id_Curr NUMBER,
X_Counted_By_Employee_Id_Prior NUMBER,
X_Counted_By_Employee_Id_Dummy NUMBER,
X_Count_Uom_First VARCHAR2,
X_Count_Uom_Current VARCHAR2,
X_Count_Uom_Prior VARCHAR2,
X_Count_Quantity_First NUMBER,
X_Count_Quantity_Current NUMBER,
X_Count_Quantity_Prior NUMBER,
X_Inventory_Item_Id NUMBER,
X_Subinventory VARCHAR2,
X_Entry_Status_Code NUMBER,
X_Count_Due_Date DATE,
X_Organization_Id NUMBER,
X_Cycle_Count_Header_Id NUMBER,
X_Number_Of_Counts NUMBER,
X_Locator_Id NUMBER,
X_Adjustment_Quantity NUMBER,
X_Adjustment_Date DATE,
X_Adjustment_Amount NUMBER,
X_Item_Unit_Cost NUMBER,
X_Inventory_Adjustment_Account NUMBER,
X_Approval_Date DATE,
X_Approver_Employee_Id NUMBER,
X_Revision VARCHAR2,
X_Lot_Number VARCHAR2,
X_Lot_Control VARCHAR2,
X_System_Quantity_First NUMBER,
X_System_Quantity_Current NUMBER,
X_System_Quantity_Prior NUMBER,
X_Reference_First VARCHAR2,
X_Reference_Current VARCHAR2,
X_Reference_Prior VARCHAR2,
X_Primary_Uom_Quantity_First NUMBER,
X_Primary_Uom_Quantity_Current NUMBER,
X_Primary_Uom_Quantity_Prior NUMBER,
X_Count_Type_Code NUMBER,
X_Transaction_Reason_Id NUMBER,
X_Approval_Type NUMBER,
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_Serial_Number VARCHAR2,
X_Serial_Detail NUMBER,
X_Approval_Condition NUMBER,
X_Neg_Adjustment_Quantity NUMBER,
X_Neg_Adjustment_Amount NUMBER,
X_Outermost_Lpn_ID NUMBER DEFAULT NULL,
X_Parent_Lpn_ID NUMBER DEFAULT NULL,
X_Cost_Group_ID NUMBER DEFAULT NULL,
-- BEGIN INVCONV
X_Count_Secondary_Uom_First VARCHAR2 DEFAULT NULL,
X_Count_Secondary_Uom_Current VARCHAR2 DEFAULT NULL,
X_Count_Secondary_Uom_Prior VARCHAR2 DEFAULT NULL,
X_Secondary_Uom_Quantity_First NUMBER DEFAULT NULL,
X_Secondary_Uom_Quantity_Curr NUMBER DEFAULT NULL,
X_Secondary_Uom_Quantity_Prior NUMBER DEFAULT NULL,
X_Secondary_System_Qty_First NUMBER DEFAULT NULL,
X_Secondary_System_Qty_Current NUMBER DEFAULT NULL,
X_Secondary_System_Qty_Prior NUMBER DEFAULT NULL,
X_Secondary_Adjustment_Qty NUMBER DEFAULT NULL
-- END INVCONV
) IS
--Bug 6012343 -Added the following variables
l_standard_operation_id NUMBER;
SELECT STANDARD_OPERATION_ID
INTO l_standard_operation_id
FROM BOM_STANDARD_OPERATIONS
WHERE WMS_TASK_TYPE = 3
AND ORGANIZATION_ID = x_organization_id
AND ROWNUM = 1;
UPDATE mtl_cycle_count_entries
SET
cycle_count_entry_id = X_Cycle_Count_Entry_Id,
last_update_date = X_Last_Update_Date,
last_updated_by = X_Last_Updated_By,
last_update_login = X_Last_Update_Login,
count_list_sequence = X_Count_List_Sequence,
count_date_first = X_Count_Date_First,
count_date_current = X_Count_Date_Current,
count_date_prior = X_Count_Date_Prior,
count_date_dummy = X_Count_Date_Dummy,
counted_by_employee_id_first = X_Counted_By_Employee_Id_First,
counted_by_employee_id_current = X_Counted_By_Employee_Id_Curr,
counted_by_employee_id_prior = X_Counted_By_Employee_Id_Prior,
counted_by_employee_id_dummy = X_Counted_By_Employee_Id_Dummy,
count_uom_first = X_Count_Uom_First,
count_uom_current = X_Count_Uom_Current,
count_uom_prior = X_Count_Uom_Prior,
count_quantity_first = X_Count_Quantity_First,
count_quantity_current = X_Count_Quantity_Current,
count_quantity_prior = X_Count_Quantity_Prior,
inventory_item_id = X_Inventory_Item_Id,
subinventory = X_Subinventory,
entry_status_code = X_Entry_Status_Code,
count_due_date = X_Count_Due_Date,
organization_id = X_Organization_Id,
cycle_count_header_id = X_Cycle_Count_Header_Id,
number_of_counts = X_Number_Of_Counts,
locator_id = X_Locator_Id,
adjustment_quantity = X_Adjustment_Quantity,
adjustment_date = X_Adjustment_Date,
adjustment_amount = X_Adjustment_Amount,
item_unit_cost = X_Item_Unit_Cost,
inventory_adjustment_account = X_Inventory_Adjustment_Account,
approval_date = X_Approval_Date,
approver_employee_id = X_Approver_Employee_Id,
revision = X_Revision,
lot_number = X_Lot_Number,
lot_control = X_Lot_Control,
system_quantity_first = X_System_Quantity_First,
system_quantity_current = X_System_Quantity_Current,
system_quantity_prior = X_System_Quantity_Prior,
reference_first = X_Reference_First,
reference_current = X_Reference_Current,
reference_prior = X_Reference_Prior,
primary_uom_quantity_first = X_Primary_Uom_Quantity_First,
primary_uom_quantity_current = X_Primary_Uom_Quantity_Current,
primary_uom_quantity_prior = X_Primary_Uom_Quantity_Prior,
count_type_code = X_Count_Type_Code,
transaction_reason_id = X_Transaction_Reason_Id,
approval_type = X_Approval_Type,
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,
serial_number = X_Serial_Number,
serial_detail = X_Serial_Detail,
approval_condition = X_Approval_Condition,
neg_adjustment_quantity = X_Neg_Adjustment_Quantity,
neg_adjustment_Amount = X_Neg_Adjustment_Amount,
outermost_lpn_id = X_Outermost_Lpn_ID,
parent_lpn_id = X_Parent_Lpn_ID,
cost_group_id = X_Cost_Group_ID,
-- BEGIN INVCONV
Count_Secondary_Uom_First = X_Count_Secondary_Uom_First,
Count_Secondary_Uom_Current = X_Count_Secondary_Uom_Current,
Count_Secondary_Uom_Prior = X_Count_Secondary_Uom_Prior,
Secondary_Uom_Quantity_First = X_Secondary_Uom_Quantity_First,
Secondary_Uom_Quantity_Current = X_Secondary_Uom_Quantity_Curr,
Secondary_Uom_Quantity_Prior = X_Secondary_Uom_Quantity_Prior,
Secondary_System_Qty_First = X_Secondary_System_Qty_First,
Secondary_System_Qty_Current = X_Secondary_System_Qty_Current,
Secondary_System_Qty_Prior = X_Secondary_System_Qty_Prior,
Secondary_Adjustment_Quantity = X_Secondary_Adjustment_Qty,
-- END INVCONV
standard_operation_id = l_standard_operation_id --End of fix of Bug 6012343
WHERE rowid = X_Rowid;
END Update_Row;
PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
BEGIN
DELETE FROM mtl_cycle_count_entries
WHERE rowid = X_Rowid;
END Delete_Row;