APPS.OKC_OUTCOME_INIT_PVT dependencies on FND_PROFILE

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

1: Package body OKC_OUTCOME_INIT_PVT AS
2: /* $Header: OKCROCEB.pls 120.2 2010/07/12 12:14:38 skuchima ship $ */
3:
4: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
5:
6: --
7: -- Package Variables
8: --

Line 55: FROM fnd_profile_options op,

51: l_contract_id NUMBER;
52:
53: CURSOR profile_cur1 IS
54: SELECT opval.profile_option_value profile_value
55: FROM fnd_profile_options op,
56: fnd_profile_option_values opval
57: WHERE op.profile_option_id = opval.profile_option_id
58: AND op.application_id = opval.application_id
59: AND op.profile_option_name = 'OKC_S_RECIPIENT';

Line 56: fnd_profile_option_values opval

52:
53: CURSOR profile_cur1 IS
54: SELECT opval.profile_option_value profile_value
55: FROM fnd_profile_options op,
56: fnd_profile_option_values opval
57: WHERE op.profile_option_id = opval.profile_option_id
58: AND op.application_id = opval.application_id
59: AND op.profile_option_name = 'OKC_S_RECIPIENT';
60: profile_rec1 profile_cur1%ROWTYPE;

Line 64: FROM fnd_profile_options op,

60: profile_rec1 profile_cur1%ROWTYPE;
61:
62: CURSOR profile_cur2 IS
63: SELECT opval.profile_option_value profile_value
64: FROM fnd_profile_options op,
65: fnd_profile_option_values opval
66: WHERE op.profile_option_id = opval.profile_option_id
67: AND op.application_id = opval.application_id
68: AND op.profile_option_name = 'OKC_E_RECIPIENT';

Line 65: fnd_profile_option_values opval

61:
62: CURSOR profile_cur2 IS
63: SELECT opval.profile_option_value profile_value
64: FROM fnd_profile_options op,
65: fnd_profile_option_values opval
66: WHERE op.profile_option_id = opval.profile_option_id
67: AND op.application_id = opval.application_id
68: AND op.profile_option_name = 'OKC_E_RECIPIENT';
69: profile_rec2 profile_cur2%ROWTYPE;

Line 249: IF( Nvl(FND_PROFILE.VALUE('OKS_STOP_WF_FROM_DA'),'NO')='NO') THEN

245: /*skuchima: Bug :9724454 stop call to generic workflow based on the profile "OKS: Stop Workflow Launch From Date Assembler " .
246: It will be called from the concurrent program "Service Contracts Date Assembler Workflow Manager" if the profile is set to YES
247: Capture all the required data into interface table*/
248:
249: IF( Nvl(FND_PROFILE.VALUE('OKS_STOP_WF_FROM_DA'),'NO')='NO') THEN
250:
251: IF (l_debug = 'Y') THEN
252: okc_debug.Log('Calling OKC_ASYNC_PUB.loop_call to create the workflow processes',2);
253: END IF;

Line 819: l_queue_size:= Nvl(FND_PROFILE.VALUE('OKS_DA_QUEUE_SIZE'),0);

815: okc_debug.Log('10: Entering submit_da_wf_mgr ',2);
816: END IF;
817:
818: ---Total Queue_Size
819: l_queue_size:= Nvl(FND_PROFILE.VALUE('OKS_DA_QUEUE_SIZE'),0);
820:
821: IF (l_debug = 'Y') THEN
822: okc_debug.Log('20: Total Queue Size '||l_queue_size,2);
823: END IF;