PACKAGE: APPS.CAC_BOOKINGS_PUB

Source

1 PACKAGE cac_bookings_pub  AUTHID CURRENT_USER AS
2 /* $Header: cacpttbs.pls 120.1 2005/06/10 20:13:52 rhshriva noship $ */
3 
4   g_pkg_name   CONSTANT VARCHAR2(30)	      := 'cac_bookings_pub';
5 
6   TYPE booking_type IS RECORD (
7         booking_id                NUMBER := NULL,
8         resource_type_code        jtf_objects_b.object_code%TYPE,
9         resource_id               jtf_tasks_b.owner_id%TYPE,
10         start_date                jtf_tasks_b.scheduled_start_date%TYPE,
11         end_date                  jtf_tasks_b.scheduled_end_date%TYPE,
12         booking_type_id           jtf_tasks_b.task_type_id%TYPE,
13         booking_status_id         jtf_tasks_b.task_status_id%TYPE,
14         source_object_type_code   jtf_tasks_b.source_object_type_code%TYPE,
15         source_object_id          jtf_tasks_b.source_object_id%TYPE,
16         booking_subject           jtf_tasks_tl.task_name%TYPE,
17         freebusytype              VARCHAR2(30)  DEFAULT 'BUSY',
18         description               jtf_tasks_tl.description%type
19    );
20 
21 
22    PROCEDURE create_booking (
23       p_api_version        IN              NUMBER,
24       p_init_msg_list      IN              VARCHAR2 DEFAULT fnd_api.g_false,
25       p_commit             IN              VARCHAR2 DEFAULT fnd_api.g_false,
26       p_booking_rec        IN              cac_bookings_pub.booking_type,
27       x_booking_id         OUT NOCOPY      NUMBER,
28       x_return_status      OUT NOCOPY      VARCHAR2,
29       x_msg_count          OUT NOCOPY      NUMBER,
30       x_msg_data           OUT NOCOPY      VARCHAR2
31    );
32 
33    PROCEDURE update_booking (
34       p_api_version        IN              NUMBER,
35       p_init_msg_list      IN              VARCHAR2 DEFAULT fnd_api.g_false,
36       p_commit             IN              VARCHAR2 DEFAULT fnd_api.g_false,
37       p_booking_rec        IN              cac_bookings_pub.booking_type,
38       p_object_version_number   IN         NUMBER ,
39       x_return_status      OUT NOCOPY      VARCHAR2,
40       x_msg_count          OUT NOCOPY      NUMBER,
41       x_msg_data           OUT NOCOPY      VARCHAR2
42    );
43 
44     PROCEDURE validate_booking (
45        p_booking_rec        IN              cac_bookings_pub.booking_type,
46 	   x_return_status      OUT NOCOPY      VARCHAR2,
47        x_msg_count          OUT NOCOPY      NUMBER,
48        x_msg_data           OUT NOCOPY      VARCHAR2
49    );
50 
51    PROCEDURE delete_booking (
52       p_api_version     IN              NUMBER,
53       p_init_msg_list   IN              VARCHAR2 DEFAULT fnd_api.g_false,
54       p_commit          IN              VARCHAR2 DEFAULT fnd_api.g_false,
55       p_booking_id      IN              NUMBER,
56 	  p_object_version_number   IN      NUMBER ,
57       x_return_status   OUT NOCOPY      VARCHAR2,
58       x_msg_count       OUT NOCOPY      NUMBER,
59       x_msg_data        OUT NOCOPY      VARCHAR2
60    );
61 
62 
63 END;