1 package hrdpp_CREATE_CA_EMP_PRVTAX_INF as
2 /*
3 * Generated by hr_pump_meta_mapper at: 2007/01/03 23:01:37
4 * Generated for API: PAY_CA_EMP_PRVTAX_INF_API.CREATE_CA_EMP_PRVTAX_INF
5 */
6 --
7 g_generator_version constant varchar2(128) default '$Revision: 120.4 $';
8 --
9
10 function dc(p in date) return varchar2;
11 pragma restrict_references(dc,WNDS);
12
13 function d(p in varchar2) return date;
14 pragma restrict_references(d,WNDS);
15 function n(p in varchar2) return number;
16 pragma restrict_references(n,WNDS);
17 function dd(p in date,i in varchar2) return varchar2;
18 pragma restrict_references(dd,WNDS);
19 function nd(p in number,i in varchar2) return varchar2;
20 pragma restrict_references(nd,WNDS);
21 --
22 procedure insert_batch_lines
23 (p_batch_id in number
24 ,p_data_pump_batch_line_id in number default null
25 ,p_data_pump_business_grp_name in varchar2 default null
26 ,p_user_sequence in number default null
27 ,p_link_value in number default null
28 ,P_EMP_PROV_TAX_INF_USER_KEY in varchar2
29 ,P_LEGISLATION_CODE in varchar2 default null
30 ,P_ASSIGNMENT_ID in number default null
31 ,P_PROVINCE_CODE in varchar2 default null
32 ,P_JURISDICTION_CODE in varchar2 default null
33 ,P_TAX_CREDIT_AMOUNT in number default null
34 ,P_BASIC_EXEMPTION_FLAG in varchar2 default null
35 ,P_DEDUCTION_CODE in varchar2 default null
36 ,P_EXTRA_INFO_NOT_PROVIDED in varchar2 default null
37 ,P_MARRIAGE_STATUS in varchar2 default null
38 ,P_NO_OF_INFIRM_DEPENDANTS in number default null
39 ,P_NON_RESIDENT_STATUS in varchar2 default null
40 ,P_DISABILITY_STATUS in varchar2 default null
41 ,P_NO_OF_DEPENDANTS in number default null
42 ,P_ANNUAL_DEDN in number default null
43 ,P_TOTAL_EXPENSE_BY_COMMISSION in number default null
44 ,P_TOTAL_REMNRTN_BY_COMMISSION in number default null
45 ,P_PRESCRIBED_ZONE_DEDN_AMT in number default null
46 ,P_ADDITIONAL_TAX in number default null
47 ,P_PROV_OVERRIDE_RATE in number default null
48 ,P_PROV_OVERRIDE_AMOUNT in number default null
49 ,P_PROV_EXEMPT_FLAG in varchar2 default null
50 ,P_PMED_EXEMPT_FLAG in varchar2 default null
51 ,P_WC_EXEMPT_FLAG in varchar2 default null
52 ,P_QPP_EXEMPT_FLAG in varchar2 default null
53 ,P_TAX_CALC_METHOD in varchar2 default null
54 ,P_OTHER_TAX_CREDIT in number default null
55 ,P_CA_TAX_INFORMATION_CATEGORY in varchar2 default null
56 ,P_CA_TAX_INFORMATION1 in varchar2 default null
57 ,P_CA_TAX_INFORMATION2 in varchar2 default null
58 ,P_CA_TAX_INFORMATION3 in varchar2 default null
59 ,P_CA_TAX_INFORMATION4 in varchar2 default null
60 ,P_CA_TAX_INFORMATION5 in varchar2 default null
61 ,P_CA_TAX_INFORMATION6 in varchar2 default null
62 ,P_CA_TAX_INFORMATION7 in varchar2 default null
63 ,P_CA_TAX_INFORMATION8 in varchar2 default null
64 ,P_CA_TAX_INFORMATION9 in varchar2 default null
65 ,P_CA_TAX_INFORMATION10 in varchar2 default null
66 ,P_CA_TAX_INFORMATION11 in varchar2 default null
67 ,P_CA_TAX_INFORMATION12 in varchar2 default null
68 ,P_CA_TAX_INFORMATION13 in varchar2 default null
69 ,P_CA_TAX_INFORMATION14 in varchar2 default null
70 ,P_CA_TAX_INFORMATION15 in varchar2 default null
71 ,P_CA_TAX_INFORMATION16 in varchar2 default null
72 ,P_CA_TAX_INFORMATION17 in varchar2 default null
73 ,P_CA_TAX_INFORMATION18 in varchar2 default null
74 ,P_CA_TAX_INFORMATION19 in varchar2 default null
75 ,P_CA_TAX_INFORMATION20 in varchar2 default null
76 ,P_CA_TAX_INFORMATION21 in varchar2 default null
77 ,P_CA_TAX_INFORMATION22 in varchar2 default null
78 ,P_CA_TAX_INFORMATION23 in varchar2 default null
79 ,P_CA_TAX_INFORMATION24 in varchar2 default null
80 ,P_CA_TAX_INFORMATION25 in varchar2 default null
81 ,P_CA_TAX_INFORMATION26 in varchar2 default null
82 ,P_CA_TAX_INFORMATION27 in varchar2 default null
83 ,P_CA_TAX_INFORMATION28 in varchar2 default null
84 ,P_CA_TAX_INFORMATION29 in varchar2 default null
85 ,P_CA_TAX_INFORMATION30 in varchar2 default null
86 ,P_PROV_LSP_AMOUNT in number default null
87 ,P_EFFECTIVE_DATE in date
88 ,P_PPIP_EXEMPT_FLAG in varchar2 default null);
89 --
90 procedure call
91 (p_business_group_id in number,
92 p_batch_line_id in number);
93 end hrdpp_CREATE_CA_EMP_PRVTAX_INF;
[Home] [Help]