1 Package hxc_ter_bus as
2 /* $Header: hxcterrhi.pkh 120.0 2005/05/29 05:59:43 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 structure.
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
37 (p_effective_date in date
38 ,p_rec in hxc_ter_shd.g_rec_type
39 );
40 --
41 -- ----------------------------------------------------------------------------
42 -- |---------------------------< update_validate >----------------------------|
43 -- ----------------------------------------------------------------------------
44 -- {Start Of Comments}
45 --
46 -- Description:
47 -- This procedure controls the execution of all update business rules
48 -- validation.
49 --
50 -- Prerequisites:
51 -- This private procedure is called from upd procedure.
52 --
53 -- In Parameters:
54 -- A Pl/Sql record structure.
55 --
56 -- Post Success:
57 -- Processing continues.
58 --
59 -- Post Failure:
60 -- If a business rules fails the error will not be handled by this procedure
61 -- unless explicity coded.
62 --
63 -- Developer Implementation Notes:
64 -- For update, your business rules should be executed from this procedure and
65 -- should ideally (unless really necessary) just be straight procedure or
66 -- function calls. Try and avoid using conditional branching logic.
67 --
68 -- Access Status:
69 -- Internal Row Handler Use Only.
70 --
71 -- {End Of Comments}
72 -- ----------------------------------------------------------------------------
73 Procedure update_validate
74 (p_effective_date in date
75 ,p_rec in hxc_ter_shd.g_rec_type
76 );
77 --
78 -- ----------------------------------------------------------------------------
79 -- |---------------------------< delete_validate >----------------------------|
80 -- ----------------------------------------------------------------------------
81 -- {Start Of Comments}
82 --
83 -- Description:
84 -- This procedure controls the execution of all delete business rules
85 -- validation.
86 --
87 -- Prerequisites:
88 -- This private procedure is called from del procedure.
89 --
90 -- In Parameters:
91 -- A Pl/Sql record structure.
92 --
93 -- Post Success:
94 -- Processing continues.
95 --
96 -- Post Failure:
97 -- If a business rules fails the error will not be handled by this procedure
98 -- unless explicity coded.
99 --
100 -- Developer Implementation Notes:
101 -- For delete, your business rules should be executed from this procedure and
102 -- should ideally (unless really necessary) just be straight procedure or
103 -- function calls. Try and avoid using conditional branching logic.
104 --
105 -- Access Status:
106 -- Internal Row Handler Use Only.
107 --
108 --
109 -- ----------------------------------------------------------------------------
110 Procedure delete_validate
111 (p_rec in hxc_ter_shd.g_rec_type
112 );
113 --
114 -- ----------------------------------------------------------------------------
115 -- |-----------------------< chk_start_date >----------------------------------|
116 -- ----------------------------------------------------------------------------
117 -- {Start Of Comments}
118 --
119 -- Description:
120 -- This procedure insures a valid start_date
121 --
122 -- Pre Conditions:
123 -- None
124 --
125 -- In Arguments:
126 -- name
127 -- start_date
128 -- end_date
129 -- object_version_number
130 --
131 -- Post Success:
132 -- Processing continues if the start_date is entered and is valid
133 --
134 -- Post Failure:
135 -- An application error is raised if the start_date is not valid
136 --
137 -- {End Of Comments}
138 -- ----------------------------------------------------------------------------
139 Procedure chk_start_date
140 (
141 p_name in hxc_time_entry_rules.name%TYPE
142 ,p_start_date in hxc_time_entry_rules.start_date%TYPE
143 ,p_end_date in hxc_time_entry_rules.end_date%TYPE
144 ,p_ovn in hxc_time_entry_rules.object_version_number%TYPE
145 ,p_bg_id NUMBER
146 ,p_legislation_code VARCHAR2
147 );
148 --
149 -- ----------------------------------------------------------------------------
150 -- |-----------------------< chk_end_date >------------------------------------|
151 -- ----------------------------------------------------------------------------
152 -- {Start Of Comments}
153 --
154 -- Description:
155 -- This procedure insures a valid end_date
156 --
157 -- Pre Conditions:
158 -- None
159 --
160 -- In Arguments:
161 -- name
162 -- start_date
163 -- end_date
164 -- object_version_number
165 --
166 -- Post Success:
167 -- Processing continues if the start_date is entered and is valid
168 --
169 -- Post Failure:
170 -- An application error is raised if the start_date is not valid
171 --
172 -- {End Of Comments}
173 -- ----------------------------------------------------------------------------
174 --
175 Procedure chk_end_date
176 (
177 p_name in hxc_time_entry_rules.name%TYPE
178 ,p_start_date in hxc_time_entry_rules.start_date%TYPE
179 ,p_end_date in hxc_time_entry_rules.end_date%TYPE
180 ,p_ovn in hxc_time_entry_rules.object_version_number%TYPE
181 ,p_bg_id NUMBER
182 ,p_legislation_code VARCHAR2
183 );
184 --
185 --
186 --
187 -- -----------------------------------------------------------------
188 -- |-----------------------< chk_legislation_code >----------------|
189 -- -----------------------------------------------------------------
190 --
191 -- Description:
192 -- Validate the legislation_code against the FND_TERRITORIES table.
193 --
194 -- Pre-Requisites:
195 -- None
196 --
197 -- In Parameters:
198 -- p_legislation_code
199 --
200 -- Post Success:
201 -- Processing continues if the legislation_code is valid.
202 --
203 -- Post Failure:
204 -- An application error is raised and processing is terminated if
205 -- the legislation_code is invalid.
206 --
207 -- Access Status:
208 -- Internal Row Handler Use Only.
209 --
210 Procedure chk_legislation_code
211 (p_business_group_id in number,
212 p_legislation_code in varchar2
213 );
214 --
215 end hxc_ter_bus;
[Home] [Help]