392: and ra.status <> 'UNAPP'
393: and nvl(ra.confirmed_flag,'Y') = 'Y';
394:
395: TYPE ra_rec_type IS RECORD (
396: l_rowid DBMS_SQL.VARCHAR2_TABLE
397: ,receivable_application_id DBMS_SQL.NUMBER_TABLE
398: ,amount_applied DBMS_SQL.NUMBER_TABLE
399: ,payment_schedule_id DBMS_SQL.NUMBER_TABLE
400: ,applied_payment_schedule_id DBMS_SQL.NUMBER_TABLE
393: and nvl(ra.confirmed_flag,'Y') = 'Y';
394:
395: TYPE ra_rec_type IS RECORD (
396: l_rowid DBMS_SQL.VARCHAR2_TABLE
397: ,receivable_application_id DBMS_SQL.NUMBER_TABLE
398: ,amount_applied DBMS_SQL.NUMBER_TABLE
399: ,payment_schedule_id DBMS_SQL.NUMBER_TABLE
400: ,applied_payment_schedule_id DBMS_SQL.NUMBER_TABLE
401: ,applied_customer_trx_id DBMS_SQL.NUMBER_TABLE
394:
395: TYPE ra_rec_type IS RECORD (
396: l_rowid DBMS_SQL.VARCHAR2_TABLE
397: ,receivable_application_id DBMS_SQL.NUMBER_TABLE
398: ,amount_applied DBMS_SQL.NUMBER_TABLE
399: ,payment_schedule_id DBMS_SQL.NUMBER_TABLE
400: ,applied_payment_schedule_id DBMS_SQL.NUMBER_TABLE
401: ,applied_customer_trx_id DBMS_SQL.NUMBER_TABLE
402: ,comments DBMS_SQL.VARCHAR2_TABLE
395: TYPE ra_rec_type IS RECORD (
396: l_rowid DBMS_SQL.VARCHAR2_TABLE
397: ,receivable_application_id DBMS_SQL.NUMBER_TABLE
398: ,amount_applied DBMS_SQL.NUMBER_TABLE
399: ,payment_schedule_id DBMS_SQL.NUMBER_TABLE
400: ,applied_payment_schedule_id DBMS_SQL.NUMBER_TABLE
401: ,applied_customer_trx_id DBMS_SQL.NUMBER_TABLE
402: ,comments DBMS_SQL.VARCHAR2_TABLE
403: ,attribute_category DBMS_SQL.VARCHAR2_TABLE
396: l_rowid DBMS_SQL.VARCHAR2_TABLE
397: ,receivable_application_id DBMS_SQL.NUMBER_TABLE
398: ,amount_applied DBMS_SQL.NUMBER_TABLE
399: ,payment_schedule_id DBMS_SQL.NUMBER_TABLE
400: ,applied_payment_schedule_id DBMS_SQL.NUMBER_TABLE
401: ,applied_customer_trx_id DBMS_SQL.NUMBER_TABLE
402: ,comments DBMS_SQL.VARCHAR2_TABLE
403: ,attribute_category DBMS_SQL.VARCHAR2_TABLE
404: ,attribute1 DBMS_SQL.VARCHAR2_TABLE
397: ,receivable_application_id DBMS_SQL.NUMBER_TABLE
398: ,amount_applied DBMS_SQL.NUMBER_TABLE
399: ,payment_schedule_id DBMS_SQL.NUMBER_TABLE
400: ,applied_payment_schedule_id DBMS_SQL.NUMBER_TABLE
401: ,applied_customer_trx_id DBMS_SQL.NUMBER_TABLE
402: ,comments DBMS_SQL.VARCHAR2_TABLE
403: ,attribute_category DBMS_SQL.VARCHAR2_TABLE
404: ,attribute1 DBMS_SQL.VARCHAR2_TABLE
405: ,attribute2 DBMS_SQL.VARCHAR2_TABLE
398: ,amount_applied DBMS_SQL.NUMBER_TABLE
399: ,payment_schedule_id DBMS_SQL.NUMBER_TABLE
400: ,applied_payment_schedule_id DBMS_SQL.NUMBER_TABLE
401: ,applied_customer_trx_id DBMS_SQL.NUMBER_TABLE
402: ,comments DBMS_SQL.VARCHAR2_TABLE
403: ,attribute_category DBMS_SQL.VARCHAR2_TABLE
404: ,attribute1 DBMS_SQL.VARCHAR2_TABLE
405: ,attribute2 DBMS_SQL.VARCHAR2_TABLE
406: ,attribute3 DBMS_SQL.VARCHAR2_TABLE
399: ,payment_schedule_id DBMS_SQL.NUMBER_TABLE
400: ,applied_payment_schedule_id DBMS_SQL.NUMBER_TABLE
401: ,applied_customer_trx_id DBMS_SQL.NUMBER_TABLE
402: ,comments DBMS_SQL.VARCHAR2_TABLE
403: ,attribute_category DBMS_SQL.VARCHAR2_TABLE
404: ,attribute1 DBMS_SQL.VARCHAR2_TABLE
405: ,attribute2 DBMS_SQL.VARCHAR2_TABLE
406: ,attribute3 DBMS_SQL.VARCHAR2_TABLE
407: ,attribute4 DBMS_SQL.VARCHAR2_TABLE
400: ,applied_payment_schedule_id DBMS_SQL.NUMBER_TABLE
401: ,applied_customer_trx_id DBMS_SQL.NUMBER_TABLE
402: ,comments DBMS_SQL.VARCHAR2_TABLE
403: ,attribute_category DBMS_SQL.VARCHAR2_TABLE
404: ,attribute1 DBMS_SQL.VARCHAR2_TABLE
405: ,attribute2 DBMS_SQL.VARCHAR2_TABLE
406: ,attribute3 DBMS_SQL.VARCHAR2_TABLE
407: ,attribute4 DBMS_SQL.VARCHAR2_TABLE
408: ,attribute5 DBMS_SQL.VARCHAR2_TABLE
401: ,applied_customer_trx_id DBMS_SQL.NUMBER_TABLE
402: ,comments DBMS_SQL.VARCHAR2_TABLE
403: ,attribute_category DBMS_SQL.VARCHAR2_TABLE
404: ,attribute1 DBMS_SQL.VARCHAR2_TABLE
405: ,attribute2 DBMS_SQL.VARCHAR2_TABLE
406: ,attribute3 DBMS_SQL.VARCHAR2_TABLE
407: ,attribute4 DBMS_SQL.VARCHAR2_TABLE
408: ,attribute5 DBMS_SQL.VARCHAR2_TABLE
409: ,attribute6 DBMS_SQL.VARCHAR2_TABLE
402: ,comments DBMS_SQL.VARCHAR2_TABLE
403: ,attribute_category DBMS_SQL.VARCHAR2_TABLE
404: ,attribute1 DBMS_SQL.VARCHAR2_TABLE
405: ,attribute2 DBMS_SQL.VARCHAR2_TABLE
406: ,attribute3 DBMS_SQL.VARCHAR2_TABLE
407: ,attribute4 DBMS_SQL.VARCHAR2_TABLE
408: ,attribute5 DBMS_SQL.VARCHAR2_TABLE
409: ,attribute6 DBMS_SQL.VARCHAR2_TABLE
410: ,attribute7 DBMS_SQL.VARCHAR2_TABLE
403: ,attribute_category DBMS_SQL.VARCHAR2_TABLE
404: ,attribute1 DBMS_SQL.VARCHAR2_TABLE
405: ,attribute2 DBMS_SQL.VARCHAR2_TABLE
406: ,attribute3 DBMS_SQL.VARCHAR2_TABLE
407: ,attribute4 DBMS_SQL.VARCHAR2_TABLE
408: ,attribute5 DBMS_SQL.VARCHAR2_TABLE
409: ,attribute6 DBMS_SQL.VARCHAR2_TABLE
410: ,attribute7 DBMS_SQL.VARCHAR2_TABLE
411: ,attribute8 DBMS_SQL.VARCHAR2_TABLE
404: ,attribute1 DBMS_SQL.VARCHAR2_TABLE
405: ,attribute2 DBMS_SQL.VARCHAR2_TABLE
406: ,attribute3 DBMS_SQL.VARCHAR2_TABLE
407: ,attribute4 DBMS_SQL.VARCHAR2_TABLE
408: ,attribute5 DBMS_SQL.VARCHAR2_TABLE
409: ,attribute6 DBMS_SQL.VARCHAR2_TABLE
410: ,attribute7 DBMS_SQL.VARCHAR2_TABLE
411: ,attribute8 DBMS_SQL.VARCHAR2_TABLE
412: ,attribute9 DBMS_SQL.VARCHAR2_TABLE
405: ,attribute2 DBMS_SQL.VARCHAR2_TABLE
406: ,attribute3 DBMS_SQL.VARCHAR2_TABLE
407: ,attribute4 DBMS_SQL.VARCHAR2_TABLE
408: ,attribute5 DBMS_SQL.VARCHAR2_TABLE
409: ,attribute6 DBMS_SQL.VARCHAR2_TABLE
410: ,attribute7 DBMS_SQL.VARCHAR2_TABLE
411: ,attribute8 DBMS_SQL.VARCHAR2_TABLE
412: ,attribute9 DBMS_SQL.VARCHAR2_TABLE
413: ,attribute10 DBMS_SQL.VARCHAR2_TABLE
406: ,attribute3 DBMS_SQL.VARCHAR2_TABLE
407: ,attribute4 DBMS_SQL.VARCHAR2_TABLE
408: ,attribute5 DBMS_SQL.VARCHAR2_TABLE
409: ,attribute6 DBMS_SQL.VARCHAR2_TABLE
410: ,attribute7 DBMS_SQL.VARCHAR2_TABLE
411: ,attribute8 DBMS_SQL.VARCHAR2_TABLE
412: ,attribute9 DBMS_SQL.VARCHAR2_TABLE
413: ,attribute10 DBMS_SQL.VARCHAR2_TABLE
414: ,attribute11 DBMS_SQL.VARCHAR2_TABLE
407: ,attribute4 DBMS_SQL.VARCHAR2_TABLE
408: ,attribute5 DBMS_SQL.VARCHAR2_TABLE
409: ,attribute6 DBMS_SQL.VARCHAR2_TABLE
410: ,attribute7 DBMS_SQL.VARCHAR2_TABLE
411: ,attribute8 DBMS_SQL.VARCHAR2_TABLE
412: ,attribute9 DBMS_SQL.VARCHAR2_TABLE
413: ,attribute10 DBMS_SQL.VARCHAR2_TABLE
414: ,attribute11 DBMS_SQL.VARCHAR2_TABLE
415: ,attribute12 DBMS_SQL.VARCHAR2_TABLE
408: ,attribute5 DBMS_SQL.VARCHAR2_TABLE
409: ,attribute6 DBMS_SQL.VARCHAR2_TABLE
410: ,attribute7 DBMS_SQL.VARCHAR2_TABLE
411: ,attribute8 DBMS_SQL.VARCHAR2_TABLE
412: ,attribute9 DBMS_SQL.VARCHAR2_TABLE
413: ,attribute10 DBMS_SQL.VARCHAR2_TABLE
414: ,attribute11 DBMS_SQL.VARCHAR2_TABLE
415: ,attribute12 DBMS_SQL.VARCHAR2_TABLE
416: ,attribute13 DBMS_SQL.VARCHAR2_TABLE
409: ,attribute6 DBMS_SQL.VARCHAR2_TABLE
410: ,attribute7 DBMS_SQL.VARCHAR2_TABLE
411: ,attribute8 DBMS_SQL.VARCHAR2_TABLE
412: ,attribute9 DBMS_SQL.VARCHAR2_TABLE
413: ,attribute10 DBMS_SQL.VARCHAR2_TABLE
414: ,attribute11 DBMS_SQL.VARCHAR2_TABLE
415: ,attribute12 DBMS_SQL.VARCHAR2_TABLE
416: ,attribute13 DBMS_SQL.VARCHAR2_TABLE
417: ,attribute14 DBMS_SQL.VARCHAR2_TABLE
410: ,attribute7 DBMS_SQL.VARCHAR2_TABLE
411: ,attribute8 DBMS_SQL.VARCHAR2_TABLE
412: ,attribute9 DBMS_SQL.VARCHAR2_TABLE
413: ,attribute10 DBMS_SQL.VARCHAR2_TABLE
414: ,attribute11 DBMS_SQL.VARCHAR2_TABLE
415: ,attribute12 DBMS_SQL.VARCHAR2_TABLE
416: ,attribute13 DBMS_SQL.VARCHAR2_TABLE
417: ,attribute14 DBMS_SQL.VARCHAR2_TABLE
418: ,attribute15 DBMS_SQL.VARCHAR2_TABLE
411: ,attribute8 DBMS_SQL.VARCHAR2_TABLE
412: ,attribute9 DBMS_SQL.VARCHAR2_TABLE
413: ,attribute10 DBMS_SQL.VARCHAR2_TABLE
414: ,attribute11 DBMS_SQL.VARCHAR2_TABLE
415: ,attribute12 DBMS_SQL.VARCHAR2_TABLE
416: ,attribute13 DBMS_SQL.VARCHAR2_TABLE
417: ,attribute14 DBMS_SQL.VARCHAR2_TABLE
418: ,attribute15 DBMS_SQL.VARCHAR2_TABLE
419: ,application_ref_num DBMS_SQL.VARCHAR2_TABLE
412: ,attribute9 DBMS_SQL.VARCHAR2_TABLE
413: ,attribute10 DBMS_SQL.VARCHAR2_TABLE
414: ,attribute11 DBMS_SQL.VARCHAR2_TABLE
415: ,attribute12 DBMS_SQL.VARCHAR2_TABLE
416: ,attribute13 DBMS_SQL.VARCHAR2_TABLE
417: ,attribute14 DBMS_SQL.VARCHAR2_TABLE
418: ,attribute15 DBMS_SQL.VARCHAR2_TABLE
419: ,application_ref_num DBMS_SQL.VARCHAR2_TABLE
420: ,secondary_application_ref_id DBMS_SQL.NUMBER_TABLE
413: ,attribute10 DBMS_SQL.VARCHAR2_TABLE
414: ,attribute11 DBMS_SQL.VARCHAR2_TABLE
415: ,attribute12 DBMS_SQL.VARCHAR2_TABLE
416: ,attribute13 DBMS_SQL.VARCHAR2_TABLE
417: ,attribute14 DBMS_SQL.VARCHAR2_TABLE
418: ,attribute15 DBMS_SQL.VARCHAR2_TABLE
419: ,application_ref_num DBMS_SQL.VARCHAR2_TABLE
420: ,secondary_application_ref_id DBMS_SQL.NUMBER_TABLE
421: ,application_ref_reason DBMS_SQL.VARCHAR2_TABLE
414: ,attribute11 DBMS_SQL.VARCHAR2_TABLE
415: ,attribute12 DBMS_SQL.VARCHAR2_TABLE
416: ,attribute13 DBMS_SQL.VARCHAR2_TABLE
417: ,attribute14 DBMS_SQL.VARCHAR2_TABLE
418: ,attribute15 DBMS_SQL.VARCHAR2_TABLE
419: ,application_ref_num DBMS_SQL.VARCHAR2_TABLE
420: ,secondary_application_ref_id DBMS_SQL.NUMBER_TABLE
421: ,application_ref_reason DBMS_SQL.VARCHAR2_TABLE
422: ,customer_reason DBMS_SQL.VARCHAR2_TABLE
415: ,attribute12 DBMS_SQL.VARCHAR2_TABLE
416: ,attribute13 DBMS_SQL.VARCHAR2_TABLE
417: ,attribute14 DBMS_SQL.VARCHAR2_TABLE
418: ,attribute15 DBMS_SQL.VARCHAR2_TABLE
419: ,application_ref_num DBMS_SQL.VARCHAR2_TABLE
420: ,secondary_application_ref_id DBMS_SQL.NUMBER_TABLE
421: ,application_ref_reason DBMS_SQL.VARCHAR2_TABLE
422: ,customer_reason DBMS_SQL.VARCHAR2_TABLE
423: ,customer_reference DBMS_SQL.VARCHAR2_TABLE
416: ,attribute13 DBMS_SQL.VARCHAR2_TABLE
417: ,attribute14 DBMS_SQL.VARCHAR2_TABLE
418: ,attribute15 DBMS_SQL.VARCHAR2_TABLE
419: ,application_ref_num DBMS_SQL.VARCHAR2_TABLE
420: ,secondary_application_ref_id DBMS_SQL.NUMBER_TABLE
421: ,application_ref_reason DBMS_SQL.VARCHAR2_TABLE
422: ,customer_reason DBMS_SQL.VARCHAR2_TABLE
423: ,customer_reference DBMS_SQL.VARCHAR2_TABLE
424: ,return_status DBMS_SQL.VARCHAR2_TABLE
417: ,attribute14 DBMS_SQL.VARCHAR2_TABLE
418: ,attribute15 DBMS_SQL.VARCHAR2_TABLE
419: ,application_ref_num DBMS_SQL.VARCHAR2_TABLE
420: ,secondary_application_ref_id DBMS_SQL.NUMBER_TABLE
421: ,application_ref_reason DBMS_SQL.VARCHAR2_TABLE
422: ,customer_reason DBMS_SQL.VARCHAR2_TABLE
423: ,customer_reference DBMS_SQL.VARCHAR2_TABLE
424: ,return_status DBMS_SQL.VARCHAR2_TABLE
425: ,msg_count DBMS_SQL.NUMBER_TABLE
418: ,attribute15 DBMS_SQL.VARCHAR2_TABLE
419: ,application_ref_num DBMS_SQL.VARCHAR2_TABLE
420: ,secondary_application_ref_id DBMS_SQL.NUMBER_TABLE
421: ,application_ref_reason DBMS_SQL.VARCHAR2_TABLE
422: ,customer_reason DBMS_SQL.VARCHAR2_TABLE
423: ,customer_reference DBMS_SQL.VARCHAR2_TABLE
424: ,return_status DBMS_SQL.VARCHAR2_TABLE
425: ,msg_count DBMS_SQL.NUMBER_TABLE
426: ,msg_data DBMS_SQL.VARCHAR2_TABLE
419: ,application_ref_num DBMS_SQL.VARCHAR2_TABLE
420: ,secondary_application_ref_id DBMS_SQL.NUMBER_TABLE
421: ,application_ref_reason DBMS_SQL.VARCHAR2_TABLE
422: ,customer_reason DBMS_SQL.VARCHAR2_TABLE
423: ,customer_reference DBMS_SQL.VARCHAR2_TABLE
424: ,return_status DBMS_SQL.VARCHAR2_TABLE
425: ,msg_count DBMS_SQL.NUMBER_TABLE
426: ,msg_data DBMS_SQL.VARCHAR2_TABLE
427: ,claim_reason_name DBMS_SQL.VARCHAR2_TABLE
420: ,secondary_application_ref_id DBMS_SQL.NUMBER_TABLE
421: ,application_ref_reason DBMS_SQL.VARCHAR2_TABLE
422: ,customer_reason DBMS_SQL.VARCHAR2_TABLE
423: ,customer_reference DBMS_SQL.VARCHAR2_TABLE
424: ,return_status DBMS_SQL.VARCHAR2_TABLE
425: ,msg_count DBMS_SQL.NUMBER_TABLE
426: ,msg_data DBMS_SQL.VARCHAR2_TABLE
427: ,claim_reason_name DBMS_SQL.VARCHAR2_TABLE
428: ,apply_date DBMS_SQL.DATE_TABLE --bug 5495310
421: ,application_ref_reason DBMS_SQL.VARCHAR2_TABLE
422: ,customer_reason DBMS_SQL.VARCHAR2_TABLE
423: ,customer_reference DBMS_SQL.VARCHAR2_TABLE
424: ,return_status DBMS_SQL.VARCHAR2_TABLE
425: ,msg_count DBMS_SQL.NUMBER_TABLE
426: ,msg_data DBMS_SQL.VARCHAR2_TABLE
427: ,claim_reason_name DBMS_SQL.VARCHAR2_TABLE
428: ,apply_date DBMS_SQL.DATE_TABLE --bug 5495310
429: );
422: ,customer_reason DBMS_SQL.VARCHAR2_TABLE
423: ,customer_reference DBMS_SQL.VARCHAR2_TABLE
424: ,return_status DBMS_SQL.VARCHAR2_TABLE
425: ,msg_count DBMS_SQL.NUMBER_TABLE
426: ,msg_data DBMS_SQL.VARCHAR2_TABLE
427: ,claim_reason_name DBMS_SQL.VARCHAR2_TABLE
428: ,apply_date DBMS_SQL.DATE_TABLE --bug 5495310
429: );
430: claim_tbl ra_rec_type;
423: ,customer_reference DBMS_SQL.VARCHAR2_TABLE
424: ,return_status DBMS_SQL.VARCHAR2_TABLE
425: ,msg_count DBMS_SQL.NUMBER_TABLE
426: ,msg_data DBMS_SQL.VARCHAR2_TABLE
427: ,claim_reason_name DBMS_SQL.VARCHAR2_TABLE
428: ,apply_date DBMS_SQL.DATE_TABLE --bug 5495310
429: );
430: claim_tbl ra_rec_type;
431: claim_tbl_null ra_rec_type;
424: ,return_status DBMS_SQL.VARCHAR2_TABLE
425: ,msg_count DBMS_SQL.NUMBER_TABLE
426: ,msg_data DBMS_SQL.VARCHAR2_TABLE
427: ,claim_reason_name DBMS_SQL.VARCHAR2_TABLE
428: ,apply_date DBMS_SQL.DATE_TABLE --bug 5495310
429: );
430: claim_tbl ra_rec_type;
431: claim_tbl_null ra_rec_type;
432:
430: claim_tbl ra_rec_type;
431: claim_tbl_null ra_rec_type;
432:
433: TYPE ra_trx_rec_type IS RECORD (
434: applied_payment_schedule_id DBMS_SQL.NUMBER_TABLE
435: );
436: ra_tbl ra_trx_rec_type;
437: ra_tbl_null ra_trx_rec_type;
438: