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_ENGINE_PKG dependencies on GCS_FLATTENED_RELNS

Line 685: DELETE FROM gcs_flattened_relns

681: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.DELETE_FLATTENED_RELNS', '<>');
682: END IF;
683:
684: --Bugfix 4928211: For performance purposes deleting from gcs_flattened relations when parent node is fully complete with consolidation
685: DELETE FROM gcs_flattened_relns
686: WHERE run_name = cons_entity_wf_info.run_identifier;
687:
688: COMMIT;
689:

Line 784: --Bugfix 4928211: If this is the topmost parent for the specifc run then delete data from gcs_flattened_relns

780: p_cal_period_id => cons_entity_wf_info.cal_period_id,
781: p_analysis_cycle_id => cons_entity_wf_info.analysis_cycle_id);
782: END IF;
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

Line 855: --Bugfix 4928211: For performance benefit store all children of consolidation hierarchy into gcs_flattened_relns

851: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
852: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.CREATE_FLATTENED_RELNS', '<>');
853: END IF;
854:
855: --Bugfix 4928211: For performance benefit store all children of consolidation hierarchy into gcs_flattened_relns
856:
857: INSERT INTO gcs_flattened_relns
858: (run_name,
859: parent_entity_id,

Line 857: INSERT INTO gcs_flattened_relns

853: END IF;
854:
855: --Bugfix 4928211: For performance benefit store all children of consolidation hierarchy into gcs_flattened_relns
856:
857: INSERT INTO gcs_flattened_relns
858: (run_name,
859: parent_entity_id,
860: child_entity_id,
861: creation_date,

Line 1002: --Bugfix 4928211: For performance benefit store all children of consolidation hierarchy into gcs_flattened_relns

998: WF_ENGINE.Set_Item_Parent(g_cons_item_type, l_childkey_list(counter), itemtype, itemkey,'WAITFORFLOW-1');
999:
1000: l_entities_to_process := TRUE;
1001:
1002: --Bugfix 4928211: For performance benefit store all children of consolidation hierarchy into gcs_flattened_relns
1003: create_flattened_relns(cons_entity_wf_info,
1004: v_cons_entity.child_entity_id);
1005:
1006: END LOOP;