eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CLN_CH_COLLABORATION_PKG dependencies on CLN_COLL_COMPLETED_STATUS

Line 4319: ecx_cln_debug_pub.Add('----- Before querying the CLN_COLL_COMPLETED_STATUS ----',1);

4315:
4316: x_coll_status := 'STARTED';
4317: BEGIN
4318: IF (l_Debug_Level <= 1) THEN
4319: ecx_cln_debug_pub.Add('----- Before querying the CLN_COLL_COMPLETED_STATUS ----',1);
4320: END IF;
4321:
4322:
4323: SELECT message_count

Line 4325: FROM CLN_COLL_COMPLETED_STATUS

4321:
4322:
4323: SELECT message_count
4324: INTO l_message_count
4325: FROM CLN_COLL_COMPLETED_STATUS
4326: WHERE application_id = p_app_id
4327: AND collaboration_type = p_coll_type
4328: AND nvl(collaboration_standard,nvl(p_coll_standard,'~')) = nvl(p_coll_standard,'~')
4329: AND document_type = p_doc_type

Line 4333: ecx_cln_debug_pub.Add('----- After querying the CLN_COLL_COMPLETED_STATUS ----',1);

4329: AND document_type = p_doc_type
4330: AND document_direction = p_doc_dir;
4331:
4332: IF (l_Debug_Level <= 1) THEN
4333: ecx_cln_debug_pub.Add('----- After querying the CLN_COLL_COMPLETED_STATUS ----',1);
4334: ecx_cln_debug_pub.Add('----- Message count : '||l_message_count,1);
4335: END IF;
4336:
4337: