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_DEF_SEG_RANGES

Line 1359: DELETE FROM xla_tb_def_seg_ranges

1355: ,p_level => C_LEVEL_PROCEDURE
1356: ,p_module =>l_log_module);
1357: END IF;
1358:
1359: DELETE FROM xla_tb_def_seg_ranges
1360: WHERE definition_code = p_definition_code;
1361:
1362: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1363: trace('# of rows deleted = ' || SQL%ROWCOUNT

Line 1381: INSERT INTO xla_tb_def_seg_ranges

1377: END IF;
1378:
1379: IF l_define_by_code = 'FLEXFIELD' THEN
1380:
1381: INSERT INTO xla_tb_def_seg_ranges
1382: (definition_code
1383: ,line_num
1384: ,balance_date
1385: ,owner_code

Line 1586: 'INSERT INTO xla_tb_def_seg_ranges

1582:
1583: END LOOP;
1584:
1585: l_def_by_seg_sql :=
1586: 'INSERT INTO xla_tb_def_seg_ranges
1587: (definition_code
1588: ,line_num '
1589: || l_ins_columns
1590: || ')

Line 1839: DELETE xla_tb_def_seg_ranges

1835:
1836: DELETE xla_tb_work_units
1837: WHERE definition_code = p_definition_code;
1838:
1839: DELETE xla_tb_def_seg_ranges
1840: WHERE definition_code = p_definition_code;
1841:
1842: DELETE xla_tb_logs
1843: WHERE definition_code = p_definition_code;

Line 1934: DELETE xla_tb_def_seg_ranges

1930:
1931: DELETE xla_tb_work_units
1932: WHERE definition_code = p_definition_code;
1933:
1934: DELETE xla_tb_def_seg_ranges
1935: WHERE definition_code = p_definition_code;
1936:
1937: --DELETE xla_tb_processes
1938: --WHERE definition_code = p_definition_code;

Line 3318: ,xla_tb_def_seg_ranges xsr ';

3314: l_seg_clause := get_segment_clause(p_ledger_id => g_ledger_id);
3315:
3316: l_from := ',xla_subledgers xsu
3317: ,xla_tb_defn_je_sources xjs
3318: ,xla_tb_def_seg_ranges xsr ';
3319:
3320: l_where := ' AND xtd.definition_code = :p_definition_code
3321: AND xtd.definition_code = xsr.definition_code
3322: AND xsu.application_id = xah.application_id

Line 3659: l_from := ',xla_tb_def_seg_ranges xsr ';

3655:
3656:
3657: l_ledger_info := get_ledger_info(p_ledger_id => g_ledger_id);
3658: l_seg_clause := get_segment_clause(p_ledger_id => g_ledger_id);
3659: l_from := ',xla_tb_def_seg_ranges xsr ';
3660: l_where := ' AND xtd.definition_code = xsr.definition_code ';
3661:
3662: IF g_group_id IS NOT NULL THEN
3663: l_where := l_where || ' AND xah.group_id = :group_id ';

Line 3741: REPLACE(l_sql,'$l_from$',' ,xla_tb_def_seg_ranges xsr ');

3737: REPLACE(l_sql,'$ic_segment$',l_ic_segment_column);
3738: l_sql :=
3739: REPLACE(l_sql,'$mgt_segment$',l_mgt_segment_column);
3740: l_sql :=
3741: REPLACE(l_sql,'$l_from$',' ,xla_tb_def_seg_ranges xsr ');
3742: l_sql :=
3743: REPLACE(l_sql,'$l_where$',l_where ||l_seg_clause);
3744:
3745: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 5221: | - xla_tb_def_seg_ranges |

5217: | Delete_Non_UI_Rows |
5218: | |
5219: | Deletes rows from the following tables: |
5220: | - xla_tb_logs |
5221: | - xla_tb_def_seg_ranges |
5222: | - xla_tb_user_trans_views |
5223: | - xla_tb_work_units |
5224: | |
5225: | For xla_trial_balances, call drop_partition separately |

Line 5246: DELETE xla_tb_def_seg_ranges

5242:
5243: DELETE xla_tb_logs
5244: WHERE definition_code = p_definition_code;
5245:
5246: DELETE xla_tb_def_seg_ranges
5247: WHERE definition_code = p_definition_code;
5248:
5249: DELETE xla_tb_user_trans_views
5250: WHERE definition_code = p_definition_code;