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');
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');
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');
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');
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');
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');
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');
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');
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');
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');
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');
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');
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');
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:
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
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
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;