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.

[Home] [Help]

APPS.PON_WF_UTL_PKG dependencies on PON_AUCTION_HEADERS_ALL

Line 475: FROM PON_AUCTION_HEADERS_ALL

471:
472: BEGIN
473: SELECT 'N'
474: INTO x_neg_deleted
475: FROM PON_AUCTION_HEADERS_ALL
476: WHERE auction_header_id = x_auction_id;
477: EXCEPTION
478: WHEN NO_DATA_FOUND THEN
479: x_neg_deleted := 'Y';

Line 566: l_auction_title pon_auction_headers_all.auction_title%type;

562: l_item_type Varchar2(8) := 'PONCNCT';
563: l_item_key Varchar2(240);
564: l_language_code VARCHAR2(5);
565: l_msg_suffix VARCHAR2(10);
566: l_auction_title pon_auction_headers_all.auction_title%type;
567: l_document_number pon_auction_headers_all.document_number%type;
568: l_trading_partner_contact_name pon_auction_headers_all.trading_partner_contact_name%type;
569: l_trading_partner_name pon_auction_headers_all.trading_partner_name%type;
570: l_doctype_group_name pon_auc_doctypes.doctype_group_name%type;

Line 567: l_document_number pon_auction_headers_all.document_number%type;

563: l_item_key Varchar2(240);
564: l_language_code VARCHAR2(5);
565: l_msg_suffix VARCHAR2(10);
566: l_auction_title pon_auction_headers_all.auction_title%type;
567: l_document_number pon_auction_headers_all.document_number%type;
568: l_trading_partner_contact_name pon_auction_headers_all.trading_partner_contact_name%type;
569: l_trading_partner_name pon_auction_headers_all.trading_partner_name%type;
570: l_doctype_group_name pon_auc_doctypes.doctype_group_name%type;
571: l_doctypemsgval Varchar2(80);

Line 568: l_trading_partner_contact_name pon_auction_headers_all.trading_partner_contact_name%type;

564: l_language_code VARCHAR2(5);
565: l_msg_suffix VARCHAR2(10);
566: l_auction_title pon_auction_headers_all.auction_title%type;
567: l_document_number pon_auction_headers_all.document_number%type;
568: l_trading_partner_contact_name pon_auction_headers_all.trading_partner_contact_name%type;
569: l_trading_partner_name pon_auction_headers_all.trading_partner_name%type;
570: l_doctype_group_name pon_auc_doctypes.doctype_group_name%type;
571: l_doctypemsgval Varchar2(80);
572: BEGIN

Line 569: l_trading_partner_name pon_auction_headers_all.trading_partner_name%type;

565: l_msg_suffix VARCHAR2(10);
566: l_auction_title pon_auction_headers_all.auction_title%type;
567: l_document_number pon_auction_headers_all.document_number%type;
568: l_trading_partner_contact_name pon_auction_headers_all.trading_partner_contact_name%type;
569: l_trading_partner_name pon_auction_headers_all.trading_partner_name%type;
570: l_doctype_group_name pon_auc_doctypes.doctype_group_name%type;
571: l_doctypemsgval Varchar2(80);
572: BEGIN
573:

Line 593: pon_auction_headers_all auc,

589: l_auction_title,
590: l_document_number,
591: l_doctype_group_name
592: FROM
593: pon_auction_headers_all auc,
594: pon_auc_doctypes dt
595: WHERE
596: dt.doctype_id= auc.doctype_id
597: AND auc.auction_header_id = p_auction_header_id;

Line 747: p_auction_id IN PON_AUCTION_HEADERS_ALL.AUCTION_HEADER_ID%TYPE) RETURN VARCHAR2

743:
744:
745: FUNCTION GET_NOTIF_PREFERENCE (
746: p_wf_message_name IN WF_MESSAGES.NAME%TYPE,
747: p_auction_id IN PON_AUCTION_HEADERS_ALL.AUCTION_HEADER_ID%TYPE) RETURN VARCHAR2
748: IS
749:
750: l_document_type PON_AUC_DOCTYPES.DOCTYPE_GROUP_NAME%TYPE;
751: l_api_name CONSTANT VARCHAR2(30) := 'get_notif_preference_1';

Line 768: FROM PON_AUCTION_HEADERS_ALL auctionHdr,

764:
765:
766: SELECT docTypes.DOCTYPE_GROUP_NAME
767: INTO l_document_type
768: FROM PON_AUCTION_HEADERS_ALL auctionHdr,
769: PON_AUC_DOCTYPES docTypes
770: WHERE auctionHdr.AUCTION_HEADER_ID = p_auction_id
771: AND auctionHdr.DOCTYPE_ID = docTypes.DOCTYPE_ID;
772: