DBA Data[Home] [Help]

APPS.OKL_CURE_WF dependencies on FND_PROFILE

Line 83: to_number(NVL(FND_PROFILE.Value('LANGUAGE'), '0')));

79: l_message_num := NULL;
80: IF l_id is not NULL
81: THEN
82: OPEN Get_Message_Num (l_message_name, l_id,
83: to_number(NVL(FND_PROFILE.Value('LANGUAGE'), '0')));
84: FETCH Get_Message_Num into l_message_num;
85: CLOSE Get_Message_Num;
86: END IF;
87:

Line 161: l_user_id NUMBER := to_number(fnd_profile.value('OKL_CURE_APPROVAL_USER'));

157: and wfr.orig_system_id =fuser.employee_id
158: and fuser.user_id =p_user_id;
159:
160:
161: l_user_id NUMBER := to_number(fnd_profile.value('OKL_CURE_APPROVAL_USER'));
162:
163:
164: BEGIN
165: