DBA Data[Home] [Help]

APPS.AS_PERIOD_RATES_REFRESH dependencies on FND_PROFILE

Line 315: IF FND_PROFILE.Value('AS_FORECAST_CALENDAR') IS NULL THEN

311: Procedure fetch_profile_values
312: IS
313: l_module CONSTANT VARCHAR2(255) := 'as.plsql.prate.fetch_profile_values';
314: Begin
315: IF FND_PROFILE.Value('AS_FORECAST_CALENDAR') IS NULL THEN
316: as_debug(l_module, 'Value of AS_FORECAST_CALENDAR is not set');
317: ELSE
318: g_period_set_name := FND_PROFILE.Value('AS_FORECAST_CALENDAR') ;
319: END IF;

Line 318: g_period_set_name := FND_PROFILE.Value('AS_FORECAST_CALENDAR') ;

314: Begin
315: IF FND_PROFILE.Value('AS_FORECAST_CALENDAR') IS NULL THEN
316: as_debug(l_module, 'Value of AS_FORECAST_CALENDAR is not set');
317: ELSE
318: g_period_set_name := FND_PROFILE.Value('AS_FORECAST_CALENDAR') ;
319: END IF;
320: as_debug(l_module, 'Profile AS_FORECAST_CALENDAR: ' || g_period_set_name);
321:
322: IF FND_PROFILE.Value('AS_MC_DATE_MAPPING_TYPE') IS NULL THEN

Line 322: IF FND_PROFILE.Value('AS_MC_DATE_MAPPING_TYPE') IS NULL THEN

318: g_period_set_name := FND_PROFILE.Value('AS_FORECAST_CALENDAR') ;
319: END IF;
320: as_debug(l_module, 'Profile AS_FORECAST_CALENDAR: ' || g_period_set_name);
321:
322: IF FND_PROFILE.Value('AS_MC_DATE_MAPPING_TYPE') IS NULL THEN
323: as_debug(l_module, 'Value of AS_MC_DATE_MAPPING_TYPE is not set');
324: ELSE
325: g_mc_date_mapping_type := FND_PROFILE.Value('AS_MC_DATE_MAPPING_TYPE') ;
326: END IF;

Line 325: g_mc_date_mapping_type := FND_PROFILE.Value('AS_MC_DATE_MAPPING_TYPE') ;

321:
322: IF FND_PROFILE.Value('AS_MC_DATE_MAPPING_TYPE') IS NULL THEN
323: as_debug(l_module, 'Value of AS_MC_DATE_MAPPING_TYPE is not set');
324: ELSE
325: g_mc_date_mapping_type := FND_PROFILE.Value('AS_MC_DATE_MAPPING_TYPE') ;
326: END IF;
327: as_debug(l_module, 'Profile AS_MC_DATE_MAPPING_TYPE: ' || g_mc_date_mapping_type);
328:
329: IF FND_PROFILE.Value('AS_MC_MAX_ROLL_DAYS') IS NULL THEN

Line 329: IF FND_PROFILE.Value('AS_MC_MAX_ROLL_DAYS') IS NULL THEN

325: g_mc_date_mapping_type := FND_PROFILE.Value('AS_MC_DATE_MAPPING_TYPE') ;
326: END IF;
327: as_debug(l_module, 'Profile AS_MC_DATE_MAPPING_TYPE: ' || g_mc_date_mapping_type);
328:
329: IF FND_PROFILE.Value('AS_MC_MAX_ROLL_DAYS') IS NULL THEN
330: as_debug(l_module, 'Value of AS_MC_MAX_ROLL_DAYS is not set');
331: ELSE
332: g_max_roll_days := FND_PROFILE.Value('AS_MC_MAX_ROLL_DAYS') ;
333: END IF;

Line 332: g_max_roll_days := FND_PROFILE.Value('AS_MC_MAX_ROLL_DAYS') ;

328:
329: IF FND_PROFILE.Value('AS_MC_MAX_ROLL_DAYS') IS NULL THEN
330: as_debug(l_module, 'Value of AS_MC_MAX_ROLL_DAYS is not set');
331: ELSE
332: g_max_roll_days := FND_PROFILE.Value('AS_MC_MAX_ROLL_DAYS') ;
333: END IF;
334: as_debug(l_module, 'Profile AS_MC_MAX_ROLL_DAYS: ' || g_max_roll_days);
335:
336: -- IF FND_PROFILE.Value('AS_MC_DAILY_CONVERSION_TYPE') IS NULL THEN

Line 336: -- IF FND_PROFILE.Value('AS_MC_DAILY_CONVERSION_TYPE') IS NULL THEN

332: g_max_roll_days := FND_PROFILE.Value('AS_MC_MAX_ROLL_DAYS') ;
333: END IF;
334: as_debug(l_module, 'Profile AS_MC_MAX_ROLL_DAYS: ' || g_max_roll_days);
335:
336: -- IF FND_PROFILE.Value('AS_MC_DAILY_CONVERSION_TYPE') IS NULL THEN
337: -- as_debug('Value of AS_MC_DAILY_CONVERSION_TYPE is not set');
338: -- ELSE
339: -- g_daily_conversion_type := FND_PROFILE.Value('AS_MC_DAILY_CONVERSION_TYPE');
340: -- END IF;

Line 339: -- g_daily_conversion_type := FND_PROFILE.Value('AS_MC_DAILY_CONVERSION_TYPE');

