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

Line 64: l_dim_info gcs_utility_pkg.t_hash_gcs_dimension_info :=

60: END add_clause_to_list;
61:
62: PROCEDURE build_where_clause_list (p_rownum IN OUT NOCOPY NUMBER) IS
63:
64: l_dim_info gcs_utility_pkg.t_hash_gcs_dimension_info :=
65: gcs_utility_pkg.g_gcs_dimension_info;
66:
67: BEGIN
68: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('FINANCIAL_ELEM_ID'), 'FINANCIAL_ELEM_ID',

Line 65: gcs_utility_pkg.g_gcs_dimension_info;

61:
62: PROCEDURE build_where_clause_list (p_rownum IN OUT NOCOPY NUMBER) IS
63:
64: l_dim_info gcs_utility_pkg.t_hash_gcs_dimension_info :=
65: gcs_utility_pkg.g_gcs_dimension_info;
66:
67: BEGIN
68: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('FINANCIAL_ELEM_ID'), 'FINANCIAL_ELEM_ID',
69: 'FINANCIAL_ELEM_DISPLAY_CODE',

Line 68: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('FINANCIAL_ELEM_ID'), 'FINANCIAL_ELEM_ID',

64: l_dim_info gcs_utility_pkg.t_hash_gcs_dimension_info :=
65: gcs_utility_pkg.g_gcs_dimension_info;
66:
67: BEGIN
68: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('FINANCIAL_ELEM_ID'), 'FINANCIAL_ELEM_ID',
69: 'FINANCIAL_ELEM_DISPLAY_CODE',
70: 'ffeb',
71: p_rownum);
72: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('PRODUCT_ID'), 'PRODUCT_ID',

Line 72: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('PRODUCT_ID'), 'PRODUCT_ID',

68: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('FINANCIAL_ELEM_ID'), 'FINANCIAL_ELEM_ID',
69: 'FINANCIAL_ELEM_DISPLAY_CODE',
70: 'ffeb',
71: p_rownum);
72: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('PRODUCT_ID'), 'PRODUCT_ID',
73: 'PRODUCT_DISPLAY_CODE',
74: 'fpb',
75: p_rownum);
76: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('NATURAL_ACCOUNT_ID'), 'NATURAL_ACCOUNT_ID',

Line 76: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('NATURAL_ACCOUNT_ID'), 'NATURAL_ACCOUNT_ID',

72: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('PRODUCT_ID'), 'PRODUCT_ID',
73: 'PRODUCT_DISPLAY_CODE',
74: 'fpb',
75: p_rownum);
76: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('NATURAL_ACCOUNT_ID'), 'NATURAL_ACCOUNT_ID',
77: 'NATURAL_ACCOUNT_DISPLAY_CODE',
78: 'fnab', p_rownum);
79: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('CHANNEL_ID'), 'CHANNEL_ID',
80: 'CHANNEL_DISPLAY_CODE',

Line 79: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('CHANNEL_ID'), 'CHANNEL_ID',

75: p_rownum);
76: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('NATURAL_ACCOUNT_ID'), 'NATURAL_ACCOUNT_ID',
77: 'NATURAL_ACCOUNT_DISPLAY_CODE',
78: 'fnab', p_rownum);
79: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('CHANNEL_ID'), 'CHANNEL_ID',
80: 'CHANNEL_DISPLAY_CODE',
81: 'fchb', p_rownum);
82: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('PROJECT_ID'), 'PROJECT_ID',
83: 'PROJECT_DISPLAY_CODE',

Line 82: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('PROJECT_ID'), 'PROJECT_ID',

78: 'fnab', p_rownum);
79: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('CHANNEL_ID'), 'CHANNEL_ID',
80: 'CHANNEL_DISPLAY_CODE',
81: 'fchb', p_rownum);
82: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('PROJECT_ID'), 'PROJECT_ID',
83: 'PROJECT_DISPLAY_CODE',
84: 'fpjb', p_rownum);
85: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('CUSTOMER_ID'), 'CUSTOMER_ID',
86: 'CUSTOMER_DISPLAY_CODE',

Line 85: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('CUSTOMER_ID'), 'CUSTOMER_ID',

81: 'fchb', p_rownum);
82: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('PROJECT_ID'), 'PROJECT_ID',
83: 'PROJECT_DISPLAY_CODE',
84: 'fpjb', p_rownum);
85: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('CUSTOMER_ID'), 'CUSTOMER_ID',
86: 'CUSTOMER_DISPLAY_CODE',
87: 'fcb', p_rownum);
88: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('TASK_ID'), 'TASK_ID',
89: 'TASK_DISPLAY_CODE',

Line 88: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('TASK_ID'), 'TASK_ID',

84: 'fpjb', p_rownum);
85: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('CUSTOMER_ID'), 'CUSTOMER_ID',
86: 'CUSTOMER_DISPLAY_CODE',
87: 'fcb', p_rownum);
88: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('TASK_ID'), 'TASK_ID',
89: 'TASK_DISPLAY_CODE',
90: 'ftb', p_rownum);
91: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID') = 'Y') THEN
92: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID'), l_dim_info('USER_DIM1_ID').dim_member_col,

Line 91: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID') = 'Y') THEN

87: 'fcb', p_rownum);
88: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('TASK_ID'), 'TASK_ID',
89: 'TASK_DISPLAY_CODE',
90: 'ftb', p_rownum);
91: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID') = 'Y') THEN
92: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID'), l_dim_info('USER_DIM1_ID').dim_member_col,
93: l_dim_info('USER_DIM1_ID').dim_member_display_code,
94: 'fud1', p_rownum);
95: END IF;

Line 92: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID'), l_dim_info('USER_DIM1_ID').dim_member_col,

88: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('TASK_ID'), 'TASK_ID',
89: 'TASK_DISPLAY_CODE',
90: 'ftb', p_rownum);
91: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID') = 'Y') THEN
92: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID'), l_dim_info('USER_DIM1_ID').dim_member_col,
93: l_dim_info('USER_DIM1_ID').dim_member_display_code,
94: 'fud1', p_rownum);
95: END IF;
96:

Line 97: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID') = 'Y') THEN

93: l_dim_info('USER_DIM1_ID').dim_member_display_code,
94: 'fud1', p_rownum);
95: END IF;
96:
97: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID') = 'Y') THEN
98: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID'), l_dim_info('USER_DIM2_ID').dim_member_col,
99: l_dim_info('USER_DIM2_ID').dim_member_display_code,
100: 'fud2', p_rownum);
101: END IF;

Line 98: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID'), l_dim_info('USER_DIM2_ID').dim_member_col,

94: 'fud1', p_rownum);
95: END IF;
96:
97: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID') = 'Y') THEN
98: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID'), l_dim_info('USER_DIM2_ID').dim_member_col,
99: l_dim_info('USER_DIM2_ID').dim_member_display_code,
100: 'fud2', p_rownum);
101: END IF;
102:

Line 103: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID') = 'Y') THEN

99: l_dim_info('USER_DIM2_ID').dim_member_display_code,
100: 'fud2', p_rownum);
101: END IF;
102:
103: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID') = 'Y') THEN
104: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID'), l_dim_info('USER_DIM3_ID').dim_member_col,
105: l_dim_info('USER_DIM3_ID').dim_member_display_code,
106: 'fud3', p_rownum);
107: END IF;

Line 104: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID'), l_dim_info('USER_DIM3_ID').dim_member_col,

100: 'fud2', p_rownum);
101: END IF;
102:
103: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID') = 'Y') THEN
104: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID'), l_dim_info('USER_DIM3_ID').dim_member_col,
105: l_dim_info('USER_DIM3_ID').dim_member_display_code,
106: 'fud3', p_rownum);
107: END IF;
108:

Line 109: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID') = 'Y') THEN

105: l_dim_info('USER_DIM3_ID').dim_member_display_code,
106: 'fud3', p_rownum);
107: END IF;
108:
109: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID') = 'Y') THEN
110: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID'), l_dim_info('USER_DIM4_ID').dim_member_col,
111: l_dim_info('USER_DIM4_ID').dim_member_display_code,
112: 'fud4', p_rownum);
113: END IF;

Line 110: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID'), l_dim_info('USER_DIM4_ID').dim_member_col,

106: 'fud3', p_rownum);
107: END IF;
108:
109: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID') = 'Y') THEN
110: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID'), l_dim_info('USER_DIM4_ID').dim_member_col,
111: l_dim_info('USER_DIM4_ID').dim_member_display_code,
112: 'fud4', p_rownum);
113: END IF;
114: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID') = 'Y') THEN

Line 114: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID') = 'Y') THEN

110: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID'), l_dim_info('USER_DIM4_ID').dim_member_col,
111: l_dim_info('USER_DIM4_ID').dim_member_display_code,
112: 'fud4', p_rownum);
113: END IF;
114: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID') = 'Y') THEN
115: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID'), l_dim_info('USER_DIM5_ID').dim_member_col,
116: l_dim_info('USER_DIM5_ID').dim_member_display_code,
117: 'fud5', p_rownum);
118: END IF;

Line 115: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID'), l_dim_info('USER_DIM5_ID').dim_member_col,

111: l_dim_info('USER_DIM4_ID').dim_member_display_code,
112: 'fud4', p_rownum);
113: END IF;
114: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID') = 'Y') THEN
115: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID'), l_dim_info('USER_DIM5_ID').dim_member_col,
116: l_dim_info('USER_DIM5_ID').dim_member_display_code,
117: 'fud5', p_rownum);
118: END IF;
119: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID') = 'Y') THEN

Line 119: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID') = 'Y') THEN

115: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID'), l_dim_info('USER_DIM5_ID').dim_member_col,
116: l_dim_info('USER_DIM5_ID').dim_member_display_code,
117: 'fud5', p_rownum);
118: END IF;
119: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID') = 'Y') THEN
120: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID'), l_dim_info('USER_DIM6_ID').dim_member_col,
121: l_dim_info('USER_DIM6_ID').dim_member_display_code,
122: 'fud6', p_rownum);
123: END IF;

Line 120: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID'), l_dim_info('USER_DIM6_ID').dim_member_col,

116: l_dim_info('USER_DIM5_ID').dim_member_display_code,
117: 'fud5', p_rownum);
118: END IF;
119: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID') = 'Y') THEN
120: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID'), l_dim_info('USER_DIM6_ID').dim_member_col,
121: l_dim_info('USER_DIM6_ID').dim_member_display_code,
122: 'fud6', p_rownum);
123: END IF;
124: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID') = 'Y') THEN

Line 124: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID') = 'Y') THEN

120: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID'), l_dim_info('USER_DIM6_ID').dim_member_col,
121: l_dim_info('USER_DIM6_ID').dim_member_display_code,
122: 'fud6', p_rownum);
123: END IF;
124: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID') = 'Y') THEN
125: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID'), l_dim_info('USER_DIM7_ID').dim_member_col,
126: l_dim_info('USER_DIM7_ID').dim_member_display_code,
127: 'fud7', p_rownum);
128: END IF;

Line 125: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID'), l_dim_info('USER_DIM7_ID').dim_member_col,

121: l_dim_info('USER_DIM6_ID').dim_member_display_code,
122: 'fud6', p_rownum);
123: END IF;
124: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID') = 'Y') THEN
125: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID'), l_dim_info('USER_DIM7_ID').dim_member_col,
126: l_dim_info('USER_DIM7_ID').dim_member_display_code,
127: 'fud7', p_rownum);
128: END IF;
129: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID') = 'Y') THEN

Line 129: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID') = 'Y') THEN

125: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID'), l_dim_info('USER_DIM7_ID').dim_member_col,
126: l_dim_info('USER_DIM7_ID').dim_member_display_code,
127: 'fud7', p_rownum);
128: END IF;
129: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID') = 'Y') THEN
130: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID'), l_dim_info('USER_DIM8_ID').dim_member_col,
131: l_dim_info('USER_DIM8_ID').dim_member_display_code,
132: 'fud8', p_rownum);
133: END IF;

Line 130: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID'), l_dim_info('USER_DIM8_ID').dim_member_col,

126: l_dim_info('USER_DIM7_ID').dim_member_display_code,
127: 'fud7', p_rownum);
128: END IF;
129: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID') = 'Y') THEN
130: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID'), l_dim_info('USER_DIM8_ID').dim_member_col,
131: l_dim_info('USER_DIM8_ID').dim_member_display_code,
132: 'fud8', p_rownum);
133: END IF;
134: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM9_ID') = 'Y') THEN

Line 134: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM9_ID') = 'Y') THEN

130: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID'), l_dim_info('USER_DIM8_ID').dim_member_col,
131: l_dim_info('USER_DIM8_ID').dim_member_display_code,
132: 'fud8', p_rownum);
133: END IF;
134: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM9_ID') = 'Y') THEN
135: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM9_ID'), l_dim_info('USER_DIM9_ID').dim_member_col,
136: l_dim_info('USER_DIM9_ID').dim_member_display_code,
137: 'fud9', p_rownum);
138: END IF;

Line 135: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM9_ID'), l_dim_info('USER_DIM9_ID').dim_member_col,

131: l_dim_info('USER_DIM8_ID').dim_member_display_code,
132: 'fud8', p_rownum);
133: END IF;
134: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM9_ID') = 'Y') THEN
135: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM9_ID'), l_dim_info('USER_DIM9_ID').dim_member_col,
136: l_dim_info('USER_DIM9_ID').dim_member_display_code,
137: 'fud9', p_rownum);
138: END IF;
139: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID') = 'Y') THEN

Line 139: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID') = 'Y') THEN

135: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM9_ID'), l_dim_info('USER_DIM9_ID').dim_member_col,
136: l_dim_info('USER_DIM9_ID').dim_member_display_code,
137: 'fud9', p_rownum);
138: END IF;
139: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID') = 'Y') THEN
140: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID'),l_dim_info('USER_DIM10_ID').dim_member_col,
141: l_dim_info('USER_DIM10_ID').dim_member_display_code,
142: 'fud10', p_rownum);
143: END IF;

Line 140: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID'),l_dim_info('USER_DIM10_ID').dim_member_col,

136: l_dim_info('USER_DIM9_ID').dim_member_display_code,
137: 'fud9', p_rownum);
138: END IF;
139: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID') = 'Y') THEN
140: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID'),l_dim_info('USER_DIM10_ID').dim_member_col,
141: l_dim_info('USER_DIM10_ID').dim_member_display_code,
142: 'fud10', p_rownum);
143: END IF;
144: END build_where_clause_list;

Line 159: l_dim_info gcs_utility_pkg.t_hash_gcs_dimension_info :=

155: END add_table_to_list;
156:
157: PROCEDURE build_table_list (p_rownum IN OUT NOCOPY NUMBER) IS
158:
159: l_dim_info gcs_utility_pkg.t_hash_gcs_dimension_info :=
160: gcs_utility_pkg.g_gcs_dimension_info;
161:
162: BEGIN
163: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('FINANCIAL_ELEM_ID'), 'fem_fin_elems_b', 'ffeb', p_rownum);

Line 160: gcs_utility_pkg.g_gcs_dimension_info;

156:
157: PROCEDURE build_table_list (p_rownum IN OUT NOCOPY NUMBER) IS
158:
159: l_dim_info gcs_utility_pkg.t_hash_gcs_dimension_info :=
160: gcs_utility_pkg.g_gcs_dimension_info;
161:
162: BEGIN
163: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('FINANCIAL_ELEM_ID'), 'fem_fin_elems_b', 'ffeb', p_rownum);
164: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('PRODUCT_ID'), 'fem_products_b', 'fpb', p_rownum);

Line 163: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('FINANCIAL_ELEM_ID'), 'fem_fin_elems_b', 'ffeb', p_rownum);

159: l_dim_info gcs_utility_pkg.t_hash_gcs_dimension_info :=
160: gcs_utility_pkg.g_gcs_dimension_info;
161:
162: BEGIN
163: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('FINANCIAL_ELEM_ID'), 'fem_fin_elems_b', 'ffeb', p_rownum);
164: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('PRODUCT_ID'), 'fem_products_b', 'fpb', p_rownum);
165: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('NATURAL_ACCOUNT_ID'), 'fem_nat_accts_b', 'fnab', p_rownum);
166: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('CHANNEL_ID'), 'fem_channels_b', 'fchb', p_rownum);
167: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('PROJECT_ID'), 'fem_projects_b', 'fpjb', p_rownum);

Line 164: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('PRODUCT_ID'), 'fem_products_b', 'fpb', p_rownum);

160: gcs_utility_pkg.g_gcs_dimension_info;
161:
162: BEGIN
163: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('FINANCIAL_ELEM_ID'), 'fem_fin_elems_b', 'ffeb', p_rownum);
164: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('PRODUCT_ID'), 'fem_products_b', 'fpb', p_rownum);
165: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('NATURAL_ACCOUNT_ID'), 'fem_nat_accts_b', 'fnab', p_rownum);
166: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('CHANNEL_ID'), 'fem_channels_b', 'fchb', p_rownum);
167: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('PROJECT_ID'), 'fem_projects_b', 'fpjb', p_rownum);
168: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('CUSTOMER_ID'), 'fem_customers_b', 'fcb', p_rownum);

Line 165: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('NATURAL_ACCOUNT_ID'), 'fem_nat_accts_b', 'fnab', p_rownum);

