1 Package hr_psf_bus as
2 /* $Header: hrpsfrhi.pkh 120.1 2006/06/01 09:54:40 grreddy ship $ */
3 --
4 --
5 g_debug boolean := hr_utility.debug_enabled;
6 --
7 --
8 -- ---------------------------------------------------------------------------
9 -- |----------------------< set_security_group_id >------------------------|
10 -- ---------------------------------------------------------------------------
11 --
12 --
13 procedure set_security_group_id
14 (
15 p_position_id in hr_positions.position_id%TYPE
16 );
17 --
18 -- ----------------------------------------------------------------------------
19 -- |---------------------------< insert_validate >----------------------------|
20 -- ----------------------------------------------------------------------------
21 -- {Start Of Comments}
22 --
23 -- Description:
24 -- This procedure controls the execution of all insert business rules
25 -- validation.
26 --
27 -- Prerequisites:
28 -- This private procedure is called from ins procedure.
29 --
30 -- In Parameters:
31 -- A Pl/Sql record structre.
32 --
33 -- Post Success:
34 -- Processing continues.
35 --
36 -- Post Failure:
37 -- If a business rules fails the error will not be handled by this procedure
38 -- unless explicity coded.
39 --
40 -- Developer Implementation Notes:
41 -- For insert, your business rules should be executed from this procedure and
42 -- should ideally (unless really necessary) just be straight procedure or
43 -- function calls. Try and avoid using conditional branching logic.
44 --
45 -- Access Status:
46 -- Internal Row Handler Use Only.
47 --
48 -- {End Of Comments}
49 -- ----------------------------------------------------------------------------
50 Procedure insert_validate
51 (p_rec in hr_psf_shd.g_rec_type,
52 p_effective_date in date,
53 p_datetrack_mode in varchar2,
54 p_validation_start_date in date,
55 p_validation_end_date in date);
56 --
57 -- ----------------------------------------------------------------------------
58 -- |---------------------------< update_validate >----------------------------|
59 -- ----------------------------------------------------------------------------
60 -- {Start Of Comments}
61 --
62 -- Description:
63 -- This procedure controls the execution of all update business rules
64 -- validation.
65 --
66 -- Prerequisites:
67 -- This private procedure is called from upd procedure.
68 --
69 -- In Parameters:
70 -- A Pl/Sql record structre.
71 --
72 -- Post Success:
73 -- Processing continues.
74 --
75 -- Post Failure:
76 -- If a business rules fails the error will not be handled by this procedure
77 -- unless explicity coded.
78 --
79 -- Developer Implementation Notes:
80 -- For update, your business rules should be executed from this procedure and
81 -- should ideally (unless really necessary) just be straight procedure or
82 -- function calls. Try and avoid using conditional branching logic.
83 --
84 -- Access Status:
85 -- Internal Row Handler Use Only.
86 --
87 -- {End Of Comments}
88 -- ----------------------------------------------------------------------------
89 Procedure update_validate
90 (p_rec in hr_psf_shd.g_rec_type,
91 p_effective_date in date,
92 p_datetrack_mode in varchar2,
93 p_validation_start_date in date,
94 p_validation_end_date in date);
95 --
96 -- ----------------------------------------------------------------------------
97 -- |---------------------------< delete_validate >----------------------------|
98 -- ----------------------------------------------------------------------------
99 -- {Start Of Comments}
100 --
101 -- Description:
102 -- This procedure controls the execution of all delete business rules
103 -- validation.
104 --
105 -- Prerequisites:
106 -- This private procedure is called from del procedure.
107 --
108 -- In Parameters:
109 -- A Pl/Sql record structre.
110 --
111 -- Post Success:
112 -- Processing continues.
113 --
114 -- Post Failure:
115 -- If a business rules fails the error will not be handled by this procedure
116 -- unless explicity coded.
117 --
118 -- Developer Implementation Notes:
119 -- For delete, your business rules should be executed from this procedure and
120 -- should ideally (unless really necessary) just be straight procedure or
121 -- function calls. Try and avoid using conditional branching logic.
122 --
123 -- Access Status:
124 -- Internal Row Handler Use Only.
125 --
126 -- {End Of Comments}
127 -- ----------------------------------------------------------------------------
128 Procedure delete_validate
129 (p_rec in hr_psf_shd.g_rec_type,
130 p_effective_date in date,
131 p_datetrack_mode in varchar2,
132 p_validation_start_date in date,
133 p_validation_end_date in date);
134 --
135 Function First_active_position_row(
136 p_position_id in number,
137 p_effective_start_date in date) return boolean ;
138 --
139 Function all_proposed_only_position(
140 p_position_id number )
141 return boolean ;
142
143 -- Bug 3199913 Start
144 procedure chk_ref_int_del(
145 p_position_id in varchar2
146 ,p_validation_start_date in date
147 ,p_validation_end_date in date
148 ,p_datetrack_mode in varchar2 );
149 -- Bug 3199913 End
150
151 -- -----------------------------------------------------------------------------
152 -- |-------------------------------< chk_ddf >---------------------------------|
153 -- -----------------------------------------------------------------------------
154 --
155 procedure chk_ddf
156 (p_rec in hr_psf_shd.g_rec_type);
157 --
158 -- -----------------------------------------------------------------------
159 -- |------------------------------< chk_df >-----------------------------|
160 -- -----------------------------------------------------------------------
161 --
162 -- Description:
163 -- Validates the all Descriptive Flexfield values.
164 --
165 -- Pre-conditions:
166 -- All other columns have been validated. Must be called as the
167 -- last step from insert_validate and update_validate.
168 --
169 -- In Arguments:
170 -- p_rec
171 --
172 -- Post Success:
173 -- If the Descriptive Flexfield structure column and data values are
174 -- all valid this procedure will end normally and processing will
175 -- continue.
176 --
177 -- Post Failure:
178 -- If the Descriptive Flexfield structure column value or any of
179 -- the data values are invalid then an application error is raised as
180 -- a PL/SQL exception.
181 --
182 -- Access Status:
183 -- Internal Row Handler Use Only.
184 --
185 procedure chk_df
186 (p_rec in hr_psf_shd.g_rec_type);
187 --
188 Procedure DE_Update_properties(
189 p_position_id in number,
190 p_effective_Start_Date in date,
191 p_updateable out nocopy boolean,
192 p_lower_limit out nocopy date,
193 p_upper_limit out nocopy date);
194 --
195 procedure chk_availability_status_id
196 (p_position_id in number
197 ,p_validation_start_date in date
198 ,p_availability_status_id in number
199 ,p_old_avail_status_id in number
200 ,p_business_group_id in number
201 ,p_date_effective in date default null
202 ,p_effective_date in date default null
203 ,p_object_version_number in number default 1
204 ,p_datetrack_mode in varchar2);
205 --
206 procedure chg_date_effective
207 (p_position_id in number
208 ,p_effective_start_date in date
209 ,p_effective_end_date in date
210 ,p_date_effective in date
211 ,p_new_date_effective out nocopy date
212 ,p_chg_date_effective out nocopy boolean
213 ,p_business_group_id in number
214 ,p_old_avail_status_id in number
215 ,p_availability_status_id in number
216 ,p_datetrack_mode in varchar2
217 );
218 --
219 Procedure chk_permanent_seasonal_flag
220 (p_position_id in number
221 ,p_permanent_temporary_flag in varchar2
222 ,p_seasonal_flag in varchar2
223 ,p_effective_date in date
224 ,p_object_version_number in number);
225 --
226 end hr_psf_bus;