1 PACKAGE okl_vp_pa_wf AUTHID CURRENT_USER AS
2 /* $Header: OKLRPAWS.pls 120.0 2005/07/28 11:44:42 sjalasut noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL VARIABLES
5 ---------------------------------------------------------------------------
6 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_VP_PA_WF';
7 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
8 G_API_TYPE CONSTANT VARCHAR2(30) := '_PVT';
9
10 -------------------------------------------------------------------------------
11 -- PROCEDURE raise_pa_event_approval
12 -------------------------------------------------------------------------------
13 -- Start of comments
14 --
15 -- Procedure Name : raise_pa_event_approval
16 -- Description : procedure raises business event for program agreement approval
17 -- : business event name oracle.apps.okl.la.vp.approve_program_agreement
18 -- Parameters : IN p_chr_id agreement id
19 -- Version : 1.0
20 -- History : May 18, 05 SJALASUT created
21 -- End of comments
22 PROCEDURE raise_pa_event_approval(p_api_version IN NUMBER
23 ,p_init_msg_list IN VARCHAR2
24 ,x_return_status OUT NOCOPY VARCHAR2
25 ,x_msg_count OUT NOCOPY NUMBER
26 ,x_msg_data OUT NOCOPY VARCHAR2
27 ,p_chr_id IN okc_k_headers_b.id%TYPE
28 );
29 -------------------------------------------------------------------------------
30 -- PROCEDURE check_approval_process
31 -------------------------------------------------------------------------------
32 -- Start of comments
33 --
34 -- Procedure Name : check_approval_process
35 -- Description : procedure that checks the approval configured in the profile
36 -- : OKL: Program Agreement Approval Process
37 -- Parameters : default wf parameters
38 -- Version : 1.0
39 -- History : May 18, 05 SJALASUT created
40 -- End of comments
41 PROCEDURE check_approval_process(itemtype IN VARCHAR2
42 ,itemkey IN VARCHAR2
43 ,actid IN NUMBER
44 ,funcmode IN VARCHAR2
45 ,resultout OUT NOCOPY VARCHAR2);
46 -------------------------------------------------------------------------------
47 -- PROCEDURE get_agrmnt_approver
48 -------------------------------------------------------------------------------
49 -- Start of comments
50 --
51 -- Procedure Name : get_agrmnt_approver
52 -- Description : procedure that gets the approver for workflow based approval
53 -- : the logic first finds if requester has a role to send,
54 -- if not found, the requisition goes to sysadmin
55 -- Parameters : default wf parameters
56 -- Version : 1.0
57 -- History : May 18, 05 SJALASUT created
58 -- End of comments
59 PROCEDURE get_agrmnt_approver(itemtype IN VARCHAR2
60 ,itemkey IN VARCHAR2
61 ,actid IN NUMBER
62 ,funcmode IN VARCHAR2
63 ,resultout OUT NOCOPY VARCHAR2);
64
65 -------------------------------------------------------------------------------
66 -- PROCEDURE get_msg_doc
67 -------------------------------------------------------------------------------
68 -- Start of comments
69 --
70 -- Procedure Name : get_msg_doc
71 -- Description : get_msg_doc constructs a sample summary of information that is
72 -- : displayed in the notification for approval, rejection and approved
73 -- operating agreements
74 -- Parameters : default wf parameters
75 -- Version : 1.0
76 -- History : May 18, 05 SJALASUT created
77 -- End of comments
78 PROCEDURE get_msg_doc(document_id IN VARCHAR2
79 ,display_type IN VARCHAR2
80 ,document IN OUT nocopy VARCHAR2
81 ,document_type IN OUT nocopy VARCHAR2
82 );
83
84 -------------------------------------------------------------------------------
85 -- PROCEDURE update_agrmnt_status
86 -------------------------------------------------------------------------------
87 -- Start of comments
88 --
89 -- Procedure Name : update_agrmnt_status
90 -- Description : updates agreement status based on the approval outcome
91 -- via workflow or AME
92 -- Parameters : default wf parameters
93 -- Version : 1.0
94 -- History : May 18, 05 SJALASUT created
95 -- End of comments
96 PROCEDURE update_agrmnt_status(itemtype IN VARCHAR2
97 ,itemkey IN VARCHAR2
98 ,actid IN NUMBER
99 ,funcmode IN VARCHAR2
100 ,resultout OUT NOCOPY VARCHAR2);
101
102 -------------------------------------------------------------------------------
103 -- PROCEDURE process_pa_for_ame
104 -------------------------------------------------------------------------------
105 -- Start of comments
106 --
107 -- Procedure Name : process_pa_for_ame
108 -- Description : procedure that sets the message subjects, transaction context
109 -- : for Oracle Approvals Managment to handle the program agreement
110 -- approval process
111 -- Parameters : default wf parameters
112 -- Version : 1.0
113 -- History : May 18, 05 SJALASUT created
114 -- End of comments
115
116 PROCEDURE process_pa_for_ame(itemtype IN VARCHAR2
117 ,itemkey IN VARCHAR2
118 ,actid IN NUMBER
119 ,funcmode IN VARCHAR2
120 ,resultout OUT NOCOPY VARCHAR2);
121
122 -------------------------------------------------------------------------------
123 -- PROCEDURE set_msg_attributes
124 -------------------------------------------------------------------------------
125 -- Start of comments
126 --
127 -- Procedure Name : set_msg_attributes
128 -- Description : set_msg_attributes sets the notification contents based on the
129 -- : outcome of the approval process via workflow
130 -- Parameters : default wf parameters
131 -- Version : 1.0
132 -- History : May 18, 05 SJALASUT created
133 -- End of comments
134 PROCEDURE set_msg_attributes(itemtype IN VARCHAR2
135 ,itemkey IN VARCHAR2
136 ,actid IN NUMBER
137 ,funcmode IN VARCHAR2
138 ,resultout OUT NOCOPY VARCHAR2);
139
140 END okl_vp_pa_wf;