1 Package ssp_mat_bus AUTHID CURRENT_USER as
2 /* $Header: spmatrhi.pkh 120.3 2010/11/27 16:32:44 npannamp ship $ */
3 --
4 Procedure validate_female_sex (p_person_id in number);
5 --
6 Procedure unique_person_due_date (p_due_date in date,
7 p_person_id in number,
8 p_leave_type in varchar2,
9 p_maternity_id in number);
10 --
11 Procedure check_actual_birth (p_actual_birth_date in date) ;
12 --
13 Procedure check_live_birth (p_live_birth_flag in out nocopy varchar2,
14 p_actual_birth_date in date);
15 --
16 Procedure check_date_notified (p_notification_of_birth_date in date,
17 p_actual_birth_date in date);
18 --
19 Procedure check_stated_ret_date (p_stated_return_date in date,
20 p_intend_to_return in varchar2,
21 p_mpp_start_date in date,
22 p_earliest_mpp_start in date);
23 --
24 Procedure check_forward_MPP_date (p_start_date_mat_allow in date,
25 p_mpp_start_date in out nocopy date);
26 --
27 Procedure check_MPP_start_date (p_mpp_start_date in out nocopy date,
28 p_earliest_mpp_start_date in date,
29 p_actual_birth_date in date);
30 --
31 Procedure check_MPP_start_date_2 (p_mpp_start_date in date,
32 p_person_id in number,
33 p_ewc in date,
34 p_earliest_mpp_start_date in date,
35 p_due_date in date,
36 p_prev_mpp_start_date in date,
37 p_actual_birth_date in date);
38 --
39 FUNCTION late_evidence (p_maternity_id in number,
40 p_evidence_rcvd in date,
41 p_effective_date in date,
42 p_element_name in varchar2) return boolean;
43 --
44 PROCEDURE evd_before_ewc_due_date_change
45 (p_qualifying_week in date,
46 p_ewc in date,
47 p_maternity_id in number);
48 --
49 PROCEDURE evd_before_ewc (p_ewc in date,
50 p_evidence_date in date,
51 p_effective_date in date,
52 p_element_name in varchar2);
53 --
54 PROCEDURE default_mpp_date(p_actual_birth_date in date,
55 p_mpp_start_date in out nocopy date);
56 --
57 PROCEDURE default_date_notification(p_actual_birth_date in date,
58 p_notif_of_birth_date in out nocopy date);
59
60 PROCEDURE default_date_notification(p_actual_birth_date in date,
61 p_effective_date in date,
62 p_notif_of_birth_date in out nocopy date);
63
64 PROCEDURE CHECK_CHILD_EXPECTED_DATE(p_due_date in date,
65 p_matching_date in date);
66 --
67 PROCEDURE CHECK_APP_START_DATE(p_mpp_start_date in date,
68 p_placement_date in date,
69 p_due_date in date);
70 --
71 PROCEDURE CHECK_PPP_START_DATE(p_ppp_start_date in date,
72 p_birth_date in date,
73 p_ewc in date,
74 p_due_date in date);
75 --
76 PROCEDURE CHECK_PPPA_START_DATE(p_ppp_start_date in date,
77 p_placement_date in date,
78 p_due_date in date);
79 --
80 PROCEDURE CHECK_ASPP_START_DATE(p_aspp_start_date in date,
81 p_birth_date in date,
82 p_partner_mpp_start in date,
83 p_partner_return_date in date,
84 p_mother_death_date in date);
85 --
86 PROCEDURE CHECK_ASPPA_START_DATE(p_aspp_start_date in date,
87 p_placement_date in date,
88 p_partner_app_start in date,
89 p_partner_return_date in date,
90 p_mother_death_date in date);
91 --
92 PROCEDURE CHECK_PLACEMENT_DATE( p_placement_date in date,
93 P_MATCHING_DATE IN DATE);
94 --
95 PROCEDURE CHECK_DISRUPTED_PLACEMENT_DATE (p_disrupted_placement_date in date,
96 p_mpp_start_date in date);
97 --
98 Procedure check_adopt_child_birth_dt(p_actual_birth_date in date,
99 p_due_date in date);
100 --
101 PROCEDURE CHECK_ASPP_PARTNER_DATES( p_partner_return in date,
102 p_partner_death IN DATE, p_partner_mpp_start in date);
103 --
104 -- ----------------------------------------------------------------------------
105 -- |---------------------------< insert_validate >----------------------------|
106 -- ----------------------------------------------------------------------------
107 -- {Start Of Comments}
108 --
109 -- Description:
110 -- This procedure controls the execution of all insert business rules
111 -- validation.
112 --
113 -- Pre Conditions:
114 -- This private procedure is called from ins procedure.
115 --
116 -- In Parameters:
117 -- A Pl/Sql record structre.
118 --
119 -- Post Success:
120 -- Processing continues.
121 --
122 -- Post Failure:
123 -- If a business rules fails the error will not be handled by this procedure
124 -- unless explicity coded.
125 --
126 -- Developer Implementation Notes:
127 -- For insert, your business rules should be executed from this procedure and
128 -- should ideally (unless really necessary) just be straight procedure or
129 -- function calls. Try and avoid using conditional branching logic.
130 --
131 -- Access Status:
132 -- Internal Table Handler Use Only.
133 --
134 -- {End Of Comments}
135 -- ----------------------------------------------------------------------------
136 Procedure insert_validate(p_rec in out nocopy ssp_mat_shd.g_rec_type);
137 --
138 -- ----------------------------------------------------------------------------
139 -- |---------------------------< update_validate >----------------------------|
140 -- ----------------------------------------------------------------------------
141 -- {Start Of Comments}
142 --
143 -- Description:
144 -- This procedure controls the execution of all update business rules
145 -- validation.
146 --
147 -- Pre Conditions:
148 -- This private procedure is called from upd procedure.
149 --
150 -- In Parameters:
151 -- A Pl/Sql record structre.
152 --
153 -- Post Success:
154 -- Processing continues.
155 --
156 -- Post Failure:
157 -- If a business rules fails the error will not be handled by this procedure
158 -- unless explicity coded.
159 --
160 -- Developer Implementation Notes:
161 -- For update, your business rules should be executed from this procedure and
162 -- should ideally (unless really necessary) just be straight procedure or
163 -- function calls. Try and avoid using conditional branching logic.
164 --
165 -- Access Status:
166 -- Internal Table Handler Use Only.
167 --
168 -- {End Of Comments}
169 -- ----------------------------------------------------------------------------
170 Procedure update_validate(p_rec in out nocopy ssp_mat_shd.g_rec_type);
171 --
172 -- ----------------------------------------------------------------------------
173 -- |---------------------------< delete_validate >----------------------------|
174 -- ----------------------------------------------------------------------------
175 -- {Start Of Comments}
176 --
177 -- Description:
178 -- This procedure controls the execution of all delete business rules
179 -- validation.
180 --
181 -- Pre Conditions:
182 -- This private procedure is called from del procedure.
183 --
184 -- In Parameters:
185 -- A Pl/Sql record structre.
186 --
187 -- Post Success:
188 -- Processing continues.
189 --
190 -- Post Failure:
191 -- If a business rules fails the error will not be handled by this procedure
192 -- unless explicity coded.
193 --
194 -- Developer Implementation Notes:
195 -- For delete, your business rules should be executed from this procedure and
196 -- should ideally (unless really necessary) just be straight procedure or
197 -- function calls. Try and avoid using conditional branching logic.
198 --
199 -- Access Status:
200 -- Internal Table Handler Use Only.
201 --
202 -- {End Of Comments}
203 -- ----------------------------------------------------------------------------
204 Procedure delete_validate(p_rec in ssp_mat_shd.g_rec_type);
205 --
206 end ssp_mat_bus;