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

Line 166: gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-GLOBAL_VS_COMBO').attribute_id;

162: p_currency_code IN VARCHAR2)
163: IS PRAGMA AUTONOMOUS_TRANSACTION;
164: l_line_item_vs_id NUMBER;
165: l_ledger_vs_combo_attr NUMBER(15) :=
166: gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-GLOBAL_VS_COMBO').attribute_id;
167: l_ledger_vs_combo_version NUMBER(15) :=
168: gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-GLOBAL_VS_COMBO').version_id;
169: l_line_item_type_attr NUMBER(15) :=
170: gcs_utility_pkg.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').attribute_id;

Line 168: gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-GLOBAL_VS_COMBO').version_id;

164: l_line_item_vs_id NUMBER;
165: l_ledger_vs_combo_attr NUMBER(15) :=
166: gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-GLOBAL_VS_COMBO').attribute_id;
167: l_ledger_vs_combo_version NUMBER(15) :=
168: gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-GLOBAL_VS_COMBO').version_id;
169: l_line_item_type_attr NUMBER(15) :=
170: gcs_utility_pkg.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').attribute_id;
171: l_line_item_type_version NUMBER(15) :=
172: gcs_utility_pkg.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').version_id;

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

166: gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-GLOBAL_VS_COMBO').attribute_id;
167: l_ledger_vs_combo_version NUMBER(15) :=
168: gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-GLOBAL_VS_COMBO').version_id;
169: l_line_item_type_attr NUMBER(15) :=
170: gcs_utility_pkg.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').attribute_id;
171: l_line_item_type_version NUMBER(15) :=
172: gcs_utility_pkg.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').version_id;
173: l_acct_type_attr NUMBER(15) :=
174: gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').attribute_id;

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

168: gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-GLOBAL_VS_COMBO').version_id;
169: l_line_item_type_attr NUMBER(15) :=
170: gcs_utility_pkg.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').attribute_id;
171: l_line_item_type_version NUMBER(15) :=
172: gcs_utility_pkg.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').version_id;
173: l_acct_type_attr NUMBER(15) :=
174: gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').attribute_id;
175: l_acct_type_version NUMBER(15) :=
176: gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').version_id;

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

170: gcs_utility_pkg.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').attribute_id;
171: l_line_item_type_version NUMBER(15) :=
172: gcs_utility_pkg.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').version_id;
173: l_acct_type_attr NUMBER(15) :=
174: gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').attribute_id;
175: l_acct_type_version NUMBER(15) :=
176: gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').version_id;
177:
178: BEGIN

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

172: gcs_utility_pkg.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').version_id;
173: l_acct_type_attr NUMBER(15) :=
174: gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').attribute_id;
175: l_acct_type_version NUMBER(15) :=
176: gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').version_id;
177:
178: BEGIN
179:
180: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

Line 303: AND fea.attribute_id = gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-LEDGER_ID').attribute_id

299: FROM fem_entities_attr fea,
300: gcs_data_sub_dtls gdsd
301: WHERE gdsd.load_id = p_load_id
302: AND fea.entity_id = gdsd.entity_id
303: AND fea.attribute_id = gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-LEDGER_ID').attribute_id
304: AND fea.version_id = gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-LEDGER_ID').version_id;
305:
306:
307: SELECT fgvcd.value_set_id,

Line 304: AND fea.version_id = gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-LEDGER_ID').version_id;

300: gcs_data_sub_dtls gdsd
301: WHERE gdsd.load_id = p_load_id
302: AND fea.entity_id = gdsd.entity_id
303: AND fea.attribute_id = gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-LEDGER_ID').attribute_id
304: AND fea.version_id = gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-LEDGER_ID').version_id;
305:
306:
307: SELECT fgvcd.value_set_id,
308: fxd.member_display_code_col,

Line 317: WHERE gcs_utility_pkg.get_fem_dim_required(fxd.MEMBER_COL) = 'Y'

313: FROM fem_global_vs_combo_defs fgvcd,
314: fem_ledgers_attr fla,
315: fem_xdim_dimensions fxd,
316: fem_dimensions_tl fdt
317: WHERE gcs_utility_pkg.get_fem_dim_required(fxd.MEMBER_COL) = 'Y'
318: AND global_vs_combo_id = fla.dim_attribute_numeric_member
319: AND fla.ledger_id = l_ledger_id
320: AND fla.attribute_id = gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-GLOBAL_VS_COMBO').attribute_id
321: AND fla.version_id = gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-GLOBAL_VS_COMBO').version_id

Line 320: AND fla.attribute_id = gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-GLOBAL_VS_COMBO').attribute_id

316: fem_dimensions_tl fdt
317: WHERE gcs_utility_pkg.get_fem_dim_required(fxd.MEMBER_COL) = 'Y'
318: AND global_vs_combo_id = fla.dim_attribute_numeric_member
319: AND fla.ledger_id = l_ledger_id
320: AND fla.attribute_id = gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-GLOBAL_VS_COMBO').attribute_id
321: AND fla.version_id = gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-GLOBAL_VS_COMBO').version_id
322: AND fgvcd.dimension_id = fxd.dimension_id
323: AND fxd.member_col IN ('COMPANY_COST_CENTER_ORG_ID','FINANCIAL_ELEM_ID','PRODUCT_ID','NATURAL_ACCOUNT_ID','CHANNEL_ID',
324: 'LINE_ITEM_ID','PROJECT_ID','CUSTOMER_ID','TASK_ID','USER_DIM1_ID','USER_DIM10_ID',

Line 321: AND fla.version_id = gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-GLOBAL_VS_COMBO').version_id

317: WHERE gcs_utility_pkg.get_fem_dim_required(fxd.MEMBER_COL) = 'Y'
318: AND global_vs_combo_id = fla.dim_attribute_numeric_member
319: AND fla.ledger_id = l_ledger_id
320: AND fla.attribute_id = gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-GLOBAL_VS_COMBO').attribute_id
321: AND fla.version_id = gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-GLOBAL_VS_COMBO').version_id
322: AND fgvcd.dimension_id = fxd.dimension_id
323: AND fxd.member_col IN ('COMPANY_COST_CENTER_ORG_ID','FINANCIAL_ELEM_ID','PRODUCT_ID','NATURAL_ACCOUNT_ID','CHANNEL_ID',
324: 'LINE_ITEM_ID','PROJECT_ID','CUSTOMER_ID','TASK_ID','USER_DIM1_ID','USER_DIM10_ID',
325: 'USER_DIM2_ID','USER_DIM3_ID', 'USER_DIM4_ID','USER_DIM5_ID',