eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XLA_TRANSFER_PKG dependencies on GL_LEDGERS

Line 126: ,NAME gl_ledgers.NAME%TYPE

122: TYPE t_array_ids IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
123:
124: TYPE r_ledger_rec IS RECORD
125: (ledger_id NUMBER
126: ,NAME gl_ledgers.NAME%TYPE
127: ,ledger_category_code gl_ledgers.ledger_category_code%TYPE
128: ,group_id gl_interface.group_id%TYPE
129: ,interface_run_id gl_interface_control.interface_run_id%TYPE
130: ,gllezl_request_id NUMBER

Line 127: ,ledger_category_code gl_ledgers.ledger_category_code%TYPE

123:
124: TYPE r_ledger_rec IS RECORD
125: (ledger_id NUMBER
126: ,NAME gl_ledgers.NAME%TYPE
127: ,ledger_category_code gl_ledgers.ledger_category_code%TYPE
128: ,group_id gl_interface.group_id%TYPE
129: ,interface_run_id gl_interface_control.interface_run_id%TYPE
130: ,gllezl_request_id NUMBER
131: ,access_set_id NUMBER

Line 179: g_budgetary_control_flag gl_ledgers.enable_budgetary_control_flag%TYPE;

175: g_transfer_summary_mode VARCHAR2(1);
176: g_access_set_id PLS_INTEGER := fnd_profile.value('GL_ACCESS_SET_ID');
177: g_sec_access_set_id PLS_INTEGER := fnd_profile.value('XLA_GL_SECONDARY_ACCESS_SET_ID');
178: g_gl_interface_table_name VARCHAR2(30);
179: g_budgetary_control_flag gl_ledgers.enable_budgetary_control_flag%TYPE;
180: --
181: -- Flow Control Flags
182: --
183: g_proceed VARCHAR2(1) := 'Y';

Line 401: l_ledger_category gl_ledgers.ledger_category_code%type;

397: l_log_module VARCHAR2(240);
398: l_packet_id NUMBER := 0;
399: l_bc_count NUMBER := 0;
400: l_arrival_seq NUMBER := 0;
401: l_ledger_category gl_ledgers.ledger_category_code%type;
402:
403:
404: BEGIN
405: IF g_log_enabled THEN

Line 470: FROM gl_ledgers led

466: loop
467:
468: SELECT enable_budgetary_control_flag, ledger_category_code
469: INTO g_budgetary_control_flag, l_ledger_category
470: FROM gl_ledgers led
471: WHERE led.ledger_id = g_ledger_id_tab(i);
472:
473: IF (C_LEVEL_EVENT >= g_log_level) THEN
474: trace('Ledger_id in loop is = ' || g_ledger_id_tab(i)

Line 1035: l_ledger_name gl_ledgers.NAME%TYPE;

1031: 'PRIMARY',1,
1032: 'ALC',2
1033: ,3);
1034:
1035: l_ledger_name gl_ledgers.NAME%TYPE;
1036: l_count PLS_INTEGER := 0;
1037: l_alc_count PLS_INTEGER := 0;
1038: l_log_module VARCHAR2(240);
1039: l_ledger_category_code gl_ledgers.ledger_category_code%TYPE;

Line 1039: l_ledger_category_code gl_ledgers.ledger_category_code%TYPE;

1035: l_ledger_name gl_ledgers.NAME%TYPE;
1036: l_count PLS_INTEGER := 0;
1037: l_alc_count PLS_INTEGER := 0;
1038: l_log_module VARCHAR2(240);
1039: l_ledger_category_code gl_ledgers.ledger_category_code%TYPE;
1040:
1041:
1042: BEGIN
1043: IF g_log_enabled THEN

Line 1061: FROM gl_ledgers led

1057: ,enable_budgetary_control_flag
1058: INTO l_ledger_name
1059: ,l_ledger_category_code
1060: ,g_budgetary_control_flag
1061: FROM gl_ledgers led
1062: WHERE led.ledger_id = p_ledger_id;
1063:
1064:
1065: --

Line 1188: FROM gl_access_sets aset, gl_ledgers led

1184: BEGIN
1185: --Added for bug 9839301
1186: /*SELECT access_set_id
1187: INTO l_access_set_id
1188: FROM gl_access_sets aset, gl_ledgers led
1189: WHERE aset.chart_of_accounts_id = led.chart_of_accounts_id
1190: AND led.ledger_id = p_ledger_id
1191: AND aset.access_set_id IN (g_access_set_id, g_sec_access_set_id)
1192: AND ROWNUM = 1;*/

Line 1217: FROM gl_ledgers led

1213: END IF;
1214: ELSE
1215: SELECT implicit_access_set_id
1216: INTO l_access_set_id
1217: FROM gl_ledgers led
1218: WHERE led.ledger_id = p_ledger_id;
1219: END IF;
1220:
1221: g_all_ledgers_tab(p_ledger_id).access_set_id := l_access_set_id;

Line 1875: ,gl_ledgers gll

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

Line 2091: ,gl_ledgers gll

2087: ,gl_period_statuses gps
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

Line 2712: ,gl_ledgers led

2708: FROM xla_ae_headers aeh
2709: ,xla_ae_lines ael
2710: ,gl_je_categories jc
2711: ,gl_period_statuses gps
2712: ,gl_ledgers led
2713: WHERE ael.application_id = aeh.application_id
2714: AND ael.ae_header_id = aeh.ae_header_id
2715: AND aeh.group_id = :12
2716: AND aeh.application_id = :13 --4769315