1 PACKAGE okl_vp_cr_wf AUTHID CURRENT_USER AS
2 /* $Header: OKLRCRWS.pls 120.0 2005/07/28 11:47:13 sjalasut noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL VARIABLES
5 ---------------------------------------------------------------------------
6 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_VP_CR_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_cr_event_approval
12 -------------------------------------------------------------------------------
13 -- Start of comments
14 --
15 -- Procedure Name : raise_cr_event_approval
16 -- Description : procedure raises business event for change request approval
17 -- : business event name oracle.apps.okl.la.vp.approve_change_request
18 -- Parameters : IN p_vp_crq_id change request agreement id
19 -- Version : 1.0
20 -- History : May 18, 05 SJALASUT created
21 -- End of comments
22 PROCEDURE raise_cr_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_vp_crq_id IN okl_vp_change_requests.id%TYPE
28 );
29 -------------------------------------------------------------------------------
30 -- PROCEDURE check_approval_process
31 -------------------------------------------------------------------------------
32 -- Start of comments
33 --
34 -- Procedure Name : check_approval_process
35 -- Description : procedure checks the approval process configured in the
36 -- profile OKL: Change Request Approval Process
37 -- Parameters : NONE
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 -------------------------------------------------------------------------------
48 -- PROCEDURE get_cr_approver
49 -------------------------------------------------------------------------------
50 -- Start of comments
51 --
52 -- Procedure Name : get_cr_approver
53 -- Description : procedure finds the approver to approve this change request
54 -- since this is a prototype, the requester is the approver
55 -- Parameters : NONE
56 -- Version : 1.0
57 -- History : May 18, 05 SJALASUT created
58 -- End of comments
59 PROCEDURE get_cr_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 -- change requests
74 -- Parameters : NONE
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_cr_status
86 -------------------------------------------------------------------------------
87 -- Start of comments
88 --
89 -- Procedure Name : update_cr_status
90 -- Description : updates change request status based on the approval outcome
91 -- via workflow or AME
92 -- Parameters : NONE
93 -- Version : 1.0
94 -- History : May 18, 05 SJALASUT created
95 -- End of comments
96 PROCEDURE update_cr_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_cr_for_ame
104 -------------------------------------------------------------------------------
105 -- Start of comments
106 --
107 -- Procedure Name : process_cr_for_ame
108 -- Description : procedure that sets the message subjects, transaction context
109 -- : for Oracle Approvals Managment to handle the change request
110 -- approval process
111 -- Parameters : NONE
112 -- Version : 1.0
113 -- History : May 18, 05 SJALASUT created
114 -- End of comments
115 PROCEDURE process_cr_for_ame(itemtype IN VARCHAR2
116 ,itemkey IN VARCHAR2
117 ,actid IN NUMBER
118 ,funcmode IN VARCHAR2
119 ,resultout OUT NOCOPY VARCHAR2);
120
121 -------------------------------------------------------------------------------
122 -- PROCEDURE set_msg_attributes
123 -------------------------------------------------------------------------------
124 -- Start of comments
125 --
126 -- Procedure Name : set_msg_attributes
127 -- Description : set_msg_attributes sets the notification contents based on the
128 -- : outcome of the approval process via workflow
129 -- Parameters : IN p_vp_crq_id change request agreement id
130 -- Version : 1.0
131 -- History : May 18, 05 SJALASUT created
132 -- End of comments
133 PROCEDURE set_msg_attributes(itemtype IN VARCHAR2
134 ,itemkey IN VARCHAR2
135 ,actid IN NUMBER
136 ,funcmode IN VARCHAR2
137 ,resultout OUT NOCOPY VARCHAR2);
138
139 END okl_vp_cr_wf;