DBA Data[Home] [Help]

PACKAGE: APPS.PQP_UK_VEHICLE_TEMPLATE

Source


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 ;