eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PON_NEW_SUPPLIER_REG_PKG dependencies on HZ_PARTIES

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

52: AND bh.vendor_id = -1;
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),

Line 60: select party_name from hz_parties where party_id = p_supplier_hz_party_id),

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,
62: requested_supplier_name = null,
63: last_update_date = l_current_date,
64: last_updated_by = p_user_id

Line 85: -- Updates pon_bid_headers with the name and id from hz_parties

81: END LOOP;
82: -- End Bug 9222914
83: --
84: -- Begin Bug 9048792
85: -- Updates pon_bid_headers with the name and id from hz_parties
86: UPDATE pon_bid_headers
87: SET trading_partner_id = p_supplier_hz_party_id,
88: trading_partner_name = (
89: SELECT party_name FROM hz_parties WHERE party_id = p_supplier_hz_party_id),

Line 89: SELECT party_name FROM hz_parties WHERE party_id = p_supplier_hz_party_id),

85: -- Updates pon_bid_headers with the name and id from hz_parties
86: UPDATE pon_bid_headers
87: SET trading_partner_id = p_supplier_hz_party_id,
88: trading_partner_name = (
89: SELECT party_name FROM hz_parties WHERE party_id = p_supplier_hz_party_id),
90: vendor_id = p_po_vendor_id
91: WHERE trading_partner_id = p_requested_supplier_id
92: AND vendor_id = -1;
93: --

Line 139: (SELECT party_name FROM hz_parties WHERE party_id = l_vendor_contact_id),

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,
141: requested_supp_contact_name = null
142: WHERE requested_supplier_contact_id = l_req_contact_id(x);
143: