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

Line 21: l_dim_info gcs_utility_pkg.t_hash_gcs_dimension_info := gcs_utility_pkg.g_gcs_dimension_info;

17:
18: PROCEDURE build_insert_clause_list (p_rownum IN OUT NOCOPY NUMBER,
19: p_prefix IN VARCHAR2)
20: IS
21: l_dim_info gcs_utility_pkg.t_hash_gcs_dimension_info := gcs_utility_pkg.g_gcs_dimension_info;
22: BEGIN
23:
24: add_insert_clause_to_list(gcs_utility_pkg.get_dimension_required('CHANNEL_ID'),
25: p_prefix,

Line 24: add_insert_clause_to_list(gcs_utility_pkg.get_dimension_required('CHANNEL_ID'),

20: IS
21: l_dim_info gcs_utility_pkg.t_hash_gcs_dimension_info := gcs_utility_pkg.g_gcs_dimension_info;
22: BEGIN
23:
24: add_insert_clause_to_list(gcs_utility_pkg.get_dimension_required('CHANNEL_ID'),
25: p_prefix,
26: p_rownum,
27: 'channel_id');
28:

Line 29: add_insert_clause_to_list(gcs_utility_pkg.get_dimension_required('CUSTOMER_ID'),

25: p_prefix,
26: p_rownum,
27: 'channel_id');
28:
29: add_insert_clause_to_list(gcs_utility_pkg.get_dimension_required('CUSTOMER_ID'),
30: p_prefix,
31: p_rownum,
32: 'customer_id');
33:

Line 34: add_insert_clause_to_list(gcs_utility_pkg.get_dimension_required('FINANCIAL_ELEM_ID'),

30: p_prefix,
31: p_rownum,
32: 'customer_id');
33:
34: add_insert_clause_to_list(gcs_utility_pkg.get_dimension_required('FINANCIAL_ELEM_ID'),
35: p_prefix,
36: p_rownum,
37: 'financial_elem_id');
38:

Line 39: add_insert_clause_to_list(gcs_utility_pkg.get_dimension_required('LINE_ITEM_ID'),

35: p_prefix,
36: p_rownum,
37: 'financial_elem_id');
38:
39: add_insert_clause_to_list(gcs_utility_pkg.get_dimension_required('LINE_ITEM_ID'),
40: p_prefix,
41: p_rownum,
42: 'line_item_id');
43:

Line 44: add_insert_clause_to_list(gcs_utility_pkg.get_dimension_required('NATURAL_ACCOUNT_ID'),

40: p_prefix,
41: p_rownum,
42: 'line_item_id');
43:
44: add_insert_clause_to_list(gcs_utility_pkg.get_dimension_required('NATURAL_ACCOUNT_ID'),
45: p_prefix,
46: p_rownum,
47: 'natural_account_id');
48:

Line 49: add_insert_clause_to_list(gcs_utility_pkg.get_dimension_required('PRODUCT_ID'),

45: p_prefix,
46: p_rownum,
47: 'natural_account_id');
48:
49: add_insert_clause_to_list(gcs_utility_pkg.get_dimension_required('PRODUCT_ID'),
50: p_prefix,
51: p_rownum,
52: 'product_id');
53:

Line 54: add_insert_clause_to_list(gcs_utility_pkg.get_dimension_required('PROJECT_ID'),

50: p_prefix,
51: p_rownum,
52: 'product_id');
53:
54: add_insert_clause_to_list(gcs_utility_pkg.get_dimension_required('PROJECT_ID'),
55: p_prefix,
56: p_rownum,
57: 'project_id');
58:

Line 59: add_insert_clause_to_list(gcs_utility_pkg.get_dimension_required('TASK_ID'),

55: p_prefix,
56: p_rownum,
57: 'project_id');
58:
59: add_insert_clause_to_list(gcs_utility_pkg.get_dimension_required('TASK_ID'),
60: p_prefix,
61: p_rownum,
62: 'task_id');
63:

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

60: p_prefix,
61: p_rownum,
62: 'task_id');
63:
64: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID') = 'Y') THEN
65: add_insert_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM10_ID'),
66: p_prefix,
67: p_rownum,
68: 'user_dim10_id');

Line 65: add_insert_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM10_ID'),

61: p_rownum,
62: 'task_id');
63:
64: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID') = 'Y') THEN
65: add_insert_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM10_ID'),
66: p_prefix,
67: p_rownum,
68: 'user_dim10_id');
69: END IF;

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

67: p_rownum,
68: 'user_dim10_id');
69: END IF;
70:
71: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID') = 'Y') THEN
72: add_insert_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM1_ID'),
73: p_prefix,
74: p_rownum,
75: 'user_dim1_id');

Line 72: add_insert_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM1_ID'),

68: 'user_dim10_id');
69: END IF;
70:
71: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID') = 'Y') THEN
72: add_insert_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM1_ID'),
73: p_prefix,
74: p_rownum,
75: 'user_dim1_id');
76: END IF;

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

74: p_rownum,
75: 'user_dim1_id');
76: END IF;
77:
78: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID') = 'Y') THEN
79: add_insert_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM2_ID'),
80: p_prefix,
81: p_rownum,
82: 'user_dim2_id');

Line 79: add_insert_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM2_ID'),

75: 'user_dim1_id');
76: END IF;
77:
78: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID') = 'Y') THEN
79: add_insert_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM2_ID'),
80: p_prefix,
81: p_rownum,
82: 'user_dim2_id');
83: END IF;

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

81: p_rownum,
82: 'user_dim2_id');
83: END IF;
84:
85: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID') = 'Y') THEN
86: add_insert_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM3_ID'),
87: p_prefix,
88: p_rownum,
89: 'user_dim3_id');

Line 86: add_insert_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM3_ID'),

82: 'user_dim2_id');
83: END IF;
84:
85: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID') = 'Y') THEN
86: add_insert_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM3_ID'),
87: p_prefix,
88: p_rownum,
89: 'user_dim3_id');
90: END IF;

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

88: p_rownum,
89: 'user_dim3_id');
90: END IF;
91:
92: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID') = 'Y') THEN
93: add_insert_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM4_ID'),
94: p_prefix,
95: p_rownum,
96: 'user_dim4_id');

Line 93: add_insert_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM4_ID'),

89: 'user_dim3_id');
90: END IF;
91:
92: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID') = 'Y') THEN
93: add_insert_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM4_ID'),
94: p_prefix,
95: p_rownum,
96: 'user_dim4_id');
97: END IF;

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

95: p_rownum,
96: 'user_dim4_id');
97: END IF;
98:
99: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID') = 'Y') THEN
100: add_insert_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM5_ID'),
101: p_prefix,
102: p_rownum,
103: 'user_dim5_id');

Line 100: add_insert_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM5_ID'),

96: 'user_dim4_id');
97: END IF;
98:
99: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID') = 'Y') THEN
100: add_insert_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM5_ID'),
101: p_prefix,
102: p_rownum,
103: 'user_dim5_id');
104: END IF;

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

102: p_rownum,
103: 'user_dim5_id');
104: END IF;
105:
106: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID') = 'Y') THEN
107: add_insert_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM6_ID'),
108: p_prefix,
109: p_rownum,
110: 'user_dim6_id');

Line 107: add_insert_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM6_ID'),

103: 'user_dim5_id');
104: END IF;
105:
106: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID') = 'Y') THEN
107: add_insert_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM6_ID'),
108: p_prefix,
109: p_rownum,
110: 'user_dim6_id');
111: END IF;

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

109: p_rownum,
110: 'user_dim6_id');
111: END IF;
112:
113: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID') = 'Y') THEN
114: add_insert_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM7_ID'),
115: p_prefix,
116: p_rownum,
117: 'user_dim7_id');

Line 114: add_insert_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM7_ID'),

110: 'user_dim6_id');
111: END IF;
112:
113: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID') = 'Y') THEN
114: add_insert_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM7_ID'),
115: p_prefix,
116: p_rownum,
117: 'user_dim7_id');
118: END IF;

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

116: p_rownum,
117: 'user_dim7_id');
118: END IF;
119:
120: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID') = 'Y') THEN
121: add_insert_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM8_ID'),
122: p_prefix,
123: p_rownum,
124: 'user_dim8_id');

Line 121: add_insert_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM8_ID'),

117: 'user_dim7_id');
118: END IF;
119:
120: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID') = 'Y') THEN
121: add_insert_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM8_ID'),
122: p_prefix,
123: p_rownum,
124: 'user_dim8_id');
125: END IF;

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

123: p_rownum,
124: 'user_dim8_id');
125: END IF;
126:
127: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM9_ID') = 'Y') THEN
128: add_insert_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM9_ID'),
129: p_prefix,
130: p_rownum,
131: 'user_dim9_id');

Line 128: add_insert_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM9_ID'),

124: 'user_dim8_id');
125: END IF;
126:
127: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM9_ID') = 'Y') THEN
128: add_insert_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM9_ID'),
129: p_prefix,
130: p_rownum,
131: 'user_dim9_id');
132: END IF;

Line 150: l_dim_info gcs_utility_pkg.t_hash_gcs_dimension_info := gcs_utility_pkg.g_gcs_dimension_info;

146:
147: PROCEDURE build_select_clause_list (p_rownum IN OUT NOCOPY NUMBER,
148: p_table_alias IN VARCHAR2)
149: IS
150: l_dim_info gcs_utility_pkg.t_hash_gcs_dimension_info := gcs_utility_pkg.g_gcs_dimension_info;
151: BEGIN
152:
153: add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('CHANNEL_ID'),
154: p_table_alias,

Line 153: add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('CHANNEL_ID'),

149: IS
150: l_dim_info gcs_utility_pkg.t_hash_gcs_dimension_info := gcs_utility_pkg.g_gcs_dimension_info;
151: BEGIN
152:
153: add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('CHANNEL_ID'),
154: p_table_alias,
155: p_rownum,
156: 'channel_id');
157:

Line 158: add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('CUSTOMER_ID'),

154: p_table_alias,
155: p_rownum,
156: 'channel_id');
157:
158: add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('CUSTOMER_ID'),
159: p_table_alias,
160: p_rownum,
161: 'customer_id');
162:

Line 163: add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('FINANCIAL_ELEM_ID'),

159: p_table_alias,
160: p_rownum,
161: 'customer_id');
162:
163: add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('FINANCIAL_ELEM_ID'),
164: p_table_alias,
165: p_rownum,
166: 'financial_elem_id');
167:

Line 168: add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('LINE_ITEM_ID'),

164: p_table_alias,
165: p_rownum,
166: 'financial_elem_id');
167:
168: add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('LINE_ITEM_ID'),
169: p_table_alias,
170: p_rownum,
171: 'line_item_id');
172:

Line 173: add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('NATURAL_ACCOUNT_ID'),

169: p_table_alias,
170: p_rownum,
171: 'line_item_id');
172:
173: add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('NATURAL_ACCOUNT_ID'),
174: p_table_alias,
175: p_rownum,
176: 'natural_account_id');
177:

Line 178: add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('PRODUCT_ID'),

174: p_table_alias,
175: p_rownum,
176: 'natural_account_id');
177:
178: add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('PRODUCT_ID'),
179: p_table_alias,
180: p_rownum,
181: 'product_id');
182:

Line 183: add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('PROJECT_ID'),

179: p_table_alias,
180: p_rownum,
181: 'product_id');
182:
183: add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('PROJECT_ID'),
184: p_table_alias,
185: p_rownum,
186: 'project_id');
187:

Line 188: add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('TASK_ID'),

184: p_table_alias,
185: p_rownum,
186: 'project_id');
187:
188: add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('TASK_ID'),
189: p_table_alias,
190: p_rownum,
191: 'task_id');
192:

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

189: p_table_alias,
190: p_rownum,
191: 'task_id');
192:
193: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID') = 'Y') THEN
194: add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM10_ID'),
195: p_table_alias,
196: p_rownum,
197: 'user_dim10_id');

Line 194: add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM10_ID'),

190: p_rownum,
191: 'task_id');
192:
193: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID') = 'Y') THEN
194: add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM10_ID'),
195: p_table_alias,
196: p_rownum,
197: 'user_dim10_id');
198: END IF;

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

196: p_rownum,
197: 'user_dim10_id');
198: END IF;
199:
200: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID') = 'Y') THEN
201: add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM1_ID'),
202: p_table_alias,
203: p_rownum,
204: 'user_dim1_id');

Line 201: add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM1_ID'),

197: 'user_dim10_id');
198: END IF;
199:
200: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID') = 'Y') THEN
201: add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM1_ID'),
202: p_table_alias,
203: p_rownum,
204: 'user_dim1_id');
205: END IF;

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

203: p_rownum,
204: 'user_dim1_id');
205: END IF;
206:
207: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID') = 'Y') THEN
208: add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM2_ID'),
209: p_table_alias,
210: p_rownum,
211: 'user_dim2_id');

Line 208: add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM2_ID'),

204: 'user_dim1_id');
205: END IF;
206:
207: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID') = 'Y') THEN
208: add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM2_ID'),
209: p_table_alias,
210: p_rownum,
211: 'user_dim2_id');
212: END IF;

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

210: p_rownum,
211: 'user_dim2_id');
212: END IF;
213:
214: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID') = 'Y') THEN
215: add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM3_ID'),
216: p_table_alias,
217: p_rownum,
218: 'user_dim3_id');

Line 215: add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM3_ID'),

211: 'user_dim2_id');
212: END IF;
213:
214: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID') = 'Y') THEN
215: add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM3_ID'),
216: p_table_alias,
217: p_rownum,
218: 'user_dim3_id');
219: END IF;

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

217: p_rownum,
218: 'user_dim3_id');
219: END IF;
220:
221: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID') = 'Y') THEN
222: add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM4_ID'),
223: p_table_alias,
224: p_rownum,
225: 'user_dim4_id');

Line 222: add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM4_ID'),

218: 'user_dim3_id');
219: END IF;
220:
221: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID') = 'Y') THEN
222: add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM4_ID'),
223: p_table_alias,
224: p_rownum,
225: 'user_dim4_id');
226: END IF;

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

224: p_rownum,
225: 'user_dim4_id');
226: END IF;
227:
228: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID') = 'Y') THEN
229: add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM5_ID'),
230: p_table_alias,
231: p_rownum,
232: 'user_dim5_id');

Line 229: add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM5_ID'),

225: 'user_dim4_id');
226: END IF;
227:
228: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID') = 'Y') THEN
229: add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM5_ID'),
230: p_table_alias,
231: p_rownum,
232: 'user_dim5_id');
233: END IF;

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

231: p_rownum,
232: 'user_dim5_id');
233: END IF;
234:
235: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID') = 'Y') THEN
236: add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM6_ID'),
237: p_table_alias,
238: p_rownum,
239: 'user_dim6_id');

Line 236: add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM6_ID'),

232: 'user_dim5_id');
233: END IF;
234:
235: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID') = 'Y') THEN
236: add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM6_ID'),
237: p_table_alias,
238: p_rownum,
239: 'user_dim6_id');
240: END IF;

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

238: p_rownum,
239: 'user_dim6_id');
240: END IF;
241:
242: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID') = 'Y') THEN
243: add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM7_ID'),
244: p_table_alias,
245: p_rownum,
246: 'user_dim7_id');

Line 243: add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM7_ID'),

239: 'user_dim6_id');
240: END IF;
241:
242: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID') = 'Y') THEN
243: add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM7_ID'),
244: p_table_alias,
245: p_rownum,
246: 'user_dim7_id');
247: END IF;

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

245: p_rownum,
246: 'user_dim7_id');
247: END IF;
248:
249: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID') = 'Y') THEN
250: add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM8_ID'),
251: p_table_alias,
252: p_rownum,
253: 'user_dim8_id');

