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

Line 1: PACKAGE BODY pqp_car_mileage_functions AS

1: PACKAGE BODY pqp_car_mileage_functions AS
2: --REM $Header: pqgbcmfn.pkb 120.5.12010000.1 2008/07/28 11:10:54 appldev ship $
3:
4: ----------------------------------------------------------------------
5: --Function get_legislation_code

Line 165: l_effective_date := TRUNC(pqp_car_mileage_functions.pqp_get_date_paid

161:
162: -- This was done because Formula Functions do not accept NULL
163: -- for input. If the date is 01/01/1900 then effective_date = date earned
164: IF TO_CHAR(TRUNC(p_claim_date),'DD/MM/YYYY') = '01/01/1900' THEN
165: l_effective_date := TRUNC(pqp_car_mileage_functions.pqp_get_date_paid
166: (p_payroll_action_id));
167: ELSE
168: l_effective_date := p_claim_date;
169: END IF;

Line 391: l_legislation_code := pqp_car_mileage_functions.

387:
388: l_get_config_value c_get_config_value_rates%ROWTYPE;
389: l_legislation_code pqp_configuration_values.legislation_code%TYPE;
390: BEGIN
391: l_legislation_code := pqp_car_mileage_functions.
392: get_legislation_code (p_business_group_id);
393: IF p_info_type = 'Rates' THEN
394: OPEN c_get_config_value_rates (l_legislation_code);
395: FETCH c_get_config_value_rates INTO l_get_config_value;

Line 642: l_effective_date :=TRUNC(pqp_car_mileage_functions.

638: l_err_num NUMBER:=0;
639: l_veh_typ VARCHAR2(3):=NULL;
640: l_temp_effective_date DATE;
641: BEGIN
642: l_effective_date :=TRUNC(pqp_car_mileage_functions.
643: pqp_get_date_paid(p_payroll_action_id));
644: l_vehicle_type := NVL(SUBSTR(p_car_type,2),'C');
645: l_car_type:=SUBSTR(p_car_type,0,1);
646: IF l_vehicle_type='CM' or l_vehicle_type='PM' THEN

Line 946: l_effective_date :=TRUNC(pqp_car_mileage_functions.

942: l_max_period_num NUMBER;
943: l_periodtype per_time_periods.period_type%TYPE;
944: l_effective_date DATE;
945: BEGIN
946: l_effective_date :=TRUNC(pqp_car_mileage_functions.
947: pqp_get_date_paid(p_payroll_action_id));
948: OPEN period_type;
949: LOOP
950: FETCH period_type INTO l_periodtype;

Line 1104: l_claim_date := TRUNC(pqp_car_mileage_functions.

1100:
1101: -- This was done because Formula Functions do not accept NULL
1102: -- for input. If the claim date is 1/01/1900 then claim date = date earned
1103: IF TO_CHAR(TRUNC(p_claim_date),'DD/MM/YYYY') = '01/01/1900' THEN
1104: l_claim_date := TRUNC(pqp_car_mileage_functions.
1105: pqp_get_date_paid(p_payroll_action_id));
1106: ELSE
1107: l_claim_date := p_claim_date;
1108: END IF;

Line 1155: l_effective_date :=TRUNC(pqp_car_mileage_functions.

1151: l_dummy VARCHAR2(1);
1152: l_effective_date DATE;
1153:
1154: BEGIN
1155: l_effective_date :=TRUNC(pqp_car_mileage_functions.
1156: pqp_get_date_paid(p_payroll_action_id));
1157: -- Get the current fiscal year
1158: -- Specific only to GB hence the dates are hard coded
1159:

Line 1207: l_effective_date := trunc(pqp_car_mileage_functions.

1203: -- This is done because in the formula functions NULL
1204: -- is not a valid input.
1205: -- If Effective date is null assign date earned to effective date
1206: IF TO_CHAR(TRUNC(p_effective_date),'DD/MM/YYYY') = '01/01/1900' THEN
1207: l_effective_date := trunc(pqp_car_mileage_functions.
1208: pqp_get_date_paid(p_payroll_action_id));
1209: ELSE
1210: l_effective_date := p_effective_date;
1211: END IF;

Line 1486: l_effective_date :=trunc(pqp_car_mileage_functions.

1482: hi_hp_mileage NUMBER:=0;
1483:
1484: l_effective_date DATE;
1485: Begin
1486: l_effective_date :=trunc(pqp_car_mileage_functions.
1487: pqp_get_date_paid(p_payroll_action_id));
1488: IF p_cl_period=p_total_period THEN
1489: RETURN('Y');
1490: ELSIF l_effective_date >TO_DATE('05/04/'||to_char(l_effective_date,'RRRR'),'DD/MM/RRRR') AND

Line 1500: lband := pqp_car_mileage_functions.pqp_get_range( p_assignment_id

1496:
1497: FOR i in p_cl_period..p_total_period
1498: LOOP
1499: l_pro_mile:=(l_mile*p_total_period)/i;
1500: lband := pqp_car_mileage_functions.pqp_get_range( p_assignment_id
1501: , p_bg_id
1502: , p_payroll_action_id
1503: , p_rates_table
1504: , 'ROW'

Line 1570: l_effective_date :=TRUNC(pqp_car_mileage_functions.

1566: BEGIN
1567: --
1568: l_end_date_nc := p_end_date;
1569:
1570: l_effective_date :=TRUNC(pqp_car_mileage_functions.
1571: pqp_get_date_paid(p_payroll_action_id));
1572: IF NVL(p_end_date,'NO') <> 'NONE' THEN
1573:
1574: p_end_date:= Max_limit_calc ( p_assignment_id

Line 1588: lband := pqp_car_mileage_functions.pqp_get_range( p_assignment_id

1584: );
1585:
1586: END IF;
1587:
1588: lband := pqp_car_mileage_functions.pqp_get_range( p_assignment_id
1589: , p_bg_id
1590: ,p_payroll_action_id
1591: , p_rates_table
1592: , 'ROW'

Line 1598: lband := pqp_car_mileage_functions.pqp_get_range( p_assignment_id

1594: , p_claim_date
1595: , l_mileage
1596: , hi_mileage);
1597:
1598: lband := pqp_car_mileage_functions.pqp_get_range( p_assignment_id
1599: , p_bg_id
1600: ,p_payroll_action_id
1601: , p_rates_table
1602: , 'ROW'

Line 1623: l_value:=pqp_car_mileage_functions.pqp_get_table_value(p_bg_id

1619: (l_mileage=l_hp_mileage and hi_mileage=hi_hp_mileage) THEN
1620: --
1621: h_mileage:=to_char(hi_hp_mileage);
1622: lh_mileage:=to_char(hi_mileage);
1623: l_value:=pqp_car_mileage_functions.pqp_get_table_value(p_bg_id
1624: ,p_payroll_action_id
1625: ,p_rates_table
1626: ,ch_col
1627: ,h_mileage

Line 1630: ll_value:=pqp_car_mileage_functions.pqp_get_table_value(p_bg_id

1626: ,ch_col
1627: ,h_mileage
1628: ,p_claim_date
1629: ,err_msg);
1630: ll_value:=pqp_car_mileage_functions.pqp_get_table_value(p_bg_id
1631: ,p_payroll_action_id
1632: ,p_rates_table
1633: ,ch_col
1634: ,lh_mileage

Line 1642: l_value:=pqp_car_mileage_functions.pqp_get_table_value(p_bg_id

1638: RETURN (((((p_prorated_mileage-l_hp_mileage)*l_value)*p_cl_period)/p_total_period) +
1639: (((l_hp_mileage-p_lower_pro_mileage)*p_cl_period)/p_total_period)*ll_value);
1640: ELSE
1641: h_mileage:=to_char(hi_hp_mileage);
1642: l_value:=pqp_car_mileage_functions.pqp_get_table_value(p_bg_id
1643: ,p_payroll_action_id
1644: ,p_rates_table
1645: ,ch_col
1646: ,h_mileage

Line 1682: l_value:=pqp_car_mileage_functions.pqp_get_table_value(p_bg_id

1678:
1679: --
1680: h_mileage:=to_char(hi_mileage);
1681: lh_mileage:=to_char(hi_hp_mileage);
1682: l_value:=pqp_car_mileage_functions.pqp_get_table_value(p_bg_id
1683: ,p_payroll_action_id
1684: ,p_rates_table
1685: ,ch_col
1686: ,h_mileage

Line 1689: ll_value:=pqp_car_mileage_functions.pqp_get_table_value(p_bg_id

1685: ,ch_col
1686: ,h_mileage
1687: ,p_claim_date
1688: ,err_msg);
1689: ll_value:=pqp_car_mileage_functions.pqp_get_table_value(p_bg_id
1690: ,p_payroll_action_id
1691: ,p_rates_table
1692: ,ch_col
1693: ,lh_mileage

Line 1702: l_value:=pqp_car_mileage_functions.pqp_get_table_value(p_bg_id

1698: (((l_mileage-p_prorated_mileage)*p_cl_period)/p_total_period)*ll_value));
1699: ELSE
1700:
1701: h_mileage:=to_char(hi_mileage);
1702: l_value:=pqp_car_mileage_functions.pqp_get_table_value(p_bg_id
1703: ,p_payroll_action_id
1704: ,p_rates_table
1705: ,ch_col
1706: ,h_mileage

Line 1780: l_effective_date := TRUNC(pqp_car_mileage_functions.

1776: l_ret_value NUMBER;
1777: l_ele_iram_itd NUMBER(11,2);
1778: l_error_mesg VARCHAR2(80) ;
1779: BEGIN
1780: l_effective_date := TRUNC(pqp_car_mileage_functions.
1781: pqp_get_date_paid(p_payroll_action_id));
1782:
1783:
1784: IF p_itd_ac_miles=0 OR

Line 1817: return_result:= pqp_car_mileage_functions.pqp_get_range (

1813: END IF;
1814:
1815: IF p_Two_wheeler_type <>'PP' AND p_Two_wheeler_type <>'PM' THEN
1816:
1817: return_result:= pqp_car_mileage_functions.pqp_get_range (
1818: p_assignment_id
1819: ,p_business_group_id
1820: ,p_payroll_action_id
1821: ,p_table_name

Line 1834: return_result:= pqp_car_mileage_functions.pqp_get_range (

1830: (p_actual_mileage+(p_total_actual_mileage-p_itd_ac_miles))
1831: THEN
1832:
1833: hi_flag:='Y';
1834: return_result:= pqp_car_mileage_functions.pqp_get_range (
1835: p_assignment_id
1836: ,p_business_group_id
1837: ,p_payroll_action_id
1838: ,p_table_name

Line 1854: return_result:= pqp_car_mileage_functions.pqp_get_range (

1850:
1851: ch_irh_mileage_band:=p_wheeler_type;
1852: END IF;
1853:
1854: return_result:= pqp_car_mileage_functions.pqp_get_range (
1855: p_assignment_id
1856: ,p_business_group_id
1857: ,p_payroll_action_id
1858: ,p_table_name

Line 1874: iram_rate:=to_number( pqp_car_mileage_functions.pqp_get_table_value(

1870: END IF;
1871:
1872: chi_cc:=to_char(hi_cc);
1873:
1874: iram_rate:=to_number( pqp_car_mileage_functions.pqp_get_table_value(
1875: p_business_group_id
1876: ,p_payroll_action_id
1877: ,p_table_name
1878: ,chi_cc

Line 1883: iram_rate_hi:=to_number( pqp_car_mileage_functions.pqp_get_table_value(

1879: , ch_irh_mileage_band
1880: , p_Claim_end_date,err_msg));
1881: IF hi_flag='Y' THEN
1882:
1883: iram_rate_hi:=to_number( pqp_car_mileage_functions.pqp_get_table_value(
1884: p_business_group_id
1885: ,p_payroll_action_id
1886: ,p_table_name
1887: ,chi_cc

Line 2007: l_ret_value:=pqp_car_mileage_functions.pqp_get_range(

2003: AND ( p_total_pasg_itd_val - p_total_passengers) <> 0 AND l_rates_table2 <> 'NONE'
2004: AND l_err IS NULL THEN
2005: l_rates_setting := get_config_info (p_business_group_id,'Rates');
2006: IF l_rates_setting ='Y' THEN
2007: l_ret_value:=pqp_car_mileage_functions.pqp_get_range(
2008: p_assignment_id => 0
2009: ,p_business_group_id => p_business_group_id
2010: ,p_payroll_action_id => p_payroll_action_id
2011: ,p_table_name => l_rates_table2

Line 2018: addl_rate1:=to_number(pqp_car_mileage_functions.pqp_get_table_value

2014: ,p_claim_date => p_claim_end_date
2015: ,p_low_value => l_low_val_ur1
2016: ,p_high_value => l_high_val_ur1 );
2017: chi_cc1:=to_char(l_high_val_ur1);
2018: addl_rate1:=to_number(pqp_car_mileage_functions.pqp_get_table_value
2019: (p_bus_group_id => p_business_group_id
2020: ,p_payroll_action_id => p_payroll_action_id
2021: ,p_table_name => l_rates_table2
2022: ,p_col_name => chi_cc1

Line 2030: l_effective_date :=TRUNC(pqp_car_mileage_functions.

2026: l_correction:='Y';
2027: END IF;
2028: END IF;
2029:
2030: l_effective_date :=TRUNC(pqp_car_mileage_functions.
2031: pqp_get_date_paid(p_payroll_action_id));
2032: IF p_total_passengers=0 AND p_total_pasg_itd_val=0 THEN
2033:
2034: p_tax_free_amt:=0;

Line 2040: l_ret_value:=pqp_car_mileage_functions.pqp_get_range(

2036: p_tax_amt:=0;
2037: p_err_msg:='SUCCESS';
2038:
2039: ELSE
2040: l_ret_value:=pqp_car_mileage_functions.pqp_get_range(
2041: p_assignment_id => 0
2042: ,p_business_group_id =>p_business_group_id
2043: ,p_payroll_action_id =>p_payroll_action_id
2044: ,p_table_name =>l_rates_table1

Line 2054: addl_rate:=to_number(pqp_car_mileage_functions.pqp_get_table_value

2050: IF (p_Claimed_mileage-p_itd_miles)<>0
2051: OR (p_total_passengers- p_total_pasg_itd_val) <> 0 THEN
2052: chi_cc:=to_char(l_high_val_ur);
2053: chi_cc_iram:=to_char(l_high_value);
2054: addl_rate:=to_number(pqp_car_mileage_functions.pqp_get_table_value
2055: (p_bus_group_id => p_business_group_id
2056: ,p_payroll_action_id =>p_payroll_action_id
2057: ,p_table_name => l_rates_table1
2058: ,p_col_name => chi_cc

Line 2237: l_ret_value:=pqp_car_mileage_functions.pqp_get_range

2233: AND l_rates_table2 <> 'NONE'
2234: AND l_err IS NULL THEN
2235: l_rates_setting := get_config_info (p_business_group_id,'Rates');
2236: IF l_rates_setting ='Y' THEN
2237: l_ret_value:=pqp_car_mileage_functions.pqp_get_range
2238: (p_assignment_id =>0
2239: ,p_business_group_id =>p_business_group_id
2240: ,p_payroll_action_id =>p_payroll_action_id
2241: ,p_table_name =>'PQP_INLAND_REV_AUTH_MILEAGE_RATES'

Line 2248: l_ret_value:=pqp_car_mileage_functions.pqp_get_range(

2244: ,p_claim_date =>p_claim_end_date
2245: ,p_low_value =>l_low_value
2246: ,p_high_value =>l_high_value );
2247:
2248: l_ret_value:=pqp_car_mileage_functions.pqp_get_range(
2249: p_assignment_id => 0
2250: ,p_business_group_id =>p_business_group_id
2251: ,p_payroll_action_id =>p_payroll_action_id
2252: ,p_table_name =>l_rates_table2

Line 2260: addl_rate1:=to_number(pqp_car_mileage_functions.pqp_get_table_value

2256: ,p_low_value =>l_low_val_ur1
2257: ,p_high_value =>l_high_val_ur1 );
2258: chi_cc1:=to_char(l_high_val_ur1);
2259: chi_cc_iram:=to_char(l_high_value);
2260: addl_rate1:=to_number(pqp_car_mileage_functions.pqp_get_table_value
2261: (p_bus_group_id => p_business_group_id
2262: ,p_payroll_action_id =>p_payroll_action_id
2263: ,p_table_name => l_rates_table2
2264: ,p_col_name => chi_cc1

Line 2270: addl_ni_rate1:=to_number(pqp_car_mileage_functions.pqp_get_table_value

2266: ,p_effective_date => p_Claim_end_date
2267: ,p_error_msg => p_err_msg));
2268: IF p_err_msg='SUCCESS'
2269: AND ( p_vehicle_type='E' OR p_vehicle_type='C')THEN
2270: addl_ni_rate1:=to_number(pqp_car_mileage_functions.pqp_get_table_value
2271: (p_bus_group_id => p_business_group_id
2272: ,p_payroll_action_id =>p_payroll_action_id
2273: ,p_table_name => 'PQP_NIC_MILEAGE_RATES'
2274: ,p_col_name => chi_cc_iram

Line 2281: addl_tax_rate1:=to_number(pqp_car_mileage_functions.pqp_get_table_value

2277: ,p_error_msg =>p_err_msg));
2278: END IF;
2279: IF p_err_msg='SUCCESS'
2280: AND ( p_vehicle_type='E' OR p_vehicle_type='C') THEN
2281: addl_tax_rate1:=to_number(pqp_car_mileage_functions.pqp_get_table_value
2282: (p_bus_group_id => p_business_group_id
2283: ,p_payroll_action_id =>p_payroll_action_id
2284: ,p_table_name => 'PQP_INLAND_REV_AUTH_MILEAGE_RATES'
2285: ,p_col_name => chi_cc_iram

Line 2293: l_effective_date :=TRUNC(pqp_car_mileage_functions.

2289: END IF;
2290: l_correction:='Y';
2291: END IF;
2292: END IF;
2293: l_effective_date :=TRUNC(pqp_car_mileage_functions.
2294: pqp_get_date_paid(p_payroll_action_id));
2295: IF p_total_passengers=0 AND p_total_pasg_itd_val=0 THEN
2296: p_tax_free_amt:=0;
2297: p_ni_amt:=0;

Line 2302: l_ret_value:=pqp_car_mileage_functions.pqp_get_range

2298: p_tax_amt:=0;
2299: p_err_msg:='SUCCESS';
2300:
2301: ELSE
2302: l_ret_value:=pqp_car_mileage_functions.pqp_get_range
2303: (p_assignment_id =>0
2304: ,p_business_group_id =>p_business_group_id
2305: ,p_payroll_action_id =>p_payroll_action_id
2306: ,p_table_name =>'PQP_INLAND_REV_AUTH_MILEAGE_RATES'

Line 2313: l_ret_value:=pqp_car_mileage_functions.pqp_get_range(

2309: ,p_claim_date =>p_claim_end_date
2310: ,p_low_value =>l_low_value
2311: ,p_high_value =>l_high_value );
2312:
2313: l_ret_value:=pqp_car_mileage_functions.pqp_get_range(
2314: p_assignment_id => 0
2315: ,p_business_group_id =>p_business_group_id
2316: ,p_payroll_action_id =>p_payroll_action_id
2317: ,p_table_name =>l_rates_table1

Line 2328: addl_rate:=to_number(pqp_car_mileage_functions.pqp_get_table_value

2324: OR (p_total_passengers- p_total_pasg_itd_val) <> 0
2325: OR (p_actual_mileage-p_ac_itd_miles)<>0 THEN
2326: chi_cc:=to_char(l_high_val_ur);
2327: chi_cc_iram:=to_char(l_high_value);
2328: addl_rate:=to_number(pqp_car_mileage_functions.pqp_get_table_value
2329: (p_bus_group_id => p_business_group_id
2330: ,p_payroll_action_id =>p_payroll_action_id
2331: ,p_table_name => l_rates_table1
2332: ,p_col_name => chi_cc

Line 2344: addl_ni_rate:=to_number(pqp_car_mileage_functions.pqp_get_table_value

2340:
2341:
2342: IF p_err_msg='SUCCESS'
2343: AND ( p_vehicle_type='E' OR p_vehicle_type='C')THEN
2344: addl_ni_rate:=to_number(pqp_car_mileage_functions.pqp_get_table_value
2345: (p_bus_group_id => p_business_group_id
2346: ,p_payroll_action_id =>p_payroll_action_id
2347: ,p_table_name => 'PQP_NIC_MILEAGE_RATES'
2348: ,p_col_name => chi_cc_iram

Line 2355: addl_tax_rate:=to_number(pqp_car_mileage_functions.pqp_get_table_value

2351: ,p_error_msg =>p_err_msg));
2352: END IF;
2353: IF p_err_msg='SUCCESS'
2354: AND ( p_vehicle_type='E' OR p_vehicle_type='C') THEN
2355: addl_tax_rate:=to_number(pqp_car_mileage_functions.pqp_get_table_value
2356: (p_bus_group_id => p_business_group_id
2357: ,p_payroll_action_id =>p_payroll_action_id
2358: ,p_table_name => 'PQP_INLAND_REV_AUTH_MILEAGE_RATES'
2359: ,p_col_name => chi_cc_iram

Line 2602: l_effective_date :=TRUNC(pqp_car_mileage_functions.

2598: l_effective_date DATE;
2599:
2600:
2601: BEGIN
2602: l_effective_date :=TRUNC(pqp_car_mileage_functions.
2603: pqp_get_date_paid(p_payroll_action_id));
2604:
2605:
2606: OPEN c_vehicle_type (p_business_group_id

Line 2715: END pqp_car_mileage_functions;

2711: RETURN('N');
2712: END;
2713:
2714:
2715: END pqp_car_mileage_functions;