DBA Data[Home] [Help]

APPS.XLA_TRANSFER_PKG dependencies on XLA_EVENT_CLASS_ATTRS

Line 1152: l_actual_flag xla_event_class_attrs.ALLOW_ACTUALS_FLAG%TYPE;

1148: l_budget_version_id_tab t_array_ids;
1149: l_budget_name_tab t_period_name;
1150: l_period_val_failed BOOLEAN := FALSE;
1151: l_index PLS_INTEGER;
1152: l_actual_flag xla_event_class_attrs.ALLOW_ACTUALS_FLAG%TYPE;
1153: l_budget_flag xla_event_class_attrs.ALLOW_BUDGETS_FLAG%TYPE;
1154: l_encum_flag xla_event_class_attrs.ALLOW_ENCUMBRANCE_FLAG%TYPE;
1155: l_statement VARCHAR2(4000);
1156: l_log_module VARCHAR2(240);

Line 1153: l_budget_flag xla_event_class_attrs.ALLOW_BUDGETS_FLAG%TYPE;

1149: l_budget_name_tab t_period_name;
1150: l_period_val_failed BOOLEAN := FALSE;
1151: l_index PLS_INTEGER;
1152: l_actual_flag xla_event_class_attrs.ALLOW_ACTUALS_FLAG%TYPE;
1153: l_budget_flag xla_event_class_attrs.ALLOW_BUDGETS_FLAG%TYPE;
1154: l_encum_flag xla_event_class_attrs.ALLOW_ENCUMBRANCE_FLAG%TYPE;
1155: l_statement VARCHAR2(4000);
1156: l_log_module VARCHAR2(240);
1157: BEGIN

Line 1154: l_encum_flag xla_event_class_attrs.ALLOW_ENCUMBRANCE_FLAG%TYPE;

1150: l_period_val_failed BOOLEAN := FALSE;
1151: l_index PLS_INTEGER;
1152: l_actual_flag xla_event_class_attrs.ALLOW_ACTUALS_FLAG%TYPE;
1153: l_budget_flag xla_event_class_attrs.ALLOW_BUDGETS_FLAG%TYPE;
1154: l_encum_flag xla_event_class_attrs.ALLOW_ENCUMBRANCE_FLAG%TYPE;
1155: l_statement VARCHAR2(4000);
1156: l_log_module VARCHAR2(240);
1157: BEGIN
1158: IF g_log_enabled THEN

Line 1188: FROM xla_event_class_attrs

1184: INTO l_actual_flag, l_budget_flag, l_encum_flag
1185: FROM (SELECT MAX(DECODE(NVL(ALLOW_ACTUALS_FLAG,'N'),'Y','Y','Z')) actual_flag
1186: ,MAX(DECODE(NVL(ALLOW_BUDGETS_FLAG,'N'),'Y','Y','Z')) budget_flag
1187: ,MAX(DECODE(NVL(ALLOW_encumbrance_FLAG,'N'),'Y','Y','Z')) encumbrance_flag
1188: FROM xla_event_class_attrs
1189: WHERE application_id = g_application_id
1190: GROUP BY allow_actuals_flag, allow_budgets_flag, allow_encumbrance_flag
1191: ORDER BY actual_flag,budget_flag,encumbrance_flag)
1192: WHERE ROWNUM = 1;

Line 1397: ,xla_event_class_attrs xec

1393: FROM xla_ae_headers aeh
1394: ,gl_period_statuses gps
1395: ,xla_transaction_entities xte
1396: ,xla_event_types_b xet
1397: ,xla_event_class_attrs xec
1398: ,xla_ledger_relationships_v xlr
1399: ,TABLE (CAST(:1 AS XLA_NUMBER_ARRAY_TYPE))led
1400: WHERE xte.entity_id = aeh.entity_id
1401: AND aeh.application_id = :2 --g_application_id

Line 1476: ,xla_event_class_attrs xec

1472: ,gbv.budget_name
1473: FROM xla_ae_headers aeh
1474: ,xla_transaction_entities xte
1475: ,xla_event_types_b xet
1476: ,xla_event_class_attrs xec
1477: ,gl_period_statuses gps
1478: ,gl_budget_period_ranges gbp
1479: ,gl_budget_versions gbv
1480: ,TABLE (CAST(:1 AS XLA_NUMBER_ARRAY_TYPE))led

Line 1553: ,xla_event_class_attrs xec

1549: FROM xla_ae_headers aeh
1550: ,gl_period_statuses gps
1551: ,xla_transaction_entities xte
1552: ,xla_event_types_b xet
1553: ,xla_event_class_attrs xec
1554: ,gl_ledgers gll
1555: ,TABLE (CAST(:1 AS XLA_NUMBER_ARRAY_TYPE))led
1556: WHERE xte.entity_id = aeh.entity_id
1557: AND aeh.application_id = :2 --g_application_id

Line 1752: ,xla_event_class_attrs xeca

1748: ,aeh.group_id
1749: FROM xla_ae_headers aeh
1750: ,xla_transaction_entities xte
1751: ,xla_event_types_b xet
1752: ,xla_event_class_attrs xeca
1753: ,xla_event_classes_b xec
1754: WHERE xte.entity_id = aeh.entity_id
1755: AND xte.application_id = :1 --g_application_id
1756: AND aeh.application_id = xte.application_id