18: l_proc varchar2(60);
19:
20: BEGIN
21: l_proc:= g_package||'CREATE_RO_PREV_EMP';
22: hr_utility.set_location('Entering : '||l_proc,5);
23: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'RO') THEN
24: hr_utility.set_location('Leaving : '||l_proc,10);
25: return;
26: END IF;
19:
20: BEGIN
21: l_proc:= g_package||'CREATE_RO_PREV_EMP';
22: hr_utility.set_location('Entering : '||l_proc,5);
23: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'RO') THEN
24: hr_utility.set_location('Leaving : '||l_proc,10);
25: return;
26: END IF;
27:
20: BEGIN
21: l_proc:= g_package||'CREATE_RO_PREV_EMP';
22: hr_utility.set_location('Entering : '||l_proc,5);
23: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'RO') THEN
24: hr_utility.set_location('Leaving : '||l_proc,10);
25: return;
26: END IF;
27:
28: hr_utility.set_location('Leaving : '||l_proc,20);
24: hr_utility.set_location('Leaving : '||l_proc,10);
25: return;
26: END IF;
27:
28: hr_utility.set_location('Leaving : '||l_proc,20);
29:
30: END CREATE_RO_PREV_EMP;
31:
32: PROCEDURE UPDATE_RO_PREV_EMP IS
34: l_proc varchar2(60);
35:
36: BEGIN
37: l_proc:= g_package||'UPDATE_RO_PREV_EMP';
38: hr_utility.set_location('Entering : '||l_proc,5);
39: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'RO') THEN
40: hr_utility.set_location('Leaving : '||l_proc,10);
41: return;
42: END IF;
35:
36: BEGIN
37: l_proc:= g_package||'UPDATE_RO_PREV_EMP';
38: hr_utility.set_location('Entering : '||l_proc,5);
39: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'RO') THEN
40: hr_utility.set_location('Leaving : '||l_proc,10);
41: return;
42: END IF;
43:
36: BEGIN
37: l_proc:= g_package||'UPDATE_RO_PREV_EMP';
38: hr_utility.set_location('Entering : '||l_proc,5);
39: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'RO') THEN
40: hr_utility.set_location('Leaving : '||l_proc,10);
41: return;
42: END IF;
43:
44: hr_utility.set_location('Leaving : '||l_proc,20);
40: hr_utility.set_location('Leaving : '||l_proc,10);
41: return;
42: END IF;
43:
44: hr_utility.set_location('Leaving : '||l_proc,20);
45:
46: END UPDATE_RO_PREV_EMP;
47:
48: END HR_RO_PREVIOUS_EMPLOYER_VAL;