1 PACKAGE IA_WF_REQUEST_PKG AS
2 /* $Header: IAWFREQS.pls 120.0 2005/06/03 23:59:23 appldev noship $ */
3
4 -- PROCEDURE Start_Process(p_request_id in number);
5 FUNCTION Start_Process(p_request_id in number) return NUMBER;
6
7 FUNCTION Abort_Process(p_request_id in number) return NUMBER;
8
9 PROCEDURE Get_Next_Approver
10 (itemtype in varchar2
11 ,itemkey in varchar2
12 ,actid in number
13 ,funcmode in varchar2
14 ,result out nocopy varchar2);
15
16 PROCEDURE Check_Approval_Type
17 (itemtype in varchar2
18 ,itemkey in varchar2
19 ,actid in number
20 ,funcmode in varchar2
21 ,result out nocopy varchar2);
22
23 /*
24 PROCEDURE Insert_Next_Approver
25 (itemtype in varchar2
26 ,itemkey in varchar2
27 ,actid in number
28 ,funcmode in varchar2
29 ,result out nocopy varchar2);
30 */
31
32 PROCEDURE Set_Role(p_role_name in varchar2);
33
34 /*
35 FUNCTION Respond
36 (p_request_id in number
37 ,p_result in varchar2
38 ,p_delegatee_id in number
39 ,p_comment in varchar2) return NUMBER;
40 */
41
42 /*
43 PROCEDURE Insert_Approval
44 (p_request_id in number
45 ,p_approver_id in number
46 ,p_approval_status in varchar2
47 ,p_approval_id out nocopy number
48 );
49 */
50
51 /*
52 PROCEDURE Update_Approval_Status
53 (p_approval_id in number
54 ,p_chain_phase in varchar2
55 ,p_approval_status in varchar2
56 );
57 */
58
59 PROCEDURE Update_ApprovalStatus_To_Final
60 (itemtype in varchar2
61 ,itemkey in varchar2
62 ,actid in number
63 ,funcmode in varchar2
64 ,result out nocopy varchar2);
65
66 PROCEDURE Send_Response_Notification
67 (itemtype in varchar2
68 ,itemkey in varchar2
69 ,actid in number
70 ,funcmode in varchar2
71 ,result out nocopy varchar2);
72
73 PROCEDURE Process_Approved
74 (itemtype in varchar2
75 ,itemkey in varchar2
76 ,actid in number
77 ,funcmode in varchar2
78 ,result out nocopy varchar2);
79
80 PROCEDURE Process_Delegated
81 (itemtype in varchar2
82 ,itemkey in varchar2
83 ,actid in number
84 ,funcmode in varchar2
85 ,result out nocopy varchar2);
86
87 PROCEDURE Process_Rejected
88 (itemtype in varchar2
89 ,itemkey in varchar2
90 ,actid in number
91 ,funcmode in varchar2
92 ,result out nocopy varchar2);
93
94 PROCEDURE Process_Cancelled
95 (itemtype in varchar2
96 ,itemkey in varchar2
97 ,actid in number
98 ,funcmode in varchar2
99 ,result out nocopy varchar2);
100
101 PROCEDURE SuperUser_Approval_Required
102 (itemtype in varchar2
103 ,itemkey in varchar2
104 ,actid in number
105 ,funcmode in varchar2
106 ,result out nocopy varchar2);
107
108 PROCEDURE Update_LineStatus_To_OnReview
109 (itemtype in varchar2
110 ,itemkey in varchar2
111 ,actid in number
112 ,funcmode in varchar2
113 ,result out nocopy varchar2);
114
115 PROCEDURE Update_LineStatus_To_Post
116 (itemtype in varchar2
117 ,itemkey in varchar2
118 ,actid in number
119 ,funcmode in varchar2
120 ,result out nocopy varchar2);
121
122 END IA_WF_REQUEST_PKG;