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.

[Home] [Help]

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 663: ota_tdb_shd.lck(p_booking_id,p_object_version_number);

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

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

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

Line 887: ota_tdb_shd.g_old_rec.booking_status_type_id);

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

Line 1023: ota_tdb_shd.g_old_rec.date_status_changed,

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

Line 1024: ota_tdb_shd.g_old_rec.booking_status_type_id,

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

Line 1025: ota_tdb_shd.g_created_by,

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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