1 package pay_gb_paye_calc as
2 /* $Header: pygbpaye.pkh 120.6.12010000.1 2008/07/27 22:46:03 appldev ship $
3 ******************************************************************
4 * *
5 * Copyright (C) 1989 Oracle Corporation UK Ltd., *
6 * Richmond, England. *
7 * *
8 * All rights reserved. *
9 * *
10 * This material has been provided pursuant to an agreement *
11 * containing restrictions on its use. The material is also *
12 * protected by copyright law. No part of this material may *
13 * be copied or distributed, transmitted or transcribed, in *
14 * any form or by any means, electronic, mechanical, magnetic, *
15 * manual, or otherwise, or disclosed to third parties without *
16 * the express written permission of Oracle Corporation UK Ltd, *
17 * Oracle Park, Bittams Lane, Guildford Road, Chertsey, Surrey, *
18 * England. *
19 * *
20 ******************************************************************
21
22 Name : pay_gb_paye_calc
23
24 Description : This package contains calculations for use in PAYE processing
25
26 Uses :
27
28 Used By : FOT fast formula
29
30
31 Change List :
32
33 Version Date Author Description
34 ------- ----- -------- ----------------
35 115.0 6/6/01 GBUTLER Created
36 115.4 21/12/06 SBAIRAGI Added check_tax_ref function.
37 115.5 28/12/05 TUKUMAR Bug 4528372 : added function tax_year_of_pensioners_death
38
39
40 */
41 function free_pay (p_amount IN NUMBER,
42 p_tax_code IN VARCHAR2,
43 p_tax_basis IN VARCHAR2,
44 p_stat_annual_periods IN NUMBER,
45 p_current_period IN NUMBER) return NUMBER;
46
47 function tax_to_date (p_session_date IN DATE,
48 p_taxable_pay IN NUMBER,
49 p_tax_code IN VARCHAR2,
50 p_tax_basis IN VARCHAR2,
51 p_stat_annual_periods IN NUMBER,
52 p_current_period IN NUMBER) return NUMBER;
53
54 function check_tax_ref(p_assignment_id number, p_payroll_id number , p_pay_run_date date,p_payroll_action_id number) return number;
55
56 function tax_year_of_pensioners_death (p_assignmnet_id in number ,p_pay_run_date in date)
57 return varchar2 ;
58
59 type g_paye_rec is record
60 (
61 g_gross_low_value pay_user_rows_f.row_low_range_or_name%TYPE,
62 g_gross_high_value pay_user_rows_f.row_high_range%TYPE,
63 g_rate pay_user_column_instances.value%TYPE,
64 g_gross_denom NUMBER,
65 g_tax_deduct NUMBER,
66 g_tax_column NUMBER,
67 g_net_low_value pay_user_rows_f.row_low_range_or_name%TYPE,
68 g_net_high_value pay_user_rows_f.row_high_range%TYPE
69 );
70
71 type g_paye_tabtype is table of g_paye_rec index by binary_integer;
72
73 tbl_paye_table g_paye_tabtype;
74
75 g_table_inited BOOLEAN := FALSE;
76
77 end pay_gb_paye_calc;