DBA Data[Home] [Help]

APPS.FND_FILE_MIME_TYPES_PKG dependencies on FND_FILE_MIME_TYPES_PKG

Line 1: package body FND_FILE_MIME_TYPES_PKG as

1: package body FND_FILE_MIME_TYPES_PKG as
2: /* $Header: AFATFMTB.pls 120.3.12020000.2 2012/12/04 20:29:38 ctilley ship $ */
3:
4: PROCEDURE INSERT_ROW (X_ROWID in out nocopy VARCHAR2,
5: X_MIME_TYPE in VARCHAR2,

Line 95: select decode(x_cp_format_code,fnd_file_mime_types_pkg.null_char,null,null,m.cp_format_code,x_cp_format_code),

91: l_file_ext varchar2(10);
92:
93: BEGIN
94: begin
95: select decode(x_cp_format_code,fnd_file_mime_types_pkg.null_char,null,null,m.cp_format_code,x_cp_format_code),
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

Line 96: decode(x_ctx_format_code,fnd_file_mime_types_pkg.null_char,null,null,m.ctx_format_code,x_ctx_format_code),

92:
93: BEGIN
94: begin
95: select decode(x_cp_format_code,fnd_file_mime_types_pkg.null_char,null,null,m.cp_format_code,x_cp_format_code),
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

Line 97: decode(x_file_ext,fnd_file_mime_types_pkg.null_char,null,null,m.file_ext,x_file_ext),

93: BEGIN
94: begin
95: select decode(x_cp_format_code,fnd_file_mime_types_pkg.null_char,null,null,m.cp_format_code,x_cp_format_code),
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)

Line 98: decode(x_allow_file_upload,fnd_file_mime_types_pkg.null_char,null,null,m.allow_file_upload,x_allow_file_upload)

94: begin
95: select decode(x_cp_format_code,fnd_file_mime_types_pkg.null_char,null,null,m.cp_format_code,x_cp_format_code),
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);

Line 105: select decode(x_cp_format_code,fnd_file_mime_types_pkg.null_char,null,null,m.cp_format_code,x_cp_format_code),

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:
105: select decode(x_cp_format_code,fnd_file_mime_types_pkg.null_char,null,null,m.cp_format_code,x_cp_format_code),
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

Line 106: decode(x_ctx_format_code,fnd_file_mime_types_pkg.null_char,null,null,m.ctx_format_code,x_ctx_format_code),

102: and lower(file_ext) = lower(x_file_ext);
103: exception when no_data_found then
104:
105: select decode(x_cp_format_code,fnd_file_mime_types_pkg.null_char,null,null,m.cp_format_code,x_cp_format_code),
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

Line 107: decode(x_file_ext,fnd_file_mime_types_pkg.null_char,null,null,m.file_ext,x_file_ext),

103: exception when no_data_found then
104:
105: select decode(x_cp_format_code,fnd_file_mime_types_pkg.null_char,null,null,m.cp_format_code,x_cp_format_code),
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);

Line 108: decode(x_allow_file_upload,fnd_file_mime_types_pkg.null_char,null,null,m.allow_file_upload,x_allow_file_upload)

104:
105: select decode(x_cp_format_code,fnd_file_mime_types_pkg.null_char,null,null,m.cp_format_code,x_cp_format_code),
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;

Line 158: END FND_FILE_MIME_TYPES_PKG;

154:
155: END;
156:
157:
158: END FND_FILE_MIME_TYPES_PKG;