1: PACKAGE BODY po_negotiation_req_notif AS
2: /* $Header: POXNEG2B.pls 120.2 2010/10/08 10:44:24 dashah ship $*/
3:
4: TYPE line_record IS RECORD (
5: req_line_id po_requisition_lines.requisition_line_id%TYPE,
211: /* build the message body and set the attribute */
212: IF Source in ('MRP','WITHDRAW') THEN
213:
214: -- Bug 3346038
215: po_negotiation_req_notif.set_req_line_details_mrp_wd(ItemType,ItemKey,x_document);
216:
217: wf_engine.SetItemAttrText(itemtype => Itemtype,
218: itemkey => ItemKey,
219: aname => 'PO_REQ_CHN_MSG_SUB_MRP',
230: aname => 'PO_REQ_CHN_MSG_BODY_MRP',
231: -- Bug 3346038, Should use PLSQLCLOB
232: -- avalue => x_document);
233: avalue =>
234: 'PLSQLCLOB:PO_NEGOTIATION_REQ_NOTIF.GET_REQ_LINE_DETAILS_MRP_WD/'||
235: itemtype||':'||itemkey);
236: ELSE
237:
238: wf_engine.SetItemAttrText(itemtype => Itemtype,
243: wf_engine.SetItemAttrText(itemtype => itemtype,
244: itemkey => itemkey,
245: aname => 'PO_REQ_CHN_MSG_BODY',
246: avalue =>
247: 'PLSQLCLOB:PO_NEGOTIATION_REQ_NOTIF.GET_REQ_LINE_DETAILS/'||
248: itemtype||':'||
249: itemkey);
250:
251: END IF;
948: x_auction_num ;
949:
950: EXIT WHEN c1%NOTFOUND;
951:
952: po_negotiation_req_notif.req_change_workflow_startup(x_control_level,
953: x_auction_header_id ,
954: x_auction_num,
955: x_document_id);
956:
964: fetch c2 into x_auction_header_id,
965: x_auction_num ;
966: EXIT WHEN c2%NOTFOUND;
967:
968: po_negotiation_req_notif.req_change_workflow_startup(x_control_level,
969: x_auction_header_id ,
970: x_auction_num,
971: x_document_id);
972:
980: fetch c3 into x_auction_header_id,
981: x_auction_num ;
982: EXIT WHEN c3%NOTFOUND;
983:
984: po_negotiation_req_notif.req_change_workflow_startup(x_control_level,
985: x_auction_header_id ,
986: x_auction_num,
987: x_document_id);
988: end loop;
998: fetch interface into x_auction_header_id,
999: x_auction_num ;
1000: exit when interface%notfound;
1001:
1002: po_negotiation_req_notif.req_change_workflow_startup(x_control_level,
1003: x_auction_header_id,
1004: x_auction_num,
1005: null,
1006: x_process_id);
1048: else
1049: resultout := wf_engine.eng_completed || ':' || 'OTHERS';
1050: end if;
1051: end;
1052: END po_negotiation_req_notif;