APPS.XLA_TRANSFER_PKG dependencies on XLA_NUMBER_ARRAY_TYPE

Line 193: g_all_ledger_ids_tab XLA_NUMBER_ARRAY_TYPE;

189: g_alc_ledger_id_tab t_array_ids; -- primary+ALC
190: g_ledger_id_tab t_array_ids;
191: g_gllezl_requests_tab t_array_ids;
192: g_group_id_tab t_array_ids;
193: g_all_ledger_ids_tab XLA_NUMBER_ARRAY_TYPE;
194:
195: --Added for bug 11855000 Start
196:
197: -- Funds check variables

Line 1707: g_all_ledger_ids_tab := XLA_NUMBER_ARRAY_TYPE();

1703: trace('Number of ledgers selected for a period validation = ' ||g_all_ledgers_tab.count,C_LEVEL_STATEMENT,l_log_module);
1704: END IF;
1705:
1706: -- Populate a SQL variable to be used for casting.
1707: g_all_ledger_ids_tab := XLA_NUMBER_ARRAY_TYPE();
1708:
1709: l_index := g_all_ledgers_tab.FIRST;
1710: FOR i IN 1..g_all_ledgers_tab.COUNT
1711: LOOP

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

1745: 'SELECT DISTINCT aeh.period_name
1746: ,aeh.ledger_id
1747: FROM xla_ae_headers aeh
1748: ,gl_period_statuses gps
1749: ,TABLE (CAST(:1 AS XLA_NUMBER_ARRAY_TYPE))led
1750: WHERE aeh.application_id = :2 --g_application_id
1751: AND aeh.ledger_id = led.column_value
1752: AND aeh.entity_id = :3 --g_entity_id
1753: AND aeh.gl_transfer_status_code = ''N''

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

1812: FROM xla_ae_headers aeh
1813: ,gl_period_statuses gps
1814: ,gl_budget_period_ranges gbp
1815: ,gl_budget_versions gbv
1816: ,TABLE (CAST(:1 AS XLA_NUMBER_ARRAY_TYPE))led
1817: WHERE aeh.application_id = :2
1818: AND aeh.ledger_id = led.column_value
1819: AND aeh.balance_type_code = ''B''
1820: AND aeh.entity_id = :3 --g_entity_id

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

1872: ,gll.latest_encumbrance_year
1873: FROM xla_ae_headers aeh
1874: ,gl_period_statuses gps
1875: ,gl_ledgers gll
1876: ,TABLE (CAST(:1 AS XLA_NUMBER_ARRAY_TYPE))led
1877: WHERE aeh.application_id = :2 --g_application_id
1878: AND aeh.entity_id = :3 --g_entity_id
1879: AND aeh.ledger_id = led.column_value
1880: AND aeh.balance_type_code = ''E''

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

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

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

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
2018: WHERE xte.entity_id = aeh.entity_id
2019: AND aeh.application_id = :2
2020: AND aeh.ledger_id = led.column_value
2021: AND aeh.accounting_date <= :3 --g_end_date

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

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