APPS.CCT_MIGRATE_MW dependencies on CCT_MIDDLEWARE_PARAMS

Line 47: from cct_middleware_params mw

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
48: where middleware_type_id=p_mw1_id and nvl(mw.f_deletedflag,'Y') <> 'D'
49:
50: minus
51:

Line 53: from cct_middleware_params mw1, cct_middleware_params mw2

49:
50: minus
51:
52: select mw1.middleware_param_id
53: from cct_middleware_params mw1, cct_middleware_params mw2
54: where mw1.middleware_type_id=p_mw1_id and mw2.middleware_type_id=p_mw2_id
55: and mw1.name=mw2.name
56: and nvl(mw1.f_deletedflag,'Y') <> 'D'
57: ) ;

Line 63: from cct_middleware_params mw

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
64: where middleware_type_id=p_mw1_id and nvl(mw.f_deletedflag,'Y') <> 'D'
65:
66: minus
67:

Line 69: from cct_middleware_params mw1, cct_middleware_params mw2

65:
66: minus
67:
68: select mw1.middleware_param_id
69: from cct_middleware_params mw1, cct_middleware_params mw2
70: where mw1.middleware_type_id=p_mw1_id and mw2.middleware_type_id=p_mw2_id
71: and mw1.name=mw2.name
72: and nvl(mw1.f_deletedflag,'Y') <> 'D'
73:

Line 84: l_mw1_param_id cct_middleware_params.middleware_param_id%type;

80: END;
81:
82: procedure update_params(p_mw1_id IN NUMBER,p_mw2_id IN NUMBER, p_mw_id IN NUMBER )
83: IS
84: l_mw1_param_id cct_middleware_params.middleware_param_id%type;
85: l_mw2_param_id cct_middleware_params.middleware_param_id%type;
86:
87: CURSOR c_mw IS
88: select mw1.middleware_param_id, mw2.middleware_param_id

Line 85: l_mw2_param_id cct_middleware_params.middleware_param_id%type;

81:
82: procedure update_params(p_mw1_id IN NUMBER,p_mw2_id IN NUMBER, p_mw_id IN NUMBER )
83: IS
84: l_mw1_param_id cct_middleware_params.middleware_param_id%type;
85: l_mw2_param_id cct_middleware_params.middleware_param_id%type;
86:
87: CURSOR c_mw IS
88: select mw1.middleware_param_id, mw2.middleware_param_id
89: from cct_middleware_params mw1, cct_middleware_params mw2

Line 89: from cct_middleware_params mw1, cct_middleware_params mw2

85: l_mw2_param_id cct_middleware_params.middleware_param_id%type;
86:
87: CURSOR c_mw IS
88: select mw1.middleware_param_id, mw2.middleware_param_id
89: from cct_middleware_params mw1, cct_middleware_params mw2
90: where mw1.middleware_type_id=p_mw1_id and mw2.middleware_type_id=p_mw2_id
91: and mw1.name=mw2.name
92: and nvl(mw1.f_deletedflag,'Y') <> 'D';
93: BEGIN