1 PACKAGE PO_WF_PO_NOTIFICATION AS
2 /* $Header: POXWPA7S.pls 120.0.12010000.2 2008/08/04 08:36:22 rramasam ship $ */
3
4 PROCEDURE get_po_approve_msg ( document_id in varchar2,
5 display_type in varchar2,
6 document in out NOCOPY varchar2,
7 document_type in out NOCOPY varchar2);
8
9 PROCEDURE get_po_lines_details ( document_id in varchar2,
10 display_type in varchar2,
11 document in out NOCOPY CLOB, -- <BUG 7006113>
12 document_type in out NOCOPY varchar2);
13
14 PROCEDURE get_action_history ( document_id in varchar2,
15 display_type in varchar2,
16 document in out NOCOPY varchar2,
17 document_type in out NOCOPY varchar2);
18
19 /* This function is the post-notification logic of requisition approval
20 ** notification.
21 */
22 PROCEDURE post_approval_notif(itemtype in varchar2,
23 itemkey in varchar2,
24 actid in number,
25 funcmode in varchar2,
26 resultout in out NOCOPY varchar2);
27
28 /* Bug# 2616433: kagarwal
29 ** Desc: Added new procedure to set notification subject token.
30 */
31 procedure Get_po_user_msg_attribute(itemtype in varchar2,
32 itemkey in varchar2,
33 actid in number,
34 funcmode in varchar2,
35 resultout out NOCOPY varchar2);
36
37 procedure GetDisplayValue(itemtype in varchar2,
38 itemkey in varchar2,
39 username in varchar2 default NULL,
40 doctype in varchar2 default NULL,
41 docsubtype in varchar2 default NULL);
42
43 -- This function was written for bug 3607009, but
44 -- modified for bug 3668188
45 FUNCTION is_open_document_allowed
46 (
47 p_itemtype IN VARCHAR2
48 , p_itemkey IN VARCHAR2
49 , p_notification_type IN VARCHAR2 --bug 3668188
50 )
51 RETURN BOOLEAN;
52
53
54 END PO_WF_PO_NOTIFICATION;