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 HR_API

Line 261: IF (nvl(p_effective_date,hr_api.g_date)

257: hr_utility.set_location('l_noa_code is '||l_noa_code, 2);
258: -- Delete the RPA EI if there is a change in Effective Date or
259: -- Person
260: IF p_refresh_flag = 'N' THEN
261: IF (nvl(p_effective_date,hr_api.g_date)
262: <> nvl(ghr_par_shd.g_old_rec.effective_date,hr_api.g_date)) or
263: (nvl(p_person_id,hr_api.g_number)
264: <> nvl(ghr_par_shd.g_old_rec.person_id,hr_api.g_number)) then
265: hr_utility.set_location('Inside the Delete IF '||l_noa_code, 2);

Line 262: <> nvl(ghr_par_shd.g_old_rec.effective_date,hr_api.g_date)) or

258: -- Delete the RPA EI if there is a change in Effective Date or
259: -- Person
260: IF p_refresh_flag = 'N' THEN
261: IF (nvl(p_effective_date,hr_api.g_date)
262: <> nvl(ghr_par_shd.g_old_rec.effective_date,hr_api.g_date)) or
263: (nvl(p_person_id,hr_api.g_number)
264: <> nvl(ghr_par_shd.g_old_rec.person_id,hr_api.g_number)) then
265: hr_utility.set_location('Inside the Delete IF '||l_noa_code, 2);
266: -- Delete from ghr_pa_request_extra_info

Line 263: (nvl(p_person_id,hr_api.g_number)

259: -- Person
260: IF p_refresh_flag = 'N' THEN
261: IF (nvl(p_effective_date,hr_api.g_date)
262: <> nvl(ghr_par_shd.g_old_rec.effective_date,hr_api.g_date)) or
263: (nvl(p_person_id,hr_api.g_number)
264: <> nvl(ghr_par_shd.g_old_rec.person_id,hr_api.g_number)) then
265: hr_utility.set_location('Inside the Delete IF '||l_noa_code, 2);
266: -- Delete from ghr_pa_request_extra_info
267: DELETE ghr_pa_request_extra_info

Line 264: <> nvl(ghr_par_shd.g_old_rec.person_id,hr_api.g_number)) then

260: IF p_refresh_flag = 'N' THEN
261: IF (nvl(p_effective_date,hr_api.g_date)
262: <> nvl(ghr_par_shd.g_old_rec.effective_date,hr_api.g_date)) or
263: (nvl(p_person_id,hr_api.g_number)
264: <> nvl(ghr_par_shd.g_old_rec.person_id,hr_api.g_number)) then
265: hr_utility.set_location('Inside the Delete IF '||l_noa_code, 2);
266: -- Delete from ghr_pa_request_extra_info
267: DELETE ghr_pa_request_extra_info
268: WHERE INFORMATION_TYPE in ( 'GHR_US_PAR_TERM_RET_GRADE',

Line 968: -- If l_person_id <> nvl(ghr_par_shd.g_old_rec.person_id,hr_api.g_number) then

964: hr_utility.set_location('Person inside appt_info is ' || to_char(l_person_id),1);
965: If l_person_id is not null then
966: hr_utility.set_location('Person inside appt_info is ' || to_char(l_person_id),1);
967: -- if the person_id is not the same as the old person_id then do the foll.
968: -- If l_person_id <> nvl(ghr_par_shd.g_old_rec.person_id,hr_api.g_number) then
969: -- a) Get PER_GROUP1 Information
970: l_refresh_flag := l_per_refresh_flag;
971: ghr_history_fetch.fetch_peopleei
972: (p_person_id => l_person_id,

Line 1358: nvl(l_tenure,hr_api.g_varchar2) = '0' THEN

1354: l_rei_rec.rei_information5,'Y');
1355: -- Date Temp Eligibility FEHB
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

Line 1369: IF nvl(l_fegli,hr_api.g_varchar2) <> 'A0' AND

1365: END IF; -- IF l_noa_code in Date Temp Eligibility FEHB
1366:
1367: -- FEGLI Eligibility Expiration
1368: --- Bug# 14062681 removed noa 171 from list
1369: IF nvl(l_fegli,hr_api.g_varchar2) <> 'A0' AND
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,

Line 1400: /*IF nvl(l_retirement_plan,hr_api.g_varchar2)

1396: END IF; --- Bug# 14062681
1397: END IF;
1398: -- TSP SCD
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');

Line 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',

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:
1418: END IF; -- IF nvl(l_retirement_plan,hr_api

Line 1418: END IF; -- IF nvl(l_retirement_plan,hr_api

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:
1418: END IF; -- IF nvl(l_retirement_plan,hr_api
1419: ELSIF l_effective_date > to_date('31/07/2010','DD/MM/RRRR') AND l_noa_code NOT IN ('130','132') THEN
1420: 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') AND l_tsp_status IS NULL THEN
1421: set_ei(l_org_rec.rei_information14,'03', l_rei_rec.rei_information14,'Y');
1422:

Line 1420: 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') AND l_tsp_status IS NULL THEN

1416: set_ei(l_org_rec.rei_information14,'03', l_rei_rec.rei_information14,'Y');
1417:
1418: END IF; -- IF nvl(l_retirement_plan,hr_api
1419: ELSIF l_effective_date > to_date('31/07/2010','DD/MM/RRRR') AND l_noa_code NOT IN ('130','132') THEN
1420: 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') AND l_tsp_status IS NULL THEN
1421: set_ei(l_org_rec.rei_information14,'03', l_rei_rec.rei_information14,'Y');
1422:
1423: END IF; -- IF nvl(l_retirement_plan,hr_api.
1424: END IF; -- IF l_effective_date > to_date('31/07/2010','DD/MM/RRRR')

Line 1423: END IF; -- IF nvl(l_retirement_plan,hr_api.

1419: ELSIF l_effective_date > to_date('31/07/2010','DD/MM/RRRR') AND l_noa_code NOT IN ('130','132') THEN
1420: 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') AND l_tsp_status IS NULL THEN
1421: set_ei(l_org_rec.rei_information14,'03', l_rei_rec.rei_information14,'Y');
1422:
1423: END IF; -- IF nvl(l_retirement_plan,hr_api.
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

Line 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',

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.
1433: ELSIF l_effective_date > to_date('31/07/2010','DD/MM/RRRR') AND l_noa_code NOT IN ('130','132') THEN

Line 1432: END IF; -- IF nvl(l_retirement_plan,hr_api.

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.
1433: ELSIF l_effective_date > to_date('31/07/2010','DD/MM/RRRR') AND l_noa_code NOT IN ('130','132') THEN
1434: 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') THEN
1435: set_ei(l_org_rec.rei_information15,'A', l_rei_rec.rei_information15,'Y');
1436: END IF; -- IF nvl(l_retirement_plan,hr_api.

Line 1434: 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') THEN

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.
1433: ELSIF l_effective_date > to_date('31/07/2010','DD/MM/RRRR') AND l_noa_code NOT IN ('130','132') THEN
1434: 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') THEN
1435: set_ei(l_org_rec.rei_information15,'A', l_rei_rec.rei_information15,'Y');
1436: END IF; -- IF nvl(l_retirement_plan,hr_api.
1437: ELSE
1438: --Begin Bug# 11924967

Line 1436: END IF; -- IF nvl(l_retirement_plan,hr_api.

1432: END IF; -- IF nvl(l_retirement_plan,hr_api.
1433: ELSIF l_effective_date > to_date('31/07/2010','DD/MM/RRRR') AND l_noa_code NOT IN ('130','132') THEN
1434: 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') THEN
1435: set_ei(l_org_rec.rei_information15,'A', l_rei_rec.rei_information15,'Y');
1436: END IF; -- IF nvl(l_retirement_plan,hr_api.
1437: ELSE
1438: --Begin Bug# 11924967
1439: IF l_effective_date < to_date('22/06/2009','DD/MM/RRRR') AND
1440: nvl(l_retirement_plan,hr_api.g_varchar2) in ('D','K','L','M','N','P') THEN

Line 1440: nvl(l_retirement_plan,hr_api.g_varchar2) in ('D','K','L','M','N','P') THEN

1436: END IF; -- IF nvl(l_retirement_plan,hr_api.
1437: ELSE
1438: --Begin Bug# 11924967
1439: IF l_effective_date < to_date('22/06/2009','DD/MM/RRRR') AND
1440: nvl(l_retirement_plan,hr_api.g_varchar2) in ('D','K','L','M','N','P') THEN
1441: set_ei(l_org_rec.rei_information15,'I',l_rei_rec.rei_information15,'Y');
1442: --End Bug 11924967
1443: ELSIF nvl(l_retirement_plan,hr_api.g_varchar2)
1444: in ('D','K','L','M','N','P') THEN

Line 1443: ELSIF nvl(l_retirement_plan,hr_api.g_varchar2)

1439: IF l_effective_date < to_date('22/06/2009','DD/MM/RRRR') AND
1440: nvl(l_retirement_plan,hr_api.g_varchar2) in ('D','K','L','M','N','P') THEN
1441: set_ei(l_org_rec.rei_information15,'I',l_rei_rec.rei_information15,'Y');
1442: --End Bug 11924967
1443: ELSIF nvl(l_retirement_plan,hr_api.g_varchar2)
1444: in ('D','K','L','M','N','P') THEN
1445: set_ei(l_org_rec.rei_information15,'E',
1446: l_rei_rec.rei_information15,'Y');-- Bug# 8622486 modified I to E
1447: ELSIF nvl(l_retirement_plan,hr_api.g_varchar2)

Line 1447: ELSIF nvl(l_retirement_plan,hr_api.g_varchar2)

1443: ELSIF nvl(l_retirement_plan,hr_api.g_varchar2)
1444: in ('D','K','L','M','N','P') THEN
1445: set_ei(l_org_rec.rei_information15,'E',
1446: l_rei_rec.rei_information15,'Y');-- Bug# 8622486 modified I to E
1447: ELSIF nvl(l_retirement_plan,hr_api.g_varchar2)
1448: in ('2','4','5') THEN
1449: set_ei(l_org_rec.rei_information15,NULL,
1450: l_rei_rec.rei_information15,'Y');
1451: ELSIF nvl(l_retirement_plan,hr_api.g_varchar2)

Line 1451: ELSIF nvl(l_retirement_plan,hr_api.g_varchar2)

1447: ELSIF nvl(l_retirement_plan,hr_api.g_varchar2)
1448: in ('2','4','5') THEN
1449: set_ei(l_org_rec.rei_information15,NULL,
1450: l_rei_rec.rei_information15,'Y');
1451: ELSIF nvl(l_retirement_plan,hr_api.g_varchar2)
1452: in ('1','3','8','9','C','E','F','G','H','R','T',
1453: 'W' ) THEN
1454: set_ei(l_org_rec.rei_information15,'E',
1455: l_rei_rec.rei_information15,'Y');

Line 1459: END IF; -- IF nvl(l_retirement_plan,hr_api.

1455: l_rei_rec.rei_information15,'Y');
1456: ELSE
1457: set_ei(l_org_rec.rei_information15,NULL,
1458: l_rei_rec.rei_information15,'Y');
1459: END IF; -- IF nvl(l_retirement_plan,hr_api.
1460:
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)

Line 1463: IF NVL(l_retirement_plan,hr_api.g_varchar2)

1459: END IF; -- IF nvl(l_retirement_plan,hr_api.
1460:
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

Line 1475: IF NVL(l_retirement_plan,hr_api.g_varchar2) IN ('D', 'K', 'L', 'M', 'N', 'P','DR','KR','LR','MR','NR','PR') THEN

1471: END IF; -- -- TSP Status Date
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

Line 1508: IF (l_family_code = 'CONV_APP' OR nvl(l_second_noa_family_code,hr_api.g_varchar2) = 'CONV_APP') OR l_family_code = 'EXT_NTE' THEN

1504: ############ For Conversion to Appointment and Extension action #################
1505: */
1506:
1507: --8793163 For Dual Actions Benefits need to defaulted even if second action is conversion to appointment
1508: IF (l_family_code = 'CONV_APP' OR nvl(l_second_noa_family_code,hr_api.g_varchar2) = 'CONV_APP') OR l_family_code = 'EXT_NTE' THEN
1509: fnd_profile.get('PER_BUSINESS_GROUP_ID',l_bus_group_id);
1510: -- Check if FEHB exists
1511: l_new_element_name := pqp_fedhr_uspay_int_utils.return_new_element_name('Health Benefits',l_bus_group_id,l_effective_date,null);
1512: FOR l_element_entry_cur IN c_element_entry(p_assignment_id , l_new_element_name, l_effective_date) LOOP

Line 1564: IF l_family_code = 'CONV_APP' OR nvl(l_second_noa_family_code,hr_api.g_varchar2) = 'CONV_APP' THEN

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
1565: IF l_fehb_exists = FALSE OR (l_fehb_exists = TRUE AND NVL(l_enrollment_option,'Z') = 'Z') THEN
1566: -- FEHB Eligibility expires
1567:
1568: --8793163 Added for second noa code

Line 1598: IF NVL(l_fegli,hr_api.g_varchar2) <> 'A0' AND

1594: END IF;
1595: END IF; -- IF l_fehb_exists = FALSE OR
1596:
1597: -- FEGLI Eligibility expires
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),

Line 1599: NVL(l_prev_fegli,hr_api.g_varchar2) = 'A0' THEN

1595: END IF; -- IF l_fehb_exists = FALSE OR
1596:
1597: -- FEGLI Eligibility expires
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');

Line 1632: /*IF nvl(l_retirement_plan,hr_api.g_varchar2) IN ('D','K','L','M','N','P') AND l_tsp_status IS NULL THEN

1628: END IF; -- IF l_tsp_exists = TRUE TH
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

Line 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',

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.
1646: ELSIF l_effective_date > to_date('31/07/2010','DD/MM/RRRR') THEN

Line 1645: END IF; -- IF nvl(l_retirement_plan,hr_api.

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.
1646: ELSIF l_effective_date > to_date('31/07/2010','DD/MM/RRRR') THEN
1647: 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') AND l_tsp_status IS NULL THEN
1648: set_ei(l_org_rec.rei_information14,'03', l_rei_rec.rei_information14,'Y');
1649:

Line 1647: 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') AND l_tsp_status IS NULL THEN

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.
1646: ELSIF l_effective_date > to_date('31/07/2010','DD/MM/RRRR') THEN
1647: 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') AND l_tsp_status IS NULL THEN
1648: set_ei(l_org_rec.rei_information14,'03', l_rei_rec.rei_information14,'Y');
1649:
1650: END IF; -- IF nvl(l_retirement_plan,hr_api.
1651: END IF; -- IF l_effective_date > to_date('31/07/2010','DD/MM/RRRR')

Line 1650: END IF; -- IF nvl(l_retirement_plan,hr_api.

1646: ELSIF l_effective_date > to_date('31/07/2010','DD/MM/RRRR') THEN
1647: 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') AND l_tsp_status IS NULL THEN
1648: set_ei(l_org_rec.rei_information14,'03', l_rei_rec.rei_information14,'Y');
1649:
1650: END IF; -- IF nvl(l_retirement_plan,hr_api.
1651: END IF; -- IF l_effective_date > to_date('31/07/2010','DD/MM/RRRR')
1652:
1653: -- TSP Status
1654: hr_utility.set_location('TSP status' || l_tsp_status,111);

Line 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',

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.
1661: ELSIF l_effective_date > to_date('31/07/2010','DD/MM/RRRR') THEN

Line 1660: END IF; -- IF nvl(l_retirement_plan,hr_api.

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.
1661: ELSIF l_effective_date > to_date('31/07/2010','DD/MM/RRRR') THEN
1662: 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') AND l_tsp_status IS NULL THEN
1663: set_ei(l_org_rec.rei_information15,'A', l_rei_rec.rei_information15,'Y');
1664: END IF; -- IF nvl(l_retirement_plan,hr_api.

Line 1662: 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') AND l_tsp_status IS NULL THEN

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.
1661: ELSIF l_effective_date > to_date('31/07/2010','DD/MM/RRRR') THEN
1662: 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') AND l_tsp_status IS NULL THEN
1663: set_ei(l_org_rec.rei_information15,'A', l_rei_rec.rei_information15,'Y');
1664: END IF; -- IF nvl(l_retirement_plan,hr_api.
1665: ELSE
1666: --Begin Bug# 11924967

Line 1664: END IF; -- IF nvl(l_retirement_plan,hr_api.

1660: END IF; -- IF nvl(l_retirement_plan,hr_api.
1661: ELSIF l_effective_date > to_date('31/07/2010','DD/MM/RRRR') THEN
1662: 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') AND l_tsp_status IS NULL THEN
1663: set_ei(l_org_rec.rei_information15,'A', l_rei_rec.rei_information15,'Y');
1664: END IF; -- IF nvl(l_retirement_plan,hr_api.
1665: ELSE
1666: --Begin Bug# 11924967
1667: IF l_effective_date < to_date('22/06/2009','DD/MM/RRRR') AND
1668: nvl(l_retirement_plan,hr_api.g_varchar2) in ('D','K','L','M','N','P') THEN

Line 1668: nvl(l_retirement_plan,hr_api.g_varchar2) in ('D','K','L','M','N','P') THEN

1664: END IF; -- IF nvl(l_retirement_plan,hr_api.
1665: ELSE
1666: --Begin Bug# 11924967
1667: IF l_effective_date < to_date('22/06/2009','DD/MM/RRRR') AND
1668: nvl(l_retirement_plan,hr_api.g_varchar2) in ('D','K','L','M','N','P') THEN
1669: set_ei(l_org_rec.rei_information15,'I',l_rei_rec.rei_information15,'Y');
1670: --End Bug 11924967
1671: ELSIF nvl(l_retirement_plan,hr_api.g_varchar2) IN ('D','K','L','M','N','P') AND l_tsp_status IS NULL THEN
1672: set_ei(l_org_rec.rei_information15,'E', l_rei_rec.rei_information15,'Y');

Line 1671: ELSIF nvl(l_retirement_plan,hr_api.g_varchar2) IN ('D','K','L','M','N','P') AND l_tsp_status IS NULL THEN

1667: IF l_effective_date < to_date('22/06/2009','DD/MM/RRRR') AND
1668: nvl(l_retirement_plan,hr_api.g_varchar2) in ('D','K','L','M','N','P') THEN
1669: set_ei(l_org_rec.rei_information15,'I',l_rei_rec.rei_information15,'Y');
1670: --End Bug 11924967
1671: ELSIF nvl(l_retirement_plan,hr_api.g_varchar2) IN ('D','K','L','M','N','P') AND l_tsp_status IS NULL THEN
1672: set_ei(l_org_rec.rei_information15,'E', l_rei_rec.rei_information15,'Y');
1673: ELSIF nvl(l_retirement_plan,hr_api.g_varchar2) IN ('2','4','5') THEN
1674: set_ei(l_org_rec.rei_information15,NULL, l_rei_rec.rei_information15,'Y');
1675: ELSIF nvl(l_retirement_plan,hr_api.g_varchar2) IN ('1','3','8','9','C','E','F','G','H','R','T','W' ) and l_tsp_status IS NULL THEN

Line 1673: ELSIF nvl(l_retirement_plan,hr_api.g_varchar2) IN ('2','4','5') THEN

1669: set_ei(l_org_rec.rei_information15,'I',l_rei_rec.rei_information15,'Y');
1670: --End Bug 11924967
1671: ELSIF nvl(l_retirement_plan,hr_api.g_varchar2) IN ('D','K','L','M','N','P') AND l_tsp_status IS NULL THEN
1672: set_ei(l_org_rec.rei_information15,'E', l_rei_rec.rei_information15,'Y');
1673: ELSIF nvl(l_retirement_plan,hr_api.g_varchar2) IN ('2','4','5') THEN
1674: set_ei(l_org_rec.rei_information15,NULL, l_rei_rec.rei_information15,'Y');
1675: ELSIF nvl(l_retirement_plan,hr_api.g_varchar2) IN ('1','3','8','9','C','E','F','G','H','R','T','W' ) and l_tsp_status IS NULL THEN
1676: set_ei(l_org_rec.rei_information15,'E', l_rei_rec.rei_information15,'Y');
1677: ELSE

Line 1675: ELSIF nvl(l_retirement_plan,hr_api.g_varchar2) IN ('1','3','8','9','C','E','F','G','H','R','T','W' ) and l_tsp_status IS NULL THEN

1671: ELSIF nvl(l_retirement_plan,hr_api.g_varchar2) IN ('D','K','L','M','N','P') AND l_tsp_status IS NULL THEN
1672: set_ei(l_org_rec.rei_information15,'E', l_rei_rec.rei_information15,'Y');
1673: ELSIF nvl(l_retirement_plan,hr_api.g_varchar2) IN ('2','4','5') THEN
1674: set_ei(l_org_rec.rei_information15,NULL, l_rei_rec.rei_information15,'Y');
1675: ELSIF nvl(l_retirement_plan,hr_api.g_varchar2) IN ('1','3','8','9','C','E','F','G','H','R','T','W' ) and l_tsp_status IS NULL THEN
1676: set_ei(l_org_rec.rei_information15,'E', l_rei_rec.rei_information15,'Y');
1677: ELSE
1678: set_ei(l_org_rec.rei_information15,NULL, l_rei_rec.rei_information15,'Y');
1679: END IF; -- IF nvl(l_retirement_plan,hr_api.

Line 1679: END IF; -- IF nvl(l_retirement_plan,hr_api.

1675: ELSIF nvl(l_retirement_plan,hr_api.g_varchar2) IN ('1','3','8','9','C','E','F','G','H','R','T','W' ) and l_tsp_status IS NULL THEN
1676: set_ei(l_org_rec.rei_information15,'E', l_rei_rec.rei_information15,'Y');
1677: ELSE
1678: set_ei(l_org_rec.rei_information15,NULL, l_rei_rec.rei_information15,'Y');
1679: END IF; -- IF nvl(l_retirement_plan,hr_api.
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

Line 1683: IF NVL(l_retirement_plan,hr_api.g_varchar2) NOT IN ('2','4','5') AND l_tsp_status_date IS NULL THEN

1679: END IF; -- IF nvl(l_retirement_plan,hr_api.
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

Line 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

1687: END IF; -- -- TSP Status Date
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

Line 1754: ghr_api.retrieve_element_entry_value

1750: hr_utility.set_location('Person inside mddds_pay is ' || to_char(l_person_id),1);
1751:
1752: l_refresh_flag := l_per_refresh_flag;
1753:
1754: ghr_api.retrieve_element_entry_value
1755: (p_element_name => 'MDDDS Special Pay',
1756: p_input_value_name => 'Full Time Status',
1757: p_assignment_id => l_assignment_id,
1758: p_effective_date => nvl(p_effective_date,trunc(sysdate)),

Line 1764: ghr_api.retrieve_element_entry_value

1760: p_multiple_error_flag => l_multiple_error_flag
1761: );
1762: set_ei(l_org_rec.rei_information9, l_value, l_rei_rec.rei_information9, l_refresh_flag);
1763:
1764: ghr_api.retrieve_element_entry_value
1765: (p_element_name => 'MDDDS Special Pay',
1766: p_input_value_name => 'Length of Service',
1767: p_assignment_id => l_assignment_id,
1768: p_effective_date => nvl(p_effective_date,trunc(sysdate)),

Line 1774: ghr_api.retrieve_element_entry_value

1770: p_multiple_error_flag => l_multiple_error_flag
1771: );
1772: set_ei(l_org_rec.rei_information10, l_value, l_rei_rec.rei_information10, l_refresh_flag);
1773:
1774: ghr_api.retrieve_element_entry_value
1775: (p_element_name => 'MDDDS Special Pay',
1776: p_input_value_name => 'Scarce Specialty',
1777: p_assignment_id => l_assignment_id,
1778: p_effective_date => nvl(p_effective_date,trunc(sysdate)),

Line 1784: ghr_api.retrieve_element_entry_value

1780: p_multiple_error_flag => l_multiple_error_flag
1781: );
1782: set_ei(l_org_rec.rei_information3, l_value, l_rei_rec.rei_information3, l_refresh_flag);
1783:
1784: ghr_api.retrieve_element_entry_value
1785: (p_element_name => 'MDDDS Special Pay',
1786: p_input_value_name => 'Specialty or Board Certification',
1787: p_assignment_id => l_assignment_id,
1788: p_effective_date => nvl(p_effective_date,trunc(sysdate)),

Line 1794: ghr_api.retrieve_element_entry_value

1790: p_multiple_error_flag => l_multiple_error_flag
1791: );
1792: set_ei(l_org_rec.rei_information4, l_value, l_rei_rec.rei_information4, l_refresh_flag);
1793:
1794: ghr_api.retrieve_element_entry_value
1795: (p_element_name => 'MDDDS Special Pay',
1796: p_input_value_name => 'Geographic Location',
1797: p_assignment_id => l_assignment_id,
1798: p_effective_date => nvl(p_effective_date,trunc(sysdate)),

Line 1804: ghr_api.retrieve_element_entry_value

1800: p_multiple_error_flag => l_multiple_error_flag
1801: );
1802: set_ei(l_org_rec.rei_information5, l_value, l_rei_rec.rei_information5, l_refresh_flag);
1803:
1804: ghr_api.retrieve_element_entry_value
1805: (p_element_name => 'MDDDS Special Pay',
1806: p_input_value_name => 'Exceptional Qualifications',
1807: p_assignment_id => l_assignment_id,
1808: p_effective_date => nvl(p_effective_date,trunc(sysdate)),

Line 1814: ghr_api.retrieve_element_entry_value

1810: p_multiple_error_flag => l_multiple_error_flag
1811: );
1812: set_ei(l_org_rec.rei_information6, l_value, l_rei_rec.rei_information6, l_refresh_flag);
1813:
1814: ghr_api.retrieve_element_entry_value
1815: (p_element_name => 'MDDDS Special Pay',
1816: p_input_value_name => 'Executive Position',
1817: p_assignment_id => l_assignment_id,
1818: p_effective_date => nvl(p_effective_date,trunc(sysdate)),

Line 1824: ghr_api.retrieve_element_entry_value

1820: p_multiple_error_flag => l_multiple_error_flag
1821: );
1822: set_ei(l_org_rec.rei_information7, l_value, l_rei_rec.rei_information7, l_refresh_flag);
1823:
1824: ghr_api.retrieve_element_entry_value
1825: (p_element_name => 'MDDDS Special Pay',
1826: p_input_value_name => 'Dentist Post Graduate Training',
1827: p_assignment_id => l_assignment_id,
1828: p_effective_date => nvl(p_effective_date,trunc(sysdate)),

Line 1834: ghr_api.retrieve_element_entry_value

1830: p_multiple_error_flag => l_multiple_error_flag
1831: );
1832: set_ei(l_org_rec.rei_information8, l_value, l_rei_rec.rei_information8, l_refresh_flag);
1833:
1834: ghr_api.retrieve_element_entry_value
1835: (p_element_name => 'MDDDS Special Pay',
1836: p_input_value_name => 'Amount',
1837: p_assignment_id => l_assignment_id,
1838: p_effective_date => nvl(p_effective_date,trunc(sysdate)),

Line 1848: ghr_api.retrieve_element_entry_value

1844: if l_rei_rec.rei_information11 is null then
1845: l_rei_rec.rei_information11 := 0;
1846: end if;
1847:
1848: ghr_api.retrieve_element_entry_value
1849: (p_element_name => 'MDDDS Special Pay',
1850: p_input_value_name => 'MDDDS Special Pay NTE Date',
1851: p_assignment_id => l_assignment_id,
1852: p_effective_date => nvl(p_effective_date,trunc(sysdate)),

Line 1858: ghr_api.retrieve_element_entry_value

1854: p_multiple_error_flag => l_multiple_error_flag
1855: );
1856: set_ei(l_org_rec.rei_information12, l_value, l_rei_rec.rei_information12, l_refresh_flag);
1857:
1858: ghr_api.retrieve_element_entry_value
1859: (p_element_name => 'Premium Pay',
1860: p_input_value_name => 'Premium Pay Ind',
1861: p_assignment_id => l_assignment_id,
1862: p_effective_date => nvl(p_effective_date,trunc(sysdate)),

Line 1882: ghr_api.retrieve_element_entry_value

1878: If l_assignment_id is not null then
1879: hr_utility.set_location('Person inside premium_pay_ind is ' || to_char(l_person_id),1);
1880: l_refresh_flag := l_per_refresh_flag;
1881:
1882: ghr_api.retrieve_element_entry_value
1883: (p_element_name => 'Premium Pay',
1884: p_input_value_name => 'Premium Pay Ind',
1885: p_assignment_id => l_assignment_id,
1886: p_effective_date => nvl(p_effective_date,trunc(sysdate)),

Line 2051: /*ghr_api.retrieve_element_entry_value

2047: set_ei(l_org_rec.rei_information17,l_asg_ei_data.aei_information9,l_rei_rec.rei_information17,l_refresh_flag);
2048: l_org_rec.rei_information17 := l_asg_ei_data.aei_information9;
2049:
2050: l_asg_ei_data := null;
2051: /*ghr_api.retrieve_element_entry_value
2052: (p_element_name => 'Within Grade Increase',
2053: p_input_value_name => 'Date Due',
2054: p_assignment_id => l_assignment_id,
2055: p_effective_date => nvl(p_effective_date,trunc(sysdate)),

Line 2252: ghr_api.retrieve_element_entry_value

2248: set_ei(l_org_rec.rei_information11,l_asg_ei_data.aei_information9,l_rei_rec.rei_information11,l_refresh_flag);
2249: -- Start Bug 1318341
2250:
2251: --Bug#5527363 Modified the l_assignment_id parameter passed.
2252: ghr_api.retrieve_element_entry_value
2253: (p_element_name => 'Within Grade Increase',
2254: p_input_value_name => 'Date Due',
2255: p_assignment_id => NVL(l_assignment_id,p_assignment_id),
2256: p_effective_date => nvl(p_effective_date,trunc(sysdate)),

Line 2670: l_agency_code := ghr_api.get_position_agency_code_pos

2666: l_pos_ei_data := null;
2667: FOR c_bg_id in c_bg LOOP
2668: l_bg_id := c_bg_id.business_group_id;
2669: END LOOP;
2670: l_agency_code := ghr_api.get_position_agency_code_pos
2671: (p_position_id => l_position_id
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);

Line 2817: l_special_info ghr_api.special_information_type;

2813: End scd_tsp;
2814: --
2815: --
2816: Procedure non_pay_duty is
2817: l_special_info ghr_api.special_information_type;
2818: begin
2819:
2820: If l_person_id is not null then
2821: l_refresh_flag := l_per_refresh_flag;

Line 2880: l_special_info ghr_api.special_information_type;

2876: End non_pay_duty;
2877: --
2878: --
2879: Procedure lwop_info is
2880: l_special_info ghr_api.special_information_type;
2881: begin
2882:
2883: If l_person_id is not null then
2884: l_refresh_flag := l_per_refresh_flag;

Line 2966: l_agency_code := ghr_api.get_position_agency_code_pos

2962: IF p_position_id is NOT NULL then
2963: FOR c_bg_id in c_bg1 LOOP
2964: l_bg_id := c_bg_id.business_group_id;
2965: END LOOP;
2966: l_agency_code := ghr_api.get_position_agency_code_pos
2967: (p_position_id => p_position_id
2968: ,p_business_group_id => l_bg_id);
2969: set_ei(l_org_rec.rei_information3, substr(l_agency_code,1,2), l_rei_rec.rei_information3, l_refresh_flag);
2970: END IF;

Line 3109: ghr_api.retrieve_element_entry_value

3105: --
3106: -- Fetch the element entry value
3107: IF l_assignment_id is not null THEN
3108: l_refresh_flag := l_per_refresh_flag;
3109: ghr_api.retrieve_element_entry_value
3110: (p_element_name => 'FEGLI',
3111: p_input_value_name => 'Eligibility Expiration',
3112: p_assignment_id => l_assignment_id,
3113: p_effective_date => nvl(p_effective_date,trunc(sysdate)),

Line 3163: ghr_api.retrieve_element_entry_value

3159: --
3160: -- Fetch the element entry value
3161: IF l_assignment_id is not null THEN
3162: l_refresh_flag := l_per_refresh_flag;
3163: ghr_api.retrieve_element_entry_value
3164: (p_element_name => 'Foreign Transfer Allowance',
3165: p_input_value_name => 'Last Action Code',
3166: p_assignment_id => l_assignment_id,
3167: p_effective_date => nvl(p_effective_date,trunc(sysdate)),

Line 3173: ghr_api.retrieve_element_entry_value

3169: p_multiple_error_flag => l_multiple_error_flag
3170: );
3171: set_ei(l_org_rec.rei_information3, l_value, l_rei_rec.rei_information3, l_refresh_flag);
3172: l_value := NULL;
3173: ghr_api.retrieve_element_entry_value
3174: (p_element_name => 'Foreign Transfer Allowance',
3175: p_input_value_name => 'Number Family Members',
3176: p_assignment_id => l_assignment_id,
3177: p_effective_date => nvl(p_effective_date,trunc(sysdate)),

Line 3183: ghr_api.retrieve_element_entry_value

3179: p_multiple_error_flag => l_multiple_error_flag
3180: );
3181: set_ei(l_org_rec.rei_information4, l_value, l_rei_rec.rei_information4, l_refresh_flag);
3182: l_value := NULL;
3183: ghr_api.retrieve_element_entry_value
3184: (p_element_name => 'Foreign Transfer Allowance',
3185: p_input_value_name => 'Miscellaneous Expense',
3186: p_assignment_id => l_assignment_id,
3187: p_effective_date => nvl(p_effective_date,trunc(sysdate)),

Line 3193: ghr_api.retrieve_element_entry_value

3189: p_multiple_error_flag => l_multiple_error_flag
3190: );
3191: set_ei(l_org_rec.rei_information5, l_value, l_rei_rec.rei_information5, l_refresh_flag);
3192: l_value := NULL;
3193: ghr_api.retrieve_element_entry_value
3194: (p_element_name => 'Foreign Transfer Allowance',
3195: p_input_value_name => 'Wardrobe Expense',
3196: p_assignment_id => l_assignment_id,
3197: p_effective_date => nvl(p_effective_date,trunc(sysdate)),

Line 3203: ghr_api.retrieve_element_entry_value

3199: p_multiple_error_flag => l_multiple_error_flag
3200: );
3201: set_ei(l_org_rec.rei_information6, l_value, l_rei_rec.rei_information6, l_refresh_flag);
3202: l_value := NULL;
3203: ghr_api.retrieve_element_entry_value
3204: (p_element_name => 'Foreign Transfer Allowance',
3205: p_input_value_name => 'Pre Departure Sub Expense',
3206: p_assignment_id => l_assignment_id,
3207: p_effective_date => nvl(p_effective_date,trunc(sysdate)),

Line 3213: ghr_api.retrieve_element_entry_value

3209: p_multiple_error_flag => l_multiple_error_flag
3210: );
3211: set_ei(l_org_rec.rei_information7, l_value, l_rei_rec.rei_information7, l_refresh_flag);
3212: l_value := NULL;
3213: ghr_api.retrieve_element_entry_value
3214: (p_element_name => 'Foreign Transfer Allowance',
3215: p_input_value_name => 'Lease Penalty Expense',
3216: p_assignment_id => l_assignment_id,
3217: p_effective_date => nvl(p_effective_date,trunc(sysdate)),

Line 3223: ghr_api.retrieve_element_entry_value

3219: p_multiple_error_flag => l_multiple_error_flag
3220: );
3221: set_ei(l_org_rec.rei_information8, l_value, l_rei_rec.rei_information8, l_refresh_flag);
3222: l_value := NULL;
3223: ghr_api.retrieve_element_entry_value
3224: (p_element_name => 'Foreign Transfer Allowance',
3225: p_input_value_name => 'Amount',
3226: p_assignment_id => l_assignment_id,
3227: p_effective_date => nvl(p_effective_date,trunc(sysdate)),

Line 3318: IF nvl(l_tenure,hr_api.g_varchar2) = '2' and

3314: p_per_ei_data => l_per_ei_data
3315: );
3316: l_refresh_flag := l_per_refresh_flag;
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);

Line 3319: nvl(l_pos_occpied,hr_api.g_varchar2) = '1' and

3315: );
3316: l_refresh_flag := l_per_refresh_flag;
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

Line 3320: nvl(l_pos_intel_pos,hr_api.g_varchar2) <> '2' THEN

3316: l_refresh_flag := l_per_refresh_flag;
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

Line 3330: IF nvl(l_tenure,hr_api.g_varchar2) = '2' and

3326: set_ei(l_org_rec.rei_information3,l_per_ei_data.pei_information3,
3327: l_rei_rec.rei_information3,l_refresh_flag);
3328: /* END IF;
3329: --Begin Bug# 4588575
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)),

Line 3331: nvl(l_pos_occpied,hr_api.g_varchar2) = '1' and

3327: l_rei_rec.rei_information3,l_refresh_flag);
3328: /* END IF;
3329: --Begin Bug# 4588575
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);

Line 3346: IF nvl(l_la_code1,hr_api.g_varchar2) = 'J8M' THEN

3342:
3343: set_ei(l_org_rec.rei_information5,l_per_ei_data.pei_information5,
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

Line 3451: nvl(l_retirement_plan,hr_api.g_varchar2) in ('D','K','L','M','N','P','DR','KR','LR','MR','NR','PR') THEN

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
3455: IF nvl(l_retirement_plan,hr_api.g_varchar2) in ('D','K','L','M','N','P') THEN -- Bug# 14001082

Line 3455: IF nvl(l_retirement_plan,hr_api.g_varchar2) in ('D','K','L','M','N','P') THEN -- Bug# 14001082

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),
3457: l_rei_rec.rei_information6,l_refresh_flag);
3458: --Begin Bug# 14001082
3459: ELSE

Line 3488: (l_family_code IN ('CONV_APP','EXT_NTE') OR nvl(l_second_noa_family_code,hr_api.g_varchar2) = 'CONV_APP') AND

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);
3492: ELSIF (l_family_code IN ('CONV_APP','EXT_NTE') OR nvl(l_second_noa_family_code,hr_api.g_varchar2) = 'CONV_APP') AND

Line 3489: nvl(l_retirement_plan,hr_api.g_varchar2) in ('D','K','L','M','N','P','DR','KR','LR','MR','NR','PR') AND

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);
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

Line 3492: ELSIF (l_family_code IN ('CONV_APP','EXT_NTE') OR nvl(l_second_noa_family_code,hr_api.g_varchar2) = 'CONV_APP') 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
3496: set_ei(l_org_rec.rei_information6,l_per_ei_data.pei_information6,l_rei_rec.rei_information6,l_refresh_flag);

Line 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

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
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;

Line 3530: if (p_person_id = nvl(ghr_par_shd.g_old_rec.person_id,hr_api.g_number) and

3526: Procedure set_refresh_flags is
3527: Begin
3528:
3529: If p_person_id is not null then
3530: if (p_person_id = nvl(ghr_par_shd.g_old_rec.person_id,hr_api.g_number) and
3531: (l_rei_rec_exists = 'N' or
3532: trunc(nvl(p_effective_date,sysdate)) <> trunc(nvl(ghr_par_shd.g_old_rec.effective_date,sysdate)))) or
3533: --Bug # 9006561 Added this condition to consider if the cancellation of one action and
3534: -- correction of another action of the same effective date has been processed consecutively

Line 3535: (p_person_id = nvl(ghr_par_shd.g_old_rec.person_id,hr_api.g_number) and

3531: (l_rei_rec_exists = 'N' or
3532: trunc(nvl(p_effective_date,sysdate)) <> trunc(nvl(ghr_par_shd.g_old_rec.effective_date,sysdate)))) or
3533: --Bug # 9006561 Added this condition to consider if the cancellation of one action and
3534: -- correction of another action of the same effective date has been processed consecutively
3535: (p_person_id = nvl(ghr_par_shd.g_old_rec.person_id,hr_api.g_number) and
3536: p_pa_request_id <> nvl(ghr_par_shd.g_old_rec.pa_request_id ,hr_api.g_number) and
3537: trunc(nvl(p_effective_date,sysdate)) = trunc(nvl(ghr_par_shd.g_old_rec.effective_date,sysdate)))
3538: then
3539: hr_utility.set_location('change in eff. date only',2);

Line 3536: p_pa_request_id <> nvl(ghr_par_shd.g_old_rec.pa_request_id ,hr_api.g_number) and

3532: trunc(nvl(p_effective_date,sysdate)) <> trunc(nvl(ghr_par_shd.g_old_rec.effective_date,sysdate)))) or
3533: --Bug # 9006561 Added this condition to consider if the cancellation of one action and
3534: -- correction of another action of the same effective date has been processed consecutively
3535: (p_person_id = nvl(ghr_par_shd.g_old_rec.person_id,hr_api.g_number) and
3536: p_pa_request_id <> nvl(ghr_par_shd.g_old_rec.pa_request_id ,hr_api.g_number) and
3537: trunc(nvl(p_effective_date,sysdate)) = trunc(nvl(ghr_par_shd.g_old_rec.effective_date,sysdate)))
3538: then
3539: hr_utility.set_location('change in eff. date only',2);
3540: l_person_id := p_person_id;

Line 3542: Elsif p_person_id <> nvl(ghr_par_shd.g_old_rec.person_id,hr_api.g_number) then

3538: then
3539: hr_utility.set_location('change in eff. date only',2);
3540: l_person_id := p_person_id;
3541: l_per_refresh_flag := 'Y';
3542: Elsif p_person_id <> nvl(ghr_par_shd.g_old_rec.person_id,hr_api.g_number) then
3543: hr_utility.set_location('person id has changed',3);
3544: l_person_id := p_person_id;
3545: l_per_refresh_flag := 'N';
3546: Else

Line 3552: if (p_assignment_id = nvl(ghr_par_shd.g_old_rec.employee_assignment_id,hr_api.g_number) and

3548: End if;
3549: hr_utility.set_location('person id in the condition - refresh flag N ' || to_char(l_person_id),1);
3550: End if;
3551: If p_assignment_id is not null then
3552: if (p_assignment_id = nvl(ghr_par_shd.g_old_rec.employee_assignment_id,hr_api.g_number) and
3553: (l_rei_rec_exists = 'N' or
3554: trunc(nvl(p_effective_date,sysdate)) <> trunc(nvl(ghr_par_shd.g_old_rec.effective_date,sysdate)))) or
3555: --Bug # 9006561 Added this condition to consider if the cancellation of one action and
3556: -- correction of another action of the same effective date has been processed consecutively

Line 3557: (p_assignment_id = nvl(ghr_par_shd.g_old_rec.employee_assignment_id,hr_api.g_number) and

3553: (l_rei_rec_exists = 'N' or
3554: trunc(nvl(p_effective_date,sysdate)) <> trunc(nvl(ghr_par_shd.g_old_rec.effective_date,sysdate)))) or
3555: --Bug # 9006561 Added this condition to consider if the cancellation of one action and
3556: -- correction of another action of the same effective date has been processed consecutively
3557: (p_assignment_id = nvl(ghr_par_shd.g_old_rec.employee_assignment_id,hr_api.g_number) and
3558: p_pa_request_id <> nvl(ghr_par_shd.g_old_rec.pa_request_id ,hr_api.g_number) and
3559: trunc(nvl(p_effective_date,sysdate)) = trunc(nvl(ghr_par_shd.g_old_rec.effective_date,sysdate)))
3560: then
3561: l_assignment_id := p_assignment_id;

Line 3558: p_pa_request_id <> nvl(ghr_par_shd.g_old_rec.pa_request_id ,hr_api.g_number) and

3554: trunc(nvl(p_effective_date,sysdate)) <> trunc(nvl(ghr_par_shd.g_old_rec.effective_date,sysdate)))) or
3555: --Bug # 9006561 Added this condition to consider if the cancellation of one action and
3556: -- correction of another action of the same effective date has been processed consecutively
3557: (p_assignment_id = nvl(ghr_par_shd.g_old_rec.employee_assignment_id,hr_api.g_number) and
3558: p_pa_request_id <> nvl(ghr_par_shd.g_old_rec.pa_request_id ,hr_api.g_number) and
3559: trunc(nvl(p_effective_date,sysdate)) = trunc(nvl(ghr_par_shd.g_old_rec.effective_date,sysdate)))
3560: then
3561: l_assignment_id := p_assignment_id;
3562: l_asg_refresh_flag := 'Y';

Line 3563: Elsif p_assignment_id <> nvl(ghr_par_shd.g_old_rec.employee_assignment_id,hr_api.g_number) then

3559: trunc(nvl(p_effective_date,sysdate)) = trunc(nvl(ghr_par_shd.g_old_rec.effective_date,sysdate)))
3560: then
3561: l_assignment_id := p_assignment_id;
3562: l_asg_refresh_flag := 'Y';
3563: Elsif p_assignment_id <> nvl(ghr_par_shd.g_old_rec.employee_assignment_id,hr_api.g_number) then
3564: l_assignment_id := p_assignment_id;
3565: l_asg_refresh_flag := 'N';
3566: Else
3567: l_assignment_id := null;

Line 3571: if (p_position_id = nvl(ghr_par_shd.g_old_rec.to_position_id,hr_api.g_number) and

3567: l_assignment_id := null;
3568: End if;
3569: End if;
3570: If p_position_id is not null then
3571: if (p_position_id = nvl(ghr_par_shd.g_old_rec.to_position_id,hr_api.g_number) and
3572: (l_rei_rec_exists = 'N' or
3573: trunc(nvl(p_effective_date,sysdate)) <> trunc(nvl(ghr_par_shd.g_old_rec.effective_date,sysdate)))) or
3574: --Bug # 9006561 Added this condition to consider if the cancellation of one action and
3575: -- correction of another action of the same effective date has been processed consecutively

Line 3576: (p_position_id = nvl(ghr_par_shd.g_old_rec.to_position_id,hr_api.g_number) and

3572: (l_rei_rec_exists = 'N' or
3573: trunc(nvl(p_effective_date,sysdate)) <> trunc(nvl(ghr_par_shd.g_old_rec.effective_date,sysdate)))) or
3574: --Bug # 9006561 Added this condition to consider if the cancellation of one action and
3575: -- correction of another action of the same effective date has been processed consecutively
3576: (p_position_id = nvl(ghr_par_shd.g_old_rec.to_position_id,hr_api.g_number) and
3577: p_pa_request_id <> nvl(ghr_par_shd.g_old_rec.pa_request_id ,hr_api.g_number) and
3578: trunc(nvl(p_effective_date,sysdate)) = trunc(nvl(ghr_par_shd.g_old_rec.effective_date,sysdate)))
3579: then
3580: l_position_id := p_position_id;

Line 3577: p_pa_request_id <> nvl(ghr_par_shd.g_old_rec.pa_request_id ,hr_api.g_number) and

3573: trunc(nvl(p_effective_date,sysdate)) <> trunc(nvl(ghr_par_shd.g_old_rec.effective_date,sysdate)))) or
3574: --Bug # 9006561 Added this condition to consider if the cancellation of one action and
3575: -- correction of another action of the same effective date has been processed consecutively
3576: (p_position_id = nvl(ghr_par_shd.g_old_rec.to_position_id,hr_api.g_number) and
3577: p_pa_request_id <> nvl(ghr_par_shd.g_old_rec.pa_request_id ,hr_api.g_number) and
3578: trunc(nvl(p_effective_date,sysdate)) = trunc(nvl(ghr_par_shd.g_old_rec.effective_date,sysdate)))
3579: then
3580: l_position_id := p_position_id;
3581: l_pos_refresh_flag := 'Y';

Line 3582: Elsif p_position_id <> nvl(ghr_par_shd.g_old_rec.to_position_id,hr_api.g_number) then

3578: trunc(nvl(p_effective_date,sysdate)) = trunc(nvl(ghr_par_shd.g_old_rec.effective_date,sysdate)))
3579: then
3580: l_position_id := p_position_id;
3581: l_pos_refresh_flag := 'Y';
3582: Elsif p_position_id <> nvl(ghr_par_shd.g_old_rec.to_position_id,hr_api.g_number) then
3583: l_position_id := p_position_id;
3584: l_pos_refresh_flag := 'Y';
3585: Else
3586: l_position_id := null;

Line 3848: if nvl(c_req_num_rec.request_number,hr_api.g_number) <> 'MTI'||to_char(p_pa_request_id) then

3844: hr_utility.set_location(l_proc,10);
3845: hr_utility.set_location('info type ' || l_information_type,2);
3846: for c_req_num_rec in c_req_num loop
3847: --Bug 3128526. Added 'NVL' to handle NULL values
3848: if nvl(c_req_num_rec.request_number,hr_api.g_number) <> 'MTI'||to_char(p_pa_request_id) then
3849: appt_transfer;
3850: end if;
3851: end loop;
3852: elsif l_information_type = 'GHR_US_PAR_CONV_APP' then

Line 4212: l_perf_appraisal ghr_api.special_information_type;

4208: p_effective_date in date ,
4209: p_refresh_flag in varchar2 default 'Y'
4210: )
4211: is
4212: l_perf_appraisal ghr_api.special_information_type;
4213: l_update_rei varchar2(1) := 'N';
4214: l_exists boolean := FALSE;
4215: l_flag varchar2(1) := null;
4216: l_rei_rec ghr_pa_request_extra_info%rowtype;

Line 4227: l_person_type per_person_types.system_person_type%type := hr_api.g_varchar2;

4223: l_noa_family_code ghr_noa_families.noa_family_code%type;
4224:
4225: l_proc varchar2(72) := g_package || 'fetch_generic_extra_info';
4226: l_information_type ghr_pa_request_extra_info.information_type%type;
4227: l_person_type per_person_types.system_person_type%type := hr_api.g_varchar2;
4228:
4229: cursor c_bus_gp is
4230: select business_group_id
4231: from per_people_f

Line 4407: if p_person_id = nvl(ghr_par_shd.g_old_rec.person_id,hr_api.g_number) and

4403: l_org_rec := Null;
4404: End if;
4405:
4406: If p_person_id is not null then
4407: if p_person_id = nvl(ghr_par_shd.g_old_rec.person_id,hr_api.g_number) and
4408: trunc(nvl(p_effective_date,sysdate)) <> trunc(nvl(ghr_par_shd.g_old_rec.effective_date,sysdate))
4409: then
4410: l_person_id := p_person_id;
4411: l_per_refresh_flag := 'Y';

Line 4412: Elsif p_person_id <> nvl(ghr_par_shd.g_old_rec.person_id,hr_api.g_number) then

4408: trunc(nvl(p_effective_date,sysdate)) <> trunc(nvl(ghr_par_shd.g_old_rec.effective_date,sysdate))
4409: then
4410: l_person_id := p_person_id;
4411: l_per_refresh_flag := 'Y';
4412: Elsif p_person_id <> nvl(ghr_par_shd.g_old_rec.person_id,hr_api.g_number) then
4413: l_person_id := p_person_id;
4414: l_per_refresh_flag := 'N';
4415: Else
4416: l_person_id := null;

Line 4422: if p_assignment_id = nvl(ghr_par_shd.g_old_rec.employee_assignment_id,hr_api.g_number) and

4418: End if;
4419:
4420:
4421: If p_assignment_id is not null and l_flag = 'N' then
4422: if p_assignment_id = nvl(ghr_par_shd.g_old_rec.employee_assignment_id,hr_api.g_number) and
4423: trunc(nvl(p_effective_date,sysdate)) <> trunc(nvl(ghr_par_shd.g_old_rec.effective_date,sysdate))
4424: then
4425: l_assignment_id := p_assignment_id;
4426: l_asg_refresh_flag := 'Y';

Line 4427: Elsif p_assignment_id <> nvl(ghr_par_shd.g_old_rec.employee_assignment_id,hr_api.g_number) then

4423: trunc(nvl(p_effective_date,sysdate)) <> trunc(nvl(ghr_par_shd.g_old_rec.effective_date,sysdate))
4424: then
4425: l_assignment_id := p_assignment_id;
4426: l_asg_refresh_flag := 'Y';
4427: Elsif p_assignment_id <> nvl(ghr_par_shd.g_old_rec.employee_assignment_id,hr_api.g_number) then
4428: --and l_noa_family_code <> 'APP'
4429: l_assignment_id := p_assignment_id;
4430: l_asg_refresh_flag := 'N';
4431: Else

Line 4515: If nvl(l_noa_family_code,hr_api.g_varchar2) = 'APP' then

4511:
4512: hr_utility.set_location(l_proc,10);
4513: l_exists := FALSE;
4514:
4515: If nvl(l_noa_family_code,hr_api.g_varchar2) = 'APP' then
4516: hr_utility.set_location(l_proc,11);
4517: l_asg_refresh_flag := 'Y';
4518: If p_person_id is not null then
4519: for bus_gp in c_bus_gp loop

Line 4673: ghr_api.return_special_information

4669: end loop;
4670:
4671:
4672: hr_utility.set_location(l_proc,40);
4673: ghr_api.return_special_information
4674: (p_person_id => l_person_id,
4675: p_structure_name => 'US Fed Perf Appraisal',
4676: p_effective_date => nvl(p_effective_date,trunc(sysdate)),
4677: p_special_info => l_perf_appraisal

Line 4899: If nvl(l_dummy.rei_information3,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information3,hr_api.g_varchar2) or

4895: If l_exists then
4896: hr_utility.set_location(' rei exists ',1);
4897: If p_update_rei = 'Y' then
4898: hr_utility.set_location(' Update ',1);
4899: If nvl(l_dummy.rei_information3,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information3,hr_api.g_varchar2) or
4900: nvl(l_dummy.rei_information4,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information4,hr_api.g_varchar2) or
4901: nvl(l_dummy.rei_information5,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information5,hr_api.g_varchar2) or
4902: nvl(l_dummy.rei_information6,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information6,hr_api.g_varchar2) or
4903: nvl(l_dummy.rei_information7,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information7,hr_api.g_varchar2) or

Line 4900: nvl(l_dummy.rei_information4,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information4,hr_api.g_varchar2) or

4896: hr_utility.set_location(' rei exists ',1);
4897: If p_update_rei = 'Y' then
4898: hr_utility.set_location(' Update ',1);
4899: If nvl(l_dummy.rei_information3,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information3,hr_api.g_varchar2) or
4900: nvl(l_dummy.rei_information4,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information4,hr_api.g_varchar2) or
4901: nvl(l_dummy.rei_information5,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information5,hr_api.g_varchar2) or
4902: nvl(l_dummy.rei_information6,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information6,hr_api.g_varchar2) or
4903: nvl(l_dummy.rei_information7,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information7,hr_api.g_varchar2) or
4904: nvl(l_dummy.rei_information8,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information8,hr_api.g_varchar2) or

Line 4901: nvl(l_dummy.rei_information5,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information5,hr_api.g_varchar2) or

4897: If p_update_rei = 'Y' then
4898: hr_utility.set_location(' Update ',1);
4899: If nvl(l_dummy.rei_information3,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information3,hr_api.g_varchar2) or
4900: nvl(l_dummy.rei_information4,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information4,hr_api.g_varchar2) or
4901: nvl(l_dummy.rei_information5,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information5,hr_api.g_varchar2) or
4902: nvl(l_dummy.rei_information6,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information6,hr_api.g_varchar2) or
4903: nvl(l_dummy.rei_information7,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information7,hr_api.g_varchar2) or
4904: nvl(l_dummy.rei_information8,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information8,hr_api.g_varchar2) or
4905: nvl(l_dummy.rei_information9,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information9,hr_api.g_varchar2) or

Line 4902: nvl(l_dummy.rei_information6,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information6,hr_api.g_varchar2) or

4898: hr_utility.set_location(' Update ',1);
4899: If nvl(l_dummy.rei_information3,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information3,hr_api.g_varchar2) or
4900: nvl(l_dummy.rei_information4,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information4,hr_api.g_varchar2) or
4901: nvl(l_dummy.rei_information5,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information5,hr_api.g_varchar2) or
4902: nvl(l_dummy.rei_information6,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information6,hr_api.g_varchar2) or
4903: nvl(l_dummy.rei_information7,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information7,hr_api.g_varchar2) or
4904: nvl(l_dummy.rei_information8,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information8,hr_api.g_varchar2) or
4905: nvl(l_dummy.rei_information9,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information9,hr_api.g_varchar2) or
4906: nvl(l_dummy.rei_information10,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information10,hr_api.g_varchar2) or

Line 4903: nvl(l_dummy.rei_information7,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information7,hr_api.g_varchar2) or

4899: If nvl(l_dummy.rei_information3,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information3,hr_api.g_varchar2) or
4900: nvl(l_dummy.rei_information4,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information4,hr_api.g_varchar2) or
4901: nvl(l_dummy.rei_information5,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information5,hr_api.g_varchar2) or
4902: nvl(l_dummy.rei_information6,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information6,hr_api.g_varchar2) or
4903: nvl(l_dummy.rei_information7,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information7,hr_api.g_varchar2) or
4904: nvl(l_dummy.rei_information8,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information8,hr_api.g_varchar2) or
4905: nvl(l_dummy.rei_information9,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information9,hr_api.g_varchar2) or
4906: nvl(l_dummy.rei_information10,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information10,hr_api.g_varchar2) or
4907: nvl(l_dummy.rei_information11,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information11,hr_api.g_varchar2) or

Line 4904: nvl(l_dummy.rei_information8,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information8,hr_api.g_varchar2) or

4900: nvl(l_dummy.rei_information4,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information4,hr_api.g_varchar2) or
4901: nvl(l_dummy.rei_information5,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information5,hr_api.g_varchar2) or
4902: nvl(l_dummy.rei_information6,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information6,hr_api.g_varchar2) or
4903: nvl(l_dummy.rei_information7,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information7,hr_api.g_varchar2) or
4904: nvl(l_dummy.rei_information8,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information8,hr_api.g_varchar2) or
4905: nvl(l_dummy.rei_information9,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information9,hr_api.g_varchar2) or
4906: nvl(l_dummy.rei_information10,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information10,hr_api.g_varchar2) or
4907: nvl(l_dummy.rei_information11,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information11,hr_api.g_varchar2) or
4908: nvl(l_dummy.rei_information12,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information12,hr_api.g_varchar2) or

Line 4905: nvl(l_dummy.rei_information9,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information9,hr_api.g_varchar2) or

4901: nvl(l_dummy.rei_information5,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information5,hr_api.g_varchar2) or
4902: nvl(l_dummy.rei_information6,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information6,hr_api.g_varchar2) or
4903: nvl(l_dummy.rei_information7,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information7,hr_api.g_varchar2) or
4904: nvl(l_dummy.rei_information8,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information8,hr_api.g_varchar2) or
4905: nvl(l_dummy.rei_information9,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information9,hr_api.g_varchar2) or
4906: nvl(l_dummy.rei_information10,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information10,hr_api.g_varchar2) or
4907: nvl(l_dummy.rei_information11,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information11,hr_api.g_varchar2) or
4908: nvl(l_dummy.rei_information12,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information12,hr_api.g_varchar2) or
4909: nvl(l_dummy.rei_information13,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information13,hr_api.g_varchar2) or

Line 4906: nvl(l_dummy.rei_information10,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information10,hr_api.g_varchar2) or

4902: nvl(l_dummy.rei_information6,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information6,hr_api.g_varchar2) or
4903: nvl(l_dummy.rei_information7,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information7,hr_api.g_varchar2) or
4904: nvl(l_dummy.rei_information8,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information8,hr_api.g_varchar2) or
4905: nvl(l_dummy.rei_information9,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information9,hr_api.g_varchar2) or
4906: nvl(l_dummy.rei_information10,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information10,hr_api.g_varchar2) or
4907: nvl(l_dummy.rei_information11,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information11,hr_api.g_varchar2) or
4908: nvl(l_dummy.rei_information12,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information12,hr_api.g_varchar2) or
4909: nvl(l_dummy.rei_information13,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information13,hr_api.g_varchar2) or
4910: nvl(l_dummy.rei_information14,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information14,hr_api.g_varchar2) or

Line 4907: nvl(l_dummy.rei_information11,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information11,hr_api.g_varchar2) or

4903: nvl(l_dummy.rei_information7,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information7,hr_api.g_varchar2) or
4904: nvl(l_dummy.rei_information8,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information8,hr_api.g_varchar2) or
4905: nvl(l_dummy.rei_information9,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information9,hr_api.g_varchar2) or
4906: nvl(l_dummy.rei_information10,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information10,hr_api.g_varchar2) or
4907: nvl(l_dummy.rei_information11,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information11,hr_api.g_varchar2) or
4908: nvl(l_dummy.rei_information12,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information12,hr_api.g_varchar2) or
4909: nvl(l_dummy.rei_information13,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information13,hr_api.g_varchar2) or
4910: nvl(l_dummy.rei_information14,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information14,hr_api.g_varchar2) or
4911: nvl(l_dummy.rei_information15,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information15,hr_api.g_varchar2) or

Line 4908: nvl(l_dummy.rei_information12,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information12,hr_api.g_varchar2) or

4904: nvl(l_dummy.rei_information8,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information8,hr_api.g_varchar2) or
4905: nvl(l_dummy.rei_information9,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information9,hr_api.g_varchar2) or
4906: nvl(l_dummy.rei_information10,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information10,hr_api.g_varchar2) or
4907: nvl(l_dummy.rei_information11,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information11,hr_api.g_varchar2) or
4908: nvl(l_dummy.rei_information12,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information12,hr_api.g_varchar2) or
4909: nvl(l_dummy.rei_information13,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information13,hr_api.g_varchar2) or
4910: nvl(l_dummy.rei_information14,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information14,hr_api.g_varchar2) or
4911: nvl(l_dummy.rei_information15,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information15,hr_api.g_varchar2) or
4912: nvl(l_dummy.rei_information16,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information16,hr_api.g_varchar2) or

Line 4909: nvl(l_dummy.rei_information13,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information13,hr_api.g_varchar2) or

4905: nvl(l_dummy.rei_information9,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information9,hr_api.g_varchar2) or
4906: nvl(l_dummy.rei_information10,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information10,hr_api.g_varchar2) or
4907: nvl(l_dummy.rei_information11,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information11,hr_api.g_varchar2) or
4908: nvl(l_dummy.rei_information12,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information12,hr_api.g_varchar2) or
4909: nvl(l_dummy.rei_information13,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information13,hr_api.g_varchar2) or
4910: nvl(l_dummy.rei_information14,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information14,hr_api.g_varchar2) or
4911: nvl(l_dummy.rei_information15,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information15,hr_api.g_varchar2) or
4912: nvl(l_dummy.rei_information16,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information16,hr_api.g_varchar2) or
4913: nvl(l_dummy.rei_information17,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information17,hr_api.g_varchar2) or

Line 4910: nvl(l_dummy.rei_information14,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information14,hr_api.g_varchar2) or

4906: nvl(l_dummy.rei_information10,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information10,hr_api.g_varchar2) or
4907: nvl(l_dummy.rei_information11,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information11,hr_api.g_varchar2) or
4908: nvl(l_dummy.rei_information12,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information12,hr_api.g_varchar2) or
4909: nvl(l_dummy.rei_information13,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information13,hr_api.g_varchar2) or
4910: nvl(l_dummy.rei_information14,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information14,hr_api.g_varchar2) or
4911: nvl(l_dummy.rei_information15,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information15,hr_api.g_varchar2) or
4912: nvl(l_dummy.rei_information16,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information16,hr_api.g_varchar2) or
4913: nvl(l_dummy.rei_information17,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information17,hr_api.g_varchar2) or
4914: nvl(l_dummy.rei_information18,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information18,hr_api.g_varchar2) or

Line 4911: nvl(l_dummy.rei_information15,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information15,hr_api.g_varchar2) or

4907: nvl(l_dummy.rei_information11,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information11,hr_api.g_varchar2) or
4908: nvl(l_dummy.rei_information12,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information12,hr_api.g_varchar2) or
4909: nvl(l_dummy.rei_information13,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information13,hr_api.g_varchar2) or
4910: nvl(l_dummy.rei_information14,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information14,hr_api.g_varchar2) or
4911: nvl(l_dummy.rei_information15,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information15,hr_api.g_varchar2) or
4912: nvl(l_dummy.rei_information16,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information16,hr_api.g_varchar2) or
4913: nvl(l_dummy.rei_information17,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information17,hr_api.g_varchar2) or
4914: nvl(l_dummy.rei_information18,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information18,hr_api.g_varchar2) or
4915: nvl(l_dummy.rei_information19,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information19,hr_api.g_varchar2) or

Line 4912: nvl(l_dummy.rei_information16,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information16,hr_api.g_varchar2) or

4908: nvl(l_dummy.rei_information12,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information12,hr_api.g_varchar2) or
4909: nvl(l_dummy.rei_information13,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information13,hr_api.g_varchar2) or
4910: nvl(l_dummy.rei_information14,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information14,hr_api.g_varchar2) or
4911: nvl(l_dummy.rei_information15,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information15,hr_api.g_varchar2) or
4912: nvl(l_dummy.rei_information16,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information16,hr_api.g_varchar2) or
4913: nvl(l_dummy.rei_information17,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information17,hr_api.g_varchar2) or
4914: nvl(l_dummy.rei_information18,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information18,hr_api.g_varchar2) or
4915: nvl(l_dummy.rei_information19,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information19,hr_api.g_varchar2) or
4916: nvl(l_dummy.rei_information20,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information20,hr_api.g_varchar2) or

Line 4913: nvl(l_dummy.rei_information17,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information17,hr_api.g_varchar2) or

4909: nvl(l_dummy.rei_information13,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information13,hr_api.g_varchar2) or
4910: nvl(l_dummy.rei_information14,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information14,hr_api.g_varchar2) or
4911: nvl(l_dummy.rei_information15,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information15,hr_api.g_varchar2) or
4912: nvl(l_dummy.rei_information16,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information16,hr_api.g_varchar2) or
4913: nvl(l_dummy.rei_information17,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information17,hr_api.g_varchar2) or
4914: nvl(l_dummy.rei_information18,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information18,hr_api.g_varchar2) or
4915: nvl(l_dummy.rei_information19,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information19,hr_api.g_varchar2) or
4916: nvl(l_dummy.rei_information20,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information20,hr_api.g_varchar2) or
4917: nvl(l_dummy.rei_information21,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information21,hr_api.g_varchar2) or

Line 4914: nvl(l_dummy.rei_information18,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information18,hr_api.g_varchar2) or

4910: nvl(l_dummy.rei_information14,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information14,hr_api.g_varchar2) or
4911: nvl(l_dummy.rei_information15,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information15,hr_api.g_varchar2) or
4912: nvl(l_dummy.rei_information16,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information16,hr_api.g_varchar2) or
4913: nvl(l_dummy.rei_information17,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information17,hr_api.g_varchar2) or
4914: nvl(l_dummy.rei_information18,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information18,hr_api.g_varchar2) or
4915: nvl(l_dummy.rei_information19,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information19,hr_api.g_varchar2) or
4916: nvl(l_dummy.rei_information20,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information20,hr_api.g_varchar2) or
4917: nvl(l_dummy.rei_information21,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information21,hr_api.g_varchar2) or
4918: nvl(l_dummy.rei_information22,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information22,hr_api.g_varchar2) or

Line 4915: nvl(l_dummy.rei_information19,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information19,hr_api.g_varchar2) or

4911: nvl(l_dummy.rei_information15,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information15,hr_api.g_varchar2) or
4912: nvl(l_dummy.rei_information16,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information16,hr_api.g_varchar2) or
4913: nvl(l_dummy.rei_information17,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information17,hr_api.g_varchar2) or
4914: nvl(l_dummy.rei_information18,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information18,hr_api.g_varchar2) or
4915: nvl(l_dummy.rei_information19,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information19,hr_api.g_varchar2) or
4916: nvl(l_dummy.rei_information20,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information20,hr_api.g_varchar2) or
4917: nvl(l_dummy.rei_information21,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information21,hr_api.g_varchar2) or
4918: nvl(l_dummy.rei_information22,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information22,hr_api.g_varchar2) or
4919: nvl(l_dummy.rei_information23,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information23,hr_api.g_varchar2) or

Line 4916: nvl(l_dummy.rei_information20,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information20,hr_api.g_varchar2) or

4912: nvl(l_dummy.rei_information16,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information16,hr_api.g_varchar2) or
4913: nvl(l_dummy.rei_information17,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information17,hr_api.g_varchar2) or
4914: nvl(l_dummy.rei_information18,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information18,hr_api.g_varchar2) or
4915: nvl(l_dummy.rei_information19,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information19,hr_api.g_varchar2) or
4916: nvl(l_dummy.rei_information20,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information20,hr_api.g_varchar2) or
4917: nvl(l_dummy.rei_information21,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information21,hr_api.g_varchar2) or
4918: nvl(l_dummy.rei_information22,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information22,hr_api.g_varchar2) or
4919: nvl(l_dummy.rei_information23,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information23,hr_api.g_varchar2) or
4920: nvl(l_dummy.rei_information24,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information24,hr_api.g_varchar2) or

Line 4917: nvl(l_dummy.rei_information21,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information21,hr_api.g_varchar2) or

4913: nvl(l_dummy.rei_information17,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information17,hr_api.g_varchar2) or
4914: nvl(l_dummy.rei_information18,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information18,hr_api.g_varchar2) or
4915: nvl(l_dummy.rei_information19,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information19,hr_api.g_varchar2) or
4916: nvl(l_dummy.rei_information20,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information20,hr_api.g_varchar2) or
4917: nvl(l_dummy.rei_information21,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information21,hr_api.g_varchar2) or
4918: nvl(l_dummy.rei_information22,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information22,hr_api.g_varchar2) or
4919: nvl(l_dummy.rei_information23,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information23,hr_api.g_varchar2) or
4920: nvl(l_dummy.rei_information24,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information24,hr_api.g_varchar2) or
4921: nvl(l_dummy.rei_information25,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information25,hr_api.g_varchar2) or

Line 4918: nvl(l_dummy.rei_information22,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information22,hr_api.g_varchar2) or

4914: nvl(l_dummy.rei_information18,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information18,hr_api.g_varchar2) or
4915: nvl(l_dummy.rei_information19,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information19,hr_api.g_varchar2) or
4916: nvl(l_dummy.rei_information20,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information20,hr_api.g_varchar2) or
4917: nvl(l_dummy.rei_information21,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information21,hr_api.g_varchar2) or
4918: nvl(l_dummy.rei_information22,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information22,hr_api.g_varchar2) or
4919: nvl(l_dummy.rei_information23,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information23,hr_api.g_varchar2) or
4920: nvl(l_dummy.rei_information24,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information24,hr_api.g_varchar2) or
4921: nvl(l_dummy.rei_information25,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information25,hr_api.g_varchar2) or
4922: nvl(l_dummy.rei_information26,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information26,hr_api.g_varchar2) or

Line 4919: nvl(l_dummy.rei_information23,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information23,hr_api.g_varchar2) or

4915: nvl(l_dummy.rei_information19,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information19,hr_api.g_varchar2) or
4916: nvl(l_dummy.rei_information20,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information20,hr_api.g_varchar2) or
4917: nvl(l_dummy.rei_information21,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information21,hr_api.g_varchar2) or
4918: nvl(l_dummy.rei_information22,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information22,hr_api.g_varchar2) or
4919: nvl(l_dummy.rei_information23,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information23,hr_api.g_varchar2) or
4920: nvl(l_dummy.rei_information24,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information24,hr_api.g_varchar2) or
4921: nvl(l_dummy.rei_information25,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information25,hr_api.g_varchar2) or
4922: nvl(l_dummy.rei_information26,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information26,hr_api.g_varchar2) or
4923: nvl(l_dummy.rei_information27,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information27,hr_api.g_varchar2) or

Line 4920: nvl(l_dummy.rei_information24,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information24,hr_api.g_varchar2) or

4916: nvl(l_dummy.rei_information20,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information20,hr_api.g_varchar2) or
4917: nvl(l_dummy.rei_information21,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information21,hr_api.g_varchar2) or
4918: nvl(l_dummy.rei_information22,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information22,hr_api.g_varchar2) or
4919: nvl(l_dummy.rei_information23,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information23,hr_api.g_varchar2) or
4920: nvl(l_dummy.rei_information24,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information24,hr_api.g_varchar2) or
4921: nvl(l_dummy.rei_information25,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information25,hr_api.g_varchar2) or
4922: nvl(l_dummy.rei_information26,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information26,hr_api.g_varchar2) or
4923: nvl(l_dummy.rei_information27,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information27,hr_api.g_varchar2) or
4924: nvl(l_dummy.rei_information28,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information28,hr_api.g_varchar2) or

Line 4921: nvl(l_dummy.rei_information25,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information25,hr_api.g_varchar2) or

4917: nvl(l_dummy.rei_information21,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information21,hr_api.g_varchar2) or
4918: nvl(l_dummy.rei_information22,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information22,hr_api.g_varchar2) or
4919: nvl(l_dummy.rei_information23,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information23,hr_api.g_varchar2) or
4920: nvl(l_dummy.rei_information24,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information24,hr_api.g_varchar2) or
4921: nvl(l_dummy.rei_information25,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information25,hr_api.g_varchar2) or
4922: nvl(l_dummy.rei_information26,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information26,hr_api.g_varchar2) or
4923: nvl(l_dummy.rei_information27,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information27,hr_api.g_varchar2) or
4924: nvl(l_dummy.rei_information28,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information28,hr_api.g_varchar2) or
4925: nvl(l_dummy.rei_information29,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information29,hr_api.g_varchar2) or

Line 4922: nvl(l_dummy.rei_information26,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information26,hr_api.g_varchar2) or

4918: nvl(l_dummy.rei_information22,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information22,hr_api.g_varchar2) or
4919: nvl(l_dummy.rei_information23,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information23,hr_api.g_varchar2) or
4920: nvl(l_dummy.rei_information24,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information24,hr_api.g_varchar2) or
4921: nvl(l_dummy.rei_information25,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information25,hr_api.g_varchar2) or
4922: nvl(l_dummy.rei_information26,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information26,hr_api.g_varchar2) or
4923: nvl(l_dummy.rei_information27,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information27,hr_api.g_varchar2) or
4924: nvl(l_dummy.rei_information28,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information28,hr_api.g_varchar2) or
4925: nvl(l_dummy.rei_information29,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information29,hr_api.g_varchar2) or
4926: nvl(l_dummy.rei_information30,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information30,hr_api.g_varchar2) then

Line 4923: nvl(l_dummy.rei_information27,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information27,hr_api.g_varchar2) or

4919: nvl(l_dummy.rei_information23,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information23,hr_api.g_varchar2) or
4920: nvl(l_dummy.rei_information24,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information24,hr_api.g_varchar2) or
4921: nvl(l_dummy.rei_information25,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information25,hr_api.g_varchar2) or
4922: nvl(l_dummy.rei_information26,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information26,hr_api.g_varchar2) or
4923: nvl(l_dummy.rei_information27,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information27,hr_api.g_varchar2) or
4924: nvl(l_dummy.rei_information28,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information28,hr_api.g_varchar2) or
4925: nvl(l_dummy.rei_information29,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information29,hr_api.g_varchar2) or
4926: nvl(l_dummy.rei_information30,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information30,hr_api.g_varchar2) then
4927: hr_utility.set_location('operation is Update',1);

Line 4924: nvl(l_dummy.rei_information28,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information28,hr_api.g_varchar2) or

4920: nvl(l_dummy.rei_information24,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information24,hr_api.g_varchar2) or
4921: nvl(l_dummy.rei_information25,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information25,hr_api.g_varchar2) or
4922: nvl(l_dummy.rei_information26,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information26,hr_api.g_varchar2) or
4923: nvl(l_dummy.rei_information27,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information27,hr_api.g_varchar2) or
4924: nvl(l_dummy.rei_information28,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information28,hr_api.g_varchar2) or
4925: nvl(l_dummy.rei_information29,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information29,hr_api.g_varchar2) or
4926: nvl(l_dummy.rei_information30,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information30,hr_api.g_varchar2) then
4927: hr_utility.set_location('operation is Update',1);
4928: p_operation_flag := 'U';

Line 4925: nvl(l_dummy.rei_information29,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information29,hr_api.g_varchar2) or

4921: nvl(l_dummy.rei_information25,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information25,hr_api.g_varchar2) or
4922: nvl(l_dummy.rei_information26,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information26,hr_api.g_varchar2) or
4923: nvl(l_dummy.rei_information27,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information27,hr_api.g_varchar2) or
4924: nvl(l_dummy.rei_information28,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information28,hr_api.g_varchar2) or
4925: nvl(l_dummy.rei_information29,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information29,hr_api.g_varchar2) or
4926: nvl(l_dummy.rei_information30,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information30,hr_api.g_varchar2) then
4927: hr_utility.set_location('operation is Update',1);
4928: p_operation_flag := 'U';
4929: hr_utility.set_location(l_proc,25);

Line 4926: nvl(l_dummy.rei_information30,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information30,hr_api.g_varchar2) then

4922: nvl(l_dummy.rei_information26,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information26,hr_api.g_varchar2) or
4923: nvl(l_dummy.rei_information27,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information27,hr_api.g_varchar2) or
4924: nvl(l_dummy.rei_information28,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information28,hr_api.g_varchar2) or
4925: nvl(l_dummy.rei_information29,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information29,hr_api.g_varchar2) or
4926: nvl(l_dummy.rei_information30,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information30,hr_api.g_varchar2) then
4927: hr_utility.set_location('operation is Update',1);
4928: p_operation_flag := 'U';
4929: hr_utility.set_location(l_proc,25);
4930: End if;

Line 5184: If nvl(p_as_in_ddf,hr_api.g_varchar2) <> nvl(p_as_in_core,hr_api.g_varchar2) and

5180: begin
5181:
5182: If p_refresh_flag = 'Y' then
5183: hr_utility.set_location('in set ei - Y ',5);
5184: If nvl(p_as_in_ddf,hr_api.g_varchar2) <> nvl(p_as_in_core,hr_api.g_varchar2) and
5185: nvl(p_as_in_ddf,hr_api.g_varchar2) = nvl(p_original,hr_api.g_varchar2) then
5186: p_as_in_ddf := p_as_in_core;
5187: End if;
5188: Else

Line 5185: nvl(p_as_in_ddf,hr_api.g_varchar2) = nvl(p_original,hr_api.g_varchar2) then

5181:
5182: If p_refresh_flag = 'Y' then
5183: hr_utility.set_location('in set ei - Y ',5);
5184: If nvl(p_as_in_ddf,hr_api.g_varchar2) <> nvl(p_as_in_core,hr_api.g_varchar2) and
5185: nvl(p_as_in_ddf,hr_api.g_varchar2) = nvl(p_original,hr_api.g_varchar2) then
5186: p_as_in_ddf := p_as_in_core;
5187: End if;
5188: Else
5189: hr_utility.set_location('in set ei - N ',6);