[Home] [Help]
PACKAGE: APPS.ZPB_DC_WF
Source
1 PACKAGE ZPB_DC_WF AS
2 /* $Header: ZPBDCWFS.pls 120.3 2007/12/04 14:34:45 mbhat ship $ */
3
4 TYPE aw_user_tab IS TABLE OF NUMBER(15);
5
6 PROCEDURE generate_template(
7 itemtype IN varchar2,
8 itemkey IN varchar2,
9 actid IN number,
10 funcmode IN varchar2,
11 resultout OUT nocopy varchar2
12 );
13
14 PROCEDURE get_review_option(
15 itemtype IN varchar2,
16 itemkey IN varchar2,
17 actid IN number,
18 funcmode IN varchar2,
19 resultout OUT nocopy varchar2
20 );
21
22 PROCEDURE auto_distribute(
23 itemtype IN varchar2,
24 itemkey IN varchar2,
25 actid IN number,
26 funcmode IN varchar2,
27 resultout OUT nocopy varchar2
28 );
29
30 PROCEDURE manual_distribute(
31 itemtype IN varchar2,
32 itemkey IN varchar2,
33 actid IN number,
34 funcmode IN varchar2,
35 resultout OUT nocopy varchar2
36 );
37
38 PROCEDURE raise_distribution_event(
39 p_api_version IN NUMBER,
40 p_init_msg_list IN VARCHAR2,
41 p_commit IN VARCHAR2,
42 p_validation_level IN NUMBER,
43 x_return_status OUT NOCOPY VARCHAR2,
44 x_msg_count OUT NOCOPY NUMBER,
45 x_msg_data OUT NOCOPY VARCHAR2,
46 --
47 p_object_id IN number,
48 p_recipient_type IN varchar2,
49 p_dist_list_id IN number,
50 p_approver_type IN varchar2,
51 p_deadline_date IN varchar2,
52 p_overwrite_cust IN varchar2,
53 p_overwrite_data IN varchar2,
54 p_distribution_message IN varchar2
55 );
56
57 PROCEDURE set_ws_recipient(
58 itemtype IN varchar2,
59 itemkey IN varchar2,
60 actid IN number,
61 funcmode IN varchar2,
62 resultout OUT nocopy varchar2
63 );
64
65 PROCEDURE review_complete(
66 itemtype IN varchar2,
67 itemkey IN varchar2,
68 actid IN number,
69 funcmode IN varchar2,
70 resultout OUT nocopy varchar2
71 );
72
73 PROCEDURE get_template_count(
74 itemtype IN varchar2,
75 itemkey IN varchar2,
76 actid IN number,
77 funcmode IN varchar2,
78 resultout OUT nocopy varchar2
79 );
80
81 PROCEDURE manage_submission(
82 itemtype IN varchar2,
83 itemkey IN varchar2,
84 actid IN number,
85 funcmode IN varchar2,
86 resultout OUT nocopy varchar2
87 );
88
89 PROCEDURE set_template_recipient(
90 itemtype IN varchar2,
91 itemkey IN varchar2,
92 actid IN number,
93 funcmode IN varchar2,
94 resultout OUT nocopy varchar2
95 );
96
97 PROCEDURE set_template_status(
98 itemtype IN varchar2,
99 itemkey IN varchar2,
100 actid IN number,
101 funcmode IN varchar2,
102 resultout OUT nocopy varchar2
103 );
104
105 PROCEDURE check_template_status(
106 itemtype IN varchar2,
107 itemkey IN varchar2,
108 actid IN number,
109 funcmode IN varchar2,
110 resultout OUT nocopy varchar2
111 );
112
113 PROCEDURE raise_submission_event(
114 p_api_version IN NUMBER,
115 p_init_msg_list IN VARCHAR2,
116 p_commit IN VARCHAR2,
117 p_validation_level IN NUMBER,
118 x_return_status OUT NOCOPY VARCHAR2,
119 x_msg_count OUT NOCOPY NUMBER,
120 x_msg_data OUT NOCOPY VARCHAR2,
121 --
122 p_object_id IN number,
123 p_submission_message IN varchar2
124 );
125
126 PROCEDURE check_object_type(
127 itemtype IN varchar2,
128 itemkey IN varchar2,
129 actid IN number,
130 funcmode IN varchar2,
131 resultout OUT nocopy varchar2
132 );
133
134 PROCEDURE freeze_template(
135 itemtype IN varchar2,
136 itemkey IN varchar2,
137 actid IN number,
138 funcmode IN varchar2,
139 resultout OUT nocopy varchar2
140 );
141
142 PROCEDURE freeze_worksheet(
143 itemtype IN varchar2,
144 itemkey IN varchar2,
145 actid IN number,
146 funcmode IN varchar2,
147 resultout OUT nocopy varchar2
148 );
149
150 PROCEDURE find_approver(
151 itemtype IN varchar2,
152 itemkey IN varchar2,
153 actid IN number,
154 funcmode IN varchar2,
155 resultout OUT nocopy varchar2
156 );
157
158 PROCEDURE set_submit_ntf_recipients(
159 itemtype IN varchar2,
160 itemkey IN varchar2,
161 actid IN number,
162 funcmode IN varchar2,
163 resultout OUT nocopy varchar2
164 );
165
166 PROCEDURE update_aw(
167 itemtype IN varchar2,
168 itemkey IN varchar2,
169 actid IN number,
170 funcmode IN varchar2,
171 resultout OUT nocopy varchar2
172 );
173
174 PROCEDURE check_update_aw_type(
175 itemtype IN varchar2,
176 itemkey IN varchar2,
177 actid IN number,
178 funcmode IN varchar2,
179 resultout OUT nocopy varchar2
180 );
181
182 PROCEDURE raise_approval_event(
183 p_api_version IN NUMBER,
184 p_init_msg_list IN VARCHAR2,
185 p_commit IN VARCHAR2,
186 p_validation_level IN NUMBER,
187 x_return_status OUT NOCOPY VARCHAR2,
188 x_msg_count OUT NOCOPY NUMBER,
189 x_msg_data OUT NOCOPY VARCHAR2,
190 --
191 p_object_id IN number,
192 p_approver_user_id IN number,
193 p_approval_message IN varchar2
194 );
195
196 PROCEDURE raise_rejection_event(
197 p_api_version IN NUMBER,
198 p_init_msg_list IN VARCHAR2,
199 p_commit IN VARCHAR2,
200 p_validation_level IN NUMBER,
201 x_return_status OUT NOCOPY VARCHAR2,
202 x_msg_count OUT NOCOPY NUMBER,
203 x_msg_data OUT NOCOPY VARCHAR2,
204 --
205 p_object_id IN number,
206 p_approver_user_id IN number,
207 p_rejection_message IN varchar2
208 );
209
210 PROCEDURE set_worksheet_status(
211 itemtype IN varchar2,
212 itemkey IN varchar2,
213 actid IN number,
214 funcmode IN varchar2,
215 resultout OUT nocopy varchar2
216 );
217
218 PROCEDURE unblock_manage_submission(
219 itemtype IN varchar2,
220 itemkey IN varchar2,
221 actid IN number,
222 funcmode IN varchar2,
223 resultout OUT nocopy varchar2
224 );
225
226 PROCEDURE check_all_ws_submitted(
227 itemtype IN varchar2,
228 itemkey IN varchar2,
229 actid IN number,
230 funcmode IN varchar2,
231 resultout OUT nocopy varchar2
232 );
233
234 END ZPB_DC_WF;