APPS.ARP_CR_ICR_LINES_PKG dependencies on DBMS_SQL

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

606: /*------------------+
607: | Dummy constants |
608: +------------------*/
609: --
610: dbms_sql.bind_variable(p_update_cursor, ':ar_text_dummy',
611: AR_TEXT_DUMMY);
612: --
613: -- dbms_sql.bind_variable(p_update_cursor, ':ar_flag_dummy',
614: -- AR_FLAG_DUMMY);

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

609: --
610: dbms_sql.bind_variable(p_update_cursor, ':ar_text_dummy',
611: AR_TEXT_DUMMY);
612: --
613: -- dbms_sql.bind_variable(p_update_cursor, ':ar_flag_dummy',
614: -- AR_FLAG_DUMMY);
615: --
616: dbms_sql.bind_variable(p_update_cursor, ':ar_number_dummy',
617: AR_NUMBER_DUMMY);

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

612: --
613: -- dbms_sql.bind_variable(p_update_cursor, ':ar_flag_dummy',
614: -- AR_FLAG_DUMMY);
615: --
616: dbms_sql.bind_variable(p_update_cursor, ':ar_number_dummy',
617: AR_NUMBER_DUMMY);
618: --
619: dbms_sql.bind_variable(p_update_cursor, ':ar_date_dummy',
620: AR_DATE_DUMMY);

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

615: --
616: dbms_sql.bind_variable(p_update_cursor, ':ar_number_dummy',
617: AR_NUMBER_DUMMY);
618: --
619: dbms_sql.bind_variable(p_update_cursor, ':ar_date_dummy',
620: AR_DATE_DUMMY);
621: arp_standard.debug('after duummy');
622: --
623: /*------------------+

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

623: /*------------------+
624: | WHO variables |
625: +------------------*/
626: --
627: dbms_sql.bind_variable(p_update_cursor, ':pg_request_id',
628: pg_request_id);
629: --
630: dbms_sql.bind_variable(p_update_cursor, ':pg_program_application_id',
631: pg_program_application_id);

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

626: --
627: dbms_sql.bind_variable(p_update_cursor, ':pg_request_id',
628: pg_request_id);
629: --
630: dbms_sql.bind_variable(p_update_cursor, ':pg_program_application_id',
631: pg_program_application_id);
632: --
633: dbms_sql.bind_variable(p_update_cursor, ':pg_program_id',
634: pg_program_id);

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

629: --
630: dbms_sql.bind_variable(p_update_cursor, ':pg_program_application_id',
631: pg_program_application_id);
632: --
633: dbms_sql.bind_variable(p_update_cursor, ':pg_program_id',
634: pg_program_id);
635: --
636: dbms_sql.bind_variable(p_update_cursor, ':pg_program_update_date',
637: pg_program_update_date);

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

632: --
633: dbms_sql.bind_variable(p_update_cursor, ':pg_program_id',
634: pg_program_id);
635: --
636: dbms_sql.bind_variable(p_update_cursor, ':pg_program_update_date',
637: pg_program_update_date);
638: --
639: dbms_sql.bind_variable(p_update_cursor, ':pg_last_updated_by',
640: pg_last_updated_by);

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

635: --
636: dbms_sql.bind_variable(p_update_cursor, ':pg_program_update_date',
637: pg_program_update_date);
638: --
639: dbms_sql.bind_variable(p_update_cursor, ':pg_last_updated_by',
640: pg_last_updated_by);
641: --
642: dbms_sql.bind_variable(p_update_cursor, ':pg_last_update_date',
643: pg_last_update_date);

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

638: --
639: dbms_sql.bind_variable(p_update_cursor, ':pg_last_updated_by',
640: pg_last_updated_by);
641: --
642: dbms_sql.bind_variable(p_update_cursor, ':pg_last_update_date',
643: pg_last_update_date);
644: --
645: dbms_sql.bind_variable(p_update_cursor, ':pg_last_update_login',
646: pg_last_update_login);

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

641: --
642: dbms_sql.bind_variable(p_update_cursor, ':pg_last_update_date',
643: pg_last_update_date);
644: --
645: dbms_sql.bind_variable(p_update_cursor, ':pg_last_update_login',
646: pg_last_update_login);
647: arp_standard.debug('after who');
648: /*----------------------------------------------+
649: | Bind variables for all columns in the table |

Line 653: dbms_sql.bind_variable(p_update_cursor, ':payment_amount',

649: | Bind variables for all columns in the table |
650: +----------------------------------------------*/
651: --
652: --
653: dbms_sql.bind_variable(p_update_cursor, ':payment_amount',
654: p_icr_lines_rec.payment_amount);
655: --
656: dbms_sql.bind_variable(p_update_cursor, ':amount_applied_from',
657: p_icr_lines_rec.amount_applied_from);

Line 656: dbms_sql.bind_variable(p_update_cursor, ':amount_applied_from',

652: --
653: dbms_sql.bind_variable(p_update_cursor, ':payment_amount',
654: p_icr_lines_rec.payment_amount);
655: --
656: dbms_sql.bind_variable(p_update_cursor, ':amount_applied_from',
657: p_icr_lines_rec.amount_applied_from);
658: --
659: dbms_sql.bind_variable(p_update_cursor, ':trans_to_receipt_rate',
660: p_icr_lines_rec.trans_to_receipt_rate);

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

655: --
656: dbms_sql.bind_variable(p_update_cursor, ':amount_applied_from',
657: p_icr_lines_rec.amount_applied_from);
658: --
659: dbms_sql.bind_variable(p_update_cursor, ':trans_to_receipt_rate',
660: p_icr_lines_rec.trans_to_receipt_rate);
661: --
662: dbms_sql.bind_variable(p_update_cursor, ':payment_schedule_id',
663: p_icr_lines_rec.payment_schedule_id);

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

658: --
659: dbms_sql.bind_variable(p_update_cursor, ':trans_to_receipt_rate',
660: p_icr_lines_rec.trans_to_receipt_rate);
661: --
662: dbms_sql.bind_variable(p_update_cursor, ':payment_schedule_id',
663: p_icr_lines_rec.payment_schedule_id);
664: --
665: dbms_sql.bind_variable(p_update_cursor, ':customer_trx_id',
666: p_icr_lines_rec.customer_trx_id);

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

661: --
662: dbms_sql.bind_variable(p_update_cursor, ':payment_schedule_id',
663: p_icr_lines_rec.payment_schedule_id);
664: --
665: dbms_sql.bind_variable(p_update_cursor, ':customer_trx_id',
666: p_icr_lines_rec.customer_trx_id);
667: --
668: dbms_sql.bind_variable(p_update_cursor, ':customer_trx_line_id',
669: p_icr_lines_rec.customer_trx_line_id);

Line 668: dbms_sql.bind_variable(p_update_cursor, ':customer_trx_line_id',

664: --
665: dbms_sql.bind_variable(p_update_cursor, ':customer_trx_id',
666: p_icr_lines_rec.customer_trx_id);
667: --
668: dbms_sql.bind_variable(p_update_cursor, ':customer_trx_line_id',
669: p_icr_lines_rec.customer_trx_line_id);
670: --
671: dbms_sql.bind_variable(p_update_cursor, ':batch_id',
672: p_icr_lines_rec.batch_id);

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

667: --
668: dbms_sql.bind_variable(p_update_cursor, ':customer_trx_line_id',
669: p_icr_lines_rec.customer_trx_line_id);
670: --
671: dbms_sql.bind_variable(p_update_cursor, ':batch_id',
672: p_icr_lines_rec.batch_id);
673: --
674: dbms_sql.bind_variable(p_update_cursor, ':sold_to_customer',
675: p_icr_lines_rec.sold_to_customer);

Line 674: dbms_sql.bind_variable(p_update_cursor, ':sold_to_customer',

670: --
671: dbms_sql.bind_variable(p_update_cursor, ':batch_id',
672: p_icr_lines_rec.batch_id);
673: --
674: dbms_sql.bind_variable(p_update_cursor, ':sold_to_customer',
675: p_icr_lines_rec.sold_to_customer);
676: --
677: dbms_sql.bind_variable(p_update_cursor, ':discount_taken',
678: p_icr_lines_rec.discount_taken);

Line 677: dbms_sql.bind_variable(p_update_cursor, ':discount_taken',

673: --
674: dbms_sql.bind_variable(p_update_cursor, ':sold_to_customer',
675: p_icr_lines_rec.sold_to_customer);
676: --
677: dbms_sql.bind_variable(p_update_cursor, ':discount_taken',
678: p_icr_lines_rec.discount_taken);
679: --
680: dbms_sql.bind_variable(p_update_cursor, ':due_date',
681: p_icr_lines_rec.due_date);

Line 680: dbms_sql.bind_variable(p_update_cursor, ':due_date',

676: --
677: dbms_sql.bind_variable(p_update_cursor, ':discount_taken',
678: p_icr_lines_rec.discount_taken);
679: --
680: dbms_sql.bind_variable(p_update_cursor, ':due_date',
681: p_icr_lines_rec.due_date);
682: --
683: dbms_sql.bind_variable(p_update_cursor, ':attribute_category',
684: p_icr_lines_rec.attribute_category);

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

679: --
680: dbms_sql.bind_variable(p_update_cursor, ':due_date',
681: p_icr_lines_rec.due_date);
682: --
683: dbms_sql.bind_variable(p_update_cursor, ':attribute_category',
684: p_icr_lines_rec.attribute_category);
685: --
686: dbms_sql.bind_variable(p_update_cursor, ':attribute1',
687: p_icr_lines_rec.attribute1);

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

682: --
683: dbms_sql.bind_variable(p_update_cursor, ':attribute_category',
684: p_icr_lines_rec.attribute_category);
685: --
686: dbms_sql.bind_variable(p_update_cursor, ':attribute1',
687: p_icr_lines_rec.attribute1);
688: --
689: dbms_sql.bind_variable(p_update_cursor, ':attribute2',
690: p_icr_lines_rec.attribute2);

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

685: --
686: dbms_sql.bind_variable(p_update_cursor, ':attribute1',
687: p_icr_lines_rec.attribute1);
688: --
689: dbms_sql.bind_variable(p_update_cursor, ':attribute2',
690: p_icr_lines_rec.attribute2);
691: --
692: dbms_sql.bind_variable(p_update_cursor, ':attribute3',
693: p_icr_lines_rec.attribute3);

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

688: --
689: dbms_sql.bind_variable(p_update_cursor, ':attribute2',
690: p_icr_lines_rec.attribute2);
691: --
692: dbms_sql.bind_variable(p_update_cursor, ':attribute3',
693: p_icr_lines_rec.attribute3);
694: --
695: dbms_sql.bind_variable(p_update_cursor, ':attribute4',
696: p_icr_lines_rec.attribute4);

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

691: --
692: dbms_sql.bind_variable(p_update_cursor, ':attribute3',
693: p_icr_lines_rec.attribute3);
694: --
695: dbms_sql.bind_variable(p_update_cursor, ':attribute4',
696: p_icr_lines_rec.attribute4);
697: --
698: --
699: dbms_sql.bind_variable(p_update_cursor, ':attribute5',

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

728: --
729: dbms_sql.bind_variable(p_update_cursor, ':attribute15',
730: p_icr_lines_rec.attribute15);
731: --
732: dbms_sql.bind_variable(p_update_cursor, ':global_attribute_category',
733: p_icr_lines_rec.global_attribute_category);
734: --
735: dbms_sql.bind_variable(p_update_cursor, ':global_attribute1',
736: p_icr_lines_rec.global_attribute1);

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

731: --
732: dbms_sql.bind_variable(p_update_cursor, ':global_attribute_category',
733: p_icr_lines_rec.global_attribute_category);
734: --
735: dbms_sql.bind_variable(p_update_cursor, ':global_attribute1',
736: p_icr_lines_rec.global_attribute1);
737: --
738: dbms_sql.bind_variable(p_update_cursor, ':global_attribute2',
739: p_icr_lines_rec.global_attribute2);

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

734: --
735: dbms_sql.bind_variable(p_update_cursor, ':global_attribute1',
736: p_icr_lines_rec.global_attribute1);
737: --
738: dbms_sql.bind_variable(p_update_cursor, ':global_attribute2',
739: p_icr_lines_rec.global_attribute2);
740: --
741: dbms_sql.bind_variable(p_update_cursor, ':global_attribute3',
742: p_icr_lines_rec.global_attribute3);

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

737: --
738: dbms_sql.bind_variable(p_update_cursor, ':global_attribute2',
739: p_icr_lines_rec.global_attribute2);
740: --
741: dbms_sql.bind_variable(p_update_cursor, ':global_attribute3',
742: p_icr_lines_rec.global_attribute3);
743: --
744: dbms_sql.bind_variable(p_update_cursor, ':global_attribute4',
745: p_icr_lines_rec.global_attribute4);

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

740: --
741: dbms_sql.bind_variable(p_update_cursor, ':global_attribute3',
742: p_icr_lines_rec.global_attribute3);
743: --
744: dbms_sql.bind_variable(p_update_cursor, ':global_attribute4',
745: p_icr_lines_rec.global_attribute4);
746: --
747: dbms_sql.bind_variable(p_update_cursor, ':global_attribute5',
748: p_icr_lines_rec.global_attribute5);

Line 747: dbms_sql.bind_variable(p_update_cursor, ':global_attribute5',

743: --
744: dbms_sql.bind_variable(p_update_cursor, ':global_attribute4',
745: p_icr_lines_rec.global_attribute4);
746: --
747: dbms_sql.bind_variable(p_update_cursor, ':global_attribute5',
748: p_icr_lines_rec.global_attribute5);
749: --
750: dbms_sql.bind_variable(p_update_cursor, ':global_attribute6',
751: p_icr_lines_rec.global_attribute6);

Line 750: dbms_sql.bind_variable(p_update_cursor, ':global_attribute6',

746: --
747: dbms_sql.bind_variable(p_update_cursor, ':global_attribute5',
748: p_icr_lines_rec.global_attribute5);
749: --
750: dbms_sql.bind_variable(p_update_cursor, ':global_attribute6',
751: p_icr_lines_rec.global_attribute6);
752: --
753: dbms_sql.bind_variable(p_update_cursor, ':global_attribute7',
754: p_icr_lines_rec.global_attribute7);

Line 753: dbms_sql.bind_variable(p_update_cursor, ':global_attribute7',

749: --
750: dbms_sql.bind_variable(p_update_cursor, ':global_attribute6',
751: p_icr_lines_rec.global_attribute6);
752: --
753: dbms_sql.bind_variable(p_update_cursor, ':global_attribute7',
754: p_icr_lines_rec.global_attribute7);
755: --
756: dbms_sql.bind_variable(p_update_cursor, ':global_attribute8',
757: p_icr_lines_rec.global_attribute8);

Line 756: dbms_sql.bind_variable(p_update_cursor, ':global_attribute8',

752: --
753: dbms_sql.bind_variable(p_update_cursor, ':global_attribute7',
754: p_icr_lines_rec.global_attribute7);
755: --
756: dbms_sql.bind_variable(p_update_cursor, ':global_attribute8',
757: p_icr_lines_rec.global_attribute8);
758: --
759: dbms_sql.bind_variable(p_update_cursor, ':global_attribute9',
760: p_icr_lines_rec.global_attribute9);

Line 759: dbms_sql.bind_variable(p_update_cursor, ':global_attribute9',

755: --
756: dbms_sql.bind_variable(p_update_cursor, ':global_attribute8',
757: p_icr_lines_rec.global_attribute8);
758: --
759: dbms_sql.bind_variable(p_update_cursor, ':global_attribute9',
760: p_icr_lines_rec.global_attribute9);
761: --
762: dbms_sql.bind_variable(p_update_cursor, ':global_attribute10',
763: p_icr_lines_rec.global_attribute10);

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

758: --
759: dbms_sql.bind_variable(p_update_cursor, ':global_attribute9',
760: p_icr_lines_rec.global_attribute9);
761: --
762: dbms_sql.bind_variable(p_update_cursor, ':global_attribute10',
763: p_icr_lines_rec.global_attribute10);
764: --
765: dbms_sql.bind_variable(p_update_cursor, ':global_attribute11',
766: p_icr_lines_rec.global_attribute11);

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

761: --
762: dbms_sql.bind_variable(p_update_cursor, ':global_attribute10',
763: p_icr_lines_rec.global_attribute10);
764: --
765: dbms_sql.bind_variable(p_update_cursor, ':global_attribute11',
766: p_icr_lines_rec.global_attribute11);
767: --
768: dbms_sql.bind_variable(p_update_cursor, ':global_attribute12',
769: p_icr_lines_rec.global_attribute12);

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

764: --
765: dbms_sql.bind_variable(p_update_cursor, ':global_attribute11',
766: p_icr_lines_rec.global_attribute11);
767: --
768: dbms_sql.bind_variable(p_update_cursor, ':global_attribute12',
769: p_icr_lines_rec.global_attribute12);
770: --
771: dbms_sql.bind_variable(p_update_cursor, ':global_attribute13',
772: p_icr_lines_rec.global_attribute13);

Line 771: dbms_sql.bind_variable(p_update_cursor, ':global_attribute13',

767: --
768: dbms_sql.bind_variable(p_update_cursor, ':global_attribute12',
769: p_icr_lines_rec.global_attribute12);
770: --
771: dbms_sql.bind_variable(p_update_cursor, ':global_attribute13',
772: p_icr_lines_rec.global_attribute13);
773: --
774: dbms_sql.bind_variable(p_update_cursor, ':global_attribute14',
775: p_icr_lines_rec.global_attribute14);

Line 774: dbms_sql.bind_variable(p_update_cursor, ':global_attribute14',

770: --
771: dbms_sql.bind_variable(p_update_cursor, ':global_attribute13',
772: p_icr_lines_rec.global_attribute13);
773: --
774: dbms_sql.bind_variable(p_update_cursor, ':global_attribute14',
775: p_icr_lines_rec.global_attribute14);
776: --
777: dbms_sql.bind_variable(p_update_cursor, ':global_attribute15',
778: p_icr_lines_rec.global_attribute15);

Line 777: dbms_sql.bind_variable(p_update_cursor, ':global_attribute15',

773: --
774: dbms_sql.bind_variable(p_update_cursor, ':global_attribute14',
775: p_icr_lines_rec.global_attribute14);
776: --
777: dbms_sql.bind_variable(p_update_cursor, ':global_attribute15',
778: p_icr_lines_rec.global_attribute15);
779: --
780: dbms_sql.bind_variable(p_update_cursor, ':global_attribute16',
781: p_icr_lines_rec.global_attribute16);

Line 780: dbms_sql.bind_variable(p_update_cursor, ':global_attribute16',

776: --
777: dbms_sql.bind_variable(p_update_cursor, ':global_attribute15',
778: p_icr_lines_rec.global_attribute15);
779: --
780: dbms_sql.bind_variable(p_update_cursor, ':global_attribute16',
781: p_icr_lines_rec.global_attribute16);
782: --
783: dbms_sql.bind_variable(p_update_cursor, ':global_attribute17',
784: p_icr_lines_rec.global_attribute17);

Line 783: dbms_sql.bind_variable(p_update_cursor, ':global_attribute17',

779: --
780: dbms_sql.bind_variable(p_update_cursor, ':global_attribute16',
781: p_icr_lines_rec.global_attribute16);
782: --
783: dbms_sql.bind_variable(p_update_cursor, ':global_attribute17',
784: p_icr_lines_rec.global_attribute17);
785: --
786: dbms_sql.bind_variable(p_update_cursor, ':global_attribute18',
787: p_icr_lines_rec.global_attribute18);

Line 786: dbms_sql.bind_variable(p_update_cursor, ':global_attribute18',

782: --
783: dbms_sql.bind_variable(p_update_cursor, ':global_attribute17',
784: p_icr_lines_rec.global_attribute17);
785: --
786: dbms_sql.bind_variable(p_update_cursor, ':global_attribute18',
787: p_icr_lines_rec.global_attribute18);
788: --
789: dbms_sql.bind_variable(p_update_cursor, ':global_attribute19',
790: p_icr_lines_rec.global_attribute19);

Line 789: dbms_sql.bind_variable(p_update_cursor, ':global_attribute19',

785: --
786: dbms_sql.bind_variable(p_update_cursor, ':global_attribute18',
787: p_icr_lines_rec.global_attribute18);
788: --
789: dbms_sql.bind_variable(p_update_cursor, ':global_attribute19',
790: p_icr_lines_rec.global_attribute19);
791: --
792: dbms_sql.bind_variable(p_update_cursor, ':global_attribute20',
793: p_icr_lines_rec.global_attribute20);

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

788: --
789: dbms_sql.bind_variable(p_update_cursor, ':global_attribute19',
790: p_icr_lines_rec.global_attribute19);
791: --
792: dbms_sql.bind_variable(p_update_cursor, ':global_attribute20',
793: p_icr_lines_rec.global_attribute20);
794: --
795: dbms_sql.bind_variable(p_update_cursor, ':ussgl_transaction_code',
796: p_icr_lines_rec.ussgl_transaction_code);

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

791: --
792: dbms_sql.bind_variable(p_update_cursor, ':global_attribute20',
793: p_icr_lines_rec.global_attribute20);
794: --
795: dbms_sql.bind_variable(p_update_cursor, ':ussgl_transaction_code',
796: p_icr_lines_rec.ussgl_transaction_code);
797: --
798: dbms_sql.bind_variable(p_update_cursor, ':ussgl_transaction_code_context',
799: p_icr_lines_rec.ussgl_transaction_code_context);

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

794: --
795: dbms_sql.bind_variable(p_update_cursor, ':ussgl_transaction_code',
796: p_icr_lines_rec.ussgl_transaction_code);
797: --
798: dbms_sql.bind_variable(p_update_cursor, ':ussgl_transaction_code_context',
799: p_icr_lines_rec.ussgl_transaction_code_context);
800: --
801: dbms_sql.bind_variable(p_update_cursor, ':application_ref_type',
802: p_icr_lines_rec.application_ref_type);

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

797: --
798: dbms_sql.bind_variable(p_update_cursor, ':ussgl_transaction_code_context',
799: p_icr_lines_rec.ussgl_transaction_code_context);
800: --
801: dbms_sql.bind_variable(p_update_cursor, ':application_ref_type',
802: p_icr_lines_rec.application_ref_type);
803: --
804: dbms_sql.bind_variable(p_update_cursor, ':customer_reference',
805: p_icr_lines_rec.customer_reference);

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

800: --
801: dbms_sql.bind_variable(p_update_cursor, ':application_ref_type',
802: p_icr_lines_rec.application_ref_type);
803: --
804: dbms_sql.bind_variable(p_update_cursor, ':customer_reference',
805: p_icr_lines_rec.customer_reference);
806: --
807: dbms_sql.bind_variable(p_update_cursor, ':customer_reason',
808: p_icr_lines_rec.customer_reason);

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

803: --
804: dbms_sql.bind_variable(p_update_cursor, ':customer_reference',
805: p_icr_lines_rec.customer_reference);
806: --
807: dbms_sql.bind_variable(p_update_cursor, ':customer_reason',
808: p_icr_lines_rec.customer_reason);
809: --
810: dbms_sql.bind_variable(p_update_cursor, ':applied_rec_app_id',
811: p_icr_lines_rec.applied_rec_app_id);

Line 810: dbms_sql.bind_variable(p_update_cursor, ':applied_rec_app_id',

806: --
807: dbms_sql.bind_variable(p_update_cursor, ':customer_reason',
808: p_icr_lines_rec.customer_reason);
809: --
810: dbms_sql.bind_variable(p_update_cursor, ':applied_rec_app_id',
811: p_icr_lines_rec.applied_rec_app_id);
812: --
813: EXCEPTION
814: WHEN OTHERS THEN

Line 817: to_char(dbms_sql.last_error_position));

813: EXCEPTION
814: WHEN OTHERS THEN
815: arp_standard.debug('EXCEPTION: arp_cr_icr_lines_pkg.bind_icr_lines_variables()');
816: arp_standard.debug('Error at character: ' ||
817: to_char(dbms_sql.last_error_position));
818:
819: RAISE;
820: --
821: END;

Line 852: p_update_cursor := dbms_sql.open_cursor;

848: --
849: if (p_update_cursor is null)
850: then
851: --
852: p_update_cursor := dbms_sql.open_cursor;
853: --
854: /*---------------------------------+
855: | Construct the update statement |
856: +---------------------------------*/

Line 867: dbms_sql.parse(p_update_cursor,

863: /*-----------------------------------------------+
864: | Parse, bind, execute and close the statement |
865: +-----------------------------------------------*/
866: --
867: dbms_sql.parse(p_update_cursor,
868: l_update_statement,
869: dbms_sql.v7);
870: --
871: arp_standard.debug('after dbms_sql');

Line 869: dbms_sql.v7);

865: +-----------------------------------------------*/
866: --
867: dbms_sql.parse(p_update_cursor,
868: l_update_statement,
869: dbms_sql.v7);
870: --
871: arp_standard.debug('after dbms_sql');
872:
873: end if;

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

867: dbms_sql.parse(p_update_cursor,
868: l_update_statement,
869: dbms_sql.v7);
870: --
871: arp_standard.debug('after dbms_sql');
872:
873: end if;
874: --
875: arp_cr_icr_lines_pkg.bind_icr_lines_variables(p_update_cursor, p_icr_lines_rec);

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

881: +-----------------------------------------*/
882: --
883: if ( p_where1 is not null )
884: then
885: dbms_sql.bind_variable(p_update_cursor, ':where_1',
886: p_where1);
887: end if;
888:
889: -- Bug 744228: bind additional where variable.

Line 892: dbms_sql.bind_variable(p_update_cursor, ':where_2',

888:
889: -- Bug 744228: bind additional where variable.
890: if ( p_where2 is not null )
891: then
892: dbms_sql.bind_variable(p_update_cursor, ':where_2',
893: p_where2);
894: end if;
895:
896: -- Bug 746872: bind additional where variable.

Line 899: dbms_sql.bind_variable(p_update_cursor, ':where_3',

895:
896: -- Bug 746872: bind additional where variable.
897: if ( p_where3 is not null )
898: then
899: dbms_sql.bind_variable(p_update_cursor, ':where_3',
900: p_where3);
901: end if;
902:
903: arp_standard.debug('after bind_variable ');

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

901: end if;
902:
903: arp_standard.debug('after bind_variable ');
904: --
905: l_count := dbms_sql.execute(p_update_cursor);
906: --
907: arp_standard.debug( to_char(l_count) || ' rows updated');
908: --
909: --

Line 928: to_char(dbms_sql.last_error_position));

924: arp_standard.debug('EXCEPTION: arp_cr_icr_lines_pkg.generic_update()
925: ');
926: arp_standard.debug(l_update_statement);
927: arp_standard.debug('Error at character: ' ||
928: to_char(dbms_sql.last_error_position));
929: --arp_standard.debug('ERROR MESSAGE: ' ||
930: -- sqlerrm);
931: RAISE;
932: END;