DBA Data[Home] [Help]

APPS.HR_CHKFMT dependencies on FND_DATE

Line 394: l_date := fnd_date.displaydate_to_date(value);

390:
391: result := TRUE;
392: -- now check that we have the correct date format
393: -- passed in.
394: l_date := fnd_date.displaydate_to_date(value);
395: --
396: -- the date format has been correctly verified.
397: -- now return it to the output field in the
398: -- canonical format of of 'YYYY/MM/DD'

Line 399: output := fnd_date.date_to_canonical(l_date);

395: --
396: -- the date format has been correctly verified.
397: -- now return it to the output field in the
398: -- canonical format of of 'YYYY/MM/DD'
399: output := fnd_date.date_to_canonical(l_date);
400: --
401: -- Return the corrected format to the output.
402: -- Needed for instance where user inputs a
403: -- value like '01-jan-99' which we want displayed

Line 405: value := fnd_date.date_to_displaydate(l_date);

401: -- Return the corrected format to the output.
402: -- Needed for instance where user inputs a
403: -- value like '01-jan-99' which we want displayed
404: -- as '01-JAN-1999'.
405: value := fnd_date.date_to_displaydate(l_date);
406: --
407: -- minimum and maximum checking.
408: if(minimum is not null) then
409: if(l_date < fnd_date.canonical_to_date(minimum)) then

Line 409: if(l_date < fnd_date.canonical_to_date(minimum)) then

405: value := fnd_date.date_to_displaydate(l_date);
406: --
407: -- minimum and maximum checking.
408: if(minimum is not null) then
409: if(l_date < fnd_date.canonical_to_date(minimum)) then
410: rgeflg := RGE_FAIL;
411: return;
412: end if;
413: end if;

Line 415: if(l_date > fnd_date.canonical_to_date(maximum)) then

411: return;
412: end if;
413: end if;
414: if(maximum is not null) then
415: if(l_date > fnd_date.canonical_to_date(maximum)) then
416: rgeflg := RGE_FAIL;
417: return;
418: end if;
419: end if;

Line 1367: l_date := fnd_date.canonical_to_date(input) ;

1363: l_date date ;
1364: oraformat varchar2(11);
1365: begin
1366: if(format = 'D' or format = 'DATE') then
1367: l_date := fnd_date.canonical_to_date(input) ;
1368: else
1369: oraformat := 'UNKNOWN'; -- this should cause failure.
1370: end if;
1371: --

Line 1373: return(fnd_date.date_to_displaydate(l_date));

1369: oraformat := 'UNKNOWN'; -- this should cause failure.
1370: end if;
1371: --
1372: -- now convert to external format.
1373: return(fnd_date.date_to_displaydate(l_date));
1374: end conv_date;
1375: --
1376: begin
1377: if(input is null) then