1 Package per_cag_bus AUTHID CURRENT_USER as
2 /* $Header: pecagrhi.pkh 120.0 2005/05/31 06:22:21 appldev noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |---------------------------< insert_validate >----------------------------|
6 -- ----------------------------------------------------------------------------
7 -- {Start Of Comments}
8 --
9 -- Description:
10 -- This procedure controls the execution of all insert business rules
11 -- validation.
12 --
13 -- Prerequisites:
14 -- This private procedure is called from ins procedure.
15 --
16 -- In Parameters:
17 -- A Pl/Sql record structre.
18 --
19 -- Post Success:
20 -- Processing continues.
21 --
22 -- Post Failure:
23 -- If a business rules fails the error will not be handled by this procedure
24 -- unless explicity coded.
25 --
26 -- Developer Implementation Notes:
27 -- For insert, your business rules should be executed from this procedure and
28 -- should ideally (unless really necessary) just be straight procedure or
29 -- function calls. Try and avoid using conditional branching logic.
30 --
31 -- Access Status:
32 -- Internal Row Handler Use Only.
33 --
34 -- {End Of Comments}
35 -- ----------------------------------------------------------------------------
36 Procedure insert_validate(p_rec in per_cag_shd.g_rec_type);
37 --
38 -- ----------------------------------------------------------------------------
39 -- |---------------------------< update_validate >----------------------------|
40 -- ----------------------------------------------------------------------------
41 -- {Start Of Comments}
42 --
43 -- Description:
44 -- This procedure controls the execution of all update business rules
45 -- validation.
46 --
47 -- Prerequisites:
48 -- This private procedure is called from upd procedure.
49 --
50 -- In Parameters:
51 -- A Pl/Sql record structre.
52 --
53 -- Post Success:
54 -- Processing continues.
55 --
56 -- Post Failure:
57 -- If a business rules fails the error will not be handled by this procedure
58 -- unless explicity coded.
59 --
60 -- Developer Implementation Notes:
61 -- For update, your business rules should be executed from this procedure and
62 -- should ideally (unless really necessary) just be straight procedure or
63 -- function calls. Try and avoid using conditional branching logic.
64 --
65 -- Access Status:
66 -- Internal Row Handler Use Only.
67 --
68 -- {End Of Comments}
69 -- ----------------------------------------------------------------------------
70 Procedure update_validate(p_rec in per_cag_shd.g_rec_type);
71 --
72 -- ----------------------------------------------------------------------------
73 -- |---------------------------< delete_validate >----------------------------|
74 -- ----------------------------------------------------------------------------
75 -- {Start Of Comments}
76 --
77 -- Description:
78 -- This procedure controls the execution of all delete business rules
79 -- validation.
80 --
81 -- Prerequisites:
82 -- This private procedure is called from del procedure.
83 --
84 -- In Parameters:
85 -- A Pl/Sql record structre.
86 --
87 -- Post Success:
88 -- Processing continues.
89 --
90 -- Post Failure:
91 -- If a business rules fails the error will not be handled by this procedure
92 -- unless explicity coded.
93 --
94 -- Developer Implementation Notes:
95 -- For delete, your business rules should be executed from this procedure and
96 -- should ideally (unless really necessary) just be straight procedure or
97 -- function calls. Try and avoid using conditional branching logic.
98 --
99 -- Access Status:
100 -- Internal Row Handler Use Only.
101 --
102 -- {End Of Comments}
103 -- ----------------------------------------------------------------------------
104 Procedure delete_validate(p_rec in per_cag_shd.g_rec_type);
105
106 -- ----------------------------------------------------------------------------
107 -- |---------------------------< chk_date_validate >----------------------------|
108 -- ----------------------------------------------------------------------------
109 -- {Start Of Comments}
110 --
111 -- Description:
112 -- This procedure controls the validity of the start_date and end_date according to the business rule.
113 -- The start_date should be lower than the end_date.
114 -- v
115 --
116 -- Prerequisites:
117 -- This private procedure is called from the Collective_Agreement Form and from the Collective_Agreement API.
118 --
119 -- In Parameters:
120 -- Collective_Agreement start_date and end_date.
121 --
122 -- Post Success:
123 -- Processing continues.
124 --
125 -- Post Failure:
126 -- If a business rules fails the error will by handled by this procedure.
127 --
128 --
129 -- Developer Implementation Notes:
130 --
131 --
132 --
133 --
134 -- Access Status:
135 -- Internal and External Row Handler Use Only.
136 --
137 -- {End Of Comments}
138 -- ----------------------------------------------------------------------------
139 Procedure chk_date_validate
140 (p_start_date in date,
141 p_end_date in date
142 );
143
144 -- ----------------------------------------------------------------------------
145 -- |---------------------------< status_validate >----------------------------|
146 -- ----------------------------------------------------------------------------
147 -- {Start Of Comments}
148 --
149 -- Description:
150 -- This procedure controls the validity of the Category Status according to the business rule.
151 -- The status should be existing in CAGR_STATUS hr_lookups.
152 --
153 -- Prerequisites:
154 -- This private procedure is called from the Collective_Agreement Form and from the Collective_Agreement API.
155 --
156 -- In Parameters:
157 -- Collective_Agreement status.
158 --
159 -- Post Success:
160 -- Processing continues.
161 --
162 -- Post Failure:
163 -- If a business rules fails the error will by handled by this procedure.
164 --
165 --
166 -- Developer Implementation Notes:
167 --
168 --
169 --
170 --
171 -- Access Status:
172 -- Internal and External Row Handler Use Only.
173 --
174 -- {End Of Comments}
175 -- ----------------------------------------------------------------------------
176 Procedure chk_status_validate
177 (p_status in varchar2
178 );
179
180
181 Procedure chk_employer_organization_id
182 (p_collective_agreement_id in number,
183 p_employer_organization_id in number,
184 p_business_group_id in number);
185
186
187 Procedure chk_bargaining_organization_id
188 (p_collective_agreement_id in number,
189 p_bargaining_organization_id in number,
190 p_business_group_id in number);
191
192 --
193 -- ---------------------------------------------------------------------------
194 -- |---------------------< return_legislation_code >-------------------------|
195 -- ---------------------------------------------------------------------------
196 --
197 -- Description:
198 -- Return the legislation code for a specific person
199 --
200 -- Prerequisites:
201 -- The contract identified by p_contract_id already exists.
202 --
203 -- In Arguments:
204 -- p_contract_id
205 --
206 -- Post Success:
207 -- If the contract is found this function will return the contract's business
208 -- group legislation code.
209 --
210 -- Post Failure:
211 -- An error is raised if the contract does not exist.
212 --
213 -- Access Status:
214 -- Internal Development Use Only.
215 --
216 function return_legislation_code
217 (p_collective_agreement_id in number
218 ) return varchar2;
219 --
220 --
221 end per_cag_bus;
[Home] [Help]