[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
X_Project_Asset_Id IN OUT NOCOPY NUMBER,
X_Project_Id NUMBER,
X_Asset_Number VARCHAR2,
X_Asset_Name VARCHAR2,
X_Asset_Description VARCHAR2,
X_Location_Id NUMBER,
X_Assigned_To_Person_Id NUMBER,
X_Date_Placed_In_Service DATE,
X_Asset_Category_Id NUMBER,
X_Asset_key_ccid NUMBER,
X_Book_Type_Code VARCHAR2,
X_Asset_Units NUMBER,
X_Depreciate_Flag VARCHAR2,
X_Amortize_Flag VARCHAR2,
X_Cost_Adjustment_Flag VARCHAR2,
X_Reverse_Flag VARCHAR2,
X_Depreciation_Expense_Ccid NUMBER,
X_Capitalized_Flag VARCHAR2,
X_Estimated_In_Service_Date DATE,
X_Capitalized_Cost NUMBER,
X_Grouped_Cip_Cost 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_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,
--PA.L
X_Project_Asset_Type VARCHAR2,
X_Estimated_Units NUMBER,
X_Parent_Asset_Id NUMBER,
X_Estimated_Cost NUMBER,
X_Manufacturer_Name VARCHAR2,
X_Model_Number VARCHAR2,
X_Serial_Number VARCHAR2,
X_Tag_Number VARCHAR2,
X_Capital_Hold_Flag VARCHAR2,
X_Ret_Target_Asset_Id NUMBER,
X_Org_Id NUMBER
) IS
CURSOR C IS SELECT rowid FROM pa_project_assets
WHERE project_asset_id = X_Project_Asset_Id;
CURSOR C2 IS SELECT pa_project_assets_s.nextval FROM sys.dual;
INSERT INTO pa_project_assets(
project_asset_id,
project_id,
asset_number,
asset_name,
asset_description,
location_id,
assigned_to_person_id,
date_placed_in_service,
asset_category_id,
asset_key_ccid,
book_type_code,
asset_units,
depreciate_flag,
amortize_flag,
cost_adjustment_flag,
reverse_flag,
depreciation_expense_ccid,
capitalized_flag,
estimated_in_service_date,
capitalized_cost,
grouped_cip_cost,
last_update_date,
last_updated_by,
creation_date,
created_by,
last_update_login,
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
new_master_flag,
Project_Asset_Type,
Estimated_asset_Units ,
Parent_Asset_Id,
Estimated_Cost,
Manufacturer_Name,
Model_Number,
Serial_Number,
Tag_Number,
Capital_Hold_Flag,
Ret_Target_Asset_Id,
Org_Id
) VALUES (
X_Project_Asset_Id,
X_Project_Id,
X_Asset_Number,
X_Asset_Name,
X_Asset_Description,
X_Location_Id,
X_Assigned_To_Person_Id,
X_Date_Placed_In_Service,
X_Asset_Category_Id,
X_Asset_key_ccid,
X_Book_Type_Code,
X_Asset_Units,
X_Depreciate_Flag,
X_Amortize_Flag,
X_Cost_Adjustment_Flag,
X_Reverse_Flag,
X_Depreciation_Expense_Ccid,
X_Capitalized_Flag,
X_Estimated_In_Service_Date,
X_Capitalized_Cost,
X_Grouped_Cip_Cost,
X_Last_Update_Date,
X_Last_Updated_By,
X_Creation_Date,
X_Created_By,
X_Last_Update_Login,
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,
'N',
X_Project_Asset_Type,
X_Estimated_Units,
X_Parent_Asset_Id,
X_Estimated_Cost,
X_Manufacturer_Name,
X_Model_Number,
X_Serial_Number,
X_Tag_Number,
X_Capital_Hold_Flag,
X_Ret_Target_Asset_Id,
X_Org_Id
);
END Insert_Row;
SELECT *
FROM pa_project_assets
WHERE pa_project_assets.rowid = X_Rowid
FOR UPDATE of Project_Asset_Id NOWAIT;
FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
PROCEDURE Update_Row(X_Rowid VARCHAR2,
X_Project_Asset_Id NUMBER,
X_Project_Id NUMBER,
X_Asset_Number VARCHAR2,
X_Asset_Name VARCHAR2,
X_Asset_Description VARCHAR2,
X_Location_Id NUMBER,
X_Assigned_To_Person_Id NUMBER,
X_Date_Placed_In_Service DATE,
X_Asset_Category_Id NUMBER,
X_Asset_key_ccid NUMBER,
X_Book_Type_Code VARCHAR2,
X_Asset_Units NUMBER,
X_Depreciate_Flag VARCHAR2,
X_Amortize_Flag VARCHAR2,
X_Cost_Adjustment_Flag VARCHAR2,
X_Reverse_Flag VARCHAR2,
X_Depreciation_Expense_Ccid NUMBER,
X_Capitalized_Flag VARCHAR2,
X_Estimated_In_Service_Date DATE,
X_Capitalized_Cost NUMBER,
X_Grouped_Cip_Cost NUMBER,
X_Last_Update_Date DATE,
X_Last_Updated_By NUMBER,
X_Last_Update_Login 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,
--PA.L
X_Project_Asset_Type VARCHAR2,
X_Estimated_Units NUMBER,
X_Parent_Asset_Id NUMBER,
X_Estimated_Cost NUMBER,
X_Manufacturer_Name VARCHAR2,
X_Model_Number VARCHAR2,
X_Serial_Number VARCHAR2,
X_Tag_Number VARCHAR2,
X_Capital_Event_Id NUMBER,
X_Capital_Hold_Flag VARCHAR2,
X_Ret_Target_Asset_Id NUMBER
) IS
BEGIN
UPDATE pa_project_assets
SET
project_asset_id = X_Project_Asset_Id,
project_id = X_Project_Id,
asset_number = X_Asset_Number,
asset_name = X_Asset_Name,
asset_description = X_Asset_Description,
location_id = X_Location_Id,
assigned_to_person_id = X_Assigned_To_Person_Id,
date_placed_in_service = X_Date_Placed_In_Service,
asset_category_id = X_Asset_Category_Id,
asset_key_ccid = X_Asset_key_ccid,
book_type_code = X_Book_Type_Code,
asset_units = X_Asset_Units,
depreciate_flag = X_Depreciate_Flag,
amortize_flag = X_Amortize_Flag,
cost_adjustment_flag = X_Cost_Adjustment_Flag,
reverse_flag = X_Reverse_Flag,
depreciation_expense_ccid = X_Depreciation_Expense_Ccid,
capitalized_flag = X_Capitalized_Flag,
estimated_in_service_date = X_Estimated_In_Service_Date,
capitalized_cost = X_Capitalized_Cost,
grouped_cip_cost = X_Grouped_Cip_Cost,
last_update_date = X_Last_Update_Date,
last_updated_by = X_Last_Updated_By,
last_update_login = X_Last_Update_Login,
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,
project_asset_type = X_Project_Asset_Type,
estimated_asset_units = X_Estimated_Units,
parent_asset_id = X_Parent_Asset_Id,
estimated_cost = X_Estimated_Cost,
manufacturer_name = X_Manufacturer_Name,
model_number = X_Model_Number,
serial_number = X_Serial_Number,
tag_number = X_Tag_Number ,
capital_event_id = X_Capital_Event_Id,
capital_hold_flag = X_Capital_Hold_Flag,
ret_target_asset_id = X_Ret_Target_Asset_Id
WHERE rowid = X_Rowid;
END Update_Row;
PROCEDURE Delete_Row(X_Rowid VARCHAR2,
X_project_asset_id NUMBER) IS
BEGIN
DELETE FROM pa_project_asset_assignments
WHERE project_asset_id = X_project_asset_id;
DELETE FROM pa_project_assets
WHERE rowid = X_Rowid;
END Delete_Row;