6: -- declare types needed globally
7: --
8:
9:
10: TYPE r_pin_code IS RECORD(state_code hr_lookups.lookup_code%TYPE,
11: pin_code hr_lookups.meaning%TYPE);
12: TYPE t_pin_code IS TABLE OF r_pin_code INDEX BY BINARY_INTEGER;
13: tab_pin_code t_pin_code;
14:
7: --
8:
9:
10: TYPE r_pin_code IS RECORD(state_code hr_lookups.lookup_code%TYPE,
11: pin_code hr_lookups.meaning%TYPE);
12: TYPE t_pin_code IS TABLE OF r_pin_code INDEX BY BINARY_INTEGER;
13: tab_pin_code t_pin_code;
14:
15: