APPS.GCS_XML_DYNAMIC_PKG dependencies on GCS_UTILITY_PKG

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

24: END IF;
25: END add_order_clause_to_list;
26: PROCEDURE build_order_clause_list(p_rownum IN OUT NOCOPY NUMBER,
27: p_xml_file_type IN VARCHAR2) IS
28: l_dim_info gcs_utility_pkg.t_hash_gcs_dimension_info := gcs_utility_pkg.g_gcs_dimension_info;
29: BEGIN
30: -- Santosh 5234796
31: IF (p_xml_file_type = 'DSLOAD') THEN
32: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('LINE_ITEM_ID'),

Line 32: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('LINE_ITEM_ID'),

28: l_dim_info gcs_utility_pkg.t_hash_gcs_dimension_info := gcs_utility_pkg.g_gcs_dimension_info;
29: BEGIN
30: -- Santosh 5234796
31: IF (p_xml_file_type = 'DSLOAD') THEN
32: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('LINE_ITEM_ID'),
33: 'LINE_ITEM_DISPLAY_CODE',
34: 'gbit',
35: p_rownum,
36: p_xml_file_type);

Line 37: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('CHANNEL_ID'),

33: 'LINE_ITEM_DISPLAY_CODE',
34: 'gbit',
35: p_rownum,
36: p_xml_file_type);
37: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('CHANNEL_ID'),
38: 'CHANNEL_DISPLAY_CODE',
39: 'gbit',
40: p_rownum,
41: p_xml_file_type);

Line 42: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('CUSTOMER_ID'),

38: 'CHANNEL_DISPLAY_CODE',
39: 'gbit',
40: p_rownum,
41: p_xml_file_type);
42: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('CUSTOMER_ID'),
43: 'CUSTOMER_DISPLAY_CODE',
44: 'gbit',
45: p_rownum,
46: p_xml_file_type);

Line 47: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('FINANCIAL_ELEM_ID'),

43: 'CUSTOMER_DISPLAY_CODE',
44: 'gbit',
45: p_rownum,
46: p_xml_file_type);
47: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('FINANCIAL_ELEM_ID'),
48: 'FINANCIAL_ELEM_DISPLAY_CODE',
49: 'gbit',
50: p_rownum,
51: p_xml_file_type);

Line 52: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('NATURAL_ACCOUNT_ID'),

48: 'FINANCIAL_ELEM_DISPLAY_CODE',
49: 'gbit',
50: p_rownum,
51: p_xml_file_type);
52: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('NATURAL_ACCOUNT_ID'),
53: 'NATURAL_ACCOUNT_DISPLAY_CODE',
54: 'gbit',
55: p_rownum,
56: p_xml_file_type);

Line 57: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('PRODUCT_ID'),

53: 'NATURAL_ACCOUNT_DISPLAY_CODE',
54: 'gbit',
55: p_rownum,
56: p_xml_file_type);
57: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('PRODUCT_ID'),
58: 'PRODUCT_DISPLAY_CODE',
59: 'gbit',
60: p_rownum,
61: p_xml_file_type);

Line 62: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('PROJECT_ID'),

58: 'PRODUCT_DISPLAY_CODE',
59: 'gbit',
60: p_rownum,
61: p_xml_file_type);
62: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('PROJECT_ID'),
63: 'PROJECT_DISPLAY_CODE',
64: 'gbit',
65: p_rownum,
66: p_xml_file_type);

Line 67: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('TASK_ID'),

63: 'PROJECT_DISPLAY_CODE',
64: 'gbit',
65: p_rownum,
66: p_xml_file_type);
67: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('TASK_ID'),
68: 'TASK_DISPLAY_CODE',
69: 'gbit',
70: p_rownum,
71: p_xml_file_type);

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

68: 'TASK_DISPLAY_CODE',
69: 'gbit',
70: p_rownum,
71: p_xml_file_type);
72: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID') = 'Y') THEN
73: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID'),
74: 'USER_DIM10_DISPLAY_CODE',
75: 'gbit',
76: p_rownum,

Line 73: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID'),

69: 'gbit',
70: p_rownum,
71: p_xml_file_type);
72: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID') = 'Y') THEN
73: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID'),
74: 'USER_DIM10_DISPLAY_CODE',
75: 'gbit',
76: p_rownum,
77: p_xml_file_type);

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

75: 'gbit',
76: p_rownum,
77: p_xml_file_type);
78: END IF;
79: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID') = 'Y') THEN
80: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID'),
81: 'USER_DIM1_DISPLAY_CODE',
82: 'gbit',
83: p_rownum,

Line 80: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID'),

76: p_rownum,
77: p_xml_file_type);
78: END IF;
79: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID') = 'Y') THEN
80: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID'),
81: 'USER_DIM1_DISPLAY_CODE',
82: 'gbit',
83: p_rownum,
84: p_xml_file_type);

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

82: 'gbit',
83: p_rownum,
84: p_xml_file_type);
85: END IF;
86: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID') = 'Y') THEN
87: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID'),
88: 'USER_DIM2_DISPLAY_CODE',
89: 'gbit',
90: p_rownum,

Line 87: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID'),

83: p_rownum,
84: p_xml_file_type);
85: END IF;
86: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID') = 'Y') THEN
87: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID'),
88: 'USER_DIM2_DISPLAY_CODE',
89: 'gbit',
90: p_rownum,
91: p_xml_file_type);

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

89: 'gbit',
90: p_rownum,
91: p_xml_file_type);
92: END IF;
93: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID') = 'Y') THEN
94: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID'),
95: 'USER_DIM3_DISPLAY_CODE',
96: 'gbit',
97: p_rownum,

Line 94: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID'),

90: p_rownum,
91: p_xml_file_type);
92: END IF;
93: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID') = 'Y') THEN
94: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID'),
95: 'USER_DIM3_DISPLAY_CODE',
96: 'gbit',
97: p_rownum,
98: p_xml_file_type);

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

96: 'gbit',
97: p_rownum,
98: p_xml_file_type);
99: END IF;
100: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID') = 'Y') THEN
101: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID'),
102: 'USER_DIM4_DISPLAY_CODE',
103: 'gbit',
104: p_rownum,

Line 101: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID'),

97: p_rownum,
98: p_xml_file_type);
99: END IF;
100: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID') = 'Y') THEN
101: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID'),
102: 'USER_DIM4_DISPLAY_CODE',
103: 'gbit',
104: p_rownum,
105: p_xml_file_type);

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

103: 'gbit',
104: p_rownum,
105: p_xml_file_type);
106: END IF;
107: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID') = 'Y') THEN
108: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID'),
109: 'USER_DIM5_DISPLAY_CODE',
110: 'gbit',
111: p_rownum,

Line 108: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID'),

104: p_rownum,
105: p_xml_file_type);
106: END IF;
107: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID') = 'Y') THEN
108: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID'),
109: 'USER_DIM5_DISPLAY_CODE',
110: 'gbit',
111: p_rownum,
112: p_xml_file_type);

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

110: 'gbit',
111: p_rownum,
112: p_xml_file_type);
113: END IF;
114: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID') = 'Y') THEN
115: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID'),
116: 'USER_DIM6_DISPLAY_CODE',
117: 'gbit',
118: p_rownum,

Line 115: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID'),

111: p_rownum,
112: p_xml_file_type);
113: END IF;
114: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID') = 'Y') THEN
115: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID'),
116: 'USER_DIM6_DISPLAY_CODE',
117: 'gbit',
118: p_rownum,
119: p_xml_file_type);

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

117: 'gbit',
118: p_rownum,
119: p_xml_file_type);
120: END IF;
121: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID') = 'Y') THEN
122: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID'),
123: 'USER_DIM7_DISPLAY_CODE',
124: 'gbit',
125: p_rownum,

Line 122: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID'),

118: p_rownum,
119: p_xml_file_type);
120: END IF;
121: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID') = 'Y') THEN
122: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID'),
123: 'USER_DIM7_DISPLAY_CODE',
124: 'gbit',
125: p_rownum,
126: p_xml_file_type);

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

124: 'gbit',
125: p_rownum,
126: p_xml_file_type);
127: END IF;
128: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID') = 'Y') THEN
129: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID'),
130: 'USER_DIM8_DISPLAY_CODE',
131: 'gbit',
132: p_rownum,

Line 129: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID'),

125: p_rownum,
126: p_xml_file_type);
127: END IF;
128: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID') = 'Y') THEN
129: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID'),
130: 'USER_DIM8_DISPLAY_CODE',
131: 'gbit',
132: p_rownum,
133: p_xml_file_type);

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

131: 'gbit',
132: p_rownum,
133: p_xml_file_type);
134: END IF;
135: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM9_ID') = 'Y') THEN
136: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM9_ID'),
137: 'USER_DIM9_DISPLAY_CODE',
138: 'gbit',
139: p_rownum,

Line 136: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM9_ID'),

132: p_rownum,
133: p_xml_file_type);
134: END IF;
135: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM9_ID') = 'Y') THEN
136: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM9_ID'),
137: 'USER_DIM9_DISPLAY_CODE',
138: 'gbit',
139: p_rownum,
140: p_xml_file_type);

Line 143: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('LINE_ITEM_ID'),

139: p_rownum,
140: p_xml_file_type);
141: END IF;
142: ELSIF (p_xml_file_type = 'DS') THEN
143: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('LINE_ITEM_ID'),
144: 'line_item_name',
145: 'flib',
146: p_rownum,
147: p_xml_file_type);

Line 148: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('CHANNEL_ID'),

144: 'line_item_name',
145: 'flib',
146: p_rownum,
147: p_xml_file_type);
148: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('CHANNEL_ID'),
149: 'channel_name',
150: 'fchb',
151: p_rownum,
152: p_xml_file_type);

Line 153: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('CUSTOMER_ID'),

149: 'channel_name',
150: 'fchb',
151: p_rownum,
152: p_xml_file_type);
153: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('CUSTOMER_ID'),
154: 'customer_name',
155: 'fcb',
156: p_rownum,
157: p_xml_file_type);

Line 158: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('FINANCIAL_ELEM_ID'),

154: 'customer_name',
155: 'fcb',
156: p_rownum,
157: p_xml_file_type);
158: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('FINANCIAL_ELEM_ID'),
159: 'financial_elem_name',
160: 'ffeb',
161: p_rownum,
162: p_xml_file_type);

Line 163: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('NATURAL_ACCOUNT_ID'),

159: 'financial_elem_name',
160: 'ffeb',
161: p_rownum,
162: p_xml_file_type);
163: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('NATURAL_ACCOUNT_ID'),
164: 'natural_account_name',
165: 'fnab',
166: p_rownum,
167: p_xml_file_type);

Line 168: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('PRODUCT_ID'),

164: 'natural_account_name',
165: 'fnab',
166: p_rownum,
167: p_xml_file_type);
168: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('PRODUCT_ID'),
169: 'product_name',
170: 'fpb',
171: p_rownum,
172: p_xml_file_type);

Line 173: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('PROJECT_ID'),

169: 'product_name',
170: 'fpb',
171: p_rownum,
172: p_xml_file_type);
173: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('PROJECT_ID'),
174: 'project_name',
175: 'fpjb',
176: p_rownum,
177: p_xml_file_type);

Line 178: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('TASK_ID'),

174: 'project_name',
175: 'fpjb',
176: p_rownum,
177: p_xml_file_type);
178: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('TASK_ID'),
179: 'task_name',
180: 'ftb',
181: p_rownum,
182: p_xml_file_type);

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

179: 'task_name',
180: 'ftb',
181: p_rownum,
182: p_xml_file_type);
183: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID') = 'Y') THEN
184: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID'),
185: 'user_dim10_name',
186: 'fud10',
187: p_rownum,

Line 184: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID'),

180: 'ftb',
181: p_rownum,
182: p_xml_file_type);
183: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID') = 'Y') THEN
184: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID'),
185: 'user_dim10_name',
186: 'fud10',
187: p_rownum,
188: p_xml_file_type);

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

186: 'fud10',
187: p_rownum,
188: p_xml_file_type);
189: END IF;
190: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID') = 'Y') THEN
191: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID'),
192: 'user_dim1_name',
193: 'fud1',
194: p_rownum,

Line 191: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID'),

187: p_rownum,
188: p_xml_file_type);
189: END IF;
190: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID') = 'Y') THEN
191: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID'),
192: 'user_dim1_name',
193: 'fud1',
194: p_rownum,
195: p_xml_file_type);

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

193: 'fud1',
194: p_rownum,
195: p_xml_file_type);
196: END IF;
197: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID') = 'Y') THEN
198: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID'),
199: 'user_dim2_name',
200: 'fud2',
201: p_rownum,

Line 198: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID'),

194: p_rownum,
195: p_xml_file_type);
196: END IF;
197: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID') = 'Y') THEN
198: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID'),
199: 'user_dim2_name',
200: 'fud2',
201: p_rownum,
202: p_xml_file_type);

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

200: 'fud2',
201: p_rownum,
202: p_xml_file_type);
203: END IF;
204: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID') = 'Y') THEN
205: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID'),
206: 'user_dim3_name',
207: 'fud3',
208: p_rownum,

Line 205: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID'),

201: p_rownum,
202: p_xml_file_type);
203: END IF;
204: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID') = 'Y') THEN
205: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID'),
206: 'user_dim3_name',
207: 'fud3',
208: p_rownum,
209: p_xml_file_type);

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

207: 'fud3',
208: p_rownum,
209: p_xml_file_type);
210: END IF;
211: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID') = 'Y') THEN
212: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID'),
213: 'user_dim4_name',
214: 'fud4',
215: p_rownum,

Line 212: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID'),

208: p_rownum,
209: p_xml_file_type);
210: END IF;
211: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID') = 'Y') THEN
212: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID'),
213: 'user_dim4_name',
214: 'fud4',
215: p_rownum,
216: p_xml_file_type);

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

214: 'fud4',
215: p_rownum,
216: p_xml_file_type);
217: END IF;
218: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID') = 'Y') THEN
219: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID'),
220: 'user_dim5_name',
221: 'fud5',
222: p_rownum,

Line 219: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID'),

215: p_rownum,
216: p_xml_file_type);
217: END IF;
218: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID') = 'Y') THEN
219: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID'),
220: 'user_dim5_name',
221: 'fud5',
222: p_rownum,
223: p_xml_file_type);

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

221: 'fud5',
222: p_rownum,
223: p_xml_file_type);
224: END IF;
225: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID') = 'Y') THEN
226: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID'),
227: 'user_dim6_name',
228: 'fud6',
229: p_rownum,

Line 226: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID'),

222: p_rownum,
223: p_xml_file_type);
224: END IF;
225: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID') = 'Y') THEN
226: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID'),
227: 'user_dim6_name',
228: 'fud6',
229: p_rownum,
230: p_xml_file_type);

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

228: 'fud6',
229: p_rownum,
230: p_xml_file_type);
231: END IF;
232: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID') = 'Y') THEN
233: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID'),
234: 'user_dim7_name',
235: 'fud7',
236: p_rownum,

Line 233: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID'),

229: p_rownum,
230: p_xml_file_type);
231: END IF;
232: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID') = 'Y') THEN
233: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID'),
234: 'user_dim7_name',
235: 'fud7',
236: p_rownum,
237: p_xml_file_type);

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

235: 'fud7',
236: p_rownum,
237: p_xml_file_type);
238: END IF;
239: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID') = 'Y') THEN
240: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID'),
241: 'user_dim8_name',
242: 'fud8',
243: p_rownum,

Line 240: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID'),

236: p_rownum,
237: p_xml_file_type);
238: END IF;
239: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID') = 'Y') THEN
240: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID'),
241: 'user_dim8_name',
242: 'fud8',
243: p_rownum,
244: p_xml_file_type);

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

242: 'fud8',
243: p_rownum,
244: p_xml_file_type);
245: END IF;
246: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM9_ID') = 'Y') THEN
247: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM9_ID'),
248: 'user_dim9_name',
249: 'fud9',
250: p_rownum,

Line 247: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM9_ID'),

243: p_rownum,
244: p_xml_file_type);
245: END IF;
246: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM9_ID') = 'Y') THEN
247: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM9_ID'),
248: 'user_dim9_name',
249: 'fud9',
250: p_rownum,
251: p_xml_file_type);

Line 254: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('CHANNEL_ID'),

250: p_rownum,
251: p_xml_file_type);
252: END IF;
253: ELSIF (p_xml_file_type = 'OGL') THEN
254: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('CHANNEL_ID'),
255: 'channel_id',
256: 'fb',
257: p_rownum,
258: p_xml_file_type);

Line 259: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('CUSTOMER_ID'),

255: 'channel_id',
256: 'fb',
257: p_rownum,
258: p_xml_file_type);
259: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('CUSTOMER_ID'),
260: 'customer_id',
261: 'fb',
262: p_rownum,
263: p_xml_file_type);

Line 264: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('FINANCIAL_ELEM_ID'),

260: 'customer_id',
261: 'fb',
262: p_rownum,
263: p_xml_file_type);
264: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('FINANCIAL_ELEM_ID'),
265: 'financial_elem_id',
266: 'fb',
267: p_rownum,
268: p_xml_file_type);

Line 269: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('NATURAL_ACCOUNT_ID'),

265: 'financial_elem_id',
266: 'fb',
267: p_rownum,
268: p_xml_file_type);
269: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('NATURAL_ACCOUNT_ID'),
270: 'natural_account_id',
271: 'fb',
272: p_rownum,
273: p_xml_file_type);

Line 274: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('PRODUCT_ID'),

270: 'natural_account_id',
271: 'fb',
272: p_rownum,
273: p_xml_file_type);
274: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('PRODUCT_ID'),
275: 'product_id',
276: 'fb',
277: p_rownum,
278: p_xml_file_type);

Line 279: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('PROJECT_ID'),

275: 'product_id',
276: 'fb',
277: p_rownum,
278: p_xml_file_type);
279: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('PROJECT_ID'),
280: 'project_id',
281: 'fb',
282: p_rownum,
283: p_xml_file_type);

Line 284: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('TASK_ID'),

280: 'project_id',
281: 'fb',
282: p_rownum,
283: p_xml_file_type);
284: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('TASK_ID'),
285: 'task_id',
286: 'fb',
287: p_rownum,
288: p_xml_file_type);

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

285: 'task_id',
286: 'fb',
287: p_rownum,
288: p_xml_file_type);
289: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID') = 'Y') THEN
290: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID'),
291: 'user_dim10_id',
292: 'fb',
293: p_rownum,

Line 290: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID'),

286: 'fb',
287: p_rownum,
288: p_xml_file_type);
289: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID') = 'Y') THEN
290: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID'),
291: 'user_dim10_id',
292: 'fb',
293: p_rownum,
294: p_xml_file_type);

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

292: 'fb',
293: p_rownum,
294: p_xml_file_type);
295: END IF;
296: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID') = 'Y') THEN
297: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID'),
298: 'user_dim1_id',
299: 'fb',
300: p_rownum,

Line 297: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID'),

293: p_rownum,
294: p_xml_file_type);
295: END IF;
296: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID') = 'Y') THEN
297: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID'),
298: 'user_dim1_id',
299: 'fb',
300: p_rownum,
301: p_xml_file_type);

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

299: 'fb',
300: p_rownum,
301: p_xml_file_type);
302: END IF;
303: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID') = 'Y') THEN
304: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID'),
305: 'user_dim2_id',
306: 'fb',
307: p_rownum,

Line 304: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID'),

300: p_rownum,
301: p_xml_file_type);
302: END IF;
303: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID') = 'Y') THEN
304: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID'),
305: 'user_dim2_id',
306: 'fb',
307: p_rownum,
308: p_xml_file_type);

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

306: 'fb',
307: p_rownum,
308: p_xml_file_type);
309: END IF;
310: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID') = 'Y') THEN
311: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID'),
312: 'user_dim3_id',
313: 'fb',
314: p_rownum,

Line 311: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID'),

307: p_rownum,
308: p_xml_file_type);
309: END IF;
310: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID') = 'Y') THEN
311: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID'),
312: 'user_dim3_id',
313: 'fb',
314: p_rownum,
315: p_xml_file_type);

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

313: 'fb',
314: p_rownum,
315: p_xml_file_type);
316: END IF;
317: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID') = 'Y') THEN
318: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID'),
319: 'user_dim4_id',
320: 'fb',
321: p_rownum,

Line 318: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID'),

314: p_rownum,
315: p_xml_file_type);
316: END IF;
317: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID') = 'Y') THEN
318: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID'),
319: 'user_dim4_id',
320: 'fb',
321: p_rownum,
322: p_xml_file_type);

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

320: 'fb',
321: p_rownum,
322: p_xml_file_type);
323: END IF;
324: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID') = 'Y') THEN
325: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID'),
326: 'user_dim5_id',
327: 'fb',
328: p_rownum,

Line 325: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID'),

321: p_rownum,
322: p_xml_file_type);
323: END IF;
324: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID') = 'Y') THEN
325: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID'),
326: 'user_dim5_id',
327: 'fb',
328: p_rownum,
329: p_xml_file_type);

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

327: 'fb',
328: p_rownum,
329: p_xml_file_type);
330: END IF;
331: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID') = 'Y') THEN
332: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID'),
333: 'user_dim6_id',
334: 'fb',
335: p_rownum,

Line 332: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID'),

328: p_rownum,
329: p_xml_file_type);
330: END IF;
331: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID') = 'Y') THEN
332: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID'),
333: 'user_dim6_id',
334: 'fb',
335: p_rownum,
336: p_xml_file_type);

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

334: 'fb',
335: p_rownum,
336: p_xml_file_type);
337: END IF;
338: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID') = 'Y') THEN
339: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID'),
340: 'user_dim7_id',
341: 'fb',
342: p_rownum,

Line 339: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID'),

335: p_rownum,
336: p_xml_file_type);
337: END IF;
338: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID') = 'Y') THEN
339: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID'),
340: 'user_dim7_id',
341: 'fb',
342: p_rownum,
343: p_xml_file_type);

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

341: 'fb',
342: p_rownum,
343: p_xml_file_type);
344: END IF;
345: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID') = 'Y') THEN
346: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID'),
347: 'user_dim8_id',
348: 'fb',
349: p_rownum,

Line 346: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID'),

