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_REGISTRATION_DETAILS

Line 1089: lv_notes FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE;

1085:
1086: lv_enterprise_name HZ_PARTIES.PARTY_NAME%TYPE;
1087: lv_reg_page_url VARCHAR2(32000);
1088:
1089: lv_notes FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE;
1090:
1091: lv_x_field_type FND_REGISTRATION_DETAILS.FIELD_TYPE%TYPE;
1092: lv_x_field_format FND_REGISTRATION_DETAILS.FIELD_FORMAT%TYPE;
1093: ln_x_field_value_number FND_REGISTRATION_DETAILS.FIELD_VALUE_NUMBER%TYPE;

Line 1091: lv_x_field_type FND_REGISTRATION_DETAILS.FIELD_TYPE%TYPE;

1087: lv_reg_page_url VARCHAR2(32000);
1088:
1089: lv_notes FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE;
1090:
1091: lv_x_field_type FND_REGISTRATION_DETAILS.FIELD_TYPE%TYPE;
1092: lv_x_field_format FND_REGISTRATION_DETAILS.FIELD_FORMAT%TYPE;
1093: ln_x_field_value_number FND_REGISTRATION_DETAILS.FIELD_VALUE_NUMBER%TYPE;
1094: lv_x_field_value_date FND_REGISTRATION_DETAILS.FIELD_VALUE_DATE%TYPE;
1095: lv_proc_name VARCHAR2(30) := 'SetInvItemAttrValues';

Line 1092: lv_x_field_format FND_REGISTRATION_DETAILS.FIELD_FORMAT%TYPE;

1088:
1089: lv_notes FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE;
1090:
1091: lv_x_field_type FND_REGISTRATION_DETAILS.FIELD_TYPE%TYPE;
1092: lv_x_field_format FND_REGISTRATION_DETAILS.FIELD_FORMAT%TYPE;
1093: ln_x_field_value_number FND_REGISTRATION_DETAILS.FIELD_VALUE_NUMBER%TYPE;
1094: lv_x_field_value_date FND_REGISTRATION_DETAILS.FIELD_VALUE_DATE%TYPE;
1095: lv_proc_name VARCHAR2(30) := 'SetInvItemAttrValues';
1096:

Line 1093: ln_x_field_value_number FND_REGISTRATION_DETAILS.FIELD_VALUE_NUMBER%TYPE;

1089: lv_notes FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE;
1090:
1091: lv_x_field_type FND_REGISTRATION_DETAILS.FIELD_TYPE%TYPE;
1092: lv_x_field_format FND_REGISTRATION_DETAILS.FIELD_FORMAT%TYPE;
1093: ln_x_field_value_number FND_REGISTRATION_DETAILS.FIELD_VALUE_NUMBER%TYPE;
1094: lv_x_field_value_date FND_REGISTRATION_DETAILS.FIELD_VALUE_DATE%TYPE;
1095: lv_proc_name VARCHAR2(30) := 'SetInvItemAttrValues';
1096:
1097: BEGIN

Line 1094: lv_x_field_value_date FND_REGISTRATION_DETAILS.FIELD_VALUE_DATE%TYPE;

1090:
1091: lv_x_field_type FND_REGISTRATION_DETAILS.FIELD_TYPE%TYPE;
1092: lv_x_field_format FND_REGISTRATION_DETAILS.FIELD_FORMAT%TYPE;
1093: ln_x_field_value_number FND_REGISTRATION_DETAILS.FIELD_VALUE_NUMBER%TYPE;
1094: lv_x_field_value_date FND_REGISTRATION_DETAILS.FIELD_VALUE_DATE%TYPE;
1095: lv_proc_name VARCHAR2(30) := 'SetInvItemAttrValues';
1096:
1097: BEGIN
1098:

Line 1241: lv_vendor_name FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE := NULL;

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)
1245: lv_approver_role WF_USER_ROLES.ROLE_NAME%TYPE := NULL; --varchar2(320)

Line 1242: lv_osn_tp_name FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE := NULL;

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)
1245: lv_approver_role WF_USER_ROLES.ROLE_NAME%TYPE := NULL; --varchar2(320)
1246: lv_approval_page_url VARCHAR2(32000) := NULL;

