APPS.M4U_RESP_PROCESS dependencies on DUAL

Line 65: SELECT cln_collaboration_msg_id_s.nextval INTO l_event_key FROM dual ;

61:
62: l_error_description := p_error_type || ', ' || p_error_code || ', ' || p_error_message;
63:
64: --create unique key for each event using CLN sequence
65: SELECT cln_collaboration_msg_id_s.nextval INTO l_event_key FROM dual ;
66:
67: IF (g_debug_Level <= 1) THEN
68: cln_debug_pub.Add('Raising Add Message Event ', 1);
69: cln_debug_pub.Add('p_event_key -- ' || l_event_key, 1);

Line 1432: -- In case of success, the individual RCIR collaborations are updated (status set to initiated)

1428: -- Name
1429: -- process_rcir_batch_ack
1430: -- Purpose
1431: -- This is used to process the RCIR Batch message
1432: -- In case of success, the individual RCIR collaborations are updated (status set to initiated)
1433: -- **In case of failure, the business event is raised to move WF block**
1434: -- Removing this as this is not required.
1435: -- Arguments
1436: -- p_command_unique_id => Unique id of batch

Line 1512: -- for every CLN-ID corresponding to individual rcir commands in the batch

1508: l_fnd_msg := 'M4U_RCIR_BATCH_REJECTED';
1509: l_apc_disposition := 'FAILED';
1510: END IF;
1511:
1512: -- for every CLN-ID corresponding to individual rcir commands in the batch
1513: -- 1. update ego_uccnet_table disposition.
1514: -- 2. update CLN Collaboration.
1515: FOR rec_cln_id IN c_clnid_for_batch(p_command_unique_id) LOOP
1516: