[Home] [Help]
PACKAGE: APPS.AMW_RISK_APPROVAL_PVT
Source
1 PACKAGE amw_risk_approval_pvt AUTHID CURRENT_USER AS
2 /* $Header: amwvraps.pls 115.4 2003/06/26 06:04:45 npanandi noship $ */
3
4 -- PROCEDURE
5 -- Notify_requestor_FYI
6 --
7 -- PURPOSE
8 -- Generate the Requisition Document for display in messages, either
9 -- text or html
10 -- IN
11 -- document_id - Item Key
12 -- display_type - either 'text/plain' or 'text/html'
13 -- document - document buffer
14 -- document_type - type of document buffer created, either 'text/plain'
15 -- or 'text/html'
16 -- OUT
17 -- USED BY
18 -- - Oracle Internal Controls Generic Apporval
19 -- HISTORY
20 -- 6/4/2003 MUMU PANDE CREATION
21 -----------------------------------------------------------------
22 PROCEDURE notify_requestor_fyi(
23 document_id IN VARCHAR2
24 ,display_type IN VARCHAR2
25 ,document IN OUT NOCOPY VARCHAR2
26 ,document_type IN OUT NOCOPY VARCHAR2);
27
28 --------------------------------------------------------------------------
29 -- PROCEDURE
30 -- Notify_requestor_of Approval
31 --
32 -- PURPOSE
33 -- Generate the Approval Document for display in messages, either
34 -- text or html
35 -- IN
36 -- document_id - Item Key
37 -- display_type - either 'text/plain' or 'text/html'
38 -- document - document buffer
39 -- document_type - type of document buffer created, either 'text/plain'
40 -- or 'text/html'
41 -- OUT
42 -- USED BY
43 -- - Oracle Internal Controls Generic Apporval
44 -- HISTORY
45 -- 6/4/2003 MUMU PANDE CREATION
46 ----------------------------------------------------------------------------
47
48 PROCEDURE notify_requestor_of_approval(
49 document_id IN VARCHAR2
50 ,display_type IN VARCHAR2
51 ,document IN OUT NOCOPY VARCHAR2
52 ,document_type IN OUT NOCOPY VARCHAR2);
53
54 --------------------------------------------------------------------------
55 -- PROCEDURE
56 -- Notify_requestor_of rejection
57 --
58 -- PURPOSE
59 -- Generate the Rejection Document for display in messages, either
60 -- text or html
61 -- IN
62 -- document_id - Item Key
63 -- display_type - either 'text/plain' or 'text/html'
64 -- document - document buffer
65 -- document_type - type of document buffer created, either 'text/plain'
66 -- or 'text/html'
67 -- OUT
68 -- USED BY
69 -- - Oracle Internal Controls Generic Apporval
70 -- HISTORY
71 -- 6/4/2003 MUMU PANDE CREATION
72 -------------------------------------------------------------------------------
73
74 PROCEDURE notify_requestor_of_rejection(
75 document_id IN VARCHAR2
76 ,display_type IN VARCHAR2
77 ,document IN OUT NOCOPY VARCHAR2
78 ,document_type IN OUT NOCOPY VARCHAR2);
79
80 --------------------------------------------------------------------------
81 -- PROCEDURE
82 -- Notify_requestor_of rejection
83 --
84 -- PURPOSE
85 -- Generate the Rejection Document for display in messages, either
86 -- text or html
87 -- IN
88 -- document_id - Item Key
89 -- display_type - either 'text/plain' or 'text/html'
90 -- document - document buffer
91 -- document_type - type of document buffer created, either 'text/plain'
92 -- or 'text/html'
93 -- OUT
94 -- USED BY
95 -- - Oracle Internal Controls Generic Apporval
96 -- HISTORY
97 -- 6/4/2003 MUMU PANDE CREATION
98
99
100 PROCEDURE notify_approval_required(
101 document_id IN VARCHAR2
102 ,display_type IN VARCHAR2
103 ,document IN OUT NOCOPY VARCHAR2
104 ,document_type IN OUT NOCOPY VARCHAR2);
105
106 --------------------------------------------------------------------------
107 -- PROCEDURE
108 -- notify_appr_req_reminder
109 --
110 -- PURPOSE
111 -- Generate the Rejection Document for display in messages, either
112 -- text or html
113 -- IN
114 -- document_id - Item Key
115 -- display_type - either 'text/plain' or 'text/html'
116 -- document - document buffer
117 -- document_type - type of document buffer created, either 'text/plain'
118 -- or 'text/html'
119 -- OUT
120 -- USED BY
121 -- - Oracle Internal Controls Generic Apporval
122 -- HISTORY
123 -- 6/4/2003 MUMU PANDE CREATION
124
125
126 PROCEDURE notify_appr_req_reminder(
127 document_id IN VARCHAR2
128 ,display_type IN VARCHAR2
129 ,document IN OUT NOCOPY VARCHAR2
130 ,document_type IN OUT NOCOPY VARCHAR2);
131
132 ---------------------------------------------------------------------
133 -- PROCEDURE
134 -- Set_risk_object_details
135 --
136 --
137 -- PURPOSE
138 -- This Procedure will set all the item attribute details
139 --
140 --
141 -- IN
142 --
143 --
144 -- OUT
145 --
146 -- Used By Activities
147 --
148 -- NOTES
149 --
150 --
151 --
152 -- HISTORY
153 -- 6/4/2003 MUMU PANDE CREATION
154 -- End of Comments
155 --------------------------------------------------------------------
156 PROCEDURE set_risk_object_details(
157 itemtype IN VARCHAR2
158 ,itemkey IN VARCHAR2
159 ,actid IN NUMBER
160 ,funcmode IN VARCHAR2
161 ,resultout OUT NOCOPY VARCHAR2);
162
163 ---------------------------------------------------------------------
164 -- PROCEDURE
165 -- Update_risk_Status
166 --
167 --
168 -- PURPOSE
169 -- This Procedure will update the status
170 --
171 --
172 -- IN
173 --
174 --
175 -- OUT
176 --
177 -- Used By Activities
178 --
179 -- NOTES
180 --
181 --
182 --
183 -- HISTORY
184 -- 6/4/2003 MUMU PANDE CREATION
185 -- End of Comments
186 --------------------------------------------------------------------
187
188
189 PROCEDURE update_risk_status(
190 itemtype IN VARCHAR2
191 ,itemkey IN VARCHAR2
192 ,actid IN NUMBER
193 ,funcmode IN VARCHAR2
194 ,resultout OUT NOCOPY VARCHAR2);
195
196 END amw_risk_approval_pvt;