1 package pay_us_dedn_template_wrapper AUTHID CURRENT_USER as
2 /* $Header: pytmpdde.pkh 120.1 2005/07/28 18:32:58 rpinjala noship $ */
3 -- =============================================================================
4 -- create_deduction_element
5 -- =============================================================================
6 Function create_deduction_element
7 (p_element_name in varchar2
8 ,p_reporting_name in varchar2
9 ,p_description in varchar2 default null
10 ,p_classification_name in varchar2
11 ,p_ben_class_id in number default null
12 ,p_category in varchar2
13 ,p_processing_type in varchar2
14 ,p_processing_priority in number default null
15 ,p_standard_link_flag in varchar2 default 'N'
16 ,p_processing_runtype in varchar2
17 ,p_start_rule in varchar2
18 ,p_stop_rule in varchar2
19 ,p_amount_rule in varchar2
20 ,p_series_ee_bond in varchar2
21 ,p_payroll_table in varchar2
22 ,p_paytab_column in varchar2
23 ,p_rowtype_meaning in varchar2
24 ,p_arrearage in varchar2
25 ,p_deduct_partial in varchar2
26 ,p_employer_match in varchar2 default 'N'
27 ,p_aftertax_component in varchar2 default 'N'
28 ,p_ele_eff_start_date in date default null
29 ,p_ele_eff_end_date in date default null
30 ,p_business_group_id in number
31 ,p_srs_plan_type in varchar2 default 'N'
32 ,p_srs_buy_back in varchar2 default 'N'
33 ,p_roth_contribution in varchar2 default 'N'
34 ,p_userra_contribution in varchar2 default 'N'
35 ,p_catchup_processing in varchar2 default 'NONE'
36 ,p_termination_rule in varchar2 default 'F'
37 )
38 Return Number;
39 -- =============================================================================
40 -- delete_deduction_element
41 -- =============================================================================
42 Procedure delete_deduction_element
43 (p_business_group_id in number
44 ,p_element_type_id in number
45 ,p_element_name in varchar2
46 ,p_classification_name in varchar2
47 ,p_category in varchar2
48 ,p_processing_priority in number
49 ,p_amount_rule in varchar2
50 ,p_series_ee_bond in varchar2
51 ,p_arrearage in varchar2
52 ,p_stop_rule in varchar2
53 ,p_calculation_ele_id in number
54 ,p_vol_dedns_baltype_id in number
55 ,p_primary_baltype_id in number
56 ,p_accrued_baltype_id in number
57 ,p_arrears_baltype_id in number
58 ,p_not_taken_baltype_id in number
59 ,p_tobondpurch_baltype_id in number
60 ,p_able_baltype_id in number
61 ,p_additional_baltype_id in number
62 ,p_replacement_baltype_id in number
63 ,p_special_inputs_ele_id in number
64 ,p_special_features_ele_id in number
65 ,p_verifier_ele_id in number
66 ,p_eff_start_date in date
67 ,p_eff_end_date in date
68 );
69
70 End pay_us_dedn_template_wrapper;