APPS.POS_REG_WF_PKG dependencies on WF_LOCAL_USERS

Line 241: lv_adhoc_username WF_LOCAL_USERS.NAME%TYPE;

237: ----------------------------------------*/
238:
239: FUNCTION GetAdHocUserName (p_username IN VARCHAR2) RETURN VARCHAR2
240: IS
241: lv_adhoc_username WF_LOCAL_USERS.NAME%TYPE;
242: BEGIN
243: -- it probably won't exceed the column restraint, but just to take precaution
244: lv_adhoc_username := 'POS_REG_' || p_username;
245: RETURN lv_adhoc_username;

Line 1992: lv_user_name WF_LOCAL_USERS.NAME%TYPE;

1988: , resultout OUT NOCOPY VARCHAR2
1989: )
1990: IS
1991:
1992: lv_user_name WF_LOCAL_USERS.NAME%TYPE;
1993: lv_user_email WF_LOCAL_USERS.EMAIL_ADDRESS%TYPE;
1994: lv_user_language WF_LOCAL_USERS.LANGUAGE%TYPE;
1995: lv_nls_lang FND_LANGUAGES.NLS_LANGUAGE%TYPE;
1996: lv_proc_name VARCHAR2(30) := 'CreateLocalUser';

Line 1993: lv_user_email WF_LOCAL_USERS.EMAIL_ADDRESS%TYPE;

1989: )
1990: IS
1991:
1992: lv_user_name WF_LOCAL_USERS.NAME%TYPE;
1993: lv_user_email WF_LOCAL_USERS.EMAIL_ADDRESS%TYPE;
1994: lv_user_language WF_LOCAL_USERS.LANGUAGE%TYPE;
1995: lv_nls_lang FND_LANGUAGES.NLS_LANGUAGE%TYPE;
1996: lv_proc_name VARCHAR2(30) := 'CreateLocalUser';
1997:

Line 1994: lv_user_language WF_LOCAL_USERS.LANGUAGE%TYPE;

1990: IS
1991:
1992: lv_user_name WF_LOCAL_USERS.NAME%TYPE;
1993: lv_user_email WF_LOCAL_USERS.EMAIL_ADDRESS%TYPE;
1994: lv_user_language WF_LOCAL_USERS.LANGUAGE%TYPE;
1995: lv_nls_lang FND_LANGUAGES.NLS_LANGUAGE%TYPE;
1996: lv_proc_name VARCHAR2(30) := 'CreateLocalUser';
1997:
1998: BEGIN

Line 2097: lv_user_name WF_LOCAL_USERS.NAME%TYPE;

2093: , resultout OUT NOCOPY VARCHAR2
2094: )
2095: IS
2096:
2097: lv_user_name WF_LOCAL_USERS.NAME%TYPE;
2098:
2099: BEGIN
2100:
2101: IF ( funcmode = 'RUN' ) then

Line 2105: DELETE FROM wf_local_users

2101: IF ( funcmode = 'RUN' ) then
2102:
2103: lv_user_name := WF_ENGINE.GetItemAttrText(itemtype, itemkey, 'ADHOC_USER_NAME');
2104:
2105: DELETE FROM wf_local_users
2106: WHERE name = lv_user_name;
2107:
2108: resultout := 'COMPLETE';
2109: RETURN;