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

Line 59: g_definition_code xla_tb_definitions_b.definition_code%TYPE;

55: g_prog_appl_id NUMBER(15);
56: g_program_id NUMBER(15);
57: g_ledger_id PLS_INTEGER;
58: g_group_id xla_ae_headers.group_id%TYPE;
59: g_definition_code xla_tb_definitions_b.definition_code%TYPE;
60: g_process_mode_code VARCHAR2(30);
61: g_je_source_name gl_je_sources.je_source_name%TYPE;
62: g_application_id PLS_INTEGER;
63: g_tb_insert_sql VARCHAR2(32000);

Line 345: ,xla_tb_definitions_b xtd

341: ,fnd_currencies fdc
342: ,gl_ledgers gl
343: ,gl_code_combinations gcc
344: ,xla_event_types_b xet
345: ,xla_tb_definitions_b xtd
346: $l_from$
347: WHERE xah.ae_header_id BETWEEN :7 AND :8
348: AND xah.upg_batch_id IS NULL -- added bug 6704677
349: $l_ledger_where$

Line 564: ,xla_tb_definitions_b xtd

560: ap_liability_balance alb
561: ,xla_ae_headers PARTITION (AP) xah
562: ,xla_event_types_b xet
563: ,xla_tb_defn_details xdd
564: ,xla_tb_definitions_b xtd
565: ,xla_tb_defn_je_sources xjs
566: ,xla_subledgers xsu
567: ,xla_transaction_entities_upg PARTITION (AP) xteu
568: ,xla_ae_lines PARTITION (AP) xal

Line 854: ,xla_tb_definitions_b xtd

850: ap_liability_balance alb
851: ,xla_ae_headers PARTITION (AP) xah
852: ,xla_event_types_b xet
853: ,xla_tb_defn_details xdd
854: ,xla_tb_definitions_b xtd
855: ,xla_tb_defn_je_sources xjs
856: ,xla_subledgers xsu
857: ,xla_transaction_entities_upg PARTITION (AP) xteu
858: ,xla_ae_lines PARTITION (AP) xal

Line 1325: FROM xla_tb_definitions_b xtd

1321: END IF;
1322:
1323: SELECT defined_by_code
1324: INTO l_define_by_code
1325: FROM xla_tb_definitions_b xtd
1326: WHERE xtd.definition_code = p_definition_code;
1327:
1328: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1329: trace('Defined By Code = ' || l_define_by_code

Line 1545: ||' FROM xla_tb_definitions_b xtd '

1541: || ')
1542: SELECT xtd.definition_code
1543: ,ROWNUM '
1544: || l_sel_columns
1545: ||' FROM xla_tb_definitions_b xtd '
1546: || l_tables
1547: ||' WHERE xtd.definition_code = :1 '
1548: || l_joins;
1549:

Line 1867: DELETE xla_tb_definitions_b

1863: END IF;
1864:
1865: IF g_je_source_name IS NULL THEN
1866:
1867: DELETE xla_tb_definitions_b
1868: WHERE definition_code = p_definition_code;
1869:
1870: DELETE xla_tb_definitions_tl
1871: WHERE definition_code = p_definition_code;

Line 2063: FROM xla_tb_definitions_b xtd

2059: ,l_definition_info.balance_side_code
2060: ,l_definition_info.defined_by_code
2061: ,l_definition_info.definition_status_code
2062: ,l_definition_info.owner_code
2063: FROM xla_tb_definitions_b xtd
2064: WHERE xtd.definition_code = p_definition_code;
2065:
2066: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
2067: trace

Line 2640: xla_tb_definitions_b xtd

2636: ,SYSDATE
2637: from xla_ae_headers xah,
2638: xla_event_types_b xet,
2639: xla_event_class_attrs xeca,
2640: xla_tb_definitions_b xtd
2641: WHERE xet.event_class_code <> 'MANUAL'
2642: AND xet.event_type_code = xah.event_type_code
2643: AND xet.event_class_code = xeca.event_class_code
2644: AND xeca.application_id = xet.application_id

Line 2699: ,xla_tb_definitions_b xtd

2695: ,g_prog_appl_id
2696: ,g_program_id
2697: ,SYSDATE
2698: FROM xla_trial_balances xtb
2699: ,xla_tb_definitions_b xtd
2700: ,xla_event_class_attrs xeca
2701: WHERE xeca.event_class_code <> 'MANUAL'
2702: AND xtb.event_class_code = xeca.event_class_code
2703: AND xtb.source_application_id = xeca.application_id

Line 2837: l_defined_by_code xla_tb_definitions_b.defined_by_code%TYPE;

2833: PROCEDURE insert_trial_balance_upg
2834: (p_definition_code IN VARCHAR2)
2835: IS
2836:
2837: l_defined_by_code xla_tb_definitions_b.defined_by_code%TYPE;
2838: l_sql VARCHAR2(32000);
2839: l_log_module VARCHAR2(240);
2840: l_bal_segment_column VARCHAR2(30);
2841: l_acct_segment_column VARCHAR2(30);

Line 2993: l_defined_by_code xla_tb_definitions_b.defined_by_code%TYPE;

2989: ,p_from_header_id IN PLS_INTEGER
2990: ,p_to_header_id IN PLS_INTEGER
2991: ) IS
2992:
2993: l_defined_by_code xla_tb_definitions_b.defined_by_code%TYPE;
2994: l_owner_code xla_tb_definitions_b.owner_code%TYPE;
2995: l_sql VARCHAR2(32000);
2996: l_upg_sql VARCHAR2(32000);
2997: l_from VARCHAR2(4000);

Line 2994: l_owner_code xla_tb_definitions_b.owner_code%TYPE;

2990: ,p_to_header_id IN PLS_INTEGER
2991: ) IS
2992:
2993: l_defined_by_code xla_tb_definitions_b.defined_by_code%TYPE;
2994: l_owner_code xla_tb_definitions_b.owner_code%TYPE;
2995: l_sql VARCHAR2(32000);
2996: l_upg_sql VARCHAR2(32000);
2997: l_from VARCHAR2(4000);
2998: l_where VARCHAR2(4000);

Line 3111: FROM xla_tb_definitions_b

3107: SELECT defined_by_code
3108: ,owner_code
3109: INTO l_defined_by_code
3110: ,l_owner_code
3111: FROM xla_tb_definitions_b
3112: WHERE definition_code = p_definition_code;
3113:
3114: IF l_defined_by_code = 'FLEXFIELD' THEN
3115: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 3861: UPDATE xla_tb_definitions_b

3857: ,p_module => l_log_module);
3858:
3859: END IF;
3860:
3861: UPDATE xla_tb_definitions_b
3862: SET definition_status_code = p_status_code
3863: ,last_updated_by = g_user_id
3864: ,last_update_date = SYSDATE
3865: ,last_update_login = g_login_id

Line 4060: ,xla_tb_definitions_b xtd

4056: )/C_WORK_UNIT
4057: ) wu
4058: FROM xla_ae_headers aeh
4059: ,xla_subledgers xsu
4060: ,xla_tb_definitions_b xtd
4061: ,xla_tb_defn_je_sources xjs
4062: WHERE gl_transfer_status_code IN ('Y','NT')
4063: AND aeh.ledger_id IN (
4064: SELECT lg.ledger_id

Line 4108: ,xla_tb_definitions_b xtd

4104: )/C_WORK_UNIT
4105: ) wu
4106: FROM xla_ae_headers aeh
4107: ,xla_subledgers xsu
4108: ,xla_tb_definitions_b xtd
4109: ,xla_tb_defn_je_sources xjs
4110: WHERE gl_transfer_status_code IN ('Y','NT')
4111: AND aeh.ledger_id = p_ledger_id
4112: AND xtd.definition_code = p_definition_code

Line 4166: ,xla_tb_definitions_b xtd

4162: )/C_WORK_UNIT
4163: ) wu
4164: FROM xla_ae_headers aeh
4165: ,xla_subledgers xsu
4166: ,xla_tb_definitions_b xtd
4167: ,xla_tb_defn_je_sources xjs
4168: WHERE gl_transfer_status_code IN ('Y','NT')
4169: AND aeh.ledger_id IN (
4170: SELECT lg.ledger_id

Line 4219: ,xla_tb_definitions_b xtd

4215: )/C_WORK_UNIT
4216: ) wu
4217: FROM xla_ae_headers aeh
4218: ,xla_subledgers xsu
4219: ,xla_tb_definitions_b xtd
4220: ,xla_tb_defn_je_sources xjs
4221: WHERE gl_transfer_status_code IN ('Y','NT')
4222: AND aeh.ledger_id = p_ledger_id
4223: AND xtd.definition_code = p_definition_code

Line 4824: l_definition_code xla_tb_definitions_b.definition_code%TYPE;

4820: ) IS
4821:
4822: l_from_header_id NUMBER(15);
4823: l_to_header_id NUMBER(15);
4824: l_definition_code xla_tb_definitions_b.definition_code%TYPE;
4825: l_log_module VARCHAR2(240);
4826: l_owner_code VARCHAR2(1);
4827: BEGIN
4828:

Line 4916: FROM xla_tb_definitions_b

4912: For upgraded report definitions, insert_trial_balance_upg will fail
4913: with ORA-1400 as balance date is null.
4914:
4915: FOR c_def IN (SELECT definition_code
4916: FROM xla_tb_definitions_b
4917: WHERE definition_code = NVL(p_definition_code,definition_code)
4918: AND ledger_id = p_ledger_id
4919: AND owner_code = 'S')
4920: LOOP