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_CONS_IMPACT_ANALYSIS_PKG dependencies on GCS_CONS_ENG_RUNS

Line 15: FROM gcs_cons_relationships gcr, gcs_cons_eng_runs gcer

11:
12: CURSOR c_parent_entity(p_child_entity_id NUMBER, p_hierarchy_id NUMBER, p_end_date DATE, p_cal_period_id NUMBER) IS
13:
14: SELECT gcr.parent_entity_id
15: FROM gcs_cons_relationships gcr, gcs_cons_eng_runs gcer
16: WHERE gcr.hierarchy_id = p_hierarchy_id
17: AND gcr.child_entity_id = p_child_entity_id
18: AND gcr.dominant_parent_flag = 'Y'
19: AND gcr.hierarchy_id = gcer.hierarchy_id

Line 203: UPDATE gcs_cons_eng_runs

199: ' Updating the impacted status of Entity with Entity_Id = ' ||
200: v_parent_entity.parent_entity_id);
201: END IF;
202:
203: UPDATE gcs_cons_eng_runs
204: SET impacted_flag = 'Y'
205: WHERE hierarchy_id = p_hierarchy_id
206: AND run_entity_id = v_parent_entity.parent_entity_id
207: AND cal_period_id = l_cal_period_id

Line 566: FROM gcs_cons_eng_runs

562:
563: BEGIN
564: SELECT run_name
565: INTO l_run_name
566: FROM gcs_cons_eng_runs
567: WHERE run_entity_id = l_parent_entity_id
568: AND hierarchy_id = l_hierarchy_id
569: AND most_recent_flag = 'Y'
570: AND cal_period_id = l_cal_period_id;

Line 576: FROM gcs_cons_eng_runs gcer

572: WHEN NO_DATA_FOUND THEN
573: --Check if change happened in earlier period
574: SELECT gcer.run_name, gcer.cal_period_id
575: INTO l_run_name, l_cal_period_id
576: FROM gcs_cons_eng_runs gcer
577: WHERE gcer.run_entity_id = l_parent_entity_id
578: AND gcer.hierarchy_id = l_hierarchy_id
579: AND most_recent_flag = 'Y'
580: AND cal_period_id =

Line 582: FROM gcs_cons_eng_runs gcer_inner

578: AND gcer.hierarchy_id = l_hierarchy_id
579: AND most_recent_flag = 'Y'
580: AND cal_period_id =
581: (SELECT min(gcer_inner.cal_period_id)
582: FROM gcs_cons_eng_runs gcer_inner
583: WHERE gcer_inner.run_entity_id = l_parent_entity_id
584: AND gcer_inner.hierarchy_id = l_hierarchy_id
585: AND gcer_inner.most_recent_flag = 'Y'
586: AND gcer_inner.cal_period_id > l_cal_period_id);

Line 719: UPDATE gcs_cons_eng_runs

715: END IF;
716:
717: IF (l_impact_occurred) THEN
718: --Update IMPACTED_FLAG rather than status code
719: UPDATE gcs_cons_eng_runs
720: SET impacted_flag = 'Y'
721: WHERE run_name = l_run_name
722: AND run_entity_id = l_parent_entity_id
723: AND most_recent_flag = 'Y';

Line 791: FROM gcs_cons_eng_runs gcer,

787: SELECT gcer.run_name,
788: gcer.run_entity_id,
789: gcer.hierarchy_id,
790: gcr.cons_relationship_id
791: FROM gcs_cons_eng_runs gcer,
792: gcs_cons_relationships gcr,
793: fem_cal_periods_attr fcpa,
794: gcs_entity_cons_attrs geca,
795: gcs_cal_period_maps_gt gcpmt,

Line 924: UPDATE gcs_cons_eng_runs

920: -- p_category_code => 'DATAPREPARATION',
921: -- p_cons_rule_flag =>'N');
922: -- END IF;
923:
924: UPDATE gcs_cons_eng_runs
925: SET impacted_flag = 'Y'
926: WHERE run_name = v_impacted_runs.run_name
927: AND run_entity_id = v_impacted_runs.run_entity_id
928: AND most_recent_flag = 'Y';

Line 1054: FROM gcs_cons_eng_runs

1050:
1051: BEGIN
1052: SELECT run_name
1053: INTO l_run_name
1054: FROM gcs_cons_eng_runs
1055: WHERE most_recent_flag = 'Y'
1056: AND hierarchy_id = l_hierarchy_id
1057: AND balance_type_code = l_bal_type_code
1058: AND cal_period_id = l_start_cal_period_id

Line 1065: FROM gcs_cons_eng_runs gcer

1061: WHEN NO_DATA_FOUND THEN
1062: --Check if change happened in earlier period
1063: SELECT gcer.run_name, gcer.cal_period_id
1064: INTO l_run_name, l_start_cal_period_id
1065: FROM gcs_cons_eng_runs gcer
1066: WHERE gcer.run_entity_id = l_cons_entity_id
1067: AND gcer.hierarchy_id = l_hierarchy_id
1068: AND gcer.most_recent_flag = 'Y'
1069: AND gcer.balance_type_code = l_bal_type_code

Line 1072: FROM gcs_cons_eng_runs gcer_inner

1068: AND gcer.most_recent_flag = 'Y'
1069: AND gcer.balance_type_code = l_bal_type_code
1070: AND gcer.cal_period_id =
1071: (SELECT min(gcer_inner.cal_period_id)
1072: FROM gcs_cons_eng_runs gcer_inner
1073: WHERE gcer_inner.run_entity_id = l_cons_entity_id
1074: AND gcer_inner.hierarchy_id = l_hierarchy_id
1075: AND gcer_inner.most_recent_flag = 'Y'
1076: AND gcer_inner.balance_type_code = l_bal_type_code

Line 1111: -- Bugfix 3848844 : Added update for impact of the gcs_cons_eng_runs

1107: p_entry_id => l_entry_id,
1108: p_orig_entry_id => l_orig_entry_id);
1109: END IF;
1110:
1111: -- Bugfix 3848844 : Added update for impact of the gcs_cons_eng_runs
1112:
1113: UPDATE gcs_cons_eng_runs
1114: SET impacted_flag = 'Y'
1115: WHERE run_name = l_run_name

Line 1113: UPDATE gcs_cons_eng_runs

1109: END IF;
1110:
1111: -- Bugfix 3848844 : Added update for impact of the gcs_cons_eng_runs
1112:
1113: UPDATE gcs_cons_eng_runs
1114: SET impacted_flag = 'Y'
1115: WHERE run_name = l_run_name
1116: AND run_entity_id = l_cons_entity_id
1117: AND most_recent_flag = 'Y';

Line 1224: FROM gcs_cons_eng_runs

1220: NVL(end_date, l_start_cp_end_date);
1221:
1222: SELECT run_name
1223: INTO l_run_name
1224: FROM gcs_cons_eng_runs
1225: WHERE most_recent_flag = 'Y'
1226: AND hierarchy_id = l_hierarchy_id
1227: AND cal_period_id = l_start_cal_period_id
1228: AND balance_type_code = l_bal_type_code

Line 1256: UPDATE gcs_cons_eng_runs

1252: p_orig_entry_id => l_orig_entry_id);
1253:
1254: END IF;
1255:
1256: UPDATE gcs_cons_eng_runs
1257: SET impacted_flag = 'Y'
1258: WHERE run_name = l_run_name
1259: AND run_entity_id = l_cons_entity_id
1260: AND most_recent_flag = 'Y';

Line 1304: FROM gcs_cons_eng_runs gcer,

1300: gcer.run_entity_id,
1301: gcerd.child_entity_id,
1302: gcer.hierarchy_id,
1303: gcer.cal_period_id
1304: FROM gcs_cons_eng_runs gcer,
1305: gcs_cons_eng_run_dtls gcerd,
1306: gcs_curr_treatments_b gctb,
1307: fem_cal_periods_b fcpb,
1308: fem_cal_periods_attr fcpa_end,

Line 1389: UPDATE gcs_cons_eng_runs

1385: p_child_entity_id => v_impacted_runs.child_entity_id,
1386: p_message_name => 'GCS_TRANSLATION_RATES_ALTERED',
1387: p_date_token => sysdate);
1388:
1389: UPDATE gcs_cons_eng_runs
1390: SET impacted_flag = 'Y'
1391: WHERE run_name = v_impacted_runs.run_name
1392: ANd run_entity_id = v_impacted_runs.run_entity_id;
1393:

Line 1463: FROM gcs_cons_eng_runs gcer, gcs_cons_eng_run_dtls gcerd

1459: END IF;
1460:
1461: SELECT gcer.run_name, gcer.run_entity_id
1462: INTO l_run_name, l_run_entity_id
1463: FROM gcs_cons_eng_runs gcer, gcs_cons_eng_run_dtls gcerd
1464: WHERE gcer.hierarchy_id = l_hierarchy_id
1465: AND gcer.cal_period_id = l_cal_period_id
1466: AND gcer.most_recent_flag = 'Y'
1467: AND gcer.run_entity_id = gcerd.consolidation_entity_id

Line 1478: UPDATE gcs_cons_eng_runs

1474: p_child_entity_id => l_entity_id,
1475: p_message_name => 'GCS_HISTORICAL_RATES_ALTERED',
1476: p_date_token => sysdate);
1477:
1478: UPDATE gcs_cons_eng_runs
1479: SET impacted_flag = 'Y'
1480: WHERE run_name = l_run_name
1481: ANd run_entity_id = l_run_entity_id;
1482:

Line 1553: FROM gcs_cons_eng_runs

