197:
198: FUNCTION CREATE_CONTACT_POINT_POST ( p_subscription_guid IN RAW, p_event IN OUT NOCOPY wf_event_t ) RETURN VARCHAR2 IS
199: CURSOR c1 IS
200: SELECT owner_table_name,owner_table_id
201: FROM hz_contact_points
202: WHERE contact_point_id = p_event.GetValueForParameter('CONTACT_POINT_ID')
203: AND primary_flag = 'Y'
204: AND contact_point_type ='PHONE'
205: AND status <>'I';
247:
248: FUNCTION UPDATE_CONTACT_POINT_POST ( p_subscription_guid IN RAW, p_event IN OUT NOCOPY wf_event_t ) RETURN VARCHAR2 IS
249: CURSOR C1 IS
250: SELECT owner_table_name,owner_table_id
251: FROM hz_contact_points
252: WHERE contact_point_id = p_event.GetValueForParameter('CONTACT_POINT_ID')
253: AND primary_flag = 'Y'
254: AND contact_point_type ='PHONE'
255: AND status <>'I';