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_EVENTS

Line 8: p_event_id ota_events.event_id%type) is

4: person_ug_map_rec_table ota_learner_access_util.person_ug_map_table;
5: t_ug_learner_list_table ota_learner_access_util.ug_learner_list_table;
6:
7: cursor csr_evt_tree(
8: p_event_id ota_events.event_id%type) is
9: select o.offering_id, i.activity_version_id, i.category_usage_id,
10: c1.parent_cat_usage_id as parent_cat_usage_id_1,
11: c2.parent_cat_usage_id as parent_cat_usage_id_2,
12: c3.parent_cat_usage_id as parent_cat_usage_id_3,

Line 14: from ota_events e,

10: c1.parent_cat_usage_id as parent_cat_usage_id_1,
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,

Line 113: p_event_id ota_events.event_id%type,

109:
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,

Line 135: p_event_id ota_events.event_id%type,

131:
132:
133: /*Bug 7046019- Modified cursor check_mandatory_evt_assoc to include learner groups
134: Cursor check_mandatory_evt_assoc(
135: p_event_id ota_events.event_id%type,
136: p_person_id ota_event_associations.person_id%type,
137: p_as_of in date
138: ) is
139: select ea.event_association_id

Line 160: p_event_id ota_events.event_id%type,

156: ( ea.org_structure_version_id IS NOT NULL AND learner_belongs_to_child_org(ea.org_structure_version_id,ea.organization_id,paf.person_id)='Y')
157: );*/
158:
159: Cursor check_mandatory_evt_assoc(
160: p_event_id ota_events.event_id%type,
161: p_person_id ota_event_associations.person_id%type,
162: p_as_of in date
163: ) is
164: select ea.event_association_id

Line 188: p_event_id ota_events.event_id%type,

184:
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,

Line 588: function is_customer_event(p_event_id in ota_events.event_id%type) return boolean is

584: trunc(sysdate) between trunc(nvl(ugb.start_date_active, sysdate)) and trunc(nvl(ugb.end_date_active, sysdate+1))) --Bug#7120108
585: and (uge.business_group_id = p_business_group_id or p_business_group_id = -1)
586: and (uge.person_id is null OR uge.elig_prfl_id is null);
587:
588: function is_customer_event(p_event_id in ota_events.event_id%type) return boolean is
589:
590: cursor customer_assoc is
591: select 1
592: from ota_event_associations

Line 608: p_event_id ota_events.event_id%type,

604: end is_customer_event;
605:
606:
607: function get_event_start_date(
608: p_event_id ota_events.event_id%type,
609: p_date date) return date is
610:
611: l_event_start_date ota_events.course_start_date%type;
612: --l_date date := trunc(p_date);

Line 611: l_event_start_date ota_events.course_start_date%type;

607: function get_event_start_date(
608: p_event_id ota_events.event_id%type,
609: p_date date) return date is
610:
611: l_event_start_date ota_events.course_start_date%type;
612: --l_date date := trunc(p_date);
613:
614: l_start_date ota_events.course_start_date%type;
615: l_synchronous_flag ota_category_usages.synchronous_flag%type;

Line 614: l_start_date ota_events.course_start_date%type;

610:
611: l_event_start_date ota_events.course_start_date%type;
612: --l_date date := trunc(p_date);
613:
614: l_start_date ota_events.course_start_date%type;
615: l_synchronous_flag ota_category_usages.synchronous_flag%type;
616: l_event_status ota_events.event_status%type;
617: l_event_end_date ota_events.course_end_date%type;
618: l_event_end_time ota_events.course_end_time%type;

Line 616: l_event_status ota_events.event_status%type;

612: --l_date date := trunc(p_date);
613:
614: l_start_date ota_events.course_start_date%type;
615: l_synchronous_flag ota_category_usages.synchronous_flag%type;
616: l_event_status ota_events.event_status%type;
617: l_event_end_date ota_events.course_end_date%type;
618: l_event_end_time ota_events.course_end_time%type;
619: l_timezone ota_events.timezone%type;
620: begin

Line 617: l_event_end_date ota_events.course_end_date%type;

613:
614: l_start_date ota_events.course_start_date%type;
615: l_synchronous_flag ota_category_usages.synchronous_flag%type;
616: l_event_status ota_events.event_status%type;
617: l_event_end_date ota_events.course_end_date%type;
618: l_event_end_time ota_events.course_end_time%type;
619: l_timezone ota_events.timezone%type;
620: begin
621: -- Modified this function for bug#4393763 to return

Line 618: l_event_end_time ota_events.course_end_time%type;

614: l_start_date ota_events.course_start_date%type;
615: l_synchronous_flag ota_category_usages.synchronous_flag%type;
616: l_event_status ota_events.event_status%type;
617: l_event_end_date ota_events.course_end_date%type;
618: l_event_end_time ota_events.course_end_time%type;
619: l_timezone ota_events.timezone%type;
620: begin
621: -- Modified this function for bug#4393763 to return
622: -- course_end_Date for synchronous class

Line 619: l_timezone ota_events.timezone%type;

615: l_synchronous_flag ota_category_usages.synchronous_flag%type;
616: l_event_status ota_events.event_status%type;
617: l_event_end_date ota_events.course_end_date%type;
618: l_event_end_time ota_events.course_end_time%type;
619: l_timezone ota_events.timezone%type;
620: begin
621: -- Modified this function for bug#4393763 to return
622: -- course_end_Date for synchronous class
623: -- sysdate for asynchronous class and 'Planned' status class

Line 628: from ota_events oev, ota_offerings ofr, ota_category_usages ocu

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

Line 718: p_event_id in ota_events.event_id%type,

714:
715:
716: function emp_matches_org(
717: p_person_id in per_people_f.person_id%type,
718: p_event_id in ota_events.event_id%type,
719: p_organization_id in ota_events.organization_id%type) return varchar2 is
720:
721: cursor csr_assignments(
722: p_person_id per_people_f.person_id%type,

Line 719: p_organization_id in ota_events.organization_id%type) return varchar2 is

715:
716: function emp_matches_org(
717: p_person_id in per_people_f.person_id%type,
718: p_event_id in ota_events.event_id%type,
719: p_organization_id in ota_events.organization_id%type) return varchar2 is
720:
721: cursor csr_assignments(
722: p_person_id per_people_f.person_id%type,
723: p_organization_id ota_event_associations.organization_id%type,

Line 733: l_event_start_date ota_events.course_start_date%type;

729: nvl(p_course_start_date, trunc(p_now)) between asg.effective_start_date and asg.effective_end_date and
730: p_organization_id = asg.organization_id and
731: asg.assignment_type in ('E','A','C');
732: l_now date;
733: l_event_start_date ota_events.course_start_date%type;
734: begin
735: l_now := sysdate;
736: -- Bug 4584737: if no data found, event has expired or does not exist. Return 'N'.
737: begin

Line 799: p_event_id ota_events.event_id%type

795:
796: --Checks whether user enrolled for the class or not
797: function is_user_enrolled(
798: p_user_id fnd_user.user_id%type,
799: p_event_id ota_events.event_id%type
800: ) return boolean is
801:
802: cursor person_bookings(
803: p_event_id ota_events.event_id%type,

Line 803: p_event_id ota_events.event_id%type,

799: p_event_id ota_events.event_id%type
800: ) return boolean is
801:
802: cursor person_bookings(
803: p_event_id ota_events.event_id%type,
804: p_person_id per_all_people.person_id%type) is
805: select 1
806: from ota_delegate_bookings book,
807: ota_booking_status_types stype

Line 824: p_event_id in ota_events.event_id%type,

820:
821:
822: function emp_has_access(
823: p_person_id in per_people_f.person_id%type,
824: p_event_id in ota_events.event_id%type,
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;

Line 827: l_event_start_date ota_events.course_start_date%type;

823: p_person_id in per_people_f.person_id%type,
824: p_event_id in ota_events.event_id%type,
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;

Line 907: p_event_id in ota_events.event_id%type,

903:
904:
905: function ext_has_access(
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;

Line 942: ,p_event_id ota_events.event_id%TYPE)

938: return 'N';
939: end ext_has_access;
940:
941: FUNCTION emp_has_valid_dates(p_person_id per_all_people_f.person_id%TYPE
942: ,p_event_id ota_events.event_id%TYPE)
943: RETURN VARCHAR2 IS
944: l_event_start_date DATE;
945: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
946: BEGIN

Line 971: p_event_id in ota_events.event_id%type,

967:
968:
969: function employee_can_enroll(
970: p_person_id in per_people_f.person_id%type,
971: p_event_id in ota_events.event_id%type,
972: p_public_event_flag ota_events.public_event_flag%type,
973: p_max_internal in ota_events.maximum_internal_attendees%type,
974: p_event_start_date in otv_scheduled_events.course_start_date%type,
975: p_parent_offering_id in ota_events.parent_offering_id%type default null) return varchar2 is

Line 972: p_public_event_flag ota_events.public_event_flag%type,

968:
969: function employee_can_enroll(
970: p_person_id in per_people_f.person_id%type,
971: p_event_id in ota_events.event_id%type,
972: p_public_event_flag ota_events.public_event_flag%type,
973: p_max_internal in ota_events.maximum_internal_attendees%type,
974: p_event_start_date in otv_scheduled_events.course_start_date%type,
975: p_parent_offering_id in ota_events.parent_offering_id%type default null) return varchar2 is
976:

Line 973: p_max_internal in ota_events.maximum_internal_attendees%type,

969: function employee_can_enroll(
970: p_person_id in per_people_f.person_id%type,
971: p_event_id in ota_events.event_id%type,
972: p_public_event_flag ota_events.public_event_flag%type,
973: p_max_internal in ota_events.maximum_internal_attendees%type,
974: p_event_start_date in otv_scheduled_events.course_start_date%type,
975: p_parent_offering_id in ota_events.parent_offering_id%type default null) return varchar2 is
976:
977: --Bug 547819

Line 975: p_parent_offering_id in ota_events.parent_offering_id%type default null) return varchar2 is

971: p_event_id in ota_events.event_id%type,
972: p_public_event_flag ota_events.public_event_flag%type,
973: p_max_internal in ota_events.maximum_internal_attendees%type,
974: p_event_start_date in otv_scheduled_events.course_start_date%type,
975: p_parent_offering_id in ota_events.parent_offering_id%type default null) return varchar2 is
976:
977: --Bug 547819
978: Cursor c_event_data is
979: Select OCU.synchronous_flag, OEV.event_status, OEV.secure_event_flag,

Line 981: From ota_events OEV, ota_offerings OFR, ota_category_usages OCU

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:

Line 988: l_event_status ota_events.event_status%type;

984: And OFR.delivery_mode_id = OCU.category_usage_id;
985:
986: l_synchronous_flag ota_category_usages.synchronous_flag%type;
987: l_effective_start_date PER_ALL_PEOPLE_F.effective_start_date%type;
988: l_event_status ota_events.event_status%type;
989: l_secure_event_flag ota_events.secure_event_flag%type;
990: l_organization_id ota_events.organization_id%type;
991: l_start_date otv_scheduled_events.course_start_date%type;
992: l_is_secure_event boolean;

Line 989: l_secure_event_flag ota_events.secure_event_flag%type;

985:
986: l_synchronous_flag ota_category_usages.synchronous_flag%type;
987: l_effective_start_date PER_ALL_PEOPLE_F.effective_start_date%type;
988: l_event_status ota_events.event_status%type;
989: l_secure_event_flag ota_events.secure_event_flag%type;
990: l_organization_id ota_events.organization_id%type;
991: l_start_date otv_scheduled_events.course_start_date%type;
992: l_is_secure_event boolean;
993: begin

Line 990: l_organization_id ota_events.organization_id%type;

986: l_synchronous_flag ota_category_usages.synchronous_flag%type;
987: l_effective_start_date PER_ALL_PEOPLE_F.effective_start_date%type;
988: l_event_status ota_events.event_status%type;
989: l_secure_event_flag ota_events.secure_event_flag%type;
990: l_organization_id ota_events.organization_id%type;
991: l_start_date otv_scheduled_events.course_start_date%type;
992: l_is_secure_event boolean;
993: begin
994: --Bug 547819

Line 1032: p_event_id in ota_events.event_id%type,

1028:
1029:
1030: function employee_can_self_enroll(
1031: p_person_id in per_people_f.person_id%type,
1032: p_event_id in ota_events.event_id%type,
1033: p_public_event_flag ota_events.public_event_flag%type,
1034: p_max_internal in ota_events.maximum_internal_attendees%type,
1035: p_parent_offering_id in ota_events.parent_offering_id%type default null) return varchar2 is
1036: begin

Line 1033: p_public_event_flag ota_events.public_event_flag%type,

1029:
1030: function employee_can_self_enroll(
1031: p_person_id in per_people_f.person_id%type,
1032: p_event_id in ota_events.event_id%type,
1033: p_public_event_flag ota_events.public_event_flag%type,
1034: p_max_internal in ota_events.maximum_internal_attendees%type,
1035: p_parent_offering_id in ota_events.parent_offering_id%type default null) return varchar2 is
1036: begin
1037: -- Employees may not enroll if MAXIMUM_INTERNAL_ATTENDEES is zero.

Line 1034: p_max_internal in ota_events.maximum_internal_attendees%type,

1030: function employee_can_self_enroll(
1031: p_person_id in per_people_f.person_id%type,
1032: p_event_id in ota_events.event_id%type,
1033: p_public_event_flag ota_events.public_event_flag%type,
1034: p_max_internal in ota_events.maximum_internal_attendees%type,
1035: p_parent_offering_id in ota_events.parent_offering_id%type default null) return varchar2 is
1036: begin
1037: -- Employees may not enroll if MAXIMUM_INTERNAL_ATTENDEES is zero.
1038: -- Self-enrollment can only be specified via event associations. Therefore,

Line 1035: p_parent_offering_id in ota_events.parent_offering_id%type default null) return varchar2 is

1031: p_person_id in per_people_f.person_id%type,
1032: p_event_id in ota_events.event_id%type,
1033: p_public_event_flag ota_events.public_event_flag%type,
1034: p_max_internal in ota_events.maximum_internal_attendees%type,
1035: p_parent_offering_id in ota_events.parent_offering_id%type default null) return varchar2 is
1036: begin
1037: -- Employees may not enroll if MAXIMUM_INTERNAL_ATTENDEES is zero.
1038: -- Self-enrollment can only be specified via event associations. Therefore,
1039: -- public events or customer events can never be self-enrollable.

Line 1051: p_event_id in ota_events.event_id%type,

1047:
1048:
1049: function ext_learner_can_enroll(
1050: p_party_id in hz_parties.party_id%type,
1051: p_event_id in ota_events.event_id%type,
1052: p_public_event_flag ota_events.public_event_flag%type,
1053: p_max_internal in ota_events.maximum_internal_attendees%type,
1054: p_event_start_date in otv_scheduled_events.course_start_date%type,
1055: p_parent_offering_id in ota_events.parent_offering_id%type default null) return varchar2 is

Line 1052: p_public_event_flag ota_events.public_event_flag%type,

1048:
1049: function ext_learner_can_enroll(
1050: p_party_id in hz_parties.party_id%type,
1051: p_event_id in ota_events.event_id%type,
1052: p_public_event_flag ota_events.public_event_flag%type,
1053: p_max_internal in ota_events.maximum_internal_attendees%type,
1054: p_event_start_date in otv_scheduled_events.course_start_date%type,
1055: p_parent_offering_id in ota_events.parent_offering_id%type default null) return varchar2 is
1056: begin

Line 1053: p_max_internal in ota_events.maximum_internal_attendees%type,

1049: function ext_learner_can_enroll(
1050: p_party_id in hz_parties.party_id%type,
1051: p_event_id in ota_events.event_id%type,
1052: p_public_event_flag ota_events.public_event_flag%type,
1053: p_max_internal in ota_events.maximum_internal_attendees%type,
1054: p_event_start_date in otv_scheduled_events.course_start_date%type,
1055: p_parent_offering_id in ota_events.parent_offering_id%type default null) return varchar2 is
1056: begin
1057: -- External learners can enroll if the event is public, or it is a non-customer event and

Line 1055: p_parent_offering_id in ota_events.parent_offering_id%type default null) return varchar2 is

1051: p_event_id in ota_events.event_id%type,
1052: p_public_event_flag ota_events.public_event_flag%type,
1053: p_max_internal in ota_events.maximum_internal_attendees%type,
1054: p_event_start_date in otv_scheduled_events.course_start_date%type,
1055: p_parent_offering_id in ota_events.parent_offering_id%type default null) return varchar2 is
1056: begin
1057: -- External learners can enroll if the event is public, or it is a non-customer event and
1058: -- the learner has been specifically given access via event associations.
1059:

Line 1075: p_event_id in ota_events.event_id%type,

1071:
1072:
1073: function ext_learner_can_self_enroll(
1074: p_party_id in hz_parties.party_id%type,
1075: p_event_id in ota_events.event_id%type,
1076: p_public_event_flag ota_events.public_event_flag%type,
1077: p_max_internal in ota_events.maximum_internal_attendees%type,
1078: p_parent_offering_id in ota_events.parent_offering_id%type default null) return varchar2 is
1079: begin

Line 1076: p_public_event_flag ota_events.public_event_flag%type,

1072:
1073: function ext_learner_can_self_enroll(
1074: p_party_id in hz_parties.party_id%type,
1075: p_event_id in ota_events.event_id%type,
1076: p_public_event_flag ota_events.public_event_flag%type,
1077: p_max_internal in ota_events.maximum_internal_attendees%type,
1078: p_parent_offering_id in ota_events.parent_offering_id%type default null) return varchar2 is
1079: begin
1080: -- Self-enrollment can only be specified via event associations. Therefore,

Line 1077: p_max_internal in ota_events.maximum_internal_attendees%type,

1073: function ext_learner_can_self_enroll(
1074: p_party_id in hz_parties.party_id%type,
1075: p_event_id in ota_events.event_id%type,
1076: p_public_event_flag ota_events.public_event_flag%type,
1077: p_max_internal in ota_events.maximum_internal_attendees%type,
1078: p_parent_offering_id in ota_events.parent_offering_id%type default null) return varchar2 is
1079: begin
1080: -- Self-enrollment can only be specified via event associations. Therefore,
1081: -- public events or customer events can never be self-enrollable.

Line 1078: p_parent_offering_id in ota_events.parent_offering_id%type default null) return varchar2 is

1074: p_party_id in hz_parties.party_id%type,
1075: p_event_id in ota_events.event_id%type,
1076: p_public_event_flag ota_events.public_event_flag%type,
1077: p_max_internal in ota_events.maximum_internal_attendees%type,
1078: p_parent_offering_id in ota_events.parent_offering_id%type default null) return varchar2 is
1079: begin
1080: -- Self-enrollment can only be specified via event associations. Therefore,
1081: -- public events or customer events can never be self-enrollable.
1082: if p_public_event_flag = 'Y' or is_customer_event(p_event_id) then

