[Home] [Help]
PACKAGE: APPS.PAY_IE_PENSION_TEMPLATE
Source
1 Package PAY_IE_Pension_Template AUTHID CURRENT_USER As
2 /* $Header: pyiepend.pkh 120.0.12000000.1 2007/01/17 20:54:27 appldev noship $ */
3 -- Legislation Subgroup Code for all core objects
4 g_template_leg_code VARCHAR2(30):= 'IE';
5 g_template_leg_subgroup VARCHAR2(30);
6
7 -- ---------------------------------------------------------------------
8 -- |--------------------< Create_User_Template_Swi >--------------------|
9 -- ---------------------------------------------------------------------
10 function Create_User_Template_Swi
11 (p_pension_provider_id In Number
12 ,p_pension_type_id In Number
13 ,p_scheme_prefix In Varchar2
14 ,p_reporting_name In Varchar2
15 ,p_prsa2_certificate In Varchar2
16 ,p_third_party In Varchar2
17 ,p_termination_rule In Varchar2
18 ,p_effective_start_date In Date Default Null
19 ,p_effective_end_date In Date Default Null
20 ,p_security_group_id In Number Default Null
21 ,p_business_group_id In Number
22 )
23 return Number;
24
25 -- ---------------------------------------------------------------------
26 -- |------------------< Delete_User_Template_Swi >----------------------|
27 -- ---------------------------------------------------------------------
28 procedure Delete_User_Template_Swi
29 (p_business_group_id In Number
30 ,p_pension_dedn_ele_name In Varchar2
31 ,p_pension_dedn_ele_type_id In Number
32 ,p_security_group_id In Number
33 ,p_effective_date In Date
34 );
35
36 --
37 -- ---------------------------------------------------------------------
38 -- |--------------------< Chk_Scheme_Prefix >---------------------------|
39 -- ---------------------------------------------------------------------
40 Procedure chk_scheme_prefix
41 (p_scheme_prefix_in in Varchar2
42 );
43
44 --
45 -- ---------------------------------------------------------------------
46 -- |--------------------< Get_Object_ID >-------------------------------|
47 -- ---------------------------------------------------------------------
48 function Get_Object_ID (p_object_type in Varchar2,
49 p_object_name in Varchar2,
50 p_business_group_id in Number,
51 p_template_id in Number)
52 return Number;
53
54 --
55 -- ---------------------------------------------------------------------
56 -- |--------------------< Update_Ipval_Defval >------------------------|
57 -- ---------------------------------------------------------------------
58 procedure Update_Ipval_Defval(p_ele_name in Varchar2
59 ,p_ip_name in Varchar2
60 ,p_def_value in Varchar2
61 ,p_business_group_id in Number);
62
63
64 end pay_ie_pension_template;