161:
162: BEGIN
163: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('FINANCIAL_ELEM_ID'), 'fem_fin_elems_b', 'ffeb', p_rownum);
164: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('PRODUCT_ID'), 'fem_products_b', 'fpb', p_rownum);
165: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('NATURAL_ACCOUNT_ID'), 'fem_nat_accts_b', 'fnab', p_rownum);
166: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('CHANNEL_ID'), 'fem_channels_b', 'fchb', p_rownum);
167: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('PROJECT_ID'), 'fem_projects_b', 'fpjb', p_rownum);
168: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('CUSTOMER_ID'), 'fem_customers_b', 'fcb', p_rownum);
169: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('TASK_ID'), 'fem_tasks_b', 'ftb', p_rownum);

Line 166: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('CHANNEL_ID'), 'fem_channels_b', 'fchb', p_rownum);

162: BEGIN
163: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('FINANCIAL_ELEM_ID'), 'fem_fin_elems_b', 'ffeb', p_rownum);
164: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('PRODUCT_ID'), 'fem_products_b', 'fpb', p_rownum);
165: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('NATURAL_ACCOUNT_ID'), 'fem_nat_accts_b', 'fnab', p_rownum);
166: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('CHANNEL_ID'), 'fem_channels_b', 'fchb', p_rownum);
167: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('PROJECT_ID'), 'fem_projects_b', 'fpjb', p_rownum);
168: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('CUSTOMER_ID'), 'fem_customers_b', 'fcb', p_rownum);
169: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('TASK_ID'), 'fem_tasks_b', 'ftb', p_rownum);
170: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID') = 'Y') THEN

Line 167: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('PROJECT_ID'), 'fem_projects_b', 'fpjb', p_rownum);

163: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('FINANCIAL_ELEM_ID'), 'fem_fin_elems_b', 'ffeb', p_rownum);
164: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('PRODUCT_ID'), 'fem_products_b', 'fpb', p_rownum);
165: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('NATURAL_ACCOUNT_ID'), 'fem_nat_accts_b', 'fnab', p_rownum);
166: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('CHANNEL_ID'), 'fem_channels_b', 'fchb', p_rownum);
167: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('PROJECT_ID'), 'fem_projects_b', 'fpjb', p_rownum);
168: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('CUSTOMER_ID'), 'fem_customers_b', 'fcb', p_rownum);
169: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('TASK_ID'), 'fem_tasks_b', 'ftb', p_rownum);
170: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID') = 'Y') THEN
171: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID'), l_dim_info('USER_DIM1_ID').dim_b_table_name,

Line 168: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('CUSTOMER_ID'), 'fem_customers_b', 'fcb', p_rownum);

164: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('PRODUCT_ID'), 'fem_products_b', 'fpb', p_rownum);
165: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('NATURAL_ACCOUNT_ID'), 'fem_nat_accts_b', 'fnab', p_rownum);
166: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('CHANNEL_ID'), 'fem_channels_b', 'fchb', p_rownum);
167: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('PROJECT_ID'), 'fem_projects_b', 'fpjb', p_rownum);
168: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('CUSTOMER_ID'), 'fem_customers_b', 'fcb', p_rownum);
169: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('TASK_ID'), 'fem_tasks_b', 'ftb', p_rownum);
170: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID') = 'Y') THEN
171: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID'), l_dim_info('USER_DIM1_ID').dim_b_table_name,
172: 'fud1', p_rownum);

Line 169: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('TASK_ID'), 'fem_tasks_b', 'ftb', p_rownum);

165: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('NATURAL_ACCOUNT_ID'), 'fem_nat_accts_b', 'fnab', p_rownum);
166: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('CHANNEL_ID'), 'fem_channels_b', 'fchb', p_rownum);
167: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('PROJECT_ID'), 'fem_projects_b', 'fpjb', p_rownum);
168: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('CUSTOMER_ID'), 'fem_customers_b', 'fcb', p_rownum);
169: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('TASK_ID'), 'fem_tasks_b', 'ftb', p_rownum);
170: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID') = 'Y') THEN
171: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID'), l_dim_info('USER_DIM1_ID').dim_b_table_name,
172: 'fud1', p_rownum);
173: END IF;

Line 170: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID') = 'Y') THEN

166: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('CHANNEL_ID'), 'fem_channels_b', 'fchb', p_rownum);
167: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('PROJECT_ID'), 'fem_projects_b', 'fpjb', p_rownum);
168: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('CUSTOMER_ID'), 'fem_customers_b', 'fcb', p_rownum);
169: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('TASK_ID'), 'fem_tasks_b', 'ftb', p_rownum);
170: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID') = 'Y') THEN
171: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID'), l_dim_info('USER_DIM1_ID').dim_b_table_name,
172: 'fud1', p_rownum);
173: END IF;
174: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID') = 'Y') THEN

Line 171: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID'), l_dim_info('USER_DIM1_ID').dim_b_table_name,

167: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('PROJECT_ID'), 'fem_projects_b', 'fpjb', p_rownum);
168: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('CUSTOMER_ID'), 'fem_customers_b', 'fcb', p_rownum);
169: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('TASK_ID'), 'fem_tasks_b', 'ftb', p_rownum);
170: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID') = 'Y') THEN
171: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID'), l_dim_info('USER_DIM1_ID').dim_b_table_name,
172: 'fud1', p_rownum);
173: END IF;
174: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID') = 'Y') THEN
175: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID'), l_dim_info('USER_DIM2_ID').dim_b_table_name,

Line 174: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID') = 'Y') THEN

170: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID') = 'Y') THEN
171: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID'), l_dim_info('USER_DIM1_ID').dim_b_table_name,
172: 'fud1', p_rownum);
173: END IF;
174: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID') = 'Y') THEN
175: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID'), l_dim_info('USER_DIM2_ID').dim_b_table_name,
176: 'fud2', p_rownum);
177: END IF;
178: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID') = 'Y') THEN

Line 175: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID'), l_dim_info('USER_DIM2_ID').dim_b_table_name,

171: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID'), l_dim_info('USER_DIM1_ID').dim_b_table_name,
172: 'fud1', p_rownum);
173: END IF;
174: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID') = 'Y') THEN
175: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID'), l_dim_info('USER_DIM2_ID').dim_b_table_name,
176: 'fud2', p_rownum);
177: END IF;
178: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID') = 'Y') THEN
179: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID'), l_dim_info('USER_DIM3_ID').dim_b_table_name,

Line 178: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID') = 'Y') THEN

174: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID') = 'Y') THEN
175: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID'), l_dim_info('USER_DIM2_ID').dim_b_table_name,
176: 'fud2', p_rownum);
177: END IF;
178: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID') = 'Y') THEN
179: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID'), l_dim_info('USER_DIM3_ID').dim_b_table_name,
180: 'fud3', p_rownum);
181: END IF;
182: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID') = 'Y') THEN

Line 179: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID'), l_dim_info('USER_DIM3_ID').dim_b_table_name,

175: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID'), l_dim_info('USER_DIM2_ID').dim_b_table_name,
176: 'fud2', p_rownum);
177: END IF;
178: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID') = 'Y') THEN
179: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID'), l_dim_info('USER_DIM3_ID').dim_b_table_name,
180: 'fud3', p_rownum);
181: END IF;
182: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID') = 'Y') THEN
183: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID'), l_dim_info('USER_DIM4_ID').dim_b_table_name,

Line 182: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID') = 'Y') THEN

178: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID') = 'Y') THEN
179: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID'), l_dim_info('USER_DIM3_ID').dim_b_table_name,
180: 'fud3', p_rownum);
181: END IF;
182: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID') = 'Y') THEN
183: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID'), l_dim_info('USER_DIM4_ID').dim_b_table_name,
184: 'fud4', p_rownum);
185: END IF;
186: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID') = 'Y') THEN

Line 183: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID'), l_dim_info('USER_DIM4_ID').dim_b_table_name,

179: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID'), l_dim_info('USER_DIM3_ID').dim_b_table_name,
180: 'fud3', p_rownum);
181: END IF;
182: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID') = 'Y') THEN
183: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID'), l_dim_info('USER_DIM4_ID').dim_b_table_name,
184: 'fud4', p_rownum);
185: END IF;
186: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID') = 'Y') THEN
187: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID'), l_dim_info('USER_DIM5_ID').dim_b_table_name,

Line 186: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID') = 'Y') THEN

182: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID') = 'Y') THEN
183: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID'), l_dim_info('USER_DIM4_ID').dim_b_table_name,
184: 'fud4', p_rownum);
185: END IF;
186: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID') = 'Y') THEN
187: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID'), l_dim_info('USER_DIM5_ID').dim_b_table_name,
188: 'fud5', p_rownum);
189: END IF;
190: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID') = 'Y') THEN

Line 187: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID'), l_dim_info('USER_DIM5_ID').dim_b_table_name,

183: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID'), l_dim_info('USER_DIM4_ID').dim_b_table_name,
184: 'fud4', p_rownum);
185: END IF;
186: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID') = 'Y') THEN
187: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID'), l_dim_info('USER_DIM5_ID').dim_b_table_name,
188: 'fud5', p_rownum);
189: END IF;
190: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID') = 'Y') THEN
191: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID'), l_dim_info('USER_DIM6_ID').dim_b_table_name,

Line 190: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID') = 'Y') THEN

186: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID') = 'Y') THEN
187: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID'), l_dim_info('USER_DIM5_ID').dim_b_table_name,
188: 'fud5', p_rownum);
189: END IF;
190: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID') = 'Y') THEN
191: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID'), l_dim_info('USER_DIM6_ID').dim_b_table_name,
192: 'fud6', p_rownum);
193: END IF;
194: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID') = 'Y') THEN

Line 191: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID'), l_dim_info('USER_DIM6_ID').dim_b_table_name,

187: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID'), l_dim_info('USER_DIM5_ID').dim_b_table_name,
188: 'fud5', p_rownum);
189: END IF;
190: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID') = 'Y') THEN
191: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID'), l_dim_info('USER_DIM6_ID').dim_b_table_name,
192: 'fud6', p_rownum);
193: END IF;
194: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID') = 'Y') THEN
195: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID'), l_dim_info('USER_DIM7_ID').dim_b_table_name,

Line 194: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID') = 'Y') THEN

190: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID') = 'Y') THEN
191: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID'), l_dim_info('USER_DIM6_ID').dim_b_table_name,
192: 'fud6', p_rownum);
193: END IF;
194: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID') = 'Y') THEN
195: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID'), l_dim_info('USER_DIM7_ID').dim_b_table_name,
196: 'fud7', p_rownum);
197: END IF;
198: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID') = 'Y') THEN

Line 195: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID'), l_dim_info('USER_DIM7_ID').dim_b_table_name,

191: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID'), l_dim_info('USER_DIM6_ID').dim_b_table_name,
192: 'fud6', p_rownum);
193: END IF;
194: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID') = 'Y') THEN
195: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID'), l_dim_info('USER_DIM7_ID').dim_b_table_name,
196: 'fud7', p_rownum);
197: END IF;
198: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID') = 'Y') THEN
199: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID'), l_dim_info('USER_DIM8_ID').dim_b_table_name,

Line 198: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID') = 'Y') THEN

194: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID') = 'Y') THEN
195: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID'), l_dim_info('USER_DIM7_ID').dim_b_table_name,
196: 'fud7', p_rownum);
197: END IF;
198: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID') = 'Y') THEN
199: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID'), l_dim_info('USER_DIM8_ID').dim_b_table_name,
200: 'fud8', p_rownum);
201: END IF;
202: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM9_ID') = 'Y') THEN

Line 199: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID'), l_dim_info('USER_DIM8_ID').dim_b_table_name,

