[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,
624: select oev.course_start_date, oev.course_end_date,ocu.synchronous_flag, oev.event_status
625: ,oev.timezone , oev.course_end_time
626: into l_event_start_date,l_event_end_date,l_synchronous_flag, l_event_status
627: ,l_timezone , l_event_end_time
628: from ota_events oev, ota_offerings ofr, ota_category_usages ocu
629: Where oev.event_id = p_event_id and
630: oev.parent_offering_id = ofr.offering_id and
631: ofr.delivery_mode_id = ocu.category_usage_id and
632: event_type in ('SCHEDULED','SELFPACED') and
825: p_self_enroll_only in varchar2) return varchar2 is
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;
906: p_party_id in hz_parties.party_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;
977: --Bug 547819
978: Cursor c_event_data is
979: Select OCU.synchronous_flag, OEV.event_status, OEV.secure_event_flag,
980: OEV.organization_id
981: From ota_events OEV, ota_offerings OFR, ota_category_usages OCU
982: Where OEV.event_id = p_event_id
983: And OEV.parent_offering_id = OFR.offering_id
984: And OFR.delivery_mode_id = OCU.category_usage_id;
985:
1229:
1230:
1231: function learner_can_see_offering(
1232: p_person_id in per_people_f.person_id%type,
1233: p_offering_id in ota_offerings.offering_id%type) return varchar2 is
1234: begin
1235: return 'Y';
1236: end learner_can_see_offering;
1237:
2203: OEV.maximum_internal_attendees,
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
2230: OEV.maximum_internal_attendees,
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