1 PACKAGE po_negotiation_req_notif AUTHID CURRENT_USER AS
2 /* $Header: POXNEG2S.pls 115.5 2004/02/26 18:00:07 zxzhang ship $*/
3
4 /*============================================================================
5 Name: Req_Change_workflow_startup
6 DESC: notifications to sourcing professional when req details are changed
7 or cancelled
8 ==============================================================================*/
9
10 PROCEDURE req_change_workflow_startup(x_calling_program IN VARCHAR2,
11 x_negotiation_id IN NUMBER ,
12 x_negotiation_num IN VARCHAR2 ,
13 x_requisition_doc_id IN NUMBER,
14 x_process_id IN NUMBER DEFAULT NULL);
15
16
17 /*============================================================================
18 Name: Start_wf_process
19 DESC: notifications to sourcing professional when req details are changed
20 or cancelled procedure to start the wf
21 ==============================================================================*/
22
23 PROCEDURE Start_WF_Process ( ItemType IN VARCHAR2,
24 ItemKey IN VARCHAR2,
25 WorkflowProcess IN VARCHAR2,
26 Source IN VARCHAR2,
27 DocumentId IN NUMBER,
28 NegotiationNum IN VARCHAR2,
29 OwnerName IN VARCHAR2,
30 ProcessId IN NUMBER);
31
32 /*============================================================================
33 Procedure to build the message body
34 input parameters :
35 - document id
36 - display type taken from workflow preferences
37 output
38 - the plsql document containing the message body
39 - the type of the message attribute
40 ==============================================================================*/
41 PROCEDURE get_req_line_details(document_id in varchar2,
42 display_type in Varchar2,
43 document in out NOCOPY clob,
44 document_type in out NOCOPY varchar2);
45
46 -- Bug 3346038, Should use PLSQLCLOB
47 /*============================================================================
48 Procedure to build the message body when called from MRP reschedule
49 input parameters :
50 - document id
51 - display type taken from workflow preferences
52 output
53 - the plsql document containing the message body
54 - the type of the message attribute
55 ==============================================================================*/
56 PROCEDURE get_req_line_details_mrp_wd(document_id in varchar2,
57 display_type in Varchar2,
58 document in out NOCOPY clob,
59 document_type in out NOCOPY varchar2);
60
61 /*============================================================================
62 Procedure to build the message body when called from MRP reschedule
63 input : wf item type,item key and the document id
64 ==============================================================================*/
65 PROCEDURE set_req_line_details_mrp_wd(itemtype in varchar2,
66 itemkey in varchar2,
67 x_document in out NOCOPY varchar2) ;
68
69
70 /*============================================================================
71 Wrapper to group the requisition lines by negotiation and call the WF
72 input parameters : control level - the place this wf is called from
73 document id : id corresponding to the level
74 (line/header/process id)
75 ==============================================================================*/
76 PROCEDURE call_negotiation_wf(x_control_level IN VARCHAR2,
77 x_document_id IN NUMBER);
78
79 /*============================================================================
80 Procedure tocheck where the wf is being called from so as to decide
81 the correct notification to be sent
82 input : wf item type,item key
83 output : source
84 ==============================================================================*/
85 procedure Check_Source( itemtype in varchar2,
86 itemkey in varchar2,
87 actid in number,
88 funcmode in varchar2,
89 resultout out NOCOPY varchar2 ) ;
90
91
92 END po_negotiation_req_notif;
93