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

Line 23: L_BID_TRADING_PARTNER_ID pon_bid_headers.TRADING_PARTNER_ID%TYPE;

19: L_TRADING_PARTNER_CONTACT_ID pon_auction_headers_all.TRADING_PARTNER_CONTACT_ID%TYPE;
20: L_PREPARER_TP_NAME HZ_PARTIES.PARTY_NAME%TYPE;
21: L_TRADING_PARTNER_CONTACT_NAME PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_NAME%TYPE;
22: L_AUCTION_HEADER_ID_ORIG_AMEND PON_AUCTION_HEADERS_ALL.AUCTION_HEADER_ID_ORIG_AMEND%TYPE;
23: L_BID_TRADING_PARTNER_ID pon_bid_headers.TRADING_PARTNER_ID%TYPE;
24: L_BID_TRADPART_CNTC_ID pon_bid_headers.TRADING_PARTNER_CONTACT_ID%TYPE;
25: L_DOCUMENT_TYPE VARCHAR2(100);
26: L_DOCUMENT_TYPE_CODE VARCHAR2(100);
27: L_PREVIEW_DATE DATE;

Line 24: L_BID_TRADPART_CNTC_ID pon_bid_headers.TRADING_PARTNER_CONTACT_ID%TYPE;

20: L_PREPARER_TP_NAME HZ_PARTIES.PARTY_NAME%TYPE;
21: L_TRADING_PARTNER_CONTACT_NAME PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_NAME%TYPE;
22: L_AUCTION_HEADER_ID_ORIG_AMEND PON_AUCTION_HEADERS_ALL.AUCTION_HEADER_ID_ORIG_AMEND%TYPE;
23: L_BID_TRADING_PARTNER_ID pon_bid_headers.TRADING_PARTNER_ID%TYPE;
24: L_BID_TRADPART_CNTC_ID pon_bid_headers.TRADING_PARTNER_CONTACT_ID%TYPE;
25: L_DOCUMENT_TYPE VARCHAR2(100);
26: L_DOCUMENT_TYPE_CODE VARCHAR2(100);
27: L_PREVIEW_DATE DATE;
28: L_START_DATE DATE;

Line 148: FROM PON_BID_HEADERS PBH

144:
145: /* Receiver will be the supplier user in this case */
146:
147: SELECT PBH.TRADING_PARTNER_CONTACT_NAME INTO L_TRADING_PARTNER_CONTACT_NAME
148: FROM PON_BID_HEADERS PBH
149: WHERE
150: PBH.BID_NUMBER=L_BID_NUMBER
151: AND
152: PBH.AUCTION_HEADER_ID=L_AUCTION_HEADER_ID

Line 302: PON_BID_HEADERS PBH

298:
299: SELECT PBH.TRADING_PARTNER_NAME,PBH.VENDOR_SITE_ID
300: INTO L_SUPPLIER,L_SUPPLIER_SITE_ID
301: FROM
302: PON_BID_HEADERS PBH
303: WHERE
304: PBH.AUCTION_HEADER_ID=L_AUCTION_HEADER_ID
305: AND
306: PBH.BID_NUMBER=L_BID_NUMBER;

Line 369: UPDATE PON_BID_HEADERS

365:
366: END IF;
367:
368:
369: UPDATE PON_BID_HEADERS
370: SET
371: WITHDRAW_REASON=L_WITHDRAW_REASON,
372: BID_STATUS='ARCHIVED'
373: WHERE

Line 385: FROM PON_BID_HEADERS PBH,

381: SELECT PBH.TRADING_PARTNER_ID,PBH.TRADING_PARTNER_CONTACT_ID,
382: PAH.AUCTION_HEADER_ID_ORIG_AMEND
383: INTO L_BID_TRADING_PARTNER_ID,L_BID_TRADPART_CNTC_ID,
384: L_AUCTION_HEADER_ID_ORIG_AMEND
385: FROM PON_BID_HEADERS PBH,
386: PON_AUCTION_HEADERS_ALL PAH
387: WHERE
388: PAH.AUCTION_HEADER_ID=L_AUCTION_HEADER_ID and
389: PBH.AUCTION_HEADER_ID=L_AUCTION_HEADER_ID AND

Line 432: L_BID_TRADING_PARTNER_ID pon_bid_headers.TRADING_PARTNER_ID%TYPE;

428: L_TRADING_PARTNER_CONTACT_ID pon_auction_headers_all.TRADING_PARTNER_CONTACT_ID%TYPE;
429: L_PREPARER_TP_NAME HZ_PARTIES.PARTY_NAME%TYPE;
430: L_TRADING_PARTNER_CONTACT_NAME PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_NAME%TYPE;
431: L_AUCTION_HEADER_ID_ORIG_AMEND PON_AUCTION_HEADERS_ALL.AUCTION_HEADER_ID_ORIG_AMEND%TYPE;
432: L_BID_TRADING_PARTNER_ID pon_bid_headers.TRADING_PARTNER_ID%TYPE;
433: L_BID_TRADPART_CNTC_ID pon_bid_headers.TRADING_PARTNER_CONTACT_ID%TYPE;
434: L_DOCUMENT_TYPE VARCHAR2(100);
435: L_DOCUMENT_TYPE_CODE VARCHAR2(100);
436: L_PREVIEW_DATE DATE;

Line 433: L_BID_TRADPART_CNTC_ID pon_bid_headers.TRADING_PARTNER_CONTACT_ID%TYPE;

429: L_PREPARER_TP_NAME HZ_PARTIES.PARTY_NAME%TYPE;
430: L_TRADING_PARTNER_CONTACT_NAME PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_NAME%TYPE;
431: L_AUCTION_HEADER_ID_ORIG_AMEND PON_AUCTION_HEADERS_ALL.AUCTION_HEADER_ID_ORIG_AMEND%TYPE;
432: L_BID_TRADING_PARTNER_ID pon_bid_headers.TRADING_PARTNER_ID%TYPE;
433: L_BID_TRADPART_CNTC_ID pon_bid_headers.TRADING_PARTNER_CONTACT_ID%TYPE;
434: L_DOCUMENT_TYPE VARCHAR2(100);
435: L_DOCUMENT_TYPE_CODE VARCHAR2(100);
436: L_PREVIEW_DATE DATE;
437: L_START_DATE DATE;

Line 546: FROM PON_BID_HEADERS PBH

542: FROM
543: PON_AUCTION_HEADERS_ALL PAH WHERE PAH.AUCTION_HEADER_ID=L_AUCTION_HEADER_ID;
544:
545: SELECT PBH.TRADING_PARTNER_CONTACT_NAME INTO L_FROM_USER
546: FROM PON_BID_HEADERS PBH
547: WHERE
548: PBH.BID_NUMBER=L_BID_NUMBER
549: AND
550: PBH.AUCTION_HEADER_ID=L_AUCTION_HEADER_ID

Line 700: PON_BID_HEADERS PBH

696:
697: SELECT PBH.TRADING_PARTNER_NAME,PBH.VENDOR_SITE_ID
698: INTO L_SUPPLIER,L_SUPPLIER_SITE_ID
699: FROM
700: PON_BID_HEADERS PBH
701: WHERE
702: PBH.AUCTION_HEADER_ID=L_AUCTION_HEADER_ID
703: AND
704: PBH.BID_NUMBER=L_BID_NUMBER;

Line 761: UPDATE PON_BID_HEADERS

757: itemkey => l_itemkey );
758:
759: END IF;
760:
761: UPDATE PON_BID_HEADERS
762: SET
763: WITHDRAW_REASON=L_WITHDRAW_REASON,
764: BID_STATUS='ARCHIVED'
765: WHERE

Line 776: FROM PON_BID_HEADERS PBH,

772: SELECT PBH.TRADING_PARTNER_ID,PBH.TRADING_PARTNER_CONTACT_ID,
773: PAH.AUCTION_HEADER_ID_ORIG_AMEND
774: INTO L_BID_TRADING_PARTNER_ID,L_BID_TRADPART_CNTC_ID,
775: L_AUCTION_HEADER_ID_ORIG_AMEND
776: FROM PON_BID_HEADERS PBH,
777: PON_AUCTION_HEADERS_ALL PAH
778: WHERE
779: PAH.AUCTION_HEADER_ID = L_AUCTION_HEADER_ID AND
780: PBH.AUCTION_HEADER_ID=L_AUCTION_HEADER_ID AND