DBA Data[Home] [Help]

PACKAGE: APPS.PER_BOOKINGS_SWI

Source


1 PACKAGE PER_BOOKINGS_SWI AUTHID CURRENT_USER As
2 /* $Header: pebkgswi.pkh 120.5 2010/08/19 11:59:59 kgowripe ship $ */
3 -- ----------------------------------------------------------------------------
4 -- |-------------------------< create_per_booking >---------------------------|
5 -- ----------------------------------------------------------------------------
6 -- {Start of comments}
7 --
8 -- Description:
9 --  This procedure is the self-service wrapper procedure to the following
10 --  API: ame_attribute_api.create_ame_attribute
11 --
12 -- Pre-requisites
13 --  All 'IN' parameters to this procedure have been appropriately derived.
14 --
15 -- Post Success:
16 --  p_return_status will return value indicating success.
17 --
18 -- Post Failure:
19 --  p_return_status will return value indication failure.
20 --
21 -- Access Status:
22 --  Internal Development use only.
23 --
24 -- {End of comments}
25 -- ----------------------------------------------------------------------------
26 --
27 -- ----------------------------------------------------------------------------
28 -- |-------------------------< create_per_booking >---------------------------|
29 -- ----------------------------------------------------------------------------
30 PROCEDURE create_per_bookings
31   (p_Rowid                        IN OUT NOCOPY VARCHAR2
32   ,p_Booking_Id                   IN OUT NOCOPY NUMBER
33   ,p_Business_Group_Id                   NUMBER
34   ,p_Person_Id                           NUMBER
35   ,p_Event_Id                            NUMBER
36   ,p_Message                             VARCHAR2   default null
37   ,p_Token                               VARCHAR2   default null
38   ,p_Comments                            VARCHAR2   default null
39   ,p_Attribute_Category                  VARCHAR2   default null
40   ,p_Attribute1                          VARCHAR2   default null
41   ,p_Attribute2                          VARCHAR2   default null
42   ,p_Attribute3                          VARCHAR2   default null
43   ,p_Attribute4                          VARCHAR2   default null
44   ,p_Attribute5                          VARCHAR2   default null
45   ,p_Attribute6                          VARCHAR2   default null
46   ,p_Attribute7                          VARCHAR2   default null
47   ,p_Attribute8                          VARCHAR2   default null
48   ,p_Attribute9                          VARCHAR2   default null
49   ,p_Attribute10                         VARCHAR2   default null
50   ,p_Attribute11                         VARCHAR2   default null
51   ,p_Attribute12                         VARCHAR2   default null
52   ,p_Attribute13                         VARCHAR2   default null
53   ,p_Attribute14                         VARCHAR2   default null
54   ,p_Attribute15                         VARCHAR2   default null
55   ,p_Attribute16                         VARCHAR2   default null
56   ,p_Attribute17                         VARCHAR2   default null
57   ,p_Attribute18                         VARCHAR2   default null
58   ,p_Attribute19                         VARCHAR2   default null
59   ,p_Attribute20                         VARCHAR2   default null
60   ,p_Primary_Interviewer_Flag            VARCHAR2   default null
61   ,p_return_status                   out nocopy varchar2
62   );
63 -- ----------------------------------------------------------------------------
64 -- |-------------------------< update_per_bookings >--------------------------|
65 -- ----------------------------------------------------------------------------
66 -- {Start of comments}
67 --
68 -- Description:
69 --  This procedure is the self-service wrapper procedure to the following
70 --  API: ame_attribute_api.create_ame_attribute
71 --
72 -- Pre-requisites
73 --  All 'IN' parameters to this procedure have been appropriately derived.
74 --
75 -- Post Success:
76 --  p_return_status will return value indicating success.
77 --
78 -- Post Failure:
79 --  p_return_status will return value indication failure.
80 --
81 -- Access Status:
82 --  Internal Development use only.
83 --
84 -- {End of comments}
85 -- ----------------------------------------------------------------------------
86 --
87 -- ----------------------------------------------------------------------------
88 -- |-------------------------< update_per_booking >---------------------------|
89 -- ----------------------------------------------------------------------------
90 PROCEDURE update_per_bookings
91   (p_Rowid                        IN OUT NOCOPY VARCHAR2
92   ,p_Booking_Id                   IN OUT NOCOPY NUMBER
93   ,p_Business_Group_Id                   NUMBER
94   ,p_Person_Id                           NUMBER
95   ,p_Event_Id                            NUMBER
96   ,p_Message                             VARCHAR2   default hr_api.g_varchar2
97   ,p_Token                               VARCHAR2   default hr_api.g_varchar2
98   ,p_Comments                            VARCHAR2   default hr_api.g_varchar2
99   ,p_Attribute_Category                  VARCHAR2   default hr_api.g_varchar2
100   ,p_Attribute1                          VARCHAR2   default hr_api.g_varchar2
101   ,p_Attribute2                          VARCHAR2   default hr_api.g_varchar2
102   ,p_Attribute3                          VARCHAR2   default hr_api.g_varchar2
103   ,p_Attribute4                          VARCHAR2   default hr_api.g_varchar2
104   ,p_Attribute5                          VARCHAR2   default hr_api.g_varchar2
105   ,p_Attribute6                          VARCHAR2   default hr_api.g_varchar2
106   ,p_Attribute7                          VARCHAR2   default hr_api.g_varchar2
107   ,p_Attribute8                          VARCHAR2   default hr_api.g_varchar2
108   ,p_Attribute9                          VARCHAR2   default hr_api.g_varchar2
109   ,p_Attribute10                         VARCHAR2   default hr_api.g_varchar2
110   ,p_Attribute11                         VARCHAR2   default hr_api.g_varchar2
111   ,p_Attribute12                         VARCHAR2   default hr_api.g_varchar2
112   ,p_Attribute13                         VARCHAR2   default hr_api.g_varchar2
113   ,p_Attribute14                         VARCHAR2   default hr_api.g_varchar2
114   ,p_Attribute15                         VARCHAR2   default hr_api.g_varchar2
115   ,p_Attribute16                         VARCHAR2   default hr_api.g_varchar2
116   ,p_Attribute17                         VARCHAR2   default hr_api.g_varchar2
117   ,p_Attribute18                         VARCHAR2   default hr_api.g_varchar2
118   ,p_Attribute19                         VARCHAR2   default hr_api.g_varchar2
119   ,p_Attribute20                         VARCHAR2   default hr_api.g_varchar2
120   ,p_Primary_Interviewer_Flag            VARCHAR2   default null
121   ,p_return_status                   out nocopy varchar2
122   );
123 ---
124 PROCEDURE delete_per_bookings
125   (p_Booking_Id                   IN NUMBER
126   ,p_return_status                    out nocopy varchar2
127   );
128 ---
129 end PER_BOOKINGS_SWI;