DBA Data[Home] [Help]

APPS.GCS_DYN_TB_VIEW_PKG dependencies on GCS_UTILITY_PKG

Line 182: l_fe_req := gcs_utility_pkg.get_fem_dim_required('FINANCIAL_ELEM_ID');

178: module := 'CREATE_VIEW';
179: module_log_write(module, g_module_enter);
180:
181: -- Set the global variables determining which dimensions are used
182: l_fe_req := gcs_utility_pkg.get_fem_dim_required('FINANCIAL_ELEM_ID');
183: l_pd_req := gcs_utility_pkg.get_fem_dim_required('PRODUCT_ID');
184: l_na_req := gcs_utility_pkg.get_fem_dim_required('NATURAL_ACCOUNT_ID');
185: l_ch_req := gcs_utility_pkg.get_fem_dim_required('CHANNEL_ID');
186: l_pj_req := gcs_utility_pkg.get_fem_dim_required('PROJECT_ID');

Line 183: l_pd_req := gcs_utility_pkg.get_fem_dim_required('PRODUCT_ID');

179: module_log_write(module, g_module_enter);
180:
181: -- Set the global variables determining which dimensions are used
182: l_fe_req := gcs_utility_pkg.get_fem_dim_required('FINANCIAL_ELEM_ID');
183: l_pd_req := gcs_utility_pkg.get_fem_dim_required('PRODUCT_ID');
184: l_na_req := gcs_utility_pkg.get_fem_dim_required('NATURAL_ACCOUNT_ID');
185: l_ch_req := gcs_utility_pkg.get_fem_dim_required('CHANNEL_ID');
186: l_pj_req := gcs_utility_pkg.get_fem_dim_required('PROJECT_ID');
187: l_cu_req := gcs_utility_pkg.get_fem_dim_required('CUSTOMER_ID');

Line 184: l_na_req := gcs_utility_pkg.get_fem_dim_required('NATURAL_ACCOUNT_ID');

180:
181: -- Set the global variables determining which dimensions are used
182: l_fe_req := gcs_utility_pkg.get_fem_dim_required('FINANCIAL_ELEM_ID');
183: l_pd_req := gcs_utility_pkg.get_fem_dim_required('PRODUCT_ID');
184: l_na_req := gcs_utility_pkg.get_fem_dim_required('NATURAL_ACCOUNT_ID');
185: l_ch_req := gcs_utility_pkg.get_fem_dim_required('CHANNEL_ID');
186: l_pj_req := gcs_utility_pkg.get_fem_dim_required('PROJECT_ID');
187: l_cu_req := gcs_utility_pkg.get_fem_dim_required('CUSTOMER_ID');
188: l_ta_req := gcs_utility_pkg.get_fem_dim_required('TASK_ID');

Line 185: l_ch_req := gcs_utility_pkg.get_fem_dim_required('CHANNEL_ID');

181: -- Set the global variables determining which dimensions are used
182: l_fe_req := gcs_utility_pkg.get_fem_dim_required('FINANCIAL_ELEM_ID');
183: l_pd_req := gcs_utility_pkg.get_fem_dim_required('PRODUCT_ID');
184: l_na_req := gcs_utility_pkg.get_fem_dim_required('NATURAL_ACCOUNT_ID');
185: l_ch_req := gcs_utility_pkg.get_fem_dim_required('CHANNEL_ID');
186: l_pj_req := gcs_utility_pkg.get_fem_dim_required('PROJECT_ID');
187: l_cu_req := gcs_utility_pkg.get_fem_dim_required('CUSTOMER_ID');
188: l_ta_req := gcs_utility_pkg.get_fem_dim_required('TASK_ID');
189: l_ud1_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID');

Line 186: l_pj_req := gcs_utility_pkg.get_fem_dim_required('PROJECT_ID');

182: l_fe_req := gcs_utility_pkg.get_fem_dim_required('FINANCIAL_ELEM_ID');
183: l_pd_req := gcs_utility_pkg.get_fem_dim_required('PRODUCT_ID');
184: l_na_req := gcs_utility_pkg.get_fem_dim_required('NATURAL_ACCOUNT_ID');
185: l_ch_req := gcs_utility_pkg.get_fem_dim_required('CHANNEL_ID');
186: l_pj_req := gcs_utility_pkg.get_fem_dim_required('PROJECT_ID');
187: l_cu_req := gcs_utility_pkg.get_fem_dim_required('CUSTOMER_ID');
188: l_ta_req := gcs_utility_pkg.get_fem_dim_required('TASK_ID');
189: l_ud1_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID');
190: l_ud2_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID');

Line 187: l_cu_req := gcs_utility_pkg.get_fem_dim_required('CUSTOMER_ID');

183: l_pd_req := gcs_utility_pkg.get_fem_dim_required('PRODUCT_ID');
184: l_na_req := gcs_utility_pkg.get_fem_dim_required('NATURAL_ACCOUNT_ID');
185: l_ch_req := gcs_utility_pkg.get_fem_dim_required('CHANNEL_ID');
186: l_pj_req := gcs_utility_pkg.get_fem_dim_required('PROJECT_ID');
187: l_cu_req := gcs_utility_pkg.get_fem_dim_required('CUSTOMER_ID');
188: l_ta_req := gcs_utility_pkg.get_fem_dim_required('TASK_ID');
189: l_ud1_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID');
190: l_ud2_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID');
191: l_ud3_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID');

