[Home] [Help]
PACKAGE: APPS.OZF_OFFERADJ_APPROVAL_PVT
Source
1 PACKAGE ozf_offeradj_approval_pvt AUTHID CURRENT_USER AS
2 /* $Header: ozfvoaws.pls 120.0 2005/06/01 01:47:52 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 ---------------------------------------------------------------------
134 -- PROCEDURE
135 -- Set_OFFRADJ_Activity_details
136 --
137 --
138 -- PURPOSE
139 -- This Procedure will set all the item attribute details
140 --
141 --
142 -- IN
143 --
144 --
145 -- OUT
146 --
147 -- Used By Activities
148 --
149 -- NOTES
150 --
151 --
152 --
153 -- HISTORY
154 -- 02/20/2001 MUMU PANDE CREATION
155 -- End of Comments
156 --------------------------------------------------------------------
157
158 PROCEDURE set_OFFRADJ_activity_details(
159 itemtype IN VARCHAR2
160 ,itemkey IN VARCHAR2
161 ,actid IN NUMBER
162 ,funcmode IN VARCHAR2
163 ,resultout OUT NOCOPY VARCHAR2);
164
165 ---------------------------------------------------------------------
166 -- PROCEDURE
167 -- Update_OFFRADJ_Statas
168 --
169 --
170 -- PURPOSE
171 -- This Procedure will update the status of the object to active
172 --
173 --
174 -- IN
175 --
176 --
177 -- OUT
178 --
179 -- Used By Activities
180 --
181 -- NOTES
182 --
183 --
184 --
185 -- HISTORY
186 -- 02/20/2001 MUMU PANDE CREATION
187 -- End of Comments
188 --------------------------------------------------------------------
189
190
191 PROCEDURE Update_OffrAdj_status(
192 itemtype IN VARCHAR2
193 ,itemkey IN VARCHAR2
194 ,actid IN NUMBER
195 ,funcmode IN VARCHAR2
196 ,resultout OUT NOCOPY VARCHAR2);
197
198
199 END ozf_offeradj_approval_pvt;