APPS.CCT_CASCADE_DELETE_PUB dependencies on CCT_MULTISITE_PATHS

Line 347: SAVEPOINT CCT_MULTISITE_PATHS_DEL;

343: IS
344: BEGIN
345: IF p_multisite_config_id is not null
346: then
347: SAVEPOINT CCT_MULTISITE_PATHS_DEL;
348: -- Delete Child records first
349: delete cct_multisite_path_values
350: where multisite_path_id IN(select multisite_path_id
351: from cct_multisite_paths

Line 351: from cct_multisite_paths

347: SAVEPOINT CCT_MULTISITE_PATHS_DEL;
348: -- Delete Child records first
349: delete cct_multisite_path_values
350: where multisite_path_id IN(select multisite_path_id
351: from cct_multisite_paths
352: where multisite_config_id = p_multisite_config_id);
353:
354: delete cct_multisite_paths
355: where multisite_config_id = p_multisite_config_id;

Line 354: delete cct_multisite_paths

350: where multisite_path_id IN(select multisite_path_id
351: from cct_multisite_paths
352: where multisite_config_id = p_multisite_config_id);
353:
354: delete cct_multisite_paths
355: where multisite_config_id = p_multisite_config_id;
356: END IF;
357: IF p_commit_flag = 'Y' THEN
358: commit;

Line 362: rollback TO SAVEPOINT CCT_MULTISITE_PATHS_DEL;

358: commit;
359: END IF;
360: EXCEPTION
361: WHEN OTHERS THEN
362: rollback TO SAVEPOINT CCT_MULTISITE_PATHS_DEL;
363: raise_application_error(-20000, sqlerrm || '. Could not delete multisite paths') ;
364: END;
365:
366: PROCEDURE delete_route_point

Line 419: SAVEPOINT CCT_MULTISITE_PATHS_RP_DEL;

415: IS
416: BEGIN
417: IF p_mw_route_point_id is not null
418: then
419: SAVEPOINT CCT_MULTISITE_PATHS_RP_DEL;
420: -- Delete Child records first
421: delete cct_multisite_path_values
422: where multisite_path_id IN(select multisite_path_id
423: from cct_multisite_paths

Line 423: from cct_multisite_paths

419: SAVEPOINT CCT_MULTISITE_PATHS_RP_DEL;
420: -- Delete Child records first
421: delete cct_multisite_path_values
422: where multisite_path_id IN(select multisite_path_id
423: from cct_multisite_paths
424: where mw_route_point_id = p_mw_route_point_id);
425:
426: delete cct_multisite_paths
427: where mw_route_point_id = p_mw_route_point_id;

Line 426: delete cct_multisite_paths

422: where multisite_path_id IN(select multisite_path_id
423: from cct_multisite_paths
424: where mw_route_point_id = p_mw_route_point_id);
425:
426: delete cct_multisite_paths
427: where mw_route_point_id = p_mw_route_point_id;
428: END IF;
429: IF p_commit_flag = 'Y' THEN
430: commit;

Line 434: rollback TO SAVEPOINT CCT_MULTISITE_PATHS_RP_DEL;

430: commit;
431: END IF;
432: EXCEPTION
433: WHEN OTHERS THEN
434: rollback TO SAVEPOINT CCT_MULTISITE_PATHS_RP_DEL;
435: raise_application_error(-20000, sqlerrm || '. Could not delete multisite paths') ;
436: END;
437:
438: END CCT_CASCADE_DELETE_PUB; -- Package Specification CCT_CASCADE_DELETE_PUB