7: );
8:
9:
10: TYPE person_details IS RECORD (
11: full_name per_people_f.FULL_NAME%TYPE,
12: person_id per_people_f.person_id%TYPE,
13: job_title per_jobs.name%TYPE DEFAULT NULL,
14: default_approver VARCHAR2(10) DEFAULT 'N',
15: error_exists VARCHAR2(10) DEFAULT 'N'
8:
9:
10: TYPE person_details IS RECORD (
11: full_name per_people_f.FULL_NAME%TYPE,
12: person_id per_people_f.person_id%TYPE,
13: job_title per_jobs.name%TYPE DEFAULT NULL,
14: default_approver VARCHAR2(10) DEFAULT 'N',
15: error_exists VARCHAR2(10) DEFAULT 'N'
16: );
17:
18: TYPE t_person_table IS TABLE OF person_details INDEX BY BINARY_INTEGER;
19:
20: TYPE approver_rec IS RECORD (
21: person_id per_people_f.person_id%TYPE,
22: default_approver VARCHAR2(10) DEFAULT 'N'
23: );
24: TYPE approver_rec_table IS TABLE OF approver_rec INDEX BY BINARY_INTEGER;
25:
23: );
24: TYPE approver_rec_table IS TABLE OF approver_rec INDEX BY BINARY_INTEGER;
25:
26: TYPE notifier_rec IS RECORD (
27: full_name per_people_f.FULL_NAME%TYPE,
28: person_id per_people_f.person_id%TYPE,
29: job_title per_jobs.name%TYPE DEFAULT NULL,
30: on_submit VARCHAR2(10) DEFAULT 'Y',
31: on_approval VARCHAR2(10) DEFAULT 'Y',
24: TYPE approver_rec_table IS TABLE OF approver_rec INDEX BY BINARY_INTEGER;
25:
26: TYPE notifier_rec IS RECORD (
27: full_name per_people_f.FULL_NAME%TYPE,
28: person_id per_people_f.person_id%TYPE,
29: job_title per_jobs.name%TYPE DEFAULT NULL,
30: on_submit VARCHAR2(10) DEFAULT 'Y',
31: on_approval VARCHAR2(10) DEFAULT 'Y',
32: error_exists VARCHAR2(10) DEFAULT 'N'