eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_GB_P11D_CAR_EXTRACT dependencies on HR_UTILITY

Line 297: hr_utility.set_location('get_prim_asg_start_date',1);

293: SELECT greatest(min(paf.effective_start_date),l_ext_start_date)
294: FROM per_all_assignments_f paf
295: WHERE paf.assignment_id = p_assignment_id;
296: BEGIN
297: hr_utility.set_location('get_prim_asg_start_date',1);
298: --
299: l_bus_group_id := get_bus_group_id(p_assignment_id);
300: l_ext_start_date := get_param_ext_start_date(l_bus_group_id);
301: --

Line 302: hr_utility.set_location('get_prim_asg_start_date',2);

298: --
299: l_bus_group_id := get_bus_group_id(p_assignment_id);
300: l_ext_start_date := get_param_ext_start_date(l_bus_group_id);
301: --
302: hr_utility.set_location('get_prim_asg_start_date',2);
303: --
304: OPEN csr_asg_start_date;
305: FETCH csr_asg_start_date INTO l_asg_start_date;
306: CLOSE csr_asg_start_date;

Line 308: hr_utility.trace('GET_PRIM_ASG_START_DATE: '||to_char(l_asg_start_date,'DD-MON-YYYY'));

304: OPEN csr_asg_start_date;
305: FETCH csr_asg_start_date INTO l_asg_start_date;
306: CLOSE csr_asg_start_date;
307: --
308: hr_utility.trace('GET_PRIM_ASG_START_DATE: '||to_char(l_asg_start_date,'DD-MON-YYYY'));
309: hr_utility.set_location('get_prim_asg_start_date',99);
310: --
311: RETURN to_char(l_asg_start_date,'DD-MON-YYYY');
312: --

Line 309: hr_utility.set_location('get_prim_asg_start_date',99);

305: FETCH csr_asg_start_date INTO l_asg_start_date;
306: CLOSE csr_asg_start_date;
307: --
308: hr_utility.trace('GET_PRIM_ASG_START_DATE: '||to_char(l_asg_start_date,'DD-MON-YYYY'));
309: hr_utility.set_location('get_prim_asg_start_date',99);
310: --
311: RETURN to_char(l_asg_start_date,'DD-MON-YYYY');
312: --
313: END get_prim_asg_start_date;

Line 335: hr_utility.set_location('get_prim_asg_end_date',1);

331: where paf.assignment_id = p_assignment_id
332: and past.per_system_status = 'ACTIVE_ASSIGN'
333: and paf.assignment_status_type_id = past.assignment_status_type_id;
334: BEGIN
335: hr_utility.set_location('get_prim_asg_end_date',1);
336: --
337: l_bus_group_id := get_bus_group_id(p_assignment_id);
338: l_ext_end_date := get_param_ext_end_date(l_bus_group_id);
339: --

Line 340: hr_utility.set_location('get_prim_asg_end_date',2);

336: --
337: l_bus_group_id := get_bus_group_id(p_assignment_id);
338: l_ext_end_date := get_param_ext_end_date(l_bus_group_id);
339: --
340: hr_utility.set_location('get_prim_asg_end_date',2);
341: --
342: OPEN csr_asg_end_date;
343: FETCH csr_asg_end_date INTO l_asg_end_date;
344: CLOSE csr_asg_end_date;

Line 346: hr_utility.trace('GET_PRIM_ASG_END_DATE: '||to_char(l_asg_end_date,'DD-MON-YYYY'));

342: OPEN csr_asg_end_date;
343: FETCH csr_asg_end_date INTO l_asg_end_date;
344: CLOSE csr_asg_end_date;
345: --
346: hr_utility.trace('GET_PRIM_ASG_END_DATE: '||to_char(l_asg_end_date,'DD-MON-YYYY'));
347: hr_utility.set_location('get_prim_asg_end_date',99);
348: --
349: RETURN to_char(l_asg_end_date,'DD-MON-YYYY');
350: --

Line 347: hr_utility.set_location('get_prim_asg_end_date',99);

343: FETCH csr_asg_end_date INTO l_asg_end_date;
344: CLOSE csr_asg_end_date;
345: --
346: hr_utility.trace('GET_PRIM_ASG_END_DATE: '||to_char(l_asg_end_date,'DD-MON-YYYY'));
347: hr_utility.set_location('get_prim_asg_end_date',99);
348: --
349: RETURN to_char(l_asg_end_date,'DD-MON-YYYY');
350: --
351: END get_prim_asg_end_date;

Line 375: hr_utility.trace('Entering get_prim_ben_start_date, p_assignment_id='||p_assignment_id);

371: AND primary_company_car is NOT NULL
372: ORDER BY effective_start_date ;
373: --
374: BEGIN
375: hr_utility.trace('Entering get_prim_ben_start_date, p_assignment_id='||p_assignment_id);
376: -- Get extract start date parameter value
377: l_ext_start_date := get_param_ext_start_date(get_bus_group_id(p_assignment_id));
378: l_ext_end_date := get_param_ext_end_date(get_bus_group_id(p_assignment_id));
379: --

Line 385: hr_utility.trace('Leaving get_prim_ben_start_date, l_ben_start_date='

381: OPEN get_eff_start_date;
382: FETCH get_eff_start_date INTO l_ben_start_date;
383: CLOSE get_eff_start_date;
384: --
385: hr_utility.trace('Leaving get_prim_ben_start_date, l_ben_start_date='
386: ||to_char(l_ben_start_date, 'DD-MON-YYYY'));
387: RETURN to_char(l_ben_start_date, 'DD-MON-YYYY');
388: --
389: END get_prim_ben_start_date;

Line 419: hr_utility.trace('Entering get_prim_ben_end_date, p_assignment_id='||p_assignment_id);

415: l_prev_prim_car_fuel_ben VARCHAR2(30) := NULL;
416: l_prev_prim_comp_car NUMBER := NULL;
417: --
418: BEGIN
419: hr_utility.trace('Entering get_prim_ben_end_date, p_assignment_id='||p_assignment_id);
420: --
421: l_ext_start_date := get_param_ext_start_date(get_bus_group_id(p_assignment_id));
422: l_ext_end_date := get_param_ext_end_date(get_bus_group_id(p_assignment_id));
423: --

Line 439: hr_utility.trace('GET_PRIM_BEN_END_DATE: In Loop, effective_start_date='

435: AND nvl(l_prev_prim_car_fuel_ben, 'ZZ') = nvl(ben_details_rec.primary_car_fuel_benefit, 'ZZ')
436: AND nvl(l_prev_prim_comp_car, -999) = nvl(ben_details_rec.primary_company_car, -999)
437: AND get_ben_details%FOUND);
438: --
439: hr_utility.trace('GET_PRIM_BEN_END_DATE: In Loop, effective_start_date='
440: ||to_char(ben_details_rec.effective_start_date, 'DD-MON-YYYY'));
441: hr_utility.trace('GET_PRIM_BEN_END_DATE: In Loop, effective_end_date='
442: ||to_char(ben_details_rec.effective_end_date, 'DD-MON-YYYY'));
443: --

Line 441: hr_utility.trace('GET_PRIM_BEN_END_DATE: In Loop, effective_end_date='

437: AND get_ben_details%FOUND);
438: --
439: hr_utility.trace('GET_PRIM_BEN_END_DATE: In Loop, effective_start_date='
440: ||to_char(ben_details_rec.effective_start_date, 'DD-MON-YYYY'));
441: hr_utility.trace('GET_PRIM_BEN_END_DATE: In Loop, effective_end_date='
442: ||to_char(ben_details_rec.effective_end_date, 'DD-MON-YYYY'));
443: --
444: l_prev_eff_end_date := ben_details_rec.effective_end_date;
445: l_prev_prim_car_fuel_ben := ben_details_rec.primary_car_fuel_benefit;

Line 452: hr_utility.trace('Leaving get_prim_ben_end_date, l_prev_eff_end_date='

448: END LOOP;
449: --
450: CLOSE get_ben_details;
451: --
452: hr_utility.trace('Leaving get_prim_ben_end_date, l_prev_eff_end_date='
453: ||to_char(l_prev_eff_end_date, 'DD-MON-YYYY'));
454: RETURN to_char(least(l_prev_eff_end_date, l_ext_end_date), 'DD-MON-YYYY');
455: --
456: END get_prim_ben_end_date;

Line 479: hr_utility.trace('Entering GET_PRIM_VIN, p_assignment_id='||p_assignment_id);

475: AND paaf.assignment_id = p_assignment_id -- comes from context
476: AND pvd.vehicle_details_id = paaf.primary_company_car;
477: --
478: BEGIN
479: hr_utility.trace('Entering GET_PRIM_VIN, p_assignment_id='||p_assignment_id);
480: --
481: l_ben_start_date := fnd_date.displaydate_to_date(get_prim_ben_start_date(p_assignment_id));
482: --
483: -- Get Vehicle Identification Number

Line 488: hr_utility.trace('Leaving GET_PRIM_VIN, l_vin='||l_vin);

484: OPEN get_vin;
485: FETCH get_vin INTO l_vin;
486: CLOSE get_vin;
487: --
488: hr_utility.trace('Leaving GET_PRIM_VIN, l_vin='||l_vin);
489: RETURN l_vin;
490: --
491: END get_prim_vin;
492:

Line 514: hr_utility.trace('Entering GET_PRIM_MAKE, p_assignment_id='||p_assignment_id);

510: AND paaf.assignment_id = p_assignment_id -- comes from context
511: AND pvd.vehicle_details_id = paaf.primary_company_car;
512: --
513: BEGIN
514: hr_utility.trace('Entering GET_PRIM_MAKE, p_assignment_id='||p_assignment_id);
515: --
516: l_ben_start_date := fnd_date.displaydate_to_date(get_prim_ben_start_date(p_assignment_id));
517: --
518: -- Get make

Line 523: hr_utility.trace('Leaving GET_PRIM_MAKE, l_make='||l_make);

519: OPEN get_make;
520: FETCH get_make INTO l_make;
521: CLOSE get_make;
522: --
523: hr_utility.trace('Leaving GET_PRIM_MAKE, l_make='||l_make);
524: RETURN l_make;
525: --
526: END get_prim_make;
527:

Line 548: hr_utility.trace('Entering GET_PRIM_MODEL, p_assignment_id='||p_assignment_id);

544: AND paaf.assignment_id = p_assignment_id -- comes from context
545: AND pvd.vehicle_details_id = paaf.primary_company_car;
546: --
547: BEGIN
548: hr_utility.trace('Entering GET_PRIM_MODEL, p_assignment_id='||p_assignment_id);
549: --
550: l_ben_start_date := fnd_date.displaydate_to_date(get_prim_ben_start_date(p_assignment_id));
551: --
552: -- Get model

Line 557: hr_utility.trace('Leaving GET_PRIM_MODEL, l_model='||l_model);

553: OPEN get_model;
554: FETCH get_model INTO l_model;
555: CLOSE get_model;
556: --
557: hr_utility.trace('Leaving GET_PRIM_MODEL, l_model='||l_model);
558: RETURN l_model;
559: --
560: END get_prim_model;
561:

Line 582: hr_utility.trace('Entering GET_PRIM_DFR, p_assignment_id='||p_assignment_id);

578: AND paaf.assignment_id = p_assignment_id -- comes from context
579: AND pvd.vehicle_details_id = paaf.primary_company_car;
580: --
581: BEGIN
582: hr_utility.trace('Entering GET_PRIM_DFR, p_assignment_id='||p_assignment_id);
583: --
584: l_ben_start_date := fnd_date.displaydate_to_date(get_prim_ben_start_date(p_assignment_id));
585: --
586: -- Get date first registered

Line 591: hr_utility.trace('Leaving GET_PRIM_DFR, l_dfr='||to_char(l_dfr, 'DD-MON-YYYY'));

587: OPEN get_dfr;
588: FETCH get_dfr INTO l_dfr;
589: CLOSE get_dfr;
590: --
591: hr_utility.trace('Leaving GET_PRIM_DFR, l_dfr='||to_char(l_dfr, 'DD-MON-YYYY'));
592: RETURN to_char(l_dfr, 'DD-MON-YYYY');
593: --
594: END get_prim_dfr;
595:

Line 616: hr_utility.trace('Entering GET_PRIM_PRICE, p_assignment_id='||p_assignment_id);

612: AND paaf.assignment_id = p_assignment_id -- comes from context
613: AND pvd.vehicle_details_id = paaf.primary_company_car;
614: --
615: BEGIN
616: hr_utility.trace('Entering GET_PRIM_PRICE, p_assignment_id='||p_assignment_id);
617: --
618: l_ben_start_date := fnd_date.displaydate_to_date(get_prim_ben_start_date(p_assignment_id));
619: --
620: -- Get price

Line 625: hr_utility.trace('Leaving GET_PRIM_PRICE, l_price='||to_char(l_price));

621: OPEN get_price;
622: FETCH get_price INTO l_price;
623: CLOSE get_price;
624: --
625: hr_utility.trace('Leaving GET_PRIM_PRICE, l_price='||to_char(l_price));
626: RETURN to_char(l_price);
627: --
628: END get_prim_price;
629:

Line 665: hr_utility.trace('Entering GET_PRIM_FUEL_TYPE, p_assignment_id='||p_assignment_id);

661: AND enabled_flag = 'Y'
662: AND description = l_fuel_type
663: ORDER BY lookup_code;
664: BEGIN
665: hr_utility.trace('Entering GET_PRIM_FUEL_TYPE, p_assignment_id='||p_assignment_id);
666: --
667: l_ben_start_date := fnd_date.displaydate_to_date(get_prim_ben_start_date(p_assignment_id));
668: --
669: -- Get fuel type

Line 674: hr_utility.trace('GET_PRIM_FUEL_TYPE: l_fuel_type='||l_fuel_type);

670: OPEN get_fuel_type;
671: FETCH get_fuel_type INTO l_fuel_type;
672: CLOSE get_fuel_type;
673: --
674: hr_utility.trace('GET_PRIM_FUEL_TYPE: l_fuel_type='||l_fuel_type);
675: --
676: -- Get Translated Meaning
677: OPEN get_translation;
678: FETCH get_translation INTO l_fuel_meaning;

Line 680: hr_utility.trace('Leaving GET_PRIM_FUEL_TYPE, l_fuel_meaning='||l_fuel_meaning);

676: -- Get Translated Meaning
677: OPEN get_translation;
678: FETCH get_translation INTO l_fuel_meaning;
679: CLOSE get_translation;
680: hr_utility.trace('Leaving GET_PRIM_FUEL_TYPE, l_fuel_meaning='||l_fuel_meaning);
681: RETURN l_fuel_meaning;
682: --
683: END get_prim_fuel_type;
684:

Line 705: hr_utility.trace('Entering GET_PRIM_CO2_EMI, p_assignment_id='||p_assignment_id);

701: AND paaf.assignment_id = p_assignment_id -- comes from context
702: AND pvd.vehicle_details_id = paaf.primary_company_car;
703: --
704: BEGIN
705: hr_utility.trace('Entering GET_PRIM_CO2_EMI, p_assignment_id='||p_assignment_id);
706: --
707: l_ben_start_date := fnd_date.displaydate_to_date(get_prim_ben_start_date(p_assignment_id));
708: --
709: -- Get CO2 Emissions

Line 714: hr_utility.trace('Leaving GET_PRIM_CO2_EMI, l_co2_emi='||to_char(l_co2_emi));

710: OPEN get_co2_emi;
711: FETCH get_co2_emi INTO l_co2_emi;
712: CLOSE get_co2_emi;
713: --
714: hr_utility.trace('Leaving GET_PRIM_CO2_EMI, l_co2_emi='||to_char(l_co2_emi));
715: RETURN to_char(l_co2_emi);
716: --
717: END get_prim_co2_emi;
718:

Line 740: hr_utility.trace('Entering GET_PRIM_OPTIONAL_ACC, p_assignment_id='||p_assignment_id);

736: AND paaf.assignment_id = p_assignment_id -- comes from context
737: AND pvd.vehicle_details_id = paaf.primary_company_car;
738: --
739: BEGIN
740: hr_utility.trace('Entering GET_PRIM_OPTIONAL_ACC, p_assignment_id='||p_assignment_id);
741: --
742: l_ben_start_date := fnd_date.displaydate_to_date(get_prim_ben_start_date(p_assignment_id));
743: --
744: -- Get accessory value

Line 749: hr_utility.trace('Leaving GET_PRIM_OPTIONAL_ACC, l_opt_acc='||to_char(l_opt_acc));

745: OPEN get_opt_acc;
746: FETCH get_opt_acc INTO l_opt_acc;
747: CLOSE get_opt_acc;
748: --
749: hr_utility.trace('Leaving GET_PRIM_OPTIONAL_ACC, l_opt_acc='||to_char(l_opt_acc));
750: RETURN to_char(l_opt_acc);
751: --
752: END get_prim_optional_acc;
753:

Line 774: hr_utility.trace('Entering GET_PRIM_ACC_ADDED_AFTER, p_assignment_id='||p_assignment_id);

770: AND paaf.assignment_id = p_assignment_id -- comes from context
771: AND pvd.vehicle_details_id = paaf.primary_company_car;
772: --
773: BEGIN
774: hr_utility.trace('Entering GET_PRIM_ACC_ADDED_AFTER, p_assignment_id='||p_assignment_id);
775: --
776: l_ben_start_date := fnd_date.displaydate_to_date(get_prim_ben_start_date(p_assignment_id));
777: --
778: -- Get accessory value added later

Line 783: hr_utility.trace('Leaving GET_PRIM_ACC_ADDED_AFTER, l_acc_added='||to_char(l_acc_added));

779: OPEN get_acc_added;
780: FETCH get_acc_added INTO l_acc_added;
781: CLOSE get_acc_added;
782: --
783: hr_utility.trace('Leaving GET_PRIM_ACC_ADDED_AFTER, l_acc_added='||to_char(l_acc_added));
784: RETURN to_char(l_acc_added);
785: --
786: END get_prim_acc_added_after;
787:

Line 806: hr_utility.trace('Entering GET_PRIM_CAPITAL_CONTRIB, p_assignment_id='||p_assignment_id);

802: AND effective_end_date
803: AND assignment_id = p_assignment_id; -- comes from context
804: --
805: BEGIN
806: hr_utility.trace('Entering GET_PRIM_CAPITAL_CONTRIB, p_assignment_id='||p_assignment_id);
807: --
808: l_ben_start_date := fnd_date.displaydate_to_date(get_prim_ben_start_date(p_assignment_id));
809: --
810: -- Get Capital Contribution

Line 815: hr_utility.trace('Leaving GET_PRIM_CAPITAL_CONTRIB, l_cap_contrib='||to_char(l_cap_contrib));

811: OPEN get_cap_contrib;
812: FETCH get_cap_contrib INTO l_cap_contrib;
813: CLOSE get_cap_contrib;
814: --
815: hr_utility.trace('Leaving GET_PRIM_CAPITAL_CONTRIB, l_cap_contrib='||to_char(l_cap_contrib));
816: RETURN to_char(l_cap_contrib);
817: --
818: END get_prim_capital_contrib;
819:

Line 839: hr_utility.trace('Entering GET_PRIM_PRIVATE_CONTRIB, p_assignment_id='||p_assignment_id);

835: AND effective_end_date
836: AND assignment_id = p_assignment_id; -- comes from context
837: --
838: BEGIN
839: hr_utility.trace('Entering GET_PRIM_PRIVATE_CONTRIB, p_assignment_id='||p_assignment_id);
840: --
841: l_ben_start_date := fnd_date.displaydate_to_date(get_prim_ben_start_date(p_assignment_id));
842: --
843: -- Get Private Contribution

Line 848: hr_utility.trace('Leaving GET_PRIM_PRIVATE_CONTRIB, l_pri_contrib='||to_char(l_pri_contrib));

844: OPEN get_pri_contrib;
845: FETCH get_pri_contrib INTO l_pri_contrib;
846: CLOSE get_pri_contrib;
847: --
848: hr_utility.trace('Leaving GET_PRIM_PRIVATE_CONTRIB, l_pri_contrib='||to_char(l_pri_contrib));
849: RETURN to_char(l_pri_contrib);
850: --
851: END get_prim_private_contrib;
852:

Line 874: hr_utility.trace('Entering GET_PRIM_ENGINE_CAPACITY, p_assignment_id='||p_assignment_id);

870: AND paaf.assignment_id = p_assignment_id -- comes from context
871: AND pvd.vehicle_details_id = paaf.primary_company_car;
872: --
873: BEGIN
874: hr_utility.trace('Entering GET_PRIM_ENGINE_CAPACITY, p_assignment_id='||p_assignment_id);
875: --
876: l_ben_start_date := fnd_date.displaydate_to_date(get_prim_ben_start_date(p_assignment_id));
877: --
878: -- Get Engine Capacity

Line 883: hr_utility.trace('Leaving GET_PRIM_ENGINE_CAPACITY, l_engine_cap='||to_char(l_engine_cap));

879: OPEN get_engine_cap;
880: FETCH get_engine_cap INTO l_engine_cap;
881: CLOSE get_engine_cap;
882: --
883: hr_utility.trace('Leaving GET_PRIM_ENGINE_CAPACITY, l_engine_cap='||to_char(l_engine_cap));
884: RETURN to_char(l_engine_cap);
885: --
886: END get_prim_engine_capacity;
887:

Line 907: hr_utility.trace('Entering GET_PRIM_FUEL_BENEFIT, p_assignment_id='||p_assignment_id);

903: AND effective_end_date
904: AND assignment_id = p_assignment_id; -- comes from context
905: --
906: BEGIN
907: hr_utility.trace('Entering GET_PRIM_FUEL_BENEFIT, p_assignment_id='||p_assignment_id);
908: --
909: l_ben_start_date := fnd_date.displaydate_to_date(get_prim_ben_start_date(p_assignment_id));
910: --
911: -- Get Fuel Benefit Flag

Line 916: hr_utility.trace('Leaving GET_PRIM_FUEL_BENEFIT, l_fuel_benefit='||l_fuel_benefit);

912: OPEN get_fuel_benefit;
913: FETCH get_fuel_benefit INTO l_fuel_benefit;
914: CLOSE get_fuel_benefit;
915: --
916: hr_utility.trace('Leaving GET_PRIM_FUEL_BENEFIT, l_fuel_benefit='||l_fuel_benefit);
917: RETURN l_fuel_benefit;
918: --
919: END get_prim_fuel_benefit;
920:

Line 940: hr_utility.trace('Entering GET_PRIM_VEHICLE_DETAILS_ID, p_assignment_id='||p_assignment_id);

936: AND effective_end_date
937: AND assignment_id = p_assignment_id; -- comes from context
938: --
939: BEGIN
940: hr_utility.trace('Entering GET_PRIM_VEHICLE_DETAILS_ID, p_assignment_id='||p_assignment_id);
941: --
942: l_ben_start_date := fnd_date.displaydate_to_date(get_prim_ben_start_date(p_assignment_id));
943: --
944: hr_utility.trace('GET_PRIM_VEHICLE_DETAILS_ID: l_ben_start_date='||to_char(l_ben_start_date, 'DD-MON-YYYY'));

Line 944: hr_utility.trace('GET_PRIM_VEHICLE_DETAILS_ID: l_ben_start_date='||to_char(l_ben_start_date, 'DD-MON-YYYY'));

940: hr_utility.trace('Entering GET_PRIM_VEHICLE_DETAILS_ID, p_assignment_id='||p_assignment_id);
941: --
942: l_ben_start_date := fnd_date.displaydate_to_date(get_prim_ben_start_date(p_assignment_id));
943: --
944: hr_utility.trace('GET_PRIM_VEHICLE_DETAILS_ID: l_ben_start_date='||to_char(l_ben_start_date, 'DD-MON-YYYY'));
945: --
946: -- Get Vehicle Details Id
947: OPEN get_vehicle_details_id;
948: FETCH get_vehicle_details_id INTO l_vehicle_details_id;

Line 951: hr_utility.trace('Leaving GET_PRIM_VEHICLE_DETAILS_ID, l_vehicle_details_id='||to_char(l_vehicle_details_id));

947: OPEN get_vehicle_details_id;
948: FETCH get_vehicle_details_id INTO l_vehicle_details_id;
949: CLOSE get_vehicle_details_id;
950: --
951: hr_utility.trace('Leaving GET_PRIM_VEHICLE_DETAILS_ID, l_vehicle_details_id='||to_char(l_vehicle_details_id));
952: RETURN to_char(l_vehicle_details_id);
953: --
954: END get_prim_vehicle_details_id;
955:

Line 1030: hr_utility.trace('Entering CHECK_ASG_INCLUSION, p_assignment_id='||p_assignment_id);

1026: AND pvd.vehicle_type = 'C'
1027: AND pvd.vehicle_ownership = 'C'
1028: AND l_ext_start_date >= fnd_date.canonical_to_date('2003/04/06'); -- BUG 3431106 Using canonical_to_date function
1029: BEGIN
1030: hr_utility.trace('Entering CHECK_ASG_INCLUSION, p_assignment_id='||p_assignment_id);
1031: -- Get Business Group Id
1032: l_bus_group_id := get_bus_group_id(p_assignment_id);
1033: -- Get Input Parameter Values
1034: l_ext_start_date := get_param_ext_start_date(l_bus_group_id);

Line 1042: hr_utility.trace('CHECK_ASG_INCLUSION: l_ext_start_date='||to_char(l_ext_start_date, 'DD-MON-YYYY'));

1038: l_ext_tax_dist := get_param_tax_dist(l_bus_group_id);
1039: l_ext_con_set_id := get_param_consolidation_set_id(l_bus_group_id);
1040: l_ext_asg_set_id := get_param_assignment_set_id(l_bus_group_id);
1041: --
1042: hr_utility.trace('CHECK_ASG_INCLUSION: l_ext_start_date='||to_char(l_ext_start_date, 'DD-MON-YYYY'));
1043: hr_utility.trace('CHECK_ASG_INCLUSION: l_ext_end_date='||to_char(l_ext_end_date, 'DD-MON-YYYY'));
1044: hr_utility.trace('CHECK_ASG_INCLUSION: l_ext_payroll_id='||to_char(l_ext_payroll_id));
1045: hr_utility.trace('CHECK_ASG_INCLUSION: l_ext_tax_dist='||l_ext_tax_dist);
1046: hr_utility.trace('CHECK_ASG_INCLUSION: l_ext_con_set_id='||to_char(l_ext_con_set_id));

Line 1043: hr_utility.trace('CHECK_ASG_INCLUSION: l_ext_end_date='||to_char(l_ext_end_date, 'DD-MON-YYYY'));

1039: l_ext_con_set_id := get_param_consolidation_set_id(l_bus_group_id);
1040: l_ext_asg_set_id := get_param_assignment_set_id(l_bus_group_id);
1041: --
1042: hr_utility.trace('CHECK_ASG_INCLUSION: l_ext_start_date='||to_char(l_ext_start_date, 'DD-MON-YYYY'));
1043: hr_utility.trace('CHECK_ASG_INCLUSION: l_ext_end_date='||to_char(l_ext_end_date, 'DD-MON-YYYY'));
1044: hr_utility.trace('CHECK_ASG_INCLUSION: l_ext_payroll_id='||to_char(l_ext_payroll_id));
1045: hr_utility.trace('CHECK_ASG_INCLUSION: l_ext_tax_dist='||l_ext_tax_dist);
1046: hr_utility.trace('CHECK_ASG_INCLUSION: l_ext_con_set_id='||to_char(l_ext_con_set_id));
1047: hr_utility.trace('CHECK_ASG_INCLUSION: l_ext_asg_set_id='||to_char(l_ext_asg_set_id));

Line 1044: hr_utility.trace('CHECK_ASG_INCLUSION: l_ext_payroll_id='||to_char(l_ext_payroll_id));

1040: l_ext_asg_set_id := get_param_assignment_set_id(l_bus_group_id);
1041: --
1042: hr_utility.trace('CHECK_ASG_INCLUSION: l_ext_start_date='||to_char(l_ext_start_date, 'DD-MON-YYYY'));
1043: hr_utility.trace('CHECK_ASG_INCLUSION: l_ext_end_date='||to_char(l_ext_end_date, 'DD-MON-YYYY'));
1044: hr_utility.trace('CHECK_ASG_INCLUSION: l_ext_payroll_id='||to_char(l_ext_payroll_id));
1045: hr_utility.trace('CHECK_ASG_INCLUSION: l_ext_tax_dist='||l_ext_tax_dist);
1046: hr_utility.trace('CHECK_ASG_INCLUSION: l_ext_con_set_id='||to_char(l_ext_con_set_id));
1047: hr_utility.trace('CHECK_ASG_INCLUSION: l_ext_asg_set_id='||to_char(l_ext_asg_set_id));
1048: --

Line 1045: hr_utility.trace('CHECK_ASG_INCLUSION: l_ext_tax_dist='||l_ext_tax_dist);

1041: --
1042: hr_utility.trace('CHECK_ASG_INCLUSION: l_ext_start_date='||to_char(l_ext_start_date, 'DD-MON-YYYY'));
1043: hr_utility.trace('CHECK_ASG_INCLUSION: l_ext_end_date='||to_char(l_ext_end_date, 'DD-MON-YYYY'));
1044: hr_utility.trace('CHECK_ASG_INCLUSION: l_ext_payroll_id='||to_char(l_ext_payroll_id));
1045: hr_utility.trace('CHECK_ASG_INCLUSION: l_ext_tax_dist='||l_ext_tax_dist);
1046: hr_utility.trace('CHECK_ASG_INCLUSION: l_ext_con_set_id='||to_char(l_ext_con_set_id));
1047: hr_utility.trace('CHECK_ASG_INCLUSION: l_ext_asg_set_id='||to_char(l_ext_asg_set_id));
1048: --
1049: -- Get details of primary assignment

Line 1046: hr_utility.trace('CHECK_ASG_INCLUSION: l_ext_con_set_id='||to_char(l_ext_con_set_id));

1042: hr_utility.trace('CHECK_ASG_INCLUSION: l_ext_start_date='||to_char(l_ext_start_date, 'DD-MON-YYYY'));
1043: hr_utility.trace('CHECK_ASG_INCLUSION: l_ext_end_date='||to_char(l_ext_end_date, 'DD-MON-YYYY'));
1044: hr_utility.trace('CHECK_ASG_INCLUSION: l_ext_payroll_id='||to_char(l_ext_payroll_id));
1045: hr_utility.trace('CHECK_ASG_INCLUSION: l_ext_tax_dist='||l_ext_tax_dist);
1046: hr_utility.trace('CHECK_ASG_INCLUSION: l_ext_con_set_id='||to_char(l_ext_con_set_id));
1047: hr_utility.trace('CHECK_ASG_INCLUSION: l_ext_asg_set_id='||to_char(l_ext_asg_set_id));
1048: --
1049: -- Get details of primary assignment
1050: -- Start with effective dates

Line 1047: hr_utility.trace('CHECK_ASG_INCLUSION: l_ext_asg_set_id='||to_char(l_ext_asg_set_id));

1043: hr_utility.trace('CHECK_ASG_INCLUSION: l_ext_end_date='||to_char(l_ext_end_date, 'DD-MON-YYYY'));
1044: hr_utility.trace('CHECK_ASG_INCLUSION: l_ext_payroll_id='||to_char(l_ext_payroll_id));
1045: hr_utility.trace('CHECK_ASG_INCLUSION: l_ext_tax_dist='||l_ext_tax_dist);
1046: hr_utility.trace('CHECK_ASG_INCLUSION: l_ext_con_set_id='||to_char(l_ext_con_set_id));
1047: hr_utility.trace('CHECK_ASG_INCLUSION: l_ext_asg_set_id='||to_char(l_ext_asg_set_id));
1048: --
1049: -- Get details of primary assignment
1050: -- Start with effective dates
1051: OPEN get_asg_eff_dates(p_assignment_id);

Line 1055: hr_utility.trace('CHECK_ASG_INCLUSION: l_min_start_date='||to_char(l_min_start_date, 'DD-MON-YYYY'));

1051: OPEN get_asg_eff_dates(p_assignment_id);
1052: FETCH get_asg_eff_dates INTO l_min_start_date, l_max_end_date;
1053: CLOSE get_asg_eff_dates;
1054: --
1055: hr_utility.trace('CHECK_ASG_INCLUSION: l_min_start_date='||to_char(l_min_start_date, 'DD-MON-YYYY'));
1056: hr_utility.trace('CHECK_ASG_INCLUSION: l_max_end_date='||to_char(l_max_end_date, 'DD-MON-YYYY'));
1057: --
1058: IF l_min_start_date > l_ext_end_date OR l_max_end_date < l_ext_start_date THEN
1059: -- Person not active within input date range therefore exclude

Line 1056: hr_utility.trace('CHECK_ASG_INCLUSION: l_max_end_date='||to_char(l_max_end_date, 'DD-MON-YYYY'));

1052: FETCH get_asg_eff_dates INTO l_min_start_date, l_max_end_date;
1053: CLOSE get_asg_eff_dates;
1054: --
1055: hr_utility.trace('CHECK_ASG_INCLUSION: l_min_start_date='||to_char(l_min_start_date, 'DD-MON-YYYY'));
1056: hr_utility.trace('CHECK_ASG_INCLUSION: l_max_end_date='||to_char(l_max_end_date, 'DD-MON-YYYY'));
1057: --
1058: IF l_min_start_date > l_ext_end_date OR l_max_end_date < l_ext_start_date THEN
1059: -- Person not active within input date range therefore exclude
1060: RETURN 'N';

Line 1073: hr_utility.trace('CHECK_ASG_INCLUSION: l_asg_set_include='||l_asg_set_include);

1069: ELSE
1070: l_asg_set_include := 'Y'; -- no input asg set specified
1071: END IF;
1072: --
1073: hr_utility.trace('CHECK_ASG_INCLUSION: l_asg_set_include='||l_asg_set_include);
1074: -- Loop through all changes in the assignment during the input date range
1075: FOR asg_det_rec IN get_asg_details(p_assignment_id) LOOP
1076: --
1077: hr_utility.trace('CHECK_ASG_INCLUSION: asg_det_rec.payroll_id='||asg_det_rec.payroll_id);

Line 1077: hr_utility.trace('CHECK_ASG_INCLUSION: asg_det_rec.payroll_id='||asg_det_rec.payroll_id);

1073: hr_utility.trace('CHECK_ASG_INCLUSION: l_asg_set_include='||l_asg_set_include);
1074: -- Loop through all changes in the assignment during the input date range
1075: FOR asg_det_rec IN get_asg_details(p_assignment_id) LOOP
1076: --
1077: hr_utility.trace('CHECK_ASG_INCLUSION: asg_det_rec.payroll_id='||asg_det_rec.payroll_id);
1078: hr_utility.trace('CHECK_ASG_INCLUSION: asg_det_rec.person_id='||asg_det_rec.person_id);
1079: hr_utility.trace('CHECK_ASG_INCLUSION: asg_det_rec.tax_dist='||asg_det_rec.tax_dist);
1080: hr_utility.trace('CHECK_ASG_INCLUSION: asg_det_rec.consolidation_set_id='||asg_det_rec.consolidation_set_id);
1081: --

Line 1078: hr_utility.trace('CHECK_ASG_INCLUSION: asg_det_rec.person_id='||asg_det_rec.person_id);

1074: -- Loop through all changes in the assignment during the input date range
1075: FOR asg_det_rec IN get_asg_details(p_assignment_id) LOOP
1076: --
1077: hr_utility.trace('CHECK_ASG_INCLUSION: asg_det_rec.payroll_id='||asg_det_rec.payroll_id);
1078: hr_utility.trace('CHECK_ASG_INCLUSION: asg_det_rec.person_id='||asg_det_rec.person_id);
1079: hr_utility.trace('CHECK_ASG_INCLUSION: asg_det_rec.tax_dist='||asg_det_rec.tax_dist);
1080: hr_utility.trace('CHECK_ASG_INCLUSION: asg_det_rec.consolidation_set_id='||asg_det_rec.consolidation_set_id);
1081: --
1082: IF (nvl(l_ext_payroll_id, nvl(asg_det_rec.payroll_id, -999)) = nvl(asg_det_rec.payroll_id, -999)

Line 1079: hr_utility.trace('CHECK_ASG_INCLUSION: asg_det_rec.tax_dist='||asg_det_rec.tax_dist);

1075: FOR asg_det_rec IN get_asg_details(p_assignment_id) LOOP
1076: --
1077: hr_utility.trace('CHECK_ASG_INCLUSION: asg_det_rec.payroll_id='||asg_det_rec.payroll_id);
1078: hr_utility.trace('CHECK_ASG_INCLUSION: asg_det_rec.person_id='||asg_det_rec.person_id);
1079: hr_utility.trace('CHECK_ASG_INCLUSION: asg_det_rec.tax_dist='||asg_det_rec.tax_dist);
1080: hr_utility.trace('CHECK_ASG_INCLUSION: asg_det_rec.consolidation_set_id='||asg_det_rec.consolidation_set_id);
1081: --
1082: IF (nvl(l_ext_payroll_id, nvl(asg_det_rec.payroll_id, -999)) = nvl(asg_det_rec.payroll_id, -999)
1083: AND nvl(l_ext_person_id, nvl(asg_det_rec.person_id, -999)) = nvl(asg_det_rec.person_id, -999)

Line 1080: hr_utility.trace('CHECK_ASG_INCLUSION: asg_det_rec.consolidation_set_id='||asg_det_rec.consolidation_set_id);

1076: --
1077: hr_utility.trace('CHECK_ASG_INCLUSION: asg_det_rec.payroll_id='||asg_det_rec.payroll_id);
1078: hr_utility.trace('CHECK_ASG_INCLUSION: asg_det_rec.person_id='||asg_det_rec.person_id);
1079: hr_utility.trace('CHECK_ASG_INCLUSION: asg_det_rec.tax_dist='||asg_det_rec.tax_dist);
1080: hr_utility.trace('CHECK_ASG_INCLUSION: asg_det_rec.consolidation_set_id='||asg_det_rec.consolidation_set_id);
1081: --
1082: IF (nvl(l_ext_payroll_id, nvl(asg_det_rec.payroll_id, -999)) = nvl(asg_det_rec.payroll_id, -999)
1083: AND nvl(l_ext_person_id, nvl(asg_det_rec.person_id, -999)) = nvl(asg_det_rec.person_id, -999)
1084: AND nvl(l_ext_tax_dist, nvl(asg_det_rec.tax_dist, 'ZZZ')) = nvl(asg_det_rec.tax_dist, 'ZZZ')

Line 1093: hr_utility.trace('CHECK_ASG_INCLUSION: In Loop, l_asg_include='||l_asg_include);

1089: OPEN check_vehicle_details(p_assignment_id);
1090: FETCH check_vehicle_details INTO l_asg_include;
1091: CLOSE check_vehicle_details;
1092: --
1093: hr_utility.trace('CHECK_ASG_INCLUSION: In Loop, l_asg_include='||l_asg_include);
1094: END IF;
1095: END LOOP;
1096: --
1097: hr_utility.trace('Leaving CHECK_ASG_INCLUSION, l_asg_include='||l_asg_include);

Line 1097: hr_utility.trace('Leaving CHECK_ASG_INCLUSION, l_asg_include='||l_asg_include);

1093: hr_utility.trace('CHECK_ASG_INCLUSION: In Loop, l_asg_include='||l_asg_include);
1094: END IF;
1095: END LOOP;
1096: --
1097: hr_utility.trace('Leaving CHECK_ASG_INCLUSION, l_asg_include='||l_asg_include);
1098: RETURN l_asg_include;
1099: --
1100: END check_asg_inclusion;
1101:

Line 1121: hr_utility.trace('Entering CHECK_PERSON_INCLUSION, p_assignment_id='||p_assignment_id);

1117: ORDER BY paa1.assignment_id;
1118: --
1119: l_asg_id NUMBER;
1120: BEGIN
1121: hr_utility.trace('Entering CHECK_PERSON_INCLUSION, p_assignment_id='||p_assignment_id);
1122: -- check whether any assignment qualifies
1123: OPEN get_all_asg;
1124: LOOP
1125: FETCH get_all_asg INTO l_asg_id;

Line 1132: hr_utility.trace('Leaving CHECK_PERSON_INCLUSION, l_person_include='||l_person_include);

1128: END IF;
1129: EXIT WHEN (get_all_asg%NOTFOUND OR l_person_include = 'Y');
1130: END LOOP;
1131: --
1132: hr_utility.trace('Leaving CHECK_PERSON_INCLUSION, l_person_include='||l_person_include);
1133: RETURN l_person_include;
1134: --
1135: END check_person_inclusion;
1136:

Line 1201: hr_utility.trace('Entering CREATE_EXT_RSLT_DTL: p_asg_id='|| p_asg_id);

1197: AND val_29 = to_char(p_vehicle_details_id);
1198: --
1199: l_chk_exists chk_exists%ROWTYPE;
1200: BEGIN
1201: hr_utility.trace('Entering CREATE_EXT_RSLT_DTL: p_asg_id='|| p_asg_id);
1202: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_asg_start_date='||to_char(p_asg_start_date, 'DD-MON-YYYY'));
1203: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_asg_end_date='||to_char(p_asg_end_date, 'DD-MON-YYYY'));
1204: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_benefit_start_date='||to_char(p_benefit_start_date, 'DD-MON-YYYY'));
1205: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_benefit_end_date='||to_char(p_benefit_end_date, 'DD-MON-YYYY'));

Line 1202: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_asg_start_date='||to_char(p_asg_start_date, 'DD-MON-YYYY'));

1198: --
1199: l_chk_exists chk_exists%ROWTYPE;
1200: BEGIN
1201: hr_utility.trace('Entering CREATE_EXT_RSLT_DTL: p_asg_id='|| p_asg_id);
1202: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_asg_start_date='||to_char(p_asg_start_date, 'DD-MON-YYYY'));
1203: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_asg_end_date='||to_char(p_asg_end_date, 'DD-MON-YYYY'));
1204: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_benefit_start_date='||to_char(p_benefit_start_date, 'DD-MON-YYYY'));
1205: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_benefit_end_date='||to_char(p_benefit_end_date, 'DD-MON-YYYY'));
1206: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_car_fuel_benefit='||p_car_fuel_benefit);

Line 1203: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_asg_end_date='||to_char(p_asg_end_date, 'DD-MON-YYYY'));

1199: l_chk_exists chk_exists%ROWTYPE;
1200: BEGIN
1201: hr_utility.trace('Entering CREATE_EXT_RSLT_DTL: p_asg_id='|| p_asg_id);
1202: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_asg_start_date='||to_char(p_asg_start_date, 'DD-MON-YYYY'));
1203: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_asg_end_date='||to_char(p_asg_end_date, 'DD-MON-YYYY'));
1204: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_benefit_start_date='||to_char(p_benefit_start_date, 'DD-MON-YYYY'));
1205: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_benefit_end_date='||to_char(p_benefit_end_date, 'DD-MON-YYYY'));
1206: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_car_fuel_benefit='||p_car_fuel_benefit);
1207: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_vehicle_details_id='||p_vehicle_details_id);

Line 1204: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_benefit_start_date='||to_char(p_benefit_start_date, 'DD-MON-YYYY'));

1200: BEGIN
1201: hr_utility.trace('Entering CREATE_EXT_RSLT_DTL: p_asg_id='|| p_asg_id);
1202: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_asg_start_date='||to_char(p_asg_start_date, 'DD-MON-YYYY'));
1203: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_asg_end_date='||to_char(p_asg_end_date, 'DD-MON-YYYY'));
1204: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_benefit_start_date='||to_char(p_benefit_start_date, 'DD-MON-YYYY'));
1205: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_benefit_end_date='||to_char(p_benefit_end_date, 'DD-MON-YYYY'));
1206: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_car_fuel_benefit='||p_car_fuel_benefit);
1207: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_vehicle_details_id='||p_vehicle_details_id);
1208: hr_utility.trace('CREATE_EXT_RSLT_DTL: g_ext_rslt_id='||g_ext_rslt_id);

Line 1205: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_benefit_end_date='||to_char(p_benefit_end_date, 'DD-MON-YYYY'));

1201: hr_utility.trace('Entering CREATE_EXT_RSLT_DTL: p_asg_id='|| p_asg_id);
1202: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_asg_start_date='||to_char(p_asg_start_date, 'DD-MON-YYYY'));
1203: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_asg_end_date='||to_char(p_asg_end_date, 'DD-MON-YYYY'));
1204: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_benefit_start_date='||to_char(p_benefit_start_date, 'DD-MON-YYYY'));
1205: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_benefit_end_date='||to_char(p_benefit_end_date, 'DD-MON-YYYY'));
1206: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_car_fuel_benefit='||p_car_fuel_benefit);
1207: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_vehicle_details_id='||p_vehicle_details_id);
1208: hr_utility.trace('CREATE_EXT_RSLT_DTL: g_ext_rslt_id='||g_ext_rslt_id);
1209: hr_utility.trace('CREATE_EXT_RSLT_DTL: g_person_id='||g_person_id);

Line 1206: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_car_fuel_benefit='||p_car_fuel_benefit);

1202: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_asg_start_date='||to_char(p_asg_start_date, 'DD-MON-YYYY'));
1203: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_asg_end_date='||to_char(p_asg_end_date, 'DD-MON-YYYY'));
1204: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_benefit_start_date='||to_char(p_benefit_start_date, 'DD-MON-YYYY'));
1205: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_benefit_end_date='||to_char(p_benefit_end_date, 'DD-MON-YYYY'));
1206: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_car_fuel_benefit='||p_car_fuel_benefit);
1207: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_vehicle_details_id='||p_vehicle_details_id);
1208: hr_utility.trace('CREATE_EXT_RSLT_DTL: g_ext_rslt_id='||g_ext_rslt_id);
1209: hr_utility.trace('CREATE_EXT_RSLT_DTL: g_person_id='||g_person_id);
1210: hr_utility.trace('CREATE_EXT_RSLT_DTL: g_veh_rcd_id='||g_veh_rcd_id);

Line 1207: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_vehicle_details_id='||p_vehicle_details_id);

1203: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_asg_end_date='||to_char(p_asg_end_date, 'DD-MON-YYYY'));
1204: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_benefit_start_date='||to_char(p_benefit_start_date, 'DD-MON-YYYY'));
1205: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_benefit_end_date='||to_char(p_benefit_end_date, 'DD-MON-YYYY'));
1206: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_car_fuel_benefit='||p_car_fuel_benefit);
1207: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_vehicle_details_id='||p_vehicle_details_id);
1208: hr_utility.trace('CREATE_EXT_RSLT_DTL: g_ext_rslt_id='||g_ext_rslt_id);
1209: hr_utility.trace('CREATE_EXT_RSLT_DTL: g_person_id='||g_person_id);
1210: hr_utility.trace('CREATE_EXT_RSLT_DTL: g_veh_rcd_id='||g_veh_rcd_id);
1211: -- Get Vehicle Details

Line 1208: hr_utility.trace('CREATE_EXT_RSLT_DTL: g_ext_rslt_id='||g_ext_rslt_id);

1204: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_benefit_start_date='||to_char(p_benefit_start_date, 'DD-MON-YYYY'));
1205: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_benefit_end_date='||to_char(p_benefit_end_date, 'DD-MON-YYYY'));
1206: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_car_fuel_benefit='||p_car_fuel_benefit);
1207: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_vehicle_details_id='||p_vehicle_details_id);
1208: hr_utility.trace('CREATE_EXT_RSLT_DTL: g_ext_rslt_id='||g_ext_rslt_id);
1209: hr_utility.trace('CREATE_EXT_RSLT_DTL: g_person_id='||g_person_id);
1210: hr_utility.trace('CREATE_EXT_RSLT_DTL: g_veh_rcd_id='||g_veh_rcd_id);
1211: -- Get Vehicle Details
1212: OPEN get_vehicle_details;

Line 1209: hr_utility.trace('CREATE_EXT_RSLT_DTL: g_person_id='||g_person_id);

1205: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_benefit_end_date='||to_char(p_benefit_end_date, 'DD-MON-YYYY'));
1206: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_car_fuel_benefit='||p_car_fuel_benefit);
1207: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_vehicle_details_id='||p_vehicle_details_id);
1208: hr_utility.trace('CREATE_EXT_RSLT_DTL: g_ext_rslt_id='||g_ext_rslt_id);
1209: hr_utility.trace('CREATE_EXT_RSLT_DTL: g_person_id='||g_person_id);
1210: hr_utility.trace('CREATE_EXT_RSLT_DTL: g_veh_rcd_id='||g_veh_rcd_id);
1211: -- Get Vehicle Details
1212: OPEN get_vehicle_details;
1213: FETCH get_vehicle_details INTO l_vehicle_rec;

Line 1210: hr_utility.trace('CREATE_EXT_RSLT_DTL: g_veh_rcd_id='||g_veh_rcd_id);

1206: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_car_fuel_benefit='||p_car_fuel_benefit);
1207: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_vehicle_details_id='||p_vehicle_details_id);
1208: hr_utility.trace('CREATE_EXT_RSLT_DTL: g_ext_rslt_id='||g_ext_rslt_id);
1209: hr_utility.trace('CREATE_EXT_RSLT_DTL: g_person_id='||g_person_id);
1210: hr_utility.trace('CREATE_EXT_RSLT_DTL: g_veh_rcd_id='||g_veh_rcd_id);
1211: -- Get Vehicle Details
1212: OPEN get_vehicle_details;
1213: FETCH get_vehicle_details INTO l_vehicle_rec;
1214: CLOSE get_vehicle_details;

Line 1228: hr_utility.trace('CREATE_EXT_RSLT_DTL: Insert result details.');

1224: IF chk_exists%NOTFOUND THEN
1225: -- Record does not exist
1226: -- Call API to create extract details record
1227: BEGIN
1228: hr_utility.trace('CREATE_EXT_RSLT_DTL: Insert result details.');
1229: ben_ext_rslt_dtl_api.create_ext_rslt_dtl( p_ext_rslt_dtl_id => l_ext_rslt_dtl_id
1230: ,p_ext_rslt_id => g_ext_rslt_id
1231: ,p_ext_rcd_id => g_veh_rcd_id
1232: ,p_person_id => g_person_id

Line 1265: hr_utility.trace('CREATE_EXT_RSLT_DTL: '||substr(sqlerrm, 1, 100));

1261: ,p_val_28 => '~~~~~~~~~~~~~~~~~~~'
1262: ,p_val_29 => to_char(p_vehicle_details_id)
1263: ,p_object_version_number => l_object_version_no);
1264: EXCEPTION WHEN others THEN
1265: hr_utility.trace('CREATE_EXT_RSLT_DTL: '||substr(sqlerrm, 1, 100));
1266: hr_utility.trace('CREATE_EXT_RSLT_DTL: '||substr(sqlerrm, 101, 100));
1267: hr_utility.trace('CREATE_EXT_RSLT_DTL: '||substr(sqlerrm, 201, 100));
1268: hr_utility.trace('CREATE_EXT_RSLT_DTL: '||substr(sqlerrm, 301, 100));
1269: RAISE;

Line 1266: hr_utility.trace('CREATE_EXT_RSLT_DTL: '||substr(sqlerrm, 101, 100));

1262: ,p_val_29 => to_char(p_vehicle_details_id)
1263: ,p_object_version_number => l_object_version_no);
1264: EXCEPTION WHEN others THEN
1265: hr_utility.trace('CREATE_EXT_RSLT_DTL: '||substr(sqlerrm, 1, 100));
1266: hr_utility.trace('CREATE_EXT_RSLT_DTL: '||substr(sqlerrm, 101, 100));
1267: hr_utility.trace('CREATE_EXT_RSLT_DTL: '||substr(sqlerrm, 201, 100));
1268: hr_utility.trace('CREATE_EXT_RSLT_DTL: '||substr(sqlerrm, 301, 100));
1269: RAISE;
1270: END;

Line 1267: hr_utility.trace('CREATE_EXT_RSLT_DTL: '||substr(sqlerrm, 201, 100));

1263: ,p_object_version_number => l_object_version_no);
1264: EXCEPTION WHEN others THEN
1265: hr_utility.trace('CREATE_EXT_RSLT_DTL: '||substr(sqlerrm, 1, 100));
1266: hr_utility.trace('CREATE_EXT_RSLT_DTL: '||substr(sqlerrm, 101, 100));
1267: hr_utility.trace('CREATE_EXT_RSLT_DTL: '||substr(sqlerrm, 201, 100));
1268: hr_utility.trace('CREATE_EXT_RSLT_DTL: '||substr(sqlerrm, 301, 100));
1269: RAISE;
1270: END;
1271: END IF;

Line 1268: hr_utility.trace('CREATE_EXT_RSLT_DTL: '||substr(sqlerrm, 301, 100));

1264: EXCEPTION WHEN others THEN
1265: hr_utility.trace('CREATE_EXT_RSLT_DTL: '||substr(sqlerrm, 1, 100));
1266: hr_utility.trace('CREATE_EXT_RSLT_DTL: '||substr(sqlerrm, 101, 100));
1267: hr_utility.trace('CREATE_EXT_RSLT_DTL: '||substr(sqlerrm, 201, 100));
1268: hr_utility.trace('CREATE_EXT_RSLT_DTL: '||substr(sqlerrm, 301, 100));
1269: RAISE;
1270: END;
1271: END IF;
1272: --

Line 1305: hr_utility.trace('Entering PROCESS_PRIM_VEH, p_asg_id='||p_asg_id);

1301: l_prev_veh_id_rec get_veh_id%ROWTYPE;
1302: --
1303: l_new_rec BOOLEAN := TRUE;
1304: BEGIN
1305: hr_utility.trace('Entering PROCESS_PRIM_VEH, p_asg_id='||p_asg_id);
1306: -- Get extract date parameter values
1307: l_ext_start_date := get_param_ext_start_date(get_bus_group_id(p_asg_id));
1308: l_ext_end_date := get_param_ext_end_date(get_bus_group_id(p_asg_id));
1309: -- Get Assignment Start and End Dates

Line 1318: hr_utility.trace('PROCESS_PRIM_VEH, After Fetch.');

1314: -- Loop through all vehicle records and create extract result detail
1315: -- record if there is a change in primary_car_fuel_benifit or vehicle id
1316: LOOP
1317: FETCH get_veh_id INTO l_veh_id_rec;
1318: hr_utility.trace('PROCESS_PRIM_VEH, After Fetch.');
1319: hr_utility.trace('PROCESS_PRIM_VEH, effective_start_date='||to_char(l_veh_id_rec.effective_start_date, 'DD-MON-YYYY'));
1320: hr_utility.trace('PROCESS_PRIM_VEH, effective_end_date='||to_char(l_veh_id_rec.effective_end_date, 'DD-MON-YYYY'));
1321: hr_utility.trace('PROCESS_PRIM_VEH, primary_car_fuel_benefit='||l_veh_id_rec.primary_car_fuel_benefit);
1322: hr_utility.trace('PROCESS_PRIM_VEH, primary_company_car='||l_veh_id_rec.primary_company_car);

Line 1319: hr_utility.trace('PROCESS_PRIM_VEH, effective_start_date='||to_char(l_veh_id_rec.effective_start_date, 'DD-MON-YYYY'));

1315: -- record if there is a change in primary_car_fuel_benifit or vehicle id
1316: LOOP
1317: FETCH get_veh_id INTO l_veh_id_rec;
1318: hr_utility.trace('PROCESS_PRIM_VEH, After Fetch.');
1319: hr_utility.trace('PROCESS_PRIM_VEH, effective_start_date='||to_char(l_veh_id_rec.effective_start_date, 'DD-MON-YYYY'));
1320: hr_utility.trace('PROCESS_PRIM_VEH, effective_end_date='||to_char(l_veh_id_rec.effective_end_date, 'DD-MON-YYYY'));
1321: hr_utility.trace('PROCESS_PRIM_VEH, primary_car_fuel_benefit='||l_veh_id_rec.primary_car_fuel_benefit);
1322: hr_utility.trace('PROCESS_PRIM_VEH, primary_company_car='||l_veh_id_rec.primary_company_car);
1323: IF l_new_rec THEN

Line 1320: hr_utility.trace('PROCESS_PRIM_VEH, effective_end_date='||to_char(l_veh_id_rec.effective_end_date, 'DD-MON-YYYY'));

1316: LOOP
1317: FETCH get_veh_id INTO l_veh_id_rec;
1318: hr_utility.trace('PROCESS_PRIM_VEH, After Fetch.');
1319: hr_utility.trace('PROCESS_PRIM_VEH, effective_start_date='||to_char(l_veh_id_rec.effective_start_date, 'DD-MON-YYYY'));
1320: hr_utility.trace('PROCESS_PRIM_VEH, effective_end_date='||to_char(l_veh_id_rec.effective_end_date, 'DD-MON-YYYY'));
1321: hr_utility.trace('PROCESS_PRIM_VEH, primary_car_fuel_benefit='||l_veh_id_rec.primary_car_fuel_benefit);
1322: hr_utility.trace('PROCESS_PRIM_VEH, primary_company_car='||l_veh_id_rec.primary_company_car);
1323: IF l_new_rec THEN
1324: hr_utility.trace('PROCESS_PRIM_VEH, l_new_rec=TRUE');

Line 1321: hr_utility.trace('PROCESS_PRIM_VEH, primary_car_fuel_benefit='||l_veh_id_rec.primary_car_fuel_benefit);

1317: FETCH get_veh_id INTO l_veh_id_rec;
1318: hr_utility.trace('PROCESS_PRIM_VEH, After Fetch.');
1319: hr_utility.trace('PROCESS_PRIM_VEH, effective_start_date='||to_char(l_veh_id_rec.effective_start_date, 'DD-MON-YYYY'));
1320: hr_utility.trace('PROCESS_PRIM_VEH, effective_end_date='||to_char(l_veh_id_rec.effective_end_date, 'DD-MON-YYYY'));
1321: hr_utility.trace('PROCESS_PRIM_VEH, primary_car_fuel_benefit='||l_veh_id_rec.primary_car_fuel_benefit);
1322: hr_utility.trace('PROCESS_PRIM_VEH, primary_company_car='||l_veh_id_rec.primary_company_car);
1323: IF l_new_rec THEN
1324: hr_utility.trace('PROCESS_PRIM_VEH, l_new_rec=TRUE');
1325: ELSE

Line 1322: hr_utility.trace('PROCESS_PRIM_VEH, primary_company_car='||l_veh_id_rec.primary_company_car);

1318: hr_utility.trace('PROCESS_PRIM_VEH, After Fetch.');
1319: hr_utility.trace('PROCESS_PRIM_VEH, effective_start_date='||to_char(l_veh_id_rec.effective_start_date, 'DD-MON-YYYY'));
1320: hr_utility.trace('PROCESS_PRIM_VEH, effective_end_date='||to_char(l_veh_id_rec.effective_end_date, 'DD-MON-YYYY'));
1321: hr_utility.trace('PROCESS_PRIM_VEH, primary_car_fuel_benefit='||l_veh_id_rec.primary_car_fuel_benefit);
1322: hr_utility.trace('PROCESS_PRIM_VEH, primary_company_car='||l_veh_id_rec.primary_company_car);
1323: IF l_new_rec THEN
1324: hr_utility.trace('PROCESS_PRIM_VEH, l_new_rec=TRUE');
1325: ELSE
1326: hr_utility.trace('PROCESS_PRIM_VEH, l_new_rec=FALSE');

Line 1324: hr_utility.trace('PROCESS_PRIM_VEH, l_new_rec=TRUE');

1320: hr_utility.trace('PROCESS_PRIM_VEH, effective_end_date='||to_char(l_veh_id_rec.effective_end_date, 'DD-MON-YYYY'));
1321: hr_utility.trace('PROCESS_PRIM_VEH, primary_car_fuel_benefit='||l_veh_id_rec.primary_car_fuel_benefit);
1322: hr_utility.trace('PROCESS_PRIM_VEH, primary_company_car='||l_veh_id_rec.primary_company_car);
1323: IF l_new_rec THEN
1324: hr_utility.trace('PROCESS_PRIM_VEH, l_new_rec=TRUE');
1325: ELSE
1326: hr_utility.trace('PROCESS_PRIM_VEH, l_new_rec=FALSE');
1327: END IF;
1328: --

Line 1326: hr_utility.trace('PROCESS_PRIM_VEH, l_new_rec=FALSE');

1322: hr_utility.trace('PROCESS_PRIM_VEH, primary_company_car='||l_veh_id_rec.primary_company_car);
1323: IF l_new_rec THEN
1324: hr_utility.trace('PROCESS_PRIM_VEH, l_new_rec=TRUE');
1325: ELSE
1326: hr_utility.trace('PROCESS_PRIM_VEH, l_new_rec=FALSE');
1327: END IF;
1328: --
1329: IF get_veh_id%FOUND THEN
1330: IF l_new_rec THEN

Line 1343: hr_utility.trace('PROCESS_PRIM_VEH: Creating Vehicle Record for this assignment.');

1339: -- vehicle benefits did not change therefore continue looping
1340: l_prev_veh_id_rec.effective_end_date := l_veh_id_rec.effective_end_date;
1341: ELSE
1342: -- Vehicle Details have changed therefore create reslt dtl record
1343: hr_utility.trace('PROCESS_PRIM_VEH: Creating Vehicle Record for this assignment.');
1344: create_ext_rslt_dtl(p_asg_id, l_asg_start_date, l_asg_end_date,
1345: l_prev_veh_id_rec.effective_start_date,
1346: l_prev_veh_id_rec.effective_end_date,
1347: l_prev_veh_id_rec.primary_car_fuel_benefit,

Line 1359: hr_utility.trace('PROCESS_PRIM_VEH: Creating Last Vehicle Record for this assignment.');

1355: END IF;
1356: ELSE
1357: -- Last record reched, create ext rslt dtl record
1358: IF l_prev_veh_id_rec.primary_company_car IS NOT NULL THEN
1359: hr_utility.trace('PROCESS_PRIM_VEH: Creating Last Vehicle Record for this assignment.');
1360: create_ext_rslt_dtl(p_asg_id, l_asg_start_date, l_asg_end_date,
1361: l_prev_veh_id_rec.effective_start_date,
1362: l_prev_veh_id_rec.effective_end_date,
1363: l_prev_veh_id_rec.primary_car_fuel_benefit,

Line 1371: hr_utility.trace('Leaving PROCESS_PRIM_VEH.');

1367: EXIT;
1368: END IF;
1369: END LOOP;
1370: --
1371: hr_utility.trace('Leaving PROCESS_PRIM_VEH.');
1372: --
1373: END process_prim_veh;
1374:
1375: ---------------------------------------------------------------------------

Line 1404: hr_utility.trace('Entering PROCESS_SEC_VEH, p_asg_id='||p_asg_id);

1400: l_prev_veh_id_rec get_veh_id%ROWTYPE;
1401: --
1402: l_new_rec BOOLEAN := TRUE;
1403: BEGIN
1404: hr_utility.trace('Entering PROCESS_SEC_VEH, p_asg_id='||p_asg_id);
1405: -- Get extract date parameter values
1406: l_ext_start_date := get_param_ext_start_date(get_bus_group_id(p_asg_id));
1407: l_ext_end_date := get_param_ext_end_date(get_bus_group_id(p_asg_id));
1408: -- Get Assignment Start and End Dates

Line 1417: hr_utility.trace('PROCESS_SEC_VEH, After Fetch.');

1413: -- Loop through all vehicle records and create extract result detail
1414: -- record if there is a change in secondary_car_fuel_benefit or vehicle id
1415: LOOP
1416: FETCH get_veh_id INTO l_veh_id_rec;
1417: hr_utility.trace('PROCESS_SEC_VEH, After Fetch.');
1418: hr_utility.trace('PROCESS_SEC_VEH, effective_start_date='||to_char(l_veh_id_rec.effective_start_date, 'DD-MON-YYYY'));
1419: hr_utility.trace('PROCESS_SEC_VEH, effective_end_date='||to_char(l_veh_id_rec.effective_end_date, 'DD-MON-YYYY'));
1420: hr_utility.trace('PROCESS_SEC_VEH, secondary_car_fuel_benefit='||l_veh_id_rec.secondary_car_fuel_benefit);
1421: hr_utility.trace('PROCESS_SEC_VEH, secondary_company_car='||l_veh_id_rec.secondary_company_car);

Line 1418: hr_utility.trace('PROCESS_SEC_VEH, effective_start_date='||to_char(l_veh_id_rec.effective_start_date, 'DD-MON-YYYY'));

1414: -- record if there is a change in secondary_car_fuel_benefit or vehicle id
1415: LOOP
1416: FETCH get_veh_id INTO l_veh_id_rec;
1417: hr_utility.trace('PROCESS_SEC_VEH, After Fetch.');
1418: hr_utility.trace('PROCESS_SEC_VEH, effective_start_date='||to_char(l_veh_id_rec.effective_start_date, 'DD-MON-YYYY'));
1419: hr_utility.trace('PROCESS_SEC_VEH, effective_end_date='||to_char(l_veh_id_rec.effective_end_date, 'DD-MON-YYYY'));
1420: hr_utility.trace('PROCESS_SEC_VEH, secondary_car_fuel_benefit='||l_veh_id_rec.secondary_car_fuel_benefit);
1421: hr_utility.trace('PROCESS_SEC_VEH, secondary_company_car='||l_veh_id_rec.secondary_company_car);
1422: IF l_new_rec THEN

Line 1419: hr_utility.trace('PROCESS_SEC_VEH, effective_end_date='||to_char(l_veh_id_rec.effective_end_date, 'DD-MON-YYYY'));

1415: LOOP
1416: FETCH get_veh_id INTO l_veh_id_rec;
1417: hr_utility.trace('PROCESS_SEC_VEH, After Fetch.');
1418: hr_utility.trace('PROCESS_SEC_VEH, effective_start_date='||to_char(l_veh_id_rec.effective_start_date, 'DD-MON-YYYY'));
1419: hr_utility.trace('PROCESS_SEC_VEH, effective_end_date='||to_char(l_veh_id_rec.effective_end_date, 'DD-MON-YYYY'));
1420: hr_utility.trace('PROCESS_SEC_VEH, secondary_car_fuel_benefit='||l_veh_id_rec.secondary_car_fuel_benefit);
1421: hr_utility.trace('PROCESS_SEC_VEH, secondary_company_car='||l_veh_id_rec.secondary_company_car);
1422: IF l_new_rec THEN
1423: hr_utility.trace('PROCESS_SEC_VEH, l_new_rec=TRUE');

Line 1420: hr_utility.trace('PROCESS_SEC_VEH, secondary_car_fuel_benefit='||l_veh_id_rec.secondary_car_fuel_benefit);

1416: FETCH get_veh_id INTO l_veh_id_rec;
1417: hr_utility.trace('PROCESS_SEC_VEH, After Fetch.');
1418: hr_utility.trace('PROCESS_SEC_VEH, effective_start_date='||to_char(l_veh_id_rec.effective_start_date, 'DD-MON-YYYY'));
1419: hr_utility.trace('PROCESS_SEC_VEH, effective_end_date='||to_char(l_veh_id_rec.effective_end_date, 'DD-MON-YYYY'));
1420: hr_utility.trace('PROCESS_SEC_VEH, secondary_car_fuel_benefit='||l_veh_id_rec.secondary_car_fuel_benefit);
1421: hr_utility.trace('PROCESS_SEC_VEH, secondary_company_car='||l_veh_id_rec.secondary_company_car);
1422: IF l_new_rec THEN
1423: hr_utility.trace('PROCESS_SEC_VEH, l_new_rec=TRUE');
1424: ELSE

Line 1421: hr_utility.trace('PROCESS_SEC_VEH, secondary_company_car='||l_veh_id_rec.secondary_company_car);

1417: hr_utility.trace('PROCESS_SEC_VEH, After Fetch.');
1418: hr_utility.trace('PROCESS_SEC_VEH, effective_start_date='||to_char(l_veh_id_rec.effective_start_date, 'DD-MON-YYYY'));
1419: hr_utility.trace('PROCESS_SEC_VEH, effective_end_date='||to_char(l_veh_id_rec.effective_end_date, 'DD-MON-YYYY'));
1420: hr_utility.trace('PROCESS_SEC_VEH, secondary_car_fuel_benefit='||l_veh_id_rec.secondary_car_fuel_benefit);
1421: hr_utility.trace('PROCESS_SEC_VEH, secondary_company_car='||l_veh_id_rec.secondary_company_car);
1422: IF l_new_rec THEN
1423: hr_utility.trace('PROCESS_SEC_VEH, l_new_rec=TRUE');
1424: ELSE
1425: hr_utility.trace('PROCESS_SEC_VEH, l_new_rec=FALSE');

Line 1423: hr_utility.trace('PROCESS_SEC_VEH, l_new_rec=TRUE');

1419: hr_utility.trace('PROCESS_SEC_VEH, effective_end_date='||to_char(l_veh_id_rec.effective_end_date, 'DD-MON-YYYY'));
1420: hr_utility.trace('PROCESS_SEC_VEH, secondary_car_fuel_benefit='||l_veh_id_rec.secondary_car_fuel_benefit);
1421: hr_utility.trace('PROCESS_SEC_VEH, secondary_company_car='||l_veh_id_rec.secondary_company_car);
1422: IF l_new_rec THEN
1423: hr_utility.trace('PROCESS_SEC_VEH, l_new_rec=TRUE');
1424: ELSE
1425: hr_utility.trace('PROCESS_SEC_VEH, l_new_rec=FALSE');
1426: END IF;
1427: --

Line 1425: hr_utility.trace('PROCESS_SEC_VEH, l_new_rec=FALSE');

1421: hr_utility.trace('PROCESS_SEC_VEH, secondary_company_car='||l_veh_id_rec.secondary_company_car);
1422: IF l_new_rec THEN
1423: hr_utility.trace('PROCESS_SEC_VEH, l_new_rec=TRUE');
1424: ELSE
1425: hr_utility.trace('PROCESS_SEC_VEH, l_new_rec=FALSE');
1426: END IF;
1427: --
1428: IF get_veh_id%FOUND THEN
1429: IF l_new_rec THEN

Line 1468: hr_utility.trace('Leaving PROCESS_SEC_VEH.');

1464: EXIT;
1465: END IF;
1466: END LOOP;
1467: --
1468: hr_utility.trace('Leaving PROCESS_SEC_VEH.');
1469: --
1470: END process_sec_veh;
1471:
1472: ---------------------------------------------------------------------------

Line 1490: hr_utility.trace('Entering PROCESS_SEC_ASG, p_asg_id='||p_asg_id);

1486: --
1487: l_asg_include VARCHAR2(1) := 'N';
1488: --
1489: BEGIN
1490: hr_utility.trace('Entering PROCESS_SEC_ASG, p_asg_id='||p_asg_id);
1491: --
1492: -- Loop through all secondary assignments
1493: FOR sec_asg_rec IN get_sec_asg LOOP
1494: --

Line 1504: hr_utility.trace('Leaving PROCESS_SEC_ASG.');

1500: process_sec_veh(sec_asg_rec.assignment_id);
1501: END IF;
1502: END LOOP;
1503: --
1504: hr_utility.trace('Leaving PROCESS_SEC_ASG.');
1505: END process_sec_asg;
1506:
1507: ---------------------------------------------------------------------------
1508: -- Procedure: PROCESS_TERM_PRIMARY_ASG

Line 1526: hr_utility.trace('Entering PROCESS_TERM_PRIMARY_ASG, p_asg_id='||p_asg_id);

1522: --
1523: l_asg_include VARCHAR2(1) := 'N';
1524: --
1525: BEGIN
1526: hr_utility.trace('Entering PROCESS_TERM_PRIMARY_ASG, p_asg_id='||p_asg_id);
1527: --
1528: -- Loop through all previous primary assignments
1529: FOR term_primary_asg_rec IN get_term_primary_asg LOOP
1530: --

Line 1540: hr_utility.trace('Leaving PROCESS_TERM_PRIMARY_ASG.');

1536: process_sec_veh(term_primary_asg_rec.assignment_id);
1537: END IF;
1538: END LOOP;
1539: --
1540: hr_utility.trace('Leaving PROCESS_TERM_PRIMARY_ASG.');
1541: END process_term_primary_asg;
1542:
1543: ---------------------------------------------------------------------------
1544: -- Function: POST_PROCESS_RULE

Line 1598: hr_utility.trace('Entering POST_PROCESS_RULE, p_ext_rslt_id='||p_ext_rslt_id);

1594: --
1595: l_asg_include VARCHAR2(1);
1596: --
1597: BEGIN
1598: hr_utility.trace('Entering POST_PROCESS_RULE, p_ext_rslt_id='||p_ext_rslt_id);
1599:
1600: g_ext_rslt_id := p_ext_rslt_id;
1601: -- Get assignment details record id
1602: OPEN get_asg_rcd_id;

Line 1606: hr_utility.trace('POST_PROCESS_RULE: l_asg_rcd_id='||l_asg_rcd_id);

1602: OPEN get_asg_rcd_id;
1603: FETCH get_asg_rcd_id INTO l_asg_rcd_id;
1604: CLOSE get_asg_rcd_id;
1605: --
1606: hr_utility.trace('POST_PROCESS_RULE: l_asg_rcd_id='||l_asg_rcd_id);
1607: -- Get Vehicle Details Record Id
1608: OPEN get_veh_rcd_id;
1609: FETCH get_veh_rcd_id INTO g_veh_rcd_id;
1610: CLOSE get_veh_rcd_id;

Line 1612: hr_utility.trace('POST_PROCESS_RULE: g_veh_rcd_id='||g_veh_rcd_id);

1608: OPEN get_veh_rcd_id;
1609: FETCH get_veh_rcd_id INTO g_veh_rcd_id;
1610: CLOSE get_veh_rcd_id;
1611: --
1612: hr_utility.trace('POST_PROCESS_RULE: g_veh_rcd_id='||g_veh_rcd_id);
1613: -- Loop through all people extracted
1614: FOR ext_asg_rec IN get_ext_asg LOOP
1615: g_person_id := ext_asg_rec.person_id;
1616: g_bg_id := get_bus_group_id(ext_asg_rec.asg_id);

Line 1619: hr_utility.trace('POST_PROCESS_RULE: ext_asg_rec.asg_id='||ext_asg_rec.asg_id);

1615: g_person_id := ext_asg_rec.person_id;
1616: g_bg_id := get_bus_group_id(ext_asg_rec.asg_id);
1617: l_prim_veh_dtl := NULL;
1618: --
1619: hr_utility.trace('POST_PROCESS_RULE: ext_asg_rec.asg_id='||ext_asg_rec.asg_id);
1620: hr_utility.trace('POST_PROCESS_RULE: g_person_id='||g_person_id);
1621: -- Delete extract result detail if primary vehicle details id is null
1622: OPEN get_prim_veh_dtl(ext_asg_rec.person_id);
1623: FETCH get_prim_veh_dtl INTO l_prim_veh_dtl;

Line 1620: hr_utility.trace('POST_PROCESS_RULE: g_person_id='||g_person_id);

1616: g_bg_id := get_bus_group_id(ext_asg_rec.asg_id);
1617: l_prim_veh_dtl := NULL;
1618: --
1619: hr_utility.trace('POST_PROCESS_RULE: ext_asg_rec.asg_id='||ext_asg_rec.asg_id);
1620: hr_utility.trace('POST_PROCESS_RULE: g_person_id='||g_person_id);
1621: -- Delete extract result detail if primary vehicle details id is null
1622: OPEN get_prim_veh_dtl(ext_asg_rec.person_id);
1623: FETCH get_prim_veh_dtl INTO l_prim_veh_dtl;
1624: CLOSE get_prim_veh_dtl;

Line 1627: hr_utility.trace('POST_PROCESS_RULE: l_prim_veh_dtl.ext_rslt_dtl_id='||l_prim_veh_dtl.ext_rslt_dtl_id);

1623: FETCH get_prim_veh_dtl INTO l_prim_veh_dtl;
1624: CLOSE get_prim_veh_dtl;
1625: --
1626: l_asg_include := check_asg_inclusion(ext_asg_rec.asg_id);
1627: hr_utility.trace('POST_PROCESS_RULE: l_prim_veh_dtl.ext_rslt_dtl_id='||l_prim_veh_dtl.ext_rslt_dtl_id);
1628: hr_utility.trace('POST_PROCESS_RULE: l_prim_veh_dtl.val_29='||l_prim_veh_dtl.val_29);
1629: IF l_prim_veh_dtl.ext_rslt_dtl_id IS NOT NULL AND l_prim_veh_dtl.val_29 IS NULL THEN
1630: -- Delete this extract rslt details because primary vehicle details
1631: -- do not exist for this assignment as of the start date parameter

Line 1628: hr_utility.trace('POST_PROCESS_RULE: l_prim_veh_dtl.val_29='||l_prim_veh_dtl.val_29);

1624: CLOSE get_prim_veh_dtl;
1625: --
1626: l_asg_include := check_asg_inclusion(ext_asg_rec.asg_id);
1627: hr_utility.trace('POST_PROCESS_RULE: l_prim_veh_dtl.ext_rslt_dtl_id='||l_prim_veh_dtl.ext_rslt_dtl_id);
1628: hr_utility.trace('POST_PROCESS_RULE: l_prim_veh_dtl.val_29='||l_prim_veh_dtl.val_29);
1629: IF l_prim_veh_dtl.ext_rslt_dtl_id IS NOT NULL AND l_prim_veh_dtl.val_29 IS NULL THEN
1630: -- Delete this extract rslt details because primary vehicle details
1631: -- do not exist for this assignment as of the start date parameter
1632: ben_ext_rslt_dtl_api.delete_ext_rslt_dtl(p_ext_rslt_dtl_id => l_prim_veh_dtl.ext_rslt_dtl_id,

Line 1650: hr_utility.trace('POST_PROCESS_RULE: Assignment processed, remove it from the extract details table.');

1646: --
1647: process_term_primary_asg(ext_asg_rec.asg_id);
1648: process_sec_asg(ext_asg_rec.asg_id);
1649: --
1650: hr_utility.trace('POST_PROCESS_RULE: Assignment processed, remove it from the extract details table.');
1651: l_obj_no := ext_asg_rec.object_version_number;
1652: -- Delete this assignment details record
1653: ben_ext_rslt_dtl_api.delete_ext_rslt_dtl(p_ext_rslt_dtl_id => ext_asg_rec.ext_rslt_dtl_id,
1654: p_object_version_number => l_obj_no);

Line 1658: hr_utility.trace('Leaving Post_process_rule.');

1654: p_object_version_number => l_obj_no);
1655: --
1656: END LOOP;
1657: --
1658: hr_utility.trace('Leaving Post_process_rule.');
1659: RETURN 'Y';
1660: --
1661: END post_process_rule;
1662: /* Following code has been added as part of PllD Car Extract 2004 */

Line 1690: hr_utility.trace('Entering get_prim_ben_start_date, p_assignment_id='||p_assignment_id);

1686: AND pvd.vehicle_ownership = 'C'
1687: ORDER BY paaf.effective_start_date ;
1688: --
1689: BEGIN
1690: hr_utility.trace('Entering get_prim_ben_start_date, p_assignment_id='||p_assignment_id);
1691: -- Get extract start date parameter value
1692: l_ext_start_date := get_param_ext_start_date(get_bus_group_id(p_assignment_id));
1693: l_ext_end_date := get_param_ext_end_date(get_bus_group_id(p_assignment_id));
1694: --

Line 1700: hr_utility.trace('Leaving prim_ben_start_date, l_ben_start_date='

1696: OPEN get_eff_start_date;
1697: FETCH get_eff_start_date INTO l_ben_start_date;
1698: CLOSE get_eff_start_date;
1699: --
1700: hr_utility.trace('Leaving prim_ben_start_date, l_ben_start_date='
1701: ||to_char(l_ben_start_date, 'DD-MON-YYYY'));
1702: RETURN to_char(l_ben_start_date, 'DD-MON-YYYY');
1703: --
1704: END prim_ben_start_date;

Line 1734: hr_utility.trace('Entering get_prim_ben_end_date, p_assignment_id='||p_assignment_id);

1730: AND pvd.vehicle_ownership = 'C'
1731: ORDER BY paaf.effective_end_date desc;
1732: --
1733: BEGIN
1734: hr_utility.trace('Entering get_prim_ben_end_date, p_assignment_id='||p_assignment_id);
1735: --
1736: l_ben_start_date := fnd_date.displaydate_to_date(prim_ben_start_date(p_assignment_id));
1737: l_ext_start_date := get_param_ext_start_date(get_bus_group_id(p_assignment_id));
1738: l_ext_end_date := get_param_ext_end_date(get_bus_group_id(p_assignment_id));

Line 1745: hr_utility.trace('Leaving prim_ben_end_date, l_ben_end_date='

1741: OPEN get_ben_details;
1742: FETCH get_ben_details INTO l_ben_end_date ;
1743: CLOSE get_ben_details;
1744: --
1745: hr_utility.trace('Leaving prim_ben_end_date, l_ben_end_date='
1746: ||to_char(l_ben_end_date, 'DD-MON-YYYY'));
1747: -- RETURN to_char(l_ext_end_date, 'DD-MON-YYYY');
1748: RETURN to_char(least(l_ben_end_date, l_ext_end_date), 'DD-MON-YYYY');
1749: --

Line 1779: hr_utility.trace('Entering GET_PRIM_VIN, p_assignment_id='||p_assignment_id);

1775: AND pvd.effective_end_date >= l_ext_start_date
1776: ORDER BY pvd.effective_end_date desc;
1777: --
1778: BEGIN
1779: hr_utility.trace('Entering GET_PRIM_VIN, p_assignment_id='||p_assignment_id);
1780: --
1781: l_ben_start_date := fnd_date.displaydate_to_date(prim_ben_start_date(p_assignment_id));
1782: l_ext_start_date := get_param_ext_start_date(get_bus_group_id(p_assignment_id));
1783: l_ext_end_date := get_param_ext_end_date(get_bus_group_id(p_assignment_id));

Line 1790: hr_utility.trace('Leaving PRIM_VIN, l_vin='||l_vin);

1786: OPEN get_vin;
1787: FETCH get_vin INTO l_vin;
1788: CLOSE get_vin;
1789: --
1790: hr_utility.trace('Leaving PRIM_VIN, l_vin='||l_vin);
1791: RETURN l_vin;
1792: --
1793: END prim_vin;
1794:

Line 1822: hr_utility.trace('Entering PRIM_MAKE, p_assignment_id='||p_assignment_id);

1818: AND pvd.effective_end_date >= l_ext_start_date
1819: ORDER BY pvd.effective_end_date desc;
1820: --
1821: BEGIN
1822: hr_utility.trace('Entering PRIM_MAKE, p_assignment_id='||p_assignment_id);
1823: --
1824: l_ben_start_date := fnd_date.displaydate_to_date(prim_ben_start_date(p_assignment_id));
1825: l_ext_start_date := get_param_ext_start_date(get_bus_group_id(p_assignment_id));
1826: l_ext_end_date := get_param_ext_end_date(get_bus_group_id(p_assignment_id));

Line 1833: hr_utility.trace('Leaving PRIM_MAKE, l_make='||l_make);

1829: OPEN get_make;
1830: FETCH get_make INTO l_make;
1831: CLOSE get_make;
1832: --
1833: hr_utility.trace('Leaving PRIM_MAKE, l_make='||l_make);
1834: RETURN l_make;
1835: --
1836: END prim_make;
1837:

Line 1864: hr_utility.trace('Entering PRIM_MODEL, p_assignment_id='||p_assignment_id);

1860: AND pvd.effective_end_date >= l_ext_start_date
1861: ORDER BY pvd.effective_end_date desc;
1862: --
1863: BEGIN
1864: hr_utility.trace('Entering PRIM_MODEL, p_assignment_id='||p_assignment_id);
1865: --
1866: l_ben_start_date := fnd_date.displaydate_to_date(prim_ben_start_date(p_assignment_id));
1867: l_ext_start_date := get_param_ext_start_date(get_bus_group_id(p_assignment_id));
1868: l_ext_end_date := get_param_ext_end_date(get_bus_group_id(p_assignment_id));

Line 1875: hr_utility.trace('Leaving PRIM_MODEL, l_model='||l_model);

1871: OPEN get_model;
1872: FETCH get_model INTO l_model;
1873: CLOSE get_model;
1874: --
1875: hr_utility.trace('Leaving PRIM_MODEL, l_model='||l_model);
1876: RETURN l_model;
1877: --
1878: END prim_model;
1879:

Line 1906: hr_utility.trace('Entering PRIM_DFR, p_assignment_id='||p_assignment_id);

1902: AND pvd.effective_end_date >= l_ext_start_date
1903: ORDER BY pvd.effective_end_date desc;
1904: --
1905: BEGIN
1906: hr_utility.trace('Entering PRIM_DFR, p_assignment_id='||p_assignment_id);
1907: --
1908: l_ben_start_date := fnd_date.displaydate_to_date(prim_ben_start_date(p_assignment_id));
1909: l_ext_start_date := get_param_ext_start_date(get_bus_group_id(p_assignment_id));
1910: l_ext_end_date := get_param_ext_end_date(get_bus_group_id(p_assignment_id));

Line 1917: hr_utility.trace('Leaving PRIM_DFR, l_dfr='||to_char(l_dfr, 'DD-MON-YYYY'));

1913: OPEN get_dfr;
1914: FETCH get_dfr INTO l_dfr;
1915: CLOSE get_dfr;
1916: --
1917: hr_utility.trace('Leaving PRIM_DFR, l_dfr='||to_char(l_dfr, 'DD-MON-YYYY'));
1918: RETURN to_char(l_dfr, 'DD-MON-YYYY');
1919: --
1920: END prim_dfr;
1921:

Line 1948: hr_utility.trace('Entering PRIM_PRICE, p_assignment_id='||p_assignment_id);

1944: AND pvd.effective_end_date >= l_ext_start_date
1945: ORDER BY pvd.effective_end_date desc;
1946: --
1947: BEGIN
1948: hr_utility.trace('Entering PRIM_PRICE, p_assignment_id='||p_assignment_id);
1949: --
1950: l_ben_start_date := fnd_date.displaydate_to_date(prim_ben_start_date(p_assignment_id));
1951: l_ext_start_date := get_param_ext_start_date(get_bus_group_id(p_assignment_id));
1952: l_ext_end_date := get_param_ext_end_date(get_bus_group_id(p_assignment_id));

Line 1959: hr_utility.trace('Leaving PRIM_PRICE, l_price='||to_char(l_price));

1955: OPEN get_price;
1956: FETCH get_price INTO l_price;
1957: CLOSE get_price;
1958: --
1959: hr_utility.trace('Leaving PRIM_PRICE, l_price='||to_char(l_price));
1960: RETURN to_char(l_price);
1961: --
1962: END prim_price;
1963:

Line 2006: hr_utility.trace('Entering PRIM_FUEL_TYPE, p_assignment_id='||p_assignment_id);

2002: AND enabled_flag = 'Y'
2003: AND description = l_fuel_type
2004: ORDER BY lookup_code;
2005: BEGIN
2006: hr_utility.trace('Entering PRIM_FUEL_TYPE, p_assignment_id='||p_assignment_id);
2007: --
2008: l_ben_start_date := fnd_date.displaydate_to_date(prim_ben_start_date(p_assignment_id));
2009: l_ext_start_date := get_param_ext_start_date(get_bus_group_id(p_assignment_id));
2010: l_ext_end_date := get_param_ext_end_date(get_bus_group_id(p_assignment_id));

Line 2017: hr_utility.trace('PRIM_FUEL_TYPE: l_fuel_type='||l_fuel_type);

2013: OPEN get_fuel_type;
2014: FETCH get_fuel_type INTO l_fuel_type;
2015: CLOSE get_fuel_type;
2016: --
2017: hr_utility.trace('PRIM_FUEL_TYPE: l_fuel_type='||l_fuel_type);
2018: --
2019: -- Get Translated Meaning
2020: OPEN get_translation;
2021: FETCH get_translation INTO l_fuel_meaning;

Line 2023: hr_utility.trace('Leaving PRIM_FUEL_TYPE, l_fuel_meaning='||l_fuel_meaning);

2019: -- Get Translated Meaning
2020: OPEN get_translation;
2021: FETCH get_translation INTO l_fuel_meaning;
2022: CLOSE get_translation;
2023: hr_utility.trace('Leaving PRIM_FUEL_TYPE, l_fuel_meaning='||l_fuel_meaning);
2024: RETURN l_fuel_meaning;
2025: --
2026: END prim_fuel_type;
2027:

Line 2054: hr_utility.trace('Entering PRIM_CO2_EMI, p_assignment_id='||p_assignment_id);

2050: AND pvd.effective_end_date >= l_ext_start_date
2051: ORDER BY pvd.effective_end_date desc;
2052: --
2053: BEGIN
2054: hr_utility.trace('Entering PRIM_CO2_EMI, p_assignment_id='||p_assignment_id);
2055: --
2056: l_ben_start_date := fnd_date.displaydate_to_date(prim_ben_start_date(p_assignment_id));
2057: l_ext_start_date := get_param_ext_start_date(get_bus_group_id(p_assignment_id));
2058: l_ext_end_date := get_param_ext_end_date(get_bus_group_id(p_assignment_id));

Line 2065: hr_utility.trace('Leaving PRIM_CO2_EMI, l_co2_emi='||to_char(l_co2_emi));

2061: OPEN get_co2_emi;
2062: FETCH get_co2_emi INTO l_co2_emi;
2063: CLOSE get_co2_emi;
2064: --
2065: hr_utility.trace('Leaving PRIM_CO2_EMI, l_co2_emi='||to_char(l_co2_emi));
2066: RETURN to_char(l_co2_emi);
2067: --
2068: END prim_co2_emi;
2069:

Line 2100: hr_utility.trace('Entering PRIM_OPTIONAL_ACC, p_assignment_id='||p_assignment_id);

2096: AND pvd.effective_end_date >= l_ext_start_date
2097: ORDER BY pvd.effective_end_date desc;
2098: --
2099: BEGIN
2100: hr_utility.trace('Entering PRIM_OPTIONAL_ACC, p_assignment_id='||p_assignment_id);
2101: --
2102: l_ben_start_date := fnd_date.displaydate_to_date(prim_ben_start_date(p_assignment_id));
2103: l_ext_start_date := get_param_ext_start_date(get_bus_group_id(p_assignment_id));
2104: l_ext_end_date := get_param_ext_end_date(get_bus_group_id(p_assignment_id));

Line 2111: hr_utility.trace('Leaving PRIM_OPTIONAL_ACC, l_opt_acc='||to_char(l_opt_acc));

2107: OPEN get_opt_acc;
2108: FETCH get_opt_acc INTO l_opt_acc;
2109: CLOSE get_opt_acc;
2110: --
2111: hr_utility.trace('Leaving PRIM_OPTIONAL_ACC, l_opt_acc='||to_char(l_opt_acc));
2112: RETURN to_char(l_opt_acc);
2113: --
2114: END prim_optional_acc;
2115:

Line 2142: hr_utility.trace('Entering PRIM_CAPITAL_CONTRIB, p_assignment_id='||p_assignment_id);

2138: AND paaf.effective_end_date >= l_ext_start_date
2139: order by paaf.effective_end_date desc;
2140: --
2141: BEGIN
2142: hr_utility.trace('Entering PRIM_CAPITAL_CONTRIB, p_assignment_id='||p_assignment_id);
2143: --
2144: l_ben_start_date := fnd_date.displaydate_to_date(prim_ben_start_date(p_assignment_id));
2145: l_ext_start_date := get_param_ext_start_date(get_bus_group_id(p_assignment_id));
2146: l_ext_end_date := get_param_ext_end_date(get_bus_group_id(p_assignment_id));

Line 2153: hr_utility.trace('Leaving PRIM_CAPITAL_CONTRIB, l_cap_contrib='||to_char(l_cap_contrib));

2149: OPEN get_cap_contrib;
2150: FETCH get_cap_contrib INTO l_cap_contrib;
2151: CLOSE get_cap_contrib;
2152: --
2153: hr_utility.trace('Leaving PRIM_CAPITAL_CONTRIB, l_cap_contrib='||to_char(l_cap_contrib));
2154: RETURN to_char(l_cap_contrib);
2155: --
2156: END prim_capital_contrib;
2157:

Line 2185: hr_utility.trace('Entering PRIM_PRIVATE_CONTRIB, p_assignment_id='||p_assignment_id);

2181: AND paaf.effective_end_date >= l_ext_start_date
2182: ORDER BY paaf.effective_end_date desc;
2183: --
2184: BEGIN
2185: hr_utility.trace('Entering PRIM_PRIVATE_CONTRIB, p_assignment_id='||p_assignment_id);
2186: --
2187: l_ben_start_date := fnd_date.displaydate_to_date(prim_ben_start_date(p_assignment_id));
2188: l_ext_start_date := get_param_ext_start_date(get_bus_group_id(p_assignment_id));
2189: l_ext_end_date := get_param_ext_end_date(get_bus_group_id(p_assignment_id));

Line 2196: hr_utility.trace('Leaving PRIM_PRIVATE_CONTRIB, l_pri_contrib='||to_char(l_pri_contrib));

2192: OPEN get_pri_contrib;
2193: FETCH get_pri_contrib INTO l_pri_contrib;
2194: CLOSE get_pri_contrib;
2195: --
2196: hr_utility.trace('Leaving PRIM_PRIVATE_CONTRIB, l_pri_contrib='||to_char(l_pri_contrib));
2197: RETURN to_char(l_pri_contrib);
2198: --
2199: END prim_private_contrib;
2200:

Line 2227: hr_utility.trace('Entering PRIM_ENGINE_CAPACITY, p_assignment_id='||p_assignment_id);

2223: AND pvd.effective_end_date >= l_ext_start_date
2224: ORDER BY pvd.effective_end_date desc;
2225: --
2226: BEGIN
2227: hr_utility.trace('Entering PRIM_ENGINE_CAPACITY, p_assignment_id='||p_assignment_id);
2228: --
2229: l_ben_start_date := fnd_date.displaydate_to_date(prim_ben_start_date(p_assignment_id));
2230: l_ext_start_date := get_param_ext_start_date(get_bus_group_id(p_assignment_id));
2231: l_ext_end_date := get_param_ext_end_date(get_bus_group_id(p_assignment_id));

Line 2238: hr_utility.trace('Leaving PRIM_ENGINE_CAPACITY, l_engine_cap='||to_char(l_engine_cap));

2234: OPEN get_engine_cap;
2235: FETCH get_engine_cap INTO l_engine_cap;
2236: CLOSE get_engine_cap;
2237: --
2238: hr_utility.trace('Leaving PRIM_ENGINE_CAPACITY, l_engine_cap='||to_char(l_engine_cap));
2239: RETURN to_char(l_engine_cap);
2240: --
2241: END prim_engine_capacity;
2242:

Line 2269: hr_utility.trace('Entering PRIM_FUEL_BENEFIT, p_assignment_id='||p_assignment_id);

2265: AND paaf.effective_end_date >= l_ext_start_date
2266: ORDER BY paaf.effective_end_date desc;
2267: --
2268: BEGIN
2269: hr_utility.trace('Entering PRIM_FUEL_BENEFIT, p_assignment_id='||p_assignment_id);
2270: --
2271: l_ben_start_date := fnd_date.displaydate_to_date(prim_ben_start_date(p_assignment_id));
2272: l_ext_start_date := get_param_ext_start_date(get_bus_group_id(p_assignment_id));
2273: l_ext_end_date := get_param_ext_end_date(get_bus_group_id(p_assignment_id));

Line 2280: hr_utility.trace('Leaving PRIM_FUEL_BENEFIT, l_fuel_benefit='||l_fuel_benefit);

2276: OPEN get_fuel_benefit;
2277: FETCH get_fuel_benefit INTO l_fuel_benefit;
2278: CLOSE get_fuel_benefit;
2279: --
2280: hr_utility.trace('Leaving PRIM_FUEL_BENEFIT, l_fuel_benefit='||l_fuel_benefit);
2281: RETURN l_fuel_benefit;
2282: --
2283: END prim_fuel_benefit;
2284: ---------------------------------------------------------------------------

Line 2310: hr_utility.trace('Entering PRIM_FUEL_REINSTATED, p_assignment_id='||p_assignment_id);

2306: AND paaf.effective_end_date >= l_ext_start_date
2307: ORDER BY paaf.effective_end_date desc;
2308: --
2309: BEGIN
2310: hr_utility.trace('Entering PRIM_FUEL_REINSTATED, p_assignment_id='||p_assignment_id);
2311: --
2312: l_ext_start_date := get_param_ext_start_date(get_bus_group_id(p_assignment_id));
2313: l_ext_end_date := get_param_ext_end_date(get_bus_group_id(p_assignment_id));
2314: l_ben_start_date := fnd_date.displaydate_to_date(prim_ben_start_date(p_assignment_id));

Line 2330: hr_utility.trace('Leaving PRIM_FUEL_REINSTATED, l_fuel='||l_fuel);

2326: EXIT WHEN (l_date_free.fuel_benefit = 'N');
2327: l_fuel := null;
2328: end loop;
2329: END IF;
2330: hr_utility.trace('Leaving PRIM_FUEL_REINSTATED, l_fuel='||l_fuel);
2331: RETURN l_fuel;
2332: --
2333: END prim_fuel_reinstated;
2334: --

Line 2362: hr_utility.trace('Entering PRIM_FREE_FUEL_WITHDRAWN, p_assignment_id='||p_assignment_id);

2358: AND paaf.effective_end_date >= l_ext_start_date
2359: ORDER BY paaf.effective_end_date desc;
2360: --
2361: BEGIN
2362: hr_utility.trace('Entering PRIM_FREE_FUEL_WITHDRAWN, p_assignment_id='||p_assignment_id);
2363: --
2364: l_ben_start_date := fnd_date.displaydate_to_date(prim_ben_start_date(p_assignment_id));
2365: l_ext_start_date := get_param_ext_start_date(get_bus_group_id(p_assignment_id));
2366: l_ext_end_date := get_param_ext_end_date(get_bus_group_id(p_assignment_id));

Line 2384: hr_utility.trace('Leaving PRIM_DATE_FREE_FUEL_WITHDRAWN, l_start_date='||l_start_date);

2380: EXIT WHEN (l_date_free.fuel_benefit = 'Y');
2381: l_start_date := null;
2382: end loop;
2383: END IF;
2384: hr_utility.trace('Leaving PRIM_DATE_FREE_FUEL_WITHDRAWN, l_start_date='||l_start_date);
2385: RETURN to_char(l_start_date, 'DD-MON-YYYY');
2386: --
2387: END prim_free_fuel_withdrawn;
2388: ---------------------------------------------------------------------------

Line 2417: hr_utility.trace('Entering PRIM_ADDITIONAL_FUEL_DAYS , p_assignment_id='||p_assignment_id);

2413: AND paaf.effective_start_date <= l_ext_end_date
2414: order by paaf.effective_start_date desc ;
2415:
2416: BEGIN
2417: hr_utility.trace('Entering PRIM_ADDITIONAL_FUEL_DAYS , p_assignment_id='||p_assignment_id);
2418: --
2419: l_ben_start_date := fnd_date.displaydate_to_date(prim_ben_start_date(p_assignment_id));
2420: --
2421: l_ext_start_date := get_param_ext_start_date(get_bus_group_id(p_assignment_id));

Line 2440: hr_utility.trace('Leaving PRIM_ADDITIONAL_FUEL_DAYS, l_days='||l_days);

2436: else
2437: l_days := trunc(l_ext_end_date - l_start_date);
2438: end if;
2439: END IF;
2440: hr_utility.trace('Leaving PRIM_ADDITIONAL_FUEL_DAYS, l_days='||l_days);
2441: RETURN to_char(l_days);
2442: --
2443: END prim_additional_fuel_days;
2444: --

Line 2473: hr_utility.trace('Entering PRIM_FUEL_REINSTATED, p_assignment_id='||p_assignment_id);

2469: AND paaf.vehicle_allocation_id = p_vehicle_allocation_id
2470: ORDER BY paaf.effective_end_date desc;
2471: --
2472: BEGIN
2473: hr_utility.trace('Entering PRIM_FUEL_REINSTATED, p_assignment_id='||p_assignment_id);
2474: --
2475: l_ext_start_date := get_param_ext_start_date(get_bus_group_id(p_assignment_id));
2476: l_ext_end_date := get_param_ext_end_date(get_bus_group_id(p_assignment_id));
2477: l_ben_start_date := fnd_date.displaydate_to_date(prim_ben_start_date(p_assignment_id));

Line 2493: hr_utility.trace('Leaving PRIM_FUEL_REINSTATED, l_fuel='||l_fuel);

2489: EXIT WHEN (l_date_free.fuel_benefit = 'N');
2490: l_fuel := null;
2491: end loop;
2492: END IF;
2493: hr_utility.trace('Leaving PRIM_FUEL_REINSTATED, l_fuel='||l_fuel);
2494: RETURN l_fuel;
2495: --
2496: END prim_fuel_reinstated;
2497: --

Line 2527: hr_utility.trace('Entering PRIM_FREE_FUEL_WITHDRAWN, p_assignment_id='||p_assignment_id);

2523: AND paaf.vehicle_allocation_id = p_vehicle_allocation_id
2524: ORDER BY paaf.effective_end_date desc;
2525: --
2526: BEGIN
2527: hr_utility.trace('Entering PRIM_FREE_FUEL_WITHDRAWN, p_assignment_id='||p_assignment_id);
2528: --
2529: l_ben_start_date := fnd_date.displaydate_to_date(prim_ben_start_date(p_assignment_id));
2530: l_ext_start_date := get_param_ext_start_date(get_bus_group_id(p_assignment_id));
2531: l_ext_end_date := get_param_ext_end_date(get_bus_group_id(p_assignment_id));

Line 2549: hr_utility.trace('Leaving PRIM_DATE_FREE_FUEL_WITHDRAWN, l_start_date='||l_start_date);

2545: EXIT WHEN (l_date_free.fuel_benefit = 'Y');
2546: l_start_date := null;
2547: end loop;
2548: END IF;
2549: hr_utility.trace('Leaving PRIM_DATE_FREE_FUEL_WITHDRAWN, l_start_date='||l_start_date);
2550: RETURN to_char(l_start_date, 'DD-MON-YYYY');
2551: --
2552: END prim_free_fuel_withdrawn;
2553: ---------------------------------------------------------------------------

Line 2584: hr_utility.trace('Entering PRIM_ADDITIONAL_FUEL_DAYS , p_assignment_id='||p_assignment_id);

2580: AND paaf.vehicle_allocation_id = p_vehicle_allocation_id
2581: order by paaf.effective_start_date desc ;
2582:
2583: BEGIN
2584: hr_utility.trace('Entering PRIM_ADDITIONAL_FUEL_DAYS , p_assignment_id='||p_assignment_id);
2585: --
2586: l_ben_start_date := fnd_date.displaydate_to_date(prim_ben_start_date(p_assignment_id));
2587: --
2588: l_ext_start_date := get_param_ext_start_date(get_bus_group_id(p_assignment_id));

Line 2607: hr_utility.trace('Leaving PRIM_ADDITIONAL_FUEL_DAYS, l_days='||l_days);

2603: else
2604: l_days := trunc(l_ext_end_date - l_start_date) + 1;
2605: end if;
2606: END IF;
2607: hr_utility.trace('Leaving PRIM_ADDITIONAL_FUEL_DAYS, l_days='||l_days);
2608: RETURN to_char(l_days);
2609: --
2610: END prim_additional_fuel_days;
2611: --

Line 2696: hr_utility.trace('Entering CREATE_EXT_RSLT_DTL_04: p_asg_id='|| p_asg_id);

2692: --
2693: l_chk_exists chk_exists%ROWTYPE;
2694: l_fuel_benefit VARCHAR2(1);
2695: BEGIN
2696: hr_utility.trace('Entering CREATE_EXT_RSLT_DTL_04: p_asg_id='|| p_asg_id);
2697: hr_utility.trace('CREATE_EXT_RSLT_DTL_04: p_asg_start_date='||to_char(p_asg_start_date, 'DD-MON-YYYY'));
2698: hr_utility.trace('CREATE_EXT_RSLT_DTL_04: p_asg_end_date='||to_char(p_asg_end_date, 'DD-MON-YYYY'));
2699: hr_utility.trace('CREATE_EXT_RSLT_DTL_04: p_benefit_start_date='||to_char(p_benefit_start_date, 'DD-MON-YYYY'));
2700: hr_utility.trace('CREATE_EXT_RSLT_DTL_04: p_benefit_end_date='||to_char(p_benefit_end_date, 'DD-MON-YYYY'));

Line 2697: hr_utility.trace('CREATE_EXT_RSLT_DTL_04: p_asg_start_date='||to_char(p_asg_start_date, 'DD-MON-YYYY'));

2693: l_chk_exists chk_exists%ROWTYPE;
2694: l_fuel_benefit VARCHAR2(1);
2695: BEGIN
2696: hr_utility.trace('Entering CREATE_EXT_RSLT_DTL_04: p_asg_id='|| p_asg_id);
2697: hr_utility.trace('CREATE_EXT_RSLT_DTL_04: p_asg_start_date='||to_char(p_asg_start_date, 'DD-MON-YYYY'));
2698: hr_utility.trace('CREATE_EXT_RSLT_DTL_04: p_asg_end_date='||to_char(p_asg_end_date, 'DD-MON-YYYY'));
2699: hr_utility.trace('CREATE_EXT_RSLT_DTL_04: p_benefit_start_date='||to_char(p_benefit_start_date, 'DD-MON-YYYY'));
2700: hr_utility.trace('CREATE_EXT_RSLT_DTL_04: p_benefit_end_date='||to_char(p_benefit_end_date, 'DD-MON-YYYY'));
2701: hr_utility.trace('CREATE_EXT_RSLT_DTL_04: p_car_fuel_benefit='||p_car_fuel_benefit);

Line 2698: hr_utility.trace('CREATE_EXT_RSLT_DTL_04: p_asg_end_date='||to_char(p_asg_end_date, 'DD-MON-YYYY'));

2694: l_fuel_benefit VARCHAR2(1);
2695: BEGIN
2696: hr_utility.trace('Entering CREATE_EXT_RSLT_DTL_04: p_asg_id='|| p_asg_id);
2697: hr_utility.trace('CREATE_EXT_RSLT_DTL_04: p_asg_start_date='||to_char(p_asg_start_date, 'DD-MON-YYYY'));
2698: hr_utility.trace('CREATE_EXT_RSLT_DTL_04: p_asg_end_date='||to_char(p_asg_end_date, 'DD-MON-YYYY'));
2699: hr_utility.trace('CREATE_EXT_RSLT_DTL_04: p_benefit_start_date='||to_char(p_benefit_start_date, 'DD-MON-YYYY'));
2700: hr_utility.trace('CREATE_EXT_RSLT_DTL_04: p_benefit_end_date='||to_char(p_benefit_end_date, 'DD-MON-YYYY'));
2701: hr_utility.trace('CREATE_EXT_RSLT_DTL_04: p_car_fuel_benefit='||p_car_fuel_benefit);
2702: hr_utility.trace('CREATE_EXT_RSLT_DTL_04: p_vehicle_repository_id='||p_vehicle_repository_id);

Line 2699: hr_utility.trace('CREATE_EXT_RSLT_DTL_04: p_benefit_start_date='||to_char(p_benefit_start_date, 'DD-MON-YYYY'));

2695: BEGIN
2696: hr_utility.trace('Entering CREATE_EXT_RSLT_DTL_04: p_asg_id='|| p_asg_id);
2697: hr_utility.trace('CREATE_EXT_RSLT_DTL_04: p_asg_start_date='||to_char(p_asg_start_date, 'DD-MON-YYYY'));
2698: hr_utility.trace('CREATE_EXT_RSLT_DTL_04: p_asg_end_date='||to_char(p_asg_end_date, 'DD-MON-YYYY'));
2699: hr_utility.trace('CREATE_EXT_RSLT_DTL_04: p_benefit_start_date='||to_char(p_benefit_start_date, 'DD-MON-YYYY'));
2700: hr_utility.trace('CREATE_EXT_RSLT_DTL_04: p_benefit_end_date='||to_char(p_benefit_end_date, 'DD-MON-YYYY'));
2701: hr_utility.trace('CREATE_EXT_RSLT_DTL_04: p_car_fuel_benefit='||p_car_fuel_benefit);
2702: hr_utility.trace('CREATE_EXT_RSLT_DTL_04: p_vehicle_repository_id='||p_vehicle_repository_id);
2703: hr_utility.trace('CREATE_EXT_RSLT_DTL_04: g_ext_rslt_id='||g_ext_rslt_id);

Line 2700: hr_utility.trace('CREATE_EXT_RSLT_DTL_04: p_benefit_end_date='||to_char(p_benefit_end_date, 'DD-MON-YYYY'));

2696: hr_utility.trace('Entering CREATE_EXT_RSLT_DTL_04: p_asg_id='|| p_asg_id);
2697: hr_utility.trace('CREATE_EXT_RSLT_DTL_04: p_asg_start_date='||to_char(p_asg_start_date, 'DD-MON-YYYY'));
2698: hr_utility.trace('CREATE_EXT_RSLT_DTL_04: p_asg_end_date='||to_char(p_asg_end_date, 'DD-MON-YYYY'));
2699: hr_utility.trace('CREATE_EXT_RSLT_DTL_04: p_benefit_start_date='||to_char(p_benefit_start_date, 'DD-MON-YYYY'));
2700: hr_utility.trace('CREATE_EXT_RSLT_DTL_04: p_benefit_end_date='||to_char(p_benefit_end_date, 'DD-MON-YYYY'));
2701: hr_utility.trace('CREATE_EXT_RSLT_DTL_04: p_car_fuel_benefit='||p_car_fuel_benefit);
2702: hr_utility.trace('CREATE_EXT_RSLT_DTL_04: p_vehicle_repository_id='||p_vehicle_repository_id);
2703: hr_utility.trace('CREATE_EXT_RSLT_DTL_04: g_ext_rslt_id='||g_ext_rslt_id);
2704: hr_utility.trace('CREATE_EXT_RSLT_DTL_04: g_person_id='||g_person_id);

Line 2701: hr_utility.trace('CREATE_EXT_RSLT_DTL_04: p_car_fuel_benefit='||p_car_fuel_benefit);

2697: hr_utility.trace('CREATE_EXT_RSLT_DTL_04: p_asg_start_date='||to_char(p_asg_start_date, 'DD-MON-YYYY'));
2698: hr_utility.trace('CREATE_EXT_RSLT_DTL_04: p_asg_end_date='||to_char(p_asg_end_date, 'DD-MON-YYYY'));
2699: hr_utility.trace('CREATE_EXT_RSLT_DTL_04: p_benefit_start_date='||to_char(p_benefit_start_date, 'DD-MON-YYYY'));
2700: hr_utility.trace('CREATE_EXT_RSLT_DTL_04: p_benefit_end_date='||to_char(p_benefit_end_date, 'DD-MON-YYYY'));
2701: hr_utility.trace('CREATE_EXT_RSLT_DTL_04: p_car_fuel_benefit='||p_car_fuel_benefit);
2702: hr_utility.trace('CREATE_EXT_RSLT_DTL_04: p_vehicle_repository_id='||p_vehicle_repository_id);
2703: hr_utility.trace('CREATE_EXT_RSLT_DTL_04: g_ext_rslt_id='||g_ext_rslt_id);
2704: hr_utility.trace('CREATE_EXT_RSLT_DTL_04: g_person_id='||g_person_id);
2705: hr_utility.trace('CREATE_EXT_RSLT_DTL_04: g_veh_rcd_id='||g_veh_rcd_id);

Line 2702: hr_utility.trace('CREATE_EXT_RSLT_DTL_04: p_vehicle_repository_id='||p_vehicle_repository_id);

2698: hr_utility.trace('CREATE_EXT_RSLT_DTL_04: p_asg_end_date='||to_char(p_asg_end_date, 'DD-MON-YYYY'));
2699: hr_utility.trace('CREATE_EXT_RSLT_DTL_04: p_benefit_start_date='||to_char(p_benefit_start_date, 'DD-MON-YYYY'));
2700: hr_utility.trace('CREATE_EXT_RSLT_DTL_04: p_benefit_end_date='||to_char(p_benefit_end_date, 'DD-MON-YYYY'));
2701: hr_utility.trace('CREATE_EXT_RSLT_DTL_04: p_car_fuel_benefit='||p_car_fuel_benefit);
2702: hr_utility.trace('CREATE_EXT_RSLT_DTL_04: p_vehicle_repository_id='||p_vehicle_repository_id);
2703: hr_utility.trace('CREATE_EXT_RSLT_DTL_04: g_ext_rslt_id='||g_ext_rslt_id);
2704: hr_utility.trace('CREATE_EXT_RSLT_DTL_04: g_person_id='||g_person_id);
2705: hr_utility.trace('CREATE_EXT_RSLT_DTL_04: g_veh_rcd_id='||g_veh_rcd_id);
2706: --

Line 2703: hr_utility.trace('CREATE_EXT_RSLT_DTL_04: g_ext_rslt_id='||g_ext_rslt_id);

2699: hr_utility.trace('CREATE_EXT_RSLT_DTL_04: p_benefit_start_date='||to_char(p_benefit_start_date, 'DD-MON-YYYY'));
2700: hr_utility.trace('CREATE_EXT_RSLT_DTL_04: p_benefit_end_date='||to_char(p_benefit_end_date, 'DD-MON-YYYY'));
2701: hr_utility.trace('CREATE_EXT_RSLT_DTL_04: p_car_fuel_benefit='||p_car_fuel_benefit);
2702: hr_utility.trace('CREATE_EXT_RSLT_DTL_04: p_vehicle_repository_id='||p_vehicle_repository_id);
2703: hr_utility.trace('CREATE_EXT_RSLT_DTL_04: g_ext_rslt_id='||g_ext_rslt_id);
2704: hr_utility.trace('CREATE_EXT_RSLT_DTL_04: g_person_id='||g_person_id);
2705: hr_utility.trace('CREATE_EXT_RSLT_DTL_04: g_veh_rcd_id='||g_veh_rcd_id);
2706: --
2707: l_ext_start_date := get_param_ext_start_date(get_bus_group_id(p_asg_id));

Line 2704: hr_utility.trace('CREATE_EXT_RSLT_DTL_04: g_person_id='||g_person_id);

2700: hr_utility.trace('CREATE_EXT_RSLT_DTL_04: p_benefit_end_date='||to_char(p_benefit_end_date, 'DD-MON-YYYY'));
2701: hr_utility.trace('CREATE_EXT_RSLT_DTL_04: p_car_fuel_benefit='||p_car_fuel_benefit);
2702: hr_utility.trace('CREATE_EXT_RSLT_DTL_04: p_vehicle_repository_id='||p_vehicle_repository_id);
2703: hr_utility.trace('CREATE_EXT_RSLT_DTL_04: g_ext_rslt_id='||g_ext_rslt_id);
2704: hr_utility.trace('CREATE_EXT_RSLT_DTL_04: g_person_id='||g_person_id);
2705: hr_utility.trace('CREATE_EXT_RSLT_DTL_04: g_veh_rcd_id='||g_veh_rcd_id);
2706: --
2707: l_ext_start_date := get_param_ext_start_date(get_bus_group_id(p_asg_id));
2708: l_ext_end_date := get_param_ext_end_date(get_bus_group_id(p_asg_id));

Line 2705: hr_utility.trace('CREATE_EXT_RSLT_DTL_04: g_veh_rcd_id='||g_veh_rcd_id);

2701: hr_utility.trace('CREATE_EXT_RSLT_DTL_04: p_car_fuel_benefit='||p_car_fuel_benefit);
2702: hr_utility.trace('CREATE_EXT_RSLT_DTL_04: p_vehicle_repository_id='||p_vehicle_repository_id);
2703: hr_utility.trace('CREATE_EXT_RSLT_DTL_04: g_ext_rslt_id='||g_ext_rslt_id);
2704: hr_utility.trace('CREATE_EXT_RSLT_DTL_04: g_person_id='||g_person_id);
2705: hr_utility.trace('CREATE_EXT_RSLT_DTL_04: g_veh_rcd_id='||g_veh_rcd_id);
2706: --
2707: l_ext_start_date := get_param_ext_start_date(get_bus_group_id(p_asg_id));
2708: l_ext_end_date := get_param_ext_end_date(get_bus_group_id(p_asg_id));
2709: -- Get Vehicle Details

Line 2737: hr_utility.trace('CREATE_EXT_RSLT_DTL_04: Insert result details.');

2733: IF chk_exists%NOTFOUND THEN
2734: -- Record does not exist
2735: -- Call API to create extract details record
2736: BEGIN
2737: hr_utility.trace('CREATE_EXT_RSLT_DTL_04: Insert result details.');
2738: ben_ext_rslt_dtl_api.create_ext_rslt_dtl( p_ext_rslt_dtl_id => l_ext_rslt_dtl_id
2739: ,p_ext_rslt_id => g_ext_rslt_id
2740: ,p_ext_rcd_id => g_veh_rcd_id
2741: ,p_person_id => g_person_id

Line 2772: hr_utility.trace('CREATE_EXT_RSLT_DTL_04: '||substr(sqlerrm, 1, 100));

2768: ,p_val_26 => prim_additional_fuel_days(p_asg_id,p_vehicle_allocation_id)
2769: ,p_val_27 => '~~~~~~~~~~~~~~~'
2770: ,p_object_version_number => l_object_version_no);
2771: EXCEPTION WHEN others THEN
2772: hr_utility.trace('CREATE_EXT_RSLT_DTL_04: '||substr(sqlerrm, 1, 100));
2773: hr_utility.trace('CREATE_EXT_RSLT_DTL_04: '||substr(sqlerrm, 101, 100));
2774: hr_utility.trace('CREATE_EXT_RSLT_DTL_04: '||substr(sqlerrm, 201, 100));
2775: hr_utility.trace('CREATE_EXT_RSLT_DTL_04: '||substr(sqlerrm, 301, 100));
2776: RAISE;

Line 2773: hr_utility.trace('CREATE_EXT_RSLT_DTL_04: '||substr(sqlerrm, 101, 100));

2769: ,p_val_27 => '~~~~~~~~~~~~~~~'
2770: ,p_object_version_number => l_object_version_no);
2771: EXCEPTION WHEN others THEN
2772: hr_utility.trace('CREATE_EXT_RSLT_DTL_04: '||substr(sqlerrm, 1, 100));
2773: hr_utility.trace('CREATE_EXT_RSLT_DTL_04: '||substr(sqlerrm, 101, 100));
2774: hr_utility.trace('CREATE_EXT_RSLT_DTL_04: '||substr(sqlerrm, 201, 100));
2775: hr_utility.trace('CREATE_EXT_RSLT_DTL_04: '||substr(sqlerrm, 301, 100));
2776: RAISE;
2777: END;

Line 2774: hr_utility.trace('CREATE_EXT_RSLT_DTL_04: '||substr(sqlerrm, 201, 100));

2770: ,p_object_version_number => l_object_version_no);
2771: EXCEPTION WHEN others THEN
2772: hr_utility.trace('CREATE_EXT_RSLT_DTL_04: '||substr(sqlerrm, 1, 100));
2773: hr_utility.trace('CREATE_EXT_RSLT_DTL_04: '||substr(sqlerrm, 101, 100));
2774: hr_utility.trace('CREATE_EXT_RSLT_DTL_04: '||substr(sqlerrm, 201, 100));
2775: hr_utility.trace('CREATE_EXT_RSLT_DTL_04: '||substr(sqlerrm, 301, 100));
2776: RAISE;
2777: END;
2778: END IF;

Line 2775: hr_utility.trace('CREATE_EXT_RSLT_DTL_04: '||substr(sqlerrm, 301, 100));

2771: EXCEPTION WHEN others THEN
2772: hr_utility.trace('CREATE_EXT_RSLT_DTL_04: '||substr(sqlerrm, 1, 100));
2773: hr_utility.trace('CREATE_EXT_RSLT_DTL_04: '||substr(sqlerrm, 101, 100));
2774: hr_utility.trace('CREATE_EXT_RSLT_DTL_04: '||substr(sqlerrm, 201, 100));
2775: hr_utility.trace('CREATE_EXT_RSLT_DTL_04: '||substr(sqlerrm, 301, 100));
2776: RAISE;
2777: END;
2778: END IF;
2779: --

Line 2820: hr_utility.trace('Entering PROCESS_SEC_VEH_NEW, p_asg_id='||p_asg_id);

2816: l_prev_veh_id_rec get_veh_id%ROWTYPE;
2817: --
2818: l_new_rec BOOLEAN := TRUE;
2819: BEGIN
2820: hr_utility.trace('Entering PROCESS_SEC_VEH_NEW, p_asg_id='||p_asg_id);
2821: -- Get extract date parameter values
2822: l_ben_start_date := fnd_date.displaydate_to_date(prim_ben_start_date(p_asg_id));
2823: l_ext_start_date := get_param_ext_start_date(get_bus_group_id(p_asg_id));
2824: l_ext_end_date := get_param_ext_end_date(get_bus_group_id(p_asg_id));

Line 2834: hr_utility.trace('PROCESS_SEC_VEH_04, After Fetch.');

2830: -- Loop through all vehicle records and create extract result detail
2831: -- record if there is a change in secondary_car_fuel_benefit or vehicle id
2832: LOOP
2833: FETCH get_veh_id INTO l_veh_id_rec;
2834: hr_utility.trace('PROCESS_SEC_VEH_04, After Fetch.');
2835: hr_utility.trace('PROCESS_SEC_VEH_04, effective_start_date='||to_char(l_veh_id_rec.effective_start_date, 'DD-MON-YYYY'));
2836: hr_utility.trace('PROCESS_SEC_VEH_04, effective_end_date='||to_char(l_veh_id_rec.effective_end_date, 'DD-MON-YYYY'));
2837: hr_utility.trace('PROCESS_SEC_VEH_04, fuel_benefit='||l_veh_id_rec.fuel_benefit);
2838: hr_utility.trace('PROCESS_SEC_VEH_04, vehicle_repository_id='||l_veh_id_rec.vehicle_repository_id);

Line 2835: hr_utility.trace('PROCESS_SEC_VEH_04, effective_start_date='||to_char(l_veh_id_rec.effective_start_date, 'DD-MON-YYYY'));

2831: -- record if there is a change in secondary_car_fuel_benefit or vehicle id
2832: LOOP
2833: FETCH get_veh_id INTO l_veh_id_rec;
2834: hr_utility.trace('PROCESS_SEC_VEH_04, After Fetch.');
2835: hr_utility.trace('PROCESS_SEC_VEH_04, effective_start_date='||to_char(l_veh_id_rec.effective_start_date, 'DD-MON-YYYY'));
2836: hr_utility.trace('PROCESS_SEC_VEH_04, effective_end_date='||to_char(l_veh_id_rec.effective_end_date, 'DD-MON-YYYY'));
2837: hr_utility.trace('PROCESS_SEC_VEH_04, fuel_benefit='||l_veh_id_rec.fuel_benefit);
2838: hr_utility.trace('PROCESS_SEC_VEH_04, vehicle_repository_id='||l_veh_id_rec.vehicle_repository_id);
2839: IF l_new_rec THEN

Line 2836: hr_utility.trace('PROCESS_SEC_VEH_04, effective_end_date='||to_char(l_veh_id_rec.effective_end_date, 'DD-MON-YYYY'));

2832: LOOP
2833: FETCH get_veh_id INTO l_veh_id_rec;
2834: hr_utility.trace('PROCESS_SEC_VEH_04, After Fetch.');
2835: hr_utility.trace('PROCESS_SEC_VEH_04, effective_start_date='||to_char(l_veh_id_rec.effective_start_date, 'DD-MON-YYYY'));
2836: hr_utility.trace('PROCESS_SEC_VEH_04, effective_end_date='||to_char(l_veh_id_rec.effective_end_date, 'DD-MON-YYYY'));
2837: hr_utility.trace('PROCESS_SEC_VEH_04, fuel_benefit='||l_veh_id_rec.fuel_benefit);
2838: hr_utility.trace('PROCESS_SEC_VEH_04, vehicle_repository_id='||l_veh_id_rec.vehicle_repository_id);
2839: IF l_new_rec THEN
2840: hr_utility.trace('PROCESS_SEC_VEH_04, l_new_rec=TRUE');

Line 2837: hr_utility.trace('PROCESS_SEC_VEH_04, fuel_benefit='||l_veh_id_rec.fuel_benefit);

2833: FETCH get_veh_id INTO l_veh_id_rec;
2834: hr_utility.trace('PROCESS_SEC_VEH_04, After Fetch.');
2835: hr_utility.trace('PROCESS_SEC_VEH_04, effective_start_date='||to_char(l_veh_id_rec.effective_start_date, 'DD-MON-YYYY'));
2836: hr_utility.trace('PROCESS_SEC_VEH_04, effective_end_date='||to_char(l_veh_id_rec.effective_end_date, 'DD-MON-YYYY'));
2837: hr_utility.trace('PROCESS_SEC_VEH_04, fuel_benefit='||l_veh_id_rec.fuel_benefit);
2838: hr_utility.trace('PROCESS_SEC_VEH_04, vehicle_repository_id='||l_veh_id_rec.vehicle_repository_id);
2839: IF l_new_rec THEN
2840: hr_utility.trace('PROCESS_SEC_VEH_04, l_new_rec=TRUE');
2841: ELSE

Line 2838: hr_utility.trace('PROCESS_SEC_VEH_04, vehicle_repository_id='||l_veh_id_rec.vehicle_repository_id);

2834: hr_utility.trace('PROCESS_SEC_VEH_04, After Fetch.');
2835: hr_utility.trace('PROCESS_SEC_VEH_04, effective_start_date='||to_char(l_veh_id_rec.effective_start_date, 'DD-MON-YYYY'));
2836: hr_utility.trace('PROCESS_SEC_VEH_04, effective_end_date='||to_char(l_veh_id_rec.effective_end_date, 'DD-MON-YYYY'));
2837: hr_utility.trace('PROCESS_SEC_VEH_04, fuel_benefit='||l_veh_id_rec.fuel_benefit);
2838: hr_utility.trace('PROCESS_SEC_VEH_04, vehicle_repository_id='||l_veh_id_rec.vehicle_repository_id);
2839: IF l_new_rec THEN
2840: hr_utility.trace('PROCESS_SEC_VEH_04, l_new_rec=TRUE');
2841: ELSE
2842: hr_utility.trace('PROCESS_SEC_VEH_04, l_new_rec=FALSE');

Line 2840: hr_utility.trace('PROCESS_SEC_VEH_04, l_new_rec=TRUE');

2836: hr_utility.trace('PROCESS_SEC_VEH_04, effective_end_date='||to_char(l_veh_id_rec.effective_end_date, 'DD-MON-YYYY'));
2837: hr_utility.trace('PROCESS_SEC_VEH_04, fuel_benefit='||l_veh_id_rec.fuel_benefit);
2838: hr_utility.trace('PROCESS_SEC_VEH_04, vehicle_repository_id='||l_veh_id_rec.vehicle_repository_id);
2839: IF l_new_rec THEN
2840: hr_utility.trace('PROCESS_SEC_VEH_04, l_new_rec=TRUE');
2841: ELSE
2842: hr_utility.trace('PROCESS_SEC_VEH_04, l_new_rec=FALSE');
2843: END IF;
2844: --

Line 2842: hr_utility.trace('PROCESS_SEC_VEH_04, l_new_rec=FALSE');

2838: hr_utility.trace('PROCESS_SEC_VEH_04, vehicle_repository_id='||l_veh_id_rec.vehicle_repository_id);
2839: IF l_new_rec THEN
2840: hr_utility.trace('PROCESS_SEC_VEH_04, l_new_rec=TRUE');
2841: ELSE
2842: hr_utility.trace('PROCESS_SEC_VEH_04, l_new_rec=FALSE');
2843: END IF;
2844: --
2845: IF get_veh_id%FOUND THEN
2846: IF l_new_rec THEN

Line 2888: hr_utility.trace('Leaving PROCESS_SEC_VEH_04.');

2884: EXIT;
2885: END IF;
2886: END LOOP;
2887: --
2888: hr_utility.trace('Leaving PROCESS_SEC_VEH_04.');
2889: --
2890: END process_sec_veh_04;
2891: ---------------------------------------------------------------------------
2892: -- Procedure: PROCESS_PRIM_VEH_04

Line 2927: hr_utility.trace('Entering PROCESS_PRIM_VEH_04, p_asg_id='||p_asg_id);

2923: l_prev_veh_id_rec get_veh_id%ROWTYPE;
2924: --
2925: l_new_rec BOOLEAN := TRUE;
2926: BEGIN
2927: hr_utility.trace('Entering PROCESS_PRIM_VEH_04, p_asg_id='||p_asg_id);
2928: -- Get extract date parameter values
2929: l_ben_start_date := fnd_date.displaydate_to_date(prim_ben_start_date(p_asg_id));
2930: l_ext_start_date := get_param_ext_start_date(get_bus_group_id(p_asg_id));
2931: l_ext_end_date := get_param_ext_end_date(get_bus_group_id(p_asg_id));

Line 2941: hr_utility.trace('PROCESS_PRIM_VEH_04, After Fetch.');

2937: -- Loop through all vehicle records and create extract result detail
2938: -- record if there is a change in primary_car_fuel_benifit or vehicle id
2939: LOOP
2940: FETCH get_veh_id INTO l_veh_id_rec;
2941: hr_utility.trace('PROCESS_PRIM_VEH_04, After Fetch.');
2942: hr_utility.trace('PROCESS_PRIM_VEH_04, effective_start_date='||to_char(l_veh_id_rec.effective_start_date, 'DD-MON-YYYY'));
2943: hr_utility.trace('PROCESS_PRIM_VEH_04, effective_end_date='||to_char(l_veh_id_rec.effective_end_date, 'DD-MON-YYYY'));
2944: hr_utility.trace('PROCESS_PRIM_VEH_04, fuel_benefit='||l_veh_id_rec.fuel_benefit);
2945: hr_utility.trace('PROCESS_PRIM_VEH_04, vehicle_repository_id='||l_veh_id_rec.vehicle_repository_id);

Line 2942: hr_utility.trace('PROCESS_PRIM_VEH_04, effective_start_date='||to_char(l_veh_id_rec.effective_start_date, 'DD-MON-YYYY'));

2938: -- record if there is a change in primary_car_fuel_benifit or vehicle id
2939: LOOP
2940: FETCH get_veh_id INTO l_veh_id_rec;
2941: hr_utility.trace('PROCESS_PRIM_VEH_04, After Fetch.');
2942: hr_utility.trace('PROCESS_PRIM_VEH_04, effective_start_date='||to_char(l_veh_id_rec.effective_start_date, 'DD-MON-YYYY'));
2943: hr_utility.trace('PROCESS_PRIM_VEH_04, effective_end_date='||to_char(l_veh_id_rec.effective_end_date, 'DD-MON-YYYY'));
2944: hr_utility.trace('PROCESS_PRIM_VEH_04, fuel_benefit='||l_veh_id_rec.fuel_benefit);
2945: hr_utility.trace('PROCESS_PRIM_VEH_04, vehicle_repository_id='||l_veh_id_rec.vehicle_repository_id);
2946: IF l_new_rec THEN

Line 2943: hr_utility.trace('PROCESS_PRIM_VEH_04, effective_end_date='||to_char(l_veh_id_rec.effective_end_date, 'DD-MON-YYYY'));

2939: LOOP
2940: FETCH get_veh_id INTO l_veh_id_rec;
2941: hr_utility.trace('PROCESS_PRIM_VEH_04, After Fetch.');
2942: hr_utility.trace('PROCESS_PRIM_VEH_04, effective_start_date='||to_char(l_veh_id_rec.effective_start_date, 'DD-MON-YYYY'));
2943: hr_utility.trace('PROCESS_PRIM_VEH_04, effective_end_date='||to_char(l_veh_id_rec.effective_end_date, 'DD-MON-YYYY'));
2944: hr_utility.trace('PROCESS_PRIM_VEH_04, fuel_benefit='||l_veh_id_rec.fuel_benefit);
2945: hr_utility.trace('PROCESS_PRIM_VEH_04, vehicle_repository_id='||l_veh_id_rec.vehicle_repository_id);
2946: IF l_new_rec THEN
2947: hr_utility.trace('PROCESS_PRIM_VEH_04, l_new_rec=TRUE');

Line 2944: hr_utility.trace('PROCESS_PRIM_VEH_04, fuel_benefit='||l_veh_id_rec.fuel_benefit);

2940: FETCH get_veh_id INTO l_veh_id_rec;
2941: hr_utility.trace('PROCESS_PRIM_VEH_04, After Fetch.');
2942: hr_utility.trace('PROCESS_PRIM_VEH_04, effective_start_date='||to_char(l_veh_id_rec.effective_start_date, 'DD-MON-YYYY'));
2943: hr_utility.trace('PROCESS_PRIM_VEH_04, effective_end_date='||to_char(l_veh_id_rec.effective_end_date, 'DD-MON-YYYY'));
2944: hr_utility.trace('PROCESS_PRIM_VEH_04, fuel_benefit='||l_veh_id_rec.fuel_benefit);
2945: hr_utility.trace('PROCESS_PRIM_VEH_04, vehicle_repository_id='||l_veh_id_rec.vehicle_repository_id);
2946: IF l_new_rec THEN
2947: hr_utility.trace('PROCESS_PRIM_VEH_04, l_new_rec=TRUE');
2948: ELSE

Line 2945: hr_utility.trace('PROCESS_PRIM_VEH_04, vehicle_repository_id='||l_veh_id_rec.vehicle_repository_id);

2941: hr_utility.trace('PROCESS_PRIM_VEH_04, After Fetch.');
2942: hr_utility.trace('PROCESS_PRIM_VEH_04, effective_start_date='||to_char(l_veh_id_rec.effective_start_date, 'DD-MON-YYYY'));
2943: hr_utility.trace('PROCESS_PRIM_VEH_04, effective_end_date='||to_char(l_veh_id_rec.effective_end_date, 'DD-MON-YYYY'));
2944: hr_utility.trace('PROCESS_PRIM_VEH_04, fuel_benefit='||l_veh_id_rec.fuel_benefit);
2945: hr_utility.trace('PROCESS_PRIM_VEH_04, vehicle_repository_id='||l_veh_id_rec.vehicle_repository_id);
2946: IF l_new_rec THEN
2947: hr_utility.trace('PROCESS_PRIM_VEH_04, l_new_rec=TRUE');
2948: ELSE
2949: hr_utility.trace('PROCESS_PRIM_VEH_04, l_new_rec=FALSE');

Line 2947: hr_utility.trace('PROCESS_PRIM_VEH_04, l_new_rec=TRUE');

2943: hr_utility.trace('PROCESS_PRIM_VEH_04, effective_end_date='||to_char(l_veh_id_rec.effective_end_date, 'DD-MON-YYYY'));
2944: hr_utility.trace('PROCESS_PRIM_VEH_04, fuel_benefit='||l_veh_id_rec.fuel_benefit);
2945: hr_utility.trace('PROCESS_PRIM_VEH_04, vehicle_repository_id='||l_veh_id_rec.vehicle_repository_id);
2946: IF l_new_rec THEN
2947: hr_utility.trace('PROCESS_PRIM_VEH_04, l_new_rec=TRUE');
2948: ELSE
2949: hr_utility.trace('PROCESS_PRIM_VEH_04, l_new_rec=FALSE');
2950: END IF;
2951: --

Line 2949: hr_utility.trace('PROCESS_PRIM_VEH_04, l_new_rec=FALSE');

2945: hr_utility.trace('PROCESS_PRIM_VEH_04, vehicle_repository_id='||l_veh_id_rec.vehicle_repository_id);
2946: IF l_new_rec THEN
2947: hr_utility.trace('PROCESS_PRIM_VEH_04, l_new_rec=TRUE');
2948: ELSE
2949: hr_utility.trace('PROCESS_PRIM_VEH_04, l_new_rec=FALSE');
2950: END IF;
2951: --
2952: IF get_veh_id%FOUND THEN
2953: IF l_new_rec THEN

Line 2966: hr_utility.trace('PROCESS_PRIM_VEH_04: Creating Vehicle Record for this assignment.');

2962: -- vehicle benefits did not change therefore continue looping
2963: l_prev_veh_id_rec.effective_end_date := l_veh_id_rec.effective_end_date;
2964: ELSE
2965: -- Vehicle Details have changed therefore create reslt dtl record
2966: hr_utility.trace('PROCESS_PRIM_VEH_04: Creating Vehicle Record for this assignment.');
2967: create_ext_rslt_dtl_04(p_asg_id, l_asg_start_date, l_asg_end_date,
2968: l_prev_veh_id_rec.effective_start_date,
2969: l_prev_veh_id_rec.effective_end_date,
2970: l_prev_veh_id_rec.fuel_benefit,

Line 2984: hr_utility.trace('PROCESS_PRIM_VEH_04: Creating Last Vehicle Record for this assignment.');

2980: END IF;
2981: ELSE
2982: -- Last record reched, create ext rslt dtl record
2983: IF l_prev_veh_id_rec.vehicle_repository_id IS NOT NULL THEN
2984: hr_utility.trace('PROCESS_PRIM_VEH_04: Creating Last Vehicle Record for this assignment.');
2985: create_ext_rslt_dtl_04(p_asg_id, l_asg_start_date, l_asg_end_date,
2986: l_prev_veh_id_rec.effective_start_date,
2987: l_prev_veh_id_rec.effective_end_date,
2988: l_prev_veh_id_rec.fuel_benefit,

Line 2997: hr_utility.trace('Leaving PROCESS_PRIM_VEH_04.');

2993: EXIT;
2994: END IF;
2995: END LOOP;
2996: --
2997: hr_utility.trace('Leaving PROCESS_PRIM_VEH_04.');
2998: --
2999: END process_prim_veh_04;
3000: ---------------------------------------------------------------------------
3001: -- Procedure: PROCESS_SEC_ASG_04

Line 3019: hr_utility.trace('Entering PROCESS_SEC_ASG, p_asg_id='||p_asg_id);

3015: --
3016: l_asg_include VARCHAR2(1) := 'N';
3017: --
3018: BEGIN
3019: hr_utility.trace('Entering PROCESS_SEC_ASG, p_asg_id='||p_asg_id);
3020: --
3021: -- Loop through all secondary assignments
3022: FOR sec_asg_rec IN get_sec_asg LOOP
3023: --

Line 3033: hr_utility.trace('Leaving PROCESS_SEC_ASG_04.');

3029: process_sec_veh_04(sec_asg_rec.assignment_id);
3030: END IF;
3031: END LOOP;
3032: --
3033: hr_utility.trace('Leaving PROCESS_SEC_ASG_04.');
3034: END process_sec_asg_04;
3035: ---------------------------------------------------------------------------
3036: -- Procedure: PROCESS_TERM_PRIMARY_ASG_04
3037: -- Desctiption: This procedure will process all primary assignments

Line 3055: hr_utility.trace('Entering PROCESS_TERM_PRIMARY_ASG_04, p_asg_id='||p_asg_id);

3051: --
3052: l_asg_include VARCHAR2(1) := 'N';
3053: --
3054: BEGIN
3055: hr_utility.trace('Entering PROCESS_TERM_PRIMARY_ASG_04, p_asg_id='||p_asg_id);
3056: --
3057: -- Loop through all previous primary assignments
3058: FOR term_primary_asg_rec IN get_term_primary_asg LOOP
3059: --

Line 3069: hr_utility.trace('Leaving PROCESS_TERM_PRIMARY_ASG_04.');

3065: process_sec_veh_04(term_primary_asg_rec.assignment_id);
3066: END IF;
3067: END LOOP;
3068: --
3069: hr_utility.trace('Leaving PROCESS_TERM_PRIMARY_ASG_04.');
3070: END process_term_primary_asg_04;
3071: ---------------------------------------------------------------------------
3072: -- Function: POST_PROCESS_RULE_04
3073: -- Desctiption: This function processes all extracted primary assignments to

Line 3126: hr_utility.trace('Entering POST_PROCESS_RULE_04, p_ext_rslt_id='||p_ext_rslt_id);

3122: --
3123: l_asg_include VARCHAR2(1);
3124: --
3125: BEGIN
3126: hr_utility.trace('Entering POST_PROCESS_RULE_04, p_ext_rslt_id='||p_ext_rslt_id);
3127:
3128: g_ext_rslt_id := p_ext_rslt_id;
3129: -- Get assignment details record id
3130: OPEN get_asg_rcd_id;

Line 3134: hr_utility.trace('POST_PROCESS_RULE_04: l_asg_rcd_id='||l_asg_rcd_id);

3130: OPEN get_asg_rcd_id;
3131: FETCH get_asg_rcd_id INTO l_asg_rcd_id;
3132: CLOSE get_asg_rcd_id;
3133: --
3134: hr_utility.trace('POST_PROCESS_RULE_04: l_asg_rcd_id='||l_asg_rcd_id);
3135: -- Get Vehicle Details Record Id
3136: OPEN get_veh_rcd_id;
3137: FETCH get_veh_rcd_id INTO g_veh_rcd_id;
3138: CLOSE get_veh_rcd_id;

Line 3140: hr_utility.trace('POST_PROCESS_RULE_04: g_veh_rcd_id='||g_veh_rcd_id);

3136: OPEN get_veh_rcd_id;
3137: FETCH get_veh_rcd_id INTO g_veh_rcd_id;
3138: CLOSE get_veh_rcd_id;
3139: --
3140: hr_utility.trace('POST_PROCESS_RULE_04: g_veh_rcd_id='||g_veh_rcd_id);
3141: -- Loop through all people extracted
3142: FOR ext_asg_rec IN get_ext_asg LOOP
3143: g_person_id := ext_asg_rec.person_id;
3144: g_bg_id := get_bus_group_id(ext_asg_rec.asg_id);

Line 3147: hr_utility.trace('POST_PROCESS_RULE_04: ext_asg_rec.asg_id='||ext_asg_rec.asg_id);

3143: g_person_id := ext_asg_rec.person_id;
3144: g_bg_id := get_bus_group_id(ext_asg_rec.asg_id);
3145: l_prim_veh_dtl := NULL;
3146: --
3147: hr_utility.trace('POST_PROCESS_RULE_04: ext_asg_rec.asg_id='||ext_asg_rec.asg_id);
3148: hr_utility.trace('POST_PROCESS_RULE_04: g_person_id='||g_person_id);
3149: -- Delete extract result detail if primary vehicle details id is null
3150:
3151: OPEN get_prim_veh_dtl(ext_asg_rec.person_id);

Line 3148: hr_utility.trace('POST_PROCESS_RULE_04: g_person_id='||g_person_id);

3144: g_bg_id := get_bus_group_id(ext_asg_rec.asg_id);
3145: l_prim_veh_dtl := NULL;
3146: --
3147: hr_utility.trace('POST_PROCESS_RULE_04: ext_asg_rec.asg_id='||ext_asg_rec.asg_id);
3148: hr_utility.trace('POST_PROCESS_RULE_04: g_person_id='||g_person_id);
3149: -- Delete extract result detail if primary vehicle details id is null
3150:
3151: OPEN get_prim_veh_dtl(ext_asg_rec.person_id);
3152: FETCH get_prim_veh_dtl INTO l_prim_veh_dtl;

Line 3156: hr_utility.trace('POST_PROCESS_RULE_04: l_prim_veh_dtl.ext_rslt_dtl_id='||l_prim_veh_dtl.ext_rslt_dtl_id);

3152: FETCH get_prim_veh_dtl INTO l_prim_veh_dtl;
3153: CLOSE get_prim_veh_dtl;
3154: --
3155: l_asg_include := check_asg_inclusion(ext_asg_rec.asg_id);
3156: hr_utility.trace('POST_PROCESS_RULE_04: l_prim_veh_dtl.ext_rslt_dtl_id='||l_prim_veh_dtl.ext_rslt_dtl_id);
3157: --
3158: IF l_prim_veh_dtl.ext_rslt_dtl_id IS NOT NULL AND l_asg_include = 'N' THEN
3159: -- Primary assignment does not qualify for extract
3160: -- Delete this extract rslt details

Line 3175: hr_utility.trace('POST_PROCESS_RULE_04: Assignment processed, remove it from the extract details table.');

3171: --
3172: process_term_primary_asg_04(ext_asg_rec.asg_id);
3173: process_sec_asg_04(ext_asg_rec.asg_id);
3174: --
3175: hr_utility.trace('POST_PROCESS_RULE_04: Assignment processed, remove it from the extract details table.');
3176: l_obj_no := ext_asg_rec.object_version_number;
3177: -- Delete this assignment details record
3178: ben_ext_rslt_dtl_api.delete_ext_rslt_dtl(p_ext_rslt_dtl_id => ext_asg_rec.ext_rslt_dtl_id,
3179: p_object_version_number => l_obj_no);

Line 3183: hr_utility.trace('Leaving Post_process_rule_04.');

3179: p_object_version_number => l_obj_no);
3180: --
3181: END LOOP;
3182: --
3183: hr_utility.trace('Leaving Post_process_rule_04.');
3184: RETURN 'Y';
3185: --
3186: END post_process_rule_04;
3187: ---------------------------------------------------------------------------