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 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 830: l_activity_version_id ota_activity_versions.activity_version_id%type;

826:
827: l_event_start_date ota_events.course_start_date%type;
828: l_now date := sysdate;
829: l_offering_id ota_offerings.offering_id%type;
830: l_activity_version_id ota_activity_versions.activity_version_id%type;
831: l_category_usage_id ota_category_usages.category_usage_id%type;
832: l_parent_cat_usage_id_1 ota_category_usages.category_usage_id%type;
833: l_parent_cat_usage_id_2 ota_category_usages.category_usage_id%type;
834: l_parent_cat_usage_id_3 ota_category_usages.category_usage_id%type;

Line 911: l_activity_version_id ota_activity_versions.activity_version_id%type;

907: p_event_id in ota_events.event_id%type,
908: p_self_enroll_only in varchar2) return varchar2 is
909:
910: l_offering_id ota_offerings.offering_id%type;
911: l_activity_version_id ota_activity_versions.activity_version_id%type;
912: l_category_usage_id ota_category_usages.category_usage_id%type;
913: l_parent_cat_usage_id_1 ota_category_usages.category_usage_id%type;
914: l_parent_cat_usage_id_2 ota_category_usages.category_usage_id%type;
915: l_parent_cat_usage_id_3 ota_category_usages.category_usage_id%type;

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

1221:
1222:
1223: function learner_can_see_course(
1224: p_person_id in per_people_f.person_id%type,
1225: p_activity_version_id in ota_activity_versions.activity_version_id%type) return varchar2 is
1226: begin
1227: return 'Y';
1228: end learner_can_see_course;
1229:

Line 2194: p_activity_version_id in ota_activity_versions.activity_version_id%type,

2190:
2191: function learner_has_access_to_course(
2192: p_person_id in per_people_f.person_id%type,
2193: p_party_id in hz_parties.party_id%type,
2194: p_activity_version_id in ota_activity_versions.activity_version_id%type,
2195: showLPOnlyClasses in varchar2 default 'N') return varchar2 is
2196:
2197: CURSOR csr_classes_in_course(
2198: p_activity_version_id in ota_activity_versions.activity_version_id%type,

Line 2198: p_activity_version_id in ota_activity_versions.activity_version_id%type,

2194: p_activity_version_id in ota_activity_versions.activity_version_id%type,
2195: showLPOnlyClasses in varchar2 default 'N') return varchar2 is
2196:
2197: CURSOR csr_classes_in_course(
2198: p_activity_version_id in ota_activity_versions.activity_version_id%type,
2199: p_business_group_id ota_events.business_group_id%type,
2200: p_server_timezone_code fnd_timezones_b.timezone_code%type) is
2201: SELECT OEV.event_id,
2202: OEV.public_event_flag,

Line 2208: ota_activity_versions OAV

2204: OEV.course_start_date
2205: FROM ota_category_usages OCU,
2206: ota_events OEV,
2207: ota_offerings OFR,
2208: ota_activity_versions OAV
2209: WHERE OAV.activity_version_id = p_activity_version_id
2210: AND OFR.activity_version_id = OAV.activity_version_id
2211: AND OEV.parent_offering_id = OFR.offering_id
2212: AND OEV.business_group_id = p_business_group_id

Line 2225: p_activity_version_id in ota_activity_versions.activity_version_id%type,

2221: AND to_date(to_char(nvl(OEV.enrolment_end_date,to_date('4712/12/31','YYYY/MM/DD')),'YYYY/MM/DD') || ' ' || '23:59', 'YYYY/MM/DD HH24:MI')
2222: ORDER BY OEV.public_event_flag DESC;
2223:
2224: CURSOR csr_normal_classes_in_course(
2225: p_activity_version_id in ota_activity_versions.activity_version_id%type,
2226: p_business_group_id ota_events.business_group_id%type,
2227: p_server_timezone_code fnd_timezones_b.timezone_code%type) is
2228: SELECT OEV.event_id,
2229: OEV.public_event_flag,

Line 2235: ota_activity_versions OAV

2231: OEV.course_start_date
2232: FROM ota_category_usages OCU,
2233: ota_events OEV,
2234: ota_offerings OFR,
2235: ota_activity_versions OAV
2236: WHERE OAV.activity_version_id = p_activity_version_id
2237: AND OFR.activity_version_id = OAV.activity_version_id
2238: AND OEV.parent_offering_id = OFR.offering_id
2239: AND OEV.business_group_id = p_business_group_id