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