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

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 952: po_negotiation_req_notif.req_change_workflow_startup(x_control_level,

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:

Line 968: po_negotiation_req_notif.req_change_workflow_startup(x_control_level,

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:

Line 984: po_negotiation_req_notif.req_change_workflow_startup(x_control_level,

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;

Line 1002: po_negotiation_req_notif.req_change_workflow_startup(x_control_level,

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);

Line 1052: END po_negotiation_req_notif;

1048: else
1049: resultout := wf_engine.eng_completed || ':' || 'OTHERS';
1050: end if;
1051: end;
1052: END po_negotiation_req_notif;