APPS.POS_SUPPLIER_USER_REG_PKG dependencies on FND_USER

Line 377: FROM fnd_user

373: FUNCTION get_contact_email RETURN VARCHAR2
374: IS
375: CURSOR l_cur IS
376: SELECT email_address
377: FROM fnd_user
378: WHERE user_id = fnd_global.user_id;
379:
380: l_email fnd_user.email_address%TYPE;
381: BEGIN

Line 380: l_email fnd_user.email_address%TYPE;

376: SELECT email_address
377: FROM fnd_user
378: WHERE user_id = fnd_global.user_id;
379:
380: l_email fnd_user.email_address%TYPE;
381: BEGIN
382: OPEN l_cur;
383: FETCH l_cur INTO l_email;
384: CLOSE l_cur;

Line 417: l_user_name FND_USER.USER_NAME%TYPE;

413: lv_unencrypted_password VARCHAR2(100);
414: l_reg_key fnd_registrations.registration_key%TYPE;
415: l_osn_req_id NUMBER;
416: l_internal_id NUMBER;
417: l_user_name FND_USER.USER_NAME%TYPE;
418: l_testname NUMBER;
419:
420: CURSOR l_cur IS
421: SELECT d1.field_value_number, d2.field_value_number

Line 486: l_testname := FND_USER_PKG.TestUserName(l_user_name);

482: into l_user_name
483: from fnd_registrations r
484: where r.registration_id = p_registration_id;
485:
486: l_testname := FND_USER_PKG.TestUserName(l_user_name);
487: IF (l_testname = FND_USER_PKG.USER_SYNCHED) THEN
488: lv_unencrypted_password := NULL;
489: END IF;
490:

Line 487: IF (l_testname = FND_USER_PKG.USER_SYNCHED) THEN

483: from fnd_registrations r
484: where r.registration_id = p_registration_id;
485:
486: l_testname := FND_USER_PKG.TestUserName(l_user_name);
487: IF (l_testname = FND_USER_PKG.USER_SYNCHED) THEN
488: lv_unencrypted_password := NULL;
489: END IF;
490:
491: RETURN lv_unencrypted_password;

Line 525: l_user_name FND_USER.USER_NAME%TYPE;

521: FUNCTION set_initial_password(l_reg_id NUMBER)
522: RETURN VARCHAR2
523:
524: IS
525: l_user_name FND_USER.USER_NAME%TYPE;
526: l_osn_req_id NUMBER;
527: l_internal_id NUMBER;
528: l_reg_key FND_REGISTRATIONS.REGISTRATION_KEY%TYPE;
529: l_encrypted_initial_password VARCHAR2(240);

Line 619: FROM fnd_user fu,

615: l_progress VARCHAR2(255);
616:
617: cursor l_role_cur is
618: SELECT final.role_name
619: FROM fnd_user fu,
620: fnd_responsibility fr,
621: wf_user_roles wur, wf_user_roles final
622: WHERE fr.menu_id in
623: (SELECT fme.menu_id

Line 671: l_user_name FND_USER.USER_NAME%TYPE := NULL;

667:
668: IS
669: x_refcur g_refcur;
670: l_approver_func_id NUMBER := NULL;
671: l_user_name FND_USER.USER_NAME%TYPE := NULL;
672: l_num_users NUMBER := 0;
673: l_approverlist VARCHAR2(2000):=NULL;
674: l_approverlist_sql VARCHAR2(2000):=NULL;
675: l_role_name WF_USER_ROLES.ROLE_NAME%TYPE := NULL;

Line 690: FROM fnd_user fu,

686: WHERE function_name = 'POS_REG_APPROVE_EXT_USERS';
687:
688: OPEN x_refcur FOR
689: 'SELECT DISTINCT fu.user_name
690: FROM fnd_user fu,
691: fnd_responsibility fr,
692: wf_user_roles wur
693: WHERE fr.menu_id in
694: (SELECT fme.menu_id

Line 1327: if (FND_USER_PKG.TestUserName(l_rec.requested_user_name) = FND_USER_PKG.USER_SYNCHED) then

1323: RETURN;
1324: END IF;
1325:
1326: l_user_in_oid := 'N';
1327: if (FND_USER_PKG.TestUserName(l_rec.requested_user_name) = FND_USER_PKG.USER_SYNCHED) then
1328: l_user_in_oid := 'Y';
1329: end if;
1330:
1331: -- create supplier user account

Line 1521: fnd_user fu

1517: fu.user_name
1518: FROM fnd_registration_details frd1,
1519: fnd_registration_details frd2,
1520: fnd_registrations fr,
1521: fnd_user fu
1522: WHERE frd1.registration_id = fr.registration_id
1523: AND frd1.field_name = 'Supplier Name'
1524: AND frd2.registration_id = fr.registration_id
1525: AND frd2.field_name = 'Approver ID'