1 package FND_FILE_MIME_TYPES_PKG AUTHID CURRENT_USER as
2 /* $Header: AFATFMTS.pls 120.1 2011/08/25 15:47:52 ctilley noship $ */
3
4 null_char varchar2(8) := '*NULL*';
5 null_date date := to_date('2', 'J');
6 null_number number := -999;
7
8 PROCEDURE INSERT_ROW (X_ROWID in out nocopy VARCHAR2,
9 X_MIME_TYPE in VARCHAR2,
10 X_CP_FORMAT_CODE in VARCHAR2 DEFAULT NULL,
11 X_CTX_FORMAT_CODE in VARCHAR2 DEFAULT 'IGNORE',
12 X_CREATION_DATE in DATE DEFAULT SYSDATE,
13 X_CREATED_BY in NUMBER,
14 X_LAST_UPDATE_DATE in DATE DEFAULT SYSDATE,
15 X_LAST_UPDATED_BY in NUMBER,
16 X_LAST_UPDATE_LOGIN in NUMBER DEFAULT NULL,
17 X_FILE_EXT in VARCHAR2,
18 X_ALLOW_FILE_UPLOAD in VARCHAR2);
19
20
21 PROCEDURE UPDATE_ROW (X_MIME_TYPE in VARCHAR2,
22 X_CP_FORMAT_CODE in VARCHAR2,
23 X_CTX_FORMAT_CODE in VARCHAR2,
24 X_LAST_UPDATE_DATE in DATE,
25 X_LAST_UPDATED_BY in NUMBER,
26 X_LAST_UPDATE_LOGIN in NUMBER DEFAULT NULL,
27 X_FILE_EXT in VARCHAR2,
28 X_ALLOW_FILE_UPLOAD in VARCHAR2);
29
30
31 PROCEDURE DELETE_ROW (X_MIME_TYPE in VARCHAR2,
32 X_FILE_EXT in VARCHAR2);
33
34
35 PROCEDURE SET_FILE_EXT (X_MIME_TYPE IN VARCHAR2, X_FILE_EXT IN VARCHAR2);
36
37 PROCEDURE SET_ALLOW_UPLOAD (X_FILE_EXT IN VARCHAR2, X_ALLOW_FILE_UPLOAD IN VARCHAR2);
38
39 END FND_FILE_MIME_TYPES_PKG;