eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_PAYRPENP_XML_PKG dependencies on FND_DATE

Line 69: -- l_start_date_char := fnd_date.date_to_displaydate(p_start_date); /* COMMENTED FOR BUG 11830805 */

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); /* COMMENTED FOR BUG 11830805 */
70: -- l_end_date_char := fnd_date.date_to_displaydate(p_end_date); /* COMMENTED FOR BUG 11830805 */
71:
72: l_start_date_char := fnd_date.date_to_displaydate(p_start_date, calendar_aware=>FND_DATE.calendar_aware_alt); /* FOR BUG 11830805 */
73: l_end_date_char := fnd_date.date_to_displaydate(p_end_date, calendar_aware=>FND_DATE.calendar_aware_alt); /* FOR BUG 11830805 */

Line 70: -- l_end_date_char := fnd_date.date_to_displaydate(p_end_date); /* COMMENTED FOR BUG 11830805 */

66: l_tag varchar2(200);
67:
68: begin
69: -- l_start_date_char := fnd_date.date_to_displaydate(p_start_date); /* COMMENTED FOR BUG 11830805 */
70: -- l_end_date_char := fnd_date.date_to_displaydate(p_end_date); /* COMMENTED FOR BUG 11830805 */
71:
72: l_start_date_char := fnd_date.date_to_displaydate(p_start_date, calendar_aware=>FND_DATE.calendar_aware_alt); /* FOR BUG 11830805 */
73: l_end_date_char := fnd_date.date_to_displaydate(p_end_date, calendar_aware=>FND_DATE.calendar_aware_alt); /* FOR BUG 11830805 */
74:

Line 72: l_start_date_char := fnd_date.date_to_displaydate(p_start_date, calendar_aware=>FND_DATE.calendar_aware_alt); /* FOR BUG 11830805 */

68: begin
69: -- l_start_date_char := fnd_date.date_to_displaydate(p_start_date); /* COMMENTED FOR BUG 11830805 */
70: -- l_end_date_char := fnd_date.date_to_displaydate(p_end_date); /* COMMENTED FOR BUG 11830805 */
71:
72: l_start_date_char := fnd_date.date_to_displaydate(p_start_date, calendar_aware=>FND_DATE.calendar_aware_alt); /* FOR BUG 11830805 */
73: l_end_date_char := fnd_date.date_to_displaydate(p_end_date, calendar_aware=>FND_DATE.calendar_aware_alt); /* FOR BUG 11830805 */
74:
75:
76: l_tag := pay_prl_xml_utils.getTag('CP_ORGANIZATION_NAME', p_organization_name );

Line 73: l_end_date_char := fnd_date.date_to_displaydate(p_end_date, calendar_aware=>FND_DATE.calendar_aware_alt); /* FOR BUG 11830805 */

69: -- l_start_date_char := fnd_date.date_to_displaydate(p_start_date); /* COMMENTED FOR BUG 11830805 */
70: -- l_end_date_char := fnd_date.date_to_displaydate(p_end_date); /* COMMENTED FOR BUG 11830805 */
71:
72: l_start_date_char := fnd_date.date_to_displaydate(p_start_date, calendar_aware=>FND_DATE.calendar_aware_alt); /* FOR BUG 11830805 */
73: l_end_date_char := fnd_date.date_to_displaydate(p_end_date, calendar_aware=>FND_DATE.calendar_aware_alt); /* FOR BUG 11830805 */
74:
75:
76: l_tag := pay_prl_xml_utils.getTag('CP_ORGANIZATION_NAME', p_organization_name );
77: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

Line 629: fnd_date.date_to_displaydate(period_start_date, calendar_aware=>2) ICX_period_start_date, -- fnd_date.date_to_displaydate(period_start_date) ICX_period_start_date, /* FOR BUG 11830805 */

625: order_name order_name,
626: full_name full_name,
627: user_status user_status,
628: period_start_date period_start_date,
629: fnd_date.date_to_displaydate(period_start_date, calendar_aware=>2) ICX_period_start_date, -- fnd_date.date_to_displaydate(period_start_date) ICX_period_start_date, /* FOR BUG 11830805 */
630: period_end_date period_end_date,
631: fnd_date.date_to_displaydate(period_end_date, calendar_aware=>2) ICX_period_end_date, -- fnd_date.date_to_displaydate(period_end_date) ICX_period_end_date, /* FOR BUG 11830805 */
632: location_code location_code,
633: pay_basis pay_basis,

Line 631: fnd_date.date_to_displaydate(period_end_date, calendar_aware=>2) ICX_period_end_date, -- fnd_date.date_to_displaydate(period_end_date) ICX_period_end_date, /* FOR BUG 11830805 */

627: user_status user_status,
628: period_start_date period_start_date,
629: fnd_date.date_to_displaydate(period_start_date, calendar_aware=>2) ICX_period_start_date, -- fnd_date.date_to_displaydate(period_start_date) ICX_period_start_date, /* FOR BUG 11830805 */
630: period_end_date period_end_date,
631: fnd_date.date_to_displaydate(period_end_date, calendar_aware=>2) ICX_period_end_date, -- fnd_date.date_to_displaydate(period_end_date) ICX_period_end_date, /* FOR BUG 11830805 */
632: location_code location_code,
633: pay_basis pay_basis,
634: assignment_id assignment_id,
635: person_id person_id,

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

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

Line 664: fnd_date.canonical_to_date(p_end_date_char);

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

Line 758: ,fnd_date.date_to_displayDT(SysDate, calendar_aware=>FND_DATE.calendar_aware_alt) -- fnd_date.date_to_displayDT(SysDate) /* FOR BUG 11830805 */

754: ,l_location_code
755: ,l_consolidation_set_name
756: ,l_business_group_name
757: ,l_no_data_found
758: ,fnd_date.date_to_displayDT(SysDate, calendar_aware=>FND_DATE.calendar_aware_alt) -- fnd_date.date_to_displayDT(SysDate) /* FOR BUG 11830805 */
759: ,fnd_date.canonical_to_date(p_start_date_char)
760: ,fnd_date.canonical_to_date(p_end_date_char)
761: ,l_group_column1
762: ,l_group_column2

Line 759: ,fnd_date.canonical_to_date(p_start_date_char)

755: ,l_consolidation_set_name
756: ,l_business_group_name
757: ,l_no_data_found
758: ,fnd_date.date_to_displayDT(SysDate, calendar_aware=>FND_DATE.calendar_aware_alt) -- fnd_date.date_to_displayDT(SysDate) /* FOR BUG 11830805 */
759: ,fnd_date.canonical_to_date(p_start_date_char)
760: ,fnd_date.canonical_to_date(p_end_date_char)
761: ,l_group_column1
762: ,l_group_column2
763: ,l_group_column3

Line 760: ,fnd_date.canonical_to_date(p_end_date_char)

756: ,l_business_group_name
757: ,l_no_data_found
758: ,fnd_date.date_to_displayDT(SysDate, calendar_aware=>FND_DATE.calendar_aware_alt) -- fnd_date.date_to_displayDT(SysDate) /* FOR BUG 11830805 */
759: ,fnd_date.canonical_to_date(p_start_date_char)
760: ,fnd_date.canonical_to_date(p_end_date_char)
761: ,l_group_column1
762: ,l_group_column2
763: ,l_group_column3
764: ,p_sort_option_one