The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT *
FROM pay_functional_usages
WHERE rowid = p_row_id
FOR UPDATE OF
usage_id NOWAIT;
PROCEDURE insert_row(
p_row_id IN out nocopy VARCHAR2,
p_usage_id IN out nocopy NUMBER,
p_area_id IN NUMBER,
p_legislation_code IN VARCHAR2,
p_business_group_id IN NUMBER,
p_payroll_id IN NUMBER
) IS
--
CURSOR csr_new_id IS
SELECT pay_functional_usages_s.NEXTVAL
FROM dual;
SELECT rowid
FROM pay_functional_usages
WHERE usage_id = p_usage_id;
INSERT INTO pay_functional_usages(
usage_id,
area_id,
legislation_code,
business_group_id,
payroll_id
) VALUES (
p_usage_id,
p_area_id,
p_legislation_code,
p_business_group_id,
p_payroll_id
);
'PAY_FUNCTIONAL_USAGES_PKG.INSERT_ROW'
);
END insert_row;
PROCEDURE update_row(
p_row_id IN VARCHAR2,
p_usage_id IN NUMBER,
p_area_id IN NUMBER,
p_legislation_code IN VARCHAR2,
p_business_group_id IN NUMBER,
p_payroll_id IN NUMBER
) IS
BEGIN
UPDATE pay_functional_usages
SET usage_id = p_usage_id,
area_id = p_area_id,
legislation_code = p_legislation_code,
business_group_id = p_business_group_id,
payroll_id = p_payroll_id
WHERE rowid = p_row_id;
'PAY_FUNCTIONAL_USAGES_PKG.UPDATE_ROW'
);
END update_row;
PROCEDURE delete_row(
p_row_id IN VARCHAR2,
p_usage_id IN NUMBER
) IS
BEGIN
DELETE
FROM pay_functional_usages
WHERE rowid = p_row_id;
'PAY_FUNCTIONAL_USAGES_PKG.DELETE_ROW'
);
END delete_row;