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.PQP_US_SRS_EXTRACTS dependencies on FND_DATE

Line 212: p_start_date := fnd_date.date_to_canonical(g_extract_start_date);

208: hr_utility.set_location('Entering: '||l_proc_name, 5);
209: -- nocopy changes tmehra
210: l_date_nc := p_start_date;
211: If g_extract_start_date Is not Null Then
212: p_start_date := fnd_date.date_to_canonical(g_extract_start_date);
213: hr_utility.set_location('.......Period Start Date :'||p_start_date,10);
214: End If;
215: hr_utility.set_location('Leaving: '||l_proc_name, 15);
216: Return 0;

Line 239: p_end_date := fnd_date.date_to_canonical(g_extract_end_date);

235: hr_utility.set_location('Entering: '||l_proc_name, 5);
236: -- nocopy changes tmehra
237: l_date_nc := p_end_date;
238: If g_extract_end_date Is not Null Then
239: p_end_date := fnd_date.date_to_canonical(g_extract_end_date);
240: hr_utility.set_location('.......Period End Date :'||p_end_date,10);
241: End If;
242: hr_utility.set_location('Leaving: '||l_proc_name, 15);
243: Return 0;

Line 815: l_start_date := fnd_date.canonical_to_date(l_assig_extra_info.aei_information1);

811: Begin
812: hr_utility.set_location('Entering: '||l_proc_name, 5);
813: For l_assig_extra_info In csr_assig_extra_info( c_assignment_id => p_assignment_id)
814: Loop
815: l_start_date := fnd_date.canonical_to_date(l_assig_extra_info.aei_information1);
816: If l_assig_extra_info.aei_information2 Is Null Then
817: l_end_date := to_date('31/12/4712','DD/MM/YYYY');
818: Else
819: l_end_date := fnd_date.canonical_to_date(l_assig_extra_info.aei_information2);

Line 819: l_end_date := fnd_date.canonical_to_date(l_assig_extra_info.aei_information2);

815: l_start_date := fnd_date.canonical_to_date(l_assig_extra_info.aei_information1);
816: If l_assig_extra_info.aei_information2 Is Null Then
817: l_end_date := to_date('31/12/4712','DD/MM/YYYY');
818: Else
819: l_end_date := fnd_date.canonical_to_date(l_assig_extra_info.aei_information2);
820: End If;
821: -- If the SRS Plan present in
822: If l_assig_extra_info.aei_information4 Is Not Null and
823: l_assig_extra_info.aei_information4 = p_extract_plan_name and

Line 1495: l_ff_value_fmt := ben_ext_fmt.apply_format_mask(FND_DATE.canonical_to_date(l_ff_value), i.frmt_mask_cd);

1491: l_ff_value_fmt := ben_ext_fmt.apply_format_mask(to_number(l_ff_value), i.frmt_mask_cd);
1492: l_ff_value := l_ff_value_fmt;
1493: Elsif substr(i.frmt_mask_lookup_cd,1,1) = 'D' then
1494: hr_utility.set_location('.....Applying Date format mask :ben_ext_fmt.apply_format_mask',55);
1495: l_ff_value_fmt := ben_ext_fmt.apply_format_mask(FND_DATE.canonical_to_date(l_ff_value), i.frmt_mask_cd);
1496: l_ff_value := l_ff_value_fmt;
1497: End If;
1498: End If;
1499: Exception -- incase l_ff_value is not valid for formatting, just don't format it.