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 635: l_first_day := fnd_date.canonical_to_date (p_start_time);

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

Line 647: fnd_date.date_to_canonical (l_first_day)

643: WHILE l_index_day IS NOT NULL
644: LOOP
645: IF ( p_block_array (l_index_day).SCOPE = 'DAY'
646: AND p_block_array (l_index_day).start_time =
647: fnd_date.date_to_canonical (l_first_day)
648: AND p_block_array (l_index_day).date_to =
649: fnd_date.date_to_canonical (hr_general.end_of_time)
650: )
651: THEN

Line 649: fnd_date.date_to_canonical (hr_general.end_of_time)

645: IF ( p_block_array (l_index_day).SCOPE = 'DAY'
646: AND p_block_array (l_index_day).start_time =
647: fnd_date.date_to_canonical (l_first_day)
648: AND p_block_array (l_index_day).date_to =
649: fnd_date.date_to_canonical (hr_general.end_of_time)
650: )
651: THEN
652: -- Store the info in local variables
653: l_day_one_time_bb_id :=p_block_array (l_index_day).TIME_BUILDING_BLOCK_ID;

Line 673: fnd_date.date_to_canonical (hr_general.end_of_time)

669: WHILE l_index_detail IS NOT NULL
670: LOOP
671: IF ( p_block_array (l_index_detail).SCOPE = 'DETAIL'
672: AND p_block_array (l_index_detail).date_to =
673: fnd_date.date_to_canonical (hr_general.end_of_time)
674: AND p_block_array (l_index_detail).PARENT_BUILDING_BLOCK_ID <>
675: l_day_one_time_bb_id
676: -- AND p_block_array (l_index_detail).PARENT_BUILDING_BLOCK_OVN <>
677: -- l_day_one_ovn

Line 731: fnd_date.date_to_canonical (hr_general.end_of_time)

727: WHILE l_index_detail IS NOT NULL -- (Main Processing)
728: LOOP
729: IF ( p_block_array (l_index_detail).SCOPE = 'DETAIL'
730: AND p_block_array (l_index_detail).date_to =
731: fnd_date.date_to_canonical (hr_general.end_of_time)
732: )
733: THEN
734:
735: -- Get all the ATTRIBUTES for this DETAIL Building Block into a Temp Table

Line 790: fnd_date.date_to_canonical (hr_general.end_of_time)

786: WHILE l_sub_index_detail IS NOT NULL -- (Sub Processing)
787: LOOP
788: IF ( p_block_array (l_sub_index_detail).SCOPE = 'DETAIL'
789: AND p_block_array (l_sub_index_detail).date_to =
790: fnd_date.date_to_canonical (hr_general.end_of_time)
791: AND p_block_array(l_sub_index_detail).time_building_block_id <>
792: p_block_array(l_index_detail).time_building_block_id
793:
794: )

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

1009: if ((p_block_array(l_index_detail).START_TIME is not null) OR
1010: (p_block_array(l_index_detail).STOP_TIME is not null)
1011: )
1012: then
1013: p_block_array(l_index_detail).START_TIME := fnd_date.date_to_canonical(l_first_day);
1014: p_block_array(l_index_detail).STOP_TIME := fnd_date.date_to_canonical(l_first_day);
1015: p_block_array(l_index_detail).TRANSLATION_DISPLAY_KEY :=
1016: hxc_trans_display_key_utils.reset_column_index_to_zero(p_block_array(l_index_detail).translation_display_key);
1017:

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

1010: (p_block_array(l_index_detail).STOP_TIME is not null)
1011: )
1012: then
1013: p_block_array(l_index_detail).START_TIME := fnd_date.date_to_canonical(l_first_day);
1014: p_block_array(l_index_detail).STOP_TIME := fnd_date.date_to_canonical(l_first_day);
1015: p_block_array(l_index_detail).TRANSLATION_DISPLAY_KEY :=
1016: hxc_trans_display_key_utils.reset_column_index_to_zero(p_block_array(l_index_detail).translation_display_key);
1017:
1018: IF (p_clear_comment = 'Y') THEN

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

1716: p_blocks(l_block_index).APPROVAL_STATUS := p_approval_status;
1717: p_blocks(l_block_index).RESOURCE_ID := p_resource_id;
1718: p_blocks(l_block_index).RESOURCE_TYPE := 'PERSON';
1719: p_blocks(l_block_index).APPROVAL_STYLE_ID := p_approval_style;
1720: p_blocks(l_block_index).DATE_FROM := fnd_date.date_to_canonical(SYSDATE);
1721: p_blocks(l_block_index).DATE_TO := fnd_date.date_to_canonical(hr_general.end_of_time);
1722: p_blocks(l_block_index).PARENT_BUILDING_BLOCK_OVN := 1;
1723: p_blocks(l_block_index).NEW := 'Y';
1724:

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

1717: p_blocks(l_block_index).RESOURCE_ID := p_resource_id;
1718: p_blocks(l_block_index).RESOURCE_TYPE := 'PERSON';
1719: p_blocks(l_block_index).APPROVAL_STYLE_ID := p_approval_style;
1720: p_blocks(l_block_index).DATE_FROM := fnd_date.date_to_canonical(SYSDATE);
1721: p_blocks(l_block_index).DATE_TO := fnd_date.date_to_canonical(hr_general.end_of_time);
1722: p_blocks(l_block_index).PARENT_BUILDING_BLOCK_OVN := 1;
1723: p_blocks(l_block_index).NEW := 'Y';
1724:
1725: IF p_blocks(l_block_index).SCOPE = 'TIMECARD'

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

1726: THEN
1727: p_timecard_id := p_blocks(l_block_index).TIME_BUILDING_BLOCK_ID;
1728: p_timecard_found := TRUE;
1729: p_blocks(l_block_index).STOP_TIME := to_char(
1730: fnd_date.canonical_to_date(p_blocks(l_block_index).STOP_TIME),'YYYY/MM/DD')
1731: || ' 23:59:59'; --fnd_date.date_to_canonical(SYSDATE);
1732: END IF;
1733:
1734:

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

1727: p_timecard_id := p_blocks(l_block_index).TIME_BUILDING_BLOCK_ID;
1728: p_timecard_found := TRUE;
1729: p_blocks(l_block_index).STOP_TIME := to_char(
1730: fnd_date.canonical_to_date(p_blocks(l_block_index).STOP_TIME),'YYYY/MM/DD')
1731: || ' 23:59:59'; --fnd_date.date_to_canonical(SYSDATE);
1732: END IF;
1733:
1734:
1735: IF p_blocks(l_block_index).SCOPE = 'DAY'

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

1734:
1735: IF p_blocks(l_block_index).SCOPE = 'DAY'
1736: THEN
1737: p_blocks(l_block_index).STOP_TIME := to_char(
1738: fnd_date.canonical_to_date(p_blocks(l_block_index).STOP_TIME),'YYYY/MM/DD')
1739: || ' 23:59:59'; --fnd_date.date_to_canonical(SYSDATE);
1740: END IF;
1741:
1742: l_block_index := p_blocks.next(l_block_index);

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

1735: IF p_blocks(l_block_index).SCOPE = 'DAY'
1736: THEN
1737: p_blocks(l_block_index).STOP_TIME := to_char(
1738: fnd_date.canonical_to_date(p_blocks(l_block_index).STOP_TIME),'YYYY/MM/DD')
1739: || ' 23:59:59'; --fnd_date.date_to_canonical(SYSDATE);
1740: END IF;
1741:
1742: l_block_index := p_blocks.next(l_block_index);
1743: END LOOP;

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

1764: IF p_blocks(l_block_index).DATE_TO IS NULL
1765: THEN
1766: l_date_to := hr_general.end_of_time;
1767: ELSE
1768: l_date_to := fnd_date.canonical_to_date(p_blocks(l_block_index).DATE_TO);
1769: END IF;
1770:
1771: IF p_new_block.SCOPE = 'TIMECARD'
1772: THEN

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

1783: IF p_blocks(l_block_index).SCOPE = 'DAY'
1784: --array AND NVL(p_blocks(l_block_index).DATE_TO, hr_general.end_of_time) = hr_general.end_of_time
1785: --array AND TRUNC(p_blocks(l_block_index).START_TIME) = TRUNC(p_new_block.START_TIME)
1786: AND l_date_to = hr_general.end_of_time
1787: AND TRUNC(fnd_date.canonical_to_date(p_blocks(l_block_index).START_TIME))
1788: = TRUNC(fnd_date.canonical_to_date(p_new_block.START_TIME))
1789: THEN
1790: p_index := l_block_index;
1791: p_found := TRUE;

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

