eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GCS_XML_DT_UTILITY_PKG dependencies on GCS_UTILITY_PKG

Line 46: l_period_end_date_attr NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')

42:
43: l_dimension_vs_id t_dimension_vs_id;
44:
45: -- Bug Fix: 5843592, Get the attribute id and version id of the CAL_PERIOD_END_DATE of calendar period
46: l_period_end_date_attr NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')
47: .attribute_id;
48: l_period_end_date_version NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')
49: .version_id;
50:

Line 48: l_period_end_date_version NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')

44:
45: -- Bug Fix: 5843592, Get the attribute id and version id of the CAL_PERIOD_END_DATE of calendar period
46: l_period_end_date_attr NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')
47: .attribute_id;
48: l_period_end_date_version NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')
49: .version_id;
50:
51: l_api_name VARCHAR2 (30) := 'GET_VALUE_SET_CLAUSE';
52:

Line 117: gcs_utility_pkg.get_fem_dim_required('PRODUCT_ID') = 'Y') THEN

113: ' AND fliv.value_set_id = ' || l_dimension_vs_id(l_counter).value_set_id ;
114:
115: ELSIF (l_dimension_vs_id(l_counter).dimension_id = 3 AND
116:
117: gcs_utility_pkg.get_fem_dim_required('PRODUCT_ID') = 'Y') THEN
118: p_value_set_clause := p_value_set_clause || g_nl ||
119: ' AND fpb.value_set_id = ' || l_dimension_vs_id(l_counter).value_set_id ;
120:
121: ELSIF (l_dimension_vs_id(l_counter).dimension_id = 2 AND

Line 123: gcs_utility_pkg.get_fem_dim_required('NATURAL_ACCOUNT_ID') = 'Y') THEN

