DBA Data[Home] [Help]

APPS.PO_WF_PO_NOTIFICATION dependencies on FND_USER

Line 1315: l_user_name fnd_user.user_name%TYPE;

1311: curr_len NUMBER := 0;
1312: prior_len NUMBER := 0;
1313:
1314: /* Bug 2788683 start */
1315: l_user_name fnd_user.user_name%TYPE;
1316: l_vendor_name hz_parties.party_name%TYPE;
1317: l_party_name hz_parties.party_name%TYPE;
1318: /* Bug 2788683 end */
1319: l_supplier po_vendors.vendor_name%TYPE; --

Line 1532: FROM fnd_user fu,

1528: SELECT fu.user_name,
1529: hp.party_name
1530: INTO l_user_name,
1531: l_party_name
1532: FROM fnd_user fu,
1533: hz_parties hp
1534: WHERE hp.party_id = fu.customer_id
1535: AND fu.user_id = l_created_by_tbl(i);
1536: EXCEPTION

Line 1626: FROM fnd_user fu,

1622: IF l_employee_id_tbl(i) IS NULL THEN
1623: BEGIN --
1624: SELECT fu.user_name, hp.party_name
1625: INTO l_user_name, l_party_name
1626: FROM fnd_user fu,
1627: hz_parties hp
1628: WHERE hp.party_id = fu.customer_id
1629: AND fu.user_id = l_created_by_tbl(i);
1630: EXCEPTION

Line 1680: l_responder_id fnd_user.user_id%TYPE;

1676: funcmode in varchar2,
1677: resultout in out NOCOPY varchar2) is
1678:
1679: -- Context setting revamp
1680: l_responder_id fnd_user.user_id%TYPE;
1681: l_session_user_id NUMBER;
1682: l_session_resp_id NUMBER;
1683: l_session_appl_id NUMBER;
1684: l_preparer_resp_id NUMBER;

Line 1888: FROM fnd_user fu,

1884: l_nid := WF_ENGINE.context_nid;
1885:
1886: SELECT fu.USER_ID
1887: INTO l_responder_id
1888: FROM fnd_user fu,
1889: wf_notifications wfn
1890: WHERE wfn.notification_id = l_nid
1891: AND wfn.original_recipient = fu.user_name;
1892: