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

Line 86: UPDATE gcs_cons_eng_runs

82: AND cal_period_id = p_cal_period_id;
83:
84: -- Bugfix : Change All Icons to Not Started
85:
86: UPDATE gcs_cons_eng_runs
87: SET most_recent_flag = 'X'
88: WHERE most_recent_flag = 'Y'
89: AND run_entity_id = p_consolidation_entity
90: AND hierarchy_id = p_consolidation_hierarchy

Line 94: UPDATE gcs_cons_eng_runs gcer

90: AND hierarchy_id = p_consolidation_hierarchy
91: AND cal_period_id = p_cal_period_id
92: AND balance_type_code = p_balance_type_code;
93:
94: UPDATE gcs_cons_eng_runs gcer
95: SET gcer.most_recent_flag = 'X'
96: WHERE gcer.most_recent_flag = 'Y'
97: AND gcer.hierarchy_id = p_consolidation_hierarchy
98: AND gcer.cal_period_id = p_cal_period_id

Line 173: GCS_CONS_ENG_RUNS_PKG.insert_row

169: WHERE attribute_id = l_end_date_attribute_id
170: AND version_id = l_end_date_version_id
171: AND cal_period_id = p_cal_period_id;
172:
173: GCS_CONS_ENG_RUNS_PKG.insert_row
174: (
175: p_run_name => p_run_identifier,
176: p_hierarchy_id => p_consolidation_hierarchy,
177: p_process_method_code => NVL(p_process_method, 'FULL'),

Line 190: UPDATE gcs_cons_eng_runs

186: COMMIT;
187:
188: -- Bugfix : Change All Icons to Not Started
189:
190: UPDATE gcs_cons_eng_runs
191: SET most_recent_flag = 'X'
192: WHERE most_recent_flag = 'Y'
193: AND run_entity_id = p_consolidation_entity
194: AND hierarchy_id = p_consolidation_hierarchy

Line 198: UPDATE gcs_cons_eng_runs gcer

194: AND hierarchy_id = p_consolidation_hierarchy
195: AND cal_period_id = p_cal_period_id
196: AND balance_type_code = p_balance_type_code;
197:
198: UPDATE gcs_cons_eng_runs gcer
199: SET gcer.most_recent_flag = 'X'
200: WHERE gcer.most_recent_flag = 'Y'
201: AND gcer.hierarchy_id = p_consolidation_hierarchy
202: AND gcer.cal_period_id = p_cal_period_id

Line 286: --Bugfix 6195807: To check if the process_identifier is already exists in gcs_cons_eng_runs.

282:
283: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
284: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.EXECUTE_CONSOLIDATION.begin', '<>');
285: END IF;
286: --Bugfix 6195807: To check if the process_identifier is already exists in gcs_cons_eng_runs.
287: --This fix is for running REQUEST SET.
288: BEGIN
289: SELECT 1
290: INTO l_process_identifier_exists

Line 291: FROM gcs_cons_eng_runs

287: --This fix is for running REQUEST SET.
288: BEGIN
289: SELECT 1
290: INTO l_process_identifier_exists
291: FROM gcs_cons_eng_runs
292: WHERE run_name=p_run_identifier;
293:
294: IF l_process_identifier_exists=1 THEN
295: SELECT gcs_cons_eng_run_dtls_s.NEXTVAL

Line 303: --Bugfix 6195807: To check if the process_identifier is already exists in gcs_cons_eng_runs.

299: EXCEPTION
300: WHEN NO_DATA_FOUND THEN
301: NULL;
302: END;
303: --Bugfix 6195807: To check if the process_identifier is already exists in gcs_cons_eng_runs.
304: fnd_file.put_line(fnd_file.log, 'Beginning Consolidation Submission Execution');
305:
306: fnd_file.put_line(fnd_file.log, '<>');
307: fnd_file.put_line(fnd_file.log, 'Consolidation Hierarchy : ' || p_consolidation_hierarchy);

Line 411: UPDATE gcs_cons_eng_runs

407: IF (p_called_via_srs = 'Y') THEN
408: fnd_file.put_line(fnd_file.log, 'Resetting consolidation status to IN_PROGRESS');
409:
410: fnd_file.put_line(fnd_file.log, 'End Date : ' || l_cal_period_end_date);
411: UPDATE gcs_cons_eng_runs
412: SET most_recent_flag = 'X'
413: WHERE most_recent_flag = 'Y'
414: AND run_entity_id = p_consolidation_entity
415: AND hierarchy_id = p_consolidation_hierarchy

Line 419: UPDATE gcs_cons_eng_runs gcer

415: AND hierarchy_id = p_consolidation_hierarchy
416: AND cal_period_id = p_cal_period_id
417: AND balance_type_code = p_balance_type_code;
418:
419: UPDATE gcs_cons_eng_runs gcer
420: SET gcer.most_recent_flag = 'X'
421: WHERE gcer.most_recent_flag = 'Y'
422: AND gcer.hierarchy_id = p_consolidation_hierarchy
423: AND gcer.cal_period_id = p_cal_period_id

Line 451: GCS_CONS_ENG_RUNS_PKG.insert_row

447: WHERE entity_id = p_consolidation_entity;
448:
449: fnd_file.put_line(fnd_file.log, 'The event key is : ' || l_event_key);
450:
451: GCS_CONS_ENG_RUNS_PKG.insert_row
452: (
453: p_run_name => p_run_identifier,
454: p_hierarchy_id => p_consolidation_hierarchy,
455: p_process_method_code => NVL(p_process_method, 'FULL'),

Line 535: UPDATE gcs_cons_eng_runs

531: <>
532:
533: IF (l_error_message IS NOT NULL) AND (p_called_via_srs <> 'Y') THEN
534:
535: UPDATE gcs_cons_eng_runs
536: SET most_recent_flag = 'Y'
537: WHERE most_recent_flag = 'X'
538: AND run_entity_id = p_consolidation_entity
539: AND hierarchy_id = p_consolidation_hierarchy

Line 543: UPDATE gcs_cons_eng_runs gcer

539: AND hierarchy_id = p_consolidation_hierarchy
540: AND cal_period_id = p_cal_period_id
541: AND balance_type_code = p_balance_type_code;
542:
543: UPDATE gcs_cons_eng_runs gcer
544: SET gcer.most_recent_flag = 'Y'
545: WHERE gcer.most_recent_flag = 'X'
546: AND gcer.hierarchy_id = p_consolidation_hierarchy
547: AND gcer.cal_period_id = p_cal_period_id