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_HXCMISTC_XMLP_PKG dependencies on HR_UTILITY

Line 59: HR_UTILITY.TRACE_ON(NULL

55:
56: BEGIN
57:
58: IF P_DEBUG = 'Y' THEN
59: HR_UTILITY.TRACE_ON(NULL
60: ,'MH');
61: END IF;
62:
63: COL_1 := NULL;

Line 392: hr_utility.trace('g_start_time group_filter');

388: FUNCTION G_START_TIMEGROUPFILTER(APPROVAL_STATUS IN VARCHAR2
389: ,P_COUNT IN NUMBER
390: ,RESOURCE_ID1 IN NUMBER) RETURN BOOLEAN IS
391: BEGIN
392: hr_utility.trace('g_start_time group_filter');
393: hr_utility.trace('define_missing:'|| p_define_missing);
394: hr_utility.trace('approval_status:'|| approval_status);
395: hr_utility.trace ('count:'|| P_COUNT);
396: hr_utility.trace('resource_id1:'|| resource_id1);

Line 393: hr_utility.trace('define_missing:'|| p_define_missing);

389: ,P_COUNT IN NUMBER
390: ,RESOURCE_ID1 IN NUMBER) RETURN BOOLEAN IS
391: BEGIN
392: hr_utility.trace('g_start_time group_filter');
393: hr_utility.trace('define_missing:'|| p_define_missing);
394: hr_utility.trace('approval_status:'|| approval_status);
395: hr_utility.trace ('count:'|| P_COUNT);
396: hr_utility.trace('resource_id1:'|| resource_id1);
397:

Line 394: hr_utility.trace('approval_status:'|| approval_status);

390: ,RESOURCE_ID1 IN NUMBER) RETURN BOOLEAN IS
391: BEGIN
392: hr_utility.trace('g_start_time group_filter');
393: hr_utility.trace('define_missing:'|| p_define_missing);
394: hr_utility.trace('approval_status:'|| approval_status);
395: hr_utility.trace ('count:'|| P_COUNT);
396: hr_utility.trace('resource_id1:'|| resource_id1);
397:
398: if P_COUNT > 0 and approval_status <> 'NOT ENTERED' then

Line 395: hr_utility.trace ('count:'|| P_COUNT);

391: BEGIN
392: hr_utility.trace('g_start_time group_filter');
393: hr_utility.trace('define_missing:'|| p_define_missing);
394: hr_utility.trace('approval_status:'|| approval_status);
395: hr_utility.trace ('count:'|| P_COUNT);
396: hr_utility.trace('resource_id1:'|| resource_id1);
397:
398: if P_COUNT > 0 and approval_status <> 'NOT ENTERED' then
399: hr_utility.set_location('g_start_time',10);

Line 396: hr_utility.trace('resource_id1:'|| resource_id1);

392: hr_utility.trace('g_start_time group_filter');
393: hr_utility.trace('define_missing:'|| p_define_missing);
394: hr_utility.trace('approval_status:'|| approval_status);
395: hr_utility.trace ('count:'|| P_COUNT);
396: hr_utility.trace('resource_id1:'|| resource_id1);
397:
398: if P_COUNT > 0 and approval_status <> 'NOT ENTERED' then
399: hr_utility.set_location('g_start_time',10);
400: return (TRUE);

Line 399: hr_utility.set_location('g_start_time',10);

395: hr_utility.trace ('count:'|| P_COUNT);
396: hr_utility.trace('resource_id1:'|| resource_id1);
397:
398: if P_COUNT > 0 and approval_status <> 'NOT ENTERED' then
399: hr_utility.set_location('g_start_time',10);
400: return (TRUE);
401: end if;
402:
403: if P_COUNT=0 and approval_status = 'NOT ENTERED' then

Line 404: hr_utility.set_location('g_start_time',11);

400: return (TRUE);
401: end if;
402:
403: if P_COUNT=0 and approval_status = 'NOT ENTERED' then
404: hr_utility.set_location('g_start_time',11);
405: return (false);
406: end if;
407:
408:

Line 410: hr_utility.set_location('g_start_time',20);

406: end if;
407:
408:
409: if p_define_missing = '01' and approval_status = 'NOT ENTERED' then
410: hr_utility.set_location('g_start_time',20);
411: return (TRUE);
412: elsif p_define_missing = '02' and approval_status in ('NOT ENTERED','WORKING') then
413: hr_utility.set_location('g_start_time',30);
414: return(TRUE);

Line 413: hr_utility.set_location('g_start_time',30);

409: if p_define_missing = '01' and approval_status = 'NOT ENTERED' then
410: hr_utility.set_location('g_start_time',20);
411: return (TRUE);
412: elsif p_define_missing = '02' and approval_status in ('NOT ENTERED','WORKING') then
413: hr_utility.set_location('g_start_time',30);
414: return(TRUE);
415: elsif p_define_missing = '03' and approval_status in ('NOT ENTERED','WORKING','REJECTED') then
416: hr_utility.set_location('g_start_time',40);
417: return(TRUE);

Line 416: hr_utility.set_location('g_start_time',40);

412: elsif p_define_missing = '02' and approval_status in ('NOT ENTERED','WORKING') then
413: hr_utility.set_location('g_start_time',30);
414: return(TRUE);
415: elsif p_define_missing = '03' and approval_status in ('NOT ENTERED','WORKING','REJECTED') then
416: hr_utility.set_location('g_start_time',40);
417: return(TRUE);
418: elsif p_define_missing = '04' and approval_status <> 'APPROVED' then
419: hr_utility.set_location('g_start_time',50);
420: return(TRUE);

Line 419: hr_utility.set_location('g_start_time',50);

415: elsif p_define_missing = '03' and approval_status in ('NOT ENTERED','WORKING','REJECTED') then
416: hr_utility.set_location('g_start_time',40);
417: return(TRUE);
418: elsif p_define_missing = '04' and approval_status <> 'APPROVED' then
419: hr_utility.set_location('g_start_time',50);
420: return(TRUE);
421: end if;
422: return (FALSE);
423: