APPS.CCT_MIGRATE_MW dependencies on CCT_MIDDLEWARE_VALUES

Line 43: delete from cct_middleware_values where nvl(f_deletedflag,'Y') <> 'D'

39: BEGIN
40: SAVEPOINT CCT_MIDDLEWARE_DELETE_SAV;
41:
42: if (p_mw_id is null) then
43: delete from cct_middleware_values where nvl(f_deletedflag,'Y') <> 'D'
44: and middleware_param_id IN
45: (
46: select mw.middleware_param_id
47: from cct_middleware_params mw

Line 59: delete from cct_middleware_values where middleware_id=p_mw_id and nvl(f_deletedflag,'Y') <> 'D'

55: and mw1.name=mw2.name
56: and nvl(mw1.f_deletedflag,'Y') <> 'D'
57: ) ;
58: else
59: delete from cct_middleware_values where middleware_id=p_mw_id and nvl(f_deletedflag,'Y') <> 'D'
60: and middleware_param_id IN
61: (
62: select mw.middleware_param_id
63: from cct_middleware_params mw

Line 102: update cct_middleware_values Set middleware_param_id = l_mw2_param_id

98: IF c_mw%NOTFOUND THEN
99: CLOSE c_mw;
100: exit;
101: ELSIF (p_mw_id is null) then
102: update cct_middleware_values Set middleware_param_id = l_mw2_param_id
103: where middleware_param_id = l_mw1_param_id and nvl(f_deletedflag,'Y') <> 'D' ;
104: ELSE
105: update cct_middleware_values Set middleware_param_id = l_mw2_param_id
106: where middleware_id=p_mw_id and middleware_param_id = l_mw1_param_id

Line 105: update cct_middleware_values Set middleware_param_id = l_mw2_param_id

101: ELSIF (p_mw_id is null) then
102: update cct_middleware_values Set middleware_param_id = l_mw2_param_id
103: where middleware_param_id = l_mw1_param_id and nvl(f_deletedflag,'Y') <> 'D' ;
104: ELSE
105: update cct_middleware_values Set middleware_param_id = l_mw2_param_id
106: where middleware_id=p_mw_id and middleware_param_id = l_mw1_param_id
107: and nvl(f_deletedflag,'Y') <> 'D' ;
108: END IF;
109: END LOOP;