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 60: HR_UTILITY.TRACE_ON(NULL

56: WHERE LOOKUP_TYPE = P_LOOKUP_TYPE
57: AND LOOKUP_CODE = P_LOOKUP_CODE;
58: BEGIN
59: IF P_DEBUG = 'Y' THEN
60: HR_UTILITY.TRACE_ON(NULL
61: ,'MH');
62: END IF;
63: COL_1 := NULL;
64: COL_2 := NULL;

Line 409: HR_UTILITY.TRACE('g_start_time group_filter');

405: FUNCTION G_START_TIMEGROUPFILTER(APPROVAL_STATUS IN VARCHAR2
406: ,P_COUNT IN NUMBER
407: ,RESOURCE_ID1 IN NUMBER) RETURN BOOLEAN IS
408: BEGIN
409: HR_UTILITY.TRACE('g_start_time group_filter');
410: HR_UTILITY.TRACE('define_missing:' || P_DEFINE_MISSING);
411: HR_UTILITY.TRACE('approval_status:' || APPROVAL_STATUS);
412: HR_UTILITY.TRACE('count:' || P_COUNT);
413: HR_UTILITY.TRACE('resource_id1:' || RESOURCE_ID1);

Line 410: HR_UTILITY.TRACE('define_missing:' || P_DEFINE_MISSING);

406: ,P_COUNT IN NUMBER
407: ,RESOURCE_ID1 IN NUMBER) RETURN BOOLEAN IS
408: BEGIN
409: HR_UTILITY.TRACE('g_start_time group_filter');
410: HR_UTILITY.TRACE('define_missing:' || P_DEFINE_MISSING);
411: HR_UTILITY.TRACE('approval_status:' || APPROVAL_STATUS);
412: HR_UTILITY.TRACE('count:' || P_COUNT);
413: HR_UTILITY.TRACE('resource_id1:' || RESOURCE_ID1);
414: IF P_COUNT > 0 AND APPROVAL_STATUS < 'NOT ENTERED' THEN

Line 411: HR_UTILITY.TRACE('approval_status:' || APPROVAL_STATUS);

407: ,RESOURCE_ID1 IN NUMBER) RETURN BOOLEAN IS
408: BEGIN
409: HR_UTILITY.TRACE('g_start_time group_filter');
410: HR_UTILITY.TRACE('define_missing:' || P_DEFINE_MISSING);
411: HR_UTILITY.TRACE('approval_status:' || APPROVAL_STATUS);
412: HR_UTILITY.TRACE('count:' || P_COUNT);
413: HR_UTILITY.TRACE('resource_id1:' || RESOURCE_ID1);
414: IF P_COUNT > 0 AND APPROVAL_STATUS < 'NOT ENTERED' THEN
415: HR_UTILITY.SET_LOCATION('g_start_time'

Line 412: HR_UTILITY.TRACE('count:' || P_COUNT);

408: BEGIN
409: HR_UTILITY.TRACE('g_start_time group_filter');
410: HR_UTILITY.TRACE('define_missing:' || P_DEFINE_MISSING);
411: HR_UTILITY.TRACE('approval_status:' || APPROVAL_STATUS);
412: HR_UTILITY.TRACE('count:' || P_COUNT);
413: HR_UTILITY.TRACE('resource_id1:' || RESOURCE_ID1);
414: IF P_COUNT > 0 AND APPROVAL_STATUS < 'NOT ENTERED' THEN
415: HR_UTILITY.SET_LOCATION('g_start_time'
416: ,10);

Line 413: HR_UTILITY.TRACE('resource_id1:' || RESOURCE_ID1);

409: HR_UTILITY.TRACE('g_start_time group_filter');
410: HR_UTILITY.TRACE('define_missing:' || P_DEFINE_MISSING);
411: HR_UTILITY.TRACE('approval_status:' || APPROVAL_STATUS);
412: HR_UTILITY.TRACE('count:' || P_COUNT);
413: HR_UTILITY.TRACE('resource_id1:' || RESOURCE_ID1);
414: IF P_COUNT > 0 AND APPROVAL_STATUS < 'NOT ENTERED' THEN
415: HR_UTILITY.SET_LOCATION('g_start_time'
416: ,10);
417: RETURN (TRUE);

Line 415: HR_UTILITY.SET_LOCATION('g_start_time'

411: HR_UTILITY.TRACE('approval_status:' || APPROVAL_STATUS);
412: HR_UTILITY.TRACE('count:' || P_COUNT);
413: HR_UTILITY.TRACE('resource_id1:' || RESOURCE_ID1);
414: IF P_COUNT > 0 AND APPROVAL_STATUS < 'NOT ENTERED' THEN
415: HR_UTILITY.SET_LOCATION('g_start_time'
416: ,10);
417: RETURN (TRUE);
418: END IF;
419: IF P_COUNT = 0 AND APPROVAL_STATUS = 'NOT ENTERED' THEN

Line 420: HR_UTILITY.SET_LOCATION('g_start_time'

416: ,10);
417: RETURN (TRUE);
418: END IF;
419: IF P_COUNT = 0 AND APPROVAL_STATUS = 'NOT ENTERED' THEN
420: HR_UTILITY.SET_LOCATION('g_start_time'
421: ,11);
422: RETURN (FALSE);
423: END IF;
424: IF P_DEFINE_MISSING = '01' AND APPROVAL_STATUS = 'NOT ENTERED' THEN

Line 425: HR_UTILITY.SET_LOCATION('g_start_time'

421: ,11);
422: RETURN (FALSE);
423: END IF;
424: IF P_DEFINE_MISSING = '01' AND APPROVAL_STATUS = 'NOT ENTERED' THEN
425: HR_UTILITY.SET_LOCATION('g_start_time'
426: ,20);
427: RETURN (TRUE);
428: ELSIF P_DEFINE_MISSING = '02' AND APPROVAL_STATUS in ('NOT ENTERED','WORKING') THEN
429: HR_UTILITY.SET_LOCATION('g_start_time'

Line 429: HR_UTILITY.SET_LOCATION('g_start_time'

425: HR_UTILITY.SET_LOCATION('g_start_time'
426: ,20);
427: RETURN (TRUE);
428: ELSIF P_DEFINE_MISSING = '02' AND APPROVAL_STATUS in ('NOT ENTERED','WORKING') THEN
429: HR_UTILITY.SET_LOCATION('g_start_time'
430: ,30);
431: RETURN (TRUE);
432: ELSIF P_DEFINE_MISSING = '03' AND APPROVAL_STATUS in ('NOT ENTERED','WORKING','REJECTED') THEN
433: HR_UTILITY.SET_LOCATION('g_start_time'

Line 433: HR_UTILITY.SET_LOCATION('g_start_time'

429: HR_UTILITY.SET_LOCATION('g_start_time'
430: ,30);
431: RETURN (TRUE);
432: ELSIF P_DEFINE_MISSING = '03' AND APPROVAL_STATUS in ('NOT ENTERED','WORKING','REJECTED') THEN
433: HR_UTILITY.SET_LOCATION('g_start_time'
434: ,40);
435: RETURN (TRUE);
436: ELSIF P_DEFINE_MISSING = '04' AND APPROVAL_STATUS < 'APPROVED' THEN
437: HR_UTILITY.SET_LOCATION('g_start_time'

Line 437: HR_UTILITY.SET_LOCATION('g_start_time'

433: HR_UTILITY.SET_LOCATION('g_start_time'
434: ,40);
435: RETURN (TRUE);
436: ELSIF P_DEFINE_MISSING = '04' AND APPROVAL_STATUS < 'APPROVED' THEN
437: HR_UTILITY.SET_LOCATION('g_start_time'
438: ,50);
439: RETURN (TRUE);
440: END IF;
441: RETURN (FALSE);