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_REGISTRATION_DETAILS

Line 361: FROM fnd_registration_details

357: FUNCTION get_note (p_registration_id IN NUMBER) RETURN VARCHAR2
358: IS
359: CURSOR l_cur IS
360: SELECT field_value_string
361: FROM fnd_registration_details
362: WHERE field_name = 'Note'
363: AND registration_id = p_registration_id;
364:
365: l_note fnd_registration_details.field_value_string%TYPE;

Line 365: l_note fnd_registration_details.field_value_string%TYPE;

361: FROM fnd_registration_details
362: WHERE field_name = 'Note'
363: AND registration_id = p_registration_id;
364:
365: l_note fnd_registration_details.field_value_string%TYPE;
366: BEGIN
367: OPEN l_cur;
368: FETCH l_cur INTO l_note;
369: CLOSE l_cur;

Line 412: l_encrypted_initial_password fnd_registration_details.field_value_string%TYPE;

408:
409: FUNCTION get_password
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;

Line 423: fnd_registration_details d1, fnd_registration_details d2

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
427: AND d1.field_name = 'OSN Request ID'

Line 459: FROM fnd_registration_details

455: WHERE registration_id = p_registration_id;
456:
457: SELECT field_value_string
458: INTO l_encrypted_initial_password
459: FROM fnd_registration_details
460: WHERE registration_id = p_registration_id
461: AND field_name = 'Initial Pass';
462:
463: lv_unencrypted_password := decrypt (l_reg_key,

Line 500: FROM fnd_registration_details frd1,

496: (p_registration_id IN NUMBER) RETURN VARCHAR2
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;

Line 506: l_tpname fnd_registration_details.field_value_string%TYPE;

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:
506: l_tpname fnd_registration_details.field_value_string%TYPE;
507: BEGIN
508: OPEN l_cur;
509: FETCH l_cur INTO l_tpname;
510: CLOSE l_cur;

Line 547: fnd_registration_details d1, fnd_registration_details d2

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
551: AND d1.field_name = 'OSN Request ID'

Line 574: FROM fnd_registration_details

570: FUNCTION is_osnrequest(p_registration_id IN NUMBER) RETURN VARCHAR2
571: IS
572: CURSOR l_cur IS
573: SELECT field_value_number
574: FROM fnd_registration_details
575: WHERE field_name = 'OSN Request ID'
576: AND registration_id = p_registration_id;
577:
578: l_osnreqid fnd_registration_details.field_value_number%TYPE;

Line 578: l_osnreqid fnd_registration_details.field_value_number%TYPE;

574: FROM fnd_registration_details
575: WHERE field_name = 'OSN Request ID'
576: AND registration_id = p_registration_id;
577:
578: l_osnreqid fnd_registration_details.field_value_number%TYPE;
579: BEGIN
580: OPEN l_cur;
581: FETCH l_cur INTO l_osnreqid;
582: IF l_cur%notfound THEN

Line 768: FROM fnd_registration_details

764: )
765: IS
766: CURSOR l_cur IS
767: SELECT field_value_string
768: FROM fnd_registration_details
769: WHERE registration_id = p_registration_id
770: AND field_name LIKE 'POS_SUPPLIER_RESP_ID%';
771:
772: l_resp_id NUMBER;

Line 811: FROM fnd_registration_details

807: )
808: IS
809: CURSOR l_cur IS
810: SELECT DISTINCT field_value_number, field_name
811: FROM fnd_registration_details
812: WHERE registration_id = p_registration_id
813: AND (field_name like 'POS_SUPPLIER_ID%'
814: OR field_name like 'POS_SUPPLIER_SITE_ID%'
815: OR field_name like 'POS_SUPPLIER_CONTACT_ID%'

Line 1213: FROM fnd_registration_details

1209: (p_registration_id IN NUMBER) RETURN VARCHAR2
1210: IS
1211: CURSOR l_cur IS
1212: SELECT field_value_string
1213: FROM fnd_registration_details
1214: WHERE field_name = 'Invited Flag'
1215: AND registration_id = p_registration_id;
1216:
1217: l_value fnd_registration_details.field_value_string%TYPE;

Line 1217: l_value fnd_registration_details.field_value_string%TYPE;

1213: FROM fnd_registration_details
1214: WHERE field_name = 'Invited Flag'
1215: AND registration_id = p_registration_id;
1216:
1217: l_value fnd_registration_details.field_value_string%TYPE;
1218: BEGIN
1219: OPEN l_cur;
1220: FETCH l_cur INTO l_value;
1221: CLOSE l_cur;

Line 1246: fnd_registration_details frd,

1242: CURSOR l_cur IS
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'

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 1493: FROM fnd_registration_details frd1,

1489: fr.email, fr.language_code, fr.registration_key,
1490: frd1.field_value_string vendor_name,
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

Line 1494: fnd_registration_details frd2,

1490: frd1.field_value_string vendor_name,
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'