1 PACKAGE PO_EMAIL_GENERATE AUTHID CURRENT_USER AS
2 /* $Header: POXWPAMS.pls 115.9 2002/11/22 22:08:25 sbull noship $ */
3
4
5
6 procedure generate_header (document_id in varchar2,
7 display_type in Varchar2,
8 document in out NOCOPY VARCHAR2,
9 document_type in out NOCOPY varchar2);
10
11
12 procedure generate_html (document_id in varchar2,
13 display_type in Varchar2,
14 document in out NOCOPY clob,
15 document_type in out NOCOPY varchar2);
16 /*
17 EMAILPO FPH
18 changed signature to take item_type_key instead of document_id parameter - No datatype changes
19 Format for item_type_key : <itemtype>:<itemkey>
20 Earlier format for document_id: <DocumentID>:<DocumentTypeCode>
21 Purpose: We need itemtype and itemkey to retrieve the attributes USER_ID, APPLICATION_ID and RESPONSIBILITY_ID
22 to set the context so that terms and conditions profile options can be retrieved correctly
23 DocumentID and DocumentTypeCode are unnecessary
24 Upgrade considerations and implications:
25 For any of the existing notifications which would still call this procedure with DocumentID:DocumentTypeCode
26 the behaviour will be same as before the fix for retrieving correct profile options as and only site level
27 profile options will be retrieved as context will not be set correctly. This is accomplished by handling any
28 exceptions that would arise while calling wf_engine.GetItemAttrNumber due to invalid itemtype and itemkey
29
30 Updates:
31 4/30/2002 by davidng - item_type_key is renamed back to document_id to standardize with common Workflow
32 standard.
33 */
34 procedure generate_terms (document_id in varchar2,
35 display_type in varchar2,
36 document in out NOCOPY clob,
37 document_type in out NOCOPY varchar2);
38
39
40 END PO_EMAIL_GENERATE;