APPS.XLA_TRANSFER_PKG dependencies on XLA_NUMBER_ARRAY_TYPE

Line 162: g_all_ledger_ids_tab XLA_NUMBER_ARRAY_TYPE;

158: g_alc_ledger_id_tab t_array_ids; -- primary+ALC
159: g_ledger_id_tab t_array_ids;
160: g_gllezl_requests_tab t_array_ids;
161: g_group_id_tab t_array_ids;
162: g_all_ledger_ids_tab XLA_NUMBER_ARRAY_TYPE;
163:
164: -- Global variables for debugging
165: g_log_level PLS_INTEGER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
166: g_log_enabled BOOLEAN := fnd_log.test

Line 1170: g_all_ledger_ids_tab := XLA_NUMBER_ARRAY_TYPE();

1166: trace('Number of ledgers selected for a period validation = ' ||g_all_ledgers_tab.count,C_LEVEL_STATEMENT,l_log_module);
1167: END IF;
1168:
1169: -- Populate a SQL variable to be used for casting.
1170: g_all_ledger_ids_tab := XLA_NUMBER_ARRAY_TYPE();
1171:
1172: l_index := g_all_ledgers_tab.FIRST;
1173: FOR i IN 1..g_all_ledgers_tab.COUNT
1174: LOOP

Line 1212: ,TABLE (CAST(:1 AS XLA_NUMBER_ARRAY_TYPE))led

1208: 'SELECT DISTINCT aeh.period_name
1209: ,aeh.ledger_id
1210: FROM xla_ae_headers aeh
1211: ,gl_period_statuses gps
1212: ,TABLE (CAST(:1 AS XLA_NUMBER_ARRAY_TYPE))led
1213: WHERE aeh.application_id = :2 --g_application_id
1214: AND aeh.ledger_id = led.column_value
1215: AND aeh.entity_id = :3 --g_entity_id
1216: AND aeh.gl_transfer_status_code = ''N''

Line 1279: ,TABLE (CAST(:1 AS XLA_NUMBER_ARRAY_TYPE))led

1275: FROM xla_ae_headers aeh
1276: ,gl_period_statuses gps
1277: ,gl_budget_period_ranges gbp
1278: ,gl_budget_versions gbv
1279: ,TABLE (CAST(:1 AS XLA_NUMBER_ARRAY_TYPE))led
1280: WHERE aeh.application_id = :2
1281: AND aeh.ledger_id = led.column_value
1282: AND aeh.balance_type_code = ''B''
1283: AND aeh.entity_id = :3 --g_entity_id

Line 1339: ,TABLE (CAST(:1 AS XLA_NUMBER_ARRAY_TYPE))led

1335: ,gll.latest_encumbrance_year
1336: FROM xla_ae_headers aeh
1337: ,gl_period_statuses gps
1338: ,gl_ledgers gll
1339: ,TABLE (CAST(:1 AS XLA_NUMBER_ARRAY_TYPE))led
1340: WHERE aeh.application_id = :2 --g_application_id
1341: AND aeh.entity_id = :3 --g_entity_id
1342: AND aeh.ledger_id = led.column_value
1343: AND aeh.balance_type_code = ''E''

Line 1399: ,TABLE (CAST(:1 AS XLA_NUMBER_ARRAY_TYPE))led

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
1402: AND aeh.ledger_id = led.column_value
1403: AND aeh.accounting_date <= :3 --g_end_date

Line 1480: ,TABLE (CAST(:1 AS XLA_NUMBER_ARRAY_TYPE))led

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
1481: WHERE xte.entity_id = aeh.entity_id
1482: AND aeh.application_id = :2
1483: AND aeh.ledger_id = led.column_value
1484: AND aeh.accounting_date <= :3 --g_end_date

Line 1555: ,TABLE (CAST(:1 AS XLA_NUMBER_ARRAY_TYPE))led

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
1558: AND aeh.ledger_id = led.column_value
1559: AND aeh.accounting_date <= :3 --g_end_date