DBA Data[Home] [Help]

APPS.HR_DE_EXTRA_WORK_INC_CHECKS dependencies on FND_DATE

Line 48: IF p_incident_date > TRUNC(fnd_date.canonical_to_date(p_inc_information10)) THEN

44:
45: -- The Work Stop Date must be on or after Work Incident Date.
46: --
47: IF p_inc_information10 IS NOT NULL THEN
48: IF p_incident_date > TRUNC(fnd_date.canonical_to_date(p_inc_information10)) THEN
49: RAISE work_stop_date_too_early;
50: END IF;
51: END IF;
52: --

Line 57: IF p_incident_date > TRUNC(fnd_date.canonical_to_date(p_inc_information9)) THEN

53: --
54: -- The Payment End Date must be on or after Work Incident Date.
55: --
56: IF p_inc_information9 IS NOT NULL THEN
57: IF p_incident_date > TRUNC(fnd_date.canonical_to_date(p_inc_information9)) THEN
58: RAISE payment_end_date_too_early;
59: END IF;
60: END IF;
61: --

Line 66: IF p_incident_date > TRUNC(fnd_date.canonical_to_date(p_inc_information11)) THEN

62: --
63: -- The Work Resumption Date must be on or after Work Incident Date.
64: --
65: IF p_inc_information11 IS NOT NULL THEN
66: IF p_incident_date > TRUNC(fnd_date.canonical_to_date(p_inc_information11)) THEN
67: RAISE work_resump_date_too_early;
68: END IF;
69: END IF;
70: --

Line 75: IF p_incident_date < TRUNC(fnd_date.canonical_to_date(p_inc_information3)) THEN

71: --
72: -- The Job Start Date must be on or before Work Incident Date.
73: --
74: IF p_inc_information3 IS NOT NULL THEN
75: IF p_incident_date < TRUNC(fnd_date.canonical_to_date(p_inc_information3)) THEN
76: RAISE job_start_date_too_late;
77: END IF;
78: END IF;
79: --

Line 84: IF TRUNC(fnd_date.canonical_to_date(p_inc_information11)) < TRUNC(fnd_date.canonical_to_date(p_inc_information10)) THEN

80: --
81: -- The Work Stop Date must be on or before Work Resumption Date.
82: --
83: IF p_inc_information10 IS NOT NULL AND p_inc_information11 IS NOT NULL THEN
84: IF TRUNC(fnd_date.canonical_to_date(p_inc_information11)) < TRUNC(fnd_date.canonical_to_date(p_inc_information10)) THEN
85: RAISE resump_date_before_stop_date;
86: END IF;
87: END IF;
88: