1 Package pay_pay_bus as
2 /* $Header: pypayrhi.pkh 120.2 2007/09/10 12:32:13 ckesanap noship $ */
3 --
4 -- ---------------------------------------------------------------------------
5 -- |----------------------< set_security_group_id >--------------------------|
6 -- ---------------------------------------------------------------------------
7 -- {Start Of Comments}
8 --
9 -- Description:
10 -- Sets the security_group_id in CLIENT_INFO for the appropriate business
11 -- group context.
12 --
13 -- Prerequisites:
14 -- The primary key identified by p_payroll_id
15 -- already exists.
16 --
17 -- In Arguments:
18 -- p_payroll_id
19 --
20 --
21 -- Post Success:
22 -- The security_group_id will be set in CLIENT_INFO.
23 --
24 -- Post Failure:
25 -- An error is raised if the value does not exist.
26 --
27 -- Access Status:
28 -- Internal Development Use Only.
29 --
30 -- {End Of Comments}
31 -- ---------------------------------------------------------------------------
32 procedure set_security_group_id
33 (p_payroll_id in number
34 ,p_associated_column1 in varchar2 default null
35 );
36 --
37 --
38 -- ----------------------------------------------------------------------------
39 -- |----------------------< chk_keyflex_and_other_ids >-----------------------|
40 -- ----------------------------------------------------------------------------
41 --
42 -- Description
43 -- This procedure is to used for foreign key validation of -
44 -- cost_allocation_keyflex_id
45 -- suspense_account_keyflex_id
46 -- gl_set_of_books_id
47 -- soft_coding_keyflex_id
48 -- organization_id
49 -------------------------------------------------------------------------------
50 procedure chk_keyflex_and_other_ids
51 (
52 p_cost_allocation_keyflex_id in number default null
53 ,p_suspense_account_keyflex_id in number default null
54 ,p_gl_set_of_books_id in number default null
55 ,p_soft_coding_keyflex_id in number default null
56 ,p_organization_id in number default null
57 ,p_datetrack_mode in varchar2 default null
58 ) ;
59 --
60 --
61 -- ---------------------------------------------------------------------------
62 -- |--------------------< chk_consolidation_set_id >-------------------------|
63 -- ---------------------------------------------------------------------------
64 -- {Start Of Comments}
65 --
66 -- Description:
67 -- Check whether the consolidation set exists or not.
68 --
69 -- Prerequisites:
70 -- Consolidation should exist to succeed.
71 --
72 -- In Arguments:
73 -- p_consolidation_set_id
74 -- p_business_group_id
75 --
76 -- Post Success:
77 -- The process continues.
78 --
79 -- Post Failure:
80 -- An error is raised if the value does not exist.
81 --
82 -- Access Status:
83 -- Internal Development Use Only.
84 --
85 -- {End Of Comments}
86 -- ---------------------------------------------------------------------------
87 procedure chk_consolidation_set_id
88 (
89 p_consolidation_set_id in number,
90 p_business_group_id out nocopy number
91 );
92 -- ---------------------------------------------------------------------------
93 -- |---------------------< return_legislation_code >-------------------------|
94 -- ---------------------------------------------------------------------------
95 -- {Start Of Comments}
96 --
97 -- Description:
98 -- Return the legislation code for a specific primary key value
99 --
100 -- Prerequisites:
101 -- The primary key identified by p_payroll_id
102 -- already exists.
103 --
104 -- In Arguments:
105 -- p_payroll_id
106 --
107 --
108 -- Post Success:
109 -- The business group's legislation code will be returned.
110 --
111 -- Post Failure:
112 -- An error is raised if the value does not exist.
113 --
114 -- Access Status:
115 -- Internal Development Use Only.
116 --
117 -- {End Of Comments}
118 -- ---------------------------------------------------------------------------
119 FUNCTION return_legislation_code
120 (p_payroll_id in number
121 ) RETURN varchar2;
122 --
123 --
124 -- ----------------------------------------------------------------------------
125 -- |---------------------------< insert_validate >----------------------------|
126 -- ----------------------------------------------------------------------------
127 -- {Start Of Comments}
128 --
129 -- Description:
130 -- This procedure controls the execution of all insert business rules
131 -- validation.
132 --
133 -- Prerequisites:
134 -- This private procedure is called from ins procedure.
135 --
136 -- In Parameters:
137 -- A Pl/Sql record structre.
138 --
139 -- Post Success:
140 -- Processing continues.
141 --
142 -- Post Failure:
143 -- If a business rules fails the error will not be handled by this procedure
144 -- unless explicity coded.
145 --
146 -- Developer Implementation Notes:
147 -- For insert, your business rules should be executed from this procedure and
148 -- should ideally (unless really necessary) just be straight procedure or
149 -- function calls. Try and avoid using conditional branching logic.
150 --
151 -- Access Status:
152 -- Internal Row Handler Use Only.
153 --
154 -- {End Of Comments}
155 -- ----------------------------------------------------------------------------
156 Procedure insert_validate
157 (p_rec in out nocopy pay_pay_shd.g_rec_type --Added 'out nocopy'.
158 ,p_effective_date in date
159 ,p_datetrack_mode in varchar2
160 ,p_validation_start_date in date
161 ,p_validation_end_date in date
162 );
163 --
164 -- ----------------------------------------------------------------------------
165 -- |---------------------------< update_validate >----------------------------|
166 -- ----------------------------------------------------------------------------
167 -- {Start Of Comments}
168 --
169 -- Description:
170 -- This procedure controls the execution of all update business rules
171 -- validation.
172 --
173 -- Prerequisites:
174 -- This private procedure is called from upd procedure.
175 --
176 -- In Parameters:
177 -- A Pl/Sql record structre.
178 --
179 -- Post Success:
180 -- Processing continues.
181 --
182 -- Post Failure:
183 -- If a business rules fails the error will not be handled by this procedure
184 -- unless explicity coded.
185 --
186 -- Developer Implementation Notes:
187 -- For update, your business rules should be executed from this procedure and
188 -- should ideally (unless really necessary) just be straight procedure or
189 -- function calls. Try and avoid using conditional branching logic.
190 --
191 -- Access Status:
192 -- Internal Row Handler Use Only.
193 --
194 -- {End Of Comments}
195 -- ----------------------------------------------------------------------------
196 Procedure update_validate
197 (p_rec in out nocopy pay_pay_shd.g_rec_type --Added 'out nocopy' .
198 ,p_effective_date in date
199 ,p_datetrack_mode in varchar2
200 ,p_validation_start_date in date
201 ,p_validation_end_date in date
202 );
203 --
204 -- ----------------------------------------------------------------------------
205 -- |---------------------------< delete_validate >----------------------------|
206 -- ----------------------------------------------------------------------------
207 -- {Start Of Comments}
208 --
209 -- Description:
210 -- This procedure controls the execution of all delete business rules
211 -- validation.
212 --
213 -- Prerequisites:
214 -- This private procedure is called from del procedure.
215 --
216 -- In Parameters:
217 -- A Pl/Sql record structure.
218 --
219 -- Post Success:
220 -- Processing continues.
221 --
222 -- Post Failure:
223 -- If a business rules fails the error will not be handled by this procedure
224 -- unless explicity coded.
225 --
226 -- Developer Implementation Notes:
227 -- For delete, your business rules should be executed from this procedure and
228 -- should ideally (unless really necessary) just be straight procedure or
229 -- function calls. Try and avoid using conditional branching logic.
230 --
231 -- Access Status:
232 -- Internal Row Handler Use Only.
233 --
234 -- {End Of Comments}
235 -- ----------------------------------------------------------------------------
236 Procedure delete_validate
237 (p_rec in pay_pay_shd.g_rec_type
238 ,p_effective_date in date
239 ,p_datetrack_mode in varchar2
240 ,p_validation_start_date in date
241 ,p_validation_end_date in date
242 );
243 --
244 end pay_pay_bus;