[Home] [Help]
PACKAGE: APPS.PQP_NL_PENSION_TEMPLATE
Source
1 Package PQP_NL_Pension_Template As
2 /* $Header: pqpnlped.pkh 120.0.12000000.1 2007/01/16 04:24:17 appldev noship $ */
3
4 -- Legislation Subgroup Code for all core objects
5 g_template_leg_code VARCHAR2(30):= 'NL';
6 g_template_leg_subgroup VARCHAR2(30);
7
8 -- ---------------------------------------------------------------------
9 -- |--------------------< Create_User_Template_Swi >--------------------|
10 -- ---------------------------------------------------------------------
11 function Create_User_Template_Swi
12 (p_pension_category In Varchar2
13 ,p_eligibility_model In Varchar2
14 ,p_pension_provider_id In Number
15 ,p_pension_type_id In Number
16 ,p_pension_plan_id In Number Default Null
17 ,p_deduction_method In Varchar2
18 ,p_arrearage_flag In Varchar2
19 ,p_partial_deductions_flag In Varchar2 Default 'N'
20 ,p_employer_component In Varchar2
21 ,p_scheme_prefix In Varchar2
22 ,p_reporting_name In Varchar2
23 ,p_scheme_description In Varchar2
24 ,p_termination_rule In Varchar2
25 ,p_standard_link In Varchar2
26 ,p_effective_start_date In Date Default Null
27 ,p_effective_end_date In Date Default Null
28 ,p_security_group_id In Number Default Null
29 ,p_business_group_id In Number
30 )
31 return Number;
32
33 -- ---------------------------------------------------------------------
34 -- |------------------< Delete_User_Template_Swi >----------------------|
35 -- ---------------------------------------------------------------------
36 procedure Delete_User_Template_Swi
37 (p_pension_plan_id In Number Default Null
38 ,p_business_group_id In Number
39 ,p_pension_dedn_ele_name In Varchar2
40 ,p_pension_dedn_ele_type_id In Number
41 ,p_security_group_id In Number
42 ,p_effective_date In Date
43 );
44
45 --
46 -- ---------------------------------------------------------------------
47 -- |--------------------< Compile_Formula >-----------------------------|
48 -- ---------------------------------------------------------------------
49
50 procedure Compile_Formula
51 (p_element_type_id in Number
52 ,p_effective_start_date in Date
53 ,p_scheme_prefix in Varchar2
54 ,p_business_group_id in Number
55 ,p_request_id out nocopy Number
56 );
57
58 --
59 -- ---------------------------------------------------------------------
60 -- |--------------------< Chk_Scheme_Prefix >---------------------------|
61 -- ---------------------------------------------------------------------
62 Procedure chk_scheme_prefix
63 (p_scheme_prefix_in in Varchar2
64 );
65
66 --
67 -- ---------------------------------------------------------------------
68 -- |--------------------< Get_Object_ID >-------------------------------|
69 -- ---------------------------------------------------------------------
70 function Get_Object_ID (p_object_type in Varchar2,
71 p_object_name in Varchar2,
72 p_business_group_id in Number,
73 p_template_id in Number)
74 return Number;
75
76 --
77 -- ---------------------------------------------------------------------
78 -- |--------------------< Get_Formula_Id >------------------------------|
79 -- ---------------------------------------------------------------------
80 function Get_Formula_Id (p_formula_name IN VARCHAR2
81 ,p_business_group_id IN NUMBER)
82 return Number;
83
84 --
85 -- ---------------------------------------------------------------------
86 -- |--------------------< Update_Ipval_Defval >------------------------|
87 -- ---------------------------------------------------------------------
88 procedure Update_Ipval_Defval(p_ele_name in Varchar2
89 ,p_ip_name in Varchar2
90 ,p_def_value in Varchar2
91 ,p_business_group_id in Number);
92
93
94 end pqp_nl_pension_template;