[Home] [Help]
PACKAGE: APPS.OZF_FUND_APPROVAL_PVT
Source
1 PACKAGE OZF_fund_approval_pvt AUTHID CURRENT_USER AS
2 /* $Header: ozfvfaps.pls 120.0 2005/06/01 00:00:13 appldev 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 MArketing Generic Apporval
19 -- HISTORY
20 -- 03/15/2001 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 MArketing Generic Apporval
44 -- HISTORY
45 -- 03/15/2001 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 MArketing Generic Apporval
70 -- HISTORY
71 -- 03/15/2001 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 MArketing Generic Apporval
96 -- HISTORY
97 -- 03/15/2001 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 MArketing Generic Apporval
122 -- HISTORY
123 -- 03/15/2001 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_ParBudget_Activity_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 -- 02/20/2001 MUMU PANDE CREATION
154 -- End of Comments
155 --------------------------------------------------------------------
156 PROCEDURE set_parbudget_activity_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_ParBudget_Statas
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 -- 02/20/2001 MUMU PANDE CREATION
185 -- End of Comments
186 --------------------------------------------------------------------
187
188
189 PROCEDURE update_parbudget_status(
190 itemtype IN VARCHAR2
191 ,itemkey IN VARCHAR2
192 ,actid IN NUMBER
193 ,funcmode IN VARCHAR2
194 ,resultout OUT NOCOPY VARCHAR2);
195
196 ---------------------------------------------------------------------
197 -- PROCEDURE
198 -- revert_ParBudget_Statas
199 --
200 --
201 -- PURPOSE
202 -- This Procedure will update the status
203 --
204 --
205 -- IN
206 --
207 --
208 -- OUT
209 --
210 -- Used By Activities
211 --
212 -- NOTES
213 --
214 --
215 --
216 -- HISTORY
217 -- 02/20/2001 MUMU PANDE CREATION
218 -- End of Comments
219 --------------------------------------------------------------------
220 /*
221 PROCEDURE revert_parbudget_status(
222 itemtype IN VARCHAR2
223 ,itemkey IN VARCHAR2
224 ,actid IN NUMBER
225 ,funcmode IN VARCHAR2
226 ,resultout OUT VARCHAR2);
227 */
228 ---------------------------------------------------------------------
229 -- PROCEDURE
230 -- get_parent_fund_owner
231 --
232 --
233 -- PURPOSE
234 -- This Procedure will update the status
235 --
236 --
237 -- IN
238 --
239 --
240 -- OUT
241 --
242 -- Used By Activities
243 --
244 -- NOTES
245 --
246 --
247 --
248 -- HISTORY
249 -- 02/20/2001 MUMU PANDE CREATION
250 -- End of Comments
251 --------------------------------------------------------------------
252
253 PROCEDURE get_fund_parent_owner(
254 itemtype IN VARCHAR2
255 ,itemkey IN VARCHAR2
256 ,x_approver_id OUT NOCOPY NUMBER
257 ,x_return_status OUT NOCOPY VARCHAR2);
258 END ozf_fund_approval_pvt;