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: ---------------------------------------------------------------------------
567: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
568: -- nikshah Modified for bug 6982494 start
569: CURSOR c_counter_csr(cp_clg_id IN NUMBER,cp_counter IN NUMBER,cp_cll_id IN NUMBER) IS
570: SELECT 'Y'
571: FROM OKL_CNTR_LVLNG_LNS_B
572: WHERE clg_id = cp_clg_id
573: AND kle_id = cp_counter
574: AND ID <> cp_cll_id;
575:
579: WHERE okl_cntr_lvlng_grps_b.id = p_id;
580:
581: CURSOR c_conscounter_csr(cp_clg_id IN NUMBER,cp_counter IN NUMBER) IS
582: SELECT b.effective_date_from,b.effective_date_to,b.id,b.name
583: FROM OKL_CNTR_LVLNG_LNS_B a,
584: Okl_Cntr_Lvlng_Grps_v b
585: WHERE a.clg_id = b.id
586: AND b.id <> cp_clg_id
587: AND a.kle_id = cp_counter;
744: -- PROCEDURE Migrate
745: ---------------------------------------------------------------------------
746: PROCEDURE migrate (
747: p_from IN cllv_rec_type,
748: p_to IN OUT NOCOPY okl_cntr_lvlng_lns_b_rec_type
749: ) IS
750: BEGIN
751: p_to.id := p_from.id;
752: p_to.kle_id := p_from.kle_id;
774: p_to.last_update_date := p_from.last_update_date;
775: p_to.last_update_login := p_from.last_update_login;
776: END migrate;
777: PROCEDURE migrate (
778: p_from IN okl_cntr_lvlng_lns_b_rec_type,
779: p_to IN OUT NOCOPY cllv_rec_type
780: ) IS
781: BEGIN
782: p_to.id := p_from.id;
822: l_api_version CONSTANT NUMBER := 1;
823: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
824: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
825: l_cllv_rec cllv_rec_type := p_cllv_rec;
826: l_okl_cntr_lvlng_lns_b_rec okl_cntr_lvlng_lns_b_rec_type;
827: l_okl_cntr_lvlng_lns_b_rec okl_cntr_lvlng_lns_b_rec_type;
828: BEGIN
829: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
830: G_PKG_NAME,
823: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
824: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
825: l_cllv_rec cllv_rec_type := p_cllv_rec;
826: l_okl_cntr_lvlng_lns_b_rec okl_cntr_lvlng_lns_b_rec_type;
827: l_okl_cntr_lvlng_lns_b_rec okl_cntr_lvlng_lns_b_rec_type;
828: BEGIN
829: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
830: G_PKG_NAME,
831: p_init_msg_list,
1046: ---------------------------------------------------------------------------
1047: -- PROCEDURE insert_row
1048: ---------------------------------------------------------------------------
1049: -----------------------------------------
1050: -- insert_row for:OKL_CNTR_LVLNG_LNS_B --
1051: -----------------------------------------
1052: PROCEDURE insert_row(
1053: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1054: x_return_status OUT NOCOPY VARCHAR2,
1053: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1054: x_return_status OUT NOCOPY VARCHAR2,
1055: x_msg_count OUT NOCOPY NUMBER,
1056: x_msg_data OUT NOCOPY VARCHAR2,
1057: p_okl_cntr_lvlng_lns_b_rec IN okl_cntr_lvlng_lns_b_rec_type,
1058: x_okl_cntr_lvlng_lns_b_rec OUT NOCOPY okl_cntr_lvlng_lns_b_rec_type) IS
1059:
1060: l_api_version CONSTANT NUMBER := 1;
1061: l_api_name CONSTANT VARCHAR2(30) := 'B_insert_row';
1054: x_return_status OUT NOCOPY VARCHAR2,
1055: x_msg_count OUT NOCOPY NUMBER,
1056: x_msg_data OUT NOCOPY VARCHAR2,
1057: p_okl_cntr_lvlng_lns_b_rec IN okl_cntr_lvlng_lns_b_rec_type,
1058: x_okl_cntr_lvlng_lns_b_rec OUT NOCOPY okl_cntr_lvlng_lns_b_rec_type) IS
1059:
1060: l_api_version CONSTANT NUMBER := 1;
1061: l_api_name CONSTANT VARCHAR2(30) := 'B_insert_row';
1062: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1059:
1060: l_api_version CONSTANT NUMBER := 1;
1061: l_api_name CONSTANT VARCHAR2(30) := 'B_insert_row';
1062: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1063: l_okl_cntr_lvlng_lns_b_rec okl_cntr_lvlng_lns_b_rec_type := p_okl_cntr_lvlng_lns_b_rec;
1064: l_def_okl_cntr_lvlng_lns_b_rec okl_cntr_lvlng_lns_b_rec_type;
1065: ---------------------------------------------
1066: -- Set_Attributes for:OKL_CNTR_LVLNG_LNS_B --
1067: ---------------------------------------------
1060: l_api_version CONSTANT NUMBER := 1;
1061: l_api_name CONSTANT VARCHAR2(30) := 'B_insert_row';
1062: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1063: l_okl_cntr_lvlng_lns_b_rec okl_cntr_lvlng_lns_b_rec_type := p_okl_cntr_lvlng_lns_b_rec;
1064: l_def_okl_cntr_lvlng_lns_b_rec okl_cntr_lvlng_lns_b_rec_type;
1065: ---------------------------------------------
1066: -- Set_Attributes for:OKL_CNTR_LVLNG_LNS_B --
1067: ---------------------------------------------
1068: FUNCTION Set_Attributes (
1062: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1063: l_okl_cntr_lvlng_lns_b_rec okl_cntr_lvlng_lns_b_rec_type := p_okl_cntr_lvlng_lns_b_rec;
1064: l_def_okl_cntr_lvlng_lns_b_rec okl_cntr_lvlng_lns_b_rec_type;
1065: ---------------------------------------------
1066: -- Set_Attributes for:OKL_CNTR_LVLNG_LNS_B --
1067: ---------------------------------------------
1068: FUNCTION Set_Attributes (
1069: p_okl_cntr_lvlng_lns_b_rec IN okl_cntr_lvlng_lns_b_rec_type,
1070: x_okl_cntr_lvlng_lns_b_rec OUT NOCOPY okl_cntr_lvlng_lns_b_rec_type
1065: ---------------------------------------------
1066: -- Set_Attributes for:OKL_CNTR_LVLNG_LNS_B --
1067: ---------------------------------------------
1068: FUNCTION Set_Attributes (
1069: p_okl_cntr_lvlng_lns_b_rec IN okl_cntr_lvlng_lns_b_rec_type,
1070: x_okl_cntr_lvlng_lns_b_rec OUT NOCOPY okl_cntr_lvlng_lns_b_rec_type
1071: ) RETURN VARCHAR2 IS
1072: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1073: BEGIN
1066: -- Set_Attributes for:OKL_CNTR_LVLNG_LNS_B --
1067: ---------------------------------------------
1068: FUNCTION Set_Attributes (
1069: p_okl_cntr_lvlng_lns_b_rec IN okl_cntr_lvlng_lns_b_rec_type,
1070: x_okl_cntr_lvlng_lns_b_rec OUT NOCOPY okl_cntr_lvlng_lns_b_rec_type
1071: ) RETURN VARCHAR2 IS
1072: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1073: BEGIN
1074: x_okl_cntr_lvlng_lns_b_rec := p_okl_cntr_lvlng_lns_b_rec;
1070: x_okl_cntr_lvlng_lns_b_rec OUT NOCOPY okl_cntr_lvlng_lns_b_rec_type
1071: ) RETURN VARCHAR2 IS
1072: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1073: BEGIN
1074: x_okl_cntr_lvlng_lns_b_rec := p_okl_cntr_lvlng_lns_b_rec;
1075: RETURN(l_return_status);
1076: END Set_Attributes;
1077: BEGIN
1078: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
1085: RAISE OKL_API.G_EXCEPTION_ERROR;
1086: END IF;
1087: --- Setting item atributes
1088: l_return_status := Set_Attributes(
1089: p_okl_cntr_lvlng_lns_b_rec, -- IN
1090: l_okl_cntr_lvlng_lns_b_rec); -- OUT
1091: --- If any errors happen abort API
1092: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1093: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1086: END IF;
1087: --- Setting item atributes
1088: l_return_status := Set_Attributes(
1089: p_okl_cntr_lvlng_lns_b_rec, -- IN
1090: l_okl_cntr_lvlng_lns_b_rec); -- OUT
1091: --- If any errors happen abort API
1092: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1093: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1094: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1093: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1094: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1095: RAISE OKL_API.G_EXCEPTION_ERROR;
1096: END IF;
1097: INSERT INTO OKL_CNTR_LVLNG_LNS_B(
1098: id,
1099: kle_id,
1100: clg_id,
1101: object_version_number,
1120: last_updated_by,
1121: last_update_date,
1122: last_update_login)
1123: VALUES (
1124: l_okl_cntr_lvlng_lns_b_rec.id,
1125: l_okl_cntr_lvlng_lns_b_rec.kle_id,
1126: l_okl_cntr_lvlng_lns_b_rec.clg_id,
1127: l_okl_cntr_lvlng_lns_b_rec.object_version_number,
1128: l_okl_cntr_lvlng_lns_b_rec.attribute_category,
1121: last_update_date,
1122: last_update_login)
1123: VALUES (
1124: l_okl_cntr_lvlng_lns_b_rec.id,
1125: l_okl_cntr_lvlng_lns_b_rec.kle_id,
1126: l_okl_cntr_lvlng_lns_b_rec.clg_id,
1127: l_okl_cntr_lvlng_lns_b_rec.object_version_number,
1128: l_okl_cntr_lvlng_lns_b_rec.attribute_category,
1129: l_okl_cntr_lvlng_lns_b_rec.attribute1,
1122: last_update_login)
1123: VALUES (
1124: l_okl_cntr_lvlng_lns_b_rec.id,
1125: l_okl_cntr_lvlng_lns_b_rec.kle_id,
1126: l_okl_cntr_lvlng_lns_b_rec.clg_id,
1127: l_okl_cntr_lvlng_lns_b_rec.object_version_number,
1128: l_okl_cntr_lvlng_lns_b_rec.attribute_category,
1129: l_okl_cntr_lvlng_lns_b_rec.attribute1,
1130: l_okl_cntr_lvlng_lns_b_rec.attribute2,
1123: VALUES (
1124: l_okl_cntr_lvlng_lns_b_rec.id,
1125: l_okl_cntr_lvlng_lns_b_rec.kle_id,
1126: l_okl_cntr_lvlng_lns_b_rec.clg_id,
1127: l_okl_cntr_lvlng_lns_b_rec.object_version_number,
1128: l_okl_cntr_lvlng_lns_b_rec.attribute_category,
1129: l_okl_cntr_lvlng_lns_b_rec.attribute1,
1130: l_okl_cntr_lvlng_lns_b_rec.attribute2,
1131: l_okl_cntr_lvlng_lns_b_rec.attribute3,
1124: l_okl_cntr_lvlng_lns_b_rec.id,
1125: l_okl_cntr_lvlng_lns_b_rec.kle_id,
1126: l_okl_cntr_lvlng_lns_b_rec.clg_id,
1127: l_okl_cntr_lvlng_lns_b_rec.object_version_number,
1128: l_okl_cntr_lvlng_lns_b_rec.attribute_category,
1129: l_okl_cntr_lvlng_lns_b_rec.attribute1,
1130: l_okl_cntr_lvlng_lns_b_rec.attribute2,
1131: l_okl_cntr_lvlng_lns_b_rec.attribute3,
1132: l_okl_cntr_lvlng_lns_b_rec.attribute4,
1125: l_okl_cntr_lvlng_lns_b_rec.kle_id,
1126: l_okl_cntr_lvlng_lns_b_rec.clg_id,
1127: l_okl_cntr_lvlng_lns_b_rec.object_version_number,
1128: l_okl_cntr_lvlng_lns_b_rec.attribute_category,
1129: l_okl_cntr_lvlng_lns_b_rec.attribute1,
1130: l_okl_cntr_lvlng_lns_b_rec.attribute2,
1131: l_okl_cntr_lvlng_lns_b_rec.attribute3,
1132: l_okl_cntr_lvlng_lns_b_rec.attribute4,
1133: l_okl_cntr_lvlng_lns_b_rec.attribute5,
1126: l_okl_cntr_lvlng_lns_b_rec.clg_id,
1127: l_okl_cntr_lvlng_lns_b_rec.object_version_number,
1128: l_okl_cntr_lvlng_lns_b_rec.attribute_category,
1129: l_okl_cntr_lvlng_lns_b_rec.attribute1,
1130: l_okl_cntr_lvlng_lns_b_rec.attribute2,
1131: l_okl_cntr_lvlng_lns_b_rec.attribute3,
1132: l_okl_cntr_lvlng_lns_b_rec.attribute4,
1133: l_okl_cntr_lvlng_lns_b_rec.attribute5,
1134: l_okl_cntr_lvlng_lns_b_rec.attribute6,
1127: l_okl_cntr_lvlng_lns_b_rec.object_version_number,
1128: l_okl_cntr_lvlng_lns_b_rec.attribute_category,
1129: l_okl_cntr_lvlng_lns_b_rec.attribute1,
1130: l_okl_cntr_lvlng_lns_b_rec.attribute2,
1131: l_okl_cntr_lvlng_lns_b_rec.attribute3,
1132: l_okl_cntr_lvlng_lns_b_rec.attribute4,
1133: l_okl_cntr_lvlng_lns_b_rec.attribute5,
1134: l_okl_cntr_lvlng_lns_b_rec.attribute6,
1135: l_okl_cntr_lvlng_lns_b_rec.attribute7,
1128: l_okl_cntr_lvlng_lns_b_rec.attribute_category,
1129: l_okl_cntr_lvlng_lns_b_rec.attribute1,
1130: l_okl_cntr_lvlng_lns_b_rec.attribute2,
1131: l_okl_cntr_lvlng_lns_b_rec.attribute3,
1132: l_okl_cntr_lvlng_lns_b_rec.attribute4,
1133: l_okl_cntr_lvlng_lns_b_rec.attribute5,
1134: l_okl_cntr_lvlng_lns_b_rec.attribute6,
1135: l_okl_cntr_lvlng_lns_b_rec.attribute7,
1136: l_okl_cntr_lvlng_lns_b_rec.attribute8,
1129: l_okl_cntr_lvlng_lns_b_rec.attribute1,
1130: l_okl_cntr_lvlng_lns_b_rec.attribute2,
1131: l_okl_cntr_lvlng_lns_b_rec.attribute3,
1132: l_okl_cntr_lvlng_lns_b_rec.attribute4,
1133: l_okl_cntr_lvlng_lns_b_rec.attribute5,
1134: l_okl_cntr_lvlng_lns_b_rec.attribute6,
1135: l_okl_cntr_lvlng_lns_b_rec.attribute7,
1136: l_okl_cntr_lvlng_lns_b_rec.attribute8,
1137: l_okl_cntr_lvlng_lns_b_rec.attribute9,
1130: l_okl_cntr_lvlng_lns_b_rec.attribute2,
1131: l_okl_cntr_lvlng_lns_b_rec.attribute3,
1132: l_okl_cntr_lvlng_lns_b_rec.attribute4,
1133: l_okl_cntr_lvlng_lns_b_rec.attribute5,
1134: l_okl_cntr_lvlng_lns_b_rec.attribute6,
1135: l_okl_cntr_lvlng_lns_b_rec.attribute7,
1136: l_okl_cntr_lvlng_lns_b_rec.attribute8,
1137: l_okl_cntr_lvlng_lns_b_rec.attribute9,
1138: l_okl_cntr_lvlng_lns_b_rec.attribute10,
1131: l_okl_cntr_lvlng_lns_b_rec.attribute3,
1132: l_okl_cntr_lvlng_lns_b_rec.attribute4,
1133: l_okl_cntr_lvlng_lns_b_rec.attribute5,
1134: l_okl_cntr_lvlng_lns_b_rec.attribute6,
1135: l_okl_cntr_lvlng_lns_b_rec.attribute7,
1136: l_okl_cntr_lvlng_lns_b_rec.attribute8,
1137: l_okl_cntr_lvlng_lns_b_rec.attribute9,
1138: l_okl_cntr_lvlng_lns_b_rec.attribute10,
1139: l_okl_cntr_lvlng_lns_b_rec.attribute11,
1132: l_okl_cntr_lvlng_lns_b_rec.attribute4,
1133: l_okl_cntr_lvlng_lns_b_rec.attribute5,
1134: l_okl_cntr_lvlng_lns_b_rec.attribute6,
1135: l_okl_cntr_lvlng_lns_b_rec.attribute7,
1136: l_okl_cntr_lvlng_lns_b_rec.attribute8,
1137: l_okl_cntr_lvlng_lns_b_rec.attribute9,
1138: l_okl_cntr_lvlng_lns_b_rec.attribute10,
1139: l_okl_cntr_lvlng_lns_b_rec.attribute11,
1140: l_okl_cntr_lvlng_lns_b_rec.attribute12,
1133: l_okl_cntr_lvlng_lns_b_rec.attribute5,
1134: l_okl_cntr_lvlng_lns_b_rec.attribute6,
1135: l_okl_cntr_lvlng_lns_b_rec.attribute7,
1136: l_okl_cntr_lvlng_lns_b_rec.attribute8,
1137: l_okl_cntr_lvlng_lns_b_rec.attribute9,
1138: l_okl_cntr_lvlng_lns_b_rec.attribute10,
1139: l_okl_cntr_lvlng_lns_b_rec.attribute11,
1140: l_okl_cntr_lvlng_lns_b_rec.attribute12,
1141: l_okl_cntr_lvlng_lns_b_rec.attribute13,
1134: l_okl_cntr_lvlng_lns_b_rec.attribute6,
1135: l_okl_cntr_lvlng_lns_b_rec.attribute7,
1136: l_okl_cntr_lvlng_lns_b_rec.attribute8,
1137: l_okl_cntr_lvlng_lns_b_rec.attribute9,
1138: l_okl_cntr_lvlng_lns_b_rec.attribute10,
1139: l_okl_cntr_lvlng_lns_b_rec.attribute11,
1140: l_okl_cntr_lvlng_lns_b_rec.attribute12,
1141: l_okl_cntr_lvlng_lns_b_rec.attribute13,
1142: l_okl_cntr_lvlng_lns_b_rec.attribute14,
1135: l_okl_cntr_lvlng_lns_b_rec.attribute7,
1136: l_okl_cntr_lvlng_lns_b_rec.attribute8,
1137: l_okl_cntr_lvlng_lns_b_rec.attribute9,
1138: l_okl_cntr_lvlng_lns_b_rec.attribute10,
1139: l_okl_cntr_lvlng_lns_b_rec.attribute11,
1140: l_okl_cntr_lvlng_lns_b_rec.attribute12,
1141: l_okl_cntr_lvlng_lns_b_rec.attribute13,
1142: l_okl_cntr_lvlng_lns_b_rec.attribute14,
1143: l_okl_cntr_lvlng_lns_b_rec.attribute15,
1136: l_okl_cntr_lvlng_lns_b_rec.attribute8,
1137: l_okl_cntr_lvlng_lns_b_rec.attribute9,
1138: l_okl_cntr_lvlng_lns_b_rec.attribute10,
1139: l_okl_cntr_lvlng_lns_b_rec.attribute11,
1140: l_okl_cntr_lvlng_lns_b_rec.attribute12,
1141: l_okl_cntr_lvlng_lns_b_rec.attribute13,
1142: l_okl_cntr_lvlng_lns_b_rec.attribute14,
1143: l_okl_cntr_lvlng_lns_b_rec.attribute15,
1144: l_okl_cntr_lvlng_lns_b_rec.created_by,
1137: l_okl_cntr_lvlng_lns_b_rec.attribute9,
1138: l_okl_cntr_lvlng_lns_b_rec.attribute10,
1139: l_okl_cntr_lvlng_lns_b_rec.attribute11,
1140: l_okl_cntr_lvlng_lns_b_rec.attribute12,
1141: l_okl_cntr_lvlng_lns_b_rec.attribute13,
1142: l_okl_cntr_lvlng_lns_b_rec.attribute14,
1143: l_okl_cntr_lvlng_lns_b_rec.attribute15,
1144: l_okl_cntr_lvlng_lns_b_rec.created_by,
1145: l_okl_cntr_lvlng_lns_b_rec.creation_date,
1138: l_okl_cntr_lvlng_lns_b_rec.attribute10,
1139: l_okl_cntr_lvlng_lns_b_rec.attribute11,
1140: l_okl_cntr_lvlng_lns_b_rec.attribute12,
1141: l_okl_cntr_lvlng_lns_b_rec.attribute13,
1142: l_okl_cntr_lvlng_lns_b_rec.attribute14,
1143: l_okl_cntr_lvlng_lns_b_rec.attribute15,
1144: l_okl_cntr_lvlng_lns_b_rec.created_by,
1145: l_okl_cntr_lvlng_lns_b_rec.creation_date,
1146: l_okl_cntr_lvlng_lns_b_rec.last_updated_by,
1139: l_okl_cntr_lvlng_lns_b_rec.attribute11,
1140: l_okl_cntr_lvlng_lns_b_rec.attribute12,
1141: l_okl_cntr_lvlng_lns_b_rec.attribute13,
1142: l_okl_cntr_lvlng_lns_b_rec.attribute14,
1143: l_okl_cntr_lvlng_lns_b_rec.attribute15,
1144: l_okl_cntr_lvlng_lns_b_rec.created_by,
1145: l_okl_cntr_lvlng_lns_b_rec.creation_date,
1146: l_okl_cntr_lvlng_lns_b_rec.last_updated_by,
1147: l_okl_cntr_lvlng_lns_b_rec.last_update_date,
1140: l_okl_cntr_lvlng_lns_b_rec.attribute12,
1141: l_okl_cntr_lvlng_lns_b_rec.attribute13,
1142: l_okl_cntr_lvlng_lns_b_rec.attribute14,
1143: l_okl_cntr_lvlng_lns_b_rec.attribute15,
1144: l_okl_cntr_lvlng_lns_b_rec.created_by,
1145: l_okl_cntr_lvlng_lns_b_rec.creation_date,
1146: l_okl_cntr_lvlng_lns_b_rec.last_updated_by,
1147: l_okl_cntr_lvlng_lns_b_rec.last_update_date,
1148: l_okl_cntr_lvlng_lns_b_rec.last_update_login);
1141: l_okl_cntr_lvlng_lns_b_rec.attribute13,
1142: l_okl_cntr_lvlng_lns_b_rec.attribute14,
1143: l_okl_cntr_lvlng_lns_b_rec.attribute15,
1144: l_okl_cntr_lvlng_lns_b_rec.created_by,
1145: l_okl_cntr_lvlng_lns_b_rec.creation_date,
1146: l_okl_cntr_lvlng_lns_b_rec.last_updated_by,
1147: l_okl_cntr_lvlng_lns_b_rec.last_update_date,
1148: l_okl_cntr_lvlng_lns_b_rec.last_update_login);
1149: -- Set OUT values
1142: l_okl_cntr_lvlng_lns_b_rec.attribute14,
1143: l_okl_cntr_lvlng_lns_b_rec.attribute15,
1144: l_okl_cntr_lvlng_lns_b_rec.created_by,
1145: l_okl_cntr_lvlng_lns_b_rec.creation_date,
1146: l_okl_cntr_lvlng_lns_b_rec.last_updated_by,
1147: l_okl_cntr_lvlng_lns_b_rec.last_update_date,
1148: l_okl_cntr_lvlng_lns_b_rec.last_update_login);
1149: -- Set OUT values
1150: x_okl_cntr_lvlng_lns_b_rec := l_okl_cntr_lvlng_lns_b_rec;
1143: l_okl_cntr_lvlng_lns_b_rec.attribute15,
1144: l_okl_cntr_lvlng_lns_b_rec.created_by,
1145: l_okl_cntr_lvlng_lns_b_rec.creation_date,
1146: l_okl_cntr_lvlng_lns_b_rec.last_updated_by,
1147: l_okl_cntr_lvlng_lns_b_rec.last_update_date,
1148: l_okl_cntr_lvlng_lns_b_rec.last_update_login);
1149: -- Set OUT values
1150: x_okl_cntr_lvlng_lns_b_rec := l_okl_cntr_lvlng_lns_b_rec;
1151: x_return_status := l_return_status;
1144: l_okl_cntr_lvlng_lns_b_rec.created_by,
1145: l_okl_cntr_lvlng_lns_b_rec.creation_date,
1146: l_okl_cntr_lvlng_lns_b_rec.last_updated_by,
1147: l_okl_cntr_lvlng_lns_b_rec.last_update_date,
1148: l_okl_cntr_lvlng_lns_b_rec.last_update_login);
1149: -- Set OUT values
1150: x_okl_cntr_lvlng_lns_b_rec := l_okl_cntr_lvlng_lns_b_rec;
1151: x_return_status := l_return_status;
1152: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1146: l_okl_cntr_lvlng_lns_b_rec.last_updated_by,
1147: l_okl_cntr_lvlng_lns_b_rec.last_update_date,
1148: l_okl_cntr_lvlng_lns_b_rec.last_update_login);
1149: -- Set OUT values
1150: x_okl_cntr_lvlng_lns_b_rec := l_okl_cntr_lvlng_lns_b_rec;
1151: x_return_status := l_return_status;
1152: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1153: EXCEPTION
1154: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1198: l_api_name CONSTANT VARCHAR2(30) := 'V_insert_row';
1199: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1200: l_cllv_rec cllv_rec_type := p_cllv_rec;
1201: l_def_cllv_rec cllv_rec_type;
1202: l_okl_cntr_lvlng_lns_b_rec okl_cntr_lvlng_lns_b_rec_type;
1203: lx_okl_cntr_lvlng_lns_b_rec okl_cntr_lvlng_lns_b_rec_type;
1204: -------------------------------
1205: -- FUNCTION fill_who_columns --
1206: -------------------------------
1199: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1200: l_cllv_rec cllv_rec_type := p_cllv_rec;
1201: l_def_cllv_rec cllv_rec_type;
1202: l_okl_cntr_lvlng_lns_b_rec okl_cntr_lvlng_lns_b_rec_type;
1203: lx_okl_cntr_lvlng_lns_b_rec okl_cntr_lvlng_lns_b_rec_type;
1204: -------------------------------
1205: -- FUNCTION fill_who_columns --
1206: -------------------------------
1207: FUNCTION fill_who_columns (
1272: END IF;
1273: -----------------------------------------
1274: -- Move VIEW record to "Child" records --
1275: -----------------------------------------
1276: migrate(l_def_cllv_rec, l_okl_cntr_lvlng_lns_b_rec);
1277: -----------------------------------------------
1278: -- Call the INSERT_ROW for each child record --
1279: -----------------------------------------------
1280: insert_row(
1281: p_init_msg_list,
1282: l_return_status,
1283: x_msg_count,
1284: x_msg_data,
1285: l_okl_cntr_lvlng_lns_b_rec,
1286: lx_okl_cntr_lvlng_lns_b_rec
1287: );
1288: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1289: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1282: l_return_status,
1283: x_msg_count,
1284: x_msg_data,
1285: l_okl_cntr_lvlng_lns_b_rec,
1286: lx_okl_cntr_lvlng_lns_b_rec
1287: );
1288: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1289: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1290: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1289: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1290: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1291: RAISE OKL_API.G_EXCEPTION_ERROR;
1292: END IF;
1293: migrate(lx_okl_cntr_lvlng_lns_b_rec, l_def_cllv_rec);
1294: -- Set OUT values
1295: x_cllv_rec := l_def_cllv_rec;
1296: x_return_status := l_return_status;
1297: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1492: ---------------------------------------------------------------------------
1493: -- PROCEDURE lock_row
1494: ---------------------------------------------------------------------------
1495: ---------------------------------------
1496: -- lock_row for:OKL_CNTR_LVLNG_LNS_B --
1497: ---------------------------------------
1498: PROCEDURE lock_row(
1499: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1500: x_return_status OUT NOCOPY VARCHAR2,
1499: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1500: x_return_status OUT NOCOPY VARCHAR2,
1501: x_msg_count OUT NOCOPY NUMBER,
1502: x_msg_data OUT NOCOPY VARCHAR2,
1503: p_okl_cntr_lvlng_lns_b_rec IN okl_cntr_lvlng_lns_b_rec_type) IS
1504:
1505: E_Resource_Busy EXCEPTION;
1506: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1507: CURSOR lock_csr (p_okl_cntr_lvlng_lns_b_rec IN okl_cntr_lvlng_lns_b_rec_type) IS
1503: p_okl_cntr_lvlng_lns_b_rec IN okl_cntr_lvlng_lns_b_rec_type) IS
1504:
1505: E_Resource_Busy EXCEPTION;
1506: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1507: CURSOR lock_csr (p_okl_cntr_lvlng_lns_b_rec IN okl_cntr_lvlng_lns_b_rec_type) IS
1508: SELECT OBJECT_VERSION_NUMBER
1509: FROM OKL_CNTR_LVLNG_LNS_B
1510: WHERE ID = p_okl_cntr_lvlng_lns_b_rec.id
1511: AND OBJECT_VERSION_NUMBER = p_okl_cntr_lvlng_lns_b_rec.object_version_number
1505: E_Resource_Busy EXCEPTION;
1506: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1507: CURSOR lock_csr (p_okl_cntr_lvlng_lns_b_rec IN okl_cntr_lvlng_lns_b_rec_type) IS
1508: SELECT OBJECT_VERSION_NUMBER
1509: FROM OKL_CNTR_LVLNG_LNS_B
1510: WHERE ID = p_okl_cntr_lvlng_lns_b_rec.id
1511: AND OBJECT_VERSION_NUMBER = p_okl_cntr_lvlng_lns_b_rec.object_version_number
1512: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1513:
1506: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1507: CURSOR lock_csr (p_okl_cntr_lvlng_lns_b_rec IN okl_cntr_lvlng_lns_b_rec_type) IS
1508: SELECT OBJECT_VERSION_NUMBER
1509: FROM OKL_CNTR_LVLNG_LNS_B
1510: WHERE ID = p_okl_cntr_lvlng_lns_b_rec.id
1511: AND OBJECT_VERSION_NUMBER = p_okl_cntr_lvlng_lns_b_rec.object_version_number
1512: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1513:
1514: CURSOR lchk_csr (p_okl_cntr_lvlng_lns_b_rec IN okl_cntr_lvlng_lns_b_rec_type) IS
1507: CURSOR lock_csr (p_okl_cntr_lvlng_lns_b_rec IN okl_cntr_lvlng_lns_b_rec_type) IS
1508: SELECT OBJECT_VERSION_NUMBER
1509: FROM OKL_CNTR_LVLNG_LNS_B
1510: WHERE ID = p_okl_cntr_lvlng_lns_b_rec.id
1511: AND OBJECT_VERSION_NUMBER = p_okl_cntr_lvlng_lns_b_rec.object_version_number
1512: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1513:
1514: CURSOR lchk_csr (p_okl_cntr_lvlng_lns_b_rec IN okl_cntr_lvlng_lns_b_rec_type) IS
1515: SELECT OBJECT_VERSION_NUMBER
1510: WHERE ID = p_okl_cntr_lvlng_lns_b_rec.id
1511: AND OBJECT_VERSION_NUMBER = p_okl_cntr_lvlng_lns_b_rec.object_version_number
1512: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1513:
1514: CURSOR lchk_csr (p_okl_cntr_lvlng_lns_b_rec IN okl_cntr_lvlng_lns_b_rec_type) IS
1515: SELECT OBJECT_VERSION_NUMBER
1516: FROM OKL_CNTR_LVLNG_LNS_B
1517: WHERE ID = p_okl_cntr_lvlng_lns_b_rec.id;
1518: l_api_version CONSTANT NUMBER := 1;
1512: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1513:
1514: CURSOR lchk_csr (p_okl_cntr_lvlng_lns_b_rec IN okl_cntr_lvlng_lns_b_rec_type) IS
1515: SELECT OBJECT_VERSION_NUMBER
1516: FROM OKL_CNTR_LVLNG_LNS_B
1517: WHERE ID = p_okl_cntr_lvlng_lns_b_rec.id;
1518: l_api_version CONSTANT NUMBER := 1;
1519: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1520: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1513:
1514: CURSOR lchk_csr (p_okl_cntr_lvlng_lns_b_rec IN okl_cntr_lvlng_lns_b_rec_type) IS
1515: SELECT OBJECT_VERSION_NUMBER
1516: FROM OKL_CNTR_LVLNG_LNS_B
1517: WHERE ID = p_okl_cntr_lvlng_lns_b_rec.id;
1518: l_api_version CONSTANT NUMBER := 1;
1519: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1520: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1521: l_object_version_number OKL_CNTR_LVLNG_LNS_B.OBJECT_VERSION_NUMBER%TYPE;
1517: WHERE ID = p_okl_cntr_lvlng_lns_b_rec.id;
1518: l_api_version CONSTANT NUMBER := 1;
1519: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1520: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1521: l_object_version_number OKL_CNTR_LVLNG_LNS_B.OBJECT_VERSION_NUMBER%TYPE;
1522: lc_object_version_number OKL_CNTR_LVLNG_LNS_B.OBJECT_VERSION_NUMBER%TYPE;
1523: l_row_notfound BOOLEAN := FALSE;
1524: lc_row_notfound BOOLEAN := FALSE;
1525: BEGIN
1518: l_api_version CONSTANT NUMBER := 1;
1519: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1520: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1521: l_object_version_number OKL_CNTR_LVLNG_LNS_B.OBJECT_VERSION_NUMBER%TYPE;
1522: lc_object_version_number OKL_CNTR_LVLNG_LNS_B.OBJECT_VERSION_NUMBER%TYPE;
1523: l_row_notfound BOOLEAN := FALSE;
1524: lc_row_notfound BOOLEAN := FALSE;
1525: BEGIN
1526: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
1532: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1533: RAISE OKL_API.G_EXCEPTION_ERROR;
1534: END IF;
1535: BEGIN
1536: OPEN lock_csr(p_okl_cntr_lvlng_lns_b_rec);
1537: FETCH lock_csr INTO l_object_version_number;
1538: l_row_notfound := lock_csr%NOTFOUND;
1539: CLOSE lock_csr;
1540: EXCEPTION
1546: RAISE APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION;
1547: END;
1548:
1549: IF ( l_row_notfound ) THEN
1550: OPEN lchk_csr(p_okl_cntr_lvlng_lns_b_rec);
1551: FETCH lchk_csr INTO lc_object_version_number;
1552: lc_row_notfound := lchk_csr%NOTFOUND;
1553: CLOSE lchk_csr;
1554: END IF;
1554: END IF;
1555: IF (lc_row_notfound) THEN
1556: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1557: RAISE OKL_API.G_EXCEPTION_ERROR;
1558: ELSIF lc_object_version_number > p_okl_cntr_lvlng_lns_b_rec.object_version_number THEN
1559: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1560: RAISE OKL_API.G_EXCEPTION_ERROR;
1561: ELSIF lc_object_version_number <> p_okl_cntr_lvlng_lns_b_rec.object_version_number THEN
1562: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1557: RAISE OKL_API.G_EXCEPTION_ERROR;
1558: ELSIF lc_object_version_number > p_okl_cntr_lvlng_lns_b_rec.object_version_number THEN
1559: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1560: RAISE OKL_API.G_EXCEPTION_ERROR;
1561: ELSIF lc_object_version_number <> p_okl_cntr_lvlng_lns_b_rec.object_version_number THEN
1562: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1563: RAISE OKL_API.G_EXCEPTION_ERROR;
1564: ELSIF lc_object_version_number = -1 THEN
1565: OKL_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1612:
1613: l_api_version CONSTANT NUMBER := 1;
1614: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
1615: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1616: l_okl_cntr_lvlng_lns_b_rec okl_cntr_lvlng_lns_b_rec_type;
1617: BEGIN
1618: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
1619: G_PKG_NAME,
1620: p_init_msg_list,
1629: END IF;
1630: -----------------------------------------
1631: -- Move VIEW record to "Child" records --
1632: -----------------------------------------
1633: migrate(p_cllv_rec, l_okl_cntr_lvlng_lns_b_rec);
1634: ---------------------------------------------
1635: -- Call the LOCK_ROW for each child record --
1636: ---------------------------------------------
1637: lock_row(
1638: p_init_msg_list,
1639: l_return_status,
1640: x_msg_count,
1641: x_msg_data,
1642: l_okl_cntr_lvlng_lns_b_rec
1643: );
1644: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1645: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1646: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1839: ---------------------------------------------------------------------------
1840: -- PROCEDURE update_row
1841: ---------------------------------------------------------------------------
1842: -----------------------------------------
1843: -- update_row for:OKL_CNTR_LVLNG_LNS_B --
1844: -----------------------------------------
1845: PROCEDURE update_row(
1846: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1847: x_return_status OUT NOCOPY VARCHAR2,
1846: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1847: x_return_status OUT NOCOPY VARCHAR2,
1848: x_msg_count OUT NOCOPY NUMBER,
1849: x_msg_data OUT NOCOPY VARCHAR2,
1850: p_okl_cntr_lvlng_lns_b_rec IN okl_cntr_lvlng_lns_b_rec_type,
1851: x_okl_cntr_lvlng_lns_b_rec OUT NOCOPY okl_cntr_lvlng_lns_b_rec_type) IS
1852:
1853: l_api_version CONSTANT NUMBER := 1;
1854: l_api_name CONSTANT VARCHAR2(30) := 'B_update_row';
1847: x_return_status OUT NOCOPY VARCHAR2,
1848: x_msg_count OUT NOCOPY NUMBER,
1849: x_msg_data OUT NOCOPY VARCHAR2,
1850: p_okl_cntr_lvlng_lns_b_rec IN okl_cntr_lvlng_lns_b_rec_type,
1851: x_okl_cntr_lvlng_lns_b_rec OUT NOCOPY okl_cntr_lvlng_lns_b_rec_type) IS
1852:
1853: l_api_version CONSTANT NUMBER := 1;
1854: l_api_name CONSTANT VARCHAR2(30) := 'B_update_row';
1855: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1852:
1853: l_api_version CONSTANT NUMBER := 1;
1854: l_api_name CONSTANT VARCHAR2(30) := 'B_update_row';
1855: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1856: l_okl_cntr_lvlng_lns_b_rec okl_cntr_lvlng_lns_b_rec_type := p_okl_cntr_lvlng_lns_b_rec;
1857: l_def_okl_cntr_lvlng_lns_b_rec okl_cntr_lvlng_lns_b_rec_type;
1858: l_row_notfound BOOLEAN := TRUE;
1859: ----------------------------------
1860: -- FUNCTION populate_new_record --
1853: l_api_version CONSTANT NUMBER := 1;
1854: l_api_name CONSTANT VARCHAR2(30) := 'B_update_row';
1855: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1856: l_okl_cntr_lvlng_lns_b_rec okl_cntr_lvlng_lns_b_rec_type := p_okl_cntr_lvlng_lns_b_rec;
1857: l_def_okl_cntr_lvlng_lns_b_rec okl_cntr_lvlng_lns_b_rec_type;
1858: l_row_notfound BOOLEAN := TRUE;
1859: ----------------------------------
1860: -- FUNCTION populate_new_record --
1861: ----------------------------------
1859: ----------------------------------
1860: -- FUNCTION populate_new_record --
1861: ----------------------------------
1862: FUNCTION populate_new_record (
1863: p_okl_cntr_lvlng_lns_b_rec IN okl_cntr_lvlng_lns_b_rec_type,
1864: x_okl_cntr_lvlng_lns_b_rec OUT NOCOPY okl_cntr_lvlng_lns_b_rec_type
1865: ) RETURN VARCHAR2 IS
1866: l_okl_cntr_lvlng_lns_b_rec okl_cntr_lvlng_lns_b_rec_type;
1867: l_row_notfound BOOLEAN := TRUE;
1860: -- FUNCTION populate_new_record --
1861: ----------------------------------
1862: FUNCTION populate_new_record (
1863: p_okl_cntr_lvlng_lns_b_rec IN okl_cntr_lvlng_lns_b_rec_type,
1864: x_okl_cntr_lvlng_lns_b_rec OUT NOCOPY okl_cntr_lvlng_lns_b_rec_type
1865: ) RETURN VARCHAR2 IS
1866: l_okl_cntr_lvlng_lns_b_rec okl_cntr_lvlng_lns_b_rec_type;
1867: l_row_notfound BOOLEAN := TRUE;
1868: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1862: FUNCTION populate_new_record (
1863: p_okl_cntr_lvlng_lns_b_rec IN okl_cntr_lvlng_lns_b_rec_type,
1864: x_okl_cntr_lvlng_lns_b_rec OUT NOCOPY okl_cntr_lvlng_lns_b_rec_type
1865: ) RETURN VARCHAR2 IS
1866: l_okl_cntr_lvlng_lns_b_rec okl_cntr_lvlng_lns_b_rec_type;
1867: l_row_notfound BOOLEAN := TRUE;
1868: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1869: BEGIN
1870: x_okl_cntr_lvlng_lns_b_rec := p_okl_cntr_lvlng_lns_b_rec;
1866: l_okl_cntr_lvlng_lns_b_rec okl_cntr_lvlng_lns_b_rec_type;
1867: l_row_notfound BOOLEAN := TRUE;
1868: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1869: BEGIN
1870: x_okl_cntr_lvlng_lns_b_rec := p_okl_cntr_lvlng_lns_b_rec;
1871: -- Get current database values
1872: l_okl_cntr_lvlng_lns_b_rec := get_rec(p_okl_cntr_lvlng_lns_b_rec, l_return_status);
1873: IF (l_return_status = OKL_API.G_RET_STS_SUCCESS) THEN
1874: IF (x_okl_cntr_lvlng_lns_b_rec.id = OKL_API.G_MISS_NUM)
1868: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1869: BEGIN
1870: x_okl_cntr_lvlng_lns_b_rec := p_okl_cntr_lvlng_lns_b_rec;
1871: -- Get current database values
1872: l_okl_cntr_lvlng_lns_b_rec := get_rec(p_okl_cntr_lvlng_lns_b_rec, l_return_status);
1873: IF (l_return_status = OKL_API.G_RET_STS_SUCCESS) THEN
1874: IF (x_okl_cntr_lvlng_lns_b_rec.id = OKL_API.G_MISS_NUM)
1875: THEN
1876: x_okl_cntr_lvlng_lns_b_rec.id := l_okl_cntr_lvlng_lns_b_rec.id;
1870: x_okl_cntr_lvlng_lns_b_rec := p_okl_cntr_lvlng_lns_b_rec;
1871: -- Get current database values
1872: l_okl_cntr_lvlng_lns_b_rec := get_rec(p_okl_cntr_lvlng_lns_b_rec, l_return_status);
1873: IF (l_return_status = OKL_API.G_RET_STS_SUCCESS) THEN
1874: IF (x_okl_cntr_lvlng_lns_b_rec.id = OKL_API.G_MISS_NUM)
1875: THEN
1876: x_okl_cntr_lvlng_lns_b_rec.id := l_okl_cntr_lvlng_lns_b_rec.id;
1877: END IF;
1878: IF (x_okl_cntr_lvlng_lns_b_rec.kle_id = OKL_API.G_MISS_NUM)
1872: l_okl_cntr_lvlng_lns_b_rec := get_rec(p_okl_cntr_lvlng_lns_b_rec, l_return_status);
1873: IF (l_return_status = OKL_API.G_RET_STS_SUCCESS) THEN
1874: IF (x_okl_cntr_lvlng_lns_b_rec.id = OKL_API.G_MISS_NUM)
1875: THEN
1876: x_okl_cntr_lvlng_lns_b_rec.id := l_okl_cntr_lvlng_lns_b_rec.id;
1877: END IF;
1878: IF (x_okl_cntr_lvlng_lns_b_rec.kle_id = OKL_API.G_MISS_NUM)
1879: THEN
1880: x_okl_cntr_lvlng_lns_b_rec.kle_id := l_okl_cntr_lvlng_lns_b_rec.kle_id;
1874: IF (x_okl_cntr_lvlng_lns_b_rec.id = OKL_API.G_MISS_NUM)
1875: THEN
1876: x_okl_cntr_lvlng_lns_b_rec.id := l_okl_cntr_lvlng_lns_b_rec.id;
1877: END IF;
1878: IF (x_okl_cntr_lvlng_lns_b_rec.kle_id = OKL_API.G_MISS_NUM)
1879: THEN
1880: x_okl_cntr_lvlng_lns_b_rec.kle_id := l_okl_cntr_lvlng_lns_b_rec.kle_id;
1881: END IF;
1882: IF (x_okl_cntr_lvlng_lns_b_rec.clg_id = OKL_API.G_MISS_NUM)
1876: x_okl_cntr_lvlng_lns_b_rec.id := l_okl_cntr_lvlng_lns_b_rec.id;
1877: END IF;
1878: IF (x_okl_cntr_lvlng_lns_b_rec.kle_id = OKL_API.G_MISS_NUM)
1879: THEN
1880: x_okl_cntr_lvlng_lns_b_rec.kle_id := l_okl_cntr_lvlng_lns_b_rec.kle_id;
1881: END IF;
1882: IF (x_okl_cntr_lvlng_lns_b_rec.clg_id = OKL_API.G_MISS_NUM)
1883: THEN
1884: x_okl_cntr_lvlng_lns_b_rec.clg_id := l_okl_cntr_lvlng_lns_b_rec.clg_id;
1878: IF (x_okl_cntr_lvlng_lns_b_rec.kle_id = OKL_API.G_MISS_NUM)
1879: THEN
1880: x_okl_cntr_lvlng_lns_b_rec.kle_id := l_okl_cntr_lvlng_lns_b_rec.kle_id;
1881: END IF;
1882: IF (x_okl_cntr_lvlng_lns_b_rec.clg_id = OKL_API.G_MISS_NUM)
1883: THEN
1884: x_okl_cntr_lvlng_lns_b_rec.clg_id := l_okl_cntr_lvlng_lns_b_rec.clg_id;
1885: END IF;
1886: IF (x_okl_cntr_lvlng_lns_b_rec.object_version_number = OKL_API.G_MISS_NUM)
1880: x_okl_cntr_lvlng_lns_b_rec.kle_id := l_okl_cntr_lvlng_lns_b_rec.kle_id;
1881: END IF;
1882: IF (x_okl_cntr_lvlng_lns_b_rec.clg_id = OKL_API.G_MISS_NUM)
1883: THEN
1884: x_okl_cntr_lvlng_lns_b_rec.clg_id := l_okl_cntr_lvlng_lns_b_rec.clg_id;
1885: END IF;
1886: IF (x_okl_cntr_lvlng_lns_b_rec.object_version_number = OKL_API.G_MISS_NUM)
1887: THEN
1888: x_okl_cntr_lvlng_lns_b_rec.object_version_number := l_okl_cntr_lvlng_lns_b_rec.object_version_number;
1882: IF (x_okl_cntr_lvlng_lns_b_rec.clg_id = OKL_API.G_MISS_NUM)
1883: THEN
1884: x_okl_cntr_lvlng_lns_b_rec.clg_id := l_okl_cntr_lvlng_lns_b_rec.clg_id;
1885: END IF;
1886: IF (x_okl_cntr_lvlng_lns_b_rec.object_version_number = OKL_API.G_MISS_NUM)
1887: THEN
1888: x_okl_cntr_lvlng_lns_b_rec.object_version_number := l_okl_cntr_lvlng_lns_b_rec.object_version_number;
1889: END IF;
1890: IF (x_okl_cntr_lvlng_lns_b_rec.attribute_category = OKL_API.G_MISS_CHAR)
1884: x_okl_cntr_lvlng_lns_b_rec.clg_id := l_okl_cntr_lvlng_lns_b_rec.clg_id;
1885: END IF;
1886: IF (x_okl_cntr_lvlng_lns_b_rec.object_version_number = OKL_API.G_MISS_NUM)
1887: THEN
1888: x_okl_cntr_lvlng_lns_b_rec.object_version_number := l_okl_cntr_lvlng_lns_b_rec.object_version_number;
1889: END IF;
1890: IF (x_okl_cntr_lvlng_lns_b_rec.attribute_category = OKL_API.G_MISS_CHAR)
1891: THEN
1892: x_okl_cntr_lvlng_lns_b_rec.attribute_category := l_okl_cntr_lvlng_lns_b_rec.attribute_category;
1886: IF (x_okl_cntr_lvlng_lns_b_rec.object_version_number = OKL_API.G_MISS_NUM)
1887: THEN
1888: x_okl_cntr_lvlng_lns_b_rec.object_version_number := l_okl_cntr_lvlng_lns_b_rec.object_version_number;
1889: END IF;
1890: IF (x_okl_cntr_lvlng_lns_b_rec.attribute_category = OKL_API.G_MISS_CHAR)
1891: THEN
1892: x_okl_cntr_lvlng_lns_b_rec.attribute_category := l_okl_cntr_lvlng_lns_b_rec.attribute_category;
1893: END IF;
1894: IF (x_okl_cntr_lvlng_lns_b_rec.attribute1 = OKL_API.G_MISS_CHAR)
1888: x_okl_cntr_lvlng_lns_b_rec.object_version_number := l_okl_cntr_lvlng_lns_b_rec.object_version_number;
1889: END IF;
1890: IF (x_okl_cntr_lvlng_lns_b_rec.attribute_category = OKL_API.G_MISS_CHAR)
1891: THEN
1892: x_okl_cntr_lvlng_lns_b_rec.attribute_category := l_okl_cntr_lvlng_lns_b_rec.attribute_category;
1893: END IF;
1894: IF (x_okl_cntr_lvlng_lns_b_rec.attribute1 = OKL_API.G_MISS_CHAR)
1895: THEN
1896: x_okl_cntr_lvlng_lns_b_rec.attribute1 := l_okl_cntr_lvlng_lns_b_rec.attribute1;
1890: IF (x_okl_cntr_lvlng_lns_b_rec.attribute_category = OKL_API.G_MISS_CHAR)
1891: THEN
1892: x_okl_cntr_lvlng_lns_b_rec.attribute_category := l_okl_cntr_lvlng_lns_b_rec.attribute_category;
1893: END IF;
1894: IF (x_okl_cntr_lvlng_lns_b_rec.attribute1 = OKL_API.G_MISS_CHAR)
1895: THEN
1896: x_okl_cntr_lvlng_lns_b_rec.attribute1 := l_okl_cntr_lvlng_lns_b_rec.attribute1;
1897: END IF;
1898: IF (x_okl_cntr_lvlng_lns_b_rec.attribute2 = OKL_API.G_MISS_CHAR)
1892: x_okl_cntr_lvlng_lns_b_rec.attribute_category := l_okl_cntr_lvlng_lns_b_rec.attribute_category;
1893: END IF;
1894: IF (x_okl_cntr_lvlng_lns_b_rec.attribute1 = OKL_API.G_MISS_CHAR)
1895: THEN
1896: x_okl_cntr_lvlng_lns_b_rec.attribute1 := l_okl_cntr_lvlng_lns_b_rec.attribute1;
1897: END IF;
1898: IF (x_okl_cntr_lvlng_lns_b_rec.attribute2 = OKL_API.G_MISS_CHAR)
1899: THEN
1900: x_okl_cntr_lvlng_lns_b_rec.attribute2 := l_okl_cntr_lvlng_lns_b_rec.attribute2;
1894: IF (x_okl_cntr_lvlng_lns_b_rec.attribute1 = OKL_API.G_MISS_CHAR)
1895: THEN
1896: x_okl_cntr_lvlng_lns_b_rec.attribute1 := l_okl_cntr_lvlng_lns_b_rec.attribute1;
1897: END IF;
1898: IF (x_okl_cntr_lvlng_lns_b_rec.attribute2 = OKL_API.G_MISS_CHAR)
1899: THEN
1900: x_okl_cntr_lvlng_lns_b_rec.attribute2 := l_okl_cntr_lvlng_lns_b_rec.attribute2;
1901: END IF;
1902: IF (x_okl_cntr_lvlng_lns_b_rec.attribute3 = OKL_API.G_MISS_CHAR)
1896: x_okl_cntr_lvlng_lns_b_rec.attribute1 := l_okl_cntr_lvlng_lns_b_rec.attribute1;
1897: END IF;
1898: IF (x_okl_cntr_lvlng_lns_b_rec.attribute2 = OKL_API.G_MISS_CHAR)
1899: THEN
1900: x_okl_cntr_lvlng_lns_b_rec.attribute2 := l_okl_cntr_lvlng_lns_b_rec.attribute2;
1901: END IF;
1902: IF (x_okl_cntr_lvlng_lns_b_rec.attribute3 = OKL_API.G_MISS_CHAR)
1903: THEN
1904: x_okl_cntr_lvlng_lns_b_rec.attribute3 := l_okl_cntr_lvlng_lns_b_rec.attribute3;
1898: IF (x_okl_cntr_lvlng_lns_b_rec.attribute2 = OKL_API.G_MISS_CHAR)
1899: THEN
1900: x_okl_cntr_lvlng_lns_b_rec.attribute2 := l_okl_cntr_lvlng_lns_b_rec.attribute2;
1901: END IF;
1902: IF (x_okl_cntr_lvlng_lns_b_rec.attribute3 = OKL_API.G_MISS_CHAR)
1903: THEN
1904: x_okl_cntr_lvlng_lns_b_rec.attribute3 := l_okl_cntr_lvlng_lns_b_rec.attribute3;
1905: END IF;
1906: IF (x_okl_cntr_lvlng_lns_b_rec.attribute4 = OKL_API.G_MISS_CHAR)
1900: x_okl_cntr_lvlng_lns_b_rec.attribute2 := l_okl_cntr_lvlng_lns_b_rec.attribute2;
1901: END IF;
1902: IF (x_okl_cntr_lvlng_lns_b_rec.attribute3 = OKL_API.G_MISS_CHAR)
1903: THEN
1904: x_okl_cntr_lvlng_lns_b_rec.attribute3 := l_okl_cntr_lvlng_lns_b_rec.attribute3;
1905: END IF;
1906: IF (x_okl_cntr_lvlng_lns_b_rec.attribute4 = OKL_API.G_MISS_CHAR)
1907: THEN
1908: x_okl_cntr_lvlng_lns_b_rec.attribute4 := l_okl_cntr_lvlng_lns_b_rec.attribute4;
1902: IF (x_okl_cntr_lvlng_lns_b_rec.attribute3 = OKL_API.G_MISS_CHAR)
1903: THEN
1904: x_okl_cntr_lvlng_lns_b_rec.attribute3 := l_okl_cntr_lvlng_lns_b_rec.attribute3;
1905: END IF;
1906: IF (x_okl_cntr_lvlng_lns_b_rec.attribute4 = OKL_API.G_MISS_CHAR)
1907: THEN
1908: x_okl_cntr_lvlng_lns_b_rec.attribute4 := l_okl_cntr_lvlng_lns_b_rec.attribute4;
1909: END IF;
1910: IF (x_okl_cntr_lvlng_lns_b_rec.attribute5 = OKL_API.G_MISS_CHAR)
1904: x_okl_cntr_lvlng_lns_b_rec.attribute3 := l_okl_cntr_lvlng_lns_b_rec.attribute3;
1905: END IF;
1906: IF (x_okl_cntr_lvlng_lns_b_rec.attribute4 = OKL_API.G_MISS_CHAR)
1907: THEN
1908: x_okl_cntr_lvlng_lns_b_rec.attribute4 := l_okl_cntr_lvlng_lns_b_rec.attribute4;
1909: END IF;
1910: IF (x_okl_cntr_lvlng_lns_b_rec.attribute5 = OKL_API.G_MISS_CHAR)
1911: THEN
1912: x_okl_cntr_lvlng_lns_b_rec.attribute5 := l_okl_cntr_lvlng_lns_b_rec.attribute5;
1906: IF (x_okl_cntr_lvlng_lns_b_rec.attribute4 = OKL_API.G_MISS_CHAR)
1907: THEN
1908: x_okl_cntr_lvlng_lns_b_rec.attribute4 := l_okl_cntr_lvlng_lns_b_rec.attribute4;
1909: END IF;
1910: IF (x_okl_cntr_lvlng_lns_b_rec.attribute5 = OKL_API.G_MISS_CHAR)
1911: THEN
1912: x_okl_cntr_lvlng_lns_b_rec.attribute5 := l_okl_cntr_lvlng_lns_b_rec.attribute5;
1913: END IF;
1914: IF (x_okl_cntr_lvlng_lns_b_rec.attribute6 = OKL_API.G_MISS_CHAR)
1908: x_okl_cntr_lvlng_lns_b_rec.attribute4 := l_okl_cntr_lvlng_lns_b_rec.attribute4;
1909: END IF;
1910: IF (x_okl_cntr_lvlng_lns_b_rec.attribute5 = OKL_API.G_MISS_CHAR)
1911: THEN
1912: x_okl_cntr_lvlng_lns_b_rec.attribute5 := l_okl_cntr_lvlng_lns_b_rec.attribute5;
1913: END IF;
1914: IF (x_okl_cntr_lvlng_lns_b_rec.attribute6 = OKL_API.G_MISS_CHAR)
1915: THEN
1916: x_okl_cntr_lvlng_lns_b_rec.attribute6 := l_okl_cntr_lvlng_lns_b_rec.attribute6;
1910: IF (x_okl_cntr_lvlng_lns_b_rec.attribute5 = OKL_API.G_MISS_CHAR)
1911: THEN
1912: x_okl_cntr_lvlng_lns_b_rec.attribute5 := l_okl_cntr_lvlng_lns_b_rec.attribute5;
1913: END IF;
1914: IF (x_okl_cntr_lvlng_lns_b_rec.attribute6 = OKL_API.G_MISS_CHAR)
1915: THEN
1916: x_okl_cntr_lvlng_lns_b_rec.attribute6 := l_okl_cntr_lvlng_lns_b_rec.attribute6;
1917: END IF;
1918: IF (x_okl_cntr_lvlng_lns_b_rec.attribute7 = OKL_API.G_MISS_CHAR)
1912: x_okl_cntr_lvlng_lns_b_rec.attribute5 := l_okl_cntr_lvlng_lns_b_rec.attribute5;
1913: END IF;
1914: IF (x_okl_cntr_lvlng_lns_b_rec.attribute6 = OKL_API.G_MISS_CHAR)
1915: THEN
1916: x_okl_cntr_lvlng_lns_b_rec.attribute6 := l_okl_cntr_lvlng_lns_b_rec.attribute6;
1917: END IF;
1918: IF (x_okl_cntr_lvlng_lns_b_rec.attribute7 = OKL_API.G_MISS_CHAR)
1919: THEN
1920: x_okl_cntr_lvlng_lns_b_rec.attribute7 := l_okl_cntr_lvlng_lns_b_rec.attribute7;
1914: IF (x_okl_cntr_lvlng_lns_b_rec.attribute6 = OKL_API.G_MISS_CHAR)
1915: THEN
1916: x_okl_cntr_lvlng_lns_b_rec.attribute6 := l_okl_cntr_lvlng_lns_b_rec.attribute6;
1917: END IF;
1918: IF (x_okl_cntr_lvlng_lns_b_rec.attribute7 = OKL_API.G_MISS_CHAR)
1919: THEN
1920: x_okl_cntr_lvlng_lns_b_rec.attribute7 := l_okl_cntr_lvlng_lns_b_rec.attribute7;
1921: END IF;
1922: IF (x_okl_cntr_lvlng_lns_b_rec.attribute8 = OKL_API.G_MISS_CHAR)
1916: x_okl_cntr_lvlng_lns_b_rec.attribute6 := l_okl_cntr_lvlng_lns_b_rec.attribute6;
1917: END IF;
1918: IF (x_okl_cntr_lvlng_lns_b_rec.attribute7 = OKL_API.G_MISS_CHAR)
1919: THEN
1920: x_okl_cntr_lvlng_lns_b_rec.attribute7 := l_okl_cntr_lvlng_lns_b_rec.attribute7;
1921: END IF;
1922: IF (x_okl_cntr_lvlng_lns_b_rec.attribute8 = OKL_API.G_MISS_CHAR)
1923: THEN
1924: x_okl_cntr_lvlng_lns_b_rec.attribute8 := l_okl_cntr_lvlng_lns_b_rec.attribute8;
1918: IF (x_okl_cntr_lvlng_lns_b_rec.attribute7 = OKL_API.G_MISS_CHAR)
1919: THEN
1920: x_okl_cntr_lvlng_lns_b_rec.attribute7 := l_okl_cntr_lvlng_lns_b_rec.attribute7;
1921: END IF;
1922: IF (x_okl_cntr_lvlng_lns_b_rec.attribute8 = OKL_API.G_MISS_CHAR)
1923: THEN
1924: x_okl_cntr_lvlng_lns_b_rec.attribute8 := l_okl_cntr_lvlng_lns_b_rec.attribute8;
1925: END IF;
1926: IF (x_okl_cntr_lvlng_lns_b_rec.attribute9 = OKL_API.G_MISS_CHAR)
1920: x_okl_cntr_lvlng_lns_b_rec.attribute7 := l_okl_cntr_lvlng_lns_b_rec.attribute7;
1921: END IF;
1922: IF (x_okl_cntr_lvlng_lns_b_rec.attribute8 = OKL_API.G_MISS_CHAR)
1923: THEN
1924: x_okl_cntr_lvlng_lns_b_rec.attribute8 := l_okl_cntr_lvlng_lns_b_rec.attribute8;
1925: END IF;
1926: IF (x_okl_cntr_lvlng_lns_b_rec.attribute9 = OKL_API.G_MISS_CHAR)
1927: THEN
1928: x_okl_cntr_lvlng_lns_b_rec.attribute9 := l_okl_cntr_lvlng_lns_b_rec.attribute9;
1922: IF (x_okl_cntr_lvlng_lns_b_rec.attribute8 = OKL_API.G_MISS_CHAR)
1923: THEN
1924: x_okl_cntr_lvlng_lns_b_rec.attribute8 := l_okl_cntr_lvlng_lns_b_rec.attribute8;
1925: END IF;
1926: IF (x_okl_cntr_lvlng_lns_b_rec.attribute9 = OKL_API.G_MISS_CHAR)
1927: THEN
1928: x_okl_cntr_lvlng_lns_b_rec.attribute9 := l_okl_cntr_lvlng_lns_b_rec.attribute9;
1929: END IF;
1930: IF (x_okl_cntr_lvlng_lns_b_rec.attribute10 = OKL_API.G_MISS_CHAR)
1924: x_okl_cntr_lvlng_lns_b_rec.attribute8 := l_okl_cntr_lvlng_lns_b_rec.attribute8;
1925: END IF;
1926: IF (x_okl_cntr_lvlng_lns_b_rec.attribute9 = OKL_API.G_MISS_CHAR)
1927: THEN
1928: x_okl_cntr_lvlng_lns_b_rec.attribute9 := l_okl_cntr_lvlng_lns_b_rec.attribute9;
1929: END IF;
1930: IF (x_okl_cntr_lvlng_lns_b_rec.attribute10 = OKL_API.G_MISS_CHAR)
1931: THEN
1932: x_okl_cntr_lvlng_lns_b_rec.attribute10 := l_okl_cntr_lvlng_lns_b_rec.attribute10;
1926: IF (x_okl_cntr_lvlng_lns_b_rec.attribute9 = OKL_API.G_MISS_CHAR)
1927: THEN
1928: x_okl_cntr_lvlng_lns_b_rec.attribute9 := l_okl_cntr_lvlng_lns_b_rec.attribute9;
1929: END IF;
1930: IF (x_okl_cntr_lvlng_lns_b_rec.attribute10 = OKL_API.G_MISS_CHAR)
1931: THEN
1932: x_okl_cntr_lvlng_lns_b_rec.attribute10 := l_okl_cntr_lvlng_lns_b_rec.attribute10;
1933: END IF;
1934: IF (x_okl_cntr_lvlng_lns_b_rec.attribute11 = OKL_API.G_MISS_CHAR)
1928: x_okl_cntr_lvlng_lns_b_rec.attribute9 := l_okl_cntr_lvlng_lns_b_rec.attribute9;
1929: END IF;
1930: IF (x_okl_cntr_lvlng_lns_b_rec.attribute10 = OKL_API.G_MISS_CHAR)
1931: THEN
1932: x_okl_cntr_lvlng_lns_b_rec.attribute10 := l_okl_cntr_lvlng_lns_b_rec.attribute10;
1933: END IF;
1934: IF (x_okl_cntr_lvlng_lns_b_rec.attribute11 = OKL_API.G_MISS_CHAR)
1935: THEN
1936: x_okl_cntr_lvlng_lns_b_rec.attribute11 := l_okl_cntr_lvlng_lns_b_rec.attribute11;
1930: IF (x_okl_cntr_lvlng_lns_b_rec.attribute10 = OKL_API.G_MISS_CHAR)
1931: THEN
1932: x_okl_cntr_lvlng_lns_b_rec.attribute10 := l_okl_cntr_lvlng_lns_b_rec.attribute10;
1933: END IF;
1934: IF (x_okl_cntr_lvlng_lns_b_rec.attribute11 = OKL_API.G_MISS_CHAR)
1935: THEN
1936: x_okl_cntr_lvlng_lns_b_rec.attribute11 := l_okl_cntr_lvlng_lns_b_rec.attribute11;
1937: END IF;
1938: IF (x_okl_cntr_lvlng_lns_b_rec.attribute12 = OKL_API.G_MISS_CHAR)
1932: x_okl_cntr_lvlng_lns_b_rec.attribute10 := l_okl_cntr_lvlng_lns_b_rec.attribute10;
1933: END IF;
1934: IF (x_okl_cntr_lvlng_lns_b_rec.attribute11 = OKL_API.G_MISS_CHAR)
1935: THEN
1936: x_okl_cntr_lvlng_lns_b_rec.attribute11 := l_okl_cntr_lvlng_lns_b_rec.attribute11;
1937: END IF;
1938: IF (x_okl_cntr_lvlng_lns_b_rec.attribute12 = OKL_API.G_MISS_CHAR)
1939: THEN
1940: x_okl_cntr_lvlng_lns_b_rec.attribute12 := l_okl_cntr_lvlng_lns_b_rec.attribute12;
1934: IF (x_okl_cntr_lvlng_lns_b_rec.attribute11 = OKL_API.G_MISS_CHAR)
1935: THEN
1936: x_okl_cntr_lvlng_lns_b_rec.attribute11 := l_okl_cntr_lvlng_lns_b_rec.attribute11;
1937: END IF;
1938: IF (x_okl_cntr_lvlng_lns_b_rec.attribute12 = OKL_API.G_MISS_CHAR)
1939: THEN
1940: x_okl_cntr_lvlng_lns_b_rec.attribute12 := l_okl_cntr_lvlng_lns_b_rec.attribute12;
1941: END IF;
1942: IF (x_okl_cntr_lvlng_lns_b_rec.attribute13 = OKL_API.G_MISS_CHAR)
1936: x_okl_cntr_lvlng_lns_b_rec.attribute11 := l_okl_cntr_lvlng_lns_b_rec.attribute11;
1937: END IF;
1938: IF (x_okl_cntr_lvlng_lns_b_rec.attribute12 = OKL_API.G_MISS_CHAR)
1939: THEN
1940: x_okl_cntr_lvlng_lns_b_rec.attribute12 := l_okl_cntr_lvlng_lns_b_rec.attribute12;
1941: END IF;
1942: IF (x_okl_cntr_lvlng_lns_b_rec.attribute13 = OKL_API.G_MISS_CHAR)
1943: THEN
1944: x_okl_cntr_lvlng_lns_b_rec.attribute13 := l_okl_cntr_lvlng_lns_b_rec.attribute13;
1938: IF (x_okl_cntr_lvlng_lns_b_rec.attribute12 = OKL_API.G_MISS_CHAR)
1939: THEN
1940: x_okl_cntr_lvlng_lns_b_rec.attribute12 := l_okl_cntr_lvlng_lns_b_rec.attribute12;
1941: END IF;
1942: IF (x_okl_cntr_lvlng_lns_b_rec.attribute13 = OKL_API.G_MISS_CHAR)
1943: THEN
1944: x_okl_cntr_lvlng_lns_b_rec.attribute13 := l_okl_cntr_lvlng_lns_b_rec.attribute13;
1945: END IF;
1946: IF (x_okl_cntr_lvlng_lns_b_rec.attribute14 = OKL_API.G_MISS_CHAR)
1940: x_okl_cntr_lvlng_lns_b_rec.attribute12 := l_okl_cntr_lvlng_lns_b_rec.attribute12;
1941: END IF;
1942: IF (x_okl_cntr_lvlng_lns_b_rec.attribute13 = OKL_API.G_MISS_CHAR)
1943: THEN
1944: x_okl_cntr_lvlng_lns_b_rec.attribute13 := l_okl_cntr_lvlng_lns_b_rec.attribute13;
1945: END IF;
1946: IF (x_okl_cntr_lvlng_lns_b_rec.attribute14 = OKL_API.G_MISS_CHAR)
1947: THEN
1948: x_okl_cntr_lvlng_lns_b_rec.attribute14 := l_okl_cntr_lvlng_lns_b_rec.attribute14;
1942: IF (x_okl_cntr_lvlng_lns_b_rec.attribute13 = OKL_API.G_MISS_CHAR)
1943: THEN
1944: x_okl_cntr_lvlng_lns_b_rec.attribute13 := l_okl_cntr_lvlng_lns_b_rec.attribute13;
1945: END IF;
1946: IF (x_okl_cntr_lvlng_lns_b_rec.attribute14 = OKL_API.G_MISS_CHAR)
1947: THEN
1948: x_okl_cntr_lvlng_lns_b_rec.attribute14 := l_okl_cntr_lvlng_lns_b_rec.attribute14;
1949: END IF;
1950: IF (x_okl_cntr_lvlng_lns_b_rec.attribute15 = OKL_API.G_MISS_CHAR)
1944: x_okl_cntr_lvlng_lns_b_rec.attribute13 := l_okl_cntr_lvlng_lns_b_rec.attribute13;
1945: END IF;
1946: IF (x_okl_cntr_lvlng_lns_b_rec.attribute14 = OKL_API.G_MISS_CHAR)
1947: THEN
1948: x_okl_cntr_lvlng_lns_b_rec.attribute14 := l_okl_cntr_lvlng_lns_b_rec.attribute14;
1949: END IF;
1950: IF (x_okl_cntr_lvlng_lns_b_rec.attribute15 = OKL_API.G_MISS_CHAR)
1951: THEN
1952: x_okl_cntr_lvlng_lns_b_rec.attribute15 := l_okl_cntr_lvlng_lns_b_rec.attribute15;
1946: IF (x_okl_cntr_lvlng_lns_b_rec.attribute14 = OKL_API.G_MISS_CHAR)
1947: THEN
1948: x_okl_cntr_lvlng_lns_b_rec.attribute14 := l_okl_cntr_lvlng_lns_b_rec.attribute14;
1949: END IF;
1950: IF (x_okl_cntr_lvlng_lns_b_rec.attribute15 = OKL_API.G_MISS_CHAR)
1951: THEN
1952: x_okl_cntr_lvlng_lns_b_rec.attribute15 := l_okl_cntr_lvlng_lns_b_rec.attribute15;
1953: END IF;
1954: IF (x_okl_cntr_lvlng_lns_b_rec.created_by = OKL_API.G_MISS_NUM)
1948: x_okl_cntr_lvlng_lns_b_rec.attribute14 := l_okl_cntr_lvlng_lns_b_rec.attribute14;
1949: END IF;
1950: IF (x_okl_cntr_lvlng_lns_b_rec.attribute15 = OKL_API.G_MISS_CHAR)
1951: THEN
1952: x_okl_cntr_lvlng_lns_b_rec.attribute15 := l_okl_cntr_lvlng_lns_b_rec.attribute15;
1953: END IF;
1954: IF (x_okl_cntr_lvlng_lns_b_rec.created_by = OKL_API.G_MISS_NUM)
1955: THEN
1956: x_okl_cntr_lvlng_lns_b_rec.created_by := l_okl_cntr_lvlng_lns_b_rec.created_by;
1950: IF (x_okl_cntr_lvlng_lns_b_rec.attribute15 = OKL_API.G_MISS_CHAR)
1951: THEN
1952: x_okl_cntr_lvlng_lns_b_rec.attribute15 := l_okl_cntr_lvlng_lns_b_rec.attribute15;
1953: END IF;
1954: IF (x_okl_cntr_lvlng_lns_b_rec.created_by = OKL_API.G_MISS_NUM)
1955: THEN
1956: x_okl_cntr_lvlng_lns_b_rec.created_by := l_okl_cntr_lvlng_lns_b_rec.created_by;
1957: END IF;
1958: IF (x_okl_cntr_lvlng_lns_b_rec.creation_date = OKL_API.G_MISS_DATE)
1952: x_okl_cntr_lvlng_lns_b_rec.attribute15 := l_okl_cntr_lvlng_lns_b_rec.attribute15;
1953: END IF;
1954: IF (x_okl_cntr_lvlng_lns_b_rec.created_by = OKL_API.G_MISS_NUM)
1955: THEN
1956: x_okl_cntr_lvlng_lns_b_rec.created_by := l_okl_cntr_lvlng_lns_b_rec.created_by;
1957: END IF;
1958: IF (x_okl_cntr_lvlng_lns_b_rec.creation_date = OKL_API.G_MISS_DATE)
1959: THEN
1960: x_okl_cntr_lvlng_lns_b_rec.creation_date := l_okl_cntr_lvlng_lns_b_rec.creation_date;
1954: IF (x_okl_cntr_lvlng_lns_b_rec.created_by = OKL_API.G_MISS_NUM)
1955: THEN
1956: x_okl_cntr_lvlng_lns_b_rec.created_by := l_okl_cntr_lvlng_lns_b_rec.created_by;
1957: END IF;
1958: IF (x_okl_cntr_lvlng_lns_b_rec.creation_date = OKL_API.G_MISS_DATE)
1959: THEN
1960: x_okl_cntr_lvlng_lns_b_rec.creation_date := l_okl_cntr_lvlng_lns_b_rec.creation_date;
1961: END IF;
1962: IF (x_okl_cntr_lvlng_lns_b_rec.last_updated_by = OKL_API.G_MISS_NUM)
1956: x_okl_cntr_lvlng_lns_b_rec.created_by := l_okl_cntr_lvlng_lns_b_rec.created_by;
1957: END IF;
1958: IF (x_okl_cntr_lvlng_lns_b_rec.creation_date = OKL_API.G_MISS_DATE)
1959: THEN
1960: x_okl_cntr_lvlng_lns_b_rec.creation_date := l_okl_cntr_lvlng_lns_b_rec.creation_date;
1961: END IF;
1962: IF (x_okl_cntr_lvlng_lns_b_rec.last_updated_by = OKL_API.G_MISS_NUM)
1963: THEN
1964: x_okl_cntr_lvlng_lns_b_rec.last_updated_by := l_okl_cntr_lvlng_lns_b_rec.last_updated_by;
1958: IF (x_okl_cntr_lvlng_lns_b_rec.creation_date = OKL_API.G_MISS_DATE)
1959: THEN
1960: x_okl_cntr_lvlng_lns_b_rec.creation_date := l_okl_cntr_lvlng_lns_b_rec.creation_date;
1961: END IF;
1962: IF (x_okl_cntr_lvlng_lns_b_rec.last_updated_by = OKL_API.G_MISS_NUM)
1963: THEN
1964: x_okl_cntr_lvlng_lns_b_rec.last_updated_by := l_okl_cntr_lvlng_lns_b_rec.last_updated_by;
1965: END IF;
1966: IF (x_okl_cntr_lvlng_lns_b_rec.last_update_date = OKL_API.G_MISS_DATE)
1960: x_okl_cntr_lvlng_lns_b_rec.creation_date := l_okl_cntr_lvlng_lns_b_rec.creation_date;
1961: END IF;
1962: IF (x_okl_cntr_lvlng_lns_b_rec.last_updated_by = OKL_API.G_MISS_NUM)
1963: THEN
1964: x_okl_cntr_lvlng_lns_b_rec.last_updated_by := l_okl_cntr_lvlng_lns_b_rec.last_updated_by;
1965: END IF;
1966: IF (x_okl_cntr_lvlng_lns_b_rec.last_update_date = OKL_API.G_MISS_DATE)
1967: THEN
1968: x_okl_cntr_lvlng_lns_b_rec.last_update_date := l_okl_cntr_lvlng_lns_b_rec.last_update_date;
1962: IF (x_okl_cntr_lvlng_lns_b_rec.last_updated_by = OKL_API.G_MISS_NUM)
1963: THEN
1964: x_okl_cntr_lvlng_lns_b_rec.last_updated_by := l_okl_cntr_lvlng_lns_b_rec.last_updated_by;
1965: END IF;
1966: IF (x_okl_cntr_lvlng_lns_b_rec.last_update_date = OKL_API.G_MISS_DATE)
1967: THEN
1968: x_okl_cntr_lvlng_lns_b_rec.last_update_date := l_okl_cntr_lvlng_lns_b_rec.last_update_date;
1969: END IF;
1970: IF (x_okl_cntr_lvlng_lns_b_rec.last_update_login = OKL_API.G_MISS_NUM)
1964: x_okl_cntr_lvlng_lns_b_rec.last_updated_by := l_okl_cntr_lvlng_lns_b_rec.last_updated_by;
1965: END IF;
1966: IF (x_okl_cntr_lvlng_lns_b_rec.last_update_date = OKL_API.G_MISS_DATE)
1967: THEN
1968: x_okl_cntr_lvlng_lns_b_rec.last_update_date := l_okl_cntr_lvlng_lns_b_rec.last_update_date;
1969: END IF;
1970: IF (x_okl_cntr_lvlng_lns_b_rec.last_update_login = OKL_API.G_MISS_NUM)
1971: THEN
1972: x_okl_cntr_lvlng_lns_b_rec.last_update_login := l_okl_cntr_lvlng_lns_b_rec.last_update_login;
1966: IF (x_okl_cntr_lvlng_lns_b_rec.last_update_date = OKL_API.G_MISS_DATE)
1967: THEN
1968: x_okl_cntr_lvlng_lns_b_rec.last_update_date := l_okl_cntr_lvlng_lns_b_rec.last_update_date;
1969: END IF;
1970: IF (x_okl_cntr_lvlng_lns_b_rec.last_update_login = OKL_API.G_MISS_NUM)
1971: THEN
1972: x_okl_cntr_lvlng_lns_b_rec.last_update_login := l_okl_cntr_lvlng_lns_b_rec.last_update_login;
1973: END IF;
1974: END IF;
1968: x_okl_cntr_lvlng_lns_b_rec.last_update_date := l_okl_cntr_lvlng_lns_b_rec.last_update_date;
1969: END IF;
1970: IF (x_okl_cntr_lvlng_lns_b_rec.last_update_login = OKL_API.G_MISS_NUM)
1971: THEN
1972: x_okl_cntr_lvlng_lns_b_rec.last_update_login := l_okl_cntr_lvlng_lns_b_rec.last_update_login;
1973: END IF;
1974: END IF;
1975: RETURN(l_return_status);
1976: END populate_new_record;
1974: END IF;
1975: RETURN(l_return_status);
1976: END populate_new_record;
1977: ---------------------------------------------
1978: -- Set_Attributes for:OKL_CNTR_LVLNG_LNS_B --
1979: ---------------------------------------------
1980: FUNCTION Set_Attributes (
1981: p_okl_cntr_lvlng_lns_b_rec IN okl_cntr_lvlng_lns_b_rec_type,
1982: x_okl_cntr_lvlng_lns_b_rec OUT NOCOPY okl_cntr_lvlng_lns_b_rec_type
1977: ---------------------------------------------
1978: -- Set_Attributes for:OKL_CNTR_LVLNG_LNS_B --
1979: ---------------------------------------------
1980: FUNCTION Set_Attributes (
1981: p_okl_cntr_lvlng_lns_b_rec IN okl_cntr_lvlng_lns_b_rec_type,
1982: x_okl_cntr_lvlng_lns_b_rec OUT NOCOPY okl_cntr_lvlng_lns_b_rec_type
1983: ) RETURN VARCHAR2 IS
1984: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1985: BEGIN
1978: -- Set_Attributes for:OKL_CNTR_LVLNG_LNS_B --
1979: ---------------------------------------------
1980: FUNCTION Set_Attributes (
1981: p_okl_cntr_lvlng_lns_b_rec IN okl_cntr_lvlng_lns_b_rec_type,
1982: x_okl_cntr_lvlng_lns_b_rec OUT NOCOPY okl_cntr_lvlng_lns_b_rec_type
1983: ) RETURN VARCHAR2 IS
1984: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1985: BEGIN
1986: x_okl_cntr_lvlng_lns_b_rec := p_okl_cntr_lvlng_lns_b_rec;
1982: x_okl_cntr_lvlng_lns_b_rec OUT NOCOPY okl_cntr_lvlng_lns_b_rec_type
1983: ) RETURN VARCHAR2 IS
1984: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1985: BEGIN
1986: x_okl_cntr_lvlng_lns_b_rec := p_okl_cntr_lvlng_lns_b_rec;
1987: x_okl_cntr_lvlng_lns_b_rec.OBJECT_VERSION_NUMBER := p_okl_cntr_lvlng_lns_b_rec.OBJECT_VERSION_NUMBER + 1;
1988: RETURN(l_return_status);
1989: END Set_Attributes;
1990: BEGIN
1983: ) RETURN VARCHAR2 IS
1984: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1985: BEGIN
1986: x_okl_cntr_lvlng_lns_b_rec := p_okl_cntr_lvlng_lns_b_rec;
1987: x_okl_cntr_lvlng_lns_b_rec.OBJECT_VERSION_NUMBER := p_okl_cntr_lvlng_lns_b_rec.OBJECT_VERSION_NUMBER + 1;
1988: RETURN(l_return_status);
1989: END Set_Attributes;
1990: BEGIN
1991: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
1998: RAISE OKL_API.G_EXCEPTION_ERROR;
1999: END IF;
2000: --- Setting item attributes
2001: l_return_status := Set_Attributes(
2002: p_okl_cntr_lvlng_lns_b_rec, -- IN
2003: l_okl_cntr_lvlng_lns_b_rec); -- OUT
2004: --- If any errors happen abort API
2005: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2006: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1999: END IF;
2000: --- Setting item attributes
2001: l_return_status := Set_Attributes(
2002: p_okl_cntr_lvlng_lns_b_rec, -- IN
2003: l_okl_cntr_lvlng_lns_b_rec); -- OUT
2004: --- If any errors happen abort API
2005: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2006: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2007: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2006: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2007: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2008: RAISE OKL_API.G_EXCEPTION_ERROR;
2009: END IF;
2010: l_return_status := populate_new_record(l_okl_cntr_lvlng_lns_b_rec, l_def_okl_cntr_lvlng_lns_b_rec);
2011: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2012: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2013: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2014: RAISE OKL_API.G_EXCEPTION_ERROR;
2012: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2013: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2014: RAISE OKL_API.G_EXCEPTION_ERROR;
2015: END IF;
2016: UPDATE OKL_CNTR_LVLNG_LNS_B
2017: SET KLE_ID = l_def_okl_cntr_lvlng_lns_b_rec.kle_id,
2018: CLG_ID = l_def_okl_cntr_lvlng_lns_b_rec.clg_id,
2019: OBJECT_VERSION_NUMBER = l_def_okl_cntr_lvlng_lns_b_rec.object_version_number,
2020: ATTRIBUTE_CATEGORY = l_def_okl_cntr_lvlng_lns_b_rec.attribute_category,
2013: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2014: RAISE OKL_API.G_EXCEPTION_ERROR;
2015: END IF;
2016: UPDATE OKL_CNTR_LVLNG_LNS_B
2017: SET KLE_ID = l_def_okl_cntr_lvlng_lns_b_rec.kle_id,
2018: CLG_ID = l_def_okl_cntr_lvlng_lns_b_rec.clg_id,
2019: OBJECT_VERSION_NUMBER = l_def_okl_cntr_lvlng_lns_b_rec.object_version_number,
2020: ATTRIBUTE_CATEGORY = l_def_okl_cntr_lvlng_lns_b_rec.attribute_category,
2021: ATTRIBUTE1 = l_def_okl_cntr_lvlng_lns_b_rec.attribute1,
2014: RAISE OKL_API.G_EXCEPTION_ERROR;
2015: END IF;
2016: UPDATE OKL_CNTR_LVLNG_LNS_B
2017: SET KLE_ID = l_def_okl_cntr_lvlng_lns_b_rec.kle_id,
2018: CLG_ID = l_def_okl_cntr_lvlng_lns_b_rec.clg_id,
2019: OBJECT_VERSION_NUMBER = l_def_okl_cntr_lvlng_lns_b_rec.object_version_number,
2020: ATTRIBUTE_CATEGORY = l_def_okl_cntr_lvlng_lns_b_rec.attribute_category,
2021: ATTRIBUTE1 = l_def_okl_cntr_lvlng_lns_b_rec.attribute1,
2022: ATTRIBUTE2 = l_def_okl_cntr_lvlng_lns_b_rec.attribute2,
2015: END IF;
2016: UPDATE OKL_CNTR_LVLNG_LNS_B
2017: SET KLE_ID = l_def_okl_cntr_lvlng_lns_b_rec.kle_id,
2018: CLG_ID = l_def_okl_cntr_lvlng_lns_b_rec.clg_id,
2019: OBJECT_VERSION_NUMBER = l_def_okl_cntr_lvlng_lns_b_rec.object_version_number,
2020: ATTRIBUTE_CATEGORY = l_def_okl_cntr_lvlng_lns_b_rec.attribute_category,
2021: ATTRIBUTE1 = l_def_okl_cntr_lvlng_lns_b_rec.attribute1,
2022: ATTRIBUTE2 = l_def_okl_cntr_lvlng_lns_b_rec.attribute2,
2023: ATTRIBUTE3 = l_def_okl_cntr_lvlng_lns_b_rec.attribute3,
2016: UPDATE OKL_CNTR_LVLNG_LNS_B
2017: SET KLE_ID = l_def_okl_cntr_lvlng_lns_b_rec.kle_id,
2018: CLG_ID = l_def_okl_cntr_lvlng_lns_b_rec.clg_id,
2019: OBJECT_VERSION_NUMBER = l_def_okl_cntr_lvlng_lns_b_rec.object_version_number,
2020: ATTRIBUTE_CATEGORY = l_def_okl_cntr_lvlng_lns_b_rec.attribute_category,
2021: ATTRIBUTE1 = l_def_okl_cntr_lvlng_lns_b_rec.attribute1,
2022: ATTRIBUTE2 = l_def_okl_cntr_lvlng_lns_b_rec.attribute2,
2023: ATTRIBUTE3 = l_def_okl_cntr_lvlng_lns_b_rec.attribute3,
2024: ATTRIBUTE4 = l_def_okl_cntr_lvlng_lns_b_rec.attribute4,
2017: SET KLE_ID = l_def_okl_cntr_lvlng_lns_b_rec.kle_id,
2018: CLG_ID = l_def_okl_cntr_lvlng_lns_b_rec.clg_id,
2019: OBJECT_VERSION_NUMBER = l_def_okl_cntr_lvlng_lns_b_rec.object_version_number,
2020: ATTRIBUTE_CATEGORY = l_def_okl_cntr_lvlng_lns_b_rec.attribute_category,
2021: ATTRIBUTE1 = l_def_okl_cntr_lvlng_lns_b_rec.attribute1,
2022: ATTRIBUTE2 = l_def_okl_cntr_lvlng_lns_b_rec.attribute2,
2023: ATTRIBUTE3 = l_def_okl_cntr_lvlng_lns_b_rec.attribute3,
2024: ATTRIBUTE4 = l_def_okl_cntr_lvlng_lns_b_rec.attribute4,
2025: ATTRIBUTE5 = l_def_okl_cntr_lvlng_lns_b_rec.attribute5,
2018: CLG_ID = l_def_okl_cntr_lvlng_lns_b_rec.clg_id,
2019: OBJECT_VERSION_NUMBER = l_def_okl_cntr_lvlng_lns_b_rec.object_version_number,
2020: ATTRIBUTE_CATEGORY = l_def_okl_cntr_lvlng_lns_b_rec.attribute_category,
2021: ATTRIBUTE1 = l_def_okl_cntr_lvlng_lns_b_rec.attribute1,
2022: ATTRIBUTE2 = l_def_okl_cntr_lvlng_lns_b_rec.attribute2,
2023: ATTRIBUTE3 = l_def_okl_cntr_lvlng_lns_b_rec.attribute3,
2024: ATTRIBUTE4 = l_def_okl_cntr_lvlng_lns_b_rec.attribute4,
2025: ATTRIBUTE5 = l_def_okl_cntr_lvlng_lns_b_rec.attribute5,
2026: ATTRIBUTE6 = l_def_okl_cntr_lvlng_lns_b_rec.attribute6,
2019: OBJECT_VERSION_NUMBER = l_def_okl_cntr_lvlng_lns_b_rec.object_version_number,
2020: ATTRIBUTE_CATEGORY = l_def_okl_cntr_lvlng_lns_b_rec.attribute_category,
2021: ATTRIBUTE1 = l_def_okl_cntr_lvlng_lns_b_rec.attribute1,
2022: ATTRIBUTE2 = l_def_okl_cntr_lvlng_lns_b_rec.attribute2,
2023: ATTRIBUTE3 = l_def_okl_cntr_lvlng_lns_b_rec.attribute3,
2024: ATTRIBUTE4 = l_def_okl_cntr_lvlng_lns_b_rec.attribute4,
2025: ATTRIBUTE5 = l_def_okl_cntr_lvlng_lns_b_rec.attribute5,
2026: ATTRIBUTE6 = l_def_okl_cntr_lvlng_lns_b_rec.attribute6,
2027: ATTRIBUTE7 = l_def_okl_cntr_lvlng_lns_b_rec.attribute7,
2020: ATTRIBUTE_CATEGORY = l_def_okl_cntr_lvlng_lns_b_rec.attribute_category,
2021: ATTRIBUTE1 = l_def_okl_cntr_lvlng_lns_b_rec.attribute1,
2022: ATTRIBUTE2 = l_def_okl_cntr_lvlng_lns_b_rec.attribute2,
2023: ATTRIBUTE3 = l_def_okl_cntr_lvlng_lns_b_rec.attribute3,
2024: ATTRIBUTE4 = l_def_okl_cntr_lvlng_lns_b_rec.attribute4,
2025: ATTRIBUTE5 = l_def_okl_cntr_lvlng_lns_b_rec.attribute5,
2026: ATTRIBUTE6 = l_def_okl_cntr_lvlng_lns_b_rec.attribute6,
2027: ATTRIBUTE7 = l_def_okl_cntr_lvlng_lns_b_rec.attribute7,
2028: ATTRIBUTE8 = l_def_okl_cntr_lvlng_lns_b_rec.attribute8,
2021: ATTRIBUTE1 = l_def_okl_cntr_lvlng_lns_b_rec.attribute1,
2022: ATTRIBUTE2 = l_def_okl_cntr_lvlng_lns_b_rec.attribute2,
2023: ATTRIBUTE3 = l_def_okl_cntr_lvlng_lns_b_rec.attribute3,
2024: ATTRIBUTE4 = l_def_okl_cntr_lvlng_lns_b_rec.attribute4,
2025: ATTRIBUTE5 = l_def_okl_cntr_lvlng_lns_b_rec.attribute5,
2026: ATTRIBUTE6 = l_def_okl_cntr_lvlng_lns_b_rec.attribute6,
2027: ATTRIBUTE7 = l_def_okl_cntr_lvlng_lns_b_rec.attribute7,
2028: ATTRIBUTE8 = l_def_okl_cntr_lvlng_lns_b_rec.attribute8,
2029: ATTRIBUTE9 = l_def_okl_cntr_lvlng_lns_b_rec.attribute9,
2022: ATTRIBUTE2 = l_def_okl_cntr_lvlng_lns_b_rec.attribute2,
2023: ATTRIBUTE3 = l_def_okl_cntr_lvlng_lns_b_rec.attribute3,
2024: ATTRIBUTE4 = l_def_okl_cntr_lvlng_lns_b_rec.attribute4,
2025: ATTRIBUTE5 = l_def_okl_cntr_lvlng_lns_b_rec.attribute5,
2026: ATTRIBUTE6 = l_def_okl_cntr_lvlng_lns_b_rec.attribute6,
2027: ATTRIBUTE7 = l_def_okl_cntr_lvlng_lns_b_rec.attribute7,
2028: ATTRIBUTE8 = l_def_okl_cntr_lvlng_lns_b_rec.attribute8,
2029: ATTRIBUTE9 = l_def_okl_cntr_lvlng_lns_b_rec.attribute9,
2030: ATTRIBUTE10 = l_def_okl_cntr_lvlng_lns_b_rec.attribute10,
2023: ATTRIBUTE3 = l_def_okl_cntr_lvlng_lns_b_rec.attribute3,
2024: ATTRIBUTE4 = l_def_okl_cntr_lvlng_lns_b_rec.attribute4,
2025: ATTRIBUTE5 = l_def_okl_cntr_lvlng_lns_b_rec.attribute5,
2026: ATTRIBUTE6 = l_def_okl_cntr_lvlng_lns_b_rec.attribute6,
2027: ATTRIBUTE7 = l_def_okl_cntr_lvlng_lns_b_rec.attribute7,
2028: ATTRIBUTE8 = l_def_okl_cntr_lvlng_lns_b_rec.attribute8,
2029: ATTRIBUTE9 = l_def_okl_cntr_lvlng_lns_b_rec.attribute9,
2030: ATTRIBUTE10 = l_def_okl_cntr_lvlng_lns_b_rec.attribute10,
2031: ATTRIBUTE11 = l_def_okl_cntr_lvlng_lns_b_rec.attribute11,
2024: ATTRIBUTE4 = l_def_okl_cntr_lvlng_lns_b_rec.attribute4,
2025: ATTRIBUTE5 = l_def_okl_cntr_lvlng_lns_b_rec.attribute5,
2026: ATTRIBUTE6 = l_def_okl_cntr_lvlng_lns_b_rec.attribute6,
2027: ATTRIBUTE7 = l_def_okl_cntr_lvlng_lns_b_rec.attribute7,
2028: ATTRIBUTE8 = l_def_okl_cntr_lvlng_lns_b_rec.attribute8,
2029: ATTRIBUTE9 = l_def_okl_cntr_lvlng_lns_b_rec.attribute9,
2030: ATTRIBUTE10 = l_def_okl_cntr_lvlng_lns_b_rec.attribute10,
2031: ATTRIBUTE11 = l_def_okl_cntr_lvlng_lns_b_rec.attribute11,
2032: ATTRIBUTE12 = l_def_okl_cntr_lvlng_lns_b_rec.attribute12,
2025: ATTRIBUTE5 = l_def_okl_cntr_lvlng_lns_b_rec.attribute5,
2026: ATTRIBUTE6 = l_def_okl_cntr_lvlng_lns_b_rec.attribute6,
2027: ATTRIBUTE7 = l_def_okl_cntr_lvlng_lns_b_rec.attribute7,
2028: ATTRIBUTE8 = l_def_okl_cntr_lvlng_lns_b_rec.attribute8,
2029: ATTRIBUTE9 = l_def_okl_cntr_lvlng_lns_b_rec.attribute9,
2030: ATTRIBUTE10 = l_def_okl_cntr_lvlng_lns_b_rec.attribute10,
2031: ATTRIBUTE11 = l_def_okl_cntr_lvlng_lns_b_rec.attribute11,
2032: ATTRIBUTE12 = l_def_okl_cntr_lvlng_lns_b_rec.attribute12,
2033: ATTRIBUTE13 = l_def_okl_cntr_lvlng_lns_b_rec.attribute13,
2026: ATTRIBUTE6 = l_def_okl_cntr_lvlng_lns_b_rec.attribute6,
2027: ATTRIBUTE7 = l_def_okl_cntr_lvlng_lns_b_rec.attribute7,
2028: ATTRIBUTE8 = l_def_okl_cntr_lvlng_lns_b_rec.attribute8,
2029: ATTRIBUTE9 = l_def_okl_cntr_lvlng_lns_b_rec.attribute9,
2030: ATTRIBUTE10 = l_def_okl_cntr_lvlng_lns_b_rec.attribute10,
2031: ATTRIBUTE11 = l_def_okl_cntr_lvlng_lns_b_rec.attribute11,
2032: ATTRIBUTE12 = l_def_okl_cntr_lvlng_lns_b_rec.attribute12,
2033: ATTRIBUTE13 = l_def_okl_cntr_lvlng_lns_b_rec.attribute13,
2034: ATTRIBUTE14 = l_def_okl_cntr_lvlng_lns_b_rec.attribute14,
2027: ATTRIBUTE7 = l_def_okl_cntr_lvlng_lns_b_rec.attribute7,
2028: ATTRIBUTE8 = l_def_okl_cntr_lvlng_lns_b_rec.attribute8,
2029: ATTRIBUTE9 = l_def_okl_cntr_lvlng_lns_b_rec.attribute9,
2030: ATTRIBUTE10 = l_def_okl_cntr_lvlng_lns_b_rec.attribute10,
2031: ATTRIBUTE11 = l_def_okl_cntr_lvlng_lns_b_rec.attribute11,
2032: ATTRIBUTE12 = l_def_okl_cntr_lvlng_lns_b_rec.attribute12,
2033: ATTRIBUTE13 = l_def_okl_cntr_lvlng_lns_b_rec.attribute13,
2034: ATTRIBUTE14 = l_def_okl_cntr_lvlng_lns_b_rec.attribute14,
2035: ATTRIBUTE15 = l_def_okl_cntr_lvlng_lns_b_rec.attribute15,
2028: ATTRIBUTE8 = l_def_okl_cntr_lvlng_lns_b_rec.attribute8,
2029: ATTRIBUTE9 = l_def_okl_cntr_lvlng_lns_b_rec.attribute9,
2030: ATTRIBUTE10 = l_def_okl_cntr_lvlng_lns_b_rec.attribute10,
2031: ATTRIBUTE11 = l_def_okl_cntr_lvlng_lns_b_rec.attribute11,
2032: ATTRIBUTE12 = l_def_okl_cntr_lvlng_lns_b_rec.attribute12,
2033: ATTRIBUTE13 = l_def_okl_cntr_lvlng_lns_b_rec.attribute13,
2034: ATTRIBUTE14 = l_def_okl_cntr_lvlng_lns_b_rec.attribute14,
2035: ATTRIBUTE15 = l_def_okl_cntr_lvlng_lns_b_rec.attribute15,
2036: CREATED_BY = l_def_okl_cntr_lvlng_lns_b_rec.created_by,
2029: ATTRIBUTE9 = l_def_okl_cntr_lvlng_lns_b_rec.attribute9,
2030: ATTRIBUTE10 = l_def_okl_cntr_lvlng_lns_b_rec.attribute10,
2031: ATTRIBUTE11 = l_def_okl_cntr_lvlng_lns_b_rec.attribute11,
2032: ATTRIBUTE12 = l_def_okl_cntr_lvlng_lns_b_rec.attribute12,
2033: ATTRIBUTE13 = l_def_okl_cntr_lvlng_lns_b_rec.attribute13,
2034: ATTRIBUTE14 = l_def_okl_cntr_lvlng_lns_b_rec.attribute14,
2035: ATTRIBUTE15 = l_def_okl_cntr_lvlng_lns_b_rec.attribute15,
2036: CREATED_BY = l_def_okl_cntr_lvlng_lns_b_rec.created_by,
2037: CREATION_DATE = l_def_okl_cntr_lvlng_lns_b_rec.creation_date,
2030: ATTRIBUTE10 = l_def_okl_cntr_lvlng_lns_b_rec.attribute10,
2031: ATTRIBUTE11 = l_def_okl_cntr_lvlng_lns_b_rec.attribute11,
2032: ATTRIBUTE12 = l_def_okl_cntr_lvlng_lns_b_rec.attribute12,
2033: ATTRIBUTE13 = l_def_okl_cntr_lvlng_lns_b_rec.attribute13,
2034: ATTRIBUTE14 = l_def_okl_cntr_lvlng_lns_b_rec.attribute14,
2035: ATTRIBUTE15 = l_def_okl_cntr_lvlng_lns_b_rec.attribute15,
2036: CREATED_BY = l_def_okl_cntr_lvlng_lns_b_rec.created_by,
2037: CREATION_DATE = l_def_okl_cntr_lvlng_lns_b_rec.creation_date,
2038: LAST_UPDATED_BY = l_def_okl_cntr_lvlng_lns_b_rec.last_updated_by,
2031: ATTRIBUTE11 = l_def_okl_cntr_lvlng_lns_b_rec.attribute11,
2032: ATTRIBUTE12 = l_def_okl_cntr_lvlng_lns_b_rec.attribute12,
2033: ATTRIBUTE13 = l_def_okl_cntr_lvlng_lns_b_rec.attribute13,
2034: ATTRIBUTE14 = l_def_okl_cntr_lvlng_lns_b_rec.attribute14,
2035: ATTRIBUTE15 = l_def_okl_cntr_lvlng_lns_b_rec.attribute15,
2036: CREATED_BY = l_def_okl_cntr_lvlng_lns_b_rec.created_by,
2037: CREATION_DATE = l_def_okl_cntr_lvlng_lns_b_rec.creation_date,
2038: LAST_UPDATED_BY = l_def_okl_cntr_lvlng_lns_b_rec.last_updated_by,
2039: LAST_UPDATE_DATE = l_def_okl_cntr_lvlng_lns_b_rec.last_update_date,
2032: ATTRIBUTE12 = l_def_okl_cntr_lvlng_lns_b_rec.attribute12,
2033: ATTRIBUTE13 = l_def_okl_cntr_lvlng_lns_b_rec.attribute13,
2034: ATTRIBUTE14 = l_def_okl_cntr_lvlng_lns_b_rec.attribute14,
2035: ATTRIBUTE15 = l_def_okl_cntr_lvlng_lns_b_rec.attribute15,
2036: CREATED_BY = l_def_okl_cntr_lvlng_lns_b_rec.created_by,
2037: CREATION_DATE = l_def_okl_cntr_lvlng_lns_b_rec.creation_date,
2038: LAST_UPDATED_BY = l_def_okl_cntr_lvlng_lns_b_rec.last_updated_by,
2039: LAST_UPDATE_DATE = l_def_okl_cntr_lvlng_lns_b_rec.last_update_date,
2040: LAST_UPDATE_LOGIN = l_def_okl_cntr_lvlng_lns_b_rec.last_update_login
2033: ATTRIBUTE13 = l_def_okl_cntr_lvlng_lns_b_rec.attribute13,
2034: ATTRIBUTE14 = l_def_okl_cntr_lvlng_lns_b_rec.attribute14,
2035: ATTRIBUTE15 = l_def_okl_cntr_lvlng_lns_b_rec.attribute15,
2036: CREATED_BY = l_def_okl_cntr_lvlng_lns_b_rec.created_by,
2037: CREATION_DATE = l_def_okl_cntr_lvlng_lns_b_rec.creation_date,
2038: LAST_UPDATED_BY = l_def_okl_cntr_lvlng_lns_b_rec.last_updated_by,
2039: LAST_UPDATE_DATE = l_def_okl_cntr_lvlng_lns_b_rec.last_update_date,
2040: LAST_UPDATE_LOGIN = l_def_okl_cntr_lvlng_lns_b_rec.last_update_login
2041: WHERE ID = l_def_okl_cntr_lvlng_lns_b_rec.id;
2034: ATTRIBUTE14 = l_def_okl_cntr_lvlng_lns_b_rec.attribute14,
2035: ATTRIBUTE15 = l_def_okl_cntr_lvlng_lns_b_rec.attribute15,
2036: CREATED_BY = l_def_okl_cntr_lvlng_lns_b_rec.created_by,
2037: CREATION_DATE = l_def_okl_cntr_lvlng_lns_b_rec.creation_date,
2038: LAST_UPDATED_BY = l_def_okl_cntr_lvlng_lns_b_rec.last_updated_by,
2039: LAST_UPDATE_DATE = l_def_okl_cntr_lvlng_lns_b_rec.last_update_date,
2040: LAST_UPDATE_LOGIN = l_def_okl_cntr_lvlng_lns_b_rec.last_update_login
2041: WHERE ID = l_def_okl_cntr_lvlng_lns_b_rec.id;
2042:
2035: ATTRIBUTE15 = l_def_okl_cntr_lvlng_lns_b_rec.attribute15,
2036: CREATED_BY = l_def_okl_cntr_lvlng_lns_b_rec.created_by,
2037: CREATION_DATE = l_def_okl_cntr_lvlng_lns_b_rec.creation_date,
2038: LAST_UPDATED_BY = l_def_okl_cntr_lvlng_lns_b_rec.last_updated_by,
2039: LAST_UPDATE_DATE = l_def_okl_cntr_lvlng_lns_b_rec.last_update_date,
2040: LAST_UPDATE_LOGIN = l_def_okl_cntr_lvlng_lns_b_rec.last_update_login
2041: WHERE ID = l_def_okl_cntr_lvlng_lns_b_rec.id;
2042:
2043: x_okl_cntr_lvlng_lns_b_rec := l_okl_cntr_lvlng_lns_b_rec;
2036: CREATED_BY = l_def_okl_cntr_lvlng_lns_b_rec.created_by,
2037: CREATION_DATE = l_def_okl_cntr_lvlng_lns_b_rec.creation_date,
2038: LAST_UPDATED_BY = l_def_okl_cntr_lvlng_lns_b_rec.last_updated_by,
2039: LAST_UPDATE_DATE = l_def_okl_cntr_lvlng_lns_b_rec.last_update_date,
2040: LAST_UPDATE_LOGIN = l_def_okl_cntr_lvlng_lns_b_rec.last_update_login
2041: WHERE ID = l_def_okl_cntr_lvlng_lns_b_rec.id;
2042:
2043: x_okl_cntr_lvlng_lns_b_rec := l_okl_cntr_lvlng_lns_b_rec;
2044: x_return_status := l_return_status;
2037: CREATION_DATE = l_def_okl_cntr_lvlng_lns_b_rec.creation_date,
2038: LAST_UPDATED_BY = l_def_okl_cntr_lvlng_lns_b_rec.last_updated_by,
2039: LAST_UPDATE_DATE = l_def_okl_cntr_lvlng_lns_b_rec.last_update_date,
2040: LAST_UPDATE_LOGIN = l_def_okl_cntr_lvlng_lns_b_rec.last_update_login
2041: WHERE ID = l_def_okl_cntr_lvlng_lns_b_rec.id;
2042:
2043: x_okl_cntr_lvlng_lns_b_rec := l_okl_cntr_lvlng_lns_b_rec;
2044: x_return_status := l_return_status;
2045: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2039: LAST_UPDATE_DATE = l_def_okl_cntr_lvlng_lns_b_rec.last_update_date,
2040: LAST_UPDATE_LOGIN = l_def_okl_cntr_lvlng_lns_b_rec.last_update_login
2041: WHERE ID = l_def_okl_cntr_lvlng_lns_b_rec.id;
2042:
2043: x_okl_cntr_lvlng_lns_b_rec := l_okl_cntr_lvlng_lns_b_rec;
2044: x_return_status := l_return_status;
2045: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2046: EXCEPTION
2047: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2092: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2093: l_cllv_rec cllv_rec_type := p_cllv_rec;
2094: l_def_cllv_rec cllv_rec_type;
2095: l_db_cllv_rec cllv_rec_type;
2096: l_okl_cntr_lvlng_lns_b_rec okl_cntr_lvlng_lns_b_rec_type;
2097: lx_okl_cntr_lvlng_lns_b_rec okl_cntr_lvlng_lns_b_rec_type;
2098: -------------------------------
2099: -- FUNCTION fill_who_columns --
2100: -------------------------------
2093: l_cllv_rec cllv_rec_type := p_cllv_rec;
2094: l_def_cllv_rec cllv_rec_type;
2095: l_db_cllv_rec cllv_rec_type;
2096: l_okl_cntr_lvlng_lns_b_rec okl_cntr_lvlng_lns_b_rec_type;
2097: lx_okl_cntr_lvlng_lns_b_rec okl_cntr_lvlng_lns_b_rec_type;
2098: -------------------------------
2099: -- FUNCTION fill_who_columns --
2100: -------------------------------
2101: FUNCTION fill_who_columns (
2302: */
2303: -----------------------------------------
2304: -- Move VIEW record to "Child" records --
2305: -----------------------------------------
2306: migrate(l_def_cllv_rec, l_okl_cntr_lvlng_lns_b_rec);
2307: -----------------------------------------------
2308: -- Call the UPDATE_ROW for each child record --
2309: -----------------------------------------------
2310: update_row(
2311: p_init_msg_list,
2312: l_return_status,
2313: x_msg_count,
2314: x_msg_data,
2315: l_okl_cntr_lvlng_lns_b_rec,
2316: lx_okl_cntr_lvlng_lns_b_rec
2317: );
2318: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2319: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2312: l_return_status,
2313: x_msg_count,
2314: x_msg_data,
2315: l_okl_cntr_lvlng_lns_b_rec,
2316: lx_okl_cntr_lvlng_lns_b_rec
2317: );
2318: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2319: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2320: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2319: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2320: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2321: RAISE OKL_API.G_EXCEPTION_ERROR;
2322: END IF;
2323: migrate(lx_okl_cntr_lvlng_lns_b_rec, l_def_cllv_rec);
2324: x_cllv_rec := l_def_cllv_rec;
2325: x_return_status := l_return_status;
2326: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2327: EXCEPTION
2521: ---------------------------------------------------------------------------
2522: -- PROCEDURE delete_row
2523: ---------------------------------------------------------------------------
2524: -----------------------------------------
2525: -- delete_row for:OKL_CNTR_LVLNG_LNS_B --
2526: -----------------------------------------
2527: PROCEDURE delete_row(
2528: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
2529: x_return_status OUT NOCOPY VARCHAR2,
2528: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
2529: x_return_status OUT NOCOPY VARCHAR2,
2530: x_msg_count OUT NOCOPY NUMBER,
2531: x_msg_data OUT NOCOPY VARCHAR2,
2532: p_okl_cntr_lvlng_lns_b_rec IN okl_cntr_lvlng_lns_b_rec_type) IS
2533:
2534: l_api_version CONSTANT NUMBER := 1;
2535: l_api_name CONSTANT VARCHAR2(30) := 'B_delete_row';
2536: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2533:
2534: l_api_version CONSTANT NUMBER := 1;
2535: l_api_name CONSTANT VARCHAR2(30) := 'B_delete_row';
2536: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2537: l_okl_cntr_lvlng_lns_b_rec okl_cntr_lvlng_lns_b_rec_type := p_okl_cntr_lvlng_lns_b_rec;
2538: l_row_notfound BOOLEAN := TRUE;
2539: BEGIN
2540: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
2541: p_init_msg_list,
2546: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2547: RAISE OKL_API.G_EXCEPTION_ERROR;
2548: END IF;
2549:
2550: DELETE FROM OKL_CNTR_LVLNG_LNS_B
2551: WHERE ID = p_okl_cntr_lvlng_lns_b_rec.id;
2552:
2553: x_return_status := l_return_status;
2554: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2547: RAISE OKL_API.G_EXCEPTION_ERROR;
2548: END IF;
2549:
2550: DELETE FROM OKL_CNTR_LVLNG_LNS_B
2551: WHERE ID = p_okl_cntr_lvlng_lns_b_rec.id;
2552:
2553: x_return_status := l_return_status;
2554: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2555: EXCEPTION
2598: l_api_version CONSTANT NUMBER := 1;
2599: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
2600: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2601: l_cllv_rec cllv_rec_type := p_cllv_rec;
2602: l_okl_cntr_lvlng_lns_b_rec okl_cntr_lvlng_lns_b_rec_type;
2603: BEGIN
2604: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
2605: G_PKG_NAME,
2606: p_init_msg_list,
2615: END IF;
2616: -----------------------------------------
2617: -- Move VIEW record to "Child" records --
2618: -----------------------------------------
2619: migrate(l_cllv_rec, l_okl_cntr_lvlng_lns_b_rec);
2620: -----------------------------------------------
2621: -- Call the DELETE_ROW for each child record --
2622: -----------------------------------------------
2623: delete_row(
2624: p_init_msg_list,
2625: l_return_status,
2626: x_msg_count,
2627: x_msg_data,
2628: l_okl_cntr_lvlng_lns_b_rec
2629: );
2630: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2631: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2632: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN