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.GCS_WEBADI_PKG dependencies on GCS_HISTORICAL_RATES

Line 222: 'DELETE FROM gcs_historical_rates ' || g_nl ||

218: /***
219: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement THEN
220: fnd_log.STRING(fnd_log.level_statement,
221: g_pkg_name || '.' || l_api_name,
222: 'DELETE FROM gcs_historical_rates ' || g_nl ||
223: ' WHERE hierarchy_id = ' || p_hierarchy_id || g_nl ||
224: ' AND entity_id = ' || p_entity_id || g_nl ||
225: ' AND cal_period_id = ' || p_cal_period_id || g_nl ||
226: ' AND update_flag = ''N''');

Line 229: DELETE FROM gcs_historical_rates

225: ' AND cal_period_id = ' || p_cal_period_id || g_nl ||
226: ' AND update_flag = ''N''');
227: END IF;
228:
229: DELETE FROM gcs_historical_rates
230: WHERE hierarchy_id = p_hierarchy_id
231: AND entity_id = p_entity_id
232: AND cal_period_id = p_cal_period_id
233: AND update_flag = 'N';

Line 240: ' UPDATE gcs_historical_rates ghr set update_flag = ''N'', account_type_code = ' || g_nl ||

236:
237: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement THEN
238: fnd_log.STRING(fnd_log.level_statement,
239: g_pkg_name || '.' || l_api_name,
240: ' UPDATE gcs_historical_rates ghr set update_flag = ''N'', account_type_code = ' || g_nl ||
241: '( select dim_attribute_varchar_member from fem_ln_items_attr ' || g_nl ||
242: ' where attribute_id = ' ||
243: gcs_utility_pkg.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE')
244: .attribute_id || g_nl || ' AND version_id = ' ||

Line 253: UPDATE gcs_historical_rates ghr

249: ' AND entity_id = ' || p_entity_id || g_nl ||
250: ' AND cal_period_id = ' || p_cal_period_id);
251: END IF;
252:
253: UPDATE gcs_historical_rates ghr
254: SET update_flag = 'N',
255: account_type_code = (select dim_attribute_varchar_member
256: from fem_ln_items_attr
257: where attribute_id =

Line 950: ' gcs_historical_rates tb, fnd_currencies_tl fct_from, fnd_currencies_tl fct_to, ' ||

946: ' translated_amount amount, flv.meaning AS rate_type, period.cal_period_name period, ' ||
947: ' tb.hierarchy_id, tb.entity_id, tb.cal_period_id ' ||
948: l_select_cols ||
949: ' FROM gcs_dimension_templates gdt,gcs_hierarchies_tl ght, fnd_lookup_values flv, fem_entities_tl entity, ' ||
950: ' gcs_historical_rates tb, fnd_currencies_tl fct_from, fnd_currencies_tl fct_to, ' ||
951: ' fem_cal_periods_tl period ' || l_from_clause ||
952: ' WHERE gdt.hierarchy_id = tb.hierarchy_id AND gdt.template_code = ''RE''' ||
953: ' AND tb.hierarchy_id = ght.hierarchy_id AND tb.entity_id = entity.entity_id ' ||
954: ' AND tb.rate_type_code = flv.lookup_code AND flv.lookup_type = ''HISTORICAL_RATE_TYPE'' ' ||

Line 1007: ' gcs_historical_rates tb, fnd_currencies_tl fct_from, fnd_currencies_tl fct_to, ' ||

1003: ' translated_amount amount, flv.meaning AS rate_type, period.cal_period_name period, ' ||
1004: ' tb.hierarchy_id, tb.entity_id, tb.cal_period_id ' ||
1005: l_hrate_select_cols ||
1006: ' FROM gcs_dimension_templates gdt, gcs_hierarchies_tl ght, fnd_lookup_values flv, fem_entities_tl entity, ' ||
1007: ' gcs_historical_rates tb, fnd_currencies_tl fct_from, fnd_currencies_tl fct_to, ' ||
1008: ' fem_cal_periods_tl period ' || l_hrate_from_clause ||
1009: ' WHERE gdt.hierarchy_id = tb.hierarchy_id AND gdt.template_code = ''RE''' ||
1010: ' AND tb.hierarchy_id = ght.hierarchy_id AND tb.entity_id = entity.entity_id ' ||
1011: ' AND tb.rate_type_code = flv.lookup_code AND flv.lookup_type = ''HISTORICAL_RATE_TYPE'' ' ||