The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
X_It_Header_Id IN OUT NOCOPY NUMBER,
X_Set_Of_Books_Id NUMBER,
X_Name VARCHAR2,
X_Description VARCHAR2,
X_It_Period_Name VARCHAR2,
X_Entered_Dr NUMBER,
X_Entered_Cr NUMBER,
X_Submit_Flag VARCHAR2,
X_It_Originator_Id VARCHAR2,
X_It_Category VARCHAR2,
X_It_Source VARCHAR2,
X_Gl_Date DATE,
X_Submit_Date DATE,
X_Currency_Code VARCHAR2,
X_Code_Combination_Id NUMBER,
X_Encumbrance_Type_Id NUMBER,
X_Creation_Date DATE,
X_Created_By NUMBER,
X_Last_Update_Login NUMBER,
X_Last_Update_Date DATE,
X_Last_Updated_By NUMBER
) IS
CURSOR C IS SELECT rowid FROM IGI_itr_charge_headers
WHERE it_header_id = X_It_Header_Id;
CURSOR C2 IS SELECT IGI_IGI_itr_charge_headers_s.nextval FROM sys.dual;
INSERT INTO IGI_itr_charge_headers(
it_header_id,
set_of_books_id,
name,
description,
it_period_name,
entered_dr,
entered_cr,
submit_flag,
it_originator_id,
it_category,
it_source,
gl_date,
submit_date,
currency_code,
code_combination_id,
encumbrance_type_id,
creation_date,
created_by,
last_update_login,
last_update_date,
last_updated_by
) VALUES (
X_It_Header_Id,
X_Set_Of_Books_Id,
X_Name,
X_Description,
X_It_Period_Name,
X_Entered_Dr,
X_Entered_Cr,
X_Submit_Flag,
X_It_Originator_Id,
X_It_Category,
X_It_Source,
X_Gl_Date,
X_Submit_Date,
X_Currency_Code,
X_Code_Combination_Id,
X_Encumbrance_Type_Id,
X_Creation_Date,
X_Created_By,
X_Last_Update_Login,
X_Last_Update_Date,
X_Last_Updated_By
);
END Insert_Row;
SELECT *
FROM IGI_itr_charge_headers
WHERE rowid = X_Rowid
FOR UPDATE of It_Header_Id NOWAIT;
FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
PROCEDURE Update_Row(X_Rowid VARCHAR2,
X_It_Header_Id NUMBER,
X_Set_Of_Books_Id NUMBER,
X_Name VARCHAR2,
X_Description VARCHAR2,
X_It_Period_Name VARCHAR2,
X_Entered_Dr NUMBER,
X_Entered_Cr NUMBER,
X_Submit_Flag VARCHAR2,
X_It_Originator_Id VARCHAR2,
X_It_Category VARCHAR2,
X_It_Source VARCHAR2,
X_Gl_Date DATE,
X_Submit_Date DATE,
X_Currency_Code VARCHAR2,
X_Code_Combination_Id NUMBER,
X_Encumbrance_Type_Id NUMBER,
X_Last_Update_Login NUMBER,
X_Last_Update_Date DATE,
X_Last_Updated_By NUMBER
) IS
BEGIN
UPDATE IGI_itr_charge_headers
SET
it_header_id = X_It_Header_Id,
set_of_books_id = X_Set_Of_Books_Id,
name = X_Name,
description = X_Description,
it_period_name = X_It_Period_Name,
entered_dr = X_Entered_Dr,
entered_cr = X_Entered_Cr,
submit_flag = X_Submit_Flag,
it_originator_id = X_It_Originator_Id,
it_category = X_It_Category,
it_source = X_It_Source,
gl_date = X_Gl_Date,
submit_date = X_Submit_Date,
currency_code = X_Currency_Code,
code_combination_id = X_Code_Combination_Id,
encumbrance_type_id = X_Encumbrance_Type_Id,
last_update_login = X_Last_Update_Login,
last_update_date = X_Last_Update_Date,
last_updated_by = X_Last_Updated_By
WHERE rowid = X_Rowid;
END Update_Row;
PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
BEGIN
DELETE FROM IGI_itr_charge_headers
WHERE rowid = X_Rowid;
END Delete_Row;