APPS.OKC_AQ_PVT dependencies on FND_PROFILE

Line 4: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');

1: Package body OKC_AQ_PVT AS
2: /* $Header: OKCRAQB.pls 120.0 2005/05/25 18:34:40 appldev noship $ */
3:
4: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
5: ---------------------------------------------------------------------------
6: -- GLOBAL DATASTRUCTURES
7: ---------------------------------------------------------------------------
8: -- TYPES

Line 670: l_listener_iterations := nvl(fnd_profile.value('OKC_LISTEN_EVENT'),100);

666: -- changed to unconditional loop
667:
668: -- okc_debug.Log('70: Before unconditional LOOP',2);
669: /* LOOP -- limit loop in order to enable faster shutdown of listeners */
670: l_listener_iterations := nvl(fnd_profile.value('OKC_LISTEN_EVENT'),100);
671:
672: FOR i IN 1..l_listener_iterations LOOP
673:
674: /* bug 2258913 - shut down cursor performs poorly when queue load is high

Line 762: l_listener_iterations := nvl(fnd_profile.value('OKC_LISTEN_OUTCOME'),100);

758: -- okc_debug.Log('30: After subscriber LOOP',2);
759:
760: -- okc_debug.Log('40: Before unconditional LOOP',2);
761:
762: l_listener_iterations := nvl(fnd_profile.value('OKC_LISTEN_OUTCOME'),100);
763: /* changed to unconditional loop
764: Changed to conditional loop to allow faster shutdown of listeners
765: and to reduce CPU usage by host system.
766: */

Line 1883: FROM fnd_profile_options op,

1879: l_profile VARCHAR2(240);
1880:
1881: CURSOR profile_cur IS
1882: SELECT opval.profile_option_value profile_value
1883: FROM fnd_profile_options op,
1884: fnd_profile_option_values opval
1885: WHERE op.profile_option_id = opval.profile_option_id
1886: AND op.application_id = opval.application_id
1887: AND op.profile_option_name = 'OKC_RETAIN_MSG_DAYS';

Line 1884: fnd_profile_option_values opval

1880:
1881: CURSOR profile_cur IS
1882: SELECT opval.profile_option_value profile_value
1883: FROM fnd_profile_options op,
1884: fnd_profile_option_values opval
1885: WHERE op.profile_option_id = opval.profile_option_id
1886: AND op.application_id = opval.application_id
1887: AND op.profile_option_name = 'OKC_RETAIN_MSG_DAYS';
1888: profile_rec profile_cur%ROWTYPE;