DBA Data[Home] [Help]

APPS.CCT_CASCADE_DELETE_PUB dependencies on CCT_MULTISITE_CONFIGS

Line 298: l_config_id cct_multisite_configs.multisite_config_id%type;

294: PROCEDURE delete_multisite
295: ( p_middleware_id IN NUMBER
296: , p_commit_flag IN VARCHAR2)
297: IS
298: l_config_id cct_multisite_configs.multisite_config_id%type;
299: CURSOR c_configs IS
300: select multisite_config_id
301: from cct_multisite_configs
302: where from_middleware_id = p_middleware_id

Line 301: from cct_multisite_configs

297: IS
298: l_config_id cct_multisite_configs.multisite_config_id%type;
299: CURSOR c_configs IS
300: select multisite_config_id
301: from cct_multisite_configs
302: where from_middleware_id = p_middleware_id
303: or to_middleware_id = p_middleware_id;
304: BEGIN
305: IF p_middleware_id is not null

Line 326: delete cct_multisite_configs

322:
323: END IF;
324: END LOOP;
325:
326: delete cct_multisite_configs
327: where from_middleware_id = p_middleware_id
328: or to_middleware_id = p_middleware_id;
329: END IF;
330: IF p_commit_flag = 'Y' THEN