342: p_rownum,
343: p_xml_file_type);
344: END IF;
345: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID') = 'Y') THEN
346: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID'),
347: 'user_dim8_id',
348: 'fb',
349: p_rownum,
350: p_xml_file_type);

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

348: 'fb',
349: p_rownum,
350: p_xml_file_type);
351: END IF;
352: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM9_ID') = 'Y') THEN
353: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM9_ID'),
354: 'user_dim9_id',
355: 'fb',
356: p_rownum,

Line 353: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM9_ID'),

349: p_rownum,
350: p_xml_file_type);
351: END IF;
352: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM9_ID') = 'Y') THEN
353: add_order_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM9_ID'),
354: 'user_dim9_id',
355: 'fb',
356: p_rownum,
357: p_xml_file_type);

Line 361: add_order_clause_to_list(gcs_utility_pkg.get_dimension_required('CHANNEL_ID'),

357: p_xml_file_type);
358: END IF;
359: ELSE
360: -- FOR 'NOT_RULES'
361: add_order_clause_to_list(gcs_utility_pkg.get_dimension_required('CHANNEL_ID'),
362: 'channel_name',
363: 'fchb',
364: p_rownum,
365: p_xml_file_type);

Line 366: add_order_clause_to_list(gcs_utility_pkg.get_dimension_required('CUSTOMER_ID'),

362: 'channel_name',
363: 'fchb',
364: p_rownum,
365: p_xml_file_type);
366: add_order_clause_to_list(gcs_utility_pkg.get_dimension_required('CUSTOMER_ID'),
367: 'customer_name',
368: 'fcb',
369: p_rownum,
370: p_xml_file_type);

Line 371: add_order_clause_to_list(gcs_utility_pkg.get_dimension_required('FINANCIAL_ELEM_ID'),

367: 'customer_name',
368: 'fcb',
369: p_rownum,
370: p_xml_file_type);
371: add_order_clause_to_list(gcs_utility_pkg.get_dimension_required('FINANCIAL_ELEM_ID'),
372: 'financial_elem_name',
373: 'ffeb',
374: p_rownum,
375: p_xml_file_type);

Line 376: add_order_clause_to_list(gcs_utility_pkg.get_dimension_required('NATURAL_ACCOUNT_ID'),

372: 'financial_elem_name',
373: 'ffeb',
374: p_rownum,
375: p_xml_file_type);
376: add_order_clause_to_list(gcs_utility_pkg.get_dimension_required('NATURAL_ACCOUNT_ID'),
377: 'natural_account_name',
378: 'fnab',
379: p_rownum,
380: p_xml_file_type);

Line 381: add_order_clause_to_list(gcs_utility_pkg.get_dimension_required('PRODUCT_ID'),

377: 'natural_account_name',
378: 'fnab',
379: p_rownum,
380: p_xml_file_type);
381: add_order_clause_to_list(gcs_utility_pkg.get_dimension_required('PRODUCT_ID'),
382: 'product_name',
383: 'fpb',
384: p_rownum,
385: p_xml_file_type);

Line 386: add_order_clause_to_list(gcs_utility_pkg.get_dimension_required('PROJECT_ID'),

382: 'product_name',
383: 'fpb',
384: p_rownum,
385: p_xml_file_type);
386: add_order_clause_to_list(gcs_utility_pkg.get_dimension_required('PROJECT_ID'),
387: 'project_name',
388: 'fpjb',
389: p_rownum,
390: p_xml_file_type);

Line 391: add_order_clause_to_list(gcs_utility_pkg.get_dimension_required('TASK_ID'),

387: 'project_name',
388: 'fpjb',
389: p_rownum,
390: p_xml_file_type);
391: add_order_clause_to_list(gcs_utility_pkg.get_dimension_required('TASK_ID'),
392: 'task_name',
393: 'ftb',
394: p_rownum,
395: p_xml_file_type);

Line 396: IF (gcs_utility_pkg.get_dimension_required('USER_DIM10_ID') = 'Y') THEN

392: 'task_name',
393: 'ftb',
394: p_rownum,
395: p_xml_file_type);
396: IF (gcs_utility_pkg.get_dimension_required('USER_DIM10_ID') = 'Y') THEN
397: add_order_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM10_ID'),
398: 'user_dim10_name',
399: 'fud10',
400: p_rownum,

Line 397: add_order_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM10_ID'),

393: 'ftb',
394: p_rownum,
395: p_xml_file_type);
396: IF (gcs_utility_pkg.get_dimension_required('USER_DIM10_ID') = 'Y') THEN
397: add_order_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM10_ID'),
398: 'user_dim10_name',
399: 'fud10',
400: p_rownum,
401: p_xml_file_type);

Line 403: IF (gcs_utility_pkg.get_dimension_required('USER_DIM1_ID') = 'Y') THEN

399: 'fud10',
400: p_rownum,
401: p_xml_file_type);
402: END IF;
403: IF (gcs_utility_pkg.get_dimension_required('USER_DIM1_ID') = 'Y') THEN
404: add_order_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM1_ID'),
405: 'user_dim1_name',
406: 'fud1',
407: p_rownum,

Line 404: add_order_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM1_ID'),

400: p_rownum,
401: p_xml_file_type);
402: END IF;
403: IF (gcs_utility_pkg.get_dimension_required('USER_DIM1_ID') = 'Y') THEN
404: add_order_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM1_ID'),
405: 'user_dim1_name',
406: 'fud1',
407: p_rownum,
408: p_xml_file_type);

Line 410: IF (gcs_utility_pkg.get_dimension_required('USER_DIM2_ID') = 'Y') THEN

406: 'fud1',
407: p_rownum,
408: p_xml_file_type);
409: END IF;
410: IF (gcs_utility_pkg.get_dimension_required('USER_DIM2_ID') = 'Y') THEN
411: add_order_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM2_ID'),
412: 'user_dim2_name',
413: 'fud2',
414: p_rownum,

Line 411: add_order_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM2_ID'),

407: p_rownum,
408: p_xml_file_type);
409: END IF;
410: IF (gcs_utility_pkg.get_dimension_required('USER_DIM2_ID') = 'Y') THEN
411: add_order_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM2_ID'),
412: 'user_dim2_name',
413: 'fud2',
414: p_rownum,
415: p_xml_file_type);

Line 417: IF (gcs_utility_pkg.get_dimension_required('USER_DIM3_ID') = 'Y') THEN

413: 'fud2',
414: p_rownum,
415: p_xml_file_type);
416: END IF;
417: IF (gcs_utility_pkg.get_dimension_required('USER_DIM3_ID') = 'Y') THEN
418: add_order_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM3_ID'),
419: 'user_dim3_name',
420: 'fud3',
421: p_rownum,

Line 418: add_order_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM3_ID'),

414: p_rownum,
415: p_xml_file_type);
416: END IF;
417: IF (gcs_utility_pkg.get_dimension_required('USER_DIM3_ID') = 'Y') THEN
418: add_order_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM3_ID'),
419: 'user_dim3_name',
420: 'fud3',
421: p_rownum,
422: p_xml_file_type);

Line 424: IF (gcs_utility_pkg.get_dimension_required('USER_DIM4_ID') = 'Y') THEN

420: 'fud3',
421: p_rownum,
422: p_xml_file_type);
423: END IF;
424: IF (gcs_utility_pkg.get_dimension_required('USER_DIM4_ID') = 'Y') THEN
425: add_order_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM4_ID'),
426: 'user_dim4_name',
427: 'fud4',
428: p_rownum,

Line 425: add_order_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM4_ID'),

421: p_rownum,
422: p_xml_file_type);
423: END IF;
424: IF (gcs_utility_pkg.get_dimension_required('USER_DIM4_ID') = 'Y') THEN
425: add_order_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM4_ID'),
426: 'user_dim4_name',
427: 'fud4',
428: p_rownum,
429: p_xml_file_type);

Line 431: IF (gcs_utility_pkg.get_dimension_required('USER_DIM5_ID') = 'Y') THEN

427: 'fud4',
428: p_rownum,
429: p_xml_file_type);
430: END IF;
431: IF (gcs_utility_pkg.get_dimension_required('USER_DIM5_ID') = 'Y') THEN
432: add_order_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM5_ID'),
433: 'user_dim5_name',
434: 'fud5',
435: p_rownum,

Line 432: add_order_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM5_ID'),

428: p_rownum,
429: p_xml_file_type);
430: END IF;
431: IF (gcs_utility_pkg.get_dimension_required('USER_DIM5_ID') = 'Y') THEN
432: add_order_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM5_ID'),
433: 'user_dim5_name',
434: 'fud5',
435: p_rownum,
436: p_xml_file_type);

Line 438: IF (gcs_utility_pkg.get_dimension_required('USER_DIM6_ID') = 'Y') THEN

434: 'fud5',
435: p_rownum,
436: p_xml_file_type);
437: END IF;
438: IF (gcs_utility_pkg.get_dimension_required('USER_DIM6_ID') = 'Y') THEN
439: add_order_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM6_ID'),
440: 'user_dim6_name',
441: 'fud6',
442: p_rownum,

Line 439: add_order_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM6_ID'),

435: p_rownum,
436: p_xml_file_type);
437: END IF;
438: IF (gcs_utility_pkg.get_dimension_required('USER_DIM6_ID') = 'Y') THEN
439: add_order_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM6_ID'),
440: 'user_dim6_name',
441: 'fud6',
442: p_rownum,
443: p_xml_file_type);

Line 445: IF (gcs_utility_pkg.get_dimension_required('USER_DIM7_ID') = 'Y') THEN

441: 'fud6',
442: p_rownum,
443: p_xml_file_type);
444: END IF;
445: IF (gcs_utility_pkg.get_dimension_required('USER_DIM7_ID') = 'Y') THEN
446: add_order_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM7_ID'),
447: 'user_dim7_name',
448: 'fud7',
449: p_rownum,

Line 446: add_order_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM7_ID'),

442: p_rownum,
443: p_xml_file_type);
444: END IF;
445: IF (gcs_utility_pkg.get_dimension_required('USER_DIM7_ID') = 'Y') THEN
446: add_order_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM7_ID'),
447: 'user_dim7_name',
448: 'fud7',
449: p_rownum,
450: p_xml_file_type);

Line 452: IF (gcs_utility_pkg.get_dimension_required('USER_DIM8_ID') = 'Y') THEN

448: 'fud7',
449: p_rownum,
450: p_xml_file_type);
451: END IF;
452: IF (gcs_utility_pkg.get_dimension_required('USER_DIM8_ID') = 'Y') THEN
453: add_order_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM8_ID'),
454: 'user_dim8_name',
455: 'fud8',
456: p_rownum,

Line 453: add_order_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM8_ID'),

449: p_rownum,
450: p_xml_file_type);
451: END IF;
452: IF (gcs_utility_pkg.get_dimension_required('USER_DIM8_ID') = 'Y') THEN
453: add_order_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM8_ID'),
454: 'user_dim8_name',
455: 'fud8',
456: p_rownum,
457: p_xml_file_type);

Line 459: IF (gcs_utility_pkg.get_dimension_required('USER_DIM9_ID') = 'Y') THEN

455: 'fud8',
456: p_rownum,
457: p_xml_file_type);
458: END IF;
459: IF (gcs_utility_pkg.get_dimension_required('USER_DIM9_ID') = 'Y') THEN
460: add_order_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM9_ID'),
461: 'user_dim9_name',
462: 'fud9',
463: p_rownum,

Line 460: add_order_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM9_ID'),

456: p_rownum,
457: p_xml_file_type);
458: END IF;
459: IF (gcs_utility_pkg.get_dimension_required('USER_DIM9_ID') = 'Y') THEN
460: add_order_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM9_ID'),
461: 'user_dim9_name',
462: 'fud9',
463: p_rownum,
464: p_xml_file_type);

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

652: END IF;
653: END add_clause_to_list;
654: PROCEDURE build_select_clause_list(p_rownum IN OUT NOCOPY NUMBER,
655: p_xml_file_type IN VARCHAR2) IS
656: l_dim_info gcs_utility_pkg.t_hash_gcs_dimension_info := gcs_utility_pkg.g_gcs_dimension_info;
657: BEGIN
658: --BUG 5147886
659: -- Santosh 5234796
660: IF (p_xml_file_type = 'DSLOAD') THEN

Line 661: add_select_clause_dsload_list(gcs_utility_pkg.get_fem_dim_required('CHANNEL_ID'),

657: BEGIN
658: --BUG 5147886
659: -- Santosh 5234796
660: IF (p_xml_file_type = 'DSLOAD') THEN
661: add_select_clause_dsload_list(gcs_utility_pkg.get_fem_dim_required('CHANNEL_ID'),
662: 'CHANNEL_DISPLAY_CODE',
663: 'channel_name',
664: 'gbit',
665: p_rownum,

Line 667: add_select_clause_dsload_list(gcs_utility_pkg.get_fem_dim_required('CUSTOMER_ID'),

663: 'channel_name',
664: 'gbit',
665: p_rownum,
666: p_xml_file_type);
667: add_select_clause_dsload_list(gcs_utility_pkg.get_fem_dim_required('CUSTOMER_ID'),
668: 'CUSTOMER_DISPLAY_CODE',
669: 'customer_name',
670: 'gbit',
671: p_rownum,

Line 674: add_select_clause_dsload_list(gcs_utility_pkg.get_fem_dim_required('FINANCIAL_ELEM_ID'),

670: 'gbit',
671: p_rownum,
672: p_xml_file_type);
673:
674: add_select_clause_dsload_list(gcs_utility_pkg.get_fem_dim_required('FINANCIAL_ELEM_ID'),
675: 'FINANCIAL_ELEM_DISPLAY_CODE',
676: 'financial_elem_name',
677: 'gbit',
678: p_rownum,

Line 681: add_select_clause_dsload_list(gcs_utility_pkg.get_fem_dim_required('NATURAL_ACCOUNT_ID'),

677: 'gbit',
678: p_rownum,
679: p_xml_file_type);
680:
681: add_select_clause_dsload_list(gcs_utility_pkg.get_fem_dim_required('NATURAL_ACCOUNT_ID'),
682: 'NATURAL_ACCOUNT_DISPLAY_CODE',
683: 'natural_account_name',
684: 'gbit',
685: p_rownum,

Line 687: add_select_clause_dsload_list(gcs_utility_pkg.get_fem_dim_required('PRODUCT_ID'),

683: 'natural_account_name',
684: 'gbit',
685: p_rownum,
686: p_xml_file_type);
687: add_select_clause_dsload_list(gcs_utility_pkg.get_fem_dim_required('PRODUCT_ID'),
688: 'PRODUCT_DISPLAY_CODE',
689: 'product_name',
690: 'gbit',
691: p_rownum,

Line 693: add_select_clause_dsload_list(gcs_utility_pkg.get_fem_dim_required('PROJECT_ID'),

689: 'product_name',
690: 'gbit',
691: p_rownum,
692: p_xml_file_type);
693: add_select_clause_dsload_list(gcs_utility_pkg.get_fem_dim_required('PROJECT_ID'),
694: 'PROJECT_DISPLAY_CODE',
695: 'project_name',
696: 'gbit',
697: p_rownum,

Line 699: add_select_clause_dsload_list(gcs_utility_pkg.get_fem_dim_required('TASK_ID'),

695: 'project_name',
696: 'gbit',
697: p_rownum,
698: p_xml_file_type);
699: add_select_clause_dsload_list(gcs_utility_pkg.get_fem_dim_required('TASK_ID'),
700: 'TASK_DISPLAY_CODE',
701: 'task_name',
702: 'gbit',
703: p_rownum,

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

701: 'task_name',
702: 'gbit',
703: p_rownum,
704: p_xml_file_type);
705: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID') = 'Y') THEN
706: add_select_clause_dsload_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID'),
707: 'USER_DIM1_DISPLAY_CODE',
708: 'user_dim1_name',
709: 'gbit',

Line 706: add_select_clause_dsload_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID'),

702: 'gbit',
703: p_rownum,
704: p_xml_file_type);
705: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID') = 'Y') THEN
706: add_select_clause_dsload_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID'),
707: 'USER_DIM1_DISPLAY_CODE',
708: 'user_dim1_name',
709: 'gbit',
710: p_rownum,

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

709: 'gbit',
710: p_rownum,
711: p_xml_file_type);
712: END IF;
713: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID') = 'Y') THEN
714: add_select_clause_dsload_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID'),
715: 'USER_DIM2_DISPLAY_CODE',
716: 'user_dim2_name',
717: 'gbit',

Line 714: add_select_clause_dsload_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID'),

710: p_rownum,
711: p_xml_file_type);
712: END IF;
713: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID') = 'Y') THEN
714: add_select_clause_dsload_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID'),
715: 'USER_DIM2_DISPLAY_CODE',
716: 'user_dim2_name',
717: 'gbit',
718: p_rownum,

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

717: 'gbit',
718: p_rownum,
719: p_xml_file_type);
720: END IF;
721: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID') = 'Y') THEN
722: add_select_clause_dsload_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID'),
723: 'USER_DIM3_DISPLAY_CODE',
724: 'user_dim3_name',
725: 'gbit',

Line 722: add_select_clause_dsload_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID'),

718: p_rownum,
719: p_xml_file_type);
720: END IF;
721: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID') = 'Y') THEN
722: add_select_clause_dsload_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID'),
723: 'USER_DIM3_DISPLAY_CODE',
724: 'user_dim3_name',
725: 'gbit',
726: p_rownum,

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

725: 'gbit',
726: p_rownum,
727: p_xml_file_type);
728: END IF;
729: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID') = 'Y') THEN
730: add_select_clause_dsload_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID'),
731: 'USER_DIM4_DISPLAY_CODE',
732: 'user_dim4_name',
733: 'gbit',

Line 730: add_select_clause_dsload_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID'),

726: p_rownum,
727: p_xml_file_type);
728: END IF;
729: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID') = 'Y') THEN
730: add_select_clause_dsload_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID'),
731: 'USER_DIM4_DISPLAY_CODE',
732: 'user_dim4_name',
733: 'gbit',
734: p_rownum,

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

733: 'gbit',
734: p_rownum,
735: p_xml_file_type);
736: END IF;
737: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID') = 'Y') THEN
738: add_select_clause_dsload_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID'),
739: 'USER_DIM5_DISPLAY_CODE',
740: 'user_dim5_name',
741: 'gbit',

Line 738: add_select_clause_dsload_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID'),

734: p_rownum,
735: p_xml_file_type);
736: END IF;
737: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID') = 'Y') THEN
738: add_select_clause_dsload_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID'),
739: 'USER_DIM5_DISPLAY_CODE',
740: 'user_dim5_name',
741: 'gbit',
742: p_rownum,

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

741: 'gbit',
742: p_rownum,
743: p_xml_file_type);
744: END IF;
745: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID') = 'Y') THEN
746: add_select_clause_dsload_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID'),
747: 'USER_DIM6_DISPLAY_CODE',
748: 'user_dim6_name',
749: 'gbit',

Line 746: add_select_clause_dsload_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID'),

742: p_rownum,
743: p_xml_file_type);
744: END IF;
745: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID') = 'Y') THEN
746: add_select_clause_dsload_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID'),
747: 'USER_DIM6_DISPLAY_CODE',
748: 'user_dim6_name',
749: 'gbit',
750: p_rownum,

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

749: 'gbit',
750: p_rownum,
751: p_xml_file_type);
752: END IF;
753: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID') = 'Y') THEN
754: add_select_clause_dsload_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID'),
755: 'USER_DIM7_DISPLAY_CODE',
756: 'user_dim7_name',
757: 'gbit',

Line 754: add_select_clause_dsload_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID'),

750: p_rownum,
751: p_xml_file_type);
752: END IF;
753: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID') = 'Y') THEN
754: add_select_clause_dsload_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID'),
755: 'USER_DIM7_DISPLAY_CODE',
756: 'user_dim7_name',
757: 'gbit',
758: p_rownum,

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

757: 'gbit',
758: p_rownum,
759: p_xml_file_type);
760: END IF;
761: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID') = 'Y') THEN
762: add_select_clause_dsload_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID'),
763: 'USER_DIM8_DISPLAY_CODE',
764: 'user_dim8_name',
765: 'gbit',

Line 762: add_select_clause_dsload_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID'),

758: p_rownum,
759: p_xml_file_type);
760: END IF;
761: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID') = 'Y') THEN
762: add_select_clause_dsload_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID'),
763: 'USER_DIM8_DISPLAY_CODE',
764: 'user_dim8_name',
765: 'gbit',
766: p_rownum,

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

765: 'gbit',
766: p_rownum,
767: p_xml_file_type);
768: END IF;
769: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM9_ID') = 'Y') THEN
770: add_select_clause_dsload_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM9_ID'),
771: 'USER_DIM9_DISPLAY_CODE',
772: 'user_dim9_name',
773: 'gbit',

Line 770: add_select_clause_dsload_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM9_ID'),

766: p_rownum,
767: p_xml_file_type);
768: END IF;
769: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM9_ID') = 'Y') THEN
770: add_select_clause_dsload_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM9_ID'),
771: 'USER_DIM9_DISPLAY_CODE',
772: 'user_dim9_name',
773: 'gbit',
774: p_rownum,

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

773: 'gbit',
774: p_rownum,
775: p_xml_file_type);
776: END IF;
777: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID') = 'Y') THEN
778: add_select_clause_dsload_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID'),
779: 'USER_DIM10_DISPLAY_CODE',
780: 'user_dim10_name',
781: 'gbit',

Line 778: add_select_clause_dsload_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID'),

774: p_rownum,
775: p_xml_file_type);
776: END IF;
777: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID') = 'Y') THEN
778: add_select_clause_dsload_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID'),
779: 'USER_DIM10_DISPLAY_CODE',
780: 'user_dim10_name',
781: 'gbit',
782: p_rownum,

Line 788: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('CHANNEL_ID'),

784: END IF;
785: ELSIF (p_xml_file_type = 'NONPOSTED_SELECT' OR
786: p_xml_file_type = 'NONPOSTED_GROUP' OR p_xml_file_type = 'DSTB' OR
787: p_xml_file_type = 'DSTB_XML' /*OR p_xml_file_type = 'DSTB_XML_ID'*/) THEN --fix 5351083
788: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('CHANNEL_ID'),
789: 'channel_name',
790: 'fchb',
791: p_rownum,
792: p_xml_file_type);

Line 793: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('CUSTOMER_ID'),

789: 'channel_name',
790: 'fchb',
791: p_rownum,
792: p_xml_file_type);
793: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('CUSTOMER_ID'),
794: 'customer_name',
795: 'fcb',
796: p_rownum,
797: p_xml_file_type);

Line 800: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('FINANCIAL_ELEM_ID'),

796: p_rownum,
797: p_xml_file_type);
798:
799: --BUG 5147886
800: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('FINANCIAL_ELEM_ID'),
801: 'financial_elem_name',
802: 'ffeb',
803: p_rownum,
804: p_xml_file_type);

Line 806: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('NATURAL_ACCOUNT_ID'),

802: 'ffeb',
803: p_rownum,
804: p_xml_file_type);
805:
806: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('NATURAL_ACCOUNT_ID'),
807: 'natural_account_name',
808: 'fnab',
809: p_rownum,
810: p_xml_file_type);

Line 811: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('PRODUCT_ID'),

807: 'natural_account_name',
808: 'fnab',
809: p_rownum,
810: p_xml_file_type);
811: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('PRODUCT_ID'),
812: 'product_name',
813: 'fpb',
814: p_rownum,
815: p_xml_file_type);

Line 816: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('PROJECT_ID'),

812: 'product_name',
813: 'fpb',
814: p_rownum,
815: p_xml_file_type);
816: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('PROJECT_ID'),
817: 'project_name',
818: 'fpjb',
819: p_rownum,
820: p_xml_file_type);

Line 821: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('TASK_ID'),

817: 'project_name',
818: 'fpjb',
819: p_rownum,
820: p_xml_file_type);
821: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('TASK_ID'),
822: 'task_name',
823: 'ftb',
824: p_rownum,
825: p_xml_file_type);

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

822: 'task_name',
823: 'ftb',
824: p_rownum,
825: p_xml_file_type);
826: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID') = 'Y') THEN
827: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID'),
828: 'user_dim1_name',
829: 'fud1',
830: p_rownum,

Line 827: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID'),

823: 'ftb',
824: p_rownum,
825: p_xml_file_type);
826: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID') = 'Y') THEN
827: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID'),
828: 'user_dim1_name',
829: 'fud1',
830: p_rownum,
831: p_xml_file_type);

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

829: 'fud1',
830: p_rownum,
831: p_xml_file_type);
832: END IF;
833: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID') = 'Y') THEN
834: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID'),
835: 'user_dim2_name',
836: 'fud2',
837: p_rownum,

Line 834: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID'),

830: p_rownum,
831: p_xml_file_type);
832: END IF;
833: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID') = 'Y') THEN
834: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID'),
835: 'user_dim2_name',
836: 'fud2',
837: p_rownum,
838: p_xml_file_type);

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

836: 'fud2',
837: p_rownum,
838: p_xml_file_type);
839: END IF;
840: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID') = 'Y') THEN
841: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID'),
842: 'user_dim3_name',
843: 'fud3',
844: p_rownum,

Line 841: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID'),

837: p_rownum,
838: p_xml_file_type);
839: END IF;
840: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID') = 'Y') THEN
841: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID'),
842: 'user_dim3_name',
843: 'fud3',
844: p_rownum,
845: p_xml_file_type);

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

843: 'fud3',
844: p_rownum,
845: p_xml_file_type);
846: END IF;
847: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID') = 'Y') THEN
848: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID'),
849: 'user_dim4_name',
850: 'fud4',
851: p_rownum,

Line 848: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID'),

844: p_rownum,
845: p_xml_file_type);
846: END IF;
847: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID') = 'Y') THEN
848: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID'),
849: 'user_dim4_name',
850: 'fud4',
851: p_rownum,
852: p_xml_file_type);

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

850: 'fud4',
851: p_rownum,
852: p_xml_file_type);
853: END IF;
854: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID') = 'Y') THEN
855: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID'),
856: 'user_dim5_name',
857: 'fud5',
858: p_rownum,

Line 855: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID'),

851: p_rownum,
852: p_xml_file_type);
853: END IF;
854: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID') = 'Y') THEN
855: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID'),
856: 'user_dim5_name',
857: 'fud5',
858: p_rownum,
859: p_xml_file_type);

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

857: 'fud5',
858: p_rownum,
859: p_xml_file_type);
860: END IF;
861: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID') = 'Y') THEN
862: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID'),
863: 'user_dim6_name',
864: 'fud6',
865: p_rownum,

Line 862: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID'),

858: p_rownum,
859: p_xml_file_type);
860: END IF;
861: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID') = 'Y') THEN
862: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID'),
863: 'user_dim6_name',
864: 'fud6',
865: p_rownum,
866: p_xml_file_type);

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

864: 'fud6',
865: p_rownum,
866: p_xml_file_type);
867: END IF;
868: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID') = 'Y') THEN
869: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID'),
870: 'user_dim7_name',
871: 'fud7',
872: p_rownum,

Line 869: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID'),

865: p_rownum,
866: p_xml_file_type);
867: END IF;
868: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID') = 'Y') THEN
869: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID'),
870: 'user_dim7_name',
871: 'fud7',
872: p_rownum,
873: p_xml_file_type);

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

871: 'fud7',
872: p_rownum,
873: p_xml_file_type);
874: END IF;
875: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID') = 'Y') THEN
876: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID'),
877: 'user_dim8_name',
878: 'fud8',
879: p_rownum,

Line 876: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID'),

872: p_rownum,
873: p_xml_file_type);
874: END IF;
875: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID') = 'Y') THEN
876: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID'),
877: 'user_dim8_name',
878: 'fud8',
879: p_rownum,
880: p_xml_file_type);

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

878: 'fud8',
879: p_rownum,
880: p_xml_file_type);
881: END IF;
882: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM9_ID') = 'Y') THEN
883: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM9_ID'),
884: 'user_dim9_name',
885: 'fud9',
886: p_rownum,

Line 883: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM9_ID'),

879: p_rownum,
880: p_xml_file_type);
881: END IF;
882: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM9_ID') = 'Y') THEN
883: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM9_ID'),
884: 'user_dim9_name',
885: 'fud9',
886: p_rownum,
887: p_xml_file_type);

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

885: 'fud9',
886: p_rownum,
887: p_xml_file_type);
888: END IF;
889: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID') = 'Y') THEN
890: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID'),
891: 'user_dim10_name',
892: 'fud10',
893: p_rownum,

Line 890: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID'),

886: p_rownum,
887: p_xml_file_type);
888: END IF;
889: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID') = 'Y') THEN
890: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID'),
891: 'user_dim10_name',
892: 'fud10',
893: p_rownum,
894: p_xml_file_type);

Line 897: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('LINE_ITEM_ID'),

893: p_rownum,
894: p_xml_file_type);
895: END IF;
896: ELSIF (p_xml_file_type = 'DSTBID') THEN
897: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('LINE_ITEM_ID'),
898: 'line_item_id',
899: 'fb',
900: p_rownum,
901: p_xml_file_type);

Line 902: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('CHANNEL_ID'),

898: 'line_item_id',
899: 'fb',
900: p_rownum,
901: p_xml_file_type);
902: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('CHANNEL_ID'),
903: 'channel_id',
904: 'fb',
905: p_rownum,
906: p_xml_file_type);

Line 907: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('CUSTOMER_ID'),

903: 'channel_id',
904: 'fb',
905: p_rownum,
906: p_xml_file_type);
907: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('CUSTOMER_ID'),
908: 'customer_id',
909: 'fb',
910: p_rownum,
911: p_xml_file_type);

Line 913: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('FINANCIAL_ELEM_ID'),

909: 'fb',
910: p_rownum,
911: p_xml_file_type);
912:
913: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('FINANCIAL_ELEM_ID'),
914: 'financial_elem_id',
915: 'fb',
916: p_rownum,
917: p_xml_file_type);

Line 919: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('NATURAL_ACCOUNT_ID'),

915: 'fb',
916: p_rownum,
917: p_xml_file_type);
918:
919: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('NATURAL_ACCOUNT_ID'),
920: 'natural_account_id',
921: 'fb',
922: p_rownum,
923: p_xml_file_type);

Line 924: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('PRODUCT_ID'),

920: 'natural_account_id',
921: 'fb',
922: p_rownum,
923: p_xml_file_type);
924: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('PRODUCT_ID'),
925: 'product_id',
926: 'fb',
927: p_rownum,
928: p_xml_file_type);

Line 929: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('PROJECT_ID'),

925: 'product_id',
926: 'fb',
927: p_rownum,
928: p_xml_file_type);
929: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('PROJECT_ID'),
930: 'project_id',
931: 'fb',
932: p_rownum,
933: p_xml_file_type);

Line 934: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('TASK_ID'),

930: 'project_id',
931: 'fb',
932: p_rownum,
933: p_xml_file_type);
934: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('TASK_ID'),
935: 'task_id',
936: 'fb',
937: p_rownum,
938: p_xml_file_type);

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

935: 'task_id',
936: 'fb',
937: p_rownum,
938: p_xml_file_type);
939: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID') = 'Y') THEN
940: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID'),
941: 'user_dim1_id',
942: 'fb',
943: p_rownum,

Line 940: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID'),

936: 'fb',
937: p_rownum,
938: p_xml_file_type);
939: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID') = 'Y') THEN
940: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID'),
941: 'user_dim1_id',
942: 'fb',
943: p_rownum,
944: p_xml_file_type);

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

942: 'fb',
943: p_rownum,
944: p_xml_file_type);
945: END IF;
946: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID') = 'Y') THEN
947: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID'),
948: 'user_dim2_id',
949: 'fb',
950: p_rownum,

Line 947: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID'),

943: p_rownum,
944: p_xml_file_type);
945: END IF;
946: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID') = 'Y') THEN
947: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID'),
948: 'user_dim2_id',
949: 'fb',
950: p_rownum,
951: p_xml_file_type);

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

949: 'fb',
950: p_rownum,
951: p_xml_file_type);
952: END IF;
953: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID') = 'Y') THEN
954: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID'),
955: 'user_dim3_id',
956: 'fb',
957: p_rownum,

Line 954: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID'),

950: p_rownum,
951: p_xml_file_type);
952: END IF;
953: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID') = 'Y') THEN
954: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID'),
955: 'user_dim3_id',
956: 'fb',
957: p_rownum,
958: p_xml_file_type);

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

956: 'fb',
957: p_rownum,
958: p_xml_file_type);
959: END IF;
960: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID') = 'Y') THEN
961: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID'),
962: 'user_dim4_id',
963: 'fb',
964: p_rownum,

Line 961: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID'),

957: p_rownum,
958: p_xml_file_type);
959: END IF;
960: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID') = 'Y') THEN
961: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID'),
962: 'user_dim4_id',
963: 'fb',
964: p_rownum,
965: p_xml_file_type);

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

963: 'fb',
964: p_rownum,
965: p_xml_file_type);
966: END IF;
967: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID') = 'Y') THEN
968: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID'),
969: 'user_dim5_id',
970: 'fb',
971: p_rownum,

Line 968: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID'),

964: p_rownum,
965: p_xml_file_type);
966: END IF;
967: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID') = 'Y') THEN
968: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID'),
969: 'user_dim5_id',
970: 'fb',
971: p_rownum,
972: p_xml_file_type);

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

970: 'fb',
971: p_rownum,
972: p_xml_file_type);
973: END IF;
974: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID') = 'Y') THEN
975: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID'),
976: 'user_dim6_id',
977: 'fb',
978: p_rownum,

Line 975: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID'),

971: p_rownum,
972: p_xml_file_type);
973: END IF;
974: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID') = 'Y') THEN
975: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID'),
976: 'user_dim6_id',
977: 'fb',
978: p_rownum,
979: p_xml_file_type);

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

977: 'fb',
978: p_rownum,
979: p_xml_file_type);
980: END IF;
981: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID') = 'Y') THEN
982: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID'),
983: 'user_dim7_id',
984: 'fb',
985: p_rownum,

Line 982: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID'),

978: p_rownum,
979: p_xml_file_type);
980: END IF;
981: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID') = 'Y') THEN
982: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID'),
983: 'user_dim7_id',
984: 'fb',
985: p_rownum,
986: p_xml_file_type);

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

984: 'fb',
985: p_rownum,
986: p_xml_file_type);
987: END IF;
988: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID') = 'Y') THEN
989: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID'),
990: 'user_dim8_id',
991: 'fb',
992: p_rownum,

Line 989: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID'),

985: p_rownum,
986: p_xml_file_type);
987: END IF;
988: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID') = 'Y') THEN
989: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID'),
990: 'user_dim8_id',
991: 'fb',
992: p_rownum,
993: p_xml_file_type);

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

991: 'fb',
992: p_rownum,
993: p_xml_file_type);
994: END IF;
995: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM9_ID') = 'Y') THEN
996: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM9_ID'),
997: 'user_dim9_id',
998: 'fb',
999: p_rownum,

Line 996: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM9_ID'),

992: p_rownum,
993: p_xml_file_type);
994: END IF;
995: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM9_ID') = 'Y') THEN
996: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM9_ID'),
997: 'user_dim9_id',
998: 'fb',
999: p_rownum,
1000: p_xml_file_type);

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

998: 'fb',
999: p_rownum,
1000: p_xml_file_type);
1001: END IF;
1002: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID') = 'Y') THEN
1003: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID'),
1004: 'user_dim10_id',
1005: 'fb',
1006: p_rownum,

Line 1003: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID'),

999: p_rownum,
1000: p_xml_file_type);
1001: END IF;
1002: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID') = 'Y') THEN
1003: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID'),
1004: 'user_dim10_id',
1005: 'fb',
1006: p_rownum,
1007: p_xml_file_type);

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

1006: p_rownum,
1007: p_xml_file_type);
1008: END IF;
1009: ELSIF (p_xml_file_type = 'VSMPID') THEN
1010: add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('LINE_ITEM_ID'),
1011: 'line_item_id',
1012: 'gel',
1013: p_rownum,
1014: p_xml_file_type);

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

1011: 'line_item_id',
1012: 'gel',
1013: p_rownum,
1014: p_xml_file_type);
1015: add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('CHANNEL_ID'),
1016: 'channel_id',
1017: 'gel',
1018: p_rownum,
1019: p_xml_file_type);

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

1016: 'channel_id',
1017: 'gel',
1018: p_rownum,
1019: p_xml_file_type);
1020: add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('CUSTOMER_ID'),
1021: 'customer_id',
1022: 'gel',
1023: p_rownum,
1024: p_xml_file_type);

Line 1025: add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('COMPANY_COST_CENTER_ORG_ID'),

1021: 'customer_id',
1022: 'gel',
1023: p_rownum,
1024: p_xml_file_type);
1025: add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('COMPANY_COST_CENTER_ORG_ID'),
1026: 'company_cost_center_org_id',
1027: 'gel',
1028: p_rownum,
1029: p_xml_file_type);

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

1026: 'company_cost_center_org_id',
1027: 'gel',
1028: p_rownum,
1029: p_xml_file_type);
1030: add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('NATURAL_ACCOUNT_ID'),
1031: 'natural_account_id',
1032: 'gel',
1033: p_rownum,
1034: p_xml_file_type);

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

1031: 'natural_account_id',
1032: 'gel',
1033: p_rownum,
1034: p_xml_file_type);
1035: add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('PRODUCT_ID'),
1036: 'product_id',
1037: 'gel',
1038: p_rownum,
1039: p_xml_file_type);

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

1036: 'product_id',
1037: 'gel',
1038: p_rownum,
1039: p_xml_file_type);
1040: add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('PROJECT_ID'),
1041: 'project_id',
1042: 'gel',
1043: p_rownum,
1044: p_xml_file_type);

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

1041: 'project_id',
1042: 'gel',
1043: p_rownum,
1044: p_xml_file_type);
1045: add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('TASK_ID'),
1046: 'task_id',
1047: 'gel',
1048: p_rownum,
1049: p_xml_file_type);

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

1046: 'task_id',
1047: 'gel',
1048: p_rownum,
1049: p_xml_file_type);
1050: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID') = 'Y') THEN
1051: add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM1_ID'),
1052: 'user_dim1_id',
1053: 'gel',
1054: p_rownum,

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

1047: 'gel',
1048: p_rownum,
1049: p_xml_file_type);
1050: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID') = 'Y') THEN
1051: add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM1_ID'),
1052: 'user_dim1_id',
1053: 'gel',
1054: p_rownum,
1055: p_xml_file_type);

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

1053: 'gel',
1054: p_rownum,
1055: p_xml_file_type);
1056: END IF;
1057: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID') = 'Y') THEN
1058: add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM2_ID'),
1059: 'user_dim2_id',
1060: 'gel',
1061: p_rownum,

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

1054: p_rownum,
1055: p_xml_file_type);
1056: END IF;
1057: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID') = 'Y') THEN
1058: add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM2_ID'),
1059: 'user_dim2_id',
1060: 'gel',
1061: p_rownum,
1062: p_xml_file_type);

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

1060: 'gel',
1061: p_rownum,
1062: p_xml_file_type);
1063: END IF;
1064: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID') = 'Y') THEN
1065: add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM3_ID'),
1066: 'user_dim3_id',
1067: 'gel',
1068: p_rownum,

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

1061: p_rownum,
1062: p_xml_file_type);
1063: END IF;
1064: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID') = 'Y') THEN
1065: add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM3_ID'),
1066: 'user_dim3_id',
1067: 'gel',
1068: p_rownum,
1069: p_xml_file_type);

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

1067: 'gel',
1068: p_rownum,
1069: p_xml_file_type);
1070: END IF;
1071: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID') = 'Y') THEN
1072: add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM4_ID'),
1073: 'user_dim4_id',
1074: 'gel',
1075: p_rownum,

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

1068: p_rownum,
1069: p_xml_file_type);
1070: END IF;
1071: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID') = 'Y') THEN
1072: add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM4_ID'),
1073: 'user_dim4_id',
1074: 'gel',
1075: p_rownum,
1076: p_xml_file_type);

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

1074: 'gel',
1075: p_rownum,
1076: p_xml_file_type);
1077: END IF;
1078: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID') = 'Y') THEN
1079: add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM5_ID'),
1080: 'user_dim5_id',
1081: 'gel',
1082: p_rownum,

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

1075: p_rownum,
1076: p_xml_file_type);
1077: END IF;
1078: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID') = 'Y') THEN
1079: add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM5_ID'),
1080: 'user_dim5_id',
1081: 'gel',
1082: p_rownum,
1083: p_xml_file_type);

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

1081: 'gel',
1082: p_rownum,
1083: p_xml_file_type);
1084: END IF;
1085: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID') = 'Y') THEN
1086: add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM6_ID'),
1087: 'user_dim6_id',
1088: 'gel',
1089: p_rownum,

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

1082: p_rownum,
1083: p_xml_file_type);
1084: END IF;
1085: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID') = 'Y') THEN
1086: add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM6_ID'),
1087: 'user_dim6_id',
1088: 'gel',
1089: p_rownum,
1090: p_xml_file_type);

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

1088: 'gel',
1089: p_rownum,
1090: p_xml_file_type);
1091: END IF;
1092: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID') = 'Y') THEN
1093: add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM7_ID'),
1094: 'user_dim7_id',
1095: 'gel',
1096: p_rownum,

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

1089: p_rownum,
1090: p_xml_file_type);
1091: END IF;
1092: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID') = 'Y') THEN
1093: add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM7_ID'),
1094: 'user_dim7_id',
1095: 'gel',
1096: p_rownum,
1097: p_xml_file_type);

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

1095: 'gel',
1096: p_rownum,
1097: p_xml_file_type);
1098: END IF;
1099: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID') = 'Y') THEN
1100: add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM8_ID'),
1101: 'user_dim8_id',
1102: 'gel',
1103: p_rownum,

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

1096: p_rownum,
1097: p_xml_file_type);
1098: END IF;
1099: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID') = 'Y') THEN
1100: add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM8_ID'),
1101: 'user_dim8_id',
1102: 'gel',
1103: p_rownum,
1104: p_xml_file_type);

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

1102: 'gel',
1103: p_rownum,
1104: p_xml_file_type);
1105: END IF;
1106: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM9_ID') = 'Y') THEN
1107: add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM9_ID'),
1108: 'user_dim9_id',
1109: 'gel',
1110: p_rownum,

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

1103: p_rownum,
1104: p_xml_file_type);
1105: END IF;
1106: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM9_ID') = 'Y') THEN
1107: add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM9_ID'),
1108: 'user_dim9_id',
1109: 'gel',
1110: p_rownum,
1111: p_xml_file_type);

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

1109: 'gel',
1110: p_rownum,
1111: p_xml_file_type);
1112: END IF;
1113: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID') = 'Y') THEN
1114: add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM10_ID'),
1115: 'user_dim10_id',
1116: 'gel',
1117: p_rownum,

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

1110: p_rownum,
1111: p_xml_file_type);
1112: END IF;
1113: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID') = 'Y') THEN
1114: add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM10_ID'),
1115: 'user_dim10_id',
1116: 'gel',
1117: p_rownum,
1118: p_xml_file_type);

Line 1121: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('COMPANY_COST_CENTER_ORG_ID'),

1117: p_rownum,
1118: p_xml_file_type);
1119: END IF;
1120: ELSIF (p_xml_file_type = 'CCIDHASH') THEN
1121: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('COMPANY_COST_CENTER_ORG_ID'),
1122: 'company_cost_center_org_id',
1123: 'fb',
1124: p_rownum,
1125: p_xml_file_type);

Line 1126: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('LINE_ITEM_ID'),

1122: 'company_cost_center_org_id',
1123: 'fb',
1124: p_rownum,
1125: p_xml_file_type);
1126: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('LINE_ITEM_ID'),
1127: 'line_item_id',
1128: 'fb',
1129: p_rownum,
1130: p_xml_file_type);

Line 1131: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('CHANNEL_ID'),

1127: 'line_item_id',
1128: 'fb',
1129: p_rownum,
1130: p_xml_file_type);
1131: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('CHANNEL_ID'),
1132: 'channel_id',
1133: 'fb',
1134: p_rownum,
1135: p_xml_file_type);

Line 1136: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('CUSTOMER_ID'),

1132: 'channel_id',
1133: 'fb',
1134: p_rownum,
1135: p_xml_file_type);
1136: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('CUSTOMER_ID'),
1137: 'customer_id',
1138: 'fb',
1139: p_rownum,
1140: p_xml_file_type);

Line 1141: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('NATURAL_ACCOUNT_ID'),

1137: 'customer_id',
1138: 'fb',
1139: p_rownum,
1140: p_xml_file_type);
1141: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('NATURAL_ACCOUNT_ID'),
1142: 'natural_account_id',
1143: 'fb',
1144: p_rownum,
1145: p_xml_file_type);

Line 1146: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('PRODUCT_ID'),

1142: 'natural_account_id',
1143: 'fb',
1144: p_rownum,
1145: p_xml_file_type);
1146: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('PRODUCT_ID'),
1147: 'product_id',
1148: 'fb',
1149: p_rownum,
1150: p_xml_file_type);

Line 1151: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('PROJECT_ID'),

1147: 'product_id',
1148: 'fb',
1149: p_rownum,
1150: p_xml_file_type);
1151: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('PROJECT_ID'),
1152: 'project_id',
1153: 'fb',
1154: p_rownum,
1155: p_xml_file_type);

Line 1156: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('TASK_ID'),

1152: 'project_id',
1153: 'fb',
1154: p_rownum,
1155: p_xml_file_type);
1156: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('TASK_ID'),
1157: 'task_id',
1158: 'fb',
1159: p_rownum,
1160: p_xml_file_type);

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

1157: 'task_id',
1158: 'fb',
1159: p_rownum,
1160: p_xml_file_type);
1161: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID') = 'Y') THEN
1162: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID'),
1163: 'user_dim1_id',
1164: 'fb',
1165: p_rownum,

Line 1162: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID'),

1158: 'fb',
1159: p_rownum,
1160: p_xml_file_type);
1161: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID') = 'Y') THEN
1162: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID'),
1163: 'user_dim1_id',
1164: 'fb',
1165: p_rownum,
1166: p_xml_file_type);

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

1164: 'fb',
1165: p_rownum,
1166: p_xml_file_type);
1167: END IF;
1168: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID') = 'Y') THEN
1169: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID'),
1170: 'user_dim2_id',
1171: 'fb',
1172: p_rownum,

Line 1169: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID'),

1165: p_rownum,
1166: p_xml_file_type);
1167: END IF;
1168: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID') = 'Y') THEN
1169: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID'),
1170: 'user_dim2_id',
1171: 'fb',
1172: p_rownum,
1173: p_xml_file_type);

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

1171: 'fb',
1172: p_rownum,
1173: p_xml_file_type);
1174: END IF;
1175: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID') = 'Y') THEN
1176: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID'),
1177: 'user_dim3_id',
1178: 'fb',
1179: p_rownum,

Line 1176: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID'),

1172: p_rownum,
1173: p_xml_file_type);
1174: END IF;
1175: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID') = 'Y') THEN
1176: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID'),
1177: 'user_dim3_id',
1178: 'fb',
1179: p_rownum,
1180: p_xml_file_type);

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

1178: 'fb',
1179: p_rownum,
1180: p_xml_file_type);
1181: END IF;
1182: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID') = 'Y') THEN
1183: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID'),
1184: 'user_dim4_id',
1185: 'fb',
1186: p_rownum,

Line 1183: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID'),

1179: p_rownum,
1180: p_xml_file_type);
1181: END IF;
1182: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID') = 'Y') THEN
1183: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID'),
1184: 'user_dim4_id',
1185: 'fb',
1186: p_rownum,
1187: p_xml_file_type);

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

1185: 'fb',
1186: p_rownum,
1187: p_xml_file_type);
1188: END IF;
1189: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID') = 'Y') THEN
1190: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID'),
1191: 'user_dim5_id',
1192: 'fb',
1193: p_rownum,

Line 1190: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID'),

1186: p_rownum,
1187: p_xml_file_type);
1188: END IF;
1189: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID') = 'Y') THEN
1190: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID'),
1191: 'user_dim5_id',
1192: 'fb',
1193: p_rownum,
1194: p_xml_file_type);

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

1192: 'fb',
1193: p_rownum,
1194: p_xml_file_type);
1195: END IF;
1196: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID') = 'Y') THEN
1197: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID'),
1198: 'user_dim6_id',
1199: 'fb',
1200: p_rownum,

Line 1197: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID'),

1193: p_rownum,
1194: p_xml_file_type);
1195: END IF;
1196: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID') = 'Y') THEN
1197: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID'),
1198: 'user_dim6_id',
1199: 'fb',
1200: p_rownum,
1201: p_xml_file_type);

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

1199: 'fb',
1200: p_rownum,
1201: p_xml_file_type);
1202: END IF;
1203: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID') = 'Y') THEN
1204: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID'),
1205: 'user_dim7_id',
1206: 'fb',
1207: p_rownum,

Line 1204: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID'),

1200: p_rownum,
1201: p_xml_file_type);
1202: END IF;
1203: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID') = 'Y') THEN
1204: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID'),
1205: 'user_dim7_id',
1206: 'fb',
1207: p_rownum,
1208: p_xml_file_type);

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

1206: 'fb',
1207: p_rownum,
1208: p_xml_file_type);
1209: END IF;
1210: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID') = 'Y') THEN
1211: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID'),
1212: 'user_dim8_id',
1213: 'fb',
1214: p_rownum,

Line 1211: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID'),

1207: p_rownum,
1208: p_xml_file_type);
1209: END IF;
1210: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID') = 'Y') THEN
1211: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID'),
1212: 'user_dim8_id',
1213: 'fb',
1214: p_rownum,
1215: p_xml_file_type);

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

1213: 'fb',
1214: p_rownum,
1215: p_xml_file_type);
1216: END IF;
1217: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM9_ID') = 'Y') THEN
1218: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM9_ID'),
1219: 'user_dim9_id',
1220: 'fb',
1221: p_rownum,

Line 1218: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM9_ID'),

1214: p_rownum,
1215: p_xml_file_type);
1216: END IF;
1217: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM9_ID') = 'Y') THEN
1218: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM9_ID'),
1219: 'user_dim9_id',
1220: 'fb',
1221: p_rownum,
1222: p_xml_file_type);

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

1220: 'fb',
1221: p_rownum,
1222: p_xml_file_type);
1223: END IF;
1224: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID') = 'Y') THEN
1225: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID'),
1226: 'user_dim10_id',
1227: 'fb',
1228: p_rownum,

Line 1225: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID'),

1221: p_rownum,
1222: p_xml_file_type);
1223: END IF;
1224: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID') = 'Y') THEN
1225: add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID'),
1226: 'user_dim10_id',
1227: 'fb',
1228: p_rownum,
1229: p_xml_file_type);

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

1228: p_rownum,
1229: p_xml_file_type);
1230: END IF;
1231: ELSE
1232: add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('CHANNEL_ID'),
1233: 'channel_name',
1234: 'fchb',
1235: p_rownum,
1236: p_xml_file_type);

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

1233: 'channel_name',
1234: 'fchb',
1235: p_rownum,
1236: p_xml_file_type);
1237: add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('CUSTOMER_ID'),
1238: 'customer_name',
1239: 'fcb',
1240: p_rownum,
1241: p_xml_file_type);

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

1238: 'customer_name',
1239: 'fcb',
1240: p_rownum,
1241: p_xml_file_type);
1242: add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('FINANCIAL_ELEM_ID'),
1243: 'financial_elem_name',
1244: 'ffeb',
1245: p_rownum,
1246: p_xml_file_type);

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

1243: 'financial_elem_name',
1244: 'ffeb',
1245: p_rownum,
1246: p_xml_file_type);
1247: add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('NATURAL_ACCOUNT_ID'),
1248: 'natural_account_name',
1249: 'fnab',
1250: p_rownum,
1251: p_xml_file_type);

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

1248: 'natural_account_name',
1249: 'fnab',
1250: p_rownum,
1251: p_xml_file_type);
1252: add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('PRODUCT_ID'),
1253: 'product_name',
1254: 'fpb',
1255: p_rownum,
1256: p_xml_file_type);

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

1253: 'product_name',
1254: 'fpb',
1255: p_rownum,
1256: p_xml_file_type);
1257: add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('PROJECT_ID'),
1258: 'project_name',
1259: 'fpjb',
1260: p_rownum,
1261: p_xml_file_type);

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

1258: 'project_name',
1259: 'fpjb',
1260: p_rownum,
1261: p_xml_file_type);
1262: add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('TASK_ID'),
1263: 'task_name',
1264: 'ftb',
1265: p_rownum,
1266: p_xml_file_type);

Line 1267: IF (gcs_utility_pkg.get_dimension_required('USER_DIM1_ID') = 'Y') THEN

1263: 'task_name',
1264: 'ftb',
1265: p_rownum,
1266: p_xml_file_type);
1267: IF (gcs_utility_pkg.get_dimension_required('USER_DIM1_ID') = 'Y') THEN
1268: add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM1_ID'),
1269: 'user_dim1_name',
1270: 'fud1',
1271: p_rownum,

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

1264: 'ftb',
1265: p_rownum,
1266: p_xml_file_type);
1267: IF (gcs_utility_pkg.get_dimension_required('USER_DIM1_ID') = 'Y') THEN
1268: add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM1_ID'),
1269: 'user_dim1_name',
1270: 'fud1',
1271: p_rownum,
1272: p_xml_file_type);

Line 1274: IF (gcs_utility_pkg.get_dimension_required('USER_DIM2_ID') = 'Y') THEN

1270: 'fud1',
1271: p_rownum,
1272: p_xml_file_type);
1273: END IF;
1274: IF (gcs_utility_pkg.get_dimension_required('USER_DIM2_ID') = 'Y') THEN
1275: add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM2_ID'),
1276: 'user_dim2_name',
1277: 'fud2',
1278: p_rownum,

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

1271: p_rownum,
1272: p_xml_file_type);
1273: END IF;
1274: IF (gcs_utility_pkg.get_dimension_required('USER_DIM2_ID') = 'Y') THEN
1275: add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM2_ID'),
1276: 'user_dim2_name',
1277: 'fud2',
1278: p_rownum,
1279: p_xml_file_type);

Line 1281: IF (gcs_utility_pkg.get_dimension_required('USER_DIM3_ID') = 'Y') THEN

1277: 'fud2',
1278: p_rownum,
1279: p_xml_file_type);
1280: END IF;
1281: IF (gcs_utility_pkg.get_dimension_required('USER_DIM3_ID') = 'Y') THEN
1282: add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM3_ID'),
1283: 'user_dim3_name',
1284: 'fud3',
1285: p_rownum,

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

1278: p_rownum,
1279: p_xml_file_type);
1280: END IF;
1281: IF (gcs_utility_pkg.get_dimension_required('USER_DIM3_ID') = 'Y') THEN
1282: add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM3_ID'),
1283: 'user_dim3_name',
1284: 'fud3',
1285: p_rownum,
1286: p_xml_file_type);

Line 1288: IF (gcs_utility_pkg.get_dimension_required('USER_DIM4_ID') = 'Y') THEN

1284: 'fud3',
1285: p_rownum,
1286: p_xml_file_type);
1287: END IF;
1288: IF (gcs_utility_pkg.get_dimension_required('USER_DIM4_ID') = 'Y') THEN
1289: add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM4_ID'),
1290: 'user_dim4_name',
1291: 'fud4',
1292: p_rownum,

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

1285: p_rownum,
1286: p_xml_file_type);
1287: END IF;
1288: IF (gcs_utility_pkg.get_dimension_required('USER_DIM4_ID') = 'Y') THEN
1289: add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM4_ID'),
1290: 'user_dim4_name',
1291: 'fud4',
1292: p_rownum,
1293: p_xml_file_type);

Line 1295: IF (gcs_utility_pkg.get_dimension_required('USER_DIM5_ID') = 'Y') THEN

1291: 'fud4',
1292: p_rownum,
1293: p_xml_file_type);
1294: END IF;
1295: IF (gcs_utility_pkg.get_dimension_required('USER_DIM5_ID') = 'Y') THEN
1296: add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM5_ID'),
1297: 'user_dim5_name',
1298: 'fud5',
1299: p_rownum,

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

1292: p_rownum,
1293: p_xml_file_type);
1294: END IF;
1295: IF (gcs_utility_pkg.get_dimension_required('USER_DIM5_ID') = 'Y') THEN
1296: add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM5_ID'),
1297: 'user_dim5_name',
1298: 'fud5',
1299: p_rownum,
1300: p_xml_file_type);

Line 1302: IF (gcs_utility_pkg.get_dimension_required('USER_DIM6_ID') = 'Y') THEN

1298: 'fud5',
1299: p_rownum,
1300: p_xml_file_type);
1301: END IF;
1302: IF (gcs_utility_pkg.get_dimension_required('USER_DIM6_ID') = 'Y') THEN
1303: add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM6_ID'),
1304: 'user_dim6_name',
1305: 'fud6',
1306: p_rownum,

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

1299: p_rownum,
1300: p_xml_file_type);
1301: END IF;
1302: IF (gcs_utility_pkg.get_dimension_required('USER_DIM6_ID') = 'Y') THEN
1303: add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM6_ID'),
1304: 'user_dim6_name',
1305: 'fud6',
1306: p_rownum,
1307: p_xml_file_type);

Line 1309: IF (gcs_utility_pkg.get_dimension_required('USER_DIM7_ID') = 'Y') THEN

1305: 'fud6',
1306: p_rownum,
1307: p_xml_file_type);
1308: END IF;
1309: IF (gcs_utility_pkg.get_dimension_required('USER_DIM7_ID') = 'Y') THEN
1310: add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM7_ID'),
1311: 'user_dim7_name',
1312: 'fud7',
1313: p_rownum,

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

1306: p_rownum,
1307: p_xml_file_type);
1308: END IF;
1309: IF (gcs_utility_pkg.get_dimension_required('USER_DIM7_ID') = 'Y') THEN
1310: add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM7_ID'),
1311: 'user_dim7_name',
1312: 'fud7',
1313: p_rownum,
1314: p_xml_file_type);

Line 1316: IF (gcs_utility_pkg.get_dimension_required('USER_DIM8_ID') = 'Y') THEN

1312: 'fud7',
1313: p_rownum,
1314: p_xml_file_type);
1315: END IF;
1316: IF (gcs_utility_pkg.get_dimension_required('USER_DIM8_ID') = 'Y') THEN
1317: add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM8_ID'),
1318: 'user_dim8_name',
1319: 'fud8',
1320: p_rownum,

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

1313: p_rownum,
1314: p_xml_file_type);
1315: END IF;
1316: IF (gcs_utility_pkg.get_dimension_required('USER_DIM8_ID') = 'Y') THEN
1317: add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM8_ID'),
1318: 'user_dim8_name',
1319: 'fud8',
1320: p_rownum,
1321: p_xml_file_type);

Line 1323: IF (gcs_utility_pkg.get_dimension_required('USER_DIM9_ID') = 'Y') THEN

1319: 'fud8',
1320: p_rownum,
1321: p_xml_file_type);
1322: END IF;
1323: IF (gcs_utility_pkg.get_dimension_required('USER_DIM9_ID') = 'Y') THEN
1324: add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM9_ID'),
1325: 'user_dim9_name',
1326: 'fud9',
1327: p_rownum,

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

1320: p_rownum,
1321: p_xml_file_type);
1322: END IF;
1323: IF (gcs_utility_pkg.get_dimension_required('USER_DIM9_ID') = 'Y') THEN
1324: add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM9_ID'),
1325: 'user_dim9_name',
1326: 'fud9',
1327: p_rownum,
1328: p_xml_file_type);

Line 1330: IF (gcs_utility_pkg.get_dimension_required('USER_DIM10_ID') = 'Y') THEN

1326: 'fud9',
1327: p_rownum,
1328: p_xml_file_type);
1329: END IF;
1330: IF (gcs_utility_pkg.get_dimension_required('USER_DIM10_ID') = 'Y') THEN
1331: add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM10_ID'),
1332: 'user_dim10_name',
1333: 'fud10',
1334: p_rownum,

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

1327: p_rownum,
1328: p_xml_file_type);
1329: END IF;
1330: IF (gcs_utility_pkg.get_dimension_required('USER_DIM10_ID') = 'Y') THEN
1331: add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM10_ID'),
1332: 'user_dim10_name',
1333: 'fud10',
1334: p_rownum,
1335: p_xml_file_type);

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

1337: END IF;
1338: END build_select_clause_list;
1339: PROCEDURE build_where_clause_list(p_rownum IN OUT NOCOPY NUMBER,
1340: p_xml_file_type IN VARCHAR2) IS
1341: l_dim_info gcs_utility_pkg.t_hash_gcs_dimension_info := gcs_utility_pkg.g_gcs_dimension_info;
1342: BEGIN
1343: -- Santosh 5234796
1344: /*IF p_xml_file_type = 'DSLOAD' THEN
1345: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('CHANNEL_ID'), 'channel_',

Line 1345: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('CHANNEL_ID'), 'channel_',

1341: l_dim_info gcs_utility_pkg.t_hash_gcs_dimension_info := gcs_utility_pkg.g_gcs_dimension_info;
1342: BEGIN
1343: -- Santosh 5234796
1344: /*IF p_xml_file_type = 'DSLOAD' THEN
1345: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('CHANNEL_ID'), 'channel_',
1346: 'fchb', p_rownum, p_xml_file_type);
1347: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('CUSTOMER_ID'), 'customer_',
1348: 'fcb', p_rownum, p_xml_file_type);
1349: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('FINANCIAL_ELEM_ID'), 'financial_elem_',

Line 1347: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('CUSTOMER_ID'), 'customer_',

1343: -- Santosh 5234796
1344: /*IF p_xml_file_type = 'DSLOAD' THEN
1345: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('CHANNEL_ID'), 'channel_',
1346: 'fchb', p_rownum, p_xml_file_type);
1347: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('CUSTOMER_ID'), 'customer_',
1348: 'fcb', p_rownum, p_xml_file_type);
1349: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('FINANCIAL_ELEM_ID'), 'financial_elem_',
1350: 'ffeb', p_rownum, p_xml_file_type);
1351: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('NATURAL_ACCOUNT_ID'), 'natural_account_',

Line 1349: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('FINANCIAL_ELEM_ID'), 'financial_elem_',

1345: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('CHANNEL_ID'), 'channel_',
1346: 'fchb', p_rownum, p_xml_file_type);
1347: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('CUSTOMER_ID'), 'customer_',
1348: 'fcb', p_rownum, p_xml_file_type);
1349: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('FINANCIAL_ELEM_ID'), 'financial_elem_',
1350: 'ffeb', p_rownum, p_xml_file_type);
1351: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('NATURAL_ACCOUNT_ID'), 'natural_account_',
1352: 'fnab', p_rownum, p_xml_file_type);
1353: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('PRODUCT_ID'), 'product_',

Line 1351: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('NATURAL_ACCOUNT_ID'), 'natural_account_',

1347: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('CUSTOMER_ID'), 'customer_',
1348: 'fcb', p_rownum, p_xml_file_type);
1349: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('FINANCIAL_ELEM_ID'), 'financial_elem_',
1350: 'ffeb', p_rownum, p_xml_file_type);
1351: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('NATURAL_ACCOUNT_ID'), 'natural_account_',
1352: 'fnab', p_rownum, p_xml_file_type);
1353: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('PRODUCT_ID'), 'product_',
1354: 'fpb',
1355: p_rownum, p_xml_file_type);

Line 1353: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('PRODUCT_ID'), 'product_',

1349: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('FINANCIAL_ELEM_ID'), 'financial_elem_',
1350: 'ffeb', p_rownum, p_xml_file_type);
1351: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('NATURAL_ACCOUNT_ID'), 'natural_account_',
1352: 'fnab', p_rownum, p_xml_file_type);
1353: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('PRODUCT_ID'), 'product_',
1354: 'fpb',
1355: p_rownum, p_xml_file_type);
1356: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('PROJECT_ID'), 'project_',
1357: 'fpjb', p_rownum, p_xml_file_type);

Line 1356: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('PROJECT_ID'), 'project_',

1352: 'fnab', p_rownum, p_xml_file_type);
1353: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('PRODUCT_ID'), 'product_',
1354: 'fpb',
1355: p_rownum, p_xml_file_type);
1356: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('PROJECT_ID'), 'project_',
1357: 'fpjb', p_rownum, p_xml_file_type);
1358: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('TASK_ID'), 'task_',
1359: 'ftb', p_rownum, p_xml_file_type);
1360: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID') = 'Y') THEN

Line 1358: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('TASK_ID'), 'task_',

1354: 'fpb',
1355: p_rownum, p_xml_file_type);
1356: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('PROJECT_ID'), 'project_',
1357: 'fpjb', p_rownum, p_xml_file_type);
1358: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('TASK_ID'), 'task_',
1359: 'ftb', p_rownum, p_xml_file_type);
1360: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID') = 'Y') THEN
1361: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID'),'user_dim10_',
1362: 'fud10', p_rownum, p_xml_file_type);

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

1356: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('PROJECT_ID'), 'project_',
1357: 'fpjb', p_rownum, p_xml_file_type);
1358: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('TASK_ID'), 'task_',
1359: 'ftb', p_rownum, p_xml_file_type);
1360: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID') = 'Y') THEN
1361: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID'),'user_dim10_',
1362: 'fud10', p_rownum, p_xml_file_type);
1363: END IF;
1364: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID') = 'Y') THEN

Line 1361: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID'),'user_dim10_',

1357: 'fpjb', p_rownum, p_xml_file_type);
1358: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('TASK_ID'), 'task_',
1359: 'ftb', p_rownum, p_xml_file_type);
1360: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID') = 'Y') THEN
1361: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID'),'user_dim10_',
1362: 'fud10', p_rownum, p_xml_file_type);
1363: END IF;
1364: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID') = 'Y') THEN
1365: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID'), 'user_dim1_',

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

1360: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID') = 'Y') THEN
1361: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID'),'user_dim10_',
1362: 'fud10', p_rownum, p_xml_file_type);
1363: END IF;
1364: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID') = 'Y') THEN
1365: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID'), 'user_dim1_',
1366: 'fud1', p_rownum, p_xml_file_type);
1367: END IF;
1368: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID') = 'Y') THEN

Line 1365: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID'), 'user_dim1_',

1361: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID'),'user_dim10_',
1362: 'fud10', p_rownum, p_xml_file_type);
1363: END IF;
1364: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID') = 'Y') THEN
1365: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID'), 'user_dim1_',
1366: 'fud1', p_rownum, p_xml_file_type);
1367: END IF;
1368: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID') = 'Y') THEN
1369: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID'), 'user_dim2_',

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

1364: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID') = 'Y') THEN
1365: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID'), 'user_dim1_',
1366: 'fud1', p_rownum, p_xml_file_type);
1367: END IF;
1368: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID') = 'Y') THEN
1369: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID'), 'user_dim2_',
1370: 'fud2', p_rownum, p_xml_file_type);
1371: END IF;
1372: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID') = 'Y') THEN

Line 1369: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID'), 'user_dim2_',

1365: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID'), 'user_dim1_',
1366: 'fud1', p_rownum, p_xml_file_type);
1367: END IF;
1368: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID') = 'Y') THEN
1369: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID'), 'user_dim2_',
1370: 'fud2', p_rownum, p_xml_file_type);
1371: END IF;
1372: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID') = 'Y') THEN
1373: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID'), 'user_dim3_',

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

1368: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID') = 'Y') THEN
1369: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID'), 'user_dim2_',
1370: 'fud2', p_rownum, p_xml_file_type);
1371: END IF;
1372: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID') = 'Y') THEN
1373: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID'), 'user_dim3_',
1374: 'fud3', p_rownum, p_xml_file_type);
1375: END IF;
1376: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID') = 'Y') THEN

Line 1373: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID'), 'user_dim3_',

1369: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID'), 'user_dim2_',
1370: 'fud2', p_rownum, p_xml_file_type);
1371: END IF;
1372: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID') = 'Y') THEN
1373: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID'), 'user_dim3_',
1374: 'fud3', p_rownum, p_xml_file_type);
1375: END IF;
1376: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID') = 'Y') THEN
1377: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID'), 'user_dim4_',

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

1372: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID') = 'Y') THEN
1373: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID'), 'user_dim3_',
1374: 'fud3', p_rownum, p_xml_file_type);
1375: END IF;
1376: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID') = 'Y') THEN
1377: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID'), 'user_dim4_',
1378: 'fud4', p_rownum, p_xml_file_type);
1379: END IF;
1380: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID') = 'Y') THEN

Line 1377: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID'), 'user_dim4_',

1373: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID'), 'user_dim3_',
1374: 'fud3', p_rownum, p_xml_file_type);
1375: END IF;
1376: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID') = 'Y') THEN
1377: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID'), 'user_dim4_',
1378: 'fud4', p_rownum, p_xml_file_type);
1379: END IF;
1380: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID') = 'Y') THEN
1381: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID'), 'user_dim5_',

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

1376: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID') = 'Y') THEN
1377: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID'), 'user_dim4_',
1378: 'fud4', p_rownum, p_xml_file_type);
1379: END IF;
1380: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID') = 'Y') THEN
1381: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID'), 'user_dim5_',
1382: 'fud5', p_rownum, p_xml_file_type);
1383: END IF;
1384: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID') = 'Y') THEN

Line 1381: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID'), 'user_dim5_',

1377: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID'), 'user_dim4_',
1378: 'fud4', p_rownum, p_xml_file_type);
1379: END IF;
1380: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID') = 'Y') THEN
1381: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID'), 'user_dim5_',
1382: 'fud5', p_rownum, p_xml_file_type);
1383: END IF;
1384: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID') = 'Y') THEN
1385: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID'), 'user_dim6_',

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

1380: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID') = 'Y') THEN
1381: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID'), 'user_dim5_',
1382: 'fud5', p_rownum, p_xml_file_type);
1383: END IF;
1384: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID') = 'Y') THEN
1385: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID'), 'user_dim6_',
1386: 'fud6', p_rownum, p_xml_file_type);
1387: END IF;
1388: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID') = 'Y') THEN

Line 1385: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID'), 'user_dim6_',

1381: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID'), 'user_dim5_',
1382: 'fud5', p_rownum, p_xml_file_type);
1383: END IF;
1384: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID') = 'Y') THEN
1385: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID'), 'user_dim6_',
1386: 'fud6', p_rownum, p_xml_file_type);
1387: END IF;
1388: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID') = 'Y') THEN
1389: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID'), 'user_dim7_',

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

1384: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID') = 'Y') THEN
1385: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID'), 'user_dim6_',
1386: 'fud6', p_rownum, p_xml_file_type);
1387: END IF;
1388: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID') = 'Y') THEN
1389: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID'), 'user_dim7_',
1390: 'fud7', p_rownum, p_xml_file_type);
1391: END IF;
1392: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID') = 'Y') THEN

Line 1389: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID'), 'user_dim7_',

1385: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID'), 'user_dim6_',
1386: 'fud6', p_rownum, p_xml_file_type);
1387: END IF;
1388: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID') = 'Y') THEN
1389: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID'), 'user_dim7_',
1390: 'fud7', p_rownum, p_xml_file_type);
1391: END IF;
1392: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID') = 'Y') THEN
1393: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID'), 'user_dim8_',

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

1388: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID') = 'Y') THEN
1389: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID'), 'user_dim7_',
1390: 'fud7', p_rownum, p_xml_file_type);
1391: END IF;
1392: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID') = 'Y') THEN
1393: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID'), 'user_dim8_',
1394: 'fud8', p_rownum, p_xml_file_type);
1395: END IF;
1396: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM9_ID') = 'Y') THEN

Line 1393: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID'), 'user_dim8_',

1389: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID'), 'user_dim7_',
1390: 'fud7', p_rownum, p_xml_file_type);
1391: END IF;
1392: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID') = 'Y') THEN
1393: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID'), 'user_dim8_',
1394: 'fud8', p_rownum, p_xml_file_type);
1395: END IF;
1396: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM9_ID') = 'Y') THEN
1397: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM9_ID'), 'user_dim9_',

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

1392: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID') = 'Y') THEN
1393: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID'), 'user_dim8_',
1394: 'fud8', p_rownum, p_xml_file_type);
1395: END IF;
1396: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM9_ID') = 'Y') THEN
1397: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM9_ID'), 'user_dim9_',
1398: 'fud9', p_rownum, p_xml_file_type);
1399: END IF;
1400: ELS*/

Line 1397: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM9_ID'), 'user_dim9_',

1393: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID'), 'user_dim8_',
1394: 'fud8', p_rownum, p_xml_file_type);
1395: END IF;
1396: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM9_ID') = 'Y') THEN
1397: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM9_ID'), 'user_dim9_',
1398: 'fud9', p_rownum, p_xml_file_type);
1399: END IF;
1400: ELS*/
1401: IF p_xml_file_type = 'DSTB' THEN

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

1398: 'fud9', p_rownum, p_xml_file_type);
1399: END IF;
1400: ELS*/
1401: IF p_xml_file_type = 'DSTB' THEN
1402: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('CHANNEL_ID'),
1403: 'channel_id',
1404: 'fchb',
1405: p_rownum,
1406: p_xml_file_type);

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

1403: 'channel_id',
1404: 'fchb',
1405: p_rownum,
1406: p_xml_file_type);
1407: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('CUSTOMER_ID'),
1408: 'customer_id',
1409: 'fcb',
1410: p_rownum,
1411: p_xml_file_type);

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

1408: 'customer_id',
1409: 'fcb',
1410: p_rownum,
1411: p_xml_file_type);
1412: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('FINANCIAL_ELEM_ID'),
1413: 'financial_elem_id',
1414: 'ffeb',
1415: p_rownum,
1416: p_xml_file_type);

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

1413: 'financial_elem_id',
1414: 'ffeb',
1415: p_rownum,
1416: p_xml_file_type);
1417: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('NATURAL_ACCOUNT_ID'),
1418: 'natural_account_id',
1419: 'fnab',
1420: p_rownum,
1421: p_xml_file_type);

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

1418: 'natural_account_id',
1419: 'fnab',
1420: p_rownum,
1421: p_xml_file_type);
1422: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('PRODUCT_ID'),
1423: 'product_id',
1424: 'fpb',
1425: p_rownum,
1426: p_xml_file_type);

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

1423: 'product_id',
1424: 'fpb',
1425: p_rownum,
1426: p_xml_file_type);
1427: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('PROJECT_ID'),
1428: 'project_id',
1429: 'fpjb',
1430: p_rownum,
1431: p_xml_file_type);

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

1428: 'project_id',
1429: 'fpjb',
1430: p_rownum,
1431: p_xml_file_type);
1432: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('TASK_ID'),
1433: 'task_id',
1434: 'ftb',
1435: p_rownum,
1436: p_xml_file_type);

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

1433: 'task_id',
1434: 'ftb',
1435: p_rownum,
1436: p_xml_file_type);
1437: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID') = 'Y') THEN
1438: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID'),
1439: 'user_dim10_id',
1440: 'fud10',
1441: p_rownum,

Line 1438: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID'),

1434: 'ftb',
1435: p_rownum,
1436: p_xml_file_type);
1437: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID') = 'Y') THEN
1438: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID'),
1439: 'user_dim10_id',
1440: 'fud10',
1441: p_rownum,
1442: p_xml_file_type);

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

1440: 'fud10',
1441: p_rownum,
1442: p_xml_file_type);
1443: END IF;
1444: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID') = 'Y') THEN
1445: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID'),
1446: 'user_dim1_id',
1447: 'fud1',
1448: p_rownum,

Line 1445: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID'),

1441: p_rownum,
1442: p_xml_file_type);
1443: END IF;
1444: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID') = 'Y') THEN
1445: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID'),
1446: 'user_dim1_id',
1447: 'fud1',
1448: p_rownum,
1449: p_xml_file_type);

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

1447: 'fud1',
1448: p_rownum,
1449: p_xml_file_type);
1450: END IF;
1451: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID') = 'Y') THEN
1452: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID'),
1453: 'user_dim2_id',
1454: 'fud2',
1455: p_rownum,

Line 1452: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID'),

1448: p_rownum,
1449: p_xml_file_type);
1450: END IF;
1451: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID') = 'Y') THEN
1452: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID'),
1453: 'user_dim2_id',
1454: 'fud2',
1455: p_rownum,
1456: p_xml_file_type);

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

1454: 'fud2',
1455: p_rownum,
1456: p_xml_file_type);
1457: END IF;
1458: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID') = 'Y') THEN
1459: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID'),
1460: 'user_dim3_id',
1461: 'fud3',
1462: p_rownum,

Line 1459: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID'),

1455: p_rownum,
1456: p_xml_file_type);
1457: END IF;
1458: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID') = 'Y') THEN
1459: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID'),
1460: 'user_dim3_id',
1461: 'fud3',
1462: p_rownum,
1463: p_xml_file_type);

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

1461: 'fud3',
1462: p_rownum,
1463: p_xml_file_type);
1464: END IF;
1465: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID') = 'Y') THEN
1466: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID'),
1467: 'user_dim4_id',
1468: 'fud4',
1469: p_rownum,

Line 1466: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID'),

1462: p_rownum,
1463: p_xml_file_type);
1464: END IF;
1465: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID') = 'Y') THEN
1466: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID'),
1467: 'user_dim4_id',
1468: 'fud4',
1469: p_rownum,
1470: p_xml_file_type);

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

1468: 'fud4',
1469: p_rownum,
1470: p_xml_file_type);
1471: END IF;
1472: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID') = 'Y') THEN
1473: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID'),
1474: 'user_dim5_id',
1475: 'fud5',
1476: p_rownum,

Line 1473: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID'),

1469: p_rownum,
1470: p_xml_file_type);
1471: END IF;
1472: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID') = 'Y') THEN
1473: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID'),
1474: 'user_dim5_id',
1475: 'fud5',
1476: p_rownum,
1477: p_xml_file_type);

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

1475: 'fud5',
1476: p_rownum,
1477: p_xml_file_type);
1478: END IF;
1479: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID') = 'Y') THEN
1480: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID'),
1481: 'user_dim6_id',
1482: 'fud6',
1483: p_rownum,

Line 1480: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID'),

1476: p_rownum,
1477: p_xml_file_type);
1478: END IF;
1479: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID') = 'Y') THEN
1480: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID'),
1481: 'user_dim6_id',
1482: 'fud6',
1483: p_rownum,
1484: p_xml_file_type);

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

1482: 'fud6',
1483: p_rownum,
1484: p_xml_file_type);
1485: END IF;
1486: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID') = 'Y') THEN
1487: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID'),
1488: 'user_dim7_id',
1489: 'fud7',
1490: p_rownum,

Line 1487: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID'),

1483: p_rownum,
1484: p_xml_file_type);
1485: END IF;
1486: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID') = 'Y') THEN
1487: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID'),
1488: 'user_dim7_id',
1489: 'fud7',
1490: p_rownum,
1491: p_xml_file_type);

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

1489: 'fud7',
1490: p_rownum,
1491: p_xml_file_type);
1492: END IF;
1493: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID') = 'Y') THEN
1494: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID'),
1495: 'user_dim8_id',
1496: 'fud8',
1497: p_rownum,

Line 1494: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID'),

1490: p_rownum,
1491: p_xml_file_type);
1492: END IF;
1493: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID') = 'Y') THEN
1494: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID'),
1495: 'user_dim8_id',
1496: 'fud8',
1497: p_rownum,
1498: p_xml_file_type);

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

1496: 'fud8',
1497: p_rownum,
1498: p_xml_file_type);
1499: END IF;
1500: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM9_ID') = 'Y') THEN
1501: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM9_ID'),
1502: 'user_dim9_id',
1503: 'fud9',
1504: p_rownum,

Line 1501: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM9_ID'),

1497: p_rownum,
1498: p_xml_file_type);
1499: END IF;
1500: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM9_ID') = 'Y') THEN
1501: add_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM9_ID'),
1502: 'user_dim9_id',
1503: 'fud9',
1504: p_rownum,
1505: p_xml_file_type);

Line 1508: add_clause_to_list(gcs_utility_pkg.get_dimension_required('CHANNEL_ID'),

1504: p_rownum,
1505: p_xml_file_type);
1506: END IF;
1507: ELSE
1508: add_clause_to_list(gcs_utility_pkg.get_dimension_required('CHANNEL_ID'),
1509: 'channel_id',
1510: 'fchb',
1511: p_rownum,
1512: p_xml_file_type);

Line 1513: add_clause_to_list(gcs_utility_pkg.get_dimension_required('CUSTOMER_ID'),

1509: 'channel_id',
1510: 'fchb',
1511: p_rownum,
1512: p_xml_file_type);
1513: add_clause_to_list(gcs_utility_pkg.get_dimension_required('CUSTOMER_ID'),
1514: 'customer_id',
1515: 'fcb',
1516: p_rownum,
1517: p_xml_file_type);

Line 1518: add_clause_to_list(gcs_utility_pkg.get_dimension_required('FINANCIAL_ELEM_ID'),

1514: 'customer_id',
1515: 'fcb',
1516: p_rownum,
1517: p_xml_file_type);
1518: add_clause_to_list(gcs_utility_pkg.get_dimension_required('FINANCIAL_ELEM_ID'),
1519: 'financial_elem_id',
1520: 'ffeb',
1521: p_rownum,
1522: p_xml_file_type);

Line 1523: add_clause_to_list(gcs_utility_pkg.get_dimension_required('NATURAL_ACCOUNT_ID'),

1519: 'financial_elem_id',
1520: 'ffeb',
1521: p_rownum,
1522: p_xml_file_type);
1523: add_clause_to_list(gcs_utility_pkg.get_dimension_required('NATURAL_ACCOUNT_ID'),
1524: 'natural_account_id',
1525: 'fnab',
1526: p_rownum,
1527: p_xml_file_type);

Line 1528: add_clause_to_list(gcs_utility_pkg.get_dimension_required('PRODUCT_ID'),

1524: 'natural_account_id',
1525: 'fnab',
1526: p_rownum,
1527: p_xml_file_type);
1528: add_clause_to_list(gcs_utility_pkg.get_dimension_required('PRODUCT_ID'),
1529: 'product_id',
1530: 'fpb',
1531: p_rownum,
1532: p_xml_file_type);

Line 1533: add_clause_to_list(gcs_utility_pkg.get_dimension_required('PROJECT_ID'),

1529: 'product_id',
1530: 'fpb',
1531: p_rownum,
1532: p_xml_file_type);
1533: add_clause_to_list(gcs_utility_pkg.get_dimension_required('PROJECT_ID'),
1534: 'project_id',
1535: 'fpjb',
1536: p_rownum,
1537: p_xml_file_type);

Line 1538: add_clause_to_list(gcs_utility_pkg.get_dimension_required('TASK_ID'),

1534: 'project_id',
1535: 'fpjb',
1536: p_rownum,
1537: p_xml_file_type);
1538: add_clause_to_list(gcs_utility_pkg.get_dimension_required('TASK_ID'),
1539: 'task_id',
1540: 'ftb',
1541: p_rownum,
1542: p_xml_file_type);

Line 1543: IF (gcs_utility_pkg.get_dimension_required('USER_DIM10_ID') = 'Y') THEN

1539: 'task_id',
1540: 'ftb',
1541: p_rownum,
1542: p_xml_file_type);
1543: IF (gcs_utility_pkg.get_dimension_required('USER_DIM10_ID') = 'Y') THEN
1544: add_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM10_ID'),
1545: l_dim_info('USER_DIM10_ID').dim_member_col,
1546: 'fud10',
1547: p_rownum,

Line 1544: add_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM10_ID'),

1540: 'ftb',
1541: p_rownum,
1542: p_xml_file_type);
1543: IF (gcs_utility_pkg.get_dimension_required('USER_DIM10_ID') = 'Y') THEN
1544: add_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM10_ID'),
1545: l_dim_info('USER_DIM10_ID').dim_member_col,
1546: 'fud10',
1547: p_rownum,
1548: p_xml_file_type);

Line 1550: IF (gcs_utility_pkg.get_dimension_required('USER_DIM1_ID') = 'Y') THEN

1546: 'fud10',
1547: p_rownum,
1548: p_xml_file_type);
1549: END IF;
1550: IF (gcs_utility_pkg.get_dimension_required('USER_DIM1_ID') = 'Y') THEN
1551: add_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM1_ID'),
1552: l_dim_info('USER_DIM1_ID').dim_member_col,
1553: 'fud1',
1554: p_rownum,

Line 1551: add_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM1_ID'),

1547: p_rownum,
1548: p_xml_file_type);
1549: END IF;
1550: IF (gcs_utility_pkg.get_dimension_required('USER_DIM1_ID') = 'Y') THEN
1551: add_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM1_ID'),
1552: l_dim_info('USER_DIM1_ID').dim_member_col,
1553: 'fud1',
1554: p_rownum,
1555: p_xml_file_type);

Line 1557: IF (gcs_utility_pkg.get_dimension_required('USER_DIM2_ID') = 'Y') THEN

1553: 'fud1',
1554: p_rownum,
1555: p_xml_file_type);
1556: END IF;
1557: IF (gcs_utility_pkg.get_dimension_required('USER_DIM2_ID') = 'Y') THEN
1558: add_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM2_ID'),
1559: l_dim_info('USER_DIM2_ID').dim_member_col,
1560: 'fud2',
1561: p_rownum,

Line 1558: add_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM2_ID'),

1554: p_rownum,
1555: p_xml_file_type);
1556: END IF;
1557: IF (gcs_utility_pkg.get_dimension_required('USER_DIM2_ID') = 'Y') THEN
1558: add_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM2_ID'),
1559: l_dim_info('USER_DIM2_ID').dim_member_col,
1560: 'fud2',
1561: p_rownum,
1562: p_xml_file_type);

Line 1564: IF (gcs_utility_pkg.get_dimension_required('USER_DIM3_ID') = 'Y') THEN

1560: 'fud2',
1561: p_rownum,
1562: p_xml_file_type);
1563: END IF;
1564: IF (gcs_utility_pkg.get_dimension_required('USER_DIM3_ID') = 'Y') THEN
1565: add_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM3_ID'),
1566: l_dim_info('USER_DIM3_ID').dim_member_col,
1567: 'fud3',
1568: p_rownum,

Line 1565: add_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM3_ID'),

1561: p_rownum,
1562: p_xml_file_type);
1563: END IF;
1564: IF (gcs_utility_pkg.get_dimension_required('USER_DIM3_ID') = 'Y') THEN
1565: add_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM3_ID'),
1566: l_dim_info('USER_DIM3_ID').dim_member_col,
1567: 'fud3',
1568: p_rownum,
1569: p_xml_file_type);

Line 1571: IF (gcs_utility_pkg.get_dimension_required('USER_DIM4_ID') = 'Y') THEN

1567: 'fud3',
1568: p_rownum,
1569: p_xml_file_type);
1570: END IF;
1571: IF (gcs_utility_pkg.get_dimension_required('USER_DIM4_ID') = 'Y') THEN
1572: add_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM4_ID'),
1573: l_dim_info('USER_DIM4_ID').dim_member_col,
1574: 'fud4',
1575: p_rownum,

Line 1572: add_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM4_ID'),

1568: p_rownum,
1569: p_xml_file_type);
1570: END IF;
1571: IF (gcs_utility_pkg.get_dimension_required('USER_DIM4_ID') = 'Y') THEN
1572: add_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM4_ID'),
1573: l_dim_info('USER_DIM4_ID').dim_member_col,
1574: 'fud4',
1575: p_rownum,
1576: p_xml_file_type);

Line 1578: IF (gcs_utility_pkg.get_dimension_required('USER_DIM5_ID') = 'Y') THEN

1574: 'fud4',
1575: p_rownum,
1576: p_xml_file_type);
1577: END IF;
1578: IF (gcs_utility_pkg.get_dimension_required('USER_DIM5_ID') = 'Y') THEN
1579: add_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM5_ID'),
1580: l_dim_info('USER_DIM5_ID').dim_member_col,
1581: 'fud5',
1582: p_rownum,

Line 1579: add_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM5_ID'),

1575: p_rownum,
1576: p_xml_file_type);
1577: END IF;
1578: IF (gcs_utility_pkg.get_dimension_required('USER_DIM5_ID') = 'Y') THEN
1579: add_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM5_ID'),
1580: l_dim_info('USER_DIM5_ID').dim_member_col,
1581: 'fud5',
1582: p_rownum,
1583: p_xml_file_type);

Line 1585: IF (gcs_utility_pkg.get_dimension_required('USER_DIM6_ID') = 'Y') THEN

1581: 'fud5',
1582: p_rownum,
1583: p_xml_file_type);
1584: END IF;
1585: IF (gcs_utility_pkg.get_dimension_required('USER_DIM6_ID') = 'Y') THEN
1586: add_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM6_ID'),
1587: l_dim_info('USER_DIM6_ID').dim_member_col,
1588: 'fud6',
1589: p_rownum,

Line 1586: add_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM6_ID'),

1582: p_rownum,
1583: p_xml_file_type);
1584: END IF;
1585: IF (gcs_utility_pkg.get_dimension_required('USER_DIM6_ID') = 'Y') THEN
1586: add_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM6_ID'),
1587: l_dim_info('USER_DIM6_ID').dim_member_col,
1588: 'fud6',
1589: p_rownum,
1590: p_xml_file_type);

Line 1592: IF (gcs_utility_pkg.get_dimension_required('USER_DIM7_ID') = 'Y') THEN

1588: 'fud6',
1589: p_rownum,
1590: p_xml_file_type);
1591: END IF;
1592: IF (gcs_utility_pkg.get_dimension_required('USER_DIM7_ID') = 'Y') THEN
1593: add_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM7_ID'),
1594: l_dim_info('USER_DIM7_ID').dim_member_col,
1595: 'fud7',
1596: p_rownum,

Line 1593: add_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM7_ID'),

1589: p_rownum,
1590: p_xml_file_type);
1591: END IF;
1592: IF (gcs_utility_pkg.get_dimension_required('USER_DIM7_ID') = 'Y') THEN
1593: add_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM7_ID'),
1594: l_dim_info('USER_DIM7_ID').dim_member_col,
1595: 'fud7',
1596: p_rownum,
1597: p_xml_file_type);

Line 1599: IF (gcs_utility_pkg.get_dimension_required('USER_DIM8_ID') = 'Y') THEN

1595: 'fud7',
1596: p_rownum,
1597: p_xml_file_type);
1598: END IF;
1599: IF (gcs_utility_pkg.get_dimension_required('USER_DIM8_ID') = 'Y') THEN
1600: add_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM8_ID'),
1601: l_dim_info('USER_DIM8_ID').dim_member_col,
1602: 'fud8',
1603: p_rownum,

Line 1600: add_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM8_ID'),

1596: p_rownum,
1597: p_xml_file_type);
1598: END IF;
1599: IF (gcs_utility_pkg.get_dimension_required('USER_DIM8_ID') = 'Y') THEN
1600: add_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM8_ID'),
1601: l_dim_info('USER_DIM8_ID').dim_member_col,
1602: 'fud8',
1603: p_rownum,
1604: p_xml_file_type);

Line 1606: IF (gcs_utility_pkg.get_dimension_required('USER_DIM9_ID') = 'Y') THEN

1602: 'fud8',
1603: p_rownum,
1604: p_xml_file_type);
1605: END IF;
1606: IF (gcs_utility_pkg.get_dimension_required('USER_DIM9_ID') = 'Y') THEN
1607: add_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM9_ID'),
1608: l_dim_info('USER_DIM9_ID').dim_member_col,
1609: 'fud9',
1610: p_rownum,

Line 1607: add_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM9_ID'),

1603: p_rownum,
1604: p_xml_file_type);
1605: END IF;
1606: IF (gcs_utility_pkg.get_dimension_required('USER_DIM9_ID') = 'Y') THEN
1607: add_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM9_ID'),
1608: l_dim_info('USER_DIM9_ID').dim_member_col,
1609: 'fud9',
1610: p_rownum,
1611: p_xml_file_type);

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

1632: END IF;
1633: END add_table_to_list;
1634: PROCEDURE build_table_list(p_rownum IN OUT NOCOPY NUMBER,
1635: p_xml_file_type IN VARCHAR2) IS
1636: l_dim_info gcs_utility_pkg.t_hash_gcs_dimension_info := gcs_utility_pkg.g_gcs_dimension_info;
1637: BEGIN
1638: IF (p_xml_file_type = 'DSTB') THEN
1639: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('CHANNEL_ID'),
1640: 'fem_channels_tl',

Line 1639: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('CHANNEL_ID'),

1635: p_xml_file_type IN VARCHAR2) IS
1636: l_dim_info gcs_utility_pkg.t_hash_gcs_dimension_info := gcs_utility_pkg.g_gcs_dimension_info;
1637: BEGIN
1638: IF (p_xml_file_type = 'DSTB') THEN
1639: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('CHANNEL_ID'),
1640: 'fem_channels_tl',
1641: 'fchb',
1642: p_rownum,
1643: p_xml_file_type);

Line 1644: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('CUSTOMER_ID'),

1640: 'fem_channels_tl',
1641: 'fchb',
1642: p_rownum,
1643: p_xml_file_type);
1644: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('CUSTOMER_ID'),
1645: 'fem_customers_tl',
1646: 'fcb',
1647: p_rownum,
1648: p_xml_file_type);

Line 1649: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('FINANCIAL_ELEM_ID'),

1645: 'fem_customers_tl',
1646: 'fcb',
1647: p_rownum,
1648: p_xml_file_type);
1649: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('FINANCIAL_ELEM_ID'),
1650: 'fem_fin_elems_tl',
1651: 'ffeb',
1652: p_rownum,
1653: p_xml_file_type);

Line 1654: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('NATURAL_ACCOUNT_ID'),

1650: 'fem_fin_elems_tl',
1651: 'ffeb',
1652: p_rownum,
1653: p_xml_file_type);
1654: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('NATURAL_ACCOUNT_ID'),
1655: 'fem_nat_accts_tl',
1656: 'fnab',
1657: p_rownum,
1658: p_xml_file_type);

Line 1659: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('PRODUCT_ID'),

1655: 'fem_nat_accts_tl',
1656: 'fnab',
1657: p_rownum,
1658: p_xml_file_type);
1659: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('PRODUCT_ID'),
1660: 'fem_products_tl',
1661: 'fpb',
1662: p_rownum,
1663: p_xml_file_type);

Line 1664: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('PROJECT_ID'),

1660: 'fem_products_tl',
1661: 'fpb',
1662: p_rownum,
1663: p_xml_file_type);
1664: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('PROJECT_ID'),
1665: 'fem_projects_tl',
1666: 'fpjb',
1667: p_rownum,
1668: p_xml_file_type);

Line 1669: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('TASK_ID'),

1665: 'fem_projects_tl',
1666: 'fpjb',
1667: p_rownum,
1668: p_xml_file_type);
1669: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('TASK_ID'),
1670: 'fem_tasks_tl',
1671: 'ftb',
1672: p_rownum,
1673: p_xml_file_type);

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

1670: 'fem_tasks_tl',
1671: 'ftb',
1672: p_rownum,
1673: p_xml_file_type);
1674: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID') = 'Y') THEN
1675: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID'),
1676: 'FEM_USER_DIM10_TL',
1677: 'fud10',
1678: p_rownum,

Line 1675: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID'),

1671: 'ftb',
1672: p_rownum,
1673: p_xml_file_type);
1674: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID') = 'Y') THEN
1675: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID'),
1676: 'FEM_USER_DIM10_TL',
1677: 'fud10',
1678: p_rownum,
1679: p_xml_file_type);

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

1677: 'fud10',
1678: p_rownum,
1679: p_xml_file_type);
1680: END IF;
1681: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID') = 'Y') THEN
1682: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID'),
1683: 'FEM_USER_DIM1_TL',
1684: 'fud1',
1685: p_rownum,

Line 1682: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID'),

1678: p_rownum,
1679: p_xml_file_type);
1680: END IF;
1681: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID') = 'Y') THEN
1682: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID'),
1683: 'FEM_USER_DIM1_TL',
1684: 'fud1',
1685: p_rownum,
1686: p_xml_file_type);

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

1684: 'fud1',
1685: p_rownum,
1686: p_xml_file_type);
1687: END IF;
1688: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID') = 'Y') THEN
1689: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID'),
1690: 'FEM_USER_DIM2_TL',
1691: 'fud2',
1692: p_rownum,

Line 1689: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID'),

1685: p_rownum,
1686: p_xml_file_type);
1687: END IF;
1688: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID') = 'Y') THEN
1689: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID'),
1690: 'FEM_USER_DIM2_TL',
1691: 'fud2',
1692: p_rownum,
1693: p_xml_file_type);

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

1691: 'fud2',
1692: p_rownum,
1693: p_xml_file_type);
1694: END IF;
1695: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID') = 'Y') THEN
1696: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID'),
1697: 'FEM_USER_DIM3_TL',
1698: 'fud3',
1699: p_rownum,

Line 1696: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID'),

1692: p_rownum,
1693: p_xml_file_type);
1694: END IF;
1695: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID') = 'Y') THEN
1696: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID'),
1697: 'FEM_USER_DIM3_TL',
1698: 'fud3',
1699: p_rownum,
1700: p_xml_file_type);

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

1698: 'fud3',
1699: p_rownum,
1700: p_xml_file_type);
1701: END IF;
1702: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID') = 'Y') THEN
1703: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID'),
1704: 'FEM_USER_DIM4_TL',
1705: 'fud4',
1706: p_rownum,

Line 1703: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID'),

1699: p_rownum,
1700: p_xml_file_type);
1701: END IF;
1702: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID') = 'Y') THEN
1703: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID'),
1704: 'FEM_USER_DIM4_TL',
1705: 'fud4',
1706: p_rownum,
1707: p_xml_file_type);

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

1705: 'fud4',
1706: p_rownum,
1707: p_xml_file_type);
1708: END IF;
1709: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID') = 'Y') THEN
1710: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID'),
1711: 'FEM_USER_DIM5_TL',
1712: 'fud5',
1713: p_rownum,

Line 1710: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID'),

1706: p_rownum,
1707: p_xml_file_type);
1708: END IF;
1709: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID') = 'Y') THEN
1710: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID'),
1711: 'FEM_USER_DIM5_TL',
1712: 'fud5',
1713: p_rownum,
1714: p_xml_file_type);

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

1712: 'fud5',
1713: p_rownum,
1714: p_xml_file_type);
1715: END IF;
1716: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID') = 'Y') THEN
1717: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID'),
1718: 'FEM_USER_DIM6_TL',
1719: 'fud6',
1720: p_rownum,

Line 1717: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID'),

1713: p_rownum,
1714: p_xml_file_type);
1715: END IF;
1716: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID') = 'Y') THEN
1717: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID'),
1718: 'FEM_USER_DIM6_TL',
1719: 'fud6',
1720: p_rownum,
1721: p_xml_file_type);

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

1719: 'fud6',
1720: p_rownum,
1721: p_xml_file_type);
1722: END IF;
1723: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID') = 'Y') THEN
1724: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID'),
1725: 'FEM_USER_DIM7_TL',
1726: 'fud7',
1727: p_rownum,

Line 1724: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID'),

1720: p_rownum,
1721: p_xml_file_type);
1722: END IF;
1723: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID') = 'Y') THEN
1724: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID'),
1725: 'FEM_USER_DIM7_TL',
1726: 'fud7',
1727: p_rownum,
1728: p_xml_file_type);

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

1726: 'fud7',
1727: p_rownum,
1728: p_xml_file_type);
1729: END IF;
1730: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID') = 'Y') THEN
1731: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID'),
1732: 'FEM_USER_DIM8_TL',
1733: 'fud8',
1734: p_rownum,

Line 1731: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID'),

1727: p_rownum,
1728: p_xml_file_type);
1729: END IF;
1730: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID') = 'Y') THEN
1731: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID'),
1732: 'FEM_USER_DIM8_TL',
1733: 'fud8',
1734: p_rownum,
1735: p_xml_file_type);

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

1733: 'fud8',
1734: p_rownum,
1735: p_xml_file_type);
1736: END IF;
1737: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM9_ID') = 'Y') THEN
1738: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM9_ID'),
1739: 'FEM_USER_DIM9_TL',
1740: 'fud9',
1741: p_rownum,

Line 1738: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM9_ID'),

1734: p_rownum,
1735: p_xml_file_type);
1736: END IF;
1737: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM9_ID') = 'Y') THEN
1738: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM9_ID'),
1739: 'FEM_USER_DIM9_TL',
1740: 'fud9',
1741: p_rownum,
1742: p_xml_file_type);

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

