APPS.FND_FILE_MIME_TYPES_PKG dependencies on FND_MIME_TYPES

Line 16: cursor C is select rowid from fnd_mime_types

12: X_LAST_UPDATE_LOGIN in NUMBER DEFAULT NULL,
13: X_FILE_EXT in VARCHAR2,
14: X_ALLOW_FILE_UPLOAD in VARCHAR2) IS
15:
16: cursor C is select rowid from fnd_mime_types
17: where lower(mime_type) = lower(x_mime_type)
18: and nvl(lower(file_ext),'NULL') = nvl(lower(x_file_ext),'NULL');
19:
20: cursor cnt is select count(*) from fnd_mime_types

Line 20: cursor cnt is select count(*) from fnd_mime_types

16: cursor C is select rowid from fnd_mime_types
17: where lower(mime_type) = lower(x_mime_type)
18: and nvl(lower(file_ext),'NULL') = nvl(lower(x_file_ext),'NULL');
19:
20: cursor cnt is select count(*) from fnd_mime_types
21: where lower(mime_type) = lower(x_mime_type)
22: and nvl(lower(file_ext),'NULL') = nvl(lower(x_file_ext),'NULL');
23:
24: chk_exists number;

Line 36: select fnd_mime_types_s.NEXTVAL into x_mime_type_id from dual;

32: * can be retrieved and returned to the caller
33: */
34:
35: if (chk_exists = 0) then
36: select fnd_mime_types_s.NEXTVAL into x_mime_type_id from dual;
37:
38: INSERT INTO fnd_mime_types (mime_type_id,
39: mime_type,
40: cp_format_code,

Line 38: INSERT INTO fnd_mime_types (mime_type_id,

34:
35: if (chk_exists = 0) then
36: select fnd_mime_types_s.NEXTVAL into x_mime_type_id from dual;
37:
38: INSERT INTO fnd_mime_types (mime_type_id,
39: mime_type,
40: cp_format_code,
41: ctx_format_code,
42: creation_date,

Line 100: from fnd_mime_types m

96: decode(x_ctx_format_code,fnd_file_mime_types_pkg.null_char,null,null,m.ctx_format_code,x_ctx_format_code),
97: decode(x_file_ext,fnd_file_mime_types_pkg.null_char,null,null,m.file_ext,x_file_ext),
98: decode(x_allow_file_upload,fnd_file_mime_types_pkg.null_char,null,null,m.allow_file_upload,x_allow_file_upload)
99: into l_cp_format_code, l_ctx_format_code, l_file_ext, l_allow_file_upload
100: from fnd_mime_types m
101: where lower(mime_type) = lower(x_mime_type)
102: and lower(file_ext) = lower(x_file_ext);
103: exception when no_data_found then
104:

Line 110: from fnd_mime_types m

106: decode(x_ctx_format_code,fnd_file_mime_types_pkg.null_char,null,null,m.ctx_format_code,x_ctx_format_code),
107: decode(x_file_ext,fnd_file_mime_types_pkg.null_char,null,null,m.file_ext,x_file_ext),
108: decode(x_allow_file_upload,fnd_file_mime_types_pkg.null_char,null,null,m.allow_file_upload,x_allow_file_upload)
109: into l_cp_format_code, l_ctx_format_code, l_file_ext, l_allow_file_upload
110: from fnd_mime_types m
111: where lower(mime_type) = lower(x_mime_type);
112: end;
113:
114:

Line 115: update fnd_mime_types

111: where lower(mime_type) = lower(x_mime_type);
112: end;
113:
114:
115: update fnd_mime_types
116: set cp_format_code = l_cp_format_code,
117: ctx_format_code = l_ctx_format_code,
118: file_ext = l_file_ext,
119: allow_file_upload = l_allow_file_upload

Line 129: delete from fnd_mime_types

125: PROCEDURE DELETE_ROW (X_MIME_TYPE in VARCHAR2,
126: X_FILE_EXT in VARCHAR2) IS
127:
128: BEGIN
129: delete from fnd_mime_types
130: where lower(mime_type) like lower(x_mime_type)
131: and lower(file_ext) like lower(x_file_ext);
132:
133: if (sql%notfound) then

Line 142: UPDATE FND_MIME_TYPES

138:
139: PROCEDURE SET_FILE_EXT (X_MIME_TYPE IN VARCHAR2, X_FILE_EXT IN VARCHAR2) IS
140:
141: BEGIN
142: UPDATE FND_MIME_TYPES
143: SET FILE_EXT = X_FILE_EXT
144: WHERE lower(MIME_TYPE) like lower(X_MIME_TYPE);
145:
146: END;

Line 151: UPDATE FND_MIME_TYPES

147:
148: PROCEDURE SET_ALLOW_UPLOAD (X_FILE_EXT IN VARCHAR2, X_ALLOW_FILE_UPLOAD IN VARCHAR2) IS
149:
150: BEGIN
151: UPDATE FND_MIME_TYPES
152: SET ALLOW_FILE_UPLOAD = X_ALLOW_FILE_UPLOAD
153: WHERE lower(FILE_EXT) = lower(X_FILE_EXT);
154:
155: END;