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 330: FROM pay_action_information pai,

326: RETURN VARCHAR2 IS
327: --
328: CURSOR c_chk_archive IS
329: SELECT 'Y' found_flag
330: FROM pay_action_information pai,
331: pay_assignment_actions act,
332: pay_payroll_actions ppa
333: WHERE ppa.report_type = 'P46_CAR_EDI'
334: AND ppa.report_qualifier='GB'

Line 384: FROM pay_action_information pai,

380: RETURN VARCHAR2 IS
381: --
382: CURSOR c_chk_archive IS
383: SELECT 'Y' found_flag
384: FROM pay_action_information pai,
385: pay_assignment_actions act,
386: pay_payroll_actions ppa
387: WHERE ppa.report_type IN ('P46_CAR_EDI_V2','P46_CAR_EDI','P46_CAR_EDI_V3','P46_CAR_EDI_V4','P46_CAR_EDI_V5') --Bug 10095492: Added V4 --Bug 13400872: Added V5
388: AND ppa.report_qualifier='GB'

Line 457: l_action_info_id pay_action_information.action_information_id%TYPE;

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

Line 458: l_ovn pay_action_information.object_version_number%TYPE;

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

Line 483: pay_action_information_api.create_action_information (

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

Line 554: l_action_info_id pay_action_information.action_information_id%TYPE;

550: AND ppa.report_category = 'EDI';
551: --
552: employer_rec c_employer%ROWTYPE;
553: l_proc CONSTANT VARCHAR2(100):= g_package||'range_code_v3';
554: l_action_info_id pay_action_information.action_information_id%TYPE;
555: l_ovn pay_action_information.object_version_number%TYPE;
556: --
557: BEGIN
558: --

Line 555: l_ovn pay_action_information.object_version_number%TYPE;

551: --
552: employer_rec c_employer%ROWTYPE;
553: l_proc CONSTANT VARCHAR2(100):= g_package||'range_code_v3';
554: l_action_info_id pay_action_information.action_information_id%TYPE;
555: l_ovn pay_action_information.object_version_number%TYPE;
556: --
557: BEGIN
558: --
559: hr_utility.set_location('Enering: '||l_proc, 10);

Line 579: pay_action_information_api.create_action_information (

575: hr_utility.trace(l_proc||': tax_district_name='||employer_rec.tax_district_name);
576: hr_utility.trace(l_proc||': organization_id='||employer_rec.organization_id);
577: hr_utility.trace(l_proc||': effective_Date='||fnd_date.date_to_displaydate(employer_rec.effective_date));
578: --
579: pay_action_information_api.create_action_information (
580: p_action_information_id => l_action_info_id
581: , p_action_context_id => pactid
582: , p_action_context_type => 'PA'
583: , p_object_version_number => l_ovn

Line 651: l_action_info_id pay_action_information.action_information_id%TYPE;

647: AND ppa.report_category = 'EDI';
648: --
649: employer_rec c_employer%ROWTYPE;
650: l_proc CONSTANT VARCHAR2(100):= g_package||'range_code_v4';
651: l_action_info_id pay_action_information.action_information_id%TYPE;
652: l_ovn pay_action_information.object_version_number%TYPE;
653: --
654: BEGIN
655: --

Line 652: l_ovn pay_action_information.object_version_number%TYPE;

648: --
649: employer_rec c_employer%ROWTYPE;
650: l_proc CONSTANT VARCHAR2(100):= g_package||'range_code_v4';
651: l_action_info_id pay_action_information.action_information_id%TYPE;
652: l_ovn pay_action_information.object_version_number%TYPE;
653: --
654: BEGIN
655: --
656: hr_utility.set_location('Enering: '||l_proc, 10);

Line 676: pay_action_information_api.create_action_information (

672: hr_utility.trace(l_proc||': tax_district_name='||employer_rec.tax_district_name);
673: hr_utility.trace(l_proc||': organization_id='||employer_rec.organization_id);
674: hr_utility.trace(l_proc||': effective_Date='||fnd_date.date_to_displaydate(employer_rec.effective_date));
675: --
676: pay_action_information_api.create_action_information (
677: p_action_information_id => l_action_info_id
678: , p_action_context_id => pactid
679: , p_action_context_type => 'PA'
680: , p_object_version_number => l_ovn

Line 747: l_action_info_id pay_action_information.action_information_id%TYPE;

743: AND ppa.report_category = 'EDI';
744: --
745: employer_rec c_employer%ROWTYPE;
746: l_proc CONSTANT VARCHAR2(100):= g_package||'range_code_v5';
747: l_action_info_id pay_action_information.action_information_id%TYPE;
748: l_ovn pay_action_information.object_version_number%TYPE;
749: --
750: BEGIN
751: --

Line 748: l_ovn pay_action_information.object_version_number%TYPE;

744: --
745: employer_rec c_employer%ROWTYPE;
746: l_proc CONSTANT VARCHAR2(100):= g_package||'range_code_v5';
747: l_action_info_id pay_action_information.action_information_id%TYPE;
748: l_ovn pay_action_information.object_version_number%TYPE;
749: --
750: BEGIN
751: --
752: hr_utility.set_location('Enering: '||l_proc, 10);

Line 772: pay_action_information_api.create_action_information (

768: hr_utility.trace(l_proc||': tax_district_name='||employer_rec.tax_district_name);
769: hr_utility.trace(l_proc||': organization_id='||employer_rec.organization_id);
770: hr_utility.trace(l_proc||': effective_Date='||fnd_date.date_to_displaydate(employer_rec.effective_date));
771: --
772: pay_action_information_api.create_action_information (
773: p_action_information_id => l_action_info_id
774: , p_action_context_id => pactid
775: , p_action_context_type => 'PA'
776: , p_object_version_number => l_ovn

Line 822: l_ovn pay_action_information.object_version_number%TYPE;

818: chunk IN NUMBER) IS
819: --
820: l_proc CONSTANT VARCHAR2(35):= g_package||'create_asg_act';
821: l_actid pay_assignment_actions.assignment_action_id%TYPE;
822: l_ovn pay_action_information.object_version_number%TYPE;
823: --
824: --
825: CURSOR c_param_values IS
826: SELECT to_number( pay_gb_eoy_archive.get_parameter(

Line 1287: l_ovn pay_action_information.object_version_number%TYPE;

1283: chunk IN NUMBER) IS
1284: --
1285: l_proc CONSTANT VARCHAR2(100):= g_package||'create_asg_act_v3';
1286: l_actid pay_assignment_actions.assignment_action_id%TYPE;
1287: l_ovn pay_action_information.object_version_number%TYPE;
1288: --
1289: --
1290: CURSOR c_param_values IS
1291: SELECT to_number( pay_gb_eoy_archive.get_parameter(

Line 1821: l_ovn pay_action_information.object_version_number%TYPE;

1817: chunk IN NUMBER) IS
1818: --
1819: l_proc CONSTANT VARCHAR2(100):= g_package||'create_asg_act_v4';
1820: l_actid pay_assignment_actions.assignment_action_id%TYPE;
1821: l_ovn pay_action_information.object_version_number%TYPE;
1822: --
1823: --
1824: CURSOR c_param_values IS
1825: SELECT to_number( pay_gb_eoy_archive.get_parameter(

Line 2361: l_ovn pay_action_information.object_version_number%TYPE;

2357: chunk IN NUMBER) IS
2358: --
2359: l_proc CONSTANT VARCHAR2(100):= g_package||'create_asg_act_v5';
2360: l_actid pay_assignment_actions.assignment_action_id%TYPE;
2361: l_ovn pay_action_information.object_version_number%TYPE;
2362: --
2363: --
2364: CURSOR c_param_values IS
2365: SELECT to_number( pay_gb_eoy_archive.get_parameter(

Line 2906: l_date_first_avail PAY_ACTION_INFORMATION.ACTION_INFORMATION14%TYPE;

2902: p_version_type IN VARCHAR2 DEFAULT NULL) IS -- Added the parameter for the Bug : 11075296. Fuel Type changes for EOY 2011/12
2903: --
2904: l_eff_date DATE;
2905: l_tax_year_start DATE;
2906: l_date_first_avail PAY_ACTION_INFORMATION.ACTION_INFORMATION14%TYPE;
2907: l_second_car_flag PAY_ACTION_INFORMATION.ACTION_INFORMATION15%TYPE;
2908: --
2909: CURSOR c_person(p_assignment_id IN NUMBER) IS
2910: SELECT p.last_name

Line 2907: l_second_car_flag PAY_ACTION_INFORMATION.ACTION_INFORMATION15%TYPE;

2903: --
2904: l_eff_date DATE;
2905: l_tax_year_start DATE;
2906: l_date_first_avail PAY_ACTION_INFORMATION.ACTION_INFORMATION14%TYPE;
2907: l_second_car_flag PAY_ACTION_INFORMATION.ACTION_INFORMATION15%TYPE;
2908: --
2909: CURSOR c_person(p_assignment_id IN NUMBER) IS
2910: SELECT p.last_name
2911: , p.title

Line 3020: l_action_info_id PAY_ACTION_INFORMATION.ACTION_INFORMATION_ID%TYPE;

3016: WHERE vehicle_allocation_id = p_vehicle_allocation_id
3017: AND l_eff_date between effective_start_date
3018: and effective_end_Date;
3019:
3020: l_action_info_id PAY_ACTION_INFORMATION.ACTION_INFORMATION_ID%TYPE;
3021: l_ovn PAY_ACTION_INFORMATION.OBJECT_VERSION_NUMBER%TYPE;
3022: l_proc CONSTANT VARCHAR2(50):= g_package||'archive_allocation_action';
3023: l_interval_of_payment VARCHAR2(1); -- Added the for the bug 9354919
3024: --

Line 3021: l_ovn PAY_ACTION_INFORMATION.OBJECT_VERSION_NUMBER%TYPE;

3017: AND l_eff_date between effective_start_date
3018: and effective_end_Date;
3019:
3020: l_action_info_id PAY_ACTION_INFORMATION.ACTION_INFORMATION_ID%TYPE;
3021: l_ovn PAY_ACTION_INFORMATION.OBJECT_VERSION_NUMBER%TYPE;
3022: l_proc CONSTANT VARCHAR2(50):= g_package||'archive_allocation_action';
3023: l_interval_of_payment VARCHAR2(1); -- Added the for the bug 9354919
3024: --
3025: BEGIN

Line 3096: pay_action_information_api.create_action_information (

3092: hr_utility.trace('Postal : ' || addr_rec.postal_code);
3093: hr_utility.trace('DOB : ' || fnd_date.date_to_canonical(person_rec.date_of_birth)); --For Bug 6652235
3094: hr_utility.trace('Gender : ' || person_rec.sex); --For Bug 6652235
3095:
3096: pay_action_information_api.create_action_information (
3097: p_action_information_id => l_action_info_id
3098: , p_action_context_id => p_asg_act_id
3099: , p_action_context_type => 'AAP'
3100: , p_object_version_number => l_ovn

Line 3198: pay_action_information_api.create_action_information (

3194:
3195: IF p_action_flag = 'N' THEN
3196: hr_utility.set_location(l_proc, 130);
3197: --
3198: pay_action_information_api.create_action_information (
3199: p_action_information_id => l_action_info_id
3200: , p_action_context_id => p_asg_act_id
3201: , p_action_context_type => 'AAP'
3202: , p_object_version_number => l_ovn

Line 3231: pay_action_information_api.create_action_information (

3227: hr_utility.set_location(l_proc, 140);
3228: ELSIF p_action_flag = 'R' THEN
3229: hr_utility.set_location(l_proc, 150);
3230: --
3231: pay_action_information_api.create_action_information (
3232: p_action_information_id => l_action_info_id
3233: , p_action_context_id => p_asg_act_id
3234: , p_action_context_type => 'AAP'
3235: , p_object_version_number => l_ovn

Line 3269: pay_action_information_api.create_action_information (

3265: hr_utility.set_location(l_proc, 160);
3266: ELSIF p_action_flag = 'W' THEN
3267: hr_utility.set_location(l_proc, 170);
3268: --
3269: pay_action_information_api.create_action_information (
3270: p_action_information_id => l_action_info_id
3271: , p_action_context_id => p_asg_act_id
3272: , p_action_context_type => 'AAP'
3273: , p_object_version_number => l_ovn

Line 3303: pay_action_information_api.create_action_information (

3299: hr_utility.set_location(l_proc, 180);
3300: ELSIF p_action_flag = 'F' THEN
3301: hr_utility.set_location(l_proc, 190);
3302: --
3303: pay_action_information_api.create_action_information (
3304: p_action_information_id => l_action_info_id
3305: , p_action_context_id => p_asg_act_id
3306: , p_action_context_type => 'AAP'
3307: , p_object_version_number => l_ovn