eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HXC_SELF_SERVICE_TIMECARD dependencies on FND_DATE

Line 201: fnd_date.date_to_canonical (hr_general.end_of_time)

197: WHILE l_index_detail IS NOT NULL -- (While Loop)
198: LOOP
199: IF (p_timecard_blocks (l_index_detail).SCOPE = 'DETAIL'
200: AND p_timecard_blocks (l_index_detail).date_to =
201: fnd_date.date_to_canonical (hr_general.end_of_time)
202: )
203: THEN
204:
205: -- Get all the ATTRIBUTES for this DETAIL Building Block into a Temp Table

Line 235: fnd_date.date_to_canonical (hr_general.end_of_time)

231: WHILE l_zero_hrs_index_detail IS NOT NULL -- (While Loop)
232: LOOP
233: IF (p_zero_template_blocks (l_zero_hrs_index_detail).SCOPE = 'DETAIL'
234: AND p_zero_template_blocks (l_zero_hrs_index_detail).date_to =
235: fnd_date.date_to_canonical (hr_general.end_of_time)
236: ) AND (NOT l_del_bb_ids.EXISTS(p_zero_template_blocks (l_zero_hrs_index_detail).TIME_BUILDING_BLOCK_ID))
237: THEN
238: -- Initialize the Temp Attribute Table
239: if(l_zero_hrs_temp_dtl_attr.count>0) then

Line 638: l_first_day := fnd_date.canonical_to_date (p_start_time);

634: l_proc := 'modify_to_zero_hrs_template';
635: hr_utility.set_location (g_package || l_proc, 120);
636: END IF;
637: -- Get the range calculated
638: l_first_day := fnd_date.canonical_to_date (p_start_time);
639: --
640: -- Get the Time Building Block ID and OVN for the first day
641: --
642: IF g_debug THEN

Line 696: fnd_date.date_to_canonical (l_first_day)

692: WHILE l_index_day IS NOT NULL
693: LOOP
694: IF ( p_block_array (l_index_day).SCOPE = 'DAY'
695: AND p_block_array (l_index_day).start_time =
696: fnd_date.date_to_canonical (l_first_day)
697: AND p_block_array (l_index_day).date_to =
698: fnd_date.date_to_canonical (hr_general.end_of_time)
699: )
700: THEN

Line 698: fnd_date.date_to_canonical (hr_general.end_of_time)

694: IF ( p_block_array (l_index_day).SCOPE = 'DAY'
695: AND p_block_array (l_index_day).start_time =
696: fnd_date.date_to_canonical (l_first_day)
697: AND p_block_array (l_index_day).date_to =
698: fnd_date.date_to_canonical (hr_general.end_of_time)
699: )
700: THEN
701: -- Store the info in local variables
702: l_day_one_time_bb_id :=p_block_array (l_index_day).TIME_BUILDING_BLOCK_ID;

Line 726: fnd_date.date_to_canonical (hr_general.end_of_time)

722: WHILE l_index_detail IS NOT NULL
723: LOOP
724: IF ( p_block_array (l_index_detail).SCOPE = 'DETAIL'
725: AND p_block_array (l_index_detail).date_to =
726: fnd_date.date_to_canonical (hr_general.end_of_time)
727: AND p_block_array (l_index_detail).PARENT_BUILDING_BLOCK_ID <>
728: l_day_one_time_bb_id
729: -- AND p_block_array (l_index_detail).PARENT_BUILDING_BLOCK_OVN <>
730: -- l_day_one_ovn

Line 815: fnd_date.date_to_canonical (hr_general.end_of_time)

811: WHILE l_index_detail IS NOT NULL -- (Main Processing)
812: LOOP
813: IF ( p_block_array (l_index_detail).SCOPE = 'DETAIL'
814: AND p_block_array (l_index_detail).date_to =
815: fnd_date.date_to_canonical (hr_general.end_of_time)
816: )
817: THEN
818:
819: -- Get all the ATTRIBUTES for this DETAIL Building Block into a Temp Table

Line 874: fnd_date.date_to_canonical (hr_general.end_of_time)

870: WHILE l_sub_index_detail IS NOT NULL -- (Sub Processing)
871: LOOP
872: IF ( p_block_array (l_sub_index_detail).SCOPE = 'DETAIL'
873: AND p_block_array (l_sub_index_detail).date_to =
874: fnd_date.date_to_canonical (hr_general.end_of_time)
875: AND p_block_array(l_sub_index_detail).time_building_block_id <>
876: p_block_array(l_index_detail).time_building_block_id
877:
878: )

Line 1116: p_block_array(l_index_detail).START_TIME := fnd_date.date_to_canonical(l_first_day);

1112: if ((p_block_array(l_index_detail).START_TIME is not null) OR
1113: (p_block_array(l_index_detail).STOP_TIME is not null)
1114: )
1115: then
1116: p_block_array(l_index_detail).START_TIME := fnd_date.date_to_canonical(l_first_day);
1117: p_block_array(l_index_detail).STOP_TIME := fnd_date.date_to_canonical(l_first_day);
1118: p_block_array(l_index_detail).TRANSLATION_DISPLAY_KEY :=
1119: hxc_trans_display_key_utils.reset_column_index_to_zero(p_block_array(l_index_detail).translation_display_key);
1120:

Line 1117: p_block_array(l_index_detail).STOP_TIME := fnd_date.date_to_canonical(l_first_day);

1113: (p_block_array(l_index_detail).STOP_TIME is not null)
1114: )
1115: then
1116: p_block_array(l_index_detail).START_TIME := fnd_date.date_to_canonical(l_first_day);
1117: p_block_array(l_index_detail).STOP_TIME := fnd_date.date_to_canonical(l_first_day);
1118: p_block_array(l_index_detail).TRANSLATION_DISPLAY_KEY :=
1119: hxc_trans_display_key_utils.reset_column_index_to_zero(p_block_array(l_index_detail).translation_display_key);
1120:
1121: IF (p_clear_comment = 'Y') THEN

Line 1216: AND p_block_array(l_index_detail).DATE_TO = fnd_date.date_to_canonical (hr_general.end_of_time)

1212: LOOP
1213: EXIT WHEN NOT p_block_array.exists(l_index_detail);
1214:
1215: IF p_block_array(l_index_detail).SCOPE = 'DETAIL'
1216: AND p_block_array(l_index_detail).DATE_TO = fnd_date.date_to_canonical (hr_general.end_of_time)
1217: THEN
1218:
1219: IF g_debug THEN
1220: hr_utility.trace('p_block_array(l_index_detail).TIME_BUILDING_BLOCK_ID ::'||p_block_array(l_index_detail).TIME_BUILDING_BLOCK_ID );

Line 2018: p_blocks(l_block_index).DATE_FROM := fnd_date.date_to_canonical(SYSDATE);

2014: p_blocks(l_block_index).APPROVAL_STATUS := p_approval_status;
2015: p_blocks(l_block_index).RESOURCE_ID := p_resource_id;
2016: p_blocks(l_block_index).RESOURCE_TYPE := 'PERSON';
2017: p_blocks(l_block_index).APPROVAL_STYLE_ID := p_approval_style;
2018: p_blocks(l_block_index).DATE_FROM := fnd_date.date_to_canonical(SYSDATE);
2019: p_blocks(l_block_index).DATE_TO := fnd_date.date_to_canonical(hr_general.end_of_time);
2020: p_blocks(l_block_index).PARENT_BUILDING_BLOCK_OVN := 1;
2021: p_blocks(l_block_index).NEW := 'Y';
2022:

Line 2019: p_blocks(l_block_index).DATE_TO := fnd_date.date_to_canonical(hr_general.end_of_time);

2015: p_blocks(l_block_index).RESOURCE_ID := p_resource_id;
2016: p_blocks(l_block_index).RESOURCE_TYPE := 'PERSON';
2017: p_blocks(l_block_index).APPROVAL_STYLE_ID := p_approval_style;
2018: p_blocks(l_block_index).DATE_FROM := fnd_date.date_to_canonical(SYSDATE);
2019: p_blocks(l_block_index).DATE_TO := fnd_date.date_to_canonical(hr_general.end_of_time);
2020: p_blocks(l_block_index).PARENT_BUILDING_BLOCK_OVN := 1;
2021: p_blocks(l_block_index).NEW := 'Y';
2022:
2023: IF p_blocks(l_block_index).SCOPE = 'TIMECARD'

Line 2028: fnd_date.canonical_to_date(p_blocks(l_block_index).STOP_TIME),'YYYY/MM/DD')

2024: THEN
2025: p_timecard_id := p_blocks(l_block_index).TIME_BUILDING_BLOCK_ID;
2026: p_timecard_found := TRUE;
2027: p_blocks(l_block_index).STOP_TIME := to_char(
2028: fnd_date.canonical_to_date(p_blocks(l_block_index).STOP_TIME),'YYYY/MM/DD')
2029: || ' 23:59:59'; --fnd_date.date_to_canonical(SYSDATE);
2030: END IF;
2031:
2032:

Line 2029: || ' 23:59:59'; --fnd_date.date_to_canonical(SYSDATE);

2025: p_timecard_id := p_blocks(l_block_index).TIME_BUILDING_BLOCK_ID;
2026: p_timecard_found := TRUE;
2027: p_blocks(l_block_index).STOP_TIME := to_char(
2028: fnd_date.canonical_to_date(p_blocks(l_block_index).STOP_TIME),'YYYY/MM/DD')
2029: || ' 23:59:59'; --fnd_date.date_to_canonical(SYSDATE);
2030: END IF;
2031:
2032:
2033: IF p_blocks(l_block_index).SCOPE = 'DAY'

Line 2036: fnd_date.canonical_to_date(p_blocks(l_block_index).STOP_TIME),'YYYY/MM/DD')

2032:
2033: IF p_blocks(l_block_index).SCOPE = 'DAY'
2034: THEN
2035: p_blocks(l_block_index).STOP_TIME := to_char(
2036: fnd_date.canonical_to_date(p_blocks(l_block_index).STOP_TIME),'YYYY/MM/DD')
2037: || ' 23:59:59'; --fnd_date.date_to_canonical(SYSDATE);
2038: END IF;
2039:
2040: l_block_index := p_blocks.next(l_block_index);

Line 2037: || ' 23:59:59'; --fnd_date.date_to_canonical(SYSDATE);

2033: IF p_blocks(l_block_index).SCOPE = 'DAY'
2034: THEN
2035: p_blocks(l_block_index).STOP_TIME := to_char(
2036: fnd_date.canonical_to_date(p_blocks(l_block_index).STOP_TIME),'YYYY/MM/DD')
2037: || ' 23:59:59'; --fnd_date.date_to_canonical(SYSDATE);
2038: END IF;
2039:
2040: l_block_index := p_blocks.next(l_block_index);
2041: END LOOP;

Line 2066: l_date_to := fnd_date.canonical_to_date(p_blocks(l_block_index).DATE_TO);

2062: IF p_blocks(l_block_index).DATE_TO IS NULL
2063: THEN
2064: l_date_to := hr_general.end_of_time;
2065: ELSE
2066: l_date_to := fnd_date.canonical_to_date(p_blocks(l_block_index).DATE_TO);
2067: END IF;
2068:
2069: IF p_new_block.SCOPE = 'TIMECARD'
2070: THEN

Line 2085: AND TRUNC(fnd_date.canonical_to_date(p_blocks(l_block_index).START_TIME))

2081: IF p_blocks(l_block_index).SCOPE = 'DAY'
2082: --array AND NVL(p_blocks(l_block_index).DATE_TO, hr_general.end_of_time) = hr_general.end_of_time
2083: --array AND TRUNC(p_blocks(l_block_index).START_TIME) = TRUNC(p_new_block.START_TIME)
2084: AND l_date_to = hr_general.end_of_time
2085: AND TRUNC(fnd_date.canonical_to_date(p_blocks(l_block_index).START_TIME))
2086: = TRUNC(fnd_date.canonical_to_date(p_new_block.START_TIME))
2087: THEN
2088: p_index := l_block_index;
2089: p_found := TRUE;

Line 2086: = TRUNC(fnd_date.canonical_to_date(p_new_block.START_TIME))

2082: --array AND NVL(p_blocks(l_block_index).DATE_TO, hr_general.end_of_time) = hr_general.end_of_time
2083: --array AND TRUNC(p_blocks(l_block_index).START_TIME) = TRUNC(p_new_block.START_TIME)
2084: AND l_date_to = hr_general.end_of_time
2085: AND TRUNC(fnd_date.canonical_to_date(p_blocks(l_block_index).START_TIME))
2086: = TRUNC(fnd_date.canonical_to_date(p_new_block.START_TIME))
2087: THEN
2088: p_index := l_block_index;
2089: p_found := TRUE;
2090: RETURN;

Line 2236: ,p_start_time => FND_DATE.CANONICAL_TO_DATE(p_start_time)

2232:
2233: HXC_ALIAS_TRANSLATOR.do_retrieval_translation(
2234: p_attributes => p_attribute_array
2235: ,p_blocks => p_block_array
2236: ,p_start_time => FND_DATE.CANONICAL_TO_DATE(p_start_time)
2237: ,p_stop_time => FND_DATE.CANONICAL_TO_DATE(p_stop_time)
2238: ,p_resource_id => p_resource_id
2239: ,p_messages => l_messages
2240: );

Line 2237: ,p_stop_time => FND_DATE.CANONICAL_TO_DATE(p_stop_time)

2233: HXC_ALIAS_TRANSLATOR.do_retrieval_translation(
2234: p_attributes => p_attribute_array
2235: ,p_blocks => p_block_array
2236: ,p_start_time => FND_DATE.CANONICAL_TO_DATE(p_start_time)
2237: ,p_stop_time => FND_DATE.CANONICAL_TO_DATE(p_stop_time)
2238: ,p_resource_id => p_resource_id
2239: ,p_messages => l_messages
2240: );
2241:

Line 2284: l_new_start_time := fnd_date.canonical_to_date (p_start_time);

2280: l_proc := 'chk_all_days_in_block';
2281: hr_utility.set_location (g_package || l_proc, 120);
2282: END IF;
2283: -- Get the range calculated
2284: l_new_start_time := fnd_date.canonical_to_date (p_start_time);
2285: l_new_stop_time := fnd_date.canonical_to_date (p_stop_time);
2286: l_num_days := l_new_stop_time - l_new_start_time;
2287:
2288: -- Loop for the total number of days in the time period.

Line 2285: l_new_stop_time := fnd_date.canonical_to_date (p_stop_time);

2281: hr_utility.set_location (g_package || l_proc, 120);
2282: END IF;
2283: -- Get the range calculated
2284: l_new_start_time := fnd_date.canonical_to_date (p_start_time);
2285: l_new_stop_time := fnd_date.canonical_to_date (p_stop_time);
2286: l_num_days := l_new_stop_time - l_new_start_time;
2287:
2288: -- Loop for the total number of days in the time period.
2289: WHILE l_num_days <> -1

Line 2300: fnd_date.date_to_canonical (l_new_start_time)

2296: WHILE l_index_day IS NOT NULL
2297: LOOP
2298: IF ( p_block_array (l_index_day).SCOPE = 'DAY'
2299: AND p_block_array (l_index_day).start_time =
2300: fnd_date.date_to_canonical (l_new_start_time)
2301: AND p_block_array (l_index_day).date_to =
2302: fnd_date.date_to_canonical (hr_general.end_of_time)
2303: AND p_block_array (l_index_day).object_version_number <> -99999
2304: )

Line 2302: fnd_date.date_to_canonical (hr_general.end_of_time)

2298: IF ( p_block_array (l_index_day).SCOPE = 'DAY'
2299: AND p_block_array (l_index_day).start_time =
2300: fnd_date.date_to_canonical (l_new_start_time)
2301: AND p_block_array (l_index_day).date_to =
2302: fnd_date.date_to_canonical (hr_general.end_of_time)
2303: AND p_block_array (l_index_day).object_version_number <> -99999
2304: )
2305: THEN
2306: l_day_exists := TRUE ;

Line 2326: fnd_date.date_to_canonical (hr_general.end_of_time)

2322: WHILE l_cache_index IS NOT NULL
2323: LOOP
2324: IF ( p_block_array (l_cache_index).SCOPE = 'DAY'
2325: AND p_block_array (l_cache_index).date_to =
2326: fnd_date.date_to_canonical (hr_general.end_of_time)
2327: )
2328: THEN
2329: l_blocks.EXTEND;
2330: l_blocks (1) := p_block_array (l_cache_index);

Line 2363: fnd_date.date_to_canonical (l_new_start_time),

2359: l_next_block_id,
2360: l_blocks (1).TYPE,
2361: l_blocks (1).measure,
2362: l_blocks (1).unit_of_measure,
2363: fnd_date.date_to_canonical (l_new_start_time),
2364: TO_CHAR (l_new_start_time, 'YYYY/MM/DD') || ' 23:59:59',
2365: l_blocks (1).parent_building_block_id,
2366: l_blocks (1).parent_is_new,
2367: l_blocks (1).SCOPE,

Line 2525: l_complete_blocks(l_block_index).DATE_TO := fnd_date.date_to_canonical(sysdate);

2521: l_block_index := l_complete_blocks.first;
2522: LOOP
2523: EXIT WHEN NOT l_complete_blocks.exists(l_block_index);
2524:
2525: l_complete_blocks(l_block_index).DATE_TO := fnd_date.date_to_canonical(sysdate);
2526:
2527: l_block_index := l_complete_blocks.next(l_block_index);
2528: END LOOP;
2529:

Line 2962: ,fnd_date.date_to_canonical(p_blocks(l_block_index).START_TIME)

2958: p_blocks(l_block_index).TIME_BUILDING_BLOCK_ID
2959: ,p_blocks(l_block_index).TYPE
2960: ,p_blocks(l_block_index).MEASURE
2961: ,p_blocks(l_block_index).UNIT_OF_MEASURE
2962: ,fnd_date.date_to_canonical(p_blocks(l_block_index).START_TIME)
2963: ,fnd_date.date_to_canonical(p_blocks(l_block_index).STOP_TIME)
2964: ,p_blocks(l_block_index).PARENT_BUILDING_BLOCK_ID
2965: ,p_blocks(l_block_index).PARENT_IS_NEW
2966: ,p_blocks(l_block_index).SCOPE

Line 2963: ,fnd_date.date_to_canonical(p_blocks(l_block_index).STOP_TIME)

2959: ,p_blocks(l_block_index).TYPE
2960: ,p_blocks(l_block_index).MEASURE
2961: ,p_blocks(l_block_index).UNIT_OF_MEASURE
2962: ,fnd_date.date_to_canonical(p_blocks(l_block_index).START_TIME)
2963: ,fnd_date.date_to_canonical(p_blocks(l_block_index).STOP_TIME)
2964: ,p_blocks(l_block_index).PARENT_BUILDING_BLOCK_ID
2965: ,p_blocks(l_block_index).PARENT_IS_NEW
2966: ,p_blocks(l_block_index).SCOPE
2967: ,p_blocks(l_block_index).OBJECT_VERSION_NUMBER

Line 2972: ,fnd_date.date_to_canonical(p_blocks(l_block_index).DATE_FROM)

