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_TDB_API_UPD2 dependencies on OTA_TDB_SHD

Line 27: ota_tdb_shd.g_old_rec.booking_status_type_id);

23: -- Set up local variables
24: --
25:
26: l_old_booking_status varchar2(30) := ota_tdb_bus.booking_status_type(
27: ota_tdb_shd.g_old_rec.booking_status_type_id);
28:
29: l_booking_status varchar2(30) := ota_tdb_bus.booking_status_type(
30: p_booking_status_type_id);
31:

Line 33: ota_tdb_shd.g_old_rec.booking_status_type_id,

29: l_booking_status varchar2(30) := ota_tdb_bus.booking_status_type(
30: p_booking_status_type_id);
31:
32: l_booking_status_changed boolean := ota_general.value_changed(
33: ota_tdb_shd.g_old_rec.booking_status_type_id,
34: p_booking_status_type_id);
35:
36: l_number_of_places_changed boolean := ota_general.value_changed(
37: ota_tdb_shd.g_old_rec.number_of_places,

Line 37: ota_tdb_shd.g_old_rec.number_of_places,

33: ota_tdb_shd.g_old_rec.booking_status_type_id,
34: p_booking_status_type_id);
35:
36: l_number_of_places_changed boolean := ota_general.value_changed(
37: ota_tdb_shd.g_old_rec.number_of_places,
38: p_number_of_places);
39:
40: l_vacancies number := ota_evt_bus2.get_vacancies(p_event_id);
41:

Line 42: l_old_number_of_places number := ota_tdb_shd.g_old_rec.number_of_places;

38: p_number_of_places);
39:
40: l_vacancies number := ota_evt_bus2.get_vacancies(p_event_id);
41:
42: l_old_number_of_places number := ota_tdb_shd.g_old_rec.number_of_places;
43:
44: l_old_event_id number := ota_tdb_shd.g_old_rec.event_id;
45: --
46: l_proc varchar2(72);

Line 44: l_old_event_id number := ota_tdb_shd.g_old_rec.event_id;

40: l_vacancies number := ota_evt_bus2.get_vacancies(p_event_id);
41:
42: l_old_number_of_places number := ota_tdb_shd.g_old_rec.number_of_places;
43:
44: l_old_event_id number := ota_tdb_shd.g_old_rec.event_id;
45: --
46: l_proc varchar2(72);
47: --
48: begin

Line 661: ota_tdb_shd.lck(p_booking_id,p_object_version_number);

657: --
658: --
659: -- Lock Enrollment (Bug 2468167)
660: --
661: ota_tdb_shd.lck(p_booking_id,p_object_version_number);
662: --
663: -- Prerequisite Validation Code
664: -- Can be overridden if p_override_prerequisites parameter is 'Y'
665: -- get booking status type

Line 880: ota_general.value_changed (ota_tdb_shd.g_old_rec.booking_status_type_id,

876: p_is_history_flag
877: );
878: --
879: l_status_type_id_changed :=
880: ota_general.value_changed (ota_tdb_shd.g_old_rec.booking_status_type_id,
881: p_booking_status_type_id);
882:
883: --Getting the old booking status to manipulate the fourm notification records
884: l_old_booking_status := ota_tdb_bus.booking_status_type(

Line 885: ota_tdb_shd.g_old_rec.booking_status_type_id);

881: p_booking_status_type_id);
882:
883: --Getting the old booking status to manipulate the fourm notification records
884: l_old_booking_status := ota_tdb_bus.booking_status_type(
885: ota_tdb_shd.g_old_rec.booking_status_type_id);
886:
887: OPEN is_contact;
888: FETCH is_contact INTO l_contact_id,l_delegate_contact_id;
889: CLOSE is_contact;

Line 1021: ota_tdb_shd.g_old_rec.date_status_changed,

1017: p_date_status_changed,
1018: p_administrator,
1019: l_status_change_comments, --p_status_change_comments,Bug 2359495
1020: p_booking_id,
1021: ota_tdb_shd.g_old_rec.date_status_changed,
1022: ota_tdb_shd.g_old_rec.booking_status_type_id,
1023: ota_tdb_shd.g_created_by,
1024: p_date_booking_placed);
1025: --

Line 1022: ota_tdb_shd.g_old_rec.booking_status_type_id,

1018: p_administrator,
1019: l_status_change_comments, --p_status_change_comments,Bug 2359495
1020: p_booking_id,
1021: ota_tdb_shd.g_old_rec.date_status_changed,
1022: ota_tdb_shd.g_old_rec.booking_status_type_id,
1023: ota_tdb_shd.g_created_by,
1024: p_date_booking_placed);
1025: --
1026: ota_tdb_bus.ota_letter_lines

Line 1023: ota_tdb_shd.g_created_by,

