DBA Data[Home] [Help]

APPS.PON_NEW_SUPPLIER_REG_PKG dependencies on HZ_PARTIES

Line 43: -- updates PBP with the name and id from hz_parties

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

Line 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

Line 98: (SELECT party_name FROM hz_parties WHERE party_id = l_vendor_contact_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: