APPS.PON_PROFILE_UTIL_PKG dependencies on PON_PARTY_PREFERENCES

Line 116: from PON_PARTY_PREFERENCES

112: BEGIN
113: x_exception_msg :='entering update_or_insert_party_perference';
114: select count(*)
115: into l_count
116: from PON_PARTY_PREFERENCES
117: where party_id = p_party_id
118: AND preference_name = p_pref_name
119: AND APP_SHORT_NAME = p_app_short_name;
120:

Line 124: UPDATE PON_PARTY_PREFERENCES

120:
121: if l_count > 0 then
122: -- do an update because row exists
123: x_exception_msg :='updating party_perference';
124: UPDATE PON_PARTY_PREFERENCES
125: SET PREFERENCE_VALUE = p_pref_value
126: , PREFERENCE_MEANING = p_pref_meaning
127: , ATTRIBUTE1 = p_attribute1
128: , ATTRIBUTE2 = p_attribute2

Line 138: insert into PON_PARTY_PREFERENCES

134: AND app_short_name = p_app_short_name;
135: ELSE
136: x_exception_msg :='inserting party_perference';
137: -- insert a new row because it doesn't exist
138: insert into PON_PARTY_PREFERENCES
139: (
140: party_id
141: , APP_SHORT_NAME
142: , preference_name

Line 190: FROM PON_PARTY_PREFERENCES

186: x_exception_msg :='entering DELETE_PARTY_PREF';
187:
188: SELECT count(*)
189: INTO l_count
190: FROM PON_PARTY_PREFERENCES
191: WHERE party_id = p_party_id
192: AND preference_name = p_pref_name
193: AND APP_SHORT_NAME = p_app_short_name;
194:

Line 197: DELETE FROM PON_PARTY_PREFERENCES

193: AND APP_SHORT_NAME = p_app_short_name;
194:
195: IF l_count > 0 THEN
196:
197: DELETE FROM PON_PARTY_PREFERENCES
198: WHERE party_id = p_party_id
199: AND preference_name = p_pref_name
200: AND APP_SHORT_NAME = p_app_short_name;
201:

Line 269: FROM PON_PARTY_PREFERENCES

265: SELECT preference_value, preference_meaning, attribute1, attribute2,
266: attribute3, attribute4, attribute5
267: INTO x_pref_value,x_pref_meaning,x_attribute1,x_attribute2,x_attribute3,
268: x_attribute4, x_attribute5
269: FROM PON_PARTY_PREFERENCES
270: WHERE app_short_name= p_app_short_name
271: AND preference_name=p_pref_name
272: AND rownum = 1;
273: