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_SUPPLIER_USER_REG_PKG dependencies on FND_REGISTRATIONS

Line 353: FROM fnd_registrations

349: IS
350: l_registration_id NUMBER;
351: BEGIN
352: SELECT registration_id INTO l_registration_id
353: FROM fnd_registrations
354: WHERE registration_id = p_registration_id FOR UPDATE;
355: END lock_reg;
356:
357: FUNCTION get_note (p_registration_id IN NUMBER) RETURN VARCHAR2

Line 414: l_reg_key fnd_registrations.registration_key%TYPE;

410: (p_registration_id IN NUMBER) RETURN VARCHAR2
411: IS
412: l_encrypted_initial_password fnd_registration_details.field_value_string%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;

Line 422: FROM fnd_registrations r,

418: l_testname NUMBER;
419:
420: CURSOR l_cur IS
421: SELECT d1.field_value_number, d2.field_value_number
422: FROM fnd_registrations r,
423: fnd_registration_details d1, fnd_registration_details d2
424: WHERE r.registration_id = p_registration_id
425: AND d1.registration_id = r.registration_id
426: AND d2.registration_id = r.registration_id

Line 454: FROM fnd_registrations

450: l_encrypted_initial_password := NULL;
451:
452: SELECT registration_key
453: INTO l_reg_key
454: FROM fnd_registrations
455: WHERE registration_id = p_registration_id;
456:
457: SELECT field_value_string
458: INTO l_encrypted_initial_password

Line 483: from fnd_registrations r

479: -- sso check: for users that already have an account in oid, add synch is allowed
480: -- we should pass null as the password when creating the user account in fnd
481: select r.requested_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

Line 501: fnd_registrations fr

497: IS
498: CURSOR l_cur IS
499: SELECT frd1.field_value_string tp_name
500: FROM fnd_registration_details frd1,
501: fnd_registrations fr
502: WHERE frd1.registration_id = fr.registration_id
503: AND frd1.field_name = 'OSN TP Name'
504: AND fr.registration_id = p_registration_id;
505:

Line 528: l_reg_key FND_REGISTRATIONS.REGISTRATION_KEY%TYPE;

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);
530: l_initial_password VARCHAR2(30);
531: l_retcode VARCHAR2(1);
532: BEGIN

Line 546: FROM fnd_registrations r,

542: END IF;
543:
544: SELECT r.requested_user_name, d1.field_value_number, d2.field_value_number
545: INTO l_user_name, l_osn_req_id, l_internal_id
546: FROM fnd_registrations r,
547: fnd_registration_details d1, fnd_registration_details d2
548: WHERE r.registration_id = l_reg_id
549: AND d1.registration_id = l_reg_id
550: AND d2.registration_id = l_reg_id

Line 1247: fnd_registrations fr, fnd_registration_details jobt

1243: SELECT pv.party_id vendor_party_id,
1244: fr.*, jobt.field_value_string
1245: FROM po_vendors pv,
1246: fnd_registration_details frd,
1247: fnd_registrations fr, fnd_registration_details jobt
1248: WHERE frd.registration_id = fr.registration_id
1249: AND pv.vendor_id = frd.field_value_number
1250: AND frd.field_name = 'Supplier Number'
1251: AND jobt.field_name = 'Job Title'

Line 1369: UPDATE fnd_registrations

1365: ROLLBACK TO supplier_user_reg_approve_sp;
1366: RETURN;
1367: END IF;
1368:
1369: UPDATE fnd_registrations
1370: SET registration_status = 'APPROVED',
1371: last_update_date = Sysdate,
1372: last_update_login = fnd_global.login_id,
1373: last_updated_by = fnd_global.user_id

Line 1407: l_email fnd_registrations.email%TYPE;

1403: x_msg_count OUT nocopy NUMBER,
1404: x_msg_data OUT nocopy VARCHAR2
1405: )
1406: IS
1407: l_email fnd_registrations.email%TYPE;
1408: l_language_code fnd_registrations.language_code%TYPE;
1409: BEGIN
1410: SAVEPOINT supplier_user_reject_sp;
1411: UPDATE fnd_registrations

Line 1408: l_language_code fnd_registrations.language_code%TYPE;

1404: x_msg_data OUT nocopy VARCHAR2
1405: )
1406: IS
1407: l_email fnd_registrations.email%TYPE;
1408: l_language_code fnd_registrations.language_code%TYPE;
1409: BEGIN
1410: SAVEPOINT supplier_user_reject_sp;
1411: UPDATE fnd_registrations
1412: SET registration_status = 'REJECTED',

Line 1411: UPDATE fnd_registrations

1407: l_email fnd_registrations.email%TYPE;
1408: l_language_code fnd_registrations.language_code%TYPE;
1409: BEGIN
1410: SAVEPOINT supplier_user_reject_sp;
1411: UPDATE fnd_registrations
1412: SET registration_status = 'REJECTED',
1413: last_update_date = Sysdate,
1414: last_update_login = fnd_global.login_id,
1415: last_updated_by = fnd_global.user_id

Line 1420: FROM fnd_registrations

1416: WHERE registration_id = p_registration_id;
1417:
1418: SELECT email, language_code
1419: INTO l_email, l_language_code
1420: FROM fnd_registrations
1421: WHERE registration_id = p_registration_id;
1422:
1423: send_rejection_ntf
1424: (p_registration_id => p_registration_id,

Line 1447: l_email fnd_registrations.email%TYPE;

1443: x_msg_count OUT nocopy NUMBER,
1444: x_msg_data OUT nocopy VARCHAR2
1445: )
1446: IS
1447: l_email fnd_registrations.email%TYPE;
1448: l_language_code fnd_registrations.language_code%TYPE;
1449: l_reg_key fnd_registrations.registration_key%TYPE;
1450: BEGIN
1451: SAVEPOINT supplier_user_invite_sp;

Line 1448: l_language_code fnd_registrations.language_code%TYPE;

1444: x_msg_data OUT nocopy VARCHAR2
1445: )
1446: IS
1447: l_email fnd_registrations.email%TYPE;
1448: l_language_code fnd_registrations.language_code%TYPE;
1449: l_reg_key fnd_registrations.registration_key%TYPE;
1450: BEGIN
1451: SAVEPOINT supplier_user_invite_sp;
1452: UPDATE fnd_registrations

Line 1449: l_reg_key fnd_registrations.registration_key%TYPE;

1445: )
1446: IS
1447: l_email fnd_registrations.email%TYPE;
1448: l_language_code fnd_registrations.language_code%TYPE;
1449: l_reg_key fnd_registrations.registration_key%TYPE;
1450: BEGIN
1451: SAVEPOINT supplier_user_invite_sp;
1452: UPDATE fnd_registrations
1453: SET registration_status = 'INVITED',

Line 1452: UPDATE fnd_registrations

1448: l_language_code fnd_registrations.language_code%TYPE;
1449: l_reg_key fnd_registrations.registration_key%TYPE;
1450: BEGIN
1451: SAVEPOINT supplier_user_invite_sp;
1452: UPDATE fnd_registrations
1453: SET registration_status = 'INVITED',
1454: last_update_date = Sysdate,
1455: last_update_login = fnd_global.login_id,
1456: last_updated_by = fnd_global.user_id

Line 1461: FROM fnd_registrations

1457: WHERE registration_id = p_registration_id;
1458:
1459: SELECT email, language_code, registration_key
1460: INTO l_email, l_language_code, l_reg_key
1461: FROM fnd_registrations
1462: WHERE registration_id = p_registration_id;
1463:
1464: send_invitation_ntf
1465: (p_registration_id => p_registration_id,

Line 1495: fnd_registrations fr,

1491: frd2.field_value_number approver_id,
1492: fu.user_name
1493: FROM fnd_registration_details frd1,
1494: fnd_registration_details frd2,
1495: fnd_registrations fr,
1496: fnd_user fu
1497: WHERE frd1.registration_id = fr.registration_id
1498: AND frd1.field_name = 'Supplier Name'
1499: AND frd2.registration_id = fr.registration_id

Line 1507: UPDATE fnd_registrations

1503:
1504: l_rec l_cur%ROWTYPE;
1505: BEGIN
1506: SAVEPOINT supplier_user_respond_sp;
1507: UPDATE fnd_registrations
1508: SET registration_status = 'REGISTERED',
1509: last_update_date = Sysdate,
1510: last_update_login = fnd_global.login_id,
1511: last_updated_by = fnd_global.user_id