1 PACKAGE pqp_gb_manage_life_events AUTHID CURRENT_USER AS
2 /* $Header: pqpgbmle.pkh 115.3 2004/05/11 09:51:36 rrazdan noship $ */
3 --
4 -- Public Global Variables
5 --
6 --
7 -- Cursors
8 --
9 CURSOR csr_last_ben_report
10 (p_person_id IN NUMBER
11 ,p_process_date IN DATE
12 ) IS
13 SELECT rep.reporting_id
14 ,rep.rep_typ_cd
15 ,rep.text
16 FROM ben_reporting rep
17 ,ben_benefit_actions bac
18 WHERE rep.person_id = p_person_id
19 AND bac.benefit_action_id = rep.benefit_action_id
20 AND bac.process_date = p_process_date
21 ORDER BY rep.creation_date DESC; -- DESC order by to get latest row
22 --
23 --
24 --
25 CURSOR csr_benmngle_batch_parameter
26 (p_business_group_id IN NUMBER
27 ) IS
28 SELECT batch_parameter_id
29 ,max_err_num -- NUMBER(15)
30 FROM ben_batch_parameter
31 WHERE BATCH_EXE_CD = 'BENMNGLE'
32 AND business_group_id = p_business_group_id;
33 --
34 --
35 --
36 PROCEDURE abse_process
37 (p_business_group_id IN NUMBER
38 ,p_person_id IN NUMBER
39 ,p_effective_date IN DATE
40 ,p_absence_attendance_id IN NUMBER DEFAULT NULL
41 ,p_absence_start_date IN DATE DEFAULT NULL
42 ,p_absence_end_date IN DATE DEFAULT NULL
43 ,p_errbuf OUT NOCOPY VARCHAR2
44 ,p_retcode OUT NOCOPY NUMBER
45 );
46 --
47 --
48 --
49 END pqp_gb_manage_life_events;