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