DBA Data[Home] [Help]

APPS.PAY_GB_P11D_EDI_2005 dependencies on HR_UTILITY

Line 1466: hr_utility.trace('Asset : ' || asset.asset_type );

1462:
1463: l_total := 0;
1464: l_count := 0;
1465: for asset in get_data loop
1466: hr_utility.trace('Asset : ' || asset.asset_type );
1467: hr_utility.trace('Cash : ' || asset.cash_equivalent );
1468: if asset.cash_equivalent > 0 then
1469: l_count := l_count + 1;
1470: l_total := l_total + asset.cash_equivalent;

Line 1467: hr_utility.trace('Cash : ' || asset.cash_equivalent );

1463: l_total := 0;
1464: l_count := 0;
1465: for asset in get_data loop
1466: hr_utility.trace('Asset : ' || asset.asset_type );
1467: hr_utility.trace('Cash : ' || asset.cash_equivalent );
1468: if asset.cash_equivalent > 0 then
1469: l_count := l_count + 1;
1470: l_total := l_total + asset.cash_equivalent;
1471: l_annual := asset.cash_equivalent + asset.amount_made_good;

Line 2477: hr_utility.trace('Assets Transferred');

2473: p_edi_rec30 out NoCopy varchar2) return number
2474: is
2475: begin
2476: if p_benefit_type = 'ASSETS TRANSFERRED' then
2477: hr_utility.trace('Assets Transferred');
2478: get_asset_transferred(p_person_id => p_person_id,
2479: p_emp_ref => p_employer_ref,
2480: p_pact_id => p_pact_id,
2481: p_edi_rec1 => p_edi_rec1,

Line 2506: hr_utility.trace('Payment made for employee');

2502: p_edi_rec22 => p_edi_rec22);
2503: return 0;
2504: end if;
2505: if p_benefit_type = 'PAYMENTS MADE FOR EMP' then
2506: hr_utility.trace('Payment made for employee');
2507: get_payments_for_emp(p_person_id => p_person_id,
2508: p_emp_ref => p_employer_ref,
2509: p_pact_id => p_pact_id,
2510: p_edi_rec1 => p_edi_rec1,

Line 2530: hr_utility.trace('Voucher');

2526: p_edi_rec17 => p_edi_rec17);
2527: return 0;
2528: end if;
2529: if p_benefit_type = 'VOUCHERS OR CREDIT CARDS' then
2530: hr_utility.trace('Voucher');
2531: get_voucher_n_creditcard(p_person_id => p_person_id,
2532: p_emp_ref => p_employer_ref,
2533: p_pact_id => p_pact_id,
2534: p_edi_rec1 => p_edi_rec1,

Line 2544: hr_utility.trace('Living accommodation');

2540: p_edi_rec7 => p_edi_rec7);
2541: return 0;
2542: end if;
2543: if p_benefit_type = 'LIVING ACCOMMODATION' then
2544: hr_utility.trace('Living accommodation');
2545: get_living_accommodation(p_person_id => p_person_id,
2546: p_emp_ref => p_employer_ref,
2547: p_pact_id => p_pact_id,
2548: p_edi_rec1 => p_edi_rec1,

Line 2554: hr_utility.trace('Mileage allowance and prepayment');

2550: p_edi_rec3 => p_edi_rec3);
2551: return 0;
2552: end if;
2553: if p_benefit_type = 'MILEAGE ALLOWANCE AND PPAYMENT' then
2554: hr_utility.trace('Mileage allowance and prepayment');
2555: get_mileage_allowance(p_person_id => p_person_id,
2556: p_emp_ref => p_employer_ref,
2557: p_pact_id => p_pact_id,
2558: p_edi_rec1 => p_edi_rec1,

Line 2564: hr_utility.trace('Car');

2560: p_edi_rec3 => p_edi_rec3);
2561: return 0;
2562: end if;
2563: if p_benefit_type = 'CAR AND CAR FUEL 2003_04' then
2564: hr_utility.trace('Car');
2565: get_car_or_fuel(p_person_id => p_person_id,
2566: p_emp_ref => p_employer_ref,
2567: p_pact_id => p_pact_id,
2568: p_tax_year => p_tax_year,

Line 2598: hr_utility.trace('Vans');

2594: p_edi_rec23 => p_edi_rec23);
2595: return 0;
2596: end if;
2597: if p_benefit_type = 'VANS 2002_03' then
2598: hr_utility.trace('Vans');
2599: get_vans(p_person_id => p_person_id,
2600: p_emp_ref => p_employer_ref,
2601: p_pact_id => p_pact_id,
2602: p_edi_rec1 => p_edi_rec1,

Line 2608: hr_utility.trace('Loans');

2604: p_edi_rec3 => p_edi_rec3);
2605: return 0;
2606: end if;
2607: if p_benefit_type = 'INT FREE AND LOW INT LOANS' then
2608: hr_utility.trace('Loans');
2609: get_low_int_loan(p_person_id => p_person_id,
2610: p_emp_ref => p_employer_ref,
2611: p_pact_id => p_pact_id,
2612: p_ben_count => p_benefit_count,

Line 2627: hr_utility.trace('Insurance');

2623: p_edi_rec9 => p_edi_rec9);
2624: return 0;
2625: end if;
2626: if p_benefit_type = 'PVT MED TREATMENT OR INSURANCE' then
2627: hr_utility.trace('Insurance');
2628: get_pvt_med_or_ins(p_person_id => p_person_id,
2629: p_emp_ref => p_employer_ref,
2630: p_pact_id => p_pact_id,
2631: p_edi_rec1 => p_edi_rec1,

Line 2641: hr_utility.trace('Relocation expenses');

2637: p_edi_rec7 => p_edi_rec7);
2638: return 0;
2639: end if;
2640: if p_benefit_type = 'RELOCATION EXPENSES' then
2641: hr_utility.trace('Relocation expenses');
2642: get_relocation(p_person_id => p_person_id,
2643: p_emp_ref => p_employer_ref,
2644: p_pact_id => p_pact_id,
2645: p_edi_rec1 => p_edi_rec1,

Line 2651: hr_utility.trace('Service supplied');

2647: p_edi_rec3 => p_edi_rec3);
2648: return 0;
2649: end if;
2650: if p_benefit_type = 'SERVICES SUPPLIED' then
2651: hr_utility.trace('Service supplied');
2652: get_service_supplied(p_person_id => p_person_id,
2653: p_emp_ref => p_employer_ref,
2654: p_pact_id => p_pact_id,
2655: p_edi_rec1 => p_edi_rec1,

Line 2665: hr_utility.trace('Assets at employee disposal');

2661: p_edi_rec7 => p_edi_rec7);
2662: return 0;
2663: end if;
2664: if p_benefit_type = 'ASSETS AT EMP DISPOSAL' then
2665: hr_utility.trace('Assets at employee disposal');
2666: get_assets_at_emp(p_person_id => p_person_id,
2667: p_emp_ref => p_employer_ref,
2668: p_pact_id => p_pact_id,
2669: p_edi_rec1 => p_edi_rec1,

Line 2688: hr_utility.trace('Other Items');

2684: p_edi_rec16 => p_edi_rec16);
2685: return 0;
2686: end if;
2687: if p_benefit_type = 'OTHER ITEMS' then
2688: hr_utility.trace('Other Items');
2689: get_other_items(p_person_id => p_person_id,
2690: p_emp_ref => p_employer_ref,
2691: p_pact_id => p_pact_id,
2692: p_edi_rec1 => p_edi_rec1,

Line 2717: hr_utility.trace('Expenses Payments');

2713: p_edi_rec22 => p_edi_rec22);
2714: return 0;
2715: end if;
2716: if p_benefit_type = 'EXPENSES PAYMENTS' then
2717: hr_utility.trace('Expenses Payments');
2718: get_exp_payment(p_person_id => p_person_id,
2719: p_emp_ref => p_employer_ref,
2720: p_pact_id => p_pact_id,
2721: p_edi_rec1 => p_edi_rec1,

Line 2744: hr_utility.trace('Marrors');

2740: p_edi_rec20 => p_edi_rec20);
2741: return 0;
2742: end if;
2743: if p_benefit_type = 'MARORS' then
2744: hr_utility.trace('Marrors');
2745: get_marors(p_person_id => p_person_id,
2746: p_emp_ref => p_employer_ref,
2747: p_pact_id => p_pact_id,
2748: p_edi_rec1 => p_edi_rec1,