1432: l_taxable_pass_payment Number;
1433: l_ce Number;
1434: begin
1435: -- hr_utility.trace_on(null,'AMAP');
1436: l_C_BUS_MILES := nvl(per_formula_functions.get_number('C_BUS_MILES'),0);
1437: l_M_BUS_MILES := nvl(per_formula_functions.get_number('M_BUS_MILES'),0);
1438: l_B_BUS_MILES := nvl(per_formula_functions.get_number('B_BUS_MILES'),0);
1439: l_C_RATE1 := nvl(per_formula_functions.get_number('C_RATE1'),0);
1440: l_C_RATE2 := nvl(per_formula_functions.get_number('C_RATE2'),0);
1433: l_ce Number;
1434: begin
1435: -- hr_utility.trace_on(null,'AMAP');
1436: l_C_BUS_MILES := nvl(per_formula_functions.get_number('C_BUS_MILES'),0);
1437: l_M_BUS_MILES := nvl(per_formula_functions.get_number('M_BUS_MILES'),0);
1438: l_B_BUS_MILES := nvl(per_formula_functions.get_number('B_BUS_MILES'),0);
1439: l_C_RATE1 := nvl(per_formula_functions.get_number('C_RATE1'),0);
1440: l_C_RATE2 := nvl(per_formula_functions.get_number('C_RATE2'),0);
1441: l_M_RATE1 := nvl(per_formula_functions.get_number('M_RATE1'),0);
1434: begin
1435: -- hr_utility.trace_on(null,'AMAP');
1436: l_C_BUS_MILES := nvl(per_formula_functions.get_number('C_BUS_MILES'),0);
1437: l_M_BUS_MILES := nvl(per_formula_functions.get_number('M_BUS_MILES'),0);
1438: l_B_BUS_MILES := nvl(per_formula_functions.get_number('B_BUS_MILES'),0);
1439: l_C_RATE1 := nvl(per_formula_functions.get_number('C_RATE1'),0);
1440: l_C_RATE2 := nvl(per_formula_functions.get_number('C_RATE2'),0);
1441: l_M_RATE1 := nvl(per_formula_functions.get_number('M_RATE1'),0);
1442: l_M_RATE2 := nvl(per_formula_functions.get_number('M_RATE2'),0);
1435: -- hr_utility.trace_on(null,'AMAP');
1436: l_C_BUS_MILES := nvl(per_formula_functions.get_number('C_BUS_MILES'),0);
1437: l_M_BUS_MILES := nvl(per_formula_functions.get_number('M_BUS_MILES'),0);
1438: l_B_BUS_MILES := nvl(per_formula_functions.get_number('B_BUS_MILES'),0);
1439: l_C_RATE1 := nvl(per_formula_functions.get_number('C_RATE1'),0);
1440: l_C_RATE2 := nvl(per_formula_functions.get_number('C_RATE2'),0);
1441: l_M_RATE1 := nvl(per_formula_functions.get_number('M_RATE1'),0);
1442: l_M_RATE2 := nvl(per_formula_functions.get_number('M_RATE2'),0);
1443: l_B_RATE1 := nvl(per_formula_functions.get_number('B_RATE1'),0);
1436: l_C_BUS_MILES := nvl(per_formula_functions.get_number('C_BUS_MILES'),0);
1437: l_M_BUS_MILES := nvl(per_formula_functions.get_number('M_BUS_MILES'),0);
1438: l_B_BUS_MILES := nvl(per_formula_functions.get_number('B_BUS_MILES'),0);
1439: l_C_RATE1 := nvl(per_formula_functions.get_number('C_RATE1'),0);
1440: l_C_RATE2 := nvl(per_formula_functions.get_number('C_RATE2'),0);
1441: l_M_RATE1 := nvl(per_formula_functions.get_number('M_RATE1'),0);
1442: l_M_RATE2 := nvl(per_formula_functions.get_number('M_RATE2'),0);
1443: l_B_RATE1 := nvl(per_formula_functions.get_number('B_RATE1'),0);
1444: l_B_RATE2 := nvl(per_formula_functions.get_number('B_RATE2'),0);
1437: l_M_BUS_MILES := nvl(per_formula_functions.get_number('M_BUS_MILES'),0);
1438: l_B_BUS_MILES := nvl(per_formula_functions.get_number('B_BUS_MILES'),0);
1439: l_C_RATE1 := nvl(per_formula_functions.get_number('C_RATE1'),0);
1440: l_C_RATE2 := nvl(per_formula_functions.get_number('C_RATE2'),0);
1441: l_M_RATE1 := nvl(per_formula_functions.get_number('M_RATE1'),0);
1442: l_M_RATE2 := nvl(per_formula_functions.get_number('M_RATE2'),0);
1443: l_B_RATE1 := nvl(per_formula_functions.get_number('B_RATE1'),0);
1444: l_B_RATE2 := nvl(per_formula_functions.get_number('B_RATE2'),0);
1445: l_C_MILEAGE_PAYMENTS := nvl(per_formula_functions.get_number('C_MILEAGE_PAYMENTS'),0);
1438: l_B_BUS_MILES := nvl(per_formula_functions.get_number('B_BUS_MILES'),0);
1439: l_C_RATE1 := nvl(per_formula_functions.get_number('C_RATE1'),0);
1440: l_C_RATE2 := nvl(per_formula_functions.get_number('C_RATE2'),0);
1441: l_M_RATE1 := nvl(per_formula_functions.get_number('M_RATE1'),0);
1442: l_M_RATE2 := nvl(per_formula_functions.get_number('M_RATE2'),0);
1443: l_B_RATE1 := nvl(per_formula_functions.get_number('B_RATE1'),0);
1444: l_B_RATE2 := nvl(per_formula_functions.get_number('B_RATE2'),0);
1445: l_C_MILEAGE_PAYMENTS := nvl(per_formula_functions.get_number('C_MILEAGE_PAYMENTS'),0);
1446: l_B_MILEAGE_PAYMENTS := nvl(per_formula_functions.get_number('B_MILEAGE_PAYMENTS'),0);
1439: l_C_RATE1 := nvl(per_formula_functions.get_number('C_RATE1'),0);
1440: l_C_RATE2 := nvl(per_formula_functions.get_number('C_RATE2'),0);
1441: l_M_RATE1 := nvl(per_formula_functions.get_number('M_RATE1'),0);
1442: l_M_RATE2 := nvl(per_formula_functions.get_number('M_RATE2'),0);
1443: l_B_RATE1 := nvl(per_formula_functions.get_number('B_RATE1'),0);
1444: l_B_RATE2 := nvl(per_formula_functions.get_number('B_RATE2'),0);
1445: l_C_MILEAGE_PAYMENTS := nvl(per_formula_functions.get_number('C_MILEAGE_PAYMENTS'),0);
1446: l_B_MILEAGE_PAYMENTS := nvl(per_formula_functions.get_number('B_MILEAGE_PAYMENTS'),0);
1447: l_M_MILEAGE_PAYMENTS := nvl(per_formula_functions.get_number('M_MILEAGE_PAYMENTS'),0);
1440: l_C_RATE2 := nvl(per_formula_functions.get_number('C_RATE2'),0);
1441: l_M_RATE1 := nvl(per_formula_functions.get_number('M_RATE1'),0);
1442: l_M_RATE2 := nvl(per_formula_functions.get_number('M_RATE2'),0);
1443: l_B_RATE1 := nvl(per_formula_functions.get_number('B_RATE1'),0);
1444: l_B_RATE2 := nvl(per_formula_functions.get_number('B_RATE2'),0);
1445: l_C_MILEAGE_PAYMENTS := nvl(per_formula_functions.get_number('C_MILEAGE_PAYMENTS'),0);
1446: l_B_MILEAGE_PAYMENTS := nvl(per_formula_functions.get_number('B_MILEAGE_PAYMENTS'),0);
1447: l_M_MILEAGE_PAYMENTS := nvl(per_formula_functions.get_number('M_MILEAGE_PAYMENTS'),0);
1448: l_C_TAX_DEDUCTED := nvl(per_formula_functions.get_number('C_TAX_DEDUCTED'),0);
1441: l_M_RATE1 := nvl(per_formula_functions.get_number('M_RATE1'),0);
1442: l_M_RATE2 := nvl(per_formula_functions.get_number('M_RATE2'),0);
1443: l_B_RATE1 := nvl(per_formula_functions.get_number('B_RATE1'),0);
1444: l_B_RATE2 := nvl(per_formula_functions.get_number('B_RATE2'),0);
1445: l_C_MILEAGE_PAYMENTS := nvl(per_formula_functions.get_number('C_MILEAGE_PAYMENTS'),0);
1446: l_B_MILEAGE_PAYMENTS := nvl(per_formula_functions.get_number('B_MILEAGE_PAYMENTS'),0);
1447: l_M_MILEAGE_PAYMENTS := nvl(per_formula_functions.get_number('M_MILEAGE_PAYMENTS'),0);
1448: l_C_TAX_DEDUCTED := nvl(per_formula_functions.get_number('C_TAX_DEDUCTED'),0);
1449: l_B_TAX_DEDUCTED := nvl(per_formula_functions.get_number('B_TAX_DEDUCTED'),0);
1442: l_M_RATE2 := nvl(per_formula_functions.get_number('M_RATE2'),0);
1443: l_B_RATE1 := nvl(per_formula_functions.get_number('B_RATE1'),0);
1444: l_B_RATE2 := nvl(per_formula_functions.get_number('B_RATE2'),0);
1445: l_C_MILEAGE_PAYMENTS := nvl(per_formula_functions.get_number('C_MILEAGE_PAYMENTS'),0);
1446: l_B_MILEAGE_PAYMENTS := nvl(per_formula_functions.get_number('B_MILEAGE_PAYMENTS'),0);
1447: l_M_MILEAGE_PAYMENTS := nvl(per_formula_functions.get_number('M_MILEAGE_PAYMENTS'),0);
1448: l_C_TAX_DEDUCTED := nvl(per_formula_functions.get_number('C_TAX_DEDUCTED'),0);
1449: l_B_TAX_DEDUCTED := nvl(per_formula_functions.get_number('B_TAX_DEDUCTED'),0);
1450: l_M_TAX_DEDUCTED := nvl(per_formula_functions.get_number('M_TAX_DEDUCTED'),0);
1443: l_B_RATE1 := nvl(per_formula_functions.get_number('B_RATE1'),0);
1444: l_B_RATE2 := nvl(per_formula_functions.get_number('B_RATE2'),0);
1445: l_C_MILEAGE_PAYMENTS := nvl(per_formula_functions.get_number('C_MILEAGE_PAYMENTS'),0);
1446: l_B_MILEAGE_PAYMENTS := nvl(per_formula_functions.get_number('B_MILEAGE_PAYMENTS'),0);
1447: l_M_MILEAGE_PAYMENTS := nvl(per_formula_functions.get_number('M_MILEAGE_PAYMENTS'),0);
1448: l_C_TAX_DEDUCTED := nvl(per_formula_functions.get_number('C_TAX_DEDUCTED'),0);
1449: l_B_TAX_DEDUCTED := nvl(per_formula_functions.get_number('B_TAX_DEDUCTED'),0);
1450: l_M_TAX_DEDUCTED := nvl(per_formula_functions.get_number('M_TAX_DEDUCTED'),0);
1451: l_PASSENGER_PAYMENTS := nvl(per_formula_functions.get_number('PASSENGER_PAYMENTS'),0);
1444: l_B_RATE2 := nvl(per_formula_functions.get_number('B_RATE2'),0);
1445: l_C_MILEAGE_PAYMENTS := nvl(per_formula_functions.get_number('C_MILEAGE_PAYMENTS'),0);
1446: l_B_MILEAGE_PAYMENTS := nvl(per_formula_functions.get_number('B_MILEAGE_PAYMENTS'),0);
1447: l_M_MILEAGE_PAYMENTS := nvl(per_formula_functions.get_number('M_MILEAGE_PAYMENTS'),0);
1448: l_C_TAX_DEDUCTED := nvl(per_formula_functions.get_number('C_TAX_DEDUCTED'),0);
1449: l_B_TAX_DEDUCTED := nvl(per_formula_functions.get_number('B_TAX_DEDUCTED'),0);
1450: l_M_TAX_DEDUCTED := nvl(per_formula_functions.get_number('M_TAX_DEDUCTED'),0);
1451: l_PASSENGER_PAYMENTS := nvl(per_formula_functions.get_number('PASSENGER_PAYMENTS'),0);
1452: l_PASSENGER_BUS_MILES := nvl(per_formula_functions.get_number('PASSENGER_BUS_MILES'),0);
1445: l_C_MILEAGE_PAYMENTS := nvl(per_formula_functions.get_number('C_MILEAGE_PAYMENTS'),0);
1446: l_B_MILEAGE_PAYMENTS := nvl(per_formula_functions.get_number('B_MILEAGE_PAYMENTS'),0);
1447: l_M_MILEAGE_PAYMENTS := nvl(per_formula_functions.get_number('M_MILEAGE_PAYMENTS'),0);
1448: l_C_TAX_DEDUCTED := nvl(per_formula_functions.get_number('C_TAX_DEDUCTED'),0);
1449: l_B_TAX_DEDUCTED := nvl(per_formula_functions.get_number('B_TAX_DEDUCTED'),0);
1450: l_M_TAX_DEDUCTED := nvl(per_formula_functions.get_number('M_TAX_DEDUCTED'),0);
1451: l_PASSENGER_PAYMENTS := nvl(per_formula_functions.get_number('PASSENGER_PAYMENTS'),0);
1452: l_PASSENGER_BUS_MILES := nvl(per_formula_functions.get_number('PASSENGER_BUS_MILES'),0);
1453: l_PASSENGER_BUS_MILE_AMT := nvl(per_formula_functions.get_number('PASSENGER_BUS_MILE_AMT'),0);
1446: l_B_MILEAGE_PAYMENTS := nvl(per_formula_functions.get_number('B_MILEAGE_PAYMENTS'),0);
1447: l_M_MILEAGE_PAYMENTS := nvl(per_formula_functions.get_number('M_MILEAGE_PAYMENTS'),0);
1448: l_C_TAX_DEDUCTED := nvl(per_formula_functions.get_number('C_TAX_DEDUCTED'),0);
1449: l_B_TAX_DEDUCTED := nvl(per_formula_functions.get_number('B_TAX_DEDUCTED'),0);
1450: l_M_TAX_DEDUCTED := nvl(per_formula_functions.get_number('M_TAX_DEDUCTED'),0);
1451: l_PASSENGER_PAYMENTS := nvl(per_formula_functions.get_number('PASSENGER_PAYMENTS'),0);
1452: l_PASSENGER_BUS_MILES := nvl(per_formula_functions.get_number('PASSENGER_BUS_MILES'),0);
1453: l_PASSENGER_BUS_MILE_AMT := nvl(per_formula_functions.get_number('PASSENGER_BUS_MILE_AMT'),0);
1454:
1447: l_M_MILEAGE_PAYMENTS := nvl(per_formula_functions.get_number('M_MILEAGE_PAYMENTS'),0);
1448: l_C_TAX_DEDUCTED := nvl(per_formula_functions.get_number('C_TAX_DEDUCTED'),0);
1449: l_B_TAX_DEDUCTED := nvl(per_formula_functions.get_number('B_TAX_DEDUCTED'),0);
1450: l_M_TAX_DEDUCTED := nvl(per_formula_functions.get_number('M_TAX_DEDUCTED'),0);
1451: l_PASSENGER_PAYMENTS := nvl(per_formula_functions.get_number('PASSENGER_PAYMENTS'),0);
1452: l_PASSENGER_BUS_MILES := nvl(per_formula_functions.get_number('PASSENGER_BUS_MILES'),0);
1453: l_PASSENGER_BUS_MILE_AMT := nvl(per_formula_functions.get_number('PASSENGER_BUS_MILE_AMT'),0);
1454:
1455: l_c_net_allowance := l_C_MILEAGE_PAYMENTS - l_C_TAX_DEDUCTED;
1448: l_C_TAX_DEDUCTED := nvl(per_formula_functions.get_number('C_TAX_DEDUCTED'),0);
1449: l_B_TAX_DEDUCTED := nvl(per_formula_functions.get_number('B_TAX_DEDUCTED'),0);
1450: l_M_TAX_DEDUCTED := nvl(per_formula_functions.get_number('M_TAX_DEDUCTED'),0);
1451: l_PASSENGER_PAYMENTS := nvl(per_formula_functions.get_number('PASSENGER_PAYMENTS'),0);
1452: l_PASSENGER_BUS_MILES := nvl(per_formula_functions.get_number('PASSENGER_BUS_MILES'),0);
1453: l_PASSENGER_BUS_MILE_AMT := nvl(per_formula_functions.get_number('PASSENGER_BUS_MILE_AMT'),0);
1454:
1455: l_c_net_allowance := l_C_MILEAGE_PAYMENTS - l_C_TAX_DEDUCTED;
1456: if l_c_net_allowance < 0
1449: l_B_TAX_DEDUCTED := nvl(per_formula_functions.get_number('B_TAX_DEDUCTED'),0);
1450: l_M_TAX_DEDUCTED := nvl(per_formula_functions.get_number('M_TAX_DEDUCTED'),0);
1451: l_PASSENGER_PAYMENTS := nvl(per_formula_functions.get_number('PASSENGER_PAYMENTS'),0);
1452: l_PASSENGER_BUS_MILES := nvl(per_formula_functions.get_number('PASSENGER_BUS_MILES'),0);
1453: l_PASSENGER_BUS_MILE_AMT := nvl(per_formula_functions.get_number('PASSENGER_BUS_MILE_AMT'),0);
1454:
1455: l_c_net_allowance := l_C_MILEAGE_PAYMENTS - l_C_TAX_DEDUCTED;
1456: if l_c_net_allowance < 0
1457: then
1537: p_effective_date => fnd_date.canonical_to_date(g_param_benefit_end_date),
1538: p_source_id => NULL,
1539: p_source_text => NULL,
1540: p_action_information_category => 'GB P11D ASSIGNMENT RESULTA',
1541: p_action_information1 => per_formula_functions.get_text('A_DESC'),
1542: p_action_information2 => per_formula_functions.get_number('A_COST'),
1543: p_action_information3 => per_formula_functions.get_number('A_AMG'),
1544: p_action_information4 => per_formula_functions.get_number('A_CE'),
1545: p_action_information5 => per_formula_functions.get_text('B_DESC'),
1538: p_source_id => NULL,
1539: p_source_text => NULL,
1540: p_action_information_category => 'GB P11D ASSIGNMENT RESULTA',
1541: p_action_information1 => per_formula_functions.get_text('A_DESC'),
1542: p_action_information2 => per_formula_functions.get_number('A_COST'),
1543: p_action_information3 => per_formula_functions.get_number('A_AMG'),
1544: p_action_information4 => per_formula_functions.get_number('A_CE'),
1545: p_action_information5 => per_formula_functions.get_text('B_DESC'),
1546: p_action_information6 => per_formula_functions.get_number('B_CE'),
1539: p_source_text => NULL,
1540: p_action_information_category => 'GB P11D ASSIGNMENT RESULTA',
1541: p_action_information1 => per_formula_functions.get_text('A_DESC'),
1542: p_action_information2 => per_formula_functions.get_number('A_COST'),
1543: p_action_information3 => per_formula_functions.get_number('A_AMG'),
1544: p_action_information4 => per_formula_functions.get_number('A_CE'),
1545: p_action_information5 => per_formula_functions.get_text('B_DESC'),
1546: p_action_information6 => per_formula_functions.get_number('B_CE'),
1547: p_action_information7 => per_formula_functions.get_number('B_TNP'),
1540: p_action_information_category => 'GB P11D ASSIGNMENT RESULTA',
1541: p_action_information1 => per_formula_functions.get_text('A_DESC'),
1542: p_action_information2 => per_formula_functions.get_number('A_COST'),
1543: p_action_information3 => per_formula_functions.get_number('A_AMG'),
1544: p_action_information4 => per_formula_functions.get_number('A_CE'),
1545: p_action_information5 => per_formula_functions.get_text('B_DESC'),
1546: p_action_information6 => per_formula_functions.get_number('B_CE'),
1547: p_action_information7 => per_formula_functions.get_number('B_TNP'),
1548: p_action_information8 => per_formula_functions.get_number('C_COST'),
1541: p_action_information1 => per_formula_functions.get_text('A_DESC'),
1542: p_action_information2 => per_formula_functions.get_number('A_COST'),
1543: p_action_information3 => per_formula_functions.get_number('A_AMG'),
1544: p_action_information4 => per_formula_functions.get_number('A_CE'),
1545: p_action_information5 => per_formula_functions.get_text('B_DESC'),
1546: p_action_information6 => per_formula_functions.get_number('B_CE'),
1547: p_action_information7 => per_formula_functions.get_number('B_TNP'),
1548: p_action_information8 => per_formula_functions.get_number('C_COST'),
1549: p_action_information9 => per_formula_functions.get_number('C_AMG'),
1542: p_action_information2 => per_formula_functions.get_number('A_COST'),
1543: p_action_information3 => per_formula_functions.get_number('A_AMG'),
1544: p_action_information4 => per_formula_functions.get_number('A_CE'),
1545: p_action_information5 => per_formula_functions.get_text('B_DESC'),
1546: p_action_information6 => per_formula_functions.get_number('B_CE'),
1547: p_action_information7 => per_formula_functions.get_number('B_TNP'),
1548: p_action_information8 => per_formula_functions.get_number('C_COST'),
1549: p_action_information9 => per_formula_functions.get_number('C_AMG'),
1550: p_action_information10 => per_formula_functions.get_number('C_CE'),
1543: p_action_information3 => per_formula_functions.get_number('A_AMG'),
1544: p_action_information4 => per_formula_functions.get_number('A_CE'),
1545: p_action_information5 => per_formula_functions.get_text('B_DESC'),
1546: p_action_information6 => per_formula_functions.get_number('B_CE'),
1547: p_action_information7 => per_formula_functions.get_number('B_TNP'),
1548: p_action_information8 => per_formula_functions.get_number('C_COST'),
1549: p_action_information9 => per_formula_functions.get_number('C_AMG'),
1550: p_action_information10 => per_formula_functions.get_number('C_CE'),
1551: p_action_information11 => per_formula_functions.get_number('D_CE'),
1544: p_action_information4 => per_formula_functions.get_number('A_CE'),
1545: p_action_information5 => per_formula_functions.get_text('B_DESC'),
1546: p_action_information6 => per_formula_functions.get_number('B_CE'),
1547: p_action_information7 => per_formula_functions.get_number('B_TNP'),
1548: p_action_information8 => per_formula_functions.get_number('C_COST'),
1549: p_action_information9 => per_formula_functions.get_number('C_AMG'),
1550: p_action_information10 => per_formula_functions.get_number('C_CE'),
1551: p_action_information11 => per_formula_functions.get_number('D_CE'),
1552: p_action_information12 => calculate_amap_ce ,
1545: p_action_information5 => per_formula_functions.get_text('B_DESC'),
1546: p_action_information6 => per_formula_functions.get_number('B_CE'),
1547: p_action_information7 => per_formula_functions.get_number('B_TNP'),
1548: p_action_information8 => per_formula_functions.get_number('C_COST'),
1549: p_action_information9 => per_formula_functions.get_number('C_AMG'),
1550: p_action_information10 => per_formula_functions.get_number('C_CE'),
1551: p_action_information11 => per_formula_functions.get_number('D_CE'),
1552: p_action_information12 => calculate_amap_ce ,
1553: p_action_information13 => per_formula_functions.get_number('F_TCCE'),
1546: p_action_information6 => per_formula_functions.get_number('B_CE'),
1547: p_action_information7 => per_formula_functions.get_number('B_TNP'),
1548: p_action_information8 => per_formula_functions.get_number('C_COST'),
1549: p_action_information9 => per_formula_functions.get_number('C_AMG'),
1550: p_action_information10 => per_formula_functions.get_number('C_CE'),
1551: p_action_information11 => per_formula_functions.get_number('D_CE'),
1552: p_action_information12 => calculate_amap_ce ,
1553: p_action_information13 => per_formula_functions.get_number('F_TCCE'),
1554: p_action_information14 => per_formula_functions.get_number('F_TFCE'),
1547: p_action_information7 => per_formula_functions.get_number('B_TNP'),
1548: p_action_information8 => per_formula_functions.get_number('C_COST'),
1549: p_action_information9 => per_formula_functions.get_number('C_AMG'),
1550: p_action_information10 => per_formula_functions.get_number('C_CE'),
1551: p_action_information11 => per_formula_functions.get_number('D_CE'),
1552: p_action_information12 => calculate_amap_ce ,
1553: p_action_information13 => per_formula_functions.get_number('F_TCCE'),
1554: p_action_information14 => per_formula_functions.get_number('F_TFCE'),
1555: p_action_information15 => per_formula_functions.get_number('G_CE'),
1549: p_action_information9 => per_formula_functions.get_number('C_AMG'),
1550: p_action_information10 => per_formula_functions.get_number('C_CE'),
1551: p_action_information11 => per_formula_functions.get_number('D_CE'),
1552: p_action_information12 => calculate_amap_ce ,
1553: p_action_information13 => per_formula_functions.get_number('F_TCCE'),
1554: p_action_information14 => per_formula_functions.get_number('F_TFCE'),
1555: p_action_information15 => per_formula_functions.get_number('G_CE'),
1556: p_action_information16 => per_formula_functions.get_number('I_COST'),
1557: p_action_information17 => per_formula_functions.get_number('I_AMG'),
1550: p_action_information10 => per_formula_functions.get_number('C_CE'),
1551: p_action_information11 => per_formula_functions.get_number('D_CE'),
1552: p_action_information12 => calculate_amap_ce ,
1553: p_action_information13 => per_formula_functions.get_number('F_TCCE'),
1554: p_action_information14 => per_formula_functions.get_number('F_TFCE'),
1555: p_action_information15 => per_formula_functions.get_number('G_CE'),
1556: p_action_information16 => per_formula_functions.get_number('I_COST'),
1557: p_action_information17 => per_formula_functions.get_number('I_AMG'),
1558: p_action_information18 => per_formula_functions.get_number('I_CE'),
1551: p_action_information11 => per_formula_functions.get_number('D_CE'),
1552: p_action_information12 => calculate_amap_ce ,
1553: p_action_information13 => per_formula_functions.get_number('F_TCCE'),
1554: p_action_information14 => per_formula_functions.get_number('F_TFCE'),
1555: p_action_information15 => per_formula_functions.get_number('G_CE'),
1556: p_action_information16 => per_formula_functions.get_number('I_COST'),
1557: p_action_information17 => per_formula_functions.get_number('I_AMG'),
1558: p_action_information18 => per_formula_functions.get_number('I_CE'),
1559: p_action_information19 => per_formula_functions.get_number('J_CE'),
1552: p_action_information12 => calculate_amap_ce ,
1553: p_action_information13 => per_formula_functions.get_number('F_TCCE'),
1554: p_action_information14 => per_formula_functions.get_number('F_TFCE'),
1555: p_action_information15 => per_formula_functions.get_number('G_CE'),
1556: p_action_information16 => per_formula_functions.get_number('I_COST'),
1557: p_action_information17 => per_formula_functions.get_number('I_AMG'),
1558: p_action_information18 => per_formula_functions.get_number('I_CE'),
1559: p_action_information19 => per_formula_functions.get_number('J_CE'),
1560: p_action_information20 => per_formula_functions.get_number('K_COST'),
1553: p_action_information13 => per_formula_functions.get_number('F_TCCE'),
1554: p_action_information14 => per_formula_functions.get_number('F_TFCE'),
1555: p_action_information15 => per_formula_functions.get_number('G_CE'),
1556: p_action_information16 => per_formula_functions.get_number('I_COST'),
1557: p_action_information17 => per_formula_functions.get_number('I_AMG'),
1558: p_action_information18 => per_formula_functions.get_number('I_CE'),
1559: p_action_information19 => per_formula_functions.get_number('J_CE'),
1560: p_action_information20 => per_formula_functions.get_number('K_COST'),
1561: p_action_information21 => per_formula_functions.get_number('K_AMG'),
1554: p_action_information14 => per_formula_functions.get_number('F_TFCE'),
1555: p_action_information15 => per_formula_functions.get_number('G_CE'),
1556: p_action_information16 => per_formula_functions.get_number('I_COST'),
1557: p_action_information17 => per_formula_functions.get_number('I_AMG'),
1558: p_action_information18 => per_formula_functions.get_number('I_CE'),
1559: p_action_information19 => per_formula_functions.get_number('J_CE'),
1560: p_action_information20 => per_formula_functions.get_number('K_COST'),
1561: p_action_information21 => per_formula_functions.get_number('K_AMG'),
1562: p_action_information22 => per_formula_functions.get_number('K_CE'),
1555: p_action_information15 => per_formula_functions.get_number('G_CE'),
1556: p_action_information16 => per_formula_functions.get_number('I_COST'),
1557: p_action_information17 => per_formula_functions.get_number('I_AMG'),
1558: p_action_information18 => per_formula_functions.get_number('I_CE'),
1559: p_action_information19 => per_formula_functions.get_number('J_CE'),
1560: p_action_information20 => per_formula_functions.get_number('K_COST'),
1561: p_action_information21 => per_formula_functions.get_number('K_AMG'),
1562: p_action_information22 => per_formula_functions.get_number('K_CE'),
1563: p_action_information23 => per_formula_functions.get_text('L_DESC'),
1556: p_action_information16 => per_formula_functions.get_number('I_COST'),
1557: p_action_information17 => per_formula_functions.get_number('I_AMG'),
1558: p_action_information18 => per_formula_functions.get_number('I_CE'),
1559: p_action_information19 => per_formula_functions.get_number('J_CE'),
1560: p_action_information20 => per_formula_functions.get_number('K_COST'),
1561: p_action_information21 => per_formula_functions.get_number('K_AMG'),
1562: p_action_information22 => per_formula_functions.get_number('K_CE'),
1563: p_action_information23 => per_formula_functions.get_text('L_DESC'),
1564: p_action_information24 => per_formula_functions.get_number('L_COST'),
1557: p_action_information17 => per_formula_functions.get_number('I_AMG'),
1558: p_action_information18 => per_formula_functions.get_number('I_CE'),
1559: p_action_information19 => per_formula_functions.get_number('J_CE'),
1560: p_action_information20 => per_formula_functions.get_number('K_COST'),
1561: p_action_information21 => per_formula_functions.get_number('K_AMG'),
1562: p_action_information22 => per_formula_functions.get_number('K_CE'),
1563: p_action_information23 => per_formula_functions.get_text('L_DESC'),
1564: p_action_information24 => per_formula_functions.get_number('L_COST'),
1565: p_action_information25 => per_formula_functions.get_number('L_AMG'),
1558: p_action_information18 => per_formula_functions.get_number('I_CE'),
1559: p_action_information19 => per_formula_functions.get_number('J_CE'),
1560: p_action_information20 => per_formula_functions.get_number('K_COST'),
1561: p_action_information21 => per_formula_functions.get_number('K_AMG'),
1562: p_action_information22 => per_formula_functions.get_number('K_CE'),
1563: p_action_information23 => per_formula_functions.get_text('L_DESC'),
1564: p_action_information24 => per_formula_functions.get_number('L_COST'),
1565: p_action_information25 => per_formula_functions.get_number('L_AMG'),
1566: p_action_information26 => per_formula_functions.get_number('L_CE'),
1559: p_action_information19 => per_formula_functions.get_number('J_CE'),
1560: p_action_information20 => per_formula_functions.get_number('K_COST'),
1561: p_action_information21 => per_formula_functions.get_number('K_AMG'),
1562: p_action_information22 => per_formula_functions.get_number('K_CE'),
1563: p_action_information23 => per_formula_functions.get_text('L_DESC'),
1564: p_action_information24 => per_formula_functions.get_number('L_COST'),
1565: p_action_information25 => per_formula_functions.get_number('L_AMG'),
1566: p_action_information26 => per_formula_functions.get_number('L_CE'),
1567: p_action_information27 => per_formula_functions.get_text('M_SHARES'),
1560: p_action_information20 => per_formula_functions.get_number('K_COST'),
1561: p_action_information21 => per_formula_functions.get_number('K_AMG'),
1562: p_action_information22 => per_formula_functions.get_number('K_CE'),
1563: p_action_information23 => per_formula_functions.get_text('L_DESC'),
1564: p_action_information24 => per_formula_functions.get_number('L_COST'),
1565: p_action_information25 => per_formula_functions.get_number('L_AMG'),
1566: p_action_information26 => per_formula_functions.get_number('L_CE'),
1567: p_action_information27 => per_formula_functions.get_text('M_SHARES'),
1568: p_action_information28 => per_formula_functions.get_number('H_CE1'),
1561: p_action_information21 => per_formula_functions.get_number('K_AMG'),
1562: p_action_information22 => per_formula_functions.get_number('K_CE'),
1563: p_action_information23 => per_formula_functions.get_text('L_DESC'),
1564: p_action_information24 => per_formula_functions.get_number('L_COST'),
1565: p_action_information25 => per_formula_functions.get_number('L_AMG'),
1566: p_action_information26 => per_formula_functions.get_number('L_CE'),
1567: p_action_information27 => per_formula_functions.get_text('M_SHARES'),
1568: p_action_information28 => per_formula_functions.get_number('H_CE1'),
1569: p_action_information29 => per_formula_functions.get_number('H_COUNT'),
1562: p_action_information22 => per_formula_functions.get_number('K_CE'),
1563: p_action_information23 => per_formula_functions.get_text('L_DESC'),
1564: p_action_information24 => per_formula_functions.get_number('L_COST'),
1565: p_action_information25 => per_formula_functions.get_number('L_AMG'),
1566: p_action_information26 => per_formula_functions.get_number('L_CE'),
1567: p_action_information27 => per_formula_functions.get_text('M_SHARES'),
1568: p_action_information28 => per_formula_functions.get_number('H_CE1'),
1569: p_action_information29 => per_formula_functions.get_number('H_COUNT'),
1570: p_action_information30 => per_formula_functions.get_number('F_COUNT') );
1563: p_action_information23 => per_formula_functions.get_text('L_DESC'),
1564: p_action_information24 => per_formula_functions.get_number('L_COST'),
1565: p_action_information25 => per_formula_functions.get_number('L_AMG'),
1566: p_action_information26 => per_formula_functions.get_number('L_CE'),
1567: p_action_information27 => per_formula_functions.get_text('M_SHARES'),
1568: p_action_information28 => per_formula_functions.get_number('H_CE1'),
1569: p_action_information29 => per_formula_functions.get_number('H_COUNT'),
1570: p_action_information30 => per_formula_functions.get_number('F_COUNT') );
1571:
1564: p_action_information24 => per_formula_functions.get_number('L_COST'),
1565: p_action_information25 => per_formula_functions.get_number('L_AMG'),
1566: p_action_information26 => per_formula_functions.get_number('L_CE'),
1567: p_action_information27 => per_formula_functions.get_text('M_SHARES'),
1568: p_action_information28 => per_formula_functions.get_number('H_CE1'),
1569: p_action_information29 => per_formula_functions.get_number('H_COUNT'),
1570: p_action_information30 => per_formula_functions.get_number('F_COUNT') );
1571:
1572: --
1565: p_action_information25 => per_formula_functions.get_number('L_AMG'),
1566: p_action_information26 => per_formula_functions.get_number('L_CE'),
1567: p_action_information27 => per_formula_functions.get_text('M_SHARES'),
1568: p_action_information28 => per_formula_functions.get_number('H_CE1'),
1569: p_action_information29 => per_formula_functions.get_number('H_COUNT'),
1570: p_action_information30 => per_formula_functions.get_number('F_COUNT') );
1571:
1572: --
1573: pay_action_information_api.create_action_information(
1566: p_action_information26 => per_formula_functions.get_number('L_CE'),
1567: p_action_information27 => per_formula_functions.get_text('M_SHARES'),
1568: p_action_information28 => per_formula_functions.get_number('H_CE1'),
1569: p_action_information29 => per_formula_functions.get_number('H_COUNT'),
1570: p_action_information30 => per_formula_functions.get_number('F_COUNT') );
1571:
1572: --
1573: pay_action_information_api.create_action_information(
1574: p_action_information_id => l_action_info_id,
1578: p_effective_date => fnd_date.canonical_to_date(g_param_benefit_end_date),
1579: p_source_id => NULL,
1580: p_source_text => NULL,
1581: p_action_information_category => 'GB P11D ASSIGNMENT RESULTB',
1582: p_action_information1 => per_formula_functions.get_text('N_DESC'),
1583: p_action_information2 => per_formula_functions.get_number('N_COST'),
1584: p_action_information3 => per_formula_functions.get_number('N_AMG'),
1585: p_action_information4 => per_formula_functions.get_number('N_CE'),
1586: p_action_information5 => per_formula_functions.get_text('NA_DESC'),
1579: p_source_id => NULL,
1580: p_source_text => NULL,
1581: p_action_information_category => 'GB P11D ASSIGNMENT RESULTB',
1582: p_action_information1 => per_formula_functions.get_text('N_DESC'),
1583: p_action_information2 => per_formula_functions.get_number('N_COST'),
1584: p_action_information3 => per_formula_functions.get_number('N_AMG'),
1585: p_action_information4 => per_formula_functions.get_number('N_CE'),
1586: p_action_information5 => per_formula_functions.get_text('NA_DESC'),
1587: p_action_information6 => per_formula_functions.get_number('NA_COST'),
1580: p_source_text => NULL,
1581: p_action_information_category => 'GB P11D ASSIGNMENT RESULTB',
1582: p_action_information1 => per_formula_functions.get_text('N_DESC'),
1583: p_action_information2 => per_formula_functions.get_number('N_COST'),
1584: p_action_information3 => per_formula_functions.get_number('N_AMG'),
1585: p_action_information4 => per_formula_functions.get_number('N_CE'),
1586: p_action_information5 => per_formula_functions.get_text('NA_DESC'),
1587: p_action_information6 => per_formula_functions.get_number('NA_COST'),
1588: p_action_information7 => per_formula_functions.get_number('NA_AMG'),
1581: p_action_information_category => 'GB P11D ASSIGNMENT RESULTB',
1582: p_action_information1 => per_formula_functions.get_text('N_DESC'),
1583: p_action_information2 => per_formula_functions.get_number('N_COST'),
1584: p_action_information3 => per_formula_functions.get_number('N_AMG'),
1585: p_action_information4 => per_formula_functions.get_number('N_CE'),
1586: p_action_information5 => per_formula_functions.get_text('NA_DESC'),
1587: p_action_information6 => per_formula_functions.get_number('NA_COST'),
1588: p_action_information7 => per_formula_functions.get_number('NA_AMG'),
1589: p_action_information8 => per_formula_functions.get_number('NA_CE'),
1582: p_action_information1 => per_formula_functions.get_text('N_DESC'),
1583: p_action_information2 => per_formula_functions.get_number('N_COST'),
1584: p_action_information3 => per_formula_functions.get_number('N_AMG'),
1585: p_action_information4 => per_formula_functions.get_number('N_CE'),
1586: p_action_information5 => per_formula_functions.get_text('NA_DESC'),
1587: p_action_information6 => per_formula_functions.get_number('NA_COST'),
1588: p_action_information7 => per_formula_functions.get_number('NA_AMG'),
1589: p_action_information8 => per_formula_functions.get_number('NA_CE'),
1590: p_action_information9 => per_formula_functions.get_number('N_TAXPAID'),
1583: p_action_information2 => per_formula_functions.get_number('N_COST'),
1584: p_action_information3 => per_formula_functions.get_number('N_AMG'),
1585: p_action_information4 => per_formula_functions.get_number('N_CE'),
1586: p_action_information5 => per_formula_functions.get_text('NA_DESC'),
1587: p_action_information6 => per_formula_functions.get_number('NA_COST'),
1588: p_action_information7 => per_formula_functions.get_number('NA_AMG'),
1589: p_action_information8 => per_formula_functions.get_number('NA_CE'),
1590: p_action_information9 => per_formula_functions.get_number('N_TAXPAID'),
1591: p_action_information10 => per_formula_functions.get_number('O1_COST'),
1584: p_action_information3 => per_formula_functions.get_number('N_AMG'),
1585: p_action_information4 => per_formula_functions.get_number('N_CE'),
1586: p_action_information5 => per_formula_functions.get_text('NA_DESC'),
1587: p_action_information6 => per_formula_functions.get_number('NA_COST'),
1588: p_action_information7 => per_formula_functions.get_number('NA_AMG'),
1589: p_action_information8 => per_formula_functions.get_number('NA_CE'),
1590: p_action_information9 => per_formula_functions.get_number('N_TAXPAID'),
1591: p_action_information10 => per_formula_functions.get_number('O1_COST'),
1592: p_action_information11 => per_formula_functions.get_number('O1_AMG'),
1585: p_action_information4 => per_formula_functions.get_number('N_CE'),
1586: p_action_information5 => per_formula_functions.get_text('NA_DESC'),
1587: p_action_information6 => per_formula_functions.get_number('NA_COST'),
1588: p_action_information7 => per_formula_functions.get_number('NA_AMG'),
1589: p_action_information8 => per_formula_functions.get_number('NA_CE'),
1590: p_action_information9 => per_formula_functions.get_number('N_TAXPAID'),
1591: p_action_information10 => per_formula_functions.get_number('O1_COST'),
1592: p_action_information11 => per_formula_functions.get_number('O1_AMG'),
1593: p_action_information12 => per_formula_functions.get_number('O1_CE'),
1586: p_action_information5 => per_formula_functions.get_text('NA_DESC'),
1587: p_action_information6 => per_formula_functions.get_number('NA_COST'),
1588: p_action_information7 => per_formula_functions.get_number('NA_AMG'),
1589: p_action_information8 => per_formula_functions.get_number('NA_CE'),
1590: p_action_information9 => per_formula_functions.get_number('N_TAXPAID'),
1591: p_action_information10 => per_formula_functions.get_number('O1_COST'),
1592: p_action_information11 => per_formula_functions.get_number('O1_AMG'),
1593: p_action_information12 => per_formula_functions.get_number('O1_CE'),
1594: p_action_information13 => per_formula_functions.get_number('O2_COST'),
1587: p_action_information6 => per_formula_functions.get_number('NA_COST'),
1588: p_action_information7 => per_formula_functions.get_number('NA_AMG'),
1589: p_action_information8 => per_formula_functions.get_number('NA_CE'),
1590: p_action_information9 => per_formula_functions.get_number('N_TAXPAID'),
1591: p_action_information10 => per_formula_functions.get_number('O1_COST'),
1592: p_action_information11 => per_formula_functions.get_number('O1_AMG'),
1593: p_action_information12 => per_formula_functions.get_number('O1_CE'),
1594: p_action_information13 => per_formula_functions.get_number('O2_COST'),
1595: p_action_information14 => per_formula_functions.get_number('O2_AMG'),
1588: p_action_information7 => per_formula_functions.get_number('NA_AMG'),
1589: p_action_information8 => per_formula_functions.get_number('NA_CE'),
1590: p_action_information9 => per_formula_functions.get_number('N_TAXPAID'),
1591: p_action_information10 => per_formula_functions.get_number('O1_COST'),
1592: p_action_information11 => per_formula_functions.get_number('O1_AMG'),
1593: p_action_information12 => per_formula_functions.get_number('O1_CE'),
1594: p_action_information13 => per_formula_functions.get_number('O2_COST'),
1595: p_action_information14 => per_formula_functions.get_number('O2_AMG'),
1596: p_action_information15 => per_formula_functions.get_number('O2_CE'),
1589: p_action_information8 => per_formula_functions.get_number('NA_CE'),
1590: p_action_information9 => per_formula_functions.get_number('N_TAXPAID'),
1591: p_action_information10 => per_formula_functions.get_number('O1_COST'),
1592: p_action_information11 => per_formula_functions.get_number('O1_AMG'),
1593: p_action_information12 => per_formula_functions.get_number('O1_CE'),
1594: p_action_information13 => per_formula_functions.get_number('O2_COST'),
1595: p_action_information14 => per_formula_functions.get_number('O2_AMG'),
1596: p_action_information15 => per_formula_functions.get_number('O2_CE'),
1597: p_action_information16 => per_formula_functions.get_text('O_TOI'),
1590: p_action_information9 => per_formula_functions.get_number('N_TAXPAID'),
1591: p_action_information10 => per_formula_functions.get_number('O1_COST'),
1592: p_action_information11 => per_formula_functions.get_number('O1_AMG'),
1593: p_action_information12 => per_formula_functions.get_number('O1_CE'),
1594: p_action_information13 => per_formula_functions.get_number('O2_COST'),
1595: p_action_information14 => per_formula_functions.get_number('O2_AMG'),
1596: p_action_information15 => per_formula_functions.get_number('O2_CE'),
1597: p_action_information16 => per_formula_functions.get_text('O_TOI'),
1598: p_action_information17 => per_formula_functions.get_number('O3_COST'),
1591: p_action_information10 => per_formula_functions.get_number('O1_COST'),
1592: p_action_information11 => per_formula_functions.get_number('O1_AMG'),
1593: p_action_information12 => per_formula_functions.get_number('O1_CE'),
1594: p_action_information13 => per_formula_functions.get_number('O2_COST'),
1595: p_action_information14 => per_formula_functions.get_number('O2_AMG'),
1596: p_action_information15 => per_formula_functions.get_number('O2_CE'),
1597: p_action_information16 => per_formula_functions.get_text('O_TOI'),
1598: p_action_information17 => per_formula_functions.get_number('O3_COST'),
1599: p_action_information18 => per_formula_functions.get_number('O3_AMG'),
1592: p_action_information11 => per_formula_functions.get_number('O1_AMG'),
1593: p_action_information12 => per_formula_functions.get_number('O1_CE'),
1594: p_action_information13 => per_formula_functions.get_number('O2_COST'),
1595: p_action_information14 => per_formula_functions.get_number('O2_AMG'),
1596: p_action_information15 => per_formula_functions.get_number('O2_CE'),
1597: p_action_information16 => per_formula_functions.get_text('O_TOI'),
1598: p_action_information17 => per_formula_functions.get_number('O3_COST'),
1599: p_action_information18 => per_formula_functions.get_number('O3_AMG'),
1600: p_action_information19 => per_formula_functions.get_number('O3_CE'),
1593: p_action_information12 => per_formula_functions.get_number('O1_CE'),
1594: p_action_information13 => per_formula_functions.get_number('O2_COST'),
1595: p_action_information14 => per_formula_functions.get_number('O2_AMG'),
1596: p_action_information15 => per_formula_functions.get_number('O2_CE'),
1597: p_action_information16 => per_formula_functions.get_text('O_TOI'),
1598: p_action_information17 => per_formula_functions.get_number('O3_COST'),
1599: p_action_information18 => per_formula_functions.get_number('O3_AMG'),
1600: p_action_information19 => per_formula_functions.get_number('O3_CE'),
1601: p_action_information20 => per_formula_functions.get_number('O4_COST'),
1594: p_action_information13 => per_formula_functions.get_number('O2_COST'),
1595: p_action_information14 => per_formula_functions.get_number('O2_AMG'),
1596: p_action_information15 => per_formula_functions.get_number('O2_CE'),
1597: p_action_information16 => per_formula_functions.get_text('O_TOI'),
1598: p_action_information17 => per_formula_functions.get_number('O3_COST'),
1599: p_action_information18 => per_formula_functions.get_number('O3_AMG'),
1600: p_action_information19 => per_formula_functions.get_number('O3_CE'),
1601: p_action_information20 => per_formula_functions.get_number('O4_COST'),
1602: p_action_information21 => per_formula_functions.get_number('O4_AMG'),
1595: p_action_information14 => per_formula_functions.get_number('O2_AMG'),
1596: p_action_information15 => per_formula_functions.get_number('O2_CE'),
1597: p_action_information16 => per_formula_functions.get_text('O_TOI'),
1598: p_action_information17 => per_formula_functions.get_number('O3_COST'),
1599: p_action_information18 => per_formula_functions.get_number('O3_AMG'),
1600: p_action_information19 => per_formula_functions.get_number('O3_CE'),
1601: p_action_information20 => per_formula_functions.get_number('O4_COST'),
1602: p_action_information21 => per_formula_functions.get_number('O4_AMG'),
1603: p_action_information22 => per_formula_functions.get_number('O4_CE'),
1596: p_action_information15 => per_formula_functions.get_number('O2_CE'),
1597: p_action_information16 => per_formula_functions.get_text('O_TOI'),
1598: p_action_information17 => per_formula_functions.get_number('O3_COST'),
1599: p_action_information18 => per_formula_functions.get_number('O3_AMG'),
1600: p_action_information19 => per_formula_functions.get_number('O3_CE'),
1601: p_action_information20 => per_formula_functions.get_number('O4_COST'),
1602: p_action_information21 => per_formula_functions.get_number('O4_AMG'),
1603: p_action_information22 => per_formula_functions.get_number('O4_CE'),
1604: p_action_information23 => per_formula_functions.get_number('O5_COST'),
1597: p_action_information16 => per_formula_functions.get_text('O_TOI'),
1598: p_action_information17 => per_formula_functions.get_number('O3_COST'),
1599: p_action_information18 => per_formula_functions.get_number('O3_AMG'),
1600: p_action_information19 => per_formula_functions.get_number('O3_CE'),
1601: p_action_information20 => per_formula_functions.get_number('O4_COST'),
1602: p_action_information21 => per_formula_functions.get_number('O4_AMG'),
1603: p_action_information22 => per_formula_functions.get_number('O4_CE'),
1604: p_action_information23 => per_formula_functions.get_number('O5_COST'),
1605: p_action_information24 => per_formula_functions.get_number('O5_AMG'),
1598: p_action_information17 => per_formula_functions.get_number('O3_COST'),
1599: p_action_information18 => per_formula_functions.get_number('O3_AMG'),
1600: p_action_information19 => per_formula_functions.get_number('O3_CE'),
1601: p_action_information20 => per_formula_functions.get_number('O4_COST'),
1602: p_action_information21 => per_formula_functions.get_number('O4_AMG'),
1603: p_action_information22 => per_formula_functions.get_number('O4_CE'),
1604: p_action_information23 => per_formula_functions.get_number('O5_COST'),
1605: p_action_information24 => per_formula_functions.get_number('O5_AMG'),
1606: p_action_information25 => per_formula_functions.get_number('O5_CE'),
1599: p_action_information18 => per_formula_functions.get_number('O3_AMG'),
1600: p_action_information19 => per_formula_functions.get_number('O3_CE'),
1601: p_action_information20 => per_formula_functions.get_number('O4_COST'),
1602: p_action_information21 => per_formula_functions.get_number('O4_AMG'),
1603: p_action_information22 => per_formula_functions.get_number('O4_CE'),
1604: p_action_information23 => per_formula_functions.get_number('O5_COST'),
1605: p_action_information24 => per_formula_functions.get_number('O5_AMG'),
1606: p_action_information25 => per_formula_functions.get_number('O5_CE'),
1607: p_action_information26 => per_formula_functions.get_text('O6_DESC'),
1600: p_action_information19 => per_formula_functions.get_number('O3_CE'),
1601: p_action_information20 => per_formula_functions.get_number('O4_COST'),
1602: p_action_information21 => per_formula_functions.get_number('O4_AMG'),
1603: p_action_information22 => per_formula_functions.get_number('O4_CE'),
1604: p_action_information23 => per_formula_functions.get_number('O5_COST'),
1605: p_action_information24 => per_formula_functions.get_number('O5_AMG'),
1606: p_action_information25 => per_formula_functions.get_number('O5_CE'),
1607: p_action_information26 => per_formula_functions.get_text('O6_DESC'),
1608: p_action_information27 => per_formula_functions.get_number('O6_COST'),
1601: p_action_information20 => per_formula_functions.get_number('O4_COST'),
1602: p_action_information21 => per_formula_functions.get_number('O4_AMG'),
1603: p_action_information22 => per_formula_functions.get_number('O4_CE'),
1604: p_action_information23 => per_formula_functions.get_number('O5_COST'),
1605: p_action_information24 => per_formula_functions.get_number('O5_AMG'),
1606: p_action_information25 => per_formula_functions.get_number('O5_CE'),
1607: p_action_information26 => per_formula_functions.get_text('O6_DESC'),
1608: p_action_information27 => per_formula_functions.get_number('O6_COST'),
1609: p_action_information28 => per_formula_functions.get_number('O6_AMG'),
1602: p_action_information21 => per_formula_functions.get_number('O4_AMG'),
1603: p_action_information22 => per_formula_functions.get_number('O4_CE'),
1604: p_action_information23 => per_formula_functions.get_number('O5_COST'),
1605: p_action_information24 => per_formula_functions.get_number('O5_AMG'),
1606: p_action_information25 => per_formula_functions.get_number('O5_CE'),
1607: p_action_information26 => per_formula_functions.get_text('O6_DESC'),
1608: p_action_information27 => per_formula_functions.get_number('O6_COST'),
1609: p_action_information28 => per_formula_functions.get_number('O6_AMG'),
1610: p_action_information29 => per_formula_functions.get_number('O6_CE') );
1603: p_action_information22 => per_formula_functions.get_number('O4_CE'),
1604: p_action_information23 => per_formula_functions.get_number('O5_COST'),
1605: p_action_information24 => per_formula_functions.get_number('O5_AMG'),
1606: p_action_information25 => per_formula_functions.get_number('O5_CE'),
1607: p_action_information26 => per_formula_functions.get_text('O6_DESC'),
1608: p_action_information27 => per_formula_functions.get_number('O6_COST'),
1609: p_action_information28 => per_formula_functions.get_number('O6_AMG'),
1610: p_action_information29 => per_formula_functions.get_number('O6_CE') );
1611:
1604: p_action_information23 => per_formula_functions.get_number('O5_COST'),
1605: p_action_information24 => per_formula_functions.get_number('O5_AMG'),
1606: p_action_information25 => per_formula_functions.get_number('O5_CE'),
1607: p_action_information26 => per_formula_functions.get_text('O6_DESC'),
1608: p_action_information27 => per_formula_functions.get_number('O6_COST'),
1609: p_action_information28 => per_formula_functions.get_number('O6_AMG'),
1610: p_action_information29 => per_formula_functions.get_number('O6_CE') );
1611:
1612: --
1605: p_action_information24 => per_formula_functions.get_number('O5_AMG'),
1606: p_action_information25 => per_formula_functions.get_number('O5_CE'),
1607: p_action_information26 => per_formula_functions.get_text('O6_DESC'),
1608: p_action_information27 => per_formula_functions.get_number('O6_COST'),
1609: p_action_information28 => per_formula_functions.get_number('O6_AMG'),
1610: p_action_information29 => per_formula_functions.get_number('O6_CE') );
1611:
1612: --
1613: pay_action_information_api.create_action_information(
1606: p_action_information25 => per_formula_functions.get_number('O5_CE'),
1607: p_action_information26 => per_formula_functions.get_text('O6_DESC'),
1608: p_action_information27 => per_formula_functions.get_number('O6_COST'),
1609: p_action_information28 => per_formula_functions.get_number('O6_AMG'),
1610: p_action_information29 => per_formula_functions.get_number('O6_CE') );
1611:
1612: --
1613: pay_action_information_api.create_action_information(
1614: p_action_information_id => l_action_info_id,
1618: p_effective_date => fnd_date.canonical_to_date(g_param_benefit_end_date),
1619: p_source_id => NULL,
1620: p_source_text => NULL,
1621: p_action_information_category => 'GB P11D ASSIGNMENT RESULTC',
1622: p_action_information1 => per_formula_functions.get_number('C_BUS_MILES'),
1623: p_action_information2 => per_formula_functions.get_number('M_BUS_MILES'),
1624: p_action_information3 => per_formula_functions.get_number('B_BUS_MILES'),
1625: p_action_information4 => per_formula_functions.get_number('C_RATE1'),
1626: p_action_information5 => per_formula_functions.get_number('C_RATE2'),
1619: p_source_id => NULL,
1620: p_source_text => NULL,
1621: p_action_information_category => 'GB P11D ASSIGNMENT RESULTC',
1622: p_action_information1 => per_formula_functions.get_number('C_BUS_MILES'),
1623: p_action_information2 => per_formula_functions.get_number('M_BUS_MILES'),
1624: p_action_information3 => per_formula_functions.get_number('B_BUS_MILES'),
1625: p_action_information4 => per_formula_functions.get_number('C_RATE1'),
1626: p_action_information5 => per_formula_functions.get_number('C_RATE2'),
1627: p_action_information6 => per_formula_functions.get_number('M_RATE1'),
1620: p_source_text => NULL,
1621: p_action_information_category => 'GB P11D ASSIGNMENT RESULTC',
1622: p_action_information1 => per_formula_functions.get_number('C_BUS_MILES'),
1623: p_action_information2 => per_formula_functions.get_number('M_BUS_MILES'),
1624: p_action_information3 => per_formula_functions.get_number('B_BUS_MILES'),
1625: p_action_information4 => per_formula_functions.get_number('C_RATE1'),
1626: p_action_information5 => per_formula_functions.get_number('C_RATE2'),
1627: p_action_information6 => per_formula_functions.get_number('M_RATE1'),
1628: p_action_information7 => per_formula_functions.get_number('M_RATE2'),
1621: p_action_information_category => 'GB P11D ASSIGNMENT RESULTC',
1622: p_action_information1 => per_formula_functions.get_number('C_BUS_MILES'),
1623: p_action_information2 => per_formula_functions.get_number('M_BUS_MILES'),
1624: p_action_information3 => per_formula_functions.get_number('B_BUS_MILES'),
1625: p_action_information4 => per_formula_functions.get_number('C_RATE1'),
1626: p_action_information5 => per_formula_functions.get_number('C_RATE2'),
1627: p_action_information6 => per_formula_functions.get_number('M_RATE1'),
1628: p_action_information7 => per_formula_functions.get_number('M_RATE2'),
1629: p_action_information8 => per_formula_functions.get_number('B_RATE1'),
1622: p_action_information1 => per_formula_functions.get_number('C_BUS_MILES'),
1623: p_action_information2 => per_formula_functions.get_number('M_BUS_MILES'),
1624: p_action_information3 => per_formula_functions.get_number('B_BUS_MILES'),
1625: p_action_information4 => per_formula_functions.get_number('C_RATE1'),
1626: p_action_information5 => per_formula_functions.get_number('C_RATE2'),
1627: p_action_information6 => per_formula_functions.get_number('M_RATE1'),
1628: p_action_information7 => per_formula_functions.get_number('M_RATE2'),
1629: p_action_information8 => per_formula_functions.get_number('B_RATE1'),
1630: p_action_information9 => per_formula_functions.get_number('B_RATE2'),
1623: p_action_information2 => per_formula_functions.get_number('M_BUS_MILES'),
1624: p_action_information3 => per_formula_functions.get_number('B_BUS_MILES'),
1625: p_action_information4 => per_formula_functions.get_number('C_RATE1'),
1626: p_action_information5 => per_formula_functions.get_number('C_RATE2'),
1627: p_action_information6 => per_formula_functions.get_number('M_RATE1'),
1628: p_action_information7 => per_formula_functions.get_number('M_RATE2'),
1629: p_action_information8 => per_formula_functions.get_number('B_RATE1'),
1630: p_action_information9 => per_formula_functions.get_number('B_RATE2'),
1631: p_action_information10 => per_formula_functions.get_text('DT_FREE_FUEL_WITHDRAWN'),
1624: p_action_information3 => per_formula_functions.get_number('B_BUS_MILES'),
1625: p_action_information4 => per_formula_functions.get_number('C_RATE1'),
1626: p_action_information5 => per_formula_functions.get_number('C_RATE2'),
1627: p_action_information6 => per_formula_functions.get_number('M_RATE1'),
1628: p_action_information7 => per_formula_functions.get_number('M_RATE2'),
1629: p_action_information8 => per_formula_functions.get_number('B_RATE1'),
1630: p_action_information9 => per_formula_functions.get_number('B_RATE2'),
1631: p_action_information10 => per_formula_functions.get_text('DT_FREE_FUEL_WITHDRAWN'),
1632: p_action_information11 => per_formula_functions.get_text('FREE_FUEL_REINSTATED'),
1625: p_action_information4 => per_formula_functions.get_number('C_RATE1'),
1626: p_action_information5 => per_formula_functions.get_number('C_RATE2'),
1627: p_action_information6 => per_formula_functions.get_number('M_RATE1'),
1628: p_action_information7 => per_formula_functions.get_number('M_RATE2'),
1629: p_action_information8 => per_formula_functions.get_number('B_RATE1'),
1630: p_action_information9 => per_formula_functions.get_number('B_RATE2'),
1631: p_action_information10 => per_formula_functions.get_text('DT_FREE_FUEL_WITHDRAWN'),
1632: p_action_information11 => per_formula_functions.get_text('FREE_FUEL_REINSTATED'),
1633: p_action_information12 => per_formula_functions.get_number('C_MILEAGE_PAYMENTS'),
1626: p_action_information5 => per_formula_functions.get_number('C_RATE2'),
1627: p_action_information6 => per_formula_functions.get_number('M_RATE1'),
1628: p_action_information7 => per_formula_functions.get_number('M_RATE2'),
1629: p_action_information8 => per_formula_functions.get_number('B_RATE1'),
1630: p_action_information9 => per_formula_functions.get_number('B_RATE2'),
1631: p_action_information10 => per_formula_functions.get_text('DT_FREE_FUEL_WITHDRAWN'),
1632: p_action_information11 => per_formula_functions.get_text('FREE_FUEL_REINSTATED'),
1633: p_action_information12 => per_formula_functions.get_number('C_MILEAGE_PAYMENTS'),
1634: p_action_information13 => per_formula_functions.get_number('B_MILEAGE_PAYMENTS'),
1627: p_action_information6 => per_formula_functions.get_number('M_RATE1'),
1628: p_action_information7 => per_formula_functions.get_number('M_RATE2'),
1629: p_action_information8 => per_formula_functions.get_number('B_RATE1'),
1630: p_action_information9 => per_formula_functions.get_number('B_RATE2'),
1631: p_action_information10 => per_formula_functions.get_text('DT_FREE_FUEL_WITHDRAWN'),
1632: p_action_information11 => per_formula_functions.get_text('FREE_FUEL_REINSTATED'),
1633: p_action_information12 => per_formula_functions.get_number('C_MILEAGE_PAYMENTS'),
1634: p_action_information13 => per_formula_functions.get_number('B_MILEAGE_PAYMENTS'),
1635: p_action_information14 => per_formula_functions.get_number('M_MILEAGE_PAYMENTS'),
1628: p_action_information7 => per_formula_functions.get_number('M_RATE2'),
1629: p_action_information8 => per_formula_functions.get_number('B_RATE1'),
1630: p_action_information9 => per_formula_functions.get_number('B_RATE2'),
1631: p_action_information10 => per_formula_functions.get_text('DT_FREE_FUEL_WITHDRAWN'),
1632: p_action_information11 => per_formula_functions.get_text('FREE_FUEL_REINSTATED'),
1633: p_action_information12 => per_formula_functions.get_number('C_MILEAGE_PAYMENTS'),
1634: p_action_information13 => per_formula_functions.get_number('B_MILEAGE_PAYMENTS'),
1635: p_action_information14 => per_formula_functions.get_number('M_MILEAGE_PAYMENTS'),
1636: p_action_information15 => per_formula_functions.get_number('MARORS_COUNT'),
1629: p_action_information8 => per_formula_functions.get_number('B_RATE1'),
1630: p_action_information9 => per_formula_functions.get_number('B_RATE2'),
1631: p_action_information10 => per_formula_functions.get_text('DT_FREE_FUEL_WITHDRAWN'),
1632: p_action_information11 => per_formula_functions.get_text('FREE_FUEL_REINSTATED'),
1633: p_action_information12 => per_formula_functions.get_number('C_MILEAGE_PAYMENTS'),
1634: p_action_information13 => per_formula_functions.get_number('B_MILEAGE_PAYMENTS'),
1635: p_action_information14 => per_formula_functions.get_number('M_MILEAGE_PAYMENTS'),
1636: p_action_information15 => per_formula_functions.get_number('MARORS_COUNT'),
1637: p_action_information16 => per_formula_functions.get_number('C_TAX_DEDUCTED'),
1630: p_action_information9 => per_formula_functions.get_number('B_RATE2'),
1631: p_action_information10 => per_formula_functions.get_text('DT_FREE_FUEL_WITHDRAWN'),
1632: p_action_information11 => per_formula_functions.get_text('FREE_FUEL_REINSTATED'),
1633: p_action_information12 => per_formula_functions.get_number('C_MILEAGE_PAYMENTS'),
1634: p_action_information13 => per_formula_functions.get_number('B_MILEAGE_PAYMENTS'),
1635: p_action_information14 => per_formula_functions.get_number('M_MILEAGE_PAYMENTS'),
1636: p_action_information15 => per_formula_functions.get_number('MARORS_COUNT'),
1637: p_action_information16 => per_formula_functions.get_number('C_TAX_DEDUCTED'),
1638: p_action_information17 => per_formula_functions.get_number('B_TAX_DEDUCTED'),
1631: p_action_information10 => per_formula_functions.get_text('DT_FREE_FUEL_WITHDRAWN'),
1632: p_action_information11 => per_formula_functions.get_text('FREE_FUEL_REINSTATED'),
1633: p_action_information12 => per_formula_functions.get_number('C_MILEAGE_PAYMENTS'),
1634: p_action_information13 => per_formula_functions.get_number('B_MILEAGE_PAYMENTS'),
1635: p_action_information14 => per_formula_functions.get_number('M_MILEAGE_PAYMENTS'),
1636: p_action_information15 => per_formula_functions.get_number('MARORS_COUNT'),
1637: p_action_information16 => per_formula_functions.get_number('C_TAX_DEDUCTED'),
1638: p_action_information17 => per_formula_functions.get_number('B_TAX_DEDUCTED'),
1639: p_action_information18 => per_formula_functions.get_number('M_TAX_DEDUCTED'),
1632: p_action_information11 => per_formula_functions.get_text('FREE_FUEL_REINSTATED'),
1633: p_action_information12 => per_formula_functions.get_number('C_MILEAGE_PAYMENTS'),
1634: p_action_information13 => per_formula_functions.get_number('B_MILEAGE_PAYMENTS'),
1635: p_action_information14 => per_formula_functions.get_number('M_MILEAGE_PAYMENTS'),
1636: p_action_information15 => per_formula_functions.get_number('MARORS_COUNT'),
1637: p_action_information16 => per_formula_functions.get_number('C_TAX_DEDUCTED'),
1638: p_action_information17 => per_formula_functions.get_number('B_TAX_DEDUCTED'),
1639: p_action_information18 => per_formula_functions.get_number('M_TAX_DEDUCTED'),
1640: p_action_information19 => per_formula_functions.get_number('PASSENGER_PAYMENTS'),
1633: p_action_information12 => per_formula_functions.get_number('C_MILEAGE_PAYMENTS'),
1634: p_action_information13 => per_formula_functions.get_number('B_MILEAGE_PAYMENTS'),
1635: p_action_information14 => per_formula_functions.get_number('M_MILEAGE_PAYMENTS'),
1636: p_action_information15 => per_formula_functions.get_number('MARORS_COUNT'),
1637: p_action_information16 => per_formula_functions.get_number('C_TAX_DEDUCTED'),
1638: p_action_information17 => per_formula_functions.get_number('B_TAX_DEDUCTED'),
1639: p_action_information18 => per_formula_functions.get_number('M_TAX_DEDUCTED'),
1640: p_action_information19 => per_formula_functions.get_number('PASSENGER_PAYMENTS'),
1641: p_action_information20 => per_formula_functions.get_number('PASSENGER_BUS_MILES'),
1634: p_action_information13 => per_formula_functions.get_number('B_MILEAGE_PAYMENTS'),
1635: p_action_information14 => per_formula_functions.get_number('M_MILEAGE_PAYMENTS'),
1636: p_action_information15 => per_formula_functions.get_number('MARORS_COUNT'),
1637: p_action_information16 => per_formula_functions.get_number('C_TAX_DEDUCTED'),
1638: p_action_information17 => per_formula_functions.get_number('B_TAX_DEDUCTED'),
1639: p_action_information18 => per_formula_functions.get_number('M_TAX_DEDUCTED'),
1640: p_action_information19 => per_formula_functions.get_number('PASSENGER_PAYMENTS'),
1641: p_action_information20 => per_formula_functions.get_number('PASSENGER_BUS_MILES'),
1642: p_action_information21 => per_formula_functions.get_number('PASSENGER_BUS_MILE_AMT'),
1635: p_action_information14 => per_formula_functions.get_number('M_MILEAGE_PAYMENTS'),
1636: p_action_information15 => per_formula_functions.get_number('MARORS_COUNT'),
1637: p_action_information16 => per_formula_functions.get_number('C_TAX_DEDUCTED'),
1638: p_action_information17 => per_formula_functions.get_number('B_TAX_DEDUCTED'),
1639: p_action_information18 => per_formula_functions.get_number('M_TAX_DEDUCTED'),
1640: p_action_information19 => per_formula_functions.get_number('PASSENGER_PAYMENTS'),
1641: p_action_information20 => per_formula_functions.get_number('PASSENGER_BUS_MILES'),
1642: p_action_information21 => per_formula_functions.get_number('PASSENGER_BUS_MILE_AMT'),
1643: p_action_information22 => per_formula_functions.get_number('MILEAGE_ALLOWANCE_RELIEF'),
1636: p_action_information15 => per_formula_functions.get_number('MARORS_COUNT'),
1637: p_action_information16 => per_formula_functions.get_number('C_TAX_DEDUCTED'),
1638: p_action_information17 => per_formula_functions.get_number('B_TAX_DEDUCTED'),
1639: p_action_information18 => per_formula_functions.get_number('M_TAX_DEDUCTED'),
1640: p_action_information19 => per_formula_functions.get_number('PASSENGER_PAYMENTS'),
1641: p_action_information20 => per_formula_functions.get_number('PASSENGER_BUS_MILES'),
1642: p_action_information21 => per_formula_functions.get_number('PASSENGER_BUS_MILE_AMT'),
1643: p_action_information22 => per_formula_functions.get_number('MILEAGE_ALLOWANCE_RELIEF'),
1644: p_action_information23 => per_formula_functions.get_number('INT_MAX_AMT_OUTSTANDING')
1637: p_action_information16 => per_formula_functions.get_number('C_TAX_DEDUCTED'),
1638: p_action_information17 => per_formula_functions.get_number('B_TAX_DEDUCTED'),
1639: p_action_information18 => per_formula_functions.get_number('M_TAX_DEDUCTED'),
1640: p_action_information19 => per_formula_functions.get_number('PASSENGER_PAYMENTS'),
1641: p_action_information20 => per_formula_functions.get_number('PASSENGER_BUS_MILES'),
1642: p_action_information21 => per_formula_functions.get_number('PASSENGER_BUS_MILE_AMT'),
1643: p_action_information22 => per_formula_functions.get_number('MILEAGE_ALLOWANCE_RELIEF'),
1644: p_action_information23 => per_formula_functions.get_number('INT_MAX_AMT_OUTSTANDING')
1645: );
1638: p_action_information17 => per_formula_functions.get_number('B_TAX_DEDUCTED'),
1639: p_action_information18 => per_formula_functions.get_number('M_TAX_DEDUCTED'),
1640: p_action_information19 => per_formula_functions.get_number('PASSENGER_PAYMENTS'),
1641: p_action_information20 => per_formula_functions.get_number('PASSENGER_BUS_MILES'),
1642: p_action_information21 => per_formula_functions.get_number('PASSENGER_BUS_MILE_AMT'),
1643: p_action_information22 => per_formula_functions.get_number('MILEAGE_ALLOWANCE_RELIEF'),
1644: p_action_information23 => per_formula_functions.get_number('INT_MAX_AMT_OUTSTANDING')
1645: );
1646: else
1639: p_action_information18 => per_formula_functions.get_number('M_TAX_DEDUCTED'),
1640: p_action_information19 => per_formula_functions.get_number('PASSENGER_PAYMENTS'),
1641: p_action_information20 => per_formula_functions.get_number('PASSENGER_BUS_MILES'),
1642: p_action_information21 => per_formula_functions.get_number('PASSENGER_BUS_MILE_AMT'),
1643: p_action_information22 => per_formula_functions.get_number('MILEAGE_ALLOWANCE_RELIEF'),
1644: p_action_information23 => per_formula_functions.get_number('INT_MAX_AMT_OUTSTANDING')
1645: );
1646: else
1647: /* Code for year 04/05 onward */
1640: p_action_information19 => per_formula_functions.get_number('PASSENGER_PAYMENTS'),
1641: p_action_information20 => per_formula_functions.get_number('PASSENGER_BUS_MILES'),
1642: p_action_information21 => per_formula_functions.get_number('PASSENGER_BUS_MILE_AMT'),
1643: p_action_information22 => per_formula_functions.get_number('MILEAGE_ALLOWANCE_RELIEF'),
1644: p_action_information23 => per_formula_functions.get_number('INT_MAX_AMT_OUTSTANDING')
1645: );
1646: else
1647: /* Code for year 04/05 onward */
1648: pay_action_information_api.create_action_information(
1653: p_effective_date => fnd_date.canonical_to_date(g_param_benefit_end_date),
1654: p_source_id => NULL,
1655: p_source_text => NULL,
1656: p_action_information_category => 'GB P11D ASSIGNMENT RESULTA',
1657: p_action_information1 => per_formula_functions.get_text('A_DESC'),
1658: p_action_information2 => per_formula_functions.get_number('A_COST'),
1659: p_action_information3 => per_formula_functions.get_number('A_AMG'),
1660: p_action_information4 => per_formula_functions.get_number('A_CE'),
1661: p_action_information5 => per_formula_functions.get_text('B_DESC'),
1654: p_source_id => NULL,
1655: p_source_text => NULL,
1656: p_action_information_category => 'GB P11D ASSIGNMENT RESULTA',
1657: p_action_information1 => per_formula_functions.get_text('A_DESC'),
1658: p_action_information2 => per_formula_functions.get_number('A_COST'),
1659: p_action_information3 => per_formula_functions.get_number('A_AMG'),
1660: p_action_information4 => per_formula_functions.get_number('A_CE'),
1661: p_action_information5 => per_formula_functions.get_text('B_DESC'),
1662: p_action_information6 => per_formula_functions.get_number('B_CE'),
1655: p_source_text => NULL,
1656: p_action_information_category => 'GB P11D ASSIGNMENT RESULTA',
1657: p_action_information1 => per_formula_functions.get_text('A_DESC'),
1658: p_action_information2 => per_formula_functions.get_number('A_COST'),
1659: p_action_information3 => per_formula_functions.get_number('A_AMG'),
1660: p_action_information4 => per_formula_functions.get_number('A_CE'),
1661: p_action_information5 => per_formula_functions.get_text('B_DESC'),
1662: p_action_information6 => per_formula_functions.get_number('B_CE'),
1663: p_action_information7 => per_formula_functions.get_number('B_TNP'),
1656: p_action_information_category => 'GB P11D ASSIGNMENT RESULTA',
1657: p_action_information1 => per_formula_functions.get_text('A_DESC'),
1658: p_action_information2 => per_formula_functions.get_number('A_COST'),
1659: p_action_information3 => per_formula_functions.get_number('A_AMG'),
1660: p_action_information4 => per_formula_functions.get_number('A_CE'),
1661: p_action_information5 => per_formula_functions.get_text('B_DESC'),
1662: p_action_information6 => per_formula_functions.get_number('B_CE'),
1663: p_action_information7 => per_formula_functions.get_number('B_TNP'),
1664: p_action_information8 => per_formula_functions.get_number('C_COST'),
1657: p_action_information1 => per_formula_functions.get_text('A_DESC'),
1658: p_action_information2 => per_formula_functions.get_number('A_COST'),
1659: p_action_information3 => per_formula_functions.get_number('A_AMG'),
1660: p_action_information4 => per_formula_functions.get_number('A_CE'),
1661: p_action_information5 => per_formula_functions.get_text('B_DESC'),
1662: p_action_information6 => per_formula_functions.get_number('B_CE'),
1663: p_action_information7 => per_formula_functions.get_number('B_TNP'),
1664: p_action_information8 => per_formula_functions.get_number('C_COST'),
1665: p_action_information9 => per_formula_functions.get_number('C_AMG'),
1658: p_action_information2 => per_formula_functions.get_number('A_COST'),
1659: p_action_information3 => per_formula_functions.get_number('A_AMG'),
1660: p_action_information4 => per_formula_functions.get_number('A_CE'),
1661: p_action_information5 => per_formula_functions.get_text('B_DESC'),
1662: p_action_information6 => per_formula_functions.get_number('B_CE'),
1663: p_action_information7 => per_formula_functions.get_number('B_TNP'),
1664: p_action_information8 => per_formula_functions.get_number('C_COST'),
1665: p_action_information9 => per_formula_functions.get_number('C_AMG'),
1666: p_action_information10 => per_formula_functions.get_number('C_CE'),
1659: p_action_information3 => per_formula_functions.get_number('A_AMG'),
1660: p_action_information4 => per_formula_functions.get_number('A_CE'),
1661: p_action_information5 => per_formula_functions.get_text('B_DESC'),
1662: p_action_information6 => per_formula_functions.get_number('B_CE'),
1663: p_action_information7 => per_formula_functions.get_number('B_TNP'),
1664: p_action_information8 => per_formula_functions.get_number('C_COST'),
1665: p_action_information9 => per_formula_functions.get_number('C_AMG'),
1666: p_action_information10 => per_formula_functions.get_number('C_CE'),
1667: p_action_information11 => per_formula_functions.get_number('D_CE'),
1660: p_action_information4 => per_formula_functions.get_number('A_CE'),
1661: p_action_information5 => per_formula_functions.get_text('B_DESC'),
1662: p_action_information6 => per_formula_functions.get_number('B_CE'),
1663: p_action_information7 => per_formula_functions.get_number('B_TNP'),
1664: p_action_information8 => per_formula_functions.get_number('C_COST'),
1665: p_action_information9 => per_formula_functions.get_number('C_AMG'),
1666: p_action_information10 => per_formula_functions.get_number('C_CE'),
1667: p_action_information11 => per_formula_functions.get_number('D_CE'),
1668: p_action_information12 => calculate_amap_ce ,
1661: p_action_information5 => per_formula_functions.get_text('B_DESC'),
1662: p_action_information6 => per_formula_functions.get_number('B_CE'),
1663: p_action_information7 => per_formula_functions.get_number('B_TNP'),
1664: p_action_information8 => per_formula_functions.get_number('C_COST'),
1665: p_action_information9 => per_formula_functions.get_number('C_AMG'),
1666: p_action_information10 => per_formula_functions.get_number('C_CE'),
1667: p_action_information11 => per_formula_functions.get_number('D_CE'),
1668: p_action_information12 => calculate_amap_ce ,
1669: p_action_information13 => per_formula_functions.get_number('F_TCCE'),
1662: p_action_information6 => per_formula_functions.get_number('B_CE'),
1663: p_action_information7 => per_formula_functions.get_number('B_TNP'),
1664: p_action_information8 => per_formula_functions.get_number('C_COST'),
1665: p_action_information9 => per_formula_functions.get_number('C_AMG'),
1666: p_action_information10 => per_formula_functions.get_number('C_CE'),
1667: p_action_information11 => per_formula_functions.get_number('D_CE'),
1668: p_action_information12 => calculate_amap_ce ,
1669: p_action_information13 => per_formula_functions.get_number('F_TCCE'),
1670: p_action_information14 => per_formula_functions.get_number('F_TFCE'),
1663: p_action_information7 => per_formula_functions.get_number('B_TNP'),
1664: p_action_information8 => per_formula_functions.get_number('C_COST'),
1665: p_action_information9 => per_formula_functions.get_number('C_AMG'),
1666: p_action_information10 => per_formula_functions.get_number('C_CE'),
1667: p_action_information11 => per_formula_functions.get_number('D_CE'),
1668: p_action_information12 => calculate_amap_ce ,
1669: p_action_information13 => per_formula_functions.get_number('F_TCCE'),
1670: p_action_information14 => per_formula_functions.get_number('F_TFCE'),
1671: p_action_information15 => per_formula_functions.get_number('G_CE'),
1665: p_action_information9 => per_formula_functions.get_number('C_AMG'),
1666: p_action_information10 => per_formula_functions.get_number('C_CE'),
1667: p_action_information11 => per_formula_functions.get_number('D_CE'),
1668: p_action_information12 => calculate_amap_ce ,
1669: p_action_information13 => per_formula_functions.get_number('F_TCCE'),
1670: p_action_information14 => per_formula_functions.get_number('F_TFCE'),
1671: p_action_information15 => per_formula_functions.get_number('G_CE'),
1672: p_action_information16 => per_formula_functions.get_number('I_COST'),
1673: p_action_information17 => per_formula_functions.get_number('I_AMG'),
1666: p_action_information10 => per_formula_functions.get_number('C_CE'),
1667: p_action_information11 => per_formula_functions.get_number('D_CE'),
1668: p_action_information12 => calculate_amap_ce ,
1669: p_action_information13 => per_formula_functions.get_number('F_TCCE'),
1670: p_action_information14 => per_formula_functions.get_number('F_TFCE'),
1671: p_action_information15 => per_formula_functions.get_number('G_CE'),
1672: p_action_information16 => per_formula_functions.get_number('I_COST'),
1673: p_action_information17 => per_formula_functions.get_number('I_AMG'),
1674: p_action_information18 => per_formula_functions.get_number('I_CE'),
1667: p_action_information11 => per_formula_functions.get_number('D_CE'),
1668: p_action_information12 => calculate_amap_ce ,
1669: p_action_information13 => per_formula_functions.get_number('F_TCCE'),
1670: p_action_information14 => per_formula_functions.get_number('F_TFCE'),
1671: p_action_information15 => per_formula_functions.get_number('G_CE'),
1672: p_action_information16 => per_formula_functions.get_number('I_COST'),
1673: p_action_information17 => per_formula_functions.get_number('I_AMG'),
1674: p_action_information18 => per_formula_functions.get_number('I_CE'),
1675: p_action_information19 => per_formula_functions.get_number('J_CE'),
1668: p_action_information12 => calculate_amap_ce ,
1669: p_action_information13 => per_formula_functions.get_number('F_TCCE'),
1670: p_action_information14 => per_formula_functions.get_number('F_TFCE'),
1671: p_action_information15 => per_formula_functions.get_number('G_CE'),
1672: p_action_information16 => per_formula_functions.get_number('I_COST'),
1673: p_action_information17 => per_formula_functions.get_number('I_AMG'),
1674: p_action_information18 => per_formula_functions.get_number('I_CE'),
1675: p_action_information19 => per_formula_functions.get_number('J_CE'),
1676: p_action_information20 => per_formula_functions.get_number('K_COST'),
1669: p_action_information13 => per_formula_functions.get_number('F_TCCE'),
1670: p_action_information14 => per_formula_functions.get_number('F_TFCE'),
1671: p_action_information15 => per_formula_functions.get_number('G_CE'),
1672: p_action_information16 => per_formula_functions.get_number('I_COST'),
1673: p_action_information17 => per_formula_functions.get_number('I_AMG'),
1674: p_action_information18 => per_formula_functions.get_number('I_CE'),
1675: p_action_information19 => per_formula_functions.get_number('J_CE'),
1676: p_action_information20 => per_formula_functions.get_number('K_COST'),
1677: p_action_information21 => per_formula_functions.get_number('K_AMG'),
1670: p_action_information14 => per_formula_functions.get_number('F_TFCE'),
1671: p_action_information15 => per_formula_functions.get_number('G_CE'),
1672: p_action_information16 => per_formula_functions.get_number('I_COST'),
1673: p_action_information17 => per_formula_functions.get_number('I_AMG'),
1674: p_action_information18 => per_formula_functions.get_number('I_CE'),
1675: p_action_information19 => per_formula_functions.get_number('J_CE'),
1676: p_action_information20 => per_formula_functions.get_number('K_COST'),
1677: p_action_information21 => per_formula_functions.get_number('K_AMG'),
1678: p_action_information22 => per_formula_functions.get_number('K_CE'),
1671: p_action_information15 => per_formula_functions.get_number('G_CE'),
1672: p_action_information16 => per_formula_functions.get_number('I_COST'),
1673: p_action_information17 => per_formula_functions.get_number('I_AMG'),
1674: p_action_information18 => per_formula_functions.get_number('I_CE'),
1675: p_action_information19 => per_formula_functions.get_number('J_CE'),
1676: p_action_information20 => per_formula_functions.get_number('K_COST'),
1677: p_action_information21 => per_formula_functions.get_number('K_AMG'),
1678: p_action_information22 => per_formula_functions.get_number('K_CE'),
1679: p_action_information23 => per_formula_functions.get_text('L_DESC'),
1672: p_action_information16 => per_formula_functions.get_number('I_COST'),
1673: p_action_information17 => per_formula_functions.get_number('I_AMG'),
1674: p_action_information18 => per_formula_functions.get_number('I_CE'),
1675: p_action_information19 => per_formula_functions.get_number('J_CE'),
1676: p_action_information20 => per_formula_functions.get_number('K_COST'),
1677: p_action_information21 => per_formula_functions.get_number('K_AMG'),
1678: p_action_information22 => per_formula_functions.get_number('K_CE'),
1679: p_action_information23 => per_formula_functions.get_text('L_DESC'),
1680: p_action_information24 => per_formula_functions.get_number('L_COST'),
1673: p_action_information17 => per_formula_functions.get_number('I_AMG'),
1674: p_action_information18 => per_formula_functions.get_number('I_CE'),
1675: p_action_information19 => per_formula_functions.get_number('J_CE'),
1676: p_action_information20 => per_formula_functions.get_number('K_COST'),
1677: p_action_information21 => per_formula_functions.get_number('K_AMG'),
1678: p_action_information22 => per_formula_functions.get_number('K_CE'),
1679: p_action_information23 => per_formula_functions.get_text('L_DESC'),
1680: p_action_information24 => per_formula_functions.get_number('L_COST'),
1681: p_action_information25 => per_formula_functions.get_number('L_AMG'),
1674: p_action_information18 => per_formula_functions.get_number('I_CE'),
1675: p_action_information19 => per_formula_functions.get_number('J_CE'),
1676: p_action_information20 => per_formula_functions.get_number('K_COST'),
1677: p_action_information21 => per_formula_functions.get_number('K_AMG'),
1678: p_action_information22 => per_formula_functions.get_number('K_CE'),
1679: p_action_information23 => per_formula_functions.get_text('L_DESC'),
1680: p_action_information24 => per_formula_functions.get_number('L_COST'),
1681: p_action_information25 => per_formula_functions.get_number('L_AMG'),
1682: p_action_information26 => per_formula_functions.get_number('L_CE'),
1675: p_action_information19 => per_formula_functions.get_number('J_CE'),
1676: p_action_information20 => per_formula_functions.get_number('K_COST'),
1677: p_action_information21 => per_formula_functions.get_number('K_AMG'),
1678: p_action_information22 => per_formula_functions.get_number('K_CE'),
1679: p_action_information23 => per_formula_functions.get_text('L_DESC'),
1680: p_action_information24 => per_formula_functions.get_number('L_COST'),
1681: p_action_information25 => per_formula_functions.get_number('L_AMG'),
1682: p_action_information26 => per_formula_functions.get_number('L_CE'),
1683: p_action_information27 => null,
1676: p_action_information20 => per_formula_functions.get_number('K_COST'),
1677: p_action_information21 => per_formula_functions.get_number('K_AMG'),
1678: p_action_information22 => per_formula_functions.get_number('K_CE'),
1679: p_action_information23 => per_formula_functions.get_text('L_DESC'),
1680: p_action_information24 => per_formula_functions.get_number('L_COST'),
1681: p_action_information25 => per_formula_functions.get_number('L_AMG'),
1682: p_action_information26 => per_formula_functions.get_number('L_CE'),
1683: p_action_information27 => null,
1684: p_action_information28 => per_formula_functions.get_number('H_CE1'),
1677: p_action_information21 => per_formula_functions.get_number('K_AMG'),
1678: p_action_information22 => per_formula_functions.get_number('K_CE'),
1679: p_action_information23 => per_formula_functions.get_text('L_DESC'),
1680: p_action_information24 => per_formula_functions.get_number('L_COST'),
1681: p_action_information25 => per_formula_functions.get_number('L_AMG'),
1682: p_action_information26 => per_formula_functions.get_number('L_CE'),
1683: p_action_information27 => null,
1684: p_action_information28 => per_formula_functions.get_number('H_CE1'),
1685: p_action_information29 => per_formula_functions.get_number('H_COUNT'),
1678: p_action_information22 => per_formula_functions.get_number('K_CE'),
1679: p_action_information23 => per_formula_functions.get_text('L_DESC'),
1680: p_action_information24 => per_formula_functions.get_number('L_COST'),
1681: p_action_information25 => per_formula_functions.get_number('L_AMG'),
1682: p_action_information26 => per_formula_functions.get_number('L_CE'),
1683: p_action_information27 => null,
1684: p_action_information28 => per_formula_functions.get_number('H_CE1'),
1685: p_action_information29 => per_formula_functions.get_number('H_COUNT'),
1686: p_action_information30 => per_formula_functions.get_number('F_COUNT') );
1680: p_action_information24 => per_formula_functions.get_number('L_COST'),
1681: p_action_information25 => per_formula_functions.get_number('L_AMG'),
1682: p_action_information26 => per_formula_functions.get_number('L_CE'),
1683: p_action_information27 => null,
1684: p_action_information28 => per_formula_functions.get_number('H_CE1'),
1685: p_action_information29 => per_formula_functions.get_number('H_COUNT'),
1686: p_action_information30 => per_formula_functions.get_number('F_COUNT') );
1687:
1688: hr_utility.trace('FFFFFF Count : ' || per_formula_functions.get_number('F_COUNT'));
1681: p_action_information25 => per_formula_functions.get_number('L_AMG'),
1682: p_action_information26 => per_formula_functions.get_number('L_CE'),
1683: p_action_information27 => null,
1684: p_action_information28 => per_formula_functions.get_number('H_CE1'),
1685: p_action_information29 => per_formula_functions.get_number('H_COUNT'),
1686: p_action_information30 => per_formula_functions.get_number('F_COUNT') );
1687:
1688: hr_utility.trace('FFFFFF Count : ' || per_formula_functions.get_number('F_COUNT'));
1689: --
1682: p_action_information26 => per_formula_functions.get_number('L_CE'),
1683: p_action_information27 => null,
1684: p_action_information28 => per_formula_functions.get_number('H_CE1'),
1685: p_action_information29 => per_formula_functions.get_number('H_COUNT'),
1686: p_action_information30 => per_formula_functions.get_number('F_COUNT') );
1687:
1688: hr_utility.trace('FFFFFF Count : ' || per_formula_functions.get_number('F_COUNT'));
1689: --
1690: pay_action_information_api.create_action_information(
1684: p_action_information28 => per_formula_functions.get_number('H_CE1'),
1685: p_action_information29 => per_formula_functions.get_number('H_COUNT'),
1686: p_action_information30 => per_formula_functions.get_number('F_COUNT') );
1687:
1688: hr_utility.trace('FFFFFF Count : ' || per_formula_functions.get_number('F_COUNT'));
1689: --
1690: pay_action_information_api.create_action_information(
1691: p_action_information_id => l_action_info_id,
1692: p_action_context_id => p_assactid,
1695: p_effective_date => fnd_date.canonical_to_date(g_param_benefit_end_date),
1696: p_source_id => NULL,
1697: p_source_text => NULL,
1698: p_action_information_category => 'GB P11D ASSIGNMENT RESULTB',
1699: p_action_information1 => per_formula_functions.get_text('M_DESC'),
1700: p_action_information2 => per_formula_functions.get_number('M_COST'),
1701: p_action_information3 => per_formula_functions.get_number('M_AMG'),
1702: p_action_information4 => per_formula_functions.get_number('M_CE'),
1703: p_action_information5 => per_formula_functions.get_text('MA_DESC'),
1696: p_source_id => NULL,
1697: p_source_text => NULL,
1698: p_action_information_category => 'GB P11D ASSIGNMENT RESULTB',
1699: p_action_information1 => per_formula_functions.get_text('M_DESC'),
1700: p_action_information2 => per_formula_functions.get_number('M_COST'),
1701: p_action_information3 => per_formula_functions.get_number('M_AMG'),
1702: p_action_information4 => per_formula_functions.get_number('M_CE'),
1703: p_action_information5 => per_formula_functions.get_text('MA_DESC'),
1704: p_action_information6 => per_formula_functions.get_number('MA_COST'),
1697: p_source_text => NULL,
1698: p_action_information_category => 'GB P11D ASSIGNMENT RESULTB',
1699: p_action_information1 => per_formula_functions.get_text('M_DESC'),
1700: p_action_information2 => per_formula_functions.get_number('M_COST'),
1701: p_action_information3 => per_formula_functions.get_number('M_AMG'),
1702: p_action_information4 => per_formula_functions.get_number('M_CE'),
1703: p_action_information5 => per_formula_functions.get_text('MA_DESC'),
1704: p_action_information6 => per_formula_functions.get_number('MA_COST'),
1705: p_action_information7 => per_formula_functions.get_number('MA_AMG'),
1698: p_action_information_category => 'GB P11D ASSIGNMENT RESULTB',
1699: p_action_information1 => per_formula_functions.get_text('M_DESC'),
1700: p_action_information2 => per_formula_functions.get_number('M_COST'),
1701: p_action_information3 => per_formula_functions.get_number('M_AMG'),
1702: p_action_information4 => per_formula_functions.get_number('M_CE'),
1703: p_action_information5 => per_formula_functions.get_text('MA_DESC'),
1704: p_action_information6 => per_formula_functions.get_number('MA_COST'),
1705: p_action_information7 => per_formula_functions.get_number('MA_AMG'),
1706: p_action_information8 => per_formula_functions.get_number('MA_CE'),
1699: p_action_information1 => per_formula_functions.get_text('M_DESC'),
1700: p_action_information2 => per_formula_functions.get_number('M_COST'),
1701: p_action_information3 => per_formula_functions.get_number('M_AMG'),
1702: p_action_information4 => per_formula_functions.get_number('M_CE'),
1703: p_action_information5 => per_formula_functions.get_text('MA_DESC'),
1704: p_action_information6 => per_formula_functions.get_number('MA_COST'),
1705: p_action_information7 => per_formula_functions.get_number('MA_AMG'),
1706: p_action_information8 => per_formula_functions.get_number('MA_CE'),
1707: p_action_information9 => per_formula_functions.get_number('M_TAXPAID'),
1700: p_action_information2 => per_formula_functions.get_number('M_COST'),
1701: p_action_information3 => per_formula_functions.get_number('M_AMG'),
1702: p_action_information4 => per_formula_functions.get_number('M_CE'),
1703: p_action_information5 => per_formula_functions.get_text('MA_DESC'),
1704: p_action_information6 => per_formula_functions.get_number('MA_COST'),
1705: p_action_information7 => per_formula_functions.get_number('MA_AMG'),
1706: p_action_information8 => per_formula_functions.get_number('MA_CE'),
1707: p_action_information9 => per_formula_functions.get_number('M_TAXPAID'),
1708: p_action_information10 => per_formula_functions.get_number('N1_COST'),
1701: p_action_information3 => per_formula_functions.get_number('M_AMG'),
1702: p_action_information4 => per_formula_functions.get_number('M_CE'),
1703: p_action_information5 => per_formula_functions.get_text('MA_DESC'),
1704: p_action_information6 => per_formula_functions.get_number('MA_COST'),
1705: p_action_information7 => per_formula_functions.get_number('MA_AMG'),
1706: p_action_information8 => per_formula_functions.get_number('MA_CE'),
1707: p_action_information9 => per_formula_functions.get_number('M_TAXPAID'),
1708: p_action_information10 => per_formula_functions.get_number('N1_COST'),
1709: p_action_information11 => per_formula_functions.get_number('N1_AMG'),
1702: p_action_information4 => per_formula_functions.get_number('M_CE'),
1703: p_action_information5 => per_formula_functions.get_text('MA_DESC'),
1704: p_action_information6 => per_formula_functions.get_number('MA_COST'),
1705: p_action_information7 => per_formula_functions.get_number('MA_AMG'),
1706: p_action_information8 => per_formula_functions.get_number('MA_CE'),
1707: p_action_information9 => per_formula_functions.get_number('M_TAXPAID'),
1708: p_action_information10 => per_formula_functions.get_number('N1_COST'),
1709: p_action_information11 => per_formula_functions.get_number('N1_AMG'),
1710: p_action_information12 => per_formula_functions.get_number('N1_CE'),
1703: p_action_information5 => per_formula_functions.get_text('MA_DESC'),
1704: p_action_information6 => per_formula_functions.get_number('MA_COST'),
1705: p_action_information7 => per_formula_functions.get_number('MA_AMG'),
1706: p_action_information8 => per_formula_functions.get_number('MA_CE'),
1707: p_action_information9 => per_formula_functions.get_number('M_TAXPAID'),
1708: p_action_information10 => per_formula_functions.get_number('N1_COST'),
1709: p_action_information11 => per_formula_functions.get_number('N1_AMG'),
1710: p_action_information12 => per_formula_functions.get_number('N1_CE'),
1711: p_action_information13 => per_formula_functions.get_number('N2_COST'),
1704: p_action_information6 => per_formula_functions.get_number('MA_COST'),
1705: p_action_information7 => per_formula_functions.get_number('MA_AMG'),
1706: p_action_information8 => per_formula_functions.get_number('MA_CE'),
1707: p_action_information9 => per_formula_functions.get_number('M_TAXPAID'),
1708: p_action_information10 => per_formula_functions.get_number('N1_COST'),
1709: p_action_information11 => per_formula_functions.get_number('N1_AMG'),
1710: p_action_information12 => per_formula_functions.get_number('N1_CE'),
1711: p_action_information13 => per_formula_functions.get_number('N2_COST'),
1712: p_action_information14 => per_formula_functions.get_number('N2_AMG'),
1705: p_action_information7 => per_formula_functions.get_number('MA_AMG'),
1706: p_action_information8 => per_formula_functions.get_number('MA_CE'),
1707: p_action_information9 => per_formula_functions.get_number('M_TAXPAID'),
1708: p_action_information10 => per_formula_functions.get_number('N1_COST'),
1709: p_action_information11 => per_formula_functions.get_number('N1_AMG'),
1710: p_action_information12 => per_formula_functions.get_number('N1_CE'),
1711: p_action_information13 => per_formula_functions.get_number('N2_COST'),
1712: p_action_information14 => per_formula_functions.get_number('N2_AMG'),
1713: p_action_information15 => per_formula_functions.get_number('N2_CE'),
1706: p_action_information8 => per_formula_functions.get_number('MA_CE'),
1707: p_action_information9 => per_formula_functions.get_number('M_TAXPAID'),
1708: p_action_information10 => per_formula_functions.get_number('N1_COST'),
1709: p_action_information11 => per_formula_functions.get_number('N1_AMG'),
1710: p_action_information12 => per_formula_functions.get_number('N1_CE'),
1711: p_action_information13 => per_formula_functions.get_number('N2_COST'),
1712: p_action_information14 => per_formula_functions.get_number('N2_AMG'),
1713: p_action_information15 => per_formula_functions.get_number('N2_CE'),
1714: p_action_information16 => per_formula_functions.get_text('N_TOI'),
1707: p_action_information9 => per_formula_functions.get_number('M_TAXPAID'),
1708: p_action_information10 => per_formula_functions.get_number('N1_COST'),
1709: p_action_information11 => per_formula_functions.get_number('N1_AMG'),
1710: p_action_information12 => per_formula_functions.get_number('N1_CE'),
1711: p_action_information13 => per_formula_functions.get_number('N2_COST'),
1712: p_action_information14 => per_formula_functions.get_number('N2_AMG'),
1713: p_action_information15 => per_formula_functions.get_number('N2_CE'),
1714: p_action_information16 => per_formula_functions.get_text('N_TOI'),
1715: p_action_information17 => per_formula_functions.get_number('N3_COST'),
1708: p_action_information10 => per_formula_functions.get_number('N1_COST'),
1709: p_action_information11 => per_formula_functions.get_number('N1_AMG'),
1710: p_action_information12 => per_formula_functions.get_number('N1_CE'),
1711: p_action_information13 => per_formula_functions.get_number('N2_COST'),
1712: p_action_information14 => per_formula_functions.get_number('N2_AMG'),
1713: p_action_information15 => per_formula_functions.get_number('N2_CE'),
1714: p_action_information16 => per_formula_functions.get_text('N_TOI'),
1715: p_action_information17 => per_formula_functions.get_number('N3_COST'),
1716: p_action_information18 => per_formula_functions.get_number('N3_AMG'),
1709: p_action_information11 => per_formula_functions.get_number('N1_AMG'),
1710: p_action_information12 => per_formula_functions.get_number('N1_CE'),
1711: p_action_information13 => per_formula_functions.get_number('N2_COST'),
1712: p_action_information14 => per_formula_functions.get_number('N2_AMG'),
1713: p_action_information15 => per_formula_functions.get_number('N2_CE'),
1714: p_action_information16 => per_formula_functions.get_text('N_TOI'),
1715: p_action_information17 => per_formula_functions.get_number('N3_COST'),
1716: p_action_information18 => per_formula_functions.get_number('N3_AMG'),
1717: p_action_information19 => per_formula_functions.get_number('N3_CE'),
1710: p_action_information12 => per_formula_functions.get_number('N1_CE'),
1711: p_action_information13 => per_formula_functions.get_number('N2_COST'),
1712: p_action_information14 => per_formula_functions.get_number('N2_AMG'),
1713: p_action_information15 => per_formula_functions.get_number('N2_CE'),
1714: p_action_information16 => per_formula_functions.get_text('N_TOI'),
1715: p_action_information17 => per_formula_functions.get_number('N3_COST'),
1716: p_action_information18 => per_formula_functions.get_number('N3_AMG'),
1717: p_action_information19 => per_formula_functions.get_number('N3_CE'),
1718: p_action_information20 => per_formula_functions.get_number('N4_COST'),
1711: p_action_information13 => per_formula_functions.get_number('N2_COST'),
1712: p_action_information14 => per_formula_functions.get_number('N2_AMG'),
1713: p_action_information15 => per_formula_functions.get_number('N2_CE'),
1714: p_action_information16 => per_formula_functions.get_text('N_TOI'),
1715: p_action_information17 => per_formula_functions.get_number('N3_COST'),
1716: p_action_information18 => per_formula_functions.get_number('N3_AMG'),
1717: p_action_information19 => per_formula_functions.get_number('N3_CE'),
1718: p_action_information20 => per_formula_functions.get_number('N4_COST'),
1719: p_action_information21 => per_formula_functions.get_number('N4_AMG'),
1712: p_action_information14 => per_formula_functions.get_number('N2_AMG'),
1713: p_action_information15 => per_formula_functions.get_number('N2_CE'),
1714: p_action_information16 => per_formula_functions.get_text('N_TOI'),
1715: p_action_information17 => per_formula_functions.get_number('N3_COST'),
1716: p_action_information18 => per_formula_functions.get_number('N3_AMG'),
1717: p_action_information19 => per_formula_functions.get_number('N3_CE'),
1718: p_action_information20 => per_formula_functions.get_number('N4_COST'),
1719: p_action_information21 => per_formula_functions.get_number('N4_AMG'),
1720: p_action_information22 => per_formula_functions.get_number('N4_CE'),
1713: p_action_information15 => per_formula_functions.get_number('N2_CE'),
1714: p_action_information16 => per_formula_functions.get_text('N_TOI'),
1715: p_action_information17 => per_formula_functions.get_number('N3_COST'),
1716: p_action_information18 => per_formula_functions.get_number('N3_AMG'),
1717: p_action_information19 => per_formula_functions.get_number('N3_CE'),
1718: p_action_information20 => per_formula_functions.get_number('N4_COST'),
1719: p_action_information21 => per_formula_functions.get_number('N4_AMG'),
1720: p_action_information22 => per_formula_functions.get_number('N4_CE'),
1721: p_action_information23 => per_formula_functions.get_number('N5_COST'),
1714: p_action_information16 => per_formula_functions.get_text('N_TOI'),
1715: p_action_information17 => per_formula_functions.get_number('N3_COST'),
1716: p_action_information18 => per_formula_functions.get_number('N3_AMG'),
1717: p_action_information19 => per_formula_functions.get_number('N3_CE'),
1718: p_action_information20 => per_formula_functions.get_number('N4_COST'),
1719: p_action_information21 => per_formula_functions.get_number('N4_AMG'),
1720: p_action_information22 => per_formula_functions.get_number('N4_CE'),
1721: p_action_information23 => per_formula_functions.get_number('N5_COST'),
1722: p_action_information24 => per_formula_functions.get_number('N5_AMG'),
1715: p_action_information17 => per_formula_functions.get_number('N3_COST'),
1716: p_action_information18 => per_formula_functions.get_number('N3_AMG'),
1717: p_action_information19 => per_formula_functions.get_number('N3_CE'),
1718: p_action_information20 => per_formula_functions.get_number('N4_COST'),
1719: p_action_information21 => per_formula_functions.get_number('N4_AMG'),
1720: p_action_information22 => per_formula_functions.get_number('N4_CE'),
1721: p_action_information23 => per_formula_functions.get_number('N5_COST'),
1722: p_action_information24 => per_formula_functions.get_number('N5_AMG'),
1723: p_action_information25 => per_formula_functions.get_number('N5_CE'),
1716: p_action_information18 => per_formula_functions.get_number('N3_AMG'),
1717: p_action_information19 => per_formula_functions.get_number('N3_CE'),
1718: p_action_information20 => per_formula_functions.get_number('N4_COST'),
1719: p_action_information21 => per_formula_functions.get_number('N4_AMG'),
1720: p_action_information22 => per_formula_functions.get_number('N4_CE'),
1721: p_action_information23 => per_formula_functions.get_number('N5_COST'),
1722: p_action_information24 => per_formula_functions.get_number('N5_AMG'),
1723: p_action_information25 => per_formula_functions.get_number('N5_CE'),
1724: p_action_information26 => per_formula_functions.get_text('N6_DESC'),
1717: p_action_information19 => per_formula_functions.get_number('N3_CE'),
1718: p_action_information20 => per_formula_functions.get_number('N4_COST'),
1719: p_action_information21 => per_formula_functions.get_number('N4_AMG'),
1720: p_action_information22 => per_formula_functions.get_number('N4_CE'),
1721: p_action_information23 => per_formula_functions.get_number('N5_COST'),
1722: p_action_information24 => per_formula_functions.get_number('N5_AMG'),
1723: p_action_information25 => per_formula_functions.get_number('N5_CE'),
1724: p_action_information26 => per_formula_functions.get_text('N6_DESC'),
1725: p_action_information27 => per_formula_functions.get_number('N6_COST'),
1718: p_action_information20 => per_formula_functions.get_number('N4_COST'),
1719: p_action_information21 => per_formula_functions.get_number('N4_AMG'),
1720: p_action_information22 => per_formula_functions.get_number('N4_CE'),
1721: p_action_information23 => per_formula_functions.get_number('N5_COST'),
1722: p_action_information24 => per_formula_functions.get_number('N5_AMG'),
1723: p_action_information25 => per_formula_functions.get_number('N5_CE'),
1724: p_action_information26 => per_formula_functions.get_text('N6_DESC'),
1725: p_action_information27 => per_formula_functions.get_number('N6_COST'),
1726: p_action_information28 => per_formula_functions.get_number('N6_AMG'),
1719: p_action_information21 => per_formula_functions.get_number('N4_AMG'),
1720: p_action_information22 => per_formula_functions.get_number('N4_CE'),
1721: p_action_information23 => per_formula_functions.get_number('N5_COST'),
1722: p_action_information24 => per_formula_functions.get_number('N5_AMG'),
1723: p_action_information25 => per_formula_functions.get_number('N5_CE'),
1724: p_action_information26 => per_formula_functions.get_text('N6_DESC'),
1725: p_action_information27 => per_formula_functions.get_number('N6_COST'),
1726: p_action_information28 => per_formula_functions.get_number('N6_AMG'),
1727: p_action_information29 => per_formula_functions.get_number('N6_CE')
1720: p_action_information22 => per_formula_functions.get_number('N4_CE'),
1721: p_action_information23 => per_formula_functions.get_number('N5_COST'),
1722: p_action_information24 => per_formula_functions.get_number('N5_AMG'),
1723: p_action_information25 => per_formula_functions.get_number('N5_CE'),
1724: p_action_information26 => per_formula_functions.get_text('N6_DESC'),
1725: p_action_information27 => per_formula_functions.get_number('N6_COST'),
1726: p_action_information28 => per_formula_functions.get_number('N6_AMG'),
1727: p_action_information29 => per_formula_functions.get_number('N6_CE')
1728: ,p_action_information30 => per_formula_functions.get_number('G_FCE'));
1721: p_action_information23 => per_formula_functions.get_number('N5_COST'),
1722: p_action_information24 => per_formula_functions.get_number('N5_AMG'),
1723: p_action_information25 => per_formula_functions.get_number('N5_CE'),
1724: p_action_information26 => per_formula_functions.get_text('N6_DESC'),
1725: p_action_information27 => per_formula_functions.get_number('N6_COST'),
1726: p_action_information28 => per_formula_functions.get_number('N6_AMG'),
1727: p_action_information29 => per_formula_functions.get_number('N6_CE')
1728: ,p_action_information30 => per_formula_functions.get_number('G_FCE'));
1729:
1722: p_action_information24 => per_formula_functions.get_number('N5_AMG'),
1723: p_action_information25 => per_formula_functions.get_number('N5_CE'),
1724: p_action_information26 => per_formula_functions.get_text('N6_DESC'),
1725: p_action_information27 => per_formula_functions.get_number('N6_COST'),
1726: p_action_information28 => per_formula_functions.get_number('N6_AMG'),
1727: p_action_information29 => per_formula_functions.get_number('N6_CE')
1728: ,p_action_information30 => per_formula_functions.get_number('G_FCE'));
1729:
1730:
1723: p_action_information25 => per_formula_functions.get_number('N5_CE'),
1724: p_action_information26 => per_formula_functions.get_text('N6_DESC'),
1725: p_action_information27 => per_formula_functions.get_number('N6_COST'),
1726: p_action_information28 => per_formula_functions.get_number('N6_AMG'),
1727: p_action_information29 => per_formula_functions.get_number('N6_CE')
1728: ,p_action_information30 => per_formula_functions.get_number('G_FCE'));
1729:
1730:
1731: pay_action_information_api.create_action_information(
1724: p_action_information26 => per_formula_functions.get_text('N6_DESC'),
1725: p_action_information27 => per_formula_functions.get_number('N6_COST'),
1726: p_action_information28 => per_formula_functions.get_number('N6_AMG'),
1727: p_action_information29 => per_formula_functions.get_number('N6_CE')
1728: ,p_action_information30 => per_formula_functions.get_number('G_FCE'));
1729:
1730:
1731: pay_action_information_api.create_action_information(
1732: p_action_information_id => l_action_info_id,
1736: p_effective_date => fnd_date.canonical_to_date(g_param_benefit_end_date),
1737: p_source_id => NULL,
1738: p_source_text => NULL,
1739: p_action_information_category => 'GB P11D ASSIGNMENT RESULTC',
1740: p_action_information1 => per_formula_functions.get_number('C_BUS_MILES'),
1741: p_action_information2 => per_formula_functions.get_number('M_BUS_MILES'),
1742: p_action_information3 => per_formula_functions.get_number('B_BUS_MILES'),
1743: p_action_information4 => per_formula_functions.get_number('C_RATE1'),
1744: p_action_information5 => per_formula_functions.get_number('C_RATE2'),
1737: p_source_id => NULL,
1738: p_source_text => NULL,
1739: p_action_information_category => 'GB P11D ASSIGNMENT RESULTC',
1740: p_action_information1 => per_formula_functions.get_number('C_BUS_MILES'),
1741: p_action_information2 => per_formula_functions.get_number('M_BUS_MILES'),
1742: p_action_information3 => per_formula_functions.get_number('B_BUS_MILES'),
1743: p_action_information4 => per_formula_functions.get_number('C_RATE1'),
1744: p_action_information5 => per_formula_functions.get_number('C_RATE2'),
1745: p_action_information6 => per_formula_functions.get_number('M_RATE1'),
1738: p_source_text => NULL,
1739: p_action_information_category => 'GB P11D ASSIGNMENT RESULTC',
1740: p_action_information1 => per_formula_functions.get_number('C_BUS_MILES'),
1741: p_action_information2 => per_formula_functions.get_number('M_BUS_MILES'),
1742: p_action_information3 => per_formula_functions.get_number('B_BUS_MILES'),
1743: p_action_information4 => per_formula_functions.get_number('C_RATE1'),
1744: p_action_information5 => per_formula_functions.get_number('C_RATE2'),
1745: p_action_information6 => per_formula_functions.get_number('M_RATE1'),
1746: p_action_information7 => per_formula_functions.get_number('M_RATE2'),
1739: p_action_information_category => 'GB P11D ASSIGNMENT RESULTC',
1740: p_action_information1 => per_formula_functions.get_number('C_BUS_MILES'),
1741: p_action_information2 => per_formula_functions.get_number('M_BUS_MILES'),
1742: p_action_information3 => per_formula_functions.get_number('B_BUS_MILES'),
1743: p_action_information4 => per_formula_functions.get_number('C_RATE1'),
1744: p_action_information5 => per_formula_functions.get_number('C_RATE2'),
1745: p_action_information6 => per_formula_functions.get_number('M_RATE1'),
1746: p_action_information7 => per_formula_functions.get_number('M_RATE2'),
1747: p_action_information8 => per_formula_functions.get_number('B_RATE1'),
1740: p_action_information1 => per_formula_functions.get_number('C_BUS_MILES'),
1741: p_action_information2 => per_formula_functions.get_number('M_BUS_MILES'),
1742: p_action_information3 => per_formula_functions.get_number('B_BUS_MILES'),
1743: p_action_information4 => per_formula_functions.get_number('C_RATE1'),
1744: p_action_information5 => per_formula_functions.get_number('C_RATE2'),
1745: p_action_information6 => per_formula_functions.get_number('M_RATE1'),
1746: p_action_information7 => per_formula_functions.get_number('M_RATE2'),
1747: p_action_information8 => per_formula_functions.get_number('B_RATE1'),
1748: p_action_information9 => per_formula_functions.get_number('B_RATE2'),
1741: p_action_information2 => per_formula_functions.get_number('M_BUS_MILES'),
1742: p_action_information3 => per_formula_functions.get_number('B_BUS_MILES'),
1743: p_action_information4 => per_formula_functions.get_number('C_RATE1'),
1744: p_action_information5 => per_formula_functions.get_number('C_RATE2'),
1745: p_action_information6 => per_formula_functions.get_number('M_RATE1'),
1746: p_action_information7 => per_formula_functions.get_number('M_RATE2'),
1747: p_action_information8 => per_formula_functions.get_number('B_RATE1'),
1748: p_action_information9 => per_formula_functions.get_number('B_RATE2'),
1749: p_action_information10 => null,
1742: p_action_information3 => per_formula_functions.get_number('B_BUS_MILES'),
1743: p_action_information4 => per_formula_functions.get_number('C_RATE1'),
1744: p_action_information5 => per_formula_functions.get_number('C_RATE2'),
1745: p_action_information6 => per_formula_functions.get_number('M_RATE1'),
1746: p_action_information7 => per_formula_functions.get_number('M_RATE2'),
1747: p_action_information8 => per_formula_functions.get_number('B_RATE1'),
1748: p_action_information9 => per_formula_functions.get_number('B_RATE2'),
1749: p_action_information10 => null,
1750: p_action_information11 => null,
1743: p_action_information4 => per_formula_functions.get_number('C_RATE1'),
1744: p_action_information5 => per_formula_functions.get_number('C_RATE2'),
1745: p_action_information6 => per_formula_functions.get_number('M_RATE1'),
1746: p_action_information7 => per_formula_functions.get_number('M_RATE2'),
1747: p_action_information8 => per_formula_functions.get_number('B_RATE1'),
1748: p_action_information9 => per_formula_functions.get_number('B_RATE2'),
1749: p_action_information10 => null,
1750: p_action_information11 => null,
1751: p_action_information12 => per_formula_functions.get_number('C_MILEAGE_PAYMENTS'),
1744: p_action_information5 => per_formula_functions.get_number('C_RATE2'),
1745: p_action_information6 => per_formula_functions.get_number('M_RATE1'),
1746: p_action_information7 => per_formula_functions.get_number('M_RATE2'),
1747: p_action_information8 => per_formula_functions.get_number('B_RATE1'),
1748: p_action_information9 => per_formula_functions.get_number('B_RATE2'),
1749: p_action_information10 => null,
1750: p_action_information11 => null,
1751: p_action_information12 => per_formula_functions.get_number('C_MILEAGE_PAYMENTS'),
1752: p_action_information13 => per_formula_functions.get_number('B_MILEAGE_PAYMENTS'),
1747: p_action_information8 => per_formula_functions.get_number('B_RATE1'),
1748: p_action_information9 => per_formula_functions.get_number('B_RATE2'),
1749: p_action_information10 => null,
1750: p_action_information11 => null,
1751: p_action_information12 => per_formula_functions.get_number('C_MILEAGE_PAYMENTS'),
1752: p_action_information13 => per_formula_functions.get_number('B_MILEAGE_PAYMENTS'),
1753: p_action_information14 => per_formula_functions.get_number('M_MILEAGE_PAYMENTS'),
1754: p_action_information15 => per_formula_functions.get_number('MARORS_COUNT'),
1755: p_action_information16 => per_formula_functions.get_number('C_TAX_DEDUCTED'),
1748: p_action_information9 => per_formula_functions.get_number('B_RATE2'),
1749: p_action_information10 => null,
1750: p_action_information11 => null,
1751: p_action_information12 => per_formula_functions.get_number('C_MILEAGE_PAYMENTS'),
1752: p_action_information13 => per_formula_functions.get_number('B_MILEAGE_PAYMENTS'),
1753: p_action_information14 => per_formula_functions.get_number('M_MILEAGE_PAYMENTS'),
1754: p_action_information15 => per_formula_functions.get_number('MARORS_COUNT'),
1755: p_action_information16 => per_formula_functions.get_number('C_TAX_DEDUCTED'),
1756: p_action_information17 => per_formula_functions.get_number('B_TAX_DEDUCTED'),
1749: p_action_information10 => null,
1750: p_action_information11 => null,
1751: p_action_information12 => per_formula_functions.get_number('C_MILEAGE_PAYMENTS'),
1752: p_action_information13 => per_formula_functions.get_number('B_MILEAGE_PAYMENTS'),
1753: p_action_information14 => per_formula_functions.get_number('M_MILEAGE_PAYMENTS'),
1754: p_action_information15 => per_formula_functions.get_number('MARORS_COUNT'),
1755: p_action_information16 => per_formula_functions.get_number('C_TAX_DEDUCTED'),
1756: p_action_information17 => per_formula_functions.get_number('B_TAX_DEDUCTED'),
1757: p_action_information18 => per_formula_functions.get_number('M_TAX_DEDUCTED'),
1750: p_action_information11 => null,
1751: p_action_information12 => per_formula_functions.get_number('C_MILEAGE_PAYMENTS'),
1752: p_action_information13 => per_formula_functions.get_number('B_MILEAGE_PAYMENTS'),
1753: p_action_information14 => per_formula_functions.get_number('M_MILEAGE_PAYMENTS'),
1754: p_action_information15 => per_formula_functions.get_number('MARORS_COUNT'),
1755: p_action_information16 => per_formula_functions.get_number('C_TAX_DEDUCTED'),
1756: p_action_information17 => per_formula_functions.get_number('B_TAX_DEDUCTED'),
1757: p_action_information18 => per_formula_functions.get_number('M_TAX_DEDUCTED'),
1758: p_action_information19 => per_formula_functions.get_number('PASSENGER_PAYMENTS'),
1751: p_action_information12 => per_formula_functions.get_number('C_MILEAGE_PAYMENTS'),
1752: p_action_information13 => per_formula_functions.get_number('B_MILEAGE_PAYMENTS'),
1753: p_action_information14 => per_formula_functions.get_number('M_MILEAGE_PAYMENTS'),
1754: p_action_information15 => per_formula_functions.get_number('MARORS_COUNT'),
1755: p_action_information16 => per_formula_functions.get_number('C_TAX_DEDUCTED'),
1756: p_action_information17 => per_formula_functions.get_number('B_TAX_DEDUCTED'),
1757: p_action_information18 => per_formula_functions.get_number('M_TAX_DEDUCTED'),
1758: p_action_information19 => per_formula_functions.get_number('PASSENGER_PAYMENTS'),
1759: p_action_information20 => per_formula_functions.get_number('PASSENGER_BUS_MILES'),
1752: p_action_information13 => per_formula_functions.get_number('B_MILEAGE_PAYMENTS'),
1753: p_action_information14 => per_formula_functions.get_number('M_MILEAGE_PAYMENTS'),
1754: p_action_information15 => per_formula_functions.get_number('MARORS_COUNT'),
1755: p_action_information16 => per_formula_functions.get_number('C_TAX_DEDUCTED'),
1756: p_action_information17 => per_formula_functions.get_number('B_TAX_DEDUCTED'),
1757: p_action_information18 => per_formula_functions.get_number('M_TAX_DEDUCTED'),
1758: p_action_information19 => per_formula_functions.get_number('PASSENGER_PAYMENTS'),
1759: p_action_information20 => per_formula_functions.get_number('PASSENGER_BUS_MILES'),
1760: p_action_information21 => per_formula_functions.get_number('PASSENGER_BUS_MILE_AMT'),
1753: p_action_information14 => per_formula_functions.get_number('M_MILEAGE_PAYMENTS'),
1754: p_action_information15 => per_formula_functions.get_number('MARORS_COUNT'),
1755: p_action_information16 => per_formula_functions.get_number('C_TAX_DEDUCTED'),
1756: p_action_information17 => per_formula_functions.get_number('B_TAX_DEDUCTED'),
1757: p_action_information18 => per_formula_functions.get_number('M_TAX_DEDUCTED'),
1758: p_action_information19 => per_formula_functions.get_number('PASSENGER_PAYMENTS'),
1759: p_action_information20 => per_formula_functions.get_number('PASSENGER_BUS_MILES'),
1760: p_action_information21 => per_formula_functions.get_number('PASSENGER_BUS_MILE_AMT'),
1761: p_action_information22 => per_formula_functions.get_number('MILEAGE_ALLOWANCE_RELIEF'),
1754: p_action_information15 => per_formula_functions.get_number('MARORS_COUNT'),
1755: p_action_information16 => per_formula_functions.get_number('C_TAX_DEDUCTED'),
1756: p_action_information17 => per_formula_functions.get_number('B_TAX_DEDUCTED'),
1757: p_action_information18 => per_formula_functions.get_number('M_TAX_DEDUCTED'),
1758: p_action_information19 => per_formula_functions.get_number('PASSENGER_PAYMENTS'),
1759: p_action_information20 => per_formula_functions.get_number('PASSENGER_BUS_MILES'),
1760: p_action_information21 => per_formula_functions.get_number('PASSENGER_BUS_MILE_AMT'),
1761: p_action_information22 => per_formula_functions.get_number('MILEAGE_ALLOWANCE_RELIEF'),
1762: p_action_information23 => per_formula_functions.get_number('INT_MAX_AMT_OUTSTANDING')
1755: p_action_information16 => per_formula_functions.get_number('C_TAX_DEDUCTED'),
1756: p_action_information17 => per_formula_functions.get_number('B_TAX_DEDUCTED'),
1757: p_action_information18 => per_formula_functions.get_number('M_TAX_DEDUCTED'),
1758: p_action_information19 => per_formula_functions.get_number('PASSENGER_PAYMENTS'),
1759: p_action_information20 => per_formula_functions.get_number('PASSENGER_BUS_MILES'),
1760: p_action_information21 => per_formula_functions.get_number('PASSENGER_BUS_MILE_AMT'),
1761: p_action_information22 => per_formula_functions.get_number('MILEAGE_ALLOWANCE_RELIEF'),
1762: p_action_information23 => per_formula_functions.get_number('INT_MAX_AMT_OUTSTANDING')
1763: );
1756: p_action_information17 => per_formula_functions.get_number('B_TAX_DEDUCTED'),
1757: p_action_information18 => per_formula_functions.get_number('M_TAX_DEDUCTED'),
1758: p_action_information19 => per_formula_functions.get_number('PASSENGER_PAYMENTS'),
1759: p_action_information20 => per_formula_functions.get_number('PASSENGER_BUS_MILES'),
1760: p_action_information21 => per_formula_functions.get_number('PASSENGER_BUS_MILE_AMT'),
1761: p_action_information22 => per_formula_functions.get_number('MILEAGE_ALLOWANCE_RELIEF'),
1762: p_action_information23 => per_formula_functions.get_number('INT_MAX_AMT_OUTSTANDING')
1763: );
1764: end if;
1757: p_action_information18 => per_formula_functions.get_number('M_TAX_DEDUCTED'),
1758: p_action_information19 => per_formula_functions.get_number('PASSENGER_PAYMENTS'),
1759: p_action_information20 => per_formula_functions.get_number('PASSENGER_BUS_MILES'),
1760: p_action_information21 => per_formula_functions.get_number('PASSENGER_BUS_MILE_AMT'),
1761: p_action_information22 => per_formula_functions.get_number('MILEAGE_ALLOWANCE_RELIEF'),
1762: p_action_information23 => per_formula_functions.get_number('INT_MAX_AMT_OUTSTANDING')
1763: );
1764: end if;
1765:
1758: p_action_information19 => per_formula_functions.get_number('PASSENGER_PAYMENTS'),
1759: p_action_information20 => per_formula_functions.get_number('PASSENGER_BUS_MILES'),
1760: p_action_information21 => per_formula_functions.get_number('PASSENGER_BUS_MILE_AMT'),
1761: p_action_information22 => per_formula_functions.get_number('MILEAGE_ALLOWANCE_RELIEF'),
1762: p_action_information23 => per_formula_functions.get_number('INT_MAX_AMT_OUTSTANDING')
1763: );
1764: end if;
1765:
1766: END;
2185: THEN
2186: pay_action_information_api.update_action_information(
2187: p_action_information_id => p_action_info_id,
2188: p_object_version_number => p_ovn,
2189: p_action_information1 => per_formula_functions.get_text('A_DESC'),
2190: p_action_information2 => per_formula_functions.get_number('A_COST'),
2191: p_action_information3 => per_formula_functions.get_number('A_AMG'),
2192: p_action_information4 => per_formula_functions.get_number('A_CE'),
2193: p_action_information5 => per_formula_functions.get_text('B_DESC'),
2186: pay_action_information_api.update_action_information(
2187: p_action_information_id => p_action_info_id,
2188: p_object_version_number => p_ovn,
2189: p_action_information1 => per_formula_functions.get_text('A_DESC'),
2190: p_action_information2 => per_formula_functions.get_number('A_COST'),
2191: p_action_information3 => per_formula_functions.get_number('A_AMG'),
2192: p_action_information4 => per_formula_functions.get_number('A_CE'),
2193: p_action_information5 => per_formula_functions.get_text('B_DESC'),
2194: p_action_information6 => per_formula_functions.get_number('B_CE'),
2187: p_action_information_id => p_action_info_id,
2188: p_object_version_number => p_ovn,
2189: p_action_information1 => per_formula_functions.get_text('A_DESC'),
2190: p_action_information2 => per_formula_functions.get_number('A_COST'),
2191: p_action_information3 => per_formula_functions.get_number('A_AMG'),
2192: p_action_information4 => per_formula_functions.get_number('A_CE'),
2193: p_action_information5 => per_formula_functions.get_text('B_DESC'),
2194: p_action_information6 => per_formula_functions.get_number('B_CE'),
2195: p_action_information7 => per_formula_functions.get_number('B_TNP'),
2188: p_object_version_number => p_ovn,
2189: p_action_information1 => per_formula_functions.get_text('A_DESC'),
2190: p_action_information2 => per_formula_functions.get_number('A_COST'),
2191: p_action_information3 => per_formula_functions.get_number('A_AMG'),
2192: p_action_information4 => per_formula_functions.get_number('A_CE'),
2193: p_action_information5 => per_formula_functions.get_text('B_DESC'),
2194: p_action_information6 => per_formula_functions.get_number('B_CE'),
2195: p_action_information7 => per_formula_functions.get_number('B_TNP'),
2196: p_action_information8 => per_formula_functions.get_number('C_COST'),
2189: p_action_information1 => per_formula_functions.get_text('A_DESC'),
2190: p_action_information2 => per_formula_functions.get_number('A_COST'),
2191: p_action_information3 => per_formula_functions.get_number('A_AMG'),
2192: p_action_information4 => per_formula_functions.get_number('A_CE'),
2193: p_action_information5 => per_formula_functions.get_text('B_DESC'),
2194: p_action_information6 => per_formula_functions.get_number('B_CE'),
2195: p_action_information7 => per_formula_functions.get_number('B_TNP'),
2196: p_action_information8 => per_formula_functions.get_number('C_COST'),
2197: p_action_information9 => per_formula_functions.get_number('C_AMG'),
2190: p_action_information2 => per_formula_functions.get_number('A_COST'),
2191: p_action_information3 => per_formula_functions.get_number('A_AMG'),
2192: p_action_information4 => per_formula_functions.get_number('A_CE'),
2193: p_action_information5 => per_formula_functions.get_text('B_DESC'),
2194: p_action_information6 => per_formula_functions.get_number('B_CE'),
2195: p_action_information7 => per_formula_functions.get_number('B_TNP'),
2196: p_action_information8 => per_formula_functions.get_number('C_COST'),
2197: p_action_information9 => per_formula_functions.get_number('C_AMG'),
2198: p_action_information10 => per_formula_functions.get_number('C_CE'),
2191: p_action_information3 => per_formula_functions.get_number('A_AMG'),
2192: p_action_information4 => per_formula_functions.get_number('A_CE'),
2193: p_action_information5 => per_formula_functions.get_text('B_DESC'),
2194: p_action_information6 => per_formula_functions.get_number('B_CE'),
2195: p_action_information7 => per_formula_functions.get_number('B_TNP'),
2196: p_action_information8 => per_formula_functions.get_number('C_COST'),
2197: p_action_information9 => per_formula_functions.get_number('C_AMG'),
2198: p_action_information10 => per_formula_functions.get_number('C_CE'),
2199: p_action_information11 => per_formula_functions.get_number('D_CE'),
2192: p_action_information4 => per_formula_functions.get_number('A_CE'),
2193: p_action_information5 => per_formula_functions.get_text('B_DESC'),
2194: p_action_information6 => per_formula_functions.get_number('B_CE'),
2195: p_action_information7 => per_formula_functions.get_number('B_TNP'),
2196: p_action_information8 => per_formula_functions.get_number('C_COST'),
2197: p_action_information9 => per_formula_functions.get_number('C_AMG'),
2198: p_action_information10 => per_formula_functions.get_number('C_CE'),
2199: p_action_information11 => per_formula_functions.get_number('D_CE'),
2200: p_action_information12 => calculate_amap_ce ,
2193: p_action_information5 => per_formula_functions.get_text('B_DESC'),
2194: p_action_information6 => per_formula_functions.get_number('B_CE'),
2195: p_action_information7 => per_formula_functions.get_number('B_TNP'),
2196: p_action_information8 => per_formula_functions.get_number('C_COST'),
2197: p_action_information9 => per_formula_functions.get_number('C_AMG'),
2198: p_action_information10 => per_formula_functions.get_number('C_CE'),
2199: p_action_information11 => per_formula_functions.get_number('D_CE'),
2200: p_action_information12 => calculate_amap_ce ,
2201: p_action_information13 => per_formula_functions.get_number('F_TCCE'),
2194: p_action_information6 => per_formula_functions.get_number('B_CE'),
2195: p_action_information7 => per_formula_functions.get_number('B_TNP'),
2196: p_action_information8 => per_formula_functions.get_number('C_COST'),
2197: p_action_information9 => per_formula_functions.get_number('C_AMG'),
2198: p_action_information10 => per_formula_functions.get_number('C_CE'),
2199: p_action_information11 => per_formula_functions.get_number('D_CE'),
2200: p_action_information12 => calculate_amap_ce ,
2201: p_action_information13 => per_formula_functions.get_number('F_TCCE'),
2202: p_action_information14 => per_formula_functions.get_number('F_TFCE'),
2195: p_action_information7 => per_formula_functions.get_number('B_TNP'),
2196: p_action_information8 => per_formula_functions.get_number('C_COST'),
2197: p_action_information9 => per_formula_functions.get_number('C_AMG'),
2198: p_action_information10 => per_formula_functions.get_number('C_CE'),
2199: p_action_information11 => per_formula_functions.get_number('D_CE'),
2200: p_action_information12 => calculate_amap_ce ,
2201: p_action_information13 => per_formula_functions.get_number('F_TCCE'),
2202: p_action_information14 => per_formula_functions.get_number('F_TFCE'),
2203: p_action_information15 => per_formula_functions.get_number('G_CE'),
2197: p_action_information9 => per_formula_functions.get_number('C_AMG'),
2198: p_action_information10 => per_formula_functions.get_number('C_CE'),
2199: p_action_information11 => per_formula_functions.get_number('D_CE'),
2200: p_action_information12 => calculate_amap_ce ,
2201: p_action_information13 => per_formula_functions.get_number('F_TCCE'),
2202: p_action_information14 => per_formula_functions.get_number('F_TFCE'),
2203: p_action_information15 => per_formula_functions.get_number('G_CE'),
2204: p_action_information16 => per_formula_functions.get_number('I_COST'),
2205: p_action_information17 => per_formula_functions.get_number('I_AMG'),
2198: p_action_information10 => per_formula_functions.get_number('C_CE'),
2199: p_action_information11 => per_formula_functions.get_number('D_CE'),
2200: p_action_information12 => calculate_amap_ce ,
2201: p_action_information13 => per_formula_functions.get_number('F_TCCE'),
2202: p_action_information14 => per_formula_functions.get_number('F_TFCE'),
2203: p_action_information15 => per_formula_functions.get_number('G_CE'),
2204: p_action_information16 => per_formula_functions.get_number('I_COST'),
2205: p_action_information17 => per_formula_functions.get_number('I_AMG'),
2206: p_action_information18 => per_formula_functions.get_number('I_CE'),
2199: p_action_information11 => per_formula_functions.get_number('D_CE'),
2200: p_action_information12 => calculate_amap_ce ,
2201: p_action_information13 => per_formula_functions.get_number('F_TCCE'),
2202: p_action_information14 => per_formula_functions.get_number('F_TFCE'),
2203: p_action_information15 => per_formula_functions.get_number('G_CE'),
2204: p_action_information16 => per_formula_functions.get_number('I_COST'),
2205: p_action_information17 => per_formula_functions.get_number('I_AMG'),
2206: p_action_information18 => per_formula_functions.get_number('I_CE'),
2207: p_action_information19 => per_formula_functions.get_number('J_CE'),
2200: p_action_information12 => calculate_amap_ce ,
2201: p_action_information13 => per_formula_functions.get_number('F_TCCE'),
2202: p_action_information14 => per_formula_functions.get_number('F_TFCE'),
2203: p_action_information15 => per_formula_functions.get_number('G_CE'),
2204: p_action_information16 => per_formula_functions.get_number('I_COST'),
2205: p_action_information17 => per_formula_functions.get_number('I_AMG'),
2206: p_action_information18 => per_formula_functions.get_number('I_CE'),
2207: p_action_information19 => per_formula_functions.get_number('J_CE'),
2208: p_action_information20 => per_formula_functions.get_number('K_COST'),
2201: p_action_information13 => per_formula_functions.get_number('F_TCCE'),
2202: p_action_information14 => per_formula_functions.get_number('F_TFCE'),
2203: p_action_information15 => per_formula_functions.get_number('G_CE'),
2204: p_action_information16 => per_formula_functions.get_number('I_COST'),
2205: p_action_information17 => per_formula_functions.get_number('I_AMG'),
2206: p_action_information18 => per_formula_functions.get_number('I_CE'),
2207: p_action_information19 => per_formula_functions.get_number('J_CE'),
2208: p_action_information20 => per_formula_functions.get_number('K_COST'),
2209: p_action_information21 => per_formula_functions.get_number('K_AMG'),
2202: p_action_information14 => per_formula_functions.get_number('F_TFCE'),
2203: p_action_information15 => per_formula_functions.get_number('G_CE'),
2204: p_action_information16 => per_formula_functions.get_number('I_COST'),
2205: p_action_information17 => per_formula_functions.get_number('I_AMG'),
2206: p_action_information18 => per_formula_functions.get_number('I_CE'),
2207: p_action_information19 => per_formula_functions.get_number('J_CE'),
2208: p_action_information20 => per_formula_functions.get_number('K_COST'),
2209: p_action_information21 => per_formula_functions.get_number('K_AMG'),
2210: p_action_information22 => per_formula_functions.get_number('K_CE'),
2203: p_action_information15 => per_formula_functions.get_number('G_CE'),
2204: p_action_information16 => per_formula_functions.get_number('I_COST'),
2205: p_action_information17 => per_formula_functions.get_number('I_AMG'),
2206: p_action_information18 => per_formula_functions.get_number('I_CE'),
2207: p_action_information19 => per_formula_functions.get_number('J_CE'),
2208: p_action_information20 => per_formula_functions.get_number('K_COST'),
2209: p_action_information21 => per_formula_functions.get_number('K_AMG'),
2210: p_action_information22 => per_formula_functions.get_number('K_CE'),
2211: p_action_information23 => per_formula_functions.get_text('L_DESC'),
2204: p_action_information16 => per_formula_functions.get_number('I_COST'),
2205: p_action_information17 => per_formula_functions.get_number('I_AMG'),
2206: p_action_information18 => per_formula_functions.get_number('I_CE'),
2207: p_action_information19 => per_formula_functions.get_number('J_CE'),
2208: p_action_information20 => per_formula_functions.get_number('K_COST'),
2209: p_action_information21 => per_formula_functions.get_number('K_AMG'),
2210: p_action_information22 => per_formula_functions.get_number('K_CE'),
2211: p_action_information23 => per_formula_functions.get_text('L_DESC'),
2212: p_action_information24 => per_formula_functions.get_number('L_COST'),
2205: p_action_information17 => per_formula_functions.get_number('I_AMG'),
2206: p_action_information18 => per_formula_functions.get_number('I_CE'),
2207: p_action_information19 => per_formula_functions.get_number('J_CE'),
2208: p_action_information20 => per_formula_functions.get_number('K_COST'),
2209: p_action_information21 => per_formula_functions.get_number('K_AMG'),
2210: p_action_information22 => per_formula_functions.get_number('K_CE'),
2211: p_action_information23 => per_formula_functions.get_text('L_DESC'),
2212: p_action_information24 => per_formula_functions.get_number('L_COST'),
2213: p_action_information25 => per_formula_functions.get_number('L_AMG'),
2206: p_action_information18 => per_formula_functions.get_number('I_CE'),
2207: p_action_information19 => per_formula_functions.get_number('J_CE'),
2208: p_action_information20 => per_formula_functions.get_number('K_COST'),
2209: p_action_information21 => per_formula_functions.get_number('K_AMG'),
2210: p_action_information22 => per_formula_functions.get_number('K_CE'),
2211: p_action_information23 => per_formula_functions.get_text('L_DESC'),
2212: p_action_information24 => per_formula_functions.get_number('L_COST'),
2213: p_action_information25 => per_formula_functions.get_number('L_AMG'),
2214: p_action_information26 => per_formula_functions.get_number('L_CE'),
2207: p_action_information19 => per_formula_functions.get_number('J_CE'),
2208: p_action_information20 => per_formula_functions.get_number('K_COST'),
2209: p_action_information21 => per_formula_functions.get_number('K_AMG'),
2210: p_action_information22 => per_formula_functions.get_number('K_CE'),
2211: p_action_information23 => per_formula_functions.get_text('L_DESC'),
2212: p_action_information24 => per_formula_functions.get_number('L_COST'),
2213: p_action_information25 => per_formula_functions.get_number('L_AMG'),
2214: p_action_information26 => per_formula_functions.get_number('L_CE'),
2215: p_action_information27 => per_formula_functions.get_text('M_SHARES'),
2208: p_action_information20 => per_formula_functions.get_number('K_COST'),
2209: p_action_information21 => per_formula_functions.get_number('K_AMG'),
2210: p_action_information22 => per_formula_functions.get_number('K_CE'),
2211: p_action_information23 => per_formula_functions.get_text('L_DESC'),
2212: p_action_information24 => per_formula_functions.get_number('L_COST'),
2213: p_action_information25 => per_formula_functions.get_number('L_AMG'),
2214: p_action_information26 => per_formula_functions.get_number('L_CE'),
2215: p_action_information27 => per_formula_functions.get_text('M_SHARES'),
2216: p_action_information28 => per_formula_functions.get_number('H_CE1'),
2209: p_action_information21 => per_formula_functions.get_number('K_AMG'),
2210: p_action_information22 => per_formula_functions.get_number('K_CE'),
2211: p_action_information23 => per_formula_functions.get_text('L_DESC'),
2212: p_action_information24 => per_formula_functions.get_number('L_COST'),
2213: p_action_information25 => per_formula_functions.get_number('L_AMG'),
2214: p_action_information26 => per_formula_functions.get_number('L_CE'),
2215: p_action_information27 => per_formula_functions.get_text('M_SHARES'),
2216: p_action_information28 => per_formula_functions.get_number('H_CE1'),
2217: p_action_information29 => per_formula_functions.get_number('H_COUNT'),
2210: p_action_information22 => per_formula_functions.get_number('K_CE'),
2211: p_action_information23 => per_formula_functions.get_text('L_DESC'),
2212: p_action_information24 => per_formula_functions.get_number('L_COST'),
2213: p_action_information25 => per_formula_functions.get_number('L_AMG'),
2214: p_action_information26 => per_formula_functions.get_number('L_CE'),
2215: p_action_information27 => per_formula_functions.get_text('M_SHARES'),
2216: p_action_information28 => per_formula_functions.get_number('H_CE1'),
2217: p_action_information29 => per_formula_functions.get_number('H_COUNT'),
2218: p_action_information30 => per_formula_functions.get_number('F_COUNT') );
2211: p_action_information23 => per_formula_functions.get_text('L_DESC'),
2212: p_action_information24 => per_formula_functions.get_number('L_COST'),
2213: p_action_information25 => per_formula_functions.get_number('L_AMG'),
2214: p_action_information26 => per_formula_functions.get_number('L_CE'),
2215: p_action_information27 => per_formula_functions.get_text('M_SHARES'),
2216: p_action_information28 => per_formula_functions.get_number('H_CE1'),
2217: p_action_information29 => per_formula_functions.get_number('H_COUNT'),
2218: p_action_information30 => per_formula_functions.get_number('F_COUNT') );
2219: END IF;
2212: p_action_information24 => per_formula_functions.get_number('L_COST'),
2213: p_action_information25 => per_formula_functions.get_number('L_AMG'),
2214: p_action_information26 => per_formula_functions.get_number('L_CE'),
2215: p_action_information27 => per_formula_functions.get_text('M_SHARES'),
2216: p_action_information28 => per_formula_functions.get_number('H_CE1'),
2217: p_action_information29 => per_formula_functions.get_number('H_COUNT'),
2218: p_action_information30 => per_formula_functions.get_number('F_COUNT') );
2219: END IF;
2220:
2213: p_action_information25 => per_formula_functions.get_number('L_AMG'),
2214: p_action_information26 => per_formula_functions.get_number('L_CE'),
2215: p_action_information27 => per_formula_functions.get_text('M_SHARES'),
2216: p_action_information28 => per_formula_functions.get_number('H_CE1'),
2217: p_action_information29 => per_formula_functions.get_number('H_COUNT'),
2218: p_action_information30 => per_formula_functions.get_number('F_COUNT') );
2219: END IF;
2220:
2221: IF p_action_info_category = 'GB P11D ASSIGNMENT RESULTB'
2214: p_action_information26 => per_formula_functions.get_number('L_CE'),
2215: p_action_information27 => per_formula_functions.get_text('M_SHARES'),
2216: p_action_information28 => per_formula_functions.get_number('H_CE1'),
2217: p_action_information29 => per_formula_functions.get_number('H_COUNT'),
2218: p_action_information30 => per_formula_functions.get_number('F_COUNT') );
2219: END IF;
2220:
2221: IF p_action_info_category = 'GB P11D ASSIGNMENT RESULTB'
2222: THEN
2222: THEN
2223: pay_action_information_api.update_action_information(
2224: p_action_information_id => p_action_info_id,
2225: p_object_version_number => p_ovn,
2226: p_action_information1 => per_formula_functions.get_text('N_DESC'),
2227: p_action_information2 => per_formula_functions.get_number('N_COST'),
2228: p_action_information3 => per_formula_functions.get_number('N_AMG'),
2229: p_action_information4 => per_formula_functions.get_number('N_CE'),
2230: p_action_information5 => per_formula_functions.get_text('NA_DESC'),
2223: pay_action_information_api.update_action_information(
2224: p_action_information_id => p_action_info_id,
2225: p_object_version_number => p_ovn,
2226: p_action_information1 => per_formula_functions.get_text('N_DESC'),
2227: p_action_information2 => per_formula_functions.get_number('N_COST'),
2228: p_action_information3 => per_formula_functions.get_number('N_AMG'),
2229: p_action_information4 => per_formula_functions.get_number('N_CE'),
2230: p_action_information5 => per_formula_functions.get_text('NA_DESC'),
2231: p_action_information6 => per_formula_functions.get_number('NA_COST'),
2224: p_action_information_id => p_action_info_id,
2225: p_object_version_number => p_ovn,
2226: p_action_information1 => per_formula_functions.get_text('N_DESC'),
2227: p_action_information2 => per_formula_functions.get_number('N_COST'),
2228: p_action_information3 => per_formula_functions.get_number('N_AMG'),
2229: p_action_information4 => per_formula_functions.get_number('N_CE'),
2230: p_action_information5 => per_formula_functions.get_text('NA_DESC'),
2231: p_action_information6 => per_formula_functions.get_number('NA_COST'),
2232: p_action_information7 => per_formula_functions.get_number('NA_AMG'),
2225: p_object_version_number => p_ovn,
2226: p_action_information1 => per_formula_functions.get_text('N_DESC'),
2227: p_action_information2 => per_formula_functions.get_number('N_COST'),
2228: p_action_information3 => per_formula_functions.get_number('N_AMG'),
2229: p_action_information4 => per_formula_functions.get_number('N_CE'),
2230: p_action_information5 => per_formula_functions.get_text('NA_DESC'),
2231: p_action_information6 => per_formula_functions.get_number('NA_COST'),
2232: p_action_information7 => per_formula_functions.get_number('NA_AMG'),
2233: p_action_information8 => per_formula_functions.get_number('NA_CE'),
2226: p_action_information1 => per_formula_functions.get_text('N_DESC'),
2227: p_action_information2 => per_formula_functions.get_number('N_COST'),
2228: p_action_information3 => per_formula_functions.get_number('N_AMG'),
2229: p_action_information4 => per_formula_functions.get_number('N_CE'),
2230: p_action_information5 => per_formula_functions.get_text('NA_DESC'),
2231: p_action_information6 => per_formula_functions.get_number('NA_COST'),
2232: p_action_information7 => per_formula_functions.get_number('NA_AMG'),
2233: p_action_information8 => per_formula_functions.get_number('NA_CE'),
2234: p_action_information9 => per_formula_functions.get_number('N_TAXPAID'),
2227: p_action_information2 => per_formula_functions.get_number('N_COST'),
2228: p_action_information3 => per_formula_functions.get_number('N_AMG'),
2229: p_action_information4 => per_formula_functions.get_number('N_CE'),
2230: p_action_information5 => per_formula_functions.get_text('NA_DESC'),
2231: p_action_information6 => per_formula_functions.get_number('NA_COST'),
2232: p_action_information7 => per_formula_functions.get_number('NA_AMG'),
2233: p_action_information8 => per_formula_functions.get_number('NA_CE'),
2234: p_action_information9 => per_formula_functions.get_number('N_TAXPAID'),
2235: p_action_information10 => per_formula_functions.get_number('O1_COST'),
2228: p_action_information3 => per_formula_functions.get_number('N_AMG'),
2229: p_action_information4 => per_formula_functions.get_number('N_CE'),
2230: p_action_information5 => per_formula_functions.get_text('NA_DESC'),
2231: p_action_information6 => per_formula_functions.get_number('NA_COST'),
2232: p_action_information7 => per_formula_functions.get_number('NA_AMG'),
2233: p_action_information8 => per_formula_functions.get_number('NA_CE'),
2234: p_action_information9 => per_formula_functions.get_number('N_TAXPAID'),
2235: p_action_information10 => per_formula_functions.get_number('O1_COST'),
2236: p_action_information11 => per_formula_functions.get_number('O1_AMG'),
2229: p_action_information4 => per_formula_functions.get_number('N_CE'),
2230: p_action_information5 => per_formula_functions.get_text('NA_DESC'),
2231: p_action_information6 => per_formula_functions.get_number('NA_COST'),
2232: p_action_information7 => per_formula_functions.get_number('NA_AMG'),
2233: p_action_information8 => per_formula_functions.get_number('NA_CE'),
2234: p_action_information9 => per_formula_functions.get_number('N_TAXPAID'),
2235: p_action_information10 => per_formula_functions.get_number('O1_COST'),
2236: p_action_information11 => per_formula_functions.get_number('O1_AMG'),
2237: p_action_information12 => per_formula_functions.get_number('O1_CE'),
2230: p_action_information5 => per_formula_functions.get_text('NA_DESC'),
2231: p_action_information6 => per_formula_functions.get_number('NA_COST'),
2232: p_action_information7 => per_formula_functions.get_number('NA_AMG'),
2233: p_action_information8 => per_formula_functions.get_number('NA_CE'),
2234: p_action_information9 => per_formula_functions.get_number('N_TAXPAID'),
2235: p_action_information10 => per_formula_functions.get_number('O1_COST'),
2236: p_action_information11 => per_formula_functions.get_number('O1_AMG'),
2237: p_action_information12 => per_formula_functions.get_number('O1_CE'),
2238: p_action_information13 => per_formula_functions.get_number('O2_COST'),
2231: p_action_information6 => per_formula_functions.get_number('NA_COST'),
2232: p_action_information7 => per_formula_functions.get_number('NA_AMG'),
2233: p_action_information8 => per_formula_functions.get_number('NA_CE'),
2234: p_action_information9 => per_formula_functions.get_number('N_TAXPAID'),
2235: p_action_information10 => per_formula_functions.get_number('O1_COST'),
2236: p_action_information11 => per_formula_functions.get_number('O1_AMG'),
2237: p_action_information12 => per_formula_functions.get_number('O1_CE'),
2238: p_action_information13 => per_formula_functions.get_number('O2_COST'),
2239: p_action_information14 => per_formula_functions.get_number('O2_AMG'),
2232: p_action_information7 => per_formula_functions.get_number('NA_AMG'),
2233: p_action_information8 => per_formula_functions.get_number('NA_CE'),
2234: p_action_information9 => per_formula_functions.get_number('N_TAXPAID'),
2235: p_action_information10 => per_formula_functions.get_number('O1_COST'),
2236: p_action_information11 => per_formula_functions.get_number('O1_AMG'),
2237: p_action_information12 => per_formula_functions.get_number('O1_CE'),
2238: p_action_information13 => per_formula_functions.get_number('O2_COST'),
2239: p_action_information14 => per_formula_functions.get_number('O2_AMG'),
2240: p_action_information15 => per_formula_functions.get_number('O2_CE'),
2233: p_action_information8 => per_formula_functions.get_number('NA_CE'),
2234: p_action_information9 => per_formula_functions.get_number('N_TAXPAID'),
2235: p_action_information10 => per_formula_functions.get_number('O1_COST'),
2236: p_action_information11 => per_formula_functions.get_number('O1_AMG'),
2237: p_action_information12 => per_formula_functions.get_number('O1_CE'),
2238: p_action_information13 => per_formula_functions.get_number('O2_COST'),
2239: p_action_information14 => per_formula_functions.get_number('O2_AMG'),
2240: p_action_information15 => per_formula_functions.get_number('O2_CE'),
2241: p_action_information16 => per_formula_functions.get_text('O_TOI'),
2234: p_action_information9 => per_formula_functions.get_number('N_TAXPAID'),
2235: p_action_information10 => per_formula_functions.get_number('O1_COST'),
2236: p_action_information11 => per_formula_functions.get_number('O1_AMG'),
2237: p_action_information12 => per_formula_functions.get_number('O1_CE'),
2238: p_action_information13 => per_formula_functions.get_number('O2_COST'),
2239: p_action_information14 => per_formula_functions.get_number('O2_AMG'),
2240: p_action_information15 => per_formula_functions.get_number('O2_CE'),
2241: p_action_information16 => per_formula_functions.get_text('O_TOI'),
2242: p_action_information17 => per_formula_functions.get_number('O3_COST'),
2235: p_action_information10 => per_formula_functions.get_number('O1_COST'),
2236: p_action_information11 => per_formula_functions.get_number('O1_AMG'),
2237: p_action_information12 => per_formula_functions.get_number('O1_CE'),
2238: p_action_information13 => per_formula_functions.get_number('O2_COST'),
2239: p_action_information14 => per_formula_functions.get_number('O2_AMG'),
2240: p_action_information15 => per_formula_functions.get_number('O2_CE'),
2241: p_action_information16 => per_formula_functions.get_text('O_TOI'),
2242: p_action_information17 => per_formula_functions.get_number('O3_COST'),
2243: p_action_information18 => per_formula_functions.get_number('O3_AMG'),
2236: p_action_information11 => per_formula_functions.get_number('O1_AMG'),
2237: p_action_information12 => per_formula_functions.get_number('O1_CE'),
2238: p_action_information13 => per_formula_functions.get_number('O2_COST'),
2239: p_action_information14 => per_formula_functions.get_number('O2_AMG'),
2240: p_action_information15 => per_formula_functions.get_number('O2_CE'),
2241: p_action_information16 => per_formula_functions.get_text('O_TOI'),
2242: p_action_information17 => per_formula_functions.get_number('O3_COST'),
2243: p_action_information18 => per_formula_functions.get_number('O3_AMG'),
2244: p_action_information19 => per_formula_functions.get_number('O3_CE'),
2237: p_action_information12 => per_formula_functions.get_number('O1_CE'),
2238: p_action_information13 => per_formula_functions.get_number('O2_COST'),
2239: p_action_information14 => per_formula_functions.get_number('O2_AMG'),
2240: p_action_information15 => per_formula_functions.get_number('O2_CE'),
2241: p_action_information16 => per_formula_functions.get_text('O_TOI'),
2242: p_action_information17 => per_formula_functions.get_number('O3_COST'),
2243: p_action_information18 => per_formula_functions.get_number('O3_AMG'),
2244: p_action_information19 => per_formula_functions.get_number('O3_CE'),
2245: p_action_information20 => per_formula_functions.get_number('O4_COST'),
2238: p_action_information13 => per_formula_functions.get_number('O2_COST'),
2239: p_action_information14 => per_formula_functions.get_number('O2_AMG'),
2240: p_action_information15 => per_formula_functions.get_number('O2_CE'),
2241: p_action_information16 => per_formula_functions.get_text('O_TOI'),
2242: p_action_information17 => per_formula_functions.get_number('O3_COST'),
2243: p_action_information18 => per_formula_functions.get_number('O3_AMG'),
2244: p_action_information19 => per_formula_functions.get_number('O3_CE'),
2245: p_action_information20 => per_formula_functions.get_number('O4_COST'),
2246: p_action_information21 => per_formula_functions.get_number('O4_AMG'),
2239: p_action_information14 => per_formula_functions.get_number('O2_AMG'),
2240: p_action_information15 => per_formula_functions.get_number('O2_CE'),
2241: p_action_information16 => per_formula_functions.get_text('O_TOI'),
2242: p_action_information17 => per_formula_functions.get_number('O3_COST'),
2243: p_action_information18 => per_formula_functions.get_number('O3_AMG'),
2244: p_action_information19 => per_formula_functions.get_number('O3_CE'),
2245: p_action_information20 => per_formula_functions.get_number('O4_COST'),
2246: p_action_information21 => per_formula_functions.get_number('O4_AMG'),
2247: p_action_information22 => per_formula_functions.get_number('O4_CE'),
2240: p_action_information15 => per_formula_functions.get_number('O2_CE'),
2241: p_action_information16 => per_formula_functions.get_text('O_TOI'),
2242: p_action_information17 => per_formula_functions.get_number('O3_COST'),
2243: p_action_information18 => per_formula_functions.get_number('O3_AMG'),
2244: p_action_information19 => per_formula_functions.get_number('O3_CE'),
2245: p_action_information20 => per_formula_functions.get_number('O4_COST'),
2246: p_action_information21 => per_formula_functions.get_number('O4_AMG'),
2247: p_action_information22 => per_formula_functions.get_number('O4_CE'),
2248: p_action_information23 => per_formula_functions.get_number('O5_COST'),
2241: p_action_information16 => per_formula_functions.get_text('O_TOI'),
2242: p_action_information17 => per_formula_functions.get_number('O3_COST'),
2243: p_action_information18 => per_formula_functions.get_number('O3_AMG'),
2244: p_action_information19 => per_formula_functions.get_number('O3_CE'),
2245: p_action_information20 => per_formula_functions.get_number('O4_COST'),
2246: p_action_information21 => per_formula_functions.get_number('O4_AMG'),
2247: p_action_information22 => per_formula_functions.get_number('O4_CE'),
2248: p_action_information23 => per_formula_functions.get_number('O5_COST'),
2249: p_action_information24 => per_formula_functions.get_number('O5_AMG'),
2242: p_action_information17 => per_formula_functions.get_number('O3_COST'),
2243: p_action_information18 => per_formula_functions.get_number('O3_AMG'),
2244: p_action_information19 => per_formula_functions.get_number('O3_CE'),
2245: p_action_information20 => per_formula_functions.get_number('O4_COST'),
2246: p_action_information21 => per_formula_functions.get_number('O4_AMG'),
2247: p_action_information22 => per_formula_functions.get_number('O4_CE'),
2248: p_action_information23 => per_formula_functions.get_number('O5_COST'),
2249: p_action_information24 => per_formula_functions.get_number('O5_AMG'),
2250: p_action_information25 => per_formula_functions.get_number('O5_CE'),
2243: p_action_information18 => per_formula_functions.get_number('O3_AMG'),
2244: p_action_information19 => per_formula_functions.get_number('O3_CE'),
2245: p_action_information20 => per_formula_functions.get_number('O4_COST'),
2246: p_action_information21 => per_formula_functions.get_number('O4_AMG'),
2247: p_action_information22 => per_formula_functions.get_number('O4_CE'),
2248: p_action_information23 => per_formula_functions.get_number('O5_COST'),
2249: p_action_information24 => per_formula_functions.get_number('O5_AMG'),
2250: p_action_information25 => per_formula_functions.get_number('O5_CE'),
2251: p_action_information26 => per_formula_functions.get_text('O6_DESC'),
2244: p_action_information19 => per_formula_functions.get_number('O3_CE'),
2245: p_action_information20 => per_formula_functions.get_number('O4_COST'),
2246: p_action_information21 => per_formula_functions.get_number('O4_AMG'),
2247: p_action_information22 => per_formula_functions.get_number('O4_CE'),
2248: p_action_information23 => per_formula_functions.get_number('O5_COST'),
2249: p_action_information24 => per_formula_functions.get_number('O5_AMG'),
2250: p_action_information25 => per_formula_functions.get_number('O5_CE'),
2251: p_action_information26 => per_formula_functions.get_text('O6_DESC'),
2252: p_action_information27 => per_formula_functions.get_number('O6_COST'),
2245: p_action_information20 => per_formula_functions.get_number('O4_COST'),
2246: p_action_information21 => per_formula_functions.get_number('O4_AMG'),
2247: p_action_information22 => per_formula_functions.get_number('O4_CE'),
2248: p_action_information23 => per_formula_functions.get_number('O5_COST'),
2249: p_action_information24 => per_formula_functions.get_number('O5_AMG'),
2250: p_action_information25 => per_formula_functions.get_number('O5_CE'),
2251: p_action_information26 => per_formula_functions.get_text('O6_DESC'),
2252: p_action_information27 => per_formula_functions.get_number('O6_COST'),
2253: p_action_information28 => per_formula_functions.get_number('O6_AMG'),
2246: p_action_information21 => per_formula_functions.get_number('O4_AMG'),
2247: p_action_information22 => per_formula_functions.get_number('O4_CE'),
2248: p_action_information23 => per_formula_functions.get_number('O5_COST'),
2249: p_action_information24 => per_formula_functions.get_number('O5_AMG'),
2250: p_action_information25 => per_formula_functions.get_number('O5_CE'),
2251: p_action_information26 => per_formula_functions.get_text('O6_DESC'),
2252: p_action_information27 => per_formula_functions.get_number('O6_COST'),
2253: p_action_information28 => per_formula_functions.get_number('O6_AMG'),
2254: p_action_information29 => per_formula_functions.get_number('O6_CE') );
2247: p_action_information22 => per_formula_functions.get_number('O4_CE'),
2248: p_action_information23 => per_formula_functions.get_number('O5_COST'),
2249: p_action_information24 => per_formula_functions.get_number('O5_AMG'),
2250: p_action_information25 => per_formula_functions.get_number('O5_CE'),
2251: p_action_information26 => per_formula_functions.get_text('O6_DESC'),
2252: p_action_information27 => per_formula_functions.get_number('O6_COST'),
2253: p_action_information28 => per_formula_functions.get_number('O6_AMG'),
2254: p_action_information29 => per_formula_functions.get_number('O6_CE') );
2255: END IF;
2248: p_action_information23 => per_formula_functions.get_number('O5_COST'),
2249: p_action_information24 => per_formula_functions.get_number('O5_AMG'),
2250: p_action_information25 => per_formula_functions.get_number('O5_CE'),
2251: p_action_information26 => per_formula_functions.get_text('O6_DESC'),
2252: p_action_information27 => per_formula_functions.get_number('O6_COST'),
2253: p_action_information28 => per_formula_functions.get_number('O6_AMG'),
2254: p_action_information29 => per_formula_functions.get_number('O6_CE') );
2255: END IF;
2256:
2249: p_action_information24 => per_formula_functions.get_number('O5_AMG'),
2250: p_action_information25 => per_formula_functions.get_number('O5_CE'),
2251: p_action_information26 => per_formula_functions.get_text('O6_DESC'),
2252: p_action_information27 => per_formula_functions.get_number('O6_COST'),
2253: p_action_information28 => per_formula_functions.get_number('O6_AMG'),
2254: p_action_information29 => per_formula_functions.get_number('O6_CE') );
2255: END IF;
2256:
2257: IF p_action_info_category = 'GB P11D ASSIGNMENT RESULTC'
2250: p_action_information25 => per_formula_functions.get_number('O5_CE'),
2251: p_action_information26 => per_formula_functions.get_text('O6_DESC'),
2252: p_action_information27 => per_formula_functions.get_number('O6_COST'),
2253: p_action_information28 => per_formula_functions.get_number('O6_AMG'),
2254: p_action_information29 => per_formula_functions.get_number('O6_CE') );
2255: END IF;
2256:
2257: IF p_action_info_category = 'GB P11D ASSIGNMENT RESULTC'
2258: THEN
2258: THEN
2259: pay_action_information_api.update_action_information(
2260: p_action_information_id => p_action_info_id,
2261: p_object_version_number => p_ovn,
2262: p_action_information1 => per_formula_functions.get_number('C_BUS_MILES'),
2263: p_action_information2 => per_formula_functions.get_number('M_BUS_MILES'),
2264: p_action_information3 => per_formula_functions.get_number('B_BUS_MILES'),
2265: p_action_information4 => per_formula_functions.get_number('C_RATE1'),
2266: p_action_information5 => per_formula_functions.get_number('C_RATE2'),
2259: pay_action_information_api.update_action_information(
2260: p_action_information_id => p_action_info_id,
2261: p_object_version_number => p_ovn,
2262: p_action_information1 => per_formula_functions.get_number('C_BUS_MILES'),
2263: p_action_information2 => per_formula_functions.get_number('M_BUS_MILES'),
2264: p_action_information3 => per_formula_functions.get_number('B_BUS_MILES'),
2265: p_action_information4 => per_formula_functions.get_number('C_RATE1'),
2266: p_action_information5 => per_formula_functions.get_number('C_RATE2'),
2267: p_action_information6 => per_formula_functions.get_number('M_RATE1'),
2260: p_action_information_id => p_action_info_id,
2261: p_object_version_number => p_ovn,
2262: p_action_information1 => per_formula_functions.get_number('C_BUS_MILES'),
2263: p_action_information2 => per_formula_functions.get_number('M_BUS_MILES'),
2264: p_action_information3 => per_formula_functions.get_number('B_BUS_MILES'),
2265: p_action_information4 => per_formula_functions.get_number('C_RATE1'),
2266: p_action_information5 => per_formula_functions.get_number('C_RATE2'),
2267: p_action_information6 => per_formula_functions.get_number('M_RATE1'),
2268: p_action_information7 => per_formula_functions.get_number('M_RATE2'),
2261: p_object_version_number => p_ovn,
2262: p_action_information1 => per_formula_functions.get_number('C_BUS_MILES'),
2263: p_action_information2 => per_formula_functions.get_number('M_BUS_MILES'),
2264: p_action_information3 => per_formula_functions.get_number('B_BUS_MILES'),
2265: p_action_information4 => per_formula_functions.get_number('C_RATE1'),
2266: p_action_information5 => per_formula_functions.get_number('C_RATE2'),
2267: p_action_information6 => per_formula_functions.get_number('M_RATE1'),
2268: p_action_information7 => per_formula_functions.get_number('M_RATE2'),
2269: p_action_information8 => per_formula_functions.get_number('B_RATE1'),
2262: p_action_information1 => per_formula_functions.get_number('C_BUS_MILES'),
2263: p_action_information2 => per_formula_functions.get_number('M_BUS_MILES'),
2264: p_action_information3 => per_formula_functions.get_number('B_BUS_MILES'),
2265: p_action_information4 => per_formula_functions.get_number('C_RATE1'),
2266: p_action_information5 => per_formula_functions.get_number('C_RATE2'),
2267: p_action_information6 => per_formula_functions.get_number('M_RATE1'),
2268: p_action_information7 => per_formula_functions.get_number('M_RATE2'),
2269: p_action_information8 => per_formula_functions.get_number('B_RATE1'),
2270: p_action_information9 => per_formula_functions.get_number('B_RATE2'),
2263: p_action_information2 => per_formula_functions.get_number('M_BUS_MILES'),
2264: p_action_information3 => per_formula_functions.get_number('B_BUS_MILES'),
2265: p_action_information4 => per_formula_functions.get_number('C_RATE1'),
2266: p_action_information5 => per_formula_functions.get_number('C_RATE2'),
2267: p_action_information6 => per_formula_functions.get_number('M_RATE1'),
2268: p_action_information7 => per_formula_functions.get_number('M_RATE2'),
2269: p_action_information8 => per_formula_functions.get_number('B_RATE1'),
2270: p_action_information9 => per_formula_functions.get_number('B_RATE2'),
2271: p_action_information10 => per_formula_functions.get_text('DT_FREE_FUEL_WITHDRAWN'),
2264: p_action_information3 => per_formula_functions.get_number('B_BUS_MILES'),
2265: p_action_information4 => per_formula_functions.get_number('C_RATE1'),
2266: p_action_information5 => per_formula_functions.get_number('C_RATE2'),
2267: p_action_information6 => per_formula_functions.get_number('M_RATE1'),
2268: p_action_information7 => per_formula_functions.get_number('M_RATE2'),
2269: p_action_information8 => per_formula_functions.get_number('B_RATE1'),
2270: p_action_information9 => per_formula_functions.get_number('B_RATE2'),
2271: p_action_information10 => per_formula_functions.get_text('DT_FREE_FUEL_WITHDRAWN'),
2272: p_action_information11 => per_formula_functions.get_text('FREE_FUEL_REINSTATED'),
2265: p_action_information4 => per_formula_functions.get_number('C_RATE1'),
2266: p_action_information5 => per_formula_functions.get_number('C_RATE2'),
2267: p_action_information6 => per_formula_functions.get_number('M_RATE1'),
2268: p_action_information7 => per_formula_functions.get_number('M_RATE2'),
2269: p_action_information8 => per_formula_functions.get_number('B_RATE1'),
2270: p_action_information9 => per_formula_functions.get_number('B_RATE2'),
2271: p_action_information10 => per_formula_functions.get_text('DT_FREE_FUEL_WITHDRAWN'),
2272: p_action_information11 => per_formula_functions.get_text('FREE_FUEL_REINSTATED'),
2273: p_action_information12 => per_formula_functions.get_number('C_MILEAGE_PAYMENTS'),
2266: p_action_information5 => per_formula_functions.get_number('C_RATE2'),
2267: p_action_information6 => per_formula_functions.get_number('M_RATE1'),
2268: p_action_information7 => per_formula_functions.get_number('M_RATE2'),
2269: p_action_information8 => per_formula_functions.get_number('B_RATE1'),
2270: p_action_information9 => per_formula_functions.get_number('B_RATE2'),
2271: p_action_information10 => per_formula_functions.get_text('DT_FREE_FUEL_WITHDRAWN'),
2272: p_action_information11 => per_formula_functions.get_text('FREE_FUEL_REINSTATED'),
2273: p_action_information12 => per_formula_functions.get_number('C_MILEAGE_PAYMENTS'),
2274: p_action_information13 => per_formula_functions.get_number('B_MILEAGE_PAYMENTS'),
2267: p_action_information6 => per_formula_functions.get_number('M_RATE1'),
2268: p_action_information7 => per_formula_functions.get_number('M_RATE2'),
2269: p_action_information8 => per_formula_functions.get_number('B_RATE1'),
2270: p_action_information9 => per_formula_functions.get_number('B_RATE2'),
2271: p_action_information10 => per_formula_functions.get_text('DT_FREE_FUEL_WITHDRAWN'),
2272: p_action_information11 => per_formula_functions.get_text('FREE_FUEL_REINSTATED'),
2273: p_action_information12 => per_formula_functions.get_number('C_MILEAGE_PAYMENTS'),
2274: p_action_information13 => per_formula_functions.get_number('B_MILEAGE_PAYMENTS'),
2275: p_action_information14 => per_formula_functions.get_number('M_MILEAGE_PAYMENTS'),
2268: p_action_information7 => per_formula_functions.get_number('M_RATE2'),
2269: p_action_information8 => per_formula_functions.get_number('B_RATE1'),
2270: p_action_information9 => per_formula_functions.get_number('B_RATE2'),
2271: p_action_information10 => per_formula_functions.get_text('DT_FREE_FUEL_WITHDRAWN'),
2272: p_action_information11 => per_formula_functions.get_text('FREE_FUEL_REINSTATED'),
2273: p_action_information12 => per_formula_functions.get_number('C_MILEAGE_PAYMENTS'),
2274: p_action_information13 => per_formula_functions.get_number('B_MILEAGE_PAYMENTS'),
2275: p_action_information14 => per_formula_functions.get_number('M_MILEAGE_PAYMENTS'),
2276: p_action_information15 => per_formula_functions.get_number('MARORS_COUNT'),
2269: p_action_information8 => per_formula_functions.get_number('B_RATE1'),
2270: p_action_information9 => per_formula_functions.get_number('B_RATE2'),
2271: p_action_information10 => per_formula_functions.get_text('DT_FREE_FUEL_WITHDRAWN'),
2272: p_action_information11 => per_formula_functions.get_text('FREE_FUEL_REINSTATED'),
2273: p_action_information12 => per_formula_functions.get_number('C_MILEAGE_PAYMENTS'),
2274: p_action_information13 => per_formula_functions.get_number('B_MILEAGE_PAYMENTS'),
2275: p_action_information14 => per_formula_functions.get_number('M_MILEAGE_PAYMENTS'),
2276: p_action_information15 => per_formula_functions.get_number('MARORS_COUNT'),
2277: p_action_information16 => per_formula_functions.get_number('C_TAX_DEDUCTED'),
2270: p_action_information9 => per_formula_functions.get_number('B_RATE2'),
2271: p_action_information10 => per_formula_functions.get_text('DT_FREE_FUEL_WITHDRAWN'),
2272: p_action_information11 => per_formula_functions.get_text('FREE_FUEL_REINSTATED'),
2273: p_action_information12 => per_formula_functions.get_number('C_MILEAGE_PAYMENTS'),
2274: p_action_information13 => per_formula_functions.get_number('B_MILEAGE_PAYMENTS'),
2275: p_action_information14 => per_formula_functions.get_number('M_MILEAGE_PAYMENTS'),
2276: p_action_information15 => per_formula_functions.get_number('MARORS_COUNT'),
2277: p_action_information16 => per_formula_functions.get_number('C_TAX_DEDUCTED'),
2278: p_action_information17 => per_formula_functions.get_number('B_TAX_DEDUCTED'),
2271: p_action_information10 => per_formula_functions.get_text('DT_FREE_FUEL_WITHDRAWN'),
2272: p_action_information11 => per_formula_functions.get_text('FREE_FUEL_REINSTATED'),
2273: p_action_information12 => per_formula_functions.get_number('C_MILEAGE_PAYMENTS'),
2274: p_action_information13 => per_formula_functions.get_number('B_MILEAGE_PAYMENTS'),
2275: p_action_information14 => per_formula_functions.get_number('M_MILEAGE_PAYMENTS'),
2276: p_action_information15 => per_formula_functions.get_number('MARORS_COUNT'),
2277: p_action_information16 => per_formula_functions.get_number('C_TAX_DEDUCTED'),
2278: p_action_information17 => per_formula_functions.get_number('B_TAX_DEDUCTED'),
2279: p_action_information18 => per_formula_functions.get_number('M_TAX_DEDUCTED'),
2272: p_action_information11 => per_formula_functions.get_text('FREE_FUEL_REINSTATED'),
2273: p_action_information12 => per_formula_functions.get_number('C_MILEAGE_PAYMENTS'),
2274: p_action_information13 => per_formula_functions.get_number('B_MILEAGE_PAYMENTS'),
2275: p_action_information14 => per_formula_functions.get_number('M_MILEAGE_PAYMENTS'),
2276: p_action_information15 => per_formula_functions.get_number('MARORS_COUNT'),
2277: p_action_information16 => per_formula_functions.get_number('C_TAX_DEDUCTED'),
2278: p_action_information17 => per_formula_functions.get_number('B_TAX_DEDUCTED'),
2279: p_action_information18 => per_formula_functions.get_number('M_TAX_DEDUCTED'),
2280: p_action_information19 => per_formula_functions.get_number('PASSENGER_PAYMENTS'),
2273: p_action_information12 => per_formula_functions.get_number('C_MILEAGE_PAYMENTS'),
2274: p_action_information13 => per_formula_functions.get_number('B_MILEAGE_PAYMENTS'),
2275: p_action_information14 => per_formula_functions.get_number('M_MILEAGE_PAYMENTS'),
2276: p_action_information15 => per_formula_functions.get_number('MARORS_COUNT'),
2277: p_action_information16 => per_formula_functions.get_number('C_TAX_DEDUCTED'),
2278: p_action_information17 => per_formula_functions.get_number('B_TAX_DEDUCTED'),
2279: p_action_information18 => per_formula_functions.get_number('M_TAX_DEDUCTED'),
2280: p_action_information19 => per_formula_functions.get_number('PASSENGER_PAYMENTS'),
2281: p_action_information20 => per_formula_functions.get_number('PASSENGER_BUS_MILES'),
2274: p_action_information13 => per_formula_functions.get_number('B_MILEAGE_PAYMENTS'),
2275: p_action_information14 => per_formula_functions.get_number('M_MILEAGE_PAYMENTS'),
2276: p_action_information15 => per_formula_functions.get_number('MARORS_COUNT'),
2277: p_action_information16 => per_formula_functions.get_number('C_TAX_DEDUCTED'),
2278: p_action_information17 => per_formula_functions.get_number('B_TAX_DEDUCTED'),
2279: p_action_information18 => per_formula_functions.get_number('M_TAX_DEDUCTED'),
2280: p_action_information19 => per_formula_functions.get_number('PASSENGER_PAYMENTS'),
2281: p_action_information20 => per_formula_functions.get_number('PASSENGER_BUS_MILES'),
2282: p_action_information21 => per_formula_functions.get_number('PASSENGER_BUS_MILE_AMT'),
2275: p_action_information14 => per_formula_functions.get_number('M_MILEAGE_PAYMENTS'),
2276: p_action_information15 => per_formula_functions.get_number('MARORS_COUNT'),
2277: p_action_information16 => per_formula_functions.get_number('C_TAX_DEDUCTED'),
2278: p_action_information17 => per_formula_functions.get_number('B_TAX_DEDUCTED'),
2279: p_action_information18 => per_formula_functions.get_number('M_TAX_DEDUCTED'),
2280: p_action_information19 => per_formula_functions.get_number('PASSENGER_PAYMENTS'),
2281: p_action_information20 => per_formula_functions.get_number('PASSENGER_BUS_MILES'),
2282: p_action_information21 => per_formula_functions.get_number('PASSENGER_BUS_MILE_AMT'),
2283: p_action_information22 => per_formula_functions.get_number('MILEAGE_ALLOWANCE_RELIEF'),
2276: p_action_information15 => per_formula_functions.get_number('MARORS_COUNT'),
2277: p_action_information16 => per_formula_functions.get_number('C_TAX_DEDUCTED'),
2278: p_action_information17 => per_formula_functions.get_number('B_TAX_DEDUCTED'),
2279: p_action_information18 => per_formula_functions.get_number('M_TAX_DEDUCTED'),
2280: p_action_information19 => per_formula_functions.get_number('PASSENGER_PAYMENTS'),
2281: p_action_information20 => per_formula_functions.get_number('PASSENGER_BUS_MILES'),
2282: p_action_information21 => per_formula_functions.get_number('PASSENGER_BUS_MILE_AMT'),
2283: p_action_information22 => per_formula_functions.get_number('MILEAGE_ALLOWANCE_RELIEF'),
2284: p_action_information23 => per_formula_functions.get_number('INT_MAX_AMT_OUTSTANDING')
2277: p_action_information16 => per_formula_functions.get_number('C_TAX_DEDUCTED'),
2278: p_action_information17 => per_formula_functions.get_number('B_TAX_DEDUCTED'),
2279: p_action_information18 => per_formula_functions.get_number('M_TAX_DEDUCTED'),
2280: p_action_information19 => per_formula_functions.get_number('PASSENGER_PAYMENTS'),
2281: p_action_information20 => per_formula_functions.get_number('PASSENGER_BUS_MILES'),
2282: p_action_information21 => per_formula_functions.get_number('PASSENGER_BUS_MILE_AMT'),
2283: p_action_information22 => per_formula_functions.get_number('MILEAGE_ALLOWANCE_RELIEF'),
2284: p_action_information23 => per_formula_functions.get_number('INT_MAX_AMT_OUTSTANDING')
2285: );
2278: p_action_information17 => per_formula_functions.get_number('B_TAX_DEDUCTED'),
2279: p_action_information18 => per_formula_functions.get_number('M_TAX_DEDUCTED'),
2280: p_action_information19 => per_formula_functions.get_number('PASSENGER_PAYMENTS'),
2281: p_action_information20 => per_formula_functions.get_number('PASSENGER_BUS_MILES'),
2282: p_action_information21 => per_formula_functions.get_number('PASSENGER_BUS_MILE_AMT'),
2283: p_action_information22 => per_formula_functions.get_number('MILEAGE_ALLOWANCE_RELIEF'),
2284: p_action_information23 => per_formula_functions.get_number('INT_MAX_AMT_OUTSTANDING')
2285: );
2286: END IF;
2279: p_action_information18 => per_formula_functions.get_number('M_TAX_DEDUCTED'),
2280: p_action_information19 => per_formula_functions.get_number('PASSENGER_PAYMENTS'),
2281: p_action_information20 => per_formula_functions.get_number('PASSENGER_BUS_MILES'),
2282: p_action_information21 => per_formula_functions.get_number('PASSENGER_BUS_MILE_AMT'),
2283: p_action_information22 => per_formula_functions.get_number('MILEAGE_ALLOWANCE_RELIEF'),
2284: p_action_information23 => per_formula_functions.get_number('INT_MAX_AMT_OUTSTANDING')
2285: );
2286: END IF;
2287: else
2280: p_action_information19 => per_formula_functions.get_number('PASSENGER_PAYMENTS'),
2281: p_action_information20 => per_formula_functions.get_number('PASSENGER_BUS_MILES'),
2282: p_action_information21 => per_formula_functions.get_number('PASSENGER_BUS_MILE_AMT'),
2283: p_action_information22 => per_formula_functions.get_number('MILEAGE_ALLOWANCE_RELIEF'),
2284: p_action_information23 => per_formula_functions.get_number('INT_MAX_AMT_OUTSTANDING')
2285: );
2286: END IF;
2287: else
2288: /* Code for year 04/05 onwards */
2290: THEN
2291: pay_action_information_api.update_action_information(
2292: p_action_information_id => p_action_info_id,
2293: p_object_version_number => p_ovn,
2294: p_action_information1 => per_formula_functions.get_text('A_DESC'),
2295: p_action_information2 => per_formula_functions.get_number('A_COST'),
2296: p_action_information3 => per_formula_functions.get_number('A_AMG'),
2297: p_action_information4 => per_formula_functions.get_number('A_CE'),
2298: p_action_information5 => per_formula_functions.get_text('B_DESC'),
2291: pay_action_information_api.update_action_information(
2292: p_action_information_id => p_action_info_id,
2293: p_object_version_number => p_ovn,
2294: p_action_information1 => per_formula_functions.get_text('A_DESC'),
2295: p_action_information2 => per_formula_functions.get_number('A_COST'),
2296: p_action_information3 => per_formula_functions.get_number('A_AMG'),
2297: p_action_information4 => per_formula_functions.get_number('A_CE'),
2298: p_action_information5 => per_formula_functions.get_text('B_DESC'),
2299: p_action_information6 => per_formula_functions.get_number('B_CE'),
2292: p_action_information_id => p_action_info_id,
2293: p_object_version_number => p_ovn,
2294: p_action_information1 => per_formula_functions.get_text('A_DESC'),
2295: p_action_information2 => per_formula_functions.get_number('A_COST'),
2296: p_action_information3 => per_formula_functions.get_number('A_AMG'),
2297: p_action_information4 => per_formula_functions.get_number('A_CE'),
2298: p_action_information5 => per_formula_functions.get_text('B_DESC'),
2299: p_action_information6 => per_formula_functions.get_number('B_CE'),
2300: p_action_information7 => per_formula_functions.get_number('B_TNP'),
2293: p_object_version_number => p_ovn,
2294: p_action_information1 => per_formula_functions.get_text('A_DESC'),
2295: p_action_information2 => per_formula_functions.get_number('A_COST'),
2296: p_action_information3 => per_formula_functions.get_number('A_AMG'),
2297: p_action_information4 => per_formula_functions.get_number('A_CE'),
2298: p_action_information5 => per_formula_functions.get_text('B_DESC'),
2299: p_action_information6 => per_formula_functions.get_number('B_CE'),
2300: p_action_information7 => per_formula_functions.get_number('B_TNP'),
2301: p_action_information8 => per_formula_functions.get_number('C_COST'),
2294: p_action_information1 => per_formula_functions.get_text('A_DESC'),
2295: p_action_information2 => per_formula_functions.get_number('A_COST'),
2296: p_action_information3 => per_formula_functions.get_number('A_AMG'),
2297: p_action_information4 => per_formula_functions.get_number('A_CE'),
2298: p_action_information5 => per_formula_functions.get_text('B_DESC'),
2299: p_action_information6 => per_formula_functions.get_number('B_CE'),
2300: p_action_information7 => per_formula_functions.get_number('B_TNP'),
2301: p_action_information8 => per_formula_functions.get_number('C_COST'),
2302: p_action_information9 => per_formula_functions.get_number('C_AMG'),
2295: p_action_information2 => per_formula_functions.get_number('A_COST'),
2296: p_action_information3 => per_formula_functions.get_number('A_AMG'),
2297: p_action_information4 => per_formula_functions.get_number('A_CE'),
2298: p_action_information5 => per_formula_functions.get_text('B_DESC'),
2299: p_action_information6 => per_formula_functions.get_number('B_CE'),
2300: p_action_information7 => per_formula_functions.get_number('B_TNP'),
2301: p_action_information8 => per_formula_functions.get_number('C_COST'),
2302: p_action_information9 => per_formula_functions.get_number('C_AMG'),
2303: p_action_information10 => per_formula_functions.get_number('C_CE'),
2296: p_action_information3 => per_formula_functions.get_number('A_AMG'),
2297: p_action_information4 => per_formula_functions.get_number('A_CE'),
2298: p_action_information5 => per_formula_functions.get_text('B_DESC'),
2299: p_action_information6 => per_formula_functions.get_number('B_CE'),
2300: p_action_information7 => per_formula_functions.get_number('B_TNP'),
2301: p_action_information8 => per_formula_functions.get_number('C_COST'),
2302: p_action_information9 => per_formula_functions.get_number('C_AMG'),
2303: p_action_information10 => per_formula_functions.get_number('C_CE'),
2304: p_action_information11 => per_formula_functions.get_number('D_CE'),
2297: p_action_information4 => per_formula_functions.get_number('A_CE'),
2298: p_action_information5 => per_formula_functions.get_text('B_DESC'),
2299: p_action_information6 => per_formula_functions.get_number('B_CE'),
2300: p_action_information7 => per_formula_functions.get_number('B_TNP'),
2301: p_action_information8 => per_formula_functions.get_number('C_COST'),
2302: p_action_information9 => per_formula_functions.get_number('C_AMG'),
2303: p_action_information10 => per_formula_functions.get_number('C_CE'),
2304: p_action_information11 => per_formula_functions.get_number('D_CE'),
2305: p_action_information12 => calculate_amap_ce ,
2298: p_action_information5 => per_formula_functions.get_text('B_DESC'),
2299: p_action_information6 => per_formula_functions.get_number('B_CE'),
2300: p_action_information7 => per_formula_functions.get_number('B_TNP'),
2301: p_action_information8 => per_formula_functions.get_number('C_COST'),
2302: p_action_information9 => per_formula_functions.get_number('C_AMG'),
2303: p_action_information10 => per_formula_functions.get_number('C_CE'),
2304: p_action_information11 => per_formula_functions.get_number('D_CE'),
2305: p_action_information12 => calculate_amap_ce ,
2306: p_action_information13 => per_formula_functions.get_number('F_TCCE'),
2299: p_action_information6 => per_formula_functions.get_number('B_CE'),
2300: p_action_information7 => per_formula_functions.get_number('B_TNP'),
2301: p_action_information8 => per_formula_functions.get_number('C_COST'),
2302: p_action_information9 => per_formula_functions.get_number('C_AMG'),
2303: p_action_information10 => per_formula_functions.get_number('C_CE'),
2304: p_action_information11 => per_formula_functions.get_number('D_CE'),
2305: p_action_information12 => calculate_amap_ce ,
2306: p_action_information13 => per_formula_functions.get_number('F_TCCE'),
2307: p_action_information14 => per_formula_functions.get_number('F_TFCE'),
2300: p_action_information7 => per_formula_functions.get_number('B_TNP'),
2301: p_action_information8 => per_formula_functions.get_number('C_COST'),
2302: p_action_information9 => per_formula_functions.get_number('C_AMG'),
2303: p_action_information10 => per_formula_functions.get_number('C_CE'),
2304: p_action_information11 => per_formula_functions.get_number('D_CE'),
2305: p_action_information12 => calculate_amap_ce ,
2306: p_action_information13 => per_formula_functions.get_number('F_TCCE'),
2307: p_action_information14 => per_formula_functions.get_number('F_TFCE'),
2308: p_action_information15 => per_formula_functions.get_number('G_CE'),
2302: p_action_information9 => per_formula_functions.get_number('C_AMG'),
2303: p_action_information10 => per_formula_functions.get_number('C_CE'),
2304: p_action_information11 => per_formula_functions.get_number('D_CE'),
2305: p_action_information12 => calculate_amap_ce ,
2306: p_action_information13 => per_formula_functions.get_number('F_TCCE'),
2307: p_action_information14 => per_formula_functions.get_number('F_TFCE'),
2308: p_action_information15 => per_formula_functions.get_number('G_CE'),
2309: p_action_information16 => per_formula_functions.get_number('I_COST'),
2310: p_action_information17 => per_formula_functions.get_number('I_AMG'),
2303: p_action_information10 => per_formula_functions.get_number('C_CE'),
2304: p_action_information11 => per_formula_functions.get_number('D_CE'),
2305: p_action_information12 => calculate_amap_ce ,
2306: p_action_information13 => per_formula_functions.get_number('F_TCCE'),
2307: p_action_information14 => per_formula_functions.get_number('F_TFCE'),
2308: p_action_information15 => per_formula_functions.get_number('G_CE'),
2309: p_action_information16 => per_formula_functions.get_number('I_COST'),
2310: p_action_information17 => per_formula_functions.get_number('I_AMG'),
2311: p_action_information18 => per_formula_functions.get_number('I_CE'),
2304: p_action_information11 => per_formula_functions.get_number('D_CE'),
2305: p_action_information12 => calculate_amap_ce ,
2306: p_action_information13 => per_formula_functions.get_number('F_TCCE'),
2307: p_action_information14 => per_formula_functions.get_number('F_TFCE'),
2308: p_action_information15 => per_formula_functions.get_number('G_CE'),
2309: p_action_information16 => per_formula_functions.get_number('I_COST'),
2310: p_action_information17 => per_formula_functions.get_number('I_AMG'),
2311: p_action_information18 => per_formula_functions.get_number('I_CE'),
2312: p_action_information19 => per_formula_functions.get_number('J_CE'),
2305: p_action_information12 => calculate_amap_ce ,
2306: p_action_information13 => per_formula_functions.get_number('F_TCCE'),
2307: p_action_information14 => per_formula_functions.get_number('F_TFCE'),
2308: p_action_information15 => per_formula_functions.get_number('G_CE'),
2309: p_action_information16 => per_formula_functions.get_number('I_COST'),
2310: p_action_information17 => per_formula_functions.get_number('I_AMG'),
2311: p_action_information18 => per_formula_functions.get_number('I_CE'),
2312: p_action_information19 => per_formula_functions.get_number('J_CE'),
2313: p_action_information20 => per_formula_functions.get_number('K_COST'),
2306: p_action_information13 => per_formula_functions.get_number('F_TCCE'),
2307: p_action_information14 => per_formula_functions.get_number('F_TFCE'),
2308: p_action_information15 => per_formula_functions.get_number('G_CE'),
2309: p_action_information16 => per_formula_functions.get_number('I_COST'),
2310: p_action_information17 => per_formula_functions.get_number('I_AMG'),
2311: p_action_information18 => per_formula_functions.get_number('I_CE'),
2312: p_action_information19 => per_formula_functions.get_number('J_CE'),
2313: p_action_information20 => per_formula_functions.get_number('K_COST'),
2314: p_action_information21 => per_formula_functions.get_number('K_AMG'),
2307: p_action_information14 => per_formula_functions.get_number('F_TFCE'),
2308: p_action_information15 => per_formula_functions.get_number('G_CE'),
2309: p_action_information16 => per_formula_functions.get_number('I_COST'),
2310: p_action_information17 => per_formula_functions.get_number('I_AMG'),
2311: p_action_information18 => per_formula_functions.get_number('I_CE'),
2312: p_action_information19 => per_formula_functions.get_number('J_CE'),
2313: p_action_information20 => per_formula_functions.get_number('K_COST'),
2314: p_action_information21 => per_formula_functions.get_number('K_AMG'),
2315: p_action_information22 => per_formula_functions.get_number('K_CE'),
2308: p_action_information15 => per_formula_functions.get_number('G_CE'),
2309: p_action_information16 => per_formula_functions.get_number('I_COST'),
2310: p_action_information17 => per_formula_functions.get_number('I_AMG'),
2311: p_action_information18 => per_formula_functions.get_number('I_CE'),
2312: p_action_information19 => per_formula_functions.get_number('J_CE'),
2313: p_action_information20 => per_formula_functions.get_number('K_COST'),
2314: p_action_information21 => per_formula_functions.get_number('K_AMG'),
2315: p_action_information22 => per_formula_functions.get_number('K_CE'),
2316: p_action_information23 => per_formula_functions.get_text('L_DESC'),
2309: p_action_information16 => per_formula_functions.get_number('I_COST'),
2310: p_action_information17 => per_formula_functions.get_number('I_AMG'),
2311: p_action_information18 => per_formula_functions.get_number('I_CE'),
2312: p_action_information19 => per_formula_functions.get_number('J_CE'),
2313: p_action_information20 => per_formula_functions.get_number('K_COST'),
2314: p_action_information21 => per_formula_functions.get_number('K_AMG'),
2315: p_action_information22 => per_formula_functions.get_number('K_CE'),
2316: p_action_information23 => per_formula_functions.get_text('L_DESC'),
2317: p_action_information24 => per_formula_functions.get_number('L_COST'),
2310: p_action_information17 => per_formula_functions.get_number('I_AMG'),
2311: p_action_information18 => per_formula_functions.get_number('I_CE'),
2312: p_action_information19 => per_formula_functions.get_number('J_CE'),
2313: p_action_information20 => per_formula_functions.get_number('K_COST'),
2314: p_action_information21 => per_formula_functions.get_number('K_AMG'),
2315: p_action_information22 => per_formula_functions.get_number('K_CE'),
2316: p_action_information23 => per_formula_functions.get_text('L_DESC'),
2317: p_action_information24 => per_formula_functions.get_number('L_COST'),
2318: p_action_information25 => per_formula_functions.get_number('L_AMG'),
2311: p_action_information18 => per_formula_functions.get_number('I_CE'),
2312: p_action_information19 => per_formula_functions.get_number('J_CE'),
2313: p_action_information20 => per_formula_functions.get_number('K_COST'),
2314: p_action_information21 => per_formula_functions.get_number('K_AMG'),
2315: p_action_information22 => per_formula_functions.get_number('K_CE'),
2316: p_action_information23 => per_formula_functions.get_text('L_DESC'),
2317: p_action_information24 => per_formula_functions.get_number('L_COST'),
2318: p_action_information25 => per_formula_functions.get_number('L_AMG'),
2319: p_action_information26 => per_formula_functions.get_number('L_CE'),
2312: p_action_information19 => per_formula_functions.get_number('J_CE'),
2313: p_action_information20 => per_formula_functions.get_number('K_COST'),
2314: p_action_information21 => per_formula_functions.get_number('K_AMG'),
2315: p_action_information22 => per_formula_functions.get_number('K_CE'),
2316: p_action_information23 => per_formula_functions.get_text('L_DESC'),
2317: p_action_information24 => per_formula_functions.get_number('L_COST'),
2318: p_action_information25 => per_formula_functions.get_number('L_AMG'),
2319: p_action_information26 => per_formula_functions.get_number('L_CE'),
2320: p_action_information27 => null,
2313: p_action_information20 => per_formula_functions.get_number('K_COST'),
2314: p_action_information21 => per_formula_functions.get_number('K_AMG'),
2315: p_action_information22 => per_formula_functions.get_number('K_CE'),
2316: p_action_information23 => per_formula_functions.get_text('L_DESC'),
2317: p_action_information24 => per_formula_functions.get_number('L_COST'),
2318: p_action_information25 => per_formula_functions.get_number('L_AMG'),
2319: p_action_information26 => per_formula_functions.get_number('L_CE'),
2320: p_action_information27 => null,
2321: p_action_information28 => per_formula_functions.get_number('H_CE1'),
2314: p_action_information21 => per_formula_functions.get_number('K_AMG'),
2315: p_action_information22 => per_formula_functions.get_number('K_CE'),
2316: p_action_information23 => per_formula_functions.get_text('L_DESC'),
2317: p_action_information24 => per_formula_functions.get_number('L_COST'),
2318: p_action_information25 => per_formula_functions.get_number('L_AMG'),
2319: p_action_information26 => per_formula_functions.get_number('L_CE'),
2320: p_action_information27 => null,
2321: p_action_information28 => per_formula_functions.get_number('H_CE1'),
2322: p_action_information29 => per_formula_functions.get_number('H_COUNT'),
2315: p_action_information22 => per_formula_functions.get_number('K_CE'),
2316: p_action_information23 => per_formula_functions.get_text('L_DESC'),
2317: p_action_information24 => per_formula_functions.get_number('L_COST'),
2318: p_action_information25 => per_formula_functions.get_number('L_AMG'),
2319: p_action_information26 => per_formula_functions.get_number('L_CE'),
2320: p_action_information27 => null,
2321: p_action_information28 => per_formula_functions.get_number('H_CE1'),
2322: p_action_information29 => per_formula_functions.get_number('H_COUNT'),
2323: p_action_information30 => per_formula_functions.get_number('F_COUNT') );
2317: p_action_information24 => per_formula_functions.get_number('L_COST'),
2318: p_action_information25 => per_formula_functions.get_number('L_AMG'),
2319: p_action_information26 => per_formula_functions.get_number('L_CE'),
2320: p_action_information27 => null,
2321: p_action_information28 => per_formula_functions.get_number('H_CE1'),
2322: p_action_information29 => per_formula_functions.get_number('H_COUNT'),
2323: p_action_information30 => per_formula_functions.get_number('F_COUNT') );
2324: END IF;
2325:
2318: p_action_information25 => per_formula_functions.get_number('L_AMG'),
2319: p_action_information26 => per_formula_functions.get_number('L_CE'),
2320: p_action_information27 => null,
2321: p_action_information28 => per_formula_functions.get_number('H_CE1'),
2322: p_action_information29 => per_formula_functions.get_number('H_COUNT'),
2323: p_action_information30 => per_formula_functions.get_number('F_COUNT') );
2324: END IF;
2325:
2326: IF p_action_info_category = 'GB P11D ASSIGNMENT RESULTB'
2319: p_action_information26 => per_formula_functions.get_number('L_CE'),
2320: p_action_information27 => null,
2321: p_action_information28 => per_formula_functions.get_number('H_CE1'),
2322: p_action_information29 => per_formula_functions.get_number('H_COUNT'),
2323: p_action_information30 => per_formula_functions.get_number('F_COUNT') );
2324: END IF;
2325:
2326: IF p_action_info_category = 'GB P11D ASSIGNMENT RESULTB'
2327: THEN
2327: THEN
2328: pay_action_information_api.update_action_information(
2329: p_action_information_id => p_action_info_id,
2330: p_object_version_number => p_ovn,
2331: p_action_information1 => per_formula_functions.get_text('M_DESC'),
2332: p_action_information2 => per_formula_functions.get_number('M_COST'),
2333: p_action_information3 => per_formula_functions.get_number('M_AMG'),
2334: p_action_information4 => per_formula_functions.get_number('M_CE'),
2335: p_action_information5 => per_formula_functions.get_text('MA_DESC'),
2328: pay_action_information_api.update_action_information(
2329: p_action_information_id => p_action_info_id,
2330: p_object_version_number => p_ovn,
2331: p_action_information1 => per_formula_functions.get_text('M_DESC'),
2332: p_action_information2 => per_formula_functions.get_number('M_COST'),
2333: p_action_information3 => per_formula_functions.get_number('M_AMG'),
2334: p_action_information4 => per_formula_functions.get_number('M_CE'),
2335: p_action_information5 => per_formula_functions.get_text('MA_DESC'),
2336: p_action_information6 => per_formula_functions.get_number('MA_COST'),
2329: p_action_information_id => p_action_info_id,
2330: p_object_version_number => p_ovn,
2331: p_action_information1 => per_formula_functions.get_text('M_DESC'),
2332: p_action_information2 => per_formula_functions.get_number('M_COST'),
2333: p_action_information3 => per_formula_functions.get_number('M_AMG'),
2334: p_action_information4 => per_formula_functions.get_number('M_CE'),
2335: p_action_information5 => per_formula_functions.get_text('MA_DESC'),
2336: p_action_information6 => per_formula_functions.get_number('MA_COST'),
2337: p_action_information7 => per_formula_functions.get_number('MA_AMG'),
2330: p_object_version_number => p_ovn,
2331: p_action_information1 => per_formula_functions.get_text('M_DESC'),
2332: p_action_information2 => per_formula_functions.get_number('M_COST'),
2333: p_action_information3 => per_formula_functions.get_number('M_AMG'),
2334: p_action_information4 => per_formula_functions.get_number('M_CE'),
2335: p_action_information5 => per_formula_functions.get_text('MA_DESC'),
2336: p_action_information6 => per_formula_functions.get_number('MA_COST'),
2337: p_action_information7 => per_formula_functions.get_number('MA_AMG'),
2338: p_action_information8 => per_formula_functions.get_number('MA_CE'),
2331: p_action_information1 => per_formula_functions.get_text('M_DESC'),
2332: p_action_information2 => per_formula_functions.get_number('M_COST'),
2333: p_action_information3 => per_formula_functions.get_number('M_AMG'),
2334: p_action_information4 => per_formula_functions.get_number('M_CE'),
2335: p_action_information5 => per_formula_functions.get_text('MA_DESC'),
2336: p_action_information6 => per_formula_functions.get_number('MA_COST'),
2337: p_action_information7 => per_formula_functions.get_number('MA_AMG'),
2338: p_action_information8 => per_formula_functions.get_number('MA_CE'),
2339: p_action_information9 => per_formula_functions.get_number('M_TAXPAID'),
2332: p_action_information2 => per_formula_functions.get_number('M_COST'),
2333: p_action_information3 => per_formula_functions.get_number('M_AMG'),
2334: p_action_information4 => per_formula_functions.get_number('M_CE'),
2335: p_action_information5 => per_formula_functions.get_text('MA_DESC'),
2336: p_action_information6 => per_formula_functions.get_number('MA_COST'),
2337: p_action_information7 => per_formula_functions.get_number('MA_AMG'),
2338: p_action_information8 => per_formula_functions.get_number('MA_CE'),
2339: p_action_information9 => per_formula_functions.get_number('M_TAXPAID'),
2340: p_action_information10 => per_formula_functions.get_number('N1_COST'),
2333: p_action_information3 => per_formula_functions.get_number('M_AMG'),
2334: p_action_information4 => per_formula_functions.get_number('M_CE'),
2335: p_action_information5 => per_formula_functions.get_text('MA_DESC'),
2336: p_action_information6 => per_formula_functions.get_number('MA_COST'),
2337: p_action_information7 => per_formula_functions.get_number('MA_AMG'),
2338: p_action_information8 => per_formula_functions.get_number('MA_CE'),
2339: p_action_information9 => per_formula_functions.get_number('M_TAXPAID'),
2340: p_action_information10 => per_formula_functions.get_number('N1_COST'),
2341: p_action_information11 => per_formula_functions.get_number('N1_AMG'),
2334: p_action_information4 => per_formula_functions.get_number('M_CE'),
2335: p_action_information5 => per_formula_functions.get_text('MA_DESC'),
2336: p_action_information6 => per_formula_functions.get_number('MA_COST'),
2337: p_action_information7 => per_formula_functions.get_number('MA_AMG'),
2338: p_action_information8 => per_formula_functions.get_number('MA_CE'),
2339: p_action_information9 => per_formula_functions.get_number('M_TAXPAID'),
2340: p_action_information10 => per_formula_functions.get_number('N1_COST'),
2341: p_action_information11 => per_formula_functions.get_number('N1_AMG'),
2342: p_action_information12 => per_formula_functions.get_number('N1_CE'),
2335: p_action_information5 => per_formula_functions.get_text('MA_DESC'),
2336: p_action_information6 => per_formula_functions.get_number('MA_COST'),
2337: p_action_information7 => per_formula_functions.get_number('MA_AMG'),
2338: p_action_information8 => per_formula_functions.get_number('MA_CE'),
2339: p_action_information9 => per_formula_functions.get_number('M_TAXPAID'),
2340: p_action_information10 => per_formula_functions.get_number('N1_COST'),
2341: p_action_information11 => per_formula_functions.get_number('N1_AMG'),
2342: p_action_information12 => per_formula_functions.get_number('N1_CE'),
2343: p_action_information13 => per_formula_functions.get_number('N2_COST'),
2336: p_action_information6 => per_formula_functions.get_number('MA_COST'),
2337: p_action_information7 => per_formula_functions.get_number('MA_AMG'),
2338: p_action_information8 => per_formula_functions.get_number('MA_CE'),
2339: p_action_information9 => per_formula_functions.get_number('M_TAXPAID'),
2340: p_action_information10 => per_formula_functions.get_number('N1_COST'),
2341: p_action_information11 => per_formula_functions.get_number('N1_AMG'),
2342: p_action_information12 => per_formula_functions.get_number('N1_CE'),
2343: p_action_information13 => per_formula_functions.get_number('N2_COST'),
2344: p_action_information14 => per_formula_functions.get_number('N2_AMG'),
2337: p_action_information7 => per_formula_functions.get_number('MA_AMG'),
2338: p_action_information8 => per_formula_functions.get_number('MA_CE'),
2339: p_action_information9 => per_formula_functions.get_number('M_TAXPAID'),
2340: p_action_information10 => per_formula_functions.get_number('N1_COST'),
2341: p_action_information11 => per_formula_functions.get_number('N1_AMG'),
2342: p_action_information12 => per_formula_functions.get_number('N1_CE'),
2343: p_action_information13 => per_formula_functions.get_number('N2_COST'),
2344: p_action_information14 => per_formula_functions.get_number('N2_AMG'),
2345: p_action_information15 => per_formula_functions.get_number('N2_CE'),
2338: p_action_information8 => per_formula_functions.get_number('MA_CE'),
2339: p_action_information9 => per_formula_functions.get_number('M_TAXPAID'),
2340: p_action_information10 => per_formula_functions.get_number('N1_COST'),
2341: p_action_information11 => per_formula_functions.get_number('N1_AMG'),
2342: p_action_information12 => per_formula_functions.get_number('N1_CE'),
2343: p_action_information13 => per_formula_functions.get_number('N2_COST'),
2344: p_action_information14 => per_formula_functions.get_number('N2_AMG'),
2345: p_action_information15 => per_formula_functions.get_number('N2_CE'),
2346: p_action_information16 => per_formula_functions.get_text('N_TOI'),
2339: p_action_information9 => per_formula_functions.get_number('M_TAXPAID'),
2340: p_action_information10 => per_formula_functions.get_number('N1_COST'),
2341: p_action_information11 => per_formula_functions.get_number('N1_AMG'),
2342: p_action_information12 => per_formula_functions.get_number('N1_CE'),
2343: p_action_information13 => per_formula_functions.get_number('N2_COST'),
2344: p_action_information14 => per_formula_functions.get_number('N2_AMG'),
2345: p_action_information15 => per_formula_functions.get_number('N2_CE'),
2346: p_action_information16 => per_formula_functions.get_text('N_TOI'),
2347: p_action_information17 => per_formula_functions.get_number('N3_COST'),
2340: p_action_information10 => per_formula_functions.get_number('N1_COST'),
2341: p_action_information11 => per_formula_functions.get_number('N1_AMG'),
2342: p_action_information12 => per_formula_functions.get_number('N1_CE'),
2343: p_action_information13 => per_formula_functions.get_number('N2_COST'),
2344: p_action_information14 => per_formula_functions.get_number('N2_AMG'),
2345: p_action_information15 => per_formula_functions.get_number('N2_CE'),
2346: p_action_information16 => per_formula_functions.get_text('N_TOI'),
2347: p_action_information17 => per_formula_functions.get_number('N3_COST'),
2348: p_action_information18 => per_formula_functions.get_number('N3_AMG'),
2341: p_action_information11 => per_formula_functions.get_number('N1_AMG'),
2342: p_action_information12 => per_formula_functions.get_number('N1_CE'),
2343: p_action_information13 => per_formula_functions.get_number('N2_COST'),
2344: p_action_information14 => per_formula_functions.get_number('N2_AMG'),
2345: p_action_information15 => per_formula_functions.get_number('N2_CE'),
2346: p_action_information16 => per_formula_functions.get_text('N_TOI'),
2347: p_action_information17 => per_formula_functions.get_number('N3_COST'),
2348: p_action_information18 => per_formula_functions.get_number('N3_AMG'),
2349: p_action_information19 => per_formula_functions.get_number('N3_CE'),
2342: p_action_information12 => per_formula_functions.get_number('N1_CE'),
2343: p_action_information13 => per_formula_functions.get_number('N2_COST'),
2344: p_action_information14 => per_formula_functions.get_number('N2_AMG'),
2345: p_action_information15 => per_formula_functions.get_number('N2_CE'),
2346: p_action_information16 => per_formula_functions.get_text('N_TOI'),
2347: p_action_information17 => per_formula_functions.get_number('N3_COST'),
2348: p_action_information18 => per_formula_functions.get_number('N3_AMG'),
2349: p_action_information19 => per_formula_functions.get_number('N3_CE'),
2350: p_action_information20 => per_formula_functions.get_number('N4_COST'),
2343: p_action_information13 => per_formula_functions.get_number('N2_COST'),
2344: p_action_information14 => per_formula_functions.get_number('N2_AMG'),
2345: p_action_information15 => per_formula_functions.get_number('N2_CE'),
2346: p_action_information16 => per_formula_functions.get_text('N_TOI'),
2347: p_action_information17 => per_formula_functions.get_number('N3_COST'),
2348: p_action_information18 => per_formula_functions.get_number('N3_AMG'),
2349: p_action_information19 => per_formula_functions.get_number('N3_CE'),
2350: p_action_information20 => per_formula_functions.get_number('N4_COST'),
2351: p_action_information21 => per_formula_functions.get_number('N4_AMG'),
2344: p_action_information14 => per_formula_functions.get_number('N2_AMG'),
2345: p_action_information15 => per_formula_functions.get_number('N2_CE'),
2346: p_action_information16 => per_formula_functions.get_text('N_TOI'),
2347: p_action_information17 => per_formula_functions.get_number('N3_COST'),
2348: p_action_information18 => per_formula_functions.get_number('N3_AMG'),
2349: p_action_information19 => per_formula_functions.get_number('N3_CE'),
2350: p_action_information20 => per_formula_functions.get_number('N4_COST'),
2351: p_action_information21 => per_formula_functions.get_number('N4_AMG'),
2352: p_action_information22 => per_formula_functions.get_number('N4_CE'),
2345: p_action_information15 => per_formula_functions.get_number('N2_CE'),
2346: p_action_information16 => per_formula_functions.get_text('N_TOI'),
2347: p_action_information17 => per_formula_functions.get_number('N3_COST'),
2348: p_action_information18 => per_formula_functions.get_number('N3_AMG'),
2349: p_action_information19 => per_formula_functions.get_number('N3_CE'),
2350: p_action_information20 => per_formula_functions.get_number('N4_COST'),
2351: p_action_information21 => per_formula_functions.get_number('N4_AMG'),
2352: p_action_information22 => per_formula_functions.get_number('N4_CE'),
2353: p_action_information23 => per_formula_functions.get_number('N5_COST'),
2346: p_action_information16 => per_formula_functions.get_text('N_TOI'),
2347: p_action_information17 => per_formula_functions.get_number('N3_COST'),
2348: p_action_information18 => per_formula_functions.get_number('N3_AMG'),
2349: p_action_information19 => per_formula_functions.get_number('N3_CE'),
2350: p_action_information20 => per_formula_functions.get_number('N4_COST'),
2351: p_action_information21 => per_formula_functions.get_number('N4_AMG'),
2352: p_action_information22 => per_formula_functions.get_number('N4_CE'),
2353: p_action_information23 => per_formula_functions.get_number('N5_COST'),
2354: p_action_information24 => per_formula_functions.get_number('N5_AMG'),
2347: p_action_information17 => per_formula_functions.get_number('N3_COST'),
2348: p_action_information18 => per_formula_functions.get_number('N3_AMG'),
2349: p_action_information19 => per_formula_functions.get_number('N3_CE'),
2350: p_action_information20 => per_formula_functions.get_number('N4_COST'),
2351: p_action_information21 => per_formula_functions.get_number('N4_AMG'),
2352: p_action_information22 => per_formula_functions.get_number('N4_CE'),
2353: p_action_information23 => per_formula_functions.get_number('N5_COST'),
2354: p_action_information24 => per_formula_functions.get_number('N5_AMG'),
2355: p_action_information25 => per_formula_functions.get_number('N5_CE'),
2348: p_action_information18 => per_formula_functions.get_number('N3_AMG'),
2349: p_action_information19 => per_formula_functions.get_number('N3_CE'),
2350: p_action_information20 => per_formula_functions.get_number('N4_COST'),
2351: p_action_information21 => per_formula_functions.get_number('N4_AMG'),
2352: p_action_information22 => per_formula_functions.get_number('N4_CE'),
2353: p_action_information23 => per_formula_functions.get_number('N5_COST'),
2354: p_action_information24 => per_formula_functions.get_number('N5_AMG'),
2355: p_action_information25 => per_formula_functions.get_number('N5_CE'),
2356: p_action_information26 => per_formula_functions.get_text('N6_DESC'),
2349: p_action_information19 => per_formula_functions.get_number('N3_CE'),
2350: p_action_information20 => per_formula_functions.get_number('N4_COST'),
2351: p_action_information21 => per_formula_functions.get_number('N4_AMG'),
2352: p_action_information22 => per_formula_functions.get_number('N4_CE'),
2353: p_action_information23 => per_formula_functions.get_number('N5_COST'),
2354: p_action_information24 => per_formula_functions.get_number('N5_AMG'),
2355: p_action_information25 => per_formula_functions.get_number('N5_CE'),
2356: p_action_information26 => per_formula_functions.get_text('N6_DESC'),
2357: p_action_information27 => per_formula_functions.get_number('N6_COST'),
2350: p_action_information20 => per_formula_functions.get_number('N4_COST'),
2351: p_action_information21 => per_formula_functions.get_number('N4_AMG'),
2352: p_action_information22 => per_formula_functions.get_number('N4_CE'),
2353: p_action_information23 => per_formula_functions.get_number('N5_COST'),
2354: p_action_information24 => per_formula_functions.get_number('N5_AMG'),
2355: p_action_information25 => per_formula_functions.get_number('N5_CE'),
2356: p_action_information26 => per_formula_functions.get_text('N6_DESC'),
2357: p_action_information27 => per_formula_functions.get_number('N6_COST'),
2358: p_action_information28 => per_formula_functions.get_number('N6_AMG'),
2351: p_action_information21 => per_formula_functions.get_number('N4_AMG'),
2352: p_action_information22 => per_formula_functions.get_number('N4_CE'),
2353: p_action_information23 => per_formula_functions.get_number('N5_COST'),
2354: p_action_information24 => per_formula_functions.get_number('N5_AMG'),
2355: p_action_information25 => per_formula_functions.get_number('N5_CE'),
2356: p_action_information26 => per_formula_functions.get_text('N6_DESC'),
2357: p_action_information27 => per_formula_functions.get_number('N6_COST'),
2358: p_action_information28 => per_formula_functions.get_number('N6_AMG'),
2359: p_action_information29 => per_formula_functions.get_number('N6_CE')
2352: p_action_information22 => per_formula_functions.get_number('N4_CE'),
2353: p_action_information23 => per_formula_functions.get_number('N5_COST'),
2354: p_action_information24 => per_formula_functions.get_number('N5_AMG'),
2355: p_action_information25 => per_formula_functions.get_number('N5_CE'),
2356: p_action_information26 => per_formula_functions.get_text('N6_DESC'),
2357: p_action_information27 => per_formula_functions.get_number('N6_COST'),
2358: p_action_information28 => per_formula_functions.get_number('N6_AMG'),
2359: p_action_information29 => per_formula_functions.get_number('N6_CE')
2360: ,p_action_information30 => per_formula_functions.get_number('G_FCE'));
2353: p_action_information23 => per_formula_functions.get_number('N5_COST'),
2354: p_action_information24 => per_formula_functions.get_number('N5_AMG'),
2355: p_action_information25 => per_formula_functions.get_number('N5_CE'),
2356: p_action_information26 => per_formula_functions.get_text('N6_DESC'),
2357: p_action_information27 => per_formula_functions.get_number('N6_COST'),
2358: p_action_information28 => per_formula_functions.get_number('N6_AMG'),
2359: p_action_information29 => per_formula_functions.get_number('N6_CE')
2360: ,p_action_information30 => per_formula_functions.get_number('G_FCE'));
2361:
2354: p_action_information24 => per_formula_functions.get_number('N5_AMG'),
2355: p_action_information25 => per_formula_functions.get_number('N5_CE'),
2356: p_action_information26 => per_formula_functions.get_text('N6_DESC'),
2357: p_action_information27 => per_formula_functions.get_number('N6_COST'),
2358: p_action_information28 => per_formula_functions.get_number('N6_AMG'),
2359: p_action_information29 => per_formula_functions.get_number('N6_CE')
2360: ,p_action_information30 => per_formula_functions.get_number('G_FCE'));
2361:
2362: END IF;
2355: p_action_information25 => per_formula_functions.get_number('N5_CE'),
2356: p_action_information26 => per_formula_functions.get_text('N6_DESC'),
2357: p_action_information27 => per_formula_functions.get_number('N6_COST'),
2358: p_action_information28 => per_formula_functions.get_number('N6_AMG'),
2359: p_action_information29 => per_formula_functions.get_number('N6_CE')
2360: ,p_action_information30 => per_formula_functions.get_number('G_FCE'));
2361:
2362: END IF;
2363:
2356: p_action_information26 => per_formula_functions.get_text('N6_DESC'),
2357: p_action_information27 => per_formula_functions.get_number('N6_COST'),
2358: p_action_information28 => per_formula_functions.get_number('N6_AMG'),
2359: p_action_information29 => per_formula_functions.get_number('N6_CE')
2360: ,p_action_information30 => per_formula_functions.get_number('G_FCE'));
2361:
2362: END IF;
2363:
2364: IF p_action_info_category = 'GB P11D ASSIGNMENT RESULTC'
2365: THEN
2366: pay_action_information_api.update_action_information(
2367: p_action_information_id => p_action_info_id,
2368: p_object_version_number => p_ovn,
2369: p_action_information1 => per_formula_functions.get_number('C_BUS_MILES'),
2370: p_action_information2 => per_formula_functions.get_number('M_BUS_MILES'),
2371: p_action_information3 => per_formula_functions.get_number('B_BUS_MILES'),
2372: p_action_information4 => per_formula_functions.get_number('C_RATE1'),
2373: p_action_information5 => per_formula_functions.get_number('C_RATE2'),
2366: pay_action_information_api.update_action_information(
2367: p_action_information_id => p_action_info_id,
2368: p_object_version_number => p_ovn,
2369: p_action_information1 => per_formula_functions.get_number('C_BUS_MILES'),
2370: p_action_information2 => per_formula_functions.get_number('M_BUS_MILES'),
2371: p_action_information3 => per_formula_functions.get_number('B_BUS_MILES'),
2372: p_action_information4 => per_formula_functions.get_number('C_RATE1'),
2373: p_action_information5 => per_formula_functions.get_number('C_RATE2'),
2374: p_action_information6 => per_formula_functions.get_number('M_RATE1'),
2367: p_action_information_id => p_action_info_id,
2368: p_object_version_number => p_ovn,
2369: p_action_information1 => per_formula_functions.get_number('C_BUS_MILES'),
2370: p_action_information2 => per_formula_functions.get_number('M_BUS_MILES'),
2371: p_action_information3 => per_formula_functions.get_number('B_BUS_MILES'),
2372: p_action_information4 => per_formula_functions.get_number('C_RATE1'),
2373: p_action_information5 => per_formula_functions.get_number('C_RATE2'),
2374: p_action_information6 => per_formula_functions.get_number('M_RATE1'),
2375: p_action_information7 => per_formula_functions.get_number('M_RATE2'),
2368: p_object_version_number => p_ovn,
2369: p_action_information1 => per_formula_functions.get_number('C_BUS_MILES'),
2370: p_action_information2 => per_formula_functions.get_number('M_BUS_MILES'),
2371: p_action_information3 => per_formula_functions.get_number('B_BUS_MILES'),
2372: p_action_information4 => per_formula_functions.get_number('C_RATE1'),
2373: p_action_information5 => per_formula_functions.get_number('C_RATE2'),
2374: p_action_information6 => per_formula_functions.get_number('M_RATE1'),
2375: p_action_information7 => per_formula_functions.get_number('M_RATE2'),
2376: p_action_information8 => per_formula_functions.get_number('B_RATE1'),
2369: p_action_information1 => per_formula_functions.get_number('C_BUS_MILES'),
2370: p_action_information2 => per_formula_functions.get_number('M_BUS_MILES'),
2371: p_action_information3 => per_formula_functions.get_number('B_BUS_MILES'),
2372: p_action_information4 => per_formula_functions.get_number('C_RATE1'),
2373: p_action_information5 => per_formula_functions.get_number('C_RATE2'),
2374: p_action_information6 => per_formula_functions.get_number('M_RATE1'),
2375: p_action_information7 => per_formula_functions.get_number('M_RATE2'),
2376: p_action_information8 => per_formula_functions.get_number('B_RATE1'),
2377: p_action_information9 => per_formula_functions.get_number('B_RATE2'),
2370: p_action_information2 => per_formula_functions.get_number('M_BUS_MILES'),
2371: p_action_information3 => per_formula_functions.get_number('B_BUS_MILES'),
2372: p_action_information4 => per_formula_functions.get_number('C_RATE1'),
2373: p_action_information5 => per_formula_functions.get_number('C_RATE2'),
2374: p_action_information6 => per_formula_functions.get_number('M_RATE1'),
2375: p_action_information7 => per_formula_functions.get_number('M_RATE2'),
2376: p_action_information8 => per_formula_functions.get_number('B_RATE1'),
2377: p_action_information9 => per_formula_functions.get_number('B_RATE2'),
2378: p_action_information10 => null,
2371: p_action_information3 => per_formula_functions.get_number('B_BUS_MILES'),
2372: p_action_information4 => per_formula_functions.get_number('C_RATE1'),
2373: p_action_information5 => per_formula_functions.get_number('C_RATE2'),
2374: p_action_information6 => per_formula_functions.get_number('M_RATE1'),
2375: p_action_information7 => per_formula_functions.get_number('M_RATE2'),
2376: p_action_information8 => per_formula_functions.get_number('B_RATE1'),
2377: p_action_information9 => per_formula_functions.get_number('B_RATE2'),
2378: p_action_information10 => null,
2379: p_action_information11 => null,
2372: p_action_information4 => per_formula_functions.get_number('C_RATE1'),
2373: p_action_information5 => per_formula_functions.get_number('C_RATE2'),
2374: p_action_information6 => per_formula_functions.get_number('M_RATE1'),
2375: p_action_information7 => per_formula_functions.get_number('M_RATE2'),
2376: p_action_information8 => per_formula_functions.get_number('B_RATE1'),
2377: p_action_information9 => per_formula_functions.get_number('B_RATE2'),
2378: p_action_information10 => null,
2379: p_action_information11 => null,
2380: p_action_information12 => per_formula_functions.get_number('C_MILEAGE_PAYMENTS'),
2373: p_action_information5 => per_formula_functions.get_number('C_RATE2'),
2374: p_action_information6 => per_formula_functions.get_number('M_RATE1'),
2375: p_action_information7 => per_formula_functions.get_number('M_RATE2'),
2376: p_action_information8 => per_formula_functions.get_number('B_RATE1'),
2377: p_action_information9 => per_formula_functions.get_number('B_RATE2'),
2378: p_action_information10 => null,
2379: p_action_information11 => null,
2380: p_action_information12 => per_formula_functions.get_number('C_MILEAGE_PAYMENTS'),
2381: p_action_information13 => per_formula_functions.get_number('B_MILEAGE_PAYMENTS'),
2376: p_action_information8 => per_formula_functions.get_number('B_RATE1'),
2377: p_action_information9 => per_formula_functions.get_number('B_RATE2'),
2378: p_action_information10 => null,
2379: p_action_information11 => null,
2380: p_action_information12 => per_formula_functions.get_number('C_MILEAGE_PAYMENTS'),
2381: p_action_information13 => per_formula_functions.get_number('B_MILEAGE_PAYMENTS'),
2382: p_action_information14 => per_formula_functions.get_number('M_MILEAGE_PAYMENTS'),
2383: p_action_information15 => per_formula_functions.get_number('MARORS_COUNT'),
2384: p_action_information16 => per_formula_functions.get_number('C_TAX_DEDUCTED'),
2377: p_action_information9 => per_formula_functions.get_number('B_RATE2'),
2378: p_action_information10 => null,
2379: p_action_information11 => null,
2380: p_action_information12 => per_formula_functions.get_number('C_MILEAGE_PAYMENTS'),
2381: p_action_information13 => per_formula_functions.get_number('B_MILEAGE_PAYMENTS'),
2382: p_action_information14 => per_formula_functions.get_number('M_MILEAGE_PAYMENTS'),
2383: p_action_information15 => per_formula_functions.get_number('MARORS_COUNT'),
2384: p_action_information16 => per_formula_functions.get_number('C_TAX_DEDUCTED'),
2385: p_action_information17 => per_formula_functions.get_number('B_TAX_DEDUCTED'),
2378: p_action_information10 => null,
2379: p_action_information11 => null,
2380: p_action_information12 => per_formula_functions.get_number('C_MILEAGE_PAYMENTS'),
2381: p_action_information13 => per_formula_functions.get_number('B_MILEAGE_PAYMENTS'),
2382: p_action_information14 => per_formula_functions.get_number('M_MILEAGE_PAYMENTS'),
2383: p_action_information15 => per_formula_functions.get_number('MARORS_COUNT'),
2384: p_action_information16 => per_formula_functions.get_number('C_TAX_DEDUCTED'),
2385: p_action_information17 => per_formula_functions.get_number('B_TAX_DEDUCTED'),
2386: p_action_information18 => per_formula_functions.get_number('M_TAX_DEDUCTED'),
2379: p_action_information11 => null,
2380: p_action_information12 => per_formula_functions.get_number('C_MILEAGE_PAYMENTS'),
2381: p_action_information13 => per_formula_functions.get_number('B_MILEAGE_PAYMENTS'),
2382: p_action_information14 => per_formula_functions.get_number('M_MILEAGE_PAYMENTS'),
2383: p_action_information15 => per_formula_functions.get_number('MARORS_COUNT'),
2384: p_action_information16 => per_formula_functions.get_number('C_TAX_DEDUCTED'),
2385: p_action_information17 => per_formula_functions.get_number('B_TAX_DEDUCTED'),
2386: p_action_information18 => per_formula_functions.get_number('M_TAX_DEDUCTED'),
2387: p_action_information19 => per_formula_functions.get_number('PASSENGER_PAYMENTS'),
2380: p_action_information12 => per_formula_functions.get_number('C_MILEAGE_PAYMENTS'),
2381: p_action_information13 => per_formula_functions.get_number('B_MILEAGE_PAYMENTS'),
2382: p_action_information14 => per_formula_functions.get_number('M_MILEAGE_PAYMENTS'),
2383: p_action_information15 => per_formula_functions.get_number('MARORS_COUNT'),
2384: p_action_information16 => per_formula_functions.get_number('C_TAX_DEDUCTED'),
2385: p_action_information17 => per_formula_functions.get_number('B_TAX_DEDUCTED'),
2386: p_action_information18 => per_formula_functions.get_number('M_TAX_DEDUCTED'),
2387: p_action_information19 => per_formula_functions.get_number('PASSENGER_PAYMENTS'),
2388: p_action_information20 => per_formula_functions.get_number('PASSENGER_BUS_MILES'),
2381: p_action_information13 => per_formula_functions.get_number('B_MILEAGE_PAYMENTS'),
2382: p_action_information14 => per_formula_functions.get_number('M_MILEAGE_PAYMENTS'),
2383: p_action_information15 => per_formula_functions.get_number('MARORS_COUNT'),
2384: p_action_information16 => per_formula_functions.get_number('C_TAX_DEDUCTED'),
2385: p_action_information17 => per_formula_functions.get_number('B_TAX_DEDUCTED'),
2386: p_action_information18 => per_formula_functions.get_number('M_TAX_DEDUCTED'),
2387: p_action_information19 => per_formula_functions.get_number('PASSENGER_PAYMENTS'),
2388: p_action_information20 => per_formula_functions.get_number('PASSENGER_BUS_MILES'),
2389: p_action_information21 => per_formula_functions.get_number('PASSENGER_BUS_MILE_AMT'),
2382: p_action_information14 => per_formula_functions.get_number('M_MILEAGE_PAYMENTS'),
2383: p_action_information15 => per_formula_functions.get_number('MARORS_COUNT'),
2384: p_action_information16 => per_formula_functions.get_number('C_TAX_DEDUCTED'),
2385: p_action_information17 => per_formula_functions.get_number('B_TAX_DEDUCTED'),
2386: p_action_information18 => per_formula_functions.get_number('M_TAX_DEDUCTED'),
2387: p_action_information19 => per_formula_functions.get_number('PASSENGER_PAYMENTS'),
2388: p_action_information20 => per_formula_functions.get_number('PASSENGER_BUS_MILES'),
2389: p_action_information21 => per_formula_functions.get_number('PASSENGER_BUS_MILE_AMT'),
2390: p_action_information22 => per_formula_functions.get_number('MILEAGE_ALLOWANCE_RELIEF'),
2383: p_action_information15 => per_formula_functions.get_number('MARORS_COUNT'),
2384: p_action_information16 => per_formula_functions.get_number('C_TAX_DEDUCTED'),
2385: p_action_information17 => per_formula_functions.get_number('B_TAX_DEDUCTED'),
2386: p_action_information18 => per_formula_functions.get_number('M_TAX_DEDUCTED'),
2387: p_action_information19 => per_formula_functions.get_number('PASSENGER_PAYMENTS'),
2388: p_action_information20 => per_formula_functions.get_number('PASSENGER_BUS_MILES'),
2389: p_action_information21 => per_formula_functions.get_number('PASSENGER_BUS_MILE_AMT'),
2390: p_action_information22 => per_formula_functions.get_number('MILEAGE_ALLOWANCE_RELIEF'),
2391: p_action_information23 => per_formula_functions.get_number('INT_MAX_AMT_OUTSTANDING'),
2384: p_action_information16 => per_formula_functions.get_number('C_TAX_DEDUCTED'),
2385: p_action_information17 => per_formula_functions.get_number('B_TAX_DEDUCTED'),
2386: p_action_information18 => per_formula_functions.get_number('M_TAX_DEDUCTED'),
2387: p_action_information19 => per_formula_functions.get_number('PASSENGER_PAYMENTS'),
2388: p_action_information20 => per_formula_functions.get_number('PASSENGER_BUS_MILES'),
2389: p_action_information21 => per_formula_functions.get_number('PASSENGER_BUS_MILE_AMT'),
2390: p_action_information22 => per_formula_functions.get_number('MILEAGE_ALLOWANCE_RELIEF'),
2391: p_action_information23 => per_formula_functions.get_number('INT_MAX_AMT_OUTSTANDING'),
2392: p_action_information24 => 'Y' --Updating the below parameter value for the bug fix 8864717.
2385: p_action_information17 => per_formula_functions.get_number('B_TAX_DEDUCTED'),
2386: p_action_information18 => per_formula_functions.get_number('M_TAX_DEDUCTED'),
2387: p_action_information19 => per_formula_functions.get_number('PASSENGER_PAYMENTS'),
2388: p_action_information20 => per_formula_functions.get_number('PASSENGER_BUS_MILES'),
2389: p_action_information21 => per_formula_functions.get_number('PASSENGER_BUS_MILE_AMT'),
2390: p_action_information22 => per_formula_functions.get_number('MILEAGE_ALLOWANCE_RELIEF'),
2391: p_action_information23 => per_formula_functions.get_number('INT_MAX_AMT_OUTSTANDING'),
2392: p_action_information24 => 'Y' --Updating the below parameter value for the bug fix 8864717.
2393: );
2386: p_action_information18 => per_formula_functions.get_number('M_TAX_DEDUCTED'),
2387: p_action_information19 => per_formula_functions.get_number('PASSENGER_PAYMENTS'),
2388: p_action_information20 => per_formula_functions.get_number('PASSENGER_BUS_MILES'),
2389: p_action_information21 => per_formula_functions.get_number('PASSENGER_BUS_MILE_AMT'),
2390: p_action_information22 => per_formula_functions.get_number('MILEAGE_ALLOWANCE_RELIEF'),
2391: p_action_information23 => per_formula_functions.get_number('INT_MAX_AMT_OUTSTANDING'),
2392: p_action_information24 => 'Y' --Updating the below parameter value for the bug fix 8864717.
2393: );
2394: END IF;
2387: p_action_information19 => per_formula_functions.get_number('PASSENGER_PAYMENTS'),
2388: p_action_information20 => per_formula_functions.get_number('PASSENGER_BUS_MILES'),
2389: p_action_information21 => per_formula_functions.get_number('PASSENGER_BUS_MILE_AMT'),
2390: p_action_information22 => per_formula_functions.get_number('MILEAGE_ALLOWANCE_RELIEF'),
2391: p_action_information23 => per_formula_functions.get_number('INT_MAX_AMT_OUTSTANDING'),
2392: p_action_information24 => 'Y' --Updating the below parameter value for the bug fix 8864717.
2393: );
2394: END IF;
2395: end if;
2428: PROCEDURE read_validate_log_desc(p_var_name VARCHAR2)
2429: IS
2430: l_var_value VARCHAR2(150);
2431: BEGIN
2432: l_var_value := per_formula_functions.get_text(p_var_name);
2433: IF UPPER(l_var_value) = 'MULTIPLE'
2434: THEN
2435: /* The code below can be removed when do P11D for year 05/06 */
2436: if to_number(g_param_rep_run) < 2005
2472: PROCEDURE read_validate_log(p_var_name VARCHAR2)
2473: IS
2474: l_var_value NUMBER;
2475: BEGIN
2476: l_var_value := per_formula_functions.get_number(p_var_name);
2477: IF p_var_name = 'F_COUNT'
2478: THEN
2479: IF l_var_value > 50
2480: THEN
2506: p_element_name VARCHAR2)
2507: IS
2508: l_var_value NUMBER;
2509: BEGIN
2510: l_var_value := per_formula_functions.get_number(p_var_name);
2511: If l_var_value < p_min_value then
2512: pay_core_utils.push_message(800, 'HR_GB_78083_MIN_VALUE_ERROR', 'F');
2513: pay_core_utils.push_token('ELEMENT_NAME', p_element_name);
2514: pay_core_utils.push_token('VALUE', p_min_value);
2635: end if;
2636: read_validate_min_max('MILEAGE_ALLOWANCE_RELIEF',-999999.99,0,'MARORS');
2637: -- checking max amount outstanding for Int free and low int loans
2638: -- will rasie just a warning for this
2639: If per_formula_functions.get_number('INT_MAX_AMT_OUTSTANDING') < l_loan_threshold then
2640: pay_core_utils.push_message(800, 'HR_GB_78083_MIN_VALUE_ERROR', 'W');
2641: pay_core_utils.push_token('ELEMENT_NAME', 'Int Free and Low Int Loans');
2642: pay_core_utils.push_token('VALUE', l_loan_threshold);
2643: l_warn := '1';
3164: l_index := l_first_index;
3165:
3166: -- loop thru all the benefits
3167: -- resetting globals as earlier values should not be used!
3168: l_ret := per_formula_functions.remove_globals;
3169: -- hr_utility.trace_on(null,'ARCH');
3170:
3171: WHILE l_index <= g_tab_ben_detail.LAST
3172: LOOP
3300: pay_core_utils.push_message(800, 'HR_78055_GB_P11D_FORMULA_ERR', 'F');
3301: pay_core_utils.push_token('ELEMENT_NAME', l_element_name);
3302: hr_utility.set_location('Nothing to execute ! '|| ' :' || l_proc, 70);
3303: -- Remove ALL GLOBALS
3304: l_ret := per_formula_functions.remove_globals;
3305: RAISE error_found;
3306: End;
3307: -- Now passing the l_user_inputs to the array l_inputs
3308: IF l_inputs.COUNT > 0 AND l_user_inputs.COUNT > 0
3709: THEN
3710: hr_utility.set_location('Failing Assignment '|| ' :' || l_proc, 70);
3711: --log_message;
3712: -- Remove ALL GLOBALS
3713: l_ret := per_formula_functions.remove_globals;
3714: RAISE error_found;
3715: ELSE
3716: -- insert rows which are sums for all values in ffs
3717: hr_utility.trace('Inserting summed records ');
3716: -- insert rows which are sums for all values in ffs
3717: hr_utility.trace('Inserting summed records ');
3718: insert_sum_records(p_assactid);
3719: -- Remove ALL GLOBALS
3720: l_ret := per_formula_functions.remove_globals;
3721: /* bug fix for 3485256
3722: l_index := g_tab_ben_detail.FIRST;
3723: */
3724: l_index := l_first_index;
3752: IF l_error = '1'
3753: THEN
3754: hr_utility.set_location('Failing Assignment '|| ' :' || l_proc, 90);
3755: -- Remove ALL GLOBALS
3756: l_ret := per_formula_functions.remove_globals;
3757: RAISE error_found;
3758: ELSE
3759: l_tab_counter := l_processed_assign_actions.FIRST;
3760: hr_utility.trace('Calling Update values..');
3766: END LOOP;
3767: END IF;
3768: END IF;
3769: END IF;
3770: l_ret := per_formula_functions.remove_globals;
3771: hr_utility.trace('nearing end');
3772: EXCEPTION
3773: WHEN error_found
3774: THEN
3771: hr_utility.trace('nearing end');
3772: EXCEPTION
3773: WHEN error_found
3774: THEN
3775: l_ret := per_formula_functions.remove_globals;
3776: -- the error will be reported in Deinitialization proc
3777: -- write_error_to_log;
3778: g_set_warning := TRUE;
3779: hr_utility.raise_error;