195: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID'), l_dim_info('USER_DIM7_ID').dim_b_table_name,
196: 'fud7', p_rownum);
197: END IF;
198: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID') = 'Y') THEN
199: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID'), l_dim_info('USER_DIM8_ID').dim_b_table_name,
200: 'fud8', p_rownum);
201: END IF;
202: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM9_ID') = 'Y') THEN
203: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM9_ID'), l_dim_info('USER_DIM9_ID').dim_b_table_name,

Line 202: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM9_ID') = 'Y') THEN

198: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID') = 'Y') THEN
199: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID'), l_dim_info('USER_DIM8_ID').dim_b_table_name,
200: 'fud8', p_rownum);
201: END IF;
202: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM9_ID') = 'Y') THEN
203: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM9_ID'), l_dim_info('USER_DIM9_ID').dim_b_table_name,
204: 'fud9', p_rownum);
205: END IF;
206: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID') = 'Y') THEN

Line 203: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM9_ID'), l_dim_info('USER_DIM9_ID').dim_b_table_name,

199: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID'), l_dim_info('USER_DIM8_ID').dim_b_table_name,
200: 'fud8', p_rownum);
201: END IF;
202: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM9_ID') = 'Y') THEN
203: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM9_ID'), l_dim_info('USER_DIM9_ID').dim_b_table_name,
204: 'fud9', p_rownum);
205: END IF;
206: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID') = 'Y') THEN
207: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID'),l_dim_info('USER_DIM10_ID').dim_b_table_name,

Line 206: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID') = 'Y') THEN

202: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM9_ID') = 'Y') THEN
203: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM9_ID'), l_dim_info('USER_DIM9_ID').dim_b_table_name,
204: 'fud9', p_rownum);
205: END IF;
206: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID') = 'Y') THEN
207: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID'),l_dim_info('USER_DIM10_ID').dim_b_table_name,
208: 'fud10', p_rownum);
209: END IF;
210: END;

Line 207: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID'),l_dim_info('USER_DIM10_ID').dim_b_table_name,

203: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM9_ID'), l_dim_info('USER_DIM9_ID').dim_b_table_name,
204: 'fud9', p_rownum);
205: END IF;
206: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID') = 'Y') THEN
207: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID'),l_dim_info('USER_DIM10_ID').dim_b_table_name,
208: 'fud10', p_rownum);
209: END IF;
210: END;
211:

Line 395: ad_ddl.build_statement(' gcs_utility_pkg.g_dimension_attr_info(''LEDGER_ID-GLOBAL_VS_COMBO'').attribute_id;', r); r:=r+1;

391: ad_ddl.build_statement(' p_currency_code IN VARCHAR2) ' , r); r:=r+1;
392: ad_ddl.build_statement(' IS PRAGMA AUTONOMOUS_TRANSACTION; ', r); r:=r+1;
393: ad_ddl.build_statement(' l_line_item_vs_id NUMBER; ', r); r:=r+1;
394: ad_ddl.build_statement(' l_ledger_vs_combo_attr NUMBER(15) := ', r); r:=r+1;
395: ad_ddl.build_statement(' gcs_utility_pkg.g_dimension_attr_info(''LEDGER_ID-GLOBAL_VS_COMBO'').attribute_id;', r); r:=r+1;
396: ad_ddl.build_statement(' l_ledger_vs_combo_version NUMBER(15) := ', r); r:=r+1;
397: ad_ddl.build_statement(' gcs_utility_pkg.g_dimension_attr_info(''LEDGER_ID-GLOBAL_VS_COMBO'').version_id;', r); r:=r+1;
398: ad_ddl.build_statement(' l_line_item_type_attr NUMBER(15) := ', r); r:=r+1;
399: ad_ddl.build_statement(' gcs_utility_pkg.g_dimension_attr_info(''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').attribute_id;', r); r:=r+1;

Line 397: ad_ddl.build_statement(' gcs_utility_pkg.g_dimension_attr_info(''LEDGER_ID-GLOBAL_VS_COMBO'').version_id;', r); r:=r+1;

393: ad_ddl.build_statement(' l_line_item_vs_id NUMBER; ', r); r:=r+1;
394: ad_ddl.build_statement(' l_ledger_vs_combo_attr NUMBER(15) := ', r); r:=r+1;
395: ad_ddl.build_statement(' gcs_utility_pkg.g_dimension_attr_info(''LEDGER_ID-GLOBAL_VS_COMBO'').attribute_id;', r); r:=r+1;
396: ad_ddl.build_statement(' l_ledger_vs_combo_version NUMBER(15) := ', r); r:=r+1;
397: ad_ddl.build_statement(' gcs_utility_pkg.g_dimension_attr_info(''LEDGER_ID-GLOBAL_VS_COMBO'').version_id;', r); r:=r+1;
398: ad_ddl.build_statement(' l_line_item_type_attr NUMBER(15) := ', r); r:=r+1;
399: ad_ddl.build_statement(' gcs_utility_pkg.g_dimension_attr_info(''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').attribute_id;', r); r:=r+1;
400: ad_ddl.build_statement(' l_line_item_type_version NUMBER(15) := ', r); r:=r+1;
401: ad_ddl.build_statement(' gcs_utility_pkg.g_dimension_attr_info(''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').version_id;', r); r:=r+1;

Line 399: ad_ddl.build_statement(' gcs_utility_pkg.g_dimension_attr_info(''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').attribute_id;', r); r:=r+1;

395: ad_ddl.build_statement(' gcs_utility_pkg.g_dimension_attr_info(''LEDGER_ID-GLOBAL_VS_COMBO'').attribute_id;', r); r:=r+1;
396: ad_ddl.build_statement(' l_ledger_vs_combo_version NUMBER(15) := ', r); r:=r+1;
397: ad_ddl.build_statement(' gcs_utility_pkg.g_dimension_attr_info(''LEDGER_ID-GLOBAL_VS_COMBO'').version_id;', r); r:=r+1;
398: ad_ddl.build_statement(' l_line_item_type_attr NUMBER(15) := ', r); r:=r+1;
399: ad_ddl.build_statement(' gcs_utility_pkg.g_dimension_attr_info(''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').attribute_id;', r); r:=r+1;
400: ad_ddl.build_statement(' l_line_item_type_version NUMBER(15) := ', r); r:=r+1;
401: ad_ddl.build_statement(' gcs_utility_pkg.g_dimension_attr_info(''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').version_id;', r); r:=r+1;
402: ad_ddl.build_statement(' l_acct_type_attr NUMBER(15) := ', r); r:=r+1;
403: ad_ddl.build_statement(' gcs_utility_pkg.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE'').attribute_id;', r); r:=r+1;

Line 401: ad_ddl.build_statement(' gcs_utility_pkg.g_dimension_attr_info(''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').version_id;', r); r:=r+1;

397: ad_ddl.build_statement(' gcs_utility_pkg.g_dimension_attr_info(''LEDGER_ID-GLOBAL_VS_COMBO'').version_id;', r); r:=r+1;
398: ad_ddl.build_statement(' l_line_item_type_attr NUMBER(15) := ', r); r:=r+1;
399: ad_ddl.build_statement(' gcs_utility_pkg.g_dimension_attr_info(''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').attribute_id;', r); r:=r+1;
400: ad_ddl.build_statement(' l_line_item_type_version NUMBER(15) := ', r); r:=r+1;
401: ad_ddl.build_statement(' gcs_utility_pkg.g_dimension_attr_info(''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').version_id;', r); r:=r+1;
402: ad_ddl.build_statement(' l_acct_type_attr NUMBER(15) := ', r); r:=r+1;
403: ad_ddl.build_statement(' gcs_utility_pkg.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE'').attribute_id;', r); r:=r+1;
404: ad_ddl.build_statement(' l_acct_type_version NUMBER(15) := ', r); r:=r+1;
405: ad_ddl.build_statement(' gcs_utility_pkg.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE'').version_id;', r); r:=r+1;

Line 403: ad_ddl.build_statement(' gcs_utility_pkg.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE'').attribute_id;', r); r:=r+1;

399: ad_ddl.build_statement(' gcs_utility_pkg.g_dimension_attr_info(''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').attribute_id;', r); r:=r+1;
400: ad_ddl.build_statement(' l_line_item_type_version NUMBER(15) := ', r); r:=r+1;
401: ad_ddl.build_statement(' gcs_utility_pkg.g_dimension_attr_info(''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').version_id;', r); r:=r+1;
402: ad_ddl.build_statement(' l_acct_type_attr NUMBER(15) := ', r); r:=r+1;
403: ad_ddl.build_statement(' gcs_utility_pkg.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE'').attribute_id;', r); r:=r+1;
404: ad_ddl.build_statement(' l_acct_type_version NUMBER(15) := ', r); r:=r+1;
405: ad_ddl.build_statement(' gcs_utility_pkg.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE'').version_id;', r); r:=r+1;
406: ad_ddl.build_statement(' ', r); r:=r+1;
407: ad_ddl.build_statement(' BEGIN ', r); r:=r+1;

Line 405: ad_ddl.build_statement(' gcs_utility_pkg.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE'').version_id;', r); r:=r+1;

401: ad_ddl.build_statement(' gcs_utility_pkg.g_dimension_attr_info(''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').version_id;', r); r:=r+1;
402: ad_ddl.build_statement(' l_acct_type_attr NUMBER(15) := ', r); r:=r+1;
403: ad_ddl.build_statement(' gcs_utility_pkg.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE'').attribute_id;', r); r:=r+1;
404: ad_ddl.build_statement(' l_acct_type_version NUMBER(15) := ', r); r:=r+1;
405: ad_ddl.build_statement(' gcs_utility_pkg.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE'').version_id;', r); r:=r+1;
406: ad_ddl.build_statement(' ', r); r:=r+1;
407: ad_ddl.build_statement(' BEGIN ', r); r:=r+1;
408: ad_ddl.build_statement(' ', r); r:=r+1;
409: ad_ddl.build_statement(' IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN ', r); r:=r+1;

Line 542: ad_ddl.build_statement(' AND fea.attribute_id = gcs_utility_pkg.g_dimension_attr_info(''ENTITY_ID-LEDGER_ID'').attribute_id ', r); r:=r+1;

538: ad_ddl.build_statement(' FROM fem_entities_attr fea, ', r); r:=r+1;
539: ad_ddl.build_statement(' gcs_data_sub_dtls gdsd ', r); r:=r+1;
540: ad_ddl.build_statement(' WHERE gdsd.load_id = p_load_id ', r); r:=r+1;
541: ad_ddl.build_statement(' AND fea.entity_id = gdsd.entity_id ', r); r:=r+1;
542: ad_ddl.build_statement(' AND fea.attribute_id = gcs_utility_pkg.g_dimension_attr_info(''ENTITY_ID-LEDGER_ID'').attribute_id ', r); r:=r+1;
543: ad_ddl.build_statement(' AND fea.version_id = gcs_utility_pkg.g_dimension_attr_info(''ENTITY_ID-LEDGER_ID'').version_id; ', r); r:=r+1;
544: ad_ddl.build_statement(' ', r); r:=r+1;
545: ad_ddl.build_statement(' ', r); r:=r+1;
546: ad_ddl.build_statement(' SELECT fgvcd.value_set_id, ', r); r:=r+1;

Line 543: ad_ddl.build_statement(' AND fea.version_id = gcs_utility_pkg.g_dimension_attr_info(''ENTITY_ID-LEDGER_ID'').version_id; ', r); r:=r+1;

539: ad_ddl.build_statement(' gcs_data_sub_dtls gdsd ', r); r:=r+1;
540: ad_ddl.build_statement(' WHERE gdsd.load_id = p_load_id ', r); r:=r+1;
541: ad_ddl.build_statement(' AND fea.entity_id = gdsd.entity_id ', r); r:=r+1;
542: ad_ddl.build_statement(' AND fea.attribute_id = gcs_utility_pkg.g_dimension_attr_info(''ENTITY_ID-LEDGER_ID'').attribute_id ', r); r:=r+1;
543: ad_ddl.build_statement(' AND fea.version_id = gcs_utility_pkg.g_dimension_attr_info(''ENTITY_ID-LEDGER_ID'').version_id; ', r); r:=r+1;
544: ad_ddl.build_statement(' ', r); r:=r+1;
545: ad_ddl.build_statement(' ', r); r:=r+1;
546: ad_ddl.build_statement(' SELECT fgvcd.value_set_id, ', r); r:=r+1;
547: ad_ddl.build_statement(' fxd.member_display_code_col, ', r); r:=r+1;

Line 556: ad_ddl.build_statement(' WHERE gcs_utility_pkg.get_fem_dim_required(fxd.MEMBER_COL) = ''Y'' ', r); r:=r+1;

552: ad_ddl.build_statement(' FROM fem_global_vs_combo_defs fgvcd, ', r); r:=r+1;
553: ad_ddl.build_statement(' fem_ledgers_attr fla, ', r); r:=r+1;
554: ad_ddl.build_statement(' fem_xdim_dimensions fxd, ', r); r:=r+1;
555: ad_ddl.build_statement(' fem_dimensions_tl fdt ', r); r:=r+1;
556: ad_ddl.build_statement(' WHERE gcs_utility_pkg.get_fem_dim_required(fxd.MEMBER_COL) = ''Y'' ', r); r:=r+1;
557: ad_ddl.build_statement(' AND global_vs_combo_id = fla.dim_attribute_numeric_member ', r); r:=r+1;
558: ad_ddl.build_statement(' AND fla.ledger_id = l_ledger_id ', r); r:=r+1;
559: ad_ddl.build_statement(' AND fla.attribute_id = gcs_utility_pkg.g_dimension_attr_info(''LEDGER_ID-GLOBAL_VS_COMBO'').attribute_id ', r); r:=r+1;
560: ad_ddl.build_statement(' AND fla.version_id = gcs_utility_pkg.g_dimension_attr_info(''LEDGER_ID-GLOBAL_VS_COMBO'').version_id ', r); r:=r+1;

Line 559: ad_ddl.build_statement(' AND fla.attribute_id = gcs_utility_pkg.g_dimension_attr_info(''LEDGER_ID-GLOBAL_VS_COMBO'').attribute_id ', r); r:=r+1;

555: ad_ddl.build_statement(' fem_dimensions_tl fdt ', r); r:=r+1;
556: ad_ddl.build_statement(' WHERE gcs_utility_pkg.get_fem_dim_required(fxd.MEMBER_COL) = ''Y'' ', r); r:=r+1;
557: ad_ddl.build_statement(' AND global_vs_combo_id = fla.dim_attribute_numeric_member ', r); r:=r+1;
558: ad_ddl.build_statement(' AND fla.ledger_id = l_ledger_id ', r); r:=r+1;
559: ad_ddl.build_statement(' AND fla.attribute_id = gcs_utility_pkg.g_dimension_attr_info(''LEDGER_ID-GLOBAL_VS_COMBO'').attribute_id ', r); r:=r+1;
560: ad_ddl.build_statement(' AND fla.version_id = gcs_utility_pkg.g_dimension_attr_info(''LEDGER_ID-GLOBAL_VS_COMBO'').version_id ', r); r:=r+1;
561: ad_ddl.build_statement(' AND fgvcd.dimension_id = fxd.dimension_id ', r); r:=r+1;
562: ad_ddl.build_statement(' AND fxd.member_col IN (''COMPANY_COST_CENTER_ORG_ID'',''FINANCIAL_ELEM_ID'',''PRODUCT_ID'',''NATURAL_ACCOUNT_ID'',''CHANNEL_ID'', ', r); r:=r+1;
563: ad_ddl.build_statement(' ''LINE_ITEM_ID'',''PROJECT_ID'',''CUSTOMER_ID'',''TASK_ID'',''USER_DIM1_ID'',''USER_DIM10_ID'', ', r); r:=r+1;

Line 560: ad_ddl.build_statement(' AND fla.version_id = gcs_utility_pkg.g_dimension_attr_info(''LEDGER_ID-GLOBAL_VS_COMBO'').version_id ', r); r:=r+1;

556: ad_ddl.build_statement(' WHERE gcs_utility_pkg.get_fem_dim_required(fxd.MEMBER_COL) = ''Y'' ', r); r:=r+1;
557: ad_ddl.build_statement(' AND global_vs_combo_id = fla.dim_attribute_numeric_member ', r); r:=r+1;
558: ad_ddl.build_statement(' AND fla.ledger_id = l_ledger_id ', r); r:=r+1;
559: ad_ddl.build_statement(' AND fla.attribute_id = gcs_utility_pkg.g_dimension_attr_info(''LEDGER_ID-GLOBAL_VS_COMBO'').attribute_id ', r); r:=r+1;
560: ad_ddl.build_statement(' AND fla.version_id = gcs_utility_pkg.g_dimension_attr_info(''LEDGER_ID-GLOBAL_VS_COMBO'').version_id ', r); r:=r+1;
561: ad_ddl.build_statement(' AND fgvcd.dimension_id = fxd.dimension_id ', r); r:=r+1;
562: ad_ddl.build_statement(' AND fxd.member_col IN (''COMPANY_COST_CENTER_ORG_ID'',''FINANCIAL_ELEM_ID'',''PRODUCT_ID'',''NATURAL_ACCOUNT_ID'',''CHANNEL_ID'', ', r); r:=r+1;
563: ad_ddl.build_statement(' ''LINE_ITEM_ID'',''PROJECT_ID'',''CUSTOMER_ID'',''TASK_ID'',''USER_DIM1_ID'',''USER_DIM10_ID'', ', r); r:=r+1;
564: ad_ddl.build_statement(' ''USER_DIM2_ID'',''USER_DIM3_ID'', ''USER_DIM4_ID'',''USER_DIM5_ID'', ', r); r:=r+1;