APPS.HXC_DEPOSIT_CHECKS dependencies on FND_DATE

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

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

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

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

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

953: (p_timecard_props
954: ,'TsPerValidateOnSaveValidateOnSave'
955: ,null
956: ,null
957: ,fnd_date.canonical_to_date(p_blocks(l_tc_index).start_time)
958: ,fnd_date.canonical_to_date(p_blocks(l_tc_index).stop_time)
959: );
960:
961:

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

954: ,'TsPerValidateOnSaveValidateOnSave'
955: ,null
956: ,null
957: ,fnd_date.canonical_to_date(p_blocks(l_tc_index).start_time)
958: ,fnd_date.canonical_to_date(p_blocks(l_tc_index).stop_time)
959: );
960:
961:
962: --

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

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

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

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

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

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