APPS.PON_NEW_SUPPLIER_REG_PKG dependencies on PON_AUCTION_HEADERS_ALL

Line 36: l_org_id PON_AUCTION_HEADERS_ALL.ORG_ID%TYPE;

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

Line 46: FROM pon_auction_headers_all ah,

42: CURSOR bids_cursor IS
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'

Line 175: FROM pon_bidding_parties pbp, pon_auction_headers_all ah

171: -- and update pon_bidding_parties to null out wf_user_name
172:
173: SELECT DISTINCT ah.auction_header_id, ah.wf_role_name
174: BULK COLLECT INTO l_auction_header_id, l_wf_role_name
175: FROM pon_bidding_parties pbp, pon_auction_headers_all ah
176: WHERE pbp.trading_partner_contact_id = l_vendor_contact_id
177: AND pbp.wf_user_name IS NOT NULL
178: AND pbp.auction_header_id = ah.auction_header_id;
179: