1 PACKAGE EDR_XDOC_UTIL_PKG AS
2 /* $Header: EDRXDUS.pls 120.4.12000000.1 2007/01/18 05:56:50 appldev ship $ */
3
4 -- EDR_XDOC_UTIL_PKG.GENERATE_ERECORD Procedure is called from STORE_ERECORD
5 -- procedure of RULE FUNCTION. Its purpose is to call the JSP with all the
6 -- required parameters passed in URL and return ERECORD or return error message
7 -- if there is any error in this processing.
8
9 -- P_EDR_EVENT_ID - Unique event id for the event being executed, for which
10 -- eRecord is to be generated
11 -- P_ERECORD_ID - ERecord Id for the eRecord to be generated.
12 -- P_STYLE_SHEET_REPOSITORY - Name of template repository to be used to generate the
13 -- eRecord
14 -- P_STYLE_SHEET - Template File Name as Setup in AME / Transaction Variable for
15 -- this event
16 -- P_STYLE_SHEET_VER - Version Label of the template file as setup in AME / Transaction Variable for
17 -- this event
18 -- X_OUTPUT_FORMAT - Format of eRecord Output viz. PDF, DOC, HTML, TEXT
19 -- X_ERROR_CODE - Error Code in case of any errors
20 -- X_ERROR_MESSAGE - Error Message in case of any errors.
21
22 -- Bug 3170251 : start : rvsingh
23 -- Bug 3761813 : start : rvsingh
24 procedure GENERATE_ERECORD
25 (
26 p_edr_event_id NUMBER,
27 p_erecord_id NUMBER,
28 p_style_sheet_repository VARCHAR2,
29 p_style_sheet VARCHAR2,
30 p_style_sheet_ver VARCHAR2,
31 p_application_code VARCHAR2,
32 p_redline_mode VARCHAR2,
33 x_output_format OUT NOCOPY VARCHAR2,
34 x_error_code OUT NOCOPY NUMBER,
35 x_error_msg OUT NOCOPY VARCHAR2
36 );
37 -- Bug 3761813 : end : rvsingh
38 -- Bug 3170251 : End
39 -- EDR_XDOC_UTIL_PKG.EDR_CREATE_ATTACHEMENT is called from EDRRuleXMLPublisher Object.
40 -- It creates an FND Attachment for the eRecord PDF to be generated and returns
41 -- the file_id created in FND_LOBS table.
42
43 -- P_ERECORD_ID - ERecord Id for the eRecord to be generated.
44 -- P_FILE_NAME - Name of EReocrd File
45 -- P_STYLE_SHEET - ERecord File Description
46 -- P_CONTENT_TYPE - ERecord File Content Type
47 -- X_File_ID - MediaId (FND_LOBS File Id) of the ERecord Attachement
48 -- created
49
50 procedure EDR_CREATE_ATTACHMENT (
51 p_eRecord_ID NUMBER,
52 P_FILE_NAME VARCHAR2,
53 p_description VARCHAR2,
54 p_content_type VARCHAR2,
55 p_file_format VARCHAR2,
56 p_source_lang VARCHAR2,
57 x_FILE_id OUT NOCOPY NUMBER);
58
59 -- EDR_XDOC_UTIL_PKG.GET_NTF_MESSAGE_BODY is called from Workflow while rendering the
60 -- Notification for rendering E-Record Message "Please read the attached ... eRecord_XXXX.pdf"
61 -- This procedure follows PLSQL Document Attrubute Format API Call conventions
62
63 -- p_document_id - This field is used to pass eRecord Id -- > ERECORD_ID
64 -- p_display_type - Format of display text/palin, text/html etc...
65 -- x_document - Document rendered in VARCHAR2 string is returned
66 -- eRecord
67 -- x_document_type - Document type i.e. text, rtf, doc, etc...
68
69 procedure GET_NTF_MESSAGE_BODY
70 ( p_document_id in varchar2,
71 p_display_type in varchar2,
72 x_document in out nocopy varchar2,
73 x_document_type in out nocopy varchar2
74 );
75
76
77 -- EDR_XDOC_UTIL_PKG.REQUEST_HTTP provides a wrapper over UTL_HTTP calls
78 -- It performs all the checks required on URL before calling UTL_HTTP.REQUEST
79 -- This FUNCTION follows PLSQL API Call conventions.
80
81 -- p_request_url - Request URL over which UTL_HTTP call is to be made.
82 -- returns varchar2 - HTTP_RESPONSE returned from UTL_HTTP.REQUEST
83
84 function REQUEST_HTTP
85 (
86 p_request_url in varchar2
87
88 ) return varchar2;
89
90 -- Bug 4450651 Start
91 -- EDR_XDOC_UTIL_PKG.GET_SERVICE_TICKET_STRING function is called before HTTP request call is made.
92 -- and append the request ticket to HTTP URL .Its purpose is to make JSP call to be secured.
93 -- p_request_service_name - Service name
94 function GET_SERVICE_TICKET_STRING
95 (
96 p_request_service_name in varchar2
97 ) return varchar2 ;
98
99 -- EDR_XDOC_UTIL_PKG.COMPARE_SERVICE_TICKET_STRINGS function is called after HTTP request call is made.
100 -- and requested ticket with HTTP URL is compared with new ticket .if both the ticket are same then
101 -- call has been made from valid source and request can be processed else abort the process .
102 -- P_TICKET1 - request ticket from http url
103
104 function VALIDATE_SERVICE_TICKET(P_TICKET in varchar2)
105 return varchar2;
106
107 -- Bug 4450651 End
108
109 end EDR_XDOC_UTIL_PKG;