1742: p_xml_file_type);
1743: END IF;
1744: -- Santosh 5234796
1745: /*ELSIF (p_xml_file_type = 'DSLOAD') THEN
1746: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('CHANNEL_ID'), 'fem_channels_b', 'fchb', p_rownum, p_xml_file_type);
1747: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('CHANNEL_ID'), 'fem_channels_tl', 'fchbt', p_rownum, p_xml_file_type);
1748: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('CUSTOMER_ID'), 'fem_customers_b', 'fcb', p_rownum, p_xml_file_type);
1749: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('CUSTOMER_ID'), 'fem_customers_tl', 'fcbt', p_rownum, p_xml_file_type);
1750: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('FINANCIAL_ELEM_ID'), 'fem_fin_elems_b', 'ffeb', p_rownum, p_xml_file_type);

Line 1747: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('CHANNEL_ID'), 'fem_channels_tl', 'fchbt', p_rownum, p_xml_file_type);

1743: END IF;
1744: -- Santosh 5234796
1745: /*ELSIF (p_xml_file_type = 'DSLOAD') THEN
1746: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('CHANNEL_ID'), 'fem_channels_b', 'fchb', p_rownum, p_xml_file_type);
1747: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('CHANNEL_ID'), 'fem_channels_tl', 'fchbt', p_rownum, p_xml_file_type);
1748: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('CUSTOMER_ID'), 'fem_customers_b', 'fcb', p_rownum, p_xml_file_type);
1749: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('CUSTOMER_ID'), 'fem_customers_tl', 'fcbt', p_rownum, p_xml_file_type);
1750: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('FINANCIAL_ELEM_ID'), 'fem_fin_elems_b', 'ffeb', p_rownum, p_xml_file_type);
1751: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('FINANCIAL_ELEM_ID'), 'fem_fin_elems_tl', 'ffebt', p_rownum, p_xml_file_type);

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

1744: -- Santosh 5234796
1745: /*ELSIF (p_xml_file_type = 'DSLOAD') THEN
1746: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('CHANNEL_ID'), 'fem_channels_b', 'fchb', p_rownum, p_xml_file_type);
1747: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('CHANNEL_ID'), 'fem_channels_tl', 'fchbt', p_rownum, p_xml_file_type);
1748: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('CUSTOMER_ID'), 'fem_customers_b', 'fcb', p_rownum, p_xml_file_type);
1749: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('CUSTOMER_ID'), 'fem_customers_tl', 'fcbt', p_rownum, p_xml_file_type);
1750: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('FINANCIAL_ELEM_ID'), 'fem_fin_elems_b', 'ffeb', p_rownum, p_xml_file_type);
1751: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('FINANCIAL_ELEM_ID'), 'fem_fin_elems_tl', 'ffebt', p_rownum, p_xml_file_type);
1752: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('NATURAL_ACCOUNT_ID'), 'fem_nat_accts_b', 'fnab', p_rownum, p_xml_file_type);

Line 1749: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('CUSTOMER_ID'), 'fem_customers_tl', 'fcbt', p_rownum, p_xml_file_type);

1745: /*ELSIF (p_xml_file_type = 'DSLOAD') THEN
1746: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('CHANNEL_ID'), 'fem_channels_b', 'fchb', p_rownum, p_xml_file_type);
1747: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('CHANNEL_ID'), 'fem_channels_tl', 'fchbt', p_rownum, p_xml_file_type);
1748: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('CUSTOMER_ID'), 'fem_customers_b', 'fcb', p_rownum, p_xml_file_type);
1749: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('CUSTOMER_ID'), 'fem_customers_tl', 'fcbt', p_rownum, p_xml_file_type);
1750: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('FINANCIAL_ELEM_ID'), 'fem_fin_elems_b', 'ffeb', p_rownum, p_xml_file_type);
1751: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('FINANCIAL_ELEM_ID'), 'fem_fin_elems_tl', 'ffebt', p_rownum, p_xml_file_type);
1752: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('NATURAL_ACCOUNT_ID'), 'fem_nat_accts_b', 'fnab', p_rownum, p_xml_file_type);
1753: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('NATURAL_ACCOUNT_ID'), 'fem_nat_accts_tl', 'fnabt', p_rownum, p_xml_file_type);

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

1746: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('CHANNEL_ID'), 'fem_channels_b', 'fchb', p_rownum, p_xml_file_type);
1747: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('CHANNEL_ID'), 'fem_channels_tl', 'fchbt', p_rownum, p_xml_file_type);
1748: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('CUSTOMER_ID'), 'fem_customers_b', 'fcb', p_rownum, p_xml_file_type);
1749: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('CUSTOMER_ID'), 'fem_customers_tl', 'fcbt', p_rownum, p_xml_file_type);
1750: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('FINANCIAL_ELEM_ID'), 'fem_fin_elems_b', 'ffeb', p_rownum, p_xml_file_type);
1751: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('FINANCIAL_ELEM_ID'), 'fem_fin_elems_tl', 'ffebt', p_rownum, p_xml_file_type);
1752: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('NATURAL_ACCOUNT_ID'), 'fem_nat_accts_b', 'fnab', p_rownum, p_xml_file_type);
1753: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('NATURAL_ACCOUNT_ID'), 'fem_nat_accts_tl', 'fnabt', p_rownum, p_xml_file_type);
1754: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('PRODUCT_ID'), 'fem_products_b', 'fpb', p_rownum, p_xml_file_type);

Line 1751: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('FINANCIAL_ELEM_ID'), 'fem_fin_elems_tl', 'ffebt', p_rownum, p_xml_file_type);

1747: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('CHANNEL_ID'), 'fem_channels_tl', 'fchbt', p_rownum, p_xml_file_type);
1748: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('CUSTOMER_ID'), 'fem_customers_b', 'fcb', p_rownum, p_xml_file_type);
1749: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('CUSTOMER_ID'), 'fem_customers_tl', 'fcbt', p_rownum, p_xml_file_type);
1750: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('FINANCIAL_ELEM_ID'), 'fem_fin_elems_b', 'ffeb', p_rownum, p_xml_file_type);
1751: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('FINANCIAL_ELEM_ID'), 'fem_fin_elems_tl', 'ffebt', p_rownum, p_xml_file_type);
1752: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('NATURAL_ACCOUNT_ID'), 'fem_nat_accts_b', 'fnab', p_rownum, p_xml_file_type);
1753: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('NATURAL_ACCOUNT_ID'), 'fem_nat_accts_tl', 'fnabt', p_rownum, p_xml_file_type);
1754: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('PRODUCT_ID'), 'fem_products_b', 'fpb', p_rownum, p_xml_file_type);
1755: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('PRODUCT_ID'), 'fem_products_tl', 'fpbt', p_rownum, p_xml_file_type);

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

1748: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('CUSTOMER_ID'), 'fem_customers_b', 'fcb', p_rownum, p_xml_file_type);
1749: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('CUSTOMER_ID'), 'fem_customers_tl', 'fcbt', p_rownum, p_xml_file_type);
1750: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('FINANCIAL_ELEM_ID'), 'fem_fin_elems_b', 'ffeb', p_rownum, p_xml_file_type);
1751: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('FINANCIAL_ELEM_ID'), 'fem_fin_elems_tl', 'ffebt', p_rownum, p_xml_file_type);
1752: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('NATURAL_ACCOUNT_ID'), 'fem_nat_accts_b', 'fnab', p_rownum, p_xml_file_type);
1753: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('NATURAL_ACCOUNT_ID'), 'fem_nat_accts_tl', 'fnabt', p_rownum, p_xml_file_type);
1754: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('PRODUCT_ID'), 'fem_products_b', 'fpb', p_rownum, p_xml_file_type);
1755: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('PRODUCT_ID'), 'fem_products_tl', 'fpbt', p_rownum, p_xml_file_type);
1756: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('PROJECT_ID'), 'fem_projects_b', 'fpjb', p_rownum, p_xml_file_type);

Line 1753: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('NATURAL_ACCOUNT_ID'), 'fem_nat_accts_tl', 'fnabt', p_rownum, p_xml_file_type);

1749: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('CUSTOMER_ID'), 'fem_customers_tl', 'fcbt', p_rownum, p_xml_file_type);
1750: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('FINANCIAL_ELEM_ID'), 'fem_fin_elems_b', 'ffeb', p_rownum, p_xml_file_type);
1751: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('FINANCIAL_ELEM_ID'), 'fem_fin_elems_tl', 'ffebt', p_rownum, p_xml_file_type);
1752: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('NATURAL_ACCOUNT_ID'), 'fem_nat_accts_b', 'fnab', p_rownum, p_xml_file_type);
1753: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('NATURAL_ACCOUNT_ID'), 'fem_nat_accts_tl', 'fnabt', p_rownum, p_xml_file_type);
1754: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('PRODUCT_ID'), 'fem_products_b', 'fpb', p_rownum, p_xml_file_type);
1755: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('PRODUCT_ID'), 'fem_products_tl', 'fpbt', p_rownum, p_xml_file_type);
1756: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('PROJECT_ID'), 'fem_projects_b', 'fpjb', p_rownum, p_xml_file_type);
1757: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('PROJECT_ID'), 'fem_projects_tl', 'fpjbt', p_rownum, p_xml_file_type);

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

1750: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('FINANCIAL_ELEM_ID'), 'fem_fin_elems_b', 'ffeb', p_rownum, p_xml_file_type);
1751: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('FINANCIAL_ELEM_ID'), 'fem_fin_elems_tl', 'ffebt', p_rownum, p_xml_file_type);
1752: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('NATURAL_ACCOUNT_ID'), 'fem_nat_accts_b', 'fnab', p_rownum, p_xml_file_type);
1753: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('NATURAL_ACCOUNT_ID'), 'fem_nat_accts_tl', 'fnabt', p_rownum, p_xml_file_type);
1754: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('PRODUCT_ID'), 'fem_products_b', 'fpb', p_rownum, p_xml_file_type);
1755: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('PRODUCT_ID'), 'fem_products_tl', 'fpbt', p_rownum, p_xml_file_type);
1756: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('PROJECT_ID'), 'fem_projects_b', 'fpjb', p_rownum, p_xml_file_type);
1757: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('PROJECT_ID'), 'fem_projects_tl', 'fpjbt', p_rownum, p_xml_file_type);
1758: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('TASK_ID'), 'fem_tasks_b', 'ftb', p_rownum, p_xml_file_type);

Line 1755: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('PRODUCT_ID'), 'fem_products_tl', 'fpbt', p_rownum, p_xml_file_type);

1751: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('FINANCIAL_ELEM_ID'), 'fem_fin_elems_tl', 'ffebt', p_rownum, p_xml_file_type);
1752: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('NATURAL_ACCOUNT_ID'), 'fem_nat_accts_b', 'fnab', p_rownum, p_xml_file_type);
1753: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('NATURAL_ACCOUNT_ID'), 'fem_nat_accts_tl', 'fnabt', p_rownum, p_xml_file_type);
1754: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('PRODUCT_ID'), 'fem_products_b', 'fpb', p_rownum, p_xml_file_type);
1755: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('PRODUCT_ID'), 'fem_products_tl', 'fpbt', p_rownum, p_xml_file_type);
1756: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('PROJECT_ID'), 'fem_projects_b', 'fpjb', p_rownum, p_xml_file_type);
1757: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('PROJECT_ID'), 'fem_projects_tl', 'fpjbt', p_rownum, p_xml_file_type);
1758: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('TASK_ID'), 'fem_tasks_b', 'ftb', p_rownum, p_xml_file_type);
1759: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('TASK_ID'), 'fem_tasks_tl', 'ftbt', p_rownum, p_xml_file_type);

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

1752: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('NATURAL_ACCOUNT_ID'), 'fem_nat_accts_b', 'fnab', p_rownum, p_xml_file_type);
1753: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('NATURAL_ACCOUNT_ID'), 'fem_nat_accts_tl', 'fnabt', p_rownum, p_xml_file_type);
1754: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('PRODUCT_ID'), 'fem_products_b', 'fpb', p_rownum, p_xml_file_type);
1755: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('PRODUCT_ID'), 'fem_products_tl', 'fpbt', p_rownum, p_xml_file_type);
1756: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('PROJECT_ID'), 'fem_projects_b', 'fpjb', p_rownum, p_xml_file_type);
1757: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('PROJECT_ID'), 'fem_projects_tl', 'fpjbt', p_rownum, p_xml_file_type);
1758: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('TASK_ID'), 'fem_tasks_b', 'ftb', p_rownum, p_xml_file_type);
1759: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('TASK_ID'), 'fem_tasks_tl', 'ftbt', p_rownum, p_xml_file_type);
1760: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID') = 'Y') THEN

Line 1757: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('PROJECT_ID'), 'fem_projects_tl', 'fpjbt', p_rownum, p_xml_file_type);

1753: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('NATURAL_ACCOUNT_ID'), 'fem_nat_accts_tl', 'fnabt', p_rownum, p_xml_file_type);
1754: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('PRODUCT_ID'), 'fem_products_b', 'fpb', p_rownum, p_xml_file_type);
1755: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('PRODUCT_ID'), 'fem_products_tl', 'fpbt', p_rownum, p_xml_file_type);
1756: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('PROJECT_ID'), 'fem_projects_b', 'fpjb', p_rownum, p_xml_file_type);
1757: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('PROJECT_ID'), 'fem_projects_tl', 'fpjbt', p_rownum, p_xml_file_type);
1758: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('TASK_ID'), 'fem_tasks_b', 'ftb', p_rownum, p_xml_file_type);
1759: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('TASK_ID'), 'fem_tasks_tl', 'ftbt', p_rownum, p_xml_file_type);
1760: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID') = 'Y') THEN
1761: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID'),'FEM_USER_DIM10_B',

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

1754: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('PRODUCT_ID'), 'fem_products_b', 'fpb', p_rownum, p_xml_file_type);
1755: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('PRODUCT_ID'), 'fem_products_tl', 'fpbt', p_rownum, p_xml_file_type);
1756: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('PROJECT_ID'), 'fem_projects_b', 'fpjb', p_rownum, p_xml_file_type);
1757: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('PROJECT_ID'), 'fem_projects_tl', 'fpjbt', p_rownum, p_xml_file_type);
1758: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('TASK_ID'), 'fem_tasks_b', 'ftb', p_rownum, p_xml_file_type);
1759: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('TASK_ID'), 'fem_tasks_tl', 'ftbt', p_rownum, p_xml_file_type);
1760: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID') = 'Y') THEN
1761: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID'),'FEM_USER_DIM10_B',
1762: 'fud10', p_rownum, p_xml_file_type);

Line 1759: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('TASK_ID'), 'fem_tasks_tl', 'ftbt', p_rownum, p_xml_file_type);

1755: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('PRODUCT_ID'), 'fem_products_tl', 'fpbt', p_rownum, p_xml_file_type);
1756: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('PROJECT_ID'), 'fem_projects_b', 'fpjb', p_rownum, p_xml_file_type);
1757: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('PROJECT_ID'), 'fem_projects_tl', 'fpjbt', p_rownum, p_xml_file_type);
1758: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('TASK_ID'), 'fem_tasks_b', 'ftb', p_rownum, p_xml_file_type);
1759: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('TASK_ID'), 'fem_tasks_tl', 'ftbt', p_rownum, p_xml_file_type);
1760: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID') = 'Y') THEN
1761: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID'),'FEM_USER_DIM10_B',
1762: 'fud10', p_rownum, p_xml_file_type);
1763: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID'),'FEM_USER_DIM10_TL',

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

1756: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('PROJECT_ID'), 'fem_projects_b', 'fpjb', p_rownum, p_xml_file_type);
1757: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('PROJECT_ID'), 'fem_projects_tl', 'fpjbt', p_rownum, p_xml_file_type);
1758: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('TASK_ID'), 'fem_tasks_b', 'ftb', p_rownum, p_xml_file_type);
1759: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('TASK_ID'), 'fem_tasks_tl', 'ftbt', p_rownum, p_xml_file_type);
1760: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID') = 'Y') THEN
1761: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID'),'FEM_USER_DIM10_B',
1762: 'fud10', p_rownum, p_xml_file_type);
1763: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID'),'FEM_USER_DIM10_TL',
1764: 'fud10T', p_rownum, p_xml_file_type);

Line 1761: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID'),'FEM_USER_DIM10_B',

1757: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('PROJECT_ID'), 'fem_projects_tl', 'fpjbt', p_rownum, p_xml_file_type);
1758: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('TASK_ID'), 'fem_tasks_b', 'ftb', p_rownum, p_xml_file_type);
1759: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('TASK_ID'), 'fem_tasks_tl', 'ftbt', p_rownum, p_xml_file_type);
1760: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID') = 'Y') THEN
1761: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID'),'FEM_USER_DIM10_B',
1762: 'fud10', p_rownum, p_xml_file_type);
1763: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID'),'FEM_USER_DIM10_TL',
1764: 'fud10T', p_rownum, p_xml_file_type);
1765: END IF;

Line 1763: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID'),'FEM_USER_DIM10_TL',

1759: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('TASK_ID'), 'fem_tasks_tl', 'ftbt', p_rownum, p_xml_file_type);
1760: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID') = 'Y') THEN
1761: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID'),'FEM_USER_DIM10_B',
1762: 'fud10', p_rownum, p_xml_file_type);
1763: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID'),'FEM_USER_DIM10_TL',
1764: 'fud10T', p_rownum, p_xml_file_type);
1765: END IF;
1766: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID') = 'Y') THEN
1767: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID'), 'FEM_USER_DIM1_B',

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

1762: 'fud10', p_rownum, p_xml_file_type);
1763: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID'),'FEM_USER_DIM10_TL',
1764: 'fud10T', p_rownum, p_xml_file_type);
1765: END IF;
1766: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID') = 'Y') THEN
1767: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID'), 'FEM_USER_DIM1_B',
1768: 'fud1', p_rownum, p_xml_file_type);
1769: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID'), 'FEM_USER_DIM1_TL',
1770: 'fud1T', p_rownum, p_xml_file_type);

Line 1767: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID'), 'FEM_USER_DIM1_B',

1763: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID'),'FEM_USER_DIM10_TL',
1764: 'fud10T', p_rownum, p_xml_file_type);
1765: END IF;
1766: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID') = 'Y') THEN
1767: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID'), 'FEM_USER_DIM1_B',
1768: 'fud1', p_rownum, p_xml_file_type);
1769: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID'), 'FEM_USER_DIM1_TL',
1770: 'fud1T', p_rownum, p_xml_file_type);
1771: END IF;

Line 1769: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID'), 'FEM_USER_DIM1_TL',

1765: END IF;
1766: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID') = 'Y') THEN
1767: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID'), 'FEM_USER_DIM1_B',
1768: 'fud1', p_rownum, p_xml_file_type);
1769: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID'), 'FEM_USER_DIM1_TL',
1770: 'fud1T', p_rownum, p_xml_file_type);
1771: END IF;
1772: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID') = 'Y') THEN
1773: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID'), 'FEM_USER_DIM2_B',

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

1768: 'fud1', p_rownum, p_xml_file_type);
1769: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID'), 'FEM_USER_DIM1_TL',
1770: 'fud1T', p_rownum, p_xml_file_type);
1771: END IF;
1772: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID') = 'Y') THEN
1773: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID'), 'FEM_USER_DIM2_B',
1774: 'fud2', p_rownum, p_xml_file_type);
1775: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID'), 'FEM_USER_DIM2_TL',
1776: 'fud2T', p_rownum, p_xml_file_type);

Line 1773: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID'), 'FEM_USER_DIM2_B',

1769: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID'), 'FEM_USER_DIM1_TL',
1770: 'fud1T', p_rownum, p_xml_file_type);
1771: END IF;
1772: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID') = 'Y') THEN
1773: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID'), 'FEM_USER_DIM2_B',
1774: 'fud2', p_rownum, p_xml_file_type);
1775: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID'), 'FEM_USER_DIM2_TL',
1776: 'fud2T', p_rownum, p_xml_file_type);
1777: END IF;

Line 1775: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID'), 'FEM_USER_DIM2_TL',

1771: END IF;
1772: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID') = 'Y') THEN
1773: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID'), 'FEM_USER_DIM2_B',
1774: 'fud2', p_rownum, p_xml_file_type);
1775: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID'), 'FEM_USER_DIM2_TL',
1776: 'fud2T', p_rownum, p_xml_file_type);
1777: END IF;
1778: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID') = 'Y') THEN
1779: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID'), 'FEM_USER_DIM3_B',

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

1774: 'fud2', p_rownum, p_xml_file_type);
1775: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID'), 'FEM_USER_DIM2_TL',
1776: 'fud2T', p_rownum, p_xml_file_type);
1777: END IF;
1778: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID') = 'Y') THEN
1779: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID'), 'FEM_USER_DIM3_B',
1780: 'fud3', p_rownum, p_xml_file_type);
1781: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID'), 'FEM_USER_DIM3_TL',
1782: 'fud3T', p_rownum, p_xml_file_type);

Line 1779: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID'), 'FEM_USER_DIM3_B',

1775: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID'), 'FEM_USER_DIM2_TL',
1776: 'fud2T', p_rownum, p_xml_file_type);
1777: END IF;
1778: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID') = 'Y') THEN
1779: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID'), 'FEM_USER_DIM3_B',
1780: 'fud3', p_rownum, p_xml_file_type);
1781: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID'), 'FEM_USER_DIM3_TL',
1782: 'fud3T', p_rownum, p_xml_file_type);
1783: END IF;

Line 1781: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID'), 'FEM_USER_DIM3_TL',

1777: END IF;
1778: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID') = 'Y') THEN
1779: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID'), 'FEM_USER_DIM3_B',
1780: 'fud3', p_rownum, p_xml_file_type);
1781: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID'), 'FEM_USER_DIM3_TL',
1782: 'fud3T', p_rownum, p_xml_file_type);
1783: END IF;
1784: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID') = 'Y') THEN
1785: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID'), 'FEM_USER_DIM4_B',

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

1780: 'fud3', p_rownum, p_xml_file_type);
1781: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID'), 'FEM_USER_DIM3_TL',
1782: 'fud3T', p_rownum, p_xml_file_type);
1783: END IF;
1784: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID') = 'Y') THEN
1785: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID'), 'FEM_USER_DIM4_B',
1786: 'fud4', p_rownum, p_xml_file_type);
1787: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID'), 'FEM_USER_DIM4_TL',
1788: 'fud4T', p_rownum, p_xml_file_type);

Line 1785: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID'), 'FEM_USER_DIM4_B',

1781: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID'), 'FEM_USER_DIM3_TL',
1782: 'fud3T', p_rownum, p_xml_file_type);
1783: END IF;
1784: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID') = 'Y') THEN
1785: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID'), 'FEM_USER_DIM4_B',
1786: 'fud4', p_rownum, p_xml_file_type);
1787: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID'), 'FEM_USER_DIM4_TL',
1788: 'fud4T', p_rownum, p_xml_file_type);
1789: END IF;

Line 1787: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID'), 'FEM_USER_DIM4_TL',

1783: END IF;
1784: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID') = 'Y') THEN
1785: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID'), 'FEM_USER_DIM4_B',
1786: 'fud4', p_rownum, p_xml_file_type);
1787: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID'), 'FEM_USER_DIM4_TL',
1788: 'fud4T', p_rownum, p_xml_file_type);
1789: END IF;
1790: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID') = 'Y') THEN
1791: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID'), 'FEM_USER_DIM5_B',

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

1786: 'fud4', p_rownum, p_xml_file_type);
1787: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID'), 'FEM_USER_DIM4_TL',
1788: 'fud4T', p_rownum, p_xml_file_type);
1789: END IF;
1790: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID') = 'Y') THEN
1791: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID'), 'FEM_USER_DIM5_B',
1792: 'fud5', p_rownum, p_xml_file_type);
1793: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID'), 'FEM_USER_DIM5_TL',
1794: 'fud5T', p_rownum, p_xml_file_type);

Line 1791: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID'), 'FEM_USER_DIM5_B',

1787: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID'), 'FEM_USER_DIM4_TL',
1788: 'fud4T', p_rownum, p_xml_file_type);
1789: END IF;
1790: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID') = 'Y') THEN
1791: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID'), 'FEM_USER_DIM5_B',
1792: 'fud5', p_rownum, p_xml_file_type);
1793: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID'), 'FEM_USER_DIM5_TL',
1794: 'fud5T', p_rownum, p_xml_file_type);
1795: END IF;

Line 1793: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID'), 'FEM_USER_DIM5_TL',

1789: END IF;
1790: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID') = 'Y') THEN
1791: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID'), 'FEM_USER_DIM5_B',
1792: 'fud5', p_rownum, p_xml_file_type);
1793: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID'), 'FEM_USER_DIM5_TL',
1794: 'fud5T', p_rownum, p_xml_file_type);
1795: END IF;
1796: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID') = 'Y') THEN
1797: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID'), 'FEM_USER_DIM6_B',

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

1792: 'fud5', p_rownum, p_xml_file_type);
1793: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID'), 'FEM_USER_DIM5_TL',
1794: 'fud5T', p_rownum, p_xml_file_type);
1795: END IF;
1796: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID') = 'Y') THEN
1797: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID'), 'FEM_USER_DIM6_B',
1798: 'fud6', p_rownum, p_xml_file_type);
1799: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID'), 'FEM_USER_DIM6_TL',
1800: 'fud6T', p_rownum, p_xml_file_type);

Line 1797: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID'), 'FEM_USER_DIM6_B',

1793: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID'), 'FEM_USER_DIM5_TL',
1794: 'fud5T', p_rownum, p_xml_file_type);
1795: END IF;
1796: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID') = 'Y') THEN
1797: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID'), 'FEM_USER_DIM6_B',
1798: 'fud6', p_rownum, p_xml_file_type);
1799: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID'), 'FEM_USER_DIM6_TL',
1800: 'fud6T', p_rownum, p_xml_file_type);
1801: END IF;

Line 1799: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID'), 'FEM_USER_DIM6_TL',

1795: END IF;
1796: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID') = 'Y') THEN
1797: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID'), 'FEM_USER_DIM6_B',
1798: 'fud6', p_rownum, p_xml_file_type);
1799: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID'), 'FEM_USER_DIM6_TL',
1800: 'fud6T', p_rownum, p_xml_file_type);
1801: END IF;
1802: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID') = 'Y') THEN
1803: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID'), 'FEM_USER_DIM7_B',

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

1798: 'fud6', p_rownum, p_xml_file_type);
1799: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID'), 'FEM_USER_DIM6_TL',
1800: 'fud6T', p_rownum, p_xml_file_type);
1801: END IF;
1802: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID') = 'Y') THEN
1803: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID'), 'FEM_USER_DIM7_B',
1804: 'fud7', p_rownum, p_xml_file_type);
1805: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID'), 'FEM_USER_DIM7_TL',
1806: 'fud7T', p_rownum, p_xml_file_type);

Line 1803: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID'), 'FEM_USER_DIM7_B',

1799: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID'), 'FEM_USER_DIM6_TL',
1800: 'fud6T', p_rownum, p_xml_file_type);
1801: END IF;
1802: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID') = 'Y') THEN
1803: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID'), 'FEM_USER_DIM7_B',
1804: 'fud7', p_rownum, p_xml_file_type);
1805: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID'), 'FEM_USER_DIM7_TL',
1806: 'fud7T', p_rownum, p_xml_file_type);
1807: END IF;

Line 1805: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID'), 'FEM_USER_DIM7_TL',

1801: END IF;
1802: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID') = 'Y') THEN
1803: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID'), 'FEM_USER_DIM7_B',
1804: 'fud7', p_rownum, p_xml_file_type);
1805: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID'), 'FEM_USER_DIM7_TL',
1806: 'fud7T', p_rownum, p_xml_file_type);
1807: END IF;
1808: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID') = 'Y') THEN
1809: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID'), 'FEM_USER_DIM8_B',

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

1804: 'fud7', p_rownum, p_xml_file_type);
1805: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID'), 'FEM_USER_DIM7_TL',
1806: 'fud7T', p_rownum, p_xml_file_type);
1807: END IF;
1808: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID') = 'Y') THEN
1809: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID'), 'FEM_USER_DIM8_B',
1810: 'fud8', p_rownum, p_xml_file_type);
1811: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID'), 'FEM_USER_DIM8_TL',
1812: 'fud8T', p_rownum, p_xml_file_type);

Line 1809: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID'), 'FEM_USER_DIM8_B',

1805: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID'), 'FEM_USER_DIM7_TL',
1806: 'fud7T', p_rownum, p_xml_file_type);
1807: END IF;
1808: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID') = 'Y') THEN
1809: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID'), 'FEM_USER_DIM8_B',
1810: 'fud8', p_rownum, p_xml_file_type);
1811: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID'), 'FEM_USER_DIM8_TL',
1812: 'fud8T', p_rownum, p_xml_file_type);
1813: END IF;

Line 1811: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID'), 'FEM_USER_DIM8_TL',

1807: END IF;
1808: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID') = 'Y') THEN
1809: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID'), 'FEM_USER_DIM8_B',
1810: 'fud8', p_rownum, p_xml_file_type);
1811: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID'), 'FEM_USER_DIM8_TL',
1812: 'fud8T', p_rownum, p_xml_file_type);
1813: END IF;
1814: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM9_ID') = 'Y') THEN
1815: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM9_ID'), 'FEM_USER_DIM9_B',

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

1810: 'fud8', p_rownum, p_xml_file_type);
1811: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID'), 'FEM_USER_DIM8_TL',
1812: 'fud8T', p_rownum, p_xml_file_type);
1813: END IF;
1814: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM9_ID') = 'Y') THEN
1815: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM9_ID'), 'FEM_USER_DIM9_B',
1816: 'fud9', p_rownum, p_xml_file_type);
1817: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM9_ID'), 'FEM_USER_DIM9_TL',
1818: 'fud9T', p_rownum, p_xml_file_type);

Line 1815: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM9_ID'), 'FEM_USER_DIM9_B',

1811: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID'), 'FEM_USER_DIM8_TL',
1812: 'fud8T', p_rownum, p_xml_file_type);
1813: END IF;
1814: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM9_ID') = 'Y') THEN
1815: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM9_ID'), 'FEM_USER_DIM9_B',
1816: 'fud9', p_rownum, p_xml_file_type);
1817: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM9_ID'), 'FEM_USER_DIM9_TL',
1818: 'fud9T', p_rownum, p_xml_file_type);
1819: END IF;

Line 1817: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM9_ID'), 'FEM_USER_DIM9_TL',

1813: END IF;
1814: IF (gcs_utility_pkg.get_fem_dim_required('USER_DIM9_ID') = 'Y') THEN
1815: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM9_ID'), 'FEM_USER_DIM9_B',
1816: 'fud9', p_rownum, p_xml_file_type);
1817: add_table_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM9_ID'), 'FEM_USER_DIM9_TL',
1818: 'fud9T', p_rownum, p_xml_file_type);
1819: END IF;
1820: */
1821: ELSIF (p_xml_file_type = 'ADTB') THEN

Line 1822: add_table_to_list(gcs_utility_pkg.get_dimension_required('CHANNEL_ID'),

1818: 'fud9T', p_rownum, p_xml_file_type);
1819: END IF;
1820: */
1821: ELSIF (p_xml_file_type = 'ADTB') THEN
1822: add_table_to_list(gcs_utility_pkg.get_dimension_required('CHANNEL_ID'),
1823: 'fem_channels_tl',
1824: 'fchb',
1825: p_rownum,
1826: p_xml_file_type);

Line 1827: add_table_to_list(gcs_utility_pkg.get_dimension_required('CUSTOMER_ID'),

1823: 'fem_channels_tl',
1824: 'fchb',
1825: p_rownum,
1826: p_xml_file_type);
1827: add_table_to_list(gcs_utility_pkg.get_dimension_required('CUSTOMER_ID'),
1828: 'fem_customers_tl',
1829: 'fcb',
1830: p_rownum,
1831: p_xml_file_type);

Line 1832: add_table_to_list(gcs_utility_pkg.get_dimension_required('FINANCIAL_ELEM_ID'),

1828: 'fem_customers_tl',
1829: 'fcb',
1830: p_rownum,
1831: p_xml_file_type);
1832: add_table_to_list(gcs_utility_pkg.get_dimension_required('FINANCIAL_ELEM_ID'),
1833: 'fem_fin_elems_tl',
1834: 'ffeb',
1835: p_rownum,
1836: p_xml_file_type);

