DBA Data[Home] [Help]

APPS.PO_SUP_CHG_REQUEST_WF_GRP dependencies on FND_USER

Line 516: l_supplier_username FND_USER.USER_NAME%TYPE;

512: actid in number,
513: funcmode in varchar2,
514: resultout out NOCOPY varchar2)
515: IS
516: l_supplier_username FND_USER.USER_NAME%TYPE;
517: l_supplier_user_id FND_USER.USER_ID%TYPE;
518: l_appl_resp_id NUMBER;
519: l_resp_id NUMBER;
520: BEGIN

Line 517: l_supplier_user_id FND_USER.USER_ID%TYPE;

513: funcmode in varchar2,
514: resultout out NOCOPY varchar2)
515: IS
516: l_supplier_username FND_USER.USER_NAME%TYPE;
517: l_supplier_user_id FND_USER.USER_ID%TYPE;
518: l_appl_resp_id NUMBER;
519: l_resp_id NUMBER;
520: BEGIN
521:

Line 534: from fnd_user

530: aname => 'APPL_RESP_ID');
531:
532: select user_id
533: into l_supplier_user_id
534: from fnd_user
535: where user_name=l_supplier_username
536: and rownum=1;
537:
538: PO_ChangeOrderWF_PVT.SET_SUPPLIER_CONTEXT(l_supplier_user_id,l_resp_id,l_appl_resp_id);