1 PACKAGE pqp_absence_plan_process AUTHID CURRENT_USER AS
2 /* $Header: pqabproc.pkh 120.0 2005/05/29 01:41:10 appldev noship $ */
3 --
4 PROCEDURE create_absence_plan_details(
5 p_person_id IN NUMBER
6 ,p_assignment_id IN NUMBER
7 ,p_business_group_id IN NUMBER
8 ,p_legislation_code IN VARCHAR2
9 ,p_effective_date IN DATE
10 ,p_element_type_id IN NUMBER
11 ,p_pl_id IN NUMBER
12 ,p_pl_typ_id IN NUMBER
13 ,p_ler_id IN NUMBER
14 ,p_per_in_ler_id IN NUMBER
15 ,p_absence_attendance_id IN NUMBER
16 ,p_effective_start_date IN DATE
17 ,p_effective_end_date IN DATE
18 ,p_formula_outputs IN ff_exec.outputs_t
19 ,p_error_code OUT NOCOPY NUMBER
20 ,p_error_message OUT NOCOPY VARCHAR2
21 );
22 --
23 PROCEDURE update_absence_plan_details(
24 p_person_id IN NUMBER
25 ,p_assignment_id IN NUMBER
26 ,p_business_group_id IN NUMBER
27 ,p_legislation_code IN VARCHAR2
28 ,p_effective_date IN DATE
29 ,p_element_type_id IN NUMBER
30 ,p_pl_id IN NUMBER
31 ,p_pl_typ_id IN NUMBER
32 ,p_ler_id IN NUMBER
33 ,p_per_in_ler_id IN NUMBER
34 ,p_absence_attendance_id IN NUMBER
35 ,p_effective_start_date IN DATE
36 ,p_effective_end_date IN DATE -- NULL 31-DEC-4712
37 ,p_formula_outputs IN ff_exec.outputs_t
38 ,p_error_code OUT NOCOPY NUMBER
39 ,p_error_message OUT NOCOPY VARCHAR2
40 );
41 --
42 PROCEDURE delete_absence_plan_details(
43 p_assignment_id IN NUMBER
44 ,p_business_group_id IN NUMBER
45 ,p_legislation_code IN VARCHAR2
46 ,p_effective_date IN DATE
47 ,p_pl_id IN NUMBER
48 ,p_pl_typ_id IN NUMBER
49 ,p_ler_id IN NUMBER
50 ,p_per_in_ler_id IN NUMBER
51 ,p_absence_attendance_id IN NUMBER
52 ,p_effective_start_date IN DATE
53 ,p_effective_end_date IN DATE -- NULL 31-DEC-4712
54 ,p_formula_outputs IN ff_exec.outputs_t
55 ,p_error_code OUT NOCOPY NUMBER
56 ,p_error_message OUT NOCOPY VARCHAR2
57 ,p_element_type_id IN NUMBER DEFAULT NULL
58 );
59
60
61 FUNCTION is_gap_absence_type(
62 p_absence_attendance_type_id IN NUMBER
63 )
64 RETURN NUMBER ;
65
66
67 FUNCTION is_absence_overlapped(
68 p_absence_attendance_id IN NUMBER
69 )
70 RETURN BOOLEAN ;
71
72 END;