[Home] [Help]
PACKAGE: APPS.PAY_ZA_EOY_VAL
Source
1 Package PAY_ZA_EOY_VAL as
2 /* $Header: pyzatyev.pkh 120.2.12010000.2 2008/08/06 08:47:43 ubhat ship $ */
3 -- Package specification
4 --
5 Function modulus_10_test
6 (p_tax_number in number) return number;
7 pragma restrict_references(modulus_10_test,WNDS,WNPS);
8 --
9 Function modulus_10_test
10 (p_tax_number in varchar2) return number;
11 pragma restrict_references(modulus_10_test,WNDS,WNPS);
12 --
13
14 Function check_id_dob
15 (p_id_number in number
16 ,p_dob in date) return number;
17 pragma restrict_references(check_id_dob,WNDS,WNPS);
18 --
19 function decimal_character_conversion ( amount_char in varchar2)
20 return varchar2;
21
22 Function check_IRP5_no
23 (p_payroll_id in number
24 ,p_irp5no in varchar2
25 ,p_tax_year in varchar2) return number;
26 pragma restrict_references(check_IRP5_no,WNDS,WNPS);
27 --
28 Procedure get_tax_start_end_dates
29 (p_payroll_id in number
30 ,p_tax_year in varchar2
31 ,p_tax_start_date out nocopy varchar2
32 ,p_tax_end_date out nocopy varchar2);
33 pragma restrict_references(get_tax_start_end_dates,WNDS,WNPS);
34 --
35 Procedure populate_messages( c_name OUT NOCOPY VARCHAR2,
36 c_ref_no OUT NOCOPY VARCHAR2,
37 c_ref_no_invalid OUT NOCOPY VARCHAR2,
38 c_person_name OUT NOCOPY VARCHAR2,
39 c_telephone OUT NOCOPY VARCHAR2,
40 c_add_line1 OUT NOCOPY VARCHAR2,
41 c_pcode OUT NOCOPY VARCHAR2,
42 c_pcode1 OUT NOCOPY VARCHAR2,
43 trade_name OUT NOCOPY VARCHAR2,
44 paye_no OUT NOCOPY VARCHAR2,
45 paye_no1 OUT NOCOPY VARCHAR2,
46 address OUT NOCOPY VARCHAR2,
47 pcode OUT NOCOPY VARCHAR2,
48 pcode1 OUT NOCOPY VARCHAR2,
49 payroll_number OUT NOCOPY VARCHAR2,
50 nature_entered OUT NOCOPY VARCHAR2,
51 id_passport OUT NOCOPY VARCHAR2,
52 no_id_passport OUT NOCOPY VARCHAR2,
53 sur_trade_name OUT NOCOPY VARCHAR2,
54 cc_no OUT NOCOPY VARCHAR2,
55 sur_first_name OUT NOCOPY VARCHAR2,
56 M_sur_fname OUT NOCOPY VARCHAR2,
57 M_id_pno_fname OUT NOCOPY VARCHAR2,
58 M_cc_trade_name OUT NOCOPY VARCHAR2,
59 M_lname_fname_cc OUT NOCOPY VARCHAR2,
60 invalid_it_no OUT NOCOPY VARCHAR2,
61 birth_id OUT NOCOPY VARCHAR2,
62 legal_entity OUT NOCOPY VARCHAR2,
63 no_site_paye_split OUT NOCOPY VARCHAR2,
64 neg_bal_not_alwd OUT NOCOPY VARCHAR2,
65 clearance_num OUT NOCOPY VARCHAR2,
66 terminate_emp OUT NOCOPY VARCHAR2,
67 town_city OUT NOCOPY VARCHAR2);
68 pragma restrict_references(populate_messages,WNDS,WNPS);
69
70 -- for TYE 2008 write the exceptions to the log file
71
72 PROCEDURE VALIDATE_TYE_DATA (
73 errbuf out nocopy varchar2,
74 retcode out nocopy number,
75 p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
76 p_tax_yr_start_date IN DATE,
77 p_tax_yr_end_date IN DATE
78 );
79
80
81
82
83 end PAY_ZA_EOY_VAL;