1 Package ota_bkng_justification_api AUTHID CURRENT_USER as
2 /* $Header: otbjsapi.pkh 120.1 2006/08/30 06:55:10 niarora noship $ */
3 /*#
4 * This package contains Booking Justification APIs.
5 * @rep:scope public
6 * @rep:product OTA
7 * @rep:displayname Booking Justification
8 */
9 --
10 -- ----------------------------------------------------------------------------
11 -- |-----------------------< create_booking_justification >-------------------|
12 -- ----------------------------------------------------------------------------
13 --
14 -- {Start Of Comments}
15 /*#
16 * This API creates the booking justification.
17 *
18 *
19 * <p><b>Licensing</b><br>
20 * This API is licensed for use with Learning Management.
21 *
22 * <p><b>Prerequisites</b><br>
23 * Business group record must exist.
24 *
25 * <p><b>Post Success</b><br>
26 * The booking justification was created successfully.
27 *
28 * <p><b>Post Failure</b><br>
29 * The API did not create a booking justification record and has raised an error.
30 *
31 * @param p_effective_date Reference date for validating that lookup values are applicable
32 * during the start-to-end active date range. This date does not determine when
33 * the changes take effect.
34 * @param p_validate If true, then validation alone will be performed and the
35 * database will remain unchanged. If false and all validation checks pass,
36 * then the database will be modified.
37 * @param p_business_group_id The business group owning the section record and the Learning Path.
38 * @param p_priority_level Enrollment Priority. Valid values are defined by the
39 * 'PRIORITY_LEVEL' lookup type.
40 * @param p_justification_text The description of the justification.
41 * @param p_start_date_active The start date of the active period for booking justification.
42 * @param p_end_date_active The end date of the active period for booking justification.
43 * @param p_booking_justification_id The unique identifier for the booking justification record.
44 * @param p_object_version_number If p_validate is false, then set to the version number of
45 * the created learning path section. If p_validate is true, then the value will be null.
46 * @rep:displayname Create Booking Justification
47 * @rep:category BUSINESS_ENTITY OTA_ENROLLMENT_JUSTIFICATION
48 * @rep:lifecycle active
49 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
50 * @rep:scope public
51 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
52 */
53 --
54 -- {End Of Comments}
55 --
56 procedure create_booking_justification
57 (
58 p_effective_date in date,
59 p_validate in boolean default false ,
60 p_business_group_id in number,
61 p_priority_level in varchar2,
62 p_justification_text in varchar2,
63 p_start_date_active in date,
64 p_end_date_active in date default null,
65 p_booking_justification_id out nocopy number,
66 p_object_version_number out nocopy number
67 );
68 --
69 -- ----------------------------------------------------------------------------
70 -- |-----------------------< update_booking_justification >-------------------|
71 -- ----------------------------------------------------------------------------
72 --
73 -- {Start Of Comments}
74 /*#
75 * This API updates the booking justification.
76 *
77 *
78 * <p><b>Licensing</b><br>
79 * This API is licensed for use with Learning Management.
80 *
81 * <p><b>Prerequisites</b><br>
82 * The booking justification record with the given object version number should exist.
83 *
84 * <p><b>Post Success</b><br>
85 * The booking justification has been updated successfully.
86 *
87 * <p><b>Post Failure</b><br>
88 * The API did not update a booking justification record and has raised an error.
89 *
90 * @param p_effective_date Reference date for validating that lookup values
91 * are applicable during the start-to-end active date range. This date
92 * does not determine when the changes take effect.
93 * @param p_booking_justification_id The unique identifier for the booking justification record.
94 * @param p_object_version_number Passes in the current version number of the learning path
95 * section to be updated. When the API completes, if p_validate is false, will be set to
96 * the new version number of the updated learning path section. If p_validate is true will be
97 * set to the same value which was passed in.
98 * @param p_priority_level Enrollment Priority. Valid values are defined by the
99 * 'PRIORITY_LEVEL' lookup type.
100 * @param p_justification_text The description of the justification.
101 * @param p_start_date_active The start date of the active period for booking justification.
102 * @param p_end_date_active The end date of the active period for booking justification.
103 * @param p_business_group_id The business group owning the section record and the Learning Path.
104 * @param p_validate If true, then validation alone will be performed and the
105 * database will remain unchanged. If false and all validation checks pass,
106 * then the database will be modified.
107 * @rep:displayname Update Booking Justification
108 * @rep:category BUSINESS_ENTITY OTA_ENROLLMENT_JUSTIFICATION
109 * @rep:lifecycle active
110 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
111 * @rep:scope public
112 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
113 */
114 --
115 -- {End Of Comments}
116 --
117 procedure Update_booking_justification
118 (
119 p_effective_date in date,
120 p_booking_justification_id in number,
121 p_object_version_number in out nocopy number,
122 p_priority_level in varchar2 default hr_api.g_varchar2,
123 p_justification_text in varchar2 default hr_api.g_varchar2,
124 p_start_date_active in date default hr_api.g_date,
125 p_end_date_active in date default hr_api.g_date,
126 p_business_group_id in number default hr_api.g_number,
127 p_validate in boolean default false
128 );
129 --
130 -- ----------------------------------------------------------------------------
131 -- |-----------------------< delete_booking_justification >-------------------|
132 -- ----------------------------------------------------------------------------
133 --
134 -- {Start Of Comments}
135 /*#
136 * This API deletes the booking justification.
137 *
138 *
139 * <p><b>Licensing</b><br>
140 * This API is licensed for use with Learning Management.
141 *
142 * <p><b>Prerequisites</b><br>
143 * The booking justification record with the given object version number should exist.
144 *
145 * <p><b>Post Success</b><br>
146 * The booking justification has been deleted successfully.
147 *
148 * <p><b>Post Failure</b><br>
149 * The API has not deleted the booking justification record, and has raised an error.
150 *
151 * @param p_booking_justification_id The unique identifier for the booking justification record.
152 * @param p_object_version_number Current version number of the learning path section to be deleted.
153 * @param p_validate If true, then validation alone will be performed and the
154 * database will remain unchanged. If false and all validation checks pass,
155 * then the database will be modified.
156 * @rep:displayname Delete Booking Justification
157 * @rep:category BUSINESS_ENTITY OTA_ENROLLMENT_JUSTIFICATION
158 * @rep:lifecycle active
159 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
160 * @rep:scope public
161 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
162 */
163 --
164 -- {End Of Comments}
165 --
166
167 procedure delete_booking_justification
168 (p_booking_justification_id in number
169 ,p_object_version_number in number
170 ,p_validate in boolean default false
171 );
172 end ota_bkng_justification_api;