APPS.XLA_TRANSFER_PKG dependencies on XLA_EVENT_CLASS_ATTRS

Line 1689: l_actual_flag xla_event_class_attrs.ALLOW_ACTUALS_FLAG%TYPE;

1685: l_budget_version_id_tab t_array_ids;
1686: l_budget_name_tab t_period_name;
1687: l_period_val_failed BOOLEAN := FALSE;
1688: l_index PLS_INTEGER;
1689: l_actual_flag xla_event_class_attrs.ALLOW_ACTUALS_FLAG%TYPE;
1690: l_budget_flag xla_event_class_attrs.ALLOW_BUDGETS_FLAG%TYPE;
1691: l_encum_flag xla_event_class_attrs.ALLOW_ENCUMBRANCE_FLAG%TYPE;
1692: l_statement VARCHAR2(4000);
1693: l_log_module VARCHAR2(240);

Line 1690: l_budget_flag xla_event_class_attrs.ALLOW_BUDGETS_FLAG%TYPE;

1686: l_budget_name_tab t_period_name;
1687: l_period_val_failed BOOLEAN := FALSE;
1688: l_index PLS_INTEGER;
1689: l_actual_flag xla_event_class_attrs.ALLOW_ACTUALS_FLAG%TYPE;
1690: l_budget_flag xla_event_class_attrs.ALLOW_BUDGETS_FLAG%TYPE;
1691: l_encum_flag xla_event_class_attrs.ALLOW_ENCUMBRANCE_FLAG%TYPE;
1692: l_statement VARCHAR2(4000);
1693: l_log_module VARCHAR2(240);
1694: BEGIN

Line 1691: l_encum_flag xla_event_class_attrs.ALLOW_ENCUMBRANCE_FLAG%TYPE;

1687: l_period_val_failed BOOLEAN := FALSE;
1688: l_index PLS_INTEGER;
1689: l_actual_flag xla_event_class_attrs.ALLOW_ACTUALS_FLAG%TYPE;
1690: l_budget_flag xla_event_class_attrs.ALLOW_BUDGETS_FLAG%TYPE;
1691: l_encum_flag xla_event_class_attrs.ALLOW_ENCUMBRANCE_FLAG%TYPE;
1692: l_statement VARCHAR2(4000);
1693: l_log_module VARCHAR2(240);
1694: BEGIN
1695: IF g_log_enabled THEN

Line 1725: FROM xla_event_class_attrs

1721: INTO l_actual_flag, l_budget_flag, l_encum_flag
1722: FROM (SELECT MAX(DECODE(NVL(ALLOW_ACTUALS_FLAG,'N'),'Y','Y','Z')) actual_flag
1723: ,MAX(DECODE(NVL(ALLOW_BUDGETS_FLAG,'N'),'Y','Y','Z')) budget_flag
1724: ,MAX(DECODE(NVL(ALLOW_encumbrance_FLAG,'N'),'Y','Y','Z')) encumbrance_flag
1725: FROM xla_event_class_attrs
1726: WHERE application_id = g_application_id
1727: GROUP BY allow_actuals_flag, allow_budgets_flag, allow_encumbrance_flag
1728: ORDER BY actual_flag,budget_flag,encumbrance_flag)
1729: WHERE ROWNUM = 1;

Line 1934: ,xla_event_class_attrs xec

1930: FROM xla_ae_headers aeh
1931: ,gl_period_statuses gps
1932: ,xla_transaction_entities xte
1933: ,xla_event_types_b xet
1934: ,xla_event_class_attrs xec
1935: ,xla_ledger_relationships_v xlr
1936: ,TABLE (CAST(:1 AS XLA_NUMBER_ARRAY_TYPE))led
1937: WHERE xte.entity_id = aeh.entity_id
1938: AND aeh.application_id = :2 --g_application_id

Line 2013: ,xla_event_class_attrs xec

2009: ,gbv.budget_name
2010: FROM xla_ae_headers aeh
2011: ,xla_transaction_entities xte
2012: ,xla_event_types_b xet
2013: ,xla_event_class_attrs xec
2014: ,gl_period_statuses gps
2015: ,gl_budget_period_ranges gbp
2016: ,gl_budget_versions gbv
2017: ,TABLE (CAST(:1 AS XLA_NUMBER_ARRAY_TYPE))led

Line 2090: ,xla_event_class_attrs xec

2086: FROM xla_ae_headers aeh
2087: ,gl_period_statuses gps
2088: ,xla_transaction_entities xte
2089: ,xla_event_types_b xet
2090: ,xla_event_class_attrs xec
2091: ,gl_ledgers gll
2092: ,TABLE (CAST(:1 AS XLA_NUMBER_ARRAY_TYPE))led
2093: WHERE xte.entity_id = aeh.entity_id
2094: AND aeh.application_id = :2 --g_application_id

Line 2358: --,xla_event_class_attrs xeca

2354: ,aeh.group_id
2355: FROM xla_ae_headers aeh
2356: ,xla_transaction_entities xte
2357: --,xla_event_types_b xet
2358: --,xla_event_class_attrs xeca
2359: --,xla_event_classes_b xec -- commented for bug12542507 and made it as IN clause
2360: WHERE xte.entity_id = aeh.entity_id
2361: AND xte.application_id = :1 --g_application_id
2362: AND aeh.application_id = xte.application_id

Line 2382: ,xla_event_class_attrs xeca

2378: AND xec.application_id = xet.application_id
2379: AND xet.event_class_code = xec.event_class_code */ --commented for bug12542507 and made it as IN clause as below
2380: AND (aeh.application_id , aeh.event_type_code) IN ( SELECT xet.application_id , xet.event_type_code
2381: FROM xla_event_types_b xet
2382: ,xla_event_class_attrs xeca
2383: ,xla_event_classes_b xec
2384: WHERE 1 = 1
2385: AND xeca.event_class_group_code = Nvl(:4,xeca.event_class_group_code)
2386: AND xeca.application_id = :5