1 PACKAGE pqp_gb_unpaid_template AUTHID CURRENT_USER AS
2 /* $Header: pqpgbupd.pkh 120.0 2005/05/29 02:03:26 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 ------------------------------------------------------------------------
10 FUNCTION create_user_template
11 (p_plan_id in number
12 ,p_plan_description in varchar2 default null
13 ,p_abs_days in varchar2
14 ,p_abs_ent_sick_leaves in number
15 ,p_abs_ent_holidays in number
16 ,p_abs_daily_rate_calc_method in varchar2
17 ,p_abs_daily_rate_calc_period in varchar2
18 ,p_abs_daily_rate_calc_divisor in number
19 ,p_abs_working_pattern in varchar2
20 ,p_abs_ele_name in varchar2
21 ,p_abs_ele_reporting_name in varchar2
22 ,p_abs_ele_description in varchar2
23 ,p_abs_ele_processing_priority in number default 500
24 ,p_abs_primary_yn in varchar2 default 'N'
25 ,p_pay_ele_reporting_name in varchar2
26 ,p_pay_ele_description in varchar2 default null
27 ,p_pay_ele_processing_priority in number default 550
28 ,p_pay_src_pay_component in varchar2
29 ,p_ele_eff_start_date in date default null
30 ,p_ele_eff_end_date in date default null
31 ,p_abs_type_lookup_type in varchar2 default null
32 ,p_abs_type_lookup_value in pqp_gb_osp_template.t_abs_types
33 ,p_security_group_id in number default null
34 ,p_bg_id in number
35 )
36 RETURN NUMBER;
37
38 PROCEDURE delete_user_template
39 (p_plan_id in number
40 ,p_business_group_id in number
41 ,p_abs_ele_name in varchar2
42 ,p_abs_ele_type_id in number
43 ,p_abs_primary_yn in varchar2
44 ,p_security_group_id in number
45 ,p_effective_date in date
46 );
47 END pqp_gb_unpaid_template;