APPS.ARRX_BRS dependencies on DBMS_SQL

Line 406: v_CursorID_main := DBMS_SQL.OPEN_CURSOR;

402: /*------------------------------------------------------------------+
403: | Parse the main cursor |
404: +------------------------------------------------------------------*/
405: -- Open the cursor for dynamic processing.
406: v_CursorID_main := DBMS_SQL.OPEN_CURSOR;
407:
408: -- Parse the main query.
409: DBMS_SQL.PARSE(v_CursorID_main,
410: 'SELECT trx.customer_trx_id

Line 409: DBMS_SQL.PARSE(v_CursorID_main,

405: -- Open the cursor for dynamic processing.
406: v_CursorID_main := DBMS_SQL.OPEN_CURSOR;
407:
408: -- Parse the main query.
409: DBMS_SQL.PARSE(v_CursorID_main,
410: 'SELECT trx.customer_trx_id
411: ,trx.trx_number transaction_number
412: ,trx.doc_sequence_value document_number
413: ,fds.name document_sequence_name

Line 555: DBMS_SQL.native);

551: l_on_hold_where ||
552: 'AND trx.customer_trx_id = ps.customer_trx_id(+)
553: AND trx.batch_id = rab.batch_id(+)
554: AND rah.status <> ''INCOMPLETE''',
555: DBMS_SQL.native);
556:
557:
558:
559: /*------------------------------------------------------------------+

Line 566: DBMS_SQL.BIND_VARIABLE(v_CursorID_main, ':p_reporting_entity_id', p_reporting_entity_id);

562:
563: -- If the MO Reporting Get Predicate function returns a bind variable then
564: -- we need to bind it.
565: IF l_org_where_trx like '%:p_reporting_entity_id%' THEN
566: DBMS_SQL.BIND_VARIABLE(v_CursorID_main, ':p_reporting_entity_id', p_reporting_entity_id);
567: END IF;
568:
569: IF p_first_status IS NOT NULL THEN
570: DBMS_SQL.BIND_VARIABLE(v_CursorID_main, ':b_first_status', p_first_status);

Line 570: DBMS_SQL.BIND_VARIABLE(v_CursorID_main, ':b_first_status', p_first_status);

566: DBMS_SQL.BIND_VARIABLE(v_CursorID_main, ':p_reporting_entity_id', p_reporting_entity_id);
567: END IF;
568:
569: IF p_first_status IS NOT NULL THEN
570: DBMS_SQL.BIND_VARIABLE(v_CursorID_main, ':b_first_status', p_first_status);
571: IF p_second_status IS NOT NULL THEN
572: DBMS_SQL.BIND_VARIABLE(v_CursorID_main, ':b_second_status', p_second_status);
573: IF p_third_status IS NOT NULL THEN
574: DBMS_SQL.BIND_VARIABLE(v_CursorID_main, ':b_third_status', p_third_status);

Line 572: DBMS_SQL.BIND_VARIABLE(v_CursorID_main, ':b_second_status', p_second_status);

568:
569: IF p_first_status IS NOT NULL THEN
570: DBMS_SQL.BIND_VARIABLE(v_CursorID_main, ':b_first_status', p_first_status);
571: IF p_second_status IS NOT NULL THEN
572: DBMS_SQL.BIND_VARIABLE(v_CursorID_main, ':b_second_status', p_second_status);
573: IF p_third_status IS NOT NULL THEN
574: DBMS_SQL.BIND_VARIABLE(v_CursorID_main, ':b_third_status', p_third_status);
575: END IF;
576: END IF;

Line 574: DBMS_SQL.BIND_VARIABLE(v_CursorID_main, ':b_third_status', p_third_status);

570: DBMS_SQL.BIND_VARIABLE(v_CursorID_main, ':b_first_status', p_first_status);
571: IF p_second_status IS NOT NULL THEN
572: DBMS_SQL.BIND_VARIABLE(v_CursorID_main, ':b_second_status', p_second_status);
573: IF p_third_status IS NOT NULL THEN
574: DBMS_SQL.BIND_VARIABLE(v_CursorID_main, ':b_third_status', p_third_status);
575: END IF;
576: END IF;
577: END IF;
578:

Line 580: DBMS_SQL.BIND_VARIABLE(v_CursorID_main, ':b_excluded_status', p_excluded_status);

576: END IF;
577: END IF;
578:
579: IF p_excluded_status IS NOT NULL THEN
580: DBMS_SQL.BIND_VARIABLE(v_CursorID_main, ':b_excluded_status', p_excluded_status);
581: END IF;
582:
583: IF p_transaction_type IS NOT NULL THEN
584: DBMS_SQL.BIND_VARIABLE(v_CursorID_main, ':b_transaction_type', p_transaction_type);

Line 584: DBMS_SQL.BIND_VARIABLE(v_CursorID_main, ':b_transaction_type', p_transaction_type);

580: DBMS_SQL.BIND_VARIABLE(v_CursorID_main, ':b_excluded_status', p_excluded_status);
581: END IF;
582:
583: IF p_transaction_type IS NOT NULL THEN
584: DBMS_SQL.BIND_VARIABLE(v_CursorID_main, ':b_transaction_type', p_transaction_type);
585: END IF;
586:
587: IF p_maturity_date_from IS NOT NULL THEN
588: DBMS_SQL.BIND_VARIABLE(v_CursorID_main, ':b_maturity_date_from', p_maturity_date_from);

Line 588: DBMS_SQL.BIND_VARIABLE(v_CursorID_main, ':b_maturity_date_from', p_maturity_date_from);

584: DBMS_SQL.BIND_VARIABLE(v_CursorID_main, ':b_transaction_type', p_transaction_type);
585: END IF;
586:
587: IF p_maturity_date_from IS NOT NULL THEN
588: DBMS_SQL.BIND_VARIABLE(v_CursorID_main, ':b_maturity_date_from', p_maturity_date_from);
589: END IF;
590:
591: IF p_maturity_date_to IS NOT NULL THEN
592: DBMS_SQL.BIND_VARIABLE(v_CursorID_main, ':b_maturity_date_to', p_maturity_date_to);

Line 592: DBMS_SQL.BIND_VARIABLE(v_CursorID_main, ':b_maturity_date_to', p_maturity_date_to);

588: DBMS_SQL.BIND_VARIABLE(v_CursorID_main, ':b_maturity_date_from', p_maturity_date_from);
589: END IF;
590:
591: IF p_maturity_date_to IS NOT NULL THEN
592: DBMS_SQL.BIND_VARIABLE(v_CursorID_main, ':b_maturity_date_to', p_maturity_date_to);
593: END IF;
594:
595: IF p_drawee_name IS NOT NULL THEN
596: DBMS_SQL.BIND_VARIABLE(v_CursorID_main, ':b_drawee_name', p_drawee_name);

Line 596: DBMS_SQL.BIND_VARIABLE(v_CursorID_main, ':b_drawee_name', p_drawee_name);

592: DBMS_SQL.BIND_VARIABLE(v_CursorID_main, ':b_maturity_date_to', p_maturity_date_to);
593: END IF;
594:
595: IF p_drawee_name IS NOT NULL THEN
596: DBMS_SQL.BIND_VARIABLE(v_CursorID_main, ':b_drawee_name', p_drawee_name);
597: END IF;
598:
599: IF p_drawee_number_from IS NOT NULL THEN
600: DBMS_SQL.BIND_VARIABLE(v_CursorID_main, ':b_drawee_number_from', p_drawee_number_from);

Line 600: DBMS_SQL.BIND_VARIABLE(v_CursorID_main, ':b_drawee_number_from', p_drawee_number_from);

596: DBMS_SQL.BIND_VARIABLE(v_CursorID_main, ':b_drawee_name', p_drawee_name);
597: END IF;
598:
599: IF p_drawee_number_from IS NOT NULL THEN
600: DBMS_SQL.BIND_VARIABLE(v_CursorID_main, ':b_drawee_number_from', p_drawee_number_from);
601: END IF;
602:
603: IF p_drawee_number_to IS NOT NULL THEN
604: DBMS_SQL.BIND_VARIABLE(v_CursorID_main, ':b_drawee_number_to', p_drawee_number_to);

Line 604: DBMS_SQL.BIND_VARIABLE(v_CursorID_main, ':b_drawee_number_to', p_drawee_number_to);

600: DBMS_SQL.BIND_VARIABLE(v_CursorID_main, ':b_drawee_number_from', p_drawee_number_from);
601: END IF;
602:
603: IF p_drawee_number_to IS NOT NULL THEN
604: DBMS_SQL.BIND_VARIABLE(v_CursorID_main, ':b_drawee_number_to', p_drawee_number_to);
605: END IF;
606:
607: IF p_drawee_bank_name IS NOT NULL THEN
608: DBMS_SQL.BIND_VARIABLE(v_CursorID_main, ':b_drawee_bank_name', p_drawee_bank_name);

Line 608: DBMS_SQL.BIND_VARIABLE(v_CursorID_main, ':b_drawee_bank_name', p_drawee_bank_name);

604: DBMS_SQL.BIND_VARIABLE(v_CursorID_main, ':b_drawee_number_to', p_drawee_number_to);
605: END IF;
606:
607: IF p_drawee_bank_name IS NOT NULL THEN
608: DBMS_SQL.BIND_VARIABLE(v_CursorID_main, ':b_drawee_bank_name', p_drawee_bank_name);
609: END IF;
610:
611: IF p_transaction_issue_date_from IS NOT NULL THEN
612: DBMS_SQL.BIND_VARIABLE(v_CursorID_main, ':b_issue_date_from', p_transaction_issue_date_from);

Line 612: DBMS_SQL.BIND_VARIABLE(v_CursorID_main, ':b_issue_date_from', p_transaction_issue_date_from);

608: DBMS_SQL.BIND_VARIABLE(v_CursorID_main, ':b_drawee_bank_name', p_drawee_bank_name);
609: END IF;
610:
611: IF p_transaction_issue_date_from IS NOT NULL THEN
612: DBMS_SQL.BIND_VARIABLE(v_CursorID_main, ':b_issue_date_from', p_transaction_issue_date_from);
613: END IF;
614:
615: IF p_transaction_issue_date_to IS NOT NULL THEN
616: DBMS_SQL.BIND_VARIABLE(v_CursorID_main, ':b_issue_date_to', p_transaction_issue_date_to);

Line 616: DBMS_SQL.BIND_VARIABLE(v_CursorID_main, ':b_issue_date_to', p_transaction_issue_date_to);

612: DBMS_SQL.BIND_VARIABLE(v_CursorID_main, ':b_issue_date_from', p_transaction_issue_date_from);
613: END IF;
614:
615: IF p_transaction_issue_date_to IS NOT NULL THEN
616: DBMS_SQL.BIND_VARIABLE(v_CursorID_main, ':b_issue_date_to', p_transaction_issue_date_to);
617: END IF;
618:
619: IF p_on_hold IS NOT NULL THEN
620: DBMS_SQL.BIND_VARIABLE(v_CursorID_main, ':b_on_hold', p_on_hold);

Line 620: DBMS_SQL.BIND_VARIABLE(v_CursorID_main, ':b_on_hold', p_on_hold);

616: DBMS_SQL.BIND_VARIABLE(v_CursorID_main, ':b_issue_date_to', p_transaction_issue_date_to);
617: END IF;
618:
619: IF p_on_hold IS NOT NULL THEN
620: DBMS_SQL.BIND_VARIABLE(v_CursorID_main, ':b_on_hold', p_on_hold);
621: END IF;
622:
623:
624: /*------------------------------------------------------------------+

Line 628: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 1, v_customer_trx_id);

624: /*------------------------------------------------------------------+
625: | Define the output variables |
626: +------------------------------------------------------------------*/
627:
628: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 1, v_customer_trx_id);
629: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 2, v_transaction_number, 20);
630: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 3, v_document_number);
631: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 4, v_document_sequence_name, 30);
632: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 5, v_currency_code, 15);

Line 629: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 2, v_transaction_number, 20);

625: | Define the output variables |
626: +------------------------------------------------------------------*/
627:
628: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 1, v_customer_trx_id);
629: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 2, v_transaction_number, 20);
630: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 3, v_document_number);
631: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 4, v_document_sequence_name, 30);
632: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 5, v_currency_code, 15);
633: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 6, v_magnetic_format_code, 30);

Line 630: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 3, v_document_number);

626: +------------------------------------------------------------------*/
627:
628: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 1, v_customer_trx_id);
629: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 2, v_transaction_number, 20);
630: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 3, v_document_number);
631: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 4, v_document_sequence_name, 30);
632: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 5, v_currency_code, 15);
633: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 6, v_magnetic_format_code, 30);
634: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 7, v_original_entered_amount);

Line 631: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 4, v_document_sequence_name, 30);

627:
628: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 1, v_customer_trx_id);
629: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 2, v_transaction_number, 20);
630: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 3, v_document_number);
631: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 4, v_document_sequence_name, 30);
632: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 5, v_currency_code, 15);
633: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 6, v_magnetic_format_code, 30);
634: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 7, v_original_entered_amount);
635: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 8, v_open_entered_amount);

Line 632: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 5, v_currency_code, 15);

628: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 1, v_customer_trx_id);
629: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 2, v_transaction_number, 20);
630: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 3, v_document_number);
631: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 4, v_document_sequence_name, 30);
632: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 5, v_currency_code, 15);
633: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 6, v_magnetic_format_code, 30);
634: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 7, v_original_entered_amount);
635: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 8, v_open_entered_amount);
636: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 9, v_open_functional_amount);

Line 633: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 6, v_magnetic_format_code, 30);

629: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 2, v_transaction_number, 20);
630: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 3, v_document_number);
631: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 4, v_document_sequence_name, 30);
632: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 5, v_currency_code, 15);
633: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 6, v_magnetic_format_code, 30);
634: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 7, v_original_entered_amount);
635: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 8, v_open_entered_amount);
636: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 9, v_open_functional_amount);
637: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 10, v_drawee_name, 255);

Line 634: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 7, v_original_entered_amount);

630: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 3, v_document_number);
631: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 4, v_document_sequence_name, 30);
632: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 5, v_currency_code, 15);
633: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 6, v_magnetic_format_code, 30);
634: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 7, v_original_entered_amount);
635: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 8, v_open_entered_amount);
636: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 9, v_open_functional_amount);
637: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 10, v_drawee_name, 255);
638: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 11, v_drawee_number, 30);

Line 635: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 8, v_open_entered_amount);

631: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 4, v_document_sequence_name, 30);
632: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 5, v_currency_code, 15);
633: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 6, v_magnetic_format_code, 30);
634: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 7, v_original_entered_amount);
635: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 8, v_open_entered_amount);
636: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 9, v_open_functional_amount);
637: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 10, v_drawee_name, 255);
638: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 11, v_drawee_number, 30);
639: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 12, v_drawee_taxpayer_id, 20);

Line 636: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 9, v_open_functional_amount);

632: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 5, v_currency_code, 15);
633: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 6, v_magnetic_format_code, 30);
634: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 7, v_original_entered_amount);
635: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 8, v_open_entered_amount);
636: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 9, v_open_functional_amount);
637: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 10, v_drawee_name, 255);
638: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 11, v_drawee_number, 30);
639: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 12, v_drawee_taxpayer_id, 20);
640: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 13, v_drawee_vat_reg_number, 50);

Line 637: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 10, v_drawee_name, 255);

633: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 6, v_magnetic_format_code, 30);
634: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 7, v_original_entered_amount);
635: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 8, v_open_entered_amount);
636: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 9, v_open_functional_amount);
637: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 10, v_drawee_name, 255);
638: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 11, v_drawee_number, 30);
639: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 12, v_drawee_taxpayer_id, 20);
640: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 13, v_drawee_vat_reg_number, 50);
641: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 14, v_drawee_city, 60);

Line 638: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 11, v_drawee_number, 30);

634: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 7, v_original_entered_amount);
635: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 8, v_open_entered_amount);
636: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 9, v_open_functional_amount);
637: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 10, v_drawee_name, 255);
638: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 11, v_drawee_number, 30);
639: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 12, v_drawee_taxpayer_id, 20);
640: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 13, v_drawee_vat_reg_number, 50);
641: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 14, v_drawee_city, 60);
642: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 15, v_drawee_state, 60);

Line 639: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 12, v_drawee_taxpayer_id, 20);

635: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 8, v_open_entered_amount);
636: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 9, v_open_functional_amount);
637: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 10, v_drawee_name, 255);
638: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 11, v_drawee_number, 30);
639: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 12, v_drawee_taxpayer_id, 20);
640: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 13, v_drawee_vat_reg_number, 50);
641: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 14, v_drawee_city, 60);
642: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 15, v_drawee_state, 60);
643: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 16, v_drawee_country, 60);

Line 640: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 13, v_drawee_vat_reg_number, 50);

636: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 9, v_open_functional_amount);
637: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 10, v_drawee_name, 255);
638: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 11, v_drawee_number, 30);
639: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 12, v_drawee_taxpayer_id, 20);
640: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 13, v_drawee_vat_reg_number, 50);
641: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 14, v_drawee_city, 60);
642: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 15, v_drawee_state, 60);
643: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 16, v_drawee_country, 60);
644: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 17, v_drawee_postal_code, 60);

Line 641: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 14, v_drawee_city, 60);

637: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 10, v_drawee_name, 255);
638: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 11, v_drawee_number, 30);
639: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 12, v_drawee_taxpayer_id, 20);
640: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 13, v_drawee_vat_reg_number, 50);
641: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 14, v_drawee_city, 60);
642: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 15, v_drawee_state, 60);
643: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 16, v_drawee_country, 60);
644: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 17, v_drawee_postal_code, 60);
645: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 18, v_drawee_class, 80);

Line 642: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 15, v_drawee_state, 60);

638: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 11, v_drawee_number, 30);
639: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 12, v_drawee_taxpayer_id, 20);
640: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 13, v_drawee_vat_reg_number, 50);
641: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 14, v_drawee_city, 60);
642: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 15, v_drawee_state, 60);
643: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 16, v_drawee_country, 60);
644: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 17, v_drawee_postal_code, 60);
645: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 18, v_drawee_class, 80);
646: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 19, v_drawee_category, 80);

Line 643: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 16, v_drawee_country, 60);

639: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 12, v_drawee_taxpayer_id, 20);
640: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 13, v_drawee_vat_reg_number, 50);
641: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 14, v_drawee_city, 60);
642: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 15, v_drawee_state, 60);
643: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 16, v_drawee_country, 60);
644: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 17, v_drawee_postal_code, 60);
645: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 18, v_drawee_class, 80);
646: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 19, v_drawee_category, 80);
647: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 20, v_drawee_location, 40);

Line 644: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 17, v_drawee_postal_code, 60);

640: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 13, v_drawee_vat_reg_number, 50);
641: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 14, v_drawee_city, 60);
642: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 15, v_drawee_state, 60);
643: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 16, v_drawee_country, 60);
644: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 17, v_drawee_postal_code, 60);
645: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 18, v_drawee_class, 80);
646: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 19, v_drawee_category, 80);
647: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 20, v_drawee_location, 40);
648: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 21, v_issue_date);

Line 645: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 18, v_drawee_class, 80);

641: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 14, v_drawee_city, 60);
642: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 15, v_drawee_state, 60);
643: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 16, v_drawee_country, 60);
644: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 17, v_drawee_postal_code, 60);
645: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 18, v_drawee_class, 80);
646: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 19, v_drawee_category, 80);
647: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 20, v_drawee_location, 40);
648: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 21, v_issue_date);
649: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 22, v_maturity_date);

Line 646: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 19, v_drawee_category, 80);

642: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 15, v_drawee_state, 60);
643: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 16, v_drawee_country, 60);
644: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 17, v_drawee_postal_code, 60);
645: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 18, v_drawee_class, 80);
646: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 19, v_drawee_category, 80);
647: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 20, v_drawee_location, 40);
648: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 21, v_issue_date);
649: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 22, v_maturity_date);
650: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 23, v_issued_by_drawee, 1);

Line 647: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 20, v_drawee_location, 40);

643: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 16, v_drawee_country, 60);
644: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 17, v_drawee_postal_code, 60);
645: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 18, v_drawee_class, 80);
646: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 19, v_drawee_category, 80);
647: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 20, v_drawee_location, 40);
648: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 21, v_issue_date);
649: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 22, v_maturity_date);
650: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 23, v_issued_by_drawee, 1);
651: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 24, v_signed_by_drawee, 1);

Line 648: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 21, v_issue_date);

644: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 17, v_drawee_postal_code, 60);
645: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 18, v_drawee_class, 80);
646: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 19, v_drawee_category, 80);
647: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 20, v_drawee_location, 40);
648: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 21, v_issue_date);
649: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 22, v_maturity_date);
650: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 23, v_issued_by_drawee, 1);
651: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 24, v_signed_by_drawee, 1);
652: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 25, v_transaction_type, 20);

Line 649: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 22, v_maturity_date);

645: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 18, v_drawee_class, 80);
646: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 19, v_drawee_category, 80);
647: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 20, v_drawee_location, 40);
648: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 21, v_issue_date);
649: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 22, v_maturity_date);
650: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 23, v_issued_by_drawee, 1);
651: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 24, v_signed_by_drawee, 1);
652: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 25, v_transaction_type, 20);
653: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 26, v_remit_bank_name, 60);

Line 650: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 23, v_issued_by_drawee, 1);

646: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 19, v_drawee_category, 80);
647: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 20, v_drawee_location, 40);
648: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 21, v_issue_date);
649: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 22, v_maturity_date);
650: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 23, v_issued_by_drawee, 1);
651: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 24, v_signed_by_drawee, 1);
652: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 25, v_transaction_type, 20);
653: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 26, v_remit_bank_name, 60);
654: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 27, v_remit_bank_number, 30);

Line 651: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 24, v_signed_by_drawee, 1);

647: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 20, v_drawee_location, 40);
648: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 21, v_issue_date);
649: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 22, v_maturity_date);
650: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 23, v_issued_by_drawee, 1);
651: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 24, v_signed_by_drawee, 1);
652: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 25, v_transaction_type, 20);
653: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 26, v_remit_bank_name, 60);
654: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 27, v_remit_bank_number, 30);
655: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 28, v_remit_branch_name, 60);

Line 652: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 25, v_transaction_type, 20);

648: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 21, v_issue_date);
649: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 22, v_maturity_date);
650: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 23, v_issued_by_drawee, 1);
651: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 24, v_signed_by_drawee, 1);
652: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 25, v_transaction_type, 20);
653: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 26, v_remit_bank_name, 60);
654: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 27, v_remit_bank_number, 30);
655: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 28, v_remit_branch_name, 60);
656: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 29, v_remit_branch_number, 25);

Line 653: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 26, v_remit_bank_name, 60);

649: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 22, v_maturity_date);
650: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 23, v_issued_by_drawee, 1);
651: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 24, v_signed_by_drawee, 1);
652: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 25, v_transaction_type, 20);
653: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 26, v_remit_bank_name, 60);
654: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 27, v_remit_bank_number, 30);
655: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 28, v_remit_branch_name, 60);
656: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 29, v_remit_branch_number, 25);
657: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 30, v_remit_bank_acc_name, 80);

Line 654: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 27, v_remit_bank_number, 30);

650: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 23, v_issued_by_drawee, 1);
651: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 24, v_signed_by_drawee, 1);
652: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 25, v_transaction_type, 20);
653: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 26, v_remit_bank_name, 60);
654: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 27, v_remit_bank_number, 30);
655: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 28, v_remit_branch_name, 60);
656: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 29, v_remit_branch_number, 25);
657: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 30, v_remit_bank_acc_name, 80);
658: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 31, v_remit_bank_acc_number, 30);

Line 655: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 28, v_remit_branch_name, 60);

651: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 24, v_signed_by_drawee, 1);
652: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 25, v_transaction_type, 20);
653: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 26, v_remit_bank_name, 60);
654: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 27, v_remit_bank_number, 30);
655: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 28, v_remit_branch_name, 60);
656: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 29, v_remit_branch_number, 25);
657: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 30, v_remit_bank_acc_name, 80);
658: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 31, v_remit_bank_acc_number, 30);
659: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 32, v_remit_bank_acc_id);

Line 656: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 29, v_remit_branch_number, 25);

652: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 25, v_transaction_type, 20);
653: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 26, v_remit_bank_name, 60);
654: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 27, v_remit_bank_number, 30);
655: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 28, v_remit_branch_name, 60);
656: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 29, v_remit_branch_number, 25);
657: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 30, v_remit_bank_acc_name, 80);
658: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 31, v_remit_bank_acc_number, 30);
659: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 32, v_remit_bank_acc_id);
660: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 33, v_remit_branch_city, 25);

Line 657: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 30, v_remit_bank_acc_name, 80);

653: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 26, v_remit_bank_name, 60);
654: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 27, v_remit_bank_number, 30);
655: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 28, v_remit_branch_name, 60);
656: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 29, v_remit_branch_number, 25);
657: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 30, v_remit_bank_acc_name, 80);
658: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 31, v_remit_bank_acc_number, 30);
659: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 32, v_remit_bank_acc_id);
660: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 33, v_remit_branch_city, 25);
661: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 34, v_remit_branch_state, 25);

Line 658: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 31, v_remit_bank_acc_number, 30);

654: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 27, v_remit_bank_number, 30);
655: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 28, v_remit_branch_name, 60);
656: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 29, v_remit_branch_number, 25);
657: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 30, v_remit_bank_acc_name, 80);
658: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 31, v_remit_bank_acc_number, 30);
659: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 32, v_remit_bank_acc_id);
660: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 33, v_remit_branch_city, 25);
661: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 34, v_remit_branch_state, 25);
662: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 35, v_remit_branch_country, 25);

Line 659: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 32, v_remit_bank_acc_id);

655: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 28, v_remit_branch_name, 60);
656: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 29, v_remit_branch_number, 25);
657: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 30, v_remit_bank_acc_name, 80);
658: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 31, v_remit_bank_acc_number, 30);
659: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 32, v_remit_bank_acc_id);
660: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 33, v_remit_branch_city, 25);
661: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 34, v_remit_branch_state, 25);
662: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 35, v_remit_branch_country, 25);
663: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 36, v_remit_branch_postal_code, 20);

Line 660: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 33, v_remit_branch_city, 25);

656: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 29, v_remit_branch_number, 25);
657: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 30, v_remit_bank_acc_name, 80);
658: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 31, v_remit_bank_acc_number, 30);
659: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 32, v_remit_bank_acc_id);
660: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 33, v_remit_branch_city, 25);
661: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 34, v_remit_branch_state, 25);
662: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 35, v_remit_branch_country, 25);
663: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 36, v_remit_branch_postal_code, 20);
664: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 37, v_remit_branch_address1, 35);

Line 661: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 34, v_remit_branch_state, 25);

657: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 30, v_remit_bank_acc_name, 80);
658: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 31, v_remit_bank_acc_number, 30);
659: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 32, v_remit_bank_acc_id);
660: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 33, v_remit_branch_city, 25);
661: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 34, v_remit_branch_state, 25);
662: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 35, v_remit_branch_country, 25);
663: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 36, v_remit_branch_postal_code, 20);
664: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 37, v_remit_branch_address1, 35);
665: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 38, v_remit_branch_address2, 35);

Line 662: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 35, v_remit_branch_country, 25);

658: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 31, v_remit_bank_acc_number, 30);
659: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 32, v_remit_bank_acc_id);
660: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 33, v_remit_branch_city, 25);
661: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 34, v_remit_branch_state, 25);
662: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 35, v_remit_branch_country, 25);
663: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 36, v_remit_branch_postal_code, 20);
664: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 37, v_remit_branch_address1, 35);
665: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 38, v_remit_branch_address2, 35);
666: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 39, v_remit_branch_address3, 35);

Line 663: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 36, v_remit_branch_postal_code, 20);

659: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 32, v_remit_bank_acc_id);
660: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 33, v_remit_branch_city, 25);
661: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 34, v_remit_branch_state, 25);
662: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 35, v_remit_branch_country, 25);
663: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 36, v_remit_branch_postal_code, 20);
664: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 37, v_remit_branch_address1, 35);
665: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 38, v_remit_branch_address2, 35);
666: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 39, v_remit_branch_address3, 35);
667: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 40, v_remit_bank_allow_override, 1);

Line 664: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 37, v_remit_branch_address1, 35);

660: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 33, v_remit_branch_city, 25);
661: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 34, v_remit_branch_state, 25);
662: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 35, v_remit_branch_country, 25);
663: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 36, v_remit_branch_postal_code, 20);
664: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 37, v_remit_branch_address1, 35);
665: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 38, v_remit_branch_address2, 35);
666: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 39, v_remit_branch_address3, 35);
667: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 40, v_remit_bank_allow_override, 1);
668: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 41, v_remit_bank_acc_check_digits, 30);

Line 665: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 38, v_remit_branch_address2, 35);

661: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 34, v_remit_branch_state, 25);
662: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 35, v_remit_branch_country, 25);
663: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 36, v_remit_branch_postal_code, 20);
664: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 37, v_remit_branch_address1, 35);
665: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 38, v_remit_branch_address2, 35);
666: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 39, v_remit_branch_address3, 35);
667: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 40, v_remit_bank_allow_override, 1);
668: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 41, v_remit_bank_acc_check_digits, 30);
669: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 42, v_remit_bank_acc_curr, 15);

Line 666: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 39, v_remit_branch_address3, 35);

662: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 35, v_remit_branch_country, 25);
663: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 36, v_remit_branch_postal_code, 20);
664: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 37, v_remit_branch_address1, 35);
665: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 38, v_remit_branch_address2, 35);
666: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 39, v_remit_branch_address3, 35);
667: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 40, v_remit_bank_allow_override, 1);
668: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 41, v_remit_bank_acc_check_digits, 30);
669: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 42, v_remit_bank_acc_curr, 15);
670: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 43, v_drawee_bank_name, 60);

Line 667: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 40, v_remit_bank_allow_override, 1);

663: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 36, v_remit_branch_postal_code, 20);
664: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 37, v_remit_branch_address1, 35);
665: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 38, v_remit_branch_address2, 35);
666: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 39, v_remit_branch_address3, 35);
667: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 40, v_remit_bank_allow_override, 1);
668: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 41, v_remit_bank_acc_check_digits, 30);
669: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 42, v_remit_bank_acc_curr, 15);
670: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 43, v_drawee_bank_name, 60);
671: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 44, v_drawee_bank_number, 30);

Line 668: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 41, v_remit_bank_acc_check_digits, 30);

664: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 37, v_remit_branch_address1, 35);
665: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 38, v_remit_branch_address2, 35);
666: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 39, v_remit_branch_address3, 35);
667: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 40, v_remit_bank_allow_override, 1);
668: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 41, v_remit_bank_acc_check_digits, 30);
669: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 42, v_remit_bank_acc_curr, 15);
670: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 43, v_drawee_bank_name, 60);
671: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 44, v_drawee_bank_number, 30);
672: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 45, v_drawee_branch_name, 60);

Line 669: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 42, v_remit_bank_acc_curr, 15);

665: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 38, v_remit_branch_address2, 35);
666: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 39, v_remit_branch_address3, 35);
667: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 40, v_remit_bank_allow_override, 1);
668: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 41, v_remit_bank_acc_check_digits, 30);
669: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 42, v_remit_bank_acc_curr, 15);
670: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 43, v_drawee_bank_name, 60);
671: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 44, v_drawee_bank_number, 30);
672: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 45, v_drawee_branch_name, 60);
673: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 46, v_drawee_branch_number, 25);

Line 670: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 43, v_drawee_bank_name, 60);

666: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 39, v_remit_branch_address3, 35);
667: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 40, v_remit_bank_allow_override, 1);
668: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 41, v_remit_bank_acc_check_digits, 30);
669: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 42, v_remit_bank_acc_curr, 15);
670: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 43, v_drawee_bank_name, 60);
671: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 44, v_drawee_bank_number, 30);
672: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 45, v_drawee_branch_name, 60);
673: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 46, v_drawee_branch_number, 25);
674: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 47, v_drawee_bank_acc_name, 80);

Line 671: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 44, v_drawee_bank_number, 30);

667: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 40, v_remit_bank_allow_override, 1);
668: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 41, v_remit_bank_acc_check_digits, 30);
669: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 42, v_remit_bank_acc_curr, 15);
670: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 43, v_drawee_bank_name, 60);
671: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 44, v_drawee_bank_number, 30);
672: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 45, v_drawee_branch_name, 60);
673: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 46, v_drawee_branch_number, 25);
674: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 47, v_drawee_bank_acc_name, 80);
675: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 48, v_drawee_bank_acc_number, 30);

Line 672: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 45, v_drawee_branch_name, 60);

668: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 41, v_remit_bank_acc_check_digits, 30);
669: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 42, v_remit_bank_acc_curr, 15);
670: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 43, v_drawee_bank_name, 60);
671: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 44, v_drawee_bank_number, 30);
672: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 45, v_drawee_branch_name, 60);
673: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 46, v_drawee_branch_number, 25);
674: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 47, v_drawee_bank_acc_name, 80);
675: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 48, v_drawee_bank_acc_number, 30);
676: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 49, v_drawee_branch_city, 25);

Line 673: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 46, v_drawee_branch_number, 25);

669: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 42, v_remit_bank_acc_curr, 15);
670: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 43, v_drawee_bank_name, 60);
671: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 44, v_drawee_bank_number, 30);
672: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 45, v_drawee_branch_name, 60);
673: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 46, v_drawee_branch_number, 25);
674: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 47, v_drawee_bank_acc_name, 80);
675: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 48, v_drawee_bank_acc_number, 30);
676: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 49, v_drawee_branch_city, 25);
677: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 50, v_drawee_branch_state, 25);

Line 674: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 47, v_drawee_bank_acc_name, 80);

670: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 43, v_drawee_bank_name, 60);
671: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 44, v_drawee_bank_number, 30);
672: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 45, v_drawee_branch_name, 60);
673: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 46, v_drawee_branch_number, 25);
674: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 47, v_drawee_bank_acc_name, 80);
675: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 48, v_drawee_bank_acc_number, 30);
676: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 49, v_drawee_branch_city, 25);
677: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 50, v_drawee_branch_state, 25);
678: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 51, v_drawee_branch_country, 25);

Line 675: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 48, v_drawee_bank_acc_number, 30);

671: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 44, v_drawee_bank_number, 30);
672: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 45, v_drawee_branch_name, 60);
673: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 46, v_drawee_branch_number, 25);
674: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 47, v_drawee_bank_acc_name, 80);
675: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 48, v_drawee_bank_acc_number, 30);
676: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 49, v_drawee_branch_city, 25);
677: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 50, v_drawee_branch_state, 25);
678: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 51, v_drawee_branch_country, 25);
679: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 52, v_drawee_branch_postal_code, 20);

Line 676: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 49, v_drawee_branch_city, 25);

672: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 45, v_drawee_branch_name, 60);
673: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 46, v_drawee_branch_number, 25);
674: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 47, v_drawee_bank_acc_name, 80);
675: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 48, v_drawee_bank_acc_number, 30);
676: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 49, v_drawee_branch_city, 25);
677: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 50, v_drawee_branch_state, 25);
678: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 51, v_drawee_branch_country, 25);
679: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 52, v_drawee_branch_postal_code, 20);
680: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 53, v_drawee_branch_address1, 35);

Line 677: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 50, v_drawee_branch_state, 25);

673: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 46, v_drawee_branch_number, 25);
674: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 47, v_drawee_bank_acc_name, 80);
675: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 48, v_drawee_bank_acc_number, 30);
676: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 49, v_drawee_branch_city, 25);
677: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 50, v_drawee_branch_state, 25);
678: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 51, v_drawee_branch_country, 25);
679: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 52, v_drawee_branch_postal_code, 20);
680: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 53, v_drawee_branch_address1, 35);
681: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 54, v_drawee_branch_address2, 35);

Line 678: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 51, v_drawee_branch_country, 25);

674: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 47, v_drawee_bank_acc_name, 80);
675: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 48, v_drawee_bank_acc_number, 30);
676: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 49, v_drawee_branch_city, 25);
677: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 50, v_drawee_branch_state, 25);
678: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 51, v_drawee_branch_country, 25);
679: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 52, v_drawee_branch_postal_code, 20);
680: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 53, v_drawee_branch_address1, 35);
681: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 54, v_drawee_branch_address2, 35);
682: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 55, v_drawee_branch_address3, 35);

Line 679: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 52, v_drawee_branch_postal_code, 20);

675: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 48, v_drawee_bank_acc_number, 30);
676: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 49, v_drawee_branch_city, 25);
677: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 50, v_drawee_branch_state, 25);
678: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 51, v_drawee_branch_country, 25);
679: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 52, v_drawee_branch_postal_code, 20);
680: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 53, v_drawee_branch_address1, 35);
681: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 54, v_drawee_branch_address2, 35);
682: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 55, v_drawee_branch_address3, 35);
683: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 56, v_drawee_bank_acc_check_digits, 30);

Line 680: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 53, v_drawee_branch_address1, 35);

676: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 49, v_drawee_branch_city, 25);
677: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 50, v_drawee_branch_state, 25);
678: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 51, v_drawee_branch_country, 25);
679: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 52, v_drawee_branch_postal_code, 20);
680: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 53, v_drawee_branch_address1, 35);
681: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 54, v_drawee_branch_address2, 35);
682: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 55, v_drawee_branch_address3, 35);
683: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 56, v_drawee_bank_acc_check_digits, 30);
684: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 57, v_drawee_bank_acc_curr, 15);

Line 681: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 54, v_drawee_branch_address2, 35);

677: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 50, v_drawee_branch_state, 25);
678: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 51, v_drawee_branch_country, 25);
679: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 52, v_drawee_branch_postal_code, 20);
680: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 53, v_drawee_branch_address1, 35);
681: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 54, v_drawee_branch_address2, 35);
682: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 55, v_drawee_branch_address3, 35);
683: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 56, v_drawee_bank_acc_check_digits, 30);
684: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 57, v_drawee_bank_acc_curr, 15);
685: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 58, v_comments, 240);

Line 682: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 55, v_drawee_branch_address3, 35);

678: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 51, v_drawee_branch_country, 25);
679: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 52, v_drawee_branch_postal_code, 20);
680: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 53, v_drawee_branch_address1, 35);
681: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 54, v_drawee_branch_address2, 35);
682: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 55, v_drawee_branch_address3, 35);
683: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 56, v_drawee_bank_acc_check_digits, 30);
684: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 57, v_drawee_bank_acc_curr, 15);
685: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 58, v_comments, 240);
686: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 59, v_days_late);

Line 683: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 56, v_drawee_bank_acc_check_digits, 30);

679: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 52, v_drawee_branch_postal_code, 20);
680: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 53, v_drawee_branch_address1, 35);
681: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 54, v_drawee_branch_address2, 35);
682: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 55, v_drawee_branch_address3, 35);
683: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 56, v_drawee_bank_acc_check_digits, 30);
684: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 57, v_drawee_bank_acc_curr, 15);
685: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 58, v_comments, 240);
686: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 59, v_days_late);
687: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 60, v_last_printed_date);

Line 684: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 57, v_drawee_bank_acc_curr, 15);

680: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 53, v_drawee_branch_address1, 35);
681: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 54, v_drawee_branch_address2, 35);
682: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 55, v_drawee_branch_address3, 35);
683: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 56, v_drawee_bank_acc_check_digits, 30);
684: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 57, v_drawee_bank_acc_curr, 15);
685: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 58, v_comments, 240);
686: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 59, v_days_late);
687: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 60, v_last_printed_date);
688: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 61, v_drawee_address1, 240);

Line 685: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 58, v_comments, 240);

681: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 54, v_drawee_branch_address2, 35);
682: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 55, v_drawee_branch_address3, 35);
683: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 56, v_drawee_bank_acc_check_digits, 30);
684: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 57, v_drawee_bank_acc_curr, 15);
685: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 58, v_comments, 240);
686: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 59, v_days_late);
687: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 60, v_last_printed_date);
688: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 61, v_drawee_address1, 240);
689: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 62, v_drawee_address2, 240);

Line 686: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 59, v_days_late);

682: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 55, v_drawee_branch_address3, 35);
683: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 56, v_drawee_bank_acc_check_digits, 30);
684: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 57, v_drawee_bank_acc_curr, 15);
685: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 58, v_comments, 240);
686: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 59, v_days_late);
687: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 60, v_last_printed_date);
688: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 61, v_drawee_address1, 240);
689: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 62, v_drawee_address2, 240);
690: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 63, v_drawee_address3, 240);

Line 687: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 60, v_last_printed_date);

683: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 56, v_drawee_bank_acc_check_digits, 30);
684: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 57, v_drawee_bank_acc_curr, 15);
685: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 58, v_comments, 240);
686: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 59, v_days_late);
687: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 60, v_last_printed_date);
688: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 61, v_drawee_address1, 240);
689: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 62, v_drawee_address2, 240);
690: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 63, v_drawee_address3, 240);
691: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 64, v_drawee_contact, 100);

Line 688: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 61, v_drawee_address1, 240);

684: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 57, v_drawee_bank_acc_curr, 15);
685: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 58, v_comments, 240);
686: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 59, v_days_late);
687: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 60, v_last_printed_date);
688: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 61, v_drawee_address1, 240);
689: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 62, v_drawee_address2, 240);
690: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 63, v_drawee_address3, 240);
691: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 64, v_drawee_contact, 100);
692: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 65, v_special_instructions, 240);

Line 689: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 62, v_drawee_address2, 240);

685: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 58, v_comments, 240);
686: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 59, v_days_late);
687: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 60, v_last_printed_date);
688: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 61, v_drawee_address1, 240);
689: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 62, v_drawee_address2, 240);
690: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 63, v_drawee_address3, 240);
691: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 64, v_drawee_contact, 100);
692: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 65, v_special_instructions, 240);
693: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 66, v_status_code, 30);

Line 690: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 63, v_drawee_address3, 240);

686: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 59, v_days_late);
687: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 60, v_last_printed_date);
688: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 61, v_drawee_address1, 240);
689: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 62, v_drawee_address2, 240);
690: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 63, v_drawee_address3, 240);
691: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 64, v_drawee_contact, 100);
692: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 65, v_special_instructions, 240);
693: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 66, v_status_code, 30);
694: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 67, v_creation_batch_name, 50);

Line 691: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 64, v_drawee_contact, 100);

687: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 60, v_last_printed_date);
688: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 61, v_drawee_address1, 240);
689: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 62, v_drawee_address2, 240);
690: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 63, v_drawee_address3, 240);
691: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 64, v_drawee_contact, 100);
692: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 65, v_special_instructions, 240);
693: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 66, v_status_code, 30);
694: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 67, v_creation_batch_name, 50);
695: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 68, v_transaction_batch_source, 50);

Line 692: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 65, v_special_instructions, 240);

688: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 61, v_drawee_address1, 240);
689: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 62, v_drawee_address2, 240);
690: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 63, v_drawee_address3, 240);
691: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 64, v_drawee_contact, 100);
692: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 65, v_special_instructions, 240);
693: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 66, v_status_code, 30);
694: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 67, v_creation_batch_name, 50);
695: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 68, v_transaction_batch_source, 50);
696: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 69, v_ps_exchange_rate);

Line 693: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 66, v_status_code, 30);

689: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 62, v_drawee_address2, 240);
690: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 63, v_drawee_address3, 240);
691: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 64, v_drawee_contact, 100);
692: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 65, v_special_instructions, 240);
693: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 66, v_status_code, 30);
694: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 67, v_creation_batch_name, 50);
695: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 68, v_transaction_batch_source, 50);
696: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 69, v_ps_exchange_rate);
697:

Line 694: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 67, v_creation_batch_name, 50);

690: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 63, v_drawee_address3, 240);
691: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 64, v_drawee_contact, 100);
692: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 65, v_special_instructions, 240);
693: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 66, v_status_code, 30);
694: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 67, v_creation_batch_name, 50);
695: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 68, v_transaction_batch_source, 50);
696: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 69, v_ps_exchange_rate);
697:
698:

Line 695: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 68, v_transaction_batch_source, 50);

691: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 64, v_drawee_contact, 100);
692: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 65, v_special_instructions, 240);
693: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 66, v_status_code, 30);
694: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 67, v_creation_batch_name, 50);
695: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 68, v_transaction_batch_source, 50);
696: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 69, v_ps_exchange_rate);
697:
698:
699: -- Execute the statement. We're not concerned about the return

Line 696: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 69, v_ps_exchange_rate);

692: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 65, v_special_instructions, 240);
693: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 66, v_status_code, 30);
694: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 67, v_creation_batch_name, 50);
695: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 68, v_transaction_batch_source, 50);
696: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 69, v_ps_exchange_rate);
697:
698:
699: -- Execute the statement. We're not concerned about the return
700: -- value, but we do need to declare a variable for it.

Line 701: v_Dummy_main := DBMS_SQL.EXECUTE(v_CursorID_main);

697:
698:
699: -- Execute the statement. We're not concerned about the return
700: -- value, but we do need to declare a variable for it.
701: v_Dummy_main := DBMS_SQL.EXECUTE(v_CursorID_main);
702:
703: -- This is the fetch loop.
704: LOOP
705:

Line 708: IF DBMS_SQL.FETCH_ROWS(v_CursorID_main) = 0 THEN

704: LOOP
705:
706: -- Fetch the rows into the buffer, and also check for the exit
707: -- condition from the loop.
708: IF DBMS_SQL.FETCH_ROWS(v_CursorID_main) = 0 THEN
709: EXIT;
710: END IF;
711:
712: -- Retrieve the rows from the buffer into PL/SQL variables.

Line 713: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 1, v_customer_trx_id);

709: EXIT;
710: END IF;
711:
712: -- Retrieve the rows from the buffer into PL/SQL variables.
713: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 1, v_customer_trx_id);
714: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 2, v_transaction_number);
715: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 3, v_document_number);
716: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 4, v_document_sequence_name);
717: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 5, v_currency_code);

Line 714: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 2, v_transaction_number);

710: END IF;
711:
712: -- Retrieve the rows from the buffer into PL/SQL variables.
713: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 1, v_customer_trx_id);
714: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 2, v_transaction_number);
715: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 3, v_document_number);
716: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 4, v_document_sequence_name);
717: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 5, v_currency_code);
718: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 6, v_magnetic_format_code);

Line 715: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 3, v_document_number);

711:
712: -- Retrieve the rows from the buffer into PL/SQL variables.
713: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 1, v_customer_trx_id);
714: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 2, v_transaction_number);
715: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 3, v_document_number);
716: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 4, v_document_sequence_name);
717: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 5, v_currency_code);
718: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 6, v_magnetic_format_code);
719: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 7, v_original_entered_amount);

Line 716: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 4, v_document_sequence_name);

712: -- Retrieve the rows from the buffer into PL/SQL variables.
713: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 1, v_customer_trx_id);
714: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 2, v_transaction_number);
715: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 3, v_document_number);
716: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 4, v_document_sequence_name);
717: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 5, v_currency_code);
718: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 6, v_magnetic_format_code);
719: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 7, v_original_entered_amount);
720: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 8, v_open_entered_amount);

Line 717: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 5, v_currency_code);

713: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 1, v_customer_trx_id);
714: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 2, v_transaction_number);
715: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 3, v_document_number);
716: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 4, v_document_sequence_name);
717: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 5, v_currency_code);
718: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 6, v_magnetic_format_code);
719: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 7, v_original_entered_amount);
720: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 8, v_open_entered_amount);
721: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 9, v_open_functional_amount);

Line 718: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 6, v_magnetic_format_code);

714: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 2, v_transaction_number);
715: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 3, v_document_number);
716: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 4, v_document_sequence_name);
717: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 5, v_currency_code);
718: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 6, v_magnetic_format_code);
719: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 7, v_original_entered_amount);
720: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 8, v_open_entered_amount);
721: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 9, v_open_functional_amount);
722: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 10, v_drawee_name);

Line 719: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 7, v_original_entered_amount);

715: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 3, v_document_number);
716: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 4, v_document_sequence_name);
717: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 5, v_currency_code);
718: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 6, v_magnetic_format_code);
719: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 7, v_original_entered_amount);
720: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 8, v_open_entered_amount);
721: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 9, v_open_functional_amount);
722: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 10, v_drawee_name);
723: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 11, v_drawee_number);

Line 720: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 8, v_open_entered_amount);

716: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 4, v_document_sequence_name);
717: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 5, v_currency_code);
718: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 6, v_magnetic_format_code);
719: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 7, v_original_entered_amount);
720: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 8, v_open_entered_amount);
721: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 9, v_open_functional_amount);
722: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 10, v_drawee_name);
723: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 11, v_drawee_number);
724: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 12, v_drawee_taxpayer_id);

Line 721: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 9, v_open_functional_amount);

717: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 5, v_currency_code);
718: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 6, v_magnetic_format_code);
719: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 7, v_original_entered_amount);
720: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 8, v_open_entered_amount);
721: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 9, v_open_functional_amount);
722: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 10, v_drawee_name);
723: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 11, v_drawee_number);
724: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 12, v_drawee_taxpayer_id);
725: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 13, v_drawee_vat_reg_number);

Line 722: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 10, v_drawee_name);

718: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 6, v_magnetic_format_code);
719: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 7, v_original_entered_amount);
720: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 8, v_open_entered_amount);
721: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 9, v_open_functional_amount);
722: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 10, v_drawee_name);
723: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 11, v_drawee_number);
724: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 12, v_drawee_taxpayer_id);
725: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 13, v_drawee_vat_reg_number);
726: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 14, v_drawee_city);

Line 723: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 11, v_drawee_number);

719: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 7, v_original_entered_amount);
720: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 8, v_open_entered_amount);
721: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 9, v_open_functional_amount);
722: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 10, v_drawee_name);
723: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 11, v_drawee_number);
724: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 12, v_drawee_taxpayer_id);
725: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 13, v_drawee_vat_reg_number);
726: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 14, v_drawee_city);
727: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 15, v_drawee_state);

Line 724: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 12, v_drawee_taxpayer_id);

720: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 8, v_open_entered_amount);
721: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 9, v_open_functional_amount);
722: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 10, v_drawee_name);
723: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 11, v_drawee_number);
724: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 12, v_drawee_taxpayer_id);
725: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 13, v_drawee_vat_reg_number);
726: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 14, v_drawee_city);
727: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 15, v_drawee_state);
728: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 16, v_drawee_country);

Line 725: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 13, v_drawee_vat_reg_number);

721: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 9, v_open_functional_amount);
722: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 10, v_drawee_name);
723: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 11, v_drawee_number);
724: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 12, v_drawee_taxpayer_id);
725: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 13, v_drawee_vat_reg_number);
726: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 14, v_drawee_city);
727: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 15, v_drawee_state);
728: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 16, v_drawee_country);
729: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 17, v_drawee_postal_code);

Line 726: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 14, v_drawee_city);

722: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 10, v_drawee_name);
723: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 11, v_drawee_number);
724: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 12, v_drawee_taxpayer_id);
725: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 13, v_drawee_vat_reg_number);
726: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 14, v_drawee_city);
727: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 15, v_drawee_state);
728: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 16, v_drawee_country);
729: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 17, v_drawee_postal_code);
730: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 18, v_drawee_class);

Line 727: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 15, v_drawee_state);

723: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 11, v_drawee_number);
724: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 12, v_drawee_taxpayer_id);
725: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 13, v_drawee_vat_reg_number);
726: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 14, v_drawee_city);
727: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 15, v_drawee_state);
728: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 16, v_drawee_country);
729: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 17, v_drawee_postal_code);
730: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 18, v_drawee_class);
731: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 19, v_drawee_category);

Line 728: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 16, v_drawee_country);

724: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 12, v_drawee_taxpayer_id);
725: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 13, v_drawee_vat_reg_number);
726: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 14, v_drawee_city);
727: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 15, v_drawee_state);
728: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 16, v_drawee_country);
729: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 17, v_drawee_postal_code);
730: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 18, v_drawee_class);
731: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 19, v_drawee_category);
732: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 20, v_drawee_location);

Line 729: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 17, v_drawee_postal_code);

725: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 13, v_drawee_vat_reg_number);
726: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 14, v_drawee_city);
727: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 15, v_drawee_state);
728: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 16, v_drawee_country);
729: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 17, v_drawee_postal_code);
730: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 18, v_drawee_class);
731: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 19, v_drawee_category);
732: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 20, v_drawee_location);
733: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 21, v_issue_date);

Line 730: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 18, v_drawee_class);

726: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 14, v_drawee_city);
727: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 15, v_drawee_state);
728: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 16, v_drawee_country);
729: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 17, v_drawee_postal_code);
730: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 18, v_drawee_class);
731: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 19, v_drawee_category);
732: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 20, v_drawee_location);
733: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 21, v_issue_date);
734: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 22, v_maturity_date);

Line 731: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 19, v_drawee_category);

727: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 15, v_drawee_state);
728: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 16, v_drawee_country);
729: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 17, v_drawee_postal_code);
730: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 18, v_drawee_class);
731: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 19, v_drawee_category);
732: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 20, v_drawee_location);
733: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 21, v_issue_date);
734: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 22, v_maturity_date);
735: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 23, v_issued_by_drawee);

Line 732: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 20, v_drawee_location);

728: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 16, v_drawee_country);
729: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 17, v_drawee_postal_code);
730: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 18, v_drawee_class);
731: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 19, v_drawee_category);
732: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 20, v_drawee_location);
733: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 21, v_issue_date);
734: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 22, v_maturity_date);
735: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 23, v_issued_by_drawee);
736: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 24, v_signed_by_drawee);

Line 733: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 21, v_issue_date);

729: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 17, v_drawee_postal_code);
730: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 18, v_drawee_class);
731: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 19, v_drawee_category);
732: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 20, v_drawee_location);
733: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 21, v_issue_date);
734: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 22, v_maturity_date);
735: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 23, v_issued_by_drawee);
736: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 24, v_signed_by_drawee);
737: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 25, v_transaction_type);

Line 734: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 22, v_maturity_date);

730: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 18, v_drawee_class);
731: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 19, v_drawee_category);
732: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 20, v_drawee_location);
733: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 21, v_issue_date);
734: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 22, v_maturity_date);
735: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 23, v_issued_by_drawee);
736: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 24, v_signed_by_drawee);
737: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 25, v_transaction_type);
738: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 26, v_remit_bank_name);

Line 735: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 23, v_issued_by_drawee);

731: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 19, v_drawee_category);
732: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 20, v_drawee_location);
733: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 21, v_issue_date);
734: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 22, v_maturity_date);
735: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 23, v_issued_by_drawee);
736: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 24, v_signed_by_drawee);
737: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 25, v_transaction_type);
738: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 26, v_remit_bank_name);
739: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 27, v_remit_bank_number);

Line 736: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 24, v_signed_by_drawee);

732: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 20, v_drawee_location);
733: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 21, v_issue_date);
734: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 22, v_maturity_date);
735: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 23, v_issued_by_drawee);
736: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 24, v_signed_by_drawee);
737: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 25, v_transaction_type);
738: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 26, v_remit_bank_name);
739: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 27, v_remit_bank_number);
740: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 28, v_remit_branch_name);

Line 737: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 25, v_transaction_type);

733: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 21, v_issue_date);
734: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 22, v_maturity_date);
735: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 23, v_issued_by_drawee);
736: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 24, v_signed_by_drawee);
737: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 25, v_transaction_type);
738: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 26, v_remit_bank_name);
739: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 27, v_remit_bank_number);
740: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 28, v_remit_branch_name);
741: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 29, v_remit_branch_number);

Line 738: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 26, v_remit_bank_name);

734: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 22, v_maturity_date);
735: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 23, v_issued_by_drawee);
736: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 24, v_signed_by_drawee);
737: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 25, v_transaction_type);
738: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 26, v_remit_bank_name);
739: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 27, v_remit_bank_number);
740: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 28, v_remit_branch_name);
741: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 29, v_remit_branch_number);
742: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 30, v_remit_bank_acc_name);

Line 739: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 27, v_remit_bank_number);

735: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 23, v_issued_by_drawee);
736: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 24, v_signed_by_drawee);
737: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 25, v_transaction_type);
738: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 26, v_remit_bank_name);
739: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 27, v_remit_bank_number);
740: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 28, v_remit_branch_name);
741: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 29, v_remit_branch_number);
742: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 30, v_remit_bank_acc_name);
743: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 31, v_remit_bank_acc_number);

Line 740: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 28, v_remit_branch_name);

736: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 24, v_signed_by_drawee);
737: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 25, v_transaction_type);
738: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 26, v_remit_bank_name);
739: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 27, v_remit_bank_number);
740: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 28, v_remit_branch_name);
741: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 29, v_remit_branch_number);
742: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 30, v_remit_bank_acc_name);
743: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 31, v_remit_bank_acc_number);
744: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 32, v_remit_bank_acc_id);

Line 741: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 29, v_remit_branch_number);

737: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 25, v_transaction_type);
738: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 26, v_remit_bank_name);
739: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 27, v_remit_bank_number);
740: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 28, v_remit_branch_name);
741: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 29, v_remit_branch_number);
742: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 30, v_remit_bank_acc_name);
743: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 31, v_remit_bank_acc_number);
744: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 32, v_remit_bank_acc_id);
745: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 33, v_remit_branch_city);

Line 742: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 30, v_remit_bank_acc_name);

738: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 26, v_remit_bank_name);
739: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 27, v_remit_bank_number);
740: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 28, v_remit_branch_name);
741: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 29, v_remit_branch_number);
742: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 30, v_remit_bank_acc_name);
743: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 31, v_remit_bank_acc_number);
744: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 32, v_remit_bank_acc_id);
745: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 33, v_remit_branch_city);
746: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 34, v_remit_branch_state);

Line 743: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 31, v_remit_bank_acc_number);

739: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 27, v_remit_bank_number);
740: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 28, v_remit_branch_name);
741: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 29, v_remit_branch_number);
742: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 30, v_remit_bank_acc_name);
743: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 31, v_remit_bank_acc_number);
744: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 32, v_remit_bank_acc_id);
745: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 33, v_remit_branch_city);
746: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 34, v_remit_branch_state);
747: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 35, v_remit_branch_country);

Line 744: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 32, v_remit_bank_acc_id);

740: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 28, v_remit_branch_name);
741: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 29, v_remit_branch_number);
742: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 30, v_remit_bank_acc_name);
743: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 31, v_remit_bank_acc_number);
744: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 32, v_remit_bank_acc_id);
745: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 33, v_remit_branch_city);
746: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 34, v_remit_branch_state);
747: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 35, v_remit_branch_country);
748: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 36, v_remit_branch_postal_code);

Line 745: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 33, v_remit_branch_city);

741: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 29, v_remit_branch_number);
742: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 30, v_remit_bank_acc_name);
743: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 31, v_remit_bank_acc_number);
744: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 32, v_remit_bank_acc_id);
745: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 33, v_remit_branch_city);
746: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 34, v_remit_branch_state);
747: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 35, v_remit_branch_country);
748: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 36, v_remit_branch_postal_code);
749: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 37, v_remit_branch_address1);

Line 746: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 34, v_remit_branch_state);

742: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 30, v_remit_bank_acc_name);
743: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 31, v_remit_bank_acc_number);
744: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 32, v_remit_bank_acc_id);
745: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 33, v_remit_branch_city);
746: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 34, v_remit_branch_state);
747: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 35, v_remit_branch_country);
748: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 36, v_remit_branch_postal_code);
749: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 37, v_remit_branch_address1);
750: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 38, v_remit_branch_address2);

Line 747: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 35, v_remit_branch_country);

743: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 31, v_remit_bank_acc_number);
744: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 32, v_remit_bank_acc_id);
745: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 33, v_remit_branch_city);
746: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 34, v_remit_branch_state);
747: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 35, v_remit_branch_country);
748: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 36, v_remit_branch_postal_code);
749: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 37, v_remit_branch_address1);
750: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 38, v_remit_branch_address2);
751: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 39, v_remit_branch_address3);

Line 748: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 36, v_remit_branch_postal_code);

744: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 32, v_remit_bank_acc_id);
745: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 33, v_remit_branch_city);
746: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 34, v_remit_branch_state);
747: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 35, v_remit_branch_country);
748: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 36, v_remit_branch_postal_code);
749: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 37, v_remit_branch_address1);
750: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 38, v_remit_branch_address2);
751: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 39, v_remit_branch_address3);
752: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 40, v_remit_bank_allow_override);

Line 749: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 37, v_remit_branch_address1);

745: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 33, v_remit_branch_city);
746: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 34, v_remit_branch_state);
747: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 35, v_remit_branch_country);
748: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 36, v_remit_branch_postal_code);
749: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 37, v_remit_branch_address1);
750: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 38, v_remit_branch_address2);
751: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 39, v_remit_branch_address3);
752: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 40, v_remit_bank_allow_override);
753: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 41, v_remit_bank_acc_check_digits);

Line 750: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 38, v_remit_branch_address2);

746: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 34, v_remit_branch_state);
747: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 35, v_remit_branch_country);
748: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 36, v_remit_branch_postal_code);
749: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 37, v_remit_branch_address1);
750: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 38, v_remit_branch_address2);
751: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 39, v_remit_branch_address3);
752: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 40, v_remit_bank_allow_override);
753: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 41, v_remit_bank_acc_check_digits);
754: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 42, v_remit_bank_acc_curr);

Line 751: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 39, v_remit_branch_address3);

747: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 35, v_remit_branch_country);
748: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 36, v_remit_branch_postal_code);
749: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 37, v_remit_branch_address1);
750: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 38, v_remit_branch_address2);
751: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 39, v_remit_branch_address3);
752: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 40, v_remit_bank_allow_override);
753: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 41, v_remit_bank_acc_check_digits);
754: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 42, v_remit_bank_acc_curr);
755: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 43, v_drawee_bank_name);

Line 752: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 40, v_remit_bank_allow_override);

748: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 36, v_remit_branch_postal_code);
749: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 37, v_remit_branch_address1);
750: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 38, v_remit_branch_address2);
751: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 39, v_remit_branch_address3);
752: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 40, v_remit_bank_allow_override);
753: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 41, v_remit_bank_acc_check_digits);
754: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 42, v_remit_bank_acc_curr);
755: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 43, v_drawee_bank_name);
756: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 44, v_drawee_bank_number);

Line 753: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 41, v_remit_bank_acc_check_digits);

749: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 37, v_remit_branch_address1);
750: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 38, v_remit_branch_address2);
751: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 39, v_remit_branch_address3);
752: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 40, v_remit_bank_allow_override);
753: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 41, v_remit_bank_acc_check_digits);
754: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 42, v_remit_bank_acc_curr);
755: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 43, v_drawee_bank_name);
756: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 44, v_drawee_bank_number);
757: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 45, v_drawee_branch_name);

Line 754: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 42, v_remit_bank_acc_curr);

750: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 38, v_remit_branch_address2);
751: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 39, v_remit_branch_address3);
752: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 40, v_remit_bank_allow_override);
753: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 41, v_remit_bank_acc_check_digits);
754: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 42, v_remit_bank_acc_curr);
755: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 43, v_drawee_bank_name);
756: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 44, v_drawee_bank_number);
757: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 45, v_drawee_branch_name);
758: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 46, v_drawee_branch_number);

Line 755: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 43, v_drawee_bank_name);

751: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 39, v_remit_branch_address3);
752: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 40, v_remit_bank_allow_override);
753: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 41, v_remit_bank_acc_check_digits);
754: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 42, v_remit_bank_acc_curr);
755: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 43, v_drawee_bank_name);
756: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 44, v_drawee_bank_number);
757: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 45, v_drawee_branch_name);
758: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 46, v_drawee_branch_number);
759: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 47, v_drawee_bank_acc_name);

Line 756: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 44, v_drawee_bank_number);

752: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 40, v_remit_bank_allow_override);
753: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 41, v_remit_bank_acc_check_digits);
754: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 42, v_remit_bank_acc_curr);
755: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 43, v_drawee_bank_name);
756: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 44, v_drawee_bank_number);
757: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 45, v_drawee_branch_name);
758: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 46, v_drawee_branch_number);
759: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 47, v_drawee_bank_acc_name);
760: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 48, v_drawee_bank_acc_number);

Line 757: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 45, v_drawee_branch_name);

753: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 41, v_remit_bank_acc_check_digits);
754: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 42, v_remit_bank_acc_curr);
755: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 43, v_drawee_bank_name);
756: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 44, v_drawee_bank_number);
757: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 45, v_drawee_branch_name);
758: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 46, v_drawee_branch_number);
759: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 47, v_drawee_bank_acc_name);
760: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 48, v_drawee_bank_acc_number);
761: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 49, v_drawee_branch_city);

Line 758: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 46, v_drawee_branch_number);

754: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 42, v_remit_bank_acc_curr);
755: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 43, v_drawee_bank_name);
756: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 44, v_drawee_bank_number);
757: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 45, v_drawee_branch_name);
758: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 46, v_drawee_branch_number);
759: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 47, v_drawee_bank_acc_name);
760: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 48, v_drawee_bank_acc_number);
761: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 49, v_drawee_branch_city);
762: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 50, v_drawee_branch_state);

Line 759: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 47, v_drawee_bank_acc_name);

755: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 43, v_drawee_bank_name);
756: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 44, v_drawee_bank_number);
757: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 45, v_drawee_branch_name);
758: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 46, v_drawee_branch_number);
759: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 47, v_drawee_bank_acc_name);
760: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 48, v_drawee_bank_acc_number);
761: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 49, v_drawee_branch_city);
762: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 50, v_drawee_branch_state);
763: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 51, v_drawee_branch_country);

Line 760: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 48, v_drawee_bank_acc_number);

756: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 44, v_drawee_bank_number);
757: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 45, v_drawee_branch_name);
758: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 46, v_drawee_branch_number);
759: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 47, v_drawee_bank_acc_name);
760: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 48, v_drawee_bank_acc_number);
761: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 49, v_drawee_branch_city);
762: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 50, v_drawee_branch_state);
763: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 51, v_drawee_branch_country);
764: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 52, v_drawee_branch_postal_code);

Line 761: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 49, v_drawee_branch_city);

757: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 45, v_drawee_branch_name);
758: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 46, v_drawee_branch_number);
759: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 47, v_drawee_bank_acc_name);
760: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 48, v_drawee_bank_acc_number);
761: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 49, v_drawee_branch_city);
762: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 50, v_drawee_branch_state);
763: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 51, v_drawee_branch_country);
764: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 52, v_drawee_branch_postal_code);
765: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 53, v_drawee_branch_address1);

Line 762: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 50, v_drawee_branch_state);

758: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 46, v_drawee_branch_number);
759: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 47, v_drawee_bank_acc_name);
760: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 48, v_drawee_bank_acc_number);
761: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 49, v_drawee_branch_city);
762: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 50, v_drawee_branch_state);
763: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 51, v_drawee_branch_country);
764: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 52, v_drawee_branch_postal_code);
765: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 53, v_drawee_branch_address1);
766: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 54, v_drawee_branch_address2);

Line 763: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 51, v_drawee_branch_country);

759: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 47, v_drawee_bank_acc_name);
760: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 48, v_drawee_bank_acc_number);
761: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 49, v_drawee_branch_city);
762: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 50, v_drawee_branch_state);
763: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 51, v_drawee_branch_country);
764: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 52, v_drawee_branch_postal_code);
765: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 53, v_drawee_branch_address1);
766: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 54, v_drawee_branch_address2);
767: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 55, v_drawee_branch_address3);

Line 764: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 52, v_drawee_branch_postal_code);

760: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 48, v_drawee_bank_acc_number);
761: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 49, v_drawee_branch_city);
762: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 50, v_drawee_branch_state);
763: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 51, v_drawee_branch_country);
764: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 52, v_drawee_branch_postal_code);
765: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 53, v_drawee_branch_address1);
766: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 54, v_drawee_branch_address2);
767: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 55, v_drawee_branch_address3);
768: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 56, v_drawee_bank_acc_check_digits);

Line 765: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 53, v_drawee_branch_address1);

761: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 49, v_drawee_branch_city);
762: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 50, v_drawee_branch_state);
763: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 51, v_drawee_branch_country);
764: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 52, v_drawee_branch_postal_code);
765: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 53, v_drawee_branch_address1);
766: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 54, v_drawee_branch_address2);
767: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 55, v_drawee_branch_address3);
768: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 56, v_drawee_bank_acc_check_digits);
769: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 57, v_drawee_bank_acc_curr);

Line 766: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 54, v_drawee_branch_address2);

762: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 50, v_drawee_branch_state);
763: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 51, v_drawee_branch_country);
764: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 52, v_drawee_branch_postal_code);
765: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 53, v_drawee_branch_address1);
766: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 54, v_drawee_branch_address2);
767: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 55, v_drawee_branch_address3);
768: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 56, v_drawee_bank_acc_check_digits);
769: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 57, v_drawee_bank_acc_curr);
770: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 58, v_comments);

Line 767: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 55, v_drawee_branch_address3);

763: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 51, v_drawee_branch_country);
764: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 52, v_drawee_branch_postal_code);
765: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 53, v_drawee_branch_address1);
766: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 54, v_drawee_branch_address2);
767: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 55, v_drawee_branch_address3);
768: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 56, v_drawee_bank_acc_check_digits);
769: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 57, v_drawee_bank_acc_curr);
770: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 58, v_comments);
771: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 59, v_days_late);

Line 768: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 56, v_drawee_bank_acc_check_digits);

764: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 52, v_drawee_branch_postal_code);
765: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 53, v_drawee_branch_address1);
766: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 54, v_drawee_branch_address2);
767: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 55, v_drawee_branch_address3);
768: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 56, v_drawee_bank_acc_check_digits);
769: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 57, v_drawee_bank_acc_curr);
770: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 58, v_comments);
771: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 59, v_days_late);
772: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 60, v_last_printed_date);

Line 769: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 57, v_drawee_bank_acc_curr);

765: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 53, v_drawee_branch_address1);
766: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 54, v_drawee_branch_address2);
767: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 55, v_drawee_branch_address3);
768: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 56, v_drawee_bank_acc_check_digits);
769: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 57, v_drawee_bank_acc_curr);
770: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 58, v_comments);
771: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 59, v_days_late);
772: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 60, v_last_printed_date);
773: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 61, v_drawee_address1);

Line 770: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 58, v_comments);

766: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 54, v_drawee_branch_address2);
767: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 55, v_drawee_branch_address3);
768: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 56, v_drawee_bank_acc_check_digits);
769: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 57, v_drawee_bank_acc_curr);
770: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 58, v_comments);
771: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 59, v_days_late);
772: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 60, v_last_printed_date);
773: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 61, v_drawee_address1);
774: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 62, v_drawee_address2);

Line 771: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 59, v_days_late);

767: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 55, v_drawee_branch_address3);
768: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 56, v_drawee_bank_acc_check_digits);
769: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 57, v_drawee_bank_acc_curr);
770: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 58, v_comments);
771: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 59, v_days_late);
772: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 60, v_last_printed_date);
773: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 61, v_drawee_address1);
774: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 62, v_drawee_address2);
775: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 63, v_drawee_address3);

Line 772: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 60, v_last_printed_date);

768: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 56, v_drawee_bank_acc_check_digits);
769: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 57, v_drawee_bank_acc_curr);
770: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 58, v_comments);
771: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 59, v_days_late);
772: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 60, v_last_printed_date);
773: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 61, v_drawee_address1);
774: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 62, v_drawee_address2);
775: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 63, v_drawee_address3);
776: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 64, v_drawee_contact);

Line 773: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 61, v_drawee_address1);

769: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 57, v_drawee_bank_acc_curr);
770: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 58, v_comments);
771: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 59, v_days_late);
772: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 60, v_last_printed_date);
773: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 61, v_drawee_address1);
774: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 62, v_drawee_address2);
775: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 63, v_drawee_address3);
776: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 64, v_drawee_contact);
777: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 65, v_special_instructions);

Line 774: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 62, v_drawee_address2);

770: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 58, v_comments);
771: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 59, v_days_late);
772: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 60, v_last_printed_date);
773: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 61, v_drawee_address1);
774: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 62, v_drawee_address2);
775: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 63, v_drawee_address3);
776: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 64, v_drawee_contact);
777: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 65, v_special_instructions);
778: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 66, v_status_code);

Line 775: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 63, v_drawee_address3);

771: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 59, v_days_late);
772: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 60, v_last_printed_date);
773: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 61, v_drawee_address1);
774: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 62, v_drawee_address2);
775: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 63, v_drawee_address3);
776: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 64, v_drawee_contact);
777: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 65, v_special_instructions);
778: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 66, v_status_code);
779: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 67, v_creation_batch_name);

Line 776: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 64, v_drawee_contact);

772: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 60, v_last_printed_date);
773: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 61, v_drawee_address1);
774: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 62, v_drawee_address2);
775: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 63, v_drawee_address3);
776: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 64, v_drawee_contact);
777: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 65, v_special_instructions);
778: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 66, v_status_code);
779: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 67, v_creation_batch_name);
780: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 68, v_transaction_batch_source);

Line 777: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 65, v_special_instructions);

773: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 61, v_drawee_address1);
774: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 62, v_drawee_address2);
775: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 63, v_drawee_address3);
776: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 64, v_drawee_contact);
777: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 65, v_special_instructions);
778: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 66, v_status_code);
779: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 67, v_creation_batch_name);
780: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 68, v_transaction_batch_source);
781: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 69, v_ps_exchange_rate);

Line 778: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 66, v_status_code);

774: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 62, v_drawee_address2);
775: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 63, v_drawee_address3);
776: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 64, v_drawee_contact);
777: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 65, v_special_instructions);
778: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 66, v_status_code);
779: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 67, v_creation_batch_name);
780: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 68, v_transaction_batch_source);
781: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 69, v_ps_exchange_rate);
782:

Line 779: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 67, v_creation_batch_name);

775: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 63, v_drawee_address3);
776: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 64, v_drawee_contact);
777: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 65, v_special_instructions);
778: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 66, v_status_code);
779: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 67, v_creation_batch_name);
780: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 68, v_transaction_batch_source);
781: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 69, v_ps_exchange_rate);
782:
783: -- Calculate correct Orignal Entered Funcional Amount

Line 780: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 68, v_transaction_batch_source);

776: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 64, v_drawee_contact);
777: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 65, v_special_instructions);
778: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 66, v_status_code);
779: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 67, v_creation_batch_name);
780: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 68, v_transaction_batch_source);
781: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 69, v_ps_exchange_rate);
782:
783: -- Calculate correct Orignal Entered Funcional Amount
784: --Bug 5041260 replaced the call arp_util.calc_acctd_amount with

Line 781: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 69, v_ps_exchange_rate);

777: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 65, v_special_instructions);
778: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 66, v_status_code);
779: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 67, v_creation_batch_name);
780: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 68, v_transaction_batch_source);
781: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 69, v_ps_exchange_rate);
782:
783: -- Calculate correct Orignal Entered Funcional Amount
784: --Bug 5041260 replaced the call arp_util.calc_acctd_amount with
785: -- arp_util.calc_accounted_amount.

Line 844: v_CursorID_rbatch := DBMS_SQL.OPEN_CURSOR;

840: v_risk_elimination_days := null;
841: l_populate := 'Y';
842:
843: -- Open the As of Date cursor for dynamic processing.
844: v_CursorID_rbatch := DBMS_SQL.OPEN_CURSOR;
845:
846: -- Parse the As of Date Cursor
847: DBMS_SQL.PARSE(v_CursorID_rbatch, l_remit_batch, DBMS_SQL.native);
848:

Line 847: DBMS_SQL.PARSE(v_CursorID_rbatch, l_remit_batch, DBMS_SQL.native);

843: -- Open the As of Date cursor for dynamic processing.
844: v_CursorID_rbatch := DBMS_SQL.OPEN_CURSOR;
845:
846: -- Parse the As of Date Cursor
847: DBMS_SQL.PARSE(v_CursorID_rbatch, l_remit_batch, DBMS_SQL.native);
848:
849: -- Bind variables for cursor.
850: DBMS_SQL.BIND_VARIABLE(v_CursorID_rbatch, ':b_status_date', p_status_as_of_date);
851: DBMS_SQL.BIND_VARIABLE(v_CursorID_rbatch, ':b_trx_id', v_customer_trx_id);

Line 850: DBMS_SQL.BIND_VARIABLE(v_CursorID_rbatch, ':b_status_date', p_status_as_of_date);

846: -- Parse the As of Date Cursor
847: DBMS_SQL.PARSE(v_CursorID_rbatch, l_remit_batch, DBMS_SQL.native);
848:
849: -- Bind variables for cursor.
850: DBMS_SQL.BIND_VARIABLE(v_CursorID_rbatch, ':b_status_date', p_status_as_of_date);
851: DBMS_SQL.BIND_VARIABLE(v_CursorID_rbatch, ':b_trx_id', v_customer_trx_id);
852:
853: -- If the MO Reporting Get Predicate function returns a bind variable then
854: -- we need to bind it.

Line 851: DBMS_SQL.BIND_VARIABLE(v_CursorID_rbatch, ':b_trx_id', v_customer_trx_id);

847: DBMS_SQL.PARSE(v_CursorID_rbatch, l_remit_batch, DBMS_SQL.native);
848:
849: -- Bind variables for cursor.
850: DBMS_SQL.BIND_VARIABLE(v_CursorID_rbatch, ':b_status_date', p_status_as_of_date);
851: DBMS_SQL.BIND_VARIABLE(v_CursorID_rbatch, ':b_trx_id', v_customer_trx_id);
852:
853: -- If the MO Reporting Get Predicate function returns a bind variable then
854: -- we need to bind it.
855: IF l_org_where_trx like '%:p_reporting_entity_id%' THEN

Line 856: DBMS_SQL.BIND_VARIABLE(v_CursorID_rbatch, ':p_reporting_entity_id', p_reporting_entity_id);

852:
853: -- If the MO Reporting Get Predicate function returns a bind variable then
854: -- we need to bind it.
855: IF l_org_where_trx like '%:p_reporting_entity_id%' THEN
856: DBMS_SQL.BIND_VARIABLE(v_CursorID_rbatch, ':p_reporting_entity_id', p_reporting_entity_id);
857: END IF;
858:
859: -- Define the output variables.
860: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 1, v_remittance_batch_name, 20);

Line 860: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 1, v_remittance_batch_name, 20);

856: DBMS_SQL.BIND_VARIABLE(v_CursorID_rbatch, ':p_reporting_entity_id', p_reporting_entity_id);
857: END IF;
858:
859: -- Define the output variables.
860: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 1, v_remittance_batch_name, 20);
861: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 2, v_remittance_method, 30);
862: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 3, v_with_recourse, 1);
863: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 4, v_remittance_payment_method, 30);
864: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 5, v_remit_bank_name, 60);

Line 861: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 2, v_remittance_method, 30);

857: END IF;
858:
859: -- Define the output variables.
860: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 1, v_remittance_batch_name, 20);
861: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 2, v_remittance_method, 30);
862: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 3, v_with_recourse, 1);
863: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 4, v_remittance_payment_method, 30);
864: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 5, v_remit_bank_name, 60);
865: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 6, v_remit_bank_number, 30);

Line 862: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 3, v_with_recourse, 1);

858:
859: -- Define the output variables.
860: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 1, v_remittance_batch_name, 20);
861: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 2, v_remittance_method, 30);
862: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 3, v_with_recourse, 1);
863: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 4, v_remittance_payment_method, 30);
864: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 5, v_remit_bank_name, 60);
865: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 6, v_remit_bank_number, 30);
866: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 7, v_remit_branch_name, 60);

Line 863: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 4, v_remittance_payment_method, 30);

859: -- Define the output variables.
860: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 1, v_remittance_batch_name, 20);
861: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 2, v_remittance_method, 30);
862: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 3, v_with_recourse, 1);
863: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 4, v_remittance_payment_method, 30);
864: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 5, v_remit_bank_name, 60);
865: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 6, v_remit_bank_number, 30);
866: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 7, v_remit_branch_name, 60);
867: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 8, v_remit_branch_number, 25);

Line 864: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 5, v_remit_bank_name, 60);

860: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 1, v_remittance_batch_name, 20);
861: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 2, v_remittance_method, 30);
862: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 3, v_with_recourse, 1);
863: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 4, v_remittance_payment_method, 30);
864: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 5, v_remit_bank_name, 60);
865: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 6, v_remit_bank_number, 30);
866: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 7, v_remit_branch_name, 60);
867: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 8, v_remit_branch_number, 25);
868: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 9, v_remit_bank_acc_name, 80);

Line 865: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 6, v_remit_bank_number, 30);

861: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 2, v_remittance_method, 30);
862: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 3, v_with_recourse, 1);
863: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 4, v_remittance_payment_method, 30);
864: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 5, v_remit_bank_name, 60);
865: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 6, v_remit_bank_number, 30);
866: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 7, v_remit_branch_name, 60);
867: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 8, v_remit_branch_number, 25);
868: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 9, v_remit_bank_acc_name, 80);
869: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 10, v_remit_bank_acc_number, 30);

Line 866: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 7, v_remit_branch_name, 60);

862: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 3, v_with_recourse, 1);
863: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 4, v_remittance_payment_method, 30);
864: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 5, v_remit_bank_name, 60);
865: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 6, v_remit_bank_number, 30);
866: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 7, v_remit_branch_name, 60);
867: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 8, v_remit_branch_number, 25);
868: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 9, v_remit_bank_acc_name, 80);
869: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 10, v_remit_bank_acc_number, 30);
870: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 11, v_remit_bank_acc_id);

Line 867: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 8, v_remit_branch_number, 25);

863: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 4, v_remittance_payment_method, 30);
864: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 5, v_remit_bank_name, 60);
865: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 6, v_remit_bank_number, 30);
866: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 7, v_remit_branch_name, 60);
867: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 8, v_remit_branch_number, 25);
868: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 9, v_remit_bank_acc_name, 80);
869: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 10, v_remit_bank_acc_number, 30);
870: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 11, v_remit_bank_acc_id);
871: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 12, v_remit_branch_city, 25);

Line 868: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 9, v_remit_bank_acc_name, 80);

864: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 5, v_remit_bank_name, 60);
865: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 6, v_remit_bank_number, 30);
866: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 7, v_remit_branch_name, 60);
867: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 8, v_remit_branch_number, 25);
868: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 9, v_remit_bank_acc_name, 80);
869: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 10, v_remit_bank_acc_number, 30);
870: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 11, v_remit_bank_acc_id);
871: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 12, v_remit_branch_city, 25);
872: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 13, v_remit_branch_state, 25);

Line 869: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 10, v_remit_bank_acc_number, 30);

865: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 6, v_remit_bank_number, 30);
866: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 7, v_remit_branch_name, 60);
867: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 8, v_remit_branch_number, 25);
868: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 9, v_remit_bank_acc_name, 80);
869: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 10, v_remit_bank_acc_number, 30);
870: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 11, v_remit_bank_acc_id);
871: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 12, v_remit_branch_city, 25);
872: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 13, v_remit_branch_state, 25);
873: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 14, v_remit_branch_country, 25);

Line 870: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 11, v_remit_bank_acc_id);

866: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 7, v_remit_branch_name, 60);
867: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 8, v_remit_branch_number, 25);
868: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 9, v_remit_bank_acc_name, 80);
869: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 10, v_remit_bank_acc_number, 30);
870: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 11, v_remit_bank_acc_id);
871: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 12, v_remit_branch_city, 25);
872: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 13, v_remit_branch_state, 25);
873: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 14, v_remit_branch_country, 25);
874: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 15, v_remit_branch_postal_code, 20);

Line 871: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 12, v_remit_branch_city, 25);

867: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 8, v_remit_branch_number, 25);
868: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 9, v_remit_bank_acc_name, 80);
869: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 10, v_remit_bank_acc_number, 30);
870: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 11, v_remit_bank_acc_id);
871: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 12, v_remit_branch_city, 25);
872: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 13, v_remit_branch_state, 25);
873: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 14, v_remit_branch_country, 25);
874: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 15, v_remit_branch_postal_code, 20);
875: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 16, v_remit_branch_address1, 35);

Line 872: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 13, v_remit_branch_state, 25);

868: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 9, v_remit_bank_acc_name, 80);
869: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 10, v_remit_bank_acc_number, 30);
870: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 11, v_remit_bank_acc_id);
871: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 12, v_remit_branch_city, 25);
872: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 13, v_remit_branch_state, 25);
873: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 14, v_remit_branch_country, 25);
874: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 15, v_remit_branch_postal_code, 20);
875: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 16, v_remit_branch_address1, 35);
876: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 17, v_remit_branch_address2, 35);

Line 873: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 14, v_remit_branch_country, 25);

869: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 10, v_remit_bank_acc_number, 30);
870: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 11, v_remit_bank_acc_id);
871: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 12, v_remit_branch_city, 25);
872: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 13, v_remit_branch_state, 25);
873: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 14, v_remit_branch_country, 25);
874: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 15, v_remit_branch_postal_code, 20);
875: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 16, v_remit_branch_address1, 35);
876: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 17, v_remit_branch_address2, 35);
877: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 18, v_remit_branch_address3, 35);

Line 874: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 15, v_remit_branch_postal_code, 20);

870: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 11, v_remit_bank_acc_id);
871: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 12, v_remit_branch_city, 25);
872: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 13, v_remit_branch_state, 25);
873: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 14, v_remit_branch_country, 25);
874: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 15, v_remit_branch_postal_code, 20);
875: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 16, v_remit_branch_address1, 35);
876: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 17, v_remit_branch_address2, 35);
877: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 18, v_remit_branch_address3, 35);
878: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 19, v_remit_bank_acc_check_digits, 30);

Line 875: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 16, v_remit_branch_address1, 35);

871: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 12, v_remit_branch_city, 25);
872: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 13, v_remit_branch_state, 25);
873: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 14, v_remit_branch_country, 25);
874: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 15, v_remit_branch_postal_code, 20);
875: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 16, v_remit_branch_address1, 35);
876: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 17, v_remit_branch_address2, 35);
877: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 18, v_remit_branch_address3, 35);
878: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 19, v_remit_bank_acc_check_digits, 30);
879: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 20, v_remit_bank_acc_curr, 15);

Line 876: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 17, v_remit_branch_address2, 35);

872: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 13, v_remit_branch_state, 25);
873: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 14, v_remit_branch_country, 25);
874: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 15, v_remit_branch_postal_code, 20);
875: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 16, v_remit_branch_address1, 35);
876: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 17, v_remit_branch_address2, 35);
877: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 18, v_remit_branch_address3, 35);
878: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 19, v_remit_bank_acc_check_digits, 30);
879: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 20, v_remit_bank_acc_curr, 15);
880: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 21, v_risk_elimination_days);

Line 877: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 18, v_remit_branch_address3, 35);

873: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 14, v_remit_branch_country, 25);
874: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 15, v_remit_branch_postal_code, 20);
875: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 16, v_remit_branch_address1, 35);
876: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 17, v_remit_branch_address2, 35);
877: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 18, v_remit_branch_address3, 35);
878: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 19, v_remit_bank_acc_check_digits, 30);
879: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 20, v_remit_bank_acc_curr, 15);
880: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 21, v_risk_elimination_days);
881:

Line 878: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 19, v_remit_bank_acc_check_digits, 30);

874: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 15, v_remit_branch_postal_code, 20);
875: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 16, v_remit_branch_address1, 35);
876: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 17, v_remit_branch_address2, 35);
877: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 18, v_remit_branch_address3, 35);
878: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 19, v_remit_bank_acc_check_digits, 30);
879: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 20, v_remit_bank_acc_curr, 15);
880: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 21, v_risk_elimination_days);
881:
882: -- Execute the statement.

Line 879: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 20, v_remit_bank_acc_curr, 15);

875: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 16, v_remit_branch_address1, 35);
876: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 17, v_remit_branch_address2, 35);
877: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 18, v_remit_branch_address3, 35);
878: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 19, v_remit_bank_acc_check_digits, 30);
879: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 20, v_remit_bank_acc_curr, 15);
880: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 21, v_risk_elimination_days);
881:
882: -- Execute the statement.
883: v_Dummy_rbatch := DBMS_SQL.EXECUTE(v_CursorID_rbatch);

Line 880: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 21, v_risk_elimination_days);

876: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 17, v_remit_branch_address2, 35);
877: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 18, v_remit_branch_address3, 35);
878: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 19, v_remit_bank_acc_check_digits, 30);
879: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 20, v_remit_bank_acc_curr, 15);
880: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 21, v_risk_elimination_days);
881:
882: -- Execute the statement.
883: v_Dummy_rbatch := DBMS_SQL.EXECUTE(v_CursorID_rbatch);
884:

Line 883: v_Dummy_rbatch := DBMS_SQL.EXECUTE(v_CursorID_rbatch);

879: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 20, v_remit_bank_acc_curr, 15);
880: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 21, v_risk_elimination_days);
881:
882: -- Execute the statement.
883: v_Dummy_rbatch := DBMS_SQL.EXECUTE(v_CursorID_rbatch);
884:
885: IF DBMS_SQL.FETCH_ROWS(v_CursorID_rbatch) > 0 THEN
886: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 1, v_remittance_batch_name);
887: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 2, v_remittance_method);

Line 885: IF DBMS_SQL.FETCH_ROWS(v_CursorID_rbatch) > 0 THEN

881:
882: -- Execute the statement.
883: v_Dummy_rbatch := DBMS_SQL.EXECUTE(v_CursorID_rbatch);
884:
885: IF DBMS_SQL.FETCH_ROWS(v_CursorID_rbatch) > 0 THEN
886: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 1, v_remittance_batch_name);
887: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 2, v_remittance_method);
888: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 3, v_with_recourse);
889: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 4, v_remittance_payment_method);

Line 886: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 1, v_remittance_batch_name);

882: -- Execute the statement.
883: v_Dummy_rbatch := DBMS_SQL.EXECUTE(v_CursorID_rbatch);
884:
885: IF DBMS_SQL.FETCH_ROWS(v_CursorID_rbatch) > 0 THEN
886: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 1, v_remittance_batch_name);
887: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 2, v_remittance_method);
888: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 3, v_with_recourse);
889: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 4, v_remittance_payment_method);
890: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 5, v_remit_bank_name);

Line 887: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 2, v_remittance_method);

883: v_Dummy_rbatch := DBMS_SQL.EXECUTE(v_CursorID_rbatch);
884:
885: IF DBMS_SQL.FETCH_ROWS(v_CursorID_rbatch) > 0 THEN
886: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 1, v_remittance_batch_name);
887: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 2, v_remittance_method);
888: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 3, v_with_recourse);
889: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 4, v_remittance_payment_method);
890: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 5, v_remit_bank_name);
891: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 6, v_remit_bank_number);

Line 888: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 3, v_with_recourse);

884:
885: IF DBMS_SQL.FETCH_ROWS(v_CursorID_rbatch) > 0 THEN
886: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 1, v_remittance_batch_name);
887: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 2, v_remittance_method);
888: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 3, v_with_recourse);
889: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 4, v_remittance_payment_method);
890: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 5, v_remit_bank_name);
891: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 6, v_remit_bank_number);
892: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 7, v_remit_branch_name);

Line 889: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 4, v_remittance_payment_method);

885: IF DBMS_SQL.FETCH_ROWS(v_CursorID_rbatch) > 0 THEN
886: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 1, v_remittance_batch_name);
887: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 2, v_remittance_method);
888: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 3, v_with_recourse);
889: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 4, v_remittance_payment_method);
890: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 5, v_remit_bank_name);
891: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 6, v_remit_bank_number);
892: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 7, v_remit_branch_name);
893: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 8, v_remit_branch_number);

Line 890: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 5, v_remit_bank_name);

886: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 1, v_remittance_batch_name);
887: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 2, v_remittance_method);
888: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 3, v_with_recourse);
889: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 4, v_remittance_payment_method);
890: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 5, v_remit_bank_name);
891: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 6, v_remit_bank_number);
892: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 7, v_remit_branch_name);
893: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 8, v_remit_branch_number);
894: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 9, v_remit_bank_acc_name);

Line 891: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 6, v_remit_bank_number);

887: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 2, v_remittance_method);
888: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 3, v_with_recourse);
889: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 4, v_remittance_payment_method);
890: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 5, v_remit_bank_name);
891: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 6, v_remit_bank_number);
892: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 7, v_remit_branch_name);
893: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 8, v_remit_branch_number);
894: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 9, v_remit_bank_acc_name);
895: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 10, v_remit_bank_acc_number);

Line 892: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 7, v_remit_branch_name);

888: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 3, v_with_recourse);
889: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 4, v_remittance_payment_method);
890: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 5, v_remit_bank_name);
891: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 6, v_remit_bank_number);
892: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 7, v_remit_branch_name);
893: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 8, v_remit_branch_number);
894: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 9, v_remit_bank_acc_name);
895: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 10, v_remit_bank_acc_number);
896: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 11, v_remit_bank_acc_id);

Line 893: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 8, v_remit_branch_number);

889: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 4, v_remittance_payment_method);
890: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 5, v_remit_bank_name);
891: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 6, v_remit_bank_number);
892: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 7, v_remit_branch_name);
893: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 8, v_remit_branch_number);
894: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 9, v_remit_bank_acc_name);
895: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 10, v_remit_bank_acc_number);
896: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 11, v_remit_bank_acc_id);
897: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 12, v_remit_branch_city);

Line 894: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 9, v_remit_bank_acc_name);

890: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 5, v_remit_bank_name);
891: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 6, v_remit_bank_number);
892: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 7, v_remit_branch_name);
893: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 8, v_remit_branch_number);
894: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 9, v_remit_bank_acc_name);
895: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 10, v_remit_bank_acc_number);
896: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 11, v_remit_bank_acc_id);
897: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 12, v_remit_branch_city);
898: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 13, v_remit_branch_state);

Line 895: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 10, v_remit_bank_acc_number);

891: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 6, v_remit_bank_number);
892: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 7, v_remit_branch_name);
893: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 8, v_remit_branch_number);
894: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 9, v_remit_bank_acc_name);
895: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 10, v_remit_bank_acc_number);
896: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 11, v_remit_bank_acc_id);
897: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 12, v_remit_branch_city);
898: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 13, v_remit_branch_state);
899: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 14, v_remit_branch_country);

Line 896: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 11, v_remit_bank_acc_id);

892: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 7, v_remit_branch_name);
893: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 8, v_remit_branch_number);
894: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 9, v_remit_bank_acc_name);
895: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 10, v_remit_bank_acc_number);
896: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 11, v_remit_bank_acc_id);
897: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 12, v_remit_branch_city);
898: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 13, v_remit_branch_state);
899: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 14, v_remit_branch_country);
900: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 15, v_remit_branch_postal_code);

Line 897: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 12, v_remit_branch_city);

893: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 8, v_remit_branch_number);
894: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 9, v_remit_bank_acc_name);
895: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 10, v_remit_bank_acc_number);
896: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 11, v_remit_bank_acc_id);
897: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 12, v_remit_branch_city);
898: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 13, v_remit_branch_state);
899: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 14, v_remit_branch_country);
900: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 15, v_remit_branch_postal_code);
901: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 16, v_remit_branch_address1);

Line 898: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 13, v_remit_branch_state);

894: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 9, v_remit_bank_acc_name);
895: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 10, v_remit_bank_acc_number);
896: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 11, v_remit_bank_acc_id);
897: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 12, v_remit_branch_city);
898: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 13, v_remit_branch_state);
899: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 14, v_remit_branch_country);
900: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 15, v_remit_branch_postal_code);
901: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 16, v_remit_branch_address1);
902: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 17, v_remit_branch_address2);

Line 899: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 14, v_remit_branch_country);

895: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 10, v_remit_bank_acc_number);
896: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 11, v_remit_bank_acc_id);
897: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 12, v_remit_branch_city);
898: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 13, v_remit_branch_state);
899: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 14, v_remit_branch_country);
900: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 15, v_remit_branch_postal_code);
901: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 16, v_remit_branch_address1);
902: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 17, v_remit_branch_address2);
903: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 18, v_remit_branch_address3);

Line 900: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 15, v_remit_branch_postal_code);

896: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 11, v_remit_bank_acc_id);
897: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 12, v_remit_branch_city);
898: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 13, v_remit_branch_state);
899: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 14, v_remit_branch_country);
900: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 15, v_remit_branch_postal_code);
901: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 16, v_remit_branch_address1);
902: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 17, v_remit_branch_address2);
903: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 18, v_remit_branch_address3);
904: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 19, v_remit_bank_acc_check_digits);

Line 901: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 16, v_remit_branch_address1);

897: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 12, v_remit_branch_city);
898: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 13, v_remit_branch_state);
899: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 14, v_remit_branch_country);
900: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 15, v_remit_branch_postal_code);
901: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 16, v_remit_branch_address1);
902: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 17, v_remit_branch_address2);
903: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 18, v_remit_branch_address3);
904: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 19, v_remit_bank_acc_check_digits);
905: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 20, v_remit_bank_acc_curr);

Line 902: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 17, v_remit_branch_address2);

898: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 13, v_remit_branch_state);
899: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 14, v_remit_branch_country);
900: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 15, v_remit_branch_postal_code);
901: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 16, v_remit_branch_address1);
902: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 17, v_remit_branch_address2);
903: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 18, v_remit_branch_address3);
904: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 19, v_remit_bank_acc_check_digits);
905: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 20, v_remit_bank_acc_curr);
906: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 21, v_risk_elimination_days);

Line 903: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 18, v_remit_branch_address3);

899: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 14, v_remit_branch_country);
900: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 15, v_remit_branch_postal_code);
901: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 16, v_remit_branch_address1);
902: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 17, v_remit_branch_address2);
903: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 18, v_remit_branch_address3);
904: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 19, v_remit_bank_acc_check_digits);
905: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 20, v_remit_bank_acc_curr);
906: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 21, v_risk_elimination_days);
907:

Line 904: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 19, v_remit_bank_acc_check_digits);

900: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 15, v_remit_branch_postal_code);
901: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 16, v_remit_branch_address1);
902: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 17, v_remit_branch_address2);
903: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 18, v_remit_branch_address3);
904: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 19, v_remit_bank_acc_check_digits);
905: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 20, v_remit_bank_acc_curr);
906: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 21, v_risk_elimination_days);
907:
908:

Line 905: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 20, v_remit_bank_acc_curr);

901: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 16, v_remit_branch_address1);
902: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 17, v_remit_branch_address2);
903: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 18, v_remit_branch_address3);
904: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 19, v_remit_bank_acc_check_digits);
905: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 20, v_remit_bank_acc_curr);
906: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 21, v_risk_elimination_days);
907:
908:
909: END IF;

Line 906: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 21, v_risk_elimination_days);

902: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 17, v_remit_branch_address2);
903: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 18, v_remit_branch_address3);
904: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 19, v_remit_bank_acc_check_digits);
905: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 20, v_remit_bank_acc_curr);
906: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 21, v_risk_elimination_days);
907:
908:
909: END IF;
910:

Line 911: IF DBMS_SQL.IS_OPEN (v_CursorID_rbatch) THEN

907:
908:
909: END IF;
910:
911: IF DBMS_SQL.IS_OPEN (v_CursorID_rbatch) THEN
912: DBMS_SQL.CLOSE_CURSOR(v_CursorID_rbatch);
913: END IF;
914:
915: -- Remitance Batch Name Restriction

Line 912: DBMS_SQL.CLOSE_CURSOR(v_CursorID_rbatch);

908:
909: END IF;
910:
911: IF DBMS_SQL.IS_OPEN (v_CursorID_rbatch) THEN
912: DBMS_SQL.CLOSE_CURSOR(v_CursorID_rbatch);
913: END IF;
914:
915: -- Remitance Batch Name Restriction
916: IF p_remittance_batch_name IS NOT NULL THEN

Line 934: DBMS_SQL.CLOSE_CURSOR(v_CursorID_rbatch);

930:
931: EXCEPTION
932: WHEN OTHERS THEN
933: -- Close both cursors, then raise the error again.
934: DBMS_SQL.CLOSE_CURSOR(v_CursorID_rbatch);
935: DBMS_SQL.CLOSE_CURSOR(v_CursorID_main);
936: RAISE;
937:
938: END;

Line 935: DBMS_SQL.CLOSE_CURSOR(v_CursorID_main);

931: EXCEPTION
932: WHEN OTHERS THEN
933: -- Close both cursors, then raise the error again.
934: DBMS_SQL.CLOSE_CURSOR(v_CursorID_rbatch);
935: DBMS_SQL.CLOSE_CURSOR(v_CursorID_main);
936: RAISE;
937:
938: END;
939:

Line 954: v_CursorID_date := DBMS_SQL.OPEN_CURSOR;

950: v_status_date := null;
951: v_status_gl_date := null;
952:
953: -- Open the As of Date cursor for dynamic processing.
954: v_CursorID_date := DBMS_SQL.OPEN_CURSOR;
955:
956: -- Parse the As of Date Cursor
957: DBMS_SQL.PARSE(v_CursorID_date, l_as_of_date, DBMS_SQL.native);
958:

Line 957: DBMS_SQL.PARSE(v_CursorID_date, l_as_of_date, DBMS_SQL.native);

953: -- Open the As of Date cursor for dynamic processing.
954: v_CursorID_date := DBMS_SQL.OPEN_CURSOR;
955:
956: -- Parse the As of Date Cursor
957: DBMS_SQL.PARSE(v_CursorID_date, l_as_of_date, DBMS_SQL.native);
958:
959: -- Bind variables for cursor
960: DBMS_SQL.BIND_VARIABLE(v_CursorID_date, ':b_status_date', p_status_as_of_date);
961: DBMS_SQL.BIND_VARIABLE(v_CursorID_date, ':b_trx_id', v_customer_trx_id);

Line 960: DBMS_SQL.BIND_VARIABLE(v_CursorID_date, ':b_status_date', p_status_as_of_date);

956: -- Parse the As of Date Cursor
957: DBMS_SQL.PARSE(v_CursorID_date, l_as_of_date, DBMS_SQL.native);
958:
959: -- Bind variables for cursor
960: DBMS_SQL.BIND_VARIABLE(v_CursorID_date, ':b_status_date', p_status_as_of_date);
961: DBMS_SQL.BIND_VARIABLE(v_CursorID_date, ':b_trx_id', v_customer_trx_id);
962: -- If the MO Reporting Get Predicate function returns a bind variable then
963: -- we need to bind it.
964: IF l_org_where_trx like '%:p_reporting_entity_id%' THEN

Line 961: DBMS_SQL.BIND_VARIABLE(v_CursorID_date, ':b_trx_id', v_customer_trx_id);

957: DBMS_SQL.PARSE(v_CursorID_date, l_as_of_date, DBMS_SQL.native);
958:
959: -- Bind variables for cursor
960: DBMS_SQL.BIND_VARIABLE(v_CursorID_date, ':b_status_date', p_status_as_of_date);
961: DBMS_SQL.BIND_VARIABLE(v_CursorID_date, ':b_trx_id', v_customer_trx_id);
962: -- If the MO Reporting Get Predicate function returns a bind variable then
963: -- we need to bind it.
964: IF l_org_where_trx like '%:p_reporting_entity_id%' THEN
965: DBMS_SQL.BIND_VARIABLE(v_CursorID_date, ':p_reporting_entity_id', p_reporting_entity_id);

Line 965: DBMS_SQL.BIND_VARIABLE(v_CursorID_date, ':p_reporting_entity_id', p_reporting_entity_id);

961: DBMS_SQL.BIND_VARIABLE(v_CursorID_date, ':b_trx_id', v_customer_trx_id);
962: -- If the MO Reporting Get Predicate function returns a bind variable then
963: -- we need to bind it.
964: IF l_org_where_trx like '%:p_reporting_entity_id%' THEN
965: DBMS_SQL.BIND_VARIABLE(v_CursorID_date, ':p_reporting_entity_id', p_reporting_entity_id);
966: END IF;
967:
968: -- Define the output variables.
969: DBMS_SQL.DEFINE_COLUMN(v_CursorID_date, 1, v_status, 30);

Line 969: DBMS_SQL.DEFINE_COLUMN(v_CursorID_date, 1, v_status, 30);

965: DBMS_SQL.BIND_VARIABLE(v_CursorID_date, ':p_reporting_entity_id', p_reporting_entity_id);
966: END IF;
967:
968: -- Define the output variables.
969: DBMS_SQL.DEFINE_COLUMN(v_CursorID_date, 1, v_status, 30);
970: DBMS_SQL.DEFINE_COLUMN(v_CursorID_date, 2, v_status_date);
971: DBMS_SQL.DEFINE_COLUMN(v_CursorID_date, 3, v_status_gl_date);
972: DBMS_SQL.DEFINE_COLUMN(v_CursorID_date, 4, v_status_code, 30);
973:

Line 970: DBMS_SQL.DEFINE_COLUMN(v_CursorID_date, 2, v_status_date);

966: END IF;
967:
968: -- Define the output variables.
969: DBMS_SQL.DEFINE_COLUMN(v_CursorID_date, 1, v_status, 30);
970: DBMS_SQL.DEFINE_COLUMN(v_CursorID_date, 2, v_status_date);
971: DBMS_SQL.DEFINE_COLUMN(v_CursorID_date, 3, v_status_gl_date);
972: DBMS_SQL.DEFINE_COLUMN(v_CursorID_date, 4, v_status_code, 30);
973:
974: -- Execute the statement.

Line 971: DBMS_SQL.DEFINE_COLUMN(v_CursorID_date, 3, v_status_gl_date);

967:
968: -- Define the output variables.
969: DBMS_SQL.DEFINE_COLUMN(v_CursorID_date, 1, v_status, 30);
970: DBMS_SQL.DEFINE_COLUMN(v_CursorID_date, 2, v_status_date);
971: DBMS_SQL.DEFINE_COLUMN(v_CursorID_date, 3, v_status_gl_date);
972: DBMS_SQL.DEFINE_COLUMN(v_CursorID_date, 4, v_status_code, 30);
973:
974: -- Execute the statement.
975: v_Dummy_date := DBMS_SQL.EXECUTE(v_CursorID_date);

Line 972: DBMS_SQL.DEFINE_COLUMN(v_CursorID_date, 4, v_status_code, 30);

968: -- Define the output variables.
969: DBMS_SQL.DEFINE_COLUMN(v_CursorID_date, 1, v_status, 30);
970: DBMS_SQL.DEFINE_COLUMN(v_CursorID_date, 2, v_status_date);
971: DBMS_SQL.DEFINE_COLUMN(v_CursorID_date, 3, v_status_gl_date);
972: DBMS_SQL.DEFINE_COLUMN(v_CursorID_date, 4, v_status_code, 30);
973:
974: -- Execute the statement.
975: v_Dummy_date := DBMS_SQL.EXECUTE(v_CursorID_date);
976:

Line 975: v_Dummy_date := DBMS_SQL.EXECUTE(v_CursorID_date);

971: DBMS_SQL.DEFINE_COLUMN(v_CursorID_date, 3, v_status_gl_date);
972: DBMS_SQL.DEFINE_COLUMN(v_CursorID_date, 4, v_status_code, 30);
973:
974: -- Execute the statement.
975: v_Dummy_date := DBMS_SQL.EXECUTE(v_CursorID_date);
976:
977: IF DBMS_SQL.FETCH_ROWS(v_CursorID_date) > 0 THEN
978: DBMS_SQL.COLUMN_VALUE(v_CursorID_date, 1, v_status);
979: DBMS_SQL.COLUMN_VALUE(v_CursorID_date, 2, v_status_date);

Line 977: IF DBMS_SQL.FETCH_ROWS(v_CursorID_date) > 0 THEN

973:
974: -- Execute the statement.
975: v_Dummy_date := DBMS_SQL.EXECUTE(v_CursorID_date);
976:
977: IF DBMS_SQL.FETCH_ROWS(v_CursorID_date) > 0 THEN
978: DBMS_SQL.COLUMN_VALUE(v_CursorID_date, 1, v_status);
979: DBMS_SQL.COLUMN_VALUE(v_CursorID_date, 2, v_status_date);
980: DBMS_SQL.COLUMN_VALUE(v_CursorID_date, 3, v_status_gl_date);
981: DBMS_SQL.COLUMN_VALUE(v_CursorID_date, 4, v_status_code);

Line 978: DBMS_SQL.COLUMN_VALUE(v_CursorID_date, 1, v_status);

974: -- Execute the statement.
975: v_Dummy_date := DBMS_SQL.EXECUTE(v_CursorID_date);
976:
977: IF DBMS_SQL.FETCH_ROWS(v_CursorID_date) > 0 THEN
978: DBMS_SQL.COLUMN_VALUE(v_CursorID_date, 1, v_status);
979: DBMS_SQL.COLUMN_VALUE(v_CursorID_date, 2, v_status_date);
980: DBMS_SQL.COLUMN_VALUE(v_CursorID_date, 3, v_status_gl_date);
981: DBMS_SQL.COLUMN_VALUE(v_CursorID_date, 4, v_status_code);
982: END IF;

Line 979: DBMS_SQL.COLUMN_VALUE(v_CursorID_date, 2, v_status_date);

975: v_Dummy_date := DBMS_SQL.EXECUTE(v_CursorID_date);
976:
977: IF DBMS_SQL.FETCH_ROWS(v_CursorID_date) > 0 THEN
978: DBMS_SQL.COLUMN_VALUE(v_CursorID_date, 1, v_status);
979: DBMS_SQL.COLUMN_VALUE(v_CursorID_date, 2, v_status_date);
980: DBMS_SQL.COLUMN_VALUE(v_CursorID_date, 3, v_status_gl_date);
981: DBMS_SQL.COLUMN_VALUE(v_CursorID_date, 4, v_status_code);
982: END IF;
983:

Line 980: DBMS_SQL.COLUMN_VALUE(v_CursorID_date, 3, v_status_gl_date);

976:
977: IF DBMS_SQL.FETCH_ROWS(v_CursorID_date) > 0 THEN
978: DBMS_SQL.COLUMN_VALUE(v_CursorID_date, 1, v_status);
979: DBMS_SQL.COLUMN_VALUE(v_CursorID_date, 2, v_status_date);
980: DBMS_SQL.COLUMN_VALUE(v_CursorID_date, 3, v_status_gl_date);
981: DBMS_SQL.COLUMN_VALUE(v_CursorID_date, 4, v_status_code);
982: END IF;
983:
984: IF DBMS_SQL.IS_OPEN (v_CursorID_date) THEN

Line 981: DBMS_SQL.COLUMN_VALUE(v_CursorID_date, 4, v_status_code);

977: IF DBMS_SQL.FETCH_ROWS(v_CursorID_date) > 0 THEN
978: DBMS_SQL.COLUMN_VALUE(v_CursorID_date, 1, v_status);
979: DBMS_SQL.COLUMN_VALUE(v_CursorID_date, 2, v_status_date);
980: DBMS_SQL.COLUMN_VALUE(v_CursorID_date, 3, v_status_gl_date);
981: DBMS_SQL.COLUMN_VALUE(v_CursorID_date, 4, v_status_code);
982: END IF;
983:
984: IF DBMS_SQL.IS_OPEN (v_CursorID_date) THEN
985: DBMS_SQL.CLOSE_CURSOR(v_CursorID_date);

Line 984: IF DBMS_SQL.IS_OPEN (v_CursorID_date) THEN

980: DBMS_SQL.COLUMN_VALUE(v_CursorID_date, 3, v_status_gl_date);
981: DBMS_SQL.COLUMN_VALUE(v_CursorID_date, 4, v_status_code);
982: END IF;
983:
984: IF DBMS_SQL.IS_OPEN (v_CursorID_date) THEN
985: DBMS_SQL.CLOSE_CURSOR(v_CursorID_date);
986: END IF;
987:
988: EXCEPTION

Line 985: DBMS_SQL.CLOSE_CURSOR(v_CursorID_date);

981: DBMS_SQL.COLUMN_VALUE(v_CursorID_date, 4, v_status_code);
982: END IF;
983:
984: IF DBMS_SQL.IS_OPEN (v_CursorID_date) THEN
985: DBMS_SQL.CLOSE_CURSOR(v_CursorID_date);
986: END IF;
987:
988: EXCEPTION
989: WHEN OTHERS THEN

Line 991: DBMS_SQL.CLOSE_CURSOR(v_CursorID_date);

987:
988: EXCEPTION
989: WHEN OTHERS THEN
990: -- Close both cursors, then raise the error again.
991: DBMS_SQL.CLOSE_CURSOR(v_CursorID_date);
992: DBMS_SQL.CLOSE_CURSOR(v_CursorID_main);
993: RAISE;
994:
995: END;

Line 992: DBMS_SQL.CLOSE_CURSOR(v_CursorID_main);

988: EXCEPTION
989: WHEN OTHERS THEN
990: -- Close both cursors, then raise the error again.
991: DBMS_SQL.CLOSE_CURSOR(v_CursorID_date);
992: DBMS_SQL.CLOSE_CURSOR(v_CursorID_main);
993: RAISE;
994:
995: END;
996:

Line 1012: v_CursorID_asg := DBMS_SQL.OPEN_CURSOR;

1008: v_assigned_entered_amount := 0;
1009: v_assigned_functional_amount := 0;
1010:
1011: -- Open the Assigned Amounts cursor for dynamic processing.
1012: v_CursorID_asg := DBMS_SQL.OPEN_CURSOR;
1013:
1014: -- Parse the Assigned Amounts Cursor
1015: DBMS_SQL.PARSE(v_CursorID_asg, l_assigned_amount, DBMS_SQL.native);
1016:

Line 1015: DBMS_SQL.PARSE(v_CursorID_asg, l_assigned_amount, DBMS_SQL.native);

1011: -- Open the Assigned Amounts cursor for dynamic processing.
1012: v_CursorID_asg := DBMS_SQL.OPEN_CURSOR;
1013:
1014: -- Parse the Assigned Amounts Cursor
1015: DBMS_SQL.PARSE(v_CursorID_asg, l_assigned_amount, DBMS_SQL.native);
1016:
1017: -- Bind variables for cursor
1018: DBMS_SQL.BIND_VARIABLE(v_CursorID_asg, ':b_trx_id', v_customer_trx_id);
1019: -- If the MO Reporting Get Predicate function returns a bind variable then

Line 1018: DBMS_SQL.BIND_VARIABLE(v_CursorID_asg, ':b_trx_id', v_customer_trx_id);

1014: -- Parse the Assigned Amounts Cursor
1015: DBMS_SQL.PARSE(v_CursorID_asg, l_assigned_amount, DBMS_SQL.native);
1016:
1017: -- Bind variables for cursor
1018: DBMS_SQL.BIND_VARIABLE(v_CursorID_asg, ':b_trx_id', v_customer_trx_id);
1019: -- If the MO Reporting Get Predicate function returns a bind variable then
1020: -- we need to bind it.
1021:
1022: IF l_org_where_trx like '%:p_reporting_entity_id%' THEN

Line 1023: DBMS_SQL.BIND_VARIABLE(v_CursorID_asg, ':p_reporting_entity_id', p_reporting_entity_id);

1019: -- If the MO Reporting Get Predicate function returns a bind variable then
1020: -- we need to bind it.
1021:
1022: IF l_org_where_trx like '%:p_reporting_entity_id%' THEN
1023: DBMS_SQL.BIND_VARIABLE(v_CursorID_asg, ':p_reporting_entity_id', p_reporting_entity_id);
1024: END IF;
1025:
1026: -- Define the output variables.
1027: DBMS_SQL.DEFINE_COLUMN(v_CursorID_asg, 1, v_assigned_entered_amount);

Line 1027: DBMS_SQL.DEFINE_COLUMN(v_CursorID_asg, 1, v_assigned_entered_amount);

1023: DBMS_SQL.BIND_VARIABLE(v_CursorID_asg, ':p_reporting_entity_id', p_reporting_entity_id);
1024: END IF;
1025:
1026: -- Define the output variables.
1027: DBMS_SQL.DEFINE_COLUMN(v_CursorID_asg, 1, v_assigned_entered_amount);
1028: DBMS_SQL.DEFINE_COLUMN(v_CursorID_asg, 2, v_assigned_functional_amount);
1029:
1030: -- Execute the statement.
1031: v_Dummy_asg := DBMS_SQL.EXECUTE(v_CursorID_asg);

Line 1028: DBMS_SQL.DEFINE_COLUMN(v_CursorID_asg, 2, v_assigned_functional_amount);

1024: END IF;
1025:
1026: -- Define the output variables.
1027: DBMS_SQL.DEFINE_COLUMN(v_CursorID_asg, 1, v_assigned_entered_amount);
1028: DBMS_SQL.DEFINE_COLUMN(v_CursorID_asg, 2, v_assigned_functional_amount);
1029:
1030: -- Execute the statement.
1031: v_Dummy_asg := DBMS_SQL.EXECUTE(v_CursorID_asg);
1032:

Line 1031: v_Dummy_asg := DBMS_SQL.EXECUTE(v_CursorID_asg);

1027: DBMS_SQL.DEFINE_COLUMN(v_CursorID_asg, 1, v_assigned_entered_amount);
1028: DBMS_SQL.DEFINE_COLUMN(v_CursorID_asg, 2, v_assigned_functional_amount);
1029:
1030: -- Execute the statement.
1031: v_Dummy_asg := DBMS_SQL.EXECUTE(v_CursorID_asg);
1032:
1033: IF DBMS_SQL.FETCH_ROWS(v_CursorID_asg) > 0 THEN
1034: DBMS_SQL.COLUMN_VALUE(v_CursorID_asg, 1, v_assigned_entered_amount);
1035: DBMS_SQL.COLUMN_VALUE(v_CursorID_asg, 2, v_assigned_functional_amount);

Line 1033: IF DBMS_SQL.FETCH_ROWS(v_CursorID_asg) > 0 THEN

1029:
1030: -- Execute the statement.
1031: v_Dummy_asg := DBMS_SQL.EXECUTE(v_CursorID_asg);
1032:
1033: IF DBMS_SQL.FETCH_ROWS(v_CursorID_asg) > 0 THEN
1034: DBMS_SQL.COLUMN_VALUE(v_CursorID_asg, 1, v_assigned_entered_amount);
1035: DBMS_SQL.COLUMN_VALUE(v_CursorID_asg, 2, v_assigned_functional_amount);
1036: END IF;
1037:

Line 1034: DBMS_SQL.COLUMN_VALUE(v_CursorID_asg, 1, v_assigned_entered_amount);

1030: -- Execute the statement.
1031: v_Dummy_asg := DBMS_SQL.EXECUTE(v_CursorID_asg);
1032:
1033: IF DBMS_SQL.FETCH_ROWS(v_CursorID_asg) > 0 THEN
1034: DBMS_SQL.COLUMN_VALUE(v_CursorID_asg, 1, v_assigned_entered_amount);
1035: DBMS_SQL.COLUMN_VALUE(v_CursorID_asg, 2, v_assigned_functional_amount);
1036: END IF;
1037:
1038: IF DBMS_SQL.IS_OPEN (v_CursorID_asg) THEN

Line 1035: DBMS_SQL.COLUMN_VALUE(v_CursorID_asg, 2, v_assigned_functional_amount);

1031: v_Dummy_asg := DBMS_SQL.EXECUTE(v_CursorID_asg);
1032:
1033: IF DBMS_SQL.FETCH_ROWS(v_CursorID_asg) > 0 THEN
1034: DBMS_SQL.COLUMN_VALUE(v_CursorID_asg, 1, v_assigned_entered_amount);
1035: DBMS_SQL.COLUMN_VALUE(v_CursorID_asg, 2, v_assigned_functional_amount);
1036: END IF;
1037:
1038: IF DBMS_SQL.IS_OPEN (v_CursorID_asg) THEN
1039: DBMS_SQL.CLOSE_CURSOR(v_CursorID_asg);

Line 1038: IF DBMS_SQL.IS_OPEN (v_CursorID_asg) THEN

1034: DBMS_SQL.COLUMN_VALUE(v_CursorID_asg, 1, v_assigned_entered_amount);
1035: DBMS_SQL.COLUMN_VALUE(v_CursorID_asg, 2, v_assigned_functional_amount);
1036: END IF;
1037:
1038: IF DBMS_SQL.IS_OPEN (v_CursorID_asg) THEN
1039: DBMS_SQL.CLOSE_CURSOR(v_CursorID_asg);
1040: END IF;
1041:
1042: EXCEPTION

Line 1039: DBMS_SQL.CLOSE_CURSOR(v_CursorID_asg);

1035: DBMS_SQL.COLUMN_VALUE(v_CursorID_asg, 2, v_assigned_functional_amount);
1036: END IF;
1037:
1038: IF DBMS_SQL.IS_OPEN (v_CursorID_asg) THEN
1039: DBMS_SQL.CLOSE_CURSOR(v_CursorID_asg);
1040: END IF;
1041:
1042: EXCEPTION
1043: WHEN OTHERS THEN

Line 1045: DBMS_SQL.CLOSE_CURSOR(v_CursorID_asg);

1041:
1042: EXCEPTION
1043: WHEN OTHERS THEN
1044: -- Close both cursors, then raise the error again.
1045: DBMS_SQL.CLOSE_CURSOR(v_CursorID_asg);
1046: DBMS_SQL.CLOSE_CURSOR(v_CursorID_main);
1047: RAISE;
1048:
1049: END;

Line 1046: DBMS_SQL.CLOSE_CURSOR(v_CursorID_main);

1042: EXCEPTION
1043: WHEN OTHERS THEN
1044: -- Close both cursors, then raise the error again.
1045: DBMS_SQL.CLOSE_CURSOR(v_CursorID_asg);
1046: DBMS_SQL.CLOSE_CURSOR(v_CursorID_main);
1047: RAISE;
1048:
1049: END;
1050:

Line 1062: v_CursorID_amt := DBMS_SQL.OPEN_CURSOR;

1058: v_amount_applied := null;
1059: v_functional_amount_applied := null;
1060:
1061: -- Open the Open Amt cursor for dynamic processing.
1062: v_CursorID_amt := DBMS_SQL.OPEN_CURSOR;
1063:
1064: -- Parse the Open Amt Cursor
1065: DBMS_SQL.PARSE(v_CursorID_amt, l_open_amount, DBMS_SQL.native);
1066:

Line 1065: DBMS_SQL.PARSE(v_CursorID_amt, l_open_amount, DBMS_SQL.native);

1061: -- Open the Open Amt cursor for dynamic processing.
1062: v_CursorID_amt := DBMS_SQL.OPEN_CURSOR;
1063:
1064: -- Parse the Open Amt Cursor
1065: DBMS_SQL.PARSE(v_CursorID_amt, l_open_amount, DBMS_SQL.native);
1066:
1067: -- Bind variables for cursor
1068: DBMS_SQL.BIND_VARIABLE(v_CursorID_amt, ':b_status_as_of_date', p_status_as_of_date);
1069: DBMS_SQL.BIND_VARIABLE(v_CursorID_amt, ':b_trx_id', v_customer_trx_id);

Line 1068: DBMS_SQL.BIND_VARIABLE(v_CursorID_amt, ':b_status_as_of_date', p_status_as_of_date);

1064: -- Parse the Open Amt Cursor
1065: DBMS_SQL.PARSE(v_CursorID_amt, l_open_amount, DBMS_SQL.native);
1066:
1067: -- Bind variables for cursor
1068: DBMS_SQL.BIND_VARIABLE(v_CursorID_amt, ':b_status_as_of_date', p_status_as_of_date);
1069: DBMS_SQL.BIND_VARIABLE(v_CursorID_amt, ':b_trx_id', v_customer_trx_id);
1070: -- If the MO Reporting Get Predicate function returns a bind variable then
1071: -- we need to bind it.
1072: IF l_org_where_trx like '%:p_reporting_entity_id%' THEN

Line 1069: DBMS_SQL.BIND_VARIABLE(v_CursorID_amt, ':b_trx_id', v_customer_trx_id);

1065: DBMS_SQL.PARSE(v_CursorID_amt, l_open_amount, DBMS_SQL.native);
1066:
1067: -- Bind variables for cursor
1068: DBMS_SQL.BIND_VARIABLE(v_CursorID_amt, ':b_status_as_of_date', p_status_as_of_date);
1069: DBMS_SQL.BIND_VARIABLE(v_CursorID_amt, ':b_trx_id', v_customer_trx_id);
1070: -- If the MO Reporting Get Predicate function returns a bind variable then
1071: -- we need to bind it.
1072: IF l_org_where_trx like '%:p_reporting_entity_id%' THEN
1073: DBMS_SQL.BIND_VARIABLE(v_CursorID_amt, ':p_reporting_entity_id', p_reporting_entity_id);

Line 1073: DBMS_SQL.BIND_VARIABLE(v_CursorID_amt, ':p_reporting_entity_id', p_reporting_entity_id);

1069: DBMS_SQL.BIND_VARIABLE(v_CursorID_amt, ':b_trx_id', v_customer_trx_id);
1070: -- If the MO Reporting Get Predicate function returns a bind variable then
1071: -- we need to bind it.
1072: IF l_org_where_trx like '%:p_reporting_entity_id%' THEN
1073: DBMS_SQL.BIND_VARIABLE(v_CursorID_amt, ':p_reporting_entity_id', p_reporting_entity_id);
1074: END IF;
1075:
1076: -- Define the output variables.
1077: DBMS_SQL.DEFINE_COLUMN(v_CursorID_amt, 1, v_amount_applied);

Line 1077: DBMS_SQL.DEFINE_COLUMN(v_CursorID_amt, 1, v_amount_applied);

1073: DBMS_SQL.BIND_VARIABLE(v_CursorID_amt, ':p_reporting_entity_id', p_reporting_entity_id);
1074: END IF;
1075:
1076: -- Define the output variables.
1077: DBMS_SQL.DEFINE_COLUMN(v_CursorID_amt, 1, v_amount_applied);
1078:
1079: -- Execute the statement.
1080: v_Dummy_amt := DBMS_SQL.EXECUTE(v_CursorID_amt);
1081:

Line 1080: v_Dummy_amt := DBMS_SQL.EXECUTE(v_CursorID_amt);

1076: -- Define the output variables.
1077: DBMS_SQL.DEFINE_COLUMN(v_CursorID_amt, 1, v_amount_applied);
1078:
1079: -- Execute the statement.
1080: v_Dummy_amt := DBMS_SQL.EXECUTE(v_CursorID_amt);
1081:
1082: IF DBMS_SQL.FETCH_ROWS(v_CursorID_amt) > 0 THEN
1083: DBMS_SQL.COLUMN_VALUE(v_CursorID_amt, 1, v_amount_applied);
1084: END IF;

Line 1082: IF DBMS_SQL.FETCH_ROWS(v_CursorID_amt) > 0 THEN

1078:
1079: -- Execute the statement.
1080: v_Dummy_amt := DBMS_SQL.EXECUTE(v_CursorID_amt);
1081:
1082: IF DBMS_SQL.FETCH_ROWS(v_CursorID_amt) > 0 THEN
1083: DBMS_SQL.COLUMN_VALUE(v_CursorID_amt, 1, v_amount_applied);
1084: END IF;
1085:
1086: IF DBMS_SQL.IS_OPEN (v_CursorID_amt) THEN

Line 1083: DBMS_SQL.COLUMN_VALUE(v_CursorID_amt, 1, v_amount_applied);

1079: -- Execute the statement.
1080: v_Dummy_amt := DBMS_SQL.EXECUTE(v_CursorID_amt);
1081:
1082: IF DBMS_SQL.FETCH_ROWS(v_CursorID_amt) > 0 THEN
1083: DBMS_SQL.COLUMN_VALUE(v_CursorID_amt, 1, v_amount_applied);
1084: END IF;
1085:
1086: IF DBMS_SQL.IS_OPEN (v_CursorID_amt) THEN
1087: DBMS_SQL.CLOSE_CURSOR(v_CursorID_amt);

Line 1086: IF DBMS_SQL.IS_OPEN (v_CursorID_amt) THEN

1082: IF DBMS_SQL.FETCH_ROWS(v_CursorID_amt) > 0 THEN
1083: DBMS_SQL.COLUMN_VALUE(v_CursorID_amt, 1, v_amount_applied);
1084: END IF;
1085:
1086: IF DBMS_SQL.IS_OPEN (v_CursorID_amt) THEN
1087: DBMS_SQL.CLOSE_CURSOR(v_CursorID_amt);
1088: END IF;
1089:
1090: IF v_amount_applied IS NOT NULL THEN

Line 1087: DBMS_SQL.CLOSE_CURSOR(v_CursorID_amt);

1083: DBMS_SQL.COLUMN_VALUE(v_CursorID_amt, 1, v_amount_applied);
1084: END IF;
1085:
1086: IF DBMS_SQL.IS_OPEN (v_CursorID_amt) THEN
1087: DBMS_SQL.CLOSE_CURSOR(v_CursorID_amt);
1088: END IF;
1089:
1090: IF v_amount_applied IS NOT NULL THEN
1091: v_open_entered_amount := v_amount_applied + v_open_entered_amount;

Line 1116: DBMS_SQL.CLOSE_CURSOR(v_CursorID_amt);

1112:
1113: EXCEPTION
1114: WHEN OTHERS THEN
1115: -- Close both cursors, then raise the error again.
1116: DBMS_SQL.CLOSE_CURSOR(v_CursorID_amt);
1117: DBMS_SQL.CLOSE_CURSOR(v_CursorID_main);
1118: RAISE;
1119:
1120: END;

Line 1117: DBMS_SQL.CLOSE_CURSOR(v_CursorID_main);

1113: EXCEPTION
1114: WHEN OTHERS THEN
1115: -- Close both cursors, then raise the error again.
1116: DBMS_SQL.CLOSE_CURSOR(v_CursorID_amt);
1117: DBMS_SQL.CLOSE_CURSOR(v_CursorID_main);
1118: RAISE;
1119:
1120: END;
1121:

Line 1134: v_CursorID_rev := DBMS_SQL.OPEN_CURSOR;

1130: -- Initialize variables
1131: v_unpaid_receipt_rev_reason := null;
1132:
1133: -- Open the Unpaide Receipt Reversal Reason cursor for dynamic processing.
1134: v_CursorID_rev := DBMS_SQL.OPEN_CURSOR;
1135:
1136: -- Parse the Open Amt Cursor
1137: DBMS_SQL.PARSE(v_CursorID_rev, l_receipt_reversal, DBMS_SQL.native);
1138:

Line 1137: DBMS_SQL.PARSE(v_CursorID_rev, l_receipt_reversal, DBMS_SQL.native);

1133: -- Open the Unpaide Receipt Reversal Reason cursor for dynamic processing.
1134: v_CursorID_rev := DBMS_SQL.OPEN_CURSOR;
1135:
1136: -- Parse the Open Amt Cursor
1137: DBMS_SQL.PARSE(v_CursorID_rev, l_receipt_reversal, DBMS_SQL.native);
1138:
1139: -- Bind variables for cursor
1140: DBMS_SQL.BIND_VARIABLE(v_CursorID_rev, ':b_trx_id', v_customer_trx_id);
1141: -- If the MO Reporting Get Predicate function returns a bind variable then

Line 1140: DBMS_SQL.BIND_VARIABLE(v_CursorID_rev, ':b_trx_id', v_customer_trx_id);

1136: -- Parse the Open Amt Cursor
1137: DBMS_SQL.PARSE(v_CursorID_rev, l_receipt_reversal, DBMS_SQL.native);
1138:
1139: -- Bind variables for cursor
1140: DBMS_SQL.BIND_VARIABLE(v_CursorID_rev, ':b_trx_id', v_customer_trx_id);
1141: -- If the MO Reporting Get Predicate function returns a bind variable then
1142: -- we need to bind it.
1143: IF l_org_where_trx like '%:p_reporting_entity_id%' THEN
1144: DBMS_SQL.BIND_VARIABLE(v_CursorID_rev, ':p_reporting_entity_id', p_reporting_entity_id);

Line 1144: DBMS_SQL.BIND_VARIABLE(v_CursorID_rev, ':p_reporting_entity_id', p_reporting_entity_id);

1140: DBMS_SQL.BIND_VARIABLE(v_CursorID_rev, ':b_trx_id', v_customer_trx_id);
1141: -- If the MO Reporting Get Predicate function returns a bind variable then
1142: -- we need to bind it.
1143: IF l_org_where_trx like '%:p_reporting_entity_id%' THEN
1144: DBMS_SQL.BIND_VARIABLE(v_CursorID_rev, ':p_reporting_entity_id', p_reporting_entity_id);
1145: END IF;
1146:
1147: -- Define the output variables.
1148: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rev, 1, v_unpaid_receipt_rev_reason, 80);

Line 1148: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rev, 1, v_unpaid_receipt_rev_reason, 80);

1144: DBMS_SQL.BIND_VARIABLE(v_CursorID_rev, ':p_reporting_entity_id', p_reporting_entity_id);
1145: END IF;
1146:
1147: -- Define the output variables.
1148: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rev, 1, v_unpaid_receipt_rev_reason, 80);
1149:
1150: -- Execute the statement.
1151: v_Dummy_amt := DBMS_SQL.EXECUTE(v_CursorID_rev);
1152:

Line 1151: v_Dummy_amt := DBMS_SQL.EXECUTE(v_CursorID_rev);

1147: -- Define the output variables.
1148: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rev, 1, v_unpaid_receipt_rev_reason, 80);
1149:
1150: -- Execute the statement.
1151: v_Dummy_amt := DBMS_SQL.EXECUTE(v_CursorID_rev);
1152:
1153: IF DBMS_SQL.FETCH_ROWS(v_CursorID_rev) > 0 THEN
1154: DBMS_SQL.COLUMN_VALUE(v_CursorID_rev, 1, v_unpaid_receipt_rev_reason);
1155: END IF;

Line 1153: IF DBMS_SQL.FETCH_ROWS(v_CursorID_rev) > 0 THEN

1149:
1150: -- Execute the statement.
1151: v_Dummy_amt := DBMS_SQL.EXECUTE(v_CursorID_rev);
1152:
1153: IF DBMS_SQL.FETCH_ROWS(v_CursorID_rev) > 0 THEN
1154: DBMS_SQL.COLUMN_VALUE(v_CursorID_rev, 1, v_unpaid_receipt_rev_reason);
1155: END IF;
1156:
1157: IF DBMS_SQL.IS_OPEN (v_CursorID_rev) THEN

Line 1154: DBMS_SQL.COLUMN_VALUE(v_CursorID_rev, 1, v_unpaid_receipt_rev_reason);

1150: -- Execute the statement.
1151: v_Dummy_amt := DBMS_SQL.EXECUTE(v_CursorID_rev);
1152:
1153: IF DBMS_SQL.FETCH_ROWS(v_CursorID_rev) > 0 THEN
1154: DBMS_SQL.COLUMN_VALUE(v_CursorID_rev, 1, v_unpaid_receipt_rev_reason);
1155: END IF;
1156:
1157: IF DBMS_SQL.IS_OPEN (v_CursorID_rev) THEN
1158: DBMS_SQL.CLOSE_CURSOR(v_CursorID_rev);

Line 1157: IF DBMS_SQL.IS_OPEN (v_CursorID_rev) THEN

1153: IF DBMS_SQL.FETCH_ROWS(v_CursorID_rev) > 0 THEN
1154: DBMS_SQL.COLUMN_VALUE(v_CursorID_rev, 1, v_unpaid_receipt_rev_reason);
1155: END IF;
1156:
1157: IF DBMS_SQL.IS_OPEN (v_CursorID_rev) THEN
1158: DBMS_SQL.CLOSE_CURSOR(v_CursorID_rev);
1159: END IF;
1160:
1161: EXCEPTION

Line 1158: DBMS_SQL.CLOSE_CURSOR(v_CursorID_rev);

1154: DBMS_SQL.COLUMN_VALUE(v_CursorID_rev, 1, v_unpaid_receipt_rev_reason);
1155: END IF;
1156:
1157: IF DBMS_SQL.IS_OPEN (v_CursorID_rev) THEN
1158: DBMS_SQL.CLOSE_CURSOR(v_CursorID_rev);
1159: END IF;
1160:
1161: EXCEPTION
1162: WHEN OTHERS THEN

Line 1164: DBMS_SQL.CLOSE_CURSOR(v_CursorID_rev);

1160:
1161: EXCEPTION
1162: WHEN OTHERS THEN
1163: -- Close both cursors, then raise the error again.
1164: DBMS_SQL.CLOSE_CURSOR(v_CursorID_rev);
1165: DBMS_SQL.CLOSE_CURSOR(v_CursorID_main);
1166: RAISE;
1167:
1168: END;

Line 1165: DBMS_SQL.CLOSE_CURSOR(v_CursorID_main);

1161: EXCEPTION
1162: WHEN OTHERS THEN
1163: -- Close both cursors, then raise the error again.
1164: DBMS_SQL.CLOSE_CURSOR(v_CursorID_rev);
1165: DBMS_SQL.CLOSE_CURSOR(v_CursorID_main);
1166: RAISE;
1167:
1168: END;
1169:

Line 1409: DBMS_SQL.CLOSE_CURSOR(v_CursorID_main);

1405:
1406: END LOOP;
1407:
1408: -- Close the cursor.
1409: DBMS_SQL.CLOSE_CURSOR(v_CursorID_main);
1410:
1411: -- Update status variables to successful completion
1412: retcode := 0;
1413: errbuf := '';

Line 1421: DBMS_SQL.CLOSE_CURSOR(v_CursorID_main);

1417:
1418: EXCEPTION
1419: WHEN OTHERS THEN
1420: -- Close the cursor, then raise the error again.
1421: DBMS_SQL.CLOSE_CURSOR(v_CursorID_main);
1422: RAISE;
1423: END arrxbrs_report;
1424:
1425: END arrx_brs;