45: l_api_version_number CONSTANT NUMBER := 1.0;
46:
47: CURSOR c_manager(p_user_id NUMBER) IS
48: SELECT b.user_id, b.user_name
49: FROM JTF_RS_RESOURCE_EXTNS a
50: , JTF_RS_RESOURCE_EXTNS b
51: WHERE b.source_id = a.source_mgr_id
52: AND a.user_id = p_user_id;
53:
46:
47: CURSOR c_manager(p_user_id NUMBER) IS
48: SELECT b.user_id, b.user_name
49: FROM JTF_RS_RESOURCE_EXTNS a
50: , JTF_RS_RESOURCE_EXTNS b
51: WHERE b.source_id = a.source_mgr_id
52: AND a.user_id = p_user_id;
53:
54: BEGIN
213: END IF;
214: --DBMS_OUTPUT.PUT_LINE('Select manager');
215:
216: -- Get manager
217: SELECT user_name INTO l_user_name from JTF_RS_RESOURCE_EXTNS
218: WHERE user_id = p_user_id;
219:
220: OPEN C_MANAGER(p_user_id);
221: FETCH C_MANAGER INTO l_manager_id, l_manager_name;