APPS.PAY_IE_P35_XML_PKG dependencies on FND_DATE

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

308: vXMLTable(vCtr).xmlString := ' ';
309: vCtr := vCtr + 1;
310: l_start_date := PAY_IE_P35_XML_PKG.get_start_date();
311: -- l_end_date := PAY_IE_P35_XML_PKG.get_end_date();
312: l_end_date := fnd_date.canonical_to_date(p_end_date); --4641756
313: hr_utility.set_location('End Date : '||p_end_date,100);
314:
315: l_reporting_year := to_char(l_start_date,'RRRR'); --12382953
316:

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

339: l_contact_name,l_phone,l_addr1,l_addr2,l_addr3,l_week53,l_payroll,l_currency;
340: CLOSE csr_header_footer_info;
341: hr_utility.set_location('emprno' || to_char(l_empr_no),13);
342:
343: vXMLTable(vCtr).xmlString := '' || to_char(fnd_date.canonical_to_date(l_tax_year),'YYYY') || '';
344: vXMLTable(vCtr).xmlString := vXMLTable(vCtr).xmlString || '' || l_request_id || '';
345: vXMLTable(vCtr).xmlString := vXMLTable(vCtr).xmlString || '' || l_date || '';
346: vXMLTable(vCtr).xmlString := vXMLTable(vCtr).xmlString || '' || l_empr_no || '';
347: vXMLTable(vCtr).xmlString := vXMLTable(vCtr).xmlString || '' || l_empr_name || '';

Line 507: SELECT fnd_date.canonical_to_date (

503: RETURN DATE
504: AS
505: l_start_date DATE;
506: BEGIN
507: SELECT fnd_date.canonical_to_date (
508: SUBSTR (fpov.profile_option_value, 1, 4)
509: || '01/01 00:00:00'
510: )
511: INTO l_start_date

Line 529: SELECT fnd_date.canonical_to_date (

525: RETURN DATE
526: AS
527: l_end_date DATE;
528: BEGIN
529: SELECT fnd_date.canonical_to_date (
530: SUBSTR (fpov.profile_option_value, 1, 4)
531: || '12/31 23:59:59'
532: )
533: INTO l_end_date