1 package pay_ae_general AUTHID CURRENT_USER as
2 /* $Header: pyaegenr.pkh 120.4.12020000.3 2013/02/07 11:54:31 bkeshary ship $ */
3
4 --
5 --
6
7
8 ------------------------------------------------------------------------
9 -- Function LOCAL_NATNATIONALITY_NOT_DEFINED
10 ------------------------------------------------------------------------
11 function local_nationality_not_defined return varchar2;
12 ------------------------------------------------------------------------
13 -- Function LOCAL_NATNATIONALITY_MATCHES
14 ------------------------------------------------------------------------
15 function local_nationality_matches
16 (p_assignment_id IN per_all_assignments_f.assignment_id%type,
17 p_date_earned IN Date)
18 return varchar2;
19
20 ------------------------------------------------------------------------
21 -- Function GET_LOCAL_NATIONALITY
22 ------------------------------------------------------------------------
23 function get_local_nationality return varchar2;
24 ------------------------------------------------------------------------
25
26 ------------------------------------------------------------------------
27 -- Function GET_PERSON_NATIONALITY
28 ------------------------------------------------------------------------
29 function get_person_nationality
30 ( p_assignment_id IN per_all_assignments_f.assignment_id%type,
31 p_date_earned IN Date) RETURN varchar2;
32
33 ------------------------------------------------------------------------
34
35 -- Function GET_SECTOR
36 ------------------------------------------------------------------------
37 function get_sector (p_tax_unit_id IN NUMBER) return varchar2;
38 ------------------------------------------------------------------------
39 -- Function GET_MESSAGE
40 ------------------------------------------------------------------------
41 function get_message
42 (p_product in varchar2
43 ,p_message_name in varchar2
44 ,p_token1 in varchar2 default null
45 ,p_token2 in varchar2 default null
46 ,p_token3 in varchar2 default null)
47 return varchar2;
48 ------------------------------------------------------------------------
49 -- Function GET_TABLE_BANDS
50 ------------------------------------------------------------------------
51 function get_table_bands
52 (p_Date_Earned IN DATE
53 ,p_table_name in varchar2
54 ,p_return_type in varchar2) return number;
55
56 -----------------------------------------------------------
57 -- Functions for EFT file
58 -----------------------------------------------------------
59 --
60 FUNCTION get_parameter (
61 p_parameter_string in varchar2
62 ,p_token in varchar2
63 ,p_segment_number in number default null) RETURN varchar2;
64 --
65 FUNCTION chk_multiple_assignments(p_effective_date IN DATE
66 ,p_person_id IN NUMBER) RETURN VARCHAR2;
67 --
68 function get_count RETURN NUMBER;
69 --
70 function get_total_sum RETURN NUMBER;
71 --
72 function get_credit_sum RETURN NUMBER;
73 --
74 function get_debit_sum RETURN NUMBER;
75 --
76 function chk_tran_code (p_value IN VARCHAR2) RETURN VARCHAR2;
77 --
78 ------------------------------------------------------------------------
79 -- Function get_contract
80 ------------------------------------------------------------------------
81 function get_contract
82 (p_assignment_id IN per_all_assignments_f.assignment_id%type,
83 p_date_earned IN Date)
84 return varchar2;
85
86 ------------------------------------------------------------------------
87 -- Function get_probation_period
88 ------------------------------------------------------------------------
89 function get_probation_period
90 (p_assignment_id IN per_all_assignments_f.assignment_id%type,
91 p_date_earned IN Date)
92 return date;
93
94 ------------------------------------------------------------------------
95 -- Function get_contract_expiry_status
96 ------------------------------------------------------------------------
97 function get_contract_expiry_status
98 (p_assignment_id IN per_all_assignments_f.assignment_id%type,
99 p_date_earned IN Date)
100 return varchar2;
101 ------------------------------------------------------------------------
102 -- Function get_termination_initiator
103 ------------------------------------------------------------------------
104 function get_termination_initiator
105 (p_assignment_id IN per_all_assignments_f.assignment_id%type,
106 p_date_earned IN Date)
107 return varchar2;
108
109 ------------------------------------------------------------------------
110 -- Function user_gratuity_formula_exists
111 ------------------------------------------------------------------------
112 function user_gratuity_formula_exists
113 (p_assignment_id IN per_all_assignments_f.assignment_id%type,
114 p_date_earned IN Date)
115 return varchar2;
116
117 --
118 ------------------------------------------------------------------------
119 -- Function run_gratuity_formula
120 ------------------------------------------------------------------------
121 function run_gratuity_formula
122 (p_assignment_id IN NUMBER
123 ,p_date_earned IN DATE
124 ,p_business_group_id IN NUMBER
125 ,p_payroll_id IN NUMBER
126 ,p_payroll_action_id IN NUMBER
127 ,p_assignment_action_id IN NUMBER
128 ,p_tax_unit_id IN NUMBER
129 ,p_element_entry_id IN NUMBER
130 ,p_element_type_id IN NUMBER
131 ,p_original_entry_id IN NUMBER
132 ,p_monthly_gratuity OUT NOCOPY NUMBER
133 ,p_paid_gratuity OUT NOCOPY NUMBER
134 )
135 return NUMBER;
136
137
138
139 ------------------------------------------------------------------------
140 -- Function run_gratuity_salary_formula
141 ------------------------------------------------------------------------
142 function run_gratuity_salary_formula
143 (p_assignment_id IN NUMBER
144 ,p_date_earned IN DATE
145 ,p_business_group_id IN NUMBER
146 ,p_payroll_id IN NUMBER
147 ,p_payroll_action_id IN NUMBER
148 ,p_assignment_action_id IN NUMBER
149 ,p_tax_unit_id IN NUMBER
150 ,p_element_entry_id IN NUMBER
151 ,p_element_type_id IN NUMBER
152 ,p_original_entry_id IN NUMBER
153 )
154 return NUMBER;
155
156 ------------------------------------------------------------------------
157 -- Function get_unauth_absence
158 -- Function for fetching unauthorised absences
159 ------------------------------------------------------------------------
160 function get_unauth_absence
161 (p_assignment_id IN NUMBER
162 ,p_date_earned IN DATE
163 ,p_business_group_id IN NUMBER
164 --,p_period_start_date IN VARCHAR2
165 --,p_period_end_date IN VARCHAR2
166 )
167 return NUMBER;
168
169 ------------------------------------------------------------------------
170 -- Function get_gratuity_basis
171 -- Function for fetching gratuity basis
172 ------------------------------------------------------------------------
173 function get_gratuity_basis
174 (p_assignment_id IN NUMBER
175 ,p_date_earned IN DATE
176 )
177 return VARCHAR2;
178
179 ------------------------------------------------------------------------
180 -- Function for returning contributory wage of employees over 50 years
181 ------------------------------------------------------------------------
182 FUNCTION get_cont_wage_emp_50 (
183 p_assignment_action_id IN NUMBER
184 ,p_assignment_id IN NUMBER
185 ,p_date_earned IN DATE
186 ,p_pct_value IN NUMBER
187 ,p_subject_to_gosi IN NUMBER)
188 RETURN NUMBER;
189
190 end pay_ae_general;