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_VALUES

Line 497: update cct_middleware_values

493: IS
494: l_string VARCHAR2(64) := 'change_mware_paramsinvalues';
495: Begin
496: Begin
497: update cct_middleware_values
498: set name='MW_SERVER_IPADDRESS'
499: where name='OT_SERVER_IPADDRESS'
500: or name='OPENTEL_SERVER_NAME';
501: Exception

Line 507: update cct_middleware_values

503: null;
504: End;
505:
506: Begin
507: update cct_middleware_values
508: set name='MW_SERVER_INFO_1'
509: where name='OT_SERVER_INFO1'
510: or name='OT_SERVER_INFO_1';
511:

Line 519: update cct_middleware_values

515: End;
516:
517:
518: Begin
519: update cct_middleware_values
520: set name='MW_SERVER_INFO_2'
521: where name='OT_SERVER_INFO2'
522: or name='OT_SERVER_INFO_2';
523:

Line 530: update cct_middleware_values

526: null;
527: End;
528:
529: Begin
530: update cct_middleware_values
531: set name='MW_SERVER_INFO_3'
532: where name='OT_SERVER_INFO3'
533: or name='OT_SERVER_INFO_3';
534:

Line 541: update cct_middleware_values

537: null;
538: End;
539:
540: Begin
541: update cct_middleware_values
542: set name='MW_SERVER_INFO_4'
543: where name='OT_SERVER_INFO4'
544: or name='OT_SERVER_INFO_4';
545:

Line 552: update cct_middleware_values

548: null;
549: End;
550:
551: Begin
552: update cct_middleware_values
553: set name='MW_SERVER_INFO_5'
554: where name='OT_SERVER_INFO5'
555: or name='OT_SERVER_INFO_5';
556:

Line 563: delete cct_middleware_values

559: null;
560: End;
561:
562: Begin
563: delete cct_middleware_values
564: where name='CTI_ENABLER_NAME'
565: or name='LOCAL_CALL_DATA_FILE';
566: Exception
567: When others then

Line 591: delete cct_middleware_values

587:
588: For v_mw in c_mw
589: Loop
590: Begin
591: delete cct_middleware_values
592: where middleware_id=v_mw.middleware_id;
593: Exception
594: When others then
595: --dbms_output.put_line('error in deleting middleware values for Prospect Aspect');

Line 658: from cct_middleware_values a, cct_middleware_params b,

654: l_string VARCHAR2(64) := 'upgrade_mware_values';
655: Cursor c_mvp
656: is
657: Select a.middleware_value_id,a.name,b.middleware_param_id
658: from cct_middleware_values a, cct_middleware_params b,
659: cct_middlewares c
660: where a.name=b.name
661: and a.middleware_param_id is null
662: and a.middleware_id=c.middleware_id

Line 667: update cct_middleware_values

663: and c.middleware_type_id=b.middleware_type_id;
664: Begin
665: for v_mvp in c_mvp LOOP
666: --dbms_output.put_line('in loop');
667: update cct_middleware_values
668: set middleware_param_id=v_mvp.middleware_param_id
669: where middleware_value_id=v_mvp.middleware_value_id;
670: end loop;
671: Exception

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 723: l_string:='Error updating CCT_Middleware_values for middleware_type='||p_old_type||' param name='||p_old_param_name;

719:
720: l_new_param_id Number;
721: l_string VARCHAR2(1000);
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

Line 732: update cct_middleware_values

728: and p.middleware_type_id=t.middleware_type_id
729: and p.name=p_new_param_name;
730:
731: for v_mvalueID in c_value LOOP
732: update cct_middleware_values
733: set middleware_param_id=l_new_param_id
734: where middleware_value_id=v_mvalueID.middleware_value_id;
735: end loop;
736: Exception

Line 756: l_string :='Error updating CCT_MIDDLEWARE_VALUES table middleware_id='||to_char(p_middleware_id)||' p_old_type='||p_old_type;

752:
753: l_string VARCHAR2(1000);
754: l_new_type_id Number;
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;

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 790: update cct_middleware_values

786: Begin
787: l_string:='ERROR deleting obsolete middleware values for type='||p_middleware_type||' and param='||p_param_name;
788: For v_value in c_mvalue LOOP
789: Begin
790: update cct_middleware_values
791: set f_deletedflag='D'
792: where middleware_value_id=v_value.middleware_value_id;
793: Exception
794: When no_data_found then

Line 820: delete cct_middleware_values

816:
817: For v_mw in c_mw
818: Loop
819: Begin
820: delete cct_middleware_values
821: where middleware_id=v_mw.middleware_id;
822: Exception
823: When others then
824: --dbms_output.put_line('error in deleting middleware values for Prospect Aspect');

Line 882: l_mval CCT_MIDDLEWARE_VALUES.VALUE%TYPE;

878: -- in bug 2276001
879: Procedure upgrade_ao_flg_mw_values
880: IS
881: l_mvid Number;
882: l_mval CCT_MIDDLEWARE_VALUES.VALUE%TYPE;
883: l_mpid Number;
884: l_string VARCHAR2(64) := 'upg_ao_flg_mware_values';
885: Cursor c_mvp
886: is

Line 888: FROM cct_middleware_params a, cct_middleware_values b

884: l_string VARCHAR2(64) := 'upg_ao_flg_mware_values';
885: Cursor c_mvp
886: is
887: SELECT b.middleware_value_id, b.VALUE
888: FROM cct_middleware_params a, cct_middleware_values b
889: WHERE a.middleware_param_id = b.middleware_param_id
890: AND a.domain_lookup_type = 'CCT_AO_FLAG'
891: AND (b.f_deletedflag <> 'D' OR b.f_deletedflag IS NULL);
892: Begin

Line 895: update cct_middleware_values

891: AND (b.f_deletedflag <> 'D' OR b.f_deletedflag IS NULL);
892: Begin
893: for v_mvp in c_mvp LOOP
894: --dbms_output.put_line('in loop');
895: update cct_middleware_values
896: set value= decode(v_mvp.value,'Y', 'YES', 'N','NO','' )
897: where middleware_value_id=v_mvp.middleware_value_id;
898: end loop;
899: Exception