APPS.CS_WF_AUTO_NTFY_UPDATE_PKG dependencies on WF_LOCAL_ROLES

Line 6299: FROM wf_local_roles

6295: l_get_source_id_rec l_get_source_id%ROWTYPE;
6296:
6297: CURSOR l_sel_adhocrole_csr(c_role_name IN VARCHAR2) IS
6298: SELECT display_name,expiration_date
6299: FROM wf_local_roles
6300: WHERE name = c_role_name;
6301: l_sel_adhocrole_rec l_sel_adhocrole_csr%ROWTYPE;
6302:
6303: BEGIN

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

7101: -- Date Name Desc
7102: -- -------- ---------- --------------------------------------
7103: -- 07/13/2004 RMANABAT Created.
7104: -- 07/28/2004 RMANABAT Changed referred table in cursor from WF_LOCAL_USERS
7105: -- to WF_LOCAL_ROLES since calling create_adhocuser()
7106: -- creates a row in WF_LOCAL_ROLES .
7107: ***********************************************************************/
7108:
7109: PROCEDURE SetWorkflowAdhocUser(

Line 7106: -- creates a row in WF_LOCAL_ROLES .

7102: -- -------- ---------- --------------------------------------
7103: -- 07/13/2004 RMANABAT Created.
7104: -- 07/28/2004 RMANABAT Changed referred table in cursor from WF_LOCAL_USERS
7105: -- to WF_LOCAL_ROLES since calling create_adhocuser()
7106: -- creates a row in WF_LOCAL_ROLES .
7107: ***********************************************************************/
7108:
7109: PROCEDURE SetWorkflowAdhocUser(
7110: p_wf_username IN OUT NOCOPY VARCHAR2,

Line 7116: FROM wf_local_roles

7112: p_display_name IN VARCHAR2 DEFAULT NULL) IS
7113:
7114: CURSOR sel_user_csr(c_user_name IN VARCHAR2) IS
7115: SELECT display_name,expiration_date
7116: FROM wf_local_roles
7117: WHERE name = c_user_name;
7118: l_sel_user_rec sel_user_csr%ROWTYPE;
7119:
7120: l_wf_username VARCHAR2(320);

Line 7177: FROM wf_local_roles

7173: p_user_list IN VARCHAR2) IS
7174:
7175: CURSOR l_sel_adhocrole_csr(c_role_name IN VARCHAR2) IS
7176: SELECT display_name,expiration_date
7177: FROM wf_local_roles
7178: WHERE name = c_role_name;
7179: l_sel_adhocrole_rec l_sel_adhocrole_csr%ROWTYPE;
7180:
7181: l_wf_rolename VARCHAR2(320);