APPS.ARP_CR_ICR_PKG dependencies on DBMS_SQL

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

562: /*------------------+
563: | Dummy constants |
564: +------------------*/
565: --
566: dbms_sql.bind_variable(p_update_cursor, ':ar_text_dummy',
567: AR_TEXT_DUMMY);
568: --
569: -- dbms_sql.bind_variable(p_update_cursor, ':ar_flag_dummy',
570: -- AR_FLAG_DUMMY);

Line 569: -- dbms_sql.bind_variable(p_update_cursor, ':ar_flag_dummy',

565: --
566: dbms_sql.bind_variable(p_update_cursor, ':ar_text_dummy',
567: AR_TEXT_DUMMY);
568: --
569: -- dbms_sql.bind_variable(p_update_cursor, ':ar_flag_dummy',
570: -- AR_FLAG_DUMMY);
571: --
572: dbms_sql.bind_variable(p_update_cursor, ':ar_number_dummy',
573: AR_NUMBER_DUMMY);

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

568: --
569: -- dbms_sql.bind_variable(p_update_cursor, ':ar_flag_dummy',
570: -- AR_FLAG_DUMMY);
571: --
572: dbms_sql.bind_variable(p_update_cursor, ':ar_number_dummy',
573: AR_NUMBER_DUMMY);
574: --
575: dbms_sql.bind_variable(p_update_cursor, ':ar_date_dummy',
576: AR_DATE_DUMMY);

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

571: --
572: dbms_sql.bind_variable(p_update_cursor, ':ar_number_dummy',
573: AR_NUMBER_DUMMY);
574: --
575: dbms_sql.bind_variable(p_update_cursor, ':ar_date_dummy',
576: AR_DATE_DUMMY);
577: arp_standard.debug('after duummy');
578: --
579: /*------------------+

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

579: /*------------------+
580: | WHO variables |
581: +------------------*/
582: --
583: dbms_sql.bind_variable(p_update_cursor, ':pg_request_id',
584: pg_request_id);
585: --
586: dbms_sql.bind_variable(p_update_cursor, ':pg_program_application_id',
587: pg_program_application_id);

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

582: --
583: dbms_sql.bind_variable(p_update_cursor, ':pg_request_id',
584: pg_request_id);
585: --
586: dbms_sql.bind_variable(p_update_cursor, ':pg_program_application_id',
587: pg_program_application_id);
588: --
589: dbms_sql.bind_variable(p_update_cursor, ':pg_program_id',
590: pg_program_id);

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

585: --
586: dbms_sql.bind_variable(p_update_cursor, ':pg_program_application_id',
587: pg_program_application_id);
588: --
589: dbms_sql.bind_variable(p_update_cursor, ':pg_program_id',
590: pg_program_id);
591: --
592: dbms_sql.bind_variable(p_update_cursor, ':pg_program_update_date',
593: pg_program_update_date);

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

588: --
589: dbms_sql.bind_variable(p_update_cursor, ':pg_program_id',
590: pg_program_id);
591: --
592: dbms_sql.bind_variable(p_update_cursor, ':pg_program_update_date',
593: pg_program_update_date);
594: --
595: dbms_sql.bind_variable(p_update_cursor, ':pg_last_updated_by',
596: pg_last_updated_by);

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

591: --
592: dbms_sql.bind_variable(p_update_cursor, ':pg_program_update_date',
593: pg_program_update_date);
594: --
595: dbms_sql.bind_variable(p_update_cursor, ':pg_last_updated_by',
596: pg_last_updated_by);
597: --
598: dbms_sql.bind_variable(p_update_cursor, ':pg_last_update_date',
599: pg_last_update_date);

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

594: --
595: dbms_sql.bind_variable(p_update_cursor, ':pg_last_updated_by',
596: pg_last_updated_by);
597: --
598: dbms_sql.bind_variable(p_update_cursor, ':pg_last_update_date',
599: pg_last_update_date);
600: --
601: dbms_sql.bind_variable(p_update_cursor, ':pg_last_update_login',
602: pg_last_update_login);

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

597: --
598: dbms_sql.bind_variable(p_update_cursor, ':pg_last_update_date',
599: pg_last_update_date);
600: --
601: dbms_sql.bind_variable(p_update_cursor, ':pg_last_update_login',
602: pg_last_update_login);
603: arp_standard.debug('after who');
604: /*----------------------------------------------+
605: | Bind variables for all columns in the table |

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

605: | Bind variables for all columns in the table |
606: +----------------------------------------------*/
607: --
608: --
609: dbms_sql.bind_variable(p_update_cursor, ':amount',
610: p_icr_rec.amount);
611: --
612: dbms_sql.bind_variable(p_update_cursor, ':amount_applied',
613: p_icr_rec.amount_applied);

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

608: --
609: dbms_sql.bind_variable(p_update_cursor, ':amount',
610: p_icr_rec.amount);
611: --
612: dbms_sql.bind_variable(p_update_cursor, ':amount_applied',
613: p_icr_rec.amount_applied);
614: --
615: dbms_sql.bind_variable(p_update_cursor, ':trans_to_receipt_rate',
616: p_icr_rec.trans_to_receipt_rate);

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

611: --
612: dbms_sql.bind_variable(p_update_cursor, ':amount_applied',
613: p_icr_rec.amount_applied);
614: --
615: dbms_sql.bind_variable(p_update_cursor, ':trans_to_receipt_rate',
616: p_icr_rec.trans_to_receipt_rate);
617: --
618: dbms_sql.bind_variable(p_update_cursor, ':factor_discount_amount',
619: p_icr_rec.factor_discount_amount);

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

614: --
615: dbms_sql.bind_variable(p_update_cursor, ':trans_to_receipt_rate',
616: p_icr_rec.trans_to_receipt_rate);
617: --
618: dbms_sql.bind_variable(p_update_cursor, ':factor_discount_amount',
619: p_icr_rec.factor_discount_amount);
620: --
621: dbms_sql.bind_variable(p_update_cursor, ':anticipated_clearing_date',
622: p_icr_rec.anticipated_clearing_date);

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

617: --
618: dbms_sql.bind_variable(p_update_cursor, ':factor_discount_amount',
619: p_icr_rec.factor_discount_amount);
620: --
621: dbms_sql.bind_variable(p_update_cursor, ':anticipated_clearing_date',
622: p_icr_rec.anticipated_clearing_date);
623: --
624: dbms_sql.bind_variable(p_update_cursor, ':customer_bank_branch_id',
625: p_icr_rec.customer_bank_branch_id);

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

620: --
621: dbms_sql.bind_variable(p_update_cursor, ':anticipated_clearing_date',
622: p_icr_rec.anticipated_clearing_date);
623: --
624: dbms_sql.bind_variable(p_update_cursor, ':customer_bank_branch_id',
625: p_icr_rec.customer_bank_branch_id);
626: --
627: dbms_sql.bind_variable(p_update_cursor, ':currency_code',
628: p_icr_rec.currency_code);

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

623: --
624: dbms_sql.bind_variable(p_update_cursor, ':customer_bank_branch_id',
625: p_icr_rec.customer_bank_branch_id);
626: --
627: dbms_sql.bind_variable(p_update_cursor, ':currency_code',
628: p_icr_rec.currency_code);
629: --
630: dbms_sql.bind_variable(p_update_cursor, ':receipt_method_id',
631: p_icr_rec.receipt_method_id);

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

626: --
627: dbms_sql.bind_variable(p_update_cursor, ':currency_code',
628: p_icr_rec.currency_code);
629: --
630: dbms_sql.bind_variable(p_update_cursor, ':receipt_method_id',
631: p_icr_rec.receipt_method_id);
632: --
633: dbms_sql.bind_variable(p_update_cursor, ':remit_bank_acct_use_id',
634: p_icr_rec.remit_bank_acct_use_id);

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

629: --
630: dbms_sql.bind_variable(p_update_cursor, ':receipt_method_id',
631: p_icr_rec.receipt_method_id);
632: --
633: dbms_sql.bind_variable(p_update_cursor, ':remit_bank_acct_use_id',
634: p_icr_rec.remit_bank_acct_use_id);
635: --
636: dbms_sql.bind_variable(p_update_cursor, ':batch_id',
637: p_icr_rec.batch_id);

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

632: --
633: dbms_sql.bind_variable(p_update_cursor, ':remit_bank_acct_use_id',
634: p_icr_rec.remit_bank_acct_use_id);
635: --
636: dbms_sql.bind_variable(p_update_cursor, ':batch_id',
637: p_icr_rec.batch_id);
638: --
639: dbms_sql.bind_variable(p_update_cursor, ':comments',
640: p_icr_rec.comments);

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

635: --
636: dbms_sql.bind_variable(p_update_cursor, ':batch_id',
637: p_icr_rec.batch_id);
638: --
639: dbms_sql.bind_variable(p_update_cursor, ':comments',
640: p_icr_rec.comments);
641: --
642: dbms_sql.bind_variable(p_update_cursor, ':customer_trx_id',
643: p_icr_rec.customer_trx_id);

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

638: --
639: dbms_sql.bind_variable(p_update_cursor, ':comments',
640: p_icr_rec.comments);
641: --
642: dbms_sql.bind_variable(p_update_cursor, ':customer_trx_id',
643: p_icr_rec.customer_trx_id);
644: --
645: dbms_sql.bind_variable(p_update_cursor, ':exchange_date',
646: p_icr_rec.exchange_date);

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

641: --
642: dbms_sql.bind_variable(p_update_cursor, ':customer_trx_id',
643: p_icr_rec.customer_trx_id);
644: --
645: dbms_sql.bind_variable(p_update_cursor, ':exchange_date',
646: p_icr_rec.exchange_date);
647: --
648: dbms_sql.bind_variable(p_update_cursor, ':exchange_rate',
649: p_icr_rec.exchange_rate);

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

644: --
645: dbms_sql.bind_variable(p_update_cursor, ':exchange_date',
646: p_icr_rec.exchange_date);
647: --
648: dbms_sql.bind_variable(p_update_cursor, ':exchange_rate',
649: p_icr_rec.exchange_rate);
650: --
651: dbms_sql.bind_variable(p_update_cursor, ':exchange_rate_type',
652: p_icr_rec.exchange_rate_type);

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

647: --
648: dbms_sql.bind_variable(p_update_cursor, ':exchange_rate',
649: p_icr_rec.exchange_rate);
650: --
651: dbms_sql.bind_variable(p_update_cursor, ':exchange_rate_type',
652: p_icr_rec.exchange_rate_type);
653: --
654: dbms_sql.bind_variable(p_update_cursor, ':gl_date',
655: p_icr_rec.gl_date);

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

650: --
651: dbms_sql.bind_variable(p_update_cursor, ':exchange_rate_type',
652: p_icr_rec.exchange_rate_type);
653: --
654: dbms_sql.bind_variable(p_update_cursor, ':gl_date',
655: p_icr_rec.gl_date);
656: --
657: dbms_sql.bind_variable(p_update_cursor, ':gl_posted_date',
658: p_icr_rec.gl_posted_date);

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

653: --
654: dbms_sql.bind_variable(p_update_cursor, ':gl_date',
655: p_icr_rec.gl_date);
656: --
657: dbms_sql.bind_variable(p_update_cursor, ':gl_posted_date',
658: p_icr_rec.gl_posted_date);
659: --
660: dbms_sql.bind_variable(p_update_cursor, ':payment_schedule_id',
661: p_icr_rec.payment_schedule_id);

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

656: --
657: dbms_sql.bind_variable(p_update_cursor, ':gl_posted_date',
658: p_icr_rec.gl_posted_date);
659: --
660: dbms_sql.bind_variable(p_update_cursor, ':payment_schedule_id',
661: p_icr_rec.payment_schedule_id);
662: --
663: dbms_sql.bind_variable(p_update_cursor, ':pay_from_customer',
664: p_icr_rec.pay_from_customer);

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

659: --
660: dbms_sql.bind_variable(p_update_cursor, ':payment_schedule_id',
661: p_icr_rec.payment_schedule_id);
662: --
663: dbms_sql.bind_variable(p_update_cursor, ':pay_from_customer',
664: p_icr_rec.pay_from_customer);
665: --
666: dbms_sql.bind_variable(p_update_cursor, ':receipt_date',
667: p_icr_rec.receipt_date);

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

662: --
663: dbms_sql.bind_variable(p_update_cursor, ':pay_from_customer',
664: p_icr_rec.pay_from_customer);
665: --
666: dbms_sql.bind_variable(p_update_cursor, ':receipt_date',
667: p_icr_rec.receipt_date);
668: --
669: dbms_sql.bind_variable(p_update_cursor, ':receipt_number',
670: p_icr_rec.receipt_number);

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

665: --
666: dbms_sql.bind_variable(p_update_cursor, ':receipt_date',
667: p_icr_rec.receipt_date);
668: --
669: dbms_sql.bind_variable(p_update_cursor, ':receipt_number',
670: p_icr_rec.receipt_number);
671: --
672: dbms_sql.bind_variable(p_update_cursor, ':site_use_id',
673: p_icr_rec.site_use_id);

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

668: --
669: dbms_sql.bind_variable(p_update_cursor, ':receipt_number',
670: p_icr_rec.receipt_number);
671: --
672: dbms_sql.bind_variable(p_update_cursor, ':site_use_id',
673: p_icr_rec.site_use_id);
674: --
675: dbms_sql.bind_variable(p_update_cursor, ':special_type',
676: p_icr_rec.special_type);

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

671: --
672: dbms_sql.bind_variable(p_update_cursor, ':site_use_id',
673: p_icr_rec.site_use_id);
674: --
675: dbms_sql.bind_variable(p_update_cursor, ':special_type',
676: p_icr_rec.special_type);
677: --
678: dbms_sql.bind_variable(p_update_cursor, ':status',
679: p_icr_rec.status);

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

674: --
675: dbms_sql.bind_variable(p_update_cursor, ':special_type',
676: p_icr_rec.special_type);
677: --
678: dbms_sql.bind_variable(p_update_cursor, ':status',
679: p_icr_rec.status);
680: --
681: dbms_sql.bind_variable(p_update_cursor, ':type',
682: p_icr_rec.type);

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

677: --
678: dbms_sql.bind_variable(p_update_cursor, ':status',
679: p_icr_rec.status);
680: --
681: dbms_sql.bind_variable(p_update_cursor, ':type',
682: p_icr_rec.type);
683: --
684: dbms_sql.bind_variable(p_update_cursor, ':ussgl_transaction_code',
685: p_icr_rec.ussgl_transaction_code);

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

680: --
681: dbms_sql.bind_variable(p_update_cursor, ':type',
682: p_icr_rec.type);
683: --
684: dbms_sql.bind_variable(p_update_cursor, ':ussgl_transaction_code',
685: p_icr_rec.ussgl_transaction_code);
686: --
687: dbms_sql.bind_variable(p_update_cursor, ':attribute_category',
688: p_icr_rec.attribute_category);

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

683: --
684: dbms_sql.bind_variable(p_update_cursor, ':ussgl_transaction_code',
685: p_icr_rec.ussgl_transaction_code);
686: --
687: dbms_sql.bind_variable(p_update_cursor, ':attribute_category',
688: p_icr_rec.attribute_category);
689: --
690: dbms_sql.bind_variable(p_update_cursor, ':attribute1',
691: p_icr_rec.attribute1);

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

686: --
687: dbms_sql.bind_variable(p_update_cursor, ':attribute_category',
688: p_icr_rec.attribute_category);
689: --
690: dbms_sql.bind_variable(p_update_cursor, ':attribute1',
691: p_icr_rec.attribute1);
692: --
693: dbms_sql.bind_variable(p_update_cursor, ':attribute2',
694: p_icr_rec.attribute2);

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

689: --
690: dbms_sql.bind_variable(p_update_cursor, ':attribute1',
691: p_icr_rec.attribute1);
692: --
693: dbms_sql.bind_variable(p_update_cursor, ':attribute2',
694: p_icr_rec.attribute2);
695: --
696: dbms_sql.bind_variable(p_update_cursor, ':attribute3',
697: p_icr_rec.attribute3);

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

692: --
693: dbms_sql.bind_variable(p_update_cursor, ':attribute2',
694: p_icr_rec.attribute2);
695: --
696: dbms_sql.bind_variable(p_update_cursor, ':attribute3',
697: p_icr_rec.attribute3);
698: --
699: dbms_sql.bind_variable(p_update_cursor, ':attribute4',
700: p_icr_rec.attribute4);

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

695: --
696: dbms_sql.bind_variable(p_update_cursor, ':attribute3',
697: p_icr_rec.attribute3);
698: --
699: dbms_sql.bind_variable(p_update_cursor, ':attribute4',
700: p_icr_rec.attribute4);
701: --
702: dbms_sql.bind_variable(p_update_cursor, ':attribute5',
703: p_icr_rec.attribute5);

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

698: --
699: dbms_sql.bind_variable(p_update_cursor, ':attribute4',
700: p_icr_rec.attribute4);
701: --
702: dbms_sql.bind_variable(p_update_cursor, ':attribute5',
703: p_icr_rec.attribute5);
704: --
705: dbms_sql.bind_variable(p_update_cursor, ':attribute6',
706: p_icr_rec.attribute6);

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

701: --
702: dbms_sql.bind_variable(p_update_cursor, ':attribute5',
703: p_icr_rec.attribute5);
704: --
705: dbms_sql.bind_variable(p_update_cursor, ':attribute6',
706: p_icr_rec.attribute6);
707: --
708: dbms_sql.bind_variable(p_update_cursor, ':attribute7',
709: p_icr_rec.attribute7);

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

704: --
705: dbms_sql.bind_variable(p_update_cursor, ':attribute6',
706: p_icr_rec.attribute6);
707: --
708: dbms_sql.bind_variable(p_update_cursor, ':attribute7',
709: p_icr_rec.attribute7);
710: --
711: dbms_sql.bind_variable(p_update_cursor, ':attribute8',
712: p_icr_rec.attribute8);

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

707: --
708: dbms_sql.bind_variable(p_update_cursor, ':attribute7',
709: p_icr_rec.attribute7);
710: --
711: dbms_sql.bind_variable(p_update_cursor, ':attribute8',
712: p_icr_rec.attribute8);
713: --
714: dbms_sql.bind_variable(p_update_cursor, ':attribute9',
715: p_icr_rec.attribute9);

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

710: --
711: dbms_sql.bind_variable(p_update_cursor, ':attribute8',
712: p_icr_rec.attribute8);
713: --
714: dbms_sql.bind_variable(p_update_cursor, ':attribute9',
715: p_icr_rec.attribute9);
716: --
717: dbms_sql.bind_variable(p_update_cursor, ':attribute10',
718: p_icr_rec.attribute10);

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

713: --
714: dbms_sql.bind_variable(p_update_cursor, ':attribute9',
715: p_icr_rec.attribute9);
716: --
717: dbms_sql.bind_variable(p_update_cursor, ':attribute10',
718: p_icr_rec.attribute10);
719: --
720: dbms_sql.bind_variable(p_update_cursor, ':attribute11',
721: p_icr_rec.attribute11);

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

716: --
717: dbms_sql.bind_variable(p_update_cursor, ':attribute10',
718: p_icr_rec.attribute10);
719: --
720: dbms_sql.bind_variable(p_update_cursor, ':attribute11',
721: p_icr_rec.attribute11);
722: --
723: dbms_sql.bind_variable(p_update_cursor, ':attribute12',
724: p_icr_rec.attribute12);

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

719: --
720: dbms_sql.bind_variable(p_update_cursor, ':attribute11',
721: p_icr_rec.attribute11);
722: --
723: dbms_sql.bind_variable(p_update_cursor, ':attribute12',
724: p_icr_rec.attribute12);
725: --
726: dbms_sql.bind_variable(p_update_cursor, ':attribute13',
727: p_icr_rec.attribute13);

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

722: --
723: dbms_sql.bind_variable(p_update_cursor, ':attribute12',
724: p_icr_rec.attribute12);
725: --
726: dbms_sql.bind_variable(p_update_cursor, ':attribute13',
727: p_icr_rec.attribute13);
728: --
729: dbms_sql.bind_variable(p_update_cursor, ':attribute14',
730: p_icr_rec.attribute14);

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

725: --
726: dbms_sql.bind_variable(p_update_cursor, ':attribute13',
727: p_icr_rec.attribute13);
728: --
729: dbms_sql.bind_variable(p_update_cursor, ':attribute14',
730: p_icr_rec.attribute14);
731: --
732: dbms_sql.bind_variable(p_update_cursor, ':attribute15',
733: p_icr_rec.attribute15);

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

728: --
729: dbms_sql.bind_variable(p_update_cursor, ':attribute14',
730: p_icr_rec.attribute14);
731: --
732: dbms_sql.bind_variable(p_update_cursor, ':attribute15',
733: p_icr_rec.attribute15);
734: --
735: dbms_sql.bind_variable(p_update_cursor, ':ussgl_transaction_code_context',
736: p_icr_rec.ussgl_transaction_code_context);

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

731: --
732: dbms_sql.bind_variable(p_update_cursor, ':attribute15',
733: p_icr_rec.attribute15);
734: --
735: dbms_sql.bind_variable(p_update_cursor, ':ussgl_transaction_code_context',
736: p_icr_rec.ussgl_transaction_code_context);
737: --
738: dbms_sql.bind_variable(p_update_cursor, ':customer_bank_account_id',
739: p_icr_rec.customer_bank_account_id);

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

734: --
735: dbms_sql.bind_variable(p_update_cursor, ':ussgl_transaction_code_context',
736: p_icr_rec.ussgl_transaction_code_context);
737: --
738: dbms_sql.bind_variable(p_update_cursor, ':customer_bank_account_id',
739: p_icr_rec.customer_bank_account_id);
740: --
741: dbms_sql.bind_variable(p_update_cursor, ':doc_sequence_id',
742: p_icr_rec.doc_sequence_id);

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

737: --
738: dbms_sql.bind_variable(p_update_cursor, ':customer_bank_account_id',
739: p_icr_rec.customer_bank_account_id);
740: --
741: dbms_sql.bind_variable(p_update_cursor, ':doc_sequence_id',
742: p_icr_rec.doc_sequence_id);
743: --
744: dbms_sql.bind_variable(p_update_cursor, ':doc_sequence_value',
745: p_icr_rec.doc_sequence_value);

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

740: --
741: dbms_sql.bind_variable(p_update_cursor, ':doc_sequence_id',
742: p_icr_rec.doc_sequence_id);
743: --
744: dbms_sql.bind_variable(p_update_cursor, ':doc_sequence_value',
745: p_icr_rec.doc_sequence_value);
746: --
747: -- enh 2074220
748: dbms_sql.bind_variable(p_update_cursor, ':application_notes',

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

744: dbms_sql.bind_variable(p_update_cursor, ':doc_sequence_value',
745: p_icr_rec.doc_sequence_value);
746: --
747: -- enh 2074220
748: dbms_sql.bind_variable(p_update_cursor, ':application_notes',
749: p_icr_rec.application_notes);
750: --
751: -- Deductions Enhancement
752: dbms_sql.bind_variable(p_update_cursor, ':application_ref_type',

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

748: dbms_sql.bind_variable(p_update_cursor, ':application_notes',
749: p_icr_rec.application_notes);
750: --
751: -- Deductions Enhancement
752: dbms_sql.bind_variable(p_update_cursor, ':application_ref_type',
753: p_icr_rec.application_ref_type);
754: --
755: dbms_sql.bind_variable(p_update_cursor, ':customer_reference',
756: p_icr_rec.customer_reference);

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

751: -- Deductions Enhancement
752: dbms_sql.bind_variable(p_update_cursor, ':application_ref_type',
753: p_icr_rec.application_ref_type);
754: --
755: dbms_sql.bind_variable(p_update_cursor, ':customer_reference',
756: p_icr_rec.customer_reference);
757: --
758: dbms_sql.bind_variable(p_update_cursor, ':customer_reason',
759: p_icr_rec.customer_reason);

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

754: --
755: dbms_sql.bind_variable(p_update_cursor, ':customer_reference',
756: p_icr_rec.customer_reference);
757: --
758: dbms_sql.bind_variable(p_update_cursor, ':customer_reason',
759: p_icr_rec.customer_reason);
760: --
761:
762: arp_standard.debug('arp_cr_icr_pkg.bind_icr_variables()-');

Line 768: to_char(dbms_sql.last_error_position));

764: EXCEPTION
765: WHEN OTHERS THEN
766: arp_standard.debug('EXCEPTION: arp_cr_icr_pkg.bind_icr_variables()');
767: arp_standard.debug('Error at character: ' ||
768: to_char(dbms_sql.last_error_position));
769:
770: RAISE;
771: --
772: END;

Line 798: p_update_cursor := dbms_sql.open_cursor;

794: --
795: if (p_update_cursor is null)
796: then
797: --
798: p_update_cursor := dbms_sql.open_cursor;
799: --
800: /*---------------------------------+
801: | Construct the update statement |
802: +---------------------------------*/

Line 813: dbms_sql.parse(p_update_cursor,

809: /*-----------------------------------------------+
810: | Parse, bind, execute and close the statement |
811: +-----------------------------------------------*/
812: --
813: dbms_sql.parse(p_update_cursor,
814: l_update_statement,
815: dbms_sql.v7);
816: --
817: arp_standard.debug('after dbms_sql');

Line 815: dbms_sql.v7);

811: +-----------------------------------------------*/
812: --
813: dbms_sql.parse(p_update_cursor,
814: l_update_statement,
815: dbms_sql.v7);
816: --
817: arp_standard.debug('after dbms_sql');
818:
819: end if;

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

813: dbms_sql.parse(p_update_cursor,
814: l_update_statement,
815: dbms_sql.v7);
816: --
817: arp_standard.debug('after dbms_sql');
818:
819: end if;
820: --
821: arp_cr_icr_pkg.bind_icr_variables(p_update_cursor, p_icr_rec);

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

827: +-----------------------------------------*/
828: --
829: if ( p_where1 is not null )
830: then
831: dbms_sql.bind_variable(p_update_cursor, ':where_1',
832: p_where1);
833: end if;
834: arp_standard.debug('after bind_variable ');
835: --

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

832: p_where1);
833: end if;
834: arp_standard.debug('after bind_variable ');
835: --
836: l_count := dbms_sql.execute(p_update_cursor);
837: --
838: arp_standard.debug( to_char(l_count) || ' rows updated');
839: --
840: --

Line 859: to_char(dbms_sql.last_error_position));

855: arp_standard.debug('EXCEPTION: arp_cr_icr_pkg.generic_update()
856: ');
857: arp_standard.debug(l_update_statement);
858: arp_standard.debug('Error at character: ' ||
859: to_char(dbms_sql.last_error_position));
860: --arp_standard.debug('ERROR MESSAGE: ' ||
861: -- sqlerrm);
862: RAISE;
863: END;