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.PAY_US_EMPLOYEE_PAYSLIP_WEB dependencies on PAY_US_EMPLOYEE_PAYSLIP_WEB

Line 1: PACKAGE BODY pay_us_employee_payslip_web

1: PACKAGE BODY pay_us_employee_payslip_web
2: /* $Header: pyusempw.pkb 120.3.12010000.4 2008/08/06 08:29:17 ubhat ship $ */
3: /*
4: ******************************************************************
5: * *

Line 20: Name : pay_us_employee_payslip_web

16: * 500 Oracle Parkway, Redwood City, CA, 94065. *
17: * *
18: ******************************************************************
19:
20: Name : pay_us_employee_payslip_web
21:
22: Description : Package contains functions and procedures used
23: by the Online Payslip Views.
24:

Line 933: pay_us_employee_payslip_web.get_asgn_annual_hours

929: elsif p_pay_bases_name = 'HOURLY' and
930: (p_assignment_id is not null and p_period_end_date is not null) then
931:
932: ln_pay_annualization_factor :=
933: pay_us_employee_payslip_web.get_asgn_annual_hours
934: (p_assignment_id,
935: p_period_end_date);
936: end if;
937: end if;

Line 1316: l_mesg := 'pay_us_employee_payslip_web.get_doc_eit';

1312: l_org_cache varchar2(10);
1313: l_bg_cache varchar2(10);
1314:
1315: BEGIN
1316: l_mesg := 'pay_us_employee_payslip_web.get_doc_eit';
1317: hr_utility.set_location(l_mesg,5);
1318: l_location_cache := 'NOT FOUND';
1319: l_org_cache := 'NOT FOUND';
1320: l_bg_cache := 'NOT FOUND';

Line 1321: l_rowCount := pay_us_employee_payslip_web.eit_tab.count;

1317: hr_utility.set_location(l_mesg,5);
1318: l_location_cache := 'NOT FOUND';
1319: l_org_cache := 'NOT FOUND';
1320: l_bg_cache := 'NOT FOUND';
1321: l_rowCount := pay_us_employee_payslip_web.eit_tab.count;
1322:
1323: IF upper(p_level) = 'ASSIGNMENT' THEN
1324: hr_utility.set_location(l_mesg, 10);
1325: OPEN get_person_info(p_id);

Line 1404: FOR i in pay_us_employee_payslip_web.eit_tab.first ..

1400: IF upper(p_level) = 'LOCATION' THEN
1401: hr_utility.set_location(l_mesg,30);
1402: hr_utility.trace('Before LOOP l_location_cache = '||l_location_cache);
1403: IF (l_rowCount > 0) THEN
1404: FOR i in pay_us_employee_payslip_web.eit_tab.first ..
1405: pay_us_employee_payslip_web.eit_tab.last
1406: LOOP
1407: IF (pay_us_employee_payslip_web.eit_tab(i).t_id = p_id AND
1408: pay_us_employee_payslip_web.eit_tab(i).t_level = 'Location') THEN

Line 1405: pay_us_employee_payslip_web.eit_tab.last

1401: hr_utility.set_location(l_mesg,30);
1402: hr_utility.trace('Before LOOP l_location_cache = '||l_location_cache);
1403: IF (l_rowCount > 0) THEN
1404: FOR i in pay_us_employee_payslip_web.eit_tab.first ..
1405: pay_us_employee_payslip_web.eit_tab.last
1406: LOOP
1407: IF (pay_us_employee_payslip_web.eit_tab(i).t_id = p_id AND
1408: pay_us_employee_payslip_web.eit_tab(i).t_level = 'Location') THEN
1409:

Line 1407: IF (pay_us_employee_payslip_web.eit_tab(i).t_id = p_id AND

1403: IF (l_rowCount > 0) THEN
1404: FOR i in pay_us_employee_payslip_web.eit_tab.first ..
1405: pay_us_employee_payslip_web.eit_tab.last
1406: LOOP
1407: IF (pay_us_employee_payslip_web.eit_tab(i).t_id = p_id AND
1408: pay_us_employee_payslip_web.eit_tab(i).t_level = 'Location') THEN
1409:
1410: l_location_cache := 'FOUND';
1411:

Line 1408: pay_us_employee_payslip_web.eit_tab(i).t_level = 'Location') THEN

1404: FOR i in pay_us_employee_payslip_web.eit_tab.first ..
1405: pay_us_employee_payslip_web.eit_tab.last
1406: LOOP
1407: IF (pay_us_employee_payslip_web.eit_tab(i).t_id = p_id AND
1408: pay_us_employee_payslip_web.eit_tab(i).t_level = 'Location') THEN
1409:
1410: l_location_cache := 'FOUND';
1411:
1412: IF p_mode = 'ONLINE' THEN

Line 1413: l_value := pay_us_employee_payslip_web.eit_tab(i).t_online;

1409:
1410: l_location_cache := 'FOUND';
1411:
1412: IF p_mode = 'ONLINE' THEN
1413: l_value := pay_us_employee_payslip_web.eit_tab(i).t_online;
1414: ELSIF p_mode = 'PRINT' THEN
1415: l_value := pay_us_employee_payslip_web.eit_tab(i).t_print;
1416: END IF;
1417: END IF;

Line 1415: l_value := pay_us_employee_payslip_web.eit_tab(i).t_print;

1411:
1412: IF p_mode = 'ONLINE' THEN
1413: l_value := pay_us_employee_payslip_web.eit_tab(i).t_online;
1414: ELSIF p_mode = 'PRINT' THEN
1415: l_value := pay_us_employee_payslip_web.eit_tab(i).t_print;
1416: END IF;
1417: END IF;
1418: END LOOP;
1419: END IF; -- l_rowCount > 0

Line 1430: l_count := pay_us_employee_payslip_web.eit_tab.count + 1 ;

1426: OPEN get_loc_eit(p_id);
1427: FETCH get_loc_eit INTO l_online, l_print;
1428: hr_utility.trace('l_online = '||l_online);
1429: hr_utility.trace('l_print = '||l_print);
1430: l_count := pay_us_employee_payslip_web.eit_tab.count + 1 ;
1431: pay_us_employee_payslip_web.eit_tab(l_count).t_id := p_id;
1432: pay_us_employee_payslip_web.eit_tab(l_count).t_level := 'Location';
1433:
1434: IF get_loc_eit%FOUND THEN

Line 1431: pay_us_employee_payslip_web.eit_tab(l_count).t_id := p_id;

1427: FETCH get_loc_eit INTO l_online, l_print;
1428: hr_utility.trace('l_online = '||l_online);
1429: hr_utility.trace('l_print = '||l_print);
1430: l_count := pay_us_employee_payslip_web.eit_tab.count + 1 ;
1431: pay_us_employee_payslip_web.eit_tab(l_count).t_id := p_id;
1432: pay_us_employee_payslip_web.eit_tab(l_count).t_level := 'Location';
1433:
1434: IF get_loc_eit%FOUND THEN
1435: pay_us_employee_payslip_web.eit_tab(l_count).t_online := l_online;

Line 1432: pay_us_employee_payslip_web.eit_tab(l_count).t_level := 'Location';

1428: hr_utility.trace('l_online = '||l_online);
1429: hr_utility.trace('l_print = '||l_print);
1430: l_count := pay_us_employee_payslip_web.eit_tab.count + 1 ;
1431: pay_us_employee_payslip_web.eit_tab(l_count).t_id := p_id;
1432: pay_us_employee_payslip_web.eit_tab(l_count).t_level := 'Location';
1433:
1434: IF get_loc_eit%FOUND THEN
1435: pay_us_employee_payslip_web.eit_tab(l_count).t_online := l_online;
1436: pay_us_employee_payslip_web.eit_tab(l_count).t_print := l_print;

Line 1435: pay_us_employee_payslip_web.eit_tab(l_count).t_online := l_online;

1431: pay_us_employee_payslip_web.eit_tab(l_count).t_id := p_id;
1432: pay_us_employee_payslip_web.eit_tab(l_count).t_level := 'Location';
1433:
1434: IF get_loc_eit%FOUND THEN
1435: pay_us_employee_payslip_web.eit_tab(l_count).t_online := l_online;
1436: pay_us_employee_payslip_web.eit_tab(l_count).t_print := l_print;
1437: ELSE
1438: pay_us_employee_payslip_web.eit_tab(l_count).t_online := 'Y';
1439: pay_us_employee_payslip_web.eit_tab(l_count).t_print := 'Y';

Line 1436: pay_us_employee_payslip_web.eit_tab(l_count).t_print := l_print;

1432: pay_us_employee_payslip_web.eit_tab(l_count).t_level := 'Location';
1433:
1434: IF get_loc_eit%FOUND THEN
1435: pay_us_employee_payslip_web.eit_tab(l_count).t_online := l_online;
1436: pay_us_employee_payslip_web.eit_tab(l_count).t_print := l_print;
1437: ELSE
1438: pay_us_employee_payslip_web.eit_tab(l_count).t_online := 'Y';
1439: pay_us_employee_payslip_web.eit_tab(l_count).t_print := 'Y';
1440: END IF;

Line 1438: pay_us_employee_payslip_web.eit_tab(l_count).t_online := 'Y';

1434: IF get_loc_eit%FOUND THEN
1435: pay_us_employee_payslip_web.eit_tab(l_count).t_online := l_online;
1436: pay_us_employee_payslip_web.eit_tab(l_count).t_print := l_print;
1437: ELSE
1438: pay_us_employee_payslip_web.eit_tab(l_count).t_online := 'Y';
1439: pay_us_employee_payslip_web.eit_tab(l_count).t_print := 'Y';
1440: END IF;
1441:
1442: hr_utility.trace('eit_tab(l_count).t_online = '||

Line 1439: pay_us_employee_payslip_web.eit_tab(l_count).t_print := 'Y';

1435: pay_us_employee_payslip_web.eit_tab(l_count).t_online := l_online;
1436: pay_us_employee_payslip_web.eit_tab(l_count).t_print := l_print;
1437: ELSE
1438: pay_us_employee_payslip_web.eit_tab(l_count).t_online := 'Y';
1439: pay_us_employee_payslip_web.eit_tab(l_count).t_print := 'Y';
1440: END IF;
1441:
1442: hr_utility.trace('eit_tab(l_count).t_online = '||
1443: pay_us_employee_payslip_web.eit_tab(l_count).t_online);

Line 1443: pay_us_employee_payslip_web.eit_tab(l_count).t_online);

1439: pay_us_employee_payslip_web.eit_tab(l_count).t_print := 'Y';
1440: END IF;
1441:
1442: hr_utility.trace('eit_tab(l_count).t_online = '||
1443: pay_us_employee_payslip_web.eit_tab(l_count).t_online);
1444: hr_utility.trace('eit_tab(l_count).t_print = '||
1445: pay_us_employee_payslip_web.eit_tab(l_count).t_print);
1446: IF p_mode = 'ONLINE' THEN
1447: l_value := pay_us_employee_payslip_web.eit_tab(l_count).t_online;

Line 1445: pay_us_employee_payslip_web.eit_tab(l_count).t_print);

1441:
1442: hr_utility.trace('eit_tab(l_count).t_online = '||
1443: pay_us_employee_payslip_web.eit_tab(l_count).t_online);
1444: hr_utility.trace('eit_tab(l_count).t_print = '||
1445: pay_us_employee_payslip_web.eit_tab(l_count).t_print);
1446: IF p_mode = 'ONLINE' THEN
1447: l_value := pay_us_employee_payslip_web.eit_tab(l_count).t_online;
1448: ELSIF p_mode = 'PRINT' THEN
1449: l_value := pay_us_employee_payslip_web.eit_tab(l_count).t_print;

Line 1447: l_value := pay_us_employee_payslip_web.eit_tab(l_count).t_online;

1443: pay_us_employee_payslip_web.eit_tab(l_count).t_online);
1444: hr_utility.trace('eit_tab(l_count).t_print = '||
1445: pay_us_employee_payslip_web.eit_tab(l_count).t_print);
1446: IF p_mode = 'ONLINE' THEN
1447: l_value := pay_us_employee_payslip_web.eit_tab(l_count).t_online;
1448: ELSIF p_mode = 'PRINT' THEN
1449: l_value := pay_us_employee_payslip_web.eit_tab(l_count).t_print;
1450: END IF;
1451: CLOSE get_loc_eit;

Line 1449: l_value := pay_us_employee_payslip_web.eit_tab(l_count).t_print;

1445: pay_us_employee_payslip_web.eit_tab(l_count).t_print);
1446: IF p_mode = 'ONLINE' THEN
1447: l_value := pay_us_employee_payslip_web.eit_tab(l_count).t_online;
1448: ELSIF p_mode = 'PRINT' THEN
1449: l_value := pay_us_employee_payslip_web.eit_tab(l_count).t_print;
1450: END IF;
1451: CLOSE get_loc_eit;
1452: END IF;
1453: return l_value;

Line 1459: FOR i in pay_us_employee_payslip_web.eit_tab.first ..

1455:
1456: IF upper(p_level) = 'ORGANIZATION' THEN
1457: hr_utility.set_location(l_mesg,50);
1458: IF (l_rowCount > 0) THEN
1459: FOR i in pay_us_employee_payslip_web.eit_tab.first ..
1460: pay_us_employee_payslip_web.eit_tab.last
1461: LOOP
1462: IF (pay_us_employee_payslip_web.eit_tab(i).t_id = p_id AND
1463: pay_us_employee_payslip_web.eit_tab(i).t_level

Line 1460: pay_us_employee_payslip_web.eit_tab.last

1456: IF upper(p_level) = 'ORGANIZATION' THEN
1457: hr_utility.set_location(l_mesg,50);
1458: IF (l_rowCount > 0) THEN
1459: FOR i in pay_us_employee_payslip_web.eit_tab.first ..
1460: pay_us_employee_payslip_web.eit_tab.last
1461: LOOP
1462: IF (pay_us_employee_payslip_web.eit_tab(i).t_id = p_id AND
1463: pay_us_employee_payslip_web.eit_tab(i).t_level
1464: = 'Organization') THEN

Line 1462: IF (pay_us_employee_payslip_web.eit_tab(i).t_id = p_id AND

1458: IF (l_rowCount > 0) THEN
1459: FOR i in pay_us_employee_payslip_web.eit_tab.first ..
1460: pay_us_employee_payslip_web.eit_tab.last
1461: LOOP
1462: IF (pay_us_employee_payslip_web.eit_tab(i).t_id = p_id AND
1463: pay_us_employee_payslip_web.eit_tab(i).t_level
1464: = 'Organization') THEN
1465: l_org_cache := 'FOUND';
1466: IF p_mode = 'ONLINE' THEN

Line 1463: pay_us_employee_payslip_web.eit_tab(i).t_level

1459: FOR i in pay_us_employee_payslip_web.eit_tab.first ..
1460: pay_us_employee_payslip_web.eit_tab.last
1461: LOOP
1462: IF (pay_us_employee_payslip_web.eit_tab(i).t_id = p_id AND
1463: pay_us_employee_payslip_web.eit_tab(i).t_level
1464: = 'Organization') THEN
1465: l_org_cache := 'FOUND';
1466: IF p_mode = 'ONLINE' THEN
1467: l_value := pay_us_employee_payslip_web.eit_tab(i).t_online;

Line 1467: l_value := pay_us_employee_payslip_web.eit_tab(i).t_online;

1463: pay_us_employee_payslip_web.eit_tab(i).t_level
1464: = 'Organization') THEN
1465: l_org_cache := 'FOUND';
1466: IF p_mode = 'ONLINE' THEN
1467: l_value := pay_us_employee_payslip_web.eit_tab(i).t_online;
1468: ELSIF p_mode = 'PRINT' THEN
1469: l_value := pay_us_employee_payslip_web.eit_tab(i).t_print;
1470: END IF;
1471: END IF;

Line 1469: l_value := pay_us_employee_payslip_web.eit_tab(i).t_print;

1465: l_org_cache := 'FOUND';
1466: IF p_mode = 'ONLINE' THEN
1467: l_value := pay_us_employee_payslip_web.eit_tab(i).t_online;
1468: ELSIF p_mode = 'PRINT' THEN
1469: l_value := pay_us_employee_payslip_web.eit_tab(i).t_print;
1470: END IF;
1471: END IF;
1472: END LOOP;
1473: END IF;

Line 1482: l_count := pay_us_employee_payslip_web.eit_tab.count + 1 ;

1478: hr_utility.trace('Org cache NOT FOUND');
1479: hr_utility.set_location(l_mesg,60);
1480: OPEN get_org_eit(p_id);
1481: FETCH get_org_eit INTO l_online, l_print;
1482: l_count := pay_us_employee_payslip_web.eit_tab.count + 1 ;
1483: pay_us_employee_payslip_web.eit_tab(l_count).t_id := p_id;
1484: pay_us_employee_payslip_web.eit_tab(l_count).t_level := 'Organization';
1485:
1486: IF get_org_eit%FOUND THEN

Line 1483: pay_us_employee_payslip_web.eit_tab(l_count).t_id := p_id;

1479: hr_utility.set_location(l_mesg,60);
1480: OPEN get_org_eit(p_id);
1481: FETCH get_org_eit INTO l_online, l_print;
1482: l_count := pay_us_employee_payslip_web.eit_tab.count + 1 ;
1483: pay_us_employee_payslip_web.eit_tab(l_count).t_id := p_id;
1484: pay_us_employee_payslip_web.eit_tab(l_count).t_level := 'Organization';
1485:
1486: IF get_org_eit%FOUND THEN
1487: pay_us_employee_payslip_web.eit_tab(l_count).t_online := l_online;

Line 1484: pay_us_employee_payslip_web.eit_tab(l_count).t_level := 'Organization';

1480: OPEN get_org_eit(p_id);
1481: FETCH get_org_eit INTO l_online, l_print;
1482: l_count := pay_us_employee_payslip_web.eit_tab.count + 1 ;
1483: pay_us_employee_payslip_web.eit_tab(l_count).t_id := p_id;
1484: pay_us_employee_payslip_web.eit_tab(l_count).t_level := 'Organization';
1485:
1486: IF get_org_eit%FOUND THEN
1487: pay_us_employee_payslip_web.eit_tab(l_count).t_online := l_online;
1488: pay_us_employee_payslip_web.eit_tab(l_count).t_print := l_print;

Line 1487: pay_us_employee_payslip_web.eit_tab(l_count).t_online := l_online;

1483: pay_us_employee_payslip_web.eit_tab(l_count).t_id := p_id;
1484: pay_us_employee_payslip_web.eit_tab(l_count).t_level := 'Organization';
1485:
1486: IF get_org_eit%FOUND THEN
1487: pay_us_employee_payslip_web.eit_tab(l_count).t_online := l_online;
1488: pay_us_employee_payslip_web.eit_tab(l_count).t_print := l_print;
1489: ELSE
1490: pay_us_employee_payslip_web.eit_tab(l_count).t_online := 'Y';
1491: pay_us_employee_payslip_web.eit_tab(l_count).t_print := 'Y';

Line 1488: pay_us_employee_payslip_web.eit_tab(l_count).t_print := l_print;

1484: pay_us_employee_payslip_web.eit_tab(l_count).t_level := 'Organization';
1485:
1486: IF get_org_eit%FOUND THEN
1487: pay_us_employee_payslip_web.eit_tab(l_count).t_online := l_online;
1488: pay_us_employee_payslip_web.eit_tab(l_count).t_print := l_print;
1489: ELSE
1490: pay_us_employee_payslip_web.eit_tab(l_count).t_online := 'Y';
1491: pay_us_employee_payslip_web.eit_tab(l_count).t_print := 'Y';
1492: END IF;

Line 1490: pay_us_employee_payslip_web.eit_tab(l_count).t_online := 'Y';

1486: IF get_org_eit%FOUND THEN
1487: pay_us_employee_payslip_web.eit_tab(l_count).t_online := l_online;
1488: pay_us_employee_payslip_web.eit_tab(l_count).t_print := l_print;
1489: ELSE
1490: pay_us_employee_payslip_web.eit_tab(l_count).t_online := 'Y';
1491: pay_us_employee_payslip_web.eit_tab(l_count).t_print := 'Y';
1492: END IF;
1493:
1494: IF p_mode = 'PRINT' THEN

Line 1491: pay_us_employee_payslip_web.eit_tab(l_count).t_print := 'Y';

1487: pay_us_employee_payslip_web.eit_tab(l_count).t_online := l_online;
1488: pay_us_employee_payslip_web.eit_tab(l_count).t_print := l_print;
1489: ELSE
1490: pay_us_employee_payslip_web.eit_tab(l_count).t_online := 'Y';
1491: pay_us_employee_payslip_web.eit_tab(l_count).t_print := 'Y';
1492: END IF;
1493:
1494: IF p_mode = 'PRINT' THEN
1495: l_value := pay_us_employee_payslip_web.eit_tab(l_count).t_print;

Line 1495: l_value := pay_us_employee_payslip_web.eit_tab(l_count).t_print;

1491: pay_us_employee_payslip_web.eit_tab(l_count).t_print := 'Y';
1492: END IF;
1493:
1494: IF p_mode = 'PRINT' THEN
1495: l_value := pay_us_employee_payslip_web.eit_tab(l_count).t_print;
1496: ELSIF p_mode = 'ONLINE' THEN
1497: l_value := pay_us_employee_payslip_web.eit_tab(l_count).t_online;
1498: END IF;
1499: CLOSE get_org_eit;

Line 1497: l_value := pay_us_employee_payslip_web.eit_tab(l_count).t_online;

1493:
1494: IF p_mode = 'PRINT' THEN
1495: l_value := pay_us_employee_payslip_web.eit_tab(l_count).t_print;
1496: ELSIF p_mode = 'ONLINE' THEN
1497: l_value := pay_us_employee_payslip_web.eit_tab(l_count).t_online;
1498: END IF;
1499: CLOSE get_org_eit;
1500: END IF;
1501: return l_value;

Line 1509: FOR i in pay_us_employee_payslip_web.eit_tab.first ..

1505:
1506: IF upper(p_level) = 'BUSINESS GROUP' THEN
1507: hr_utility.set_location(l_mesg,70);
1508: IF (l_rowCount > 0) THEN
1509: FOR i in pay_us_employee_payslip_web.eit_tab.first ..
1510: pay_us_employee_payslip_web.eit_tab.last LOOP
1511: IF (pay_us_employee_payslip_web.eit_tab(i).t_id = p_id AND
1512: pay_us_employee_payslip_web.eit_tab(i).t_level = 'Business Group')
1513: THEN

Line 1510: pay_us_employee_payslip_web.eit_tab.last LOOP

1506: IF upper(p_level) = 'BUSINESS GROUP' THEN
1507: hr_utility.set_location(l_mesg,70);
1508: IF (l_rowCount > 0) THEN
1509: FOR i in pay_us_employee_payslip_web.eit_tab.first ..
1510: pay_us_employee_payslip_web.eit_tab.last LOOP
1511: IF (pay_us_employee_payslip_web.eit_tab(i).t_id = p_id AND
1512: pay_us_employee_payslip_web.eit_tab(i).t_level = 'Business Group')
1513: THEN
1514: l_bg_cache := 'FOUND';

Line 1511: IF (pay_us_employee_payslip_web.eit_tab(i).t_id = p_id AND

1507: hr_utility.set_location(l_mesg,70);
1508: IF (l_rowCount > 0) THEN
1509: FOR i in pay_us_employee_payslip_web.eit_tab.first ..
1510: pay_us_employee_payslip_web.eit_tab.last LOOP
1511: IF (pay_us_employee_payslip_web.eit_tab(i).t_id = p_id AND
1512: pay_us_employee_payslip_web.eit_tab(i).t_level = 'Business Group')
1513: THEN
1514: l_bg_cache := 'FOUND';
1515: IF p_mode = 'ONLINE' THEN

Line 1512: pay_us_employee_payslip_web.eit_tab(i).t_level = 'Business Group')

1508: IF (l_rowCount > 0) THEN
1509: FOR i in pay_us_employee_payslip_web.eit_tab.first ..
1510: pay_us_employee_payslip_web.eit_tab.last LOOP
1511: IF (pay_us_employee_payslip_web.eit_tab(i).t_id = p_id AND
1512: pay_us_employee_payslip_web.eit_tab(i).t_level = 'Business Group')
1513: THEN
1514: l_bg_cache := 'FOUND';
1515: IF p_mode = 'ONLINE' THEN
1516: l_value := pay_us_employee_payslip_web.eit_tab(i).t_online;

Line 1516: l_value := pay_us_employee_payslip_web.eit_tab(i).t_online;

1512: pay_us_employee_payslip_web.eit_tab(i).t_level = 'Business Group')
1513: THEN
1514: l_bg_cache := 'FOUND';
1515: IF p_mode = 'ONLINE' THEN
1516: l_value := pay_us_employee_payslip_web.eit_tab(i).t_online;
1517: ELSIF p_mode = 'PRINT' THEN
1518: l_value := pay_us_employee_payslip_web.eit_tab(i).t_print;
1519: END IF;
1520: END IF;

Line 1518: l_value := pay_us_employee_payslip_web.eit_tab(i).t_print;

1514: l_bg_cache := 'FOUND';
1515: IF p_mode = 'ONLINE' THEN
1516: l_value := pay_us_employee_payslip_web.eit_tab(i).t_online;
1517: ELSIF p_mode = 'PRINT' THEN
1518: l_value := pay_us_employee_payslip_web.eit_tab(i).t_print;
1519: END IF;
1520: END IF;
1521: END LOOP;
1522: END IF;

Line 1531: l_count := pay_us_employee_payslip_web.eit_tab.count + 1;

1527: hr_utility.set_location(l_mesg,80);
1528:
1529: OPEN get_bg_eit(p_id);
1530: FETCH get_bg_eit INTO l_online, l_print;
1531: l_count := pay_us_employee_payslip_web.eit_tab.count + 1;
1532: pay_us_employee_payslip_web.eit_tab(l_count).t_id := p_id;
1533: pay_us_employee_payslip_web.eit_tab(l_count).t_level := 'Business Group';
1534:
1535: IF get_bg_eit%FOUND THEN

Line 1532: pay_us_employee_payslip_web.eit_tab(l_count).t_id := p_id;

1528:
1529: OPEN get_bg_eit(p_id);
1530: FETCH get_bg_eit INTO l_online, l_print;
1531: l_count := pay_us_employee_payslip_web.eit_tab.count + 1;
1532: pay_us_employee_payslip_web.eit_tab(l_count).t_id := p_id;
1533: pay_us_employee_payslip_web.eit_tab(l_count).t_level := 'Business Group';
1534:
1535: IF get_bg_eit%FOUND THEN
1536: pay_us_employee_payslip_web.eit_tab(l_count).t_online := l_online;

Line 1533: pay_us_employee_payslip_web.eit_tab(l_count).t_level := 'Business Group';

1529: OPEN get_bg_eit(p_id);
1530: FETCH get_bg_eit INTO l_online, l_print;
1531: l_count := pay_us_employee_payslip_web.eit_tab.count + 1;
1532: pay_us_employee_payslip_web.eit_tab(l_count).t_id := p_id;
1533: pay_us_employee_payslip_web.eit_tab(l_count).t_level := 'Business Group';
1534:
1535: IF get_bg_eit%FOUND THEN
1536: pay_us_employee_payslip_web.eit_tab(l_count).t_online := l_online;
1537: pay_us_employee_payslip_web.eit_tab(l_count).t_print := l_print;

Line 1536: pay_us_employee_payslip_web.eit_tab(l_count).t_online := l_online;

1532: pay_us_employee_payslip_web.eit_tab(l_count).t_id := p_id;
1533: pay_us_employee_payslip_web.eit_tab(l_count).t_level := 'Business Group';
1534:
1535: IF get_bg_eit%FOUND THEN
1536: pay_us_employee_payslip_web.eit_tab(l_count).t_online := l_online;
1537: pay_us_employee_payslip_web.eit_tab(l_count).t_print := l_print;
1538: ELSE
1539: pay_us_employee_payslip_web.eit_tab(l_count).t_online := 'Y';
1540: pay_us_employee_payslip_web.eit_tab(l_count).t_print := 'Y';

Line 1537: pay_us_employee_payslip_web.eit_tab(l_count).t_print := l_print;

1533: pay_us_employee_payslip_web.eit_tab(l_count).t_level := 'Business Group';
1534:
1535: IF get_bg_eit%FOUND THEN
1536: pay_us_employee_payslip_web.eit_tab(l_count).t_online := l_online;
1537: pay_us_employee_payslip_web.eit_tab(l_count).t_print := l_print;
1538: ELSE
1539: pay_us_employee_payslip_web.eit_tab(l_count).t_online := 'Y';
1540: pay_us_employee_payslip_web.eit_tab(l_count).t_print := 'Y';
1541: END IF;

Line 1539: pay_us_employee_payslip_web.eit_tab(l_count).t_online := 'Y';

1535: IF get_bg_eit%FOUND THEN
1536: pay_us_employee_payslip_web.eit_tab(l_count).t_online := l_online;
1537: pay_us_employee_payslip_web.eit_tab(l_count).t_print := l_print;
1538: ELSE
1539: pay_us_employee_payslip_web.eit_tab(l_count).t_online := 'Y';
1540: pay_us_employee_payslip_web.eit_tab(l_count).t_print := 'Y';
1541: END IF;
1542:
1543: IF p_mode = 'ONLINE' THEN

Line 1540: pay_us_employee_payslip_web.eit_tab(l_count).t_print := 'Y';

1536: pay_us_employee_payslip_web.eit_tab(l_count).t_online := l_online;
1537: pay_us_employee_payslip_web.eit_tab(l_count).t_print := l_print;
1538: ELSE
1539: pay_us_employee_payslip_web.eit_tab(l_count).t_online := 'Y';
1540: pay_us_employee_payslip_web.eit_tab(l_count).t_print := 'Y';
1541: END IF;
1542:
1543: IF p_mode = 'ONLINE' THEN
1544: l_value := pay_us_employee_payslip_web.eit_tab(l_count).t_online;

Line 1544: l_value := pay_us_employee_payslip_web.eit_tab(l_count).t_online;

1540: pay_us_employee_payslip_web.eit_tab(l_count).t_print := 'Y';
1541: END IF;
1542:
1543: IF p_mode = 'ONLINE' THEN
1544: l_value := pay_us_employee_payslip_web.eit_tab(l_count).t_online;
1545: ELSIF p_mode = 'PRINT' THEN
1546: l_value := pay_us_employee_payslip_web.eit_tab(l_count).t_print;
1547: END IF;
1548:

Line 1546: l_value := pay_us_employee_payslip_web.eit_tab(l_count).t_print;

1542:
1543: IF p_mode = 'ONLINE' THEN
1544: l_value := pay_us_employee_payslip_web.eit_tab(l_count).t_online;
1545: ELSIF p_mode = 'PRINT' THEN
1546: l_value := pay_us_employee_payslip_web.eit_tab(l_count).t_print;
1547: END IF;
1548:
1549: CLOSE get_bg_eit;
1550: END IF; -- bg_cache not found

Line 1633: := pay_us_employee_payslip_web.get_school_dsts_name(p_jurisdiction_code);

1629: close c_get_city;
1630: elsif p_jurisdiction_code like '__-_____' then
1631: -- this is school district make a function call
1632: lv_jurisdiction_name
1633: := pay_us_employee_payslip_web.get_school_dsts_name(p_jurisdiction_code);
1634: end if;
1635:
1636: hr_utility.set_location(gv_package || lv_procedure_name, 30);
1637: return (lv_jurisdiction_name);

Line 1830: lv_jurisdiction_name := pay_us_employee_payslip_web.get_jurisdiction_name

1826: lv_jurisdiction_name := null;
1827:
1828: hr_utility.set_location(gv_package || lv_procedure_name, 10);
1829: if p_jurisdiction_code like '__-000-0000' then
1830: lv_jurisdiction_name := pay_us_employee_payslip_web.get_jurisdiction_name
1831: (lv_state_code || '-000-0000');
1832:
1833: elsif p_jurisdiction_code like '__-___-0000' then
1834: lv_state_abbrev := pay_us_employee_payslip_web.get_jurisdiction_name

Line 1834: lv_state_abbrev := pay_us_employee_payslip_web.get_jurisdiction_name

1830: lv_jurisdiction_name := pay_us_employee_payslip_web.get_jurisdiction_name
1831: (lv_state_code || '-000-0000');
1832:
1833: elsif p_jurisdiction_code like '__-___-0000' then
1834: lv_state_abbrev := pay_us_employee_payslip_web.get_jurisdiction_name
1835: (lv_state_code || '-000-0000');
1836: lv_county_name := pay_us_employee_payslip_web.get_jurisdiction_name
1837: (p_jurisdiction_code);
1838:

Line 1836: lv_county_name := pay_us_employee_payslip_web.get_jurisdiction_name

1832:
1833: elsif p_jurisdiction_code like '__-___-0000' then
1834: lv_state_abbrev := pay_us_employee_payslip_web.get_jurisdiction_name
1835: (lv_state_code || '-000-0000');
1836: lv_county_name := pay_us_employee_payslip_web.get_jurisdiction_name
1837: (p_jurisdiction_code);
1838:
1839: lv_jurisdiction_name := lv_state_abbrev ||', '||lv_county_name;
1840:

Line 1842: lv_state_abbrev := pay_us_employee_payslip_web.get_jurisdiction_name

1838:
1839: lv_jurisdiction_name := lv_state_abbrev ||', '||lv_county_name;
1840:
1841: elsif p_jurisdiction_code like '__-___-____' then
1842: lv_state_abbrev := pay_us_employee_payslip_web.get_jurisdiction_name
1843: (lv_state_code || '-000-0000');
1844:
1845: lv_county_name := pay_us_employee_payslip_web.get_jurisdiction_name
1846: (lv_state_code || '-' || lv_county_code || '-0000');

Line 1845: lv_county_name := pay_us_employee_payslip_web.get_jurisdiction_name

1841: elsif p_jurisdiction_code like '__-___-____' then
1842: lv_state_abbrev := pay_us_employee_payslip_web.get_jurisdiction_name
1843: (lv_state_code || '-000-0000');
1844:
1845: lv_county_name := pay_us_employee_payslip_web.get_jurisdiction_name
1846: (lv_state_code || '-' || lv_county_code || '-0000');
1847: lv_city_name := pay_us_employee_payslip_web.get_jurisdiction_name
1848: (p_jurisdiction_code);
1849:

Line 1847: lv_city_name := pay_us_employee_payslip_web.get_jurisdiction_name

1843: (lv_state_code || '-000-0000');
1844:
1845: lv_county_name := pay_us_employee_payslip_web.get_jurisdiction_name
1846: (lv_state_code || '-' || lv_county_code || '-0000');
1847: lv_city_name := pay_us_employee_payslip_web.get_jurisdiction_name
1848: (p_jurisdiction_code);
1849:
1850: hr_utility.set_location('p_jurisdiction_code -> '||p_jurisdiction_code, 30);
1851: hr_utility.set_location('lv_state_abbrev -> '|| lv_state_abbrev, 30);

Line 1859: lv_state_abbrev := pay_us_employee_payslip_web.get_jurisdiction_name

1855: lv_jurisdiction_name := lv_state_abbrev ||', '||
1856: lv_county_name ||', '||
1857: lv_city_name;
1858: elsif length(p_jurisdiction_code) = 8 then
1859: lv_state_abbrev := pay_us_employee_payslip_web.get_jurisdiction_name
1860: (lv_state_code || '-000-0000');
1861: lv_school_dst := pay_us_employee_payslip_web.get_jurisdiction_name
1862: (p_jurisdiction_code);
1863: lv_jurisdiction_name := lv_state_abbrev || ', ' ||

Line 1861: lv_school_dst := pay_us_employee_payslip_web.get_jurisdiction_name

1857: lv_city_name;
1858: elsif length(p_jurisdiction_code) = 8 then
1859: lv_state_abbrev := pay_us_employee_payslip_web.get_jurisdiction_name
1860: (lv_state_code || '-000-0000');
1861: lv_school_dst := pay_us_employee_payslip_web.get_jurisdiction_name
1862: (p_jurisdiction_code);
1863: lv_jurisdiction_name := lv_state_abbrev || ', ' ||
1864: lv_school_dst;
1865:

Line 1901: hr_utility.trace('Entering into pay_us_employee_payslip_web.get_netpaydistr_segment');

1897: lv_legislation_code VARCHAR2(100);
1898: lv_exists VARCHAR2(10);
1899:
1900: BEGIN
1901: hr_utility.trace('Entering into pay_us_employee_payslip_web.get_netpaydistr_segment');
1902: hr_utility.trace('p_business_grp_id := ' || p_business_grp_id);
1903: hr_utility.trace('p_org_pay_meth_id := ' || p_org_pay_meth_id);
1904:
1905: open cur_legislation(p_business_grp_id);

Line 1938: gv_package := 'pay_us_employee_payslip_web';

1934: END get_netpaydistr_segment;
1935:
1936:
1937: BEGIN
1938: gv_package := 'pay_us_employee_payslip_web';
1939: -- hr_utility.trace_on(null, 'PAYSLIP');
1940: END pay_us_employee_payslip_web;

Line 1940: END pay_us_employee_payslip_web;

1936:
1937: BEGIN
1938: gv_package := 'pay_us_employee_payslip_web';
1939: -- hr_utility.trace_on(null, 'PAYSLIP');
1940: END pay_us_employee_payslip_web;