1 PACKAGE EDR_ISIGN_TEMPLATE_PKG AS
2 /* $Header: EDRITPS.pls 120.0.12000000.1 2007/01/18 05:54:08 appldev ship $ */
3
4
5 -- EDR_ISIGN_TEMPLATE_PKG.GET_XSLFO_TEMPLATE procedure is called from EDRRuleXMLPublisherHandler Class
6 -- to get the handle of XSLFO Blob. It passes template name and template type as input and get the template
7 -- blob and other information as output.
8
9 -- P_STYLE_SHEET - Original file name of template
10 -- P_STYLE_SHEET_VER - Version label of template
11 -- X_SS_BLOB - Blob containing template
12 -- X_SS_APPROVED - Is template approved Y or N
13 -- X_ERROR_CODE - Error code if XSLFO cannot be found
14 -- X_ERROR_MSG - Error message in case of any errors
15
16 PROCEDURE GET_XSLFO_TEMPLATE(p_style_sheet VARCHAR2,
17 p_style_sheet_ver VARCHAR2,
18 x_ss_blob out nocopy BLOB,
19 x_ss_approved out nocopy VARCHAR2,
20 x_ss_type out nocopy VARCHAR2,
21 x_error_code out nocopy VARCHAR2,
22 x_error_msg OUT NOCOPY VARCHAR2);
23
24 -- EDR_ISIGN_TEMPLATE_PKG.GET_TEMPLATE procedure is called from TemplateManager Class
25 -- to get the handle of RTF Template Blob. It passes unique p_event_key which is equal to file_id
26 -- in ISIGN edr_files_b table.
27 --
28 -- P_EVENT_KEY - File Id for the ISIGN EDR_FILES_B Table repository
29 -- X_TEMPALTE_TYPE - Return template type as string e.g. RTF, XSL, PDF
30 -- X_TEMPLATE_BLOB - Return Template contents in BLOB
31 -- X_TEMPLATE_FILE_NAME - Return Template File Name as String
32
33 PROCEDURE GET_TEMPLATE (p_event_key VARCHAR2,
34 x_template_type out nocopy VARCHAR2,
35 x_template_blob out nocopy BLOB,
36 x_template_file_name OUT NOCOPY VARCHAR2
37 );
38
39 END EDR_ISIGN_TEMPLATE_PKG;