1 PACKAGE PON_BIZ_EVENTS_PVT AS
2 --$Header: PONVEVTS.pls 120.0 2005/06/01 13:34:11 appldev noship $
3
4
5
6 -- Start of comments
7 -- API name : RAISE_NEG_PUB_EVENT
8 -- Type : Private
9 -- Pre-reqs : Negotiation with the given auction_header_id
10 -- (p_auction_header_id) must exists in the database
11 -- Function : Calls Workflow API to raise a Business Event for Negotiation
12 -- publication event for the given auction_header_id (p_auction_header_id)
13 -- Modifies : None
14 -- Locks : None
15 --
16 -- Parameters:
17 -- IN : p_api_version NUMBER Required
18 -- IN p_init_msg_list VARCHAR2 DEFAULT FND_API.G_FALSE Optional
19 -- IN : p_commit VARCHAR2 DEFAULT FND_API.G_FALSE Optional
20 -- IN : p_auction_header_id NUMBER Required, auction_header_id
21 -- of the negotiation published
22 -- OUT : x_return_status VARCHAR2, flag to indicate if the procedure
23 -- was successful or not; It can have
24 -- following values -
25 -- FND_API.G_RET_STS_SUCCESS (Success)
26 -- FND_API.G_RET_STS_ERROR (Failed due to error)
27 -- OUT : x_msg_count NUMBER, the number of warning of error messages due
28 -- to this procedure call. It will have following
29 -- values -
30 -- 0 (for Success without warning)
31 -- 1 or more (for Error(s)/Warning(s)
32 -- OUT : x_msg_data VARCHAR2, the standard message data output parameter
33 -- used to return the first message of the stack
34 -- Version : Current version 1.0
35 -- Previous version 1.0
36 -- Initial version 1.0
37 --
38 -- End of comments
39
40
41 PROCEDURE RAISE_NEG_PUB_EVENT
42 (
43 p_api_version IN NUMBER,
44 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
45 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE ,
46 p_auction_header_id IN NUMBER,
47 x_return_status IN OUT NOCOPY VARCHAR2,
48 x_msg_count IN OUT NOCOPY NUMBER,
49 x_msg_data IN OUT NOCOPY VARCHAR2
50 );
51
52 -- Start of comments
53 -- API name : RAISE_RESPNSE_PUB_EVENT
54 -- Type : Private
55 -- Pre-reqs : Response with the given bid_number
56 -- (p_bid_number) must exists in the database
57 -- Function : Calls Workflow API to raise a Business Event for Response
58 -- publication event for the
59 -- given bid_number (p_bid_number)
60 -- Modifies : None
61 -- Locks : None
62 --
63 -- Parameters:
64 -- IN : p_api_version NUMBER Required
65 -- IN p_init_msg_list VARCHAR2 DEFAULT FND_API.G_FALSE Optional
66 -- IN : p_commit VARCHAR2 DEFAULT FND_API.G_FALSE Optional
67 -- IN : p_bid_number NUMBER Required, bid_number
68 -- of the Response published
69 -- OUT : x_return_status VARCHAR2, flag to indicate if the procedure
70 -- was successful or not; It can have
71 -- following values -
72 -- FND_API.G_RET_STS_SUCCESS (Success)
73 -- FND_API.G_RET_STS_ERROR (Failed due to error)
74 -- OUT : x_msg_count NUMBER, the number of warning of error messages due
75 -- to this procedure call. It will have following
76 -- values -
77 -- 0 (for Success without warning)
78 -- 1 or more (for Error(s)/Warning(s)
79 -- OUT : x_msg_data VARCHAR2, the standard message data output parameter
80 -- used to return the first message of the stack
81 -- Version : Current version 1.0
82 -- Previous version 1.0
83 -- Initial version 1.0
84 --
85 -- End of comments
86
87
88 PROCEDURE RAISE_RESPNSE_PUB_EVENT
89 ( p_api_version IN NUMBER,
90 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
91 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE ,
92 p_bid_number IN NUMBER,
93 x_return_status IN OUT NOCOPY VARCHAR2,
94 x_msg_count IN OUT NOCOPY NUMBER,
95 x_msg_data IN OUT NOCOPY VARCHAR2
96 );
97
98 -- Start of comments
99 -- API name : RAISE_RESPNSE_DISQ_EVENT
100 -- Type : Private
101 -- Pre-reqs : Response with the given bid_number
102 -- (p_bid_number) must exists in the database
103 -- Function : Calls Workflow API to raise a Business Event for Disqualification
104 -- of Response event for the given bid_number (p_bid_number)
105 -- Modifies : None
106 -- Locks : None
107 --
108 -- Parameters:
109 -- IN : p_api_version NUMBER Required
110 -- IN p_init_msg_list VARCHAR2 DEFAULT FND_API.G_FALSE Optional
111 -- IN : p_commit VARCHAR2 DEFAULT FND_API.G_FALSE Optional
112 -- IN : p_bid_number NUMBER Required, bid_number
113 -- of the Response published
114 -- OUT : x_return_status VARCHAR2, flag to indicate if the procedure
115 -- was successful or not; It can have
116 -- following values -
117 -- FND_API.G_RET_STS_SUCCESS (Success)
118 -- FND_API.G_RET_STS_ERROR (Failed due to error)
119 -- OUT : x_msg_count NUMBER, the number of warning of error messages due
120 -- to this procedure call. It will have following
121 -- values -
125 -- used to return the first message of the stack
122 -- 0 (for Success without warning)
123 -- 1 or more (for Error(s)/Warning(s)
124 -- OUT : x_msg_data VARCHAR2, the standard message data output parameter
126 -- Version : Current version 1.0
127 -- Previous version 1.0
128 -- Initial version 1.0
129 --
130 -- End of comments
131
132
133 PROCEDURE RAISE_RESPNSE_DISQ_EVENT
134 (
135 p_api_version IN NUMBER,
136 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
137 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE ,
138 p_bid_number IN NUMBER,
139 x_return_status IN OUT NOCOPY VARCHAR2,
140 x_msg_count IN OUT NOCOPY NUMBER,
141 x_msg_data IN OUT NOCOPY VARCHAR2
142 );
143
144 -- Start of comments
145 -- API name : RAISE_NEG_AWD_APPR_STRT_EVENT
146 -- Type : Private
147 -- Pre-reqs : Negotiation with the given auction_header_id
148 -- (p_auction_header_id) must exists in the database
149 -- Function : Calls Workflow API to raise a Business Event for Submission
150 -- of Award Approval event for the given auction_header_id (p_auction_header_id)
151 -- Modifies : None
152 -- Locks : None
153 --
154 -- Parameters:
155 -- IN : p_api_version NUMBER Required
156 -- IN p_init_msg_list VARCHAR2 DEFAULT FND_API.G_FALSE Optional
157 -- IN : p_commit VARCHAR2 DEFAULT FND_API.G_FALSE Optional
158 -- IN : p_auction_header_id NUMBER Required, p_auction_header_id
159 -- of the Negotiation submitted
160 -- OUT : x_return_status VARCHAR2, flag to indicate if the procedure
161 -- was successful or not; It can have
162 -- following values -
166 -- to this procedure call. It will have following
163 -- FND_API.G_RET_STS_SUCCESS (Success)
164 -- FND_API.G_RET_STS_ERROR (Failed due to error)
165 -- OUT : x_msg_count NUMBER, the number of warning of error messages due
167 -- values -
168 -- 0 (for Success without warning)
169 -- 1 or more (for Error(s)/Warning(s)
170 -- OUT : x_msg_data VARCHAR2, the standard message data output parameter
171 -- used to return the first message of the stack
172 -- Version : Current version 1.0
173 -- Previous version 1.0
174 -- Initial version 1.0
175 --
176 -- End of comments
177
178
179 PROCEDURE RAISE_NEG_AWD_APPR_STRT_EVENT
180 (
181 p_api_version IN NUMBER,
182 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
183 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE ,
184 p_auction_header_id IN NUMBER,
185 x_return_status IN OUT NOCOPY VARCHAR2,
186 x_msg_count IN OUT NOCOPY NUMBER,
187 x_msg_data IN OUT NOCOPY VARCHAR2
188 );
189
190
191 -- Start of comments
192 -- API name : RAISE_NEG_AWRD_COMPLETE_EVENT
193 -- Type : Private
194 -- Pre-reqs : Negotiation with the given auction_header_id
195 -- (p_auction_header_id) must exists in the database
196 -- Function : Calls Workflow API to raise a Business Event for Completion
197 -- of Award event for the given auction_header_id (p_auction_header_id)
198 -- Modifies : None
199 -- Locks : None
200 --
201 -- Parameters:
202 -- IN : p_api_version NUMBER Required
203 -- IN p_init_msg_list VARCHAR2 DEFAULT FND_API.G_FALSE Optional
204 -- IN : p_commit VARCHAR2 DEFAULT FND_API.G_FALSE Optional
205 -- IN : p_auction_header_id NUMBER Required, p_auction_header_id
206 -- of the Negotiation completed
207
208 -- IN : p_create_po_flag VARCHAR2 Required, Flag to indicate if user has selected
209 -- create PO option while completing the given Negotiation
210 -- OUT : x_return_status VARCHAR2, flag to indicate if the procedure
211 -- was successful or not; It can have
212 -- following values -
213 -- FND_API.G_RET_STS_SUCCESS (Success)
214 -- FND_API.G_RET_STS_ERROR (Failed due to error)
215 -- OUT : x_msg_count NUMBER, the number of warning of error messages due
216 -- to this procedure call. It will have following
217 -- values -
218 -- 0 (for Success without warning)
219 -- 1 or more (for Error(s)/Warning(s)
220 -- OUT : x_msg_data VARCHAR2, the standard message data output parameter
221 -- used to return the first message of the stack
222 -- Version : Current version 1.0
223 -- Previous version 1.0
224 -- Initial version 1.0
225 --
226 -- End of comments
227
228
229 PROCEDURE RAISE_NEG_AWRD_COMPLETE_EVENT
230 (
231 p_api_version IN NUMBER,
232 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
233 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE ,
234 p_auction_header_id IN NUMBER,
235 p_create_po_flag IN VARCHAR2,
236 x_return_status IN OUT NOCOPY VARCHAR2,
237 x_msg_count IN OUT NOCOPY NUMBER,
238 x_msg_data IN OUT NOCOPY VARCHAR2
239 );
240
241 -- Start of comments
242 -- API name : RAISE_PO_CREATION_INIT_EVENT
243 -- Type : Private
244 -- Pre-reqs : Negotiation with the given auction_header_id
245 -- (p_auction_header_id) must exists in the database
246 -- Function : Calls Workflow API to raise a Business Event for PO Creation
250 --
247 -- initiation event for the given Negotiation (p_auction_header_id)
248 -- Modifies : None
249 -- Locks : None
251 -- Parameters:
252 -- IN : p_api_version NUMBER Required
253 -- IN p_init_msg_list VARCHAR2 DEFAULT FND_API.G_FALSE Optional
254 -- IN : p_commit VARCHAR2 DEFAULT FND_API.G_FALSE Optional
255 -- IN : p_auction_header_id NUMBER Required, p_auction_header_id
256 -- of the Negotiation for which PO creation is started
257 -- IN : p_user_name VARCHAR2 Required, User Name
258 -- of the Negotiation Creator who has initiated PO creation
259 -- IN : p_requisition_based_flag VARCHAR2 Required, Flag to indicate if the
260 -- Negotiation has some backing Requisition(s)
261 -- OUT : x_return_status VARCHAR2, flag to indicate if the procedure
262 -- was successful or not; It can have
263 -- following values -
264 -- FND_API.G_RET_STS_SUCCESS (Success)
265 -- FND_API.G_RET_STS_ERROR (Failed due to error)
266 -- OUT : x_msg_count NUMBER, the number of warning of error messages due
267 -- to this procedure call. It will have following
268 -- values -
269 -- 0 (for Success without warning)
270 -- 1 or more (for Error(s)/Warning(s)
271 -- OUT : x_msg_data VARCHAR2, the standard message data output parameter
275 -- Initial version 1.0
272 -- used to return the first message of the stack
273 -- Version : Current version 1.0
274 -- Previous version 1.0
276 --
277 -- End of comments
278
279 PROCEDURE RAISE_PO_CREATION_INIT_EVENT
280 (
281 p_api_version IN NUMBER,
282 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
283 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE ,
284 p_auction_header_id IN NUMBER,
285 p_user_name IN VARCHAR2,
286 p_requisition_based_flag IN VARCHAR2,
287 x_return_status IN OUT NOCOPY VARCHAR2,
288 x_msg_count IN OUT NOCOPY NUMBER,
289 x_msg_data IN OUT NOCOPY VARCHAR2
290 );
291
292 END PON_BIZ_EVENTS_PVT;