1784: --array AND NVL(p_blocks(l_block_index).DATE_TO, hr_general.end_of_time) = hr_general.end_of_time
1785: --array AND TRUNC(p_blocks(l_block_index).START_TIME) = TRUNC(p_new_block.START_TIME)
1786: AND l_date_to = hr_general.end_of_time
1787: AND TRUNC(fnd_date.canonical_to_date(p_blocks(l_block_index).START_TIME))
1788: = TRUNC(fnd_date.canonical_to_date(p_new_block.START_TIME))
1789: THEN
1790: p_index := l_block_index;
1791: p_found := TRUE;
1792: RETURN;

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

1934:
1935: HXC_ALIAS_TRANSLATOR.do_retrieval_translation(
1936: p_attributes => p_attribute_array
1937: ,p_blocks => p_block_array
1938: ,p_start_time => FND_DATE.CANONICAL_TO_DATE(p_start_time)
1939: ,p_stop_time => FND_DATE.CANONICAL_TO_DATE(p_stop_time)
1940: ,p_resource_id => p_resource_id
1941: ,p_messages => l_messages
1942: );

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

1935: HXC_ALIAS_TRANSLATOR.do_retrieval_translation(
1936: p_attributes => p_attribute_array
1937: ,p_blocks => p_block_array
1938: ,p_start_time => FND_DATE.CANONICAL_TO_DATE(p_start_time)
1939: ,p_stop_time => FND_DATE.CANONICAL_TO_DATE(p_stop_time)
1940: ,p_resource_id => p_resource_id
1941: ,p_messages => l_messages
1942: );
1943:

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

1982: l_proc := 'chk_all_days_in_block';
1983: hr_utility.set_location (g_package || l_proc, 120);
1984: END IF;
1985: -- Get the range calculated
1986: l_new_start_time := fnd_date.canonical_to_date (p_start_time);
1987: l_new_stop_time := fnd_date.canonical_to_date (p_stop_time);
1988: l_num_days := l_new_stop_time - l_new_start_time;
1989:
1990: -- Loop for the total number of days in the time period.

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

1983: hr_utility.set_location (g_package || l_proc, 120);
1984: END IF;
1985: -- Get the range calculated
1986: l_new_start_time := fnd_date.canonical_to_date (p_start_time);
1987: l_new_stop_time := fnd_date.canonical_to_date (p_stop_time);
1988: l_num_days := l_new_stop_time - l_new_start_time;
1989:
1990: -- Loop for the total number of days in the time period.
1991: WHILE l_num_days <> -1

Line 2002: fnd_date.date_to_canonical (l_new_start_time)

1998: WHILE l_index_day IS NOT NULL
1999: LOOP
2000: IF ( p_block_array (l_index_day).SCOPE = 'DAY'
2001: AND p_block_array (l_index_day).start_time =
2002: fnd_date.date_to_canonical (l_new_start_time)
2003: AND p_block_array (l_index_day).date_to =
2004: fnd_date.date_to_canonical (hr_general.end_of_time)
2005: AND p_block_array (l_index_day).object_version_number <> -99999
2006: )

Line 2004: fnd_date.date_to_canonical (hr_general.end_of_time)

2000: IF ( p_block_array (l_index_day).SCOPE = 'DAY'
2001: AND p_block_array (l_index_day).start_time =
2002: fnd_date.date_to_canonical (l_new_start_time)
2003: AND p_block_array (l_index_day).date_to =
2004: fnd_date.date_to_canonical (hr_general.end_of_time)
2005: AND p_block_array (l_index_day).object_version_number <> -99999
2006: )
2007: THEN
2008: l_day_exists := TRUE ;

Line 2028: fnd_date.date_to_canonical (hr_general.end_of_time)

2024: WHILE l_cache_index IS NOT NULL
2025: LOOP
2026: IF ( p_block_array (l_cache_index).SCOPE = 'DAY'
2027: AND p_block_array (l_cache_index).date_to =
2028: fnd_date.date_to_canonical (hr_general.end_of_time)
2029: )
2030: THEN
2031: l_blocks.EXTEND;
2032: l_blocks (1) := p_block_array (l_cache_index);

Line 2065: fnd_date.date_to_canonical (l_new_start_time),

2061: l_next_block_id,
2062: l_blocks (1).TYPE,
2063: l_blocks (1).measure,
2064: l_blocks (1).unit_of_measure,
2065: fnd_date.date_to_canonical (l_new_start_time),
2066: TO_CHAR (l_new_start_time, 'YYYY/MM/DD') || ' 23:59:59',
2067: l_blocks (1).parent_building_block_id,
2068: l_blocks (1).parent_is_new,
2069: l_blocks (1).SCOPE,

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

2223: l_block_index := l_complete_blocks.first;
2224: LOOP
2225: EXIT WHEN NOT l_complete_blocks.exists(l_block_index);
2226:
2227: l_complete_blocks(l_block_index).DATE_TO := fnd_date.date_to_canonical(sysdate);
2228:
2229: l_block_index := l_complete_blocks.next(l_block_index);
2230: END LOOP;
2231:

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

2658: p_blocks(l_block_index).TIME_BUILDING_BLOCK_ID
2659: ,p_blocks(l_block_index).TYPE
2660: ,p_blocks(l_block_index).MEASURE
2661: ,p_blocks(l_block_index).UNIT_OF_MEASURE
2662: ,fnd_date.date_to_canonical(p_blocks(l_block_index).START_TIME)
2663: ,fnd_date.date_to_canonical(p_blocks(l_block_index).STOP_TIME)
2664: ,p_blocks(l_block_index).PARENT_BUILDING_BLOCK_ID
2665: ,p_blocks(l_block_index).PARENT_IS_NEW
2666: ,p_blocks(l_block_index).SCOPE

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

2659: ,p_blocks(l_block_index).TYPE
2660: ,p_blocks(l_block_index).MEASURE
2661: ,p_blocks(l_block_index).UNIT_OF_MEASURE
2662: ,fnd_date.date_to_canonical(p_blocks(l_block_index).START_TIME)
2663: ,fnd_date.date_to_canonical(p_blocks(l_block_index).STOP_TIME)
2664: ,p_blocks(l_block_index).PARENT_BUILDING_BLOCK_ID
2665: ,p_blocks(l_block_index).PARENT_IS_NEW
2666: ,p_blocks(l_block_index).SCOPE
2667: ,p_blocks(l_block_index).OBJECT_VERSION_NUMBER

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

2668: ,p_blocks(l_block_index).APPROVAL_STATUS
2669: ,p_blocks(l_block_index).RESOURCE_ID
2670: ,p_blocks(l_block_index).RESOURCE_TYPE
2671: ,p_blocks(l_block_index).APPROVAL_STYLE_ID
2672: ,fnd_date.date_to_canonical(p_blocks(l_block_index).DATE_FROM)
2673: ,fnd_date.date_to_canonical(p_blocks(l_block_index).DATE_TO)
2674: ,p_blocks(l_block_index).COMMENT_TEXT
2675: ,p_blocks(l_block_index).PARENT_BUILDING_BLOCK_OVN
2676: ,p_blocks(l_block_index).NEW

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

2669: ,p_blocks(l_block_index).RESOURCE_ID
2670: ,p_blocks(l_block_index).RESOURCE_TYPE
2671: ,p_blocks(l_block_index).APPROVAL_STYLE_ID
2672: ,fnd_date.date_to_canonical(p_blocks(l_block_index).DATE_FROM)
2673: ,fnd_date.date_to_canonical(p_blocks(l_block_index).DATE_TO)
2674: ,p_blocks(l_block_index).COMMENT_TEXT
2675: ,p_blocks(l_block_index).PARENT_BUILDING_BLOCK_OVN
2676: ,p_blocks(l_block_index).NEW
2677: ,p_blocks(l_block_index).CHANGED

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

3160: --
3161: -- Using new routine, we know the first block is the top-level block
3162: -- which might be a timecard or a timecard-template.
3163: --
3164: l_blocks(1).START_TIME := fnd_date.date_to_canonical(l_new_start_time);
3165: -- joel asked for this stop time set like this!
3166: l_blocks(1).STOP_TIME := to_char(l_new_stop_time, 'YYYY/MM/DD') || ' 23:59:59';
3167: l_blocks(1).SCOPE := 'TIMECARD';
3168:

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

3167: l_blocks(1).SCOPE := 'TIMECARD';
3168:
3169: FOR l_block_index IN 1..l_blocks.count LOOP
3170: IF l_blocks.exists(l_block_index) THEN
3171: l_blocks(l_block_index).DATE_FROM := fnd_date.date_to_canonical(SYSDATE);
3172: l_blocks(l_block_index).DATE_TO := fnd_date.date_to_canonical(hr_general.end_of_time);
3173: l_blocks(l_block_index).RESOURCE_ID := p_resource_id;
3174: l_blocks(l_block_index).RESOURCE_TYPE := p_resource_type;
3175: l_blocks(l_block_index).OBJECT_VERSION_NUMBER := 1;

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

3168:
3169: FOR l_block_index IN 1..l_blocks.count LOOP
3170: IF l_blocks.exists(l_block_index) THEN
3171: l_blocks(l_block_index).DATE_FROM := fnd_date.date_to_canonical(SYSDATE);
3172: l_blocks(l_block_index).DATE_TO := fnd_date.date_to_canonical(hr_general.end_of_time);
3173: l_blocks(l_block_index).RESOURCE_ID := p_resource_id;
3174: l_blocks(l_block_index).RESOURCE_TYPE := p_resource_type;
3175: l_blocks(l_block_index).OBJECT_VERSION_NUMBER := 1;
3176: l_blocks(l_block_index).new := hxc_timecard.c_yes;

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

3192: END IF;
3193:
3194: IF l_blocks(l_block_index).SCOPE = 'DAY'
3195: THEN
3196: l_difference := fnd_date.canonical_to_date(l_blocks(l_block_index).START_TIME)
3197: - l_old_start_time;
3198: l_start_time := l_new_start_time + l_difference;
3199:
3200: IF l_start_time > l_new_stop_time

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

3223: p_block_index => l_block_index
3224: );
3225:
3226: ELSE
3227: l_blocks(l_block_index).START_TIME := fnd_date.date_to_canonical(l_start_time);
3228: l_blocks(l_block_index).STOP_TIME := TO_CHAR(l_start_time, 'YYYY/MM/DD')
3229: || ' 23:59:59';
3230:
3231: l_blocks(l_block_index).PARENT_IS_NEW := 'Y';

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

3239: IF l_blocks(l_second_block_index).START_TIME IS NOT NULL
3240: THEN
3241:
3242: l_detail_start_date :=
3243: fnd_date.canonical_to_date(l_blocks(l_second_block_index).START_TIME)
3244: - l_old_start_time + l_new_start_time;
3245: l_blocks(l_second_block_index).START_TIME :=
3246: TO_CHAR(l_detail_start_date, 'YYYY/MM/DD')
3247: || TO_CHAR(

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

3248: TO_DATE(l_blocks(l_second_block_index).START_TIME, 'YYYY/MM/DD HH24:MI:SS'),
3249: ' HH24:MI:SS');
3250:
3251: l_detail_stop_date :=
3252: fnd_date.canonical_to_date(l_blocks(l_second_block_index).STOP_TIME)
3253: - l_old_start_time + l_new_start_time;
3254:
3255: l_blocks(l_second_block_index).STOP_TIME :=
3256: TO_CHAR(l_detail_stop_date, 'YYYY/MM/DD')

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

3589:
3590: HXC_ALIAS_TRANSLATOR.do_retrieval_translation(
3591: p_attributes => p_attribute_array
3592: ,p_blocks => p_block_array
3593: ,p_start_time => FND_DATE.CANONICAL_TO_DATE(p_start_time)
3594: ,p_stop_time => FND_DATE.CANONICAL_TO_DATE(p_stop_time)
3595: ,p_resource_id => l_resource_id
3596: ,p_messages => l_messages_table
3597: );

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

3590: HXC_ALIAS_TRANSLATOR.do_retrieval_translation(
3591: p_attributes => p_attribute_array
3592: ,p_blocks => p_block_array
3593: ,p_start_time => FND_DATE.CANONICAL_TO_DATE(p_start_time)
3594: ,p_stop_time => FND_DATE.CANONICAL_TO_DATE(p_stop_time)
3595: ,p_resource_id => l_resource_id
3596: ,p_messages => l_messages_table
3597: );
3598:

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

4032:
4033: if(p_blocks is not null) then
4034: translate_alias_timecards
4035: (p_resource_id => p_blocks(1).resource_id,
4036: p_start_time => substrb(fnd_date.date_to_canonical(p_start_time),1,10),
4037: p_stop_time => substrb(fnd_date.date_to_canonical(p_stop_time),1,10),
4038: p_block_array => p_blocks,
4039: p_attribute_array => p_attributes
4040: );

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

4033: if(p_blocks is not null) then
4034: translate_alias_timecards
4035: (p_resource_id => p_blocks(1).resource_id,
4036: p_start_time => substrb(fnd_date.date_to_canonical(p_start_time),1,10),
4037: p_stop_time => substrb(fnd_date.date_to_canonical(p_stop_time),1,10),
4038: p_block_array => p_blocks,
4039: p_attribute_array => p_attributes
4040: );
4041: end if;