DBA Data[Home] [Help]

APPS.PON_USER_PROFILE_PKG dependencies on FND_USER

Line 84: FROM fnd_user

80: l_object_version_number number;
81: BEGIN
82: SELECT person_party_id
83: INTO l_user_party_id
84: FROM fnd_user
85: WHERE user_name = p_username;
86:
87:
88: SELECT vendor_party_id

Line 120: --set email address in fnd_user as well as TCA.

116: x_return_status <> fnd_api.g_ret_sts_success THEN
117: RAISE UPDATE_SUPPLIER_CONTACT_E;
118: END IF;
119:
120: --set email address in fnd_user as well as TCA.
121: UPDATE fnd_user
122: SET email_address = p_user_email
123: WHERE person_party_id = l_user_party_id;
124:

Line 121: UPDATE fnd_user

117: RAISE UPDATE_SUPPLIER_CONTACT_E;
118: END IF;
119:
120: --set email address in fnd_user as well as TCA.
121: UPDATE fnd_user
122: SET email_address = p_user_email
123: WHERE person_party_id = l_user_party_id;
124:
125: -- bug 2329157 . Need the user encoding option to be set for the user

Line 188: FROM fnd_user

184: -- first, get the user_id and the fk to TCA
185: SELECT person_party_id, user_id
186: INTO x_user_party_id
187: , l_user_id
188: FROM fnd_user
189: WHERE user_name = p_username;
190:
191: --grab user info from TCA
192: x_exception_msg:='retrieve_user_info: select person, phone, fax';

Line 352: UPDATE fnd_user

348: )
349: IS
350: BEGIN
351: --Note: user must be an Oracle Exchange User
352: UPDATE fnd_user
353: SET encrypted_user_password = p_new_password
354: , password_date = sysdate
355: , password_accesses_left = 9999999
356: , last_update_date = sysdate

Line 386: FROM fnd_user

382: BEGIN
383: --Note: user must be an Oracle Exchange user
384: SELECT user_id
385: INTO l_user_id
386: FROM fnd_user
387: WHERE user_name = p_username
388: AND description = 'Oracle Exchange User';
389:
390: FND_SIGNON.new_session(l_user_id,l_session_id,p_change_password);

Line 401: --completely removes a user from fnd_user and TCA tables.

397: X_STATUS :='U';
398: raise;
399: END login;
400:
401: --completely removes a user from fnd_user and TCA tables.
402: --VERY BAD MOJO if you are not sure you want this guy gone.
403: --Does not commit: if you want to commit, you must do it explicitly
404: PROCEDURE delete_user(
405: p_username IN VARCHAR2

Line 419: FROM fnd_user

415: WHERE party_id = l_user_party_id;
416: BEGIN
417: SELECT person_party_id
418: INTO l_user_party_id
419: FROM fnd_user
420: WHERE user_name = p_username;
421:
422: DELETE FROM fnd_user
423: WHERE user_name = p_username;

Line 422: DELETE FROM fnd_user

418: INTO l_user_party_id
419: FROM fnd_user
420: WHERE user_name = p_username;
421:
422: DELETE FROM fnd_user
423: WHERE user_name = p_username;
424:
425: --get rid of user profile
426: DELETE FROM hz_person_profiles

Line 620: from fnd_user

616: BEGIN
617:
618: select user_id into
619: l_user_id
620: from fnd_user
621: where user_name = p_username;
622:
623: IF (g_fnd_debug = 'Y') THEN
624: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

Line 831: FROM fnd_user

827: -- first, get the user_id and the fk to TCA
828: SELECT person_party_id, user_id
829: INTO x_user_party_id
830: , l_user_id
831: FROM fnd_user
832: WHERE user_name = p_username;
833:
834: --grab user info from TCA
835:

Line 956: FROM fnd_user

952: SELECT person_party_id, user_id, employee_id
953: INTO x_user_party_id
954: , l_user_id
955: , l_employee_id
956: FROM fnd_user
957: WHERE user_name = p_username;
958:
959: --grab user info from TCA
960: x_exception_msg:='retrieve_user_info: select person, phone, fax';