APPS.CLN_CH_COLLABORATION_PKG dependencies on FND_LOOKUPS

Line 620: SELECT meaning INTO l_meaning FROM fnd_lookups

616: END IF;
617: IF (p_app_id IS NOT NULL) THEN
618: BEGIN
619: l_meaning := p_app_id;
620: SELECT meaning INTO l_meaning FROM fnd_lookups
621: WHERE lookup_code = p_app_id AND lookup_type = 'CLN_APPLICATION_ID';
622: IF (l_Debug_Level <= 1) THEN
623: ecx_cln_debug_pub.Add('...........Application ID found as - '||l_meaning,1);
624: END IF;

Line 639: SELECT meaning INTO l_meaning FROM fnd_lookups

635: END IF;
636: IF (p_doc_dir IS NOT NULL) THEN
637: BEGIN
638: l_meaning := p_doc_dir;
639: SELECT meaning INTO l_meaning FROM fnd_lookups
640: WHERE lookup_code = p_doc_dir AND lookup_type = 'CLN_COLLABORATION_DOC_DIRECTN';
641: IF (l_Debug_Level <= 1) THEN
642: ecx_cln_debug_pub.Add('...........Document Direction found as - '||l_meaning,1);
643: END IF;

Line 658: SELECT meaning INTO l_meaning FROM fnd_lookups

654: END IF;
655: IF (p_doc_type IS NOT NULL) THEN
656: BEGIN
657: l_meaning := p_doc_type;
658: SELECT meaning INTO l_meaning FROM fnd_lookups
659: WHERE lookup_code = p_doc_type AND lookup_type = 'CLN_COLLABORATION_DOC_TYPE';
660: IF (l_Debug_Level <= 1) THEN
661: ecx_cln_debug_pub.Add('...........Document Type found as - '||l_meaning,1);
662: END IF;

Line 677: SELECT meaning INTO l_meaning FROM fnd_lookups

673: END IF;
674: IF (p_coll_status IS NOT NULL) THEN
675: BEGIN
676: l_meaning := p_coll_status;
677: SELECT meaning INTO l_meaning FROM fnd_lookups
678: WHERE lookup_code = p_coll_status AND lookup_type = 'CLN_COLLABORATION_STATUS';
679: IF (l_Debug_Level <= 1) THEN
680: ecx_cln_debug_pub.Add('...........Collaboration Status found as - '||l_meaning,1);
681: END IF;

Line 696: SELECT meaning INTO l_meaning FROM fnd_lookups

692: END IF;
693: IF (p_coll_pt IS NOT NULL) THEN
694: BEGIN
695: l_meaning := p_coll_pt;
696: SELECT meaning INTO l_meaning FROM fnd_lookups
697: WHERE lookup_code = p_coll_pt AND lookup_type = 'CLN_COLLABORATION_POINT';
698: IF (l_Debug_Level <= 1) THEN
699: ecx_cln_debug_pub.Add('...........Collaboration Point found as - '||l_meaning,1);
700: END IF;

Line 715: SELECT meaning INTO l_meaning FROM fnd_lookups

711: END IF;
712: IF (p_coll_type IS NOT NULL) THEN
713: BEGIN
714: l_meaning := p_coll_type;
715: SELECT meaning INTO l_meaning FROM fnd_lookups
716: WHERE lookup_code = p_coll_type AND lookup_type = 'CLN_COLLABORATION_TYPE';
717: IF (l_Debug_Level <= 1) THEN
718: ecx_cln_debug_pub.Add('...........Collaboration Type found as - '||l_meaning,1);
719: END IF;

Line 734: SELECT meaning INTO l_meaning FROM fnd_lookups

730: END IF;
731: IF (p_doc_status IS NOT NULL) THEN
732: BEGIN
733: l_meaning := p_doc_status;
734: SELECT meaning INTO l_meaning FROM fnd_lookups
735: WHERE lookup_code = p_doc_status AND lookup_type = 'CLN_COLLABORATION_DOC_STATUS';
736: IF (l_Debug_Level <= 1) THEN
737: ecx_cln_debug_pub.Add('...........Collaboration Document Status found as - '||l_meaning,1);
738: END IF;

Line 752: SELECT meaning INTO l_meaning FROM fnd_lookups

748: END IF;
749: IF (p_disposition IS NOT NULL) THEN
750: BEGIN
751: l_meaning := p_disposition;
752: SELECT meaning INTO l_meaning FROM fnd_lookups
753: WHERE lookup_code = p_disposition AND lookup_type = 'CLN_DISPOSITION';
754: IF (l_Debug_Level <= 1) THEN
755: ecx_cln_debug_pub.Add('...........Disposition found as - '||l_meaning,1);
756: END IF;