eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ARP_AUTOMATIC_CLEARING_PKG dependencies on DBMS_SQL

Line 456: dbms_sql.bind_variable(c, ':b_cust_number_low' ,p_customer_number_low);

452: --
453: BEGIN
454: --
455: IF ( p_customer_number_low IS NOT NULL ) THEN
456: dbms_sql.bind_variable(c, ':b_cust_number_low' ,p_customer_number_low);
457: END IF;
458: --
459: IF ( p_customer_number_high IS NOT NULL ) THEN
460: dbms_sql.bind_variable(c, ':b_cust_number_high' ,p_customer_number_high);

Line 460: dbms_sql.bind_variable(c, ':b_cust_number_high' ,p_customer_number_high);

456: dbms_sql.bind_variable(c, ':b_cust_number_low' ,p_customer_number_low);
457: END IF;
458: --
459: IF ( p_customer_number_high IS NOT NULL ) THEN
460: dbms_sql.bind_variable(c, ':b_cust_number_high' ,p_customer_number_high);
461: END IF;
462: --
463: IF ( p_customer_name_low IS NOT NULL ) THEN
464: dbms_sql.bind_variable(c, ':b_cust_name_low' ,p_customer_name_low);

Line 464: dbms_sql.bind_variable(c, ':b_cust_name_low' ,p_customer_name_low);

460: dbms_sql.bind_variable(c, ':b_cust_number_high' ,p_customer_number_high);
461: END IF;
462: --
463: IF ( p_customer_name_low IS NOT NULL ) THEN
464: dbms_sql.bind_variable(c, ':b_cust_name_low' ,p_customer_name_low);
465: END IF;
466: --
467: IF ( p_customer_name_high IS NOT NULL ) THEN
468: dbms_sql.bind_variable(c, ':b_cust_name_high' ,p_customer_name_high);

Line 468: dbms_sql.bind_variable(c, ':b_cust_name_high' ,p_customer_name_high);

464: dbms_sql.bind_variable(c, ':b_cust_name_low' ,p_customer_name_low);
465: END IF;
466: --
467: IF ( p_customer_name_high IS NOT NULL ) THEN
468: dbms_sql.bind_variable(c, ':b_cust_name_high' ,p_customer_name_high);
469: END IF;
470: --
471: IF ( p_receipt_number_low IS NOT NULL ) THEN
472: dbms_sql.bind_variable(c, ':b_receipt_number_low' ,p_receipt_number_low);

Line 472: dbms_sql.bind_variable(c, ':b_receipt_number_low' ,p_receipt_number_low);

468: dbms_sql.bind_variable(c, ':b_cust_name_high' ,p_customer_name_high);
469: END IF;
470: --
471: IF ( p_receipt_number_low IS NOT NULL ) THEN
472: dbms_sql.bind_variable(c, ':b_receipt_number_low' ,p_receipt_number_low);
473: END IF;
474: --
475: IF ( p_receipt_number_high IS NOT NULL ) THEN
476: dbms_sql.bind_variable(c, ':b_receipt_number_high' ,p_receipt_number_high);

Line 476: dbms_sql.bind_variable(c, ':b_receipt_number_high' ,p_receipt_number_high);

472: dbms_sql.bind_variable(c, ':b_receipt_number_low' ,p_receipt_number_low);
473: END IF;
474: --
475: IF ( p_receipt_number_high IS NOT NULL ) THEN
476: dbms_sql.bind_variable(c, ':b_receipt_number_high' ,p_receipt_number_high);
477: END IF;
478: --
479: IF ( p_remittance_bank_account_id IS NOT NULL ) THEN
480: dbms_sql.bind_variable(c, ':b_remittance_bank_account_id' ,p_remittance_bank_account_id);

Line 480: dbms_sql.bind_variable(c, ':b_remittance_bank_account_id' ,p_remittance_bank_account_id);

476: dbms_sql.bind_variable(c, ':b_receipt_number_high' ,p_receipt_number_high);
477: END IF;
478: --
479: IF ( p_remittance_bank_account_id IS NOT NULL ) THEN
480: dbms_sql.bind_variable(c, ':b_remittance_bank_account_id' ,p_remittance_bank_account_id);
481: END IF;
482: --
483: IF ( p_payment_method_id IS NOT NULL ) THEN
484: dbms_sql.bind_variable(c, ':b_payment_method' ,p_payment_method_id);

Line 484: dbms_sql.bind_variable(c, ':b_payment_method' ,p_payment_method_id);

480: dbms_sql.bind_variable(c, ':b_remittance_bank_account_id' ,p_remittance_bank_account_id);
481: END IF;
482: --
483: IF ( p_payment_method_id IS NOT NULL ) THEN
484: dbms_sql.bind_variable(c, ':b_payment_method' ,p_payment_method_id);
485: END IF;
486:
487: -- Added for Bug 706935
488: --

Line 490: dbms_sql.bind_variable(c, ':b_batch_id' ,p_batch_id);

486:
487: -- Added for Bug 706935
488: --
489: IF ( p_batch_id IS NOT NULL ) THEN
490: dbms_sql.bind_variable(c, ':b_batch_id' ,p_batch_id);
491: END IF;
492: --
493: EXCEPTION
494: WHEN OTHERS THEN

Line 568: c := dbms_sql.open_cursor;

564: 0,
565: -1 );
566: END IF;
567: --
568: c := dbms_sql.open_cursor;
569: --
570: -- Build expanded select-statement depending on parameters
571: --
572: expand_stmt( p_customer_name_low,

Line 583: dbms_sql.parse(c, statement, dbms_sql.native);

579: p_payment_method_id,
580: p_batch_id,
581: statement );
582: --
583: dbms_sql.parse(c, statement, dbms_sql.native);
584: --
585: -- Bind variables
586: --
587: dbms_sql.bind_variable(c, ':b_clear_date' ,p_clear_date);

Line 587: dbms_sql.bind_variable(c, ':b_clear_date' ,p_clear_date);

583: dbms_sql.parse(c, statement, dbms_sql.native);
584: --
585: -- Bind variables
586: --
587: dbms_sql.bind_variable(c, ':b_clear_date' ,p_clear_date);
588: dbms_sql.bind_variable(c, ':b_gl_date' ,p_gl_date);
589: --
590: IF ( remitted_or_factored_or_risk <> 3) THEN
591: dbms_sql.bind_variable(c, ':b_exchange_rate_type' ,p_exchange_rate_type);

Line 588: dbms_sql.bind_variable(c, ':b_gl_date' ,p_gl_date);

584: --
585: -- Bind variables
586: --
587: dbms_sql.bind_variable(c, ':b_clear_date' ,p_clear_date);
588: dbms_sql.bind_variable(c, ':b_gl_date' ,p_gl_date);
589: --
590: IF ( remitted_or_factored_or_risk <> 3) THEN
591: dbms_sql.bind_variable(c, ':b_exchange_rate_type' ,p_exchange_rate_type);
592: dbms_sql.bind_variable(c, ':b_set_of_bks_id' ,v_set_of_bks_id);

Line 591: dbms_sql.bind_variable(c, ':b_exchange_rate_type' ,p_exchange_rate_type);

587: dbms_sql.bind_variable(c, ':b_clear_date' ,p_clear_date);
588: dbms_sql.bind_variable(c, ':b_gl_date' ,p_gl_date);
589: --
590: IF ( remitted_or_factored_or_risk <> 3) THEN
591: dbms_sql.bind_variable(c, ':b_exchange_rate_type' ,p_exchange_rate_type);
592: dbms_sql.bind_variable(c, ':b_set_of_bks_id' ,v_set_of_bks_id);
593:
594: -- Bug 706935.
595: -- Removed this line.

Line 592: dbms_sql.bind_variable(c, ':b_set_of_bks_id' ,v_set_of_bks_id);

588: dbms_sql.bind_variable(c, ':b_gl_date' ,p_gl_date);
589: --
590: IF ( remitted_or_factored_or_risk <> 3) THEN
591: dbms_sql.bind_variable(c, ':b_exchange_rate_type' ,p_exchange_rate_type);
592: dbms_sql.bind_variable(c, ':b_set_of_bks_id' ,v_set_of_bks_id);
593:
594: -- Bug 706935.
595: -- Removed this line.
596: -- dbms_sql.bind_variable(c, ':b_batch_id' ,p_batch_id);

Line 596: -- dbms_sql.bind_variable(c, ':b_batch_id' ,p_batch_id);

592: dbms_sql.bind_variable(c, ':b_set_of_bks_id' ,v_set_of_bks_id);
593:
594: -- Bug 706935.
595: -- Removed this line.
596: -- dbms_sql.bind_variable(c, ':b_batch_id' ,p_batch_id);
597:
598: END IF;
599: --
600: ar_bind_variables( p_customer_name_low,

Line 612: dbms_sql.define_column(c, 1, v_cr_id);

608: p_batch_id,
609: c );
610: --
611: IF ( remitted_or_factored_or_risk = 3) THEN
612: dbms_sql.define_column(c, 1, v_cr_id);
613: dbms_sql.define_column(c, 2, v_trx_date);
614: dbms_sql.define_column(c, 3, v_gl_date);
615: dbms_sql.define_column(c, 4, v_mod_name, 30);
616: dbms_sql.define_column(c, 5, v_mod_vers, 5);

Line 613: dbms_sql.define_column(c, 2, v_trx_date);

609: c );
610: --
611: IF ( remitted_or_factored_or_risk = 3) THEN
612: dbms_sql.define_column(c, 1, v_cr_id);
613: dbms_sql.define_column(c, 2, v_trx_date);
614: dbms_sql.define_column(c, 3, v_gl_date);
615: dbms_sql.define_column(c, 4, v_mod_name, 30);
616: dbms_sql.define_column(c, 5, v_mod_vers, 5);
617: dbms_sql.define_column(c, 6, v_crh_id);

Line 614: dbms_sql.define_column(c, 3, v_gl_date);

610: --
611: IF ( remitted_or_factored_or_risk = 3) THEN
612: dbms_sql.define_column(c, 1, v_cr_id);
613: dbms_sql.define_column(c, 2, v_trx_date);
614: dbms_sql.define_column(c, 3, v_gl_date);
615: dbms_sql.define_column(c, 4, v_mod_name, 30);
616: dbms_sql.define_column(c, 5, v_mod_vers, 5);
617: dbms_sql.define_column(c, 6, v_crh_id);
618: ELSE

Line 615: dbms_sql.define_column(c, 4, v_mod_name, 30);

611: IF ( remitted_or_factored_or_risk = 3) THEN
612: dbms_sql.define_column(c, 1, v_cr_id);
613: dbms_sql.define_column(c, 2, v_trx_date);
614: dbms_sql.define_column(c, 3, v_gl_date);
615: dbms_sql.define_column(c, 4, v_mod_name, 30);
616: dbms_sql.define_column(c, 5, v_mod_vers, 5);
617: dbms_sql.define_column(c, 6, v_crh_id);
618: ELSE
619: dbms_sql.define_column(c, 1, v_cr_id);

Line 616: dbms_sql.define_column(c, 5, v_mod_vers, 5);

612: dbms_sql.define_column(c, 1, v_cr_id);
613: dbms_sql.define_column(c, 2, v_trx_date);
614: dbms_sql.define_column(c, 3, v_gl_date);
615: dbms_sql.define_column(c, 4, v_mod_name, 30);
616: dbms_sql.define_column(c, 5, v_mod_vers, 5);
617: dbms_sql.define_column(c, 6, v_crh_id);
618: ELSE
619: dbms_sql.define_column(c, 1, v_cr_id);
620: dbms_sql.define_column(c, 2, v_trx_date);

Line 617: dbms_sql.define_column(c, 6, v_crh_id);

613: dbms_sql.define_column(c, 2, v_trx_date);
614: dbms_sql.define_column(c, 3, v_gl_date);
615: dbms_sql.define_column(c, 4, v_mod_name, 30);
616: dbms_sql.define_column(c, 5, v_mod_vers, 5);
617: dbms_sql.define_column(c, 6, v_crh_id);
618: ELSE
619: dbms_sql.define_column(c, 1, v_cr_id);
620: dbms_sql.define_column(c, 2, v_trx_date);
621: dbms_sql.define_column(c, 3, v_gl_date);

Line 619: dbms_sql.define_column(c, 1, v_cr_id);

615: dbms_sql.define_column(c, 4, v_mod_name, 30);
616: dbms_sql.define_column(c, 5, v_mod_vers, 5);
617: dbms_sql.define_column(c, 6, v_crh_id);
618: ELSE
619: dbms_sql.define_column(c, 1, v_cr_id);
620: dbms_sql.define_column(c, 2, v_trx_date);
621: dbms_sql.define_column(c, 3, v_gl_date);
622: dbms_sql.define_column(c, 4, v_ex_date);
623: dbms_sql.define_column(c, 5, v_ex_rate_type, 30);

Line 620: dbms_sql.define_column(c, 2, v_trx_date);

616: dbms_sql.define_column(c, 5, v_mod_vers, 5);
617: dbms_sql.define_column(c, 6, v_crh_id);
618: ELSE
619: dbms_sql.define_column(c, 1, v_cr_id);
620: dbms_sql.define_column(c, 2, v_trx_date);
621: dbms_sql.define_column(c, 3, v_gl_date);
622: dbms_sql.define_column(c, 4, v_ex_date);
623: dbms_sql.define_column(c, 5, v_ex_rate_type, 30);
624: dbms_sql.define_column(c, 6, v_ex_rate);

Line 621: dbms_sql.define_column(c, 3, v_gl_date);

617: dbms_sql.define_column(c, 6, v_crh_id);
618: ELSE
619: dbms_sql.define_column(c, 1, v_cr_id);
620: dbms_sql.define_column(c, 2, v_trx_date);
621: dbms_sql.define_column(c, 3, v_gl_date);
622: dbms_sql.define_column(c, 4, v_ex_date);
623: dbms_sql.define_column(c, 5, v_ex_rate_type, 30);
624: dbms_sql.define_column(c, 6, v_ex_rate);
625: dbms_sql.define_column(c, 7, v_currency, 15);

Line 622: dbms_sql.define_column(c, 4, v_ex_date);

618: ELSE
619: dbms_sql.define_column(c, 1, v_cr_id);
620: dbms_sql.define_column(c, 2, v_trx_date);
621: dbms_sql.define_column(c, 3, v_gl_date);
622: dbms_sql.define_column(c, 4, v_ex_date);
623: dbms_sql.define_column(c, 5, v_ex_rate_type, 30);
624: dbms_sql.define_column(c, 6, v_ex_rate);
625: dbms_sql.define_column(c, 7, v_currency, 15);
626: dbms_sql.define_column(c, 8, v_amount);

Line 623: dbms_sql.define_column(c, 5, v_ex_rate_type, 30);

619: dbms_sql.define_column(c, 1, v_cr_id);
620: dbms_sql.define_column(c, 2, v_trx_date);
621: dbms_sql.define_column(c, 3, v_gl_date);
622: dbms_sql.define_column(c, 4, v_ex_date);
623: dbms_sql.define_column(c, 5, v_ex_rate_type, 30);
624: dbms_sql.define_column(c, 6, v_ex_rate);
625: dbms_sql.define_column(c, 7, v_currency, 15);
626: dbms_sql.define_column(c, 8, v_amount);
627: dbms_sql.define_column(c, 9, v_fac_disc_amount);

Line 624: dbms_sql.define_column(c, 6, v_ex_rate);

620: dbms_sql.define_column(c, 2, v_trx_date);
621: dbms_sql.define_column(c, 3, v_gl_date);
622: dbms_sql.define_column(c, 4, v_ex_date);
623: dbms_sql.define_column(c, 5, v_ex_rate_type, 30);
624: dbms_sql.define_column(c, 6, v_ex_rate);
625: dbms_sql.define_column(c, 7, v_currency, 15);
626: dbms_sql.define_column(c, 8, v_amount);
627: dbms_sql.define_column(c, 9, v_fac_disc_amount);
628: dbms_sql.define_column(c, 10, v_mod_name, 30);

Line 625: dbms_sql.define_column(c, 7, v_currency, 15);

621: dbms_sql.define_column(c, 3, v_gl_date);
622: dbms_sql.define_column(c, 4, v_ex_date);
623: dbms_sql.define_column(c, 5, v_ex_rate_type, 30);
624: dbms_sql.define_column(c, 6, v_ex_rate);
625: dbms_sql.define_column(c, 7, v_currency, 15);
626: dbms_sql.define_column(c, 8, v_amount);
627: dbms_sql.define_column(c, 9, v_fac_disc_amount);
628: dbms_sql.define_column(c, 10, v_mod_name, 30);
629: dbms_sql.define_column(c, 11, v_mod_vers, 5);

Line 626: dbms_sql.define_column(c, 8, v_amount);

622: dbms_sql.define_column(c, 4, v_ex_date);
623: dbms_sql.define_column(c, 5, v_ex_rate_type, 30);
624: dbms_sql.define_column(c, 6, v_ex_rate);
625: dbms_sql.define_column(c, 7, v_currency, 15);
626: dbms_sql.define_column(c, 8, v_amount);
627: dbms_sql.define_column(c, 9, v_fac_disc_amount);
628: dbms_sql.define_column(c, 10, v_mod_name, 30);
629: dbms_sql.define_column(c, 11, v_mod_vers, 5);
630: dbms_sql.define_column(c, 12, v_crh_id);

Line 627: dbms_sql.define_column(c, 9, v_fac_disc_amount);

623: dbms_sql.define_column(c, 5, v_ex_rate_type, 30);
624: dbms_sql.define_column(c, 6, v_ex_rate);
625: dbms_sql.define_column(c, 7, v_currency, 15);
626: dbms_sql.define_column(c, 8, v_amount);
627: dbms_sql.define_column(c, 9, v_fac_disc_amount);
628: dbms_sql.define_column(c, 10, v_mod_name, 30);
629: dbms_sql.define_column(c, 11, v_mod_vers, 5);
630: dbms_sql.define_column(c, 12, v_crh_id);
631: dbms_sql.define_column(c, 13, v_crh_amount);

Line 628: dbms_sql.define_column(c, 10, v_mod_name, 30);

624: dbms_sql.define_column(c, 6, v_ex_rate);
625: dbms_sql.define_column(c, 7, v_currency, 15);
626: dbms_sql.define_column(c, 8, v_amount);
627: dbms_sql.define_column(c, 9, v_fac_disc_amount);
628: dbms_sql.define_column(c, 10, v_mod_name, 30);
629: dbms_sql.define_column(c, 11, v_mod_vers, 5);
630: dbms_sql.define_column(c, 12, v_crh_id);
631: dbms_sql.define_column(c, 13, v_crh_amount);
632: dbms_sql.define_column(c, 14, v_crh_fac_disc_amt);

Line 629: dbms_sql.define_column(c, 11, v_mod_vers, 5);

625: dbms_sql.define_column(c, 7, v_currency, 15);
626: dbms_sql.define_column(c, 8, v_amount);
627: dbms_sql.define_column(c, 9, v_fac_disc_amount);
628: dbms_sql.define_column(c, 10, v_mod_name, 30);
629: dbms_sql.define_column(c, 11, v_mod_vers, 5);
630: dbms_sql.define_column(c, 12, v_crh_id);
631: dbms_sql.define_column(c, 13, v_crh_amount);
632: dbms_sql.define_column(c, 14, v_crh_fac_disc_amt);
633: dbms_sql.define_column(c, 15, v_cr_currency, 15);

Line 630: dbms_sql.define_column(c, 12, v_crh_id);

626: dbms_sql.define_column(c, 8, v_amount);
627: dbms_sql.define_column(c, 9, v_fac_disc_amount);
628: dbms_sql.define_column(c, 10, v_mod_name, 30);
629: dbms_sql.define_column(c, 11, v_mod_vers, 5);
630: dbms_sql.define_column(c, 12, v_crh_id);
631: dbms_sql.define_column(c, 13, v_crh_amount);
632: dbms_sql.define_column(c, 14, v_crh_fac_disc_amt);
633: dbms_sql.define_column(c, 15, v_cr_currency, 15);
634: dbms_sql.define_column(c, 16, v_ex_rate_old);

Line 631: dbms_sql.define_column(c, 13, v_crh_amount);

627: dbms_sql.define_column(c, 9, v_fac_disc_amount);
628: dbms_sql.define_column(c, 10, v_mod_name, 30);
629: dbms_sql.define_column(c, 11, v_mod_vers, 5);
630: dbms_sql.define_column(c, 12, v_crh_id);
631: dbms_sql.define_column(c, 13, v_crh_amount);
632: dbms_sql.define_column(c, 14, v_crh_fac_disc_amt);
633: dbms_sql.define_column(c, 15, v_cr_currency, 15);
634: dbms_sql.define_column(c, 16, v_ex_rate_old);
635: END IF;

Line 632: dbms_sql.define_column(c, 14, v_crh_fac_disc_amt);

628: dbms_sql.define_column(c, 10, v_mod_name, 30);
629: dbms_sql.define_column(c, 11, v_mod_vers, 5);
630: dbms_sql.define_column(c, 12, v_crh_id);
631: dbms_sql.define_column(c, 13, v_crh_amount);
632: dbms_sql.define_column(c, 14, v_crh_fac_disc_amt);
633: dbms_sql.define_column(c, 15, v_cr_currency, 15);
634: dbms_sql.define_column(c, 16, v_ex_rate_old);
635: END IF;
636: --

Line 633: dbms_sql.define_column(c, 15, v_cr_currency, 15);

629: dbms_sql.define_column(c, 11, v_mod_vers, 5);
630: dbms_sql.define_column(c, 12, v_crh_id);
631: dbms_sql.define_column(c, 13, v_crh_amount);
632: dbms_sql.define_column(c, 14, v_crh_fac_disc_amt);
633: dbms_sql.define_column(c, 15, v_cr_currency, 15);
634: dbms_sql.define_column(c, 16, v_ex_rate_old);
635: END IF;
636: --
637: ignore := dbms_sql.execute(c);

Line 634: dbms_sql.define_column(c, 16, v_ex_rate_old);

630: dbms_sql.define_column(c, 12, v_crh_id);
631: dbms_sql.define_column(c, 13, v_crh_amount);
632: dbms_sql.define_column(c, 14, v_crh_fac_disc_amt);
633: dbms_sql.define_column(c, 15, v_cr_currency, 15);
634: dbms_sql.define_column(c, 16, v_ex_rate_old);
635: END IF;
636: --
637: ignore := dbms_sql.execute(c);
638: --

Line 637: ignore := dbms_sql.execute(c);

633: dbms_sql.define_column(c, 15, v_cr_currency, 15);
634: dbms_sql.define_column(c, 16, v_ex_rate_old);
635: END IF;
636: --
637: ignore := dbms_sql.execute(c);
638: --
639: IF ( remitted_or_factored_or_risk = 3) THEN
640: LOOP
641: IF dbms_sql.fetch_rows(c) > 0 THEN

Line 641: IF dbms_sql.fetch_rows(c) > 0 THEN

637: ignore := dbms_sql.execute(c);
638: --
639: IF ( remitted_or_factored_or_risk = 3) THEN
640: LOOP
641: IF dbms_sql.fetch_rows(c) > 0 THEN
642: dbms_sql.column_value(c, 1, v_cr_id);
643: dbms_sql.column_value(c, 2, v_trx_date);
644: dbms_sql.column_value(c, 3, v_gl_date);
645: dbms_sql.column_value(c, 4, v_mod_name);

Line 642: dbms_sql.column_value(c, 1, v_cr_id);

638: --
639: IF ( remitted_or_factored_or_risk = 3) THEN
640: LOOP
641: IF dbms_sql.fetch_rows(c) > 0 THEN
642: dbms_sql.column_value(c, 1, v_cr_id);
643: dbms_sql.column_value(c, 2, v_trx_date);
644: dbms_sql.column_value(c, 3, v_gl_date);
645: dbms_sql.column_value(c, 4, v_mod_name);
646: dbms_sql.column_value(c, 5, v_mod_vers);

Line 643: dbms_sql.column_value(c, 2, v_trx_date);

639: IF ( remitted_or_factored_or_risk = 3) THEN
640: LOOP
641: IF dbms_sql.fetch_rows(c) > 0 THEN
642: dbms_sql.column_value(c, 1, v_cr_id);
643: dbms_sql.column_value(c, 2, v_trx_date);
644: dbms_sql.column_value(c, 3, v_gl_date);
645: dbms_sql.column_value(c, 4, v_mod_name);
646: dbms_sql.column_value(c, 5, v_mod_vers);
647: dbms_sql.column_value(c, 6, v_crh_id);

Line 644: dbms_sql.column_value(c, 3, v_gl_date);

640: LOOP
641: IF dbms_sql.fetch_rows(c) > 0 THEN
642: dbms_sql.column_value(c, 1, v_cr_id);
643: dbms_sql.column_value(c, 2, v_trx_date);
644: dbms_sql.column_value(c, 3, v_gl_date);
645: dbms_sql.column_value(c, 4, v_mod_name);
646: dbms_sql.column_value(c, 5, v_mod_vers);
647: dbms_sql.column_value(c, 6, v_crh_id);
648: --

Line 645: dbms_sql.column_value(c, 4, v_mod_name);

641: IF dbms_sql.fetch_rows(c) > 0 THEN
642: dbms_sql.column_value(c, 1, v_cr_id);
643: dbms_sql.column_value(c, 2, v_trx_date);
644: dbms_sql.column_value(c, 3, v_gl_date);
645: dbms_sql.column_value(c, 4, v_mod_name);
646: dbms_sql.column_value(c, 5, v_mod_vers);
647: dbms_sql.column_value(c, 6, v_crh_id);
648: --
649: -- Lock rows

Line 646: dbms_sql.column_value(c, 5, v_mod_vers);

642: dbms_sql.column_value(c, 1, v_cr_id);
643: dbms_sql.column_value(c, 2, v_trx_date);
644: dbms_sql.column_value(c, 3, v_gl_date);
645: dbms_sql.column_value(c, 4, v_mod_name);
646: dbms_sql.column_value(c, 5, v_mod_vers);
647: dbms_sql.column_value(c, 6, v_crh_id);
648: --
649: -- Lock rows
650: --

Line 647: dbms_sql.column_value(c, 6, v_crh_id);

643: dbms_sql.column_value(c, 2, v_trx_date);
644: dbms_sql.column_value(c, 3, v_gl_date);
645: dbms_sql.column_value(c, 4, v_mod_name);
646: dbms_sql.column_value(c, 5, v_mod_vers);
647: dbms_sql.column_value(c, 6, v_crh_id);
648: --
649: -- Lock rows
650: --
651: BEGIN

Line 693: IF dbms_sql.fetch_rows(c) > 0 THEN

689: ARP_CASHBOOK.g_unq_cust_site_cur_org_cmb.delete;
690:
691: ELSE
692: LOOP
693: IF dbms_sql.fetch_rows(c) > 0 THEN
694: dbms_sql.column_value(c, 1, v_cr_id);
695: dbms_sql.column_value(c, 2, v_trx_date);
696: dbms_sql.column_value(c, 3, v_gl_date);
697: dbms_sql.column_value(c, 4, v_ex_date);

Line 694: dbms_sql.column_value(c, 1, v_cr_id);

690:
691: ELSE
692: LOOP
693: IF dbms_sql.fetch_rows(c) > 0 THEN
694: dbms_sql.column_value(c, 1, v_cr_id);
695: dbms_sql.column_value(c, 2, v_trx_date);
696: dbms_sql.column_value(c, 3, v_gl_date);
697: dbms_sql.column_value(c, 4, v_ex_date);
698: dbms_sql.column_value(c, 5, v_ex_rate_type);

Line 695: dbms_sql.column_value(c, 2, v_trx_date);

691: ELSE
692: LOOP
693: IF dbms_sql.fetch_rows(c) > 0 THEN
694: dbms_sql.column_value(c, 1, v_cr_id);
695: dbms_sql.column_value(c, 2, v_trx_date);
696: dbms_sql.column_value(c, 3, v_gl_date);
697: dbms_sql.column_value(c, 4, v_ex_date);
698: dbms_sql.column_value(c, 5, v_ex_rate_type);
699: dbms_sql.column_value(c, 6, v_ex_rate);

Line 696: dbms_sql.column_value(c, 3, v_gl_date);

692: LOOP
693: IF dbms_sql.fetch_rows(c) > 0 THEN
694: dbms_sql.column_value(c, 1, v_cr_id);
695: dbms_sql.column_value(c, 2, v_trx_date);
696: dbms_sql.column_value(c, 3, v_gl_date);
697: dbms_sql.column_value(c, 4, v_ex_date);
698: dbms_sql.column_value(c, 5, v_ex_rate_type);
699: dbms_sql.column_value(c, 6, v_ex_rate);
700: dbms_sql.column_value(c, 7, v_currency);

Line 697: dbms_sql.column_value(c, 4, v_ex_date);

693: IF dbms_sql.fetch_rows(c) > 0 THEN
694: dbms_sql.column_value(c, 1, v_cr_id);
695: dbms_sql.column_value(c, 2, v_trx_date);
696: dbms_sql.column_value(c, 3, v_gl_date);
697: dbms_sql.column_value(c, 4, v_ex_date);
698: dbms_sql.column_value(c, 5, v_ex_rate_type);
699: dbms_sql.column_value(c, 6, v_ex_rate);
700: dbms_sql.column_value(c, 7, v_currency);
701: dbms_sql.column_value(c, 8, v_amount);

Line 698: dbms_sql.column_value(c, 5, v_ex_rate_type);

694: dbms_sql.column_value(c, 1, v_cr_id);
695: dbms_sql.column_value(c, 2, v_trx_date);
696: dbms_sql.column_value(c, 3, v_gl_date);
697: dbms_sql.column_value(c, 4, v_ex_date);
698: dbms_sql.column_value(c, 5, v_ex_rate_type);
699: dbms_sql.column_value(c, 6, v_ex_rate);
700: dbms_sql.column_value(c, 7, v_currency);
701: dbms_sql.column_value(c, 8, v_amount);
702: dbms_sql.column_value(c, 9, v_fac_disc_amount);

Line 699: dbms_sql.column_value(c, 6, v_ex_rate);

695: dbms_sql.column_value(c, 2, v_trx_date);
696: dbms_sql.column_value(c, 3, v_gl_date);
697: dbms_sql.column_value(c, 4, v_ex_date);
698: dbms_sql.column_value(c, 5, v_ex_rate_type);
699: dbms_sql.column_value(c, 6, v_ex_rate);
700: dbms_sql.column_value(c, 7, v_currency);
701: dbms_sql.column_value(c, 8, v_amount);
702: dbms_sql.column_value(c, 9, v_fac_disc_amount);
703: dbms_sql.column_value(c, 10, v_mod_name);

Line 700: dbms_sql.column_value(c, 7, v_currency);

696: dbms_sql.column_value(c, 3, v_gl_date);
697: dbms_sql.column_value(c, 4, v_ex_date);
698: dbms_sql.column_value(c, 5, v_ex_rate_type);
699: dbms_sql.column_value(c, 6, v_ex_rate);
700: dbms_sql.column_value(c, 7, v_currency);
701: dbms_sql.column_value(c, 8, v_amount);
702: dbms_sql.column_value(c, 9, v_fac_disc_amount);
703: dbms_sql.column_value(c, 10, v_mod_name);
704: dbms_sql.column_value(c, 11, v_mod_vers);

Line 701: dbms_sql.column_value(c, 8, v_amount);

697: dbms_sql.column_value(c, 4, v_ex_date);
698: dbms_sql.column_value(c, 5, v_ex_rate_type);
699: dbms_sql.column_value(c, 6, v_ex_rate);
700: dbms_sql.column_value(c, 7, v_currency);
701: dbms_sql.column_value(c, 8, v_amount);
702: dbms_sql.column_value(c, 9, v_fac_disc_amount);
703: dbms_sql.column_value(c, 10, v_mod_name);
704: dbms_sql.column_value(c, 11, v_mod_vers);
705: dbms_sql.column_value(c, 12, v_crh_id);

Line 702: dbms_sql.column_value(c, 9, v_fac_disc_amount);

698: dbms_sql.column_value(c, 5, v_ex_rate_type);
699: dbms_sql.column_value(c, 6, v_ex_rate);
700: dbms_sql.column_value(c, 7, v_currency);
701: dbms_sql.column_value(c, 8, v_amount);
702: dbms_sql.column_value(c, 9, v_fac_disc_amount);
703: dbms_sql.column_value(c, 10, v_mod_name);
704: dbms_sql.column_value(c, 11, v_mod_vers);
705: dbms_sql.column_value(c, 12, v_crh_id);
706: dbms_sql.column_value(c, 13, v_crh_amount);

Line 703: dbms_sql.column_value(c, 10, v_mod_name);

699: dbms_sql.column_value(c, 6, v_ex_rate);
700: dbms_sql.column_value(c, 7, v_currency);
701: dbms_sql.column_value(c, 8, v_amount);
702: dbms_sql.column_value(c, 9, v_fac_disc_amount);
703: dbms_sql.column_value(c, 10, v_mod_name);
704: dbms_sql.column_value(c, 11, v_mod_vers);
705: dbms_sql.column_value(c, 12, v_crh_id);
706: dbms_sql.column_value(c, 13, v_crh_amount);
707: dbms_sql.column_value(c, 14, v_crh_fac_disc_amt);

Line 704: dbms_sql.column_value(c, 11, v_mod_vers);

700: dbms_sql.column_value(c, 7, v_currency);
701: dbms_sql.column_value(c, 8, v_amount);
702: dbms_sql.column_value(c, 9, v_fac_disc_amount);
703: dbms_sql.column_value(c, 10, v_mod_name);
704: dbms_sql.column_value(c, 11, v_mod_vers);
705: dbms_sql.column_value(c, 12, v_crh_id);
706: dbms_sql.column_value(c, 13, v_crh_amount);
707: dbms_sql.column_value(c, 14, v_crh_fac_disc_amt);
708: dbms_sql.column_value(c, 15, v_cr_currency);

Line 705: dbms_sql.column_value(c, 12, v_crh_id);

701: dbms_sql.column_value(c, 8, v_amount);
702: dbms_sql.column_value(c, 9, v_fac_disc_amount);
703: dbms_sql.column_value(c, 10, v_mod_name);
704: dbms_sql.column_value(c, 11, v_mod_vers);
705: dbms_sql.column_value(c, 12, v_crh_id);
706: dbms_sql.column_value(c, 13, v_crh_amount);
707: dbms_sql.column_value(c, 14, v_crh_fac_disc_amt);
708: dbms_sql.column_value(c, 15, v_cr_currency);
709: dbms_sql.column_value(c, 16, v_ex_rate_old);

Line 706: dbms_sql.column_value(c, 13, v_crh_amount);

702: dbms_sql.column_value(c, 9, v_fac_disc_amount);
703: dbms_sql.column_value(c, 10, v_mod_name);
704: dbms_sql.column_value(c, 11, v_mod_vers);
705: dbms_sql.column_value(c, 12, v_crh_id);
706: dbms_sql.column_value(c, 13, v_crh_amount);
707: dbms_sql.column_value(c, 14, v_crh_fac_disc_amt);
708: dbms_sql.column_value(c, 15, v_cr_currency);
709: dbms_sql.column_value(c, 16, v_ex_rate_old);
710: --

Line 707: dbms_sql.column_value(c, 14, v_crh_fac_disc_amt);

703: dbms_sql.column_value(c, 10, v_mod_name);
704: dbms_sql.column_value(c, 11, v_mod_vers);
705: dbms_sql.column_value(c, 12, v_crh_id);
706: dbms_sql.column_value(c, 13, v_crh_amount);
707: dbms_sql.column_value(c, 14, v_crh_fac_disc_amt);
708: dbms_sql.column_value(c, 15, v_cr_currency);
709: dbms_sql.column_value(c, 16, v_ex_rate_old);
710: --
711: -- Lock rows

Line 708: dbms_sql.column_value(c, 15, v_cr_currency);

704: dbms_sql.column_value(c, 11, v_mod_vers);
705: dbms_sql.column_value(c, 12, v_crh_id);
706: dbms_sql.column_value(c, 13, v_crh_amount);
707: dbms_sql.column_value(c, 14, v_crh_fac_disc_amt);
708: dbms_sql.column_value(c, 15, v_cr_currency);
709: dbms_sql.column_value(c, 16, v_ex_rate_old);
710: --
711: -- Lock rows
712: --

Line 709: dbms_sql.column_value(c, 16, v_ex_rate_old);

705: dbms_sql.column_value(c, 12, v_crh_id);
706: dbms_sql.column_value(c, 13, v_crh_amount);
707: dbms_sql.column_value(c, 14, v_crh_fac_disc_amt);
708: dbms_sql.column_value(c, 15, v_cr_currency);
709: dbms_sql.column_value(c, 16, v_ex_rate_old);
710: --
711: -- Lock rows
712: --
713: BEGIN

Line 827: dbms_sql.close_cursor(c);

823: ARP_CASHBOOK.g_unq_cust_site_cur_org_cmb.delete;
824:
825: END IF;
826: --
827: dbms_sql.close_cursor(c);
828: --
829: EXCEPTION
830: WHEN OTHERS THEN
831: arp_standard.debug('Exception: ar_automatic_clearing_pkg ');

Line 1347: c := dbms_sql.open_cursor;

1343: p_total_workers,
1344: p_request_id );
1345: END IF;
1346: --
1347: c := dbms_sql.open_cursor;
1348: --
1349: -- Build expanded select-statement depending on parameters
1350: --
1351: expand_stmt( p_customer_name_low,

Line 1362: dbms_sql.parse(c, statement, dbms_sql.native);

1358: p_payment_method_id,
1359: p_batch_id,
1360: statement );
1361: --
1362: dbms_sql.parse(c, statement, dbms_sql.native);
1363: --
1364: IF PG_DEBUG in ('Y', 'C') THEN
1365: arp_standard.debug('Inside populate_interim_table()');
1366: arp_standard.debug( 'Statement ' || statement);

Line 1370: dbms_sql.bind_variable(c, ':b_clear_date' ,p_clear_date);

1366: arp_standard.debug( 'Statement ' || statement);
1367: END IF;
1368: -- Bind variables
1369: --
1370: dbms_sql.bind_variable(c, ':b_clear_date' ,p_clear_date);
1371: dbms_sql.bind_variable(c, ':b_gl_date' ,p_gl_date);
1372: --
1373: IF ( remitted_or_factored_or_risk <> 3) THEN
1374: dbms_sql.bind_variable(c, ':b_exchange_rate_type' ,p_exchange_rate_type);

Line 1371: dbms_sql.bind_variable(c, ':b_gl_date' ,p_gl_date);

1367: END IF;
1368: -- Bind variables
1369: --
1370: dbms_sql.bind_variable(c, ':b_clear_date' ,p_clear_date);
1371: dbms_sql.bind_variable(c, ':b_gl_date' ,p_gl_date);
1372: --
1373: IF ( remitted_or_factored_or_risk <> 3) THEN
1374: dbms_sql.bind_variable(c, ':b_exchange_rate_type' ,p_exchange_rate_type);
1375: dbms_sql.bind_variable(c, ':b_set_of_bks_id' ,v_set_of_bks_id);

Line 1374: dbms_sql.bind_variable(c, ':b_exchange_rate_type' ,p_exchange_rate_type);

1370: dbms_sql.bind_variable(c, ':b_clear_date' ,p_clear_date);
1371: dbms_sql.bind_variable(c, ':b_gl_date' ,p_gl_date);
1372: --
1373: IF ( remitted_or_factored_or_risk <> 3) THEN
1374: dbms_sql.bind_variable(c, ':b_exchange_rate_type' ,p_exchange_rate_type);
1375: dbms_sql.bind_variable(c, ':b_set_of_bks_id' ,v_set_of_bks_id);
1376:
1377: -- Bug 706935.
1378: -- Removed this line.

Line 1375: dbms_sql.bind_variable(c, ':b_set_of_bks_id' ,v_set_of_bks_id);

1371: dbms_sql.bind_variable(c, ':b_gl_date' ,p_gl_date);
1372: --
1373: IF ( remitted_or_factored_or_risk <> 3) THEN
1374: dbms_sql.bind_variable(c, ':b_exchange_rate_type' ,p_exchange_rate_type);
1375: dbms_sql.bind_variable(c, ':b_set_of_bks_id' ,v_set_of_bks_id);
1376:
1377: -- Bug 706935.
1378: -- Removed this line.
1379: -- dbms_sql.bind_variable(c, ':b_batch_id' ,p_batch_id);

Line 1379: -- dbms_sql.bind_variable(c, ':b_batch_id' ,p_batch_id);

1375: dbms_sql.bind_variable(c, ':b_set_of_bks_id' ,v_set_of_bks_id);
1376:
1377: -- Bug 706935.
1378: -- Removed this line.
1379: -- dbms_sql.bind_variable(c, ':b_batch_id' ,p_batch_id);
1380:
1381: END IF;
1382: --
1383: ar_bind_variables( p_customer_name_low,

Line 1394: ignore := dbms_sql.execute(c);

1390: p_payment_method_id,
1391: p_batch_id,
1392: c );
1393: --
1394: ignore := dbms_sql.execute(c);
1395: IF PG_DEBUG IN ('Y','C') THEN
1396: fnd_file.put_line(fnd_file.LOG, 'No of Records Selected : '|| ignore);
1397: END IF;
1398: --

Line 1401: dbms_sql.close_cursor(c);

1397: END IF;
1398: --
1399: commit; -- Commit the values inserted into the interim table.
1400: --
1401: dbms_sql.close_cursor(c);
1402: fnd_file.put_line( FND_FILE.LOG, 'populate_interim_table()-');
1403: --
1404: EXCEPTION
1405: WHEN OTHERS THEN

Line 1551: dbms_sql.bind_variable(c, ':b_worker_number' ,p_worker_number);

1547: --
1548: BEGIN
1549: --
1550: IF ( p_worker_number IS NOT NULL ) THEN
1551: dbms_sql.bind_variable(c, ':b_worker_number' ,p_worker_number);
1552: END IF;
1553: --
1554: IF ( p_request_id IS NOT NULL ) THEN
1555: dbms_sql.bind_variable(c, ':b_request_id' ,p_request_id);

Line 1555: dbms_sql.bind_variable(c, ':b_request_id' ,p_request_id);

1551: dbms_sql.bind_variable(c, ':b_worker_number' ,p_worker_number);
1552: END IF;
1553: --
1554: IF ( p_request_id IS NOT NULL ) THEN
1555: dbms_sql.bind_variable(c, ':b_request_id' ,p_request_id);
1556: END IF;
1557: --
1558: EXCEPTION
1559: WHEN OTHERS THEN

Line 1618: c := dbms_sql.open_cursor;

1614: main_select_risk_parallel(
1615: statement );
1616: END IF;
1617: --
1618: c := dbms_sql.open_cursor;
1619: --
1620: dbms_sql.parse(c, statement, dbms_sql.native);
1621: --
1622: -- Bind variables

Line 1620: dbms_sql.parse(c, statement, dbms_sql.native);

1616: END IF;
1617: --
1618: c := dbms_sql.open_cursor;
1619: --
1620: dbms_sql.parse(c, statement, dbms_sql.native);
1621: --
1622: -- Bind variables
1623: --
1624: fnd_file.put_line(fnd_file.log, 'Worker No ' ||p_worker_number);

Line 1632: dbms_sql.define_column(c, 1, v_cr_id);

1628: p_request_id,
1629: c );
1630: --
1631: IF ( remitted_or_factored_or_risk = 3) THEN
1632: dbms_sql.define_column(c, 1, v_cr_id);
1633: dbms_sql.define_column(c, 2, v_trx_date);
1634: dbms_sql.define_column(c, 3, v_gl_date);
1635: dbms_sql.define_column(c, 4, v_mod_name, 30);
1636: dbms_sql.define_column(c, 5, v_mod_vers, 5);

Line 1633: dbms_sql.define_column(c, 2, v_trx_date);

1629: c );
1630: --
1631: IF ( remitted_or_factored_or_risk = 3) THEN
1632: dbms_sql.define_column(c, 1, v_cr_id);
1633: dbms_sql.define_column(c, 2, v_trx_date);
1634: dbms_sql.define_column(c, 3, v_gl_date);
1635: dbms_sql.define_column(c, 4, v_mod_name, 30);
1636: dbms_sql.define_column(c, 5, v_mod_vers, 5);
1637: dbms_sql.define_column(c, 6, v_crh_id);

Line 1634: dbms_sql.define_column(c, 3, v_gl_date);

1630: --
1631: IF ( remitted_or_factored_or_risk = 3) THEN
1632: dbms_sql.define_column(c, 1, v_cr_id);
1633: dbms_sql.define_column(c, 2, v_trx_date);
1634: dbms_sql.define_column(c, 3, v_gl_date);
1635: dbms_sql.define_column(c, 4, v_mod_name, 30);
1636: dbms_sql.define_column(c, 5, v_mod_vers, 5);
1637: dbms_sql.define_column(c, 6, v_crh_id);
1638: ELSE

Line 1635: dbms_sql.define_column(c, 4, v_mod_name, 30);

1631: IF ( remitted_or_factored_or_risk = 3) THEN
1632: dbms_sql.define_column(c, 1, v_cr_id);
1633: dbms_sql.define_column(c, 2, v_trx_date);
1634: dbms_sql.define_column(c, 3, v_gl_date);
1635: dbms_sql.define_column(c, 4, v_mod_name, 30);
1636: dbms_sql.define_column(c, 5, v_mod_vers, 5);
1637: dbms_sql.define_column(c, 6, v_crh_id);
1638: ELSE
1639: dbms_sql.define_column(c, 1, v_cr_id);

Line 1636: dbms_sql.define_column(c, 5, v_mod_vers, 5);

1632: dbms_sql.define_column(c, 1, v_cr_id);
1633: dbms_sql.define_column(c, 2, v_trx_date);
1634: dbms_sql.define_column(c, 3, v_gl_date);
1635: dbms_sql.define_column(c, 4, v_mod_name, 30);
1636: dbms_sql.define_column(c, 5, v_mod_vers, 5);
1637: dbms_sql.define_column(c, 6, v_crh_id);
1638: ELSE
1639: dbms_sql.define_column(c, 1, v_cr_id);
1640: dbms_sql.define_column(c, 2, v_trx_date);

Line 1637: dbms_sql.define_column(c, 6, v_crh_id);

1633: dbms_sql.define_column(c, 2, v_trx_date);
1634: dbms_sql.define_column(c, 3, v_gl_date);
1635: dbms_sql.define_column(c, 4, v_mod_name, 30);
1636: dbms_sql.define_column(c, 5, v_mod_vers, 5);
1637: dbms_sql.define_column(c, 6, v_crh_id);
1638: ELSE
1639: dbms_sql.define_column(c, 1, v_cr_id);
1640: dbms_sql.define_column(c, 2, v_trx_date);
1641: dbms_sql.define_column(c, 3, v_gl_date);

Line 1639: dbms_sql.define_column(c, 1, v_cr_id);

1635: dbms_sql.define_column(c, 4, v_mod_name, 30);
1636: dbms_sql.define_column(c, 5, v_mod_vers, 5);
1637: dbms_sql.define_column(c, 6, v_crh_id);
1638: ELSE
1639: dbms_sql.define_column(c, 1, v_cr_id);
1640: dbms_sql.define_column(c, 2, v_trx_date);
1641: dbms_sql.define_column(c, 3, v_gl_date);
1642: dbms_sql.define_column(c, 4, v_ex_date);
1643: dbms_sql.define_column(c, 5, v_ex_rate_type, 30);

Line 1640: dbms_sql.define_column(c, 2, v_trx_date);

1636: dbms_sql.define_column(c, 5, v_mod_vers, 5);
1637: dbms_sql.define_column(c, 6, v_crh_id);
1638: ELSE
1639: dbms_sql.define_column(c, 1, v_cr_id);
1640: dbms_sql.define_column(c, 2, v_trx_date);
1641: dbms_sql.define_column(c, 3, v_gl_date);
1642: dbms_sql.define_column(c, 4, v_ex_date);
1643: dbms_sql.define_column(c, 5, v_ex_rate_type, 30);
1644: dbms_sql.define_column(c, 6, v_ex_rate);

Line 1641: dbms_sql.define_column(c, 3, v_gl_date);

1637: dbms_sql.define_column(c, 6, v_crh_id);
1638: ELSE
1639: dbms_sql.define_column(c, 1, v_cr_id);
1640: dbms_sql.define_column(c, 2, v_trx_date);
1641: dbms_sql.define_column(c, 3, v_gl_date);
1642: dbms_sql.define_column(c, 4, v_ex_date);
1643: dbms_sql.define_column(c, 5, v_ex_rate_type, 30);
1644: dbms_sql.define_column(c, 6, v_ex_rate);
1645: dbms_sql.define_column(c, 7, v_currency, 15);

Line 1642: dbms_sql.define_column(c, 4, v_ex_date);

1638: ELSE
1639: dbms_sql.define_column(c, 1, v_cr_id);
1640: dbms_sql.define_column(c, 2, v_trx_date);
1641: dbms_sql.define_column(c, 3, v_gl_date);
1642: dbms_sql.define_column(c, 4, v_ex_date);
1643: dbms_sql.define_column(c, 5, v_ex_rate_type, 30);
1644: dbms_sql.define_column(c, 6, v_ex_rate);
1645: dbms_sql.define_column(c, 7, v_currency, 15);
1646: dbms_sql.define_column(c, 8, v_amount);

Line 1643: dbms_sql.define_column(c, 5, v_ex_rate_type, 30);

1639: dbms_sql.define_column(c, 1, v_cr_id);
1640: dbms_sql.define_column(c, 2, v_trx_date);
1641: dbms_sql.define_column(c, 3, v_gl_date);
1642: dbms_sql.define_column(c, 4, v_ex_date);
1643: dbms_sql.define_column(c, 5, v_ex_rate_type, 30);
1644: dbms_sql.define_column(c, 6, v_ex_rate);
1645: dbms_sql.define_column(c, 7, v_currency, 15);
1646: dbms_sql.define_column(c, 8, v_amount);
1647: dbms_sql.define_column(c, 9, v_fac_disc_amount);

Line 1644: dbms_sql.define_column(c, 6, v_ex_rate);

1640: dbms_sql.define_column(c, 2, v_trx_date);
1641: dbms_sql.define_column(c, 3, v_gl_date);
1642: dbms_sql.define_column(c, 4, v_ex_date);
1643: dbms_sql.define_column(c, 5, v_ex_rate_type, 30);
1644: dbms_sql.define_column(c, 6, v_ex_rate);
1645: dbms_sql.define_column(c, 7, v_currency, 15);
1646: dbms_sql.define_column(c, 8, v_amount);
1647: dbms_sql.define_column(c, 9, v_fac_disc_amount);
1648: dbms_sql.define_column(c, 10, v_mod_name, 30);

Line 1645: dbms_sql.define_column(c, 7, v_currency, 15);

1641: dbms_sql.define_column(c, 3, v_gl_date);
1642: dbms_sql.define_column(c, 4, v_ex_date);
1643: dbms_sql.define_column(c, 5, v_ex_rate_type, 30);
1644: dbms_sql.define_column(c, 6, v_ex_rate);
1645: dbms_sql.define_column(c, 7, v_currency, 15);
1646: dbms_sql.define_column(c, 8, v_amount);
1647: dbms_sql.define_column(c, 9, v_fac_disc_amount);
1648: dbms_sql.define_column(c, 10, v_mod_name, 30);
1649: dbms_sql.define_column(c, 11, v_mod_vers, 5);

Line 1646: dbms_sql.define_column(c, 8, v_amount);

1642: dbms_sql.define_column(c, 4, v_ex_date);
1643: dbms_sql.define_column(c, 5, v_ex_rate_type, 30);
1644: dbms_sql.define_column(c, 6, v_ex_rate);
1645: dbms_sql.define_column(c, 7, v_currency, 15);
1646: dbms_sql.define_column(c, 8, v_amount);
1647: dbms_sql.define_column(c, 9, v_fac_disc_amount);
1648: dbms_sql.define_column(c, 10, v_mod_name, 30);
1649: dbms_sql.define_column(c, 11, v_mod_vers, 5);
1650: dbms_sql.define_column(c, 12, v_crh_id);

Line 1647: dbms_sql.define_column(c, 9, v_fac_disc_amount);

1643: dbms_sql.define_column(c, 5, v_ex_rate_type, 30);
1644: dbms_sql.define_column(c, 6, v_ex_rate);
1645: dbms_sql.define_column(c, 7, v_currency, 15);
1646: dbms_sql.define_column(c, 8, v_amount);
1647: dbms_sql.define_column(c, 9, v_fac_disc_amount);
1648: dbms_sql.define_column(c, 10, v_mod_name, 30);
1649: dbms_sql.define_column(c, 11, v_mod_vers, 5);
1650: dbms_sql.define_column(c, 12, v_crh_id);
1651: dbms_sql.define_column(c, 13, v_crh_amount);

Line 1648: dbms_sql.define_column(c, 10, v_mod_name, 30);

1644: dbms_sql.define_column(c, 6, v_ex_rate);
1645: dbms_sql.define_column(c, 7, v_currency, 15);
1646: dbms_sql.define_column(c, 8, v_amount);
1647: dbms_sql.define_column(c, 9, v_fac_disc_amount);
1648: dbms_sql.define_column(c, 10, v_mod_name, 30);
1649: dbms_sql.define_column(c, 11, v_mod_vers, 5);
1650: dbms_sql.define_column(c, 12, v_crh_id);
1651: dbms_sql.define_column(c, 13, v_crh_amount);
1652: dbms_sql.define_column(c, 14, v_crh_fac_disc_amt);

Line 1649: dbms_sql.define_column(c, 11, v_mod_vers, 5);

1645: dbms_sql.define_column(c, 7, v_currency, 15);
1646: dbms_sql.define_column(c, 8, v_amount);
1647: dbms_sql.define_column(c, 9, v_fac_disc_amount);
1648: dbms_sql.define_column(c, 10, v_mod_name, 30);
1649: dbms_sql.define_column(c, 11, v_mod_vers, 5);
1650: dbms_sql.define_column(c, 12, v_crh_id);
1651: dbms_sql.define_column(c, 13, v_crh_amount);
1652: dbms_sql.define_column(c, 14, v_crh_fac_disc_amt);
1653: dbms_sql.define_column(c, 15, v_cr_currency, 15);

Line 1650: dbms_sql.define_column(c, 12, v_crh_id);

1646: dbms_sql.define_column(c, 8, v_amount);
1647: dbms_sql.define_column(c, 9, v_fac_disc_amount);
1648: dbms_sql.define_column(c, 10, v_mod_name, 30);
1649: dbms_sql.define_column(c, 11, v_mod_vers, 5);
1650: dbms_sql.define_column(c, 12, v_crh_id);
1651: dbms_sql.define_column(c, 13, v_crh_amount);
1652: dbms_sql.define_column(c, 14, v_crh_fac_disc_amt);
1653: dbms_sql.define_column(c, 15, v_cr_currency, 15);
1654: dbms_sql.define_column(c, 16, v_ex_rate_old);

Line 1651: dbms_sql.define_column(c, 13, v_crh_amount);

1647: dbms_sql.define_column(c, 9, v_fac_disc_amount);
1648: dbms_sql.define_column(c, 10, v_mod_name, 30);
1649: dbms_sql.define_column(c, 11, v_mod_vers, 5);
1650: dbms_sql.define_column(c, 12, v_crh_id);
1651: dbms_sql.define_column(c, 13, v_crh_amount);
1652: dbms_sql.define_column(c, 14, v_crh_fac_disc_amt);
1653: dbms_sql.define_column(c, 15, v_cr_currency, 15);
1654: dbms_sql.define_column(c, 16, v_ex_rate_old);
1655: END IF;

Line 1652: dbms_sql.define_column(c, 14, v_crh_fac_disc_amt);

1648: dbms_sql.define_column(c, 10, v_mod_name, 30);
1649: dbms_sql.define_column(c, 11, v_mod_vers, 5);
1650: dbms_sql.define_column(c, 12, v_crh_id);
1651: dbms_sql.define_column(c, 13, v_crh_amount);
1652: dbms_sql.define_column(c, 14, v_crh_fac_disc_amt);
1653: dbms_sql.define_column(c, 15, v_cr_currency, 15);
1654: dbms_sql.define_column(c, 16, v_ex_rate_old);
1655: END IF;
1656: --

Line 1653: dbms_sql.define_column(c, 15, v_cr_currency, 15);

1649: dbms_sql.define_column(c, 11, v_mod_vers, 5);
1650: dbms_sql.define_column(c, 12, v_crh_id);
1651: dbms_sql.define_column(c, 13, v_crh_amount);
1652: dbms_sql.define_column(c, 14, v_crh_fac_disc_amt);
1653: dbms_sql.define_column(c, 15, v_cr_currency, 15);
1654: dbms_sql.define_column(c, 16, v_ex_rate_old);
1655: END IF;
1656: --
1657: ignore := dbms_sql.execute(c);

Line 1654: dbms_sql.define_column(c, 16, v_ex_rate_old);

1650: dbms_sql.define_column(c, 12, v_crh_id);
1651: dbms_sql.define_column(c, 13, v_crh_amount);
1652: dbms_sql.define_column(c, 14, v_crh_fac_disc_amt);
1653: dbms_sql.define_column(c, 15, v_cr_currency, 15);
1654: dbms_sql.define_column(c, 16, v_ex_rate_old);
1655: END IF;
1656: --
1657: ignore := dbms_sql.execute(c);
1658: --

Line 1657: ignore := dbms_sql.execute(c);

1653: dbms_sql.define_column(c, 15, v_cr_currency, 15);
1654: dbms_sql.define_column(c, 16, v_ex_rate_old);
1655: END IF;
1656: --
1657: ignore := dbms_sql.execute(c);
1658: --
1659: IF ( remitted_or_factored_or_risk = 3) THEN
1660: LOOP
1661: IF dbms_sql.fetch_rows(c) > 0 THEN

Line 1661: IF dbms_sql.fetch_rows(c) > 0 THEN

1657: ignore := dbms_sql.execute(c);
1658: --
1659: IF ( remitted_or_factored_or_risk = 3) THEN
1660: LOOP
1661: IF dbms_sql.fetch_rows(c) > 0 THEN
1662: dbms_sql.column_value(c, 1, v_cr_id);
1663: dbms_sql.column_value(c, 2, v_trx_date);
1664: dbms_sql.column_value(c, 3, v_gl_date);
1665: dbms_sql.column_value(c, 4, v_mod_name);

Line 1662: dbms_sql.column_value(c, 1, v_cr_id);

1658: --
1659: IF ( remitted_or_factored_or_risk = 3) THEN
1660: LOOP
1661: IF dbms_sql.fetch_rows(c) > 0 THEN
1662: dbms_sql.column_value(c, 1, v_cr_id);
1663: dbms_sql.column_value(c, 2, v_trx_date);
1664: dbms_sql.column_value(c, 3, v_gl_date);
1665: dbms_sql.column_value(c, 4, v_mod_name);
1666: dbms_sql.column_value(c, 5, v_mod_vers);

Line 1663: dbms_sql.column_value(c, 2, v_trx_date);

1659: IF ( remitted_or_factored_or_risk = 3) THEN
1660: LOOP
1661: IF dbms_sql.fetch_rows(c) > 0 THEN
1662: dbms_sql.column_value(c, 1, v_cr_id);
1663: dbms_sql.column_value(c, 2, v_trx_date);
1664: dbms_sql.column_value(c, 3, v_gl_date);
1665: dbms_sql.column_value(c, 4, v_mod_name);
1666: dbms_sql.column_value(c, 5, v_mod_vers);
1667: dbms_sql.column_value(c, 6, v_crh_id);

Line 1664: dbms_sql.column_value(c, 3, v_gl_date);

1660: LOOP
1661: IF dbms_sql.fetch_rows(c) > 0 THEN
1662: dbms_sql.column_value(c, 1, v_cr_id);
1663: dbms_sql.column_value(c, 2, v_trx_date);
1664: dbms_sql.column_value(c, 3, v_gl_date);
1665: dbms_sql.column_value(c, 4, v_mod_name);
1666: dbms_sql.column_value(c, 5, v_mod_vers);
1667: dbms_sql.column_value(c, 6, v_crh_id);
1668: --

Line 1665: dbms_sql.column_value(c, 4, v_mod_name);

1661: IF dbms_sql.fetch_rows(c) > 0 THEN
1662: dbms_sql.column_value(c, 1, v_cr_id);
1663: dbms_sql.column_value(c, 2, v_trx_date);
1664: dbms_sql.column_value(c, 3, v_gl_date);
1665: dbms_sql.column_value(c, 4, v_mod_name);
1666: dbms_sql.column_value(c, 5, v_mod_vers);
1667: dbms_sql.column_value(c, 6, v_crh_id);
1668: --
1669: -- Lock rows

Line 1666: dbms_sql.column_value(c, 5, v_mod_vers);

1662: dbms_sql.column_value(c, 1, v_cr_id);
1663: dbms_sql.column_value(c, 2, v_trx_date);
1664: dbms_sql.column_value(c, 3, v_gl_date);
1665: dbms_sql.column_value(c, 4, v_mod_name);
1666: dbms_sql.column_value(c, 5, v_mod_vers);
1667: dbms_sql.column_value(c, 6, v_crh_id);
1668: --
1669: -- Lock rows
1670: --

Line 1667: dbms_sql.column_value(c, 6, v_crh_id);

1663: dbms_sql.column_value(c, 2, v_trx_date);
1664: dbms_sql.column_value(c, 3, v_gl_date);
1665: dbms_sql.column_value(c, 4, v_mod_name);
1666: dbms_sql.column_value(c, 5, v_mod_vers);
1667: dbms_sql.column_value(c, 6, v_crh_id);
1668: --
1669: -- Lock rows
1670: --
1671: BEGIN

Line 1713: IF dbms_sql.fetch_rows(c) > 0 THEN

1709:
1710: ARP_CASHBOOK.g_unq_cust_site_cur_org_cmb.delete;
1711: ELSE
1712: LOOP
1713: IF dbms_sql.fetch_rows(c) > 0 THEN
1714: dbms_sql.column_value(c, 1, v_cr_id);
1715: dbms_sql.column_value(c, 2, v_trx_date);
1716: dbms_sql.column_value(c, 3, v_gl_date);
1717: dbms_sql.column_value(c, 4, v_ex_date);

Line 1714: dbms_sql.column_value(c, 1, v_cr_id);

1710: ARP_CASHBOOK.g_unq_cust_site_cur_org_cmb.delete;
1711: ELSE
1712: LOOP
1713: IF dbms_sql.fetch_rows(c) > 0 THEN
1714: dbms_sql.column_value(c, 1, v_cr_id);
1715: dbms_sql.column_value(c, 2, v_trx_date);
1716: dbms_sql.column_value(c, 3, v_gl_date);
1717: dbms_sql.column_value(c, 4, v_ex_date);
1718: dbms_sql.column_value(c, 5, v_ex_rate_type);

Line 1715: dbms_sql.column_value(c, 2, v_trx_date);

1711: ELSE
1712: LOOP
1713: IF dbms_sql.fetch_rows(c) > 0 THEN
1714: dbms_sql.column_value(c, 1, v_cr_id);
1715: dbms_sql.column_value(c, 2, v_trx_date);
1716: dbms_sql.column_value(c, 3, v_gl_date);
1717: dbms_sql.column_value(c, 4, v_ex_date);
1718: dbms_sql.column_value(c, 5, v_ex_rate_type);
1719: dbms_sql.column_value(c, 6, v_ex_rate);

Line 1716: dbms_sql.column_value(c, 3, v_gl_date);

1712: LOOP
1713: IF dbms_sql.fetch_rows(c) > 0 THEN
1714: dbms_sql.column_value(c, 1, v_cr_id);
1715: dbms_sql.column_value(c, 2, v_trx_date);
1716: dbms_sql.column_value(c, 3, v_gl_date);
1717: dbms_sql.column_value(c, 4, v_ex_date);
1718: dbms_sql.column_value(c, 5, v_ex_rate_type);
1719: dbms_sql.column_value(c, 6, v_ex_rate);
1720: dbms_sql.column_value(c, 7, v_currency);

Line 1717: dbms_sql.column_value(c, 4, v_ex_date);

1713: IF dbms_sql.fetch_rows(c) > 0 THEN
1714: dbms_sql.column_value(c, 1, v_cr_id);
1715: dbms_sql.column_value(c, 2, v_trx_date);
1716: dbms_sql.column_value(c, 3, v_gl_date);
1717: dbms_sql.column_value(c, 4, v_ex_date);
1718: dbms_sql.column_value(c, 5, v_ex_rate_type);
1719: dbms_sql.column_value(c, 6, v_ex_rate);
1720: dbms_sql.column_value(c, 7, v_currency);
1721: dbms_sql.column_value(c, 8, v_amount);

Line 1718: dbms_sql.column_value(c, 5, v_ex_rate_type);

1714: dbms_sql.column_value(c, 1, v_cr_id);
1715: dbms_sql.column_value(c, 2, v_trx_date);
1716: dbms_sql.column_value(c, 3, v_gl_date);
1717: dbms_sql.column_value(c, 4, v_ex_date);
1718: dbms_sql.column_value(c, 5, v_ex_rate_type);
1719: dbms_sql.column_value(c, 6, v_ex_rate);
1720: dbms_sql.column_value(c, 7, v_currency);
1721: dbms_sql.column_value(c, 8, v_amount);
1722: dbms_sql.column_value(c, 9, v_fac_disc_amount);

Line 1719: dbms_sql.column_value(c, 6, v_ex_rate);

1715: dbms_sql.column_value(c, 2, v_trx_date);
1716: dbms_sql.column_value(c, 3, v_gl_date);
1717: dbms_sql.column_value(c, 4, v_ex_date);
1718: dbms_sql.column_value(c, 5, v_ex_rate_type);
1719: dbms_sql.column_value(c, 6, v_ex_rate);
1720: dbms_sql.column_value(c, 7, v_currency);
1721: dbms_sql.column_value(c, 8, v_amount);
1722: dbms_sql.column_value(c, 9, v_fac_disc_amount);
1723: dbms_sql.column_value(c, 10, v_mod_name);

Line 1720: dbms_sql.column_value(c, 7, v_currency);

1716: dbms_sql.column_value(c, 3, v_gl_date);
1717: dbms_sql.column_value(c, 4, v_ex_date);
1718: dbms_sql.column_value(c, 5, v_ex_rate_type);
1719: dbms_sql.column_value(c, 6, v_ex_rate);
1720: dbms_sql.column_value(c, 7, v_currency);
1721: dbms_sql.column_value(c, 8, v_amount);
1722: dbms_sql.column_value(c, 9, v_fac_disc_amount);
1723: dbms_sql.column_value(c, 10, v_mod_name);
1724: dbms_sql.column_value(c, 11, v_mod_vers);

Line 1721: dbms_sql.column_value(c, 8, v_amount);

1717: dbms_sql.column_value(c, 4, v_ex_date);
1718: dbms_sql.column_value(c, 5, v_ex_rate_type);
1719: dbms_sql.column_value(c, 6, v_ex_rate);
1720: dbms_sql.column_value(c, 7, v_currency);
1721: dbms_sql.column_value(c, 8, v_amount);
1722: dbms_sql.column_value(c, 9, v_fac_disc_amount);
1723: dbms_sql.column_value(c, 10, v_mod_name);
1724: dbms_sql.column_value(c, 11, v_mod_vers);
1725: dbms_sql.column_value(c, 12, v_crh_id);

Line 1722: dbms_sql.column_value(c, 9, v_fac_disc_amount);

1718: dbms_sql.column_value(c, 5, v_ex_rate_type);
1719: dbms_sql.column_value(c, 6, v_ex_rate);
1720: dbms_sql.column_value(c, 7, v_currency);
1721: dbms_sql.column_value(c, 8, v_amount);
1722: dbms_sql.column_value(c, 9, v_fac_disc_amount);
1723: dbms_sql.column_value(c, 10, v_mod_name);
1724: dbms_sql.column_value(c, 11, v_mod_vers);
1725: dbms_sql.column_value(c, 12, v_crh_id);
1726: dbms_sql.column_value(c, 13, v_crh_amount);

Line 1723: dbms_sql.column_value(c, 10, v_mod_name);

1719: dbms_sql.column_value(c, 6, v_ex_rate);
1720: dbms_sql.column_value(c, 7, v_currency);
1721: dbms_sql.column_value(c, 8, v_amount);
1722: dbms_sql.column_value(c, 9, v_fac_disc_amount);
1723: dbms_sql.column_value(c, 10, v_mod_name);
1724: dbms_sql.column_value(c, 11, v_mod_vers);
1725: dbms_sql.column_value(c, 12, v_crh_id);
1726: dbms_sql.column_value(c, 13, v_crh_amount);
1727: dbms_sql.column_value(c, 14, v_crh_fac_disc_amt);

Line 1724: dbms_sql.column_value(c, 11, v_mod_vers);

1720: dbms_sql.column_value(c, 7, v_currency);
1721: dbms_sql.column_value(c, 8, v_amount);
1722: dbms_sql.column_value(c, 9, v_fac_disc_amount);
1723: dbms_sql.column_value(c, 10, v_mod_name);
1724: dbms_sql.column_value(c, 11, v_mod_vers);
1725: dbms_sql.column_value(c, 12, v_crh_id);
1726: dbms_sql.column_value(c, 13, v_crh_amount);
1727: dbms_sql.column_value(c, 14, v_crh_fac_disc_amt);
1728: dbms_sql.column_value(c, 15, v_cr_currency);

Line 1725: dbms_sql.column_value(c, 12, v_crh_id);

1721: dbms_sql.column_value(c, 8, v_amount);
1722: dbms_sql.column_value(c, 9, v_fac_disc_amount);
1723: dbms_sql.column_value(c, 10, v_mod_name);
1724: dbms_sql.column_value(c, 11, v_mod_vers);
1725: dbms_sql.column_value(c, 12, v_crh_id);
1726: dbms_sql.column_value(c, 13, v_crh_amount);
1727: dbms_sql.column_value(c, 14, v_crh_fac_disc_amt);
1728: dbms_sql.column_value(c, 15, v_cr_currency);
1729: dbms_sql.column_value(c, 16, v_ex_rate_old);

Line 1726: dbms_sql.column_value(c, 13, v_crh_amount);

1722: dbms_sql.column_value(c, 9, v_fac_disc_amount);
1723: dbms_sql.column_value(c, 10, v_mod_name);
1724: dbms_sql.column_value(c, 11, v_mod_vers);
1725: dbms_sql.column_value(c, 12, v_crh_id);
1726: dbms_sql.column_value(c, 13, v_crh_amount);
1727: dbms_sql.column_value(c, 14, v_crh_fac_disc_amt);
1728: dbms_sql.column_value(c, 15, v_cr_currency);
1729: dbms_sql.column_value(c, 16, v_ex_rate_old);
1730: --

Line 1727: dbms_sql.column_value(c, 14, v_crh_fac_disc_amt);

1723: dbms_sql.column_value(c, 10, v_mod_name);
1724: dbms_sql.column_value(c, 11, v_mod_vers);
1725: dbms_sql.column_value(c, 12, v_crh_id);
1726: dbms_sql.column_value(c, 13, v_crh_amount);
1727: dbms_sql.column_value(c, 14, v_crh_fac_disc_amt);
1728: dbms_sql.column_value(c, 15, v_cr_currency);
1729: dbms_sql.column_value(c, 16, v_ex_rate_old);
1730: --
1731: -- Lock rows

Line 1728: dbms_sql.column_value(c, 15, v_cr_currency);

1724: dbms_sql.column_value(c, 11, v_mod_vers);
1725: dbms_sql.column_value(c, 12, v_crh_id);
1726: dbms_sql.column_value(c, 13, v_crh_amount);
1727: dbms_sql.column_value(c, 14, v_crh_fac_disc_amt);
1728: dbms_sql.column_value(c, 15, v_cr_currency);
1729: dbms_sql.column_value(c, 16, v_ex_rate_old);
1730: --
1731: -- Lock rows
1732: --

Line 1729: dbms_sql.column_value(c, 16, v_ex_rate_old);

1725: dbms_sql.column_value(c, 12, v_crh_id);
1726: dbms_sql.column_value(c, 13, v_crh_amount);
1727: dbms_sql.column_value(c, 14, v_crh_fac_disc_amt);
1728: dbms_sql.column_value(c, 15, v_cr_currency);
1729: dbms_sql.column_value(c, 16, v_ex_rate_old);
1730: --
1731: -- Lock rows
1732: --
1733: BEGIN

Line 1845: dbms_sql.close_cursor(c);

1841: ARP_CASHBOOK.g_unq_cust_site_cur_org_cmb.delete;
1842:
1843: END IF;
1844: --
1845: dbms_sql.close_cursor(c);
1846: fnd_file.put_line(fnd_file.log, 'clr_remit_disc_risk_rcpts_pa()-');
1847: --
1848: EXCEPTION
1849: WHEN OTHERS THEN