DBA Data[Home] [Help]

APPS.CCT_CASCADE_DELETE_PUB dependencies on CCT_IVR_MAPS

Line 258: delete cct_ivr_maps

254: IF p_middleware_id is not null
255: then
256: SAVEPOINT CCT_IVR_DEL;
257: -- Delete Child records first
258: delete cct_ivr_maps
259: where mw_route_point_id in (select mw_route_point_id
260: from cct_mw_route_points
261: where middleware_id = p_middleware_id);
262: END IF;

Line 281: delete cct_ivr_maps

277: IF p_route_point_id is not null
278: then
279: SAVEPOINT CCT_IVR_RP_DEL;
280: -- Delete Child records first
281: delete cct_ivr_maps
282: where mw_route_point_id = p_route_point_id;
283: END IF;
284: IF p_commit_flag = 'Y' THEN
285: commit;