[Home] [Help]
1: PACKAGE BODY cac_bookings_pub AS
2: /* $Header: cacpttbb.pls 120.3 2005/07/29 12:19:11 sbarat noship $ */
3:
4: PROCEDURE create_booking (
5: p_api_version IN NUMBER,
4: PROCEDURE create_booking (
5: p_api_version IN NUMBER,
6: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
7: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
8: p_booking_rec IN cac_bookings_pub.booking_type,
9: x_booking_id OUT NOCOPY NUMBER,
10: x_return_status OUT NOCOPY VARCHAR2,
11: x_msg_count OUT NOCOPY NUMBER,
12: x_msg_data OUT NOCOPY VARCHAR2
15: l_api_version CONSTANT NUMBER
16: := 1.0;
17: l_api_name CONSTANT VARCHAR2(30)
18: := 'CREATE_BOOKING';
19: l_booking_type_rec cac_bookings_pub.booking_type := p_booking_rec;
20:
21: BEGIN
22: SAVEPOINT create_bookings_pub;
23: x_return_status := fnd_api.g_ret_sts_success;
112: PROCEDURE update_booking (
113: p_api_version IN NUMBER,
114: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
115: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
116: p_booking_rec IN cac_bookings_pub.booking_type,
117: p_object_version_number IN NUMBER ,
118: x_return_status OUT NOCOPY VARCHAR2,
119: x_msg_count OUT NOCOPY NUMBER,
120: x_msg_data OUT NOCOPY VARCHAR2
125: := 1.0;
126: l_api_name CONSTANT VARCHAR2(30)
127: := 'UPDATE_BOOKING';
128: l_ovn NUMBER := p_object_version_number;
129: l_booking_type_rec cac_bookings_pub.booking_type := p_booking_rec;
130:
131: BEGIN
132: SAVEPOINT update_bookings_pub;
133: x_return_status := fnd_api.g_ret_sts_success;
246: END;
247:
248:
249: PROCEDURE validate_booking (
250: p_booking_rec IN cac_bookings_pub.booking_type,
251: x_return_status OUT NOCOPY VARCHAR2,
252: x_msg_count OUT NOCOPY NUMBER,
253: x_msg_data OUT NOCOPY VARCHAR2
254: )
252: x_msg_count OUT NOCOPY NUMBER,
253: x_msg_data OUT NOCOPY VARCHAR2
254: )
255: IS
256: l_booking_type_rec cac_bookings_pub.booking_type := p_booking_rec;
257:
258: BEGIN
259: -- For booking scheduled dates are populated --'
260: IF (l_booking_type_rec.start_date IS NULL)