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_TB_BALANCE_PKG dependencies on XLA_TB_DEFINITIONS_B

Line 45: (definition_code xla_tb_definitions_b.definition_code%TYPE

41: g_mode VARCHAR2(30); -- C_CREATE_MODE / C_UPDATE_MODE
42:
43:
44: TYPE r_definition IS RECORD
45: (definition_code xla_tb_definitions_b.definition_code%TYPE
46: ,name xla_tb_definitions_tl.name%TYPE
47: ,ledger_id xla_tb_definitions_b.ledger_id%TYPE
48: ,description xla_tb_definitions_tl.description%TYPE
49: ,balance_side_code xla_tb_definitions_b.balance_side_code%TYPE);

Line 47: ,ledger_id xla_tb_definitions_b.ledger_id%TYPE

43:
44: TYPE r_definition IS RECORD
45: (definition_code xla_tb_definitions_b.definition_code%TYPE
46: ,name xla_tb_definitions_tl.name%TYPE
47: ,ledger_id xla_tb_definitions_b.ledger_id%TYPE
48: ,description xla_tb_definitions_tl.description%TYPE
49: ,balance_side_code xla_tb_definitions_b.balance_side_code%TYPE);
50:
51:

Line 49: ,balance_side_code xla_tb_definitions_b.balance_side_code%TYPE);

45: (definition_code xla_tb_definitions_b.definition_code%TYPE
46: ,name xla_tb_definitions_tl.name%TYPE
47: ,ledger_id xla_tb_definitions_b.ledger_id%TYPE
48: ,description xla_tb_definitions_tl.description%TYPE
49: ,balance_side_code xla_tb_definitions_b.balance_side_code%TYPE);
50:
51:
52: --
53:

Line 210: FROM xla_tb_definitions_b

206: -- Check if Definition Code exists in db
207: --
208: SELECT COUNT(1)
209: INTO l_db_cnt
210: FROM xla_tb_definitions_b
211: WHERE definition_code = p_definition_rec.definition_code;
212:
213: IF l_db_cnt = 0 THEN
214:

Line 1094: l_ledger_id xla_tb_definitions_b.ledger_id%TYPE;

1090: C_DEFN_STATUS_CODE CONSTANT VARCHAR2(30) := 'NEW';
1091: C_DEFN_OWNER_CODE CONSTANT VARCHAR2(30) := 'S';
1092:
1093: l_ovn NUMBER;
1094: l_ledger_id xla_tb_definitions_b.ledger_id%TYPE;
1095: l_enabled_flag xla_tb_definitions_b.enabled_flag%TYPE;
1096: l_balance_side_code xla_tb_definitions_b.balance_side_code%TYPE;
1097: l_defined_by_code xla_tb_definitions_b.defined_by_code%TYPE;
1098: l_definition_status_code xla_tb_definitions_b.definition_status_code%TYPE;

Line 1095: l_enabled_flag xla_tb_definitions_b.enabled_flag%TYPE;

1091: C_DEFN_OWNER_CODE CONSTANT VARCHAR2(30) := 'S';
1092:
1093: l_ovn NUMBER;
1094: l_ledger_id xla_tb_definitions_b.ledger_id%TYPE;
1095: l_enabled_flag xla_tb_definitions_b.enabled_flag%TYPE;
1096: l_balance_side_code xla_tb_definitions_b.balance_side_code%TYPE;
1097: l_defined_by_code xla_tb_definitions_b.defined_by_code%TYPE;
1098: l_definition_status_code xla_tb_definitions_b.definition_status_code%TYPE;
1099: l_owner_code xla_tb_definitions_b.owner_code%TYPE;

Line 1096: l_balance_side_code xla_tb_definitions_b.balance_side_code%TYPE;

1092:
1093: l_ovn NUMBER;
1094: l_ledger_id xla_tb_definitions_b.ledger_id%TYPE;
1095: l_enabled_flag xla_tb_definitions_b.enabled_flag%TYPE;
1096: l_balance_side_code xla_tb_definitions_b.balance_side_code%TYPE;
1097: l_defined_by_code xla_tb_definitions_b.defined_by_code%TYPE;
1098: l_definition_status_code xla_tb_definitions_b.definition_status_code%TYPE;
1099: l_owner_code xla_tb_definitions_b.owner_code%TYPE;
1100: l_name xla_tb_definitions_vl.NAME%TYPE;

Line 1097: l_defined_by_code xla_tb_definitions_b.defined_by_code%TYPE;

