DBA Data[Home] [Help]

PACKAGE: APPS.OZF_PRICELIST_APPROVAL_PVT

Source


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;