[Home] [Help]
200:
201: -- Cursor to the entry_id and stat_entry_id that belong to perticular run_name
202: -- and run_entity_id. The following cases are considered to get the entry ids
203: -- i) All the entris that do not belong lastest run are eligible for purging.
204: -- ii) Only AUTOMATIC entries from gcs_entry_headers table are eligible for purging.
205: -- iii) stat_entry_ids along with entry_ids are also eligible for purging
206:
207: CURSOR c_purge_entry(p_consolidation_hierarchy IN NUMBER,
208: p_cal_period_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
219: AND gcerd_outer.entry_id = geh.entry_id
220: AND geh.entry_type_code = 'AUTOMATIC'
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
244: AND gcerd_outer.stat_entry_id = geh.entry_id
245: AND geh.entry_type_code = 'AUTOMATIC'
393: END IF;
394: -- To purge the entry line information
395: DELETE FROM gcs_entry_lines WHERE entry_id = l_purge_entry_id_rec(j).entry_id;
396: -- To purge the entry header information
397: DELETE FROM gcs_entry_headers WHERE entry_id = l_purge_entry_id_rec(j).entry_id;
398: -- To get the Child entity name
399: SELECT entity_name
400: INTO l_entity_name
401: FROM fem_entities_tl fem