APPS.PON_NEW_SUPPLIER_REG_PKG dependencies on FND_USER

Line 39: l_user_name FND_USER.USER_NAME%TYPE;

35:
36: l_org_id PON_AUCTION_HEADERS_ALL.ORG_ID%TYPE;
37: l_party_id PON_BIDDING_PARTIES.TRADING_PARTNER_ID%TYPE;
38: l_vendor_contact_id PON_BIDDING_PARTIES.TRADING_PARTNER_CONTACT_ID%TYPE;
39: l_user_name FND_USER.USER_NAME%TYPE;
40: --
41: --
42: BEGIN
43: -- updates PBP with the name and id from hz_parties

Line 103: -- create wf user for fnd_user_name

99: requested_supplier_contact_id = null,
100: requested_supp_contact_name = null
101: WHERE requested_supplier_contact_id = l_req_contact_id(x);
102:
103: -- create wf user for fnd_user_name
104: BEGIN
105: SELECT user_name
106: INTO l_user_name
107: FROM fnd_user

Line 107: FROM fnd_user

103: -- create wf user for fnd_user_name
104: BEGIN
105: SELECT user_name
106: INTO l_user_name
107: FROM fnd_user
108: WHERE person_party_id = l_vendor_contact_id;
109: EXCEPTION
110: WHEN TOO_MANY_ROWS THEN
111: SELECT user_name

Line 113: FROM fnd_user

109: EXCEPTION
110: WHEN TOO_MANY_ROWS THEN
111: SELECT user_name
112: INTO l_user_name
113: FROM fnd_user
114: WHERE person_party_id = l_vendor_contact_id
115: AND ROWNUM = 1;
116: END;
117: -- loop through all auctions and create wf user with the user_name