[Home] [Help]
905: BEGIN
906:
907: SELECT VISIBILITY_FLAG
908: INTO l_visibility_flag
909: FROM EGO_ACTIONS_DL
910: WHERE ACTION_ID = l_action_id
911: AND DATA_LEVEL_ID = l_data_level_id;
912:
913: UPDATE EGO_ACTIONS_DL
909: FROM EGO_ACTIONS_DL
910: WHERE ACTION_ID = l_action_id
911: AND DATA_LEVEL_ID = l_data_level_id;
912:
913: UPDATE EGO_ACTIONS_DL
914: SET VISIBILITY_FLAG = p_visibility_flag
915: WHERE ACTION_ID = l_action_id
916: AND DATA_LEVEL_ID = l_data_level_id;
917:
917:
918: EXCEPTION
919: WHEN NO_DATA_FOUND THEN
920:
921: INSERT INTO EGO_ACTIONS_DL
922: (
923: ACTION_ID,
924: DATA_LEVEL_ID,
925: VISIBILITY_FLAG,