APPS.HXC_DEPOSIT_CHECKS dependencies on HR_GENERAL

Line 388: if(fnd_date.canonical_to_date(p_blocks(l_block_count).date_to) <> hr_general.end_of_time) then

384: EXIT WHEN l_deleted_tc;
385: EXIT WHEN NOT p_blocks.exists(l_block_count);
386:
387: if(p_blocks(l_block_count).time_building_block_id = p_timecard_id) then
388: if(fnd_date.canonical_to_date(p_blocks(l_block_count).date_to) <> hr_general.end_of_time) then
389: l_deleted_tc := true;
390: end if;
391: end if;
392:

Line 420: if(p_blocks(l_block_count).date_to <> hr_general.end_of_time) then

416: EXIT WHEN l_deleted_tc;
417: EXIT WHEN NOT p_blocks.exists(l_block_count);
418:
419: if(p_blocks(l_block_count).time_building_block_id = p_timecard_id) then
420: if(p_blocks(l_block_count).date_to <> hr_general.end_of_time) then
421: l_deleted_tc := true;
422: end if;
423: end if;
424:

Line 479: and tbb.date_to = hr_general.end_of_time

475: select tbb.time_building_block_id into l_existing_timecard_id
476: from hxc_time_building_blocks tbb
477: where tbb.resource_id = p_resource_id
478: and tbb.scope = 'TIMECARD'
479: and tbb.date_to = hr_general.end_of_time
480: and tbb.start_time <= p_stop_time
481: and tbb.stop_time >= p_start_time
482: and tbb.time_building_block_id <> p_time_building_block_id;
483:

Line 544: if (fnd_date.canonical_to_date(p_blocks(p_block_number).date_to) = hr_general.end_of_time) then

540: -- checked elsewhere, but double check.
541: --
542: if (p_blocks(p_block_number).scope = 'TIMECARD') then
543:
544: if (fnd_date.canonical_to_date(p_blocks(p_block_number).date_to) = hr_general.end_of_time) then
545: --
546: -- Run the check
547: --
548: l_test_tc_id := chk_timecard_exists

Line 621: if (p_blocks(p_block_number).date_to = hr_general.end_of_time) then

617: -- checked elsewhere, but double check.
618: --
619: if (p_blocks(p_block_number).scope = 'TIMECARD') then
620:
621: if (p_blocks(p_block_number).date_to = hr_general.end_of_time) then
622: --
623: -- Run the check
624: --
625: l_test_tc_id := chk_timecard_exists

Line 796: l_early_detail date := hr_general.end_of_time;

792: ,p_details in hxc_timecard.block_list
793: ,p_block_idxs out nocopy block_list
794: ) is
795:
796: l_early_detail date := hr_general.end_of_time;
797: l_late_detail date := hr_general.start_of_time;
798: l_detail_date date;
799: l_asg_info asg_info;
800: l_index number;

Line 797: l_late_detail date := hr_general.start_of_time;

793: ,p_block_idxs out nocopy block_list
794: ) is
795:
796: l_early_detail date := hr_general.end_of_time;
797: l_late_detail date := hr_general.start_of_time;
798: l_detail_date date;
799: l_asg_info asg_info;
800: l_index number;
801: l_block_index number;

Line 1347: and tc.date_to = hr_general.end_of_time

1343: and ap.approval_status = 'APPROVED'
1344: and p_date between ap.start_time and ap.stop_time
1345: and ap.resource_id = tc.resource_id
1346: and ap.creation_date >= tc.creation_date
1347: and tc.date_to = hr_general.end_of_time
1348: and tc.scope = 'TIMECARD'
1349: and tc.start_time <= ap.stop_time
1350: and tc.stop_time >= ap.start_time
1351: and NOT exists

Line 1356: and date_to = hr_general.end_of_time

1352: (select 'Y'
1353: from hxc_time_building_blocks
1354: where resource_id = p_resource_id
1355: and scope = 'APPLICATION_PERIOD'
1356: and date_to = hr_general.end_of_time
1357: and approval_status = 'REJECTED'
1358: and p_date between start_time and stop_time
1359: );
1360:

Line 1395: AND detail.date_to = hr_general.end_of_time

1391: hxc_time_building_blocks day,
1392: hxc_time_building_blocks parent
1393: WHERE detail.parent_building_block_id = day.time_building_block_id
1394: AND detail.parent_building_block_ovn = day.object_version_number
1395: AND detail.date_to = hr_general.end_of_time
1396: AND detail.resource_id = p_resource_id
1397: AND detail.scope = 'DETAIL'
1398: AND detail.creation_date <=(select max(ap.creation_date)
1399: from hxc_time_building_blocks ap

Line 1406: and parent.date_to = hr_general.end_of_time

1402: and ap.approval_status = 'APPROVED'
1403: and p_date between ap.start_time and ap.stop_time
1404: and ap.resource_id = parent.resource_id
1405: and ap.creation_date >= parent.creation_date
1406: and parent.date_to = hr_general.end_of_time
1407: and parent.start_time <= ap.stop_time
1408: and parent.stop_time >= ap.start_time)
1409: AND day.scope = 'DAY'
1410: AND Trunc(day.start_time) = Trunc(p_date)

Line 1411: AND day.date_to = hr_general.end_of_time

1407: and parent.start_time <= ap.stop_time
1408: and parent.stop_time >= ap.start_time)
1409: AND day.scope = 'DAY'
1410: AND Trunc(day.start_time) = Trunc(p_date)
1411: AND day.date_to = hr_general.end_of_time
1412: AND day.resource_id = p_resource_id
1413: and parent.time_building_block_id=day.parent_building_block_id
1414: and parent.object_version_number=day.parent_building_block_ovn
1415: and parent.scope='TIMECARD'

Line 1416: AND parent.date_to = hr_general.end_of_time

1412: AND day.resource_id = p_resource_id
1413: and parent.time_building_block_id=day.parent_building_block_id
1414: and parent.object_version_number=day.parent_building_block_ovn
1415: and parent.scope='TIMECARD'
1416: AND parent.date_to = hr_general.end_of_time
1417: AND parent.resource_id = p_resource_id;
1418:
1419: l_dummy varchar2(1);
1420:

Line 1565: l_early_detail date := hr_general.end_of_time;

1561: l_modify_days varchar2(2) := 'N';
1562: l_modify_details varchar2(2) := 'N';
1563: l_detail_date date;
1564: l_detail_index number;
1565: l_early_detail date := hr_general.end_of_time;
1566: l_late_detail date := hr_general.start_of_time;
1567: l_proc varchar2(72) := g_package||'chk_approved_locked_days';
1568: Begin
1569:

Line 1566: l_late_detail date := hr_general.start_of_time;

1562: l_modify_details varchar2(2) := 'N';
1563: l_detail_date date;
1564: l_detail_index number;
1565: l_early_detail date := hr_general.end_of_time;
1566: l_late_detail date := hr_general.start_of_time;
1567: l_proc varchar2(72) := g_package||'chk_approved_locked_days';
1568: Begin
1569:
1570: find_detail_date_extremes