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

Line 139: dimInfo GCS_UTILITY_PKG.t_hash_gcs_dimension_info;

135: TYPE stepDataTable IS TABLE OF getSteps%ROWTYPE INDEX BY BINARY_INTEGER;
136: stepData stepDataTable;
137:
138: --A hash table full of the accessible dims
139: dimInfo GCS_UTILITY_PKG.t_hash_gcs_dimension_info;
140:
141: --JH 7.22.04: join to FEM_OBJECT_DEFINITIONS first to get object_definition_id
142: --JH 7.28.94: added outerjoin to hierarchy_obj_id is it is nullable (Bug 3800142)
143: --Bugfix 4928211 (STK): Remove the selection of the hierarchy object definition id

Line 490: gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-ELIMINATION_ENTITY')

486: AND l_end_date between gcr.start_date and
487: nvl(gcr.end_date, l_end_date)
488: AND fea.entity_id = gcr.parent_entity_id
489: AND fea.attribute_id =
490: gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-ELIMINATION_ENTITY')
491: .attribute_id
492: AND fea.version_id =
493: gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-ELIMINATION_ENTITY')
494: .version_id

Line 493: gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-ELIMINATION_ENTITY')

489: AND fea.attribute_id =
490: gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-ELIMINATION_ENTITY')
491: .attribute_id
492: AND fea.version_id =
493: gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-ELIMINATION_ENTITY')
494: .version_id
495: AND geca.hierarchy_id = gcr.hierarchy_id
496: AND geca.entity_id = gcr.parent_entity_id
497: AND geca.currency_code = fc.currency_code;

Line 542: gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')

538: SELECT date_assign_value
539: FROM fem_cal_periods_attr
540: where cal_period_id = contextData.calPeriodId
541: AND attribute_id =
542: gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')
543: .attribute_id
544: AND version_id =
545: gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')
546: .version_id;

Line 545: gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')

541: AND attribute_id =
542: gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')
543: .attribute_id
544: AND version_id =
545: gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')
546: .version_id;
547:
548: -- get the ownership percent for the consolidating relationship
549: CURSOR c_get_ownership IS

Line 625: gcs_utility_pkg.get_conversion_rate(P_Source_Currency => contextData.CurrencyCode,

621:
622: --Bugfix 4122843 : Check if l_currency is not zero
623: IF (l_currency.COUNT <> 0) THEN
624: FOR i IN l_currency.first .. l_currency.last LOOP
625: gcs_utility_pkg.get_conversion_rate(P_Source_Currency => contextData.CurrencyCode,
626: P_Target_Currency => l_currency(i),
627: p_cal_period_Id => contextData.calPeriodId,
628: p_conversion_rate => l_rate_var,
629: P_errbuf => l_errbuf,

Line 892: dimInfo := GCS_UTILITY_PKG.g_gcs_dimension_info;

888: logString(eventLogLevel, procedureName, 'section', '1');
889: --=======================================================
890:
891: dimInfo.DELETE;
892: dimInfo := GCS_UTILITY_PKG.g_gcs_dimension_info;
893: If dimInfo.COUNT > 0 Then
894: i := dimInfo.FIRST;
895: While i IS NOT NULL Loop
896: --We do not want to include some dims in the dynamic sql used here.

Line 1175: GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-ENTITY_TYPE_CODE')

1171: SELECT dim_attribute_varchar_member
1172: FROM FEM_ENTITIES_ATTR
1173: WHERE entity_id = nvl(contextData.childEntity, -1)
1174: AND attribute_id =
1175: GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-ENTITY_TYPE_CODE')
1176: .attribute_id
1177: AND version_id =
1178: GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-ENTITY_TYPE_CODE')
1179: .version_id

Line 1178: GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-ENTITY_TYPE_CODE')

1174: AND attribute_id =
1175: GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-ENTITY_TYPE_CODE')
1176: .attribute_id
1177: AND version_id =
1178: GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-ENTITY_TYPE_CODE')
1179: .version_id
1180: AND value_set_id =
1181: GCS_UTILITY_PKG.g_gcs_dimension_info('ENTITY_ID')
1182: .associated_value_set_id;

Line 1181: GCS_UTILITY_PKG.g_gcs_dimension_info('ENTITY_ID')

1177: AND version_id =
1178: GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-ENTITY_TYPE_CODE')
1179: .version_id
1180: AND value_set_id =
1181: GCS_UTILITY_PKG.g_gcs_dimension_info('ENTITY_ID')
1182: .associated_value_set_id;
1183:
1184: begin
1185: procedureName := 'INIT_ENTRIESGT_STD_DIMSET';

Line 1467: orgId := GCS_UTILITY_PKG.get_org_id(categoryInfo.entityId,

1463: --interco values are determined (jh 06.29.04)
1464: --JH 7.28.94: use categoryInfo.entityId to get base_org (3798215)
1465: if dimInfo(i).column_name = cctr_column then
1466: if categoryInfo.org_output_code = 'BASE_ORG' then
1467: orgId := GCS_UTILITY_PKG.get_org_id(categoryInfo.entityId,
1468: contextData.hierarchy);
1469: if orgId = -1 then
1470: logString(exceptionLogLevel,
1471: procedureName,

Line 1487: orgId := GCS_UTILITY_PKG.get_org_id(contextData.childEntity,

1483: tgtOrg := to_char(orgId);
1484:
1485: --jh 11.05.04: add CHILD_BASE_ORG
1486: elsif categoryInfo.org_output_code = 'CHILD_BASE_ORG' then
1487: orgId := GCS_UTILITY_PKG.get_org_id(contextData.childEntity,
1488: contextData.hierarchy);
1489: if orgId = -1 then
1490: logString(exceptionLogLevel,
1491: procedureName,

Line 1572: orgId := GCS_UTILITY_PKG.get_org_id(contextData.childEntity,

1568: Close getSpecificIntercoId;
1569:
1570: IF intercoId IS NULL THEN
1571: IF categoryInfo.org_output_code = 'CHILD_BASE_ORG' THEN
1572: orgId := GCS_UTILITY_PKG.get_org_id(contextData.childEntity,
1573: contextData.hierarchy);
1574: IF orgId = -1 then
1575: logString(exceptionLogLevel,
1576: procedureName,

Line 1589: orgId := GCS_UTILITY_PKG.get_org_id(categoryInfo.entityId,

1585: RAISE no_default_cctr_found;
1586: END if; --if orgId = -1
1587:
1588: ELSE
1589: orgId := GCS_UTILITY_PKG.get_org_id(categoryInfo.entityId,
1590: contextData.hierarchy);
1591: IF orgId = -1 then
1592: logString(exceptionLogLevel,
1593: procedureName,

Line 2185: GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-ENTITY_TYPE_CODE')

2181: SELECT dim_attribute_varchar_member
2182: FROM FEM_ENTITIES_ATTR
2183: WHERE entity_id = nvl(contextData.childEntity, -1)
2184: AND attribute_id =
2185: GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-ENTITY_TYPE_CODE')
2186: .attribute_id
2187: AND version_id =
2188: GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-ENTITY_TYPE_CODE')
2189: .version_id

Line 2188: GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-ENTITY_TYPE_CODE')

2184: AND attribute_id =
2185: GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-ENTITY_TYPE_CODE')
2186: .attribute_id
2187: AND version_id =
2188: GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-ENTITY_TYPE_CODE')
2189: .version_id
2190: AND value_set_id =
2191: GCS_UTILITY_PKG.g_gcs_dimension_info('ENTITY_ID')
2192: .associated_value_set_id;

Line 2191: GCS_UTILITY_PKG.g_gcs_dimension_info('ENTITY_ID')

2187: AND version_id =
2188: GCS_UTILITY_PKG.g_dimension_attr_info('ENTITY_ID-ENTITY_TYPE_CODE')
2189: .version_id
2190: AND value_set_id =
2191: GCS_UTILITY_PKG.g_gcs_dimension_info('ENTITY_ID')
2192: .associated_value_set_id;
2193:
2194: --Bugfix 4928211: Added objectDefnId for performance purposes
2195: objectDefnId number;

Line 2791: orgId := GCS_UTILITY_PKG.get_org_id(categoryInfo.entityId,

2787:
2788: --Identify a default cctr and interco dim member to use
2789:
2790: --JH 7.28.04: use categoryInfo.entityId to get base_org (3798215)
2791: orgId := GCS_UTILITY_PKG.get_org_id(categoryInfo.entityId,
2792: contextData.hierarchy);
2793:
2794: if orgId = -1 then
2795: logString(exceptionLogLevel,

Line 3583: organizationId := GCS_UTILITY_PKG.get_org_id(contextData.parentEntity,

3579:
3580: --Bugfix 6160542: Added Elimination Base Org
3581: --Populate values for company_cost_center_org and intercompany
3582: if categoryInfo.org_output_code = 'BASE_ORG' then
3583: organizationId := GCS_UTILITY_PKG.get_org_id(contextData.parentEntity,
3584: contextData.hierarchy);
3585: elsif categoryInfo.org_output_code = 'ELIM_BASE_ORG' then
3586: organizationId := GCS_UTILITY_PKG.get_base_org_id(contextData.elimsEntity);
3587: else

Line 3586: organizationId := GCS_UTILITY_PKG.get_base_org_id(contextData.elimsEntity);

3582: if categoryInfo.org_output_code = 'BASE_ORG' then
3583: organizationId := GCS_UTILITY_PKG.get_org_id(contextData.parentEntity,
3584: contextData.hierarchy);
3585: elsif categoryInfo.org_output_code = 'ELIM_BASE_ORG' then
3586: organizationId := GCS_UTILITY_PKG.get_base_org_id(contextData.elimsEntity);
3587: else
3588: organizationId := GCS_UTILITY_PKG.get_org_id(contextData.childEntity,
3589: contextData.hierarchy);
3590: end if;

Line 3588: organizationId := GCS_UTILITY_PKG.get_org_id(contextData.childEntity,

3584: contextData.hierarchy);
3585: elsif categoryInfo.org_output_code = 'ELIM_BASE_ORG' then
3586: organizationId := GCS_UTILITY_PKG.get_base_org_id(contextData.elimsEntity);
3587: else
3588: organizationId := GCS_UTILITY_PKG.get_org_id(contextData.childEntity,
3589: contextData.hierarchy);
3590: end if;
3591:
3592: if organizationId = -1 then

Line 4044: l_line_item_type_attr NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE')

4040: -- See package global data declares above for cursor
4041: categoryInfo getCategory%ROWTYPE;
4042:
4043: --Bugfix 6242317: Add the attribute information
4044: l_line_item_type_attr NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE')
4045: .attribute_id;
4046: l_line_item_type_version NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE')
4047: .version_id;
4048: l_acct_type_attr NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE')

Line 4046: l_line_item_type_version NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE')

4042:
4043: --Bugfix 6242317: Add the attribute information
4044: l_line_item_type_attr NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE')
4045: .attribute_id;
4046: l_line_item_type_version NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE')
4047: .version_id;
4048: l_acct_type_attr NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE')
4049: .attribute_id;
4050: l_acct_type_version NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE')

Line 4048: l_acct_type_attr NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE')

4044: l_line_item_type_attr NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE')
4045: .attribute_id;
4046: l_line_item_type_version NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE')
4047: .version_id;
4048: l_acct_type_attr NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE')
4049: .attribute_id;
4050: l_acct_type_version NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE')
4051: .version_id;
4052:

Line 4050: l_acct_type_version NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE')

4046: l_line_item_type_version NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE')
4047: .version_id;
4048: l_acct_type_attr NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE')
4049: .attribute_id;
4050: l_acct_type_version NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE')
4051: .version_id;
4052:
4053: begin
4054: procedureName := 'CREATE_ENTRY';

Line 4155: liaAttr := GCS_UTILITY_PKG.g_dimension_attr_info(liaKey).attribute_id;

4151: --Get the attribute_id and version_id for the EXTENDED_ACCOUNT_TYPE
4152: declare
4153: liaKey varchar2(100) := 'LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE';
4154: begin
4155: liaAttr := GCS_UTILITY_PKG.g_dimension_attr_info(liaKey).attribute_id;
4156: liaVers := GCS_UTILITY_PKG.g_dimension_attr_info(liaKey).version_id;
4157: exception
4158: when no_data_found then
4159: logString(exceptionLogLevel,

Line 4156: liaVers := GCS_UTILITY_PKG.g_dimension_attr_info(liaKey).version_id;

4152: declare
4153: liaKey varchar2(100) := 'LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE';
4154: begin
4155: liaAttr := GCS_UTILITY_PKG.g_dimension_attr_info(liaKey).attribute_id;
4156: liaVers := GCS_UTILITY_PKG.g_dimension_attr_info(liaKey).version_id;
4157: exception
4158: when no_data_found then
4159: logString(exceptionLogLevel,
4160: procedureName,

Line 4176: ataAttr := GCS_UTILITY_PKG.g_dimension_attr_info(ataKey).attribute_id;

4172: --Get the attribute_id and version_id for the EXT_ACCOUNT_TYPE_CODE
4173: declare
4174: ataKey varchar2(100) := 'EXT_ACCOUNT_TYPE_CODE-SIGN';
4175: begin
4176: ataAttr := GCS_UTILITY_PKG.g_dimension_attr_info(ataKey).attribute_id;
4177: ataVers := GCS_UTILITY_PKG.g_dimension_attr_info(ataKey).version_id;
4178: exception
4179: when no_data_found then
4180: logString(exceptionLogLevel,

Line 4177: ataVers := GCS_UTILITY_PKG.g_dimension_attr_info(ataKey).version_id;

4173: declare
4174: ataKey varchar2(100) := 'EXT_ACCOUNT_TYPE_CODE-SIGN';
4175: begin
4176: ataAttr := GCS_UTILITY_PKG.g_dimension_attr_info(ataKey).attribute_id;
4177: ataVers := GCS_UTILITY_PKG.g_dimension_attr_info(ataKey).version_id;
4178: exception
4179: when no_data_found then
4180: logString(exceptionLogLevel,
4181: procedureName,