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); /*COMMENTED FOR BUG 11830805 */
80:
81: l_start_date_char := fnd_date.date_to_displaydate(p_start_date, calendar_aware=>FND_DATE.calendar_aware_alt); /* BUG 11830805 */
82:
83:
77:
78: begin
79: -- l_start_date_char := fnd_date.date_to_displaydate(p_start_date); /*COMMENTED FOR BUG 11830805 */
80:
81: l_start_date_char := fnd_date.date_to_displaydate(p_start_date, calendar_aware=>FND_DATE.calendar_aware_alt); /* BUG 11830805 */
82:
83:
84: -- l_end_date_char := fnd_date.date_to_displaydate(p_end_date); /*COMMENTED FOR BUG 11830805 */
85:
80:
81: l_start_date_char := fnd_date.date_to_displaydate(p_start_date, calendar_aware=>FND_DATE.calendar_aware_alt); /* BUG 11830805 */
82:
83:
84: -- l_end_date_char := fnd_date.date_to_displaydate(p_end_date); /*COMMENTED FOR BUG 11830805 */
85:
86: l_end_date_char := fnd_date.date_to_displaydate(p_end_date, calendar_aware=>FND_DATE.calendar_aware_alt); /* BUG 11830805 */
87:
88:
82:
83:
84: -- l_end_date_char := fnd_date.date_to_displaydate(p_end_date); /*COMMENTED FOR BUG 11830805 */
85:
86: l_end_date_char := fnd_date.date_to_displaydate(p_end_date, calendar_aware=>FND_DATE.calendar_aware_alt); /* BUG 11830805 */
87:
88:
89: l_tag := pay_prl_xml_utils.getTag('CP_CONSOLIDATION_SET_NAME', p_consolidation_set_name );
90: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
432: 'select
433: ppf.person_id person_id,
434: ppf.full_name full_name,
435: ppf.employee_number employee_number,
436: fnd_date.date_to_displaydate(ppa.effective_date, calendar_aware => 2) effective_date, -- fnd_date.date_to_displaydate(ppa.effective_date) effective_date, /* BUG 11830805 */
437: ppa.action_type action_type,
438: paa.assignment_action_id action_number,
439: paf.assignment_number assignment_number,
440: pay.payroll_name payroll_name,
486: l_tag := '
487: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
488:
489:
490: l_session_date := fnd_date.canonical_to_date(p_session_date_char);
491: l_start_date := fnd_date.canonical_to_date(p_start_date_char);
492: l_end_date := fnd_date.canonical_to_date(p_end_date_char);
493:
494:
487: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
488:
489:
490: l_session_date := fnd_date.canonical_to_date(p_session_date_char);
491: l_start_date := fnd_date.canonical_to_date(p_start_date_char);
492: l_end_date := fnd_date.canonical_to_date(p_end_date_char);
493:
494:
495: cf_record_counter := 0;
488:
489:
490: l_session_date := fnd_date.canonical_to_date(p_session_date_char);
491: l_start_date := fnd_date.canonical_to_date(p_start_date_char);
492: l_end_date := fnd_date.canonical_to_date(p_end_date_char);
493:
494:
495: cf_record_counter := 0;
496:
546: ,l_business_group_name
547: ,cf_record_counter
548: ,p_report_name
549: ,l_mode_desc
550: ,fnd_date.date_to_displayDT(SysDate, calendar_aware=>FND_DATE.calendar_aware_alt) -- ,fnd_date.date_to_displayDT(SysDate) /* BUG 11830805 */
551: ,l_start_date
552: ,l_end_date
553: ,l_template_name
554: );