DBA Data[Home] [Help]

APPS.CUSTOM_CLASS_PKG dependencies on MWA_CLASS_CUSTOM_FILES

Line 32: select ROWID from MWA_CLASS_CUSTOM_FILES

28: X_ATTRIBUTE14 in VARCHAR2,
29: X_ATTRIBUTE15 in VARCHAR2
30: ) is
31: cursor get_row is
32: select ROWID from MWA_CLASS_CUSTOM_FILES
33: where CLASSFILEID = X_CLASSFILEID;
34: begin
35: insert into MWA_CLASS_CUSTOM_FILES (
36: CLASSFILEID,

Line 35: insert into MWA_CLASS_CUSTOM_FILES (

31: cursor get_row is
32: select ROWID from MWA_CLASS_CUSTOM_FILES
33: where CLASSFILEID = X_CLASSFILEID;
34: begin
35: insert into MWA_CLASS_CUSTOM_FILES (
36: CLASSFILEID,
37: CLASSOLDFILE,
38: CLASSNEWFILE,
39: ENABLED,

Line 154: from MWA_CLASS_CUSTOM_FILES

150: ATTRIBUTE12,
151: ATTRIBUTE13,
152: ATTRIBUTE14,
153: ATTRIBUTE15
154: from MWA_CLASS_CUSTOM_FILES
155: where ROWID = X_ROWID
156: for update of CLASSFILEID nowait;
157: recinfo get_lock%rowtype;
158:

Line 251: update MWA_CLASS_CUSTOM_FILES set

247: X_ATTRIBUTE14 in VARCHAR2,
248: X_ATTRIBUTE15 in VARCHAR2)
249: is
250: begin
251: update MWA_CLASS_CUSTOM_FILES set
252: CLASSOLDFILE = X_CLASSOLDFILE,
253: CLASSNEWFILE = X_CLASSNEWFILE,
254: ENABLED = X_ENABLED,
255: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 287: delete from MWA_CLASS_CUSTOM_FILES

283:
284: procedure DELETE_ROW (X_CLASSFILEID in NUMBER)
285: is
286: begin
287: delete from MWA_CLASS_CUSTOM_FILES
288: where CLASSFILEID = X_CLASSFILEID;
289:
290: if (sql%notfound) then
291: raise no_data_found;