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.GHR_NON_SF52_EXTRA_INFO dependencies on FND_DATE

Line 60: AND NVL(fnd_date.canonical_to_date(pei.pei_information1) ,p_effective_date)

56: pay_user_tables put
57: WHERE pei.person_id = p_person_id
58: AND pei.information_type = 'GHR_US_RETAINED_GRADE'
59: AND put.user_table_id = ghr_general.return_number(pei.pei_information6)
60: AND NVL(fnd_date.canonical_to_date(pei.pei_information1) ,p_effective_date)
61: <= p_effective_date
62: AND nvl(fnd_date.canonical_to_date(pei.pei_information2),p_effective_date)
63: >= p_effective_date
64: UNION

Line 62: AND nvl(fnd_date.canonical_to_date(pei.pei_information2),p_effective_date)

58: AND pei.information_type = 'GHR_US_RETAINED_GRADE'
59: AND put.user_table_id = ghr_general.return_number(pei.pei_information6)
60: AND NVL(fnd_date.canonical_to_date(pei.pei_information1) ,p_effective_date)
61: <= p_effective_date
62: AND nvl(fnd_date.canonical_to_date(pei.pei_information2),p_effective_date)
63: >= p_effective_date
64: UNION
65: SELECT pei_information1 From_Date,
66: pei_information2 To_date,

Line 139: BETWEEN NVL(fnd_date.canonical_to_date(pei.pei_information1) ,p_effective_date)

135: WHERE pei.person_id = p_person_id
136: AND pei.information_type = 'GHR_US_RETAINED_GRADE'
137: AND put.user_table_id = pei.pei_information6
138: AND p_effective_date
139: BETWEEN NVL(fnd_date.canonical_to_date(pei.pei_information1) ,p_effective_date)
140: AND NVL(fnd_date.canonical_to_date(pei.pei_information2),p_effective_date)
141: UNION
142: SELECT pei_information1 From_Date,
143: pei_information2 To_date,

Line 140: AND NVL(fnd_date.canonical_to_date(pei.pei_information2),p_effective_date)

136: AND pei.information_type = 'GHR_US_RETAINED_GRADE'
137: AND put.user_table_id = pei.pei_information6
138: AND p_effective_date
139: BETWEEN NVL(fnd_date.canonical_to_date(pei.pei_information1) ,p_effective_date)
140: AND NVL(fnd_date.canonical_to_date(pei.pei_information2),p_effective_date)
141: UNION
142: SELECT pei_information1 From_Date,
143: pei_information2 To_date,
144: pei_information3,

Line 348: set_ei(l_org_rec.rei_information15,fnd_date.date_to_canonical(p_effective_date),

344: END IF;
345: set_ei(l_org_rec.rei_information15,l_asg_ei_data.aei_information3,l_rei_rec.rei_information15,'Y');
346: --end Bug 5923620
347: ELSIF l_from_poid <> l_to_poid THEN
348: set_ei(l_org_rec.rei_information15,fnd_date.date_to_canonical(p_effective_date),
349: l_rei_rec.rei_information15,'Y');
350: END IF;
351: --Bug#4126188 End
352:

Line 991: -- set_ei(l_org_rec.rei_information5,fnd_date.date_to_canonical(p_effective_date),

987: p_asg_ei_data => l_asg_ei_data
988: );
989:
990: -- added on 02-oct-98 by skutteti to autopopulate with the effective date
991: -- set_ei(l_org_rec.rei_information5,fnd_date.date_to_canonical(p_effective_date),
992: -- l_rei_rec.rei_information5,l_refresh_flag);
993: -- set_ei(l_org_rec.rei_information5,l_asg_ei_data.aei_information3,
994: -- l_rei_rec.rei_information5,l_refresh_flag);
995: -- l_org_rec.rei_information5 := l_asg_ei_data.aei_information3;

Line 999: set_ei(l_org_rec.rei_information5,fnd_date.date_to_canonical(c_get_eff_rec.effective_date),

995: -- l_org_rec.rei_information5 := l_asg_ei_data.aei_information3;
996:
997: -- added on 3-dec-99 -- Refer bug 963634
998: for c_get_eff_rec in c_get_effective_date loop
999: set_ei(l_org_rec.rei_information5,fnd_date.date_to_canonical(c_get_eff_rec.effective_date),
1000: l_rei_rec.rei_information5,l_refresh_flag);
1001: exit;
1002: end loop;
1003:

Line 1032: fnd_date.date_to_canonical(l_dlei_date),

1028: OPEN c_noac_1xx;
1029: FETCH c_noac_1xx INTO l_dlei_date;
1030: IF l_dlei_date is not null THEN
1031: set_ei(l_org_rec.rei_information18,
1032: fnd_date.date_to_canonical(l_dlei_date),
1033: l_rei_rec.rei_information18,'Y');
1034: ELSE
1035: set_ei(l_org_rec.rei_information18,
1036: null,l_rei_rec.rei_information18,'Y');

Line 1156: fnd_date.date_to_canonical(nvl(p_effective_date,sysdate)+60),

1152: '124', '140', '141',
1153: '142', '143', '146',
1154: '148','170', '190' ) THEN
1155: set_ei(l_org_rec.rei_information3,
1156: fnd_date.date_to_canonical(nvl(p_effective_date,sysdate)+60),
1157: l_rei_rec.rei_information3,'Y');
1158: set_ei(l_org_rec.rei_information6, 'X',
1159: l_rei_rec.rei_information6,'Y');
1160: ELSE

Line 1189: fnd_date.date_to_canonical(add_months(nvl(p_effective_date,TRUNC(sysdate)),12)+1),

1185: IF l_noa_code in
1186: ( '115', '122', '149', '171') and
1187: nvl(l_tenure,hr_api.g_varchar2) = '0' THEN
1188: set_ei(l_org_rec.rei_information4,
1189: fnd_date.date_to_canonical(add_months(nvl(p_effective_date,TRUNC(sysdate)),12)+1),
1190: l_rei_rec.rei_information4,'Y');
1191: ELSE
1192: set_ei(l_org_rec.rei_information4,
1193: NULL,l_rei_rec.rei_information4,'Y');

Line 1200: fnd_date.date_to_canonical(nvl(p_effective_date,TRUNC(sysdate))+31),

1196: -- FEGLI Eligibility Expiration
1197: IF nvl(l_fegli,hr_api.g_varchar2) <> 'A0' AND
1198: l_noa_code NOT IN ('130','132','145','147','115', '122', '149', '171') THEN -- Bug 4669419
1199: set_ei(l_org_rec.rei_information10,
1200: fnd_date.date_to_canonical(nvl(p_effective_date,TRUNC(sysdate))+31),
1201: l_rei_rec.rei_information10,'Y');
1202: ELSE
1203: set_ei(l_org_rec.rei_information10,NULL,
1204: l_rei_rec.rei_information10,'Y');

Line 1210: fnd_date.date_to_canonical(nvl(l_scd,TRUNC(sysdate))),

1206: -- TSP SCD
1207: IF nvl(l_retirement_plan,hr_api.g_varchar2)
1208: in ('D','K','L','M','N','P') THEN
1209: set_ei(l_org_rec.rei_information12,
1210: fnd_date.date_to_canonical(nvl(l_scd,TRUNC(sysdate))),
1211: l_rei_rec.rei_information12,'Y');
1212: ELSE
1213: set_ei(l_org_rec.rei_information12,NULL,
1214: l_rei_rec.rei_information12,'Y');

Line 1237: set_ei(l_org_rec.rei_information16,fnd_date.date_to_canonical(l_effective_date),

1233: END IF; -- IF nvl(l_retirement_plan,hr_api.
1234: -- TSP Status Date
1235: IF NVL(l_retirement_plan,hr_api.g_varchar2)
1236: NOT IN ('2','4','5') THEN
1237: set_ei(l_org_rec.rei_information16,fnd_date.date_to_canonical(l_effective_date),
1238: l_rei_rec.rei_information16,'Y');
1239: set_ei(l_org_rec.rei_information18,NULL,l_rei_rec.rei_information18,'Y'); -- TSP Emp Contrib Elig Date
1240: ELSE
1241: set_ei(l_org_rec.rei_information16,NULL, l_rei_rec.rei_information16,'Y');

Line 1262: set_ei(l_org_rec.rei_information17,fnd_date.date_to_canonical(l_start_date), l_rei_rec.rei_information17,'Y');

1258: l_start_date := l_cur_start_date.start_date;
1259: END LOOP;
1260: END IF; -- IF to_number(to_char(l_effective_date,'MM'))
1261: /*Bug#6312182*/
1262: set_ei(l_org_rec.rei_information17,fnd_date.date_to_canonical(l_start_date), l_rei_rec.rei_information17,'Y');
1263: ELSE
1264: set_ei(l_org_rec.rei_information17,NULL,l_rei_rec.rei_information17,'Y');
1265: END IF; -- IF NVL(l_retirement_plan,hr_a
1266: -- TSP Emp Contrib Elig Date

Line 1324: l_date_temp_elig := fnd_date.canonical_to_date(l_per_ei_data.pei_information5);

1320: p_date_effective => nvl(l_effective_date,trunc(sysdate)),
1321: p_per_ei_data => l_per_ei_data
1322: );
1323:
1324: l_date_temp_elig := fnd_date.canonical_to_date(l_per_ei_data.pei_information5);
1325: l_agency_contrib_date := fnd_date.canonical_to_date(l_per_ei_data.pei_information14);
1326:
1327: hr_utility.set_location('l_date_temp_elig' || l_per_ei_data.pei_information5,111);
1328:

Line 1325: l_agency_contrib_date := fnd_date.canonical_to_date(l_per_ei_data.pei_information14);

1321: p_per_ei_data => l_per_ei_data
1322: );
1323:
1324: l_date_temp_elig := fnd_date.canonical_to_date(l_per_ei_data.pei_information5);
1325: l_agency_contrib_date := fnd_date.canonical_to_date(l_per_ei_data.pei_information14);
1326:
1327: hr_utility.set_location('l_date_temp_elig' || l_per_ei_data.pei_information5,111);
1328:
1329: IF l_family_code = 'CONV_APP' THEN

Line 1334: set_ei(l_org_rec.rei_information3, fnd_date.date_to_canonical(nvl(p_effective_date,sysdate)+60),l_rei_rec.rei_information3,'Y');

1330: IF l_fehb_exists = FALSE OR (l_fehb_exists = TRUE AND NVL(l_enrollment_option,'Z') = 'Z') THEN
1331: -- FEHB Eligibility expires
1332: IF l_noa_code IN ('500', '501', '507', '508', '520', '524', '540', '541', '542', '543', '546', '548', '570', '590') THEN
1333: hr_utility.set_location('inside 1st',121);
1334: set_ei(l_org_rec.rei_information3, fnd_date.date_to_canonical(nvl(p_effective_date,sysdate)+60),l_rei_rec.rei_information3,'Y');
1335: END IF;
1336: -- FEHB Temp eligibility expires
1337: IF l_noa_code IN ('515','522','549','571') THEN
1338: set_ei(l_org_rec.rei_information4,

Line 1339: fnd_date.date_to_canonical(add_months(nvl(l_effective_date,TRUNC(sysdate)),12)+1),l_rei_rec.rei_information4,'Y');

1335: END IF;
1336: -- FEHB Temp eligibility expires
1337: IF l_noa_code IN ('515','522','549','571') THEN
1338: set_ei(l_org_rec.rei_information4,
1339: fnd_date.date_to_canonical(add_months(nvl(l_effective_date,TRUNC(sysdate)),12)+1),l_rei_rec.rei_information4,'Y');
1340: END IF;
1341: -- Health Plan
1342: IF NVL(l_health_plan,'ZZ') = 'ZZ' THEN
1343: set_ei(l_org_rec.rei_information5, 'ZZ', l_rei_rec.rei_information5,'Y');

Line 1356: set_ei(l_org_rec.rei_information10, fnd_date.date_to_canonical(nvl(l_effective_date,TRUNC(sysdate))+31), l_rei_rec.rei_information10,'Y');

1352:
1353: -- FEGLI Eligibility expires
1354: IF NVL(l_fegli,hr_api.g_varchar2) <> 'A0' AND
1355: NVL(l_prev_fegli,hr_api.g_varchar2) = 'A0' THEN
1356: set_ei(l_org_rec.rei_information10, fnd_date.date_to_canonical(nvl(l_effective_date,TRUNC(sysdate))+31), l_rei_rec.rei_information10,'Y');
1357: END IF;
1358:
1359: -- Check if TSP exists
1360: l_new_element_name := NULL;

Line 1373: l_tsp_status_date := fnd_date.canonical_to_date(l_cur_element.screen_entry_value);

1369: FOR l_cur_element IN c_element_value(l_new_element_name,p_assignment_id, l_effective_date) LOOP
1370: IF l_cur_element.ipv_name = 'Status' then
1371: l_tsp_status := substr(l_cur_element.screen_entry_value,1,1);
1372: ELSIF l_cur_element.ipv_name = 'Status Date' then
1373: l_tsp_status_date := fnd_date.canonical_to_date(l_cur_element.screen_entry_value);
1374: END IF;
1375: END LOOP;
1376: END IF; -- IF l_tsp_exists = TRUE TH
1377:

Line 1380: set_ei(l_org_rec.rei_information12, fnd_date.date_to_canonical(nvl(l_scd,TRUNC(sysdate))), l_rei_rec.rei_information12,'Y');

1376: END IF; -- IF l_tsp_exists = TRUE TH
1377:
1378: -- TSP SCD
1379: IF nvl(l_retirement_plan,hr_api.g_varchar2) IN ('D','K','L','M','N','P') AND l_tsp_status IS NULL THEN
1380: set_ei(l_org_rec.rei_information12, fnd_date.date_to_canonical(nvl(l_scd,TRUNC(sysdate))), l_rei_rec.rei_information12,'Y');
1381: ELSE
1382: set_ei(l_org_rec.rei_information12,NULL, l_rei_rec.rei_information12,'Y');
1383: END IF; -- IF nvl(l_retirement_pl
1384:

Line 1399: set_ei(l_org_rec.rei_information16,fnd_date.date_to_canonical(l_effective_date), l_rei_rec.rei_information16,'Y');

1395: END IF; -- IF nvl(l_retirement_plan,hr_api.
1396:
1397: -- TSP Status Date
1398: IF NVL(l_retirement_plan,hr_api.g_varchar2) NOT IN ('2','4','5') AND l_tsp_status_date IS NULL THEN
1399: set_ei(l_org_rec.rei_information16,fnd_date.date_to_canonical(l_effective_date), l_rei_rec.rei_information16,'Y');
1400: ELSE
1401: set_ei(l_org_rec.rei_information16,NULL, l_rei_rec.rei_information16,'Y');
1402: END IF; -- -- TSP Status Date
1403:

Line 1422: set_ei(l_org_rec.rei_information17,fnd_date.date_to_canonical(l_start_date), l_rei_rec.rei_information17,'Y');

1418: END LOOP;
1419:
1420: END IF; -- IF to_number(to_char(l_effective_date,'MM'))
1421: /*Bug#6312182*/
1422: set_ei(l_org_rec.rei_information17,fnd_date.date_to_canonical(l_start_date), l_rei_rec.rei_information17,'Y');
1423: ELSE
1424: set_ei(l_org_rec.rei_information17,NULL,l_rei_rec.rei_information17,'Y');
1425: END IF; -- IF NVL(l_retirement_plan,hr_a
1426:

Line 1434: set_ei(l_org_rec.rei_information3,fnd_date.date_to_canonical(l_date_temp_elig+1),l_rei_rec.rei_information3,'Y');

1430: hr_utility.set_location('l_date_temp_elig ' || to_char(l_date_temp_elig,'dd/mm/yyyy'),121);
1431: IF l_fehb_exists = TRUE AND NVL(l_enrollment_option,'Z') = 'Z' THEN
1432: -- FEHB Eligibility date
1433: hr_utility.set_location('Inside l_enrollment_option ' || l_enrollment_option,121);
1434: set_ei(l_org_rec.rei_information3,fnd_date.date_to_canonical(l_date_temp_elig+1),l_rei_rec.rei_information3,'Y');
1435: -- Enrollment
1436: IF l_date_temp_elig <= l_effective_date THEN
1437: set_ei(l_org_rec.rei_information6, 'X', l_rei_rec.rei_information6,'Y');
1438: END IF; -- IF l_date_temp_elig

Line 1738: -- set_ei(l_org_rec.rei_information7,fnd_date.date_to_canonical(p_effective_date),

1734: );
1735:
1736: -- added on 2-oct-98 to autopopulate date arrived personnel office by the
1737: -- effective date
1738: -- set_ei(l_org_rec.rei_information7,fnd_date.date_to_canonical(p_effective_date),
1739: -- l_rei_rec.rei_information7,l_refresh_flag);
1740: -- set_ei(l_org_rec.rei_information7,l_asg_ei_data.aei_information3,
1741: -- l_rei_rec.rei_information7,l_refresh_flag);
1742: -- l_org_rec.rei_information7 := l_asg_ei_data.aei_information3;

Line 1746: set_ei(l_org_rec.rei_information7,fnd_date.date_to_canonical(c_get_eff_rec.effective_date),

1742: -- l_org_rec.rei_information7 := l_asg_ei_data.aei_information3;
1743:
1744: -- added on 3-dec-99 -- Refer bug 963634
1745: for c_get_eff_rec in c_get_effective_date loop
1746: set_ei(l_org_rec.rei_information7,fnd_date.date_to_canonical(c_get_eff_rec.effective_date),
1747: l_rei_rec.rei_information7,l_refresh_flag);
1748: exit;
1749: end loop;
1750: set_ei(l_org_rec.rei_information11,l_asg_ei_data.aei_information6,l_rei_rec.rei_information11,l_refresh_flag);

Line 1792: fnd_date.date_to_canonical(l_dlei_date),

1788: OPEN c_noac_130;
1789: FETCH c_noac_130 INTO l_dlei_date;
1790: IF l_dlei_date is not null THEN
1791: set_ei(l_org_rec.rei_information20,
1792: fnd_date.date_to_canonical(l_dlei_date),
1793: l_rei_rec.rei_information20,'Y');
1794: ELSE
1795: set_ei(l_org_rec.rei_information20,
1796: null,l_rei_rec.rei_information20,'Y');

Line 1984: set_ei(l_org_rec.rei_information5,fnd_date.date_to_canonical(c_get_eff_rec.effective_date),

1980: FOR c_get_eff_rec in c_get_effective_date
1981: LOOP
1982: IF (l_rei_rec.rei_information5 IS NULL) OR
1983: (l_noa_family_code = 'CORRECT' AND l_rei_rec.rei_information5 IS NOT NULL) THEN
1984: set_ei(l_org_rec.rei_information5,fnd_date.date_to_canonical(c_get_eff_rec.effective_date),
1985: l_rei_rec.rei_information5,l_refresh_flag);
1986: END IF;
1987: exit;
1988: END LOOP;

Line 2002: fnd_date.date_to_canonical(l_dlei_date),

1998: > nvl(get_pay_grd.from_grade_or_level,1)
1999: and get_pay_grd.to_pay_plan = get_pay_grd.from_pay_plan
2000: THEN
2001: set_ei(l_org_rec.rei_information20,
2002: fnd_date.date_to_canonical(l_dlei_date),
2003: l_rei_rec.rei_information20,'Y');
2004: END IF;
2005: END LOOP;
2006: ELSE

Line 2157: set_ei(l_org_rec.rei_information7,fnd_date.date_to_canonical(c_get_eff_rec.effective_date),

2153: ELSE
2154: FOR c_get_eff_rec in c_get_effective_date
2155: LOOP
2156: IF l_org_rec.rei_information7 IS NULL THEN
2157: set_ei(l_org_rec.rei_information7,fnd_date.date_to_canonical(c_get_eff_rec.effective_date),
2158: l_rei_rec.rei_information7,l_refresh_flag);
2159: ELSIF (nvl(l_noa_family_code,'C') = 'CORRECT' AND l_org_rec.rei_information7 IS NOT NULL) THEN
2160: set_ei(l_org_rec.rei_information7,fnd_date.date_to_canonical(c_get_eff_rec.effective_date),
2161: l_rei_rec.rei_information7,l_refresh_flag);

Line 2160: set_ei(l_org_rec.rei_information7,fnd_date.date_to_canonical(c_get_eff_rec.effective_date),

2156: IF l_org_rec.rei_information7 IS NULL THEN
2157: set_ei(l_org_rec.rei_information7,fnd_date.date_to_canonical(c_get_eff_rec.effective_date),
2158: l_rei_rec.rei_information7,l_refresh_flag);
2159: ELSIF (nvl(l_noa_family_code,'C') = 'CORRECT' AND l_org_rec.rei_information7 IS NOT NULL) THEN
2160: set_ei(l_org_rec.rei_information7,fnd_date.date_to_canonical(c_get_eff_rec.effective_date),
2161: l_rei_rec.rei_information7,l_refresh_flag);
2162: END IF;
2163: exit;
2164: END LOOP;

Line 2247: set_ei(l_org_rec.rei_information5,fnd_date.date_to_canonical(p_effective_date),l_rei_rec.rei_information5,l_refresh_flag);

2243: ,p_business_group_id => l_bg_id
2244: ,p_effective_date => nvl(p_effective_date,trunc(sysdate)));
2245: set_ei(l_org_rec.rei_information4,l_agency_code,l_rei_rec.rei_information4,l_refresh_flag);
2246: -- Begin Bug# 4126188
2247: set_ei(l_org_rec.rei_information5,fnd_date.date_to_canonical(p_effective_date),l_rei_rec.rei_information5,l_refresh_flag);
2248: -- End Bug# 4126188
2249: End if;
2250:
2251: End chg_data_element;

Line 2417: hr_utility.set_location('eff. date is ' || fnd_date.date_to_canonical(p_effective_date),1);

2413: -- populate the date award earned field with the effective_date
2414: --
2415: IF NVL(l_noa_family_code,'C') <> 'CORRECT' THEN -- Bug 2836175
2416: l_refresh_flag := l_per_refresh_flag;
2417: hr_utility.set_location('eff. date is ' || fnd_date.date_to_canonical(p_effective_date),1);
2418:
2419: --set_ei(l_org_rec.rei_information9, fnd_date.date_to_canonical(p_effective_date), l_rei_rec.rei_information9, l_refresh_flag);
2420: --Bug 2833942
2421: set_ei(l_org_rec.rei_information9, NVL(l_rei_rec.rei_information9,fnd_date.date_to_canonical(p_effective_date)), l_rei_rec.rei_information9, l_refresh_flag);

Line 2419: --set_ei(l_org_rec.rei_information9, fnd_date.date_to_canonical(p_effective_date), l_rei_rec.rei_information9, l_refresh_flag);

2415: IF NVL(l_noa_family_code,'C') <> 'CORRECT' THEN -- Bug 2836175
2416: l_refresh_flag := l_per_refresh_flag;
2417: hr_utility.set_location('eff. date is ' || fnd_date.date_to_canonical(p_effective_date),1);
2418:
2419: --set_ei(l_org_rec.rei_information9, fnd_date.date_to_canonical(p_effective_date), l_rei_rec.rei_information9, l_refresh_flag);
2420: --Bug 2833942
2421: set_ei(l_org_rec.rei_information9, NVL(l_rei_rec.rei_information9,fnd_date.date_to_canonical(p_effective_date)), l_rei_rec.rei_information9, l_refresh_flag);
2422:
2423: hr_utility.set_location('Eff date ' || p_effective_date,1);

Line 2421: set_ei(l_org_rec.rei_information9, NVL(l_rei_rec.rei_information9,fnd_date.date_to_canonical(p_effective_date)), l_rei_rec.rei_information9, l_refresh_flag);

2417: hr_utility.set_location('eff. date is ' || fnd_date.date_to_canonical(p_effective_date),1);
2418:
2419: --set_ei(l_org_rec.rei_information9, fnd_date.date_to_canonical(p_effective_date), l_rei_rec.rei_information9, l_refresh_flag);
2420: --Bug 2833942
2421: set_ei(l_org_rec.rei_information9, NVL(l_rei_rec.rei_information9,fnd_date.date_to_canonical(p_effective_date)), l_rei_rec.rei_information9, l_refresh_flag);
2422:
2423: hr_utility.set_location('Eff date ' || p_effective_date,1);
2424: hr_utility.set_location('Info9 for Gov Awards ' || l_org_rec.rei_information9,1);
2425: -- Start Bug 1379280

Line 2505: set_ei(l_org_rec.rei_information4,fnd_date.date_to_canonical(p_effective_date),l_rei_rec.rei_information4,l_refresh_flag);

2501: IF l_serv_oblig_code IS NULL THEN
2502: set_ei(l_org_rec.rei_information4,l_serv_oblig_stdt,l_rei_rec.rei_information4,l_refresh_flag);
2503: set_ei(l_org_rec.rei_information5,l_serv_oblig_enddt,l_rei_rec.rei_information5,l_refresh_flag);
2504: ELSE
2505: set_ei(l_org_rec.rei_information4,fnd_date.date_to_canonical(p_effective_date),l_rei_rec.rei_information4,l_refresh_flag);
2506: set_ei(l_org_rec.rei_information5,l_serv_oblig_enddt,l_rei_rec.rei_information5,l_refresh_flag);
2507: END IF;
2508: l_per_ei_data := null;
2509: End if;

Line 2780: set_ei(l_org_rec.rei_information3,fnd_date.date_to_canonical(p_effective_date),

2776: /* --Begin Bug# 4588575
2777: IF nvl(l_tenure,hr_api.g_varchar2) = '2' and
2778: nvl(l_pos_occpied,hr_api.g_varchar2) = '1' and
2779: nvl(l_pos_intel_pos,hr_api.g_varchar2) <> '2' THEN
2780: set_ei(l_org_rec.rei_information3,fnd_date.date_to_canonical(p_effective_date),
2781: l_rei_rec.rei_information3,l_refresh_flag);
2782: ELSE
2783: --end Bug# 4588575
2784: */ --Backout the changes done for Bug# 4588575

Line 2793: fnd_date.date_to_canonical(add_months(p_effective_date,36)),

2789: IF nvl(l_tenure,hr_api.g_varchar2) = '2' and
2790: nvl(l_pos_occpied,hr_api.g_varchar2) = '1' and
2791: l_rei_rec.rei_information3 IS NOT NULL THEN
2792: set_ei(l_org_rec.rei_information4,
2793: fnd_date.date_to_canonical(add_months(p_effective_date,36)),
2794: l_rei_rec.rei_information4,l_refresh_flag);
2795: ELSE
2796: --End Bug# 4588575
2797: */ --Backout the changes done for Bug# 4588575

Line 2807: fnd_date.date_to_canonical(add_months(p_effective_date,24)),

2803: l_rei_rec.rei_information5,l_refresh_flag);
2804: /*--Begin Bug# 4588575
2805: IF nvl(l_la_code1,hr_api.g_varchar2) = 'J8M' THEN
2806: set_ei( l_org_rec.rei_information6,
2807: fnd_date.date_to_canonical(add_months(p_effective_date,24)),
2808: l_rei_rec.rei_information6,l_refresh_flag);
2809: ELSE
2810: --End Bug# 4588575
2811: */ --Backout the changes done for Bug# 4588575

Line 2841: set_ei(l_org_rec.rei_information10,fnd_date.date_to_canonical(p_effective_date),

2837: p_per_ei_data => l_per_ei_data
2838: );
2839: l_refresh_flag := l_per_refresh_flag;
2840: IF l_first_noa_code not in('130','132','145','147') THEN
2841: set_ei(l_org_rec.rei_information10,fnd_date.date_to_canonical(p_effective_date),
2842: l_rei_rec.rei_information10,l_refresh_flag);
2843: ELSE
2844: set_ei(l_org_rec.rei_information10,l_per_ei_data.pei_information3,
2845: l_rei_rec.rei_information10,l_refresh_flag);

Line 2852: fnd_date.date_to_canonical(add_months(p_effective_date,12)),

2848: l_pos_occpied := pa_rec.position_occupied;
2849: END LOOP;
2850: IF l_first_noa_code not in('130','132','145','147') and l_pos_occpied = '1' THEN
2851: set_ei(l_org_rec.rei_information11,
2852: fnd_date.date_to_canonical(add_months(p_effective_date,12)),
2853: l_rei_rec.rei_information11,l_refresh_flag);
2854: ELSIF l_first_noa_code not in('130','132','145','147') and l_pos_occpied = '2' THEN
2855: set_ei(l_org_rec.rei_information11,
2856: fnd_date.date_to_canonical(add_months(p_effective_date,24)),

Line 2856: fnd_date.date_to_canonical(add_months(p_effective_date,24)),

2852: fnd_date.date_to_canonical(add_months(p_effective_date,12)),
2853: l_rei_rec.rei_information11,l_refresh_flag);
2854: ELSIF l_first_noa_code not in('130','132','145','147') and l_pos_occpied = '2' THEN
2855: set_ei(l_org_rec.rei_information11,
2856: fnd_date.date_to_canonical(add_months(p_effective_date,24)),
2857: l_rei_rec.rei_information11,l_refresh_flag);
2858: ELSE
2859: set_ei(l_org_rec.rei_information11,
2860: l_per_ei_data.pei_information4,

Line 2889: set_ei(l_org_rec.rei_information10,fnd_date.date_to_canonical(l_service_comp_date),

2885: l_retirement_plan := pa_rec.retirement_plan;
2886: l_service_comp_date := pa_rec.service_comp_date;
2887: END LOOP;
2888: IF l_first_noa_code not in('130','132','145','147') THEN
2889: set_ei(l_org_rec.rei_information10,fnd_date.date_to_canonical(l_service_comp_date),
2890: l_rei_rec.rei_information10,l_refresh_flag);
2891: set_ei(l_org_rec.rei_information11,fnd_date.date_to_canonical(l_service_comp_date),
2892: l_rei_rec.rei_information11,l_refresh_flag);
2893: ELSE

Line 2891: set_ei(l_org_rec.rei_information11,fnd_date.date_to_canonical(l_service_comp_date),

2887: END LOOP;
2888: IF l_first_noa_code not in('130','132','145','147') THEN
2889: set_ei(l_org_rec.rei_information10,fnd_date.date_to_canonical(l_service_comp_date),
2890: l_rei_rec.rei_information10,l_refresh_flag);
2891: set_ei(l_org_rec.rei_information11,fnd_date.date_to_canonical(l_service_comp_date),
2892: l_rei_rec.rei_information11,l_refresh_flag);
2893: ELSE
2894: set_ei(l_org_rec.rei_information10,l_per_ei_data.pei_information4,
2895: l_rei_rec.rei_information10,l_refresh_flag);

Line 2900: set_ei(l_org_rec.rei_information12,fnd_date.date_to_canonical(l_service_comp_date),

2896: set_ei(l_org_rec.rei_information11,l_per_ei_data.pei_information5,
2897: l_rei_rec.rei_information11,l_refresh_flag);
2898: END IF;
2899: IF l_retirement_plan in('2','4','5') AND l_first_noa_code not in('130','132','145','147') THEN
2900: set_ei(l_org_rec.rei_information12,fnd_date.date_to_canonical(l_service_comp_date),
2901: l_rei_rec.rei_information12,l_refresh_flag);
2902: ELSE
2903: set_ei(l_org_rec.rei_information12,l_per_ei_data.pei_information7,
2904: l_rei_rec.rei_information12,l_refresh_flag);

Line 3283: fnd_date.date_to_canonical(l_dlei_date),

3279: OPEN c_afhr_noac_sal_chg;
3280: FETCH c_afhr_noac_sal_chg INTO l_dlei_date;
3281: IF l_dlei_date is not null THEN
3282: set_ei(l_org_rec.rei_information5,
3283: fnd_date.date_to_canonical(l_dlei_date),
3284: l_rei_rec.rei_information5,'Y');
3285: ELSE
3286: -- Bug 3263140
3287: --Setting the value to NULL only if the original value is NULL

Line 3301: fnd_date.date_to_canonical(l_dlei_date),

3297: OPEN c_noac_sal_chg;
3298: FETCH c_noac_sal_chg INTO l_dlei_date;
3299: IF l_dlei_date is not null THEN
3300: set_ei(l_org_rec.rei_information5,
3301: fnd_date.date_to_canonical(l_dlei_date),
3302: l_rei_rec.rei_information5,'Y');
3303: ELSE
3304: -- Bug 3263140
3305: --Setting the value to NULL only if the original value is NULL

Line 3386: set_ei(l_org_rec.rei_information6,fnd_date.date_to_canonical(c_get_eff_rec.effective_date), l_rei_rec.rei_information6,'Y');

3382: /*End - Bug 6129752*/
3383: ELSE
3384: FOR c_get_eff_rec in c_get_effective_date
3385: LOOP
3386: set_ei(l_org_rec.rei_information6,fnd_date.date_to_canonical(c_get_eff_rec.effective_date), l_rei_rec.rei_information6,'Y');
3387: exit;
3388: END LOOP;
3389: END IF;
3390: END IF;