APPS.PON_FORMS_UTIL_PVT dependencies on PON_PARTY_PREFERENCES

Line 754: select preference_value into rt_value from PON_PARTY_PREFERENCES where app_short_name = 'PON' and preference_name = 'FBO_USER_ID';

750: elsif p_field_code = 'FED_FILE_LINK' then
751: rt_value := get_fed_file_link(to_number(p_id));
752:
753: elsif p_field_code = 'FED_CBAC' then
754: select preference_value into rt_value from PON_PARTY_PREFERENCES where app_short_name = 'PON' and preference_name = 'FBO_USER_ID';
755:
756: --Temporately use 'FedBizOpps' as key to match with encryption in NegotiationConfCO.java
757: elsif p_field_code = 'FED_PASSWORD' then
758: SELECT PON_FORMS_UTIL_PVT.decrypt('FedBizOpps', (select preference_value from PON_PARTY_PREFERENCES where app_short_name = 'PON' and preference_name = 'FBO_PASSWORD')) into rt_value

Line 758: SELECT PON_FORMS_UTIL_PVT.decrypt('FedBizOpps', (select preference_value from PON_PARTY_PREFERENCES where app_short_name = 'PON' and preference_name = 'FBO_PASSWORD')) into rt_value

754: select preference_value into rt_value from PON_PARTY_PREFERENCES where app_short_name = 'PON' and preference_name = 'FBO_USER_ID';
755:
756: --Temporately use 'FedBizOpps' as key to match with encryption in NegotiationConfCO.java
757: elsif p_field_code = 'FED_PASSWORD' then
758: SELECT PON_FORMS_UTIL_PVT.decrypt('FedBizOpps', (select preference_value from PON_PARTY_PREFERENCES where app_short_name = 'PON' and preference_name = 'FBO_PASSWORD')) into rt_value
759: FROM DUAL;
760:
761: end if;
762:

Line 3715: from PON_PARTY_PREFERENCES

3711: l_result VARCHAR(240);
3712: BEGIN
3713: /*select preference_value
3714: into l_result
3715: from PON_PARTY_PREFERENCES
3716: where app_short_name = 'PON'
3717: and preference_name = 'FBO_URL';*/
3718:
3719: -- CLM Phase2: we will take the url value from PON_FBO_URL profile.