APPS.HXC_DEPOSIT_CHECKS dependencies on FND_DATE

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 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 553: ,fnd_date.canonical_to_date(p_blocks(p_block_number).start_time)

549: -- Run the check
550: --
551: l_test_tc_id := chk_timecard_exists
552: (p_blocks(p_block_number).resource_id
553: ,fnd_date.canonical_to_date(p_blocks(p_block_number).start_time)
554: ,fnd_date.canonical_to_date(p_blocks(p_block_number).stop_time)
555: ,p_blocks(p_block_number).time_building_block_id
556: );
557:

Line 554: ,fnd_date.canonical_to_date(p_blocks(p_block_number).stop_time)

550: --
551: l_test_tc_id := chk_timecard_exists
552: (p_blocks(p_block_number).resource_id
553: ,fnd_date.canonical_to_date(p_blocks(p_block_number).start_time)
554: ,fnd_date.canonical_to_date(p_blocks(p_block_number).stop_time)
555: ,p_blocks(p_block_number).time_building_block_id
556: );
557:
558: if(l_test_tc_id is null) then

Line 960: ,fnd_date.canonical_to_date(p_blocks(l_tc_index).start_time)

956: (p_timecard_props
957: ,'TsPerValidateOnSaveValidateOnSave'
958: ,null
959: ,null
960: ,fnd_date.canonical_to_date(p_blocks(l_tc_index).start_time)
961: ,fnd_date.canonical_to_date(p_blocks(l_tc_index).stop_time)
962: );
963:
964:

Line 961: ,fnd_date.canonical_to_date(p_blocks(l_tc_index).stop_time)

957: ,'TsPerValidateOnSaveValidateOnSave'
958: ,null
959: ,null
960: ,fnd_date.canonical_to_date(p_blocks(l_tc_index).start_time)
961: ,fnd_date.canonical_to_date(p_blocks(l_tc_index).stop_time)
962: );
963:
964:
965: --

Line 1187: if(l_old_block.START_TIME <> fnd_date.canonical_to_date(p_block.START_TIME)) then

1183: else
1184: if(l_old_block.UNIT_OF_MEASURE <> p_block.UNIT_OF_MEASURE) then
1185: l_prohibited := true;
1186: else
1187: if(l_old_block.START_TIME <> fnd_date.canonical_to_date(p_block.START_TIME)) then
1188: l_prohibited := true;
1189: else
1190: if(l_old_block.STOP_TIME <> fnd_date.canonical_to_date(p_block.STOP_TIME)) then
1191: l_prohibited := true;

Line 1190: if(l_old_block.STOP_TIME <> fnd_date.canonical_to_date(p_block.STOP_TIME)) then

1186: else
1187: if(l_old_block.START_TIME <> fnd_date.canonical_to_date(p_block.START_TIME)) then
1188: l_prohibited := true;
1189: else
1190: if(l_old_block.STOP_TIME <> fnd_date.canonical_to_date(p_block.STOP_TIME)) then
1191: l_prohibited := true;
1192: else
1193: if(l_old_block.APPROVAL_STATUS <> p_block.APPROVAL_STATUS) then
1194: l_prohibited := true;

Line 1196: if(l_old_block.DATE_TO <> fnd_date.canonical_to_date(p_block.DATE_TO)) then

1192: else
1193: if(l_old_block.APPROVAL_STATUS <> p_block.APPROVAL_STATUS) then
1194: l_prohibited := true;
1195: else
1196: if(l_old_block.DATE_TO <> fnd_date.canonical_to_date(p_block.DATE_TO)) then
1197: l_prohibited := true;
1198: else
1199: if(nvl(l_old_block.COMMENT_TEXT,'COMMENT') <> nvl(p_block.COMMENT_TEXT,'COMMENT')) then
1200: l_prohibited := true;