APPS.CCT_UPGRADE_PKG dependencies on CCT_MIDDLEWARE_PARAMS

Line 616: delete cct_middleware_params

612: null;
613: End;
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

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 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 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 845: delete cct_middleware_params

841: null;
842: End;
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

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