APPS.RRS_SITES_PKG dependencies on RRS_SITES_B

Line 38: ,RRS_SITES_B RRS

34: ,PN.BATCH_NAME
35: ,PN.SITE_ID
36: FROM
37: HZ_LOCATIONS HZ
38: ,RRS_SITES_B RRS
39: ,PN_LOCATIONS_ITF PN
40: WHERE HZ.LOCATION_ID = RRS.LOCATION_ID
41: AND PN.SITE_ID = RRS.SITE_ID
42: AND PN.BATCH_NAME = p_batch_name

Line 125: UPDATE RRS_SITES_B RRS

121: errbuf := 'E' ;
122: rollback to call_import ;
123: ELSE
124: FOR rec IN UPDATE_LOCATION_ID LOOP
125: UPDATE RRS_SITES_B RRS
126: SET RRS.PROPERTY_LOCATION_ID = rec.LOCATION_ID
127: WHERE RRS.SITE_ID = rec.SITE_ID ;
128: END LOOP ;
129: DELETE FROM PN_LOCATIONS_ITF WHERE BATCH_NAME = p_batch_name ;

Line 248: DELETE FROM RRS_SITES_B WHERE SITE_ID = p_site_id;

244: DELETE FROM RRS_SITES_EXT_TL WHERE SITE_ID = p_site_id;
245: DELETE FROM RRS_SITES_EXT_B WHERE SITE_ID = p_site_id;
246: DELETE FROM RRS_SITE_USES WHERE SITE_ID = p_site_id;
247: DELETE FROM RRS_SITES_TL WHERE SITE_ID = p_site_id;
248: DELETE FROM RRS_SITES_B WHERE SITE_ID = p_site_id;
249: COMMIT;
250: END DELETE_TEMPLATE;
251:
252: --Bug 4742710