APPS.PAY_PAYRPENP_XML_PKG dependencies on FND_DATE

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

65: l_end_date_char varchar2(60);
66: l_tag varchar2(200);
67:
68: begin
69: l_start_date_char := fnd_date.date_to_displaydate(p_start_date);
70: l_end_date_char := fnd_date.date_to_displaydate(p_end_date);
71:
72: l_tag := pay_prl_xml_utils.getTag('CP_ORGANIZATION_NAME', p_organization_name );
73: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

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

66: l_tag varchar2(200);
67:
68: begin
69: l_start_date_char := fnd_date.date_to_displaydate(p_start_date);
70: l_end_date_char := fnd_date.date_to_displaydate(p_end_date);
71:
72: l_tag := pay_prl_xml_utils.getTag('CP_ORGANIZATION_NAME', p_organization_name );
73: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
74:

Line 625: fnd_date.date_to_displaydate(period_start_date) ICX_period_start_date,

621: order_name order_name,
622: full_name full_name,
623: user_status user_status,
624: period_start_date period_start_date,
625: fnd_date.date_to_displaydate(period_start_date) ICX_period_start_date,
626: period_end_date period_end_date,
627: fnd_date.date_to_displaydate(period_end_date) ICX_period_end_date,
628: location_code location_code,
629: pay_basis pay_basis,

Line 627: fnd_date.date_to_displaydate(period_end_date) ICX_period_end_date,

623: user_status user_status,
624: period_start_date period_start_date,
625: fnd_date.date_to_displaydate(period_start_date) ICX_period_start_date,
626: period_end_date period_end_date,
627: fnd_date.date_to_displaydate(period_end_date) ICX_period_end_date,
628: location_code location_code,
629: pay_basis pay_basis,
630: assignment_id assignment_id,
631: person_id person_id,

Line 659: open csr_master for l_master_statement using fnd_date.canonical_to_date(p_start_date_char),

655: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
656:
657: cf_data_found := 0;
658:
659: open csr_master for l_master_statement using fnd_date.canonical_to_date(p_start_date_char),
660: fnd_date.canonical_to_date(p_end_date_char);
661: loop
662:
663: fetch csr_master into l_master_column1,l_master_column2,l_master_column3;

Line 660: fnd_date.canonical_to_date(p_end_date_char);

656:
657: cf_data_found := 0;
658:
659: open csr_master for l_master_statement using fnd_date.canonical_to_date(p_start_date_char),
660: fnd_date.canonical_to_date(p_end_date_char);
661: loop
662:
663: fetch csr_master into l_master_column1,l_master_column2,l_master_column3;
664: exit when csr_master%notfound;

Line 754: ,fnd_date.date_to_displayDT(SysDate)

750: ,l_location_code
751: ,l_consolidation_set_name
752: ,l_business_group_name
753: ,l_no_data_found
754: ,fnd_date.date_to_displayDT(SysDate)
755: ,fnd_date.canonical_to_date(p_start_date_char)
756: ,fnd_date.canonical_to_date(p_end_date_char)
757: ,l_group_column1
758: ,l_group_column2

Line 755: ,fnd_date.canonical_to_date(p_start_date_char)

751: ,l_consolidation_set_name
752: ,l_business_group_name
753: ,l_no_data_found
754: ,fnd_date.date_to_displayDT(SysDate)
755: ,fnd_date.canonical_to_date(p_start_date_char)
756: ,fnd_date.canonical_to_date(p_end_date_char)
757: ,l_group_column1
758: ,l_group_column2
759: ,l_group_column3

Line 756: ,fnd_date.canonical_to_date(p_end_date_char)

752: ,l_business_group_name
753: ,l_no_data_found
754: ,fnd_date.date_to_displayDT(SysDate)
755: ,fnd_date.canonical_to_date(p_start_date_char)
756: ,fnd_date.canonical_to_date(p_end_date_char)
757: ,l_group_column1
758: ,l_group_column2
759: ,l_group_column3
760: ,p_sort_option_one