APPS.PO_REQAPPROVAL_INIT1 dependencies on PO_WF_USER_TMP

Line 349: (SELECT user_name FROM po_wf_user_tmp

345: WHERE role_name IN
346: (SELECT role_name
347: FROM wf_user_roles
348: WHERE user_name IN
349: (SELECT user_name FROM po_wf_user_tmp
350: )
351: AND role_name LIKE 'ADHOC%'
352: AND NVL(EXPIRATION_DATE,SYSDATE+1) > SYSDATE
353: GROUP BY role_name

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

357: HAVING COUNT(role_name) = p_num_users
358: )
359: WHERE ROWNUM < 2;
360: BEGIN
361: DELETE po_wf_user_tmp; -- delete rows in the global temp table
362: -- split the user names from p_list_of_users and insert them to the
363: -- global temp table
364: l_offset := 1;
365: l_count := 0;

Line 378: INSERT INTO po_wf_user_tmp

374: EXIT;
375: END IF;
376: l_user_name := SUBSTR(p_list_of_users, l_start+1, l_end - l_start - 1);
377: l_offset := l_end + 1;
378: INSERT INTO po_wf_user_tmp
379: (user_name
380: ) VALUES
381: (l_user_name
382: );

Line 395: DELETE po_wf_user_tmp;

391: IF l_cur%notfound THEN
392: l_role_name := NULL;
393: END IF;
394: CLOSE l_cur;
395: DELETE po_wf_user_tmp;
396: RETURN l_role_name;
397: EXCEPTION
398: WHEN OTHERS THEN
399: l_role_name := NULL;