APPS.PON_NEW_SUPPLIER_REG_PKG dependencies on PON_BID_HEADERS

Line 47: pon_bid_headers bh

43: SELECT ah.intgr_hdr_attach_flag,
44: ah.auction_header_id,
45: bh.bid_number
46: FROM pon_auction_headers_all ah,
47: pon_bid_headers bh
48: WHERE ah.auction_header_id = bh.auction_header_id
49: AND ah.auction_status = 'AUCTION_CLOSED'
50: AND bh.bid_status = 'ACTIVE'
51: AND bh.trading_partner_id = p_requested_supplier_id

Line 73: X_from_entity_name => 'PON_BID_HEADERS',

69: -- Integrate Header Attachments
70: FOR bid IN bids_cursor LOOP
71: IF (bid.intgr_hdr_attach_flag = 'Y') THEN
72: fnd_attached_documents2_pkg.copy_attachments(
73: X_from_entity_name => 'PON_BID_HEADERS',
74: X_from_pk1_value => bid.auction_header_id,
75: X_from_pk2_value => bid.bid_number,
76: X_to_entity_name => 'PO_VENDORS',
77: X_to_pk1_value => p_po_vendor_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 86: UPDATE pon_bid_headers

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),
90: vendor_id = p_po_vendor_id

Line 160: -- Updates pon_bid_headers with the first contact id and name

156: AND ROWNUM = 1;
157: END;
158:
159: -- Begin Bug 9048792
160: -- Updates pon_bid_headers with the first contact id and name
161: IF (x = 1) THEN
162: UPDATE pon_bid_headers
163: SET trading_partner_contact_id = l_vendor_contact_id,
164: trading_partner_contact_name = l_user_name

Line 162: UPDATE pon_bid_headers

158:
159: -- Begin Bug 9048792
160: -- Updates pon_bid_headers with the first contact id and name
161: IF (x = 1) THEN
162: UPDATE pon_bid_headers
163: SET trading_partner_contact_id = l_vendor_contact_id,
164: trading_partner_contact_name = l_user_name
165: WHERE trading_partner_id = p_supplier_hz_party_id
166: AND nvl(evaluation_flag, 'N') = 'N';