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