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

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

241: module VARCHAR2(50) := ''ROLL_FORWARD_RETAINED_EARNINGS'';
242: BEGIN
243: write_to_log(module, FND_LOG.LEVEL_PROCEDURE,g_module_enter);
244:
245: --Bugfix 6111815: Only Roll Forward Rates Where Standard RE Rate Flag is Y
246: write_to_log(module, FND_LOG.LEVEL_STATEMENT,
247: ''UPDATE gcs_historical_rates ghr'' || g_nl ||
248: ''SET (translated_rate, translated_amount, rate_type_code, '' ||
249: ''last_update_date, last_updated_by, last_update_login) ='' || g_nl ||

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

255: '' AND ghr1.hierarchy_id = ghr.hierarchy_id'' || g_nl ||
256: '' AND ghr1.from_currency = ghr.from_currency'' || g_nl ||
257: '' AND ghr1.to_currency = ghr.to_currency'' || g_nl ||
258: '' AND ghr1.line_item_id = ghr.line_item_id'' || g_nl ||
259: '' AND ghr1.standard_re_rate_flag = ''''Y'''' '' || g_nl ||
260: '' AND ghr1.line_item_id = p_hier_li_id '' || g_nl ||';
261:
262: curr_pos := 1;
263: body_len := LENGTH(body_block);

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

269: END LOOP;
270:
271: line_num := GCS_TRANS_DYN_BUILD_PKG.build_join_list(''' AND ghr1.', ' = ghr.', ''' || g_nl ||', line_num, 'F');
272:
273: --Bugfix 6111815: Only Roll Forward Rates Where Standard RE Rate Flag is Y
274: body_block :=
275: ''' AND ghr1.cal_period_id = '' || p_prev_period_id || '')'' || g_nl ||
276: ''WHERE ghr.rowid IN ( '' || g_nl ||
277: '' SELECT ghr3.rowid'' || g_nl ||

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

288: '' AND ghr3.hierarchy_id = ghr2.hierarchy_id'' || g_nl ||
289: '' AND ghr2.cal_period_id = '' || p_prev_period_id || g_nl ||
290: '' AND ghr3.cal_period_id = '' || p_cal_period_id || g_nl ||
291: '' AND ghr3.line_item_id = ghr2.line_item_id'' || g_nl ||
292: '' AND ghr3.standard_re_rate_flag = ''''Y'''' '' || g_nl ||
293: '' AND ghr3.line_item_id = p_hier_li_id'' || g_nl ||';
294:
295: curr_pos := 1;
296: body_len := LENGTH(body_block);

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

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

Line 335: AND ghr1.standard_re_rate_flag = ''Y''

331: AND ghr1.hierarchy_id = ghr.hierarchy_id
332: AND ghr1.from_currency = ghr.from_currency
333: AND ghr1.to_currency = ghr.to_currency
334: AND ghr1.line_item_id = ghr.line_item_id
335: AND ghr1.standard_re_rate_flag = ''Y''
336: AND ghr1.line_item_id = p_hier_li_id';
337:
338: curr_pos := 1;
339: body_len := LENGTH(body_block);

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

345: END LOOP;
346:
347: line_num := GCS_TRANS_DYN_BUILD_PKG.build_join_list(' AND ghr1.', ' = ghr.', '', line_num, 'F');
348:
349: --Bugfix 6111815: Only Roll Forward Rates Where Standard RE Rate Flag is Y
350: body_block :=
351: ' AND ghr1.cal_period_id = p_prev_period_id)
352: WHERE ghr.rowid IN (
353: SELECT ghr3.rowid

Line 368: ANd ghr3.standard_re_rate_flag = ''Y''

364: AND ghr3.hierarchy_id = ghr2.hierarchy_id
365: AND ghr2.cal_period_id = p_prev_period_id
366: AND ghr3.cal_period_id = p_cal_period_id
367: AND ghr3.line_item_id = ghr2.line_item_id
368: ANd ghr3.standard_re_rate_flag = ''Y''
369: AND ghr3.line_item_id = p_hier_li_id';
370:
371: curr_pos := 1;
372: body_len := LENGTH(body_block);

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

388: OR
389: nvl(to_char(ghr2.translated_amount), ''X'') <>
390: nvl(to_char(ghr3.translated_amount), ''X'')));
391:
392: --Bugfix 6111815: Only Roll Forward Rates Where Standard RE Rate Flag is Y
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 = ''''Y'''' '' || 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 = ''''Y'''' '' || g_nl ||
414: '' AND ghr3.line_item_id = p_hier_li_id '' || g_nl ||';
415:
416: curr_pos := 1;
417: body_len := LENGTH(body_block);

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

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

Line 455: AND ghr3.standard_re_rate_flag = ''Y''

451: AND ghr2.from_currency (+)= p_from_ccy
452: AND ghr2.to_currency (+)= p_to_ccy
453: AND ghr2.stop_rollforward_flag (+)= ''N''
454: AND ghr2.line_item_id (+)= ghr3.line_item_id
455: AND ghr3.standard_re_rate_flag = ''Y''
456: AND ghr3.line_item_id = p_hier_li_id';
457:
458: curr_pos := 1;
459: body_len := LENGTH(body_block);

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

465: END LOOP;
466:
467: line_num := GCS_TRANS_DYN_BUILD_PKG.build_join_list(' AND ghr2.', ' (+)= ghr3.', '', line_num, 'F');
468:
469: --Bugfix 6111815: Only Roll Forward Rates Where Standard RE Rate Flag is Y
470: body_block :=
471: ' );
472:
473: write_to_log(module, FND_LOG.LEVEL_STATEMENT,

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

470: body_block :=
471: ' );
472:
473: write_to_log(module, FND_LOG.LEVEL_STATEMENT,
474: ''INSERT /*+ parallel (gcs_historical_rates) */ INTO gcs_historical_rates(standard_re_rate_flag, entity_id, hierarchy_id, '' ||
475: ''cal_period_id, from_currency, to_currency, line_item_id, '' ||
476: ''company_cost_center_org_id, intercompany_id, financial_elem_id, '' ||
477: ''product_id, natural_account_id, channel_id, project_id, customer_id, task_id, '' ||
478: ''user_dim1_id, user_dim2_id, user_dim3_id, user_dim4_id, user_dim5_id, '' ||

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

509: ''AND ghr.cal_period_id = '' || p_prev_period_id || g_nl ||
510: ''AND ghr.account_type_code IN (''''ASSET'''',''''LIABILITY'''',decode('''''' || p_eq_xlate_mode || '''''', ''''YTD'''', ''''EQUITY'''', NULL))'' || g_nl ||
511: ''AND ghr.stop_rollforward_flag = ''''N'''''' || g_nl ||
512: ''AND ghr.line_item_id = '' || p_hier_li_id || g_nl ||
513: ''AND ghr.standard_re_rate_flag = ''''Y'''' '' || g_nl ||
514: '' AND NOT EXISTS ('' || g_nl ||
515: '' SELECT 1 FROM gcs_historical_rates ghr1'' || g_nl ||
516: '' WHERE ghr1.entity_id = p_entity_id'' || g_nl ||
517: '' AND ghr1.hierarchy_id = p_hierarchy_id'' || g_nl ||

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

537: -- Next, insert historical rates for balance sheet accounts if:
538: -- 1. No historical rate exists for the current period.
539: -- 2. A historical rate is defined for the previous period with Prior or
540: -- Historical rate type and the stop roll forward flag is not checked.
541: -- Bugfix 6111815: Adeded Standard RE Rate Flag as part of insert
542: INSERT /*+ parallel (gcs_historical_rates) */ INTO gcs_historical_rates(
543: standard_re_rate_flag, entity_id, hierarchy_id, cal_period_id, from_currency,
544: to_currency, line_item_id, company_cost_center_org_id, intercompany_id,
545: financial_elem_id, product_id, natural_account_id,

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

539: -- 2. A historical rate is defined for the previous period with Prior or
540: -- Historical rate type and the stop roll forward flag is not checked.
541: -- Bugfix 6111815: Adeded Standard RE Rate Flag as part of insert
542: INSERT /*+ parallel (gcs_historical_rates) */ INTO gcs_historical_rates(
543: standard_re_rate_flag, entity_id, hierarchy_id, cal_period_id, from_currency,
544: to_currency, line_item_id, company_cost_center_org_id, intercompany_id,
545: financial_elem_id, product_id, natural_account_id,
546: channel_id, project_id, customer_id, task_id, user_dim1_id, user_dim2_id,
547: user_dim3_id, user_dim4_id, user_dim5_id, user_dim6_id, user_dim7_id,

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

564: END LOOP;
565:
566: line_num := GCS_TRANS_DYN_BUILD_PKG.build_comma_list(' ghr.', '', ' NULL,', line_num, 'F');
567:
568: --Bugfix 6111815: Only Roll Forward Rates Where Standard RE Rate Flag is Y
569: body_block :=
570: ' ghr.translated_rate, ghr.translated_amount, ''P'', ''N'',
571: ghr.account_type_code, ''N'', sysdate, gcs_translation_pkg.g_fnd_user_id,
572: gcs_translation_pkg.g_fnd_login_id, sysdate,

Line 584: AND ghr.standard_re_rate_flag = ''Y''

580: AND ghr.cal_period_id = p_prev_period_id
581: AND ghr.account_type_code IN (''ASSET'',''LIABILITY'',decode(p_eq_xlate_mode, ''YTD'', ''EQUITY'', NULL))
582: AND ghr.stop_rollforward_flag = ''N''
583: AND ghr.line_item_id = p_hier_li_id
584: AND ghr.standard_re_rate_flag = ''Y''
585: AND NOT EXISTS (
586: SELECT 1 FROM gcs_historical_rates ghr1
587: WHERE ghr1.entity_id = p_entity_id
588: AND ghr1.hierarchy_id = p_hierarchy_id

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

762: END LOOP;
763:
764: line_num := GCS_TRANS_DYN_BUILD_PKG.build_comma_list(''' fb_in.', ' '' ||', '', line_num, 'F');
765:
766: --Bugfix 6111815: Added Standard RE Rate Flag
767: body_block :=
768: ''' fb_in.line_item_id) fb,'' || g_nl ||
769: '' FEM_LN_ITEMS_ATTR li,'' || g_nl ||
770: '' FEM_EXT_ACCT_TYPES_ATTR fxata,'' || g_nl ||

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

781: ''AND ghr.to_currency = '''''' || p_to_ccy || '''''''' || g_nl ||
782: ''AND ghr.cal_period_id = '' || p_cal_period_id || g_nl ||
783: ''AND ghr.line_item_id = fb.line_item_id'' || g_nl ||
784: ''AND ghr.update_flag = ''''N'''' '' || g_nl ||
785: ''AND ghr.standard_re_rate_flag = ''''Y'''' '' || g_nl ||
786: ''AND fb.line_item_id = p_hier_li_id '' || g_nl ||';
787:
788: curr_pos := 1;
789: body_len := LENGTH(body_block);

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

905: END LOOP;
906:
907: line_num := GCS_TRANS_DYN_BUILD_PKG.build_comma_list(' fb_in.', '', '', line_num, 'F');
908:
909: --Bugfix 6111815: Added Standard RE Rate Flag
910: body_block :=
911: ' fb_in.line_item_id) fb,
912: FEM_LN_ITEMS_ATTR li,
913: FEM_EXT_ACCT_TYPES_ATTR fxata,

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

925: AND ghr.cal_period_id = p_cal_period_id
926: AND ghr.line_item_id = fb.line_item_id
927: AND ghr.update_flag = ''N''
928: AND fb.line_item_id = p_hier_li_id
929: AND ghr.standard_re_rate_flag = ''Y'' ';
930:
931: curr_pos := 1;
932: body_len := LENGTH(body_block);
933: WHILE curr_pos <= body_len LOOP

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

1026: END LOOP;
1027:
1028: line_num := GCS_TRANS_DYN_BUILD_PKG.build_comma_list(''' fb_in.', ' '' ||', '', line_num, 'F');
1029:
1030: --Bugfix 6111815: Added Standard RE Rate Flag
1031: body_block :=
1032: ''' ytd_debit_balance_e sum_ytd_debit_balance_e,'' || g_nl ||
1033: '' ytd_credit_balance_e sum_ytd_credit_balance_e'' || g_nl ||
1034: '' FROM FEM_BALANCES fb_in'' || g_nl ||

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

1053: ''AND ghr.to_currency = '''''' || p_to_ccy || '''''''' || g_nl ||
1054: ''AND ghr.cal_period_id = '' || p_cal_period_id || g_nl ||
1055: ''AND ghr.line_item_id = fb.line_item_id'' || g_nl ||
1056: ''AND ghr.update_flag = ''''N'''' '' || g_nl ||
1057: ''AND ghr.standard_re_rate_flag = ''''Y'''' '' || g_nl ||
1058: ''AND fb.line_item_id = p_hier_li_id '' || g_nl ||';
1059:
1060: curr_pos := 1;
1061: body_len := LENGTH(body_block);

Line 1158: --Bugfix 6111815: Removed Added Standard RE Rate Flag

1154: END LOOP;
1155:
1156: line_num := GCS_TRANS_DYN_BUILD_PKG.build_comma_list(' fb_in.', '', '', line_num, 'F');
1157:
1158: --Bugfix 6111815: Removed Added Standard RE Rate Flag
1159: body_block :=
1160: ' ytd_debit_balance_e sum_ytd_debit_balance_e,
1161: ytd_credit_balance_e sum_ytd_credit_balance_e
1162: FROM FEM_BALANCES fb_in

Line 1185: AND ghr.standard_re_rate_flag = ''Y''

1181: AND ghr.to_currency = p_to_ccy
1182: AND ghr.cal_period_id = p_cal_period_id
1183: AND ghr.line_item_id = fb.line_item_id
1184: AND ghr.update_flag = ''N''
1185: AND ghr.standard_re_rate_flag = ''Y''
1186: AND fb.line_item_id = p_hier_li_id';
1187:
1188: curr_pos := 1;
1189: body_len := LENGTH(body_block);

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

1422: END LOOP;
1423:
1424: line_num := GCS_TRANS_DYN_BUILD_PKG.build_join_list('''AND fbp.', ' (+)= fb.', ''' || g_nl ||', line_num, 'F');
1425:
1426: --Bugfix 6111815: Added Standard RE Rate Flag
1427: body_block :=
1428: '''AND ghr.entity_id = '' || p_entity_id || g_nl ||
1429: ''AND ghr.hierarchy_id = '' || p_hierarchy_id || g_nl ||
1430: ''AND ghr.from_currency = '''''' || p_from_ccy || '''''''' || g_nl ||

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

1430: ''AND ghr.from_currency = '''''' || p_from_ccy || '''''''' || g_nl ||
1431: ''AND ghr.to_currency = '''''' || p_to_ccy || '''''''' || g_nl ||
1432: ''AND ghr.cal_period_id = '' || p_cal_period_id || g_nl ||
1433: ''AND ghr.line_item_id = fb.line_item_id'' || g_nl ||
1434: ''AND ghr.standard_re_rate_flag = ''''Y'''' '' || g_nl ||
1435: ''AND ghr.update_flag = ''''N'''''' || g_nl ||';
1436:
1437: curr_pos := 1;
1438: body_len := LENGTH(body_block);

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

1591: END LOOP;
1592:
1593: line_num := GCS_TRANS_DYN_BUILD_PKG.build_join_list(' AND fbp.', ' (+)= fb.', '', line_num, 'F');
1594:
1595: --Bugfix 6111815: Added Standard RE Rate Flag
1596: body_block :=
1597: ' AND ghr.entity_id = p_entity_id
1598: AND ghr.hierarchy_id = p_hierarchy_id
1599: AND ghr.from_currency = p_from_ccy

Line 1603: AND ghr.standard_re_rate_flag = ''Y''

1599: AND ghr.from_currency = p_from_ccy
1600: AND ghr.to_currency = p_to_ccy
1601: AND ghr.cal_period_id = p_cal_period_id
1602: AND ghr.line_item_id = fb.line_item_id
1603: AND ghr.standard_re_rate_flag = ''Y''
1604: AND ghr.update_flag = ''N''';
1605:
1606: curr_pos := 1;
1607: body_len := LENGTH(body_block);

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

1748: END LOOP;
1749:
1750: line_num := GCS_TRANS_DYN_BUILD_PKG.build_join_list('''AND fbp.', ' (+)= fb.', ''' || g_nl ||', line_num, 'F');
1751:
1752: --Bugfix 6111815: Added Standard RE Rate Flag
1753: body_block :=
1754: '''AND ghr.entity_id = '' || p_entity_id || g_nl ||
1755: ''AND ghr.hierarchy_id = '' || p_hierarchy_id || g_nl ||
1756: ''AND ghr.from_currency = '''''' || p_from_ccy || '''''''' || g_nl ||

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

1756: ''AND ghr.from_currency = '''''' || p_from_ccy || '''''''' || g_nl ||
1757: ''AND ghr.to_currency = '''''' || p_to_ccy || '''''''' || g_nl ||
1758: ''AND ghr.cal_period_id = '' || p_cal_period_id || g_nl ||
1759: ''AND ghr.line_item_id = fb.line_item_id'' || g_nl ||
1760: ''AND ghr.standard_re_rate_flag = ''''Y'''' '' || g_nl ||
1761: ''AND ghr.update_flag = ''''N'''''' || g_nl ||';
1762:
1763: curr_pos := 1;
1764: body_len := LENGTH(body_block);

Line 1907: --Bugfix 6111815: Removed Outer Joins and Added Standard RE Rate Flag Condition

1903: END LOOP;
1904:
1905: line_num := GCS_TRANS_DYN_BUILD_PKG.build_join_list(' AND fbp.', ' (+)= fb.', '', line_num, 'F');
1906:
1907: --Bugfix 6111815: Removed Outer Joins and Added Standard RE Rate Flag Condition
1908: body_block :=
1909: ' AND ghr.entity_id = p_entity_id
1910: AND ghr.hierarchy_id = p_hierarchy_id
1911: AND ghr.from_currency = p_from_ccy

Line 1915: AND ghr.standard_re_rate_flag = ''Y''

1911: AND ghr.from_currency = p_from_ccy
1912: AND ghr.to_currency = p_to_ccy
1913: AND ghr.cal_period_id = p_cal_period_id
1914: AND ghr.line_item_id = fb.line_item_id
1915: AND ghr.standard_re_rate_flag = ''Y''
1916: AND ghr.update_flag = ''N''';
1917:
1918: curr_pos := 1;
1919: body_len := LENGTH(body_block);