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_EDI_P46_CAR dependencies on FND_DATE

Line 345: AND fnd_date.date_to_canonical(p_allocation_start_date) = pai.action_information3;

341: AND 'AAP' = pai.action_context_type
342: AND 'GB P46 CAR EDI ALLOCATION' = pai.action_information_category
343: AND p_action_flag = pai.action_information1
344: AND to_char(p_vehicle_allocation_id) = pai.action_information2
345: AND fnd_date.date_to_canonical(p_allocation_start_date) = pai.action_information3;
346: --
347: chk_archive_rec c_chk_archive%ROWTYPE;
348: --
349: l_archived_flag VARCHAR2(1) := 'Y';

Line 355: hr_utility.trace(l_proc||': p_allocation_start_date='|| fnd_date.date_to_displaydate(p_allocation_start_date));

351: BEGIN
352: hr_utility.set_location(l_proc, 10);
353: hr_utility.trace(l_proc||': p_assignment_id='|| p_assignment_id);
354: hr_utility.trace(l_proc||': p_vehicle_allocation_id='|| p_vehicle_allocation_id);
355: hr_utility.trace(l_proc||': p_allocation_start_date='|| fnd_date.date_to_displaydate(p_allocation_start_date));
356: hr_utility.trace(l_proc||': p_action_flag='|| p_action_flag);
357: --
358: OPEN c_chk_archive;
359: FETCH c_chk_archive INTO chk_archive_rec;

Line 399: AND (fnd_date.date_to_canonical(p_allocation_start_date) = pai.action_information3

395: AND 'AAP' = pai.action_context_type
396: AND 'GB P46 CAR EDI ALLOCATION' = pai.action_information_category
397: AND p_action_flag = pai.action_information1
398: AND to_char(p_vehicle_allocation_id) = pai.action_information2
399: AND (fnd_date.date_to_canonical(p_allocation_start_date) = pai.action_information3
400: OR fnd_date.date_to_canonical(p_orig_allocation_start_date) = pai.action_information3); -- Modified for the bug 10088866
401: --
402: chk_archive_rec c_chk_archive%ROWTYPE;
403: --

Line 400: OR fnd_date.date_to_canonical(p_orig_allocation_start_date) = pai.action_information3); -- Modified for the bug 10088866

396: AND 'GB P46 CAR EDI ALLOCATION' = pai.action_information_category
397: AND p_action_flag = pai.action_information1
398: AND to_char(p_vehicle_allocation_id) = pai.action_information2
399: AND (fnd_date.date_to_canonical(p_allocation_start_date) = pai.action_information3
400: OR fnd_date.date_to_canonical(p_orig_allocation_start_date) = pai.action_information3); -- Modified for the bug 10088866
401: --
402: chk_archive_rec c_chk_archive%ROWTYPE;
403: --
404: l_archived_flag VARCHAR2(1) := 'Y';

Line 410: hr_utility.trace(l_proc||': p_allocation_start_date='|| fnd_date.date_to_displaydate(p_allocation_start_date));

406: BEGIN
407: hr_utility.set_location(l_proc, 10);
408: hr_utility.trace(l_proc||': p_assignment_id='|| p_assignment_id);
409: hr_utility.trace(l_proc||': p_vehicle_allocation_id='|| p_vehicle_allocation_id);
410: hr_utility.trace(l_proc||': p_allocation_start_date='|| fnd_date.date_to_displaydate(p_allocation_start_date));
411: hr_utility.trace(l_proc||': p_action_flag='|| p_action_flag);
412: --
413: OPEN c_chk_archive;
414: FETCH c_chk_archive INTO chk_archive_rec;

Line 481: hr_utility.trace(l_proc||': effective_Date='||fnd_date.date_to_displaydate(employer_rec.effective_date));

477: hr_utility.trace(l_proc||': employer_name='||employer_rec.employer_name);
478: hr_utility.trace(l_proc||': employer_address_line='||employer_rec.employer_address_line);
479: hr_utility.trace(l_proc||': tax_district_name='||employer_rec.tax_district_name);
480: hr_utility.trace(l_proc||': organization_id='||employer_rec.organization_id);
481: hr_utility.trace(l_proc||': effective_Date='||fnd_date.date_to_displaydate(employer_rec.effective_date));
482: --
483: pay_action_information_api.create_action_information (
484: p_action_information_id => l_action_info_id
485: , p_action_context_id => pactid

Line 577: hr_utility.trace(l_proc||': effective_Date='||fnd_date.date_to_displaydate(employer_rec.effective_date));

573: hr_utility.trace(l_proc||': employer_name='||employer_rec.employer_name);
574: hr_utility.trace(l_proc||': employer_address_line='||employer_rec.employer_address_line);
575: hr_utility.trace(l_proc||': tax_district_name='||employer_rec.tax_district_name);
576: hr_utility.trace(l_proc||': organization_id='||employer_rec.organization_id);
577: hr_utility.trace(l_proc||': effective_Date='||fnd_date.date_to_displaydate(employer_rec.effective_date));
578: --
579: pay_action_information_api.create_action_information (
580: p_action_information_id => l_action_info_id
581: , p_action_context_id => pactid

Line 674: hr_utility.trace(l_proc||': effective_Date='||fnd_date.date_to_displaydate(employer_rec.effective_date));

670: hr_utility.trace(l_proc||': employer_name='||employer_rec.employer_name);
671: hr_utility.trace(l_proc||': employer_address_line='||employer_rec.employer_address_line);
672: hr_utility.trace(l_proc||': tax_district_name='||employer_rec.tax_district_name);
673: hr_utility.trace(l_proc||': organization_id='||employer_rec.organization_id);
674: hr_utility.trace(l_proc||': effective_Date='||fnd_date.date_to_displaydate(employer_rec.effective_date));
675: --
676: pay_action_information_api.create_action_information (
677: p_action_information_id => l_action_info_id
678: , p_action_context_id => pactid

Line 770: hr_utility.trace(l_proc||': effective_Date='||fnd_date.date_to_displaydate(employer_rec.effective_date));

766: hr_utility.trace(l_proc||': employer_name='||employer_rec.employer_name);
767: hr_utility.trace(l_proc||': employer_address_line='||employer_rec.employer_address_line);
768: hr_utility.trace(l_proc||': tax_district_name='||employer_rec.tax_district_name);
769: hr_utility.trace(l_proc||': organization_id='||employer_rec.organization_id);
770: hr_utility.trace(l_proc||': effective_Date='||fnd_date.date_to_displaydate(employer_rec.effective_date));
771: --
772: pay_action_information_api.create_action_information (
773: p_action_information_id => l_action_info_id
774: , p_action_context_id => pactid

Line 834: fnd_date.canonical_to_date(

830: legislative_parameters,
831: 'TAX_REF'),1,20) tax_ref,
832: start_date,
833: effective_date,
834: fnd_date.canonical_to_date(
835: pay_gb_eoy_archive.get_parameter(
836: legislative_parameters,
837: 'END_DATE')) end_date,
838: business_group_id

Line 894: hr_utility.trace(l_proc||': g_start_date='||fnd_date.date_to_displaydate(g_start_date));

890: --
891: hr_utility.set_location(l_proc, 15);
892: hr_utility.trace(l_proc||': g_payroll_id='||g_payroll_id);
893: hr_utility.trace(l_proc||': g_tax_ref='||g_tax_ref);
894: hr_utility.trace(l_proc||': g_start_date='||fnd_date.date_to_displaydate(g_start_date));
895: hr_utility.trace(l_proc||': g_effective_date='||fnd_date.date_to_displaydate(g_effective_date));
896: hr_utility.trace(l_proc||': g_end_date='||fnd_date.date_to_displaydate(g_end_date));
897: hr_utility.trace(l_proc||': g_business_group_id='||g_business_group_id);
898: For asg_rec IN c_asg

Line 895: hr_utility.trace(l_proc||': g_effective_date='||fnd_date.date_to_displaydate(g_effective_date));

891: hr_utility.set_location(l_proc, 15);
892: hr_utility.trace(l_proc||': g_payroll_id='||g_payroll_id);
893: hr_utility.trace(l_proc||': g_tax_ref='||g_tax_ref);
894: hr_utility.trace(l_proc||': g_start_date='||fnd_date.date_to_displaydate(g_start_date));
895: hr_utility.trace(l_proc||': g_effective_date='||fnd_date.date_to_displaydate(g_effective_date));
896: hr_utility.trace(l_proc||': g_end_date='||fnd_date.date_to_displaydate(g_end_date));
897: hr_utility.trace(l_proc||': g_business_group_id='||g_business_group_id);
898: For asg_rec IN c_asg
899: LOOP

Line 896: hr_utility.trace(l_proc||': g_end_date='||fnd_date.date_to_displaydate(g_end_date));

892: hr_utility.trace(l_proc||': g_payroll_id='||g_payroll_id);
893: hr_utility.trace(l_proc||': g_tax_ref='||g_tax_ref);
894: hr_utility.trace(l_proc||': g_start_date='||fnd_date.date_to_displaydate(g_start_date));
895: hr_utility.trace(l_proc||': g_effective_date='||fnd_date.date_to_displaydate(g_effective_date));
896: hr_utility.trace(l_proc||': g_end_date='||fnd_date.date_to_displaydate(g_end_date));
897: hr_utility.trace(l_proc||': g_business_group_id='||g_business_group_id);
898: For asg_rec IN c_asg
899: LOOP
900: -- Loop through all assignments

Line 903: hr_utility.trace(l_proc||': asg_min_start_date='||fnd_date.date_to_displaydate(asg_rec.asg_min_start_date));

899: LOOP
900: -- Loop through all assignments
901: hr_utility.set_location(l_proc, 20);
902: hr_utility.trace(l_proc||': assignment_id='||asg_rec.assignment_id);
903: hr_utility.trace(l_proc||': asg_min_start_date='||fnd_date.date_to_displaydate(asg_rec.asg_min_start_date));
904: hr_utility.trace(l_proc||': asg_max_end_date='||fnd_date.date_to_displaydate(asg_rec.asg_max_end_date));
905: --
906: l_create_assact_flag := 'N';
907: --

Line 904: hr_utility.trace(l_proc||': asg_max_end_date='||fnd_date.date_to_displaydate(asg_rec.asg_max_end_date));

900: -- Loop through all assignments
901: hr_utility.set_location(l_proc, 20);
902: hr_utility.trace(l_proc||': assignment_id='||asg_rec.assignment_id);
903: hr_utility.trace(l_proc||': asg_min_start_date='||fnd_date.date_to_displaydate(asg_rec.asg_min_start_date));
904: hr_utility.trace(l_proc||': asg_max_end_date='||fnd_date.date_to_displaydate(asg_rec.asg_max_end_date));
905: --
906: l_create_assact_flag := 'N';
907: --
908: FOR alc_rec IN c_allocations(asg_rec.assignment_id) LOOP

Line 923: hr_utility.trace(l_proc||': min_start_date='|| fnd_date.date_to_displaydate(alc_dates_rec.min_start_date));

919: FETCH c_alloc_dates INTO alc_dates_rec;
920: CLOSE c_alloc_dates;
921: --
922: hr_utility.set_location(l_proc, 40);
923: hr_utility.trace(l_proc||': min_start_date='|| fnd_date.date_to_displaydate(alc_dates_rec.min_start_date));
924: hr_utility.trace(l_proc||': max_end_date='|| fnd_date.date_to_displaydate(alc_dates_rec.max_end_date));
925: --
926: -- Check whether vehicle was allocated or
927: -- Withdrawn within the date range also

Line 924: hr_utility.trace(l_proc||': max_end_date='|| fnd_date.date_to_displaydate(alc_dates_rec.max_end_date));

920: CLOSE c_alloc_dates;
921: --
922: hr_utility.set_location(l_proc, 40);
923: hr_utility.trace(l_proc||': min_start_date='|| fnd_date.date_to_displaydate(alc_dates_rec.min_start_date));
924: hr_utility.trace(l_proc||': max_end_date='|| fnd_date.date_to_displaydate(alc_dates_rec.max_end_date));
925: --
926: -- Check whether vehicle was allocated or
927: -- Withdrawn within the date range also
928: -- check that this allocation or withdrawal

Line 1299: fnd_date.canonical_to_date(

1295: legislative_parameters,
1296: 'TAX_REF'),1,20) tax_ref,
1297: start_date,
1298: effective_date,
1299: fnd_date.canonical_to_date(
1300: pay_gb_eoy_archive.get_parameter(
1301: legislative_parameters,
1302: 'END_DATE')) end_date,
1303: business_group_id

Line 1361: hr_utility.trace(l_proc||': g_start_date='||fnd_date.date_to_displaydate(g_start_date));

1357: --
1358: hr_utility.set_location(l_proc, 15);
1359: hr_utility.trace(l_proc||': g_payroll_id='||g_payroll_id);
1360: hr_utility.trace(l_proc||': g_tax_ref='||g_tax_ref);
1361: hr_utility.trace(l_proc||': g_start_date='||fnd_date.date_to_displaydate(g_start_date));
1362: hr_utility.trace(l_proc||': g_effective_date='||fnd_date.date_to_displaydate(g_effective_date));
1363: hr_utility.trace(l_proc||': g_end_date='||fnd_date.date_to_displaydate(g_end_date));
1364: hr_utility.trace(l_proc||': g_business_group_id='||g_business_group_id);
1365: For asg_rec IN c_asg

Line 1362: hr_utility.trace(l_proc||': g_effective_date='||fnd_date.date_to_displaydate(g_effective_date));

1358: hr_utility.set_location(l_proc, 15);
1359: hr_utility.trace(l_proc||': g_payroll_id='||g_payroll_id);
1360: hr_utility.trace(l_proc||': g_tax_ref='||g_tax_ref);
1361: hr_utility.trace(l_proc||': g_start_date='||fnd_date.date_to_displaydate(g_start_date));
1362: hr_utility.trace(l_proc||': g_effective_date='||fnd_date.date_to_displaydate(g_effective_date));
1363: hr_utility.trace(l_proc||': g_end_date='||fnd_date.date_to_displaydate(g_end_date));
1364: hr_utility.trace(l_proc||': g_business_group_id='||g_business_group_id);
1365: For asg_rec IN c_asg
1366: LOOP

Line 1363: hr_utility.trace(l_proc||': g_end_date='||fnd_date.date_to_displaydate(g_end_date));

1359: hr_utility.trace(l_proc||': g_payroll_id='||g_payroll_id);
1360: hr_utility.trace(l_proc||': g_tax_ref='||g_tax_ref);
1361: hr_utility.trace(l_proc||': g_start_date='||fnd_date.date_to_displaydate(g_start_date));
1362: hr_utility.trace(l_proc||': g_effective_date='||fnd_date.date_to_displaydate(g_effective_date));
1363: hr_utility.trace(l_proc||': g_end_date='||fnd_date.date_to_displaydate(g_end_date));
1364: hr_utility.trace(l_proc||': g_business_group_id='||g_business_group_id);
1365: For asg_rec IN c_asg
1366: LOOP
1367: -- Loop through all assignments

Line 1370: hr_utility.trace(l_proc||': asg_min_start_date='||fnd_date.date_to_displaydate(asg_rec.asg_min_start_date));

1366: LOOP
1367: -- Loop through all assignments
1368: hr_utility.set_location(l_proc, 20);
1369: hr_utility.trace(l_proc||': assignment_id='||asg_rec.assignment_id);
1370: hr_utility.trace(l_proc||': asg_min_start_date='||fnd_date.date_to_displaydate(asg_rec.asg_min_start_date));
1371: hr_utility.trace(l_proc||': asg_max_end_date='||fnd_date.date_to_displaydate(asg_rec.asg_max_end_date));
1372: --
1373: l_create_assact_flag := 'N';
1374: --

Line 1371: hr_utility.trace(l_proc||': asg_max_end_date='||fnd_date.date_to_displaydate(asg_rec.asg_max_end_date));

1367: -- Loop through all assignments
1368: hr_utility.set_location(l_proc, 20);
1369: hr_utility.trace(l_proc||': assignment_id='||asg_rec.assignment_id);
1370: hr_utility.trace(l_proc||': asg_min_start_date='||fnd_date.date_to_displaydate(asg_rec.asg_min_start_date));
1371: hr_utility.trace(l_proc||': asg_max_end_date='||fnd_date.date_to_displaydate(asg_rec.asg_max_end_date));
1372: --
1373: l_create_assact_flag := 'N';
1374: --
1375: FOR alc_rec IN c_allocations(asg_rec.assignment_id) LOOP

Line 1446: hr_utility.trace(l_proc||': min_start_date='|| fnd_date.date_to_displaydate(alc_dates_rec.min_start_date));

1442: FETCH c_alloc_dates INTO alc_dates_rec;
1443: CLOSE c_alloc_dates;
1444: --
1445: hr_utility.set_location(l_proc, 40);
1446: hr_utility.trace(l_proc||': min_start_date='|| fnd_date.date_to_displaydate(alc_dates_rec.min_start_date));
1447: hr_utility.trace(l_proc||': max_end_date='|| fnd_date.date_to_displaydate(alc_dates_rec.max_end_date));
1448: --
1449: -- Check whether vehicle was allocated or
1450: -- Withdrawn within the date range also

Line 1447: hr_utility.trace(l_proc||': max_end_date='|| fnd_date.date_to_displaydate(alc_dates_rec.max_end_date));

1443: CLOSE c_alloc_dates;
1444: --
1445: hr_utility.set_location(l_proc, 40);
1446: hr_utility.trace(l_proc||': min_start_date='|| fnd_date.date_to_displaydate(alc_dates_rec.min_start_date));
1447: hr_utility.trace(l_proc||': max_end_date='|| fnd_date.date_to_displaydate(alc_dates_rec.max_end_date));
1448: --
1449: -- Check whether vehicle was allocated or
1450: -- Withdrawn within the date range also
1451: -- check that this allocation or withdrawal

Line 1453: hr_utility.trace(l_proc||': alc_dates_rec.min_start_date='|| fnd_date.date_to_displaydate(alc_dates_rec.min_start_date));

1449: -- Check whether vehicle was allocated or
1450: -- Withdrawn within the date range also
1451: -- check that this allocation or withdrawal
1452: -- happened when assignment was with input tax ref
1453: hr_utility.trace(l_proc||': alc_dates_rec.min_start_date='|| fnd_date.date_to_displaydate(alc_dates_rec.min_start_date));
1454: hr_utility.trace(l_proc||': asg_rec.asg_min_start_date='|| fnd_date.date_to_displaydate(asg_rec.asg_min_start_date));
1455: hr_utility.trace(l_proc||': asg_rec.asg_max_end_date='|| fnd_date.date_to_displaydate(asg_rec.asg_max_end_date));
1456: hr_utility.trace(l_proc||': alc_rec.usage_type='|| alc_rec.usage_type);
1457: IF (alc_dates_rec.min_start_date BETWEEN g_start_date AND g_end_Date) AND

Line 1454: hr_utility.trace(l_proc||': asg_rec.asg_min_start_date='|| fnd_date.date_to_displaydate(asg_rec.asg_min_start_date));

1450: -- Withdrawn within the date range also
1451: -- check that this allocation or withdrawal
1452: -- happened when assignment was with input tax ref
1453: hr_utility.trace(l_proc||': alc_dates_rec.min_start_date='|| fnd_date.date_to_displaydate(alc_dates_rec.min_start_date));
1454: hr_utility.trace(l_proc||': asg_rec.asg_min_start_date='|| fnd_date.date_to_displaydate(asg_rec.asg_min_start_date));
1455: hr_utility.trace(l_proc||': asg_rec.asg_max_end_date='|| fnd_date.date_to_displaydate(asg_rec.asg_max_end_date));
1456: hr_utility.trace(l_proc||': alc_rec.usage_type='|| alc_rec.usage_type);
1457: IF (alc_dates_rec.min_start_date BETWEEN g_start_date AND g_end_Date) AND
1458: (alc_dates_rec.min_start_date BETWEEN asg_rec.asg_min_start_date AND asg_rec.asg_max_end_date) THEN

Line 1455: hr_utility.trace(l_proc||': asg_rec.asg_max_end_date='|| fnd_date.date_to_displaydate(asg_rec.asg_max_end_date));

1451: -- check that this allocation or withdrawal
1452: -- happened when assignment was with input tax ref
1453: hr_utility.trace(l_proc||': alc_dates_rec.min_start_date='|| fnd_date.date_to_displaydate(alc_dates_rec.min_start_date));
1454: hr_utility.trace(l_proc||': asg_rec.asg_min_start_date='|| fnd_date.date_to_displaydate(asg_rec.asg_min_start_date));
1455: hr_utility.trace(l_proc||': asg_rec.asg_max_end_date='|| fnd_date.date_to_displaydate(asg_rec.asg_max_end_date));
1456: hr_utility.trace(l_proc||': alc_rec.usage_type='|| alc_rec.usage_type);
1457: IF (alc_dates_rec.min_start_date BETWEEN g_start_date AND g_end_Date) AND
1458: (alc_dates_rec.min_start_date BETWEEN asg_rec.asg_min_start_date AND asg_rec.asg_max_end_date) THEN
1459: --

Line 1833: fnd_date.canonical_to_date(

1829: legislative_parameters,
1830: 'TAX_REF'),1,20) tax_ref,
1831: start_date,
1832: effective_date,
1833: fnd_date.canonical_to_date(
1834: pay_gb_eoy_archive.get_parameter(
1835: legislative_parameters,
1836: 'END_DATE')) end_date,
1837: business_group_id

Line 1895: hr_utility.trace(l_proc||': g_start_date='||fnd_date.date_to_displaydate(g_start_date));

1891: --
1892: hr_utility.set_location(l_proc, 15);
1893: hr_utility.trace(l_proc||': g_payroll_id='||g_payroll_id);
1894: hr_utility.trace(l_proc||': g_tax_ref='||g_tax_ref);
1895: hr_utility.trace(l_proc||': g_start_date='||fnd_date.date_to_displaydate(g_start_date));
1896: hr_utility.trace(l_proc||': g_effective_date='||fnd_date.date_to_displaydate(g_effective_date));
1897: hr_utility.trace(l_proc||': g_end_date='||fnd_date.date_to_displaydate(g_end_date));
1898: hr_utility.trace(l_proc||': g_business_group_id='||g_business_group_id);
1899: For asg_rec IN c_asg

Line 1896: hr_utility.trace(l_proc||': g_effective_date='||fnd_date.date_to_displaydate(g_effective_date));

1892: hr_utility.set_location(l_proc, 15);
1893: hr_utility.trace(l_proc||': g_payroll_id='||g_payroll_id);
1894: hr_utility.trace(l_proc||': g_tax_ref='||g_tax_ref);
1895: hr_utility.trace(l_proc||': g_start_date='||fnd_date.date_to_displaydate(g_start_date));
1896: hr_utility.trace(l_proc||': g_effective_date='||fnd_date.date_to_displaydate(g_effective_date));
1897: hr_utility.trace(l_proc||': g_end_date='||fnd_date.date_to_displaydate(g_end_date));
1898: hr_utility.trace(l_proc||': g_business_group_id='||g_business_group_id);
1899: For asg_rec IN c_asg
1900: LOOP

Line 1897: hr_utility.trace(l_proc||': g_end_date='||fnd_date.date_to_displaydate(g_end_date));

1893: hr_utility.trace(l_proc||': g_payroll_id='||g_payroll_id);
1894: hr_utility.trace(l_proc||': g_tax_ref='||g_tax_ref);
1895: hr_utility.trace(l_proc||': g_start_date='||fnd_date.date_to_displaydate(g_start_date));
1896: hr_utility.trace(l_proc||': g_effective_date='||fnd_date.date_to_displaydate(g_effective_date));
1897: hr_utility.trace(l_proc||': g_end_date='||fnd_date.date_to_displaydate(g_end_date));
1898: hr_utility.trace(l_proc||': g_business_group_id='||g_business_group_id);
1899: For asg_rec IN c_asg
1900: LOOP
1901: -- Loop through all assignments

Line 1904: hr_utility.trace(l_proc||': asg_min_start_date='||fnd_date.date_to_displaydate(asg_rec.asg_min_start_date));

1900: LOOP
1901: -- Loop through all assignments
1902: hr_utility.set_location(l_proc, 20);
1903: hr_utility.trace(l_proc||': assignment_id='||asg_rec.assignment_id);
1904: hr_utility.trace(l_proc||': asg_min_start_date='||fnd_date.date_to_displaydate(asg_rec.asg_min_start_date));
1905: hr_utility.trace(l_proc||': asg_max_end_date='||fnd_date.date_to_displaydate(asg_rec.asg_max_end_date));
1906: --
1907: l_create_assact_flag := 'N';
1908: --

Line 1905: hr_utility.trace(l_proc||': asg_max_end_date='||fnd_date.date_to_displaydate(asg_rec.asg_max_end_date));

1901: -- Loop through all assignments
1902: hr_utility.set_location(l_proc, 20);
1903: hr_utility.trace(l_proc||': assignment_id='||asg_rec.assignment_id);
1904: hr_utility.trace(l_proc||': asg_min_start_date='||fnd_date.date_to_displaydate(asg_rec.asg_min_start_date));
1905: hr_utility.trace(l_proc||': asg_max_end_date='||fnd_date.date_to_displaydate(asg_rec.asg_max_end_date));
1906: --
1907: l_create_assact_flag := 'N';
1908: --
1909: FOR alc_rec IN c_allocations(asg_rec.assignment_id) LOOP

Line 1983: hr_utility.trace(l_proc||': min_start_date='|| fnd_date.date_to_displaydate(alc_dates_rec.min_start_date));

1979: FETCH c_alloc_dates INTO alc_dates_rec;
1980: CLOSE c_alloc_dates;
1981: --
1982: hr_utility.set_location(l_proc, 40);
1983: hr_utility.trace(l_proc||': min_start_date='|| fnd_date.date_to_displaydate(alc_dates_rec.min_start_date));
1984: hr_utility.trace(l_proc||': max_end_date='|| fnd_date.date_to_displaydate(alc_dates_rec.max_end_date));
1985: --
1986: -- Check whether vehicle was allocated or
1987: -- Withdrawn within the date range also

Line 1984: hr_utility.trace(l_proc||': max_end_date='|| fnd_date.date_to_displaydate(alc_dates_rec.max_end_date));

1980: CLOSE c_alloc_dates;
1981: --
1982: hr_utility.set_location(l_proc, 40);
1983: hr_utility.trace(l_proc||': min_start_date='|| fnd_date.date_to_displaydate(alc_dates_rec.min_start_date));
1984: hr_utility.trace(l_proc||': max_end_date='|| fnd_date.date_to_displaydate(alc_dates_rec.max_end_date));
1985: --
1986: -- Check whether vehicle was allocated or
1987: -- Withdrawn within the date range also
1988: -- check that this allocation or withdrawal

Line 1990: hr_utility.trace(l_proc||': alc_dates_rec.min_start_date='|| fnd_date.date_to_displaydate(alc_dates_rec.min_start_date));

1986: -- Check whether vehicle was allocated or
1987: -- Withdrawn within the date range also
1988: -- check that this allocation or withdrawal
1989: -- happened when assignment was with input tax ref
1990: hr_utility.trace(l_proc||': alc_dates_rec.min_start_date='|| fnd_date.date_to_displaydate(alc_dates_rec.min_start_date));
1991: hr_utility.trace(l_proc||': asg_rec.asg_min_start_date='|| fnd_date.date_to_displaydate(asg_rec.asg_min_start_date));
1992: hr_utility.trace(l_proc||': asg_rec.asg_max_end_date='|| fnd_date.date_to_displaydate(asg_rec.asg_max_end_date));
1993: hr_utility.trace(l_proc||': alc_rec.usage_type='|| alc_rec.usage_type);
1994: IF (alc_dates_rec.min_start_date BETWEEN g_start_date AND g_end_Date) AND

Line 1991: hr_utility.trace(l_proc||': asg_rec.asg_min_start_date='|| fnd_date.date_to_displaydate(asg_rec.asg_min_start_date));

1987: -- Withdrawn within the date range also
1988: -- check that this allocation or withdrawal
1989: -- happened when assignment was with input tax ref
1990: hr_utility.trace(l_proc||': alc_dates_rec.min_start_date='|| fnd_date.date_to_displaydate(alc_dates_rec.min_start_date));
1991: hr_utility.trace(l_proc||': asg_rec.asg_min_start_date='|| fnd_date.date_to_displaydate(asg_rec.asg_min_start_date));
1992: hr_utility.trace(l_proc||': asg_rec.asg_max_end_date='|| fnd_date.date_to_displaydate(asg_rec.asg_max_end_date));
1993: hr_utility.trace(l_proc||': alc_rec.usage_type='|| alc_rec.usage_type);
1994: IF (alc_dates_rec.min_start_date BETWEEN g_start_date AND g_end_Date) AND
1995: (alc_dates_rec.min_start_date BETWEEN asg_rec.asg_min_start_date AND asg_rec.asg_max_end_date) THEN

Line 1992: hr_utility.trace(l_proc||': asg_rec.asg_max_end_date='|| fnd_date.date_to_displaydate(asg_rec.asg_max_end_date));

1988: -- check that this allocation or withdrawal
1989: -- happened when assignment was with input tax ref
1990: hr_utility.trace(l_proc||': alc_dates_rec.min_start_date='|| fnd_date.date_to_displaydate(alc_dates_rec.min_start_date));
1991: hr_utility.trace(l_proc||': asg_rec.asg_min_start_date='|| fnd_date.date_to_displaydate(asg_rec.asg_min_start_date));
1992: hr_utility.trace(l_proc||': asg_rec.asg_max_end_date='|| fnd_date.date_to_displaydate(asg_rec.asg_max_end_date));
1993: hr_utility.trace(l_proc||': alc_rec.usage_type='|| alc_rec.usage_type);
1994: IF (alc_dates_rec.min_start_date BETWEEN g_start_date AND g_end_Date) AND
1995: (alc_dates_rec.min_start_date BETWEEN asg_rec.asg_min_start_date AND asg_rec.asg_max_end_date) THEN
1996: --

Line 2373: fnd_date.canonical_to_date(

2369: legislative_parameters,
2370: 'TAX_REF'),1,20) tax_ref,
2371: start_date,
2372: effective_date,
2373: fnd_date.canonical_to_date(
2374: pay_gb_eoy_archive.get_parameter(
2375: legislative_parameters,
2376: 'END_DATE')) end_date,
2377: business_group_id

Line 2435: hr_utility.trace(l_proc||': g_start_date='||fnd_date.date_to_displaydate(g_start_date));

2431: --
2432: hr_utility.set_location(l_proc, 15);
2433: hr_utility.trace(l_proc||': g_payroll_id='||g_payroll_id);
2434: hr_utility.trace(l_proc||': g_tax_ref='||g_tax_ref);
2435: hr_utility.trace(l_proc||': g_start_date='||fnd_date.date_to_displaydate(g_start_date));
2436: hr_utility.trace(l_proc||': g_effective_date='||fnd_date.date_to_displaydate(g_effective_date));
2437: hr_utility.trace(l_proc||': g_end_date='||fnd_date.date_to_displaydate(g_end_date));
2438: hr_utility.trace(l_proc||': g_business_group_id='||g_business_group_id);
2439: For asg_rec IN c_asg

Line 2436: hr_utility.trace(l_proc||': g_effective_date='||fnd_date.date_to_displaydate(g_effective_date));

2432: hr_utility.set_location(l_proc, 15);
2433: hr_utility.trace(l_proc||': g_payroll_id='||g_payroll_id);
2434: hr_utility.trace(l_proc||': g_tax_ref='||g_tax_ref);
2435: hr_utility.trace(l_proc||': g_start_date='||fnd_date.date_to_displaydate(g_start_date));
2436: hr_utility.trace(l_proc||': g_effective_date='||fnd_date.date_to_displaydate(g_effective_date));
2437: hr_utility.trace(l_proc||': g_end_date='||fnd_date.date_to_displaydate(g_end_date));
2438: hr_utility.trace(l_proc||': g_business_group_id='||g_business_group_id);
2439: For asg_rec IN c_asg
2440: LOOP

Line 2437: hr_utility.trace(l_proc||': g_end_date='||fnd_date.date_to_displaydate(g_end_date));

2433: hr_utility.trace(l_proc||': g_payroll_id='||g_payroll_id);
2434: hr_utility.trace(l_proc||': g_tax_ref='||g_tax_ref);
2435: hr_utility.trace(l_proc||': g_start_date='||fnd_date.date_to_displaydate(g_start_date));
2436: hr_utility.trace(l_proc||': g_effective_date='||fnd_date.date_to_displaydate(g_effective_date));
2437: hr_utility.trace(l_proc||': g_end_date='||fnd_date.date_to_displaydate(g_end_date));
2438: hr_utility.trace(l_proc||': g_business_group_id='||g_business_group_id);
2439: For asg_rec IN c_asg
2440: LOOP
2441: -- Loop through all assignments

Line 2444: hr_utility.trace(l_proc||': asg_min_start_date='||fnd_date.date_to_displaydate(asg_rec.asg_min_start_date));

2440: LOOP
2441: -- Loop through all assignments
2442: hr_utility.set_location(l_proc, 20);
2443: hr_utility.trace(l_proc||': assignment_id='||asg_rec.assignment_id);
2444: hr_utility.trace(l_proc||': asg_min_start_date='||fnd_date.date_to_displaydate(asg_rec.asg_min_start_date));
2445: hr_utility.trace(l_proc||': asg_max_end_date='||fnd_date.date_to_displaydate(asg_rec.asg_max_end_date));
2446: --
2447: l_create_assact_flag := 'N';
2448: --

Line 2445: hr_utility.trace(l_proc||': asg_max_end_date='||fnd_date.date_to_displaydate(asg_rec.asg_max_end_date));

2441: -- Loop through all assignments
2442: hr_utility.set_location(l_proc, 20);
2443: hr_utility.trace(l_proc||': assignment_id='||asg_rec.assignment_id);
2444: hr_utility.trace(l_proc||': asg_min_start_date='||fnd_date.date_to_displaydate(asg_rec.asg_min_start_date));
2445: hr_utility.trace(l_proc||': asg_max_end_date='||fnd_date.date_to_displaydate(asg_rec.asg_max_end_date));
2446: --
2447: l_create_assact_flag := 'N';
2448: --
2449: FOR alc_rec IN c_allocations(asg_rec.assignment_id) LOOP

Line 2523: hr_utility.trace(l_proc||': min_start_date='|| fnd_date.date_to_displaydate(alc_dates_rec.min_start_date));

2519: FETCH c_alloc_dates INTO alc_dates_rec;
2520: CLOSE c_alloc_dates;
2521: --
2522: hr_utility.set_location(l_proc, 40);
2523: hr_utility.trace(l_proc||': min_start_date='|| fnd_date.date_to_displaydate(alc_dates_rec.min_start_date));
2524: hr_utility.trace(l_proc||': max_end_date='|| fnd_date.date_to_displaydate(alc_dates_rec.max_end_date));
2525: --
2526: -- Check whether vehicle was allocated or
2527: -- Withdrawn within the date range also

Line 2524: hr_utility.trace(l_proc||': max_end_date='|| fnd_date.date_to_displaydate(alc_dates_rec.max_end_date));

2520: CLOSE c_alloc_dates;
2521: --
2522: hr_utility.set_location(l_proc, 40);
2523: hr_utility.trace(l_proc||': min_start_date='|| fnd_date.date_to_displaydate(alc_dates_rec.min_start_date));
2524: hr_utility.trace(l_proc||': max_end_date='|| fnd_date.date_to_displaydate(alc_dates_rec.max_end_date));
2525: --
2526: -- Check whether vehicle was allocated or
2527: -- Withdrawn within the date range also
2528: -- check that this allocation or withdrawal

Line 2530: hr_utility.trace(l_proc||': alc_dates_rec.min_start_date='|| fnd_date.date_to_displaydate(alc_dates_rec.min_start_date));

2526: -- Check whether vehicle was allocated or
2527: -- Withdrawn within the date range also
2528: -- check that this allocation or withdrawal
2529: -- happened when assignment was with input tax ref
2530: hr_utility.trace(l_proc||': alc_dates_rec.min_start_date='|| fnd_date.date_to_displaydate(alc_dates_rec.min_start_date));
2531: hr_utility.trace(l_proc||': asg_rec.asg_min_start_date='|| fnd_date.date_to_displaydate(asg_rec.asg_min_start_date));
2532: hr_utility.trace(l_proc||': asg_rec.asg_max_end_date='|| fnd_date.date_to_displaydate(asg_rec.asg_max_end_date));
2533: hr_utility.trace(l_proc||': alc_rec.usage_type='|| alc_rec.usage_type);
2534: IF (alc_dates_rec.min_start_date BETWEEN g_start_date AND g_end_Date) AND

Line 2531: hr_utility.trace(l_proc||': asg_rec.asg_min_start_date='|| fnd_date.date_to_displaydate(asg_rec.asg_min_start_date));

2527: -- Withdrawn within the date range also
2528: -- check that this allocation or withdrawal
2529: -- happened when assignment was with input tax ref
2530: hr_utility.trace(l_proc||': alc_dates_rec.min_start_date='|| fnd_date.date_to_displaydate(alc_dates_rec.min_start_date));
2531: hr_utility.trace(l_proc||': asg_rec.asg_min_start_date='|| fnd_date.date_to_displaydate(asg_rec.asg_min_start_date));
2532: hr_utility.trace(l_proc||': asg_rec.asg_max_end_date='|| fnd_date.date_to_displaydate(asg_rec.asg_max_end_date));
2533: hr_utility.trace(l_proc||': alc_rec.usage_type='|| alc_rec.usage_type);
2534: IF (alc_dates_rec.min_start_date BETWEEN g_start_date AND g_end_Date) AND
2535: (alc_dates_rec.min_start_date BETWEEN asg_rec.asg_min_start_date AND asg_rec.asg_max_end_date) THEN

Line 2532: hr_utility.trace(l_proc||': asg_rec.asg_max_end_date='|| fnd_date.date_to_displaydate(asg_rec.asg_max_end_date));

2528: -- check that this allocation or withdrawal
2529: -- happened when assignment was with input tax ref
2530: hr_utility.trace(l_proc||': alc_dates_rec.min_start_date='|| fnd_date.date_to_displaydate(alc_dates_rec.min_start_date));
2531: hr_utility.trace(l_proc||': asg_rec.asg_min_start_date='|| fnd_date.date_to_displaydate(asg_rec.asg_min_start_date));
2532: hr_utility.trace(l_proc||': asg_rec.asg_max_end_date='|| fnd_date.date_to_displaydate(asg_rec.asg_max_end_date));
2533: hr_utility.trace(l_proc||': alc_rec.usage_type='|| alc_rec.usage_type);
2534: IF (alc_dates_rec.min_start_date BETWEEN g_start_date AND g_end_Date) AND
2535: (alc_dates_rec.min_start_date BETWEEN asg_rec.asg_min_start_date AND asg_rec.asg_max_end_date) THEN
2536: --

Line 2941: AND nvl(addr.date_to, fnd_date.canonical_to_date('4712/12/31'));

2937: FROM per_addresses addr
2938: WHERE addr.person_id = p_person_id
2939: AND addr.primary_flag = 'Y'
2940: AND l_eff_date BETWEEN addr.date_from
2941: AND nvl(addr.date_to, fnd_date.canonical_to_date('4712/12/31'));
2942: --
2943: addr_rec c_addr%ROWTYPE;
2944: --
2945: CURSOR c_alloc IS

Line 3032: hr_utility.trace('p_fuel_type_change_date='||fnd_date.date_to_displaydate(p_fuel_type_change_date));

3028: hr_utility.trace('p_asg_act_id='||p_asg_act_id);
3029: hr_utility.trace('p_vehicle_allocation_id='||p_vehicle_allocation_id);
3030: hr_utility.trace('p_vehicle_repository_id='||p_vehicle_repository_id);
3031: hr_utility.trace('p_action_flag='||p_action_flag);
3032: hr_utility.trace('p_fuel_type_change_date='||fnd_date.date_to_displaydate(p_fuel_type_change_date));
3033: hr_utility.trace('p_allocation_start_date='||fnd_date.date_to_displaydate(p_allocation_start_date));
3034: hr_utility.trace('p_allocation_end_date='||fnd_date.date_to_displaydate(p_allocation_end_date));
3035: -- Get data as of the action date within
3036: -- the date range, effective date is:

Line 3033: hr_utility.trace('p_allocation_start_date='||fnd_date.date_to_displaydate(p_allocation_start_date));

3029: hr_utility.trace('p_vehicle_allocation_id='||p_vehicle_allocation_id);
3030: hr_utility.trace('p_vehicle_repository_id='||p_vehicle_repository_id);
3031: hr_utility.trace('p_action_flag='||p_action_flag);
3032: hr_utility.trace('p_fuel_type_change_date='||fnd_date.date_to_displaydate(p_fuel_type_change_date));
3033: hr_utility.trace('p_allocation_start_date='||fnd_date.date_to_displaydate(p_allocation_start_date));
3034: hr_utility.trace('p_allocation_end_date='||fnd_date.date_to_displaydate(p_allocation_end_date));
3035: -- Get data as of the action date within
3036: -- the date range, effective date is:
3037: IF p_action_flag = 'F' THEN

Line 3034: hr_utility.trace('p_allocation_end_date='||fnd_date.date_to_displaydate(p_allocation_end_date));

3030: hr_utility.trace('p_vehicle_repository_id='||p_vehicle_repository_id);
3031: hr_utility.trace('p_action_flag='||p_action_flag);
3032: hr_utility.trace('p_fuel_type_change_date='||fnd_date.date_to_displaydate(p_fuel_type_change_date));
3033: hr_utility.trace('p_allocation_start_date='||fnd_date.date_to_displaydate(p_allocation_start_date));
3034: hr_utility.trace('p_allocation_end_date='||fnd_date.date_to_displaydate(p_allocation_end_date));
3035: -- Get data as of the action date within
3036: -- the date range, effective date is:
3037: IF p_action_flag = 'F' THEN
3038: -- Get data as of the fuel type change date

Line 3046: hr_utility.trace('l_eff_date='||fnd_date.date_to_displaydate(l_eff_date));

3042: ELSIF p_action_flag = 'W' THEN
3043: l_eff_date := p_allocation_end_date;
3044: END IF;
3045: hr_utility.set_location(l_proc, 20);
3046: hr_utility.trace('l_eff_date='||fnd_date.date_to_displaydate(l_eff_date));
3047: --
3048: -- Get person details
3049: OPEN c_person(p_assignment_id);
3050: FETCH c_person INTO person_rec;

Line 3093: hr_utility.trace('DOB : ' || fnd_date.date_to_canonical(person_rec.date_of_birth)); --For Bug 6652235

3089: hr_utility.trace('ADDR1 : ' || addr_rec.address_line3);
3090: hr_utility.trace('City/Town : ' || addr_rec.town_or_city);
3091: hr_utility.trace('Regioin_1 : ' || addr_rec.region_1);
3092: hr_utility.trace('Postal : ' || addr_rec.postal_code);
3093: hr_utility.trace('DOB : ' || fnd_date.date_to_canonical(person_rec.date_of_birth)); --For Bug 6652235
3094: hr_utility.trace('Gender : ' || person_rec.sex); --For Bug 6652235
3095:
3096: pay_action_information_api.create_action_information (
3097: p_action_information_id => l_action_info_id

Line 3117: , p_action_information12 => fnd_date.date_to_canonical(person_rec.date_of_birth) --For Bug 6652235

3113: , p_action_information8 => upper(addr_rec.address_line3)
3114: , p_action_information9 => upper(addr_rec.town_or_city)
3115: , p_action_information10 => upper(addr_rec.region_1)
3116: , p_action_information11 => upper(addr_rec.postal_code)
3117: , p_action_information12 => fnd_date.date_to_canonical(person_rec.date_of_birth) --For Bug 6652235
3118: , p_action_information13 => upper(person_rec.sex)); --For Bug 6652235
3119: --
3120: hr_utility.set_location(l_proc, 70);
3121: ---------------------------------------------