1549:
1550: --Check if top parent needs to be re-consolidated
1551: SELECT parent_entity_id
1552: INTO l_run_parent_entity_id
1553: FROM gcs_cons_eng_runs
1554: WHERE run_name = p_run_name
1555: AND run_entity_id = p_run_entity_id;
1556:
1557: IF (l_run_parent_entity_id = -1) THEN

Line 1570: FROM gcs_cons_eng_runs

1566: NVL(end_date, p_cal_period_end_date);
1567:
1568: SELECT run_name
1569: INTO l_run_name
1570: FROM gcs_cons_eng_runs
1571: WHERE run_entity_id = l_parent_entity_id
1572: AND cal_period_id = p_cal_period_id
1573: AND hierarchy_id = p_hierarchy_id
1574: AND balance_type_code = p_balance_type_code

Line 1589: UPDATE gcs_cons_eng_runs

1585: p_child_entity_id => p_run_entity_id,
1586: p_message_name => 'GCS_SUB_RECONSOLIDATED',
1587: p_date_token => sysdate);
1588:
1589: UPDATE gcs_cons_eng_runs
1590: SET impacted_flag = 'Y'
1591: WHERE run_name = l_run_name
1592: AND run_entity_id = l_parent_entity_id;
1593:

Line 1614: FROM gcs_cons_eng_runs

1610: p_cal_period_record => l_cal_period_info);
1611:
1612: SELECT run_name
1613: INTO l_run_name
1614: FROM gcs_cons_eng_runs
1615: WHERE hierarchy_id = p_hierarchy_id
1616: AND run_entity_id = p_run_entity_id
1617: AND balance_type_code = p_balance_type_code
1618: AND cal_period_id = l_cal_period_info.next_cal_period_id

Line 1627: UPDATE gcs_cons_eng_runs

1623: p_child_entity_id => p_run_entity_id,
1624: p_message_name => 'GCS_PRIOR_PD_RECONSOLIDATED',
1625: p_date_token => sysdate);
1626:
1627: UPDATE gcs_cons_eng_runs
1628: SET impacted_flag = 'Y'
1629: WHERE run_name = l_run_name
1630: AND run_entity_id = p_run_entity_id;
1631:

Line 1693: FROM gcs_cons_eng_runs gcer,

1689: CURSOR c_impacted_hierarchies IS
1690: SELECT min(gcer.cal_period_id) cal_period_id,
1691: gcer.hierarchy_id hierarchy_id,
1692: min(fcpa_end.date_assign_value) end_date
1693: FROM gcs_cons_eng_runs gcer,
1694: fem_cal_periods_attr fcpa_start,
1695: fem_cal_periods_attr fcpa_end
1696: WHERE gcer.cal_period_id = fcpa_start.cal_period_id
1697: AND gcer.cal_period_id = fcpa_end.cal_period_id

Line 1711: gcs_cons_eng_runs gcer,

1707:
1708: CURSOR c_impacted_entities(p_hierarchy_id NUMBER, p_cal_period_id NUMBER, p_cal_period_end_date DATE) IS
1709: SELECT gcr.parent_entity_id, gcr.child_entity_id, gcer.run_name
1710: FROM gcs_cons_relationships gcr,
1711: gcs_cons_eng_runs gcer,
1712: fem_global_vs_combo_defs fgvcd,
1713: gcs_entities_attr gea,
1714: fem_ledgers_attr fla
1715: WHERE gcr.hierarchy_id = p_hierarchy_id

Line 1816: UPDATE gcs_cons_eng_runs

1812: l_character_index := l_tab_run_entity_info.FIRST;
1813:
1814: WHILE (l_character_index IS NOT NULL) LOOP
1815:
1816: UPDATE gcs_cons_eng_runs
1817: SET impacted_flag = 'Y'
1818: WHERE run_name = l_tab_run_entity_info(l_character_index)
1819: .run_name
1820: AND run_entity_id = l_tab_run_entity_info(l_character_index)

Line 1929: FROM gcs_cons_eng_runs

1925: NVL(end_date, l_start_cp_end_date);
1926:
1927: SELECT run_name
1928: INTO l_run_name
1929: FROM gcs_cons_eng_runs
1930: WHERE most_recent_flag = 'Y'
1931: AND hierarchy_id = l_hierarchy_id
1932: AND cal_period_id = l_start_cal_period_id
1933: AND balance_type_code = l_bal_type_code

Line 1945: UPDATE gcs_cons_eng_runs

1941: p_post_relationship_id => null,
1942: p_date_token => sysdate,
1943: p_entry_id => l_entry_id);
1944:
1945: UPDATE gcs_cons_eng_runs
1946: SET impacted_flag = 'Y'
1947: WHERE run_name = l_run_name
1948: AND run_entity_id = l_cons_entity_id
1949: AND most_recent_flag = 'Y';