APPS.BNE_LAYOUTS_PKG dependencies on BNE_LAYOUTS_B

Line 27: cursor C is select ROWID from BNE_LAYOUTS_B

23: X_LAST_UPDATE_LOGIN in NUMBER,
24: X_CREATE_DOC_LIST_APP_ID in NUMBER,
25: X_CREATE_DOC_LIST_CODE in VARCHAR2
26: ) is
27: cursor C is select ROWID from BNE_LAYOUTS_B
28: where APPLICATION_ID = X_APPLICATION_ID
29: and LAYOUT_CODE = X_LAYOUT_CODE
30: ;
31: begin

Line 32: insert into BNE_LAYOUTS_B (

28: where APPLICATION_ID = X_APPLICATION_ID
29: and LAYOUT_CODE = X_LAYOUT_CODE
30: ;
31: begin
32: insert into BNE_LAYOUTS_B (
33: APPLICATION_ID,
34: LAYOUT_CODE,
35: OBJECT_VERSION_NUMBER,
36: STYLESHEET_APP_ID,

Line 145: from BNE_LAYOUTS_B

141: REPORTING_INTERFACE_APP_ID,
142: REPORTING_INTERFACE_CODE,
143: CREATE_DOC_LIST_APP_ID,
144: CREATE_DOC_LIST_CODE
145: from BNE_LAYOUTS_B
146: where APPLICATION_ID = X_APPLICATION_ID
147: and LAYOUT_CODE = X_LAYOUT_CODE
148: for update of APPLICATION_ID nowait;
149: recinfo c%rowtype;

Line 229: update BNE_LAYOUTS_B set

225: X_CREATE_DOC_LIST_APP_ID in NUMBER,
226: X_CREATE_DOC_LIST_CODE in VARCHAR2
227: ) is
228: begin
229: update BNE_LAYOUTS_B set
230: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
231: STYLESHEET_APP_ID = X_STYLESHEET_APP_ID,
232: STYLESHEET_CODE = X_STYLESHEET_CODE,
233: INTEGRATOR_APP_ID = X_INTEGRATOR_APP_ID,

Line 280: delete from BNE_LAYOUTS_B

276: if (sql%notfound) then
277: raise no_data_found;
278: end if;
279:
280: delete from BNE_LAYOUTS_B
281: where APPLICATION_ID = X_APPLICATION_ID
282: and LAYOUT_CODE = X_LAYOUT_CODE;
283:
284: if (sql%notfound) then

Line 295: from BNE_LAYOUTS_B B

291: begin
292: delete from BNE_LAYOUTS_TL T
293: where not exists
294: (select NULL
295: from BNE_LAYOUTS_B B
296: where B.APPLICATION_ID = T.APPLICATION_ID
297: and B.LAYOUT_CODE = T.LAYOUT_CODE
298: );
299:

Line 484: from BNE_LAYOUTS_B

480: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
481: begin
482: select LAST_UPDATED_BY, LAST_UPDATE_DATE
483: into db_luby, db_ludate
484: from BNE_LAYOUTS_B
485: where APPLICATION_ID = l_app_id
486: and LAYOUT_CODE = x_layout_code;
487:
488: -- Test for customization and version