APPS.OTA_LEARNER_ACCESS_UTIL dependencies on OTA_ACTIVITY_VERSIONS

Line 115: p_activity_version_id ota_activity_versions.activity_version_id%type,

111: cursor csr_evt_assoc(
112: p_self_enroll_only varchar2,
113: p_event_id ota_events.event_id%type,
114: p_offering_id ota_offerings.offering_id%type,
115: p_activity_version_id ota_activity_versions.activity_version_id%type,
116: p_category_usage_id ota_category_usages.category_usage_id%type,
117: p_parent_cat_usage_id_1 ota_category_usages.category_usage_id%type,
118: p_parent_cat_usage_id_2 ota_category_usages.category_usage_id%type,
119: p_parent_cat_usage_id_3 ota_category_usages.category_usage_id%type,

Line 190: p_activity_version_id ota_activity_versions.activity_version_id%type,

186: p_self_enroll_only varchar2,
187: p_party_id hz_parties.party_id%type,
188: p_event_id ota_events.event_id%type,
189: p_offering_id ota_offerings.offering_id%type,
190: p_activity_version_id ota_activity_versions.activity_version_id%type,
191: p_category_usage_id ota_category_usages.category_usage_id%type,
192: p_parent_cat_usage_id_1 ota_category_usages.category_usage_id%type,
193: p_parent_cat_usage_id_2 ota_category_usages.category_usage_id%type,
194: p_parent_cat_usage_id_3 ota_category_usages.category_usage_id%type,

Line 531: p_activity_version_id in ota_activity_versions.activity_version_id%type) is

527: asg.assignment_type in ('E','A','C');
528:
529:
530: CURSOR csr_classes_in_course(
531: p_activity_version_id in ota_activity_versions.activity_version_id%type) is
532: SELECT OEV.event_id,
533: OEV.public_event_flag,
534: OEV.maximum_internal_attendees,
535: OEV.course_start_date

Line 536: FROM ota_activity_versions_vl OAV,

532: SELECT OEV.event_id,
533: OEV.public_event_flag,
534: OEV.maximum_internal_attendees,
535: OEV.course_start_date
536: FROM ota_activity_versions_vl OAV,
537: ota_events_vl OEV,
538: ota_offerings_vl OFR,
539: ota_category_usages OCU
540: WHERE OFR.activity_version_id = OAV.activity_version_id

Line 821: l_activity_version_id ota_activity_versions.activity_version_id%type;

817:
818: l_event_start_date ota_events.course_start_date%type;
819: l_now date := sysdate;
820: l_offering_id ota_offerings.offering_id%type;
821: l_activity_version_id ota_activity_versions.activity_version_id%type;
822: l_category_usage_id ota_category_usages.category_usage_id%type;
823: l_parent_cat_usage_id_1 ota_category_usages.category_usage_id%type;
824: l_parent_cat_usage_id_2 ota_category_usages.category_usage_id%type;
825: l_parent_cat_usage_id_3 ota_category_usages.category_usage_id%type;

Line 898: l_activity_version_id ota_activity_versions.activity_version_id%type;

894: p_event_id in ota_events.event_id%type,
895: p_self_enroll_only in varchar2) return varchar2 is
896:
897: l_offering_id ota_offerings.offering_id%type;
898: l_activity_version_id ota_activity_versions.activity_version_id%type;
899: l_category_usage_id ota_category_usages.category_usage_id%type;
900: l_parent_cat_usage_id_1 ota_category_usages.category_usage_id%type;
901: l_parent_cat_usage_id_2 ota_category_usages.category_usage_id%type;
902: l_parent_cat_usage_id_3 ota_category_usages.category_usage_id%type;

Line 1212: p_activity_version_id in ota_activity_versions.activity_version_id%type) return varchar2 is

1208:
1209:
1210: function learner_can_see_course(
1211: p_person_id in per_people_f.person_id%type,
1212: p_activity_version_id in ota_activity_versions.activity_version_id%type) return varchar2 is
1213: begin
1214: return 'Y';
1215: end learner_can_see_course;
1216:

Line 2181: p_activity_version_id in ota_activity_versions.activity_version_id%type) return varchar2 is

2177:
2178: function learner_has_access_to_course(
2179: p_person_id in per_people_f.person_id%type,
2180: p_party_id in hz_parties.party_id%type,
2181: p_activity_version_id in ota_activity_versions.activity_version_id%type) return varchar2 is
2182:
2183: begin
2184:
2185: for assoc in csr_classes_in_course(p_activity_version_id) loop