1 package pqp_uk_vehicle_template as
2 /* $Header: pqukcmtp.pkh 120.0 2005/05/29 02:13:02 appldev noship $ */
3
4
5 -- Legislation Subgroup Code for all template elements.
6 g_template_leg_code VARCHAR2(30) := 'GB';
7 g_template_leg_subgroup VARCHAR2(30);
8 ------------------------------------------------------------------------
9 FUNCTION create_user_template
10 (p_ele_name in varchar2
11 ,p_ele_reporting_name in varchar2
12 ,p_ele_description in varchar2 default NULL
13 ,p_ele_classification in varchar2
14 ,p_ele_processing_type in varchar2
15 ,p_ele_priority in number default NULL
16 ,p_ele_standard_link in varchar2 default 'N'
17 ,p_veh_type in varchar2
18 ,p_table_indicator_flg in varchar2
19 ,p_table_name in varchar2
20 ,p_ele_eff_start_date in date default NULL
21 ,p_ele_eff_end_date in date default NULL
22 ,p_bg_id in number
23 )
24 RETURN NUMBER ;
25 --
26 PROCEDURE delete_user_template
27 (p_business_group_id in number
28 ,p_ele_type_id in number
29 ,p_ele_name in varchar2
30 ,p_effective_date in date
31 );
32
33 --
34 END pqp_uk_vehicle_template ;