1 PACKAGE pqp_gb_professional_body_temp AS
2 /* $Header: pqgbpbtp.pkh 120.1 2005/05/30 00:12:18 rvishwan 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 FUNCTION create_user_template
10 (p_professional_body_name in varchar2
11 ,p_ele_name in varchar2
12 ,p_ele_reporting_name in varchar2
13 ,p_ele_description in varchar2 default null
14 ,p_ele_processing_type in varchar2
15 ,p_ele_third_party_payment in varchar2 default 'Y'
16 ,p_override_amount in varchar2 default 'N'
17 ,p_professional_body_level_bal in varchar2
18 ,p_professional_body_level_yn in varchar2
19 ,p_ele_eff_start_date in date default null
20 ,p_ele_eff_end_date in date default null
21 ,p_bg_id in number
22 )
23 RETURN NUMBER;
24 --
25 PROCEDURE delete_user_template
26 (p_professional_body_name in varchar2
27 ,p_professional_body_level_bal in varchar2
28 ,p_business_group_id in number
29 ,p_ele_type_id in number
30 ,p_ele_name in varchar2
31 ,p_effective_date in date
32 );
33 --
34 END pqp_gb_professional_body_temp;