APPS.PAY_PAYRPANP_XML_PKG dependencies on FND_DATE

Line 79: l_start_date_char := fnd_date.date_to_displaydate(p_start_date);

75: l_end_date_char varchar2(60);
76: l_tag varchar2(200);
77:
78: begin
79: l_start_date_char := fnd_date.date_to_displaydate(p_start_date);
80: l_end_date_char := fnd_date.date_to_displaydate(p_end_date);
81:
82: l_tag := pay_prl_xml_utils.getTag('CP_CONSOLIDATION_SET_NAME', p_consolidation_set_name );
83: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

Line 80: l_end_date_char := fnd_date.date_to_displaydate(p_end_date);

76: l_tag varchar2(200);
77:
78: begin
79: l_start_date_char := fnd_date.date_to_displaydate(p_start_date);
80: l_end_date_char := fnd_date.date_to_displaydate(p_end_date);
81:
82: l_tag := pay_prl_xml_utils.getTag('CP_CONSOLIDATION_SET_NAME', p_consolidation_set_name );
83: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
84:

Line 429: fnd_date.date_to_displaydate(ppa.effective_date) effective_date,

425: 'select
426: ppf.person_id person_id,
427: ppf.full_name full_name,
428: ppf.employee_number employee_number,
429: fnd_date.date_to_displaydate(ppa.effective_date) effective_date,
430: ppa.action_type action_type,
431: paa.assignment_action_id action_number,
432: paf.assignment_number assignment_number,
433: pay.payroll_name payroll_name,

Line 483: l_session_date := fnd_date.canonical_to_date(p_session_date_char);

479: l_tag := '';
480: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
481:
482:
483: l_session_date := fnd_date.canonical_to_date(p_session_date_char);
484: l_start_date := fnd_date.canonical_to_date(p_start_date_char);
485: l_end_date := fnd_date.canonical_to_date(p_end_date_char);
486:
487:

Line 484: l_start_date := fnd_date.canonical_to_date(p_start_date_char);

480: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
481:
482:
483: l_session_date := fnd_date.canonical_to_date(p_session_date_char);
484: l_start_date := fnd_date.canonical_to_date(p_start_date_char);
485: l_end_date := fnd_date.canonical_to_date(p_end_date_char);
486:
487:
488: cf_record_counter := 0;

Line 485: l_end_date := fnd_date.canonical_to_date(p_end_date_char);

481:
482:
483: l_session_date := fnd_date.canonical_to_date(p_session_date_char);
484: l_start_date := fnd_date.canonical_to_date(p_start_date_char);
485: l_end_date := fnd_date.canonical_to_date(p_end_date_char);
486:
487:
488: cf_record_counter := 0;
489:

Line 543: ,fnd_date.date_to_displayDT(SysDate)

539: ,l_business_group_name
540: ,cf_record_counter
541: ,p_report_name
542: ,l_mode_desc
543: ,fnd_date.date_to_displayDT(SysDate)
544: ,l_start_date
545: ,l_end_date
546: ,l_template_name
547: );