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 679: IF dbms_sql.fetch_rows(c) > 0 THEN

675: --
676: END LOOP;
677: ELSE
678: LOOP
679: IF dbms_sql.fetch_rows(c) > 0 THEN
680: dbms_sql.column_value(c, 1, v_cr_id);
681: dbms_sql.column_value(c, 2, v_trx_date);
682: dbms_sql.column_value(c, 3, v_gl_date);
683: dbms_sql.column_value(c, 4, v_ex_date);

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

676: END LOOP;
677: ELSE
678: LOOP
679: IF dbms_sql.fetch_rows(c) > 0 THEN
680: dbms_sql.column_value(c, 1, v_cr_id);
681: dbms_sql.column_value(c, 2, v_trx_date);
682: dbms_sql.column_value(c, 3, v_gl_date);
683: dbms_sql.column_value(c, 4, v_ex_date);
684: dbms_sql.column_value(c, 5, v_ex_rate_type);

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

677: ELSE
678: LOOP
679: IF dbms_sql.fetch_rows(c) > 0 THEN
680: dbms_sql.column_value(c, 1, v_cr_id);
681: dbms_sql.column_value(c, 2, v_trx_date);
682: dbms_sql.column_value(c, 3, v_gl_date);
683: dbms_sql.column_value(c, 4, v_ex_date);
684: dbms_sql.column_value(c, 5, v_ex_rate_type);
685: dbms_sql.column_value(c, 6, v_ex_rate);

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

678: LOOP
679: IF dbms_sql.fetch_rows(c) > 0 THEN
680: dbms_sql.column_value(c, 1, v_cr_id);
681: dbms_sql.column_value(c, 2, v_trx_date);
682: dbms_sql.column_value(c, 3, v_gl_date);
683: dbms_sql.column_value(c, 4, v_ex_date);
684: dbms_sql.column_value(c, 5, v_ex_rate_type);
685: dbms_sql.column_value(c, 6, v_ex_rate);
686: dbms_sql.column_value(c, 7, v_currency);

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

679: IF dbms_sql.fetch_rows(c) > 0 THEN
680: dbms_sql.column_value(c, 1, v_cr_id);
681: dbms_sql.column_value(c, 2, v_trx_date);
682: dbms_sql.column_value(c, 3, v_gl_date);
683: dbms_sql.column_value(c, 4, v_ex_date);
684: dbms_sql.column_value(c, 5, v_ex_rate_type);
685: dbms_sql.column_value(c, 6, v_ex_rate);
686: dbms_sql.column_value(c, 7, v_currency);
687: dbms_sql.column_value(c, 8, v_amount);

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

680: dbms_sql.column_value(c, 1, v_cr_id);
681: dbms_sql.column_value(c, 2, v_trx_date);
682: dbms_sql.column_value(c, 3, v_gl_date);
683: dbms_sql.column_value(c, 4, v_ex_date);
684: dbms_sql.column_value(c, 5, v_ex_rate_type);
685: dbms_sql.column_value(c, 6, v_ex_rate);
686: dbms_sql.column_value(c, 7, v_currency);
687: dbms_sql.column_value(c, 8, v_amount);
688: dbms_sql.column_value(c, 9, v_fac_disc_amount);

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

681: dbms_sql.column_value(c, 2, v_trx_date);
682: dbms_sql.column_value(c, 3, v_gl_date);
683: dbms_sql.column_value(c, 4, v_ex_date);
684: dbms_sql.column_value(c, 5, v_ex_rate_type);
685: dbms_sql.column_value(c, 6, v_ex_rate);
686: dbms_sql.column_value(c, 7, v_currency);
687: dbms_sql.column_value(c, 8, v_amount);
688: dbms_sql.column_value(c, 9, v_fac_disc_amount);
689: dbms_sql.column_value(c, 10, v_mod_name);

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

682: dbms_sql.column_value(c, 3, v_gl_date);
683: dbms_sql.column_value(c, 4, v_ex_date);
684: dbms_sql.column_value(c, 5, v_ex_rate_type);
685: dbms_sql.column_value(c, 6, v_ex_rate);
686: dbms_sql.column_value(c, 7, v_currency);
687: dbms_sql.column_value(c, 8, v_amount);
688: dbms_sql.column_value(c, 9, v_fac_disc_amount);
689: dbms_sql.column_value(c, 10, v_mod_name);
690: dbms_sql.column_value(c, 11, v_mod_vers);

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

683: dbms_sql.column_value(c, 4, v_ex_date);
684: dbms_sql.column_value(c, 5, v_ex_rate_type);
685: dbms_sql.column_value(c, 6, v_ex_rate);
686: dbms_sql.column_value(c, 7, v_currency);
687: dbms_sql.column_value(c, 8, v_amount);
688: dbms_sql.column_value(c, 9, v_fac_disc_amount);
689: dbms_sql.column_value(c, 10, v_mod_name);
690: dbms_sql.column_value(c, 11, v_mod_vers);
691: dbms_sql.column_value(c, 12, v_crh_id);

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

684: dbms_sql.column_value(c, 5, v_ex_rate_type);
685: dbms_sql.column_value(c, 6, v_ex_rate);
686: dbms_sql.column_value(c, 7, v_currency);
687: dbms_sql.column_value(c, 8, v_amount);
688: dbms_sql.column_value(c, 9, v_fac_disc_amount);
689: dbms_sql.column_value(c, 10, v_mod_name);
690: dbms_sql.column_value(c, 11, v_mod_vers);
691: dbms_sql.column_value(c, 12, v_crh_id);
692: dbms_sql.column_value(c, 13, v_crh_amount);

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

685: dbms_sql.column_value(c, 6, v_ex_rate);
686: dbms_sql.column_value(c, 7, v_currency);
687: dbms_sql.column_value(c, 8, v_amount);
688: dbms_sql.column_value(c, 9, v_fac_disc_amount);
689: dbms_sql.column_value(c, 10, v_mod_name);
690: dbms_sql.column_value(c, 11, v_mod_vers);
691: dbms_sql.column_value(c, 12, v_crh_id);
692: dbms_sql.column_value(c, 13, v_crh_amount);
693: dbms_sql.column_value(c, 14, v_crh_fac_disc_amt);

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

686: dbms_sql.column_value(c, 7, v_currency);
687: dbms_sql.column_value(c, 8, v_amount);
688: dbms_sql.column_value(c, 9, v_fac_disc_amount);
689: dbms_sql.column_value(c, 10, v_mod_name);
690: dbms_sql.column_value(c, 11, v_mod_vers);
691: dbms_sql.column_value(c, 12, v_crh_id);
692: dbms_sql.column_value(c, 13, v_crh_amount);
693: dbms_sql.column_value(c, 14, v_crh_fac_disc_amt);
694: dbms_sql.column_value(c, 15, v_cr_currency);

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

687: dbms_sql.column_value(c, 8, v_amount);
688: dbms_sql.column_value(c, 9, v_fac_disc_amount);
689: dbms_sql.column_value(c, 10, v_mod_name);
690: dbms_sql.column_value(c, 11, v_mod_vers);
691: dbms_sql.column_value(c, 12, v_crh_id);
692: dbms_sql.column_value(c, 13, v_crh_amount);
693: dbms_sql.column_value(c, 14, v_crh_fac_disc_amt);
694: dbms_sql.column_value(c, 15, v_cr_currency);
695: dbms_sql.column_value(c, 16, v_ex_rate_old);

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

688: dbms_sql.column_value(c, 9, v_fac_disc_amount);
689: dbms_sql.column_value(c, 10, v_mod_name);
690: dbms_sql.column_value(c, 11, v_mod_vers);
691: dbms_sql.column_value(c, 12, v_crh_id);
692: dbms_sql.column_value(c, 13, v_crh_amount);
693: dbms_sql.column_value(c, 14, v_crh_fac_disc_amt);
694: dbms_sql.column_value(c, 15, v_cr_currency);
695: dbms_sql.column_value(c, 16, v_ex_rate_old);
696: --

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

689: dbms_sql.column_value(c, 10, v_mod_name);
690: dbms_sql.column_value(c, 11, v_mod_vers);
691: dbms_sql.column_value(c, 12, v_crh_id);
692: dbms_sql.column_value(c, 13, v_crh_amount);
693: dbms_sql.column_value(c, 14, v_crh_fac_disc_amt);
694: dbms_sql.column_value(c, 15, v_cr_currency);
695: dbms_sql.column_value(c, 16, v_ex_rate_old);
696: --
697: -- Lock rows

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

690: dbms_sql.column_value(c, 11, v_mod_vers);
691: dbms_sql.column_value(c, 12, v_crh_id);
692: dbms_sql.column_value(c, 13, v_crh_amount);
693: dbms_sql.column_value(c, 14, v_crh_fac_disc_amt);
694: dbms_sql.column_value(c, 15, v_cr_currency);
695: dbms_sql.column_value(c, 16, v_ex_rate_old);
696: --
697: -- Lock rows
698: --

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

691: dbms_sql.column_value(c, 12, v_crh_id);
692: dbms_sql.column_value(c, 13, v_crh_amount);
693: dbms_sql.column_value(c, 14, v_crh_fac_disc_amt);
694: dbms_sql.column_value(c, 15, v_cr_currency);
695: dbms_sql.column_value(c, 16, v_ex_rate_old);
696: --
697: -- Lock rows
698: --
699: BEGIN

Line 799: dbms_sql.close_cursor(c);

795: END IF;
796: END LOOP;
797: END IF;
798: --
799: dbms_sql.close_cursor(c);
800: --
801: EXCEPTION
802: WHEN OTHERS THEN
803: arp_standard.debug('Exception: ar_automatic_clearing_pkg ');

Line 1319: c := dbms_sql.open_cursor;

1315: p_total_workers,
1316: p_request_id );
1317: END IF;
1318: --
1319: c := dbms_sql.open_cursor;
1320: --
1321: -- Build expanded select-statement depending on parameters
1322: --
1323: expand_stmt( p_customer_name_low,

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

1330: p_payment_method_id,
1331: p_batch_id,
1332: statement );
1333: --
1334: dbms_sql.parse(c, statement, dbms_sql.native);
1335: --
1336: IF PG_DEBUG in ('Y', 'C') THEN
1337: arp_standard.debug('Inside populate_interim_table()');
1338: arp_standard.debug( 'Statement ' || statement);

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

1338: arp_standard.debug( 'Statement ' || statement);
1339: END IF;
1340: -- Bind variables
1341: --
1342: dbms_sql.bind_variable(c, ':b_clear_date' ,p_clear_date);
1343: dbms_sql.bind_variable(c, ':b_gl_date' ,p_gl_date);
1344: --
1345: IF ( remitted_or_factored_or_risk <> 3) THEN
1346: dbms_sql.bind_variable(c, ':b_exchange_rate_type' ,p_exchange_rate_type);

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

1339: END IF;
1340: -- Bind variables
1341: --
1342: dbms_sql.bind_variable(c, ':b_clear_date' ,p_clear_date);
1343: dbms_sql.bind_variable(c, ':b_gl_date' ,p_gl_date);
1344: --
1345: IF ( remitted_or_factored_or_risk <> 3) THEN
1346: dbms_sql.bind_variable(c, ':b_exchange_rate_type' ,p_exchange_rate_type);
1347: dbms_sql.bind_variable(c, ':b_set_of_bks_id' ,v_set_of_bks_id);

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

1342: dbms_sql.bind_variable(c, ':b_clear_date' ,p_clear_date);
1343: dbms_sql.bind_variable(c, ':b_gl_date' ,p_gl_date);
1344: --
1345: IF ( remitted_or_factored_or_risk <> 3) THEN
1346: dbms_sql.bind_variable(c, ':b_exchange_rate_type' ,p_exchange_rate_type);
1347: dbms_sql.bind_variable(c, ':b_set_of_bks_id' ,v_set_of_bks_id);
1348:
1349: -- Bug 706935.
1350: -- Removed this line.

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

1343: dbms_sql.bind_variable(c, ':b_gl_date' ,p_gl_date);
1344: --
1345: IF ( remitted_or_factored_or_risk <> 3) THEN
1346: dbms_sql.bind_variable(c, ':b_exchange_rate_type' ,p_exchange_rate_type);
1347: dbms_sql.bind_variable(c, ':b_set_of_bks_id' ,v_set_of_bks_id);
1348:
1349: -- Bug 706935.
1350: -- Removed this line.
1351: -- dbms_sql.bind_variable(c, ':b_batch_id' ,p_batch_id);

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

1347: dbms_sql.bind_variable(c, ':b_set_of_bks_id' ,v_set_of_bks_id);
1348:
1349: -- Bug 706935.
1350: -- Removed this line.
1351: -- dbms_sql.bind_variable(c, ':b_batch_id' ,p_batch_id);
1352:
1353: END IF;
1354: --
1355: ar_bind_variables( p_customer_name_low,

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

1362: p_payment_method_id,
1363: p_batch_id,
1364: c );
1365: --
1366: ignore := dbms_sql.execute(c);
1367: IF PG_DEBUG IN ('Y','C') THEN
1368: fnd_file.put_line(fnd_file.LOG, 'No of Records Selected : '|| ignore);
1369: END IF;
1370: --

Line 1373: dbms_sql.close_cursor(c);

1369: END IF;
1370: --
1371: commit; -- Commit the values inserted into the interim table.
1372: --
1373: dbms_sql.close_cursor(c);
1374: fnd_file.put_line( FND_FILE.LOG, 'populate_interim_table()-');
1375: --
1376: EXCEPTION
1377: WHEN OTHERS THEN

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

1519: --
1520: BEGIN
1521: --
1522: IF ( p_worker_number IS NOT NULL ) THEN
1523: dbms_sql.bind_variable(c, ':b_worker_number' ,p_worker_number);
1524: END IF;
1525: --
1526: IF ( p_request_id IS NOT NULL ) THEN
1527: dbms_sql.bind_variable(c, ':b_request_id' ,p_request_id);

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

1523: dbms_sql.bind_variable(c, ':b_worker_number' ,p_worker_number);
1524: END IF;
1525: --
1526: IF ( p_request_id IS NOT NULL ) THEN
1527: dbms_sql.bind_variable(c, ':b_request_id' ,p_request_id);
1528: END IF;
1529: --
1530: EXCEPTION
1531: WHEN OTHERS THEN

Line 1590: c := dbms_sql.open_cursor;

1586: main_select_risk_parallel(
1587: statement );
1588: END IF;
1589: --
1590: c := dbms_sql.open_cursor;
1591: --
1592: dbms_sql.parse(c, statement, dbms_sql.native);
1593: --
1594: -- Bind variables

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

1588: END IF;
1589: --
1590: c := dbms_sql.open_cursor;
1591: --
1592: dbms_sql.parse(c, statement, dbms_sql.native);
1593: --
1594: -- Bind variables
1595: --
1596: fnd_file.put_line(fnd_file.log, 'Worker No ' ||p_worker_number);

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

1600: p_request_id,
1601: c );
1602: --
1603: IF ( remitted_or_factored_or_risk = 3) THEN
1604: dbms_sql.define_column(c, 1, v_cr_id);
1605: dbms_sql.define_column(c, 2, v_trx_date);
1606: dbms_sql.define_column(c, 3, v_gl_date);
1607: dbms_sql.define_column(c, 4, v_mod_name, 30);
1608: dbms_sql.define_column(c, 5, v_mod_vers, 5);

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

1601: c );
1602: --
1603: IF ( remitted_or_factored_or_risk = 3) THEN
1604: dbms_sql.define_column(c, 1, v_cr_id);
1605: dbms_sql.define_column(c, 2, v_trx_date);
1606: dbms_sql.define_column(c, 3, v_gl_date);
1607: dbms_sql.define_column(c, 4, v_mod_name, 30);
1608: dbms_sql.define_column(c, 5, v_mod_vers, 5);
1609: dbms_sql.define_column(c, 6, v_crh_id);

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

1602: --
1603: IF ( remitted_or_factored_or_risk = 3) THEN
1604: dbms_sql.define_column(c, 1, v_cr_id);
1605: dbms_sql.define_column(c, 2, v_trx_date);
1606: dbms_sql.define_column(c, 3, v_gl_date);
1607: dbms_sql.define_column(c, 4, v_mod_name, 30);
1608: dbms_sql.define_column(c, 5, v_mod_vers, 5);
1609: dbms_sql.define_column(c, 6, v_crh_id);
1610: ELSE

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

1603: IF ( remitted_or_factored_or_risk = 3) THEN
1604: dbms_sql.define_column(c, 1, v_cr_id);
1605: dbms_sql.define_column(c, 2, v_trx_date);
1606: dbms_sql.define_column(c, 3, v_gl_date);
1607: dbms_sql.define_column(c, 4, v_mod_name, 30);
1608: dbms_sql.define_column(c, 5, v_mod_vers, 5);
1609: dbms_sql.define_column(c, 6, v_crh_id);
1610: ELSE
1611: dbms_sql.define_column(c, 1, v_cr_id);

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

1604: dbms_sql.define_column(c, 1, v_cr_id);
1605: dbms_sql.define_column(c, 2, v_trx_date);
1606: dbms_sql.define_column(c, 3, v_gl_date);
1607: dbms_sql.define_column(c, 4, v_mod_name, 30);
1608: dbms_sql.define_column(c, 5, v_mod_vers, 5);
1609: dbms_sql.define_column(c, 6, v_crh_id);
1610: ELSE
1611: dbms_sql.define_column(c, 1, v_cr_id);
1612: dbms_sql.define_column(c, 2, v_trx_date);

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

1605: dbms_sql.define_column(c, 2, v_trx_date);
1606: dbms_sql.define_column(c, 3, v_gl_date);
1607: dbms_sql.define_column(c, 4, v_mod_name, 30);
1608: dbms_sql.define_column(c, 5, v_mod_vers, 5);
1609: dbms_sql.define_column(c, 6, v_crh_id);
1610: ELSE
1611: dbms_sql.define_column(c, 1, v_cr_id);
1612: dbms_sql.define_column(c, 2, v_trx_date);
1613: dbms_sql.define_column(c, 3, v_gl_date);

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

1607: dbms_sql.define_column(c, 4, v_mod_name, 30);
1608: dbms_sql.define_column(c, 5, v_mod_vers, 5);
1609: dbms_sql.define_column(c, 6, v_crh_id);
1610: ELSE
1611: dbms_sql.define_column(c, 1, v_cr_id);
1612: dbms_sql.define_column(c, 2, v_trx_date);
1613: dbms_sql.define_column(c, 3, v_gl_date);
1614: dbms_sql.define_column(c, 4, v_ex_date);
1615: dbms_sql.define_column(c, 5, v_ex_rate_type, 30);

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

1608: dbms_sql.define_column(c, 5, v_mod_vers, 5);
1609: dbms_sql.define_column(c, 6, v_crh_id);
1610: ELSE
1611: dbms_sql.define_column(c, 1, v_cr_id);
1612: dbms_sql.define_column(c, 2, v_trx_date);
1613: dbms_sql.define_column(c, 3, v_gl_date);
1614: dbms_sql.define_column(c, 4, v_ex_date);
1615: dbms_sql.define_column(c, 5, v_ex_rate_type, 30);
1616: dbms_sql.define_column(c, 6, v_ex_rate);

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

1609: dbms_sql.define_column(c, 6, v_crh_id);
1610: ELSE
1611: dbms_sql.define_column(c, 1, v_cr_id);
1612: dbms_sql.define_column(c, 2, v_trx_date);
1613: dbms_sql.define_column(c, 3, v_gl_date);
1614: dbms_sql.define_column(c, 4, v_ex_date);
1615: dbms_sql.define_column(c, 5, v_ex_rate_type, 30);
1616: dbms_sql.define_column(c, 6, v_ex_rate);
1617: dbms_sql.define_column(c, 7, v_currency, 15);

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

1610: ELSE
1611: dbms_sql.define_column(c, 1, v_cr_id);
1612: dbms_sql.define_column(c, 2, v_trx_date);
1613: dbms_sql.define_column(c, 3, v_gl_date);
1614: dbms_sql.define_column(c, 4, v_ex_date);
1615: dbms_sql.define_column(c, 5, v_ex_rate_type, 30);
1616: dbms_sql.define_column(c, 6, v_ex_rate);
1617: dbms_sql.define_column(c, 7, v_currency, 15);
1618: dbms_sql.define_column(c, 8, v_amount);

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

1611: dbms_sql.define_column(c, 1, v_cr_id);
1612: dbms_sql.define_column(c, 2, v_trx_date);
1613: dbms_sql.define_column(c, 3, v_gl_date);
1614: dbms_sql.define_column(c, 4, v_ex_date);
1615: dbms_sql.define_column(c, 5, v_ex_rate_type, 30);
1616: dbms_sql.define_column(c, 6, v_ex_rate);
1617: dbms_sql.define_column(c, 7, v_currency, 15);
1618: dbms_sql.define_column(c, 8, v_amount);
1619: dbms_sql.define_column(c, 9, v_fac_disc_amount);

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

1612: dbms_sql.define_column(c, 2, v_trx_date);
1613: dbms_sql.define_column(c, 3, v_gl_date);
1614: dbms_sql.define_column(c, 4, v_ex_date);
1615: dbms_sql.define_column(c, 5, v_ex_rate_type, 30);
1616: dbms_sql.define_column(c, 6, v_ex_rate);
1617: dbms_sql.define_column(c, 7, v_currency, 15);
1618: dbms_sql.define_column(c, 8, v_amount);
1619: dbms_sql.define_column(c, 9, v_fac_disc_amount);
1620: dbms_sql.define_column(c, 10, v_mod_name, 30);

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

1613: dbms_sql.define_column(c, 3, v_gl_date);
1614: dbms_sql.define_column(c, 4, v_ex_date);
1615: dbms_sql.define_column(c, 5, v_ex_rate_type, 30);
1616: dbms_sql.define_column(c, 6, v_ex_rate);
1617: dbms_sql.define_column(c, 7, v_currency, 15);
1618: dbms_sql.define_column(c, 8, v_amount);
1619: dbms_sql.define_column(c, 9, v_fac_disc_amount);
1620: dbms_sql.define_column(c, 10, v_mod_name, 30);
1621: dbms_sql.define_column(c, 11, v_mod_vers, 5);

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

1614: dbms_sql.define_column(c, 4, v_ex_date);
1615: dbms_sql.define_column(c, 5, v_ex_rate_type, 30);
1616: dbms_sql.define_column(c, 6, v_ex_rate);
1617: dbms_sql.define_column(c, 7, v_currency, 15);
1618: dbms_sql.define_column(c, 8, v_amount);
1619: dbms_sql.define_column(c, 9, v_fac_disc_amount);
1620: dbms_sql.define_column(c, 10, v_mod_name, 30);
1621: dbms_sql.define_column(c, 11, v_mod_vers, 5);
1622: dbms_sql.define_column(c, 12, v_crh_id);

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

1615: dbms_sql.define_column(c, 5, v_ex_rate_type, 30);
1616: dbms_sql.define_column(c, 6, v_ex_rate);
1617: dbms_sql.define_column(c, 7, v_currency, 15);
1618: dbms_sql.define_column(c, 8, v_amount);
1619: dbms_sql.define_column(c, 9, v_fac_disc_amount);
1620: dbms_sql.define_column(c, 10, v_mod_name, 30);
1621: dbms_sql.define_column(c, 11, v_mod_vers, 5);
1622: dbms_sql.define_column(c, 12, v_crh_id);
1623: dbms_sql.define_column(c, 13, v_crh_amount);

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

1616: dbms_sql.define_column(c, 6, v_ex_rate);
1617: dbms_sql.define_column(c, 7, v_currency, 15);
1618: dbms_sql.define_column(c, 8, v_amount);
1619: dbms_sql.define_column(c, 9, v_fac_disc_amount);
1620: dbms_sql.define_column(c, 10, v_mod_name, 30);
1621: dbms_sql.define_column(c, 11, v_mod_vers, 5);
1622: dbms_sql.define_column(c, 12, v_crh_id);
1623: dbms_sql.define_column(c, 13, v_crh_amount);
1624: dbms_sql.define_column(c, 14, v_crh_fac_disc_amt);

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

1617: dbms_sql.define_column(c, 7, v_currency, 15);
1618: dbms_sql.define_column(c, 8, v_amount);
1619: dbms_sql.define_column(c, 9, v_fac_disc_amount);
1620: dbms_sql.define_column(c, 10, v_mod_name, 30);
1621: dbms_sql.define_column(c, 11, v_mod_vers, 5);
1622: dbms_sql.define_column(c, 12, v_crh_id);
1623: dbms_sql.define_column(c, 13, v_crh_amount);
1624: dbms_sql.define_column(c, 14, v_crh_fac_disc_amt);
1625: dbms_sql.define_column(c, 15, v_cr_currency, 15);

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

1618: dbms_sql.define_column(c, 8, v_amount);
1619: dbms_sql.define_column(c, 9, v_fac_disc_amount);
1620: dbms_sql.define_column(c, 10, v_mod_name, 30);
1621: dbms_sql.define_column(c, 11, v_mod_vers, 5);
1622: dbms_sql.define_column(c, 12, v_crh_id);
1623: dbms_sql.define_column(c, 13, v_crh_amount);
1624: dbms_sql.define_column(c, 14, v_crh_fac_disc_amt);
1625: dbms_sql.define_column(c, 15, v_cr_currency, 15);
1626: dbms_sql.define_column(c, 16, v_ex_rate_old);

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

1619: dbms_sql.define_column(c, 9, v_fac_disc_amount);
1620: dbms_sql.define_column(c, 10, v_mod_name, 30);
1621: dbms_sql.define_column(c, 11, v_mod_vers, 5);
1622: dbms_sql.define_column(c, 12, v_crh_id);
1623: dbms_sql.define_column(c, 13, v_crh_amount);
1624: dbms_sql.define_column(c, 14, v_crh_fac_disc_amt);
1625: dbms_sql.define_column(c, 15, v_cr_currency, 15);
1626: dbms_sql.define_column(c, 16, v_ex_rate_old);
1627: END IF;

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

1620: dbms_sql.define_column(c, 10, v_mod_name, 30);
1621: dbms_sql.define_column(c, 11, v_mod_vers, 5);
1622: dbms_sql.define_column(c, 12, v_crh_id);
1623: dbms_sql.define_column(c, 13, v_crh_amount);
1624: dbms_sql.define_column(c, 14, v_crh_fac_disc_amt);
1625: dbms_sql.define_column(c, 15, v_cr_currency, 15);
1626: dbms_sql.define_column(c, 16, v_ex_rate_old);
1627: END IF;
1628: --

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

1621: dbms_sql.define_column(c, 11, v_mod_vers, 5);
1622: dbms_sql.define_column(c, 12, v_crh_id);
1623: dbms_sql.define_column(c, 13, v_crh_amount);
1624: dbms_sql.define_column(c, 14, v_crh_fac_disc_amt);
1625: dbms_sql.define_column(c, 15, v_cr_currency, 15);
1626: dbms_sql.define_column(c, 16, v_ex_rate_old);
1627: END IF;
1628: --
1629: ignore := dbms_sql.execute(c);

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

1622: dbms_sql.define_column(c, 12, v_crh_id);
1623: dbms_sql.define_column(c, 13, v_crh_amount);
1624: dbms_sql.define_column(c, 14, v_crh_fac_disc_amt);
1625: dbms_sql.define_column(c, 15, v_cr_currency, 15);
1626: dbms_sql.define_column(c, 16, v_ex_rate_old);
1627: END IF;
1628: --
1629: ignore := dbms_sql.execute(c);
1630: --

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

1625: dbms_sql.define_column(c, 15, v_cr_currency, 15);
1626: dbms_sql.define_column(c, 16, v_ex_rate_old);
1627: END IF;
1628: --
1629: ignore := dbms_sql.execute(c);
1630: --
1631: IF ( remitted_or_factored_or_risk = 3) THEN
1632: LOOP
1633: IF dbms_sql.fetch_rows(c) > 0 THEN

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

1629: ignore := dbms_sql.execute(c);
1630: --
1631: IF ( remitted_or_factored_or_risk = 3) THEN
1632: LOOP
1633: IF dbms_sql.fetch_rows(c) > 0 THEN
1634: dbms_sql.column_value(c, 1, v_cr_id);
1635: dbms_sql.column_value(c, 2, v_trx_date);
1636: dbms_sql.column_value(c, 3, v_gl_date);
1637: dbms_sql.column_value(c, 4, v_mod_name);

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

1630: --
1631: IF ( remitted_or_factored_or_risk = 3) THEN
1632: LOOP
1633: IF dbms_sql.fetch_rows(c) > 0 THEN
1634: dbms_sql.column_value(c, 1, v_cr_id);
1635: dbms_sql.column_value(c, 2, v_trx_date);
1636: dbms_sql.column_value(c, 3, v_gl_date);
1637: dbms_sql.column_value(c, 4, v_mod_name);
1638: dbms_sql.column_value(c, 5, v_mod_vers);

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

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

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

1632: LOOP
1633: IF dbms_sql.fetch_rows(c) > 0 THEN
1634: dbms_sql.column_value(c, 1, v_cr_id);
1635: dbms_sql.column_value(c, 2, v_trx_date);
1636: dbms_sql.column_value(c, 3, v_gl_date);
1637: dbms_sql.column_value(c, 4, v_mod_name);
1638: dbms_sql.column_value(c, 5, v_mod_vers);
1639: dbms_sql.column_value(c, 6, v_crh_id);
1640: --

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

1633: IF dbms_sql.fetch_rows(c) > 0 THEN
1634: dbms_sql.column_value(c, 1, v_cr_id);
1635: dbms_sql.column_value(c, 2, v_trx_date);
1636: dbms_sql.column_value(c, 3, v_gl_date);
1637: dbms_sql.column_value(c, 4, v_mod_name);
1638: dbms_sql.column_value(c, 5, v_mod_vers);
1639: dbms_sql.column_value(c, 6, v_crh_id);
1640: --
1641: -- Lock rows

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

1634: dbms_sql.column_value(c, 1, v_cr_id);
1635: dbms_sql.column_value(c, 2, v_trx_date);
1636: dbms_sql.column_value(c, 3, v_gl_date);
1637: dbms_sql.column_value(c, 4, v_mod_name);
1638: dbms_sql.column_value(c, 5, v_mod_vers);
1639: dbms_sql.column_value(c, 6, v_crh_id);
1640: --
1641: -- Lock rows
1642: --

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

