59: END IF;
60:
61: END PROCESS_RTTAP_ACCOUNT;
62:
63: FUNCTION CREATE_ORGANIZATION_POST ( p_subscription_guid IN RAW, p_event IN OUT NOCOPY wf_event_t ) RETURN VARCHAR2 IS
64: p_return_status VARCHAR2(1);
65: BEGIN
66: PROCESS_RTTAP_ACCOUNT(p_event.GetValueForParameter('PARTY_ID'),p_return_status);
67: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
78: WF_EVENT.setErrorInfo(p_event, 'ERROR');
79: RETURN 'ERROR';
80: END CREATE_ORGANIZATION_POST;
81:
82: FUNCTION UPDATE_ORGANIZATION_POST ( p_subscription_guid IN RAW, p_event IN OUT NOCOPY wf_event_t ) RETURN VARCHAR2 IS
83: p_return_status VARCHAR2(1);
84: BEGIN
85: PROCESS_RTTAP_ACCOUNT(p_event.GetValueForParameter('PARTY_ID'),p_return_status);
86: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
97: WF_EVENT.setErrorInfo(p_event, 'ERROR');
98: RETURN 'ERROR';
99: END;
100:
101: FUNCTION CREATE_PERSON_POST ( p_subscription_guid IN RAW, p_event IN OUT NOCOPY wf_event_t ) RETURN VARCHAR2 IS
102: p_return_status VARCHAR2(1);
103: BEGIN
104: PROCESS_RTTAP_ACCOUNT(p_event.GetValueForParameter('PARTY_ID'),p_return_status);
105: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
117: RETURN 'ERROR';
118: END;
119:
120:
121: FUNCTION UPDATE_PERSON_POST ( p_subscription_guid IN RAW, p_event IN OUT NOCOPY wf_event_t ) RETURN VARCHAR2 IS
122: p_return_status VARCHAR2(1);
123: BEGIN
124: PROCESS_RTTAP_ACCOUNT(p_event.GetValueForParameter('PARTY_ID'),p_return_status);
125: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
137: RETURN 'ERROR';
138:
139: END;
140:
141: FUNCTION CREATE_PARTY_SITE_POST ( p_subscription_guid IN RAW, p_event IN OUT NOCOPY wf_event_t ) RETURN VARCHAR2 IS
142: CURSOR c1 IS
143: SELECT party_id
144: FROM HZ_PARTY_SITES
145: WHERE party_site_id = p_event.GetValueForParameter('PARTY_SITE_ID');
165: RETURN 'ERROR';
166:
167: END;
168:
169: FUNCTION UPDATE_PARTY_SITE_POST ( p_subscription_guid IN RAW, p_event IN OUT NOCOPY wf_event_t ) RETURN VARCHAR2 IS
170: CURSOR c1 IS
171: SELECT party_id
172: FROM HZ_PARTY_SITES
173: WHERE party_site_id = p_event.GetValueForParameter('PARTY_SITE_ID');
194:
195: END;
196:
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')
244: RETURN 'ERROR';
245:
246: END CREATE_CONTACT_POINT_POST;
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')
294: RETURN 'ERROR';
295:
296: END UPDATE_CONTACT_POINT_POST;
297:
298: FUNCTION UPDATE_LOCATION_POST ( p_subscription_guid IN RAW, p_event IN OUT NOCOPY wf_event_t ) RETURN VARCHAR2 IS
299:
300: CURSOR C2 IS
301: SELECT DISTINCT party_id
302: FROM AS_PARTY_ADDRESSES_V