Line 3125: fnd_date.canonical_to_date(

3121: ---------------------------------------------
3122: -- Archive Vehicle Allocation Details --
3123: ---------------------------------------------
3124: IF g_effective_date <
3125: fnd_date.canonical_to_date(
3126: to_char(g_effective_date, 'YYYY')||'04/06') THEN
3127: -- Effective Date between 1st Jan
3128: -- to 5th Apr of the calendar year
3129: l_tax_year_start := fnd_date.canonical_to_date(

Line 3129: l_tax_year_start := fnd_date.canonical_to_date(

3125: fnd_date.canonical_to_date(
3126: to_char(g_effective_date, 'YYYY')||'04/06') THEN
3127: -- Effective Date between 1st Jan
3128: -- to 5th Apr of the calendar year
3129: l_tax_year_start := fnd_date.canonical_to_date(
3130: to_char(to_number(to_char(g_effective_date, 'YYYY')) -1)
3131: ||'04/06');
3132: ELSE
3133: -- Effective Date between 06th Apr

Line 3135: l_tax_year_start := fnd_date.canonical_to_date(

3131: ||'04/06');
3132: ELSE
3133: -- Effective Date between 06th Apr
3134: -- to 31st Dec of the calendar year
3135: l_tax_year_start := fnd_date.canonical_to_date(
3136: to_char(g_effective_date, 'YYYY')||'04/06');
3137: END IF;
3138: --
3139: hr_utility.set_location(l_proc, 80);

Line 3144: l_date_first_avail := fnd_date.date_to_canonical(p_allocation_start_date);

3140: --
3141: IF p_allocation_start_date >= l_tax_year_start THEN
3142: -- Car was first allocated in this tax year
3143: -- Archive Date Car First Available
3144: l_date_first_avail := fnd_date.date_to_canonical(p_allocation_start_date);
3145: ELSE
3146: l_date_first_avail := NULL;
3147: END IF;
3148: --

Line 3190: l_date_first_avail := fnd_date.date_to_canonical(p_fuel_type_Change_date);

3186: --
3187: -- To indicate the Fuel Type change date in EDI File. Also checked
3188: -- that this is not Second/Further car.
3189: IF NOT(p_fuel_type_Change_date is NULL) AND p_action_flag = 'F' THEN
3190: l_date_first_avail := fnd_date.date_to_canonical(p_fuel_type_Change_date);
3191: hr_utility.trace('p_fuel_type_change_date='||p_fuel_type_Change_date);
3192: END IF;
3193:
3194:

Line 3210: , p_action_information3 => fnd_date.date_to_canonical(p_allocation_start_date)

3206: , p_source_text => NULL
3207: , p_action_information_category => 'GB P46 CAR EDI ALLOCATION'
3208: , p_action_information1 => p_action_flag
3209: , p_action_information2 => p_vehicle_allocation_id
3210: , p_action_information3 => fnd_date.date_to_canonical(p_allocation_start_date)
3211: , p_action_information4 => fnd_date.date_to_canonical(p_allocation_end_date)
3212: , p_action_information5 => p_vehicle_repository_id
3213: , p_action_information6 => to_char(nvl(car_rec.list_price,0)*100)
3214: , p_action_information7 => to_char(nvl(car_rec.accessory_value_at_startdate,0)*100)

Line 3211: , p_action_information4 => fnd_date.date_to_canonical(p_allocation_end_date)

3207: , p_action_information_category => 'GB P46 CAR EDI ALLOCATION'
3208: , p_action_information1 => p_action_flag
3209: , p_action_information2 => p_vehicle_allocation_id
3210: , p_action_information3 => fnd_date.date_to_canonical(p_allocation_start_date)
3211: , p_action_information4 => fnd_date.date_to_canonical(p_allocation_end_date)
3212: , p_action_information5 => p_vehicle_repository_id
3213: , p_action_information6 => to_char(nvl(car_rec.list_price,0)*100)
3214: , p_action_information7 => to_char(nvl(car_rec.accessory_value_at_startdate,0)*100)
3215: , p_action_information8 => to_char(nvl(alloc_rec.capital_contribution,0)*100)

Line 3220: , p_action_information13 => fnd_date.date_to_canonical(car_rec.initial_registration)

3216: , p_action_information9 => to_char(nvl(alloc_rec.private_contribution,0)*100)
3217: , p_action_information10 => car_rec.fuel_type
3218: , p_action_information11 => car_rec.fiscal_ratings
3219: , p_action_information12 => alloc_rec.fuel_benefit
3220: , p_action_information13 => fnd_date.date_to_canonical(car_rec.initial_registration)
3221: , p_action_information14 => l_date_first_avail
3222: , p_action_information15 => l_second_car_flag
3223: , p_action_information16 => upper(car_rec.make || ' ' || car_rec.model)
3224: , p_action_information17 => to_char(car_rec.engine_capacity_in_cc)

Line 3243: , p_action_information3 => fnd_date.date_to_canonical(p_allocation_start_date)

3239: , p_source_text => NULL
3240: , p_action_information_category => 'GB P46 CAR EDI ALLOCATION'
3241: , p_action_information1 => p_action_flag
3242: , p_action_information2 => p_vehicle_allocation_id
3243: , p_action_information3 => fnd_date.date_to_canonical(p_allocation_start_date)
3244: , p_action_information4 => fnd_date.date_to_canonical(p_allocation_end_date)
3245: , p_action_information5 => p_vehicle_repository_id
3246: , p_action_information6 => to_char(nvl(car_rec.list_price,0)*100)
3247: , p_action_information7 => to_char(nvl(car_rec.accessory_value_at_startdate,0)*100)

Line 3244: , p_action_information4 => fnd_date.date_to_canonical(p_allocation_end_date)

3240: , p_action_information_category => 'GB P46 CAR EDI ALLOCATION'
3241: , p_action_information1 => p_action_flag
3242: , p_action_information2 => p_vehicle_allocation_id
3243: , p_action_information3 => fnd_date.date_to_canonical(p_allocation_start_date)
3244: , p_action_information4 => fnd_date.date_to_canonical(p_allocation_end_date)
3245: , p_action_information5 => p_vehicle_repository_id
3246: , p_action_information6 => to_char(nvl(car_rec.list_price,0)*100)
3247: , p_action_information7 => to_char(nvl(car_rec.accessory_value_at_startdate,0)*100)
3248: , p_action_information8 => to_char(nvl(alloc_rec.capital_contribution,0)*100)

Line 3253: , p_action_information13 => fnd_date.date_to_canonical(car_rec.initial_registration)

3249: , p_action_information9 => to_char(nvl(alloc_rec.private_contribution,0)*100)
3250: , p_action_information10 => car_rec.fuel_type
3251: , p_action_information11 => car_rec.fiscal_ratings
3252: , p_action_information12 => alloc_rec.fuel_benefit
3253: , p_action_information13 => fnd_date.date_to_canonical(car_rec.initial_registration)
3254: , p_action_information14 => l_date_first_avail
3255: , p_action_information15 => l_second_car_flag
3256: , p_action_information16 => upper(car_rec.make || ' ' || car_rec.model)
3257: , p_action_information17 => to_char(car_rec.engine_capacity_in_cc)

Line 3261: , p_action_information21 => fnd_date.date_to_canonical(prior_prim_car_rec.effective_end_date)

3257: , p_action_information17 => to_char(car_rec.engine_capacity_in_cc)
3258: , p_action_information18 => upper(ltrim(rtrim(prior_prim_car_rec.make)) || ' ' || ltrim(rtrim(prior_prim_car_rec.model)))
3259: , p_action_information19 => to_char(prior_prim_car_rec.engine_capacity_in_cc)
3260: , p_action_information20 => to_char(prior_prim_car_rec.vehicle_allocation_id)
3261: , p_action_information21 => fnd_date.date_to_canonical(prior_prim_car_rec.effective_end_date)
3262: , p_action_information22 => nvl(l_interval_of_payment,'Y') -- Added for the bug 9354919
3263: );
3264: --
3265: hr_utility.set_location(l_proc, 160);

Line 3281: , p_action_information3 => fnd_date.date_to_canonical(p_allocation_start_date)

3277: , p_source_text => NULL
3278: , p_action_information_category => 'GB P46 CAR EDI ALLOCATION'
3279: , p_action_information1 => p_action_flag
3280: , p_action_information2 => p_vehicle_allocation_id
3281: , p_action_information3 => fnd_date.date_to_canonical(p_allocation_start_date)
3282: , p_action_information4 => fnd_date.date_to_canonical(p_allocation_end_date)
3283: , p_action_information5 => p_vehicle_repository_id
3284: , p_action_information6 => to_char(nvl(car_rec.list_price,0)*100)
3285: , p_action_information7 => to_char(nvl(car_rec.accessory_value_at_startdate,0)*100)

Line 3282: , p_action_information4 => fnd_date.date_to_canonical(p_allocation_end_date)

3278: , p_action_information_category => 'GB P46 CAR EDI ALLOCATION'
3279: , p_action_information1 => p_action_flag
3280: , p_action_information2 => p_vehicle_allocation_id
3281: , p_action_information3 => fnd_date.date_to_canonical(p_allocation_start_date)
3282: , p_action_information4 => fnd_date.date_to_canonical(p_allocation_end_date)
3283: , p_action_information5 => p_vehicle_repository_id
3284: , p_action_information6 => to_char(nvl(car_rec.list_price,0)*100)
3285: , p_action_information7 => to_char(nvl(car_rec.accessory_value_at_startdate,0)*100)
3286: , p_action_information8 => to_char(nvl(alloc_rec.capital_contribution,0)*100)

Line 3291: , p_action_information13 => fnd_date.date_to_canonical(car_rec.initial_registration)

3287: , p_action_information9 => to_char(nvl(alloc_rec.private_contribution,0)*100)
3288: , p_action_information10 => car_rec.fuel_type
3289: , p_action_information11 => car_rec.fiscal_ratings
3290: , p_action_information12 => alloc_rec.fuel_benefit
3291: , p_action_information13 => fnd_date.date_to_canonical(car_rec.initial_registration)
3292: , p_action_information14 => NULL
3293: , p_action_information15 => NULL
3294: , p_action_information16 => upper(car_rec.make || ' ' || car_rec.model)
3295: , p_action_information17 => to_char(car_rec.engine_capacity_in_cc)

Line 3315: , p_action_information3 => fnd_date.date_to_canonical(p_fuel_type_change_Date)

3311: , p_source_text => NULL
3312: , p_action_information_category => 'GB P46 CAR EDI ALLOCATION'
3313: , p_action_information1 => p_action_flag
3314: , p_action_information2 => p_vehicle_allocation_id
3315: , p_action_information3 => fnd_date.date_to_canonical(p_fuel_type_change_Date)
3316: , p_action_information4 => fnd_date.date_to_canonical(p_allocation_end_date)
3317: , p_action_information5 => p_vehicle_repository_id
3318: , p_action_information6 => to_char(nvl(car_rec.list_price,0)*100)
3319: , p_action_information7 => to_char(nvl(car_rec.accessory_value_at_startdate,0)*100)

Line 3316: , p_action_information4 => fnd_date.date_to_canonical(p_allocation_end_date)

3312: , p_action_information_category => 'GB P46 CAR EDI ALLOCATION'
3313: , p_action_information1 => p_action_flag
3314: , p_action_information2 => p_vehicle_allocation_id
3315: , p_action_information3 => fnd_date.date_to_canonical(p_fuel_type_change_Date)
3316: , p_action_information4 => fnd_date.date_to_canonical(p_allocation_end_date)
3317: , p_action_information5 => p_vehicle_repository_id
3318: , p_action_information6 => to_char(nvl(car_rec.list_price,0)*100)
3319: , p_action_information7 => to_char(nvl(car_rec.accessory_value_at_startdate,0)*100)
3320: , p_action_information8 => to_char(nvl(alloc_rec.capital_contribution,0)*100)

Line 3325: , p_action_information13 => fnd_date.date_to_canonical(car_rec.initial_registration)

3321: , p_action_information9 => to_char(nvl(alloc_rec.private_contribution,0)*100)
3322: , p_action_information10 => car_rec.fuel_type
3323: , p_action_information11 => car_rec.fiscal_ratings
3324: , p_action_information12 => alloc_rec.fuel_benefit
3325: , p_action_information13 => fnd_date.date_to_canonical(car_rec.initial_registration)
3326: , p_action_information14 => l_date_first_avail
3327: , p_action_information15 => l_second_car_flag
3328: , p_action_information16 => upper(car_rec.make || ' ' || car_rec.model)
3329: , p_action_information17 => to_char(car_rec.engine_capacity_in_cc)

Line 3333: , p_action_information21 => fnd_date.date_to_canonical(p_fuel_type_change_date-1)

3329: , p_action_information17 => to_char(car_rec.engine_capacity_in_cc)
3330: , p_action_information18 => upper(car_rec.make || ' ' || car_rec.model)
3331: , p_action_information19 => to_char(car_rec.engine_capacity_in_cc)
3332: , p_action_information20 => to_char(p_vehicle_allocation_id)
3333: , p_action_information21 => fnd_date.date_to_canonical(p_fuel_type_change_date-1)
3334: , p_action_information22 => nvl(l_interval_of_payment,'Y') -- Added for the bug 9354919
3335: );
3336: --
3337: hr_utility.set_location(l_proc, 200);

Line 3387: hr_utility.trace(l_proc||': asg_min_start_date='||fnd_date.date_to_displaydate(asg_rec.asg_min_start_date));

3383: LOOP
3384: -- Loop through all assignments
3385: hr_utility.set_location(l_proc, 20);
3386: hr_utility.trace(l_proc||': assignment_id='||asg_rec.assignment_id);
3387: hr_utility.trace(l_proc||': asg_min_start_date='||fnd_date.date_to_displaydate(asg_rec.asg_min_start_date));
3388: hr_utility.trace(l_proc||': asg_max_end_date='||fnd_date.date_to_displaydate(asg_rec.asg_max_end_date));
3389: --
3390: FOR alc_rec IN c_allocations(asg_rec.assignment_id) LOOP
3391: -- Loop through all vehicle allocations

Line 3388: hr_utility.trace(l_proc||': asg_max_end_date='||fnd_date.date_to_displaydate(asg_rec.asg_max_end_date));

3384: -- Loop through all assignments
3385: hr_utility.set_location(l_proc, 20);
3386: hr_utility.trace(l_proc||': assignment_id='||asg_rec.assignment_id);
3387: hr_utility.trace(l_proc||': asg_min_start_date='||fnd_date.date_to_displaydate(asg_rec.asg_min_start_date));
3388: hr_utility.trace(l_proc||': asg_max_end_date='||fnd_date.date_to_displaydate(asg_rec.asg_max_end_date));
3389: --
3390: FOR alc_rec IN c_allocations(asg_rec.assignment_id) LOOP
3391: -- Loop through all vehicle allocations
3392: -- over the date range

Line 3405: hr_utility.trace(l_proc||': min_start_date='|| fnd_date.date_to_displaydate(alc_dates_rec.min_start_date));

3401: FETCH c_alloc_dates INTO alc_dates_rec;
3402: CLOSE c_alloc_dates;
3403: --
3404: hr_utility.set_location(l_proc, 40);
3405: hr_utility.trace(l_proc||': min_start_date='|| fnd_date.date_to_displaydate(alc_dates_rec.min_start_date));
3406: hr_utility.trace(l_proc||': max_end_date='|| fnd_date.date_to_displaydate(alc_dates_rec.max_end_date));
3407: --
3408: -- Check whether vehicle was allocated or
3409: -- Withdrawn within the date range also

Line 3406: hr_utility.trace(l_proc||': max_end_date='|| fnd_date.date_to_displaydate(alc_dates_rec.max_end_date));

3402: CLOSE c_alloc_dates;
3403: --
3404: hr_utility.set_location(l_proc, 40);
3405: hr_utility.trace(l_proc||': min_start_date='|| fnd_date.date_to_displaydate(alc_dates_rec.min_start_date));
3406: hr_utility.trace(l_proc||': max_end_date='|| fnd_date.date_to_displaydate(alc_dates_rec.max_end_date));
3407: --
3408: -- Check whether vehicle was allocated or
3409: -- Withdrawn within the date range also
3410: -- check that this allocation or withdrawal

Line 3495: hr_utility.trace(l_proc||': alc_dates_rec.min_start_date='|| fnd_date.date_to_displaydate(alc_dates_rec.min_start_date));

3491: hr_utility.trace(l_proc||': p_assactid='|| p_assactid);
3492: hr_utility.trace(l_proc||': vehicle_allocation_id='|| alc_rec.vehicle_allocation_id);
3493: hr_utility.trace(l_proc||': vehicle_repository_id='|| alc_rec.vehicle_repository_id);
3494: hr_utility.trace(l_proc||': l_action_flag='|| l_action_flag);
3495: hr_utility.trace(l_proc||': alc_dates_rec.min_start_date='|| fnd_date.date_to_displaydate(alc_dates_rec.min_start_date));
3496: hr_utility.trace(l_proc||': alc_dates_rec.max_end_date='|| fnd_date.date_to_displaydate(alc_dates_rec.max_end_date));
3497: --
3498: archive_allocation_action(p_assignment_id => asg_rec.assignment_id,
3499: p_asg_act_id => p_assactid,

Line 3496: hr_utility.trace(l_proc||': alc_dates_rec.max_end_date='|| fnd_date.date_to_displaydate(alc_dates_rec.max_end_date));

3492: hr_utility.trace(l_proc||': vehicle_allocation_id='|| alc_rec.vehicle_allocation_id);
3493: hr_utility.trace(l_proc||': vehicle_repository_id='|| alc_rec.vehicle_repository_id);
3494: hr_utility.trace(l_proc||': l_action_flag='|| l_action_flag);
3495: hr_utility.trace(l_proc||': alc_dates_rec.min_start_date='|| fnd_date.date_to_displaydate(alc_dates_rec.min_start_date));
3496: hr_utility.trace(l_proc||': alc_dates_rec.max_end_date='|| fnd_date.date_to_displaydate(alc_dates_rec.max_end_date));
3497: --
3498: archive_allocation_action(p_assignment_id => asg_rec.assignment_id,
3499: p_asg_act_id => p_assactid,
3500: p_vehicle_allocation_id => alc_rec.vehicle_allocation_id,

Line 3596: hr_utility.trace(l_proc||': alc_dates_rec.min_start_date='|| fnd_date.date_to_displaydate(alc_dates_rec.min_start_date));

3592: hr_utility.trace(l_proc||': p_assactid='|| p_assactid);
3593: hr_utility.trace(l_proc||': vehicle_allocation_id='|| alc_rec.vehicle_allocation_id);
3594: hr_utility.trace(l_proc||': vehicle_repository_id='|| alc_rec.vehicle_repository_id);
3595: hr_utility.trace(l_proc||': l_action_flag='|| l_action_flag);
3596: hr_utility.trace(l_proc||': alc_dates_rec.min_start_date='|| fnd_date.date_to_displaydate(alc_dates_rec.min_start_date));
3597: hr_utility.trace(l_proc||': alc_dates_rec.max_end_date='|| fnd_date.date_to_displaydate(alc_dates_rec.max_end_date));
3598: --
3599: archive_allocation_action(p_assignment_id => asg_rec.assignment_id,
3600: p_asg_act_id => p_assactid,

Line 3597: hr_utility.trace(l_proc||': alc_dates_rec.max_end_date='|| fnd_date.date_to_displaydate(alc_dates_rec.max_end_date));

3593: hr_utility.trace(l_proc||': vehicle_allocation_id='|| alc_rec.vehicle_allocation_id);
3594: hr_utility.trace(l_proc||': vehicle_repository_id='|| alc_rec.vehicle_repository_id);
3595: hr_utility.trace(l_proc||': l_action_flag='|| l_action_flag);
3596: hr_utility.trace(l_proc||': alc_dates_rec.min_start_date='|| fnd_date.date_to_displaydate(alc_dates_rec.min_start_date));
3597: hr_utility.trace(l_proc||': alc_dates_rec.max_end_date='|| fnd_date.date_to_displaydate(alc_dates_rec.max_end_date));
3598: --
3599: archive_allocation_action(p_assignment_id => asg_rec.assignment_id,
3600: p_asg_act_id => p_assactid,
3601: p_vehicle_allocation_id => alc_rec.vehicle_allocation_id,

Line 3823: hr_utility.trace(l_proc||': asg_min_start_date='||fnd_date.date_to_displaydate(asg_rec.asg_min_start_date));

3819: LOOP
3820: -- Loop through all assignments
3821: hr_utility.set_location(l_proc, 20);
3822: hr_utility.trace(l_proc||': assignment_id='||asg_rec.assignment_id);
3823: hr_utility.trace(l_proc||': asg_min_start_date='||fnd_date.date_to_displaydate(asg_rec.asg_min_start_date));
3824: hr_utility.trace(l_proc||': asg_max_end_date='||fnd_date.date_to_displaydate(asg_rec.asg_max_end_date));
3825: --
3826: FOR alc_rec IN c_allocations(asg_rec.assignment_id) LOOP
3827: -- Loop through all vehicle allocations

Line 3824: hr_utility.trace(l_proc||': asg_max_end_date='||fnd_date.date_to_displaydate(asg_rec.asg_max_end_date));

3820: -- Loop through all assignments
3821: hr_utility.set_location(l_proc, 20);
3822: hr_utility.trace(l_proc||': assignment_id='||asg_rec.assignment_id);
3823: hr_utility.trace(l_proc||': asg_min_start_date='||fnd_date.date_to_displaydate(asg_rec.asg_min_start_date));
3824: hr_utility.trace(l_proc||': asg_max_end_date='||fnd_date.date_to_displaydate(asg_rec.asg_max_end_date));
3825: --
3826: FOR alc_rec IN c_allocations(asg_rec.assignment_id) LOOP
3827: -- Loop through all vehicle allocations
3828: -- over the date range

Line 3841: hr_utility.trace(l_proc||': min_start_date='|| fnd_date.date_to_displaydate(alc_dates_rec.min_start_date));

3837: FETCH c_alloc_dates INTO alc_dates_rec;
3838: CLOSE c_alloc_dates;
3839: --
3840: hr_utility.set_location(l_proc, 40);
3841: hr_utility.trace(l_proc||': min_start_date='|| fnd_date.date_to_displaydate(alc_dates_rec.min_start_date));
3842: hr_utility.trace(l_proc||': max_end_date='|| fnd_date.date_to_displaydate(alc_dates_rec.max_end_date));
3843:
3844: -- Moved the code here from below for the bug 10088866
3845: -- Start moving for the bug 10088866

Line 3842: hr_utility.trace(l_proc||': max_end_date='|| fnd_date.date_to_displaydate(alc_dates_rec.max_end_date));

3838: CLOSE c_alloc_dates;
3839: --
3840: hr_utility.set_location(l_proc, 40);
3841: hr_utility.trace(l_proc||': min_start_date='|| fnd_date.date_to_displaydate(alc_dates_rec.min_start_date));
3842: hr_utility.trace(l_proc||': max_end_date='|| fnd_date.date_to_displaydate(alc_dates_rec.max_end_date));
3843:
3844: -- Moved the code here from below for the bug 10088866
3845: -- Start moving for the bug 10088866
3846: -- Private flag logic

Line 3990: hr_utility.trace(l_proc||': alc_dates_rec.min_start_date='|| fnd_date.date_to_displaydate(alc_dates_rec.min_start_date));

3986: hr_utility.trace(l_proc||': p_assactid='|| p_assactid);
3987: hr_utility.trace(l_proc||': vehicle_allocation_id='|| alc_rec.vehicle_allocation_id);
3988: hr_utility.trace(l_proc||': vehicle_repository_id='|| alc_rec.vehicle_repository_id);
3989: hr_utility.trace(l_proc||': l_action_flag='|| l_action_flag);
3990: hr_utility.trace(l_proc||': alc_dates_rec.min_start_date='|| fnd_date.date_to_displaydate(alc_dates_rec.min_start_date));
3991: hr_utility.trace(l_proc||': alc_dates_rec.max_end_date='|| fnd_date.date_to_displaydate(alc_dates_rec.max_end_date));
3992: --
3993: archive_allocation_action(p_assignment_id => asg_rec.assignment_id,
3994: p_asg_act_id => p_assactid,

Line 3991: hr_utility.trace(l_proc||': alc_dates_rec.max_end_date='|| fnd_date.date_to_displaydate(alc_dates_rec.max_end_date));

3987: hr_utility.trace(l_proc||': vehicle_allocation_id='|| alc_rec.vehicle_allocation_id);
3988: hr_utility.trace(l_proc||': vehicle_repository_id='|| alc_rec.vehicle_repository_id);
3989: hr_utility.trace(l_proc||': l_action_flag='|| l_action_flag);
3990: hr_utility.trace(l_proc||': alc_dates_rec.min_start_date='|| fnd_date.date_to_displaydate(alc_dates_rec.min_start_date));
3991: hr_utility.trace(l_proc||': alc_dates_rec.max_end_date='|| fnd_date.date_to_displaydate(alc_dates_rec.max_end_date));
3992: --
3993: archive_allocation_action(p_assignment_id => asg_rec.assignment_id,
3994: p_asg_act_id => p_assactid,
3995: p_vehicle_allocation_id => alc_rec.vehicle_allocation_id,

Line 4092: hr_utility.trace(l_proc||': alc_dates_rec.min_start_date='|| fnd_date.date_to_displaydate(alc_dates_rec.min_start_date));

4088: hr_utility.trace(l_proc||': p_assactid='|| p_assactid);
4089: hr_utility.trace(l_proc||': vehicle_allocation_id='|| alc_rec.vehicle_allocation_id);
4090: hr_utility.trace(l_proc||': vehicle_repository_id='|| alc_rec.vehicle_repository_id);
4091: hr_utility.trace(l_proc||': l_action_flag='|| l_action_flag);
4092: hr_utility.trace(l_proc||': alc_dates_rec.min_start_date='|| fnd_date.date_to_displaydate(alc_dates_rec.min_start_date));
4093: hr_utility.trace(l_proc||': alc_dates_rec.max_end_date='|| fnd_date.date_to_displaydate(alc_dates_rec.max_end_date));
4094: --
4095: archive_allocation_action(p_assignment_id => asg_rec.assignment_id,
4096: p_asg_act_id => p_assactid,

Line 4093: hr_utility.trace(l_proc||': alc_dates_rec.max_end_date='|| fnd_date.date_to_displaydate(alc_dates_rec.max_end_date));

4089: hr_utility.trace(l_proc||': vehicle_allocation_id='|| alc_rec.vehicle_allocation_id);
4090: hr_utility.trace(l_proc||': vehicle_repository_id='|| alc_rec.vehicle_repository_id);
4091: hr_utility.trace(l_proc||': l_action_flag='|| l_action_flag);
4092: hr_utility.trace(l_proc||': alc_dates_rec.min_start_date='|| fnd_date.date_to_displaydate(alc_dates_rec.min_start_date));
4093: hr_utility.trace(l_proc||': alc_dates_rec.max_end_date='|| fnd_date.date_to_displaydate(alc_dates_rec.max_end_date));
4094: --
4095: archive_allocation_action(p_assignment_id => asg_rec.assignment_id,
4096: p_asg_act_id => p_assactid,
4097: p_vehicle_allocation_id => alc_rec.vehicle_allocation_id,

Line 4322: hr_utility.trace(l_proc||': asg_min_start_date='||fnd_date.date_to_displaydate(asg_rec.asg_min_start_date));

4318: LOOP
4319: -- Loop through all assignments
4320: hr_utility.set_location(l_proc, 20);
4321: hr_utility.trace(l_proc||': assignment_id='||asg_rec.assignment_id);
4322: hr_utility.trace(l_proc||': asg_min_start_date='||fnd_date.date_to_displaydate(asg_rec.asg_min_start_date));
4323: hr_utility.trace(l_proc||': asg_max_end_date='||fnd_date.date_to_displaydate(asg_rec.asg_max_end_date));
4324: --
4325: FOR alc_rec IN c_allocations(asg_rec.assignment_id) LOOP
4326: -- Loop through all vehicle allocations

Line 4323: hr_utility.trace(l_proc||': asg_max_end_date='||fnd_date.date_to_displaydate(asg_rec.asg_max_end_date));

4319: -- Loop through all assignments
4320: hr_utility.set_location(l_proc, 20);
4321: hr_utility.trace(l_proc||': assignment_id='||asg_rec.assignment_id);
4322: hr_utility.trace(l_proc||': asg_min_start_date='||fnd_date.date_to_displaydate(asg_rec.asg_min_start_date));
4323: hr_utility.trace(l_proc||': asg_max_end_date='||fnd_date.date_to_displaydate(asg_rec.asg_max_end_date));
4324: --
4325: FOR alc_rec IN c_allocations(asg_rec.assignment_id) LOOP
4326: -- Loop through all vehicle allocations
4327: -- over the date range

Line 4340: hr_utility.trace(l_proc||': min_start_date='|| fnd_date.date_to_displaydate(alc_dates_rec.min_start_date));

4336: FETCH c_alloc_dates INTO alc_dates_rec;
4337: CLOSE c_alloc_dates;
4338: --
4339: hr_utility.set_location(l_proc, 40);
4340: hr_utility.trace(l_proc||': min_start_date='|| fnd_date.date_to_displaydate(alc_dates_rec.min_start_date));
4341: hr_utility.trace(l_proc||': max_end_date='|| fnd_date.date_to_displaydate(alc_dates_rec.max_end_date));
4342:
4343: -- Moved the code here from below for the bug 10088866
4344: -- Start moving for the bug 10088866

Line 4341: hr_utility.trace(l_proc||': max_end_date='|| fnd_date.date_to_displaydate(alc_dates_rec.max_end_date));

4337: CLOSE c_alloc_dates;
4338: --
4339: hr_utility.set_location(l_proc, 40);
4340: hr_utility.trace(l_proc||': min_start_date='|| fnd_date.date_to_displaydate(alc_dates_rec.min_start_date));
4341: hr_utility.trace(l_proc||': max_end_date='|| fnd_date.date_to_displaydate(alc_dates_rec.max_end_date));
4342:
4343: -- Moved the code here from below for the bug 10088866
4344: -- Start moving for the bug 10088866
4345: -- Private flag logic

Line 4490: hr_utility.trace(l_proc||': alc_dates_rec.min_start_date='|| fnd_date.date_to_displaydate(alc_dates_rec.min_start_date));

4486: hr_utility.trace(l_proc||': p_assactid='|| p_assactid);
4487: hr_utility.trace(l_proc||': vehicle_allocation_id='|| alc_rec.vehicle_allocation_id);
4488: hr_utility.trace(l_proc||': vehicle_repository_id='|| alc_rec.vehicle_repository_id);
4489: hr_utility.trace(l_proc||': l_action_flag='|| l_action_flag);
4490: hr_utility.trace(l_proc||': alc_dates_rec.min_start_date='|| fnd_date.date_to_displaydate(alc_dates_rec.min_start_date));
4491: hr_utility.trace(l_proc||': alc_dates_rec.max_end_date='|| fnd_date.date_to_displaydate(alc_dates_rec.max_end_date));
4492: --
4493: archive_allocation_action(p_assignment_id => asg_rec.assignment_id,
4494: p_asg_act_id => p_assactid,

Line 4491: hr_utility.trace(l_proc||': alc_dates_rec.max_end_date='|| fnd_date.date_to_displaydate(alc_dates_rec.max_end_date));

4487: hr_utility.trace(l_proc||': vehicle_allocation_id='|| alc_rec.vehicle_allocation_id);
4488: hr_utility.trace(l_proc||': vehicle_repository_id='|| alc_rec.vehicle_repository_id);
4489: hr_utility.trace(l_proc||': l_action_flag='|| l_action_flag);
4490: hr_utility.trace(l_proc||': alc_dates_rec.min_start_date='|| fnd_date.date_to_displaydate(alc_dates_rec.min_start_date));
4491: hr_utility.trace(l_proc||': alc_dates_rec.max_end_date='|| fnd_date.date_to_displaydate(alc_dates_rec.max_end_date));
4492: --
4493: archive_allocation_action(p_assignment_id => asg_rec.assignment_id,
4494: p_asg_act_id => p_assactid,
4495: p_vehicle_allocation_id => alc_rec.vehicle_allocation_id,

Line 4593: hr_utility.trace(l_proc||': alc_dates_rec.min_start_date='|| fnd_date.date_to_displaydate(alc_dates_rec.min_start_date));

4589: hr_utility.trace(l_proc||': p_assactid='|| p_assactid);
4590: hr_utility.trace(l_proc||': vehicle_allocation_id='|| alc_rec.vehicle_allocation_id);
4591: hr_utility.trace(l_proc||': vehicle_repository_id='|| alc_rec.vehicle_repository_id);
4592: hr_utility.trace(l_proc||': l_action_flag='|| l_action_flag);
4593: hr_utility.trace(l_proc||': alc_dates_rec.min_start_date='|| fnd_date.date_to_displaydate(alc_dates_rec.min_start_date));
4594: hr_utility.trace(l_proc||': alc_dates_rec.max_end_date='|| fnd_date.date_to_displaydate(alc_dates_rec.max_end_date));
4595: --
4596: archive_allocation_action(p_assignment_id => asg_rec.assignment_id,
4597: p_asg_act_id => p_assactid,

Line 4594: hr_utility.trace(l_proc||': alc_dates_rec.max_end_date='|| fnd_date.date_to_displaydate(alc_dates_rec.max_end_date));

4590: hr_utility.trace(l_proc||': vehicle_allocation_id='|| alc_rec.vehicle_allocation_id);
4591: hr_utility.trace(l_proc||': vehicle_repository_id='|| alc_rec.vehicle_repository_id);
4592: hr_utility.trace(l_proc||': l_action_flag='|| l_action_flag);
4593: hr_utility.trace(l_proc||': alc_dates_rec.min_start_date='|| fnd_date.date_to_displaydate(alc_dates_rec.min_start_date));
4594: hr_utility.trace(l_proc||': alc_dates_rec.max_end_date='|| fnd_date.date_to_displaydate(alc_dates_rec.max_end_date));
4595: --
4596: archive_allocation_action(p_assignment_id => asg_rec.assignment_id,
4597: p_asg_act_id => p_assactid,
4598: p_vehicle_allocation_id => alc_rec.vehicle_allocation_id,

Line 4829: hr_utility.trace(l_proc||': asg_min_start_date='||fnd_date.date_to_displaydate(asg_rec.asg_min_start_date));

4825: LOOP
4826: -- Loop through all assignments
4827: hr_utility.set_location(l_proc, 20);
4828: hr_utility.trace(l_proc||': assignment_id='||asg_rec.assignment_id);
4829: hr_utility.trace(l_proc||': asg_min_start_date='||fnd_date.date_to_displaydate(asg_rec.asg_min_start_date));
4830: hr_utility.trace(l_proc||': asg_max_end_date='||fnd_date.date_to_displaydate(asg_rec.asg_max_end_date));
4831: --
4832: FOR alc_rec IN c_allocations(asg_rec.assignment_id) LOOP
4833: -- Loop through all vehicle allocations

Line 4830: hr_utility.trace(l_proc||': asg_max_end_date='||fnd_date.date_to_displaydate(asg_rec.asg_max_end_date));

4826: -- Loop through all assignments
4827: hr_utility.set_location(l_proc, 20);
4828: hr_utility.trace(l_proc||': assignment_id='||asg_rec.assignment_id);
4829: hr_utility.trace(l_proc||': asg_min_start_date='||fnd_date.date_to_displaydate(asg_rec.asg_min_start_date));
4830: hr_utility.trace(l_proc||': asg_max_end_date='||fnd_date.date_to_displaydate(asg_rec.asg_max_end_date));
4831: --
4832: FOR alc_rec IN c_allocations(asg_rec.assignment_id) LOOP
4833: -- Loop through all vehicle allocations
4834: -- over the date range

Line 4847: hr_utility.trace(l_proc||': min_start_date='|| fnd_date.date_to_displaydate(alc_dates_rec.min_start_date));

4843: FETCH c_alloc_dates INTO alc_dates_rec;
4844: CLOSE c_alloc_dates;
4845: --
4846: hr_utility.set_location(l_proc, 40);
4847: hr_utility.trace(l_proc||': min_start_date='|| fnd_date.date_to_displaydate(alc_dates_rec.min_start_date));
4848: hr_utility.trace(l_proc||': max_end_date='|| fnd_date.date_to_displaydate(alc_dates_rec.max_end_date));
4849:
4850: -- Moved the code here from below for the bug 10088866
4851: -- Start moving for the bug 10088866

Line 4848: hr_utility.trace(l_proc||': max_end_date='|| fnd_date.date_to_displaydate(alc_dates_rec.max_end_date));

4844: CLOSE c_alloc_dates;
4845: --
4846: hr_utility.set_location(l_proc, 40);
4847: hr_utility.trace(l_proc||': min_start_date='|| fnd_date.date_to_displaydate(alc_dates_rec.min_start_date));
4848: hr_utility.trace(l_proc||': max_end_date='|| fnd_date.date_to_displaydate(alc_dates_rec.max_end_date));
4849:
4850: -- Moved the code here from below for the bug 10088866
4851: -- Start moving for the bug 10088866
4852: -- Private flag logic

Line 4997: hr_utility.trace(l_proc||': alc_dates_rec.min_start_date='|| fnd_date.date_to_displaydate(alc_dates_rec.min_start_date));

4993: hr_utility.trace(l_proc||': p_assactid='|| p_assactid);
4994: hr_utility.trace(l_proc||': vehicle_allocation_id='|| alc_rec.vehicle_allocation_id);
4995: hr_utility.trace(l_proc||': vehicle_repository_id='|| alc_rec.vehicle_repository_id);
4996: hr_utility.trace(l_proc||': l_action_flag='|| l_action_flag);
4997: hr_utility.trace(l_proc||': alc_dates_rec.min_start_date='|| fnd_date.date_to_displaydate(alc_dates_rec.min_start_date));
4998: hr_utility.trace(l_proc||': alc_dates_rec.max_end_date='|| fnd_date.date_to_displaydate(alc_dates_rec.max_end_date));
4999: --
5000: archive_allocation_action(p_assignment_id => asg_rec.assignment_id,
5001: p_asg_act_id => p_assactid,

Line 4998: hr_utility.trace(l_proc||': alc_dates_rec.max_end_date='|| fnd_date.date_to_displaydate(alc_dates_rec.max_end_date));

4994: hr_utility.trace(l_proc||': vehicle_allocation_id='|| alc_rec.vehicle_allocation_id);
4995: hr_utility.trace(l_proc||': vehicle_repository_id='|| alc_rec.vehicle_repository_id);
4996: hr_utility.trace(l_proc||': l_action_flag='|| l_action_flag);
4997: hr_utility.trace(l_proc||': alc_dates_rec.min_start_date='|| fnd_date.date_to_displaydate(alc_dates_rec.min_start_date));
4998: hr_utility.trace(l_proc||': alc_dates_rec.max_end_date='|| fnd_date.date_to_displaydate(alc_dates_rec.max_end_date));
4999: --
5000: archive_allocation_action(p_assignment_id => asg_rec.assignment_id,
5001: p_asg_act_id => p_assactid,
5002: p_vehicle_allocation_id => alc_rec.vehicle_allocation_id,

Line 5100: hr_utility.trace(l_proc||': alc_dates_rec.min_start_date='|| fnd_date.date_to_displaydate(alc_dates_rec.min_start_date));

5096: hr_utility.trace(l_proc||': p_assactid='|| p_assactid);
5097: hr_utility.trace(l_proc||': vehicle_allocation_id='|| alc_rec.vehicle_allocation_id);
5098: hr_utility.trace(l_proc||': vehicle_repository_id='|| alc_rec.vehicle_repository_id);
5099: hr_utility.trace(l_proc||': l_action_flag='|| l_action_flag);
5100: hr_utility.trace(l_proc||': alc_dates_rec.min_start_date='|| fnd_date.date_to_displaydate(alc_dates_rec.min_start_date));
5101: hr_utility.trace(l_proc||': alc_dates_rec.max_end_date='|| fnd_date.date_to_displaydate(alc_dates_rec.max_end_date));
5102: --
5103: archive_allocation_action(p_assignment_id => asg_rec.assignment_id,
5104: p_asg_act_id => p_assactid,

Line 5101: hr_utility.trace(l_proc||': alc_dates_rec.max_end_date='|| fnd_date.date_to_displaydate(alc_dates_rec.max_end_date));

5097: hr_utility.trace(l_proc||': vehicle_allocation_id='|| alc_rec.vehicle_allocation_id);
5098: hr_utility.trace(l_proc||': vehicle_repository_id='|| alc_rec.vehicle_repository_id);
5099: hr_utility.trace(l_proc||': l_action_flag='|| l_action_flag);
5100: hr_utility.trace(l_proc||': alc_dates_rec.min_start_date='|| fnd_date.date_to_displaydate(alc_dates_rec.min_start_date));
5101: hr_utility.trace(l_proc||': alc_dates_rec.max_end_date='|| fnd_date.date_to_displaydate(alc_dates_rec.max_end_date));
5102: --
5103: archive_allocation_action(p_assignment_id => asg_rec.assignment_id,
5104: p_asg_act_id => p_assactid,
5105: p_vehicle_allocation_id => alc_rec.vehicle_allocation_id,