1 PACKAGE m4u_resp_process AUTHID CURRENT_USER AS
2 /* $Header: m4uresps.pls 120.1 2005/10/27 03:34:17 rkrishan noship $ */
3 /*#
4 * This package contains the private helper APIs invoked while processing
5 * UCCnet XML response messages for RCIR, CIN, Worklist query messages.
6 * @rep:scope private
7 * @rep:product CLN
8 * @rep:displayname Response XML message processing APIs.
9 * @rep:category BUSINESS_ENTITY EGO_ITEM
10 */
11 -- Name
12 -- add_error_to_cln_hist
13 -- Purpose
14 -- This generic procedure is used to add error-messages to CLN History
15 -- Arguments
16 -- p_error_code - UCCnet specific error code
17 -- p_error_message - UCCnet generated error description
18 -- p_error_type - 'ERROR',(haven't seen anything else)
19 -- p_collab_detail_id - collaboration-history detail id to be updated
20 -- p_ucc_doc_unique_id - uccnet generated document identifer for inbound payload
21 -- p_xmlg_internal_control_no - XMLG ICN for debug purpose only
22 -- x_return_status - return_status (S-Success/F-failure)
23 -- x_msg_data - return message (if any)
24 -- Notes
25 -- Adds error-information to collaboration history detail messages
26 /*#
27 * This procedure is called to add error-messages parsed from UCCnet XML reponses to the collaboration history.
28 * @param p_error_code UCCnet supplied error code.
29 * @param p_error_type UCCnet supplied error string.
30 * @param p_error_message UCCnet description of the error.
31 * @param p_collab_detail_id Collaboration detail-id to be updated with error.
32 * @param p_ucc_doc_unique_id UCCnet document identifier for response.
33 * @param p_xmlg_internal_control_no XMLG Internal Control Number
34 * @param x_return_status Return status of API call
35 * @param x_msg_data Return message of API call
36 * @rep:displayname Adds error messages to collaboration history
37 * @rep:scope private
38 * @rep:lifecycle active
39 */
40 PROCEDURE add_error_to_cln_hist(
41 p_error_code IN VARCHAR2,
42 p_error_type IN VARCHAR2,
43 p_error_message IN VARCHAR2,
44 p_collab_detail_id IN VARCHAR2,
45 p_ucc_doc_unique_id IN VARCHAR2,
46 p_xmlg_internal_control_no IN VARCHAR2,
47 x_return_status OUT NOCOPY VARCHAR2,
48 x_msg_data OUT NOCOPY VARCHAR2 );
49
50 -- Name
51 -- process_cic_notification
52 -- Purpose
53 -- This process is called for each CIC notification received from a Retailer(in worklist query response)
54 -- The Worklist-Query of the type/topic CatalogueItemConfirmation/RoutedDocument
55 -- contains CIC notifications issued by retailers
56 -- The ego_uccnet_events table, and CLN Collaboration need to be updated
57 -- When the catalogueItemConfirmationState is "REJECTED|SYNCHRONIZED" an event needs to be
58 -- raised to move the item-publication WF which is blocked at this stage.
59 -- Arguments
60 -- p_gtin => GTIN of item notified
61 -- p_supp_gln => Supplier GLN
62 -- p_target_market => Code of target market
63 -- p_retailer_gln => GLN of ratiler to whom notification is sent
64 -- p_cic_unique_id => Unique creator ID of CIC document generated by reatiler
65 -- p_cic_state => State of CIC notification
66 -- p_cin_unique_id => Unique creator of CIN for which this CIC was generated
67 -- p_ucc_doc_unique_id => Unique document identifier of wLQ response generated by UCCnet
68 -- p_xmlg_internal_colntrol_no => XMLG internal control no. from map
69 -- x_return_status => Collaboration history detail-id, to be used for further processing
70 -- x_return_status => return_status (s-Success/F-failure)
71 -- x_msg_data => return message
72 -- Notes
73 -- (GTIN + Supplier GLN + Target Code) identify a unique item registered in the UCCnet registry.
74 -- p_cin_unique_id = CLN Id for collaboration of outbound document
75 /*#
76 * This procedure is called for each CIC Catalog Item Confirmation - notification
77 * received from a retailer as part of worklist query response.
78 * The procedure updates EGO Item APIs and collaboration history tables with the details parsed from the payloads.
79 * A notification is issued to the document owner with the CIC details.
80 * @param p_gtin GTIN corresponding to CIN
81 * @param p_supp_gln GLN of supplier
82 * @param p_target_market Target market of supplier
83 * @param p_retailer_gln GLN of retailer
84 * @param p_cic_unique_id Unique CIC identifier
85 * @param p_cic_state CIC status sent by retailer.
86 * @param p_cin_unique_id CIN unique identifier.
87 * @param p_ucc_doc_unique_id UCC docuemnt unique Identifier
88 * @param p_xmlg_internal_control_no XMLG internal control number
89 * @param x_collab_detail_id Collaboraction detail returned by update collaboration call.
90 * @param x_return_status API return status
91 * @param x_msg_data API return message.
92 * @rep:scope private
93 * @rep:lifecycle active
94 * @rep:displayname Processes Catalogue Item Confirmation (CIC), notifications
95 */
96 PROCEDURE process_cic_notification(
97 p_gtin IN VARCHAR2,
98 p_supp_gln IN VARCHAR2,
99 p_target_market IN vARCHAR2,
100 p_retailer_gln IN VARCHAR2,
101 p_cic_unique_id IN VARCHAR2,
102 p_cic_state IN VARCHAR2,
103 p_cin_unique_id IN VARCHAR2,
104 p_ucc_doc_unique_id IN VARCHAR2,
105 p_xmlg_internal_control_no IN NUMBER,
106 x_collab_detail_id OUT NOCOPY NUMBER,
107 x_return_status OUT NOCOPY VARCHAR2,
108 x_msg_data OUT NOCOPY VARCHAR2 );
109
110
111 -- Name
112 -- process_cic_additional_info
113 -- Purpose
114 -- This process is called to cater for additional attributes obtained in
115 -- CIC notification received from a Retailer(in worklist query response)
116 /*#
117 * This procedure is called to cater for the additional information
118 * in each CIC Catalog Item Confirmation - notification received from a
119 * retailer as part of worklist query response.
120 * The procedure updates EGO Item APIs and collaboration history tables
121 * with the details parsed from the payloads.
122 * @param p_cln_id Collaboration ID
123 * @param p_cic_code CIC code sent from the customer
124 * @param p_cic_description Code description
125 * @param p_cic_action_needed Action Required
126 * @param p_collab_detail_id Collaboration detail ID
127 * @param x_return_status API return status
128 * @param x_msg_data API return message.
129 * @rep:scope private
130 * @rep:lifecycle active
131 * @rep:displayname Processes Catalogue Item Confirmation (CIC), notifications
132 */
133
134 PROCEDURE process_cic_additional_info(
135 p_cln_id IN NUMBER,
136 p_cic_code IN VARCHAR2,
137 p_cic_description IN VARCHAR2,
138 p_cic_action_needed IN VARCHAR2,
139 p_collab_detail_id IN NUMBER,
140 x_return_status OUT NOCOPY VARCHAR2,
141 x_msg_data OUT NOCOPY VARCHAR2 );
142
143
144 -- process_cic_trade_item
145 -- Purpose
146 -- This process is called if the optional trade-item information is sent along with the CIC document
147 -- The Worklist-Query of the type/topic CatalogueItemConfirmation/RoutedDocument
148 -- contains CIC notifications issued by retailers
149 -- No processing is defined for this, dummy procedure call
150 -- Arguments
151 -- p_gtin => GTIN of item received as part of CIC
152 -- p_supp_gln => Supplier GLN of item received as part of CIC
153 -- p_target_market => Target market code of item received as part of CIC
154 -- p_reailter_gln => GLN of retailer who generated the CIC
155 -- p_cic_unique_id => uniquecreatorID of CIC document
156 -- p_cic_state => State of CIC
157 -- p_cin_unique_id => uniqueCreatorId of CIN for which this CIC is generated
158 -- p_ucc_doc_unique_id => uniqueCreatorId of UCCnet generated WLQ response
159 -- p_xmlg_internal_colntrol_no => XMLG map ICN
160 -- x_collab_detail_id => Collaboration history detail-id, to be used for further processing
161 -- x_return_status => return_status (s-Success/F-failure)
162 -- x_msg_data => return message
163 -- Notes
164 -- (GTIN + Supplier GLN + Target Code) identify a unique item registered in the UCCnet registry.
165 PROCEDURE process_cic_trade_item(
166 p_gtin IN VARCHAR2,
167 p_supp_gln IN VARCHAR2,
168 p_target_market IN vARCHAR2,
169 p_retailer_gln IN VARCHAR2,
170 p_cic_unique_id IN VARCHAR2,
171 p_cic_state IN VARCHAR2,
172 p_cin_unique_id IN VARCHAR2,
173 p_ucc_doc_unique_id IN VARCHAR2,
174 p_xmlg_internal_control_no IN NUMBER,
175 x_collab_detail_id OUT NOCOPY NUMBER,
176 x_return_status OUT NOCOPY VARCHAR2,
177 x_msg_data OUT NOCOPY VARCHAR2 );
178
179 -- Name
180 -- process_rcir_notification
181 -- Purpose
182 -- This process is called for each RCIR command in a transaction batch.
183 -- The Worklist-query response contains status of each of the RCIR command
184 -- The ego_uccnet_events table, and CLN Collaboration need to be updated
185 -- The Collaboration Detail Id is an out parameter, to be used subsequently for updating error messsages.
186 -- Arguments
187 -- p_gtin => The GTIN of the Item published in the Batch
188 -- p_supp_gln => Unique GLN of Supplier
189 -- p_target_market => target market to which the item is to be published
190 -- p_rcir_batch_id => The Batch_Id of the Batch in which the RCIR command was sent
191 -- p_rcir_command_success => TRUE/FALSE flag, indicates if Item-Registration was successful
192 -- p_rcir_command_unique_id => Unique Creartor Id of RCIR command (command level)
193 -- p_rcir_command_validation_key => Unique validation key, received for successful registration.
194 -- p_ucc_doc_unique_id => Unique UCCnet generated identifier for the document
195 -- p_xmlg_internal_control_no => XMLG Generated Unique Id for Document
196 -- x_collab_detail_id => The collab_detail_id returned by CLN Update CH API call.
197 -- x_return_status => return_status (s-Success/F-failure)
198 -- x_msg_data => return message
199 -- Notes
200 -- (GTIN + Supplier GLN + Target Code) identify a unique item registered in the UCCnet registry.
201 /*#
202 * This procedure is called to update EGO Item APIs and collaboration history tables
203 * for each RCIR notification in a transaction batch.
204 * @param p_gtin GTIN of RCIR command
205 * @param p_supp_gln GLN of RCIR command
206 * @param p_target_market Target market of RCIR command
207 * @param p_rcir_batch_id Batch of RCIR command
208 * @param p_rcir_command_unique_id RCIR command identifier
209 * @param p_rcir_command_success RCIR command success/failur response
210 * @param p_rcir_command_validation_key RCIR command validaition key
211 * @param p_ucc_doc_unique_id XML response document unique identifier
212 * @param p_xmlg_internal_control_no XMLG internal control number
213 * @param x_collab_detail_id Returned collaboration detail id
214 * @param x_return_status API return status
215 * @param x_msg_data API return message
216 * @rep:scope private
217 * @rep:lifecycle active
218 * @rep:displayname Processes RCIR notifications.
219 */
220
221 PROCEDURE process_rcir_notification(
222 p_gtin IN VARCHAR2,
223 p_supp_gln IN VARCHAR2,
224 p_target_market IN VARCHAR2,
225 p_rcir_batch_id IN VARCHAR2,
226 p_rcir_command_unique_id IN VARCHAR2,
227 p_rcir_command_success IN VARCHAR2,
228 p_rcir_command_validation_key IN VARCHAR2,
229 p_ucc_doc_unique_id IN VARCHAR2,
230 p_xmlg_internal_control_no IN NUMBER,
231 x_collab_detail_id OUT NOCOPY NUMBER,
232 x_return_status OUT NOCOPY VARCHAR2,
233 x_msg_data OUT NOCOPY VARCHAR2 );
234
235 -- Name
236 -- process_rcir_batch_list
240 -- Arguments
237 -- Purpose
238 -- process all RCIR-BATCHes received in a Worlist-query Batch Notification reponse
239 -- raise event, for each batch-id to move corresponding WF block
241 -- p_rcir_batch_id_list => distinct RCIR batch_ids which have been processed
242 -- are concatenated into a string, delimited by ':' string.
243 -- p_rcir_batch_count => Count of number of Batch_ids in the above string
244 -- p_ucc_doc_unique_id => unique UCCnet generated document identifer
245 -- p_xmlg_internal_control_no => XML Gateway generated Internal Control Number for document
246 -- x_return_status => return_status (s-Success/F-failure)
247 -- x_msg_data => return message
248 -- Notes
249 -- Sample input to this procedure would be
250 -- p_rcir_batch_id_list - rcir1:rcir2:rcir3:
251 -- p_rcir_batch_count - 3
252 /*#
253 * A notifcation is issued to the RCIR-Batch document owner with the status of invididual RCIR commands in the batch.
254 * @param p_rcir_batch_id_list List of RCIR Batch ids
255 * @param p_rcir_batch_count Count of RCIR Batch ids in the list
256 * @param p_ucc_doc_unique_id RCIR Batch response document unique id
257 * @param p_xmlg_internal_control_no XMLG Internal control number
258 * @param x_return_status API return status
259 * @param x_msg_data API return message
260 * @rep:scope private
261 * @rep:lifecycle active
262 * @rep:displayname Raises notifcation with RCIR Batch information.
263 */
264 PROCEDURE process_rcir_batch_list(
265 p_rcir_batch_id_list VARCHAR2,
266 p_rcir_batch_count NUMBER,
267 p_ucc_doc_unique_id VARCHAR2,
268 p_xmlg_internal_control_no VARCHAR2,
269 x_return_status OUT NOCOPY VARCHAR2,
270 x_msg_data OUT NOCOPY VARCHAR2 );
271
272
273 -- Name
274 -- process_wlq_response
275 -- Purpose
276 -- This process is called after a worklist query response document processed
277 -- This is done to update the CLN collaboration corresponding to the WLQ send
278 -- Arguments
279 -- p_wlq_message_id => Used as CLN_Id for the WLQ Collaboration
280 -- p_wlq_success_flag => TRUE/FALSE flag, correspond to WLQ, generally true.
281 -- p_ucc_unique_id => Unique document identifer for payload, from UCC
282 -- p_xmlg_internal_control_no => XMLG generated Unique Id for inbound document
283 -- x_collab_detail_id => collaboration history detail id
284 -- x_return_status => return_status (s-Success/F-failure)
285 -- x_msg_data => return message
286 -- Notes
287 -- No specific notes.
288 /*#
289 * This procedure is invoked to update collaboration history tables for each worklist query response.
290 * @param p_wlq_message_id Worklist-query message id
291 * @param p_wlq_success_flag Worklist-queury success/failure response indicator
292 * @param p_wlq_response_type Query response type
293 * @param p_ucc_doc_unique_id UCCnet response document id
294 * @param p_xmlg_internal_control_no XMLG Internal control number
295 * @param x_collab_detail_id Worklist query collaboration detail id
296 * @param x_return_status API return status.
297 * @param x_msg_data API return message
298 * @rep:scope private
299 * @rep:lifecycle active
300 * @rep:displayname Updates collaboration history tables with worklist query response information.
301 */
302 PROCEDURE process_wlq_response(
303 p_wlq_message_id IN VARCHAR2,
304 p_wlq_success_flag IN VARCHAR2,
305 p_wlq_response_type IN VARCHAR2,
306 p_ucc_doc_unique_id IN VARCHAR2,
307 p_xmlg_internal_control_no IN VARCHAR2,
308 x_collab_detail_id OUT NOCOPY NUMBER,
309 x_return_status OUT NOCOPY VARCHAR2,
310 x_msg_data OUT NOCOPY VARCHAR2 );
311
312 -- Name
313 -- process_rcir_ack
314 -- Purpose
315 -- This process is called processing the synchronous Ack received from UCCnet for RCIR messages
316 -- The CLN Collaboration is updated with the response, and event is raised to move WF block*
317 -- There is no need for this now.
318 -- Arguments
319 -- p_ack_type => Used as CLN_Id for the WLQ Collaboration
320 -- p_command_unique_id => Unique id of command for which response is received
321 -- p_command_success => Success/failure flag of command for which response is received
322 -- p_command_validation_key => validation key if command is succesfully processed
323 -- p_xmlg_internal_control_no => XMLG generated Unique Id for inbound document
327 -- x_msg_data => return message
324 -- p_ucc_doc_unique_id => UCCnet generated UniqueId for response
325 -- x_collab_detail_id => collab deatil-id to be returned to map
326 -- x_return_status => return_status (s-Success/F-failure)
328 -- Notes
329 -- No specific notes.
330 /*#
331 * This procedure is called to process synchronous acknowledgements received for RCIR messages.
332 * It updates collaboration history and EGO Item APIs with RCIR command status
333 * and raises a notification to the document owner.
334 * @param p_gtin RCIR GTIN message
335 * @param p_supp_gln RCIR supplier GLN
336 * @param p_target_market RCIR target market
337 * @param p_command_unique_id RCIR Command unique id.
338 * @param p_command_success IN RCIR command sucess/failure response.
339 * @param p_command_validation_key RCIR command validation key.
340 * @param p_ucc_doc_unique_id RCIR command unique identifier
341 * @param p_xmlg_internal_control_no RCIR internal control number
342 * @param x_collab_detail_id RCIR collaboraton detail id
343 * @param x_return_status API return status
344 * @param x_msg_data API return message
345 * @rep:scope private
346 * @rep:lifecycle active
347 * @rep:displayname Processes synchronous acknowledgement response for RCIR messages
348 */
349 PROCEDURE process_rcir_ack(
350 p_gtin IN VARCHAR2,
351 p_supp_gln IN VARCHAR2,
352 p_target_market IN VARCHAR2,
353 p_command_unique_id IN VARCHAR2,
354 p_command_success IN VARCHAR2,
355 p_command_validation_key IN VARCHAR2,
356 p_ucc_doc_unique_id IN VARCHAR2,
357 p_xmlg_internal_control_no IN NUMBER,
358 x_collab_detail_id OUT NOCOPY NUMBER,
359 x_return_status OUT NOCOPY VARCHAR2,
360 x_msg_data OUT NOCOPY VARCHAR2 );
361
362 -- Name
363 -- process_rcir_batch_ack
364 -- Purpose
365 -- This is used to process the RCIR Batch message
366 -- In case of success, the individual RCIR collaborations are updated (status set to initiated)
367 -- **In case of failure, the business event is raised to move WF block**
368 -- Removing this as this is not required.
369 -- Arguments
370 -- p_command_unique_id => Unique id of batch
371 -- p_supp_gln => unique GLN of supplier
372 -- p_command_success => Success/failure flag of command for which response is received
373 -- p_ucc_doc_unique_id => UCCnet generated UniqueId for response
374 -- p_xmlg_internal_control_no => XMLG generated Unique Id for inbound document
375 -- x_collab_detail_id => collab deatil-id to be returned to map
376 -- x_return_status => return_status (s-Success/F-failure)
377 -- x_msg_data => return message
378 -- Notes
379 -- No specific notes.
380 /*#
381 * This Procedure is called to process asynchronous batch notifications received for RCIR comand batch messages.
382 * It updates the collaboration history and updates the EGO Item APIs in case the RCIR batch is rejected by UCCnet.
383 * It also raises a notification to the document owner.
384 * @param p_command_unique_id RCIR Batch command id
385 * @param p_supp_gln RCIR batch supplier GLN
386 * @param p_command_success RCIR command success
387 * @param p_ucc_doc_unique_id RCIR batch response document id
388 * @param p_xmlg_internal_control_no XMLG internal control number
389 * @param x_collab_detail_id Returned collaboration detail id.
390 * @param x_return_status API return status.
391 * @param x_msg_data API return message
392 * @rep:scope private
393 * @rep:lifecycle active
394 * @rep:displayname Procedure to process synchronous RCIR batch acknowledgement messages.
395 */
396 PROCEDURE process_rcir_batch_ack(
397 p_command_unique_id IN VARCHAR2,
398 p_supp_gln IN VARCHAR2,
399 p_command_success IN VARCHAR2,
400 p_ucc_doc_unique_id IN VARCHAR2,
401 p_xmlg_internal_control_no IN NUMBER,
402 x_collab_detail_id OUT NOCOPY NUMBER,
403 x_return_status OUT NOCOPY VARCHAR2,
404 x_msg_data OUT NOCOPY VARCHAR2 );
405
406 -- Name
407 -- process_cin_ack
408 -- Purpose
409 -- This process is called for processing the synchronous acknowledgement received from UCCnet for CIN messages
410 -- The CLN collaboration, ego_uccnet_events table are updated with the response
411 -- A CLN notification event is raised
412 -- Arguments
416 -- p_command_validation_key => validation key if command is succesfully processed
413 -- p_command_unique_id => Unique id of command for which response is received
414 -- p_supp_gln => datasource/gln of document originator
415 -- p_command_success => Success/failure flag of command for which response is received
417 -- p_ucc_doc_unique_id => UCCnet generated UniqueId for response document
418 -- p_xmlg_internal_control_no => XMLG generated Unique Id for inbound document
419 -- x_collab_detail_id => collab deatil-id to be returned to map
420 -- x_return_status => return_status (S-Success/F-failure)
421 -- x_msg_data => return message
422 -- Notes
423 -- No specific notes.
424 /*#
425 * This procedure is called to process synchronous acknowledgement received from UCCnet for Catalog Item Notification - messages.
426 * It updates the collaboration history and the EGO Item API with the response information.
427 * It sends a notification to the document owner with this information.
428 * @param p_command_unique_id CIN command unique identifier.
429 * @param p_supp_gln CIN supplier GLN.
430 * @param p_command_success CIN success/failure indicator.
431 * @param p_command_validation_key CIN command validation key.
432 * @param p_ucc_doc_unique_id CIN response document unique identifier.
433 * @param p_xmlg_internal_control_no CIN Internal control number.
434 * @param x_collab_detail_id Collab detail id, returned from API call.
435 * @param x_return_status API call return status.
436 * @param x_msg_data API message data.
437 * @rep:scope private
438 * @rep:lifecycle active
439 * @rep:displayname Processes synchronous CIN acknowledgement message received from UCCnet.
440 */
441 PROCEDURE process_cin_ack(
442 p_command_unique_id IN VARCHAR2,
443 p_supp_gln IN VARCHAR2,
444 p_command_success IN VARCHAR2,
445 p_command_validation_key IN VARCHAR2,
446 p_ucc_doc_unique_id IN VARCHAR2,
447 p_xmlg_internal_control_no IN NUMBER,
448 x_collab_detail_id OUT NOCOPY NUMBER,
449 x_return_status OUT NOCOPY VARCHAR2,
450 x_msg_data OUT NOCOPY VARCHAR2 );
451
452 -- Name
453 -- process_rfcin_ack
454 -- Purpose
455 -- This process is called for processing the "Request For Catalogue Item Notification" notifiacation
456 -- from UCCnet. These notifications are recived as part of Worklistquery Responses where the
457 -- filter in the Query is name = "REQUEST_FOR_NOTIFICATION".
458 -- A CLN collaboration is to be created for this messsage.
459 -- A CLN Notification is to be raised on for each of these responses received.
460 -- Arguments
461 -- p_wlq_message_id => Unique identifier Worklist-query for which this notification is received as response
462 -- p_target_market_country => Retailer wants notification for item(s) of this target market
463 -- p_target_market_subdivision => Retailer wants notification for item(s) of this target market sub division
464 -- p_gtin => Retailer wants notification for this specific GTIN
465 -- p_data_recipient => GLN of (this) supplier
466 -- p_data_source => Datasoure
467 -- p_recipient_data_pool => Datapool of recipient
468 -- p_classification_category => Retailer wants notification for items of this Category
469 -- p_rfcin_unique_id => unique command level id of RFCIN command
470 -- p_rfcin_owner_gln => GLN of retailer who issued this command
471 -- p_reload_flag => flag specifies whether retailer wants new GTIN or reload exisiting data
472 -- p_ucc_doc_unique_id => unique id of UCCnet message(worklist query response)
473 -- p_xmlg_internal_control_no => XMLG generated internal control number
474 -- x_return_status => out param. ret status from CLN API call
475 -- x_msg_data => out param. ret message from CLN API call
476 -- Notes
477 -- No specific notes.
478 /*#
479 * This procedure is called to process Request for Catalog Item Notifications (RFCIN) received from UCCnet, as part of worklist query responses.
480 * It updates collaboration history and raises a notification to the CLN_ADMINISTRATOR with details of the RFCIN parsed from the payload.
481 * @param p_wlq_message_id Worklistquery identifier
482 * @param p_target_market_country RFCIN target market
483 * @param p_target_market_subdivision RFCIN target subdivision
484 * @param p_gtin IN RFCIN GTIN attribute
485 * @param p_data_recipient Data recepient GLN for RFCIN request
486 * @param p_data_source Data source of GTIN
487 * @param p_recipient_data_pool Data recepient of RFCIN
488 * @param p_classification_category RFCIN - GTIN categroy
489 * @param p_rfcin_unique_id RFCIN command identifier
490 * @param p_rfcin_owner_gln RFCIN owner gln
491 * @param p_reload_flag RFCIN reload flag
492 * @param p_rfcin_creation_date RFCIN creation date.
493 * @param p_ucc_doc_unique_id Document unique identifier
494 * @param p_xmlg_internal_control_no XMLG Internal control number
495 * @param x_return_status API return status
496 * @param x_msg_data API return message
497 * @rep:scope private
498 * @rep:lifecycle active
499 * @rep:displayname Processes RFCIN notifications received for the supplier.
500 */
501 PROCEDURE process_rfcin_notification(
502 p_wlq_message_id IN VARCHAR2,
503 p_target_market_country IN VARCHAR2,
504 p_target_market_subdivision IN VARCHAR2,
505 p_gtin IN VARCHAR2,
506 p_data_recipient IN VARCHAR2,
507 p_data_source IN VARCHAR2,
508 p_recipient_data_pool IN VARCHAR2,
509 p_classification_category IN VARCHAR2,
510 p_rfcin_unique_id IN VARCHAR2,
511 p_rfcin_owner_gln IN VARCHAR2,
512 p_reload_flag IN VARCHAR2,
513 p_rfcin_creation_date IN VARCHAR2,
514 p_ucc_doc_unique_id IN VARCHAR2,
515 p_xmlg_internal_control_no IN NUMBER,
516 x_return_status OUT NOCOPY VARCHAR2,
517 x_msg_data OUT NOCOPY VARCHAR2 );
518 END m4u_resp_process;