22:
23: function learner_can_enroll(
24: p_person_id in per_people_f.person_id%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;
23: function learner_can_enroll(
24: p_person_id in per_people_f.person_id%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:
24: p_person_id in per_people_f.person_id%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:
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(
34: p_person_id in per_people_f.person_id%type,
32:
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(
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,
42: p_party_id in hz_parties.party_id%type,
39:
40: function learner_can_enroll(
41: p_person_id in per_people_f.person_id%type,
42: p_party_id in hz_parties.party_id%type,
43: p_event_id in ota_events.event_id%type) return varchar2;
44:
45: function learner_can_self_enroll(
46: p_person_id in per_people_f.person_id%type,
47: p_party_id in hz_parties.party_id%type,
44:
45: function learner_can_self_enroll(
46: p_person_id in per_people_f.person_id%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;
45: function learner_can_self_enroll(
46: p_person_id in per_people_f.person_id%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:
46: p_person_id in per_people_f.person_id%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:
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(
56: p_person_id in per_people_f.person_id%type,
54:
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(
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,
64: p_party_id in hz_parties.party_id%type,
61:
62: function learner_can_self_enroll(
63: p_person_id in per_people_f.person_id%type,
64: p_party_id in hz_parties.party_id%type,
65: p_event_id in ota_events.event_id%type) return varchar2;
66:
67: function employee_can_enroll(
68: p_person_id in per_people_f.person_id%type,
69: p_event_id in ota_events.event_id%type,
65: p_event_id in ota_events.event_id%type) return varchar2;
66:
67: function employee_can_enroll(
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;
66:
67: function employee_can_enroll(
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:
67: function employee_can_enroll(
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:
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(
77: p_party_id in hz_parties.party_id%type,
74:
75:
76: function ext_learner_can_enroll(
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;
75:
76: function ext_learner_can_enroll(
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:
76: function ext_learner_can_enroll(
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:
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(
86: p_delegate_id in per_people_f.person_id%type,
83:
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:
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(
93: p_person_id in per_people_f.person_id%type,
343: ,p_person_id in per_all_people_f.person_id%type
344: ,p_party_id in hz_parties.party_id%type) return varchar2;
345:
346: FUNCTION emp_has_valid_dates(p_person_id per_all_people_f.person_id%TYPE
347: ,p_event_id ota_events.event_id%TYPE) RETURN VARCHAR2;
348: function get_event_start_date(
349: p_event_id ota_events.event_id%type,
350: p_date date) return date;
351:
345:
346: FUNCTION emp_has_valid_dates(p_person_id per_all_people_f.person_id%TYPE
347: ,p_event_id ota_events.event_id%TYPE) RETURN VARCHAR2;
348: function get_event_start_date(
349: p_event_id ota_events.event_id%type,
350: p_date date) return date;
351:
352: FUNCTION learner_belongs_to_child_org(p_org_structure_version_id IN ota_event_associations. org_structure_version_id%type,
353: p_organization_id IN ota_event_associations.organization_id%type,