APPS.CCT_UPGRADE_PKG dependencies on JTF_RS_RESOURCE_PARAMS

Line 626: delete jtf_rs_resource_params

622: --dbms_output.put_line('error in deleting middleware_param for Prospect Aspect');
623: null;
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

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 855: delete jtf_rs_resource_params

851: --dbms_output.put_line('error in deleting middleware_param for Prospect Aspect');
852: null;
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

Line 992: from jtf_rs_resource_params

988: BEGIN
989: -- check if the resource_param_id is incorrect
990: Select resource_param_id
991: into l_old_param_id
992: from jtf_rs_resource_params
993: where name=p_agent_param
994: and param_type=p_middleware_type_id
995: and resource_param_id<>p_new_agent_param_id;
996:

Line 1008: delete jtf_rs_resource_params

1004: where resource_param_value_id=v_values.resource_param_value_id;
1005: End Loop;
1006:
1007: -- Delete the incorrect resource param
1008: delete jtf_rs_resource_params
1009: where resource_param_id=l_old_param_id;
1010: --dbms_output.put_line('deleted l_old_param_id='||to_char(l_old_param_id));
1011: Exception
1012: When no_data_found then