39: l_user_name FND_USER.USER_NAME%TYPE;
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),
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,
49: requested_supplier_name = null,
50: last_update_date = l_current_date,
51: last_updated_by = p_user_id
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,
100: requested_supp_contact_name = null
101: WHERE requested_supplier_contact_id = l_req_contact_id(x);
102: