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 1265: fnd_registrations fr, fnd_registration_details jobt

1261: SELECT pv.party_id vendor_party_id,
1262: fr.*, jobt.field_value_string
1263: FROM po_vendors pv,
1264: fnd_registration_details frd,
1265: fnd_registrations fr, fnd_registration_details jobt
1266: WHERE frd.registration_id = fr.registration_id
1267: AND pv.vendor_id = frd.field_value_number
1268: AND frd.field_name = 'Supplier Number'
1269: AND jobt.field_name = 'Job Title'

Line 1387: UPDATE fnd_registrations

1383: ROLLBACK TO supplier_user_reg_approve_sp;
1384: RETURN;
1385: END IF;
1386:
1387: UPDATE fnd_registrations
1388: SET registration_status = 'APPROVED',
1389: last_update_date = Sysdate,
1390: last_update_login = fnd_global.login_id,
1391: last_updated_by = fnd_global.user_id

Line 1425: l_email fnd_registrations.email%TYPE;

1421: x_msg_count OUT nocopy NUMBER,
1422: x_msg_data OUT nocopy VARCHAR2
1423: )
1424: IS
1425: l_email fnd_registrations.email%TYPE;
1426: l_language_code fnd_registrations.language_code%TYPE;
1427: event_id Number;
1428: BEGIN
1429: SAVEPOINT supplier_user_reject_sp;

Line 1426: l_language_code fnd_registrations.language_code%TYPE;

1422: x_msg_data OUT nocopy VARCHAR2
1423: )
1424: IS
1425: l_email fnd_registrations.email%TYPE;
1426: l_language_code fnd_registrations.language_code%TYPE;
1427: event_id Number;
1428: BEGIN
1429: SAVEPOINT supplier_user_reject_sp;
1430: UPDATE fnd_registrations

Line 1430: UPDATE fnd_registrations

1426: l_language_code fnd_registrations.language_code%TYPE;
1427: event_id Number;
1428: BEGIN
1429: SAVEPOINT supplier_user_reject_sp;
1430: UPDATE fnd_registrations
1431: SET registration_status = 'REJECTED',
1432: last_update_date = Sysdate,
1433: last_update_login = fnd_global.login_id,
1434: last_updated_by = fnd_global.user_id

Line 1439: FROM fnd_registrations

1435: WHERE registration_id = p_registration_id;
1436:
1437: SELECT email, language_code
1438: INTO l_email, l_language_code
1439: FROM fnd_registrations
1440: WHERE registration_id = p_registration_id;
1441:
1442: send_rejection_ntf
1443: (p_registration_id => p_registration_id,

Line 1472: l_email fnd_registrations.email%TYPE;

1468: x_msg_count OUT nocopy NUMBER,
1469: x_msg_data OUT nocopy VARCHAR2
1470: )
1471: IS
1472: l_email fnd_registrations.email%TYPE;
1473: l_language_code fnd_registrations.language_code%TYPE;
1474: l_reg_key fnd_registrations.registration_key%TYPE;
1475: BEGIN
1476: SAVEPOINT supplier_user_invite_sp;

Line 1473: l_language_code fnd_registrations.language_code%TYPE;

1469: x_msg_data OUT nocopy VARCHAR2
1470: )
1471: IS
1472: l_email fnd_registrations.email%TYPE;
1473: l_language_code fnd_registrations.language_code%TYPE;
1474: l_reg_key fnd_registrations.registration_key%TYPE;
1475: BEGIN
1476: SAVEPOINT supplier_user_invite_sp;
1477: UPDATE fnd_registrations

Line 1474: l_reg_key fnd_registrations.registration_key%TYPE;

1470: )
1471: IS
1472: l_email fnd_registrations.email%TYPE;
1473: l_language_code fnd_registrations.language_code%TYPE;
1474: l_reg_key fnd_registrations.registration_key%TYPE;
1475: BEGIN
1476: SAVEPOINT supplier_user_invite_sp;
1477: UPDATE fnd_registrations
1478: SET registration_status = 'INVITED',

Line 1477: UPDATE fnd_registrations

1473: l_language_code fnd_registrations.language_code%TYPE;
1474: l_reg_key fnd_registrations.registration_key%TYPE;
1475: BEGIN
1476: SAVEPOINT supplier_user_invite_sp;
1477: UPDATE fnd_registrations
1478: SET registration_status = 'INVITED',
1479: last_update_date = Sysdate,
1480: last_update_login = fnd_global.login_id,
1481: last_updated_by = fnd_global.user_id

Line 1486: FROM fnd_registrations

1482: WHERE registration_id = p_registration_id;
1483:
1484: SELECT email, language_code, registration_key
1485: INTO l_email, l_language_code, l_reg_key
1486: FROM fnd_registrations
1487: WHERE registration_id = p_registration_id;
1488:
1489: send_invitation_ntf
1490: (p_registration_id => p_registration_id,

Line 1520: fnd_registrations fr,

1516: frd2.field_value_number approver_id,
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

Line 1532: UPDATE fnd_registrations

1528:
1529: l_rec l_cur%ROWTYPE;
1530: BEGIN
1531: SAVEPOINT supplier_user_respond_sp;
1532: UPDATE fnd_registrations
1533: SET registration_status = 'REGISTERED',
1534: last_update_date = Sysdate,
1535: last_update_login = fnd_global.login_id,
1536: last_updated_by = fnd_global.user_id