1389: -- bug 3265814
1390: --If looks like CC not in use then dont bother to look for modified
1391: --better to have global payroll level switch, but now compare date
1392: if (l_date = hr_api.g_sot) then
1393: -- l_return_value := hr_general.decode_lookup('ACTION_STATUS',p_action_status ) ;
1394: -- Bug 3576520: Repeating the special case for the Cheque Writer.
1395: if ( p_action_type in ('M', 'H' )) then
1396: open c_is_voided( p_assignment_action_id ) ;
1397: fetch c_is_voided into l_dummy_action_id ;
1395: if ( p_action_type in ('M', 'H' )) then
1396: open c_is_voided( p_assignment_action_id ) ;
1397: fetch c_is_voided into l_dummy_action_id ;
1398: if c_is_voided%found then
1399: l_return_value := hr_general.decode_lookup('ACTION_STATUS','V');
1400: hr_utility.set_location(l_proc,50);
1401: else
1402: l_return_value := hr_general.decode_lookup('ACTION_STATUS',p_action_status ) ;
1403: hr_utility.set_location(l_proc,55);
1398: if c_is_voided%found then
1399: l_return_value := hr_general.decode_lookup('ACTION_STATUS','V');
1400: hr_utility.set_location(l_proc,50);
1401: else
1402: l_return_value := hr_general.decode_lookup('ACTION_STATUS',p_action_status ) ;
1403: hr_utility.set_location(l_proc,55);
1404: end if;
1405: close c_is_voided ;
1406: else
1403: hr_utility.set_location(l_proc,55);
1404: end if;
1405: close c_is_voided ;
1406: else
1407: l_return_value := hr_general.decode_lookup('ACTION_STATUS',p_action_status ) ;
1408: end if;
1409: --
1410: else
1411: if ( p_action_type in ('R', 'Q')) then
1420: end if;
1421: close run_modified ;
1422: --
1423: if (ischanged) then
1424: l_return_value := hr_general.decode_lookup('ACTION_STATUS','MO');
1425: hr_utility.set_location(l_proc,20);
1426: else
1427: l_return_value := hr_general.decode_lookup('ACTION_STATUS',p_action_status ) ;
1428: hr_utility.set_location(l_proc,25);
1423: if (ischanged) then
1424: l_return_value := hr_general.decode_lookup('ACTION_STATUS','MO');
1425: hr_utility.set_location(l_proc,20);
1426: else
1427: l_return_value := hr_general.decode_lookup('ACTION_STATUS',p_action_status ) ;
1428: hr_utility.set_location(l_proc,25);
1429: end if;
1430: --
1431: elsif ( p_action_type in ('P', 'U')) then
1440: end if;
1441: close prepay_modified ;
1442: --
1443: if (ischanged) then
1444: l_return_value := hr_general.decode_lookup('ACTION_STATUS','MO');
1445: hr_utility.set_location(l_proc,30);
1446: else
1447: l_return_value := hr_general.decode_lookup('ACTION_STATUS',p_action_status ) ;
1448: hr_utility.set_location(l_proc,35);
1443: if (ischanged) then
1444: l_return_value := hr_general.decode_lookup('ACTION_STATUS','MO');
1445: hr_utility.set_location(l_proc,30);
1446: else
1447: l_return_value := hr_general.decode_lookup('ACTION_STATUS',p_action_status ) ;
1448: hr_utility.set_location(l_proc,35);
1449: end if;
1450: --
1451: elsif ( p_action_type = 'C') then
1460: end if;
1461: close cost_modified ;
1462: --
1463: if (ischanged) then
1464: l_return_value := hr_general.decode_lookup('ACTION_STATUS','MO');
1465: hr_utility.set_location(l_proc,40);
1466: else
1467: l_return_value := hr_general.decode_lookup('ACTION_STATUS',p_action_status ) ;
1468: hr_utility.set_location(l_proc,45);
1463: if (ischanged) then
1464: l_return_value := hr_general.decode_lookup('ACTION_STATUS','MO');
1465: hr_utility.set_location(l_proc,40);
1466: else
1467: l_return_value := hr_general.decode_lookup('ACTION_STATUS',p_action_status ) ;
1468: hr_utility.set_location(l_proc,45);
1469: end if;
1470: --
1471: --
1472: elsif ( p_action_type = 'H' ) then
1473: open c_is_voided( p_assignment_action_id ) ;
1474: fetch c_is_voided into l_dummy_action_id ;
1475: if c_is_voided%found then
1476: l_return_value := hr_general.decode_lookup('ACTION_STATUS','V');
1477: hr_utility.set_location(l_proc,50);
1478: else
1479: l_return_value := hr_general.decode_lookup('ACTION_STATUS',p_action_status ) ;
1480: hr_utility.set_location(l_proc,55);
1475: if c_is_voided%found then
1476: l_return_value := hr_general.decode_lookup('ACTION_STATUS','V');
1477: hr_utility.set_location(l_proc,50);
1478: else
1479: l_return_value := hr_general.decode_lookup('ACTION_STATUS',p_action_status ) ;
1480: hr_utility.set_location(l_proc,55);
1481: end if;
1482: close c_is_voided ;
1483: else
1480: hr_utility.set_location(l_proc,55);
1481: end if;
1482: close c_is_voided ;
1483: else
1484: l_return_value := hr_general.decode_lookup('ACTION_STATUS',p_action_status ) ;
1485: end if;
1486: end if;
1487: hr_utility.set_location(l_proc,900);
1488: return ( l_return_value ) ;