1 PACKAGE pqp_gb_omp_template AUTHID CURRENT_USER AS
2 /* $Header: pqpgbomd.pkh 115.4 2004/01/06 05:19:37 cchappid noship $ */
3
4 -- Legislation Subgroup Code for all core objects
5 g_template_leg_code VARCHAR2(30):= 'GB';
6 g_template_leg_subgroup VARCHAR2(30);
7
8 /* TYPE rt_abs_types IS RECORD
9 (abs_type_id NUMBER
10 ,abs_type_name PER_ABSENCE_ATTENDANCE_TYPES.NAME%TYPE
11 );
12
13 TYPE t_abs_types IS TABLE OF pqp_gb_osp_template.rt_abs_types
14 INDEX BY BINARY_INTEGER; */
15
16 TYPE t_ele_name IS TABLE OF pay_element_types_f.element_name%TYPE
17 INDEX BY BINARY_INTEGER;
18
19
20 CURSOR csr_get_element_type_id(p_template_id NUMBER) IS
21 SELECT core_object_id element_type_id
22 FROM pay_template_core_objects
23 WHERE template_id = p_template_id
24 and core_object_type = 'ET' ;
25
26 CURSOR csr_get_element_name(p_element_type_id NUMBER)
27 IS
28 SELECT element_name
29 FROM PAY_ELEMENT_TYPES_F
30 WHERE element_type_id = p_element_type_id ;
31
32
33
34 ------------------------------------------------------------------------
35 FUNCTION create_user_template
36 (p_plan_id IN NUMBER
37 ,p_plan_description IN VARCHAR2 DEFAULT NULL
38 ,p_abse_days_def IN VARCHAR2
39 ,p_maternity_abse_ent_udt IN NUMBER
40 ,p_holidays_udt IN NUMBER
41 ,p_daily_rate_calc_method IN VARCHAR2
42 ,p_daily_rate_calc_period IN VARCHAR2
43 ,p_daily_rate_calc_divisor IN NUMBER
44 ,p_working_pattern IN VARCHAR2
45 ,p_los_calc IN VARCHAR2
46 ,p_los_calc_uom IN VARCHAR2
47 ,p_los_calc_duration IN VARCHAR2
48 ,p_avg_earnings_duration IN VARCHAR2
49 ,p_avg_earnings_uom IN VARCHAR2
50 ,p_avg_earnings_balance IN VARCHAR2
51 ,p_pri_ele_name IN VARCHAR2
52 ,p_pri_ele_reporting_name IN VARCHAR2
53 ,p_pri_ele_description IN VARCHAR2
54 ,p_pri_ele_processing_priority IN NUMBER DEFAULT 500
55 ,p_abse_primary_yn IN VARCHAR2 DEFAULT 'N'
56 ,p_pay_ele_reporting_name IN VARCHAR2
57 ,p_pay_ele_description IN VARCHAR2 DEFAULT NULL
58 ,p_pay_ele_processing_priority IN NUMBER DEFAULT 550
59 ,p_pay_src_pay_component IN VARCHAR2
60 ,p_band1_ele_base_name IN VARCHAR2 DEFAULT NULL
61 ,p_band2_ele_base_name IN VARCHAR2 DEFAULT NULL
62 ,p_band3_ele_base_name IN VARCHAR2 DEFAULT NULL
63 ,p_band4_ele_base_name IN VARCHAR2 DEFAULT NULL
64 ,p_effective_start_date IN DATE DEFAULT NULL
65 ,p_effective_end_date IN DATE DEFAULT NULL
66 ,p_abse_type_lookup_type IN VARCHAR2 DEFAULT NULL
67 ,p_abse_type_lookup_value IN PQP_GB_OSP_TEMPLATE.T_ABS_TYPES
68 ,p_security_group_id IN NUMBER DEFAULT NULL
69 ,p_bg_id IN NUMBER
70 )
71 RETURN NUMBER;
72 --
73 PROCEDURE delete_user_template
74 (p_plan_id IN NUMBER
75 ,p_business_group_id IN NUMBER
76 ,p_pri_ele_name IN VARCHAR2
77 ,p_abse_ele_type_id IN NUMBER
78 ,p_abse_primary_yn IN VARCHAR2
79 ,p_security_group_id IN NUMBER
80 ,p_effective_date IN DATE
81 );
82
83 PROCEDURE create_element_links
84 ( p_business_group_id IN NUMBER
85 ,p_effective_start_date IN DATE
86 ,p_effective_end_date IN DATE
87 --,p_legislation_code IN VARCHAR2
88 --,p_base_name IN VARCHAR2
89 --,p_abs_type IN VARCHAR2
90 ,p_template_id IN NUMBER
91 ) ;
92
93 PROCEDURE delete_element_links
94 ( p_business_group_id IN NUMBER
95 ,p_effective_start_date IN DATE
96 ,p_effective_end_date IN DATE
97 --,p_base_name IN VARCHAR2
98 --,p_abs_type IN VARCHAR2
99 ,p_template_id IN NUMBER
100 ) ;
101 --
102 PROCEDURE check_ben_standard_rates_link (
103 p_business_group_id IN NUMBER
104 ,p_plan_id IN NUMBER
105 ,p_element_type_id IN NUMBER ) ;
106
107 END pqp_gb_omp_template;