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

Line 257: gcs_utility_pkg.g_gcs_dimension_info ('LINE_ITEM_ID').associated_value_set_id;

253:
254:
255: --Bugfix 4226223 : Used to populate the line type code on gcs_ad_transactionx 4226223 : Populate the line_type_code for A&D Entries
256: l_line_item_vs_id NUMBER :=
257: gcs_utility_pkg.g_gcs_dimension_info ('LINE_ITEM_ID').associated_value_set_id;
258: l_ext_acct_type_attr NUMBER :=
259: gcs_utility_pkg.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').attribute_id;
260: l_ext_acct_type_version NUMBER :=
261: gcs_utility_pkg.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').version_id;

Line 259: gcs_utility_pkg.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').attribute_id;

255: --Bugfix 4226223 : Used to populate the line type code on gcs_ad_transactionx 4226223 : Populate the line_type_code for A&D Entries
256: l_line_item_vs_id NUMBER :=
257: gcs_utility_pkg.g_gcs_dimension_info ('LINE_ITEM_ID').associated_value_set_id;
258: l_ext_acct_type_attr NUMBER :=
259: gcs_utility_pkg.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').attribute_id;
260: l_ext_acct_type_version NUMBER :=
261: gcs_utility_pkg.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').version_id;
262: l_basic_acct_type_attr NUMBER :=
263: gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').attribute_id;

Line 261: gcs_utility_pkg.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').version_id;

257: gcs_utility_pkg.g_gcs_dimension_info ('LINE_ITEM_ID').associated_value_set_id;
258: l_ext_acct_type_attr NUMBER :=
259: gcs_utility_pkg.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').attribute_id;
260: l_ext_acct_type_version NUMBER :=
261: gcs_utility_pkg.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').version_id;
262: l_basic_acct_type_attr NUMBER :=
263: gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').attribute_id;
264: l_basic_acct_type_version NUMBER :=
265: gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').version_id;

Line 263: gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').attribute_id;

259: gcs_utility_pkg.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').attribute_id;
260: l_ext_acct_type_version NUMBER :=
261: gcs_utility_pkg.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').version_id;
262: l_basic_acct_type_attr NUMBER :=
263: gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').attribute_id;
264: l_basic_acct_type_version NUMBER :=
265: gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').version_id;
266: l_entry_id NUMBER(15);
267:

Line 265: gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').version_id;

261: gcs_utility_pkg.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').version_id;
262: l_basic_acct_type_attr NUMBER :=
263: gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').attribute_id;
264: l_basic_acct_type_version NUMBER :=
265: gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').version_id;
266: l_entry_id NUMBER(15);
267:
268: BEGIN
269:

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

340: --Get the attribute_id and version_id for the EXTENDED_ACCOUNT_TYPE
341: declare
342: liaKey varchar2(100) := 'LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE';
343: begin
344: liaAttr := GCS_UTILITY_PKG.g_dimension_attr_info(liaKey).attribute_id;
345: liaVers := GCS_UTILITY_PKG.g_dimension_attr_info(liaKey).version_id;
346: logString( statementLogLevel, procedureName, 'liaAttr ', liaAttr);
347: logString( statementLogLevel, procedureName, 'liaVers ', liaVers);
348: exception

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

341: declare
342: liaKey varchar2(100) := 'LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE';
343: begin
344: liaAttr := GCS_UTILITY_PKG.g_dimension_attr_info(liaKey).attribute_id;
345: liaVers := GCS_UTILITY_PKG.g_dimension_attr_info(liaKey).version_id;
346: logString( statementLogLevel, procedureName, 'liaAttr ', liaAttr);
347: logString( statementLogLevel, procedureName, 'liaVers ', liaVers);
348: exception
349: when no_data_found then

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

356: --Get the attribute_id and version_id for the EXT_ACCOUNT_TYPE_CODE
357: declare
358: ataKey varchar2(100) := 'EXT_ACCOUNT_TYPE_CODE-SIGN';
359: begin
360: ataAttr := GCS_UTILITY_PKG.g_dimension_attr_info(ataKey).attribute_id;
361: ataVers := GCS_UTILITY_PKG.g_dimension_attr_info(ataKey).version_id;
362: logString( statementLogLevel, procedureName, 'ataAttr ', ataAttr);
363: logString( statementLogLevel, procedureName, 'ataVers ', ataVers);
364: exception

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

357: declare
358: ataKey varchar2(100) := 'EXT_ACCOUNT_TYPE_CODE-SIGN';
359: begin
360: ataAttr := GCS_UTILITY_PKG.g_dimension_attr_info(ataKey).attribute_id;
361: ataVers := GCS_UTILITY_PKG.g_dimension_attr_info(ataKey).version_id;
362: logString( statementLogLevel, procedureName, 'ataAttr ', ataAttr);
363: logString( statementLogLevel, procedureName, 'ataVers ', ataVers);
364: exception
365: when no_data_found then

Line 584: attr := GCS_UTILITY_PKG.g_dimension_attr_info(key).attribute_id;

580: AND g.entity_id = parentEntity;
581: begin
582:
583: --Get attribute_id and version_id (throws no_data_found if data error)
584: attr := GCS_UTILITY_PKG.g_dimension_attr_info(key).attribute_id;
585: vers := GCS_UTILITY_PKG.g_dimension_attr_info(key).version_id;
586: logString( statementLogLevel, procedureName, 'parameter',
587: 'attribute_id => ' ||attr);
588: logString( statementLogLevel, procedureName, 'parameter',

Line 585: vers := GCS_UTILITY_PKG.g_dimension_attr_info(key).version_id;

581: begin
582:
583: --Get attribute_id and version_id (throws no_data_found if data error)
584: attr := GCS_UTILITY_PKG.g_dimension_attr_info(key).attribute_id;
585: vers := GCS_UTILITY_PKG.g_dimension_attr_info(key).version_id;
586: logString( statementLogLevel, procedureName, 'parameter',
587: 'attribute_id => ' ||attr);
588: logString( statementLogLevel, procedureName, 'parameter',
589: 'version_id => ' || vers);