APPS.PO_REQAPPROVAL_INIT1 dependencies on PO_WF_USER_TMP

Line 276: WHERE user_name in (SELECT user_name FROM po_wf_user_tmp)

272: FROM wf_user_roles
273: WHERE role_name IN
274: (SELECT role_name
275: FROM wf_user_roles
276: WHERE user_name in (SELECT user_name FROM po_wf_user_tmp)
277: AND role_name like 'ADHOC%'
278: AND NVL(EXPIRATION_DATE,SYSDATE+1) > SYSDATE
279: GROUP BY role_name
280: HAVING count(role_name) = p_num_users

Line 288: DELETE po_wf_user_tmp; -- delete rows in the global temp table

284: )
285: WHERE ROWNUM < 2;
286: BEGIN
287:
288: DELETE po_wf_user_tmp; -- delete rows in the global temp table
289:
290: -- split the user names from p_list_of_users and insert them to the
291: -- global temp table
292:

Line 310: INSERT INTO po_wf_user_tmp (user_name) VALUES (l_user_name);

306:
307: l_user_name := Substr(p_list_of_users, l_start+1, l_end - l_start - 1);
308: l_offset := l_end + 1;
309:
310: INSERT INTO po_wf_user_tmp (user_name) VALUES (l_user_name);
311: l_count := l_count + 1;
312: END LOOP;
313:
314: IF l_count = 0 OR l_count <> p_num_users THEN

Line 325: DELETE po_wf_user_tmp;

321: l_role_name := NULL;
322: END IF;
323: CLOSE l_cur;
324:
325: DELETE po_wf_user_tmp;
326: RETURN l_role_name;
327:
328: EXCEPTION
329: WHEN OTHERS THEN