eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_GB_EDI_P46_CAR dependencies on PAY_ACTION_INFORMATION

Line 234: FROM pay_action_information pai,

230: RETURN VARCHAR2 IS
231: --
232: CURSOR c_chk_archive IS
233: SELECT 'Y' found_flag
234: FROM pay_action_information pai,
235: pay_assignment_actions act,
236: pay_payroll_actions ppa
237: WHERE ppa.report_type = 'P46_CAR_EDI'
238: AND ppa.report_qualifier='GB'

Line 287: FROM pay_action_information pai,

283: RETURN VARCHAR2 IS
284: --
285: CURSOR c_chk_archive IS
286: SELECT 'Y' found_flag
287: FROM pay_action_information pai,
288: pay_assignment_actions act,
289: pay_payroll_actions ppa
290: WHERE ppa.report_type IN ('P46_CAR_EDI_V2','P46_CAR_EDI')
291: AND ppa.report_qualifier='GB'

Line 359: l_action_info_id pay_action_information.action_information_id%TYPE;

355: AND ppa.report_category = 'EDI';
356: --
357: employer_rec c_employer%ROWTYPE;
358: l_proc CONSTANT VARCHAR2(35):= g_package||'range_cursor';
359: l_action_info_id pay_action_information.action_information_id%TYPE;
360: l_ovn pay_action_information.object_version_number%TYPE;
361: --
362: BEGIN
363: --

Line 360: l_ovn pay_action_information.object_version_number%TYPE;

356: --
357: employer_rec c_employer%ROWTYPE;
358: l_proc CONSTANT VARCHAR2(35):= g_package||'range_cursor';
359: l_action_info_id pay_action_information.action_information_id%TYPE;
360: l_ovn pay_action_information.object_version_number%TYPE;
361: --
362: BEGIN
363: --
364: -- hr_utility.trace_on(null, 'RMAKHIJA');

Line 385: pay_action_information_api.create_action_information (

381: hr_utility.trace(l_proc||': tax_district_name='||employer_rec.tax_district_name);
382: hr_utility.trace(l_proc||': organization_id='||employer_rec.organization_id);
383: hr_utility.trace(l_proc||': effective_Date='||fnd_date.date_to_displaydate(employer_rec.effective_date));
384: --
385: pay_action_information_api.create_action_information (
386: p_action_information_id => l_action_info_id
387: , p_action_context_id => pactid
388: , p_action_context_type => 'PA'
389: , p_object_version_number => l_ovn

Line 456: l_action_info_id pay_action_information.action_information_id%TYPE;

452: AND ppa.report_category = 'EDI';
453: --
454: employer_rec c_employer%ROWTYPE;
455: l_proc CONSTANT VARCHAR2(35):= g_package||'range_code';
456: l_action_info_id pay_action_information.action_information_id%TYPE;
457: l_ovn pay_action_information.object_version_number%TYPE;
458: --
459: BEGIN
460: --

Line 457: l_ovn pay_action_information.object_version_number%TYPE;

453: --
454: employer_rec c_employer%ROWTYPE;
455: l_proc CONSTANT VARCHAR2(35):= g_package||'range_code';
456: l_action_info_id pay_action_information.action_information_id%TYPE;
457: l_ovn pay_action_information.object_version_number%TYPE;
458: --
459: BEGIN
460: --
461: -- hr_utility.trace_on(null, 'RMAKHIJA');

Line 482: pay_action_information_api.create_action_information (

478: hr_utility.trace(l_proc||': tax_district_name='||employer_rec.tax_district_name);
479: hr_utility.trace(l_proc||': organization_id='||employer_rec.organization_id);
480: hr_utility.trace(l_proc||': effective_Date='||fnd_date.date_to_displaydate(employer_rec.effective_date));
481: --
482: pay_action_information_api.create_action_information (
483: p_action_information_id => l_action_info_id
484: , p_action_context_id => pactid
485: , p_action_context_type => 'PA'
486: , p_object_version_number => l_ovn

Line 530: l_ovn pay_action_information.object_version_number%TYPE;

526: chunk IN NUMBER) IS
527: --
528: l_proc CONSTANT VARCHAR2(35):= g_package||'create_asg_act';
529: l_actid pay_assignment_actions.assignment_action_id%TYPE;
530: l_ovn pay_action_information.object_version_number%TYPE;
531: --
532: --
533: CURSOR c_param_values IS
534: SELECT to_number( pay_gb_eoy_archive.get_parameter(

Line 995: l_ovn pay_action_information.object_version_number%TYPE;

991: chunk IN NUMBER) IS
992: --
993: l_proc CONSTANT VARCHAR2(35):= g_package||'create_asg_act';
994: l_actid pay_assignment_actions.assignment_action_id%TYPE;
995: l_ovn pay_action_information.object_version_number%TYPE;
996: --
997: --
998: CURSOR c_param_values IS
999: SELECT to_number( pay_gb_eoy_archive.get_parameter(

Line 1463: l_date_first_avail PAY_ACTION_INFORMATION.ACTION_INFORMATION14%TYPE;

1459: p_allocation_end_date IN DATE) IS
1460: --
1461: l_eff_date DATE;
1462: l_tax_year_start DATE;
1463: l_date_first_avail PAY_ACTION_INFORMATION.ACTION_INFORMATION14%TYPE;
1464: l_second_car_flag PAY_ACTION_INFORMATION.ACTION_INFORMATION15%TYPE;
1465: --
1466: CURSOR c_person(p_assignment_id IN NUMBER) IS
1467: SELECT p.last_name

Line 1464: l_second_car_flag PAY_ACTION_INFORMATION.ACTION_INFORMATION15%TYPE;

1460: --
1461: l_eff_date DATE;
1462: l_tax_year_start DATE;
1463: l_date_first_avail PAY_ACTION_INFORMATION.ACTION_INFORMATION14%TYPE;
1464: l_second_car_flag PAY_ACTION_INFORMATION.ACTION_INFORMATION15%TYPE;
1465: --
1466: CURSOR c_person(p_assignment_id IN NUMBER) IS
1467: SELECT p.last_name
1468: , p.title

Line 1544: l_action_info_id PAY_ACTION_INFORMATION.ACTION_INFORMATION_ID%TYPE;

1540: AND trunc(sysdate) BETWEEN trunc(nvl(h1.start_date_active, sysdate-1)) AND trunc(nvl(h1.end_date_active,sysdate+1));
1541: --
1542: car_rec c_car%ROWTYPE;
1543: --
1544: l_action_info_id PAY_ACTION_INFORMATION.ACTION_INFORMATION_ID%TYPE;
1545: l_ovn PAY_ACTION_INFORMATION.OBJECT_VERSION_NUMBER%TYPE;
1546: l_proc CONSTANT VARCHAR2(50):= g_package||'archive_allocation_action';
1547: --
1548: BEGIN

Line 1545: l_ovn PAY_ACTION_INFORMATION.OBJECT_VERSION_NUMBER%TYPE;

1541: --
1542: car_rec c_car%ROWTYPE;
1543: --
1544: l_action_info_id PAY_ACTION_INFORMATION.ACTION_INFORMATION_ID%TYPE;
1545: l_ovn PAY_ACTION_INFORMATION.OBJECT_VERSION_NUMBER%TYPE;
1546: l_proc CONSTANT VARCHAR2(50):= g_package||'archive_allocation_action';
1547: --
1548: BEGIN
1549: hr_utility.set_location('Entering '||l_proc, 10);

Line 1612: pay_action_information_api.create_action_information (

1608: hr_utility.trace('Postal : ' || addr_rec.postal_code);
1609: hr_utility.trace('DOB : ' || fnd_date.date_to_canonical(person_rec.date_of_birth)); --For Bug 6652235
1610: hr_utility.trace('Gender : ' || person_rec.sex); --For Bug 6652235
1611:
1612: pay_action_information_api.create_action_information (
1613: p_action_information_id => l_action_info_id
1614: , p_action_context_id => p_asg_act_id
1615: , p_action_context_type => 'AAP'
1616: , p_object_version_number => l_ovn

Line 1706: pay_action_information_api.create_action_information (

1702: --
1703: IF p_action_flag = 'N' THEN
1704: hr_utility.set_location(l_proc, 130);
1705: --
1706: pay_action_information_api.create_action_information (
1707: p_action_information_id => l_action_info_id
1708: , p_action_context_id => p_asg_act_id
1709: , p_action_context_type => 'AAP'
1710: , p_object_version_number => l_ovn

Line 1738: pay_action_information_api.create_action_information (

1734: hr_utility.set_location(l_proc, 140);
1735: ELSIF p_action_flag = 'R' THEN
1736: hr_utility.set_location(l_proc, 150);
1737: --
1738: pay_action_information_api.create_action_information (
1739: p_action_information_id => l_action_info_id
1740: , p_action_context_id => p_asg_act_id
1741: , p_action_context_type => 'AAP'
1742: , p_object_version_number => l_ovn

Line 1775: pay_action_information_api.create_action_information (

1771: hr_utility.set_location(l_proc, 160);
1772: ELSIF p_action_flag = 'W' THEN
1773: hr_utility.set_location(l_proc, 170);
1774: --
1775: pay_action_information_api.create_action_information (
1776: p_action_information_id => l_action_info_id
1777: , p_action_context_id => p_asg_act_id
1778: , p_action_context_type => 'AAP'
1779: , p_object_version_number => l_ovn

Line 1808: pay_action_information_api.create_action_information (

1804: hr_utility.set_location(l_proc, 180);
1805: ELSIF p_action_flag = 'F' THEN
1806: hr_utility.set_location(l_proc, 190);
1807: --
1808: pay_action_information_api.create_action_information (
1809: p_action_information_id => l_action_info_id
1810: , p_action_context_id => p_asg_act_id
1811: , p_action_context_type => 'AAP'
1812: , p_object_version_number => l_ovn