335:
336: -- IF FND_PROFILE.Value('AS_MC_DAILY_CONVERSION_TYPE') IS NULL THEN
337: -- as_debug('Value of AS_MC_DAILY_CONVERSION_TYPE is not set');
338: -- ELSE
339: -- g_daily_conversion_type := FND_PROFILE.Value('AS_MC_DAILY_CONVERSION_TYPE');
340: -- END IF;
341: -- as_debug('Profile AS_MC_DAILY_CONVERSION_TYPE: ' || g_daily_conversion_type);
342:
343: -- IF FND_PROFILE.Value('AS_PREFERRED_CURRENCY') IS NULL THEN

Line 343: -- IF FND_PROFILE.Value('AS_PREFERRED_CURRENCY') IS NULL THEN

339: -- g_daily_conversion_type := FND_PROFILE.Value('AS_MC_DAILY_CONVERSION_TYPE');
340: -- END IF;
341: -- as_debug('Profile AS_MC_DAILY_CONVERSION_TYPE: ' || g_daily_conversion_type);
342:
343: -- IF FND_PROFILE.Value('AS_PREFERRED_CURRENCY') IS NULL THEN
344: -- as_debug('Value of AS_PREFERRED_CURRENCY is not set');
345: -- ELSE
346: -- g_preferred_currency := FND_PROFILE.Value('AS_PREFERRED_CURRENCY');
347: -- END IF;

Line 346: -- g_preferred_currency := FND_PROFILE.Value('AS_PREFERRED_CURRENCY');

342:
343: -- IF FND_PROFILE.Value('AS_PREFERRED_CURRENCY') IS NULL THEN
344: -- as_debug('Value of AS_PREFERRED_CURRENCY is not set');
345: -- ELSE
346: -- g_preferred_currency := FND_PROFILE.Value('AS_PREFERRED_CURRENCY');
347: -- END IF;
348: -- as_debug('Profile AS_PREFERRED_CURRENCY: ' || g_preferred_currency);
349:
350: g_request_id := TO_NUMBER(fnd_profile.value('CONC_REQUEST_ID'));

Line 350: g_request_id := TO_NUMBER(fnd_profile.value('CONC_REQUEST_ID'));

346: -- g_preferred_currency := FND_PROFILE.Value('AS_PREFERRED_CURRENCY');
347: -- END IF;
348: -- as_debug('Profile AS_PREFERRED_CURRENCY: ' || g_preferred_currency);
349:
350: g_request_id := TO_NUMBER(fnd_profile.value('CONC_REQUEST_ID'));
351: g_user_id := NVL(TO_NUMBER(fnd_profile.value('USER_ID')), -1);
352: g_prog_appl_id := FND_GLOBAL.PROG_APPL_ID;
353: g_prog_id := to_number(fnd_profile.value('CONC_PROGRAM_ID'));
354: g_last_update_login := NVL(TO_NUMBER(fnd_profile.value('CONC_LOGIN_ID')), -1);

Line 351: g_user_id := NVL(TO_NUMBER(fnd_profile.value('USER_ID')), -1);

347: -- END IF;
348: -- as_debug('Profile AS_PREFERRED_CURRENCY: ' || g_preferred_currency);
349:
350: g_request_id := TO_NUMBER(fnd_profile.value('CONC_REQUEST_ID'));
351: g_user_id := NVL(TO_NUMBER(fnd_profile.value('USER_ID')), -1);
352: g_prog_appl_id := FND_GLOBAL.PROG_APPL_ID;
353: g_prog_id := to_number(fnd_profile.value('CONC_PROGRAM_ID'));
354: g_last_update_login := NVL(TO_NUMBER(fnd_profile.value('CONC_LOGIN_ID')), -1);
355:

Line 353: g_prog_id := to_number(fnd_profile.value('CONC_PROGRAM_ID'));

349:
350: g_request_id := TO_NUMBER(fnd_profile.value('CONC_REQUEST_ID'));
351: g_user_id := NVL(TO_NUMBER(fnd_profile.value('USER_ID')), -1);
352: g_prog_appl_id := FND_GLOBAL.PROG_APPL_ID;
353: g_prog_id := to_number(fnd_profile.value('CONC_PROGRAM_ID'));
354: g_last_update_login := NVL(TO_NUMBER(fnd_profile.value('CONC_LOGIN_ID')), -1);
355:
356: as_debug(l_module, 'request_id: ' || g_request_id);
357: as_debug(l_module, 'user_id: ' || g_user_id);

Line 354: g_last_update_login := NVL(TO_NUMBER(fnd_profile.value('CONC_LOGIN_ID')), -1);

350: g_request_id := TO_NUMBER(fnd_profile.value('CONC_REQUEST_ID'));
351: g_user_id := NVL(TO_NUMBER(fnd_profile.value('USER_ID')), -1);
352: g_prog_appl_id := FND_GLOBAL.PROG_APPL_ID;
353: g_prog_id := to_number(fnd_profile.value('CONC_PROGRAM_ID'));
354: g_last_update_login := NVL(TO_NUMBER(fnd_profile.value('CONC_LOGIN_ID')), -1);
355:
356: as_debug(l_module, 'request_id: ' || g_request_id);
357: as_debug(l_module, 'user_id: ' || g_user_id);
358: as_debug(l_module, 'program_application_id: ' || g_prog_appl_id);