DBA Data[Home] [Help]

APPS.PER_EVS_MAG_REPORT dependencies on FND_DATE

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

1250: --
1251: hr_utility.set_location(l_proc,20);
1252:
1253: if p_start_date is null then
1254: l_start_date := fnd_date.canonical_to_date(to_char(sysdate,'YYYY/MM/DD'));
1255: else
1256: l_start_date := fnd_date.canonical_to_date(p_start_date);
1257: end if;
1258:

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

1252:
1253: if p_start_date is null then
1254: l_start_date := fnd_date.canonical_to_date(to_char(sysdate,'YYYY/MM/DD'));
1255: else
1256: l_start_date := fnd_date.canonical_to_date(p_start_date);
1257: end if;
1258:
1259: if p_end_date is null then
1260: l_end_date := to_date(to_char(sysdate,'YYYY') || '-12-31', 'YYYY-MM-DD');

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

1258:
1259: if p_end_date is null then
1260: l_end_date := to_date(to_char(sysdate,'YYYY') || '-12-31', 'YYYY-MM-DD');
1261: else
1262: l_end_date := fnd_date.canonical_to_date(p_end_date);
1263: end if;
1264:
1265: if p_media_type is NULL then
1266: l_media_type := 'DISKETTE';