DBA Data[Home] [Help]

APPS.HXC_TIMESTORE_DEPOSIT_UTIL dependencies on FND_DATE

Line 26: p_start_date => fnd_date.canonical_to_date

22: (p_props,
23: 'TsPerAuditRequirementsAuditRequirements',
24: NULL,
25: NULL,
26: p_start_date => fnd_date.canonical_to_date
27: (p_blocks
28: (hxc_timecard_block_utils.find_active_timecard_index
29: (p_blocks)
30: ).start_time

Line 32: p_stop_date => fnd_date.canonical_to_date

28: (hxc_timecard_block_utils.find_active_timecard_index
29: (p_blocks)
30: ).start_time
31: ),
32: p_stop_date => fnd_date.canonical_to_date
33: (p_blocks
34: (hxc_timecard_block_utils.find_active_timecard_index
35: (p_blocks)
36: ).stop_time

Line 227: fnd_date.canonical_to_date

223: hxc_timecard_approval.is_timecard_resubmitted
224: (p_blocks (l_timecard_index).time_building_block_id,
225: p_blocks (l_timecard_index).object_version_number,
226: p_blocks (l_timecard_index).resource_id,
227: fnd_date.canonical_to_date
228: (p_blocks (l_timecard_index).start_time
229: ),
230: fnd_date.canonical_to_date
231: (p_blocks (l_timecard_index).stop_time

Line 230: fnd_date.canonical_to_date

226: p_blocks (l_timecard_index).resource_id,
227: fnd_date.canonical_to_date
228: (p_blocks (l_timecard_index).start_time
229: ),
230: fnd_date.canonical_to_date
231: (p_blocks (l_timecard_index).stop_time
232: )
233: );
234: ELSE

Line 317: p_timecard_start_time => fnd_date.canonical_to_date

313: hxc_timecard_block_utils.find_active_timecard_index (p_blocks);
314: hxc_timecard_properties.get_preference_properties
315: (p_validate => hxc_timecard.c_yes,
316: p_resource_id => p_blocks (l_timecard_index).resource_id,
317: p_timecard_start_time => fnd_date.canonical_to_date
318: (p_blocks (l_timecard_index).start_time
319: ),
320: p_timecard_stop_time => fnd_date.canonical_to_date
321: (p_blocks (l_timecard_index).stop_time

Line 320: p_timecard_stop_time => fnd_date.canonical_to_date

316: p_resource_id => p_blocks (l_timecard_index).resource_id,
317: p_timecard_start_time => fnd_date.canonical_to_date
318: (p_blocks (l_timecard_index).start_time
319: ),
320: p_timecard_stop_time => fnd_date.canonical_to_date
321: (p_blocks (l_timecard_index).stop_time
322: ),
323: p_for_timecard => FALSE,
324: p_messages => p_messages,

Line 520: fnd_date.canonical_to_date

516: hxc_timecard_approval.is_timecard_resubmitted
517: (p_blocks (l_timecard_index).time_building_block_id,
518: p_blocks (l_timecard_index).object_version_number,
519: p_blocks (l_timecard_index).resource_id,
520: fnd_date.canonical_to_date
521: (p_blocks (l_timecard_index).start_time
522: ),
523: fnd_date.canonical_to_date
524: (p_blocks (l_timecard_index).stop_time

Line 523: fnd_date.canonical_to_date

519: p_blocks (l_timecard_index).resource_id,
520: fnd_date.canonical_to_date
521: (p_blocks (l_timecard_index).start_time
522: ),
523: fnd_date.canonical_to_date
524: (p_blocks (l_timecard_index).stop_time
525: )
526: );
527: ELSE

Line 535: p_timecard_start_time => fnd_date.canonical_to_date

531: -- Obtain the timecard properties
532: hxc_timecard_properties.get_preference_properties
533: (p_validate => hxc_timecard.c_yes,
534: p_resource_id => p_blocks (l_timecard_index).resource_id,
535: p_timecard_start_time => fnd_date.canonical_to_date
536: (p_blocks (l_timecard_index).start_time
537: ),
538: p_timecard_stop_time => fnd_date.canonical_to_date
539: (p_blocks (l_timecard_index).stop_time

Line 538: p_timecard_stop_time => fnd_date.canonical_to_date

534: p_resource_id => p_blocks (l_timecard_index).resource_id,
535: p_timecard_start_time => fnd_date.canonical_to_date
536: (p_blocks (l_timecard_index).start_time
537: ),
538: p_timecard_stop_time => fnd_date.canonical_to_date
539: (p_blocks (l_timecard_index).stop_time
540: ),
541: p_for_timecard => FALSE,
542: p_messages => p_messages,

Line 843: fnd_date.date_to_canonical (p_blocks (l_index).start_time),

839: (p_blocks (l_index).time_building_block_id,
840: p_blocks (l_index).TYPE,
841: p_blocks (l_index).measure,
842: p_blocks (l_index).unit_of_measure,
843: fnd_date.date_to_canonical (p_blocks (l_index).start_time),
844: fnd_date.date_to_canonical (p_blocks (l_index).stop_time),
845: p_blocks (l_index).parent_building_block_id,
846: p_blocks (l_index).parent_is_new,
847: p_blocks (l_index).SCOPE,

Line 844: fnd_date.date_to_canonical (p_blocks (l_index).stop_time),

840: p_blocks (l_index).TYPE,
841: p_blocks (l_index).measure,
842: p_blocks (l_index).unit_of_measure,
843: fnd_date.date_to_canonical (p_blocks (l_index).start_time),
844: fnd_date.date_to_canonical (p_blocks (l_index).stop_time),
845: p_blocks (l_index).parent_building_block_id,
846: p_blocks (l_index).parent_is_new,
847: p_blocks (l_index).SCOPE,
848: p_blocks (l_index).object_version_number,

Line 853: fnd_date.date_to_canonical (p_blocks (l_index).date_from),

849: p_blocks (l_index).approval_status,
850: p_blocks (l_index).resource_id,
851: p_blocks (l_index).resource_type,
852: p_blocks (l_index).approval_style_id,
853: fnd_date.date_to_canonical (p_blocks (l_index).date_from),
854: fnd_date.date_to_canonical (p_blocks (l_index).date_to),
855: p_blocks (l_index).comment_text,
856: p_blocks (l_index).parent_building_block_ovn,
857: p_blocks (l_index).NEW,

Line 854: fnd_date.date_to_canonical (p_blocks (l_index).date_to),

850: p_blocks (l_index).resource_id,
851: p_blocks (l_index).resource_type,
852: p_blocks (l_index).approval_style_id,
853: fnd_date.date_to_canonical (p_blocks (l_index).date_from),
854: fnd_date.date_to_canonical (p_blocks (l_index).date_to),
855: p_blocks (l_index).comment_text,
856: p_blocks (l_index).parent_building_block_ovn,
857: p_blocks (l_index).NEW,
858: p_blocks (l_index).changed,

Line 1558: BETWEEN fnd_date.canonical_to_date

1554: EXIT WHEN (NOT p_app_blocks.EXISTS (l_building_block_count))
1555: OR (p_timecard_bb_id IS NOT NULL);
1556:
1557: IF (p_start_time
1558: BETWEEN fnd_date.canonical_to_date
1559: (p_app_blocks (l_building_block_count).start_time
1560: )
1561: AND fnd_date.canonical_to_date
1562: (p_app_blocks (l_building_block_count).stop_time

Line 1561: AND fnd_date.canonical_to_date

1557: IF (p_start_time
1558: BETWEEN fnd_date.canonical_to_date
1559: (p_app_blocks (l_building_block_count).start_time
1560: )
1561: AND fnd_date.canonical_to_date
1562: (p_app_blocks (l_building_block_count).stop_time
1563: )
1564: )
1565: AND (p_resource_type =

Line 2594: p_start_time => fnd_date.canonical_to_date

2590: THEN
2591: hxc_lock_api.request_lock
2592: (p_process_locker_type => hxc_lock_util.c_plsql_deposit_action,
2593: p_resource_id => p_app_blocks (l_tc_index).resource_id,
2594: p_start_time => fnd_date.canonical_to_date
2595: (p_app_blocks (l_tc_index).start_time
2596: ),
2597: p_stop_time => fnd_date.canonical_to_date
2598: (p_app_blocks (l_tc_index).stop_time

Line 2597: p_stop_time => fnd_date.canonical_to_date

2593: p_resource_id => p_app_blocks (l_tc_index).resource_id,
2594: p_start_time => fnd_date.canonical_to_date
2595: (p_app_blocks (l_tc_index).start_time
2596: ),
2597: p_stop_time => fnd_date.canonical_to_date
2598: (p_app_blocks (l_tc_index).stop_time
2599: ),
2600: p_time_building_block_id => NULL,
2601: p_time_building_block_ovn => NULL,

Line 2666: p_start_time => fnd_date.canonical_to_date

2662: hxc_lock_api.release_lock
2663: (p_row_lock_id => p_row_lock_id,
2664: p_process_locker_type => hxc_lock_util.c_plsql_deposit_action,
2665: p_resource_id => p_app_blocks (l_tc_index).resource_id,
2666: p_start_time => fnd_date.canonical_to_date
2667: (p_app_blocks (l_tc_index).start_time
2668: ),
2669: p_stop_time => fnd_date.canonical_to_date
2670: (p_app_blocks (l_tc_index).stop_time

Line 2669: p_stop_time => fnd_date.canonical_to_date

2665: p_resource_id => p_app_blocks (l_tc_index).resource_id,
2666: p_start_time => fnd_date.canonical_to_date
2667: (p_app_blocks (l_tc_index).start_time
2668: ),
2669: p_stop_time => fnd_date.canonical_to_date
2670: (p_app_blocks (l_tc_index).stop_time
2671: ),
2672: p_time_building_block_id => NULL,
2673: p_time_building_block_ovn => NULL,