DBA Data[Home] [Help]

APPS.PER_IN_DATA_PUMP dependencies on FND_DATE

Line 630: RETURN fnd_date.date_to_canonical(fnd_date.chardt_to_date(p_issue_date));

626: --------------------------------------------------------------------------+
627: FUNCTION get_issue_date(p_issue_date VARCHAR2)
628: RETURN varchar2 IS
629: BEGIN
630: RETURN fnd_date.date_to_canonical(fnd_date.chardt_to_date(p_issue_date));
631: EXCEPTION
632: WHEN OTHERS THEN
633: hr_data_pump.fail('get_issue_date', sqlerrm, p_issue_date);
634: RAISE;

Line 653: RETURN fnd_date.date_to_canonical(fnd_date.chardt_to_date(p_guardian_birth_date));

649:
650: FUNCTION get_birth_date(p_guardian_birth_date VARCHAR2)
651: RETURN varchar2 IS
652: BEGIN
653: RETURN fnd_date.date_to_canonical(fnd_date.chardt_to_date(p_guardian_birth_date));
654: EXCEPTION
655: WHEN OTHERS THEN
656: hr_data_pump.fail('get_birth_date', sqlerrm, p_guardian_birth_date);
657: RAISE;

Line 675: RETURN fnd_date.date_to_canonical(fnd_date.chardt_to_date(p_expiry_date));

671: --------------------------------------------------------------------------+
672: FUNCTION get_expiry_date(p_expiry_date VARCHAR2)
673: RETURN varchar2 IS
674: BEGIN
675: RETURN fnd_date.date_to_canonical(fnd_date.chardt_to_date(p_expiry_date));
676: EXCEPTION
677: WHEN OTHERS THEN
678: hr_data_pump.fail('get_expiry_date', sqlerrm, p_expiry_date);
679: RAISE;