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 227: IF (nvl(p_effective_date,hr_api.g_date)

223: hr_utility.set_location('l_noa_code is '||l_noa_code, 2);
224: -- Delete the RPA EI if there is a change in Effective Date or
225: -- Person
226: IF p_refresh_flag = 'N' THEN
227: IF (nvl(p_effective_date,hr_api.g_date)
228: <> nvl(ghr_par_shd.g_old_rec.effective_date,hr_api.g_date)) or
229: (nvl(p_person_id,hr_api.g_number)
230: <> nvl(ghr_par_shd.g_old_rec.person_id,hr_api.g_number)) then
231: hr_utility.set_location('Inside the Delete IF '||l_noa_code, 2);

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

224: -- Delete the RPA EI if there is a change in Effective Date or
225: -- Person
226: IF p_refresh_flag = 'N' THEN
227: IF (nvl(p_effective_date,hr_api.g_date)
228: <> nvl(ghr_par_shd.g_old_rec.effective_date,hr_api.g_date)) or
229: (nvl(p_person_id,hr_api.g_number)
230: <> nvl(ghr_par_shd.g_old_rec.person_id,hr_api.g_number)) then
231: hr_utility.set_location('Inside the Delete IF '||l_noa_code, 2);
232: -- Delete from ghr_pa_request_extra_info

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

225: -- Person
226: IF p_refresh_flag = 'N' THEN
227: IF (nvl(p_effective_date,hr_api.g_date)
228: <> nvl(ghr_par_shd.g_old_rec.effective_date,hr_api.g_date)) or
229: (nvl(p_person_id,hr_api.g_number)
230: <> nvl(ghr_par_shd.g_old_rec.person_id,hr_api.g_number)) then
231: hr_utility.set_location('Inside the Delete IF '||l_noa_code, 2);
232: -- Delete from ghr_pa_request_extra_info
233: DELETE ghr_pa_request_extra_info

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

226: IF p_refresh_flag = 'N' THEN
227: IF (nvl(p_effective_date,hr_api.g_date)
228: <> nvl(ghr_par_shd.g_old_rec.effective_date,hr_api.g_date)) or
229: (nvl(p_person_id,hr_api.g_number)
230: <> nvl(ghr_par_shd.g_old_rec.person_id,hr_api.g_number)) then
231: hr_utility.set_location('Inside the Delete IF '||l_noa_code, 2);
232: -- Delete from ghr_pa_request_extra_info
233: DELETE ghr_pa_request_extra_info
234: WHERE INFORMATION_TYPE in ( 'GHR_US_PAR_TERM_RET_GRADE',

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

886: hr_utility.set_location('Person inside appt_info is ' || to_char(l_person_id),1);
887: If l_person_id is not null then
888: hr_utility.set_location('Person inside appt_info is ' || to_char(l_person_id),1);
889: -- if the person_id is not the same as the old person_id then do the foll.
890: -- If l_person_id <> nvl(ghr_par_shd.g_old_rec.person_id,hr_api.g_number) then
891: -- a) Get PER_GROUP1 Information
892: l_refresh_flag := l_per_refresh_flag;
893: ghr_history_fetch.fetch_peopleei
894: (p_person_id => l_person_id,

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

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

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

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

Line 1207: IF nvl(l_retirement_plan,hr_api.g_varchar2)

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

Line 1217: IF nvl(l_retirement_plan,hr_api.g_varchar2)

1213: set_ei(l_org_rec.rei_information12,NULL,
1214: l_rei_rec.rei_information12,'Y');
1215: END IF; -- IF nvl(l_retirement_pl
1216: -- TSP Status
1217: IF nvl(l_retirement_plan,hr_api.g_varchar2)
1218: in ('D','K','L','M','N','P') THEN
1219: set_ei(l_org_rec.rei_information15,'I',
1220: l_rei_rec.rei_information15,'Y');
1221: ELSIF nvl(l_retirement_plan,hr_api.g_varchar2)

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

1217: IF nvl(l_retirement_plan,hr_api.g_varchar2)
1218: in ('D','K','L','M','N','P') THEN
1219: set_ei(l_org_rec.rei_information15,'I',
1220: l_rei_rec.rei_information15,'Y');
1221: ELSIF nvl(l_retirement_plan,hr_api.g_varchar2)
1222: in ('2','4','5') THEN
1223: set_ei(l_org_rec.rei_information15,NULL,
1224: l_rei_rec.rei_information15,'Y');
1225: ELSIF nvl(l_retirement_plan,hr_api.g_varchar2)

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

1221: ELSIF nvl(l_retirement_plan,hr_api.g_varchar2)
1222: in ('2','4','5') THEN
1223: set_ei(l_org_rec.rei_information15,NULL,
1224: l_rei_rec.rei_information15,'Y');
1225: ELSIF nvl(l_retirement_plan,hr_api.g_varchar2)
1226: in ('1','3','8','9','C','E','F','G','H','R','T',
1227: 'W' ) THEN
1228: set_ei(l_org_rec.rei_information15,'E',
1229: l_rei_rec.rei_information15,'Y');

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

1229: l_rei_rec.rei_information15,'Y');
1230: ELSE
1231: set_ei(l_org_rec.rei_information15,NULL,
1232: l_rei_rec.rei_information15,'Y');
1233: END IF; -- IF nvl(l_retirement_plan,hr_api.
1234: -- TSP Status Date
1235: IF NVL(l_retirement_plan,hr_api.g_varchar2)
1236: NOT IN ('2','4','5') THEN
1237: set_ei(l_org_rec.rei_information16,fnd_date.date_to_canonical(l_effective_date),

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

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

Line 1246: IF NVL(l_retirement_plan,hr_api.g_varchar2) IN ('D', 'K', 'L', 'M', 'N', 'P') THEN

1242: set_ei(l_org_rec.rei_information18,NULL,l_rei_rec.rei_information18,'Y'); -- TSP Emp Contrib Elig Date
1243: END IF; -- -- TSP Status Date
1244:
1245: -- TSP Agency Contrib Elig Date
1246: IF NVL(l_retirement_plan,hr_api.g_varchar2) IN ('D', 'K', 'L', 'M', 'N', 'P') THEN
1247: -- Get Payroll ID
1248: FOR l_cur_payroll_id IN c_payroll_id(l_pa_request_id) LOOP
1249: l_payroll_id := l_cur_payroll_id.payroll_id;
1250: END LOOP;

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

1350: END IF;
1351: END IF; -- IF l_fehb_exists = FALSE OR
1352:
1353: -- FEGLI Eligibility expires
1354: IF NVL(l_fegli,hr_api.g_varchar2) <> 'A0' AND
1355: NVL(l_prev_fegli,hr_api.g_varchar2) = 'A0' THEN
1356: set_ei(l_org_rec.rei_information10, fnd_date.date_to_canonical(nvl(l_effective_date,TRUNC(sysdate))+31), l_rei_rec.rei_information10,'Y');
1357: END IF;
1358:

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

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

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

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

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

1383: END IF; -- IF nvl(l_retirement_pl
1384:
1385: -- TSP Status
1386: hr_utility.set_location('TSP status' || l_tsp_status,111);
1387: IF nvl(l_retirement_plan,hr_api.g_varchar2) IN ('D','K','L','M','N','P') AND l_tsp_status IS NULL THEN
1388: set_ei(l_org_rec.rei_information15,'I', l_rei_rec.rei_information15,'Y');
1389: ELSIF nvl(l_retirement_plan,hr_api.g_varchar2) IN ('2','4','5') THEN
1390: set_ei(l_org_rec.rei_information15,NULL, l_rei_rec.rei_information15,'Y');
1391: 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 1389: ELSIF nvl(l_retirement_plan,hr_api.g_varchar2) IN ('2','4','5') THEN

1385: -- TSP Status
1386: hr_utility.set_location('TSP status' || l_tsp_status,111);
1387: IF nvl(l_retirement_plan,hr_api.g_varchar2) IN ('D','K','L','M','N','P') AND l_tsp_status IS NULL THEN
1388: set_ei(l_org_rec.rei_information15,'I', l_rei_rec.rei_information15,'Y');
1389: ELSIF nvl(l_retirement_plan,hr_api.g_varchar2) IN ('2','4','5') THEN
1390: set_ei(l_org_rec.rei_information15,NULL, l_rei_rec.rei_information15,'Y');
1391: 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
1392: set_ei(l_org_rec.rei_information15,'E', l_rei_rec.rei_information15,'Y');
1393: ELSE

Line 1391: 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

1387: IF nvl(l_retirement_plan,hr_api.g_varchar2) IN ('D','K','L','M','N','P') AND l_tsp_status IS NULL THEN
1388: set_ei(l_org_rec.rei_information15,'I', l_rei_rec.rei_information15,'Y');
1389: ELSIF nvl(l_retirement_plan,hr_api.g_varchar2) IN ('2','4','5') THEN
1390: set_ei(l_org_rec.rei_information15,NULL, l_rei_rec.rei_information15,'Y');
1391: 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
1392: set_ei(l_org_rec.rei_information15,'E', l_rei_rec.rei_information15,'Y');
1393: ELSE
1394: set_ei(l_org_rec.rei_information15,NULL, l_rei_rec.rei_information15,'Y');
1395: END IF; -- IF nvl(l_retirement_plan,hr_api.

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

1391: 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
1392: set_ei(l_org_rec.rei_information15,'E', l_rei_rec.rei_information15,'Y');
1393: ELSE
1394: set_ei(l_org_rec.rei_information15,NULL, l_rei_rec.rei_information15,'Y');
1395: END IF; -- IF nvl(l_retirement_plan,hr_api.
1396:
1397: -- TSP Status Date
1398: IF NVL(l_retirement_plan,hr_api.g_varchar2) NOT IN ('2','4','5') AND l_tsp_status_date IS NULL THEN
1399: set_ei(l_org_rec.rei_information16,fnd_date.date_to_canonical(l_effective_date), l_rei_rec.rei_information16,'Y');

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

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

Line 1405: IF NVL(l_retirement_plan,hr_api.g_varchar2) IN ('D', 'K', 'L', 'M', 'N', 'P') AND l_agency_contrib_date IS NULL THEN

1401: set_ei(l_org_rec.rei_information16,NULL, l_rei_rec.rei_information16,'Y');
1402: END IF; -- -- TSP Status Date
1403:
1404: -- TSP Agency Contrib Elig Date
1405: IF NVL(l_retirement_plan,hr_api.g_varchar2) IN ('D', 'K', 'L', 'M', 'N', 'P') AND l_agency_contrib_date IS NULL THEN
1406: -- Get Payroll ID
1407: FOR l_cur_payroll_id IN c_payroll_id(l_pa_request_id) LOOP
1408: l_payroll_id := l_cur_payroll_id.payroll_id;
1409: END LOOP;

Line 1466: ghr_api.retrieve_element_entry_value

1462: hr_utility.set_location('Person inside mddds_pay is ' || to_char(l_person_id),1);
1463:
1464: l_refresh_flag := l_per_refresh_flag;
1465:
1466: ghr_api.retrieve_element_entry_value
1467: (p_element_name => 'MDDDS Special Pay',
1468: p_input_value_name => 'Full Time Status',
1469: p_assignment_id => l_assignment_id,
1470: p_effective_date => nvl(p_effective_date,trunc(sysdate)),

Line 1476: ghr_api.retrieve_element_entry_value

1472: p_multiple_error_flag => l_multiple_error_flag
1473: );
1474: set_ei(l_org_rec.rei_information9, l_value, l_rei_rec.rei_information9, l_refresh_flag);
1475:
1476: ghr_api.retrieve_element_entry_value
1477: (p_element_name => 'MDDDS Special Pay',
1478: p_input_value_name => 'Length of Service',
1479: p_assignment_id => l_assignment_id,
1480: p_effective_date => nvl(p_effective_date,trunc(sysdate)),

Line 1486: ghr_api.retrieve_element_entry_value

1482: p_multiple_error_flag => l_multiple_error_flag
1483: );
1484: set_ei(l_org_rec.rei_information10, l_value, l_rei_rec.rei_information10, l_refresh_flag);
1485:
1486: ghr_api.retrieve_element_entry_value
1487: (p_element_name => 'MDDDS Special Pay',
1488: p_input_value_name => 'Scarce Specialty',
1489: p_assignment_id => l_assignment_id,
1490: p_effective_date => nvl(p_effective_date,trunc(sysdate)),

Line 1496: ghr_api.retrieve_element_entry_value

1492: p_multiple_error_flag => l_multiple_error_flag
1493: );
1494: set_ei(l_org_rec.rei_information3, l_value, l_rei_rec.rei_information3, l_refresh_flag);
1495:
1496: ghr_api.retrieve_element_entry_value
1497: (p_element_name => 'MDDDS Special Pay',
1498: p_input_value_name => 'Specialty or Board Certification',
1499: p_assignment_id => l_assignment_id,
1500: p_effective_date => nvl(p_effective_date,trunc(sysdate)),

Line 1506: ghr_api.retrieve_element_entry_value

1502: p_multiple_error_flag => l_multiple_error_flag
1503: );
1504: set_ei(l_org_rec.rei_information4, l_value, l_rei_rec.rei_information4, l_refresh_flag);
1505:
1506: ghr_api.retrieve_element_entry_value
1507: (p_element_name => 'MDDDS Special Pay',
1508: p_input_value_name => 'Geographic Location',
1509: p_assignment_id => l_assignment_id,
1510: p_effective_date => nvl(p_effective_date,trunc(sysdate)),

Line 1516: ghr_api.retrieve_element_entry_value

1512: p_multiple_error_flag => l_multiple_error_flag
1513: );
1514: set_ei(l_org_rec.rei_information5, l_value, l_rei_rec.rei_information5, l_refresh_flag);
1515:
1516: ghr_api.retrieve_element_entry_value
1517: (p_element_name => 'MDDDS Special Pay',
1518: p_input_value_name => 'Exceptional Qualifications',
1519: p_assignment_id => l_assignment_id,
1520: p_effective_date => nvl(p_effective_date,trunc(sysdate)),

Line 1526: ghr_api.retrieve_element_entry_value

1522: p_multiple_error_flag => l_multiple_error_flag
1523: );
1524: set_ei(l_org_rec.rei_information6, l_value, l_rei_rec.rei_information6, l_refresh_flag);
1525:
1526: ghr_api.retrieve_element_entry_value
1527: (p_element_name => 'MDDDS Special Pay',
1528: p_input_value_name => 'Executive Position',
1529: p_assignment_id => l_assignment_id,
1530: p_effective_date => nvl(p_effective_date,trunc(sysdate)),

Line 1536: ghr_api.retrieve_element_entry_value

1532: p_multiple_error_flag => l_multiple_error_flag
1533: );
1534: set_ei(l_org_rec.rei_information7, l_value, l_rei_rec.rei_information7, l_refresh_flag);
1535:
1536: ghr_api.retrieve_element_entry_value
1537: (p_element_name => 'MDDDS Special Pay',
1538: p_input_value_name => 'Dentist Post Graduate Training',
1539: p_assignment_id => l_assignment_id,
1540: p_effective_date => nvl(p_effective_date,trunc(sysdate)),

Line 1546: ghr_api.retrieve_element_entry_value

1542: p_multiple_error_flag => l_multiple_error_flag
1543: );
1544: set_ei(l_org_rec.rei_information8, l_value, l_rei_rec.rei_information8, l_refresh_flag);
1545:
1546: ghr_api.retrieve_element_entry_value
1547: (p_element_name => 'MDDDS Special Pay',
1548: p_input_value_name => 'Amount',
1549: p_assignment_id => l_assignment_id,
1550: p_effective_date => nvl(p_effective_date,trunc(sysdate)),

Line 1560: ghr_api.retrieve_element_entry_value

1556: if l_rei_rec.rei_information11 is null then
1557: l_rei_rec.rei_information11 := 0;
1558: end if;
1559:
1560: ghr_api.retrieve_element_entry_value
1561: (p_element_name => 'MDDDS Special Pay',
1562: p_input_value_name => 'MDDDS Special Pay NTE Date',
1563: p_assignment_id => l_assignment_id,
1564: p_effective_date => nvl(p_effective_date,trunc(sysdate)),

Line 1570: ghr_api.retrieve_element_entry_value

1566: p_multiple_error_flag => l_multiple_error_flag
1567: );
1568: set_ei(l_org_rec.rei_information12, l_value, l_rei_rec.rei_information12, l_refresh_flag);
1569:
1570: ghr_api.retrieve_element_entry_value
1571: (p_element_name => 'Premium Pay',
1572: p_input_value_name => 'Premium Pay Ind',
1573: p_assignment_id => l_assignment_id,
1574: p_effective_date => nvl(p_effective_date,trunc(sysdate)),

Line 1594: ghr_api.retrieve_element_entry_value

1590: If l_assignment_id is not null then
1591: hr_utility.set_location('Person inside premium_pay_ind is ' || to_char(l_person_id),1);
1592: l_refresh_flag := l_per_refresh_flag;
1593:
1594: ghr_api.retrieve_element_entry_value
1595: (p_element_name => 'Premium Pay',
1596: p_input_value_name => 'Premium Pay Ind',
1597: p_assignment_id => l_assignment_id,
1598: p_effective_date => nvl(p_effective_date,trunc(sysdate)),

Line 1760: /*ghr_api.retrieve_element_entry_value

1756: set_ei(l_org_rec.rei_information17,l_asg_ei_data.aei_information9,l_rei_rec.rei_information17,l_refresh_flag);
1757: l_org_rec.rei_information17 := l_asg_ei_data.aei_information9;
1758:
1759: l_asg_ei_data := null;
1760: /*ghr_api.retrieve_element_entry_value
1761: (p_element_name => 'Within Grade Increase',
1762: p_input_value_name => 'Date Due',
1763: p_assignment_id => l_assignment_id,
1764: p_effective_date => nvl(p_effective_date,trunc(sysdate)),

Line 1899: ghr_api.retrieve_element_entry_value

1895: set_ei(l_org_rec.rei_information11,l_asg_ei_data.aei_information9,l_rei_rec.rei_information11,l_refresh_flag);
1896: -- Start Bug 1318341
1897:
1898: --Bug#5527363 Modified the l_assignment_id parameter passed.
1899: ghr_api.retrieve_element_entry_value
1900: (p_element_name => 'Within Grade Increase',
1901: p_input_value_name => 'Date Due',
1902: p_assignment_id => NVL(l_assignment_id,p_assignment_id),
1903: p_effective_date => nvl(p_effective_date,trunc(sysdate)),

Line 2241: l_agency_code := ghr_api.get_position_agency_code_pos

2237: l_pos_ei_data := null;
2238: FOR c_bg_id in c_bg LOOP
2239: l_bg_id := c_bg_id.business_group_id;
2240: END LOOP;
2241: l_agency_code := ghr_api.get_position_agency_code_pos
2242: (p_position_id => l_position_id
2243: ,p_business_group_id => l_bg_id
2244: ,p_effective_date => nvl(p_effective_date,trunc(sysdate)));
2245: set_ei(l_org_rec.rei_information4,l_agency_code,l_rei_rec.rei_information4,l_refresh_flag);

Line 2353: l_special_info ghr_api.special_information_type;

2349: End scd_tsp;
2350: --
2351: --
2352: Procedure non_pay_duty is
2353: l_special_info ghr_api.special_information_type;
2354: begin
2355:
2356: If l_person_id is not null then
2357: l_refresh_flag := l_per_refresh_flag;

Line 2375: l_special_info ghr_api.special_information_type;

2371: End non_pay_duty;
2372: --
2373: --
2374: Procedure lwop_info is
2375: l_special_info ghr_api.special_information_type;
2376: begin
2377:
2378: If l_person_id is not null then
2379: l_refresh_flag := l_per_refresh_flag;

Line 2431: l_agency_code := ghr_api.get_position_agency_code_pos

2427: IF p_position_id is NOT NULL then
2428: FOR c_bg_id in c_bg1 LOOP
2429: l_bg_id := c_bg_id.business_group_id;
2430: END LOOP;
2431: l_agency_code := ghr_api.get_position_agency_code_pos
2432: (p_position_id => p_position_id
2433: ,p_business_group_id => l_bg_id);
2434: set_ei(l_org_rec.rei_information3, substr(l_agency_code,1,2), l_rei_rec.rei_information3, l_refresh_flag);
2435: END IF;

Line 2574: ghr_api.retrieve_element_entry_value

2570: --
2571: -- Fetch the element entry value
2572: IF l_assignment_id is not null THEN
2573: l_refresh_flag := l_per_refresh_flag;
2574: ghr_api.retrieve_element_entry_value
2575: (p_element_name => 'FEGLI',
2576: p_input_value_name => 'Eligibility Expiration',
2577: p_assignment_id => l_assignment_id,
2578: p_effective_date => nvl(p_effective_date,trunc(sysdate)),

Line 2628: ghr_api.retrieve_element_entry_value

2624: --
2625: -- Fetch the element entry value
2626: IF l_assignment_id is not null THEN
2627: l_refresh_flag := l_per_refresh_flag;
2628: ghr_api.retrieve_element_entry_value
2629: (p_element_name => 'Foreign Transfer Allowance',
2630: p_input_value_name => 'Last Action Code',
2631: p_assignment_id => l_assignment_id,
2632: p_effective_date => nvl(p_effective_date,trunc(sysdate)),

Line 2638: ghr_api.retrieve_element_entry_value

2634: p_multiple_error_flag => l_multiple_error_flag
2635: );
2636: set_ei(l_org_rec.rei_information3, l_value, l_rei_rec.rei_information3, l_refresh_flag);
2637: l_value := NULL;
2638: ghr_api.retrieve_element_entry_value
2639: (p_element_name => 'Foreign Transfer Allowance',
2640: p_input_value_name => 'Number Family Members',
2641: p_assignment_id => l_assignment_id,
2642: p_effective_date => nvl(p_effective_date,trunc(sysdate)),

Line 2648: ghr_api.retrieve_element_entry_value

2644: p_multiple_error_flag => l_multiple_error_flag
2645: );
2646: set_ei(l_org_rec.rei_information4, l_value, l_rei_rec.rei_information4, l_refresh_flag);
2647: l_value := NULL;
2648: ghr_api.retrieve_element_entry_value
2649: (p_element_name => 'Foreign Transfer Allowance',
2650: p_input_value_name => 'Miscellaneous Expense',
2651: p_assignment_id => l_assignment_id,
2652: p_effective_date => nvl(p_effective_date,trunc(sysdate)),

Line 2658: ghr_api.retrieve_element_entry_value

2654: p_multiple_error_flag => l_multiple_error_flag
2655: );
2656: set_ei(l_org_rec.rei_information5, l_value, l_rei_rec.rei_information5, l_refresh_flag);
2657: l_value := NULL;
2658: ghr_api.retrieve_element_entry_value
2659: (p_element_name => 'Foreign Transfer Allowance',
2660: p_input_value_name => 'Wardrobe Expense',
2661: p_assignment_id => l_assignment_id,
2662: p_effective_date => nvl(p_effective_date,trunc(sysdate)),

Line 2668: ghr_api.retrieve_element_entry_value

2664: p_multiple_error_flag => l_multiple_error_flag
2665: );
2666: set_ei(l_org_rec.rei_information6, l_value, l_rei_rec.rei_information6, l_refresh_flag);
2667: l_value := NULL;
2668: ghr_api.retrieve_element_entry_value
2669: (p_element_name => 'Foreign Transfer Allowance',
2670: p_input_value_name => 'Pre Departure Sub Expense',
2671: p_assignment_id => l_assignment_id,
2672: p_effective_date => nvl(p_effective_date,trunc(sysdate)),

Line 2678: ghr_api.retrieve_element_entry_value

2674: p_multiple_error_flag => l_multiple_error_flag
2675: );
2676: set_ei(l_org_rec.rei_information7, l_value, l_rei_rec.rei_information7, l_refresh_flag);
2677: l_value := NULL;
2678: ghr_api.retrieve_element_entry_value
2679: (p_element_name => 'Foreign Transfer Allowance',
2680: p_input_value_name => 'Lease Penalty Expense',
2681: p_assignment_id => l_assignment_id,
2682: p_effective_date => nvl(p_effective_date,trunc(sysdate)),

Line 2688: ghr_api.retrieve_element_entry_value

2684: p_multiple_error_flag => l_multiple_error_flag
2685: );
2686: set_ei(l_org_rec.rei_information8, l_value, l_rei_rec.rei_information8, l_refresh_flag);
2687: l_value := NULL;
2688: ghr_api.retrieve_element_entry_value
2689: (p_element_name => 'Foreign Transfer Allowance',
2690: p_input_value_name => 'Amount',
2691: p_assignment_id => l_assignment_id,
2692: p_effective_date => nvl(p_effective_date,trunc(sysdate)),

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

2773: p_per_ei_data => l_per_ei_data
2774: );
2775: l_refresh_flag := l_per_refresh_flag;
2776: /* --Begin Bug# 4588575
2777: IF nvl(l_tenure,hr_api.g_varchar2) = '2' and
2778: nvl(l_pos_occpied,hr_api.g_varchar2) = '1' and
2779: nvl(l_pos_intel_pos,hr_api.g_varchar2) <> '2' THEN
2780: set_ei(l_org_rec.rei_information3,fnd_date.date_to_canonical(p_effective_date),
2781: l_rei_rec.rei_information3,l_refresh_flag);

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

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

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

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

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

2785: set_ei(l_org_rec.rei_information3,l_per_ei_data.pei_information3,
2786: l_rei_rec.rei_information3,l_refresh_flag);
2787: /* END IF;
2788: --Begin Bug# 4588575
2789: IF nvl(l_tenure,hr_api.g_varchar2) = '2' and
2790: nvl(l_pos_occpied,hr_api.g_varchar2) = '1' and
2791: l_rei_rec.rei_information3 IS NOT NULL THEN
2792: set_ei(l_org_rec.rei_information4,
2793: fnd_date.date_to_canonical(add_months(p_effective_date,36)),

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

2786: l_rei_rec.rei_information3,l_refresh_flag);
2787: /* END IF;
2788: --Begin Bug# 4588575
2789: IF nvl(l_tenure,hr_api.g_varchar2) = '2' and
2790: nvl(l_pos_occpied,hr_api.g_varchar2) = '1' and
2791: l_rei_rec.rei_information3 IS NOT NULL THEN
2792: set_ei(l_org_rec.rei_information4,
2793: fnd_date.date_to_canonical(add_months(p_effective_date,36)),
2794: l_rei_rec.rei_information4,l_refresh_flag);

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

2801:
2802: set_ei(l_org_rec.rei_information5,l_per_ei_data.pei_information5,
2803: l_rei_rec.rei_information5,l_refresh_flag);
2804: /*--Begin Bug# 4588575
2805: IF nvl(l_la_code1,hr_api.g_varchar2) = 'J8M' THEN
2806: set_ei( l_org_rec.rei_information6,
2807: fnd_date.date_to_canonical(add_months(p_effective_date,24)),
2808: l_rei_rec.rei_information6,l_refresh_flag);
2809: ELSE

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

2911: */ --Backout the changes done for Bug# 4588575
2912: Procedure set_refresh_flags is
2913: Begin
2914: If p_person_id is not null then
2915: if p_person_id = nvl(ghr_par_shd.g_old_rec.person_id,hr_api.g_number) and
2916: (l_rei_rec_exists = 'N' or
2917: trunc(nvl(p_effective_date,sysdate)) <> trunc(nvl(ghr_par_shd.g_old_rec.effective_date,sysdate)))
2918: then
2919: hr_utility.set_location('change in eff. date only',2);

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

2918: then
2919: hr_utility.set_location('change in eff. date only',2);
2920: l_person_id := p_person_id;
2921: l_per_refresh_flag := 'Y';
2922: Elsif p_person_id <> nvl(ghr_par_shd.g_old_rec.person_id,hr_api.g_number) then
2923: hr_utility.set_location('person id has changed',3);
2924: l_person_id := p_person_id;
2925: l_per_refresh_flag := 'N';
2926: Else

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

2928: End if;
2929: hr_utility.set_location('person id in the condition - refresh flag N ' || to_char(l_person_id),1);
2930: End if;
2931: If p_assignment_id is not null then
2932: if p_assignment_id = nvl(ghr_par_shd.g_old_rec.employee_assignment_id,hr_api.g_number) and
2933: (l_rei_rec_exists = 'N' or
2934: trunc(nvl(p_effective_date,sysdate)) <> trunc(nvl(ghr_par_shd.g_old_rec.effective_date,sysdate)))
2935: then
2936: l_assignment_id := p_assignment_id;

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

2934: trunc(nvl(p_effective_date,sysdate)) <> trunc(nvl(ghr_par_shd.g_old_rec.effective_date,sysdate)))
2935: then
2936: l_assignment_id := p_assignment_id;
2937: l_asg_refresh_flag := 'Y';
2938: Elsif p_assignment_id <> nvl(ghr_par_shd.g_old_rec.employee_assignment_id,hr_api.g_number) then
2939: l_assignment_id := p_assignment_id;
2940: l_asg_refresh_flag := 'N';
2941: Else
2942: l_assignment_id := null;

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

2942: l_assignment_id := null;
2943: End if;
2944: End if;
2945: If p_position_id is not null then
2946: if p_position_id = nvl(ghr_par_shd.g_old_rec.to_position_id,hr_api.g_number) and
2947: (l_rei_rec_exists = 'N' or
2948: trunc(nvl(p_effective_date,sysdate)) <> trunc(nvl(ghr_par_shd.g_old_rec.effective_date,sysdate)))
2949: then
2950: l_position_id := p_position_id;

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

2948: trunc(nvl(p_effective_date,sysdate)) <> trunc(nvl(ghr_par_shd.g_old_rec.effective_date,sysdate)))
2949: then
2950: l_position_id := p_position_id;
2951: l_pos_refresh_flag := 'Y';
2952: Elsif p_position_id <> nvl(ghr_par_shd.g_old_rec.to_position_id,hr_api.g_number) then
2953: l_position_id := p_position_id;
2954: l_pos_refresh_flag := 'Y';
2955: Else
2956: l_position_id := null;

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

3148: hr_utility.set_location(l_proc,10);
3149: hr_utility.set_location('info type ' || l_information_type,2);
3150: for c_req_num_rec in c_req_num loop
3151: --Bug 3128526. Added 'NVL' to handle NULL values
3152: if nvl(c_req_num_rec.request_number,hr_api.g_number) <> 'MTI'||to_char(p_pa_request_id) then
3153: appt_transfer;
3154: end if;
3155: end loop;
3156: elsif l_information_type = 'GHR_US_PAR_CONV_APP' then

Line 3455: l_perf_appraisal ghr_api.special_information_type;

3451: p_effective_date in date ,
3452: p_refresh_flag in varchar2 default 'Y'
3453: )
3454: is
3455: l_perf_appraisal ghr_api.special_information_type;
3456: l_update_rei varchar2(1) := 'N';
3457: l_exists boolean := FALSE;
3458: l_flag varchar2(1) := null;
3459: l_rei_rec ghr_pa_request_extra_info%rowtype;

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

3466: l_noa_family_code ghr_noa_families.noa_family_code%type;
3467:
3468: l_proc varchar2(72) := g_package || 'fetch_gneric_extra_info';
3469: l_information_type ghr_pa_request_extra_info.information_type%type;
3470: l_person_type per_person_types.system_person_type%type := hr_api.g_varchar2;
3471:
3472: cursor c_bus_gp is
3473: select business_group_id
3474: from per_people_f

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

3646: l_org_rec := Null;
3647: End if;
3648:
3649: If p_person_id is not null then
3650: if p_person_id = nvl(ghr_par_shd.g_old_rec.person_id,hr_api.g_number) and
3651: trunc(nvl(p_effective_date,sysdate)) <> trunc(nvl(ghr_par_shd.g_old_rec.effective_date,sysdate))
3652: then
3653: l_person_id := p_person_id;
3654: l_per_refresh_flag := 'Y';

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

3651: trunc(nvl(p_effective_date,sysdate)) <> trunc(nvl(ghr_par_shd.g_old_rec.effective_date,sysdate))
3652: then
3653: l_person_id := p_person_id;
3654: l_per_refresh_flag := 'Y';
3655: Elsif p_person_id <> nvl(ghr_par_shd.g_old_rec.person_id,hr_api.g_number) then
3656: l_person_id := p_person_id;
3657: l_per_refresh_flag := 'N';
3658: Else
3659: l_person_id := null;

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

3661: End if;
3662:
3663:
3664: If p_assignment_id is not null and l_flag = 'N' then
3665: if p_assignment_id = nvl(ghr_par_shd.g_old_rec.employee_assignment_id,hr_api.g_number) and
3666: trunc(nvl(p_effective_date,sysdate)) <> trunc(nvl(ghr_par_shd.g_old_rec.effective_date,sysdate))
3667: then
3668: l_assignment_id := p_assignment_id;
3669: l_asg_refresh_flag := 'Y';

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

3666: trunc(nvl(p_effective_date,sysdate)) <> trunc(nvl(ghr_par_shd.g_old_rec.effective_date,sysdate))
3667: then
3668: l_assignment_id := p_assignment_id;
3669: l_asg_refresh_flag := 'Y';
3670: Elsif p_assignment_id <> nvl(ghr_par_shd.g_old_rec.employee_assignment_id,hr_api.g_number) then
3671: --and l_noa_family_code <> 'APP'
3672: l_assignment_id := p_assignment_id;
3673: l_asg_refresh_flag := 'N';
3674: Else

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

3754:
3755: hr_utility.set_location(l_proc,10);
3756: l_exists := FALSE;
3757:
3758: If nvl(l_noa_family_code,hr_api.g_varchar2) = 'APP' then
3759: hr_utility.set_location(l_proc,11);
3760: l_asg_refresh_flag := 'Y';
3761: If p_person_id is not null then
3762: for bus_gp in c_bus_gp loop

Line 3916: ghr_api.return_special_information

3912: end loop;
3913:
3914:
3915: hr_utility.set_location(l_proc,40);
3916: ghr_api.return_special_information
3917: (p_person_id => l_person_id,
3918: p_structure_name => 'US Fed Perf Appraisal',
3919: p_effective_date => nvl(p_effective_date,trunc(sysdate)),
3920: p_special_info => l_perf_appraisal

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

4138: If l_exists then
4139: hr_utility.set_location(' rei exists ',1);
4140: If p_update_rei = 'Y' then
4141: hr_utility.set_location(' Update ',1);
4142: If nvl(l_dummy.rei_information3,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information3,hr_api.g_varchar2) or
4143: nvl(l_dummy.rei_information4,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information4,hr_api.g_varchar2) or
4144: nvl(l_dummy.rei_information5,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information5,hr_api.g_varchar2) or
4145: nvl(l_dummy.rei_information6,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information6,hr_api.g_varchar2) or
4146: nvl(l_dummy.rei_information7,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information7,hr_api.g_varchar2) or

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

4139: hr_utility.set_location(' rei exists ',1);
4140: If p_update_rei = 'Y' then
4141: hr_utility.set_location(' Update ',1);
4142: If nvl(l_dummy.rei_information3,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information3,hr_api.g_varchar2) or
4143: nvl(l_dummy.rei_information4,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information4,hr_api.g_varchar2) or
4144: nvl(l_dummy.rei_information5,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information5,hr_api.g_varchar2) or
4145: nvl(l_dummy.rei_information6,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information6,hr_api.g_varchar2) or
4146: nvl(l_dummy.rei_information7,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information7,hr_api.g_varchar2) or
4147: nvl(l_dummy.rei_information8,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information8,hr_api.g_varchar2) or

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

4140: If p_update_rei = 'Y' then
4141: hr_utility.set_location(' Update ',1);
4142: If nvl(l_dummy.rei_information3,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information3,hr_api.g_varchar2) or
4143: nvl(l_dummy.rei_information4,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information4,hr_api.g_varchar2) or
4144: nvl(l_dummy.rei_information5,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information5,hr_api.g_varchar2) or
4145: nvl(l_dummy.rei_information6,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information6,hr_api.g_varchar2) or
4146: nvl(l_dummy.rei_information7,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information7,hr_api.g_varchar2) or
4147: nvl(l_dummy.rei_information8,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information8,hr_api.g_varchar2) or
4148: nvl(l_dummy.rei_information9,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information9,hr_api.g_varchar2) or

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

4141: hr_utility.set_location(' Update ',1);
4142: If nvl(l_dummy.rei_information3,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information3,hr_api.g_varchar2) or
4143: nvl(l_dummy.rei_information4,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information4,hr_api.g_varchar2) or
4144: nvl(l_dummy.rei_information5,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information5,hr_api.g_varchar2) or
4145: nvl(l_dummy.rei_information6,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information6,hr_api.g_varchar2) or
4146: nvl(l_dummy.rei_information7,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information7,hr_api.g_varchar2) or
4147: nvl(l_dummy.rei_information8,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information8,hr_api.g_varchar2) or
4148: nvl(l_dummy.rei_information9,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information9,hr_api.g_varchar2) or
4149: nvl(l_dummy.rei_information10,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information10,hr_api.g_varchar2) or

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

4142: If nvl(l_dummy.rei_information3,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information3,hr_api.g_varchar2) or
4143: nvl(l_dummy.rei_information4,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information4,hr_api.g_varchar2) or
4144: nvl(l_dummy.rei_information5,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information5,hr_api.g_varchar2) or
4145: nvl(l_dummy.rei_information6,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information6,hr_api.g_varchar2) or
4146: nvl(l_dummy.rei_information7,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information7,hr_api.g_varchar2) or
4147: nvl(l_dummy.rei_information8,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information8,hr_api.g_varchar2) or
4148: nvl(l_dummy.rei_information9,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information9,hr_api.g_varchar2) or
4149: nvl(l_dummy.rei_information10,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information10,hr_api.g_varchar2) or
4150: nvl(l_dummy.rei_information11,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information11,hr_api.g_varchar2) or

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

4143: nvl(l_dummy.rei_information4,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information4,hr_api.g_varchar2) or
4144: nvl(l_dummy.rei_information5,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information5,hr_api.g_varchar2) or
4145: nvl(l_dummy.rei_information6,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information6,hr_api.g_varchar2) or
4146: nvl(l_dummy.rei_information7,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information7,hr_api.g_varchar2) or
4147: nvl(l_dummy.rei_information8,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information8,hr_api.g_varchar2) or
4148: nvl(l_dummy.rei_information9,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information9,hr_api.g_varchar2) or
4149: nvl(l_dummy.rei_information10,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information10,hr_api.g_varchar2) or
4150: nvl(l_dummy.rei_information11,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information11,hr_api.g_varchar2) or
4151: nvl(l_dummy.rei_information12,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information12,hr_api.g_varchar2) or

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

4144: nvl(l_dummy.rei_information5,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information5,hr_api.g_varchar2) or
4145: nvl(l_dummy.rei_information6,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information6,hr_api.g_varchar2) or
4146: nvl(l_dummy.rei_information7,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information7,hr_api.g_varchar2) or
4147: nvl(l_dummy.rei_information8,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information8,hr_api.g_varchar2) or
4148: nvl(l_dummy.rei_information9,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information9,hr_api.g_varchar2) or
4149: nvl(l_dummy.rei_information10,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information10,hr_api.g_varchar2) or
4150: nvl(l_dummy.rei_information11,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information11,hr_api.g_varchar2) or
4151: nvl(l_dummy.rei_information12,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information12,hr_api.g_varchar2) or
4152: nvl(l_dummy.rei_information13,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information13,hr_api.g_varchar2) or

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

4145: nvl(l_dummy.rei_information6,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information6,hr_api.g_varchar2) or
4146: nvl(l_dummy.rei_information7,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information7,hr_api.g_varchar2) or
4147: nvl(l_dummy.rei_information8,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information8,hr_api.g_varchar2) or
4148: nvl(l_dummy.rei_information9,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information9,hr_api.g_varchar2) or
4149: nvl(l_dummy.rei_information10,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information10,hr_api.g_varchar2) or
4150: nvl(l_dummy.rei_information11,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information11,hr_api.g_varchar2) or
4151: nvl(l_dummy.rei_information12,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information12,hr_api.g_varchar2) or
4152: nvl(l_dummy.rei_information13,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information13,hr_api.g_varchar2) or
4153: nvl(l_dummy.rei_information14,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information14,hr_api.g_varchar2) or

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

4146: nvl(l_dummy.rei_information7,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information7,hr_api.g_varchar2) or
4147: nvl(l_dummy.rei_information8,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information8,hr_api.g_varchar2) or
4148: nvl(l_dummy.rei_information9,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information9,hr_api.g_varchar2) or
4149: nvl(l_dummy.rei_information10,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information10,hr_api.g_varchar2) or
4150: nvl(l_dummy.rei_information11,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information11,hr_api.g_varchar2) or
4151: nvl(l_dummy.rei_information12,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information12,hr_api.g_varchar2) or
4152: nvl(l_dummy.rei_information13,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information13,hr_api.g_varchar2) or
4153: nvl(l_dummy.rei_information14,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information14,hr_api.g_varchar2) or
4154: nvl(l_dummy.rei_information15,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information15,hr_api.g_varchar2) or

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

4147: nvl(l_dummy.rei_information8,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information8,hr_api.g_varchar2) or
4148: nvl(l_dummy.rei_information9,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information9,hr_api.g_varchar2) or
4149: nvl(l_dummy.rei_information10,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information10,hr_api.g_varchar2) or
4150: nvl(l_dummy.rei_information11,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information11,hr_api.g_varchar2) or
4151: nvl(l_dummy.rei_information12,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information12,hr_api.g_varchar2) or
4152: nvl(l_dummy.rei_information13,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information13,hr_api.g_varchar2) or
4153: nvl(l_dummy.rei_information14,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information14,hr_api.g_varchar2) or
4154: nvl(l_dummy.rei_information15,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information15,hr_api.g_varchar2) or
4155: nvl(l_dummy.rei_information16,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information16,hr_api.g_varchar2) or

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

4148: nvl(l_dummy.rei_information9,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information9,hr_api.g_varchar2) or
4149: nvl(l_dummy.rei_information10,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information10,hr_api.g_varchar2) or
4150: nvl(l_dummy.rei_information11,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information11,hr_api.g_varchar2) or
4151: nvl(l_dummy.rei_information12,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information12,hr_api.g_varchar2) or
4152: nvl(l_dummy.rei_information13,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information13,hr_api.g_varchar2) or
4153: nvl(l_dummy.rei_information14,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information14,hr_api.g_varchar2) or
4154: nvl(l_dummy.rei_information15,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information15,hr_api.g_varchar2) or
4155: nvl(l_dummy.rei_information16,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information16,hr_api.g_varchar2) or
4156: nvl(l_dummy.rei_information17,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information17,hr_api.g_varchar2) or

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

4149: nvl(l_dummy.rei_information10,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information10,hr_api.g_varchar2) or
4150: nvl(l_dummy.rei_information11,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information11,hr_api.g_varchar2) or
4151: nvl(l_dummy.rei_information12,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information12,hr_api.g_varchar2) or
4152: nvl(l_dummy.rei_information13,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information13,hr_api.g_varchar2) or
4153: nvl(l_dummy.rei_information14,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information14,hr_api.g_varchar2) or
4154: nvl(l_dummy.rei_information15,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information15,hr_api.g_varchar2) or
4155: nvl(l_dummy.rei_information16,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information16,hr_api.g_varchar2) or
4156: nvl(l_dummy.rei_information17,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information17,hr_api.g_varchar2) or
4157: nvl(l_dummy.rei_information18,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information18,hr_api.g_varchar2) or

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

4150: nvl(l_dummy.rei_information11,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information11,hr_api.g_varchar2) or
4151: nvl(l_dummy.rei_information12,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information12,hr_api.g_varchar2) or
4152: nvl(l_dummy.rei_information13,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information13,hr_api.g_varchar2) or
4153: nvl(l_dummy.rei_information14,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information14,hr_api.g_varchar2) or
4154: nvl(l_dummy.rei_information15,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information15,hr_api.g_varchar2) or
4155: nvl(l_dummy.rei_information16,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information16,hr_api.g_varchar2) or
4156: nvl(l_dummy.rei_information17,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information17,hr_api.g_varchar2) or
4157: nvl(l_dummy.rei_information18,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information18,hr_api.g_varchar2) or
4158: nvl(l_dummy.rei_information19,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information19,hr_api.g_varchar2) or

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

4151: nvl(l_dummy.rei_information12,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information12,hr_api.g_varchar2) or
4152: nvl(l_dummy.rei_information13,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information13,hr_api.g_varchar2) or
4153: nvl(l_dummy.rei_information14,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information14,hr_api.g_varchar2) or
4154: nvl(l_dummy.rei_information15,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information15,hr_api.g_varchar2) or
4155: nvl(l_dummy.rei_information16,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information16,hr_api.g_varchar2) or
4156: nvl(l_dummy.rei_information17,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information17,hr_api.g_varchar2) or
4157: nvl(l_dummy.rei_information18,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information18,hr_api.g_varchar2) or
4158: nvl(l_dummy.rei_information19,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information19,hr_api.g_varchar2) or
4159: nvl(l_dummy.rei_information20,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information20,hr_api.g_varchar2) or

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

4152: nvl(l_dummy.rei_information13,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information13,hr_api.g_varchar2) or
4153: nvl(l_dummy.rei_information14,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information14,hr_api.g_varchar2) or
4154: nvl(l_dummy.rei_information15,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information15,hr_api.g_varchar2) or
4155: nvl(l_dummy.rei_information16,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information16,hr_api.g_varchar2) or
4156: nvl(l_dummy.rei_information17,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information17,hr_api.g_varchar2) or
4157: nvl(l_dummy.rei_information18,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information18,hr_api.g_varchar2) or
4158: nvl(l_dummy.rei_information19,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information19,hr_api.g_varchar2) or
4159: nvl(l_dummy.rei_information20,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information20,hr_api.g_varchar2) or
4160: nvl(l_dummy.rei_information21,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information21,hr_api.g_varchar2) or

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

4153: nvl(l_dummy.rei_information14,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information14,hr_api.g_varchar2) or
4154: nvl(l_dummy.rei_information15,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information15,hr_api.g_varchar2) or
4155: nvl(l_dummy.rei_information16,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information16,hr_api.g_varchar2) or
4156: nvl(l_dummy.rei_information17,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information17,hr_api.g_varchar2) or
4157: nvl(l_dummy.rei_information18,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information18,hr_api.g_varchar2) or
4158: nvl(l_dummy.rei_information19,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information19,hr_api.g_varchar2) or
4159: nvl(l_dummy.rei_information20,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information20,hr_api.g_varchar2) or
4160: nvl(l_dummy.rei_information21,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information21,hr_api.g_varchar2) or
4161: nvl(l_dummy.rei_information22,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information22,hr_api.g_varchar2) or

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

4154: nvl(l_dummy.rei_information15,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information15,hr_api.g_varchar2) or
4155: nvl(l_dummy.rei_information16,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information16,hr_api.g_varchar2) or
4156: nvl(l_dummy.rei_information17,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information17,hr_api.g_varchar2) or
4157: nvl(l_dummy.rei_information18,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information18,hr_api.g_varchar2) or
4158: nvl(l_dummy.rei_information19,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information19,hr_api.g_varchar2) or
4159: nvl(l_dummy.rei_information20,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information20,hr_api.g_varchar2) or
4160: nvl(l_dummy.rei_information21,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information21,hr_api.g_varchar2) or
4161: nvl(l_dummy.rei_information22,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information22,hr_api.g_varchar2) or
4162: nvl(l_dummy.rei_information23,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information23,hr_api.g_varchar2) or

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

4155: nvl(l_dummy.rei_information16,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information16,hr_api.g_varchar2) or
4156: nvl(l_dummy.rei_information17,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information17,hr_api.g_varchar2) or
4157: nvl(l_dummy.rei_information18,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information18,hr_api.g_varchar2) or
4158: nvl(l_dummy.rei_information19,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information19,hr_api.g_varchar2) or
4159: nvl(l_dummy.rei_information20,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information20,hr_api.g_varchar2) or
4160: nvl(l_dummy.rei_information21,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information21,hr_api.g_varchar2) or
4161: nvl(l_dummy.rei_information22,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information22,hr_api.g_varchar2) or
4162: nvl(l_dummy.rei_information23,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information23,hr_api.g_varchar2) or
4163: nvl(l_dummy.rei_information24,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information24,hr_api.g_varchar2) or

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

4156: nvl(l_dummy.rei_information17,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information17,hr_api.g_varchar2) or
4157: nvl(l_dummy.rei_information18,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information18,hr_api.g_varchar2) or
4158: nvl(l_dummy.rei_information19,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information19,hr_api.g_varchar2) or
4159: nvl(l_dummy.rei_information20,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information20,hr_api.g_varchar2) or
4160: nvl(l_dummy.rei_information21,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information21,hr_api.g_varchar2) or
4161: nvl(l_dummy.rei_information22,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information22,hr_api.g_varchar2) or
4162: nvl(l_dummy.rei_information23,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information23,hr_api.g_varchar2) or
4163: nvl(l_dummy.rei_information24,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information24,hr_api.g_varchar2) or
4164: nvl(l_dummy.rei_information25,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information25,hr_api.g_varchar2) or

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

4157: nvl(l_dummy.rei_information18,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information18,hr_api.g_varchar2) or
4158: nvl(l_dummy.rei_information19,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information19,hr_api.g_varchar2) or
4159: nvl(l_dummy.rei_information20,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information20,hr_api.g_varchar2) or
4160: nvl(l_dummy.rei_information21,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information21,hr_api.g_varchar2) or
4161: nvl(l_dummy.rei_information22,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information22,hr_api.g_varchar2) or
4162: nvl(l_dummy.rei_information23,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information23,hr_api.g_varchar2) or
4163: nvl(l_dummy.rei_information24,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information24,hr_api.g_varchar2) or
4164: nvl(l_dummy.rei_information25,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information25,hr_api.g_varchar2) or
4165: nvl(l_dummy.rei_information26,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information26,hr_api.g_varchar2) or

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

4158: nvl(l_dummy.rei_information19,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information19,hr_api.g_varchar2) or
4159: nvl(l_dummy.rei_information20,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information20,hr_api.g_varchar2) or
4160: nvl(l_dummy.rei_information21,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information21,hr_api.g_varchar2) or
4161: nvl(l_dummy.rei_information22,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information22,hr_api.g_varchar2) or
4162: nvl(l_dummy.rei_information23,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information23,hr_api.g_varchar2) or
4163: nvl(l_dummy.rei_information24,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information24,hr_api.g_varchar2) or
4164: nvl(l_dummy.rei_information25,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information25,hr_api.g_varchar2) or
4165: nvl(l_dummy.rei_information26,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information26,hr_api.g_varchar2) or
4166: nvl(l_dummy.rei_information27,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information27,hr_api.g_varchar2) or

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

4159: nvl(l_dummy.rei_information20,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information20,hr_api.g_varchar2) or
4160: nvl(l_dummy.rei_information21,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information21,hr_api.g_varchar2) or
4161: nvl(l_dummy.rei_information22,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information22,hr_api.g_varchar2) or
4162: nvl(l_dummy.rei_information23,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information23,hr_api.g_varchar2) or
4163: nvl(l_dummy.rei_information24,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information24,hr_api.g_varchar2) or
4164: nvl(l_dummy.rei_information25,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information25,hr_api.g_varchar2) or
4165: nvl(l_dummy.rei_information26,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information26,hr_api.g_varchar2) or
4166: nvl(l_dummy.rei_information27,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information27,hr_api.g_varchar2) or
4167: nvl(l_dummy.rei_information28,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information28,hr_api.g_varchar2) or

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

4160: nvl(l_dummy.rei_information21,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information21,hr_api.g_varchar2) or
4161: nvl(l_dummy.rei_information22,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information22,hr_api.g_varchar2) or
4162: nvl(l_dummy.rei_information23,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information23,hr_api.g_varchar2) or
4163: nvl(l_dummy.rei_information24,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information24,hr_api.g_varchar2) or
4164: nvl(l_dummy.rei_information25,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information25,hr_api.g_varchar2) or
4165: nvl(l_dummy.rei_information26,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information26,hr_api.g_varchar2) or
4166: nvl(l_dummy.rei_information27,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information27,hr_api.g_varchar2) or
4167: nvl(l_dummy.rei_information28,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information28,hr_api.g_varchar2) or
4168: nvl(l_dummy.rei_information29,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information29,hr_api.g_varchar2) or

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

4161: nvl(l_dummy.rei_information22,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information22,hr_api.g_varchar2) or
4162: nvl(l_dummy.rei_information23,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information23,hr_api.g_varchar2) or
4163: nvl(l_dummy.rei_information24,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information24,hr_api.g_varchar2) or
4164: nvl(l_dummy.rei_information25,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information25,hr_api.g_varchar2) or
4165: nvl(l_dummy.rei_information26,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information26,hr_api.g_varchar2) or
4166: nvl(l_dummy.rei_information27,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information27,hr_api.g_varchar2) or
4167: nvl(l_dummy.rei_information28,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information28,hr_api.g_varchar2) or
4168: nvl(l_dummy.rei_information29,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information29,hr_api.g_varchar2) or
4169: nvl(l_dummy.rei_information30,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information30,hr_api.g_varchar2) then

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

4162: nvl(l_dummy.rei_information23,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information23,hr_api.g_varchar2) or
4163: nvl(l_dummy.rei_information24,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information24,hr_api.g_varchar2) or
4164: nvl(l_dummy.rei_information25,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information25,hr_api.g_varchar2) or
4165: nvl(l_dummy.rei_information26,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information26,hr_api.g_varchar2) or
4166: nvl(l_dummy.rei_information27,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information27,hr_api.g_varchar2) or
4167: nvl(l_dummy.rei_information28,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information28,hr_api.g_varchar2) or
4168: nvl(l_dummy.rei_information29,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information29,hr_api.g_varchar2) or
4169: nvl(l_dummy.rei_information30,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information30,hr_api.g_varchar2) then
4170: hr_utility.set_location('operation is Update',1);

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

4163: nvl(l_dummy.rei_information24,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information24,hr_api.g_varchar2) or
4164: nvl(l_dummy.rei_information25,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information25,hr_api.g_varchar2) or
4165: nvl(l_dummy.rei_information26,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information26,hr_api.g_varchar2) or
4166: nvl(l_dummy.rei_information27,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information27,hr_api.g_varchar2) or
4167: nvl(l_dummy.rei_information28,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information28,hr_api.g_varchar2) or
4168: nvl(l_dummy.rei_information29,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information29,hr_api.g_varchar2) or
4169: nvl(l_dummy.rei_information30,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information30,hr_api.g_varchar2) then
4170: hr_utility.set_location('operation is Update',1);
4171: p_operation_flag := 'U';

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

4164: nvl(l_dummy.rei_information25,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information25,hr_api.g_varchar2) or
4165: nvl(l_dummy.rei_information26,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information26,hr_api.g_varchar2) or
4166: nvl(l_dummy.rei_information27,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information27,hr_api.g_varchar2) or
4167: nvl(l_dummy.rei_information28,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information28,hr_api.g_varchar2) or
4168: nvl(l_dummy.rei_information29,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information29,hr_api.g_varchar2) or
4169: nvl(l_dummy.rei_information30,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information30,hr_api.g_varchar2) then
4170: hr_utility.set_location('operation is Update',1);
4171: p_operation_flag := 'U';
4172: hr_utility.set_location(l_proc,25);

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

4165: nvl(l_dummy.rei_information26,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information26,hr_api.g_varchar2) or
4166: nvl(l_dummy.rei_information27,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information27,hr_api.g_varchar2) or
4167: nvl(l_dummy.rei_information28,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information28,hr_api.g_varchar2) or
4168: nvl(l_dummy.rei_information29,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information29,hr_api.g_varchar2) or
4169: nvl(l_dummy.rei_information30,hr_api.g_varchar2) <> nvl(l_rei_rec.rei_information30,hr_api.g_varchar2) then
4170: hr_utility.set_location('operation is Update',1);
4171: p_operation_flag := 'U';
4172: hr_utility.set_location(l_proc,25);
4173: End if;

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

4423: begin
4424:
4425: If p_refresh_flag = 'Y' then
4426: hr_utility.set_location('in set ei - Y ',5);
4427: If nvl(p_as_in_ddf,hr_api.g_varchar2) <> nvl(p_as_in_core,hr_api.g_varchar2) and
4428: nvl(p_as_in_ddf,hr_api.g_varchar2) = nvl(p_original,hr_api.g_varchar2) then
4429: p_as_in_ddf := p_as_in_core;
4430: End if;
4431: Else

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

4424:
4425: If p_refresh_flag = 'Y' then
4426: hr_utility.set_location('in set ei - Y ',5);
4427: If nvl(p_as_in_ddf,hr_api.g_varchar2) <> nvl(p_as_in_core,hr_api.g_varchar2) and
4428: nvl(p_as_in_ddf,hr_api.g_varchar2) = nvl(p_original,hr_api.g_varchar2) then
4429: p_as_in_ddf := p_as_in_core;
4430: End if;
4431: Else
4432: hr_utility.set_location('in set ei - N ',6);