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_TRANS_RE_DYNAMIC_PKG dependencies on STANDARD

Line 114: --Bugfix 6111815: Only Roll Forward Rates Where Standard RE Rate Flag is Y

110: module VARCHAR2(50) := 'ROLL_FORWARD_RETAINED_EARNINGS';
111: BEGIN
112: write_to_log(module, FND_LOG.LEVEL_PROCEDURE,g_module_enter);
113:
114: --Bugfix 6111815: Only Roll Forward Rates Where Standard RE Rate Flag is Y
115: write_to_log(module, FND_LOG.LEVEL_STATEMENT,
116: 'UPDATE gcs_historical_rates ghr' || g_nl ||
117: 'SET (translated_rate, translated_amount, rate_type_code, ' ||
118: 'last_update_date, last_updated_by, last_update_login) =' || g_nl ||

Line 128: ' AND ghr1.standard_re_rate_flag = ''Y'' ' || g_nl ||

124: ' AND ghr1.hierarchy_id = ghr.hierarchy_id' || g_nl ||
125: ' AND ghr1.from_currency = ghr.from_currency' || g_nl ||
126: ' AND ghr1.to_currency = ghr.to_currency' || g_nl ||
127: ' AND ghr1.line_item_id = ghr.line_item_id' || g_nl ||
128: ' AND ghr1.standard_re_rate_flag = ''Y'' ' || g_nl ||
129: ' AND ghr1.line_item_id = p_hier_li_id ' || g_nl ||' AND ghr1.cal_period_id = ' || p_prev_period_id || ')' || g_nl ||
130: 'WHERE ghr.rowid IN ( ' || g_nl ||
131: ' SELECT ghr3.rowid' || g_nl ||
132: ' FROM GCS_HISTORICAL_RATES ghr2, ' || g_nl ||

Line 146: ' AND ghr3.standard_re_rate_flag = ''Y'' ' || g_nl ||

142: ' AND ghr3.hierarchy_id = ghr2.hierarchy_id' || g_nl ||
143: ' AND ghr2.cal_period_id = ' || p_prev_period_id || g_nl ||
144: ' AND ghr3.cal_period_id = ' || p_cal_period_id || g_nl ||
145: ' AND ghr3.line_item_id = ghr2.line_item_id' || g_nl ||
146: ' AND ghr3.standard_re_rate_flag = ''Y'' ' || g_nl ||
147: ' AND ghr3.line_item_id = p_hier_li_id' || g_nl ||' AND ghr3.from_currency = ghr2.from_currency' || g_nl ||
148: ' AND ghr3.to_currency = ghr2.to_currency ' || g_nl ||
149: ' AND ghr3.rate_type_code IN (''P'', ''E'')' || g_nl ||
150: ' AND (nvl(to_char(ghr2.translated_rate), ''X'') <>' || g_nl ||

Line 163: --Bugfix 6111815: Only Roll Forward Rates Where Standard RE Rate Flag is Y

159: -- 2. A historical rate exists in the previous period and the rate type
160: -- is Prior or Historical.
161: -- 3. The historical rates of current and previous periods are different.
162: -- 4. The historical rate is not marked with stop rolling forward.
163: --Bugfix 6111815: Only Roll Forward Rates Where Standard RE Rate Flag is Y
164: UPDATE gcs_historical_rates ghr
165: SET (translated_rate, translated_amount, rate_type_code,
166: last_update_date, last_updated_by, last_update_login) =
167: (SELECT ghr1.translated_rate, ghr1.translated_amount, 'P', sysdate,

Line 175: AND ghr1.standard_re_rate_flag = 'Y'

171: AND ghr1.hierarchy_id = ghr.hierarchy_id
172: AND ghr1.from_currency = ghr.from_currency
173: AND ghr1.to_currency = ghr.to_currency
174: AND ghr1.line_item_id = ghr.line_item_id
175: AND ghr1.standard_re_rate_flag = 'Y'
176: AND ghr1.line_item_id = p_hier_li_id AND ghr1.cal_period_id = p_prev_period_id)
177: WHERE ghr.rowid IN (
178: SELECT ghr3.rowid
179: FROM GCS_HISTORICAL_RATES ghr2,

Line 193: ANd ghr3.standard_re_rate_flag = 'Y'

189: AND ghr3.hierarchy_id = ghr2.hierarchy_id
190: AND ghr2.cal_period_id = p_prev_period_id
191: AND ghr3.cal_period_id = p_cal_period_id
192: AND ghr3.line_item_id = ghr2.line_item_id
193: ANd ghr3.standard_re_rate_flag = 'Y'
194: AND ghr3.line_item_id = p_hier_li_id AND ghr3.from_currency = ghr2.from_currency
195: AND ghr3.to_currency = ghr2.to_currency
196: AND ghr3.rate_type_code IN ('P', 'E')
197: AND (nvl(to_char(ghr2.translated_rate), 'X') <>

Line 203: --Bugfix 6111815: Only Roll Forward Rates Where Standard RE Rate Flag is Y

199: OR
200: nvl(to_char(ghr2.translated_amount), 'X') <>
201: nvl(to_char(ghr3.translated_amount), 'X')));
202:
203: --Bugfix 6111815: Only Roll Forward Rates Where Standard RE Rate Flag is Y
204: write_to_log(module, FND_LOG.LEVEL_STATEMENT,
205: 'DELETE FROM gcs_historical_rates ghr' || g_nl ||
206: 'WHERE (rowid, ''E'') IN (' || g_nl ||
207: ' SELECT ghr3.rowid, nvl(ghr2.rate_type_code, ''E'')' || g_nl ||

Line 224: ' AND ghr3.standard_re_rate_flag = ''Y'' ' || g_nl ||

220: ' AND ghr2.from_currency (+)= ''' || p_from_ccy || '''' || g_nl ||
221: ' AND ghr2.to_currency (+)= ''' || p_to_ccy || '''' || g_nl ||
222: ' AND ghr2.stop_rollforward_flag (+)= ''N''' || g_nl ||
223: ' AND ghr2.line_item_id (+)= ghr3.line_item_id' || g_nl ||
224: ' AND ghr3.standard_re_rate_flag = ''Y'' ' || g_nl ||
225: ' AND ghr3.line_item_id = p_hier_li_id ' || g_nl ||' )');
226:
227: -- Next, delete historical rates for balance sheet accounts if:
228: -- 1. A historical rate exists in the current period and the rate

Line 232: --Bugfix 6111815: Only Roll Forward Rates Where Standard RE Rate Flag is Y

228: -- 1. A historical rate exists in the current period and the rate
229: -- type is Prior.
230: -- 2. There is no historical rate in the previous period or a historical
231: -- rate exists in the previous period with the rate type Period.
232: --Bugfix 6111815: Only Roll Forward Rates Where Standard RE Rate Flag is Y
233: DELETE FROM gcs_historical_rates ghr
234: WHERE (rowid, 'E') IN (
235: SELECT ghr3.rowid, nvl(ghr2.rate_type_code, 'E')
236: FROM GCS_HISTORICAL_RATES ghr3,

Line 252: AND ghr3.standard_re_rate_flag = 'Y'

248: AND ghr2.from_currency (+)= p_from_ccy
249: AND ghr2.to_currency (+)= p_to_ccy
250: AND ghr2.stop_rollforward_flag (+)= 'N'
251: AND ghr2.line_item_id (+)= ghr3.line_item_id
252: AND ghr3.standard_re_rate_flag = 'Y'
253: AND ghr3.line_item_id = p_hier_li_id );
254:
255: write_to_log(module, FND_LOG.LEVEL_STATEMENT,
256: 'INSERT /*+ parallel (gcs_historical_rates) */ INTO gcs_historical_rates(standard_re_rate_flag, entity_id, hierarchy_id, ' ||

Line 256: 'INSERT /+ parallel (gcs_historical_rates) / INTO gcs_historical_rates(standard_re_rate_flag, entity_id, hierarchy_id, ' ||

252: AND ghr3.standard_re_rate_flag = 'Y'
253: AND ghr3.line_item_id = p_hier_li_id );
254:
255: write_to_log(module, FND_LOG.LEVEL_STATEMENT,
256: 'INSERT /*+ parallel (gcs_historical_rates) */ INTO gcs_historical_rates(standard_re_rate_flag, entity_id, hierarchy_id, ' ||
257: 'cal_period_id, from_currency, to_currency, line_item_id, ' ||
258: 'company_cost_center_org_id, intercompany_id, financial_elem_id, ' ||
259: 'product_id, natural_account_id, channel_id, project_id, customer_id, task_id, ' ||
260: 'user_dim1_id, user_dim2_id, user_dim3_id, user_dim4_id, user_dim5_id, ' ||

Line 281: 'AND ghr.standard_re_rate_flag = ''Y'' ' || g_nl ||

277: 'AND ghr.cal_period_id = ' || p_prev_period_id || g_nl ||
278: 'AND ghr.account_type_code IN (''ASSET'',''LIABILITY'',decode(''' || p_eq_xlate_mode || ''', ''YTD'', ''EQUITY'', NULL))' || g_nl ||
279: 'AND ghr.stop_rollforward_flag = ''N''' || g_nl ||
280: 'AND ghr.line_item_id = ' || p_hier_li_id || g_nl ||
281: 'AND ghr.standard_re_rate_flag = ''Y'' ' || g_nl ||
282: ' AND NOT EXISTS (' || g_nl ||
283: ' SELECT 1 FROM gcs_historical_rates ghr1' || g_nl ||
284: ' WHERE ghr1.entity_id = p_entity_id' || g_nl ||
285: ' AND ghr1.hierarchy_id = p_hierarchy_id' || g_nl ||

Line 295: -- Bugfix 6111815: Adeded Standard RE Rate Flag as part of insert

291: -- Next, insert historical rates for balance sheet accounts if:
292: -- 1. No historical rate exists for the current period.
293: -- 2. A historical rate is defined for the previous period with Prior or
294: -- Historical rate type and the stop roll forward flag is not checked.
295: -- Bugfix 6111815: Adeded Standard RE Rate Flag as part of insert
296: INSERT /*+ parallel (gcs_historical_rates) */ INTO gcs_historical_rates(
297: standard_re_rate_flag, entity_id, hierarchy_id, cal_period_id, from_currency,
298: to_currency, line_item_id, company_cost_center_org_id, intercompany_id,
299: financial_elem_id, product_id, natural_account_id,

Line 297: standard_re_rate_flag, entity_id, hierarchy_id, cal_period_id, from_currency,

293: -- 2. A historical rate is defined for the previous period with Prior or
294: -- Historical rate type and the stop roll forward flag is not checked.
295: -- Bugfix 6111815: Adeded Standard RE Rate Flag as part of insert
296: INSERT /*+ parallel (gcs_historical_rates) */ INTO gcs_historical_rates(
297: standard_re_rate_flag, entity_id, hierarchy_id, cal_period_id, from_currency,
298: to_currency, line_item_id, company_cost_center_org_id, intercompany_id,
299: financial_elem_id, product_id, natural_account_id,
300: channel_id, project_id, customer_id, task_id, user_dim1_id, user_dim2_id,
301: user_dim3_id, user_dim4_id, user_dim5_id, user_dim6_id, user_dim7_id,

Line 323: AND ghr.standard_re_rate_flag = 'Y'

319: AND ghr.cal_period_id = p_prev_period_id
320: AND ghr.account_type_code IN ('ASSET','LIABILITY',decode(p_eq_xlate_mode, 'YTD', 'EQUITY', NULL))
321: AND ghr.stop_rollforward_flag = 'N'
322: AND ghr.line_item_id = p_hier_li_id
323: AND ghr.standard_re_rate_flag = 'Y'
324: AND NOT EXISTS (
325: SELECT 1 FROM gcs_historical_rates ghr1
326: WHERE ghr1.entity_id = p_entity_id
327: AND ghr1.hierarchy_id = p_hierarchy_id

Line 467: 'AND ghr.standard_re_rate_flag = ''Y'' ' || g_nl ||

463: 'AND ghr.to_currency = ''' || p_to_ccy || '''' || g_nl ||
464: 'AND ghr.cal_period_id = ' || p_cal_period_id || g_nl ||
465: 'AND ghr.line_item_id = fb.line_item_id' || g_nl ||
466: 'AND ghr.update_flag = ''N'' ' || g_nl ||
467: 'AND ghr.standard_re_rate_flag = ''Y'' ' || g_nl ||
468: 'AND fb.line_item_id = p_hier_li_id ' || g_nl ||'');
469:
470: INSERT /*+ parallel (GCS_TRANSLATION_GT) */ INTO GCS_TRANSLATION_GT(
471: translate_rule_code, account_type_code, line_item_id,

Line 553: AND ghr.standard_re_rate_flag = 'Y' ;

549: AND ghr.cal_period_id = p_cal_period_id
550: AND ghr.line_item_id = fb.line_item_id
551: AND ghr.update_flag = 'N'
552: AND fb.line_item_id = p_hier_li_id
553: AND ghr.standard_re_rate_flag = 'Y' ;
554:
555: ELSE
556: write_to_log(module, FND_LOG.LEVEL_STATEMENT,
557: 'INSERT /*+ parallel (GCS_TRANSLATION_GT) */ INTO GCS_TRANSLATION_GT(translate_rule_code, account_type_code, ' ||

Line 637: 'AND ghr.standard_re_rate_flag = ''Y'' ' || g_nl ||

633: 'AND ghr.to_currency = ''' || p_to_ccy || '''' || g_nl ||
634: 'AND ghr.cal_period_id = ' || p_cal_period_id || g_nl ||
635: 'AND ghr.line_item_id = fb.line_item_id' || g_nl ||
636: 'AND ghr.update_flag = ''N'' ' || g_nl ||
637: 'AND ghr.standard_re_rate_flag = ''Y'' ' || g_nl ||
638: 'AND fb.line_item_id = p_hier_li_id ' || g_nl ||'');
639:
640: INSERT /*+ parallel (GCS_TRANSLATION_GT) */ INTO GCS_TRANSLATION_GT(
641: translate_rule_code, account_type_code, line_item_id,

Line 721: AND ghr.standard_re_rate_flag = 'Y'

717: AND ghr.to_currency = p_to_ccy
718: AND ghr.cal_period_id = p_cal_period_id
719: AND ghr.line_item_id = fb.line_item_id
720: AND ghr.update_flag = 'N'
721: AND ghr.standard_re_rate_flag = 'Y'
722: AND fb.line_item_id = p_hier_li_id ;
723: END IF;
724:
725: --Bugfix 6111815: Do not check if any data was translated

Line 898: 'AND ghr.standard_re_rate_flag = ''Y'' ' || g_nl ||

894: 'AND ghr.from_currency = ''' || p_from_ccy || '''' || g_nl ||
895: 'AND ghr.to_currency = ''' || p_to_ccy || '''' || g_nl ||
896: 'AND ghr.cal_period_id = ' || p_cal_period_id || g_nl ||
897: 'AND ghr.line_item_id = fb.line_item_id' || g_nl ||
898: 'AND ghr.standard_re_rate_flag = ''Y'' ' || g_nl ||
899: 'AND ghr.update_flag = ''N''' || g_nl ||'');
900:
901: INSERT /*+ parallel (GCS_TRANSLATION_GT) */ INTO GCS_TRANSLATION_GT(
902: translate_rule_code, account_type_code, line_item_id,

Line 996: AND ghr.standard_re_rate_flag = 'Y'

992: AND ghr.from_currency = p_from_ccy
993: AND ghr.to_currency = p_to_ccy
994: AND ghr.cal_period_id = p_cal_period_id
995: AND ghr.line_item_id = fb.line_item_id
996: AND ghr.standard_re_rate_flag = 'Y'
997: AND ghr.update_flag = 'N' ;
998:
999: ELSE
1000: write_to_log(module, FND_LOG.LEVEL_STATEMENT,

Line 1096: 'AND ghr.standard_re_rate_flag = ''Y'' ' || g_nl ||

1092: 'AND ghr.from_currency = ''' || p_from_ccy || '''' || g_nl ||
1093: 'AND ghr.to_currency = ''' || p_to_ccy || '''' || g_nl ||
1094: 'AND ghr.cal_period_id = ' || p_cal_period_id || g_nl ||
1095: 'AND ghr.line_item_id = fb.line_item_id' || g_nl ||
1096: 'AND ghr.standard_re_rate_flag = ''Y'' ' || g_nl ||
1097: 'AND ghr.update_flag = ''N''' || g_nl ||'');
1098:
1099: INSERT /*+ parallel (GCS_TRANSLATION_GT) */ INTO GCS_TRANSLATION_GT(
1100: translate_rule_code, account_type_code, line_item_id,

Line 1193: AND ghr.standard_re_rate_flag = 'Y'

1189: AND ghr.from_currency = p_from_ccy
1190: AND ghr.to_currency = p_to_ccy
1191: AND ghr.cal_period_id = p_cal_period_id
1192: AND ghr.line_item_id = fb.line_item_id
1193: AND ghr.standard_re_rate_flag = 'Y'
1194: AND ghr.update_flag = 'N' ;
1195:
1196: END IF;
1197: