[Home] [Help]
191: BEGIN
192: RETURN(get_rec(p_cllv_rec, l_row_not_found));
193: END get_rec;
194: ---------------------------------------------------------------------------
195: -- FUNCTION get_rec for: OKL_CNTR_LVLNG_LNS_B
196: ---------------------------------------------------------------------------
197: FUNCTION get_rec (
198: p_okl_cntr_lvlng_lns_b_rec IN okl_cntr_lvlng_lns_b_rec_type,
199: x_no_data_found OUT NOCOPY BOOLEAN
194: ---------------------------------------------------------------------------
195: -- FUNCTION get_rec for: OKL_CNTR_LVLNG_LNS_B
196: ---------------------------------------------------------------------------
197: FUNCTION get_rec (
198: p_okl_cntr_lvlng_lns_b_rec IN okl_cntr_lvlng_lns_b_rec_type,
199: x_no_data_found OUT NOCOPY BOOLEAN
200: ) RETURN okl_cntr_lvlng_lns_b_rec_type IS
201: CURSOR okl_cntr_lvlng_lns_b_pk_csr (p_id IN NUMBER) IS
202: SELECT
196: ---------------------------------------------------------------------------
197: FUNCTION get_rec (
198: p_okl_cntr_lvlng_lns_b_rec IN okl_cntr_lvlng_lns_b_rec_type,
199: x_no_data_found OUT NOCOPY BOOLEAN
200: ) RETURN okl_cntr_lvlng_lns_b_rec_type IS
201: CURSOR okl_cntr_lvlng_lns_b_pk_csr (p_id IN NUMBER) IS
202: SELECT
203: ID,
204: KLE_ID,
197: FUNCTION get_rec (
198: p_okl_cntr_lvlng_lns_b_rec IN okl_cntr_lvlng_lns_b_rec_type,
199: x_no_data_found OUT NOCOPY BOOLEAN
200: ) RETURN okl_cntr_lvlng_lns_b_rec_type IS
201: CURSOR okl_cntr_lvlng_lns_b_pk_csr (p_id IN NUMBER) IS
202: SELECT
203: ID,
204: KLE_ID,
205: CLG_ID,
224: CREATION_DATE,
225: LAST_UPDATED_BY,
226: LAST_UPDATE_DATE,
227: LAST_UPDATE_LOGIN
228: FROM Okl_Cntr_Lvlng_Lns_B
229: WHERE okl_cntr_lvlng_lns_b.id = p_id;
230: l_okl_cntr_lvlng_lns_b_pk okl_cntr_lvlng_lns_b_pk_csr%ROWTYPE;
231: l_okl_cntr_lvlng_lns_b_rec okl_cntr_lvlng_lns_b_rec_type;
232: BEGIN
225: LAST_UPDATED_BY,
226: LAST_UPDATE_DATE,
227: LAST_UPDATE_LOGIN
228: FROM Okl_Cntr_Lvlng_Lns_B
229: WHERE okl_cntr_lvlng_lns_b.id = p_id;
230: l_okl_cntr_lvlng_lns_b_pk okl_cntr_lvlng_lns_b_pk_csr%ROWTYPE;
231: l_okl_cntr_lvlng_lns_b_rec okl_cntr_lvlng_lns_b_rec_type;
232: BEGIN
233: x_no_data_found := TRUE;
226: LAST_UPDATE_DATE,
227: LAST_UPDATE_LOGIN
228: FROM Okl_Cntr_Lvlng_Lns_B
229: WHERE okl_cntr_lvlng_lns_b.id = p_id;
230: l_okl_cntr_lvlng_lns_b_pk okl_cntr_lvlng_lns_b_pk_csr%ROWTYPE;
231: l_okl_cntr_lvlng_lns_b_rec okl_cntr_lvlng_lns_b_rec_type;
232: BEGIN
233: x_no_data_found := TRUE;
234: -- Get current database values
227: LAST_UPDATE_LOGIN
228: FROM Okl_Cntr_Lvlng_Lns_B
229: WHERE okl_cntr_lvlng_lns_b.id = p_id;
230: l_okl_cntr_lvlng_lns_b_pk okl_cntr_lvlng_lns_b_pk_csr%ROWTYPE;
231: l_okl_cntr_lvlng_lns_b_rec okl_cntr_lvlng_lns_b_rec_type;
232: BEGIN
233: x_no_data_found := TRUE;
234: -- Get current database values
235: OPEN okl_cntr_lvlng_lns_b_pk_csr (p_okl_cntr_lvlng_lns_b_rec.id);
231: l_okl_cntr_lvlng_lns_b_rec okl_cntr_lvlng_lns_b_rec_type;
232: BEGIN
233: x_no_data_found := TRUE;
234: -- Get current database values
235: OPEN okl_cntr_lvlng_lns_b_pk_csr (p_okl_cntr_lvlng_lns_b_rec.id);
236: FETCH okl_cntr_lvlng_lns_b_pk_csr INTO
237: l_okl_cntr_lvlng_lns_b_rec.id,
238: l_okl_cntr_lvlng_lns_b_rec.kle_id,
239: l_okl_cntr_lvlng_lns_b_rec.clg_id,
232: BEGIN
233: x_no_data_found := TRUE;
234: -- Get current database values
235: OPEN okl_cntr_lvlng_lns_b_pk_csr (p_okl_cntr_lvlng_lns_b_rec.id);
236: FETCH okl_cntr_lvlng_lns_b_pk_csr INTO
237: l_okl_cntr_lvlng_lns_b_rec.id,
238: l_okl_cntr_lvlng_lns_b_rec.kle_id,
239: l_okl_cntr_lvlng_lns_b_rec.clg_id,
240: l_okl_cntr_lvlng_lns_b_rec.object_version_number,
233: x_no_data_found := TRUE;
234: -- Get current database values
235: OPEN okl_cntr_lvlng_lns_b_pk_csr (p_okl_cntr_lvlng_lns_b_rec.id);
236: FETCH okl_cntr_lvlng_lns_b_pk_csr INTO
237: l_okl_cntr_lvlng_lns_b_rec.id,
238: l_okl_cntr_lvlng_lns_b_rec.kle_id,
239: l_okl_cntr_lvlng_lns_b_rec.clg_id,
240: l_okl_cntr_lvlng_lns_b_rec.object_version_number,
241: l_okl_cntr_lvlng_lns_b_rec.attribute_category,
234: -- Get current database values
235: OPEN okl_cntr_lvlng_lns_b_pk_csr (p_okl_cntr_lvlng_lns_b_rec.id);
236: FETCH okl_cntr_lvlng_lns_b_pk_csr INTO
237: l_okl_cntr_lvlng_lns_b_rec.id,
238: l_okl_cntr_lvlng_lns_b_rec.kle_id,
239: l_okl_cntr_lvlng_lns_b_rec.clg_id,
240: l_okl_cntr_lvlng_lns_b_rec.object_version_number,
241: l_okl_cntr_lvlng_lns_b_rec.attribute_category,
242: l_okl_cntr_lvlng_lns_b_rec.attribute1,
235: OPEN okl_cntr_lvlng_lns_b_pk_csr (p_okl_cntr_lvlng_lns_b_rec.id);
236: FETCH okl_cntr_lvlng_lns_b_pk_csr INTO
237: l_okl_cntr_lvlng_lns_b_rec.id,
238: l_okl_cntr_lvlng_lns_b_rec.kle_id,
239: l_okl_cntr_lvlng_lns_b_rec.clg_id,
240: l_okl_cntr_lvlng_lns_b_rec.object_version_number,
241: l_okl_cntr_lvlng_lns_b_rec.attribute_category,
242: l_okl_cntr_lvlng_lns_b_rec.attribute1,
243: l_okl_cntr_lvlng_lns_b_rec.attribute2,
236: FETCH okl_cntr_lvlng_lns_b_pk_csr INTO
237: l_okl_cntr_lvlng_lns_b_rec.id,
238: l_okl_cntr_lvlng_lns_b_rec.kle_id,
239: l_okl_cntr_lvlng_lns_b_rec.clg_id,
240: l_okl_cntr_lvlng_lns_b_rec.object_version_number,
241: l_okl_cntr_lvlng_lns_b_rec.attribute_category,
242: l_okl_cntr_lvlng_lns_b_rec.attribute1,
243: l_okl_cntr_lvlng_lns_b_rec.attribute2,
244: l_okl_cntr_lvlng_lns_b_rec.attribute3,
237: l_okl_cntr_lvlng_lns_b_rec.id,
238: l_okl_cntr_lvlng_lns_b_rec.kle_id,
239: l_okl_cntr_lvlng_lns_b_rec.clg_id,
240: l_okl_cntr_lvlng_lns_b_rec.object_version_number,
241: l_okl_cntr_lvlng_lns_b_rec.attribute_category,
242: l_okl_cntr_lvlng_lns_b_rec.attribute1,
243: l_okl_cntr_lvlng_lns_b_rec.attribute2,
244: l_okl_cntr_lvlng_lns_b_rec.attribute3,
245: l_okl_cntr_lvlng_lns_b_rec.attribute4,
238: l_okl_cntr_lvlng_lns_b_rec.kle_id,
239: l_okl_cntr_lvlng_lns_b_rec.clg_id,
240: l_okl_cntr_lvlng_lns_b_rec.object_version_number,
241: l_okl_cntr_lvlng_lns_b_rec.attribute_category,
242: l_okl_cntr_lvlng_lns_b_rec.attribute1,
243: l_okl_cntr_lvlng_lns_b_rec.attribute2,
244: l_okl_cntr_lvlng_lns_b_rec.attribute3,
245: l_okl_cntr_lvlng_lns_b_rec.attribute4,
246: l_okl_cntr_lvlng_lns_b_rec.attribute5,
239: l_okl_cntr_lvlng_lns_b_rec.clg_id,
240: l_okl_cntr_lvlng_lns_b_rec.object_version_number,
241: l_okl_cntr_lvlng_lns_b_rec.attribute_category,
242: l_okl_cntr_lvlng_lns_b_rec.attribute1,
243: l_okl_cntr_lvlng_lns_b_rec.attribute2,
244: l_okl_cntr_lvlng_lns_b_rec.attribute3,
245: l_okl_cntr_lvlng_lns_b_rec.attribute4,
246: l_okl_cntr_lvlng_lns_b_rec.attribute5,
247: l_okl_cntr_lvlng_lns_b_rec.attribute6,
240: l_okl_cntr_lvlng_lns_b_rec.object_version_number,
241: l_okl_cntr_lvlng_lns_b_rec.attribute_category,
242: l_okl_cntr_lvlng_lns_b_rec.attribute1,
243: l_okl_cntr_lvlng_lns_b_rec.attribute2,
244: l_okl_cntr_lvlng_lns_b_rec.attribute3,
245: l_okl_cntr_lvlng_lns_b_rec.attribute4,
246: l_okl_cntr_lvlng_lns_b_rec.attribute5,
247: l_okl_cntr_lvlng_lns_b_rec.attribute6,
248: l_okl_cntr_lvlng_lns_b_rec.attribute7,
241: l_okl_cntr_lvlng_lns_b_rec.attribute_category,
242: l_okl_cntr_lvlng_lns_b_rec.attribute1,
243: l_okl_cntr_lvlng_lns_b_rec.attribute2,
244: l_okl_cntr_lvlng_lns_b_rec.attribute3,
245: l_okl_cntr_lvlng_lns_b_rec.attribute4,
246: l_okl_cntr_lvlng_lns_b_rec.attribute5,
247: l_okl_cntr_lvlng_lns_b_rec.attribute6,
248: l_okl_cntr_lvlng_lns_b_rec.attribute7,
249: l_okl_cntr_lvlng_lns_b_rec.attribute8,
242: l_okl_cntr_lvlng_lns_b_rec.attribute1,
243: l_okl_cntr_lvlng_lns_b_rec.attribute2,
244: l_okl_cntr_lvlng_lns_b_rec.attribute3,
245: l_okl_cntr_lvlng_lns_b_rec.attribute4,
246: l_okl_cntr_lvlng_lns_b_rec.attribute5,
247: l_okl_cntr_lvlng_lns_b_rec.attribute6,
248: l_okl_cntr_lvlng_lns_b_rec.attribute7,
249: l_okl_cntr_lvlng_lns_b_rec.attribute8,
250: l_okl_cntr_lvlng_lns_b_rec.attribute9,
243: l_okl_cntr_lvlng_lns_b_rec.attribute2,
244: l_okl_cntr_lvlng_lns_b_rec.attribute3,
245: l_okl_cntr_lvlng_lns_b_rec.attribute4,
246: l_okl_cntr_lvlng_lns_b_rec.attribute5,
247: l_okl_cntr_lvlng_lns_b_rec.attribute6,
248: l_okl_cntr_lvlng_lns_b_rec.attribute7,
249: l_okl_cntr_lvlng_lns_b_rec.attribute8,
250: l_okl_cntr_lvlng_lns_b_rec.attribute9,
251: l_okl_cntr_lvlng_lns_b_rec.attribute10,
244: l_okl_cntr_lvlng_lns_b_rec.attribute3,
245: l_okl_cntr_lvlng_lns_b_rec.attribute4,
246: l_okl_cntr_lvlng_lns_b_rec.attribute5,
247: l_okl_cntr_lvlng_lns_b_rec.attribute6,
248: l_okl_cntr_lvlng_lns_b_rec.attribute7,
249: l_okl_cntr_lvlng_lns_b_rec.attribute8,
250: l_okl_cntr_lvlng_lns_b_rec.attribute9,
251: l_okl_cntr_lvlng_lns_b_rec.attribute10,
252: l_okl_cntr_lvlng_lns_b_rec.attribute11,
245: l_okl_cntr_lvlng_lns_b_rec.attribute4,
246: l_okl_cntr_lvlng_lns_b_rec.attribute5,
247: l_okl_cntr_lvlng_lns_b_rec.attribute6,
248: l_okl_cntr_lvlng_lns_b_rec.attribute7,
249: l_okl_cntr_lvlng_lns_b_rec.attribute8,
250: l_okl_cntr_lvlng_lns_b_rec.attribute9,
251: l_okl_cntr_lvlng_lns_b_rec.attribute10,
252: l_okl_cntr_lvlng_lns_b_rec.attribute11,
253: l_okl_cntr_lvlng_lns_b_rec.attribute12,
246: l_okl_cntr_lvlng_lns_b_rec.attribute5,
247: l_okl_cntr_lvlng_lns_b_rec.attribute6,
248: l_okl_cntr_lvlng_lns_b_rec.attribute7,
249: l_okl_cntr_lvlng_lns_b_rec.attribute8,
250: l_okl_cntr_lvlng_lns_b_rec.attribute9,
251: l_okl_cntr_lvlng_lns_b_rec.attribute10,
252: l_okl_cntr_lvlng_lns_b_rec.attribute11,
253: l_okl_cntr_lvlng_lns_b_rec.attribute12,
254: l_okl_cntr_lvlng_lns_b_rec.attribute13,
247: l_okl_cntr_lvlng_lns_b_rec.attribute6,
248: l_okl_cntr_lvlng_lns_b_rec.attribute7,
249: l_okl_cntr_lvlng_lns_b_rec.attribute8,
250: l_okl_cntr_lvlng_lns_b_rec.attribute9,
251: l_okl_cntr_lvlng_lns_b_rec.attribute10,
252: l_okl_cntr_lvlng_lns_b_rec.attribute11,
253: l_okl_cntr_lvlng_lns_b_rec.attribute12,
254: l_okl_cntr_lvlng_lns_b_rec.attribute13,
255: l_okl_cntr_lvlng_lns_b_rec.attribute14,
248: l_okl_cntr_lvlng_lns_b_rec.attribute7,
249: l_okl_cntr_lvlng_lns_b_rec.attribute8,
250: l_okl_cntr_lvlng_lns_b_rec.attribute9,
251: l_okl_cntr_lvlng_lns_b_rec.attribute10,
252: l_okl_cntr_lvlng_lns_b_rec.attribute11,
253: l_okl_cntr_lvlng_lns_b_rec.attribute12,
254: l_okl_cntr_lvlng_lns_b_rec.attribute13,
255: l_okl_cntr_lvlng_lns_b_rec.attribute14,
256: l_okl_cntr_lvlng_lns_b_rec.attribute15,
249: l_okl_cntr_lvlng_lns_b_rec.attribute8,
250: l_okl_cntr_lvlng_lns_b_rec.attribute9,
251: l_okl_cntr_lvlng_lns_b_rec.attribute10,
252: l_okl_cntr_lvlng_lns_b_rec.attribute11,
253: l_okl_cntr_lvlng_lns_b_rec.attribute12,
254: l_okl_cntr_lvlng_lns_b_rec.attribute13,
255: l_okl_cntr_lvlng_lns_b_rec.attribute14,
256: l_okl_cntr_lvlng_lns_b_rec.attribute15,
257: l_okl_cntr_lvlng_lns_b_rec.created_by,
250: l_okl_cntr_lvlng_lns_b_rec.attribute9,
251: l_okl_cntr_lvlng_lns_b_rec.attribute10,
252: l_okl_cntr_lvlng_lns_b_rec.attribute11,
253: l_okl_cntr_lvlng_lns_b_rec.attribute12,
254: l_okl_cntr_lvlng_lns_b_rec.attribute13,
255: l_okl_cntr_lvlng_lns_b_rec.attribute14,
256: l_okl_cntr_lvlng_lns_b_rec.attribute15,
257: l_okl_cntr_lvlng_lns_b_rec.created_by,
258: l_okl_cntr_lvlng_lns_b_rec.creation_date,
251: l_okl_cntr_lvlng_lns_b_rec.attribute10,
252: l_okl_cntr_lvlng_lns_b_rec.attribute11,
253: l_okl_cntr_lvlng_lns_b_rec.attribute12,
254: l_okl_cntr_lvlng_lns_b_rec.attribute13,
255: l_okl_cntr_lvlng_lns_b_rec.attribute14,
256: l_okl_cntr_lvlng_lns_b_rec.attribute15,
257: l_okl_cntr_lvlng_lns_b_rec.created_by,
258: l_okl_cntr_lvlng_lns_b_rec.creation_date,
259: l_okl_cntr_lvlng_lns_b_rec.last_updated_by,
252: l_okl_cntr_lvlng_lns_b_rec.attribute11,
253: l_okl_cntr_lvlng_lns_b_rec.attribute12,
254: l_okl_cntr_lvlng_lns_b_rec.attribute13,
255: l_okl_cntr_lvlng_lns_b_rec.attribute14,
256: l_okl_cntr_lvlng_lns_b_rec.attribute15,
257: l_okl_cntr_lvlng_lns_b_rec.created_by,
258: l_okl_cntr_lvlng_lns_b_rec.creation_date,
259: l_okl_cntr_lvlng_lns_b_rec.last_updated_by,
260: l_okl_cntr_lvlng_lns_b_rec.last_update_date,
253: l_okl_cntr_lvlng_lns_b_rec.attribute12,
254: l_okl_cntr_lvlng_lns_b_rec.attribute13,
255: l_okl_cntr_lvlng_lns_b_rec.attribute14,
256: l_okl_cntr_lvlng_lns_b_rec.attribute15,
257: l_okl_cntr_lvlng_lns_b_rec.created_by,
258: l_okl_cntr_lvlng_lns_b_rec.creation_date,
259: l_okl_cntr_lvlng_lns_b_rec.last_updated_by,
260: l_okl_cntr_lvlng_lns_b_rec.last_update_date,
261: l_okl_cntr_lvlng_lns_b_rec.last_update_login;
254: l_okl_cntr_lvlng_lns_b_rec.attribute13,
255: l_okl_cntr_lvlng_lns_b_rec.attribute14,
256: l_okl_cntr_lvlng_lns_b_rec.attribute15,
257: l_okl_cntr_lvlng_lns_b_rec.created_by,
258: l_okl_cntr_lvlng_lns_b_rec.creation_date,
259: l_okl_cntr_lvlng_lns_b_rec.last_updated_by,
260: l_okl_cntr_lvlng_lns_b_rec.last_update_date,
261: l_okl_cntr_lvlng_lns_b_rec.last_update_login;
262: x_no_data_found := okl_cntr_lvlng_lns_b_pk_csr%NOTFOUND;
255: l_okl_cntr_lvlng_lns_b_rec.attribute14,
256: l_okl_cntr_lvlng_lns_b_rec.attribute15,
257: l_okl_cntr_lvlng_lns_b_rec.created_by,
258: l_okl_cntr_lvlng_lns_b_rec.creation_date,
259: l_okl_cntr_lvlng_lns_b_rec.last_updated_by,
260: l_okl_cntr_lvlng_lns_b_rec.last_update_date,
261: l_okl_cntr_lvlng_lns_b_rec.last_update_login;
262: x_no_data_found := okl_cntr_lvlng_lns_b_pk_csr%NOTFOUND;
263: CLOSE okl_cntr_lvlng_lns_b_pk_csr;
256: l_okl_cntr_lvlng_lns_b_rec.attribute15,
257: l_okl_cntr_lvlng_lns_b_rec.created_by,
258: l_okl_cntr_lvlng_lns_b_rec.creation_date,
259: l_okl_cntr_lvlng_lns_b_rec.last_updated_by,
260: l_okl_cntr_lvlng_lns_b_rec.last_update_date,
261: l_okl_cntr_lvlng_lns_b_rec.last_update_login;
262: x_no_data_found := okl_cntr_lvlng_lns_b_pk_csr%NOTFOUND;
263: CLOSE okl_cntr_lvlng_lns_b_pk_csr;
264: RETURN(l_okl_cntr_lvlng_lns_b_rec);
257: l_okl_cntr_lvlng_lns_b_rec.created_by,
258: l_okl_cntr_lvlng_lns_b_rec.creation_date,
259: l_okl_cntr_lvlng_lns_b_rec.last_updated_by,
260: l_okl_cntr_lvlng_lns_b_rec.last_update_date,
261: l_okl_cntr_lvlng_lns_b_rec.last_update_login;
262: x_no_data_found := okl_cntr_lvlng_lns_b_pk_csr%NOTFOUND;
263: CLOSE okl_cntr_lvlng_lns_b_pk_csr;
264: RETURN(l_okl_cntr_lvlng_lns_b_rec);
265: END get_rec;
258: l_okl_cntr_lvlng_lns_b_rec.creation_date,
259: l_okl_cntr_lvlng_lns_b_rec.last_updated_by,
260: l_okl_cntr_lvlng_lns_b_rec.last_update_date,
261: l_okl_cntr_lvlng_lns_b_rec.last_update_login;
262: x_no_data_found := okl_cntr_lvlng_lns_b_pk_csr%NOTFOUND;
263: CLOSE okl_cntr_lvlng_lns_b_pk_csr;
264: RETURN(l_okl_cntr_lvlng_lns_b_rec);
265: END get_rec;
266:
259: l_okl_cntr_lvlng_lns_b_rec.last_updated_by,
260: l_okl_cntr_lvlng_lns_b_rec.last_update_date,
261: l_okl_cntr_lvlng_lns_b_rec.last_update_login;
262: x_no_data_found := okl_cntr_lvlng_lns_b_pk_csr%NOTFOUND;
263: CLOSE okl_cntr_lvlng_lns_b_pk_csr;
264: RETURN(l_okl_cntr_lvlng_lns_b_rec);
265: END get_rec;
266:
267: ------------------------------------------------------------------
260: l_okl_cntr_lvlng_lns_b_rec.last_update_date,
261: l_okl_cntr_lvlng_lns_b_rec.last_update_login;
262: x_no_data_found := okl_cntr_lvlng_lns_b_pk_csr%NOTFOUND;
263: CLOSE okl_cntr_lvlng_lns_b_pk_csr;
264: RETURN(l_okl_cntr_lvlng_lns_b_rec);
265: END get_rec;
266:
267: ------------------------------------------------------------------
268: -- This version of get_rec sets error messages if no data found --
267: ------------------------------------------------------------------
268: -- This version of get_rec sets error messages if no data found --
269: ------------------------------------------------------------------
270: FUNCTION get_rec (
271: p_okl_cntr_lvlng_lns_b_rec IN okl_cntr_lvlng_lns_b_rec_type,
272: x_return_status OUT NOCOPY VARCHAR2
273: ) RETURN okl_cntr_lvlng_lns_b_rec_type IS
274: l_okl_cntr_lvlng_lns_b_rec okl_cntr_lvlng_lns_b_rec_type;
275: l_row_notfound BOOLEAN := TRUE;
269: ------------------------------------------------------------------
270: FUNCTION get_rec (
271: p_okl_cntr_lvlng_lns_b_rec IN okl_cntr_lvlng_lns_b_rec_type,
272: x_return_status OUT NOCOPY VARCHAR2
273: ) RETURN okl_cntr_lvlng_lns_b_rec_type IS
274: l_okl_cntr_lvlng_lns_b_rec okl_cntr_lvlng_lns_b_rec_type;
275: l_row_notfound BOOLEAN := TRUE;
276: BEGIN
277: x_return_status := OKL_API.G_RET_STS_SUCCESS;
270: FUNCTION get_rec (
271: p_okl_cntr_lvlng_lns_b_rec IN okl_cntr_lvlng_lns_b_rec_type,
272: x_return_status OUT NOCOPY VARCHAR2
273: ) RETURN okl_cntr_lvlng_lns_b_rec_type IS
274: l_okl_cntr_lvlng_lns_b_rec okl_cntr_lvlng_lns_b_rec_type;
275: l_row_notfound BOOLEAN := TRUE;
276: BEGIN
277: x_return_status := OKL_API.G_RET_STS_SUCCESS;
278: l_okl_cntr_lvlng_lns_b_rec := get_rec(p_okl_cntr_lvlng_lns_b_rec, l_row_notfound);
274: l_okl_cntr_lvlng_lns_b_rec okl_cntr_lvlng_lns_b_rec_type;
275: l_row_notfound BOOLEAN := TRUE;
276: BEGIN
277: x_return_status := OKL_API.G_RET_STS_SUCCESS;
278: l_okl_cntr_lvlng_lns_b_rec := get_rec(p_okl_cntr_lvlng_lns_b_rec, l_row_notfound);
279: IF (l_row_notfound) THEN
280: OKL_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'ID');
281: x_return_status := OKL_API.G_RET_STS_ERROR;
282: END IF;
279: IF (l_row_notfound) THEN
280: OKL_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'ID');
281: x_return_status := OKL_API.G_RET_STS_ERROR;
282: END IF;
283: RETURN(l_okl_cntr_lvlng_lns_b_rec);
284: END get_rec;
285: -----------------------------------------------------------
286: -- So we don't have to pass an "l_row_notfound" variable --
287: -----------------------------------------------------------
285: -----------------------------------------------------------
286: -- So we don't have to pass an "l_row_notfound" variable --
287: -----------------------------------------------------------
288: FUNCTION get_rec (
289: p_okl_cntr_lvlng_lns_b_rec IN okl_cntr_lvlng_lns_b_rec_type
290: ) RETURN okl_cntr_lvlng_lns_b_rec_type IS
291: l_row_not_found BOOLEAN := TRUE;
292: BEGIN
293: RETURN(get_rec(p_okl_cntr_lvlng_lns_b_rec, l_row_not_found));
286: -- So we don't have to pass an "l_row_notfound" variable --
287: -----------------------------------------------------------
288: FUNCTION get_rec (
289: p_okl_cntr_lvlng_lns_b_rec IN okl_cntr_lvlng_lns_b_rec_type
290: ) RETURN okl_cntr_lvlng_lns_b_rec_type IS
291: l_row_not_found BOOLEAN := TRUE;
292: BEGIN
293: RETURN(get_rec(p_okl_cntr_lvlng_lns_b_rec, l_row_not_found));
294: END get_rec;
289: p_okl_cntr_lvlng_lns_b_rec IN okl_cntr_lvlng_lns_b_rec_type
290: ) RETURN okl_cntr_lvlng_lns_b_rec_type IS
291: l_row_not_found BOOLEAN := TRUE;
292: BEGIN
293: RETURN(get_rec(p_okl_cntr_lvlng_lns_b_rec, l_row_not_found));
294: END get_rec;
295: ---------------------------------------------------------------------------
296: -- FUNCTION null_out_defaults for: OKL_CNTR_LVLNG_LNS_V
297: ---------------------------------------------------------------------------
639: -- PROCEDURE Migrate
640: ---------------------------------------------------------------------------
641: PROCEDURE migrate (
642: p_from IN cllv_rec_type,
643: p_to IN OUT NOCOPY okl_cntr_lvlng_lns_b_rec_type
644: ) IS
645: BEGIN
646: p_to.id := p_from.id;
647: p_to.kle_id := p_from.kle_id;
669: p_to.last_update_date := p_from.last_update_date;
670: p_to.last_update_login := p_from.last_update_login;
671: END migrate;
672: PROCEDURE migrate (
673: p_from IN okl_cntr_lvlng_lns_b_rec_type,
674: p_to IN OUT NOCOPY cllv_rec_type
675: ) IS
676: BEGIN
677: p_to.id := p_from.id;
717: l_api_version CONSTANT NUMBER := 1;
718: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
719: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
720: l_cllv_rec cllv_rec_type := p_cllv_rec;
721: l_okl_cntr_lvlng_lns_b_rec okl_cntr_lvlng_lns_b_rec_type;
722: l_okl_cntr_lvlng_lns_b_rec okl_cntr_lvlng_lns_b_rec_type;
723: BEGIN
724: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
725: G_PKG_NAME,
718: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
719: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
720: l_cllv_rec cllv_rec_type := p_cllv_rec;
721: l_okl_cntr_lvlng_lns_b_rec okl_cntr_lvlng_lns_b_rec_type;
722: l_okl_cntr_lvlng_lns_b_rec okl_cntr_lvlng_lns_b_rec_type;
723: BEGIN
724: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
725: G_PKG_NAME,
726: p_init_msg_list,
941: ---------------------------------------------------------------------------
942: -- PROCEDURE insert_row
943: ---------------------------------------------------------------------------
944: -----------------------------------------
945: -- insert_row for:OKL_CNTR_LVLNG_LNS_B --
946: -----------------------------------------
947: PROCEDURE insert_row(
948: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
949: x_return_status OUT NOCOPY VARCHAR2,
948: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
949: x_return_status OUT NOCOPY VARCHAR2,
950: x_msg_count OUT NOCOPY NUMBER,
951: x_msg_data OUT NOCOPY VARCHAR2,
952: p_okl_cntr_lvlng_lns_b_rec IN okl_cntr_lvlng_lns_b_rec_type,
953: x_okl_cntr_lvlng_lns_b_rec OUT NOCOPY okl_cntr_lvlng_lns_b_rec_type) IS
954:
955: l_api_version CONSTANT NUMBER := 1;
956: l_api_name CONSTANT VARCHAR2(30) := 'B_insert_row';
949: x_return_status OUT NOCOPY VARCHAR2,
950: x_msg_count OUT NOCOPY NUMBER,
951: x_msg_data OUT NOCOPY VARCHAR2,
952: p_okl_cntr_lvlng_lns_b_rec IN okl_cntr_lvlng_lns_b_rec_type,
953: x_okl_cntr_lvlng_lns_b_rec OUT NOCOPY okl_cntr_lvlng_lns_b_rec_type) IS
954:
955: l_api_version CONSTANT NUMBER := 1;
956: l_api_name CONSTANT VARCHAR2(30) := 'B_insert_row';
957: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
954:
955: l_api_version CONSTANT NUMBER := 1;
956: l_api_name CONSTANT VARCHAR2(30) := 'B_insert_row';
957: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
958: l_okl_cntr_lvlng_lns_b_rec okl_cntr_lvlng_lns_b_rec_type := p_okl_cntr_lvlng_lns_b_rec;
959: l_def_okl_cntr_lvlng_lns_b_rec okl_cntr_lvlng_lns_b_rec_type;
960: ---------------------------------------------
961: -- Set_Attributes for:OKL_CNTR_LVLNG_LNS_B --
962: ---------------------------------------------
955: l_api_version CONSTANT NUMBER := 1;
956: l_api_name CONSTANT VARCHAR2(30) := 'B_insert_row';
957: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
958: l_okl_cntr_lvlng_lns_b_rec okl_cntr_lvlng_lns_b_rec_type := p_okl_cntr_lvlng_lns_b_rec;
959: l_def_okl_cntr_lvlng_lns_b_rec okl_cntr_lvlng_lns_b_rec_type;
960: ---------------------------------------------
961: -- Set_Attributes for:OKL_CNTR_LVLNG_LNS_B --
962: ---------------------------------------------
963: FUNCTION Set_Attributes (
957: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
958: l_okl_cntr_lvlng_lns_b_rec okl_cntr_lvlng_lns_b_rec_type := p_okl_cntr_lvlng_lns_b_rec;
959: l_def_okl_cntr_lvlng_lns_b_rec okl_cntr_lvlng_lns_b_rec_type;
960: ---------------------------------------------
961: -- Set_Attributes for:OKL_CNTR_LVLNG_LNS_B --
962: ---------------------------------------------
963: FUNCTION Set_Attributes (
964: p_okl_cntr_lvlng_lns_b_rec IN okl_cntr_lvlng_lns_b_rec_type,
965: x_okl_cntr_lvlng_lns_b_rec OUT NOCOPY okl_cntr_lvlng_lns_b_rec_type
960: ---------------------------------------------
961: -- Set_Attributes for:OKL_CNTR_LVLNG_LNS_B --
962: ---------------------------------------------
963: FUNCTION Set_Attributes (
964: p_okl_cntr_lvlng_lns_b_rec IN okl_cntr_lvlng_lns_b_rec_type,
965: x_okl_cntr_lvlng_lns_b_rec OUT NOCOPY okl_cntr_lvlng_lns_b_rec_type
966: ) RETURN VARCHAR2 IS
967: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
968: BEGIN
961: -- Set_Attributes for:OKL_CNTR_LVLNG_LNS_B --
962: ---------------------------------------------
963: FUNCTION Set_Attributes (
964: p_okl_cntr_lvlng_lns_b_rec IN okl_cntr_lvlng_lns_b_rec_type,
965: x_okl_cntr_lvlng_lns_b_rec OUT NOCOPY okl_cntr_lvlng_lns_b_rec_type
966: ) RETURN VARCHAR2 IS
967: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
968: BEGIN
969: x_okl_cntr_lvlng_lns_b_rec := p_okl_cntr_lvlng_lns_b_rec;
965: x_okl_cntr_lvlng_lns_b_rec OUT NOCOPY okl_cntr_lvlng_lns_b_rec_type
966: ) RETURN VARCHAR2 IS
967: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
968: BEGIN
969: x_okl_cntr_lvlng_lns_b_rec := p_okl_cntr_lvlng_lns_b_rec;
970: RETURN(l_return_status);
971: END Set_Attributes;
972: BEGIN
973: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
980: RAISE OKL_API.G_EXCEPTION_ERROR;
981: END IF;
982: --- Setting item atributes
983: l_return_status := Set_Attributes(
984: p_okl_cntr_lvlng_lns_b_rec, -- IN
985: l_okl_cntr_lvlng_lns_b_rec); -- OUT
986: --- If any errors happen abort API
987: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
988: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
981: END IF;
982: --- Setting item atributes
983: l_return_status := Set_Attributes(
984: p_okl_cntr_lvlng_lns_b_rec, -- IN
985: l_okl_cntr_lvlng_lns_b_rec); -- OUT
986: --- If any errors happen abort API
987: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
988: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
989: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
988: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
989: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
990: RAISE OKL_API.G_EXCEPTION_ERROR;
991: END IF;
992: INSERT INTO OKL_CNTR_LVLNG_LNS_B(
993: id,
994: kle_id,
995: clg_id,
996: object_version_number,
1015: last_updated_by,
1016: last_update_date,
1017: last_update_login)
1018: VALUES (
1019: l_okl_cntr_lvlng_lns_b_rec.id,
1020: l_okl_cntr_lvlng_lns_b_rec.kle_id,
1021: l_okl_cntr_lvlng_lns_b_rec.clg_id,
1022: l_okl_cntr_lvlng_lns_b_rec.object_version_number,
1023: l_okl_cntr_lvlng_lns_b_rec.attribute_category,
1016: last_update_date,
1017: last_update_login)
1018: VALUES (
1019: l_okl_cntr_lvlng_lns_b_rec.id,
1020: l_okl_cntr_lvlng_lns_b_rec.kle_id,
1021: l_okl_cntr_lvlng_lns_b_rec.clg_id,
1022: l_okl_cntr_lvlng_lns_b_rec.object_version_number,
1023: l_okl_cntr_lvlng_lns_b_rec.attribute_category,
1024: l_okl_cntr_lvlng_lns_b_rec.attribute1,
1017: last_update_login)
1018: VALUES (
1019: l_okl_cntr_lvlng_lns_b_rec.id,
1020: l_okl_cntr_lvlng_lns_b_rec.kle_id,
1021: l_okl_cntr_lvlng_lns_b_rec.clg_id,
1022: l_okl_cntr_lvlng_lns_b_rec.object_version_number,
1023: l_okl_cntr_lvlng_lns_b_rec.attribute_category,
1024: l_okl_cntr_lvlng_lns_b_rec.attribute1,
1025: l_okl_cntr_lvlng_lns_b_rec.attribute2,
1018: VALUES (
1019: l_okl_cntr_lvlng_lns_b_rec.id,
1020: l_okl_cntr_lvlng_lns_b_rec.kle_id,
1021: l_okl_cntr_lvlng_lns_b_rec.clg_id,
1022: l_okl_cntr_lvlng_lns_b_rec.object_version_number,
1023: l_okl_cntr_lvlng_lns_b_rec.attribute_category,
1024: l_okl_cntr_lvlng_lns_b_rec.attribute1,
1025: l_okl_cntr_lvlng_lns_b_rec.attribute2,
1026: l_okl_cntr_lvlng_lns_b_rec.attribute3,
1019: l_okl_cntr_lvlng_lns_b_rec.id,
1020: l_okl_cntr_lvlng_lns_b_rec.kle_id,
1021: l_okl_cntr_lvlng_lns_b_rec.clg_id,
1022: l_okl_cntr_lvlng_lns_b_rec.object_version_number,
1023: l_okl_cntr_lvlng_lns_b_rec.attribute_category,
1024: l_okl_cntr_lvlng_lns_b_rec.attribute1,
1025: l_okl_cntr_lvlng_lns_b_rec.attribute2,
1026: l_okl_cntr_lvlng_lns_b_rec.attribute3,
1027: l_okl_cntr_lvlng_lns_b_rec.attribute4,
1020: l_okl_cntr_lvlng_lns_b_rec.kle_id,
1021: l_okl_cntr_lvlng_lns_b_rec.clg_id,
1022: l_okl_cntr_lvlng_lns_b_rec.object_version_number,
1023: l_okl_cntr_lvlng_lns_b_rec.attribute_category,
1024: l_okl_cntr_lvlng_lns_b_rec.attribute1,
1025: l_okl_cntr_lvlng_lns_b_rec.attribute2,
1026: l_okl_cntr_lvlng_lns_b_rec.attribute3,
1027: l_okl_cntr_lvlng_lns_b_rec.attribute4,
1028: l_okl_cntr_lvlng_lns_b_rec.attribute5,
1021: l_okl_cntr_lvlng_lns_b_rec.clg_id,
1022: l_okl_cntr_lvlng_lns_b_rec.object_version_number,
1023: l_okl_cntr_lvlng_lns_b_rec.attribute_category,
1024: l_okl_cntr_lvlng_lns_b_rec.attribute1,
1025: l_okl_cntr_lvlng_lns_b_rec.attribute2,
1026: l_okl_cntr_lvlng_lns_b_rec.attribute3,
1027: l_okl_cntr_lvlng_lns_b_rec.attribute4,
1028: l_okl_cntr_lvlng_lns_b_rec.attribute5,
1029: l_okl_cntr_lvlng_lns_b_rec.attribute6,
1022: l_okl_cntr_lvlng_lns_b_rec.object_version_number,
1023: l_okl_cntr_lvlng_lns_b_rec.attribute_category,
1024: l_okl_cntr_lvlng_lns_b_rec.attribute1,
1025: l_okl_cntr_lvlng_lns_b_rec.attribute2,
1026: l_okl_cntr_lvlng_lns_b_rec.attribute3,
1027: l_okl_cntr_lvlng_lns_b_rec.attribute4,
1028: l_okl_cntr_lvlng_lns_b_rec.attribute5,
1029: l_okl_cntr_lvlng_lns_b_rec.attribute6,
1030: l_okl_cntr_lvlng_lns_b_rec.attribute7,
1023: l_okl_cntr_lvlng_lns_b_rec.attribute_category,
1024: l_okl_cntr_lvlng_lns_b_rec.attribute1,
1025: l_okl_cntr_lvlng_lns_b_rec.attribute2,
1026: l_okl_cntr_lvlng_lns_b_rec.attribute3,
1027: l_okl_cntr_lvlng_lns_b_rec.attribute4,
1028: l_okl_cntr_lvlng_lns_b_rec.attribute5,
1029: l_okl_cntr_lvlng_lns_b_rec.attribute6,
1030: l_okl_cntr_lvlng_lns_b_rec.attribute7,
1031: l_okl_cntr_lvlng_lns_b_rec.attribute8,
1024: l_okl_cntr_lvlng_lns_b_rec.attribute1,
1025: l_okl_cntr_lvlng_lns_b_rec.attribute2,
1026: l_okl_cntr_lvlng_lns_b_rec.attribute3,
1027: l_okl_cntr_lvlng_lns_b_rec.attribute4,
1028: l_okl_cntr_lvlng_lns_b_rec.attribute5,
1029: l_okl_cntr_lvlng_lns_b_rec.attribute6,
1030: l_okl_cntr_lvlng_lns_b_rec.attribute7,
1031: l_okl_cntr_lvlng_lns_b_rec.attribute8,
1032: l_okl_cntr_lvlng_lns_b_rec.attribute9,
1025: l_okl_cntr_lvlng_lns_b_rec.attribute2,
1026: l_okl_cntr_lvlng_lns_b_rec.attribute3,
1027: l_okl_cntr_lvlng_lns_b_rec.attribute4,
1028: l_okl_cntr_lvlng_lns_b_rec.attribute5,
1029: l_okl_cntr_lvlng_lns_b_rec.attribute6,
1030: l_okl_cntr_lvlng_lns_b_rec.attribute7,
1031: l_okl_cntr_lvlng_lns_b_rec.attribute8,
1032: l_okl_cntr_lvlng_lns_b_rec.attribute9,
1033: l_okl_cntr_lvlng_lns_b_rec.attribute10,
1026: l_okl_cntr_lvlng_lns_b_rec.attribute3,
1027: l_okl_cntr_lvlng_lns_b_rec.attribute4,
1028: l_okl_cntr_lvlng_lns_b_rec.attribute5,
1029: l_okl_cntr_lvlng_lns_b_rec.attribute6,
1030: l_okl_cntr_lvlng_lns_b_rec.attribute7,
1031: l_okl_cntr_lvlng_lns_b_rec.attribute8,
1032: l_okl_cntr_lvlng_lns_b_rec.attribute9,
1033: l_okl_cntr_lvlng_lns_b_rec.attribute10,
1034: l_okl_cntr_lvlng_lns_b_rec.attribute11,
1027: l_okl_cntr_lvlng_lns_b_rec.attribute4,
1028: l_okl_cntr_lvlng_lns_b_rec.attribute5,
1029: l_okl_cntr_lvlng_lns_b_rec.attribute6,
1030: l_okl_cntr_lvlng_lns_b_rec.attribute7,
1031: l_okl_cntr_lvlng_lns_b_rec.attribute8,
1032: l_okl_cntr_lvlng_lns_b_rec.attribute9,
1033: l_okl_cntr_lvlng_lns_b_rec.attribute10,
1034: l_okl_cntr_lvlng_lns_b_rec.attribute11,
1035: l_okl_cntr_lvlng_lns_b_rec.attribute12,
1028: l_okl_cntr_lvlng_lns_b_rec.attribute5,
1029: l_okl_cntr_lvlng_lns_b_rec.attribute6,
1030: l_okl_cntr_lvlng_lns_b_rec.attribute7,
1031: l_okl_cntr_lvlng_lns_b_rec.attribute8,
1032: l_okl_cntr_lvlng_lns_b_rec.attribute9,
1033: l_okl_cntr_lvlng_lns_b_rec.attribute10,
1034: l_okl_cntr_lvlng_lns_b_rec.attribute11,
1035: l_okl_cntr_lvlng_lns_b_rec.attribute12,
1036: l_okl_cntr_lvlng_lns_b_rec.attribute13,
1029: l_okl_cntr_lvlng_lns_b_rec.attribute6,
1030: l_okl_cntr_lvlng_lns_b_rec.attribute7,
1031: l_okl_cntr_lvlng_lns_b_rec.attribute8,
1032: l_okl_cntr_lvlng_lns_b_rec.attribute9,
1033: l_okl_cntr_lvlng_lns_b_rec.attribute10,
1034: l_okl_cntr_lvlng_lns_b_rec.attribute11,
1035: l_okl_cntr_lvlng_lns_b_rec.attribute12,
1036: l_okl_cntr_lvlng_lns_b_rec.attribute13,
1037: l_okl_cntr_lvlng_lns_b_rec.attribute14,
1030: l_okl_cntr_lvlng_lns_b_rec.attribute7,
1031: l_okl_cntr_lvlng_lns_b_rec.attribute8,
1032: l_okl_cntr_lvlng_lns_b_rec.attribute9,
1033: l_okl_cntr_lvlng_lns_b_rec.attribute10,
1034: l_okl_cntr_lvlng_lns_b_rec.attribute11,
1035: l_okl_cntr_lvlng_lns_b_rec.attribute12,
1036: l_okl_cntr_lvlng_lns_b_rec.attribute13,
1037: l_okl_cntr_lvlng_lns_b_rec.attribute14,
1038: l_okl_cntr_lvlng_lns_b_rec.attribute15,
1031: l_okl_cntr_lvlng_lns_b_rec.attribute8,
1032: l_okl_cntr_lvlng_lns_b_rec.attribute9,
1033: l_okl_cntr_lvlng_lns_b_rec.attribute10,
1034: l_okl_cntr_lvlng_lns_b_rec.attribute11,
1035: l_okl_cntr_lvlng_lns_b_rec.attribute12,
1036: l_okl_cntr_lvlng_lns_b_rec.attribute13,
1037: l_okl_cntr_lvlng_lns_b_rec.attribute14,
1038: l_okl_cntr_lvlng_lns_b_rec.attribute15,
1039: l_okl_cntr_lvlng_lns_b_rec.created_by,
1032: l_okl_cntr_lvlng_lns_b_rec.attribute9,
1033: l_okl_cntr_lvlng_lns_b_rec.attribute10,
1034: l_okl_cntr_lvlng_lns_b_rec.attribute11,
1035: l_okl_cntr_lvlng_lns_b_rec.attribute12,
1036: l_okl_cntr_lvlng_lns_b_rec.attribute13,
1037: l_okl_cntr_lvlng_lns_b_rec.attribute14,
1038: l_okl_cntr_lvlng_lns_b_rec.attribute15,
1039: l_okl_cntr_lvlng_lns_b_rec.created_by,
1040: l_okl_cntr_lvlng_lns_b_rec.creation_date,
1033: l_okl_cntr_lvlng_lns_b_rec.attribute10,
1034: l_okl_cntr_lvlng_lns_b_rec.attribute11,
1035: l_okl_cntr_lvlng_lns_b_rec.attribute12,
1036: l_okl_cntr_lvlng_lns_b_rec.attribute13,
1037: l_okl_cntr_lvlng_lns_b_rec.attribute14,
1038: l_okl_cntr_lvlng_lns_b_rec.attribute15,
1039: l_okl_cntr_lvlng_lns_b_rec.created_by,
1040: l_okl_cntr_lvlng_lns_b_rec.creation_date,
1041: l_okl_cntr_lvlng_lns_b_rec.last_updated_by,
1034: l_okl_cntr_lvlng_lns_b_rec.attribute11,
1035: l_okl_cntr_lvlng_lns_b_rec.attribute12,
1036: l_okl_cntr_lvlng_lns_b_rec.attribute13,
1037: l_okl_cntr_lvlng_lns_b_rec.attribute14,
1038: l_okl_cntr_lvlng_lns_b_rec.attribute15,
1039: l_okl_cntr_lvlng_lns_b_rec.created_by,
1040: l_okl_cntr_lvlng_lns_b_rec.creation_date,
1041: l_okl_cntr_lvlng_lns_b_rec.last_updated_by,
1042: l_okl_cntr_lvlng_lns_b_rec.last_update_date,
1035: l_okl_cntr_lvlng_lns_b_rec.attribute12,
1036: l_okl_cntr_lvlng_lns_b_rec.attribute13,
1037: l_okl_cntr_lvlng_lns_b_rec.attribute14,
1038: l_okl_cntr_lvlng_lns_b_rec.attribute15,
1039: l_okl_cntr_lvlng_lns_b_rec.created_by,
1040: l_okl_cntr_lvlng_lns_b_rec.creation_date,
1041: l_okl_cntr_lvlng_lns_b_rec.last_updated_by,
1042: l_okl_cntr_lvlng_lns_b_rec.last_update_date,
1043: l_okl_cntr_lvlng_lns_b_rec.last_update_login);
1036: l_okl_cntr_lvlng_lns_b_rec.attribute13,
1037: l_okl_cntr_lvlng_lns_b_rec.attribute14,
1038: l_okl_cntr_lvlng_lns_b_rec.attribute15,
1039: l_okl_cntr_lvlng_lns_b_rec.created_by,
1040: l_okl_cntr_lvlng_lns_b_rec.creation_date,
1041: l_okl_cntr_lvlng_lns_b_rec.last_updated_by,
1042: l_okl_cntr_lvlng_lns_b_rec.last_update_date,
1043: l_okl_cntr_lvlng_lns_b_rec.last_update_login);
1044: -- Set OUT values
1037: l_okl_cntr_lvlng_lns_b_rec.attribute14,
1038: l_okl_cntr_lvlng_lns_b_rec.attribute15,
1039: l_okl_cntr_lvlng_lns_b_rec.created_by,
1040: l_okl_cntr_lvlng_lns_b_rec.creation_date,
1041: l_okl_cntr_lvlng_lns_b_rec.last_updated_by,
1042: l_okl_cntr_lvlng_lns_b_rec.last_update_date,
1043: l_okl_cntr_lvlng_lns_b_rec.last_update_login);
1044: -- Set OUT values
1045: x_okl_cntr_lvlng_lns_b_rec := l_okl_cntr_lvlng_lns_b_rec;
1038: l_okl_cntr_lvlng_lns_b_rec.attribute15,
1039: l_okl_cntr_lvlng_lns_b_rec.created_by,
1040: l_okl_cntr_lvlng_lns_b_rec.creation_date,
1041: l_okl_cntr_lvlng_lns_b_rec.last_updated_by,
1042: l_okl_cntr_lvlng_lns_b_rec.last_update_date,
1043: l_okl_cntr_lvlng_lns_b_rec.last_update_login);
1044: -- Set OUT values
1045: x_okl_cntr_lvlng_lns_b_rec := l_okl_cntr_lvlng_lns_b_rec;
1046: x_return_status := l_return_status;
1039: l_okl_cntr_lvlng_lns_b_rec.created_by,
1040: l_okl_cntr_lvlng_lns_b_rec.creation_date,
1041: l_okl_cntr_lvlng_lns_b_rec.last_updated_by,
1042: l_okl_cntr_lvlng_lns_b_rec.last_update_date,
1043: l_okl_cntr_lvlng_lns_b_rec.last_update_login);
1044: -- Set OUT values
1045: x_okl_cntr_lvlng_lns_b_rec := l_okl_cntr_lvlng_lns_b_rec;
1046: x_return_status := l_return_status;
1047: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1041: l_okl_cntr_lvlng_lns_b_rec.last_updated_by,
1042: l_okl_cntr_lvlng_lns_b_rec.last_update_date,
1043: l_okl_cntr_lvlng_lns_b_rec.last_update_login);
1044: -- Set OUT values
1045: x_okl_cntr_lvlng_lns_b_rec := l_okl_cntr_lvlng_lns_b_rec;
1046: x_return_status := l_return_status;
1047: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1048: EXCEPTION
1049: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1093: l_api_name CONSTANT VARCHAR2(30) := 'V_insert_row';
1094: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1095: l_cllv_rec cllv_rec_type := p_cllv_rec;
1096: l_def_cllv_rec cllv_rec_type;
1097: l_okl_cntr_lvlng_lns_b_rec okl_cntr_lvlng_lns_b_rec_type;
1098: lx_okl_cntr_lvlng_lns_b_rec okl_cntr_lvlng_lns_b_rec_type;
1099: -------------------------------
1100: -- FUNCTION fill_who_columns --
1101: -------------------------------
1094: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1095: l_cllv_rec cllv_rec_type := p_cllv_rec;
1096: l_def_cllv_rec cllv_rec_type;
1097: l_okl_cntr_lvlng_lns_b_rec okl_cntr_lvlng_lns_b_rec_type;
1098: lx_okl_cntr_lvlng_lns_b_rec okl_cntr_lvlng_lns_b_rec_type;
1099: -------------------------------
1100: -- FUNCTION fill_who_columns --
1101: -------------------------------
1102: FUNCTION fill_who_columns (
1167: END IF;
1168: -----------------------------------------
1169: -- Move VIEW record to "Child" records --
1170: -----------------------------------------
1171: migrate(l_def_cllv_rec, l_okl_cntr_lvlng_lns_b_rec);
1172: -----------------------------------------------
1173: -- Call the INSERT_ROW for each child record --
1174: -----------------------------------------------
1175: insert_row(
1176: p_init_msg_list,
1177: l_return_status,
1178: x_msg_count,
1179: x_msg_data,
1180: l_okl_cntr_lvlng_lns_b_rec,
1181: lx_okl_cntr_lvlng_lns_b_rec
1182: );
1183: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1184: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1177: l_return_status,
1178: x_msg_count,
1179: x_msg_data,
1180: l_okl_cntr_lvlng_lns_b_rec,
1181: lx_okl_cntr_lvlng_lns_b_rec
1182: );
1183: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1184: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1185: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1184: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1185: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1186: RAISE OKL_API.G_EXCEPTION_ERROR;
1187: END IF;
1188: migrate(lx_okl_cntr_lvlng_lns_b_rec, l_def_cllv_rec);
1189: -- Set OUT values
1190: x_cllv_rec := l_def_cllv_rec;
1191: x_return_status := l_return_status;
1192: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1387: ---------------------------------------------------------------------------
1388: -- PROCEDURE lock_row
1389: ---------------------------------------------------------------------------
1390: ---------------------------------------
1391: -- lock_row for:OKL_CNTR_LVLNG_LNS_B --
1392: ---------------------------------------
1393: PROCEDURE lock_row(
1394: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1395: x_return_status OUT NOCOPY VARCHAR2,
1394: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1395: x_return_status OUT NOCOPY VARCHAR2,
1396: x_msg_count OUT NOCOPY NUMBER,
1397: x_msg_data OUT NOCOPY VARCHAR2,
1398: p_okl_cntr_lvlng_lns_b_rec IN okl_cntr_lvlng_lns_b_rec_type) IS
1399:
1400: E_Resource_Busy EXCEPTION;
1401: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1402: CURSOR lock_csr (p_okl_cntr_lvlng_lns_b_rec IN okl_cntr_lvlng_lns_b_rec_type) IS
1398: p_okl_cntr_lvlng_lns_b_rec IN okl_cntr_lvlng_lns_b_rec_type) IS
1399:
1400: E_Resource_Busy EXCEPTION;
1401: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1402: CURSOR lock_csr (p_okl_cntr_lvlng_lns_b_rec IN okl_cntr_lvlng_lns_b_rec_type) IS
1403: SELECT OBJECT_VERSION_NUMBER
1404: FROM OKL_CNTR_LVLNG_LNS_B
1405: WHERE ID = p_okl_cntr_lvlng_lns_b_rec.id
1406: AND OBJECT_VERSION_NUMBER = p_okl_cntr_lvlng_lns_b_rec.object_version_number
1400: E_Resource_Busy EXCEPTION;
1401: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1402: CURSOR lock_csr (p_okl_cntr_lvlng_lns_b_rec IN okl_cntr_lvlng_lns_b_rec_type) IS
1403: SELECT OBJECT_VERSION_NUMBER
1404: FROM OKL_CNTR_LVLNG_LNS_B
1405: WHERE ID = p_okl_cntr_lvlng_lns_b_rec.id
1406: AND OBJECT_VERSION_NUMBER = p_okl_cntr_lvlng_lns_b_rec.object_version_number
1407: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1408:
1401: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1402: CURSOR lock_csr (p_okl_cntr_lvlng_lns_b_rec IN okl_cntr_lvlng_lns_b_rec_type) IS
1403: SELECT OBJECT_VERSION_NUMBER
1404: FROM OKL_CNTR_LVLNG_LNS_B
1405: WHERE ID = p_okl_cntr_lvlng_lns_b_rec.id
1406: AND OBJECT_VERSION_NUMBER = p_okl_cntr_lvlng_lns_b_rec.object_version_number
1407: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1408:
1409: CURSOR lchk_csr (p_okl_cntr_lvlng_lns_b_rec IN okl_cntr_lvlng_lns_b_rec_type) IS
1402: CURSOR lock_csr (p_okl_cntr_lvlng_lns_b_rec IN okl_cntr_lvlng_lns_b_rec_type) IS
1403: SELECT OBJECT_VERSION_NUMBER
1404: FROM OKL_CNTR_LVLNG_LNS_B
1405: WHERE ID = p_okl_cntr_lvlng_lns_b_rec.id
1406: AND OBJECT_VERSION_NUMBER = p_okl_cntr_lvlng_lns_b_rec.object_version_number
1407: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1408:
1409: CURSOR lchk_csr (p_okl_cntr_lvlng_lns_b_rec IN okl_cntr_lvlng_lns_b_rec_type) IS
1410: SELECT OBJECT_VERSION_NUMBER
1405: WHERE ID = p_okl_cntr_lvlng_lns_b_rec.id
1406: AND OBJECT_VERSION_NUMBER = p_okl_cntr_lvlng_lns_b_rec.object_version_number
1407: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1408:
1409: CURSOR lchk_csr (p_okl_cntr_lvlng_lns_b_rec IN okl_cntr_lvlng_lns_b_rec_type) IS
1410: SELECT OBJECT_VERSION_NUMBER
1411: FROM OKL_CNTR_LVLNG_LNS_B
1412: WHERE ID = p_okl_cntr_lvlng_lns_b_rec.id;
1413: l_api_version CONSTANT NUMBER := 1;
1407: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1408:
1409: CURSOR lchk_csr (p_okl_cntr_lvlng_lns_b_rec IN okl_cntr_lvlng_lns_b_rec_type) IS
1410: SELECT OBJECT_VERSION_NUMBER
1411: FROM OKL_CNTR_LVLNG_LNS_B
1412: WHERE ID = p_okl_cntr_lvlng_lns_b_rec.id;
1413: l_api_version CONSTANT NUMBER := 1;
1414: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1415: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1408:
1409: CURSOR lchk_csr (p_okl_cntr_lvlng_lns_b_rec IN okl_cntr_lvlng_lns_b_rec_type) IS
1410: SELECT OBJECT_VERSION_NUMBER
1411: FROM OKL_CNTR_LVLNG_LNS_B
1412: WHERE ID = p_okl_cntr_lvlng_lns_b_rec.id;
1413: l_api_version CONSTANT NUMBER := 1;
1414: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1415: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1416: l_object_version_number OKL_CNTR_LVLNG_LNS_B.OBJECT_VERSION_NUMBER%TYPE;
1412: WHERE ID = p_okl_cntr_lvlng_lns_b_rec.id;
1413: l_api_version CONSTANT NUMBER := 1;
1414: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1415: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1416: l_object_version_number OKL_CNTR_LVLNG_LNS_B.OBJECT_VERSION_NUMBER%TYPE;
1417: lc_object_version_number OKL_CNTR_LVLNG_LNS_B.OBJECT_VERSION_NUMBER%TYPE;
1418: l_row_notfound BOOLEAN := FALSE;
1419: lc_row_notfound BOOLEAN := FALSE;
1420: BEGIN
1413: l_api_version CONSTANT NUMBER := 1;
1414: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1415: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1416: l_object_version_number OKL_CNTR_LVLNG_LNS_B.OBJECT_VERSION_NUMBER%TYPE;
1417: lc_object_version_number OKL_CNTR_LVLNG_LNS_B.OBJECT_VERSION_NUMBER%TYPE;
1418: l_row_notfound BOOLEAN := FALSE;
1419: lc_row_notfound BOOLEAN := FALSE;
1420: BEGIN
1421: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
1427: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1428: RAISE OKL_API.G_EXCEPTION_ERROR;
1429: END IF;
1430: BEGIN
1431: OPEN lock_csr(p_okl_cntr_lvlng_lns_b_rec);
1432: FETCH lock_csr INTO l_object_version_number;
1433: l_row_notfound := lock_csr%NOTFOUND;
1434: CLOSE lock_csr;
1435: EXCEPTION
1441: RAISE APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION;
1442: END;
1443:
1444: IF ( l_row_notfound ) THEN
1445: OPEN lchk_csr(p_okl_cntr_lvlng_lns_b_rec);
1446: FETCH lchk_csr INTO lc_object_version_number;
1447: lc_row_notfound := lchk_csr%NOTFOUND;
1448: CLOSE lchk_csr;
1449: END IF;
1449: END IF;
1450: IF (lc_row_notfound) THEN
1451: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1452: RAISE OKL_API.G_EXCEPTION_ERROR;
1453: ELSIF lc_object_version_number > p_okl_cntr_lvlng_lns_b_rec.object_version_number THEN
1454: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1455: RAISE OKL_API.G_EXCEPTION_ERROR;
1456: ELSIF lc_object_version_number <> p_okl_cntr_lvlng_lns_b_rec.object_version_number THEN
1457: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1452: RAISE OKL_API.G_EXCEPTION_ERROR;
1453: ELSIF lc_object_version_number > p_okl_cntr_lvlng_lns_b_rec.object_version_number THEN
1454: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1455: RAISE OKL_API.G_EXCEPTION_ERROR;
1456: ELSIF lc_object_version_number <> p_okl_cntr_lvlng_lns_b_rec.object_version_number THEN
1457: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1458: RAISE OKL_API.G_EXCEPTION_ERROR;
1459: ELSIF lc_object_version_number = -1 THEN
1460: OKL_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1507:
1508: l_api_version CONSTANT NUMBER := 1;
1509: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
1510: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1511: l_okl_cntr_lvlng_lns_b_rec okl_cntr_lvlng_lns_b_rec_type;
1512: BEGIN
1513: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
1514: G_PKG_NAME,
1515: p_init_msg_list,
1524: END IF;
1525: -----------------------------------------
1526: -- Move VIEW record to "Child" records --
1527: -----------------------------------------
1528: migrate(p_cllv_rec, l_okl_cntr_lvlng_lns_b_rec);
1529: ---------------------------------------------
1530: -- Call the LOCK_ROW for each child record --
1531: ---------------------------------------------
1532: lock_row(
1533: p_init_msg_list,
1534: l_return_status,
1535: x_msg_count,
1536: x_msg_data,
1537: l_okl_cntr_lvlng_lns_b_rec
1538: );
1539: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1540: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1541: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1734: ---------------------------------------------------------------------------
1735: -- PROCEDURE update_row
1736: ---------------------------------------------------------------------------
1737: -----------------------------------------
1738: -- update_row for:OKL_CNTR_LVLNG_LNS_B --
1739: -----------------------------------------
1740: PROCEDURE update_row(
1741: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1742: x_return_status OUT NOCOPY VARCHAR2,
1741: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1742: x_return_status OUT NOCOPY VARCHAR2,
1743: x_msg_count OUT NOCOPY NUMBER,
1744: x_msg_data OUT NOCOPY VARCHAR2,
1745: p_okl_cntr_lvlng_lns_b_rec IN okl_cntr_lvlng_lns_b_rec_type,
1746: x_okl_cntr_lvlng_lns_b_rec OUT NOCOPY okl_cntr_lvlng_lns_b_rec_type) IS
1747:
1748: l_api_version CONSTANT NUMBER := 1;
1749: l_api_name CONSTANT VARCHAR2(30) := 'B_update_row';
1742: x_return_status OUT NOCOPY VARCHAR2,
1743: x_msg_count OUT NOCOPY NUMBER,
1744: x_msg_data OUT NOCOPY VARCHAR2,
1745: p_okl_cntr_lvlng_lns_b_rec IN okl_cntr_lvlng_lns_b_rec_type,
1746: x_okl_cntr_lvlng_lns_b_rec OUT NOCOPY okl_cntr_lvlng_lns_b_rec_type) IS
1747:
1748: l_api_version CONSTANT NUMBER := 1;
1749: l_api_name CONSTANT VARCHAR2(30) := 'B_update_row';
1750: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1747:
1748: l_api_version CONSTANT NUMBER := 1;
1749: l_api_name CONSTANT VARCHAR2(30) := 'B_update_row';
1750: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1751: l_okl_cntr_lvlng_lns_b_rec okl_cntr_lvlng_lns_b_rec_type := p_okl_cntr_lvlng_lns_b_rec;
1752: l_def_okl_cntr_lvlng_lns_b_rec okl_cntr_lvlng_lns_b_rec_type;
1753: l_row_notfound BOOLEAN := TRUE;
1754: ----------------------------------
1755: -- FUNCTION populate_new_record --
1748: l_api_version CONSTANT NUMBER := 1;
1749: l_api_name CONSTANT VARCHAR2(30) := 'B_update_row';
1750: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1751: l_okl_cntr_lvlng_lns_b_rec okl_cntr_lvlng_lns_b_rec_type := p_okl_cntr_lvlng_lns_b_rec;
1752: l_def_okl_cntr_lvlng_lns_b_rec okl_cntr_lvlng_lns_b_rec_type;
1753: l_row_notfound BOOLEAN := TRUE;
1754: ----------------------------------
1755: -- FUNCTION populate_new_record --
1756: ----------------------------------
1754: ----------------------------------
1755: -- FUNCTION populate_new_record --
1756: ----------------------------------
1757: FUNCTION populate_new_record (
1758: p_okl_cntr_lvlng_lns_b_rec IN okl_cntr_lvlng_lns_b_rec_type,
1759: x_okl_cntr_lvlng_lns_b_rec OUT NOCOPY okl_cntr_lvlng_lns_b_rec_type
1760: ) RETURN VARCHAR2 IS
1761: l_okl_cntr_lvlng_lns_b_rec okl_cntr_lvlng_lns_b_rec_type;
1762: l_row_notfound BOOLEAN := TRUE;
1755: -- FUNCTION populate_new_record --
1756: ----------------------------------
1757: FUNCTION populate_new_record (
1758: p_okl_cntr_lvlng_lns_b_rec IN okl_cntr_lvlng_lns_b_rec_type,
1759: x_okl_cntr_lvlng_lns_b_rec OUT NOCOPY okl_cntr_lvlng_lns_b_rec_type
1760: ) RETURN VARCHAR2 IS
1761: l_okl_cntr_lvlng_lns_b_rec okl_cntr_lvlng_lns_b_rec_type;
1762: l_row_notfound BOOLEAN := TRUE;
1763: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1757: FUNCTION populate_new_record (
1758: p_okl_cntr_lvlng_lns_b_rec IN okl_cntr_lvlng_lns_b_rec_type,
1759: x_okl_cntr_lvlng_lns_b_rec OUT NOCOPY okl_cntr_lvlng_lns_b_rec_type
1760: ) RETURN VARCHAR2 IS
1761: l_okl_cntr_lvlng_lns_b_rec okl_cntr_lvlng_lns_b_rec_type;
1762: l_row_notfound BOOLEAN := TRUE;
1763: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1764: BEGIN
1765: x_okl_cntr_lvlng_lns_b_rec := p_okl_cntr_lvlng_lns_b_rec;
1761: l_okl_cntr_lvlng_lns_b_rec okl_cntr_lvlng_lns_b_rec_type;
1762: l_row_notfound BOOLEAN := TRUE;
1763: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1764: BEGIN
1765: x_okl_cntr_lvlng_lns_b_rec := p_okl_cntr_lvlng_lns_b_rec;
1766: -- Get current database values
1767: l_okl_cntr_lvlng_lns_b_rec := get_rec(p_okl_cntr_lvlng_lns_b_rec, l_return_status);
1768: IF (l_return_status = OKL_API.G_RET_STS_SUCCESS) THEN
1769: IF (x_okl_cntr_lvlng_lns_b_rec.id = OKL_API.G_MISS_NUM)
1763: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1764: BEGIN
1765: x_okl_cntr_lvlng_lns_b_rec := p_okl_cntr_lvlng_lns_b_rec;
1766: -- Get current database values
1767: l_okl_cntr_lvlng_lns_b_rec := get_rec(p_okl_cntr_lvlng_lns_b_rec, l_return_status);
1768: IF (l_return_status = OKL_API.G_RET_STS_SUCCESS) THEN
1769: IF (x_okl_cntr_lvlng_lns_b_rec.id = OKL_API.G_MISS_NUM)
1770: THEN
1771: x_okl_cntr_lvlng_lns_b_rec.id := l_okl_cntr_lvlng_lns_b_rec.id;
1765: x_okl_cntr_lvlng_lns_b_rec := p_okl_cntr_lvlng_lns_b_rec;
1766: -- Get current database values
1767: l_okl_cntr_lvlng_lns_b_rec := get_rec(p_okl_cntr_lvlng_lns_b_rec, l_return_status);
1768: IF (l_return_status = OKL_API.G_RET_STS_SUCCESS) THEN
1769: IF (x_okl_cntr_lvlng_lns_b_rec.id = OKL_API.G_MISS_NUM)
1770: THEN
1771: x_okl_cntr_lvlng_lns_b_rec.id := l_okl_cntr_lvlng_lns_b_rec.id;
1772: END IF;
1773: IF (x_okl_cntr_lvlng_lns_b_rec.kle_id = OKL_API.G_MISS_NUM)
1767: l_okl_cntr_lvlng_lns_b_rec := get_rec(p_okl_cntr_lvlng_lns_b_rec, l_return_status);
1768: IF (l_return_status = OKL_API.G_RET_STS_SUCCESS) THEN
1769: IF (x_okl_cntr_lvlng_lns_b_rec.id = OKL_API.G_MISS_NUM)
1770: THEN
1771: x_okl_cntr_lvlng_lns_b_rec.id := l_okl_cntr_lvlng_lns_b_rec.id;
1772: END IF;
1773: IF (x_okl_cntr_lvlng_lns_b_rec.kle_id = OKL_API.G_MISS_NUM)
1774: THEN
1775: x_okl_cntr_lvlng_lns_b_rec.kle_id := l_okl_cntr_lvlng_lns_b_rec.kle_id;
1769: IF (x_okl_cntr_lvlng_lns_b_rec.id = OKL_API.G_MISS_NUM)
1770: THEN
1771: x_okl_cntr_lvlng_lns_b_rec.id := l_okl_cntr_lvlng_lns_b_rec.id;
1772: END IF;
1773: IF (x_okl_cntr_lvlng_lns_b_rec.kle_id = OKL_API.G_MISS_NUM)
1774: THEN
1775: x_okl_cntr_lvlng_lns_b_rec.kle_id := l_okl_cntr_lvlng_lns_b_rec.kle_id;
1776: END IF;
1777: IF (x_okl_cntr_lvlng_lns_b_rec.clg_id = OKL_API.G_MISS_NUM)
1771: x_okl_cntr_lvlng_lns_b_rec.id := l_okl_cntr_lvlng_lns_b_rec.id;
1772: END IF;
1773: IF (x_okl_cntr_lvlng_lns_b_rec.kle_id = OKL_API.G_MISS_NUM)
1774: THEN
1775: x_okl_cntr_lvlng_lns_b_rec.kle_id := l_okl_cntr_lvlng_lns_b_rec.kle_id;
1776: END IF;
1777: IF (x_okl_cntr_lvlng_lns_b_rec.clg_id = OKL_API.G_MISS_NUM)
1778: THEN
1779: x_okl_cntr_lvlng_lns_b_rec.clg_id := l_okl_cntr_lvlng_lns_b_rec.clg_id;
1773: IF (x_okl_cntr_lvlng_lns_b_rec.kle_id = OKL_API.G_MISS_NUM)
1774: THEN
1775: x_okl_cntr_lvlng_lns_b_rec.kle_id := l_okl_cntr_lvlng_lns_b_rec.kle_id;
1776: END IF;
1777: IF (x_okl_cntr_lvlng_lns_b_rec.clg_id = OKL_API.G_MISS_NUM)
1778: THEN
1779: x_okl_cntr_lvlng_lns_b_rec.clg_id := l_okl_cntr_lvlng_lns_b_rec.clg_id;
1780: END IF;
1781: IF (x_okl_cntr_lvlng_lns_b_rec.object_version_number = OKL_API.G_MISS_NUM)
1775: x_okl_cntr_lvlng_lns_b_rec.kle_id := l_okl_cntr_lvlng_lns_b_rec.kle_id;
1776: END IF;
1777: IF (x_okl_cntr_lvlng_lns_b_rec.clg_id = OKL_API.G_MISS_NUM)
1778: THEN
1779: x_okl_cntr_lvlng_lns_b_rec.clg_id := l_okl_cntr_lvlng_lns_b_rec.clg_id;
1780: END IF;
1781: IF (x_okl_cntr_lvlng_lns_b_rec.object_version_number = OKL_API.G_MISS_NUM)
1782: THEN
1783: x_okl_cntr_lvlng_lns_b_rec.object_version_number := l_okl_cntr_lvlng_lns_b_rec.object_version_number;
1777: IF (x_okl_cntr_lvlng_lns_b_rec.clg_id = OKL_API.G_MISS_NUM)
1778: THEN
1779: x_okl_cntr_lvlng_lns_b_rec.clg_id := l_okl_cntr_lvlng_lns_b_rec.clg_id;
1780: END IF;
1781: IF (x_okl_cntr_lvlng_lns_b_rec.object_version_number = OKL_API.G_MISS_NUM)
1782: THEN
1783: x_okl_cntr_lvlng_lns_b_rec.object_version_number := l_okl_cntr_lvlng_lns_b_rec.object_version_number;
1784: END IF;
1785: IF (x_okl_cntr_lvlng_lns_b_rec.attribute_category = OKL_API.G_MISS_CHAR)
1779: x_okl_cntr_lvlng_lns_b_rec.clg_id := l_okl_cntr_lvlng_lns_b_rec.clg_id;
1780: END IF;
1781: IF (x_okl_cntr_lvlng_lns_b_rec.object_version_number = OKL_API.G_MISS_NUM)
1782: THEN
1783: x_okl_cntr_lvlng_lns_b_rec.object_version_number := l_okl_cntr_lvlng_lns_b_rec.object_version_number;
1784: END IF;
1785: IF (x_okl_cntr_lvlng_lns_b_rec.attribute_category = OKL_API.G_MISS_CHAR)
1786: THEN
1787: x_okl_cntr_lvlng_lns_b_rec.attribute_category := l_okl_cntr_lvlng_lns_b_rec.attribute_category;
1781: IF (x_okl_cntr_lvlng_lns_b_rec.object_version_number = OKL_API.G_MISS_NUM)
1782: THEN
1783: x_okl_cntr_lvlng_lns_b_rec.object_version_number := l_okl_cntr_lvlng_lns_b_rec.object_version_number;
1784: END IF;
1785: IF (x_okl_cntr_lvlng_lns_b_rec.attribute_category = OKL_API.G_MISS_CHAR)
1786: THEN
1787: x_okl_cntr_lvlng_lns_b_rec.attribute_category := l_okl_cntr_lvlng_lns_b_rec.attribute_category;
1788: END IF;
1789: IF (x_okl_cntr_lvlng_lns_b_rec.attribute1 = OKL_API.G_MISS_CHAR)
1783: x_okl_cntr_lvlng_lns_b_rec.object_version_number := l_okl_cntr_lvlng_lns_b_rec.object_version_number;
1784: END IF;
1785: IF (x_okl_cntr_lvlng_lns_b_rec.attribute_category = OKL_API.G_MISS_CHAR)
1786: THEN
1787: x_okl_cntr_lvlng_lns_b_rec.attribute_category := l_okl_cntr_lvlng_lns_b_rec.attribute_category;
1788: END IF;
1789: IF (x_okl_cntr_lvlng_lns_b_rec.attribute1 = OKL_API.G_MISS_CHAR)
1790: THEN
1791: x_okl_cntr_lvlng_lns_b_rec.attribute1 := l_okl_cntr_lvlng_lns_b_rec.attribute1;
1785: IF (x_okl_cntr_lvlng_lns_b_rec.attribute_category = OKL_API.G_MISS_CHAR)
1786: THEN
1787: x_okl_cntr_lvlng_lns_b_rec.attribute_category := l_okl_cntr_lvlng_lns_b_rec.attribute_category;
1788: END IF;
1789: IF (x_okl_cntr_lvlng_lns_b_rec.attribute1 = OKL_API.G_MISS_CHAR)
1790: THEN
1791: x_okl_cntr_lvlng_lns_b_rec.attribute1 := l_okl_cntr_lvlng_lns_b_rec.attribute1;
1792: END IF;
1793: IF (x_okl_cntr_lvlng_lns_b_rec.attribute2 = OKL_API.G_MISS_CHAR)
1787: x_okl_cntr_lvlng_lns_b_rec.attribute_category := l_okl_cntr_lvlng_lns_b_rec.attribute_category;
1788: END IF;
1789: IF (x_okl_cntr_lvlng_lns_b_rec.attribute1 = OKL_API.G_MISS_CHAR)
1790: THEN
1791: x_okl_cntr_lvlng_lns_b_rec.attribute1 := l_okl_cntr_lvlng_lns_b_rec.attribute1;
1792: END IF;
1793: IF (x_okl_cntr_lvlng_lns_b_rec.attribute2 = OKL_API.G_MISS_CHAR)
1794: THEN
1795: x_okl_cntr_lvlng_lns_b_rec.attribute2 := l_okl_cntr_lvlng_lns_b_rec.attribute2;
1789: IF (x_okl_cntr_lvlng_lns_b_rec.attribute1 = OKL_API.G_MISS_CHAR)
1790: THEN
1791: x_okl_cntr_lvlng_lns_b_rec.attribute1 := l_okl_cntr_lvlng_lns_b_rec.attribute1;
1792: END IF;
1793: IF (x_okl_cntr_lvlng_lns_b_rec.attribute2 = OKL_API.G_MISS_CHAR)
1794: THEN
1795: x_okl_cntr_lvlng_lns_b_rec.attribute2 := l_okl_cntr_lvlng_lns_b_rec.attribute2;
1796: END IF;
1797: IF (x_okl_cntr_lvlng_lns_b_rec.attribute3 = OKL_API.G_MISS_CHAR)
1791: x_okl_cntr_lvlng_lns_b_rec.attribute1 := l_okl_cntr_lvlng_lns_b_rec.attribute1;
1792: END IF;
1793: IF (x_okl_cntr_lvlng_lns_b_rec.attribute2 = OKL_API.G_MISS_CHAR)
1794: THEN
1795: x_okl_cntr_lvlng_lns_b_rec.attribute2 := l_okl_cntr_lvlng_lns_b_rec.attribute2;
1796: END IF;
1797: IF (x_okl_cntr_lvlng_lns_b_rec.attribute3 = OKL_API.G_MISS_CHAR)
1798: THEN
1799: x_okl_cntr_lvlng_lns_b_rec.attribute3 := l_okl_cntr_lvlng_lns_b_rec.attribute3;
1793: IF (x_okl_cntr_lvlng_lns_b_rec.attribute2 = OKL_API.G_MISS_CHAR)
1794: THEN
1795: x_okl_cntr_lvlng_lns_b_rec.attribute2 := l_okl_cntr_lvlng_lns_b_rec.attribute2;
1796: END IF;
1797: IF (x_okl_cntr_lvlng_lns_b_rec.attribute3 = OKL_API.G_MISS_CHAR)
1798: THEN
1799: x_okl_cntr_lvlng_lns_b_rec.attribute3 := l_okl_cntr_lvlng_lns_b_rec.attribute3;
1800: END IF;
1801: IF (x_okl_cntr_lvlng_lns_b_rec.attribute4 = OKL_API.G_MISS_CHAR)
1795: x_okl_cntr_lvlng_lns_b_rec.attribute2 := l_okl_cntr_lvlng_lns_b_rec.attribute2;
1796: END IF;
1797: IF (x_okl_cntr_lvlng_lns_b_rec.attribute3 = OKL_API.G_MISS_CHAR)
1798: THEN
1799: x_okl_cntr_lvlng_lns_b_rec.attribute3 := l_okl_cntr_lvlng_lns_b_rec.attribute3;
1800: END IF;
1801: IF (x_okl_cntr_lvlng_lns_b_rec.attribute4 = OKL_API.G_MISS_CHAR)
1802: THEN
1803: x_okl_cntr_lvlng_lns_b_rec.attribute4 := l_okl_cntr_lvlng_lns_b_rec.attribute4;
1797: IF (x_okl_cntr_lvlng_lns_b_rec.attribute3 = OKL_API.G_MISS_CHAR)
1798: THEN
1799: x_okl_cntr_lvlng_lns_b_rec.attribute3 := l_okl_cntr_lvlng_lns_b_rec.attribute3;
1800: END IF;
1801: IF (x_okl_cntr_lvlng_lns_b_rec.attribute4 = OKL_API.G_MISS_CHAR)
1802: THEN
1803: x_okl_cntr_lvlng_lns_b_rec.attribute4 := l_okl_cntr_lvlng_lns_b_rec.attribute4;
1804: END IF;
1805: IF (x_okl_cntr_lvlng_lns_b_rec.attribute5 = OKL_API.G_MISS_CHAR)
1799: x_okl_cntr_lvlng_lns_b_rec.attribute3 := l_okl_cntr_lvlng_lns_b_rec.attribute3;
1800: END IF;
1801: IF (x_okl_cntr_lvlng_lns_b_rec.attribute4 = OKL_API.G_MISS_CHAR)
1802: THEN
1803: x_okl_cntr_lvlng_lns_b_rec.attribute4 := l_okl_cntr_lvlng_lns_b_rec.attribute4;
1804: END IF;
1805: IF (x_okl_cntr_lvlng_lns_b_rec.attribute5 = OKL_API.G_MISS_CHAR)
1806: THEN
1807: x_okl_cntr_lvlng_lns_b_rec.attribute5 := l_okl_cntr_lvlng_lns_b_rec.attribute5;
1801: IF (x_okl_cntr_lvlng_lns_b_rec.attribute4 = OKL_API.G_MISS_CHAR)
1802: THEN
1803: x_okl_cntr_lvlng_lns_b_rec.attribute4 := l_okl_cntr_lvlng_lns_b_rec.attribute4;
1804: END IF;
1805: IF (x_okl_cntr_lvlng_lns_b_rec.attribute5 = OKL_API.G_MISS_CHAR)
1806: THEN
1807: x_okl_cntr_lvlng_lns_b_rec.attribute5 := l_okl_cntr_lvlng_lns_b_rec.attribute5;
1808: END IF;
1809: IF (x_okl_cntr_lvlng_lns_b_rec.attribute6 = OKL_API.G_MISS_CHAR)
1803: x_okl_cntr_lvlng_lns_b_rec.attribute4 := l_okl_cntr_lvlng_lns_b_rec.attribute4;
1804: END IF;
1805: IF (x_okl_cntr_lvlng_lns_b_rec.attribute5 = OKL_API.G_MISS_CHAR)
1806: THEN
1807: x_okl_cntr_lvlng_lns_b_rec.attribute5 := l_okl_cntr_lvlng_lns_b_rec.attribute5;
1808: END IF;
1809: IF (x_okl_cntr_lvlng_lns_b_rec.attribute6 = OKL_API.G_MISS_CHAR)
1810: THEN
1811: x_okl_cntr_lvlng_lns_b_rec.attribute6 := l_okl_cntr_lvlng_lns_b_rec.attribute6;
1805: IF (x_okl_cntr_lvlng_lns_b_rec.attribute5 = OKL_API.G_MISS_CHAR)
1806: THEN
1807: x_okl_cntr_lvlng_lns_b_rec.attribute5 := l_okl_cntr_lvlng_lns_b_rec.attribute5;
1808: END IF;
1809: IF (x_okl_cntr_lvlng_lns_b_rec.attribute6 = OKL_API.G_MISS_CHAR)
1810: THEN
1811: x_okl_cntr_lvlng_lns_b_rec.attribute6 := l_okl_cntr_lvlng_lns_b_rec.attribute6;
1812: END IF;
1813: IF (x_okl_cntr_lvlng_lns_b_rec.attribute7 = OKL_API.G_MISS_CHAR)
1807: x_okl_cntr_lvlng_lns_b_rec.attribute5 := l_okl_cntr_lvlng_lns_b_rec.attribute5;
1808: END IF;
1809: IF (x_okl_cntr_lvlng_lns_b_rec.attribute6 = OKL_API.G_MISS_CHAR)
1810: THEN
1811: x_okl_cntr_lvlng_lns_b_rec.attribute6 := l_okl_cntr_lvlng_lns_b_rec.attribute6;
1812: END IF;
1813: IF (x_okl_cntr_lvlng_lns_b_rec.attribute7 = OKL_API.G_MISS_CHAR)
1814: THEN
1815: x_okl_cntr_lvlng_lns_b_rec.attribute7 := l_okl_cntr_lvlng_lns_b_rec.attribute7;
1809: IF (x_okl_cntr_lvlng_lns_b_rec.attribute6 = OKL_API.G_MISS_CHAR)
1810: THEN
1811: x_okl_cntr_lvlng_lns_b_rec.attribute6 := l_okl_cntr_lvlng_lns_b_rec.attribute6;
1812: END IF;
1813: IF (x_okl_cntr_lvlng_lns_b_rec.attribute7 = OKL_API.G_MISS_CHAR)
1814: THEN
1815: x_okl_cntr_lvlng_lns_b_rec.attribute7 := l_okl_cntr_lvlng_lns_b_rec.attribute7;
1816: END IF;
1817: IF (x_okl_cntr_lvlng_lns_b_rec.attribute8 = OKL_API.G_MISS_CHAR)
1811: x_okl_cntr_lvlng_lns_b_rec.attribute6 := l_okl_cntr_lvlng_lns_b_rec.attribute6;
1812: END IF;
1813: IF (x_okl_cntr_lvlng_lns_b_rec.attribute7 = OKL_API.G_MISS_CHAR)
1814: THEN
1815: x_okl_cntr_lvlng_lns_b_rec.attribute7 := l_okl_cntr_lvlng_lns_b_rec.attribute7;
1816: END IF;
1817: IF (x_okl_cntr_lvlng_lns_b_rec.attribute8 = OKL_API.G_MISS_CHAR)
1818: THEN
1819: x_okl_cntr_lvlng_lns_b_rec.attribute8 := l_okl_cntr_lvlng_lns_b_rec.attribute8;
1813: IF (x_okl_cntr_lvlng_lns_b_rec.attribute7 = OKL_API.G_MISS_CHAR)
1814: THEN
1815: x_okl_cntr_lvlng_lns_b_rec.attribute7 := l_okl_cntr_lvlng_lns_b_rec.attribute7;
1816: END IF;
1817: IF (x_okl_cntr_lvlng_lns_b_rec.attribute8 = OKL_API.G_MISS_CHAR)
1818: THEN
1819: x_okl_cntr_lvlng_lns_b_rec.attribute8 := l_okl_cntr_lvlng_lns_b_rec.attribute8;
1820: END IF;
1821: IF (x_okl_cntr_lvlng_lns_b_rec.attribute9 = OKL_API.G_MISS_CHAR)
1815: x_okl_cntr_lvlng_lns_b_rec.attribute7 := l_okl_cntr_lvlng_lns_b_rec.attribute7;
1816: END IF;
1817: IF (x_okl_cntr_lvlng_lns_b_rec.attribute8 = OKL_API.G_MISS_CHAR)
1818: THEN
1819: x_okl_cntr_lvlng_lns_b_rec.attribute8 := l_okl_cntr_lvlng_lns_b_rec.attribute8;
1820: END IF;
1821: IF (x_okl_cntr_lvlng_lns_b_rec.attribute9 = OKL_API.G_MISS_CHAR)
1822: THEN
1823: x_okl_cntr_lvlng_lns_b_rec.attribute9 := l_okl_cntr_lvlng_lns_b_rec.attribute9;
1817: IF (x_okl_cntr_lvlng_lns_b_rec.attribute8 = OKL_API.G_MISS_CHAR)
1818: THEN
1819: x_okl_cntr_lvlng_lns_b_rec.attribute8 := l_okl_cntr_lvlng_lns_b_rec.attribute8;
1820: END IF;
1821: IF (x_okl_cntr_lvlng_lns_b_rec.attribute9 = OKL_API.G_MISS_CHAR)
1822: THEN
1823: x_okl_cntr_lvlng_lns_b_rec.attribute9 := l_okl_cntr_lvlng_lns_b_rec.attribute9;
1824: END IF;
1825: IF (x_okl_cntr_lvlng_lns_b_rec.attribute10 = OKL_API.G_MISS_CHAR)
1819: x_okl_cntr_lvlng_lns_b_rec.attribute8 := l_okl_cntr_lvlng_lns_b_rec.attribute8;
1820: END IF;
1821: IF (x_okl_cntr_lvlng_lns_b_rec.attribute9 = OKL_API.G_MISS_CHAR)
1822: THEN
1823: x_okl_cntr_lvlng_lns_b_rec.attribute9 := l_okl_cntr_lvlng_lns_b_rec.attribute9;
1824: END IF;
1825: IF (x_okl_cntr_lvlng_lns_b_rec.attribute10 = OKL_API.G_MISS_CHAR)
1826: THEN
1827: x_okl_cntr_lvlng_lns_b_rec.attribute10 := l_okl_cntr_lvlng_lns_b_rec.attribute10;
1821: IF (x_okl_cntr_lvlng_lns_b_rec.attribute9 = OKL_API.G_MISS_CHAR)
1822: THEN
1823: x_okl_cntr_lvlng_lns_b_rec.attribute9 := l_okl_cntr_lvlng_lns_b_rec.attribute9;
1824: END IF;
1825: IF (x_okl_cntr_lvlng_lns_b_rec.attribute10 = OKL_API.G_MISS_CHAR)
1826: THEN
1827: x_okl_cntr_lvlng_lns_b_rec.attribute10 := l_okl_cntr_lvlng_lns_b_rec.attribute10;
1828: END IF;
1829: IF (x_okl_cntr_lvlng_lns_b_rec.attribute11 = OKL_API.G_MISS_CHAR)
1823: x_okl_cntr_lvlng_lns_b_rec.attribute9 := l_okl_cntr_lvlng_lns_b_rec.attribute9;
1824: END IF;
1825: IF (x_okl_cntr_lvlng_lns_b_rec.attribute10 = OKL_API.G_MISS_CHAR)
1826: THEN
1827: x_okl_cntr_lvlng_lns_b_rec.attribute10 := l_okl_cntr_lvlng_lns_b_rec.attribute10;
1828: END IF;
1829: IF (x_okl_cntr_lvlng_lns_b_rec.attribute11 = OKL_API.G_MISS_CHAR)
1830: THEN
1831: x_okl_cntr_lvlng_lns_b_rec.attribute11 := l_okl_cntr_lvlng_lns_b_rec.attribute11;
1825: IF (x_okl_cntr_lvlng_lns_b_rec.attribute10 = OKL_API.G_MISS_CHAR)
1826: THEN
1827: x_okl_cntr_lvlng_lns_b_rec.attribute10 := l_okl_cntr_lvlng_lns_b_rec.attribute10;
1828: END IF;
1829: IF (x_okl_cntr_lvlng_lns_b_rec.attribute11 = OKL_API.G_MISS_CHAR)
1830: THEN
1831: x_okl_cntr_lvlng_lns_b_rec.attribute11 := l_okl_cntr_lvlng_lns_b_rec.attribute11;
1832: END IF;
1833: IF (x_okl_cntr_lvlng_lns_b_rec.attribute12 = OKL_API.G_MISS_CHAR)
1827: x_okl_cntr_lvlng_lns_b_rec.attribute10 := l_okl_cntr_lvlng_lns_b_rec.attribute10;
1828: END IF;
1829: IF (x_okl_cntr_lvlng_lns_b_rec.attribute11 = OKL_API.G_MISS_CHAR)
1830: THEN
1831: x_okl_cntr_lvlng_lns_b_rec.attribute11 := l_okl_cntr_lvlng_lns_b_rec.attribute11;
1832: END IF;
1833: IF (x_okl_cntr_lvlng_lns_b_rec.attribute12 = OKL_API.G_MISS_CHAR)
1834: THEN
1835: x_okl_cntr_lvlng_lns_b_rec.attribute12 := l_okl_cntr_lvlng_lns_b_rec.attribute12;
1829: IF (x_okl_cntr_lvlng_lns_b_rec.attribute11 = OKL_API.G_MISS_CHAR)
1830: THEN
1831: x_okl_cntr_lvlng_lns_b_rec.attribute11 := l_okl_cntr_lvlng_lns_b_rec.attribute11;
1832: END IF;
1833: IF (x_okl_cntr_lvlng_lns_b_rec.attribute12 = OKL_API.G_MISS_CHAR)
1834: THEN
1835: x_okl_cntr_lvlng_lns_b_rec.attribute12 := l_okl_cntr_lvlng_lns_b_rec.attribute12;
1836: END IF;
1837: IF (x_okl_cntr_lvlng_lns_b_rec.attribute13 = OKL_API.G_MISS_CHAR)
1831: x_okl_cntr_lvlng_lns_b_rec.attribute11 := l_okl_cntr_lvlng_lns_b_rec.attribute11;
1832: END IF;
1833: IF (x_okl_cntr_lvlng_lns_b_rec.attribute12 = OKL_API.G_MISS_CHAR)
1834: THEN
1835: x_okl_cntr_lvlng_lns_b_rec.attribute12 := l_okl_cntr_lvlng_lns_b_rec.attribute12;
1836: END IF;
1837: IF (x_okl_cntr_lvlng_lns_b_rec.attribute13 = OKL_API.G_MISS_CHAR)
1838: THEN
1839: x_okl_cntr_lvlng_lns_b_rec.attribute13 := l_okl_cntr_lvlng_lns_b_rec.attribute13;
1833: IF (x_okl_cntr_lvlng_lns_b_rec.attribute12 = OKL_API.G_MISS_CHAR)
1834: THEN
1835: x_okl_cntr_lvlng_lns_b_rec.attribute12 := l_okl_cntr_lvlng_lns_b_rec.attribute12;
1836: END IF;
1837: IF (x_okl_cntr_lvlng_lns_b_rec.attribute13 = OKL_API.G_MISS_CHAR)
1838: THEN
1839: x_okl_cntr_lvlng_lns_b_rec.attribute13 := l_okl_cntr_lvlng_lns_b_rec.attribute13;
1840: END IF;
1841: IF (x_okl_cntr_lvlng_lns_b_rec.attribute14 = OKL_API.G_MISS_CHAR)
1835: x_okl_cntr_lvlng_lns_b_rec.attribute12 := l_okl_cntr_lvlng_lns_b_rec.attribute12;
1836: END IF;
1837: IF (x_okl_cntr_lvlng_lns_b_rec.attribute13 = OKL_API.G_MISS_CHAR)
1838: THEN
1839: x_okl_cntr_lvlng_lns_b_rec.attribute13 := l_okl_cntr_lvlng_lns_b_rec.attribute13;
1840: END IF;
1841: IF (x_okl_cntr_lvlng_lns_b_rec.attribute14 = OKL_API.G_MISS_CHAR)
1842: THEN
1843: x_okl_cntr_lvlng_lns_b_rec.attribute14 := l_okl_cntr_lvlng_lns_b_rec.attribute14;
1837: IF (x_okl_cntr_lvlng_lns_b_rec.attribute13 = OKL_API.G_MISS_CHAR)
1838: THEN
1839: x_okl_cntr_lvlng_lns_b_rec.attribute13 := l_okl_cntr_lvlng_lns_b_rec.attribute13;
1840: END IF;
1841: IF (x_okl_cntr_lvlng_lns_b_rec.attribute14 = OKL_API.G_MISS_CHAR)
1842: THEN
1843: x_okl_cntr_lvlng_lns_b_rec.attribute14 := l_okl_cntr_lvlng_lns_b_rec.attribute14;
1844: END IF;
1845: IF (x_okl_cntr_lvlng_lns_b_rec.attribute15 = OKL_API.G_MISS_CHAR)
1839: x_okl_cntr_lvlng_lns_b_rec.attribute13 := l_okl_cntr_lvlng_lns_b_rec.attribute13;
1840: END IF;
1841: IF (x_okl_cntr_lvlng_lns_b_rec.attribute14 = OKL_API.G_MISS_CHAR)
1842: THEN
1843: x_okl_cntr_lvlng_lns_b_rec.attribute14 := l_okl_cntr_lvlng_lns_b_rec.attribute14;
1844: END IF;
1845: IF (x_okl_cntr_lvlng_lns_b_rec.attribute15 = OKL_API.G_MISS_CHAR)
1846: THEN
1847: x_okl_cntr_lvlng_lns_b_rec.attribute15 := l_okl_cntr_lvlng_lns_b_rec.attribute15;
1841: IF (x_okl_cntr_lvlng_lns_b_rec.attribute14 = OKL_API.G_MISS_CHAR)
1842: THEN
1843: x_okl_cntr_lvlng_lns_b_rec.attribute14 := l_okl_cntr_lvlng_lns_b_rec.attribute14;
1844: END IF;
1845: IF (x_okl_cntr_lvlng_lns_b_rec.attribute15 = OKL_API.G_MISS_CHAR)
1846: THEN
1847: x_okl_cntr_lvlng_lns_b_rec.attribute15 := l_okl_cntr_lvlng_lns_b_rec.attribute15;
1848: END IF;
1849: IF (x_okl_cntr_lvlng_lns_b_rec.created_by = OKL_API.G_MISS_NUM)
1843: x_okl_cntr_lvlng_lns_b_rec.attribute14 := l_okl_cntr_lvlng_lns_b_rec.attribute14;
1844: END IF;
1845: IF (x_okl_cntr_lvlng_lns_b_rec.attribute15 = OKL_API.G_MISS_CHAR)
1846: THEN
1847: x_okl_cntr_lvlng_lns_b_rec.attribute15 := l_okl_cntr_lvlng_lns_b_rec.attribute15;
1848: END IF;
1849: IF (x_okl_cntr_lvlng_lns_b_rec.created_by = OKL_API.G_MISS_NUM)
1850: THEN
1851: x_okl_cntr_lvlng_lns_b_rec.created_by := l_okl_cntr_lvlng_lns_b_rec.created_by;
1845: IF (x_okl_cntr_lvlng_lns_b_rec.attribute15 = OKL_API.G_MISS_CHAR)
1846: THEN
1847: x_okl_cntr_lvlng_lns_b_rec.attribute15 := l_okl_cntr_lvlng_lns_b_rec.attribute15;
1848: END IF;
1849: IF (x_okl_cntr_lvlng_lns_b_rec.created_by = OKL_API.G_MISS_NUM)
1850: THEN
1851: x_okl_cntr_lvlng_lns_b_rec.created_by := l_okl_cntr_lvlng_lns_b_rec.created_by;
1852: END IF;
1853: IF (x_okl_cntr_lvlng_lns_b_rec.creation_date = OKL_API.G_MISS_DATE)
1847: x_okl_cntr_lvlng_lns_b_rec.attribute15 := l_okl_cntr_lvlng_lns_b_rec.attribute15;
1848: END IF;
1849: IF (x_okl_cntr_lvlng_lns_b_rec.created_by = OKL_API.G_MISS_NUM)
1850: THEN
1851: x_okl_cntr_lvlng_lns_b_rec.created_by := l_okl_cntr_lvlng_lns_b_rec.created_by;
1852: END IF;
1853: IF (x_okl_cntr_lvlng_lns_b_rec.creation_date = OKL_API.G_MISS_DATE)
1854: THEN
1855: x_okl_cntr_lvlng_lns_b_rec.creation_date := l_okl_cntr_lvlng_lns_b_rec.creation_date;
1849: IF (x_okl_cntr_lvlng_lns_b_rec.created_by = OKL_API.G_MISS_NUM)
1850: THEN
1851: x_okl_cntr_lvlng_lns_b_rec.created_by := l_okl_cntr_lvlng_lns_b_rec.created_by;
1852: END IF;
1853: IF (x_okl_cntr_lvlng_lns_b_rec.creation_date = OKL_API.G_MISS_DATE)
1854: THEN
1855: x_okl_cntr_lvlng_lns_b_rec.creation_date := l_okl_cntr_lvlng_lns_b_rec.creation_date;
1856: END IF;
1857: IF (x_okl_cntr_lvlng_lns_b_rec.last_updated_by = OKL_API.G_MISS_NUM)
1851: x_okl_cntr_lvlng_lns_b_rec.created_by := l_okl_cntr_lvlng_lns_b_rec.created_by;
1852: END IF;
1853: IF (x_okl_cntr_lvlng_lns_b_rec.creation_date = OKL_API.G_MISS_DATE)
1854: THEN
1855: x_okl_cntr_lvlng_lns_b_rec.creation_date := l_okl_cntr_lvlng_lns_b_rec.creation_date;
1856: END IF;
1857: IF (x_okl_cntr_lvlng_lns_b_rec.last_updated_by = OKL_API.G_MISS_NUM)
1858: THEN
1859: x_okl_cntr_lvlng_lns_b_rec.last_updated_by := l_okl_cntr_lvlng_lns_b_rec.last_updated_by;
1853: IF (x_okl_cntr_lvlng_lns_b_rec.creation_date = OKL_API.G_MISS_DATE)
1854: THEN
1855: x_okl_cntr_lvlng_lns_b_rec.creation_date := l_okl_cntr_lvlng_lns_b_rec.creation_date;
1856: END IF;
1857: IF (x_okl_cntr_lvlng_lns_b_rec.last_updated_by = OKL_API.G_MISS_NUM)
1858: THEN
1859: x_okl_cntr_lvlng_lns_b_rec.last_updated_by := l_okl_cntr_lvlng_lns_b_rec.last_updated_by;
1860: END IF;
1861: IF (x_okl_cntr_lvlng_lns_b_rec.last_update_date = OKL_API.G_MISS_DATE)
1855: x_okl_cntr_lvlng_lns_b_rec.creation_date := l_okl_cntr_lvlng_lns_b_rec.creation_date;
1856: END IF;
1857: IF (x_okl_cntr_lvlng_lns_b_rec.last_updated_by = OKL_API.G_MISS_NUM)
1858: THEN
1859: x_okl_cntr_lvlng_lns_b_rec.last_updated_by := l_okl_cntr_lvlng_lns_b_rec.last_updated_by;
1860: END IF;
1861: IF (x_okl_cntr_lvlng_lns_b_rec.last_update_date = OKL_API.G_MISS_DATE)
1862: THEN
1863: x_okl_cntr_lvlng_lns_b_rec.last_update_date := l_okl_cntr_lvlng_lns_b_rec.last_update_date;
1857: IF (x_okl_cntr_lvlng_lns_b_rec.last_updated_by = OKL_API.G_MISS_NUM)
1858: THEN
1859: x_okl_cntr_lvlng_lns_b_rec.last_updated_by := l_okl_cntr_lvlng_lns_b_rec.last_updated_by;
1860: END IF;
1861: IF (x_okl_cntr_lvlng_lns_b_rec.last_update_date = OKL_API.G_MISS_DATE)
1862: THEN
1863: x_okl_cntr_lvlng_lns_b_rec.last_update_date := l_okl_cntr_lvlng_lns_b_rec.last_update_date;
1864: END IF;
1865: IF (x_okl_cntr_lvlng_lns_b_rec.last_update_login = OKL_API.G_MISS_NUM)
1859: x_okl_cntr_lvlng_lns_b_rec.last_updated_by := l_okl_cntr_lvlng_lns_b_rec.last_updated_by;
1860: END IF;
1861: IF (x_okl_cntr_lvlng_lns_b_rec.last_update_date = OKL_API.G_MISS_DATE)
1862: THEN
1863: x_okl_cntr_lvlng_lns_b_rec.last_update_date := l_okl_cntr_lvlng_lns_b_rec.last_update_date;
1864: END IF;
1865: IF (x_okl_cntr_lvlng_lns_b_rec.last_update_login = OKL_API.G_MISS_NUM)
1866: THEN
1867: x_okl_cntr_lvlng_lns_b_rec.last_update_login := l_okl_cntr_lvlng_lns_b_rec.last_update_login;
1861: IF (x_okl_cntr_lvlng_lns_b_rec.last_update_date = OKL_API.G_MISS_DATE)
1862: THEN
1863: x_okl_cntr_lvlng_lns_b_rec.last_update_date := l_okl_cntr_lvlng_lns_b_rec.last_update_date;
1864: END IF;
1865: IF (x_okl_cntr_lvlng_lns_b_rec.last_update_login = OKL_API.G_MISS_NUM)
1866: THEN
1867: x_okl_cntr_lvlng_lns_b_rec.last_update_login := l_okl_cntr_lvlng_lns_b_rec.last_update_login;
1868: END IF;
1869: END IF;
1863: x_okl_cntr_lvlng_lns_b_rec.last_update_date := l_okl_cntr_lvlng_lns_b_rec.last_update_date;
1864: END IF;
1865: IF (x_okl_cntr_lvlng_lns_b_rec.last_update_login = OKL_API.G_MISS_NUM)
1866: THEN
1867: x_okl_cntr_lvlng_lns_b_rec.last_update_login := l_okl_cntr_lvlng_lns_b_rec.last_update_login;
1868: END IF;
1869: END IF;
1870: RETURN(l_return_status);
1871: END populate_new_record;
1869: END IF;
1870: RETURN(l_return_status);
1871: END populate_new_record;
1872: ---------------------------------------------
1873: -- Set_Attributes for:OKL_CNTR_LVLNG_LNS_B --
1874: ---------------------------------------------
1875: FUNCTION Set_Attributes (
1876: p_okl_cntr_lvlng_lns_b_rec IN okl_cntr_lvlng_lns_b_rec_type,
1877: x_okl_cntr_lvlng_lns_b_rec OUT NOCOPY okl_cntr_lvlng_lns_b_rec_type
1872: ---------------------------------------------
1873: -- Set_Attributes for:OKL_CNTR_LVLNG_LNS_B --
1874: ---------------------------------------------
1875: FUNCTION Set_Attributes (
1876: p_okl_cntr_lvlng_lns_b_rec IN okl_cntr_lvlng_lns_b_rec_type,
1877: x_okl_cntr_lvlng_lns_b_rec OUT NOCOPY okl_cntr_lvlng_lns_b_rec_type
1878: ) RETURN VARCHAR2 IS
1879: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1880: BEGIN
1873: -- Set_Attributes for:OKL_CNTR_LVLNG_LNS_B --
1874: ---------------------------------------------
1875: FUNCTION Set_Attributes (
1876: p_okl_cntr_lvlng_lns_b_rec IN okl_cntr_lvlng_lns_b_rec_type,
1877: x_okl_cntr_lvlng_lns_b_rec OUT NOCOPY okl_cntr_lvlng_lns_b_rec_type
1878: ) RETURN VARCHAR2 IS
1879: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1880: BEGIN
1881: x_okl_cntr_lvlng_lns_b_rec := p_okl_cntr_lvlng_lns_b_rec;
1877: x_okl_cntr_lvlng_lns_b_rec OUT NOCOPY okl_cntr_lvlng_lns_b_rec_type
1878: ) RETURN VARCHAR2 IS
1879: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1880: BEGIN
1881: x_okl_cntr_lvlng_lns_b_rec := p_okl_cntr_lvlng_lns_b_rec;
1882: x_okl_cntr_lvlng_lns_b_rec.OBJECT_VERSION_NUMBER := p_okl_cntr_lvlng_lns_b_rec.OBJECT_VERSION_NUMBER + 1;
1883: RETURN(l_return_status);
1884: END Set_Attributes;
1885: BEGIN
1878: ) RETURN VARCHAR2 IS
1879: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1880: BEGIN
1881: x_okl_cntr_lvlng_lns_b_rec := p_okl_cntr_lvlng_lns_b_rec;
1882: x_okl_cntr_lvlng_lns_b_rec.OBJECT_VERSION_NUMBER := p_okl_cntr_lvlng_lns_b_rec.OBJECT_VERSION_NUMBER + 1;
1883: RETURN(l_return_status);
1884: END Set_Attributes;
1885: BEGIN
1886: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
1893: RAISE OKL_API.G_EXCEPTION_ERROR;
1894: END IF;
1895: --- Setting item attributes
1896: l_return_status := Set_Attributes(
1897: p_okl_cntr_lvlng_lns_b_rec, -- IN
1898: l_okl_cntr_lvlng_lns_b_rec); -- OUT
1899: --- If any errors happen abort API
1900: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1901: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1894: END IF;
1895: --- Setting item attributes
1896: l_return_status := Set_Attributes(
1897: p_okl_cntr_lvlng_lns_b_rec, -- IN
1898: l_okl_cntr_lvlng_lns_b_rec); -- OUT
1899: --- If any errors happen abort API
1900: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1901: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1902: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1901: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1902: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1903: RAISE OKL_API.G_EXCEPTION_ERROR;
1904: END IF;
1905: l_return_status := populate_new_record(l_okl_cntr_lvlng_lns_b_rec, l_def_okl_cntr_lvlng_lns_b_rec);
1906: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1907: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1908: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1909: RAISE OKL_API.G_EXCEPTION_ERROR;
1907: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1908: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1909: RAISE OKL_API.G_EXCEPTION_ERROR;
1910: END IF;
1911: UPDATE OKL_CNTR_LVLNG_LNS_B
1912: SET KLE_ID = l_def_okl_cntr_lvlng_lns_b_rec.kle_id,
1913: CLG_ID = l_def_okl_cntr_lvlng_lns_b_rec.clg_id,
1914: OBJECT_VERSION_NUMBER = l_def_okl_cntr_lvlng_lns_b_rec.object_version_number,
1915: ATTRIBUTE_CATEGORY = l_def_okl_cntr_lvlng_lns_b_rec.attribute_category,
1908: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1909: RAISE OKL_API.G_EXCEPTION_ERROR;
1910: END IF;
1911: UPDATE OKL_CNTR_LVLNG_LNS_B
1912: SET KLE_ID = l_def_okl_cntr_lvlng_lns_b_rec.kle_id,
1913: CLG_ID = l_def_okl_cntr_lvlng_lns_b_rec.clg_id,
1914: OBJECT_VERSION_NUMBER = l_def_okl_cntr_lvlng_lns_b_rec.object_version_number,
1915: ATTRIBUTE_CATEGORY = l_def_okl_cntr_lvlng_lns_b_rec.attribute_category,
1916: ATTRIBUTE1 = l_def_okl_cntr_lvlng_lns_b_rec.attribute1,
1909: RAISE OKL_API.G_EXCEPTION_ERROR;
1910: END IF;
1911: UPDATE OKL_CNTR_LVLNG_LNS_B
1912: SET KLE_ID = l_def_okl_cntr_lvlng_lns_b_rec.kle_id,
1913: CLG_ID = l_def_okl_cntr_lvlng_lns_b_rec.clg_id,
1914: OBJECT_VERSION_NUMBER = l_def_okl_cntr_lvlng_lns_b_rec.object_version_number,
1915: ATTRIBUTE_CATEGORY = l_def_okl_cntr_lvlng_lns_b_rec.attribute_category,
1916: ATTRIBUTE1 = l_def_okl_cntr_lvlng_lns_b_rec.attribute1,
1917: ATTRIBUTE2 = l_def_okl_cntr_lvlng_lns_b_rec.attribute2,
1910: END IF;
1911: UPDATE OKL_CNTR_LVLNG_LNS_B
1912: SET KLE_ID = l_def_okl_cntr_lvlng_lns_b_rec.kle_id,
1913: CLG_ID = l_def_okl_cntr_lvlng_lns_b_rec.clg_id,
1914: OBJECT_VERSION_NUMBER = l_def_okl_cntr_lvlng_lns_b_rec.object_version_number,
1915: ATTRIBUTE_CATEGORY = l_def_okl_cntr_lvlng_lns_b_rec.attribute_category,
1916: ATTRIBUTE1 = l_def_okl_cntr_lvlng_lns_b_rec.attribute1,
1917: ATTRIBUTE2 = l_def_okl_cntr_lvlng_lns_b_rec.attribute2,
1918: ATTRIBUTE3 = l_def_okl_cntr_lvlng_lns_b_rec.attribute3,
1911: UPDATE OKL_CNTR_LVLNG_LNS_B
1912: SET KLE_ID = l_def_okl_cntr_lvlng_lns_b_rec.kle_id,
1913: CLG_ID = l_def_okl_cntr_lvlng_lns_b_rec.clg_id,
1914: OBJECT_VERSION_NUMBER = l_def_okl_cntr_lvlng_lns_b_rec.object_version_number,
1915: ATTRIBUTE_CATEGORY = l_def_okl_cntr_lvlng_lns_b_rec.attribute_category,
1916: ATTRIBUTE1 = l_def_okl_cntr_lvlng_lns_b_rec.attribute1,
1917: ATTRIBUTE2 = l_def_okl_cntr_lvlng_lns_b_rec.attribute2,
1918: ATTRIBUTE3 = l_def_okl_cntr_lvlng_lns_b_rec.attribute3,
1919: ATTRIBUTE4 = l_def_okl_cntr_lvlng_lns_b_rec.attribute4,
1912: SET KLE_ID = l_def_okl_cntr_lvlng_lns_b_rec.kle_id,
1913: CLG_ID = l_def_okl_cntr_lvlng_lns_b_rec.clg_id,
1914: OBJECT_VERSION_NUMBER = l_def_okl_cntr_lvlng_lns_b_rec.object_version_number,
1915: ATTRIBUTE_CATEGORY = l_def_okl_cntr_lvlng_lns_b_rec.attribute_category,
1916: ATTRIBUTE1 = l_def_okl_cntr_lvlng_lns_b_rec.attribute1,
1917: ATTRIBUTE2 = l_def_okl_cntr_lvlng_lns_b_rec.attribute2,
1918: ATTRIBUTE3 = l_def_okl_cntr_lvlng_lns_b_rec.attribute3,
1919: ATTRIBUTE4 = l_def_okl_cntr_lvlng_lns_b_rec.attribute4,
1920: ATTRIBUTE5 = l_def_okl_cntr_lvlng_lns_b_rec.attribute5,
1913: CLG_ID = l_def_okl_cntr_lvlng_lns_b_rec.clg_id,
1914: OBJECT_VERSION_NUMBER = l_def_okl_cntr_lvlng_lns_b_rec.object_version_number,
1915: ATTRIBUTE_CATEGORY = l_def_okl_cntr_lvlng_lns_b_rec.attribute_category,
1916: ATTRIBUTE1 = l_def_okl_cntr_lvlng_lns_b_rec.attribute1,
1917: ATTRIBUTE2 = l_def_okl_cntr_lvlng_lns_b_rec.attribute2,
1918: ATTRIBUTE3 = l_def_okl_cntr_lvlng_lns_b_rec.attribute3,
1919: ATTRIBUTE4 = l_def_okl_cntr_lvlng_lns_b_rec.attribute4,
1920: ATTRIBUTE5 = l_def_okl_cntr_lvlng_lns_b_rec.attribute5,
1921: ATTRIBUTE6 = l_def_okl_cntr_lvlng_lns_b_rec.attribute6,
1914: OBJECT_VERSION_NUMBER = l_def_okl_cntr_lvlng_lns_b_rec.object_version_number,
1915: ATTRIBUTE_CATEGORY = l_def_okl_cntr_lvlng_lns_b_rec.attribute_category,
1916: ATTRIBUTE1 = l_def_okl_cntr_lvlng_lns_b_rec.attribute1,
1917: ATTRIBUTE2 = l_def_okl_cntr_lvlng_lns_b_rec.attribute2,
1918: ATTRIBUTE3 = l_def_okl_cntr_lvlng_lns_b_rec.attribute3,
1919: ATTRIBUTE4 = l_def_okl_cntr_lvlng_lns_b_rec.attribute4,
1920: ATTRIBUTE5 = l_def_okl_cntr_lvlng_lns_b_rec.attribute5,
1921: ATTRIBUTE6 = l_def_okl_cntr_lvlng_lns_b_rec.attribute6,
1922: ATTRIBUTE7 = l_def_okl_cntr_lvlng_lns_b_rec.attribute7,
1915: ATTRIBUTE_CATEGORY = l_def_okl_cntr_lvlng_lns_b_rec.attribute_category,
1916: ATTRIBUTE1 = l_def_okl_cntr_lvlng_lns_b_rec.attribute1,
1917: ATTRIBUTE2 = l_def_okl_cntr_lvlng_lns_b_rec.attribute2,
1918: ATTRIBUTE3 = l_def_okl_cntr_lvlng_lns_b_rec.attribute3,
1919: ATTRIBUTE4 = l_def_okl_cntr_lvlng_lns_b_rec.attribute4,
1920: ATTRIBUTE5 = l_def_okl_cntr_lvlng_lns_b_rec.attribute5,
1921: ATTRIBUTE6 = l_def_okl_cntr_lvlng_lns_b_rec.attribute6,
1922: ATTRIBUTE7 = l_def_okl_cntr_lvlng_lns_b_rec.attribute7,
1923: ATTRIBUTE8 = l_def_okl_cntr_lvlng_lns_b_rec.attribute8,
1916: ATTRIBUTE1 = l_def_okl_cntr_lvlng_lns_b_rec.attribute1,
1917: ATTRIBUTE2 = l_def_okl_cntr_lvlng_lns_b_rec.attribute2,
1918: ATTRIBUTE3 = l_def_okl_cntr_lvlng_lns_b_rec.attribute3,
1919: ATTRIBUTE4 = l_def_okl_cntr_lvlng_lns_b_rec.attribute4,
1920: ATTRIBUTE5 = l_def_okl_cntr_lvlng_lns_b_rec.attribute5,
1921: ATTRIBUTE6 = l_def_okl_cntr_lvlng_lns_b_rec.attribute6,
1922: ATTRIBUTE7 = l_def_okl_cntr_lvlng_lns_b_rec.attribute7,
1923: ATTRIBUTE8 = l_def_okl_cntr_lvlng_lns_b_rec.attribute8,
1924: ATTRIBUTE9 = l_def_okl_cntr_lvlng_lns_b_rec.attribute9,
1917: ATTRIBUTE2 = l_def_okl_cntr_lvlng_lns_b_rec.attribute2,
1918: ATTRIBUTE3 = l_def_okl_cntr_lvlng_lns_b_rec.attribute3,
1919: ATTRIBUTE4 = l_def_okl_cntr_lvlng_lns_b_rec.attribute4,
1920: ATTRIBUTE5 = l_def_okl_cntr_lvlng_lns_b_rec.attribute5,
1921: ATTRIBUTE6 = l_def_okl_cntr_lvlng_lns_b_rec.attribute6,
1922: ATTRIBUTE7 = l_def_okl_cntr_lvlng_lns_b_rec.attribute7,
1923: ATTRIBUTE8 = l_def_okl_cntr_lvlng_lns_b_rec.attribute8,
1924: ATTRIBUTE9 = l_def_okl_cntr_lvlng_lns_b_rec.attribute9,
1925: ATTRIBUTE10 = l_def_okl_cntr_lvlng_lns_b_rec.attribute10,
1918: ATTRIBUTE3 = l_def_okl_cntr_lvlng_lns_b_rec.attribute3,
1919: ATTRIBUTE4 = l_def_okl_cntr_lvlng_lns_b_rec.attribute4,
1920: ATTRIBUTE5 = l_def_okl_cntr_lvlng_lns_b_rec.attribute5,
1921: ATTRIBUTE6 = l_def_okl_cntr_lvlng_lns_b_rec.attribute6,
1922: ATTRIBUTE7 = l_def_okl_cntr_lvlng_lns_b_rec.attribute7,
1923: ATTRIBUTE8 = l_def_okl_cntr_lvlng_lns_b_rec.attribute8,
1924: ATTRIBUTE9 = l_def_okl_cntr_lvlng_lns_b_rec.attribute9,
1925: ATTRIBUTE10 = l_def_okl_cntr_lvlng_lns_b_rec.attribute10,
1926: ATTRIBUTE11 = l_def_okl_cntr_lvlng_lns_b_rec.attribute11,
1919: ATTRIBUTE4 = l_def_okl_cntr_lvlng_lns_b_rec.attribute4,
1920: ATTRIBUTE5 = l_def_okl_cntr_lvlng_lns_b_rec.attribute5,
1921: ATTRIBUTE6 = l_def_okl_cntr_lvlng_lns_b_rec.attribute6,
1922: ATTRIBUTE7 = l_def_okl_cntr_lvlng_lns_b_rec.attribute7,
1923: ATTRIBUTE8 = l_def_okl_cntr_lvlng_lns_b_rec.attribute8,
1924: ATTRIBUTE9 = l_def_okl_cntr_lvlng_lns_b_rec.attribute9,
1925: ATTRIBUTE10 = l_def_okl_cntr_lvlng_lns_b_rec.attribute10,
1926: ATTRIBUTE11 = l_def_okl_cntr_lvlng_lns_b_rec.attribute11,
1927: ATTRIBUTE12 = l_def_okl_cntr_lvlng_lns_b_rec.attribute12,
1920: ATTRIBUTE5 = l_def_okl_cntr_lvlng_lns_b_rec.attribute5,
1921: ATTRIBUTE6 = l_def_okl_cntr_lvlng_lns_b_rec.attribute6,
1922: ATTRIBUTE7 = l_def_okl_cntr_lvlng_lns_b_rec.attribute7,
1923: ATTRIBUTE8 = l_def_okl_cntr_lvlng_lns_b_rec.attribute8,
1924: ATTRIBUTE9 = l_def_okl_cntr_lvlng_lns_b_rec.attribute9,
1925: ATTRIBUTE10 = l_def_okl_cntr_lvlng_lns_b_rec.attribute10,
1926: ATTRIBUTE11 = l_def_okl_cntr_lvlng_lns_b_rec.attribute11,
1927: ATTRIBUTE12 = l_def_okl_cntr_lvlng_lns_b_rec.attribute12,
1928: ATTRIBUTE13 = l_def_okl_cntr_lvlng_lns_b_rec.attribute13,
1921: ATTRIBUTE6 = l_def_okl_cntr_lvlng_lns_b_rec.attribute6,
1922: ATTRIBUTE7 = l_def_okl_cntr_lvlng_lns_b_rec.attribute7,
1923: ATTRIBUTE8 = l_def_okl_cntr_lvlng_lns_b_rec.attribute8,
1924: ATTRIBUTE9 = l_def_okl_cntr_lvlng_lns_b_rec.attribute9,
1925: ATTRIBUTE10 = l_def_okl_cntr_lvlng_lns_b_rec.attribute10,
1926: ATTRIBUTE11 = l_def_okl_cntr_lvlng_lns_b_rec.attribute11,
1927: ATTRIBUTE12 = l_def_okl_cntr_lvlng_lns_b_rec.attribute12,
1928: ATTRIBUTE13 = l_def_okl_cntr_lvlng_lns_b_rec.attribute13,
1929: ATTRIBUTE14 = l_def_okl_cntr_lvlng_lns_b_rec.attribute14,
1922: ATTRIBUTE7 = l_def_okl_cntr_lvlng_lns_b_rec.attribute7,
1923: ATTRIBUTE8 = l_def_okl_cntr_lvlng_lns_b_rec.attribute8,
1924: ATTRIBUTE9 = l_def_okl_cntr_lvlng_lns_b_rec.attribute9,
1925: ATTRIBUTE10 = l_def_okl_cntr_lvlng_lns_b_rec.attribute10,
1926: ATTRIBUTE11 = l_def_okl_cntr_lvlng_lns_b_rec.attribute11,
1927: ATTRIBUTE12 = l_def_okl_cntr_lvlng_lns_b_rec.attribute12,
1928: ATTRIBUTE13 = l_def_okl_cntr_lvlng_lns_b_rec.attribute13,
1929: ATTRIBUTE14 = l_def_okl_cntr_lvlng_lns_b_rec.attribute14,
1930: ATTRIBUTE15 = l_def_okl_cntr_lvlng_lns_b_rec.attribute15,
1923: ATTRIBUTE8 = l_def_okl_cntr_lvlng_lns_b_rec.attribute8,
1924: ATTRIBUTE9 = l_def_okl_cntr_lvlng_lns_b_rec.attribute9,
1925: ATTRIBUTE10 = l_def_okl_cntr_lvlng_lns_b_rec.attribute10,
1926: ATTRIBUTE11 = l_def_okl_cntr_lvlng_lns_b_rec.attribute11,
1927: ATTRIBUTE12 = l_def_okl_cntr_lvlng_lns_b_rec.attribute12,
1928: ATTRIBUTE13 = l_def_okl_cntr_lvlng_lns_b_rec.attribute13,
1929: ATTRIBUTE14 = l_def_okl_cntr_lvlng_lns_b_rec.attribute14,
1930: ATTRIBUTE15 = l_def_okl_cntr_lvlng_lns_b_rec.attribute15,
1931: CREATED_BY = l_def_okl_cntr_lvlng_lns_b_rec.created_by,
1924: ATTRIBUTE9 = l_def_okl_cntr_lvlng_lns_b_rec.attribute9,
1925: ATTRIBUTE10 = l_def_okl_cntr_lvlng_lns_b_rec.attribute10,
1926: ATTRIBUTE11 = l_def_okl_cntr_lvlng_lns_b_rec.attribute11,
1927: ATTRIBUTE12 = l_def_okl_cntr_lvlng_lns_b_rec.attribute12,
1928: ATTRIBUTE13 = l_def_okl_cntr_lvlng_lns_b_rec.attribute13,
1929: ATTRIBUTE14 = l_def_okl_cntr_lvlng_lns_b_rec.attribute14,
1930: ATTRIBUTE15 = l_def_okl_cntr_lvlng_lns_b_rec.attribute15,
1931: CREATED_BY = l_def_okl_cntr_lvlng_lns_b_rec.created_by,
1932: CREATION_DATE = l_def_okl_cntr_lvlng_lns_b_rec.creation_date,
1925: ATTRIBUTE10 = l_def_okl_cntr_lvlng_lns_b_rec.attribute10,
1926: ATTRIBUTE11 = l_def_okl_cntr_lvlng_lns_b_rec.attribute11,
1927: ATTRIBUTE12 = l_def_okl_cntr_lvlng_lns_b_rec.attribute12,
1928: ATTRIBUTE13 = l_def_okl_cntr_lvlng_lns_b_rec.attribute13,
1929: ATTRIBUTE14 = l_def_okl_cntr_lvlng_lns_b_rec.attribute14,
1930: ATTRIBUTE15 = l_def_okl_cntr_lvlng_lns_b_rec.attribute15,
1931: CREATED_BY = l_def_okl_cntr_lvlng_lns_b_rec.created_by,
1932: CREATION_DATE = l_def_okl_cntr_lvlng_lns_b_rec.creation_date,
1933: LAST_UPDATED_BY = l_def_okl_cntr_lvlng_lns_b_rec.last_updated_by,
1926: ATTRIBUTE11 = l_def_okl_cntr_lvlng_lns_b_rec.attribute11,
1927: ATTRIBUTE12 = l_def_okl_cntr_lvlng_lns_b_rec.attribute12,
1928: ATTRIBUTE13 = l_def_okl_cntr_lvlng_lns_b_rec.attribute13,
1929: ATTRIBUTE14 = l_def_okl_cntr_lvlng_lns_b_rec.attribute14,
1930: ATTRIBUTE15 = l_def_okl_cntr_lvlng_lns_b_rec.attribute15,
1931: CREATED_BY = l_def_okl_cntr_lvlng_lns_b_rec.created_by,
1932: CREATION_DATE = l_def_okl_cntr_lvlng_lns_b_rec.creation_date,
1933: LAST_UPDATED_BY = l_def_okl_cntr_lvlng_lns_b_rec.last_updated_by,
1934: LAST_UPDATE_DATE = l_def_okl_cntr_lvlng_lns_b_rec.last_update_date,
1927: ATTRIBUTE12 = l_def_okl_cntr_lvlng_lns_b_rec.attribute12,
1928: ATTRIBUTE13 = l_def_okl_cntr_lvlng_lns_b_rec.attribute13,
1929: ATTRIBUTE14 = l_def_okl_cntr_lvlng_lns_b_rec.attribute14,
1930: ATTRIBUTE15 = l_def_okl_cntr_lvlng_lns_b_rec.attribute15,
1931: CREATED_BY = l_def_okl_cntr_lvlng_lns_b_rec.created_by,
1932: CREATION_DATE = l_def_okl_cntr_lvlng_lns_b_rec.creation_date,
1933: LAST_UPDATED_BY = l_def_okl_cntr_lvlng_lns_b_rec.last_updated_by,
1934: LAST_UPDATE_DATE = l_def_okl_cntr_lvlng_lns_b_rec.last_update_date,
1935: LAST_UPDATE_LOGIN = l_def_okl_cntr_lvlng_lns_b_rec.last_update_login
1928: ATTRIBUTE13 = l_def_okl_cntr_lvlng_lns_b_rec.attribute13,
1929: ATTRIBUTE14 = l_def_okl_cntr_lvlng_lns_b_rec.attribute14,
1930: ATTRIBUTE15 = l_def_okl_cntr_lvlng_lns_b_rec.attribute15,
1931: CREATED_BY = l_def_okl_cntr_lvlng_lns_b_rec.created_by,
1932: CREATION_DATE = l_def_okl_cntr_lvlng_lns_b_rec.creation_date,
1933: LAST_UPDATED_BY = l_def_okl_cntr_lvlng_lns_b_rec.last_updated_by,
1934: LAST_UPDATE_DATE = l_def_okl_cntr_lvlng_lns_b_rec.last_update_date,
1935: LAST_UPDATE_LOGIN = l_def_okl_cntr_lvlng_lns_b_rec.last_update_login
1936: WHERE ID = l_def_okl_cntr_lvlng_lns_b_rec.id;
1929: ATTRIBUTE14 = l_def_okl_cntr_lvlng_lns_b_rec.attribute14,
1930: ATTRIBUTE15 = l_def_okl_cntr_lvlng_lns_b_rec.attribute15,
1931: CREATED_BY = l_def_okl_cntr_lvlng_lns_b_rec.created_by,
1932: CREATION_DATE = l_def_okl_cntr_lvlng_lns_b_rec.creation_date,
1933: LAST_UPDATED_BY = l_def_okl_cntr_lvlng_lns_b_rec.last_updated_by,
1934: LAST_UPDATE_DATE = l_def_okl_cntr_lvlng_lns_b_rec.last_update_date,
1935: LAST_UPDATE_LOGIN = l_def_okl_cntr_lvlng_lns_b_rec.last_update_login
1936: WHERE ID = l_def_okl_cntr_lvlng_lns_b_rec.id;
1937:
1930: ATTRIBUTE15 = l_def_okl_cntr_lvlng_lns_b_rec.attribute15,
1931: CREATED_BY = l_def_okl_cntr_lvlng_lns_b_rec.created_by,
1932: CREATION_DATE = l_def_okl_cntr_lvlng_lns_b_rec.creation_date,
1933: LAST_UPDATED_BY = l_def_okl_cntr_lvlng_lns_b_rec.last_updated_by,
1934: LAST_UPDATE_DATE = l_def_okl_cntr_lvlng_lns_b_rec.last_update_date,
1935: LAST_UPDATE_LOGIN = l_def_okl_cntr_lvlng_lns_b_rec.last_update_login
1936: WHERE ID = l_def_okl_cntr_lvlng_lns_b_rec.id;
1937:
1938: x_okl_cntr_lvlng_lns_b_rec := l_okl_cntr_lvlng_lns_b_rec;
1931: CREATED_BY = l_def_okl_cntr_lvlng_lns_b_rec.created_by,
1932: CREATION_DATE = l_def_okl_cntr_lvlng_lns_b_rec.creation_date,
1933: LAST_UPDATED_BY = l_def_okl_cntr_lvlng_lns_b_rec.last_updated_by,
1934: LAST_UPDATE_DATE = l_def_okl_cntr_lvlng_lns_b_rec.last_update_date,
1935: LAST_UPDATE_LOGIN = l_def_okl_cntr_lvlng_lns_b_rec.last_update_login
1936: WHERE ID = l_def_okl_cntr_lvlng_lns_b_rec.id;
1937:
1938: x_okl_cntr_lvlng_lns_b_rec := l_okl_cntr_lvlng_lns_b_rec;
1939: x_return_status := l_return_status;
1932: CREATION_DATE = l_def_okl_cntr_lvlng_lns_b_rec.creation_date,
1933: LAST_UPDATED_BY = l_def_okl_cntr_lvlng_lns_b_rec.last_updated_by,
1934: LAST_UPDATE_DATE = l_def_okl_cntr_lvlng_lns_b_rec.last_update_date,
1935: LAST_UPDATE_LOGIN = l_def_okl_cntr_lvlng_lns_b_rec.last_update_login
1936: WHERE ID = l_def_okl_cntr_lvlng_lns_b_rec.id;
1937:
1938: x_okl_cntr_lvlng_lns_b_rec := l_okl_cntr_lvlng_lns_b_rec;
1939: x_return_status := l_return_status;
1940: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1934: LAST_UPDATE_DATE = l_def_okl_cntr_lvlng_lns_b_rec.last_update_date,
1935: LAST_UPDATE_LOGIN = l_def_okl_cntr_lvlng_lns_b_rec.last_update_login
1936: WHERE ID = l_def_okl_cntr_lvlng_lns_b_rec.id;
1937:
1938: x_okl_cntr_lvlng_lns_b_rec := l_okl_cntr_lvlng_lns_b_rec;
1939: x_return_status := l_return_status;
1940: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1941: EXCEPTION
1942: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1987: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1988: l_cllv_rec cllv_rec_type := p_cllv_rec;
1989: l_def_cllv_rec cllv_rec_type;
1990: l_db_cllv_rec cllv_rec_type;
1991: l_okl_cntr_lvlng_lns_b_rec okl_cntr_lvlng_lns_b_rec_type;
1992: lx_okl_cntr_lvlng_lns_b_rec okl_cntr_lvlng_lns_b_rec_type;
1993: -------------------------------
1994: -- FUNCTION fill_who_columns --
1995: -------------------------------
1988: l_cllv_rec cllv_rec_type := p_cllv_rec;
1989: l_def_cllv_rec cllv_rec_type;
1990: l_db_cllv_rec cllv_rec_type;
1991: l_okl_cntr_lvlng_lns_b_rec okl_cntr_lvlng_lns_b_rec_type;
1992: lx_okl_cntr_lvlng_lns_b_rec okl_cntr_lvlng_lns_b_rec_type;
1993: -------------------------------
1994: -- FUNCTION fill_who_columns --
1995: -------------------------------
1996: FUNCTION fill_who_columns (
2197: */
2198: -----------------------------------------
2199: -- Move VIEW record to "Child" records --
2200: -----------------------------------------
2201: migrate(l_def_cllv_rec, l_okl_cntr_lvlng_lns_b_rec);
2202: -----------------------------------------------
2203: -- Call the UPDATE_ROW for each child record --
2204: -----------------------------------------------
2205: update_row(
2206: p_init_msg_list,
2207: l_return_status,
2208: x_msg_count,
2209: x_msg_data,
2210: l_okl_cntr_lvlng_lns_b_rec,
2211: lx_okl_cntr_lvlng_lns_b_rec
2212: );
2213: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2214: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2207: l_return_status,
2208: x_msg_count,
2209: x_msg_data,
2210: l_okl_cntr_lvlng_lns_b_rec,
2211: lx_okl_cntr_lvlng_lns_b_rec
2212: );
2213: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2214: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2215: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2214: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2215: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2216: RAISE OKL_API.G_EXCEPTION_ERROR;
2217: END IF;
2218: migrate(lx_okl_cntr_lvlng_lns_b_rec, l_def_cllv_rec);
2219: x_cllv_rec := l_def_cllv_rec;
2220: x_return_status := l_return_status;
2221: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2222: EXCEPTION
2416: ---------------------------------------------------------------------------
2417: -- PROCEDURE delete_row
2418: ---------------------------------------------------------------------------
2419: -----------------------------------------
2420: -- delete_row for:OKL_CNTR_LVLNG_LNS_B --
2421: -----------------------------------------
2422: PROCEDURE delete_row(
2423: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
2424: x_return_status OUT NOCOPY VARCHAR2,
2423: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
2424: x_return_status OUT NOCOPY VARCHAR2,
2425: x_msg_count OUT NOCOPY NUMBER,
2426: x_msg_data OUT NOCOPY VARCHAR2,
2427: p_okl_cntr_lvlng_lns_b_rec IN okl_cntr_lvlng_lns_b_rec_type) IS
2428:
2429: l_api_version CONSTANT NUMBER := 1;
2430: l_api_name CONSTANT VARCHAR2(30) := 'B_delete_row';
2431: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2428:
2429: l_api_version CONSTANT NUMBER := 1;
2430: l_api_name CONSTANT VARCHAR2(30) := 'B_delete_row';
2431: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2432: l_okl_cntr_lvlng_lns_b_rec okl_cntr_lvlng_lns_b_rec_type := p_okl_cntr_lvlng_lns_b_rec;
2433: l_row_notfound BOOLEAN := TRUE;
2434: BEGIN
2435: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
2436: p_init_msg_list,
2441: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2442: RAISE OKL_API.G_EXCEPTION_ERROR;
2443: END IF;
2444:
2445: DELETE FROM OKL_CNTR_LVLNG_LNS_B
2446: WHERE ID = p_okl_cntr_lvlng_lns_b_rec.id;
2447:
2448: x_return_status := l_return_status;
2449: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2442: RAISE OKL_API.G_EXCEPTION_ERROR;
2443: END IF;
2444:
2445: DELETE FROM OKL_CNTR_LVLNG_LNS_B
2446: WHERE ID = p_okl_cntr_lvlng_lns_b_rec.id;
2447:
2448: x_return_status := l_return_status;
2449: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2450: EXCEPTION
2493: l_api_version CONSTANT NUMBER := 1;
2494: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
2495: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2496: l_cllv_rec cllv_rec_type := p_cllv_rec;
2497: l_okl_cntr_lvlng_lns_b_rec okl_cntr_lvlng_lns_b_rec_type;
2498: BEGIN
2499: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
2500: G_PKG_NAME,
2501: p_init_msg_list,
2510: END IF;
2511: -----------------------------------------
2512: -- Move VIEW record to "Child" records --
2513: -----------------------------------------
2514: migrate(l_cllv_rec, l_okl_cntr_lvlng_lns_b_rec);
2515: -----------------------------------------------
2516: -- Call the DELETE_ROW for each child record --
2517: -----------------------------------------------
2518: delete_row(
2519: p_init_msg_list,
2520: l_return_status,
2521: x_msg_count,
2522: x_msg_data,
2523: l_okl_cntr_lvlng_lns_b_rec
2524: );
2525: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2526: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2527: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN