1 PACKAGE pqp_uk_union_template AS
2 /* $Header: pqgbundt.pkh 120.1 2005/05/30 00:12:36 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_frm_union_name IN VARCHAR2
11 -- Convert to Org_ID = Extra Element Info #1
12 ,p_frm_element_name IN VARCHAR2
13 -- <BASENAME>
14 ,p_frm_reporting_name IN VARCHAR2
15 -- IF NULL THEN = <BASENAME>
16 ,p_frm_description IN VARCHAR2 DEFAULT NULL
17 --
18 -- ,p_frm_classification IN VARCHAR2
19 -- Always 'Voluntary Deduction'
20 ,p_frm_processing_type IN VARCHAR2
21 -- 'N'on-Recurring or 'R'ecurring
22 ,p_frm_override_amount IN VARCHAR2 DEFAULT 'N'
23 -- 'Y'es/'N'o
24 ,p_frm_tax_relief IN VARCHAR2 DEFAULT 'N'
25 -- 'Y'es/'N'o
26 ,p_frm_supplementary_levy IN VARCHAR2 DEFAULT 'N'
27 -- 'Y'es/'N'o
28 ,p_frm_union_level_balance IN VARCHAR2
29 -- Mandatory
30 ,p_frm_union_level_balance_yn IN VARCHAR2
31 -- Mandatory 'Y'es/'N'o
32 ,p_frm_rate_type IN VARCHAR2 DEFAULT NULL
33 -- Extra Element Info #2
34 ,p_frm_fund_list IN VARCHAR2 DEFAULT NULL
35 -- Name of the Lookup Type for funds selected
36 ,p_frm_effective_start_date IN DATE DEFAULT NULL
37 -- Standard
38 ,p_frm_effective_end_date IN DATE DEFAULT NULL
39 -- Standard
40 ,p_frm_business_group_id IN NUMBER
41 -- Standard Business Group ID
42 )
43 RETURN NUMBER; -- The union element type core object id
44 --
45 PROCEDURE delete_user_template
46 (p_frm_union_name IN VARCHAR2
47 ,p_frm_union_level_balance IN VARCHAR2
48 ,p_frm_element_type_id IN NUMBER
49 ,p_frm_element_name IN VARCHAR2
50 ,p_frm_business_group_id IN NUMBER
51 ,p_frm_effective_date IN DATE
52 );
53 --
54 END pqp_uk_union_template;