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_TIMECARD_UTILITIES dependencies on FND_DATE

Line 2109: p_rec_period_start_date => fnd_date.canonical_to_date

2105: hr_utility.set_location(g_package||l_proc, 10);
2106: END IF;
2107:
2108: find_current_period(
2109: p_rec_period_start_date => fnd_date.canonical_to_date
2110: (p_rec_period_start_date)
2111: ,p_period_type => p_period_type
2112: ,p_duration_in_days => p_duration_in_days
2113: ,p_current_date => TO_DATE(p_current_date, g_date_format)

Line 2175: l_start_time := FND_DATE.CANONICAL_TO_DATE(p_start_time);

2171: l_plan_name VARCHAR2(80);
2172: --
2173: BEGIN
2174: --
2175: l_start_time := FND_DATE.CANONICAL_TO_DATE(p_start_time);
2176: --
2177: IF (p_plan_code = 'MONTHLY') THEN
2178: l_plan_name := 'LGE_TL_MonthlyLeave_AP';
2179: ELSE

Line 2610: fnd_date.date_to_canonical(c_timecard.START_TIME),

2606: c_timecard.TIME_BUILDING_BLOCK_ID,
2607: c_timecard.TYPE,
2608: c_timecard.MEASURE,
2609: c_timecard.UNIT_OF_MEASURE,
2610: fnd_date.date_to_canonical(c_timecard.START_TIME),
2611: fnd_date.date_to_canonical(c_timecard.STOP_TIME),
2612: c_timecard.PARENT_BUILDING_BLOCK_ID,
2613: c_timecard.PARENT_IS_NEW,
2614: c_timecard.SCOPE,

Line 2611: fnd_date.date_to_canonical(c_timecard.STOP_TIME),

2607: c_timecard.TYPE,
2608: c_timecard.MEASURE,
2609: c_timecard.UNIT_OF_MEASURE,
2610: fnd_date.date_to_canonical(c_timecard.START_TIME),
2611: fnd_date.date_to_canonical(c_timecard.STOP_TIME),
2612: c_timecard.PARENT_BUILDING_BLOCK_ID,
2613: c_timecard.PARENT_IS_NEW,
2614: c_timecard.SCOPE,
2615: c_timecard.OBJECT_VERSION_NUMBER,

Line 2620: fnd_date.date_to_canonical(c_timecard.DATE_FROM),

2616: c_timecard.APPROVAL_STATUS,
2617: c_timecard.RESOURCE_ID,
2618: c_timecard.RESOURCE_TYPE,
2619: c_timecard.APPROVAL_STYLE_ID,
2620: fnd_date.date_to_canonical(c_timecard.DATE_FROM),
2621: fnd_date.date_to_canonical(c_timecard.DATE_TO),
2622: c_timecard.COMMENT_TEXT,
2623: c_timecard.PARENT_BUILDING_BLOCK_OVN,
2624: c_timecard.NEW,

Line 2621: fnd_date.date_to_canonical(c_timecard.DATE_TO),

2617: c_timecard.RESOURCE_ID,
2618: c_timecard.RESOURCE_TYPE,
2619: c_timecard.APPROVAL_STYLE_ID,
2620: fnd_date.date_to_canonical(c_timecard.DATE_FROM),
2621: fnd_date.date_to_canonical(c_timecard.DATE_TO),
2622: c_timecard.COMMENT_TEXT,
2623: c_timecard.PARENT_BUILDING_BLOCK_OVN,
2624: c_timecard.NEW,
2625: c_timecard.CHANGED,

Line 2650: fnd_date.date_to_canonical(c_day_info.START_TIME),

2646: c_day_info.TIME_BUILDING_BLOCK_ID,
2647: c_day_info.TYPE,
2648: c_day_info.MEASURE,
2649: c_day_info.UNIT_OF_MEASURE,
2650: fnd_date.date_to_canonical(c_day_info.START_TIME),
2651: fnd_date.date_to_canonical(c_day_info.STOP_TIME),
2652: c_day_info.PARENT_BUILDING_BLOCK_ID,
2653: c_day_info.PARENT_IS_NEW,
2654: c_day_info.SCOPE,

Line 2651: fnd_date.date_to_canonical(c_day_info.STOP_TIME),

2647: c_day_info.TYPE,
2648: c_day_info.MEASURE,
2649: c_day_info.UNIT_OF_MEASURE,
2650: fnd_date.date_to_canonical(c_day_info.START_TIME),
2651: fnd_date.date_to_canonical(c_day_info.STOP_TIME),
2652: c_day_info.PARENT_BUILDING_BLOCK_ID,
2653: c_day_info.PARENT_IS_NEW,
2654: c_day_info.SCOPE,
2655: c_day_info.OBJECT_VERSION_NUMBER,

Line 2660: fnd_date.date_to_canonical(c_day_info.DATE_FROM),

2656: c_day_info.APPROVAL_STATUS,
2657: c_day_info.RESOURCE_ID,
2658: c_day_info.RESOURCE_TYPE,
2659: c_day_info.APPROVAL_STYLE_ID,
2660: fnd_date.date_to_canonical(c_day_info.DATE_FROM),
2661: fnd_date.date_to_canonical(c_day_info.DATE_TO),
2662: c_day_info.COMMENT_TEXT,
2663: c_day_info.PARENT_BUILDING_BLOCK_OVN,
2664: c_day_info.NEW,

Line 2661: fnd_date.date_to_canonical(c_day_info.DATE_TO),

2657: c_day_info.RESOURCE_ID,
2658: c_day_info.RESOURCE_TYPE,
2659: c_day_info.APPROVAL_STYLE_ID,
2660: fnd_date.date_to_canonical(c_day_info.DATE_FROM),
2661: fnd_date.date_to_canonical(c_day_info.DATE_TO),
2662: c_day_info.COMMENT_TEXT,
2663: c_day_info.PARENT_BUILDING_BLOCK_OVN,
2664: c_day_info.NEW,
2665: c_day_info.CHANGED,

Line 2689: fnd_date.date_to_canonical(c_detail_info.START_TIME),

2685: c_detail_info.TIME_BUILDING_BLOCK_ID,
2686: c_detail_info.TYPE,
2687: c_detail_info.MEASURE,
2688: c_detail_info.UNIT_OF_MEASURE,
2689: fnd_date.date_to_canonical(c_detail_info.START_TIME),
2690: fnd_date.date_to_canonical(c_detail_info.STOP_TIME),
2691: c_detail_info.PARENT_BUILDING_BLOCK_ID,
2692: c_detail_info.PARENT_IS_NEW,
2693: c_detail_info.SCOPE,

Line 2690: fnd_date.date_to_canonical(c_detail_info.STOP_TIME),

2686: c_detail_info.TYPE,
2687: c_detail_info.MEASURE,
2688: c_detail_info.UNIT_OF_MEASURE,
2689: fnd_date.date_to_canonical(c_detail_info.START_TIME),
2690: fnd_date.date_to_canonical(c_detail_info.STOP_TIME),
2691: c_detail_info.PARENT_BUILDING_BLOCK_ID,
2692: c_detail_info.PARENT_IS_NEW,
2693: c_detail_info.SCOPE,
2694: c_detail_info.OBJECT_VERSION_NUMBER,

Line 2699: fnd_date.date_to_canonical(c_detail_info.DATE_FROM),

2695: c_detail_info.APPROVAL_STATUS,
2696: c_detail_info.RESOURCE_ID,
2697: c_detail_info.RESOURCE_TYPE,
2698: c_detail_info.APPROVAL_STYLE_ID,
2699: fnd_date.date_to_canonical(c_detail_info.DATE_FROM),
2700: fnd_date.date_to_canonical(c_detail_info.DATE_TO),
2701: c_detail_info.COMMENT_TEXT,
2702: c_detail_info.PARENT_BUILDING_BLOCK_OVN,
2703: c_detail_info.NEW,

Line 2700: fnd_date.date_to_canonical(c_detail_info.DATE_TO),

2696: c_detail_info.RESOURCE_ID,
2697: c_detail_info.RESOURCE_TYPE,
2698: c_detail_info.APPROVAL_STYLE_ID,
2699: fnd_date.date_to_canonical(c_detail_info.DATE_FROM),
2700: fnd_date.date_to_canonical(c_detail_info.DATE_TO),
2701: c_detail_info.COMMENT_TEXT,
2702: c_detail_info.PARENT_BUILDING_BLOCK_OVN,
2703: c_detail_info.NEW,
2704: c_detail_info.CHANGED,

Line 2903: , regexp_replace(fnd_date.date_to_canonical(trunc(app.start_time)),' .*') app_start_date

2899: c_tc_end_date date)
2900: IS
2901: SELECT distinct
2902: to_char(app.resource_id) app_resource_id
2903: , regexp_replace(fnd_date.date_to_canonical(trunc(app.start_time)),' .*') app_start_date
2904: , regexp_replace(fnd_date.date_to_canonical(trunc(app.stop_time)),' .*') app_end_date
2905: , fad.entity_name
2906: , fad.pk1_value
2907: , fad.pk2_value

Line 2904: , regexp_replace(fnd_date.date_to_canonical(trunc(app.stop_time)),' .*') app_end_date

2900: IS
2901: SELECT distinct
2902: to_char(app.resource_id) app_resource_id
2903: , regexp_replace(fnd_date.date_to_canonical(trunc(app.start_time)),' .*') app_start_date
2904: , regexp_replace(fnd_date.date_to_canonical(trunc(app.stop_time)),' .*') app_end_date
2905: , fad.entity_name
2906: , fad.pk1_value
2907: , fad.pk2_value
2908: , fad.pk3_value

Line 2930: AND regexp_replace(fnd_date.date_to_canonical(trunc(hts.start_time)),' .*') = fad.pk2_value

2926: AND trunc(app.stop_time) <> c_tc_end_date
2927: AND app.time_building_block_id = htal.application_period_id
2928: AND htal.timecard_id = hts.timecard_id
2929: AND hts.resource_id = to_number(fad.pk1_value)
2930: AND regexp_replace(fnd_date.date_to_canonical(trunc(hts.start_time)),' .*') = fad.pk2_value
2931: AND regexp_replace(fnd_date.date_to_canonical(trunc(hts.stop_time)),' .*') = fad.pk3_value
2932: AND fad.entity_name = 'HXC_TIMECARD_SUMMARY'
2933: ;
2934:

Line 2931: AND regexp_replace(fnd_date.date_to_canonical(trunc(hts.stop_time)),' .*') = fad.pk3_value

2927: AND app.time_building_block_id = htal.application_period_id
2928: AND htal.timecard_id = hts.timecard_id
2929: AND hts.resource_id = to_number(fad.pk1_value)
2930: AND regexp_replace(fnd_date.date_to_canonical(trunc(hts.start_time)),' .*') = fad.pk2_value
2931: AND regexp_replace(fnd_date.date_to_canonical(trunc(hts.stop_time)),' .*') = fad.pk3_value
2932: AND fad.entity_name = 'HXC_TIMECARD_SUMMARY'
2933: ;
2934:
2935: TYPE num_tab IS TABLE OF NUMBER;

Line 2972: OPEN c_get_tc_attahcments_for_ap(FND_DATE.CANONICAL_TO_DATE(p_tc_start_date),

2968: RETURN;
2969: END IF;
2970:
2971:
2972: OPEN c_get_tc_attahcments_for_ap(FND_DATE.CANONICAL_TO_DATE(p_tc_start_date),
2973: FND_DATE.CANONICAL_TO_DATE(p_tc_end_date)
2974: );
2975: FETCH c_get_tc_attahcments_for_ap BULK COLLECT
2976: INTO l_app_resource_id_tab

Line 2973: FND_DATE.CANONICAL_TO_DATE(p_tc_end_date)

2969: END IF;
2970:
2971:
2972: OPEN c_get_tc_attahcments_for_ap(FND_DATE.CANONICAL_TO_DATE(p_tc_start_date),
2973: FND_DATE.CANONICAL_TO_DATE(p_tc_end_date)
2974: );
2975: FETCH c_get_tc_attahcments_for_ap BULK COLLECT
2976: INTO l_app_resource_id_tab
2977: , l_app_start_date_tab