DBA Data[Home] [Help]

APPS.HR_DYNAMIC_APPROVAL_WEB dependencies on PER_PEOPLE_F

Line 11: full_name per_people_f.FULL_NAME%TYPE,

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'

Line 12: person_id per_people_f.person_id%TYPE,

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: );

Line 21: person_id per_people_f.person_id%TYPE,

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:

Line 27: full_name per_people_f.FULL_NAME%TYPE,

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',

Line 28: person_id per_people_f.person_id%TYPE,

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'