[Home] [Help]
PACKAGE: APPS.AMW_WF_HIERARCHY_PKG
Source
1 PACKAGE AMW_WF_HIERARCHY_PKG as
2 /*$Header: amwwfhrs.pls 120.0 2005/05/31 21:02:44 appldev noship $*/
3
4 procedure write_amw_process (
5 p_process_name IN VARCHAR2,
6 p_SIGNIFICANT_PROCESS_FLAG IN VARCHAR2,
7 p_STANDARD_PROCESS_FLAG IN VARCHAR2,
8 p_APPROVAL_STATUS IN VARCHAR2,
9 p_CERTIFICATION_STATUS IN VARCHAR2,
10 p_PROCESS_OWNER_ID IN NUMBER,
11 p_PROCESS_CATEGORY IN VARCHAR2,
12 p_APPLICATION_OWNER_ID IN NUMBER,
13 p_FINANCE_OWNER_ID IN NUMBER,
14 p_commit in varchar2 := FND_API.G_FALSE,
15 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
16 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
17 x_return_status out nocopy varchar2,
18 x_msg_count out nocopy number,
19 x_msg_data out nocopy varchar2
20 );
21
22 procedure find_hierarchy_children(p_process_name in varchar2);
23 procedure find_hierarchy_parent(p_process_name in varchar2);
24
25 procedure synch_hierarchy_amw_process( x_return_status out nocopy varchar2,
26 x_msg_count out nocopy number,
27 x_msg_data out nocopy varchar2);
28
29 procedure adhoc_synch_hier_amw_proc ( x_return_status out nocopy varchar2,
30 x_msg_count out nocopy number,
31 x_msg_data out nocopy varchar2);
32
33 /*
34 procedure synch_hierarchy_amw_process(errbuf OUT NOCOPY VARCHAR2,
35 retcode OUT NOCOPY NUMBER);
36 */
37 function find_transition_order(p_instance_id in number) return number;
38 procedure find_transition_children(p_instance_id in number);
39
40 procedure reset_process_risk_ctrl_count;
41 procedure reset_proc_org_risk_ctrl_count;
42 procedure reset_proc_org_risk_ctrl_count( p_org_id IN NUMBER);
43
44 procedure find_org_hierarchy_parent(p_org_id in number, p_process_id in number);
45 procedure find_org_hierarchy_children(p_org_id in number, p_process_id in number);
46
47 procedure populate_flatlist(p_org_id in number);
48
49 procedure create_org_relations( p_process_name in varchar2,
50 p_org_id in number,
51 x_return_status out nocopy varchar2,
52 x_msg_count out nocopy number,
53 x_msg_data out nocopy varchar2);
54
55 procedure assoc_process_org_hier(
56 p_process_id in Number,
57 p_org_id in Number,
58 p_parent_process_id in Number,
59 x_return_status out nocopy varchar2,
60 x_msg_count out nocopy number,
61 x_msg_data out nocopy varchar2);
62
63 procedure assoc_process_rcm_org_hier(
64 p_process_id in Number,
65 p_org_id in Number,
66 p_rcm_assoc in varchar2 := 'N',
67 p_batch_id in number := null,
68 p_rcm_org_intf_id in number := null,
69 p_risk_id in number := null,
70 p_control_id in number := null,
71 p_parent_process_id in Number,
72 x_return_status out nocopy varchar2,
73 x_msg_count out nocopy number,
74 x_msg_data out nocopy varchar2);
75
76 --procedure associate_org_process
77 procedure associate_org_process(
78 p_process_id in number,
79 p_org_id in number,
80 p_commit in varchar2 := FND_API.G_FALSE,
81 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
82 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
83 x_return_status out nocopy varchar2,
84 x_msg_count out nocopy number,
85 x_msg_data out nocopy varchar2);
86
87 --npanandi 10/18/2004: commenting out the signature of below procedure due to
88 --error during RCMOrg association
89 --syncing code between main and branch lines
90 --bugfix for bug 3841334
91 /*
92 procedure associate_org_process(
93 p_process_id in number,
94 p_org_id in number,
95 p_rcm_assoc in varchar2 := 'N',
96 p_batch_id in number := null,
97 p_rcm_org_intf_id in number := null,
98 p_risk_id in number := null,
99 p_control_id in number := null,
100 p_commit in varchar2 := FND_API.G_FALSE,
101 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
102 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
103 x_return_status out nocopy varchar2,
104 x_msg_count out nocopy number,
105 x_msg_data out nocopy varchar2);
106 --npanandi ends above
107 */
108
109 procedure delete_org_relation(
110 p_parent_process_id in number,
111 p_child_process_id in number,
112 p_org_id in number);
113
114 procedure disassociate_process_org(
115 p_process_id in number,
116 p_org_id in number,
117 p_commit in varchar2 := FND_API.G_FALSE,
118 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
119 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
120 x_return_status out nocopy varchar2,
121 x_msg_count out nocopy number,
122 x_msg_data out nocopy varchar2);
123
124 procedure disassoc_proc_org_hier(p_process_id in number, p_org_id in number);
125
126 procedure modify_org_relation (
127 p_mode in varchar2,
128 p_parent_process_id in number,
129 p_child_process_id in number,
130 p_org_id in number,
131 p_exception_yes in varchar2,
132 p_process_owner_party_id in number,
133 p_commit in varchar2 := FND_API.G_FALSE,
134 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
135 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
136 x_return_status out nocopy varchar2,
137 x_msg_count out nocopy number,
138 x_msg_data out nocopy varchar2);
139
140 procedure populate_proc_flatlist;
141 procedure reset_org_count;
142
143
144
145 -- KOSRINIV -begin :- Concurrent programs for count synching
146 -- wrapper for synch_hierarchy_amw_process
147 PROCEDURE sync_hier_amw_process_wrap (
148 errbuf out nocopy varchar2,
149 retcode out nocopy varchar2 );
150
151 -- wrapper for reset_process_risk_ctrl_count
152 PROCEDURE reset_process_risk_ctrl_wrap(
153 errbuf out nocopy varchar2,
154 retcode out nocopy varchar2 );
155
156
157 procedure reset_proc_org_risk_ctrl_wrap(
158 errbuf out nocopy varchar2,
159 retcode out nocopy varchar2,
160 p_org_id in number);
161
162 --kosriniv end
163
164 procedure refresh_process_org (
165 p_process_id in number,
166 p_org_id in number,
167 p_commit in varchar2 := FND_API.G_FALSE,
168 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
169 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
170 x_return_status out nocopy varchar2,
171 x_msg_count out nocopy number,
172 x_msg_data out nocopy varchar2
173 );
174
175
176 procedure refresh_process_org (
177 p_process_id in number,
178 p_org_string in varchar,
179 p_commit in varchar2 := FND_API.G_FALSE,
180 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
181 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
182 x_return_status out nocopy varchar2,
183 x_msg_count out nocopy number,
184 x_msg_data out nocopy varchar2
185 );
186
187
188 procedure refresh_process_per_org(
189 p_process_id in number,
190 p_org_id in number,
191 x_return_status out nocopy varchar2,
192 x_msg_count out nocopy number,
193 x_msg_data out nocopy varchar2
194 );
195
196
197 function check_org_children_exist(p_process_id in number) return number;
198
199 procedure check_org_exist( p_process_id in number,
200 p_out out nocopy number,
201 x_return_status out nocopy varchar2,
202 x_msg_count out nocopy number,
203 x_msg_data out nocopy varchar2);
204
205 procedure check_cert_exist( p_process_id in number,
206 p_out out nocopy number,
207 x_return_status out nocopy varchar2,
208 x_msg_count out nocopy number,
209 x_msg_data out nocopy varchar2);
210
211 procedure check_cert_exist( p_process_id in number,
212 p_out out nocopy number,
213 p_org_id in number,
214 x_return_status out nocopy varchar2,
215 x_msg_count out nocopy number,
216 x_msg_data out nocopy varchar2);
217
218 procedure check_org_cert_exist( p_process_id in number,
219 p_check out nocopy number,
220 x_return_status out nocopy varchar2,
221 x_msg_count out nocopy number,
222 x_msg_data out nocopy varchar2);
223
224 function check_org_user_permission(org_id in number) return number;
225 function isProcessOwner(p_user_id in number, p_org_id in number) return number;
226 function hasOrgAccess(p_user_id in number, p_org_id in number) return number;
227 function checkOrgHier(p_emp_id in number, p_org_id in number) return number;
228
229 amw_deadlock_detected EXCEPTION;
230
231
232 deadlock_detected EXCEPTION;
233 PRAGMA EXCEPTION_INIT(deadlock_detected, -60);
234
235 -- abb added
236 procedure find_amwp_hierarchy_parent(p_process_id in number);
237 -- abb added
238 procedure find_amwp_hierarchy_children(p_process_id in number);
239
240 procedure old_synch_hier_amw_process( x_return_status out nocopy varchar2,
241 x_msg_count out nocopy number,
242 x_msg_data out nocopy varchar2);
243
244 end AMW_WF_HIERARCHY_PKG;