APPS.HXC_TIME_CATEGORY_API dependencies on HXC_TIME_CATEGORIES

Line 27: l_object_version_number hxc_time_categories.object_version_number%TYPE;

23: --
24: -- Declare cursors and local variables
25: --
26: l_proc varchar2(72) ;
27: l_object_version_number hxc_time_categories.object_version_number%TYPE;
28: l_time_category_id hxc_time_categories.time_category_id%TYPE;
29:
30: begin
31: g_debug := hr_utility.debug_enabled;

Line 28: l_time_category_id hxc_time_categories.time_category_id%TYPE;

24: -- Declare cursors and local variables
25: --
26: l_proc varchar2(72) ;
27: l_object_version_number hxc_time_categories.object_version_number%TYPE;
28: l_time_category_id hxc_time_categories.time_category_id%TYPE;
29:
30: begin
31: g_debug := hr_utility.debug_enabled;
32: --

Line 178: l_object_version_number hxc_time_categories.object_version_number%TYPE := p_object_version_number;

174: -- Declare cursors and local variables
175: --
176:
177: l_proc varchar2(72) ;
178: l_object_version_number hxc_time_categories.object_version_number%TYPE := p_object_version_number;
179:
180: begin
181: g_debug := hr_utility.debug_enabled;
182: --

Line 416: l_time_category_id hxc_time_Categories.time_category_id%TYPE;

412: --
413: procedure set_dynamic_sql_string ( p_time_category_id NUMBER ) IS
414:
415: l_time_sql long;
416: l_time_category_id hxc_time_Categories.time_category_id%TYPE;
417: l_operator hxc_time_categories.operator%TYPE;
418:
419: BEGIN
420:

Line 417: l_operator hxc_time_categories.operator%TYPE;

413: procedure set_dynamic_sql_string ( p_time_category_id NUMBER ) IS
414:
415: l_time_sql long;
416: l_time_category_id hxc_time_Categories.time_category_id%TYPE;
417: l_operator hxc_time_categories.operator%TYPE;
418:
419: BEGIN
420:
421: g_debug := hr_utility.debug_enabled;

Line 431: UPDATE hxc_time_categories

427: if g_debug then
428: hr_utility.trace('set dyn sql string string is '||l_time_sql);
429: end if;
430:
431: UPDATE hxc_time_categories
432: SET time_sql = l_time_sql
433: WHERE time_category_id = p_time_category_id;
434:
435: exception when others then

Line 459: FROM hxc_time_categories cat,

455: l_cat VARCHAR2(50);
456:
457: CURSOR get_corrupt_tcs
458: IS SELECT cat.time_category_id
459: FROM hxc_time_categories cat,
460: hxc_time_category_comps comp
461: WHERE cat.time_category_id = comp.time_category_id
462: AND cat.time_category_name IN ('Payroll Processing Fields',
463: 'Projects Processing Fields',