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 68: AND NVL(fnd_date.canonical_to_date(pei.pei_information1) ,p_effective_date)

64: pay_user_tables put
65: WHERE pei.person_id = p_person_id
66: AND pei.information_type = 'GHR_US_RETAINED_GRADE'
67: AND put.user_table_id = ghr_general.return_number(pei.pei_information6)
68: AND NVL(fnd_date.canonical_to_date(pei.pei_information1) ,p_effective_date)
69: <= p_effective_date
70: AND nvl(fnd_date.canonical_to_date(pei.pei_information2),p_effective_date)
71: >= p_effective_date
72: UNION

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

66: AND pei.information_type = 'GHR_US_RETAINED_GRADE'
67: AND put.user_table_id = ghr_general.return_number(pei.pei_information6)
68: AND NVL(fnd_date.canonical_to_date(pei.pei_information1) ,p_effective_date)
69: <= p_effective_date
70: AND nvl(fnd_date.canonical_to_date(pei.pei_information2),p_effective_date)
71: >= p_effective_date
72: UNION
73: SELECT pei_information1 From_Date,
74: pei_information2 To_date,

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

124: WHERE pei.person_id = p_person_id
125: AND pei.information_type = 'GHR_US_RETAINED_GRADE'
126: AND put.user_table_id = pei.pei_information6
127: AND p_effective_date
128: BETWEEN NVL(fnd_date.canonical_to_date(pei.pei_information1) ,p_effective_date)
129: AND NVL(fnd_date.canonical_to_date(pei.pei_information2),p_effective_date);
130:
131:
132:

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

125: AND pei.information_type = 'GHR_US_RETAINED_GRADE'
126: AND put.user_table_id = pei.pei_information6
127: AND p_effective_date
128: BETWEEN NVL(fnd_date.canonical_to_date(pei.pei_information1) ,p_effective_date)
129: AND NVL(fnd_date.canonical_to_date(pei.pei_information2),p_effective_date);
130:
131:
132:
133: --Bug # 5584845

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

168: WHERE pei.person_id = p_person_id
169: AND pei.information_type = 'GHR_US_RETAINED_GRADE'
170: AND put.user_table_id = pei.pei_information6
171: AND p_effective_date
172: BETWEEN NVL(fnd_date.canonical_to_date(pei.pei_information1) ,p_effective_date)
173: AND NVL(fnd_date.canonical_to_date(pei.pei_information2),p_effective_date)
174: UNION
175: SELECT pei_information1 From_Date,
176: pei_information2 To_date,

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

169: AND pei.information_type = 'GHR_US_RETAINED_GRADE'
170: AND put.user_table_id = pei.pei_information6
171: AND p_effective_date
172: BETWEEN NVL(fnd_date.canonical_to_date(pei.pei_information1) ,p_effective_date)
173: AND NVL(fnd_date.canonical_to_date(pei.pei_information2),p_effective_date)
174: UNION
175: SELECT pei_information1 From_Date,
176: pei_information2 To_date,
177: pei_information3,

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

389: END IF;
390: set_ei(l_org_rec.rei_information15,l_asg_ei_data.aei_information3,l_rei_rec.rei_information15,'Y');
391: --end Bug 5923620
392: ELSIF l_from_poid <> l_to_poid THEN
393: set_ei(l_org_rec.rei_information15,fnd_date.date_to_canonical(p_effective_date),
394: l_rei_rec.rei_information15,'Y');
395: END IF;
396: --Bug#4126188 End
397:

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

1073: p_asg_ei_data => l_asg_ei_data
1074: );
1075:
1076: -- added on 02-oct-98 by skutteti to autopopulate with the effective date
1077: -- set_ei(l_org_rec.rei_information5,fnd_date.date_to_canonical(p_effective_date),
1078: -- l_rei_rec.rei_information5,l_refresh_flag);
1079: -- set_ei(l_org_rec.rei_information5,l_asg_ei_data.aei_information3,
1080: -- l_rei_rec.rei_information5,l_refresh_flag);
1081: -- l_org_rec.rei_information5 := l_asg_ei_data.aei_information3;

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

1081: -- l_org_rec.rei_information5 := l_asg_ei_data.aei_information3;
1082:
1083: -- added on 3-dec-99 -- Refer bug 963634
1084: for c_get_eff_rec in c_get_effective_date loop
1085: set_ei(l_org_rec.rei_information5,fnd_date.date_to_canonical(c_get_eff_rec.effective_date),
1086: l_rei_rec.rei_information5,l_refresh_flag);
1087: exit;
1088: end loop;
1089:

Line 1133: set_ei(l_org_rec.rei_information28,fnd_date.date_to_canonical(p_effective_date+365),l_rei_rec.rei_information28,l_refresh_flag);

1129:
1130: IF SUBSTR(l_valid_grade_name,1,2) = SUBSTR(l_target_grade_name,1,2) AND
1131: TO_NUMBER(SUBSTR(l_valid_grade_name,4,5)) < TO_NUMBER(SUBSTR(l_target_grade_name,4,5)) THEN
1132: hr_utility.set_location('promotion_eligibility_date default in appt_info '|| l_valid_grade_name,353);
1133: set_ei(l_org_rec.rei_information28,fnd_date.date_to_canonical(p_effective_date+365),l_rei_rec.rei_information28,l_refresh_flag);
1134: END IF;
1135: l_pos_ei_data := null;
1136: --End Bug# 14514445
1137: End if;

Line 1144: fnd_date.date_to_canonical(l_dlei_date),

1140: OPEN c_noac_1xx;
1141: FETCH c_noac_1xx INTO l_dlei_date;
1142: IF l_dlei_date is not null THEN
1143: set_ei(l_org_rec.rei_information18,
1144: fnd_date.date_to_canonical(l_dlei_date),
1145: l_rei_rec.rei_information18,'Y');
1146: ELSE
1147: set_ei(l_org_rec.rei_information18,
1148: null,l_rei_rec.rei_information18,'Y');

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

1310: '124', '140', '141',
1311: '142', '143', '146',
1312: '148','170') THEN
1313: set_ei(l_org_rec.rei_information3,
1314: fnd_date.date_to_canonical(nvl(p_effective_date,sysdate)+60),
1315: l_rei_rec.rei_information3,'Y');
1316: set_ei(l_org_rec.rei_information6, 'X',
1317: l_rei_rec.rei_information6,'Y');
1318: ELSE

Line 1321: l_nte_date := fnd_date.canonical_to_date(l_first_nte_date.first_noa_information1);

1317: l_rei_rec.rei_information6,'Y');
1318: ELSE
1319: --- Begin Bug# 14062681
1320: FOR l_first_nte_date IN c_first_nte_date LOOP
1321: l_nte_date := fnd_date.canonical_to_date(l_first_nte_date.first_noa_information1);
1322: END LOOP;
1323: IF l_noa_code in ('115','171','190') AND l_nte_date > p_effective_date+365 THEN
1324: set_ei(l_org_rec.rei_information3,
1325: fnd_date.date_to_canonical(nvl(p_effective_date,sysdate)+60),

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

1321: l_nte_date := fnd_date.canonical_to_date(l_first_nte_date.first_noa_information1);
1322: END LOOP;
1323: IF l_noa_code in ('115','171','190') AND l_nte_date > p_effective_date+365 THEN
1324: set_ei(l_org_rec.rei_information3,
1325: fnd_date.date_to_canonical(nvl(p_effective_date,sysdate)+60),
1326: l_rei_rec.rei_information3,'Y');
1327: set_ei(l_org_rec.rei_information6, 'X',
1328: l_rei_rec.rei_information6,'Y');
1329: ELSE

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

1356: IF l_noa_code in
1357: ( '115', '122', '149', '171') and
1358: nvl(l_tenure,hr_api.g_varchar2) = '0' THEN
1359: set_ei(l_org_rec.rei_information4,
1360: fnd_date.date_to_canonical(add_months(nvl(p_effective_date,TRUNC(sysdate)),12)+1),
1361: l_rei_rec.rei_information4,'Y');
1362: ELSE
1363: set_ei(l_org_rec.rei_information4,
1364: NULL,l_rei_rec.rei_information4,'Y');

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

1370: l_noa_code NOT IN ('130','132','145','147','115', '122', '149') THEN -- Bug 4669419
1371: -- Begin Bug# 10198463
1372: IF l_effective_date < to_date('01/10/2010','DD/MM/RRRR') THEN
1373: set_ei(l_org_rec.rei_information10,
1374: fnd_date.date_to_canonical(nvl(p_effective_date,TRUNC(sysdate))+31),
1375: l_rei_rec.rei_information10,'Y');
1376:
1377: ELSE
1378: -- End Bug# 10198463

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

1376:
1377: ELSE
1378: -- End Bug# 10198463
1379: set_ei(l_org_rec.rei_information10,
1380: fnd_date.date_to_canonical(nvl(p_effective_date,TRUNC(sysdate))+60),
1381: l_rei_rec.rei_information10,'Y');
1382: END IF; -- End Bug# 10198463
1383: ELSE
1384: --- Begin Bug# 14062681

Line 1386: l_nte_date := fnd_date.canonical_to_date(l_first_nte_date.first_noa_information1);

1382: END IF; -- End Bug# 10198463
1383: ELSE
1384: --- Begin Bug# 14062681
1385: FOR l_first_nte_date IN c_first_nte_date LOOP
1386: l_nte_date := fnd_date.canonical_to_date(l_first_nte_date.first_noa_information1);
1387: END LOOP;
1388: IF l_noa_code in ('171') AND l_nte_date > p_effective_date+365 THEN
1389: set_ei(l_org_rec.rei_information10,
1390: fnd_date.date_to_canonical(nvl(p_effective_date,TRUNC(sysdate))+60),

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

1386: l_nte_date := fnd_date.canonical_to_date(l_first_nte_date.first_noa_information1);
1387: END LOOP;
1388: IF l_noa_code in ('171') AND l_nte_date > p_effective_date+365 THEN
1389: set_ei(l_org_rec.rei_information10,
1390: fnd_date.date_to_canonical(nvl(p_effective_date,TRUNC(sysdate))+60),
1391: l_rei_rec.rei_information10,'Y');
1392: ELSE
1393: --- End Bug# 14062681
1394: set_ei(l_org_rec.rei_information10,NULL,

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

1399: --Begin Bug# 12557463, commented following and added in proc ghr_scd_info
1400: /*IF nvl(l_retirement_plan,hr_api.g_varchar2)
1401: in ('D','K','L','M','N','P') THEN
1402: set_ei(l_org_rec.rei_information12,
1403: fnd_date.date_to_canonical(nvl(l_scd,TRUNC(sysdate))),
1404: l_rei_rec.rei_information12,'Y');
1405: ELSE
1406: set_ei(l_org_rec.rei_information12,NULL,
1407: l_rei_rec.rei_information12,'Y');

Line 1413: IF l_effective_date >= fnd_date.canonical_to_date('2013/01/01') AND l_noa_code NOT IN ('130','132') THEN

1409: */
1410: --End Bug# 12557463
1411: -- TSP Rate
1412: --Bug# 15941036 added Retirement codes DR,KR,LR,MR,NR,PR effective from 01-Jan-2013
1413: IF l_effective_date >= fnd_date.canonical_to_date('2013/01/01') AND l_noa_code NOT IN ('130','132') THEN
1414: IF nvl(l_retirement_plan,hr_api.g_varchar2) IN ('D','K','L','M','N','P','1','3','6','C','E','F','G','R','T','H','W',
1415: 'DR','KR','LR','MR','NR','PR') AND l_tsp_status IS NULL THEN
1416: set_ei(l_org_rec.rei_information14,'03', l_rei_rec.rei_information14,'Y');
1417:

Line 1428: IF l_effective_date >= fnd_date.canonical_to_date('2013/01/01') AND l_noa_code NOT IN ('130','132') THEN

1424: END IF; -- IF l_effective_date > to_date('31/07/2010','DD/MM/RRRR')
1425:
1426: -- TSP Status
1427: --Bug# 15941036 added Retirement codes DR,KR,LR,MR,NR,PR effective from 01-Jan-2013
1428: IF l_effective_date >= fnd_date.canonical_to_date('2013/01/01') AND l_noa_code NOT IN ('130','132') THEN
1429: IF nvl(l_retirement_plan,hr_api.g_varchar2) IN ('D','K','L','M','N','P','1','3','6','C','E','F','G','R','T','H','W',
1430: 'DR','KR','LR','MR','NR','PR') THEN
1431: set_ei(l_org_rec.rei_information15,'A', l_rei_rec.rei_information15,'Y');
1432: END IF; -- IF nvl(l_retirement_plan,hr_api.

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

1461: END IF; -- IF l_effective_date > to_date('31/07/2010','DD/MM/RRRR')
1462: -- TSP Status Date
1463: IF NVL(l_retirement_plan,hr_api.g_varchar2)
1464: NOT IN ('2','4','5') THEN
1465: set_ei(l_org_rec.rei_information16,fnd_date.date_to_canonical(l_effective_date),
1466: l_rei_rec.rei_information16,'Y');
1467: set_ei(l_org_rec.rei_information18,NULL,l_rei_rec.rei_information18,'Y'); -- TSP Emp Contrib Elig Date
1468: ELSE
1469: set_ei(l_org_rec.rei_information16,NULL, l_rei_rec.rei_information16,'Y');

Line 1476: set_ei(l_org_rec.rei_information17,fnd_date.date_to_canonical(l_effective_date), l_rei_rec.rei_information17,'Y');

1472: --Begin Bug# 8622486
1473: -- TSP Agency Contrib Elig Date
1474: --Bug# 15941036 added Retirement codes DR,KR,LR,MR,NR,PR
1475: IF NVL(l_retirement_plan,hr_api.g_varchar2) IN ('D', 'K', 'L', 'M', 'N', 'P','DR','KR','LR','MR','NR','PR') THEN
1476: set_ei(l_org_rec.rei_information17,fnd_date.date_to_canonical(l_effective_date), l_rei_rec.rei_information17,'Y');
1477: /*
1478: -- Get Payroll ID
1479: FOR l_cur_payroll_id IN c_payroll_id(l_pa_request_id) LOOP
1480: l_payroll_id := l_cur_payroll_id.payroll_id;

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

1489: l_start_date := l_cur_start_date.start_date;
1490: END LOOP;
1491: END IF; -- IF to_number(to_char(l_effective_date,'MM'))
1492: --Bug#6312182
1493: set_ei(l_org_rec.rei_information17,fnd_date.date_to_canonical(l_start_date), l_rei_rec.rei_information17,'Y');
1494: */
1495: --End Bug# 8622486
1496: ELSE
1497: set_ei(l_org_rec.rei_information17,NULL,l_rei_rec.rei_information17,'Y');

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

1555: p_date_effective => nvl(l_effective_date,trunc(sysdate)),
1556: p_per_ei_data => l_per_ei_data
1557: );
1558:
1559: l_date_temp_elig := fnd_date.canonical_to_date(l_per_ei_data.pei_information5);
1560: l_agency_contrib_date := fnd_date.canonical_to_date(l_per_ei_data.pei_information14);
1561:
1562: hr_utility.set_location('l_date_temp_elig' || l_per_ei_data.pei_information5,111);
1563: --8793163 For Dual Actions Benefits need to defaulted even if second action is conversion to appointment

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

1556: p_per_ei_data => l_per_ei_data
1557: );
1558:
1559: l_date_temp_elig := fnd_date.canonical_to_date(l_per_ei_data.pei_information5);
1560: l_agency_contrib_date := fnd_date.canonical_to_date(l_per_ei_data.pei_information14);
1561:
1562: hr_utility.set_location('l_date_temp_elig' || l_per_ei_data.pei_information5,111);
1563: --8793163 For Dual Actions Benefits need to defaulted even if second action is conversion to appointment
1564: IF l_family_code = 'CONV_APP' OR nvl(l_second_noa_family_code,hr_api.g_varchar2) = 'CONV_APP' THEN

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

1568: --8793163 Added for second noa code
1569: IF l_noa_code IN ('500', '501', '507', '508', '520', '524', '540', '541', '542', '543', '546', '548', '570', '590') OR
1570: l_second_noa_code IN ('500', '501', '507', '508', '520', '524', '540', '541', '542', '543', '546', '548', '570', '590') THEN
1571: hr_utility.set_location('inside 1st',121);
1572: set_ei(l_org_rec.rei_information3, fnd_date.date_to_canonical(nvl(p_effective_date,sysdate)+60),l_rei_rec.rei_information3,'Y');
1573: END IF;
1574:
1575: --8793163 Added for second noa code
1576: -- FEHB Temp eligibility expires

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

1576: -- FEHB Temp eligibility expires
1577: IF l_noa_code IN ('515','522','549','571') OR
1578: l_second_noa_code IN ('515','522','549','571') THEN
1579: set_ei(l_org_rec.rei_information4,
1580: fnd_date.date_to_canonical(add_months(nvl(l_effective_date,TRUNC(sysdate)),12)+1),l_rei_rec.rei_information4,'Y');
1581: END IF;
1582: -- Health Plan
1583: IF NVL(l_health_plan,'ZZ') = 'ZZ' THEN
1584: set_ei(l_org_rec.rei_information5, 'ZZ', l_rei_rec.rei_information5,'Y');

Line 1602: set_ei(l_org_rec.rei_information10, fnd_date.date_to_canonical(nvl(l_effective_date,TRUNC(sysdate))+31),

1598: IF NVL(l_fegli,hr_api.g_varchar2) <> 'A0' AND
1599: NVL(l_prev_fegli,hr_api.g_varchar2) = 'A0' THEN
1600: -- Begin Bug# 10198463
1601: IF l_effective_date < to_date('01/10/2010','DD/MM/RRRR') THEN
1602: set_ei(l_org_rec.rei_information10, fnd_date.date_to_canonical(nvl(l_effective_date,TRUNC(sysdate))+31),
1603: l_rei_rec.rei_information10,'Y');
1604: ELSE
1605: -- Begin Bug# 10198463
1606: set_ei(l_org_rec.rei_information10, fnd_date.date_to_canonical(nvl(l_effective_date,TRUNC(sysdate))+60),

Line 1606: set_ei(l_org_rec.rei_information10, fnd_date.date_to_canonical(nvl(l_effective_date,TRUNC(sysdate))+60),

1602: set_ei(l_org_rec.rei_information10, fnd_date.date_to_canonical(nvl(l_effective_date,TRUNC(sysdate))+31),
1603: l_rei_rec.rei_information10,'Y');
1604: ELSE
1605: -- Begin Bug# 10198463
1606: set_ei(l_org_rec.rei_information10, fnd_date.date_to_canonical(nvl(l_effective_date,TRUNC(sysdate))+60),
1607: l_rei_rec.rei_information10,'Y');
1608: END IF;-- Begin Bug# 10198463
1609: END IF;
1610:

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

1621: FOR l_cur_element IN c_element_value(l_new_element_name,p_assignment_id, l_effective_date) LOOP
1622: IF l_cur_element.ipv_name = 'Status' then
1623: l_tsp_status := substr(l_cur_element.screen_entry_value,1,1);
1624: ELSIF l_cur_element.ipv_name = 'Status Date' then
1625: l_tsp_status_date := fnd_date.canonical_to_date(l_cur_element.screen_entry_value);
1626: END IF;
1627: END LOOP;
1628: END IF; -- IF l_tsp_exists = TRUE TH
1629:

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

1629:
1630: -- TSP SCD
1631: --Begin Bug# 12557463, commented following and added in proc ghr_scd_info
1632: /*IF nvl(l_retirement_plan,hr_api.g_varchar2) IN ('D','K','L','M','N','P') AND l_tsp_status IS NULL THEN
1633: set_ei(l_org_rec.rei_information12, fnd_date.date_to_canonical(nvl(l_scd,TRUNC(sysdate))), l_rei_rec.rei_information12,'Y');
1634: ELSE
1635: set_ei(l_org_rec.rei_information12,NULL, l_rei_rec.rei_information12,'Y');
1636: END IF; -- IF nvl(l_retirement_pl
1637: */

Line 1641: IF l_effective_date >= fnd_date.canonical_to_date('2013/01/01') THEN

1637: */
1638: --End Bug# 12557463
1639: -- TSP Rate
1640: --Bug# 15941036 added Retirement codes DR,KR,LR,MR,NR,PR effective from 01-Jan-2013
1641: IF l_effective_date >= fnd_date.canonical_to_date('2013/01/01') THEN
1642: IF nvl(l_retirement_plan,hr_api.g_varchar2) IN ('D','K','L','M','N','P','1','3','6','C','E','F','G','R','T','H','W',
1643: 'DR','KR','LR','MR','NR','PR') AND l_tsp_status IS NULL THEN
1644: set_ei(l_org_rec.rei_information14,'03', l_rei_rec.rei_information14,'Y');
1645: END IF; -- IF nvl(l_retirement_plan,hr_api.

Line 1656: IF l_effective_date >= fnd_date.canonical_to_date('2013/01/01') THEN

1652:
1653: -- TSP Status
1654: hr_utility.set_location('TSP status' || l_tsp_status,111);
1655: --Bug# 15941036 added Retirement codes DR,KR,LR,MR,NR,PR effective from 01-Jan-2013
1656: IF l_effective_date >= fnd_date.canonical_to_date('2013/01/01') THEN
1657: IF nvl(l_retirement_plan,hr_api.g_varchar2) IN ('D','K','L','M','N','P','1','3','6','C','E','F','G','R','T','H','W',
1658: 'DR','KR','LR','MR','NR','PR') AND l_tsp_status IS NULL THEN
1659: set_ei(l_org_rec.rei_information15,'A', l_rei_rec.rei_information15,'Y');
1660: END IF; -- IF nvl(l_retirement_plan,hr_api.

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

1680: END IF; -- IF l_effective_date > to_date('31/07/2010','DD/MM/RRRR')
1681:
1682: -- TSP Status Date
1683: IF NVL(l_retirement_plan,hr_api.g_varchar2) NOT IN ('2','4','5') AND l_tsp_status_date IS NULL THEN
1684: set_ei(l_org_rec.rei_information16,fnd_date.date_to_canonical(l_effective_date), l_rei_rec.rei_information16,'Y');
1685: ELSE
1686: set_ei(l_org_rec.rei_information16,NULL, l_rei_rec.rei_information16,'Y');
1687: END IF; -- -- TSP Status Date
1688: --Begin Bug# 8622486

Line 1692: set_ei(l_org_rec.rei_information17,fnd_date.date_to_canonical(l_effective_date), l_rei_rec.rei_information17,'Y');

1688: --Begin Bug# 8622486
1689: -- TSP Agency Contrib Elig Date
1690: --Bug# 15941036 added Retirement codes DR,KR,LR,MR,NR,PR
1691: IF NVL(l_retirement_plan,hr_api.g_varchar2) IN ('D', 'K', 'L', 'M', 'N', 'P','DR','KR','LR','MR','NR','PR') AND l_agency_contrib_date IS NULL THEN
1692: set_ei(l_org_rec.rei_information17,fnd_date.date_to_canonical(l_effective_date), l_rei_rec.rei_information17,'Y');
1693: /*
1694: -- Get Payroll ID
1695: FOR l_cur_payroll_id IN c_payroll_id(l_pa_request_id) LOOP
1696: l_payroll_id := l_cur_payroll_id.payroll_id;

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

1706: END LOOP;
1707:
1708: END IF; -- IF to_number(to_char(l_effective_date,'MM'))
1709: --Bug#6312182
1710: set_ei(l_org_rec.rei_information17,fnd_date.date_to_canonical(l_start_date), l_rei_rec.rei_information17,'Y');
1711: */
1712: --end Bug# 8622486
1713: ELSE
1714: set_ei(l_org_rec.rei_information17,NULL,l_rei_rec.rei_information17,'Y');

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

1721: IF l_fehb_exists = TRUE AND NVL(l_enrollment_option,'Z') = 'Z' THEN
1722: -- FEHB Eligibility date,Enrollment
1723: --bug# 12761010 moved rei_information3 to below
1724: IF l_date_temp_elig <= l_effective_date THEN
1725: set_ei(l_org_rec.rei_information3,fnd_date.date_to_canonical(l_date_temp_elig+1),l_rei_rec.rei_information3,'Y');
1726: set_ei(l_org_rec.rei_information6, 'X', l_rei_rec.rei_information6,'Y');
1727: END IF; -- IF l_date_temp_elig
1728: END IF; -- IF l_fehb_exists = TRUE
1729: END IF; -- IF l_noa_code IN ('760','762') THEN

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

2025: );
2026:
2027: -- added on 2-oct-98 to autopopulate date arrived personnel office by the
2028: -- effective date
2029: -- set_ei(l_org_rec.rei_information7,fnd_date.date_to_canonical(p_effective_date),
2030: -- l_rei_rec.rei_information7,l_refresh_flag);
2031: -- set_ei(l_org_rec.rei_information7,l_asg_ei_data.aei_information3,
2032: -- l_rei_rec.rei_information7,l_refresh_flag);
2033: -- l_org_rec.rei_information7 := l_asg_ei_data.aei_information3;

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

2033: -- l_org_rec.rei_information7 := l_asg_ei_data.aei_information3;
2034:
2035: -- added on 3-dec-99 -- Refer bug 963634
2036: for c_get_eff_rec in c_get_effective_date loop
2037: set_ei(l_org_rec.rei_information7,fnd_date.date_to_canonical(c_get_eff_rec.effective_date),
2038: l_rei_rec.rei_information7,l_refresh_flag);
2039: exit;
2040: end loop;
2041: set_ei(l_org_rec.rei_information11,l_asg_ei_data.aei_information6,l_rei_rec.rei_information11,l_refresh_flag);

Line 2098: set_ei(l_org_rec.rei_information27,fnd_date.date_to_canonical(p_effective_date+365),l_rei_rec.rei_information27,l_refresh_flag);

2094:
2095: IF SUBSTR(l_valid_grade_name,1,2) = SUBSTR(l_target_grade_name,1,2) AND
2096: TO_NUMBER(SUBSTR(l_valid_grade_name,4,5)) < TO_NUMBER(SUBSTR(l_target_grade_name,4,5)) THEN
2097: hr_utility.set_location('promotion_eligibility_date default '|| l_valid_grade_name,353);
2098: set_ei(l_org_rec.rei_information27,fnd_date.date_to_canonical(p_effective_date+365),l_rei_rec.rei_information27,l_refresh_flag);
2099: END IF;
2100: l_pos_ei_data := null;
2101: --End Bug# 14514445
2102: End if;

Line 2109: fnd_date.date_to_canonical(l_dlei_date),

2105: OPEN c_noac_130;
2106: FETCH c_noac_130 INTO l_dlei_date;
2107: IF l_dlei_date is not null THEN
2108: set_ei(l_org_rec.rei_information20,
2109: fnd_date.date_to_canonical(l_dlei_date),
2110: l_rei_rec.rei_information20,'Y');
2111: ELSE
2112: set_ei(l_org_rec.rei_information20,
2113: null,l_rei_rec.rei_information20,'Y');

Line 2299: set_ei(l_org_rec.rei_information26,fnd_date.date_to_canonical(p_effective_date+365),l_rei_rec.rei_information26,l_refresh_flag);

2295:
2296: IF SUBSTR(l_valid_grade_name,1,2) = SUBSTR(l_target_grade_name,1,2) AND
2297: TO_NUMBER(SUBSTR(l_valid_grade_name,4,5)) < TO_NUMBER(SUBSTR(l_target_grade_name,4,5)) THEN
2298: hr_utility.set_location('promotion_eligibility_date default in conv_appt '|| l_valid_grade_name,353);
2299: set_ei(l_org_rec.rei_information26,fnd_date.date_to_canonical(p_effective_date+365),l_rei_rec.rei_information26,l_refresh_flag);
2300: END IF;
2301: l_pos_ei_data := null;
2302: --End Bug# 14514445
2303: End if;

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

2360: FOR c_get_eff_rec in c_get_effective_date
2361: LOOP
2362: IF (l_rei_rec.rei_information5 IS NULL) OR
2363: (l_noa_family_code = 'CORRECT' AND l_rei_rec.rei_information5 IS NOT NULL) THEN
2364: set_ei(l_org_rec.rei_information5,fnd_date.date_to_canonical(c_get_eff_rec.effective_date),
2365: l_rei_rec.rei_information5,l_refresh_flag);
2366: END IF;
2367: exit;
2368: END LOOP;

Line 2382: fnd_date.date_to_canonical(l_dlei_date),

2378: > nvl(get_pay_grd.from_grade_or_level,1)
2379: and get_pay_grd.to_pay_plan = get_pay_grd.from_pay_plan
2380: THEN
2381: set_ei(l_org_rec.rei_information20,
2382: fnd_date.date_to_canonical(l_dlei_date),
2383: l_rei_rec.rei_information20,'Y');
2384: END IF;
2385: END LOOP;
2386: ELSE

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

2583: ELSE
2584: FOR c_get_eff_rec in c_get_effective_date
2585: LOOP
2586: IF l_org_rec.rei_information7 IS NULL THEN
2587: set_ei(l_org_rec.rei_information7,fnd_date.date_to_canonical(c_get_eff_rec.effective_date),
2588: l_rei_rec.rei_information7,l_refresh_flag);
2589: ELSIF (nvl(l_noa_family_code,'C') = 'CORRECT' AND l_org_rec.rei_information7 IS NOT NULL) THEN
2590: set_ei(l_org_rec.rei_information7,fnd_date.date_to_canonical(c_get_eff_rec.effective_date),
2591: l_rei_rec.rei_information7,l_refresh_flag);

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

2586: IF l_org_rec.rei_information7 IS NULL THEN
2587: set_ei(l_org_rec.rei_information7,fnd_date.date_to_canonical(c_get_eff_rec.effective_date),
2588: l_rei_rec.rei_information7,l_refresh_flag);
2589: ELSIF (nvl(l_noa_family_code,'C') = 'CORRECT' AND l_org_rec.rei_information7 IS NOT NULL) THEN
2590: set_ei(l_org_rec.rei_information7,fnd_date.date_to_canonical(c_get_eff_rec.effective_date),
2591: l_rei_rec.rei_information7,l_refresh_flag);
2592: END IF;
2593: exit;
2594: END LOOP;

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

2672: ,p_business_group_id => l_bg_id
2673: ,p_effective_date => nvl(p_effective_date,trunc(sysdate)));
2674: set_ei(l_org_rec.rei_information4,l_agency_code,l_rei_rec.rei_information4,l_refresh_flag);
2675: -- Begin Bug# 4126188
2676: set_ei(l_org_rec.rei_information5,fnd_date.date_to_canonical(p_effective_date),l_rei_rec.rei_information5,l_refresh_flag);
2677: -- End Bug# 4126188
2678: End if;
2679:
2680: End chg_data_element;

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

2948: -- populate the date award earned field with the effective_date
2949: --
2950: IF NVL(l_noa_family_code,'C') <> 'CORRECT' THEN -- Bug 2836175
2951: l_refresh_flag := l_per_refresh_flag;
2952: hr_utility.set_location('eff. date is ' || fnd_date.date_to_canonical(p_effective_date),1);
2953:
2954: --set_ei(l_org_rec.rei_information9, fnd_date.date_to_canonical(p_effective_date), l_rei_rec.rei_information9, l_refresh_flag);
2955: --Bug 2833942
2956: 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 2954: --set_ei(l_org_rec.rei_information9, fnd_date.date_to_canonical(p_effective_date), l_rei_rec.rei_information9, l_refresh_flag);

2950: IF NVL(l_noa_family_code,'C') <> 'CORRECT' THEN -- Bug 2836175
2951: l_refresh_flag := l_per_refresh_flag;
2952: hr_utility.set_location('eff. date is ' || fnd_date.date_to_canonical(p_effective_date),1);
2953:
2954: --set_ei(l_org_rec.rei_information9, fnd_date.date_to_canonical(p_effective_date), l_rei_rec.rei_information9, l_refresh_flag);
2955: --Bug 2833942
2956: 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);
2957:
2958: hr_utility.set_location('Eff date ' || p_effective_date,1);

Line 2956: 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);

2952: hr_utility.set_location('eff. date is ' || fnd_date.date_to_canonical(p_effective_date),1);
2953:
2954: --set_ei(l_org_rec.rei_information9, fnd_date.date_to_canonical(p_effective_date), l_rei_rec.rei_information9, l_refresh_flag);
2955: --Bug 2833942
2956: 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);
2957:
2958: hr_utility.set_location('Eff date ' || p_effective_date,1);
2959: hr_utility.set_location('Info9 for Gov Awards ' || l_org_rec.rei_information9,1);
2960: -- Start Bug 1379280

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

3036: IF l_serv_oblig_code IS NULL THEN
3037: set_ei(l_org_rec.rei_information4,l_serv_oblig_stdt,l_rei_rec.rei_information4,l_refresh_flag);
3038: set_ei(l_org_rec.rei_information5,l_serv_oblig_enddt,l_rei_rec.rei_information5,l_refresh_flag);
3039: ELSE
3040: set_ei(l_org_rec.rei_information4,fnd_date.date_to_canonical(p_effective_date),l_rei_rec.rei_information4,l_refresh_flag);
3041: set_ei(l_org_rec.rei_information5,l_serv_oblig_enddt,l_rei_rec.rei_information5,l_refresh_flag);
3042: END IF;
3043: l_per_ei_data := null;
3044: End if;

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

3317: /* --Begin Bug# 4588575
3318: IF nvl(l_tenure,hr_api.g_varchar2) = '2' and
3319: nvl(l_pos_occpied,hr_api.g_varchar2) = '1' and
3320: nvl(l_pos_intel_pos,hr_api.g_varchar2) <> '2' THEN
3321: set_ei(l_org_rec.rei_information3,fnd_date.date_to_canonical(p_effective_date),
3322: l_rei_rec.rei_information3,l_refresh_flag);
3323: ELSE
3324: --end Bug# 4588575
3325: */ --Backout the changes done for Bug# 4588575

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

3330: IF nvl(l_tenure,hr_api.g_varchar2) = '2' and
3331: nvl(l_pos_occpied,hr_api.g_varchar2) = '1' and
3332: l_rei_rec.rei_information3 IS NOT NULL THEN
3333: set_ei(l_org_rec.rei_information4,
3334: fnd_date.date_to_canonical(add_months(p_effective_date,36)),
3335: l_rei_rec.rei_information4,l_refresh_flag);
3336: ELSE
3337: --End Bug# 4588575
3338: */ --Backout the changes done for Bug# 4588575

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

3344: l_rei_rec.rei_information5,l_refresh_flag);
3345: /*--Begin Bug# 4588575
3346: IF nvl(l_la_code1,hr_api.g_varchar2) = 'J8M' THEN
3347: set_ei( l_org_rec.rei_information6,
3348: fnd_date.date_to_canonical(add_months(p_effective_date,24)),
3349: l_rei_rec.rei_information6,l_refresh_flag);
3350: ELSE
3351: --End Bug# 4588575
3352: */ --Backout the changes done for Bug# 4588575

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

3378: p_per_ei_data => l_per_ei_data
3379: );
3380: l_refresh_flag := l_per_refresh_flag;
3381: IF l_first_noa_code not in('130','132','145','147') THEN
3382: set_ei(l_org_rec.rei_information10,fnd_date.date_to_canonical(p_effective_date),
3383: l_rei_rec.rei_information10,l_refresh_flag);
3384: ELSE
3385: set_ei(l_org_rec.rei_information10,l_per_ei_data.pei_information3,
3386: l_rei_rec.rei_information10,l_refresh_flag);

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

3389: l_pos_occpied := pa_rec.position_occupied;
3390: END LOOP;
3391: IF l_first_noa_code not in('130','132','145','147') and l_pos_occpied = '1' THEN
3392: set_ei(l_org_rec.rei_information11,
3393: fnd_date.date_to_canonical(add_months(p_effective_date,12)),
3394: l_rei_rec.rei_information11,l_refresh_flag);
3395: ELSIF l_first_noa_code not in('130','132','145','147') and l_pos_occpied = '2' THEN
3396: set_ei(l_org_rec.rei_information11,
3397: fnd_date.date_to_canonical(add_months(p_effective_date,24)),

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

3393: fnd_date.date_to_canonical(add_months(p_effective_date,12)),
3394: l_rei_rec.rei_information11,l_refresh_flag);
3395: ELSIF l_first_noa_code not in('130','132','145','147') and l_pos_occpied = '2' THEN
3396: set_ei(l_org_rec.rei_information11,
3397: fnd_date.date_to_canonical(add_months(p_effective_date,24)),
3398: l_rei_rec.rei_information11,l_refresh_flag);
3399: ELSE
3400: set_ei(l_org_rec.rei_information11,
3401: l_per_ei_data.pei_information4,

Line 3439: set_ei(l_org_rec.rei_information1,fnd_date.date_to_canonical(l_service_comp_date),

3435: --End Bug# 14001082
3436: END LOOP;
3437:
3438: IF substr(l_first_noa_code,1,1) ='1' THEN
3439: set_ei(l_org_rec.rei_information1,fnd_date.date_to_canonical(l_service_comp_date),
3440: l_rei_rec.rei_information1,l_refresh_flag);
3441: set_ei(l_org_rec.rei_information2,fnd_date.date_to_canonical(l_service_comp_date),
3442: l_rei_rec.rei_information2,l_refresh_flag);
3443: set_ei(l_org_rec.rei_information3,fnd_date.date_to_canonical(l_service_comp_date),

Line 3441: set_ei(l_org_rec.rei_information2,fnd_date.date_to_canonical(l_service_comp_date),

3437:
3438: IF substr(l_first_noa_code,1,1) ='1' THEN
3439: set_ei(l_org_rec.rei_information1,fnd_date.date_to_canonical(l_service_comp_date),
3440: l_rei_rec.rei_information1,l_refresh_flag);
3441: set_ei(l_org_rec.rei_information2,fnd_date.date_to_canonical(l_service_comp_date),
3442: l_rei_rec.rei_information2,l_refresh_flag);
3443: set_ei(l_org_rec.rei_information3,fnd_date.date_to_canonical(l_service_comp_date),
3444: l_rei_rec.rei_information3,l_refresh_flag);
3445: --Begin Bug# 14514445

Line 3443: set_ei(l_org_rec.rei_information3,fnd_date.date_to_canonical(l_service_comp_date),

3439: set_ei(l_org_rec.rei_information1,fnd_date.date_to_canonical(l_service_comp_date),
3440: l_rei_rec.rei_information1,l_refresh_flag);
3441: set_ei(l_org_rec.rei_information2,fnd_date.date_to_canonical(l_service_comp_date),
3442: l_rei_rec.rei_information2,l_refresh_flag);
3443: set_ei(l_org_rec.rei_information3,fnd_date.date_to_canonical(l_service_comp_date),
3444: l_rei_rec.rei_information3,l_refresh_flag);
3445: --Begin Bug# 14514445
3446: set_ei(l_org_rec.rei_information10,fnd_date.date_to_canonical(l_service_comp_date),
3447: l_rei_rec.rei_information10,l_refresh_flag);

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

3442: l_rei_rec.rei_information2,l_refresh_flag);
3443: set_ei(l_org_rec.rei_information3,fnd_date.date_to_canonical(l_service_comp_date),
3444: l_rei_rec.rei_information3,l_refresh_flag);
3445: --Begin Bug# 14514445
3446: set_ei(l_org_rec.rei_information10,fnd_date.date_to_canonical(l_service_comp_date),
3447: l_rei_rec.rei_information10,l_refresh_flag);
3448: --End Bug# 14514445
3449: --Bug# 15941036 added Retirement codes DR,KR,LR,MR,NR,PR effective from 01-Jan-2013
3450: IF p_effective_date >= fnd_date.canonical_to_date('2013/01/01') AND

Line 3450: IF p_effective_date >= fnd_date.canonical_to_date('2013/01/01') AND

3446: set_ei(l_org_rec.rei_information10,fnd_date.date_to_canonical(l_service_comp_date),
3447: l_rei_rec.rei_information10,l_refresh_flag);
3448: --End Bug# 14514445
3449: --Bug# 15941036 added Retirement codes DR,KR,LR,MR,NR,PR effective from 01-Jan-2013
3450: IF p_effective_date >= fnd_date.canonical_to_date('2013/01/01') AND
3451: nvl(l_retirement_plan,hr_api.g_varchar2) in ('D','K','L','M','N','P','DR','KR','LR','MR','NR','PR') THEN
3452: set_ei(l_org_rec.rei_information6,fnd_date.date_to_canonical(l_service_comp_date),
3453: l_rei_rec.rei_information6,l_refresh_flag);
3454: ELSE

Line 3452: set_ei(l_org_rec.rei_information6,fnd_date.date_to_canonical(l_service_comp_date),

3448: --End Bug# 14514445
3449: --Bug# 15941036 added Retirement codes DR,KR,LR,MR,NR,PR effective from 01-Jan-2013
3450: IF p_effective_date >= fnd_date.canonical_to_date('2013/01/01') AND
3451: nvl(l_retirement_plan,hr_api.g_varchar2) in ('D','K','L','M','N','P','DR','KR','LR','MR','NR','PR') THEN
3452: set_ei(l_org_rec.rei_information6,fnd_date.date_to_canonical(l_service_comp_date),
3453: l_rei_rec.rei_information6,l_refresh_flag);
3454: ELSE
3455: IF nvl(l_retirement_plan,hr_api.g_varchar2) in ('D','K','L','M','N','P') THEN -- Bug# 14001082
3456: set_ei(l_org_rec.rei_information6,fnd_date.date_to_canonical(l_service_comp_date),

Line 3456: set_ei(l_org_rec.rei_information6,fnd_date.date_to_canonical(l_service_comp_date),

3452: set_ei(l_org_rec.rei_information6,fnd_date.date_to_canonical(l_service_comp_date),
3453: l_rei_rec.rei_information6,l_refresh_flag);
3454: ELSE
3455: IF nvl(l_retirement_plan,hr_api.g_varchar2) in ('D','K','L','M','N','P') THEN -- Bug# 14001082
3456: set_ei(l_org_rec.rei_information6,fnd_date.date_to_canonical(l_service_comp_date),
3457: l_rei_rec.rei_information6,l_refresh_flag);
3458: --Begin Bug# 14001082
3459: ELSE
3460: set_ei(l_org_rec.rei_information6,NULL,l_rei_rec.rei_information6,l_refresh_flag);

Line 3487: IF p_effective_date >= fnd_date.canonical_to_date('2013/01/01') AND

3483: l_rei_rec.rei_information10,l_refresh_flag);
3484: --End Bug# 14514445
3485: --Begin Bug# 14001082
3486: --Bug# 15941036 added Retirement codes DR,KR,LR,MR,NR,PR effective from 01-Jan-2013
3487: IF p_effective_date >= fnd_date.canonical_to_date('2013/01/01') AND
3488: (l_family_code IN ('CONV_APP','EXT_NTE') OR nvl(l_second_noa_family_code,hr_api.g_varchar2) = 'CONV_APP') AND
3489: nvl(l_retirement_plan,hr_api.g_varchar2) in ('D','K','L','M','N','P','DR','KR','LR','MR','NR','PR') AND
3490: l_per_ei_data.pei_information6 IS NULL THEN
3491: set_ei(l_org_rec.rei_information6,fnd_date.date_to_canonical(l_service_comp_date),l_rei_rec.rei_information6,l_refresh_flag);

Line 3491: set_ei(l_org_rec.rei_information6,fnd_date.date_to_canonical(l_service_comp_date),l_rei_rec.rei_information6,l_refresh_flag);

3487: IF p_effective_date >= fnd_date.canonical_to_date('2013/01/01') AND
3488: (l_family_code IN ('CONV_APP','EXT_NTE') OR nvl(l_second_noa_family_code,hr_api.g_varchar2) = 'CONV_APP') AND
3489: nvl(l_retirement_plan,hr_api.g_varchar2) in ('D','K','L','M','N','P','DR','KR','LR','MR','NR','PR') AND
3490: l_per_ei_data.pei_information6 IS NULL THEN
3491: set_ei(l_org_rec.rei_information6,fnd_date.date_to_canonical(l_service_comp_date),l_rei_rec.rei_information6,l_refresh_flag);
3492: ELSIF (l_family_code IN ('CONV_APP','EXT_NTE') OR nvl(l_second_noa_family_code,hr_api.g_varchar2) = 'CONV_APP') AND
3493: nvl(l_retirement_plan,hr_api.g_varchar2) in ('D','K','L','M','N','P') AND l_per_ei_data.pei_information6 IS NULL THEN
3494: set_ei(l_org_rec.rei_information6,fnd_date.date_to_canonical(l_service_comp_date),l_rei_rec.rei_information6,l_refresh_flag);
3495: ELSE

Line 3494: set_ei(l_org_rec.rei_information6,fnd_date.date_to_canonical(l_service_comp_date),l_rei_rec.rei_information6,l_refresh_flag);

3490: l_per_ei_data.pei_information6 IS NULL THEN
3491: set_ei(l_org_rec.rei_information6,fnd_date.date_to_canonical(l_service_comp_date),l_rei_rec.rei_information6,l_refresh_flag);
3492: ELSIF (l_family_code IN ('CONV_APP','EXT_NTE') OR nvl(l_second_noa_family_code,hr_api.g_varchar2) = 'CONV_APP') AND
3493: nvl(l_retirement_plan,hr_api.g_varchar2) in ('D','K','L','M','N','P') AND l_per_ei_data.pei_information6 IS NULL THEN
3494: set_ei(l_org_rec.rei_information6,fnd_date.date_to_canonical(l_service_comp_date),l_rei_rec.rei_information6,l_refresh_flag);
3495: ELSE
3496: set_ei(l_org_rec.rei_information6,l_per_ei_data.pei_information6,l_rei_rec.rei_information6,l_refresh_flag);
3497: END IF;
3498: --End Bug# 14001082

Line 3682: set_ei(l_org_rec.rei_information1,fnd_date.date_to_canonical(p_effective_date),l_rei_rec.rei_information1,l_refresh_flag);

3678: --Begin Bug# 10182526, removed detail start and end dtes from RPA EIT, no defaulting is required
3679: /*FOR c_detail_nte_date_rec in c_detail_nte_date LOOP
3680: l_detail_nte_date := c_detail_nte_date_rec.first_noa_information1;
3681: END LOOP;
3682: set_ei(l_org_rec.rei_information1,fnd_date.date_to_canonical(p_effective_date),l_rei_rec.rei_information1,l_refresh_flag);
3683: set_ei(l_org_rec.rei_information2,l_detail_nte_date,l_rei_rec.rei_information2,l_refresh_flag);*/--End Bug# 10182526
3684: set_ei(l_org_rec.rei_information4,'N',l_rei_rec.rei_information4,l_refresh_flag);
3685: ELSE
3686: --Begin Bug# 10182526

Line 3689: set_ei(l_org_rec.rei_information2,fnd_date.date_to_canonical(p_effective_date),l_rei_rec.rei_information2,l_refresh_flag);

3685: ELSE
3686: --Begin Bug# 10182526
3687: /*set_ei(l_org_rec.rei_information1,l_asg_ei_data.aei_information1,l_rei_rec.rei_information1,l_refresh_flag);
3688: IF l_first_noa_code in ('732','932') THEN
3689: set_ei(l_org_rec.rei_information2,fnd_date.date_to_canonical(p_effective_date),l_rei_rec.rei_information2,l_refresh_flag);
3690: else
3691: FOR c_detail_nte_date_rec in c_detail_nte_date LOOP
3692: l_detail_nte_date := c_detail_nte_date_rec.first_noa_information1;
3693: END LOOP;

Line 3998: fnd_date.date_to_canonical(l_dlei_date),

3994: OPEN c_afhr_noac_sal_chg;
3995: FETCH c_afhr_noac_sal_chg INTO l_dlei_date;
3996: IF l_dlei_date is not null THEN
3997: set_ei(l_org_rec.rei_information5,
3998: fnd_date.date_to_canonical(l_dlei_date),
3999: l_rei_rec.rei_information5,'Y');
4000: ELSE
4001: -- Bug 3263140
4002: --Setting the value to NULL only if the original value is NULL

Line 4016: fnd_date.date_to_canonical(l_dlei_date),

4012: OPEN c_noac_sal_chg;
4013: FETCH c_noac_sal_chg INTO l_dlei_date;
4014: IF l_dlei_date is not null THEN
4015: set_ei(l_org_rec.rei_information5,
4016: fnd_date.date_to_canonical(l_dlei_date),
4017: l_rei_rec.rei_information5,'Y');
4018: ELSE
4019: -- Bug 3263140
4020: --Setting the value to NULL only if the original value is NULL

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

4100: /*End - Bug 6129752*/
4101: ELSE
4102: FOR c_get_eff_rec in c_get_effective_date
4103: LOOP
4104: set_ei(l_org_rec.rei_information6,fnd_date.date_to_canonical(c_get_eff_rec.effective_date), l_rei_rec.rei_information6,'Y');
4105: exit;
4106: END LOOP;
4107: END IF;
4108: --Begin Bug# 14514445

Line 4132: set_ei(l_org_rec.rei_information7,fnd_date.date_to_canonical(p_effective_date+365),l_rei_rec.rei_information7,l_refresh_flag);

4128: IF SUBSTR(l_valid_grade_name,1,2) = SUBSTR(l_target_grade_name,1,2) AND
4129: TO_NUMBER(SUBSTR(l_valid_grade_name,4,5)) < TO_NUMBER(SUBSTR(l_target_grade_name,4,5)) THEN
4130: hr_utility.set_location('promotion_eligibility_date default in Salary change '|| l_valid_grade_name,353);
4131: IF l_first_noa_code IN ('702') THEN
4132: set_ei(l_org_rec.rei_information7,fnd_date.date_to_canonical(p_effective_date+365),l_rei_rec.rei_information7,l_refresh_flag);
4133: ELSE
4134: ghr_history_fetch.fetch_peopleei
4135: (p_person_id => l_person_id,
4136: p_information_type => 'GHR_US_PER_GROUP1',