1 PACKAGE PO_WF_REQ_NOTIFICATION_R11 AUTHID CURRENT_USER AS
2 /* $Header: POXWPA8S.pls 115.2 2002/11/22 22:09:40 sbull noship $ */
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 /* This function is the PL/SQL document function to retrieve the
37 ** line details of the requisition.
38 */
39 PROCEDURE get_req_lines_details(document_id in varchar2,
40 display_type in varchar2,
41 document in out NOCOPY varchar2,
42 document_type in out NOCOPY varchar2);
43
44 PROCEDURE get_req_lines_details_link(document_id in varchar2,
45 display_type in varchar2,
46 document in out NOCOPY varchar2,
47 document_type in out NOCOPY varchar2);
48
49
50 /* This function is the PL/SQL document function to retrieve the
51 ** action history of the requisition.
52 */
53 PROCEDURE get_action_history(document_id in varchar2,
54 display_type in varchar2,
55 document in out NOCOPY varchar2,
56 document_type in out NOCOPY varchar2);
57
58 /* This function is the post-notification logic of requisition approval
59 ** notification.
60 */
61 PROCEDURE post_approval_notif(itemtype in varchar2,
62 itemkey in varchar2,
63 actid in number,
64 funcmode in varchar2,
65 resultout in out NOCOPY varchar2);
66
67 --
68 -- Newline
69 -- Return newline character in current codeset
70 --
71 function Newline
72 return varchar2;
73 pragma restrict_references (NEWLINE, WNDS, WNPS, RNPS);
74
75 END PO_WF_REQ_NOTIFICATION_R11;