1 PACKAGE PER_HRWF_SYNCH AUTHID CURRENT_USER AS
2 /* $Header: perhrwfs.pkh 120.0.12020000.3 2013/05/10 12:58:38 pathota ship $ */
3 --
4 --
5 --
6 --
7 -- ----------------------------------------------------------------------------
8 -- |------------------------------< call_back >-------------------------------|
9 -- ----------------------------------------------------------------------------
10 --
11 -- {Start Of Comments}
12 --
13 -- Description:
14 -- This is a callbackable routine from WF_EVENT. This procedure calls
15 -- the routines WF_LOCAL_SYNCH.propagate_user and propagate_user_role.
16 -- WF_EVENT.call_me_later defferrs calling this procedure until the future
17 -- dated transactions' effective start date equals sysdate.
18 --
19 --
20 -- Pre Conditions:
21 -- Start date must equal sysdate.
22 --
23 -- In Arguments:
24 -- wf_parameter_list_t type varry.
25 --
26 -- Post Success:
27 -- Processing continues.
28 -- This procedure calls the routines WF_LOCAL_SYNCH.propagate_user
29 -- or WF_LOCAL_SYNCH.propagate_user_role, whichever is appropriate.
30 --
31 -- Post Failure:
32 -- No specific error handling is required within this procedure.
33 --
34 -- Access Status:
35 -- Internal Table Handler Use Only.
36 --
37 -- {End Of Comments}
38 -- ----------------------------------------------------------------------------
39 --
40 --
41 procedure call_back
42 (p_parameters in wf_parameter_list_t default null);
43 --
44 --
45 -- ----------------------------------------------------------------------------
46 -- |--------------------------< chk_date_status >-----------------------------|
47 -- ----------------------------------------------------------------------------
48 --
49 -- {Start Of Comments}
50 --
51 -- Description:
52 --
53 -- This function will return the status of the dates provided, where
54 -- the dates fall with respect to the sysdate. Possible options are
55 -- CURRENT, FUTURE or PAST.
56 --
57 -- Pre Conditions:
58 -- None.
59 --
60 -- In Arguments:
61 -- Two dates (start date and end date).
62 --
63 -- Post Success:
64 -- Processing continues.
65 -- This function returns one of the value CURRENT, FUTURE or PAST.
66 --
67 -- Post Failure:
68 -- None.
69 --
70 -- Access Status:
71 -- Internal Table Handler Use Only.
72 --
73 -- {End Of Comments}
74 -- ----------------------------------------------------------------------------
75 function chk_date_status
76 (p_start_date in date,
77 p_end_date in date) return varchar2;
78 --
79 --
80 -- ----------------------------------------------------------------------------
81 -- |-----------------------------< per_per_wf >-------------------------------|
82 -- ----------------------------------------------------------------------------
83 --
84 -- {Start Of Comments}
85 --
86 -- Description:
87 --
88 -- This procedure calls the appropriate routines, depending on the status of the
89 -- effective dates.
90 --
91 -- Pre Conditions:
92 -- None.
93 --
94 -- In Arguments:
95 -- per_all_people_f%rowtype and p_action(INSERT, DELETE, UPDATE).
96 --
97 -- Post Success:
98 -- Processing continues.
99 -- If the status is CURRENT then the routine WF_LOCAL_SYNCH.propagate_user
100 -- is called. If the status is FUTURE then WF_EVENT. call_me_later is called.
101 --
102 -- Post Failure:
103 -- None.
104 --
105 -- Access Status:
106 -- Internal Table Handler Use Only.
107 --
108 -- {End Of Comments}
109 -- ----------------------------------------------------------------------------
110 procedure per_per_wf(
111 p_rec in per_all_people_f%rowtype,
112 p_action in varchar2);
113 --
114 --
115 -- ----------------------------------------------------------------------------
116 -- |-----------------------------< per_asg_wf >-------------------------------|
117 -- ----------------------------------------------------------------------------
118 --
119 -- {Start Of Comments}
120 --
121 -- Description:
122 --
123 -- This procedure calls the appropriate routines, depending on the status of the
124 -- effective dates.
125 --
126 -- Pre Conditions:
127 -- None.
128 --
129 -- In Arguments:
130 -- per_all_assignments_f%rowtype and p_action(INSERT, DELETE, UPDATE).
131 --
132 -- Post Success:
133 -- Processing continues.
134 -- If the status is CURRENT then the routine WF_LOCAL_SYNCH.propagate_user_role
135 -- is called. If the status is FUTURE then WF_EVENT. call_me_later is called.
136 --
137 -- Post Failure:
138 -- None.
139 --
140 -- Access Status:
141 -- Internal Table Handler Use Only.
142 --
143 -- {End Of Comments}
144 -- ----------------------------------------------------------------------------
145
146 procedure per_asg_wf(
147 p_rec in per_all_assignments_f%rowtype,
148 p_action in varchar2);
149 --
150 --
151 -- ----------------------------------------------------------------------------
152 -- |-----------------------------< per_pds_wf >-------------------------------|
153 -- ----------------------------------------------------------------------------
154 --
155 -- {Start Of Comments}
156 --
157 -- Description:
158 --
159 -- This procedure calls the WF_LOCAL_SYNCGH.propagate_user routine.
160 --
161 -- Pre Conditions:
162 -- None.
163 --
164 -- In Arguments:
165 -- per_periods_of_service%rowtype and p_action(TERMINATION, REVERSE TERMINATION).
166 --
167 -- Post Success:
168 -- Processing continues.
169 -- If the status is CURRENT then the routine WF_LOCAL_SYNCH.propagate_user
170 -- is called. If the status is FUTURE then WF_EVENT. call_me_later is called.
171 --
172 -- Post Failure:
173 -- None.
174 --
175 -- Access Status:
176 -- Internal Table Handler Use Only.
177 --
178 -- {End Of Comments}
179 -- ----------------------------------------------------------------------------
180 procedure per_pds_wf(
181 p_rec in per_periods_of_service%rowtype,
182 p_date in date default null,
183 p_action in varchar2);
184 --
185 -- --------------------------------------------------------------------------
186 -- |-----------------------------< per_per_wf >-----------------------------|
187 -- --------------------------------------------------------------------------
188 --
189 -- {Start Of Comments}
190 --
191 -- Description:
192 --
193 -- This overloaded procedure is just to overcome the %rowtype issues
194 -- in forms. This will be directly called from the form and
195 -- this procedure will be inturn calling the actual procedure
196 --
197 -- Pre Conditions:
198 -- None.
199 --
200 -- In Arguments:
201 -- p_rec per_per_shd.g_rec_type
202 -- p_action(INSERT, DELETE, UPDATE).
203 --
204 -- Post Success:
205 -- Processing continues.
206 --
207 -- Post Failure:
208 -- None.
209 --
210 -- Access Status:
211 -- Internal Table Handler Use Only.
212 --
213 -- {End Of Comments}
214 -- --------------------------------------------------------------------------
215 procedure per_per_wf(
216 p_rec in per_per_shd.g_rec_type,
217 p_action in varchar2);
218 --
219 -- --------------------------------------------------------------------------
223 -- {Start Of Comments}
220 -- |-----------------------------< per_pds_wf >-----------------------------|
221 -- --------------------------------------------------------------------------
222 --
224 --
225 -- Description:
226 --
227 -- This overloaded procedure is just to overcome the %rowtype issues
228 -- in forms. This will be directly called from the form and
229 -- this procedure will be inturn calling the actual procedure
230 --
231 -- Pre Conditions:
232 -- None.
233 --
234 -- In Arguments:
235 -- p_person_id
236 -- p_date
237 -- p_date_start Start date of the period of employment
238 -- p_action(TERMINATION, REVERSE TERMINATION)
239 --
240 -- Post Success:
241 -- Processing continues.
242 --
243 -- Post Failure:
244 -- None.
245 --
246 -- Access Status:
247 -- Internal Table Handler Use Only.
248 --
249 -- {End Of Comments}
250 -- ----------------------------------------------------------------------------
251 procedure per_pds_wf(
252 p_person_id in number,
253 p_date in date default null,
254 p_date_start in date,
255 p_action in varchar2);
256 --
257
258 Type srch_criteria_record is RECORD
259 (p_person_id per_all_people_f.person_id%type default null,
260 p_assignment_id per_all_assignments_f.assignment_id%type default null,
261 p_effective_start_date per_all_assignments_f.effective_start_date%type default null,
262 p_effective_end_date per_all_assignments_f.effective_end_date%type default null,
263 p_position_id per_all_assignments_f.position_id%type default null);
264
265
266 Type srch_criteria is table of srch_criteria_record INDEX BY BINARY_INTEGER;
267
268 procedure sych_user_pos_role (p_in_user_name in fnd_user.user_name%type,
269 p_in_person_id in per_all_people_f.person_id%type,
270 p_in_start_date in fnd_user.start_date%type,
271 p_in_exp_date in fnd_user.end_date%type) ;
272
273 --
274 end per_hrwf_synch;