APPS.CLN_RESEND dependencies on CLN_COLL_HIST_HDR

Line 47: cln_debug_pub.Add('Before Sql Query - cln_coll_hist_hdr',1);

43: END IF;
44: -- Initialize API return status to success
45: l_msg_data := 'Requested Document successfully sent';
46: IF (l_Debug_Level <= 1) THEN
47: cln_debug_pub.Add('Before Sql Query - cln_coll_hist_hdr',1);
48: END IF;
49: BEGIN
50: SELECT resend_count
51: INTO l_resend_count

Line 52: FROM cln_coll_hist_hdr

48: END IF;
49: BEGIN
50: SELECT resend_count
51: INTO l_resend_count
52: FROM cln_coll_hist_hdr
53: WHERE collaboration_id = p_collaboration_id;
54: IF (l_Debug_Level <= 1) THEN
55: cln_debug_pub.Add('After Sql Query - cln_coll_hist_hdr',1);
56: cln_debug_pub.Add('Resend Count -'||l_resend_count,1);

Line 55: cln_debug_pub.Add('After Sql Query - cln_coll_hist_hdr',1);

51: INTO l_resend_count
52: FROM cln_coll_hist_hdr
53: WHERE collaboration_id = p_collaboration_id;
54: IF (l_Debug_Level <= 1) THEN
55: cln_debug_pub.Add('After Sql Query - cln_coll_hist_hdr',1);
56: cln_debug_pub.Add('Resend Count -'||l_resend_count,1);
57: cln_debug_pub.Add('Before Sql Query - cln_coll_hist_dtl',1);
58: END IF;
59: EXCEPTION