# `callAllIdbVisible` (procedure)


- **Type:** PROCEDURE
- **Deterministic:** NO
- **SQL data access:** CONTAINS SQL

## Parameters

_No parameters._

## Body

_Body is not pre-cached. To inspect: `mysql --defaults-file=~/.my.cnf -e 'SHOW CREATE PROCEDURE `callAllIdbVisible`'`._

## Narrative

**Business context:** Module-tree visibility-cascade for the BACK navigation tree (`gdsmodule`). Walks the root nodes (those with empty `sParentId`); for any root that has `bVisible=0`, marks every direct child invisible (`bVisible=0`, `bJurisdictionShow=0`, `bUnTask=0`) and then recurses deeper via `callAllIdChidVisible`. Companion to `callAllId` (which rebuilds the `sAllId` path), specialised for propagating the visibility/jurisdiction flags down the subtree when a parent is hidden.

**What it does:** opens a cursor over root `gdsmodule` rows; for each root with `IFNULL(bVisible,0)=0`, runs a single `UPDATE gdsmodule SET bVisible=0, bJurisdictionShow=0, bUnTask=0 WHERE sParentId = root.sId` and then calls `callAllIdChidVisible(root.sId)` to descend.

**Invocation:** Status: appears orphaned. No caller found in any channel (form-master, gdsmodule hooks, other routines, xly-src grep). The visibility-rebuild flow ships through `callAllIdChidVisible` directly from Java; this top-level wrapper is unused — candidate for maintainer audit.
