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.41.12020000.3 2012/11/28 07:01:12 pkoduri 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 1521: pay_us_employee_payslip_web.get_asgn_annual_hours

1517: elsif p_pay_bases_name = 'HOURLY' and
1518: (p_assignment_id is not null and p_period_end_date is not null) then
1519:
1520: ln_pay_annualization_factor :=
1521: pay_us_employee_payslip_web.get_asgn_annual_hours
1522: (p_assignment_id,
1523: p_period_end_date);
1524: end if;
1525: end if;

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

1913: l_term_diff number ; --Bug# 14682114
1914: l_time_period_id number; --Bug# 14682114
1915:
1916: BEGIN
1917: l_mesg := 'pay_us_employee_payslip_web.get_doc_eit';
1918: hr_utility.set_location(l_mesg,5);
1919: l_location_cache := 'NOT FOUND';
1920: l_org_cache := 'NOT FOUND';
1921: l_bg_cache := 'NOT FOUND';

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

1918: hr_utility.set_location(l_mesg,5);
1919: l_location_cache := 'NOT FOUND';
1920: l_org_cache := 'NOT FOUND';
1921: l_bg_cache := 'NOT FOUND';
1922: l_rowCount := pay_us_employee_payslip_web.eit_tab.count;
1923:
1924: IF upper(p_level) = 'ASSIGNMENT' THEN
1925: hr_utility.set_location(l_mesg, 10);
1926:

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

2046: IF upper(p_level) = 'LOCATION' THEN
2047: hr_utility.set_location(l_mesg,30);
2048: hr_utility.trace('Before LOOP l_location_cache = '||l_location_cache);
2049: IF (l_rowCount > 0) THEN
2050: FOR i in pay_us_employee_payslip_web.eit_tab.first ..
2051: pay_us_employee_payslip_web.eit_tab.last
2052: LOOP
2053: IF (pay_us_employee_payslip_web.eit_tab(i).t_id = p_id AND
2054: pay_us_employee_payslip_web.eit_tab(i).t_level = 'Location') THEN

Line 2051: pay_us_employee_payslip_web.eit_tab.last

2047: hr_utility.set_location(l_mesg,30);
2048: hr_utility.trace('Before LOOP l_location_cache = '||l_location_cache);
2049: IF (l_rowCount > 0) THEN
2050: FOR i in pay_us_employee_payslip_web.eit_tab.first ..
2051: pay_us_employee_payslip_web.eit_tab.last
2052: LOOP
2053: IF (pay_us_employee_payslip_web.eit_tab(i).t_id = p_id AND
2054: pay_us_employee_payslip_web.eit_tab(i).t_level = 'Location') THEN
2055:

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

2049: IF (l_rowCount > 0) THEN
2050: FOR i in pay_us_employee_payslip_web.eit_tab.first ..
2051: pay_us_employee_payslip_web.eit_tab.last
2052: LOOP
2053: IF (pay_us_employee_payslip_web.eit_tab(i).t_id = p_id AND
2054: pay_us_employee_payslip_web.eit_tab(i).t_level = 'Location') THEN
2055:
2056: l_location_cache := 'FOUND';
2057:

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

2050: FOR i in pay_us_employee_payslip_web.eit_tab.first ..
2051: pay_us_employee_payslip_web.eit_tab.last
2052: LOOP
2053: IF (pay_us_employee_payslip_web.eit_tab(i).t_id = p_id AND
2054: pay_us_employee_payslip_web.eit_tab(i).t_level = 'Location') THEN
2055:
2056: l_location_cache := 'FOUND';
2057:
2058: IF p_mode = 'ONLINE' THEN

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

2055:
2056: l_location_cache := 'FOUND';
2057:
2058: IF p_mode = 'ONLINE' THEN
2059: l_value := pay_us_employee_payslip_web.eit_tab(i).t_online;
2060: ELSIF p_mode = 'PRINT' THEN
2061: l_value := pay_us_employee_payslip_web.eit_tab(i).t_print;
2062: END IF;
2063: END IF;

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

2057:
2058: IF p_mode = 'ONLINE' THEN
2059: l_value := pay_us_employee_payslip_web.eit_tab(i).t_online;
2060: ELSIF p_mode = 'PRINT' THEN
2061: l_value := pay_us_employee_payslip_web.eit_tab(i).t_print;
2062: END IF;
2063: END IF;
2064: END LOOP;
2065: END IF; -- l_rowCount > 0

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

