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 1314: DELETE FROM xla_tb_def_seg_ranges

1310: ,p_level => C_LEVEL_PROCEDURE
1311: ,p_module =>l_log_module);
1312: END IF;
1313:
1314: DELETE FROM xla_tb_def_seg_ranges
1315: WHERE definition_code = p_definition_code;
1316:
1317: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1318: trace('# of rows deleted = ' || SQL%ROWCOUNT

Line 1336: INSERT INTO xla_tb_def_seg_ranges

1332: END IF;
1333:
1334: IF l_define_by_code = 'FLEXFIELD' THEN
1335:
1336: INSERT INTO xla_tb_def_seg_ranges
1337: (definition_code
1338: ,line_num
1339: ,balance_date
1340: ,owner_code

Line 1537: 'INSERT INTO xla_tb_def_seg_ranges

1533:
1534: END LOOP;
1535:
1536: l_def_by_seg_sql :=
1537: 'INSERT INTO xla_tb_def_seg_ranges
1538: (definition_code
1539: ,line_num '
1540: || l_ins_columns
1541: || ')

Line 1790: DELETE xla_tb_def_seg_ranges

1786:
1787: DELETE xla_tb_work_units
1788: WHERE definition_code = p_definition_code;
1789:
1790: DELETE xla_tb_def_seg_ranges
1791: WHERE definition_code = p_definition_code;
1792:
1793: DELETE xla_tb_logs
1794: WHERE definition_code = p_definition_code;

Line 1885: DELETE xla_tb_def_seg_ranges

1881:
1882: DELETE xla_tb_work_units
1883: WHERE definition_code = p_definition_code;
1884:
1885: DELETE xla_tb_def_seg_ranges
1886: WHERE definition_code = p_definition_code;
1887:
1888: --DELETE xla_tb_processes
1889: --WHERE definition_code = p_definition_code;

Line 3235: ,xla_tb_def_seg_ranges xsr ';

3231: l_seg_clause := get_segment_clause(p_ledger_id => g_ledger_id);
3232:
3233: l_from := ',xla_subledgers xsu
3234: ,xla_tb_defn_je_sources xjs
3235: ,xla_tb_def_seg_ranges xsr ';
3236:
3237: l_where := ' AND xtd.definition_code = :p_definition_code
3238: AND xtd.definition_code = xsr.definition_code
3239: AND xsu.application_id = xah.application_id

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

3502:
3503:
3504: l_ledger_info := get_ledger_info(p_ledger_id => g_ledger_id);
3505: l_seg_clause := get_segment_clause(p_ledger_id => g_ledger_id);
3506: l_from := ',xla_tb_def_seg_ranges xsr ';
3507: l_where := ' AND xtd.definition_code = xsr.definition_code ';
3508:
3509: IF g_group_id IS NOT NULL THEN
3510: l_where := l_where || ' AND xah.group_id = :group_id ';

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

3584: REPLACE(l_sql,'$ic_segment$',l_ic_segment_column);
3585: l_sql :=
3586: REPLACE(l_sql,'$mgt_segment$',l_mgt_segment_column);
3587: l_sql :=
3588: REPLACE(l_sql,'$l_from$',' ,xla_tb_def_seg_ranges xsr ');
3589: l_sql :=
3590: REPLACE(l_sql,'$l_where$',l_where ||l_seg_clause);
3591:
3592: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 5065: | - xla_tb_def_seg_ranges |

5061: | Delete_Non_UI_Rows |
5062: | |
5063: | Deletes rows from the following tables: |
5064: | - xla_tb_logs |
5065: | - xla_tb_def_seg_ranges |
5066: | - xla_tb_user_trans_views |
5067: | - xla_tb_work_units |
5068: | |
5069: | For xla_trial_balances, call drop_partition separately |

Line 5090: DELETE xla_tb_def_seg_ranges

5086:
5087: DELETE xla_tb_logs
5088: WHERE definition_code = p_definition_code;
5089:
5090: DELETE xla_tb_def_seg_ranges
5091: WHERE definition_code = p_definition_code;
5092:
5093: DELETE xla_tb_user_trans_views
5094: WHERE definition_code = p_definition_code;