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_WF_UTL_PKG dependencies on PON_AUCTION_HEADERS_ALL

Line 502: FROM PON_AUCTION_HEADERS_ALL

498:
499: BEGIN
500: SELECT 'N'
501: INTO x_neg_deleted
502: FROM PON_AUCTION_HEADERS_ALL
503: WHERE auction_header_id = x_auction_id;
504: EXCEPTION
505: WHEN NO_DATA_FOUND THEN
506: x_neg_deleted := 'Y';

Line 592: l_auction_title pon_auction_headers_all.auction_title%type;

588: l_item_type Varchar2(8) := 'PONCNCT';
589: l_item_key Varchar2(240);
590: l_language_code VARCHAR2(5);
591: l_msg_suffix VARCHAR2(10);
592: l_auction_title pon_auction_headers_all.auction_title%type;
593: l_document_number pon_auction_headers_all.document_number%type;
594: l_trading_partner_contact_name pon_auction_headers_all.trading_partner_contact_name%type;
595: l_trading_partner_name pon_auction_headers_all.trading_partner_name%type;
596: l_doctype_group_name pon_auc_doctypes.doctype_group_name%type;

Line 593: l_document_number pon_auction_headers_all.document_number%type;

589: l_item_key Varchar2(240);
590: l_language_code VARCHAR2(5);
591: l_msg_suffix VARCHAR2(10);
592: l_auction_title pon_auction_headers_all.auction_title%type;
593: l_document_number pon_auction_headers_all.document_number%type;
594: l_trading_partner_contact_name pon_auction_headers_all.trading_partner_contact_name%type;
595: l_trading_partner_name pon_auction_headers_all.trading_partner_name%type;
596: l_doctype_group_name pon_auc_doctypes.doctype_group_name%type;
597: l_doctypemsgval Varchar2(80);

Line 594: l_trading_partner_contact_name pon_auction_headers_all.trading_partner_contact_name%type;

590: l_language_code VARCHAR2(5);
591: l_msg_suffix VARCHAR2(10);
592: l_auction_title pon_auction_headers_all.auction_title%type;
593: l_document_number pon_auction_headers_all.document_number%type;
594: l_trading_partner_contact_name pon_auction_headers_all.trading_partner_contact_name%type;
595: l_trading_partner_name pon_auction_headers_all.trading_partner_name%type;
596: l_doctype_group_name pon_auc_doctypes.doctype_group_name%type;
597: l_doctypemsgval Varchar2(80);
598:

Line 595: l_trading_partner_name pon_auction_headers_all.trading_partner_name%type;

591: l_msg_suffix VARCHAR2(10);
592: l_auction_title pon_auction_headers_all.auction_title%type;
593: l_document_number pon_auction_headers_all.document_number%type;
594: l_trading_partner_contact_name pon_auction_headers_all.trading_partner_contact_name%type;
595: l_trading_partner_name pon_auction_headers_all.trading_partner_name%type;
596: l_doctype_group_name pon_auc_doctypes.doctype_group_name%type;
597: l_doctypemsgval Varchar2(80);
598:
599: /* Variables added for CLM Sol Amendments project. */

Line 600: l_auc_head_id_prev_amend pon_auction_headers_all.auction_header_id%type;

596: l_doctype_group_name pon_auc_doctypes.doctype_group_name%type;
597: l_doctypemsgval Varchar2(80);
598:
599: /* Variables added for CLM Sol Amendments project. */
600: l_auc_head_id_prev_amend pon_auction_headers_all.auction_header_id%type;
601: l_revision pon_auction_headers_all.revision%type;
602: l_amendment_number pon_auction_headers_all.document_number%type;
603: l_rev_message VARCHAR2(30);
604: l_success_msg VARCHAR2(100);

Line 601: l_revision pon_auction_headers_all.revision%type;

597: l_doctypemsgval Varchar2(80);
598:
599: /* Variables added for CLM Sol Amendments project. */
600: l_auc_head_id_prev_amend pon_auction_headers_all.auction_header_id%type;
601: l_revision pon_auction_headers_all.revision%type;
602: l_amendment_number pon_auction_headers_all.document_number%type;
603: l_rev_message VARCHAR2(30);
604: l_success_msg VARCHAR2(100);
605:

Line 602: l_amendment_number pon_auction_headers_all.document_number%type;

598:
599: /* Variables added for CLM Sol Amendments project. */
600: l_auc_head_id_prev_amend pon_auction_headers_all.auction_header_id%type;
601: l_revision pon_auction_headers_all.revision%type;
602: l_amendment_number pon_auction_headers_all.document_number%type;
603: l_rev_message VARCHAR2(30);
604: l_success_msg VARCHAR2(100);
605:
606: BEGIN

Line 627: pon_auction_headers_all auc,

623: l_auction_title,
624: l_document_number,
625: l_doctype_group_name
626: FROM
627: pon_auction_headers_all auc,
628: pon_auc_doctypes dt
629: WHERE
630: dt.doctype_id= auc.doctype_id
631: AND auc.auction_header_id = p_auction_header_id;

Line 725: from pon_auction_headers_all

721: if p_ProgramTypeCode = 'AMENDMENT_COPY' and p_messagetype ='S' then
722:
723: select auction_header_id_prev_amend,revision
724: into l_auc_head_id_prev_amend,l_revision
725: from pon_auction_headers_all
726: where auction_header_id = p_auction_header_id;
727:
728: select document_number
729: into l_amendment_number

Line 730: from pon_auction_headers_all

726: where auction_header_id = p_auction_header_id;
727:
728: select document_number
729: into l_amendment_number
730: from pon_auction_headers_all
731: where auction_header_id_prev_amend = l_auc_head_id_prev_amend
732: and nvl(amendment_flag,'N') = 'Y';
733:
734: fnd_message.set_name('PON', 'PON_REVISION_CLM');

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

811:
812:
813: FUNCTION GET_NOTIF_PREFERENCE (
814: p_wf_message_name IN WF_MESSAGES.NAME%TYPE,
815: p_auction_id IN PON_AUCTION_HEADERS_ALL.AUCTION_HEADER_ID%TYPE) RETURN VARCHAR2
816: IS
817:
818: l_document_type PON_AUC_DOCTYPES.DOCTYPE_GROUP_NAME%TYPE;
819: l_api_name CONSTANT VARCHAR2(30) := 'get_notif_preference_1';

Line 836: FROM PON_AUCTION_HEADERS_ALL auctionHdr,

832:
833:
834: SELECT docTypes.DOCTYPE_GROUP_NAME
835: INTO l_document_type
836: FROM PON_AUCTION_HEADERS_ALL auctionHdr,
837: PON_AUC_DOCTYPES docTypes
838: WHERE auctionHdr.AUCTION_HEADER_ID = p_auction_id
839: AND auctionHdr.DOCTYPE_ID = docTypes.DOCTYPE_ID;
840: