The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE Update_taxes(errbuf OUT NOCOPY VARCHAR2,
retcode OUT NOCOPY VARCHAR2,
p_batch_name IN VARCHAR2) IS
l_batch_id NUMBER;
SELECT je_batch_id
INTO l_batch_id
FROM gl_je_batches
WHERE name = p_batch_name AND
ROWNUM = 1;
END Update_taxes;
SELECT je_header_id,name,je_source,tax_status_code,ledger_id
FROM gl_je_headers
WHERE je_batch_id = batch_id_in
FOR UPDATE;
SELECT period_name,effective_date,status,
tax_code,amount_includes_tax_flag,tax_code_id,
attribute9,attribute10
FROM gl_je_lines
WHERE je_header_id = header_id_in
FOR UPDATE;
SELECT org_id,
budgetary_control_status, actual_flag,
approval_status_code, status, name
INTO l_org_id,
l_budgetary_control_status, l_actual_flag,
l_approval_status_code, l_status, l_name
FROM GL_JE_BATCHES
WHERE je_batch_id = p_batch_id;
SELECT name
INTO l_org_name
FROM hr_operating_units
WHERE organization_id = l_org_id;
UPDATE gl_je_lines
SET tax_code_id = l_je_line_tax_code_id,
amount_includes_tax_flag = l_je_line_tax_flag,
tax_type_code = l_je_line_tax_type_code,
tax_rounding_rule_code = 'N',
taxable_line_flag = 'Y'
WHERE CURRENT OF je_lines;
UPDATE gl_je_headers
SET tax_status_code = 'R'
WHERE CURRENT OF je_headers;
UPDATE gl_je_batches
SET org_id = l_org_id
WHERE je_batch_id = p_batch_id;
SELECT je_header_id,name,je_source,tax_status_code, ledger_id
FROM gl_je_headers
WHERE je_batch_id = batch_id_in
FOR UPDATE;
SELECT je_line_num,period_name,effective_date,status,
tax_code,amount_includes_tax_flag,tax_code_id,
attribute9,attribute10
FROM gl_je_lines
WHERE je_header_id = header_id_in
FOR UPDATE;
SELECT org_id,
budgetary_control_status, actual_flag,
approval_status_code, status, name
INTO l_org_id,
l_budgetary_control_status, l_actual_flag,
l_approval_status_code, l_status, l_name
FROM GL_JE_BATCHES
WHERE je_batch_id = p_batch_id;
SELECT name
INTO l_org_name
FROM hr_operating_units
WHERE organization_id = l_org_id;
SELECT tax_code_id, tax_type_code
INTO l_je_line_tax_code_id, l_je_line_tax_type_code
FROM GL_TAX_CODES_V
WHERE org_id = l_org_id AND
ledger_id = l_ledger_id AND
tax_code = l_je_line_attribute9 AND
valid_flag = 'Y' AND
displayed_flag = 'Y' AND
enabled_flag = 'Y' AND
sysdate BETWEEN nvl(start_date,sysdate) AND
nvl(end_date,sysdate);
UPDATE gl_je_lines
SET tax_code_id = l_je_line_tax_code_id,
amount_includes_tax_flag = l_je_line_tax_flag,
tax_type_code = l_je_line_tax_type_code,
tax_rounding_rule_code = 'N',
taxable_line_flag = 'Y'
WHERE CURRENT OF je_lines;
UPDATE gl_je_headers
SET tax_status_code = 'R'
WHERE CURRENT OF je_headers;
UPDATE gl_je_batches
SET org_id = l_org_id
WHERE je_batch_id = p_batch_id;