APPS.ARP_CR_BATCHES_PKG dependencies on DBMS_SQL

Line 523: dbms_sql.bind_variable(p_update_cursor, ':ar_text_dummy',

519: /*------------------+
520: | Dummy constants |
521: +------------------*/
522: --
523: dbms_sql.bind_variable(p_update_cursor, ':ar_text_dummy',
524: AR_TEXT_DUMMY);
525: /* 31-MAY-2000 J Rautiainen BR Implementation
526: * The flag bind variable was commented out. Comments were removed since
527: * BR changes require this flag */

Line 528: dbms_sql.bind_variable(p_update_cursor, ':ar_flag_dummy',

524: AR_TEXT_DUMMY);
525: /* 31-MAY-2000 J Rautiainen BR Implementation
526: * The flag bind variable was commented out. Comments were removed since
527: * BR changes require this flag */
528: dbms_sql.bind_variable(p_update_cursor, ':ar_flag_dummy',
529: AR_FLAG_DUMMY);
530:
531: dbms_sql.bind_variable(p_update_cursor, ':ar_number_dummy',
532: AR_NUMBER_DUMMY);

Line 531: dbms_sql.bind_variable(p_update_cursor, ':ar_number_dummy',

527: * BR changes require this flag */
528: dbms_sql.bind_variable(p_update_cursor, ':ar_flag_dummy',
529: AR_FLAG_DUMMY);
530:
531: dbms_sql.bind_variable(p_update_cursor, ':ar_number_dummy',
532: AR_NUMBER_DUMMY);
533: --
534: dbms_sql.bind_variable(p_update_cursor, ':ar_date_dummy',
535: AR_DATE_DUMMY);

Line 534: dbms_sql.bind_variable(p_update_cursor, ':ar_date_dummy',

530:
531: dbms_sql.bind_variable(p_update_cursor, ':ar_number_dummy',
532: AR_NUMBER_DUMMY);
533: --
534: dbms_sql.bind_variable(p_update_cursor, ':ar_date_dummy',
535: AR_DATE_DUMMY);
536: arp_standard.debug('after duummy');
537: --
538: /*------------------+

Line 542: dbms_sql.bind_variable(p_update_cursor, ':pg_request_id',

538: /*------------------+
539: | WHO variables |
540: +------------------*/
541: --
542: dbms_sql.bind_variable(p_update_cursor, ':pg_request_id',
543: pg_request_id);
544: --
545: dbms_sql.bind_variable(p_update_cursor, ':pg_program_application_id',
546: pg_program_application_id);

Line 545: dbms_sql.bind_variable(p_update_cursor, ':pg_program_application_id',

541: --
542: dbms_sql.bind_variable(p_update_cursor, ':pg_request_id',
543: pg_request_id);
544: --
545: dbms_sql.bind_variable(p_update_cursor, ':pg_program_application_id',
546: pg_program_application_id);
547: --
548: dbms_sql.bind_variable(p_update_cursor, ':pg_program_id',
549: pg_program_id);

Line 548: dbms_sql.bind_variable(p_update_cursor, ':pg_program_id',

544: --
545: dbms_sql.bind_variable(p_update_cursor, ':pg_program_application_id',
546: pg_program_application_id);
547: --
548: dbms_sql.bind_variable(p_update_cursor, ':pg_program_id',
549: pg_program_id);
550: --
551: dbms_sql.bind_variable(p_update_cursor, ':pg_program_update_date',
552: pg_program_update_date);

Line 551: dbms_sql.bind_variable(p_update_cursor, ':pg_program_update_date',

547: --
548: dbms_sql.bind_variable(p_update_cursor, ':pg_program_id',
549: pg_program_id);
550: --
551: dbms_sql.bind_variable(p_update_cursor, ':pg_program_update_date',
552: pg_program_update_date);
553: --
554: dbms_sql.bind_variable(p_update_cursor, ':pg_last_updated_by',
555: pg_last_updated_by);

Line 554: dbms_sql.bind_variable(p_update_cursor, ':pg_last_updated_by',

550: --
551: dbms_sql.bind_variable(p_update_cursor, ':pg_program_update_date',
552: pg_program_update_date);
553: --
554: dbms_sql.bind_variable(p_update_cursor, ':pg_last_updated_by',
555: pg_last_updated_by);
556: --
557: dbms_sql.bind_variable(p_update_cursor, ':pg_last_update_date',
558: pg_last_update_date);

Line 557: dbms_sql.bind_variable(p_update_cursor, ':pg_last_update_date',

553: --
554: dbms_sql.bind_variable(p_update_cursor, ':pg_last_updated_by',
555: pg_last_updated_by);
556: --
557: dbms_sql.bind_variable(p_update_cursor, ':pg_last_update_date',
558: pg_last_update_date);
559: --
560: dbms_sql.bind_variable(p_update_cursor, ':pg_last_update_login',
561: pg_last_update_login);

Line 560: dbms_sql.bind_variable(p_update_cursor, ':pg_last_update_login',

556: --
557: dbms_sql.bind_variable(p_update_cursor, ':pg_last_update_date',
558: pg_last_update_date);
559: --
560: dbms_sql.bind_variable(p_update_cursor, ':pg_last_update_login',
561: pg_last_update_login);
562: dbms_sql.bind_variable(p_update_cursor, ':pg_set_of_books_id',
563: arp_global.set_of_books_id);
564: arp_standard.debug('after who');

Line 562: dbms_sql.bind_variable(p_update_cursor, ':pg_set_of_books_id',

558: pg_last_update_date);
559: --
560: dbms_sql.bind_variable(p_update_cursor, ':pg_last_update_login',
561: pg_last_update_login);
562: dbms_sql.bind_variable(p_update_cursor, ':pg_set_of_books_id',
563: arp_global.set_of_books_id);
564: arp_standard.debug('after who');
565: /*----------------------------------------------+
566: | Bind variables for all columns in the table |

Line 570: dbms_sql.bind_variable(p_update_cursor, ':batch_applied_status',

566: | Bind variables for all columns in the table |
567: +----------------------------------------------*/
568: --
569: --
570: dbms_sql.bind_variable(p_update_cursor, ':batch_applied_status',
571: p_bat_rec.batch_applied_status);
572: --
573: dbms_sql.bind_variable(p_update_cursor, ':batch_date',
574: p_bat_rec.batch_date);

Line 573: dbms_sql.bind_variable(p_update_cursor, ':batch_date',

569: --
570: dbms_sql.bind_variable(p_update_cursor, ':batch_applied_status',
571: p_bat_rec.batch_applied_status);
572: --
573: dbms_sql.bind_variable(p_update_cursor, ':batch_date',
574: p_bat_rec.batch_date);
575: --
576: dbms_sql.bind_variable(p_update_cursor, ':batch_source_id',
577: p_bat_rec.batch_source_id);

Line 576: dbms_sql.bind_variable(p_update_cursor, ':batch_source_id',

572: --
573: dbms_sql.bind_variable(p_update_cursor, ':batch_date',
574: p_bat_rec.batch_date);
575: --
576: dbms_sql.bind_variable(p_update_cursor, ':batch_source_id',
577: p_bat_rec.batch_source_id);
578: --
579: dbms_sql.bind_variable(p_update_cursor, ':currency_code',
580: p_bat_rec.currency_code);

Line 579: dbms_sql.bind_variable(p_update_cursor, ':currency_code',

575: --
576: dbms_sql.bind_variable(p_update_cursor, ':batch_source_id',
577: p_bat_rec.batch_source_id);
578: --
579: dbms_sql.bind_variable(p_update_cursor, ':currency_code',
580: p_bat_rec.currency_code);
581: --
582: dbms_sql.bind_variable(p_update_cursor, ':name',
583: p_bat_rec.name);

Line 582: dbms_sql.bind_variable(p_update_cursor, ':name',

578: --
579: dbms_sql.bind_variable(p_update_cursor, ':currency_code',
580: p_bat_rec.currency_code);
581: --
582: dbms_sql.bind_variable(p_update_cursor, ':name',
583: p_bat_rec.name);
584: --
585: dbms_sql.bind_variable(p_update_cursor, ':type',
586: p_bat_rec.type);

Line 585: dbms_sql.bind_variable(p_update_cursor, ':type',

581: --
582: dbms_sql.bind_variable(p_update_cursor, ':name',
583: p_bat_rec.name);
584: --
585: dbms_sql.bind_variable(p_update_cursor, ':type',
586: p_bat_rec.type);
587: --
588: dbms_sql.bind_variable(p_update_cursor, ':closed_date',
589: p_bat_rec.closed_date);

Line 588: dbms_sql.bind_variable(p_update_cursor, ':closed_date',

584: --
585: dbms_sql.bind_variable(p_update_cursor, ':type',
586: p_bat_rec.type);
587: --
588: dbms_sql.bind_variable(p_update_cursor, ':closed_date',
589: p_bat_rec.closed_date);
590: --
591: dbms_sql.bind_variable(p_update_cursor, ':comments',
592: p_bat_rec.comments);

Line 591: dbms_sql.bind_variable(p_update_cursor, ':comments',

587: --
588: dbms_sql.bind_variable(p_update_cursor, ':closed_date',
589: p_bat_rec.closed_date);
590: --
591: dbms_sql.bind_variable(p_update_cursor, ':comments',
592: p_bat_rec.comments);
593: --
594: dbms_sql.bind_variable(p_update_cursor, ':control_amount',
595: p_bat_rec.control_amount);

Line 594: dbms_sql.bind_variable(p_update_cursor, ':control_amount',

590: --
591: dbms_sql.bind_variable(p_update_cursor, ':comments',
592: p_bat_rec.comments);
593: --
594: dbms_sql.bind_variable(p_update_cursor, ':control_amount',
595: p_bat_rec.control_amount);
596: --
597: dbms_sql.bind_variable(p_update_cursor, ':control_count',
598: p_bat_rec.control_count);

Line 597: dbms_sql.bind_variable(p_update_cursor, ':control_count',

593: --
594: dbms_sql.bind_variable(p_update_cursor, ':control_amount',
595: p_bat_rec.control_amount);
596: --
597: dbms_sql.bind_variable(p_update_cursor, ':control_count',
598: p_bat_rec.control_count);
599: --
600: dbms_sql.bind_variable(p_update_cursor, ':deposit_date',
601: p_bat_rec.deposit_date);

Line 600: dbms_sql.bind_variable(p_update_cursor, ':deposit_date',

596: --
597: dbms_sql.bind_variable(p_update_cursor, ':control_count',
598: p_bat_rec.control_count);
599: --
600: dbms_sql.bind_variable(p_update_cursor, ':deposit_date',
601: p_bat_rec.deposit_date);
602: --
603: dbms_sql.bind_variable(p_update_cursor, ':exchange_date',
604: p_bat_rec.exchange_date);

Line 603: dbms_sql.bind_variable(p_update_cursor, ':exchange_date',

599: --
600: dbms_sql.bind_variable(p_update_cursor, ':deposit_date',
601: p_bat_rec.deposit_date);
602: --
603: dbms_sql.bind_variable(p_update_cursor, ':exchange_date',
604: p_bat_rec.exchange_date);
605: --
606: dbms_sql.bind_variable(p_update_cursor, ':exchange_rate',
607: p_bat_rec.exchange_rate);

Line 606: dbms_sql.bind_variable(p_update_cursor, ':exchange_rate',

602: --
603: dbms_sql.bind_variable(p_update_cursor, ':exchange_date',
604: p_bat_rec.exchange_date);
605: --
606: dbms_sql.bind_variable(p_update_cursor, ':exchange_rate',
607: p_bat_rec.exchange_rate);
608: --
609: dbms_sql.bind_variable(p_update_cursor, ':exchange_rate_type',
610: p_bat_rec.exchange_rate_type);

Line 609: dbms_sql.bind_variable(p_update_cursor, ':exchange_rate_type',

605: --
606: dbms_sql.bind_variable(p_update_cursor, ':exchange_rate',
607: p_bat_rec.exchange_rate);
608: --
609: dbms_sql.bind_variable(p_update_cursor, ':exchange_rate_type',
610: p_bat_rec.exchange_rate_type);
611: --
612: dbms_sql.bind_variable(p_update_cursor, ':gl_date',
613: p_bat_rec.gl_date);

Line 612: dbms_sql.bind_variable(p_update_cursor, ':gl_date',

608: --
609: dbms_sql.bind_variable(p_update_cursor, ':exchange_rate_type',
610: p_bat_rec.exchange_rate_type);
611: --
612: dbms_sql.bind_variable(p_update_cursor, ':gl_date',
613: p_bat_rec.gl_date);
614: --
615: --
616: dbms_sql.bind_variable(p_update_cursor, ':lockbox_batch_name',

Line 616: dbms_sql.bind_variable(p_update_cursor, ':lockbox_batch_name',

612: dbms_sql.bind_variable(p_update_cursor, ':gl_date',
613: p_bat_rec.gl_date);
614: --
615: --
616: dbms_sql.bind_variable(p_update_cursor, ':lockbox_batch_name',
617: p_bat_rec.lockbox_batch_name);
618: --
619: dbms_sql.bind_variable(p_update_cursor, ':lockbox_id',
620: p_bat_rec.lockbox_id);

Line 619: dbms_sql.bind_variable(p_update_cursor, ':lockbox_id',

615: --
616: dbms_sql.bind_variable(p_update_cursor, ':lockbox_batch_name',
617: p_bat_rec.lockbox_batch_name);
618: --
619: dbms_sql.bind_variable(p_update_cursor, ':lockbox_id',
620: p_bat_rec.lockbox_id);
621: --
622: dbms_sql.bind_variable(p_update_cursor, ':media_reference',
623: p_bat_rec.media_reference);

Line 622: dbms_sql.bind_variable(p_update_cursor, ':media_reference',

618: --
619: dbms_sql.bind_variable(p_update_cursor, ':lockbox_id',
620: p_bat_rec.lockbox_id);
621: --
622: dbms_sql.bind_variable(p_update_cursor, ':media_reference',
623: p_bat_rec.media_reference);
624: --
625: dbms_sql.bind_variable(p_update_cursor, ':operation_request_id',
626: p_bat_rec.operation_request_id);

Line 625: dbms_sql.bind_variable(p_update_cursor, ':operation_request_id',

621: --
622: dbms_sql.bind_variable(p_update_cursor, ':media_reference',
623: p_bat_rec.media_reference);
624: --
625: dbms_sql.bind_variable(p_update_cursor, ':operation_request_id',
626: p_bat_rec.operation_request_id);
627: --
628: dbms_sql.bind_variable(p_update_cursor, ':receipt_class_id',
629: p_bat_rec.receipt_class_id);

Line 628: dbms_sql.bind_variable(p_update_cursor, ':receipt_class_id',

624: --
625: dbms_sql.bind_variable(p_update_cursor, ':operation_request_id',
626: p_bat_rec.operation_request_id);
627: --
628: dbms_sql.bind_variable(p_update_cursor, ':receipt_class_id',
629: p_bat_rec.receipt_class_id);
630: --
631: dbms_sql.bind_variable(p_update_cursor, ':receipt_method_id',
632: p_bat_rec.receipt_method_id);

Line 631: dbms_sql.bind_variable(p_update_cursor, ':receipt_method_id',

627: --
628: dbms_sql.bind_variable(p_update_cursor, ':receipt_class_id',
629: p_bat_rec.receipt_class_id);
630: --
631: dbms_sql.bind_variable(p_update_cursor, ':receipt_method_id',
632: p_bat_rec.receipt_method_id);
633: --
634: dbms_sql.bind_variable(p_update_cursor, ':remit_method_code',
635: p_bat_rec.remit_method_code);

Line 634: dbms_sql.bind_variable(p_update_cursor, ':remit_method_code',

630: --
631: dbms_sql.bind_variable(p_update_cursor, ':receipt_method_id',
632: p_bat_rec.receipt_method_id);
633: --
634: dbms_sql.bind_variable(p_update_cursor, ':remit_method_code',
635: p_bat_rec.remit_method_code);
636: --
637: dbms_sql.bind_variable(p_update_cursor, ':remit_bank_acct_use_id',
638: p_bat_rec.remit_bank_acct_use_id);

Line 637: dbms_sql.bind_variable(p_update_cursor, ':remit_bank_acct_use_id',

633: --
634: dbms_sql.bind_variable(p_update_cursor, ':remit_method_code',
635: p_bat_rec.remit_method_code);
636: --
637: dbms_sql.bind_variable(p_update_cursor, ':remit_bank_acct_use_id',
638: p_bat_rec.remit_bank_acct_use_id);
639: --
640: dbms_sql.bind_variable(p_update_cursor, ':remittance_bank_branch_id',
641: p_bat_rec.remittance_bank_branch_id);

Line 640: dbms_sql.bind_variable(p_update_cursor, ':remittance_bank_branch_id',

636: --
637: dbms_sql.bind_variable(p_update_cursor, ':remit_bank_acct_use_id',
638: p_bat_rec.remit_bank_acct_use_id);
639: --
640: dbms_sql.bind_variable(p_update_cursor, ':remittance_bank_branch_id',
641: p_bat_rec.remittance_bank_branch_id);
642: --
643: dbms_sql.bind_variable(p_update_cursor, ':status',
644: p_bat_rec.status);

Line 643: dbms_sql.bind_variable(p_update_cursor, ':status',

639: --
640: dbms_sql.bind_variable(p_update_cursor, ':remittance_bank_branch_id',
641: p_bat_rec.remittance_bank_branch_id);
642: --
643: dbms_sql.bind_variable(p_update_cursor, ':status',
644: p_bat_rec.status);
645: dbms_sql.bind_variable(p_update_cursor, ':transmission_request_id',
646: p_bat_rec.transmission_request_id);
647: --

Line 645: dbms_sql.bind_variable(p_update_cursor, ':transmission_request_id',

641: p_bat_rec.remittance_bank_branch_id);
642: --
643: dbms_sql.bind_variable(p_update_cursor, ':status',
644: p_bat_rec.status);
645: dbms_sql.bind_variable(p_update_cursor, ':transmission_request_id',
646: p_bat_rec.transmission_request_id);
647: --
648: dbms_sql.bind_variable(p_update_cursor, ':attribute_category',
649: p_bat_rec.attribute_category);

Line 648: dbms_sql.bind_variable(p_update_cursor, ':attribute_category',

644: p_bat_rec.status);
645: dbms_sql.bind_variable(p_update_cursor, ':transmission_request_id',
646: p_bat_rec.transmission_request_id);
647: --
648: dbms_sql.bind_variable(p_update_cursor, ':attribute_category',
649: p_bat_rec.attribute_category);
650: --
651: dbms_sql.bind_variable(p_update_cursor, ':attribute1',
652: p_bat_rec.attribute1);

Line 651: dbms_sql.bind_variable(p_update_cursor, ':attribute1',

647: --
648: dbms_sql.bind_variable(p_update_cursor, ':attribute_category',
649: p_bat_rec.attribute_category);
650: --
651: dbms_sql.bind_variable(p_update_cursor, ':attribute1',
652: p_bat_rec.attribute1);
653: --
654: dbms_sql.bind_variable(p_update_cursor, ':attribute2',
655: p_bat_rec.attribute2);

Line 654: dbms_sql.bind_variable(p_update_cursor, ':attribute2',

650: --
651: dbms_sql.bind_variable(p_update_cursor, ':attribute1',
652: p_bat_rec.attribute1);
653: --
654: dbms_sql.bind_variable(p_update_cursor, ':attribute2',
655: p_bat_rec.attribute2);
656: --
657: dbms_sql.bind_variable(p_update_cursor, ':attribute3',
658: p_bat_rec.attribute3);

Line 657: dbms_sql.bind_variable(p_update_cursor, ':attribute3',

653: --
654: dbms_sql.bind_variable(p_update_cursor, ':attribute2',
655: p_bat_rec.attribute2);
656: --
657: dbms_sql.bind_variable(p_update_cursor, ':attribute3',
658: p_bat_rec.attribute3);
659: --
660: dbms_sql.bind_variable(p_update_cursor, ':attribute4',
661: p_bat_rec.attribute4);

Line 660: dbms_sql.bind_variable(p_update_cursor, ':attribute4',

656: --
657: dbms_sql.bind_variable(p_update_cursor, ':attribute3',
658: p_bat_rec.attribute3);
659: --
660: dbms_sql.bind_variable(p_update_cursor, ':attribute4',
661: p_bat_rec.attribute4);
662: --
663: --
664: dbms_sql.bind_variable(p_update_cursor, ':attribute5',

Line 664: dbms_sql.bind_variable(p_update_cursor, ':attribute5',

660: dbms_sql.bind_variable(p_update_cursor, ':attribute4',
661: p_bat_rec.attribute4);
662: --
663: --
664: dbms_sql.bind_variable(p_update_cursor, ':attribute5',
665: p_bat_rec.attribute5);
666: --
667: dbms_sql.bind_variable(p_update_cursor, ':attribute6',
668: p_bat_rec.attribute6);

Line 667: dbms_sql.bind_variable(p_update_cursor, ':attribute6',

663: --
664: dbms_sql.bind_variable(p_update_cursor, ':attribute5',
665: p_bat_rec.attribute5);
666: --
667: dbms_sql.bind_variable(p_update_cursor, ':attribute6',
668: p_bat_rec.attribute6);
669: --
670: dbms_sql.bind_variable(p_update_cursor, ':attribute7',
671: p_bat_rec.attribute7);

Line 670: dbms_sql.bind_variable(p_update_cursor, ':attribute7',

666: --
667: dbms_sql.bind_variable(p_update_cursor, ':attribute6',
668: p_bat_rec.attribute6);
669: --
670: dbms_sql.bind_variable(p_update_cursor, ':attribute7',
671: p_bat_rec.attribute7);
672: --
673: dbms_sql.bind_variable(p_update_cursor, ':attribute8',
674: p_bat_rec.attribute8);

Line 673: dbms_sql.bind_variable(p_update_cursor, ':attribute8',

669: --
670: dbms_sql.bind_variable(p_update_cursor, ':attribute7',
671: p_bat_rec.attribute7);
672: --
673: dbms_sql.bind_variable(p_update_cursor, ':attribute8',
674: p_bat_rec.attribute8);
675: --
676: dbms_sql.bind_variable(p_update_cursor, ':attribute9',
677: p_bat_rec.attribute9);

Line 676: dbms_sql.bind_variable(p_update_cursor, ':attribute9',

672: --
673: dbms_sql.bind_variable(p_update_cursor, ':attribute8',
674: p_bat_rec.attribute8);
675: --
676: dbms_sql.bind_variable(p_update_cursor, ':attribute9',
677: p_bat_rec.attribute9);
678: --
679: dbms_sql.bind_variable(p_update_cursor, ':attribute10',
680: p_bat_rec.attribute10);

Line 679: dbms_sql.bind_variable(p_update_cursor, ':attribute10',

675: --
676: dbms_sql.bind_variable(p_update_cursor, ':attribute9',
677: p_bat_rec.attribute9);
678: --
679: dbms_sql.bind_variable(p_update_cursor, ':attribute10',
680: p_bat_rec.attribute10);
681: --
682: dbms_sql.bind_variable(p_update_cursor, ':attribute11',
683: p_bat_rec.attribute11);

Line 682: dbms_sql.bind_variable(p_update_cursor, ':attribute11',

678: --
679: dbms_sql.bind_variable(p_update_cursor, ':attribute10',
680: p_bat_rec.attribute10);
681: --
682: dbms_sql.bind_variable(p_update_cursor, ':attribute11',
683: p_bat_rec.attribute11);
684: --
685: dbms_sql.bind_variable(p_update_cursor, ':attribute12',
686: p_bat_rec.attribute12);

Line 685: dbms_sql.bind_variable(p_update_cursor, ':attribute12',

681: --
682: dbms_sql.bind_variable(p_update_cursor, ':attribute11',
683: p_bat_rec.attribute11);
684: --
685: dbms_sql.bind_variable(p_update_cursor, ':attribute12',
686: p_bat_rec.attribute12);
687: --
688: dbms_sql.bind_variable(p_update_cursor, ':attribute13',
689: p_bat_rec.attribute13);

Line 688: dbms_sql.bind_variable(p_update_cursor, ':attribute13',

684: --
685: dbms_sql.bind_variable(p_update_cursor, ':attribute12',
686: p_bat_rec.attribute12);
687: --
688: dbms_sql.bind_variable(p_update_cursor, ':attribute13',
689: p_bat_rec.attribute13);
690: --
691: dbms_sql.bind_variable(p_update_cursor, ':attribute14',
692: p_bat_rec.attribute14);

Line 691: dbms_sql.bind_variable(p_update_cursor, ':attribute14',

687: --
688: dbms_sql.bind_variable(p_update_cursor, ':attribute13',
689: p_bat_rec.attribute13);
690: --
691: dbms_sql.bind_variable(p_update_cursor, ':attribute14',
692: p_bat_rec.attribute14);
693: --
694: dbms_sql.bind_variable(p_update_cursor, ':attribute15',
695: p_bat_rec.attribute15);

Line 694: dbms_sql.bind_variable(p_update_cursor, ':attribute15',

690: --
691: dbms_sql.bind_variable(p_update_cursor, ':attribute14',
692: p_bat_rec.attribute14);
693: --
694: dbms_sql.bind_variable(p_update_cursor, ':attribute15',
695: p_bat_rec.attribute15);
696: --
697: dbms_sql.bind_variable(p_update_cursor, ':transmission_id',
698: p_bat_rec.transmission_id);

Line 697: dbms_sql.bind_variable(p_update_cursor, ':transmission_id',

693: --
694: dbms_sql.bind_variable(p_update_cursor, ':attribute15',
695: p_bat_rec.attribute15);
696: --
697: dbms_sql.bind_variable(p_update_cursor, ':transmission_id',
698: p_bat_rec.transmission_id);
699: --
700: dbms_sql.bind_variable(p_update_cursor, ':bank_deposit_number',
701: p_bat_rec.bank_deposit_number);

Line 700: dbms_sql.bind_variable(p_update_cursor, ':bank_deposit_number',

696: --
697: dbms_sql.bind_variable(p_update_cursor, ':transmission_id',
698: p_bat_rec.transmission_id);
699: --
700: dbms_sql.bind_variable(p_update_cursor, ':bank_deposit_number',
701: p_bat_rec.bank_deposit_number);
702: --
703: dbms_sql.bind_variable(p_update_cursor, ':with_recourse_flag',
704: p_bat_rec.with_recourse_flag);

Line 703: dbms_sql.bind_variable(p_update_cursor, ':with_recourse_flag',

699: --
700: dbms_sql.bind_variable(p_update_cursor, ':bank_deposit_number',
701: p_bat_rec.bank_deposit_number);
702: --
703: dbms_sql.bind_variable(p_update_cursor, ':with_recourse_flag',
704: p_bat_rec.with_recourse_flag);
705: --
706: dbms_sql.bind_variable(p_update_cursor, ':auto_print_program_id',
707: p_bat_rec.auto_print_program_id);

Line 706: dbms_sql.bind_variable(p_update_cursor, ':auto_print_program_id',

702: --
703: dbms_sql.bind_variable(p_update_cursor, ':with_recourse_flag',
704: p_bat_rec.with_recourse_flag);
705: --
706: dbms_sql.bind_variable(p_update_cursor, ':auto_print_program_id',
707: p_bat_rec.auto_print_program_id);
708: --
709: dbms_sql.bind_variable(p_update_cursor, ':auto_trans_program_id',
710: p_bat_rec.auto_trans_program_id);

Line 709: dbms_sql.bind_variable(p_update_cursor, ':auto_trans_program_id',

705: --
706: dbms_sql.bind_variable(p_update_cursor, ':auto_print_program_id',
707: p_bat_rec.auto_print_program_id);
708: --
709: dbms_sql.bind_variable(p_update_cursor, ':auto_trans_program_id',
710: p_bat_rec.auto_trans_program_id);
711: --
712: dbms_sql.bind_variable(p_update_cursor, ':purged_children_flag',
713: p_bat_rec.purged_children_flag);

Line 712: dbms_sql.bind_variable(p_update_cursor, ':purged_children_flag',

708: --
709: dbms_sql.bind_variable(p_update_cursor, ':auto_trans_program_id',
710: p_bat_rec.auto_trans_program_id);
711: --
712: dbms_sql.bind_variable(p_update_cursor, ':purged_children_flag',
713: p_bat_rec.purged_children_flag);
714: --
715: arp_standard.debug('arp_cr_batches_pkg.bind_bat_variables()-');
716: --

Line 721: to_char(dbms_sql.last_error_position));

717: EXCEPTION
718: WHEN OTHERS THEN
719: arp_standard.debug('EXCEPTION: arp_cr_batches_pkg.bind_bat_variables()');
720: arp_standard.debug('Error at character: ' ||
721: to_char(dbms_sql.last_error_position));
722:
723: RAISE;
724: --
725: END;

Line 737: ar_batch_array dbms_sql.number_table;

733: IS
734: --
735: l_count number;
736: l_update_statement varchar2(20000);
737: ar_batch_array dbms_sql.number_table;
738:
739: --
740: BEGIN
741: arp_standard.debug('arp_cr_batches_pkg.generic_update()+');

Line 753: p_update_cursor := dbms_sql.open_cursor;

749: --
750: if (p_update_cursor is null)
751: then
752: --
753: p_update_cursor := dbms_sql.open_cursor;
754: --
755: /*---------------------------------+
756: | Construct the update statement |
757: +---------------------------------*/

Line 773: dbms_sql.parse(p_update_cursor,

769: /*-----------------------------------------------+
770: | Parse, bind, execute and close the statement |
771: +-----------------------------------------------*/
772: --
773: dbms_sql.parse(p_update_cursor,
774: l_update_statement,
775: dbms_sql.v7);
776: --
777:

Line 775: dbms_sql.v7);

771: +-----------------------------------------------*/
772: --
773: dbms_sql.parse(p_update_cursor,
774: l_update_statement,
775: dbms_sql.v7);
776: --
777:
778: arp_standard.debug('after dbms_sql');
779:

Line 778: arp_standard.debug('after dbms_sql');

774: l_update_statement,
775: dbms_sql.v7);
776: --
777:
778: arp_standard.debug('after dbms_sql');
779:
780: end if;
781: --
782: arp_cr_batches_pkg.bind_bat_variables(p_update_cursor, p_bat_rec);

Line 792: dbms_sql.bind_variable(p_update_cursor, ':where_1',

788: +-----------------------------------------*/
789: --
790: if ( p_where1 is not null )
791: then
792: dbms_sql.bind_variable(p_update_cursor, ':where_1',
793: p_where1);
794: end if;
795: arp_standard.debug('after bind_variable ');
796: --

Line 800: dbms_sql.bind_array(p_update_cursor,':ar_batch_key_value',

796: --
797: /*---------------------------+
798: | Bind output variable |
799: +---------------------------*/
800: dbms_sql.bind_array(p_update_cursor,':ar_batch_key_value',
801: ar_batch_array);
802:
803: l_count := dbms_sql.execute(p_update_cursor);
804: --

Line 803: l_count := dbms_sql.execute(p_update_cursor);

799: +---------------------------*/
800: dbms_sql.bind_array(p_update_cursor,':ar_batch_key_value',
801: ar_batch_array);
802:
803: l_count := dbms_sql.execute(p_update_cursor);
804: --
805: arp_standard.debug( to_char(l_count) || ' rows updated');
806: --
807: /*------------------------------------------+

Line 811: dbms_sql.variable_value( p_update_cursor, ':ar_batch_key_value',

807: /*------------------------------------------+
808: | get RETURNING COLUMN into OUT NOCOPY bind array |
809: +------------------------------------------*/
810:
811: dbms_sql.variable_value( p_update_cursor, ':ar_batch_key_value',
812: ar_batch_array);
813:
814: --
815: /*------------------------------------------------------------+

Line 849: to_char(dbms_sql.last_error_position));

845: arp_standard.debug('EXCEPTION: arp_cr_batches_pkg.generic_update()
846: ');
847: arp_standard.debug(l_update_statement);
848: arp_standard.debug('Error at character: ' ||
849: to_char(dbms_sql.last_error_position));
850: --arp_standard.debug('ERROR MESSAGE: ' ||
851: -- sqlerrm);
852: RAISE;
853: END;