The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT module_name
FROM hr_api_modules
WHERE api_module_id = p_api_module_id;
SELECT parameter_value
FROM pay_action_parameters
WHERE parameter_name = 'HR_DU_DEBUG_LOG';
SELECT status
FROM hr_du_uploads
WHERE (upload_id = p_upload_id);
SELECT status
FROM hr_du_upload_headers
WHERE (upload_header_id = p_upload_header_id);
SELECT status
FROM hr_du_upload_lines
WHERE (upload_line_id = p_upload_lines_id);
PROCEDURE update_uploads (p_new_status IN VARCHAR2, p_id IN NUMBER) IS
--
-- table is hr_du_uploads
-- parent of hr_du_upload_headers
-- child of (none)
l_complete VARCHAR2(30);
SELECT status
FROM hr_du_upload_headers
WHERE ((upload_id = p_id)
AND (status <> 'C'));
message('ROUT','entry:hr_du_utility.update_uploads', 5);
UPDATE hr_du_uploads
SET status = p_new_status
WHERE upload_id = p_id;
UPDATE hr_du_uploads
SET status = p_new_status
WHERE upload_id = p_id;
message('INFO','Update status - update_uploads', 15);
message('SUMM','Update status - update_uploads', 20);
message('ROUT','exit:hr_du_utility.update_uploads', 25);
error(SQLCODE,'hr_du_utility.update_uploads','(none)','R');
END update_uploads;
PROCEDURE update_upload_lines (p_new_status IN VARCHAR2, p_id IN NUMBER) IS
--
-- table is hr_du_upload_lines
-- parent of n/a
-- child of hr_du_upload_headers
l_parent_table_id NUMBER(9);
SELECT upload_header_id
FROM hr_du_upload_lines
WHERE upload_line_id = p_id;
message('ROUT','entry:hr_du_utility.update_upload_lines', 5);
UPDATE hr_du_upload_lines
SET status = p_new_status
WHERE upload_line_id = p_id;
update_upload_headers(p_new_status,l_parent_table_id);
message('INFO','Update status - update_upload_lines', 15);
message('SUMM','Update status - update_upload_lines', 20);
message('ROUT','exit:hr_du_utility.update_upload_lines', 25);
error(SQLCODE,'hr_du_utility.update_upload_lines','(none)','R');
END update_upload_lines;
PROCEDURE update_upload_headers (p_new_status IN VARCHAR2, p_id IN NUMBER) IS
--
-- table is hr_du_upload_headers
-- parent of hr_du_upload_lines
-- child of hr_du_uploads
l_parent_table_id NUMBER(9);
SELECT status
FROM hr_du_upload_lines
WHERE ((upload_header_id = p_id)
AND (status <> 'C'));
SELECT upload_id
FROM hr_du_upload_headers
WHERE upload_header_id = p_id;
message('ROUT','entry:hr_du_utility.update_upload_headers', 5);
UPDATE hr_du_upload_headers
SET status = l_new_status
WHERE upload_header_id = p_id;
UPDATE hr_du_upload_headers
SET status = l_new_status
WHERE upload_header_id = p_id;
update_uploads(l_new_status,l_parent_table_id);
message('INFO','Update status - update_upload_headers', 15);
message('SUMM','Update status - update_upload_headers', 20);
message('ROUT','exit:hr_dm_utility.update_upload_headers', 25);
error(SQLCODE,'hr_dm_utility.update_upload_headers','(none)','R');
END update_upload_headers;
SELECT PARAMETER_VALUE
FROM pay_action_parameters
WHERE PARAMETER_NAME = 'CHUNK_SIZE';