APPS.PAY_IE_P35_XML_PKG dependencies on FND_DATE

Line 292: l_end_date := fnd_date.canonical_to_date(p_end_date); --4641756

288: vXMLTable(vCtr).xmlString := ' ';
289: vCtr := vCtr + 1;
290: l_start_date := PAY_IE_P35_XML_PKG.get_start_date();
291: -- l_end_date := PAY_IE_P35_XML_PKG.get_end_date();
292: l_end_date := fnd_date.canonical_to_date(p_end_date); --4641756
293: hr_utility.set_location('End Date : '||p_end_date,100);
294:
295: IF p_payroll = 0 then
296: l_p_payroll := NULL;

Line 320: vXMLTable(vCtr).xmlString := '' || to_char(fnd_date.canonical_to_date(l_tax_year),'YYYY') || '';

316: l_contact_name,l_phone,l_addr1,l_addr2,l_addr3,l_week53,l_payroll,l_currency;
317: CLOSE csr_header_footer_info;
318: hr_utility.set_location('emprno' || to_char(l_empr_no),13);
319:
320: vXMLTable(vCtr).xmlString := '' || to_char(fnd_date.canonical_to_date(l_tax_year),'YYYY') || '';
321: vXMLTable(vCtr).xmlString := vXMLTable(vCtr).xmlString || '' || l_request_id || '';
322: vXMLTable(vCtr).xmlString := vXMLTable(vCtr).xmlString || '' || l_date || '';
323: vXMLTable(vCtr).xmlString := vXMLTable(vCtr).xmlString || '' || l_empr_no || '';
324: vXMLTable(vCtr).xmlString := vXMLTable(vCtr).xmlString || '' || l_empr_name || '';

Line 445: SELECT fnd_date.canonical_to_date (

441: RETURN DATE
442: AS
443: l_start_date DATE;
444: BEGIN
445: SELECT fnd_date.canonical_to_date (
446: SUBSTR (fpov.profile_option_value, 1, 4)
447: || '01/01 00:00:00'
448: )
449: INTO l_start_date

Line 467: SELECT fnd_date.canonical_to_date (

463: RETURN DATE
464: AS
465: l_end_date DATE;
466: BEGIN
467: SELECT fnd_date.canonical_to_date (
468: SUBSTR (fpov.profile_option_value, 1, 4)
469: || '12/31 23:59:59'
470: )
471: INTO l_end_date