APPS.RRS_SITESTH_PKG dependencies on RRS_SITES_B

Line 32: cursor C is select ROWID from RRS_SITES_B

28: X_DESCRIPTION in VARCHAR2
29: ) is
30: l_site_id NUMBER;
31:
32: cursor C is select ROWID from RRS_SITES_B
33: where SITE_ID = l_site_id
34: ;
35:
36: begin

Line 42: insert into RRS_SITES_B (

38: select nvl(X_SITE_ID ,RRS_SITES_S.nextval)
39: into l_site_id
40: from dual;
41:
42: insert into RRS_SITES_B (
43: SITE_ID,
44: SITE_IDENTIFICATION_NUMBER,
45: SITE_TYPE_CODE,
46: SITE_STATUS_CODE,

Line 168: from RRS_SITES_B

164: END_DATE,
165: IS_TEMPLATE_FLAG,
166: OBJECT_VERSION_NUMBER,
167: ORGANIZATION_ID
168: from RRS_SITES_B
169: where SITE_ID = X_SITE_ID
170: for update of SITE_ID nowait;
171: recinfo c%rowtype;
172:

Line 267: update RRS_SITES_B set

263: X_ORGANIZATION_ID in NUMBER,
264: X_DESCRIPTION in VARCHAR2
265: ) is
266: begin
267: update RRS_SITES_B set
268: SITE_IDENTIFICATION_NUMBER = X_SITE_IDENTIFICATION_NUMBER,
269: SITE_TYPE_CODE = X_SITE_TYPE_CODE,
270: SITE_STATUS_CODE = X_SITE_STATUS_CODE,
271: BRANDNAME_CODE = X_BRANDNAME_CODE,

Line 319: delete from RRS_SITES_B

315: if (sql%notfound) then
316: raise no_data_found;
317: end if;
318:
319: delete from RRS_SITES_B
320: where SITE_ID = X_SITE_ID;
321:
322: if (sql%notfound) then
323: raise no_data_found;

Line 333: from RRS_SITES_B B

329: begin
330: delete from RRS_SITES_TL T
331: where not exists
332: (select NULL
333: from RRS_SITES_B B
334: where B.SITE_ID = T.SITE_ID
335: );
336:
337: update RRS_SITES_TL T set (