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 742: p_course_start_date otv_scheduled_events.course_start_date%type,

738:
739: cursor csr_assignments(
740: p_person_id per_people_f.person_id%type,
741: p_organization_id ota_event_associations.organization_id%type,
742: p_course_start_date otv_scheduled_events.course_start_date%type,
743: p_now date) is
744: select asg.assignment_id
745: from per_all_assignments_f asg
746: where asg.person_id = p_person_id and

Line 961: p_event_start_date in otv_scheduled_events.course_start_date%type,

957: p_person_id in per_people_f.person_id%type,
958: p_event_id in ota_events.event_id%type,
959: p_public_event_flag ota_events.public_event_flag%type,
960: p_max_internal in ota_events.maximum_internal_attendees%type,
961: p_event_start_date in otv_scheduled_events.course_start_date%type,
962: p_parent_offering_id in ota_events.parent_offering_id%type default null) return varchar2 is
963:
964: --Bug 547819
965: Cursor c_event_data is

Line 978: l_start_date otv_scheduled_events.course_start_date%type;

974: l_effective_start_date PER_ALL_PEOPLE_F.effective_start_date%type;
975: l_event_status ota_events.event_status%type;
976: l_secure_event_flag ota_events.secure_event_flag%type;
977: l_organization_id ota_events.organization_id%type;
978: l_start_date otv_scheduled_events.course_start_date%type;
979: l_is_secure_event boolean;
980: begin
981: --Bug 547819
982: Open c_event_data;

Line 1041: p_event_start_date in otv_scheduled_events.course_start_date%type,

1037: p_party_id in hz_parties.party_id%type,
1038: p_event_id in ota_events.event_id%type,
1039: p_public_event_flag ota_events.public_event_flag%type,
1040: p_max_internal in ota_events.maximum_internal_attendees%type,
1041: p_event_start_date in otv_scheduled_events.course_start_date%type,
1042: p_parent_offering_id in ota_events.parent_offering_id%type default null) return varchar2 is
1043: begin
1044: -- External learners can enroll if the event is public, or it is a non-customer event and
1045: -- the learner has been specifically given access via event associations.

Line 1084: p_event_start_date in otv_scheduled_events.course_start_date%type,

1080: p_party_id in hz_parties.party_id%type,
1081: p_event_id in ota_events.event_id%type,
1082: p_public_event_flag in ota_events.public_event_flag%type,
1083: p_max_internal in ota_events.maximum_internal_attendees%type,
1084: p_event_start_date in otv_scheduled_events.course_start_date%type,
1085: p_parent_offering_id in ota_events.parent_offering_id%type default null) return varchar2 is
1086: begin
1087: if p_person_id is not null then
1088: 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 1099: p_event_start_date in otv_scheduled_events.course_start_date%type,

1095: function learner_can_enroll(
1096: p_person_id in per_people_f.person_id%type,
1097: p_party_id in hz_parties.party_id%type,
1098: p_event_id in ota_events.event_id%type,
1099: p_event_start_date in otv_scheduled_events.course_start_date%type,
1100: p_parent_offering_id in ota_events.parent_offering_id%type default null) return varchar2 is
1101:
1102: v_public_event_flag ota_events.public_event_flag%type;
1103: v_max_internal ota_events.maximum_internal_attendees%type;

Line 1139: p_event_start_date in otv_scheduled_events.course_start_date%type,

1135: p_party_id in hz_parties.party_id%type,
1136: p_event_id in ota_events.event_id%type,
1137: p_public_event_flag in ota_events.public_event_flag%type,
1138: p_max_internal in ota_events.maximum_internal_attendees%type,
1139: p_event_start_date in otv_scheduled_events.course_start_date%type,
1140: p_parent_offering_id in ota_events.parent_offering_id%type default null) return varchar2 is
1141: begin
1142: if p_person_id is not null then
1143: return employee_can_self_enroll(p_person_id, p_event_id, p_public_event_flag, p_max_internal, p_parent_offering_id);

Line 1154: p_event_start_date in otv_scheduled_events.course_start_date%type,

1150: function learner_can_self_enroll(
1151: p_person_id in per_people_f.person_id%type,
1152: p_party_id in hz_parties.party_id%type,
1153: p_event_id in ota_events.event_id%type,
1154: p_event_start_date in otv_scheduled_events.course_start_date%type,
1155: p_parent_offering_id in ota_events.parent_offering_id%type default null) return varchar2 is
1156:
1157: v_public_event_flag ota_events.public_event_flag%type;
1158: v_max_internal ota_events.maximum_internal_attendees%type;

Line 1190: p_event_start_date in otv_scheduled_events.course_start_date%type,

1186:
1187: function chk_delegate_ok_for_event(
1188: p_delegate_id in per_people_f.person_id%type,
1189: p_event_id in ota_events.event_id%type,
1190: p_event_start_date in otv_scheduled_events.course_start_date%type,
1191: p_parent_offering_id in ota_events.parent_offering_id%type default null) return varchar2 is
1192: begin
1193: return learner_can_enroll(p_delegate_id, null, p_event_id, p_event_start_date, p_parent_offering_id);
1194: end chk_delegate_ok_for_event;