[Home] [Help]
363: BEGIN
364:
365: SELECT VISIBILITY_FLAG
366: INTO l_visibility_flag
367: FROM EGO_ACTIONS_DL
368: WHERE ACTION_ID = l_action_id
369: AND DATA_LEVEL_ID = l_data_level_id;
370:
371: UPDATE EGO_ACTIONS_DL
367: FROM EGO_ACTIONS_DL
368: WHERE ACTION_ID = l_action_id
369: AND DATA_LEVEL_ID = l_data_level_id;
370:
371: UPDATE EGO_ACTIONS_DL
372: SET VISIBILITY_FLAG = p_visibility_flag
373: WHERE ACTION_ID = l_action_id
374: AND DATA_LEVEL_ID = l_data_level_id;
375:
375:
376: EXCEPTION
377: WHEN NO_DATA_FOUND THEN
378:
379: INSERT INTO EGO_ACTIONS_DL
380: (
381: ACTION_ID,
382: DATA_LEVEL_ID,
383: VISIBILITY_FLAG,