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 249: AND fnd_date.date_to_canonical(p_allocation_start_date) = pai.action_information3;

245: AND 'AAP' = pai.action_context_type
246: AND 'GB P46 CAR EDI ALLOCATION' = pai.action_information_category
247: AND p_action_flag = pai.action_information1
248: AND to_char(p_vehicle_allocation_id) = pai.action_information2
249: AND fnd_date.date_to_canonical(p_allocation_start_date) = pai.action_information3;
250: --
251: chk_archive_rec c_chk_archive%ROWTYPE;
252: --
253: l_archived_flag VARCHAR2(1) := 'Y';

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

255: BEGIN
256: hr_utility.set_location(l_proc, 10);
257: hr_utility.trace(l_proc||': p_assignment_id='|| p_assignment_id);
258: hr_utility.trace(l_proc||': p_vehicle_allocation_id='|| p_vehicle_allocation_id);
259: hr_utility.trace(l_proc||': p_allocation_start_date='|| fnd_date.date_to_displaydate(p_allocation_start_date));
260: hr_utility.trace(l_proc||': p_action_flag='|| p_action_flag);
261: --
262: OPEN c_chk_archive;
263: FETCH c_chk_archive INTO chk_archive_rec;

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

298: AND 'AAP' = pai.action_context_type
299: AND 'GB P46 CAR EDI ALLOCATION' = pai.action_information_category
300: AND p_action_flag = pai.action_information1
301: AND to_char(p_vehicle_allocation_id) = pai.action_information2
302: AND fnd_date.date_to_canonical(p_allocation_start_date) = pai.action_information3;
303: --
304: chk_archive_rec c_chk_archive%ROWTYPE;
305: --
306: l_archived_flag VARCHAR2(1) := 'Y';

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

308: BEGIN
309: hr_utility.set_location(l_proc, 10);
310: hr_utility.trace(l_proc||': p_assignment_id='|| p_assignment_id);
311: hr_utility.trace(l_proc||': p_vehicle_allocation_id='|| p_vehicle_allocation_id);
312: hr_utility.trace(l_proc||': p_allocation_start_date='|| fnd_date.date_to_displaydate(p_allocation_start_date));
313: hr_utility.trace(l_proc||': p_action_flag='|| p_action_flag);
314: --
315: OPEN c_chk_archive;
316: FETCH c_chk_archive INTO chk_archive_rec;

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

379: hr_utility.trace(l_proc||': employer_name='||employer_rec.employer_name);
380: hr_utility.trace(l_proc||': employer_address_line='||employer_rec.employer_address_line);
381: hr_utility.trace(l_proc||': tax_district_name='||employer_rec.tax_district_name);
382: hr_utility.trace(l_proc||': organization_id='||employer_rec.organization_id);
383: hr_utility.trace(l_proc||': effective_Date='||fnd_date.date_to_displaydate(employer_rec.effective_date));
384: --
385: pay_action_information_api.create_action_information (
386: p_action_information_id => l_action_info_id
387: , p_action_context_id => pactid

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

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

Line 542: fnd_date.canonical_to_date(

538: legislative_parameters,
539: 'TAX_REF'),1,20) tax_ref,
540: start_date,
541: effective_date,
542: fnd_date.canonical_to_date(
543: pay_gb_eoy_archive.get_parameter(
544: legislative_parameters,
545: 'END_DATE')) end_date,
546: business_group_id

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

598: --
599: hr_utility.set_location(l_proc, 15);
600: hr_utility.trace(l_proc||': g_payroll_id='||g_payroll_id);
601: hr_utility.trace(l_proc||': g_tax_ref='||g_tax_ref);
602: hr_utility.trace(l_proc||': g_start_date='||fnd_date.date_to_displaydate(g_start_date));
603: hr_utility.trace(l_proc||': g_effective_date='||fnd_date.date_to_displaydate(g_effective_date));
604: hr_utility.trace(l_proc||': g_end_date='||fnd_date.date_to_displaydate(g_end_date));
605: hr_utility.trace(l_proc||': g_business_group_id='||g_business_group_id);
606: For asg_rec IN c_asg

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

599: hr_utility.set_location(l_proc, 15);
600: hr_utility.trace(l_proc||': g_payroll_id='||g_payroll_id);
601: hr_utility.trace(l_proc||': g_tax_ref='||g_tax_ref);
602: hr_utility.trace(l_proc||': g_start_date='||fnd_date.date_to_displaydate(g_start_date));
603: hr_utility.trace(l_proc||': g_effective_date='||fnd_date.date_to_displaydate(g_effective_date));
604: hr_utility.trace(l_proc||': g_end_date='||fnd_date.date_to_displaydate(g_end_date));
605: hr_utility.trace(l_proc||': g_business_group_id='||g_business_group_id);
606: For asg_rec IN c_asg
607: LOOP

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

600: hr_utility.trace(l_proc||': g_payroll_id='||g_payroll_id);
601: hr_utility.trace(l_proc||': g_tax_ref='||g_tax_ref);
602: hr_utility.trace(l_proc||': g_start_date='||fnd_date.date_to_displaydate(g_start_date));
603: hr_utility.trace(l_proc||': g_effective_date='||fnd_date.date_to_displaydate(g_effective_date));
604: hr_utility.trace(l_proc||': g_end_date='||fnd_date.date_to_displaydate(g_end_date));
605: hr_utility.trace(l_proc||': g_business_group_id='||g_business_group_id);
606: For asg_rec IN c_asg
607: LOOP
608: -- Loop through all assignments

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

607: LOOP
608: -- Loop through all assignments
609: hr_utility.set_location(l_proc, 20);
610: hr_utility.trace(l_proc||': assignment_id='||asg_rec.assignment_id);
611: hr_utility.trace(l_proc||': asg_min_start_date='||fnd_date.date_to_displaydate(asg_rec.asg_min_start_date));
612: hr_utility.trace(l_proc||': asg_max_end_date='||fnd_date.date_to_displaydate(asg_rec.asg_max_end_date));
613: --
614: l_create_assact_flag := 'N';
615: --

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

608: -- Loop through all assignments
609: hr_utility.set_location(l_proc, 20);
610: hr_utility.trace(l_proc||': assignment_id='||asg_rec.assignment_id);
611: hr_utility.trace(l_proc||': asg_min_start_date='||fnd_date.date_to_displaydate(asg_rec.asg_min_start_date));
612: hr_utility.trace(l_proc||': asg_max_end_date='||fnd_date.date_to_displaydate(asg_rec.asg_max_end_date));
613: --
614: l_create_assact_flag := 'N';
615: --
616: FOR alc_rec IN c_allocations(asg_rec.assignment_id) LOOP

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

627: FETCH c_alloc_dates INTO alc_dates_rec;
628: CLOSE c_alloc_dates;
629: --
630: hr_utility.set_location(l_proc, 40);
631: hr_utility.trace(l_proc||': min_start_date='|| fnd_date.date_to_displaydate(alc_dates_rec.min_start_date));
632: hr_utility.trace(l_proc||': max_end_date='|| fnd_date.date_to_displaydate(alc_dates_rec.max_end_date));
633: --
634: -- Check whether vehicle was allocated or
635: -- Withdrawn within the date range also

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

628: CLOSE c_alloc_dates;
629: --
630: hr_utility.set_location(l_proc, 40);
631: hr_utility.trace(l_proc||': min_start_date='|| fnd_date.date_to_displaydate(alc_dates_rec.min_start_date));
632: hr_utility.trace(l_proc||': max_end_date='|| fnd_date.date_to_displaydate(alc_dates_rec.max_end_date));
633: --
634: -- Check whether vehicle was allocated or
635: -- Withdrawn within the date range also
636: -- check that this allocation or withdrawal

Line 1007: fnd_date.canonical_to_date(

1003: legislative_parameters,
1004: 'TAX_REF'),1,20) tax_ref,
1005: start_date,
1006: effective_date,
1007: fnd_date.canonical_to_date(
1008: pay_gb_eoy_archive.get_parameter(
1009: legislative_parameters,
1010: 'END_DATE')) end_date,
1011: business_group_id

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

1063: --
1064: hr_utility.set_location(l_proc, 15);
1065: hr_utility.trace(l_proc||': g_payroll_id='||g_payroll_id);
1066: hr_utility.trace(l_proc||': g_tax_ref='||g_tax_ref);
1067: hr_utility.trace(l_proc||': g_start_date='||fnd_date.date_to_displaydate(g_start_date));
1068: hr_utility.trace(l_proc||': g_effective_date='||fnd_date.date_to_displaydate(g_effective_date));
1069: hr_utility.trace(l_proc||': g_end_date='||fnd_date.date_to_displaydate(g_end_date));
1070: hr_utility.trace(l_proc||': g_business_group_id='||g_business_group_id);
1071: For asg_rec IN c_asg

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

1064: hr_utility.set_location(l_proc, 15);
1065: hr_utility.trace(l_proc||': g_payroll_id='||g_payroll_id);
1066: hr_utility.trace(l_proc||': g_tax_ref='||g_tax_ref);
1067: hr_utility.trace(l_proc||': g_start_date='||fnd_date.date_to_displaydate(g_start_date));
1068: hr_utility.trace(l_proc||': g_effective_date='||fnd_date.date_to_displaydate(g_effective_date));
1069: hr_utility.trace(l_proc||': g_end_date='||fnd_date.date_to_displaydate(g_end_date));
1070: hr_utility.trace(l_proc||': g_business_group_id='||g_business_group_id);
1071: For asg_rec IN c_asg
1072: LOOP

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

1065: hr_utility.trace(l_proc||': g_payroll_id='||g_payroll_id);
1066: hr_utility.trace(l_proc||': g_tax_ref='||g_tax_ref);
1067: hr_utility.trace(l_proc||': g_start_date='||fnd_date.date_to_displaydate(g_start_date));
1068: hr_utility.trace(l_proc||': g_effective_date='||fnd_date.date_to_displaydate(g_effective_date));
1069: hr_utility.trace(l_proc||': g_end_date='||fnd_date.date_to_displaydate(g_end_date));
1070: hr_utility.trace(l_proc||': g_business_group_id='||g_business_group_id);
1071: For asg_rec IN c_asg
1072: LOOP
1073: -- Loop through all assignments

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

1072: LOOP
1073: -- Loop through all assignments
1074: hr_utility.set_location(l_proc, 20);
1075: hr_utility.trace(l_proc||': assignment_id='||asg_rec.assignment_id);
1076: hr_utility.trace(l_proc||': asg_min_start_date='||fnd_date.date_to_displaydate(asg_rec.asg_min_start_date));
1077: hr_utility.trace(l_proc||': asg_max_end_date='||fnd_date.date_to_displaydate(asg_rec.asg_max_end_date));
1078: --
1079: l_create_assact_flag := 'N';
1080: --

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

1073: -- Loop through all assignments
1074: hr_utility.set_location(l_proc, 20);
1075: hr_utility.trace(l_proc||': assignment_id='||asg_rec.assignment_id);
1076: hr_utility.trace(l_proc||': asg_min_start_date='||fnd_date.date_to_displaydate(asg_rec.asg_min_start_date));
1077: hr_utility.trace(l_proc||': asg_max_end_date='||fnd_date.date_to_displaydate(asg_rec.asg_max_end_date));
1078: --
1079: l_create_assact_flag := 'N';
1080: --
1081: FOR alc_rec IN c_allocations(asg_rec.assignment_id) LOOP

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

1092: FETCH c_alloc_dates INTO alc_dates_rec;
1093: CLOSE c_alloc_dates;
1094: --
1095: hr_utility.set_location(l_proc, 40);
1096: hr_utility.trace(l_proc||': min_start_date='|| fnd_date.date_to_displaydate(alc_dates_rec.min_start_date));
1097: hr_utility.trace(l_proc||': max_end_date='|| fnd_date.date_to_displaydate(alc_dates_rec.max_end_date));
1098: --
1099: -- Check whether vehicle was allocated or
1100: -- Withdrawn within the date range also

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

1093: CLOSE c_alloc_dates;
1094: --
1095: hr_utility.set_location(l_proc, 40);
1096: hr_utility.trace(l_proc||': min_start_date='|| fnd_date.date_to_displaydate(alc_dates_rec.min_start_date));
1097: hr_utility.trace(l_proc||': max_end_date='|| fnd_date.date_to_displaydate(alc_dates_rec.max_end_date));
1098: --
1099: -- Check whether vehicle was allocated or
1100: -- Withdrawn within the date range also
1101: -- check that this allocation or withdrawal

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

1494: FROM per_addresses addr
1495: WHERE addr.person_id = p_person_id
1496: AND addr.primary_flag = 'Y'
1497: AND l_eff_date BETWEEN addr.date_from
1498: AND nvl(addr.date_to, fnd_date.canonical_to_date('4712/12/31'));
1499: --
1500: addr_rec c_addr%ROWTYPE;
1501: --
1502: CURSOR c_alloc IS

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

1551: hr_utility.trace('p_asg_act_id='||p_asg_act_id);
1552: hr_utility.trace('p_vehicle_allocation_id='||p_vehicle_allocation_id);
1553: hr_utility.trace('p_vehicle_repository_id='||p_vehicle_repository_id);
1554: hr_utility.trace('p_action_flag='||p_action_flag);
1555: hr_utility.trace('p_fuel_type_change_date='||fnd_date.date_to_displaydate(p_fuel_type_change_date));
1556: hr_utility.trace('p_allocation_start_date='||fnd_date.date_to_displaydate(p_allocation_start_date));
1557: hr_utility.trace('p_allocation_end_date='||fnd_date.date_to_displaydate(p_allocation_end_date));
1558: -- Get data as of the action date within
1559: -- the date range, effective date is:

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

1552: hr_utility.trace('p_vehicle_allocation_id='||p_vehicle_allocation_id);
1553: hr_utility.trace('p_vehicle_repository_id='||p_vehicle_repository_id);
1554: hr_utility.trace('p_action_flag='||p_action_flag);
1555: hr_utility.trace('p_fuel_type_change_date='||fnd_date.date_to_displaydate(p_fuel_type_change_date));
1556: hr_utility.trace('p_allocation_start_date='||fnd_date.date_to_displaydate(p_allocation_start_date));
1557: hr_utility.trace('p_allocation_end_date='||fnd_date.date_to_displaydate(p_allocation_end_date));
1558: -- Get data as of the action date within
1559: -- the date range, effective date is:
1560: IF p_action_flag = 'F' THEN

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

1553: hr_utility.trace('p_vehicle_repository_id='||p_vehicle_repository_id);
1554: hr_utility.trace('p_action_flag='||p_action_flag);
1555: hr_utility.trace('p_fuel_type_change_date='||fnd_date.date_to_displaydate(p_fuel_type_change_date));
1556: hr_utility.trace('p_allocation_start_date='||fnd_date.date_to_displaydate(p_allocation_start_date));
1557: hr_utility.trace('p_allocation_end_date='||fnd_date.date_to_displaydate(p_allocation_end_date));
1558: -- Get data as of the action date within
1559: -- the date range, effective date is:
1560: IF p_action_flag = 'F' THEN
1561: -- Get data as of the fuel type change date

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

1565: ELSIF p_action_flag = 'W' THEN
1566: l_eff_date := p_allocation_end_date;
1567: END IF;
1568: hr_utility.set_location(l_proc, 20);
1569: hr_utility.trace('l_eff_date='||fnd_date.date_to_displaydate(l_eff_date));
1570: --
1571: -- Get person details
1572: OPEN c_person(p_assignment_id);
1573: FETCH c_person INTO person_rec;

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

1605: hr_utility.trace('ADDR1 : ' || addr_rec.address_line3);
1606: hr_utility.trace('City/Town : ' || addr_rec.town_or_city);
1607: hr_utility.trace('Regioin_1 : ' || addr_rec.region_1);
1608: hr_utility.trace('Postal : ' || addr_rec.postal_code);
1609: hr_utility.trace('DOB : ' || fnd_date.date_to_canonical(person_rec.date_of_birth)); --For Bug 6652235
1610: hr_utility.trace('Gender : ' || person_rec.sex); --For Bug 6652235
1611:
1612: pay_action_information_api.create_action_information (
1613: p_action_information_id => l_action_info_id

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

1629: , p_action_information8 => upper(addr_rec.address_line3)
1630: , p_action_information9 => upper(addr_rec.town_or_city)
1631: , p_action_information10 => upper(addr_rec.region_1)
1632: , p_action_information11 => upper(addr_rec.postal_code)
1633: , p_action_information12 => fnd_date.date_to_canonical(person_rec.date_of_birth) --For Bug 6652235
1634: , p_action_information13 => upper(person_rec.sex)); --For Bug 6652235
1635: --
1636: hr_utility.set_location(l_proc, 70);
1637: ---------------------------------------------

Line 1641: fnd_date.canonical_to_date(

1637: ---------------------------------------------
1638: -- Archive Vehicle Allocation Details --
1639: ---------------------------------------------
1640: IF g_effective_date <
1641: fnd_date.canonical_to_date(
1642: to_char(g_effective_date, 'YYYY')||'04/06') THEN
1643: -- Effective Date between 1st Jan
1644: -- to 5th Apr of the calendar year
1645: l_tax_year_start := fnd_date.canonical_to_date(

Line 1645: l_tax_year_start := fnd_date.canonical_to_date(

1641: fnd_date.canonical_to_date(
1642: to_char(g_effective_date, 'YYYY')||'04/06') THEN
1643: -- Effective Date between 1st Jan
1644: -- to 5th Apr of the calendar year
1645: l_tax_year_start := fnd_date.canonical_to_date(
1646: to_char(to_number(to_char(g_effective_date, 'YYYY')) -1)
1647: ||'04/06');
1648: ELSE
1649: -- Effective Date between 06th Apr

Line 1651: l_tax_year_start := fnd_date.canonical_to_date(

1647: ||'04/06');
1648: ELSE
1649: -- Effective Date between 06th Apr
1650: -- to 31st Dec of the calendar year
1651: l_tax_year_start := fnd_date.canonical_to_date(
1652: to_char(g_effective_date, 'YYYY')||'04/06');
1653: END IF;
1654: --
1655: hr_utility.set_location(l_proc, 80);

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

1656: --
1657: IF p_allocation_start_date >= l_tax_year_start THEN
1658: -- Car was first allocated in this tax year
1659: -- Archive Date Car First Available
1660: l_date_first_avail := fnd_date.date_to_canonical(p_allocation_start_date);
1661: ELSE
1662: l_date_first_avail := NULL;
1663: END IF;
1664: --

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

1714: , p_source_text => NULL
1715: , p_action_information_category => 'GB P46 CAR EDI ALLOCATION'
1716: , p_action_information1 => p_action_flag
1717: , p_action_information2 => p_vehicle_allocation_id
1718: , p_action_information3 => fnd_date.date_to_canonical(p_allocation_start_date)
1719: , p_action_information4 => fnd_date.date_to_canonical(p_allocation_end_date)
1720: , p_action_information5 => p_vehicle_repository_id
1721: , p_action_information6 => to_char(nvl(car_rec.list_price,0)*100)
1722: , p_action_information7 => to_char(nvl(car_rec.accessory_value_at_startdate,0)*100)

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

1715: , p_action_information_category => 'GB P46 CAR EDI ALLOCATION'
1716: , p_action_information1 => p_action_flag
1717: , p_action_information2 => p_vehicle_allocation_id
1718: , p_action_information3 => fnd_date.date_to_canonical(p_allocation_start_date)
1719: , p_action_information4 => fnd_date.date_to_canonical(p_allocation_end_date)
1720: , p_action_information5 => p_vehicle_repository_id
1721: , p_action_information6 => to_char(nvl(car_rec.list_price,0)*100)
1722: , p_action_information7 => to_char(nvl(car_rec.accessory_value_at_startdate,0)*100)
1723: , p_action_information8 => to_char(nvl(alloc_rec.capital_contribution,0)*100)

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

1724: , p_action_information9 => to_char(nvl(alloc_rec.private_contribution,0)*100)
1725: , p_action_information10 => car_rec.fuel_type
1726: , p_action_information11 => car_rec.fiscal_ratings
1727: , p_action_information12 => alloc_rec.fuel_benefit
1728: , p_action_information13 => fnd_date.date_to_canonical(car_rec.initial_registration)
1729: , p_action_information14 => l_date_first_avail
1730: , p_action_information15 => l_second_car_flag
1731: , p_action_information16 => upper(car_rec.make || ' ' || car_rec.model)
1732: , p_action_information17 => to_char(car_rec.engine_capacity_in_cc));

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

1746: , p_source_text => NULL
1747: , p_action_information_category => 'GB P46 CAR EDI ALLOCATION'
1748: , p_action_information1 => p_action_flag
1749: , p_action_information2 => p_vehicle_allocation_id
1750: , p_action_information3 => fnd_date.date_to_canonical(p_allocation_start_date)
1751: , p_action_information4 => fnd_date.date_to_canonical(p_allocation_end_date)
1752: , p_action_information5 => p_vehicle_repository_id
1753: , p_action_information6 => to_char(nvl(car_rec.list_price,0)*100)
1754: , p_action_information7 => to_char(nvl(car_rec.accessory_value_at_startdate,0)*100)

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

1747: , p_action_information_category => 'GB P46 CAR EDI ALLOCATION'
1748: , p_action_information1 => p_action_flag
1749: , p_action_information2 => p_vehicle_allocation_id
1750: , p_action_information3 => fnd_date.date_to_canonical(p_allocation_start_date)
1751: , p_action_information4 => fnd_date.date_to_canonical(p_allocation_end_date)
1752: , p_action_information5 => p_vehicle_repository_id
1753: , p_action_information6 => to_char(nvl(car_rec.list_price,0)*100)
1754: , p_action_information7 => to_char(nvl(car_rec.accessory_value_at_startdate,0)*100)
1755: , p_action_information8 => to_char(nvl(alloc_rec.capital_contribution,0)*100)

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

1756: , p_action_information9 => to_char(nvl(alloc_rec.private_contribution,0)*100)
1757: , p_action_information10 => car_rec.fuel_type
1758: , p_action_information11 => car_rec.fiscal_ratings
1759: , p_action_information12 => alloc_rec.fuel_benefit
1760: , p_action_information13 => fnd_date.date_to_canonical(car_rec.initial_registration)
1761: , p_action_information14 => l_date_first_avail
1762: , p_action_information15 => l_second_car_flag
1763: , p_action_information16 => upper(car_rec.make || ' ' || car_rec.model)
1764: , p_action_information17 => to_char(car_rec.engine_capacity_in_cc)

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

1764: , p_action_information17 => to_char(car_rec.engine_capacity_in_cc)
1765: , p_action_information18 => upper(ltrim(rtrim(prior_prim_car_rec.make)) || ' ' || ltrim(rtrim(prior_prim_car_rec.model)))
1766: , p_action_information19 => to_char(prior_prim_car_rec.engine_capacity_in_cc)
1767: , p_action_information20 => to_char(prior_prim_car_rec.vehicle_allocation_id)
1768: , p_action_information21 => fnd_date.date_to_canonical(prior_prim_car_rec.effective_end_date)
1769: );
1770: --
1771: hr_utility.set_location(l_proc, 160);
1772: ELSIF p_action_flag = 'W' THEN

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

1783: , p_source_text => NULL
1784: , p_action_information_category => 'GB P46 CAR EDI ALLOCATION'
1785: , p_action_information1 => p_action_flag
1786: , p_action_information2 => p_vehicle_allocation_id
1787: , p_action_information3 => fnd_date.date_to_canonical(p_allocation_start_date)
1788: , p_action_information4 => fnd_date.date_to_canonical(p_allocation_end_date)
1789: , p_action_information5 => p_vehicle_repository_id
1790: , p_action_information6 => to_char(nvl(car_rec.list_price,0)*100)
1791: , p_action_information7 => to_char(nvl(car_rec.accessory_value_at_startdate,0)*100)

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

1784: , p_action_information_category => 'GB P46 CAR EDI ALLOCATION'
1785: , p_action_information1 => p_action_flag
1786: , p_action_information2 => p_vehicle_allocation_id
1787: , p_action_information3 => fnd_date.date_to_canonical(p_allocation_start_date)
1788: , p_action_information4 => fnd_date.date_to_canonical(p_allocation_end_date)
1789: , p_action_information5 => p_vehicle_repository_id
1790: , p_action_information6 => to_char(nvl(car_rec.list_price,0)*100)
1791: , p_action_information7 => to_char(nvl(car_rec.accessory_value_at_startdate,0)*100)
1792: , p_action_information8 => to_char(nvl(alloc_rec.capital_contribution,0)*100)

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

1793: , p_action_information9 => to_char(nvl(alloc_rec.private_contribution,0)*100)
1794: , p_action_information10 => car_rec.fuel_type
1795: , p_action_information11 => car_rec.fiscal_ratings
1796: , p_action_information12 => alloc_rec.fuel_benefit
1797: , p_action_information13 => fnd_date.date_to_canonical(car_rec.initial_registration)
1798: , p_action_information14 => NULL
1799: , p_action_information15 => NULL
1800: , p_action_information16 => upper(car_rec.make || ' ' || car_rec.model)
1801: , p_action_information17 => to_char(car_rec.engine_capacity_in_cc)

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

1816: , p_source_text => NULL
1817: , p_action_information_category => 'GB P46 CAR EDI ALLOCATION'
1818: , p_action_information1 => p_action_flag
1819: , p_action_information2 => p_vehicle_allocation_id
1820: , p_action_information3 => fnd_date.date_to_canonical(p_fuel_type_change_Date)
1821: , p_action_information4 => fnd_date.date_to_canonical(p_allocation_end_date)
1822: , p_action_information5 => p_vehicle_repository_id
1823: , p_action_information6 => to_char(nvl(car_rec.list_price,0)*100)
1824: , p_action_information7 => to_char(nvl(car_rec.accessory_value_at_startdate,0)*100)

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

1817: , p_action_information_category => 'GB P46 CAR EDI ALLOCATION'
1818: , p_action_information1 => p_action_flag
1819: , p_action_information2 => p_vehicle_allocation_id
1820: , p_action_information3 => fnd_date.date_to_canonical(p_fuel_type_change_Date)
1821: , p_action_information4 => fnd_date.date_to_canonical(p_allocation_end_date)
1822: , p_action_information5 => p_vehicle_repository_id
1823: , p_action_information6 => to_char(nvl(car_rec.list_price,0)*100)
1824: , p_action_information7 => to_char(nvl(car_rec.accessory_value_at_startdate,0)*100)
1825: , p_action_information8 => to_char(nvl(alloc_rec.capital_contribution,0)*100)

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

1826: , p_action_information9 => to_char(nvl(alloc_rec.private_contribution,0)*100)
1827: , p_action_information10 => car_rec.fuel_type
1828: , p_action_information11 => car_rec.fiscal_ratings
1829: , p_action_information12 => alloc_rec.fuel_benefit
1830: , p_action_information13 => fnd_date.date_to_canonical(car_rec.initial_registration)
1831: , p_action_information14 => l_date_first_avail
1832: , p_action_information15 => l_second_car_flag
1833: , p_action_information16 => upper(car_rec.make || ' ' || car_rec.model)
1834: , p_action_information17 => to_char(car_rec.engine_capacity_in_cc)

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

1834: , p_action_information17 => to_char(car_rec.engine_capacity_in_cc)
1835: , p_action_information18 => upper(car_rec.make || ' ' || car_rec.model)
1836: , p_action_information19 => to_char(car_rec.engine_capacity_in_cc)
1837: , p_action_information20 => to_char(p_vehicle_allocation_id)
1838: , p_action_information21 => fnd_date.date_to_canonical(p_fuel_type_change_date-1)
1839: );
1840: --
1841: hr_utility.set_location(l_proc, 200);
1842: END IF;

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

1884: LOOP
1885: -- Loop through all assignments
1886: hr_utility.set_location(l_proc, 20);
1887: hr_utility.trace(l_proc||': assignment_id='||asg_rec.assignment_id);
1888: hr_utility.trace(l_proc||': asg_min_start_date='||fnd_date.date_to_displaydate(asg_rec.asg_min_start_date));
1889: hr_utility.trace(l_proc||': asg_max_end_date='||fnd_date.date_to_displaydate(asg_rec.asg_max_end_date));
1890: --
1891: FOR alc_rec IN c_allocations(asg_rec.assignment_id) LOOP
1892: -- Loop through all vehicle allocations

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

1885: -- Loop through all assignments
1886: hr_utility.set_location(l_proc, 20);
1887: hr_utility.trace(l_proc||': assignment_id='||asg_rec.assignment_id);
1888: hr_utility.trace(l_proc||': asg_min_start_date='||fnd_date.date_to_displaydate(asg_rec.asg_min_start_date));
1889: hr_utility.trace(l_proc||': asg_max_end_date='||fnd_date.date_to_displaydate(asg_rec.asg_max_end_date));
1890: --
1891: FOR alc_rec IN c_allocations(asg_rec.assignment_id) LOOP
1892: -- Loop through all vehicle allocations
1893: -- over the date range

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

1902: FETCH c_alloc_dates INTO alc_dates_rec;
1903: CLOSE c_alloc_dates;
1904: --
1905: hr_utility.set_location(l_proc, 40);
1906: hr_utility.trace(l_proc||': min_start_date='|| fnd_date.date_to_displaydate(alc_dates_rec.min_start_date));
1907: hr_utility.trace(l_proc||': max_end_date='|| fnd_date.date_to_displaydate(alc_dates_rec.max_end_date));
1908: --
1909: -- Check whether vehicle was allocated or
1910: -- Withdrawn within the date range also

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

1903: CLOSE c_alloc_dates;
1904: --
1905: hr_utility.set_location(l_proc, 40);
1906: hr_utility.trace(l_proc||': min_start_date='|| fnd_date.date_to_displaydate(alc_dates_rec.min_start_date));
1907: hr_utility.trace(l_proc||': max_end_date='|| fnd_date.date_to_displaydate(alc_dates_rec.max_end_date));
1908: --
1909: -- Check whether vehicle was allocated or
1910: -- Withdrawn within the date range also
1911: -- check that this allocation or withdrawal

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

1992: hr_utility.trace(l_proc||': p_assactid='|| p_assactid);
1993: hr_utility.trace(l_proc||': vehicle_allocation_id='|| alc_rec.vehicle_allocation_id);
1994: hr_utility.trace(l_proc||': vehicle_repository_id='|| alc_rec.vehicle_repository_id);
1995: hr_utility.trace(l_proc||': l_action_flag='|| l_action_flag);
1996: hr_utility.trace(l_proc||': alc_dates_rec.min_start_date='|| fnd_date.date_to_displaydate(alc_dates_rec.min_start_date));
1997: hr_utility.trace(l_proc||': alc_dates_rec.max_end_date='|| fnd_date.date_to_displaydate(alc_dates_rec.max_end_date));
1998: --
1999: archive_allocation_action(p_assignment_id => asg_rec.assignment_id,
2000: p_asg_act_id => p_assactid,

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

1993: hr_utility.trace(l_proc||': vehicle_allocation_id='|| alc_rec.vehicle_allocation_id);
1994: hr_utility.trace(l_proc||': vehicle_repository_id='|| alc_rec.vehicle_repository_id);
1995: hr_utility.trace(l_proc||': l_action_flag='|| l_action_flag);
1996: hr_utility.trace(l_proc||': alc_dates_rec.min_start_date='|| fnd_date.date_to_displaydate(alc_dates_rec.min_start_date));
1997: hr_utility.trace(l_proc||': alc_dates_rec.max_end_date='|| fnd_date.date_to_displaydate(alc_dates_rec.max_end_date));
1998: --
1999: archive_allocation_action(p_assignment_id => asg_rec.assignment_id,
2000: p_asg_act_id => p_assactid,
2001: p_vehicle_allocation_id => alc_rec.vehicle_allocation_id,

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

2093: hr_utility.trace(l_proc||': p_assactid='|| p_assactid);
2094: hr_utility.trace(l_proc||': vehicle_allocation_id='|| alc_rec.vehicle_allocation_id);
2095: hr_utility.trace(l_proc||': vehicle_repository_id='|| alc_rec.vehicle_repository_id);
2096: hr_utility.trace(l_proc||': l_action_flag='|| l_action_flag);
2097: hr_utility.trace(l_proc||': alc_dates_rec.min_start_date='|| fnd_date.date_to_displaydate(alc_dates_rec.min_start_date));
2098: hr_utility.trace(l_proc||': alc_dates_rec.max_end_date='|| fnd_date.date_to_displaydate(alc_dates_rec.max_end_date));
2099: --
2100: archive_allocation_action(p_assignment_id => asg_rec.assignment_id,
2101: p_asg_act_id => p_assactid,

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

2094: hr_utility.trace(l_proc||': vehicle_allocation_id='|| alc_rec.vehicle_allocation_id);
2095: hr_utility.trace(l_proc||': vehicle_repository_id='|| alc_rec.vehicle_repository_id);
2096: hr_utility.trace(l_proc||': l_action_flag='|| l_action_flag);
2097: hr_utility.trace(l_proc||': alc_dates_rec.min_start_date='|| fnd_date.date_to_displaydate(alc_dates_rec.min_start_date));
2098: hr_utility.trace(l_proc||': alc_dates_rec.max_end_date='|| fnd_date.date_to_displaydate(alc_dates_rec.max_end_date));
2099: --
2100: archive_allocation_action(p_assignment_id => asg_rec.assignment_id,
2101: p_asg_act_id => p_assactid,
2102: p_vehicle_allocation_id => alc_rec.vehicle_allocation_id,

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

2321: LOOP
2322: -- Loop through all assignments
2323: hr_utility.set_location(l_proc, 20);
2324: hr_utility.trace(l_proc||': assignment_id='||asg_rec.assignment_id);
2325: hr_utility.trace(l_proc||': asg_min_start_date='||fnd_date.date_to_displaydate(asg_rec.asg_min_start_date));
2326: hr_utility.trace(l_proc||': asg_max_end_date='||fnd_date.date_to_displaydate(asg_rec.asg_max_end_date));
2327: --
2328: FOR alc_rec IN c_allocations(asg_rec.assignment_id) LOOP
2329: -- Loop through all vehicle allocations

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

2322: -- Loop through all assignments
2323: hr_utility.set_location(l_proc, 20);
2324: hr_utility.trace(l_proc||': assignment_id='||asg_rec.assignment_id);
2325: hr_utility.trace(l_proc||': asg_min_start_date='||fnd_date.date_to_displaydate(asg_rec.asg_min_start_date));
2326: hr_utility.trace(l_proc||': asg_max_end_date='||fnd_date.date_to_displaydate(asg_rec.asg_max_end_date));
2327: --
2328: FOR alc_rec IN c_allocations(asg_rec.assignment_id) LOOP
2329: -- Loop through all vehicle allocations
2330: -- over the date range

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

2339: FETCH c_alloc_dates INTO alc_dates_rec;
2340: CLOSE c_alloc_dates;
2341: --
2342: hr_utility.set_location(l_proc, 40);
2343: hr_utility.trace(l_proc||': min_start_date='|| fnd_date.date_to_displaydate(alc_dates_rec.min_start_date));
2344: hr_utility.trace(l_proc||': max_end_date='|| fnd_date.date_to_displaydate(alc_dates_rec.max_end_date));
2345: --
2346: -- Check whether vehicle was allocated or
2347: -- Withdrawn within the date range also

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

2340: CLOSE c_alloc_dates;
2341: --
2342: hr_utility.set_location(l_proc, 40);
2343: hr_utility.trace(l_proc||': min_start_date='|| fnd_date.date_to_displaydate(alc_dates_rec.min_start_date));
2344: hr_utility.trace(l_proc||': max_end_date='|| fnd_date.date_to_displaydate(alc_dates_rec.max_end_date));
2345: --
2346: -- Check whether vehicle was allocated or
2347: -- Withdrawn within the date range also
2348: -- check that this allocation or withdrawal

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

2429: hr_utility.trace(l_proc||': p_assactid='|| p_assactid);
2430: hr_utility.trace(l_proc||': vehicle_allocation_id='|| alc_rec.vehicle_allocation_id);
2431: hr_utility.trace(l_proc||': vehicle_repository_id='|| alc_rec.vehicle_repository_id);
2432: hr_utility.trace(l_proc||': l_action_flag='|| l_action_flag);
2433: hr_utility.trace(l_proc||': alc_dates_rec.min_start_date='|| fnd_date.date_to_displaydate(alc_dates_rec.min_start_date));
2434: hr_utility.trace(l_proc||': alc_dates_rec.max_end_date='|| fnd_date.date_to_displaydate(alc_dates_rec.max_end_date));
2435: --
2436: archive_allocation_action(p_assignment_id => asg_rec.assignment_id,
2437: p_asg_act_id => p_assactid,

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

2430: hr_utility.trace(l_proc||': vehicle_allocation_id='|| alc_rec.vehicle_allocation_id);
2431: hr_utility.trace(l_proc||': vehicle_repository_id='|| alc_rec.vehicle_repository_id);
2432: hr_utility.trace(l_proc||': l_action_flag='|| l_action_flag);
2433: hr_utility.trace(l_proc||': alc_dates_rec.min_start_date='|| fnd_date.date_to_displaydate(alc_dates_rec.min_start_date));
2434: hr_utility.trace(l_proc||': alc_dates_rec.max_end_date='|| fnd_date.date_to_displaydate(alc_dates_rec.max_end_date));
2435: --
2436: archive_allocation_action(p_assignment_id => asg_rec.assignment_id,
2437: p_asg_act_id => p_assactid,
2438: p_vehicle_allocation_id => alc_rec.vehicle_allocation_id,

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

2530: hr_utility.trace(l_proc||': p_assactid='|| p_assactid);
2531: hr_utility.trace(l_proc||': vehicle_allocation_id='|| alc_rec.vehicle_allocation_id);
2532: hr_utility.trace(l_proc||': vehicle_repository_id='|| alc_rec.vehicle_repository_id);
2533: hr_utility.trace(l_proc||': l_action_flag='|| l_action_flag);
2534: hr_utility.trace(l_proc||': alc_dates_rec.min_start_date='|| fnd_date.date_to_displaydate(alc_dates_rec.min_start_date));
2535: hr_utility.trace(l_proc||': alc_dates_rec.max_end_date='|| fnd_date.date_to_displaydate(alc_dates_rec.max_end_date));
2536: --
2537: archive_allocation_action(p_assignment_id => asg_rec.assignment_id,
2538: p_asg_act_id => p_assactid,

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

2531: hr_utility.trace(l_proc||': vehicle_allocation_id='|| alc_rec.vehicle_allocation_id);
2532: hr_utility.trace(l_proc||': vehicle_repository_id='|| alc_rec.vehicle_repository_id);
2533: hr_utility.trace(l_proc||': l_action_flag='|| l_action_flag);
2534: hr_utility.trace(l_proc||': alc_dates_rec.min_start_date='|| fnd_date.date_to_displaydate(alc_dates_rec.min_start_date));
2535: hr_utility.trace(l_proc||': alc_dates_rec.max_end_date='|| fnd_date.date_to_displaydate(alc_dates_rec.max_end_date));
2536: --
2537: archive_allocation_action(p_assignment_id => asg_rec.assignment_id,
2538: p_asg_act_id => p_assactid,
2539: p_vehicle_allocation_id => alc_rec.vehicle_allocation_id,