APPS.OTA_LEARNER_ACCESS_UTIL dependencies on OTV_SCHEDULED_EVENTS

Line 29: p_event_start_date in otv_scheduled_events.course_start_date%type,

25: p_party_id in hz_parties.party_id%type,
26: p_event_id in ota_events.event_id%type,
27: p_public_event_flag in ota_events.public_event_flag%type,
28: p_max_internal in ota_events.maximum_internal_attendees%type,
29: p_event_start_date in otv_scheduled_events.course_start_date%type,
30: p_parent_offering_id in ota_events.parent_offering_id%type default null) return varchar2;
31:
32:
33: function learner_can_enroll(

Line 37: p_event_start_date in otv_scheduled_events.course_start_date%type,

33: function learner_can_enroll(
34: p_person_id in per_people_f.person_id%type,
35: p_party_id in hz_parties.party_id%type,
36: p_event_id in ota_events.event_id%type,
37: p_event_start_date in otv_scheduled_events.course_start_date%type,
38: p_parent_offering_id in ota_events.parent_offering_id%type default null) return varchar2;
39:
40: function learner_can_enroll(
41: p_person_id in per_people_f.person_id%type,

Line 51: p_event_start_date in otv_scheduled_events.course_start_date%type,

47: p_party_id in hz_parties.party_id%type,
48: p_event_id in ota_events.event_id%type,
49: p_public_event_flag in ota_events.public_event_flag%type,
50: p_max_internal in ota_events.maximum_internal_attendees%type,
51: p_event_start_date in otv_scheduled_events.course_start_date%type,
52: p_parent_offering_id in ota_events.parent_offering_id%type default null) return varchar2;
53:
54:
55: function learner_can_self_enroll(

Line 59: p_event_start_date in otv_scheduled_events.course_start_date%type,

55: function learner_can_self_enroll(
56: p_person_id in per_people_f.person_id%type,
57: p_party_id in hz_parties.party_id%type,
58: p_event_id in ota_events.event_id%type,
59: p_event_start_date in otv_scheduled_events.course_start_date%type,
60: p_parent_offering_id in ota_events.parent_offering_id%type default null) return varchar2;
61:
62: function learner_can_self_enroll(
63: p_person_id in per_people_f.person_id%type,

Line 72: p_event_start_date in otv_scheduled_events.course_start_date%type,

68: p_person_id in per_people_f.person_id%type,
69: p_event_id in ota_events.event_id%type,
70: p_public_event_flag ota_events.public_event_flag%type,
71: p_max_internal in ota_events.maximum_internal_attendees%type,
72: p_event_start_date in otv_scheduled_events.course_start_date%type,
73: p_parent_offering_id in ota_events.parent_offering_id%type default null) return varchar2;
74:
75:
76: function ext_learner_can_enroll(

Line 81: p_event_start_date in otv_scheduled_events.course_start_date%type,

77: p_party_id in hz_parties.party_id%type,
78: p_event_id in ota_events.event_id%type,
79: p_public_event_flag ota_events.public_event_flag%type,
80: p_max_internal in ota_events.maximum_internal_attendees%type,
81: p_event_start_date in otv_scheduled_events.course_start_date%type,
82: p_parent_offering_id in ota_events.parent_offering_id%type default null) return varchar2;
83:
84:
85: function chk_delegate_ok_for_event(

Line 88: p_event_start_date in otv_scheduled_events.course_start_date%type,

84:
85: function chk_delegate_ok_for_event(
86: p_delegate_id in per_people_f.person_id%type,
87: p_event_id in ota_events.event_id%type,
88: p_event_start_date in otv_scheduled_events.course_start_date%type,
89: p_parent_offering_id in ota_events.parent_offering_id%type default null) return varchar2;
90:
91:
92: function learner_can_see_category(