DBA Data[Home] [Help]

APPS.PO_NEGOTIATION_REQ_NOTIF dependencies on PO_NEGOTIATION_REQ_NOTIF

Line 1: PACKAGE BODY po_negotiation_req_notif AS

1: PACKAGE BODY po_negotiation_req_notif AS
2: /* $Header: POXNEG2B.pls 120.0 2005/06/02 00:27:09 appldev noship $*/
3:
4: TYPE line_record IS RECORD (
5: req_line_id po_requisition_lines.requisition_line_id%TYPE,

Line 215: po_negotiation_req_notif.set_req_line_details_mrp_wd(ItemType,ItemKey,x_document);

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',

Line 234: 'PLSQLCLOB:PO_NEGOTIATION_REQ_NOTIF.GET_REQ_LINE_DETAILS_MRP_WD/'||

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,

Line 247: 'PLSQLCLOB:PO_NEGOTIATION_REQ_NOTIF.GET_REQ_LINE_DETAILS/'||

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;

Line 949: po_negotiation_req_notif.req_change_workflow_startup(x_control_level,

945: x_auction_num ;
946:
947: EXIT WHEN c1%NOTFOUND;
948:
949: po_negotiation_req_notif.req_change_workflow_startup(x_control_level,
950: x_auction_header_id ,
951: x_auction_num,
952: x_document_id);
953:

Line 965: po_negotiation_req_notif.req_change_workflow_startup(x_control_level,

961: fetch c2 into x_auction_header_id,
962: x_auction_num ;
963: EXIT WHEN c2%NOTFOUND;
964:
965: po_negotiation_req_notif.req_change_workflow_startup(x_control_level,
966: x_auction_header_id ,
967: x_auction_num,
968: x_document_id);
969:

Line 981: po_negotiation_req_notif.req_change_workflow_startup(x_control_level,

977: fetch c3 into x_auction_header_id,
978: x_auction_num ;
979: EXIT WHEN c3%NOTFOUND;
980:
981: po_negotiation_req_notif.req_change_workflow_startup(x_control_level,
982: x_auction_header_id ,
983: x_auction_num,
984: x_document_id);
985: end loop;

Line 999: po_negotiation_req_notif.req_change_workflow_startup(x_control_level,

995: fetch interface into x_auction_header_id,
996: x_auction_num ;
997: exit when interface%notfound;
998:
999: po_negotiation_req_notif.req_change_workflow_startup(x_control_level,
1000: x_auction_header_id,
1001: x_auction_num,
1002: null,
1003: x_process_id);

Line 1049: END po_negotiation_req_notif;

1045: else
1046: resultout := wf_engine.eng_completed || ':' || 'OTHERS';
1047: end if;
1048: end;
1049: END po_negotiation_req_notif;