Line 188: l_ta_req := gcs_utility_pkg.get_fem_dim_required('TASK_ID');

184: l_na_req := gcs_utility_pkg.get_fem_dim_required('NATURAL_ACCOUNT_ID');
185: l_ch_req := gcs_utility_pkg.get_fem_dim_required('CHANNEL_ID');
186: l_pj_req := gcs_utility_pkg.get_fem_dim_required('PROJECT_ID');
187: l_cu_req := gcs_utility_pkg.get_fem_dim_required('CUSTOMER_ID');
188: l_ta_req := gcs_utility_pkg.get_fem_dim_required('TASK_ID');
189: l_ud1_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID');
190: l_ud2_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID');
191: l_ud3_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID');
192: l_ud4_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID');

Line 189: l_ud1_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID');

185: l_ch_req := gcs_utility_pkg.get_fem_dim_required('CHANNEL_ID');
186: l_pj_req := gcs_utility_pkg.get_fem_dim_required('PROJECT_ID');
187: l_cu_req := gcs_utility_pkg.get_fem_dim_required('CUSTOMER_ID');
188: l_ta_req := gcs_utility_pkg.get_fem_dim_required('TASK_ID');
189: l_ud1_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID');
190: l_ud2_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID');
191: l_ud3_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID');
192: l_ud4_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID');
193: l_ud5_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID');

Line 190: l_ud2_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID');

186: l_pj_req := gcs_utility_pkg.get_fem_dim_required('PROJECT_ID');
187: l_cu_req := gcs_utility_pkg.get_fem_dim_required('CUSTOMER_ID');
188: l_ta_req := gcs_utility_pkg.get_fem_dim_required('TASK_ID');
189: l_ud1_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID');
190: l_ud2_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID');
191: l_ud3_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID');
192: l_ud4_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID');
193: l_ud5_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID');
194: l_ud6_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID');

Line 191: l_ud3_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID');

187: l_cu_req := gcs_utility_pkg.get_fem_dim_required('CUSTOMER_ID');
188: l_ta_req := gcs_utility_pkg.get_fem_dim_required('TASK_ID');
189: l_ud1_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID');
190: l_ud2_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID');
191: l_ud3_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID');
192: l_ud4_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID');
193: l_ud5_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID');
194: l_ud6_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID');
195: l_ud7_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID');

Line 192: l_ud4_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID');

188: l_ta_req := gcs_utility_pkg.get_fem_dim_required('TASK_ID');
189: l_ud1_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID');
190: l_ud2_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID');
191: l_ud3_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID');
192: l_ud4_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID');
193: l_ud5_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID');
194: l_ud6_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID');
195: l_ud7_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID');
196: l_ud8_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID');

Line 193: l_ud5_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID');

189: l_ud1_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID');
190: l_ud2_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID');
191: l_ud3_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID');
192: l_ud4_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID');
193: l_ud5_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID');
194: l_ud6_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID');
195: l_ud7_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID');
196: l_ud8_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID');
197: l_ud9_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM9_ID');

Line 194: l_ud6_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID');

190: l_ud2_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID');
191: l_ud3_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID');
192: l_ud4_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID');
193: l_ud5_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID');
194: l_ud6_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID');
195: l_ud7_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID');
196: l_ud8_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID');
197: l_ud9_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM9_ID');
198: l_ud10_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID');

Line 195: l_ud7_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID');

191: l_ud3_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID');
192: l_ud4_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID');
193: l_ud5_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID');
194: l_ud6_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID');
195: l_ud7_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID');
196: l_ud8_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID');
197: l_ud9_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM9_ID');
198: l_ud10_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID');
199:

Line 196: l_ud8_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID');

192: l_ud4_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID');
193: l_ud5_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID');
194: l_ud6_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID');
195: l_ud7_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID');
196: l_ud8_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID');
197: l_ud9_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM9_ID');
198: l_ud10_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID');
199:
200: -- Get APPLSYS information. Needed for ad_ddl

Line 197: l_ud9_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM9_ID');

193: l_ud5_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID');
194: l_ud6_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID');
195: l_ud7_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID');
196: l_ud8_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID');
197: l_ud9_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM9_ID');
198: l_ud10_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID');
199:
200: -- Get APPLSYS information. Needed for ad_ddl
201: IF NOT fnd_installation.get_app_info('FND', status, industry, appl) THEN

Line 198: l_ud10_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID');

194: l_ud6_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID');
195: l_ud7_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID');
196: l_ud8_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID');
197: l_ud9_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM9_ID');
198: l_ud10_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID');
199:
200: -- Get APPLSYS information. Needed for ad_ddl
201: IF NOT fnd_installation.get_app_info('FND', status, industry, appl) THEN
202: raise gcs_dyn_tb_applsys_not_found;