Line 1837: add_table_to_list(gcs_utility_pkg.get_dimension_required('NATURAL_ACCOUNT_ID'),

1833: 'fem_fin_elems_tl',
1834: 'ffeb',
1835: p_rownum,
1836: p_xml_file_type);
1837: add_table_to_list(gcs_utility_pkg.get_dimension_required('NATURAL_ACCOUNT_ID'),
1838: 'fem_nat_accts_tl',
1839: 'fnab',
1840: p_rownum,
1841: p_xml_file_type);

Line 1842: add_table_to_list(gcs_utility_pkg.get_dimension_required('PRODUCT_ID'),

1838: 'fem_nat_accts_tl',
1839: 'fnab',
1840: p_rownum,
1841: p_xml_file_type);
1842: add_table_to_list(gcs_utility_pkg.get_dimension_required('PRODUCT_ID'),
1843: 'fem_products_tl',
1844: 'fpb',
1845: p_rownum,
1846: p_xml_file_type);

Line 1847: add_table_to_list(gcs_utility_pkg.get_dimension_required('PROJECT_ID'),

1843: 'fem_products_tl',
1844: 'fpb',
1845: p_rownum,
1846: p_xml_file_type);
1847: add_table_to_list(gcs_utility_pkg.get_dimension_required('PROJECT_ID'),
1848: 'fem_projects_tl',
1849: 'fpjb',
1850: p_rownum,
1851: p_xml_file_type);

Line 1852: add_table_to_list(gcs_utility_pkg.get_dimension_required('TASK_ID'),

1848: 'fem_projects_tl',
1849: 'fpjb',
1850: p_rownum,
1851: p_xml_file_type);
1852: add_table_to_list(gcs_utility_pkg.get_dimension_required('TASK_ID'),
1853: 'fem_tasks_tl',
1854: 'ftb',
1855: p_rownum,
1856: p_xml_file_type);

Line 1857: IF (gcs_utility_pkg.get_dimension_required('USER_DIM10_ID') = 'Y') THEN

1853: 'fem_tasks_tl',
1854: 'ftb',
1855: p_rownum,
1856: p_xml_file_type);
1857: IF (gcs_utility_pkg.get_dimension_required('USER_DIM10_ID') = 'Y') THEN
1858: add_table_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM10_ID'),
1859: 'FEM_USER_DIM10_TL',
1860: 'fud10',
1861: p_rownum,

Line 1858: add_table_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM10_ID'),

1854: 'ftb',
1855: p_rownum,
1856: p_xml_file_type);
1857: IF (gcs_utility_pkg.get_dimension_required('USER_DIM10_ID') = 'Y') THEN
1858: add_table_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM10_ID'),
1859: 'FEM_USER_DIM10_TL',
1860: 'fud10',
1861: p_rownum,
1862: p_xml_file_type);

Line 1864: IF (gcs_utility_pkg.get_dimension_required('USER_DIM1_ID') = 'Y') THEN

1860: 'fud10',
1861: p_rownum,
1862: p_xml_file_type);
1863: END IF;
1864: IF (gcs_utility_pkg.get_dimension_required('USER_DIM1_ID') = 'Y') THEN
1865: add_table_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM1_ID'),
1866: 'FEM_USER_DIM1_TL',
1867: 'fud1',
1868: p_rownum,

Line 1865: add_table_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM1_ID'),

1861: p_rownum,
1862: p_xml_file_type);
1863: END IF;
1864: IF (gcs_utility_pkg.get_dimension_required('USER_DIM1_ID') = 'Y') THEN
1865: add_table_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM1_ID'),
1866: 'FEM_USER_DIM1_TL',
1867: 'fud1',
1868: p_rownum,
1869: p_xml_file_type);

Line 1871: IF (gcs_utility_pkg.get_dimension_required('USER_DIM2_ID') = 'Y') THEN

1867: 'fud1',
1868: p_rownum,
1869: p_xml_file_type);
1870: END IF;
1871: IF (gcs_utility_pkg.get_dimension_required('USER_DIM2_ID') = 'Y') THEN
1872: add_table_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM2_ID'),
1873: 'FEM_USER_DIM2_TL',
1874: 'fud2',
1875: p_rownum,

Line 1872: add_table_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM2_ID'),

1868: p_rownum,
1869: p_xml_file_type);
1870: END IF;
1871: IF (gcs_utility_pkg.get_dimension_required('USER_DIM2_ID') = 'Y') THEN
1872: add_table_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM2_ID'),
1873: 'FEM_USER_DIM2_TL',
1874: 'fud2',
1875: p_rownum,
1876: p_xml_file_type);

Line 1878: IF (gcs_utility_pkg.get_dimension_required('USER_DIM3_ID') = 'Y') THEN

1874: 'fud2',
1875: p_rownum,
1876: p_xml_file_type);
1877: END IF;
1878: IF (gcs_utility_pkg.get_dimension_required('USER_DIM3_ID') = 'Y') THEN
1879: add_table_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM3_ID'),
1880: 'FEM_USER_DIM3_TL',
1881: 'fud3',
1882: p_rownum,

Line 1879: add_table_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM3_ID'),

1875: p_rownum,
1876: p_xml_file_type);
1877: END IF;
1878: IF (gcs_utility_pkg.get_dimension_required('USER_DIM3_ID') = 'Y') THEN
1879: add_table_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM3_ID'),
1880: 'FEM_USER_DIM3_TL',
1881: 'fud3',
1882: p_rownum,
1883: p_xml_file_type);

Line 1885: IF (gcs_utility_pkg.get_dimension_required('USER_DIM4_ID') = 'Y') THEN

1881: 'fud3',
1882: p_rownum,
1883: p_xml_file_type);
1884: END IF;
1885: IF (gcs_utility_pkg.get_dimension_required('USER_DIM4_ID') = 'Y') THEN
1886: add_table_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM4_ID'),
1887: 'FEM_USER_DIM4_TL',
1888: 'fud4',
1889: p_rownum,

Line 1886: add_table_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM4_ID'),

1882: p_rownum,
1883: p_xml_file_type);
1884: END IF;
1885: IF (gcs_utility_pkg.get_dimension_required('USER_DIM4_ID') = 'Y') THEN
1886: add_table_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM4_ID'),
1887: 'FEM_USER_DIM4_TL',
1888: 'fud4',
1889: p_rownum,
1890: p_xml_file_type);

Line 1892: IF (gcs_utility_pkg.get_dimension_required('USER_DIM5_ID') = 'Y') THEN

1888: 'fud4',
1889: p_rownum,
1890: p_xml_file_type);
1891: END IF;
1892: IF (gcs_utility_pkg.get_dimension_required('USER_DIM5_ID') = 'Y') THEN
1893: add_table_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM5_ID'),
1894: 'FEM_USER_DIM5_TL',
1895: 'fud5',
1896: p_rownum,

Line 1893: add_table_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM5_ID'),

1889: p_rownum,
1890: p_xml_file_type);
1891: END IF;
1892: IF (gcs_utility_pkg.get_dimension_required('USER_DIM5_ID') = 'Y') THEN
1893: add_table_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM5_ID'),
1894: 'FEM_USER_DIM5_TL',
1895: 'fud5',
1896: p_rownum,
1897: p_xml_file_type);

Line 1899: IF (gcs_utility_pkg.get_dimension_required('USER_DIM6_ID') = 'Y') THEN

1895: 'fud5',
1896: p_rownum,
1897: p_xml_file_type);
1898: END IF;
1899: IF (gcs_utility_pkg.get_dimension_required('USER_DIM6_ID') = 'Y') THEN
1900: add_table_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM6_ID'),
1901: 'FEM_USER_DIM6_TL',
1902: 'fud6',
1903: p_rownum,

Line 1900: add_table_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM6_ID'),

1896: p_rownum,
1897: p_xml_file_type);
1898: END IF;
1899: IF (gcs_utility_pkg.get_dimension_required('USER_DIM6_ID') = 'Y') THEN
1900: add_table_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM6_ID'),
1901: 'FEM_USER_DIM6_TL',
1902: 'fud6',
1903: p_rownum,
1904: p_xml_file_type);

Line 1906: IF (gcs_utility_pkg.get_dimension_required('USER_DIM7_ID') = 'Y') THEN

1902: 'fud6',
1903: p_rownum,
1904: p_xml_file_type);
1905: END IF;
1906: IF (gcs_utility_pkg.get_dimension_required('USER_DIM7_ID') = 'Y') THEN
1907: add_table_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM7_ID'),
1908: 'FEM_USER_DIM7_TL',
1909: 'fud7',
1910: p_rownum,

Line 1907: add_table_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM7_ID'),

1903: p_rownum,
1904: p_xml_file_type);
1905: END IF;
1906: IF (gcs_utility_pkg.get_dimension_required('USER_DIM7_ID') = 'Y') THEN
1907: add_table_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM7_ID'),
1908: 'FEM_USER_DIM7_TL',
1909: 'fud7',
1910: p_rownum,
1911: p_xml_file_type);

Line 1913: IF (gcs_utility_pkg.get_dimension_required('USER_DIM8_ID') = 'Y') THEN

1909: 'fud7',
1910: p_rownum,
1911: p_xml_file_type);
1912: END IF;
1913: IF (gcs_utility_pkg.get_dimension_required('USER_DIM8_ID') = 'Y') THEN
1914: add_table_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM8_ID'),
1915: 'FEM_USER_DIM8_TL',
1916: 'fud8',
1917: p_rownum,

Line 1914: add_table_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM8_ID'),

1910: p_rownum,
1911: p_xml_file_type);
1912: END IF;
1913: IF (gcs_utility_pkg.get_dimension_required('USER_DIM8_ID') = 'Y') THEN
1914: add_table_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM8_ID'),
1915: 'FEM_USER_DIM8_TL',
1916: 'fud8',
1917: p_rownum,
1918: p_xml_file_type);

Line 1920: IF (gcs_utility_pkg.get_dimension_required('USER_DIM9_ID') = 'Y') THEN

1916: 'fud8',
1917: p_rownum,
1918: p_xml_file_type);
1919: END IF;
1920: IF (gcs_utility_pkg.get_dimension_required('USER_DIM9_ID') = 'Y') THEN
1921: add_table_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM9_ID'),
1922: 'FEM_USER_DIM9_TL',
1923: 'fud9',
1924: p_rownum,

Line 1921: add_table_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM9_ID'),

1917: p_rownum,
1918: p_xml_file_type);
1919: END IF;
1920: IF (gcs_utility_pkg.get_dimension_required('USER_DIM9_ID') = 'Y') THEN
1921: add_table_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM9_ID'),
1922: 'FEM_USER_DIM9_TL',
1923: 'fud9',
1924: p_rownum,
1925: p_xml_file_type);

Line 1928: add_table_to_list(gcs_utility_pkg.get_dimension_required('CHANNEL_ID'),

1924: p_rownum,
1925: p_xml_file_type);
1926: END IF;
1927: ELSE
1928: add_table_to_list(gcs_utility_pkg.get_dimension_required('CHANNEL_ID'),
1929: 'fem_channels_tl',
1930: 'fchb',
1931: p_rownum,
1932: p_xml_file_type);

Line 1933: add_table_to_list(gcs_utility_pkg.get_dimension_required('CUSTOMER_ID'),

1929: 'fem_channels_tl',
1930: 'fchb',
1931: p_rownum,
1932: p_xml_file_type);
1933: add_table_to_list(gcs_utility_pkg.get_dimension_required('CUSTOMER_ID'),
1934: 'fem_customers_tl',
1935: 'fcb',
1936: p_rownum,
1937: p_xml_file_type);

Line 1938: add_table_to_list(gcs_utility_pkg.get_dimension_required('FINANCIAL_ELEM_ID'),

1934: 'fem_customers_tl',
1935: 'fcb',
1936: p_rownum,
1937: p_xml_file_type);
1938: add_table_to_list(gcs_utility_pkg.get_dimension_required('FINANCIAL_ELEM_ID'),
1939: 'fem_fin_elems_tl',
1940: 'ffeb',
1941: p_rownum,
1942: p_xml_file_type);

Line 1943: add_table_to_list(gcs_utility_pkg.get_dimension_required('NATURAL_ACCOUNT_ID'),

1939: 'fem_fin_elems_tl',
1940: 'ffeb',
1941: p_rownum,
1942: p_xml_file_type);
1943: add_table_to_list(gcs_utility_pkg.get_dimension_required('NATURAL_ACCOUNT_ID'),
1944: 'fem_nat_accts_tl',
1945: 'fnab',
1946: p_rownum,
1947: p_xml_file_type);

Line 1948: add_table_to_list(gcs_utility_pkg.get_dimension_required('PRODUCT_ID'),

1944: 'fem_nat_accts_tl',
1945: 'fnab',
1946: p_rownum,
1947: p_xml_file_type);
1948: add_table_to_list(gcs_utility_pkg.get_dimension_required('PRODUCT_ID'),
1949: 'fem_products_tl',
1950: 'fpb',
1951: p_rownum,
1952: p_xml_file_type);

Line 1953: add_table_to_list(gcs_utility_pkg.get_dimension_required('PROJECT_ID'),

1949: 'fem_products_tl',
1950: 'fpb',
1951: p_rownum,
1952: p_xml_file_type);
1953: add_table_to_list(gcs_utility_pkg.get_dimension_required('PROJECT_ID'),
1954: 'fem_projects_tl',
1955: 'fpjb',
1956: p_rownum,
1957: p_xml_file_type);

Line 1958: add_table_to_list(gcs_utility_pkg.get_dimension_required('TASK_ID'),

1954: 'fem_projects_tl',
1955: 'fpjb',
1956: p_rownum,
1957: p_xml_file_type);
1958: add_table_to_list(gcs_utility_pkg.get_dimension_required('TASK_ID'),
1959: 'fem_tasks_tl',
1960: 'ftb',
1961: p_rownum,
1962: p_xml_file_type);

Line 1963: IF (gcs_utility_pkg.get_dimension_required('USER_DIM10_ID') = 'Y') THEN

1959: 'fem_tasks_tl',
1960: 'ftb',
1961: p_rownum,
1962: p_xml_file_type);
1963: IF (gcs_utility_pkg.get_dimension_required('USER_DIM10_ID') = 'Y') THEN
1964: add_table_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM10_ID'),
1965: 'FEM_USER_DIM10_TL',
1966: 'fud10',
1967: p_rownum,

Line 1964: add_table_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM10_ID'),

1960: 'ftb',
1961: p_rownum,
1962: p_xml_file_type);
1963: IF (gcs_utility_pkg.get_dimension_required('USER_DIM10_ID') = 'Y') THEN
1964: add_table_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM10_ID'),
1965: 'FEM_USER_DIM10_TL',
1966: 'fud10',
1967: p_rownum,
1968: p_xml_file_type);

Line 1970: IF (gcs_utility_pkg.get_dimension_required('USER_DIM1_ID') = 'Y') THEN

1966: 'fud10',
1967: p_rownum,
1968: p_xml_file_type);
1969: END IF;
1970: IF (gcs_utility_pkg.get_dimension_required('USER_DIM1_ID') = 'Y') THEN
1971: add_table_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM1_ID'),
1972: 'FEM_USER_DIM1_TL',
1973: 'fud1',
1974: p_rownum,

Line 1971: add_table_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM1_ID'),

1967: p_rownum,
1968: p_xml_file_type);
1969: END IF;
1970: IF (gcs_utility_pkg.get_dimension_required('USER_DIM1_ID') = 'Y') THEN
1971: add_table_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM1_ID'),
1972: 'FEM_USER_DIM1_TL',
1973: 'fud1',
1974: p_rownum,
1975: p_xml_file_type);

Line 1977: IF (gcs_utility_pkg.get_dimension_required('USER_DIM2_ID') = 'Y') THEN

1973: 'fud1',
1974: p_rownum,
1975: p_xml_file_type);
1976: END IF;
1977: IF (gcs_utility_pkg.get_dimension_required('USER_DIM2_ID') = 'Y') THEN
1978: add_table_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM2_ID'),
1979: 'FEM_USER_DIM2_TL',
1980: 'fud2',
1981: p_rownum,

Line 1978: add_table_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM2_ID'),

1974: p_rownum,
1975: p_xml_file_type);
1976: END IF;
1977: IF (gcs_utility_pkg.get_dimension_required('USER_DIM2_ID') = 'Y') THEN
1978: add_table_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM2_ID'),
1979: 'FEM_USER_DIM2_TL',
1980: 'fud2',
1981: p_rownum,
1982: p_xml_file_type);

Line 1984: IF (gcs_utility_pkg.get_dimension_required('USER_DIM3_ID') = 'Y') THEN

1980: 'fud2',
1981: p_rownum,
1982: p_xml_file_type);
1983: END IF;
1984: IF (gcs_utility_pkg.get_dimension_required('USER_DIM3_ID') = 'Y') THEN
1985: add_table_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM3_ID'),
1986: 'FEM_USER_DIM3_TL',
1987: 'fud3',
1988: p_rownum,

Line 1985: add_table_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM3_ID'),

1981: p_rownum,
1982: p_xml_file_type);
1983: END IF;
1984: IF (gcs_utility_pkg.get_dimension_required('USER_DIM3_ID') = 'Y') THEN
1985: add_table_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM3_ID'),
1986: 'FEM_USER_DIM3_TL',
1987: 'fud3',
1988: p_rownum,
1989: p_xml_file_type);

Line 1991: IF (gcs_utility_pkg.get_dimension_required('USER_DIM4_ID') = 'Y') THEN

1987: 'fud3',
1988: p_rownum,
1989: p_xml_file_type);
1990: END IF;
1991: IF (gcs_utility_pkg.get_dimension_required('USER_DIM4_ID') = 'Y') THEN
1992: add_table_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM4_ID'),
1993: 'FEM_USER_DIM4_TL',
1994: 'fud4',
1995: p_rownum,

Line 1992: add_table_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM4_ID'),

1988: p_rownum,
1989: p_xml_file_type);
1990: END IF;
1991: IF (gcs_utility_pkg.get_dimension_required('USER_DIM4_ID') = 'Y') THEN
1992: add_table_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM4_ID'),
1993: 'FEM_USER_DIM4_TL',
1994: 'fud4',
1995: p_rownum,
1996: p_xml_file_type);

Line 1998: IF (gcs_utility_pkg.get_dimension_required('USER_DIM5_ID') = 'Y') THEN

1994: 'fud4',
1995: p_rownum,
1996: p_xml_file_type);
1997: END IF;
1998: IF (gcs_utility_pkg.get_dimension_required('USER_DIM5_ID') = 'Y') THEN
1999: add_table_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM5_ID'),
2000: 'FEM_USER_DIM5_TL',
2001: 'fud5',
2002: p_rownum,

Line 1999: add_table_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM5_ID'),

1995: p_rownum,
1996: p_xml_file_type);
1997: END IF;
1998: IF (gcs_utility_pkg.get_dimension_required('USER_DIM5_ID') = 'Y') THEN
1999: add_table_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM5_ID'),
2000: 'FEM_USER_DIM5_TL',
2001: 'fud5',
2002: p_rownum,
2003: p_xml_file_type);

Line 2005: IF (gcs_utility_pkg.get_dimension_required('USER_DIM6_ID') = 'Y') THEN

2001: 'fud5',
2002: p_rownum,
2003: p_xml_file_type);
2004: END IF;
2005: IF (gcs_utility_pkg.get_dimension_required('USER_DIM6_ID') = 'Y') THEN
2006: add_table_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM6_ID'),
2007: 'FEM_USER_DIM6_TL',
2008: 'fud6',
2009: p_rownum,

Line 2006: add_table_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM6_ID'),

2002: p_rownum,
2003: p_xml_file_type);
2004: END IF;
2005: IF (gcs_utility_pkg.get_dimension_required('USER_DIM6_ID') = 'Y') THEN
2006: add_table_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM6_ID'),
2007: 'FEM_USER_DIM6_TL',
2008: 'fud6',
2009: p_rownum,
2010: p_xml_file_type);

Line 2012: IF (gcs_utility_pkg.get_dimension_required('USER_DIM7_ID') = 'Y') THEN

2008: 'fud6',
2009: p_rownum,
2010: p_xml_file_type);
2011: END IF;
2012: IF (gcs_utility_pkg.get_dimension_required('USER_DIM7_ID') = 'Y') THEN
2013: add_table_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM7_ID'),
2014: 'FEM_USER_DIM7_TL',
2015: 'fud7',
2016: p_rownum,

Line 2013: add_table_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM7_ID'),

2009: p_rownum,
2010: p_xml_file_type);
2011: END IF;
2012: IF (gcs_utility_pkg.get_dimension_required('USER_DIM7_ID') = 'Y') THEN
2013: add_table_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM7_ID'),
2014: 'FEM_USER_DIM7_TL',
2015: 'fud7',
2016: p_rownum,
2017: p_xml_file_type);

Line 2019: IF (gcs_utility_pkg.get_dimension_required('USER_DIM8_ID') = 'Y') THEN

2015: 'fud7',
2016: p_rownum,
2017: p_xml_file_type);
2018: END IF;
2019: IF (gcs_utility_pkg.get_dimension_required('USER_DIM8_ID') = 'Y') THEN
2020: add_table_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM8_ID'),
2021: 'FEM_USER_DIM8_TL',
2022: 'fud8',
2023: p_rownum,

Line 2020: add_table_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM8_ID'),

2016: p_rownum,
2017: p_xml_file_type);
2018: END IF;
2019: IF (gcs_utility_pkg.get_dimension_required('USER_DIM8_ID') = 'Y') THEN
2020: add_table_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM8_ID'),
2021: 'FEM_USER_DIM8_TL',
2022: 'fud8',
2023: p_rownum,
2024: p_xml_file_type);

Line 2026: IF (gcs_utility_pkg.get_dimension_required('USER_DIM9_ID') = 'Y') THEN

2022: 'fud8',
2023: p_rownum,
2024: p_xml_file_type);
2025: END IF;
2026: IF (gcs_utility_pkg.get_dimension_required('USER_DIM9_ID') = 'Y') THEN
2027: add_table_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM9_ID'),
2028: 'FEM_USER_DIM9_TL',
2029: 'fud9',
2030: p_rownum,

Line 2027: add_table_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM9_ID'),

2023: p_rownum,
2024: p_xml_file_type);
2025: END IF;
2026: IF (gcs_utility_pkg.get_dimension_required('USER_DIM9_ID') = 'Y') THEN
2027: add_table_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM9_ID'),
2028: 'FEM_USER_DIM9_TL',
2029: 'fud9',
2030: p_rownum,
2031: p_xml_file_type);