1 Package ben_pdp_bus AUTHID CURRENT_USER as
2 /* $Header: bepdprhi.pkh 120.3 2005/11/18 04:28:44 vborkar noship $ */
3 --
4 --
5 -- ---------------------------------------------------------------------------
6 -- |---------------------< return_legislation_code >-------------------------|
7 -- ---------------------------------------------------------------------------
8 --
9 -- Description:
10 -- Return the legislation code for a specific primary key value
11 --
12 -- Prerequisites:
13 -- The primary key identified by p_elig_cvrd_dpnt_id already exists.
14 --
15 -- In Arguments:
16 -- p_elig_cvrd_dpnt_id
17 --
18 -- Post Success:
19 -- If the value is found this function will return the values business
20 -- group legislation code.
21 --
22 -- Post Failure:
23 -- An error is raised if the value does not exist.
24 --
25 -- Access Status:
26 -- Internal Development Use Only.
27 --
28 function return_legislation_code
29 (p_elig_cvrd_dpnt_id in number) return varchar2;
30 --
31 --
32 -- ----------------------------------------------------------------------------
33 -- |---------------------------< insert_validate >----------------------------|
34 -- ----------------------------------------------------------------------------
35 -- {Start Of Comments}
36 --
37 -- Description:
38 -- This procedure controls the execution of all insert business rules
39 -- validation.
40 --
41 -- Prerequisites:
42 -- This private procedure is called from ins procedure.
43 --
44 -- In Parameters:
45 -- A Pl/Sql record structre.
46 --
47 -- Post Success:
48 -- Processing continues.
49 --
50 -- Post Failure:
51 -- If a business rules fails the error will not be handled by this procedure
52 -- unless explicity coded.
53 --
54 -- Developer Implementation Notes:
55 -- For insert, your business rules should be executed from this procedure and
56 -- should ideally (unless really necessary) just be straight procedure or
57 -- function calls. Try and avoid using conditional branching logic.
58 --
59 -- Access Status:
60 -- Internal Row Handler Use Only.
61 --
62 -- {End Of Comments}
63 -- ----------------------------------------------------------------------------
64 Procedure insert_validate
65 (p_rec in ben_pdp_shd.g_rec_type,
66 p_effective_date in date,
67 p_datetrack_mode in varchar2,
68 p_validation_start_date in date,
69 p_validation_end_date in date);
70 --
71 -- ----------------------------------------------------------------------------
72 -- |---------------------------< update_validate >----------------------------|
73 -- ----------------------------------------------------------------------------
74 -- {Start Of Comments}
75 --
76 -- Description:
77 -- This procedure controls the execution of all update business rules
78 -- validation.
79 --
80 -- Prerequisites:
81 -- This private procedure is called from upd procedure.
82 --
83 -- In Parameters:
84 -- A Pl/Sql record structre.
85 --
86 -- Post Success:
87 -- Processing continues.
88 --
89 -- Post Failure:
90 -- If a business rules fails the error will not be handled by this procedure
91 -- unless explicity coded.
92 --
93 -- Developer Implementation Notes:
94 -- For update, your business rules should be executed from this procedure and
95 -- should ideally (unless really necessary) just be straight procedure or
96 -- function calls. Try and avoid using conditional branching logic.
97 --
98 -- Access Status:
99 -- Internal Row Handler Use Only.
100 --
101 -- {End Of Comments}
102 -- ----------------------------------------------------------------------------
103 Procedure update_validate
104 (p_rec in ben_pdp_shd.g_rec_type,
105 p_effective_date in date,
106 p_datetrack_mode in varchar2,
107 p_validation_start_date in date,
108 p_validation_end_date in date);
109 --
110 -- ----------------------------------------------------------------------------
111 -- |---------------------------< delete_validate >----------------------------|
112 -- ----------------------------------------------------------------------------
113 -- {Start Of Comments}
114 --
115 -- Description:
116 -- This procedure controls the execution of all delete business rules
117 -- validation.
118 --
119 -- Prerequisites:
120 -- This private procedure is called from del procedure.
121 --
122 -- In Parameters:
123 -- A Pl/Sql record structre.
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 delete, 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 delete_validate
143 (p_rec in ben_pdp_shd.g_rec_type,
144 p_effective_date in date,
145 p_datetrack_mode in varchar2,
146 p_validation_start_date in date,
147 p_validation_end_date in date);
148 --
149 -- ---------------------------------------------------------------------------
150 -- |------------------------< crt_ordr_warning >----------------------------|
151 -- ---------------------------------------------------------------------------
152 -- Procedure used to create warning messages for crt_ordrs.
153 --
154 -- Description
155 -- This procedure is used to create warning messages for persons
156 -- not designated as covered dependents but reqired to be covered
157 -- under court orders.
158 --
159 -- Pre Conditions
160 -- None.
161 --
162 -- In Parameters
163 -- prtt_enrt_rslt_id PK of record being inserted or updated.
164 -- effective_date effective date
165 --
166 -- Post Success
167 -- Processing continues
168 --
169 -- Post Failure
170 -- Error handled by procedure
171 --
172 -- Access Status
173 -- Internal table handler use only.
174 --
175 procedure crt_ordr_warning
176 (p_prtt_enrt_rslt_id in number
177 ,p_effective_date in date
178 ,p_business_group_id in number);
179 --
180 --
181 -- ---------------------------------------------------------------------------
182 -- |------------------------< crt_ordr_warning_ss >----------------------------|
183 -- ---------------------------------------------------------------------------
184 -- Function is called from SS to check court order(s) for a dependent.
185 --
186 Function crt_ordr_warning_ss
187 (p_prtt_enrt_rslt_id in number
188 ,p_enrt_cvg_strt_dt in date
189 ,p_enrt_cvg_thru_dt in date
190 ,p_person_id in number
191 ,p_dpnt_person_id in number
192 ,p_pl_id in number
193 ,p_pl_typ_id in number
194 ,p_effective_date in date
195 ,p_per_in_ler_id in number
196 ,p_business_group_id in number)
197 Return VARCHAR2;
198 --
199 end ben_pdp_bus;