APPS.CLN_CH_COLLABORATION_PKG dependencies on DUAL

Line 877: SELECT cln_collaboration_dtl_id_s.nextval INTO l_dtl_coll_id FROM dual ;

873: END IF;
874:
875:
876: -- Collaboration Detail ID is generated from a sequence.
877: SELECT cln_collaboration_dtl_id_s.nextval INTO l_dtl_coll_id FROM dual ;
878: IF (l_Debug_Level <= 1) THEN
879: ecx_cln_debug_pub.Add('Collaboration Detail ID generated : '||l_dtl_coll_id,1);
880:
881:

Line 1410: SELECT cln_collaboration_hdr_id_s.NEXTVAL INTO x_coll_id FROM dual;

1406: END IF;
1407:
1408:
1409: -- Collaboration ID is generated from a sequence.
1410: SELECT cln_collaboration_hdr_id_s.NEXTVAL INTO x_coll_id FROM dual;
1411: IF (l_Debug_Level <= 1) THEN
1412: ecx_cln_debug_pub.Add('Collaboration Id generated : '||x_coll_id,1);
1413:
1414:

Line 2256: SELECT cln_collaboration_dtl_id_s.nextval INTO l_dtl_coll_id FROM dual ;

2252: END IF;
2253:
2254:
2255: -- Collaboration Detail ID is generated from a sequence.
2256: SELECT cln_collaboration_dtl_id_s.nextval INTO l_dtl_coll_id FROM dual ;
2257: IF (l_Debug_Level <= 1) THEN
2258: ecx_cln_debug_pub.Add('Collaboration Detail ID generated : '||l_dtl_coll_id,1);
2259: END IF;
2260:

Line 2943: SELECT cln_collaboration_msg_id_s.nextval INTO l_dtl_msg_id FROM dual ;

2939: END IF;
2940:
2941:
2942: -- Collaboration Message Detail ID is generated from a sequence.
2943: SELECT cln_collaboration_msg_id_s.nextval INTO l_dtl_msg_id FROM dual ;
2944: IF (l_Debug_Level <= 1) THEN
2945: ecx_cln_debug_pub.Add('Message Detail ID generated : '||l_dtl_msg_id,1);
2946: END IF;
2947: