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

Line 63: GCS_UTILITY_PKG.init_dimension_info;

59: -- appl VARCHAR2(30);
60:
61: BEGIN
62: -- Initialize the dimension information.
63: GCS_UTILITY_PKG.init_dimension_info;
64:
65: -- Set the global variables determining which dimensions are used by GCS
66: g_felm_req := gcs_utility_pkg.get_dimension_required('FINANCIAL_ELEM_ID');
67: g_prd_req := gcs_utility_pkg.get_dimension_required('PRODUCT_ID');

Line 66: g_felm_req := gcs_utility_pkg.get_dimension_required('FINANCIAL_ELEM_ID');

62: -- Initialize the dimension information.
63: GCS_UTILITY_PKG.init_dimension_info;
64:
65: -- Set the global variables determining which dimensions are used by GCS
66: g_felm_req := gcs_utility_pkg.get_dimension_required('FINANCIAL_ELEM_ID');
67: g_prd_req := gcs_utility_pkg.get_dimension_required('PRODUCT_ID');
68: g_na_req := gcs_utility_pkg.get_dimension_required('NATURAL_ACCOUNT_ID');
69: g_chl_req := gcs_utility_pkg.get_dimension_required('CHANNEL_ID');
70: g_prj_req := gcs_utility_pkg.get_dimension_required('PROJECT_ID');

Line 67: g_prd_req := gcs_utility_pkg.get_dimension_required('PRODUCT_ID');

63: GCS_UTILITY_PKG.init_dimension_info;
64:
65: -- Set the global variables determining which dimensions are used by GCS
66: g_felm_req := gcs_utility_pkg.get_dimension_required('FINANCIAL_ELEM_ID');
67: g_prd_req := gcs_utility_pkg.get_dimension_required('PRODUCT_ID');
68: g_na_req := gcs_utility_pkg.get_dimension_required('NATURAL_ACCOUNT_ID');
69: g_chl_req := gcs_utility_pkg.get_dimension_required('CHANNEL_ID');
70: g_prj_req := gcs_utility_pkg.get_dimension_required('PROJECT_ID');
71: g_cst_req := gcs_utility_pkg.get_dimension_required('CUSTOMER_ID');

Line 68: g_na_req := gcs_utility_pkg.get_dimension_required('NATURAL_ACCOUNT_ID');

64:
65: -- Set the global variables determining which dimensions are used by GCS
66: g_felm_req := gcs_utility_pkg.get_dimension_required('FINANCIAL_ELEM_ID');
67: g_prd_req := gcs_utility_pkg.get_dimension_required('PRODUCT_ID');
68: g_na_req := gcs_utility_pkg.get_dimension_required('NATURAL_ACCOUNT_ID');
69: g_chl_req := gcs_utility_pkg.get_dimension_required('CHANNEL_ID');
70: g_prj_req := gcs_utility_pkg.get_dimension_required('PROJECT_ID');
71: g_cst_req := gcs_utility_pkg.get_dimension_required('CUSTOMER_ID');
72: g_tsk_req := gcs_utility_pkg.get_dimension_required('TASK_ID');

Line 69: g_chl_req := gcs_utility_pkg.get_dimension_required('CHANNEL_ID');

65: -- Set the global variables determining which dimensions are used by GCS
66: g_felm_req := gcs_utility_pkg.get_dimension_required('FINANCIAL_ELEM_ID');
67: g_prd_req := gcs_utility_pkg.get_dimension_required('PRODUCT_ID');
68: g_na_req := gcs_utility_pkg.get_dimension_required('NATURAL_ACCOUNT_ID');
69: g_chl_req := gcs_utility_pkg.get_dimension_required('CHANNEL_ID');
70: g_prj_req := gcs_utility_pkg.get_dimension_required('PROJECT_ID');
71: g_cst_req := gcs_utility_pkg.get_dimension_required('CUSTOMER_ID');
72: g_tsk_req := gcs_utility_pkg.get_dimension_required('TASK_ID');
73: g_ud1_req := gcs_utility_pkg.get_dimension_required('USER_DIM1_ID');

Line 70: g_prj_req := gcs_utility_pkg.get_dimension_required('PROJECT_ID');

66: g_felm_req := gcs_utility_pkg.get_dimension_required('FINANCIAL_ELEM_ID');
67: g_prd_req := gcs_utility_pkg.get_dimension_required('PRODUCT_ID');
68: g_na_req := gcs_utility_pkg.get_dimension_required('NATURAL_ACCOUNT_ID');
69: g_chl_req := gcs_utility_pkg.get_dimension_required('CHANNEL_ID');
70: g_prj_req := gcs_utility_pkg.get_dimension_required('PROJECT_ID');
71: g_cst_req := gcs_utility_pkg.get_dimension_required('CUSTOMER_ID');
72: g_tsk_req := gcs_utility_pkg.get_dimension_required('TASK_ID');
73: g_ud1_req := gcs_utility_pkg.get_dimension_required('USER_DIM1_ID');
74: g_ud2_req := gcs_utility_pkg.get_dimension_required('USER_DIM2_ID');

Line 71: g_cst_req := gcs_utility_pkg.get_dimension_required('CUSTOMER_ID');

67: g_prd_req := gcs_utility_pkg.get_dimension_required('PRODUCT_ID');
68: g_na_req := gcs_utility_pkg.get_dimension_required('NATURAL_ACCOUNT_ID');
69: g_chl_req := gcs_utility_pkg.get_dimension_required('CHANNEL_ID');
70: g_prj_req := gcs_utility_pkg.get_dimension_required('PROJECT_ID');
71: g_cst_req := gcs_utility_pkg.get_dimension_required('CUSTOMER_ID');
72: g_tsk_req := gcs_utility_pkg.get_dimension_required('TASK_ID');
73: g_ud1_req := gcs_utility_pkg.get_dimension_required('USER_DIM1_ID');
74: g_ud2_req := gcs_utility_pkg.get_dimension_required('USER_DIM2_ID');
75: g_ud3_req := gcs_utility_pkg.get_dimension_required('USER_DIM3_ID');

Line 72: g_tsk_req := gcs_utility_pkg.get_dimension_required('TASK_ID');

68: g_na_req := gcs_utility_pkg.get_dimension_required('NATURAL_ACCOUNT_ID');
69: g_chl_req := gcs_utility_pkg.get_dimension_required('CHANNEL_ID');
70: g_prj_req := gcs_utility_pkg.get_dimension_required('PROJECT_ID');
71: g_cst_req := gcs_utility_pkg.get_dimension_required('CUSTOMER_ID');
72: g_tsk_req := gcs_utility_pkg.get_dimension_required('TASK_ID');
73: g_ud1_req := gcs_utility_pkg.get_dimension_required('USER_DIM1_ID');
74: g_ud2_req := gcs_utility_pkg.get_dimension_required('USER_DIM2_ID');
75: g_ud3_req := gcs_utility_pkg.get_dimension_required('USER_DIM3_ID');
76: g_ud4_req := gcs_utility_pkg.get_dimension_required('USER_DIM4_ID');

Line 73: g_ud1_req := gcs_utility_pkg.get_dimension_required('USER_DIM1_ID');

69: g_chl_req := gcs_utility_pkg.get_dimension_required('CHANNEL_ID');
70: g_prj_req := gcs_utility_pkg.get_dimension_required('PROJECT_ID');
71: g_cst_req := gcs_utility_pkg.get_dimension_required('CUSTOMER_ID');
72: g_tsk_req := gcs_utility_pkg.get_dimension_required('TASK_ID');
73: g_ud1_req := gcs_utility_pkg.get_dimension_required('USER_DIM1_ID');
74: g_ud2_req := gcs_utility_pkg.get_dimension_required('USER_DIM2_ID');
75: g_ud3_req := gcs_utility_pkg.get_dimension_required('USER_DIM3_ID');
76: g_ud4_req := gcs_utility_pkg.get_dimension_required('USER_DIM4_ID');
77: g_ud5_req := gcs_utility_pkg.get_dimension_required('USER_DIM5_ID');

Line 74: g_ud2_req := gcs_utility_pkg.get_dimension_required('USER_DIM2_ID');

70: g_prj_req := gcs_utility_pkg.get_dimension_required('PROJECT_ID');
71: g_cst_req := gcs_utility_pkg.get_dimension_required('CUSTOMER_ID');
72: g_tsk_req := gcs_utility_pkg.get_dimension_required('TASK_ID');
73: g_ud1_req := gcs_utility_pkg.get_dimension_required('USER_DIM1_ID');
74: g_ud2_req := gcs_utility_pkg.get_dimension_required('USER_DIM2_ID');
75: g_ud3_req := gcs_utility_pkg.get_dimension_required('USER_DIM3_ID');
76: g_ud4_req := gcs_utility_pkg.get_dimension_required('USER_DIM4_ID');
77: g_ud5_req := gcs_utility_pkg.get_dimension_required('USER_DIM5_ID');
78: g_ud6_req := gcs_utility_pkg.get_dimension_required('USER_DIM6_ID');

Line 75: g_ud3_req := gcs_utility_pkg.get_dimension_required('USER_DIM3_ID');

71: g_cst_req := gcs_utility_pkg.get_dimension_required('CUSTOMER_ID');
72: g_tsk_req := gcs_utility_pkg.get_dimension_required('TASK_ID');
73: g_ud1_req := gcs_utility_pkg.get_dimension_required('USER_DIM1_ID');
74: g_ud2_req := gcs_utility_pkg.get_dimension_required('USER_DIM2_ID');
75: g_ud3_req := gcs_utility_pkg.get_dimension_required('USER_DIM3_ID');
76: g_ud4_req := gcs_utility_pkg.get_dimension_required('USER_DIM4_ID');
77: g_ud5_req := gcs_utility_pkg.get_dimension_required('USER_DIM5_ID');
78: g_ud6_req := gcs_utility_pkg.get_dimension_required('USER_DIM6_ID');
79: g_ud7_req := gcs_utility_pkg.get_dimension_required('USER_DIM7_ID');

Line 76: g_ud4_req := gcs_utility_pkg.get_dimension_required('USER_DIM4_ID');

72: g_tsk_req := gcs_utility_pkg.get_dimension_required('TASK_ID');
73: g_ud1_req := gcs_utility_pkg.get_dimension_required('USER_DIM1_ID');
74: g_ud2_req := gcs_utility_pkg.get_dimension_required('USER_DIM2_ID');
75: g_ud3_req := gcs_utility_pkg.get_dimension_required('USER_DIM3_ID');
76: g_ud4_req := gcs_utility_pkg.get_dimension_required('USER_DIM4_ID');
77: g_ud5_req := gcs_utility_pkg.get_dimension_required('USER_DIM5_ID');
78: g_ud6_req := gcs_utility_pkg.get_dimension_required('USER_DIM6_ID');
79: g_ud7_req := gcs_utility_pkg.get_dimension_required('USER_DIM7_ID');
80: g_ud8_req := gcs_utility_pkg.get_dimension_required('USER_DIM8_ID');

Line 77: g_ud5_req := gcs_utility_pkg.get_dimension_required('USER_DIM5_ID');

73: g_ud1_req := gcs_utility_pkg.get_dimension_required('USER_DIM1_ID');
74: g_ud2_req := gcs_utility_pkg.get_dimension_required('USER_DIM2_ID');
75: g_ud3_req := gcs_utility_pkg.get_dimension_required('USER_DIM3_ID');
76: g_ud4_req := gcs_utility_pkg.get_dimension_required('USER_DIM4_ID');
77: g_ud5_req := gcs_utility_pkg.get_dimension_required('USER_DIM5_ID');
78: g_ud6_req := gcs_utility_pkg.get_dimension_required('USER_DIM6_ID');
79: g_ud7_req := gcs_utility_pkg.get_dimension_required('USER_DIM7_ID');
80: g_ud8_req := gcs_utility_pkg.get_dimension_required('USER_DIM8_ID');
81: g_ud9_req := gcs_utility_pkg.get_dimension_required('USER_DIM9_ID');

Line 78: g_ud6_req := gcs_utility_pkg.get_dimension_required('USER_DIM6_ID');

74: g_ud2_req := gcs_utility_pkg.get_dimension_required('USER_DIM2_ID');
75: g_ud3_req := gcs_utility_pkg.get_dimension_required('USER_DIM3_ID');
76: g_ud4_req := gcs_utility_pkg.get_dimension_required('USER_DIM4_ID');
77: g_ud5_req := gcs_utility_pkg.get_dimension_required('USER_DIM5_ID');
78: g_ud6_req := gcs_utility_pkg.get_dimension_required('USER_DIM6_ID');
79: g_ud7_req := gcs_utility_pkg.get_dimension_required('USER_DIM7_ID');
80: g_ud8_req := gcs_utility_pkg.get_dimension_required('USER_DIM8_ID');
81: g_ud9_req := gcs_utility_pkg.get_dimension_required('USER_DIM9_ID');
82: g_ud10_req := gcs_utility_pkg.get_dimension_required('USER_DIM10_ID');

Line 79: g_ud7_req := gcs_utility_pkg.get_dimension_required('USER_DIM7_ID');

75: g_ud3_req := gcs_utility_pkg.get_dimension_required('USER_DIM3_ID');
76: g_ud4_req := gcs_utility_pkg.get_dimension_required('USER_DIM4_ID');
77: g_ud5_req := gcs_utility_pkg.get_dimension_required('USER_DIM5_ID');
78: g_ud6_req := gcs_utility_pkg.get_dimension_required('USER_DIM6_ID');
79: g_ud7_req := gcs_utility_pkg.get_dimension_required('USER_DIM7_ID');
80: g_ud8_req := gcs_utility_pkg.get_dimension_required('USER_DIM8_ID');
81: g_ud9_req := gcs_utility_pkg.get_dimension_required('USER_DIM9_ID');
82: g_ud10_req := gcs_utility_pkg.get_dimension_required('USER_DIM10_ID');
83:

Line 80: g_ud8_req := gcs_utility_pkg.get_dimension_required('USER_DIM8_ID');

76: g_ud4_req := gcs_utility_pkg.get_dimension_required('USER_DIM4_ID');
77: g_ud5_req := gcs_utility_pkg.get_dimension_required('USER_DIM5_ID');
78: g_ud6_req := gcs_utility_pkg.get_dimension_required('USER_DIM6_ID');
79: g_ud7_req := gcs_utility_pkg.get_dimension_required('USER_DIM7_ID');
80: g_ud8_req := gcs_utility_pkg.get_dimension_required('USER_DIM8_ID');
81: g_ud9_req := gcs_utility_pkg.get_dimension_required('USER_DIM9_ID');
82: g_ud10_req := gcs_utility_pkg.get_dimension_required('USER_DIM10_ID');
83:
84: -- Set the global variables determining which dimensions are used by FEM

Line 81: g_ud9_req := gcs_utility_pkg.get_dimension_required('USER_DIM9_ID');

