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 560: DBMS_SQL.native);

556: l_on_hold_where ||
557: 'AND trx.customer_trx_id = ps.customer_trx_id(+)
558: AND trx.batch_id = rab.batch_id(+)
559: AND rah.status <> ''INCOMPLETE''',
560: DBMS_SQL.native);
561:
562:
563:
564: /*------------------------------------------------------------------+

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

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

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

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

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

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

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

575: DBMS_SQL.BIND_VARIABLE(v_CursorID_main, ':b_first_status', p_first_status);
576: IF p_second_status IS NOT NULL THEN
577: DBMS_SQL.BIND_VARIABLE(v_CursorID_main, ':b_second_status', p_second_status);
578: IF p_third_status IS NOT NULL THEN
579: DBMS_SQL.BIND_VARIABLE(v_CursorID_main, ':b_third_status', p_third_status);
580: END IF;
581: END IF;
582: END IF;
583:

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

617: DBMS_SQL.BIND_VARIABLE(v_CursorID_main, ':b_issue_date_from', p_transaction_issue_date_from);
618: END IF;
619:
620: IF p_transaction_issue_date_to IS NOT NULL THEN
621: DBMS_SQL.BIND_VARIABLE(v_CursorID_main, ':b_issue_date_to', p_transaction_issue_date_to);
622: END IF;
623:
624: IF p_on_hold IS NOT NULL THEN
625: DBMS_SQL.BIND_VARIABLE(v_CursorID_main, ':b_on_hold', p_on_hold);

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

621: DBMS_SQL.BIND_VARIABLE(v_CursorID_main, ':b_issue_date_to', p_transaction_issue_date_to);
622: END IF;
623:
624: IF p_on_hold IS NOT NULL THEN
625: DBMS_SQL.BIND_VARIABLE(v_CursorID_main, ':b_on_hold', p_on_hold);
626: END IF;
627:
628:
629: /*------------------------------------------------------------------+

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

629: /*------------------------------------------------------------------+
630: | Define the output variables |
631: +------------------------------------------------------------------*/
632:
633: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 1, v_customer_trx_id);
634: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 2, v_transaction_number, 20);
635: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 3, v_document_number);
636: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 4, v_document_sequence_name, 30);
637: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 5, v_currency_code, 15);

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

630: | Define the output variables |
631: +------------------------------------------------------------------*/
632:
633: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 1, v_customer_trx_id);
634: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 2, v_transaction_number, 20);
635: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 3, v_document_number);
636: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 4, v_document_sequence_name, 30);
637: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 5, v_currency_code, 15);
638: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 6, v_magnetic_format_code, 30);

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

631: +------------------------------------------------------------------*/
632:
633: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 1, v_customer_trx_id);
634: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 2, v_transaction_number, 20);
635: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 3, v_document_number);
636: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 4, v_document_sequence_name, 30);
637: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 5, v_currency_code, 15);
638: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 6, v_magnetic_format_code, 30);
639: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 7, v_original_entered_amount);

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

632:
633: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 1, v_customer_trx_id);
634: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 2, v_transaction_number, 20);
635: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 3, v_document_number);
636: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 4, v_document_sequence_name, 30);
637: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 5, v_currency_code, 15);
638: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 6, v_magnetic_format_code, 30);
639: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 7, v_original_entered_amount);
640: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 8, v_open_entered_amount);

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

633: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 1, v_customer_trx_id);
634: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 2, v_transaction_number, 20);
635: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 3, v_document_number);
636: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 4, v_document_sequence_name, 30);
637: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 5, v_currency_code, 15);
638: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 6, v_magnetic_format_code, 30);
639: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 7, v_original_entered_amount);
640: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 8, v_open_entered_amount);
641: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 9, v_open_functional_amount);

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

634: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 2, v_transaction_number, 20);
635: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 3, v_document_number);
636: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 4, v_document_sequence_name, 30);
637: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 5, v_currency_code, 15);
638: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 6, v_magnetic_format_code, 30);
639: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 7, v_original_entered_amount);
640: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 8, v_open_entered_amount);
641: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 9, v_open_functional_amount);
642: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 10, v_drawee_name, 255);

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

635: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 3, v_document_number);
636: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 4, v_document_sequence_name, 30);
637: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 5, v_currency_code, 15);
638: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 6, v_magnetic_format_code, 30);
639: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 7, v_original_entered_amount);
640: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 8, v_open_entered_amount);
641: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 9, v_open_functional_amount);
642: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 10, v_drawee_name, 255);
643: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 11, v_drawee_number, 30);

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

636: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 4, v_document_sequence_name, 30);
637: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 5, v_currency_code, 15);
638: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 6, v_magnetic_format_code, 30);
639: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 7, v_original_entered_amount);
640: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 8, v_open_entered_amount);
641: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 9, v_open_functional_amount);
642: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 10, v_drawee_name, 255);
643: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 11, v_drawee_number, 30);
644: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 12, v_drawee_taxpayer_id, 20);

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

637: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 5, v_currency_code, 15);
638: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 6, v_magnetic_format_code, 30);
639: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 7, v_original_entered_amount);
640: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 8, v_open_entered_amount);
641: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 9, v_open_functional_amount);
642: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 10, v_drawee_name, 255);
643: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 11, v_drawee_number, 30);
644: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 12, v_drawee_taxpayer_id, 20);
645: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 13, v_drawee_vat_reg_number, 50);

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

638: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 6, v_magnetic_format_code, 30);
639: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 7, v_original_entered_amount);
640: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 8, v_open_entered_amount);
641: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 9, v_open_functional_amount);
642: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 10, v_drawee_name, 255);
643: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 11, v_drawee_number, 30);
644: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 12, v_drawee_taxpayer_id, 20);
645: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 13, v_drawee_vat_reg_number, 50);
646: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 14, v_drawee_city, 60);

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

639: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 7, v_original_entered_amount);
640: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 8, v_open_entered_amount);
641: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 9, v_open_functional_amount);
642: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 10, v_drawee_name, 255);
643: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 11, v_drawee_number, 30);
644: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 12, v_drawee_taxpayer_id, 20);
645: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 13, v_drawee_vat_reg_number, 50);
646: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 14, v_drawee_city, 60);
647: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 15, v_drawee_state, 60);

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

640: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 8, v_open_entered_amount);
641: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 9, v_open_functional_amount);
642: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 10, v_drawee_name, 255);
643: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 11, v_drawee_number, 30);
644: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 12, v_drawee_taxpayer_id, 20);
645: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 13, v_drawee_vat_reg_number, 50);
646: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 14, v_drawee_city, 60);
647: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 15, v_drawee_state, 60);
648: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 16, v_drawee_country, 60);

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

641: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 9, v_open_functional_amount);
642: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 10, v_drawee_name, 255);
643: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 11, v_drawee_number, 30);
644: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 12, v_drawee_taxpayer_id, 20);
645: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 13, v_drawee_vat_reg_number, 50);
646: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 14, v_drawee_city, 60);
647: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 15, v_drawee_state, 60);
648: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 16, v_drawee_country, 60);
649: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 17, v_drawee_postal_code, 60);

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

642: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 10, v_drawee_name, 255);
643: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 11, v_drawee_number, 30);
644: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 12, v_drawee_taxpayer_id, 20);
645: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 13, v_drawee_vat_reg_number, 50);
646: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 14, v_drawee_city, 60);
647: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 15, v_drawee_state, 60);
648: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 16, v_drawee_country, 60);
649: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 17, v_drawee_postal_code, 60);
650: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 18, v_drawee_class, 80);

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

643: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 11, v_drawee_number, 30);
644: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 12, v_drawee_taxpayer_id, 20);
645: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 13, v_drawee_vat_reg_number, 50);
646: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 14, v_drawee_city, 60);
647: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 15, v_drawee_state, 60);
648: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 16, v_drawee_country, 60);
649: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 17, v_drawee_postal_code, 60);
650: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 18, v_drawee_class, 80);
651: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 19, v_drawee_category, 80);

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

644: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 12, v_drawee_taxpayer_id, 20);
645: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 13, v_drawee_vat_reg_number, 50);
646: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 14, v_drawee_city, 60);
647: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 15, v_drawee_state, 60);
648: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 16, v_drawee_country, 60);
649: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 17, v_drawee_postal_code, 60);
650: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 18, v_drawee_class, 80);
651: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 19, v_drawee_category, 80);
652: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 20, v_drawee_location, 40);

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

645: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 13, v_drawee_vat_reg_number, 50);
646: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 14, v_drawee_city, 60);
647: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 15, v_drawee_state, 60);
648: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 16, v_drawee_country, 60);
649: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 17, v_drawee_postal_code, 60);
650: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 18, v_drawee_class, 80);
651: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 19, v_drawee_category, 80);
652: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 20, v_drawee_location, 40);
653: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 21, v_issue_date);

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

646: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 14, v_drawee_city, 60);
647: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 15, v_drawee_state, 60);
648: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 16, v_drawee_country, 60);
649: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 17, v_drawee_postal_code, 60);
650: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 18, v_drawee_class, 80);
651: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 19, v_drawee_category, 80);
652: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 20, v_drawee_location, 40);
653: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 21, v_issue_date);
654: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 22, v_maturity_date);

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

647: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 15, v_drawee_state, 60);
648: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 16, v_drawee_country, 60);
649: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 17, v_drawee_postal_code, 60);
650: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 18, v_drawee_class, 80);
651: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 19, v_drawee_category, 80);
652: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 20, v_drawee_location, 40);
653: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 21, v_issue_date);
654: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 22, v_maturity_date);
655: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 23, v_issued_by_drawee, 1);

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

648: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 16, v_drawee_country, 60);
649: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 17, v_drawee_postal_code, 60);
650: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 18, v_drawee_class, 80);
651: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 19, v_drawee_category, 80);
652: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 20, v_drawee_location, 40);
653: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 21, v_issue_date);
654: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 22, v_maturity_date);
655: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 23, v_issued_by_drawee, 1);
656: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 24, v_signed_by_drawee, 1);

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

649: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 17, v_drawee_postal_code, 60);
650: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 18, v_drawee_class, 80);
651: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 19, v_drawee_category, 80);
652: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 20, v_drawee_location, 40);
653: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 21, v_issue_date);
654: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 22, v_maturity_date);
655: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 23, v_issued_by_drawee, 1);
656: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 24, v_signed_by_drawee, 1);
657: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 25, v_transaction_type, 20);

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

650: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 18, v_drawee_class, 80);
651: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 19, v_drawee_category, 80);
652: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 20, v_drawee_location, 40);
653: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 21, v_issue_date);
654: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 22, v_maturity_date);
655: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 23, v_issued_by_drawee, 1);
656: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 24, v_signed_by_drawee, 1);
657: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 25, v_transaction_type, 20);
658: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 26, v_remit_bank_name, 60);

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

651: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 19, v_drawee_category, 80);
652: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 20, v_drawee_location, 40);
653: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 21, v_issue_date);
654: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 22, v_maturity_date);
655: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 23, v_issued_by_drawee, 1);
656: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 24, v_signed_by_drawee, 1);
657: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 25, v_transaction_type, 20);
658: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 26, v_remit_bank_name, 60);
659: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 27, v_remit_bank_number, 30);

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

652: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 20, v_drawee_location, 40);
653: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 21, v_issue_date);
654: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 22, v_maturity_date);
655: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 23, v_issued_by_drawee, 1);
656: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 24, v_signed_by_drawee, 1);
657: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 25, v_transaction_type, 20);
658: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 26, v_remit_bank_name, 60);
659: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 27, v_remit_bank_number, 30);
660: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 28, v_remit_branch_name, 60);

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

653: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 21, v_issue_date);
654: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 22, v_maturity_date);
655: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 23, v_issued_by_drawee, 1);
656: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 24, v_signed_by_drawee, 1);
657: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 25, v_transaction_type, 20);
658: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 26, v_remit_bank_name, 60);
659: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 27, v_remit_bank_number, 30);
660: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 28, v_remit_branch_name, 60);
661: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 29, v_remit_branch_number, 25);

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

654: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 22, v_maturity_date);
655: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 23, v_issued_by_drawee, 1);
656: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 24, v_signed_by_drawee, 1);
657: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 25, v_transaction_type, 20);
658: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 26, v_remit_bank_name, 60);
659: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 27, v_remit_bank_number, 30);
660: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 28, v_remit_branch_name, 60);
661: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 29, v_remit_branch_number, 25);
662: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 30, v_remit_bank_acc_name, 80);

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

655: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 23, v_issued_by_drawee, 1);
656: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 24, v_signed_by_drawee, 1);
657: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 25, v_transaction_type, 20);
658: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 26, v_remit_bank_name, 60);
659: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 27, v_remit_bank_number, 30);
660: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 28, v_remit_branch_name, 60);
661: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 29, v_remit_branch_number, 25);
662: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 30, v_remit_bank_acc_name, 80);
663: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 31, v_remit_bank_acc_number, 30);

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

656: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 24, v_signed_by_drawee, 1);
657: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 25, v_transaction_type, 20);
658: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 26, v_remit_bank_name, 60);
659: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 27, v_remit_bank_number, 30);
660: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 28, v_remit_branch_name, 60);
661: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 29, v_remit_branch_number, 25);
662: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 30, v_remit_bank_acc_name, 80);
663: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 31, v_remit_bank_acc_number, 30);
664: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 32, v_remit_bank_acc_id);

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

657: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 25, v_transaction_type, 20);
658: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 26, v_remit_bank_name, 60);
659: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 27, v_remit_bank_number, 30);
660: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 28, v_remit_branch_name, 60);
661: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 29, v_remit_branch_number, 25);
662: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 30, v_remit_bank_acc_name, 80);
663: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 31, v_remit_bank_acc_number, 30);
664: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 32, v_remit_bank_acc_id);
665: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 33, v_remit_branch_city, 25);

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

658: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 26, v_remit_bank_name, 60);
659: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 27, v_remit_bank_number, 30);
660: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 28, v_remit_branch_name, 60);
661: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 29, v_remit_branch_number, 25);
662: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 30, v_remit_bank_acc_name, 80);
663: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 31, v_remit_bank_acc_number, 30);
664: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 32, v_remit_bank_acc_id);
665: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 33, v_remit_branch_city, 25);
666: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 34, v_remit_branch_state, 25);

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

659: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 27, v_remit_bank_number, 30);
660: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 28, v_remit_branch_name, 60);
661: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 29, v_remit_branch_number, 25);
662: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 30, v_remit_bank_acc_name, 80);
663: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 31, v_remit_bank_acc_number, 30);
664: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 32, v_remit_bank_acc_id);
665: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 33, v_remit_branch_city, 25);
666: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 34, v_remit_branch_state, 25);
667: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 35, v_remit_branch_country, 25);

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

660: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 28, v_remit_branch_name, 60);
661: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 29, v_remit_branch_number, 25);
662: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 30, v_remit_bank_acc_name, 80);
663: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 31, v_remit_bank_acc_number, 30);
664: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 32, v_remit_bank_acc_id);
665: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 33, v_remit_branch_city, 25);
666: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 34, v_remit_branch_state, 25);
667: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 35, v_remit_branch_country, 25);
668: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 36, v_remit_branch_postal_code, 20);

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

661: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 29, v_remit_branch_number, 25);
662: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 30, v_remit_bank_acc_name, 80);
663: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 31, v_remit_bank_acc_number, 30);
664: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 32, v_remit_bank_acc_id);
665: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 33, v_remit_branch_city, 25);
666: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 34, v_remit_branch_state, 25);
667: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 35, v_remit_branch_country, 25);
668: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 36, v_remit_branch_postal_code, 20);
669: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 37, v_remit_branch_address1, 35);

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

662: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 30, v_remit_bank_acc_name, 80);
663: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 31, v_remit_bank_acc_number, 30);
664: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 32, v_remit_bank_acc_id);
665: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 33, v_remit_branch_city, 25);
666: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 34, v_remit_branch_state, 25);
667: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 35, v_remit_branch_country, 25);
668: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 36, v_remit_branch_postal_code, 20);
669: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 37, v_remit_branch_address1, 35);
670: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 38, v_remit_branch_address2, 35);

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

663: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 31, v_remit_bank_acc_number, 30);
664: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 32, v_remit_bank_acc_id);
665: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 33, v_remit_branch_city, 25);
666: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 34, v_remit_branch_state, 25);
667: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 35, v_remit_branch_country, 25);
668: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 36, v_remit_branch_postal_code, 20);
669: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 37, v_remit_branch_address1, 35);
670: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 38, v_remit_branch_address2, 35);
671: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 39, v_remit_branch_address3, 35);

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

664: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 32, v_remit_bank_acc_id);
665: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 33, v_remit_branch_city, 25);
666: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 34, v_remit_branch_state, 25);
667: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 35, v_remit_branch_country, 25);
668: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 36, v_remit_branch_postal_code, 20);
669: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 37, v_remit_branch_address1, 35);
670: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 38, v_remit_branch_address2, 35);
671: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 39, v_remit_branch_address3, 35);
672: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 40, v_remit_bank_allow_override, 1);

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

665: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 33, v_remit_branch_city, 25);
666: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 34, v_remit_branch_state, 25);
667: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 35, v_remit_branch_country, 25);
668: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 36, v_remit_branch_postal_code, 20);
669: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 37, v_remit_branch_address1, 35);
670: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 38, v_remit_branch_address2, 35);
671: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 39, v_remit_branch_address3, 35);
672: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 40, v_remit_bank_allow_override, 1);
673: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 41, v_remit_bank_acc_check_digits, 30);

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

666: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 34, v_remit_branch_state, 25);
667: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 35, v_remit_branch_country, 25);
668: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 36, v_remit_branch_postal_code, 20);
669: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 37, v_remit_branch_address1, 35);
670: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 38, v_remit_branch_address2, 35);
671: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 39, v_remit_branch_address3, 35);
672: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 40, v_remit_bank_allow_override, 1);
673: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 41, v_remit_bank_acc_check_digits, 30);
674: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 42, v_remit_bank_acc_curr, 15);

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

667: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 35, v_remit_branch_country, 25);
668: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 36, v_remit_branch_postal_code, 20);
669: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 37, v_remit_branch_address1, 35);
670: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 38, v_remit_branch_address2, 35);
671: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 39, v_remit_branch_address3, 35);
672: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 40, v_remit_bank_allow_override, 1);
673: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 41, v_remit_bank_acc_check_digits, 30);
674: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 42, v_remit_bank_acc_curr, 15);
675: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 43, v_drawee_bank_name, 60);

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

668: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 36, v_remit_branch_postal_code, 20);
669: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 37, v_remit_branch_address1, 35);
670: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 38, v_remit_branch_address2, 35);
671: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 39, v_remit_branch_address3, 35);
672: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 40, v_remit_bank_allow_override, 1);
673: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 41, v_remit_bank_acc_check_digits, 30);
674: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 42, v_remit_bank_acc_curr, 15);
675: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 43, v_drawee_bank_name, 60);
676: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 44, v_drawee_bank_number, 30);

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

669: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 37, v_remit_branch_address1, 35);
670: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 38, v_remit_branch_address2, 35);
671: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 39, v_remit_branch_address3, 35);
672: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 40, v_remit_bank_allow_override, 1);
673: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 41, v_remit_bank_acc_check_digits, 30);
674: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 42, v_remit_bank_acc_curr, 15);
675: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 43, v_drawee_bank_name, 60);
676: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 44, v_drawee_bank_number, 30);
677: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 45, v_drawee_branch_name, 60);

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

670: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 38, v_remit_branch_address2, 35);
671: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 39, v_remit_branch_address3, 35);
672: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 40, v_remit_bank_allow_override, 1);
673: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 41, v_remit_bank_acc_check_digits, 30);
674: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 42, v_remit_bank_acc_curr, 15);
675: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 43, v_drawee_bank_name, 60);
676: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 44, v_drawee_bank_number, 30);
677: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 45, v_drawee_branch_name, 60);
678: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 46, v_drawee_branch_number, 25);

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

671: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 39, v_remit_branch_address3, 35);
672: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 40, v_remit_bank_allow_override, 1);
673: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 41, v_remit_bank_acc_check_digits, 30);
674: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 42, v_remit_bank_acc_curr, 15);
675: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 43, v_drawee_bank_name, 60);
676: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 44, v_drawee_bank_number, 30);
677: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 45, v_drawee_branch_name, 60);
678: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 46, v_drawee_branch_number, 25);
679: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 47, v_drawee_bank_acc_name, 80);

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

672: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 40, v_remit_bank_allow_override, 1);
673: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 41, v_remit_bank_acc_check_digits, 30);
674: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 42, v_remit_bank_acc_curr, 15);
675: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 43, v_drawee_bank_name, 60);
676: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 44, v_drawee_bank_number, 30);
677: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 45, v_drawee_branch_name, 60);
678: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 46, v_drawee_branch_number, 25);
679: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 47, v_drawee_bank_acc_name, 80);
680: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 48, v_drawee_bank_acc_number, 30);

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

673: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 41, v_remit_bank_acc_check_digits, 30);
674: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 42, v_remit_bank_acc_curr, 15);
675: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 43, v_drawee_bank_name, 60);
676: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 44, v_drawee_bank_number, 30);
677: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 45, v_drawee_branch_name, 60);
678: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 46, v_drawee_branch_number, 25);
679: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 47, v_drawee_bank_acc_name, 80);
680: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 48, v_drawee_bank_acc_number, 30);
681: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 49, v_drawee_branch_city, 25);

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

674: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 42, v_remit_bank_acc_curr, 15);
675: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 43, v_drawee_bank_name, 60);
676: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 44, v_drawee_bank_number, 30);
677: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 45, v_drawee_branch_name, 60);
678: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 46, v_drawee_branch_number, 25);
679: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 47, v_drawee_bank_acc_name, 80);
680: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 48, v_drawee_bank_acc_number, 30);
681: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 49, v_drawee_branch_city, 25);
682: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 50, v_drawee_branch_state, 25);

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

675: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 43, v_drawee_bank_name, 60);
676: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 44, v_drawee_bank_number, 30);
677: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 45, v_drawee_branch_name, 60);
678: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 46, v_drawee_branch_number, 25);
679: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 47, v_drawee_bank_acc_name, 80);
680: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 48, v_drawee_bank_acc_number, 30);
681: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 49, v_drawee_branch_city, 25);
682: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 50, v_drawee_branch_state, 25);
683: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 51, v_drawee_branch_country, 25);

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

676: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 44, v_drawee_bank_number, 30);
677: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 45, v_drawee_branch_name, 60);
678: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 46, v_drawee_branch_number, 25);
679: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 47, v_drawee_bank_acc_name, 80);
680: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 48, v_drawee_bank_acc_number, 30);
681: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 49, v_drawee_branch_city, 25);
682: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 50, v_drawee_branch_state, 25);
683: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 51, v_drawee_branch_country, 25);
684: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 52, v_drawee_branch_postal_code, 20);

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

677: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 45, v_drawee_branch_name, 60);
678: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 46, v_drawee_branch_number, 25);
679: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 47, v_drawee_bank_acc_name, 80);
680: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 48, v_drawee_bank_acc_number, 30);
681: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 49, v_drawee_branch_city, 25);
682: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 50, v_drawee_branch_state, 25);
683: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 51, v_drawee_branch_country, 25);
684: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 52, v_drawee_branch_postal_code, 20);
685: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 53, v_drawee_branch_address1, 35);

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

678: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 46, v_drawee_branch_number, 25);
679: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 47, v_drawee_bank_acc_name, 80);
680: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 48, v_drawee_bank_acc_number, 30);
681: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 49, v_drawee_branch_city, 25);
682: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 50, v_drawee_branch_state, 25);
683: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 51, v_drawee_branch_country, 25);
684: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 52, v_drawee_branch_postal_code, 20);
685: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 53, v_drawee_branch_address1, 35);
686: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 54, v_drawee_branch_address2, 35);

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

679: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 47, v_drawee_bank_acc_name, 80);
680: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 48, v_drawee_bank_acc_number, 30);
681: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 49, v_drawee_branch_city, 25);
682: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 50, v_drawee_branch_state, 25);
683: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 51, v_drawee_branch_country, 25);
684: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 52, v_drawee_branch_postal_code, 20);
685: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 53, v_drawee_branch_address1, 35);
686: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 54, v_drawee_branch_address2, 35);
687: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 55, v_drawee_branch_address3, 35);

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

680: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 48, v_drawee_bank_acc_number, 30);
681: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 49, v_drawee_branch_city, 25);
682: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 50, v_drawee_branch_state, 25);
683: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 51, v_drawee_branch_country, 25);
684: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 52, v_drawee_branch_postal_code, 20);
685: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 53, v_drawee_branch_address1, 35);
686: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 54, v_drawee_branch_address2, 35);
687: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 55, v_drawee_branch_address3, 35);
688: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 56, v_drawee_bank_acc_check_digits, 30);

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

681: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 49, v_drawee_branch_city, 25);
682: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 50, v_drawee_branch_state, 25);
683: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 51, v_drawee_branch_country, 25);
684: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 52, v_drawee_branch_postal_code, 20);
685: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 53, v_drawee_branch_address1, 35);
686: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 54, v_drawee_branch_address2, 35);
687: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 55, v_drawee_branch_address3, 35);
688: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 56, v_drawee_bank_acc_check_digits, 30);
689: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 57, v_drawee_bank_acc_curr, 15);

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

682: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 50, v_drawee_branch_state, 25);
683: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 51, v_drawee_branch_country, 25);
684: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 52, v_drawee_branch_postal_code, 20);
685: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 53, v_drawee_branch_address1, 35);
686: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 54, v_drawee_branch_address2, 35);
687: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 55, v_drawee_branch_address3, 35);
688: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 56, v_drawee_bank_acc_check_digits, 30);
689: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 57, v_drawee_bank_acc_curr, 15);
690: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 58, v_comments, 240);

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

683: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 51, v_drawee_branch_country, 25);
684: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 52, v_drawee_branch_postal_code, 20);
685: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 53, v_drawee_branch_address1, 35);
686: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 54, v_drawee_branch_address2, 35);
687: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 55, v_drawee_branch_address3, 35);
688: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 56, v_drawee_bank_acc_check_digits, 30);
689: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 57, v_drawee_bank_acc_curr, 15);
690: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 58, v_comments, 240);
691: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 59, v_days_late);

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

684: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 52, v_drawee_branch_postal_code, 20);
685: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 53, v_drawee_branch_address1, 35);
686: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 54, v_drawee_branch_address2, 35);
687: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 55, v_drawee_branch_address3, 35);
688: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 56, v_drawee_bank_acc_check_digits, 30);
689: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 57, v_drawee_bank_acc_curr, 15);
690: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 58, v_comments, 240);
691: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 59, v_days_late);
692: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 60, v_last_printed_date);

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

685: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 53, v_drawee_branch_address1, 35);
686: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 54, v_drawee_branch_address2, 35);
687: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 55, v_drawee_branch_address3, 35);
688: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 56, v_drawee_bank_acc_check_digits, 30);
689: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 57, v_drawee_bank_acc_curr, 15);
690: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 58, v_comments, 240);
691: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 59, v_days_late);
692: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 60, v_last_printed_date);
693: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 61, v_drawee_address1, 240);

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

686: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 54, v_drawee_branch_address2, 35);
687: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 55, v_drawee_branch_address3, 35);
688: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 56, v_drawee_bank_acc_check_digits, 30);
689: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 57, v_drawee_bank_acc_curr, 15);
690: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 58, v_comments, 240);
691: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 59, v_days_late);
692: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 60, v_last_printed_date);
693: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 61, v_drawee_address1, 240);
694: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 62, v_drawee_address2, 240);

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

687: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 55, v_drawee_branch_address3, 35);
688: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 56, v_drawee_bank_acc_check_digits, 30);
689: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 57, v_drawee_bank_acc_curr, 15);
690: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 58, v_comments, 240);
691: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 59, v_days_late);
692: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 60, v_last_printed_date);
693: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 61, v_drawee_address1, 240);
694: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 62, v_drawee_address2, 240);
695: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 63, v_drawee_address3, 240);

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

688: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 56, v_drawee_bank_acc_check_digits, 30);
689: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 57, v_drawee_bank_acc_curr, 15);
690: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 58, v_comments, 240);
691: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 59, v_days_late);
692: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 60, v_last_printed_date);
693: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 61, v_drawee_address1, 240);
694: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 62, v_drawee_address2, 240);
695: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 63, v_drawee_address3, 240);
696: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 64, v_drawee_contact, 100);

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

689: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 57, v_drawee_bank_acc_curr, 15);
690: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 58, v_comments, 240);
691: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 59, v_days_late);
692: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 60, v_last_printed_date);
693: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 61, v_drawee_address1, 240);
694: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 62, v_drawee_address2, 240);
695: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 63, v_drawee_address3, 240);
696: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 64, v_drawee_contact, 100);
697: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 65, v_special_instructions, 240);

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

690: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 58, v_comments, 240);
691: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 59, v_days_late);
692: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 60, v_last_printed_date);
693: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 61, v_drawee_address1, 240);
694: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 62, v_drawee_address2, 240);
695: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 63, v_drawee_address3, 240);
696: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 64, v_drawee_contact, 100);
697: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 65, v_special_instructions, 240);
698: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 66, v_status_code, 30);

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

691: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 59, v_days_late);
692: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 60, v_last_printed_date);
693: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 61, v_drawee_address1, 240);
694: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 62, v_drawee_address2, 240);
695: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 63, v_drawee_address3, 240);
696: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 64, v_drawee_contact, 100);
697: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 65, v_special_instructions, 240);
698: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 66, v_status_code, 30);
699: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 67, v_creation_batch_name, 50);

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

692: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 60, v_last_printed_date);
693: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 61, v_drawee_address1, 240);
694: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 62, v_drawee_address2, 240);
695: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 63, v_drawee_address3, 240);
696: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 64, v_drawee_contact, 100);
697: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 65, v_special_instructions, 240);
698: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 66, v_status_code, 30);
699: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 67, v_creation_batch_name, 50);
700: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 68, v_transaction_batch_source, 50);

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

693: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 61, v_drawee_address1, 240);
694: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 62, v_drawee_address2, 240);
695: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 63, v_drawee_address3, 240);
696: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 64, v_drawee_contact, 100);
697: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 65, v_special_instructions, 240);
698: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 66, v_status_code, 30);
699: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 67, v_creation_batch_name, 50);
700: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 68, v_transaction_batch_source, 50);
701: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 69, v_ps_exchange_rate);

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

694: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 62, v_drawee_address2, 240);
695: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 63, v_drawee_address3, 240);
696: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 64, v_drawee_contact, 100);
697: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 65, v_special_instructions, 240);
698: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 66, v_status_code, 30);
699: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 67, v_creation_batch_name, 50);
700: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 68, v_transaction_batch_source, 50);
701: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 69, v_ps_exchange_rate);
702:

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

695: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 63, v_drawee_address3, 240);
696: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 64, v_drawee_contact, 100);
697: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 65, v_special_instructions, 240);
698: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 66, v_status_code, 30);
699: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 67, v_creation_batch_name, 50);
700: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 68, v_transaction_batch_source, 50);
701: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 69, v_ps_exchange_rate);
702:
703:

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

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

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

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

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

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

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

709: LOOP
710:
711: -- Fetch the rows into the buffer, and also check for the exit
712: -- condition from the loop.
713: IF DBMS_SQL.FETCH_ROWS(v_CursorID_main) = 0 THEN
714: EXIT;
715: END IF;
716:
717: -- Retrieve the rows from the buffer into PL/SQL variables.

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

714: EXIT;
715: END IF;
716:
717: -- Retrieve the rows from the buffer into PL/SQL variables.
718: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 1, v_customer_trx_id);
719: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 2, v_transaction_number);
720: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 3, v_document_number);
721: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 4, v_document_sequence_name);
722: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 5, v_currency_code);

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

715: END IF;
716:
717: -- Retrieve the rows from the buffer into PL/SQL variables.
718: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 1, v_customer_trx_id);
719: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 2, v_transaction_number);
720: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 3, v_document_number);
721: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 4, v_document_sequence_name);
722: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 5, v_currency_code);
723: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 6, v_magnetic_format_code);

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

716:
717: -- Retrieve the rows from the buffer into PL/SQL variables.
718: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 1, v_customer_trx_id);
719: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 2, v_transaction_number);
720: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 3, v_document_number);
721: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 4, v_document_sequence_name);
722: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 5, v_currency_code);
723: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 6, v_magnetic_format_code);
724: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 7, v_original_entered_amount);

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

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

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

718: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 1, v_customer_trx_id);
719: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 2, v_transaction_number);
720: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 3, v_document_number);
721: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 4, v_document_sequence_name);
722: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 5, v_currency_code);
723: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 6, v_magnetic_format_code);
724: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 7, v_original_entered_amount);
725: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 8, v_open_entered_amount);
726: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 9, v_open_functional_amount);

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

719: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 2, v_transaction_number);
720: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 3, v_document_number);
721: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 4, v_document_sequence_name);
722: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 5, v_currency_code);
723: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 6, v_magnetic_format_code);
724: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 7, v_original_entered_amount);
725: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 8, v_open_entered_amount);
726: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 9, v_open_functional_amount);
727: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 10, v_drawee_name);

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

720: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 3, v_document_number);
721: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 4, v_document_sequence_name);
722: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 5, v_currency_code);
723: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 6, v_magnetic_format_code);
724: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 7, v_original_entered_amount);
725: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 8, v_open_entered_amount);
726: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 9, v_open_functional_amount);
727: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 10, v_drawee_name);
728: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 11, v_drawee_number);

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

721: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 4, v_document_sequence_name);
722: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 5, v_currency_code);
723: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 6, v_magnetic_format_code);
724: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 7, v_original_entered_amount);
725: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 8, v_open_entered_amount);
726: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 9, v_open_functional_amount);
727: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 10, v_drawee_name);
728: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 11, v_drawee_number);
729: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 12, v_drawee_taxpayer_id);

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

722: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 5, v_currency_code);
723: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 6, v_magnetic_format_code);
724: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 7, v_original_entered_amount);
725: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 8, v_open_entered_amount);
726: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 9, v_open_functional_amount);
727: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 10, v_drawee_name);
728: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 11, v_drawee_number);
729: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 12, v_drawee_taxpayer_id);
730: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 13, v_drawee_vat_reg_number);

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

723: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 6, v_magnetic_format_code);
724: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 7, v_original_entered_amount);
725: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 8, v_open_entered_amount);
726: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 9, v_open_functional_amount);
727: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 10, v_drawee_name);
728: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 11, v_drawee_number);
729: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 12, v_drawee_taxpayer_id);
730: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 13, v_drawee_vat_reg_number);
731: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 14, v_drawee_city);

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

724: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 7, v_original_entered_amount);
725: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 8, v_open_entered_amount);
726: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 9, v_open_functional_amount);
727: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 10, v_drawee_name);
728: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 11, v_drawee_number);
729: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 12, v_drawee_taxpayer_id);
730: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 13, v_drawee_vat_reg_number);
731: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 14, v_drawee_city);
732: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 15, v_drawee_state);

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

725: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 8, v_open_entered_amount);
726: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 9, v_open_functional_amount);
727: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 10, v_drawee_name);
728: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 11, v_drawee_number);
729: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 12, v_drawee_taxpayer_id);
730: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 13, v_drawee_vat_reg_number);
731: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 14, v_drawee_city);
732: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 15, v_drawee_state);
733: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 16, v_drawee_country);

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

726: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 9, v_open_functional_amount);
727: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 10, v_drawee_name);
728: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 11, v_drawee_number);
729: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 12, v_drawee_taxpayer_id);
730: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 13, v_drawee_vat_reg_number);
731: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 14, v_drawee_city);
732: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 15, v_drawee_state);
733: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 16, v_drawee_country);
734: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 17, v_drawee_postal_code);

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

727: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 10, v_drawee_name);
728: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 11, v_drawee_number);
729: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 12, v_drawee_taxpayer_id);
730: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 13, v_drawee_vat_reg_number);
731: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 14, v_drawee_city);
732: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 15, v_drawee_state);
733: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 16, v_drawee_country);
734: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 17, v_drawee_postal_code);
735: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 18, v_drawee_class);

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

728: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 11, v_drawee_number);
729: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 12, v_drawee_taxpayer_id);
730: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 13, v_drawee_vat_reg_number);
731: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 14, v_drawee_city);
732: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 15, v_drawee_state);
733: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 16, v_drawee_country);
734: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 17, v_drawee_postal_code);
735: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 18, v_drawee_class);
736: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 19, v_drawee_category);

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

729: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 12, v_drawee_taxpayer_id);
730: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 13, v_drawee_vat_reg_number);
731: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 14, v_drawee_city);
732: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 15, v_drawee_state);
733: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 16, v_drawee_country);
734: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 17, v_drawee_postal_code);
735: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 18, v_drawee_class);
736: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 19, v_drawee_category);
737: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 20, v_drawee_location);

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

730: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 13, v_drawee_vat_reg_number);
731: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 14, v_drawee_city);
732: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 15, v_drawee_state);
733: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 16, v_drawee_country);
734: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 17, v_drawee_postal_code);
735: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 18, v_drawee_class);
736: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 19, v_drawee_category);
737: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 20, v_drawee_location);
738: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 21, v_issue_date);

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

731: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 14, v_drawee_city);
732: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 15, v_drawee_state);
733: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 16, v_drawee_country);
734: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 17, v_drawee_postal_code);
735: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 18, v_drawee_class);
736: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 19, v_drawee_category);
737: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 20, v_drawee_location);
738: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 21, v_issue_date);
739: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 22, v_maturity_date);

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

732: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 15, v_drawee_state);
733: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 16, v_drawee_country);
734: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 17, v_drawee_postal_code);
735: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 18, v_drawee_class);
736: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 19, v_drawee_category);
737: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 20, v_drawee_location);
738: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 21, v_issue_date);
739: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 22, v_maturity_date);
740: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 23, v_issued_by_drawee);

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

733: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 16, v_drawee_country);
734: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 17, v_drawee_postal_code);
735: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 18, v_drawee_class);
736: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 19, v_drawee_category);
737: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 20, v_drawee_location);
738: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 21, v_issue_date);
739: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 22, v_maturity_date);
740: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 23, v_issued_by_drawee);
741: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 24, v_signed_by_drawee);

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

734: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 17, v_drawee_postal_code);
735: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 18, v_drawee_class);
736: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 19, v_drawee_category);
737: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 20, v_drawee_location);
738: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 21, v_issue_date);
739: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 22, v_maturity_date);
740: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 23, v_issued_by_drawee);
741: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 24, v_signed_by_drawee);
742: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 25, v_transaction_type);

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

735: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 18, v_drawee_class);
736: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 19, v_drawee_category);
737: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 20, v_drawee_location);
738: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 21, v_issue_date);
739: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 22, v_maturity_date);
740: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 23, v_issued_by_drawee);
741: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 24, v_signed_by_drawee);
742: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 25, v_transaction_type);
743: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 26, v_remit_bank_name);

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

736: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 19, v_drawee_category);
737: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 20, v_drawee_location);
738: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 21, v_issue_date);
739: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 22, v_maturity_date);
740: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 23, v_issued_by_drawee);
741: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 24, v_signed_by_drawee);
742: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 25, v_transaction_type);
743: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 26, v_remit_bank_name);
744: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 27, v_remit_bank_number);

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

737: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 20, v_drawee_location);
738: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 21, v_issue_date);
739: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 22, v_maturity_date);
740: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 23, v_issued_by_drawee);
741: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 24, v_signed_by_drawee);
742: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 25, v_transaction_type);
743: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 26, v_remit_bank_name);
744: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 27, v_remit_bank_number);
745: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 28, v_remit_branch_name);

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

738: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 21, v_issue_date);
739: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 22, v_maturity_date);
740: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 23, v_issued_by_drawee);
741: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 24, v_signed_by_drawee);
742: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 25, v_transaction_type);
743: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 26, v_remit_bank_name);
744: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 27, v_remit_bank_number);
745: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 28, v_remit_branch_name);
746: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 29, v_remit_branch_number);

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

739: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 22, v_maturity_date);
740: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 23, v_issued_by_drawee);
741: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 24, v_signed_by_drawee);
742: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 25, v_transaction_type);
743: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 26, v_remit_bank_name);
744: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 27, v_remit_bank_number);
745: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 28, v_remit_branch_name);
746: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 29, v_remit_branch_number);
747: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 30, v_remit_bank_acc_name);

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

740: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 23, v_issued_by_drawee);
741: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 24, v_signed_by_drawee);
742: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 25, v_transaction_type);
743: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 26, v_remit_bank_name);
744: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 27, v_remit_bank_number);
745: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 28, v_remit_branch_name);
746: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 29, v_remit_branch_number);
747: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 30, v_remit_bank_acc_name);
748: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 31, v_remit_bank_acc_number);

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

741: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 24, v_signed_by_drawee);
742: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 25, v_transaction_type);
743: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 26, v_remit_bank_name);
744: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 27, v_remit_bank_number);
745: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 28, v_remit_branch_name);
746: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 29, v_remit_branch_number);
747: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 30, v_remit_bank_acc_name);
748: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 31, v_remit_bank_acc_number);
749: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 32, v_remit_bank_acc_id);

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

742: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 25, v_transaction_type);
743: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 26, v_remit_bank_name);
744: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 27, v_remit_bank_number);
745: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 28, v_remit_branch_name);
746: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 29, v_remit_branch_number);
747: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 30, v_remit_bank_acc_name);
748: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 31, v_remit_bank_acc_number);
749: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 32, v_remit_bank_acc_id);
750: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 33, v_remit_branch_city);

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

743: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 26, v_remit_bank_name);
744: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 27, v_remit_bank_number);
745: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 28, v_remit_branch_name);
746: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 29, v_remit_branch_number);
747: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 30, v_remit_bank_acc_name);
748: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 31, v_remit_bank_acc_number);
749: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 32, v_remit_bank_acc_id);
750: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 33, v_remit_branch_city);
751: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 34, v_remit_branch_state);

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

744: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 27, v_remit_bank_number);
745: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 28, v_remit_branch_name);
746: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 29, v_remit_branch_number);
747: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 30, v_remit_bank_acc_name);
748: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 31, v_remit_bank_acc_number);
749: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 32, v_remit_bank_acc_id);
750: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 33, v_remit_branch_city);
751: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 34, v_remit_branch_state);
752: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 35, v_remit_branch_country);

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

745: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 28, v_remit_branch_name);
746: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 29, v_remit_branch_number);
747: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 30, v_remit_bank_acc_name);
748: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 31, v_remit_bank_acc_number);
749: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 32, v_remit_bank_acc_id);
750: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 33, v_remit_branch_city);
751: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 34, v_remit_branch_state);
752: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 35, v_remit_branch_country);
753: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 36, v_remit_branch_postal_code);

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

746: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 29, v_remit_branch_number);
747: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 30, v_remit_bank_acc_name);
748: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 31, v_remit_bank_acc_number);
749: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 32, v_remit_bank_acc_id);
750: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 33, v_remit_branch_city);
751: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 34, v_remit_branch_state);
752: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 35, v_remit_branch_country);
753: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 36, v_remit_branch_postal_code);
754: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 37, v_remit_branch_address1);

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

747: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 30, v_remit_bank_acc_name);
748: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 31, v_remit_bank_acc_number);
749: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 32, v_remit_bank_acc_id);
750: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 33, v_remit_branch_city);
751: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 34, v_remit_branch_state);
752: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 35, v_remit_branch_country);
753: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 36, v_remit_branch_postal_code);
754: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 37, v_remit_branch_address1);
755: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 38, v_remit_branch_address2);

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

748: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 31, v_remit_bank_acc_number);
749: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 32, v_remit_bank_acc_id);
750: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 33, v_remit_branch_city);
751: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 34, v_remit_branch_state);
752: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 35, v_remit_branch_country);
753: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 36, v_remit_branch_postal_code);
754: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 37, v_remit_branch_address1);
755: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 38, v_remit_branch_address2);
756: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 39, v_remit_branch_address3);

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

749: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 32, v_remit_bank_acc_id);
750: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 33, v_remit_branch_city);
751: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 34, v_remit_branch_state);
752: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 35, v_remit_branch_country);
753: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 36, v_remit_branch_postal_code);
754: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 37, v_remit_branch_address1);
755: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 38, v_remit_branch_address2);
756: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 39, v_remit_branch_address3);
757: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 40, v_remit_bank_allow_override);

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

750: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 33, v_remit_branch_city);
751: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 34, v_remit_branch_state);
752: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 35, v_remit_branch_country);
753: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 36, v_remit_branch_postal_code);
754: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 37, v_remit_branch_address1);
755: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 38, v_remit_branch_address2);
756: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 39, v_remit_branch_address3);
757: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 40, v_remit_bank_allow_override);
758: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 41, v_remit_bank_acc_check_digits);

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

751: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 34, v_remit_branch_state);
752: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 35, v_remit_branch_country);
753: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 36, v_remit_branch_postal_code);
754: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 37, v_remit_branch_address1);
755: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 38, v_remit_branch_address2);
756: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 39, v_remit_branch_address3);
757: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 40, v_remit_bank_allow_override);
758: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 41, v_remit_bank_acc_check_digits);
759: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 42, v_remit_bank_acc_curr);

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

752: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 35, v_remit_branch_country);
753: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 36, v_remit_branch_postal_code);
754: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 37, v_remit_branch_address1);
755: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 38, v_remit_branch_address2);
756: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 39, v_remit_branch_address3);
757: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 40, v_remit_bank_allow_override);
758: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 41, v_remit_bank_acc_check_digits);
759: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 42, v_remit_bank_acc_curr);
760: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 43, v_drawee_bank_name);

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

753: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 36, v_remit_branch_postal_code);
754: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 37, v_remit_branch_address1);
755: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 38, v_remit_branch_address2);
756: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 39, v_remit_branch_address3);
757: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 40, v_remit_bank_allow_override);
758: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 41, v_remit_bank_acc_check_digits);
759: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 42, v_remit_bank_acc_curr);
760: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 43, v_drawee_bank_name);
761: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 44, v_drawee_bank_number);

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

754: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 37, v_remit_branch_address1);
755: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 38, v_remit_branch_address2);
756: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 39, v_remit_branch_address3);
757: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 40, v_remit_bank_allow_override);
758: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 41, v_remit_bank_acc_check_digits);
759: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 42, v_remit_bank_acc_curr);
760: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 43, v_drawee_bank_name);
761: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 44, v_drawee_bank_number);
762: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 45, v_drawee_branch_name);

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

755: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 38, v_remit_branch_address2);
756: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 39, v_remit_branch_address3);
757: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 40, v_remit_bank_allow_override);
758: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 41, v_remit_bank_acc_check_digits);
759: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 42, v_remit_bank_acc_curr);
760: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 43, v_drawee_bank_name);
761: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 44, v_drawee_bank_number);
762: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 45, v_drawee_branch_name);
763: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 46, v_drawee_branch_number);

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

756: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 39, v_remit_branch_address3);
757: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 40, v_remit_bank_allow_override);
758: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 41, v_remit_bank_acc_check_digits);
759: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 42, v_remit_bank_acc_curr);
760: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 43, v_drawee_bank_name);
761: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 44, v_drawee_bank_number);
762: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 45, v_drawee_branch_name);
763: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 46, v_drawee_branch_number);
764: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 47, v_drawee_bank_acc_name);

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

757: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 40, v_remit_bank_allow_override);
758: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 41, v_remit_bank_acc_check_digits);
759: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 42, v_remit_bank_acc_curr);
760: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 43, v_drawee_bank_name);
761: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 44, v_drawee_bank_number);
762: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 45, v_drawee_branch_name);
763: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 46, v_drawee_branch_number);
764: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 47, v_drawee_bank_acc_name);
765: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 48, v_drawee_bank_acc_number);

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

758: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 41, v_remit_bank_acc_check_digits);
759: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 42, v_remit_bank_acc_curr);
760: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 43, v_drawee_bank_name);
761: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 44, v_drawee_bank_number);
762: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 45, v_drawee_branch_name);
763: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 46, v_drawee_branch_number);
764: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 47, v_drawee_bank_acc_name);
765: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 48, v_drawee_bank_acc_number);
766: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 49, v_drawee_branch_city);

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

759: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 42, v_remit_bank_acc_curr);
760: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 43, v_drawee_bank_name);
761: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 44, v_drawee_bank_number);
762: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 45, v_drawee_branch_name);
763: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 46, v_drawee_branch_number);
764: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 47, v_drawee_bank_acc_name);
765: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 48, v_drawee_bank_acc_number);
766: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 49, v_drawee_branch_city);
767: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 50, v_drawee_branch_state);

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

760: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 43, v_drawee_bank_name);
761: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 44, v_drawee_bank_number);
762: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 45, v_drawee_branch_name);
763: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 46, v_drawee_branch_number);
764: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 47, v_drawee_bank_acc_name);
765: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 48, v_drawee_bank_acc_number);
766: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 49, v_drawee_branch_city);
767: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 50, v_drawee_branch_state);
768: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 51, v_drawee_branch_country);

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

761: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 44, v_drawee_bank_number);
762: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 45, v_drawee_branch_name);
763: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 46, v_drawee_branch_number);
764: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 47, v_drawee_bank_acc_name);
765: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 48, v_drawee_bank_acc_number);
766: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 49, v_drawee_branch_city);
767: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 50, v_drawee_branch_state);
768: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 51, v_drawee_branch_country);
769: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 52, v_drawee_branch_postal_code);

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

762: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 45, v_drawee_branch_name);
763: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 46, v_drawee_branch_number);
764: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 47, v_drawee_bank_acc_name);
765: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 48, v_drawee_bank_acc_number);
766: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 49, v_drawee_branch_city);
767: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 50, v_drawee_branch_state);
768: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 51, v_drawee_branch_country);
769: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 52, v_drawee_branch_postal_code);
770: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 53, v_drawee_branch_address1);

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

763: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 46, v_drawee_branch_number);
764: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 47, v_drawee_bank_acc_name);
765: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 48, v_drawee_bank_acc_number);
766: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 49, v_drawee_branch_city);
767: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 50, v_drawee_branch_state);
768: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 51, v_drawee_branch_country);
769: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 52, v_drawee_branch_postal_code);
770: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 53, v_drawee_branch_address1);
771: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 54, v_drawee_branch_address2);

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

764: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 47, v_drawee_bank_acc_name);
765: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 48, v_drawee_bank_acc_number);
766: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 49, v_drawee_branch_city);
767: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 50, v_drawee_branch_state);
768: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 51, v_drawee_branch_country);
769: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 52, v_drawee_branch_postal_code);
770: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 53, v_drawee_branch_address1);
771: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 54, v_drawee_branch_address2);
772: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 55, v_drawee_branch_address3);

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

765: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 48, v_drawee_bank_acc_number);
766: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 49, v_drawee_branch_city);
767: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 50, v_drawee_branch_state);
768: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 51, v_drawee_branch_country);
769: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 52, v_drawee_branch_postal_code);
770: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 53, v_drawee_branch_address1);
771: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 54, v_drawee_branch_address2);
772: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 55, v_drawee_branch_address3);
773: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 56, v_drawee_bank_acc_check_digits);

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

766: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 49, v_drawee_branch_city);
767: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 50, v_drawee_branch_state);
768: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 51, v_drawee_branch_country);
769: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 52, v_drawee_branch_postal_code);
770: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 53, v_drawee_branch_address1);
771: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 54, v_drawee_branch_address2);
772: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 55, v_drawee_branch_address3);
773: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 56, v_drawee_bank_acc_check_digits);
774: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 57, v_drawee_bank_acc_curr);

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

767: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 50, v_drawee_branch_state);
768: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 51, v_drawee_branch_country);
769: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 52, v_drawee_branch_postal_code);
770: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 53, v_drawee_branch_address1);
771: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 54, v_drawee_branch_address2);
772: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 55, v_drawee_branch_address3);
773: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 56, v_drawee_bank_acc_check_digits);
774: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 57, v_drawee_bank_acc_curr);
775: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 58, v_comments);

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

768: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 51, v_drawee_branch_country);
769: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 52, v_drawee_branch_postal_code);
770: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 53, v_drawee_branch_address1);
771: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 54, v_drawee_branch_address2);
772: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 55, v_drawee_branch_address3);
773: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 56, v_drawee_bank_acc_check_digits);
774: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 57, v_drawee_bank_acc_curr);
775: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 58, v_comments);
776: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 59, v_days_late);

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

769: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 52, v_drawee_branch_postal_code);
770: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 53, v_drawee_branch_address1);
771: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 54, v_drawee_branch_address2);
772: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 55, v_drawee_branch_address3);
773: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 56, v_drawee_bank_acc_check_digits);
774: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 57, v_drawee_bank_acc_curr);
775: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 58, v_comments);
776: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 59, v_days_late);
777: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 60, v_last_printed_date);

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

770: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 53, v_drawee_branch_address1);
771: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 54, v_drawee_branch_address2);
772: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 55, v_drawee_branch_address3);
773: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 56, v_drawee_bank_acc_check_digits);
774: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 57, v_drawee_bank_acc_curr);
775: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 58, v_comments);
776: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 59, v_days_late);
777: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 60, v_last_printed_date);
778: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 61, v_drawee_address1);

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

771: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 54, v_drawee_branch_address2);
772: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 55, v_drawee_branch_address3);
773: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 56, v_drawee_bank_acc_check_digits);
774: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 57, v_drawee_bank_acc_curr);
775: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 58, v_comments);
776: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 59, v_days_late);
777: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 60, v_last_printed_date);
778: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 61, v_drawee_address1);
779: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 62, v_drawee_address2);

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

772: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 55, v_drawee_branch_address3);
773: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 56, v_drawee_bank_acc_check_digits);
774: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 57, v_drawee_bank_acc_curr);
775: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 58, v_comments);
776: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 59, v_days_late);
777: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 60, v_last_printed_date);
778: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 61, v_drawee_address1);
779: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 62, v_drawee_address2);
780: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 63, v_drawee_address3);

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

773: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 56, v_drawee_bank_acc_check_digits);
774: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 57, v_drawee_bank_acc_curr);
775: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 58, v_comments);
776: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 59, v_days_late);
777: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 60, v_last_printed_date);
778: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 61, v_drawee_address1);
779: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 62, v_drawee_address2);
780: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 63, v_drawee_address3);
781: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 64, v_drawee_contact);

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

774: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 57, v_drawee_bank_acc_curr);
775: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 58, v_comments);
776: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 59, v_days_late);
777: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 60, v_last_printed_date);
778: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 61, v_drawee_address1);
779: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 62, v_drawee_address2);
780: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 63, v_drawee_address3);
781: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 64, v_drawee_contact);
782: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 65, v_special_instructions);

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

775: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 58, v_comments);
776: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 59, v_days_late);
777: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 60, v_last_printed_date);
778: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 61, v_drawee_address1);
779: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 62, v_drawee_address2);
780: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 63, v_drawee_address3);
781: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 64, v_drawee_contact);
782: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 65, v_special_instructions);
783: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 66, v_status_code);

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

776: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 59, v_days_late);
777: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 60, v_last_printed_date);
778: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 61, v_drawee_address1);
779: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 62, v_drawee_address2);
780: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 63, v_drawee_address3);
781: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 64, v_drawee_contact);
782: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 65, v_special_instructions);
783: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 66, v_status_code);
784: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 67, v_creation_batch_name);

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

777: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 60, v_last_printed_date);
778: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 61, v_drawee_address1);
779: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 62, v_drawee_address2);
780: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 63, v_drawee_address3);
781: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 64, v_drawee_contact);
782: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 65, v_special_instructions);
783: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 66, v_status_code);
784: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 67, v_creation_batch_name);
785: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 68, v_transaction_batch_source);

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

778: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 61, v_drawee_address1);
779: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 62, v_drawee_address2);
780: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 63, v_drawee_address3);
781: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 64, v_drawee_contact);
782: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 65, v_special_instructions);
783: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 66, v_status_code);
784: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 67, v_creation_batch_name);
785: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 68, v_transaction_batch_source);
786: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 69, v_ps_exchange_rate);

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

779: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 62, v_drawee_address2);
780: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 63, v_drawee_address3);
781: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 64, v_drawee_contact);
782: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 65, v_special_instructions);
783: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 66, v_status_code);
784: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 67, v_creation_batch_name);
785: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 68, v_transaction_batch_source);
786: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 69, v_ps_exchange_rate);
787:

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

780: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 63, v_drawee_address3);
781: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 64, v_drawee_contact);
782: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 65, v_special_instructions);
783: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 66, v_status_code);
784: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 67, v_creation_batch_name);
785: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 68, v_transaction_batch_source);
786: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 69, v_ps_exchange_rate);
787:
788: -- Calculate correct Orignal Entered Funcional Amount

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

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

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

782: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 65, v_special_instructions);
783: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 66, v_status_code);
784: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 67, v_creation_batch_name);
785: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 68, v_transaction_batch_source);
786: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 69, v_ps_exchange_rate);
787:
788: -- Calculate correct Orignal Entered Funcional Amount
789: --Bug 5041260 replaced the call arp_util.calc_acctd_amount with
790: -- arp_util.calc_accounted_amount.

Line 849: v_CursorID_rbatch := DBMS_SQL.OPEN_CURSOR;

845: v_risk_elimination_days := null;
846: l_populate := 'Y';
847:
848: -- Open the As of Date cursor for dynamic processing.
849: v_CursorID_rbatch := DBMS_SQL.OPEN_CURSOR;
850:
851: -- Parse the As of Date Cursor
852: DBMS_SQL.PARSE(v_CursorID_rbatch, l_remit_batch, DBMS_SQL.native);
853:

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

848: -- Open the As of Date cursor for dynamic processing.
849: v_CursorID_rbatch := DBMS_SQL.OPEN_CURSOR;
850:
851: -- Parse the As of Date Cursor
852: DBMS_SQL.PARSE(v_CursorID_rbatch, l_remit_batch, DBMS_SQL.native);
853:
854: -- Bind variables for cursor.
855: DBMS_SQL.BIND_VARIABLE(v_CursorID_rbatch, ':b_status_date', p_status_as_of_date);
856: DBMS_SQL.BIND_VARIABLE(v_CursorID_rbatch, ':b_trx_id', v_customer_trx_id);

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

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

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

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

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

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

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

861: DBMS_SQL.BIND_VARIABLE(v_CursorID_rbatch, ':p_reporting_entity_id', p_reporting_entity_id);
862: END IF;
863:
864: -- Define the output variables.
865: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 1, v_remittance_batch_name, 20);
866: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 2, v_remittance_method, 30);
867: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 3, v_with_recourse, 1);
868: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 4, v_remittance_payment_method, 30);
869: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 5, v_remit_bank_name, 60);

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

862: END IF;
863:
864: -- Define the output variables.
865: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 1, v_remittance_batch_name, 20);
866: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 2, v_remittance_method, 30);
867: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 3, v_with_recourse, 1);
868: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 4, v_remittance_payment_method, 30);
869: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 5, v_remit_bank_name, 60);
870: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 6, v_remit_bank_number, 30);

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

863:
864: -- Define the output variables.
865: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 1, v_remittance_batch_name, 20);
866: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 2, v_remittance_method, 30);
867: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 3, v_with_recourse, 1);
868: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 4, v_remittance_payment_method, 30);
869: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 5, v_remit_bank_name, 60);
870: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 6, v_remit_bank_number, 30);
871: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 7, v_remit_branch_name, 60);

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

864: -- Define the output variables.
865: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 1, v_remittance_batch_name, 20);
866: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 2, v_remittance_method, 30);
867: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 3, v_with_recourse, 1);
868: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 4, v_remittance_payment_method, 30);
869: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 5, v_remit_bank_name, 60);
870: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 6, v_remit_bank_number, 30);
871: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 7, v_remit_branch_name, 60);
872: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 8, v_remit_branch_number, 25);

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

865: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 1, v_remittance_batch_name, 20);
866: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 2, v_remittance_method, 30);
867: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 3, v_with_recourse, 1);
868: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 4, v_remittance_payment_method, 30);
869: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 5, v_remit_bank_name, 60);
870: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 6, v_remit_bank_number, 30);
871: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 7, v_remit_branch_name, 60);
872: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 8, v_remit_branch_number, 25);
873: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 9, v_remit_bank_acc_name, 80);

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

866: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 2, v_remittance_method, 30);
867: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 3, v_with_recourse, 1);
868: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 4, v_remittance_payment_method, 30);
869: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 5, v_remit_bank_name, 60);
870: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 6, v_remit_bank_number, 30);
871: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 7, v_remit_branch_name, 60);
872: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 8, v_remit_branch_number, 25);
873: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 9, v_remit_bank_acc_name, 80);
874: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 10, v_remit_bank_acc_number, 30);

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

867: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 3, v_with_recourse, 1);
868: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 4, v_remittance_payment_method, 30);
869: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 5, v_remit_bank_name, 60);
870: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 6, v_remit_bank_number, 30);
871: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 7, v_remit_branch_name, 60);
872: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 8, v_remit_branch_number, 25);
873: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 9, v_remit_bank_acc_name, 80);
874: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 10, v_remit_bank_acc_number, 30);
875: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 11, v_remit_bank_acc_id);

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

868: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 4, v_remittance_payment_method, 30);
869: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 5, v_remit_bank_name, 60);
870: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 6, v_remit_bank_number, 30);
871: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 7, v_remit_branch_name, 60);
872: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 8, v_remit_branch_number, 25);
873: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 9, v_remit_bank_acc_name, 80);
874: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 10, v_remit_bank_acc_number, 30);
875: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 11, v_remit_bank_acc_id);
876: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 12, v_remit_branch_city, 25);

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

869: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 5, v_remit_bank_name, 60);
870: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 6, v_remit_bank_number, 30);
871: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 7, v_remit_branch_name, 60);
872: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 8, v_remit_branch_number, 25);
873: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 9, v_remit_bank_acc_name, 80);
874: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 10, v_remit_bank_acc_number, 30);
875: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 11, v_remit_bank_acc_id);
876: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 12, v_remit_branch_city, 25);
877: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 13, v_remit_branch_state, 25);

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

870: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 6, v_remit_bank_number, 30);
871: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 7, v_remit_branch_name, 60);
872: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 8, v_remit_branch_number, 25);
873: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 9, v_remit_bank_acc_name, 80);
874: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 10, v_remit_bank_acc_number, 30);
875: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 11, v_remit_bank_acc_id);
876: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 12, v_remit_branch_city, 25);
877: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 13, v_remit_branch_state, 25);
878: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 14, v_remit_branch_country, 25);

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

871: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 7, v_remit_branch_name, 60);
872: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 8, v_remit_branch_number, 25);
873: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 9, v_remit_bank_acc_name, 80);
874: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 10, v_remit_bank_acc_number, 30);
875: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 11, v_remit_bank_acc_id);
876: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 12, v_remit_branch_city, 25);
877: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 13, v_remit_branch_state, 25);
878: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 14, v_remit_branch_country, 25);
879: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 15, v_remit_branch_postal_code, 20);

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

872: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 8, v_remit_branch_number, 25);
873: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 9, v_remit_bank_acc_name, 80);
874: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 10, v_remit_bank_acc_number, 30);
875: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 11, v_remit_bank_acc_id);
876: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 12, v_remit_branch_city, 25);
877: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 13, v_remit_branch_state, 25);
878: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 14, v_remit_branch_country, 25);
879: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 15, v_remit_branch_postal_code, 20);
880: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 16, v_remit_branch_address1, 35);

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

873: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 9, v_remit_bank_acc_name, 80);
874: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 10, v_remit_bank_acc_number, 30);
875: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 11, v_remit_bank_acc_id);
876: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 12, v_remit_branch_city, 25);
877: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 13, v_remit_branch_state, 25);
878: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 14, v_remit_branch_country, 25);
879: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 15, v_remit_branch_postal_code, 20);
880: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 16, v_remit_branch_address1, 35);
881: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 17, v_remit_branch_address2, 35);

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

874: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 10, v_remit_bank_acc_number, 30);
875: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 11, v_remit_bank_acc_id);
876: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 12, v_remit_branch_city, 25);
877: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 13, v_remit_branch_state, 25);
878: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 14, v_remit_branch_country, 25);
879: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 15, v_remit_branch_postal_code, 20);
880: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 16, v_remit_branch_address1, 35);
881: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 17, v_remit_branch_address2, 35);
882: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 18, v_remit_branch_address3, 35);

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

875: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 11, v_remit_bank_acc_id);
876: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 12, v_remit_branch_city, 25);
877: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 13, v_remit_branch_state, 25);
878: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 14, v_remit_branch_country, 25);
879: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 15, v_remit_branch_postal_code, 20);
880: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 16, v_remit_branch_address1, 35);
881: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 17, v_remit_branch_address2, 35);
882: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 18, v_remit_branch_address3, 35);
883: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 19, v_remit_bank_acc_check_digits, 30);

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

876: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 12, v_remit_branch_city, 25);
877: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 13, v_remit_branch_state, 25);
878: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 14, v_remit_branch_country, 25);
879: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 15, v_remit_branch_postal_code, 20);
880: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 16, v_remit_branch_address1, 35);
881: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 17, v_remit_branch_address2, 35);
882: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 18, v_remit_branch_address3, 35);
883: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 19, v_remit_bank_acc_check_digits, 30);
884: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 20, v_remit_bank_acc_curr, 15);

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

877: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 13, v_remit_branch_state, 25);
878: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 14, v_remit_branch_country, 25);
879: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 15, v_remit_branch_postal_code, 20);
880: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 16, v_remit_branch_address1, 35);
881: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 17, v_remit_branch_address2, 35);
882: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 18, v_remit_branch_address3, 35);
883: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 19, v_remit_bank_acc_check_digits, 30);
884: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 20, v_remit_bank_acc_curr, 15);
885: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 21, v_risk_elimination_days);

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

878: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 14, v_remit_branch_country, 25);
879: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 15, v_remit_branch_postal_code, 20);
880: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 16, v_remit_branch_address1, 35);
881: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 17, v_remit_branch_address2, 35);
882: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 18, v_remit_branch_address3, 35);
883: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 19, v_remit_bank_acc_check_digits, 30);
884: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 20, v_remit_bank_acc_curr, 15);
885: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 21, v_risk_elimination_days);
886:

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

879: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 15, v_remit_branch_postal_code, 20);
880: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 16, v_remit_branch_address1, 35);
881: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 17, v_remit_branch_address2, 35);
882: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 18, v_remit_branch_address3, 35);
883: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 19, v_remit_bank_acc_check_digits, 30);
884: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 20, v_remit_bank_acc_curr, 15);
885: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 21, v_risk_elimination_days);
886:
887: -- Execute the statement.

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

880: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 16, v_remit_branch_address1, 35);
881: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 17, v_remit_branch_address2, 35);
882: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 18, v_remit_branch_address3, 35);
883: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 19, v_remit_bank_acc_check_digits, 30);
884: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 20, v_remit_bank_acc_curr, 15);
885: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 21, v_risk_elimination_days);
886:
887: -- Execute the statement.
888: v_Dummy_rbatch := DBMS_SQL.EXECUTE(v_CursorID_rbatch);

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

881: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 17, v_remit_branch_address2, 35);
882: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 18, v_remit_branch_address3, 35);
883: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 19, v_remit_bank_acc_check_digits, 30);
884: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 20, v_remit_bank_acc_curr, 15);
885: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 21, v_risk_elimination_days);
886:
887: -- Execute the statement.
888: v_Dummy_rbatch := DBMS_SQL.EXECUTE(v_CursorID_rbatch);
889:

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

884: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 20, v_remit_bank_acc_curr, 15);
885: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rbatch, 21, v_risk_elimination_days);
886:
887: -- Execute the statement.
888: v_Dummy_rbatch := DBMS_SQL.EXECUTE(v_CursorID_rbatch);
889:
890: IF DBMS_SQL.FETCH_ROWS(v_CursorID_rbatch) > 0 THEN
891: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 1, v_remittance_batch_name);
892: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 2, v_remittance_method);

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

886:
887: -- Execute the statement.
888: v_Dummy_rbatch := DBMS_SQL.EXECUTE(v_CursorID_rbatch);
889:
890: IF DBMS_SQL.FETCH_ROWS(v_CursorID_rbatch) > 0 THEN
891: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 1, v_remittance_batch_name);
892: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 2, v_remittance_method);
893: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 3, v_with_recourse);
894: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 4, v_remittance_payment_method);

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

887: -- Execute the statement.
888: v_Dummy_rbatch := DBMS_SQL.EXECUTE(v_CursorID_rbatch);
889:
890: IF DBMS_SQL.FETCH_ROWS(v_CursorID_rbatch) > 0 THEN
891: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 1, v_remittance_batch_name);
892: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 2, v_remittance_method);
893: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 3, v_with_recourse);
894: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 4, v_remittance_payment_method);
895: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 5, v_remit_bank_name);

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

888: v_Dummy_rbatch := DBMS_SQL.EXECUTE(v_CursorID_rbatch);
889:
890: IF DBMS_SQL.FETCH_ROWS(v_CursorID_rbatch) > 0 THEN
891: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 1, v_remittance_batch_name);
892: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 2, v_remittance_method);
893: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 3, v_with_recourse);
894: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 4, v_remittance_payment_method);
895: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 5, v_remit_bank_name);
896: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 6, v_remit_bank_number);

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

889:
890: IF DBMS_SQL.FETCH_ROWS(v_CursorID_rbatch) > 0 THEN
891: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 1, v_remittance_batch_name);
892: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 2, v_remittance_method);
893: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 3, v_with_recourse);
894: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 4, v_remittance_payment_method);
895: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 5, v_remit_bank_name);
896: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 6, v_remit_bank_number);
897: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 7, v_remit_branch_name);

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

890: IF DBMS_SQL.FETCH_ROWS(v_CursorID_rbatch) > 0 THEN
891: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 1, v_remittance_batch_name);
892: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 2, v_remittance_method);
893: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 3, v_with_recourse);
894: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 4, v_remittance_payment_method);
895: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 5, v_remit_bank_name);
896: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 6, v_remit_bank_number);
897: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 7, v_remit_branch_name);
898: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 8, v_remit_branch_number);

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

891: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 1, v_remittance_batch_name);
892: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 2, v_remittance_method);
893: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 3, v_with_recourse);
894: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 4, v_remittance_payment_method);
895: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 5, v_remit_bank_name);
896: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 6, v_remit_bank_number);
897: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 7, v_remit_branch_name);
898: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 8, v_remit_branch_number);
899: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 9, v_remit_bank_acc_name);

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

892: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 2, v_remittance_method);
893: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 3, v_with_recourse);
894: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 4, v_remittance_payment_method);
895: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 5, v_remit_bank_name);
896: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 6, v_remit_bank_number);
897: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 7, v_remit_branch_name);
898: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 8, v_remit_branch_number);
899: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 9, v_remit_bank_acc_name);
900: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 10, v_remit_bank_acc_number);

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

893: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 3, v_with_recourse);
894: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 4, v_remittance_payment_method);
895: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 5, v_remit_bank_name);
896: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 6, v_remit_bank_number);
897: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 7, v_remit_branch_name);
898: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 8, v_remit_branch_number);
899: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 9, v_remit_bank_acc_name);
900: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 10, v_remit_bank_acc_number);
901: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 11, v_remit_bank_acc_id);

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

894: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 4, v_remittance_payment_method);
895: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 5, v_remit_bank_name);
896: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 6, v_remit_bank_number);
897: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 7, v_remit_branch_name);
898: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 8, v_remit_branch_number);
899: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 9, v_remit_bank_acc_name);
900: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 10, v_remit_bank_acc_number);
901: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 11, v_remit_bank_acc_id);
902: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 12, v_remit_branch_city);

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

895: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 5, v_remit_bank_name);
896: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 6, v_remit_bank_number);
897: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 7, v_remit_branch_name);
898: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 8, v_remit_branch_number);
899: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 9, v_remit_bank_acc_name);
900: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 10, v_remit_bank_acc_number);
901: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 11, v_remit_bank_acc_id);
902: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 12, v_remit_branch_city);
903: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 13, v_remit_branch_state);

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

896: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 6, v_remit_bank_number);
897: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 7, v_remit_branch_name);
898: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 8, v_remit_branch_number);
899: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 9, v_remit_bank_acc_name);
900: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 10, v_remit_bank_acc_number);
901: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 11, v_remit_bank_acc_id);
902: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 12, v_remit_branch_city);
903: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 13, v_remit_branch_state);
904: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 14, v_remit_branch_country);

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

897: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 7, v_remit_branch_name);
898: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 8, v_remit_branch_number);
899: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 9, v_remit_bank_acc_name);
900: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 10, v_remit_bank_acc_number);
901: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 11, v_remit_bank_acc_id);
902: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 12, v_remit_branch_city);
903: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 13, v_remit_branch_state);
904: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 14, v_remit_branch_country);
905: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 15, v_remit_branch_postal_code);

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

898: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 8, v_remit_branch_number);
899: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 9, v_remit_bank_acc_name);
900: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 10, v_remit_bank_acc_number);
901: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 11, v_remit_bank_acc_id);
902: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 12, v_remit_branch_city);
903: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 13, v_remit_branch_state);
904: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 14, v_remit_branch_country);
905: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 15, v_remit_branch_postal_code);
906: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 16, v_remit_branch_address1);

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

899: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 9, v_remit_bank_acc_name);
900: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 10, v_remit_bank_acc_number);
901: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 11, v_remit_bank_acc_id);
902: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 12, v_remit_branch_city);
903: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 13, v_remit_branch_state);
904: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 14, v_remit_branch_country);
905: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 15, v_remit_branch_postal_code);
906: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 16, v_remit_branch_address1);
907: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 17, v_remit_branch_address2);

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

900: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 10, v_remit_bank_acc_number);
901: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 11, v_remit_bank_acc_id);
902: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 12, v_remit_branch_city);
903: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 13, v_remit_branch_state);
904: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 14, v_remit_branch_country);
905: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 15, v_remit_branch_postal_code);
906: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 16, v_remit_branch_address1);
907: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 17, v_remit_branch_address2);
908: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 18, v_remit_branch_address3);

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

901: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 11, v_remit_bank_acc_id);
902: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 12, v_remit_branch_city);
903: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 13, v_remit_branch_state);
904: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 14, v_remit_branch_country);
905: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 15, v_remit_branch_postal_code);
906: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 16, v_remit_branch_address1);
907: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 17, v_remit_branch_address2);
908: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 18, v_remit_branch_address3);
909: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 19, v_remit_bank_acc_check_digits);

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

902: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 12, v_remit_branch_city);
903: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 13, v_remit_branch_state);
904: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 14, v_remit_branch_country);
905: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 15, v_remit_branch_postal_code);
906: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 16, v_remit_branch_address1);
907: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 17, v_remit_branch_address2);
908: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 18, v_remit_branch_address3);
909: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 19, v_remit_bank_acc_check_digits);
910: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 20, v_remit_bank_acc_curr);

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

903: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 13, v_remit_branch_state);
904: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 14, v_remit_branch_country);
905: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 15, v_remit_branch_postal_code);
906: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 16, v_remit_branch_address1);
907: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 17, v_remit_branch_address2);
908: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 18, v_remit_branch_address3);
909: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 19, v_remit_bank_acc_check_digits);
910: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 20, v_remit_bank_acc_curr);
911: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 21, v_risk_elimination_days);

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

904: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 14, v_remit_branch_country);
905: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 15, v_remit_branch_postal_code);
906: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 16, v_remit_branch_address1);
907: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 17, v_remit_branch_address2);
908: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 18, v_remit_branch_address3);
909: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 19, v_remit_bank_acc_check_digits);
910: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 20, v_remit_bank_acc_curr);
911: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 21, v_risk_elimination_days);
912:

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

905: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 15, v_remit_branch_postal_code);
906: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 16, v_remit_branch_address1);
907: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 17, v_remit_branch_address2);
908: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 18, v_remit_branch_address3);
909: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 19, v_remit_bank_acc_check_digits);
910: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 20, v_remit_bank_acc_curr);
911: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 21, v_risk_elimination_days);
912:
913:

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

906: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 16, v_remit_branch_address1);
907: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 17, v_remit_branch_address2);
908: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 18, v_remit_branch_address3);
909: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 19, v_remit_bank_acc_check_digits);
910: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 20, v_remit_bank_acc_curr);
911: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 21, v_risk_elimination_days);
912:
913:
914: END IF;

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

907: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 17, v_remit_branch_address2);
908: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 18, v_remit_branch_address3);
909: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 19, v_remit_bank_acc_check_digits);
910: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 20, v_remit_bank_acc_curr);
911: DBMS_SQL.COLUMN_VALUE(v_CursorID_rbatch, 21, v_risk_elimination_days);
912:
913:
914: END IF;
915:

Line 916: IF DBMS_SQL.IS_OPEN (v_CursorID_rbatch) THEN

912:
913:
914: END IF;
915:
916: IF DBMS_SQL.IS_OPEN (v_CursorID_rbatch) THEN
917: DBMS_SQL.CLOSE_CURSOR(v_CursorID_rbatch);
918: END IF;
919:
920: -- Remitance Batch Name Restriction

Line 917: DBMS_SQL.CLOSE_CURSOR(v_CursorID_rbatch);

913:
914: END IF;
915:
916: IF DBMS_SQL.IS_OPEN (v_CursorID_rbatch) THEN
917: DBMS_SQL.CLOSE_CURSOR(v_CursorID_rbatch);
918: END IF;
919:
920: -- Remitance Batch Name Restriction
921: IF p_remittance_batch_name IS NOT NULL THEN

Line 939: DBMS_SQL.CLOSE_CURSOR(v_CursorID_rbatch);

935:
936: EXCEPTION
937: WHEN OTHERS THEN
938: -- Close both cursors, then raise the error again.
939: DBMS_SQL.CLOSE_CURSOR(v_CursorID_rbatch);
940: DBMS_SQL.CLOSE_CURSOR(v_CursorID_main);
941: RAISE;
942:
943: END;

Line 940: DBMS_SQL.CLOSE_CURSOR(v_CursorID_main);

936: EXCEPTION
937: WHEN OTHERS THEN
938: -- Close both cursors, then raise the error again.
939: DBMS_SQL.CLOSE_CURSOR(v_CursorID_rbatch);
940: DBMS_SQL.CLOSE_CURSOR(v_CursorID_main);
941: RAISE;
942:
943: END;
944:

Line 959: v_CursorID_date := DBMS_SQL.OPEN_CURSOR;

955: v_status_date := null;
956: v_status_gl_date := null;
957:
958: -- Open the As of Date cursor for dynamic processing.
959: v_CursorID_date := DBMS_SQL.OPEN_CURSOR;
960:
961: -- Parse the As of Date Cursor
962: DBMS_SQL.PARSE(v_CursorID_date, l_as_of_date, DBMS_SQL.native);
963:

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

958: -- Open the As of Date cursor for dynamic processing.
959: v_CursorID_date := DBMS_SQL.OPEN_CURSOR;
960:
961: -- Parse the As of Date Cursor
962: DBMS_SQL.PARSE(v_CursorID_date, l_as_of_date, DBMS_SQL.native);
963:
964: -- Bind variables for cursor
965: DBMS_SQL.BIND_VARIABLE(v_CursorID_date, ':b_status_date', p_status_as_of_date);
966: DBMS_SQL.BIND_VARIABLE(v_CursorID_date, ':b_trx_id', v_customer_trx_id);

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

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

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

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

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

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

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

970: DBMS_SQL.BIND_VARIABLE(v_CursorID_date, ':p_reporting_entity_id', p_reporting_entity_id);
971: END IF;
972:
973: -- Define the output variables.
974: DBMS_SQL.DEFINE_COLUMN(v_CursorID_date, 1, v_status, 30);
975: DBMS_SQL.DEFINE_COLUMN(v_CursorID_date, 2, v_status_date);
976: DBMS_SQL.DEFINE_COLUMN(v_CursorID_date, 3, v_status_gl_date);
977: DBMS_SQL.DEFINE_COLUMN(v_CursorID_date, 4, v_status_code, 30);
978:

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

971: END IF;
972:
973: -- Define the output variables.
974: DBMS_SQL.DEFINE_COLUMN(v_CursorID_date, 1, v_status, 30);
975: DBMS_SQL.DEFINE_COLUMN(v_CursorID_date, 2, v_status_date);
976: DBMS_SQL.DEFINE_COLUMN(v_CursorID_date, 3, v_status_gl_date);
977: DBMS_SQL.DEFINE_COLUMN(v_CursorID_date, 4, v_status_code, 30);
978:
979: -- Execute the statement.

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

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

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

973: -- Define the output variables.
974: DBMS_SQL.DEFINE_COLUMN(v_CursorID_date, 1, v_status, 30);
975: DBMS_SQL.DEFINE_COLUMN(v_CursorID_date, 2, v_status_date);
976: DBMS_SQL.DEFINE_COLUMN(v_CursorID_date, 3, v_status_gl_date);
977: DBMS_SQL.DEFINE_COLUMN(v_CursorID_date, 4, v_status_code, 30);
978:
979: -- Execute the statement.
980: v_Dummy_date := DBMS_SQL.EXECUTE(v_CursorID_date);
981:

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

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

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

978:
979: -- Execute the statement.
980: v_Dummy_date := DBMS_SQL.EXECUTE(v_CursorID_date);
981:
982: IF DBMS_SQL.FETCH_ROWS(v_CursorID_date) > 0 THEN
983: DBMS_SQL.COLUMN_VALUE(v_CursorID_date, 1, v_status);
984: DBMS_SQL.COLUMN_VALUE(v_CursorID_date, 2, v_status_date);
985: DBMS_SQL.COLUMN_VALUE(v_CursorID_date, 3, v_status_gl_date);
986: DBMS_SQL.COLUMN_VALUE(v_CursorID_date, 4, v_status_code);

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

979: -- Execute the statement.
980: v_Dummy_date := DBMS_SQL.EXECUTE(v_CursorID_date);
981:
982: IF DBMS_SQL.FETCH_ROWS(v_CursorID_date) > 0 THEN
983: DBMS_SQL.COLUMN_VALUE(v_CursorID_date, 1, v_status);
984: DBMS_SQL.COLUMN_VALUE(v_CursorID_date, 2, v_status_date);
985: DBMS_SQL.COLUMN_VALUE(v_CursorID_date, 3, v_status_gl_date);
986: DBMS_SQL.COLUMN_VALUE(v_CursorID_date, 4, v_status_code);
987: END IF;

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

980: v_Dummy_date := DBMS_SQL.EXECUTE(v_CursorID_date);
981:
982: IF DBMS_SQL.FETCH_ROWS(v_CursorID_date) > 0 THEN
983: DBMS_SQL.COLUMN_VALUE(v_CursorID_date, 1, v_status);
984: DBMS_SQL.COLUMN_VALUE(v_CursorID_date, 2, v_status_date);
985: DBMS_SQL.COLUMN_VALUE(v_CursorID_date, 3, v_status_gl_date);
986: DBMS_SQL.COLUMN_VALUE(v_CursorID_date, 4, v_status_code);
987: END IF;
988:

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

981:
982: IF DBMS_SQL.FETCH_ROWS(v_CursorID_date) > 0 THEN
983: DBMS_SQL.COLUMN_VALUE(v_CursorID_date, 1, v_status);
984: DBMS_SQL.COLUMN_VALUE(v_CursorID_date, 2, v_status_date);
985: DBMS_SQL.COLUMN_VALUE(v_CursorID_date, 3, v_status_gl_date);
986: DBMS_SQL.COLUMN_VALUE(v_CursorID_date, 4, v_status_code);
987: END IF;
988:
989: IF DBMS_SQL.IS_OPEN (v_CursorID_date) THEN

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

982: IF DBMS_SQL.FETCH_ROWS(v_CursorID_date) > 0 THEN
983: DBMS_SQL.COLUMN_VALUE(v_CursorID_date, 1, v_status);
984: DBMS_SQL.COLUMN_VALUE(v_CursorID_date, 2, v_status_date);
985: DBMS_SQL.COLUMN_VALUE(v_CursorID_date, 3, v_status_gl_date);
986: DBMS_SQL.COLUMN_VALUE(v_CursorID_date, 4, v_status_code);
987: END IF;
988:
989: IF DBMS_SQL.IS_OPEN (v_CursorID_date) THEN
990: DBMS_SQL.CLOSE_CURSOR(v_CursorID_date);

Line 989: IF DBMS_SQL.IS_OPEN (v_CursorID_date) THEN

985: DBMS_SQL.COLUMN_VALUE(v_CursorID_date, 3, v_status_gl_date);
986: DBMS_SQL.COLUMN_VALUE(v_CursorID_date, 4, v_status_code);
987: END IF;
988:
989: IF DBMS_SQL.IS_OPEN (v_CursorID_date) THEN
990: DBMS_SQL.CLOSE_CURSOR(v_CursorID_date);
991: END IF;
992:
993: EXCEPTION

Line 990: DBMS_SQL.CLOSE_CURSOR(v_CursorID_date);

986: DBMS_SQL.COLUMN_VALUE(v_CursorID_date, 4, v_status_code);
987: END IF;
988:
989: IF DBMS_SQL.IS_OPEN (v_CursorID_date) THEN
990: DBMS_SQL.CLOSE_CURSOR(v_CursorID_date);
991: END IF;
992:
993: EXCEPTION
994: WHEN OTHERS THEN

Line 996: DBMS_SQL.CLOSE_CURSOR(v_CursorID_date);

992:
993: EXCEPTION
994: WHEN OTHERS THEN
995: -- Close both cursors, then raise the error again.
996: DBMS_SQL.CLOSE_CURSOR(v_CursorID_date);
997: DBMS_SQL.CLOSE_CURSOR(v_CursorID_main);
998: RAISE;
999:
1000: END;

Line 997: DBMS_SQL.CLOSE_CURSOR(v_CursorID_main);

993: EXCEPTION
994: WHEN OTHERS THEN
995: -- Close both cursors, then raise the error again.
996: DBMS_SQL.CLOSE_CURSOR(v_CursorID_date);
997: DBMS_SQL.CLOSE_CURSOR(v_CursorID_main);
998: RAISE;
999:
1000: END;
1001:

Line 1017: v_CursorID_asg := DBMS_SQL.OPEN_CURSOR;

1013: v_assigned_entered_amount := 0;
1014: v_assigned_functional_amount := 0;
1015:
1016: -- Open the Assigned Amounts cursor for dynamic processing.
1017: v_CursorID_asg := DBMS_SQL.OPEN_CURSOR;
1018:
1019: -- Parse the Assigned Amounts Cursor
1020: DBMS_SQL.PARSE(v_CursorID_asg, l_assigned_amount, DBMS_SQL.native);
1021:

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

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

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

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

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

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

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

1028: DBMS_SQL.BIND_VARIABLE(v_CursorID_asg, ':p_reporting_entity_id', p_reporting_entity_id);
1029: END IF;
1030:
1031: -- Define the output variables.
1032: DBMS_SQL.DEFINE_COLUMN(v_CursorID_asg, 1, v_assigned_entered_amount);
1033: DBMS_SQL.DEFINE_COLUMN(v_CursorID_asg, 2, v_assigned_functional_amount);
1034:
1035: -- Execute the statement.
1036: v_Dummy_asg := DBMS_SQL.EXECUTE(v_CursorID_asg);

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

1029: END IF;
1030:
1031: -- Define the output variables.
1032: DBMS_SQL.DEFINE_COLUMN(v_CursorID_asg, 1, v_assigned_entered_amount);
1033: DBMS_SQL.DEFINE_COLUMN(v_CursorID_asg, 2, v_assigned_functional_amount);
1034:
1035: -- Execute the statement.
1036: v_Dummy_asg := DBMS_SQL.EXECUTE(v_CursorID_asg);
1037:

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

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

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

1034:
1035: -- Execute the statement.
1036: v_Dummy_asg := DBMS_SQL.EXECUTE(v_CursorID_asg);
1037:
1038: IF DBMS_SQL.FETCH_ROWS(v_CursorID_asg) > 0 THEN
1039: DBMS_SQL.COLUMN_VALUE(v_CursorID_asg, 1, v_assigned_entered_amount);
1040: DBMS_SQL.COLUMN_VALUE(v_CursorID_asg, 2, v_assigned_functional_amount);
1041: END IF;
1042:

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

1035: -- Execute the statement.
1036: v_Dummy_asg := DBMS_SQL.EXECUTE(v_CursorID_asg);
1037:
1038: IF DBMS_SQL.FETCH_ROWS(v_CursorID_asg) > 0 THEN
1039: DBMS_SQL.COLUMN_VALUE(v_CursorID_asg, 1, v_assigned_entered_amount);
1040: DBMS_SQL.COLUMN_VALUE(v_CursorID_asg, 2, v_assigned_functional_amount);
1041: END IF;
1042:
1043: IF DBMS_SQL.IS_OPEN (v_CursorID_asg) THEN

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

1036: v_Dummy_asg := DBMS_SQL.EXECUTE(v_CursorID_asg);
1037:
1038: IF DBMS_SQL.FETCH_ROWS(v_CursorID_asg) > 0 THEN
1039: DBMS_SQL.COLUMN_VALUE(v_CursorID_asg, 1, v_assigned_entered_amount);
1040: DBMS_SQL.COLUMN_VALUE(v_CursorID_asg, 2, v_assigned_functional_amount);
1041: END IF;
1042:
1043: IF DBMS_SQL.IS_OPEN (v_CursorID_asg) THEN
1044: DBMS_SQL.CLOSE_CURSOR(v_CursorID_asg);

Line 1043: IF DBMS_SQL.IS_OPEN (v_CursorID_asg) THEN

1039: DBMS_SQL.COLUMN_VALUE(v_CursorID_asg, 1, v_assigned_entered_amount);
1040: DBMS_SQL.COLUMN_VALUE(v_CursorID_asg, 2, v_assigned_functional_amount);
1041: END IF;
1042:
1043: IF DBMS_SQL.IS_OPEN (v_CursorID_asg) THEN
1044: DBMS_SQL.CLOSE_CURSOR(v_CursorID_asg);
1045: END IF;
1046:
1047: EXCEPTION

Line 1044: DBMS_SQL.CLOSE_CURSOR(v_CursorID_asg);

1040: DBMS_SQL.COLUMN_VALUE(v_CursorID_asg, 2, v_assigned_functional_amount);
1041: END IF;
1042:
1043: IF DBMS_SQL.IS_OPEN (v_CursorID_asg) THEN
1044: DBMS_SQL.CLOSE_CURSOR(v_CursorID_asg);
1045: END IF;
1046:
1047: EXCEPTION
1048: WHEN OTHERS THEN

Line 1050: DBMS_SQL.CLOSE_CURSOR(v_CursorID_asg);

1046:
1047: EXCEPTION
1048: WHEN OTHERS THEN
1049: -- Close both cursors, then raise the error again.
1050: DBMS_SQL.CLOSE_CURSOR(v_CursorID_asg);
1051: DBMS_SQL.CLOSE_CURSOR(v_CursorID_main);
1052: RAISE;
1053:
1054: END;

Line 1051: DBMS_SQL.CLOSE_CURSOR(v_CursorID_main);

1047: EXCEPTION
1048: WHEN OTHERS THEN
1049: -- Close both cursors, then raise the error again.
1050: DBMS_SQL.CLOSE_CURSOR(v_CursorID_asg);
1051: DBMS_SQL.CLOSE_CURSOR(v_CursorID_main);
1052: RAISE;
1053:
1054: END;
1055:

Line 1067: v_CursorID_amt := DBMS_SQL.OPEN_CURSOR;

1063: v_amount_applied := null;
1064: v_functional_amount_applied := null;
1065:
1066: -- Open the Open Amt cursor for dynamic processing.
1067: v_CursorID_amt := DBMS_SQL.OPEN_CURSOR;
1068:
1069: -- Parse the Open Amt Cursor
1070: DBMS_SQL.PARSE(v_CursorID_amt, l_open_amount, DBMS_SQL.native);
1071:

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

1066: -- Open the Open Amt cursor for dynamic processing.
1067: v_CursorID_amt := DBMS_SQL.OPEN_CURSOR;
1068:
1069: -- Parse the Open Amt Cursor
1070: DBMS_SQL.PARSE(v_CursorID_amt, l_open_amount, DBMS_SQL.native);
1071:
1072: -- Bind variables for cursor
1073: DBMS_SQL.BIND_VARIABLE(v_CursorID_amt, ':b_status_as_of_date', p_status_as_of_date);
1074: DBMS_SQL.BIND_VARIABLE(v_CursorID_amt, ':b_trx_id', v_customer_trx_id);

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

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

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

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

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

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

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

1078: DBMS_SQL.BIND_VARIABLE(v_CursorID_amt, ':p_reporting_entity_id', p_reporting_entity_id);
1079: END IF;
1080:
1081: -- Define the output variables.
1082: DBMS_SQL.DEFINE_COLUMN(v_CursorID_amt, 1, v_amount_applied);
1083:
1084: -- Execute the statement.
1085: v_Dummy_amt := DBMS_SQL.EXECUTE(v_CursorID_amt);
1086:

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

1081: -- Define the output variables.
1082: DBMS_SQL.DEFINE_COLUMN(v_CursorID_amt, 1, v_amount_applied);
1083:
1084: -- Execute the statement.
1085: v_Dummy_amt := DBMS_SQL.EXECUTE(v_CursorID_amt);
1086:
1087: IF DBMS_SQL.FETCH_ROWS(v_CursorID_amt) > 0 THEN
1088: DBMS_SQL.COLUMN_VALUE(v_CursorID_amt, 1, v_amount_applied);
1089: END IF;

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

1083:
1084: -- Execute the statement.
1085: v_Dummy_amt := DBMS_SQL.EXECUTE(v_CursorID_amt);
1086:
1087: IF DBMS_SQL.FETCH_ROWS(v_CursorID_amt) > 0 THEN
1088: DBMS_SQL.COLUMN_VALUE(v_CursorID_amt, 1, v_amount_applied);
1089: END IF;
1090:
1091: IF DBMS_SQL.IS_OPEN (v_CursorID_amt) THEN

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

1084: -- Execute the statement.
1085: v_Dummy_amt := DBMS_SQL.EXECUTE(v_CursorID_amt);
1086:
1087: IF DBMS_SQL.FETCH_ROWS(v_CursorID_amt) > 0 THEN
1088: DBMS_SQL.COLUMN_VALUE(v_CursorID_amt, 1, v_amount_applied);
1089: END IF;
1090:
1091: IF DBMS_SQL.IS_OPEN (v_CursorID_amt) THEN
1092: DBMS_SQL.CLOSE_CURSOR(v_CursorID_amt);

Line 1091: IF DBMS_SQL.IS_OPEN (v_CursorID_amt) THEN

1087: IF DBMS_SQL.FETCH_ROWS(v_CursorID_amt) > 0 THEN
1088: DBMS_SQL.COLUMN_VALUE(v_CursorID_amt, 1, v_amount_applied);
1089: END IF;
1090:
1091: IF DBMS_SQL.IS_OPEN (v_CursorID_amt) THEN
1092: DBMS_SQL.CLOSE_CURSOR(v_CursorID_amt);
1093: END IF;
1094:
1095: IF v_amount_applied IS NOT NULL THEN

Line 1092: DBMS_SQL.CLOSE_CURSOR(v_CursorID_amt);

1088: DBMS_SQL.COLUMN_VALUE(v_CursorID_amt, 1, v_amount_applied);
1089: END IF;
1090:
1091: IF DBMS_SQL.IS_OPEN (v_CursorID_amt) THEN
1092: DBMS_SQL.CLOSE_CURSOR(v_CursorID_amt);
1093: END IF;
1094:
1095: IF v_amount_applied IS NOT NULL THEN
1096: v_open_entered_amount := v_amount_applied + v_open_entered_amount;

Line 1121: DBMS_SQL.CLOSE_CURSOR(v_CursorID_amt);

1117:
1118: EXCEPTION
1119: WHEN OTHERS THEN
1120: -- Close both cursors, then raise the error again.
1121: DBMS_SQL.CLOSE_CURSOR(v_CursorID_amt);
1122: DBMS_SQL.CLOSE_CURSOR(v_CursorID_main);
1123: RAISE;
1124:
1125: END;

Line 1122: DBMS_SQL.CLOSE_CURSOR(v_CursorID_main);

1118: EXCEPTION
1119: WHEN OTHERS THEN
1120: -- Close both cursors, then raise the error again.
1121: DBMS_SQL.CLOSE_CURSOR(v_CursorID_amt);
1122: DBMS_SQL.CLOSE_CURSOR(v_CursorID_main);
1123: RAISE;
1124:
1125: END;
1126:

Line 1139: v_CursorID_rev := DBMS_SQL.OPEN_CURSOR;

1135: -- Initialize variables
1136: v_unpaid_receipt_rev_reason := null;
1137:
1138: -- Open the Unpaide Receipt Reversal Reason cursor for dynamic processing.
1139: v_CursorID_rev := DBMS_SQL.OPEN_CURSOR;
1140:
1141: -- Parse the Open Amt Cursor
1142: DBMS_SQL.PARSE(v_CursorID_rev, l_receipt_reversal, DBMS_SQL.native);
1143:

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

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

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

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

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

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

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

1149: DBMS_SQL.BIND_VARIABLE(v_CursorID_rev, ':p_reporting_entity_id', p_reporting_entity_id);
1150: END IF;
1151:
1152: -- Define the output variables.
1153: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rev, 1, v_unpaid_receipt_rev_reason, 80);
1154:
1155: -- Execute the statement.
1156: v_Dummy_amt := DBMS_SQL.EXECUTE(v_CursorID_rev);
1157:

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

1152: -- Define the output variables.
1153: DBMS_SQL.DEFINE_COLUMN(v_CursorID_rev, 1, v_unpaid_receipt_rev_reason, 80);
1154:
1155: -- Execute the statement.
1156: v_Dummy_amt := DBMS_SQL.EXECUTE(v_CursorID_rev);
1157:
1158: IF DBMS_SQL.FETCH_ROWS(v_CursorID_rev) > 0 THEN
1159: DBMS_SQL.COLUMN_VALUE(v_CursorID_rev, 1, v_unpaid_receipt_rev_reason);
1160: END IF;

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

1154:
1155: -- Execute the statement.
1156: v_Dummy_amt := DBMS_SQL.EXECUTE(v_CursorID_rev);
1157:
1158: IF DBMS_SQL.FETCH_ROWS(v_CursorID_rev) > 0 THEN
1159: DBMS_SQL.COLUMN_VALUE(v_CursorID_rev, 1, v_unpaid_receipt_rev_reason);
1160: END IF;
1161:
1162: IF DBMS_SQL.IS_OPEN (v_CursorID_rev) THEN

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

1155: -- Execute the statement.
1156: v_Dummy_amt := DBMS_SQL.EXECUTE(v_CursorID_rev);
1157:
1158: IF DBMS_SQL.FETCH_ROWS(v_CursorID_rev) > 0 THEN
1159: DBMS_SQL.COLUMN_VALUE(v_CursorID_rev, 1, v_unpaid_receipt_rev_reason);
1160: END IF;
1161:
1162: IF DBMS_SQL.IS_OPEN (v_CursorID_rev) THEN
1163: DBMS_SQL.CLOSE_CURSOR(v_CursorID_rev);

Line 1162: IF DBMS_SQL.IS_OPEN (v_CursorID_rev) THEN

1158: IF DBMS_SQL.FETCH_ROWS(v_CursorID_rev) > 0 THEN
1159: DBMS_SQL.COLUMN_VALUE(v_CursorID_rev, 1, v_unpaid_receipt_rev_reason);
1160: END IF;
1161:
1162: IF DBMS_SQL.IS_OPEN (v_CursorID_rev) THEN
1163: DBMS_SQL.CLOSE_CURSOR(v_CursorID_rev);
1164: END IF;
1165:
1166: EXCEPTION

Line 1163: DBMS_SQL.CLOSE_CURSOR(v_CursorID_rev);

1159: DBMS_SQL.COLUMN_VALUE(v_CursorID_rev, 1, v_unpaid_receipt_rev_reason);
1160: END IF;
1161:
1162: IF DBMS_SQL.IS_OPEN (v_CursorID_rev) THEN
1163: DBMS_SQL.CLOSE_CURSOR(v_CursorID_rev);
1164: END IF;
1165:
1166: EXCEPTION
1167: WHEN OTHERS THEN

Line 1169: DBMS_SQL.CLOSE_CURSOR(v_CursorID_rev);

1165:
1166: EXCEPTION
1167: WHEN OTHERS THEN
1168: -- Close both cursors, then raise the error again.
1169: DBMS_SQL.CLOSE_CURSOR(v_CursorID_rev);
1170: DBMS_SQL.CLOSE_CURSOR(v_CursorID_main);
1171: RAISE;
1172:
1173: END;

Line 1170: DBMS_SQL.CLOSE_CURSOR(v_CursorID_main);

1166: EXCEPTION
1167: WHEN OTHERS THEN
1168: -- Close both cursors, then raise the error again.
1169: DBMS_SQL.CLOSE_CURSOR(v_CursorID_rev);
1170: DBMS_SQL.CLOSE_CURSOR(v_CursorID_main);
1171: RAISE;
1172:
1173: END;
1174:

Line 1414: DBMS_SQL.CLOSE_CURSOR(v_CursorID_main);

1410:
1411: END LOOP;
1412:
1413: -- Close the cursor.
1414: DBMS_SQL.CLOSE_CURSOR(v_CursorID_main);
1415:
1416: -- Update status variables to successful completion
1417: retcode := 0;
1418: errbuf := '';

Line 1426: DBMS_SQL.CLOSE_CURSOR(v_CursorID_main);

1422:
1423: EXCEPTION
1424: WHEN OTHERS THEN
1425: -- Close the cursor, then raise the error again.
1426: DBMS_SQL.CLOSE_CURSOR(v_CursorID_main);
1427: RAISE;
1428: END arrxbrs_report;
1429:
1430: END arrx_brs;