APPS.AS_RTTAP_ACCOUNT dependencies on HZ_PARTY_SITES

Line 144: FROM HZ_PARTY_SITES

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');
146: l_party_id NUMBER;
147: p_return_status VARCHAR2(1);
148: BEGIN

Line 172: FROM HZ_PARTY_SITES

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');
174: l_party_id NUMBER;
175: p_return_status VARCHAR2(1);
176: BEGIN

Line 208: FROM hz_party_sites

204: AND contact_point_type ='PHONE'
205: AND status <>'I';
206: CURSOR c2(p_party_site_id NUMBER) IS
207: SELECT party_id
208: FROM hz_party_sites
209: WHERE party_site_id= p_party_site_id;
210:
211: l_owner_table_name VARCHAR2(30);
212: l_owner_table_id NUMBER;

Line 224: IF l_owner_table_name= 'HZ_PARTY_SITES' THEN

220: RETURN 'SUCCESS';
221: END IF;
222: Close c1;
223:
224: IF l_owner_table_name= 'HZ_PARTY_SITES' THEN
225: OPEN C2(l_owner_table_id);
226: FETCH C2 INTO l_party_id;
227: CLOSE C2;
228: PROCESS_RTTAP_ACCOUNT(l_party_id,p_return_status);

Line 258: FROM hz_party_sites

254: AND contact_point_type ='PHONE'
255: AND status <>'I';
256: CURSOR C2(p_party_site_id NUMBER) IS
257: SELECT party_id
258: FROM hz_party_sites
259: WHERE party_site_id= p_party_site_id;
260:
261: l_owner_table_name VARCHAR2(30);
262: l_owner_table_id NUMBER;

Line 274: IF l_owner_table_name= 'HZ_PARTY_SITES' THEN

270: RETURN 'SUCCESS';
271: END IF;
272: CLOSE c1;
273:
274: IF l_owner_table_name= 'HZ_PARTY_SITES' THEN
275: OPEN C2(l_owner_table_id);
276: FETCH C2 INTO l_party_id;
277: CLOSE C2;
278: PROCESS_RTTAP_ACCOUNT(l_party_id,p_return_status);