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.

[Home] [Help]

APPS.XLA_TB_BALANCE_PKG dependencies on XLA_TB_DEFINITIONS_B

Line 34: (definition_code xla_tb_definitions_b.definition_code%TYPE

30: g_mode VARCHAR2(30); -- C_CREATE_MODE / C_UPDATE_MODE
31:
32:
33: TYPE r_definition IS RECORD
34: (definition_code xla_tb_definitions_b.definition_code%TYPE
35: ,name xla_tb_definitions_tl.name%TYPE
36: ,ledger_id xla_tb_definitions_b.ledger_id%TYPE
37: ,description xla_tb_definitions_tl.description%TYPE
38: ,balance_side_code xla_tb_definitions_b.balance_side_code%TYPE);

Line 36: ,ledger_id xla_tb_definitions_b.ledger_id%TYPE

32:
33: TYPE r_definition IS RECORD
34: (definition_code xla_tb_definitions_b.definition_code%TYPE
35: ,name xla_tb_definitions_tl.name%TYPE
36: ,ledger_id xla_tb_definitions_b.ledger_id%TYPE
37: ,description xla_tb_definitions_tl.description%TYPE
38: ,balance_side_code xla_tb_definitions_b.balance_side_code%TYPE);
39:
40:

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

34: (definition_code xla_tb_definitions_b.definition_code%TYPE
35: ,name xla_tb_definitions_tl.name%TYPE
36: ,ledger_id xla_tb_definitions_b.ledger_id%TYPE
37: ,description xla_tb_definitions_tl.description%TYPE
38: ,balance_side_code xla_tb_definitions_b.balance_side_code%TYPE);
39:
40:
41: --
42:

Line 198: FROM xla_tb_definitions_b

194: -- Check if Definition Code exists in db
195: --
196: SELECT COUNT(1)
197: INTO l_db_cnt
198: FROM xla_tb_definitions_b
199: WHERE definition_code = p_definition_rec.definition_code;
200:
201: IF l_db_cnt = 0 THEN
202:

Line 1082: l_ledger_id xla_tb_definitions_b.ledger_id%TYPE;

1078: C_DEFN_STATUS_CODE CONSTANT VARCHAR2(30) := 'NEW';
1079: C_DEFN_OWNER_CODE CONSTANT VARCHAR2(30) := 'S';
1080:
1081: l_ovn NUMBER;
1082: l_ledger_id xla_tb_definitions_b.ledger_id%TYPE;
1083: l_enabled_flag xla_tb_definitions_b.enabled_flag%TYPE;
1084: l_balance_side_code xla_tb_definitions_b.balance_side_code%TYPE;
1085: l_defined_by_code xla_tb_definitions_b.defined_by_code%TYPE;
1086: l_definition_status_code xla_tb_definitions_b.definition_status_code%TYPE;

Line 1083: l_enabled_flag xla_tb_definitions_b.enabled_flag%TYPE;

1079: C_DEFN_OWNER_CODE CONSTANT VARCHAR2(30) := 'S';
1080:
1081: l_ovn NUMBER;
1082: l_ledger_id xla_tb_definitions_b.ledger_id%TYPE;
1083: l_enabled_flag xla_tb_definitions_b.enabled_flag%TYPE;
1084: l_balance_side_code xla_tb_definitions_b.balance_side_code%TYPE;
1085: l_defined_by_code xla_tb_definitions_b.defined_by_code%TYPE;
1086: l_definition_status_code xla_tb_definitions_b.definition_status_code%TYPE;
1087: l_owner_code xla_tb_definitions_b.owner_code%TYPE;

Line 1084: l_balance_side_code xla_tb_definitions_b.balance_side_code%TYPE;

1080:
1081: l_ovn NUMBER;
1082: l_ledger_id xla_tb_definitions_b.ledger_id%TYPE;
1083: l_enabled_flag xla_tb_definitions_b.enabled_flag%TYPE;
1084: l_balance_side_code xla_tb_definitions_b.balance_side_code%TYPE;
1085: l_defined_by_code xla_tb_definitions_b.defined_by_code%TYPE;
1086: l_definition_status_code xla_tb_definitions_b.definition_status_code%TYPE;
1087: l_owner_code xla_tb_definitions_b.owner_code%TYPE;
1088: l_name xla_tb_definitions_vl.NAME%TYPE;

Line 1085: l_defined_by_code xla_tb_definitions_b.defined_by_code%TYPE;

1081: l_ovn NUMBER;
1082: l_ledger_id xla_tb_definitions_b.ledger_id%TYPE;
1083: l_enabled_flag xla_tb_definitions_b.enabled_flag%TYPE;
1084: l_balance_side_code xla_tb_definitions_b.balance_side_code%TYPE;
1085: l_defined_by_code xla_tb_definitions_b.defined_by_code%TYPE;
1086: l_definition_status_code xla_tb_definitions_b.definition_status_code%TYPE;
1087: l_owner_code xla_tb_definitions_b.owner_code%TYPE;
1088: l_name xla_tb_definitions_vl.NAME%TYPE;
1089: l_description xla_tb_definitions_vl.description%TYPE;

Line 1086: l_definition_status_code xla_tb_definitions_b.definition_status_code%TYPE;

1082: l_ledger_id xla_tb_definitions_b.ledger_id%TYPE;
1083: l_enabled_flag xla_tb_definitions_b.enabled_flag%TYPE;
1084: l_balance_side_code xla_tb_definitions_b.balance_side_code%TYPE;
1085: l_defined_by_code xla_tb_definitions_b.defined_by_code%TYPE;
1086: l_definition_status_code xla_tb_definitions_b.definition_status_code%TYPE;
1087: l_owner_code xla_tb_definitions_b.owner_code%TYPE;
1088: l_name xla_tb_definitions_vl.NAME%TYPE;
1089: l_description xla_tb_definitions_vl.description%TYPE;
1090:

Line 1087: l_owner_code xla_tb_definitions_b.owner_code%TYPE;

1083: l_enabled_flag xla_tb_definitions_b.enabled_flag%TYPE;
1084: l_balance_side_code xla_tb_definitions_b.balance_side_code%TYPE;
1085: l_defined_by_code xla_tb_definitions_b.defined_by_code%TYPE;
1086: l_definition_status_code xla_tb_definitions_b.definition_status_code%TYPE;
1087: l_owner_code xla_tb_definitions_b.owner_code%TYPE;
1088: l_name xla_tb_definitions_vl.NAME%TYPE;
1089: l_description xla_tb_definitions_vl.description%TYPE;
1090:
1091: l_creation_date DATE;

Line 1856: ,xla_tb_definitions_b xtd

1852: ,xla_environment_pkg.g_Prog_Appl_Id
1853: ,xla_environment_pkg.g_Prog_Id
1854: ,SYSDATE
1855: FROM xla_trial_balances xtb
1856: ,xla_tb_definitions_b xtd
1857: ,xla_event_class_attrs xeca
1858: WHERE xeca.event_class_code <> 'MANUAL'
1859: AND xtb.event_class_code = xeca.event_class_code
1860: AND xtb.source_application_id = xeca.application_id

Line 2167: ,xla_tb_definitions_b xtd

2163: xla_ae_headers PARTITION (AP) xah
2164: ,ap_liability_balance alb
2165: ,xla_event_types_b xet
2166: ,xla_tb_defn_details xdd
2167: ,xla_tb_definitions_b xtd
2168: ,xla_tb_defn_je_sources xjs
2169: ,xla_subledgers xsu
2170: ,xla_transaction_entities_upg PARTITION (AP) xteu
2171: ,xla_ae_lines PARTITION (AP) xal

Line 2355: FROM xla_tb_definitions_b

2351: FROM xla_tb_balances_gt tb
2352: WHERE definition_code NOT IN
2353: (
2354: SELECT definition_code
2355: FROM xla_tb_definitions_b
2356: );
2357:
2358: IF (C_LEVEL_STATEMENT>= g_log_level) THEN
2359: trace

Line 2366: INSERT INTO xla_tb_definitions_b

2362: ,p_module => l_log_module);
2363: END IF;
2364:
2365: FORALL i IN l_array_defn_code.first .. l_array_defn_code.last
2366: INSERT INTO xla_tb_definitions_b
2367: (definition_code
2368: ,object_version_number
2369: ,ledger_id
2370: ,enabled_flag

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

2398: ,'S');
2399:
2400: IF (C_LEVEL_STATEMENT>= g_log_level) THEN
2401: trace
2402: (p_msg => 'inserted definition into the xla_tb_definitions_b:'|| SQL%ROWCOUNT
2403: ,p_level => C_LEVEL_STATEMENT
2404: ,p_module => l_log_module);
2405: END IF;
2406: