The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE insert_row (
X_rowid IN OUT NOCOPY VARCHAR2,
X_revaluation_id IN OUT NOCOPY NUMBER,
X_book_type_code IN VARCHAR2,
X_revaluation_date IN DATE,
X_revaluation_period IN VARCHAR2,
X_status IN VARCHAR2,
X_reval_request_id IN NUMBER,
X_create_request_id IN NUMBER,
X_calling_program IN VARCHAR2,
X_mode IN VARCHAR2,
X_event_id IN NUMBER -- for R12 SLA upgrade
) AS
CURSOR c IS
SELECT rowid
FROM igi_iac_revaluations
WHERE revaluation_id = X_revaluation_id;
SELECT igi_iac_revaluations_s.NEXTVAL
FROM sys.dual;
X_last_update_date DATE;
X_last_updated_by NUMBER;
X_last_update_login NUMBER;
l_path_name VARCHAR2(150) := g_path||'insert_row';
x_last_update_date := SYSDATE;
x_last_updated_by := fnd_global.user_id;
IF (x_last_updated_by IS NULL) THEN
x_last_updated_by := -1;
x_last_update_login := fnd_global.login_id;
IF (x_last_update_login IS NULL) THEN
x_last_update_login := -1;
INSERT INTO igi_iac_revaluations
(revaluation_id,
book_type_code,
revaluation_date,
revaluation_period,
status,
reval_request_id,
create_request_id,
calling_program,
last_update_date,
created_by,
last_update_login,
last_updated_by,
creation_date,
event_id) -- for R12 SLA upgrade
VALUES
(X_revaluation_id,
X_book_type_code,
X_revaluation_date,
X_revaluation_period,
X_status,
X_reval_request_id,
X_create_request_id,
X_calling_program,
X_last_update_date,
X_created_by,
X_last_update_login,
X_last_updated_by,
X_creation_date,
X_event_id); -- for R12 SLA upgrade
END insert_row;
PROCEDURE delete_row (
x_revaluation_id IN NUMBER
) AS
BEGIN
DELETE FROM igi_iac_revaluations
WHERE revaluation_id = x_revaluation_id;
END delete_row;