77: g_ud5_req := gcs_utility_pkg.get_dimension_required('USER_DIM5_ID');
78: g_ud6_req := gcs_utility_pkg.get_dimension_required('USER_DIM6_ID');
79: g_ud7_req := gcs_utility_pkg.get_dimension_required('USER_DIM7_ID');
80: g_ud8_req := gcs_utility_pkg.get_dimension_required('USER_DIM8_ID');
81: g_ud9_req := gcs_utility_pkg.get_dimension_required('USER_DIM9_ID');
82: g_ud10_req := gcs_utility_pkg.get_dimension_required('USER_DIM10_ID');
83:
84: -- Set the global variables determining which dimensions are used by FEM
85: g_felm_fem_req := gcs_utility_pkg.get_fem_dim_required('FINANCIAL_ELEM_ID');

Line 82: g_ud10_req := gcs_utility_pkg.get_dimension_required('USER_DIM10_ID');

78: g_ud6_req := gcs_utility_pkg.get_dimension_required('USER_DIM6_ID');
79: g_ud7_req := gcs_utility_pkg.get_dimension_required('USER_DIM7_ID');
80: g_ud8_req := gcs_utility_pkg.get_dimension_required('USER_DIM8_ID');
81: g_ud9_req := gcs_utility_pkg.get_dimension_required('USER_DIM9_ID');
82: g_ud10_req := gcs_utility_pkg.get_dimension_required('USER_DIM10_ID');
83:
84: -- Set the global variables determining which dimensions are used by FEM
85: g_felm_fem_req := gcs_utility_pkg.get_fem_dim_required('FINANCIAL_ELEM_ID');
86: g_prd_fem_req := gcs_utility_pkg.get_fem_dim_required('PRODUCT_ID');

Line 85: g_felm_fem_req := gcs_utility_pkg.get_fem_dim_required('FINANCIAL_ELEM_ID');

81: g_ud9_req := gcs_utility_pkg.get_dimension_required('USER_DIM9_ID');
82: g_ud10_req := gcs_utility_pkg.get_dimension_required('USER_DIM10_ID');
83:
84: -- Set the global variables determining which dimensions are used by FEM
85: g_felm_fem_req := gcs_utility_pkg.get_fem_dim_required('FINANCIAL_ELEM_ID');
86: g_prd_fem_req := gcs_utility_pkg.get_fem_dim_required('PRODUCT_ID');
87: g_na_fem_req := gcs_utility_pkg.get_fem_dim_required('NATURAL_ACCOUNT_ID');
88: g_chl_fem_req := gcs_utility_pkg.get_fem_dim_required('CHANNEL_ID');
89: g_prj_fem_req := gcs_utility_pkg.get_fem_dim_required('PROJECT_ID');

Line 86: g_prd_fem_req := gcs_utility_pkg.get_fem_dim_required('PRODUCT_ID');

82: g_ud10_req := gcs_utility_pkg.get_dimension_required('USER_DIM10_ID');
83:
84: -- Set the global variables determining which dimensions are used by FEM
85: g_felm_fem_req := gcs_utility_pkg.get_fem_dim_required('FINANCIAL_ELEM_ID');
86: g_prd_fem_req := gcs_utility_pkg.get_fem_dim_required('PRODUCT_ID');
87: g_na_fem_req := gcs_utility_pkg.get_fem_dim_required('NATURAL_ACCOUNT_ID');
88: g_chl_fem_req := gcs_utility_pkg.get_fem_dim_required('CHANNEL_ID');
89: g_prj_fem_req := gcs_utility_pkg.get_fem_dim_required('PROJECT_ID');
90: g_cst_fem_req := gcs_utility_pkg.get_fem_dim_required('CUSTOMER_ID');

Line 87: g_na_fem_req := gcs_utility_pkg.get_fem_dim_required('NATURAL_ACCOUNT_ID');

83:
84: -- Set the global variables determining which dimensions are used by FEM
85: g_felm_fem_req := gcs_utility_pkg.get_fem_dim_required('FINANCIAL_ELEM_ID');
86: g_prd_fem_req := gcs_utility_pkg.get_fem_dim_required('PRODUCT_ID');
87: g_na_fem_req := gcs_utility_pkg.get_fem_dim_required('NATURAL_ACCOUNT_ID');
88: g_chl_fem_req := gcs_utility_pkg.get_fem_dim_required('CHANNEL_ID');
89: g_prj_fem_req := gcs_utility_pkg.get_fem_dim_required('PROJECT_ID');
90: g_cst_fem_req := gcs_utility_pkg.get_fem_dim_required('CUSTOMER_ID');
91: g_tsk_fem_req := gcs_utility_pkg.get_fem_dim_required('TASK_ID');

Line 88: g_chl_fem_req := gcs_utility_pkg.get_fem_dim_required('CHANNEL_ID');

84: -- Set the global variables determining which dimensions are used by FEM
85: g_felm_fem_req := gcs_utility_pkg.get_fem_dim_required('FINANCIAL_ELEM_ID');
86: g_prd_fem_req := gcs_utility_pkg.get_fem_dim_required('PRODUCT_ID');
87: g_na_fem_req := gcs_utility_pkg.get_fem_dim_required('NATURAL_ACCOUNT_ID');
88: g_chl_fem_req := gcs_utility_pkg.get_fem_dim_required('CHANNEL_ID');
89: g_prj_fem_req := gcs_utility_pkg.get_fem_dim_required('PROJECT_ID');
90: g_cst_fem_req := gcs_utility_pkg.get_fem_dim_required('CUSTOMER_ID');
91: g_tsk_fem_req := gcs_utility_pkg.get_fem_dim_required('TASK_ID');
92: g_ud1_fem_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID');

Line 89: g_prj_fem_req := gcs_utility_pkg.get_fem_dim_required('PROJECT_ID');

85: g_felm_fem_req := gcs_utility_pkg.get_fem_dim_required('FINANCIAL_ELEM_ID');
86: g_prd_fem_req := gcs_utility_pkg.get_fem_dim_required('PRODUCT_ID');
87: g_na_fem_req := gcs_utility_pkg.get_fem_dim_required('NATURAL_ACCOUNT_ID');
88: g_chl_fem_req := gcs_utility_pkg.get_fem_dim_required('CHANNEL_ID');
89: g_prj_fem_req := gcs_utility_pkg.get_fem_dim_required('PROJECT_ID');
90: g_cst_fem_req := gcs_utility_pkg.get_fem_dim_required('CUSTOMER_ID');
91: g_tsk_fem_req := gcs_utility_pkg.get_fem_dim_required('TASK_ID');
92: g_ud1_fem_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID');
93: g_ud2_fem_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID');

Line 90: g_cst_fem_req := gcs_utility_pkg.get_fem_dim_required('CUSTOMER_ID');

86: g_prd_fem_req := gcs_utility_pkg.get_fem_dim_required('PRODUCT_ID');
87: g_na_fem_req := gcs_utility_pkg.get_fem_dim_required('NATURAL_ACCOUNT_ID');
88: g_chl_fem_req := gcs_utility_pkg.get_fem_dim_required('CHANNEL_ID');
89: g_prj_fem_req := gcs_utility_pkg.get_fem_dim_required('PROJECT_ID');
90: g_cst_fem_req := gcs_utility_pkg.get_fem_dim_required('CUSTOMER_ID');
91: g_tsk_fem_req := gcs_utility_pkg.get_fem_dim_required('TASK_ID');
92: g_ud1_fem_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID');
93: g_ud2_fem_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID');
94: g_ud3_fem_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID');

Line 91: g_tsk_fem_req := gcs_utility_pkg.get_fem_dim_required('TASK_ID');

87: g_na_fem_req := gcs_utility_pkg.get_fem_dim_required('NATURAL_ACCOUNT_ID');
88: g_chl_fem_req := gcs_utility_pkg.get_fem_dim_required('CHANNEL_ID');
89: g_prj_fem_req := gcs_utility_pkg.get_fem_dim_required('PROJECT_ID');
90: g_cst_fem_req := gcs_utility_pkg.get_fem_dim_required('CUSTOMER_ID');
91: g_tsk_fem_req := gcs_utility_pkg.get_fem_dim_required('TASK_ID');
92: g_ud1_fem_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID');
93: g_ud2_fem_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID');
94: g_ud3_fem_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID');
95: g_ud4_fem_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID');

Line 92: g_ud1_fem_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID');

88: g_chl_fem_req := gcs_utility_pkg.get_fem_dim_required('CHANNEL_ID');
89: g_prj_fem_req := gcs_utility_pkg.get_fem_dim_required('PROJECT_ID');
90: g_cst_fem_req := gcs_utility_pkg.get_fem_dim_required('CUSTOMER_ID');
91: g_tsk_fem_req := gcs_utility_pkg.get_fem_dim_required('TASK_ID');
92: g_ud1_fem_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID');
93: g_ud2_fem_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID');
94: g_ud3_fem_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID');
95: g_ud4_fem_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID');
96: g_ud5_fem_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID');

Line 93: g_ud2_fem_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID');

89: g_prj_fem_req := gcs_utility_pkg.get_fem_dim_required('PROJECT_ID');
90: g_cst_fem_req := gcs_utility_pkg.get_fem_dim_required('CUSTOMER_ID');
91: g_tsk_fem_req := gcs_utility_pkg.get_fem_dim_required('TASK_ID');
92: g_ud1_fem_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID');
93: g_ud2_fem_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID');
94: g_ud3_fem_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID');
95: g_ud4_fem_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID');
96: g_ud5_fem_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID');
97: g_ud6_fem_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID');

Line 94: g_ud3_fem_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID');

