[Home] [Help]
PACKAGE: APPS.PAY_ZA_EOY_VAL
Source
1 Package PAY_ZA_EOY_VAL AUTHID CURRENT_USER as
2 /* $Header: pyzatyev.pkh 120.8.12020000.2 2012/07/23 10:57:27 nchinnam ship $ */
3 -- Package specification
4 --
5 TYPE t_xml_element_rec IS RECORD
6 (tagname VARCHAR2(100)
7 ,tagvalue VARCHAR2(500)
8 );
9
10 TYPE t_xml_element_table IS TABLE OF t_xml_element_rec INDEX BY BINARY_INTEGER;
11
12 g_xml_element_table t_xml_element_table;
13
14 Function modulus_10_test
15 (p_tax_number in number) return number;
16 pragma restrict_references(modulus_10_test,WNDS,WNPS);
17 --
18 Function modulus_10_test
19 (p_tax_number in varchar2
20 ,p_type in varchar2 default null) return number; --Added for TYE2010
21 pragma restrict_references(modulus_10_test,WNDS,WNPS);
22 --
23
24 Function modulus_13_test
25 (p_id_number in varchar2)
26 return number;
27 pragma restrict_references(modulus_13_test,WNDS,WNPS);
28 --
29
30 Function check_id_dob
31 (p_id_number in number
32 ,p_dob in date) return number;
33 pragma restrict_references(check_id_dob,WNDS,WNPS);
34 --
35 function decimal_character_conversion ( amount_char in varchar2)
36 return varchar2;
37
38 Function check_IRP5_no
39 (p_payroll_id in number
40 ,p_irp5no in varchar2
41 ,p_tax_year in varchar2) return number;
42 pragma restrict_references(check_IRP5_no,WNDS,WNPS);
43 --
44 Procedure get_tax_start_end_dates
45 (p_payroll_id in number
46 ,p_tax_year in varchar2
47 ,p_tax_start_date out nocopy varchar2
48 ,p_tax_end_date out nocopy varchar2);
49 pragma restrict_references(get_tax_start_end_dates,WNDS,WNPS);
50 --
51 Procedure populate_messages( c_name OUT NOCOPY VARCHAR2,
52 c_ref_no OUT NOCOPY VARCHAR2,
53 c_ref_no_invalid OUT NOCOPY VARCHAR2,
54 c_person_name OUT NOCOPY VARCHAR2,
55 c_telephone OUT NOCOPY VARCHAR2,
56 c_add_line1 OUT NOCOPY VARCHAR2,
57 c_pcode OUT NOCOPY VARCHAR2,
58 c_pcode1 OUT NOCOPY VARCHAR2,
59 trade_name OUT NOCOPY VARCHAR2,
60 paye_no OUT NOCOPY VARCHAR2,
61 paye_no1 OUT NOCOPY VARCHAR2,
62 address OUT NOCOPY VARCHAR2,
63 pcode OUT NOCOPY VARCHAR2,
64 pcode1 OUT NOCOPY VARCHAR2,
65 payroll_number OUT NOCOPY VARCHAR2,
66 nature_entered OUT NOCOPY VARCHAR2,
67 id_passport OUT NOCOPY VARCHAR2,
68 no_id_passport OUT NOCOPY VARCHAR2,
69 sur_trade_name OUT NOCOPY VARCHAR2,
70 cc_no OUT NOCOPY VARCHAR2,
71 sur_first_name OUT NOCOPY VARCHAR2,
72 M_sur_fname OUT NOCOPY VARCHAR2,
73 M_id_pno_fname OUT NOCOPY VARCHAR2,
74 M_cc_trade_name OUT NOCOPY VARCHAR2,
75 M_lname_fname_cc OUT NOCOPY VARCHAR2,
76 invalid_it_no OUT NOCOPY VARCHAR2,
77 birth_id OUT NOCOPY VARCHAR2,
78 legal_entity OUT NOCOPY VARCHAR2,
79 no_site_paye_split OUT NOCOPY VARCHAR2,
80 neg_bal_not_alwd OUT NOCOPY VARCHAR2,
81 clearance_num OUT NOCOPY VARCHAR2,
82 terminate_emp OUT NOCOPY VARCHAR2,
83 town_city OUT NOCOPY VARCHAR2,
84 employer_name OUT NOCOPY VARCHAR2);
85 pragma restrict_references(populate_messages,WNDS,WNPS);
86
87 -- for TYE 2008 write the exceptions to the log file
88
89 PROCEDURE VALIDATE_TYE_DATA (
90 errbuf out nocopy varchar2,
91 retcode out nocopy number,
92 p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
93 p_tax_yr_start_date IN DATE,
94 p_tax_yr_end_date IN DATE
95 );
96
97 --Added for TYE2010
98 Function check_id_dob
99 (p_id_number in varchar2
100 ,p_dob in date
101 ,p_new_format in varchar2) return number;
102 pragma restrict_references(check_id_dob,WNDS,WNPS);
103
104
105 procedure get_tyev_xml (
106 P_PROCESS_NAME IN varchar2,
107 P_BUSINESS_GROUP_ID IN number,
108 P_ACTN_PARAMTR_GRP_ID IN number,
109 P_LEGAL_ENTITY IN number,
110 P_LEGAL_ENTITY_HIDDEN IN varchar2,
111 P_TAX_YEAR IN varchar2,
112 P_TAX_YEAR_H IN varchar2,
113 P_PERIOD_RECON IN varchar2, -- 9877034 fix
114 P_PERIOD_RECON_H IN varchar2, -- 9877034 fix
115 P_CERT_TYPE IN varchar2,
116 P_CERT_TYPE_H IN varchar2,
117 P_PAYROLL_ID IN number,
118 P_PAYROLL_ID_H IN varchar2,
119 P_START_DATE IN varchar2,
120 P_END_DATE IN varchar2,
121 P_ASG_SET_ID IN number,
122 P_ASG_SET_ID_H IN varchar2,
123 P_PERSON_ID IN number,
124 P_PERSON_ID_H IN varchar2,
125 P_TEST_RUN IN varchar2,
126 P_SORT_ORDER1 IN varchar2,
127 P_SORT_ORDER2 IN varchar2,
128 P_SORT_ORDER3 IN varchar2,
129 P_MONTHLY_RUN IN varchar2,
130 p_template_name IN varchar2,
131 P_COMBINE_CERT IN varchar2,
132 P_COMBINE_CERT_H IN varchar2,
133 p_xml out nocopy CLOB
134 );
135
136
137
138 PROCEDURE VALIDATE_TYE_DATA_EOY2010 (
139 errbuf out nocopy varchar2,
140 retcode out nocopy number,
141 p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
142 p_tax_yr_start_date IN DATE,
143 p_tax_yr_end_date IN DATE,
144 p_tax_year IN NUMBER,
145 p_period_recon IN varchar2 -- 9877034 fix
146 );
147
148
149
150
151 end PAY_ZA_EOY_VAL;