APPS.BNE_LAYOUT_BLOCKS_PKG dependencies on BNE_LAYOUT_BLOCKS_B

Line 46: cursor C is select ROWID from BNE_LAYOUT_BLOCKS_B

42: X_PROMPT_ABOVE in VARCHAR2,
43: X_TITLE_STYLE_CLASS in VARCHAR2,
44: X_TITLE_STYLE in VARCHAR2
45: ) is
46: cursor C is select ROWID from BNE_LAYOUT_BLOCKS_B
47: where APPLICATION_ID = X_APPLICATION_ID
48: and LAYOUT_CODE = X_LAYOUT_CODE
49: and BLOCK_ID = X_BLOCK_ID
50: ;

Line 52: insert into BNE_LAYOUT_BLOCKS_B (

48: and LAYOUT_CODE = X_LAYOUT_CODE
49: and BLOCK_ID = X_BLOCK_ID
50: ;
51: begin
52: insert into BNE_LAYOUT_BLOCKS_B (
53: APPLICATION_ID,
54: LAYOUT_CODE,
55: BLOCK_ID,
56: OBJECT_VERSION_NUMBER,

Line 242: from BNE_LAYOUT_BLOCKS_B

238: SUMMARY_STYLE_CLASS,
239: SUMMARY_STYLE,
240: TITLE_STYLE_CLASS,
241: TITLE_STYLE
242: from BNE_LAYOUT_BLOCKS_B
243: where APPLICATION_ID = X_APPLICATION_ID
244: and LAYOUT_CODE = X_LAYOUT_CODE
245: and BLOCK_ID = X_BLOCK_ID
246: for update of APPLICATION_ID nowait;

Line 375: update BNE_LAYOUT_BLOCKS_B set

371: X_TITLE_STYLE_CLASS in VARCHAR2,
372: X_TITLE_STYLE in VARCHAR2
373: ) is
374: begin
375: update BNE_LAYOUT_BLOCKS_B set
376: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
377: PARENT_ID = X_PARENT_ID,
378: LAYOUT_ELEMENT = X_LAYOUT_ELEMENT,
379: STYLE_CLASS = X_STYLE_CLASS,

Line 448: delete from BNE_LAYOUT_BLOCKS_B

444: if (sql%notfound) then
445: raise no_data_found;
446: end if;
447:
448: delete from BNE_LAYOUT_BLOCKS_B
449: where APPLICATION_ID = X_APPLICATION_ID
450: and LAYOUT_CODE = X_LAYOUT_CODE
451: and BLOCK_ID = X_BLOCK_ID;
452:

Line 464: from BNE_LAYOUT_BLOCKS_B B

460: begin
461: delete from BNE_LAYOUT_BLOCKS_TL T
462: where not exists
463: (select NULL
464: from BNE_LAYOUT_BLOCKS_B B
465: where B.APPLICATION_ID = T.APPLICATION_ID
466: and B.LAYOUT_CODE = T.LAYOUT_CODE
467: and B.BLOCK_ID = T.BLOCK_ID
468: );

Line 676: from BNE_LAYOUT_BLOCKS_B

672: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
673: begin
674: select LAST_UPDATED_BY, LAST_UPDATE_DATE
675: into db_luby, db_ludate
676: from BNE_LAYOUT_BLOCKS_B
677: where APPLICATION_ID = l_app_id
678: and LAYOUT_CODE = x_layout_code
679: and BLOCK_ID = x_block_id;
680: