1 package pay_ae_general as
2 /* $Header: pyaegenr.pkh 120.2 2005/11/10 03:05:26 abppradh noship $ */
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 -- Function GET_SECTOR
26 ------------------------------------------------------------------------
27 function get_sector (p_tax_unit_id IN NUMBER) return varchar2;
28 ------------------------------------------------------------------------
29 -- Function GET_MESSAGE
30 ------------------------------------------------------------------------
31 function get_message
32 (p_product in varchar2
33 ,p_message_name in varchar2
34 ,p_token1 in varchar2 default null
35 ,p_token2 in varchar2 default null
36 ,p_token3 in varchar2 default null)
37 return varchar2;
38 ------------------------------------------------------------------------
39 -- Function GET_TABLE_BANDS
40 ------------------------------------------------------------------------
41 function get_table_bands
42 (p_Date_Earned IN DATE
43 ,p_table_name in varchar2
44 ,p_return_type in varchar2) return number;
45
46 -----------------------------------------------------------
47 -- Functions for EFT file
48 -----------------------------------------------------------
49 --
50 FUNCTION get_parameter (
51 p_parameter_string in varchar2
52 ,p_token in varchar2
53 ,p_segment_number in number default null) RETURN varchar2;
54 --
55 FUNCTION chk_multiple_assignments(p_effective_date IN DATE
56 ,p_person_id IN NUMBER) RETURN VARCHAR2;
57 --
58 function get_count RETURN NUMBER;
59 --
60 function get_total_sum RETURN NUMBER;
61 --
62 function get_credit_sum RETURN NUMBER;
63 --
64 function get_debit_sum RETURN NUMBER;
65 --
66 function chk_tran_code (p_value IN VARCHAR2) RETURN VARCHAR2;
67 --
68 ------------------------------------------------------------------------
69 -- Function get_contract
70 ------------------------------------------------------------------------
71 function get_contract
72 (p_assignment_id IN per_all_assignments_f.assignment_id%type,
73 p_date_earned IN Date)
74 return varchar2;
75 ------------------------------------------------------------------------
76 -- Function get_contract_expiry_status
77 ------------------------------------------------------------------------
78 function get_contract_expiry_status
79 (p_assignment_id IN per_all_assignments_f.assignment_id%type,
80 p_date_earned IN Date)
81 return varchar2;
82 ------------------------------------------------------------------------
83 -- Function get_termination_initiator
84 ------------------------------------------------------------------------
85 function get_termination_initiator
86 (p_assignment_id IN per_all_assignments_f.assignment_id%type,
87 p_date_earned IN Date)
88 return varchar2;
89
90 ------------------------------------------------------------------------
91 -- Function user_gratuity_formula_exists
92 ------------------------------------------------------------------------
93 function user_gratuity_formula_exists
94 (p_assignment_id IN per_all_assignments_f.assignment_id%type,
95 p_date_earned IN Date)
96 return varchar2;
97
98 --
99 ------------------------------------------------------------------------
100 -- Function run_gratuity_formula
101 ------------------------------------------------------------------------
102 function run_gratuity_formula
103 (p_assignment_id IN NUMBER
104 ,p_date_earned IN DATE
105 ,p_business_group_id IN NUMBER
106 ,p_payroll_id IN NUMBER
107 ,p_payroll_action_id IN NUMBER
108 ,p_assignment_action_id IN NUMBER
109 ,p_tax_unit_id IN NUMBER
110 ,p_element_entry_id IN NUMBER
111 ,p_element_type_id IN NUMBER
112 ,p_original_entry_id IN NUMBER
113 ,p_monthly_gratuity OUT NOCOPY NUMBER
114 ,p_paid_gratuity OUT NOCOPY NUMBER
115 )
116 return NUMBER;
117
118
119
120 ------------------------------------------------------------------------
121 -- Function run_gratuity_salary_formula
122 ------------------------------------------------------------------------
123 function run_gratuity_salary_formula
124 (p_assignment_id IN NUMBER
125 ,p_date_earned IN DATE
126 ,p_business_group_id IN NUMBER
127 ,p_payroll_id IN NUMBER
128 ,p_payroll_action_id IN NUMBER
129 ,p_assignment_action_id IN NUMBER
130 ,p_tax_unit_id IN NUMBER
131 ,p_element_entry_id IN NUMBER
132 ,p_element_type_id IN NUMBER
133 ,p_original_entry_id IN NUMBER
134 )
135 return NUMBER;
136
137 ------------------------------------------------------------------------
138 -- Function get_unauth_absence
139 -- Function for fetching unauthorised absences
140 ------------------------------------------------------------------------
141 function get_unauth_absence
142 (p_assignment_id IN NUMBER
143 ,p_date_earned IN DATE
144 ,p_business_group_id IN NUMBER
145 --,p_period_start_date IN VARCHAR2
146 --,p_period_end_date IN VARCHAR2
147 )
148 return NUMBER;
149
150 ------------------------------------------------------------------------
151 -- Function get_gratuity_basis
152 -- Function for fetching gratuity basis
153 ------------------------------------------------------------------------
154 function get_gratuity_basis
155 (p_assignment_id IN NUMBER
156 ,p_date_earned IN DATE
157 )
158 return VARCHAR2;
159
160
161 end pay_ae_general;