4:
5: FUNCTION get_base_supplier_url RETURN VARCHAR2;
6: FUNCTION get_base_buyer_url RETURN VARCHAR2;
7: FUNCTION GET_NOTIF_PREFERENCE ( p_wf_message_name IN WF_MESSAGES.NAME%TYPE,
8: p_doctype IN PON_AUC_DOCTYPES.DOCTYPE_GROUP_NAME%TYPE)
9: RETURN VARCHAR2;
10:
11:
12: /*
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:
574: select to_char(p_auction_header_id) || '-' ||
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;
598:
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';
752:
753: BEGIN
754:
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:
773: RETURN GET_NOTIF_PREFERENCE(p_wf_message_name, l_document_type);
811:
812:
813: FUNCTION GET_NOTIF_PREFERENCE (
814: p_wf_message_name IN WF_MESSAGES.NAME%TYPE,
815: p_doctype IN PON_AUC_DOCTYPES.DOCTYPE_GROUP_NAME%TYPE)
816: RETURN VARCHAR2
817: IS
818:
819: l_notif_pref VARCHAR2(3);