2072: OPEN get_loc_eit(p_id);
2073: FETCH get_loc_eit INTO l_online, l_print;
2074: hr_utility.trace('l_online = '||l_online);
2075: hr_utility.trace('l_print = '||l_print);
2076: l_count := pay_us_employee_payslip_web.eit_tab.count + 1 ;
2077: pay_us_employee_payslip_web.eit_tab(l_count).t_id := p_id;
2078: pay_us_employee_payslip_web.eit_tab(l_count).t_level := 'Location';
2079:
2080: IF get_loc_eit%FOUND THEN

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

2073: FETCH get_loc_eit INTO l_online, l_print;
2074: hr_utility.trace('l_online = '||l_online);
2075: hr_utility.trace('l_print = '||l_print);
2076: l_count := pay_us_employee_payslip_web.eit_tab.count + 1 ;
2077: pay_us_employee_payslip_web.eit_tab(l_count).t_id := p_id;
2078: pay_us_employee_payslip_web.eit_tab(l_count).t_level := 'Location';
2079:
2080: IF get_loc_eit%FOUND THEN
2081: pay_us_employee_payslip_web.eit_tab(l_count).t_online := l_online;

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

2074: hr_utility.trace('l_online = '||l_online);
2075: hr_utility.trace('l_print = '||l_print);
2076: l_count := pay_us_employee_payslip_web.eit_tab.count + 1 ;
2077: pay_us_employee_payslip_web.eit_tab(l_count).t_id := p_id;
2078: pay_us_employee_payslip_web.eit_tab(l_count).t_level := 'Location';
2079:
2080: IF get_loc_eit%FOUND THEN
2081: pay_us_employee_payslip_web.eit_tab(l_count).t_online := l_online;
2082: pay_us_employee_payslip_web.eit_tab(l_count).t_print := l_print;

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

2077: pay_us_employee_payslip_web.eit_tab(l_count).t_id := p_id;
2078: pay_us_employee_payslip_web.eit_tab(l_count).t_level := 'Location';
2079:
2080: IF get_loc_eit%FOUND THEN
2081: pay_us_employee_payslip_web.eit_tab(l_count).t_online := l_online;
2082: pay_us_employee_payslip_web.eit_tab(l_count).t_print := l_print;
2083: ELSE
2084: pay_us_employee_payslip_web.eit_tab(l_count).t_online := 'Y';
2085: pay_us_employee_payslip_web.eit_tab(l_count).t_print := 'Y';

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

2078: pay_us_employee_payslip_web.eit_tab(l_count).t_level := 'Location';
2079:
2080: IF get_loc_eit%FOUND THEN
2081: pay_us_employee_payslip_web.eit_tab(l_count).t_online := l_online;
2082: pay_us_employee_payslip_web.eit_tab(l_count).t_print := l_print;
2083: ELSE
2084: pay_us_employee_payslip_web.eit_tab(l_count).t_online := 'Y';
2085: pay_us_employee_payslip_web.eit_tab(l_count).t_print := 'Y';
2086: END IF;

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

2080: IF get_loc_eit%FOUND THEN
2081: pay_us_employee_payslip_web.eit_tab(l_count).t_online := l_online;
2082: pay_us_employee_payslip_web.eit_tab(l_count).t_print := l_print;
2083: ELSE
2084: pay_us_employee_payslip_web.eit_tab(l_count).t_online := 'Y';
2085: pay_us_employee_payslip_web.eit_tab(l_count).t_print := 'Y';
2086: END IF;
2087:
2088: hr_utility.trace('eit_tab(l_count).t_online = '||

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

2081: pay_us_employee_payslip_web.eit_tab(l_count).t_online := l_online;
2082: pay_us_employee_payslip_web.eit_tab(l_count).t_print := l_print;
2083: ELSE
2084: pay_us_employee_payslip_web.eit_tab(l_count).t_online := 'Y';
2085: pay_us_employee_payslip_web.eit_tab(l_count).t_print := 'Y';
2086: END IF;
2087:
2088: hr_utility.trace('eit_tab(l_count).t_online = '||
2089: pay_us_employee_payslip_web.eit_tab(l_count).t_online);

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

2085: pay_us_employee_payslip_web.eit_tab(l_count).t_print := 'Y';
2086: END IF;
2087:
2088: hr_utility.trace('eit_tab(l_count).t_online = '||
2089: pay_us_employee_payslip_web.eit_tab(l_count).t_online);
2090: hr_utility.trace('eit_tab(l_count).t_print = '||
2091: pay_us_employee_payslip_web.eit_tab(l_count).t_print);
2092: IF p_mode = 'ONLINE' THEN
2093: l_value := pay_us_employee_payslip_web.eit_tab(l_count).t_online;

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

2087:
2088: hr_utility.trace('eit_tab(l_count).t_online = '||
2089: pay_us_employee_payslip_web.eit_tab(l_count).t_online);
2090: hr_utility.trace('eit_tab(l_count).t_print = '||
2091: pay_us_employee_payslip_web.eit_tab(l_count).t_print);
2092: IF p_mode = 'ONLINE' THEN
2093: l_value := pay_us_employee_payslip_web.eit_tab(l_count).t_online;
2094: ELSIF p_mode = 'PRINT' THEN
2095: l_value := pay_us_employee_payslip_web.eit_tab(l_count).t_print;

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

2089: pay_us_employee_payslip_web.eit_tab(l_count).t_online);
2090: hr_utility.trace('eit_tab(l_count).t_print = '||
2091: pay_us_employee_payslip_web.eit_tab(l_count).t_print);
2092: IF p_mode = 'ONLINE' THEN
2093: l_value := pay_us_employee_payslip_web.eit_tab(l_count).t_online;
2094: ELSIF p_mode = 'PRINT' THEN
2095: l_value := pay_us_employee_payslip_web.eit_tab(l_count).t_print;
2096: END IF;
2097: CLOSE get_loc_eit;

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

2091: pay_us_employee_payslip_web.eit_tab(l_count).t_print);
2092: IF p_mode = 'ONLINE' THEN
2093: l_value := pay_us_employee_payslip_web.eit_tab(l_count).t_online;
2094: ELSIF p_mode = 'PRINT' THEN
2095: l_value := pay_us_employee_payslip_web.eit_tab(l_count).t_print;
2096: END IF;
2097: CLOSE get_loc_eit;
2098: END IF;
2099: return l_value;

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

2101:
2102: IF upper(p_level) = 'ORGANIZATION' THEN
2103: hr_utility.set_location(l_mesg,50);
2104: IF (l_rowCount > 0) THEN
2105: FOR i in pay_us_employee_payslip_web.eit_tab.first ..
2106: pay_us_employee_payslip_web.eit_tab.last
2107: LOOP
2108: IF (pay_us_employee_payslip_web.eit_tab(i).t_id = p_id AND
2109: pay_us_employee_payslip_web.eit_tab(i).t_level

Line 2106: pay_us_employee_payslip_web.eit_tab.last

2102: IF upper(p_level) = 'ORGANIZATION' THEN
2103: hr_utility.set_location(l_mesg,50);
2104: IF (l_rowCount > 0) THEN
2105: FOR i in pay_us_employee_payslip_web.eit_tab.first ..
2106: pay_us_employee_payslip_web.eit_tab.last
2107: LOOP
2108: IF (pay_us_employee_payslip_web.eit_tab(i).t_id = p_id AND
2109: pay_us_employee_payslip_web.eit_tab(i).t_level
2110: = 'Organization') THEN

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

2104: IF (l_rowCount > 0) THEN
2105: FOR i in pay_us_employee_payslip_web.eit_tab.first ..
2106: pay_us_employee_payslip_web.eit_tab.last
2107: LOOP
2108: IF (pay_us_employee_payslip_web.eit_tab(i).t_id = p_id AND
2109: pay_us_employee_payslip_web.eit_tab(i).t_level
2110: = 'Organization') THEN
2111: l_org_cache := 'FOUND';
2112: IF p_mode = 'ONLINE' THEN

Line 2109: pay_us_employee_payslip_web.eit_tab(i).t_level

2105: FOR i in pay_us_employee_payslip_web.eit_tab.first ..
2106: pay_us_employee_payslip_web.eit_tab.last
2107: LOOP
2108: IF (pay_us_employee_payslip_web.eit_tab(i).t_id = p_id AND
2109: pay_us_employee_payslip_web.eit_tab(i).t_level
2110: = 'Organization') THEN
2111: l_org_cache := 'FOUND';
2112: IF p_mode = 'ONLINE' THEN
2113: l_value := pay_us_employee_payslip_web.eit_tab(i).t_online;

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

2109: pay_us_employee_payslip_web.eit_tab(i).t_level
2110: = 'Organization') THEN
2111: l_org_cache := 'FOUND';
2112: IF p_mode = 'ONLINE' THEN
2113: l_value := pay_us_employee_payslip_web.eit_tab(i).t_online;
2114: ELSIF p_mode = 'PRINT' THEN
2115: l_value := pay_us_employee_payslip_web.eit_tab(i).t_print;
2116: END IF;
2117: END IF;

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

2111: l_org_cache := 'FOUND';
2112: IF p_mode = 'ONLINE' THEN
2113: l_value := pay_us_employee_payslip_web.eit_tab(i).t_online;
2114: ELSIF p_mode = 'PRINT' THEN
2115: l_value := pay_us_employee_payslip_web.eit_tab(i).t_print;
2116: END IF;
2117: END IF;
2118: END LOOP;
2119: END IF;

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

2124: hr_utility.trace('Org cache NOT FOUND');
2125: hr_utility.set_location(l_mesg,60);
2126: OPEN get_org_eit(p_id);
2127: FETCH get_org_eit INTO l_online, l_print;
2128: l_count := pay_us_employee_payslip_web.eit_tab.count + 1 ;
2129: pay_us_employee_payslip_web.eit_tab(l_count).t_id := p_id;
2130: pay_us_employee_payslip_web.eit_tab(l_count).t_level := 'Organization';
2131:
2132: IF get_org_eit%FOUND THEN

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

2125: hr_utility.set_location(l_mesg,60);
2126: OPEN get_org_eit(p_id);
2127: FETCH get_org_eit INTO l_online, l_print;
2128: l_count := pay_us_employee_payslip_web.eit_tab.count + 1 ;
2129: pay_us_employee_payslip_web.eit_tab(l_count).t_id := p_id;
2130: pay_us_employee_payslip_web.eit_tab(l_count).t_level := 'Organization';
2131:
2132: IF get_org_eit%FOUND THEN
2133: pay_us_employee_payslip_web.eit_tab(l_count).t_online := l_online;

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

2126: OPEN get_org_eit(p_id);
2127: FETCH get_org_eit INTO l_online, l_print;
2128: l_count := pay_us_employee_payslip_web.eit_tab.count + 1 ;
2129: pay_us_employee_payslip_web.eit_tab(l_count).t_id := p_id;
2130: pay_us_employee_payslip_web.eit_tab(l_count).t_level := 'Organization';
2131:
2132: IF get_org_eit%FOUND THEN
2133: pay_us_employee_payslip_web.eit_tab(l_count).t_online := l_online;
2134: pay_us_employee_payslip_web.eit_tab(l_count).t_print := l_print;

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

2129: pay_us_employee_payslip_web.eit_tab(l_count).t_id := p_id;
2130: pay_us_employee_payslip_web.eit_tab(l_count).t_level := 'Organization';
2131:
2132: IF get_org_eit%FOUND THEN
2133: pay_us_employee_payslip_web.eit_tab(l_count).t_online := l_online;
2134: pay_us_employee_payslip_web.eit_tab(l_count).t_print := l_print;
2135: ELSE
2136: pay_us_employee_payslip_web.eit_tab(l_count).t_online := 'Y';
2137: pay_us_employee_payslip_web.eit_tab(l_count).t_print := 'Y';

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

2130: pay_us_employee_payslip_web.eit_tab(l_count).t_level := 'Organization';
2131:
2132: IF get_org_eit%FOUND THEN
2133: pay_us_employee_payslip_web.eit_tab(l_count).t_online := l_online;
2134: pay_us_employee_payslip_web.eit_tab(l_count).t_print := l_print;
2135: ELSE
2136: pay_us_employee_payslip_web.eit_tab(l_count).t_online := 'Y';
2137: pay_us_employee_payslip_web.eit_tab(l_count).t_print := 'Y';
2138: END IF;

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

2132: IF get_org_eit%FOUND THEN
2133: pay_us_employee_payslip_web.eit_tab(l_count).t_online := l_online;
2134: pay_us_employee_payslip_web.eit_tab(l_count).t_print := l_print;
2135: ELSE
2136: pay_us_employee_payslip_web.eit_tab(l_count).t_online := 'Y';
2137: pay_us_employee_payslip_web.eit_tab(l_count).t_print := 'Y';
2138: END IF;
2139:
2140: IF p_mode = 'PRINT' THEN

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

2133: pay_us_employee_payslip_web.eit_tab(l_count).t_online := l_online;
2134: pay_us_employee_payslip_web.eit_tab(l_count).t_print := l_print;
2135: ELSE
2136: pay_us_employee_payslip_web.eit_tab(l_count).t_online := 'Y';
2137: pay_us_employee_payslip_web.eit_tab(l_count).t_print := 'Y';
2138: END IF;
2139:
2140: IF p_mode = 'PRINT' THEN
2141: l_value := pay_us_employee_payslip_web.eit_tab(l_count).t_print;

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

2137: pay_us_employee_payslip_web.eit_tab(l_count).t_print := 'Y';
2138: END IF;
2139:
2140: IF p_mode = 'PRINT' THEN
2141: l_value := pay_us_employee_payslip_web.eit_tab(l_count).t_print;
2142: ELSIF p_mode = 'ONLINE' THEN
2143: l_value := pay_us_employee_payslip_web.eit_tab(l_count).t_online;
2144: END IF;
2145: CLOSE get_org_eit;

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

2139:
2140: IF p_mode = 'PRINT' THEN
2141: l_value := pay_us_employee_payslip_web.eit_tab(l_count).t_print;
2142: ELSIF p_mode = 'ONLINE' THEN
2143: l_value := pay_us_employee_payslip_web.eit_tab(l_count).t_online;
2144: END IF;
2145: CLOSE get_org_eit;
2146: END IF;
2147: return l_value;

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

2151:
2152: IF upper(p_level) = 'BUSINESS GROUP' THEN
2153: hr_utility.set_location(l_mesg,70);
2154: IF (l_rowCount > 0) THEN
2155: FOR i in pay_us_employee_payslip_web.eit_tab.first ..
2156: pay_us_employee_payslip_web.eit_tab.last LOOP
2157: IF (pay_us_employee_payslip_web.eit_tab(i).t_id = p_id AND
2158: pay_us_employee_payslip_web.eit_tab(i).t_level = 'Business Group')
2159: THEN

Line 2156: pay_us_employee_payslip_web.eit_tab.last LOOP

2152: IF upper(p_level) = 'BUSINESS GROUP' THEN
2153: hr_utility.set_location(l_mesg,70);
2154: IF (l_rowCount > 0) THEN
2155: FOR i in pay_us_employee_payslip_web.eit_tab.first ..
2156: pay_us_employee_payslip_web.eit_tab.last LOOP
2157: IF (pay_us_employee_payslip_web.eit_tab(i).t_id = p_id AND
2158: pay_us_employee_payslip_web.eit_tab(i).t_level = 'Business Group')
2159: THEN
2160: l_bg_cache := 'FOUND';

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

2153: hr_utility.set_location(l_mesg,70);
2154: IF (l_rowCount > 0) THEN
2155: FOR i in pay_us_employee_payslip_web.eit_tab.first ..
2156: pay_us_employee_payslip_web.eit_tab.last LOOP
2157: IF (pay_us_employee_payslip_web.eit_tab(i).t_id = p_id AND
2158: pay_us_employee_payslip_web.eit_tab(i).t_level = 'Business Group')
2159: THEN
2160: l_bg_cache := 'FOUND';
2161: IF p_mode = 'ONLINE' THEN

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

2154: IF (l_rowCount > 0) THEN
2155: FOR i in pay_us_employee_payslip_web.eit_tab.first ..
2156: pay_us_employee_payslip_web.eit_tab.last LOOP
2157: IF (pay_us_employee_payslip_web.eit_tab(i).t_id = p_id AND
2158: pay_us_employee_payslip_web.eit_tab(i).t_level = 'Business Group')
2159: THEN
2160: l_bg_cache := 'FOUND';
2161: IF p_mode = 'ONLINE' THEN
2162: l_value := pay_us_employee_payslip_web.eit_tab(i).t_online;

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

2158: pay_us_employee_payslip_web.eit_tab(i).t_level = 'Business Group')
2159: THEN
2160: l_bg_cache := 'FOUND';
2161: IF p_mode = 'ONLINE' THEN
2162: l_value := pay_us_employee_payslip_web.eit_tab(i).t_online;
2163: ELSIF p_mode = 'PRINT' THEN
2164: l_value := pay_us_employee_payslip_web.eit_tab(i).t_print;
2165: END IF;
2166: END IF;

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

2160: l_bg_cache := 'FOUND';
2161: IF p_mode = 'ONLINE' THEN
2162: l_value := pay_us_employee_payslip_web.eit_tab(i).t_online;
2163: ELSIF p_mode = 'PRINT' THEN
2164: l_value := pay_us_employee_payslip_web.eit_tab(i).t_print;
2165: END IF;
2166: END IF;
2167: END LOOP;
2168: END IF;

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

2173: hr_utility.set_location(l_mesg,80);
2174:
2175: OPEN get_bg_eit(p_id);
2176: FETCH get_bg_eit INTO l_online, l_print;
2177: l_count := pay_us_employee_payslip_web.eit_tab.count + 1;
2178: pay_us_employee_payslip_web.eit_tab(l_count).t_id := p_id;
2179: pay_us_employee_payslip_web.eit_tab(l_count).t_level := 'Business Group';
2180:
2181: IF get_bg_eit%FOUND THEN

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

2174:
2175: OPEN get_bg_eit(p_id);
2176: FETCH get_bg_eit INTO l_online, l_print;
2177: l_count := pay_us_employee_payslip_web.eit_tab.count + 1;
2178: pay_us_employee_payslip_web.eit_tab(l_count).t_id := p_id;
2179: pay_us_employee_payslip_web.eit_tab(l_count).t_level := 'Business Group';
2180:
2181: IF get_bg_eit%FOUND THEN
2182: pay_us_employee_payslip_web.eit_tab(l_count).t_online := l_online;

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

2175: OPEN get_bg_eit(p_id);
2176: FETCH get_bg_eit INTO l_online, l_print;
2177: l_count := pay_us_employee_payslip_web.eit_tab.count + 1;
2178: pay_us_employee_payslip_web.eit_tab(l_count).t_id := p_id;
2179: pay_us_employee_payslip_web.eit_tab(l_count).t_level := 'Business Group';
2180:
2181: IF get_bg_eit%FOUND THEN
2182: pay_us_employee_payslip_web.eit_tab(l_count).t_online := l_online;
2183: pay_us_employee_payslip_web.eit_tab(l_count).t_print := l_print;

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

2178: pay_us_employee_payslip_web.eit_tab(l_count).t_id := p_id;
2179: pay_us_employee_payslip_web.eit_tab(l_count).t_level := 'Business Group';
2180:
2181: IF get_bg_eit%FOUND THEN
2182: pay_us_employee_payslip_web.eit_tab(l_count).t_online := l_online;
2183: pay_us_employee_payslip_web.eit_tab(l_count).t_print := l_print;
2184: ELSE
2185: pay_us_employee_payslip_web.eit_tab(l_count).t_online := 'Y';
2186: pay_us_employee_payslip_web.eit_tab(l_count).t_print := 'Y';

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

2179: pay_us_employee_payslip_web.eit_tab(l_count).t_level := 'Business Group';
2180:
2181: IF get_bg_eit%FOUND THEN
2182: pay_us_employee_payslip_web.eit_tab(l_count).t_online := l_online;
2183: pay_us_employee_payslip_web.eit_tab(l_count).t_print := l_print;
2184: ELSE
2185: pay_us_employee_payslip_web.eit_tab(l_count).t_online := 'Y';
2186: pay_us_employee_payslip_web.eit_tab(l_count).t_print := 'Y';
2187: END IF;

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

2181: IF get_bg_eit%FOUND THEN
2182: pay_us_employee_payslip_web.eit_tab(l_count).t_online := l_online;
2183: pay_us_employee_payslip_web.eit_tab(l_count).t_print := l_print;
2184: ELSE
2185: pay_us_employee_payslip_web.eit_tab(l_count).t_online := 'Y';
2186: pay_us_employee_payslip_web.eit_tab(l_count).t_print := 'Y';
2187: END IF;
2188:
2189: IF p_mode = 'ONLINE' THEN

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

2182: pay_us_employee_payslip_web.eit_tab(l_count).t_online := l_online;
2183: pay_us_employee_payslip_web.eit_tab(l_count).t_print := l_print;
2184: ELSE
2185: pay_us_employee_payslip_web.eit_tab(l_count).t_online := 'Y';
2186: pay_us_employee_payslip_web.eit_tab(l_count).t_print := 'Y';
2187: END IF;
2188:
2189: IF p_mode = 'ONLINE' THEN
2190: l_value := pay_us_employee_payslip_web.eit_tab(l_count).t_online;

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

2186: pay_us_employee_payslip_web.eit_tab(l_count).t_print := 'Y';
2187: END IF;
2188:
2189: IF p_mode = 'ONLINE' THEN
2190: l_value := pay_us_employee_payslip_web.eit_tab(l_count).t_online;
2191: ELSIF p_mode = 'PRINT' THEN
2192: l_value := pay_us_employee_payslip_web.eit_tab(l_count).t_print;
2193: END IF;
2194:

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

2188:
2189: IF p_mode = 'ONLINE' THEN
2190: l_value := pay_us_employee_payslip_web.eit_tab(l_count).t_online;
2191: ELSIF p_mode = 'PRINT' THEN
2192: l_value := pay_us_employee_payslip_web.eit_tab(l_count).t_print;
2193: END IF;
2194:
2195: CLOSE get_bg_eit;
2196: END IF; -- bg_cache not found

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

2275: close c_get_city;
2276: elsif p_jurisdiction_code like '__-_____' then
2277: -- this is school district make a function call
2278: lv_jurisdiction_name
2279: := pay_us_employee_payslip_web.get_school_dsts_name(p_jurisdiction_code);
2280: end if;
2281:
2282: hr_utility.set_location(gv_package || lv_procedure_name, 30);
2283: return (lv_jurisdiction_name);

