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

Line 68: FROM gcs_cons_eng_runs gcer

64:
65: BEGIN
66: SELECT run_name
67: INTO p_key
68: FROM gcs_cons_eng_runs gcer
69: WHERE gcer.hierarchy_id = p_consolidation_hierarchy
70: AND gcer.cal_period_id = p_cal_period_id
71: AND gcer.balance_type_code = p_balance_type_code
72: AND gcer.most_recent_flag = 'Y'

Line 87: X_table => 'GCS_CONS_ENG_RUNS',

83: -- AD Parallel framework Manager processing
84:
85: --Purge all the info from ad processing tables
86: ad_parallel_updates_pkg.purge_processed_units(X_owner => 'GCS',
87: X_table => 'GCS_CONS_ENG_RUNS',
88: X_script => p_key);
89:
90: ad_parallel_updates_pkg.delete_update_information(X_update_type => ad_parallel_updates_pkg.ROWID_RANGE,
91: X_owner => 'GCS',

Line 92: X_table => 'GCS_CONS_ENG_RUNS',

88: X_script => p_key);
89:
90: ad_parallel_updates_pkg.delete_update_information(X_update_type => ad_parallel_updates_pkg.ROWID_RANGE,
91: X_owner => 'GCS',
92: X_table => 'GCS_CONS_ENG_RUNS',
93: X_script => p_key);
94:
95: -- submit purge worker
96: AD_CONC_UTILS_PKG.submit_subrequests(X_errbuf => x_errbuf,

Line 167: FROM gcs_cons_eng_runs gcer,

163: p_start_rowid ROWID,
164: p_end_rowid ROWID
165: ) IS
166: SELECT DISTINCT run_name, run_entity_id, entity_name
167: FROM gcs_cons_eng_runs gcer,
168: fem_entities_tl fem
169: WHERE gcer.run_entity_id = fem.entity_id
170: AND gcer.hierarchy_id = p_consolidation_hierarchy
171: AND gcer.cal_period_id = p_cal_period_id

Line 179: FROM gcs_cons_eng_runs gcer_inner

175: AND (gcer.associated_run_name IS NULL
176: OR (gcer.associated_run_name IS NOT NULL
177: AND NOT EXISTS (
178: SELECT run_name
179: FROM gcs_cons_eng_runs gcer_inner
180: WHERE gcer_inner.hierarchy_id=p_consolidation_hierarchy
181: AND gcer_inner.cal_period_id = p_cal_period_id
182: AND gcer_inner.balance_type_code = p_balance_type_code
183: AND gcer_inner.most_recent_flag = 'Y'

Line 214: FROM gcs_cons_eng_runs gcer_outer,

210: p_run_name IN VARCHAR2,
211: p_run_entity_id IN NUMBER
212: ) IS
213: SELECT DISTINCT gcerd_outer.entry_id,gcerd_outer.child_entity_id,geh.entry_name,geh.description
214: FROM gcs_cons_eng_runs gcer_outer,
215: gcs_cons_eng_run_dtls gcerd_outer,
216: gcs_entry_headers geh
217: WHERE gcer_outer.run_name = gcerd_outer.run_name
218: AND gcer_outer.run_entity_id = gcerd_outer.consolidation_entity_id

Line 226: FROM gcs_cons_eng_runs gcer_inner,

222: AND gcerd_outer.consolidation_entity_id = p_run_entity_id
223: AND gcerd_outer.entry_id IS NOT NULL
224: AND NOT EXISTS (
225: SELECT 'X'
226: FROM gcs_cons_eng_runs gcer_inner,
227: gcs_cons_eng_run_dtls gcerd_inner
228: WHERE gcer_inner.most_recent_flag = 'Y'
229: AND gcer_inner.hierarchy_id = gcer_outer.hierarchy_id
230: AND gcer_inner.run_entity_id = gcer_outer.run_entity_id

Line 239: FROM gcs_cons_eng_runs gcer_outer,

235: )
236: UNION ALL
237:
238: SELECT DISTINCT gcerd_outer.stat_entry_id,gcerd_outer.child_entity_id,geh.entry_name,geh.description
239: FROM gcs_cons_eng_runs gcer_outer,
240: gcs_cons_eng_run_dtls gcerd_outer,
241: gcs_entry_headers geh
242: WHERE gcer_outer.run_name = gcerd_outer.run_name
243: AND gcer_outer.run_entity_id = gcerd_outer.consolidation_entity_id

Line 251: FROM gcs_cons_eng_runs gcer_inner,

247: AND gcerd_outer.consolidation_entity_id = p_run_entity_id
248: AND gcerd_outer.stat_entry_id IS NOT NULL
249: AND NOT EXISTS (
250: SELECT 'X'
251: FROM gcs_cons_eng_runs gcer_inner,
252: gcs_cons_eng_run_dtls gcerd_inner
253: WHERE gcer_inner.most_recent_flag = 'Y'
254: AND gcer_inner.hierarchy_id = gcer_outer.hierarchy_id
255: AND gcer_inner.run_entity_id = gcer_outer.run_entity_id

Line 274: v_table_name VARCHAR2(30) := 'GCS_CONS_ENG_RUNS';

270: l_purge_entry_id_rec t_purge_entry_id;
271: l_run_name NUMBER;
272: l_entity_name VARCHAR2(100);
273: v_product VARCHAR2(30) := 'GCS';
274: v_table_name VARCHAR2(30) := 'GCS_CONS_ENG_RUNS';
275: p_key VARCHAR2(30);
276: v_status VARCHAR2(30);
277: v_industry VARCHAR2(30);
278: v_retstatus BOOLEAN;

Line 321: FROM gcs_cons_eng_runs gcer

317: -- To Generate Unique key
318:
319: SELECT run_name
320: INTO p_key
321: FROM gcs_cons_eng_runs gcer
322: WHERE gcer.hierarchy_id = p_consolidation_hierarchy
323: AND gcer.cal_period_id = p_cal_period_id
324: AND gcer.balance_type_code = p_balance_type_code
325: AND gcer.most_recent_flag = 'Y'

Line 420: UPDATE gcs_cons_eng_runs

416: WHERE gcerd.run_name = l_purge_cons_entity_list(i).run_name
417: AND gcerd.consolidation_entity_id = l_purge_cons_entity_list(i).run_entity_id;
418:
419: -- To update the run information to PURGED.
420: UPDATE gcs_cons_eng_runs
421: SET status_code = 'PURGED'
422: WHERE run_name = l_purge_cons_entity_list(i).run_name
423: AND run_entity_id = l_purge_cons_entity_list(i).run_entity_id;
424: -- To keep track of how many rows processed so far