DBA Data[Home] [Help]

PACKAGE: APPS.PO_EMAIL_GENERATE

Source


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;