DBA Data[Home] [Help]

APPS.PAY_CA_EMP_TAX_INF dependencies on PAY_CA_EMP_TAX_INF

Line 1: PACKAGE BODY PAY_CA_EMP_TAX_INF as

1: PACKAGE BODY PAY_CA_EMP_TAX_INF as
2: /* $Header: pycantax.pkb 120.3.12010000.2 2008/08/06 06:57:38 ubhat ship $ */
3:
4:
5: procedure get_province_code (p_assignment_id in number,

Line 47: hr_utility.set_location('pay_ca_emp_tax_inf.get_work_provinces',1);

43: and lkp.lookup_code = hrl.region_1
44: and lkp.lookup_type = 'CA_PROVINCE';
45: begin
46:
47: hr_utility.set_location('pay_ca_emp_tax_inf.get_work_provinces',1);
48:
49: /* Get the resident address details */
50:
51: open csr_get_resident_province;

Line 81: hr_utility.set_location('pay_ca_emp_tax_inf.get_work_provinces',3);

77: p_work_province_name := null;
78:
79: end if;
80:
81: hr_utility.set_location('pay_ca_emp_tax_inf.get_work_provinces',3);
82:
83: close csr_get_work_province;
84: end get_province_code;
85:

Line 255: hr_utility.set_location('pay_ca_emp_tax_inf.create_default_tax_record',99);

251: hr_utility.set_location('province_code'||l_province_code,999);
252:
253: commit;
254:
255: hr_utility.set_location('pay_ca_emp_tax_inf.create_default_tax_record',99);
256: /****/
257: end create_default_tax_record;
258:
259: function get_basic_exemption(p_effective_date date,

Line 1213: hr_utility.set_location(' Entering: '||'pay_ca_emp_tax_inf'||l_proc, 10);

1209: --
1210: begin
1211: --
1212: --
1213: hr_utility.set_location(' Entering: '||'pay_ca_emp_tax_inf'||l_proc, 10);
1214: l_effective_date := trunc(p_effective_date);
1215: --
1216: -- Validate that a federal tax rule exists for this assignment
1217: --

Line 1295: hr_utility.set_location(' Leaving: '||'pay_ca_emp_tax_inf'||l_proc, 60);

1291: p_effective_start_date := l_effective_start_date;
1292: p_effective_end_date := l_effective_end_date;
1293: p_object_version_number := l_object_version_number;
1294: --
1295: hr_utility.set_location(' Leaving: '||'pay_ca_emp_tax_inf'||l_proc, 60);
1296: --
1297: exception
1298: --
1299: when l_exit_quietly then

Line 1305: hr_utility.set_location(' Leaving:'||'pay_ca_emp_tax_inf'||l_proc, 70);

1301: p_effective_start_date := null;
1302: p_effective_end_date := null;
1303: p_object_version_number := null;
1304: --
1305: hr_utility.set_location(' Leaving:'||'pay_ca_emp_tax_inf'||l_proc, 70);
1306: --
1307: --
1308: end delete_fed_tax_rule;
1309:

Line 1366: hr_utility.set_location('Entering: '||'pay_ca_emp_tax_inf'||l_proc, 10);

1362: --
1363: --
1364: begin
1365: --
1366: hr_utility.set_location('Entering: '||'pay_ca_emp_tax_inf'||l_proc, 10);
1367: --
1368: l_effective_date := trunc(p_effective_date);
1369: --
1370: hr_utility.set_location(l_proc, 20);

Line 1427: hr_utility.set_location(' Leaving:'||'pay_ca_emp_tax_inf'||l_proc, 60);

1423: end loop;
1424:
1425: end if; -- datetrack mode is ZAP?
1426: --
1427: hr_utility.set_location(' Leaving:'||'pay_ca_emp_tax_inf'||l_proc, 60);
1428: --
1429: exception
1430: --
1431: when l_exit_quietly then

Line 1432: hr_utility.set_location(' Leaving:'||'pay_ca_emp_tax_inf'||l_proc, 70);

1428: --
1429: exception
1430: --
1431: when l_exit_quietly then
1432: hr_utility.set_location(' Leaving:'||'pay_ca_emp_tax_inf'||l_proc, 70);
1433: --
1434: end maintain_ca_employee_taxes;
1435:
1436: procedure delete_tax_record

Line 1447: hr_utility.set_location('Entering: '||'pay_ca_emp_tax_inf'||l_proc, 10);

1443:
1444: begin
1445:
1446: --
1447: hr_utility.set_location('Entering: '||'pay_ca_emp_tax_inf'||l_proc, 10);
1448: --
1449:
1450: maintain_ca_employee_taxes
1451: ( p_period_of_service_id => p_period_of_service_id,

Line 1457: hr_utility.set_location('Leaving: '||'pay_ca_emp_tax_inf'||l_proc, 20);

1453: p_datetrack_mode => 'DELETE',
1454: p_delete_routine => 'ASSIGNMENT'
1455: );
1456:
1457: hr_utility.set_location('Leaving: '||'pay_ca_emp_tax_inf'||l_proc, 20);
1458:
1459: exception
1460: --
1461: when others then

Line 1462: hr_utility.set_location(' Leaving:'||'pay_ca_emp_tax_inf'||l_proc, 30);

1458:
1459: exception
1460: --
1461: when others then
1462: hr_utility.set_location(' Leaving:'||'pay_ca_emp_tax_inf'||l_proc, 30);
1463: --
1464: end delete_tax_record;
1465:
1466: end pay_ca_emp_tax_inf;

Line 1466: end pay_ca_emp_tax_inf;

1462: hr_utility.set_location(' Leaving:'||'pay_ca_emp_tax_inf'||l_proc, 30);
1463: --
1464: end delete_tax_record;
1465:
1466: end pay_ca_emp_tax_inf;