APPS.HXC_DEPOSIT_CHECKS dependencies on HR_GENERAL

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

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

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

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

Line 482: and tbb.date_to = hr_general.end_of_time

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

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

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

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

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

Line 799: l_early_detail date := hr_general.end_of_time;

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

Line 800: l_late_detail date := hr_general.start_of_time;

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

Line 1350: and tc.date_to = hr_general.end_of_time

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

Line 1359: and date_to = hr_general.end_of_time

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

Line 1398: AND detail.date_to = hr_general.end_of_time

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

Line 1409: and parent.date_to = hr_general.end_of_time

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

Line 1414: AND day.date_to = hr_general.end_of_time

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

Line 1419: AND parent.date_to = hr_general.end_of_time

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

Line 1568: l_early_detail date := hr_general.end_of_time;

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

Line 1569: l_late_detail date := hr_general.start_of_time;

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