1431: l_taxable_pass_payment Number;
1432: l_ce Number;
1433: begin
1434: -- hr_utility.trace_on(null,'AMAP');
1435: l_C_BUS_MILES := nvl(per_formula_functions.get_number('C_BUS_MILES'),0);
1436: l_M_BUS_MILES := nvl(per_formula_functions.get_number('M_BUS_MILES'),0);
1437: l_B_BUS_MILES := nvl(per_formula_functions.get_number('B_BUS_MILES'),0);
1438: l_C_RATE1 := nvl(per_formula_functions.get_number('C_RATE1'),0);
1439: l_C_RATE2 := nvl(per_formula_functions.get_number('C_RATE2'),0);
1432: l_ce Number;
1433: begin
1434: -- hr_utility.trace_on(null,'AMAP');
1435: l_C_BUS_MILES := nvl(per_formula_functions.get_number('C_BUS_MILES'),0);
1436: l_M_BUS_MILES := nvl(per_formula_functions.get_number('M_BUS_MILES'),0);
1437: l_B_BUS_MILES := nvl(per_formula_functions.get_number('B_BUS_MILES'),0);
1438: l_C_RATE1 := nvl(per_formula_functions.get_number('C_RATE1'),0);
1439: l_C_RATE2 := nvl(per_formula_functions.get_number('C_RATE2'),0);
1440: l_M_RATE1 := nvl(per_formula_functions.get_number('M_RATE1'),0);
1433: begin
1434: -- hr_utility.trace_on(null,'AMAP');
1435: l_C_BUS_MILES := nvl(per_formula_functions.get_number('C_BUS_MILES'),0);
1436: l_M_BUS_MILES := nvl(per_formula_functions.get_number('M_BUS_MILES'),0);
1437: l_B_BUS_MILES := nvl(per_formula_functions.get_number('B_BUS_MILES'),0);
1438: l_C_RATE1 := nvl(per_formula_functions.get_number('C_RATE1'),0);
1439: l_C_RATE2 := nvl(per_formula_functions.get_number('C_RATE2'),0);
1440: l_M_RATE1 := nvl(per_formula_functions.get_number('M_RATE1'),0);
1441: l_M_RATE2 := nvl(per_formula_functions.get_number('M_RATE2'),0);
1434: -- hr_utility.trace_on(null,'AMAP');
1435: l_C_BUS_MILES := nvl(per_formula_functions.get_number('C_BUS_MILES'),0);
1436: l_M_BUS_MILES := nvl(per_formula_functions.get_number('M_BUS_MILES'),0);
1437: l_B_BUS_MILES := nvl(per_formula_functions.get_number('B_BUS_MILES'),0);
1438: l_C_RATE1 := nvl(per_formula_functions.get_number('C_RATE1'),0);
1439: l_C_RATE2 := nvl(per_formula_functions.get_number('C_RATE2'),0);
1440: l_M_RATE1 := nvl(per_formula_functions.get_number('M_RATE1'),0);
1441: l_M_RATE2 := nvl(per_formula_functions.get_number('M_RATE2'),0);
1442: l_B_RATE1 := nvl(per_formula_functions.get_number('B_RATE1'),0);
1435: l_C_BUS_MILES := nvl(per_formula_functions.get_number('C_BUS_MILES'),0);
1436: l_M_BUS_MILES := nvl(per_formula_functions.get_number('M_BUS_MILES'),0);
1437: l_B_BUS_MILES := nvl(per_formula_functions.get_number('B_BUS_MILES'),0);
1438: l_C_RATE1 := nvl(per_formula_functions.get_number('C_RATE1'),0);
1439: l_C_RATE2 := nvl(per_formula_functions.get_number('C_RATE2'),0);
1440: l_M_RATE1 := nvl(per_formula_functions.get_number('M_RATE1'),0);
1441: l_M_RATE2 := nvl(per_formula_functions.get_number('M_RATE2'),0);
1442: l_B_RATE1 := nvl(per_formula_functions.get_number('B_RATE1'),0);
1443: l_B_RATE2 := nvl(per_formula_functions.get_number('B_RATE2'),0);
1436: l_M_BUS_MILES := nvl(per_formula_functions.get_number('M_BUS_MILES'),0);
1437: l_B_BUS_MILES := nvl(per_formula_functions.get_number('B_BUS_MILES'),0);
1438: l_C_RATE1 := nvl(per_formula_functions.get_number('C_RATE1'),0);
1439: l_C_RATE2 := nvl(per_formula_functions.get_number('C_RATE2'),0);
1440: l_M_RATE1 := nvl(per_formula_functions.get_number('M_RATE1'),0);
1441: l_M_RATE2 := nvl(per_formula_functions.get_number('M_RATE2'),0);
1442: l_B_RATE1 := nvl(per_formula_functions.get_number('B_RATE1'),0);
1443: l_B_RATE2 := nvl(per_formula_functions.get_number('B_RATE2'),0);
1444: l_C_MILEAGE_PAYMENTS := nvl(per_formula_functions.get_number('C_MILEAGE_PAYMENTS'),0);
1437: l_B_BUS_MILES := nvl(per_formula_functions.get_number('B_BUS_MILES'),0);
1438: l_C_RATE1 := nvl(per_formula_functions.get_number('C_RATE1'),0);
1439: l_C_RATE2 := nvl(per_formula_functions.get_number('C_RATE2'),0);
1440: l_M_RATE1 := nvl(per_formula_functions.get_number('M_RATE1'),0);
1441: l_M_RATE2 := nvl(per_formula_functions.get_number('M_RATE2'),0);
1442: l_B_RATE1 := nvl(per_formula_functions.get_number('B_RATE1'),0);
1443: l_B_RATE2 := nvl(per_formula_functions.get_number('B_RATE2'),0);
1444: l_C_MILEAGE_PAYMENTS := nvl(per_formula_functions.get_number('C_MILEAGE_PAYMENTS'),0);
1445: l_B_MILEAGE_PAYMENTS := nvl(per_formula_functions.get_number('B_MILEAGE_PAYMENTS'),0);
1438: l_C_RATE1 := nvl(per_formula_functions.get_number('C_RATE1'),0);
1439: l_C_RATE2 := nvl(per_formula_functions.get_number('C_RATE2'),0);
1440: l_M_RATE1 := nvl(per_formula_functions.get_number('M_RATE1'),0);
1441: l_M_RATE2 := nvl(per_formula_functions.get_number('M_RATE2'),0);
1442: l_B_RATE1 := nvl(per_formula_functions.get_number('B_RATE1'),0);
1443: l_B_RATE2 := nvl(per_formula_functions.get_number('B_RATE2'),0);
1444: l_C_MILEAGE_PAYMENTS := nvl(per_formula_functions.get_number('C_MILEAGE_PAYMENTS'),0);
1445: l_B_MILEAGE_PAYMENTS := nvl(per_formula_functions.get_number('B_MILEAGE_PAYMENTS'),0);
1446: l_M_MILEAGE_PAYMENTS := nvl(per_formula_functions.get_number('M_MILEAGE_PAYMENTS'),0);
1439: l_C_RATE2 := nvl(per_formula_functions.get_number('C_RATE2'),0);
1440: l_M_RATE1 := nvl(per_formula_functions.get_number('M_RATE1'),0);
1441: l_M_RATE2 := nvl(per_formula_functions.get_number('M_RATE2'),0);
1442: l_B_RATE1 := nvl(per_formula_functions.get_number('B_RATE1'),0);
1443: l_B_RATE2 := nvl(per_formula_functions.get_number('B_RATE2'),0);
1444: l_C_MILEAGE_PAYMENTS := nvl(per_formula_functions.get_number('C_MILEAGE_PAYMENTS'),0);
1445: l_B_MILEAGE_PAYMENTS := nvl(per_formula_functions.get_number('B_MILEAGE_PAYMENTS'),0);
1446: l_M_MILEAGE_PAYMENTS := nvl(per_formula_functions.get_number('M_MILEAGE_PAYMENTS'),0);
1447: l_C_TAX_DEDUCTED := nvl(per_formula_functions.get_number('C_TAX_DEDUCTED'),0);
1440: l_M_RATE1 := nvl(per_formula_functions.get_number('M_RATE1'),0);
1441: l_M_RATE2 := nvl(per_formula_functions.get_number('M_RATE2'),0);
1442: l_B_RATE1 := nvl(per_formula_functions.get_number('B_RATE1'),0);
1443: l_B_RATE2 := nvl(per_formula_functions.get_number('B_RATE2'),0);
1444: l_C_MILEAGE_PAYMENTS := nvl(per_formula_functions.get_number('C_MILEAGE_PAYMENTS'),0);
1445: l_B_MILEAGE_PAYMENTS := nvl(per_formula_functions.get_number('B_MILEAGE_PAYMENTS'),0);
1446: l_M_MILEAGE_PAYMENTS := nvl(per_formula_functions.get_number('M_MILEAGE_PAYMENTS'),0);
1447: l_C_TAX_DEDUCTED := nvl(per_formula_functions.get_number('C_TAX_DEDUCTED'),0);
1448: l_B_TAX_DEDUCTED := nvl(per_formula_functions.get_number('B_TAX_DEDUCTED'),0);
1441: l_M_RATE2 := nvl(per_formula_functions.get_number('M_RATE2'),0);
1442: l_B_RATE1 := nvl(per_formula_functions.get_number('B_RATE1'),0);
1443: l_B_RATE2 := nvl(per_formula_functions.get_number('B_RATE2'),0);
1444: l_C_MILEAGE_PAYMENTS := nvl(per_formula_functions.get_number('C_MILEAGE_PAYMENTS'),0);
1445: l_B_MILEAGE_PAYMENTS := nvl(per_formula_functions.get_number('B_MILEAGE_PAYMENTS'),0);
1446: l_M_MILEAGE_PAYMENTS := nvl(per_formula_functions.get_number('M_MILEAGE_PAYMENTS'),0);
1447: l_C_TAX_DEDUCTED := nvl(per_formula_functions.get_number('C_TAX_DEDUCTED'),0);
1448: l_B_TAX_DEDUCTED := nvl(per_formula_functions.get_number('B_TAX_DEDUCTED'),0);
1449: l_M_TAX_DEDUCTED := nvl(per_formula_functions.get_number('M_TAX_DEDUCTED'),0);
1442: l_B_RATE1 := nvl(per_formula_functions.get_number('B_RATE1'),0);
1443: l_B_RATE2 := nvl(per_formula_functions.get_number('B_RATE2'),0);
1444: l_C_MILEAGE_PAYMENTS := nvl(per_formula_functions.get_number('C_MILEAGE_PAYMENTS'),0);
1445: l_B_MILEAGE_PAYMENTS := nvl(per_formula_functions.get_number('B_MILEAGE_PAYMENTS'),0);
1446: l_M_MILEAGE_PAYMENTS := nvl(per_formula_functions.get_number('M_MILEAGE_PAYMENTS'),0);
1447: l_C_TAX_DEDUCTED := nvl(per_formula_functions.get_number('C_TAX_DEDUCTED'),0);
1448: l_B_TAX_DEDUCTED := nvl(per_formula_functions.get_number('B_TAX_DEDUCTED'),0);
1449: l_M_TAX_DEDUCTED := nvl(per_formula_functions.get_number('M_TAX_DEDUCTED'),0);
1450: l_PASSENGER_PAYMENTS := nvl(per_formula_functions.get_number('PASSENGER_PAYMENTS'),0);
1443: l_B_RATE2 := nvl(per_formula_functions.get_number('B_RATE2'),0);
1444: l_C_MILEAGE_PAYMENTS := nvl(per_formula_functions.get_number('C_MILEAGE_PAYMENTS'),0);
1445: l_B_MILEAGE_PAYMENTS := nvl(per_formula_functions.get_number('B_MILEAGE_PAYMENTS'),0);
1446: l_M_MILEAGE_PAYMENTS := nvl(per_formula_functions.get_number('M_MILEAGE_PAYMENTS'),0);
1447: l_C_TAX_DEDUCTED := nvl(per_formula_functions.get_number('C_TAX_DEDUCTED'),0);
1448: l_B_TAX_DEDUCTED := nvl(per_formula_functions.get_number('B_TAX_DEDUCTED'),0);
1449: l_M_TAX_DEDUCTED := nvl(per_formula_functions.get_number('M_TAX_DEDUCTED'),0);
1450: l_PASSENGER_PAYMENTS := nvl(per_formula_functions.get_number('PASSENGER_PAYMENTS'),0);
1451: l_PASSENGER_BUS_MILES := nvl(per_formula_functions.get_number('PASSENGER_BUS_MILES'),0);
1444: l_C_MILEAGE_PAYMENTS := nvl(per_formula_functions.get_number('C_MILEAGE_PAYMENTS'),0);
1445: l_B_MILEAGE_PAYMENTS := nvl(per_formula_functions.get_number('B_MILEAGE_PAYMENTS'),0);
1446: l_M_MILEAGE_PAYMENTS := nvl(per_formula_functions.get_number('M_MILEAGE_PAYMENTS'),0);
1447: l_C_TAX_DEDUCTED := nvl(per_formula_functions.get_number('C_TAX_DEDUCTED'),0);
1448: l_B_TAX_DEDUCTED := nvl(per_formula_functions.get_number('B_TAX_DEDUCTED'),0);
1449: l_M_TAX_DEDUCTED := nvl(per_formula_functions.get_number('M_TAX_DEDUCTED'),0);
1450: l_PASSENGER_PAYMENTS := nvl(per_formula_functions.get_number('PASSENGER_PAYMENTS'),0);
1451: l_PASSENGER_BUS_MILES := nvl(per_formula_functions.get_number('PASSENGER_BUS_MILES'),0);
1452: l_PASSENGER_BUS_MILE_AMT := nvl(per_formula_functions.get_number('PASSENGER_BUS_MILE_AMT'),0);
1445: l_B_MILEAGE_PAYMENTS := nvl(per_formula_functions.get_number('B_MILEAGE_PAYMENTS'),0);
1446: l_M_MILEAGE_PAYMENTS := nvl(per_formula_functions.get_number('M_MILEAGE_PAYMENTS'),0);
1447: l_C_TAX_DEDUCTED := nvl(per_formula_functions.get_number('C_TAX_DEDUCTED'),0);
1448: l_B_TAX_DEDUCTED := nvl(per_formula_functions.get_number('B_TAX_DEDUCTED'),0);
1449: l_M_TAX_DEDUCTED := nvl(per_formula_functions.get_number('M_TAX_DEDUCTED'),0);
1450: l_PASSENGER_PAYMENTS := nvl(per_formula_functions.get_number('PASSENGER_PAYMENTS'),0);
1451: l_PASSENGER_BUS_MILES := nvl(per_formula_functions.get_number('PASSENGER_BUS_MILES'),0);
1452: l_PASSENGER_BUS_MILE_AMT := nvl(per_formula_functions.get_number('PASSENGER_BUS_MILE_AMT'),0);
1453:
1446: l_M_MILEAGE_PAYMENTS := nvl(per_formula_functions.get_number('M_MILEAGE_PAYMENTS'),0);
1447: l_C_TAX_DEDUCTED := nvl(per_formula_functions.get_number('C_TAX_DEDUCTED'),0);
1448: l_B_TAX_DEDUCTED := nvl(per_formula_functions.get_number('B_TAX_DEDUCTED'),0);
1449: l_M_TAX_DEDUCTED := nvl(per_formula_functions.get_number('M_TAX_DEDUCTED'),0);
1450: l_PASSENGER_PAYMENTS := nvl(per_formula_functions.get_number('PASSENGER_PAYMENTS'),0);
1451: l_PASSENGER_BUS_MILES := nvl(per_formula_functions.get_number('PASSENGER_BUS_MILES'),0);
1452: l_PASSENGER_BUS_MILE_AMT := nvl(per_formula_functions.get_number('PASSENGER_BUS_MILE_AMT'),0);
1453:
1454: l_c_net_allowance := l_C_MILEAGE_PAYMENTS - l_C_TAX_DEDUCTED;
1447: l_C_TAX_DEDUCTED := nvl(per_formula_functions.get_number('C_TAX_DEDUCTED'),0);
1448: l_B_TAX_DEDUCTED := nvl(per_formula_functions.get_number('B_TAX_DEDUCTED'),0);
1449: l_M_TAX_DEDUCTED := nvl(per_formula_functions.get_number('M_TAX_DEDUCTED'),0);
1450: l_PASSENGER_PAYMENTS := nvl(per_formula_functions.get_number('PASSENGER_PAYMENTS'),0);
1451: l_PASSENGER_BUS_MILES := nvl(per_formula_functions.get_number('PASSENGER_BUS_MILES'),0);
1452: l_PASSENGER_BUS_MILE_AMT := nvl(per_formula_functions.get_number('PASSENGER_BUS_MILE_AMT'),0);
1453:
1454: l_c_net_allowance := l_C_MILEAGE_PAYMENTS - l_C_TAX_DEDUCTED;
1455: if l_c_net_allowance < 0
1448: l_B_TAX_DEDUCTED := nvl(per_formula_functions.get_number('B_TAX_DEDUCTED'),0);
1449: l_M_TAX_DEDUCTED := nvl(per_formula_functions.get_number('M_TAX_DEDUCTED'),0);
1450: l_PASSENGER_PAYMENTS := nvl(per_formula_functions.get_number('PASSENGER_PAYMENTS'),0);
1451: l_PASSENGER_BUS_MILES := nvl(per_formula_functions.get_number('PASSENGER_BUS_MILES'),0);
1452: l_PASSENGER_BUS_MILE_AMT := nvl(per_formula_functions.get_number('PASSENGER_BUS_MILE_AMT'),0);
1453:
1454: l_c_net_allowance := l_C_MILEAGE_PAYMENTS - l_C_TAX_DEDUCTED;
1455: if l_c_net_allowance < 0
1456: then
1536: p_effective_date => fnd_date.canonical_to_date(g_param_benefit_end_date),
1537: p_source_id => NULL,
1538: p_source_text => NULL,
1539: p_action_information_category => 'GB P11D ASSIGNMENT RESULTA',
1540: p_action_information1 => per_formula_functions.get_text('A_DESC'),
1541: p_action_information2 => per_formula_functions.get_number('A_COST'),
1542: p_action_information3 => per_formula_functions.get_number('A_AMG'),
1543: p_action_information4 => per_formula_functions.get_number('A_CE'),
1544: p_action_information5 => per_formula_functions.get_text('B_DESC'),
1537: p_source_id => NULL,
1538: p_source_text => NULL,
1539: p_action_information_category => 'GB P11D ASSIGNMENT RESULTA',
1540: p_action_information1 => per_formula_functions.get_text('A_DESC'),
1541: p_action_information2 => per_formula_functions.get_number('A_COST'),
1542: p_action_information3 => per_formula_functions.get_number('A_AMG'),
1543: p_action_information4 => per_formula_functions.get_number('A_CE'),
1544: p_action_information5 => per_formula_functions.get_text('B_DESC'),
1545: p_action_information6 => per_formula_functions.get_number('B_CE'),
1538: p_source_text => NULL,
1539: p_action_information_category => 'GB P11D ASSIGNMENT RESULTA',
1540: p_action_information1 => per_formula_functions.get_text('A_DESC'),
1541: p_action_information2 => per_formula_functions.get_number('A_COST'),
1542: p_action_information3 => per_formula_functions.get_number('A_AMG'),
1543: p_action_information4 => per_formula_functions.get_number('A_CE'),
1544: p_action_information5 => per_formula_functions.get_text('B_DESC'),
1545: p_action_information6 => per_formula_functions.get_number('B_CE'),
1546: p_action_information7 => per_formula_functions.get_number('B_TNP'),
1539: p_action_information_category => 'GB P11D ASSIGNMENT RESULTA',
1540: p_action_information1 => per_formula_functions.get_text('A_DESC'),
1541: p_action_information2 => per_formula_functions.get_number('A_COST'),
1542: p_action_information3 => per_formula_functions.get_number('A_AMG'),
1543: p_action_information4 => per_formula_functions.get_number('A_CE'),
1544: p_action_information5 => per_formula_functions.get_text('B_DESC'),
1545: p_action_information6 => per_formula_functions.get_number('B_CE'),
1546: p_action_information7 => per_formula_functions.get_number('B_TNP'),
1547: p_action_information8 => per_formula_functions.get_number('C_COST'),
1540: p_action_information1 => per_formula_functions.get_text('A_DESC'),
1541: p_action_information2 => per_formula_functions.get_number('A_COST'),
1542: p_action_information3 => per_formula_functions.get_number('A_AMG'),
1543: p_action_information4 => per_formula_functions.get_number('A_CE'),
1544: p_action_information5 => per_formula_functions.get_text('B_DESC'),
1545: p_action_information6 => per_formula_functions.get_number('B_CE'),
1546: p_action_information7 => per_formula_functions.get_number('B_TNP'),
1547: p_action_information8 => per_formula_functions.get_number('C_COST'),
1548: p_action_information9 => per_formula_functions.get_number('C_AMG'),
1541: p_action_information2 => per_formula_functions.get_number('A_COST'),
1542: p_action_information3 => per_formula_functions.get_number('A_AMG'),
1543: p_action_information4 => per_formula_functions.get_number('A_CE'),
1544: p_action_information5 => per_formula_functions.get_text('B_DESC'),
1545: p_action_information6 => per_formula_functions.get_number('B_CE'),
1546: p_action_information7 => per_formula_functions.get_number('B_TNP'),
1547: p_action_information8 => per_formula_functions.get_number('C_COST'),
1548: p_action_information9 => per_formula_functions.get_number('C_AMG'),
1549: p_action_information10 => per_formula_functions.get_number('C_CE'),
1542: p_action_information3 => per_formula_functions.get_number('A_AMG'),
1543: p_action_information4 => per_formula_functions.get_number('A_CE'),
1544: p_action_information5 => per_formula_functions.get_text('B_DESC'),
1545: p_action_information6 => per_formula_functions.get_number('B_CE'),
1546: p_action_information7 => per_formula_functions.get_number('B_TNP'),
1547: p_action_information8 => per_formula_functions.get_number('C_COST'),
1548: p_action_information9 => per_formula_functions.get_number('C_AMG'),
1549: p_action_information10 => per_formula_functions.get_number('C_CE'),
1550: p_action_information11 => per_formula_functions.get_number('D_CE'),
1543: p_action_information4 => per_formula_functions.get_number('A_CE'),
1544: p_action_information5 => per_formula_functions.get_text('B_DESC'),
1545: p_action_information6 => per_formula_functions.get_number('B_CE'),
1546: p_action_information7 => per_formula_functions.get_number('B_TNP'),
1547: p_action_information8 => per_formula_functions.get_number('C_COST'),
1548: p_action_information9 => per_formula_functions.get_number('C_AMG'),
1549: p_action_information10 => per_formula_functions.get_number('C_CE'),
1550: p_action_information11 => per_formula_functions.get_number('D_CE'),
1551: p_action_information12 => calculate_amap_ce ,
1544: p_action_information5 => per_formula_functions.get_text('B_DESC'),
1545: p_action_information6 => per_formula_functions.get_number('B_CE'),
1546: p_action_information7 => per_formula_functions.get_number('B_TNP'),
1547: p_action_information8 => per_formula_functions.get_number('C_COST'),
1548: p_action_information9 => per_formula_functions.get_number('C_AMG'),
1549: p_action_information10 => per_formula_functions.get_number('C_CE'),
1550: p_action_information11 => per_formula_functions.get_number('D_CE'),
1551: p_action_information12 => calculate_amap_ce ,
1552: p_action_information13 => per_formula_functions.get_number('F_TCCE'),
1545: p_action_information6 => per_formula_functions.get_number('B_CE'),
1546: p_action_information7 => per_formula_functions.get_number('B_TNP'),
1547: p_action_information8 => per_formula_functions.get_number('C_COST'),
1548: p_action_information9 => per_formula_functions.get_number('C_AMG'),
1549: p_action_information10 => per_formula_functions.get_number('C_CE'),
1550: p_action_information11 => per_formula_functions.get_number('D_CE'),
1551: p_action_information12 => calculate_amap_ce ,
1552: p_action_information13 => per_formula_functions.get_number('F_TCCE'),
1553: p_action_information14 => per_formula_functions.get_number('F_TFCE'),
1546: p_action_information7 => per_formula_functions.get_number('B_TNP'),
1547: p_action_information8 => per_formula_functions.get_number('C_COST'),
1548: p_action_information9 => per_formula_functions.get_number('C_AMG'),
1549: p_action_information10 => per_formula_functions.get_number('C_CE'),
1550: p_action_information11 => per_formula_functions.get_number('D_CE'),
1551: p_action_information12 => calculate_amap_ce ,
1552: p_action_information13 => per_formula_functions.get_number('F_TCCE'),
1553: p_action_information14 => per_formula_functions.get_number('F_TFCE'),
1554: p_action_information15 => per_formula_functions.get_number('G_CE'),
1548: p_action_information9 => per_formula_functions.get_number('C_AMG'),
1549: p_action_information10 => per_formula_functions.get_number('C_CE'),
1550: p_action_information11 => per_formula_functions.get_number('D_CE'),
1551: p_action_information12 => calculate_amap_ce ,
1552: p_action_information13 => per_formula_functions.get_number('F_TCCE'),
1553: p_action_information14 => per_formula_functions.get_number('F_TFCE'),
1554: p_action_information15 => per_formula_functions.get_number('G_CE'),
1555: p_action_information16 => per_formula_functions.get_number('I_COST'),
1556: p_action_information17 => per_formula_functions.get_number('I_AMG'),
1549: p_action_information10 => per_formula_functions.get_number('C_CE'),
1550: p_action_information11 => per_formula_functions.get_number('D_CE'),
1551: p_action_information12 => calculate_amap_ce ,
1552: p_action_information13 => per_formula_functions.get_number('F_TCCE'),
1553: p_action_information14 => per_formula_functions.get_number('F_TFCE'),
1554: p_action_information15 => per_formula_functions.get_number('G_CE'),
1555: p_action_information16 => per_formula_functions.get_number('I_COST'),
1556: p_action_information17 => per_formula_functions.get_number('I_AMG'),
1557: p_action_information18 => per_formula_functions.get_number('I_CE'),
1550: p_action_information11 => per_formula_functions.get_number('D_CE'),
1551: p_action_information12 => calculate_amap_ce ,
1552: p_action_information13 => per_formula_functions.get_number('F_TCCE'),
1553: p_action_information14 => per_formula_functions.get_number('F_TFCE'),
1554: p_action_information15 => per_formula_functions.get_number('G_CE'),
1555: p_action_information16 => per_formula_functions.get_number('I_COST'),
1556: p_action_information17 => per_formula_functions.get_number('I_AMG'),
1557: p_action_information18 => per_formula_functions.get_number('I_CE'),
1558: p_action_information19 => per_formula_functions.get_number('J_CE'),
1551: p_action_information12 => calculate_amap_ce ,
1552: p_action_information13 => per_formula_functions.get_number('F_TCCE'),
1553: p_action_information14 => per_formula_functions.get_number('F_TFCE'),
1554: p_action_information15 => per_formula_functions.get_number('G_CE'),
1555: p_action_information16 => per_formula_functions.get_number('I_COST'),
1556: p_action_information17 => per_formula_functions.get_number('I_AMG'),
1557: p_action_information18 => per_formula_functions.get_number('I_CE'),
1558: p_action_information19 => per_formula_functions.get_number('J_CE'),
1559: p_action_information20 => per_formula_functions.get_number('K_COST'),
1552: p_action_information13 => per_formula_functions.get_number('F_TCCE'),
1553: p_action_information14 => per_formula_functions.get_number('F_TFCE'),
1554: p_action_information15 => per_formula_functions.get_number('G_CE'),
1555: p_action_information16 => per_formula_functions.get_number('I_COST'),
1556: p_action_information17 => per_formula_functions.get_number('I_AMG'),
1557: p_action_information18 => per_formula_functions.get_number('I_CE'),
1558: p_action_information19 => per_formula_functions.get_number('J_CE'),
1559: p_action_information20 => per_formula_functions.get_number('K_COST'),
1560: p_action_information21 => per_formula_functions.get_number('K_AMG'),
1553: p_action_information14 => per_formula_functions.get_number('F_TFCE'),
1554: p_action_information15 => per_formula_functions.get_number('G_CE'),
1555: p_action_information16 => per_formula_functions.get_number('I_COST'),
1556: p_action_information17 => per_formula_functions.get_number('I_AMG'),
1557: p_action_information18 => per_formula_functions.get_number('I_CE'),
1558: p_action_information19 => per_formula_functions.get_number('J_CE'),
1559: p_action_information20 => per_formula_functions.get_number('K_COST'),
1560: p_action_information21 => per_formula_functions.get_number('K_AMG'),
1561: p_action_information22 => per_formula_functions.get_number('K_CE'),
1554: p_action_information15 => per_formula_functions.get_number('G_CE'),
1555: p_action_information16 => per_formula_functions.get_number('I_COST'),
1556: p_action_information17 => per_formula_functions.get_number('I_AMG'),
1557: p_action_information18 => per_formula_functions.get_number('I_CE'),
1558: p_action_information19 => per_formula_functions.get_number('J_CE'),
1559: p_action_information20 => per_formula_functions.get_number('K_COST'),
1560: p_action_information21 => per_formula_functions.get_number('K_AMG'),
1561: p_action_information22 => per_formula_functions.get_number('K_CE'),
1562: p_action_information23 => per_formula_functions.get_text('L_DESC'),
1555: p_action_information16 => per_formula_functions.get_number('I_COST'),
1556: p_action_information17 => per_formula_functions.get_number('I_AMG'),
1557: p_action_information18 => per_formula_functions.get_number('I_CE'),
1558: p_action_information19 => per_formula_functions.get_number('J_CE'),
1559: p_action_information20 => per_formula_functions.get_number('K_COST'),
1560: p_action_information21 => per_formula_functions.get_number('K_AMG'),
1561: p_action_information22 => per_formula_functions.get_number('K_CE'),
1562: p_action_information23 => per_formula_functions.get_text('L_DESC'),
1563: p_action_information24 => per_formula_functions.get_number('L_COST'),
1556: p_action_information17 => per_formula_functions.get_number('I_AMG'),
1557: p_action_information18 => per_formula_functions.get_number('I_CE'),
1558: p_action_information19 => per_formula_functions.get_number('J_CE'),
1559: p_action_information20 => per_formula_functions.get_number('K_COST'),
1560: p_action_information21 => per_formula_functions.get_number('K_AMG'),
1561: p_action_information22 => per_formula_functions.get_number('K_CE'),
1562: p_action_information23 => per_formula_functions.get_text('L_DESC'),
1563: p_action_information24 => per_formula_functions.get_number('L_COST'),
1564: p_action_information25 => per_formula_functions.get_number('L_AMG'),
1557: p_action_information18 => per_formula_functions.get_number('I_CE'),
1558: p_action_information19 => per_formula_functions.get_number('J_CE'),
1559: p_action_information20 => per_formula_functions.get_number('K_COST'),
1560: p_action_information21 => per_formula_functions.get_number('K_AMG'),
1561: p_action_information22 => per_formula_functions.get_number('K_CE'),
1562: p_action_information23 => per_formula_functions.get_text('L_DESC'),
1563: p_action_information24 => per_formula_functions.get_number('L_COST'),
1564: p_action_information25 => per_formula_functions.get_number('L_AMG'),
1565: p_action_information26 => per_formula_functions.get_number('L_CE'),
1558: p_action_information19 => per_formula_functions.get_number('J_CE'),
1559: p_action_information20 => per_formula_functions.get_number('K_COST'),
1560: p_action_information21 => per_formula_functions.get_number('K_AMG'),
1561: p_action_information22 => per_formula_functions.get_number('K_CE'),
1562: p_action_information23 => per_formula_functions.get_text('L_DESC'),
1563: p_action_information24 => per_formula_functions.get_number('L_COST'),
1564: p_action_information25 => per_formula_functions.get_number('L_AMG'),
1565: p_action_information26 => per_formula_functions.get_number('L_CE'),
1566: p_action_information27 => per_formula_functions.get_text('M_SHARES'),
1559: p_action_information20 => per_formula_functions.get_number('K_COST'),
1560: p_action_information21 => per_formula_functions.get_number('K_AMG'),
1561: p_action_information22 => per_formula_functions.get_number('K_CE'),
1562: p_action_information23 => per_formula_functions.get_text('L_DESC'),
1563: p_action_information24 => per_formula_functions.get_number('L_COST'),
1564: p_action_information25 => per_formula_functions.get_number('L_AMG'),
1565: p_action_information26 => per_formula_functions.get_number('L_CE'),
1566: p_action_information27 => per_formula_functions.get_text('M_SHARES'),
1567: p_action_information28 => per_formula_functions.get_number('H_CE1'),
1560: p_action_information21 => per_formula_functions.get_number('K_AMG'),
1561: p_action_information22 => per_formula_functions.get_number('K_CE'),
1562: p_action_information23 => per_formula_functions.get_text('L_DESC'),
1563: p_action_information24 => per_formula_functions.get_number('L_COST'),
1564: p_action_information25 => per_formula_functions.get_number('L_AMG'),
1565: p_action_information26 => per_formula_functions.get_number('L_CE'),
1566: p_action_information27 => per_formula_functions.get_text('M_SHARES'),
1567: p_action_information28 => per_formula_functions.get_number('H_CE1'),
1568: p_action_information29 => per_formula_functions.get_number('H_COUNT'),
1561: p_action_information22 => per_formula_functions.get_number('K_CE'),
1562: p_action_information23 => per_formula_functions.get_text('L_DESC'),
1563: p_action_information24 => per_formula_functions.get_number('L_COST'),
1564: p_action_information25 => per_formula_functions.get_number('L_AMG'),
1565: p_action_information26 => per_formula_functions.get_number('L_CE'),
1566: p_action_information27 => per_formula_functions.get_text('M_SHARES'),
1567: p_action_information28 => per_formula_functions.get_number('H_CE1'),
1568: p_action_information29 => per_formula_functions.get_number('H_COUNT'),
1569: p_action_information30 => per_formula_functions.get_number('F_COUNT') );
1562: p_action_information23 => per_formula_functions.get_text('L_DESC'),
1563: p_action_information24 => per_formula_functions.get_number('L_COST'),
1564: p_action_information25 => per_formula_functions.get_number('L_AMG'),
1565: p_action_information26 => per_formula_functions.get_number('L_CE'),
1566: p_action_information27 => per_formula_functions.get_text('M_SHARES'),
1567: p_action_information28 => per_formula_functions.get_number('H_CE1'),
1568: p_action_information29 => per_formula_functions.get_number('H_COUNT'),
1569: p_action_information30 => per_formula_functions.get_number('F_COUNT') );
1570:
1563: p_action_information24 => per_formula_functions.get_number('L_COST'),
1564: p_action_information25 => per_formula_functions.get_number('L_AMG'),
1565: p_action_information26 => per_formula_functions.get_number('L_CE'),
1566: p_action_information27 => per_formula_functions.get_text('M_SHARES'),
1567: p_action_information28 => per_formula_functions.get_number('H_CE1'),
1568: p_action_information29 => per_formula_functions.get_number('H_COUNT'),
1569: p_action_information30 => per_formula_functions.get_number('F_COUNT') );
1570:
1571: --
1564: p_action_information25 => per_formula_functions.get_number('L_AMG'),
1565: p_action_information26 => per_formula_functions.get_number('L_CE'),
1566: p_action_information27 => per_formula_functions.get_text('M_SHARES'),
1567: p_action_information28 => per_formula_functions.get_number('H_CE1'),
1568: p_action_information29 => per_formula_functions.get_number('H_COUNT'),
1569: p_action_information30 => per_formula_functions.get_number('F_COUNT') );
1570:
1571: --
1572: pay_action_information_api.create_action_information(
1565: p_action_information26 => per_formula_functions.get_number('L_CE'),
1566: p_action_information27 => per_formula_functions.get_text('M_SHARES'),
1567: p_action_information28 => per_formula_functions.get_number('H_CE1'),
1568: p_action_information29 => per_formula_functions.get_number('H_COUNT'),
1569: p_action_information30 => per_formula_functions.get_number('F_COUNT') );
1570:
1571: --
1572: pay_action_information_api.create_action_information(
1573: p_action_information_id => l_action_info_id,
1577: p_effective_date => fnd_date.canonical_to_date(g_param_benefit_end_date),
1578: p_source_id => NULL,
1579: p_source_text => NULL,
1580: p_action_information_category => 'GB P11D ASSIGNMENT RESULTB',
1581: p_action_information1 => per_formula_functions.get_text('N_DESC'),
1582: p_action_information2 => per_formula_functions.get_number('N_COST'),
1583: p_action_information3 => per_formula_functions.get_number('N_AMG'),
1584: p_action_information4 => per_formula_functions.get_number('N_CE'),
1585: p_action_information5 => per_formula_functions.get_text('NA_DESC'),
1578: p_source_id => NULL,
1579: p_source_text => NULL,
1580: p_action_information_category => 'GB P11D ASSIGNMENT RESULTB',
1581: p_action_information1 => per_formula_functions.get_text('N_DESC'),
1582: p_action_information2 => per_formula_functions.get_number('N_COST'),
1583: p_action_information3 => per_formula_functions.get_number('N_AMG'),
1584: p_action_information4 => per_formula_functions.get_number('N_CE'),
1585: p_action_information5 => per_formula_functions.get_text('NA_DESC'),
1586: p_action_information6 => per_formula_functions.get_number('NA_COST'),
1579: p_source_text => NULL,
1580: p_action_information_category => 'GB P11D ASSIGNMENT RESULTB',
1581: p_action_information1 => per_formula_functions.get_text('N_DESC'),
1582: p_action_information2 => per_formula_functions.get_number('N_COST'),
1583: p_action_information3 => per_formula_functions.get_number('N_AMG'),
1584: p_action_information4 => per_formula_functions.get_number('N_CE'),
1585: p_action_information5 => per_formula_functions.get_text('NA_DESC'),
1586: p_action_information6 => per_formula_functions.get_number('NA_COST'),
1587: p_action_information7 => per_formula_functions.get_number('NA_AMG'),
1580: p_action_information_category => 'GB P11D ASSIGNMENT RESULTB',
1581: p_action_information1 => per_formula_functions.get_text('N_DESC'),
1582: p_action_information2 => per_formula_functions.get_number('N_COST'),
1583: p_action_information3 => per_formula_functions.get_number('N_AMG'),
1584: p_action_information4 => per_formula_functions.get_number('N_CE'),
1585: p_action_information5 => per_formula_functions.get_text('NA_DESC'),
1586: p_action_information6 => per_formula_functions.get_number('NA_COST'),
1587: p_action_information7 => per_formula_functions.get_number('NA_AMG'),
1588: p_action_information8 => per_formula_functions.get_number('NA_CE'),
1581: p_action_information1 => per_formula_functions.get_text('N_DESC'),
1582: p_action_information2 => per_formula_functions.get_number('N_COST'),
1583: p_action_information3 => per_formula_functions.get_number('N_AMG'),
1584: p_action_information4 => per_formula_functions.get_number('N_CE'),
1585: p_action_information5 => per_formula_functions.get_text('NA_DESC'),
1586: p_action_information6 => per_formula_functions.get_number('NA_COST'),
1587: p_action_information7 => per_formula_functions.get_number('NA_AMG'),
1588: p_action_information8 => per_formula_functions.get_number('NA_CE'),
1589: p_action_information9 => per_formula_functions.get_number('N_TAXPAID'),
1582: p_action_information2 => per_formula_functions.get_number('N_COST'),
1583: p_action_information3 => per_formula_functions.get_number('N_AMG'),
1584: p_action_information4 => per_formula_functions.get_number('N_CE'),
1585: p_action_information5 => per_formula_functions.get_text('NA_DESC'),
1586: p_action_information6 => per_formula_functions.get_number('NA_COST'),
1587: p_action_information7 => per_formula_functions.get_number('NA_AMG'),
1588: p_action_information8 => per_formula_functions.get_number('NA_CE'),
1589: p_action_information9 => per_formula_functions.get_number('N_TAXPAID'),
1590: p_action_information10 => per_formula_functions.get_number('O1_COST'),
1583: p_action_information3 => per_formula_functions.get_number('N_AMG'),
1584: p_action_information4 => per_formula_functions.get_number('N_CE'),
1585: p_action_information5 => per_formula_functions.get_text('NA_DESC'),
1586: p_action_information6 => per_formula_functions.get_number('NA_COST'),
1587: p_action_information7 => per_formula_functions.get_number('NA_AMG'),
1588: p_action_information8 => per_formula_functions.get_number('NA_CE'),
1589: p_action_information9 => per_formula_functions.get_number('N_TAXPAID'),
1590: p_action_information10 => per_formula_functions.get_number('O1_COST'),
1591: p_action_information11 => per_formula_functions.get_number('O1_AMG'),
1584: p_action_information4 => per_formula_functions.get_number('N_CE'),
1585: p_action_information5 => per_formula_functions.get_text('NA_DESC'),
1586: p_action_information6 => per_formula_functions.get_number('NA_COST'),
1587: p_action_information7 => per_formula_functions.get_number('NA_AMG'),
1588: p_action_information8 => per_formula_functions.get_number('NA_CE'),
1589: p_action_information9 => per_formula_functions.get_number('N_TAXPAID'),
1590: p_action_information10 => per_formula_functions.get_number('O1_COST'),
1591: p_action_information11 => per_formula_functions.get_number('O1_AMG'),
1592: p_action_information12 => per_formula_functions.get_number('O1_CE'),
1585: p_action_information5 => per_formula_functions.get_text('NA_DESC'),
1586: p_action_information6 => per_formula_functions.get_number('NA_COST'),
1587: p_action_information7 => per_formula_functions.get_number('NA_AMG'),
1588: p_action_information8 => per_formula_functions.get_number('NA_CE'),
1589: p_action_information9 => per_formula_functions.get_number('N_TAXPAID'),
1590: p_action_information10 => per_formula_functions.get_number('O1_COST'),
1591: p_action_information11 => per_formula_functions.get_number('O1_AMG'),
1592: p_action_information12 => per_formula_functions.get_number('O1_CE'),
1593: p_action_information13 => per_formula_functions.get_number('O2_COST'),
1586: p_action_information6 => per_formula_functions.get_number('NA_COST'),
1587: p_action_information7 => per_formula_functions.get_number('NA_AMG'),
1588: p_action_information8 => per_formula_functions.get_number('NA_CE'),
1589: p_action_information9 => per_formula_functions.get_number('N_TAXPAID'),
1590: p_action_information10 => per_formula_functions.get_number('O1_COST'),
1591: p_action_information11 => per_formula_functions.get_number('O1_AMG'),
1592: p_action_information12 => per_formula_functions.get_number('O1_CE'),
1593: p_action_information13 => per_formula_functions.get_number('O2_COST'),
1594: p_action_information14 => per_formula_functions.get_number('O2_AMG'),
1587: p_action_information7 => per_formula_functions.get_number('NA_AMG'),
1588: p_action_information8 => per_formula_functions.get_number('NA_CE'),
1589: p_action_information9 => per_formula_functions.get_number('N_TAXPAID'),
1590: p_action_information10 => per_formula_functions.get_number('O1_COST'),
1591: p_action_information11 => per_formula_functions.get_number('O1_AMG'),
1592: p_action_information12 => per_formula_functions.get_number('O1_CE'),
1593: p_action_information13 => per_formula_functions.get_number('O2_COST'),
1594: p_action_information14 => per_formula_functions.get_number('O2_AMG'),
1595: p_action_information15 => per_formula_functions.get_number('O2_CE'),
1588: p_action_information8 => per_formula_functions.get_number('NA_CE'),
1589: p_action_information9 => per_formula_functions.get_number('N_TAXPAID'),
1590: p_action_information10 => per_formula_functions.get_number('O1_COST'),
1591: p_action_information11 => per_formula_functions.get_number('O1_AMG'),
1592: p_action_information12 => per_formula_functions.get_number('O1_CE'),
1593: p_action_information13 => per_formula_functions.get_number('O2_COST'),
1594: p_action_information14 => per_formula_functions.get_number('O2_AMG'),
1595: p_action_information15 => per_formula_functions.get_number('O2_CE'),
1596: p_action_information16 => per_formula_functions.get_text('O_TOI'),
1589: p_action_information9 => per_formula_functions.get_number('N_TAXPAID'),
1590: p_action_information10 => per_formula_functions.get_number('O1_COST'),
1591: p_action_information11 => per_formula_functions.get_number('O1_AMG'),
1592: p_action_information12 => per_formula_functions.get_number('O1_CE'),
1593: p_action_information13 => per_formula_functions.get_number('O2_COST'),
1594: p_action_information14 => per_formula_functions.get_number('O2_AMG'),
1595: p_action_information15 => per_formula_functions.get_number('O2_CE'),
1596: p_action_information16 => per_formula_functions.get_text('O_TOI'),
1597: p_action_information17 => per_formula_functions.get_number('O3_COST'),
1590: p_action_information10 => per_formula_functions.get_number('O1_COST'),
1591: p_action_information11 => per_formula_functions.get_number('O1_AMG'),
1592: p_action_information12 => per_formula_functions.get_number('O1_CE'),
1593: p_action_information13 => per_formula_functions.get_number('O2_COST'),
1594: p_action_information14 => per_formula_functions.get_number('O2_AMG'),
1595: p_action_information15 => per_formula_functions.get_number('O2_CE'),
1596: p_action_information16 => per_formula_functions.get_text('O_TOI'),
1597: p_action_information17 => per_formula_functions.get_number('O3_COST'),
1598: p_action_information18 => per_formula_functions.get_number('O3_AMG'),
1591: p_action_information11 => per_formula_functions.get_number('O1_AMG'),
1592: p_action_information12 => per_formula_functions.get_number('O1_CE'),
1593: p_action_information13 => per_formula_functions.get_number('O2_COST'),
1594: p_action_information14 => per_formula_functions.get_number('O2_AMG'),
1595: p_action_information15 => per_formula_functions.get_number('O2_CE'),
1596: p_action_information16 => per_formula_functions.get_text('O_TOI'),
1597: p_action_information17 => per_formula_functions.get_number('O3_COST'),
1598: p_action_information18 => per_formula_functions.get_number('O3_AMG'),
1599: p_action_information19 => per_formula_functions.get_number('O3_CE'),
1592: p_action_information12 => per_formula_functions.get_number('O1_CE'),
1593: p_action_information13 => per_formula_functions.get_number('O2_COST'),
1594: p_action_information14 => per_formula_functions.get_number('O2_AMG'),
1595: p_action_information15 => per_formula_functions.get_number('O2_CE'),
1596: p_action_information16 => per_formula_functions.get_text('O_TOI'),
1597: p_action_information17 => per_formula_functions.get_number('O3_COST'),
1598: p_action_information18 => per_formula_functions.get_number('O3_AMG'),
1599: p_action_information19 => per_formula_functions.get_number('O3_CE'),
1600: p_action_information20 => per_formula_functions.get_number('O4_COST'),
1593: p_action_information13 => per_formula_functions.get_number('O2_COST'),
1594: p_action_information14 => per_formula_functions.get_number('O2_AMG'),
1595: p_action_information15 => per_formula_functions.get_number('O2_CE'),
1596: p_action_information16 => per_formula_functions.get_text('O_TOI'),
1597: p_action_information17 => per_formula_functions.get_number('O3_COST'),
1598: p_action_information18 => per_formula_functions.get_number('O3_AMG'),
1599: p_action_information19 => per_formula_functions.get_number('O3_CE'),
1600: p_action_information20 => per_formula_functions.get_number('O4_COST'),
1601: p_action_information21 => per_formula_functions.get_number('O4_AMG'),
1594: p_action_information14 => per_formula_functions.get_number('O2_AMG'),
1595: p_action_information15 => per_formula_functions.get_number('O2_CE'),
1596: p_action_information16 => per_formula_functions.get_text('O_TOI'),
1597: p_action_information17 => per_formula_functions.get_number('O3_COST'),
1598: p_action_information18 => per_formula_functions.get_number('O3_AMG'),
1599: p_action_information19 => per_formula_functions.get_number('O3_CE'),
1600: p_action_information20 => per_formula_functions.get_number('O4_COST'),
1601: p_action_information21 => per_formula_functions.get_number('O4_AMG'),
1602: p_action_information22 => per_formula_functions.get_number('O4_CE'),
1595: p_action_information15 => per_formula_functions.get_number('O2_CE'),
1596: p_action_information16 => per_formula_functions.get_text('O_TOI'),
1597: p_action_information17 => per_formula_functions.get_number('O3_COST'),
1598: p_action_information18 => per_formula_functions.get_number('O3_AMG'),
1599: p_action_information19 => per_formula_functions.get_number('O3_CE'),
1600: p_action_information20 => per_formula_functions.get_number('O4_COST'),
1601: p_action_information21 => per_formula_functions.get_number('O4_AMG'),
1602: p_action_information22 => per_formula_functions.get_number('O4_CE'),
1603: p_action_information23 => per_formula_functions.get_number('O5_COST'),
1596: p_action_information16 => per_formula_functions.get_text('O_TOI'),
1597: p_action_information17 => per_formula_functions.get_number('O3_COST'),
1598: p_action_information18 => per_formula_functions.get_number('O3_AMG'),
1599: p_action_information19 => per_formula_functions.get_number('O3_CE'),
1600: p_action_information20 => per_formula_functions.get_number('O4_COST'),
1601: p_action_information21 => per_formula_functions.get_number('O4_AMG'),
1602: p_action_information22 => per_formula_functions.get_number('O4_CE'),
1603: p_action_information23 => per_formula_functions.get_number('O5_COST'),
1604: p_action_information24 => per_formula_functions.get_number('O5_AMG'),
1597: p_action_information17 => per_formula_functions.get_number('O3_COST'),
1598: p_action_information18 => per_formula_functions.get_number('O3_AMG'),
1599: p_action_information19 => per_formula_functions.get_number('O3_CE'),
1600: p_action_information20 => per_formula_functions.get_number('O4_COST'),
1601: p_action_information21 => per_formula_functions.get_number('O4_AMG'),
1602: p_action_information22 => per_formula_functions.get_number('O4_CE'),
1603: p_action_information23 => per_formula_functions.get_number('O5_COST'),
1604: p_action_information24 => per_formula_functions.get_number('O5_AMG'),
1605: p_action_information25 => per_formula_functions.get_number('O5_CE'),
1598: p_action_information18 => per_formula_functions.get_number('O3_AMG'),
1599: p_action_information19 => per_formula_functions.get_number('O3_CE'),
1600: p_action_information20 => per_formula_functions.get_number('O4_COST'),
1601: p_action_information21 => per_formula_functions.get_number('O4_AMG'),
1602: p_action_information22 => per_formula_functions.get_number('O4_CE'),
1603: p_action_information23 => per_formula_functions.get_number('O5_COST'),
1604: p_action_information24 => per_formula_functions.get_number('O5_AMG'),
1605: p_action_information25 => per_formula_functions.get_number('O5_CE'),
1606: p_action_information26 => per_formula_functions.get_text('O6_DESC'),
1599: p_action_information19 => per_formula_functions.get_number('O3_CE'),
1600: p_action_information20 => per_formula_functions.get_number('O4_COST'),
1601: p_action_information21 => per_formula_functions.get_number('O4_AMG'),
1602: p_action_information22 => per_formula_functions.get_number('O4_CE'),
1603: p_action_information23 => per_formula_functions.get_number('O5_COST'),
1604: p_action_information24 => per_formula_functions.get_number('O5_AMG'),
1605: p_action_information25 => per_formula_functions.get_number('O5_CE'),
1606: p_action_information26 => per_formula_functions.get_text('O6_DESC'),
1607: p_action_information27 => per_formula_functions.get_number('O6_COST'),
1600: p_action_information20 => per_formula_functions.get_number('O4_COST'),
1601: p_action_information21 => per_formula_functions.get_number('O4_AMG'),
1602: p_action_information22 => per_formula_functions.get_number('O4_CE'),
1603: p_action_information23 => per_formula_functions.get_number('O5_COST'),
1604: p_action_information24 => per_formula_functions.get_number('O5_AMG'),
1605: p_action_information25 => per_formula_functions.get_number('O5_CE'),
1606: p_action_information26 => per_formula_functions.get_text('O6_DESC'),
1607: p_action_information27 => per_formula_functions.get_number('O6_COST'),
1608: p_action_information28 => per_formula_functions.get_number('O6_AMG'),
1601: p_action_information21 => per_formula_functions.get_number('O4_AMG'),
1602: p_action_information22 => per_formula_functions.get_number('O4_CE'),
1603: p_action_information23 => per_formula_functions.get_number('O5_COST'),
1604: p_action_information24 => per_formula_functions.get_number('O5_AMG'),
1605: p_action_information25 => per_formula_functions.get_number('O5_CE'),
1606: p_action_information26 => per_formula_functions.get_text('O6_DESC'),
1607: p_action_information27 => per_formula_functions.get_number('O6_COST'),
1608: p_action_information28 => per_formula_functions.get_number('O6_AMG'),
1609: p_action_information29 => per_formula_functions.get_number('O6_CE') );
1602: p_action_information22 => per_formula_functions.get_number('O4_CE'),
1603: p_action_information23 => per_formula_functions.get_number('O5_COST'),
1604: p_action_information24 => per_formula_functions.get_number('O5_AMG'),
1605: p_action_information25 => per_formula_functions.get_number('O5_CE'),
1606: p_action_information26 => per_formula_functions.get_text('O6_DESC'),
1607: p_action_information27 => per_formula_functions.get_number('O6_COST'),
1608: p_action_information28 => per_formula_functions.get_number('O6_AMG'),
1609: p_action_information29 => per_formula_functions.get_number('O6_CE') );
1610:
1603: p_action_information23 => per_formula_functions.get_number('O5_COST'),
1604: p_action_information24 => per_formula_functions.get_number('O5_AMG'),
1605: p_action_information25 => per_formula_functions.get_number('O5_CE'),
1606: p_action_information26 => per_formula_functions.get_text('O6_DESC'),
1607: p_action_information27 => per_formula_functions.get_number('O6_COST'),
1608: p_action_information28 => per_formula_functions.get_number('O6_AMG'),
1609: p_action_information29 => per_formula_functions.get_number('O6_CE') );
1610:
1611: --
1604: p_action_information24 => per_formula_functions.get_number('O5_AMG'),
1605: p_action_information25 => per_formula_functions.get_number('O5_CE'),
1606: p_action_information26 => per_formula_functions.get_text('O6_DESC'),
1607: p_action_information27 => per_formula_functions.get_number('O6_COST'),
1608: p_action_information28 => per_formula_functions.get_number('O6_AMG'),
1609: p_action_information29 => per_formula_functions.get_number('O6_CE') );
1610:
1611: --
1612: pay_action_information_api.create_action_information(
1605: p_action_information25 => per_formula_functions.get_number('O5_CE'),
1606: p_action_information26 => per_formula_functions.get_text('O6_DESC'),
1607: p_action_information27 => per_formula_functions.get_number('O6_COST'),
1608: p_action_information28 => per_formula_functions.get_number('O6_AMG'),
1609: p_action_information29 => per_formula_functions.get_number('O6_CE') );
1610:
1611: --
1612: pay_action_information_api.create_action_information(
1613: p_action_information_id => l_action_info_id,
1617: p_effective_date => fnd_date.canonical_to_date(g_param_benefit_end_date),
1618: p_source_id => NULL,
1619: p_source_text => NULL,
1620: p_action_information_category => 'GB P11D ASSIGNMENT RESULTC',
1621: p_action_information1 => per_formula_functions.get_number('C_BUS_MILES'),
1622: p_action_information2 => per_formula_functions.get_number('M_BUS_MILES'),
1623: p_action_information3 => per_formula_functions.get_number('B_BUS_MILES'),
1624: p_action_information4 => per_formula_functions.get_number('C_RATE1'),
1625: p_action_information5 => per_formula_functions.get_number('C_RATE2'),
1618: p_source_id => NULL,
1619: p_source_text => NULL,
1620: p_action_information_category => 'GB P11D ASSIGNMENT RESULTC',
1621: p_action_information1 => per_formula_functions.get_number('C_BUS_MILES'),
1622: p_action_information2 => per_formula_functions.get_number('M_BUS_MILES'),
1623: p_action_information3 => per_formula_functions.get_number('B_BUS_MILES'),
1624: p_action_information4 => per_formula_functions.get_number('C_RATE1'),
1625: p_action_information5 => per_formula_functions.get_number('C_RATE2'),
1626: p_action_information6 => per_formula_functions.get_number('M_RATE1'),
1619: p_source_text => NULL,
1620: p_action_information_category => 'GB P11D ASSIGNMENT RESULTC',
1621: p_action_information1 => per_formula_functions.get_number('C_BUS_MILES'),
1622: p_action_information2 => per_formula_functions.get_number('M_BUS_MILES'),
1623: p_action_information3 => per_formula_functions.get_number('B_BUS_MILES'),
1624: p_action_information4 => per_formula_functions.get_number('C_RATE1'),
1625: p_action_information5 => per_formula_functions.get_number('C_RATE2'),
1626: p_action_information6 => per_formula_functions.get_number('M_RATE1'),
1627: p_action_information7 => per_formula_functions.get_number('M_RATE2'),
1620: p_action_information_category => 'GB P11D ASSIGNMENT RESULTC',
1621: p_action_information1 => per_formula_functions.get_number('C_BUS_MILES'),
1622: p_action_information2 => per_formula_functions.get_number('M_BUS_MILES'),
1623: p_action_information3 => per_formula_functions.get_number('B_BUS_MILES'),
1624: p_action_information4 => per_formula_functions.get_number('C_RATE1'),
1625: p_action_information5 => per_formula_functions.get_number('C_RATE2'),
1626: p_action_information6 => per_formula_functions.get_number('M_RATE1'),
1627: p_action_information7 => per_formula_functions.get_number('M_RATE2'),
1628: p_action_information8 => per_formula_functions.get_number('B_RATE1'),
1621: p_action_information1 => per_formula_functions.get_number('C_BUS_MILES'),
1622: p_action_information2 => per_formula_functions.get_number('M_BUS_MILES'),
1623: p_action_information3 => per_formula_functions.get_number('B_BUS_MILES'),
1624: p_action_information4 => per_formula_functions.get_number('C_RATE1'),
1625: p_action_information5 => per_formula_functions.get_number('C_RATE2'),
1626: p_action_information6 => per_formula_functions.get_number('M_RATE1'),
1627: p_action_information7 => per_formula_functions.get_number('M_RATE2'),
1628: p_action_information8 => per_formula_functions.get_number('B_RATE1'),
1629: p_action_information9 => per_formula_functions.get_number('B_RATE2'),
1622: p_action_information2 => per_formula_functions.get_number('M_BUS_MILES'),
1623: p_action_information3 => per_formula_functions.get_number('B_BUS_MILES'),
1624: p_action_information4 => per_formula_functions.get_number('C_RATE1'),
1625: p_action_information5 => per_formula_functions.get_number('C_RATE2'),
1626: p_action_information6 => per_formula_functions.get_number('M_RATE1'),
1627: p_action_information7 => per_formula_functions.get_number('M_RATE2'),
1628: p_action_information8 => per_formula_functions.get_number('B_RATE1'),
1629: p_action_information9 => per_formula_functions.get_number('B_RATE2'),
1630: p_action_information10 => per_formula_functions.get_text('DT_FREE_FUEL_WITHDRAWN'),
1623: p_action_information3 => per_formula_functions.get_number('B_BUS_MILES'),
1624: p_action_information4 => per_formula_functions.get_number('C_RATE1'),
1625: p_action_information5 => per_formula_functions.get_number('C_RATE2'),
1626: p_action_information6 => per_formula_functions.get_number('M_RATE1'),
1627: p_action_information7 => per_formula_functions.get_number('M_RATE2'),
1628: p_action_information8 => per_formula_functions.get_number('B_RATE1'),
1629: p_action_information9 => per_formula_functions.get_number('B_RATE2'),
1630: p_action_information10 => per_formula_functions.get_text('DT_FREE_FUEL_WITHDRAWN'),
1631: p_action_information11 => per_formula_functions.get_text('FREE_FUEL_REINSTATED'),
1624: p_action_information4 => per_formula_functions.get_number('C_RATE1'),
1625: p_action_information5 => per_formula_functions.get_number('C_RATE2'),
1626: p_action_information6 => per_formula_functions.get_number('M_RATE1'),
1627: p_action_information7 => per_formula_functions.get_number('M_RATE2'),
1628: p_action_information8 => per_formula_functions.get_number('B_RATE1'),
1629: p_action_information9 => per_formula_functions.get_number('B_RATE2'),
1630: p_action_information10 => per_formula_functions.get_text('DT_FREE_FUEL_WITHDRAWN'),
1631: p_action_information11 => per_formula_functions.get_text('FREE_FUEL_REINSTATED'),
1632: p_action_information12 => per_formula_functions.get_number('C_MILEAGE_PAYMENTS'),
1625: p_action_information5 => per_formula_functions.get_number('C_RATE2'),
1626: p_action_information6 => per_formula_functions.get_number('M_RATE1'),
1627: p_action_information7 => per_formula_functions.get_number('M_RATE2'),
1628: p_action_information8 => per_formula_functions.get_number('B_RATE1'),
1629: p_action_information9 => per_formula_functions.get_number('B_RATE2'),
1630: p_action_information10 => per_formula_functions.get_text('DT_FREE_FUEL_WITHDRAWN'),
1631: p_action_information11 => per_formula_functions.get_text('FREE_FUEL_REINSTATED'),
1632: p_action_information12 => per_formula_functions.get_number('C_MILEAGE_PAYMENTS'),
1633: p_action_information13 => per_formula_functions.get_number('B_MILEAGE_PAYMENTS'),
1626: p_action_information6 => per_formula_functions.get_number('M_RATE1'),
1627: p_action_information7 => per_formula_functions.get_number('M_RATE2'),
1628: p_action_information8 => per_formula_functions.get_number('B_RATE1'),
1629: p_action_information9 => per_formula_functions.get_number('B_RATE2'),
1630: p_action_information10 => per_formula_functions.get_text('DT_FREE_FUEL_WITHDRAWN'),
1631: p_action_information11 => per_formula_functions.get_text('FREE_FUEL_REINSTATED'),
1632: p_action_information12 => per_formula_functions.get_number('C_MILEAGE_PAYMENTS'),
1633: p_action_information13 => per_formula_functions.get_number('B_MILEAGE_PAYMENTS'),
1634: p_action_information14 => per_formula_functions.get_number('M_MILEAGE_PAYMENTS'),
1627: p_action_information7 => per_formula_functions.get_number('M_RATE2'),
1628: p_action_information8 => per_formula_functions.get_number('B_RATE1'),
1629: p_action_information9 => per_formula_functions.get_number('B_RATE2'),
1630: p_action_information10 => per_formula_functions.get_text('DT_FREE_FUEL_WITHDRAWN'),
1631: p_action_information11 => per_formula_functions.get_text('FREE_FUEL_REINSTATED'),
1632: p_action_information12 => per_formula_functions.get_number('C_MILEAGE_PAYMENTS'),
1633: p_action_information13 => per_formula_functions.get_number('B_MILEAGE_PAYMENTS'),
1634: p_action_information14 => per_formula_functions.get_number('M_MILEAGE_PAYMENTS'),
1635: p_action_information15 => per_formula_functions.get_number('MARORS_COUNT'),
1628: p_action_information8 => per_formula_functions.get_number('B_RATE1'),
1629: p_action_information9 => per_formula_functions.get_number('B_RATE2'),
1630: p_action_information10 => per_formula_functions.get_text('DT_FREE_FUEL_WITHDRAWN'),
1631: p_action_information11 => per_formula_functions.get_text('FREE_FUEL_REINSTATED'),
1632: p_action_information12 => per_formula_functions.get_number('C_MILEAGE_PAYMENTS'),
1633: p_action_information13 => per_formula_functions.get_number('B_MILEAGE_PAYMENTS'),
1634: p_action_information14 => per_formula_functions.get_number('M_MILEAGE_PAYMENTS'),
1635: p_action_information15 => per_formula_functions.get_number('MARORS_COUNT'),
1636: p_action_information16 => per_formula_functions.get_number('C_TAX_DEDUCTED'),
1629: p_action_information9 => per_formula_functions.get_number('B_RATE2'),
1630: p_action_information10 => per_formula_functions.get_text('DT_FREE_FUEL_WITHDRAWN'),
1631: p_action_information11 => per_formula_functions.get_text('FREE_FUEL_REINSTATED'),
1632: p_action_information12 => per_formula_functions.get_number('C_MILEAGE_PAYMENTS'),
1633: p_action_information13 => per_formula_functions.get_number('B_MILEAGE_PAYMENTS'),
1634: p_action_information14 => per_formula_functions.get_number('M_MILEAGE_PAYMENTS'),
1635: p_action_information15 => per_formula_functions.get_number('MARORS_COUNT'),
1636: p_action_information16 => per_formula_functions.get_number('C_TAX_DEDUCTED'),
1637: p_action_information17 => per_formula_functions.get_number('B_TAX_DEDUCTED'),
1630: p_action_information10 => per_formula_functions.get_text('DT_FREE_FUEL_WITHDRAWN'),
1631: p_action_information11 => per_formula_functions.get_text('FREE_FUEL_REINSTATED'),
1632: p_action_information12 => per_formula_functions.get_number('C_MILEAGE_PAYMENTS'),
1633: p_action_information13 => per_formula_functions.get_number('B_MILEAGE_PAYMENTS'),
1634: p_action_information14 => per_formula_functions.get_number('M_MILEAGE_PAYMENTS'),
1635: p_action_information15 => per_formula_functions.get_number('MARORS_COUNT'),
1636: p_action_information16 => per_formula_functions.get_number('C_TAX_DEDUCTED'),
1637: p_action_information17 => per_formula_functions.get_number('B_TAX_DEDUCTED'),
1638: p_action_information18 => per_formula_functions.get_number('M_TAX_DEDUCTED'),
1631: p_action_information11 => per_formula_functions.get_text('FREE_FUEL_REINSTATED'),
1632: p_action_information12 => per_formula_functions.get_number('C_MILEAGE_PAYMENTS'),
1633: p_action_information13 => per_formula_functions.get_number('B_MILEAGE_PAYMENTS'),
1634: p_action_information14 => per_formula_functions.get_number('M_MILEAGE_PAYMENTS'),
1635: p_action_information15 => per_formula_functions.get_number('MARORS_COUNT'),
1636: p_action_information16 => per_formula_functions.get_number('C_TAX_DEDUCTED'),
1637: p_action_information17 => per_formula_functions.get_number('B_TAX_DEDUCTED'),
1638: p_action_information18 => per_formula_functions.get_number('M_TAX_DEDUCTED'),
1639: p_action_information19 => per_formula_functions.get_number('PASSENGER_PAYMENTS'),
1632: p_action_information12 => per_formula_functions.get_number('C_MILEAGE_PAYMENTS'),
1633: p_action_information13 => per_formula_functions.get_number('B_MILEAGE_PAYMENTS'),
1634: p_action_information14 => per_formula_functions.get_number('M_MILEAGE_PAYMENTS'),
1635: p_action_information15 => per_formula_functions.get_number('MARORS_COUNT'),
1636: p_action_information16 => per_formula_functions.get_number('C_TAX_DEDUCTED'),
1637: p_action_information17 => per_formula_functions.get_number('B_TAX_DEDUCTED'),
1638: p_action_information18 => per_formula_functions.get_number('M_TAX_DEDUCTED'),
1639: p_action_information19 => per_formula_functions.get_number('PASSENGER_PAYMENTS'),
1640: p_action_information20 => per_formula_functions.get_number('PASSENGER_BUS_MILES'),
1633: p_action_information13 => per_formula_functions.get_number('B_MILEAGE_PAYMENTS'),
1634: p_action_information14 => per_formula_functions.get_number('M_MILEAGE_PAYMENTS'),
1635: p_action_information15 => per_formula_functions.get_number('MARORS_COUNT'),
1636: p_action_information16 => per_formula_functions.get_number('C_TAX_DEDUCTED'),
1637: p_action_information17 => per_formula_functions.get_number('B_TAX_DEDUCTED'),
1638: p_action_information18 => per_formula_functions.get_number('M_TAX_DEDUCTED'),
1639: p_action_information19 => per_formula_functions.get_number('PASSENGER_PAYMENTS'),
1640: p_action_information20 => per_formula_functions.get_number('PASSENGER_BUS_MILES'),
1641: p_action_information21 => per_formula_functions.get_number('PASSENGER_BUS_MILE_AMT'),
1634: p_action_information14 => per_formula_functions.get_number('M_MILEAGE_PAYMENTS'),
1635: p_action_information15 => per_formula_functions.get_number('MARORS_COUNT'),
1636: p_action_information16 => per_formula_functions.get_number('C_TAX_DEDUCTED'),
1637: p_action_information17 => per_formula_functions.get_number('B_TAX_DEDUCTED'),
1638: p_action_information18 => per_formula_functions.get_number('M_TAX_DEDUCTED'),
1639: p_action_information19 => per_formula_functions.get_number('PASSENGER_PAYMENTS'),
1640: p_action_information20 => per_formula_functions.get_number('PASSENGER_BUS_MILES'),
1641: p_action_information21 => per_formula_functions.get_number('PASSENGER_BUS_MILE_AMT'),
1642: p_action_information22 => per_formula_functions.get_number('MILEAGE_ALLOWANCE_RELIEF'),
1635: p_action_information15 => per_formula_functions.get_number('MARORS_COUNT'),
1636: p_action_information16 => per_formula_functions.get_number('C_TAX_DEDUCTED'),
1637: p_action_information17 => per_formula_functions.get_number('B_TAX_DEDUCTED'),
1638: p_action_information18 => per_formula_functions.get_number('M_TAX_DEDUCTED'),
1639: p_action_information19 => per_formula_functions.get_number('PASSENGER_PAYMENTS'),
1640: p_action_information20 => per_formula_functions.get_number('PASSENGER_BUS_MILES'),
1641: p_action_information21 => per_formula_functions.get_number('PASSENGER_BUS_MILE_AMT'),
1642: p_action_information22 => per_formula_functions.get_number('MILEAGE_ALLOWANCE_RELIEF'),
1643: p_action_information23 => per_formula_functions.get_number('INT_MAX_AMT_OUTSTANDING')
1636: p_action_information16 => per_formula_functions.get_number('C_TAX_DEDUCTED'),
1637: p_action_information17 => per_formula_functions.get_number('B_TAX_DEDUCTED'),
1638: p_action_information18 => per_formula_functions.get_number('M_TAX_DEDUCTED'),
1639: p_action_information19 => per_formula_functions.get_number('PASSENGER_PAYMENTS'),
1640: p_action_information20 => per_formula_functions.get_number('PASSENGER_BUS_MILES'),
1641: p_action_information21 => per_formula_functions.get_number('PASSENGER_BUS_MILE_AMT'),
1642: p_action_information22 => per_formula_functions.get_number('MILEAGE_ALLOWANCE_RELIEF'),
1643: p_action_information23 => per_formula_functions.get_number('INT_MAX_AMT_OUTSTANDING')
1644: );
1637: p_action_information17 => per_formula_functions.get_number('B_TAX_DEDUCTED'),
1638: p_action_information18 => per_formula_functions.get_number('M_TAX_DEDUCTED'),
1639: p_action_information19 => per_formula_functions.get_number('PASSENGER_PAYMENTS'),
1640: p_action_information20 => per_formula_functions.get_number('PASSENGER_BUS_MILES'),
1641: p_action_information21 => per_formula_functions.get_number('PASSENGER_BUS_MILE_AMT'),
1642: p_action_information22 => per_formula_functions.get_number('MILEAGE_ALLOWANCE_RELIEF'),
1643: p_action_information23 => per_formula_functions.get_number('INT_MAX_AMT_OUTSTANDING')
1644: );
1645: else
1638: p_action_information18 => per_formula_functions.get_number('M_TAX_DEDUCTED'),
1639: p_action_information19 => per_formula_functions.get_number('PASSENGER_PAYMENTS'),
1640: p_action_information20 => per_formula_functions.get_number('PASSENGER_BUS_MILES'),
1641: p_action_information21 => per_formula_functions.get_number('PASSENGER_BUS_MILE_AMT'),
1642: p_action_information22 => per_formula_functions.get_number('MILEAGE_ALLOWANCE_RELIEF'),
1643: p_action_information23 => per_formula_functions.get_number('INT_MAX_AMT_OUTSTANDING')
1644: );
1645: else
1646: /* Code for year 04/05 onward */
1639: p_action_information19 => per_formula_functions.get_number('PASSENGER_PAYMENTS'),
1640: p_action_information20 => per_formula_functions.get_number('PASSENGER_BUS_MILES'),
1641: p_action_information21 => per_formula_functions.get_number('PASSENGER_BUS_MILE_AMT'),
1642: p_action_information22 => per_formula_functions.get_number('MILEAGE_ALLOWANCE_RELIEF'),
1643: p_action_information23 => per_formula_functions.get_number('INT_MAX_AMT_OUTSTANDING')
1644: );
1645: else
1646: /* Code for year 04/05 onward */
1647: pay_action_information_api.create_action_information(
1652: p_effective_date => fnd_date.canonical_to_date(g_param_benefit_end_date),
1653: p_source_id => NULL,
1654: p_source_text => NULL,
1655: p_action_information_category => 'GB P11D ASSIGNMENT RESULTA',
1656: p_action_information1 => per_formula_functions.get_text('A_DESC'),
1657: p_action_information2 => per_formula_functions.get_number('A_COST'),
1658: p_action_information3 => per_formula_functions.get_number('A_AMG'),
1659: p_action_information4 => per_formula_functions.get_number('A_CE'),
1660: p_action_information5 => per_formula_functions.get_text('B_DESC'),
1653: p_source_id => NULL,
1654: p_source_text => NULL,
1655: p_action_information_category => 'GB P11D ASSIGNMENT RESULTA',
1656: p_action_information1 => per_formula_functions.get_text('A_DESC'),
1657: p_action_information2 => per_formula_functions.get_number('A_COST'),
1658: p_action_information3 => per_formula_functions.get_number('A_AMG'),
1659: p_action_information4 => per_formula_functions.get_number('A_CE'),
1660: p_action_information5 => per_formula_functions.get_text('B_DESC'),
1661: p_action_information6 => per_formula_functions.get_number('B_CE'),
1654: p_source_text => NULL,
1655: p_action_information_category => 'GB P11D ASSIGNMENT RESULTA',
1656: p_action_information1 => per_formula_functions.get_text('A_DESC'),
1657: p_action_information2 => per_formula_functions.get_number('A_COST'),
1658: p_action_information3 => per_formula_functions.get_number('A_AMG'),
1659: p_action_information4 => per_formula_functions.get_number('A_CE'),
1660: p_action_information5 => per_formula_functions.get_text('B_DESC'),
1661: p_action_information6 => per_formula_functions.get_number('B_CE'),
1662: p_action_information7 => per_formula_functions.get_number('B_TNP'),
1655: p_action_information_category => 'GB P11D ASSIGNMENT RESULTA',
1656: p_action_information1 => per_formula_functions.get_text('A_DESC'),
1657: p_action_information2 => per_formula_functions.get_number('A_COST'),
1658: p_action_information3 => per_formula_functions.get_number('A_AMG'),
1659: p_action_information4 => per_formula_functions.get_number('A_CE'),
1660: p_action_information5 => per_formula_functions.get_text('B_DESC'),
1661: p_action_information6 => per_formula_functions.get_number('B_CE'),
1662: p_action_information7 => per_formula_functions.get_number('B_TNP'),
1663: p_action_information8 => per_formula_functions.get_number('C_COST'),
1656: p_action_information1 => per_formula_functions.get_text('A_DESC'),
1657: p_action_information2 => per_formula_functions.get_number('A_COST'),
1658: p_action_information3 => per_formula_functions.get_number('A_AMG'),
1659: p_action_information4 => per_formula_functions.get_number('A_CE'),
1660: p_action_information5 => per_formula_functions.get_text('B_DESC'),
1661: p_action_information6 => per_formula_functions.get_number('B_CE'),
1662: p_action_information7 => per_formula_functions.get_number('B_TNP'),
1663: p_action_information8 => per_formula_functions.get_number('C_COST'),
1664: p_action_information9 => per_formula_functions.get_number('C_AMG'),
1657: p_action_information2 => per_formula_functions.get_number('A_COST'),
1658: p_action_information3 => per_formula_functions.get_number('A_AMG'),
1659: p_action_information4 => per_formula_functions.get_number('A_CE'),
1660: p_action_information5 => per_formula_functions.get_text('B_DESC'),
1661: p_action_information6 => per_formula_functions.get_number('B_CE'),
1662: p_action_information7 => per_formula_functions.get_number('B_TNP'),
1663: p_action_information8 => per_formula_functions.get_number('C_COST'),
1664: p_action_information9 => per_formula_functions.get_number('C_AMG'),
1665: p_action_information10 => per_formula_functions.get_number('C_CE'),
1658: p_action_information3 => per_formula_functions.get_number('A_AMG'),
1659: p_action_information4 => per_formula_functions.get_number('A_CE'),
1660: p_action_information5 => per_formula_functions.get_text('B_DESC'),
1661: p_action_information6 => per_formula_functions.get_number('B_CE'),
1662: p_action_information7 => per_formula_functions.get_number('B_TNP'),
1663: p_action_information8 => per_formula_functions.get_number('C_COST'),
1664: p_action_information9 => per_formula_functions.get_number('C_AMG'),
1665: p_action_information10 => per_formula_functions.get_number('C_CE'),
1666: p_action_information11 => per_formula_functions.get_number('D_CE'),
1659: p_action_information4 => per_formula_functions.get_number('A_CE'),
1660: p_action_information5 => per_formula_functions.get_text('B_DESC'),
1661: p_action_information6 => per_formula_functions.get_number('B_CE'),
1662: p_action_information7 => per_formula_functions.get_number('B_TNP'),
1663: p_action_information8 => per_formula_functions.get_number('C_COST'),
1664: p_action_information9 => per_formula_functions.get_number('C_AMG'),
1665: p_action_information10 => per_formula_functions.get_number('C_CE'),
1666: p_action_information11 => per_formula_functions.get_number('D_CE'),
1667: p_action_information12 => calculate_amap_ce ,
1660: p_action_information5 => per_formula_functions.get_text('B_DESC'),
1661: p_action_information6 => per_formula_functions.get_number('B_CE'),
1662: p_action_information7 => per_formula_functions.get_number('B_TNP'),
1663: p_action_information8 => per_formula_functions.get_number('C_COST'),
1664: p_action_information9 => per_formula_functions.get_number('C_AMG'),
1665: p_action_information10 => per_formula_functions.get_number('C_CE'),
1666: p_action_information11 => per_formula_functions.get_number('D_CE'),
1667: p_action_information12 => calculate_amap_ce ,
1668: p_action_information13 => per_formula_functions.get_number('F_TCCE'),
1661: p_action_information6 => per_formula_functions.get_number('B_CE'),
1662: p_action_information7 => per_formula_functions.get_number('B_TNP'),
1663: p_action_information8 => per_formula_functions.get_number('C_COST'),
1664: p_action_information9 => per_formula_functions.get_number('C_AMG'),
1665: p_action_information10 => per_formula_functions.get_number('C_CE'),
1666: p_action_information11 => per_formula_functions.get_number('D_CE'),
1667: p_action_information12 => calculate_amap_ce ,
1668: p_action_information13 => per_formula_functions.get_number('F_TCCE'),
1669: p_action_information14 => per_formula_functions.get_number('F_TFCE'),
1662: p_action_information7 => per_formula_functions.get_number('B_TNP'),
1663: p_action_information8 => per_formula_functions.get_number('C_COST'),
1664: p_action_information9 => per_formula_functions.get_number('C_AMG'),
1665: p_action_information10 => per_formula_functions.get_number('C_CE'),
1666: p_action_information11 => per_formula_functions.get_number('D_CE'),
1667: p_action_information12 => calculate_amap_ce ,
1668: p_action_information13 => per_formula_functions.get_number('F_TCCE'),
1669: p_action_information14 => per_formula_functions.get_number('F_TFCE'),
1670: p_action_information15 => per_formula_functions.get_number('G_CE'),
1664: p_action_information9 => per_formula_functions.get_number('C_AMG'),
1665: p_action_information10 => per_formula_functions.get_number('C_CE'),
1666: p_action_information11 => per_formula_functions.get_number('D_CE'),
1667: p_action_information12 => calculate_amap_ce ,
1668: p_action_information13 => per_formula_functions.get_number('F_TCCE'),
1669: p_action_information14 => per_formula_functions.get_number('F_TFCE'),
1670: p_action_information15 => per_formula_functions.get_number('G_CE'),
1671: p_action_information16 => per_formula_functions.get_number('I_COST'),
1672: p_action_information17 => per_formula_functions.get_number('I_AMG'),
1665: p_action_information10 => per_formula_functions.get_number('C_CE'),
1666: p_action_information11 => per_formula_functions.get_number('D_CE'),
1667: p_action_information12 => calculate_amap_ce ,
1668: p_action_information13 => per_formula_functions.get_number('F_TCCE'),
1669: p_action_information14 => per_formula_functions.get_number('F_TFCE'),
1670: p_action_information15 => per_formula_functions.get_number('G_CE'),
1671: p_action_information16 => per_formula_functions.get_number('I_COST'),
1672: p_action_information17 => per_formula_functions.get_number('I_AMG'),
1673: p_action_information18 => per_formula_functions.get_number('I_CE'),
1666: p_action_information11 => per_formula_functions.get_number('D_CE'),
1667: p_action_information12 => calculate_amap_ce ,
1668: p_action_information13 => per_formula_functions.get_number('F_TCCE'),
1669: p_action_information14 => per_formula_functions.get_number('F_TFCE'),
1670: p_action_information15 => per_formula_functions.get_number('G_CE'),
1671: p_action_information16 => per_formula_functions.get_number('I_COST'),
1672: p_action_information17 => per_formula_functions.get_number('I_AMG'),
1673: p_action_information18 => per_formula_functions.get_number('I_CE'),
1674: p_action_information19 => per_formula_functions.get_number('J_CE'),
1667: p_action_information12 => calculate_amap_ce ,
1668: p_action_information13 => per_formula_functions.get_number('F_TCCE'),
1669: p_action_information14 => per_formula_functions.get_number('F_TFCE'),
1670: p_action_information15 => per_formula_functions.get_number('G_CE'),
1671: p_action_information16 => per_formula_functions.get_number('I_COST'),
1672: p_action_information17 => per_formula_functions.get_number('I_AMG'),
1673: p_action_information18 => per_formula_functions.get_number('I_CE'),
1674: p_action_information19 => per_formula_functions.get_number('J_CE'),
1675: p_action_information20 => per_formula_functions.get_number('K_COST'),
1668: p_action_information13 => per_formula_functions.get_number('F_TCCE'),
1669: p_action_information14 => per_formula_functions.get_number('F_TFCE'),
1670: p_action_information15 => per_formula_functions.get_number('G_CE'),
1671: p_action_information16 => per_formula_functions.get_number('I_COST'),
1672: p_action_information17 => per_formula_functions.get_number('I_AMG'),
1673: p_action_information18 => per_formula_functions.get_number('I_CE'),
1674: p_action_information19 => per_formula_functions.get_number('J_CE'),
1675: p_action_information20 => per_formula_functions.get_number('K_COST'),
1676: p_action_information21 => per_formula_functions.get_number('K_AMG'),
1669: p_action_information14 => per_formula_functions.get_number('F_TFCE'),
1670: p_action_information15 => per_formula_functions.get_number('G_CE'),
1671: p_action_information16 => per_formula_functions.get_number('I_COST'),
1672: p_action_information17 => per_formula_functions.get_number('I_AMG'),
1673: p_action_information18 => per_formula_functions.get_number('I_CE'),
1674: p_action_information19 => per_formula_functions.get_number('J_CE'),
1675: p_action_information20 => per_formula_functions.get_number('K_COST'),
1676: p_action_information21 => per_formula_functions.get_number('K_AMG'),
1677: p_action_information22 => per_formula_functions.get_number('K_CE'),
1670: p_action_information15 => per_formula_functions.get_number('G_CE'),
1671: p_action_information16 => per_formula_functions.get_number('I_COST'),
1672: p_action_information17 => per_formula_functions.get_number('I_AMG'),
1673: p_action_information18 => per_formula_functions.get_number('I_CE'),
1674: p_action_information19 => per_formula_functions.get_number('J_CE'),
1675: p_action_information20 => per_formula_functions.get_number('K_COST'),
1676: p_action_information21 => per_formula_functions.get_number('K_AMG'),
1677: p_action_information22 => per_formula_functions.get_number('K_CE'),
1678: p_action_information23 => per_formula_functions.get_text('L_DESC'),
1671: p_action_information16 => per_formula_functions.get_number('I_COST'),
1672: p_action_information17 => per_formula_functions.get_number('I_AMG'),
1673: p_action_information18 => per_formula_functions.get_number('I_CE'),
1674: p_action_information19 => per_formula_functions.get_number('J_CE'),
1675: p_action_information20 => per_formula_functions.get_number('K_COST'),
1676: p_action_information21 => per_formula_functions.get_number('K_AMG'),
1677: p_action_information22 => per_formula_functions.get_number('K_CE'),
1678: p_action_information23 => per_formula_functions.get_text('L_DESC'),
1679: p_action_information24 => per_formula_functions.get_number('L_COST'),
1672: p_action_information17 => per_formula_functions.get_number('I_AMG'),
1673: p_action_information18 => per_formula_functions.get_number('I_CE'),
1674: p_action_information19 => per_formula_functions.get_number('J_CE'),
1675: p_action_information20 => per_formula_functions.get_number('K_COST'),
1676: p_action_information21 => per_formula_functions.get_number('K_AMG'),
1677: p_action_information22 => per_formula_functions.get_number('K_CE'),
1678: p_action_information23 => per_formula_functions.get_text('L_DESC'),
1679: p_action_information24 => per_formula_functions.get_number('L_COST'),
1680: p_action_information25 => per_formula_functions.get_number('L_AMG'),
1673: p_action_information18 => per_formula_functions.get_number('I_CE'),
1674: p_action_information19 => per_formula_functions.get_number('J_CE'),
1675: p_action_information20 => per_formula_functions.get_number('K_COST'),
1676: p_action_information21 => per_formula_functions.get_number('K_AMG'),
1677: p_action_information22 => per_formula_functions.get_number('K_CE'),
1678: p_action_information23 => per_formula_functions.get_text('L_DESC'),
1679: p_action_information24 => per_formula_functions.get_number('L_COST'),
1680: p_action_information25 => per_formula_functions.get_number('L_AMG'),
1681: p_action_information26 => per_formula_functions.get_number('L_CE'),
1674: p_action_information19 => per_formula_functions.get_number('J_CE'),
1675: p_action_information20 => per_formula_functions.get_number('K_COST'),
1676: p_action_information21 => per_formula_functions.get_number('K_AMG'),
1677: p_action_information22 => per_formula_functions.get_number('K_CE'),
1678: p_action_information23 => per_formula_functions.get_text('L_DESC'),
1679: p_action_information24 => per_formula_functions.get_number('L_COST'),
1680: p_action_information25 => per_formula_functions.get_number('L_AMG'),
1681: p_action_information26 => per_formula_functions.get_number('L_CE'),
1682: p_action_information27 => null,
1675: p_action_information20 => per_formula_functions.get_number('K_COST'),
1676: p_action_information21 => per_formula_functions.get_number('K_AMG'),
1677: p_action_information22 => per_formula_functions.get_number('K_CE'),
1678: p_action_information23 => per_formula_functions.get_text('L_DESC'),
1679: p_action_information24 => per_formula_functions.get_number('L_COST'),
1680: p_action_information25 => per_formula_functions.get_number('L_AMG'),
1681: p_action_information26 => per_formula_functions.get_number('L_CE'),
1682: p_action_information27 => null,
1683: p_action_information28 => per_formula_functions.get_number('H_CE1'),
1676: p_action_information21 => per_formula_functions.get_number('K_AMG'),
1677: p_action_information22 => per_formula_functions.get_number('K_CE'),
1678: p_action_information23 => per_formula_functions.get_text('L_DESC'),
1679: p_action_information24 => per_formula_functions.get_number('L_COST'),
1680: p_action_information25 => per_formula_functions.get_number('L_AMG'),
1681: p_action_information26 => per_formula_functions.get_number('L_CE'),
1682: p_action_information27 => null,
1683: p_action_information28 => per_formula_functions.get_number('H_CE1'),
1684: p_action_information29 => per_formula_functions.get_number('H_COUNT'),
1677: p_action_information22 => per_formula_functions.get_number('K_CE'),
1678: p_action_information23 => per_formula_functions.get_text('L_DESC'),
1679: p_action_information24 => per_formula_functions.get_number('L_COST'),
1680: p_action_information25 => per_formula_functions.get_number('L_AMG'),
1681: p_action_information26 => per_formula_functions.get_number('L_CE'),
1682: p_action_information27 => null,
1683: p_action_information28 => per_formula_functions.get_number('H_CE1'),
1684: p_action_information29 => per_formula_functions.get_number('H_COUNT'),
1685: p_action_information30 => per_formula_functions.get_number('F_COUNT') );
1679: p_action_information24 => per_formula_functions.get_number('L_COST'),
1680: p_action_information25 => per_formula_functions.get_number('L_AMG'),
1681: p_action_information26 => per_formula_functions.get_number('L_CE'),
1682: p_action_information27 => null,
1683: p_action_information28 => per_formula_functions.get_number('H_CE1'),
1684: p_action_information29 => per_formula_functions.get_number('H_COUNT'),
1685: p_action_information30 => per_formula_functions.get_number('F_COUNT') );
1686:
1687: hr_utility.trace('FFFFFF Count : ' || per_formula_functions.get_number('F_COUNT'));
1680: p_action_information25 => per_formula_functions.get_number('L_AMG'),
1681: p_action_information26 => per_formula_functions.get_number('L_CE'),
1682: p_action_information27 => null,
1683: p_action_information28 => per_formula_functions.get_number('H_CE1'),
1684: p_action_information29 => per_formula_functions.get_number('H_COUNT'),
1685: p_action_information30 => per_formula_functions.get_number('F_COUNT') );
1686:
1687: hr_utility.trace('FFFFFF Count : ' || per_formula_functions.get_number('F_COUNT'));
1688: --
1681: p_action_information26 => per_formula_functions.get_number('L_CE'),
1682: p_action_information27 => null,
1683: p_action_information28 => per_formula_functions.get_number('H_CE1'),
1684: p_action_information29 => per_formula_functions.get_number('H_COUNT'),
1685: p_action_information30 => per_formula_functions.get_number('F_COUNT') );
1686:
1687: hr_utility.trace('FFFFFF Count : ' || per_formula_functions.get_number('F_COUNT'));
1688: --
1689: pay_action_information_api.create_action_information(
1683: p_action_information28 => per_formula_functions.get_number('H_CE1'),
1684: p_action_information29 => per_formula_functions.get_number('H_COUNT'),
1685: p_action_information30 => per_formula_functions.get_number('F_COUNT') );
1686:
1687: hr_utility.trace('FFFFFF Count : ' || per_formula_functions.get_number('F_COUNT'));
1688: --
1689: pay_action_information_api.create_action_information(
1690: p_action_information_id => l_action_info_id,
1691: p_action_context_id => p_assactid,
1694: p_effective_date => fnd_date.canonical_to_date(g_param_benefit_end_date),
1695: p_source_id => NULL,
1696: p_source_text => NULL,
1697: p_action_information_category => 'GB P11D ASSIGNMENT RESULTB',
1698: p_action_information1 => per_formula_functions.get_text('M_DESC'),
1699: p_action_information2 => per_formula_functions.get_number('M_COST'),
1700: p_action_information3 => per_formula_functions.get_number('M_AMG'),
1701: p_action_information4 => per_formula_functions.get_number('M_CE'),
1702: p_action_information5 => per_formula_functions.get_text('MA_DESC'),
1695: p_source_id => NULL,
1696: p_source_text => NULL,
1697: p_action_information_category => 'GB P11D ASSIGNMENT RESULTB',
1698: p_action_information1 => per_formula_functions.get_text('M_DESC'),
1699: p_action_information2 => per_formula_functions.get_number('M_COST'),
1700: p_action_information3 => per_formula_functions.get_number('M_AMG'),
1701: p_action_information4 => per_formula_functions.get_number('M_CE'),
1702: p_action_information5 => per_formula_functions.get_text('MA_DESC'),
1703: p_action_information6 => per_formula_functions.get_number('MA_COST'),
1696: p_source_text => NULL,
1697: p_action_information_category => 'GB P11D ASSIGNMENT RESULTB',
1698: p_action_information1 => per_formula_functions.get_text('M_DESC'),
1699: p_action_information2 => per_formula_functions.get_number('M_COST'),
1700: p_action_information3 => per_formula_functions.get_number('M_AMG'),
1701: p_action_information4 => per_formula_functions.get_number('M_CE'),
1702: p_action_information5 => per_formula_functions.get_text('MA_DESC'),
1703: p_action_information6 => per_formula_functions.get_number('MA_COST'),
1704: p_action_information7 => per_formula_functions.get_number('MA_AMG'),
1697: p_action_information_category => 'GB P11D ASSIGNMENT RESULTB',
1698: p_action_information1 => per_formula_functions.get_text('M_DESC'),
1699: p_action_information2 => per_formula_functions.get_number('M_COST'),
1700: p_action_information3 => per_formula_functions.get_number('M_AMG'),
1701: p_action_information4 => per_formula_functions.get_number('M_CE'),
1702: p_action_information5 => per_formula_functions.get_text('MA_DESC'),
1703: p_action_information6 => per_formula_functions.get_number('MA_COST'),
1704: p_action_information7 => per_formula_functions.get_number('MA_AMG'),
1705: p_action_information8 => per_formula_functions.get_number('MA_CE'),
1698: p_action_information1 => per_formula_functions.get_text('M_DESC'),
1699: p_action_information2 => per_formula_functions.get_number('M_COST'),
1700: p_action_information3 => per_formula_functions.get_number('M_AMG'),
1701: p_action_information4 => per_formula_functions.get_number('M_CE'),
1702: p_action_information5 => per_formula_functions.get_text('MA_DESC'),
1703: p_action_information6 => per_formula_functions.get_number('MA_COST'),
1704: p_action_information7 => per_formula_functions.get_number('MA_AMG'),
1705: p_action_information8 => per_formula_functions.get_number('MA_CE'),
1706: p_action_information9 => per_formula_functions.get_number('M_TAXPAID'),
1699: p_action_information2 => per_formula_functions.get_number('M_COST'),
1700: p_action_information3 => per_formula_functions.get_number('M_AMG'),
1701: p_action_information4 => per_formula_functions.get_number('M_CE'),
1702: p_action_information5 => per_formula_functions.get_text('MA_DESC'),
1703: p_action_information6 => per_formula_functions.get_number('MA_COST'),
1704: p_action_information7 => per_formula_functions.get_number('MA_AMG'),
1705: p_action_information8 => per_formula_functions.get_number('MA_CE'),
1706: p_action_information9 => per_formula_functions.get_number('M_TAXPAID'),
1707: p_action_information10 => per_formula_functions.get_number('N1_COST'),
1700: p_action_information3 => per_formula_functions.get_number('M_AMG'),
1701: p_action_information4 => per_formula_functions.get_number('M_CE'),
1702: p_action_information5 => per_formula_functions.get_text('MA_DESC'),
1703: p_action_information6 => per_formula_functions.get_number('MA_COST'),
1704: p_action_information7 => per_formula_functions.get_number('MA_AMG'),
1705: p_action_information8 => per_formula_functions.get_number('MA_CE'),
1706: p_action_information9 => per_formula_functions.get_number('M_TAXPAID'),
1707: p_action_information10 => per_formula_functions.get_number('N1_COST'),
1708: p_action_information11 => per_formula_functions.get_number('N1_AMG'),
1701: p_action_information4 => per_formula_functions.get_number('M_CE'),
1702: p_action_information5 => per_formula_functions.get_text('MA_DESC'),
1703: p_action_information6 => per_formula_functions.get_number('MA_COST'),
1704: p_action_information7 => per_formula_functions.get_number('MA_AMG'),
1705: p_action_information8 => per_formula_functions.get_number('MA_CE'),
1706: p_action_information9 => per_formula_functions.get_number('M_TAXPAID'),
1707: p_action_information10 => per_formula_functions.get_number('N1_COST'),
1708: p_action_information11 => per_formula_functions.get_number('N1_AMG'),
1709: p_action_information12 => per_formula_functions.get_number('N1_CE'),
1702: p_action_information5 => per_formula_functions.get_text('MA_DESC'),
1703: p_action_information6 => per_formula_functions.get_number('MA_COST'),
1704: p_action_information7 => per_formula_functions.get_number('MA_AMG'),
1705: p_action_information8 => per_formula_functions.get_number('MA_CE'),
1706: p_action_information9 => per_formula_functions.get_number('M_TAXPAID'),
1707: p_action_information10 => per_formula_functions.get_number('N1_COST'),
1708: p_action_information11 => per_formula_functions.get_number('N1_AMG'),
1709: p_action_information12 => per_formula_functions.get_number('N1_CE'),
1710: p_action_information13 => per_formula_functions.get_number('N2_COST'),
1703: p_action_information6 => per_formula_functions.get_number('MA_COST'),
1704: p_action_information7 => per_formula_functions.get_number('MA_AMG'),
1705: p_action_information8 => per_formula_functions.get_number('MA_CE'),
1706: p_action_information9 => per_formula_functions.get_number('M_TAXPAID'),
1707: p_action_information10 => per_formula_functions.get_number('N1_COST'),
1708: p_action_information11 => per_formula_functions.get_number('N1_AMG'),
1709: p_action_information12 => per_formula_functions.get_number('N1_CE'),
1710: p_action_information13 => per_formula_functions.get_number('N2_COST'),
1711: p_action_information14 => per_formula_functions.get_number('N2_AMG'),
1704: p_action_information7 => per_formula_functions.get_number('MA_AMG'),
1705: p_action_information8 => per_formula_functions.get_number('MA_CE'),
1706: p_action_information9 => per_formula_functions.get_number('M_TAXPAID'),
1707: p_action_information10 => per_formula_functions.get_number('N1_COST'),
1708: p_action_information11 => per_formula_functions.get_number('N1_AMG'),
1709: p_action_information12 => per_formula_functions.get_number('N1_CE'),
1710: p_action_information13 => per_formula_functions.get_number('N2_COST'),
1711: p_action_information14 => per_formula_functions.get_number('N2_AMG'),
1712: p_action_information15 => per_formula_functions.get_number('N2_CE'),
1705: p_action_information8 => per_formula_functions.get_number('MA_CE'),
1706: p_action_information9 => per_formula_functions.get_number('M_TAXPAID'),
1707: p_action_information10 => per_formula_functions.get_number('N1_COST'),
1708: p_action_information11 => per_formula_functions.get_number('N1_AMG'),
1709: p_action_information12 => per_formula_functions.get_number('N1_CE'),
1710: p_action_information13 => per_formula_functions.get_number('N2_COST'),
1711: p_action_information14 => per_formula_functions.get_number('N2_AMG'),
1712: p_action_information15 => per_formula_functions.get_number('N2_CE'),
1713: p_action_information16 => per_formula_functions.get_text('N_TOI'),
1706: p_action_information9 => per_formula_functions.get_number('M_TAXPAID'),
1707: p_action_information10 => per_formula_functions.get_number('N1_COST'),
1708: p_action_information11 => per_formula_functions.get_number('N1_AMG'),
1709: p_action_information12 => per_formula_functions.get_number('N1_CE'),
1710: p_action_information13 => per_formula_functions.get_number('N2_COST'),
1711: p_action_information14 => per_formula_functions.get_number('N2_AMG'),
1712: p_action_information15 => per_formula_functions.get_number('N2_CE'),
1713: p_action_information16 => per_formula_functions.get_text('N_TOI'),
1714: p_action_information17 => per_formula_functions.get_number('N3_COST'),
1707: p_action_information10 => per_formula_functions.get_number('N1_COST'),
1708: p_action_information11 => per_formula_functions.get_number('N1_AMG'),
1709: p_action_information12 => per_formula_functions.get_number('N1_CE'),
1710: p_action_information13 => per_formula_functions.get_number('N2_COST'),
1711: p_action_information14 => per_formula_functions.get_number('N2_AMG'),
1712: p_action_information15 => per_formula_functions.get_number('N2_CE'),
1713: p_action_information16 => per_formula_functions.get_text('N_TOI'),
1714: p_action_information17 => per_formula_functions.get_number('N3_COST'),
1715: p_action_information18 => per_formula_functions.get_number('N3_AMG'),
1708: p_action_information11 => per_formula_functions.get_number('N1_AMG'),
1709: p_action_information12 => per_formula_functions.get_number('N1_CE'),
1710: p_action_information13 => per_formula_functions.get_number('N2_COST'),
1711: p_action_information14 => per_formula_functions.get_number('N2_AMG'),
1712: p_action_information15 => per_formula_functions.get_number('N2_CE'),
1713: p_action_information16 => per_formula_functions.get_text('N_TOI'),
1714: p_action_information17 => per_formula_functions.get_number('N3_COST'),
1715: p_action_information18 => per_formula_functions.get_number('N3_AMG'),
1716: p_action_information19 => per_formula_functions.get_number('N3_CE'),
1709: p_action_information12 => per_formula_functions.get_number('N1_CE'),
1710: p_action_information13 => per_formula_functions.get_number('N2_COST'),
1711: p_action_information14 => per_formula_functions.get_number('N2_AMG'),
1712: p_action_information15 => per_formula_functions.get_number('N2_CE'),
1713: p_action_information16 => per_formula_functions.get_text('N_TOI'),
1714: p_action_information17 => per_formula_functions.get_number('N3_COST'),
1715: p_action_information18 => per_formula_functions.get_number('N3_AMG'),
1716: p_action_information19 => per_formula_functions.get_number('N3_CE'),
1717: p_action_information20 => per_formula_functions.get_number('N4_COST'),
1710: p_action_information13 => per_formula_functions.get_number('N2_COST'),
1711: p_action_information14 => per_formula_functions.get_number('N2_AMG'),
1712: p_action_information15 => per_formula_functions.get_number('N2_CE'),
1713: p_action_information16 => per_formula_functions.get_text('N_TOI'),
1714: p_action_information17 => per_formula_functions.get_number('N3_COST'),
1715: p_action_information18 => per_formula_functions.get_number('N3_AMG'),
1716: p_action_information19 => per_formula_functions.get_number('N3_CE'),
1717: p_action_information20 => per_formula_functions.get_number('N4_COST'),
1718: p_action_information21 => per_formula_functions.get_number('N4_AMG'),
1711: p_action_information14 => per_formula_functions.get_number('N2_AMG'),
1712: p_action_information15 => per_formula_functions.get_number('N2_CE'),
1713: p_action_information16 => per_formula_functions.get_text('N_TOI'),
1714: p_action_information17 => per_formula_functions.get_number('N3_COST'),
1715: p_action_information18 => per_formula_functions.get_number('N3_AMG'),
1716: p_action_information19 => per_formula_functions.get_number('N3_CE'),
1717: p_action_information20 => per_formula_functions.get_number('N4_COST'),
1718: p_action_information21 => per_formula_functions.get_number('N4_AMG'),
1719: p_action_information22 => per_formula_functions.get_number('N4_CE'),
1712: p_action_information15 => per_formula_functions.get_number('N2_CE'),
1713: p_action_information16 => per_formula_functions.get_text('N_TOI'),
1714: p_action_information17 => per_formula_functions.get_number('N3_COST'),
1715: p_action_information18 => per_formula_functions.get_number('N3_AMG'),
1716: p_action_information19 => per_formula_functions.get_number('N3_CE'),
1717: p_action_information20 => per_formula_functions.get_number('N4_COST'),
1718: p_action_information21 => per_formula_functions.get_number('N4_AMG'),
1719: p_action_information22 => per_formula_functions.get_number('N4_CE'),
1720: p_action_information23 => per_formula_functions.get_number('N5_COST'),
1713: p_action_information16 => per_formula_functions.get_text('N_TOI'),
1714: p_action_information17 => per_formula_functions.get_number('N3_COST'),
1715: p_action_information18 => per_formula_functions.get_number('N3_AMG'),
1716: p_action_information19 => per_formula_functions.get_number('N3_CE'),
1717: p_action_information20 => per_formula_functions.get_number('N4_COST'),
1718: p_action_information21 => per_formula_functions.get_number('N4_AMG'),
1719: p_action_information22 => per_formula_functions.get_number('N4_CE'),
1720: p_action_information23 => per_formula_functions.get_number('N5_COST'),
1721: p_action_information24 => per_formula_functions.get_number('N5_AMG'),
1714: p_action_information17 => per_formula_functions.get_number('N3_COST'),
1715: p_action_information18 => per_formula_functions.get_number('N3_AMG'),
1716: p_action_information19 => per_formula_functions.get_number('N3_CE'),
1717: p_action_information20 => per_formula_functions.get_number('N4_COST'),
1718: p_action_information21 => per_formula_functions.get_number('N4_AMG'),
1719: p_action_information22 => per_formula_functions.get_number('N4_CE'),
1720: p_action_information23 => per_formula_functions.get_number('N5_COST'),
1721: p_action_information24 => per_formula_functions.get_number('N5_AMG'),
1722: p_action_information25 => per_formula_functions.get_number('N5_CE'),
1715: p_action_information18 => per_formula_functions.get_number('N3_AMG'),
1716: p_action_information19 => per_formula_functions.get_number('N3_CE'),
1717: p_action_information20 => per_formula_functions.get_number('N4_COST'),
1718: p_action_information21 => per_formula_functions.get_number('N4_AMG'),
1719: p_action_information22 => per_formula_functions.get_number('N4_CE'),
1720: p_action_information23 => per_formula_functions.get_number('N5_COST'),
1721: p_action_information24 => per_formula_functions.get_number('N5_AMG'),
1722: p_action_information25 => per_formula_functions.get_number('N5_CE'),
1723: p_action_information26 => per_formula_functions.get_text('N6_DESC'),
1716: p_action_information19 => per_formula_functions.get_number('N3_CE'),
1717: p_action_information20 => per_formula_functions.get_number('N4_COST'),
1718: p_action_information21 => per_formula_functions.get_number('N4_AMG'),
1719: p_action_information22 => per_formula_functions.get_number('N4_CE'),
1720: p_action_information23 => per_formula_functions.get_number('N5_COST'),
1721: p_action_information24 => per_formula_functions.get_number('N5_AMG'),
1722: p_action_information25 => per_formula_functions.get_number('N5_CE'),
1723: p_action_information26 => per_formula_functions.get_text('N6_DESC'),
1724: p_action_information27 => per_formula_functions.get_number('N6_COST'),
1717: p_action_information20 => per_formula_functions.get_number('N4_COST'),
1718: p_action_information21 => per_formula_functions.get_number('N4_AMG'),
1719: p_action_information22 => per_formula_functions.get_number('N4_CE'),
1720: p_action_information23 => per_formula_functions.get_number('N5_COST'),
1721: p_action_information24 => per_formula_functions.get_number('N5_AMG'),
1722: p_action_information25 => per_formula_functions.get_number('N5_CE'),
1723: p_action_information26 => per_formula_functions.get_text('N6_DESC'),
1724: p_action_information27 => per_formula_functions.get_number('N6_COST'),
1725: p_action_information28 => per_formula_functions.get_number('N6_AMG'),
1718: p_action_information21 => per_formula_functions.get_number('N4_AMG'),
1719: p_action_information22 => per_formula_functions.get_number('N4_CE'),
1720: p_action_information23 => per_formula_functions.get_number('N5_COST'),
1721: p_action_information24 => per_formula_functions.get_number('N5_AMG'),
1722: p_action_information25 => per_formula_functions.get_number('N5_CE'),
1723: p_action_information26 => per_formula_functions.get_text('N6_DESC'),
1724: p_action_information27 => per_formula_functions.get_number('N6_COST'),
1725: p_action_information28 => per_formula_functions.get_number('N6_AMG'),
1726: p_action_information29 => per_formula_functions.get_number('N6_CE')
1719: p_action_information22 => per_formula_functions.get_number('N4_CE'),
1720: p_action_information23 => per_formula_functions.get_number('N5_COST'),
1721: p_action_information24 => per_formula_functions.get_number('N5_AMG'),
1722: p_action_information25 => per_formula_functions.get_number('N5_CE'),
1723: p_action_information26 => per_formula_functions.get_text('N6_DESC'),
1724: p_action_information27 => per_formula_functions.get_number('N6_COST'),
1725: p_action_information28 => per_formula_functions.get_number('N6_AMG'),
1726: p_action_information29 => per_formula_functions.get_number('N6_CE')
1727: ,p_action_information30 => per_formula_functions.get_number('G_FCE'));
1720: p_action_information23 => per_formula_functions.get_number('N5_COST'),
1721: p_action_information24 => per_formula_functions.get_number('N5_AMG'),
1722: p_action_information25 => per_formula_functions.get_number('N5_CE'),
1723: p_action_information26 => per_formula_functions.get_text('N6_DESC'),
1724: p_action_information27 => per_formula_functions.get_number('N6_COST'),
1725: p_action_information28 => per_formula_functions.get_number('N6_AMG'),
1726: p_action_information29 => per_formula_functions.get_number('N6_CE')
1727: ,p_action_information30 => per_formula_functions.get_number('G_FCE'));
1728:
1721: p_action_information24 => per_formula_functions.get_number('N5_AMG'),
1722: p_action_information25 => per_formula_functions.get_number('N5_CE'),
1723: p_action_information26 => per_formula_functions.get_text('N6_DESC'),
1724: p_action_information27 => per_formula_functions.get_number('N6_COST'),
1725: p_action_information28 => per_formula_functions.get_number('N6_AMG'),
1726: p_action_information29 => per_formula_functions.get_number('N6_CE')
1727: ,p_action_information30 => per_formula_functions.get_number('G_FCE'));
1728:
1729:
1722: p_action_information25 => per_formula_functions.get_number('N5_CE'),
1723: p_action_information26 => per_formula_functions.get_text('N6_DESC'),
1724: p_action_information27 => per_formula_functions.get_number('N6_COST'),
1725: p_action_information28 => per_formula_functions.get_number('N6_AMG'),
1726: p_action_information29 => per_formula_functions.get_number('N6_CE')
1727: ,p_action_information30 => per_formula_functions.get_number('G_FCE'));
1728:
1729:
1730: pay_action_information_api.create_action_information(
1723: p_action_information26 => per_formula_functions.get_text('N6_DESC'),
1724: p_action_information27 => per_formula_functions.get_number('N6_COST'),
1725: p_action_information28 => per_formula_functions.get_number('N6_AMG'),
1726: p_action_information29 => per_formula_functions.get_number('N6_CE')
1727: ,p_action_information30 => per_formula_functions.get_number('G_FCE'));
1728:
1729:
1730: pay_action_information_api.create_action_information(
1731: p_action_information_id => l_action_info_id,
1735: p_effective_date => fnd_date.canonical_to_date(g_param_benefit_end_date),
1736: p_source_id => NULL,
1737: p_source_text => NULL,
1738: p_action_information_category => 'GB P11D ASSIGNMENT RESULTC',
1739: p_action_information1 => per_formula_functions.get_number('C_BUS_MILES'),
1740: p_action_information2 => per_formula_functions.get_number('M_BUS_MILES'),
1741: p_action_information3 => per_formula_functions.get_number('B_BUS_MILES'),
1742: p_action_information4 => per_formula_functions.get_number('C_RATE1'),
1743: p_action_information5 => per_formula_functions.get_number('C_RATE2'),
1736: p_source_id => NULL,
1737: p_source_text => NULL,
1738: p_action_information_category => 'GB P11D ASSIGNMENT RESULTC',
1739: p_action_information1 => per_formula_functions.get_number('C_BUS_MILES'),
1740: p_action_information2 => per_formula_functions.get_number('M_BUS_MILES'),
1741: p_action_information3 => per_formula_functions.get_number('B_BUS_MILES'),
1742: p_action_information4 => per_formula_functions.get_number('C_RATE1'),
1743: p_action_information5 => per_formula_functions.get_number('C_RATE2'),
1744: p_action_information6 => per_formula_functions.get_number('M_RATE1'),
1737: p_source_text => NULL,
1738: p_action_information_category => 'GB P11D ASSIGNMENT RESULTC',
1739: p_action_information1 => per_formula_functions.get_number('C_BUS_MILES'),
1740: p_action_information2 => per_formula_functions.get_number('M_BUS_MILES'),
1741: p_action_information3 => per_formula_functions.get_number('B_BUS_MILES'),
1742: p_action_information4 => per_formula_functions.get_number('C_RATE1'),
1743: p_action_information5 => per_formula_functions.get_number('C_RATE2'),
1744: p_action_information6 => per_formula_functions.get_number('M_RATE1'),
1745: p_action_information7 => per_formula_functions.get_number('M_RATE2'),
1738: p_action_information_category => 'GB P11D ASSIGNMENT RESULTC',
1739: p_action_information1 => per_formula_functions.get_number('C_BUS_MILES'),
1740: p_action_information2 => per_formula_functions.get_number('M_BUS_MILES'),
1741: p_action_information3 => per_formula_functions.get_number('B_BUS_MILES'),
1742: p_action_information4 => per_formula_functions.get_number('C_RATE1'),
1743: p_action_information5 => per_formula_functions.get_number('C_RATE2'),
1744: p_action_information6 => per_formula_functions.get_number('M_RATE1'),
1745: p_action_information7 => per_formula_functions.get_number('M_RATE2'),
1746: p_action_information8 => per_formula_functions.get_number('B_RATE1'),
1739: p_action_information1 => per_formula_functions.get_number('C_BUS_MILES'),
1740: p_action_information2 => per_formula_functions.get_number('M_BUS_MILES'),
1741: p_action_information3 => per_formula_functions.get_number('B_BUS_MILES'),
1742: p_action_information4 => per_formula_functions.get_number('C_RATE1'),
1743: p_action_information5 => per_formula_functions.get_number('C_RATE2'),
1744: p_action_information6 => per_formula_functions.get_number('M_RATE1'),
1745: p_action_information7 => per_formula_functions.get_number('M_RATE2'),
1746: p_action_information8 => per_formula_functions.get_number('B_RATE1'),
1747: p_action_information9 => per_formula_functions.get_number('B_RATE2'),
1740: p_action_information2 => per_formula_functions.get_number('M_BUS_MILES'),
1741: p_action_information3 => per_formula_functions.get_number('B_BUS_MILES'),
1742: p_action_information4 => per_formula_functions.get_number('C_RATE1'),
1743: p_action_information5 => per_formula_functions.get_number('C_RATE2'),
1744: p_action_information6 => per_formula_functions.get_number('M_RATE1'),
1745: p_action_information7 => per_formula_functions.get_number('M_RATE2'),
1746: p_action_information8 => per_formula_functions.get_number('B_RATE1'),
1747: p_action_information9 => per_formula_functions.get_number('B_RATE2'),
1748: p_action_information10 => null,
1741: p_action_information3 => per_formula_functions.get_number('B_BUS_MILES'),
1742: p_action_information4 => per_formula_functions.get_number('C_RATE1'),
1743: p_action_information5 => per_formula_functions.get_number('C_RATE2'),
1744: p_action_information6 => per_formula_functions.get_number('M_RATE1'),
1745: p_action_information7 => per_formula_functions.get_number('M_RATE2'),
1746: p_action_information8 => per_formula_functions.get_number('B_RATE1'),
1747: p_action_information9 => per_formula_functions.get_number('B_RATE2'),
1748: p_action_information10 => null,
1749: p_action_information11 => null,
1742: p_action_information4 => per_formula_functions.get_number('C_RATE1'),
1743: p_action_information5 => per_formula_functions.get_number('C_RATE2'),
1744: p_action_information6 => per_formula_functions.get_number('M_RATE1'),
1745: p_action_information7 => per_formula_functions.get_number('M_RATE2'),
1746: p_action_information8 => per_formula_functions.get_number('B_RATE1'),
1747: p_action_information9 => per_formula_functions.get_number('B_RATE2'),
1748: p_action_information10 => null,
1749: p_action_information11 => null,
1750: p_action_information12 => per_formula_functions.get_number('C_MILEAGE_PAYMENTS'),
1743: p_action_information5 => per_formula_functions.get_number('C_RATE2'),
1744: p_action_information6 => per_formula_functions.get_number('M_RATE1'),
1745: p_action_information7 => per_formula_functions.get_number('M_RATE2'),
1746: p_action_information8 => per_formula_functions.get_number('B_RATE1'),
1747: p_action_information9 => per_formula_functions.get_number('B_RATE2'),
1748: p_action_information10 => null,
1749: p_action_information11 => null,
1750: p_action_information12 => per_formula_functions.get_number('C_MILEAGE_PAYMENTS'),
1751: p_action_information13 => per_formula_functions.get_number('B_MILEAGE_PAYMENTS'),
1746: p_action_information8 => per_formula_functions.get_number('B_RATE1'),
1747: p_action_information9 => per_formula_functions.get_number('B_RATE2'),
1748: p_action_information10 => null,
1749: p_action_information11 => null,
1750: p_action_information12 => per_formula_functions.get_number('C_MILEAGE_PAYMENTS'),
1751: p_action_information13 => per_formula_functions.get_number('B_MILEAGE_PAYMENTS'),
1752: p_action_information14 => per_formula_functions.get_number('M_MILEAGE_PAYMENTS'),
1753: p_action_information15 => per_formula_functions.get_number('MARORS_COUNT'),
1754: p_action_information16 => per_formula_functions.get_number('C_TAX_DEDUCTED'),
1747: p_action_information9 => per_formula_functions.get_number('B_RATE2'),
1748: p_action_information10 => null,
1749: p_action_information11 => null,
1750: p_action_information12 => per_formula_functions.get_number('C_MILEAGE_PAYMENTS'),
1751: p_action_information13 => per_formula_functions.get_number('B_MILEAGE_PAYMENTS'),
1752: p_action_information14 => per_formula_functions.get_number('M_MILEAGE_PAYMENTS'),
1753: p_action_information15 => per_formula_functions.get_number('MARORS_COUNT'),
1754: p_action_information16 => per_formula_functions.get_number('C_TAX_DEDUCTED'),
1755: p_action_information17 => per_formula_functions.get_number('B_TAX_DEDUCTED'),
1748: p_action_information10 => null,
1749: p_action_information11 => null,
1750: p_action_information12 => per_formula_functions.get_number('C_MILEAGE_PAYMENTS'),
1751: p_action_information13 => per_formula_functions.get_number('B_MILEAGE_PAYMENTS'),
1752: p_action_information14 => per_formula_functions.get_number('M_MILEAGE_PAYMENTS'),
1753: p_action_information15 => per_formula_functions.get_number('MARORS_COUNT'),
1754: p_action_information16 => per_formula_functions.get_number('C_TAX_DEDUCTED'),
1755: p_action_information17 => per_formula_functions.get_number('B_TAX_DEDUCTED'),
1756: p_action_information18 => per_formula_functions.get_number('M_TAX_DEDUCTED'),
1749: p_action_information11 => null,
1750: p_action_information12 => per_formula_functions.get_number('C_MILEAGE_PAYMENTS'),
1751: p_action_information13 => per_formula_functions.get_number('B_MILEAGE_PAYMENTS'),
1752: p_action_information14 => per_formula_functions.get_number('M_MILEAGE_PAYMENTS'),
1753: p_action_information15 => per_formula_functions.get_number('MARORS_COUNT'),
1754: p_action_information16 => per_formula_functions.get_number('C_TAX_DEDUCTED'),
1755: p_action_information17 => per_formula_functions.get_number('B_TAX_DEDUCTED'),
1756: p_action_information18 => per_formula_functions.get_number('M_TAX_DEDUCTED'),
1757: p_action_information19 => per_formula_functions.get_number('PASSENGER_PAYMENTS'),
1750: p_action_information12 => per_formula_functions.get_number('C_MILEAGE_PAYMENTS'),
1751: p_action_information13 => per_formula_functions.get_number('B_MILEAGE_PAYMENTS'),
1752: p_action_information14 => per_formula_functions.get_number('M_MILEAGE_PAYMENTS'),
1753: p_action_information15 => per_formula_functions.get_number('MARORS_COUNT'),
1754: p_action_information16 => per_formula_functions.get_number('C_TAX_DEDUCTED'),
1755: p_action_information17 => per_formula_functions.get_number('B_TAX_DEDUCTED'),
1756: p_action_information18 => per_formula_functions.get_number('M_TAX_DEDUCTED'),
1757: p_action_information19 => per_formula_functions.get_number('PASSENGER_PAYMENTS'),
1758: p_action_information20 => per_formula_functions.get_number('PASSENGER_BUS_MILES'),
1751: p_action_information13 => per_formula_functions.get_number('B_MILEAGE_PAYMENTS'),
1752: p_action_information14 => per_formula_functions.get_number('M_MILEAGE_PAYMENTS'),
1753: p_action_information15 => per_formula_functions.get_number('MARORS_COUNT'),
1754: p_action_information16 => per_formula_functions.get_number('C_TAX_DEDUCTED'),
1755: p_action_information17 => per_formula_functions.get_number('B_TAX_DEDUCTED'),
1756: p_action_information18 => per_formula_functions.get_number('M_TAX_DEDUCTED'),
1757: p_action_information19 => per_formula_functions.get_number('PASSENGER_PAYMENTS'),
1758: p_action_information20 => per_formula_functions.get_number('PASSENGER_BUS_MILES'),
1759: p_action_information21 => per_formula_functions.get_number('PASSENGER_BUS_MILE_AMT'),
1752: p_action_information14 => per_formula_functions.get_number('M_MILEAGE_PAYMENTS'),
1753: p_action_information15 => per_formula_functions.get_number('MARORS_COUNT'),
1754: p_action_information16 => per_formula_functions.get_number('C_TAX_DEDUCTED'),
1755: p_action_information17 => per_formula_functions.get_number('B_TAX_DEDUCTED'),
1756: p_action_information18 => per_formula_functions.get_number('M_TAX_DEDUCTED'),
1757: p_action_information19 => per_formula_functions.get_number('PASSENGER_PAYMENTS'),
1758: p_action_information20 => per_formula_functions.get_number('PASSENGER_BUS_MILES'),
1759: p_action_information21 => per_formula_functions.get_number('PASSENGER_BUS_MILE_AMT'),
1760: p_action_information22 => per_formula_functions.get_number('MILEAGE_ALLOWANCE_RELIEF'),
1753: p_action_information15 => per_formula_functions.get_number('MARORS_COUNT'),
1754: p_action_information16 => per_formula_functions.get_number('C_TAX_DEDUCTED'),
1755: p_action_information17 => per_formula_functions.get_number('B_TAX_DEDUCTED'),
1756: p_action_information18 => per_formula_functions.get_number('M_TAX_DEDUCTED'),
1757: p_action_information19 => per_formula_functions.get_number('PASSENGER_PAYMENTS'),
1758: p_action_information20 => per_formula_functions.get_number('PASSENGER_BUS_MILES'),
1759: p_action_information21 => per_formula_functions.get_number('PASSENGER_BUS_MILE_AMT'),
1760: p_action_information22 => per_formula_functions.get_number('MILEAGE_ALLOWANCE_RELIEF'),
1761: p_action_information23 => per_formula_functions.get_number('INT_MAX_AMT_OUTSTANDING')
1754: p_action_information16 => per_formula_functions.get_number('C_TAX_DEDUCTED'),
1755: p_action_information17 => per_formula_functions.get_number('B_TAX_DEDUCTED'),
1756: p_action_information18 => per_formula_functions.get_number('M_TAX_DEDUCTED'),
1757: p_action_information19 => per_formula_functions.get_number('PASSENGER_PAYMENTS'),
1758: p_action_information20 => per_formula_functions.get_number('PASSENGER_BUS_MILES'),
1759: p_action_information21 => per_formula_functions.get_number('PASSENGER_BUS_MILE_AMT'),
1760: p_action_information22 => per_formula_functions.get_number('MILEAGE_ALLOWANCE_RELIEF'),
1761: p_action_information23 => per_formula_functions.get_number('INT_MAX_AMT_OUTSTANDING')
1762: );
1755: p_action_information17 => per_formula_functions.get_number('B_TAX_DEDUCTED'),
1756: p_action_information18 => per_formula_functions.get_number('M_TAX_DEDUCTED'),
1757: p_action_information19 => per_formula_functions.get_number('PASSENGER_PAYMENTS'),
1758: p_action_information20 => per_formula_functions.get_number('PASSENGER_BUS_MILES'),
1759: p_action_information21 => per_formula_functions.get_number('PASSENGER_BUS_MILE_AMT'),
1760: p_action_information22 => per_formula_functions.get_number('MILEAGE_ALLOWANCE_RELIEF'),
1761: p_action_information23 => per_formula_functions.get_number('INT_MAX_AMT_OUTSTANDING')
1762: );
1763: end if;
1756: p_action_information18 => per_formula_functions.get_number('M_TAX_DEDUCTED'),
1757: p_action_information19 => per_formula_functions.get_number('PASSENGER_PAYMENTS'),
1758: p_action_information20 => per_formula_functions.get_number('PASSENGER_BUS_MILES'),
1759: p_action_information21 => per_formula_functions.get_number('PASSENGER_BUS_MILE_AMT'),
1760: p_action_information22 => per_formula_functions.get_number('MILEAGE_ALLOWANCE_RELIEF'),
1761: p_action_information23 => per_formula_functions.get_number('INT_MAX_AMT_OUTSTANDING')
1762: );
1763: end if;
1764:
1757: p_action_information19 => per_formula_functions.get_number('PASSENGER_PAYMENTS'),
1758: p_action_information20 => per_formula_functions.get_number('PASSENGER_BUS_MILES'),
1759: p_action_information21 => per_formula_functions.get_number('PASSENGER_BUS_MILE_AMT'),
1760: p_action_information22 => per_formula_functions.get_number('MILEAGE_ALLOWANCE_RELIEF'),
1761: p_action_information23 => per_formula_functions.get_number('INT_MAX_AMT_OUTSTANDING')
1762: );
1763: end if;
1764:
1765: END;
2120: THEN
2121: pay_action_information_api.update_action_information(
2122: p_action_information_id => p_action_info_id,
2123: p_object_version_number => p_ovn,
2124: p_action_information1 => per_formula_functions.get_text('A_DESC'),
2125: p_action_information2 => per_formula_functions.get_number('A_COST'),
2126: p_action_information3 => per_formula_functions.get_number('A_AMG'),
2127: p_action_information4 => per_formula_functions.get_number('A_CE'),
2128: p_action_information5 => per_formula_functions.get_text('B_DESC'),
2121: pay_action_information_api.update_action_information(
2122: p_action_information_id => p_action_info_id,
2123: p_object_version_number => p_ovn,
2124: p_action_information1 => per_formula_functions.get_text('A_DESC'),
2125: p_action_information2 => per_formula_functions.get_number('A_COST'),
2126: p_action_information3 => per_formula_functions.get_number('A_AMG'),
2127: p_action_information4 => per_formula_functions.get_number('A_CE'),
2128: p_action_information5 => per_formula_functions.get_text('B_DESC'),
2129: p_action_information6 => per_formula_functions.get_number('B_CE'),
2122: p_action_information_id => p_action_info_id,
2123: p_object_version_number => p_ovn,
2124: p_action_information1 => per_formula_functions.get_text('A_DESC'),
2125: p_action_information2 => per_formula_functions.get_number('A_COST'),
2126: p_action_information3 => per_formula_functions.get_number('A_AMG'),
2127: p_action_information4 => per_formula_functions.get_number('A_CE'),
2128: p_action_information5 => per_formula_functions.get_text('B_DESC'),
2129: p_action_information6 => per_formula_functions.get_number('B_CE'),
2130: p_action_information7 => per_formula_functions.get_number('B_TNP'),
2123: p_object_version_number => p_ovn,
2124: p_action_information1 => per_formula_functions.get_text('A_DESC'),
2125: p_action_information2 => per_formula_functions.get_number('A_COST'),
2126: p_action_information3 => per_formula_functions.get_number('A_AMG'),
2127: p_action_information4 => per_formula_functions.get_number('A_CE'),
2128: p_action_information5 => per_formula_functions.get_text('B_DESC'),
2129: p_action_information6 => per_formula_functions.get_number('B_CE'),
2130: p_action_information7 => per_formula_functions.get_number('B_TNP'),
2131: p_action_information8 => per_formula_functions.get_number('C_COST'),
2124: p_action_information1 => per_formula_functions.get_text('A_DESC'),
2125: p_action_information2 => per_formula_functions.get_number('A_COST'),
2126: p_action_information3 => per_formula_functions.get_number('A_AMG'),
2127: p_action_information4 => per_formula_functions.get_number('A_CE'),
2128: p_action_information5 => per_formula_functions.get_text('B_DESC'),
2129: p_action_information6 => per_formula_functions.get_number('B_CE'),
2130: p_action_information7 => per_formula_functions.get_number('B_TNP'),
2131: p_action_information8 => per_formula_functions.get_number('C_COST'),
2132: p_action_information9 => per_formula_functions.get_number('C_AMG'),
2125: p_action_information2 => per_formula_functions.get_number('A_COST'),
2126: p_action_information3 => per_formula_functions.get_number('A_AMG'),
2127: p_action_information4 => per_formula_functions.get_number('A_CE'),
2128: p_action_information5 => per_formula_functions.get_text('B_DESC'),
2129: p_action_information6 => per_formula_functions.get_number('B_CE'),
2130: p_action_information7 => per_formula_functions.get_number('B_TNP'),
2131: p_action_information8 => per_formula_functions.get_number('C_COST'),
2132: p_action_information9 => per_formula_functions.get_number('C_AMG'),
2133: p_action_information10 => per_formula_functions.get_number('C_CE'),
2126: p_action_information3 => per_formula_functions.get_number('A_AMG'),
2127: p_action_information4 => per_formula_functions.get_number('A_CE'),
2128: p_action_information5 => per_formula_functions.get_text('B_DESC'),
2129: p_action_information6 => per_formula_functions.get_number('B_CE'),
2130: p_action_information7 => per_formula_functions.get_number('B_TNP'),
2131: p_action_information8 => per_formula_functions.get_number('C_COST'),
2132: p_action_information9 => per_formula_functions.get_number('C_AMG'),
2133: p_action_information10 => per_formula_functions.get_number('C_CE'),
2134: p_action_information11 => per_formula_functions.get_number('D_CE'),
2127: p_action_information4 => per_formula_functions.get_number('A_CE'),
2128: p_action_information5 => per_formula_functions.get_text('B_DESC'),
2129: p_action_information6 => per_formula_functions.get_number('B_CE'),
2130: p_action_information7 => per_formula_functions.get_number('B_TNP'),
2131: p_action_information8 => per_formula_functions.get_number('C_COST'),
2132: p_action_information9 => per_formula_functions.get_number('C_AMG'),
2133: p_action_information10 => per_formula_functions.get_number('C_CE'),
2134: p_action_information11 => per_formula_functions.get_number('D_CE'),
2135: p_action_information12 => calculate_amap_ce ,
2128: p_action_information5 => per_formula_functions.get_text('B_DESC'),
2129: p_action_information6 => per_formula_functions.get_number('B_CE'),
2130: p_action_information7 => per_formula_functions.get_number('B_TNP'),
2131: p_action_information8 => per_formula_functions.get_number('C_COST'),
2132: p_action_information9 => per_formula_functions.get_number('C_AMG'),
2133: p_action_information10 => per_formula_functions.get_number('C_CE'),
2134: p_action_information11 => per_formula_functions.get_number('D_CE'),
2135: p_action_information12 => calculate_amap_ce ,
2136: p_action_information13 => per_formula_functions.get_number('F_TCCE'),
2129: p_action_information6 => per_formula_functions.get_number('B_CE'),
2130: p_action_information7 => per_formula_functions.get_number('B_TNP'),
2131: p_action_information8 => per_formula_functions.get_number('C_COST'),
2132: p_action_information9 => per_formula_functions.get_number('C_AMG'),
2133: p_action_information10 => per_formula_functions.get_number('C_CE'),
2134: p_action_information11 => per_formula_functions.get_number('D_CE'),
2135: p_action_information12 => calculate_amap_ce ,
2136: p_action_information13 => per_formula_functions.get_number('F_TCCE'),
2137: p_action_information14 => per_formula_functions.get_number('F_TFCE'),
2130: p_action_information7 => per_formula_functions.get_number('B_TNP'),
2131: p_action_information8 => per_formula_functions.get_number('C_COST'),
2132: p_action_information9 => per_formula_functions.get_number('C_AMG'),
2133: p_action_information10 => per_formula_functions.get_number('C_CE'),
2134: p_action_information11 => per_formula_functions.get_number('D_CE'),
2135: p_action_information12 => calculate_amap_ce ,
2136: p_action_information13 => per_formula_functions.get_number('F_TCCE'),
2137: p_action_information14 => per_formula_functions.get_number('F_TFCE'),
2138: p_action_information15 => per_formula_functions.get_number('G_CE'),
2132: p_action_information9 => per_formula_functions.get_number('C_AMG'),
2133: p_action_information10 => per_formula_functions.get_number('C_CE'),
2134: p_action_information11 => per_formula_functions.get_number('D_CE'),
2135: p_action_information12 => calculate_amap_ce ,
2136: p_action_information13 => per_formula_functions.get_number('F_TCCE'),
2137: p_action_information14 => per_formula_functions.get_number('F_TFCE'),
2138: p_action_information15 => per_formula_functions.get_number('G_CE'),
2139: p_action_information16 => per_formula_functions.get_number('I_COST'),
2140: p_action_information17 => per_formula_functions.get_number('I_AMG'),
2133: p_action_information10 => per_formula_functions.get_number('C_CE'),
2134: p_action_information11 => per_formula_functions.get_number('D_CE'),
2135: p_action_information12 => calculate_amap_ce ,
2136: p_action_information13 => per_formula_functions.get_number('F_TCCE'),
2137: p_action_information14 => per_formula_functions.get_number('F_TFCE'),
2138: p_action_information15 => per_formula_functions.get_number('G_CE'),
2139: p_action_information16 => per_formula_functions.get_number('I_COST'),
2140: p_action_information17 => per_formula_functions.get_number('I_AMG'),
2141: p_action_information18 => per_formula_functions.get_number('I_CE'),
2134: p_action_information11 => per_formula_functions.get_number('D_CE'),
2135: p_action_information12 => calculate_amap_ce ,
2136: p_action_information13 => per_formula_functions.get_number('F_TCCE'),
2137: p_action_information14 => per_formula_functions.get_number('F_TFCE'),
2138: p_action_information15 => per_formula_functions.get_number('G_CE'),
2139: p_action_information16 => per_formula_functions.get_number('I_COST'),
2140: p_action_information17 => per_formula_functions.get_number('I_AMG'),
2141: p_action_information18 => per_formula_functions.get_number('I_CE'),
2142: p_action_information19 => per_formula_functions.get_number('J_CE'),
2135: p_action_information12 => calculate_amap_ce ,
2136: p_action_information13 => per_formula_functions.get_number('F_TCCE'),
2137: p_action_information14 => per_formula_functions.get_number('F_TFCE'),
2138: p_action_information15 => per_formula_functions.get_number('G_CE'),
2139: p_action_information16 => per_formula_functions.get_number('I_COST'),
2140: p_action_information17 => per_formula_functions.get_number('I_AMG'),
2141: p_action_information18 => per_formula_functions.get_number('I_CE'),
2142: p_action_information19 => per_formula_functions.get_number('J_CE'),
2143: p_action_information20 => per_formula_functions.get_number('K_COST'),
2136: p_action_information13 => per_formula_functions.get_number('F_TCCE'),
2137: p_action_information14 => per_formula_functions.get_number('F_TFCE'),
2138: p_action_information15 => per_formula_functions.get_number('G_CE'),
2139: p_action_information16 => per_formula_functions.get_number('I_COST'),
2140: p_action_information17 => per_formula_functions.get_number('I_AMG'),
2141: p_action_information18 => per_formula_functions.get_number('I_CE'),
2142: p_action_information19 => per_formula_functions.get_number('J_CE'),
2143: p_action_information20 => per_formula_functions.get_number('K_COST'),
2144: p_action_information21 => per_formula_functions.get_number('K_AMG'),
2137: p_action_information14 => per_formula_functions.get_number('F_TFCE'),
2138: p_action_information15 => per_formula_functions.get_number('G_CE'),
2139: p_action_information16 => per_formula_functions.get_number('I_COST'),
2140: p_action_information17 => per_formula_functions.get_number('I_AMG'),
2141: p_action_information18 => per_formula_functions.get_number('I_CE'),
2142: p_action_information19 => per_formula_functions.get_number('J_CE'),
2143: p_action_information20 => per_formula_functions.get_number('K_COST'),
2144: p_action_information21 => per_formula_functions.get_number('K_AMG'),
2145: p_action_information22 => per_formula_functions.get_number('K_CE'),
2138: p_action_information15 => per_formula_functions.get_number('G_CE'),
2139: p_action_information16 => per_formula_functions.get_number('I_COST'),
2140: p_action_information17 => per_formula_functions.get_number('I_AMG'),
2141: p_action_information18 => per_formula_functions.get_number('I_CE'),
2142: p_action_information19 => per_formula_functions.get_number('J_CE'),
2143: p_action_information20 => per_formula_functions.get_number('K_COST'),
2144: p_action_information21 => per_formula_functions.get_number('K_AMG'),
2145: p_action_information22 => per_formula_functions.get_number('K_CE'),
2146: p_action_information23 => per_formula_functions.get_text('L_DESC'),
2139: p_action_information16 => per_formula_functions.get_number('I_COST'),
2140: p_action_information17 => per_formula_functions.get_number('I_AMG'),
2141: p_action_information18 => per_formula_functions.get_number('I_CE'),
2142: p_action_information19 => per_formula_functions.get_number('J_CE'),
2143: p_action_information20 => per_formula_functions.get_number('K_COST'),
2144: p_action_information21 => per_formula_functions.get_number('K_AMG'),
2145: p_action_information22 => per_formula_functions.get_number('K_CE'),
2146: p_action_information23 => per_formula_functions.get_text('L_DESC'),
2147: p_action_information24 => per_formula_functions.get_number('L_COST'),
2140: p_action_information17 => per_formula_functions.get_number('I_AMG'),
2141: p_action_information18 => per_formula_functions.get_number('I_CE'),
2142: p_action_information19 => per_formula_functions.get_number('J_CE'),
2143: p_action_information20 => per_formula_functions.get_number('K_COST'),
2144: p_action_information21 => per_formula_functions.get_number('K_AMG'),
2145: p_action_information22 => per_formula_functions.get_number('K_CE'),
2146: p_action_information23 => per_formula_functions.get_text('L_DESC'),
2147: p_action_information24 => per_formula_functions.get_number('L_COST'),
2148: p_action_information25 => per_formula_functions.get_number('L_AMG'),
2141: p_action_information18 => per_formula_functions.get_number('I_CE'),
2142: p_action_information19 => per_formula_functions.get_number('J_CE'),
2143: p_action_information20 => per_formula_functions.get_number('K_COST'),
2144: p_action_information21 => per_formula_functions.get_number('K_AMG'),
2145: p_action_information22 => per_formula_functions.get_number('K_CE'),
2146: p_action_information23 => per_formula_functions.get_text('L_DESC'),
2147: p_action_information24 => per_formula_functions.get_number('L_COST'),
2148: p_action_information25 => per_formula_functions.get_number('L_AMG'),
2149: p_action_information26 => per_formula_functions.get_number('L_CE'),
2142: p_action_information19 => per_formula_functions.get_number('J_CE'),
2143: p_action_information20 => per_formula_functions.get_number('K_COST'),
2144: p_action_information21 => per_formula_functions.get_number('K_AMG'),
2145: p_action_information22 => per_formula_functions.get_number('K_CE'),
2146: p_action_information23 => per_formula_functions.get_text('L_DESC'),
2147: p_action_information24 => per_formula_functions.get_number('L_COST'),
2148: p_action_information25 => per_formula_functions.get_number('L_AMG'),
2149: p_action_information26 => per_formula_functions.get_number('L_CE'),
2150: p_action_information27 => per_formula_functions.get_text('M_SHARES'),
2143: p_action_information20 => per_formula_functions.get_number('K_COST'),
2144: p_action_information21 => per_formula_functions.get_number('K_AMG'),
2145: p_action_information22 => per_formula_functions.get_number('K_CE'),
2146: p_action_information23 => per_formula_functions.get_text('L_DESC'),
2147: p_action_information24 => per_formula_functions.get_number('L_COST'),
2148: p_action_information25 => per_formula_functions.get_number('L_AMG'),
2149: p_action_information26 => per_formula_functions.get_number('L_CE'),
2150: p_action_information27 => per_formula_functions.get_text('M_SHARES'),
2151: p_action_information28 => per_formula_functions.get_number('H_CE1'),
2144: p_action_information21 => per_formula_functions.get_number('K_AMG'),
2145: p_action_information22 => per_formula_functions.get_number('K_CE'),
2146: p_action_information23 => per_formula_functions.get_text('L_DESC'),
2147: p_action_information24 => per_formula_functions.get_number('L_COST'),
2148: p_action_information25 => per_formula_functions.get_number('L_AMG'),
2149: p_action_information26 => per_formula_functions.get_number('L_CE'),
2150: p_action_information27 => per_formula_functions.get_text('M_SHARES'),
2151: p_action_information28 => per_formula_functions.get_number('H_CE1'),
2152: p_action_information29 => per_formula_functions.get_number('H_COUNT'),
2145: p_action_information22 => per_formula_functions.get_number('K_CE'),
2146: p_action_information23 => per_formula_functions.get_text('L_DESC'),
2147: p_action_information24 => per_formula_functions.get_number('L_COST'),
2148: p_action_information25 => per_formula_functions.get_number('L_AMG'),
2149: p_action_information26 => per_formula_functions.get_number('L_CE'),
2150: p_action_information27 => per_formula_functions.get_text('M_SHARES'),
2151: p_action_information28 => per_formula_functions.get_number('H_CE1'),
2152: p_action_information29 => per_formula_functions.get_number('H_COUNT'),
2153: p_action_information30 => per_formula_functions.get_number('F_COUNT') );
2146: p_action_information23 => per_formula_functions.get_text('L_DESC'),
2147: p_action_information24 => per_formula_functions.get_number('L_COST'),
2148: p_action_information25 => per_formula_functions.get_number('L_AMG'),
2149: p_action_information26 => per_formula_functions.get_number('L_CE'),
2150: p_action_information27 => per_formula_functions.get_text('M_SHARES'),
2151: p_action_information28 => per_formula_functions.get_number('H_CE1'),
2152: p_action_information29 => per_formula_functions.get_number('H_COUNT'),
2153: p_action_information30 => per_formula_functions.get_number('F_COUNT') );
2154: END IF;
2147: p_action_information24 => per_formula_functions.get_number('L_COST'),
2148: p_action_information25 => per_formula_functions.get_number('L_AMG'),
2149: p_action_information26 => per_formula_functions.get_number('L_CE'),
2150: p_action_information27 => per_formula_functions.get_text('M_SHARES'),
2151: p_action_information28 => per_formula_functions.get_number('H_CE1'),
2152: p_action_information29 => per_formula_functions.get_number('H_COUNT'),
2153: p_action_information30 => per_formula_functions.get_number('F_COUNT') );
2154: END IF;
2155:
2148: p_action_information25 => per_formula_functions.get_number('L_AMG'),
2149: p_action_information26 => per_formula_functions.get_number('L_CE'),
2150: p_action_information27 => per_formula_functions.get_text('M_SHARES'),
2151: p_action_information28 => per_formula_functions.get_number('H_CE1'),
2152: p_action_information29 => per_formula_functions.get_number('H_COUNT'),
2153: p_action_information30 => per_formula_functions.get_number('F_COUNT') );
2154: END IF;
2155:
2156: IF p_action_info_category = 'GB P11D ASSIGNMENT RESULTB'
2149: p_action_information26 => per_formula_functions.get_number('L_CE'),
2150: p_action_information27 => per_formula_functions.get_text('M_SHARES'),
2151: p_action_information28 => per_formula_functions.get_number('H_CE1'),
2152: p_action_information29 => per_formula_functions.get_number('H_COUNT'),
2153: p_action_information30 => per_formula_functions.get_number('F_COUNT') );
2154: END IF;
2155:
2156: IF p_action_info_category = 'GB P11D ASSIGNMENT RESULTB'
2157: THEN
2157: THEN
2158: pay_action_information_api.update_action_information(
2159: p_action_information_id => p_action_info_id,
2160: p_object_version_number => p_ovn,
2161: p_action_information1 => per_formula_functions.get_text('N_DESC'),
2162: p_action_information2 => per_formula_functions.get_number('N_COST'),
2163: p_action_information3 => per_formula_functions.get_number('N_AMG'),
2164: p_action_information4 => per_formula_functions.get_number('N_CE'),
2165: p_action_information5 => per_formula_functions.get_text('NA_DESC'),
2158: pay_action_information_api.update_action_information(
2159: p_action_information_id => p_action_info_id,
2160: p_object_version_number => p_ovn,
2161: p_action_information1 => per_formula_functions.get_text('N_DESC'),
2162: p_action_information2 => per_formula_functions.get_number('N_COST'),
2163: p_action_information3 => per_formula_functions.get_number('N_AMG'),
2164: p_action_information4 => per_formula_functions.get_number('N_CE'),
2165: p_action_information5 => per_formula_functions.get_text('NA_DESC'),
2166: p_action_information6 => per_formula_functions.get_number('NA_COST'),
2159: p_action_information_id => p_action_info_id,
2160: p_object_version_number => p_ovn,
2161: p_action_information1 => per_formula_functions.get_text('N_DESC'),
2162: p_action_information2 => per_formula_functions.get_number('N_COST'),
2163: p_action_information3 => per_formula_functions.get_number('N_AMG'),
2164: p_action_information4 => per_formula_functions.get_number('N_CE'),
2165: p_action_information5 => per_formula_functions.get_text('NA_DESC'),
2166: p_action_information6 => per_formula_functions.get_number('NA_COST'),
2167: p_action_information7 => per_formula_functions.get_number('NA_AMG'),
2160: p_object_version_number => p_ovn,
2161: p_action_information1 => per_formula_functions.get_text('N_DESC'),
2162: p_action_information2 => per_formula_functions.get_number('N_COST'),
2163: p_action_information3 => per_formula_functions.get_number('N_AMG'),
2164: p_action_information4 => per_formula_functions.get_number('N_CE'),
2165: p_action_information5 => per_formula_functions.get_text('NA_DESC'),
2166: p_action_information6 => per_formula_functions.get_number('NA_COST'),
2167: p_action_information7 => per_formula_functions.get_number('NA_AMG'),
2168: p_action_information8 => per_formula_functions.get_number('NA_CE'),
2161: p_action_information1 => per_formula_functions.get_text('N_DESC'),
2162: p_action_information2 => per_formula_functions.get_number('N_COST'),
2163: p_action_information3 => per_formula_functions.get_number('N_AMG'),
2164: p_action_information4 => per_formula_functions.get_number('N_CE'),
2165: p_action_information5 => per_formula_functions.get_text('NA_DESC'),
2166: p_action_information6 => per_formula_functions.get_number('NA_COST'),
2167: p_action_information7 => per_formula_functions.get_number('NA_AMG'),
2168: p_action_information8 => per_formula_functions.get_number('NA_CE'),
2169: p_action_information9 => per_formula_functions.get_number('N_TAXPAID'),
2162: p_action_information2 => per_formula_functions.get_number('N_COST'),
2163: p_action_information3 => per_formula_functions.get_number('N_AMG'),
2164: p_action_information4 => per_formula_functions.get_number('N_CE'),
2165: p_action_information5 => per_formula_functions.get_text('NA_DESC'),
2166: p_action_information6 => per_formula_functions.get_number('NA_COST'),
2167: p_action_information7 => per_formula_functions.get_number('NA_AMG'),
2168: p_action_information8 => per_formula_functions.get_number('NA_CE'),
2169: p_action_information9 => per_formula_functions.get_number('N_TAXPAID'),
2170: p_action_information10 => per_formula_functions.get_number('O1_COST'),
2163: p_action_information3 => per_formula_functions.get_number('N_AMG'),
2164: p_action_information4 => per_formula_functions.get_number('N_CE'),
2165: p_action_information5 => per_formula_functions.get_text('NA_DESC'),
2166: p_action_information6 => per_formula_functions.get_number('NA_COST'),
2167: p_action_information7 => per_formula_functions.get_number('NA_AMG'),
2168: p_action_information8 => per_formula_functions.get_number('NA_CE'),
2169: p_action_information9 => per_formula_functions.get_number('N_TAXPAID'),
2170: p_action_information10 => per_formula_functions.get_number('O1_COST'),
2171: p_action_information11 => per_formula_functions.get_number('O1_AMG'),
2164: p_action_information4 => per_formula_functions.get_number('N_CE'),
2165: p_action_information5 => per_formula_functions.get_text('NA_DESC'),
2166: p_action_information6 => per_formula_functions.get_number('NA_COST'),
2167: p_action_information7 => per_formula_functions.get_number('NA_AMG'),
2168: p_action_information8 => per_formula_functions.get_number('NA_CE'),
2169: p_action_information9 => per_formula_functions.get_number('N_TAXPAID'),
2170: p_action_information10 => per_formula_functions.get_number('O1_COST'),
2171: p_action_information11 => per_formula_functions.get_number('O1_AMG'),
2172: p_action_information12 => per_formula_functions.get_number('O1_CE'),
2165: p_action_information5 => per_formula_functions.get_text('NA_DESC'),
2166: p_action_information6 => per_formula_functions.get_number('NA_COST'),
2167: p_action_information7 => per_formula_functions.get_number('NA_AMG'),
2168: p_action_information8 => per_formula_functions.get_number('NA_CE'),
2169: p_action_information9 => per_formula_functions.get_number('N_TAXPAID'),
2170: p_action_information10 => per_formula_functions.get_number('O1_COST'),
2171: p_action_information11 => per_formula_functions.get_number('O1_AMG'),
2172: p_action_information12 => per_formula_functions.get_number('O1_CE'),
2173: p_action_information13 => per_formula_functions.get_number('O2_COST'),
2166: p_action_information6 => per_formula_functions.get_number('NA_COST'),
2167: p_action_information7 => per_formula_functions.get_number('NA_AMG'),
2168: p_action_information8 => per_formula_functions.get_number('NA_CE'),
2169: p_action_information9 => per_formula_functions.get_number('N_TAXPAID'),
2170: p_action_information10 => per_formula_functions.get_number('O1_COST'),
2171: p_action_information11 => per_formula_functions.get_number('O1_AMG'),
2172: p_action_information12 => per_formula_functions.get_number('O1_CE'),
2173: p_action_information13 => per_formula_functions.get_number('O2_COST'),
2174: p_action_information14 => per_formula_functions.get_number('O2_AMG'),
2167: p_action_information7 => per_formula_functions.get_number('NA_AMG'),
2168: p_action_information8 => per_formula_functions.get_number('NA_CE'),
2169: p_action_information9 => per_formula_functions.get_number('N_TAXPAID'),
2170: p_action_information10 => per_formula_functions.get_number('O1_COST'),
2171: p_action_information11 => per_formula_functions.get_number('O1_AMG'),
2172: p_action_information12 => per_formula_functions.get_number('O1_CE'),
2173: p_action_information13 => per_formula_functions.get_number('O2_COST'),
2174: p_action_information14 => per_formula_functions.get_number('O2_AMG'),
2175: p_action_information15 => per_formula_functions.get_number('O2_CE'),
2168: p_action_information8 => per_formula_functions.get_number('NA_CE'),
2169: p_action_information9 => per_formula_functions.get_number('N_TAXPAID'),
2170: p_action_information10 => per_formula_functions.get_number('O1_COST'),
2171: p_action_information11 => per_formula_functions.get_number('O1_AMG'),
2172: p_action_information12 => per_formula_functions.get_number('O1_CE'),
2173: p_action_information13 => per_formula_functions.get_number('O2_COST'),
2174: p_action_information14 => per_formula_functions.get_number('O2_AMG'),
2175: p_action_information15 => per_formula_functions.get_number('O2_CE'),
2176: p_action_information16 => per_formula_functions.get_text('O_TOI'),
2169: p_action_information9 => per_formula_functions.get_number('N_TAXPAID'),
2170: p_action_information10 => per_formula_functions.get_number('O1_COST'),
2171: p_action_information11 => per_formula_functions.get_number('O1_AMG'),
2172: p_action_information12 => per_formula_functions.get_number('O1_CE'),
2173: p_action_information13 => per_formula_functions.get_number('O2_COST'),
2174: p_action_information14 => per_formula_functions.get_number('O2_AMG'),
2175: p_action_information15 => per_formula_functions.get_number('O2_CE'),
2176: p_action_information16 => per_formula_functions.get_text('O_TOI'),
2177: p_action_information17 => per_formula_functions.get_number('O3_COST'),
2170: p_action_information10 => per_formula_functions.get_number('O1_COST'),
2171: p_action_information11 => per_formula_functions.get_number('O1_AMG'),
2172: p_action_information12 => per_formula_functions.get_number('O1_CE'),
2173: p_action_information13 => per_formula_functions.get_number('O2_COST'),
2174: p_action_information14 => per_formula_functions.get_number('O2_AMG'),
2175: p_action_information15 => per_formula_functions.get_number('O2_CE'),
2176: p_action_information16 => per_formula_functions.get_text('O_TOI'),
2177: p_action_information17 => per_formula_functions.get_number('O3_COST'),
2178: p_action_information18 => per_formula_functions.get_number('O3_AMG'),
2171: p_action_information11 => per_formula_functions.get_number('O1_AMG'),
2172: p_action_information12 => per_formula_functions.get_number('O1_CE'),
2173: p_action_information13 => per_formula_functions.get_number('O2_COST'),
2174: p_action_information14 => per_formula_functions.get_number('O2_AMG'),
2175: p_action_information15 => per_formula_functions.get_number('O2_CE'),
2176: p_action_information16 => per_formula_functions.get_text('O_TOI'),
2177: p_action_information17 => per_formula_functions.get_number('O3_COST'),
2178: p_action_information18 => per_formula_functions.get_number('O3_AMG'),
2179: p_action_information19 => per_formula_functions.get_number('O3_CE'),
2172: p_action_information12 => per_formula_functions.get_number('O1_CE'),
2173: p_action_information13 => per_formula_functions.get_number('O2_COST'),
2174: p_action_information14 => per_formula_functions.get_number('O2_AMG'),
2175: p_action_information15 => per_formula_functions.get_number('O2_CE'),
2176: p_action_information16 => per_formula_functions.get_text('O_TOI'),
2177: p_action_information17 => per_formula_functions.get_number('O3_COST'),
2178: p_action_information18 => per_formula_functions.get_number('O3_AMG'),
2179: p_action_information19 => per_formula_functions.get_number('O3_CE'),
2180: p_action_information20 => per_formula_functions.get_number('O4_COST'),
2173: p_action_information13 => per_formula_functions.get_number('O2_COST'),
2174: p_action_information14 => per_formula_functions.get_number('O2_AMG'),
2175: p_action_information15 => per_formula_functions.get_number('O2_CE'),
2176: p_action_information16 => per_formula_functions.get_text('O_TOI'),
2177: p_action_information17 => per_formula_functions.get_number('O3_COST'),
2178: p_action_information18 => per_formula_functions.get_number('O3_AMG'),
2179: p_action_information19 => per_formula_functions.get_number('O3_CE'),
2180: p_action_information20 => per_formula_functions.get_number('O4_COST'),
2181: p_action_information21 => per_formula_functions.get_number('O4_AMG'),
2174: p_action_information14 => per_formula_functions.get_number('O2_AMG'),
2175: p_action_information15 => per_formula_functions.get_number('O2_CE'),
2176: p_action_information16 => per_formula_functions.get_text('O_TOI'),
2177: p_action_information17 => per_formula_functions.get_number('O3_COST'),
2178: p_action_information18 => per_formula_functions.get_number('O3_AMG'),
2179: p_action_information19 => per_formula_functions.get_number('O3_CE'),
2180: p_action_information20 => per_formula_functions.get_number('O4_COST'),
2181: p_action_information21 => per_formula_functions.get_number('O4_AMG'),
2182: p_action_information22 => per_formula_functions.get_number('O4_CE'),
2175: p_action_information15 => per_formula_functions.get_number('O2_CE'),
2176: p_action_information16 => per_formula_functions.get_text('O_TOI'),
2177: p_action_information17 => per_formula_functions.get_number('O3_COST'),
2178: p_action_information18 => per_formula_functions.get_number('O3_AMG'),
2179: p_action_information19 => per_formula_functions.get_number('O3_CE'),
2180: p_action_information20 => per_formula_functions.get_number('O4_COST'),
2181: p_action_information21 => per_formula_functions.get_number('O4_AMG'),
2182: p_action_information22 => per_formula_functions.get_number('O4_CE'),
2183: p_action_information23 => per_formula_functions.get_number('O5_COST'),
2176: p_action_information16 => per_formula_functions.get_text('O_TOI'),
2177: p_action_information17 => per_formula_functions.get_number('O3_COST'),
2178: p_action_information18 => per_formula_functions.get_number('O3_AMG'),
2179: p_action_information19 => per_formula_functions.get_number('O3_CE'),
2180: p_action_information20 => per_formula_functions.get_number('O4_COST'),
2181: p_action_information21 => per_formula_functions.get_number('O4_AMG'),
2182: p_action_information22 => per_formula_functions.get_number('O4_CE'),
2183: p_action_information23 => per_formula_functions.get_number('O5_COST'),
2184: p_action_information24 => per_formula_functions.get_number('O5_AMG'),
2177: p_action_information17 => per_formula_functions.get_number('O3_COST'),
2178: p_action_information18 => per_formula_functions.get_number('O3_AMG'),
2179: p_action_information19 => per_formula_functions.get_number('O3_CE'),
2180: p_action_information20 => per_formula_functions.get_number('O4_COST'),
2181: p_action_information21 => per_formula_functions.get_number('O4_AMG'),
2182: p_action_information22 => per_formula_functions.get_number('O4_CE'),
2183: p_action_information23 => per_formula_functions.get_number('O5_COST'),
2184: p_action_information24 => per_formula_functions.get_number('O5_AMG'),
2185: p_action_information25 => per_formula_functions.get_number('O5_CE'),
2178: p_action_information18 => per_formula_functions.get_number('O3_AMG'),
2179: p_action_information19 => per_formula_functions.get_number('O3_CE'),
2180: p_action_information20 => per_formula_functions.get_number('O4_COST'),
2181: p_action_information21 => per_formula_functions.get_number('O4_AMG'),
2182: p_action_information22 => per_formula_functions.get_number('O4_CE'),
2183: p_action_information23 => per_formula_functions.get_number('O5_COST'),
2184: p_action_information24 => per_formula_functions.get_number('O5_AMG'),
2185: p_action_information25 => per_formula_functions.get_number('O5_CE'),
2186: p_action_information26 => per_formula_functions.get_text('O6_DESC'),
2179: p_action_information19 => per_formula_functions.get_number('O3_CE'),
2180: p_action_information20 => per_formula_functions.get_number('O4_COST'),
2181: p_action_information21 => per_formula_functions.get_number('O4_AMG'),
2182: p_action_information22 => per_formula_functions.get_number('O4_CE'),
2183: p_action_information23 => per_formula_functions.get_number('O5_COST'),
2184: p_action_information24 => per_formula_functions.get_number('O5_AMG'),
2185: p_action_information25 => per_formula_functions.get_number('O5_CE'),
2186: p_action_information26 => per_formula_functions.get_text('O6_DESC'),
2187: p_action_information27 => per_formula_functions.get_number('O6_COST'),
2180: p_action_information20 => per_formula_functions.get_number('O4_COST'),
2181: p_action_information21 => per_formula_functions.get_number('O4_AMG'),
2182: p_action_information22 => per_formula_functions.get_number('O4_CE'),
2183: p_action_information23 => per_formula_functions.get_number('O5_COST'),
2184: p_action_information24 => per_formula_functions.get_number('O5_AMG'),
2185: p_action_information25 => per_formula_functions.get_number('O5_CE'),
2186: p_action_information26 => per_formula_functions.get_text('O6_DESC'),
2187: p_action_information27 => per_formula_functions.get_number('O6_COST'),
2188: p_action_information28 => per_formula_functions.get_number('O6_AMG'),
2181: p_action_information21 => per_formula_functions.get_number('O4_AMG'),
2182: p_action_information22 => per_formula_functions.get_number('O4_CE'),
2183: p_action_information23 => per_formula_functions.get_number('O5_COST'),
2184: p_action_information24 => per_formula_functions.get_number('O5_AMG'),
2185: p_action_information25 => per_formula_functions.get_number('O5_CE'),
2186: p_action_information26 => per_formula_functions.get_text('O6_DESC'),
2187: p_action_information27 => per_formula_functions.get_number('O6_COST'),
2188: p_action_information28 => per_formula_functions.get_number('O6_AMG'),
2189: p_action_information29 => per_formula_functions.get_number('O6_CE') );
2182: p_action_information22 => per_formula_functions.get_number('O4_CE'),
2183: p_action_information23 => per_formula_functions.get_number('O5_COST'),
2184: p_action_information24 => per_formula_functions.get_number('O5_AMG'),
2185: p_action_information25 => per_formula_functions.get_number('O5_CE'),
2186: p_action_information26 => per_formula_functions.get_text('O6_DESC'),
2187: p_action_information27 => per_formula_functions.get_number('O6_COST'),
2188: p_action_information28 => per_formula_functions.get_number('O6_AMG'),
2189: p_action_information29 => per_formula_functions.get_number('O6_CE') );
2190: END IF;
2183: p_action_information23 => per_formula_functions.get_number('O5_COST'),
2184: p_action_information24 => per_formula_functions.get_number('O5_AMG'),
2185: p_action_information25 => per_formula_functions.get_number('O5_CE'),
2186: p_action_information26 => per_formula_functions.get_text('O6_DESC'),
2187: p_action_information27 => per_formula_functions.get_number('O6_COST'),
2188: p_action_information28 => per_formula_functions.get_number('O6_AMG'),
2189: p_action_information29 => per_formula_functions.get_number('O6_CE') );
2190: END IF;
2191:
2184: p_action_information24 => per_formula_functions.get_number('O5_AMG'),
2185: p_action_information25 => per_formula_functions.get_number('O5_CE'),
2186: p_action_information26 => per_formula_functions.get_text('O6_DESC'),
2187: p_action_information27 => per_formula_functions.get_number('O6_COST'),
2188: p_action_information28 => per_formula_functions.get_number('O6_AMG'),
2189: p_action_information29 => per_formula_functions.get_number('O6_CE') );
2190: END IF;
2191:
2192: IF p_action_info_category = 'GB P11D ASSIGNMENT RESULTC'
2185: p_action_information25 => per_formula_functions.get_number('O5_CE'),
2186: p_action_information26 => per_formula_functions.get_text('O6_DESC'),
2187: p_action_information27 => per_formula_functions.get_number('O6_COST'),
2188: p_action_information28 => per_formula_functions.get_number('O6_AMG'),
2189: p_action_information29 => per_formula_functions.get_number('O6_CE') );
2190: END IF;
2191:
2192: IF p_action_info_category = 'GB P11D ASSIGNMENT RESULTC'
2193: THEN
2193: THEN
2194: pay_action_information_api.update_action_information(
2195: p_action_information_id => p_action_info_id,
2196: p_object_version_number => p_ovn,
2197: p_action_information1 => per_formula_functions.get_number('C_BUS_MILES'),
2198: p_action_information2 => per_formula_functions.get_number('M_BUS_MILES'),
2199: p_action_information3 => per_formula_functions.get_number('B_BUS_MILES'),
2200: p_action_information4 => per_formula_functions.get_number('C_RATE1'),
2201: p_action_information5 => per_formula_functions.get_number('C_RATE2'),
2194: pay_action_information_api.update_action_information(
2195: p_action_information_id => p_action_info_id,
2196: p_object_version_number => p_ovn,
2197: p_action_information1 => per_formula_functions.get_number('C_BUS_MILES'),
2198: p_action_information2 => per_formula_functions.get_number('M_BUS_MILES'),
2199: p_action_information3 => per_formula_functions.get_number('B_BUS_MILES'),
2200: p_action_information4 => per_formula_functions.get_number('C_RATE1'),
2201: p_action_information5 => per_formula_functions.get_number('C_RATE2'),
2202: p_action_information6 => per_formula_functions.get_number('M_RATE1'),
2195: p_action_information_id => p_action_info_id,
2196: p_object_version_number => p_ovn,
2197: p_action_information1 => per_formula_functions.get_number('C_BUS_MILES'),
2198: p_action_information2 => per_formula_functions.get_number('M_BUS_MILES'),
2199: p_action_information3 => per_formula_functions.get_number('B_BUS_MILES'),
2200: p_action_information4 => per_formula_functions.get_number('C_RATE1'),
2201: p_action_information5 => per_formula_functions.get_number('C_RATE2'),
2202: p_action_information6 => per_formula_functions.get_number('M_RATE1'),
2203: p_action_information7 => per_formula_functions.get_number('M_RATE2'),
2196: p_object_version_number => p_ovn,
2197: p_action_information1 => per_formula_functions.get_number('C_BUS_MILES'),
2198: p_action_information2 => per_formula_functions.get_number('M_BUS_MILES'),
2199: p_action_information3 => per_formula_functions.get_number('B_BUS_MILES'),
2200: p_action_information4 => per_formula_functions.get_number('C_RATE1'),
2201: p_action_information5 => per_formula_functions.get_number('C_RATE2'),
2202: p_action_information6 => per_formula_functions.get_number('M_RATE1'),
2203: p_action_information7 => per_formula_functions.get_number('M_RATE2'),
2204: p_action_information8 => per_formula_functions.get_number('B_RATE1'),
2197: p_action_information1 => per_formula_functions.get_number('C_BUS_MILES'),
2198: p_action_information2 => per_formula_functions.get_number('M_BUS_MILES'),
2199: p_action_information3 => per_formula_functions.get_number('B_BUS_MILES'),
2200: p_action_information4 => per_formula_functions.get_number('C_RATE1'),
2201: p_action_information5 => per_formula_functions.get_number('C_RATE2'),
2202: p_action_information6 => per_formula_functions.get_number('M_RATE1'),
2203: p_action_information7 => per_formula_functions.get_number('M_RATE2'),
2204: p_action_information8 => per_formula_functions.get_number('B_RATE1'),
2205: p_action_information9 => per_formula_functions.get_number('B_RATE2'),
2198: p_action_information2 => per_formula_functions.get_number('M_BUS_MILES'),
2199: p_action_information3 => per_formula_functions.get_number('B_BUS_MILES'),
2200: p_action_information4 => per_formula_functions.get_number('C_RATE1'),
2201: p_action_information5 => per_formula_functions.get_number('C_RATE2'),
2202: p_action_information6 => per_formula_functions.get_number('M_RATE1'),
2203: p_action_information7 => per_formula_functions.get_number('M_RATE2'),
2204: p_action_information8 => per_formula_functions.get_number('B_RATE1'),
2205: p_action_information9 => per_formula_functions.get_number('B_RATE2'),
2206: p_action_information10 => per_formula_functions.get_text('DT_FREE_FUEL_WITHDRAWN'),
2199: p_action_information3 => per_formula_functions.get_number('B_BUS_MILES'),
2200: p_action_information4 => per_formula_functions.get_number('C_RATE1'),
2201: p_action_information5 => per_formula_functions.get_number('C_RATE2'),
2202: p_action_information6 => per_formula_functions.get_number('M_RATE1'),
2203: p_action_information7 => per_formula_functions.get_number('M_RATE2'),
2204: p_action_information8 => per_formula_functions.get_number('B_RATE1'),
2205: p_action_information9 => per_formula_functions.get_number('B_RATE2'),
2206: p_action_information10 => per_formula_functions.get_text('DT_FREE_FUEL_WITHDRAWN'),
2207: p_action_information11 => per_formula_functions.get_text('FREE_FUEL_REINSTATED'),
2200: p_action_information4 => per_formula_functions.get_number('C_RATE1'),
2201: p_action_information5 => per_formula_functions.get_number('C_RATE2'),
2202: p_action_information6 => per_formula_functions.get_number('M_RATE1'),
2203: p_action_information7 => per_formula_functions.get_number('M_RATE2'),
2204: p_action_information8 => per_formula_functions.get_number('B_RATE1'),
2205: p_action_information9 => per_formula_functions.get_number('B_RATE2'),
2206: p_action_information10 => per_formula_functions.get_text('DT_FREE_FUEL_WITHDRAWN'),
2207: p_action_information11 => per_formula_functions.get_text('FREE_FUEL_REINSTATED'),
2208: p_action_information12 => per_formula_functions.get_number('C_MILEAGE_PAYMENTS'),
2201: p_action_information5 => per_formula_functions.get_number('C_RATE2'),
2202: p_action_information6 => per_formula_functions.get_number('M_RATE1'),
2203: p_action_information7 => per_formula_functions.get_number('M_RATE2'),
2204: p_action_information8 => per_formula_functions.get_number('B_RATE1'),
2205: p_action_information9 => per_formula_functions.get_number('B_RATE2'),
2206: p_action_information10 => per_formula_functions.get_text('DT_FREE_FUEL_WITHDRAWN'),
2207: p_action_information11 => per_formula_functions.get_text('FREE_FUEL_REINSTATED'),
2208: p_action_information12 => per_formula_functions.get_number('C_MILEAGE_PAYMENTS'),
2209: p_action_information13 => per_formula_functions.get_number('B_MILEAGE_PAYMENTS'),
2202: p_action_information6 => per_formula_functions.get_number('M_RATE1'),
2203: p_action_information7 => per_formula_functions.get_number('M_RATE2'),
2204: p_action_information8 => per_formula_functions.get_number('B_RATE1'),
2205: p_action_information9 => per_formula_functions.get_number('B_RATE2'),
2206: p_action_information10 => per_formula_functions.get_text('DT_FREE_FUEL_WITHDRAWN'),
2207: p_action_information11 => per_formula_functions.get_text('FREE_FUEL_REINSTATED'),
2208: p_action_information12 => per_formula_functions.get_number('C_MILEAGE_PAYMENTS'),
2209: p_action_information13 => per_formula_functions.get_number('B_MILEAGE_PAYMENTS'),
2210: p_action_information14 => per_formula_functions.get_number('M_MILEAGE_PAYMENTS'),
2203: p_action_information7 => per_formula_functions.get_number('M_RATE2'),
2204: p_action_information8 => per_formula_functions.get_number('B_RATE1'),
2205: p_action_information9 => per_formula_functions.get_number('B_RATE2'),
2206: p_action_information10 => per_formula_functions.get_text('DT_FREE_FUEL_WITHDRAWN'),
2207: p_action_information11 => per_formula_functions.get_text('FREE_FUEL_REINSTATED'),
2208: p_action_information12 => per_formula_functions.get_number('C_MILEAGE_PAYMENTS'),
2209: p_action_information13 => per_formula_functions.get_number('B_MILEAGE_PAYMENTS'),
2210: p_action_information14 => per_formula_functions.get_number('M_MILEAGE_PAYMENTS'),
2211: p_action_information15 => per_formula_functions.get_number('MARORS_COUNT'),
2204: p_action_information8 => per_formula_functions.get_number('B_RATE1'),
2205: p_action_information9 => per_formula_functions.get_number('B_RATE2'),
2206: p_action_information10 => per_formula_functions.get_text('DT_FREE_FUEL_WITHDRAWN'),
2207: p_action_information11 => per_formula_functions.get_text('FREE_FUEL_REINSTATED'),
2208: p_action_information12 => per_formula_functions.get_number('C_MILEAGE_PAYMENTS'),
2209: p_action_information13 => per_formula_functions.get_number('B_MILEAGE_PAYMENTS'),
2210: p_action_information14 => per_formula_functions.get_number('M_MILEAGE_PAYMENTS'),
2211: p_action_information15 => per_formula_functions.get_number('MARORS_COUNT'),
2212: p_action_information16 => per_formula_functions.get_number('C_TAX_DEDUCTED'),
2205: p_action_information9 => per_formula_functions.get_number('B_RATE2'),
2206: p_action_information10 => per_formula_functions.get_text('DT_FREE_FUEL_WITHDRAWN'),
2207: p_action_information11 => per_formula_functions.get_text('FREE_FUEL_REINSTATED'),
2208: p_action_information12 => per_formula_functions.get_number('C_MILEAGE_PAYMENTS'),
2209: p_action_information13 => per_formula_functions.get_number('B_MILEAGE_PAYMENTS'),
2210: p_action_information14 => per_formula_functions.get_number('M_MILEAGE_PAYMENTS'),
2211: p_action_information15 => per_formula_functions.get_number('MARORS_COUNT'),
2212: p_action_information16 => per_formula_functions.get_number('C_TAX_DEDUCTED'),
2213: p_action_information17 => per_formula_functions.get_number('B_TAX_DEDUCTED'),
2206: p_action_information10 => per_formula_functions.get_text('DT_FREE_FUEL_WITHDRAWN'),
2207: p_action_information11 => per_formula_functions.get_text('FREE_FUEL_REINSTATED'),
2208: p_action_information12 => per_formula_functions.get_number('C_MILEAGE_PAYMENTS'),
2209: p_action_information13 => per_formula_functions.get_number('B_MILEAGE_PAYMENTS'),
2210: p_action_information14 => per_formula_functions.get_number('M_MILEAGE_PAYMENTS'),
2211: p_action_information15 => per_formula_functions.get_number('MARORS_COUNT'),
2212: p_action_information16 => per_formula_functions.get_number('C_TAX_DEDUCTED'),
2213: p_action_information17 => per_formula_functions.get_number('B_TAX_DEDUCTED'),
2214: p_action_information18 => per_formula_functions.get_number('M_TAX_DEDUCTED'),
2207: p_action_information11 => per_formula_functions.get_text('FREE_FUEL_REINSTATED'),
2208: p_action_information12 => per_formula_functions.get_number('C_MILEAGE_PAYMENTS'),
2209: p_action_information13 => per_formula_functions.get_number('B_MILEAGE_PAYMENTS'),
2210: p_action_information14 => per_formula_functions.get_number('M_MILEAGE_PAYMENTS'),
2211: p_action_information15 => per_formula_functions.get_number('MARORS_COUNT'),
2212: p_action_information16 => per_formula_functions.get_number('C_TAX_DEDUCTED'),
2213: p_action_information17 => per_formula_functions.get_number('B_TAX_DEDUCTED'),
2214: p_action_information18 => per_formula_functions.get_number('M_TAX_DEDUCTED'),
2215: p_action_information19 => per_formula_functions.get_number('PASSENGER_PAYMENTS'),
2208: p_action_information12 => per_formula_functions.get_number('C_MILEAGE_PAYMENTS'),
2209: p_action_information13 => per_formula_functions.get_number('B_MILEAGE_PAYMENTS'),
2210: p_action_information14 => per_formula_functions.get_number('M_MILEAGE_PAYMENTS'),
2211: p_action_information15 => per_formula_functions.get_number('MARORS_COUNT'),
2212: p_action_information16 => per_formula_functions.get_number('C_TAX_DEDUCTED'),
2213: p_action_information17 => per_formula_functions.get_number('B_TAX_DEDUCTED'),
2214: p_action_information18 => per_formula_functions.get_number('M_TAX_DEDUCTED'),
2215: p_action_information19 => per_formula_functions.get_number('PASSENGER_PAYMENTS'),
2216: p_action_information20 => per_formula_functions.get_number('PASSENGER_BUS_MILES'),
2209: p_action_information13 => per_formula_functions.get_number('B_MILEAGE_PAYMENTS'),
2210: p_action_information14 => per_formula_functions.get_number('M_MILEAGE_PAYMENTS'),
2211: p_action_information15 => per_formula_functions.get_number('MARORS_COUNT'),
2212: p_action_information16 => per_formula_functions.get_number('C_TAX_DEDUCTED'),
2213: p_action_information17 => per_formula_functions.get_number('B_TAX_DEDUCTED'),
2214: p_action_information18 => per_formula_functions.get_number('M_TAX_DEDUCTED'),
2215: p_action_information19 => per_formula_functions.get_number('PASSENGER_PAYMENTS'),
2216: p_action_information20 => per_formula_functions.get_number('PASSENGER_BUS_MILES'),
2217: p_action_information21 => per_formula_functions.get_number('PASSENGER_BUS_MILE_AMT'),
2210: p_action_information14 => per_formula_functions.get_number('M_MILEAGE_PAYMENTS'),
2211: p_action_information15 => per_formula_functions.get_number('MARORS_COUNT'),
2212: p_action_information16 => per_formula_functions.get_number('C_TAX_DEDUCTED'),
2213: p_action_information17 => per_formula_functions.get_number('B_TAX_DEDUCTED'),
2214: p_action_information18 => per_formula_functions.get_number('M_TAX_DEDUCTED'),
2215: p_action_information19 => per_formula_functions.get_number('PASSENGER_PAYMENTS'),
2216: p_action_information20 => per_formula_functions.get_number('PASSENGER_BUS_MILES'),
2217: p_action_information21 => per_formula_functions.get_number('PASSENGER_BUS_MILE_AMT'),
2218: p_action_information22 => per_formula_functions.get_number('MILEAGE_ALLOWANCE_RELIEF'),
2211: p_action_information15 => per_formula_functions.get_number('MARORS_COUNT'),
2212: p_action_information16 => per_formula_functions.get_number('C_TAX_DEDUCTED'),
2213: p_action_information17 => per_formula_functions.get_number('B_TAX_DEDUCTED'),
2214: p_action_information18 => per_formula_functions.get_number('M_TAX_DEDUCTED'),
2215: p_action_information19 => per_formula_functions.get_number('PASSENGER_PAYMENTS'),
2216: p_action_information20 => per_formula_functions.get_number('PASSENGER_BUS_MILES'),
2217: p_action_information21 => per_formula_functions.get_number('PASSENGER_BUS_MILE_AMT'),
2218: p_action_information22 => per_formula_functions.get_number('MILEAGE_ALLOWANCE_RELIEF'),
2219: p_action_information23 => per_formula_functions.get_number('INT_MAX_AMT_OUTSTANDING')
2212: p_action_information16 => per_formula_functions.get_number('C_TAX_DEDUCTED'),
2213: p_action_information17 => per_formula_functions.get_number('B_TAX_DEDUCTED'),
2214: p_action_information18 => per_formula_functions.get_number('M_TAX_DEDUCTED'),
2215: p_action_information19 => per_formula_functions.get_number('PASSENGER_PAYMENTS'),
2216: p_action_information20 => per_formula_functions.get_number('PASSENGER_BUS_MILES'),
2217: p_action_information21 => per_formula_functions.get_number('PASSENGER_BUS_MILE_AMT'),
2218: p_action_information22 => per_formula_functions.get_number('MILEAGE_ALLOWANCE_RELIEF'),
2219: p_action_information23 => per_formula_functions.get_number('INT_MAX_AMT_OUTSTANDING')
2220: );
2213: p_action_information17 => per_formula_functions.get_number('B_TAX_DEDUCTED'),
2214: p_action_information18 => per_formula_functions.get_number('M_TAX_DEDUCTED'),
2215: p_action_information19 => per_formula_functions.get_number('PASSENGER_PAYMENTS'),
2216: p_action_information20 => per_formula_functions.get_number('PASSENGER_BUS_MILES'),
2217: p_action_information21 => per_formula_functions.get_number('PASSENGER_BUS_MILE_AMT'),
2218: p_action_information22 => per_formula_functions.get_number('MILEAGE_ALLOWANCE_RELIEF'),
2219: p_action_information23 => per_formula_functions.get_number('INT_MAX_AMT_OUTSTANDING')
2220: );
2221: END IF;
2214: p_action_information18 => per_formula_functions.get_number('M_TAX_DEDUCTED'),
2215: p_action_information19 => per_formula_functions.get_number('PASSENGER_PAYMENTS'),
2216: p_action_information20 => per_formula_functions.get_number('PASSENGER_BUS_MILES'),
2217: p_action_information21 => per_formula_functions.get_number('PASSENGER_BUS_MILE_AMT'),
2218: p_action_information22 => per_formula_functions.get_number('MILEAGE_ALLOWANCE_RELIEF'),
2219: p_action_information23 => per_formula_functions.get_number('INT_MAX_AMT_OUTSTANDING')
2220: );
2221: END IF;
2222: else
2215: p_action_information19 => per_formula_functions.get_number('PASSENGER_PAYMENTS'),
2216: p_action_information20 => per_formula_functions.get_number('PASSENGER_BUS_MILES'),
2217: p_action_information21 => per_formula_functions.get_number('PASSENGER_BUS_MILE_AMT'),
2218: p_action_information22 => per_formula_functions.get_number('MILEAGE_ALLOWANCE_RELIEF'),
2219: p_action_information23 => per_formula_functions.get_number('INT_MAX_AMT_OUTSTANDING')
2220: );
2221: END IF;
2222: else
2223: /* Code for year 04/05 onwards */
2225: THEN
2226: pay_action_information_api.update_action_information(
2227: p_action_information_id => p_action_info_id,
2228: p_object_version_number => p_ovn,
2229: p_action_information1 => per_formula_functions.get_text('A_DESC'),
2230: p_action_information2 => per_formula_functions.get_number('A_COST'),
2231: p_action_information3 => per_formula_functions.get_number('A_AMG'),
2232: p_action_information4 => per_formula_functions.get_number('A_CE'),
2233: p_action_information5 => per_formula_functions.get_text('B_DESC'),
2226: pay_action_information_api.update_action_information(
2227: p_action_information_id => p_action_info_id,
2228: p_object_version_number => p_ovn,
2229: p_action_information1 => per_formula_functions.get_text('A_DESC'),
2230: p_action_information2 => per_formula_functions.get_number('A_COST'),
2231: p_action_information3 => per_formula_functions.get_number('A_AMG'),
2232: p_action_information4 => per_formula_functions.get_number('A_CE'),
2233: p_action_information5 => per_formula_functions.get_text('B_DESC'),
2234: p_action_information6 => per_formula_functions.get_number('B_CE'),
2227: p_action_information_id => p_action_info_id,
2228: p_object_version_number => p_ovn,
2229: p_action_information1 => per_formula_functions.get_text('A_DESC'),
2230: p_action_information2 => per_formula_functions.get_number('A_COST'),
2231: p_action_information3 => per_formula_functions.get_number('A_AMG'),
2232: p_action_information4 => per_formula_functions.get_number('A_CE'),
2233: p_action_information5 => per_formula_functions.get_text('B_DESC'),
2234: p_action_information6 => per_formula_functions.get_number('B_CE'),
2235: p_action_information7 => per_formula_functions.get_number('B_TNP'),
2228: p_object_version_number => p_ovn,
2229: p_action_information1 => per_formula_functions.get_text('A_DESC'),
2230: p_action_information2 => per_formula_functions.get_number('A_COST'),
2231: p_action_information3 => per_formula_functions.get_number('A_AMG'),
2232: p_action_information4 => per_formula_functions.get_number('A_CE'),
2233: p_action_information5 => per_formula_functions.get_text('B_DESC'),
2234: p_action_information6 => per_formula_functions.get_number('B_CE'),
2235: p_action_information7 => per_formula_functions.get_number('B_TNP'),
2236: p_action_information8 => per_formula_functions.get_number('C_COST'),
2229: p_action_information1 => per_formula_functions.get_text('A_DESC'),
2230: p_action_information2 => per_formula_functions.get_number('A_COST'),
2231: p_action_information3 => per_formula_functions.get_number('A_AMG'),
2232: p_action_information4 => per_formula_functions.get_number('A_CE'),
2233: p_action_information5 => per_formula_functions.get_text('B_DESC'),
2234: p_action_information6 => per_formula_functions.get_number('B_CE'),
2235: p_action_information7 => per_formula_functions.get_number('B_TNP'),
2236: p_action_information8 => per_formula_functions.get_number('C_COST'),
2237: p_action_information9 => per_formula_functions.get_number('C_AMG'),
2230: p_action_information2 => per_formula_functions.get_number('A_COST'),
2231: p_action_information3 => per_formula_functions.get_number('A_AMG'),
2232: p_action_information4 => per_formula_functions.get_number('A_CE'),
2233: p_action_information5 => per_formula_functions.get_text('B_DESC'),
2234: p_action_information6 => per_formula_functions.get_number('B_CE'),
2235: p_action_information7 => per_formula_functions.get_number('B_TNP'),
2236: p_action_information8 => per_formula_functions.get_number('C_COST'),
2237: p_action_information9 => per_formula_functions.get_number('C_AMG'),
2238: p_action_information10 => per_formula_functions.get_number('C_CE'),
2231: p_action_information3 => per_formula_functions.get_number('A_AMG'),
2232: p_action_information4 => per_formula_functions.get_number('A_CE'),
2233: p_action_information5 => per_formula_functions.get_text('B_DESC'),
2234: p_action_information6 => per_formula_functions.get_number('B_CE'),
2235: p_action_information7 => per_formula_functions.get_number('B_TNP'),
2236: p_action_information8 => per_formula_functions.get_number('C_COST'),
2237: p_action_information9 => per_formula_functions.get_number('C_AMG'),
2238: p_action_information10 => per_formula_functions.get_number('C_CE'),
2239: p_action_information11 => per_formula_functions.get_number('D_CE'),
2232: p_action_information4 => per_formula_functions.get_number('A_CE'),
2233: p_action_information5 => per_formula_functions.get_text('B_DESC'),
2234: p_action_information6 => per_formula_functions.get_number('B_CE'),
2235: p_action_information7 => per_formula_functions.get_number('B_TNP'),
2236: p_action_information8 => per_formula_functions.get_number('C_COST'),
2237: p_action_information9 => per_formula_functions.get_number('C_AMG'),
2238: p_action_information10 => per_formula_functions.get_number('C_CE'),
2239: p_action_information11 => per_formula_functions.get_number('D_CE'),
2240: p_action_information12 => calculate_amap_ce ,
2233: p_action_information5 => per_formula_functions.get_text('B_DESC'),
2234: p_action_information6 => per_formula_functions.get_number('B_CE'),
2235: p_action_information7 => per_formula_functions.get_number('B_TNP'),
2236: p_action_information8 => per_formula_functions.get_number('C_COST'),
2237: p_action_information9 => per_formula_functions.get_number('C_AMG'),
2238: p_action_information10 => per_formula_functions.get_number('C_CE'),
2239: p_action_information11 => per_formula_functions.get_number('D_CE'),
2240: p_action_information12 => calculate_amap_ce ,
2241: p_action_information13 => per_formula_functions.get_number('F_TCCE'),
2234: p_action_information6 => per_formula_functions.get_number('B_CE'),
2235: p_action_information7 => per_formula_functions.get_number('B_TNP'),
2236: p_action_information8 => per_formula_functions.get_number('C_COST'),
2237: p_action_information9 => per_formula_functions.get_number('C_AMG'),
2238: p_action_information10 => per_formula_functions.get_number('C_CE'),
2239: p_action_information11 => per_formula_functions.get_number('D_CE'),
2240: p_action_information12 => calculate_amap_ce ,
2241: p_action_information13 => per_formula_functions.get_number('F_TCCE'),
2242: p_action_information14 => per_formula_functions.get_number('F_TFCE'),
2235: p_action_information7 => per_formula_functions.get_number('B_TNP'),
2236: p_action_information8 => per_formula_functions.get_number('C_COST'),
2237: p_action_information9 => per_formula_functions.get_number('C_AMG'),
2238: p_action_information10 => per_formula_functions.get_number('C_CE'),
2239: p_action_information11 => per_formula_functions.get_number('D_CE'),
2240: p_action_information12 => calculate_amap_ce ,
2241: p_action_information13 => per_formula_functions.get_number('F_TCCE'),
2242: p_action_information14 => per_formula_functions.get_number('F_TFCE'),
2243: p_action_information15 => per_formula_functions.get_number('G_CE'),
2237: p_action_information9 => per_formula_functions.get_number('C_AMG'),
2238: p_action_information10 => per_formula_functions.get_number('C_CE'),
2239: p_action_information11 => per_formula_functions.get_number('D_CE'),
2240: p_action_information12 => calculate_amap_ce ,
2241: p_action_information13 => per_formula_functions.get_number('F_TCCE'),
2242: p_action_information14 => per_formula_functions.get_number('F_TFCE'),
2243: p_action_information15 => per_formula_functions.get_number('G_CE'),
2244: p_action_information16 => per_formula_functions.get_number('I_COST'),
2245: p_action_information17 => per_formula_functions.get_number('I_AMG'),
2238: p_action_information10 => per_formula_functions.get_number('C_CE'),
2239: p_action_information11 => per_formula_functions.get_number('D_CE'),
2240: p_action_information12 => calculate_amap_ce ,
2241: p_action_information13 => per_formula_functions.get_number('F_TCCE'),
2242: p_action_information14 => per_formula_functions.get_number('F_TFCE'),
2243: p_action_information15 => per_formula_functions.get_number('G_CE'),
2244: p_action_information16 => per_formula_functions.get_number('I_COST'),
2245: p_action_information17 => per_formula_functions.get_number('I_AMG'),
2246: p_action_information18 => per_formula_functions.get_number('I_CE'),
2239: p_action_information11 => per_formula_functions.get_number('D_CE'),
2240: p_action_information12 => calculate_amap_ce ,
2241: p_action_information13 => per_formula_functions.get_number('F_TCCE'),
2242: p_action_information14 => per_formula_functions.get_number('F_TFCE'),
2243: p_action_information15 => per_formula_functions.get_number('G_CE'),
2244: p_action_information16 => per_formula_functions.get_number('I_COST'),
2245: p_action_information17 => per_formula_functions.get_number('I_AMG'),
2246: p_action_information18 => per_formula_functions.get_number('I_CE'),
2247: p_action_information19 => per_formula_functions.get_number('J_CE'),
2240: p_action_information12 => calculate_amap_ce ,
2241: p_action_information13 => per_formula_functions.get_number('F_TCCE'),
2242: p_action_information14 => per_formula_functions.get_number('F_TFCE'),
2243: p_action_information15 => per_formula_functions.get_number('G_CE'),
2244: p_action_information16 => per_formula_functions.get_number('I_COST'),
2245: p_action_information17 => per_formula_functions.get_number('I_AMG'),
2246: p_action_information18 => per_formula_functions.get_number('I_CE'),
2247: p_action_information19 => per_formula_functions.get_number('J_CE'),
2248: p_action_information20 => per_formula_functions.get_number('K_COST'),
2241: p_action_information13 => per_formula_functions.get_number('F_TCCE'),
2242: p_action_information14 => per_formula_functions.get_number('F_TFCE'),
2243: p_action_information15 => per_formula_functions.get_number('G_CE'),
2244: p_action_information16 => per_formula_functions.get_number('I_COST'),
2245: p_action_information17 => per_formula_functions.get_number('I_AMG'),
2246: p_action_information18 => per_formula_functions.get_number('I_CE'),
2247: p_action_information19 => per_formula_functions.get_number('J_CE'),
2248: p_action_information20 => per_formula_functions.get_number('K_COST'),
2249: p_action_information21 => per_formula_functions.get_number('K_AMG'),
2242: p_action_information14 => per_formula_functions.get_number('F_TFCE'),
2243: p_action_information15 => per_formula_functions.get_number('G_CE'),
2244: p_action_information16 => per_formula_functions.get_number('I_COST'),
2245: p_action_information17 => per_formula_functions.get_number('I_AMG'),
2246: p_action_information18 => per_formula_functions.get_number('I_CE'),
2247: p_action_information19 => per_formula_functions.get_number('J_CE'),
2248: p_action_information20 => per_formula_functions.get_number('K_COST'),
2249: p_action_information21 => per_formula_functions.get_number('K_AMG'),
2250: p_action_information22 => per_formula_functions.get_number('K_CE'),
2243: p_action_information15 => per_formula_functions.get_number('G_CE'),
2244: p_action_information16 => per_formula_functions.get_number('I_COST'),
2245: p_action_information17 => per_formula_functions.get_number('I_AMG'),
2246: p_action_information18 => per_formula_functions.get_number('I_CE'),
2247: p_action_information19 => per_formula_functions.get_number('J_CE'),
2248: p_action_information20 => per_formula_functions.get_number('K_COST'),
2249: p_action_information21 => per_formula_functions.get_number('K_AMG'),
2250: p_action_information22 => per_formula_functions.get_number('K_CE'),
2251: p_action_information23 => per_formula_functions.get_text('L_DESC'),
2244: p_action_information16 => per_formula_functions.get_number('I_COST'),
2245: p_action_information17 => per_formula_functions.get_number('I_AMG'),
2246: p_action_information18 => per_formula_functions.get_number('I_CE'),
2247: p_action_information19 => per_formula_functions.get_number('J_CE'),
2248: p_action_information20 => per_formula_functions.get_number('K_COST'),
2249: p_action_information21 => per_formula_functions.get_number('K_AMG'),
2250: p_action_information22 => per_formula_functions.get_number('K_CE'),
2251: p_action_information23 => per_formula_functions.get_text('L_DESC'),
2252: p_action_information24 => per_formula_functions.get_number('L_COST'),
2245: p_action_information17 => per_formula_functions.get_number('I_AMG'),
2246: p_action_information18 => per_formula_functions.get_number('I_CE'),
2247: p_action_information19 => per_formula_functions.get_number('J_CE'),
2248: p_action_information20 => per_formula_functions.get_number('K_COST'),
2249: p_action_information21 => per_formula_functions.get_number('K_AMG'),
2250: p_action_information22 => per_formula_functions.get_number('K_CE'),
2251: p_action_information23 => per_formula_functions.get_text('L_DESC'),
2252: p_action_information24 => per_formula_functions.get_number('L_COST'),
2253: p_action_information25 => per_formula_functions.get_number('L_AMG'),
2246: p_action_information18 => per_formula_functions.get_number('I_CE'),
2247: p_action_information19 => per_formula_functions.get_number('J_CE'),
2248: p_action_information20 => per_formula_functions.get_number('K_COST'),
2249: p_action_information21 => per_formula_functions.get_number('K_AMG'),
2250: p_action_information22 => per_formula_functions.get_number('K_CE'),
2251: p_action_information23 => per_formula_functions.get_text('L_DESC'),
2252: p_action_information24 => per_formula_functions.get_number('L_COST'),
2253: p_action_information25 => per_formula_functions.get_number('L_AMG'),
2254: p_action_information26 => per_formula_functions.get_number('L_CE'),
2247: p_action_information19 => per_formula_functions.get_number('J_CE'),
2248: p_action_information20 => per_formula_functions.get_number('K_COST'),
2249: p_action_information21 => per_formula_functions.get_number('K_AMG'),
2250: p_action_information22 => per_formula_functions.get_number('K_CE'),
2251: p_action_information23 => per_formula_functions.get_text('L_DESC'),
2252: p_action_information24 => per_formula_functions.get_number('L_COST'),
2253: p_action_information25 => per_formula_functions.get_number('L_AMG'),
2254: p_action_information26 => per_formula_functions.get_number('L_CE'),
2255: p_action_information27 => null,
2248: p_action_information20 => per_formula_functions.get_number('K_COST'),
2249: p_action_information21 => per_formula_functions.get_number('K_AMG'),
2250: p_action_information22 => per_formula_functions.get_number('K_CE'),
2251: p_action_information23 => per_formula_functions.get_text('L_DESC'),
2252: p_action_information24 => per_formula_functions.get_number('L_COST'),
2253: p_action_information25 => per_formula_functions.get_number('L_AMG'),
2254: p_action_information26 => per_formula_functions.get_number('L_CE'),
2255: p_action_information27 => null,
2256: p_action_information28 => per_formula_functions.get_number('H_CE1'),
2249: p_action_information21 => per_formula_functions.get_number('K_AMG'),
2250: p_action_information22 => per_formula_functions.get_number('K_CE'),
2251: p_action_information23 => per_formula_functions.get_text('L_DESC'),
2252: p_action_information24 => per_formula_functions.get_number('L_COST'),
2253: p_action_information25 => per_formula_functions.get_number('L_AMG'),
2254: p_action_information26 => per_formula_functions.get_number('L_CE'),
2255: p_action_information27 => null,
2256: p_action_information28 => per_formula_functions.get_number('H_CE1'),
2257: p_action_information29 => per_formula_functions.get_number('H_COUNT'),
2250: p_action_information22 => per_formula_functions.get_number('K_CE'),
2251: p_action_information23 => per_formula_functions.get_text('L_DESC'),
2252: p_action_information24 => per_formula_functions.get_number('L_COST'),
2253: p_action_information25 => per_formula_functions.get_number('L_AMG'),
2254: p_action_information26 => per_formula_functions.get_number('L_CE'),
2255: p_action_information27 => null,
2256: p_action_information28 => per_formula_functions.get_number('H_CE1'),
2257: p_action_information29 => per_formula_functions.get_number('H_COUNT'),
2258: p_action_information30 => per_formula_functions.get_number('F_COUNT') );
2252: p_action_information24 => per_formula_functions.get_number('L_COST'),
2253: p_action_information25 => per_formula_functions.get_number('L_AMG'),
2254: p_action_information26 => per_formula_functions.get_number('L_CE'),
2255: p_action_information27 => null,
2256: p_action_information28 => per_formula_functions.get_number('H_CE1'),
2257: p_action_information29 => per_formula_functions.get_number('H_COUNT'),
2258: p_action_information30 => per_formula_functions.get_number('F_COUNT') );
2259: END IF;
2260:
2253: p_action_information25 => per_formula_functions.get_number('L_AMG'),
2254: p_action_information26 => per_formula_functions.get_number('L_CE'),
2255: p_action_information27 => null,
2256: p_action_information28 => per_formula_functions.get_number('H_CE1'),
2257: p_action_information29 => per_formula_functions.get_number('H_COUNT'),
2258: p_action_information30 => per_formula_functions.get_number('F_COUNT') );
2259: END IF;
2260:
2261: IF p_action_info_category = 'GB P11D ASSIGNMENT RESULTB'
2254: p_action_information26 => per_formula_functions.get_number('L_CE'),
2255: p_action_information27 => null,
2256: p_action_information28 => per_formula_functions.get_number('H_CE1'),
2257: p_action_information29 => per_formula_functions.get_number('H_COUNT'),
2258: p_action_information30 => per_formula_functions.get_number('F_COUNT') );
2259: END IF;
2260:
2261: IF p_action_info_category = 'GB P11D ASSIGNMENT RESULTB'
2262: THEN
2262: THEN
2263: pay_action_information_api.update_action_information(
2264: p_action_information_id => p_action_info_id,
2265: p_object_version_number => p_ovn,
2266: p_action_information1 => per_formula_functions.get_text('M_DESC'),
2267: p_action_information2 => per_formula_functions.get_number('M_COST'),
2268: p_action_information3 => per_formula_functions.get_number('M_AMG'),
2269: p_action_information4 => per_formula_functions.get_number('M_CE'),
2270: p_action_information5 => per_formula_functions.get_text('MA_DESC'),
2263: pay_action_information_api.update_action_information(
2264: p_action_information_id => p_action_info_id,
2265: p_object_version_number => p_ovn,
2266: p_action_information1 => per_formula_functions.get_text('M_DESC'),
2267: p_action_information2 => per_formula_functions.get_number('M_COST'),
2268: p_action_information3 => per_formula_functions.get_number('M_AMG'),
2269: p_action_information4 => per_formula_functions.get_number('M_CE'),
2270: p_action_information5 => per_formula_functions.get_text('MA_DESC'),
2271: p_action_information6 => per_formula_functions.get_number('MA_COST'),
2264: p_action_information_id => p_action_info_id,
2265: p_object_version_number => p_ovn,
2266: p_action_information1 => per_formula_functions.get_text('M_DESC'),
2267: p_action_information2 => per_formula_functions.get_number('M_COST'),
2268: p_action_information3 => per_formula_functions.get_number('M_AMG'),
2269: p_action_information4 => per_formula_functions.get_number('M_CE'),
2270: p_action_information5 => per_formula_functions.get_text('MA_DESC'),
2271: p_action_information6 => per_formula_functions.get_number('MA_COST'),
2272: p_action_information7 => per_formula_functions.get_number('MA_AMG'),
2265: p_object_version_number => p_ovn,
2266: p_action_information1 => per_formula_functions.get_text('M_DESC'),
2267: p_action_information2 => per_formula_functions.get_number('M_COST'),
2268: p_action_information3 => per_formula_functions.get_number('M_AMG'),
2269: p_action_information4 => per_formula_functions.get_number('M_CE'),
2270: p_action_information5 => per_formula_functions.get_text('MA_DESC'),
2271: p_action_information6 => per_formula_functions.get_number('MA_COST'),
2272: p_action_information7 => per_formula_functions.get_number('MA_AMG'),
2273: p_action_information8 => per_formula_functions.get_number('MA_CE'),
2266: p_action_information1 => per_formula_functions.get_text('M_DESC'),
2267: p_action_information2 => per_formula_functions.get_number('M_COST'),
2268: p_action_information3 => per_formula_functions.get_number('M_AMG'),
2269: p_action_information4 => per_formula_functions.get_number('M_CE'),
2270: p_action_information5 => per_formula_functions.get_text('MA_DESC'),
2271: p_action_information6 => per_formula_functions.get_number('MA_COST'),
2272: p_action_information7 => per_formula_functions.get_number('MA_AMG'),
2273: p_action_information8 => per_formula_functions.get_number('MA_CE'),
2274: p_action_information9 => per_formula_functions.get_number('M_TAXPAID'),
2267: p_action_information2 => per_formula_functions.get_number('M_COST'),
2268: p_action_information3 => per_formula_functions.get_number('M_AMG'),
2269: p_action_information4 => per_formula_functions.get_number('M_CE'),
2270: p_action_information5 => per_formula_functions.get_text('MA_DESC'),
2271: p_action_information6 => per_formula_functions.get_number('MA_COST'),
2272: p_action_information7 => per_formula_functions.get_number('MA_AMG'),
2273: p_action_information8 => per_formula_functions.get_number('MA_CE'),
2274: p_action_information9 => per_formula_functions.get_number('M_TAXPAID'),
2275: p_action_information10 => per_formula_functions.get_number('N1_COST'),
2268: p_action_information3 => per_formula_functions.get_number('M_AMG'),
2269: p_action_information4 => per_formula_functions.get_number('M_CE'),
2270: p_action_information5 => per_formula_functions.get_text('MA_DESC'),
2271: p_action_information6 => per_formula_functions.get_number('MA_COST'),
2272: p_action_information7 => per_formula_functions.get_number('MA_AMG'),
2273: p_action_information8 => per_formula_functions.get_number('MA_CE'),
2274: p_action_information9 => per_formula_functions.get_number('M_TAXPAID'),
2275: p_action_information10 => per_formula_functions.get_number('N1_COST'),
2276: p_action_information11 => per_formula_functions.get_number('N1_AMG'),
2269: p_action_information4 => per_formula_functions.get_number('M_CE'),
2270: p_action_information5 => per_formula_functions.get_text('MA_DESC'),
2271: p_action_information6 => per_formula_functions.get_number('MA_COST'),
2272: p_action_information7 => per_formula_functions.get_number('MA_AMG'),
2273: p_action_information8 => per_formula_functions.get_number('MA_CE'),
2274: p_action_information9 => per_formula_functions.get_number('M_TAXPAID'),
2275: p_action_information10 => per_formula_functions.get_number('N1_COST'),
2276: p_action_information11 => per_formula_functions.get_number('N1_AMG'),
2277: p_action_information12 => per_formula_functions.get_number('N1_CE'),
2270: p_action_information5 => per_formula_functions.get_text('MA_DESC'),
2271: p_action_information6 => per_formula_functions.get_number('MA_COST'),
2272: p_action_information7 => per_formula_functions.get_number('MA_AMG'),
2273: p_action_information8 => per_formula_functions.get_number('MA_CE'),
2274: p_action_information9 => per_formula_functions.get_number('M_TAXPAID'),
2275: p_action_information10 => per_formula_functions.get_number('N1_COST'),
2276: p_action_information11 => per_formula_functions.get_number('N1_AMG'),
2277: p_action_information12 => per_formula_functions.get_number('N1_CE'),
2278: p_action_information13 => per_formula_functions.get_number('N2_COST'),
2271: p_action_information6 => per_formula_functions.get_number('MA_COST'),
2272: p_action_information7 => per_formula_functions.get_number('MA_AMG'),
2273: p_action_information8 => per_formula_functions.get_number('MA_CE'),
2274: p_action_information9 => per_formula_functions.get_number('M_TAXPAID'),
2275: p_action_information10 => per_formula_functions.get_number('N1_COST'),
2276: p_action_information11 => per_formula_functions.get_number('N1_AMG'),
2277: p_action_information12 => per_formula_functions.get_number('N1_CE'),
2278: p_action_information13 => per_formula_functions.get_number('N2_COST'),
2279: p_action_information14 => per_formula_functions.get_number('N2_AMG'),
2272: p_action_information7 => per_formula_functions.get_number('MA_AMG'),
2273: p_action_information8 => per_formula_functions.get_number('MA_CE'),
2274: p_action_information9 => per_formula_functions.get_number('M_TAXPAID'),
2275: p_action_information10 => per_formula_functions.get_number('N1_COST'),
2276: p_action_information11 => per_formula_functions.get_number('N1_AMG'),
2277: p_action_information12 => per_formula_functions.get_number('N1_CE'),
2278: p_action_information13 => per_formula_functions.get_number('N2_COST'),
2279: p_action_information14 => per_formula_functions.get_number('N2_AMG'),
2280: p_action_information15 => per_formula_functions.get_number('N2_CE'),
2273: p_action_information8 => per_formula_functions.get_number('MA_CE'),
2274: p_action_information9 => per_formula_functions.get_number('M_TAXPAID'),
2275: p_action_information10 => per_formula_functions.get_number('N1_COST'),
2276: p_action_information11 => per_formula_functions.get_number('N1_AMG'),
2277: p_action_information12 => per_formula_functions.get_number('N1_CE'),
2278: p_action_information13 => per_formula_functions.get_number('N2_COST'),
2279: p_action_information14 => per_formula_functions.get_number('N2_AMG'),
2280: p_action_information15 => per_formula_functions.get_number('N2_CE'),
2281: p_action_information16 => per_formula_functions.get_text('N_TOI'),
2274: p_action_information9 => per_formula_functions.get_number('M_TAXPAID'),
2275: p_action_information10 => per_formula_functions.get_number('N1_COST'),
2276: p_action_information11 => per_formula_functions.get_number('N1_AMG'),
2277: p_action_information12 => per_formula_functions.get_number('N1_CE'),
2278: p_action_information13 => per_formula_functions.get_number('N2_COST'),
2279: p_action_information14 => per_formula_functions.get_number('N2_AMG'),
2280: p_action_information15 => per_formula_functions.get_number('N2_CE'),
2281: p_action_information16 => per_formula_functions.get_text('N_TOI'),
2282: p_action_information17 => per_formula_functions.get_number('N3_COST'),
2275: p_action_information10 => per_formula_functions.get_number('N1_COST'),
2276: p_action_information11 => per_formula_functions.get_number('N1_AMG'),
2277: p_action_information12 => per_formula_functions.get_number('N1_CE'),
2278: p_action_information13 => per_formula_functions.get_number('N2_COST'),
2279: p_action_information14 => per_formula_functions.get_number('N2_AMG'),
2280: p_action_information15 => per_formula_functions.get_number('N2_CE'),
2281: p_action_information16 => per_formula_functions.get_text('N_TOI'),
2282: p_action_information17 => per_formula_functions.get_number('N3_COST'),
2283: p_action_information18 => per_formula_functions.get_number('N3_AMG'),
2276: p_action_information11 => per_formula_functions.get_number('N1_AMG'),
2277: p_action_information12 => per_formula_functions.get_number('N1_CE'),
2278: p_action_information13 => per_formula_functions.get_number('N2_COST'),
2279: p_action_information14 => per_formula_functions.get_number('N2_AMG'),
2280: p_action_information15 => per_formula_functions.get_number('N2_CE'),
2281: p_action_information16 => per_formula_functions.get_text('N_TOI'),
2282: p_action_information17 => per_formula_functions.get_number('N3_COST'),
2283: p_action_information18 => per_formula_functions.get_number('N3_AMG'),
2284: p_action_information19 => per_formula_functions.get_number('N3_CE'),
2277: p_action_information12 => per_formula_functions.get_number('N1_CE'),
2278: p_action_information13 => per_formula_functions.get_number('N2_COST'),
2279: p_action_information14 => per_formula_functions.get_number('N2_AMG'),
2280: p_action_information15 => per_formula_functions.get_number('N2_CE'),
2281: p_action_information16 => per_formula_functions.get_text('N_TOI'),
2282: p_action_information17 => per_formula_functions.get_number('N3_COST'),
2283: p_action_information18 => per_formula_functions.get_number('N3_AMG'),
2284: p_action_information19 => per_formula_functions.get_number('N3_CE'),
2285: p_action_information20 => per_formula_functions.get_number('N4_COST'),
2278: p_action_information13 => per_formula_functions.get_number('N2_COST'),
2279: p_action_information14 => per_formula_functions.get_number('N2_AMG'),
2280: p_action_information15 => per_formula_functions.get_number('N2_CE'),
2281: p_action_information16 => per_formula_functions.get_text('N_TOI'),
2282: p_action_information17 => per_formula_functions.get_number('N3_COST'),
2283: p_action_information18 => per_formula_functions.get_number('N3_AMG'),
2284: p_action_information19 => per_formula_functions.get_number('N3_CE'),
2285: p_action_information20 => per_formula_functions.get_number('N4_COST'),
2286: p_action_information21 => per_formula_functions.get_number('N4_AMG'),
2279: p_action_information14 => per_formula_functions.get_number('N2_AMG'),
2280: p_action_information15 => per_formula_functions.get_number('N2_CE'),
2281: p_action_information16 => per_formula_functions.get_text('N_TOI'),
2282: p_action_information17 => per_formula_functions.get_number('N3_COST'),
2283: p_action_information18 => per_formula_functions.get_number('N3_AMG'),
2284: p_action_information19 => per_formula_functions.get_number('N3_CE'),
2285: p_action_information20 => per_formula_functions.get_number('N4_COST'),
2286: p_action_information21 => per_formula_functions.get_number('N4_AMG'),
2287: p_action_information22 => per_formula_functions.get_number('N4_CE'),
2280: p_action_information15 => per_formula_functions.get_number('N2_CE'),
2281: p_action_information16 => per_formula_functions.get_text('N_TOI'),
2282: p_action_information17 => per_formula_functions.get_number('N3_COST'),
2283: p_action_information18 => per_formula_functions.get_number('N3_AMG'),
2284: p_action_information19 => per_formula_functions.get_number('N3_CE'),
2285: p_action_information20 => per_formula_functions.get_number('N4_COST'),
2286: p_action_information21 => per_formula_functions.get_number('N4_AMG'),
2287: p_action_information22 => per_formula_functions.get_number('N4_CE'),
2288: p_action_information23 => per_formula_functions.get_number('N5_COST'),
2281: p_action_information16 => per_formula_functions.get_text('N_TOI'),
2282: p_action_information17 => per_formula_functions.get_number('N3_COST'),
2283: p_action_information18 => per_formula_functions.get_number('N3_AMG'),
2284: p_action_information19 => per_formula_functions.get_number('N3_CE'),
2285: p_action_information20 => per_formula_functions.get_number('N4_COST'),
2286: p_action_information21 => per_formula_functions.get_number('N4_AMG'),
2287: p_action_information22 => per_formula_functions.get_number('N4_CE'),
2288: p_action_information23 => per_formula_functions.get_number('N5_COST'),
2289: p_action_information24 => per_formula_functions.get_number('N5_AMG'),
2282: p_action_information17 => per_formula_functions.get_number('N3_COST'),
2283: p_action_information18 => per_formula_functions.get_number('N3_AMG'),
2284: p_action_information19 => per_formula_functions.get_number('N3_CE'),
2285: p_action_information20 => per_formula_functions.get_number('N4_COST'),
2286: p_action_information21 => per_formula_functions.get_number('N4_AMG'),
2287: p_action_information22 => per_formula_functions.get_number('N4_CE'),
2288: p_action_information23 => per_formula_functions.get_number('N5_COST'),
2289: p_action_information24 => per_formula_functions.get_number('N5_AMG'),
2290: p_action_information25 => per_formula_functions.get_number('N5_CE'),
2283: p_action_information18 => per_formula_functions.get_number('N3_AMG'),
2284: p_action_information19 => per_formula_functions.get_number('N3_CE'),
2285: p_action_information20 => per_formula_functions.get_number('N4_COST'),
2286: p_action_information21 => per_formula_functions.get_number('N4_AMG'),
2287: p_action_information22 => per_formula_functions.get_number('N4_CE'),
2288: p_action_information23 => per_formula_functions.get_number('N5_COST'),
2289: p_action_information24 => per_formula_functions.get_number('N5_AMG'),
2290: p_action_information25 => per_formula_functions.get_number('N5_CE'),
2291: p_action_information26 => per_formula_functions.get_text('N6_DESC'),
2284: p_action_information19 => per_formula_functions.get_number('N3_CE'),
2285: p_action_information20 => per_formula_functions.get_number('N4_COST'),
2286: p_action_information21 => per_formula_functions.get_number('N4_AMG'),
2287: p_action_information22 => per_formula_functions.get_number('N4_CE'),
2288: p_action_information23 => per_formula_functions.get_number('N5_COST'),
2289: p_action_information24 => per_formula_functions.get_number('N5_AMG'),
2290: p_action_information25 => per_formula_functions.get_number('N5_CE'),
2291: p_action_information26 => per_formula_functions.get_text('N6_DESC'),
2292: p_action_information27 => per_formula_functions.get_number('N6_COST'),
2285: p_action_information20 => per_formula_functions.get_number('N4_COST'),
2286: p_action_information21 => per_formula_functions.get_number('N4_AMG'),
2287: p_action_information22 => per_formula_functions.get_number('N4_CE'),
2288: p_action_information23 => per_formula_functions.get_number('N5_COST'),
2289: p_action_information24 => per_formula_functions.get_number('N5_AMG'),
2290: p_action_information25 => per_formula_functions.get_number('N5_CE'),
2291: p_action_information26 => per_formula_functions.get_text('N6_DESC'),
2292: p_action_information27 => per_formula_functions.get_number('N6_COST'),
2293: p_action_information28 => per_formula_functions.get_number('N6_AMG'),
2286: p_action_information21 => per_formula_functions.get_number('N4_AMG'),
2287: p_action_information22 => per_formula_functions.get_number('N4_CE'),
2288: p_action_information23 => per_formula_functions.get_number('N5_COST'),
2289: p_action_information24 => per_formula_functions.get_number('N5_AMG'),
2290: p_action_information25 => per_formula_functions.get_number('N5_CE'),
2291: p_action_information26 => per_formula_functions.get_text('N6_DESC'),
2292: p_action_information27 => per_formula_functions.get_number('N6_COST'),
2293: p_action_information28 => per_formula_functions.get_number('N6_AMG'),
2294: p_action_information29 => per_formula_functions.get_number('N6_CE')
2287: p_action_information22 => per_formula_functions.get_number('N4_CE'),
2288: p_action_information23 => per_formula_functions.get_number('N5_COST'),
2289: p_action_information24 => per_formula_functions.get_number('N5_AMG'),
2290: p_action_information25 => per_formula_functions.get_number('N5_CE'),
2291: p_action_information26 => per_formula_functions.get_text('N6_DESC'),
2292: p_action_information27 => per_formula_functions.get_number('N6_COST'),
2293: p_action_information28 => per_formula_functions.get_number('N6_AMG'),
2294: p_action_information29 => per_formula_functions.get_number('N6_CE')
2295: ,p_action_information30 => per_formula_functions.get_number('G_FCE'));
2288: p_action_information23 => per_formula_functions.get_number('N5_COST'),
2289: p_action_information24 => per_formula_functions.get_number('N5_AMG'),
2290: p_action_information25 => per_formula_functions.get_number('N5_CE'),
2291: p_action_information26 => per_formula_functions.get_text('N6_DESC'),
2292: p_action_information27 => per_formula_functions.get_number('N6_COST'),
2293: p_action_information28 => per_formula_functions.get_number('N6_AMG'),
2294: p_action_information29 => per_formula_functions.get_number('N6_CE')
2295: ,p_action_information30 => per_formula_functions.get_number('G_FCE'));
2296:
2289: p_action_information24 => per_formula_functions.get_number('N5_AMG'),
2290: p_action_information25 => per_formula_functions.get_number('N5_CE'),
2291: p_action_information26 => per_formula_functions.get_text('N6_DESC'),
2292: p_action_information27 => per_formula_functions.get_number('N6_COST'),
2293: p_action_information28 => per_formula_functions.get_number('N6_AMG'),
2294: p_action_information29 => per_formula_functions.get_number('N6_CE')
2295: ,p_action_information30 => per_formula_functions.get_number('G_FCE'));
2296:
2297: END IF;
2290: p_action_information25 => per_formula_functions.get_number('N5_CE'),
2291: p_action_information26 => per_formula_functions.get_text('N6_DESC'),
2292: p_action_information27 => per_formula_functions.get_number('N6_COST'),
2293: p_action_information28 => per_formula_functions.get_number('N6_AMG'),
2294: p_action_information29 => per_formula_functions.get_number('N6_CE')
2295: ,p_action_information30 => per_formula_functions.get_number('G_FCE'));
2296:
2297: END IF;
2298:
2291: p_action_information26 => per_formula_functions.get_text('N6_DESC'),
2292: p_action_information27 => per_formula_functions.get_number('N6_COST'),
2293: p_action_information28 => per_formula_functions.get_number('N6_AMG'),
2294: p_action_information29 => per_formula_functions.get_number('N6_CE')
2295: ,p_action_information30 => per_formula_functions.get_number('G_FCE'));
2296:
2297: END IF;
2298:
2299: IF p_action_info_category = 'GB P11D ASSIGNMENT RESULTC'
2300: THEN
2301: pay_action_information_api.update_action_information(
2302: p_action_information_id => p_action_info_id,
2303: p_object_version_number => p_ovn,
2304: p_action_information1 => per_formula_functions.get_number('C_BUS_MILES'),
2305: p_action_information2 => per_formula_functions.get_number('M_BUS_MILES'),
2306: p_action_information3 => per_formula_functions.get_number('B_BUS_MILES'),
2307: p_action_information4 => per_formula_functions.get_number('C_RATE1'),
2308: p_action_information5 => per_formula_functions.get_number('C_RATE2'),
2301: pay_action_information_api.update_action_information(
2302: p_action_information_id => p_action_info_id,
2303: p_object_version_number => p_ovn,
2304: p_action_information1 => per_formula_functions.get_number('C_BUS_MILES'),
2305: p_action_information2 => per_formula_functions.get_number('M_BUS_MILES'),
2306: p_action_information3 => per_formula_functions.get_number('B_BUS_MILES'),
2307: p_action_information4 => per_formula_functions.get_number('C_RATE1'),
2308: p_action_information5 => per_formula_functions.get_number('C_RATE2'),
2309: p_action_information6 => per_formula_functions.get_number('M_RATE1'),
2302: p_action_information_id => p_action_info_id,
2303: p_object_version_number => p_ovn,
2304: p_action_information1 => per_formula_functions.get_number('C_BUS_MILES'),
2305: p_action_information2 => per_formula_functions.get_number('M_BUS_MILES'),
2306: p_action_information3 => per_formula_functions.get_number('B_BUS_MILES'),
2307: p_action_information4 => per_formula_functions.get_number('C_RATE1'),
2308: p_action_information5 => per_formula_functions.get_number('C_RATE2'),
2309: p_action_information6 => per_formula_functions.get_number('M_RATE1'),
2310: p_action_information7 => per_formula_functions.get_number('M_RATE2'),
2303: p_object_version_number => p_ovn,
2304: p_action_information1 => per_formula_functions.get_number('C_BUS_MILES'),
2305: p_action_information2 => per_formula_functions.get_number('M_BUS_MILES'),
2306: p_action_information3 => per_formula_functions.get_number('B_BUS_MILES'),
2307: p_action_information4 => per_formula_functions.get_number('C_RATE1'),
2308: p_action_information5 => per_formula_functions.get_number('C_RATE2'),
2309: p_action_information6 => per_formula_functions.get_number('M_RATE1'),
2310: p_action_information7 => per_formula_functions.get_number('M_RATE2'),
2311: p_action_information8 => per_formula_functions.get_number('B_RATE1'),
2304: p_action_information1 => per_formula_functions.get_number('C_BUS_MILES'),
2305: p_action_information2 => per_formula_functions.get_number('M_BUS_MILES'),
2306: p_action_information3 => per_formula_functions.get_number('B_BUS_MILES'),
2307: p_action_information4 => per_formula_functions.get_number('C_RATE1'),
2308: p_action_information5 => per_formula_functions.get_number('C_RATE2'),
2309: p_action_information6 => per_formula_functions.get_number('M_RATE1'),
2310: p_action_information7 => per_formula_functions.get_number('M_RATE2'),
2311: p_action_information8 => per_formula_functions.get_number('B_RATE1'),
2312: p_action_information9 => per_formula_functions.get_number('B_RATE2'),
2305: p_action_information2 => per_formula_functions.get_number('M_BUS_MILES'),
2306: p_action_information3 => per_formula_functions.get_number('B_BUS_MILES'),
2307: p_action_information4 => per_formula_functions.get_number('C_RATE1'),
2308: p_action_information5 => per_formula_functions.get_number('C_RATE2'),
2309: p_action_information6 => per_formula_functions.get_number('M_RATE1'),
2310: p_action_information7 => per_formula_functions.get_number('M_RATE2'),
2311: p_action_information8 => per_formula_functions.get_number('B_RATE1'),
2312: p_action_information9 => per_formula_functions.get_number('B_RATE2'),
2313: p_action_information10 => null,
2306: p_action_information3 => per_formula_functions.get_number('B_BUS_MILES'),
2307: p_action_information4 => per_formula_functions.get_number('C_RATE1'),
2308: p_action_information5 => per_formula_functions.get_number('C_RATE2'),
2309: p_action_information6 => per_formula_functions.get_number('M_RATE1'),
2310: p_action_information7 => per_formula_functions.get_number('M_RATE2'),
2311: p_action_information8 => per_formula_functions.get_number('B_RATE1'),
2312: p_action_information9 => per_formula_functions.get_number('B_RATE2'),
2313: p_action_information10 => null,
2314: p_action_information11 => null,
2307: p_action_information4 => per_formula_functions.get_number('C_RATE1'),
2308: p_action_information5 => per_formula_functions.get_number('C_RATE2'),
2309: p_action_information6 => per_formula_functions.get_number('M_RATE1'),
2310: p_action_information7 => per_formula_functions.get_number('M_RATE2'),
2311: p_action_information8 => per_formula_functions.get_number('B_RATE1'),
2312: p_action_information9 => per_formula_functions.get_number('B_RATE2'),
2313: p_action_information10 => null,
2314: p_action_information11 => null,
2315: p_action_information12 => per_formula_functions.get_number('C_MILEAGE_PAYMENTS'),
2308: p_action_information5 => per_formula_functions.get_number('C_RATE2'),
2309: p_action_information6 => per_formula_functions.get_number('M_RATE1'),
2310: p_action_information7 => per_formula_functions.get_number('M_RATE2'),
2311: p_action_information8 => per_formula_functions.get_number('B_RATE1'),
2312: p_action_information9 => per_formula_functions.get_number('B_RATE2'),
2313: p_action_information10 => null,
2314: p_action_information11 => null,
2315: p_action_information12 => per_formula_functions.get_number('C_MILEAGE_PAYMENTS'),
2316: p_action_information13 => per_formula_functions.get_number('B_MILEAGE_PAYMENTS'),
2311: p_action_information8 => per_formula_functions.get_number('B_RATE1'),
2312: p_action_information9 => per_formula_functions.get_number('B_RATE2'),
2313: p_action_information10 => null,
2314: p_action_information11 => null,
2315: p_action_information12 => per_formula_functions.get_number('C_MILEAGE_PAYMENTS'),
2316: p_action_information13 => per_formula_functions.get_number('B_MILEAGE_PAYMENTS'),
2317: p_action_information14 => per_formula_functions.get_number('M_MILEAGE_PAYMENTS'),
2318: p_action_information15 => per_formula_functions.get_number('MARORS_COUNT'),
2319: p_action_information16 => per_formula_functions.get_number('C_TAX_DEDUCTED'),
2312: p_action_information9 => per_formula_functions.get_number('B_RATE2'),
2313: p_action_information10 => null,
2314: p_action_information11 => null,
2315: p_action_information12 => per_formula_functions.get_number('C_MILEAGE_PAYMENTS'),
2316: p_action_information13 => per_formula_functions.get_number('B_MILEAGE_PAYMENTS'),
2317: p_action_information14 => per_formula_functions.get_number('M_MILEAGE_PAYMENTS'),
2318: p_action_information15 => per_formula_functions.get_number('MARORS_COUNT'),
2319: p_action_information16 => per_formula_functions.get_number('C_TAX_DEDUCTED'),
2320: p_action_information17 => per_formula_functions.get_number('B_TAX_DEDUCTED'),
2313: p_action_information10 => null,
2314: p_action_information11 => null,
2315: p_action_information12 => per_formula_functions.get_number('C_MILEAGE_PAYMENTS'),
2316: p_action_information13 => per_formula_functions.get_number('B_MILEAGE_PAYMENTS'),
2317: p_action_information14 => per_formula_functions.get_number('M_MILEAGE_PAYMENTS'),
2318: p_action_information15 => per_formula_functions.get_number('MARORS_COUNT'),
2319: p_action_information16 => per_formula_functions.get_number('C_TAX_DEDUCTED'),
2320: p_action_information17 => per_formula_functions.get_number('B_TAX_DEDUCTED'),
2321: p_action_information18 => per_formula_functions.get_number('M_TAX_DEDUCTED'),
2314: p_action_information11 => null,
2315: p_action_information12 => per_formula_functions.get_number('C_MILEAGE_PAYMENTS'),
2316: p_action_information13 => per_formula_functions.get_number('B_MILEAGE_PAYMENTS'),
2317: p_action_information14 => per_formula_functions.get_number('M_MILEAGE_PAYMENTS'),
2318: p_action_information15 => per_formula_functions.get_number('MARORS_COUNT'),
2319: p_action_information16 => per_formula_functions.get_number('C_TAX_DEDUCTED'),
2320: p_action_information17 => per_formula_functions.get_number('B_TAX_DEDUCTED'),
2321: p_action_information18 => per_formula_functions.get_number('M_TAX_DEDUCTED'),
2322: p_action_information19 => per_formula_functions.get_number('PASSENGER_PAYMENTS'),
2315: p_action_information12 => per_formula_functions.get_number('C_MILEAGE_PAYMENTS'),
2316: p_action_information13 => per_formula_functions.get_number('B_MILEAGE_PAYMENTS'),
2317: p_action_information14 => per_formula_functions.get_number('M_MILEAGE_PAYMENTS'),
2318: p_action_information15 => per_formula_functions.get_number('MARORS_COUNT'),
2319: p_action_information16 => per_formula_functions.get_number('C_TAX_DEDUCTED'),
2320: p_action_information17 => per_formula_functions.get_number('B_TAX_DEDUCTED'),
2321: p_action_information18 => per_formula_functions.get_number('M_TAX_DEDUCTED'),
2322: p_action_information19 => per_formula_functions.get_number('PASSENGER_PAYMENTS'),
2323: p_action_information20 => per_formula_functions.get_number('PASSENGER_BUS_MILES'),
2316: p_action_information13 => per_formula_functions.get_number('B_MILEAGE_PAYMENTS'),
2317: p_action_information14 => per_formula_functions.get_number('M_MILEAGE_PAYMENTS'),
2318: p_action_information15 => per_formula_functions.get_number('MARORS_COUNT'),
2319: p_action_information16 => per_formula_functions.get_number('C_TAX_DEDUCTED'),
2320: p_action_information17 => per_formula_functions.get_number('B_TAX_DEDUCTED'),
2321: p_action_information18 => per_formula_functions.get_number('M_TAX_DEDUCTED'),
2322: p_action_information19 => per_formula_functions.get_number('PASSENGER_PAYMENTS'),
2323: p_action_information20 => per_formula_functions.get_number('PASSENGER_BUS_MILES'),
2324: p_action_information21 => per_formula_functions.get_number('PASSENGER_BUS_MILE_AMT'),
2317: p_action_information14 => per_formula_functions.get_number('M_MILEAGE_PAYMENTS'),
2318: p_action_information15 => per_formula_functions.get_number('MARORS_COUNT'),
2319: p_action_information16 => per_formula_functions.get_number('C_TAX_DEDUCTED'),
2320: p_action_information17 => per_formula_functions.get_number('B_TAX_DEDUCTED'),
2321: p_action_information18 => per_formula_functions.get_number('M_TAX_DEDUCTED'),
2322: p_action_information19 => per_formula_functions.get_number('PASSENGER_PAYMENTS'),
2323: p_action_information20 => per_formula_functions.get_number('PASSENGER_BUS_MILES'),
2324: p_action_information21 => per_formula_functions.get_number('PASSENGER_BUS_MILE_AMT'),
2325: p_action_information22 => per_formula_functions.get_number('MILEAGE_ALLOWANCE_RELIEF'),
2318: p_action_information15 => per_formula_functions.get_number('MARORS_COUNT'),
2319: p_action_information16 => per_formula_functions.get_number('C_TAX_DEDUCTED'),
2320: p_action_information17 => per_formula_functions.get_number('B_TAX_DEDUCTED'),
2321: p_action_information18 => per_formula_functions.get_number('M_TAX_DEDUCTED'),
2322: p_action_information19 => per_formula_functions.get_number('PASSENGER_PAYMENTS'),
2323: p_action_information20 => per_formula_functions.get_number('PASSENGER_BUS_MILES'),
2324: p_action_information21 => per_formula_functions.get_number('PASSENGER_BUS_MILE_AMT'),
2325: p_action_information22 => per_formula_functions.get_number('MILEAGE_ALLOWANCE_RELIEF'),
2326: p_action_information23 => per_formula_functions.get_number('INT_MAX_AMT_OUTSTANDING')
2319: p_action_information16 => per_formula_functions.get_number('C_TAX_DEDUCTED'),
2320: p_action_information17 => per_formula_functions.get_number('B_TAX_DEDUCTED'),
2321: p_action_information18 => per_formula_functions.get_number('M_TAX_DEDUCTED'),
2322: p_action_information19 => per_formula_functions.get_number('PASSENGER_PAYMENTS'),
2323: p_action_information20 => per_formula_functions.get_number('PASSENGER_BUS_MILES'),
2324: p_action_information21 => per_formula_functions.get_number('PASSENGER_BUS_MILE_AMT'),
2325: p_action_information22 => per_formula_functions.get_number('MILEAGE_ALLOWANCE_RELIEF'),
2326: p_action_information23 => per_formula_functions.get_number('INT_MAX_AMT_OUTSTANDING')
2327: );
2320: p_action_information17 => per_formula_functions.get_number('B_TAX_DEDUCTED'),
2321: p_action_information18 => per_formula_functions.get_number('M_TAX_DEDUCTED'),
2322: p_action_information19 => per_formula_functions.get_number('PASSENGER_PAYMENTS'),
2323: p_action_information20 => per_formula_functions.get_number('PASSENGER_BUS_MILES'),
2324: p_action_information21 => per_formula_functions.get_number('PASSENGER_BUS_MILE_AMT'),
2325: p_action_information22 => per_formula_functions.get_number('MILEAGE_ALLOWANCE_RELIEF'),
2326: p_action_information23 => per_formula_functions.get_number('INT_MAX_AMT_OUTSTANDING')
2327: );
2328: END IF;
2321: p_action_information18 => per_formula_functions.get_number('M_TAX_DEDUCTED'),
2322: p_action_information19 => per_formula_functions.get_number('PASSENGER_PAYMENTS'),
2323: p_action_information20 => per_formula_functions.get_number('PASSENGER_BUS_MILES'),
2324: p_action_information21 => per_formula_functions.get_number('PASSENGER_BUS_MILE_AMT'),
2325: p_action_information22 => per_formula_functions.get_number('MILEAGE_ALLOWANCE_RELIEF'),
2326: p_action_information23 => per_formula_functions.get_number('INT_MAX_AMT_OUTSTANDING')
2327: );
2328: END IF;
2329: end if;
2322: p_action_information19 => per_formula_functions.get_number('PASSENGER_PAYMENTS'),
2323: p_action_information20 => per_formula_functions.get_number('PASSENGER_BUS_MILES'),
2324: p_action_information21 => per_formula_functions.get_number('PASSENGER_BUS_MILE_AMT'),
2325: p_action_information22 => per_formula_functions.get_number('MILEAGE_ALLOWANCE_RELIEF'),
2326: p_action_information23 => per_formula_functions.get_number('INT_MAX_AMT_OUTSTANDING')
2327: );
2328: END IF;
2329: end if;
2330: END;
2362: PROCEDURE read_validate_log_desc(p_var_name VARCHAR2)
2363: IS
2364: l_var_value VARCHAR2(150);
2365: BEGIN
2366: l_var_value := per_formula_functions.get_text(p_var_name);
2367: IF UPPER(l_var_value) = 'MULTIPLE'
2368: THEN
2369: /* The code below can be removed when do P11D for year 05/06 */
2370: if to_number(g_param_rep_run) < 2005
2406: PROCEDURE read_validate_log(p_var_name VARCHAR2)
2407: IS
2408: l_var_value NUMBER;
2409: BEGIN
2410: l_var_value := per_formula_functions.get_number(p_var_name);
2411: IF p_var_name = 'F_COUNT'
2412: THEN
2413: IF l_var_value > 50
2414: THEN
2440: p_element_name VARCHAR2)
2441: IS
2442: l_var_value NUMBER;
2443: BEGIN
2444: l_var_value := per_formula_functions.get_number(p_var_name);
2445: If l_var_value < p_min_value then
2446: pay_core_utils.push_message(800, 'HR_GB_78083_MIN_VALUE_ERROR', 'F');
2447: pay_core_utils.push_token('ELEMENT_NAME', p_element_name);
2448: pay_core_utils.push_token('VALUE', p_min_value);
2569: end if;
2570: read_validate_min_max('MILEAGE_ALLOWANCE_RELIEF',-999999.99,0,'MARORS');
2571: -- checking max amount outstanding for Int free and low int loans
2572: -- will rasie just a warning for this
2573: If per_formula_functions.get_number('INT_MAX_AMT_OUTSTANDING') < l_loan_threshold then
2574: pay_core_utils.push_message(800, 'HR_GB_78083_MIN_VALUE_ERROR', 'W');
2575: pay_core_utils.push_token('ELEMENT_NAME', 'Int Free and Low Int Loans');
2576: pay_core_utils.push_token('VALUE', l_loan_threshold);
2577: l_warn := '1';
3098: l_index := l_first_index;
3099:
3100: -- loop thru all the benefits
3101: -- resetting globals as earlier values should not be used!
3102: l_ret := per_formula_functions.remove_globals;
3103: -- hr_utility.trace_on(null,'ARCH');
3104:
3105: WHILE l_index <= g_tab_ben_detail.LAST
3106: LOOP
3234: pay_core_utils.push_message(800, 'HR_78055_GB_P11D_FORMULA_ERR', 'F');
3235: pay_core_utils.push_token('ELEMENT_NAME', l_element_name);
3236: hr_utility.set_location('Nothing to execute ! '|| ' :' || l_proc, 70);
3237: -- Remove ALL GLOBALS
3238: l_ret := per_formula_functions.remove_globals;
3239: RAISE error_found;
3240: End;
3241: -- Now passing the l_user_inputs to the array l_inputs
3242: IF l_inputs.COUNT > 0 AND l_user_inputs.COUNT > 0
3643: THEN
3644: hr_utility.set_location('Failing Assignment '|| ' :' || l_proc, 70);
3645: --log_message;
3646: -- Remove ALL GLOBALS
3647: l_ret := per_formula_functions.remove_globals;
3648: RAISE error_found;
3649: ELSE
3650: -- insert rows which are sums for all values in ffs
3651: hr_utility.trace('Inserting summed records ');
3650: -- insert rows which are sums for all values in ffs
3651: hr_utility.trace('Inserting summed records ');
3652: insert_sum_records(p_assactid);
3653: -- Remove ALL GLOBALS
3654: l_ret := per_formula_functions.remove_globals;
3655: /* bug fix for 3485256
3656: l_index := g_tab_ben_detail.FIRST;
3657: */
3658: l_index := l_first_index;
3686: IF l_error = '1'
3687: THEN
3688: hr_utility.set_location('Failing Assignment '|| ' :' || l_proc, 90);
3689: -- Remove ALL GLOBALS
3690: l_ret := per_formula_functions.remove_globals;
3691: RAISE error_found;
3692: ELSE
3693: l_tab_counter := l_processed_assign_actions.FIRST;
3694: hr_utility.trace('Calling Update values..');
3700: END LOOP;
3701: END IF;
3702: END IF;
3703: END IF;
3704: l_ret := per_formula_functions.remove_globals;
3705: hr_utility.trace('nearing end');
3706: EXCEPTION
3707: WHEN error_found
3708: THEN
3705: hr_utility.trace('nearing end');
3706: EXCEPTION
3707: WHEN error_found
3708: THEN
3709: l_ret := per_formula_functions.remove_globals;
3710: -- the error will be reported in Deinitialization proc
3711: -- write_error_to_log;
3712: g_set_warning := TRUE;
3713: hr_utility.raise_error;