APPS.OTA_OM_UPD_API dependencies on OTA_TDB_BUS

Line 1278: l_type := ota_tdb_bus.booking_status_type(l_type_id);

1274:
1275:
1276:
1277: if l_type_id is not null then
1278: l_type := ota_tdb_bus.booking_status_type(l_type_id);
1279: end if;
1280:
1281:
1282: IF l_type_id is NULL THEN

Line 1289: IF ota_tdb_bus.Booking_status_type(l_type_id) = 'R' then

1285: FETCH get_booking_status_type_id into l_booking_status_type_id,l_meaning;
1286: CLOSE get_booking_status_type_id;
1287:
1288: ELSE
1289: IF ota_tdb_bus.Booking_status_type(l_type_id) = 'R' then
1290:
1291: OPEN get_booking_status_type_id;
1292: FETCH get_booking_status_type_id into l_booking_status_type_id,l_meaning;
1293: CLOSE get_booking_status_type_id;

Line 1304: IF ota_tdb_bus.Booking_status_type(l_booking_status_type_id) = 'W' then

1300: END IF;
1301:
1302:
1303: -- ***
1304: IF ota_tdb_bus.Booking_status_type(l_booking_status_type_id) = 'W' then
1305: l_booking_priority := fnd_profile.value('OTA_WAITLIST_PRIORITY');
1306: if l_booking_priority is null then
1307: FND_MESSAGE.set_name ('OTA', 'OTA_13902_TDB_OM_NO_PROFILE');
1308: