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