186: --
187: -- Index-by tables for storing the identifiers and names of Operating
188: -- Units.
189: --
190: TYPE OrgIdTab IS TABLE OF hr_operating_units.organization_id%TYPE
191: INDEX BY BINARY_INTEGER;
192: TYPE OuNameTab IS TABLE OF hr_operating_units.name%TYPE
193: INDEX BY BINARY_INTEGER;
194:
188: -- Units.
189: --
190: TYPE OrgIdTab IS TABLE OF hr_operating_units.organization_id%TYPE
191: INDEX BY BINARY_INTEGER;
192: TYPE OuNameTab IS TABLE OF hr_operating_units.name%TYPE
193: INDEX BY BINARY_INTEGER;
194:
195: --
196: -- A record type that contains information pertinent to an Operating
196: -- A record type that contains information pertinent to an Operating
197: -- Unit.
198: --
199: TYPE OrgInfoRec IS RECORD (
200: organization_name hr_operating_units.name%TYPE);
201:
202: --
203: -- Name
204: -- get_valid_org