1 PACKAGE pqp_gb_absence_plan_process AUTHID CURRENT_USER AS
2 /* $Header: pqgbabpr.pkh 115.5 2003/07/17 05:48:23 rrazdan noship $ */
3
4 CURSOR csr_absence_pay_plan_category(p_pl_id NUMBER)
5 IS
6 SELECT eit.eei_information30 -- Absence Pay Plan Category
7 absence_pay_plan_category
8 FROM pay_element_type_extra_info eit
9 WHERE UPPER(eit.eei_information19) = 'ABSENCE INFO'
10 AND eit.information_type IN -- either
11 ('PQP_GB_OSP_ABSENCE_PLAN_INFO', 'PQP_GB_OMP_ABSENCE_PLAN_INFO')
12 AND eit.eei_information1 = fnd_number.number_to_canonical(p_pl_id)
13 AND ROWNUM < 2; -- any element will do
14 --
15 --
16 --
17 CURSOR csr_abs_plan_category_by_eid(p_element_type_id NUMBER) IS
18 SELECT eit.eei_information30 absence_pay_plan_category
19 FROM pay_element_type_extra_info eit
20 WHERE eit.element_type_id = p_element_type_id
21 AND ( -- is OSP Primary Element
22 ( eit.information_type = 'PQP_GB_OSP_ABSENCE_PLAN_INFO'
23 AND
24 eit.eei_information16 = 'Y' -- primary OSP
25 )
26 OR -- is OMP Primary Element
27 ( eit.information_type = 'PQP_GB_OMP_ABSENCE_PLAN_INFO'
28 AND
29 eit.eei_information17 = 'Y' -- primary OMP
30 )
31 )
32 AND UPPER(eit.eei_information19) = 'ABSENCE INFO';
33 --
34 --
35 --
36 PROCEDURE create_absence_plan_details(
37 p_person_id IN NUMBER
38 ,p_assignment_id IN NUMBER
39 ,p_business_group_id IN NUMBER
40 ,p_legislation_code IN VARCHAR2
41 ,p_effective_date IN DATE
42 ,p_element_type_id IN NUMBER
43 ,p_effective_start_date IN DATE
44 ,p_effective_end_date IN DATE
45 ,p_pl_id IN NUMBER
46 ,p_pl_typ_id IN NUMBER
47 ,p_ler_id IN NUMBER
48 ,p_per_in_ler_id IN NUMBER
49 ,p_absence_attendance_id IN NUMBER
50 ,p_absence_date_start IN DATE
51 ,p_absence_date_end IN DATE
52 ,p_formula_outputs IN ff_exec.outputs_t
53 ,p_error_code OUT NOCOPY NUMBER
54 ,p_error_message OUT NOCOPY VARCHAR2
55 );
56
57 PROCEDURE update_absence_plan_details(
58 p_person_id IN NUMBER
59 ,p_assignment_id IN NUMBER
60 ,p_business_group_id IN NUMBER
61 ,p_legislation_code IN VARCHAR2
62 ,p_effective_date IN DATE
63 ,p_element_type_id IN NUMBER
64 ,p_effective_start_date IN DATE
65 ,p_effective_end_date IN DATE
66 ,p_pl_id IN NUMBER
67 ,p_pl_typ_id IN NUMBER
68 ,p_ler_id IN NUMBER
69 ,p_per_in_ler_id IN NUMBER
70 ,p_absence_attendance_id IN NUMBER
71 ,p_absence_date_start IN DATE
72 ,p_absence_date_end IN DATE
73 ,p_formula_outputs IN ff_exec.outputs_t
74 ,p_error_code OUT NOCOPY NUMBER
75 ,p_error_message OUT NOCOPY VARCHAR2
76 );
77
78 PROCEDURE delete_absence_plan_details(
79 p_assignment_id IN NUMBER
80 ,p_business_group_id IN NUMBER
81 ,p_legislation_code IN VARCHAR2
82 ,p_effective_date IN DATE
83 ,p_pl_id IN NUMBER
84 ,p_pl_typ_id IN NUMBER
85 ,p_ler_id IN NUMBER
86 ,p_per_in_ler_id IN NUMBER
87 ,p_absence_attendance_id IN NUMBER
88 ,p_effective_start_date IN DATE
89 ,p_effective_end_date IN DATE
90 ,p_formula_outputs IN ff_exec.outputs_t
91 ,p_error_code OUT NOCOPY NUMBER
92 ,p_error_message OUT NOCOPY VARCHAR2
93 ,p_element_type_id IN NUMBER DEFAULT NULL
94 );
95 END;