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.CCT_UPGRADE_PKG dependencies on CCT_MIDDLEWARE_TYPES

Line 582: from cct_middlewares a,cct_middleware_types b

578: IS
579: Cursor c_mw
580: is
581: Select a.middleware_id
582: from cct_middlewares a,cct_middleware_types b
583: where a.middleware_type_id=b.middleware_type_id
584: and b.middleware_type='PROSPECT_ASPECT';
585:
586: Begin

Line 618: from cct_middleware_types

614: End Loop;
615: Begin
616: delete cct_middleware_params
617: where middleware_type_id=(Select middleware_Type_id
618: from cct_middleware_types
619: where middleware_type='PROSPECT_ASPECT');
620: Exception
621: When others then
622: --dbms_output.put_line('error in deleting middleware_param for Prospect Aspect');

Line 628: from cct_middleware_types

624: End;
625: Begin
626: delete jtf_rs_resource_params
627: where param_type=(Select middleware_Type_id
628: from cct_middleware_types
629: where middleware_type='PROSPECT_ASPECT');
630: Exception
631: When others then
632: --dbms_output.put_line('error in deleting middleware_param for Prospect Aspect');

Line 636: delete cct_middleware_types

632: --dbms_output.put_line('error in deleting middleware_param for Prospect Aspect');
633: null;
634: End;
635: Begin
636: delete cct_middleware_types
637: where middleware_type='PROSPECT_ASPECT';
638: Exception
639: When others then
640: --dbms_output.put_line('error in deleting middleware_type=Prospect Aspect');

Line 681: from jtf_rs_resource_values v,jtf_rs_resource_params p,cct_middleware_types t

677: IS
678: Cursor c_value
679: is
680: Select resource_param_value_id
681: from jtf_rs_resource_values v,jtf_rs_resource_params p,cct_middleware_types t
682: where t.middleware_type=p_old_type
683: and p.param_type=t.middleware_type_id
684: and p.name=p_old_param_name
685: and v.resource_param_id=p.resource_param_id;

Line 693: from jtf_rs_resource_params p,cct_middleware_types t

689: Begin
690: l_string:='Error updating JTF_RS_RESOURCE_VALUES for middleware_type='||p_old_type||' agent param name='||p_old_param_name;
691: Select resourcE_param_id
692: into l_new_param_id
693: from jtf_rs_resource_params p,cct_middleware_types t
694: where t.middleware_type=p_new_type
695: and p.param_type=t.middleware_type_id
696: and p.name=p_new_param_name;
697:

Line 714: from cct_middleware_values v,cct_middleware_params p,cct_middleware_types t

710: IS
711: Cursor c_value
712: is
713: Select middleware_value_id
714: from cct_middleware_values v,cct_middleware_params p,cct_middleware_types t
715: where t.middleware_type=p_old_type
716: and p.middleware_type_id=t.middleware_type_id
717: and p.name=p_old_param_name
718: and v.middleware_param_id=p.middleware_param_id;

Line 726: from cct_middleware_params p,cct_middleware_types t

722: Begin
723: l_string:='Error updating CCT_Middleware_values for middleware_type='||p_old_type||' param name='||p_old_param_name;
724: Select middleware_param_id
725: into l_new_param_id
726: from cct_middleware_params p,cct_middleware_types t
727: where t.middleware_type=p_new_type
728: and p.middleware_type_id=t.middleware_type_id
729: and p.name=p_new_param_name;
730:

Line 748: from cct_middlewares m,cct_middleware_types t

744: IS
745: Cursor c_middleware
746: is
747: Select m.middleware_id
748: from cct_middlewares m,cct_middleware_types t
749: where t.middleware_type=p_old_type
750: and t.middleware_type_id=m.middleware_type_id
751: and m.middleware_id=p_middleware_id;
752:

Line 759: from cct_middleware_types

755: Begin
756: l_string :='Error updating CCT_MIDDLEWARE_VALUES table middleware_id='||to_char(p_middleware_id)||' p_old_type='||p_old_type;
757: Select middleware_type_id
758: into l_new_type_id
759: from cct_middleware_types
760: where middleware_type=p_new_type;
761:
762: for v_middleware in c_middleware Loop
763: update cct_middlewares

Line 780: from cct_middleware_values v,cct_middleware_params p,cct_middleware_types t

776: is
777: Cursor c_mvalue
778: is
779: Select v.middleware_value_id
780: from cct_middleware_values v,cct_middleware_params p,cct_middleware_types t
781: where t.middleware_type=p_middleware_type
782: and t.middleware_type_id=p.middleware_type_id
783: and p.name=p_param_name
784: and v.middleware_param_id=p.middleware_param_id;

Line 811: from cct_middlewares a,cct_middleware_types b

807: IS
808: Cursor c_mw
809: is
810: Select a.middleware_id
811: from cct_middlewares a,cct_middleware_types b
812: where a.middleware_type_id=b.middleware_type_id
813: and b.middleware_type_id=p_middleware_type_id;
814:
815: Begin

Line 847: from cct_middleware_types

843: End Loop;
844: Begin
845: delete cct_middleware_params
846: where middleware_type_id=(Select middleware_Type_id
847: from cct_middleware_types
848: where middleware_type_id=p_middleware_type_id);
849: Exception
850: When others then
851: --dbms_output.put_line('error in deleting middleware_param for Prospect Aspect');

Line 857: from cct_middleware_types

853: End;
854: Begin
855: delete jtf_rs_resource_params
856: where param_type=(Select middleware_Type_id
857: from cct_middleware_types
858: where middleware_type_id=p_middleware_type_id);
859: Exception
860: When others then
861: --dbms_output.put_line('error in deleting middleware_param for Prospect Aspect');

Line 865: delete cct_middleware_types

861: --dbms_output.put_line('error in deleting middleware_param for Prospect Aspect');
862: null;
863: End;
864: Begin
865: delete cct_middleware_types
866: where middleware_type_id=p_middleware_type_id;
867: Exception
868: When others then
869: --dbms_output.put_line('error in deleting middleware_type=Prospect Aspect');