1019: l_status_change_comments, --p_status_change_comments,Bug 2359495
1020: p_booking_id,
1021: ota_tdb_shd.g_old_rec.date_status_changed,
1022: ota_tdb_shd.g_old_rec.booking_status_type_id,
1023: ota_tdb_shd.g_created_by,
1024: p_date_booking_placed);
1025: --
1026: ota_tdb_bus.ota_letter_lines
1027: (p_booking_id => p_booking_id,

Line 1039: AND p_event_id <> ota_tdb_shd.g_old_rec.event_id THEN

1035: end if;
1036: --
1037: --Added for Bug#4106893
1038: IF p_event_id <> hr_api.g_number
1039: AND p_event_id <> ota_tdb_shd.g_old_rec.event_id THEN
1040: l_event_id_changed:= true;
1041: END IF;
1042:
1043: IF p_delegate_person_id <> hr_api.g_number

Line 1044: AND p_delegate_person_id <> ota_tdb_shd.g_old_rec.delegate_person_id THEN

1040: l_event_id_changed:= true;
1041: END IF;
1042:
1043: IF p_delegate_person_id <> hr_api.g_number
1044: AND p_delegate_person_id <> ota_tdb_shd.g_old_rec.delegate_person_id THEN
1045: l_person_id_changed := true;
1046: END IF;
1047:
1048: IF p_delegate_contact_id <> hr_api.g_number

Line 1049: AND p_delegate_contact_id <> ota_tdb_shd.g_old_rec.delegate_contact_id THEN

1045: l_person_id_changed := true;
1046: END IF;
1047:
1048: IF p_delegate_contact_id <> hr_api.g_number
1049: AND p_delegate_contact_id <> ota_tdb_shd.g_old_rec.delegate_contact_id THEN
1050: l_contact_id_changed := true;
1051: END IF;
1052:
1053:

Line 1084: ota_lrng_path_member_util.update_lme_enroll_status_chg(p_event_id => ota_tdb_shd.g_old_rec.event_id,

1080: **/
1081: /*
1082: IF l_event_id_changed AND NOT l_person_id_changed AND NOT l_contact_id_changed THEN
1083: IF l_person_id IS NOT NULL THEN
1084: ota_lrng_path_member_util.update_lme_enroll_status_chg(p_event_id => ota_tdb_shd.g_old_rec.event_id,
1085: p_person_id => l_person_id,
1086: p_contact_id => null,
1087: p_lp_enrollment_ids => l_lp_enrollment_ids);
1088: -- update any associated cert member enrollment statuses

Line 1089: ota_cme_util.update_cme_status(p_event_id => ota_tdb_shd.g_old_rec.event_id,

1085: p_person_id => l_person_id,
1086: p_contact_id => null,
1087: p_lp_enrollment_ids => l_lp_enrollment_ids);
1088: -- update any associated cert member enrollment statuses
1089: ota_cme_util.update_cme_status(p_event_id => ota_tdb_shd.g_old_rec.event_id,
1090: p_person_id => l_person_id,
1091: p_contact_id => null,
1092: p_cert_prd_enrollment_ids => l_cert_prd_enrollment_ids);
1093:

Line 1105: deleteForumNotification(ota_tdb_shd.g_old_rec.event_id, l_person_id, null);

1101: p_contact_id => null,
1102: p_cert_prd_enrollment_ids => l_cert_prd_enrollment_ids);
1103: --If the event has changed, the forum notification record should be deleted and created for the new event
1104: -- FRM Notification should be created only for Placed or Attended status. Not for 'C','W' or 'R'.
1105: deleteForumNotification(ota_tdb_shd.g_old_rec.event_id, l_person_id, null);
1106: createForumNotification(p_event_id, l_person_id, null, l_effective_date, p_booking_status_type_id);
1107: ELSIF l_delegate_contact_id IS NOT NULL THEN
1108: ota_lrng_path_member_util.update_lme_enroll_status_chg(p_event_id => ota_tdb_shd.g_old_rec.event_id,
1109: p_person_id => null,

Line 1108: ota_lrng_path_member_util.update_lme_enroll_status_chg(p_event_id => ota_tdb_shd.g_old_rec.event_id,

1104: -- FRM Notification should be created only for Placed or Attended status. Not for 'C','W' or 'R'.
1105: deleteForumNotification(ota_tdb_shd.g_old_rec.event_id, l_person_id, null);
1106: createForumNotification(p_event_id, l_person_id, null, l_effective_date, p_booking_status_type_id);
1107: ELSIF l_delegate_contact_id IS NOT NULL THEN
1108: ota_lrng_path_member_util.update_lme_enroll_status_chg(p_event_id => ota_tdb_shd.g_old_rec.event_id,
1109: p_person_id => null,
1110: p_contact_id => l_delegate_contact_id,
1111: p_lp_enrollment_ids => l_lp_enrollment_ids);
1112:

Line 1114: ota_cme_util.update_cme_status(p_event_id => ota_tdb_shd.g_old_rec.event_id,

1110: p_contact_id => l_delegate_contact_id,
1111: p_lp_enrollment_ids => l_lp_enrollment_ids);
1112:
1113: -- update any associated cert member enrollment statuses
1114: ota_cme_util.update_cme_status(p_event_id => ota_tdb_shd.g_old_rec.event_id,
1115: p_person_id => null,
1116: p_contact_id => l_delegate_contact_id,
1117: p_cert_prd_enrollment_ids => l_cert_prd_enrollment_ids);
1118:

Line 1128: deleteForumNotification(ota_tdb_shd.g_old_rec.event_id, null, l_delegate_contact_id);

1124: ota_cme_util.update_cme_status(p_event_id => p_event_id,
1125: p_person_id => null,
1126: p_contact_id => l_delegate_contact_id,
1127: p_cert_prd_enrollment_ids => l_cert_prd_enrollment_ids);
1128: deleteForumNotification(ota_tdb_shd.g_old_rec.event_id, null, l_delegate_contact_id);
1129: createForumNotification(p_event_id, null, l_delegate_contact_id, l_effective_date, p_booking_status_type_id);
1130: END IF;
1131: ELSIF l_event_id_changed THEN
1132: IF l_person_id_changed THEN

Line 1133: ota_lrng_path_member_util.update_lme_enroll_status_chg(p_event_id => ota_tdb_shd.g_old_rec.event_id,

1129: createForumNotification(p_event_id, null, l_delegate_contact_id, l_effective_date, p_booking_status_type_id);
1130: END IF;
1131: ELSIF l_event_id_changed THEN
1132: IF l_person_id_changed THEN
1133: ota_lrng_path_member_util.update_lme_enroll_status_chg(p_event_id => ota_tdb_shd.g_old_rec.event_id,
1134: p_person_id =>ota_tdb_shd.g_old_rec.delegate_person_id,
1135: p_contact_id => null,
1136: p_lp_enrollment_ids => l_lp_enrollment_ids);
1137:

Line 1134: p_person_id =>ota_tdb_shd.g_old_rec.delegate_person_id,

1130: END IF;
1131: ELSIF l_event_id_changed THEN
1132: IF l_person_id_changed THEN
1133: ota_lrng_path_member_util.update_lme_enroll_status_chg(p_event_id => ota_tdb_shd.g_old_rec.event_id,
1134: p_person_id =>ota_tdb_shd.g_old_rec.delegate_person_id,
1135: p_contact_id => null,
1136: p_lp_enrollment_ids => l_lp_enrollment_ids);
1137:
1138: -- update any associated cert member enrollment statuses

Line 1139: ota_cme_util.update_cme_status(p_event_id => ota_tdb_shd.g_old_rec.event_id,

1135: p_contact_id => null,
1136: p_lp_enrollment_ids => l_lp_enrollment_ids);
1137:
1138: -- update any associated cert member enrollment statuses
1139: ota_cme_util.update_cme_status(p_event_id => ota_tdb_shd.g_old_rec.event_id,
1140: p_person_id => ota_tdb_shd.g_old_rec.delegate_person_id,
1141: p_contact_id => null,
1142: p_cert_prd_enrollment_ids => l_cert_prd_enrollment_ids);
1143:

Line 1140: p_person_id => ota_tdb_shd.g_old_rec.delegate_person_id,

1136: p_lp_enrollment_ids => l_lp_enrollment_ids);
1137:
1138: -- update any associated cert member enrollment statuses
1139: ota_cme_util.update_cme_status(p_event_id => ota_tdb_shd.g_old_rec.event_id,
1140: p_person_id => ota_tdb_shd.g_old_rec.delegate_person_id,
1141: p_contact_id => null,
1142: p_cert_prd_enrollment_ids => l_cert_prd_enrollment_ids);
1143:
1144: ota_lrng_path_member_util.update_lme_enroll_status_chg(p_event_id => p_event_id,

Line 1155: deleteForumNotification(ota_tdb_shd.g_old_rec.event_id, ota_tdb_shd.g_old_rec.delegate_person_id, null);

1151: p_contact_id => null,
1152: p_cert_prd_enrollment_ids => l_cert_prd_enrollment_ids);
1153: -- the class and the learner have change.So delete the forum record for old class and person
1154: --and create a notification record for the new class and new person
1155: deleteForumNotification(ota_tdb_shd.g_old_rec.event_id, ota_tdb_shd.g_old_rec.delegate_person_id, null);
1156: createForumNotification(p_event_id, l_person_id, null, l_effective_date, p_booking_status_type_id);
1157: ELSIF l_contact_id_changed THEN
1158: ota_lrng_path_member_util.update_lme_enroll_status_chg(p_event_id => ota_tdb_shd.g_old_rec.event_id,
1159: p_person_id => null,

Line 1158: ota_lrng_path_member_util.update_lme_enroll_status_chg(p_event_id => ota_tdb_shd.g_old_rec.event_id,

1154: --and create a notification record for the new class and new person
1155: deleteForumNotification(ota_tdb_shd.g_old_rec.event_id, ota_tdb_shd.g_old_rec.delegate_person_id, null);
1156: createForumNotification(p_event_id, l_person_id, null, l_effective_date, p_booking_status_type_id);
1157: ELSIF l_contact_id_changed THEN
1158: ota_lrng_path_member_util.update_lme_enroll_status_chg(p_event_id => ota_tdb_shd.g_old_rec.event_id,
1159: p_person_id => null,
1160: p_contact_id =>ota_tdb_shd.g_old_rec.delegate_contact_id,
1161: p_lp_enrollment_ids => l_lp_enrollment_ids);
1162: -- update any associated cert member enrollment statuses

Line 1160: p_contact_id =>ota_tdb_shd.g_old_rec.delegate_contact_id,

1156: createForumNotification(p_event_id, l_person_id, null, l_effective_date, p_booking_status_type_id);
1157: ELSIF l_contact_id_changed THEN
1158: ota_lrng_path_member_util.update_lme_enroll_status_chg(p_event_id => ota_tdb_shd.g_old_rec.event_id,
1159: p_person_id => null,
1160: p_contact_id =>ota_tdb_shd.g_old_rec.delegate_contact_id,
1161: p_lp_enrollment_ids => l_lp_enrollment_ids);
1162: -- update any associated cert member enrollment statuses
1163: ota_cme_util.update_cme_status(p_event_id => ota_tdb_shd.g_old_rec.event_id,
1164: p_person_id => null,

Line 1163: ota_cme_util.update_cme_status(p_event_id => ota_tdb_shd.g_old_rec.event_id,

1159: p_person_id => null,
1160: p_contact_id =>ota_tdb_shd.g_old_rec.delegate_contact_id,
1161: p_lp_enrollment_ids => l_lp_enrollment_ids);
1162: -- update any associated cert member enrollment statuses
1163: ota_cme_util.update_cme_status(p_event_id => ota_tdb_shd.g_old_rec.event_id,
1164: p_person_id => null,
1165: p_contact_id => ota_tdb_shd.g_old_rec.delegate_contact_id,
1166: p_cert_prd_enrollment_ids => l_cert_prd_enrollment_ids);
1167:

Line 1165: p_contact_id => ota_tdb_shd.g_old_rec.delegate_contact_id,

1161: p_lp_enrollment_ids => l_lp_enrollment_ids);
1162: -- update any associated cert member enrollment statuses
1163: ota_cme_util.update_cme_status(p_event_id => ota_tdb_shd.g_old_rec.event_id,
1164: p_person_id => null,
1165: p_contact_id => ota_tdb_shd.g_old_rec.delegate_contact_id,
1166: p_cert_prd_enrollment_ids => l_cert_prd_enrollment_ids);
1167:
1168: ota_lrng_path_member_util.update_lme_enroll_status_chg(p_event_id => p_event_id,
1169: p_person_id => null,

Line 1177: deleteForumNotification(ota_tdb_shd.g_old_rec.event_id, null, ota_tdb_shd.g_old_rec.delegate_contact_id);

1173: ota_cme_util.update_cme_status(p_event_id => p_event_id,
1174: p_person_id => null,
1175: p_contact_id => p_delegate_contact_id,
1176: p_cert_prd_enrollment_ids => l_cert_prd_enrollment_ids);
1177: deleteForumNotification(ota_tdb_shd.g_old_rec.event_id, null, ota_tdb_shd.g_old_rec.delegate_contact_id);
1178: createForumNotification(p_event_id, null, l_delegate_contact_id, l_effective_date, p_booking_status_type_id);
1179: END IF;
1180: ELSIF l_person_id_changed THEN
1181: ota_lrng_path_member_util.update_lme_enroll_status_chg(p_event_id => ota_tdb_shd.g_old_rec.event_id,

Line 1181: ota_lrng_path_member_util.update_lme_enroll_status_chg(p_event_id => ota_tdb_shd.g_old_rec.event_id,

1177: deleteForumNotification(ota_tdb_shd.g_old_rec.event_id, null, ota_tdb_shd.g_old_rec.delegate_contact_id);
1178: createForumNotification(p_event_id, null, l_delegate_contact_id, l_effective_date, p_booking_status_type_id);
1179: END IF;
1180: ELSIF l_person_id_changed THEN
1181: ota_lrng_path_member_util.update_lme_enroll_status_chg(p_event_id => ota_tdb_shd.g_old_rec.event_id,
1182: p_person_id =>ota_tdb_shd.g_old_rec.delegate_person_id,
1183: p_contact_id => null,
1184: p_lp_enrollment_ids => l_lp_enrollment_ids);
1185:

Line 1182: p_person_id =>ota_tdb_shd.g_old_rec.delegate_person_id,

1178: createForumNotification(p_event_id, null, l_delegate_contact_id, l_effective_date, p_booking_status_type_id);
1179: END IF;
1180: ELSIF l_person_id_changed THEN
1181: ota_lrng_path_member_util.update_lme_enroll_status_chg(p_event_id => ota_tdb_shd.g_old_rec.event_id,
1182: p_person_id =>ota_tdb_shd.g_old_rec.delegate_person_id,
1183: p_contact_id => null,
1184: p_lp_enrollment_ids => l_lp_enrollment_ids);
1185:
1186: -- update any associated cert member enrollment statuses

Line 1187: ota_cme_util.update_cme_status(p_event_id => ota_tdb_shd.g_old_rec.event_id,

1183: p_contact_id => null,
1184: p_lp_enrollment_ids => l_lp_enrollment_ids);
1185:
1186: -- update any associated cert member enrollment statuses
1187: ota_cme_util.update_cme_status(p_event_id => ota_tdb_shd.g_old_rec.event_id,
1188: p_person_id => ota_tdb_shd.g_old_rec.delegate_person_id,
1189: p_contact_id => null,
1190: p_cert_prd_enrollment_ids => l_cert_prd_enrollment_ids);
1191:

Line 1188: p_person_id => ota_tdb_shd.g_old_rec.delegate_person_id,

1184: p_lp_enrollment_ids => l_lp_enrollment_ids);
1185:
1186: -- update any associated cert member enrollment statuses
1187: ota_cme_util.update_cme_status(p_event_id => ota_tdb_shd.g_old_rec.event_id,
1188: p_person_id => ota_tdb_shd.g_old_rec.delegate_person_id,
1189: p_contact_id => null,
1190: p_cert_prd_enrollment_ids => l_cert_prd_enrollment_ids);
1191:
1192: ota_lrng_path_member_util.update_lme_enroll_status_chg(p_event_id => ota_tdb_shd.g_old_rec.event_id,

Line 1192: ota_lrng_path_member_util.update_lme_enroll_status_chg(p_event_id => ota_tdb_shd.g_old_rec.event_id,

1188: p_person_id => ota_tdb_shd.g_old_rec.delegate_person_id,
1189: p_contact_id => null,
1190: p_cert_prd_enrollment_ids => l_cert_prd_enrollment_ids);
1191:
1192: ota_lrng_path_member_util.update_lme_enroll_status_chg(p_event_id => ota_tdb_shd.g_old_rec.event_id,
1193: p_person_id => l_person_id,
1194: p_contact_id => null,
1195: p_lp_enrollment_ids => l_lp_enrollment_ids);
1196: -- update any associated cert member enrollment statuses

Line 1197: ota_cme_util.update_cme_status(p_event_id => ota_tdb_shd.g_old_rec.event_id,

1193: p_person_id => l_person_id,
1194: p_contact_id => null,
1195: p_lp_enrollment_ids => l_lp_enrollment_ids);
1196: -- update any associated cert member enrollment statuses
1197: ota_cme_util.update_cme_status(p_event_id => ota_tdb_shd.g_old_rec.event_id,
1198: p_person_id => l_person_id,
1199: p_contact_id => null,
1200: p_cert_prd_enrollment_ids => l_cert_prd_enrollment_ids);
1201: -- the learner has changed.So delete the forum record for old person

Line 1203: deleteForumNotification(ota_tdb_shd.g_old_rec.event_id, ota_tdb_shd.g_old_rec.delegate_person_id, null);

1199: p_contact_id => null,
1200: p_cert_prd_enrollment_ids => l_cert_prd_enrollment_ids);
1201: -- the learner has changed.So delete the forum record for old person
1202: --and create a notification record for the new person
1203: deleteForumNotification(ota_tdb_shd.g_old_rec.event_id, ota_tdb_shd.g_old_rec.delegate_person_id, null);
1204: createForumNotification(ota_tdb_shd.g_old_rec.event_id, l_person_id, null, l_effective_date, p_booking_status_type_id);
1205:
1206: ELSIF l_contact_id_changed THEN
1207: ota_lrng_path_member_util.update_lme_enroll_status_chg(p_event_id => ota_tdb_shd.g_old_rec.event_id,

Line 1204: createForumNotification(ota_tdb_shd.g_old_rec.event_id, l_person_id, null, l_effective_date, p_booking_status_type_id);

1200: p_cert_prd_enrollment_ids => l_cert_prd_enrollment_ids);
1201: -- the learner has changed.So delete the forum record for old person
1202: --and create a notification record for the new person
1203: deleteForumNotification(ota_tdb_shd.g_old_rec.event_id, ota_tdb_shd.g_old_rec.delegate_person_id, null);
1204: createForumNotification(ota_tdb_shd.g_old_rec.event_id, l_person_id, null, l_effective_date, p_booking_status_type_id);
1205:
1206: ELSIF l_contact_id_changed THEN
1207: ota_lrng_path_member_util.update_lme_enroll_status_chg(p_event_id => ota_tdb_shd.g_old_rec.event_id,
1208: p_person_id => null,

Line 1207: ota_lrng_path_member_util.update_lme_enroll_status_chg(p_event_id => ota_tdb_shd.g_old_rec.event_id,

1203: deleteForumNotification(ota_tdb_shd.g_old_rec.event_id, ota_tdb_shd.g_old_rec.delegate_person_id, null);
1204: createForumNotification(ota_tdb_shd.g_old_rec.event_id, l_person_id, null, l_effective_date, p_booking_status_type_id);
1205:
1206: ELSIF l_contact_id_changed THEN
1207: ota_lrng_path_member_util.update_lme_enroll_status_chg(p_event_id => ota_tdb_shd.g_old_rec.event_id,
1208: p_person_id => null,
1209: p_contact_id =>ota_tdb_shd.g_old_rec.delegate_contact_id,
1210: p_lp_enrollment_ids => l_lp_enrollment_ids);
1211: -- update any associated cert member enrollment statuses

Line 1209: p_contact_id =>ota_tdb_shd.g_old_rec.delegate_contact_id,

1205:
1206: ELSIF l_contact_id_changed THEN
1207: ota_lrng_path_member_util.update_lme_enroll_status_chg(p_event_id => ota_tdb_shd.g_old_rec.event_id,
1208: p_person_id => null,
1209: p_contact_id =>ota_tdb_shd.g_old_rec.delegate_contact_id,
1210: p_lp_enrollment_ids => l_lp_enrollment_ids);
1211: -- update any associated cert member enrollment statuses
1212: ota_cme_util.update_cme_status(p_event_id => ota_tdb_shd.g_old_rec.event_id,
1213: p_person_id => null,

Line 1212: ota_cme_util.update_cme_status(p_event_id => ota_tdb_shd.g_old_rec.event_id,

1208: p_person_id => null,
1209: p_contact_id =>ota_tdb_shd.g_old_rec.delegate_contact_id,
1210: p_lp_enrollment_ids => l_lp_enrollment_ids);
1211: -- update any associated cert member enrollment statuses
1212: ota_cme_util.update_cme_status(p_event_id => ota_tdb_shd.g_old_rec.event_id,
1213: p_person_id => null,
1214: p_contact_id => ota_tdb_shd.g_old_rec.delegate_contact_id,
1215: p_cert_prd_enrollment_ids => l_cert_prd_enrollment_ids);
1216:

Line 1214: p_contact_id => ota_tdb_shd.g_old_rec.delegate_contact_id,

1210: p_lp_enrollment_ids => l_lp_enrollment_ids);
1211: -- update any associated cert member enrollment statuses
1212: ota_cme_util.update_cme_status(p_event_id => ota_tdb_shd.g_old_rec.event_id,
1213: p_person_id => null,
1214: p_contact_id => ota_tdb_shd.g_old_rec.delegate_contact_id,
1215: p_cert_prd_enrollment_ids => l_cert_prd_enrollment_ids);
1216:
1217: ota_lrng_path_member_util.update_lme_enroll_status_chg(p_event_id => ota_tdb_shd.g_old_rec.event_id,
1218: p_person_id => null,

Line 1217: ota_lrng_path_member_util.update_lme_enroll_status_chg(p_event_id => ota_tdb_shd.g_old_rec.event_id,

1213: p_person_id => null,
1214: p_contact_id => ota_tdb_shd.g_old_rec.delegate_contact_id,
1215: p_cert_prd_enrollment_ids => l_cert_prd_enrollment_ids);
1216:
1217: ota_lrng_path_member_util.update_lme_enroll_status_chg(p_event_id => ota_tdb_shd.g_old_rec.event_id,
1218: p_person_id => null,
1219: p_contact_id => p_delegate_contact_id,
1220: p_lp_enrollment_ids => l_lp_enrollment_ids);
1221: -- update any associated cert member enrollment statuses

Line 1222: ota_cme_util.update_cme_status(p_event_id => ota_tdb_shd.g_old_rec.event_id,

1218: p_person_id => null,
1219: p_contact_id => p_delegate_contact_id,
1220: p_lp_enrollment_ids => l_lp_enrollment_ids);
1221: -- update any associated cert member enrollment statuses
1222: ota_cme_util.update_cme_status(p_event_id => ota_tdb_shd.g_old_rec.event_id,
1223: p_person_id => null,
1224: p_contact_id => p_delegate_contact_id,
1225: p_cert_prd_enrollment_ids => l_cert_prd_enrollment_ids);
1226: deleteForumNotification(ota_tdb_shd.g_old_rec.event_id, null, ota_tdb_shd.g_old_rec.delegate_contact_id);

Line 1226: deleteForumNotification(ota_tdb_shd.g_old_rec.event_id, null, ota_tdb_shd.g_old_rec.delegate_contact_id);

1222: ota_cme_util.update_cme_status(p_event_id => ota_tdb_shd.g_old_rec.event_id,
1223: p_person_id => null,
1224: p_contact_id => p_delegate_contact_id,
1225: p_cert_prd_enrollment_ids => l_cert_prd_enrollment_ids);
1226: deleteForumNotification(ota_tdb_shd.g_old_rec.event_id, null, ota_tdb_shd.g_old_rec.delegate_contact_id);
1227: createForumNotification(ota_tdb_shd.g_old_rec.event_id, null, p_delegate_contact_id, l_effective_date, p_booking_status_type_id);
1228:
1229: END IF;
1230:

Line 1227: createForumNotification(ota_tdb_shd.g_old_rec.event_id, null, p_delegate_contact_id, l_effective_date, p_booking_status_type_id);

1223: p_person_id => null,
1224: p_contact_id => p_delegate_contact_id,
1225: p_cert_prd_enrollment_ids => l_cert_prd_enrollment_ids);
1226: deleteForumNotification(ota_tdb_shd.g_old_rec.event_id, null, ota_tdb_shd.g_old_rec.delegate_contact_id);
1227: createForumNotification(ota_tdb_shd.g_old_rec.event_id, null, p_delegate_contact_id, l_effective_date, p_booking_status_type_id);
1228:
1229: END IF;
1230:
1231: if p_update_finance_line in ('C','Y') then

Line 1259: if p_event_id <> ota_tdb_shd.g_old_rec.event_id then

1255: ,l_event_rec.maximum_attendees);
1256: --
1257: -- *** In case of Event Change -- Reset Event Status for Old Event ***
1258: --
1259: if p_event_id <> ota_tdb_shd.g_old_rec.event_id then
1260: ota_evt_bus2.lock_event(ota_tdb_shd.g_old_rec.event_id);
1261:
1262: ota_evt_shd.get_event_details (ota_tdb_shd.g_old_rec.event_id,
1263: l_event_rec,

Line 1260: ota_evt_bus2.lock_event(ota_tdb_shd.g_old_rec.event_id);

1256: --
1257: -- *** In case of Event Change -- Reset Event Status for Old Event ***
1258: --
1259: if p_event_id <> ota_tdb_shd.g_old_rec.event_id then
1260: ota_evt_bus2.lock_event(ota_tdb_shd.g_old_rec.event_id);
1261:
1262: ota_evt_shd.get_event_details (ota_tdb_shd.g_old_rec.event_id,
1263: l_event_rec,
1264: l_event_exists);

Line 1262: ota_evt_shd.get_event_details (ota_tdb_shd.g_old_rec.event_id,

1258: --
1259: if p_event_id <> ota_tdb_shd.g_old_rec.event_id then
1260: ota_evt_bus2.lock_event(ota_tdb_shd.g_old_rec.event_id);
1261:
1262: ota_evt_shd.get_event_details (ota_tdb_shd.g_old_rec.event_id,
1263: l_event_rec,
1264: l_event_exists);
1265:
1266: ota_evt_bus2.reset_event_status(ota_tdb_shd.g_old_rec.event_id

Line 1266: ota_evt_bus2.reset_event_status(ota_tdb_shd.g_old_rec.event_id

1262: ota_evt_shd.get_event_details (ota_tdb_shd.g_old_rec.event_id,
1263: l_event_rec,
1264: l_event_exists);
1265:
1266: ota_evt_bus2.reset_event_status(ota_tdb_shd.g_old_rec.event_id
1267: ,l_event_rec.object_version_number
1268: ,l_event_rec.event_status
1269: ,l_event_rec.maximum_attendees);
1270:

Line 1406: l_delegate_person_id := ota_tdb_shd.g_old_rec.delegate_person_id;

1402: -- Prerequisite Validation Code
1403: l_check_prereq := false;
1404:
1405: If ( p_delegate_person_id = hr_api.g_number ) Then
1406: l_delegate_person_id := ota_tdb_shd.g_old_rec.delegate_person_id;
1407: Else
1408: l_delegate_person_id := p_delegate_person_id;
1409: End If;
1410:

Line 1412: l_delegate_contact_id := ota_tdb_shd.g_old_rec.delegate_contact_id;

1408: l_delegate_person_id := p_delegate_person_id;
1409: End If;
1410:
1411: If ( p_delegate_contact_id = hr_api.g_number ) Then
1412: l_delegate_contact_id := ota_tdb_shd.g_old_rec.delegate_contact_id;
1413: Else
1414: l_delegate_contact_id := p_delegate_contact_id;
1415: End If;
1416:

Line 1418: l_customer_id := ota_tdb_shd.g_old_rec.customer_id;

1414: l_delegate_contact_id := p_delegate_contact_id;
1415: End If;
1416:
1417: If ( p_customer_id = hr_api.g_number ) Then
1418: l_customer_id := ota_tdb_shd.g_old_rec.customer_id;
1419: Else
1420: l_customer_id := p_customer_id;
1421: End If;
1422:

Line 1424: l_event_id := ota_tdb_shd.g_old_rec.event_id;

1420: l_customer_id := p_customer_id;
1421: End If;
1422:
1423: If ( p_event_id = hr_api.g_number ) Then
1424: l_event_id := ota_tdb_shd.g_old_rec.event_id;
1425: Else
1426: l_event_id := p_event_id;
1427: End If;
1428:

Line 1430: l_booking_status_type_id := ota_tdb_shd.g_old_rec.booking_status_type_id;

1426: l_event_id := p_event_id;
1427: End If;
1428:
1429: If ( p_booking_status_type_id = hr_api.g_number ) Then
1430: l_booking_status_type_id := ota_tdb_shd.g_old_rec.booking_status_type_id;
1431: Else
1432: l_booking_status_type_id := p_booking_status_type_id;
1433: End If;
1434:

Line 1435: If (ota_general.value_changed (ota_tdb_shd.g_old_rec.delegate_person_id, l_delegate_person_id) ) Then

1431: Else
1432: l_booking_status_type_id := p_booking_status_type_id;
1433: End If;
1434:
1435: If (ota_general.value_changed (ota_tdb_shd.g_old_rec.delegate_person_id, l_delegate_person_id) ) Then
1436: l_check_prereq := true;
1437: End If;
1438:
1439: If (ota_general.value_changed (ota_tdb_shd.g_old_rec.delegate_contact_id, l_delegate_contact_id) ) Then

Line 1439: If (ota_general.value_changed (ota_tdb_shd.g_old_rec.delegate_contact_id, l_delegate_contact_id) ) Then

1435: If (ota_general.value_changed (ota_tdb_shd.g_old_rec.delegate_person_id, l_delegate_person_id) ) Then
1436: l_check_prereq := true;
1437: End If;
1438:
1439: If (ota_general.value_changed (ota_tdb_shd.g_old_rec.delegate_contact_id, l_delegate_contact_id) ) Then
1440: l_check_prereq := true;
1441: End If;
1442:
1443: If (ota_general.value_changed (ota_tdb_shd.g_old_rec.customer_id, l_customer_id) ) Then

Line 1443: If (ota_general.value_changed (ota_tdb_shd.g_old_rec.customer_id, l_customer_id) ) Then

1439: If (ota_general.value_changed (ota_tdb_shd.g_old_rec.delegate_contact_id, l_delegate_contact_id) ) Then
1440: l_check_prereq := true;
1441: End If;
1442:
1443: If (ota_general.value_changed (ota_tdb_shd.g_old_rec.customer_id, l_customer_id) ) Then
1444: l_check_prereq := true;
1445: End If;
1446:
1447: If (ota_general.value_changed (ota_tdb_shd.g_old_rec.event_id, l_event_id) ) Then

Line 1447: If (ota_general.value_changed (ota_tdb_shd.g_old_rec.event_id, l_event_id) ) Then

1443: If (ota_general.value_changed (ota_tdb_shd.g_old_rec.customer_id, l_customer_id) ) Then
1444: l_check_prereq := true;
1445: End If;
1446:
1447: If (ota_general.value_changed (ota_tdb_shd.g_old_rec.event_id, l_event_id) ) Then
1448: l_check_prereq := true;
1449: End If;
1450:
1451: ota_utility.get_booking_status_type(p_status_type_id => ota_tdb_shd.g_old_rec.booking_status_type_id,

Line 1451: ota_utility.get_booking_status_type(p_status_type_id => ota_tdb_shd.g_old_rec.booking_status_type_id,

1447: If (ota_general.value_changed (ota_tdb_shd.g_old_rec.event_id, l_event_id) ) Then
1448: l_check_prereq := true;
1449: End If;
1450:
1451: ota_utility.get_booking_status_type(p_status_type_id => ota_tdb_shd.g_old_rec.booking_status_type_id,
1452: p_type => l_old_status_type);
1453:
1454: ota_utility.get_booking_status_type(p_status_type_id => l_booking_status_type_id,
1455: p_type => l_new_status_type);