[Home] [Help]
11: c2.parent_cat_usage_id as parent_cat_usage_id_2,
12: c3.parent_cat_usage_id as parent_cat_usage_id_3,
13: c4.parent_cat_usage_id as parent_cat_usage_id_4
14: from ota_events e,
15: ota_offerings o,
16: ota_act_cat_inclusions i,
17: ota_category_usages c1,
18: ota_category_usages c2,
19: ota_category_usages c3,
110:
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,
185: cursor csr_evt_assoc_ext(
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,
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
541: AND OEV.parent_offering_id = OFR.offering_id
542: AND OEV.business_group_id = ota_general.get_business_group_id
642: select oev.course_start_date, oev.course_end_date,ocu.synchronous_flag, oev.event_status
643: ,oev.timezone , oev.course_end_time
644: into l_event_start_date,l_event_end_date,l_synchronous_flag, l_event_status
645: ,l_timezone , l_event_end_time
646: from ota_events oev, ota_offerings ofr, ota_category_usages ocu
647: Where oev.event_id = p_event_id and
648: oev.parent_offering_id = ofr.offering_id and
649: ofr.delivery_mode_id = ocu.category_usage_id and
650: event_type in ('SCHEDULED','SELFPACED') and
816: p_self_enroll_only in varchar2) return varchar2 is
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;
893: p_party_id in hz_parties.party_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;
964: --Bug 547819
965: Cursor c_event_data is
966: Select OCU.synchronous_flag, OEV.event_status, OEV.secure_event_flag,
967: OEV.organization_id
968: From ota_events OEV, ota_offerings OFR, ota_category_usages OCU
969: Where OEV.event_id = p_event_id
970: And OEV.parent_offering_id = OFR.offering_id
971: And OFR.delivery_mode_id = OCU.category_usage_id;
972:
1216:
1217:
1218: function learner_can_see_offering(
1219: p_person_id in per_people_f.person_id%type,
1220: p_offering_id in ota_offerings.offering_id%type) return varchar2 is
1221: begin
1222: return 'Y';
1223: end learner_can_see_offering;
1224: