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_GENERIC_RETRIEVAL_UTILS dependencies on HXC_GENERIC_RETRIEVAL_UTILS

Line 1: Package Body hxc_generic_retrieval_utils as

1: Package Body hxc_generic_retrieval_utils as
2: /* $Header: hxcretutl.pkb 120.16.12020000.2 2013/02/11 11:21:29 jnerella ship $ */
3:
4: -- global package data type and variables
5:

Line 523: l_resource_index := hxc_generic_retrieval_utils.g_resources.FIRST;

519: -- GPM v115.40
520:
521: -- loop through the resources table and get the preferences
522:
523: l_resource_index := hxc_generic_retrieval_utils.g_resources.FIRST;
524:
525: WHILE l_resource_index IS NOT NULL
526: LOOP
527:

Line 545: l_resource_start_time := TRUNC(hxc_generic_retrieval_utils.g_resources(l_resource_index).start_time);

541: l_ret_ranges.delete;
542:
543: -- need to hit the database to retrieve this person's prefs
544:
545: l_resource_start_time := TRUNC(hxc_generic_retrieval_utils.g_resources(l_resource_index).start_time);
546:
547: l_resource_stop_time := TRUNC(hxc_generic_retrieval_utils.g_resources(l_resource_index).stop_time);
548:
549: -- GPM v115.27

Line 547: l_resource_stop_time := TRUNC(hxc_generic_retrieval_utils.g_resources(l_resource_index).stop_time);

543: -- need to hit the database to retrieve this person's prefs
544:
545: l_resource_start_time := TRUNC(hxc_generic_retrieval_utils.g_resources(l_resource_index).start_time);
546:
547: l_resource_stop_time := TRUNC(hxc_generic_retrieval_utils.g_resources(l_resource_index).stop_time);
548:
549: -- GPM v115.27
550:
551: IF ( g_debug ) THEN

Line 1089: l_resource_index := hxc_generic_retrieval_utils.g_resources.NEXT(l_resource_index);

1085: END IF; -- NOT p_errors.EXISTS(l_resource_index) - hxc_no_hier_for_date check
1086:
1087: END IF; -- NOT p_errors.EXISTS(l_resource_index) - preference call
1088:
1089: l_resource_index := hxc_generic_retrieval_utils.g_resources.NEXT(l_resource_index);
1090:
1091: END LOOP; -- g_resources loop
1092:
1093: IF ( g_debug ) THEN

Line 1109: l_resource_index := hxc_generic_retrieval_utils.g_resources.NEXT(l_resource_index);

1105: END IF;
1106:
1107: p_errors(l_resource_index).exception_description := SUBSTR(l_proc||':'||SQLERRM,1,2000);
1108: p_prefs(l_resource_index).prefs_ok := 'X';
1109: l_resource_index := hxc_generic_retrieval_utils.g_resources.NEXT(l_resource_index);
1110:
1111: IF ( g_debug ) THEN
1112: hr_utility.set_location('Processing '||l_proc, 150);
1113: END IF;

Line 1123: l_resource_index := hxc_generic_retrieval_utils.g_resources.FIRST;

1119: IF ( g_debug ) THEN
1120:
1121: hr_utility.trace('****** Resources ********');
1122:
1123: l_resource_index := hxc_generic_retrieval_utils.g_resources.FIRST;
1124:
1125: WHILE l_resource_index IS NOT NULL
1126: LOOP
1127: hr_utility.trace('');

Line 1129: hr_utility.trace('start time is '||to_char(hxc_generic_retrieval_utils.g_resources(l_resource_index).start_time,'dd-mon-yyyy'));

1125: WHILE l_resource_index IS NOT NULL
1126: LOOP
1127: hr_utility.trace('');
1128: hr_utility.trace('index is '||to_char(l_resource_index));
1129: hr_utility.trace('start time is '||to_char(hxc_generic_retrieval_utils.g_resources(l_resource_index).start_time,'dd-mon-yyyy'));
1130: hr_utility.trace('stop time is '||to_char(hxc_generic_retrieval_utils.g_resources(l_resource_index).stop_time,'dd-mon-yyyy'));
1131: hr_utility.trace('');
1132:
1133: l_resource_index := hxc_generic_retrieval_utils.g_resources.NEXT(l_resource_index);

Line 1130: hr_utility.trace('stop time is '||to_char(hxc_generic_retrieval_utils.g_resources(l_resource_index).stop_time,'dd-mon-yyyy'));

1126: LOOP
1127: hr_utility.trace('');
1128: hr_utility.trace('index is '||to_char(l_resource_index));
1129: hr_utility.trace('start time is '||to_char(hxc_generic_retrieval_utils.g_resources(l_resource_index).start_time,'dd-mon-yyyy'));
1130: hr_utility.trace('stop time is '||to_char(hxc_generic_retrieval_utils.g_resources(l_resource_index).stop_time,'dd-mon-yyyy'));
1131: hr_utility.trace('');
1132:
1133: l_resource_index := hxc_generic_retrieval_utils.g_resources.NEXT(l_resource_index);
1134:

Line 1133: l_resource_index := hxc_generic_retrieval_utils.g_resources.NEXT(l_resource_index);

1129: hr_utility.trace('start time is '||to_char(hxc_generic_retrieval_utils.g_resources(l_resource_index).start_time,'dd-mon-yyyy'));
1130: hr_utility.trace('stop time is '||to_char(hxc_generic_retrieval_utils.g_resources(l_resource_index).stop_time,'dd-mon-yyyy'));
1131: hr_utility.trace('');
1132:
1133: l_resource_index := hxc_generic_retrieval_utils.g_resources.NEXT(l_resource_index);
1134:
1135: END LOOP;
1136:
1137: hr_utility.trace('****** Prefs ********');

Line 2150: end hxc_generic_retrieval_utils;

2146:
2147: END absence_link_exists;
2148:
2149:
2150: end hxc_generic_retrieval_utils;