[Home] [Help]
90: null;
91: END api_copy;
92:
93: ---------------------------------------------------------------------------
94: -- FUNCTION get_rec for: OKL_CURE_PAYMENT_LINES_V
95: ---------------------------------------------------------------------------
96: FUNCTION get_rec (
97: p_CPNv_rec IN CPNv_rec_type,
98: x_no_data_found OUT NOCOPY BOOLEAN
138: CREATION_DATE,
139: LAST_UPDATED_BY,
140: LAST_UPDATE_DATE,
141: LAST_UPDATE_LOGIN
142: FROM OKL_CURE_PAYMENT_LINES
143: WHERE OKL_CURE_PAYMENT_LINES.cure_payment_line_id = p_cure_payment_line_id;
144: l_OKL_cure_pay_line_pk OKL_cure_pay_line_pk_csr%ROWTYPE;
145: l_CPNv_rec CPNv_rec_type;
146: BEGIN
139: LAST_UPDATED_BY,
140: LAST_UPDATE_DATE,
141: LAST_UPDATE_LOGIN
142: FROM OKL_CURE_PAYMENT_LINES
143: WHERE OKL_CURE_PAYMENT_LINES.cure_payment_line_id = p_cure_payment_line_id;
144: l_OKL_cure_pay_line_pk OKL_cure_pay_line_pk_csr%ROWTYPE;
145: l_CPNv_rec CPNv_rec_type;
146: BEGIN
147: x_no_data_found := TRUE;
221: BEGIN
222: RETURN(get_rec(p_CPNv_rec, l_row_not_found));
223: END get_rec;
224: ---------------------------------------------------------------------------
225: -- FUNCTION get_rec for: OKL_CURE_PAYMENT_LINES
226: ---------------------------------------------------------------------------
227: FUNCTION get_rec (
228: p_OKL_cure_payment_lines_rec IN OKLCurePaymentLinesRecType,
229: x_no_data_found OUT NOCOPY BOOLEAN
224: ---------------------------------------------------------------------------
225: -- FUNCTION get_rec for: OKL_CURE_PAYMENT_LINES
226: ---------------------------------------------------------------------------
227: FUNCTION get_rec (
228: p_OKL_cure_payment_lines_rec IN OKLCurePaymentLinesRecType,
229: x_no_data_found OUT NOCOPY BOOLEAN
230: ) RETURN OKLCurePaymentLinesRecType IS
231: CURSOR OKL_cure_payment_line_pk_csr (p_cure_payment_line_id IN NUMBER) IS
232: SELECT
269: CREATION_DATE,
270: LAST_UPDATED_BY,
271: LAST_UPDATE_DATE,
272: LAST_UPDATE_LOGIN
273: FROM OKL_Cure_Payment_Lines
274: WHERE OKL_cure_payment_lines.cure_payment_line_id = p_cure_payment_line_id;
275: l_OKL_cure_payment_line_pk OKL_cure_payment_line_pk_csr%ROWTYPE;
276: l_OKL_cure_payment_lines_rec OKLCurePaymentLinesRecType;
277: BEGIN
270: LAST_UPDATED_BY,
271: LAST_UPDATE_DATE,
272: LAST_UPDATE_LOGIN
273: FROM OKL_Cure_Payment_Lines
274: WHERE OKL_cure_payment_lines.cure_payment_line_id = p_cure_payment_line_id;
275: l_OKL_cure_payment_line_pk OKL_cure_payment_line_pk_csr%ROWTYPE;
276: l_OKL_cure_payment_lines_rec OKLCurePaymentLinesRecType;
277: BEGIN
278: x_no_data_found := TRUE;
272: LAST_UPDATE_LOGIN
273: FROM OKL_Cure_Payment_Lines
274: WHERE OKL_cure_payment_lines.cure_payment_line_id = p_cure_payment_line_id;
275: l_OKL_cure_payment_line_pk OKL_cure_payment_line_pk_csr%ROWTYPE;
276: l_OKL_cure_payment_lines_rec OKLCurePaymentLinesRecType;
277: BEGIN
278: x_no_data_found := TRUE;
279: -- Get current database values
280: OPEN OKL_cure_payment_line_pk_csr (p_OKL_cure_payment_lines_rec.cure_payment_line_id);
276: l_OKL_cure_payment_lines_rec OKLCurePaymentLinesRecType;
277: BEGIN
278: x_no_data_found := TRUE;
279: -- Get current database values
280: OPEN OKL_cure_payment_line_pk_csr (p_OKL_cure_payment_lines_rec.cure_payment_line_id);
281: FETCH OKL_cure_payment_line_pk_csr INTO
282: l_OKL_cure_payment_lines_rec.cure_payment_line_id,
283: l_OKL_cure_payment_lines_rec.cure_payment_id,
284: l_OKL_cure_payment_lines_rec.chr_id,
278: x_no_data_found := TRUE;
279: -- Get current database values
280: OPEN OKL_cure_payment_line_pk_csr (p_OKL_cure_payment_lines_rec.cure_payment_line_id);
281: FETCH OKL_cure_payment_line_pk_csr INTO
282: l_OKL_cure_payment_lines_rec.cure_payment_line_id,
283: l_OKL_cure_payment_lines_rec.cure_payment_id,
284: l_OKL_cure_payment_lines_rec.chr_id,
285: l_OKL_cure_payment_lines_rec.amount,
286: l_OKL_cure_payment_lines_rec.cured_flag,
279: -- Get current database values
280: OPEN OKL_cure_payment_line_pk_csr (p_OKL_cure_payment_lines_rec.cure_payment_line_id);
281: FETCH OKL_cure_payment_line_pk_csr INTO
282: l_OKL_cure_payment_lines_rec.cure_payment_line_id,
283: l_OKL_cure_payment_lines_rec.cure_payment_id,
284: l_OKL_cure_payment_lines_rec.chr_id,
285: l_OKL_cure_payment_lines_rec.amount,
286: l_OKL_cure_payment_lines_rec.cured_flag,
287: l_OKL_cure_payment_lines_rec.status,
280: OPEN OKL_cure_payment_line_pk_csr (p_OKL_cure_payment_lines_rec.cure_payment_line_id);
281: FETCH OKL_cure_payment_line_pk_csr INTO
282: l_OKL_cure_payment_lines_rec.cure_payment_line_id,
283: l_OKL_cure_payment_lines_rec.cure_payment_id,
284: l_OKL_cure_payment_lines_rec.chr_id,
285: l_OKL_cure_payment_lines_rec.amount,
286: l_OKL_cure_payment_lines_rec.cured_flag,
287: l_OKL_cure_payment_lines_rec.status,
288: l_OKL_cure_payment_lines_rec.cure_refund_id,
281: FETCH OKL_cure_payment_line_pk_csr INTO
282: l_OKL_cure_payment_lines_rec.cure_payment_line_id,
283: l_OKL_cure_payment_lines_rec.cure_payment_id,
284: l_OKL_cure_payment_lines_rec.chr_id,
285: l_OKL_cure_payment_lines_rec.amount,
286: l_OKL_cure_payment_lines_rec.cured_flag,
287: l_OKL_cure_payment_lines_rec.status,
288: l_OKL_cure_payment_lines_rec.cure_refund_id,
289: l_OKL_cure_payment_lines_rec.approval_status,
282: l_OKL_cure_payment_lines_rec.cure_payment_line_id,
283: l_OKL_cure_payment_lines_rec.cure_payment_id,
284: l_OKL_cure_payment_lines_rec.chr_id,
285: l_OKL_cure_payment_lines_rec.amount,
286: l_OKL_cure_payment_lines_rec.cured_flag,
287: l_OKL_cure_payment_lines_rec.status,
288: l_OKL_cure_payment_lines_rec.cure_refund_id,
289: l_OKL_cure_payment_lines_rec.approval_status,
290: l_OKL_cure_payment_lines_rec.approval_reason,
283: l_OKL_cure_payment_lines_rec.cure_payment_id,
284: l_OKL_cure_payment_lines_rec.chr_id,
285: l_OKL_cure_payment_lines_rec.amount,
286: l_OKL_cure_payment_lines_rec.cured_flag,
287: l_OKL_cure_payment_lines_rec.status,
288: l_OKL_cure_payment_lines_rec.cure_refund_id,
289: l_OKL_cure_payment_lines_rec.approval_status,
290: l_OKL_cure_payment_lines_rec.approval_reason,
291: l_OKL_cure_payment_lines_rec.transaction_id,
284: l_OKL_cure_payment_lines_rec.chr_id,
285: l_OKL_cure_payment_lines_rec.amount,
286: l_OKL_cure_payment_lines_rec.cured_flag,
287: l_OKL_cure_payment_lines_rec.status,
288: l_OKL_cure_payment_lines_rec.cure_refund_id,
289: l_OKL_cure_payment_lines_rec.approval_status,
290: l_OKL_cure_payment_lines_rec.approval_reason,
291: l_OKL_cure_payment_lines_rec.transaction_id,
292: l_OKL_cure_payment_lines_rec.tai_id,
285: l_OKL_cure_payment_lines_rec.amount,
286: l_OKL_cure_payment_lines_rec.cured_flag,
287: l_OKL_cure_payment_lines_rec.status,
288: l_OKL_cure_payment_lines_rec.cure_refund_id,
289: l_OKL_cure_payment_lines_rec.approval_status,
290: l_OKL_cure_payment_lines_rec.approval_reason,
291: l_OKL_cure_payment_lines_rec.transaction_id,
292: l_OKL_cure_payment_lines_rec.tai_id,
293: l_OKL_cure_payment_lines_rec.process_status,
286: l_OKL_cure_payment_lines_rec.cured_flag,
287: l_OKL_cure_payment_lines_rec.status,
288: l_OKL_cure_payment_lines_rec.cure_refund_id,
289: l_OKL_cure_payment_lines_rec.approval_status,
290: l_OKL_cure_payment_lines_rec.approval_reason,
291: l_OKL_cure_payment_lines_rec.transaction_id,
292: l_OKL_cure_payment_lines_rec.tai_id,
293: l_OKL_cure_payment_lines_rec.process_status,
294: l_OKL_cure_payment_lines_rec.rct_id,
287: l_OKL_cure_payment_lines_rec.status,
288: l_OKL_cure_payment_lines_rec.cure_refund_id,
289: l_OKL_cure_payment_lines_rec.approval_status,
290: l_OKL_cure_payment_lines_rec.approval_reason,
291: l_OKL_cure_payment_lines_rec.transaction_id,
292: l_OKL_cure_payment_lines_rec.tai_id,
293: l_OKL_cure_payment_lines_rec.process_status,
294: l_OKL_cure_payment_lines_rec.rct_id,
295: l_OKL_cure_payment_lines_rec.object_version_number,
288: l_OKL_cure_payment_lines_rec.cure_refund_id,
289: l_OKL_cure_payment_lines_rec.approval_status,
290: l_OKL_cure_payment_lines_rec.approval_reason,
291: l_OKL_cure_payment_lines_rec.transaction_id,
292: l_OKL_cure_payment_lines_rec.tai_id,
293: l_OKL_cure_payment_lines_rec.process_status,
294: l_OKL_cure_payment_lines_rec.rct_id,
295: l_OKL_cure_payment_lines_rec.object_version_number,
296: l_OKL_cure_payment_lines_rec.org_id,
289: l_OKL_cure_payment_lines_rec.approval_status,
290: l_OKL_cure_payment_lines_rec.approval_reason,
291: l_OKL_cure_payment_lines_rec.transaction_id,
292: l_OKL_cure_payment_lines_rec.tai_id,
293: l_OKL_cure_payment_lines_rec.process_status,
294: l_OKL_cure_payment_lines_rec.rct_id,
295: l_OKL_cure_payment_lines_rec.object_version_number,
296: l_OKL_cure_payment_lines_rec.org_id,
297: l_OKL_cure_payment_lines_rec.request_id,
290: l_OKL_cure_payment_lines_rec.approval_reason,
291: l_OKL_cure_payment_lines_rec.transaction_id,
292: l_OKL_cure_payment_lines_rec.tai_id,
293: l_OKL_cure_payment_lines_rec.process_status,
294: l_OKL_cure_payment_lines_rec.rct_id,
295: l_OKL_cure_payment_lines_rec.object_version_number,
296: l_OKL_cure_payment_lines_rec.org_id,
297: l_OKL_cure_payment_lines_rec.request_id,
298: l_OKL_cure_payment_lines_rec.program_application_id,
291: l_OKL_cure_payment_lines_rec.transaction_id,
292: l_OKL_cure_payment_lines_rec.tai_id,
293: l_OKL_cure_payment_lines_rec.process_status,
294: l_OKL_cure_payment_lines_rec.rct_id,
295: l_OKL_cure_payment_lines_rec.object_version_number,
296: l_OKL_cure_payment_lines_rec.org_id,
297: l_OKL_cure_payment_lines_rec.request_id,
298: l_OKL_cure_payment_lines_rec.program_application_id,
299: l_OKL_cure_payment_lines_rec.program_id,
292: l_OKL_cure_payment_lines_rec.tai_id,
293: l_OKL_cure_payment_lines_rec.process_status,
294: l_OKL_cure_payment_lines_rec.rct_id,
295: l_OKL_cure_payment_lines_rec.object_version_number,
296: l_OKL_cure_payment_lines_rec.org_id,
297: l_OKL_cure_payment_lines_rec.request_id,
298: l_OKL_cure_payment_lines_rec.program_application_id,
299: l_OKL_cure_payment_lines_rec.program_id,
300: l_OKL_cure_payment_lines_rec.program_update_date,
293: l_OKL_cure_payment_lines_rec.process_status,
294: l_OKL_cure_payment_lines_rec.rct_id,
295: l_OKL_cure_payment_lines_rec.object_version_number,
296: l_OKL_cure_payment_lines_rec.org_id,
297: l_OKL_cure_payment_lines_rec.request_id,
298: l_OKL_cure_payment_lines_rec.program_application_id,
299: l_OKL_cure_payment_lines_rec.program_id,
300: l_OKL_cure_payment_lines_rec.program_update_date,
301: l_OKL_cure_payment_lines_rec.attribute_category,
294: l_OKL_cure_payment_lines_rec.rct_id,
295: l_OKL_cure_payment_lines_rec.object_version_number,
296: l_OKL_cure_payment_lines_rec.org_id,
297: l_OKL_cure_payment_lines_rec.request_id,
298: l_OKL_cure_payment_lines_rec.program_application_id,
299: l_OKL_cure_payment_lines_rec.program_id,
300: l_OKL_cure_payment_lines_rec.program_update_date,
301: l_OKL_cure_payment_lines_rec.attribute_category,
302: l_OKL_cure_payment_lines_rec.attribute1,
295: l_OKL_cure_payment_lines_rec.object_version_number,
296: l_OKL_cure_payment_lines_rec.org_id,
297: l_OKL_cure_payment_lines_rec.request_id,
298: l_OKL_cure_payment_lines_rec.program_application_id,
299: l_OKL_cure_payment_lines_rec.program_id,
300: l_OKL_cure_payment_lines_rec.program_update_date,
301: l_OKL_cure_payment_lines_rec.attribute_category,
302: l_OKL_cure_payment_lines_rec.attribute1,
303: l_OKL_cure_payment_lines_rec.attribute2,
296: l_OKL_cure_payment_lines_rec.org_id,
297: l_OKL_cure_payment_lines_rec.request_id,
298: l_OKL_cure_payment_lines_rec.program_application_id,
299: l_OKL_cure_payment_lines_rec.program_id,
300: l_OKL_cure_payment_lines_rec.program_update_date,
301: l_OKL_cure_payment_lines_rec.attribute_category,
302: l_OKL_cure_payment_lines_rec.attribute1,
303: l_OKL_cure_payment_lines_rec.attribute2,
304: l_OKL_cure_payment_lines_rec.attribute3,
297: l_OKL_cure_payment_lines_rec.request_id,
298: l_OKL_cure_payment_lines_rec.program_application_id,
299: l_OKL_cure_payment_lines_rec.program_id,
300: l_OKL_cure_payment_lines_rec.program_update_date,
301: l_OKL_cure_payment_lines_rec.attribute_category,
302: l_OKL_cure_payment_lines_rec.attribute1,
303: l_OKL_cure_payment_lines_rec.attribute2,
304: l_OKL_cure_payment_lines_rec.attribute3,
305: l_OKL_cure_payment_lines_rec.attribute4,
298: l_OKL_cure_payment_lines_rec.program_application_id,
299: l_OKL_cure_payment_lines_rec.program_id,
300: l_OKL_cure_payment_lines_rec.program_update_date,
301: l_OKL_cure_payment_lines_rec.attribute_category,
302: l_OKL_cure_payment_lines_rec.attribute1,
303: l_OKL_cure_payment_lines_rec.attribute2,
304: l_OKL_cure_payment_lines_rec.attribute3,
305: l_OKL_cure_payment_lines_rec.attribute4,
306: l_OKL_cure_payment_lines_rec.attribute5,
299: l_OKL_cure_payment_lines_rec.program_id,
300: l_OKL_cure_payment_lines_rec.program_update_date,
301: l_OKL_cure_payment_lines_rec.attribute_category,
302: l_OKL_cure_payment_lines_rec.attribute1,
303: l_OKL_cure_payment_lines_rec.attribute2,
304: l_OKL_cure_payment_lines_rec.attribute3,
305: l_OKL_cure_payment_lines_rec.attribute4,
306: l_OKL_cure_payment_lines_rec.attribute5,
307: l_OKL_cure_payment_lines_rec.attribute6,
300: l_OKL_cure_payment_lines_rec.program_update_date,
301: l_OKL_cure_payment_lines_rec.attribute_category,
302: l_OKL_cure_payment_lines_rec.attribute1,
303: l_OKL_cure_payment_lines_rec.attribute2,
304: l_OKL_cure_payment_lines_rec.attribute3,
305: l_OKL_cure_payment_lines_rec.attribute4,
306: l_OKL_cure_payment_lines_rec.attribute5,
307: l_OKL_cure_payment_lines_rec.attribute6,
308: l_OKL_cure_payment_lines_rec.attribute7,
301: l_OKL_cure_payment_lines_rec.attribute_category,
302: l_OKL_cure_payment_lines_rec.attribute1,
303: l_OKL_cure_payment_lines_rec.attribute2,
304: l_OKL_cure_payment_lines_rec.attribute3,
305: l_OKL_cure_payment_lines_rec.attribute4,
306: l_OKL_cure_payment_lines_rec.attribute5,
307: l_OKL_cure_payment_lines_rec.attribute6,
308: l_OKL_cure_payment_lines_rec.attribute7,
309: l_OKL_cure_payment_lines_rec.attribute8,
302: l_OKL_cure_payment_lines_rec.attribute1,
303: l_OKL_cure_payment_lines_rec.attribute2,
304: l_OKL_cure_payment_lines_rec.attribute3,
305: l_OKL_cure_payment_lines_rec.attribute4,
306: l_OKL_cure_payment_lines_rec.attribute5,
307: l_OKL_cure_payment_lines_rec.attribute6,
308: l_OKL_cure_payment_lines_rec.attribute7,
309: l_OKL_cure_payment_lines_rec.attribute8,
310: l_OKL_cure_payment_lines_rec.attribute9,
303: l_OKL_cure_payment_lines_rec.attribute2,
304: l_OKL_cure_payment_lines_rec.attribute3,
305: l_OKL_cure_payment_lines_rec.attribute4,
306: l_OKL_cure_payment_lines_rec.attribute5,
307: l_OKL_cure_payment_lines_rec.attribute6,
308: l_OKL_cure_payment_lines_rec.attribute7,
309: l_OKL_cure_payment_lines_rec.attribute8,
310: l_OKL_cure_payment_lines_rec.attribute9,
311: l_OKL_cure_payment_lines_rec.attribute10,
304: l_OKL_cure_payment_lines_rec.attribute3,
305: l_OKL_cure_payment_lines_rec.attribute4,
306: l_OKL_cure_payment_lines_rec.attribute5,
307: l_OKL_cure_payment_lines_rec.attribute6,
308: l_OKL_cure_payment_lines_rec.attribute7,
309: l_OKL_cure_payment_lines_rec.attribute8,
310: l_OKL_cure_payment_lines_rec.attribute9,
311: l_OKL_cure_payment_lines_rec.attribute10,
312: l_OKL_cure_payment_lines_rec.attribute11,
305: l_OKL_cure_payment_lines_rec.attribute4,
306: l_OKL_cure_payment_lines_rec.attribute5,
307: l_OKL_cure_payment_lines_rec.attribute6,
308: l_OKL_cure_payment_lines_rec.attribute7,
309: l_OKL_cure_payment_lines_rec.attribute8,
310: l_OKL_cure_payment_lines_rec.attribute9,
311: l_OKL_cure_payment_lines_rec.attribute10,
312: l_OKL_cure_payment_lines_rec.attribute11,
313: l_OKL_cure_payment_lines_rec.attribute12,
306: l_OKL_cure_payment_lines_rec.attribute5,
307: l_OKL_cure_payment_lines_rec.attribute6,
308: l_OKL_cure_payment_lines_rec.attribute7,
309: l_OKL_cure_payment_lines_rec.attribute8,
310: l_OKL_cure_payment_lines_rec.attribute9,
311: l_OKL_cure_payment_lines_rec.attribute10,
312: l_OKL_cure_payment_lines_rec.attribute11,
313: l_OKL_cure_payment_lines_rec.attribute12,
314: l_OKL_cure_payment_lines_rec.attribute13,
307: l_OKL_cure_payment_lines_rec.attribute6,
308: l_OKL_cure_payment_lines_rec.attribute7,
309: l_OKL_cure_payment_lines_rec.attribute8,
310: l_OKL_cure_payment_lines_rec.attribute9,
311: l_OKL_cure_payment_lines_rec.attribute10,
312: l_OKL_cure_payment_lines_rec.attribute11,
313: l_OKL_cure_payment_lines_rec.attribute12,
314: l_OKL_cure_payment_lines_rec.attribute13,
315: l_OKL_cure_payment_lines_rec.attribute14,
308: l_OKL_cure_payment_lines_rec.attribute7,
309: l_OKL_cure_payment_lines_rec.attribute8,
310: l_OKL_cure_payment_lines_rec.attribute9,
311: l_OKL_cure_payment_lines_rec.attribute10,
312: l_OKL_cure_payment_lines_rec.attribute11,
313: l_OKL_cure_payment_lines_rec.attribute12,
314: l_OKL_cure_payment_lines_rec.attribute13,
315: l_OKL_cure_payment_lines_rec.attribute14,
316: l_OKL_cure_payment_lines_rec.attribute15,
309: l_OKL_cure_payment_lines_rec.attribute8,
310: l_OKL_cure_payment_lines_rec.attribute9,
311: l_OKL_cure_payment_lines_rec.attribute10,
312: l_OKL_cure_payment_lines_rec.attribute11,
313: l_OKL_cure_payment_lines_rec.attribute12,
314: l_OKL_cure_payment_lines_rec.attribute13,
315: l_OKL_cure_payment_lines_rec.attribute14,
316: l_OKL_cure_payment_lines_rec.attribute15,
317: l_OKL_cure_payment_lines_rec.created_by,
310: l_OKL_cure_payment_lines_rec.attribute9,
311: l_OKL_cure_payment_lines_rec.attribute10,
312: l_OKL_cure_payment_lines_rec.attribute11,
313: l_OKL_cure_payment_lines_rec.attribute12,
314: l_OKL_cure_payment_lines_rec.attribute13,
315: l_OKL_cure_payment_lines_rec.attribute14,
316: l_OKL_cure_payment_lines_rec.attribute15,
317: l_OKL_cure_payment_lines_rec.created_by,
318: l_OKL_cure_payment_lines_rec.creation_date,
311: l_OKL_cure_payment_lines_rec.attribute10,
312: l_OKL_cure_payment_lines_rec.attribute11,
313: l_OKL_cure_payment_lines_rec.attribute12,
314: l_OKL_cure_payment_lines_rec.attribute13,
315: l_OKL_cure_payment_lines_rec.attribute14,
316: l_OKL_cure_payment_lines_rec.attribute15,
317: l_OKL_cure_payment_lines_rec.created_by,
318: l_OKL_cure_payment_lines_rec.creation_date,
319: l_OKL_cure_payment_lines_rec.last_updated_by,
312: l_OKL_cure_payment_lines_rec.attribute11,
313: l_OKL_cure_payment_lines_rec.attribute12,
314: l_OKL_cure_payment_lines_rec.attribute13,
315: l_OKL_cure_payment_lines_rec.attribute14,
316: l_OKL_cure_payment_lines_rec.attribute15,
317: l_OKL_cure_payment_lines_rec.created_by,
318: l_OKL_cure_payment_lines_rec.creation_date,
319: l_OKL_cure_payment_lines_rec.last_updated_by,
320: l_OKL_cure_payment_lines_rec.last_update_date,
313: l_OKL_cure_payment_lines_rec.attribute12,
314: l_OKL_cure_payment_lines_rec.attribute13,
315: l_OKL_cure_payment_lines_rec.attribute14,
316: l_OKL_cure_payment_lines_rec.attribute15,
317: l_OKL_cure_payment_lines_rec.created_by,
318: l_OKL_cure_payment_lines_rec.creation_date,
319: l_OKL_cure_payment_lines_rec.last_updated_by,
320: l_OKL_cure_payment_lines_rec.last_update_date,
321: l_OKL_cure_payment_lines_rec.last_update_login;
314: l_OKL_cure_payment_lines_rec.attribute13,
315: l_OKL_cure_payment_lines_rec.attribute14,
316: l_OKL_cure_payment_lines_rec.attribute15,
317: l_OKL_cure_payment_lines_rec.created_by,
318: l_OKL_cure_payment_lines_rec.creation_date,
319: l_OKL_cure_payment_lines_rec.last_updated_by,
320: l_OKL_cure_payment_lines_rec.last_update_date,
321: l_OKL_cure_payment_lines_rec.last_update_login;
322: x_no_data_found := OKL_cure_payment_line_pk_csr%NOTFOUND;
315: l_OKL_cure_payment_lines_rec.attribute14,
316: l_OKL_cure_payment_lines_rec.attribute15,
317: l_OKL_cure_payment_lines_rec.created_by,
318: l_OKL_cure_payment_lines_rec.creation_date,
319: l_OKL_cure_payment_lines_rec.last_updated_by,
320: l_OKL_cure_payment_lines_rec.last_update_date,
321: l_OKL_cure_payment_lines_rec.last_update_login;
322: x_no_data_found := OKL_cure_payment_line_pk_csr%NOTFOUND;
323: CLOSE OKL_cure_payment_line_pk_csr;
316: l_OKL_cure_payment_lines_rec.attribute15,
317: l_OKL_cure_payment_lines_rec.created_by,
318: l_OKL_cure_payment_lines_rec.creation_date,
319: l_OKL_cure_payment_lines_rec.last_updated_by,
320: l_OKL_cure_payment_lines_rec.last_update_date,
321: l_OKL_cure_payment_lines_rec.last_update_login;
322: x_no_data_found := OKL_cure_payment_line_pk_csr%NOTFOUND;
323: CLOSE OKL_cure_payment_line_pk_csr;
324: RETURN(l_OKL_cure_payment_lines_rec);
317: l_OKL_cure_payment_lines_rec.created_by,
318: l_OKL_cure_payment_lines_rec.creation_date,
319: l_OKL_cure_payment_lines_rec.last_updated_by,
320: l_OKL_cure_payment_lines_rec.last_update_date,
321: l_OKL_cure_payment_lines_rec.last_update_login;
322: x_no_data_found := OKL_cure_payment_line_pk_csr%NOTFOUND;
323: CLOSE OKL_cure_payment_line_pk_csr;
324: RETURN(l_OKL_cure_payment_lines_rec);
325: END get_rec;
320: l_OKL_cure_payment_lines_rec.last_update_date,
321: l_OKL_cure_payment_lines_rec.last_update_login;
322: x_no_data_found := OKL_cure_payment_line_pk_csr%NOTFOUND;
323: CLOSE OKL_cure_payment_line_pk_csr;
324: RETURN(l_OKL_cure_payment_lines_rec);
325: END get_rec;
326:
327: ------------------------------------------------------------------
328: -- This version of get_rec sets error messages if no data found --
327: ------------------------------------------------------------------
328: -- This version of get_rec sets error messages if no data found --
329: ------------------------------------------------------------------
330: FUNCTION get_rec (
331: p_OKL_cure_payment_lines_rec IN OKLCurePaymentLinesRecType,
332: x_return_status OUT NOCOPY VARCHAR2
333: ) RETURN OKLCurePaymentLinesRecType IS
334: l_OKL_cure_payment_lines_rec OKLCurePaymentLinesRecType;
335: l_row_notfound BOOLEAN := TRUE;
330: FUNCTION get_rec (
331: p_OKL_cure_payment_lines_rec IN OKLCurePaymentLinesRecType,
332: x_return_status OUT NOCOPY VARCHAR2
333: ) RETURN OKLCurePaymentLinesRecType IS
334: l_OKL_cure_payment_lines_rec OKLCurePaymentLinesRecType;
335: l_row_notfound BOOLEAN := TRUE;
336: BEGIN
337: x_return_status := OKC_API.G_RET_STS_SUCCESS;
338: l_OKL_cure_payment_lines_rec := get_rec(p_OKL_cure_payment_lines_rec, l_row_notfound);
334: l_OKL_cure_payment_lines_rec OKLCurePaymentLinesRecType;
335: l_row_notfound BOOLEAN := TRUE;
336: BEGIN
337: x_return_status := OKC_API.G_RET_STS_SUCCESS;
338: l_OKL_cure_payment_lines_rec := get_rec(p_OKL_cure_payment_lines_rec, l_row_notfound);
339: IF (l_row_notfound) THEN
340: OKC_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'CURE_PAYMENT_LINE_ID');
341: x_return_status := OKC_API.G_RET_STS_ERROR;
342: END IF;
339: IF (l_row_notfound) THEN
340: OKC_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'CURE_PAYMENT_LINE_ID');
341: x_return_status := OKC_API.G_RET_STS_ERROR;
342: END IF;
343: RETURN(l_OKL_cure_payment_lines_rec);
344: END get_rec;
345: -----------------------------------------------------------
346: -- So we don't have to pass an "l_row_notfound" variable --
347: -----------------------------------------------------------
345: -----------------------------------------------------------
346: -- So we don't have to pass an "l_row_notfound" variable --
347: -----------------------------------------------------------
348: FUNCTION get_rec (
349: p_OKL_cure_payment_lines_rec IN OKLCurePaymentLinesRecType
350: ) RETURN OKLCurePaymentLinesRecType IS
351: l_row_not_found BOOLEAN := TRUE;
352: BEGIN
353: RETURN(get_rec(p_OKL_cure_payment_lines_rec, l_row_not_found));
349: p_OKL_cure_payment_lines_rec IN OKLCurePaymentLinesRecType
350: ) RETURN OKLCurePaymentLinesRecType IS
351: l_row_not_found BOOLEAN := TRUE;
352: BEGIN
353: RETURN(get_rec(p_OKL_cure_payment_lines_rec, l_row_not_found));
354: END get_rec;
355: ---------------------------------------------------------------------------
356: -- FUNCTION null_out_defaults for: OKL_CURE_PAYMENT_LINES_V
357: ---------------------------------------------------------------------------
352: BEGIN
353: RETURN(get_rec(p_OKL_cure_payment_lines_rec, l_row_not_found));
354: END get_rec;
355: ---------------------------------------------------------------------------
356: -- FUNCTION null_out_defaults for: OKL_CURE_PAYMENT_LINES_V
357: ---------------------------------------------------------------------------
358: FUNCTION null_out_defaults (
359: p_CPNv_rec IN CPNv_rec_type
360: ) RETURN CPNv_rec_type IS
593: ---------------------------------------------------------------------------
594: -- FUNCTION Validate_Attributes
595: ---------------------------------------------------------------------------
596: ------------------------------------------------------
597: -- Validate_Attributes for:OKL_CURE_PAYMENT_LINES_V --
598: ------------------------------------------------------
599: FUNCTION Validate_Attributes (
600: p_CPNv_rec IN CPNv_rec_type
601: ) RETURN VARCHAR2 IS
674: ---------------------------------------------------------------------------
675: -- PROCEDURE Validate_Record
676: ---------------------------------------------------------------------------
677: --------------------------------------------------
678: -- Validate Record for:OKL_CURE_PAYMENT_LINES_V --
679: --------------------------------------------------
680: FUNCTION Validate_Record (
681: p_CPNv_rec IN CPNv_rec_type,
682: p_db_CPNv_rec IN CPNv_rec_type
794: ---------------------------------------------------------------------------
795: -- PROCEDURE validate_row
796: ---------------------------------------------------------------------------
797: -----------------------------------------------
798: -- validate_row for:OKL_CURE_PAYMENT_LINES_V --
799: -----------------------------------------------
800: PROCEDURE validate_row(
801: p_api_version IN NUMBER,
802: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
808: l_api_version CONSTANT NUMBER := 1;
809: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
810: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
811: l_CPNv_rec CPNv_rec_type := p_CPNv_rec;
812: l_OKL_cure_payment_lines_rec OKLCurePaymentLinesRecType;
813: l_OKL_cure_payment_lines_rec OKLCurePaymentLinesRecType;
814: BEGIN
815: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
816: G_PKG_NAME,
809: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
810: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
811: l_CPNv_rec CPNv_rec_type := p_CPNv_rec;
812: l_OKL_cure_payment_lines_rec OKLCurePaymentLinesRecType;
813: l_OKL_cure_payment_lines_rec OKLCurePaymentLinesRecType;
814: BEGIN
815: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
816: G_PKG_NAME,
817: p_init_msg_list,
871: '_PVT'
872: );
873: END validate_row;
874: ----------------------------------------------------------
875: -- PL/SQL TBL validate_row for:OKL_CURE_PAYMENT_LINES_V --
876: ----------------------------------------------------------
877: PROCEDURE validate_row(
878: p_api_version IN NUMBER,
879: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
967: );
968: END validate_row;
969:
970: ----------------------------------------------------------
971: -- PL/SQL TBL validate_row for:OKL_CURE_PAYMENT_LINES_V --
972: ----------------------------------------------------------
973: PROCEDURE validate_row(
974: p_api_version IN NUMBER,
975: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1032: ---------------------------------------------------------------------------
1033: -- PROCEDURE insert_row
1034: ---------------------------------------------------------------------------
1035: -------------------------------------------
1036: -- insert_row for:OKL_CURE_PAYMENT_LINES --
1037: -------------------------------------------
1038: PROCEDURE insert_row(
1039: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1040: x_return_status OUT NOCOPY VARCHAR2,
1039: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1040: x_return_status OUT NOCOPY VARCHAR2,
1041: x_msg_count OUT NOCOPY NUMBER,
1042: x_msg_data OUT NOCOPY VARCHAR2,
1043: p_OKL_cure_payment_lines_rec IN OKLCurePaymentLinesRecType,
1044: x_OKL_cure_payment_lines_rec OUT NOCOPY OKLCurePaymentLinesRecType) IS
1045:
1046: l_api_version CONSTANT NUMBER := 1;
1047: l_api_name CONSTANT VARCHAR2(30) := 'B_insert_row';
1040: x_return_status OUT NOCOPY VARCHAR2,
1041: x_msg_count OUT NOCOPY NUMBER,
1042: x_msg_data OUT NOCOPY VARCHAR2,
1043: p_OKL_cure_payment_lines_rec IN OKLCurePaymentLinesRecType,
1044: x_OKL_cure_payment_lines_rec OUT NOCOPY OKLCurePaymentLinesRecType) IS
1045:
1046: l_api_version CONSTANT NUMBER := 1;
1047: l_api_name CONSTANT VARCHAR2(30) := 'B_insert_row';
1048: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1045:
1046: l_api_version CONSTANT NUMBER := 1;
1047: l_api_name CONSTANT VARCHAR2(30) := 'B_insert_row';
1048: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1049: l_OKL_cure_payment_lines_rec OKLCurePaymentLinesRecType := p_OKL_cure_payment_lines_rec;
1050: LDefOKLCurePaymentLinesRec OKLCurePaymentLinesRecType;
1051: -----------------------------------------------
1052: -- Set_Attributes for:OKL_CURE_PAYMENT_LINES --
1053: -----------------------------------------------
1048: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1049: l_OKL_cure_payment_lines_rec OKLCurePaymentLinesRecType := p_OKL_cure_payment_lines_rec;
1050: LDefOKLCurePaymentLinesRec OKLCurePaymentLinesRecType;
1051: -----------------------------------------------
1052: -- Set_Attributes for:OKL_CURE_PAYMENT_LINES --
1053: -----------------------------------------------
1054: FUNCTION Set_Attributes (
1055: p_OKL_cure_payment_lines_rec IN OKLCurePaymentLinesRecType,
1056: x_OKL_cure_payment_lines_rec OUT NOCOPY OKLCurePaymentLinesRecType
1051: -----------------------------------------------
1052: -- Set_Attributes for:OKL_CURE_PAYMENT_LINES --
1053: -----------------------------------------------
1054: FUNCTION Set_Attributes (
1055: p_OKL_cure_payment_lines_rec IN OKLCurePaymentLinesRecType,
1056: x_OKL_cure_payment_lines_rec OUT NOCOPY OKLCurePaymentLinesRecType
1057: ) RETURN VARCHAR2 IS
1058: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1059: BEGIN
1052: -- Set_Attributes for:OKL_CURE_PAYMENT_LINES --
1053: -----------------------------------------------
1054: FUNCTION Set_Attributes (
1055: p_OKL_cure_payment_lines_rec IN OKLCurePaymentLinesRecType,
1056: x_OKL_cure_payment_lines_rec OUT NOCOPY OKLCurePaymentLinesRecType
1057: ) RETURN VARCHAR2 IS
1058: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1059: BEGIN
1060: x_OKL_cure_payment_lines_rec := p_OKL_cure_payment_lines_rec;
1056: x_OKL_cure_payment_lines_rec OUT NOCOPY OKLCurePaymentLinesRecType
1057: ) RETURN VARCHAR2 IS
1058: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1059: BEGIN
1060: x_OKL_cure_payment_lines_rec := p_OKL_cure_payment_lines_rec;
1061: RETURN(l_return_status);
1062: END Set_Attributes;
1063: BEGIN
1064: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1071: RAISE OKC_API.G_EXCEPTION_ERROR;
1072: END IF;
1073: --- Setting item atributes
1074: l_return_status := Set_Attributes(
1075: p_OKL_cure_payment_lines_rec, -- IN
1076: l_OKL_cure_payment_lines_rec); -- OUT
1077: --- If any errors happen abort API
1078: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1079: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1072: END IF;
1073: --- Setting item atributes
1074: l_return_status := Set_Attributes(
1075: p_OKL_cure_payment_lines_rec, -- IN
1076: l_OKL_cure_payment_lines_rec); -- OUT
1077: --- If any errors happen abort API
1078: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1079: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1080: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1079: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1080: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1081: RAISE OKC_API.G_EXCEPTION_ERROR;
1082: END IF;
1083: INSERT INTO OKL_CURE_PAYMENT_LINES(
1084: cure_payment_line_id,
1085: cure_payment_id,
1086: chr_id,
1087: amount,
1121: last_updated_by,
1122: last_update_date,
1123: last_update_login)
1124: VALUES (
1125: l_OKL_cure_payment_lines_rec.cure_payment_line_id,
1126: l_OKL_cure_payment_lines_rec.cure_payment_id,
1127: l_OKL_cure_payment_lines_rec.chr_id,
1128: l_OKL_cure_payment_lines_rec.amount,
1129: l_OKL_cure_payment_lines_rec.cured_flag,
1122: last_update_date,
1123: last_update_login)
1124: VALUES (
1125: l_OKL_cure_payment_lines_rec.cure_payment_line_id,
1126: l_OKL_cure_payment_lines_rec.cure_payment_id,
1127: l_OKL_cure_payment_lines_rec.chr_id,
1128: l_OKL_cure_payment_lines_rec.amount,
1129: l_OKL_cure_payment_lines_rec.cured_flag,
1130: l_OKL_cure_payment_lines_rec.status,
1123: last_update_login)
1124: VALUES (
1125: l_OKL_cure_payment_lines_rec.cure_payment_line_id,
1126: l_OKL_cure_payment_lines_rec.cure_payment_id,
1127: l_OKL_cure_payment_lines_rec.chr_id,
1128: l_OKL_cure_payment_lines_rec.amount,
1129: l_OKL_cure_payment_lines_rec.cured_flag,
1130: l_OKL_cure_payment_lines_rec.status,
1131: l_OKL_cure_payment_lines_rec.cure_refund_id,
1124: VALUES (
1125: l_OKL_cure_payment_lines_rec.cure_payment_line_id,
1126: l_OKL_cure_payment_lines_rec.cure_payment_id,
1127: l_OKL_cure_payment_lines_rec.chr_id,
1128: l_OKL_cure_payment_lines_rec.amount,
1129: l_OKL_cure_payment_lines_rec.cured_flag,
1130: l_OKL_cure_payment_lines_rec.status,
1131: l_OKL_cure_payment_lines_rec.cure_refund_id,
1132: l_OKL_cure_payment_lines_rec.approval_status,
1125: l_OKL_cure_payment_lines_rec.cure_payment_line_id,
1126: l_OKL_cure_payment_lines_rec.cure_payment_id,
1127: l_OKL_cure_payment_lines_rec.chr_id,
1128: l_OKL_cure_payment_lines_rec.amount,
1129: l_OKL_cure_payment_lines_rec.cured_flag,
1130: l_OKL_cure_payment_lines_rec.status,
1131: l_OKL_cure_payment_lines_rec.cure_refund_id,
1132: l_OKL_cure_payment_lines_rec.approval_status,
1133: l_OKL_cure_payment_lines_rec.approval_reason,
1126: l_OKL_cure_payment_lines_rec.cure_payment_id,
1127: l_OKL_cure_payment_lines_rec.chr_id,
1128: l_OKL_cure_payment_lines_rec.amount,
1129: l_OKL_cure_payment_lines_rec.cured_flag,
1130: l_OKL_cure_payment_lines_rec.status,
1131: l_OKL_cure_payment_lines_rec.cure_refund_id,
1132: l_OKL_cure_payment_lines_rec.approval_status,
1133: l_OKL_cure_payment_lines_rec.approval_reason,
1134: l_OKL_cure_payment_lines_rec.transaction_id,
1127: l_OKL_cure_payment_lines_rec.chr_id,
1128: l_OKL_cure_payment_lines_rec.amount,
1129: l_OKL_cure_payment_lines_rec.cured_flag,
1130: l_OKL_cure_payment_lines_rec.status,
1131: l_OKL_cure_payment_lines_rec.cure_refund_id,
1132: l_OKL_cure_payment_lines_rec.approval_status,
1133: l_OKL_cure_payment_lines_rec.approval_reason,
1134: l_OKL_cure_payment_lines_rec.transaction_id,
1135: l_OKL_cure_payment_lines_rec.tai_id,
1128: l_OKL_cure_payment_lines_rec.amount,
1129: l_OKL_cure_payment_lines_rec.cured_flag,
1130: l_OKL_cure_payment_lines_rec.status,
1131: l_OKL_cure_payment_lines_rec.cure_refund_id,
1132: l_OKL_cure_payment_lines_rec.approval_status,
1133: l_OKL_cure_payment_lines_rec.approval_reason,
1134: l_OKL_cure_payment_lines_rec.transaction_id,
1135: l_OKL_cure_payment_lines_rec.tai_id,
1136: l_OKL_cure_payment_lines_rec.process_status,
1129: l_OKL_cure_payment_lines_rec.cured_flag,
1130: l_OKL_cure_payment_lines_rec.status,
1131: l_OKL_cure_payment_lines_rec.cure_refund_id,
1132: l_OKL_cure_payment_lines_rec.approval_status,
1133: l_OKL_cure_payment_lines_rec.approval_reason,
1134: l_OKL_cure_payment_lines_rec.transaction_id,
1135: l_OKL_cure_payment_lines_rec.tai_id,
1136: l_OKL_cure_payment_lines_rec.process_status,
1137: l_OKL_cure_payment_lines_rec.rct_id,
1130: l_OKL_cure_payment_lines_rec.status,
1131: l_OKL_cure_payment_lines_rec.cure_refund_id,
1132: l_OKL_cure_payment_lines_rec.approval_status,
1133: l_OKL_cure_payment_lines_rec.approval_reason,
1134: l_OKL_cure_payment_lines_rec.transaction_id,
1135: l_OKL_cure_payment_lines_rec.tai_id,
1136: l_OKL_cure_payment_lines_rec.process_status,
1137: l_OKL_cure_payment_lines_rec.rct_id,
1138: l_OKL_cure_payment_lines_rec.object_version_number,
1131: l_OKL_cure_payment_lines_rec.cure_refund_id,
1132: l_OKL_cure_payment_lines_rec.approval_status,
1133: l_OKL_cure_payment_lines_rec.approval_reason,
1134: l_OKL_cure_payment_lines_rec.transaction_id,
1135: l_OKL_cure_payment_lines_rec.tai_id,
1136: l_OKL_cure_payment_lines_rec.process_status,
1137: l_OKL_cure_payment_lines_rec.rct_id,
1138: l_OKL_cure_payment_lines_rec.object_version_number,
1139: l_OKL_cure_payment_lines_rec.org_id,
1132: l_OKL_cure_payment_lines_rec.approval_status,
1133: l_OKL_cure_payment_lines_rec.approval_reason,
1134: l_OKL_cure_payment_lines_rec.transaction_id,
1135: l_OKL_cure_payment_lines_rec.tai_id,
1136: l_OKL_cure_payment_lines_rec.process_status,
1137: l_OKL_cure_payment_lines_rec.rct_id,
1138: l_OKL_cure_payment_lines_rec.object_version_number,
1139: l_OKL_cure_payment_lines_rec.org_id,
1140: l_OKL_cure_payment_lines_rec.request_id,
1133: l_OKL_cure_payment_lines_rec.approval_reason,
1134: l_OKL_cure_payment_lines_rec.transaction_id,
1135: l_OKL_cure_payment_lines_rec.tai_id,
1136: l_OKL_cure_payment_lines_rec.process_status,
1137: l_OKL_cure_payment_lines_rec.rct_id,
1138: l_OKL_cure_payment_lines_rec.object_version_number,
1139: l_OKL_cure_payment_lines_rec.org_id,
1140: l_OKL_cure_payment_lines_rec.request_id,
1141: l_OKL_cure_payment_lines_rec.program_application_id,
1134: l_OKL_cure_payment_lines_rec.transaction_id,
1135: l_OKL_cure_payment_lines_rec.tai_id,
1136: l_OKL_cure_payment_lines_rec.process_status,
1137: l_OKL_cure_payment_lines_rec.rct_id,
1138: l_OKL_cure_payment_lines_rec.object_version_number,
1139: l_OKL_cure_payment_lines_rec.org_id,
1140: l_OKL_cure_payment_lines_rec.request_id,
1141: l_OKL_cure_payment_lines_rec.program_application_id,
1142: l_OKL_cure_payment_lines_rec.program_id,
1135: l_OKL_cure_payment_lines_rec.tai_id,
1136: l_OKL_cure_payment_lines_rec.process_status,
1137: l_OKL_cure_payment_lines_rec.rct_id,
1138: l_OKL_cure_payment_lines_rec.object_version_number,
1139: l_OKL_cure_payment_lines_rec.org_id,
1140: l_OKL_cure_payment_lines_rec.request_id,
1141: l_OKL_cure_payment_lines_rec.program_application_id,
1142: l_OKL_cure_payment_lines_rec.program_id,
1143: l_OKL_cure_payment_lines_rec.program_update_date,
1136: l_OKL_cure_payment_lines_rec.process_status,
1137: l_OKL_cure_payment_lines_rec.rct_id,
1138: l_OKL_cure_payment_lines_rec.object_version_number,
1139: l_OKL_cure_payment_lines_rec.org_id,
1140: l_OKL_cure_payment_lines_rec.request_id,
1141: l_OKL_cure_payment_lines_rec.program_application_id,
1142: l_OKL_cure_payment_lines_rec.program_id,
1143: l_OKL_cure_payment_lines_rec.program_update_date,
1144: l_OKL_cure_payment_lines_rec.attribute_category,
1137: l_OKL_cure_payment_lines_rec.rct_id,
1138: l_OKL_cure_payment_lines_rec.object_version_number,
1139: l_OKL_cure_payment_lines_rec.org_id,
1140: l_OKL_cure_payment_lines_rec.request_id,
1141: l_OKL_cure_payment_lines_rec.program_application_id,
1142: l_OKL_cure_payment_lines_rec.program_id,
1143: l_OKL_cure_payment_lines_rec.program_update_date,
1144: l_OKL_cure_payment_lines_rec.attribute_category,
1145: l_OKL_cure_payment_lines_rec.attribute1,
1138: l_OKL_cure_payment_lines_rec.object_version_number,
1139: l_OKL_cure_payment_lines_rec.org_id,
1140: l_OKL_cure_payment_lines_rec.request_id,
1141: l_OKL_cure_payment_lines_rec.program_application_id,
1142: l_OKL_cure_payment_lines_rec.program_id,
1143: l_OKL_cure_payment_lines_rec.program_update_date,
1144: l_OKL_cure_payment_lines_rec.attribute_category,
1145: l_OKL_cure_payment_lines_rec.attribute1,
1146: l_OKL_cure_payment_lines_rec.attribute2,
1139: l_OKL_cure_payment_lines_rec.org_id,
1140: l_OKL_cure_payment_lines_rec.request_id,
1141: l_OKL_cure_payment_lines_rec.program_application_id,
1142: l_OKL_cure_payment_lines_rec.program_id,
1143: l_OKL_cure_payment_lines_rec.program_update_date,
1144: l_OKL_cure_payment_lines_rec.attribute_category,
1145: l_OKL_cure_payment_lines_rec.attribute1,
1146: l_OKL_cure_payment_lines_rec.attribute2,
1147: l_OKL_cure_payment_lines_rec.attribute3,
1140: l_OKL_cure_payment_lines_rec.request_id,
1141: l_OKL_cure_payment_lines_rec.program_application_id,
1142: l_OKL_cure_payment_lines_rec.program_id,
1143: l_OKL_cure_payment_lines_rec.program_update_date,
1144: l_OKL_cure_payment_lines_rec.attribute_category,
1145: l_OKL_cure_payment_lines_rec.attribute1,
1146: l_OKL_cure_payment_lines_rec.attribute2,
1147: l_OKL_cure_payment_lines_rec.attribute3,
1148: l_OKL_cure_payment_lines_rec.attribute4,
1141: l_OKL_cure_payment_lines_rec.program_application_id,
1142: l_OKL_cure_payment_lines_rec.program_id,
1143: l_OKL_cure_payment_lines_rec.program_update_date,
1144: l_OKL_cure_payment_lines_rec.attribute_category,
1145: l_OKL_cure_payment_lines_rec.attribute1,
1146: l_OKL_cure_payment_lines_rec.attribute2,
1147: l_OKL_cure_payment_lines_rec.attribute3,
1148: l_OKL_cure_payment_lines_rec.attribute4,
1149: l_OKL_cure_payment_lines_rec.attribute5,
1142: l_OKL_cure_payment_lines_rec.program_id,
1143: l_OKL_cure_payment_lines_rec.program_update_date,
1144: l_OKL_cure_payment_lines_rec.attribute_category,
1145: l_OKL_cure_payment_lines_rec.attribute1,
1146: l_OKL_cure_payment_lines_rec.attribute2,
1147: l_OKL_cure_payment_lines_rec.attribute3,
1148: l_OKL_cure_payment_lines_rec.attribute4,
1149: l_OKL_cure_payment_lines_rec.attribute5,
1150: l_OKL_cure_payment_lines_rec.attribute6,
1143: l_OKL_cure_payment_lines_rec.program_update_date,
1144: l_OKL_cure_payment_lines_rec.attribute_category,
1145: l_OKL_cure_payment_lines_rec.attribute1,
1146: l_OKL_cure_payment_lines_rec.attribute2,
1147: l_OKL_cure_payment_lines_rec.attribute3,
1148: l_OKL_cure_payment_lines_rec.attribute4,
1149: l_OKL_cure_payment_lines_rec.attribute5,
1150: l_OKL_cure_payment_lines_rec.attribute6,
1151: l_OKL_cure_payment_lines_rec.attribute7,
1144: l_OKL_cure_payment_lines_rec.attribute_category,
1145: l_OKL_cure_payment_lines_rec.attribute1,
1146: l_OKL_cure_payment_lines_rec.attribute2,
1147: l_OKL_cure_payment_lines_rec.attribute3,
1148: l_OKL_cure_payment_lines_rec.attribute4,
1149: l_OKL_cure_payment_lines_rec.attribute5,
1150: l_OKL_cure_payment_lines_rec.attribute6,
1151: l_OKL_cure_payment_lines_rec.attribute7,
1152: l_OKL_cure_payment_lines_rec.attribute8,
1145: l_OKL_cure_payment_lines_rec.attribute1,
1146: l_OKL_cure_payment_lines_rec.attribute2,
1147: l_OKL_cure_payment_lines_rec.attribute3,
1148: l_OKL_cure_payment_lines_rec.attribute4,
1149: l_OKL_cure_payment_lines_rec.attribute5,
1150: l_OKL_cure_payment_lines_rec.attribute6,
1151: l_OKL_cure_payment_lines_rec.attribute7,
1152: l_OKL_cure_payment_lines_rec.attribute8,
1153: l_OKL_cure_payment_lines_rec.attribute9,
1146: l_OKL_cure_payment_lines_rec.attribute2,
1147: l_OKL_cure_payment_lines_rec.attribute3,
1148: l_OKL_cure_payment_lines_rec.attribute4,
1149: l_OKL_cure_payment_lines_rec.attribute5,
1150: l_OKL_cure_payment_lines_rec.attribute6,
1151: l_OKL_cure_payment_lines_rec.attribute7,
1152: l_OKL_cure_payment_lines_rec.attribute8,
1153: l_OKL_cure_payment_lines_rec.attribute9,
1154: l_OKL_cure_payment_lines_rec.attribute10,
1147: l_OKL_cure_payment_lines_rec.attribute3,
1148: l_OKL_cure_payment_lines_rec.attribute4,
1149: l_OKL_cure_payment_lines_rec.attribute5,
1150: l_OKL_cure_payment_lines_rec.attribute6,
1151: l_OKL_cure_payment_lines_rec.attribute7,
1152: l_OKL_cure_payment_lines_rec.attribute8,
1153: l_OKL_cure_payment_lines_rec.attribute9,
1154: l_OKL_cure_payment_lines_rec.attribute10,
1155: l_OKL_cure_payment_lines_rec.attribute11,
1148: l_OKL_cure_payment_lines_rec.attribute4,
1149: l_OKL_cure_payment_lines_rec.attribute5,
1150: l_OKL_cure_payment_lines_rec.attribute6,
1151: l_OKL_cure_payment_lines_rec.attribute7,
1152: l_OKL_cure_payment_lines_rec.attribute8,
1153: l_OKL_cure_payment_lines_rec.attribute9,
1154: l_OKL_cure_payment_lines_rec.attribute10,
1155: l_OKL_cure_payment_lines_rec.attribute11,
1156: l_OKL_cure_payment_lines_rec.attribute12,
1149: l_OKL_cure_payment_lines_rec.attribute5,
1150: l_OKL_cure_payment_lines_rec.attribute6,
1151: l_OKL_cure_payment_lines_rec.attribute7,
1152: l_OKL_cure_payment_lines_rec.attribute8,
1153: l_OKL_cure_payment_lines_rec.attribute9,
1154: l_OKL_cure_payment_lines_rec.attribute10,
1155: l_OKL_cure_payment_lines_rec.attribute11,
1156: l_OKL_cure_payment_lines_rec.attribute12,
1157: l_OKL_cure_payment_lines_rec.attribute13,
1150: l_OKL_cure_payment_lines_rec.attribute6,
1151: l_OKL_cure_payment_lines_rec.attribute7,
1152: l_OKL_cure_payment_lines_rec.attribute8,
1153: l_OKL_cure_payment_lines_rec.attribute9,
1154: l_OKL_cure_payment_lines_rec.attribute10,
1155: l_OKL_cure_payment_lines_rec.attribute11,
1156: l_OKL_cure_payment_lines_rec.attribute12,
1157: l_OKL_cure_payment_lines_rec.attribute13,
1158: l_OKL_cure_payment_lines_rec.attribute14,
1151: l_OKL_cure_payment_lines_rec.attribute7,
1152: l_OKL_cure_payment_lines_rec.attribute8,
1153: l_OKL_cure_payment_lines_rec.attribute9,
1154: l_OKL_cure_payment_lines_rec.attribute10,
1155: l_OKL_cure_payment_lines_rec.attribute11,
1156: l_OKL_cure_payment_lines_rec.attribute12,
1157: l_OKL_cure_payment_lines_rec.attribute13,
1158: l_OKL_cure_payment_lines_rec.attribute14,
1159: l_OKL_cure_payment_lines_rec.attribute15,
1152: l_OKL_cure_payment_lines_rec.attribute8,
1153: l_OKL_cure_payment_lines_rec.attribute9,
1154: l_OKL_cure_payment_lines_rec.attribute10,
1155: l_OKL_cure_payment_lines_rec.attribute11,
1156: l_OKL_cure_payment_lines_rec.attribute12,
1157: l_OKL_cure_payment_lines_rec.attribute13,
1158: l_OKL_cure_payment_lines_rec.attribute14,
1159: l_OKL_cure_payment_lines_rec.attribute15,
1160: l_OKL_cure_payment_lines_rec.created_by,
1153: l_OKL_cure_payment_lines_rec.attribute9,
1154: l_OKL_cure_payment_lines_rec.attribute10,
1155: l_OKL_cure_payment_lines_rec.attribute11,
1156: l_OKL_cure_payment_lines_rec.attribute12,
1157: l_OKL_cure_payment_lines_rec.attribute13,
1158: l_OKL_cure_payment_lines_rec.attribute14,
1159: l_OKL_cure_payment_lines_rec.attribute15,
1160: l_OKL_cure_payment_lines_rec.created_by,
1161: l_OKL_cure_payment_lines_rec.creation_date,
1154: l_OKL_cure_payment_lines_rec.attribute10,
1155: l_OKL_cure_payment_lines_rec.attribute11,
1156: l_OKL_cure_payment_lines_rec.attribute12,
1157: l_OKL_cure_payment_lines_rec.attribute13,
1158: l_OKL_cure_payment_lines_rec.attribute14,
1159: l_OKL_cure_payment_lines_rec.attribute15,
1160: l_OKL_cure_payment_lines_rec.created_by,
1161: l_OKL_cure_payment_lines_rec.creation_date,
1162: l_OKL_cure_payment_lines_rec.last_updated_by,
1155: l_OKL_cure_payment_lines_rec.attribute11,
1156: l_OKL_cure_payment_lines_rec.attribute12,
1157: l_OKL_cure_payment_lines_rec.attribute13,
1158: l_OKL_cure_payment_lines_rec.attribute14,
1159: l_OKL_cure_payment_lines_rec.attribute15,
1160: l_OKL_cure_payment_lines_rec.created_by,
1161: l_OKL_cure_payment_lines_rec.creation_date,
1162: l_OKL_cure_payment_lines_rec.last_updated_by,
1163: l_OKL_cure_payment_lines_rec.last_update_date,
1156: l_OKL_cure_payment_lines_rec.attribute12,
1157: l_OKL_cure_payment_lines_rec.attribute13,
1158: l_OKL_cure_payment_lines_rec.attribute14,
1159: l_OKL_cure_payment_lines_rec.attribute15,
1160: l_OKL_cure_payment_lines_rec.created_by,
1161: l_OKL_cure_payment_lines_rec.creation_date,
1162: l_OKL_cure_payment_lines_rec.last_updated_by,
1163: l_OKL_cure_payment_lines_rec.last_update_date,
1164: l_OKL_cure_payment_lines_rec.last_update_login);
1157: l_OKL_cure_payment_lines_rec.attribute13,
1158: l_OKL_cure_payment_lines_rec.attribute14,
1159: l_OKL_cure_payment_lines_rec.attribute15,
1160: l_OKL_cure_payment_lines_rec.created_by,
1161: l_OKL_cure_payment_lines_rec.creation_date,
1162: l_OKL_cure_payment_lines_rec.last_updated_by,
1163: l_OKL_cure_payment_lines_rec.last_update_date,
1164: l_OKL_cure_payment_lines_rec.last_update_login);
1165: -- Set OUT values
1158: l_OKL_cure_payment_lines_rec.attribute14,
1159: l_OKL_cure_payment_lines_rec.attribute15,
1160: l_OKL_cure_payment_lines_rec.created_by,
1161: l_OKL_cure_payment_lines_rec.creation_date,
1162: l_OKL_cure_payment_lines_rec.last_updated_by,
1163: l_OKL_cure_payment_lines_rec.last_update_date,
1164: l_OKL_cure_payment_lines_rec.last_update_login);
1165: -- Set OUT values
1166: x_OKL_cure_payment_lines_rec := l_OKL_cure_payment_lines_rec;
1159: l_OKL_cure_payment_lines_rec.attribute15,
1160: l_OKL_cure_payment_lines_rec.created_by,
1161: l_OKL_cure_payment_lines_rec.creation_date,
1162: l_OKL_cure_payment_lines_rec.last_updated_by,
1163: l_OKL_cure_payment_lines_rec.last_update_date,
1164: l_OKL_cure_payment_lines_rec.last_update_login);
1165: -- Set OUT values
1166: x_OKL_cure_payment_lines_rec := l_OKL_cure_payment_lines_rec;
1167: x_return_status := l_return_status;
1160: l_OKL_cure_payment_lines_rec.created_by,
1161: l_OKL_cure_payment_lines_rec.creation_date,
1162: l_OKL_cure_payment_lines_rec.last_updated_by,
1163: l_OKL_cure_payment_lines_rec.last_update_date,
1164: l_OKL_cure_payment_lines_rec.last_update_login);
1165: -- Set OUT values
1166: x_OKL_cure_payment_lines_rec := l_OKL_cure_payment_lines_rec;
1167: x_return_status := l_return_status;
1168: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1162: l_OKL_cure_payment_lines_rec.last_updated_by,
1163: l_OKL_cure_payment_lines_rec.last_update_date,
1164: l_OKL_cure_payment_lines_rec.last_update_login);
1165: -- Set OUT values
1166: x_OKL_cure_payment_lines_rec := l_OKL_cure_payment_lines_rec;
1167: x_return_status := l_return_status;
1168: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1169: EXCEPTION
1170: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1198: '_PVT'
1199: );
1200: END insert_row;
1201: ----------------------------------------------
1202: -- insert_row for :OKL_CURE_PAYMENT_LINES_V --
1203: ----------------------------------------------
1204: PROCEDURE insert_row(
1205: p_api_version IN NUMBER,
1206: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1214: l_api_name CONSTANT VARCHAR2(30) := 'V_insert_row';
1215: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1216: l_CPNv_rec CPNv_rec_type := p_CPNv_rec;
1217: l_def_CPNv_rec CPNv_rec_type;
1218: l_OKL_cure_payment_lines_rec OKLCurePaymentLinesRecType;
1219: lx_OKL_cure_payment_lines_rec OKLCurePaymentLinesRecType;
1220: -------------------------------
1221: -- FUNCTION fill_who_columns --
1222: -------------------------------
1215: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1216: l_CPNv_rec CPNv_rec_type := p_CPNv_rec;
1217: l_def_CPNv_rec CPNv_rec_type;
1218: l_OKL_cure_payment_lines_rec OKLCurePaymentLinesRecType;
1219: lx_OKL_cure_payment_lines_rec OKLCurePaymentLinesRecType;
1220: -------------------------------
1221: -- FUNCTION fill_who_columns --
1222: -------------------------------
1223: FUNCTION fill_who_columns (
1232: l_CPNv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1233: RETURN(l_CPNv_rec);
1234: END fill_who_columns;
1235: -------------------------------------------------
1236: -- Set_Attributes for:OKL_CURE_PAYMENT_LINES_V --
1237: -------------------------------------------------
1238: FUNCTION Set_Attributes (
1239: p_CPNv_rec IN CPNv_rec_type,
1240: x_CPNv_rec OUT NOCOPY CPNv_rec_type
1288: END IF;
1289: -----------------------------------------
1290: -- Move VIEW record to "Child" records --
1291: -----------------------------------------
1292: migrate(l_def_CPNv_rec, l_OKL_cure_payment_lines_rec);
1293: -----------------------------------------------
1294: -- Call the INSERT_ROW for each child record --
1295: -----------------------------------------------
1296: insert_row(
1297: p_init_msg_list,
1298: l_return_status,
1299: x_msg_count,
1300: x_msg_data,
1301: l_OKL_cure_payment_lines_rec,
1302: lx_OKL_cure_payment_lines_rec
1303: );
1304: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1305: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1298: l_return_status,
1299: x_msg_count,
1300: x_msg_data,
1301: l_OKL_cure_payment_lines_rec,
1302: lx_OKL_cure_payment_lines_rec
1303: );
1304: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1305: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1306: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1305: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1306: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1307: RAISE OKC_API.G_EXCEPTION_ERROR;
1308: END IF;
1309: migrate(lx_OKL_cure_payment_lines_rec, l_def_CPNv_rec);
1310: -- Set OUT values
1311: x_CPNv_rec := l_def_CPNv_rec;
1312: x_return_status := l_return_status;
1313: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1508: ---------------------------------------------------------------------------
1509: -- PROCEDURE lock_row
1510: ---------------------------------------------------------------------------
1511: -----------------------------------------
1512: -- lock_row for:OKL_CURE_PAYMENT_LINES --
1513: -----------------------------------------
1514: PROCEDURE lock_row(
1515: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1516: x_return_status OUT NOCOPY VARCHAR2,
1515: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1516: x_return_status OUT NOCOPY VARCHAR2,
1517: x_msg_count OUT NOCOPY NUMBER,
1518: x_msg_data OUT NOCOPY VARCHAR2,
1519: p_OKL_cure_payment_lines_rec IN OKLCurePaymentLinesRecType) IS
1520:
1521: E_Resource_Busy EXCEPTION;
1522: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1523: CURSOR lock_csr (p_OKL_cure_payment_lines_rec IN OKLCurePaymentLinesRecType) IS
1519: p_OKL_cure_payment_lines_rec IN OKLCurePaymentLinesRecType) IS
1520:
1521: E_Resource_Busy EXCEPTION;
1522: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1523: CURSOR lock_csr (p_OKL_cure_payment_lines_rec IN OKLCurePaymentLinesRecType) IS
1524: SELECT OBJECT_VERSION_NUMBER
1525: FROM OKL_CURE_PAYMENT_LINES
1526: WHERE CURE_PAYMENT_LINE_ID = p_OKL_cure_payment_lines_rec.cure_payment_line_id
1527: AND OBJECT_VERSION_NUMBER = p_OKL_cure_payment_lines_rec.object_version_number
1521: E_Resource_Busy EXCEPTION;
1522: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1523: CURSOR lock_csr (p_OKL_cure_payment_lines_rec IN OKLCurePaymentLinesRecType) IS
1524: SELECT OBJECT_VERSION_NUMBER
1525: FROM OKL_CURE_PAYMENT_LINES
1526: WHERE CURE_PAYMENT_LINE_ID = p_OKL_cure_payment_lines_rec.cure_payment_line_id
1527: AND OBJECT_VERSION_NUMBER = p_OKL_cure_payment_lines_rec.object_version_number
1528: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1529:
1522: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1523: CURSOR lock_csr (p_OKL_cure_payment_lines_rec IN OKLCurePaymentLinesRecType) IS
1524: SELECT OBJECT_VERSION_NUMBER
1525: FROM OKL_CURE_PAYMENT_LINES
1526: WHERE CURE_PAYMENT_LINE_ID = p_OKL_cure_payment_lines_rec.cure_payment_line_id
1527: AND OBJECT_VERSION_NUMBER = p_OKL_cure_payment_lines_rec.object_version_number
1528: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1529:
1530: CURSOR lchk_csr (p_OKL_cure_payment_lines_rec IN OKLCurePaymentLinesRecType) IS
1523: CURSOR lock_csr (p_OKL_cure_payment_lines_rec IN OKLCurePaymentLinesRecType) IS
1524: SELECT OBJECT_VERSION_NUMBER
1525: FROM OKL_CURE_PAYMENT_LINES
1526: WHERE CURE_PAYMENT_LINE_ID = p_OKL_cure_payment_lines_rec.cure_payment_line_id
1527: AND OBJECT_VERSION_NUMBER = p_OKL_cure_payment_lines_rec.object_version_number
1528: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1529:
1530: CURSOR lchk_csr (p_OKL_cure_payment_lines_rec IN OKLCurePaymentLinesRecType) IS
1531: SELECT OBJECT_VERSION_NUMBER
1526: WHERE CURE_PAYMENT_LINE_ID = p_OKL_cure_payment_lines_rec.cure_payment_line_id
1527: AND OBJECT_VERSION_NUMBER = p_OKL_cure_payment_lines_rec.object_version_number
1528: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1529:
1530: CURSOR lchk_csr (p_OKL_cure_payment_lines_rec IN OKLCurePaymentLinesRecType) IS
1531: SELECT OBJECT_VERSION_NUMBER
1532: FROM OKL_CURE_PAYMENT_LINES
1533: WHERE CURE_PAYMENT_LINE_ID = p_OKL_cure_payment_lines_rec.cure_payment_line_id;
1534: l_api_version CONSTANT NUMBER := 1;
1528: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1529:
1530: CURSOR lchk_csr (p_OKL_cure_payment_lines_rec IN OKLCurePaymentLinesRecType) IS
1531: SELECT OBJECT_VERSION_NUMBER
1532: FROM OKL_CURE_PAYMENT_LINES
1533: WHERE CURE_PAYMENT_LINE_ID = p_OKL_cure_payment_lines_rec.cure_payment_line_id;
1534: l_api_version CONSTANT NUMBER := 1;
1535: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1536: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1529:
1530: CURSOR lchk_csr (p_OKL_cure_payment_lines_rec IN OKLCurePaymentLinesRecType) IS
1531: SELECT OBJECT_VERSION_NUMBER
1532: FROM OKL_CURE_PAYMENT_LINES
1533: WHERE CURE_PAYMENT_LINE_ID = p_OKL_cure_payment_lines_rec.cure_payment_line_id;
1534: l_api_version CONSTANT NUMBER := 1;
1535: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1536: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1537: l_object_version_number OKL_CURE_PAYMENT_LINES.OBJECT_VERSION_NUMBER%TYPE;
1533: WHERE CURE_PAYMENT_LINE_ID = p_OKL_cure_payment_lines_rec.cure_payment_line_id;
1534: l_api_version CONSTANT NUMBER := 1;
1535: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1536: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1537: l_object_version_number OKL_CURE_PAYMENT_LINES.OBJECT_VERSION_NUMBER%TYPE;
1538: lc_object_version_number OKL_CURE_PAYMENT_LINES.OBJECT_VERSION_NUMBER%TYPE;
1539: l_row_notfound BOOLEAN := FALSE;
1540: lc_row_notfound BOOLEAN := FALSE;
1541: BEGIN
1534: l_api_version CONSTANT NUMBER := 1;
1535: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1536: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1537: l_object_version_number OKL_CURE_PAYMENT_LINES.OBJECT_VERSION_NUMBER%TYPE;
1538: lc_object_version_number OKL_CURE_PAYMENT_LINES.OBJECT_VERSION_NUMBER%TYPE;
1539: l_row_notfound BOOLEAN := FALSE;
1540: lc_row_notfound BOOLEAN := FALSE;
1541: BEGIN
1542: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1548: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1549: RAISE OKC_API.G_EXCEPTION_ERROR;
1550: END IF;
1551: BEGIN
1552: OPEN lock_csr(p_OKL_cure_payment_lines_rec);
1553: FETCH lock_csr INTO l_object_version_number;
1554: l_row_notfound := lock_csr%NOTFOUND;
1555: CLOSE lock_csr;
1556: EXCEPTION
1562: RAISE APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION;
1563: END;
1564:
1565: IF ( l_row_notfound ) THEN
1566: OPEN lchk_csr(p_OKL_cure_payment_lines_rec);
1567: FETCH lchk_csr INTO lc_object_version_number;
1568: lc_row_notfound := lchk_csr%NOTFOUND;
1569: CLOSE lchk_csr;
1570: END IF;
1570: END IF;
1571: IF (lc_row_notfound) THEN
1572: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1573: RAISE OKC_API.G_EXCEPTION_ERROR;
1574: ELSIF lc_object_version_number > p_OKL_cure_payment_lines_rec.object_version_number THEN
1575: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1576: RAISE OKC_API.G_EXCEPTION_ERROR;
1577: ELSIF lc_object_version_number <> p_OKL_cure_payment_lines_rec.object_version_number THEN
1578: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1573: RAISE OKC_API.G_EXCEPTION_ERROR;
1574: ELSIF lc_object_version_number > p_OKL_cure_payment_lines_rec.object_version_number THEN
1575: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1576: RAISE OKC_API.G_EXCEPTION_ERROR;
1577: ELSIF lc_object_version_number <> p_OKL_cure_payment_lines_rec.object_version_number THEN
1578: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1579: RAISE OKC_API.G_EXCEPTION_ERROR;
1580: ELSIF lc_object_version_number = -1 THEN
1581: OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1615: '_PVT'
1616: );
1617: END lock_row;
1618: --------------------------------------------
1619: -- lock_row for: OKL_CURE_PAYMENT_LINES_V --
1620: --------------------------------------------
1621: PROCEDURE lock_row(
1622: p_api_version IN NUMBER,
1623: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1628:
1629: l_api_version CONSTANT NUMBER := 1;
1630: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
1631: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1632: l_OKL_cure_payment_lines_rec OKLCurePaymentLinesRecType;
1633: BEGIN
1634: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1635: G_PKG_NAME,
1636: p_init_msg_list,
1645: END IF;
1646: -----------------------------------------
1647: -- Move VIEW record to "Child" records --
1648: -----------------------------------------
1649: migrate(p_CPNv_rec, l_OKL_cure_payment_lines_rec);
1650: ---------------------------------------------
1651: -- Call the LOCK_ROW for each child record --
1652: ---------------------------------------------
1653: lock_row(
1654: p_init_msg_list,
1655: l_return_status,
1656: x_msg_count,
1657: x_msg_data,
1658: l_OKL_cure_payment_lines_rec
1659: );
1660: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1661: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1662: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1855: ---------------------------------------------------------------------------
1856: -- PROCEDURE update_row
1857: ---------------------------------------------------------------------------
1858: -------------------------------------------
1859: -- update_row for:OKL_CURE_PAYMENT_LINES --
1860: -------------------------------------------
1861: PROCEDURE update_row(
1862: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1863: x_return_status OUT NOCOPY VARCHAR2,
1862: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1863: x_return_status OUT NOCOPY VARCHAR2,
1864: x_msg_count OUT NOCOPY NUMBER,
1865: x_msg_data OUT NOCOPY VARCHAR2,
1866: p_OKL_cure_payment_lines_rec IN OKLCurePaymentLinesRecType,
1867: x_OKL_cure_payment_lines_rec OUT NOCOPY OKLCurePaymentLinesRecType) IS
1868:
1869: l_api_version CONSTANT NUMBER := 1;
1870: l_api_name CONSTANT VARCHAR2(30) := 'B_update_row';
1863: x_return_status OUT NOCOPY VARCHAR2,
1864: x_msg_count OUT NOCOPY NUMBER,
1865: x_msg_data OUT NOCOPY VARCHAR2,
1866: p_OKL_cure_payment_lines_rec IN OKLCurePaymentLinesRecType,
1867: x_OKL_cure_payment_lines_rec OUT NOCOPY OKLCurePaymentLinesRecType) IS
1868:
1869: l_api_version CONSTANT NUMBER := 1;
1870: l_api_name CONSTANT VARCHAR2(30) := 'B_update_row';
1871: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1868:
1869: l_api_version CONSTANT NUMBER := 1;
1870: l_api_name CONSTANT VARCHAR2(30) := 'B_update_row';
1871: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1872: l_OKL_cure_payment_lines_rec OKLCurePaymentLinesRecType := p_OKL_cure_payment_lines_rec;
1873: LDefOKLCurePaymentLinesRec OKLCurePaymentLinesRecType;
1874: l_row_notfound BOOLEAN := TRUE;
1875: ----------------------------------
1876: -- FUNCTION populate_new_record --
1875: ----------------------------------
1876: -- FUNCTION populate_new_record --
1877: ----------------------------------
1878: FUNCTION populate_new_record (
1879: p_OKL_cure_payment_lines_rec IN OKLCurePaymentLinesRecType,
1880: x_OKL_cure_payment_lines_rec OUT NOCOPY OKLCurePaymentLinesRecType
1881: ) RETURN VARCHAR2 IS
1882: l_OKL_cure_payment_lines_rec OKLCurePaymentLinesRecType;
1883: l_row_notfound BOOLEAN := TRUE;
1876: -- FUNCTION populate_new_record --
1877: ----------------------------------
1878: FUNCTION populate_new_record (
1879: p_OKL_cure_payment_lines_rec IN OKLCurePaymentLinesRecType,
1880: x_OKL_cure_payment_lines_rec OUT NOCOPY OKLCurePaymentLinesRecType
1881: ) RETURN VARCHAR2 IS
1882: l_OKL_cure_payment_lines_rec OKLCurePaymentLinesRecType;
1883: l_row_notfound BOOLEAN := TRUE;
1884: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1878: FUNCTION populate_new_record (
1879: p_OKL_cure_payment_lines_rec IN OKLCurePaymentLinesRecType,
1880: x_OKL_cure_payment_lines_rec OUT NOCOPY OKLCurePaymentLinesRecType
1881: ) RETURN VARCHAR2 IS
1882: l_OKL_cure_payment_lines_rec OKLCurePaymentLinesRecType;
1883: l_row_notfound BOOLEAN := TRUE;
1884: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1885: BEGIN
1886: x_OKL_cure_payment_lines_rec := p_OKL_cure_payment_lines_rec;
1882: l_OKL_cure_payment_lines_rec OKLCurePaymentLinesRecType;
1883: l_row_notfound BOOLEAN := TRUE;
1884: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1885: BEGIN
1886: x_OKL_cure_payment_lines_rec := p_OKL_cure_payment_lines_rec;
1887: -- Get current database values
1888: l_OKL_cure_payment_lines_rec := get_rec(p_OKL_cure_payment_lines_rec, l_return_status);
1889: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
1890: IF (x_OKL_cure_payment_lines_rec.cure_payment_line_id = OKC_API.G_MISS_NUM)
1884: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1885: BEGIN
1886: x_OKL_cure_payment_lines_rec := p_OKL_cure_payment_lines_rec;
1887: -- Get current database values
1888: l_OKL_cure_payment_lines_rec := get_rec(p_OKL_cure_payment_lines_rec, l_return_status);
1889: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
1890: IF (x_OKL_cure_payment_lines_rec.cure_payment_line_id = OKC_API.G_MISS_NUM)
1891: THEN
1892: x_OKL_cure_payment_lines_rec.cure_payment_line_id := l_OKL_cure_payment_lines_rec.cure_payment_line_id;
1886: x_OKL_cure_payment_lines_rec := p_OKL_cure_payment_lines_rec;
1887: -- Get current database values
1888: l_OKL_cure_payment_lines_rec := get_rec(p_OKL_cure_payment_lines_rec, l_return_status);
1889: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
1890: IF (x_OKL_cure_payment_lines_rec.cure_payment_line_id = OKC_API.G_MISS_NUM)
1891: THEN
1892: x_OKL_cure_payment_lines_rec.cure_payment_line_id := l_OKL_cure_payment_lines_rec.cure_payment_line_id;
1893: END IF;
1894: IF (x_OKL_cure_payment_lines_rec.cure_payment_id = OKC_API.G_MISS_NUM)
1888: l_OKL_cure_payment_lines_rec := get_rec(p_OKL_cure_payment_lines_rec, l_return_status);
1889: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
1890: IF (x_OKL_cure_payment_lines_rec.cure_payment_line_id = OKC_API.G_MISS_NUM)
1891: THEN
1892: x_OKL_cure_payment_lines_rec.cure_payment_line_id := l_OKL_cure_payment_lines_rec.cure_payment_line_id;
1893: END IF;
1894: IF (x_OKL_cure_payment_lines_rec.cure_payment_id = OKC_API.G_MISS_NUM)
1895: THEN
1896: x_OKL_cure_payment_lines_rec.cure_payment_id := l_OKL_cure_payment_lines_rec.cure_payment_id;
1890: IF (x_OKL_cure_payment_lines_rec.cure_payment_line_id = OKC_API.G_MISS_NUM)
1891: THEN
1892: x_OKL_cure_payment_lines_rec.cure_payment_line_id := l_OKL_cure_payment_lines_rec.cure_payment_line_id;
1893: END IF;
1894: IF (x_OKL_cure_payment_lines_rec.cure_payment_id = OKC_API.G_MISS_NUM)
1895: THEN
1896: x_OKL_cure_payment_lines_rec.cure_payment_id := l_OKL_cure_payment_lines_rec.cure_payment_id;
1897: END IF;
1898: IF (x_OKL_cure_payment_lines_rec.chr_id = OKC_API.G_MISS_NUM)
1892: x_OKL_cure_payment_lines_rec.cure_payment_line_id := l_OKL_cure_payment_lines_rec.cure_payment_line_id;
1893: END IF;
1894: IF (x_OKL_cure_payment_lines_rec.cure_payment_id = OKC_API.G_MISS_NUM)
1895: THEN
1896: x_OKL_cure_payment_lines_rec.cure_payment_id := l_OKL_cure_payment_lines_rec.cure_payment_id;
1897: END IF;
1898: IF (x_OKL_cure_payment_lines_rec.chr_id = OKC_API.G_MISS_NUM)
1899: THEN
1900: x_OKL_cure_payment_lines_rec.chr_id := l_OKL_cure_payment_lines_rec.chr_id;
1894: IF (x_OKL_cure_payment_lines_rec.cure_payment_id = OKC_API.G_MISS_NUM)
1895: THEN
1896: x_OKL_cure_payment_lines_rec.cure_payment_id := l_OKL_cure_payment_lines_rec.cure_payment_id;
1897: END IF;
1898: IF (x_OKL_cure_payment_lines_rec.chr_id = OKC_API.G_MISS_NUM)
1899: THEN
1900: x_OKL_cure_payment_lines_rec.chr_id := l_OKL_cure_payment_lines_rec.chr_id;
1901: END IF;
1902: IF (x_OKL_cure_payment_lines_rec.amount = OKC_API.G_MISS_NUM)
1896: x_OKL_cure_payment_lines_rec.cure_payment_id := l_OKL_cure_payment_lines_rec.cure_payment_id;
1897: END IF;
1898: IF (x_OKL_cure_payment_lines_rec.chr_id = OKC_API.G_MISS_NUM)
1899: THEN
1900: x_OKL_cure_payment_lines_rec.chr_id := l_OKL_cure_payment_lines_rec.chr_id;
1901: END IF;
1902: IF (x_OKL_cure_payment_lines_rec.amount = OKC_API.G_MISS_NUM)
1903: THEN
1904: x_OKL_cure_payment_lines_rec.amount := l_OKL_cure_payment_lines_rec.amount;
1898: IF (x_OKL_cure_payment_lines_rec.chr_id = OKC_API.G_MISS_NUM)
1899: THEN
1900: x_OKL_cure_payment_lines_rec.chr_id := l_OKL_cure_payment_lines_rec.chr_id;
1901: END IF;
1902: IF (x_OKL_cure_payment_lines_rec.amount = OKC_API.G_MISS_NUM)
1903: THEN
1904: x_OKL_cure_payment_lines_rec.amount := l_OKL_cure_payment_lines_rec.amount;
1905: END IF;
1906: IF (x_OKL_cure_payment_lines_rec.cured_flag = OKC_API.G_MISS_CHAR)
1900: x_OKL_cure_payment_lines_rec.chr_id := l_OKL_cure_payment_lines_rec.chr_id;
1901: END IF;
1902: IF (x_OKL_cure_payment_lines_rec.amount = OKC_API.G_MISS_NUM)
1903: THEN
1904: x_OKL_cure_payment_lines_rec.amount := l_OKL_cure_payment_lines_rec.amount;
1905: END IF;
1906: IF (x_OKL_cure_payment_lines_rec.cured_flag = OKC_API.G_MISS_CHAR)
1907: THEN
1908: x_OKL_cure_payment_lines_rec.cured_flag := l_OKL_cure_payment_lines_rec.cured_flag;
1902: IF (x_OKL_cure_payment_lines_rec.amount = OKC_API.G_MISS_NUM)
1903: THEN
1904: x_OKL_cure_payment_lines_rec.amount := l_OKL_cure_payment_lines_rec.amount;
1905: END IF;
1906: IF (x_OKL_cure_payment_lines_rec.cured_flag = OKC_API.G_MISS_CHAR)
1907: THEN
1908: x_OKL_cure_payment_lines_rec.cured_flag := l_OKL_cure_payment_lines_rec.cured_flag;
1909: END IF;
1910: IF (x_OKL_cure_payment_lines_rec.status = OKC_API.G_MISS_CHAR)
1904: x_OKL_cure_payment_lines_rec.amount := l_OKL_cure_payment_lines_rec.amount;
1905: END IF;
1906: IF (x_OKL_cure_payment_lines_rec.cured_flag = OKC_API.G_MISS_CHAR)
1907: THEN
1908: x_OKL_cure_payment_lines_rec.cured_flag := l_OKL_cure_payment_lines_rec.cured_flag;
1909: END IF;
1910: IF (x_OKL_cure_payment_lines_rec.status = OKC_API.G_MISS_CHAR)
1911: THEN
1912: x_OKL_cure_payment_lines_rec.status := l_OKL_cure_payment_lines_rec.status;
1906: IF (x_OKL_cure_payment_lines_rec.cured_flag = OKC_API.G_MISS_CHAR)
1907: THEN
1908: x_OKL_cure_payment_lines_rec.cured_flag := l_OKL_cure_payment_lines_rec.cured_flag;
1909: END IF;
1910: IF (x_OKL_cure_payment_lines_rec.status = OKC_API.G_MISS_CHAR)
1911: THEN
1912: x_OKL_cure_payment_lines_rec.status := l_OKL_cure_payment_lines_rec.status;
1913: END IF;
1914: IF (x_OKL_cure_payment_lines_rec.cure_refund_id = OKC_API.G_MISS_NUM)
1908: x_OKL_cure_payment_lines_rec.cured_flag := l_OKL_cure_payment_lines_rec.cured_flag;
1909: END IF;
1910: IF (x_OKL_cure_payment_lines_rec.status = OKC_API.G_MISS_CHAR)
1911: THEN
1912: x_OKL_cure_payment_lines_rec.status := l_OKL_cure_payment_lines_rec.status;
1913: END IF;
1914: IF (x_OKL_cure_payment_lines_rec.cure_refund_id = OKC_API.G_MISS_NUM)
1915: THEN
1916: x_OKL_cure_payment_lines_rec.cure_refund_id := l_OKL_cure_payment_lines_rec.cure_refund_id;
1910: IF (x_OKL_cure_payment_lines_rec.status = OKC_API.G_MISS_CHAR)
1911: THEN
1912: x_OKL_cure_payment_lines_rec.status := l_OKL_cure_payment_lines_rec.status;
1913: END IF;
1914: IF (x_OKL_cure_payment_lines_rec.cure_refund_id = OKC_API.G_MISS_NUM)
1915: THEN
1916: x_OKL_cure_payment_lines_rec.cure_refund_id := l_OKL_cure_payment_lines_rec.cure_refund_id;
1917: END IF;
1918: IF (x_OKL_cure_payment_lines_rec.approval_status = OKC_API.G_MISS_CHAR)
1912: x_OKL_cure_payment_lines_rec.status := l_OKL_cure_payment_lines_rec.status;
1913: END IF;
1914: IF (x_OKL_cure_payment_lines_rec.cure_refund_id = OKC_API.G_MISS_NUM)
1915: THEN
1916: x_OKL_cure_payment_lines_rec.cure_refund_id := l_OKL_cure_payment_lines_rec.cure_refund_id;
1917: END IF;
1918: IF (x_OKL_cure_payment_lines_rec.approval_status = OKC_API.G_MISS_CHAR)
1919: THEN
1920: x_OKL_cure_payment_lines_rec.approval_status := l_OKL_cure_payment_lines_rec.approval_status;
1914: IF (x_OKL_cure_payment_lines_rec.cure_refund_id = OKC_API.G_MISS_NUM)
1915: THEN
1916: x_OKL_cure_payment_lines_rec.cure_refund_id := l_OKL_cure_payment_lines_rec.cure_refund_id;
1917: END IF;
1918: IF (x_OKL_cure_payment_lines_rec.approval_status = OKC_API.G_MISS_CHAR)
1919: THEN
1920: x_OKL_cure_payment_lines_rec.approval_status := l_OKL_cure_payment_lines_rec.approval_status;
1921: END IF;
1922: IF (x_OKL_cure_payment_lines_rec.approval_reason = OKC_API.G_MISS_CHAR)
1916: x_OKL_cure_payment_lines_rec.cure_refund_id := l_OKL_cure_payment_lines_rec.cure_refund_id;
1917: END IF;
1918: IF (x_OKL_cure_payment_lines_rec.approval_status = OKC_API.G_MISS_CHAR)
1919: THEN
1920: x_OKL_cure_payment_lines_rec.approval_status := l_OKL_cure_payment_lines_rec.approval_status;
1921: END IF;
1922: IF (x_OKL_cure_payment_lines_rec.approval_reason = OKC_API.G_MISS_CHAR)
1923: THEN
1924: x_OKL_cure_payment_lines_rec.approval_reason := l_OKL_cure_payment_lines_rec.approval_reason;
1918: IF (x_OKL_cure_payment_lines_rec.approval_status = OKC_API.G_MISS_CHAR)
1919: THEN
1920: x_OKL_cure_payment_lines_rec.approval_status := l_OKL_cure_payment_lines_rec.approval_status;
1921: END IF;
1922: IF (x_OKL_cure_payment_lines_rec.approval_reason = OKC_API.G_MISS_CHAR)
1923: THEN
1924: x_OKL_cure_payment_lines_rec.approval_reason := l_OKL_cure_payment_lines_rec.approval_reason;
1925: END IF;
1926: IF (x_OKL_cure_payment_lines_rec.transaction_id = OKC_API.G_MISS_NUM)
1920: x_OKL_cure_payment_lines_rec.approval_status := l_OKL_cure_payment_lines_rec.approval_status;
1921: END IF;
1922: IF (x_OKL_cure_payment_lines_rec.approval_reason = OKC_API.G_MISS_CHAR)
1923: THEN
1924: x_OKL_cure_payment_lines_rec.approval_reason := l_OKL_cure_payment_lines_rec.approval_reason;
1925: END IF;
1926: IF (x_OKL_cure_payment_lines_rec.transaction_id = OKC_API.G_MISS_NUM)
1927: THEN
1928: x_OKL_cure_payment_lines_rec.transaction_id := l_OKL_cure_payment_lines_rec.transaction_id;
1922: IF (x_OKL_cure_payment_lines_rec.approval_reason = OKC_API.G_MISS_CHAR)
1923: THEN
1924: x_OKL_cure_payment_lines_rec.approval_reason := l_OKL_cure_payment_lines_rec.approval_reason;
1925: END IF;
1926: IF (x_OKL_cure_payment_lines_rec.transaction_id = OKC_API.G_MISS_NUM)
1927: THEN
1928: x_OKL_cure_payment_lines_rec.transaction_id := l_OKL_cure_payment_lines_rec.transaction_id;
1929: END IF;
1930: IF (x_OKL_cure_payment_lines_rec.tai_id = OKC_API.G_MISS_NUM)
1924: x_OKL_cure_payment_lines_rec.approval_reason := l_OKL_cure_payment_lines_rec.approval_reason;
1925: END IF;
1926: IF (x_OKL_cure_payment_lines_rec.transaction_id = OKC_API.G_MISS_NUM)
1927: THEN
1928: x_OKL_cure_payment_lines_rec.transaction_id := l_OKL_cure_payment_lines_rec.transaction_id;
1929: END IF;
1930: IF (x_OKL_cure_payment_lines_rec.tai_id = OKC_API.G_MISS_NUM)
1931: THEN
1932: x_OKL_cure_payment_lines_rec.tai_id := l_OKL_cure_payment_lines_rec.tai_id;
1926: IF (x_OKL_cure_payment_lines_rec.transaction_id = OKC_API.G_MISS_NUM)
1927: THEN
1928: x_OKL_cure_payment_lines_rec.transaction_id := l_OKL_cure_payment_lines_rec.transaction_id;
1929: END IF;
1930: IF (x_OKL_cure_payment_lines_rec.tai_id = OKC_API.G_MISS_NUM)
1931: THEN
1932: x_OKL_cure_payment_lines_rec.tai_id := l_OKL_cure_payment_lines_rec.tai_id;
1933: END IF;
1934: IF (x_OKL_cure_payment_lines_rec.process_status = OKC_API.G_MISS_CHAR)
1928: x_OKL_cure_payment_lines_rec.transaction_id := l_OKL_cure_payment_lines_rec.transaction_id;
1929: END IF;
1930: IF (x_OKL_cure_payment_lines_rec.tai_id = OKC_API.G_MISS_NUM)
1931: THEN
1932: x_OKL_cure_payment_lines_rec.tai_id := l_OKL_cure_payment_lines_rec.tai_id;
1933: END IF;
1934: IF (x_OKL_cure_payment_lines_rec.process_status = OKC_API.G_MISS_CHAR)
1935: THEN
1936: x_OKL_cure_payment_lines_rec.process_status := l_OKL_cure_payment_lines_rec.process_status;
1930: IF (x_OKL_cure_payment_lines_rec.tai_id = OKC_API.G_MISS_NUM)
1931: THEN
1932: x_OKL_cure_payment_lines_rec.tai_id := l_OKL_cure_payment_lines_rec.tai_id;
1933: END IF;
1934: IF (x_OKL_cure_payment_lines_rec.process_status = OKC_API.G_MISS_CHAR)
1935: THEN
1936: x_OKL_cure_payment_lines_rec.process_status := l_OKL_cure_payment_lines_rec.process_status;
1937: END IF;
1938: IF (x_OKL_cure_payment_lines_rec.rct_id = OKC_API.G_MISS_NUM)
1932: x_OKL_cure_payment_lines_rec.tai_id := l_OKL_cure_payment_lines_rec.tai_id;
1933: END IF;
1934: IF (x_OKL_cure_payment_lines_rec.process_status = OKC_API.G_MISS_CHAR)
1935: THEN
1936: x_OKL_cure_payment_lines_rec.process_status := l_OKL_cure_payment_lines_rec.process_status;
1937: END IF;
1938: IF (x_OKL_cure_payment_lines_rec.rct_id = OKC_API.G_MISS_NUM)
1939: THEN
1940: x_OKL_cure_payment_lines_rec.rct_id := l_OKL_cure_payment_lines_rec.rct_id;
1934: IF (x_OKL_cure_payment_lines_rec.process_status = OKC_API.G_MISS_CHAR)
1935: THEN
1936: x_OKL_cure_payment_lines_rec.process_status := l_OKL_cure_payment_lines_rec.process_status;
1937: END IF;
1938: IF (x_OKL_cure_payment_lines_rec.rct_id = OKC_API.G_MISS_NUM)
1939: THEN
1940: x_OKL_cure_payment_lines_rec.rct_id := l_OKL_cure_payment_lines_rec.rct_id;
1941: END IF;
1942: IF (x_OKL_cure_payment_lines_rec.object_version_number = OKC_API.G_MISS_NUM)
1936: x_OKL_cure_payment_lines_rec.process_status := l_OKL_cure_payment_lines_rec.process_status;
1937: END IF;
1938: IF (x_OKL_cure_payment_lines_rec.rct_id = OKC_API.G_MISS_NUM)
1939: THEN
1940: x_OKL_cure_payment_lines_rec.rct_id := l_OKL_cure_payment_lines_rec.rct_id;
1941: END IF;
1942: IF (x_OKL_cure_payment_lines_rec.object_version_number = OKC_API.G_MISS_NUM)
1943: THEN
1944: x_OKL_cure_payment_lines_rec.object_version_number := l_OKL_cure_payment_lines_rec.object_version_number;
1938: IF (x_OKL_cure_payment_lines_rec.rct_id = OKC_API.G_MISS_NUM)
1939: THEN
1940: x_OKL_cure_payment_lines_rec.rct_id := l_OKL_cure_payment_lines_rec.rct_id;
1941: END IF;
1942: IF (x_OKL_cure_payment_lines_rec.object_version_number = OKC_API.G_MISS_NUM)
1943: THEN
1944: x_OKL_cure_payment_lines_rec.object_version_number := l_OKL_cure_payment_lines_rec.object_version_number;
1945: END IF;
1946: IF (x_OKL_cure_payment_lines_rec.org_id = OKC_API.G_MISS_NUM)
1940: x_OKL_cure_payment_lines_rec.rct_id := l_OKL_cure_payment_lines_rec.rct_id;
1941: END IF;
1942: IF (x_OKL_cure_payment_lines_rec.object_version_number = OKC_API.G_MISS_NUM)
1943: THEN
1944: x_OKL_cure_payment_lines_rec.object_version_number := l_OKL_cure_payment_lines_rec.object_version_number;
1945: END IF;
1946: IF (x_OKL_cure_payment_lines_rec.org_id = OKC_API.G_MISS_NUM)
1947: THEN
1948: x_OKL_cure_payment_lines_rec.org_id := l_OKL_cure_payment_lines_rec.org_id;
1942: IF (x_OKL_cure_payment_lines_rec.object_version_number = OKC_API.G_MISS_NUM)
1943: THEN
1944: x_OKL_cure_payment_lines_rec.object_version_number := l_OKL_cure_payment_lines_rec.object_version_number;
1945: END IF;
1946: IF (x_OKL_cure_payment_lines_rec.org_id = OKC_API.G_MISS_NUM)
1947: THEN
1948: x_OKL_cure_payment_lines_rec.org_id := l_OKL_cure_payment_lines_rec.org_id;
1949: END IF;
1950: IF (x_OKL_cure_payment_lines_rec.request_id = OKC_API.G_MISS_NUM)
1944: x_OKL_cure_payment_lines_rec.object_version_number := l_OKL_cure_payment_lines_rec.object_version_number;
1945: END IF;
1946: IF (x_OKL_cure_payment_lines_rec.org_id = OKC_API.G_MISS_NUM)
1947: THEN
1948: x_OKL_cure_payment_lines_rec.org_id := l_OKL_cure_payment_lines_rec.org_id;
1949: END IF;
1950: IF (x_OKL_cure_payment_lines_rec.request_id = OKC_API.G_MISS_NUM)
1951: THEN
1952: x_OKL_cure_payment_lines_rec.request_id := l_OKL_cure_payment_lines_rec.request_id;
1946: IF (x_OKL_cure_payment_lines_rec.org_id = OKC_API.G_MISS_NUM)
1947: THEN
1948: x_OKL_cure_payment_lines_rec.org_id := l_OKL_cure_payment_lines_rec.org_id;
1949: END IF;
1950: IF (x_OKL_cure_payment_lines_rec.request_id = OKC_API.G_MISS_NUM)
1951: THEN
1952: x_OKL_cure_payment_lines_rec.request_id := l_OKL_cure_payment_lines_rec.request_id;
1953: END IF;
1954: IF (x_OKL_cure_payment_lines_rec.program_application_id = OKC_API.G_MISS_NUM)
1948: x_OKL_cure_payment_lines_rec.org_id := l_OKL_cure_payment_lines_rec.org_id;
1949: END IF;
1950: IF (x_OKL_cure_payment_lines_rec.request_id = OKC_API.G_MISS_NUM)
1951: THEN
1952: x_OKL_cure_payment_lines_rec.request_id := l_OKL_cure_payment_lines_rec.request_id;
1953: END IF;
1954: IF (x_OKL_cure_payment_lines_rec.program_application_id = OKC_API.G_MISS_NUM)
1955: THEN
1956: x_OKL_cure_payment_lines_rec.program_application_id := l_OKL_cure_payment_lines_rec.program_application_id;
1950: IF (x_OKL_cure_payment_lines_rec.request_id = OKC_API.G_MISS_NUM)
1951: THEN
1952: x_OKL_cure_payment_lines_rec.request_id := l_OKL_cure_payment_lines_rec.request_id;
1953: END IF;
1954: IF (x_OKL_cure_payment_lines_rec.program_application_id = OKC_API.G_MISS_NUM)
1955: THEN
1956: x_OKL_cure_payment_lines_rec.program_application_id := l_OKL_cure_payment_lines_rec.program_application_id;
1957: END IF;
1958: IF (x_OKL_cure_payment_lines_rec.program_id = OKC_API.G_MISS_NUM)
1952: x_OKL_cure_payment_lines_rec.request_id := l_OKL_cure_payment_lines_rec.request_id;
1953: END IF;
1954: IF (x_OKL_cure_payment_lines_rec.program_application_id = OKC_API.G_MISS_NUM)
1955: THEN
1956: x_OKL_cure_payment_lines_rec.program_application_id := l_OKL_cure_payment_lines_rec.program_application_id;
1957: END IF;
1958: IF (x_OKL_cure_payment_lines_rec.program_id = OKC_API.G_MISS_NUM)
1959: THEN
1960: x_OKL_cure_payment_lines_rec.program_id := l_OKL_cure_payment_lines_rec.program_id;
1954: IF (x_OKL_cure_payment_lines_rec.program_application_id = OKC_API.G_MISS_NUM)
1955: THEN
1956: x_OKL_cure_payment_lines_rec.program_application_id := l_OKL_cure_payment_lines_rec.program_application_id;
1957: END IF;
1958: IF (x_OKL_cure_payment_lines_rec.program_id = OKC_API.G_MISS_NUM)
1959: THEN
1960: x_OKL_cure_payment_lines_rec.program_id := l_OKL_cure_payment_lines_rec.program_id;
1961: END IF;
1962: IF (x_OKL_cure_payment_lines_rec.program_update_date = OKC_API.G_MISS_DATE)
1956: x_OKL_cure_payment_lines_rec.program_application_id := l_OKL_cure_payment_lines_rec.program_application_id;
1957: END IF;
1958: IF (x_OKL_cure_payment_lines_rec.program_id = OKC_API.G_MISS_NUM)
1959: THEN
1960: x_OKL_cure_payment_lines_rec.program_id := l_OKL_cure_payment_lines_rec.program_id;
1961: END IF;
1962: IF (x_OKL_cure_payment_lines_rec.program_update_date = OKC_API.G_MISS_DATE)
1963: THEN
1964: x_OKL_cure_payment_lines_rec.program_update_date := l_OKL_cure_payment_lines_rec.program_update_date;
1958: IF (x_OKL_cure_payment_lines_rec.program_id = OKC_API.G_MISS_NUM)
1959: THEN
1960: x_OKL_cure_payment_lines_rec.program_id := l_OKL_cure_payment_lines_rec.program_id;
1961: END IF;
1962: IF (x_OKL_cure_payment_lines_rec.program_update_date = OKC_API.G_MISS_DATE)
1963: THEN
1964: x_OKL_cure_payment_lines_rec.program_update_date := l_OKL_cure_payment_lines_rec.program_update_date;
1965: END IF;
1966: IF (x_OKL_cure_payment_lines_rec.attribute_category = OKC_API.G_MISS_CHAR)
1960: x_OKL_cure_payment_lines_rec.program_id := l_OKL_cure_payment_lines_rec.program_id;
1961: END IF;
1962: IF (x_OKL_cure_payment_lines_rec.program_update_date = OKC_API.G_MISS_DATE)
1963: THEN
1964: x_OKL_cure_payment_lines_rec.program_update_date := l_OKL_cure_payment_lines_rec.program_update_date;
1965: END IF;
1966: IF (x_OKL_cure_payment_lines_rec.attribute_category = OKC_API.G_MISS_CHAR)
1967: THEN
1968: x_OKL_cure_payment_lines_rec.attribute_category := l_OKL_cure_payment_lines_rec.attribute_category;
1962: IF (x_OKL_cure_payment_lines_rec.program_update_date = OKC_API.G_MISS_DATE)
1963: THEN
1964: x_OKL_cure_payment_lines_rec.program_update_date := l_OKL_cure_payment_lines_rec.program_update_date;
1965: END IF;
1966: IF (x_OKL_cure_payment_lines_rec.attribute_category = OKC_API.G_MISS_CHAR)
1967: THEN
1968: x_OKL_cure_payment_lines_rec.attribute_category := l_OKL_cure_payment_lines_rec.attribute_category;
1969: END IF;
1970: IF (x_OKL_cure_payment_lines_rec.attribute1 = OKC_API.G_MISS_CHAR)
1964: x_OKL_cure_payment_lines_rec.program_update_date := l_OKL_cure_payment_lines_rec.program_update_date;
1965: END IF;
1966: IF (x_OKL_cure_payment_lines_rec.attribute_category = OKC_API.G_MISS_CHAR)
1967: THEN
1968: x_OKL_cure_payment_lines_rec.attribute_category := l_OKL_cure_payment_lines_rec.attribute_category;
1969: END IF;
1970: IF (x_OKL_cure_payment_lines_rec.attribute1 = OKC_API.G_MISS_CHAR)
1971: THEN
1972: x_OKL_cure_payment_lines_rec.attribute1 := l_OKL_cure_payment_lines_rec.attribute1;
1966: IF (x_OKL_cure_payment_lines_rec.attribute_category = OKC_API.G_MISS_CHAR)
1967: THEN
1968: x_OKL_cure_payment_lines_rec.attribute_category := l_OKL_cure_payment_lines_rec.attribute_category;
1969: END IF;
1970: IF (x_OKL_cure_payment_lines_rec.attribute1 = OKC_API.G_MISS_CHAR)
1971: THEN
1972: x_OKL_cure_payment_lines_rec.attribute1 := l_OKL_cure_payment_lines_rec.attribute1;
1973: END IF;
1974: IF (x_OKL_cure_payment_lines_rec.attribute2 = OKC_API.G_MISS_CHAR)
1968: x_OKL_cure_payment_lines_rec.attribute_category := l_OKL_cure_payment_lines_rec.attribute_category;
1969: END IF;
1970: IF (x_OKL_cure_payment_lines_rec.attribute1 = OKC_API.G_MISS_CHAR)
1971: THEN
1972: x_OKL_cure_payment_lines_rec.attribute1 := l_OKL_cure_payment_lines_rec.attribute1;
1973: END IF;
1974: IF (x_OKL_cure_payment_lines_rec.attribute2 = OKC_API.G_MISS_CHAR)
1975: THEN
1976: x_OKL_cure_payment_lines_rec.attribute2 := l_OKL_cure_payment_lines_rec.attribute2;
1970: IF (x_OKL_cure_payment_lines_rec.attribute1 = OKC_API.G_MISS_CHAR)
1971: THEN
1972: x_OKL_cure_payment_lines_rec.attribute1 := l_OKL_cure_payment_lines_rec.attribute1;
1973: END IF;
1974: IF (x_OKL_cure_payment_lines_rec.attribute2 = OKC_API.G_MISS_CHAR)
1975: THEN
1976: x_OKL_cure_payment_lines_rec.attribute2 := l_OKL_cure_payment_lines_rec.attribute2;
1977: END IF;
1978: IF (x_OKL_cure_payment_lines_rec.attribute3 = OKC_API.G_MISS_CHAR)
1972: x_OKL_cure_payment_lines_rec.attribute1 := l_OKL_cure_payment_lines_rec.attribute1;
1973: END IF;
1974: IF (x_OKL_cure_payment_lines_rec.attribute2 = OKC_API.G_MISS_CHAR)
1975: THEN
1976: x_OKL_cure_payment_lines_rec.attribute2 := l_OKL_cure_payment_lines_rec.attribute2;
1977: END IF;
1978: IF (x_OKL_cure_payment_lines_rec.attribute3 = OKC_API.G_MISS_CHAR)
1979: THEN
1980: x_OKL_cure_payment_lines_rec.attribute3 := l_OKL_cure_payment_lines_rec.attribute3;
1974: IF (x_OKL_cure_payment_lines_rec.attribute2 = OKC_API.G_MISS_CHAR)
1975: THEN
1976: x_OKL_cure_payment_lines_rec.attribute2 := l_OKL_cure_payment_lines_rec.attribute2;
1977: END IF;
1978: IF (x_OKL_cure_payment_lines_rec.attribute3 = OKC_API.G_MISS_CHAR)
1979: THEN
1980: x_OKL_cure_payment_lines_rec.attribute3 := l_OKL_cure_payment_lines_rec.attribute3;
1981: END IF;
1982: IF (x_OKL_cure_payment_lines_rec.attribute4 = OKC_API.G_MISS_CHAR)
1976: x_OKL_cure_payment_lines_rec.attribute2 := l_OKL_cure_payment_lines_rec.attribute2;
1977: END IF;
1978: IF (x_OKL_cure_payment_lines_rec.attribute3 = OKC_API.G_MISS_CHAR)
1979: THEN
1980: x_OKL_cure_payment_lines_rec.attribute3 := l_OKL_cure_payment_lines_rec.attribute3;
1981: END IF;
1982: IF (x_OKL_cure_payment_lines_rec.attribute4 = OKC_API.G_MISS_CHAR)
1983: THEN
1984: x_OKL_cure_payment_lines_rec.attribute4 := l_OKL_cure_payment_lines_rec.attribute4;
1978: IF (x_OKL_cure_payment_lines_rec.attribute3 = OKC_API.G_MISS_CHAR)
1979: THEN
1980: x_OKL_cure_payment_lines_rec.attribute3 := l_OKL_cure_payment_lines_rec.attribute3;
1981: END IF;
1982: IF (x_OKL_cure_payment_lines_rec.attribute4 = OKC_API.G_MISS_CHAR)
1983: THEN
1984: x_OKL_cure_payment_lines_rec.attribute4 := l_OKL_cure_payment_lines_rec.attribute4;
1985: END IF;
1986: IF (x_OKL_cure_payment_lines_rec.attribute5 = OKC_API.G_MISS_CHAR)
1980: x_OKL_cure_payment_lines_rec.attribute3 := l_OKL_cure_payment_lines_rec.attribute3;
1981: END IF;
1982: IF (x_OKL_cure_payment_lines_rec.attribute4 = OKC_API.G_MISS_CHAR)
1983: THEN
1984: x_OKL_cure_payment_lines_rec.attribute4 := l_OKL_cure_payment_lines_rec.attribute4;
1985: END IF;
1986: IF (x_OKL_cure_payment_lines_rec.attribute5 = OKC_API.G_MISS_CHAR)
1987: THEN
1988: x_OKL_cure_payment_lines_rec.attribute5 := l_OKL_cure_payment_lines_rec.attribute5;
1982: IF (x_OKL_cure_payment_lines_rec.attribute4 = OKC_API.G_MISS_CHAR)
1983: THEN
1984: x_OKL_cure_payment_lines_rec.attribute4 := l_OKL_cure_payment_lines_rec.attribute4;
1985: END IF;
1986: IF (x_OKL_cure_payment_lines_rec.attribute5 = OKC_API.G_MISS_CHAR)
1987: THEN
1988: x_OKL_cure_payment_lines_rec.attribute5 := l_OKL_cure_payment_lines_rec.attribute5;
1989: END IF;
1990: IF (x_OKL_cure_payment_lines_rec.attribute6 = OKC_API.G_MISS_CHAR)
1984: x_OKL_cure_payment_lines_rec.attribute4 := l_OKL_cure_payment_lines_rec.attribute4;
1985: END IF;
1986: IF (x_OKL_cure_payment_lines_rec.attribute5 = OKC_API.G_MISS_CHAR)
1987: THEN
1988: x_OKL_cure_payment_lines_rec.attribute5 := l_OKL_cure_payment_lines_rec.attribute5;
1989: END IF;
1990: IF (x_OKL_cure_payment_lines_rec.attribute6 = OKC_API.G_MISS_CHAR)
1991: THEN
1992: x_OKL_cure_payment_lines_rec.attribute6 := l_OKL_cure_payment_lines_rec.attribute6;
1986: IF (x_OKL_cure_payment_lines_rec.attribute5 = OKC_API.G_MISS_CHAR)
1987: THEN
1988: x_OKL_cure_payment_lines_rec.attribute5 := l_OKL_cure_payment_lines_rec.attribute5;
1989: END IF;
1990: IF (x_OKL_cure_payment_lines_rec.attribute6 = OKC_API.G_MISS_CHAR)
1991: THEN
1992: x_OKL_cure_payment_lines_rec.attribute6 := l_OKL_cure_payment_lines_rec.attribute6;
1993: END IF;
1994: IF (x_OKL_cure_payment_lines_rec.attribute7 = OKC_API.G_MISS_CHAR)
1988: x_OKL_cure_payment_lines_rec.attribute5 := l_OKL_cure_payment_lines_rec.attribute5;
1989: END IF;
1990: IF (x_OKL_cure_payment_lines_rec.attribute6 = OKC_API.G_MISS_CHAR)
1991: THEN
1992: x_OKL_cure_payment_lines_rec.attribute6 := l_OKL_cure_payment_lines_rec.attribute6;
1993: END IF;
1994: IF (x_OKL_cure_payment_lines_rec.attribute7 = OKC_API.G_MISS_CHAR)
1995: THEN
1996: x_OKL_cure_payment_lines_rec.attribute7 := l_OKL_cure_payment_lines_rec.attribute7;
1990: IF (x_OKL_cure_payment_lines_rec.attribute6 = OKC_API.G_MISS_CHAR)
1991: THEN
1992: x_OKL_cure_payment_lines_rec.attribute6 := l_OKL_cure_payment_lines_rec.attribute6;
1993: END IF;
1994: IF (x_OKL_cure_payment_lines_rec.attribute7 = OKC_API.G_MISS_CHAR)
1995: THEN
1996: x_OKL_cure_payment_lines_rec.attribute7 := l_OKL_cure_payment_lines_rec.attribute7;
1997: END IF;
1998: IF (x_OKL_cure_payment_lines_rec.attribute8 = OKC_API.G_MISS_CHAR)
1992: x_OKL_cure_payment_lines_rec.attribute6 := l_OKL_cure_payment_lines_rec.attribute6;
1993: END IF;
1994: IF (x_OKL_cure_payment_lines_rec.attribute7 = OKC_API.G_MISS_CHAR)
1995: THEN
1996: x_OKL_cure_payment_lines_rec.attribute7 := l_OKL_cure_payment_lines_rec.attribute7;
1997: END IF;
1998: IF (x_OKL_cure_payment_lines_rec.attribute8 = OKC_API.G_MISS_CHAR)
1999: THEN
2000: x_OKL_cure_payment_lines_rec.attribute8 := l_OKL_cure_payment_lines_rec.attribute8;
1994: IF (x_OKL_cure_payment_lines_rec.attribute7 = OKC_API.G_MISS_CHAR)
1995: THEN
1996: x_OKL_cure_payment_lines_rec.attribute7 := l_OKL_cure_payment_lines_rec.attribute7;
1997: END IF;
1998: IF (x_OKL_cure_payment_lines_rec.attribute8 = OKC_API.G_MISS_CHAR)
1999: THEN
2000: x_OKL_cure_payment_lines_rec.attribute8 := l_OKL_cure_payment_lines_rec.attribute8;
2001: END IF;
2002: IF (x_OKL_cure_payment_lines_rec.attribute9 = OKC_API.G_MISS_CHAR)
1996: x_OKL_cure_payment_lines_rec.attribute7 := l_OKL_cure_payment_lines_rec.attribute7;
1997: END IF;
1998: IF (x_OKL_cure_payment_lines_rec.attribute8 = OKC_API.G_MISS_CHAR)
1999: THEN
2000: x_OKL_cure_payment_lines_rec.attribute8 := l_OKL_cure_payment_lines_rec.attribute8;
2001: END IF;
2002: IF (x_OKL_cure_payment_lines_rec.attribute9 = OKC_API.G_MISS_CHAR)
2003: THEN
2004: x_OKL_cure_payment_lines_rec.attribute9 := l_OKL_cure_payment_lines_rec.attribute9;
1998: IF (x_OKL_cure_payment_lines_rec.attribute8 = OKC_API.G_MISS_CHAR)
1999: THEN
2000: x_OKL_cure_payment_lines_rec.attribute8 := l_OKL_cure_payment_lines_rec.attribute8;
2001: END IF;
2002: IF (x_OKL_cure_payment_lines_rec.attribute9 = OKC_API.G_MISS_CHAR)
2003: THEN
2004: x_OKL_cure_payment_lines_rec.attribute9 := l_OKL_cure_payment_lines_rec.attribute9;
2005: END IF;
2006: IF (x_OKL_cure_payment_lines_rec.attribute10 = OKC_API.G_MISS_CHAR)
2000: x_OKL_cure_payment_lines_rec.attribute8 := l_OKL_cure_payment_lines_rec.attribute8;
2001: END IF;
2002: IF (x_OKL_cure_payment_lines_rec.attribute9 = OKC_API.G_MISS_CHAR)
2003: THEN
2004: x_OKL_cure_payment_lines_rec.attribute9 := l_OKL_cure_payment_lines_rec.attribute9;
2005: END IF;
2006: IF (x_OKL_cure_payment_lines_rec.attribute10 = OKC_API.G_MISS_CHAR)
2007: THEN
2008: x_OKL_cure_payment_lines_rec.attribute10 := l_OKL_cure_payment_lines_rec.attribute10;
2002: IF (x_OKL_cure_payment_lines_rec.attribute9 = OKC_API.G_MISS_CHAR)
2003: THEN
2004: x_OKL_cure_payment_lines_rec.attribute9 := l_OKL_cure_payment_lines_rec.attribute9;
2005: END IF;
2006: IF (x_OKL_cure_payment_lines_rec.attribute10 = OKC_API.G_MISS_CHAR)
2007: THEN
2008: x_OKL_cure_payment_lines_rec.attribute10 := l_OKL_cure_payment_lines_rec.attribute10;
2009: END IF;
2010: IF (x_OKL_cure_payment_lines_rec.attribute11 = OKC_API.G_MISS_CHAR)
2004: x_OKL_cure_payment_lines_rec.attribute9 := l_OKL_cure_payment_lines_rec.attribute9;
2005: END IF;
2006: IF (x_OKL_cure_payment_lines_rec.attribute10 = OKC_API.G_MISS_CHAR)
2007: THEN
2008: x_OKL_cure_payment_lines_rec.attribute10 := l_OKL_cure_payment_lines_rec.attribute10;
2009: END IF;
2010: IF (x_OKL_cure_payment_lines_rec.attribute11 = OKC_API.G_MISS_CHAR)
2011: THEN
2012: x_OKL_cure_payment_lines_rec.attribute11 := l_OKL_cure_payment_lines_rec.attribute11;
2006: IF (x_OKL_cure_payment_lines_rec.attribute10 = OKC_API.G_MISS_CHAR)
2007: THEN
2008: x_OKL_cure_payment_lines_rec.attribute10 := l_OKL_cure_payment_lines_rec.attribute10;
2009: END IF;
2010: IF (x_OKL_cure_payment_lines_rec.attribute11 = OKC_API.G_MISS_CHAR)
2011: THEN
2012: x_OKL_cure_payment_lines_rec.attribute11 := l_OKL_cure_payment_lines_rec.attribute11;
2013: END IF;
2014: IF (x_OKL_cure_payment_lines_rec.attribute12 = OKC_API.G_MISS_CHAR)
2008: x_OKL_cure_payment_lines_rec.attribute10 := l_OKL_cure_payment_lines_rec.attribute10;
2009: END IF;
2010: IF (x_OKL_cure_payment_lines_rec.attribute11 = OKC_API.G_MISS_CHAR)
2011: THEN
2012: x_OKL_cure_payment_lines_rec.attribute11 := l_OKL_cure_payment_lines_rec.attribute11;
2013: END IF;
2014: IF (x_OKL_cure_payment_lines_rec.attribute12 = OKC_API.G_MISS_CHAR)
2015: THEN
2016: x_OKL_cure_payment_lines_rec.attribute12 := l_OKL_cure_payment_lines_rec.attribute12;
2010: IF (x_OKL_cure_payment_lines_rec.attribute11 = OKC_API.G_MISS_CHAR)
2011: THEN
2012: x_OKL_cure_payment_lines_rec.attribute11 := l_OKL_cure_payment_lines_rec.attribute11;
2013: END IF;
2014: IF (x_OKL_cure_payment_lines_rec.attribute12 = OKC_API.G_MISS_CHAR)
2015: THEN
2016: x_OKL_cure_payment_lines_rec.attribute12 := l_OKL_cure_payment_lines_rec.attribute12;
2017: END IF;
2018: IF (x_OKL_cure_payment_lines_rec.attribute13 = OKC_API.G_MISS_CHAR)
2012: x_OKL_cure_payment_lines_rec.attribute11 := l_OKL_cure_payment_lines_rec.attribute11;
2013: END IF;
2014: IF (x_OKL_cure_payment_lines_rec.attribute12 = OKC_API.G_MISS_CHAR)
2015: THEN
2016: x_OKL_cure_payment_lines_rec.attribute12 := l_OKL_cure_payment_lines_rec.attribute12;
2017: END IF;
2018: IF (x_OKL_cure_payment_lines_rec.attribute13 = OKC_API.G_MISS_CHAR)
2019: THEN
2020: x_OKL_cure_payment_lines_rec.attribute13 := l_OKL_cure_payment_lines_rec.attribute13;
2014: IF (x_OKL_cure_payment_lines_rec.attribute12 = OKC_API.G_MISS_CHAR)
2015: THEN
2016: x_OKL_cure_payment_lines_rec.attribute12 := l_OKL_cure_payment_lines_rec.attribute12;
2017: END IF;
2018: IF (x_OKL_cure_payment_lines_rec.attribute13 = OKC_API.G_MISS_CHAR)
2019: THEN
2020: x_OKL_cure_payment_lines_rec.attribute13 := l_OKL_cure_payment_lines_rec.attribute13;
2021: END IF;
2022: IF (x_OKL_cure_payment_lines_rec.attribute14 = OKC_API.G_MISS_CHAR)
2016: x_OKL_cure_payment_lines_rec.attribute12 := l_OKL_cure_payment_lines_rec.attribute12;
2017: END IF;
2018: IF (x_OKL_cure_payment_lines_rec.attribute13 = OKC_API.G_MISS_CHAR)
2019: THEN
2020: x_OKL_cure_payment_lines_rec.attribute13 := l_OKL_cure_payment_lines_rec.attribute13;
2021: END IF;
2022: IF (x_OKL_cure_payment_lines_rec.attribute14 = OKC_API.G_MISS_CHAR)
2023: THEN
2024: x_OKL_cure_payment_lines_rec.attribute14 := l_OKL_cure_payment_lines_rec.attribute14;
2018: IF (x_OKL_cure_payment_lines_rec.attribute13 = OKC_API.G_MISS_CHAR)
2019: THEN
2020: x_OKL_cure_payment_lines_rec.attribute13 := l_OKL_cure_payment_lines_rec.attribute13;
2021: END IF;
2022: IF (x_OKL_cure_payment_lines_rec.attribute14 = OKC_API.G_MISS_CHAR)
2023: THEN
2024: x_OKL_cure_payment_lines_rec.attribute14 := l_OKL_cure_payment_lines_rec.attribute14;
2025: END IF;
2026: IF (x_OKL_cure_payment_lines_rec.attribute15 = OKC_API.G_MISS_CHAR)
2020: x_OKL_cure_payment_lines_rec.attribute13 := l_OKL_cure_payment_lines_rec.attribute13;
2021: END IF;
2022: IF (x_OKL_cure_payment_lines_rec.attribute14 = OKC_API.G_MISS_CHAR)
2023: THEN
2024: x_OKL_cure_payment_lines_rec.attribute14 := l_OKL_cure_payment_lines_rec.attribute14;
2025: END IF;
2026: IF (x_OKL_cure_payment_lines_rec.attribute15 = OKC_API.G_MISS_CHAR)
2027: THEN
2028: x_OKL_cure_payment_lines_rec.attribute15 := l_OKL_cure_payment_lines_rec.attribute15;
2022: IF (x_OKL_cure_payment_lines_rec.attribute14 = OKC_API.G_MISS_CHAR)
2023: THEN
2024: x_OKL_cure_payment_lines_rec.attribute14 := l_OKL_cure_payment_lines_rec.attribute14;
2025: END IF;
2026: IF (x_OKL_cure_payment_lines_rec.attribute15 = OKC_API.G_MISS_CHAR)
2027: THEN
2028: x_OKL_cure_payment_lines_rec.attribute15 := l_OKL_cure_payment_lines_rec.attribute15;
2029: END IF;
2030: IF (x_OKL_cure_payment_lines_rec.created_by = OKC_API.G_MISS_NUM)
2024: x_OKL_cure_payment_lines_rec.attribute14 := l_OKL_cure_payment_lines_rec.attribute14;
2025: END IF;
2026: IF (x_OKL_cure_payment_lines_rec.attribute15 = OKC_API.G_MISS_CHAR)
2027: THEN
2028: x_OKL_cure_payment_lines_rec.attribute15 := l_OKL_cure_payment_lines_rec.attribute15;
2029: END IF;
2030: IF (x_OKL_cure_payment_lines_rec.created_by = OKC_API.G_MISS_NUM)
2031: THEN
2032: x_OKL_cure_payment_lines_rec.created_by := l_OKL_cure_payment_lines_rec.created_by;
2026: IF (x_OKL_cure_payment_lines_rec.attribute15 = OKC_API.G_MISS_CHAR)
2027: THEN
2028: x_OKL_cure_payment_lines_rec.attribute15 := l_OKL_cure_payment_lines_rec.attribute15;
2029: END IF;
2030: IF (x_OKL_cure_payment_lines_rec.created_by = OKC_API.G_MISS_NUM)
2031: THEN
2032: x_OKL_cure_payment_lines_rec.created_by := l_OKL_cure_payment_lines_rec.created_by;
2033: END IF;
2034: IF (x_OKL_cure_payment_lines_rec.creation_date = OKC_API.G_MISS_DATE)
2028: x_OKL_cure_payment_lines_rec.attribute15 := l_OKL_cure_payment_lines_rec.attribute15;
2029: END IF;
2030: IF (x_OKL_cure_payment_lines_rec.created_by = OKC_API.G_MISS_NUM)
2031: THEN
2032: x_OKL_cure_payment_lines_rec.created_by := l_OKL_cure_payment_lines_rec.created_by;
2033: END IF;
2034: IF (x_OKL_cure_payment_lines_rec.creation_date = OKC_API.G_MISS_DATE)
2035: THEN
2036: x_OKL_cure_payment_lines_rec.creation_date := l_OKL_cure_payment_lines_rec.creation_date;
2030: IF (x_OKL_cure_payment_lines_rec.created_by = OKC_API.G_MISS_NUM)
2031: THEN
2032: x_OKL_cure_payment_lines_rec.created_by := l_OKL_cure_payment_lines_rec.created_by;
2033: END IF;
2034: IF (x_OKL_cure_payment_lines_rec.creation_date = OKC_API.G_MISS_DATE)
2035: THEN
2036: x_OKL_cure_payment_lines_rec.creation_date := l_OKL_cure_payment_lines_rec.creation_date;
2037: END IF;
2038: IF (x_OKL_cure_payment_lines_rec.last_updated_by = OKC_API.G_MISS_NUM)
2032: x_OKL_cure_payment_lines_rec.created_by := l_OKL_cure_payment_lines_rec.created_by;
2033: END IF;
2034: IF (x_OKL_cure_payment_lines_rec.creation_date = OKC_API.G_MISS_DATE)
2035: THEN
2036: x_OKL_cure_payment_lines_rec.creation_date := l_OKL_cure_payment_lines_rec.creation_date;
2037: END IF;
2038: IF (x_OKL_cure_payment_lines_rec.last_updated_by = OKC_API.G_MISS_NUM)
2039: THEN
2040: x_OKL_cure_payment_lines_rec.last_updated_by := l_OKL_cure_payment_lines_rec.last_updated_by;
2034: IF (x_OKL_cure_payment_lines_rec.creation_date = OKC_API.G_MISS_DATE)
2035: THEN
2036: x_OKL_cure_payment_lines_rec.creation_date := l_OKL_cure_payment_lines_rec.creation_date;
2037: END IF;
2038: IF (x_OKL_cure_payment_lines_rec.last_updated_by = OKC_API.G_MISS_NUM)
2039: THEN
2040: x_OKL_cure_payment_lines_rec.last_updated_by := l_OKL_cure_payment_lines_rec.last_updated_by;
2041: END IF;
2042: IF (x_OKL_cure_payment_lines_rec.last_update_date = OKC_API.G_MISS_DATE)
2036: x_OKL_cure_payment_lines_rec.creation_date := l_OKL_cure_payment_lines_rec.creation_date;
2037: END IF;
2038: IF (x_OKL_cure_payment_lines_rec.last_updated_by = OKC_API.G_MISS_NUM)
2039: THEN
2040: x_OKL_cure_payment_lines_rec.last_updated_by := l_OKL_cure_payment_lines_rec.last_updated_by;
2041: END IF;
2042: IF (x_OKL_cure_payment_lines_rec.last_update_date = OKC_API.G_MISS_DATE)
2043: THEN
2044: x_OKL_cure_payment_lines_rec.last_update_date := l_OKL_cure_payment_lines_rec.last_update_date;
2038: IF (x_OKL_cure_payment_lines_rec.last_updated_by = OKC_API.G_MISS_NUM)
2039: THEN
2040: x_OKL_cure_payment_lines_rec.last_updated_by := l_OKL_cure_payment_lines_rec.last_updated_by;
2041: END IF;
2042: IF (x_OKL_cure_payment_lines_rec.last_update_date = OKC_API.G_MISS_DATE)
2043: THEN
2044: x_OKL_cure_payment_lines_rec.last_update_date := l_OKL_cure_payment_lines_rec.last_update_date;
2045: END IF;
2046: IF (x_OKL_cure_payment_lines_rec.last_update_login = OKC_API.G_MISS_NUM)
2040: x_OKL_cure_payment_lines_rec.last_updated_by := l_OKL_cure_payment_lines_rec.last_updated_by;
2041: END IF;
2042: IF (x_OKL_cure_payment_lines_rec.last_update_date = OKC_API.G_MISS_DATE)
2043: THEN
2044: x_OKL_cure_payment_lines_rec.last_update_date := l_OKL_cure_payment_lines_rec.last_update_date;
2045: END IF;
2046: IF (x_OKL_cure_payment_lines_rec.last_update_login = OKC_API.G_MISS_NUM)
2047: THEN
2048: x_OKL_cure_payment_lines_rec.last_update_login := l_OKL_cure_payment_lines_rec.last_update_login;
2042: IF (x_OKL_cure_payment_lines_rec.last_update_date = OKC_API.G_MISS_DATE)
2043: THEN
2044: x_OKL_cure_payment_lines_rec.last_update_date := l_OKL_cure_payment_lines_rec.last_update_date;
2045: END IF;
2046: IF (x_OKL_cure_payment_lines_rec.last_update_login = OKC_API.G_MISS_NUM)
2047: THEN
2048: x_OKL_cure_payment_lines_rec.last_update_login := l_OKL_cure_payment_lines_rec.last_update_login;
2049: END IF;
2050: END IF;
2044: x_OKL_cure_payment_lines_rec.last_update_date := l_OKL_cure_payment_lines_rec.last_update_date;
2045: END IF;
2046: IF (x_OKL_cure_payment_lines_rec.last_update_login = OKC_API.G_MISS_NUM)
2047: THEN
2048: x_OKL_cure_payment_lines_rec.last_update_login := l_OKL_cure_payment_lines_rec.last_update_login;
2049: END IF;
2050: END IF;
2051: RETURN(l_return_status);
2052: END populate_new_record;
2050: END IF;
2051: RETURN(l_return_status);
2052: END populate_new_record;
2053: -----------------------------------------------
2054: -- Set_Attributes for:OKL_CURE_PAYMENT_LINES --
2055: -----------------------------------------------
2056: FUNCTION Set_Attributes (
2057: p_OKL_cure_payment_lines_rec IN OKLCurePaymentLinesRecType,
2058: x_OKL_cure_payment_lines_rec OUT NOCOPY OKLCurePaymentLinesRecType
2053: -----------------------------------------------
2054: -- Set_Attributes for:OKL_CURE_PAYMENT_LINES --
2055: -----------------------------------------------
2056: FUNCTION Set_Attributes (
2057: p_OKL_cure_payment_lines_rec IN OKLCurePaymentLinesRecType,
2058: x_OKL_cure_payment_lines_rec OUT NOCOPY OKLCurePaymentLinesRecType
2059: ) RETURN VARCHAR2 IS
2060: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2061: BEGIN
2054: -- Set_Attributes for:OKL_CURE_PAYMENT_LINES --
2055: -----------------------------------------------
2056: FUNCTION Set_Attributes (
2057: p_OKL_cure_payment_lines_rec IN OKLCurePaymentLinesRecType,
2058: x_OKL_cure_payment_lines_rec OUT NOCOPY OKLCurePaymentLinesRecType
2059: ) RETURN VARCHAR2 IS
2060: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2061: BEGIN
2062: x_OKL_cure_payment_lines_rec := p_OKL_cure_payment_lines_rec;
2058: x_OKL_cure_payment_lines_rec OUT NOCOPY OKLCurePaymentLinesRecType
2059: ) RETURN VARCHAR2 IS
2060: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2061: BEGIN
2062: x_OKL_cure_payment_lines_rec := p_OKL_cure_payment_lines_rec;
2063: x_OKL_cure_payment_lines_rec.OBJECT_VERSION_NUMBER := p_OKL_cure_payment_lines_rec.OBJECT_VERSION_NUMBER + 1;
2064: RETURN(l_return_status);
2065: END Set_Attributes;
2066: BEGIN
2059: ) RETURN VARCHAR2 IS
2060: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2061: BEGIN
2062: x_OKL_cure_payment_lines_rec := p_OKL_cure_payment_lines_rec;
2063: x_OKL_cure_payment_lines_rec.OBJECT_VERSION_NUMBER := p_OKL_cure_payment_lines_rec.OBJECT_VERSION_NUMBER + 1;
2064: RETURN(l_return_status);
2065: END Set_Attributes;
2066: BEGIN
2067: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2074: RAISE OKC_API.G_EXCEPTION_ERROR;
2075: END IF;
2076: --- Setting item attributes
2077: l_return_status := Set_Attributes(
2078: p_OKL_cure_payment_lines_rec, -- IN
2079: l_OKL_cure_payment_lines_rec); -- OUT
2080: --- If any errors happen abort API
2081: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2082: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2075: END IF;
2076: --- Setting item attributes
2077: l_return_status := Set_Attributes(
2078: p_OKL_cure_payment_lines_rec, -- IN
2079: l_OKL_cure_payment_lines_rec); -- OUT
2080: --- If any errors happen abort API
2081: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2082: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2083: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2082: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2083: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2084: RAISE OKC_API.G_EXCEPTION_ERROR;
2085: END IF;
2086: l_return_status := populate_new_record(l_OKL_cure_payment_lines_rec, LDefOKLCurePaymentLinesRec);
2087: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2088: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2089: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2090: RAISE OKC_API.G_EXCEPTION_ERROR;
2088: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2089: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2090: RAISE OKC_API.G_EXCEPTION_ERROR;
2091: END IF;
2092: UPDATE OKL_CURE_PAYMENT_LINES
2093: SET CURE_PAYMENT_ID = LDefOKLCurePaymentLinesRec.cure_payment_id,
2094: CHR_ID = LDefOKLCurePaymentLinesRec.chr_id,
2095: AMOUNT = LDefOKLCurePaymentLinesRec.amount,
2096: CURED_FLAG = LDefOKLCurePaymentLinesRec.cured_flag,
2130: LAST_UPDATE_DATE = LDefOKLCurePaymentLinesRec.last_update_date,
2131: LAST_UPDATE_LOGIN = LDefOKLCurePaymentLinesRec.last_update_login
2132: WHERE CURE_PAYMENT_LINE_ID = LDefOKLCurePaymentLinesRec.cure_payment_line_id;
2133:
2134: x_OKL_cure_payment_lines_rec := l_OKL_cure_payment_lines_rec;
2135: x_return_status := l_return_status;
2136: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2137: EXCEPTION
2138: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2166: '_PVT'
2167: );
2168: END update_row;
2169: ---------------------------------------------
2170: -- update_row for:OKL_CURE_PAYMENT_LINES_V --
2171: ---------------------------------------------
2172: PROCEDURE update_row(
2173: p_api_version IN NUMBER,
2174: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2183: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2184: l_CPNv_rec CPNv_rec_type := p_CPNv_rec;
2185: l_def_CPNv_rec CPNv_rec_type;
2186: l_db_CPNv_rec CPNv_rec_type;
2187: l_OKL_cure_payment_lines_rec OKLCurePaymentLinesRecType;
2188: lx_OKL_cure_payment_lines_rec OKLCurePaymentLinesRecType;
2189: -------------------------------
2190: -- FUNCTION fill_who_columns --
2191: -------------------------------
2184: l_CPNv_rec CPNv_rec_type := p_CPNv_rec;
2185: l_def_CPNv_rec CPNv_rec_type;
2186: l_db_CPNv_rec CPNv_rec_type;
2187: l_OKL_cure_payment_lines_rec OKLCurePaymentLinesRecType;
2188: lx_OKL_cure_payment_lines_rec OKLCurePaymentLinesRecType;
2189: -------------------------------
2190: -- FUNCTION fill_who_columns --
2191: -------------------------------
2192: FUNCTION fill_who_columns (
2374: END IF;
2375: RETURN(l_return_status);
2376: END populate_new_record;
2377: -------------------------------------------------
2378: -- Set_Attributes for:OKL_CURE_PAYMENT_LINES_V --
2379: -------------------------------------------------
2380: FUNCTION Set_Attributes (
2381: p_CPNv_rec IN CPNv_rec_type,
2382: x_CPNv_rec OUT NOCOPY CPNv_rec_type
2447:
2448: -----------------------------------------
2449: -- Move VIEW record to "Child" records --
2450: -----------------------------------------
2451: migrate(l_def_CPNv_rec, l_OKL_cure_payment_lines_rec);
2452: -----------------------------------------------
2453: -- Call the UPDATE_ROW for each child record --
2454: -----------------------------------------------
2455: update_row(
2456: p_init_msg_list,
2457: l_return_status,
2458: x_msg_count,
2459: x_msg_data,
2460: l_OKL_cure_payment_lines_rec,
2461: lx_OKL_cure_payment_lines_rec
2462: );
2463: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2464: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2457: l_return_status,
2458: x_msg_count,
2459: x_msg_data,
2460: l_OKL_cure_payment_lines_rec,
2461: lx_OKL_cure_payment_lines_rec
2462: );
2463: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2464: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2465: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2464: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2465: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2466: RAISE OKC_API.G_EXCEPTION_ERROR;
2467: END IF;
2468: migrate(lx_OKL_cure_payment_lines_rec, l_def_CPNv_rec);
2469: x_CPNv_rec := l_def_CPNv_rec;
2470: x_return_status := l_return_status;
2471: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2472: EXCEPTION
2666: ---------------------------------------------------------------------------
2667: -- PROCEDURE delete_row
2668: ---------------------------------------------------------------------------
2669: -------------------------------------------
2670: -- delete_row for:OKL_CURE_PAYMENT_LINES --
2671: -------------------------------------------
2672: PROCEDURE delete_row(
2673: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2674: x_return_status OUT NOCOPY VARCHAR2,
2673: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2674: x_return_status OUT NOCOPY VARCHAR2,
2675: x_msg_count OUT NOCOPY NUMBER,
2676: x_msg_data OUT NOCOPY VARCHAR2,
2677: p_OKL_cure_payment_lines_rec IN OKLCurePaymentLinesRecType) IS
2678:
2679: l_api_version CONSTANT NUMBER := 1;
2680: l_api_name CONSTANT VARCHAR2(30) := 'B_delete_row';
2681: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2678:
2679: l_api_version CONSTANT NUMBER := 1;
2680: l_api_name CONSTANT VARCHAR2(30) := 'B_delete_row';
2681: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2682: l_OKL_cure_payment_lines_rec OKLCurePaymentLinesRecType := p_OKL_cure_payment_lines_rec;
2683: l_row_notfound BOOLEAN := TRUE;
2684: BEGIN
2685: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2686: p_init_msg_list,
2691: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2692: RAISE OKC_API.G_EXCEPTION_ERROR;
2693: END IF;
2694:
2695: DELETE FROM OKL_CURE_PAYMENT_LINES
2696: WHERE CURE_PAYMENT_LINE_ID = p_OKL_cure_payment_lines_rec.cure_payment_line_id;
2697:
2698: x_return_status := l_return_status;
2699: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2692: RAISE OKC_API.G_EXCEPTION_ERROR;
2693: END IF;
2694:
2695: DELETE FROM OKL_CURE_PAYMENT_LINES
2696: WHERE CURE_PAYMENT_LINE_ID = p_OKL_cure_payment_lines_rec.cure_payment_line_id;
2697:
2698: x_return_status := l_return_status;
2699: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2700: EXCEPTION
2729: '_PVT'
2730: );
2731: END delete_row;
2732: ---------------------------------------------
2733: -- delete_row for:OKL_CURE_PAYMENT_LINES_V --
2734: ---------------------------------------------
2735: PROCEDURE delete_row(
2736: p_api_version IN NUMBER,
2737: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2743: l_api_version CONSTANT NUMBER := 1;
2744: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
2745: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2746: l_CPNv_rec CPNv_rec_type := p_CPNv_rec;
2747: l_OKL_cure_payment_lines_rec OKLCurePaymentLinesRecType;
2748: BEGIN
2749: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2750: G_PKG_NAME,
2751: p_init_msg_list,
2760: END IF;
2761: -----------------------------------------
2762: -- Move VIEW record to "Child" records --
2763: -----------------------------------------
2764: migrate(l_CPNv_rec, l_OKL_cure_payment_lines_rec);
2765: -----------------------------------------------
2766: -- Call the DELETE_ROW for each child record --
2767: -----------------------------------------------
2768: delete_row(
2769: p_init_msg_list,
2770: l_return_status,
2771: x_msg_count,
2772: x_msg_data,
2773: l_OKL_cure_payment_lines_rec
2774: );
2775: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2776: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2777: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2811: '_PVT'
2812: );
2813: END delete_row;
2814: --------------------------------------------------------
2815: -- PL/SQL TBL delete_row for:OKL_CURE_PAYMENT_LINES_V --
2816: --------------------------------------------------------
2817: PROCEDURE delete_row(
2818: p_api_version IN NUMBER,
2819: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2907: );
2908: END delete_row;
2909:
2910: --------------------------------------------------------
2911: -- PL/SQL TBL delete_row for:OKL_CURE_PAYMENT_LINES_V --
2912: --------------------------------------------------------
2913: PROCEDURE delete_row(
2914: p_api_version IN NUMBER,
2915: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,