DBA Data[Home] [Help]

APPS.OTA_CANCEL_API dependencies on OTA_TDB_SHD

Line 661: ota_tdb_shd.lck(l_booking_id,l_enr_ovn);

657: IF l_status_id is not null THEN
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

Line 699: ota_tdb_shd.lck(l_booking_id,l_enr_ovn);

695: FND_FILE.PUT_LINE(FND_FILE.LOG,'Processing booking id : ' || l_booking_id);
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

Line 732: ota_tdb_shd.lck(l_booking_id,l_enr_ovn);

728: IF l_status_id is not null THEN
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

Line 774: ota_tdb_shd.lck(l_booking_id,l_enr_ovn);

770:
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

Line 802: ota_tdb_shd.lck(l_booking_id,l_enr_ovn);

798: FND_FILE.PUT_LINE(FND_FILE.LOG,'Processing booking id : ' || l_booking_id);
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

Line 1086: ota_tdb_shd.lck(db.booking_id,l_booking_ovn);

1082: l_update_finance := 'N';
1083: end if;
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