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.OE_AUDIT_HISTORY_PVT dependencies on FND_DATE

Line 555: SELECT nvl(fnd_date.canonical_to_date(start_date),to_date('01/01/1950','MM/DD/RRRR')),

551:
552:
553: /* Get date range for which data needs to be collected for this entity */
554:
555: SELECT nvl(fnd_date.canonical_to_date(start_date),to_date('01/01/1950','MM/DD/RRRR')),
556: nvl(fnd_date.canonical_to_date(end_date), sysdate)
557: INTO min_hist_creation_date, max_hist_creation_date
558: FROM dual;
559: retcode := 0;

Line 556: nvl(fnd_date.canonical_to_date(end_date), sysdate)

552:
553: /* Get date range for which data needs to be collected for this entity */
554:
555: SELECT nvl(fnd_date.canonical_to_date(start_date),to_date('01/01/1950','MM/DD/RRRR')),
556: nvl(fnd_date.canonical_to_date(end_date), sysdate)
557: INTO min_hist_creation_date, max_hist_creation_date
558: FROM dual;
559: retcode := 0;
560:

Line 618: min_hist_creation_date := fnd_date.canonical_to_date(start_date);

614:
615: if start_date is null and end_date is null then
616: null;
617: elsif start_date is not null and end_date is null then
618: min_hist_creation_date := fnd_date.canonical_to_date(start_date);
619: max_hist_creation_date := sysdate;
620: elsif end_date is not null and start_date is null then
621: min_hist_creation_date := sysdate;
622: max_hist_creation_date := round(fnd_date.canonical_to_date(end_date)+1);

Line 622: max_hist_creation_date := round(fnd_date.canonical_to_date(end_date)+1);

618: min_hist_creation_date := fnd_date.canonical_to_date(start_date);
619: max_hist_creation_date := sysdate;
620: elsif end_date is not null and start_date is null then
621: min_hist_creation_date := sysdate;
622: max_hist_creation_date := round(fnd_date.canonical_to_date(end_date)+1);
623: elsif end_date is not null and start_date is not null then
624: min_hist_creation_date := fnd_date.canonical_to_date(start_date);
625: max_hist_creation_date := round(fnd_date.canonical_to_date(end_date)+1);
626: end if;

Line 624: min_hist_creation_date := fnd_date.canonical_to_date(start_date);

620: elsif end_date is not null and start_date is null then
621: min_hist_creation_date := sysdate;
622: max_hist_creation_date := round(fnd_date.canonical_to_date(end_date)+1);
623: elsif end_date is not null and start_date is not null then
624: min_hist_creation_date := fnd_date.canonical_to_date(start_date);
625: max_hist_creation_date := round(fnd_date.canonical_to_date(end_date)+1);
626: end if;
627:
628: if audit_duration is not null then

Line 625: max_hist_creation_date := round(fnd_date.canonical_to_date(end_date)+1);

621: min_hist_creation_date := sysdate;
622: max_hist_creation_date := round(fnd_date.canonical_to_date(end_date)+1);
623: elsif end_date is not null and start_date is not null then
624: min_hist_creation_date := fnd_date.canonical_to_date(start_date);
625: max_hist_creation_date := round(fnd_date.canonical_to_date(end_date)+1);
626: end if;
627:
628: if audit_duration is not null then
629: min_hist_creation_date := sysdate - audit_duration;

Line 1839: l_varchar_out := fnd_date.canonical_to_date(p_value);

1835: BEGIN
1836: IF p_datatype = 'N' THEN
1837: l_varchar_out := to_char(fnd_number.canonical_to_number(p_value));
1838: ELSIF p_datatype = 'X' THEN
1839: l_varchar_out := fnd_date.canonical_to_date(p_value);
1840: ELSIF p_datatype = 'Y' THEN
1841: l_varchar_out := fnd_date.canonical_to_date(p_value);
1842: ELSIF p_datatype = 'C' THEN
1843: l_varchar_out := p_value;

Line 1841: l_varchar_out := fnd_date.canonical_to_date(p_value);

1837: l_varchar_out := to_char(fnd_number.canonical_to_number(p_value));
1838: ELSIF p_datatype = 'X' THEN
1839: l_varchar_out := fnd_date.canonical_to_date(p_value);
1840: ELSIF p_datatype = 'Y' THEN
1841: l_varchar_out := fnd_date.canonical_to_date(p_value);
1842: ELSIF p_datatype = 'C' THEN
1843: l_varchar_out := p_value;
1844: ELSE
1845: l_varchar_out := p_value;