Line 2476: lv_jurisdiction_name := pay_us_employee_payslip_web.get_jurisdiction_name

2472: lv_jurisdiction_name := null;
2473:
2474: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2475: if p_jurisdiction_code like '__-000-0000' then
2476: lv_jurisdiction_name := pay_us_employee_payslip_web.get_jurisdiction_name
2477: (lv_state_code || '-000-0000');
2478:
2479: elsif p_jurisdiction_code like '__-___-0000' then
2480: lv_state_abbrev := pay_us_employee_payslip_web.get_jurisdiction_name

Line 2480: lv_state_abbrev := pay_us_employee_payslip_web.get_jurisdiction_name

2476: lv_jurisdiction_name := pay_us_employee_payslip_web.get_jurisdiction_name
2477: (lv_state_code || '-000-0000');
2478:
2479: elsif p_jurisdiction_code like '__-___-0000' then
2480: lv_state_abbrev := pay_us_employee_payslip_web.get_jurisdiction_name
2481: (lv_state_code || '-000-0000');
2482: lv_county_name := pay_us_employee_payslip_web.get_jurisdiction_name
2483: (p_jurisdiction_code);
2484:

Line 2482: lv_county_name := pay_us_employee_payslip_web.get_jurisdiction_name

2478:
2479: elsif p_jurisdiction_code like '__-___-0000' then
2480: lv_state_abbrev := pay_us_employee_payslip_web.get_jurisdiction_name
2481: (lv_state_code || '-000-0000');
2482: lv_county_name := pay_us_employee_payslip_web.get_jurisdiction_name
2483: (p_jurisdiction_code);
2484:
2485: lv_jurisdiction_name := lv_state_abbrev ||', '||lv_county_name;
2486:

Line 2488: lv_state_abbrev := pay_us_employee_payslip_web.get_jurisdiction_name

2484:
2485: lv_jurisdiction_name := lv_state_abbrev ||', '||lv_county_name;
2486:
2487: elsif p_jurisdiction_code like '__-___-____' then
2488: lv_state_abbrev := pay_us_employee_payslip_web.get_jurisdiction_name
2489: (lv_state_code || '-000-0000');
2490:
2491: lv_county_name := pay_us_employee_payslip_web.get_jurisdiction_name
2492: (lv_state_code || '-' || lv_county_code || '-0000');

Line 2491: lv_county_name := pay_us_employee_payslip_web.get_jurisdiction_name

2487: elsif p_jurisdiction_code like '__-___-____' then
2488: lv_state_abbrev := pay_us_employee_payslip_web.get_jurisdiction_name
2489: (lv_state_code || '-000-0000');
2490:
2491: lv_county_name := pay_us_employee_payslip_web.get_jurisdiction_name
2492: (lv_state_code || '-' || lv_county_code || '-0000');
2493: lv_city_name := pay_us_employee_payslip_web.get_jurisdiction_name
2494: (p_jurisdiction_code);
2495:

Line 2493: lv_city_name := pay_us_employee_payslip_web.get_jurisdiction_name

2489: (lv_state_code || '-000-0000');
2490:
2491: lv_county_name := pay_us_employee_payslip_web.get_jurisdiction_name
2492: (lv_state_code || '-' || lv_county_code || '-0000');
2493: lv_city_name := pay_us_employee_payslip_web.get_jurisdiction_name
2494: (p_jurisdiction_code);
2495:
2496: hr_utility.set_location('p_jurisdiction_code -> '||p_jurisdiction_code, 30);
2497: hr_utility.set_location('lv_state_abbrev -> '|| lv_state_abbrev, 30);

Line 2505: lv_state_abbrev := pay_us_employee_payslip_web.get_jurisdiction_name

2501: lv_jurisdiction_name := lv_state_abbrev ||', '||
2502: lv_county_name ||', '||
2503: lv_city_name;
2504: elsif length(p_jurisdiction_code) = 8 then
2505: lv_state_abbrev := pay_us_employee_payslip_web.get_jurisdiction_name
2506: (lv_state_code || '-000-0000');
2507: lv_school_dst := pay_us_employee_payslip_web.get_jurisdiction_name
2508: (p_jurisdiction_code);
2509: lv_jurisdiction_name := lv_state_abbrev || ', ' ||

Line 2507: lv_school_dst := pay_us_employee_payslip_web.get_jurisdiction_name

2503: lv_city_name;
2504: elsif length(p_jurisdiction_code) = 8 then
2505: lv_state_abbrev := pay_us_employee_payslip_web.get_jurisdiction_name
2506: (lv_state_code || '-000-0000');
2507: lv_school_dst := pay_us_employee_payslip_web.get_jurisdiction_name
2508: (p_jurisdiction_code);
2509: lv_jurisdiction_name := lv_state_abbrev || ', ' ||
2510: lv_school_dst;
2511:

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

2543: lv_legislation_code VARCHAR2(100);
2544: lv_exists VARCHAR2(10);
2545:
2546: BEGIN
2547: hr_utility.trace('Entering into pay_us_employee_payslip_web.get_netpaydistr_segment');
2548: hr_utility.trace('p_business_grp_id := ' || p_business_grp_id);
2549: hr_utility.trace('p_org_pay_meth_id := ' || p_org_pay_meth_id);
2550:
2551: open cur_legislation(p_business_grp_id);

Line 2755: g_job_label := pay_us_employee_payslip_web.get_meaning_payslip_label(g_legislation_code || '', 'JOB');

2751: ELSE
2752: IF p_first_call = 'Y' THEN
2753: hr_utility.TRACE('check_emp_personal_payment - First Call');
2754: numlistrows := numlistrows + 1;
2755: g_job_label := pay_us_employee_payslip_web.get_meaning_payslip_label(g_legislation_code || '', 'JOB');
2756: g_check_label := pay_us_employee_payslip_web.get_meaning_payslip_label(g_legislation_code || '', 'CHECK');
2757:
2758: --check if the cursor was closed. If there was an exception of sort, then it may lead to
2759: --cursor remaining in open status

Line 2756: g_check_label := pay_us_employee_payslip_web.get_meaning_payslip_label(g_legislation_code || '', 'CHECK');

2752: IF p_first_call = 'Y' THEN
2753: hr_utility.TRACE('check_emp_personal_payment - First Call');
2754: numlistrows := numlistrows + 1;
2755: g_job_label := pay_us_employee_payslip_web.get_meaning_payslip_label(g_legislation_code || '', 'JOB');
2756: g_check_label := pay_us_employee_payslip_web.get_meaning_payslip_label(g_legislation_code || '', 'CHECK');
2757:
2758: --check if the cursor was closed. If there was an exception of sort, then it may lead to
2759: --cursor remaining in open status
2760: IF get_choose_payslip%ISOPEN THEN

Line 2834: l_term_flag := pay_us_employee_payslip_web.get_term_info(p_business_group_id, p_person_id, action_context_id);

2830: hr_utility.TRACE('check_emp_personal_payment - Valid Payslip found for t_assignment_action_id ' ||action_context_id);
2831:
2832: --Now check for Termination
2833: IF p_enable_term = 'N' THEN
2834: l_term_flag := pay_us_employee_payslip_web.get_term_info(p_business_group_id, p_person_id, action_context_id);
2835: END IF;
2836:
2837: IF (p_enable_term = 'N' AND l_term_flag = 'Y') OR (p_enable_term <> 'N') THEN
2838:

Line 3183: g_job_label := pay_us_employee_payslip_web.get_meaning_payslip_label(p_legislation_code || '', 'JOB');

3179:
3180: begin
3181:
3182: if g_job_label is null then
3183: g_job_label := pay_us_employee_payslip_web.get_meaning_payslip_label(p_legislation_code || '', 'JOB');
3184: end if;
3185:
3186: if g_check_label is null then
3187: g_check_label := pay_us_employee_payslip_web.get_meaning_payslip_label(p_legislation_code || '', 'CHECK');

Line 3187: g_check_label := pay_us_employee_payslip_web.get_meaning_payslip_label(p_legislation_code || '', 'CHECK');

3183: g_job_label := pay_us_employee_payslip_web.get_meaning_payslip_label(p_legislation_code || '', 'JOB');
3184: end if;
3185:
3186: if g_check_label is null then
3187: g_check_label := pay_us_employee_payslip_web.get_meaning_payslip_label(p_legislation_code || '', 'CHECK');
3188: end if;
3189: /*
3190: if fnd_release.release_name >= '12.1.1' then
3191:

Line 3240: gv_package := 'pay_us_employee_payslip_web';

3236:
3237: end get_display_list;
3238:
3239: BEGIN
3240: gv_package := 'pay_us_employee_payslip_web';
3241: -- hr_utility.trace_on(null, 'PAYSLIP');
3242: END pay_us_employee_payslip_web;

Line 3242: END pay_us_employee_payslip_web;

3238:
3239: BEGIN
3240: gv_package := 'pay_us_employee_payslip_web';
3241: -- hr_utility.trace_on(null, 'PAYSLIP');
3242: END pay_us_employee_payslip_web;