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_APPROVAL_UTILITIES dependencies on HXC_TIME_CATEGORY_UTILS_PKG

Line 516: l_one_where := 'hxc_time_category_utils_pkg.category_app_period_tc_hrs(htbb.start_time,

512: || '''';
513:
514: ELSIF l_search_by = 'HOURS_WORKED'
515: THEN
516: l_one_where := 'hxc_time_category_utils_pkg.category_app_period_tc_hrs(htbb.start_time,
517: htbb.stop_time, htbb.resource_id, '''', htbb.time_building_block_id) '
518: || l_search_operator
519: || l_search_value;
520:

Line 740: ,hxc_time_category_utils_pkg.category_app_period_tc_hrs(apsum.start_time, apsum.stop_time, apsum.resource_id, '', apsum.application_period_id)

736: ,ppf.full_name
737: ,htbb.comment_text
738: ,favtl.application_name
739: ,apsum.resource_id
740: ,hxc_time_category_utils_pkg.category_app_period_tc_hrs(apsum.start_time, apsum.stop_time, apsum.resource_id, '', apsum.application_period_id)
741: ,hxc_time_category_utils_pkg.category_app_period_tc_hrs(apsum.start_time, apsum.stop_time, apsum.resource_id, 'Total2', apsum.application_period_id),
742: hxc_time_category_utils_pkg.category_app_period_tc_hrs(apsum.start_time, apsum.stop_time, apsum.resource_id, 'Total3', apsum.application_period_id),
743: apsum.time_recipient_id
744: ,nvl(ppf.employee_number,ppf.NPW_NUMBER)

Line 741: ,hxc_time_category_utils_pkg.category_app_period_tc_hrs(apsum.start_time, apsum.stop_time, apsum.resource_id, 'Total2', apsum.application_period_id),

737: ,htbb.comment_text
738: ,favtl.application_name
739: ,apsum.resource_id
740: ,hxc_time_category_utils_pkg.category_app_period_tc_hrs(apsum.start_time, apsum.stop_time, apsum.resource_id, '', apsum.application_period_id)
741: ,hxc_time_category_utils_pkg.category_app_period_tc_hrs(apsum.start_time, apsum.stop_time, apsum.resource_id, 'Total2', apsum.application_period_id),
742: hxc_time_category_utils_pkg.category_app_period_tc_hrs(apsum.start_time, apsum.stop_time, apsum.resource_id, 'Total3', apsum.application_period_id),
743: apsum.time_recipient_id
744: ,nvl(ppf.employee_number,ppf.NPW_NUMBER)
745: ,hxc_self_service_timecard.get_timecard_transferred_to(hts.timecard_id, hts.timecard_ovn)

Line 742: hxc_time_category_utils_pkg.category_app_period_tc_hrs(apsum.start_time, apsum.stop_time, apsum.resource_id, 'Total3', apsum.application_period_id),

738: ,favtl.application_name
739: ,apsum.resource_id
740: ,hxc_time_category_utils_pkg.category_app_period_tc_hrs(apsum.start_time, apsum.stop_time, apsum.resource_id, '', apsum.application_period_id)
741: ,hxc_time_category_utils_pkg.category_app_period_tc_hrs(apsum.start_time, apsum.stop_time, apsum.resource_id, 'Total2', apsum.application_period_id),
742: hxc_time_category_utils_pkg.category_app_period_tc_hrs(apsum.start_time, apsum.stop_time, apsum.resource_id, 'Total3', apsum.application_period_id),
743: apsum.time_recipient_id
744: ,nvl(ppf.employee_number,ppf.NPW_NUMBER)
745: ,hxc_self_service_timecard.get_timecard_transferred_to(hts.timecard_id, hts.timecard_ovn)
746: FROM hxc_app_period_summary apsum

Line 1041: ,hxc_time_category_utils_pkg.category_app_period_tc_hrs(apsum.start_time, apsum.stop_time, apsum.resource_id, '', apsum.application_period_id)

1037: ,ppf.full_name
1038: ,htbb.comment_text
1039: ,favtl.application_name
1040: ,apsum.resource_id
1041: ,hxc_time_category_utils_pkg.category_app_period_tc_hrs(apsum.start_time, apsum.stop_time, apsum.resource_id, '', apsum.application_period_id)
1042: ,hxc_time_category_utils_pkg.category_app_period_tc_hrs(apsum.start_time, apsum.stop_time, apsum.resource_id, 'Total2', apsum.application_period_id),
1043: hxc_time_category_utils_pkg.category_app_period_tc_hrs(apsum.start_time, apsum.stop_time, apsum.resource_id, 'Total3', apsum.application_period_id),
1044: apsum.time_recipient_id
1045: ,nvl(ppf.employee_number,ppf.NPW_NUMBER)

Line 1042: ,hxc_time_category_utils_pkg.category_app_period_tc_hrs(apsum.start_time, apsum.stop_time, apsum.resource_id, 'Total2', apsum.application_period_id),

1038: ,htbb.comment_text
1039: ,favtl.application_name
1040: ,apsum.resource_id
1041: ,hxc_time_category_utils_pkg.category_app_period_tc_hrs(apsum.start_time, apsum.stop_time, apsum.resource_id, '', apsum.application_period_id)
1042: ,hxc_time_category_utils_pkg.category_app_period_tc_hrs(apsum.start_time, apsum.stop_time, apsum.resource_id, 'Total2', apsum.application_period_id),
1043: hxc_time_category_utils_pkg.category_app_period_tc_hrs(apsum.start_time, apsum.stop_time, apsum.resource_id, 'Total3', apsum.application_period_id),
1044: apsum.time_recipient_id
1045: ,nvl(ppf.employee_number,ppf.NPW_NUMBER)
1046: ,hxc_self_service_timecard.get_timecard_transferred_to(hts.timecard_id, hts.timecard_ovn)

Line 1043: hxc_time_category_utils_pkg.category_app_period_tc_hrs(apsum.start_time, apsum.stop_time, apsum.resource_id, 'Total3', apsum.application_period_id),

1039: ,favtl.application_name
1040: ,apsum.resource_id
1041: ,hxc_time_category_utils_pkg.category_app_period_tc_hrs(apsum.start_time, apsum.stop_time, apsum.resource_id, '', apsum.application_period_id)
1042: ,hxc_time_category_utils_pkg.category_app_period_tc_hrs(apsum.start_time, apsum.stop_time, apsum.resource_id, 'Total2', apsum.application_period_id),
1043: hxc_time_category_utils_pkg.category_app_period_tc_hrs(apsum.start_time, apsum.stop_time, apsum.resource_id, 'Total3', apsum.application_period_id),
1044: apsum.time_recipient_id
1045: ,nvl(ppf.employee_number,ppf.NPW_NUMBER)
1046: ,hxc_self_service_timecard.get_timecard_transferred_to(hts.timecard_id, hts.timecard_ovn)
1047: FROM hxc_app_period_summary apsum