DBA Data[Home] [Help]

APPS.PER_EVS_MAG_REPORT dependencies on FND_DATE

Line 1274: l_start_date := fnd_date.canonical_to_date(to_char(sysdate,'YYYY/MM/DD'));

1270: --
1271: hr_utility.set_location(l_proc,20);
1272:
1273: if p_start_date is null then
1274: l_start_date := fnd_date.canonical_to_date(to_char(sysdate,'YYYY/MM/DD'));
1275: else
1276: l_start_date := fnd_date.canonical_to_date(p_start_date);
1277: end if;
1278:

Line 1276: l_start_date := fnd_date.canonical_to_date(p_start_date);

1272:
1273: if p_start_date is null then
1274: l_start_date := fnd_date.canonical_to_date(to_char(sysdate,'YYYY/MM/DD'));
1275: else
1276: l_start_date := fnd_date.canonical_to_date(p_start_date);
1277: end if;
1278:
1279: if p_end_date is null then
1280: l_end_date := to_date(to_char(sysdate,'YYYY') || '-12-31', 'YYYY-MM-DD');

Line 1282: l_end_date := fnd_date.canonical_to_date(p_end_date);

1278:
1279: if p_end_date is null then
1280: l_end_date := to_date(to_char(sysdate,'YYYY') || '-12-31', 'YYYY-MM-DD');
1281: else
1282: l_end_date := fnd_date.canonical_to_date(p_end_date);
1283: end if;
1284:
1285: if p_media_type is NULL then
1286: l_media_type := 'DISKETTE';