1093: l_ovn NUMBER;
1094: l_ledger_id xla_tb_definitions_b.ledger_id%TYPE;
1095: l_enabled_flag xla_tb_definitions_b.enabled_flag%TYPE;
1096: l_balance_side_code xla_tb_definitions_b.balance_side_code%TYPE;
1097: l_defined_by_code xla_tb_definitions_b.defined_by_code%TYPE;
1098: l_definition_status_code xla_tb_definitions_b.definition_status_code%TYPE;
1099: l_owner_code xla_tb_definitions_b.owner_code%TYPE;
1100: l_name xla_tb_definitions_vl.NAME%TYPE;
1101: l_description xla_tb_definitions_vl.description%TYPE;

Line 1098: l_definition_status_code xla_tb_definitions_b.definition_status_code%TYPE;

1094: l_ledger_id xla_tb_definitions_b.ledger_id%TYPE;
1095: l_enabled_flag xla_tb_definitions_b.enabled_flag%TYPE;
1096: l_balance_side_code xla_tb_definitions_b.balance_side_code%TYPE;
1097: l_defined_by_code xla_tb_definitions_b.defined_by_code%TYPE;
1098: l_definition_status_code xla_tb_definitions_b.definition_status_code%TYPE;
1099: l_owner_code xla_tb_definitions_b.owner_code%TYPE;
1100: l_name xla_tb_definitions_vl.NAME%TYPE;
1101: l_description xla_tb_definitions_vl.description%TYPE;
1102:

Line 1099: l_owner_code xla_tb_definitions_b.owner_code%TYPE;

1095: l_enabled_flag xla_tb_definitions_b.enabled_flag%TYPE;
1096: l_balance_side_code xla_tb_definitions_b.balance_side_code%TYPE;
1097: l_defined_by_code xla_tb_definitions_b.defined_by_code%TYPE;
1098: l_definition_status_code xla_tb_definitions_b.definition_status_code%TYPE;
1099: l_owner_code xla_tb_definitions_b.owner_code%TYPE;
1100: l_name xla_tb_definitions_vl.NAME%TYPE;
1101: l_description xla_tb_definitions_vl.description%TYPE;
1102:
1103: l_creation_date DATE;

Line 2180: ,xla_tb_definitions_b xtd

2176: xla_ae_headers PARTITION (AP) xah
2177: ,ap_liability_balance alb
2178: ,xla_event_types_b xet
2179: ,xla_tb_defn_details xdd
2180: ,xla_tb_definitions_b xtd
2181: ,xla_tb_defn_je_sources xjs
2182: ,xla_subledgers xsu
2183: ,xla_transaction_entities_upg PARTITION (AP) xteu
2184: ,xla_ae_lines PARTITION (AP) xal

Line 2368: FROM xla_tb_definitions_b

2364: FROM xla_tb_balances_gt tb
2365: WHERE definition_code NOT IN
2366: (
2367: SELECT definition_code
2368: FROM xla_tb_definitions_b
2369: );
2370:
2371: IF (C_LEVEL_STATEMENT>= g_log_level) THEN
2372: trace

Line 2379: INSERT INTO xla_tb_definitions_b

2375: ,p_module => l_log_module);
2376: END IF;
2377:
2378: FORALL i IN l_array_defn_code.first .. l_array_defn_code.last
2379: INSERT INTO xla_tb_definitions_b
2380: (definition_code
2381: ,object_version_number
2382: ,ledger_id
2383: ,enabled_flag

Line 2415: (p_msg => 'inserted definition into the xla_tb_definitions_b:'|| SQL%ROWCOUNT

2411: ,'S');
2412:
2413: IF (C_LEVEL_STATEMENT>= g_log_level) THEN
2414: trace
2415: (p_msg => 'inserted definition into the xla_tb_definitions_b:'|| SQL%ROWCOUNT
2416: ,p_level => C_LEVEL_STATEMENT
2417: ,p_module => l_log_module);
2418: END IF;
2419:

Line 2795: FROM XLA_TB_DEFINITIONS_B TB

2791: END LOOP;
2792: END IF;
2793: */
2794: FOR i in ( SELECT TB.DEFINITION_CODE , TB.LEDGER_ID
2795: FROM XLA_TB_DEFINITIONS_B TB
2796: WHERE NOT EXISTS
2797: ( SELECT 1
2798: FROM DBA_TAB_PARTITIONS
2799: WHERE TABLE_NAME = 'XLA_TRIAL_BALANCES'