Line 1094: p_event_id in ota_events.event_id%type,

1090:
1091: function learner_can_enroll(
1092: p_person_id in per_people_f.person_id%type,
1093: p_party_id in hz_parties.party_id%type,
1094: p_event_id in ota_events.event_id%type,
1095: p_public_event_flag in ota_events.public_event_flag%type,
1096: p_max_internal in ota_events.maximum_internal_attendees%type,
1097: p_event_start_date in otv_scheduled_events.course_start_date%type,
1098: p_parent_offering_id in ota_events.parent_offering_id%type default null) return varchar2 is

Line 1095: p_public_event_flag in ota_events.public_event_flag%type,

1091: function learner_can_enroll(
1092: p_person_id in per_people_f.person_id%type,
1093: p_party_id in hz_parties.party_id%type,
1094: p_event_id in ota_events.event_id%type,
1095: p_public_event_flag in ota_events.public_event_flag%type,
1096: p_max_internal in ota_events.maximum_internal_attendees%type,
1097: p_event_start_date in otv_scheduled_events.course_start_date%type,
1098: p_parent_offering_id in ota_events.parent_offering_id%type default null) return varchar2 is
1099: begin

Line 1096: p_max_internal in ota_events.maximum_internal_attendees%type,

1092: p_person_id in per_people_f.person_id%type,
1093: p_party_id in hz_parties.party_id%type,
1094: p_event_id in ota_events.event_id%type,
1095: p_public_event_flag in ota_events.public_event_flag%type,
1096: p_max_internal in ota_events.maximum_internal_attendees%type,
1097: p_event_start_date in otv_scheduled_events.course_start_date%type,
1098: p_parent_offering_id in ota_events.parent_offering_id%type default null) return varchar2 is
1099: begin
1100: if p_person_id is not null then

Line 1098: p_parent_offering_id in ota_events.parent_offering_id%type default null) return varchar2 is

1094: p_event_id in ota_events.event_id%type,
1095: p_public_event_flag in ota_events.public_event_flag%type,
1096: p_max_internal in ota_events.maximum_internal_attendees%type,
1097: p_event_start_date in otv_scheduled_events.course_start_date%type,
1098: p_parent_offering_id in ota_events.parent_offering_id%type default null) return varchar2 is
1099: begin
1100: if p_person_id is not null then
1101: 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);
1102: else

Line 1111: p_event_id in ota_events.event_id%type,

1107:
1108: function learner_can_enroll(
1109: p_person_id in per_people_f.person_id%type,
1110: p_party_id in hz_parties.party_id%type,
1111: p_event_id in ota_events.event_id%type,
1112: p_event_start_date in otv_scheduled_events.course_start_date%type,
1113: p_parent_offering_id in ota_events.parent_offering_id%type default null) return varchar2 is
1114:
1115: v_public_event_flag ota_events.public_event_flag%type;

Line 1113: p_parent_offering_id in ota_events.parent_offering_id%type default null) return varchar2 is

1109: p_person_id in per_people_f.person_id%type,
1110: p_party_id in hz_parties.party_id%type,
1111: p_event_id in ota_events.event_id%type,
1112: p_event_start_date in otv_scheduled_events.course_start_date%type,
1113: p_parent_offering_id in ota_events.parent_offering_id%type default null) return varchar2 is
1114:
1115: v_public_event_flag ota_events.public_event_flag%type;
1116: v_max_internal ota_events.maximum_internal_attendees%type;
1117: begin

Line 1115: v_public_event_flag ota_events.public_event_flag%type;

1111: p_event_id in ota_events.event_id%type,
1112: p_event_start_date in otv_scheduled_events.course_start_date%type,
1113: p_parent_offering_id in ota_events.parent_offering_id%type default null) return varchar2 is
1114:
1115: v_public_event_flag ota_events.public_event_flag%type;
1116: v_max_internal ota_events.maximum_internal_attendees%type;
1117: begin
1118: select maximum_internal_attendees, public_event_flag
1119: into v_max_internal, v_public_event_flag

Line 1116: v_max_internal ota_events.maximum_internal_attendees%type;

1112: p_event_start_date in otv_scheduled_events.course_start_date%type,
1113: p_parent_offering_id in ota_events.parent_offering_id%type default null) return varchar2 is
1114:
1115: v_public_event_flag ota_events.public_event_flag%type;
1116: v_max_internal ota_events.maximum_internal_attendees%type;
1117: begin
1118: select maximum_internal_attendees, public_event_flag
1119: into v_max_internal, v_public_event_flag
1120: from ota_events

Line 1120: from ota_events

1116: v_max_internal ota_events.maximum_internal_attendees%type;
1117: begin
1118: select maximum_internal_attendees, public_event_flag
1119: into v_max_internal, v_public_event_flag
1120: from ota_events
1121: where event_id = p_event_id;
1122:
1123: return learner_can_enroll(p_person_id, p_party_id, p_event_id, v_public_event_flag, v_max_internal, p_event_start_date, p_parent_offering_id);
1124: end learner_can_enroll;

Line 1130: p_event_id in ota_events.event_id%type) return varchar2 is

1126:
1127: function learner_can_enroll(
1128: p_person_id in per_people_f.person_id%type,
1129: p_party_id in hz_parties.party_id%type,
1130: p_event_id in ota_events.event_id%type) return varchar2 is
1131:
1132: v_event_start_date ota_events.course_start_date%type;
1133: v_parent_offering_id ota_events.parent_offering_id%type;
1134: v_public_event_flag ota_events.public_event_flag%type;

Line 1132: v_event_start_date ota_events.course_start_date%type;

1128: p_person_id in per_people_f.person_id%type,
1129: p_party_id in hz_parties.party_id%type,
1130: p_event_id in ota_events.event_id%type) return varchar2 is
1131:
1132: v_event_start_date ota_events.course_start_date%type;
1133: v_parent_offering_id ota_events.parent_offering_id%type;
1134: v_public_event_flag ota_events.public_event_flag%type;
1135: v_max_internal ota_events.maximum_internal_attendees%type;
1136: begin

Line 1133: v_parent_offering_id ota_events.parent_offering_id%type;

1129: p_party_id in hz_parties.party_id%type,
1130: p_event_id in ota_events.event_id%type) return varchar2 is
1131:
1132: v_event_start_date ota_events.course_start_date%type;
1133: v_parent_offering_id ota_events.parent_offering_id%type;
1134: v_public_event_flag ota_events.public_event_flag%type;
1135: v_max_internal ota_events.maximum_internal_attendees%type;
1136: begin
1137: select maximum_internal_attendees, public_event_flag, parent_offering_id, course_start_date

Line 1134: v_public_event_flag ota_events.public_event_flag%type;

1130: p_event_id in ota_events.event_id%type) return varchar2 is
1131:
1132: v_event_start_date ota_events.course_start_date%type;
1133: v_parent_offering_id ota_events.parent_offering_id%type;
1134: v_public_event_flag ota_events.public_event_flag%type;
1135: v_max_internal ota_events.maximum_internal_attendees%type;
1136: begin
1137: select maximum_internal_attendees, public_event_flag, parent_offering_id, course_start_date
1138: into v_max_internal, v_public_event_flag, v_parent_offering_id, v_event_start_date

Line 1135: v_max_internal ota_events.maximum_internal_attendees%type;

1131:
1132: v_event_start_date ota_events.course_start_date%type;
1133: v_parent_offering_id ota_events.parent_offering_id%type;
1134: v_public_event_flag ota_events.public_event_flag%type;
1135: v_max_internal ota_events.maximum_internal_attendees%type;
1136: begin
1137: select maximum_internal_attendees, public_event_flag, parent_offering_id, course_start_date
1138: into v_max_internal, v_public_event_flag, v_parent_offering_id, v_event_start_date
1139: from ota_events

Line 1139: from ota_events

1135: v_max_internal ota_events.maximum_internal_attendees%type;
1136: begin
1137: select maximum_internal_attendees, public_event_flag, parent_offering_id, course_start_date
1138: into v_max_internal, v_public_event_flag, v_parent_offering_id, v_event_start_date
1139: from ota_events
1140: where event_id = p_event_id;
1141:
1142: return learner_can_enroll(p_person_id, p_party_id, p_event_id, v_public_event_flag, v_max_internal, v_event_start_date, v_parent_offering_id);
1143: end learner_can_enroll;

Line 1149: p_event_id in ota_events.event_id%type,

1145:
1146: function learner_can_self_enroll(
1147: p_person_id in per_people_f.person_id%type,
1148: p_party_id in hz_parties.party_id%type,
1149: p_event_id in ota_events.event_id%type,
1150: p_public_event_flag in ota_events.public_event_flag%type,
1151: p_max_internal in ota_events.maximum_internal_attendees%type,
1152: p_event_start_date in otv_scheduled_events.course_start_date%type,
1153: p_parent_offering_id in ota_events.parent_offering_id%type default null) return varchar2 is

Line 1150: p_public_event_flag in ota_events.public_event_flag%type,

1146: function learner_can_self_enroll(
1147: p_person_id in per_people_f.person_id%type,
1148: p_party_id in hz_parties.party_id%type,
1149: p_event_id in ota_events.event_id%type,
1150: p_public_event_flag in ota_events.public_event_flag%type,
1151: p_max_internal in ota_events.maximum_internal_attendees%type,
1152: p_event_start_date in otv_scheduled_events.course_start_date%type,
1153: p_parent_offering_id in ota_events.parent_offering_id%type default null) return varchar2 is
1154: begin

Line 1151: p_max_internal in ota_events.maximum_internal_attendees%type,

1147: p_person_id in per_people_f.person_id%type,
1148: p_party_id in hz_parties.party_id%type,
1149: p_event_id in ota_events.event_id%type,
1150: p_public_event_flag in ota_events.public_event_flag%type,
1151: p_max_internal in ota_events.maximum_internal_attendees%type,
1152: p_event_start_date in otv_scheduled_events.course_start_date%type,
1153: p_parent_offering_id in ota_events.parent_offering_id%type default null) return varchar2 is
1154: begin
1155: if p_person_id is not null then

Line 1153: p_parent_offering_id in ota_events.parent_offering_id%type default null) return varchar2 is

1149: p_event_id in ota_events.event_id%type,
1150: p_public_event_flag in ota_events.public_event_flag%type,
1151: p_max_internal in ota_events.maximum_internal_attendees%type,
1152: p_event_start_date in otv_scheduled_events.course_start_date%type,
1153: p_parent_offering_id in ota_events.parent_offering_id%type default null) return varchar2 is
1154: begin
1155: if p_person_id is not null then
1156: return employee_can_self_enroll(p_person_id, p_event_id, p_public_event_flag, p_max_internal, p_parent_offering_id);
1157: else

Line 1166: p_event_id in ota_events.event_id%type,

1162:
1163: function learner_can_self_enroll(
1164: p_person_id in per_people_f.person_id%type,
1165: p_party_id in hz_parties.party_id%type,
1166: p_event_id in ota_events.event_id%type,
1167: p_event_start_date in otv_scheduled_events.course_start_date%type,
1168: p_parent_offering_id in ota_events.parent_offering_id%type default null) return varchar2 is
1169:
1170: v_public_event_flag ota_events.public_event_flag%type;

Line 1168: p_parent_offering_id in ota_events.parent_offering_id%type default null) return varchar2 is

1164: p_person_id in per_people_f.person_id%type,
1165: p_party_id in hz_parties.party_id%type,
1166: p_event_id in ota_events.event_id%type,
1167: p_event_start_date in otv_scheduled_events.course_start_date%type,
1168: p_parent_offering_id in ota_events.parent_offering_id%type default null) return varchar2 is
1169:
1170: v_public_event_flag ota_events.public_event_flag%type;
1171: v_max_internal ota_events.maximum_internal_attendees%type;
1172: begin

Line 1170: v_public_event_flag ota_events.public_event_flag%type;

1166: p_event_id in ota_events.event_id%type,
1167: p_event_start_date in otv_scheduled_events.course_start_date%type,
1168: p_parent_offering_id in ota_events.parent_offering_id%type default null) return varchar2 is
1169:
1170: v_public_event_flag ota_events.public_event_flag%type;
1171: v_max_internal ota_events.maximum_internal_attendees%type;
1172: begin
1173: select maximum_internal_attendees, public_event_flag
1174: into v_max_internal, v_public_event_flag

Line 1171: v_max_internal ota_events.maximum_internal_attendees%type;

1167: p_event_start_date in otv_scheduled_events.course_start_date%type,
1168: p_parent_offering_id in ota_events.parent_offering_id%type default null) return varchar2 is
1169:
1170: v_public_event_flag ota_events.public_event_flag%type;
1171: v_max_internal ota_events.maximum_internal_attendees%type;
1172: begin
1173: select maximum_internal_attendees, public_event_flag
1174: into v_max_internal, v_public_event_flag
1175: from ota_events

Line 1175: from ota_events

1171: v_max_internal ota_events.maximum_internal_attendees%type;
1172: begin
1173: select maximum_internal_attendees, public_event_flag
1174: into v_max_internal, v_public_event_flag
1175: from ota_events
1176: where event_id = p_event_id;
1177:
1178: return learner_can_self_enroll(p_person_id, p_party_id, p_event_id, v_public_event_flag, v_max_internal, p_event_start_date, p_parent_offering_id);
1179: end learner_can_self_enroll;

Line 1184: p_event_id in ota_events.event_id%type) return varchar2 is

1180:
1181: function learner_can_self_enroll(
1182: p_person_id in per_people_f.person_id%type,
1183: p_party_id in hz_parties.party_id%type,
1184: p_event_id in ota_events.event_id%type) return varchar2 is
1185:
1186: v_event_start_date ota_events.course_start_date%type;
1187: v_parent_offering_id ota_events.parent_offering_id%type;
1188: v_public_event_flag ota_events.public_event_flag%type;

Line 1186: v_event_start_date ota_events.course_start_date%type;

1182: p_person_id in per_people_f.person_id%type,
1183: p_party_id in hz_parties.party_id%type,
1184: p_event_id in ota_events.event_id%type) return varchar2 is
1185:
1186: v_event_start_date ota_events.course_start_date%type;
1187: v_parent_offering_id ota_events.parent_offering_id%type;
1188: v_public_event_flag ota_events.public_event_flag%type;
1189: v_max_internal ota_events.maximum_internal_attendees%type;
1190: begin

Line 1187: v_parent_offering_id ota_events.parent_offering_id%type;

1183: p_party_id in hz_parties.party_id%type,
1184: p_event_id in ota_events.event_id%type) return varchar2 is
1185:
1186: v_event_start_date ota_events.course_start_date%type;
1187: v_parent_offering_id ota_events.parent_offering_id%type;
1188: v_public_event_flag ota_events.public_event_flag%type;
1189: v_max_internal ota_events.maximum_internal_attendees%type;
1190: begin
1191: select maximum_internal_attendees, public_event_flag, parent_offering_id, course_start_date

Line 1188: v_public_event_flag ota_events.public_event_flag%type;

1184: p_event_id in ota_events.event_id%type) return varchar2 is
1185:
1186: v_event_start_date ota_events.course_start_date%type;
1187: v_parent_offering_id ota_events.parent_offering_id%type;
1188: v_public_event_flag ota_events.public_event_flag%type;
1189: v_max_internal ota_events.maximum_internal_attendees%type;
1190: begin
1191: select maximum_internal_attendees, public_event_flag, parent_offering_id, course_start_date
1192: into v_max_internal, v_public_event_flag, v_parent_offering_id, v_event_start_date

Line 1189: v_max_internal ota_events.maximum_internal_attendees%type;

1185:
1186: v_event_start_date ota_events.course_start_date%type;
1187: v_parent_offering_id ota_events.parent_offering_id%type;
1188: v_public_event_flag ota_events.public_event_flag%type;
1189: v_max_internal ota_events.maximum_internal_attendees%type;
1190: begin
1191: select maximum_internal_attendees, public_event_flag, parent_offering_id, course_start_date
1192: into v_max_internal, v_public_event_flag, v_parent_offering_id, v_event_start_date
1193: from ota_events

Line 1193: from ota_events

1189: v_max_internal ota_events.maximum_internal_attendees%type;
1190: begin
1191: select maximum_internal_attendees, public_event_flag, parent_offering_id, course_start_date
1192: into v_max_internal, v_public_event_flag, v_parent_offering_id, v_event_start_date
1193: from ota_events
1194: where event_id = p_event_id;
1195:
1196: return learner_can_self_enroll(p_person_id, p_party_id, p_event_id, v_public_event_flag, v_max_internal, v_event_start_date, v_parent_offering_id);
1197: end learner_can_self_enroll;

Line 1202: p_event_id in ota_events.event_id%type,

1198:
1199:
1200: function chk_delegate_ok_for_event(
1201: p_delegate_id in per_people_f.person_id%type,
1202: p_event_id in ota_events.event_id%type,
1203: p_event_start_date in otv_scheduled_events.course_start_date%type,
1204: p_parent_offering_id in ota_events.parent_offering_id%type default null) return varchar2 is
1205: begin
1206: return learner_can_enroll(p_delegate_id, null, p_event_id, p_event_start_date, p_parent_offering_id);

Line 1204: p_parent_offering_id in ota_events.parent_offering_id%type default null) return varchar2 is

1200: function chk_delegate_ok_for_event(
1201: p_delegate_id in per_people_f.person_id%type,
1202: p_event_id in ota_events.event_id%type,
1203: p_event_start_date in otv_scheduled_events.course_start_date%type,
1204: p_parent_offering_id in ota_events.parent_offering_id%type default null) return varchar2 is
1205: begin
1206: return learner_can_enroll(p_delegate_id, null, p_event_id, p_event_start_date, p_parent_offering_id);
1207: end chk_delegate_ok_for_event;
1208:

Line 2199: p_business_group_id ota_events.business_group_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,
2203: OEV.maximum_internal_attendees,

Line 2206: ota_events OEV,

2202: OEV.public_event_flag,
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

Line 2226: p_business_group_id ota_events.business_group_id%type,

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,
2230: OEV.maximum_internal_attendees,

Line 2233: ota_events OEV,

2229: OEV.public_event_flag,
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

Line 2252: l_business_group_id ota_events.business_group_id%type;

2248: 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')
2249: AND nvl(OEV.event_availability, 'ALL') = 'ALL'
2250: ORDER BY OEV.public_event_flag DESC;
2251:
2252: l_business_group_id ota_events.business_group_id%type;
2253: l_server_timezone_code fnd_timezones_b.timezone_code%type;
2254: begin
2255:
2256: l_business_group_id := ota_general.get_business_group_id;