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_ENG_UTILITY_PKG dependencies on GCS_UTILITY_PKG

Line 802: AND fea.attribute_id = gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-ELIMINATION_ENTITY').attribute_id

798: SELECT fea.dim_attribute_numeric_member
799: INTO l_entity_id
800: FROM fem_entities_attr fea
801: WHERE fea.entity_id = cons_entity_wf_info.consolidation_entity
802: AND fea.attribute_id = gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-ELIMINATION_ENTITY').attribute_id
803: AND fea.version_id = gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-ELIMINATION_ENTITY').version_id;
804: ELSE
805: BEGIN
806: SELECT fea.dim_attribute_numeric_member

Line 803: AND fea.version_id = gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-ELIMINATION_ENTITY').version_id;

799: INTO l_entity_id
800: FROM fem_entities_attr fea
801: WHERE fea.entity_id = cons_entity_wf_info.consolidation_entity
802: AND fea.attribute_id = gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-ELIMINATION_ENTITY').attribute_id
803: AND fea.version_id = gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-ELIMINATION_ENTITY').version_id;
804: ELSE
805: BEGIN
806: SELECT fea.dim_attribute_numeric_member
807: INTO l_entity_id

Line 810: AND fea.attribute_id = gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-OPERATING_ENTITY').attribute_id

806: SELECT fea.dim_attribute_numeric_member
807: INTO l_entity_id
808: FROM fem_entities_attr fea
809: WHERE fea.entity_id = cons_entity_wf_info.consolidation_entity
810: AND fea.attribute_id = gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-OPERATING_ENTITY').attribute_id
811: AND fea.version_id = gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-OPERATING_ENTITY').version_id;
812: EXCEPTION
813: WHEN OTHERS THEN
814: l_entity_id := -1;

Line 811: AND fea.version_id = gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-OPERATING_ENTITY').version_id;

807: INTO l_entity_id
808: FROM fem_entities_attr fea
809: WHERE fea.entity_id = cons_entity_wf_info.consolidation_entity
810: AND fea.attribute_id = gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-OPERATING_ENTITY').attribute_id
811: AND fea.version_id = gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-OPERATING_ENTITY').version_id;
812: EXCEPTION
813: WHEN OTHERS THEN
814: l_entity_id := -1;
815: END;

Line 1142: gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-ELIMINATION_ENTITY').attribute_id;

1138: l_parameter_list gcs_cons_eng_utility_pkg.r_module_parameters;
1139: l_run_detail_id NUMBER(15);
1140: l_tgt_entity_id NUMBER(15);
1141: l_elim_entity_attr NUMBER(15) :=
1142: gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-ELIMINATION_ENTITY').attribute_id;
1143: l_elim_entity_version NUMBER(15) :=
1144: gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-ELIMINATION_ENTITY').version_id;
1145: l_oper_entity_attr NUMBER(15) :=
1146: gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-OPERATING_ENTITY').attribute_id;

Line 1144: gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-ELIMINATION_ENTITY').version_id;

1140: l_tgt_entity_id NUMBER(15);
1141: l_elim_entity_attr NUMBER(15) :=
1142: gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-ELIMINATION_ENTITY').attribute_id;
1143: l_elim_entity_version NUMBER(15) :=
1144: gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-ELIMINATION_ENTITY').version_id;
1145: l_oper_entity_attr NUMBER(15) :=
1146: gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-OPERATING_ENTITY').attribute_id;
1147: l_oper_entity_version NUMBER(15) :=
1148: gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-OPERATING_ENTITY').version_id;

Line 1146: gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-OPERATING_ENTITY').attribute_id;

1142: gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-ELIMINATION_ENTITY').attribute_id;
1143: l_elim_entity_version NUMBER(15) :=
1144: gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-ELIMINATION_ENTITY').version_id;
1145: l_oper_entity_attr NUMBER(15) :=
1146: gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-OPERATING_ENTITY').attribute_id;
1147: l_oper_entity_version NUMBER(15) :=
1148: gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-OPERATING_ENTITY').version_id;
1149:
1150:

Line 1148: gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-OPERATING_ENTITY').version_id;

1144: gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-ELIMINATION_ENTITY').version_id;
1145: l_oper_entity_attr NUMBER(15) :=
1146: gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-OPERATING_ENTITY').attribute_id;
1147: l_oper_entity_version NUMBER(15) :=
1148: gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-OPERATING_ENTITY').version_id;
1149:
1150:
1151: --Bugfix 5017120: Support for additional data types
1152: l_apply_elim_rules_flag VARCHAR2(1);

Line 1583: AND attribute_id = gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-ELIMINATION_ENTITY').attribute_id

1579: SELECT dim_attribute_numeric_member
1580: INTO l_entity_id
1581: FROM fem_entities_attr
1582: WHERE entity_id = cons_entity_wf_info.consolidation_entity
1583: AND attribute_id = gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-ELIMINATION_ENTITY').attribute_id
1584: AND version_id = gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-ELIMINATION_ENTITY').version_id;
1585:
1586: SELECT 'Y'
1587: INTO l_init_required

Line 1584: AND version_id = gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-ELIMINATION_ENTITY').version_id;

1580: INTO l_entity_id
1581: FROM fem_entities_attr
1582: WHERE entity_id = cons_entity_wf_info.consolidation_entity
1583: AND attribute_id = gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-ELIMINATION_ENTITY').attribute_id
1584: AND version_id = gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-ELIMINATION_ENTITY').version_id;
1585:
1586: SELECT 'Y'
1587: INTO l_init_required
1588: FROM gcs_cons_eng_run_dtls