DBA Data[Home] [Help]

APPS.PO_REQCHANGEREQUESTWF_PVT dependencies on FND_USER

Line 424: l_approver_user_name fnd_user.user_name%TYPE;

420: l_numerator_rate number;
421: l_approval_currency varchar2(30);
422: l_amount_disp varchar2(60);
423: l_amount_approval_currency number;
424: l_approver_user_name fnd_user.user_name%TYPE;
425: l_user_id fnd_user.user_id%TYPE;
426: l_progress varchar2(200);
427: l_no_rate_msg varchar2(200);
428:

Line 425: l_user_id fnd_user.user_id%TYPE;

421: l_approval_currency varchar2(30);
422: l_amount_disp varchar2(60);
423: l_amount_approval_currency number;
424: l_approver_user_name fnd_user.user_name%TYPE;
425: l_user_id fnd_user.user_id%TYPE;
426: l_progress varchar2(200);
427: l_no_rate_msg varchar2(200);
428:
429: begin

Line 445: FROM fnd_user

441: aname=>'APPROVER_USER_NAME');
442: if (l_approver_user_name is not null) then
443: SELECT user_id
444: INTO l_user_id
445: FROM fnd_user
446: WHERE user_name = l_approver_user_name;
447:
448: l_progress := 'getReqAmountInfo:' || l_user_id;
449: IF (g_po_wf_debug = 'Y') THEN