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_RTI_UPD dependencies on FND_DATE

Line 79: RETURN fnd_date.date_to_displaydate (l_date_soy);

75: END IF;
76:
77: hr_utility.trace ('date after soy check:'
78: || l_date_soy);
79: RETURN fnd_date.date_to_displaydate (l_date_soy);
80: END get_soy_date;
81:
82: PROCEDURE get_extra_info_exists
83: (p_assignment_id IN per_all_assignments_f.assignment_id%type

Line 436: p_effect_date := get_soy_date (fnd_date.date_to_displaydate (p_effective_date));

432:
433: hr_utility.trace ('assignment_id:'
434: || c_person_info.assignment_id);
435:
436: p_effect_date := get_soy_date (fnd_date.date_to_displaydate (p_effective_date));
437:
438: hr_utility.trace ('p_effect_date:'
439: || p_effect_date);
440:

Line 455: ,p_aei_information2 => fnd_date.date_to_canonical (p_effect_date)

451: ,p_business_group_id => c_person_info.business_group_id
452: ,p_information_type => 'GB_RTI_AGGREGATION'
453: ,p_aei_information_category => 'GB_RTI_AGGREGATION'
454: ,p_aei_information1 => l_ni_reporting_flag
455: ,p_aei_information2 => fnd_date.date_to_canonical (p_effect_date)
456: ,p_aei_information3 => l_rti_payroll_id
457: ,p_aei_information4 => l_payroll_id
458: ,p_object_version_number => p_object_version_number
459: ,p_assignment_extra_info_id => p_assignment_extra_info_id);

Line 467: ,p_aei_information2 => fnd_date.date_to_canonical (p_effect_date)

463: ,p_business_group_id => c_person_info.business_group_id
464: ,p_object_version_number => p_object_version_number
465: ,p_aei_information_category => 'GB_RTI_AGGREGATION'
466: ,p_aei_information1 => l_ni_reporting_flag
467: ,p_aei_information2 => fnd_date.date_to_canonical (p_effect_date)
468: ,p_aei_information3 => l_rti_payroll_id
469: ,p_aei_information4 => l_payroll_id);
470: END IF;
471: END LOOP;

Line 547: AND fnd_date.canonical_to_date(p_effective_date) between pap.effective_start_date

543: --AND asg.period_of_service_id = serv.period_of_service_id
544: AND pay.soft_coding_keyflex_id = sck.soft_coding_keyflex_id
545: AND upper (tax_ref_no) = upper (sck.segment1)
546: AND asg.assignment_type = 'E'
547: AND fnd_date.canonical_to_date(p_effective_date) between pap.effective_start_date
548: and pap.effective_end_date
549: AND fnd_date.canonical_to_date(p_effective_date) between asg.effective_start_date
550: and asg.effective_end_date
551: AND fnd_date.canonical_to_date(p_effective_date) between pay.effective_start_date

Line 549: AND fnd_date.canonical_to_date(p_effective_date) between asg.effective_start_date

545: AND upper (tax_ref_no) = upper (sck.segment1)
546: AND asg.assignment_type = 'E'
547: AND fnd_date.canonical_to_date(p_effective_date) between pap.effective_start_date
548: and pap.effective_end_date
549: AND fnd_date.canonical_to_date(p_effective_date) between asg.effective_start_date
550: and asg.effective_end_date
551: AND fnd_date.canonical_to_date(p_effective_date) between pay.effective_start_date
552: and pay.effective_end_date
553: /*AND pap.effective_start_date =

Line 551: AND fnd_date.canonical_to_date(p_effective_date) between pay.effective_start_date

547: AND fnd_date.canonical_to_date(p_effective_date) between pap.effective_start_date
548: and pap.effective_end_date
549: AND fnd_date.canonical_to_date(p_effective_date) between asg.effective_start_date
550: and asg.effective_end_date
551: AND fnd_date.canonical_to_date(p_effective_date) between pay.effective_start_date
552: and pay.effective_end_date
553: /*AND pap.effective_start_date =
554: (
555: SELECT MAX(papf2.effective_start_date)

Line 632: p_effect_date := get_soy_date (fnd_date.canonical_to_date(p_effective_date));

628: hr_utility.trace('Parameters are:');
629: hr_utility.trace('tax_ref_no:'||tax_ref_no);
630: hr_utility.trace('p_effective_date:'||p_effective_date);
631: hr_utility.trace('l_business_group_id:'||l_business_group_id);
632: p_effect_date := get_soy_date (fnd_date.canonical_to_date(p_effective_date));
633: hr_utility.trace('Effective Date after get_soy_date call:'||p_effect_date);
634:
635: fnd_file.put_line (fnd_file.output
636: ,rpad ('-----------------------------------------------------------------'

Line 656: || fnd_date.canonical_to_date(p_effective_date));

652: || l_business_group_id);
653:
654: fnd_file.put_line (fnd_file.output
655: ,'Effective Date : '
656: || fnd_date.canonical_to_date(p_effective_date));
657: fnd_file.put_line (fnd_file.output
658: ,rpad (' '
659: ,80));
660: fnd_file.put_line (fnd_file.output

Line 740: hr_utility.trace('p_aei_information2:'||fnd_date.date_to_canonical(p_effect_date));

736:
737: hr_utility.trace('Calling the Extra Information Insert API...');
738: hr_utility.trace('Parameters are:');
739: hr_utility.trace('p_aei_information1:'||l_ni_reporting_flag);
740: hr_utility.trace('p_aei_information2:'||fnd_date.date_to_canonical(p_effect_date));
741: hr_utility.trace('p_aei_information3:'||l_rti_payroll_id);
742:
743: pay_gb_aei_api.pay_gb_ins_rti_agg_strt
744: (p_assignment_id => v_person_details.assignment_id

Line 749: ,p_aei_information2 => fnd_date.date_to_canonical(l_effective_date)

745: ,p_business_group_id => l_business_group_id
746: ,p_information_type => 'GB_RTI_AGGREGATION'
747: ,p_aei_information_category => 'GB_RTI_AGGREGATION'
748: ,p_aei_information1 => l_ni_reporting_flag
749: ,p_aei_information2 => fnd_date.date_to_canonical(l_effective_date)
750: ,p_aei_information3 => l_rti_payroll_id
751: ,p_aei_information4 => l_payroll_id
752: ,p_object_version_number => p_object_version_number
753: ,p_assignment_extra_info_id => p_assignment_extra_info_id);