APPS.BNE_STYLESHEETS_PKG dependencies on BNE_STYLESHEETS_B

Line 19: cursor C is select ROWID from BNE_STYLESHEETS_B

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

Line 24: insert into BNE_STYLESHEETS_B (

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

Line 104: from BNE_STYLESHEETS_B

100: cursor c is select
101: OBJECT_VERSION_NUMBER,
102: DEFAULT_FLAG,
103: READ_ONLY_FLAG
104: from BNE_STYLESHEETS_B
105: where APPLICATION_ID = X_APPLICATION_ID
106: and STYLESHEET_CODE = X_STYLESHEET_CODE
107: for update of APPLICATION_ID nowait;
108: recinfo c%rowtype;

Line 168: update BNE_STYLESHEETS_B set

164: X_READ_ONLY_FLAG in VARCHAR2,
165: X_DESCRIPTION in VARCHAR2
166: ) is
167: begin
168: update BNE_STYLESHEETS_B set
169: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
170: DEFAULT_FLAG = X_DEFAULT_FLAG,
171: READ_ONLY_FLAG = X_READ_ONLY_FLAG,
172: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 211: delete from BNE_STYLESHEETS_B

207: if (sql%notfound) then
208: raise no_data_found;
209: end if;
210:
211: delete from BNE_STYLESHEETS_B
212: where APPLICATION_ID = X_APPLICATION_ID
213: and STYLESHEET_CODE = X_STYLESHEET_CODE;
214:
215: if (sql%notfound) then

Line 226: from BNE_STYLESHEETS_B B

222: begin
223: delete from BNE_STYLESHEETS_TL T
224: where not exists
225: (select NULL
226: from BNE_STYLESHEETS_B B
227: where B.APPLICATION_ID = T.APPLICATION_ID
228: and B.STYLESHEET_CODE = T.STYLESHEET_CODE
229: );
230:

Line 338: from BNE_STYLESHEETS_B

334: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
335: begin
336: select LAST_UPDATED_BY, LAST_UPDATE_DATE
337: into db_luby, db_ludate
338: from BNE_STYLESHEETS_B
339: where APPLICATION_ID = l_app_id
340: and STYLESHEET_CODE = x_stylesheet_code;
341:
342: -- Test for customization and version