1 PACKAGE pay_us_iSetup_earn_dedn AS
2 /* $Header: pyusisetup.pkh 120.4 2005/08/25 19:29:39 ndorai noship $ */
3 -----------------------------------------------------------------------------
4 -- CREATE_ISETUP_EARN_ELEMENT
5 -----------------------------------------------------------------------------
6 FUNCTION create_isetup_earn_element
7 (p_ele_name in varchar2
8 ,p_ele_reporting_name in varchar2
9 ,p_ele_description in varchar2
10 ,p_ele_classification in varchar2
11 ,p_ele_category in varchar2
12 ,p_ele_ot_base in varchar2
13 ,p_flsa_hours in varchar2
14 ,p_ele_processing_type in varchar2
15 ,p_ele_priority in number
16 ,p_ele_standard_link in varchar2
17 ,p_ele_calc_ff_id in number
18 ,p_ele_calc_ff_name in varchar2
19 ,p_sep_check_option in varchar2
20 ,p_dedn_proc in varchar2
21 ,p_mix_flag in varchar2
22 ,p_reduce_regular in varchar2
23 ,p_ele_eff_start_date in date
24 ,p_ele_eff_end_date in date
25 ,p_alien_supp_category in varchar2
26 ,p_bg_id in number
27 ,p_termination_rule in varchar2 default 'F'
28 ,p_grossup_chk in varchar2
29 ,p_legislation_code in varchar2
30 )
31 RETURN NUMBER;
32 -----------------------------------------------------------------------------
33 -- CREATE_ISETUP_DEDN_ELEMENT
34 -----------------------------------------------------------------------------
35
36 FUNCTION create_isetup_dedn_element
37 (p_element_name in varchar2
38 ,p_reporting_name in varchar2
39 ,p_description in varchar2 default NULL
40 ,p_classification_name in varchar2
41 ,p_ben_class_id in number default NULL
42 ,p_category in varchar2
43 ,p_processing_type in varchar2
44 ,p_processing_priority in number default NULL
45 ,p_standard_link_flag in varchar2 default 'N'
46 ,p_processing_runtype in varchar2
47 ,p_start_rule in varchar2
48 ,p_stop_rule in varchar2
49 ,p_amount_rule in varchar2
50 ,p_series_ee_bond in varchar2
51 ,p_payroll_table in varchar2
52 ,p_paytab_column in varchar2
53 ,p_rowtype_meaning in varchar2
54 ,p_arrearage in varchar2
55 ,p_deduct_partial in varchar2
56 ,p_employer_match in varchar2 default 'N'
57 ,p_aftertax_component in varchar2 default 'N'
58 ,p_ele_eff_start_date in date default NULL
59 ,p_ele_eff_end_date in date default NULL
60 ,p_business_group_id in number
61 ,p_srs_plan_type in varchar2 default 'N'
62 ,p_srs_buy_back in varchar2 default 'N'
63 ,p_catchup_processing in varchar2 default 'NONE'
64 ,p_termination_rule in varchar2 default 'F'
65 )
66 RETURN NUMBER;
67 --
68 --
69 --
70 --
71 PROCEDURE compile_formula
72 (p_element_type_id IN NUMBER);
73 --
74 --
75 PROCEDURE compile_mig_formula
76 (p_formula_id IN NUMBER);
77 --
78 --
79 PROCEDURE bulk_compile_formula;
80 --
81 --
82 FUNCTION uncompiled_formula return number;
83 --PROCEDURE uncompiled_formula;
84 --
85 --
86 END pay_us_iSetup_earn_dedn;