2968: ,p_blocks(l_block_index).APPROVAL_STATUS
2969: ,p_blocks(l_block_index).RESOURCE_ID
2970: ,p_blocks(l_block_index).RESOURCE_TYPE
2971: ,p_blocks(l_block_index).APPROVAL_STYLE_ID
2972: ,fnd_date.date_to_canonical(p_blocks(l_block_index).DATE_FROM)
2973: ,fnd_date.date_to_canonical(p_blocks(l_block_index).DATE_TO)
2974: ,p_blocks(l_block_index).COMMENT_TEXT
2975: ,p_blocks(l_block_index).PARENT_BUILDING_BLOCK_OVN
2976: ,p_blocks(l_block_index).NEW

Line 2973: ,fnd_date.date_to_canonical(p_blocks(l_block_index).DATE_TO)

2969: ,p_blocks(l_block_index).RESOURCE_ID
2970: ,p_blocks(l_block_index).RESOURCE_TYPE
2971: ,p_blocks(l_block_index).APPROVAL_STYLE_ID
2972: ,fnd_date.date_to_canonical(p_blocks(l_block_index).DATE_FROM)
2973: ,fnd_date.date_to_canonical(p_blocks(l_block_index).DATE_TO)
2974: ,p_blocks(l_block_index).COMMENT_TEXT
2975: ,p_blocks(l_block_index).PARENT_BUILDING_BLOCK_OVN
2976: ,p_blocks(l_block_index).NEW
2977: ,p_blocks(l_block_index).CHANGED

Line 3483: l_blocks(1).START_TIME := fnd_date.date_to_canonical(l_new_start_time);

3479: --
3480: -- Using new routine, we know the first block is the top-level block
3481: -- which might be a timecard or a timecard-template.
3482: --
3483: l_blocks(1).START_TIME := fnd_date.date_to_canonical(l_new_start_time);
3484: -- joel asked for this stop time set like this!
3485: l_blocks(1).STOP_TIME := to_char(l_new_stop_time, 'YYYY/MM/DD') || ' 23:59:59';
3486: l_blocks(1).SCOPE := 'TIMECARD';
3487:

Line 3490: l_blocks(l_block_index).DATE_FROM := fnd_date.date_to_canonical(SYSDATE);

3486: l_blocks(1).SCOPE := 'TIMECARD';
3487:
3488: FOR l_block_index IN 1..l_blocks.count LOOP
3489: IF l_blocks.exists(l_block_index) THEN
3490: l_blocks(l_block_index).DATE_FROM := fnd_date.date_to_canonical(SYSDATE);
3491: l_blocks(l_block_index).DATE_TO := fnd_date.date_to_canonical(hr_general.end_of_time);
3492: l_blocks(l_block_index).RESOURCE_ID := p_resource_id;
3493: l_blocks(l_block_index).RESOURCE_TYPE := p_resource_type;
3494: l_blocks(l_block_index).OBJECT_VERSION_NUMBER := 1;

Line 3491: l_blocks(l_block_index).DATE_TO := fnd_date.date_to_canonical(hr_general.end_of_time);

3487:
3488: FOR l_block_index IN 1..l_blocks.count LOOP
3489: IF l_blocks.exists(l_block_index) THEN
3490: l_blocks(l_block_index).DATE_FROM := fnd_date.date_to_canonical(SYSDATE);
3491: l_blocks(l_block_index).DATE_TO := fnd_date.date_to_canonical(hr_general.end_of_time);
3492: l_blocks(l_block_index).RESOURCE_ID := p_resource_id;
3493: l_blocks(l_block_index).RESOURCE_TYPE := p_resource_type;
3494: l_blocks(l_block_index).OBJECT_VERSION_NUMBER := 1;
3495: l_blocks(l_block_index).new := hxc_timecard.c_yes;

Line 3515: l_difference := fnd_date.canonical_to_date(l_blocks(l_block_index).START_TIME)

3511: END IF;
3512:
3513: IF l_blocks(l_block_index).SCOPE = 'DAY'
3514: THEN
3515: l_difference := fnd_date.canonical_to_date(l_blocks(l_block_index).START_TIME)
3516: - l_old_start_time;
3517: l_start_time := l_new_start_time + l_difference;
3518:
3519: IF l_start_time > l_new_stop_time

Line 3546: l_blocks(l_block_index).START_TIME := fnd_date.date_to_canonical(l_start_time);

3542: p_block_index => l_block_index
3543: );
3544:
3545: ELSE
3546: l_blocks(l_block_index).START_TIME := fnd_date.date_to_canonical(l_start_time);
3547: l_blocks(l_block_index).STOP_TIME := TO_CHAR(l_start_time, 'YYYY/MM/DD')
3548: || ' 23:59:59';
3549:
3550: l_blocks(l_block_index).PARENT_IS_NEW := 'Y';

Line 3562: fnd_date.canonical_to_date(l_blocks(l_second_block_index).START_TIME)

3558: IF l_blocks(l_second_block_index).START_TIME IS NOT NULL
3559: THEN
3560:
3561: l_detail_start_date :=
3562: fnd_date.canonical_to_date(l_blocks(l_second_block_index).START_TIME)
3563: - l_old_start_time + l_new_start_time;
3564: l_blocks(l_second_block_index).START_TIME :=
3565: TO_CHAR(l_detail_start_date, 'YYYY/MM/DD')
3566: || TO_CHAR(

Line 3571: fnd_date.canonical_to_date(l_blocks(l_second_block_index).STOP_TIME)

3567: TO_DATE(l_blocks(l_second_block_index).START_TIME, 'YYYY/MM/DD HH24:MI:SS'),
3568: ' HH24:MI:SS');
3569:
3570: l_detail_stop_date :=
3571: fnd_date.canonical_to_date(l_blocks(l_second_block_index).STOP_TIME)
3572: - l_old_start_time + l_new_start_time;
3573:
3574: l_blocks(l_second_block_index).STOP_TIME :=
3575: TO_CHAR(l_detail_stop_date, 'YYYY/MM/DD')

Line 3929: ,p_start_time => FND_DATE.CANONICAL_TO_DATE(p_start_time)

3925:
3926: HXC_ALIAS_TRANSLATOR.do_retrieval_translation(
3927: p_attributes => p_attribute_array
3928: ,p_blocks => p_block_array
3929: ,p_start_time => FND_DATE.CANONICAL_TO_DATE(p_start_time)
3930: ,p_stop_time => FND_DATE.CANONICAL_TO_DATE(p_stop_time)
3931: ,p_resource_id => l_resource_id
3932: ,p_messages => l_messages_table
3933: );

Line 3930: ,p_stop_time => FND_DATE.CANONICAL_TO_DATE(p_stop_time)

3926: HXC_ALIAS_TRANSLATOR.do_retrieval_translation(
3927: p_attributes => p_attribute_array
3928: ,p_blocks => p_block_array
3929: ,p_start_time => FND_DATE.CANONICAL_TO_DATE(p_start_time)
3930: ,p_stop_time => FND_DATE.CANONICAL_TO_DATE(p_stop_time)
3931: ,p_resource_id => l_resource_id
3932: ,p_messages => l_messages_table
3933: );
3934:

Line 4372: p_start_time => substrb(fnd_date.date_to_canonical(p_start_time),1,10),

4368:
4369: if(p_blocks is not null) then
4370: translate_alias_timecards
4371: (p_resource_id => p_blocks(1).resource_id,
4372: p_start_time => substrb(fnd_date.date_to_canonical(p_start_time),1,10),
4373: p_stop_time => substrb(fnd_date.date_to_canonical(p_stop_time),1,10),
4374: p_block_array => p_blocks,
4375: p_attribute_array => p_attributes
4376: );

Line 4373: p_stop_time => substrb(fnd_date.date_to_canonical(p_stop_time),1,10),

4369: if(p_blocks is not null) then
4370: translate_alias_timecards
4371: (p_resource_id => p_blocks(1).resource_id,
4372: p_start_time => substrb(fnd_date.date_to_canonical(p_start_time),1,10),
4373: p_stop_time => substrb(fnd_date.date_to_canonical(p_stop_time),1,10),
4374: p_block_array => p_blocks,
4375: p_attribute_array => p_attributes
4376: );
4377: end if;