[Home] [Help]
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: /*
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. */
600: l_auc_head_id_prev_amend pon_auction_headers_all.auction_header_id%type;
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;
632:
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';
820:
821: BEGIN
822:
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:
841: RETURN GET_NOTIF_PREFERENCE(p_wf_message_name, l_document_type);
879:
880:
881: FUNCTION GET_NOTIF_PREFERENCE (
882: p_wf_message_name IN WF_MESSAGES.NAME%TYPE,
883: p_doctype IN PON_AUC_DOCTYPES.DOCTYPE_GROUP_NAME%TYPE)
884: RETURN VARCHAR2
885: IS
886:
887: l_notif_pref VARCHAR2(3);