1 Package ssp_mat_bus as
2 /* $Header: spmatrhi.pkh 120.1 2006/08/23 09:33:36 kthampan noship $ */
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_PLACEMENT_DATE( p_placement_date in date,
81 P_MATCHING_DATE IN DATE);
82 --
83 PROCEDURE CHECK_DISRUPTED_PLACEMENT_DATE (p_disrupted_placement_date in date,
84 p_mpp_start_date in date);
85 --
86 Procedure check_adopt_child_birth_dt(p_actual_birth_date in date,
87 p_due_date in date);
88
89 --
90 -- ----------------------------------------------------------------------------
91 -- |---------------------------< insert_validate >----------------------------|
92 -- ----------------------------------------------------------------------------
93 -- {Start Of Comments}
94 --
95 -- Description:
96 -- This procedure controls the execution of all insert business rules
97 -- validation.
98 --
99 -- Pre Conditions:
100 -- This private procedure is called from ins procedure.
101 --
102 -- In Parameters:
103 -- A Pl/Sql record structre.
104 --
105 -- Post Success:
106 -- Processing continues.
107 --
108 -- Post Failure:
109 -- If a business rules fails the error will not be handled by this procedure
110 -- unless explicity coded.
111 --
112 -- Developer Implementation Notes:
113 -- For insert, your business rules should be executed from this procedure and
114 -- should ideally (unless really necessary) just be straight procedure or
115 -- function calls. Try and avoid using conditional branching logic.
116 --
117 -- Access Status:
118 -- Internal Table Handler Use Only.
119 --
120 -- {End Of Comments}
121 -- ----------------------------------------------------------------------------
122 Procedure insert_validate(p_rec in out nocopy ssp_mat_shd.g_rec_type);
123 --
124 -- ----------------------------------------------------------------------------
125 -- |---------------------------< update_validate >----------------------------|
126 -- ----------------------------------------------------------------------------
127 -- {Start Of Comments}
128 --
129 -- Description:
130 -- This procedure controls the execution of all update business rules
131 -- validation.
132 --
133 -- Pre Conditions:
134 -- This private procedure is called from upd procedure.
135 --
136 -- In Parameters:
137 -- A Pl/Sql record structre.
138 --
139 -- Post Success:
140 -- Processing continues.
141 --
142 -- Post Failure:
143 -- If a business rules fails the error will not be handled by this procedure
144 -- unless explicity coded.
145 --
146 -- Developer Implementation Notes:
147 -- For update, your business rules should be executed from this procedure and
148 -- should ideally (unless really necessary) just be straight procedure or
149 -- function calls. Try and avoid using conditional branching logic.
150 --
151 -- Access Status:
152 -- Internal Table Handler Use Only.
153 --
154 -- {End Of Comments}
155 -- ----------------------------------------------------------------------------
156 Procedure update_validate(p_rec in out nocopy ssp_mat_shd.g_rec_type);
157 --
158 -- ----------------------------------------------------------------------------
159 -- |---------------------------< delete_validate >----------------------------|
160 -- ----------------------------------------------------------------------------
161 -- {Start Of Comments}
162 --
163 -- Description:
164 -- This procedure controls the execution of all delete business rules
165 -- validation.
166 --
167 -- Pre Conditions:
168 -- This private procedure is called from del procedure.
169 --
170 -- In Parameters:
171 -- A Pl/Sql record structre.
172 --
173 -- Post Success:
174 -- Processing continues.
175 --
176 -- Post Failure:
177 -- If a business rules fails the error will not be handled by this procedure
178 -- unless explicity coded.
179 --
180 -- Developer Implementation Notes:
181 -- For delete, your business rules should be executed from this procedure and
182 -- should ideally (unless really necessary) just be straight procedure or
183 -- function calls. Try and avoid using conditional branching logic.
184 --
185 -- Access Status:
186 -- Internal Table Handler Use Only.
187 --
188 -- {End Of Comments}
189 -- ----------------------------------------------------------------------------
190 Procedure delete_validate(p_rec in ssp_mat_shd.g_rec_type);
191 --
192 end ssp_mat_bus;