APPS.HXC_ARRAY_TIME_DEPOSIT dependencies on FND_DATE

Line 71: if(fnd_date.canonical_to_date(p_blocks(l_block_count).date_to) = hr_general.end_of_time) then

67: if(p_deleted) then
68: l_deposit_block := true;
69: else
70:
71: if(fnd_date.canonical_to_date(p_blocks(l_block_count).date_to) = hr_general.end_of_time) then
72:
73: l_deposit_block := true;
74:
75: end if;

Line 87: if(fnd_date.canonical_to_date(p_blocks(l_block_count).date_to) = hr_general.end_of_time) then

83: /*
84: None of this is required anymore.
85:
86: if(p_blocks(l_block_count).scope = 'TIMECARD') then
87: if(fnd_date.canonical_to_date(p_blocks(l_block_count).date_to) = hr_general.end_of_time) then
88:
89: --
90: -- check to see if there is a timecard id already for this
91: -- period

Line 520: ,p_blocks(l_block).START_TIME--fnd_date.date_to_canonical(p_blocks(l_block).START_TIME)

516: p_blocks(l_block).TIME_BUILDING_BLOCK_ID
517: ,p_blocks(l_block).TYPE
518: ,p_blocks(l_block).MEASURE
519: ,p_blocks(l_block).UNIT_OF_MEASURE
520: ,p_blocks(l_block).START_TIME--fnd_date.date_to_canonical(p_blocks(l_block).START_TIME)
521: ,p_blocks(l_block).STOP_TIME--fnd_date.date_to_canonical(p_blocks(l_block).STOP_TIME)
522: ,p_blocks(l_block).PARENT_BUILDING_BLOCK_ID
523: ,p_blocks(l_block).PARENT_IS_NEW
524: ,p_blocks(l_block).SCOPE

Line 521: ,p_blocks(l_block).STOP_TIME--fnd_date.date_to_canonical(p_blocks(l_block).STOP_TIME)

517: ,p_blocks(l_block).TYPE
518: ,p_blocks(l_block).MEASURE
519: ,p_blocks(l_block).UNIT_OF_MEASURE
520: ,p_blocks(l_block).START_TIME--fnd_date.date_to_canonical(p_blocks(l_block).START_TIME)
521: ,p_blocks(l_block).STOP_TIME--fnd_date.date_to_canonical(p_blocks(l_block).STOP_TIME)
522: ,p_blocks(l_block).PARENT_BUILDING_BLOCK_ID
523: ,p_blocks(l_block).PARENT_IS_NEW
524: ,p_blocks(l_block).SCOPE
525: ,p_blocks(l_block).OBJECT_VERSION_NUMBER

Line 530: ,p_blocks(l_block).DATE_FROM--fnd_date.date_to_canonical(p_blocks(l_block).DATE_FROM)

526: ,p_blocks(l_block).APPROVAL_STATUS
527: ,p_blocks(l_block).RESOURCE_ID
528: ,p_blocks(l_block).RESOURCE_TYPE
529: ,p_blocks(l_block).APPROVAL_STYLE_ID
530: ,p_blocks(l_block).DATE_FROM--fnd_date.date_to_canonical(p_blocks(l_block).DATE_FROM)
531: ,p_blocks(l_block).DATE_TO--fnd_date.date_to_canonical(p_blocks(l_block).DATE_TO)
532: ,p_blocks(l_block).COMMENT_TEXT
533: ,p_blocks(l_block).PARENT_BUILDING_BLOCK_OVN
534: ,p_blocks(l_block).NEW

Line 531: ,p_blocks(l_block).DATE_TO--fnd_date.date_to_canonical(p_blocks(l_block).DATE_TO)

527: ,p_blocks(l_block).RESOURCE_ID
528: ,p_blocks(l_block).RESOURCE_TYPE
529: ,p_blocks(l_block).APPROVAL_STYLE_ID
530: ,p_blocks(l_block).DATE_FROM--fnd_date.date_to_canonical(p_blocks(l_block).DATE_FROM)
531: ,p_blocks(l_block).DATE_TO--fnd_date.date_to_canonical(p_blocks(l_block).DATE_TO)
532: ,p_blocks(l_block).COMMENT_TEXT
533: ,p_blocks(l_block).PARENT_BUILDING_BLOCK_OVN
534: ,p_blocks(l_block).NEW
535: ,p_blocks(l_block).CHANGED

Line 561: ,fnd_date.date_to_canonical(p_details_blocks(l_block).START_TIME)

557: p_details_blocks(l_block).TIME_BUILDING_BLOCK_ID
558: ,p_details_blocks(l_block).TYPE
559: ,p_details_blocks(l_block).MEASURE
560: ,p_details_blocks(l_block).UNIT_OF_MEASURE
561: ,fnd_date.date_to_canonical(p_details_blocks(l_block).START_TIME)
562: ,fnd_date.date_to_canonical(p_details_blocks(l_block).STOP_TIME)
563: ,p_details_blocks(l_block).PARENT_BUILDING_BLOCK_ID
564: ,p_details_blocks(l_block).PARENT_IS_NEW
565: ,p_details_blocks(l_block).SCOPE

Line 562: ,fnd_date.date_to_canonical(p_details_blocks(l_block).STOP_TIME)

558: ,p_details_blocks(l_block).TYPE
559: ,p_details_blocks(l_block).MEASURE
560: ,p_details_blocks(l_block).UNIT_OF_MEASURE
561: ,fnd_date.date_to_canonical(p_details_blocks(l_block).START_TIME)
562: ,fnd_date.date_to_canonical(p_details_blocks(l_block).STOP_TIME)
563: ,p_details_blocks(l_block).PARENT_BUILDING_BLOCK_ID
564: ,p_details_blocks(l_block).PARENT_IS_NEW
565: ,p_details_blocks(l_block).SCOPE
566: ,p_details_blocks(l_block).OBJECT_VERSION_NUMBER

Line 571: ,fnd_date.date_to_canonical(p_details_blocks(l_block).DATE_FROM)

567: ,p_details_blocks(l_block).APPROVAL_STATUS
568: ,p_details_blocks(l_block).RESOURCE_ID
569: ,p_details_blocks(l_block).RESOURCE_TYPE
570: ,p_details_blocks(l_block).APPROVAL_STYLE_ID
571: ,fnd_date.date_to_canonical(p_details_blocks(l_block).DATE_FROM)
572: ,fnd_date.date_to_canonical(p_details_blocks(l_block).DATE_TO)
573: ,p_details_blocks(l_block).COMMENT_TEXT
574: ,p_details_blocks(l_block).PARENT_BUILDING_BLOCK_OVN
575: ,p_details_blocks(l_block).NEW

Line 572: ,fnd_date.date_to_canonical(p_details_blocks(l_block).DATE_TO)

568: ,p_details_blocks(l_block).RESOURCE_ID
569: ,p_details_blocks(l_block).RESOURCE_TYPE
570: ,p_details_blocks(l_block).APPROVAL_STYLE_ID
571: ,fnd_date.date_to_canonical(p_details_blocks(l_block).DATE_FROM)
572: ,fnd_date.date_to_canonical(p_details_blocks(l_block).DATE_TO)
573: ,p_details_blocks(l_block).COMMENT_TEXT
574: ,p_details_blocks(l_block).PARENT_BUILDING_BLOCK_OVN
575: ,p_details_blocks(l_block).NEW
576: ,p_details_blocks(l_block).CHANGED

Line 712: ,p_start_time => FND_DATE.CANONICAL_TO_DATE(g_start_time)

708:
709: hxc_alias_translator.do_retrieval_translation
710: (p_attributes => l_exploded_attributes
711: ,p_blocks => l_blocks_for_translation
712: ,p_start_time => FND_DATE.CANONICAL_TO_DATE(g_start_time)
713: ,p_stop_time => FND_DATE.CANONICAL_TO_DATE(g_stop_time)
714: ,p_resource_id => g_resource_id
715: ,p_messages => l_messages_table
716: );

Line 713: ,p_stop_time => FND_DATE.CANONICAL_TO_DATE(g_stop_time)

709: hxc_alias_translator.do_retrieval_translation
710: (p_attributes => l_exploded_attributes
711: ,p_blocks => l_blocks_for_translation
712: ,p_start_time => FND_DATE.CANONICAL_TO_DATE(g_start_time)
713: ,p_stop_time => FND_DATE.CANONICAL_TO_DATE(g_stop_time)
714: ,p_resource_id => g_resource_id
715: ,p_messages => l_messages_table
716: );
717: