1 Package ghr_cah_bus as
2 /* $Header: ghcahrhi.pkh 120.0 2005/05/29 02:48:37 appldev noship $ */
3 --
4 -- ---------------------------------------------------------------------------
5 -- |----------------------< set_security_group_id >--------------------------|
6 -- ---------------------------------------------------------------------------
7 -- {Start Of Comments}
8 --
9 -- Description:
10 -- Sets the security_group_id in CLIENT_INFO for the appropriate business
11 -- group context.
12 --
13 -- Prerequisites:
14 -- The primary key identified by p_compl_ca_header_id
15 -- already exists.
16 --
17 -- In Arguments:
18 -- p_compl_ca_header_id
19 --
20 --
21 -- Post Success:
22 -- The security_group_id will be set in CLIENT_INFO.
23 --
24 -- Post Failure:
25 -- An error is raised if the value does not exist.
26 --
27 -- Access Status:
28 -- Internal Development Use Only.
29 --
30 -- {End Of Comments}
31 -- ---------------------------------------------------------------------------
32 procedure set_security_group_id
33 (p_compl_ca_header_id in number
34 );
35 --
36 --
37 -- ---------------------------------------------------------------------------
38 -- |---------------------< return_legislation_code >-------------------------|
39 -- ---------------------------------------------------------------------------
40 -- {Start Of Comments}
41 --
42 -- Description:
43 -- Return the legislation code for a specific primary key value
44 --
45 -- Prerequisites:
46 -- The primary key identified by p_compl_ca_header_id
47 -- already exists.
48 --
49 -- In Arguments:
50 -- p_compl_ca_header_id
51 --
52 --
53 -- Post Success:
54 -- The business group's legislation code will be returned.
55 --
56 -- Post Failure:
57 -- An error is raised if the value does not exist.
58 --
59 -- Access Status:
60 -- Internal Development Use Only.
61 --
62 -- {End Of Comments}
63 -- ---------------------------------------------------------------------------
64 FUNCTION return_legislation_code
65 (p_compl_ca_header_id in number
66 ) RETURN varchar2;
67 --
68
69 PROCEDURE chk_ca_source(p_compl_ca_header_id in ghr_compl_ca_headers.compl_ca_header_id%TYPE,
70 p_ca_source in ghr_compl_ca_headers.ca_source%TYPE,
71 p_effective_date in date,
72 p_object_version_number in number);
73
74 PROCEDURE chk_comrep_noncom_req(p_compl_ca_header_id in ghr_compl_ca_headers.compl_ca_header_id%TYPE,
75 p_comrep_noncom_req in ghr_compl_ca_headers.comrep_noncom_req%TYPE,
76 p_effective_date in date,
77 p_object_version_number in number);
78
79 PROCEDURE chk_stage_complaint_reinstated(p_compl_ca_header_id in ghr_compl_ca_headers.compl_ca_header_id%TYPE,
80 p_stage_complaint_reinstated in ghr_compl_ca_headers.stage_complaint_reinstated%TYPE,
81 p_effective_date in date,
82 p_object_version_number in number);
83
84 --
85 -- ----------------------------------------------------------------------------
86 -- |---------------------------< insert_validate >----------------------------|
87 -- ----------------------------------------------------------------------------
88 -- {Start of comments}
89 --
90 -- Description:
91 -- This procedure controls the execution of all insert business rules
92 -- validation.
93 --
94 -- Prerequisites:
95 -- This private procedure is called from ins procedure.
96 --
97 -- In Parameters:
98 -- A Pl/Sql record structure.
99 --
100 -- Post Success:
101 -- Processing continues.
102 --
103 -- Post Failure:
104 -- If a business rules fails the error will not be handled by this procedure
105 -- unless explicity coded.
106 --
107 -- Developer Implementation Notes:
108 -- For insert, your business rules should be executed from this procedure
109 -- and should ideally (unless really necessary) just be straight procedure
110 -- or function calls. Try and avoid using conditional branching logic.
111 --
112 -- Access Status:
113 -- Internal Row Handler Use Only.
114 --
115 -- {End of comments}
116 -- ----------------------------------------------------------------------------
117 Procedure insert_validate
118 (p_effective_date in date
119 ,p_rec in ghr_cah_shd.g_rec_type
120 );
121 --
122 -- ----------------------------------------------------------------------------
123 -- |---------------------------< update_validate >----------------------------|
124 -- ----------------------------------------------------------------------------
125 -- {Start Of Comments}
126 --
127 -- Description:
128 -- This procedure controls the execution of all update business rules
129 -- validation.
130 --
131 -- Prerequisites:
132 -- This private procedure is called from upd procedure.
133 --
134 -- In Parameters:
135 -- A Pl/Sql record structure.
136 --
137 -- Post Success:
138 -- Processing continues.
139 --
140 -- Post Failure:
141 -- If a business rules fails the error will not be handled by this procedure
142 -- unless explicity coded.
143 --
144 -- Access Status:
145 -- Internal Row Handler Use Only.
146 --
147 -- {End Of Comments}
148 -- ----------------------------------------------------------------------------
149 Procedure update_validate
150 (p_effective_date in date
151 ,p_rec in ghr_cah_shd.g_rec_type
152 );
153 --
154 -- ----------------------------------------------------------------------------
155 -- |---------------------------< delete_validate >----------------------------|
156 -- ----------------------------------------------------------------------------
157 -- {Start Of Comments}
158 --
159 -- Description:
160 -- This procedure controls the execution of all delete business rules
161 -- validation.
162 --
163 -- Prerequisites:
164 -- This private procedure is called from del procedure.
165 --
166 -- In Parameters:
167 -- A Pl/Sql record structure.
168 --
169 -- Post Success:
170 -- Processing continues.
171 --
172 -- Post Failure:
173 -- If a business rules fails the error will not be handled by this procedure
174 -- unless explicity coded.
175 --
176 -- Developer Implementation Notes:
177 -- For delete, your business rules should be executed from this procedure
178 -- and should ideally (unless really necessary) just be straight procedure
179 -- or function calls. Try and avoid using conditional branching logic.
180 --
181 -- Access Status:
182 -- Internal Row Handler Use Only.
183 --
184 -- {End Of Comments}
185 -- ----------------------------------------------------------------------------
186 Procedure delete_validate
187 (p_rec in ghr_cah_shd.g_rec_type
188 );
189 --
190 end ghr_cah_bus;