DBA Data[Home] [Help]

APPS.XLA_TRANSFER_PKG dependencies on XLA_TRANSACTION_ENTITIES

Line 120: g_security_id_int_1 xla_transaction_entities.source_id_int_1%TYPE;

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;

Line 121: g_security_id_int_2 xla_transaction_entities.source_id_int_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;

Line 122: g_security_id_int_3 xla_transaction_entities.source_id_int_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;

Line 123: g_security_id_char_1 xla_transaction_entities.source_id_char_1%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);

Line 124: g_security_id_char_2 xla_transaction_entities.source_id_char_2%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);
128:

Line 125: g_security_id_char_3 xla_transaction_entities.source_id_char_3%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:
129:

Line 126: g_valuation_method xla_transaction_entities.valuation_method%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:
130: -- Batch level global variables

Line 1395: ,xla_transaction_entities xte

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

Line 1474: ,xla_transaction_entities xte

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

Line 1551: ,xla_transaction_entities xte

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

Line 1750: ,xla_transaction_entities xte

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