APPS.BNE_CONTENTS_PKG dependencies on BNE_CONTENTS_B

Line 22: cursor C is select ROWID from BNE_CONTENTS_B

18: X_LAST_UPDATED_BY in NUMBER,
19: X_LAST_UPDATE_LOGIN in NUMBER,
20: X_ONCE_ONLY_DOWNLOAD_FLAG in VARCHAR2 DEFAULT 'N'
21: ) is
22: cursor C is select ROWID from BNE_CONTENTS_B
23: where APPLICATION_ID = X_APPLICATION_ID
24: and CONTENT_CODE = X_CONTENT_CODE
25: ;
26: begin

Line 27: insert into BNE_CONTENTS_B (

23: where APPLICATION_ID = X_APPLICATION_ID
24: and CONTENT_CODE = X_CONTENT_CODE
25: ;
26: begin
27: insert into BNE_CONTENTS_B (
28: APPLICATION_ID,
29: CONTENT_CODE,
30: OBJECT_VERSION_NUMBER,
31: INTEGRATOR_APP_ID,

Line 120: from BNE_CONTENTS_B

116: PARAM_LIST_APP_ID,
117: PARAM_LIST_CODE,
118: CONTENT_CLASS,
119: ONCE_ONLY_DOWNLOAD_FLAG
120: from BNE_CONTENTS_B
121: where APPLICATION_ID = X_APPLICATION_ID
122: and CONTENT_CODE = X_CONTENT_CODE
123: for update of APPLICATION_ID nowait;
124: recinfo c%rowtype;

Line 191: update BNE_CONTENTS_B set

187: X_LAST_UPDATE_LOGIN in NUMBER,
188: X_ONCE_ONLY_DOWNLOAD_FLAG in VARCHAR2 DEFAULT 'N'
189: ) is
190: begin
191: update BNE_CONTENTS_B set
192: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
193: INTEGRATOR_APP_ID = X_INTEGRATOR_APP_ID,
194: INTEGRATOR_CODE = X_INTEGRATOR_CODE,
195: PARAM_LIST_APP_ID = X_PARAM_LIST_APP_ID,

Line 237: delete from BNE_CONTENTS_B

233: if (sql%notfound) then
234: raise no_data_found;
235: end if;
236:
237: delete from BNE_CONTENTS_B
238: where APPLICATION_ID = X_APPLICATION_ID
239: and CONTENT_CODE = X_CONTENT_CODE;
240:
241: if (sql%notfound) then

Line 252: from BNE_CONTENTS_B B

248: begin
249: delete from BNE_CONTENTS_TL T
250: where not exists
251: (select NULL
252: from BNE_CONTENTS_B B
253: where B.APPLICATION_ID = T.APPLICATION_ID
254: and B.CONTENT_CODE = T.CONTENT_CODE
255: );
256:

Line 431: from BNE_CONTENTS_B

427: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
428: begin
429: select LAST_UPDATED_BY, LAST_UPDATE_DATE
430: into db_luby, db_ludate
431: from BNE_CONTENTS_B
432: where APPLICATION_ID = l_app_id
433: and CONTENT_CODE = x_content_code;
434:
435: -- Test for customization and version