APPS.BNE_VIEWERS_PKG dependencies on BNE_VIEWERS_B

Line 30: cursor C is select ROWID from BNE_VIEWERS_B

26: X_CREATE_DOC_LIST_APP_ID in NUMBER,
27: X_CREATE_DOC_LIST_CODE in VARCHAR2,
28: X_ENABLED_FLAG in VARCHAR2
29: ) is
30: cursor C is select ROWID from BNE_VIEWERS_B
31: where APPLICATION_ID = X_APPLICATION_ID
32: and VIEWER_CODE = X_VIEWER_CODE
33: ;
34: begin

Line 35: insert into BNE_VIEWERS_B (

31: where APPLICATION_ID = X_APPLICATION_ID
32: and VIEWER_CODE = X_VIEWER_CODE
33: ;
34: begin
35: insert into BNE_VIEWERS_B (
36: PARAM_LIST_APP_ID,
37: PARAM_LIST_CODE,
38: APPLICATION_ID,
39: VIEWER_CODE,

Line 128: from BNE_VIEWERS_B

124: VIEWER_JAVA_CLASS,
125: CREATE_DOC_LIST_APP_ID,
126: CREATE_DOC_LIST_CODE,
127: ENABLED_FLAG
128: from BNE_VIEWERS_B
129: where APPLICATION_ID = X_APPLICATION_ID
130: and VIEWER_CODE = X_VIEWER_CODE
131: for update of APPLICATION_ID nowait;
132: recinfo c%rowtype;

Line 200: update BNE_VIEWERS_B set

196: X_CREATE_DOC_LIST_CODE in VARCHAR2,
197: X_ENABLED_FLAG in VARCHAR2
198: ) is
199: begin
200: update BNE_VIEWERS_B set
201: PARAM_LIST_APP_ID = X_PARAM_LIST_APP_ID,
202: PARAM_LIST_CODE = X_PARAM_LIST_CODE,
203: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
204: VIEWER_JAVA_CLASS = X_VIEWER_JAVA_CLASS,

Line 246: delete from BNE_VIEWERS_B

242: if (sql%notfound) then
243: raise no_data_found;
244: end if;
245:
246: delete from BNE_VIEWERS_B
247: where APPLICATION_ID = X_APPLICATION_ID
248: and VIEWER_CODE = X_VIEWER_CODE;
249:
250: if (sql%notfound) then

Line 261: from BNE_VIEWERS_B B

257: begin
258: delete from BNE_VIEWERS_TL T
259: where not exists
260: (select NULL
261: from BNE_VIEWERS_B B
262: where B.APPLICATION_ID = T.APPLICATION_ID
263: and B.VIEWER_CODE = T.VIEWER_CODE
264: );
265:

Line 375: from BNE_VIEWERS_B

371: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
372: begin
373: select LAST_UPDATED_BY, LAST_UPDATE_DATE
374: into db_luby, db_ludate
375: from BNE_VIEWERS_B
376: where APPLICATION_ID = l_app_id
377: and VIEWER_CODE = x_viewer_code;
378:
379: -- Test for customization and version