APPS.XLA_TRANSFER_PKG dependencies on GL_LEDGERS

Line 96: ,NAME gl_ledgers.NAME%TYPE

92: TYPE t_array_ids IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
93:
94: TYPE r_ledger_rec IS RECORD
95: (ledger_id NUMBER
96: ,NAME gl_ledgers.NAME%TYPE
97: ,ledger_category_code gl_ledgers.ledger_category_code%TYPE
98: ,group_id gl_interface.group_id%TYPE
99: ,interface_run_id gl_interface_control.interface_run_id%TYPE
100: ,gllezl_request_id NUMBER

Line 97: ,ledger_category_code gl_ledgers.ledger_category_code%TYPE

93:
94: TYPE r_ledger_rec IS RECORD
95: (ledger_id NUMBER
96: ,NAME gl_ledgers.NAME%TYPE
97: ,ledger_category_code gl_ledgers.ledger_category_code%TYPE
98: ,group_id gl_interface.group_id%TYPE
99: ,interface_run_id gl_interface_control.interface_run_id%TYPE
100: ,gllezl_request_id NUMBER
101: ,access_set_id NUMBER

Line 148: g_budgetary_control_flag gl_ledgers.enable_budgetary_control_flag%TYPE;

144: g_transfer_summary_mode VARCHAR2(1);
145: g_access_set_id PLS_INTEGER := fnd_profile.value('GL_ACCESS_SET_ID');
146: g_sec_access_set_id PLS_INTEGER := fnd_profile.value('XLA_GL_SECONDARY_ACCESS_SET_ID');
147: g_gl_interface_table_name VARCHAR2(30);
148: g_budgetary_control_flag gl_ledgers.enable_budgetary_control_flag%TYPE;
149: --
150: -- Flow Control Flags
151: --
152: g_proceed VARCHAR2(1) := 'Y';

Line 599: l_ledger_name gl_ledgers.NAME%TYPE;

595: 'PRIMARY',1,
596: 'ALC',2
597: ,3);
598:
599: l_ledger_name gl_ledgers.NAME%TYPE;
600: l_count PLS_INTEGER := 0;
601: l_alc_count PLS_INTEGER := 0;
602: l_log_module VARCHAR2(240);
603: l_ledger_category_code gl_ledgers.ledger_category_code%TYPE;

Line 603: l_ledger_category_code gl_ledgers.ledger_category_code%TYPE;

599: l_ledger_name gl_ledgers.NAME%TYPE;
600: l_count PLS_INTEGER := 0;
601: l_alc_count PLS_INTEGER := 0;
602: l_log_module VARCHAR2(240);
603: l_ledger_category_code gl_ledgers.ledger_category_code%TYPE;
604:
605:
606: BEGIN
607: IF g_log_enabled THEN

Line 625: FROM gl_ledgers led

621: ,enable_budgetary_control_flag
622: INTO l_ledger_name
623: ,l_ledger_category_code
624: ,g_budgetary_control_flag
625: FROM gl_ledgers led
626: WHERE led.ledger_id = p_ledger_id;
627:
628:
629: --

Line 751: FROM gl_access_sets aset, gl_ledgers led

747: IF (g_access_set_id IS NOT NULL OR g_sec_access_set_id IS NOT NULL) THEN
748: BEGIN
749: SELECT access_set_id
750: INTO l_access_set_id
751: FROM gl_access_sets aset, gl_ledgers led
752: WHERE aset.chart_of_accounts_id = led.chart_of_accounts_id
753: AND led.ledger_id = p_ledger_id
754: AND aset.access_set_id IN (g_access_set_id, g_sec_access_set_id)
755: AND ROWNUM = 1;

Line 773: FROM gl_ledgers led

769: END IF;
770: ELSE
771: SELECT implicit_access_set_id
772: INTO l_access_set_id
773: FROM gl_ledgers led
774: WHERE led.ledger_id = p_ledger_id;
775: END IF;
776:
777: g_all_ledgers_tab(p_ledger_id).access_set_id := l_access_set_id;

Line 1338: ,gl_ledgers gll

1334: ' SELECT DISTINCT aeh.ledger_id
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

Line 1554: ,gl_ledgers gll

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

Line 2059: ,gl_ledgers led

2055: FROM xla_ae_headers aeh
2056: ,xla_ae_lines ael
2057: ,gl_je_categories jc
2058: ,gl_period_statuses gps
2059: ,gl_ledgers led
2060: WHERE ael.application_id = aeh.application_id
2061: AND ael.ae_header_id = aeh.ae_header_id
2062: AND aeh.group_id = :11
2063: AND aeh.application_id = :12 --4769315