eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_FR_DISABILITY_UPG_PKG dependencies on FND_DATE

Line 100: ELSIF FND_date.canonical_to_date(l_disabled.PEI_INFORMATION6) < l_person_start_date THEN

96: /* Determine Start date for disability record */
97: IF l_disabled.PEI_INFORMATION6 IS NULL THEN
98: -- Disability Start Date is NULL. Use person start date
99: l_disabilities_start_date := l_person_start_date;
100: ELSIF FND_date.canonical_to_date(l_disabled.PEI_INFORMATION6) < l_person_start_date THEN
101: -- Disability started prior to employment. Therefore use person start date.
102: l_disabilities_start_date := l_person_start_date;
103: ELSIF FND_date.canonical_to_date(l_disabled.PEI_INFORMATION6) BETWEEN l_person_start_date AND l_person_end_date THEN
104: -- Disability started within employment term. Use disability start date.

Line 103: ELSIF FND_date.canonical_to_date(l_disabled.PEI_INFORMATION6) BETWEEN l_person_start_date AND l_person_end_date THEN

99: l_disabilities_start_date := l_person_start_date;
100: ELSIF FND_date.canonical_to_date(l_disabled.PEI_INFORMATION6) < l_person_start_date THEN
101: -- Disability started prior to employment. Therefore use person start date.
102: l_disabilities_start_date := l_person_start_date;
103: ELSIF FND_date.canonical_to_date(l_disabled.PEI_INFORMATION6) BETWEEN l_person_start_date AND l_person_end_date THEN
104: -- Disability started within employment term. Use disability start date.
105: l_disabilities_start_date := FND_date.canonical_to_date(l_disabled.PEI_INFORMATION6);
106: ELSE
107: -- Disability Started after end date of employee

Line 105: l_disabilities_start_date := FND_date.canonical_to_date(l_disabled.PEI_INFORMATION6);

101: -- Disability started prior to employment. Therefore use person start date.
102: l_disabilities_start_date := l_person_start_date;
103: ELSIF FND_date.canonical_to_date(l_disabled.PEI_INFORMATION6) BETWEEN l_person_start_date AND l_person_end_date THEN
104: -- Disability started within employment term. Use disability start date.
105: l_disabilities_start_date := FND_date.canonical_to_date(l_disabled.PEI_INFORMATION6);
106: ELSE
107: -- Disability Started after end date of employee
108: per_fr_upgrade_data_pkg.write_log_message(p_message_name => 'PER_74992_DIS_BAD_STR_DATE');
109: l_record_status := 1;

Line 116: ELSIF FND_date.canonical_to_date(l_disabled.PEI_INFORMATION7) > l_person_end_date THEN

112: /* Determine End date for disability record */
113: IF l_disabled.PEI_INFORMATION7 IS NULL THEN
114: -- Disability end Date is NULL. Use person end date
115: l_disabilities_end_date := l_person_end_date;
116: ELSIF FND_date.canonical_to_date(l_disabled.PEI_INFORMATION7) > l_person_end_date THEN
117: -- Disability end date exceeds employment term, use end of employment
118: l_disabilities_end_date := l_person_end_date;
119: ELSIF (FND_date.canonical_to_date(l_disabled.PEI_INFORMATION7) between l_person_start_date AND l_person_end_date) THEN
120: -- Disability ended within employment term. Use Disability end date.

Line 119: ELSIF (FND_date.canonical_to_date(l_disabled.PEI_INFORMATION7) between l_person_start_date AND l_person_end_date) THEN

115: l_disabilities_end_date := l_person_end_date;
116: ELSIF FND_date.canonical_to_date(l_disabled.PEI_INFORMATION7) > l_person_end_date THEN
117: -- Disability end date exceeds employment term, use end of employment
118: l_disabilities_end_date := l_person_end_date;
119: ELSIF (FND_date.canonical_to_date(l_disabled.PEI_INFORMATION7) between l_person_start_date AND l_person_end_date) THEN
120: -- Disability ended within employment term. Use Disability end date.
121: l_disabilities_end_date := FND_date.canonical_to_date(l_disabled.PEI_INFORMATION7);
122: ELSE
123: -- Disability end before start date of employeee

Line 121: l_disabilities_end_date := FND_date.canonical_to_date(l_disabled.PEI_INFORMATION7);

117: -- Disability end date exceeds employment term, use end of employment
118: l_disabilities_end_date := l_person_end_date;
119: ELSIF (FND_date.canonical_to_date(l_disabled.PEI_INFORMATION7) between l_person_start_date AND l_person_end_date) THEN
120: -- Disability ended within employment term. Use Disability end date.
121: l_disabilities_end_date := FND_date.canonical_to_date(l_disabled.PEI_INFORMATION7);
122: ELSE
123: -- Disability end before start date of employeee
124: per_fr_upgrade_data_pkg.write_log_message(p_message_name => 'PER_74993_DIS_BAD_END_DATE');
125: l_record_status := 1;