1: PACKAGE BODY pay_ac_taxability_wrapper as
2: /* $Header: payactxabltywrap.pkb 120.5 2006/11/20 10:49:23 rpasumar noship $ */
3:
4: /*
5: ******************************************************************
17: * 500 Oracle Parkway, Redwood City, CA, 94065. *
18: * *
19: ******************************************************************
20:
21: Package Body Name : pay_ac_taxability_wrapper
22: Package File Name : payactxabltywrap.pkb
23: Description : This package declares functions and procedures
24: which supports US and CA taxability rules upload
25: via spread sheet loader.
78: ,p_input_tax_type_value11 IN VARCHAR2)
79: IS
80: BEGIN
81:
82: pay_ac_taxability_wrapper.ltt_tax_type_values(1) := upper(p_input_tax_type_value1);
83: pay_ac_taxability_wrapper.ltt_tax_type_values(2) := upper(p_input_tax_type_value2);
84: pay_ac_taxability_wrapper.ltt_tax_type_values(3) := upper(p_input_tax_type_value3);
85: pay_ac_taxability_wrapper.ltt_tax_type_values(4) := upper(p_input_tax_type_value4);
86: pay_ac_taxability_wrapper.ltt_tax_type_values(5) := upper(p_input_tax_type_value5);
79: IS
80: BEGIN
81:
82: pay_ac_taxability_wrapper.ltt_tax_type_values(1) := upper(p_input_tax_type_value1);
83: pay_ac_taxability_wrapper.ltt_tax_type_values(2) := upper(p_input_tax_type_value2);
84: pay_ac_taxability_wrapper.ltt_tax_type_values(3) := upper(p_input_tax_type_value3);
85: pay_ac_taxability_wrapper.ltt_tax_type_values(4) := upper(p_input_tax_type_value4);
86: pay_ac_taxability_wrapper.ltt_tax_type_values(5) := upper(p_input_tax_type_value5);
87: pay_ac_taxability_wrapper.ltt_tax_type_values(6) := upper(p_input_tax_type_value6);
80: BEGIN
81:
82: pay_ac_taxability_wrapper.ltt_tax_type_values(1) := upper(p_input_tax_type_value1);
83: pay_ac_taxability_wrapper.ltt_tax_type_values(2) := upper(p_input_tax_type_value2);
84: pay_ac_taxability_wrapper.ltt_tax_type_values(3) := upper(p_input_tax_type_value3);
85: pay_ac_taxability_wrapper.ltt_tax_type_values(4) := upper(p_input_tax_type_value4);
86: pay_ac_taxability_wrapper.ltt_tax_type_values(5) := upper(p_input_tax_type_value5);
87: pay_ac_taxability_wrapper.ltt_tax_type_values(6) := upper(p_input_tax_type_value6);
88: pay_ac_taxability_wrapper.ltt_tax_type_values(7) := upper(p_input_tax_type_value7);
81:
82: pay_ac_taxability_wrapper.ltt_tax_type_values(1) := upper(p_input_tax_type_value1);
83: pay_ac_taxability_wrapper.ltt_tax_type_values(2) := upper(p_input_tax_type_value2);
84: pay_ac_taxability_wrapper.ltt_tax_type_values(3) := upper(p_input_tax_type_value3);
85: pay_ac_taxability_wrapper.ltt_tax_type_values(4) := upper(p_input_tax_type_value4);
86: pay_ac_taxability_wrapper.ltt_tax_type_values(5) := upper(p_input_tax_type_value5);
87: pay_ac_taxability_wrapper.ltt_tax_type_values(6) := upper(p_input_tax_type_value6);
88: pay_ac_taxability_wrapper.ltt_tax_type_values(7) := upper(p_input_tax_type_value7);
89: pay_ac_taxability_wrapper.ltt_tax_type_values(8) := upper(p_input_tax_type_value8);
82: pay_ac_taxability_wrapper.ltt_tax_type_values(1) := upper(p_input_tax_type_value1);
83: pay_ac_taxability_wrapper.ltt_tax_type_values(2) := upper(p_input_tax_type_value2);
84: pay_ac_taxability_wrapper.ltt_tax_type_values(3) := upper(p_input_tax_type_value3);
85: pay_ac_taxability_wrapper.ltt_tax_type_values(4) := upper(p_input_tax_type_value4);
86: pay_ac_taxability_wrapper.ltt_tax_type_values(5) := upper(p_input_tax_type_value5);
87: pay_ac_taxability_wrapper.ltt_tax_type_values(6) := upper(p_input_tax_type_value6);
88: pay_ac_taxability_wrapper.ltt_tax_type_values(7) := upper(p_input_tax_type_value7);
89: pay_ac_taxability_wrapper.ltt_tax_type_values(8) := upper(p_input_tax_type_value8);
90: pay_ac_taxability_wrapper.ltt_tax_type_values(9) := upper(p_input_tax_type_value9);
83: pay_ac_taxability_wrapper.ltt_tax_type_values(2) := upper(p_input_tax_type_value2);
84: pay_ac_taxability_wrapper.ltt_tax_type_values(3) := upper(p_input_tax_type_value3);
85: pay_ac_taxability_wrapper.ltt_tax_type_values(4) := upper(p_input_tax_type_value4);
86: pay_ac_taxability_wrapper.ltt_tax_type_values(5) := upper(p_input_tax_type_value5);
87: pay_ac_taxability_wrapper.ltt_tax_type_values(6) := upper(p_input_tax_type_value6);
88: pay_ac_taxability_wrapper.ltt_tax_type_values(7) := upper(p_input_tax_type_value7);
89: pay_ac_taxability_wrapper.ltt_tax_type_values(8) := upper(p_input_tax_type_value8);
90: pay_ac_taxability_wrapper.ltt_tax_type_values(9) := upper(p_input_tax_type_value9);
91: pay_ac_taxability_wrapper.ltt_tax_type_values(10):= upper(p_input_tax_type_value10);
84: pay_ac_taxability_wrapper.ltt_tax_type_values(3) := upper(p_input_tax_type_value3);
85: pay_ac_taxability_wrapper.ltt_tax_type_values(4) := upper(p_input_tax_type_value4);
86: pay_ac_taxability_wrapper.ltt_tax_type_values(5) := upper(p_input_tax_type_value5);
87: pay_ac_taxability_wrapper.ltt_tax_type_values(6) := upper(p_input_tax_type_value6);
88: pay_ac_taxability_wrapper.ltt_tax_type_values(7) := upper(p_input_tax_type_value7);
89: pay_ac_taxability_wrapper.ltt_tax_type_values(8) := upper(p_input_tax_type_value8);
90: pay_ac_taxability_wrapper.ltt_tax_type_values(9) := upper(p_input_tax_type_value9);
91: pay_ac_taxability_wrapper.ltt_tax_type_values(10):= upper(p_input_tax_type_value10);
92: pay_ac_taxability_wrapper.ltt_tax_type_values(11):= upper(p_input_tax_type_value11);
85: pay_ac_taxability_wrapper.ltt_tax_type_values(4) := upper(p_input_tax_type_value4);
86: pay_ac_taxability_wrapper.ltt_tax_type_values(5) := upper(p_input_tax_type_value5);
87: pay_ac_taxability_wrapper.ltt_tax_type_values(6) := upper(p_input_tax_type_value6);
88: pay_ac_taxability_wrapper.ltt_tax_type_values(7) := upper(p_input_tax_type_value7);
89: pay_ac_taxability_wrapper.ltt_tax_type_values(8) := upper(p_input_tax_type_value8);
90: pay_ac_taxability_wrapper.ltt_tax_type_values(9) := upper(p_input_tax_type_value9);
91: pay_ac_taxability_wrapper.ltt_tax_type_values(10):= upper(p_input_tax_type_value10);
92: pay_ac_taxability_wrapper.ltt_tax_type_values(11):= upper(p_input_tax_type_value11);
93:
86: pay_ac_taxability_wrapper.ltt_tax_type_values(5) := upper(p_input_tax_type_value5);
87: pay_ac_taxability_wrapper.ltt_tax_type_values(6) := upper(p_input_tax_type_value6);
88: pay_ac_taxability_wrapper.ltt_tax_type_values(7) := upper(p_input_tax_type_value7);
89: pay_ac_taxability_wrapper.ltt_tax_type_values(8) := upper(p_input_tax_type_value8);
90: pay_ac_taxability_wrapper.ltt_tax_type_values(9) := upper(p_input_tax_type_value9);
91: pay_ac_taxability_wrapper.ltt_tax_type_values(10):= upper(p_input_tax_type_value10);
92: pay_ac_taxability_wrapper.ltt_tax_type_values(11):= upper(p_input_tax_type_value11);
93:
94: hr_utility.trace('ltt_tax_type_values(1) = '||
87: pay_ac_taxability_wrapper.ltt_tax_type_values(6) := upper(p_input_tax_type_value6);
88: pay_ac_taxability_wrapper.ltt_tax_type_values(7) := upper(p_input_tax_type_value7);
89: pay_ac_taxability_wrapper.ltt_tax_type_values(8) := upper(p_input_tax_type_value8);
90: pay_ac_taxability_wrapper.ltt_tax_type_values(9) := upper(p_input_tax_type_value9);
91: pay_ac_taxability_wrapper.ltt_tax_type_values(10):= upper(p_input_tax_type_value10);
92: pay_ac_taxability_wrapper.ltt_tax_type_values(11):= upper(p_input_tax_type_value11);
93:
94: hr_utility.trace('ltt_tax_type_values(1) = '||
95: pay_ac_taxability_wrapper.ltt_tax_type_values(1));
88: pay_ac_taxability_wrapper.ltt_tax_type_values(7) := upper(p_input_tax_type_value7);
89: pay_ac_taxability_wrapper.ltt_tax_type_values(8) := upper(p_input_tax_type_value8);
90: pay_ac_taxability_wrapper.ltt_tax_type_values(9) := upper(p_input_tax_type_value9);
91: pay_ac_taxability_wrapper.ltt_tax_type_values(10):= upper(p_input_tax_type_value10);
92: pay_ac_taxability_wrapper.ltt_tax_type_values(11):= upper(p_input_tax_type_value11);
93:
94: hr_utility.trace('ltt_tax_type_values(1) = '||
95: pay_ac_taxability_wrapper.ltt_tax_type_values(1));
96: hr_utility.trace('ltt_tax_type_values(2) = '||
91: pay_ac_taxability_wrapper.ltt_tax_type_values(10):= upper(p_input_tax_type_value10);
92: pay_ac_taxability_wrapper.ltt_tax_type_values(11):= upper(p_input_tax_type_value11);
93:
94: hr_utility.trace('ltt_tax_type_values(1) = '||
95: pay_ac_taxability_wrapper.ltt_tax_type_values(1));
96: hr_utility.trace('ltt_tax_type_values(2) = '||
97: pay_ac_taxability_wrapper.ltt_tax_type_values(2));
98: hr_utility.trace('ltt_tax_type_values(3) = '||
99: pay_ac_taxability_wrapper.ltt_tax_type_values(3));
93:
94: hr_utility.trace('ltt_tax_type_values(1) = '||
95: pay_ac_taxability_wrapper.ltt_tax_type_values(1));
96: hr_utility.trace('ltt_tax_type_values(2) = '||
97: pay_ac_taxability_wrapper.ltt_tax_type_values(2));
98: hr_utility.trace('ltt_tax_type_values(3) = '||
99: pay_ac_taxability_wrapper.ltt_tax_type_values(3));
100: hr_utility.trace('ltt_tax_type_values(4) = '||
101: pay_ac_taxability_wrapper.ltt_tax_type_values(4));
95: pay_ac_taxability_wrapper.ltt_tax_type_values(1));
96: hr_utility.trace('ltt_tax_type_values(2) = '||
97: pay_ac_taxability_wrapper.ltt_tax_type_values(2));
98: hr_utility.trace('ltt_tax_type_values(3) = '||
99: pay_ac_taxability_wrapper.ltt_tax_type_values(3));
100: hr_utility.trace('ltt_tax_type_values(4) = '||
101: pay_ac_taxability_wrapper.ltt_tax_type_values(4));
102: hr_utility.trace('ltt_tax_type_values(5) = '||
103: pay_ac_taxability_wrapper.ltt_tax_type_values(5));
97: pay_ac_taxability_wrapper.ltt_tax_type_values(2));
98: hr_utility.trace('ltt_tax_type_values(3) = '||
99: pay_ac_taxability_wrapper.ltt_tax_type_values(3));
100: hr_utility.trace('ltt_tax_type_values(4) = '||
101: pay_ac_taxability_wrapper.ltt_tax_type_values(4));
102: hr_utility.trace('ltt_tax_type_values(5) = '||
103: pay_ac_taxability_wrapper.ltt_tax_type_values(5));
104: hr_utility.trace('ltt_tax_type_values(6) = '||
105: pay_ac_taxability_wrapper.ltt_tax_type_values(6));
99: pay_ac_taxability_wrapper.ltt_tax_type_values(3));
100: hr_utility.trace('ltt_tax_type_values(4) = '||
101: pay_ac_taxability_wrapper.ltt_tax_type_values(4));
102: hr_utility.trace('ltt_tax_type_values(5) = '||
103: pay_ac_taxability_wrapper.ltt_tax_type_values(5));
104: hr_utility.trace('ltt_tax_type_values(6) = '||
105: pay_ac_taxability_wrapper.ltt_tax_type_values(6));
106: hr_utility.trace('ltt_tax_type_values(7) = '||
107: pay_ac_taxability_wrapper.ltt_tax_type_values(7));
101: pay_ac_taxability_wrapper.ltt_tax_type_values(4));
102: hr_utility.trace('ltt_tax_type_values(5) = '||
103: pay_ac_taxability_wrapper.ltt_tax_type_values(5));
104: hr_utility.trace('ltt_tax_type_values(6) = '||
105: pay_ac_taxability_wrapper.ltt_tax_type_values(6));
106: hr_utility.trace('ltt_tax_type_values(7) = '||
107: pay_ac_taxability_wrapper.ltt_tax_type_values(7));
108: hr_utility.trace('ltt_tax_type_values(8) = '||
109: pay_ac_taxability_wrapper.ltt_tax_type_values(8));
103: pay_ac_taxability_wrapper.ltt_tax_type_values(5));
104: hr_utility.trace('ltt_tax_type_values(6) = '||
105: pay_ac_taxability_wrapper.ltt_tax_type_values(6));
106: hr_utility.trace('ltt_tax_type_values(7) = '||
107: pay_ac_taxability_wrapper.ltt_tax_type_values(7));
108: hr_utility.trace('ltt_tax_type_values(8) = '||
109: pay_ac_taxability_wrapper.ltt_tax_type_values(8));
110: hr_utility.trace('ltt_tax_type_values(9) = '||
111: pay_ac_taxability_wrapper.ltt_tax_type_values(9));
105: pay_ac_taxability_wrapper.ltt_tax_type_values(6));
106: hr_utility.trace('ltt_tax_type_values(7) = '||
107: pay_ac_taxability_wrapper.ltt_tax_type_values(7));
108: hr_utility.trace('ltt_tax_type_values(8) = '||
109: pay_ac_taxability_wrapper.ltt_tax_type_values(8));
110: hr_utility.trace('ltt_tax_type_values(9) = '||
111: pay_ac_taxability_wrapper.ltt_tax_type_values(9));
112: hr_utility.trace('ltt_tax_type_values(10) = '||
113: pay_ac_taxability_wrapper.ltt_tax_type_values(10));
107: pay_ac_taxability_wrapper.ltt_tax_type_values(7));
108: hr_utility.trace('ltt_tax_type_values(8) = '||
109: pay_ac_taxability_wrapper.ltt_tax_type_values(8));
110: hr_utility.trace('ltt_tax_type_values(9) = '||
111: pay_ac_taxability_wrapper.ltt_tax_type_values(9));
112: hr_utility.trace('ltt_tax_type_values(10) = '||
113: pay_ac_taxability_wrapper.ltt_tax_type_values(10));
114: hr_utility.trace('ltt_tax_type_values(11) = '||
115: pay_ac_taxability_wrapper.ltt_tax_type_values(11));
109: pay_ac_taxability_wrapper.ltt_tax_type_values(8));
110: hr_utility.trace('ltt_tax_type_values(9) = '||
111: pay_ac_taxability_wrapper.ltt_tax_type_values(9));
112: hr_utility.trace('ltt_tax_type_values(10) = '||
113: pay_ac_taxability_wrapper.ltt_tax_type_values(10));
114: hr_utility.trace('ltt_tax_type_values(11) = '||
115: pay_ac_taxability_wrapper.ltt_tax_type_values(11));
116:
117: END transfer_tax_type_values;
111: pay_ac_taxability_wrapper.ltt_tax_type_values(9));
112: hr_utility.trace('ltt_tax_type_values(10) = '||
113: pay_ac_taxability_wrapper.ltt_tax_type_values(10));
114: hr_utility.trace('ltt_tax_type_values(11) = '||
115: pay_ac_taxability_wrapper.ltt_tax_type_values(11));
116:
117: END transfer_tax_type_values;
118:
119: /************************************************************
827: ,p_local_jd_code => lv_jurisdiction_code);
828:
829: if lv_classification_name in ('Supplemental Earnings',
830: 'Imputed Earnings') then
831: pay_ac_taxability_wrapper.ltt_tax_type_values(1)
832: := upper(p_input_tax_type_value3);
833: pay_ac_taxability_wrapper.ltt_tax_type_values(2)
834: := upper(p_input_tax_type_value4);
835:
829: if lv_classification_name in ('Supplemental Earnings',
830: 'Imputed Earnings') then
831: pay_ac_taxability_wrapper.ltt_tax_type_values(1)
832: := upper(p_input_tax_type_value3);
833: pay_ac_taxability_wrapper.ltt_tax_type_values(2)
834: := upper(p_input_tax_type_value4);
835:
836: pay_ac_taxability_wrapper.ltt_tax_type_values(3)
837: := null;
832: := upper(p_input_tax_type_value3);
833: pay_ac_taxability_wrapper.ltt_tax_type_values(2)
834: := upper(p_input_tax_type_value4);
835:
836: pay_ac_taxability_wrapper.ltt_tax_type_values(3)
837: := null;
838: pay_ac_taxability_wrapper.ltt_tax_type_values(4)
839: := null;
840: hr_utility.trace('Local Earnings. Tax type value1 = '||
834: := upper(p_input_tax_type_value4);
835:
836: pay_ac_taxability_wrapper.ltt_tax_type_values(3)
837: := null;
838: pay_ac_taxability_wrapper.ltt_tax_type_values(4)
839: := null;
840: hr_utility.trace('Local Earnings. Tax type value1 = '||
841: pay_ac_taxability_wrapper.ltt_tax_type_values(1));
842: hr_utility.trace('Local Earnings. Tax type value 2= '||
837: := null;
838: pay_ac_taxability_wrapper.ltt_tax_type_values(4)
839: := null;
840: hr_utility.trace('Local Earnings. Tax type value1 = '||
841: pay_ac_taxability_wrapper.ltt_tax_type_values(1));
842: hr_utility.trace('Local Earnings. Tax type value 2= '||
843: pay_ac_taxability_wrapper.ltt_tax_type_values(2));
844:
845: elsif lv_classification_name in ('Pre-Tax Deductions') then
839: := null;
840: hr_utility.trace('Local Earnings. Tax type value1 = '||
841: pay_ac_taxability_wrapper.ltt_tax_type_values(1));
842: hr_utility.trace('Local Earnings. Tax type value 2= '||
843: pay_ac_taxability_wrapper.ltt_tax_type_values(2));
844:
845: elsif lv_classification_name in ('Pre-Tax Deductions') then
846: pay_ac_taxability_wrapper.ltt_tax_type_values(1)
847: := upper(p_input_tax_type_value3);
842: hr_utility.trace('Local Earnings. Tax type value 2= '||
843: pay_ac_taxability_wrapper.ltt_tax_type_values(2));
844:
845: elsif lv_classification_name in ('Pre-Tax Deductions') then
846: pay_ac_taxability_wrapper.ltt_tax_type_values(1)
847: := upper(p_input_tax_type_value3);
848: pay_ac_taxability_wrapper.ltt_tax_type_values(2)
849: := null;
850: pay_ac_taxability_wrapper.ltt_tax_type_values(3)
844:
845: elsif lv_classification_name in ('Pre-Tax Deductions') then
846: pay_ac_taxability_wrapper.ltt_tax_type_values(1)
847: := upper(p_input_tax_type_value3);
848: pay_ac_taxability_wrapper.ltt_tax_type_values(2)
849: := null;
850: pay_ac_taxability_wrapper.ltt_tax_type_values(3)
851: := null;
852: hr_utility.trace('Local Earnings. Tax type value1 = '||
846: pay_ac_taxability_wrapper.ltt_tax_type_values(1)
847: := upper(p_input_tax_type_value3);
848: pay_ac_taxability_wrapper.ltt_tax_type_values(2)
849: := null;
850: pay_ac_taxability_wrapper.ltt_tax_type_values(3)
851: := null;
852: hr_utility.trace('Local Earnings. Tax type value1 = '||
853: pay_ac_taxability_wrapper.ltt_tax_type_values(1));
854:
849: := null;
850: pay_ac_taxability_wrapper.ltt_tax_type_values(3)
851: := null;
852: hr_utility.trace('Local Earnings. Tax type value1 = '||
853: pay_ac_taxability_wrapper.ltt_tax_type_values(1));
854:
855: end if;
856: end if;
857:
869: end if;
870: end if;
871:
872: hr_utility.trace('Before call_api_for_taxability_rules');
873: hr_utility.trace('pay_ac_taxability_wrapper.ltt_tax_type_values(1) = '||
874: pay_ac_taxability_wrapper.ltt_tax_type_values(1));
875:
876: hr_utility.trace('ltt_tax_type_values(1) = '||
877: ltt_tax_type_values(1));
870: end if;
871:
872: hr_utility.trace('Before call_api_for_taxability_rules');
873: hr_utility.trace('pay_ac_taxability_wrapper.ltt_tax_type_values(1) = '||
874: pay_ac_taxability_wrapper.ltt_tax_type_values(1));
875:
876: hr_utility.trace('ltt_tax_type_values(1) = '||
877: ltt_tax_type_values(1));
878: hr_utility.trace('ltt_tax_type_values.count = '||
941:
942: BEGIN
943: g_package := 'pay_ac_taxability_rules_wrapper.';
944: --hr_utility.trace_on(null,'ram');
945: end pay_ac_taxability_wrapper;