APPS.CCT_MIGRATE_MW dependencies on JTF_RS_RESOURCE_VALUES

Line 119: l_mw1_param_id jtf_rs_resource_values.resource_param_id%type;

115: end;
116:
117: procedure update_agent_params(p_mw1_id IN NUMBER,p_mw2_id IN NUMBER, p_mw_id IN NUMBER )
118: IS
119: l_mw1_param_id jtf_rs_resource_values.resource_param_id%type;
120: l_mw2_param_id jtf_rs_resource_values.resource_param_id%type;
121:
122: CURSOR c_mw IS
123: select mw1.resource_param_id, mw2.resource_param_id

Line 120: l_mw2_param_id jtf_rs_resource_values.resource_param_id%type;

116:
117: procedure update_agent_params(p_mw1_id IN NUMBER,p_mw2_id IN NUMBER, p_mw_id IN NUMBER )
118: IS
119: l_mw1_param_id jtf_rs_resource_values.resource_param_id%type;
120: l_mw2_param_id jtf_rs_resource_values.resource_param_id%type;
121:
122: CURSOR c_mw IS
123: select mw1.resource_param_id, mw2.resource_param_id
124: from jtf_rs_resource_params mw1, jtf_rs_resource_params mw2

Line 136: update jtf_rs_resource_values Set resource_param_id = l_mw2_param_id

132: IF c_mw%NOTFOUND THEN
133: CLOSE c_mw;
134: exit;
135: ELSIF (p_mw_id is null) then
136: update jtf_rs_resource_values Set resource_param_id = l_mw2_param_id
137: where resource_param_id = l_mw1_param_id ;
138: ELSE
139: update jtf_rs_resource_values Set resource_param_id = l_mw2_param_id
140: where value_type=p_mw_id and resource_param_id = l_mw1_param_id ;

Line 139: update jtf_rs_resource_values Set resource_param_id = l_mw2_param_id

135: ELSIF (p_mw_id is null) then
136: update jtf_rs_resource_values Set resource_param_id = l_mw2_param_id
137: where resource_param_id = l_mw1_param_id ;
138: ELSE
139: update jtf_rs_resource_values Set resource_param_id = l_mw2_param_id
140: where value_type=p_mw_id and resource_param_id = l_mw1_param_id ;
141: END IF;
142: END LOOP;
143: