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_BIZ_EVENTS_PVT dependencies on PON_BID_HEADERS

Line 199: l_bid_number PON_BID_HEADERS. BID_NUMBER%TYPE;

195: x_msg_count IN OUT NOCOPY NUMBER,
196: x_msg_data IN OUT NOCOPY VARCHAR2
197: )
198: IS
199: l_bid_number PON_BID_HEADERS. BID_NUMBER%TYPE;
200: l_auction_header_id PON_BID_HEADERS. AUCTION_HEADER_ID%TYPE;
201: l_document_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
202: l_trading_partner_contact_id PON_BID_HEADERS.TRADING_PARTNER_CONTACT_ID%TYPE;
203: l_trading_partner_id PON_BID_HEADERS.TRADING_PARTNER_ID%TYPE;

Line 200: l_auction_header_id PON_BID_HEADERS. AUCTION_HEADER_ID%TYPE;

196: x_msg_data IN OUT NOCOPY VARCHAR2
197: )
198: IS
199: l_bid_number PON_BID_HEADERS. BID_NUMBER%TYPE;
200: l_auction_header_id PON_BID_HEADERS. AUCTION_HEADER_ID%TYPE;
201: l_document_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
202: l_trading_partner_contact_id PON_BID_HEADERS.TRADING_PARTNER_CONTACT_ID%TYPE;
203: l_trading_partner_id PON_BID_HEADERS.TRADING_PARTNER_ID%TYPE;
204: l_publish_date VARCHAR2(100);

Line 202: l_trading_partner_contact_id PON_BID_HEADERS.TRADING_PARTNER_CONTACT_ID%TYPE;

198: IS
199: l_bid_number PON_BID_HEADERS. BID_NUMBER%TYPE;
200: l_auction_header_id PON_BID_HEADERS. AUCTION_HEADER_ID%TYPE;
201: l_document_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
202: l_trading_partner_contact_id PON_BID_HEADERS.TRADING_PARTNER_CONTACT_ID%TYPE;
203: l_trading_partner_id PON_BID_HEADERS.TRADING_PARTNER_ID%TYPE;
204: l_publish_date VARCHAR2(100);
205: l_surr_bid_created_contct_id PON_BID_HEADERS.SURROG_BID_CREATED_CONTACT_ID%TYPE;
206: l_surrog_bid_created_tp_id PON_BID_HEADERS.SURROG_BID_CREATED_TP_ID%TYPE;

Line 203: l_trading_partner_id PON_BID_HEADERS.TRADING_PARTNER_ID%TYPE;

199: l_bid_number PON_BID_HEADERS. BID_NUMBER%TYPE;
200: l_auction_header_id PON_BID_HEADERS. AUCTION_HEADER_ID%TYPE;
201: l_document_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
202: l_trading_partner_contact_id PON_BID_HEADERS.TRADING_PARTNER_CONTACT_ID%TYPE;
203: l_trading_partner_id PON_BID_HEADERS.TRADING_PARTNER_ID%TYPE;
204: l_publish_date VARCHAR2(100);
205: l_surr_bid_created_contct_id PON_BID_HEADERS.SURROG_BID_CREATED_CONTACT_ID%TYPE;
206: l_surrog_bid_created_tp_id PON_BID_HEADERS.SURROG_BID_CREATED_TP_ID%TYPE;
207:

Line 205: l_surr_bid_created_contct_id PON_BID_HEADERS.SURROG_BID_CREATED_CONTACT_ID%TYPE;

201: l_document_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
202: l_trading_partner_contact_id PON_BID_HEADERS.TRADING_PARTNER_CONTACT_ID%TYPE;
203: l_trading_partner_id PON_BID_HEADERS.TRADING_PARTNER_ID%TYPE;
204: l_publish_date VARCHAR2(100);
205: l_surr_bid_created_contct_id PON_BID_HEADERS.SURROG_BID_CREATED_CONTACT_ID%TYPE;
206: l_surrog_bid_created_tp_id PON_BID_HEADERS.SURROG_BID_CREATED_TP_ID%TYPE;
207:
208: l_parameter_list WF_PARAMETER_LIST_T := WF_PARAMETER_LIST_T();
209:

Line 206: l_surrog_bid_created_tp_id PON_BID_HEADERS.SURROG_BID_CREATED_TP_ID%TYPE;

202: l_trading_partner_contact_id PON_BID_HEADERS.TRADING_PARTNER_CONTACT_ID%TYPE;
203: l_trading_partner_id PON_BID_HEADERS.TRADING_PARTNER_ID%TYPE;
204: l_publish_date VARCHAR2(100);
205: l_surr_bid_created_contct_id PON_BID_HEADERS.SURROG_BID_CREATED_CONTACT_ID%TYPE;
206: l_surrog_bid_created_tp_id PON_BID_HEADERS.SURROG_BID_CREATED_TP_ID%TYPE;
207:
208: l_parameter_list WF_PARAMETER_LIST_T := WF_PARAMETER_LIST_T();
209:
210: BEGIN

Line 243: FROM PON_BID_HEADERS B, PON_AUCTION_HEADERS_ALL A

239: l_trading_partner_id,
240: l_publish_date,
241: l_surr_bid_created_contct_id,
242: l_surrog_bid_created_tp_id
243: FROM PON_BID_HEADERS B, PON_AUCTION_HEADERS_ALL A
244: WHERE B.BID_NUMBER = p_bid_number
245: AND A.AUCTION_HEADER_ID = B.AUCTION_HEADER_ID;
246:
247: --

Line 343: l_bid_number PON_BID_HEADERS. BID_NUMBER%TYPE;

339: x_msg_count IN OUT NOCOPY NUMBER,
340: x_msg_data IN OUT NOCOPY VARCHAR2
341: )
342: IS
343: l_bid_number PON_BID_HEADERS. BID_NUMBER%TYPE;
344: l_auction_header_id PON_BID_HEADERS. AUCTION_HEADER_ID%TYPE;
345: l_document_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
346: l_trading_partner_contact_id PON_BID_HEADERS.TRADING_PARTNER_CONTACT_ID%TYPE;
347: l_trading_partner_id PON_BID_HEADERS.TRADING_PARTNER_ID%TYPE;

Line 344: l_auction_header_id PON_BID_HEADERS. AUCTION_HEADER_ID%TYPE;

340: x_msg_data IN OUT NOCOPY VARCHAR2
341: )
342: IS
343: l_bid_number PON_BID_HEADERS. BID_NUMBER%TYPE;
344: l_auction_header_id PON_BID_HEADERS. AUCTION_HEADER_ID%TYPE;
345: l_document_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
346: l_trading_partner_contact_id PON_BID_HEADERS.TRADING_PARTNER_CONTACT_ID%TYPE;
347: l_trading_partner_id PON_BID_HEADERS.TRADING_PARTNER_ID%TYPE;
348: l_publish_date VARCHAR2(100);

Line 346: l_trading_partner_contact_id PON_BID_HEADERS.TRADING_PARTNER_CONTACT_ID%TYPE;

342: IS
343: l_bid_number PON_BID_HEADERS. BID_NUMBER%TYPE;
344: l_auction_header_id PON_BID_HEADERS. AUCTION_HEADER_ID%TYPE;
345: l_document_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
346: l_trading_partner_contact_id PON_BID_HEADERS.TRADING_PARTNER_CONTACT_ID%TYPE;
347: l_trading_partner_id PON_BID_HEADERS.TRADING_PARTNER_ID%TYPE;
348: l_publish_date VARCHAR2(100);
349: l_last_update_date VARCHAR2(100);
350: l_disqualify_reason PON_BID_HEADERS.DISQUALIFY_REASON%TYPE;

Line 347: l_trading_partner_id PON_BID_HEADERS.TRADING_PARTNER_ID%TYPE;

343: l_bid_number PON_BID_HEADERS. BID_NUMBER%TYPE;
344: l_auction_header_id PON_BID_HEADERS. AUCTION_HEADER_ID%TYPE;
345: l_document_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
346: l_trading_partner_contact_id PON_BID_HEADERS.TRADING_PARTNER_CONTACT_ID%TYPE;
347: l_trading_partner_id PON_BID_HEADERS.TRADING_PARTNER_ID%TYPE;
348: l_publish_date VARCHAR2(100);
349: l_last_update_date VARCHAR2(100);
350: l_disqualify_reason PON_BID_HEADERS.DISQUALIFY_REASON%TYPE;
351:

Line 350: l_disqualify_reason PON_BID_HEADERS.DISQUALIFY_REASON%TYPE;

346: l_trading_partner_contact_id PON_BID_HEADERS.TRADING_PARTNER_CONTACT_ID%TYPE;
347: l_trading_partner_id PON_BID_HEADERS.TRADING_PARTNER_ID%TYPE;
348: l_publish_date VARCHAR2(100);
349: l_last_update_date VARCHAR2(100);
350: l_disqualify_reason PON_BID_HEADERS.DISQUALIFY_REASON%TYPE;
351:
352: l_parameter_list WF_PARAMETER_LIST_T := WF_PARAMETER_LIST_T();
353:
354: BEGIN

Line 387: FROM PON_BID_HEADERS B, PON_AUCTION_HEADERS_ALL A

383: l_trading_partner_id,
384: l_publish_date,
385: l_last_update_date,
386: l_disqualify_reason
387: FROM PON_BID_HEADERS B, PON_AUCTION_HEADERS_ALL A
388: WHERE B.BID_NUMBER = p_bid_number
389: AND A.AUCTION_HEADER_ID = B.AUCTION_HEADER_ID;
390:
391: