[Home] [Help]
1474:
1475: l_total := 0;
1476: l_count := 0;
1477: for asset in get_data loop
1478: hr_utility.trace('Asset : ' || asset.asset_type );
1479: hr_utility.trace('Cash : ' || asset.cash_equivalent );
1480: if asset.cash_equivalent >= 1 then
1481: l_count := l_count + 1;
1482: l_total := l_total + asset.cash_equivalent;
1475: l_total := 0;
1476: l_count := 0;
1477: for asset in get_data loop
1478: hr_utility.trace('Asset : ' || asset.asset_type );
1479: hr_utility.trace('Cash : ' || asset.cash_equivalent );
1480: if asset.cash_equivalent >= 1 then
1481: l_count := l_count + 1;
1482: l_total := l_total + asset.cash_equivalent;
1483: l_annual := asset.cash_equivalent + asset.amount_made_good;
2524: p_edi_rec30 out NoCopy varchar2) return number
2525: is
2526: begin
2527: if p_benefit_type = 'ASSETS TRANSFERRED' then
2528: hr_utility.trace('Assets Transferred');
2529: get_asset_transferred(p_person_id => p_person_id,
2530: p_emp_ref => p_employer_ref,
2531: p_pact_id => p_pact_id,
2532: p_edi_rec1 => p_edi_rec1,
2553: p_edi_rec22 => p_edi_rec22);
2554: return 0;
2555: end if;
2556: if p_benefit_type = 'PAYMENTS MADE FOR EMP' then
2557: hr_utility.trace('Payment made for employee');
2558: get_payments_for_emp(p_person_id => p_person_id,
2559: p_emp_ref => p_employer_ref,
2560: p_pact_id => p_pact_id,
2561: p_edi_rec1 => p_edi_rec1,
2577: p_edi_rec17 => p_edi_rec17);
2578: return 0;
2579: end if;
2580: if p_benefit_type = 'VOUCHERS OR CREDIT CARDS' then
2581: hr_utility.trace('Voucher');
2582: get_voucher_n_creditcard(p_person_id => p_person_id,
2583: p_emp_ref => p_employer_ref,
2584: p_pact_id => p_pact_id,
2585: p_edi_rec1 => p_edi_rec1,
2591: p_edi_rec7 => p_edi_rec7);
2592: return 0;
2593: end if;
2594: if p_benefit_type = 'LIVING ACCOMMODATION' then
2595: hr_utility.trace('Living accommodation');
2596: get_living_accommodation(p_person_id => p_person_id,
2597: p_emp_ref => p_employer_ref,
2598: p_pact_id => p_pact_id,
2599: p_edi_rec1 => p_edi_rec1,
2601: p_edi_rec3 => p_edi_rec3);
2602: return 0;
2603: end if;
2604: if p_benefit_type = 'MILEAGE ALLOWANCE AND PPAYMENT' then
2605: hr_utility.trace('Mileage allowance and prepayment');
2606: get_mileage_allowance(p_person_id => p_person_id,
2607: p_emp_ref => p_employer_ref,
2608: p_pact_id => p_pact_id,
2609: p_edi_rec1 => p_edi_rec1,
2611: p_edi_rec3 => p_edi_rec3);
2612: return 0;
2613: end if;
2614: if p_benefit_type = 'CAR AND CAR FUEL 2003_04' then
2615: hr_utility.trace('Car');
2616: get_car_or_fuel(p_person_id => p_person_id,
2617: p_emp_ref => p_employer_ref,
2618: p_pact_id => p_pact_id,
2619: p_tax_year => p_tax_year,
2645: p_edi_rec23 => p_edi_rec23);
2646: return 0;
2647: end if;
2648: if p_benefit_type = 'VANS 2005' then
2649: hr_utility.trace('Vans');
2650: get_vans(p_person_id => p_person_id,
2651: p_emp_ref => p_employer_ref,
2652: p_pact_id => p_pact_id,
2653: p_edi_rec1 => p_edi_rec1,
2655: p_edi_rec3 => p_edi_rec3);
2656: return 0;
2657: end if;
2658: if p_benefit_type = 'INT FREE AND LOW INT LOANS' then
2659: hr_utility.trace('Loans');
2660: get_low_int_loan(p_person_id => p_person_id,
2661: p_emp_ref => p_employer_ref,
2662: p_pact_id => p_pact_id,
2663: p_ben_count => p_benefit_count,
2674: p_edi_rec9 => p_edi_rec9);
2675: return 0;
2676: end if;
2677: if p_benefit_type = 'PVT MED TREATMENT OR INSURANCE' then
2678: hr_utility.trace('Insurance');
2679: get_pvt_med_or_ins(p_person_id => p_person_id,
2680: p_emp_ref => p_employer_ref,
2681: p_pact_id => p_pact_id,
2682: p_edi_rec1 => p_edi_rec1,
2688: p_edi_rec7 => p_edi_rec7);
2689: return 0;
2690: end if;
2691: if p_benefit_type = 'RELOCATION EXPENSES' then
2692: hr_utility.trace('Relocation expenses');
2693: get_relocation(p_person_id => p_person_id,
2694: p_emp_ref => p_employer_ref,
2695: p_pact_id => p_pact_id,
2696: p_edi_rec1 => p_edi_rec1,
2698: p_edi_rec3 => p_edi_rec3);
2699: return 0;
2700: end if;
2701: if p_benefit_type = 'SERVICES SUPPLIED' then
2702: hr_utility.trace('Service supplied');
2703: get_service_supplied(p_person_id => p_person_id,
2704: p_emp_ref => p_employer_ref,
2705: p_pact_id => p_pact_id,
2706: p_edi_rec1 => p_edi_rec1,
2712: p_edi_rec7 => p_edi_rec7);
2713: return 0;
2714: end if;
2715: if p_benefit_type = 'ASSETS AT EMP DISPOSAL' then
2716: hr_utility.trace('Assets at employee disposal');
2717: get_assets_at_emp(p_person_id => p_person_id,
2718: p_emp_ref => p_employer_ref,
2719: p_pact_id => p_pact_id,
2720: p_edi_rec1 => p_edi_rec1,
2735: p_edi_rec16 => p_edi_rec16);
2736: return 0;
2737: end if;
2738: if p_benefit_type = 'OTHER ITEMS' then
2739: hr_utility.trace('Other Items');
2740: get_other_items(p_person_id => p_person_id,
2741: p_emp_ref => p_employer_ref,
2742: p_pact_id => p_pact_id,
2743: p_edi_rec1 => p_edi_rec1,
2764: p_edi_rec22 => p_edi_rec22);
2765: return 0;
2766: end if;
2767: if p_benefit_type = 'EXPENSES PAYMENTS' then
2768: hr_utility.trace('Expenses Payments');
2769: get_exp_payment(p_person_id => p_person_id,
2770: p_emp_ref => p_employer_ref,
2771: p_pact_id => p_pact_id,
2772: p_edi_rec1 => p_edi_rec1,
2791: p_edi_rec20 => p_edi_rec20);
2792: return 0;
2793: end if;
2794: if p_benefit_type = 'MARORS' then
2795: hr_utility.trace('Marrors');
2796: get_marors(p_person_id => p_person_id,
2797: p_emp_ref => p_employer_ref,
2798: p_pact_id => p_pact_id,
2799: p_edi_rec1 => p_edi_rec1,