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

Line 249: --Bugfix 6111815: Added Standard RE Rate Flag

245: module VARCHAR2(50) := ''ROLL_FORWARD_HISTORICAL_RATES'';
246: BEGIN
247: write_to_log(module, FND_LOG.LEVEL_PROCEDURE,g_module_enter);
248:
249: --Bugfix 6111815: Added Standard RE Rate Flag
250: write_to_log(module, FND_LOG.LEVEL_STATEMENT,
251: ''UPDATE gcs_historical_rates ghr'' || g_nl ||
252: ''SET (translated_rate, translated_amount, rate_type_code, '' ||
253: ''last_update_date, last_updated_by, last_update_login) ='' || g_nl ||

Line 263: '' AND ghr1.standard_re_rate_flag IS NULL '' || g_nl ||';

259: '' AND ghr1.hierarchy_id = ghr.hierarchy_id'' || g_nl ||
260: '' AND ghr1.from_currency = ghr.from_currency'' || g_nl ||
261: '' AND ghr1.to_currency = ghr.to_currency'' || g_nl ||
262: '' AND ghr1.line_item_id = ghr.line_item_id'' || g_nl ||
263: '' AND ghr1.standard_re_rate_flag IS NULL '' || g_nl ||';
264:
265: curr_pos := 1;
266: body_len := LENGTH(body_block);
267: WHILE curr_pos <= body_len LOOP

Line 276: --Bugfix 6111815: Adeded Standard RE Rate Flag

272: END LOOP;
273:
274: line_num := GCS_TRANS_DYN_BUILD_PKG.build_join_list(''' AND ghr1.', ' = ghr.', ''' || g_nl ||', line_num, 'H');
275:
276: --Bugfix 6111815: Adeded Standard RE Rate Flag
277: body_block :=
278: ''' AND ghr1.cal_period_id = '' || p_prev_period_id || '')'' || g_nl ||
279: ''WHERE ghr.rowid IN ( '' || g_nl ||
280: '' SELECT ghr3.rowid'' || g_nl ||

Line 295: '' AND ghr3.standard_re_rate_flag IS NULL'' || g_nl ||';

291: '' AND ghr3.hierarchy_id = ghr2.hierarchy_id'' || g_nl ||
292: '' AND ghr2.cal_period_id = '' || p_prev_period_id || g_nl ||
293: '' AND ghr3.cal_period_id = '' || p_cal_period_id || g_nl ||
294: '' AND ghr3.line_item_id = ghr2.line_item_id'' || g_nl ||
295: '' AND ghr3.standard_re_rate_flag IS NULL'' || g_nl ||';
296:
297: curr_pos := 1;
298: body_len := LENGTH(body_block);
299: WHILE curr_pos <= body_len LOOP

Line 325: -- Bugfix 6111815: Added Standard RE Rate Flag

321: -- 2. A historical rate exists in the previous period and the rate type
322: -- is Prior or Historical.
323: -- 3. The historical rates of current and previous periods are different.
324: -- 4. The historical rate is not marked with stop rolling forward.
325: -- Bugfix 6111815: Added Standard RE Rate Flag
326: UPDATE gcs_historical_rates ghr
327: SET (translated_rate, translated_amount, rate_type_code,
328: last_update_date, last_updated_by, last_update_login) =
329: (SELECT ghr1.translated_rate, ghr1.translated_amount, ''P'', sysdate,

Line 337: AND ghr1.standard_re_rate_flag IS NULL';

333: AND ghr1.hierarchy_id = ghr.hierarchy_id
334: AND ghr1.from_currency = ghr.from_currency
335: AND ghr1.to_currency = ghr.to_currency
336: AND ghr1.line_item_id = ghr.line_item_id
337: AND ghr1.standard_re_rate_flag IS NULL';
338:
339: curr_pos := 1;
340: body_len := LENGTH(body_block);
341: WHILE curr_pos <= body_len LOOP

Line 350: --Bugfix 6111815: Added Standard RE Rate Flag

346: END LOOP;
347:
348: line_num := GCS_TRANS_DYN_BUILD_PKG.build_join_list(' AND ghr1.', ' = ghr.', '', line_num, 'H');
349:
350: --Bugfix 6111815: Added Standard RE Rate Flag
351: body_block :=
352: ' AND ghr1.cal_period_id = p_prev_period_id)
353: WHERE ghr.rowid IN (
354: SELECT ghr3.rowid

Line 369: AND ghr3.standard_re_rate_flag IS NULL';

365: AND ghr3.hierarchy_id = ghr2.hierarchy_id
366: AND ghr2.cal_period_id = p_prev_period_id
367: AND ghr3.cal_period_id = p_cal_period_id
368: AND ghr3.line_item_id = ghr2.line_item_id
369: AND ghr3.standard_re_rate_flag IS NULL';
370:
371: curr_pos := 1;
372: body_len := LENGTH(body_block);
373: WHILE curr_pos <= body_len LOOP

Line 392: --Bugfix 6111815: Added Standard RE Rate Flag

388: OR
389: nvl(to_char(ghr2.translated_amount), ''X'') <>
390: nvl(to_char(ghr3.translated_amount), ''X'')));
391:
392: --Bugfix 6111815: Added Standard RE Rate Flag
393: write_to_log(module, FND_LOG.LEVEL_STATEMENT,
394: ''DELETE FROM gcs_historical_rates ghr'' || g_nl ||
395: ''WHERE (rowid, ''''E'''') IN ('' || g_nl ||
396: '' SELECT ghr3.rowid, nvl(ghr2.rate_type_code, ''''E'''')'' || g_nl ||

Line 413: '' AND ghr3.standard_re_rate_flag IS NULL '' || g_nl ||';

409: '' AND ghr2.from_currency (+)= '''''' || p_from_ccy || '''''''' || g_nl ||
410: '' AND ghr2.to_currency (+)= '''''' || p_to_ccy || '''''''' || g_nl ||
411: '' AND ghr2.stop_rollforward_flag (+)= ''''N'''''' || g_nl ||
412: '' AND ghr2.line_item_id (+)= ghr3.line_item_id'' || g_nl ||
413: '' AND ghr3.standard_re_rate_flag IS NULL '' || g_nl ||';
414:
415: curr_pos := 1;
416: body_len := LENGTH(body_block);
417: WHILE curr_pos <= body_len LOOP

Line 434: -- Bugfix 6111815: Added Standard RE Rate Flag

430: -- 1. A historical rate exists in the current period and the rate
431: -- type is Prior.
432: -- 2. There is no historical rate in the previous period or a historical
433: -- rate exists in the previous period with the rate type Period.
434: -- Bugfix 6111815: Added Standard RE Rate Flag
435: DELETE FROM gcs_historical_rates ghr
436: WHERE (rowid, ''E'') IN (
437: SELECT ghr3.rowid, nvl(ghr2.rate_type_code, ''E'')
438: FROM GCS_HISTORICAL_RATES ghr3,

Line 454: AND ghr3.standard_re_rate_flag IS NULL';

450: AND ghr2.from_currency (+)= p_from_ccy
451: AND ghr2.to_currency (+)= p_to_ccy
452: AND ghr2.stop_rollforward_flag (+)= ''N''
453: AND ghr2.line_item_id (+)= ghr3.line_item_id
454: AND ghr3.standard_re_rate_flag IS NULL';
455:
456: curr_pos := 1;
457: body_len := LENGTH(body_block);
458: WHILE curr_pos <= body_len LOOP

Line 470: --Bugfix 6111815: Added Standard RE Rate Flag

466:
467: body_block :=
468: ' );
469:
470: --Bugfix 6111815: Added Standard RE Rate Flag
471: write_to_log(module, FND_LOG.LEVEL_STATEMENT,
472: ''INSERT /*+ parallel (gcs_historical_rates) */ INTO gcs_historical_rates(entity_id, hierarchy_id, '' ||
473: ''cal_period_id, from_currency, to_currency, line_item_id, '' ||
474: ''company_cost_center_org_id, intercompany_id, financial_elem_id, '' ||

Line 510: ''AND ghr.standard_re_rate_flag IS NULL '' || g_nl ||

506: ''AND ghr.rate_type_code in (''''H'''', ''''P'''', ''''C'''')'' || g_nl ||
507: ''AND ghr.cal_period_id = '' || p_prev_period_id || g_nl ||
508: ''AND ghr.account_type_code IN (''''ASSET'''',''''LIABILITY'''',decode('''''' || p_eq_xlate_mode || '''''', ''''YTD'''', ''''EQUITY'''', NULL))'' || g_nl ||
509: ''AND ghr.stop_rollforward_flag = ''''N'''''' || g_nl ||
510: ''AND ghr.standard_re_rate_flag IS NULL '' || g_nl ||
511: '' AND NOT EXISTS ('' || g_nl ||
512: '' SELECT 1 FROM gcs_historical_rates ghr1'' || g_nl ||
513: '' WHERE ghr1.entity_id = p_entity_id'' || g_nl ||
514: '' AND ghr1.hierarchy_id = p_hierarchy_id'' || g_nl ||

Line 564: --Bugfix 6111815: Added Standard RE Rate Flag

560: END LOOP;
561:
562: line_num := GCS_TRANS_DYN_BUILD_PKG.build_comma_list(' ghr.', '', ' NULL,', line_num, 'H');
563:
564: --Bugfix 6111815: Added Standard RE Rate Flag
565: body_block :=
566: ' ghr.translated_rate, ghr.translated_amount, ''P'', ''N'',
567: ghr.account_type_code, ''N'', sysdate, gcs_translation_pkg.g_fnd_user_id,
568: gcs_translation_pkg.g_fnd_login_id, sysdate,

Line 579: AND ghr.standard_re_rate_flag IS NULL

575: AND ghr.rate_type_code in (''H'', ''P'', ''C'')
576: AND ghr.cal_period_id = p_prev_period_id
577: AND ghr.account_type_code IN (''ASSET'',''LIABILITY'',decode(p_eq_xlate_mode, ''YTD'', ''EQUITY'', NULL))
578: AND ghr.stop_rollforward_flag = ''N''
579: AND ghr.standard_re_rate_flag IS NULL
580: AND NOT EXISTS (
581: SELECT 1 FROM gcs_historical_rates ghr1
582: WHERE ghr1.entity_id = p_entity_id
583: AND ghr1.hierarchy_id = p_hierarchy_id

Line 936: WHERE ghr_retained.standard_re_rate_flag = ''Y''

932: body_block :=
933: '
934: AND NOT EXISTS (SELECT ''X''
935: FROM gcs_historical_rates ghr_retained
936: WHERE ghr_retained.standard_re_rate_flag = ''Y''
937: AND ghr_retained.hierarchy_id = p_hierarchy_id
938: AND ghr_retained.entity_id = p_entity_id
939: AND ghr_retained.cal_period_id = p_cal_period_id
940: AND ghr_retained.line_item_id = fb.line_item_id';

Line 1209: WHERE ghr_retained.standard_re_rate_flag = ''Y''

1205: body_block :=
1206: '
1207: AND NOT EXISTS (SELECT ''X''
1208: FROM gcs_historical_rates ghr_retained
1209: WHERE ghr_retained.standard_re_rate_flag = ''Y''
1210: AND ghr_retained.hierarchy_id = p_hierarchy_id
1211: AND ghr_retained.entity_id = p_entity_id
1212: AND ghr_retained.cal_period_id = p_cal_period_id
1213: AND ghr_retained.line_item_id = fb.line_item_id';

Line 1643: WHERE ghr_retained.standard_re_rate_flag = ''Y''

1639: body_block :=
1640: '
1641: AND NOT EXISTS (SELECT ''X''
1642: FROM gcs_historical_rates ghr_retained
1643: WHERE ghr_retained.standard_re_rate_flag = ''Y''
1644: AND ghr_retained.hierarchy_id = p_hierarchy_id
1645: AND ghr_retained.entity_id = p_entity_id
1646: AND ghr_retained.cal_period_id = p_cal_period_id
1647: AND ghr_retained.line_item_id = fb.line_item_id';

Line 1972: WHERE ghr_retained.standard_re_rate_flag = ''Y''

1968: body_block :=
1969: '
1970: AND NOT EXISTS (SELECT ''X''
1971: FROM gcs_historical_rates ghr_retained
1972: WHERE ghr_retained.standard_re_rate_flag = ''Y''
1973: AND ghr_retained.hierarchy_id = p_hierarchy_id
1974: AND ghr_retained.entity_id = p_entity_id
1975: AND ghr_retained.cal_period_id = p_cal_period_id
1976: AND ghr_retained.line_item_id = fb.line_item_id';