APPS.PON_WITH_DRAW_PKG dependencies on HZ_PARTIES

Line 20: L_PREPARER_TP_NAME HZ_PARTIES.PARTY_NAME%TYPE;

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;
24: L_BID_TRADPART_CNTC_ID pon_bid_headers.TRADING_PARTNER_CONTACT_ID%TYPE;

Line 33: L_FROM_USER HZ_PARTIES.PARTY_NAME%TYPE;

29: L_END_DATE DATE;
30: L_SUPPLIER AP_SUPPLIERS.VENDOR_NAME%TYPE;
31: L_SUPPLIER_SITE_ID NUMBER;
32: L_SUPPLIER_SITE_NAME AP_SUPPLIER_SITES_ALL.VENDOR_SITE_CODE%TYPE:=NULL;
33: L_FROM_USER HZ_PARTIES.PARTY_NAME%TYPE;
34: X_VIEW_QUOTE_URL VARCHAR2(2000);
35: X_NOTIFICATION_ID NUMBER;
36: L_NOTIF_SUBSCR_FLAG VARCHAR2(1);
37:

Line 209: HZ_PARTIES HZ

205: avalue => L_TRADING_PARTNER_CONTACT_NAME);
206:
207: SELECT HZ.PARTY_NAME INTO L_PREPARER_TP_NAME
208: FROM
209: HZ_PARTIES HZ
210: WHERE
211: PARTY_ID=L_TRADING_PARTNER_ID;
212:
213: L_STEP:=6;

Line 429: L_PREPARER_TP_NAME HZ_PARTIES.PARTY_NAME%TYPE;

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;
433: L_BID_TRADPART_CNTC_ID pon_bid_headers.TRADING_PARTNER_CONTACT_ID%TYPE;

Line 442: L_FROM_USER HZ_PARTIES.PARTY_NAME%TYPE;

438: L_END_DATE DATE;
439: L_SUPPLIER AP_SUPPLIERS.VENDOR_NAME%TYPE;
440: L_SUPPLIER_SITE_ID NUMBER;
441: L_SUPPLIER_SITE_NAME AP_SUPPLIER_SITES_ALL.VENDOR_SITE_CODE%TYPE:=NULL;
442: L_FROM_USER HZ_PARTIES.PARTY_NAME%TYPE;
443:
444: X_VIEW_QUOTE_URL VARCHAR2(2000);
445: X_NOTIFICATION_ID NUMBER;
446: L_NOTIF_SUBSCR_FLAG VARCHAR2(1);

Line 608: HZ_PARTIES HZ

604: avalue => L_TRADING_PARTNER_CONTACT_NAME);
605:
606: SELECT HZ.PARTY_NAME INTO L_PREPARER_TP_NAME
607: FROM
608: HZ_PARTIES HZ
609: WHERE
610: PARTY_ID=L_TRADING_PARTNER_ID;
611:
612: wf_engine.SetItemAttrText (itemtype => l_itemtype,