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.8.12010000.2 2008/10/16 17:27:47 asrajago ship $ */
3:
4: -- global package data type and variables
5:

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

436: -- GPM v115.40
437:
438: -- loop through the resources table and get the preferences
439:
440: l_resource_index := hxc_generic_retrieval_utils.g_resources.FIRST;
441:
442: WHILE l_resource_index IS NOT NULL
443: LOOP
444:

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

458: l_ret_ranges.delete;
459:
460: -- need to hit the database to retrieve this person's prefs
461:
462: l_resource_start_time := TRUNC(hxc_generic_retrieval_utils.g_resources(l_resource_index).start_time);
463:
464: l_resource_stop_time := TRUNC(hxc_generic_retrieval_utils.g_resources(l_resource_index).stop_time);
465:
466: -- GPM v115.27

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

460: -- need to hit the database to retrieve this person's prefs
461:
462: l_resource_start_time := TRUNC(hxc_generic_retrieval_utils.g_resources(l_resource_index).start_time);
463:
464: l_resource_stop_time := TRUNC(hxc_generic_retrieval_utils.g_resources(l_resource_index).stop_time);
465:
466: -- GPM v115.27
467:
468: IF ( g_debug ) THEN

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

982: END IF; -- NOT p_errors.EXISTS(l_resource_index) - hxc_no_hier_for_date check
983:
984: END IF; -- NOT p_errors.EXISTS(l_resource_index) - preference call
985:
986: l_resource_index := hxc_generic_retrieval_utils.g_resources.NEXT(l_resource_index);
987:
988: END LOOP; -- g_resources loop
989:
990: IF ( g_debug ) THEN

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

1002: END IF;
1003:
1004: p_errors(l_resource_index).exception_description := SUBSTR(l_proc||':'||SQLERRM,1,2000);
1005: p_prefs(l_resource_index).prefs_ok := 'X';
1006: l_resource_index := hxc_generic_retrieval_utils.g_resources.NEXT(l_resource_index);
1007:
1008: IF ( g_debug ) THEN
1009: hr_utility.set_location('Processing '||l_proc, 150);
1010: END IF;

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

1016: IF ( g_debug ) THEN
1017:
1018: hr_utility.trace('****** Resources ********');
1019:
1020: l_resource_index := hxc_generic_retrieval_utils.g_resources.FIRST;
1021:
1022: WHILE l_resource_index IS NOT NULL
1023: LOOP
1024: hr_utility.trace('');

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

1022: WHILE l_resource_index IS NOT NULL
1023: LOOP
1024: hr_utility.trace('');
1025: hr_utility.trace('index is '||to_char(l_resource_index));
1026: hr_utility.trace('start time is '||to_char(hxc_generic_retrieval_utils.g_resources(l_resource_index).start_time,'dd-mon-yyyy'));
1027: hr_utility.trace('stop time is '||to_char(hxc_generic_retrieval_utils.g_resources(l_resource_index).stop_time,'dd-mon-yyyy'));
1028: hr_utility.trace('');
1029:
1030: l_resource_index := hxc_generic_retrieval_utils.g_resources.NEXT(l_resource_index);

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

1023: LOOP
1024: hr_utility.trace('');
1025: hr_utility.trace('index is '||to_char(l_resource_index));
1026: hr_utility.trace('start time is '||to_char(hxc_generic_retrieval_utils.g_resources(l_resource_index).start_time,'dd-mon-yyyy'));
1027: hr_utility.trace('stop time is '||to_char(hxc_generic_retrieval_utils.g_resources(l_resource_index).stop_time,'dd-mon-yyyy'));
1028: hr_utility.trace('');
1029:
1030: l_resource_index := hxc_generic_retrieval_utils.g_resources.NEXT(l_resource_index);
1031:

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

1026: hr_utility.trace('start time is '||to_char(hxc_generic_retrieval_utils.g_resources(l_resource_index).start_time,'dd-mon-yyyy'));
1027: hr_utility.trace('stop time is '||to_char(hxc_generic_retrieval_utils.g_resources(l_resource_index).stop_time,'dd-mon-yyyy'));
1028: hr_utility.trace('');
1029:
1030: l_resource_index := hxc_generic_retrieval_utils.g_resources.NEXT(l_resource_index);
1031:
1032: END LOOP;
1033:
1034: hr_utility.trace('****** Prefs ********');

Line 1966: end hxc_generic_retrieval_utils;

1962:
1963: END get_ret_criteria;
1964:
1965:
1966: end hxc_generic_retrieval_utils;