APPS.BNE_STYLESHEETS_PKG dependencies on BNE_STYLESHEETS_B

Line 20: cursor C is select ROWID from BNE_STYLESHEETS_B

16: X_READ_ONLY_FLAG in VARCHAR2,
17: X_DESCRIPTION in VARCHAR2,
18: X_IMAGE_FILE_NAME IN VARCHAR2
19: ) is
20: cursor C is select ROWID from BNE_STYLESHEETS_B
21: where APPLICATION_ID = X_APPLICATION_ID
22: and STYLESHEET_CODE = X_STYLESHEET_CODE
23: ;
24: begin

Line 25: insert into BNE_STYLESHEETS_B (

21: where APPLICATION_ID = X_APPLICATION_ID
22: and STYLESHEET_CODE = X_STYLESHEET_CODE
23: ;
24: begin
25: insert into BNE_STYLESHEETS_B (
26: OBJECT_VERSION_NUMBER,
27: APPLICATION_ID,
28: STYLESHEET_CODE,
29: DEFAULT_FLAG,

Line 109: from BNE_STYLESHEETS_B

105: OBJECT_VERSION_NUMBER,
106: DEFAULT_FLAG,
107: READ_ONLY_FLAG,
108: IMAGE_FILE_NAME
109: from BNE_STYLESHEETS_B
110: where APPLICATION_ID = X_APPLICATION_ID
111: and STYLESHEET_CODE = X_STYLESHEET_CODE
112: for update of APPLICATION_ID nowait;
113: recinfo c%rowtype;

Line 176: update BNE_STYLESHEETS_B set

172: X_DESCRIPTION in VARCHAR2,
173: X_IMAGE_FILE_NAME IN VARCHAR2
174: ) is
175: begin
176: update BNE_STYLESHEETS_B set
177: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
178: DEFAULT_FLAG = X_DEFAULT_FLAG,
179: READ_ONLY_FLAG = X_READ_ONLY_FLAG,
180: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 220: delete from BNE_STYLESHEETS_B

216: if (sql%notfound) then
217: raise no_data_found;
218: end if;
219:
220: delete from BNE_STYLESHEETS_B
221: where APPLICATION_ID = X_APPLICATION_ID
222: and STYLESHEET_CODE = X_STYLESHEET_CODE;
223:
224: if (sql%notfound) then

Line 235: from BNE_STYLESHEETS_B B

231: begin
232: delete from BNE_STYLESHEETS_TL T
233: where not exists
234: (select NULL
235: from BNE_STYLESHEETS_B B
236: where B.APPLICATION_ID = T.APPLICATION_ID
237: and B.STYLESHEET_CODE = T.STYLESHEET_CODE
238: );
239:

Line 348: from BNE_STYLESHEETS_B

344: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
345: begin
346: select LAST_UPDATED_BY, LAST_UPDATE_DATE
347: into db_luby, db_ludate
348: from BNE_STYLESHEETS_B
349: where APPLICATION_ID = l_app_id
350: and STYLESHEET_CODE = x_stylesheet_code;
351:
352: -- Test for customization and version