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