Line 1247: lv_notes 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)
1245: lv_approver_role WF_USER_ROLES.ROLE_NAME%TYPE := NULL; --varchar2(320)
1246: lv_approval_page_url VARCHAR2(32000) := NULL;
1247: lv_notes FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE := NULL;
1248: lv_enterprise_name HZ_PARTIES.PARTY_NAME%TYPE;
1249: lv_logon_page_url VARCHAR2(32000) := NULL;
1250:
1251: lv_x_field_type FND_REGISTRATION_DETAILS.FIELD_TYPE%TYPE;

Line 1251: lv_x_field_type FND_REGISTRATION_DETAILS.FIELD_TYPE%TYPE;

1247: lv_notes FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE := NULL;
1248: lv_enterprise_name HZ_PARTIES.PARTY_NAME%TYPE;
1249: lv_logon_page_url VARCHAR2(32000) := NULL;
1250:
1251: lv_x_field_type FND_REGISTRATION_DETAILS.FIELD_TYPE%TYPE;
1252: lv_x_field_format FND_REGISTRATION_DETAILS.FIELD_FORMAT%TYPE;
1253: lv_x_field_value_string FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE;
1254: ln_x_field_value_number FND_REGISTRATION_DETAILS.FIELD_VALUE_NUMBER%TYPE;
1255: lv_x_field_value_date FND_REGISTRATION_DETAILS.FIELD_VALUE_DATE%TYPE;

Line 1252: lv_x_field_format FND_REGISTRATION_DETAILS.FIELD_FORMAT%TYPE;

1248: lv_enterprise_name HZ_PARTIES.PARTY_NAME%TYPE;
1249: lv_logon_page_url VARCHAR2(32000) := NULL;
1250:
1251: lv_x_field_type FND_REGISTRATION_DETAILS.FIELD_TYPE%TYPE;
1252: lv_x_field_format FND_REGISTRATION_DETAILS.FIELD_FORMAT%TYPE;
1253: lv_x_field_value_string FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE;
1254: ln_x_field_value_number FND_REGISTRATION_DETAILS.FIELD_VALUE_NUMBER%TYPE;
1255: lv_x_field_value_date FND_REGISTRATION_DETAILS.FIELD_VALUE_DATE%TYPE;
1256: lv_proc_name VARCHAR2(30) := 'SetRegItemAttrValues';

Line 1253: lv_x_field_value_string FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE;

1249: lv_logon_page_url VARCHAR2(32000) := NULL;
1250:
1251: lv_x_field_type FND_REGISTRATION_DETAILS.FIELD_TYPE%TYPE;
1252: lv_x_field_format FND_REGISTRATION_DETAILS.FIELD_FORMAT%TYPE;
1253: lv_x_field_value_string FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE;
1254: ln_x_field_value_number FND_REGISTRATION_DETAILS.FIELD_VALUE_NUMBER%TYPE;
1255: lv_x_field_value_date FND_REGISTRATION_DETAILS.FIELD_VALUE_DATE%TYPE;
1256: lv_proc_name VARCHAR2(30) := 'SetRegItemAttrValues';
1257:

Line 1254: ln_x_field_value_number FND_REGISTRATION_DETAILS.FIELD_VALUE_NUMBER%TYPE;

1250:
1251: lv_x_field_type FND_REGISTRATION_DETAILS.FIELD_TYPE%TYPE;
1252: lv_x_field_format FND_REGISTRATION_DETAILS.FIELD_FORMAT%TYPE;
1253: lv_x_field_value_string FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE;
1254: ln_x_field_value_number FND_REGISTRATION_DETAILS.FIELD_VALUE_NUMBER%TYPE;
1255: lv_x_field_value_date FND_REGISTRATION_DETAILS.FIELD_VALUE_DATE%TYPE;
1256: lv_proc_name VARCHAR2(30) := 'SetRegItemAttrValues';
1257:
1258: BEGIN

Line 1255: lv_x_field_value_date FND_REGISTRATION_DETAILS.FIELD_VALUE_DATE%TYPE;

1251: lv_x_field_type FND_REGISTRATION_DETAILS.FIELD_TYPE%TYPE;
1252: lv_x_field_format FND_REGISTRATION_DETAILS.FIELD_FORMAT%TYPE;
1253: lv_x_field_value_string FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE;
1254: ln_x_field_value_number FND_REGISTRATION_DETAILS.FIELD_VALUE_NUMBER%TYPE;
1255: lv_x_field_value_date FND_REGISTRATION_DETAILS.FIELD_VALUE_DATE%TYPE;
1256: lv_proc_name VARCHAR2(30) := 'SetRegItemAttrValues';
1257:
1258: BEGIN
1259:

Line 1516: lv_is_invited_flag FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE;

1512: ln_approver_id NUMBER;
1513: lv_contact_email FND_USER.EMAIL_ADDRESS%TYPE;
1514: lv_logon_page_url VARCHAR2(32000) := NULL;
1515: lv_enterprise_name HZ_PARTIES.PARTY_NAME%TYPE;
1516: lv_is_invited_flag FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE;
1517: ln_vendor_id NUMBER;
1518: lv_pos_flag FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE;
1519: lv_pon_flag FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE;
1520: lv_sc_flag FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE;

Line 1518: lv_pos_flag FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE;

1514: lv_logon_page_url VARCHAR2(32000) := NULL;
1515: lv_enterprise_name HZ_PARTIES.PARTY_NAME%TYPE;
1516: lv_is_invited_flag FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE;
1517: ln_vendor_id NUMBER;
1518: lv_pos_flag FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE;
1519: lv_pon_flag FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE;
1520: lv_sc_flag FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE;
1521: lv_notes FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE;
1522: lv_job_title FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE;

Line 1519: lv_pon_flag FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE;

1515: lv_enterprise_name HZ_PARTIES.PARTY_NAME%TYPE;
1516: lv_is_invited_flag FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE;
1517: ln_vendor_id NUMBER;
1518: lv_pos_flag FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE;
1519: lv_pon_flag FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE;
1520: lv_sc_flag FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE;
1521: lv_notes FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE;
1522: lv_job_title FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE;
1523:

Line 1520: lv_sc_flag FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE;

1516: lv_is_invited_flag FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE;
1517: ln_vendor_id NUMBER;
1518: lv_pos_flag FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE;
1519: lv_pon_flag FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE;
1520: lv_sc_flag FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE;
1521: lv_notes FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE;
1522: lv_job_title FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE;
1523:
1524: lv_x_field_type FND_REGISTRATION_DETAILS.FIELD_TYPE%TYPE;

Line 1521: lv_notes FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE;

1517: ln_vendor_id NUMBER;
1518: lv_pos_flag FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE;
1519: lv_pon_flag FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE;
1520: lv_sc_flag FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE;
1521: lv_notes FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE;
1522: lv_job_title FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE;
1523:
1524: lv_x_field_type FND_REGISTRATION_DETAILS.FIELD_TYPE%TYPE;
1525: lv_x_field_format FND_REGISTRATION_DETAILS.FIELD_FORMAT%TYPE;

Line 1522: lv_job_title FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE;

1518: lv_pos_flag FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE;
1519: lv_pon_flag FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE;
1520: lv_sc_flag FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE;
1521: lv_notes FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE;
1522: lv_job_title FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE;
1523:
1524: lv_x_field_type FND_REGISTRATION_DETAILS.FIELD_TYPE%TYPE;
1525: lv_x_field_format FND_REGISTRATION_DETAILS.FIELD_FORMAT%TYPE;
1526: lv_x_field_value_string FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE;

Line 1524: lv_x_field_type FND_REGISTRATION_DETAILS.FIELD_TYPE%TYPE;

1520: lv_sc_flag FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE;
1521: lv_notes FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE;
1522: lv_job_title FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE;
1523:
1524: lv_x_field_type FND_REGISTRATION_DETAILS.FIELD_TYPE%TYPE;
1525: lv_x_field_format FND_REGISTRATION_DETAILS.FIELD_FORMAT%TYPE;
1526: lv_x_field_value_string FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE;
1527: ln_x_field_value_number FND_REGISTRATION_DETAILS.FIELD_VALUE_NUMBER%TYPE;
1528: lv_x_field_value_date FND_REGISTRATION_DETAILS.FIELD_VALUE_DATE%TYPE;

Line 1525: lv_x_field_format FND_REGISTRATION_DETAILS.FIELD_FORMAT%TYPE;

1521: lv_notes FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE;
1522: lv_job_title FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE;
1523:
1524: lv_x_field_type FND_REGISTRATION_DETAILS.FIELD_TYPE%TYPE;
1525: lv_x_field_format FND_REGISTRATION_DETAILS.FIELD_FORMAT%TYPE;
1526: lv_x_field_value_string FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE;
1527: ln_x_field_value_number FND_REGISTRATION_DETAILS.FIELD_VALUE_NUMBER%TYPE;
1528: lv_x_field_value_date FND_REGISTRATION_DETAILS.FIELD_VALUE_DATE%TYPE;
1529: lv_proc_name VARCHAR2(30) := 'SetApprvItemAttrValues';

Line 1526: lv_x_field_value_string FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE;

1522: lv_job_title FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE;
1523:
1524: lv_x_field_type FND_REGISTRATION_DETAILS.FIELD_TYPE%TYPE;
1525: lv_x_field_format FND_REGISTRATION_DETAILS.FIELD_FORMAT%TYPE;
1526: lv_x_field_value_string FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE;
1527: ln_x_field_value_number FND_REGISTRATION_DETAILS.FIELD_VALUE_NUMBER%TYPE;
1528: lv_x_field_value_date FND_REGISTRATION_DETAILS.FIELD_VALUE_DATE%TYPE;
1529: lv_proc_name VARCHAR2(30) := 'SetApprvItemAttrValues';
1530:

Line 1527: ln_x_field_value_number FND_REGISTRATION_DETAILS.FIELD_VALUE_NUMBER%TYPE;

1523:
1524: lv_x_field_type FND_REGISTRATION_DETAILS.FIELD_TYPE%TYPE;
1525: lv_x_field_format FND_REGISTRATION_DETAILS.FIELD_FORMAT%TYPE;
1526: lv_x_field_value_string FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE;
1527: ln_x_field_value_number FND_REGISTRATION_DETAILS.FIELD_VALUE_NUMBER%TYPE;
1528: lv_x_field_value_date FND_REGISTRATION_DETAILS.FIELD_VALUE_DATE%TYPE;
1529: lv_proc_name VARCHAR2(30) := 'SetApprvItemAttrValues';
1530:
1531: BEGIN

Line 1528: lv_x_field_value_date FND_REGISTRATION_DETAILS.FIELD_VALUE_DATE%TYPE;

1524: lv_x_field_type FND_REGISTRATION_DETAILS.FIELD_TYPE%TYPE;
1525: lv_x_field_format FND_REGISTRATION_DETAILS.FIELD_FORMAT%TYPE;
1526: lv_x_field_value_string FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE;
1527: ln_x_field_value_number FND_REGISTRATION_DETAILS.FIELD_VALUE_NUMBER%TYPE;
1528: lv_x_field_value_date FND_REGISTRATION_DETAILS.FIELD_VALUE_DATE%TYPE;
1529: lv_proc_name VARCHAR2(30) := 'SetApprvItemAttrValues';
1530:
1531: BEGIN
1532:

Line 1823: lv_is_invited_flag FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE;

1819: lv_enterprise_name HZ_PARTIES.PARTY_NAME%TYPE;
1820:
1821: ln_approver_id NUMBER;
1822: lv_contact_email FND_USER.EMAIL_ADDRESS%TYPE;
1823: lv_is_invited_flag FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE;
1824:
1825: lv_x_field_type FND_REGISTRATION_DETAILS.FIELD_TYPE%TYPE;
1826: lv_x_field_format FND_REGISTRATION_DETAILS.FIELD_FORMAT%TYPE;
1827: lv_x_field_value_string FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE;

Line 1825: lv_x_field_type FND_REGISTRATION_DETAILS.FIELD_TYPE%TYPE;

1821: ln_approver_id NUMBER;
1822: lv_contact_email FND_USER.EMAIL_ADDRESS%TYPE;
1823: lv_is_invited_flag FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE;
1824:
1825: lv_x_field_type FND_REGISTRATION_DETAILS.FIELD_TYPE%TYPE;
1826: lv_x_field_format FND_REGISTRATION_DETAILS.FIELD_FORMAT%TYPE;
1827: lv_x_field_value_string FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE;
1828: ln_x_field_value_number FND_REGISTRATION_DETAILS.FIELD_VALUE_NUMBER%TYPE;
1829: lv_x_field_value_date FND_REGISTRATION_DETAILS.FIELD_VALUE_DATE%TYPE;

Line 1826: lv_x_field_format FND_REGISTRATION_DETAILS.FIELD_FORMAT%TYPE;

1822: lv_contact_email FND_USER.EMAIL_ADDRESS%TYPE;
1823: lv_is_invited_flag FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE;
1824:
1825: lv_x_field_type FND_REGISTRATION_DETAILS.FIELD_TYPE%TYPE;
1826: lv_x_field_format FND_REGISTRATION_DETAILS.FIELD_FORMAT%TYPE;
1827: lv_x_field_value_string FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE;
1828: ln_x_field_value_number FND_REGISTRATION_DETAILS.FIELD_VALUE_NUMBER%TYPE;
1829: lv_x_field_value_date FND_REGISTRATION_DETAILS.FIELD_VALUE_DATE%TYPE;
1830: lv_proc_name VARCHAR2(30) := 'SetRjctItemAttrValues';

Line 1827: lv_x_field_value_string FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE;

1823: lv_is_invited_flag FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE;
1824:
1825: lv_x_field_type FND_REGISTRATION_DETAILS.FIELD_TYPE%TYPE;
1826: lv_x_field_format FND_REGISTRATION_DETAILS.FIELD_FORMAT%TYPE;
1827: lv_x_field_value_string FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE;
1828: ln_x_field_value_number FND_REGISTRATION_DETAILS.FIELD_VALUE_NUMBER%TYPE;
1829: lv_x_field_value_date FND_REGISTRATION_DETAILS.FIELD_VALUE_DATE%TYPE;
1830: lv_proc_name VARCHAR2(30) := 'SetRjctItemAttrValues';
1831: BEGIN

Line 1828: ln_x_field_value_number FND_REGISTRATION_DETAILS.FIELD_VALUE_NUMBER%TYPE;

1824:
1825: lv_x_field_type FND_REGISTRATION_DETAILS.FIELD_TYPE%TYPE;
1826: lv_x_field_format FND_REGISTRATION_DETAILS.FIELD_FORMAT%TYPE;
1827: lv_x_field_value_string FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE;
1828: ln_x_field_value_number FND_REGISTRATION_DETAILS.FIELD_VALUE_NUMBER%TYPE;
1829: lv_x_field_value_date FND_REGISTRATION_DETAILS.FIELD_VALUE_DATE%TYPE;
1830: lv_proc_name VARCHAR2(30) := 'SetRjctItemAttrValues';
1831: BEGIN
1832:

Line 1829: lv_x_field_value_date FND_REGISTRATION_DETAILS.FIELD_VALUE_DATE%TYPE;

1825: lv_x_field_type FND_REGISTRATION_DETAILS.FIELD_TYPE%TYPE;
1826: lv_x_field_format FND_REGISTRATION_DETAILS.FIELD_FORMAT%TYPE;
1827: lv_x_field_value_string FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE;
1828: ln_x_field_value_number FND_REGISTRATION_DETAILS.FIELD_VALUE_NUMBER%TYPE;
1829: lv_x_field_value_date FND_REGISTRATION_DETAILS.FIELD_VALUE_DATE%TYPE;
1830: lv_proc_name VARCHAR2(30) := 'SetRjctItemAttrValues';
1831: BEGIN
1832:
1833:

Line 2717: FROM fnd_registration_details

2713: WHERE application_short_name = p_app_short_name;
2714:
2715: CURSOR l_site_cont_id_cur (p_reg_id NUMBER, p_field_name VARCHAR2) IS
2716: SELECT field_value_number
2717: FROM fnd_registration_details
2718: WHERE registration_id = p_reg_id
2719: AND field_name like p_field_name||'%';
2720:
2721: CURSOR l_user_resp_app_cur (p_reg_id NUMBER, p_field_name VARCHAR2) IS

Line 2723: FROM fnd_registration_details

2719: AND field_name like p_field_name||'%';
2720:
2721: CURSOR l_user_resp_app_cur (p_reg_id NUMBER, p_field_name VARCHAR2) IS
2722: SELECT field_value_string
2723: FROM fnd_registration_details
2724: WHERE registration_id = p_reg_id
2725: AND field_name like p_field_name||'%';
2726:
2727: CURSOR l_fnd_user_cur(l_user_id IN NUMBER) IS

Line 2794: FROM fnd_registration_details

2790: l_encrypted_initial_password := NULL;
2791:
2792: SELECT field_value_string
2793: INTO l_encrypted_initial_password
2794: FROM fnd_registration_details
2795: WHERE registration_id = ln_reg_id
2796: AND field_name = 'Initial Pass';
2797:
2798: lv_unencrypted_password := decrypt (

Line 3456: fnd_registration_details d1, fnd_registration_details d2

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
3460: and d1.field_name = 'OSN Request 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: