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: -- Bug 9222914
42: CURSOR bids_cursor IS
43: SELECT ah.intgr_hdr_attach_flag,

Line 144: -- create wf user for fnd_user_name

140: requested_supplier_contact_id = null,
141: requested_supp_contact_name = null
142: WHERE requested_supplier_contact_id = l_req_contact_id(x);
143:
144: -- create wf user for fnd_user_name
145: BEGIN
146: SELECT user_name
147: INTO l_user_name
148: FROM fnd_user

Line 148: FROM fnd_user

144: -- create wf user for fnd_user_name
145: BEGIN
146: SELECT user_name
147: INTO l_user_name
148: FROM fnd_user
149: WHERE person_party_id = l_vendor_contact_id;
150: EXCEPTION
151: WHEN TOO_MANY_ROWS THEN
152: SELECT user_name

Line 154: FROM fnd_user

150: EXCEPTION
151: WHEN TOO_MANY_ROWS THEN
152: SELECT user_name
153: INTO l_user_name
154: FROM fnd_user
155: WHERE person_party_id = l_vendor_contact_id
156: AND ROWNUM = 1;
157: END;
158: