DBA Data[Home] [Help]

APPS.OKL_PAY_CURE_REFUNDS_PVT 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 2952: l_user_id NUMBER := to_number(fnd_profile.value('OKL_REFUND_APPROVAL_USER'));

2948: and wfr.orig_system_id =fuser.employee_id
2949: and fuser.user_id =p_user_id;
2950:
2951:
2952: l_user_id NUMBER := to_number(fnd_profile.value('OKL_REFUND_APPROVAL_USER'));
2953:
2954: --vendor role
2955: l_role_name VARCHAR2(30);
2956: l_offset_count NUMBER;