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.

[Home] [Help]

APPS.GCS_CONS_ENGINE_PKG dependencies on GCS_CONS_ENG_RUNS

Line 253: gcs_cons_eng_runs gcer

249: fem_entities_attr fea,
250: fem_entities_vl fev,
251: gcs_entity_cons_attrs geca_parent,
252: gcs_entity_cons_attrs geca_child,
253: gcs_cons_eng_runs gcer
254: WHERE gcerd.run_name = p_run_name
255: AND gcerd.consolidation_entity_id = p_cons_entity_id
256: AND gcerd.entry_id IS NULL
257: AND gcerd.category_code = 'DATAPREPARATION'

Line 482: gcs_cons_eng_runs gcer

478: l_entry_id,
479: l_stat_entry_id,
480: l_request_error_code
481: FROM gcs_cons_eng_run_dtls gcerd,
482: gcs_cons_eng_runs gcer
483: WHERE gcer.run_entity_id = cons_entity_wf_info.consolidation_entity
484: AND gcerd.category_code = 'DATAPREPARATION'
485: AND gcer.run_name = gcerd.run_name
486: AND gcerd.request_error_code IN ('COMPLETED', 'WARNING')

Line 749: gcs_cons_eng_runs_pkg.update_status(

745: ELSE
746: l_status_code := 'COMPLETED';
747: END IF;
748:
749: gcs_cons_eng_runs_pkg.update_status(
750: p_run_name => cons_entity_wf_info.run_identifier,
751: p_most_recent_flag => 'Y',
752: p_status_code => l_status_code,
753: p_run_entity_id => cons_entity_wf_info.consolidation_entity,

Line 787: FROM gcs_cons_eng_runs

783:
784: --Bugfix 4928211: If this is the topmost parent for the specifc run then delete data from gcs_flattened_relns
785: SELECT parent_entity_id
786: INTO l_top_entity_id
787: FROM gcs_cons_eng_runs
788: WHERE run_name = cons_entity_wf_info.run_identifier
789: AND run_entity_id = cons_entity_wf_info.consolidation_entity;
790:
791: IF (l_top_entity_id = -1) THEN

Line 931: gcs_cons_eng_runs gcer

927: fem_entities_attr fea,
928: fem_entities_vl fev,
929: gcs_entity_cons_attrs geca_parent,
930: gcs_entity_cons_attrs geca_child,
931: gcs_cons_eng_runs gcer
932: WHERE gcerd.run_name = p_run_name
933: AND gcerd.consolidation_entity_id = p_cons_entity_id
934: AND gcerd.entry_id IS NULL
935: AND category_code = 'DATAPREPARATION'

Line 971: GCS_CONS_ENG_RUNS_PKG.insert_row

967:
968: l_childkey_list.extend(1);
969: l_childkey_list(counter) := l_child_key;
970:
971: GCS_CONS_ENG_RUNS_PKG.insert_row
972: (
973: p_run_name => cons_entity_wf_info.run_identifier,
974: p_hierarchy_id => cons_entity_wf_info.consolidation_hierarchy,
975: p_process_method_code => cons_entity_wf_info.process_method,

Line 1101: FROM gcs_cons_eng_runs

1097: INTO l_prior_run_name,
1098: l_status_code,
1099: l_locked_flag,
1100: l_impacted_flag
1101: FROM gcs_cons_eng_runs
1102: WHERE run_entity_id = cons_entity_wf_info.consolidation_entity
1103: -- Bugfix 3659810 : Added condition for hierarchy_id
1104: AND hierarchy_id = cons_entity_wf_info.consolidation_hierarchy
1105: AND most_recent_flag = 'X'

Line 1112: gcs_cons_eng_runs_pkg.update_status ( p_run_name => l_prior_run_name,

1108: WF_ENGINE.SetItemAttrText(itemtype, itemkey, 'PRIOR_RUN_NAME', l_prior_run_name);
1109: result := 'COMPLETE:F';
1110:
1111: --Bugfix 3750740 : Update Prior Run To MOST_RECENT_FLAG = 'N'
1112: gcs_cons_eng_runs_pkg.update_status ( p_run_name => l_prior_run_name,
1113: p_most_recent_flag => 'N',
1114: p_status_code => NULL,
1115: p_run_entity_id => cons_entity_wf_info.consolidation_entity);
1116:

Line 1117: gcs_cons_eng_runs_pkg.update_status ( p_run_name => cons_entity_wf_info.run_identifier,

1113: p_most_recent_flag => 'N',
1114: p_status_code => NULL,
1115: p_run_entity_id => cons_entity_wf_info.consolidation_entity);
1116:
1117: gcs_cons_eng_runs_pkg.update_status ( p_run_name => cons_entity_wf_info.run_identifier,
1118: p_most_recent_flag => 'Y',
1119: p_status_code => 'IN_PROGRESS',
1120: p_run_entity_id => cons_entity_wf_info.consolidation_entity);
1121:

Line 1136: gcs_cons_eng_runs_pkg.update_status ( p_run_name => cons_entity_wf_info.run_identifier,

1132: EXCEPTION
1133: WHEN NO_DATA_FOUND THEN
1134: WF_ENGINE.SetItemAttrText(itemtype, itemkey, 'PRIOR_RUN_NAME', 'NO_PRIOR_RUN');
1135:
1136: gcs_cons_eng_runs_pkg.update_status ( p_run_name => cons_entity_wf_info.run_identifier,
1137: p_most_recent_flag => 'Y',
1138: p_status_code => 'IN_PROGRESS',
1139: p_run_entity_id => cons_entity_wf_info.consolidation_entity);
1140: result := 'COMPLETE:F';

Line 1158: UPDATE gcs_cons_eng_runs

1154: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1155: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.UPDATE_RUN_INFORMATION.begin', '<>');
1156: END IF;
1157:
1158: UPDATE gcs_cons_eng_runs
1159: SET most_recent_flag = 'Y'
1160: WHERE run_name = cons_entity_wf_info.prior_run_identifier
1161: AND run_entity_id = cons_entity_wf_info.consolidation_entity
1162: RETURNING status_code, impacted_flag, locked_flag INTO l_status_code, l_impacted_flag, l_locked_flag;

Line 1164: UPDATE gcs_cons_eng_runs

1160: WHERE run_name = cons_entity_wf_info.prior_run_identifier
1161: AND run_entity_id = cons_entity_wf_info.consolidation_entity
1162: RETURNING status_code, impacted_flag, locked_flag INTO l_status_code, l_impacted_flag, l_locked_flag;
1163:
1164: UPDATE gcs_cons_eng_runs
1165: SET most_recent_flag = 'N',
1166: associated_run_name = cons_entity_wf_info.prior_run_identifier,
1167: status_code = l_status_code,
1168: impacted_flag = l_impacted_flag,

Line 1177: UPDATE gcs_cons_eng_runs gcer

1173: last_update_login = FND_GLOBAL.LOGIN_ID
1174: WHERE run_name = cons_entity_wf_info.run_identifier
1175: AND run_entity_id = cons_entity_wf_info.consolidation_entity;
1176:
1177: UPDATE gcs_cons_eng_runs gcer
1178: SET gcer.most_recent_flag = 'Y'
1179: WHERE gcer.most_recent_flag = 'X'
1180: AND gcer.hierarchy_id = cons_entity_wf_info.consolidation_hierarchy
1181: AND gcer.cal_period_id = cons_entity_wf_info.cal_period_id