104: INDEX BY BINARY_INTEGER;
105: ---------------------------------------------------------------------------
106: -- GLOBAL MESSAGE CONSTANTS
107: ---------------------------------------------------------------------------
108: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
109: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
110: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
111: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
112: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
105: ---------------------------------------------------------------------------
106: -- GLOBAL MESSAGE CONSTANTS
107: ---------------------------------------------------------------------------
108: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
109: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
110: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
111: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
112: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
113: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
106: -- GLOBAL MESSAGE CONSTANTS
107: ---------------------------------------------------------------------------
108: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
109: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
110: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
111: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
112: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
113: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
114: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
107: ---------------------------------------------------------------------------
108: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
109: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
110: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
111: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
112: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
113: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
114: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
115: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
108: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
109: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
110: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
111: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
112: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
113: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
114: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
115: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
116: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
109: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
110: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
111: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
112: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
113: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
114: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
115: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
116: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
117: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
110: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
111: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
112: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
113: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
114: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
115: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
116: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
117: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
118: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
111: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
112: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
113: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
114: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
115: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
116: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
117: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
118: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
119: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
112: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
113: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
114: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
115: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
116: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
117: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
118: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
119: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
120: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
113: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
114: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
115: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
116: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
117: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
118: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
119: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
120: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
121:
127: ---------------------------------------------------------------------------
128: -- GLOBAL VARIABLES
129: ---------------------------------------------------------------------------
130: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_DRA_PVT';
131: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
132: ---------------------------------------------------------------------------
133: -- Procedures and Functions
134: ---------------------------------------------------------------------------
135:
138: PROCEDURE api_copy;
139: PROCEDURE add_language;
140: PROCEDURE insert_row(
141: p_api_version IN NUMBER,
142: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
143: x_return_status OUT NOCOPY VARCHAR2,
144: x_msg_count OUT NOCOPY NUMBER,
145: x_msg_data OUT NOCOPY VARCHAR2,
146: p_drav_rec IN drav_rec_type,
146: p_drav_rec IN drav_rec_type,
147: x_drav_rec OUT NOCOPY drav_rec_type);
148: PROCEDURE insert_row(
149: p_api_version IN NUMBER,
150: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
151: x_return_status OUT NOCOPY VARCHAR2,
152: x_msg_count OUT NOCOPY NUMBER,
153: x_msg_data OUT NOCOPY VARCHAR2,
154: p_drav_tbl IN drav_tbl_type,
152: x_msg_count OUT NOCOPY NUMBER,
153: x_msg_data OUT NOCOPY VARCHAR2,
154: p_drav_tbl IN drav_tbl_type,
155: x_drav_tbl OUT NOCOPY drav_tbl_type,
156: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
157: PROCEDURE insert_row(
158: p_api_version IN NUMBER,
159: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
160: x_return_status OUT NOCOPY VARCHAR2,
155: x_drav_tbl OUT NOCOPY drav_tbl_type,
156: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
157: PROCEDURE insert_row(
158: p_api_version IN NUMBER,
159: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
160: x_return_status OUT NOCOPY VARCHAR2,
161: x_msg_count OUT NOCOPY NUMBER,
162: x_msg_data OUT NOCOPY VARCHAR2,
163: p_drav_tbl IN drav_tbl_type,
163: p_drav_tbl IN drav_tbl_type,
164: x_drav_tbl OUT NOCOPY drav_tbl_type);
165: PROCEDURE lock_row(
166: p_api_version IN NUMBER,
167: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
168: x_return_status OUT NOCOPY VARCHAR2,
169: x_msg_count OUT NOCOPY NUMBER,
170: x_msg_data OUT NOCOPY VARCHAR2,
171: p_drav_rec IN drav_rec_type);
170: x_msg_data OUT NOCOPY VARCHAR2,
171: p_drav_rec IN drav_rec_type);
172: PROCEDURE lock_row(
173: p_api_version IN NUMBER,
174: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
175: x_return_status OUT NOCOPY VARCHAR2,
176: x_msg_count OUT NOCOPY NUMBER,
177: x_msg_data OUT NOCOPY VARCHAR2,
178: p_drav_tbl IN drav_tbl_type,
175: x_return_status OUT NOCOPY VARCHAR2,
176: x_msg_count OUT NOCOPY NUMBER,
177: x_msg_data OUT NOCOPY VARCHAR2,
178: p_drav_tbl IN drav_tbl_type,
179: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
180: PROCEDURE lock_row(
181: p_api_version IN NUMBER,
182: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
183: x_return_status OUT NOCOPY VARCHAR2,
178: p_drav_tbl IN drav_tbl_type,
179: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
180: PROCEDURE lock_row(
181: p_api_version IN NUMBER,
182: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
183: x_return_status OUT NOCOPY VARCHAR2,
184: x_msg_count OUT NOCOPY NUMBER,
185: x_msg_data OUT NOCOPY VARCHAR2,
186: p_drav_tbl IN drav_tbl_type);
185: x_msg_data OUT NOCOPY VARCHAR2,
186: p_drav_tbl IN drav_tbl_type);
187: PROCEDURE update_row(
188: p_api_version IN NUMBER,
189: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
190: x_return_status OUT NOCOPY VARCHAR2,
191: x_msg_count OUT NOCOPY NUMBER,
192: x_msg_data OUT NOCOPY VARCHAR2,
193: p_drav_rec IN drav_rec_type,
193: p_drav_rec IN drav_rec_type,
194: x_drav_rec OUT NOCOPY drav_rec_type);
195: PROCEDURE update_row(
196: p_api_version IN NUMBER,
197: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
198: x_return_status OUT NOCOPY VARCHAR2,
199: x_msg_count OUT NOCOPY NUMBER,
200: x_msg_data OUT NOCOPY VARCHAR2,
201: p_drav_tbl IN drav_tbl_type,
199: x_msg_count OUT NOCOPY NUMBER,
200: x_msg_data OUT NOCOPY VARCHAR2,
201: p_drav_tbl IN drav_tbl_type,
202: x_drav_tbl OUT NOCOPY drav_tbl_type,
203: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
204: PROCEDURE update_row(
205: p_api_version IN NUMBER,
206: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
207: x_return_status OUT NOCOPY VARCHAR2,
202: x_drav_tbl OUT NOCOPY drav_tbl_type,
203: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
204: PROCEDURE update_row(
205: p_api_version IN NUMBER,
206: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
207: x_return_status OUT NOCOPY VARCHAR2,
208: x_msg_count OUT NOCOPY NUMBER,
209: x_msg_data OUT NOCOPY VARCHAR2,
210: p_drav_tbl IN drav_tbl_type,
210: p_drav_tbl IN drav_tbl_type,
211: x_drav_tbl OUT NOCOPY drav_tbl_type);
212: PROCEDURE delete_row(
213: p_api_version IN NUMBER,
214: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
215: x_return_status OUT NOCOPY VARCHAR2,
216: x_msg_count OUT NOCOPY NUMBER,
217: x_msg_data OUT NOCOPY VARCHAR2,
218: p_drav_rec IN drav_rec_type);
217: x_msg_data OUT NOCOPY VARCHAR2,
218: p_drav_rec IN drav_rec_type);
219: PROCEDURE delete_row(
220: p_api_version IN NUMBER,
221: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
222: x_return_status OUT NOCOPY VARCHAR2,
223: x_msg_count OUT NOCOPY NUMBER,
224: x_msg_data OUT NOCOPY VARCHAR2,
225: p_drav_tbl IN drav_tbl_type,
222: x_return_status OUT NOCOPY VARCHAR2,
223: x_msg_count OUT NOCOPY NUMBER,
224: x_msg_data OUT NOCOPY VARCHAR2,
225: p_drav_tbl IN drav_tbl_type,
226: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
227: PROCEDURE delete_row(
228: p_api_version IN NUMBER,
229: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
230: x_return_status OUT NOCOPY VARCHAR2,
225: p_drav_tbl IN drav_tbl_type,
226: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
227: PROCEDURE delete_row(
228: p_api_version IN NUMBER,
229: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
230: x_return_status OUT NOCOPY VARCHAR2,
231: x_msg_count OUT NOCOPY NUMBER,
232: x_msg_data OUT NOCOPY VARCHAR2,
233: p_drav_tbl IN drav_tbl_type);
232: x_msg_data OUT NOCOPY VARCHAR2,
233: p_drav_tbl IN drav_tbl_type);
234: PROCEDURE validate_row(
235: p_api_version IN NUMBER,
236: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
237: x_return_status OUT NOCOPY VARCHAR2,
238: x_msg_count OUT NOCOPY NUMBER,
239: x_msg_data OUT NOCOPY VARCHAR2,
240: p_drav_rec IN drav_rec_type);
239: x_msg_data OUT NOCOPY VARCHAR2,
240: p_drav_rec IN drav_rec_type);
241: PROCEDURE validate_row(
242: p_api_version IN NUMBER,
243: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
244: x_return_status OUT NOCOPY VARCHAR2,
245: x_msg_count OUT NOCOPY NUMBER,
246: x_msg_data OUT NOCOPY VARCHAR2,
247: p_drav_tbl IN drav_tbl_type,
244: x_return_status OUT NOCOPY VARCHAR2,
245: x_msg_count OUT NOCOPY NUMBER,
246: x_msg_data OUT NOCOPY VARCHAR2,
247: p_drav_tbl IN drav_tbl_type,
248: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
249: PROCEDURE validate_row(
250: p_api_version IN NUMBER,
251: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
252: x_return_status OUT NOCOPY VARCHAR2,
247: p_drav_tbl IN drav_tbl_type,
248: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
249: PROCEDURE validate_row(
250: p_api_version IN NUMBER,
251: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
252: x_return_status OUT NOCOPY VARCHAR2,
253: x_msg_count OUT NOCOPY NUMBER,
254: x_msg_data OUT NOCOPY VARCHAR2,
255: p_drav_tbl IN drav_tbl_type);