APPS.CCT_UPGRADE_PKG dependencies on JTF_RS_RESOURCE_VALUES

Line 599: delete jtf_rs_ResourcE_values

595: --dbms_output.put_line('error in deleting middleware values for Prospect Aspect');
596: null;
597: End;
598: Begin
599: delete jtf_rs_ResourcE_values
600: where value_type=v_mw.middleware_id;
601: Exception
602: When others then
603: --dbms_output.put_line('error in deleting resourcE_middleware values for 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 690: l_string:='Error updating JTF_RS_RESOURCE_VALUES for middleware_type='||p_old_type||' agent param name='||p_old_param_name;

686:
687: l_new_param_id Number;
688: l_string VARCHAR2(1000);
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

Line 699: update jtf_rs_resource_values

695: and p.param_type=t.middleware_type_id
696: and p.name=p_new_param_name;
697:
698: for v_valueID in c_value LOOP
699: update jtf_rs_resource_values
700: set resourcE_param_id=l_new_param_id
701: where resource_param_value_id=v_valueID.resource_param_value_id;
702: end loop;
703: Exception

Line 828: delete jtf_rs_ResourcE_values

824: --dbms_output.put_line('error in deleting middleware values for Prospect Aspect');
825: null;
826: End;
827: Begin
828: delete jtf_rs_ResourcE_values
829: where value_type=v_mw.middleware_id;
830: Exception
831: When others then
832: --dbms_output.put_line('error in deleting resourcE_middleware values for Prospect Aspect');

Line 985: from jtf_rs_resource_values

981: IS
982: Cursor c_values(p_param_id Number)
983: is
984: Select resource_param_value_id
985: from jtf_rs_resource_values
986: where resource_param_id=p_param_id;
987: l_old_param_id Number;
988: BEGIN
989: -- check if the resource_param_id is incorrect

Line 1002: Update jtf_rs_ResourcE_values

998:
999: -- if there is an incorrect param then get all the resource values for that param and update it with the correct param id (from JTFRSPAR.ldt file)
1000: For v_values in c_values(l_old_param_id) LOOP
1001: --dbms_output.put_line('updating Resource Value id='||to_char(v_values.resource_param_value_id));
1002: Update jtf_rs_ResourcE_values
1003: set resource_param_id=p_new_agent_param_id
1004: where resource_param_value_id=v_values.resource_param_value_id;
1005: End Loop;
1006: