APPS.BNE_CACHE_DIRECTIVES_PKG dependencies on BNE_CACHE_DIRECTIVES_B

Line 21: cursor C is select ROWID from BNE_CACHE_DIRECTIVES_B

17: X_LAST_UPDATE_DATE in DATE,
18: X_LAST_UPDATED_BY in NUMBER,
19: X_LAST_UPDATE_LOGIN in NUMBER
20: ) is
21: cursor C is select ROWID from BNE_CACHE_DIRECTIVES_B
22: where APPLICATION_ID = X_APPLICATION_ID
23: and DIRECTIVE_CODE = X_DIRECTIVE_CODE
24: ;
25: begin

Line 26: insert into BNE_CACHE_DIRECTIVES_B (

22: where APPLICATION_ID = X_APPLICATION_ID
23: and DIRECTIVE_CODE = X_DIRECTIVE_CODE
24: ;
25: begin
26: insert into BNE_CACHE_DIRECTIVES_B (
27: MAX_AGE,
28: DISCRIMINATOR_TYPE,
29: DISCRIMINATOR_VALUE,
30: APPLICATION_ID,

Line 115: from BNE_CACHE_DIRECTIVES_B

111: DISCRIMINATOR_VALUE,
112: OBJECT_VERSION_NUMBER,
113: MAX_SIZE,
114: MAX_HITS
115: from BNE_CACHE_DIRECTIVES_B
116: where APPLICATION_ID = X_APPLICATION_ID
117: and DIRECTIVE_CODE = X_DIRECTIVE_CODE
118: for update of APPLICATION_ID nowait;
119: recinfo c%rowtype;

Line 183: update BNE_CACHE_DIRECTIVES_B set

179: X_LAST_UPDATED_BY in NUMBER,
180: X_LAST_UPDATE_LOGIN in NUMBER
181: ) is
182: begin
183: update BNE_CACHE_DIRECTIVES_B set
184: MAX_AGE = X_MAX_AGE,
185: DISCRIMINATOR_TYPE = X_DISCRIMINATOR_TYPE,
186: DISCRIMINATOR_VALUE = X_DISCRIMINATOR_VALUE,
187: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,

Line 228: delete from BNE_CACHE_DIRECTIVES_B

224: if (sql%notfound) then
225: raise no_data_found;
226: end if;
227:
228: delete from BNE_CACHE_DIRECTIVES_B
229: where APPLICATION_ID = X_APPLICATION_ID
230: and DIRECTIVE_CODE = X_DIRECTIVE_CODE;
231:
232: if (sql%notfound) then

Line 243: from BNE_CACHE_DIRECTIVES_B B

239: begin
240: delete from BNE_CACHE_DIRECTIVES_TL T
241: where not exists
242: (select NULL
243: from BNE_CACHE_DIRECTIVES_B B
244: where B.APPLICATION_ID = T.APPLICATION_ID
245: and B.DIRECTIVE_CODE = T.DIRECTIVE_CODE
246: );
247:

Line 416: from BNE_CACHE_DIRECTIVES_B

412: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
413: begin
414: select LAST_UPDATED_BY, LAST_UPDATE_DATE
415: into db_luby, db_ludate
416: from BNE_CACHE_DIRECTIVES_B
417: where APPLICATION_ID = l_app_id
418: and DIRECTIVE_CODE = x_directive_code;
419:
420: -- Test for customization and version