[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
g_last_update_date DATE;
g_last_update_login INTEGER;
g_last_updated_by INTEGER;
SELECT 'x'
FROM xla_evt_class_acct_attrs e
WHERE e.application_id = p_application_id
AND e.event_class_code = p_event_class_code
AND e.accounting_attribute_code IN ('ACCOUNTING_REVERSAL_OPTION','TRX_ACCT_REVERSAL_OPTION');
SELECT a.accounting_attribute_code
FROM xla_acct_attributes_b a
WHERE a.assignment_required_code = 'Y'
AND NOT EXISTS (SELECT 'x'
FROM xla_evt_class_acct_attrs e
WHERE e.application_id = p_application_id
AND e.event_class_code = p_event_class_code
AND e.accounting_attribute_code = a.accounting_attribute_code
AND e.default_flag = 'Y');
SELECT distinct a.assignment_group_code
FROM xla_acct_attributes_b a
WHERE assignment_group_code is NOT NULL
AND EXISTS (SELECT 'x'
FROM xla_evt_class_acct_attrs e
WHERE e.application_id = p_application_id
AND e.event_class_code = p_event_class_code
AND e.accounting_attribute_code = a.accounting_attribute_code
AND e.default_flag = 'Y');
SELECT accounting_attribute_code
FROM xla_acct_attributes_b s
WHERE assignment_required_code = 'G'
AND assignment_group_code = p_assignment_group_code
AND not exists (SELECT 'x'
FROM xla_evt_class_acct_attrs e
WHERE e.application_id = p_application_id
AND e.event_class_code = p_event_class_code
AND e.accounting_attribute_code = s.accounting_attribute_code
AND e.default_flag = 'Y');
SELECT allow_budgets_flag, allow_encumbrance_flag
FROM xla_event_class_attrs e
WHERE e.application_id = p_application_id
AND e.entity_code = p_entity_code
AND e.event_class_code = p_event_class_code;
SELECT 'x'
FROM xla_evt_class_acct_attrs e
WHERE e.application_id = p_application_id
AND e.event_class_code = p_event_class_code
AND e.accounting_attribute_code = 'BUDGET_VERSION_ID'
AND e.default_flag = 'Y';
SELECT 'x'
FROM xla_evt_class_acct_attrs e
WHERE e.application_id = p_application_id
AND e.event_class_code = p_event_class_code
AND e.accounting_attribute_code = 'ENCUMBRANCE_TYPE_ID'
AND e.default_flag = 'Y';
SELECT a.accounting_attribute_code, a.assignment_group_code
FROM xla_evt_class_acct_attrs_fvl a
WHERE a.application_id = p_application_id
AND a.event_class_code = p_event_class_code
AND a.accounting_attribute_code = 'REVERSED_DISTRIBUTION_ID2'
AND default_flag = 'Y';
SELECT 'x'
FROM xla_evt_class_acct_attrs a
WHERE a.application_id = p_application_id
AND a.event_class_code = p_event_class_code
AND a.accounting_attribute_code = 'DISTRIBUTION_IDENTIFIER_2'
AND default_flag = 'Y';
SELECT a.accounting_attribute_code, a.assignment_group_code
FROM xla_evt_class_acct_attrs_fvl a
WHERE a.application_id = p_application_id
AND a.event_class_code = p_event_class_code
AND a.accounting_attribute_code = 'REVERSED_DISTRIBUTION_ID3'
AND default_flag = 'Y';
SELECT 'x'
FROM xla_evt_class_acct_attrs a
WHERE a.application_id = p_application_id
AND a.event_class_code = p_event_class_code
AND a.accounting_attribute_code = 'DISTRIBUTION_IDENTIFIER_3'
AND a.default_flag = 'Y';
SELECT a.accounting_attribute_code, a.assignment_group_code
FROM xla_evt_class_acct_attrs_fvl a
WHERE a.application_id = p_application_id
AND a.event_class_code = p_event_class_code
AND a.accounting_attribute_code = 'REVERSED_DISTRIBUTION_ID4'
AND default_flag = 'Y';
SELECT 'x'
FROM xla_evt_class_acct_attrs a
WHERE a.application_id = p_application_id
AND a.event_class_code = p_event_class_code
AND a.accounting_attribute_code = 'DISTRIBUTION_IDENTIFIER_4'
AND default_flag = 'Y';
SELECT a.accounting_attribute_code, a.assignment_group_code
FROM xla_evt_class_acct_attrs_fvl a
WHERE a.application_id = p_application_id
AND a.event_class_code = p_event_class_code
AND a.accounting_attribute_code = 'REVERSED_DISTRIBUTION_ID5'
AND a.default_flag = 'Y';
SELECT 'x'
FROM xla_evt_class_acct_attrs a
WHERE a.application_id = p_application_id
AND a.event_class_code = p_event_class_code
AND a.accounting_attribute_code = 'DISTRIBUTION_IDENTIFIER_5'
AND a.default_flag = 'Y';
SELECT s.accounting_attribute_code, s.source_application_id,
s.source_type_code, s.source_code
FROM xla_evt_class_acct_attrs s
WHERE s.application_id = p_application_id
AND s.event_class_code = p_event_class_code
AND s.source_application_id = p_application_id
AND s.source_type_code = 'S'
AND NOT EXISTS (SELECT 'x'
FROM xla_event_sources e
WHERE e.application_id = s.application_id
AND e.event_class_code = s.event_class_code
AND e.source_application_id = s.source_application_id
AND e.source_type_code = s.source_type_code
AND e.source_code = s.source_code
AND e.active_flag = 'Y');
SELECT s.accounting_attribute_code, s.source_application_id,
s.source_type_code, s.source_code
FROM xla_evt_class_acct_attrs s
WHERE s.application_id = p_application_id
AND s.event_class_code = p_event_class_code
AND s.source_application_id = p_application_id
AND s.source_type_code = 'D';
SELECT distinct d.entity_code, d.event_class_code, d.event_type_code,
d.description_type_code, d.description_code
FROM xla_prod_acct_headers d
WHERE d.application_id = p_application_id
AND d.amb_context_code = p_amb_context_code
AND d.product_rule_type_code = p_product_rule_type_code
AND d.product_rule_code = p_product_rule_code
AND d.description_type_code IS NOT NULL
AND d.accounting_required_flag = 'Y'
AND d.validation_status_code = 'R'
AND NOT EXISTS (SELECT 'y'
FROM xla_descriptions_b s
WHERE s.application_id = d.application_id
AND s.amb_context_code = d.amb_context_code
AND s.description_type_code = d.description_type_code
AND s.description_code = d.description_code
AND s.enabled_flag = 'Y');
SELECT distinct l.entity_code, l.event_class_code, l.event_type_code,
l.description_type_code, l.description_code, d.source_type_code, d.source_code
FROM xla_descript_details_b d, xla_desc_priorities p, xla_prod_acct_headers l
WHERE d.description_prio_id = p.description_prio_id
AND p.application_id = l.application_id
AND p.amb_context_code = l.amb_context_code
AND p.description_type_code = l.description_type_code
AND p.description_code = l.description_code
AND l.application_id = p_application_id
AND l.amb_context_code = p_amb_context_code
AND l.product_rule_type_code = p_product_rule_type_code
AND l.product_rule_code = p_product_rule_code
AND l.accounting_required_flag = 'Y'
AND l.validation_status_code = 'R'
AND d.source_type_code = 'S'
AND NOT EXISTS (SELECT 'y'
FROM xla_event_sources s
WHERE s.source_application_id = d.source_application_id
AND s.source_type_code = d.source_type_code
AND s.source_code = d.source_code
AND s.application_id = l.application_id
AND s.entity_code = l.entity_code
AND s.event_class_code = l.event_class_code
AND s.active_flag = 'Y'
AND s.level_code = 'H');
SELECT distinct l.entity_code, l.event_class_code, l.event_type_code,
l.description_type_code, l.description_code,
c.source_type_code source_type_code, c.source_code source_code
FROM xla_conditions c, xla_desc_priorities p, xla_prod_acct_headers l
WHERE c.description_prio_id = p.description_prio_id
AND p.application_id = l.application_id
AND p.amb_context_code = l.amb_context_code
AND p.description_type_code = l.description_type_code
AND p.description_code = l.description_code
AND l.application_id = p_application_id
AND l.amb_context_code = p_amb_context_code
AND l.product_rule_type_code= p_product_rule_type_code
AND l.product_rule_code = p_product_rule_code
AND l.accounting_required_flag = 'Y'
AND l.validation_status_code = 'R'
AND c.source_type_code = 'S'
AND NOT EXISTS (SELECT 'y'
FROM xla_event_sources s
WHERE s.source_application_id = c.source_application_id
AND s.source_type_code = c.source_type_code
AND s.source_code = c.source_code
AND s.application_id = l.application_id
AND s.entity_code = l.entity_code
AND s.event_class_code = l.event_class_code
AND s.active_flag = 'Y'
AND s.level_code = 'H')
UNION
SELECT distinct l.entity_code, l.event_class_code, l.event_type_code,
l.description_type_code, l.description_code,
c.value_source_type_code source_type_code, c.value_source_code source_code
FROM xla_conditions c, xla_desc_priorities p, xla_prod_acct_headers l
WHERE c.description_prio_id = p.description_prio_id
AND p.application_id = l.application_id
AND p.amb_context_code = l.amb_context_code
AND p.description_type_code = l.description_type_code
AND p.description_code = l.description_code
AND l.application_id = p_application_id
AND l.amb_context_code = p_amb_context_code
AND l.product_rule_type_code= p_product_rule_type_code
AND l.product_rule_code = p_product_rule_code
AND l.accounting_required_flag = 'Y'
AND l.validation_status_code = 'R'
AND c.value_source_type_code = 'S'
AND NOT EXISTS (SELECT 'y'
FROM xla_event_sources s
WHERE s.source_application_id = c.value_source_application_id
AND s.source_type_code = c.value_source_type_code
AND s.source_code = c.value_source_code
AND s.application_id = l.application_id
AND s.entity_code = l.entity_code
AND s.event_class_code = l.event_class_code
AND s.active_flag = 'Y'
AND s.level_code = 'H');
SELECT distinct l.entity_code, l.event_class_code, l.event_type_code,
l.description_type_code, l.description_code, d.source_type_code, d.source_code
FROM xla_descript_details_b d, xla_desc_priorities p, xla_prod_acct_headers l
WHERE d.description_prio_id = p.description_prio_id
AND p.application_id = l.application_id
AND p.amb_context_code = l.amb_context_code
AND p.description_type_code = l.description_type_code
AND p.description_code = l.description_code
AND l.application_id = p_application_id
AND l.amb_context_code = p_amb_context_code
AND l.product_rule_type_code= p_product_rule_type_code
AND l.product_rule_code = p_product_rule_code
AND l.accounting_required_flag = 'Y'
AND l.validation_status_code = 'R'
AND d.source_type_code = 'D';
SELECT distinct l.entity_code, l.event_class_code, l.event_type_code,
l.description_type_code, l.description_code,
c.source_type_code source_type_code, c.source_code source_code
FROM xla_conditions c, xla_desc_priorities p, xla_prod_acct_headers l
WHERE c.description_prio_id = p.description_prio_id
AND p.application_id = l.application_id
AND p.amb_context_code = l.amb_context_code
AND p.description_type_code = l.description_type_code
AND p.description_code = l.description_code
AND l.application_id = p_application_id
AND l.amb_context_code = p_amb_context_code
AND l.product_rule_type_code= p_product_rule_type_code
AND l.product_rule_code = p_product_rule_code
AND l.accounting_required_flag = 'Y'
AND l.validation_status_code = 'R'
AND c.source_type_code = 'D'
UNION
SELECT distinct l.entity_code, l.event_class_code, l.event_type_code,
l.description_type_code, l.description_code,
c.value_source_type_code source_type_code, c.value_source_code source_code
FROM xla_conditions c, xla_desc_priorities p, xla_prod_acct_headers l
WHERE c.description_prio_id = p.description_prio_id
AND p.application_id = l.application_id
AND p.amb_context_code = l.amb_context_code
AND p.description_type_code = l.description_type_code
AND p.description_code = l.description_code
AND l.application_id = p_application_id
AND l.amb_context_code = p_amb_context_code
AND l.product_rule_type_code= p_product_rule_type_code
AND l.product_rule_code = p_product_rule_code
AND l.accounting_required_flag = 'Y'
AND l.validation_status_code = 'R'
AND c.value_source_type_code = 'D';
SELECT distinct s.event_class_code, s.event_type_code,
s.analytical_criterion_type_code, s.analytical_criterion_code
FROM xla_aad_header_ac_assgns s
WHERE s.application_id = p_application_id
AND s.amb_context_code = p_amb_context_code
AND s.product_rule_type_code = p_product_rule_type_code
AND s.product_rule_code = p_product_rule_code
AND NOT EXISTS ( SELECT 'x'
FROM xla_analytical_hdrs_b a
WHERE a.amb_context_code = s.amb_context_code
AND a.analytical_criterion_code = s.analytical_criterion_code
AND a.analytical_criterion_type_code = s.analytical_criterion_type_code
AND a.enabled_flag = 'Y');
SELECT distinct s.event_class_code, s.event_type_code,
s.analytical_criterion_type_code, s.analytical_criterion_code
FROM xla_aad_header_ac_assgns s
WHERE s.application_id = p_application_id
AND s.amb_context_code = p_amb_context_code
AND s.product_rule_type_code = p_product_rule_type_code
AND s.product_rule_code = p_product_rule_code
AND EXISTS ( SELECT 'x'
FROM xla_analytical_hdrs_b a
WHERE a.amb_context_code = s.amb_context_code
AND a.analytical_criterion_code = s.analytical_criterion_code
AND a.analytical_criterion_type_code = s.analytical_criterion_type_code
AND a.balancing_flag = 'Y');
SELECT distinct s.event_class_code, s.event_type_code,
s.analytical_criterion_type_code, s.analytical_criterion_code
FROM xla_aad_header_ac_assgns s
WHERE s.application_id = p_application_id
AND s.amb_context_code = p_amb_context_code
AND s.product_rule_type_code = p_product_rule_type_code
AND s.product_rule_code = p_product_rule_code
AND NOT EXISTS (SELECT 'x'
FROM xla_analytical_sources a
WHERE a.application_id = s.application_id
AND a.amb_context_code = s.amb_context_code
AND a.event_class_code = s.event_class_code
AND a.analytical_criterion_code = s.analytical_criterion_code
AND a.analytical_criterion_type_code = s.analytical_criterion_type_code);
SELECT distinct n.event_class_code, n.event_type_code,
n.analytical_criterion_type_code, n.analytical_criterion_code,
a.source_code, a.source_type_code
FROM xla_analytical_sources a, xla_aad_header_ac_assgns n
WHERE a.application_id = n.application_id
AND a.amb_context_code = n.amb_context_code
AND a.event_class_code = n.event_class_code
AND a.analytical_criterion_code = n.analytical_criterion_code
AND a.analytical_criterion_type_code = n.analytical_criterion_type_code
AND a.source_type_code = 'S'
AND n.application_id = p_application_id
AND n.amb_context_code = p_amb_context_code
AND n.product_rule_type_code = p_product_rule_type_code
AND n.product_rule_code = p_product_rule_code
AND not exists (SELECT 'y'
FROM xla_event_sources s
WHERE s.source_application_id = a.source_application_id
AND s.source_type_code = a.source_type_code
AND s.source_code = a.source_code
AND s.application_id = a.application_id
AND s.entity_code = a.entity_code
AND s.event_class_code = a.event_class_code
AND s.active_flag = 'Y'
AND s.level_code = 'H');
SELECT distinct n.event_class_code, n.event_type_code,
n.analytical_criterion_type_code, n.analytical_criterion_code,
a.source_code, a.source_type_code
FROM xla_analytical_sources a, xla_aad_header_ac_assgns n
WHERE a.application_id = n.application_id
AND a.amb_context_code = n.amb_context_code
AND a.event_class_code = n.event_class_code
AND a.analytical_criterion_code = n.analytical_criterion_code
AND a.analytical_criterion_type_code = n.analytical_criterion_type_code
AND a.source_type_code = 'D'
AND n.application_id = p_application_id
AND n.amb_context_code = p_amb_context_code
AND n.product_rule_type_code = p_product_rule_type_code
AND n.product_rule_code = p_product_rule_code;
SELECT entity_code, event_class_code
FROM xla_prod_acct_headers d
WHERE d.application_id = p_application_id
AND d.amb_context_code = p_amb_context_code
AND d.product_rule_type_code = p_product_rule_type_code
AND d.product_rule_code = p_product_rule_code
AND EXISTS (SELECT 'y'
FROM xla_event_classes_b s
WHERE s.application_id = d.application_id
AND s.entity_code = d.entity_code
AND s.event_class_code = d.event_class_code
AND s.enabled_flag = 'N');
SELECT entity_code, event_class_code
FROM xla_prod_acct_headers d
WHERE d.application_id = p_application_id
AND d.amb_context_code = p_amb_context_code
AND d.product_rule_type_code = p_product_rule_type_code
AND d.product_rule_code = p_product_rule_code
AND EXISTS (SELECT 'x'
FROM xla_event_class_predecs p
WHERE p.application_id = d.application_id
AND p.event_class_code = d.event_class_code
AND CONNECT_BY_ISCYCLE = 1
CONNECT BY NOCYCLE prior event_class_code = prior_event_class_code);
SELECT 'x'
FROM xla_prod_acct_headers d
WHERE d.application_id = p_application_id
AND d.amb_context_code = p_amb_context_code
AND d.product_rule_type_code = p_product_rule_type_code
AND d.product_rule_code = p_product_rule_code
AND d.accounting_required_flag = 'Y';
SELECT entity_code, event_class_code
FROM xla_prod_acct_headers d
WHERE d.application_id = p_application_id
AND d.amb_context_code = p_amb_context_code
AND d.product_rule_type_code = p_product_rule_type_code
AND d.product_rule_code = p_product_rule_code
AND d.event_type_code = d.event_class_code||'_ALL'
AND NOT EXISTS (SELECT 'y'
FROM xla_event_types_b et
WHERE et.application_id = d.application_id
AND et.entity_code = d.entity_code
AND et.event_class_code = d.event_class_code
AND et.event_type_code <> d.event_class_code||'_ALL'
AND et.enabled_flag = 'Y'
AND et.accounting_flag = 'Y');
SELECT application_id, entity_code, event_class_code, event_type_code
FROM xla_prod_acct_headers d
WHERE d.application_id = p_application_id
AND d.amb_context_code = p_amb_context_code
AND d.product_rule_type_code = p_product_rule_type_code
AND d.product_rule_code = p_product_rule_code
AND d.event_type_code <> d.event_class_code||'_ALL'
AND d.validation_status_code = 'R'
AND NOT EXISTS (SELECT 'y'
FROM xla_event_types_b s
WHERE s.application_id = d.application_id
AND s.entity_code = d.entity_code
AND s.event_class_code = d.event_class_code
AND s.event_type_code = d.event_type_code
AND s.enabled_flag = 'Y'
AND s.accounting_flag = 'Y');
SELECT xpa.entity_code, xpa.event_class_code, xpa.event_type_code
FROM xla_prod_acct_headers xpa
WHERE xpa.application_id = p_application_id
AND xpa.amb_context_code = p_amb_context_code
AND xpa.product_rule_type_code = p_product_rule_type_code
AND xpa.product_rule_code = p_product_rule_code
AND xpa.accounting_required_flag = 'Y'
AND xpa.validation_status_code = 'R'
AND NOT EXISTS (SELECT 'x'
FROM xla_aad_line_defn_assgns xal
, xla_line_definitions_b xld
WHERE xal.application_id = xpa.application_id
AND xal.amb_context_code = xpa.amb_context_code
AND xal.product_rule_type_code = xpa.product_rule_type_code
AND xal.product_rule_code = xpa.product_rule_code
AND xal.event_class_code = xpa.event_class_code
AND xal.event_type_code = xpa.event_type_code
AND xld.application_id = xal.application_id
AND xld.amb_context_code = xal.amb_context_code
AND xld.event_class_code = xal.event_class_code
AND xld.event_type_code = xal.event_type_code
AND xld.line_definition_owner_code = xal.line_definition_owner_code
AND xld.line_definition_code = xal.line_definition_code
AND xld.enabled_flag = 'Y');
SELECT distinct entity_code, event_class_code, event_type_code
FROM xla_prod_acct_headers d
WHERE d.application_id = p_application_id
AND d.amb_context_code = p_amb_context_code
AND d.product_rule_type_code = p_product_rule_type_code
AND d.product_rule_code = p_product_rule_code
AND d.accounting_required_flag = 'Y'
AND d.validation_status_code = 'R';
UPDATE xla_line_definitions_b
SET validation_status_code = 'Y' -- Valid
WHERE application_id = p_application_id
AND amb_context_code = p_amb_context_code
AND event_class_code = p_event_class_code
AND event_type_code = p_event_type_code
AND line_definition_owner_code = p_line_definition_owner_code
AND line_definition_code = p_line_definition_code;
UPDATE xla_line_definitions_b
SET validation_status_code = 'E' -- Invalid
WHERE application_id = p_application_id
AND amb_context_code = p_amb_context_code
AND event_class_code = p_event_class_code
AND event_type_code = p_event_type_code
AND line_definition_owner_code = p_line_definition_owner_code
AND line_definition_code = p_line_definition_code;
SELECT distinct xld.event_class_code, xld.event_type_code,
xld.line_definition_owner_code, xld.line_definition_code
FROM xla_aad_line_defn_assgns xal
,xla_line_definitions_b xld
WHERE xld.application_id = xal.application_id
AND xld.amb_context_code = xal.amb_context_code
AND xld.event_class_code = xal.event_class_code
AND xld.event_type_code = xal.event_type_code
AND xld.line_definition_owner_code = xal.line_definition_owner_code
AND xld.line_definition_code = xal.line_definition_code
AND xld.validation_status_code <> 'Y'
AND xal.application_id = p_application_id
AND xal.amb_context_code = p_amb_context_code
AND xal.product_rule_type_code = p_product_rule_type_code
AND xal.product_rule_code = p_product_rule_code;
DELETE FROM xla_amb_setup_errors
WHERE application_id = p_application_id
AND amb_context_code = p_amb_context_code
AND product_rule_type_code = p_product_rule_type_code
AND product_rule_code = p_product_rule_code;
UPDATE xla_prod_acct_headers xpa
SET validation_status_code = 'E'
WHERE application_id = p_application_id
AND amb_context_code = p_amb_context_code
AND product_rule_type_code = p_product_rule_type_code
AND product_rule_code = p_product_rule_code
AND event_class_code = l_inv_event_class_codes(j);
xla_amb_setup_err_pkg.insert_errors;
UPDATE xla_prod_acct_headers
SET validation_status_code = 'R'
WHERE application_id = p_application_id
AND amb_context_code = p_amb_context_code
AND product_rule_type_code = p_product_rule_type_code
AND product_rule_code = p_product_rule_code
AND validation_status_code <> 'Y';
trace(p_msg => '# rows updated to Validating = '||l_count
,p_module => l_log_module
,p_level => C_LEVEL_STATEMENT);
UPDATE xla_prod_acct_headers
SET validation_status_code = 'R'
WHERE application_id = p_application_id
AND amb_context_code = p_amb_context_code
AND product_rule_type_code = p_product_rule_type_code
AND product_rule_code = p_product_rule_code
AND validation_status_code = 'Y';
xla_amb_setup_err_pkg.insert_errors;
UPDATE xla_prod_acct_headers
SET validation_status_code = x_compilation_status_code
, last_update_date = sysdate
, last_updated_by = xla_environment_pkg.g_usr_id
, last_update_login = xla_environment_pkg.g_login_id
WHERE application_id = p_application_id
AND amb_context_code = p_amb_context_code
AND product_rule_type_code = p_product_rule_type_code
AND product_rule_code = p_product_rule_code
AND validation_status_code = 'R';
UPDATE xla_product_rules_b
SET compile_status_code = x_compilation_status_code
, product_rule_hash_id = NVL(x_hash_id,product_rule_hash_id)
, last_update_date = sysdate
, last_updated_by = xla_environment_pkg.g_usr_id
, last_update_login = xla_environment_pkg.g_login_id
WHERE application_id = p_application_id
AND amb_context_code = p_amb_context_code
AND product_rule_type_code = p_product_rule_type_code
AND product_rule_code = p_product_rule_code
RETURNING product_rule_hash_id INTO x_hash_id;
g_last_update_date := sysdate;
g_last_update_login := xla_environment_pkg.g_login_id;
g_last_updated_by := xla_environment_pkg.g_usr_id;