1 Package hxc_htc_bus AUTHID CURRENT_USER as
2 /* $Header: hxchtcrhi.pkh 120.0 2005/05/29 05:42:06 appldev noship $ */
3
4 TYPE r_ter_record IS RECORD ( ter_id hxc_time_entry_rules.time_entry_rule_id%TYPE
5 ,attribute varchar2(20) );
6
7 TYPE t_ter_table IS TABLE OF r_ter_record INDEX BY BINARY_INTEGER;
8 --
9 -- ----------------------------------------------------------------------------
10 -- |-----------------------< chk_time_category >-------------------------|
11 -- ----------------------------------------------------------------------------
12
13 -- Description:
14 -- This procedure insures time category is not duplicated
15
16 -- Pre Conditions:
17 -- None
18
19 -- In Arguments:
20 -- name
21 -- time_category_id
22
23 -- Post Success:
24 -- Processing continues if the name business rules have not been violated
25
26 -- Post Failure:
27 -- An application error is raised if the name is not valid
28
29 -- ----------------------------------------------------------------------------
30 Procedure chk_time_category
31 (
32 p_time_category_id number,
33 p_time_category_name varchar2
34 );
35
36
37 -- ----------------------------------------------------------------------------
38 -- |------------------< chk_tc_ref_integrity >--------------------------------|
39 -- ----------------------------------------------------------------------------
40
41 -- Description:
42 -- This function checks to see if a time category is referenced elsewhere
43 -- in the system
44
45 -- In Arguments:
46 -- p_time_category_id
47
48 -- Post Success:
49 -- Returns TRUE if the time category IS NOT referenced
50
51 -- Post Failure:
52 -- Returns FALSE if the time category IS referenced
53
54 -- ----------------------------------------------------------------------------
55
56 FUNCTION chk_tc_ref_integrity ( p_time_category_id NUMBER ) RETURN BOOLEAN;
57
58
59
60 -- ----------------------------------------------------------------------------
61 -- |-----------------< get_tc_ref_integrity_list >----------------------------|
62 -- ----------------------------------------------------------------------------
63
64 -- Description:
65 -- This function returns a list of Time Entry Rules which the time category
66 -- is being used in
67
68 -- In Arguments:
69 -- p_time_category_id
70
71 -- Post Success:
72 -- t_ter_table
73
74 -- Post Failure:
75 -- empty t_ter_table
76
77 -- ----------------------------------------------------------------------------
78
79 FUNCTION get_tc_ref_integrity_list ( p_time_category_id NUMBER ) RETURN t_ter_table;
80
81
82
83 -- ----------------------------------------------------------------------------
84 -- |-----------------------< chk_delete >-------------------------------------|
85 -- ----------------------------------------------------------------------------
86 -- {Start Of Comments}
87 --
88 -- Description:
89 -- This procedure carries out delete time referential integrity checks
90 -- to ensure that a time category is not being used by another time category
91 --
92 -- Pre Conditions:
93 -- None
94 --
95 -- In Arguments:
96 -- time_category_id
97 --
98 -- Post Success:
99 -- Processing continues if the name is not being referenced
100 --
101 -- Post Failure:
102 -- An application error is raised if the rule is being used.
103 --
104 -- {End Of Comments}
105 -- ----------------------------------------------------------------------------
106 Procedure chk_delete
107 (
108 p_time_category_id number
109 );
110 -- ----------------------------------------------------------------------------
111 -- |---------------------------< insert_validate >----------------------------|
112 -- ----------------------------------------------------------------------------
113 -- {Start of comments}
114 --
115 -- Description:
116 -- This procedure controls the execution of all insert business rules
117 -- validation.
118 --
119 -- Prerequisites:
120 -- This private procedure is called from ins procedure.
121 --
122 -- In Parameters:
123 -- A Pl/Sql record structure.
124 --
125 -- Post Success:
126 -- Processing continues.
127 --
128 -- Post Failure:
129 -- If a business rules fails the error will not be handled by this procedure
130 -- unless explicity coded.
131 --
132 -- Developer Implementation Notes:
133 -- For insert, your business rules should be executed from this procedure and
134 -- should ideally (unless really necessary) just be straight procedure or
135 -- function calls. Try and avoid using conditional branching logic.
136 --
137 -- Access Status:
138 -- Internal Row Handler Use Only.
139 --
140 -- {End of comments}
141 -- ----------------------------------------------------------------------------
142 Procedure insert_validate
143 (p_rec in hxc_htc_shd.g_rec_type
144 );
145 --
146 -- ----------------------------------------------------------------------------
147 -- |---------------------------< update_validate >----------------------------|
148 -- ----------------------------------------------------------------------------
149 -- {Start Of Comments}
150 --
151 -- Description:
152 -- This procedure controls the execution of all update business rules
153 -- validation.
154 --
155 -- Prerequisites:
156 -- This private procedure is called from upd procedure.
157 --
158 -- In Parameters:
159 -- A Pl/Sql record structure.
160 --
161 -- Post Success:
162 -- Processing continues.
163 --
164 -- Post Failure:
165 -- If a business rules fails the error will not be handled by this procedure
166 -- unless explicity coded.
167 --
168 -- Developer Implementation Notes:
169 -- For update, your business rules should be executed from this procedure and
170 -- should ideally (unless really necessary) just be straight procedure or
171 -- function calls. Try and avoid using conditional branching logic.
172 --
173 -- Access Status:
174 -- Internal Row Handler Use Only.
175 --
176 -- {End Of Comments}
177 -- ----------------------------------------------------------------------------
178 Procedure update_validate
179 (p_rec in hxc_htc_shd.g_rec_type
180 );
181 --
182 -- ----------------------------------------------------------------------------
183 -- |---------------------------< delete_validate >----------------------------|
184 -- ----------------------------------------------------------------------------
185 -- {Start Of Comments}
186 --
187 -- Description:
188 -- This procedure controls the execution of all delete business rules
189 -- validation.
190 --
191 -- Prerequisites:
192 -- This private procedure is called from del procedure.
193 --
194 -- In Parameters:
195 -- A Pl/Sql record structure.
196 --
197 -- Post Success:
198 -- Processing continues.
199 --
200 -- Post Failure:
201 -- If a business rules fails the error will not be handled by this procedure
202 -- unless explicity coded.
203 --
204 -- Developer Implementation Notes:
205 -- For delete, your business rules should be executed from this procedure and
206 -- should ideally (unless really necessary) just be straight procedure or
207 -- function calls. Try and avoid using conditional branching logic.
208 --
209 -- Access Status:
210 -- Internal Row Handler Use Only.
211 --
212 --
213 -- ----------------------------------------------------------------------------
214 Procedure delete_validate
215 (p_rec in hxc_htc_shd.g_rec_type
216 );
217 --
218 end hxc_htc_bus;