DBA Data[Home] [Help]

PACKAGE: APPS.EDR_FILE_UTIL_PUB

Source


1 PACKAGE EDR_FILE_UTIL_PUB AUTHID CURRENT_USER AS
2 /* $Header: EDRFUTLS.pls 120.0.12000000.1 2007/01/18 05:53:07 appldev ship $ */
3 
4 G_API_VERSION NUMBER := 1.0;
5 
6 PROCEDURE GET_FILE_NAME(p_file_id IN NUMBER,
7 				x_file_name OUT NOCOPY VARCHAR2);
8 
9 PROCEDURE GET_VERSION_LABEL(p_file_id IN NUMBER,
10 				x_version_label OUT NOCOPY VARCHAR2);
11 
12 PROCEDURE GET_CATEGORY_NAME(p_file_id IN NUMBER,
13 				x_category_name OUT NOCOPY VARCHAR2);
14 
15 PROCEDURE GET_AUTHOR_NAME(p_file_id IN NUMBER,
16  			x_author_name OUT NOCOPY VARCHAR2);
17 
18 PROCEDURE GET_ATTRIBUTE(p_file_id IN NUMBER,
19 				p_attribute_col IN VARCHAR2,
20 				x_attribute_value OUT NOCOPY VARCHAR2);
21 
22 PROCEDURE GET_FILE_DATA(p_file_id NUMBER,
23                                 x_file_data OUT NOCOPY BLOB);
24 
25 END EDR_FILE_UTIL_PUB;