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:
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
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