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 74: g_definition_code xla_tb_definitions_b.definition_code%TYPE;

70: g_prog_appl_id NUMBER(15);
71: g_program_id NUMBER(15);
72: g_ledger_id PLS_INTEGER;
73: g_group_id xla_ae_headers.group_id%TYPE;
74: g_definition_code xla_tb_definitions_b.definition_code%TYPE;
75: g_process_mode_code VARCHAR2(30);
76: g_je_source_name gl_je_sources.je_source_name%TYPE;
77: g_application_id PLS_INTEGER;
78: g_tb_insert_sql VARCHAR2(32000);

Line 360: ,xla_tb_definitions_b xtd

356: ,fnd_currencies fdc
357: ,gl_ledgers gl
358: ,gl_code_combinations gcc
359: ,xla_event_types_b xet
360: ,xla_tb_definitions_b xtd
361: $l_from$
362: WHERE xah.ae_header_id BETWEEN :7 AND :8
363: AND xah.upg_batch_id IS NULL -- added bug 6704677
364: $l_ledger_where$

Line 582: ,xla_tb_definitions_b xtd

578: FROM
579: ap_liability_balance alb
580: ,xla_ae_headers PARTITION (AP) xah
581: ,xla_event_types_b xet
582: ,xla_tb_definitions_b xtd
583: $l_from$
584: ,xla_transaction_entities_upg PARTITION (AP) xteu
585: ,xla_ae_lines PARTITION (AP) xal
586: ,gl_code_combinations gcc

Line 887: ,xla_tb_definitions_b xtd

883: FROM
884: ap_liability_balance alb
885: ,xla_ae_headers PARTITION (AP) xah
886: ,xla_event_types_b xet
887: ,xla_tb_definitions_b xtd
888: $l_from$
889: ,xla_transaction_entities_upg PARTITION (AP) xteu
890: ,xla_ae_lines PARTITION (AP) xal
891: ,gl_code_combinations gcc

Line 1370: FROM xla_tb_definitions_b xtd

1366: END IF;
1367:
1368: SELECT defined_by_code
1369: INTO l_define_by_code
1370: FROM xla_tb_definitions_b xtd
1371: WHERE xtd.definition_code = p_definition_code;
1372:
1373: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1374: trace('Defined By Code = ' || l_define_by_code

Line 1594: ||' FROM xla_tb_definitions_b xtd '

1590: || ')
1591: SELECT xtd.definition_code
1592: ,ROWNUM '
1593: || l_sel_columns
1594: ||' FROM xla_tb_definitions_b xtd '
1595: || l_tables
1596: ||' WHERE xtd.definition_code = :1 '
1597: || l_joins;
1598:

Line 1916: DELETE xla_tb_definitions_b

1912: END IF;
1913:
1914: IF g_je_source_name IS NULL THEN
1915:
1916: DELETE xla_tb_definitions_b
1917: WHERE definition_code = p_definition_code;
1918:
1919: DELETE xla_tb_definitions_tl
1920: WHERE definition_code = p_definition_code;

Line 2112: FROM xla_tb_definitions_b xtd

2108: ,l_definition_info.balance_side_code
2109: ,l_definition_info.defined_by_code
2110: ,l_definition_info.definition_status_code
2111: ,l_definition_info.owner_code
2112: FROM xla_tb_definitions_b xtd
2113: WHERE xtd.definition_code = p_definition_code;
2114:
2115: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
2116: trace

Line 2692: xla_tb_definitions_b xtd

2688: ,SYSDATE
2689: from xla_ae_headers xah,
2690: xla_event_types_b xet,
2691: xla_event_class_attrs xeca,
2692: xla_tb_definitions_b xtd
2693: WHERE xet.event_class_code <> 'MANUAL'
2694: AND xet.event_type_code = xah.event_type_code
2695: AND xet.event_class_code = xeca.event_class_code
2696: AND xeca.application_id = xet.application_id

Line 2892: l_defined_by_code xla_tb_definitions_b.defined_by_code%TYPE;

2888: PROCEDURE insert_trial_balance_upg
2889: (p_definition_code IN VARCHAR2)
2890: IS
2891:
2892: l_defined_by_code xla_tb_definitions_b.defined_by_code%TYPE;
2893: l_sql VARCHAR2(32000);
2894: l_log_module VARCHAR2(240);
2895: l_bal_segment_column VARCHAR2(30);
2896: l_acct_segment_column VARCHAR2(30);

Line 3048: l_defined_by_code xla_tb_definitions_b.defined_by_code%TYPE;

3044: ,p_from_header_id IN NUMBER -- 8761772
3045: ,p_to_header_id IN NUMBER -- 8761772
3046: ) IS
3047:
3048: l_defined_by_code xla_tb_definitions_b.defined_by_code%TYPE;
3049: l_owner_code xla_tb_definitions_b.owner_code%TYPE;
3050: l_sql VARCHAR2(32000);
3051: l_upg_sql VARCHAR2(32000);
3052: l_from VARCHAR2(4000);

Line 3049: l_owner_code xla_tb_definitions_b.owner_code%TYPE;

3045: ,p_to_header_id IN NUMBER -- 8761772
3046: ) IS
3047:
3048: l_defined_by_code xla_tb_definitions_b.defined_by_code%TYPE;
3049: l_owner_code xla_tb_definitions_b.owner_code%TYPE;
3050: l_sql VARCHAR2(32000);
3051: l_upg_sql VARCHAR2(32000);
3052: l_from VARCHAR2(4000);
3053: l_where VARCHAR2(4000);

Line 3166: FROM xla_tb_definitions_b

3162: SELECT defined_by_code
3163: ,owner_code
3164: INTO l_defined_by_code
3165: ,l_owner_code
3166: FROM xla_tb_definitions_b
3167: WHERE definition_code = p_definition_code;
3168:
3169: IF l_defined_by_code = 'FLEXFIELD' THEN
3170: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 4014: UPDATE xla_tb_definitions_b

4010: ,p_module => l_log_module);
4011:
4012: END IF;
4013:
4014: UPDATE xla_tb_definitions_b
4015: SET definition_status_code = p_status_code
4016: ,last_updated_by = g_user_id
4017: ,last_update_date = SYSDATE
4018: ,last_update_login = g_login_id

Line 4213: ,xla_tb_definitions_b xtd

4209: )/C_WORK_UNIT
4210: ) wu
4211: FROM xla_ae_headers aeh
4212: ,xla_subledgers xsu
4213: ,xla_tb_definitions_b xtd
4214: ,xla_tb_defn_je_sources xjs
4215: WHERE gl_transfer_status_code IN ('Y','NT')
4216: AND aeh.ledger_id IN (
4217: SELECT lg.ledger_id

Line 4261: ,xla_tb_definitions_b xtd

4257: )/C_WORK_UNIT
4258: ) wu
4259: FROM xla_ae_headers aeh
4260: ,xla_subledgers xsu
4261: ,xla_tb_definitions_b xtd
4262: ,xla_tb_defn_je_sources xjs
4263: WHERE gl_transfer_status_code IN ('Y','NT')
4264: AND aeh.ledger_id = p_ledger_id
4265: AND xtd.definition_code = p_definition_code

Line 4319: ,xla_tb_definitions_b xtd

4315: )/C_WORK_UNIT
4316: ) wu
4317: FROM xla_ae_headers aeh
4318: ,xla_subledgers xsu
4319: ,xla_tb_definitions_b xtd
4320: ,xla_tb_defn_je_sources xjs
4321: WHERE gl_transfer_status_code IN ('Y','NT')
4322: AND aeh.ledger_id IN (
4323: SELECT lg.ledger_id

Line 4372: ,xla_tb_definitions_b xtd

4368: )/C_WORK_UNIT
4369: ) wu
4370: FROM xla_ae_headers aeh
4371: ,xla_subledgers xsu
4372: ,xla_tb_definitions_b xtd
4373: ,xla_tb_defn_je_sources xjs
4374: WHERE gl_transfer_status_code IN ('Y','NT')
4375: AND aeh.ledger_id = p_ledger_id
4376: AND xtd.definition_code = p_definition_code

Line 4980: l_definition_code xla_tb_definitions_b.definition_code%TYPE;

4976: ) IS
4977:
4978: l_from_header_id NUMBER(15);
4979: l_to_header_id NUMBER(15);
4980: l_definition_code xla_tb_definitions_b.definition_code%TYPE;
4981: l_log_module VARCHAR2(240);
4982: l_owner_code VARCHAR2(1);
4983: BEGIN
4984:

Line 5072: FROM xla_tb_definitions_b

5068: For upgraded report definitions, insert_trial_balance_upg will fail
5069: with ORA-1400 as balance date is null.
5070:
5071: FOR c_def IN (SELECT definition_code
5072: FROM xla_tb_definitions_b
5073: WHERE definition_code = NVL(p_definition_code,definition_code)
5074: AND ledger_id = p_ledger_id
5075: AND owner_code = 'S')
5076: LOOP