APPS.CCT_CASCADE_DELETE_PUB dependencies on CCT_MW_ROUTE_POINTS

Line 260: from cct_mw_route_points

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;
263: IF p_commit_flag = 'Y' THEN
264: commit;

Line 370: l_id cct_mw_route_points.mw_route_point_id%type;

366: PROCEDURE delete_route_point
367: ( p_middleware_id IN NUMBER
368: , p_commit_flag IN VARCHAR2)
369: IS
370: l_id cct_mw_route_points.mw_route_point_id%type;
371: CURSOR c_rpts IS
372: select mw_route_point_id
373: from cct_mw_route_points
374: where middleware_id = p_middleware_id;

Line 373: from cct_mw_route_points

369: IS
370: l_id cct_mw_route_points.mw_route_point_id%type;
371: CURSOR c_rpts IS
372: select mw_route_point_id
373: from cct_mw_route_points
374: where middleware_id = p_middleware_id;
375: BEGIN
376: IF p_middleware_id is not null
377: then

Line 397: delete cct_mw_route_points

393: where mw_route_point_id = l_id;
394: END IF;
395: END LOOP;
396:
397: delete cct_mw_route_points
398: where middleware_id = p_middleware_id;
399:
400: END IF;
401: IF p_commit_flag = 'Y' THEN