DBA Data[Home] [Help]

APPS.AS_RTTAP_ACCOUNT dependencies on WF_EVENT_T

Line 63: FUNCTION CREATE_ORGANIZATION_POST ( p_subscription_guid IN RAW, p_event IN OUT NOCOPY wf_event_t ) RETURN VARCHAR2 IS

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

Line 82: FUNCTION UPDATE_ORGANIZATION_POST ( p_subscription_guid IN RAW, p_event IN OUT NOCOPY wf_event_t ) RETURN VARCHAR2 IS

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

Line 101: FUNCTION CREATE_PERSON_POST ( p_subscription_guid IN RAW, p_event IN OUT NOCOPY wf_event_t ) RETURN VARCHAR2 IS

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

Line 121: FUNCTION UPDATE_PERSON_POST ( p_subscription_guid IN RAW, p_event IN OUT NOCOPY wf_event_t ) RETURN VARCHAR2 IS

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

Line 141: FUNCTION CREATE_PARTY_SITE_POST ( p_subscription_guid IN RAW, p_event IN OUT NOCOPY wf_event_t ) RETURN VARCHAR2 IS

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');

Line 169: FUNCTION UPDATE_PARTY_SITE_POST ( p_subscription_guid IN RAW, p_event IN OUT NOCOPY wf_event_t ) RETURN VARCHAR2 IS

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');

Line 198: FUNCTION CREATE_CONTACT_POINT_POST ( p_subscription_guid IN RAW, p_event IN OUT NOCOPY wf_event_t ) RETURN VARCHAR2 IS

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')

Line 248: FUNCTION UPDATE_CONTACT_POINT_POST ( p_subscription_guid IN RAW, p_event IN OUT NOCOPY wf_event_t ) RETURN VARCHAR2 IS

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')

Line 298: FUNCTION UPDATE_LOCATION_POST ( p_subscription_guid IN RAW, p_event IN OUT NOCOPY wf_event_t ) RETURN VARCHAR2 IS

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