1 Package ben_rrb_bus as
2 /* $Header: berrbrhi.pkh 120.0.12010000.1 2008/07/29 13:02:04 appldev ship $ */
3 --
4 --
5 -- ---------------------------------------------------------------------------
6 -- |---------------------< return_legislation_code >-------------------------|
7 -- ---------------------------------------------------------------------------
8 --
9 -- Description:
10 -- Return the legislation code for a specific primary key value
11 --
12 -- Prerequisites:
13 -- The primary key identified by p_regn_for_regy_body_id already exists.
14 --
15 -- In Arguments:
16 -- p_regn_for_regy_body_id
17 --
18 -- Post Success:
19 -- If the value is found this function will return the values business
20 -- group legislation code.
21 --
22 -- Post Failure:
23 -- An error is raised if the value does not exist.
24 --
25 -- Access Status:
26 -- Internal Development Use Only.
27 --
28 function return_legislation_code
29 (p_regn_for_regy_body_id in number) return varchar2;
30 --
31 -- ----------------------------------------------------------------------------
32 -- |------< chk_organization_id >------|
33 -- ----------------------------------------------------------------------------
34 --
35 -- Description
36 -- This procedure is used to check that the organization_id field (for Regy Body)
37 -- is unique within Regulation on insert and on update.
38 --
39 -- Pre Conditions
40 -- None.
41 --
42 -- In Parameters
43 -- regn_for_regy_body_id PK of record being inserted or updated.
44 -- regn_id of record being inserted or updated.
45 -- organization_id that is beeing inserted ot updated to.
46 -- effective_date Effective Date of session
47 -- business group ID
48 -- object_version_number Object version number of record being
49 -- inserted or updated.
50 --
51 -- Post Success
52 -- Processing continues
53 --
54 -- Post Failure
55 -- Errors handled by the procedure
56 --
57 -- Access Status
58 -- HR Development Internal use only.
59 --
60 Procedure chk_organization_id(
61 p_regn_for_regy_body_id in number,
62 p_regn_id in number,
63 p_organization_id in number,
64 p_effective_date in date,
65 p_validation_start_date in date,
66 p_validation_end_date in date,
67 p_business_group_id in number,
68 p_object_version_number in number);
69 --
70 -- ----------------------------------------------------------------------------
71 -- |---------------------------< insert_validate >----------------------------|
72 -- ----------------------------------------------------------------------------
73 -- {Start Of Comments}
74 --
75 -- Description:
76 -- This procedure controls the execution of all insert business rules
77 -- validation.
78 --
79 -- Prerequisites:
80 -- This private procedure is called from ins procedure.
81 --
82 -- In Parameters:
83 -- A Pl/Sql record structre.
84 --
85 -- Post Success:
86 -- Processing continues.
87 --
88 -- Post Failure:
89 -- If a business rules fails the error will not be handled by this procedure
90 -- unless explicity coded.
91 --
92 -- Developer Implementation Notes:
93 -- For insert, your business rules should be executed from this procedure and
94 -- should ideally (unless really necessary) just be straight procedure or
95 -- function calls. Try and avoid using conditional branching logic.
96 --
97 -- Access Status:
98 -- Internal Row Handler Use Only.
99 --
100 -- {End Of Comments}
101 -- ----------------------------------------------------------------------------
102 Procedure insert_validate
103 (p_rec in ben_rrb_shd.g_rec_type,
104 p_effective_date in date,
105 p_datetrack_mode in varchar2,
106 p_validation_start_date in date,
107 p_validation_end_date in date);
108 --
109 -- ----------------------------------------------------------------------------
110 -- |---------------------------< update_validate >----------------------------|
111 -- ----------------------------------------------------------------------------
112 -- {Start Of Comments}
113 --
114 -- Description:
115 -- This procedure controls the execution of all update business rules
116 -- validation.
117 --
118 -- Prerequisites:
119 -- This private procedure is called from upd procedure.
120 --
121 -- In Parameters:
122 -- A Pl/Sql record structre.
123 --
124 -- Post Success:
125 -- Processing continues.
126 --
127 -- Post Failure:
128 -- If a business rules fails the error will not be handled by this procedure
129 -- unless explicity coded.
130 --
131 -- Developer Implementation Notes:
132 -- For update, your business rules should be executed from this procedure and
133 -- should ideally (unless really necessary) just be straight procedure or
134 -- function calls. Try and avoid using conditional branching logic.
135 --
136 -- Access Status:
137 -- Internal Row Handler Use Only.
138 --
139 -- {End Of Comments}
140 -- ----------------------------------------------------------------------------
141 Procedure update_validate
142 (p_rec in ben_rrb_shd.g_rec_type,
143 p_effective_date in date,
144 p_datetrack_mode in varchar2,
145 p_validation_start_date in date,
146 p_validation_end_date in date);
147 --
148 -- ----------------------------------------------------------------------------
149 -- |---------------------------< delete_validate >----------------------------|
150 -- ----------------------------------------------------------------------------
151 -- {Start Of Comments}
152 --
153 -- Description:
154 -- This procedure controls the execution of all delete business rules
155 -- validation.
156 --
157 -- Prerequisites:
158 -- This private procedure is called from del procedure.
159 --
160 -- In Parameters:
161 -- A Pl/Sql record structre.
162 --
163 -- Post Success:
164 -- Processing continues.
165 --
166 -- Post Failure:
167 -- If a business rules fails the error will not be handled by this procedure
168 -- unless explicity coded.
169 --
170 -- Developer Implementation Notes:
171 -- For delete, your business rules should be executed from this procedure and
172 -- should ideally (unless really necessary) just be straight procedure or
173 -- function calls. Try and avoid using conditional branching logic.
174 --
175 -- Access Status:
176 -- Internal Row Handler Use Only.
177 --
178 -- {End Of Comments}
179 -- ----------------------------------------------------------------------------
180 Procedure delete_validate
181 (p_rec in ben_rrb_shd.g_rec_type,
182 p_effective_date in date,
183 p_datetrack_mode in varchar2,
184 p_validation_start_date in date,
185 p_validation_end_date in date);
186 --
187 end ben_rrb_bus;