DBA Data[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;