44: l_api_version_number CONSTANT NUMBER := 1.0;
45:
46: CURSOR c_manager(p_user_id NUMBER) IS
47: SELECT b.user_id, b.user_name
48: FROM JTF_RS_RESOURCE_EXTNS a
49: , JTF_RS_RESOURCE_EXTNS b
50: WHERE b.source_id = a.source_mgr_id
51: AND a.user_id = p_user_id;
52:
45:
46: CURSOR c_manager(p_user_id NUMBER) IS
47: SELECT b.user_id, b.user_name
48: FROM JTF_RS_RESOURCE_EXTNS a
49: , JTF_RS_RESOURCE_EXTNS b
50: WHERE b.source_id = a.source_mgr_id
51: AND a.user_id = p_user_id;
52:
53: BEGIN
205: -- result := 'COMPLETE';
206: END IF;
207: --DBMS_OUTPUT.PUT_LINE('*');
208: -- Get manager
209: SELECT user_name INTO l_user_name from JTF_RS_RESOURCE_EXTNS
210: WHERE user_id = p_user_id;
211:
212: OPEN C_MANAGER(p_user_id);
213: FETCH C_MANAGER INTO l_manager_id, l_manager_name;