APPS.OTA_MANDATORY_ENROLL_UTIL dependencies on DBMS_SQL

Line 15: enr_prereq_type dbms_sql.varchar2_table,

11: p_event_id IN NUMBER) IS
12:
13:
14: TYPE mandatory_event_assoc_rec IS RECORD(
15: enr_prereq_type dbms_sql.varchar2_table,
16: event_id dbms_sql.number_table,
17: person_id dbms_sql.number_table,
18: organization_id dbms_sql.number_table,
19: job_id dbms_sql.number_table,

Line 16: event_id dbms_sql.number_table,

12:
13:
14: TYPE mandatory_event_assoc_rec IS RECORD(
15: enr_prereq_type dbms_sql.varchar2_table,
16: event_id dbms_sql.number_table,
17: person_id dbms_sql.number_table,
18: organization_id dbms_sql.number_table,
19: job_id dbms_sql.number_table,
20: position_id dbms_sql.varchar2_table,

Line 17: person_id dbms_sql.number_table,

13:
14: TYPE mandatory_event_assoc_rec IS RECORD(
15: enr_prereq_type dbms_sql.varchar2_table,
16: event_id dbms_sql.number_table,
17: person_id dbms_sql.number_table,
18: organization_id dbms_sql.number_table,
19: job_id dbms_sql.number_table,
20: position_id dbms_sql.varchar2_table,
21: org_structure_version_id dbms_sql.number_table,

Line 18: organization_id dbms_sql.number_table,

14: TYPE mandatory_event_assoc_rec IS RECORD(
15: enr_prereq_type dbms_sql.varchar2_table,
16: event_id dbms_sql.number_table,
17: person_id dbms_sql.number_table,
18: organization_id dbms_sql.number_table,
19: job_id dbms_sql.number_table,
20: position_id dbms_sql.varchar2_table,
21: org_structure_version_id dbms_sql.number_table,
22: user_group_id dbms_sql.number_table,

Line 19: job_id dbms_sql.number_table,

15: enr_prereq_type dbms_sql.varchar2_table,
16: event_id dbms_sql.number_table,
17: person_id dbms_sql.number_table,
18: organization_id dbms_sql.number_table,
19: job_id dbms_sql.number_table,
20: position_id dbms_sql.varchar2_table,
21: org_structure_version_id dbms_sql.number_table,
22: user_group_id dbms_sql.number_table,
23: requestor_id dbms_sql.number_table

Line 20: position_id dbms_sql.varchar2_table,

16: event_id dbms_sql.number_table,
17: person_id dbms_sql.number_table,
18: organization_id dbms_sql.number_table,
19: job_id dbms_sql.number_table,
20: position_id dbms_sql.varchar2_table,
21: org_structure_version_id dbms_sql.number_table,
22: user_group_id dbms_sql.number_table,
23: requestor_id dbms_sql.number_table
24: );

Line 21: org_structure_version_id dbms_sql.number_table,

17: person_id dbms_sql.number_table,
18: organization_id dbms_sql.number_table,
19: job_id dbms_sql.number_table,
20: position_id dbms_sql.varchar2_table,
21: org_structure_version_id dbms_sql.number_table,
22: user_group_id dbms_sql.number_table,
23: requestor_id dbms_sql.number_table
24: );
25:

Line 22: user_group_id dbms_sql.number_table,

18: organization_id dbms_sql.number_table,
19: job_id dbms_sql.number_table,
20: position_id dbms_sql.varchar2_table,
21: org_structure_version_id dbms_sql.number_table,
22: user_group_id dbms_sql.number_table,
23: requestor_id dbms_sql.number_table
24: );
25:
26: l_rec mandatory_event_assoc_rec;

Line 23: requestor_id dbms_sql.number_table

19: job_id dbms_sql.number_table,
20: position_id dbms_sql.varchar2_table,
21: org_structure_version_id dbms_sql.number_table,
22: user_group_id dbms_sql.number_table,
23: requestor_id dbms_sql.number_table
24: );
25:
26: l_rec mandatory_event_assoc_rec;
27: l_date ota_events.course_end_date%type;