APPS.ARP_CR_ICR_PKG dependencies on DBMS_SQL

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

572: /*------------------+
573: | Dummy constants |
574: +------------------*/
575: --
576: dbms_sql.bind_variable(p_update_cursor, ':ar_text_dummy',
577: AR_TEXT_DUMMY);
578: --
579: dbms_sql.bind_variable(p_update_cursor, ':ar_flag_dummy',
580: AR_FLAG_DUMMY);

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

575: --
576: dbms_sql.bind_variable(p_update_cursor, ':ar_text_dummy',
577: AR_TEXT_DUMMY);
578: --
579: dbms_sql.bind_variable(p_update_cursor, ':ar_flag_dummy',
580: AR_FLAG_DUMMY);
581: --
582: dbms_sql.bind_variable(p_update_cursor, ':ar_number_dummy',
583: AR_NUMBER_DUMMY);

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

578: --
579: dbms_sql.bind_variable(p_update_cursor, ':ar_flag_dummy',
580: AR_FLAG_DUMMY);
581: --
582: dbms_sql.bind_variable(p_update_cursor, ':ar_number_dummy',
583: AR_NUMBER_DUMMY);
584: --
585: dbms_sql.bind_variable(p_update_cursor, ':ar_date_dummy',
586: AR_DATE_DUMMY);

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

581: --
582: dbms_sql.bind_variable(p_update_cursor, ':ar_number_dummy',
583: AR_NUMBER_DUMMY);
584: --
585: dbms_sql.bind_variable(p_update_cursor, ':ar_date_dummy',
586: AR_DATE_DUMMY);
587: arp_standard.debug('after duummy');
588: --
589: /*------------------+

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

589: /*------------------+
590: | WHO variables |
591: +------------------*/
592: --
593: dbms_sql.bind_variable(p_update_cursor, ':pg_request_id',
594: pg_request_id);
595: --
596: dbms_sql.bind_variable(p_update_cursor, ':pg_program_application_id',
597: pg_program_application_id);

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

592: --
593: dbms_sql.bind_variable(p_update_cursor, ':pg_request_id',
594: pg_request_id);
595: --
596: dbms_sql.bind_variable(p_update_cursor, ':pg_program_application_id',
597: pg_program_application_id);
598: --
599: dbms_sql.bind_variable(p_update_cursor, ':pg_program_id',
600: pg_program_id);

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

595: --
596: dbms_sql.bind_variable(p_update_cursor, ':pg_program_application_id',
597: pg_program_application_id);
598: --
599: dbms_sql.bind_variable(p_update_cursor, ':pg_program_id',
600: pg_program_id);
601: --
602: dbms_sql.bind_variable(p_update_cursor, ':pg_program_update_date',
603: pg_program_update_date);

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

598: --
599: dbms_sql.bind_variable(p_update_cursor, ':pg_program_id',
600: pg_program_id);
601: --
602: dbms_sql.bind_variable(p_update_cursor, ':pg_program_update_date',
603: pg_program_update_date);
604: --
605: dbms_sql.bind_variable(p_update_cursor, ':pg_last_updated_by',
606: pg_last_updated_by);

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

601: --
602: dbms_sql.bind_variable(p_update_cursor, ':pg_program_update_date',
603: pg_program_update_date);
604: --
605: dbms_sql.bind_variable(p_update_cursor, ':pg_last_updated_by',
606: pg_last_updated_by);
607: --
608: dbms_sql.bind_variable(p_update_cursor, ':pg_last_update_date',
609: pg_last_update_date);

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

604: --
605: dbms_sql.bind_variable(p_update_cursor, ':pg_last_updated_by',
606: pg_last_updated_by);
607: --
608: dbms_sql.bind_variable(p_update_cursor, ':pg_last_update_date',
609: pg_last_update_date);
610: --
611: dbms_sql.bind_variable(p_update_cursor, ':pg_last_update_login',
612: pg_last_update_login);

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

607: --
608: dbms_sql.bind_variable(p_update_cursor, ':pg_last_update_date',
609: pg_last_update_date);
610: --
611: dbms_sql.bind_variable(p_update_cursor, ':pg_last_update_login',
612: pg_last_update_login);
613: arp_standard.debug('after who');
614: /*----------------------------------------------+
615: | Bind variables for all columns in the table |

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

615: | Bind variables for all columns in the table |
616: +----------------------------------------------*/
617: --
618: --
619: dbms_sql.bind_variable(p_update_cursor, ':amount',
620: p_icr_rec.amount);
621: --
622: dbms_sql.bind_variable(p_update_cursor, ':amount_applied',
623: p_icr_rec.amount_applied);

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

618: --
619: dbms_sql.bind_variable(p_update_cursor, ':amount',
620: p_icr_rec.amount);
621: --
622: dbms_sql.bind_variable(p_update_cursor, ':amount_applied',
623: p_icr_rec.amount_applied);
624: --
625: dbms_sql.bind_variable(p_update_cursor, ':trans_to_receipt_rate',
626: p_icr_rec.trans_to_receipt_rate);

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

621: --
622: dbms_sql.bind_variable(p_update_cursor, ':amount_applied',
623: p_icr_rec.amount_applied);
624: --
625: dbms_sql.bind_variable(p_update_cursor, ':trans_to_receipt_rate',
626: p_icr_rec.trans_to_receipt_rate);
627: --
628: dbms_sql.bind_variable(p_update_cursor, ':factor_discount_amount',
629: p_icr_rec.factor_discount_amount);

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

624: --
625: dbms_sql.bind_variable(p_update_cursor, ':trans_to_receipt_rate',
626: p_icr_rec.trans_to_receipt_rate);
627: --
628: dbms_sql.bind_variable(p_update_cursor, ':factor_discount_amount',
629: p_icr_rec.factor_discount_amount);
630: --
631: dbms_sql.bind_variable(p_update_cursor, ':anticipated_clearing_date',
632: p_icr_rec.anticipated_clearing_date);

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

627: --
628: dbms_sql.bind_variable(p_update_cursor, ':factor_discount_amount',
629: p_icr_rec.factor_discount_amount);
630: --
631: dbms_sql.bind_variable(p_update_cursor, ':anticipated_clearing_date',
632: p_icr_rec.anticipated_clearing_date);
633: --
634: dbms_sql.bind_variable(p_update_cursor, ':customer_bank_branch_id',
635: p_icr_rec.customer_bank_branch_id);

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

630: --
631: dbms_sql.bind_variable(p_update_cursor, ':anticipated_clearing_date',
632: p_icr_rec.anticipated_clearing_date);
633: --
634: dbms_sql.bind_variable(p_update_cursor, ':customer_bank_branch_id',
635: p_icr_rec.customer_bank_branch_id);
636: --
637: dbms_sql.bind_variable(p_update_cursor, ':currency_code',
638: p_icr_rec.currency_code);

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

633: --
634: dbms_sql.bind_variable(p_update_cursor, ':customer_bank_branch_id',
635: p_icr_rec.customer_bank_branch_id);
636: --
637: dbms_sql.bind_variable(p_update_cursor, ':currency_code',
638: p_icr_rec.currency_code);
639: --
640: dbms_sql.bind_variable(p_update_cursor, ':receipt_method_id',
641: p_icr_rec.receipt_method_id);

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

636: --
637: dbms_sql.bind_variable(p_update_cursor, ':currency_code',
638: p_icr_rec.currency_code);
639: --
640: dbms_sql.bind_variable(p_update_cursor, ':receipt_method_id',
641: p_icr_rec.receipt_method_id);
642: --
643: dbms_sql.bind_variable(p_update_cursor, ':remit_bank_acct_use_id',
644: p_icr_rec.remit_bank_acct_use_id);

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

639: --
640: dbms_sql.bind_variable(p_update_cursor, ':receipt_method_id',
641: p_icr_rec.receipt_method_id);
642: --
643: dbms_sql.bind_variable(p_update_cursor, ':remit_bank_acct_use_id',
644: p_icr_rec.remit_bank_acct_use_id);
645: --
646: dbms_sql.bind_variable(p_update_cursor, ':batch_id',
647: p_icr_rec.batch_id);

Line 646: dbms_sql.bind_variable(p_update_cursor, ':batch_id',

642: --
643: dbms_sql.bind_variable(p_update_cursor, ':remit_bank_acct_use_id',
644: p_icr_rec.remit_bank_acct_use_id);
645: --
646: dbms_sql.bind_variable(p_update_cursor, ':batch_id',
647: p_icr_rec.batch_id);
648: --
649: dbms_sql.bind_variable(p_update_cursor, ':comments',
650: p_icr_rec.comments);

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

645: --
646: dbms_sql.bind_variable(p_update_cursor, ':batch_id',
647: p_icr_rec.batch_id);
648: --
649: dbms_sql.bind_variable(p_update_cursor, ':comments',
650: p_icr_rec.comments);
651: --
652: dbms_sql.bind_variable(p_update_cursor, ':customer_trx_id',
653: p_icr_rec.customer_trx_id);

Line 652: dbms_sql.bind_variable(p_update_cursor, ':customer_trx_id',

648: --
649: dbms_sql.bind_variable(p_update_cursor, ':comments',
650: p_icr_rec.comments);
651: --
652: dbms_sql.bind_variable(p_update_cursor, ':customer_trx_id',
653: p_icr_rec.customer_trx_id);
654: --
655: dbms_sql.bind_variable(p_update_cursor, ':exchange_date',
656: p_icr_rec.exchange_date);

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

651: --
652: dbms_sql.bind_variable(p_update_cursor, ':customer_trx_id',
653: p_icr_rec.customer_trx_id);
654: --
655: dbms_sql.bind_variable(p_update_cursor, ':exchange_date',
656: p_icr_rec.exchange_date);
657: --
658: dbms_sql.bind_variable(p_update_cursor, ':exchange_rate',
659: p_icr_rec.exchange_rate);

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

654: --
655: dbms_sql.bind_variable(p_update_cursor, ':exchange_date',
656: p_icr_rec.exchange_date);
657: --
658: dbms_sql.bind_variable(p_update_cursor, ':exchange_rate',
659: p_icr_rec.exchange_rate);
660: --
661: dbms_sql.bind_variable(p_update_cursor, ':exchange_rate_type',
662: p_icr_rec.exchange_rate_type);

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

657: --
658: dbms_sql.bind_variable(p_update_cursor, ':exchange_rate',
659: p_icr_rec.exchange_rate);
660: --
661: dbms_sql.bind_variable(p_update_cursor, ':exchange_rate_type',
662: p_icr_rec.exchange_rate_type);
663: --
664: dbms_sql.bind_variable(p_update_cursor, ':gl_date',
665: p_icr_rec.gl_date);

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

660: --
661: dbms_sql.bind_variable(p_update_cursor, ':exchange_rate_type',
662: p_icr_rec.exchange_rate_type);
663: --
664: dbms_sql.bind_variable(p_update_cursor, ':gl_date',
665: p_icr_rec.gl_date);
666: --
667: dbms_sql.bind_variable(p_update_cursor, ':gl_posted_date',
668: p_icr_rec.gl_posted_date);

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

663: --
664: dbms_sql.bind_variable(p_update_cursor, ':gl_date',
665: p_icr_rec.gl_date);
666: --
667: dbms_sql.bind_variable(p_update_cursor, ':gl_posted_date',
668: p_icr_rec.gl_posted_date);
669: --
670: dbms_sql.bind_variable(p_update_cursor, ':payment_schedule_id',
671: p_icr_rec.payment_schedule_id);

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

666: --
667: dbms_sql.bind_variable(p_update_cursor, ':gl_posted_date',
668: p_icr_rec.gl_posted_date);
669: --
670: dbms_sql.bind_variable(p_update_cursor, ':payment_schedule_id',
671: p_icr_rec.payment_schedule_id);
672: --
673: dbms_sql.bind_variable(p_update_cursor, ':pay_from_customer',
674: p_icr_rec.pay_from_customer);

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

669: --
670: dbms_sql.bind_variable(p_update_cursor, ':payment_schedule_id',
671: p_icr_rec.payment_schedule_id);
672: --
673: dbms_sql.bind_variable(p_update_cursor, ':pay_from_customer',
674: p_icr_rec.pay_from_customer);
675: --
676: dbms_sql.bind_variable(p_update_cursor, ':receipt_date',
677: p_icr_rec.receipt_date);

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

672: --
673: dbms_sql.bind_variable(p_update_cursor, ':pay_from_customer',
674: p_icr_rec.pay_from_customer);
675: --
676: dbms_sql.bind_variable(p_update_cursor, ':receipt_date',
677: p_icr_rec.receipt_date);
678: --
679: dbms_sql.bind_variable(p_update_cursor, ':receipt_number',
680: p_icr_rec.receipt_number);

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

675: --
676: dbms_sql.bind_variable(p_update_cursor, ':receipt_date',
677: p_icr_rec.receipt_date);
678: --
679: dbms_sql.bind_variable(p_update_cursor, ':receipt_number',
680: p_icr_rec.receipt_number);
681: --
682: dbms_sql.bind_variable(p_update_cursor, ':site_use_id',
683: p_icr_rec.site_use_id);

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

678: --
679: dbms_sql.bind_variable(p_update_cursor, ':receipt_number',
680: p_icr_rec.receipt_number);
681: --
682: dbms_sql.bind_variable(p_update_cursor, ':site_use_id',
683: p_icr_rec.site_use_id);
684: --
685: dbms_sql.bind_variable(p_update_cursor, ':special_type',
686: p_icr_rec.special_type);

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

681: --
682: dbms_sql.bind_variable(p_update_cursor, ':site_use_id',
683: p_icr_rec.site_use_id);
684: --
685: dbms_sql.bind_variable(p_update_cursor, ':special_type',
686: p_icr_rec.special_type);
687: --
688: dbms_sql.bind_variable(p_update_cursor, ':status',
689: p_icr_rec.status);

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

684: --
685: dbms_sql.bind_variable(p_update_cursor, ':special_type',
686: p_icr_rec.special_type);
687: --
688: dbms_sql.bind_variable(p_update_cursor, ':status',
689: p_icr_rec.status);
690: --
691: dbms_sql.bind_variable(p_update_cursor, ':type',
692: p_icr_rec.type);

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

687: --
688: dbms_sql.bind_variable(p_update_cursor, ':status',
689: p_icr_rec.status);
690: --
691: dbms_sql.bind_variable(p_update_cursor, ':type',
692: p_icr_rec.type);
693: --
694: dbms_sql.bind_variable(p_update_cursor, ':ussgl_transaction_code',
695: p_icr_rec.ussgl_transaction_code);

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

690: --
691: dbms_sql.bind_variable(p_update_cursor, ':type',
692: p_icr_rec.type);
693: --
694: dbms_sql.bind_variable(p_update_cursor, ':ussgl_transaction_code',
695: p_icr_rec.ussgl_transaction_code);
696: --
697: dbms_sql.bind_variable(p_update_cursor, ':attribute_category',
698: p_icr_rec.attribute_category);

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

693: --
694: dbms_sql.bind_variable(p_update_cursor, ':ussgl_transaction_code',
695: p_icr_rec.ussgl_transaction_code);
696: --
697: dbms_sql.bind_variable(p_update_cursor, ':attribute_category',
698: p_icr_rec.attribute_category);
699: --
700: dbms_sql.bind_variable(p_update_cursor, ':attribute1',
701: p_icr_rec.attribute1);

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

696: --
697: dbms_sql.bind_variable(p_update_cursor, ':attribute_category',
698: p_icr_rec.attribute_category);
699: --
700: dbms_sql.bind_variable(p_update_cursor, ':attribute1',
701: p_icr_rec.attribute1);
702: --
703: dbms_sql.bind_variable(p_update_cursor, ':attribute2',
704: p_icr_rec.attribute2);

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

699: --
700: dbms_sql.bind_variable(p_update_cursor, ':attribute1',
701: p_icr_rec.attribute1);
702: --
703: dbms_sql.bind_variable(p_update_cursor, ':attribute2',
704: p_icr_rec.attribute2);
705: --
706: dbms_sql.bind_variable(p_update_cursor, ':attribute3',
707: p_icr_rec.attribute3);

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

702: --
703: dbms_sql.bind_variable(p_update_cursor, ':attribute2',
704: p_icr_rec.attribute2);
705: --
706: dbms_sql.bind_variable(p_update_cursor, ':attribute3',
707: p_icr_rec.attribute3);
708: --
709: dbms_sql.bind_variable(p_update_cursor, ':attribute4',
710: p_icr_rec.attribute4);

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

705: --
706: dbms_sql.bind_variable(p_update_cursor, ':attribute3',
707: p_icr_rec.attribute3);
708: --
709: dbms_sql.bind_variable(p_update_cursor, ':attribute4',
710: p_icr_rec.attribute4);
711: --
712: dbms_sql.bind_variable(p_update_cursor, ':attribute5',
713: p_icr_rec.attribute5);

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

708: --
709: dbms_sql.bind_variable(p_update_cursor, ':attribute4',
710: p_icr_rec.attribute4);
711: --
712: dbms_sql.bind_variable(p_update_cursor, ':attribute5',
713: p_icr_rec.attribute5);
714: --
715: dbms_sql.bind_variable(p_update_cursor, ':attribute6',
716: p_icr_rec.attribute6);

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

711: --
712: dbms_sql.bind_variable(p_update_cursor, ':attribute5',
713: p_icr_rec.attribute5);
714: --
715: dbms_sql.bind_variable(p_update_cursor, ':attribute6',
716: p_icr_rec.attribute6);
717: --
718: dbms_sql.bind_variable(p_update_cursor, ':attribute7',
719: p_icr_rec.attribute7);

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

714: --
715: dbms_sql.bind_variable(p_update_cursor, ':attribute6',
716: p_icr_rec.attribute6);
717: --
718: dbms_sql.bind_variable(p_update_cursor, ':attribute7',
719: p_icr_rec.attribute7);
720: --
721: dbms_sql.bind_variable(p_update_cursor, ':attribute8',
722: p_icr_rec.attribute8);

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

717: --
718: dbms_sql.bind_variable(p_update_cursor, ':attribute7',
719: p_icr_rec.attribute7);
720: --
721: dbms_sql.bind_variable(p_update_cursor, ':attribute8',
722: p_icr_rec.attribute8);
723: --
724: dbms_sql.bind_variable(p_update_cursor, ':attribute9',
725: p_icr_rec.attribute9);

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

720: --
721: dbms_sql.bind_variable(p_update_cursor, ':attribute8',
722: p_icr_rec.attribute8);
723: --
724: dbms_sql.bind_variable(p_update_cursor, ':attribute9',
725: p_icr_rec.attribute9);
726: --
727: dbms_sql.bind_variable(p_update_cursor, ':attribute10',
728: p_icr_rec.attribute10);

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

723: --
724: dbms_sql.bind_variable(p_update_cursor, ':attribute9',
725: p_icr_rec.attribute9);
726: --
727: dbms_sql.bind_variable(p_update_cursor, ':attribute10',
728: p_icr_rec.attribute10);
729: --
730: dbms_sql.bind_variable(p_update_cursor, ':attribute11',
731: p_icr_rec.attribute11);

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

726: --
727: dbms_sql.bind_variable(p_update_cursor, ':attribute10',
728: p_icr_rec.attribute10);
729: --
730: dbms_sql.bind_variable(p_update_cursor, ':attribute11',
731: p_icr_rec.attribute11);
732: --
733: dbms_sql.bind_variable(p_update_cursor, ':attribute12',
734: p_icr_rec.attribute12);

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

729: --
730: dbms_sql.bind_variable(p_update_cursor, ':attribute11',
731: p_icr_rec.attribute11);
732: --
733: dbms_sql.bind_variable(p_update_cursor, ':attribute12',
734: p_icr_rec.attribute12);
735: --
736: dbms_sql.bind_variable(p_update_cursor, ':attribute13',
737: p_icr_rec.attribute13);

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

732: --
733: dbms_sql.bind_variable(p_update_cursor, ':attribute12',
734: p_icr_rec.attribute12);
735: --
736: dbms_sql.bind_variable(p_update_cursor, ':attribute13',
737: p_icr_rec.attribute13);
738: --
739: dbms_sql.bind_variable(p_update_cursor, ':attribute14',
740: p_icr_rec.attribute14);

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

735: --
736: dbms_sql.bind_variable(p_update_cursor, ':attribute13',
737: p_icr_rec.attribute13);
738: --
739: dbms_sql.bind_variable(p_update_cursor, ':attribute14',
740: p_icr_rec.attribute14);
741: --
742: dbms_sql.bind_variable(p_update_cursor, ':attribute15',
743: p_icr_rec.attribute15);

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

738: --
739: dbms_sql.bind_variable(p_update_cursor, ':attribute14',
740: p_icr_rec.attribute14);
741: --
742: dbms_sql.bind_variable(p_update_cursor, ':attribute15',
743: p_icr_rec.attribute15);
744: --
745: dbms_sql.bind_variable(p_update_cursor, ':ussgl_transaction_code_context',
746: p_icr_rec.ussgl_transaction_code_context);

Line 745: dbms_sql.bind_variable(p_update_cursor, ':ussgl_transaction_code_context',

741: --
742: dbms_sql.bind_variable(p_update_cursor, ':attribute15',
743: p_icr_rec.attribute15);
744: --
745: dbms_sql.bind_variable(p_update_cursor, ':ussgl_transaction_code_context',
746: p_icr_rec.ussgl_transaction_code_context);
747: --
748: dbms_sql.bind_variable(p_update_cursor, ':customer_bank_account_id',
749: p_icr_rec.customer_bank_account_id);

Line 748: dbms_sql.bind_variable(p_update_cursor, ':customer_bank_account_id',

744: --
745: dbms_sql.bind_variable(p_update_cursor, ':ussgl_transaction_code_context',
746: p_icr_rec.ussgl_transaction_code_context);
747: --
748: dbms_sql.bind_variable(p_update_cursor, ':customer_bank_account_id',
749: p_icr_rec.customer_bank_account_id);
750: --
751: dbms_sql.bind_variable(p_update_cursor, ':doc_sequence_id',
752: p_icr_rec.doc_sequence_id);

Line 751: dbms_sql.bind_variable(p_update_cursor, ':doc_sequence_id',

747: --
748: dbms_sql.bind_variable(p_update_cursor, ':customer_bank_account_id',
749: p_icr_rec.customer_bank_account_id);
750: --
751: dbms_sql.bind_variable(p_update_cursor, ':doc_sequence_id',
752: p_icr_rec.doc_sequence_id);
753: --
754: dbms_sql.bind_variable(p_update_cursor, ':doc_sequence_value',
755: p_icr_rec.doc_sequence_value);

Line 754: dbms_sql.bind_variable(p_update_cursor, ':doc_sequence_value',

750: --
751: dbms_sql.bind_variable(p_update_cursor, ':doc_sequence_id',
752: p_icr_rec.doc_sequence_id);
753: --
754: dbms_sql.bind_variable(p_update_cursor, ':doc_sequence_value',
755: p_icr_rec.doc_sequence_value);
756: --
757: -- enh 2074220
758: dbms_sql.bind_variable(p_update_cursor, ':application_notes',

Line 758: dbms_sql.bind_variable(p_update_cursor, ':application_notes',

754: dbms_sql.bind_variable(p_update_cursor, ':doc_sequence_value',
755: p_icr_rec.doc_sequence_value);
756: --
757: -- enh 2074220
758: dbms_sql.bind_variable(p_update_cursor, ':application_notes',
759: p_icr_rec.application_notes);
760: --
761: -- Deductions Enhancement
762: dbms_sql.bind_variable(p_update_cursor, ':application_ref_type',

Line 762: dbms_sql.bind_variable(p_update_cursor, ':application_ref_type',

758: dbms_sql.bind_variable(p_update_cursor, ':application_notes',
759: p_icr_rec.application_notes);
760: --
761: -- Deductions Enhancement
762: dbms_sql.bind_variable(p_update_cursor, ':application_ref_type',
763: p_icr_rec.application_ref_type);
764: --
765: dbms_sql.bind_variable(p_update_cursor, ':customer_reference',
766: p_icr_rec.customer_reference);

Line 765: dbms_sql.bind_variable(p_update_cursor, ':customer_reference',

761: -- Deductions Enhancement
762: dbms_sql.bind_variable(p_update_cursor, ':application_ref_type',
763: p_icr_rec.application_ref_type);
764: --
765: dbms_sql.bind_variable(p_update_cursor, ':customer_reference',
766: p_icr_rec.customer_reference);
767: --
768: dbms_sql.bind_variable(p_update_cursor, ':customer_reason',
769: p_icr_rec.customer_reason);

Line 768: dbms_sql.bind_variable(p_update_cursor, ':customer_reason',

764: --
765: dbms_sql.bind_variable(p_update_cursor, ':customer_reference',
766: p_icr_rec.customer_reference);
767: --
768: dbms_sql.bind_variable(p_update_cursor, ':customer_reason',
769: p_icr_rec.customer_reason);
770: --
771:
772: --

Line 773: dbms_sql.bind_variable(p_update_cursor, ':automatch_set_id',

769: p_icr_rec.customer_reason);
770: --
771:
772: --
773: dbms_sql.bind_variable(p_update_cursor, ':automatch_set_id',
774: p_icr_rec.automatch_set_id);
775: --
776:
777: --

Line 778: dbms_sql.bind_variable(p_update_cursor, ':autoapply_flag',

774: p_icr_rec.automatch_set_id);
775: --
776:
777: --
778: dbms_sql.bind_variable(p_update_cursor, ':autoapply_flag',
779: p_icr_rec.autoapply_flag);
780: --
781:
782: arp_standard.debug('arp_cr_icr_pkg.bind_icr_variables()-');

Line 788: to_char(dbms_sql.last_error_position));

784: EXCEPTION
785: WHEN OTHERS THEN
786: arp_standard.debug('EXCEPTION: arp_cr_icr_pkg.bind_icr_variables()');
787: arp_standard.debug('Error at character: ' ||
788: to_char(dbms_sql.last_error_position));
789:
790: RAISE;
791: --
792: END;

Line 818: p_update_cursor := dbms_sql.open_cursor;

814: --
815: if (p_update_cursor is null)
816: then
817: --
818: p_update_cursor := dbms_sql.open_cursor;
819: --
820: /*---------------------------------+
821: | Construct the update statement |
822: +---------------------------------*/

Line 833: dbms_sql.parse(p_update_cursor,

829: /*-----------------------------------------------+
830: | Parse, bind, execute and close the statement |
831: +-----------------------------------------------*/
832: --
833: dbms_sql.parse(p_update_cursor,
834: l_update_statement,
835: dbms_sql.v7);
836: --
837: arp_standard.debug('after dbms_sql');

Line 835: dbms_sql.v7);

831: +-----------------------------------------------*/
832: --
833: dbms_sql.parse(p_update_cursor,
834: l_update_statement,
835: dbms_sql.v7);
836: --
837: arp_standard.debug('after dbms_sql');
838:
839: end if;

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

833: dbms_sql.parse(p_update_cursor,
834: l_update_statement,
835: dbms_sql.v7);
836: --
837: arp_standard.debug('after dbms_sql');
838:
839: end if;
840: --
841: arp_cr_icr_pkg.bind_icr_variables(p_update_cursor, p_icr_rec);

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

847: +-----------------------------------------*/
848: --
849: if ( p_where1 is not null )
850: then
851: dbms_sql.bind_variable(p_update_cursor, ':where_1',
852: p_where1);
853: end if;
854: arp_standard.debug('after bind_variable ');
855: --

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

852: p_where1);
853: end if;
854: arp_standard.debug('after bind_variable ');
855: --
856: l_count := dbms_sql.execute(p_update_cursor);
857: --
858: arp_standard.debug( to_char(l_count) || ' rows updated');
859: --
860: --

Line 879: to_char(dbms_sql.last_error_position));

875: arp_standard.debug('EXCEPTION: arp_cr_icr_pkg.generic_update()
876: ');
877: arp_standard.debug(l_update_statement);
878: arp_standard.debug('Error at character: ' ||
879: to_char(dbms_sql.last_error_position));
880: --arp_standard.debug('ERROR MESSAGE: ' ||
881: -- sqlerrm);
882: RAISE;
883: END;