1 PACKAGE pay_es_calc_ss_earnings AS
2 /* $Header: pyesssec.pkh 120.4 2005/08/05 02:44:07 viviswan noship $ */
3 --
4 FUNCTION get_defined_bal_id(p_bal_name IN VARCHAR2
5 ,p_db_item_suffix IN VARCHAR2) RETURN NUMBER ;
6 --
7 FUNCTION Get_Absence_Details(p_absence_attendance_id IN NUMBER
8 ,p_sickness_reason OUT NOCOPY VARCHAR2
9 ,p_sickness_category OUT NOCOPY VARCHAR2
10 ,p_temp_dis_start_date OUT NOCOPY DATE
11 ,p_sickness_end OUT NOCOPY DATE
12 ,p_info_1 OUT NOCOPY VARCHAR2
13 ,p_info_2 OUT NOCOPY VARCHAR2
14 ,p_info_3 OUT NOCOPY VARCHAR2
15 ,p_info_4 OUT NOCOPY VARCHAR2
16 ,p_info_5 OUT NOCOPY VARCHAR2
17 ,p_info_6 OUT NOCOPY VARCHAR2
18 ,p_info_7 OUT NOCOPY VARCHAR2
19 ,p_info_8 OUT NOCOPY VARCHAR2) RETURN VARCHAR2;
20
21 --
22 FUNCTION Get_Contribution_Days(p_date_earned IN DATE
23 ,p_no_of_months IN NUMBER) RETURN NUMBER ;
24 --
25 FUNCTION get_person_gender(p_assignment_id IN NUMBER
26 ,p_date_earned IN DATE) RETURN VARCHAR2 ;
27 --
28 FUNCTION get_days_prev_year(p_date_earned IN DATE) RETURN NUMBER ;
29 --
30 FUNCTION get_ss_contribution_days(p_assignment_id IN NUMBER
31 ,p_balance_name IN VARCHAR2
32 ,p_database_item_suffix IN VARCHAR2
33 ,p_virtal_date IN DATE
34 ,p_span_years IN NUMBER)RETURN NUMBER ;
35 --
36 FUNCTION get_linked_absence_details(p_absence_attendance_id IN NUMBER
37 ,p_disability_start_date IN DATE) RETURN NUMBER;
38 --
39 FUNCTION get_no_children(passignment_id IN NUMBER
40 ,pbusiness_gr_id IN NUMBER
41 ,peffective_date IN DATE)RETURN NUMBER;
42 --
43 FUNCTION get_benefit_slabs(p_assignment_id IN NUMBER
44 ,p_business_group_id IN NUMBER
45 ,p_absence_attendance_id IN NUMBER
46 ,p_disability_start_date IN DATE
47 ,p_Start_Date IN DATE
48 ,p_End_Date IN DATE
49 ,p_Work_Pattern IN VARCHAR2
50 ,p_Slab_1_high IN NUMBER
51 ,p_Slab_2_high IN NUMBER
52 ,p_Slab_SSA_high IN NUMBER
53 ,p_Days_Passed_By IN NUMBER
54 ,p_Disability_in_current IN VARCHAR2
55 ,p_Link_Days OUT NOCOPY NUMBER
56 ,p_Withheld_Days OUT NOCOPY NUMBER
57 ,p_Lower_Days OUT NOCOPY NUMBER
58 ,p_Higher_Days OUT NOCOPY NUMBER
59 ,p_Lower_BR_Days OUT NOCOPY NUMBER
60 ,p_Higher_BR_Days OUT NOCOPY NUMBER) RETURN NUMBER ;
61 --
62 FUNCTION get_contract_working_hours(p_assignment_id IN NUMBER
63 ,p_business_group_id IN NUMBER
64 ,p_Start_Date IN DATE) RETURN NUMBER;
65 --
66 FUNCTION Maternity_Validations(p_absence_attendance_id IN NUMBER
67 ,p_benefit_days OUT NOCOPY NUMBER) RETURN VARCHAR2;
68 --
69 FUNCTION get_wc_nd_sd_pu_info(p_work_center IN NUMBER
70 ,p_date_between IN DATE
71 ,p_PU IN VARCHAR2
72 ,p_end_date OUT NOCOPY DATE
73 ,p_part_unemp_perc OUT NOCOPY NUMBER
74 ,p_start_date OUT NOCOPY DATE
75 ,p_Cal_method OUT NOCOPY VARCHAR2
76 ,p_Rate_formula OUT NOCOPY VARCHAR2
77 ,p_Duration_Formula OUT NOCOPY VARCHAR2) RETURN VARCHAR2;
78 --
79 FUNCTION get_wc_pu_info(p_work_center IN NUMBER
80 ,p_period_start_date IN DATE
81 ,p_period_end_date IN DATE
82 ,p_end_date OUT NOCOPY DATE
83 ,p_part_unemp_perc OUT NOCOPY NUMBER
84 ,p_start_date OUT NOCOPY DATE
85 ,p_Cal_method OUT NOCOPY VARCHAR2
86 ,p_Rate_formula OUT NOCOPY VARCHAR2
87 ,p_Duration_Formula OUT NOCOPY VARCHAR2) RETURN VARCHAR2;
88 --
89 FUNCTION get_bu_info(p_assignment_id IN NUMBER
90 ,p_business_gr_id IN NUMBER
91 ,p_date_earned IN DATE
92 ,p_abs_cat IN VARCHAR2
93 ,p_Total_Days IN NUMBER
94 ,p_bu_calc_method_e IN VARCHAR2
95 ,p_bu_daily_rate_e IN VARCHAR2
96 ,p_bu_duration_e IN VARCHAR2
97 ,p_start_date IN DATE
98 ,p_end_date IN DATE
99 ,p_Daily_Value_Base IN NUMBER
100 ,p_Link_Duration_Days IN NUMBER
101 ,p_Days_Passed_By OUT NOCOPY NUMBER
102 ,p_Benefit_Uplift OUT NOCOPY NUMBER
103 ,p_Gross_Pay_Per_Days OUT NOCOPY NUMBER
104 ,p_rate1 OUT NOCOPY NUMBER
105 ,p_value1 OUT NOCOPY NUMBER
106 ,p_rate2 OUT NOCOPY NUMBER
107 ,p_value2 OUT NOCOPY NUMBER
108 ,p_rate3 OUT NOCOPY NUMBER
109 ,p_value3 OUT NOCOPY NUMBER
110 ,p_rate4 OUT NOCOPY NUMBER
111 ,p_value4 OUT NOCOPY NUMBER
112 ,p_rate5 OUT NOCOPY NUMBER
113 ,p_value5 OUT NOCOPY NUMBER
114 ,p_rate6 OUT NOCOPY NUMBER
115 ,p_value6 OUT NOCOPY NUMBER
116 ,p_rate7 OUT NOCOPY NUMBER
117 ,p_value7 OUT NOCOPY NUMBER
118 ,p_rate8 OUT NOCOPY NUMBER
119 ,p_value8 OUT NOCOPY NUMBER
120 ,p_rate9 OUT NOCOPY NUMBER
121 ,p_value9 OUT NOCOPY NUMBER
122 ,p_rate10 OUT NOCOPY NUMBER
123 ,p_value10 OUT NOCOPY NUMBER
124 ,p_work_center IN NUMBER
125 ,p_pattern IN VARCHAR2
126 ,p_percentage IN NUMBER) RETURN VARCHAR2;
127 --
128 FUNCTION get_pu_contribution_value(p_assignment_id IN NUMBER
129 ,p_assignment_action_id IN NUMBER
130 ,p_balance_SS IN VARCHAR2
131 ,p_database_item_SS IN VARCHAR2
132 ,p_balance_PU IN VARCHAR2
133 ,p_database_item_PU IN VARCHAR2
134 ,p_PU_start_date IN DATE
135 ,p_span_days IN NUMBER
136 ,p_ss_days OUT NOCOPY NUMBER)RETURN NUMBER;
137 --
138 --
139 END pay_es_calc_ss_earnings;