DBA Data[Home] [Help]

APPS.PV_CONTEXT_VALUES dependencies on FND_PROFILE

Line 349: FROM fnd_profile_options a,

345: -- --------------------------------------------------------------------
346: -- Retrieve the profile value for incremental refresh
347: -- --------------------------------------------------------------------
348: FOR x IN (SELECT profile_option_value
349: FROM fnd_profile_options a,
350: fnd_profile_option_values b
351: WHERE a.application_id = 691 AND
352: a.profile_option_id = b.profile_option_id AND
353: b.level_id = 10001 AND -- site level

Line 350: fnd_profile_option_values b

346: -- Retrieve the profile value for incremental refresh
347: -- --------------------------------------------------------------------
348: FOR x IN (SELECT profile_option_value
349: FROM fnd_profile_options a,
350: fnd_profile_option_values b
351: WHERE a.application_id = 691 AND
352: a.profile_option_id = b.profile_option_id AND
353: b.level_id = 10001 AND -- site level
354: b.level_value = 0 AND

Line 361: -- Somehow FND_PROFILE.VALUE is not getting the proper value. Use the above

357: l_last_incr_refresh_str := x.profile_option_value;
358: END LOOP;
359:
360: -- ------------------------------------------------------------------------
361: -- Somehow FND_PROFILE.VALUE is not getting the proper value. Use the above
362: -- SQL instead.
363: -- ------------------------------------------------------------------------
364: -- l_last_incr_refresh_str := FND_PROFILE.VALUE('PV_REFRESH_ATTRS_LAST_UPDATE');
365: l_last_incr_refresh_date := NVL(TO_DATE(l_last_incr_refresh_str,

Line 364: -- l_last_incr_refresh_str := FND_PROFILE.VALUE('PV_REFRESH_ATTRS_LAST_UPDATE');

360: -- ------------------------------------------------------------------------
361: -- Somehow FND_PROFILE.VALUE is not getting the proper value. Use the above
362: -- SQL instead.
363: -- ------------------------------------------------------------------------
364: -- l_last_incr_refresh_str := FND_PROFILE.VALUE('PV_REFRESH_ATTRS_LAST_UPDATE');
365: l_last_incr_refresh_date := NVL(TO_DATE(l_last_incr_refresh_str,
366: 'MM-DD-YYYY HH24:MI:SS'),
367: TO_DATE('01-01-1900 00:00:00',
368: 'MM-DD-YYYY HH24:MI:SS'));

Line 384: g_common_currency := NVL(FND_PROFILE.Value('PV_COMMON_CURRENCY'), 'USD');

380: -- Retrieve the common currency code from the profile option. This is the
381: -- currency in which all the partner's currency attribute values will be
382: -- converted to.
383: -- -----------------------------------------------------------------------
384: g_common_currency := NVL(FND_PROFILE.Value('PV_COMMON_CURRENCY'), 'USD');
385: Debug('The common currency is: ' || g_common_currency);
386:
387:
388: -- -----------------------------------------------------------------------

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

405: -- -----------------------------------------------------------------------
406: -- Set the flag to NOT to display message in currency conversion.
407: -- -----------------------------------------------------------------------
408: pv_check_match_pub.g_display_message := FALSE;
409: pv_check_match_pub.g_period_set_name := FND_PROFILE.Value('AS_FORECAST_CALENDAR');
410: pv_check_match_pub.g_period_type := FND_PROFILE.Value('AS_DEFAULT_PERIOD_TYPE');
411:
412: g_partner_temp_table := 'PV_PARTNER_ID_SESSION';
413:

Line 410: pv_check_match_pub.g_period_type := FND_PROFILE.Value('AS_DEFAULT_PERIOD_TYPE');

406: -- Set the flag to NOT to display message in currency conversion.
407: -- -----------------------------------------------------------------------
408: pv_check_match_pub.g_display_message := FALSE;
409: pv_check_match_pub.g_period_set_name := FND_PROFILE.Value('AS_FORECAST_CALENDAR');
410: pv_check_match_pub.g_period_type := FND_PROFILE.Value('AS_DEFAULT_PERIOD_TYPE');
411:
412: g_partner_temp_table := 'PV_PARTNER_ID_SESSION';
413:
414:

Line 456: FND_PROFILE.PUT('PV_REFRESH_ATTRS_LAST_UPDATE', l_incr_timestamp);

452: -- -----------------------------------------------------------------------
453: IF (l_refresh_type IN (g_incr_refresh, g_incr_full_refresh) AND l_end_refresh_flag) THEN
454: Debug('Update last refresh date...');
455:
456: FND_PROFILE.PUT('PV_REFRESH_ATTRS_LAST_UPDATE', l_incr_timestamp);
457: l_ret_val := FND_PROFILE.SAVE('PV_REFRESH_ATTRS_LAST_UPDATE',
458: l_incr_timestamp,
459: 'SITE');
460:

Line 457: l_ret_val := FND_PROFILE.SAVE('PV_REFRESH_ATTRS_LAST_UPDATE',

453: IF (l_refresh_type IN (g_incr_refresh, g_incr_full_refresh) AND l_end_refresh_flag) THEN
454: Debug('Update last refresh date...');
455:
456: FND_PROFILE.PUT('PV_REFRESH_ATTRS_LAST_UPDATE', l_incr_timestamp);
457: l_ret_val := FND_PROFILE.SAVE('PV_REFRESH_ATTRS_LAST_UPDATE',
458: l_incr_timestamp,
459: 'SITE');
460:
461: Debug('The next incremental refresh will start from ' || l_incr_timestamp);

Line 775: FND_PROFILE.PUT('PV_REFRESH_ATTRS_LAST_UPDATE', l_incr_timestamp);

771: -- --------------------------------------------------------------
772: -- Update last refresh date.
773: -- --------------------------------------------------------------
774: Debug('Update last refresh date...');
775: FND_PROFILE.PUT('PV_REFRESH_ATTRS_LAST_UPDATE', l_incr_timestamp);
776: l_ret_val := FND_PROFILE.SAVE('PV_REFRESH_ATTRS_LAST_UPDATE',
777: l_incr_timestamp,
778: 'SITE');
779:

Line 776: l_ret_val := FND_PROFILE.SAVE('PV_REFRESH_ATTRS_LAST_UPDATE',

772: -- Update last refresh date.
773: -- --------------------------------------------------------------
774: Debug('Update last refresh date...');
775: FND_PROFILE.PUT('PV_REFRESH_ATTRS_LAST_UPDATE', l_incr_timestamp);
776: l_ret_val := FND_PROFILE.SAVE('PV_REFRESH_ATTRS_LAST_UPDATE',
777: l_incr_timestamp,
778: 'SITE');
779:
780: Debug('The next incremental refresh will start from ' || l_incr_timestamp);