119: ' AND fpb.value_set_id = ' || l_dimension_vs_id(l_counter).value_set_id ;
120:
121: ELSIF (l_dimension_vs_id(l_counter).dimension_id = 2 AND
122:
123: gcs_utility_pkg.get_fem_dim_required('NATURAL_ACCOUNT_ID') = 'Y') THEN
124: p_value_set_clause := p_value_set_clause || g_nl ||
125: ' AND fnab.value_set_id = ' || l_dimension_vs_id(l_counter).value_set_id ;
126:
127: ELSIF (l_dimension_vs_id(l_counter).dimension_id = 13 AND

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

125: ' AND fnab.value_set_id = ' || l_dimension_vs_id(l_counter).value_set_id ;
126:
127: ELSIF (l_dimension_vs_id(l_counter).dimension_id = 13 AND
128:
129: gcs_utility_pkg.get_fem_dim_required('CHANNEL_ID') = 'Y') THEN
130: p_value_set_clause := p_value_set_clause || g_nl ||
131: ' AND fchb.value_set_id = ' || l_dimension_vs_id(l_counter).value_set_id ;
132:
133: ELSIF (l_dimension_vs_id(l_counter).dimension_id = 15 AND

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

131: ' AND fchb.value_set_id = ' || l_dimension_vs_id(l_counter).value_set_id ;
132:
133: ELSIF (l_dimension_vs_id(l_counter).dimension_id = 15 AND
134:
135: gcs_utility_pkg.get_fem_dim_required('PROJECT_ID') = 'Y') THEN
136: p_value_set_clause := p_value_set_clause || g_nl ||
137: ' AND fpjb.value_set_id = ' || l_dimension_vs_id(l_counter).value_set_id ;
138:
139: ELSIF (l_dimension_vs_id(l_counter).dimension_id = 16 AND

Line 141: gcs_utility_pkg.get_fem_dim_required('CUSTOMER_ID') = 'Y') THEN

137: ' AND fpjb.value_set_id = ' || l_dimension_vs_id(l_counter).value_set_id ;
138:
139: ELSIF (l_dimension_vs_id(l_counter).dimension_id = 16 AND
140:
141: gcs_utility_pkg.get_fem_dim_required('CUSTOMER_ID') = 'Y') THEN
142: p_value_set_clause := p_value_set_clause || g_nl ||
143: ' AND fcb.value_set_id = ' || l_dimension_vs_id(l_counter).value_set_id ;
144:
145: ELSIF (l_dimension_vs_id(l_counter).dimension_id = 30 AND

Line 147: gcs_utility_pkg.get_fem_dim_required('TASK_ID') = 'Y') THEN

143: ' AND fcb.value_set_id = ' || l_dimension_vs_id(l_counter).value_set_id ;
144:
145: ELSIF (l_dimension_vs_id(l_counter).dimension_id = 30 AND
146:
147: gcs_utility_pkg.get_fem_dim_required('TASK_ID') = 'Y') THEN
148: p_value_set_clause := p_value_set_clause || g_nl ||
149: ' AND ftb.value_set_id = ' || l_dimension_vs_id(l_counter).value_set_id ;
150:
151: ELSIF (l_dimension_vs_id(l_counter).dimension_id = 19 AND

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

149: ' AND ftb.value_set_id = ' || l_dimension_vs_id(l_counter).value_set_id ;
150:
151: ELSIF (l_dimension_vs_id(l_counter).dimension_id = 19 AND
152:
153: gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID') = 'Y') THEN
154: p_value_set_clause := p_value_set_clause || g_nl ||
155: ' AND fud1.value_set_id = ' || l_dimension_vs_id(l_counter).value_set_id ;
156:
157: ELSIF (l_dimension_vs_id(l_counter).dimension_id = 20 AND

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

155: ' AND fud1.value_set_id = ' || l_dimension_vs_id(l_counter).value_set_id ;
156:
157: ELSIF (l_dimension_vs_id(l_counter).dimension_id = 20 AND
158:
159: gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID') = 'Y') THEN
160: p_value_set_clause := p_value_set_clause || g_nl ||
161: ' AND fud2.value_set_id = ' || l_dimension_vs_id(l_counter).value_set_id ;
162:
163: ELSIF (l_dimension_vs_id(l_counter).dimension_id = 21 AND

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

161: ' AND fud2.value_set_id = ' || l_dimension_vs_id(l_counter).value_set_id ;
162:
163: ELSIF (l_dimension_vs_id(l_counter).dimension_id = 21 AND
164:
165: gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID') = 'Y') THEN
166: p_value_set_clause := p_value_set_clause || g_nl ||
167: ' AND fud3.value_set_id = ' || l_dimension_vs_id(l_counter).value_set_id ;
168:
169: ELSIF (l_dimension_vs_id(l_counter).dimension_id = 22 AND

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

167: ' AND fud3.value_set_id = ' || l_dimension_vs_id(l_counter).value_set_id ;
168:
169: ELSIF (l_dimension_vs_id(l_counter).dimension_id = 22 AND
170:
171: gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID') = 'Y') THEN
172: p_value_set_clause := p_value_set_clause || g_nl ||
173: ' AND fud4.value_set_id = ' || l_dimension_vs_id(l_counter).value_set_id ;
174:
175: ELSIF (l_dimension_vs_id(l_counter).dimension_id = 23 AND

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

173: ' AND fud4.value_set_id = ' || l_dimension_vs_id(l_counter).value_set_id ;
174:
175: ELSIF (l_dimension_vs_id(l_counter).dimension_id = 23 AND
176:
177: gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID') = 'Y') THEN
178: p_value_set_clause := p_value_set_clause || g_nl ||
179: ' AND fud5.value_set_id = ' || l_dimension_vs_id(l_counter).value_set_id ;
180:
181: ELSIF (l_dimension_vs_id(l_counter).dimension_id = 24 AND

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

179: ' AND fud5.value_set_id = ' || l_dimension_vs_id(l_counter).value_set_id ;
180:
181: ELSIF (l_dimension_vs_id(l_counter).dimension_id = 24 AND
182:
183: gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID') = 'Y') THEN
184: p_value_set_clause := p_value_set_clause || g_nl ||
185: ' AND fud6.value_set_id = ' || l_dimension_vs_id(l_counter).value_set_id ;
186:
187: ELSIF (l_dimension_vs_id(l_counter).dimension_id = 25 AND

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

185: ' AND fud6.value_set_id = ' || l_dimension_vs_id(l_counter).value_set_id ;
186:
187: ELSIF (l_dimension_vs_id(l_counter).dimension_id = 25 AND
188:
189: gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID') = 'Y') THEN
190: p_value_set_clause := p_value_set_clause || g_nl ||
191: ' AND fud7.value_set_id = ' || l_dimension_vs_id(l_counter).value_set_id ;
192:
193: ELSIF (l_dimension_vs_id(l_counter).dimension_id = 26 AND

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

191: ' AND fud7.value_set_id = ' || l_dimension_vs_id(l_counter).value_set_id ;
192:
193: ELSIF (l_dimension_vs_id(l_counter).dimension_id = 26 AND
194:
195: gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID') = 'Y') THEN
196: p_value_set_clause := p_value_set_clause || g_nl ||
197: ' AND fud8.value_set_id = ' || l_dimension_vs_id(l_counter).value_set_id ;
198:
199: ELSIF (l_dimension_vs_id(l_counter).dimension_id = 27 AND

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

197: ' AND fud8.value_set_id = ' || l_dimension_vs_id(l_counter).value_set_id ;
198:
199: ELSIF (l_dimension_vs_id(l_counter).dimension_id = 27 AND
200:
201: gcs_utility_pkg.get_fem_dim_required('USER_DIM9_ID') = 'Y') THEN
202: p_value_set_clause := p_value_set_clause || g_nl ||
203: ' AND fud9.value_set_id = ' || l_dimension_vs_id(l_counter).value_set_id ;
204:
205: ELSIF (l_dimension_vs_id(l_counter).dimension_id = 28 AND

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

203: ' AND fud9.value_set_id = ' || l_dimension_vs_id(l_counter).value_set_id ;
204:
205: ELSIF (l_dimension_vs_id(l_counter).dimension_id = 28 AND
206:
207: gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID') = 'Y') THEN
208: p_value_set_clause := p_value_set_clause || g_nl ||
209: ' AND fud10.value_set_id = ' || l_dimension_vs_id(l_counter).value_set_id ;
210:
211: END IF;

Line 318: l_period_end_date_attr NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')

314: l_entity_id NUMBER;
315: --end bug fix 5394468
316:
317: -- Bug Fix: 5843592, Get the attribute id and version id of the CAL_PERIOD_END_DATE of calendar period
318: l_period_end_date_attr NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')
319: .attribute_id;
320: l_period_end_date_version NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')
321: .version_id;
322:

Line 320: l_period_end_date_version NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')

316:
317: -- Bug Fix: 5843592, Get the attribute id and version id of the CAL_PERIOD_END_DATE of calendar period
318: l_period_end_date_attr NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')
319: .attribute_id;
320: l_period_end_date_version NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')
321: .version_id;
322:
323:
324: BEGIN

Line 585: g_dimension_attr_info gcs_utility_pkg.t_hash_dimension_attr_info := gcs_utility_pkg.g_dimension_attr_info;

581: l_cal_pd_end_date VARCHAR2(150);
582: l_def_hier_id NUMBER;
583: l_her_obj_def_id NUMBER := -1;
584: l_map_flag VARCHAR2(10) := 'UNMAPPED';
585: g_dimension_attr_info gcs_utility_pkg.t_hash_dimension_attr_info := gcs_utility_pkg.g_dimension_attr_info;
586:
587: -- Bug Fix: 5843592, Get the attribute id and version id of the CAL_PERIOD_END_DATE of calendar period
588:
589: l_period_end_date_attr NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')

Line 589: l_period_end_date_attr NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')

585: g_dimension_attr_info gcs_utility_pkg.t_hash_dimension_attr_info := gcs_utility_pkg.g_dimension_attr_info;
586:
587: -- Bug Fix: 5843592, Get the attribute id and version id of the CAL_PERIOD_END_DATE of calendar period
588:
589: l_period_end_date_attr NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')
590: .attribute_id;
591: l_period_end_date_version NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')
592: .version_id;
593:

Line 591: l_period_end_date_version NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')

587: -- Bug Fix: 5843592, Get the attribute id and version id of the CAL_PERIOD_END_DATE of calendar period
588:
589: l_period_end_date_attr NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')
590: .attribute_id;
591: l_period_end_date_version NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')
592: .version_id;
593:
594: BEGIN
595: --Do initial logging

Line 627: AND fla.attribute_id = gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-LEDGER_FUNCTIONAL_CRNCY_CODE').attribute_id

623: AND fcpa.attribute_id = l_period_end_date_attr
624: AND fcpa.version_id = l_period_end_date_version
625: AND fcpa.date_assign_value BETWEEN gea.effective_start_date
626: AND NVL(gea.effective_end_date, fcpa.date_assign_value )
627: AND fla.attribute_id = gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-LEDGER_FUNCTIONAL_CRNCY_CODE').attribute_id
628: AND fla.version_id = gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-LEDGER_FUNCTIONAL_CRNCY_CODE').version_id
629: AND fda.attribute_id = gcs_utility_pkg.g_dimension_attr_info('DATASET_CODE-DATASET_BALANCE_TYPE_CODE').attribute_id
630: AND fda.version_id = gcs_utility_pkg.g_dimension_attr_info('DATASET_CODE-DATASET_BALANCE_TYPE_CODE').version_id ;
631:

Line 628: AND fla.version_id = gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-LEDGER_FUNCTIONAL_CRNCY_CODE').version_id

624: AND fcpa.version_id = l_period_end_date_version
625: AND fcpa.date_assign_value BETWEEN gea.effective_start_date
626: AND NVL(gea.effective_end_date, fcpa.date_assign_value )
627: AND fla.attribute_id = gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-LEDGER_FUNCTIONAL_CRNCY_CODE').attribute_id
628: AND fla.version_id = gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-LEDGER_FUNCTIONAL_CRNCY_CODE').version_id
629: AND fda.attribute_id = gcs_utility_pkg.g_dimension_attr_info('DATASET_CODE-DATASET_BALANCE_TYPE_CODE').attribute_id
630: AND fda.version_id = gcs_utility_pkg.g_dimension_attr_info('DATASET_CODE-DATASET_BALANCE_TYPE_CODE').version_id ;
631:
632: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT THEN

Line 629: AND fda.attribute_id = gcs_utility_pkg.g_dimension_attr_info('DATASET_CODE-DATASET_BALANCE_TYPE_CODE').attribute_id

625: AND fcpa.date_assign_value BETWEEN gea.effective_start_date
626: AND NVL(gea.effective_end_date, fcpa.date_assign_value )
627: AND fla.attribute_id = gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-LEDGER_FUNCTIONAL_CRNCY_CODE').attribute_id
628: AND fla.version_id = gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-LEDGER_FUNCTIONAL_CRNCY_CODE').version_id
629: AND fda.attribute_id = gcs_utility_pkg.g_dimension_attr_info('DATASET_CODE-DATASET_BALANCE_TYPE_CODE').attribute_id
630: AND fda.version_id = gcs_utility_pkg.g_dimension_attr_info('DATASET_CODE-DATASET_BALANCE_TYPE_CODE').version_id ;
631:
632: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT THEN
633: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'l_currency_code : '||l_currency_code);

Line 630: AND fda.version_id = gcs_utility_pkg.g_dimension_attr_info('DATASET_CODE-DATASET_BALANCE_TYPE_CODE').version_id ;

626: AND NVL(gea.effective_end_date, fcpa.date_assign_value )
627: AND fla.attribute_id = gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-LEDGER_FUNCTIONAL_CRNCY_CODE').attribute_id
628: AND fla.version_id = gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-LEDGER_FUNCTIONAL_CRNCY_CODE').version_id
629: AND fda.attribute_id = gcs_utility_pkg.g_dimension_attr_info('DATASET_CODE-DATASET_BALANCE_TYPE_CODE').attribute_id
630: AND fda.version_id = gcs_utility_pkg.g_dimension_attr_info('DATASET_CODE-DATASET_BALANCE_TYPE_CODE').version_id ;
631:
632: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT THEN
633: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'l_currency_code : '||l_currency_code);
634: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'l_dataset_code : '||l_dataset_code);

Line 672: WHERE fda.attribute_id = gcs_utility_pkg.g_dimension_attr_info('DATASET_CODE-BUDGET_ID').attribute_id

668:
669: SELECT fda.dim_attribute_numeric_member
670: INTO l_budget_vers_id
671: FROM fem_datasets_attr fda
672: WHERE fda.attribute_id = gcs_utility_pkg.g_dimension_attr_info('DATASET_CODE-BUDGET_ID').attribute_id
673: AND fda.version_id = gcs_utility_pkg.g_dimension_attr_info('DATASET_CODE-BUDGET_ID').version_id
674: AND fda.dataset_code = l_source_datasetcode ; -- datasetcode from previous query
675:
676: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT THEN

Line 673: AND fda.version_id = gcs_utility_pkg.g_dimension_attr_info('DATASET_CODE-BUDGET_ID').version_id

669: SELECT fda.dim_attribute_numeric_member
670: INTO l_budget_vers_id
671: FROM fem_datasets_attr fda
672: WHERE fda.attribute_id = gcs_utility_pkg.g_dimension_attr_info('DATASET_CODE-BUDGET_ID').attribute_id
673: AND fda.version_id = gcs_utility_pkg.g_dimension_attr_info('DATASET_CODE-BUDGET_ID').version_id
674: AND fda.dataset_code = l_source_datasetcode ; -- datasetcode from previous query
675:
676: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT THEN
677: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'l_budget_vers_id : '||l_budget_vers_id);

Line 687: WHERE fda.attribute_id = gcs_utility_pkg.g_dimension_attr_info('DATASET_CODE-ENCUMBRANCE_TYPE_ID').attribute_id

683:
684: SELECT fda.dim_attribute_numeric_member
685: INTO l_enc_type_id
686: FROM fem_datasets_attr fda
687: WHERE fda.attribute_id = gcs_utility_pkg.g_dimension_attr_info('DATASET_CODE-ENCUMBRANCE_TYPE_ID').attribute_id
688: AND fda.version_id = gcs_utility_pkg.g_dimension_attr_info('DATASET_CODE-ENCUMBRANCE_TYPE_ID').version_id
689: AND fda.dataset_code = l_source_datasetcode ; -- datasetcode from previous query
690:
691: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT THEN

Line 688: AND fda.version_id = gcs_utility_pkg.g_dimension_attr_info('DATASET_CODE-ENCUMBRANCE_TYPE_ID').version_id

684: SELECT fda.dim_attribute_numeric_member
685: INTO l_enc_type_id
686: FROM fem_datasets_attr fda
687: WHERE fda.attribute_id = gcs_utility_pkg.g_dimension_attr_info('DATASET_CODE-ENCUMBRANCE_TYPE_ID').attribute_id
688: AND fda.version_id = gcs_utility_pkg.g_dimension_attr_info('DATASET_CODE-ENCUMBRANCE_TYPE_ID').version_id
689: AND fda.dataset_code = l_source_datasetcode ; -- datasetcode from previous query
690:
691: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT THEN
692: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'l_enc_type_id : '||l_enc_type_id);