eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OTA_LEARNER_ACCESS_UTIL dependencies on OTV_SCHEDULED_EVENTS

Line 724: p_course_start_date otv_scheduled_events.course_start_date%type,

720:
721: cursor csr_assignments(
722: p_person_id per_people_f.person_id%type,
723: p_organization_id ota_event_associations.organization_id%type,
724: p_course_start_date otv_scheduled_events.course_start_date%type,
725: p_now date) is
726: select asg.assignment_id
727: from per_all_assignments_f asg
728: where asg.person_id = p_person_id and

Line 974: p_event_start_date in otv_scheduled_events.course_start_date%type,

970: p_person_id in per_people_f.person_id%type,
971: p_event_id in ota_events.event_id%type,
972: p_public_event_flag ota_events.public_event_flag%type,
973: p_max_internal in ota_events.maximum_internal_attendees%type,
974: p_event_start_date in otv_scheduled_events.course_start_date%type,
975: p_parent_offering_id in ota_events.parent_offering_id%type default null) return varchar2 is
976:
977: --Bug 547819
978: Cursor c_event_data is

Line 991: l_start_date otv_scheduled_events.course_start_date%type;

987: l_effective_start_date PER_ALL_PEOPLE_F.effective_start_date%type;
988: l_event_status ota_events.event_status%type;
989: l_secure_event_flag ota_events.secure_event_flag%type;
990: l_organization_id ota_events.organization_id%type;
991: l_start_date otv_scheduled_events.course_start_date%type;
992: l_is_secure_event boolean;
993: begin
994: --Bug 547819
995: Open c_event_data;

Line 1054: p_event_start_date in otv_scheduled_events.course_start_date%type,

1050: p_party_id in hz_parties.party_id%type,
1051: p_event_id in ota_events.event_id%type,
1052: p_public_event_flag ota_events.public_event_flag%type,
1053: p_max_internal in ota_events.maximum_internal_attendees%type,
1054: p_event_start_date in otv_scheduled_events.course_start_date%type,
1055: p_parent_offering_id in ota_events.parent_offering_id%type default null) return varchar2 is
1056: begin
1057: -- External learners can enroll if the event is public, or it is a non-customer event and
1058: -- the learner has been specifically given access via event associations.

Line 1097: p_event_start_date in otv_scheduled_events.course_start_date%type,

1093: p_party_id in hz_parties.party_id%type,
1094: p_event_id in ota_events.event_id%type,
1095: p_public_event_flag in ota_events.public_event_flag%type,
1096: p_max_internal in ota_events.maximum_internal_attendees%type,
1097: p_event_start_date in otv_scheduled_events.course_start_date%type,
1098: p_parent_offering_id in ota_events.parent_offering_id%type default null) return varchar2 is
1099: begin
1100: if p_person_id is not null then
1101: return employee_can_enroll(p_person_id, p_event_id, p_public_event_flag, p_max_internal, p_event_start_date, p_parent_offering_id);

Line 1112: p_event_start_date in otv_scheduled_events.course_start_date%type,

1108: function learner_can_enroll(
1109: p_person_id in per_people_f.person_id%type,
1110: p_party_id in hz_parties.party_id%type,
1111: p_event_id in ota_events.event_id%type,
1112: p_event_start_date in otv_scheduled_events.course_start_date%type,
1113: p_parent_offering_id in ota_events.parent_offering_id%type default null) return varchar2 is
1114:
1115: v_public_event_flag ota_events.public_event_flag%type;
1116: v_max_internal ota_events.maximum_internal_attendees%type;

Line 1152: p_event_start_date in otv_scheduled_events.course_start_date%type,

1148: p_party_id in hz_parties.party_id%type,
1149: p_event_id in ota_events.event_id%type,
1150: p_public_event_flag in ota_events.public_event_flag%type,
1151: p_max_internal in ota_events.maximum_internal_attendees%type,
1152: p_event_start_date in otv_scheduled_events.course_start_date%type,
1153: p_parent_offering_id in ota_events.parent_offering_id%type default null) return varchar2 is
1154: begin
1155: if p_person_id is not null then
1156: return employee_can_self_enroll(p_person_id, p_event_id, p_public_event_flag, p_max_internal, p_parent_offering_id);

Line 1167: p_event_start_date in otv_scheduled_events.course_start_date%type,

1163: function learner_can_self_enroll(
1164: p_person_id in per_people_f.person_id%type,
1165: p_party_id in hz_parties.party_id%type,
1166: p_event_id in ota_events.event_id%type,
1167: p_event_start_date in otv_scheduled_events.course_start_date%type,
1168: p_parent_offering_id in ota_events.parent_offering_id%type default null) return varchar2 is
1169:
1170: v_public_event_flag ota_events.public_event_flag%type;
1171: v_max_internal ota_events.maximum_internal_attendees%type;

Line 1203: p_event_start_date in otv_scheduled_events.course_start_date%type,

1199:
1200: function chk_delegate_ok_for_event(
1201: p_delegate_id in per_people_f.person_id%type,
1202: p_event_id in ota_events.event_id%type,
1203: p_event_start_date in otv_scheduled_events.course_start_date%type,
1204: p_parent_offering_id in ota_events.parent_offering_id%type default null) return varchar2 is
1205: begin
1206: return learner_can_enroll(p_delegate_id, null, p_event_id, p_event_start_date, p_parent_offering_id);
1207: end chk_delegate_ok_for_event;