90: g_cst_fem_req := gcs_utility_pkg.get_fem_dim_required('CUSTOMER_ID');
91: g_tsk_fem_req := gcs_utility_pkg.get_fem_dim_required('TASK_ID');
92: g_ud1_fem_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID');
93: g_ud2_fem_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID');
94: g_ud3_fem_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID');
95: g_ud4_fem_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID');
96: g_ud5_fem_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID');
97: g_ud6_fem_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID');
98: g_ud7_fem_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID');

Line 95: g_ud4_fem_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID');

91: g_tsk_fem_req := gcs_utility_pkg.get_fem_dim_required('TASK_ID');
92: g_ud1_fem_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID');
93: g_ud2_fem_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID');
94: g_ud3_fem_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID');
95: g_ud4_fem_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID');
96: g_ud5_fem_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID');
97: g_ud6_fem_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID');
98: g_ud7_fem_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID');
99: g_ud8_fem_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID');

Line 96: g_ud5_fem_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID');

92: g_ud1_fem_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID');
93: g_ud2_fem_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID');
94: g_ud3_fem_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID');
95: g_ud4_fem_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID');
96: g_ud5_fem_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID');
97: g_ud6_fem_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID');
98: g_ud7_fem_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID');
99: g_ud8_fem_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID');
100: g_ud9_fem_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM9_ID');

Line 97: g_ud6_fem_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID');

93: g_ud2_fem_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID');
94: g_ud3_fem_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID');
95: g_ud4_fem_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID');
96: g_ud5_fem_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID');
97: g_ud6_fem_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID');
98: g_ud7_fem_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID');
99: g_ud8_fem_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID');
100: g_ud9_fem_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM9_ID');
101: g_ud10_fem_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID');

Line 98: g_ud7_fem_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID');

94: g_ud3_fem_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID');
95: g_ud4_fem_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID');
96: g_ud5_fem_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID');
97: g_ud6_fem_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID');
98: g_ud7_fem_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID');
99: g_ud8_fem_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID');
100: g_ud9_fem_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM9_ID');
101: g_ud10_fem_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID');
102:

Line 99: g_ud8_fem_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID');

95: g_ud4_fem_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID');
96: g_ud5_fem_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID');
97: g_ud6_fem_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID');
98: g_ud7_fem_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID');
99: g_ud8_fem_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID');
100: g_ud9_fem_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM9_ID');
101: g_ud10_fem_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID');
102:
103: -- Get APPLSYS information. Needed for ad_ddl

Line 100: g_ud9_fem_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM9_ID');

96: g_ud5_fem_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID');
97: g_ud6_fem_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID');
98: g_ud7_fem_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID');
99: g_ud8_fem_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID');
100: g_ud9_fem_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM9_ID');
101: g_ud10_fem_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID');
102:
103: -- Get APPLSYS information. Needed for ad_ddl
104: IF NOT fnd_installation.get_app_info('FND', status, industry,

Line 101: g_ud10_fem_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID');

97: g_ud6_fem_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID');
98: g_ud7_fem_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID');
99: g_ud8_fem_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID');
100: g_ud9_fem_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM9_ID');
101: g_ud10_fem_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID');
102:
103: -- Get APPLSYS information. Needed for ad_ddl
104: IF NOT fnd_installation.get_app_info('FND', status, industry,
105: g_applsys_username) THEN

Line 300: default_val := GCS_UTILITY_PKG.get_default_value('FINANCIAL_ELEM_ID');

296: BEGIN
297: -- Go through each of the optional dimensions, and fill out accordingly
298:
299: IF (p_value_req = 'Y' AND g_felm_req = 'N') THEN
300: default_val := GCS_UTILITY_PKG.get_default_value('FINANCIAL_ELEM_ID');
301: the_rownum := build_fem_dimension_row( to_char(default_val), p_default_text, the_rownum, g_felm_fem_req);
302: ELSE
303: the_rownum := build_dimension_row(p_prefix||'FINANCIAL_ELEM_ID,'||p_suffix,p_default_text, the_rownum, g_felm_fem_req);
304: END IF;

Line 307: default_val := GCS_UTILITY_PKG.get_default_value('PRODUCT_ID');

303: the_rownum := build_dimension_row(p_prefix||'FINANCIAL_ELEM_ID,'||p_suffix,p_default_text, the_rownum, g_felm_fem_req);
304: END IF;
305:
306: IF (p_value_req = 'Y' AND g_prd_req = 'N') THEN
307: default_val := GCS_UTILITY_PKG.get_default_value('PRODUCT_ID');
308: the_rownum := build_fem_dimension_row( to_char(default_val), p_default_text, the_rownum, g_prd_fem_req);
309: ELSE
310: the_rownum := build_dimension_row(p_prefix||'PRODUCT_ID,'||p_suffix,p_default_text, the_rownum, g_prd_fem_req);
311: END IF;

Line 314: default_val := GCS_UTILITY_PKG.get_default_value('NATURAL_ACCOUNT_ID');

310: the_rownum := build_dimension_row(p_prefix||'PRODUCT_ID,'||p_suffix,p_default_text, the_rownum, g_prd_fem_req);
311: END IF;
312:
313: IF (p_value_req = 'Y' AND g_na_req = 'N') THEN
314: default_val := GCS_UTILITY_PKG.get_default_value('NATURAL_ACCOUNT_ID');
315: the_rownum := build_fem_dimension_row(to_char(default_val), p_default_text, the_rownum, g_na_fem_req);
316: ELSE
317: the_rownum := build_dimension_row(p_prefix||'NATURAL_ACCOUNT_ID,'||p_suffix,p_default_text, the_rownum, g_na_fem_req);
318: END IF;

Line 322: default_val := GCS_UTILITY_PKG.get_default_value('CHANNEL_ID');

318: END IF;
319:
320:
321: IF (p_value_req = 'Y' AND g_chl_req = 'N') THEN
322: default_val := GCS_UTILITY_PKG.get_default_value('CHANNEL_ID');
323: the_rownum := build_fem_dimension_row(to_char(default_val), p_default_text, the_rownum, g_chl_fem_req);
324: ELSE
325: the_rownum := build_dimension_row(p_prefix||'CHANNEL_ID,'||p_suffix,
326: p_default_text, the_rownum, g_chl_fem_req);

Line 330: default_val := GCS_UTILITY_PKG.get_default_value('PROJECT_ID');

326: p_default_text, the_rownum, g_chl_fem_req);
327: END IF;
328:
329: IF (p_value_req = 'Y' AND g_prj_req = 'N') THEN
330: default_val := GCS_UTILITY_PKG.get_default_value('PROJECT_ID');
331: the_rownum := build_fem_dimension_row(to_char(default_val), p_default_text, the_rownum, g_prj_fem_req);
332: ELSE
333: the_rownum := build_dimension_row(p_prefix||'PROJECT_ID,'||p_suffix,
334: p_default_text, the_rownum, g_prj_fem_req);

Line 338: default_val := GCS_UTILITY_PKG.get_default_value('CUSTOMER_ID');

334: p_default_text, the_rownum, g_prj_fem_req);
335: END IF;
336:
337: IF (p_value_req = 'Y' AND g_cst_req = 'N') THEN
338: default_val := GCS_UTILITY_PKG.get_default_value('CUSTOMER_ID');
339: the_rownum := build_fem_dimension_row(to_char(default_val), p_default_text, the_rownum, g_cst_fem_req);
340: ELSE
341: the_rownum := build_dimension_row(p_prefix||'CUSTOMER_ID,'||p_suffix,
342: p_default_text, the_rownum,g_cst_fem_req);

Line 346: default_val := GCS_UTILITY_PKG.get_default_value('TASK_ID');

342: p_default_text, the_rownum,g_cst_fem_req);
343: END IF;
344:
345: IF (p_value_req = 'Y' AND g_tsk_req = 'N') THEN
346: default_val := GCS_UTILITY_PKG.get_default_value('TASK_ID');
347: the_rownum := build_fem_dimension_row(to_char(default_val), p_default_text, the_rownum, g_tsk_fem_req);
348: ELSE
349: the_rownum := build_dimension_row(p_prefix||'TASK_ID,'||p_suffix,
350: p_default_text, the_rownum, g_tsk_fem_req);

Line 354: default_val := GCS_UTILITY_PKG.get_default_value('USER_DIM1_ID');

350: p_default_text, the_rownum, g_tsk_fem_req);
351: END IF;
352:
353: IF (p_value_req = 'Y' AND g_ud1_req = 'N') THEN
354: default_val := GCS_UTILITY_PKG.get_default_value('USER_DIM1_ID');
355: the_rownum := build_fem_dimension_row(to_char(default_val), p_default_text, the_rownum, g_ud1_fem_req);
356: ELSE
357: the_rownum := build_dimension_row(p_prefix||'USER_DIM1_ID,'||p_suffix,
358: p_default_text, the_rownum, g_ud1_fem_req);

Line 362: default_val := GCS_UTILITY_PKG.get_default_value('USER_DIM2_ID');

358: p_default_text, the_rownum, g_ud1_fem_req);
359: END IF;
360:
361: IF (p_value_req = 'Y' AND g_ud2_req = 'N') THEN
362: default_val := GCS_UTILITY_PKG.get_default_value('USER_DIM2_ID');
363: the_rownum := build_fem_dimension_row(to_char(default_val), p_default_text, the_rownum, g_ud2_fem_req);
364: ELSE
365: the_rownum := build_dimension_row(p_prefix||'USER_DIM2_ID,'||p_suffix,
366: p_default_text, the_rownum, g_ud2_fem_req);

Line 370: default_val := GCS_UTILITY_PKG.get_default_value('USER_DIM3_ID');

366: p_default_text, the_rownum, g_ud2_fem_req);
367: END IF;
368:
369: IF (p_value_req = 'Y' AND g_ud3_req = 'N') THEN
370: default_val := GCS_UTILITY_PKG.get_default_value('USER_DIM3_ID');
371: the_rownum := build_fem_dimension_row(to_char(default_val), p_default_text, the_rownum, g_ud3_fem_req);
372: ELSE
373: the_rownum := build_dimension_row(p_prefix||'USER_DIM3_ID,'||p_suffix,
374: p_default_text, the_rownum, g_ud3_fem_req);

Line 378: default_val := GCS_UTILITY_PKG.get_default_value('USER_DIM4_ID');

374: p_default_text, the_rownum, g_ud3_fem_req);
375: END IF;
376:
377: IF (p_value_req = 'Y' AND g_ud4_req = 'N') THEN
378: default_val := GCS_UTILITY_PKG.get_default_value('USER_DIM4_ID');
379: the_rownum := build_fem_dimension_row(to_char(default_val), p_default_text, the_rownum, g_ud4_fem_req);
380: ELSE
381: the_rownum := build_dimension_row(p_prefix||'USER_DIM4_ID,'||p_suffix,
382: p_default_text, the_rownum, g_ud4_fem_req);

Line 386: default_val := GCS_UTILITY_PKG.get_default_value('USER_DIM5_ID');

382: p_default_text, the_rownum, g_ud4_fem_req);
383: END IF;
384:
385: IF (p_value_req = 'Y' AND g_ud5_req = 'N') THEN
386: default_val := GCS_UTILITY_PKG.get_default_value('USER_DIM5_ID');
387: the_rownum := build_fem_dimension_row(to_char(default_val), p_default_text, the_rownum, g_ud5_fem_req);
388: ELSE
389: the_rownum := build_dimension_row(p_prefix||'USER_DIM5_ID,'||p_suffix,
390: p_default_text, the_rownum, g_ud5_fem_req);

Line 394: default_val := GCS_UTILITY_PKG.get_default_value('USER_DIM6_ID');

390: p_default_text, the_rownum, g_ud5_fem_req);
391: END IF;
392:
393: IF (p_value_req = 'Y' AND g_ud6_req = 'N') THEN
394: default_val := GCS_UTILITY_PKG.get_default_value('USER_DIM6_ID');
395: the_rownum := build_fem_dimension_row(to_char(default_val), p_default_text, the_rownum, g_ud6_fem_req);
396: ELSE
397: the_rownum := build_dimension_row(p_prefix||'USER_DIM6_ID,'||p_suffix,
398: p_default_text, the_rownum, g_ud6_fem_req);

Line 402: default_val := GCS_UTILITY_PKG.get_default_value('USER_DIM7_ID');

398: p_default_text, the_rownum, g_ud6_fem_req);
399: END IF;
400:
401: IF (p_value_req = 'Y' AND g_ud7_req = 'N') THEN
402: default_val := GCS_UTILITY_PKG.get_default_value('USER_DIM7_ID');
403: the_rownum := build_fem_dimension_row(to_char(default_val), p_default_text, the_rownum, g_ud7_fem_req);
404: ELSE
405: the_rownum := build_dimension_row(p_prefix||'USER_DIM7_ID,'||p_suffix,
406: p_default_text, the_rownum, g_ud7_fem_req);

Line 410: default_val := GCS_UTILITY_PKG.get_default_value('USER_DIM8_ID');

406: p_default_text, the_rownum, g_ud7_fem_req);
407: END IF;
408:
409: IF (p_value_req = 'Y' AND g_ud8_req = 'N') THEN
410: default_val := GCS_UTILITY_PKG.get_default_value('USER_DIM8_ID');
411: the_rownum := build_fem_dimension_row(to_char(default_val), p_default_text, the_rownum, g_ud8_fem_req);
412: ELSE
413: the_rownum := build_dimension_row(p_prefix||'USER_DIM8_ID,'||p_suffix,
414: p_default_text, the_rownum, g_ud8_fem_req);

Line 418: default_val := GCS_UTILITY_PKG.get_default_value('USER_DIM9_ID');

414: p_default_text, the_rownum, g_ud8_fem_req);
415: END IF;
416:
417: IF (p_value_req = 'Y' AND g_ud9_req = 'N') THEN
418: default_val := GCS_UTILITY_PKG.get_default_value('USER_DIM9_ID');
419: the_rownum := build_fem_dimension_row(to_char(default_val), p_default_text, the_rownum, g_ud9_fem_req);
420: ELSE
421: the_rownum := build_dimension_row(p_prefix||'USER_DIM9_ID,'||p_suffix,
422: p_default_text, the_rownum, g_ud9_fem_req);

Line 426: default_val := GCS_UTILITY_PKG.get_default_value('USER_DIM10_ID');

422: p_default_text, the_rownum, g_ud9_fem_req);
423: END IF;
424:
425: IF (p_value_req = 'Y' AND g_ud10_req = 'N') THEN
426: default_val := GCS_UTILITY_PKG.get_default_value('USER_DIM10_ID');
427: the_rownum := build_fem_dimension_row(to_char(default_val), p_default_text, the_rownum, g_ud10_fem_req);
428: ELSE
429: the_rownum := build_dimension_row(p_prefix||'USER_DIM10_ID,'||p_suffix,
430: p_default_text, the_rownum, g_ud10_fem_req);