DBA Data[Home] [Help]

APPS.HR_SUIT_MATCH_UTIL_SS dependencies on HR_UTILITY

Line 816: hr_utility.trace('initialize globals');

812: THEN
813: l_ret_ess_des_match_count := 0;
814: END IF;
815: CLOSE csr_ess_des_match_count;
816: hr_utility.trace('initialize globals');
817: IF p_req = 'Y' THEN
818: g_prev_ess_count := l_ret_ess_des_match_count;
819: ELSE
820: g_prev_des_count := l_ret_ess_des_match_count;

Line 823: hr_utility.trace('Same person: Using Globals now:get_ess_desired_match');

819: ELSE
820: g_prev_des_count := l_ret_ess_des_match_count;
821: END IF;
822: ELSE
823: hr_utility.trace('Same person: Using Globals now:get_ess_desired_match');
824: IF p_req = 'Y' THEN
825: l_ret_ess_des_match_count := g_prev_ess_count;
826: ELSE
827: l_ret_ess_des_match_count := g_prev_des_count;

Line 829: hr_utility.trace('g_prev_des_count:'||g_prev_des_count);

825: l_ret_ess_des_match_count := g_prev_ess_count;
826: ELSE
827: l_ret_ess_des_match_count := g_prev_des_count;
828: END IF;
829: hr_utility.trace('g_prev_des_count:'||g_prev_des_count);
830: hr_utility.trace('g_prev_ess_count:'||g_prev_ess_count);
831: END IF;
832: hr_utility.trace('Leaving get_ess_des_match_count:'||p_person_id||':'||p_req||':'||l_ret_ess_des_match_count);
833: RETURN l_ret_ess_des_match_count;

Line 830: hr_utility.trace('g_prev_ess_count:'||g_prev_ess_count);

826: ELSE
827: l_ret_ess_des_match_count := g_prev_des_count;
828: END IF;
829: hr_utility.trace('g_prev_des_count:'||g_prev_des_count);
830: hr_utility.trace('g_prev_ess_count:'||g_prev_ess_count);
831: END IF;
832: hr_utility.trace('Leaving get_ess_des_match_count:'||p_person_id||':'||p_req||':'||l_ret_ess_des_match_count);
833: RETURN l_ret_ess_des_match_count;
834: END get_ess_des_match_count;

Line 832: hr_utility.trace('Leaving get_ess_des_match_count:'||p_person_id||':'||p_req||':'||l_ret_ess_des_match_count);

828: END IF;
829: hr_utility.trace('g_prev_des_count:'||g_prev_des_count);
830: hr_utility.trace('g_prev_ess_count:'||g_prev_ess_count);
831: END IF;
832: hr_utility.trace('Leaving get_ess_des_match_count:'||p_person_id||':'||p_req||':'||l_ret_ess_des_match_count);
833: RETURN l_ret_ess_des_match_count;
834: END get_ess_des_match_count;
835:
836:

Line 916: hr_utility.trace('Return from get_ess_desired_match:'||p_req||':'||p_person_id||l_ess_des_match_count);

912:
913: BEGIN
914: -- get ess match count
915: l_ess_des_match_count := get_ess_des_match_count(p_person_id, p_req);
916: hr_utility.trace('Return from get_ess_desired_match:'||p_req||':'||p_person_id||l_ess_des_match_count);
917: RETURN l_ess_des_match_count || '/' ;
918: END get_ess_desired_match;
919:
920:

Line 1001: hr_utility.trace('Inside is_ess_des_meets'||p_person_id);

997: l_total_des_count integer;
998:
999:
1000: BEGIN
1001: hr_utility.trace('Inside is_ess_des_meets'||p_person_id);
1002:
1003: -- first get the ess match count
1004: l_ess_match_count := get_ess_des_match_count(p_person_id, 'Y');
1005: -- get the des match count