1635: dbms_sql.column_value(c, 2, v_trx_date);
1636: dbms_sql.column_value(c, 3, v_gl_date);
1637: dbms_sql.column_value(c, 4, v_mod_name);
1638: dbms_sql.column_value(c, 5, v_mod_vers);
1639: dbms_sql.column_value(c, 6, v_crh_id);
1640: --
1641: -- Lock rows
1642: --
1643: BEGIN

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

1667: --
1668: END LOOP;
1669: ELSE
1670: LOOP
1671: IF dbms_sql.fetch_rows(c) > 0 THEN
1672: dbms_sql.column_value(c, 1, v_cr_id);
1673: dbms_sql.column_value(c, 2, v_trx_date);
1674: dbms_sql.column_value(c, 3, v_gl_date);
1675: dbms_sql.column_value(c, 4, v_ex_date);

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

1668: END LOOP;
1669: ELSE
1670: LOOP
1671: IF dbms_sql.fetch_rows(c) > 0 THEN
1672: dbms_sql.column_value(c, 1, v_cr_id);
1673: dbms_sql.column_value(c, 2, v_trx_date);
1674: dbms_sql.column_value(c, 3, v_gl_date);
1675: dbms_sql.column_value(c, 4, v_ex_date);
1676: dbms_sql.column_value(c, 5, v_ex_rate_type);

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

1669: ELSE
1670: LOOP
1671: IF dbms_sql.fetch_rows(c) > 0 THEN
1672: dbms_sql.column_value(c, 1, v_cr_id);
1673: dbms_sql.column_value(c, 2, v_trx_date);
1674: dbms_sql.column_value(c, 3, v_gl_date);
1675: dbms_sql.column_value(c, 4, v_ex_date);
1676: dbms_sql.column_value(c, 5, v_ex_rate_type);
1677: dbms_sql.column_value(c, 6, v_ex_rate);

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

1670: LOOP
1671: IF dbms_sql.fetch_rows(c) > 0 THEN
1672: dbms_sql.column_value(c, 1, v_cr_id);
1673: dbms_sql.column_value(c, 2, v_trx_date);
1674: dbms_sql.column_value(c, 3, v_gl_date);
1675: dbms_sql.column_value(c, 4, v_ex_date);
1676: dbms_sql.column_value(c, 5, v_ex_rate_type);
1677: dbms_sql.column_value(c, 6, v_ex_rate);
1678: dbms_sql.column_value(c, 7, v_currency);

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

1671: IF dbms_sql.fetch_rows(c) > 0 THEN
1672: dbms_sql.column_value(c, 1, v_cr_id);
1673: dbms_sql.column_value(c, 2, v_trx_date);
1674: dbms_sql.column_value(c, 3, v_gl_date);
1675: dbms_sql.column_value(c, 4, v_ex_date);
1676: dbms_sql.column_value(c, 5, v_ex_rate_type);
1677: dbms_sql.column_value(c, 6, v_ex_rate);
1678: dbms_sql.column_value(c, 7, v_currency);
1679: dbms_sql.column_value(c, 8, v_amount);

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

1672: dbms_sql.column_value(c, 1, v_cr_id);
1673: dbms_sql.column_value(c, 2, v_trx_date);
1674: dbms_sql.column_value(c, 3, v_gl_date);
1675: dbms_sql.column_value(c, 4, v_ex_date);
1676: dbms_sql.column_value(c, 5, v_ex_rate_type);
1677: dbms_sql.column_value(c, 6, v_ex_rate);
1678: dbms_sql.column_value(c, 7, v_currency);
1679: dbms_sql.column_value(c, 8, v_amount);
1680: dbms_sql.column_value(c, 9, v_fac_disc_amount);

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

1673: dbms_sql.column_value(c, 2, v_trx_date);
1674: dbms_sql.column_value(c, 3, v_gl_date);
1675: dbms_sql.column_value(c, 4, v_ex_date);
1676: dbms_sql.column_value(c, 5, v_ex_rate_type);
1677: dbms_sql.column_value(c, 6, v_ex_rate);
1678: dbms_sql.column_value(c, 7, v_currency);
1679: dbms_sql.column_value(c, 8, v_amount);
1680: dbms_sql.column_value(c, 9, v_fac_disc_amount);
1681: dbms_sql.column_value(c, 10, v_mod_name);

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

1674: dbms_sql.column_value(c, 3, v_gl_date);
1675: dbms_sql.column_value(c, 4, v_ex_date);
1676: dbms_sql.column_value(c, 5, v_ex_rate_type);
1677: dbms_sql.column_value(c, 6, v_ex_rate);
1678: dbms_sql.column_value(c, 7, v_currency);
1679: dbms_sql.column_value(c, 8, v_amount);
1680: dbms_sql.column_value(c, 9, v_fac_disc_amount);
1681: dbms_sql.column_value(c, 10, v_mod_name);
1682: dbms_sql.column_value(c, 11, v_mod_vers);

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

1675: dbms_sql.column_value(c, 4, v_ex_date);
1676: dbms_sql.column_value(c, 5, v_ex_rate_type);
1677: dbms_sql.column_value(c, 6, v_ex_rate);
1678: dbms_sql.column_value(c, 7, v_currency);
1679: dbms_sql.column_value(c, 8, v_amount);
1680: dbms_sql.column_value(c, 9, v_fac_disc_amount);
1681: dbms_sql.column_value(c, 10, v_mod_name);
1682: dbms_sql.column_value(c, 11, v_mod_vers);
1683: dbms_sql.column_value(c, 12, v_crh_id);

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

1676: dbms_sql.column_value(c, 5, v_ex_rate_type);
1677: dbms_sql.column_value(c, 6, v_ex_rate);
1678: dbms_sql.column_value(c, 7, v_currency);
1679: dbms_sql.column_value(c, 8, v_amount);
1680: dbms_sql.column_value(c, 9, v_fac_disc_amount);
1681: dbms_sql.column_value(c, 10, v_mod_name);
1682: dbms_sql.column_value(c, 11, v_mod_vers);
1683: dbms_sql.column_value(c, 12, v_crh_id);
1684: dbms_sql.column_value(c, 13, v_crh_amount);

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

1677: dbms_sql.column_value(c, 6, v_ex_rate);
1678: dbms_sql.column_value(c, 7, v_currency);
1679: dbms_sql.column_value(c, 8, v_amount);
1680: dbms_sql.column_value(c, 9, v_fac_disc_amount);
1681: dbms_sql.column_value(c, 10, v_mod_name);
1682: dbms_sql.column_value(c, 11, v_mod_vers);
1683: dbms_sql.column_value(c, 12, v_crh_id);
1684: dbms_sql.column_value(c, 13, v_crh_amount);
1685: dbms_sql.column_value(c, 14, v_crh_fac_disc_amt);

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

1678: dbms_sql.column_value(c, 7, v_currency);
1679: dbms_sql.column_value(c, 8, v_amount);
1680: dbms_sql.column_value(c, 9, v_fac_disc_amount);
1681: dbms_sql.column_value(c, 10, v_mod_name);
1682: dbms_sql.column_value(c, 11, v_mod_vers);
1683: dbms_sql.column_value(c, 12, v_crh_id);
1684: dbms_sql.column_value(c, 13, v_crh_amount);
1685: dbms_sql.column_value(c, 14, v_crh_fac_disc_amt);
1686: dbms_sql.column_value(c, 15, v_cr_currency);

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

1679: dbms_sql.column_value(c, 8, v_amount);
1680: dbms_sql.column_value(c, 9, v_fac_disc_amount);
1681: dbms_sql.column_value(c, 10, v_mod_name);
1682: dbms_sql.column_value(c, 11, v_mod_vers);
1683: dbms_sql.column_value(c, 12, v_crh_id);
1684: dbms_sql.column_value(c, 13, v_crh_amount);
1685: dbms_sql.column_value(c, 14, v_crh_fac_disc_amt);
1686: dbms_sql.column_value(c, 15, v_cr_currency);
1687: dbms_sql.column_value(c, 16, v_ex_rate_old);

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

1680: dbms_sql.column_value(c, 9, v_fac_disc_amount);
1681: dbms_sql.column_value(c, 10, v_mod_name);
1682: dbms_sql.column_value(c, 11, v_mod_vers);
1683: dbms_sql.column_value(c, 12, v_crh_id);
1684: dbms_sql.column_value(c, 13, v_crh_amount);
1685: dbms_sql.column_value(c, 14, v_crh_fac_disc_amt);
1686: dbms_sql.column_value(c, 15, v_cr_currency);
1687: dbms_sql.column_value(c, 16, v_ex_rate_old);
1688: --

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

1681: dbms_sql.column_value(c, 10, v_mod_name);
1682: dbms_sql.column_value(c, 11, v_mod_vers);
1683: dbms_sql.column_value(c, 12, v_crh_id);
1684: dbms_sql.column_value(c, 13, v_crh_amount);
1685: dbms_sql.column_value(c, 14, v_crh_fac_disc_amt);
1686: dbms_sql.column_value(c, 15, v_cr_currency);
1687: dbms_sql.column_value(c, 16, v_ex_rate_old);
1688: --
1689: -- Lock rows

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

1682: dbms_sql.column_value(c, 11, v_mod_vers);
1683: dbms_sql.column_value(c, 12, v_crh_id);
1684: dbms_sql.column_value(c, 13, v_crh_amount);
1685: dbms_sql.column_value(c, 14, v_crh_fac_disc_amt);
1686: dbms_sql.column_value(c, 15, v_cr_currency);
1687: dbms_sql.column_value(c, 16, v_ex_rate_old);
1688: --
1689: -- Lock rows
1690: --

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

1683: dbms_sql.column_value(c, 12, v_crh_id);
1684: dbms_sql.column_value(c, 13, v_crh_amount);
1685: dbms_sql.column_value(c, 14, v_crh_fac_disc_amt);
1686: dbms_sql.column_value(c, 15, v_cr_currency);
1687: dbms_sql.column_value(c, 16, v_ex_rate_old);
1688: --
1689: -- Lock rows
1690: --
1691: BEGIN

Line 1789: dbms_sql.close_cursor(c);

1785: END IF;
1786: END LOOP;
1787: END IF;
1788: --
1789: dbms_sql.close_cursor(c);
1790: fnd_file.put_line(fnd_file.log, 'clr_remit_disc_risk_rcpts_pa()-');
1791: --
1792: EXCEPTION
1793: WHEN OTHERS THEN