APPS.OTA_CANCEL_API dependencies on OTA_TDB_API_UPD2

Line 339: ota_tdb_api_upd2.update_enrollment(

335: l_booking_status_type;
336: IF c_booking_status%found then
337: IF l_booking_status_type not in('A','C') then
338: hr_utility.set_location('Entering:'||l_proc, 30);
339: ota_tdb_api_upd2.update_enrollment(
340: p_booking_id => l_booking_id
341: ,p_object_version_number => l_enr_ovn
342: ,p_event_id => l_event_id
343: ,p_daemon_flag => 'Y'

Line 662: ota_tdb_api_upd2.Update_Enrollment(

658: BEGIN
659: FND_FILE.PUT_LINE(FND_FILE.LOG,'Updating booking id : ' || l_booking_id);
660: hr_utility.set_location('Entering:'|| l_proc, 40);
661: ota_tdb_shd.lck(l_booking_id,l_enr_ovn);
662: ota_tdb_api_upd2.Update_Enrollment(
663: p_booking_id => l_booking_id
664: ,p_booking_status_type_id => l_status_id
665: ,p_event_id => l_event_id
666: ,p_business_group_id => l_enr_business_group_id

Line 700: ota_tdb_api_upd2.Update_Enrollment(

696: hr_utility.set_location('Entering:'|| l_proc, 45);
697: BEGIN
698: FND_FILE.PUT_LINE(FND_FILE.LOG,'Updating booking id : ' || l_booking_id);
699: ota_tdb_shd.lck(l_booking_id,l_enr_ovn);
700: ota_tdb_api_upd2.Update_Enrollment(
701: p_booking_id => l_booking_id
702: ,p_booking_status_type_id => l_booking_status_type_id
703: ,p_event_id => l_event_id
704: ,p_business_group_id => l_enr_business_group_id

Line 733: ota_tdb_api_upd2.Update_Enrollment(

729:
730: BEGIN
731: FND_FILE.PUT_LINE(FND_FILE.LOG,'Updating booking id : ' || l_booking_id);
732: ota_tdb_shd.lck(l_booking_id,l_enr_ovn);
733: ota_tdb_api_upd2.Update_Enrollment(
734: p_booking_id => l_booking_id
735: ,p_booking_status_type_id => l_status_id
736: ,p_event_id => l_event_id
737: ,p_business_group_id => l_enr_business_group_id

Line 775: ota_tdb_api_upd2.Update_Enrollment(

771: hr_utility.set_location('Entering:'|| l_proc, 50);
772: BEGIN
773: FND_FILE.PUT_LINE(FND_FILE.LOG,'Updating booking id : ' || l_booking_id);
774: ota_tdb_shd.lck(l_booking_id,l_enr_ovn);
775: ota_tdb_api_upd2.Update_Enrollment(
776: p_booking_id => l_booking_id
777: ,p_booking_status_type_id => l_booking_status_type_id
778: ,p_event_id => l_event_id
779: ,p_business_group_id => l_enr_business_group_id

Line 803: ota_tdb_api_upd2.Update_Enrollment(

799: hr_utility.set_location('Entering:'|| l_proc, 55); -- err location added for bug#1632104
800: BEGIN
801: FND_FILE.PUT_LINE(FND_FILE.LOG,'Updating booking id : ' || l_booking_id);
802: ota_tdb_shd.lck(l_booking_id,l_enr_ovn);
803: ota_tdb_api_upd2.Update_Enrollment(
804: p_booking_id => l_booking_id
805: ,p_booking_status_type_id => l_booking_status_type_id
806: ,p_event_id => l_event_id
807: ,p_business_group_id => l_enr_business_group_id

Line 1088: ota_tdb_api_upd2.Update_Enrollment(

1084:
1085: l_booking_ovn := db.object_version_number;
1086: ota_tdb_shd.lck(db.booking_id,l_booking_ovn);
1087:
1088: ota_tdb_api_upd2.Update_Enrollment(
1089: p_booking_id => db.booking_id
1090: ,p_event_id => l_event_id
1091: ,p_business_group_id => db.business_group_id
1092: ,p_booking_status_type_id => db.booking_status_type_id