1 PACKAGE PO_WF_REQ_NOTIFICATION AUTHID CURRENT_USER AS
2 /* $Header: POXWPA6S.pls 115.14 2004/02/23 12:24:11 manram ship $ */
3
4 /* This function is the PL/SQL document function to retrieve the
5 ** approval notification message header of the requisition.
6 */
7 PROCEDURE get_po_req_approve_msg(document_id in varchar2,
8 display_type in varchar2,
9 document in out NOCOPY varchar2,
10 document_type in out NOCOPY varchar2);
11
12 /* This function is the PL/SQL document function to retrieve the
13 ** approved notification message header of the requisition.
14 */
15 PROCEDURE get_po_req_approved_msg(document_id in varchar2,
16 display_type in varchar2,
17 document in out NOCOPY varchar2,
18 document_type in out NOCOPY varchar2);
19
20 /* This function is the PL/SQL document function to retrieve the
21 ** no approver notification message header of the requisition.
22 */
23 PROCEDURE get_po_req_no_approver_msg(document_id in varchar2,
24 display_type in varchar2,
25 document in out NOCOPY varchar2,
26 document_type in out NOCOPY varchar2);
27
28 /* This function is the PL/SQL document function to retrieve the
29 ** rejected notification message header of the requisition.
30 */
31 PROCEDURE get_po_req_reject_msg(document_id in varchar2,
32 display_type in varchar2,
33 document in out NOCOPY varchar2,
34 document_type in out NOCOPY varchar2);
35
36 PROCEDURE get_req_lines_details(document_id in varchar2,
37 display_type in varchar2,
38 document in out NOCOPY varchar2,
39 document_type in out NOCOPY varchar2);
40
41 /* Bug #1581410 :kagarwal
42 ** Desc: This procedure is added for the new UI and is called only
43 ** by get_po_req_approve_msg and get_po_req_reject_msg messages for
44 ** the html body. It also creates 'View Requisition Details' and
45 ** 'Edit Requisition' links in the message body.
46 */
47 PROCEDURE get_req_lines_details_link(document_id in varchar2,
48 display_type in varchar2,
49 document in out NOCOPY varchar2,
50 document_type in out NOCOPY varchar2);
51
52 /* This function is the PL/SQL document function to retrieve the
53 ** action history of the requisition.
54 */
55 PROCEDURE get_action_history(document_id in varchar2,
56 display_type in varchar2,
57 document in out NOCOPY varchar2,
58 document_type in out NOCOPY varchar2);
59
60 /* Bug #1581410 :kagarwal
61 ** Desc: This procedure has been added for the new UI. This is
62 ** called by all the messages using the new UI for the html body.
63 */
64
65 PROCEDURE get_action_history_html(document_id in varchar2,
66 display_type in varchar2,
67 document in out NOCOPY varchar2,
68 document_type in out NOCOPY varchar2);
69
70 /* This function is the post-notification logic of requisition approval
71 ** notification.
72 */
73 PROCEDURE post_approval_notif(itemtype in varchar2,
74 itemkey in varchar2,
75 actid in number,
76 funcmode in varchar2,
77 resultout out NOCOPY varchar2);
78
79 /* Bug# 2469882
80 ** Desc: Added new procedure to set notification subject token.
81 */
82 procedure Get_req_approver_msg_attribute(itemtype in varchar2,
83 itemkey in varchar2,
84 actid in number,
85 funcmode in varchar2,
86 resultout out NOCOPY varchar2);
87
88 procedure Get_req_preparer_msg_attribute(itemtype in varchar2,
89 itemkey in varchar2,
90 actid in number,
91 funcmode in varchar2,
92 resultout out NOCOPY varchar2);
93
94 /* Procedure to check whether Forward Action is allowed. */
95
96 procedure Is_Forward_Action_Allowed(itemtype in varchar2,
97 itemkey in varchar2,
98 actid in number,
99 funcmode in varchar2,
100 resultout out NOCOPY varchar2 );
101
102 /* Bug# 2616255: kagarwal
103 ** Desc: Added new procedure to set notification subject token
104 ** for the notifications sent to forward from person
105 */
106 procedure Get_req_fwdfrom_msg_attribute(itemtype in varchar2,
107 itemkey in varchar2,
108 actid in number,
109 funcmode in varchar2,
110 resultout out NOCOPY varchar2);
111
112 /* Bug# 3419861: manram
113 ** Desc: Added new function which returns the formatted currency
114 ** for a given currency code and amount.
115 */
116
117 Function FORMAT_CURRENCY_NO_PRECESION (p_currency_code IN varchar2,
118 p_amount IN number ) return Varchar2;
119
120 END PO_WF_REQ_NOTIFICATION;