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_AUCTION_HEADERS_ALL

Line 16: l_document_number pon_auction_headers_all.document_number%TYPE;

12: l_itemkey wf_items.item_key%TYPE;
13: l_process wf_process_activities.process_name%TYPE;
14: x_role_name VARCHAR2(100);
15: l_user_table wf_directory.usertable;
16: l_document_number pon_auction_headers_all.document_number%TYPE;
17: l_auction_title pon_auction_headers_all.auction_title%TYPE;
18: L_TRADING_PARTNER_ID pon_auction_headers_all.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;

Line 17: l_auction_title pon_auction_headers_all.auction_title%TYPE;

13: l_process wf_process_activities.process_name%TYPE;
14: x_role_name VARCHAR2(100);
15: l_user_table wf_directory.usertable;
16: l_document_number pon_auction_headers_all.document_number%TYPE;
17: l_auction_title pon_auction_headers_all.auction_title%TYPE;
18: L_TRADING_PARTNER_ID pon_auction_headers_all.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;

Line 18: L_TRADING_PARTNER_ID pon_auction_headers_all.TRADING_PARTNER_ID%TYPE;

14: x_role_name VARCHAR2(100);
15: l_user_table wf_directory.usertable;
16: l_document_number pon_auction_headers_all.document_number%TYPE;
17: l_auction_title pon_auction_headers_all.auction_title%TYPE;
18: L_TRADING_PARTNER_ID pon_auction_headers_all.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;

Line 19: L_TRADING_PARTNER_CONTACT_ID pon_auction_headers_all.TRADING_PARTNER_CONTACT_ID%TYPE;

15: l_user_table wf_directory.usertable;
16: l_document_number pon_auction_headers_all.document_number%TYPE;
17: l_auction_title pon_auction_headers_all.auction_title%TYPE;
18: L_TRADING_PARTNER_ID pon_auction_headers_all.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;

Line 21: L_TRADING_PARTNER_CONTACT_NAME PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_NAME%TYPE;

17: l_auction_title pon_auction_headers_all.auction_title%TYPE;
18: L_TRADING_PARTNER_ID pon_auction_headers_all.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);

Line 22: L_AUCTION_HEADER_ID_ORIG_AMEND PON_AUCTION_HEADERS_ALL.AUCTION_HEADER_ID_ORIG_AMEND%TYPE;

18: L_TRADING_PARTNER_ID pon_auction_headers_all.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);

Line 54: PON_AUCTION_HEADERS_ALL PAH,

50: /* Document Type */
51:
52: SELECT FL.LOOKUP_CODE,FL.MEANING INTO L_DOCUMENT_TYPE_CODE,L_DOCUMENT_TYPE
53: FROM
54: PON_AUCTION_HEADERS_ALL PAH,
55: PON_AUC_DOCTYPES DOC,
56: FND_LOOKUPS FL
57: WHERE
58: PAH.AUCTION_HEADER_ID=L_AUCTION_HEADER_ID

Line 141: PON_AUCTION_HEADERS_ALL PAH WHERE PAH.AUCTION_HEADER_ID=L_AUCTION_HEADER_ID;

137: L_PREVIEW_DATE,L_START_DATE,L_END_DATE,L_TRADING_PARTNER_CONTACT_ID,
138: L_FROM_USER,
139: L_AUCTION_HEADER_ID_ORIG_AMEND
140: FROM
141: PON_AUCTION_HEADERS_ALL PAH WHERE PAH.AUCTION_HEADER_ID=L_AUCTION_HEADER_ID;
142:
143: L_STEP:=3;
144:
145: /* Receiver will be the supplier user in this case */

Line 386: PON_AUCTION_HEADERS_ALL PAH

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
390: PBH.BID_NUMBER=L_BID_NUMBER;

Line 425: l_document_number pon_auction_headers_all.document_number%TYPE;

421: l_itemkey wf_items.item_key%TYPE;
422: l_process wf_process_activities.process_name%TYPE;
423: x_role_name VARCHAR2(100);
424: l_user_table wf_directory.usertable;
425: l_document_number pon_auction_headers_all.document_number%TYPE;
426: l_auction_title pon_auction_headers_all.auction_title%TYPE;
427: L_TRADING_PARTNER_ID pon_auction_headers_all.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;

Line 426: l_auction_title pon_auction_headers_all.auction_title%TYPE;

422: l_process wf_process_activities.process_name%TYPE;
423: x_role_name VARCHAR2(100);
424: l_user_table wf_directory.usertable;
425: l_document_number pon_auction_headers_all.document_number%TYPE;
426: l_auction_title pon_auction_headers_all.auction_title%TYPE;
427: L_TRADING_PARTNER_ID pon_auction_headers_all.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;

Line 427: L_TRADING_PARTNER_ID pon_auction_headers_all.TRADING_PARTNER_ID%TYPE;

423: x_role_name VARCHAR2(100);
424: l_user_table wf_directory.usertable;
425: l_document_number pon_auction_headers_all.document_number%TYPE;
426: l_auction_title pon_auction_headers_all.auction_title%TYPE;
427: L_TRADING_PARTNER_ID pon_auction_headers_all.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;

Line 428: L_TRADING_PARTNER_CONTACT_ID pon_auction_headers_all.TRADING_PARTNER_CONTACT_ID%TYPE;

424: l_user_table wf_directory.usertable;
425: l_document_number pon_auction_headers_all.document_number%TYPE;
426: l_auction_title pon_auction_headers_all.auction_title%TYPE;
427: L_TRADING_PARTNER_ID pon_auction_headers_all.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;

Line 430: L_TRADING_PARTNER_CONTACT_NAME PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_NAME%TYPE;

426: l_auction_title pon_auction_headers_all.auction_title%TYPE;
427: L_TRADING_PARTNER_ID pon_auction_headers_all.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);

Line 431: L_AUCTION_HEADER_ID_ORIG_AMEND PON_AUCTION_HEADERS_ALL.AUCTION_HEADER_ID_ORIG_AMEND%TYPE;

427: L_TRADING_PARTNER_ID pon_auction_headers_all.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);

Line 460: PON_AUCTION_HEADERS_ALL PAH,

456: /* Document Type */
457:
458: SELECT FL.LOOKUP_CODE,FL.MEANING INTO L_DOCUMENT_TYPE_CODE,L_DOCUMENT_TYPE
459: FROM
460: PON_AUCTION_HEADERS_ALL PAH,
461: PON_AUC_DOCTYPES DOC,
462: FND_LOOKUPS FL
463: WHERE
464: PAH.AUCTION_HEADER_ID=L_AUCTION_HEADER_ID

Line 543: PON_AUCTION_HEADERS_ALL PAH WHERE PAH.AUCTION_HEADER_ID=L_AUCTION_HEADER_ID;

539: INTO L_TRADING_PARTNER_CONTACT_NAME,L_DOCUMENT_NUMBER,L_AUCTION_TITLE,L_TRADING_PARTNER_ID,
540: L_PREVIEW_DATE,L_START_DATE,L_END_DATE,L_TRADING_PARTNER_CONTACT_ID,
541: L_AUCTION_HEADER_ID_ORIG_AMEND
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

Line 777: PON_AUCTION_HEADERS_ALL PAH

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
781: PBH.BID_NUMBER=L_BID_NUMBER;