[Home] [Help]
PACKAGE: APPS.PAY_CA_T4_XML
Source
1 package pay_ca_t4_xml as
2 /* $Header: pycat4xml.pkh 120.4.12000000.1 2007/01/17 17:29:57 appldev noship $ */
3 /*
4
5 rem +======================================================================+
6 rem | Copyright (c) 1993 Oracle Corporation |
7 rem | Redwood Shores, California, USA |
8 rem | All rights reserved. |
9 rem +======================================================================+
10 Change List
11 -----------
12 Date Name Vers Description
13 ----------- ---------- ----- -----------------------------------
14 05-APR-2005 ssouresr 115.0 Created.
15 30-NOV-2005 ssouresr 115.4 Changed fetch_t4_xml to be a procedure
16 */
17
18 type other_info_rec is record (code varchar2(3),
19 amount varchar2(50));
20
21 type other_info_tab is table of other_info_rec index by binary_integer;
22
23 g_other_info_list other_info_tab;
24
25 procedure store_other_information(p_aa_id in number,
26 p_prov in varchar2);
27
28 procedure get_other_information(p_index in number,
29 p_code in out nocopy varchar2,
30 p_amount in out nocopy varchar2);
31
32 procedure get_asg_xml;
33 procedure get_header_xml;
34 procedure get_trailer_xml;
35
36 procedure fetch_t4_xml(p_aa_id in number,
37 p_pa_id in number,
38 p_type in varchar2,
39 p_print in varchar2,
40 p_prov in varchar2);
41
42 function create_xml_string (p_employer_name varchar2,
43 p_employer_bn varchar2,
44 p_employer_addr varchar2,
45 p_employee_name varchar2,
46 p_employee_last_name varchar2,
47 p_employee_init varchar2,
48 p_employee_addr varchar2,
49 p_sin varchar2,
50 p_cpp_qpp_exempt varchar2,
51 p_ei_exempt varchar2,
52 p_employment_prov varchar2,
53 p_employment_code varchar2,
54 p_registration_number varchar2,
55 p_employment_income varchar2,
56 p_cpp_contributions varchar2,
57 p_qpp_contributions varchar2,
58 p_ei_contributions varchar2,
59 p_rpp_contributions varchar2,
60 p_pension_adjustment varchar2,
61 p_tax_deducted varchar2,
62 p_ei_earnings varchar2,
63 p_cpp_qpp_earnings varchar2,
64 p_union_dues varchar2,
65 p_charitable_donations varchar2,
66 p_other_code1 varchar2,
67 p_other_amount1 varchar2,
68 p_other_code2 varchar2,
69 p_other_amount2 varchar2,
70 p_other_code3 varchar2,
71 p_other_amount3 varchar2,
72 p_other_code4 varchar2,
73 p_other_amount4 varchar2,
74 p_other_code5 varchar2,
75 p_other_amount5 varchar2,
76 p_other_code6 varchar2,
77 p_other_amount6 varchar2,
78 p_year varchar2,
79 p_ppip_exempt varchar2,
80 p_ppip_contributions varchar2,
81 p_ppip_earnings varchar2,
82 p_gre_name varchar2)
83 return varchar2;
84
85 function get_outfile return varchar2;
86
87 function get_IANA_charset return varchar2;
88
89 cursor main_block is
90 select 'Version_Number=X' ,'Version 1.1'
91 from sys.dual;
92
93 cursor transfer_block is
94 select 'TRANSFER_ACT_ID=P', assignment_action_id
95 from pay_assignment_actions
96 where payroll_action_id =
97 pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');
98
99 cursor assignment_block is
100 select 'TRANSFER_ACT_ID=P',pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')
101 from sys.dual;
102
103 level_cnt NUMBER :=0;
104 g_temp_dir VARCHAR2(512);
105
106 end pay_ca_t4_xml;