DBA Data[Home] [Help]

APPS.PAY_CC_PROCESS_UTILS dependencies on HR_GENERAL

Line 1393: -- l_return_value := hr_general.decode_lookup('ACTION_STATUS',p_action_status ) ;

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 ;

Line 1399: l_return_value := hr_general.decode_lookup('ACTION_STATUS','V');

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

Line 1402: l_return_value := hr_general.decode_lookup('ACTION_STATUS',p_action_status ) ;

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

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

Line 1424: l_return_value := hr_general.decode_lookup('ACTION_STATUS','MO');

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

Line 1427: l_return_value := hr_general.decode_lookup('ACTION_STATUS',p_action_status ) ;

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

Line 1444: l_return_value := hr_general.decode_lookup('ACTION_STATUS','MO');

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

Line 1447: l_return_value := hr_general.decode_lookup('ACTION_STATUS',p_action_status ) ;

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

Line 1464: l_return_value := hr_general.decode_lookup('ACTION_STATUS','MO');

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

Line 1467: l_return_value := hr_general.decode_lookup('ACTION_STATUS',p_action_status ) ;

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

Line 1476: l_return_value := hr_general.decode_lookup('ACTION_STATUS','V');

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

Line 1479: l_return_value := hr_general.decode_lookup('ACTION_STATUS',p_action_status ) ;

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

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