116: g_batch_name VARCHAR2(50);
117: g_accounting_batch_id PLS_INTEGER;
118: g_entity_id PLS_INTEGER;
119: g_process_category xla_event_class_grps_b.event_class_group_code%TYPE;
120: g_security_id_int_1 xla_transaction_entities.source_id_int_1%TYPE;
121: g_security_id_int_2 xla_transaction_entities.source_id_int_2%TYPE;
122: g_security_id_int_3 xla_transaction_entities.source_id_int_3%TYPE;
123: g_security_id_char_1 xla_transaction_entities.source_id_char_1%TYPE;
124: g_security_id_char_2 xla_transaction_entities.source_id_char_2%TYPE;
117: g_accounting_batch_id PLS_INTEGER;
118: g_entity_id PLS_INTEGER;
119: g_process_category xla_event_class_grps_b.event_class_group_code%TYPE;
120: g_security_id_int_1 xla_transaction_entities.source_id_int_1%TYPE;
121: g_security_id_int_2 xla_transaction_entities.source_id_int_2%TYPE;
122: g_security_id_int_3 xla_transaction_entities.source_id_int_3%TYPE;
123: g_security_id_char_1 xla_transaction_entities.source_id_char_1%TYPE;
124: g_security_id_char_2 xla_transaction_entities.source_id_char_2%TYPE;
125: g_security_id_char_3 xla_transaction_entities.source_id_char_3%TYPE;
118: g_entity_id PLS_INTEGER;
119: g_process_category xla_event_class_grps_b.event_class_group_code%TYPE;
120: g_security_id_int_1 xla_transaction_entities.source_id_int_1%TYPE;
121: g_security_id_int_2 xla_transaction_entities.source_id_int_2%TYPE;
122: g_security_id_int_3 xla_transaction_entities.source_id_int_3%TYPE;
123: g_security_id_char_1 xla_transaction_entities.source_id_char_1%TYPE;
124: g_security_id_char_2 xla_transaction_entities.source_id_char_2%TYPE;
125: g_security_id_char_3 xla_transaction_entities.source_id_char_3%TYPE;
126: g_valuation_method xla_transaction_entities.valuation_method%TYPE;
119: g_process_category xla_event_class_grps_b.event_class_group_code%TYPE;
120: g_security_id_int_1 xla_transaction_entities.source_id_int_1%TYPE;
121: g_security_id_int_2 xla_transaction_entities.source_id_int_2%TYPE;
122: g_security_id_int_3 xla_transaction_entities.source_id_int_3%TYPE;
123: g_security_id_char_1 xla_transaction_entities.source_id_char_1%TYPE;
124: g_security_id_char_2 xla_transaction_entities.source_id_char_2%TYPE;
125: g_security_id_char_3 xla_transaction_entities.source_id_char_3%TYPE;
126: g_valuation_method xla_transaction_entities.valuation_method%TYPE;
127: g_caller VARCHAR2(80);
120: g_security_id_int_1 xla_transaction_entities.source_id_int_1%TYPE;
121: g_security_id_int_2 xla_transaction_entities.source_id_int_2%TYPE;
122: g_security_id_int_3 xla_transaction_entities.source_id_int_3%TYPE;
123: g_security_id_char_1 xla_transaction_entities.source_id_char_1%TYPE;
124: g_security_id_char_2 xla_transaction_entities.source_id_char_2%TYPE;
125: g_security_id_char_3 xla_transaction_entities.source_id_char_3%TYPE;
126: g_valuation_method xla_transaction_entities.valuation_method%TYPE;
127: g_caller VARCHAR2(80);
128:
121: g_security_id_int_2 xla_transaction_entities.source_id_int_2%TYPE;
122: g_security_id_int_3 xla_transaction_entities.source_id_int_3%TYPE;
123: g_security_id_char_1 xla_transaction_entities.source_id_char_1%TYPE;
124: g_security_id_char_2 xla_transaction_entities.source_id_char_2%TYPE;
125: g_security_id_char_3 xla_transaction_entities.source_id_char_3%TYPE;
126: g_valuation_method xla_transaction_entities.valuation_method%TYPE;
127: g_caller VARCHAR2(80);
128:
129:
122: g_security_id_int_3 xla_transaction_entities.source_id_int_3%TYPE;
123: g_security_id_char_1 xla_transaction_entities.source_id_char_1%TYPE;
124: g_security_id_char_2 xla_transaction_entities.source_id_char_2%TYPE;
125: g_security_id_char_3 xla_transaction_entities.source_id_char_3%TYPE;
126: g_valuation_method xla_transaction_entities.valuation_method%TYPE;
127: g_caller VARCHAR2(80);
128:
129:
130: -- Batch level global variables
1391: 'SELECT DISTINCT aeh.period_name
1392: ,aeh.ledger_id
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
1470: l_statement := '
1471: SELECT DISTINCT gps.period_year
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
1547: ' SELECT DISTINCT aeh.ledger_id
1548: ,gll.latest_encumbrance_year
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
1746: ,aeh.gl_transfer_date
1747: ,aeh.gl_transfer_status_code
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