1 PACKAGE pqp_gb_osp_template AS
2 /* $Header: pqpgbosd.pkh 120.0 2005/05/29 02:00:25 appldev noship $ */
3
4
5 -- Legislation Subgroup Code for all core objects
6 g_template_leg_code VARCHAR2(30):= 'GB';
7 g_template_leg_subgroup VARCHAR2(30);
8
9 TYPE rt_abs_types IS RECORD
10 (abs_type_id NUMBER
11 ,abs_type_name per_absence_attendance_types.name%TYPE
12 );
13
14 TYPE t_abs_types IS TABLE OF rt_abs_types
15 INDEX BY BINARY_INTEGER;
16
17 -- LG
18 TYPE rt_plan_types IS RECORD
19 (plan_type_id ben_pl_typ_f.PL_TYP_ID%TYPE
20 ,name ben_pl_typ_f.name%TYPE
21 );
22
23 TYPE t_plan_types IS TABLE OF rt_plan_types
24 INDEX BY BINARY_INTEGER;
25
26 -- LG
27
28 ------------------------------------------------------------------------
29 FUNCTION create_user_template
30 (p_plan_id in number
31 ,p_plan_description in varchar2 default null
32 ,p_sch_cal_type in varchar2
33 ,p_sch_cal_duration in number
34 ,p_sch_cal_uom in varchar2
35 ,p_sch_cal_start_date in date
36 ,p_sch_cal_end_date in date
37 ,p_abs_days in varchar2
38 ,p_abs_ent_sick_leaves in number
39 ,p_abs_ent_holidays in number
40 ,p_abs_daily_rate_calc_method in varchar2
41 ,p_abs_daily_rate_calc_period in varchar2
42 ,p_abs_daily_rate_calc_divisor in number
43 ,p_abs_working_pattern in varchar2
44 ,p_abs_overlap_rule in varchar2
45 ,p_abs_ele_name in varchar2
46 ,p_abs_ele_reporting_name in varchar2
47 ,p_abs_ele_description in varchar2
48 ,p_abs_ele_processing_priority in number default 500
49 ,p_abs_primary_yn in varchar2 default 'N'
50 ,p_pay_ele_reporting_name in varchar2
51 ,p_pay_ele_description in varchar2 default null
52 ,p_pay_ele_processing_priority in number default 550
53 ,p_pay_src_pay_component in varchar2
54 ,p_bnd1_ele_sub_name in varchar2 default null
55 ,p_bnd2_ele_sub_name in varchar2 default null
56 ,p_bnd3_ele_sub_name in varchar2 default null
57 ,p_bnd4_ele_sub_name in varchar2 default null
58 ,p_ele_eff_start_date in date default null
59 ,p_ele_eff_end_date in date default null
60 ,p_abs_type_lookup_type in varchar2 default null
61 ,p_abs_type_lookup_value in t_abs_types
62 ,p_security_group_id in number default null
63 ,p_bg_id in number
64 ,p_plan_type_lookup_type in varchar2 default null -- LG
65 ,p_plan_type_lookup_value in t_plan_types -- LG
66 ,p_enable_ent_proration in varchar2 default null -- LG
67 ,p_scheme_type in varchar2 default null -- LG
68 ,p_abs_schedule_wp in varchar2 default null -- LG
69 ,p_dual_rolling_duration in number default null
70 ,p_dual_rolling_UOM in varchar2 default null
71 ,p_ft_round_config in varchar2 default null
72 ,p_pt_round_config in varchar2 default null
73 )
74 RETURN NUMBER;
75 --
76 PROCEDURE delete_user_template
77 (p_plan_id in number
78 ,p_business_group_id in number
79 ,p_abs_ele_name in varchar2
80 ,p_abs_ele_type_id in number
81 ,p_abs_primary_yn in varchar2
82 ,p_security_group_id in number
83 ,p_effective_date in date
84 );
85
86 --
87
88 PROCEDURE create_udt_entry
89 (p_bg_id IN NUMBER
90 ,p_band IN VARCHAR2
91 ,p_entit IN VARCHAR2
92 ,p_lower IN VARCHAR2
93 ,p_user_tbl_id IN NUMBER
94 );
95 --
96 PROCEDURE create_gap_lookup (p_security_group_id IN NUMBER
97 ,p_ele_eff_start_date IN DATE
98 ,p_lookup_type IN VARCHAR2
99 ,p_lookup_meaning IN VARCHAR2
100 ,p_lookup_values IN t_abs_types
101 ) ;
102
103 PROCEDURE automate_plan_setup
104 (p_pl_id IN NUMBER
105 ,p_business_group_id IN NUMBER
106 ,p_element_type_id IN NUMBER --
107 ,p_effective_date IN DATE
108 ,p_base_name IN VARCHAR2
109 ,p_plan_class IN VARCHAR2 DEFAULT 'OSP'
110 );
111
112 PROCEDURE del_automated_plan_setup_data
113 (p_pl_id IN NUMBER
114 ,p_business_group_id IN NUMBER
115 ,p_effective_date IN DATE
116 ,p_base_name IN VARCHAR2
117 );
118
119 END pqp_gb_osp_template;