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

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: --
42: BEGIN

Line 44: UPDATE pon_bidding_parties

40: --
41: --
42: BEGIN
43: -- updates PBP with the name and id from hz_parties
44: UPDATE pon_bidding_parties
45: SET trading_partner_id = p_supplier_hz_party_id,
46: trading_partner_name = (
47: select party_name from hz_parties where party_id = p_supplier_hz_party_id),
48: requested_supplier_id = null,

Line 79: FROM pon_bidding_parties

75: --
76: -- loop through all the supplier contacts and set the suppler contact ids
77: SELECT DISTINCT requested_supplier_contact_id
78: BULK COLLECT INTO l_req_contact_id
79: FROM pon_bidding_parties
80: WHERE trading_partner_id = p_supplier_hz_party_id;
81:
82: IF (l_req_contact_id.count <> 0) THEN --{
83: FOR x IN 1..l_req_contact_id.COUNT

Line 95: UPDATE pon_bidding_parties

91: x_msg_data
92: );
93: -- check return_status
94: IF (x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN --{
95: UPDATE pon_bidding_parties
96: SET trading_partner_contact_id = l_vendor_contact_id,
97: trading_partner_contact_name =
98: (SELECT party_name FROM hz_parties WHERE party_id = l_vendor_contact_id),
99: requested_supplier_contact_id = null,

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

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
118: -- and update pon_bidding_parties to null out wf_user_name
119:
120: SELECT DISTINCT ah.auction_header_id, ah.wf_role_name
121: BULK COLLECT INTO l_auction_header_id, l_wf_role_name
122: FROM pon_bidding_parties pbp, pon_auction_headers_all ah

Line 122: FROM pon_bidding_parties pbp, pon_auction_headers_all ah

118: -- and update pon_bidding_parties to null out wf_user_name
119:
120: SELECT DISTINCT ah.auction_header_id, ah.wf_role_name
121: BULK COLLECT INTO l_auction_header_id, l_wf_role_name
122: FROM pon_bidding_parties pbp, pon_auction_headers_all ah
123: WHERE pbp.trading_partner_contact_id = l_vendor_contact_id
124: AND pbp.wf_user_name IS NOT NULL
125: AND pbp.auction_header_id = ah.auction_header_id;
126:

Line 131: UPDATE pon_bidding_parties

127: IF (l_auction_header_id.count <> 0) THEN
128: FOR y IN 1..l_auction_header_id.COUNT
129: LOOP
130: WF_DIRECTORY.AddUsersToAdHocRole(l_wf_role_name(y), l_user_name);
131: UPDATE pon_bidding_parties
132: SET wf_user_name = NULL
133: WHERE auction_header_id = l_auction_header_id(y)
134: AND trading_partner_contact_id = l_vendor_contact_id;
135: END LOOP;