eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.POS_REG_WF_PKG dependencies on FND_USER

Line 36: MSG_FND_USER_DUPLICATE CONSTANT FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'SECURITY-DUPLICATE USER';

32: -- error message names
33: MSG_USER_RESP_FAIL CONSTANT FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'POS_USER_RESP_FAIL';
34:
35: MSG_UNEXPECTED_ERROR CONSTANT FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'POS_REG_UNEXPECTED_ERR';
36: MSG_FND_USER_DUPLICATE CONSTANT FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'SECURITY-DUPLICATE USER';
37: MSG_USER_CREATION_FAIL CONSTANT FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'POS_REG_USER_CREATION_FAIL';
38: MSG_VENDORUSER_CREATION_FAIL CONSTANT FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'POS_REG_VNDR_USR_CREATE_FAIL';
39: MSG_POS_SITE_SECATTR_FAIL CONSTANT FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'POS_REG_SITE_SECATTR_FAIL';
40: MSG_POS_CONTACT_SECATTR_FAIL CONSTANT FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'POS_REG_CONT_SECATTR_FAIL';

Line 138: l_user_name FND_USER.USER_NAME%TYPE := null;

134:
135: is
136: x_refcur g_refcur;
137: l_approver_func_id NUMBER := null;
138: l_user_name FND_USER.USER_NAME%TYPE := null;
139: l_num_users number := 0;
140: l_approverlist varchar2(2000):=null;
141: l_approverlist_sql varchar2(2000):=null;
142: l_role_name WF_USER_ROLES.ROLE_NAME%TYPE := null;

Line 157: FROM fnd_user fu,

153: WHERE function_name = 'POS_REG_APPROVE_EXT_USERS';
154:
155: OPEN x_refcur FOR
156: 'SELECT DISTINCT fu.user_name
157: FROM fnd_user fu,
158: fnd_responsibility fr,
159: wf_user_roles wur
160: WHERE fr.menu_id in
161: (SELECT fme.menu_id

Line 1244: --lv_approver_role FND_USER.USER_NAME%TYPE := NULL; --varchar2(100)

1240: lv_last_name FND_REGISTRATIONS.LAST_NAME%TYPE := NULL;
1241: lv_vendor_name FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE := NULL;
1242: lv_osn_tp_name FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE := NULL;
1243: ln_approver_id NUMBER := NULL;
1244: --lv_approver_role FND_USER.USER_NAME%TYPE := NULL; --varchar2(100)
1245: lv_approver_role WF_USER_ROLES.ROLE_NAME%TYPE := NULL; --varchar2(320)
1246: lv_approval_page_url VARCHAR2(32000) := NULL;
1247: lv_notes FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE := NULL;
1248: lv_enterprise_name HZ_PARTIES.PARTY_NAME%TYPE;

Line 1348: FROM fnd_user

1344:
1345: BEGIN
1346: SELECT user_name
1347: INTO lv_approver_role
1348: FROM fnd_user
1349: WHERE user_id = ln_approver_id;
1350: EXCEPTION WHEN OTHERS THEN
1351:
1352: IF ( fnd_log.level_exception >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

Line 1513: lv_contact_email FND_USER.EMAIL_ADDRESS%TYPE;

1509: lv_phone_ext FND_REGISTRATIONS.PHONE_EXTENSION%TYPE := NULL;
1510: lv_fax FND_REGISTRATIONS.FAX%TYPE := NULL;
1511:
1512: ln_approver_id NUMBER;
1513: lv_contact_email FND_USER.EMAIL_ADDRESS%TYPE;
1514: lv_logon_page_url VARCHAR2(32000) := NULL;
1515: lv_enterprise_name HZ_PARTIES.PARTY_NAME%TYPE;
1516: lv_is_invited_flag FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE;
1517: ln_vendor_id NUMBER;

Line 1638: FROM fnd_user

1634:
1635: BEGIN
1636: SELECT email_address
1637: INTO lv_contact_email
1638: FROM fnd_user
1639: WHERE user_id = ln_approver_id;
1640:
1641: EXCEPTION WHEN OTHERS THEN
1642:

Line 1822: lv_contact_email FND_USER.EMAIL_ADDRESS%TYPE;

1818:
1819: lv_enterprise_name HZ_PARTIES.PARTY_NAME%TYPE;
1820:
1821: ln_approver_id NUMBER;
1822: lv_contact_email FND_USER.EMAIL_ADDRESS%TYPE;
1823: lv_is_invited_flag FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE;
1824:
1825: lv_x_field_type FND_REGISTRATION_DETAILS.FIELD_TYPE%TYPE;
1826: lv_x_field_format FND_REGISTRATION_DETAILS.FIELD_FORMAT%TYPE;

Line 1930: FROM fnd_user

1926:
1927: BEGIN
1928: SELECT email_address
1929: INTO lv_contact_email
1930: FROM fnd_user
1931: WHERE user_id = ln_approver_id;
1932:
1933: EXCEPTION WHEN OTHERS THEN
1934:

Line 2125: p_user_id IN NUMBER - the FND_USER id of the assignee

2121:
2122: Assgin responsibility to user
2123:
2124: PARAM:
2125: p_user_id IN NUMBER - the FND_USER id of the assignee
2126: p_resp_app_id IN NUMBER - the application id associated with the resp
2127: p_resp_key IN VARCHAR2 - the responsibility key
2128:
2129: EXCEPTION:

Line 2165: FND_USER_RESP_GROUPS_API.insert_assignment

2161:
2162: RETURN;
2163: END IF;
2164:
2165: FND_USER_RESP_GROUPS_API.insert_assignment
2166: ( user_id => p_user_id,
2167: responsibility_id => ln_resp_id,
2168: responsibility_application_id => p_resp_app_id,
2169: security_group_id => 0,

Line 2192: p_user_id IN NUMBER - the FND_USER id of the assignee

2188:
2189: Set security atttribute to the user.
2190:
2191: PARAM:
2192: p_user_id IN NUMBER - the FND_USER id of the assignee
2193: p_attribute_code IN VARCHAR2 - the security attribute code
2194: p_app_id IN NUMBER - the application id associated with the
2195: security code
2196: p_varchar2_value IN VARCHAR2 - the VARCHAR2 value DEFAULT NULL

Line 2629: Workflow activity function. Actually create the user in FND_USER.

2625: /*----------------------------------------
2626:
2627: public PROCEDURE CreateUser
2628:
2629: Workflow activity function. Actually create the user in FND_USER.
2630: Following activities are done:
2631: * generate random user password
2632: * insert FND_USER
2633: * insert TCA

Line 2632: * insert FND_USER

2628:
2629: Workflow activity function. Actually create the user in FND_USER.
2630: Following activities are done:
2631: * generate random user password
2632: * insert FND_USER
2633: * insert TCA
2634: * assign user responsibility
2635: * set user security attributes
2636:

Line 2661: -- user info needed to update FND_USER and TCA

2657:
2658: lv_reg_key WF_ITEM_ATTRIBUTE_VALUES.TEXT_VALUE%TYPE;
2659: ln_reg_id NUMBER := -1;
2660:
2661: -- user info needed to update FND_USER and TCA
2662:
2663: lv_user_name FND_USER.USER_NAME%TYPE;
2664: lv_unencrypted_password VARCHAR2(30);
2665:

Line 2663: lv_user_name FND_USER.USER_NAME%TYPE;

2659: ln_reg_id NUMBER := -1;
2660:
2661: -- user info needed to update FND_USER and TCA
2662:
2663: lv_user_name FND_USER.USER_NAME%TYPE;
2664: lv_unencrypted_password VARCHAR2(30);
2665:
2666: --OSN: the encrypted initial password
2667: l_encrypted_initial_password VARCHAR2(240);

Line 2670: lv_user_description FND_USER.DESCRIPTION%TYPE;

2666: --OSN: the encrypted initial password
2667: l_encrypted_initial_password VARCHAR2(240);
2668: l_retcode VARCHAR2(1);
2669:
2670: lv_user_description FND_USER.DESCRIPTION%TYPE;
2671: lv_user_email FND_USER.EMAIL_ADDRESS%TYPE;
2672: ln_vendor_id NUMBER;
2673: lv_user_firstname WF_ITEM_ATTRIBUTE_VALUES.TEXT_VALUE%TYPE;
2674: lv_user_lastname WF_ITEM_ATTRIBUTE_VALUES.TEXT_VALUE%TYPE;

Line 2671: lv_user_email FND_USER.EMAIL_ADDRESS%TYPE;

2667: l_encrypted_initial_password VARCHAR2(240);
2668: l_retcode VARCHAR2(1);
2669:
2670: lv_user_description FND_USER.DESCRIPTION%TYPE;
2671: lv_user_email FND_USER.EMAIL_ADDRESS%TYPE;
2672: ln_vendor_id NUMBER;
2673: lv_user_firstname WF_ITEM_ATTRIBUTE_VALUES.TEXT_VALUE%TYPE;
2674: lv_user_lastname WF_ITEM_ATTRIBUTE_VALUES.TEXT_VALUE%TYPE;
2675: lv_user_middlename WF_ITEM_ATTRIBUTE_VALUES.TEXT_VALUE%TYPE;

Line 2727: CURSOR l_fnd_user_cur(l_user_id IN NUMBER) IS

2723: FROM fnd_registration_details
2724: WHERE registration_id = p_reg_id
2725: AND field_name like p_field_name||'%';
2726:
2727: CURSOR l_fnd_user_cur(l_user_id IN NUMBER) IS
2728: SELECT * FROM fnd_user WHERE user_id = l_user_id;
2729:
2730: l_fnd_user_rec l_fnd_user_cur%ROWTYPE;
2731:

Line 2728: SELECT * FROM fnd_user WHERE user_id = l_user_id;

2724: WHERE registration_id = p_reg_id
2725: AND field_name like p_field_name||'%';
2726:
2727: CURSOR l_fnd_user_cur(l_user_id IN NUMBER) IS
2728: SELECT * FROM fnd_user WHERE user_id = l_user_id;
2729:
2730: l_fnd_user_rec l_fnd_user_cur%ROWTYPE;
2731:
2732: lv_pattern VARCHAR2(40);

Line 2730: l_fnd_user_rec l_fnd_user_cur%ROWTYPE;

2726:
2727: CURSOR l_fnd_user_cur(l_user_id IN NUMBER) IS
2728: SELECT * FROM fnd_user WHERE user_id = l_user_id;
2729:
2730: l_fnd_user_rec l_fnd_user_cur%ROWTYPE;
2731:
2732: lv_pattern VARCHAR2(40);
2733: lv_flag VARCHAR2(40);
2734:

Line 2823: --insert FND_USER

2819: END IF;
2820:
2821: END IF;
2822:
2823: --insert FND_USER
2824: BEGIN
2825:
2826: SELECT 1
2827: INTO ln_counter

Line 2828: FROM fnd_user

2824: BEGIN
2825:
2826: SELECT 1
2827: INTO ln_counter
2828: FROM fnd_user
2829: WHERE user_name = lv_user_name
2830: AND ROWNUM = 1;
2831:
2832: SetErrMsg(MSG_FND_USER_DUPLICATE);

Line 2832: SetErrMsg(MSG_FND_USER_DUPLICATE);

2828: FROM fnd_user
2829: WHERE user_name = lv_user_name
2830: AND ROWNUM = 1;
2831:
2832: SetErrMsg(MSG_FND_USER_DUPLICATE);
2833: resultout := 'COMPLETE:ERROR';
2834: RAISE TOO_MANY_ROWS;
2835:
2836: EXCEPTION

Line 3441: l_user_name FND_USER.USER_NAME%TYPE;

3437: function set_initial_password(l_reg_id NUMBER)
3438: return varchar2
3439:
3440: is
3441: l_user_name FND_USER.USER_NAME%TYPE;
3442: l_osn_req_id NUMBER;
3443: l_internal_id NUMBER;
3444: l_reg_key FND_REGISTRATIONS.REGISTRATION_KEY%TYPE;
3445: l_encrypted_initial_password VARCHAR2(240);