[Home] [Help]
94: null;
95: END api_copy;
96:
97: ---------------------------------------------------------------------------
98: -- FUNCTION get_rec for: OKL_TRX_SUBSIDY_POOLS_V
99: ---------------------------------------------------------------------------
100: FUNCTION get_rec (
101: p_sixv_rec IN sixv_rec_type,
102: x_no_data_found OUT NOCOPY BOOLEAN
100: FUNCTION get_rec (
101: p_sixv_rec IN sixv_rec_type,
102: x_no_data_found OUT NOCOPY BOOLEAN
103: ) RETURN sixv_rec_type IS
104: CURSOR okl_trx_subsidy_pools_v_pk_csr (p_id IN NUMBER) IS
105: SELECT
106: ID,
107: OBJECT_VERSION_NUMBER,
108: TRX_TYPE_CODE,
140: CREATION_DATE,
141: LAST_UPDATED_BY,
142: LAST_UPDATE_DATE,
143: LAST_UPDATE_LOGIN
144: FROM Okl_Trx_Subsidy_Pools_V
145: WHERE okl_trx_subsidy_pools_v.id = p_id;
146: l_okl_trx_subsidy_pools_v_pk okl_trx_subsidy_pools_v_pk_csr%ROWTYPE;
147: l_sixv_rec sixv_rec_type;
148: BEGIN
141: LAST_UPDATED_BY,
142: LAST_UPDATE_DATE,
143: LAST_UPDATE_LOGIN
144: FROM Okl_Trx_Subsidy_Pools_V
145: WHERE okl_trx_subsidy_pools_v.id = p_id;
146: l_okl_trx_subsidy_pools_v_pk okl_trx_subsidy_pools_v_pk_csr%ROWTYPE;
147: l_sixv_rec sixv_rec_type;
148: BEGIN
149: x_no_data_found := TRUE;
142: LAST_UPDATE_DATE,
143: LAST_UPDATE_LOGIN
144: FROM Okl_Trx_Subsidy_Pools_V
145: WHERE okl_trx_subsidy_pools_v.id = p_id;
146: l_okl_trx_subsidy_pools_v_pk okl_trx_subsidy_pools_v_pk_csr%ROWTYPE;
147: l_sixv_rec sixv_rec_type;
148: BEGIN
149: x_no_data_found := TRUE;
150: -- Get current database values
147: l_sixv_rec sixv_rec_type;
148: BEGIN
149: x_no_data_found := TRUE;
150: -- Get current database values
151: OPEN okl_trx_subsidy_pools_v_pk_csr (p_sixv_rec.id);
152: FETCH okl_trx_subsidy_pools_v_pk_csr INTO
153: l_sixv_rec.id,
154: l_sixv_rec.object_version_number,
155: l_sixv_rec.trx_type_code,
148: BEGIN
149: x_no_data_found := TRUE;
150: -- Get current database values
151: OPEN okl_trx_subsidy_pools_v_pk_csr (p_sixv_rec.id);
152: FETCH okl_trx_subsidy_pools_v_pk_csr INTO
153: l_sixv_rec.id,
154: l_sixv_rec.object_version_number,
155: l_sixv_rec.trx_type_code,
156: l_sixv_rec.source_type_code,
187: l_sixv_rec.creation_date,
188: l_sixv_rec.last_updated_by,
189: l_sixv_rec.last_update_date,
190: l_sixv_rec.last_update_login;
191: x_no_data_found := okl_trx_subsidy_pools_v_pk_csr%NOTFOUND;
192: CLOSE okl_trx_subsidy_pools_v_pk_csr;
193: RETURN(l_sixv_rec);
194: END get_rec;
195:
188: l_sixv_rec.last_updated_by,
189: l_sixv_rec.last_update_date,
190: l_sixv_rec.last_update_login;
191: x_no_data_found := okl_trx_subsidy_pools_v_pk_csr%NOTFOUND;
192: CLOSE okl_trx_subsidy_pools_v_pk_csr;
193: RETURN(l_sixv_rec);
194: END get_rec;
195:
196: ------------------------------------------------------------------
221: BEGIN
222: RETURN(get_rec(p_sixv_rec, l_row_not_found));
223: END get_rec;
224: ---------------------------------------------------------------------------
225: -- FUNCTION get_rec for: OKL_TRX_SUBSIDY_POOLS
226: ---------------------------------------------------------------------------
227: FUNCTION get_rec (
228: p_okl_trx_subsidy_pools_rec IN okl_trx_subsidy_pools_rec_type,
229: x_no_data_found OUT NOCOPY BOOLEAN
224: ---------------------------------------------------------------------------
225: -- FUNCTION get_rec for: OKL_TRX_SUBSIDY_POOLS
226: ---------------------------------------------------------------------------
227: FUNCTION get_rec (
228: p_okl_trx_subsidy_pools_rec IN okl_trx_subsidy_pools_rec_type,
229: x_no_data_found OUT NOCOPY BOOLEAN
230: ) RETURN okl_trx_subsidy_pools_rec_type IS
231: CURSOR okl_trx_subsidy_pools_pk_csr (p_id IN NUMBER) IS
232: SELECT
226: ---------------------------------------------------------------------------
227: FUNCTION get_rec (
228: p_okl_trx_subsidy_pools_rec IN okl_trx_subsidy_pools_rec_type,
229: x_no_data_found OUT NOCOPY BOOLEAN
230: ) RETURN okl_trx_subsidy_pools_rec_type IS
231: CURSOR okl_trx_subsidy_pools_pk_csr (p_id IN NUMBER) IS
232: SELECT
233: ID,
234: OBJECT_VERSION_NUMBER,
227: FUNCTION get_rec (
228: p_okl_trx_subsidy_pools_rec IN okl_trx_subsidy_pools_rec_type,
229: x_no_data_found OUT NOCOPY BOOLEAN
230: ) RETURN okl_trx_subsidy_pools_rec_type IS
231: CURSOR okl_trx_subsidy_pools_pk_csr (p_id IN NUMBER) IS
232: SELECT
233: ID,
234: OBJECT_VERSION_NUMBER,
235: TRX_TYPE_CODE,
267: CREATION_DATE,
268: LAST_UPDATED_BY,
269: LAST_UPDATE_DATE,
270: LAST_UPDATE_LOGIN
271: FROM Okl_Trx_Subsidy_Pools
272: WHERE okl_trx_subsidy_pools.id = p_id;
273: l_okl_trx_subsidy_pools_pk okl_trx_subsidy_pools_pk_csr%ROWTYPE;
274: l_okl_trx_subsidy_pools_rec okl_trx_subsidy_pools_rec_type;
275: BEGIN
268: LAST_UPDATED_BY,
269: LAST_UPDATE_DATE,
270: LAST_UPDATE_LOGIN
271: FROM Okl_Trx_Subsidy_Pools
272: WHERE okl_trx_subsidy_pools.id = p_id;
273: l_okl_trx_subsidy_pools_pk okl_trx_subsidy_pools_pk_csr%ROWTYPE;
274: l_okl_trx_subsidy_pools_rec okl_trx_subsidy_pools_rec_type;
275: BEGIN
276: x_no_data_found := TRUE;
269: LAST_UPDATE_DATE,
270: LAST_UPDATE_LOGIN
271: FROM Okl_Trx_Subsidy_Pools
272: WHERE okl_trx_subsidy_pools.id = p_id;
273: l_okl_trx_subsidy_pools_pk okl_trx_subsidy_pools_pk_csr%ROWTYPE;
274: l_okl_trx_subsidy_pools_rec okl_trx_subsidy_pools_rec_type;
275: BEGIN
276: x_no_data_found := TRUE;
277: -- Get current database values
270: LAST_UPDATE_LOGIN
271: FROM Okl_Trx_Subsidy_Pools
272: WHERE okl_trx_subsidy_pools.id = p_id;
273: l_okl_trx_subsidy_pools_pk okl_trx_subsidy_pools_pk_csr%ROWTYPE;
274: l_okl_trx_subsidy_pools_rec okl_trx_subsidy_pools_rec_type;
275: BEGIN
276: x_no_data_found := TRUE;
277: -- Get current database values
278: OPEN okl_trx_subsidy_pools_pk_csr (p_okl_trx_subsidy_pools_rec.id);
274: l_okl_trx_subsidy_pools_rec okl_trx_subsidy_pools_rec_type;
275: BEGIN
276: x_no_data_found := TRUE;
277: -- Get current database values
278: OPEN okl_trx_subsidy_pools_pk_csr (p_okl_trx_subsidy_pools_rec.id);
279: FETCH okl_trx_subsidy_pools_pk_csr INTO
280: l_okl_trx_subsidy_pools_rec.id,
281: l_okl_trx_subsidy_pools_rec.object_version_number,
282: l_okl_trx_subsidy_pools_rec.trx_type_code,
275: BEGIN
276: x_no_data_found := TRUE;
277: -- Get current database values
278: OPEN okl_trx_subsidy_pools_pk_csr (p_okl_trx_subsidy_pools_rec.id);
279: FETCH okl_trx_subsidy_pools_pk_csr INTO
280: l_okl_trx_subsidy_pools_rec.id,
281: l_okl_trx_subsidy_pools_rec.object_version_number,
282: l_okl_trx_subsidy_pools_rec.trx_type_code,
283: l_okl_trx_subsidy_pools_rec.source_type_code,
276: x_no_data_found := TRUE;
277: -- Get current database values
278: OPEN okl_trx_subsidy_pools_pk_csr (p_okl_trx_subsidy_pools_rec.id);
279: FETCH okl_trx_subsidy_pools_pk_csr INTO
280: l_okl_trx_subsidy_pools_rec.id,
281: l_okl_trx_subsidy_pools_rec.object_version_number,
282: l_okl_trx_subsidy_pools_rec.trx_type_code,
283: l_okl_trx_subsidy_pools_rec.source_type_code,
284: l_okl_trx_subsidy_pools_rec.source_object_id,
277: -- Get current database values
278: OPEN okl_trx_subsidy_pools_pk_csr (p_okl_trx_subsidy_pools_rec.id);
279: FETCH okl_trx_subsidy_pools_pk_csr INTO
280: l_okl_trx_subsidy_pools_rec.id,
281: l_okl_trx_subsidy_pools_rec.object_version_number,
282: l_okl_trx_subsidy_pools_rec.trx_type_code,
283: l_okl_trx_subsidy_pools_rec.source_type_code,
284: l_okl_trx_subsidy_pools_rec.source_object_id,
285: l_okl_trx_subsidy_pools_rec.subsidy_pool_id,
278: OPEN okl_trx_subsidy_pools_pk_csr (p_okl_trx_subsidy_pools_rec.id);
279: FETCH okl_trx_subsidy_pools_pk_csr INTO
280: l_okl_trx_subsidy_pools_rec.id,
281: l_okl_trx_subsidy_pools_rec.object_version_number,
282: l_okl_trx_subsidy_pools_rec.trx_type_code,
283: l_okl_trx_subsidy_pools_rec.source_type_code,
284: l_okl_trx_subsidy_pools_rec.source_object_id,
285: l_okl_trx_subsidy_pools_rec.subsidy_pool_id,
286: l_okl_trx_subsidy_pools_rec.dnz_asset_number,
279: FETCH okl_trx_subsidy_pools_pk_csr INTO
280: l_okl_trx_subsidy_pools_rec.id,
281: l_okl_trx_subsidy_pools_rec.object_version_number,
282: l_okl_trx_subsidy_pools_rec.trx_type_code,
283: l_okl_trx_subsidy_pools_rec.source_type_code,
284: l_okl_trx_subsidy_pools_rec.source_object_id,
285: l_okl_trx_subsidy_pools_rec.subsidy_pool_id,
286: l_okl_trx_subsidy_pools_rec.dnz_asset_number,
287: l_okl_trx_subsidy_pools_rec.vendor_id,
280: l_okl_trx_subsidy_pools_rec.id,
281: l_okl_trx_subsidy_pools_rec.object_version_number,
282: l_okl_trx_subsidy_pools_rec.trx_type_code,
283: l_okl_trx_subsidy_pools_rec.source_type_code,
284: l_okl_trx_subsidy_pools_rec.source_object_id,
285: l_okl_trx_subsidy_pools_rec.subsidy_pool_id,
286: l_okl_trx_subsidy_pools_rec.dnz_asset_number,
287: l_okl_trx_subsidy_pools_rec.vendor_id,
288: l_okl_trx_subsidy_pools_rec.source_trx_date,
281: l_okl_trx_subsidy_pools_rec.object_version_number,
282: l_okl_trx_subsidy_pools_rec.trx_type_code,
283: l_okl_trx_subsidy_pools_rec.source_type_code,
284: l_okl_trx_subsidy_pools_rec.source_object_id,
285: l_okl_trx_subsidy_pools_rec.subsidy_pool_id,
286: l_okl_trx_subsidy_pools_rec.dnz_asset_number,
287: l_okl_trx_subsidy_pools_rec.vendor_id,
288: l_okl_trx_subsidy_pools_rec.source_trx_date,
289: l_okl_trx_subsidy_pools_rec.trx_date,
282: l_okl_trx_subsidy_pools_rec.trx_type_code,
283: l_okl_trx_subsidy_pools_rec.source_type_code,
284: l_okl_trx_subsidy_pools_rec.source_object_id,
285: l_okl_trx_subsidy_pools_rec.subsidy_pool_id,
286: l_okl_trx_subsidy_pools_rec.dnz_asset_number,
287: l_okl_trx_subsidy_pools_rec.vendor_id,
288: l_okl_trx_subsidy_pools_rec.source_trx_date,
289: l_okl_trx_subsidy_pools_rec.trx_date,
290: l_okl_trx_subsidy_pools_rec.subsidy_id,
283: l_okl_trx_subsidy_pools_rec.source_type_code,
284: l_okl_trx_subsidy_pools_rec.source_object_id,
285: l_okl_trx_subsidy_pools_rec.subsidy_pool_id,
286: l_okl_trx_subsidy_pools_rec.dnz_asset_number,
287: l_okl_trx_subsidy_pools_rec.vendor_id,
288: l_okl_trx_subsidy_pools_rec.source_trx_date,
289: l_okl_trx_subsidy_pools_rec.trx_date,
290: l_okl_trx_subsidy_pools_rec.subsidy_id,
291: l_okl_trx_subsidy_pools_rec.trx_reason_code,
284: l_okl_trx_subsidy_pools_rec.source_object_id,
285: l_okl_trx_subsidy_pools_rec.subsidy_pool_id,
286: l_okl_trx_subsidy_pools_rec.dnz_asset_number,
287: l_okl_trx_subsidy_pools_rec.vendor_id,
288: l_okl_trx_subsidy_pools_rec.source_trx_date,
289: l_okl_trx_subsidy_pools_rec.trx_date,
290: l_okl_trx_subsidy_pools_rec.subsidy_id,
291: l_okl_trx_subsidy_pools_rec.trx_reason_code,
292: l_okl_trx_subsidy_pools_rec.trx_currency_code,
285: l_okl_trx_subsidy_pools_rec.subsidy_pool_id,
286: l_okl_trx_subsidy_pools_rec.dnz_asset_number,
287: l_okl_trx_subsidy_pools_rec.vendor_id,
288: l_okl_trx_subsidy_pools_rec.source_trx_date,
289: l_okl_trx_subsidy_pools_rec.trx_date,
290: l_okl_trx_subsidy_pools_rec.subsidy_id,
291: l_okl_trx_subsidy_pools_rec.trx_reason_code,
292: l_okl_trx_subsidy_pools_rec.trx_currency_code,
293: l_okl_trx_subsidy_pools_rec.trx_amount,
286: l_okl_trx_subsidy_pools_rec.dnz_asset_number,
287: l_okl_trx_subsidy_pools_rec.vendor_id,
288: l_okl_trx_subsidy_pools_rec.source_trx_date,
289: l_okl_trx_subsidy_pools_rec.trx_date,
290: l_okl_trx_subsidy_pools_rec.subsidy_id,
291: l_okl_trx_subsidy_pools_rec.trx_reason_code,
292: l_okl_trx_subsidy_pools_rec.trx_currency_code,
293: l_okl_trx_subsidy_pools_rec.trx_amount,
294: l_okl_trx_subsidy_pools_rec.subsidy_pool_currency_code,
287: l_okl_trx_subsidy_pools_rec.vendor_id,
288: l_okl_trx_subsidy_pools_rec.source_trx_date,
289: l_okl_trx_subsidy_pools_rec.trx_date,
290: l_okl_trx_subsidy_pools_rec.subsidy_id,
291: l_okl_trx_subsidy_pools_rec.trx_reason_code,
292: l_okl_trx_subsidy_pools_rec.trx_currency_code,
293: l_okl_trx_subsidy_pools_rec.trx_amount,
294: l_okl_trx_subsidy_pools_rec.subsidy_pool_currency_code,
295: l_okl_trx_subsidy_pools_rec.subsidy_pool_amount,
288: l_okl_trx_subsidy_pools_rec.source_trx_date,
289: l_okl_trx_subsidy_pools_rec.trx_date,
290: l_okl_trx_subsidy_pools_rec.subsidy_id,
291: l_okl_trx_subsidy_pools_rec.trx_reason_code,
292: l_okl_trx_subsidy_pools_rec.trx_currency_code,
293: l_okl_trx_subsidy_pools_rec.trx_amount,
294: l_okl_trx_subsidy_pools_rec.subsidy_pool_currency_code,
295: l_okl_trx_subsidy_pools_rec.subsidy_pool_amount,
296: l_okl_trx_subsidy_pools_rec.conversion_rate,
289: l_okl_trx_subsidy_pools_rec.trx_date,
290: l_okl_trx_subsidy_pools_rec.subsidy_id,
291: l_okl_trx_subsidy_pools_rec.trx_reason_code,
292: l_okl_trx_subsidy_pools_rec.trx_currency_code,
293: l_okl_trx_subsidy_pools_rec.trx_amount,
294: l_okl_trx_subsidy_pools_rec.subsidy_pool_currency_code,
295: l_okl_trx_subsidy_pools_rec.subsidy_pool_amount,
296: l_okl_trx_subsidy_pools_rec.conversion_rate,
297: l_okl_trx_subsidy_pools_rec.attribute_category,
290: l_okl_trx_subsidy_pools_rec.subsidy_id,
291: l_okl_trx_subsidy_pools_rec.trx_reason_code,
292: l_okl_trx_subsidy_pools_rec.trx_currency_code,
293: l_okl_trx_subsidy_pools_rec.trx_amount,
294: l_okl_trx_subsidy_pools_rec.subsidy_pool_currency_code,
295: l_okl_trx_subsidy_pools_rec.subsidy_pool_amount,
296: l_okl_trx_subsidy_pools_rec.conversion_rate,
297: l_okl_trx_subsidy_pools_rec.attribute_category,
298: l_okl_trx_subsidy_pools_rec.attribute1,
291: l_okl_trx_subsidy_pools_rec.trx_reason_code,
292: l_okl_trx_subsidy_pools_rec.trx_currency_code,
293: l_okl_trx_subsidy_pools_rec.trx_amount,
294: l_okl_trx_subsidy_pools_rec.subsidy_pool_currency_code,
295: l_okl_trx_subsidy_pools_rec.subsidy_pool_amount,
296: l_okl_trx_subsidy_pools_rec.conversion_rate,
297: l_okl_trx_subsidy_pools_rec.attribute_category,
298: l_okl_trx_subsidy_pools_rec.attribute1,
299: l_okl_trx_subsidy_pools_rec.attribute2,
292: l_okl_trx_subsidy_pools_rec.trx_currency_code,
293: l_okl_trx_subsidy_pools_rec.trx_amount,
294: l_okl_trx_subsidy_pools_rec.subsidy_pool_currency_code,
295: l_okl_trx_subsidy_pools_rec.subsidy_pool_amount,
296: l_okl_trx_subsidy_pools_rec.conversion_rate,
297: l_okl_trx_subsidy_pools_rec.attribute_category,
298: l_okl_trx_subsidy_pools_rec.attribute1,
299: l_okl_trx_subsidy_pools_rec.attribute2,
300: l_okl_trx_subsidy_pools_rec.attribute3,
293: l_okl_trx_subsidy_pools_rec.trx_amount,
294: l_okl_trx_subsidy_pools_rec.subsidy_pool_currency_code,
295: l_okl_trx_subsidy_pools_rec.subsidy_pool_amount,
296: l_okl_trx_subsidy_pools_rec.conversion_rate,
297: l_okl_trx_subsidy_pools_rec.attribute_category,
298: l_okl_trx_subsidy_pools_rec.attribute1,
299: l_okl_trx_subsidy_pools_rec.attribute2,
300: l_okl_trx_subsidy_pools_rec.attribute3,
301: l_okl_trx_subsidy_pools_rec.attribute4,
294: l_okl_trx_subsidy_pools_rec.subsidy_pool_currency_code,
295: l_okl_trx_subsidy_pools_rec.subsidy_pool_amount,
296: l_okl_trx_subsidy_pools_rec.conversion_rate,
297: l_okl_trx_subsidy_pools_rec.attribute_category,
298: l_okl_trx_subsidy_pools_rec.attribute1,
299: l_okl_trx_subsidy_pools_rec.attribute2,
300: l_okl_trx_subsidy_pools_rec.attribute3,
301: l_okl_trx_subsidy_pools_rec.attribute4,
302: l_okl_trx_subsidy_pools_rec.attribute5,
295: l_okl_trx_subsidy_pools_rec.subsidy_pool_amount,
296: l_okl_trx_subsidy_pools_rec.conversion_rate,
297: l_okl_trx_subsidy_pools_rec.attribute_category,
298: l_okl_trx_subsidy_pools_rec.attribute1,
299: l_okl_trx_subsidy_pools_rec.attribute2,
300: l_okl_trx_subsidy_pools_rec.attribute3,
301: l_okl_trx_subsidy_pools_rec.attribute4,
302: l_okl_trx_subsidy_pools_rec.attribute5,
303: l_okl_trx_subsidy_pools_rec.attribute6,
296: l_okl_trx_subsidy_pools_rec.conversion_rate,
297: l_okl_trx_subsidy_pools_rec.attribute_category,
298: l_okl_trx_subsidy_pools_rec.attribute1,
299: l_okl_trx_subsidy_pools_rec.attribute2,
300: l_okl_trx_subsidy_pools_rec.attribute3,
301: l_okl_trx_subsidy_pools_rec.attribute4,
302: l_okl_trx_subsidy_pools_rec.attribute5,
303: l_okl_trx_subsidy_pools_rec.attribute6,
304: l_okl_trx_subsidy_pools_rec.attribute7,
297: l_okl_trx_subsidy_pools_rec.attribute_category,
298: l_okl_trx_subsidy_pools_rec.attribute1,
299: l_okl_trx_subsidy_pools_rec.attribute2,
300: l_okl_trx_subsidy_pools_rec.attribute3,
301: l_okl_trx_subsidy_pools_rec.attribute4,
302: l_okl_trx_subsidy_pools_rec.attribute5,
303: l_okl_trx_subsidy_pools_rec.attribute6,
304: l_okl_trx_subsidy_pools_rec.attribute7,
305: l_okl_trx_subsidy_pools_rec.attribute8,
298: l_okl_trx_subsidy_pools_rec.attribute1,
299: l_okl_trx_subsidy_pools_rec.attribute2,
300: l_okl_trx_subsidy_pools_rec.attribute3,
301: l_okl_trx_subsidy_pools_rec.attribute4,
302: l_okl_trx_subsidy_pools_rec.attribute5,
303: l_okl_trx_subsidy_pools_rec.attribute6,
304: l_okl_trx_subsidy_pools_rec.attribute7,
305: l_okl_trx_subsidy_pools_rec.attribute8,
306: l_okl_trx_subsidy_pools_rec.attribute9,
299: l_okl_trx_subsidy_pools_rec.attribute2,
300: l_okl_trx_subsidy_pools_rec.attribute3,
301: l_okl_trx_subsidy_pools_rec.attribute4,
302: l_okl_trx_subsidy_pools_rec.attribute5,
303: l_okl_trx_subsidy_pools_rec.attribute6,
304: l_okl_trx_subsidy_pools_rec.attribute7,
305: l_okl_trx_subsidy_pools_rec.attribute8,
306: l_okl_trx_subsidy_pools_rec.attribute9,
307: l_okl_trx_subsidy_pools_rec.attribute10,
300: l_okl_trx_subsidy_pools_rec.attribute3,
301: l_okl_trx_subsidy_pools_rec.attribute4,
302: l_okl_trx_subsidy_pools_rec.attribute5,
303: l_okl_trx_subsidy_pools_rec.attribute6,
304: l_okl_trx_subsidy_pools_rec.attribute7,
305: l_okl_trx_subsidy_pools_rec.attribute8,
306: l_okl_trx_subsidy_pools_rec.attribute9,
307: l_okl_trx_subsidy_pools_rec.attribute10,
308: l_okl_trx_subsidy_pools_rec.attribute11,
301: l_okl_trx_subsidy_pools_rec.attribute4,
302: l_okl_trx_subsidy_pools_rec.attribute5,
303: l_okl_trx_subsidy_pools_rec.attribute6,
304: l_okl_trx_subsidy_pools_rec.attribute7,
305: l_okl_trx_subsidy_pools_rec.attribute8,
306: l_okl_trx_subsidy_pools_rec.attribute9,
307: l_okl_trx_subsidy_pools_rec.attribute10,
308: l_okl_trx_subsidy_pools_rec.attribute11,
309: l_okl_trx_subsidy_pools_rec.attribute12,
302: l_okl_trx_subsidy_pools_rec.attribute5,
303: l_okl_trx_subsidy_pools_rec.attribute6,
304: l_okl_trx_subsidy_pools_rec.attribute7,
305: l_okl_trx_subsidy_pools_rec.attribute8,
306: l_okl_trx_subsidy_pools_rec.attribute9,
307: l_okl_trx_subsidy_pools_rec.attribute10,
308: l_okl_trx_subsidy_pools_rec.attribute11,
309: l_okl_trx_subsidy_pools_rec.attribute12,
310: l_okl_trx_subsidy_pools_rec.attribute13,
303: l_okl_trx_subsidy_pools_rec.attribute6,
304: l_okl_trx_subsidy_pools_rec.attribute7,
305: l_okl_trx_subsidy_pools_rec.attribute8,
306: l_okl_trx_subsidy_pools_rec.attribute9,
307: l_okl_trx_subsidy_pools_rec.attribute10,
308: l_okl_trx_subsidy_pools_rec.attribute11,
309: l_okl_trx_subsidy_pools_rec.attribute12,
310: l_okl_trx_subsidy_pools_rec.attribute13,
311: l_okl_trx_subsidy_pools_rec.attribute14,
304: l_okl_trx_subsidy_pools_rec.attribute7,
305: l_okl_trx_subsidy_pools_rec.attribute8,
306: l_okl_trx_subsidy_pools_rec.attribute9,
307: l_okl_trx_subsidy_pools_rec.attribute10,
308: l_okl_trx_subsidy_pools_rec.attribute11,
309: l_okl_trx_subsidy_pools_rec.attribute12,
310: l_okl_trx_subsidy_pools_rec.attribute13,
311: l_okl_trx_subsidy_pools_rec.attribute14,
312: l_okl_trx_subsidy_pools_rec.attribute15,
305: l_okl_trx_subsidy_pools_rec.attribute8,
306: l_okl_trx_subsidy_pools_rec.attribute9,
307: l_okl_trx_subsidy_pools_rec.attribute10,
308: l_okl_trx_subsidy_pools_rec.attribute11,
309: l_okl_trx_subsidy_pools_rec.attribute12,
310: l_okl_trx_subsidy_pools_rec.attribute13,
311: l_okl_trx_subsidy_pools_rec.attribute14,
312: l_okl_trx_subsidy_pools_rec.attribute15,
313: l_okl_trx_subsidy_pools_rec.created_by,
306: l_okl_trx_subsidy_pools_rec.attribute9,
307: l_okl_trx_subsidy_pools_rec.attribute10,
308: l_okl_trx_subsidy_pools_rec.attribute11,
309: l_okl_trx_subsidy_pools_rec.attribute12,
310: l_okl_trx_subsidy_pools_rec.attribute13,
311: l_okl_trx_subsidy_pools_rec.attribute14,
312: l_okl_trx_subsidy_pools_rec.attribute15,
313: l_okl_trx_subsidy_pools_rec.created_by,
314: l_okl_trx_subsidy_pools_rec.creation_date,
307: l_okl_trx_subsidy_pools_rec.attribute10,
308: l_okl_trx_subsidy_pools_rec.attribute11,
309: l_okl_trx_subsidy_pools_rec.attribute12,
310: l_okl_trx_subsidy_pools_rec.attribute13,
311: l_okl_trx_subsidy_pools_rec.attribute14,
312: l_okl_trx_subsidy_pools_rec.attribute15,
313: l_okl_trx_subsidy_pools_rec.created_by,
314: l_okl_trx_subsidy_pools_rec.creation_date,
315: l_okl_trx_subsidy_pools_rec.last_updated_by,
308: l_okl_trx_subsidy_pools_rec.attribute11,
309: l_okl_trx_subsidy_pools_rec.attribute12,
310: l_okl_trx_subsidy_pools_rec.attribute13,
311: l_okl_trx_subsidy_pools_rec.attribute14,
312: l_okl_trx_subsidy_pools_rec.attribute15,
313: l_okl_trx_subsidy_pools_rec.created_by,
314: l_okl_trx_subsidy_pools_rec.creation_date,
315: l_okl_trx_subsidy_pools_rec.last_updated_by,
316: l_okl_trx_subsidy_pools_rec.last_update_date,
309: l_okl_trx_subsidy_pools_rec.attribute12,
310: l_okl_trx_subsidy_pools_rec.attribute13,
311: l_okl_trx_subsidy_pools_rec.attribute14,
312: l_okl_trx_subsidy_pools_rec.attribute15,
313: l_okl_trx_subsidy_pools_rec.created_by,
314: l_okl_trx_subsidy_pools_rec.creation_date,
315: l_okl_trx_subsidy_pools_rec.last_updated_by,
316: l_okl_trx_subsidy_pools_rec.last_update_date,
317: l_okl_trx_subsidy_pools_rec.last_update_login;
310: l_okl_trx_subsidy_pools_rec.attribute13,
311: l_okl_trx_subsidy_pools_rec.attribute14,
312: l_okl_trx_subsidy_pools_rec.attribute15,
313: l_okl_trx_subsidy_pools_rec.created_by,
314: l_okl_trx_subsidy_pools_rec.creation_date,
315: l_okl_trx_subsidy_pools_rec.last_updated_by,
316: l_okl_trx_subsidy_pools_rec.last_update_date,
317: l_okl_trx_subsidy_pools_rec.last_update_login;
318: x_no_data_found := okl_trx_subsidy_pools_pk_csr%NOTFOUND;
311: l_okl_trx_subsidy_pools_rec.attribute14,
312: l_okl_trx_subsidy_pools_rec.attribute15,
313: l_okl_trx_subsidy_pools_rec.created_by,
314: l_okl_trx_subsidy_pools_rec.creation_date,
315: l_okl_trx_subsidy_pools_rec.last_updated_by,
316: l_okl_trx_subsidy_pools_rec.last_update_date,
317: l_okl_trx_subsidy_pools_rec.last_update_login;
318: x_no_data_found := okl_trx_subsidy_pools_pk_csr%NOTFOUND;
319: CLOSE okl_trx_subsidy_pools_pk_csr;
312: l_okl_trx_subsidy_pools_rec.attribute15,
313: l_okl_trx_subsidy_pools_rec.created_by,
314: l_okl_trx_subsidy_pools_rec.creation_date,
315: l_okl_trx_subsidy_pools_rec.last_updated_by,
316: l_okl_trx_subsidy_pools_rec.last_update_date,
317: l_okl_trx_subsidy_pools_rec.last_update_login;
318: x_no_data_found := okl_trx_subsidy_pools_pk_csr%NOTFOUND;
319: CLOSE okl_trx_subsidy_pools_pk_csr;
320: RETURN(l_okl_trx_subsidy_pools_rec);
313: l_okl_trx_subsidy_pools_rec.created_by,
314: l_okl_trx_subsidy_pools_rec.creation_date,
315: l_okl_trx_subsidy_pools_rec.last_updated_by,
316: l_okl_trx_subsidy_pools_rec.last_update_date,
317: l_okl_trx_subsidy_pools_rec.last_update_login;
318: x_no_data_found := okl_trx_subsidy_pools_pk_csr%NOTFOUND;
319: CLOSE okl_trx_subsidy_pools_pk_csr;
320: RETURN(l_okl_trx_subsidy_pools_rec);
321: END get_rec;
314: l_okl_trx_subsidy_pools_rec.creation_date,
315: l_okl_trx_subsidy_pools_rec.last_updated_by,
316: l_okl_trx_subsidy_pools_rec.last_update_date,
317: l_okl_trx_subsidy_pools_rec.last_update_login;
318: x_no_data_found := okl_trx_subsidy_pools_pk_csr%NOTFOUND;
319: CLOSE okl_trx_subsidy_pools_pk_csr;
320: RETURN(l_okl_trx_subsidy_pools_rec);
321: END get_rec;
322:
315: l_okl_trx_subsidy_pools_rec.last_updated_by,
316: l_okl_trx_subsidy_pools_rec.last_update_date,
317: l_okl_trx_subsidy_pools_rec.last_update_login;
318: x_no_data_found := okl_trx_subsidy_pools_pk_csr%NOTFOUND;
319: CLOSE okl_trx_subsidy_pools_pk_csr;
320: RETURN(l_okl_trx_subsidy_pools_rec);
321: END get_rec;
322:
323: ------------------------------------------------------------------
316: l_okl_trx_subsidy_pools_rec.last_update_date,
317: l_okl_trx_subsidy_pools_rec.last_update_login;
318: x_no_data_found := okl_trx_subsidy_pools_pk_csr%NOTFOUND;
319: CLOSE okl_trx_subsidy_pools_pk_csr;
320: RETURN(l_okl_trx_subsidy_pools_rec);
321: END get_rec;
322:
323: ------------------------------------------------------------------
324: -- This version of get_rec sets error messages if no data found --
323: ------------------------------------------------------------------
324: -- This version of get_rec sets error messages if no data found --
325: ------------------------------------------------------------------
326: FUNCTION get_rec (
327: p_okl_trx_subsidy_pools_rec IN okl_trx_subsidy_pools_rec_type,
328: x_return_status OUT NOCOPY VARCHAR2
329: ) RETURN okl_trx_subsidy_pools_rec_type IS
330: l_okl_trx_subsidy_pools_rec okl_trx_subsidy_pools_rec_type;
331: l_row_notfound BOOLEAN := TRUE;
325: ------------------------------------------------------------------
326: FUNCTION get_rec (
327: p_okl_trx_subsidy_pools_rec IN okl_trx_subsidy_pools_rec_type,
328: x_return_status OUT NOCOPY VARCHAR2
329: ) RETURN okl_trx_subsidy_pools_rec_type IS
330: l_okl_trx_subsidy_pools_rec okl_trx_subsidy_pools_rec_type;
331: l_row_notfound BOOLEAN := TRUE;
332: BEGIN
333: x_return_status := OKC_API.G_RET_STS_SUCCESS;
326: FUNCTION get_rec (
327: p_okl_trx_subsidy_pools_rec IN okl_trx_subsidy_pools_rec_type,
328: x_return_status OUT NOCOPY VARCHAR2
329: ) RETURN okl_trx_subsidy_pools_rec_type IS
330: l_okl_trx_subsidy_pools_rec okl_trx_subsidy_pools_rec_type;
331: l_row_notfound BOOLEAN := TRUE;
332: BEGIN
333: x_return_status := OKC_API.G_RET_STS_SUCCESS;
334: l_okl_trx_subsidy_pools_rec := get_rec(p_okl_trx_subsidy_pools_rec, l_row_notfound);
330: l_okl_trx_subsidy_pools_rec okl_trx_subsidy_pools_rec_type;
331: l_row_notfound BOOLEAN := TRUE;
332: BEGIN
333: x_return_status := OKC_API.G_RET_STS_SUCCESS;
334: l_okl_trx_subsidy_pools_rec := get_rec(p_okl_trx_subsidy_pools_rec, l_row_notfound);
335: IF (l_row_notfound) THEN
336: OKC_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'ID');
337: x_return_status := OKC_API.G_RET_STS_ERROR;
338: END IF;
335: IF (l_row_notfound) THEN
336: OKC_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'ID');
337: x_return_status := OKC_API.G_RET_STS_ERROR;
338: END IF;
339: RETURN(l_okl_trx_subsidy_pools_rec);
340: END get_rec;
341: -----------------------------------------------------------
342: -- So we don't have to pass an "l_row_notfound" variable --
343: -----------------------------------------------------------
341: -----------------------------------------------------------
342: -- So we don't have to pass an "l_row_notfound" variable --
343: -----------------------------------------------------------
344: FUNCTION get_rec (
345: p_okl_trx_subsidy_pools_rec IN okl_trx_subsidy_pools_rec_type
346: ) RETURN okl_trx_subsidy_pools_rec_type IS
347: l_row_not_found BOOLEAN := TRUE;
348: BEGIN
349: RETURN(get_rec(p_okl_trx_subsidy_pools_rec, l_row_not_found));
342: -- So we don't have to pass an "l_row_notfound" variable --
343: -----------------------------------------------------------
344: FUNCTION get_rec (
345: p_okl_trx_subsidy_pools_rec IN okl_trx_subsidy_pools_rec_type
346: ) RETURN okl_trx_subsidy_pools_rec_type IS
347: l_row_not_found BOOLEAN := TRUE;
348: BEGIN
349: RETURN(get_rec(p_okl_trx_subsidy_pools_rec, l_row_not_found));
350: END get_rec;
345: p_okl_trx_subsidy_pools_rec IN okl_trx_subsidy_pools_rec_type
346: ) RETURN okl_trx_subsidy_pools_rec_type IS
347: l_row_not_found BOOLEAN := TRUE;
348: BEGIN
349: RETURN(get_rec(p_okl_trx_subsidy_pools_rec, l_row_not_found));
350: END get_rec;
351: ---------------------------------------------------------------------------
352: -- FUNCTION null_out_defaults for: OKL_TRX_SUBSIDY_POOLS_V
353: ---------------------------------------------------------------------------
348: BEGIN
349: RETURN(get_rec(p_okl_trx_subsidy_pools_rec, l_row_not_found));
350: END get_rec;
351: ---------------------------------------------------------------------------
352: -- FUNCTION null_out_defaults for: OKL_TRX_SUBSIDY_POOLS_V
353: ---------------------------------------------------------------------------
354: FUNCTION null_out_defaults (
355: p_sixv_rec IN sixv_rec_type
356: ) RETURN sixv_rec_type IS
982: ---------------------------------------------------------------------------
983: -- FUNCTION Validate_Attributes
984: ---------------------------------------------------------------------------
985: -----------------------------------------------------
986: -- Validate_Attributes for:OKL_TRX_SUBSIDY_POOLS_V --
987: -----------------------------------------------------
988: FUNCTION Validate_Attributes (
989: p_sixv_rec IN sixv_rec_type
990: ) RETURN VARCHAR2 IS
998: -- ***
999: -- id
1000: -- ***
1001: -- sjalasut: commented for subsidy pools enhancements
1002: -- for okl_trx_subsidy_pools, data is always inserted and never updated or deleted
1003: -- therefore validate_id and validate_object_version number are hampring other validation logic
1004: --validate_id(x_return_status, p_sixv_rec.id);
1005: --IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1006: --l_return_status := x_return_status;
1162: ---------------------------------------------------------------------------
1163: -- PROCEDURE Validate_Record
1164: ---------------------------------------------------------------------------
1165: -------------------------------------------------
1166: -- Validate Record for:OKL_TRX_SUBSIDY_POOLS_V --
1167: -------------------------------------------------
1168: FUNCTION Validate_Record (
1169: p_sixv_rec IN sixv_rec_type,
1170: p_db_sixv_rec IN sixv_rec_type
1223: -- PROCEDURE Migrate
1224: ---------------------------------------------------------------------------
1225: PROCEDURE migrate (
1226: p_from IN sixv_rec_type,
1227: p_to IN OUT NOCOPY okl_trx_subsidy_pools_rec_type
1228: ) IS
1229: BEGIN
1230: p_to.id := p_from.id;
1231: p_to.object_version_number := p_from.object_version_number;
1266: p_to.last_update_date := p_from.last_update_date;
1267: p_to.last_update_login := p_from.last_update_login;
1268: END migrate;
1269: PROCEDURE migrate (
1270: p_from IN okl_trx_subsidy_pools_rec_type,
1271: p_to IN OUT NOCOPY sixv_rec_type
1272: ) IS
1273: BEGIN
1274: p_to.id := p_from.id;
1313: ---------------------------------------------------------------------------
1314: -- PROCEDURE validate_row
1315: ---------------------------------------------------------------------------
1316: ----------------------------------------------
1317: -- validate_row for:OKL_TRX_SUBSIDY_POOLS_V --
1318: ----------------------------------------------
1319: PROCEDURE validate_row(
1320: p_api_version IN NUMBER,
1321: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1327: l_api_version CONSTANT NUMBER := 1;
1328: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
1329: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1330: l_sixv_rec sixv_rec_type := p_sixv_rec;
1331: l_okl_trx_subsidy_pools_rec okl_trx_subsidy_pools_rec_type;
1332: l_okl_trx_subsidy_pools_rec okl_trx_subsidy_pools_rec_type;
1333: BEGIN
1334: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1335: G_PKG_NAME,
1328: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
1329: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1330: l_sixv_rec sixv_rec_type := p_sixv_rec;
1331: l_okl_trx_subsidy_pools_rec okl_trx_subsidy_pools_rec_type;
1332: l_okl_trx_subsidy_pools_rec okl_trx_subsidy_pools_rec_type;
1333: BEGIN
1334: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1335: G_PKG_NAME,
1336: p_init_msg_list,
1390: '_PVT'
1391: );
1392: END validate_row;
1393: ---------------------------------------------------------
1394: -- PL/SQL TBL validate_row for:OKL_TRX_SUBSIDY_POOLS_V --
1395: ---------------------------------------------------------
1396: PROCEDURE validate_row(
1397: p_api_version IN NUMBER,
1398: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1486: );
1487: END validate_row;
1488:
1489: ---------------------------------------------------------
1490: -- PL/SQL TBL validate_row for:OKL_TRX_SUBSIDY_POOLS_V --
1491: ---------------------------------------------------------
1492: PROCEDURE validate_row(
1493: p_api_version IN NUMBER,
1494: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1551: ---------------------------------------------------------------------------
1552: -- PROCEDURE insert_row
1553: ---------------------------------------------------------------------------
1554: ------------------------------------------
1555: -- insert_row for:OKL_TRX_SUBSIDY_POOLS --
1556: ------------------------------------------
1557: PROCEDURE insert_row(
1558: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1559: x_return_status OUT NOCOPY VARCHAR2,
1558: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1559: x_return_status OUT NOCOPY VARCHAR2,
1560: x_msg_count OUT NOCOPY NUMBER,
1561: x_msg_data OUT NOCOPY VARCHAR2,
1562: p_okl_trx_subsidy_pools_rec IN okl_trx_subsidy_pools_rec_type,
1563: x_okl_trx_subsidy_pools_rec OUT NOCOPY okl_trx_subsidy_pools_rec_type) IS
1564:
1565: l_api_version CONSTANT NUMBER := 1;
1566: l_api_name CONSTANT VARCHAR2(30) := 'B_insert_row';
1559: x_return_status OUT NOCOPY VARCHAR2,
1560: x_msg_count OUT NOCOPY NUMBER,
1561: x_msg_data OUT NOCOPY VARCHAR2,
1562: p_okl_trx_subsidy_pools_rec IN okl_trx_subsidy_pools_rec_type,
1563: x_okl_trx_subsidy_pools_rec OUT NOCOPY okl_trx_subsidy_pools_rec_type) IS
1564:
1565: l_api_version CONSTANT NUMBER := 1;
1566: l_api_name CONSTANT VARCHAR2(30) := 'B_insert_row';
1567: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1564:
1565: l_api_version CONSTANT NUMBER := 1;
1566: l_api_name CONSTANT VARCHAR2(30) := 'B_insert_row';
1567: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1568: l_okl_trx_subsidy_pools_rec okl_trx_subsidy_pools_rec_type := p_okl_trx_subsidy_pools_rec;
1569: LDefOklTrxSubsidyPoolsRec okl_trx_subsidy_pools_rec_type;
1570: ----------------------------------------------
1571: -- Set_Attributes for:OKL_TRX_SUBSIDY_POOLS --
1572: ----------------------------------------------
1565: l_api_version CONSTANT NUMBER := 1;
1566: l_api_name CONSTANT VARCHAR2(30) := 'B_insert_row';
1567: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1568: l_okl_trx_subsidy_pools_rec okl_trx_subsidy_pools_rec_type := p_okl_trx_subsidy_pools_rec;
1569: LDefOklTrxSubsidyPoolsRec okl_trx_subsidy_pools_rec_type;
1570: ----------------------------------------------
1571: -- Set_Attributes for:OKL_TRX_SUBSIDY_POOLS --
1572: ----------------------------------------------
1573: FUNCTION Set_Attributes (
1567: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1568: l_okl_trx_subsidy_pools_rec okl_trx_subsidy_pools_rec_type := p_okl_trx_subsidy_pools_rec;
1569: LDefOklTrxSubsidyPoolsRec okl_trx_subsidy_pools_rec_type;
1570: ----------------------------------------------
1571: -- Set_Attributes for:OKL_TRX_SUBSIDY_POOLS --
1572: ----------------------------------------------
1573: FUNCTION Set_Attributes (
1574: p_okl_trx_subsidy_pools_rec IN okl_trx_subsidy_pools_rec_type,
1575: x_okl_trx_subsidy_pools_rec OUT NOCOPY okl_trx_subsidy_pools_rec_type
1570: ----------------------------------------------
1571: -- Set_Attributes for:OKL_TRX_SUBSIDY_POOLS --
1572: ----------------------------------------------
1573: FUNCTION Set_Attributes (
1574: p_okl_trx_subsidy_pools_rec IN okl_trx_subsidy_pools_rec_type,
1575: x_okl_trx_subsidy_pools_rec OUT NOCOPY okl_trx_subsidy_pools_rec_type
1576: ) RETURN VARCHAR2 IS
1577: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1578: BEGIN
1571: -- Set_Attributes for:OKL_TRX_SUBSIDY_POOLS --
1572: ----------------------------------------------
1573: FUNCTION Set_Attributes (
1574: p_okl_trx_subsidy_pools_rec IN okl_trx_subsidy_pools_rec_type,
1575: x_okl_trx_subsidy_pools_rec OUT NOCOPY okl_trx_subsidy_pools_rec_type
1576: ) RETURN VARCHAR2 IS
1577: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1578: BEGIN
1579: x_okl_trx_subsidy_pools_rec := p_okl_trx_subsidy_pools_rec;
1575: x_okl_trx_subsidy_pools_rec OUT NOCOPY okl_trx_subsidy_pools_rec_type
1576: ) RETURN VARCHAR2 IS
1577: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1578: BEGIN
1579: x_okl_trx_subsidy_pools_rec := p_okl_trx_subsidy_pools_rec;
1580: RETURN(l_return_status);
1581: END Set_Attributes;
1582: BEGIN
1583: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1590: RAISE OKC_API.G_EXCEPTION_ERROR;
1591: END IF;
1592: --- Setting item atributes
1593: l_return_status := Set_Attributes(
1594: p_okl_trx_subsidy_pools_rec, -- IN
1595: l_okl_trx_subsidy_pools_rec); -- OUT
1596: --- If any errors happen abort API
1597: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1598: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1591: END IF;
1592: --- Setting item atributes
1593: l_return_status := Set_Attributes(
1594: p_okl_trx_subsidy_pools_rec, -- IN
1595: l_okl_trx_subsidy_pools_rec); -- OUT
1596: --- If any errors happen abort API
1597: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1598: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1599: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1598: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1599: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1600: RAISE OKC_API.G_EXCEPTION_ERROR;
1601: END IF;
1602: INSERT INTO OKL_TRX_SUBSIDY_POOLS(
1603: id,
1604: object_version_number,
1605: trx_type_code,
1606: source_type_code,
1638: last_updated_by,
1639: last_update_date,
1640: last_update_login)
1641: VALUES (
1642: l_okl_trx_subsidy_pools_rec.id,
1643: l_okl_trx_subsidy_pools_rec.object_version_number,
1644: l_okl_trx_subsidy_pools_rec.trx_type_code,
1645: l_okl_trx_subsidy_pools_rec.source_type_code,
1646: l_okl_trx_subsidy_pools_rec.source_object_id,
1639: last_update_date,
1640: last_update_login)
1641: VALUES (
1642: l_okl_trx_subsidy_pools_rec.id,
1643: l_okl_trx_subsidy_pools_rec.object_version_number,
1644: l_okl_trx_subsidy_pools_rec.trx_type_code,
1645: l_okl_trx_subsidy_pools_rec.source_type_code,
1646: l_okl_trx_subsidy_pools_rec.source_object_id,
1647: l_okl_trx_subsidy_pools_rec.subsidy_pool_id,
1640: last_update_login)
1641: VALUES (
1642: l_okl_trx_subsidy_pools_rec.id,
1643: l_okl_trx_subsidy_pools_rec.object_version_number,
1644: l_okl_trx_subsidy_pools_rec.trx_type_code,
1645: l_okl_trx_subsidy_pools_rec.source_type_code,
1646: l_okl_trx_subsidy_pools_rec.source_object_id,
1647: l_okl_trx_subsidy_pools_rec.subsidy_pool_id,
1648: l_okl_trx_subsidy_pools_rec.dnz_asset_number,
1641: VALUES (
1642: l_okl_trx_subsidy_pools_rec.id,
1643: l_okl_trx_subsidy_pools_rec.object_version_number,
1644: l_okl_trx_subsidy_pools_rec.trx_type_code,
1645: l_okl_trx_subsidy_pools_rec.source_type_code,
1646: l_okl_trx_subsidy_pools_rec.source_object_id,
1647: l_okl_trx_subsidy_pools_rec.subsidy_pool_id,
1648: l_okl_trx_subsidy_pools_rec.dnz_asset_number,
1649: l_okl_trx_subsidy_pools_rec.vendor_id,
1642: l_okl_trx_subsidy_pools_rec.id,
1643: l_okl_trx_subsidy_pools_rec.object_version_number,
1644: l_okl_trx_subsidy_pools_rec.trx_type_code,
1645: l_okl_trx_subsidy_pools_rec.source_type_code,
1646: l_okl_trx_subsidy_pools_rec.source_object_id,
1647: l_okl_trx_subsidy_pools_rec.subsidy_pool_id,
1648: l_okl_trx_subsidy_pools_rec.dnz_asset_number,
1649: l_okl_trx_subsidy_pools_rec.vendor_id,
1650: l_okl_trx_subsidy_pools_rec.source_trx_date,
1643: l_okl_trx_subsidy_pools_rec.object_version_number,
1644: l_okl_trx_subsidy_pools_rec.trx_type_code,
1645: l_okl_trx_subsidy_pools_rec.source_type_code,
1646: l_okl_trx_subsidy_pools_rec.source_object_id,
1647: l_okl_trx_subsidy_pools_rec.subsidy_pool_id,
1648: l_okl_trx_subsidy_pools_rec.dnz_asset_number,
1649: l_okl_trx_subsidy_pools_rec.vendor_id,
1650: l_okl_trx_subsidy_pools_rec.source_trx_date,
1651: l_okl_trx_subsidy_pools_rec.trx_date,
1644: l_okl_trx_subsidy_pools_rec.trx_type_code,
1645: l_okl_trx_subsidy_pools_rec.source_type_code,
1646: l_okl_trx_subsidy_pools_rec.source_object_id,
1647: l_okl_trx_subsidy_pools_rec.subsidy_pool_id,
1648: l_okl_trx_subsidy_pools_rec.dnz_asset_number,
1649: l_okl_trx_subsidy_pools_rec.vendor_id,
1650: l_okl_trx_subsidy_pools_rec.source_trx_date,
1651: l_okl_trx_subsidy_pools_rec.trx_date,
1652: l_okl_trx_subsidy_pools_rec.subsidy_id,
1645: l_okl_trx_subsidy_pools_rec.source_type_code,
1646: l_okl_trx_subsidy_pools_rec.source_object_id,
1647: l_okl_trx_subsidy_pools_rec.subsidy_pool_id,
1648: l_okl_trx_subsidy_pools_rec.dnz_asset_number,
1649: l_okl_trx_subsidy_pools_rec.vendor_id,
1650: l_okl_trx_subsidy_pools_rec.source_trx_date,
1651: l_okl_trx_subsidy_pools_rec.trx_date,
1652: l_okl_trx_subsidy_pools_rec.subsidy_id,
1653: l_okl_trx_subsidy_pools_rec.trx_reason_code,
1646: l_okl_trx_subsidy_pools_rec.source_object_id,
1647: l_okl_trx_subsidy_pools_rec.subsidy_pool_id,
1648: l_okl_trx_subsidy_pools_rec.dnz_asset_number,
1649: l_okl_trx_subsidy_pools_rec.vendor_id,
1650: l_okl_trx_subsidy_pools_rec.source_trx_date,
1651: l_okl_trx_subsidy_pools_rec.trx_date,
1652: l_okl_trx_subsidy_pools_rec.subsidy_id,
1653: l_okl_trx_subsidy_pools_rec.trx_reason_code,
1654: l_okl_trx_subsidy_pools_rec.trx_currency_code,
1647: l_okl_trx_subsidy_pools_rec.subsidy_pool_id,
1648: l_okl_trx_subsidy_pools_rec.dnz_asset_number,
1649: l_okl_trx_subsidy_pools_rec.vendor_id,
1650: l_okl_trx_subsidy_pools_rec.source_trx_date,
1651: l_okl_trx_subsidy_pools_rec.trx_date,
1652: l_okl_trx_subsidy_pools_rec.subsidy_id,
1653: l_okl_trx_subsidy_pools_rec.trx_reason_code,
1654: l_okl_trx_subsidy_pools_rec.trx_currency_code,
1655: l_okl_trx_subsidy_pools_rec.trx_amount,
1648: l_okl_trx_subsidy_pools_rec.dnz_asset_number,
1649: l_okl_trx_subsidy_pools_rec.vendor_id,
1650: l_okl_trx_subsidy_pools_rec.source_trx_date,
1651: l_okl_trx_subsidy_pools_rec.trx_date,
1652: l_okl_trx_subsidy_pools_rec.subsidy_id,
1653: l_okl_trx_subsidy_pools_rec.trx_reason_code,
1654: l_okl_trx_subsidy_pools_rec.trx_currency_code,
1655: l_okl_trx_subsidy_pools_rec.trx_amount,
1656: l_okl_trx_subsidy_pools_rec.subsidy_pool_currency_code,
1649: l_okl_trx_subsidy_pools_rec.vendor_id,
1650: l_okl_trx_subsidy_pools_rec.source_trx_date,
1651: l_okl_trx_subsidy_pools_rec.trx_date,
1652: l_okl_trx_subsidy_pools_rec.subsidy_id,
1653: l_okl_trx_subsidy_pools_rec.trx_reason_code,
1654: l_okl_trx_subsidy_pools_rec.trx_currency_code,
1655: l_okl_trx_subsidy_pools_rec.trx_amount,
1656: l_okl_trx_subsidy_pools_rec.subsidy_pool_currency_code,
1657: l_okl_trx_subsidy_pools_rec.subsidy_pool_amount,
1650: l_okl_trx_subsidy_pools_rec.source_trx_date,
1651: l_okl_trx_subsidy_pools_rec.trx_date,
1652: l_okl_trx_subsidy_pools_rec.subsidy_id,
1653: l_okl_trx_subsidy_pools_rec.trx_reason_code,
1654: l_okl_trx_subsidy_pools_rec.trx_currency_code,
1655: l_okl_trx_subsidy_pools_rec.trx_amount,
1656: l_okl_trx_subsidy_pools_rec.subsidy_pool_currency_code,
1657: l_okl_trx_subsidy_pools_rec.subsidy_pool_amount,
1658: l_okl_trx_subsidy_pools_rec.conversion_rate,
1651: l_okl_trx_subsidy_pools_rec.trx_date,
1652: l_okl_trx_subsidy_pools_rec.subsidy_id,
1653: l_okl_trx_subsidy_pools_rec.trx_reason_code,
1654: l_okl_trx_subsidy_pools_rec.trx_currency_code,
1655: l_okl_trx_subsidy_pools_rec.trx_amount,
1656: l_okl_trx_subsidy_pools_rec.subsidy_pool_currency_code,
1657: l_okl_trx_subsidy_pools_rec.subsidy_pool_amount,
1658: l_okl_trx_subsidy_pools_rec.conversion_rate,
1659: l_okl_trx_subsidy_pools_rec.attribute_category,
1652: l_okl_trx_subsidy_pools_rec.subsidy_id,
1653: l_okl_trx_subsidy_pools_rec.trx_reason_code,
1654: l_okl_trx_subsidy_pools_rec.trx_currency_code,
1655: l_okl_trx_subsidy_pools_rec.trx_amount,
1656: l_okl_trx_subsidy_pools_rec.subsidy_pool_currency_code,
1657: l_okl_trx_subsidy_pools_rec.subsidy_pool_amount,
1658: l_okl_trx_subsidy_pools_rec.conversion_rate,
1659: l_okl_trx_subsidy_pools_rec.attribute_category,
1660: l_okl_trx_subsidy_pools_rec.attribute1,
1653: l_okl_trx_subsidy_pools_rec.trx_reason_code,
1654: l_okl_trx_subsidy_pools_rec.trx_currency_code,
1655: l_okl_trx_subsidy_pools_rec.trx_amount,
1656: l_okl_trx_subsidy_pools_rec.subsidy_pool_currency_code,
1657: l_okl_trx_subsidy_pools_rec.subsidy_pool_amount,
1658: l_okl_trx_subsidy_pools_rec.conversion_rate,
1659: l_okl_trx_subsidy_pools_rec.attribute_category,
1660: l_okl_trx_subsidy_pools_rec.attribute1,
1661: l_okl_trx_subsidy_pools_rec.attribute2,
1654: l_okl_trx_subsidy_pools_rec.trx_currency_code,
1655: l_okl_trx_subsidy_pools_rec.trx_amount,
1656: l_okl_trx_subsidy_pools_rec.subsidy_pool_currency_code,
1657: l_okl_trx_subsidy_pools_rec.subsidy_pool_amount,
1658: l_okl_trx_subsidy_pools_rec.conversion_rate,
1659: l_okl_trx_subsidy_pools_rec.attribute_category,
1660: l_okl_trx_subsidy_pools_rec.attribute1,
1661: l_okl_trx_subsidy_pools_rec.attribute2,
1662: l_okl_trx_subsidy_pools_rec.attribute3,
1655: l_okl_trx_subsidy_pools_rec.trx_amount,
1656: l_okl_trx_subsidy_pools_rec.subsidy_pool_currency_code,
1657: l_okl_trx_subsidy_pools_rec.subsidy_pool_amount,
1658: l_okl_trx_subsidy_pools_rec.conversion_rate,
1659: l_okl_trx_subsidy_pools_rec.attribute_category,
1660: l_okl_trx_subsidy_pools_rec.attribute1,
1661: l_okl_trx_subsidy_pools_rec.attribute2,
1662: l_okl_trx_subsidy_pools_rec.attribute3,
1663: l_okl_trx_subsidy_pools_rec.attribute4,
1656: l_okl_trx_subsidy_pools_rec.subsidy_pool_currency_code,
1657: l_okl_trx_subsidy_pools_rec.subsidy_pool_amount,
1658: l_okl_trx_subsidy_pools_rec.conversion_rate,
1659: l_okl_trx_subsidy_pools_rec.attribute_category,
1660: l_okl_trx_subsidy_pools_rec.attribute1,
1661: l_okl_trx_subsidy_pools_rec.attribute2,
1662: l_okl_trx_subsidy_pools_rec.attribute3,
1663: l_okl_trx_subsidy_pools_rec.attribute4,
1664: l_okl_trx_subsidy_pools_rec.attribute5,
1657: l_okl_trx_subsidy_pools_rec.subsidy_pool_amount,
1658: l_okl_trx_subsidy_pools_rec.conversion_rate,
1659: l_okl_trx_subsidy_pools_rec.attribute_category,
1660: l_okl_trx_subsidy_pools_rec.attribute1,
1661: l_okl_trx_subsidy_pools_rec.attribute2,
1662: l_okl_trx_subsidy_pools_rec.attribute3,
1663: l_okl_trx_subsidy_pools_rec.attribute4,
1664: l_okl_trx_subsidy_pools_rec.attribute5,
1665: l_okl_trx_subsidy_pools_rec.attribute6,
1658: l_okl_trx_subsidy_pools_rec.conversion_rate,
1659: l_okl_trx_subsidy_pools_rec.attribute_category,
1660: l_okl_trx_subsidy_pools_rec.attribute1,
1661: l_okl_trx_subsidy_pools_rec.attribute2,
1662: l_okl_trx_subsidy_pools_rec.attribute3,
1663: l_okl_trx_subsidy_pools_rec.attribute4,
1664: l_okl_trx_subsidy_pools_rec.attribute5,
1665: l_okl_trx_subsidy_pools_rec.attribute6,
1666: l_okl_trx_subsidy_pools_rec.attribute7,
1659: l_okl_trx_subsidy_pools_rec.attribute_category,
1660: l_okl_trx_subsidy_pools_rec.attribute1,
1661: l_okl_trx_subsidy_pools_rec.attribute2,
1662: l_okl_trx_subsidy_pools_rec.attribute3,
1663: l_okl_trx_subsidy_pools_rec.attribute4,
1664: l_okl_trx_subsidy_pools_rec.attribute5,
1665: l_okl_trx_subsidy_pools_rec.attribute6,
1666: l_okl_trx_subsidy_pools_rec.attribute7,
1667: l_okl_trx_subsidy_pools_rec.attribute8,
1660: l_okl_trx_subsidy_pools_rec.attribute1,
1661: l_okl_trx_subsidy_pools_rec.attribute2,
1662: l_okl_trx_subsidy_pools_rec.attribute3,
1663: l_okl_trx_subsidy_pools_rec.attribute4,
1664: l_okl_trx_subsidy_pools_rec.attribute5,
1665: l_okl_trx_subsidy_pools_rec.attribute6,
1666: l_okl_trx_subsidy_pools_rec.attribute7,
1667: l_okl_trx_subsidy_pools_rec.attribute8,
1668: l_okl_trx_subsidy_pools_rec.attribute9,
1661: l_okl_trx_subsidy_pools_rec.attribute2,
1662: l_okl_trx_subsidy_pools_rec.attribute3,
1663: l_okl_trx_subsidy_pools_rec.attribute4,
1664: l_okl_trx_subsidy_pools_rec.attribute5,
1665: l_okl_trx_subsidy_pools_rec.attribute6,
1666: l_okl_trx_subsidy_pools_rec.attribute7,
1667: l_okl_trx_subsidy_pools_rec.attribute8,
1668: l_okl_trx_subsidy_pools_rec.attribute9,
1669: l_okl_trx_subsidy_pools_rec.attribute10,
1662: l_okl_trx_subsidy_pools_rec.attribute3,
1663: l_okl_trx_subsidy_pools_rec.attribute4,
1664: l_okl_trx_subsidy_pools_rec.attribute5,
1665: l_okl_trx_subsidy_pools_rec.attribute6,
1666: l_okl_trx_subsidy_pools_rec.attribute7,
1667: l_okl_trx_subsidy_pools_rec.attribute8,
1668: l_okl_trx_subsidy_pools_rec.attribute9,
1669: l_okl_trx_subsidy_pools_rec.attribute10,
1670: l_okl_trx_subsidy_pools_rec.attribute11,
1663: l_okl_trx_subsidy_pools_rec.attribute4,
1664: l_okl_trx_subsidy_pools_rec.attribute5,
1665: l_okl_trx_subsidy_pools_rec.attribute6,
1666: l_okl_trx_subsidy_pools_rec.attribute7,
1667: l_okl_trx_subsidy_pools_rec.attribute8,
1668: l_okl_trx_subsidy_pools_rec.attribute9,
1669: l_okl_trx_subsidy_pools_rec.attribute10,
1670: l_okl_trx_subsidy_pools_rec.attribute11,
1671: l_okl_trx_subsidy_pools_rec.attribute12,
1664: l_okl_trx_subsidy_pools_rec.attribute5,
1665: l_okl_trx_subsidy_pools_rec.attribute6,
1666: l_okl_trx_subsidy_pools_rec.attribute7,
1667: l_okl_trx_subsidy_pools_rec.attribute8,
1668: l_okl_trx_subsidy_pools_rec.attribute9,
1669: l_okl_trx_subsidy_pools_rec.attribute10,
1670: l_okl_trx_subsidy_pools_rec.attribute11,
1671: l_okl_trx_subsidy_pools_rec.attribute12,
1672: l_okl_trx_subsidy_pools_rec.attribute13,
1665: l_okl_trx_subsidy_pools_rec.attribute6,
1666: l_okl_trx_subsidy_pools_rec.attribute7,
1667: l_okl_trx_subsidy_pools_rec.attribute8,
1668: l_okl_trx_subsidy_pools_rec.attribute9,
1669: l_okl_trx_subsidy_pools_rec.attribute10,
1670: l_okl_trx_subsidy_pools_rec.attribute11,
1671: l_okl_trx_subsidy_pools_rec.attribute12,
1672: l_okl_trx_subsidy_pools_rec.attribute13,
1673: l_okl_trx_subsidy_pools_rec.attribute14,
1666: l_okl_trx_subsidy_pools_rec.attribute7,
1667: l_okl_trx_subsidy_pools_rec.attribute8,
1668: l_okl_trx_subsidy_pools_rec.attribute9,
1669: l_okl_trx_subsidy_pools_rec.attribute10,
1670: l_okl_trx_subsidy_pools_rec.attribute11,
1671: l_okl_trx_subsidy_pools_rec.attribute12,
1672: l_okl_trx_subsidy_pools_rec.attribute13,
1673: l_okl_trx_subsidy_pools_rec.attribute14,
1674: l_okl_trx_subsidy_pools_rec.attribute15,
1667: l_okl_trx_subsidy_pools_rec.attribute8,
1668: l_okl_trx_subsidy_pools_rec.attribute9,
1669: l_okl_trx_subsidy_pools_rec.attribute10,
1670: l_okl_trx_subsidy_pools_rec.attribute11,
1671: l_okl_trx_subsidy_pools_rec.attribute12,
1672: l_okl_trx_subsidy_pools_rec.attribute13,
1673: l_okl_trx_subsidy_pools_rec.attribute14,
1674: l_okl_trx_subsidy_pools_rec.attribute15,
1675: l_okl_trx_subsidy_pools_rec.created_by,
1668: l_okl_trx_subsidy_pools_rec.attribute9,
1669: l_okl_trx_subsidy_pools_rec.attribute10,
1670: l_okl_trx_subsidy_pools_rec.attribute11,
1671: l_okl_trx_subsidy_pools_rec.attribute12,
1672: l_okl_trx_subsidy_pools_rec.attribute13,
1673: l_okl_trx_subsidy_pools_rec.attribute14,
1674: l_okl_trx_subsidy_pools_rec.attribute15,
1675: l_okl_trx_subsidy_pools_rec.created_by,
1676: l_okl_trx_subsidy_pools_rec.creation_date,
1669: l_okl_trx_subsidy_pools_rec.attribute10,
1670: l_okl_trx_subsidy_pools_rec.attribute11,
1671: l_okl_trx_subsidy_pools_rec.attribute12,
1672: l_okl_trx_subsidy_pools_rec.attribute13,
1673: l_okl_trx_subsidy_pools_rec.attribute14,
1674: l_okl_trx_subsidy_pools_rec.attribute15,
1675: l_okl_trx_subsidy_pools_rec.created_by,
1676: l_okl_trx_subsidy_pools_rec.creation_date,
1677: l_okl_trx_subsidy_pools_rec.last_updated_by,
1670: l_okl_trx_subsidy_pools_rec.attribute11,
1671: l_okl_trx_subsidy_pools_rec.attribute12,
1672: l_okl_trx_subsidy_pools_rec.attribute13,
1673: l_okl_trx_subsidy_pools_rec.attribute14,
1674: l_okl_trx_subsidy_pools_rec.attribute15,
1675: l_okl_trx_subsidy_pools_rec.created_by,
1676: l_okl_trx_subsidy_pools_rec.creation_date,
1677: l_okl_trx_subsidy_pools_rec.last_updated_by,
1678: l_okl_trx_subsidy_pools_rec.last_update_date,
1671: l_okl_trx_subsidy_pools_rec.attribute12,
1672: l_okl_trx_subsidy_pools_rec.attribute13,
1673: l_okl_trx_subsidy_pools_rec.attribute14,
1674: l_okl_trx_subsidy_pools_rec.attribute15,
1675: l_okl_trx_subsidy_pools_rec.created_by,
1676: l_okl_trx_subsidy_pools_rec.creation_date,
1677: l_okl_trx_subsidy_pools_rec.last_updated_by,
1678: l_okl_trx_subsidy_pools_rec.last_update_date,
1679: l_okl_trx_subsidy_pools_rec.last_update_login);
1672: l_okl_trx_subsidy_pools_rec.attribute13,
1673: l_okl_trx_subsidy_pools_rec.attribute14,
1674: l_okl_trx_subsidy_pools_rec.attribute15,
1675: l_okl_trx_subsidy_pools_rec.created_by,
1676: l_okl_trx_subsidy_pools_rec.creation_date,
1677: l_okl_trx_subsidy_pools_rec.last_updated_by,
1678: l_okl_trx_subsidy_pools_rec.last_update_date,
1679: l_okl_trx_subsidy_pools_rec.last_update_login);
1680: -- Set OUT values
1673: l_okl_trx_subsidy_pools_rec.attribute14,
1674: l_okl_trx_subsidy_pools_rec.attribute15,
1675: l_okl_trx_subsidy_pools_rec.created_by,
1676: l_okl_trx_subsidy_pools_rec.creation_date,
1677: l_okl_trx_subsidy_pools_rec.last_updated_by,
1678: l_okl_trx_subsidy_pools_rec.last_update_date,
1679: l_okl_trx_subsidy_pools_rec.last_update_login);
1680: -- Set OUT values
1681: x_okl_trx_subsidy_pools_rec := l_okl_trx_subsidy_pools_rec;
1674: l_okl_trx_subsidy_pools_rec.attribute15,
1675: l_okl_trx_subsidy_pools_rec.created_by,
1676: l_okl_trx_subsidy_pools_rec.creation_date,
1677: l_okl_trx_subsidy_pools_rec.last_updated_by,
1678: l_okl_trx_subsidy_pools_rec.last_update_date,
1679: l_okl_trx_subsidy_pools_rec.last_update_login);
1680: -- Set OUT values
1681: x_okl_trx_subsidy_pools_rec := l_okl_trx_subsidy_pools_rec;
1682: x_return_status := l_return_status;
1675: l_okl_trx_subsidy_pools_rec.created_by,
1676: l_okl_trx_subsidy_pools_rec.creation_date,
1677: l_okl_trx_subsidy_pools_rec.last_updated_by,
1678: l_okl_trx_subsidy_pools_rec.last_update_date,
1679: l_okl_trx_subsidy_pools_rec.last_update_login);
1680: -- Set OUT values
1681: x_okl_trx_subsidy_pools_rec := l_okl_trx_subsidy_pools_rec;
1682: x_return_status := l_return_status;
1683: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1677: l_okl_trx_subsidy_pools_rec.last_updated_by,
1678: l_okl_trx_subsidy_pools_rec.last_update_date,
1679: l_okl_trx_subsidy_pools_rec.last_update_login);
1680: -- Set OUT values
1681: x_okl_trx_subsidy_pools_rec := l_okl_trx_subsidy_pools_rec;
1682: x_return_status := l_return_status;
1683: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1684: EXCEPTION
1685: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1713: '_PVT'
1714: );
1715: END insert_row;
1716: ---------------------------------------------
1717: -- insert_row for :OKL_TRX_SUBSIDY_POOLS_V --
1718: ---------------------------------------------
1719: PROCEDURE insert_row(
1720: p_api_version IN NUMBER,
1721: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1729: l_api_name CONSTANT VARCHAR2(30) := 'V_insert_row';
1730: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1731: l_sixv_rec sixv_rec_type := p_sixv_rec;
1732: l_def_sixv_rec sixv_rec_type;
1733: l_okl_trx_subsidy_pools_rec okl_trx_subsidy_pools_rec_type;
1734: lx_okl_trx_subsidy_pools_rec okl_trx_subsidy_pools_rec_type;
1735: -------------------------------
1736: -- FUNCTION fill_who_columns --
1737: -------------------------------
1730: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1731: l_sixv_rec sixv_rec_type := p_sixv_rec;
1732: l_def_sixv_rec sixv_rec_type;
1733: l_okl_trx_subsidy_pools_rec okl_trx_subsidy_pools_rec_type;
1734: lx_okl_trx_subsidy_pools_rec okl_trx_subsidy_pools_rec_type;
1735: -------------------------------
1736: -- FUNCTION fill_who_columns --
1737: -------------------------------
1738: FUNCTION fill_who_columns (
1747: l_sixv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1748: RETURN(l_sixv_rec);
1749: END fill_who_columns;
1750: ------------------------------------------------
1751: -- Set_Attributes for:OKL_TRX_SUBSIDY_POOLS_V --
1752: ------------------------------------------------
1753: FUNCTION Set_Attributes (
1754: p_sixv_rec IN sixv_rec_type,
1755: x_sixv_rec OUT NOCOPY sixv_rec_type
1803: END IF;
1804: -----------------------------------------
1805: -- Move VIEW record to "Child" records --
1806: -----------------------------------------
1807: migrate(l_def_sixv_rec, l_okl_trx_subsidy_pools_rec);
1808: -----------------------------------------------
1809: -- Call the INSERT_ROW for each child record --
1810: -----------------------------------------------
1811: insert_row(
1812: p_init_msg_list,
1813: l_return_status,
1814: x_msg_count,
1815: x_msg_data,
1816: l_okl_trx_subsidy_pools_rec,
1817: lx_okl_trx_subsidy_pools_rec
1818: );
1819: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1820: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1813: l_return_status,
1814: x_msg_count,
1815: x_msg_data,
1816: l_okl_trx_subsidy_pools_rec,
1817: lx_okl_trx_subsidy_pools_rec
1818: );
1819: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1820: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1821: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1820: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1821: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1822: RAISE OKC_API.G_EXCEPTION_ERROR;
1823: END IF;
1824: migrate(lx_okl_trx_subsidy_pools_rec, l_def_sixv_rec);
1825: -- Set OUT values
1826: x_sixv_rec := l_def_sixv_rec;
1827: x_return_status := l_return_status;
1828: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2023: ---------------------------------------------------------------------------
2024: -- PROCEDURE lock_row
2025: ---------------------------------------------------------------------------
2026: ----------------------------------------
2027: -- lock_row for:OKL_TRX_SUBSIDY_POOLS --
2028: ----------------------------------------
2029: PROCEDURE lock_row(
2030: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2031: x_return_status OUT NOCOPY VARCHAR2,
2030: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2031: x_return_status OUT NOCOPY VARCHAR2,
2032: x_msg_count OUT NOCOPY NUMBER,
2033: x_msg_data OUT NOCOPY VARCHAR2,
2034: p_okl_trx_subsidy_pools_rec IN okl_trx_subsidy_pools_rec_type) IS
2035:
2036: E_Resource_Busy EXCEPTION;
2037: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2038: CURSOR lock_csr (p_okl_trx_subsidy_pools_rec IN okl_trx_subsidy_pools_rec_type) IS
2034: p_okl_trx_subsidy_pools_rec IN okl_trx_subsidy_pools_rec_type) IS
2035:
2036: E_Resource_Busy EXCEPTION;
2037: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2038: CURSOR lock_csr (p_okl_trx_subsidy_pools_rec IN okl_trx_subsidy_pools_rec_type) IS
2039: SELECT OBJECT_VERSION_NUMBER
2040: FROM OKL_TRX_SUBSIDY_POOLS
2041: WHERE ID = p_okl_trx_subsidy_pools_rec.id
2042: AND OBJECT_VERSION_NUMBER = p_okl_trx_subsidy_pools_rec.object_version_number
2036: E_Resource_Busy EXCEPTION;
2037: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2038: CURSOR lock_csr (p_okl_trx_subsidy_pools_rec IN okl_trx_subsidy_pools_rec_type) IS
2039: SELECT OBJECT_VERSION_NUMBER
2040: FROM OKL_TRX_SUBSIDY_POOLS
2041: WHERE ID = p_okl_trx_subsidy_pools_rec.id
2042: AND OBJECT_VERSION_NUMBER = p_okl_trx_subsidy_pools_rec.object_version_number
2043: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
2044:
2037: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2038: CURSOR lock_csr (p_okl_trx_subsidy_pools_rec IN okl_trx_subsidy_pools_rec_type) IS
2039: SELECT OBJECT_VERSION_NUMBER
2040: FROM OKL_TRX_SUBSIDY_POOLS
2041: WHERE ID = p_okl_trx_subsidy_pools_rec.id
2042: AND OBJECT_VERSION_NUMBER = p_okl_trx_subsidy_pools_rec.object_version_number
2043: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
2044:
2045: CURSOR lchk_csr (p_okl_trx_subsidy_pools_rec IN okl_trx_subsidy_pools_rec_type) IS
2038: CURSOR lock_csr (p_okl_trx_subsidy_pools_rec IN okl_trx_subsidy_pools_rec_type) IS
2039: SELECT OBJECT_VERSION_NUMBER
2040: FROM OKL_TRX_SUBSIDY_POOLS
2041: WHERE ID = p_okl_trx_subsidy_pools_rec.id
2042: AND OBJECT_VERSION_NUMBER = p_okl_trx_subsidy_pools_rec.object_version_number
2043: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
2044:
2045: CURSOR lchk_csr (p_okl_trx_subsidy_pools_rec IN okl_trx_subsidy_pools_rec_type) IS
2046: SELECT OBJECT_VERSION_NUMBER
2041: WHERE ID = p_okl_trx_subsidy_pools_rec.id
2042: AND OBJECT_VERSION_NUMBER = p_okl_trx_subsidy_pools_rec.object_version_number
2043: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
2044:
2045: CURSOR lchk_csr (p_okl_trx_subsidy_pools_rec IN okl_trx_subsidy_pools_rec_type) IS
2046: SELECT OBJECT_VERSION_NUMBER
2047: FROM OKL_TRX_SUBSIDY_POOLS
2048: WHERE ID = p_okl_trx_subsidy_pools_rec.id;
2049: l_api_version CONSTANT NUMBER := 1;
2043: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
2044:
2045: CURSOR lchk_csr (p_okl_trx_subsidy_pools_rec IN okl_trx_subsidy_pools_rec_type) IS
2046: SELECT OBJECT_VERSION_NUMBER
2047: FROM OKL_TRX_SUBSIDY_POOLS
2048: WHERE ID = p_okl_trx_subsidy_pools_rec.id;
2049: l_api_version CONSTANT NUMBER := 1;
2050: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
2051: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2044:
2045: CURSOR lchk_csr (p_okl_trx_subsidy_pools_rec IN okl_trx_subsidy_pools_rec_type) IS
2046: SELECT OBJECT_VERSION_NUMBER
2047: FROM OKL_TRX_SUBSIDY_POOLS
2048: WHERE ID = p_okl_trx_subsidy_pools_rec.id;
2049: l_api_version CONSTANT NUMBER := 1;
2050: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
2051: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2052: l_object_version_number OKL_TRX_SUBSIDY_POOLS.OBJECT_VERSION_NUMBER%TYPE;
2048: WHERE ID = p_okl_trx_subsidy_pools_rec.id;
2049: l_api_version CONSTANT NUMBER := 1;
2050: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
2051: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2052: l_object_version_number OKL_TRX_SUBSIDY_POOLS.OBJECT_VERSION_NUMBER%TYPE;
2053: lc_object_version_number OKL_TRX_SUBSIDY_POOLS.OBJECT_VERSION_NUMBER%TYPE;
2054: l_row_notfound BOOLEAN := FALSE;
2055: lc_row_notfound BOOLEAN := FALSE;
2056: BEGIN
2049: l_api_version CONSTANT NUMBER := 1;
2050: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
2051: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2052: l_object_version_number OKL_TRX_SUBSIDY_POOLS.OBJECT_VERSION_NUMBER%TYPE;
2053: lc_object_version_number OKL_TRX_SUBSIDY_POOLS.OBJECT_VERSION_NUMBER%TYPE;
2054: l_row_notfound BOOLEAN := FALSE;
2055: lc_row_notfound BOOLEAN := FALSE;
2056: BEGIN
2057: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2063: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2064: RAISE OKC_API.G_EXCEPTION_ERROR;
2065: END IF;
2066: BEGIN
2067: OPEN lock_csr(p_okl_trx_subsidy_pools_rec);
2068: FETCH lock_csr INTO l_object_version_number;
2069: l_row_notfound := lock_csr%NOTFOUND;
2070: CLOSE lock_csr;
2071: EXCEPTION
2077: RAISE APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION;
2078: END;
2079:
2080: IF ( l_row_notfound ) THEN
2081: OPEN lchk_csr(p_okl_trx_subsidy_pools_rec);
2082: FETCH lchk_csr INTO lc_object_version_number;
2083: lc_row_notfound := lchk_csr%NOTFOUND;
2084: CLOSE lchk_csr;
2085: END IF;
2085: END IF;
2086: IF (lc_row_notfound) THEN
2087: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
2088: RAISE OKC_API.G_EXCEPTION_ERROR;
2089: ELSIF lc_object_version_number > p_okl_trx_subsidy_pools_rec.object_version_number THEN
2090: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
2091: RAISE OKC_API.G_EXCEPTION_ERROR;
2092: ELSIF lc_object_version_number <> p_okl_trx_subsidy_pools_rec.object_version_number THEN
2093: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
2088: RAISE OKC_API.G_EXCEPTION_ERROR;
2089: ELSIF lc_object_version_number > p_okl_trx_subsidy_pools_rec.object_version_number THEN
2090: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
2091: RAISE OKC_API.G_EXCEPTION_ERROR;
2092: ELSIF lc_object_version_number <> p_okl_trx_subsidy_pools_rec.object_version_number THEN
2093: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
2094: RAISE OKC_API.G_EXCEPTION_ERROR;
2095: ELSIF lc_object_version_number = -1 THEN
2096: OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
2130: '_PVT'
2131: );
2132: END lock_row;
2133: -------------------------------------------
2134: -- lock_row for: OKL_TRX_SUBSIDY_POOLS_V --
2135: -------------------------------------------
2136: PROCEDURE lock_row(
2137: p_api_version IN NUMBER,
2138: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2143:
2144: l_api_version CONSTANT NUMBER := 1;
2145: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
2146: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2147: l_okl_trx_subsidy_pools_rec okl_trx_subsidy_pools_rec_type;
2148: BEGIN
2149: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2150: G_PKG_NAME,
2151: p_init_msg_list,
2160: END IF;
2161: -----------------------------------------
2162: -- Move VIEW record to "Child" records --
2163: -----------------------------------------
2164: migrate(p_sixv_rec, l_okl_trx_subsidy_pools_rec);
2165: ---------------------------------------------
2166: -- Call the LOCK_ROW for each child record --
2167: ---------------------------------------------
2168: lock_row(
2169: p_init_msg_list,
2170: l_return_status,
2171: x_msg_count,
2172: x_msg_data,
2173: l_okl_trx_subsidy_pools_rec
2174: );
2175: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2176: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2177: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2370: ---------------------------------------------------------------------------
2371: -- PROCEDURE update_row
2372: ---------------------------------------------------------------------------
2373: ------------------------------------------
2374: -- update_row for:OKL_TRX_SUBSIDY_POOLS --
2375: ------------------------------------------
2376: PROCEDURE update_row(
2377: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2378: x_return_status OUT NOCOPY VARCHAR2,
2377: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2378: x_return_status OUT NOCOPY VARCHAR2,
2379: x_msg_count OUT NOCOPY NUMBER,
2380: x_msg_data OUT NOCOPY VARCHAR2,
2381: p_okl_trx_subsidy_pools_rec IN okl_trx_subsidy_pools_rec_type,
2382: x_okl_trx_subsidy_pools_rec OUT NOCOPY okl_trx_subsidy_pools_rec_type) IS
2383:
2384: l_api_version CONSTANT NUMBER := 1;
2385: l_api_name CONSTANT VARCHAR2(30) := 'B_update_row';
2378: x_return_status OUT NOCOPY VARCHAR2,
2379: x_msg_count OUT NOCOPY NUMBER,
2380: x_msg_data OUT NOCOPY VARCHAR2,
2381: p_okl_trx_subsidy_pools_rec IN okl_trx_subsidy_pools_rec_type,
2382: x_okl_trx_subsidy_pools_rec OUT NOCOPY okl_trx_subsidy_pools_rec_type) IS
2383:
2384: l_api_version CONSTANT NUMBER := 1;
2385: l_api_name CONSTANT VARCHAR2(30) := 'B_update_row';
2386: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2383:
2384: l_api_version CONSTANT NUMBER := 1;
2385: l_api_name CONSTANT VARCHAR2(30) := 'B_update_row';
2386: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2387: l_okl_trx_subsidy_pools_rec okl_trx_subsidy_pools_rec_type := p_okl_trx_subsidy_pools_rec;
2388: LDefOklTrxSubsidyPoolsRec okl_trx_subsidy_pools_rec_type;
2389: l_row_notfound BOOLEAN := TRUE;
2390: ----------------------------------
2391: -- FUNCTION populate_new_record --
2384: l_api_version CONSTANT NUMBER := 1;
2385: l_api_name CONSTANT VARCHAR2(30) := 'B_update_row';
2386: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2387: l_okl_trx_subsidy_pools_rec okl_trx_subsidy_pools_rec_type := p_okl_trx_subsidy_pools_rec;
2388: LDefOklTrxSubsidyPoolsRec okl_trx_subsidy_pools_rec_type;
2389: l_row_notfound BOOLEAN := TRUE;
2390: ----------------------------------
2391: -- FUNCTION populate_new_record --
2392: ----------------------------------
2390: ----------------------------------
2391: -- FUNCTION populate_new_record --
2392: ----------------------------------
2393: FUNCTION populate_new_record (
2394: p_okl_trx_subsidy_pools_rec IN okl_trx_subsidy_pools_rec_type,
2395: x_okl_trx_subsidy_pools_rec OUT NOCOPY okl_trx_subsidy_pools_rec_type
2396: ) RETURN VARCHAR2 IS
2397: l_okl_trx_subsidy_pools_rec okl_trx_subsidy_pools_rec_type;
2398: l_row_notfound BOOLEAN := TRUE;
2391: -- FUNCTION populate_new_record --
2392: ----------------------------------
2393: FUNCTION populate_new_record (
2394: p_okl_trx_subsidy_pools_rec IN okl_trx_subsidy_pools_rec_type,
2395: x_okl_trx_subsidy_pools_rec OUT NOCOPY okl_trx_subsidy_pools_rec_type
2396: ) RETURN VARCHAR2 IS
2397: l_okl_trx_subsidy_pools_rec okl_trx_subsidy_pools_rec_type;
2398: l_row_notfound BOOLEAN := TRUE;
2399: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2393: FUNCTION populate_new_record (
2394: p_okl_trx_subsidy_pools_rec IN okl_trx_subsidy_pools_rec_type,
2395: x_okl_trx_subsidy_pools_rec OUT NOCOPY okl_trx_subsidy_pools_rec_type
2396: ) RETURN VARCHAR2 IS
2397: l_okl_trx_subsidy_pools_rec okl_trx_subsidy_pools_rec_type;
2398: l_row_notfound BOOLEAN := TRUE;
2399: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2400: BEGIN
2401: x_okl_trx_subsidy_pools_rec := p_okl_trx_subsidy_pools_rec;
2397: l_okl_trx_subsidy_pools_rec okl_trx_subsidy_pools_rec_type;
2398: l_row_notfound BOOLEAN := TRUE;
2399: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2400: BEGIN
2401: x_okl_trx_subsidy_pools_rec := p_okl_trx_subsidy_pools_rec;
2402: -- Get current database values
2403: l_okl_trx_subsidy_pools_rec := get_rec(p_okl_trx_subsidy_pools_rec, l_return_status);
2404: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
2405: IF (x_okl_trx_subsidy_pools_rec.id = OKC_API.G_MISS_NUM)
2399: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2400: BEGIN
2401: x_okl_trx_subsidy_pools_rec := p_okl_trx_subsidy_pools_rec;
2402: -- Get current database values
2403: l_okl_trx_subsidy_pools_rec := get_rec(p_okl_trx_subsidy_pools_rec, l_return_status);
2404: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
2405: IF (x_okl_trx_subsidy_pools_rec.id = OKC_API.G_MISS_NUM)
2406: THEN
2407: x_okl_trx_subsidy_pools_rec.id := l_okl_trx_subsidy_pools_rec.id;
2401: x_okl_trx_subsidy_pools_rec := p_okl_trx_subsidy_pools_rec;
2402: -- Get current database values
2403: l_okl_trx_subsidy_pools_rec := get_rec(p_okl_trx_subsidy_pools_rec, l_return_status);
2404: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
2405: IF (x_okl_trx_subsidy_pools_rec.id = OKC_API.G_MISS_NUM)
2406: THEN
2407: x_okl_trx_subsidy_pools_rec.id := l_okl_trx_subsidy_pools_rec.id;
2408: END IF;
2409: IF (x_okl_trx_subsidy_pools_rec.object_version_number = OKC_API.G_MISS_NUM)
2403: l_okl_trx_subsidy_pools_rec := get_rec(p_okl_trx_subsidy_pools_rec, l_return_status);
2404: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
2405: IF (x_okl_trx_subsidy_pools_rec.id = OKC_API.G_MISS_NUM)
2406: THEN
2407: x_okl_trx_subsidy_pools_rec.id := l_okl_trx_subsidy_pools_rec.id;
2408: END IF;
2409: IF (x_okl_trx_subsidy_pools_rec.object_version_number = OKC_API.G_MISS_NUM)
2410: THEN
2411: x_okl_trx_subsidy_pools_rec.object_version_number := l_okl_trx_subsidy_pools_rec.object_version_number;
2405: IF (x_okl_trx_subsidy_pools_rec.id = OKC_API.G_MISS_NUM)
2406: THEN
2407: x_okl_trx_subsidy_pools_rec.id := l_okl_trx_subsidy_pools_rec.id;
2408: END IF;
2409: IF (x_okl_trx_subsidy_pools_rec.object_version_number = OKC_API.G_MISS_NUM)
2410: THEN
2411: x_okl_trx_subsidy_pools_rec.object_version_number := l_okl_trx_subsidy_pools_rec.object_version_number;
2412: END IF;
2413: IF (x_okl_trx_subsidy_pools_rec.trx_type_code = OKC_API.G_MISS_CHAR)
2407: x_okl_trx_subsidy_pools_rec.id := l_okl_trx_subsidy_pools_rec.id;
2408: END IF;
2409: IF (x_okl_trx_subsidy_pools_rec.object_version_number = OKC_API.G_MISS_NUM)
2410: THEN
2411: x_okl_trx_subsidy_pools_rec.object_version_number := l_okl_trx_subsidy_pools_rec.object_version_number;
2412: END IF;
2413: IF (x_okl_trx_subsidy_pools_rec.trx_type_code = OKC_API.G_MISS_CHAR)
2414: THEN
2415: x_okl_trx_subsidy_pools_rec.trx_type_code := l_okl_trx_subsidy_pools_rec.trx_type_code;
2409: IF (x_okl_trx_subsidy_pools_rec.object_version_number = OKC_API.G_MISS_NUM)
2410: THEN
2411: x_okl_trx_subsidy_pools_rec.object_version_number := l_okl_trx_subsidy_pools_rec.object_version_number;
2412: END IF;
2413: IF (x_okl_trx_subsidy_pools_rec.trx_type_code = OKC_API.G_MISS_CHAR)
2414: THEN
2415: x_okl_trx_subsidy_pools_rec.trx_type_code := l_okl_trx_subsidy_pools_rec.trx_type_code;
2416: END IF;
2417: IF (x_okl_trx_subsidy_pools_rec.source_type_code = OKC_API.G_MISS_CHAR)
2411: x_okl_trx_subsidy_pools_rec.object_version_number := l_okl_trx_subsidy_pools_rec.object_version_number;
2412: END IF;
2413: IF (x_okl_trx_subsidy_pools_rec.trx_type_code = OKC_API.G_MISS_CHAR)
2414: THEN
2415: x_okl_trx_subsidy_pools_rec.trx_type_code := l_okl_trx_subsidy_pools_rec.trx_type_code;
2416: END IF;
2417: IF (x_okl_trx_subsidy_pools_rec.source_type_code = OKC_API.G_MISS_CHAR)
2418: THEN
2419: x_okl_trx_subsidy_pools_rec.source_type_code := l_okl_trx_subsidy_pools_rec.source_type_code;
2413: IF (x_okl_trx_subsidy_pools_rec.trx_type_code = OKC_API.G_MISS_CHAR)
2414: THEN
2415: x_okl_trx_subsidy_pools_rec.trx_type_code := l_okl_trx_subsidy_pools_rec.trx_type_code;
2416: END IF;
2417: IF (x_okl_trx_subsidy_pools_rec.source_type_code = OKC_API.G_MISS_CHAR)
2418: THEN
2419: x_okl_trx_subsidy_pools_rec.source_type_code := l_okl_trx_subsidy_pools_rec.source_type_code;
2420: END IF;
2421: IF (x_okl_trx_subsidy_pools_rec.source_object_id = OKC_API.G_MISS_NUM)
2415: x_okl_trx_subsidy_pools_rec.trx_type_code := l_okl_trx_subsidy_pools_rec.trx_type_code;
2416: END IF;
2417: IF (x_okl_trx_subsidy_pools_rec.source_type_code = OKC_API.G_MISS_CHAR)
2418: THEN
2419: x_okl_trx_subsidy_pools_rec.source_type_code := l_okl_trx_subsidy_pools_rec.source_type_code;
2420: END IF;
2421: IF (x_okl_trx_subsidy_pools_rec.source_object_id = OKC_API.G_MISS_NUM)
2422: THEN
2423: x_okl_trx_subsidy_pools_rec.source_object_id := l_okl_trx_subsidy_pools_rec.source_object_id;
2417: IF (x_okl_trx_subsidy_pools_rec.source_type_code = OKC_API.G_MISS_CHAR)
2418: THEN
2419: x_okl_trx_subsidy_pools_rec.source_type_code := l_okl_trx_subsidy_pools_rec.source_type_code;
2420: END IF;
2421: IF (x_okl_trx_subsidy_pools_rec.source_object_id = OKC_API.G_MISS_NUM)
2422: THEN
2423: x_okl_trx_subsidy_pools_rec.source_object_id := l_okl_trx_subsidy_pools_rec.source_object_id;
2424: END IF;
2425: IF (x_okl_trx_subsidy_pools_rec.subsidy_pool_id = OKC_API.G_MISS_NUM)
2419: x_okl_trx_subsidy_pools_rec.source_type_code := l_okl_trx_subsidy_pools_rec.source_type_code;
2420: END IF;
2421: IF (x_okl_trx_subsidy_pools_rec.source_object_id = OKC_API.G_MISS_NUM)
2422: THEN
2423: x_okl_trx_subsidy_pools_rec.source_object_id := l_okl_trx_subsidy_pools_rec.source_object_id;
2424: END IF;
2425: IF (x_okl_trx_subsidy_pools_rec.subsidy_pool_id = OKC_API.G_MISS_NUM)
2426: THEN
2427: x_okl_trx_subsidy_pools_rec.subsidy_pool_id := l_okl_trx_subsidy_pools_rec.subsidy_pool_id;
2421: IF (x_okl_trx_subsidy_pools_rec.source_object_id = OKC_API.G_MISS_NUM)
2422: THEN
2423: x_okl_trx_subsidy_pools_rec.source_object_id := l_okl_trx_subsidy_pools_rec.source_object_id;
2424: END IF;
2425: IF (x_okl_trx_subsidy_pools_rec.subsidy_pool_id = OKC_API.G_MISS_NUM)
2426: THEN
2427: x_okl_trx_subsidy_pools_rec.subsidy_pool_id := l_okl_trx_subsidy_pools_rec.subsidy_pool_id;
2428: END IF;
2429: IF (x_okl_trx_subsidy_pools_rec.dnz_asset_number = OKC_API.G_MISS_CHAR)
2423: x_okl_trx_subsidy_pools_rec.source_object_id := l_okl_trx_subsidy_pools_rec.source_object_id;
2424: END IF;
2425: IF (x_okl_trx_subsidy_pools_rec.subsidy_pool_id = OKC_API.G_MISS_NUM)
2426: THEN
2427: x_okl_trx_subsidy_pools_rec.subsidy_pool_id := l_okl_trx_subsidy_pools_rec.subsidy_pool_id;
2428: END IF;
2429: IF (x_okl_trx_subsidy_pools_rec.dnz_asset_number = OKC_API.G_MISS_CHAR)
2430: THEN
2431: x_okl_trx_subsidy_pools_rec.dnz_asset_number := l_okl_trx_subsidy_pools_rec.dnz_asset_number;
2425: IF (x_okl_trx_subsidy_pools_rec.subsidy_pool_id = OKC_API.G_MISS_NUM)
2426: THEN
2427: x_okl_trx_subsidy_pools_rec.subsidy_pool_id := l_okl_trx_subsidy_pools_rec.subsidy_pool_id;
2428: END IF;
2429: IF (x_okl_trx_subsidy_pools_rec.dnz_asset_number = OKC_API.G_MISS_CHAR)
2430: THEN
2431: x_okl_trx_subsidy_pools_rec.dnz_asset_number := l_okl_trx_subsidy_pools_rec.dnz_asset_number;
2432: END IF;
2433: IF (x_okl_trx_subsidy_pools_rec.vendor_id = OKC_API.G_MISS_NUM)
2427: x_okl_trx_subsidy_pools_rec.subsidy_pool_id := l_okl_trx_subsidy_pools_rec.subsidy_pool_id;
2428: END IF;
2429: IF (x_okl_trx_subsidy_pools_rec.dnz_asset_number = OKC_API.G_MISS_CHAR)
2430: THEN
2431: x_okl_trx_subsidy_pools_rec.dnz_asset_number := l_okl_trx_subsidy_pools_rec.dnz_asset_number;
2432: END IF;
2433: IF (x_okl_trx_subsidy_pools_rec.vendor_id = OKC_API.G_MISS_NUM)
2434: THEN
2435: x_okl_trx_subsidy_pools_rec.vendor_id := l_okl_trx_subsidy_pools_rec.vendor_id;
2429: IF (x_okl_trx_subsidy_pools_rec.dnz_asset_number = OKC_API.G_MISS_CHAR)
2430: THEN
2431: x_okl_trx_subsidy_pools_rec.dnz_asset_number := l_okl_trx_subsidy_pools_rec.dnz_asset_number;
2432: END IF;
2433: IF (x_okl_trx_subsidy_pools_rec.vendor_id = OKC_API.G_MISS_NUM)
2434: THEN
2435: x_okl_trx_subsidy_pools_rec.vendor_id := l_okl_trx_subsidy_pools_rec.vendor_id;
2436: END IF;
2437: IF (x_okl_trx_subsidy_pools_rec.source_trx_date = OKC_API.G_MISS_DATE)
2431: x_okl_trx_subsidy_pools_rec.dnz_asset_number := l_okl_trx_subsidy_pools_rec.dnz_asset_number;
2432: END IF;
2433: IF (x_okl_trx_subsidy_pools_rec.vendor_id = OKC_API.G_MISS_NUM)
2434: THEN
2435: x_okl_trx_subsidy_pools_rec.vendor_id := l_okl_trx_subsidy_pools_rec.vendor_id;
2436: END IF;
2437: IF (x_okl_trx_subsidy_pools_rec.source_trx_date = OKC_API.G_MISS_DATE)
2438: THEN
2439: x_okl_trx_subsidy_pools_rec.source_trx_date := l_okl_trx_subsidy_pools_rec.source_trx_date;
2433: IF (x_okl_trx_subsidy_pools_rec.vendor_id = OKC_API.G_MISS_NUM)
2434: THEN
2435: x_okl_trx_subsidy_pools_rec.vendor_id := l_okl_trx_subsidy_pools_rec.vendor_id;
2436: END IF;
2437: IF (x_okl_trx_subsidy_pools_rec.source_trx_date = OKC_API.G_MISS_DATE)
2438: THEN
2439: x_okl_trx_subsidy_pools_rec.source_trx_date := l_okl_trx_subsidy_pools_rec.source_trx_date;
2440: END IF;
2441: IF (x_okl_trx_subsidy_pools_rec.trx_date = OKC_API.G_MISS_DATE)
2435: x_okl_trx_subsidy_pools_rec.vendor_id := l_okl_trx_subsidy_pools_rec.vendor_id;
2436: END IF;
2437: IF (x_okl_trx_subsidy_pools_rec.source_trx_date = OKC_API.G_MISS_DATE)
2438: THEN
2439: x_okl_trx_subsidy_pools_rec.source_trx_date := l_okl_trx_subsidy_pools_rec.source_trx_date;
2440: END IF;
2441: IF (x_okl_trx_subsidy_pools_rec.trx_date = OKC_API.G_MISS_DATE)
2442: THEN
2443: x_okl_trx_subsidy_pools_rec.trx_date := l_okl_trx_subsidy_pools_rec.trx_date;
2437: IF (x_okl_trx_subsidy_pools_rec.source_trx_date = OKC_API.G_MISS_DATE)
2438: THEN
2439: x_okl_trx_subsidy_pools_rec.source_trx_date := l_okl_trx_subsidy_pools_rec.source_trx_date;
2440: END IF;
2441: IF (x_okl_trx_subsidy_pools_rec.trx_date = OKC_API.G_MISS_DATE)
2442: THEN
2443: x_okl_trx_subsidy_pools_rec.trx_date := l_okl_trx_subsidy_pools_rec.trx_date;
2444: END IF;
2445: IF (x_okl_trx_subsidy_pools_rec.subsidy_id = OKC_API.G_MISS_NUM)
2439: x_okl_trx_subsidy_pools_rec.source_trx_date := l_okl_trx_subsidy_pools_rec.source_trx_date;
2440: END IF;
2441: IF (x_okl_trx_subsidy_pools_rec.trx_date = OKC_API.G_MISS_DATE)
2442: THEN
2443: x_okl_trx_subsidy_pools_rec.trx_date := l_okl_trx_subsidy_pools_rec.trx_date;
2444: END IF;
2445: IF (x_okl_trx_subsidy_pools_rec.subsidy_id = OKC_API.G_MISS_NUM)
2446: THEN
2447: x_okl_trx_subsidy_pools_rec.subsidy_id := l_okl_trx_subsidy_pools_rec.subsidy_id;
2441: IF (x_okl_trx_subsidy_pools_rec.trx_date = OKC_API.G_MISS_DATE)
2442: THEN
2443: x_okl_trx_subsidy_pools_rec.trx_date := l_okl_trx_subsidy_pools_rec.trx_date;
2444: END IF;
2445: IF (x_okl_trx_subsidy_pools_rec.subsidy_id = OKC_API.G_MISS_NUM)
2446: THEN
2447: x_okl_trx_subsidy_pools_rec.subsidy_id := l_okl_trx_subsidy_pools_rec.subsidy_id;
2448: END IF;
2449: IF (x_okl_trx_subsidy_pools_rec.trx_reason_code = OKC_API.G_MISS_CHAR)
2443: x_okl_trx_subsidy_pools_rec.trx_date := l_okl_trx_subsidy_pools_rec.trx_date;
2444: END IF;
2445: IF (x_okl_trx_subsidy_pools_rec.subsidy_id = OKC_API.G_MISS_NUM)
2446: THEN
2447: x_okl_trx_subsidy_pools_rec.subsidy_id := l_okl_trx_subsidy_pools_rec.subsidy_id;
2448: END IF;
2449: IF (x_okl_trx_subsidy_pools_rec.trx_reason_code = OKC_API.G_MISS_CHAR)
2450: THEN
2451: x_okl_trx_subsidy_pools_rec.trx_reason_code := l_okl_trx_subsidy_pools_rec.trx_reason_code;
2445: IF (x_okl_trx_subsidy_pools_rec.subsidy_id = OKC_API.G_MISS_NUM)
2446: THEN
2447: x_okl_trx_subsidy_pools_rec.subsidy_id := l_okl_trx_subsidy_pools_rec.subsidy_id;
2448: END IF;
2449: IF (x_okl_trx_subsidy_pools_rec.trx_reason_code = OKC_API.G_MISS_CHAR)
2450: THEN
2451: x_okl_trx_subsidy_pools_rec.trx_reason_code := l_okl_trx_subsidy_pools_rec.trx_reason_code;
2452: END IF;
2453: IF (x_okl_trx_subsidy_pools_rec.trx_currency_code = OKC_API.G_MISS_CHAR)
2447: x_okl_trx_subsidy_pools_rec.subsidy_id := l_okl_trx_subsidy_pools_rec.subsidy_id;
2448: END IF;
2449: IF (x_okl_trx_subsidy_pools_rec.trx_reason_code = OKC_API.G_MISS_CHAR)
2450: THEN
2451: x_okl_trx_subsidy_pools_rec.trx_reason_code := l_okl_trx_subsidy_pools_rec.trx_reason_code;
2452: END IF;
2453: IF (x_okl_trx_subsidy_pools_rec.trx_currency_code = OKC_API.G_MISS_CHAR)
2454: THEN
2455: x_okl_trx_subsidy_pools_rec.trx_currency_code := l_okl_trx_subsidy_pools_rec.trx_currency_code;
2449: IF (x_okl_trx_subsidy_pools_rec.trx_reason_code = OKC_API.G_MISS_CHAR)
2450: THEN
2451: x_okl_trx_subsidy_pools_rec.trx_reason_code := l_okl_trx_subsidy_pools_rec.trx_reason_code;
2452: END IF;
2453: IF (x_okl_trx_subsidy_pools_rec.trx_currency_code = OKC_API.G_MISS_CHAR)
2454: THEN
2455: x_okl_trx_subsidy_pools_rec.trx_currency_code := l_okl_trx_subsidy_pools_rec.trx_currency_code;
2456: END IF;
2457: IF (x_okl_trx_subsidy_pools_rec.trx_amount = OKC_API.G_MISS_NUM)
2451: x_okl_trx_subsidy_pools_rec.trx_reason_code := l_okl_trx_subsidy_pools_rec.trx_reason_code;
2452: END IF;
2453: IF (x_okl_trx_subsidy_pools_rec.trx_currency_code = OKC_API.G_MISS_CHAR)
2454: THEN
2455: x_okl_trx_subsidy_pools_rec.trx_currency_code := l_okl_trx_subsidy_pools_rec.trx_currency_code;
2456: END IF;
2457: IF (x_okl_trx_subsidy_pools_rec.trx_amount = OKC_API.G_MISS_NUM)
2458: THEN
2459: x_okl_trx_subsidy_pools_rec.trx_amount := l_okl_trx_subsidy_pools_rec.trx_amount;
2453: IF (x_okl_trx_subsidy_pools_rec.trx_currency_code = OKC_API.G_MISS_CHAR)
2454: THEN
2455: x_okl_trx_subsidy_pools_rec.trx_currency_code := l_okl_trx_subsidy_pools_rec.trx_currency_code;
2456: END IF;
2457: IF (x_okl_trx_subsidy_pools_rec.trx_amount = OKC_API.G_MISS_NUM)
2458: THEN
2459: x_okl_trx_subsidy_pools_rec.trx_amount := l_okl_trx_subsidy_pools_rec.trx_amount;
2460: END IF;
2461: IF (x_okl_trx_subsidy_pools_rec.subsidy_pool_currency_code = OKC_API.G_MISS_CHAR)
2455: x_okl_trx_subsidy_pools_rec.trx_currency_code := l_okl_trx_subsidy_pools_rec.trx_currency_code;
2456: END IF;
2457: IF (x_okl_trx_subsidy_pools_rec.trx_amount = OKC_API.G_MISS_NUM)
2458: THEN
2459: x_okl_trx_subsidy_pools_rec.trx_amount := l_okl_trx_subsidy_pools_rec.trx_amount;
2460: END IF;
2461: IF (x_okl_trx_subsidy_pools_rec.subsidy_pool_currency_code = OKC_API.G_MISS_CHAR)
2462: THEN
2463: x_okl_trx_subsidy_pools_rec.subsidy_pool_currency_code := l_okl_trx_subsidy_pools_rec.subsidy_pool_currency_code;
2457: IF (x_okl_trx_subsidy_pools_rec.trx_amount = OKC_API.G_MISS_NUM)
2458: THEN
2459: x_okl_trx_subsidy_pools_rec.trx_amount := l_okl_trx_subsidy_pools_rec.trx_amount;
2460: END IF;
2461: IF (x_okl_trx_subsidy_pools_rec.subsidy_pool_currency_code = OKC_API.G_MISS_CHAR)
2462: THEN
2463: x_okl_trx_subsidy_pools_rec.subsidy_pool_currency_code := l_okl_trx_subsidy_pools_rec.subsidy_pool_currency_code;
2464: END IF;
2465: IF (x_okl_trx_subsidy_pools_rec.subsidy_pool_amount = OKC_API.G_MISS_NUM)
2459: x_okl_trx_subsidy_pools_rec.trx_amount := l_okl_trx_subsidy_pools_rec.trx_amount;
2460: END IF;
2461: IF (x_okl_trx_subsidy_pools_rec.subsidy_pool_currency_code = OKC_API.G_MISS_CHAR)
2462: THEN
2463: x_okl_trx_subsidy_pools_rec.subsidy_pool_currency_code := l_okl_trx_subsidy_pools_rec.subsidy_pool_currency_code;
2464: END IF;
2465: IF (x_okl_trx_subsidy_pools_rec.subsidy_pool_amount = OKC_API.G_MISS_NUM)
2466: THEN
2467: x_okl_trx_subsidy_pools_rec.subsidy_pool_amount := l_okl_trx_subsidy_pools_rec.subsidy_pool_amount;
2461: IF (x_okl_trx_subsidy_pools_rec.subsidy_pool_currency_code = OKC_API.G_MISS_CHAR)
2462: THEN
2463: x_okl_trx_subsidy_pools_rec.subsidy_pool_currency_code := l_okl_trx_subsidy_pools_rec.subsidy_pool_currency_code;
2464: END IF;
2465: IF (x_okl_trx_subsidy_pools_rec.subsidy_pool_amount = OKC_API.G_MISS_NUM)
2466: THEN
2467: x_okl_trx_subsidy_pools_rec.subsidy_pool_amount := l_okl_trx_subsidy_pools_rec.subsidy_pool_amount;
2468: END IF;
2469: IF (x_okl_trx_subsidy_pools_rec.conversion_rate = OKC_API.G_MISS_NUM)
2463: x_okl_trx_subsidy_pools_rec.subsidy_pool_currency_code := l_okl_trx_subsidy_pools_rec.subsidy_pool_currency_code;
2464: END IF;
2465: IF (x_okl_trx_subsidy_pools_rec.subsidy_pool_amount = OKC_API.G_MISS_NUM)
2466: THEN
2467: x_okl_trx_subsidy_pools_rec.subsidy_pool_amount := l_okl_trx_subsidy_pools_rec.subsidy_pool_amount;
2468: END IF;
2469: IF (x_okl_trx_subsidy_pools_rec.conversion_rate = OKC_API.G_MISS_NUM)
2470: THEN
2471: x_okl_trx_subsidy_pools_rec.conversion_rate := l_okl_trx_subsidy_pools_rec.conversion_rate;
2465: IF (x_okl_trx_subsidy_pools_rec.subsidy_pool_amount = OKC_API.G_MISS_NUM)
2466: THEN
2467: x_okl_trx_subsidy_pools_rec.subsidy_pool_amount := l_okl_trx_subsidy_pools_rec.subsidy_pool_amount;
2468: END IF;
2469: IF (x_okl_trx_subsidy_pools_rec.conversion_rate = OKC_API.G_MISS_NUM)
2470: THEN
2471: x_okl_trx_subsidy_pools_rec.conversion_rate := l_okl_trx_subsidy_pools_rec.conversion_rate;
2472: END IF;
2473: IF (x_okl_trx_subsidy_pools_rec.attribute_category = OKC_API.G_MISS_CHAR)
2467: x_okl_trx_subsidy_pools_rec.subsidy_pool_amount := l_okl_trx_subsidy_pools_rec.subsidy_pool_amount;
2468: END IF;
2469: IF (x_okl_trx_subsidy_pools_rec.conversion_rate = OKC_API.G_MISS_NUM)
2470: THEN
2471: x_okl_trx_subsidy_pools_rec.conversion_rate := l_okl_trx_subsidy_pools_rec.conversion_rate;
2472: END IF;
2473: IF (x_okl_trx_subsidy_pools_rec.attribute_category = OKC_API.G_MISS_CHAR)
2474: THEN
2475: x_okl_trx_subsidy_pools_rec.attribute_category := l_okl_trx_subsidy_pools_rec.attribute_category;
2469: IF (x_okl_trx_subsidy_pools_rec.conversion_rate = OKC_API.G_MISS_NUM)
2470: THEN
2471: x_okl_trx_subsidy_pools_rec.conversion_rate := l_okl_trx_subsidy_pools_rec.conversion_rate;
2472: END IF;
2473: IF (x_okl_trx_subsidy_pools_rec.attribute_category = OKC_API.G_MISS_CHAR)
2474: THEN
2475: x_okl_trx_subsidy_pools_rec.attribute_category := l_okl_trx_subsidy_pools_rec.attribute_category;
2476: END IF;
2477: IF (x_okl_trx_subsidy_pools_rec.attribute1 = OKC_API.G_MISS_CHAR)
2471: x_okl_trx_subsidy_pools_rec.conversion_rate := l_okl_trx_subsidy_pools_rec.conversion_rate;
2472: END IF;
2473: IF (x_okl_trx_subsidy_pools_rec.attribute_category = OKC_API.G_MISS_CHAR)
2474: THEN
2475: x_okl_trx_subsidy_pools_rec.attribute_category := l_okl_trx_subsidy_pools_rec.attribute_category;
2476: END IF;
2477: IF (x_okl_trx_subsidy_pools_rec.attribute1 = OKC_API.G_MISS_CHAR)
2478: THEN
2479: x_okl_trx_subsidy_pools_rec.attribute1 := l_okl_trx_subsidy_pools_rec.attribute1;
2473: IF (x_okl_trx_subsidy_pools_rec.attribute_category = OKC_API.G_MISS_CHAR)
2474: THEN
2475: x_okl_trx_subsidy_pools_rec.attribute_category := l_okl_trx_subsidy_pools_rec.attribute_category;
2476: END IF;
2477: IF (x_okl_trx_subsidy_pools_rec.attribute1 = OKC_API.G_MISS_CHAR)
2478: THEN
2479: x_okl_trx_subsidy_pools_rec.attribute1 := l_okl_trx_subsidy_pools_rec.attribute1;
2480: END IF;
2481: IF (x_okl_trx_subsidy_pools_rec.attribute2 = OKC_API.G_MISS_CHAR)
2475: x_okl_trx_subsidy_pools_rec.attribute_category := l_okl_trx_subsidy_pools_rec.attribute_category;
2476: END IF;
2477: IF (x_okl_trx_subsidy_pools_rec.attribute1 = OKC_API.G_MISS_CHAR)
2478: THEN
2479: x_okl_trx_subsidy_pools_rec.attribute1 := l_okl_trx_subsidy_pools_rec.attribute1;
2480: END IF;
2481: IF (x_okl_trx_subsidy_pools_rec.attribute2 = OKC_API.G_MISS_CHAR)
2482: THEN
2483: x_okl_trx_subsidy_pools_rec.attribute2 := l_okl_trx_subsidy_pools_rec.attribute2;
2477: IF (x_okl_trx_subsidy_pools_rec.attribute1 = OKC_API.G_MISS_CHAR)
2478: THEN
2479: x_okl_trx_subsidy_pools_rec.attribute1 := l_okl_trx_subsidy_pools_rec.attribute1;
2480: END IF;
2481: IF (x_okl_trx_subsidy_pools_rec.attribute2 = OKC_API.G_MISS_CHAR)
2482: THEN
2483: x_okl_trx_subsidy_pools_rec.attribute2 := l_okl_trx_subsidy_pools_rec.attribute2;
2484: END IF;
2485: IF (x_okl_trx_subsidy_pools_rec.attribute3 = OKC_API.G_MISS_CHAR)
2479: x_okl_trx_subsidy_pools_rec.attribute1 := l_okl_trx_subsidy_pools_rec.attribute1;
2480: END IF;
2481: IF (x_okl_trx_subsidy_pools_rec.attribute2 = OKC_API.G_MISS_CHAR)
2482: THEN
2483: x_okl_trx_subsidy_pools_rec.attribute2 := l_okl_trx_subsidy_pools_rec.attribute2;
2484: END IF;
2485: IF (x_okl_trx_subsidy_pools_rec.attribute3 = OKC_API.G_MISS_CHAR)
2486: THEN
2487: x_okl_trx_subsidy_pools_rec.attribute3 := l_okl_trx_subsidy_pools_rec.attribute3;
2481: IF (x_okl_trx_subsidy_pools_rec.attribute2 = OKC_API.G_MISS_CHAR)
2482: THEN
2483: x_okl_trx_subsidy_pools_rec.attribute2 := l_okl_trx_subsidy_pools_rec.attribute2;
2484: END IF;
2485: IF (x_okl_trx_subsidy_pools_rec.attribute3 = OKC_API.G_MISS_CHAR)
2486: THEN
2487: x_okl_trx_subsidy_pools_rec.attribute3 := l_okl_trx_subsidy_pools_rec.attribute3;
2488: END IF;
2489: IF (x_okl_trx_subsidy_pools_rec.attribute4 = OKC_API.G_MISS_CHAR)
2483: x_okl_trx_subsidy_pools_rec.attribute2 := l_okl_trx_subsidy_pools_rec.attribute2;
2484: END IF;
2485: IF (x_okl_trx_subsidy_pools_rec.attribute3 = OKC_API.G_MISS_CHAR)
2486: THEN
2487: x_okl_trx_subsidy_pools_rec.attribute3 := l_okl_trx_subsidy_pools_rec.attribute3;
2488: END IF;
2489: IF (x_okl_trx_subsidy_pools_rec.attribute4 = OKC_API.G_MISS_CHAR)
2490: THEN
2491: x_okl_trx_subsidy_pools_rec.attribute4 := l_okl_trx_subsidy_pools_rec.attribute4;
2485: IF (x_okl_trx_subsidy_pools_rec.attribute3 = OKC_API.G_MISS_CHAR)
2486: THEN
2487: x_okl_trx_subsidy_pools_rec.attribute3 := l_okl_trx_subsidy_pools_rec.attribute3;
2488: END IF;
2489: IF (x_okl_trx_subsidy_pools_rec.attribute4 = OKC_API.G_MISS_CHAR)
2490: THEN
2491: x_okl_trx_subsidy_pools_rec.attribute4 := l_okl_trx_subsidy_pools_rec.attribute4;
2492: END IF;
2493: IF (x_okl_trx_subsidy_pools_rec.attribute5 = OKC_API.G_MISS_CHAR)
2487: x_okl_trx_subsidy_pools_rec.attribute3 := l_okl_trx_subsidy_pools_rec.attribute3;
2488: END IF;
2489: IF (x_okl_trx_subsidy_pools_rec.attribute4 = OKC_API.G_MISS_CHAR)
2490: THEN
2491: x_okl_trx_subsidy_pools_rec.attribute4 := l_okl_trx_subsidy_pools_rec.attribute4;
2492: END IF;
2493: IF (x_okl_trx_subsidy_pools_rec.attribute5 = OKC_API.G_MISS_CHAR)
2494: THEN
2495: x_okl_trx_subsidy_pools_rec.attribute5 := l_okl_trx_subsidy_pools_rec.attribute5;
2489: IF (x_okl_trx_subsidy_pools_rec.attribute4 = OKC_API.G_MISS_CHAR)
2490: THEN
2491: x_okl_trx_subsidy_pools_rec.attribute4 := l_okl_trx_subsidy_pools_rec.attribute4;
2492: END IF;
2493: IF (x_okl_trx_subsidy_pools_rec.attribute5 = OKC_API.G_MISS_CHAR)
2494: THEN
2495: x_okl_trx_subsidy_pools_rec.attribute5 := l_okl_trx_subsidy_pools_rec.attribute5;
2496: END IF;
2497: IF (x_okl_trx_subsidy_pools_rec.attribute6 = OKC_API.G_MISS_CHAR)
2491: x_okl_trx_subsidy_pools_rec.attribute4 := l_okl_trx_subsidy_pools_rec.attribute4;
2492: END IF;
2493: IF (x_okl_trx_subsidy_pools_rec.attribute5 = OKC_API.G_MISS_CHAR)
2494: THEN
2495: x_okl_trx_subsidy_pools_rec.attribute5 := l_okl_trx_subsidy_pools_rec.attribute5;
2496: END IF;
2497: IF (x_okl_trx_subsidy_pools_rec.attribute6 = OKC_API.G_MISS_CHAR)
2498: THEN
2499: x_okl_trx_subsidy_pools_rec.attribute6 := l_okl_trx_subsidy_pools_rec.attribute6;
2493: IF (x_okl_trx_subsidy_pools_rec.attribute5 = OKC_API.G_MISS_CHAR)
2494: THEN
2495: x_okl_trx_subsidy_pools_rec.attribute5 := l_okl_trx_subsidy_pools_rec.attribute5;
2496: END IF;
2497: IF (x_okl_trx_subsidy_pools_rec.attribute6 = OKC_API.G_MISS_CHAR)
2498: THEN
2499: x_okl_trx_subsidy_pools_rec.attribute6 := l_okl_trx_subsidy_pools_rec.attribute6;
2500: END IF;
2501: IF (x_okl_trx_subsidy_pools_rec.attribute7 = OKC_API.G_MISS_CHAR)
2495: x_okl_trx_subsidy_pools_rec.attribute5 := l_okl_trx_subsidy_pools_rec.attribute5;
2496: END IF;
2497: IF (x_okl_trx_subsidy_pools_rec.attribute6 = OKC_API.G_MISS_CHAR)
2498: THEN
2499: x_okl_trx_subsidy_pools_rec.attribute6 := l_okl_trx_subsidy_pools_rec.attribute6;
2500: END IF;
2501: IF (x_okl_trx_subsidy_pools_rec.attribute7 = OKC_API.G_MISS_CHAR)
2502: THEN
2503: x_okl_trx_subsidy_pools_rec.attribute7 := l_okl_trx_subsidy_pools_rec.attribute7;
2497: IF (x_okl_trx_subsidy_pools_rec.attribute6 = OKC_API.G_MISS_CHAR)
2498: THEN
2499: x_okl_trx_subsidy_pools_rec.attribute6 := l_okl_trx_subsidy_pools_rec.attribute6;
2500: END IF;
2501: IF (x_okl_trx_subsidy_pools_rec.attribute7 = OKC_API.G_MISS_CHAR)
2502: THEN
2503: x_okl_trx_subsidy_pools_rec.attribute7 := l_okl_trx_subsidy_pools_rec.attribute7;
2504: END IF;
2505: IF (x_okl_trx_subsidy_pools_rec.attribute8 = OKC_API.G_MISS_CHAR)
2499: x_okl_trx_subsidy_pools_rec.attribute6 := l_okl_trx_subsidy_pools_rec.attribute6;
2500: END IF;
2501: IF (x_okl_trx_subsidy_pools_rec.attribute7 = OKC_API.G_MISS_CHAR)
2502: THEN
2503: x_okl_trx_subsidy_pools_rec.attribute7 := l_okl_trx_subsidy_pools_rec.attribute7;
2504: END IF;
2505: IF (x_okl_trx_subsidy_pools_rec.attribute8 = OKC_API.G_MISS_CHAR)
2506: THEN
2507: x_okl_trx_subsidy_pools_rec.attribute8 := l_okl_trx_subsidy_pools_rec.attribute8;
2501: IF (x_okl_trx_subsidy_pools_rec.attribute7 = OKC_API.G_MISS_CHAR)
2502: THEN
2503: x_okl_trx_subsidy_pools_rec.attribute7 := l_okl_trx_subsidy_pools_rec.attribute7;
2504: END IF;
2505: IF (x_okl_trx_subsidy_pools_rec.attribute8 = OKC_API.G_MISS_CHAR)
2506: THEN
2507: x_okl_trx_subsidy_pools_rec.attribute8 := l_okl_trx_subsidy_pools_rec.attribute8;
2508: END IF;
2509: IF (x_okl_trx_subsidy_pools_rec.attribute9 = OKC_API.G_MISS_CHAR)
2503: x_okl_trx_subsidy_pools_rec.attribute7 := l_okl_trx_subsidy_pools_rec.attribute7;
2504: END IF;
2505: IF (x_okl_trx_subsidy_pools_rec.attribute8 = OKC_API.G_MISS_CHAR)
2506: THEN
2507: x_okl_trx_subsidy_pools_rec.attribute8 := l_okl_trx_subsidy_pools_rec.attribute8;
2508: END IF;
2509: IF (x_okl_trx_subsidy_pools_rec.attribute9 = OKC_API.G_MISS_CHAR)
2510: THEN
2511: x_okl_trx_subsidy_pools_rec.attribute9 := l_okl_trx_subsidy_pools_rec.attribute9;
2505: IF (x_okl_trx_subsidy_pools_rec.attribute8 = OKC_API.G_MISS_CHAR)
2506: THEN
2507: x_okl_trx_subsidy_pools_rec.attribute8 := l_okl_trx_subsidy_pools_rec.attribute8;
2508: END IF;
2509: IF (x_okl_trx_subsidy_pools_rec.attribute9 = OKC_API.G_MISS_CHAR)
2510: THEN
2511: x_okl_trx_subsidy_pools_rec.attribute9 := l_okl_trx_subsidy_pools_rec.attribute9;
2512: END IF;
2513: IF (x_okl_trx_subsidy_pools_rec.attribute10 = OKC_API.G_MISS_CHAR)
2507: x_okl_trx_subsidy_pools_rec.attribute8 := l_okl_trx_subsidy_pools_rec.attribute8;
2508: END IF;
2509: IF (x_okl_trx_subsidy_pools_rec.attribute9 = OKC_API.G_MISS_CHAR)
2510: THEN
2511: x_okl_trx_subsidy_pools_rec.attribute9 := l_okl_trx_subsidy_pools_rec.attribute9;
2512: END IF;
2513: IF (x_okl_trx_subsidy_pools_rec.attribute10 = OKC_API.G_MISS_CHAR)
2514: THEN
2515: x_okl_trx_subsidy_pools_rec.attribute10 := l_okl_trx_subsidy_pools_rec.attribute10;
2509: IF (x_okl_trx_subsidy_pools_rec.attribute9 = OKC_API.G_MISS_CHAR)
2510: THEN
2511: x_okl_trx_subsidy_pools_rec.attribute9 := l_okl_trx_subsidy_pools_rec.attribute9;
2512: END IF;
2513: IF (x_okl_trx_subsidy_pools_rec.attribute10 = OKC_API.G_MISS_CHAR)
2514: THEN
2515: x_okl_trx_subsidy_pools_rec.attribute10 := l_okl_trx_subsidy_pools_rec.attribute10;
2516: END IF;
2517: IF (x_okl_trx_subsidy_pools_rec.attribute11 = OKC_API.G_MISS_CHAR)
2511: x_okl_trx_subsidy_pools_rec.attribute9 := l_okl_trx_subsidy_pools_rec.attribute9;
2512: END IF;
2513: IF (x_okl_trx_subsidy_pools_rec.attribute10 = OKC_API.G_MISS_CHAR)
2514: THEN
2515: x_okl_trx_subsidy_pools_rec.attribute10 := l_okl_trx_subsidy_pools_rec.attribute10;
2516: END IF;
2517: IF (x_okl_trx_subsidy_pools_rec.attribute11 = OKC_API.G_MISS_CHAR)
2518: THEN
2519: x_okl_trx_subsidy_pools_rec.attribute11 := l_okl_trx_subsidy_pools_rec.attribute11;
2513: IF (x_okl_trx_subsidy_pools_rec.attribute10 = OKC_API.G_MISS_CHAR)
2514: THEN
2515: x_okl_trx_subsidy_pools_rec.attribute10 := l_okl_trx_subsidy_pools_rec.attribute10;
2516: END IF;
2517: IF (x_okl_trx_subsidy_pools_rec.attribute11 = OKC_API.G_MISS_CHAR)
2518: THEN
2519: x_okl_trx_subsidy_pools_rec.attribute11 := l_okl_trx_subsidy_pools_rec.attribute11;
2520: END IF;
2521: IF (x_okl_trx_subsidy_pools_rec.attribute12 = OKC_API.G_MISS_CHAR)
2515: x_okl_trx_subsidy_pools_rec.attribute10 := l_okl_trx_subsidy_pools_rec.attribute10;
2516: END IF;
2517: IF (x_okl_trx_subsidy_pools_rec.attribute11 = OKC_API.G_MISS_CHAR)
2518: THEN
2519: x_okl_trx_subsidy_pools_rec.attribute11 := l_okl_trx_subsidy_pools_rec.attribute11;
2520: END IF;
2521: IF (x_okl_trx_subsidy_pools_rec.attribute12 = OKC_API.G_MISS_CHAR)
2522: THEN
2523: x_okl_trx_subsidy_pools_rec.attribute12 := l_okl_trx_subsidy_pools_rec.attribute12;
2517: IF (x_okl_trx_subsidy_pools_rec.attribute11 = OKC_API.G_MISS_CHAR)
2518: THEN
2519: x_okl_trx_subsidy_pools_rec.attribute11 := l_okl_trx_subsidy_pools_rec.attribute11;
2520: END IF;
2521: IF (x_okl_trx_subsidy_pools_rec.attribute12 = OKC_API.G_MISS_CHAR)
2522: THEN
2523: x_okl_trx_subsidy_pools_rec.attribute12 := l_okl_trx_subsidy_pools_rec.attribute12;
2524: END IF;
2525: IF (x_okl_trx_subsidy_pools_rec.attribute13 = OKC_API.G_MISS_CHAR)
2519: x_okl_trx_subsidy_pools_rec.attribute11 := l_okl_trx_subsidy_pools_rec.attribute11;
2520: END IF;
2521: IF (x_okl_trx_subsidy_pools_rec.attribute12 = OKC_API.G_MISS_CHAR)
2522: THEN
2523: x_okl_trx_subsidy_pools_rec.attribute12 := l_okl_trx_subsidy_pools_rec.attribute12;
2524: END IF;
2525: IF (x_okl_trx_subsidy_pools_rec.attribute13 = OKC_API.G_MISS_CHAR)
2526: THEN
2527: x_okl_trx_subsidy_pools_rec.attribute13 := l_okl_trx_subsidy_pools_rec.attribute13;
2521: IF (x_okl_trx_subsidy_pools_rec.attribute12 = OKC_API.G_MISS_CHAR)
2522: THEN
2523: x_okl_trx_subsidy_pools_rec.attribute12 := l_okl_trx_subsidy_pools_rec.attribute12;
2524: END IF;
2525: IF (x_okl_trx_subsidy_pools_rec.attribute13 = OKC_API.G_MISS_CHAR)
2526: THEN
2527: x_okl_trx_subsidy_pools_rec.attribute13 := l_okl_trx_subsidy_pools_rec.attribute13;
2528: END IF;
2529: IF (x_okl_trx_subsidy_pools_rec.attribute14 = OKC_API.G_MISS_CHAR)
2523: x_okl_trx_subsidy_pools_rec.attribute12 := l_okl_trx_subsidy_pools_rec.attribute12;
2524: END IF;
2525: IF (x_okl_trx_subsidy_pools_rec.attribute13 = OKC_API.G_MISS_CHAR)
2526: THEN
2527: x_okl_trx_subsidy_pools_rec.attribute13 := l_okl_trx_subsidy_pools_rec.attribute13;
2528: END IF;
2529: IF (x_okl_trx_subsidy_pools_rec.attribute14 = OKC_API.G_MISS_CHAR)
2530: THEN
2531: x_okl_trx_subsidy_pools_rec.attribute14 := l_okl_trx_subsidy_pools_rec.attribute14;
2525: IF (x_okl_trx_subsidy_pools_rec.attribute13 = OKC_API.G_MISS_CHAR)
2526: THEN
2527: x_okl_trx_subsidy_pools_rec.attribute13 := l_okl_trx_subsidy_pools_rec.attribute13;
2528: END IF;
2529: IF (x_okl_trx_subsidy_pools_rec.attribute14 = OKC_API.G_MISS_CHAR)
2530: THEN
2531: x_okl_trx_subsidy_pools_rec.attribute14 := l_okl_trx_subsidy_pools_rec.attribute14;
2532: END IF;
2533: IF (x_okl_trx_subsidy_pools_rec.attribute15 = OKC_API.G_MISS_CHAR)
2527: x_okl_trx_subsidy_pools_rec.attribute13 := l_okl_trx_subsidy_pools_rec.attribute13;
2528: END IF;
2529: IF (x_okl_trx_subsidy_pools_rec.attribute14 = OKC_API.G_MISS_CHAR)
2530: THEN
2531: x_okl_trx_subsidy_pools_rec.attribute14 := l_okl_trx_subsidy_pools_rec.attribute14;
2532: END IF;
2533: IF (x_okl_trx_subsidy_pools_rec.attribute15 = OKC_API.G_MISS_CHAR)
2534: THEN
2535: x_okl_trx_subsidy_pools_rec.attribute15 := l_okl_trx_subsidy_pools_rec.attribute15;
2529: IF (x_okl_trx_subsidy_pools_rec.attribute14 = OKC_API.G_MISS_CHAR)
2530: THEN
2531: x_okl_trx_subsidy_pools_rec.attribute14 := l_okl_trx_subsidy_pools_rec.attribute14;
2532: END IF;
2533: IF (x_okl_trx_subsidy_pools_rec.attribute15 = OKC_API.G_MISS_CHAR)
2534: THEN
2535: x_okl_trx_subsidy_pools_rec.attribute15 := l_okl_trx_subsidy_pools_rec.attribute15;
2536: END IF;
2537: IF (x_okl_trx_subsidy_pools_rec.created_by = OKC_API.G_MISS_NUM)
2531: x_okl_trx_subsidy_pools_rec.attribute14 := l_okl_trx_subsidy_pools_rec.attribute14;
2532: END IF;
2533: IF (x_okl_trx_subsidy_pools_rec.attribute15 = OKC_API.G_MISS_CHAR)
2534: THEN
2535: x_okl_trx_subsidy_pools_rec.attribute15 := l_okl_trx_subsidy_pools_rec.attribute15;
2536: END IF;
2537: IF (x_okl_trx_subsidy_pools_rec.created_by = OKC_API.G_MISS_NUM)
2538: THEN
2539: x_okl_trx_subsidy_pools_rec.created_by := l_okl_trx_subsidy_pools_rec.created_by;
2533: IF (x_okl_trx_subsidy_pools_rec.attribute15 = OKC_API.G_MISS_CHAR)
2534: THEN
2535: x_okl_trx_subsidy_pools_rec.attribute15 := l_okl_trx_subsidy_pools_rec.attribute15;
2536: END IF;
2537: IF (x_okl_trx_subsidy_pools_rec.created_by = OKC_API.G_MISS_NUM)
2538: THEN
2539: x_okl_trx_subsidy_pools_rec.created_by := l_okl_trx_subsidy_pools_rec.created_by;
2540: END IF;
2541: IF (x_okl_trx_subsidy_pools_rec.creation_date = OKC_API.G_MISS_DATE)
2535: x_okl_trx_subsidy_pools_rec.attribute15 := l_okl_trx_subsidy_pools_rec.attribute15;
2536: END IF;
2537: IF (x_okl_trx_subsidy_pools_rec.created_by = OKC_API.G_MISS_NUM)
2538: THEN
2539: x_okl_trx_subsidy_pools_rec.created_by := l_okl_trx_subsidy_pools_rec.created_by;
2540: END IF;
2541: IF (x_okl_trx_subsidy_pools_rec.creation_date = OKC_API.G_MISS_DATE)
2542: THEN
2543: x_okl_trx_subsidy_pools_rec.creation_date := l_okl_trx_subsidy_pools_rec.creation_date;
2537: IF (x_okl_trx_subsidy_pools_rec.created_by = OKC_API.G_MISS_NUM)
2538: THEN
2539: x_okl_trx_subsidy_pools_rec.created_by := l_okl_trx_subsidy_pools_rec.created_by;
2540: END IF;
2541: IF (x_okl_trx_subsidy_pools_rec.creation_date = OKC_API.G_MISS_DATE)
2542: THEN
2543: x_okl_trx_subsidy_pools_rec.creation_date := l_okl_trx_subsidy_pools_rec.creation_date;
2544: END IF;
2545: IF (x_okl_trx_subsidy_pools_rec.last_updated_by = OKC_API.G_MISS_NUM)
2539: x_okl_trx_subsidy_pools_rec.created_by := l_okl_trx_subsidy_pools_rec.created_by;
2540: END IF;
2541: IF (x_okl_trx_subsidy_pools_rec.creation_date = OKC_API.G_MISS_DATE)
2542: THEN
2543: x_okl_trx_subsidy_pools_rec.creation_date := l_okl_trx_subsidy_pools_rec.creation_date;
2544: END IF;
2545: IF (x_okl_trx_subsidy_pools_rec.last_updated_by = OKC_API.G_MISS_NUM)
2546: THEN
2547: x_okl_trx_subsidy_pools_rec.last_updated_by := l_okl_trx_subsidy_pools_rec.last_updated_by;
2541: IF (x_okl_trx_subsidy_pools_rec.creation_date = OKC_API.G_MISS_DATE)
2542: THEN
2543: x_okl_trx_subsidy_pools_rec.creation_date := l_okl_trx_subsidy_pools_rec.creation_date;
2544: END IF;
2545: IF (x_okl_trx_subsidy_pools_rec.last_updated_by = OKC_API.G_MISS_NUM)
2546: THEN
2547: x_okl_trx_subsidy_pools_rec.last_updated_by := l_okl_trx_subsidy_pools_rec.last_updated_by;
2548: END IF;
2549: IF (x_okl_trx_subsidy_pools_rec.last_update_date = OKC_API.G_MISS_DATE)
2543: x_okl_trx_subsidy_pools_rec.creation_date := l_okl_trx_subsidy_pools_rec.creation_date;
2544: END IF;
2545: IF (x_okl_trx_subsidy_pools_rec.last_updated_by = OKC_API.G_MISS_NUM)
2546: THEN
2547: x_okl_trx_subsidy_pools_rec.last_updated_by := l_okl_trx_subsidy_pools_rec.last_updated_by;
2548: END IF;
2549: IF (x_okl_trx_subsidy_pools_rec.last_update_date = OKC_API.G_MISS_DATE)
2550: THEN
2551: x_okl_trx_subsidy_pools_rec.last_update_date := l_okl_trx_subsidy_pools_rec.last_update_date;
2545: IF (x_okl_trx_subsidy_pools_rec.last_updated_by = OKC_API.G_MISS_NUM)
2546: THEN
2547: x_okl_trx_subsidy_pools_rec.last_updated_by := l_okl_trx_subsidy_pools_rec.last_updated_by;
2548: END IF;
2549: IF (x_okl_trx_subsidy_pools_rec.last_update_date = OKC_API.G_MISS_DATE)
2550: THEN
2551: x_okl_trx_subsidy_pools_rec.last_update_date := l_okl_trx_subsidy_pools_rec.last_update_date;
2552: END IF;
2553: IF (x_okl_trx_subsidy_pools_rec.last_update_login = OKC_API.G_MISS_NUM)
2547: x_okl_trx_subsidy_pools_rec.last_updated_by := l_okl_trx_subsidy_pools_rec.last_updated_by;
2548: END IF;
2549: IF (x_okl_trx_subsidy_pools_rec.last_update_date = OKC_API.G_MISS_DATE)
2550: THEN
2551: x_okl_trx_subsidy_pools_rec.last_update_date := l_okl_trx_subsidy_pools_rec.last_update_date;
2552: END IF;
2553: IF (x_okl_trx_subsidy_pools_rec.last_update_login = OKC_API.G_MISS_NUM)
2554: THEN
2555: x_okl_trx_subsidy_pools_rec.last_update_login := l_okl_trx_subsidy_pools_rec.last_update_login;
2549: IF (x_okl_trx_subsidy_pools_rec.last_update_date = OKC_API.G_MISS_DATE)
2550: THEN
2551: x_okl_trx_subsidy_pools_rec.last_update_date := l_okl_trx_subsidy_pools_rec.last_update_date;
2552: END IF;
2553: IF (x_okl_trx_subsidy_pools_rec.last_update_login = OKC_API.G_MISS_NUM)
2554: THEN
2555: x_okl_trx_subsidy_pools_rec.last_update_login := l_okl_trx_subsidy_pools_rec.last_update_login;
2556: END IF;
2557: END IF;
2551: x_okl_trx_subsidy_pools_rec.last_update_date := l_okl_trx_subsidy_pools_rec.last_update_date;
2552: END IF;
2553: IF (x_okl_trx_subsidy_pools_rec.last_update_login = OKC_API.G_MISS_NUM)
2554: THEN
2555: x_okl_trx_subsidy_pools_rec.last_update_login := l_okl_trx_subsidy_pools_rec.last_update_login;
2556: END IF;
2557: END IF;
2558: RETURN(l_return_status);
2559: END populate_new_record;
2557: END IF;
2558: RETURN(l_return_status);
2559: END populate_new_record;
2560: ----------------------------------------------
2561: -- Set_Attributes for:OKL_TRX_SUBSIDY_POOLS --
2562: ----------------------------------------------
2563: FUNCTION Set_Attributes (
2564: p_okl_trx_subsidy_pools_rec IN okl_trx_subsidy_pools_rec_type,
2565: x_okl_trx_subsidy_pools_rec OUT NOCOPY okl_trx_subsidy_pools_rec_type
2560: ----------------------------------------------
2561: -- Set_Attributes for:OKL_TRX_SUBSIDY_POOLS --
2562: ----------------------------------------------
2563: FUNCTION Set_Attributes (
2564: p_okl_trx_subsidy_pools_rec IN okl_trx_subsidy_pools_rec_type,
2565: x_okl_trx_subsidy_pools_rec OUT NOCOPY okl_trx_subsidy_pools_rec_type
2566: ) RETURN VARCHAR2 IS
2567: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2568: BEGIN
2561: -- Set_Attributes for:OKL_TRX_SUBSIDY_POOLS --
2562: ----------------------------------------------
2563: FUNCTION Set_Attributes (
2564: p_okl_trx_subsidy_pools_rec IN okl_trx_subsidy_pools_rec_type,
2565: x_okl_trx_subsidy_pools_rec OUT NOCOPY okl_trx_subsidy_pools_rec_type
2566: ) RETURN VARCHAR2 IS
2567: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2568: BEGIN
2569: x_okl_trx_subsidy_pools_rec := p_okl_trx_subsidy_pools_rec;
2565: x_okl_trx_subsidy_pools_rec OUT NOCOPY okl_trx_subsidy_pools_rec_type
2566: ) RETURN VARCHAR2 IS
2567: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2568: BEGIN
2569: x_okl_trx_subsidy_pools_rec := p_okl_trx_subsidy_pools_rec;
2570: x_okl_trx_subsidy_pools_rec.OBJECT_VERSION_NUMBER := p_okl_trx_subsidy_pools_rec.OBJECT_VERSION_NUMBER + 1;
2571: RETURN(l_return_status);
2572: END Set_Attributes;
2573: BEGIN
2566: ) RETURN VARCHAR2 IS
2567: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2568: BEGIN
2569: x_okl_trx_subsidy_pools_rec := p_okl_trx_subsidy_pools_rec;
2570: x_okl_trx_subsidy_pools_rec.OBJECT_VERSION_NUMBER := p_okl_trx_subsidy_pools_rec.OBJECT_VERSION_NUMBER + 1;
2571: RETURN(l_return_status);
2572: END Set_Attributes;
2573: BEGIN
2574: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2581: RAISE OKC_API.G_EXCEPTION_ERROR;
2582: END IF;
2583: --- Setting item attributes
2584: l_return_status := Set_Attributes(
2585: p_okl_trx_subsidy_pools_rec, -- IN
2586: l_okl_trx_subsidy_pools_rec); -- OUT
2587: --- If any errors happen abort API
2588: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2589: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2582: END IF;
2583: --- Setting item attributes
2584: l_return_status := Set_Attributes(
2585: p_okl_trx_subsidy_pools_rec, -- IN
2586: l_okl_trx_subsidy_pools_rec); -- OUT
2587: --- If any errors happen abort API
2588: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2589: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2590: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2589: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2590: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2591: RAISE OKC_API.G_EXCEPTION_ERROR;
2592: END IF;
2593: l_return_status := populate_new_record(l_okl_trx_subsidy_pools_rec, LDefOklTrxSubsidyPoolsRec);
2594: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2595: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2596: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2597: RAISE OKC_API.G_EXCEPTION_ERROR;
2595: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2596: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2597: RAISE OKC_API.G_EXCEPTION_ERROR;
2598: END IF;
2599: UPDATE OKL_TRX_SUBSIDY_POOLS
2600: SET OBJECT_VERSION_NUMBER = LDefOklTrxSubsidyPoolsRec.object_version_number,
2601: TRX_TYPE_CODE = LDefOklTrxSubsidyPoolsRec.trx_type_code,
2602: SOURCE_TYPE_CODE = LDefOklTrxSubsidyPoolsRec.source_type_code,
2603: SOURCE_OBJECT_ID = LDefOklTrxSubsidyPoolsRec.source_object_id,
2635: LAST_UPDATE_DATE = LDefOklTrxSubsidyPoolsRec.last_update_date,
2636: LAST_UPDATE_LOGIN = LDefOklTrxSubsidyPoolsRec.last_update_login
2637: WHERE ID = LDefOklTrxSubsidyPoolsRec.id;
2638:
2639: x_okl_trx_subsidy_pools_rec := l_okl_trx_subsidy_pools_rec;
2640: x_return_status := l_return_status;
2641: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2642: EXCEPTION
2643: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2671: '_PVT'
2672: );
2673: END update_row;
2674: --------------------------------------------
2675: -- update_row for:OKL_TRX_SUBSIDY_POOLS_V --
2676: --------------------------------------------
2677: PROCEDURE update_row(
2678: p_api_version IN NUMBER,
2679: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2688: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2689: l_sixv_rec sixv_rec_type := p_sixv_rec;
2690: l_def_sixv_rec sixv_rec_type;
2691: l_db_sixv_rec sixv_rec_type;
2692: l_okl_trx_subsidy_pools_rec okl_trx_subsidy_pools_rec_type;
2693: lx_okl_trx_subsidy_pools_rec okl_trx_subsidy_pools_rec_type;
2694: -------------------------------
2695: -- FUNCTION fill_who_columns --
2696: -------------------------------
2689: l_sixv_rec sixv_rec_type := p_sixv_rec;
2690: l_def_sixv_rec sixv_rec_type;
2691: l_db_sixv_rec sixv_rec_type;
2692: l_okl_trx_subsidy_pools_rec okl_trx_subsidy_pools_rec_type;
2693: lx_okl_trx_subsidy_pools_rec okl_trx_subsidy_pools_rec_type;
2694: -------------------------------
2695: -- FUNCTION fill_who_columns --
2696: -------------------------------
2697: FUNCTION fill_who_columns (
2871: END IF;
2872: RETURN(l_return_status);
2873: END populate_new_record;
2874: ------------------------------------------------
2875: -- Set_Attributes for:OKL_TRX_SUBSIDY_POOLS_V --
2876: ------------------------------------------------
2877: FUNCTION Set_Attributes (
2878: p_sixv_rec IN sixv_rec_type,
2879: x_sixv_rec OUT NOCOPY sixv_rec_type
2946:
2947: -----------------------------------------
2948: -- Move VIEW record to "Child" records --
2949: -----------------------------------------
2950: migrate(l_def_sixv_rec, l_okl_trx_subsidy_pools_rec);
2951: -----------------------------------------------
2952: -- Call the UPDATE_ROW for each child record --
2953: -----------------------------------------------
2954: update_row(
2955: p_init_msg_list,
2956: l_return_status,
2957: x_msg_count,
2958: x_msg_data,
2959: l_okl_trx_subsidy_pools_rec,
2960: lx_okl_trx_subsidy_pools_rec
2961: );
2962: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2963: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2956: l_return_status,
2957: x_msg_count,
2958: x_msg_data,
2959: l_okl_trx_subsidy_pools_rec,
2960: lx_okl_trx_subsidy_pools_rec
2961: );
2962: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2963: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2964: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2963: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2964: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2965: RAISE OKC_API.G_EXCEPTION_ERROR;
2966: END IF;
2967: migrate(lx_okl_trx_subsidy_pools_rec, l_def_sixv_rec);
2968: x_sixv_rec := l_def_sixv_rec;
2969: x_return_status := l_return_status;
2970: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2971: EXCEPTION
3165: ---------------------------------------------------------------------------
3166: -- PROCEDURE delete_row
3167: ---------------------------------------------------------------------------
3168: ------------------------------------------
3169: -- delete_row for:OKL_TRX_SUBSIDY_POOLS --
3170: ------------------------------------------
3171: PROCEDURE delete_row(
3172: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3173: x_return_status OUT NOCOPY VARCHAR2,
3172: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3173: x_return_status OUT NOCOPY VARCHAR2,
3174: x_msg_count OUT NOCOPY NUMBER,
3175: x_msg_data OUT NOCOPY VARCHAR2,
3176: p_okl_trx_subsidy_pools_rec IN okl_trx_subsidy_pools_rec_type) IS
3177:
3178: l_api_version CONSTANT NUMBER := 1;
3179: l_api_name CONSTANT VARCHAR2(30) := 'B_delete_row';
3180: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3177:
3178: l_api_version CONSTANT NUMBER := 1;
3179: l_api_name CONSTANT VARCHAR2(30) := 'B_delete_row';
3180: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3181: l_okl_trx_subsidy_pools_rec okl_trx_subsidy_pools_rec_type := p_okl_trx_subsidy_pools_rec;
3182: l_row_notfound BOOLEAN := TRUE;
3183: BEGIN
3184: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
3185: p_init_msg_list,
3190: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3191: RAISE OKC_API.G_EXCEPTION_ERROR;
3192: END IF;
3193:
3194: DELETE FROM OKL_TRX_SUBSIDY_POOLS
3195: WHERE ID = p_okl_trx_subsidy_pools_rec.id;
3196:
3197: x_return_status := l_return_status;
3198: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3191: RAISE OKC_API.G_EXCEPTION_ERROR;
3192: END IF;
3193:
3194: DELETE FROM OKL_TRX_SUBSIDY_POOLS
3195: WHERE ID = p_okl_trx_subsidy_pools_rec.id;
3196:
3197: x_return_status := l_return_status;
3198: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3199: EXCEPTION
3228: '_PVT'
3229: );
3230: END delete_row;
3231: --------------------------------------------
3232: -- delete_row for:OKL_TRX_SUBSIDY_POOLS_V --
3233: --------------------------------------------
3234: PROCEDURE delete_row(
3235: p_api_version IN NUMBER,
3236: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3242: l_api_version CONSTANT NUMBER := 1;
3243: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
3244: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3245: l_sixv_rec sixv_rec_type := p_sixv_rec;
3246: l_okl_trx_subsidy_pools_rec okl_trx_subsidy_pools_rec_type;
3247: BEGIN
3248: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
3249: G_PKG_NAME,
3250: p_init_msg_list,
3259: END IF;
3260: -----------------------------------------
3261: -- Move VIEW record to "Child" records --
3262: -----------------------------------------
3263: migrate(l_sixv_rec, l_okl_trx_subsidy_pools_rec);
3264: -----------------------------------------------
3265: -- Call the DELETE_ROW for each child record --
3266: -----------------------------------------------
3267: delete_row(
3268: p_init_msg_list,
3269: l_return_status,
3270: x_msg_count,
3271: x_msg_data,
3272: l_okl_trx_subsidy_pools_rec
3273: );
3274: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3275: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3276: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3310: '_PVT'
3311: );
3312: END delete_row;
3313: -------------------------------------------------------
3314: -- PL/SQL TBL delete_row for:OKL_TRX_SUBSIDY_POOLS_V --
3315: -------------------------------------------------------
3316: PROCEDURE delete_row(
3317: p_api_version IN NUMBER,
3318: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3406: );
3407: END delete_row;
3408:
3409: -------------------------------------------------------
3410: -- PL/SQL TBL delete_row for:OKL_TRX_SUBSIDY_POOLS_V --
3411: -------------------------------------------------------
3412: PROCEDURE delete_row(
3413: p_api_version IN NUMBER,
3414: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,