1 PACKAGE ams_gen_approval_pvt AUTHID CURRENT_USER as
2 /* $Header: amsvgaps.pls 115.16 2003/10/30 10:16:18 vmodur ship $ */
3 --
4 -- Procedure
5 -- Check_Line_Further_Approval
6 --
7 -- Workflow cover: Check if line needs further approvals
8 -- IN
9 -- itemtype - A valid item type from (WF_ITEM_TYPES table).
10 -- itemkey - A string generated from the application object's primary key.
11 -- actid - The function activity(instance id).
12 -- funcmode - Run/Cancel/Timeout
13 -- OUT
14 -- Resultout - 'COMPLETE:Y' If line needs further approvals
15 -- - 'COMPLETE:N' If line does not need further approvals
16 --
17 -- USED BY ACTIVITIES
18 -- <ITEM_TYPE> <ACTIVITY>
19 -- AMS_APPROVAL_PVT AMS_GET_APPROVER_DETAILS
20 --
21
22 Type ObjRecTyp is RECORD
23 ( name VARCHAR2(240),
24 business_unit_id NUMBER(15),
25 country_code VARCHAR2(30),
26 setup_type_id NUMBER,
27 total_header_amount NUMBER,
28 org_id NUMBER,
29 object_type VARCHAR2(30),
30 priority VARCHAR2(30),
31 start_date DATE,
32 end_date DATE,
33 purpose VARCHAR2(30),
34 description VARCHAR2(4000),
35 owner_id NUMBER,
36 currency varchar2(10) ,
37 priority_desc varchar2(80)
38 );
39
40 ---------------------------------------------------------------------------------
41
42 PROCEDURE Check_Process_Type( itemtype in varchar2,
43 itemkey in varchar2,
44 actid in number,
45 funcmode in varchar2,
46 resultout OUT NOCOPY varchar2 );
47 --------------------------------------------------------------------------------
48 --
49 -- NAME
50 -- StartProcess
51 --
52 -- PURPOSE
53 -- This Procedure will Start the flow for the Approval Process
54 --
55 --
56 -- IN
57 -- p_approval_for IN Approval for Object (i.e. CAMP/EVEH,...)
58 -- p_approval_for_id IN Approval for Objectid (i.e. CAMP_id,...)
59 -- p_object_version_number IN Object Version Number
60 -- p_orig_stat_id IN Original User Status Id(e.g. id for 'NEW')
61 -- p_new_stat_id IN New User Status Id(e.g. id for 'AVAILABLE')
62 -- p_requester_userid IN Userid
63 -- p_workflowprocess IN WF Process Name (Default Null)
64 -- p_item_type IN WF Item type(Default Null)
65 -- OUT
66 --
67 -- Used By Activities
68 --
69 -- NOTES
70 -- HISTORY
71 -- End of Comments
72 PROCEDURE StartProcess
73 (p_activity_type IN VARCHAR2,
74 p_activity_id IN NUMBER,
75 p_approval_type IN VARCHAR2,
76 p_object_version_number IN NUMBER,
77 p_orig_stat_id IN NUMBER,
78 p_new_stat_id IN NUMBER,
79 p_reject_stat_id IN NUMBER,
80 p_requester_userid IN NUMBER,
81 p_notes_from_requester IN VARCHAR2 DEFAULT NULL,
82 p_workflowprocess IN VARCHAR2 DEFAULT NULL,
83 p_item_type IN VARCHAR2 DEFAULT NULL,
84 p_gen_process_flag IN VARCHAR2 DEFAULT NULL
85 );
86
87 PROCEDURE Set_Activity_Details(itemtype IN VARCHAR2,
88 itemkey IN VARCHAR2,
89 actid IN NUMBER,
90 funcmode IN VARCHAR2,
91 resultout OUT NOCOPY VARCHAR2);
92
93 PROCEDURE Revert_Status( itemtype in varchar2,
94 itemkey in varchar2,
95 actid in number,
96 funcmode in varchar2,
97 resultout OUT NOCOPY varchar2);
98
99
100 PROCEDURE Prepare_Doc( itemtype in varchar2,
101 itemkey in varchar2,
102 actid in number,
103 funcmode in varchar2,
104 resultout OUT NOCOPY varchar2 );
105
106 PROCEDURE Set_Approver_Details( itemtype in varchar2,
107 itemkey in varchar2,
108 actid in number,
109 funcmode in varchar2,
110 resultout OUT NOCOPY varchar2 );
111
112 PROCEDURE Set_Further_Approvals( itemtype in varchar2,
113 itemkey in varchar2,
114 actid in number,
115 funcmode in varchar2,
116 resultout OUT NOCOPY varchar2 );
117
118 PROCEDURE Get_Approval_Details
119 ( p_activity_id IN NUMBER,
120 p_activity_type IN VARCHAR2,
121 p_approval_type IN VARCHAR2 DEFAULT 'BUDGET',
122 -- p_act_budget_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
123 p_object_details IN ObjRecTyp,
124 x_approval_detail_id OUT NOCOPY NUMBER,
125 x_approver_seq OUT NOCOPY NUMBER,
126 x_return_status OUT NOCOPY VARCHAR2);
127 /*****************************************************************
128 -- Start of Comments
129 --
130 -- NAME
131 -- AbortProcess
132 --
133 -- PURPOSE
134 -- This Procedure will abort the process of Approvals
135 --
136 -- Used By Activities
137 --
138 -- NOTES
139 --
140 --
141 -- HISTORY
142 -- End of Comments
143 *****************************************************************/
144
145 PROCEDURE AbortProcess
146 (p_itemkey IN VARCHAR2
147 ,p_workflowprocess IN VARCHAR2 DEFAULT NULL
148 ,p_itemtype IN VARCHAR2 DEFAULT NULL
149 );
150
151 PROCEDURE Get_Api_Name( p_rule_used_by in varchar2,
152 p_rule_used_by_type in varchar2,
153 p_rule_type in VARCHAR2,
154 p_appr_type in VARCHAR2,
155 x_pkg_name OUT NOCOPY varchar2,
156 x_proc_name OUT NOCOPY varchar2,
157 x_return_stat OUT NOCOPY varchar2);
158
159 PROCEDURE Ntf_Approval(document_id in varchar2,
160 display_type in varchar2,
161 document in OUT NOCOPY varchar2,
162 document_type in OUT NOCOPY varchar2);
163
164 PROCEDURE Ntf_Approval_reminder(document_id in varchar2,
165 display_type in varchar2,
166 document in OUT NOCOPY varchar2,
167 document_type in OUT NOCOPY varchar2);
168
169 PROCEDURE Ntf_Forward_FYI( document_id in varchar2,
170 display_type in varchar2,
171 document in OUT NOCOPY varchar2,
172 document_type in OUT NOCOPY varchar2);
173
174 PROCEDURE Ntf_Approved_FYI(document_id in varchar2,
175 display_type in varchar2,
176 document in OUT NOCOPY varchar2,
177 document_type in OUT NOCOPY varchar2);
178
179 PROCEDURE Ntf_Rejected_FYI(document_id in varchar2,
180 display_type in varchar2,
181 document in OUT NOCOPY varchar2,
182 document_type in OUT NOCOPY varchar2);
183
184 PROCEDURE Ntf_Requestor_Of_Error(document_id in varchar2,
185 display_type in varchar2,
186 document in OUT NOCOPY varchar2,
187 document_type in OUT NOCOPY varchar2);
188
189 PROCEDURE Update_Status(itemtype IN varchar2,
190 itemkey IN varchar2,
191 actid in number,
192 funcmode in varchar2,
193 resultout OUT NOCOPY varchar2);
194
195 PROCEDURE Reject_Update_Status(itemtype IN varchar2,
196 itemkey IN varchar2,
197 actid in number,
198 funcmode in varchar2,
199 resultout OUT NOCOPY varchar2);
200
201 PROCEDURE Approved_Update_Status(itemtype IN varchar2,
202 itemkey IN varchar2,
203 actid in number,
204 funcmode in varchar2,
205 resultout OUT NOCOPY varchar2 );
206
207 PROCEDURE DynTst(itemtype IN varchar2
208 ,itemkey IN varchar2
209 ,resultout OUT NOCOPY varchar2);
210
211 PROCEDURE DynTst1(itemtype IN varchar2
212 ,itemkey IN varchar2
213 -- ,resultout out varchar2
214 );
215
216 PROCEDURE Get_approver_Info
217 ( p_approval_detail_id IN NUMBER,
218 p_current_seq IN NUMBER,
219 x_approver_id OUT NOCOPY VARCHAR2,
220 x_approver_type OUT NOCOPY VARCHAR2,
221 x_role_name OUT NOCOPY VARCHAR2,
222 x_object_approver_id OUT NOCOPY VARCHAR2,
223 x_notification_type OUT NOCOPY VARCHAR2,
224 x_notification_timeout OUT NOCOPY VARCHAR2,
225 x_return_status OUT NOCOPY VARCHAR2);
226
227 PROCEDURE Handle_Err
228 (p_itemtype IN VARCHAR2 ,
229 p_itemkey IN VARCHAR2 ,
230 p_msg_count IN NUMBER , -- Number of error Messages
231 p_msg_data IN VARCHAR2 ,
232 p_attr_name IN VARCHAR2,
233 x_error_msg OUT NOCOPY VARCHAR2
234 );
235
236 PROCEDURE Approval_Required(itemtype IN VARCHAR2,
237 itemkey IN VARCHAR2,
238 actid IN NUMBER,
239 funcmode IN VARCHAR2,
240 resultout OUT NOCOPY VARCHAR2);
241 -- Added for 11.5.9
242 PROCEDURE Get_Approval_Rule ( p_activity_id IN NUMBER,
243 p_activity_type IN VARCHAR2,
244 p_approval_type IN VARCHAR2,
245 p_act_budget_id IN NUMBER,
246 x_approval_detail_id OUT NOCOPY NUMBER,
247 x_return_status OUT NOCOPY VARCHAR2);
248
249 PROCEDURE PostNotif_Update (itemtype IN VARCHAR2,
250 itemkey IN VARCHAR2,
251 actid IN NUMBER,
252 funcmode IN VARCHAR2,
253 resultout OUT NOCOPY VARCHAR2);
254
255 END ams_gen_approval_pvt;