Line 250: add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM8_ID'),

246: 'user_dim7_id');
247: END IF;
248:
249: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID') = 'Y') THEN
250: add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM8_ID'),
251: p_table_alias,
252: p_rownum,
253: 'user_dim8_id');
254: END IF;

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

252: p_rownum,
253: 'user_dim8_id');
254: END IF;
255:
256: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM9_ID') = 'Y') THEN
257: add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM9_ID'),
258: p_table_alias,
259: p_rownum,
260: 'user_dim9_id');

Line 257: add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM9_ID'),

253: 'user_dim8_id');
254: END IF;
255:
256: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM9_ID') = 'Y') THEN
257: add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM9_ID'),
258: p_table_alias,
259: p_rownum,
260: 'user_dim9_id');
261: END IF;

Line 288: l_dim_info gcs_utility_pkg.t_hash_gcs_dimension_info := gcs_utility_pkg.g_gcs_dimension_info;

284: p_table_alias IN VARCHAR2,
285: p_assign_type IN VARCHAR2)
286:
287: IS
288: l_dim_info gcs_utility_pkg.t_hash_gcs_dimension_info := gcs_utility_pkg.g_gcs_dimension_info;
289: BEGIN
290:
291: add_column_to_group(gcs_utility_pkg.get_dimension_required('CHANNEL_ID'),
292: p_table_alias,

Line 291: add_column_to_group(gcs_utility_pkg.get_dimension_required('CHANNEL_ID'),

287: IS
288: l_dim_info gcs_utility_pkg.t_hash_gcs_dimension_info := gcs_utility_pkg.g_gcs_dimension_info;
289: BEGIN
290:
291: add_column_to_group(gcs_utility_pkg.get_dimension_required('CHANNEL_ID'),
292: p_table_alias,
293: p_rownum,
294: 'channel_id',
295: p_assign_type);

Line 297: add_column_to_group(gcs_utility_pkg.get_dimension_required('CUSTOMER_ID'),

293: p_rownum,
294: 'channel_id',
295: p_assign_type);
296:
297: add_column_to_group(gcs_utility_pkg.get_dimension_required('CUSTOMER_ID'),
298: p_table_alias,
299: p_rownum,
300: 'customer_id',
301: p_assign_type);

Line 303: add_column_to_group(gcs_utility_pkg.get_dimension_required('FINANCIAL_ELEM_ID'),

299: p_rownum,
300: 'customer_id',
301: p_assign_type);
302:
303: add_column_to_group(gcs_utility_pkg.get_dimension_required('FINANCIAL_ELEM_ID'),
304: p_table_alias,
305: p_rownum,
306: 'financial_elem_id',
307: p_assign_type);

Line 309: add_column_to_group(gcs_utility_pkg.get_dimension_required('LINE_ITEM_ID'),

305: p_rownum,
306: 'financial_elem_id',
307: p_assign_type);
308:
309: add_column_to_group(gcs_utility_pkg.get_dimension_required('LINE_ITEM_ID'),
310: p_table_alias,
311: p_rownum,
312: 'line_item_id',
313: p_assign_type);

Line 315: add_column_to_group(gcs_utility_pkg.get_dimension_required('NATURAL_ACCOUNT_ID'),

311: p_rownum,
312: 'line_item_id',
313: p_assign_type);
314:
315: add_column_to_group(gcs_utility_pkg.get_dimension_required('NATURAL_ACCOUNT_ID'),
316: p_table_alias,
317: p_rownum,
318: 'natural_account_id',
319: p_assign_type);

Line 321: add_column_to_group(gcs_utility_pkg.get_dimension_required('PRODUCT_ID'),

317: p_rownum,
318: 'natural_account_id',
319: p_assign_type);
320:
321: add_column_to_group(gcs_utility_pkg.get_dimension_required('PRODUCT_ID'),
322: p_table_alias,
323: p_rownum,
324: 'product_id',
325: p_assign_type);

Line 327: add_column_to_group(gcs_utility_pkg.get_dimension_required('PROJECT_ID'),

323: p_rownum,
324: 'product_id',
325: p_assign_type);
326:
327: add_column_to_group(gcs_utility_pkg.get_dimension_required('PROJECT_ID'),
328: p_table_alias,
329: p_rownum,
330: 'project_id',
331: p_assign_type);

Line 333: add_column_to_group(gcs_utility_pkg.get_dimension_required('TASK_ID'),

329: p_rownum,
330: 'project_id',
331: p_assign_type);
332:
333: add_column_to_group(gcs_utility_pkg.get_dimension_required('TASK_ID'),
334: p_table_alias,
335: p_rownum,
336: 'task_id',
337: p_assign_type);

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

335: p_rownum,
336: 'task_id',
337: p_assign_type);
338:
339: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID') = 'Y') THEN
340: add_column_to_group(gcs_utility_pkg.get_dimension_required('USER_DIM10_ID'),
341: p_table_alias,
342: p_rownum,
343: 'user_dim10_id',

Line 340: add_column_to_group(gcs_utility_pkg.get_dimension_required('USER_DIM10_ID'),

336: 'task_id',
337: p_assign_type);
338:
339: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID') = 'Y') THEN
340: add_column_to_group(gcs_utility_pkg.get_dimension_required('USER_DIM10_ID'),
341: p_table_alias,
342: p_rownum,
343: 'user_dim10_id',
344: p_assign_type);

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

343: 'user_dim10_id',
344: p_assign_type);
345: END IF;
346:
347: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID') = 'Y') THEN
348: add_column_to_group(gcs_utility_pkg.get_dimension_required('USER_DIM1_ID'),
349: p_table_alias,
350: p_rownum,
351: 'user_dim1_id',

Line 348: add_column_to_group(gcs_utility_pkg.get_dimension_required('USER_DIM1_ID'),

344: p_assign_type);
345: END IF;
346:
347: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID') = 'Y') THEN
348: add_column_to_group(gcs_utility_pkg.get_dimension_required('USER_DIM1_ID'),
349: p_table_alias,
350: p_rownum,
351: 'user_dim1_id',
352: p_assign_type);

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

351: 'user_dim1_id',
352: p_assign_type);
353: END IF;
354:
355: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID') = 'Y') THEN
356: add_column_to_group(gcs_utility_pkg.get_dimension_required('USER_DIM2_ID'),
357: p_table_alias,
358: p_rownum,
359: 'user_dim2_id',

Line 356: add_column_to_group(gcs_utility_pkg.get_dimension_required('USER_DIM2_ID'),

352: p_assign_type);
353: END IF;
354:
355: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID') = 'Y') THEN
356: add_column_to_group(gcs_utility_pkg.get_dimension_required('USER_DIM2_ID'),
357: p_table_alias,
358: p_rownum,
359: 'user_dim2_id',
360: p_assign_type);

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

359: 'user_dim2_id',
360: p_assign_type);
361: END IF;
362:
363: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID') = 'Y') THEN
364: add_column_to_group(gcs_utility_pkg.get_dimension_required('USER_DIM3_ID'),
365: p_table_alias,
366: p_rownum,
367: 'user_dim3_id',

Line 364: add_column_to_group(gcs_utility_pkg.get_dimension_required('USER_DIM3_ID'),

360: p_assign_type);
361: END IF;
362:
363: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID') = 'Y') THEN
364: add_column_to_group(gcs_utility_pkg.get_dimension_required('USER_DIM3_ID'),
365: p_table_alias,
366: p_rownum,
367: 'user_dim3_id',
368: p_assign_type);

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

367: 'user_dim3_id',
368: p_assign_type);
369: END IF;
370:
371: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID') = 'Y') THEN
372: add_column_to_group(gcs_utility_pkg.get_dimension_required('USER_DIM4_ID'),
373: p_table_alias,
374: p_rownum,
375: 'user_dim4_id',

Line 372: add_column_to_group(gcs_utility_pkg.get_dimension_required('USER_DIM4_ID'),

368: p_assign_type);
369: END IF;
370:
371: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID') = 'Y') THEN
372: add_column_to_group(gcs_utility_pkg.get_dimension_required('USER_DIM4_ID'),
373: p_table_alias,
374: p_rownum,
375: 'user_dim4_id',
376: p_assign_type);

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

375: 'user_dim4_id',
376: p_assign_type);
377: END IF;
378:
379: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID') = 'Y') THEN
380: add_column_to_group(gcs_utility_pkg.get_dimension_required('USER_DIM5_ID'),
381: p_table_alias,
382: p_rownum,
383: 'user_dim5_id',

Line 380: add_column_to_group(gcs_utility_pkg.get_dimension_required('USER_DIM5_ID'),

376: p_assign_type);
377: END IF;
378:
379: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID') = 'Y') THEN
380: add_column_to_group(gcs_utility_pkg.get_dimension_required('USER_DIM5_ID'),
381: p_table_alias,
382: p_rownum,
383: 'user_dim5_id',
384: p_assign_type);

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

383: 'user_dim5_id',
384: p_assign_type);
385: END IF;
386:
387: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID') = 'Y') THEN
388: add_column_to_group(gcs_utility_pkg.get_dimension_required('USER_DIM6_ID'),
389: p_table_alias,
390: p_rownum,
391: 'user_dim6_id',

Line 388: add_column_to_group(gcs_utility_pkg.get_dimension_required('USER_DIM6_ID'),

384: p_assign_type);
385: END IF;
386:
387: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID') = 'Y') THEN
388: add_column_to_group(gcs_utility_pkg.get_dimension_required('USER_DIM6_ID'),
389: p_table_alias,
390: p_rownum,
391: 'user_dim6_id',
392: p_assign_type);

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

391: 'user_dim6_id',
392: p_assign_type);
393: END IF;
394:
395: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID') = 'Y') THEN
396: add_column_to_group(gcs_utility_pkg.get_dimension_required('USER_DIM7_ID'),
397: p_table_alias,
398: p_rownum,
399: 'user_dim7_id',

Line 396: add_column_to_group(gcs_utility_pkg.get_dimension_required('USER_DIM7_ID'),

392: p_assign_type);
393: END IF;
394:
395: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID') = 'Y') THEN
396: add_column_to_group(gcs_utility_pkg.get_dimension_required('USER_DIM7_ID'),
397: p_table_alias,
398: p_rownum,
399: 'user_dim7_id',
400: p_assign_type);

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

399: 'user_dim7_id',
400: p_assign_type);
401: END IF;
402:
403: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID') = 'Y') THEN
404: add_column_to_group(gcs_utility_pkg.get_dimension_required('USER_DIM8_ID'),
405: p_table_alias,
406: p_rownum,
407: 'user_dim8_id',

Line 404: add_column_to_group(gcs_utility_pkg.get_dimension_required('USER_DIM8_ID'),

400: p_assign_type);
401: END IF;
402:
403: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID') = 'Y') THEN
404: add_column_to_group(gcs_utility_pkg.get_dimension_required('USER_DIM8_ID'),
405: p_table_alias,
406: p_rownum,
407: 'user_dim8_id',
408: p_assign_type);

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

407: 'user_dim8_id',
408: p_assign_type);
409: END IF;
410:
411: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM9_ID') = 'Y') THEN
412: add_column_to_group(gcs_utility_pkg.get_dimension_required('USER_DIM9_ID'),
413: p_table_alias,
414: p_rownum,
415: 'user_dim9_id',

Line 412: add_column_to_group(gcs_utility_pkg.get_dimension_required('USER_DIM9_ID'),

408: p_assign_type);
409: END IF;
410:
411: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM9_ID') = 'Y') THEN
412: add_column_to_group(gcs_utility_pkg.get_dimension_required('USER_DIM9_ID'),
413: p_table_alias,
414: p_rownum,
415: 'user_dim9_id',
416: p_assign_type);