APPS.CCT_MIGRATE_MW dependencies on CCT_MIDDLEWARES

Line 10: select middleware_id into l_mw_id from cct_middlewares

6: BEGIN
7: l_mw_id := '';
8: if (p_name is not null) then
9: begin
10: select middleware_id into l_mw_id from cct_middlewares
11: where middleware_type_id= p_mw1_id
12: and config_name=p_name
13: and nvl(f_deletedflag,'Y') <> 'D';
14: Exception

Line 19: update cct_middlewares set middleware_type_id=p_mw2_id

15: WHEN OTHERS THEN
16: return; --Given Config Name doesn't exists.
17: end;
18:
19: update cct_middlewares set middleware_type_id=p_mw2_id
20: where middleware_type_id=p_mw1_id
21: and config_name=p_name;
22: else
23: update cct_middlewares set middleware_type_id=p_mw2_id

Line 23: update cct_middlewares set middleware_type_id=p_mw2_id

19: update cct_middlewares set middleware_type_id=p_mw2_id
20: where middleware_type_id=p_mw1_id
21: and config_name=p_name;
22: else
23: update cct_middlewares set middleware_type_id=p_mw2_id
24: where middleware_type_id=p_mw1_id;
25:
26: end if;
27: delete_params(p_mw1_id,p_mw2_id,l_mw_id);