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

Line 519: lv_reg_type FND_REGISTRATIONS.REGISTRATION_TYPE%TYPE := NULL;

515: IS
516:
517: ln_reg_id NUMBER := -1;
518: ln_app_id NUMBER := -1;
519: lv_reg_type FND_REGISTRATIONS.REGISTRATION_TYPE%TYPE := NULL;
520:
521: lv_registration_key WF_ITEM_ATTRIBUTE_VALUES.TEXT_VALUE%TYPE;
522: lv_proc_name VARCHAR2(30) := 'UpdItemTypeKeyHelper';
523:

Line 592: lv_reg_status FND_REGISTRATIONS.REGISTRATION_STATUS%TYPE;

588: )
589: IS
590:
591: lv_reg_key WF_ITEM_ATTRIBUTE_VALUES.TEXT_VALUE%TYPE;
592: lv_reg_status FND_REGISTRATIONS.REGISTRATION_STATUS%TYPE;
593: lv_proc_name VARCHAR2(30) := 'LockReg';
594:
595: BEGIN
596:

Line 620: FROM fnd_registrations

616:
617: -- lock the registration record row
618: SELECT registration_status
619: INTO lv_reg_status
620: FROM fnd_registrations
621: WHERE registration_key = lv_reg_key
622: FOR UPDATE;
623:
624: -- check the precondition of registration

Line 692: lv_reg_status FND_REGISTRATIONS.REGISTRATION_STATUS%TYPE;

688: )
689: IS
690:
691: lv_reg_key WF_ITEM_ATTRIBUTE_VALUES.TEXT_VALUE%TYPE;
692: lv_reg_status FND_REGISTRATIONS.REGISTRATION_STATUS%TYPE;
693: lv_proc_name VARCHAR2(30) := 'LockApprv';
694:
695: BEGIN
696:

Line 721: FROM fnd_registrations

717:
718: -- lock the registration record row
719: SELECT registration_status
720: INTO lv_reg_status
721: FROM fnd_registrations
722: WHERE registration_key = lv_reg_key
723: FOR UPDATE;
724:
725: -- check the pre-condition of an approval process

Line 1083: lv_registrant_lang FND_REGISTRATIONS.LANGUAGE_CODE%TYPE;

1079:
1080: lv_reg_key WF_ITEM_ATTRIBUTE_VALUES.TEXT_VALUE%TYPE;
1081: ln_reg_id NUMBER;
1082:
1083: lv_registrant_lang FND_REGISTRATIONS.LANGUAGE_CODE%TYPE;
1084: lv_registrant_email FND_REGISTRATIONS.EMAIL%TYPE;
1085:
1086: lv_enterprise_name HZ_PARTIES.PARTY_NAME%TYPE;
1087: lv_reg_page_url VARCHAR2(32000);

Line 1084: lv_registrant_email FND_REGISTRATIONS.EMAIL%TYPE;

1080: lv_reg_key WF_ITEM_ATTRIBUTE_VALUES.TEXT_VALUE%TYPE;
1081: ln_reg_id NUMBER;
1082:
1083: lv_registrant_lang FND_REGISTRATIONS.LANGUAGE_CODE%TYPE;
1084: lv_registrant_email FND_REGISTRATIONS.EMAIL%TYPE;
1085:
1086: lv_enterprise_name HZ_PARTIES.PARTY_NAME%TYPE;
1087: lv_reg_page_url VARCHAR2(32000);
1088:

Line 1122: FROM fnd_registrations

1118:
1119: BEGIN
1120: SELECT NVL(language_code, 'US'), email
1121: INTO lv_registrant_lang, lv_registrant_email
1122: FROM fnd_registrations
1123: WHERE registration_id = ln_reg_id;
1124: EXCEPTION WHEN OTHERS THEN
1125:
1126: IF ( fnd_log.level_exception >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

Line 1239: lv_first_name FND_REGISTRATIONS.FIRST_NAME%TYPE := NULL;

1235:
1236: lv_reg_key WF_ITEM_ATTRIBUTE_VALUES.TEXT_VALUE%TYPE;
1237: ln_reg_id NUMBER;
1238:
1239: lv_first_name FND_REGISTRATIONS.FIRST_NAME%TYPE := NULL;
1240: lv_last_name FND_REGISTRATIONS.LAST_NAME%TYPE := NULL;
1241: lv_vendor_name FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE := NULL;
1242: lv_osn_tp_name FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE := NULL;
1243: ln_approver_id NUMBER := NULL;

Line 1240: lv_last_name FND_REGISTRATIONS.LAST_NAME%TYPE := NULL;

1236: lv_reg_key WF_ITEM_ATTRIBUTE_VALUES.TEXT_VALUE%TYPE;
1237: ln_reg_id NUMBER;
1238:
1239: lv_first_name FND_REGISTRATIONS.FIRST_NAME%TYPE := NULL;
1240: lv_last_name FND_REGISTRATIONS.LAST_NAME%TYPE := NULL;
1241: lv_vendor_name FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE := NULL;
1242: lv_osn_tp_name FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE := NULL;
1243: ln_approver_id NUMBER := NULL;
1244: --lv_approver_role FND_USER.USER_NAME%TYPE := NULL; --varchar2(100)

Line 1283: FROM fnd_registrations

1279:
1280: BEGIN
1281: SELECT first_name, last_name
1282: INTO lv_first_name, lv_last_name
1283: FROM fnd_registrations
1284: WHERE registration_id = ln_reg_id;
1285: EXCEPTION WHEN OTHERS THEN
1286:
1287: IF ( fnd_log.level_exception >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

Line 1502: lv_requested_user_name FND_REGISTRATIONS.REQUESTED_USER_NAME%TYPE := NULL;

1498:
1499: lv_reg_key WF_ITEM_ATTRIBUTE_VALUES.TEXT_VALUE%TYPE;
1500: ln_reg_id NUMBER;
1501:
1502: lv_requested_user_name FND_REGISTRATIONS.REQUESTED_USER_NAME%TYPE := NULL;
1503: lv_user_email FND_REGISTRATIONS.EMAIL%TYPE := NULL;
1504: lv_first_name FND_REGISTRATIONS.FIRST_NAME%TYPE := NULL;
1505: lv_last_name FND_REGISTRATIONS.LAST_NAME%TYPE := NULL;
1506: lv_middle_name FND_REGISTRATIONS.MIDDLE_NAME%TYPE := NULL;

Line 1503: lv_user_email FND_REGISTRATIONS.EMAIL%TYPE := NULL;

1499: lv_reg_key WF_ITEM_ATTRIBUTE_VALUES.TEXT_VALUE%TYPE;
1500: ln_reg_id NUMBER;
1501:
1502: lv_requested_user_name FND_REGISTRATIONS.REQUESTED_USER_NAME%TYPE := NULL;
1503: lv_user_email FND_REGISTRATIONS.EMAIL%TYPE := NULL;
1504: lv_first_name FND_REGISTRATIONS.FIRST_NAME%TYPE := NULL;
1505: lv_last_name FND_REGISTRATIONS.LAST_NAME%TYPE := NULL;
1506: lv_middle_name FND_REGISTRATIONS.MIDDLE_NAME%TYPE := NULL;
1507: lv_title FND_REGISTRATIONS.USER_TITLE%TYPE := NULL;

Line 1504: lv_first_name FND_REGISTRATIONS.FIRST_NAME%TYPE := NULL;

1500: ln_reg_id NUMBER;
1501:
1502: lv_requested_user_name FND_REGISTRATIONS.REQUESTED_USER_NAME%TYPE := NULL;
1503: lv_user_email FND_REGISTRATIONS.EMAIL%TYPE := NULL;
1504: lv_first_name FND_REGISTRATIONS.FIRST_NAME%TYPE := NULL;
1505: lv_last_name FND_REGISTRATIONS.LAST_NAME%TYPE := NULL;
1506: lv_middle_name FND_REGISTRATIONS.MIDDLE_NAME%TYPE := NULL;
1507: lv_title FND_REGISTRATIONS.USER_TITLE%TYPE := NULL;
1508: lv_phone FND_REGISTRATIONS.PHONE%TYPE := NULL;

Line 1505: lv_last_name FND_REGISTRATIONS.LAST_NAME%TYPE := NULL;

1501:
1502: lv_requested_user_name FND_REGISTRATIONS.REQUESTED_USER_NAME%TYPE := NULL;
1503: lv_user_email FND_REGISTRATIONS.EMAIL%TYPE := NULL;
1504: lv_first_name FND_REGISTRATIONS.FIRST_NAME%TYPE := NULL;
1505: lv_last_name FND_REGISTRATIONS.LAST_NAME%TYPE := NULL;
1506: lv_middle_name FND_REGISTRATIONS.MIDDLE_NAME%TYPE := NULL;
1507: lv_title FND_REGISTRATIONS.USER_TITLE%TYPE := NULL;
1508: lv_phone FND_REGISTRATIONS.PHONE%TYPE := NULL;
1509: lv_phone_ext FND_REGISTRATIONS.PHONE_EXTENSION%TYPE := NULL;

Line 1506: lv_middle_name FND_REGISTRATIONS.MIDDLE_NAME%TYPE := NULL;

1502: lv_requested_user_name FND_REGISTRATIONS.REQUESTED_USER_NAME%TYPE := NULL;
1503: lv_user_email FND_REGISTRATIONS.EMAIL%TYPE := NULL;
1504: lv_first_name FND_REGISTRATIONS.FIRST_NAME%TYPE := NULL;
1505: lv_last_name FND_REGISTRATIONS.LAST_NAME%TYPE := NULL;
1506: lv_middle_name FND_REGISTRATIONS.MIDDLE_NAME%TYPE := NULL;
1507: lv_title FND_REGISTRATIONS.USER_TITLE%TYPE := NULL;
1508: lv_phone FND_REGISTRATIONS.PHONE%TYPE := NULL;
1509: lv_phone_ext FND_REGISTRATIONS.PHONE_EXTENSION%TYPE := NULL;
1510: lv_fax FND_REGISTRATIONS.FAX%TYPE := NULL;

Line 1507: lv_title FND_REGISTRATIONS.USER_TITLE%TYPE := NULL;

1503: lv_user_email FND_REGISTRATIONS.EMAIL%TYPE := NULL;
1504: lv_first_name FND_REGISTRATIONS.FIRST_NAME%TYPE := NULL;
1505: lv_last_name FND_REGISTRATIONS.LAST_NAME%TYPE := NULL;
1506: lv_middle_name FND_REGISTRATIONS.MIDDLE_NAME%TYPE := NULL;
1507: lv_title FND_REGISTRATIONS.USER_TITLE%TYPE := NULL;
1508: lv_phone FND_REGISTRATIONS.PHONE%TYPE := NULL;
1509: lv_phone_ext FND_REGISTRATIONS.PHONE_EXTENSION%TYPE := NULL;
1510: lv_fax FND_REGISTRATIONS.FAX%TYPE := NULL;
1511:

Line 1508: lv_phone FND_REGISTRATIONS.PHONE%TYPE := NULL;

1504: lv_first_name FND_REGISTRATIONS.FIRST_NAME%TYPE := NULL;
1505: lv_last_name FND_REGISTRATIONS.LAST_NAME%TYPE := NULL;
1506: lv_middle_name FND_REGISTRATIONS.MIDDLE_NAME%TYPE := NULL;
1507: lv_title FND_REGISTRATIONS.USER_TITLE%TYPE := NULL;
1508: lv_phone FND_REGISTRATIONS.PHONE%TYPE := NULL;
1509: lv_phone_ext FND_REGISTRATIONS.PHONE_EXTENSION%TYPE := NULL;
1510: lv_fax FND_REGISTRATIONS.FAX%TYPE := NULL;
1511:
1512: ln_approver_id NUMBER;

Line 1509: lv_phone_ext FND_REGISTRATIONS.PHONE_EXTENSION%TYPE := NULL;

1505: lv_last_name FND_REGISTRATIONS.LAST_NAME%TYPE := NULL;
1506: lv_middle_name FND_REGISTRATIONS.MIDDLE_NAME%TYPE := NULL;
1507: lv_title FND_REGISTRATIONS.USER_TITLE%TYPE := NULL;
1508: lv_phone FND_REGISTRATIONS.PHONE%TYPE := NULL;
1509: lv_phone_ext FND_REGISTRATIONS.PHONE_EXTENSION%TYPE := NULL;
1510: lv_fax FND_REGISTRATIONS.FAX%TYPE := NULL;
1511:
1512: ln_approver_id NUMBER;
1513: lv_contact_email FND_USER.EMAIL_ADDRESS%TYPE;

Line 1510: lv_fax FND_REGISTRATIONS.FAX%TYPE := NULL;

1506: lv_middle_name FND_REGISTRATIONS.MIDDLE_NAME%TYPE := NULL;
1507: lv_title FND_REGISTRATIONS.USER_TITLE%TYPE := NULL;
1508: lv_phone FND_REGISTRATIONS.PHONE%TYPE := NULL;
1509: lv_phone_ext FND_REGISTRATIONS.PHONE_EXTENSION%TYPE := NULL;
1510: lv_fax FND_REGISTRATIONS.FAX%TYPE := NULL;
1511:
1512: ln_approver_id NUMBER;
1513: lv_contact_email FND_USER.EMAIL_ADDRESS%TYPE;
1514: lv_logon_page_url VARCHAR2(32000) := NULL;

Line 1557: FROM fnd_registrations

1553:
1554: BEGIN
1555: SELECT requested_user_name, email, first_name, last_name, middle_name, user_title, phone, phone_extension, fax
1556: INTO lv_requested_user_name, lv_user_email, lv_first_name, lv_last_name, lv_middle_name, lv_title, lv_phone, lv_phone_ext, lv_fax
1557: FROM fnd_registrations
1558: WHERE registration_id = ln_reg_id;
1559: EXCEPTION WHEN OTHERS THEN
1560:
1561: IF ( fnd_log.level_exception >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

Line 1816: lv_registrant_lang FND_REGISTRATIONS.LANGUAGE_CODE%TYPE;

1812:
1813: lv_reg_key WF_ITEM_ATTRIBUTE_VALUES.TEXT_VALUE%TYPE;
1814: ln_reg_id NUMBER;
1815:
1816: lv_registrant_lang FND_REGISTRATIONS.LANGUAGE_CODE%TYPE;
1817: lv_registrant_email FND_REGISTRATIONS.EMAIL%TYPE;
1818:
1819: lv_enterprise_name HZ_PARTIES.PARTY_NAME%TYPE;
1820:

Line 1817: lv_registrant_email FND_REGISTRATIONS.EMAIL%TYPE;

1813: lv_reg_key WF_ITEM_ATTRIBUTE_VALUES.TEXT_VALUE%TYPE;
1814: ln_reg_id NUMBER;
1815:
1816: lv_registrant_lang FND_REGISTRATIONS.LANGUAGE_CODE%TYPE;
1817: lv_registrant_email FND_REGISTRATIONS.EMAIL%TYPE;
1818:
1819: lv_enterprise_name HZ_PARTIES.PARTY_NAME%TYPE;
1820:
1821: ln_approver_id NUMBER;

Line 1856: FROM fnd_registrations

1852:
1853: BEGIN
1854: SELECT NVL(language_code, 'US'), email
1855: INTO lv_registrant_lang, lv_registrant_email
1856: FROM fnd_registrations
1857: WHERE registration_id = ln_reg_id;
1858: EXCEPTION WHEN OTHERS THEN
1859:
1860: IF ( fnd_log.level_exception >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

Line 3444: l_reg_key FND_REGISTRATIONS.REGISTRATION_KEY%TYPE;

3440: is
3441: l_user_name FND_USER.USER_NAME%TYPE;
3442: l_osn_req_id NUMBER;
3443: l_internal_id NUMBER;
3444: l_reg_key FND_REGISTRATIONS.REGISTRATION_KEY%TYPE;
3445: l_encrypted_initial_password VARCHAR2(240);
3446: l_initial_password VARCHAR2(30);
3447: l_retcode VARCHAR2(1);
3448: begin

Line 3455: from fnd_registrations r,

3451:
3452: --r12 requirement to use centralized password management
3453: select r.requested_user_name, d1.field_value_number, d2.field_value_number
3454: into l_user_name, l_osn_req_id, l_internal_id
3455: from fnd_registrations r,
3456: fnd_registration_details d1, fnd_registration_details d2
3457: where r.registration_id = l_reg_id
3458: and d1.registration_id = l_reg_id
3459: and d2.registration_id = l_reg_id

Line 3470: from fnd_registration_details d, fnd_registrations r

3466: -- to be compatible with old requests
3467: if (l_initial_password is NULL) then
3468: select d.field_value_string, r.requested_user_name, r.registration_key
3469: into l_encrypted_initial_password, l_user_name, l_reg_key
3470: from fnd_registration_details d, fnd_registrations r
3471: where r.registration_id = l_reg_id
3472: and d.registration_id = l_reg_id
3473: and d.field_name = 'Initial Pass';
3474: