DBA Data[Home] [Help]

APPS.ISC_FS_INV_USG_ETL_PKG dependencies on BIS_COMMON_PARAMETERS

Line 165: l_global_currency_code1 := BIS_COMMON_PARAMETERS.GET_CURRENCY_CODE;

161: BIS_COLLECTION_UTILITIES.LOG( 'Begin Currency Conversion', 1 );
162:
163: -- get the primary global currency code
164: l_stmt_num := 10;
165: l_global_currency_code1 := BIS_COMMON_PARAMETERS.GET_CURRENCY_CODE;
166: IF l_global_currency_code1 IS NULL THEN
167: l_err_msg := 'Unable to get primary global currency code.';
168: logger( l_proc_name, l_stmt_num, l_err_msg );
169: RAISE l_exception;

Line 177: l_global_rate_type1 := bis_common_parameters.get_rate_type;

173: );
174:
175: -- get the primary global rate type
176: l_stmt_num := 20;
177: l_global_rate_type1 := bis_common_parameters.get_rate_type;
178: IF l_global_rate_type1 IS NULL THEN
179: l_err_msg := 'Unable to get primary global rate type.';
180: logger( l_proc_name, l_stmt_num, l_err_msg );
181: RAISE l_exception;

Line 188: l_global_currency_code2 := bis_common_parameters.get_secondary_currency_code;

184: BIS_COLLECTION_UTILITIES.LOG( 'Primary global rate type: ' || l_global_rate_type1, 2 );
185:
186: -- get the secondary global currency code
187: l_stmt_num := 30;
188: l_global_currency_code2 := bis_common_parameters.get_secondary_currency_code;
189:
190: IF l_global_currency_code2 IS NOT NULL THEN
191: BIS_COLLECTION_UTILITIES.LOG( 'Secondary global currency code: ' ||
192: l_global_currency_code2, 2 );

Line 199: l_global_rate_type2 := bis_common_parameters.get_secondary_rate_type;

195: END IF;
196:
197: -- get the secondary global rate type
198: l_stmt_num := 40;
199: l_global_rate_type2 := bis_common_parameters.get_secondary_rate_type;
200: IF l_global_rate_type2 IS NULL AND l_global_currency_code2 IS NOT NULL THEN
201: l_err_msg := 'Unable to get secondary global rate type.';
202: LOGGER( l_proc_name, l_stmt_num, l_err_msg );
203: RAISE l_exception;

Line 398: IF (bis_common_parameters.check_global_parameters(l_list)) THEN

394: l_list(1) := 'BIS_GLOBAL_START_DATE';
395:
396: BIS_COLLECTION_UTILITIES.LOG( 'Begin Initial Load' );
397:
398: IF (bis_common_parameters.check_global_parameters(l_list)) THEN
399:
400: l_stmt_num := 0;
401: IF NOT BIS_COLLECTION_UTILITIES.SETUP( g_object_name ) THEN
402: l_err_msg := 'Error in BIS_COLLECTION_UTILITIES.Setup';

Line 792: IF (bis_common_parameters.check_global_parameters(l_list)) THEN

788: l_list(1) := 'BIS_GLOBAL_START_DATE';
789:
790: BIS_COLLECTION_UTILITIES.LOG( 'Begin Incremental Load' );
791:
792: IF (bis_common_parameters.check_global_parameters(l_list)) THEN
793:
794: l_stmt_num := 0;
795: IF NOT BIS_COLLECTION_UTILITIES.SETUP( g_object_name ) THEN
796: l_err_msg := 'Error in BIS_COLLECTION_UTILITIES.Setup';