APPS.M4U_RESP_PROCESS dependencies on CLN_COLL_HIST_HDR

Line 878: FROM cln_coll_hist_hdr

874:
875: BEGIN
876: SELECT owner_role
877: INTO l_owner_role
878: FROM cln_coll_hist_hdr
879: WHERE attribute12 = l_batch_id AND rownum < 2
880: AND xmlg_transaction_type = 'M4U';
881: EXCEPTION
882: WHEN NO_DATA_FOUND THEN

Line 1060: FROM cln_coll_hist_hdr

1056: l_doc_type := 'M4U_' || p_wlq_response_type;
1057:
1058: SELECT collaboration_type
1059: INTO l_coll_type
1060: FROM cln_coll_hist_hdr
1061: WHERE collaboration_id = p_wlq_message_id;
1062:
1063: -- set CLN Dispositon, CLN Coll Status, CLN Message Text, CLN Doc Status
1064:

Line 1225: FROM cln_coll_hist_hdr

1221: -- since same procedure is being used to process RCIR Ack, GTIN Query Ack
1222: -- and diff processing requirement for each of these messages
1223: SELECT collaboration_type
1224: INTO l_coll_type
1225: FROM cln_coll_hist_hdr
1226: WHERE collaboration_id = p_command_unique_id;
1227:
1228: IF (g_debug_Level <= 1) THEN
1229: cln_debug_pub.Add('CLN Collaboration Type retrieved as - ' || l_coll_type, 1);

Line 1476: FROM cln_coll_hist_hdr

1472: l_apc_disposition VARCHAR2(50);
1473:
1474: CURSOR c_clnid_for_batch (p_batch_id VARCHAR) IS
1475: SELECT collaboration_id
1476: FROM cln_coll_hist_hdr
1477: WHERE attribute12 = p_batch_id
1478: AND xmlg_transaction_type = 'M4U';
1479:
1480: BEGIN

Line 1659: FROM cln_coll_hist_hdr

1655:
1656: BEGIN
1657: SELECT owner_role
1658: INTO l_owner_role
1659: FROM cln_coll_hist_hdr
1660: WHERE attribute12 = p_command_unique_id AND rownum < 2
1661: AND xmlg_transaction_type = 'M4U';
1662: EXCEPTION
1663: WHEN NO_DATA_FOUND THEN