The following lines contain the word 'select', 'insert', 'update' or 'delete':
G_Cache.DELETE;
SELECT asp.org_id,
asp.auto_site_numbering,
asp.default_country,
gl.chart_of_accounts_id,
gl.set_of_books_id,
asp.location_structure_id,
asp.tax_method,
asp.address_validation,
-- Bug 5002547 : Added create_reciprocal_flag
nvl(asp.create_reciprocal_flag, 'N')
BULK COLLECT
INTO p_globals.org_id_t,
p_globals.auto_site_numbering_t,
p_globals.default_country_t,
p_globals.chart_of_accounts_id_t,
p_globals.set_of_books_id_t,
p_globals.location_structure_id_t,
p_globals.tax_method_t,
p_globals.address_val_t,
-- Bug 5002547 : Added create_reciprocal_flag
p_globals.reciprocal_flag_t
FROM gl_sets_of_books gl,
ar_system_parameters asp
WHERE gl.set_of_books_id = asp.set_of_books_id;
SELECT generate_customer_number,
autocash_hierarchy_id,
default_grouping_rule_id
INTO l_cust, l_autocash, l_grouping
FROM AR_SYSTEM_PARAMETERS_ALL
WHERE org_id = p_org_id;
SELECT
hr.organization_id,
hr.name
INTO
l_org_id,
l_org_name
FROM
hr_operating_units hr,
ar_system_parameters s
WHERE
mo_global.check_access(hr.organization_id) = 'Y'
AND hr.organization_id = s.org_id
AND s.set_of_books_id > 0
AND rownum < 2;
FND_LOG.string(FND_LOG.LEVEL_STATEMENT,MOD_validate_orgid_pub_api,'caught exception no_data_found in sql=SELECT hr.organization_id,hr.name FROM hr_operating_units hr WHERE mo_global.check_access(hr.organization_id) = "Y" AND rownum < 2');
SELECT
hr.organization_id,
hr.name
INTO
l_org_id,
l_org_name
FROM
hr_operating_units hr,
ar_system_parameters s
WHERE
mo_global.check_access(hr.organization_id) = 'Y'
AND hr.organization_id = s.org_id
AND s.set_of_books_id > 0
AND rownum < 2;
FND_LOG.string(FND_LOG.LEVEL_STATEMENT,MOD_validate_orgid_pub_api,'caught exception no_data_found in sql=SELECT hr.organization_id,hr.name FROM hr_operating_units hr WHERE mo_global.check_access(hr.organization_id) = "Y" AND rownum < 2');