APPS.PON_NEW_SUPPLIER_REG_PKG dependencies on PON_BIDDING_PARTIES

Line 37: l_party_id PON_BIDDING_PARTIES.TRADING_PARTNER_ID%TYPE;

33: TYPE VARCHAR2_WF_ROLE_TYPE IS TABLE OF VARCHAR2(320) INDEX BY BINARY_INTEGER;
34: l_wf_role_name VARCHAR2_WF_ROLE_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

Line 38: l_vendor_contact_id PON_BIDDING_PARTIES.TRADING_PARTNER_CONTACT_ID%TYPE;

34: l_wf_role_name VARCHAR2_WF_ROLE_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

Line 57: UPDATE pon_bidding_parties

53: --
54: --
55: BEGIN
56: -- updates PBP with the name and id from hz_parties
57: UPDATE pon_bidding_parties
58: SET trading_partner_id = p_supplier_hz_party_id,
59: trading_partner_name = (
60: select party_name from hz_parties where party_id = p_supplier_hz_party_id),
61: requested_supplier_id = null,

Line 120: FROM pon_bidding_parties

116: --
117: -- loop through all the supplier contacts and set the suppler contact ids
118: SELECT DISTINCT requested_supplier_contact_id
119: BULK COLLECT INTO l_req_contact_id
120: FROM pon_bidding_parties
121: WHERE trading_partner_id = p_supplier_hz_party_id;
122:
123: IF (l_req_contact_id.count <> 0) THEN --{
124: FOR x IN 1..l_req_contact_id.COUNT

Line 136: UPDATE pon_bidding_parties

132: x_msg_data
133: );
134: -- check return_status
135: IF (x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN --{
136: UPDATE pon_bidding_parties
137: SET trading_partner_contact_id = l_vendor_contact_id,
138: trading_partner_contact_name =
139: (SELECT party_name FROM hz_parties WHERE party_id = l_vendor_contact_id),
140: requested_supplier_contact_id = null,

Line 171: -- and update pon_bidding_parties to null out wf_user_name

167: END IF;
168: -- End Bug 9048792
169:
170: -- loop through all auctions and create wf user with the user_name
171: -- and update pon_bidding_parties to null out wf_user_name
172:
173: SELECT DISTINCT ah.auction_header_id, ah.wf_role_name
174: BULK COLLECT INTO l_auction_header_id, l_wf_role_name
175: FROM pon_bidding_parties pbp, pon_auction_headers_all ah

Line 175: FROM pon_bidding_parties pbp, pon_auction_headers_all ah

171: -- and update pon_bidding_parties to null out wf_user_name
172:
173: SELECT DISTINCT ah.auction_header_id, ah.wf_role_name
174: BULK COLLECT INTO l_auction_header_id, l_wf_role_name
175: FROM pon_bidding_parties pbp, pon_auction_headers_all ah
176: WHERE pbp.trading_partner_contact_id = l_vendor_contact_id
177: AND pbp.wf_user_name IS NOT NULL
178: AND pbp.auction_header_id = ah.auction_header_id;
179:

Line 184: UPDATE pon_bidding_parties

180: IF (l_auction_header_id.count <> 0) THEN
181: FOR y IN 1..l_auction_header_id.COUNT
182: LOOP
183: WF_DIRECTORY.AddUsersToAdHocRole(l_wf_role_name(y), l_user_name);
184: UPDATE pon_bidding_parties
185: SET wf_user_name = NULL
186: WHERE auction_header_id = l_auction_header_id(y)
187: AND trading_partner_contact_id = l_vendor_contact_id;
188: END LOOP;