[Home] [Help]
180: /* Setting the negotiation title header attribute */
181: wf_engine.SetItemAttrText(itemtype => p_itemtype
182: ,itemkey => p_itemkey
183: ,aname => 'AUCTION_TITLE'
184: ,avalue => pon_auction_pkg.replaceHtmlChars(p_auction_title));
185:
186: /* Setting the negotiation document number attribute */
187: wf_engine.SetItemAttrText(itemtype => p_itemtype
188: ,itemkey => p_itemkey
575: to_char(p_request_id)
576: into l_item_key from dual;
577: -- set the db session language
578: PON_PROFILE_UTIL_PKG.get_wf_language(p_RecepientUsername, l_language_code);
579: PON_AUCTION_PKG.set_session_language(null, l_language_code);
580: SELECT
581: auc.trading_partner_contact_name,
582: auc.trading_partner_name,
583: auc.auction_title,
595: WHERE
596: dt.doctype_id= auc.doctype_id
597: AND auc.auction_header_id = p_auction_header_id;
598:
599: l_msg_suffix := PON_AUCTION_PKG.get_message_suffix(l_doctype_group_name);
600: l_doctypemsgval := PON_AUCTION_PKG.getmessage('PON_AUCTION',l_msg_suffix);
601: if p_messagetype ='S' then
602: wf_engine.CreateProcess(itemtype => l_item_type,
603: itemkey => l_item_key,
596: dt.doctype_id= auc.doctype_id
597: AND auc.auction_header_id = p_auction_header_id;
598:
599: l_msg_suffix := PON_AUCTION_PKG.get_message_suffix(l_doctype_group_name);
600: l_doctypemsgval := PON_AUCTION_PKG.getmessage('PON_AUCTION',l_msg_suffix);
601: if p_messagetype ='S' then
602: wf_engine.CreateProcess(itemtype => l_item_type,
603: itemkey => l_item_key,
604: process => 'REPORT_SUCCESS');
656:
657: wf_engine.SetItemAttrText(itemtype => l_item_type,
658: itemkey => l_item_key,
659: aname => 'NOTIFICATION_SUBJECT',
660: avalue => PON_AUCTION_PKG.getMessage('PONCPG' || p_messagetype || '_' || p_ProgramTypeCode,
661: l_msg_suffix,
662: 'REQUEST_ID', --REQUEST_ID
663: to_char(p_request_id),
664: 'DOC_TYPE',