APPS.CS_WF_AUTO_NTFY_UPDATE_PKG dependencies on WF_LOCAL_ROLES

Line 6363: FROM wf_local_roles

6359: l_get_source_id_rec l_get_source_id%ROWTYPE;
6360:
6361: CURSOR l_sel_adhocrole_csr(c_role_name IN VARCHAR2) IS
6362: SELECT display_name,expiration_date
6363: FROM wf_local_roles
6364: WHERE name = c_role_name;
6365: l_sel_adhocrole_rec l_sel_adhocrole_csr%ROWTYPE;
6366:
6367: BEGIN

Line 7169: -- to WF_LOCAL_ROLES since calling create_adhocuser()

7165: -- Date Name Desc
7166: -- -------- ---------- --------------------------------------
7167: -- 07/13/2004 RMANABAT Created.
7168: -- 07/28/2004 RMANABAT Changed referred table in cursor from WF_LOCAL_USERS
7169: -- to WF_LOCAL_ROLES since calling create_adhocuser()
7170: -- creates a row in WF_LOCAL_ROLES .
7171: ***********************************************************************/
7172:
7173: PROCEDURE SetWorkflowAdhocUser(

Line 7170: -- creates a row in WF_LOCAL_ROLES .

7166: -- -------- ---------- --------------------------------------
7167: -- 07/13/2004 RMANABAT Created.
7168: -- 07/28/2004 RMANABAT Changed referred table in cursor from WF_LOCAL_USERS
7169: -- to WF_LOCAL_ROLES since calling create_adhocuser()
7170: -- creates a row in WF_LOCAL_ROLES .
7171: ***********************************************************************/
7172:
7173: PROCEDURE SetWorkflowAdhocUser(
7174: p_wf_username IN OUT NOCOPY VARCHAR2,

Line 7180: FROM wf_local_roles

7176: p_display_name IN VARCHAR2 DEFAULT NULL) IS
7177:
7178: CURSOR sel_user_csr(c_user_name IN VARCHAR2) IS
7179: SELECT display_name,expiration_date
7180: FROM wf_local_roles
7181: WHERE name = c_user_name;
7182: l_sel_user_rec sel_user_csr%ROWTYPE;
7183:
7184: l_wf_username VARCHAR2(320);

Line 7241: FROM wf_local_roles

7237: p_user_list IN VARCHAR2) IS
7238:
7239: CURSOR l_sel_adhocrole_csr(c_role_name IN VARCHAR2) IS
7240: SELECT display_name,expiration_date
7241: FROM wf_local_roles
7242: WHERE name = c_role_name;
7243: l_sel_adhocrole_rec l_sel_adhocrole_csr%ROWTYPE;
7244:
7245: l_wf_rolename VARCHAR2(320);