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.QRM_PA_CALCULATION_P dependencies on DBMS_SQL

Line 511: p_deal_nos DBMS_SQL.NUMBER_TABLE;

507: p_prepaid_interests SYSTEM.QRM_VARCHAR_TABLE;
508: */
509:
510:
511: p_deal_nos DBMS_SQL.NUMBER_TABLE;
512: p_transaction_nos DBMS_SQL.NUMBER_TABLE;
513: p_market_data_sets DBMS_SQL.VARCHAR2_TABLE;
514: p_company_codes DBMS_SQL.VARCHAR2_TABLE;
515: p_calls_or_puts DBMS_SQL.VARCHAR2_TABLE;

Line 512: p_transaction_nos DBMS_SQL.NUMBER_TABLE;

508: */
509:
510:
511: p_deal_nos DBMS_SQL.NUMBER_TABLE;
512: p_transaction_nos DBMS_SQL.NUMBER_TABLE;
513: p_market_data_sets DBMS_SQL.VARCHAR2_TABLE;
514: p_company_codes DBMS_SQL.VARCHAR2_TABLE;
515: p_calls_or_puts DBMS_SQL.VARCHAR2_TABLE;
516: p_pricing_models DBMS_SQL.VARCHAR2_TABLE;

Line 513: p_market_data_sets DBMS_SQL.VARCHAR2_TABLE;

509:
510:
511: p_deal_nos DBMS_SQL.NUMBER_TABLE;
512: p_transaction_nos DBMS_SQL.NUMBER_TABLE;
513: p_market_data_sets DBMS_SQL.VARCHAR2_TABLE;
514: p_company_codes DBMS_SQL.VARCHAR2_TABLE;
515: p_calls_or_puts DBMS_SQL.VARCHAR2_TABLE;
516: p_pricing_models DBMS_SQL.VARCHAR2_TABLE;
517: p_deal_ccys DBMS_SQL.VARCHAR2_TABLE;

Line 514: p_company_codes DBMS_SQL.VARCHAR2_TABLE;

510:
511: p_deal_nos DBMS_SQL.NUMBER_TABLE;
512: p_transaction_nos DBMS_SQL.NUMBER_TABLE;
513: p_market_data_sets DBMS_SQL.VARCHAR2_TABLE;
514: p_company_codes DBMS_SQL.VARCHAR2_TABLE;
515: p_calls_or_puts DBMS_SQL.VARCHAR2_TABLE;
516: p_pricing_models DBMS_SQL.VARCHAR2_TABLE;
517: p_deal_ccys DBMS_SQL.VARCHAR2_TABLE;
518: p_buy_ccys DBMS_SQL.VARCHAR2_TABLE;

Line 515: p_calls_or_puts DBMS_SQL.VARCHAR2_TABLE;

511: p_deal_nos DBMS_SQL.NUMBER_TABLE;
512: p_transaction_nos DBMS_SQL.NUMBER_TABLE;
513: p_market_data_sets DBMS_SQL.VARCHAR2_TABLE;
514: p_company_codes DBMS_SQL.VARCHAR2_TABLE;
515: p_calls_or_puts DBMS_SQL.VARCHAR2_TABLE;
516: p_pricing_models DBMS_SQL.VARCHAR2_TABLE;
517: p_deal_ccys DBMS_SQL.VARCHAR2_TABLE;
518: p_buy_ccys DBMS_SQL.VARCHAR2_TABLE;
519: p_sell_ccys DBMS_SQL.VARCHAR2_TABLE;

Line 516: p_pricing_models DBMS_SQL.VARCHAR2_TABLE;

512: p_transaction_nos DBMS_SQL.NUMBER_TABLE;
513: p_market_data_sets DBMS_SQL.VARCHAR2_TABLE;
514: p_company_codes DBMS_SQL.VARCHAR2_TABLE;
515: p_calls_or_puts DBMS_SQL.VARCHAR2_TABLE;
516: p_pricing_models DBMS_SQL.VARCHAR2_TABLE;
517: p_deal_ccys DBMS_SQL.VARCHAR2_TABLE;
518: p_buy_ccys DBMS_SQL.VARCHAR2_TABLE;
519: p_sell_ccys DBMS_SQL.VARCHAR2_TABLE;
520: p_foreign_ccys DBMS_SQL.VARCHAR2_TABLE;

Line 517: p_deal_ccys DBMS_SQL.VARCHAR2_TABLE;

513: p_market_data_sets DBMS_SQL.VARCHAR2_TABLE;
514: p_company_codes DBMS_SQL.VARCHAR2_TABLE;
515: p_calls_or_puts DBMS_SQL.VARCHAR2_TABLE;
516: p_pricing_models DBMS_SQL.VARCHAR2_TABLE;
517: p_deal_ccys DBMS_SQL.VARCHAR2_TABLE;
518: p_buy_ccys DBMS_SQL.VARCHAR2_TABLE;
519: p_sell_ccys DBMS_SQL.VARCHAR2_TABLE;
520: p_foreign_ccys DBMS_SQL.VARCHAR2_TABLE;
521: p_domestic_ccys DBMS_SQL.VARCHAR2_TABLE;

Line 518: p_buy_ccys DBMS_SQL.VARCHAR2_TABLE;

514: p_company_codes DBMS_SQL.VARCHAR2_TABLE;
515: p_calls_or_puts DBMS_SQL.VARCHAR2_TABLE;
516: p_pricing_models DBMS_SQL.VARCHAR2_TABLE;
517: p_deal_ccys DBMS_SQL.VARCHAR2_TABLE;
518: p_buy_ccys DBMS_SQL.VARCHAR2_TABLE;
519: p_sell_ccys DBMS_SQL.VARCHAR2_TABLE;
520: p_foreign_ccys DBMS_SQL.VARCHAR2_TABLE;
521: p_domestic_ccys DBMS_SQL.VARCHAR2_TABLE;
522: p_base_ccys DBMS_SQL.VARCHAR2_TABLE;

Line 519: p_sell_ccys DBMS_SQL.VARCHAR2_TABLE;

515: p_calls_or_puts DBMS_SQL.VARCHAR2_TABLE;
516: p_pricing_models DBMS_SQL.VARCHAR2_TABLE;
517: p_deal_ccys DBMS_SQL.VARCHAR2_TABLE;
518: p_buy_ccys DBMS_SQL.VARCHAR2_TABLE;
519: p_sell_ccys DBMS_SQL.VARCHAR2_TABLE;
520: p_foreign_ccys DBMS_SQL.VARCHAR2_TABLE;
521: p_domestic_ccys DBMS_SQL.VARCHAR2_TABLE;
522: p_base_ccys DBMS_SQL.VARCHAR2_TABLE;
523: p_contra_ccys DBMS_SQL.VARCHAR2_TABLE;

Line 520: p_foreign_ccys DBMS_SQL.VARCHAR2_TABLE;

516: p_pricing_models DBMS_SQL.VARCHAR2_TABLE;
517: p_deal_ccys DBMS_SQL.VARCHAR2_TABLE;
518: p_buy_ccys DBMS_SQL.VARCHAR2_TABLE;
519: p_sell_ccys DBMS_SQL.VARCHAR2_TABLE;
520: p_foreign_ccys DBMS_SQL.VARCHAR2_TABLE;
521: p_domestic_ccys DBMS_SQL.VARCHAR2_TABLE;
522: p_base_ccys DBMS_SQL.VARCHAR2_TABLE;
523: p_contra_ccys DBMS_SQL.VARCHAR2_TABLE;
524: p_premium_ccys DBMS_SQL.VARCHAR2_TABLE;

Line 521: p_domestic_ccys DBMS_SQL.VARCHAR2_TABLE;

517: p_deal_ccys DBMS_SQL.VARCHAR2_TABLE;
518: p_buy_ccys DBMS_SQL.VARCHAR2_TABLE;
519: p_sell_ccys DBMS_SQL.VARCHAR2_TABLE;
520: p_foreign_ccys DBMS_SQL.VARCHAR2_TABLE;
521: p_domestic_ccys DBMS_SQL.VARCHAR2_TABLE;
522: p_base_ccys DBMS_SQL.VARCHAR2_TABLE;
523: p_contra_ccys DBMS_SQL.VARCHAR2_TABLE;
524: p_premium_ccys DBMS_SQL.VARCHAR2_TABLE;
525: p_buy_amounts DBMS_SQL.NUMBER_TABLE;

Line 522: p_base_ccys DBMS_SQL.VARCHAR2_TABLE;

518: p_buy_ccys DBMS_SQL.VARCHAR2_TABLE;
519: p_sell_ccys DBMS_SQL.VARCHAR2_TABLE;
520: p_foreign_ccys DBMS_SQL.VARCHAR2_TABLE;
521: p_domestic_ccys DBMS_SQL.VARCHAR2_TABLE;
522: p_base_ccys DBMS_SQL.VARCHAR2_TABLE;
523: p_contra_ccys DBMS_SQL.VARCHAR2_TABLE;
524: p_premium_ccys DBMS_SQL.VARCHAR2_TABLE;
525: p_buy_amounts DBMS_SQL.NUMBER_TABLE;
526: p_sell_amounts DBMS_SQL.NUMBER_TABLE;

Line 523: p_contra_ccys DBMS_SQL.VARCHAR2_TABLE;

519: p_sell_ccys DBMS_SQL.VARCHAR2_TABLE;
520: p_foreign_ccys DBMS_SQL.VARCHAR2_TABLE;
521: p_domestic_ccys DBMS_SQL.VARCHAR2_TABLE;
522: p_base_ccys DBMS_SQL.VARCHAR2_TABLE;
523: p_contra_ccys DBMS_SQL.VARCHAR2_TABLE;
524: p_premium_ccys DBMS_SQL.VARCHAR2_TABLE;
525: p_buy_amounts DBMS_SQL.NUMBER_TABLE;
526: p_sell_amounts DBMS_SQL.NUMBER_TABLE;
527: p_foreign_amounts DBMS_SQL.NUMBER_TABLE;

Line 524: p_premium_ccys DBMS_SQL.VARCHAR2_TABLE;

520: p_foreign_ccys DBMS_SQL.VARCHAR2_TABLE;
521: p_domestic_ccys DBMS_SQL.VARCHAR2_TABLE;
522: p_base_ccys DBMS_SQL.VARCHAR2_TABLE;
523: p_contra_ccys DBMS_SQL.VARCHAR2_TABLE;
524: p_premium_ccys DBMS_SQL.VARCHAR2_TABLE;
525: p_buy_amounts DBMS_SQL.NUMBER_TABLE;
526: p_sell_amounts DBMS_SQL.NUMBER_TABLE;
527: p_foreign_amounts DBMS_SQL.NUMBER_TABLE;
528: p_domestic_amounts DBMS_SQL.NUMBER_TABLE;

Line 525: p_buy_amounts DBMS_SQL.NUMBER_TABLE;

521: p_domestic_ccys DBMS_SQL.VARCHAR2_TABLE;
522: p_base_ccys DBMS_SQL.VARCHAR2_TABLE;
523: p_contra_ccys DBMS_SQL.VARCHAR2_TABLE;
524: p_premium_ccys DBMS_SQL.VARCHAR2_TABLE;
525: p_buy_amounts DBMS_SQL.NUMBER_TABLE;
526: p_sell_amounts DBMS_SQL.NUMBER_TABLE;
527: p_foreign_amounts DBMS_SQL.NUMBER_TABLE;
528: p_domestic_amounts DBMS_SQL.NUMBER_TABLE;
529: p_base_amounts DBMS_SQL.NUMBER_TABLE;

Line 526: p_sell_amounts DBMS_SQL.NUMBER_TABLE;

522: p_base_ccys DBMS_SQL.VARCHAR2_TABLE;
523: p_contra_ccys DBMS_SQL.VARCHAR2_TABLE;
524: p_premium_ccys DBMS_SQL.VARCHAR2_TABLE;
525: p_buy_amounts DBMS_SQL.NUMBER_TABLE;
526: p_sell_amounts DBMS_SQL.NUMBER_TABLE;
527: p_foreign_amounts DBMS_SQL.NUMBER_TABLE;
528: p_domestic_amounts DBMS_SQL.NUMBER_TABLE;
529: p_base_amounts DBMS_SQL.NUMBER_TABLE;
530: p_contra_amounts DBMS_SQL.NUMBER_TABLE;

Line 527: p_foreign_amounts DBMS_SQL.NUMBER_TABLE;

523: p_contra_ccys DBMS_SQL.VARCHAR2_TABLE;
524: p_premium_ccys DBMS_SQL.VARCHAR2_TABLE;
525: p_buy_amounts DBMS_SQL.NUMBER_TABLE;
526: p_sell_amounts DBMS_SQL.NUMBER_TABLE;
527: p_foreign_amounts DBMS_SQL.NUMBER_TABLE;
528: p_domestic_amounts DBMS_SQL.NUMBER_TABLE;
529: p_base_amounts DBMS_SQL.NUMBER_TABLE;
530: p_contra_amounts DBMS_SQL.NUMBER_TABLE;
531: p_start_amounts DBMS_SQL.NUMBER_TABLE;

Line 528: p_domestic_amounts DBMS_SQL.NUMBER_TABLE;

524: p_premium_ccys DBMS_SQL.VARCHAR2_TABLE;
525: p_buy_amounts DBMS_SQL.NUMBER_TABLE;
526: p_sell_amounts DBMS_SQL.NUMBER_TABLE;
527: p_foreign_amounts DBMS_SQL.NUMBER_TABLE;
528: p_domestic_amounts DBMS_SQL.NUMBER_TABLE;
529: p_base_amounts DBMS_SQL.NUMBER_TABLE;
530: p_contra_amounts DBMS_SQL.NUMBER_TABLE;
531: p_start_amounts DBMS_SQL.NUMBER_TABLE;
532: p_face_values DBMS_SQL.NUMBER_TABLE;

Line 529: p_base_amounts DBMS_SQL.NUMBER_TABLE;

525: p_buy_amounts DBMS_SQL.NUMBER_TABLE;
526: p_sell_amounts DBMS_SQL.NUMBER_TABLE;
527: p_foreign_amounts DBMS_SQL.NUMBER_TABLE;
528: p_domestic_amounts DBMS_SQL.NUMBER_TABLE;
529: p_base_amounts DBMS_SQL.NUMBER_TABLE;
530: p_contra_amounts DBMS_SQL.NUMBER_TABLE;
531: p_start_amounts DBMS_SQL.NUMBER_TABLE;
532: p_face_values DBMS_SQL.NUMBER_TABLE;
533: p_interests DBMS_SQL.NUMBER_TABLE;

Line 530: p_contra_amounts DBMS_SQL.NUMBER_TABLE;

526: p_sell_amounts DBMS_SQL.NUMBER_TABLE;
527: p_foreign_amounts DBMS_SQL.NUMBER_TABLE;
528: p_domestic_amounts DBMS_SQL.NUMBER_TABLE;
529: p_base_amounts DBMS_SQL.NUMBER_TABLE;
530: p_contra_amounts DBMS_SQL.NUMBER_TABLE;
531: p_start_amounts DBMS_SQL.NUMBER_TABLE;
532: p_face_values DBMS_SQL.NUMBER_TABLE;
533: p_interests DBMS_SQL.NUMBER_TABLE;
534: p_accum_int_bfs DBMS_SQL.NUMBER_TABLE;

Line 531: p_start_amounts DBMS_SQL.NUMBER_TABLE;

527: p_foreign_amounts DBMS_SQL.NUMBER_TABLE;
528: p_domestic_amounts DBMS_SQL.NUMBER_TABLE;
529: p_base_amounts DBMS_SQL.NUMBER_TABLE;
530: p_contra_amounts DBMS_SQL.NUMBER_TABLE;
531: p_start_amounts DBMS_SQL.NUMBER_TABLE;
532: p_face_values DBMS_SQL.NUMBER_TABLE;
533: p_interests DBMS_SQL.NUMBER_TABLE;
534: p_accum_int_bfs DBMS_SQL.NUMBER_TABLE;
535: p_accum_int_actions DBMS_SQL.VARCHAR2_TABLE;

Line 532: p_face_values DBMS_SQL.NUMBER_TABLE;

528: p_domestic_amounts DBMS_SQL.NUMBER_TABLE;
529: p_base_amounts DBMS_SQL.NUMBER_TABLE;
530: p_contra_amounts DBMS_SQL.NUMBER_TABLE;
531: p_start_amounts DBMS_SQL.NUMBER_TABLE;
532: p_face_values DBMS_SQL.NUMBER_TABLE;
533: p_interests DBMS_SQL.NUMBER_TABLE;
534: p_accum_int_bfs DBMS_SQL.NUMBER_TABLE;
535: p_accum_int_actions DBMS_SQL.VARCHAR2_TABLE;
536: p_accrued_interests DBMS_SQL.NUMBER_TABLE;

Line 533: p_interests DBMS_SQL.NUMBER_TABLE;

529: p_base_amounts DBMS_SQL.NUMBER_TABLE;
530: p_contra_amounts DBMS_SQL.NUMBER_TABLE;
531: p_start_amounts DBMS_SQL.NUMBER_TABLE;
532: p_face_values DBMS_SQL.NUMBER_TABLE;
533: p_interests DBMS_SQL.NUMBER_TABLE;
534: p_accum_int_bfs DBMS_SQL.NUMBER_TABLE;
535: p_accum_int_actions DBMS_SQL.VARCHAR2_TABLE;
536: p_accrued_interests DBMS_SQL.NUMBER_TABLE;
537: p_interests_settled DBMS_SQL.NUMBER_TABLE;

Line 534: p_accum_int_bfs DBMS_SQL.NUMBER_TABLE;

530: p_contra_amounts DBMS_SQL.NUMBER_TABLE;
531: p_start_amounts DBMS_SQL.NUMBER_TABLE;
532: p_face_values DBMS_SQL.NUMBER_TABLE;
533: p_interests DBMS_SQL.NUMBER_TABLE;
534: p_accum_int_bfs DBMS_SQL.NUMBER_TABLE;
535: p_accum_int_actions DBMS_SQL.VARCHAR2_TABLE;
536: p_accrued_interests DBMS_SQL.NUMBER_TABLE;
537: p_interests_settled DBMS_SQL.NUMBER_TABLE;
538: p_deal_dates DBMS_SQL.DATE_TABLE;

Line 535: p_accum_int_actions DBMS_SQL.VARCHAR2_TABLE;

531: p_start_amounts DBMS_SQL.NUMBER_TABLE;
532: p_face_values DBMS_SQL.NUMBER_TABLE;
533: p_interests DBMS_SQL.NUMBER_TABLE;
534: p_accum_int_bfs DBMS_SQL.NUMBER_TABLE;
535: p_accum_int_actions DBMS_SQL.VARCHAR2_TABLE;
536: p_accrued_interests DBMS_SQL.NUMBER_TABLE;
537: p_interests_settled DBMS_SQL.NUMBER_TABLE;
538: p_deal_dates DBMS_SQL.DATE_TABLE;
539: p_end_dates DBMS_SQL.DATE_TABLE;

Line 536: p_accrued_interests DBMS_SQL.NUMBER_TABLE;

532: p_face_values DBMS_SQL.NUMBER_TABLE;
533: p_interests DBMS_SQL.NUMBER_TABLE;
534: p_accum_int_bfs DBMS_SQL.NUMBER_TABLE;
535: p_accum_int_actions DBMS_SQL.VARCHAR2_TABLE;
536: p_accrued_interests DBMS_SQL.NUMBER_TABLE;
537: p_interests_settled DBMS_SQL.NUMBER_TABLE;
538: p_deal_dates DBMS_SQL.DATE_TABLE;
539: p_end_dates DBMS_SQL.DATE_TABLE;
540: p_gap_dates DBMS_SQL.DATE_TABLE;

Line 537: p_interests_settled DBMS_SQL.NUMBER_TABLE;

533: p_interests DBMS_SQL.NUMBER_TABLE;
534: p_accum_int_bfs DBMS_SQL.NUMBER_TABLE;
535: p_accum_int_actions DBMS_SQL.VARCHAR2_TABLE;
536: p_accrued_interests DBMS_SQL.NUMBER_TABLE;
537: p_interests_settled DBMS_SQL.NUMBER_TABLE;
538: p_deal_dates DBMS_SQL.DATE_TABLE;
539: p_end_dates DBMS_SQL.DATE_TABLE;
540: p_gap_dates DBMS_SQL.DATE_TABLE;
541: p_deal_subtypes DBMS_SQL.VARCHAR2_TABLE;

Line 538: p_deal_dates DBMS_SQL.DATE_TABLE;

534: p_accum_int_bfs DBMS_SQL.NUMBER_TABLE;
535: p_accum_int_actions DBMS_SQL.VARCHAR2_TABLE;
536: p_accrued_interests DBMS_SQL.NUMBER_TABLE;
537: p_interests_settled DBMS_SQL.NUMBER_TABLE;
538: p_deal_dates DBMS_SQL.DATE_TABLE;
539: p_end_dates DBMS_SQL.DATE_TABLE;
540: p_gap_dates DBMS_SQL.DATE_TABLE;
541: p_deal_subtypes DBMS_SQL.VARCHAR2_TABLE;
542: p_deal_types DBMS_SQL.VARCHAR2_TABLE;

Line 539: p_end_dates DBMS_SQL.DATE_TABLE;

535: p_accum_int_actions DBMS_SQL.VARCHAR2_TABLE;
536: p_accrued_interests DBMS_SQL.NUMBER_TABLE;
537: p_interests_settled DBMS_SQL.NUMBER_TABLE;
538: p_deal_dates DBMS_SQL.DATE_TABLE;
539: p_end_dates DBMS_SQL.DATE_TABLE;
540: p_gap_dates DBMS_SQL.DATE_TABLE;
541: p_deal_subtypes DBMS_SQL.VARCHAR2_TABLE;
542: p_deal_types DBMS_SQL.VARCHAR2_TABLE;
543: p_discount_yields DBMS_SQL.VARCHAR2_TABLE;

Line 540: p_gap_dates DBMS_SQL.DATE_TABLE;

536: p_accrued_interests DBMS_SQL.NUMBER_TABLE;
537: p_interests_settled DBMS_SQL.NUMBER_TABLE;
538: p_deal_dates DBMS_SQL.DATE_TABLE;
539: p_end_dates DBMS_SQL.DATE_TABLE;
540: p_gap_dates DBMS_SQL.DATE_TABLE;
541: p_deal_subtypes DBMS_SQL.VARCHAR2_TABLE;
542: p_deal_types DBMS_SQL.VARCHAR2_TABLE;
543: p_discount_yields DBMS_SQL.VARCHAR2_TABLE;
544: p_maturity_dates DBMS_SQL.DATE_TABLE;

Line 541: p_deal_subtypes DBMS_SQL.VARCHAR2_TABLE;

537: p_interests_settled DBMS_SQL.NUMBER_TABLE;
538: p_deal_dates DBMS_SQL.DATE_TABLE;
539: p_end_dates DBMS_SQL.DATE_TABLE;
540: p_gap_dates DBMS_SQL.DATE_TABLE;
541: p_deal_subtypes DBMS_SQL.VARCHAR2_TABLE;
542: p_deal_types DBMS_SQL.VARCHAR2_TABLE;
543: p_discount_yields DBMS_SQL.VARCHAR2_TABLE;
544: p_maturity_dates DBMS_SQL.DATE_TABLE;
545: p_no_of_days DBMS_SQL.NUMBER_TABLE;

Line 542: p_deal_types DBMS_SQL.VARCHAR2_TABLE;

538: p_deal_dates DBMS_SQL.DATE_TABLE;
539: p_end_dates DBMS_SQL.DATE_TABLE;
540: p_gap_dates DBMS_SQL.DATE_TABLE;
541: p_deal_subtypes DBMS_SQL.VARCHAR2_TABLE;
542: p_deal_types DBMS_SQL.VARCHAR2_TABLE;
543: p_discount_yields DBMS_SQL.VARCHAR2_TABLE;
544: p_maturity_dates DBMS_SQL.DATE_TABLE;
545: p_no_of_days DBMS_SQL.NUMBER_TABLE;
546: p_settle_dates DBMS_SQL.DATE_TABLE;

Line 543: p_discount_yields DBMS_SQL.VARCHAR2_TABLE;

539: p_end_dates DBMS_SQL.DATE_TABLE;
540: p_gap_dates DBMS_SQL.DATE_TABLE;
541: p_deal_subtypes DBMS_SQL.VARCHAR2_TABLE;
542: p_deal_types DBMS_SQL.VARCHAR2_TABLE;
543: p_discount_yields DBMS_SQL.VARCHAR2_TABLE;
544: p_maturity_dates DBMS_SQL.DATE_TABLE;
545: p_no_of_days DBMS_SQL.NUMBER_TABLE;
546: p_settle_dates DBMS_SQL.DATE_TABLE;
547: p_premium_amounts DBMS_SQL.NUMBER_TABLE;

Line 544: p_maturity_dates DBMS_SQL.DATE_TABLE;

540: p_gap_dates DBMS_SQL.DATE_TABLE;
541: p_deal_subtypes DBMS_SQL.VARCHAR2_TABLE;
542: p_deal_types DBMS_SQL.VARCHAR2_TABLE;
543: p_discount_yields DBMS_SQL.VARCHAR2_TABLE;
544: p_maturity_dates DBMS_SQL.DATE_TABLE;
545: p_no_of_days DBMS_SQL.NUMBER_TABLE;
546: p_settle_dates DBMS_SQL.DATE_TABLE;
547: p_premium_amounts DBMS_SQL.NUMBER_TABLE;
548: p_start_dates DBMS_SQL.DATE_TABLE;

Line 545: p_no_of_days DBMS_SQL.NUMBER_TABLE;

541: p_deal_subtypes DBMS_SQL.VARCHAR2_TABLE;
542: p_deal_types DBMS_SQL.VARCHAR2_TABLE;
543: p_discount_yields DBMS_SQL.VARCHAR2_TABLE;
544: p_maturity_dates DBMS_SQL.DATE_TABLE;
545: p_no_of_days DBMS_SQL.NUMBER_TABLE;
546: p_settle_dates DBMS_SQL.DATE_TABLE;
547: p_premium_amounts DBMS_SQL.NUMBER_TABLE;
548: p_start_dates DBMS_SQL.DATE_TABLE;
549: p_initial_bases DBMS_SQL.VARCHAR2_TABLE;

Line 546: p_settle_dates DBMS_SQL.DATE_TABLE;

542: p_deal_types DBMS_SQL.VARCHAR2_TABLE;
543: p_discount_yields DBMS_SQL.VARCHAR2_TABLE;
544: p_maturity_dates DBMS_SQL.DATE_TABLE;
545: p_no_of_days DBMS_SQL.NUMBER_TABLE;
546: p_settle_dates DBMS_SQL.DATE_TABLE;
547: p_premium_amounts DBMS_SQL.NUMBER_TABLE;
548: p_start_dates DBMS_SQL.DATE_TABLE;
549: p_initial_bases DBMS_SQL.VARCHAR2_TABLE;
550: p_bond_issues DBMS_SQL.VARCHAR2_TABLE;

Line 547: p_premium_amounts DBMS_SQL.NUMBER_TABLE;

543: p_discount_yields DBMS_SQL.VARCHAR2_TABLE;
544: p_maturity_dates DBMS_SQL.DATE_TABLE;
545: p_no_of_days DBMS_SQL.NUMBER_TABLE;
546: p_settle_dates DBMS_SQL.DATE_TABLE;
547: p_premium_amounts DBMS_SQL.NUMBER_TABLE;
548: p_start_dates DBMS_SQL.DATE_TABLE;
549: p_initial_bases DBMS_SQL.VARCHAR2_TABLE;
550: p_bond_issues DBMS_SQL.VARCHAR2_TABLE;
551: p_coupon_actions DBMS_SQL.VARCHAR2_TABLE;

Line 548: p_start_dates DBMS_SQL.DATE_TABLE;

544: p_maturity_dates DBMS_SQL.DATE_TABLE;
545: p_no_of_days DBMS_SQL.NUMBER_TABLE;
546: p_settle_dates DBMS_SQL.DATE_TABLE;
547: p_premium_amounts DBMS_SQL.NUMBER_TABLE;
548: p_start_dates DBMS_SQL.DATE_TABLE;
549: p_initial_bases DBMS_SQL.VARCHAR2_TABLE;
550: p_bond_issues DBMS_SQL.VARCHAR2_TABLE;
551: p_coupon_actions DBMS_SQL.VARCHAR2_TABLE;
552: p_coupon_rates DBMS_SQL.NUMBER_TABLE;

Line 549: p_initial_bases DBMS_SQL.VARCHAR2_TABLE;

545: p_no_of_days DBMS_SQL.NUMBER_TABLE;
546: p_settle_dates DBMS_SQL.DATE_TABLE;
547: p_premium_amounts DBMS_SQL.NUMBER_TABLE;
548: p_start_dates DBMS_SQL.DATE_TABLE;
549: p_initial_bases DBMS_SQL.VARCHAR2_TABLE;
550: p_bond_issues DBMS_SQL.VARCHAR2_TABLE;
551: p_coupon_actions DBMS_SQL.VARCHAR2_TABLE;
552: p_coupon_rates DBMS_SQL.NUMBER_TABLE;
553: p_margins DBMS_SQL.NUMBER_TABLE;

Line 550: p_bond_issues DBMS_SQL.VARCHAR2_TABLE;

546: p_settle_dates DBMS_SQL.DATE_TABLE;
547: p_premium_amounts DBMS_SQL.NUMBER_TABLE;
548: p_start_dates DBMS_SQL.DATE_TABLE;
549: p_initial_bases DBMS_SQL.VARCHAR2_TABLE;
550: p_bond_issues DBMS_SQL.VARCHAR2_TABLE;
551: p_coupon_actions DBMS_SQL.VARCHAR2_TABLE;
552: p_coupon_rates DBMS_SQL.NUMBER_TABLE;
553: p_margins DBMS_SQL.NUMBER_TABLE;
554: p_transaction_rates DBMS_SQL.NUMBER_TABLE;

Line 551: p_coupon_actions DBMS_SQL.VARCHAR2_TABLE;

547: p_premium_amounts DBMS_SQL.NUMBER_TABLE;
548: p_start_dates DBMS_SQL.DATE_TABLE;
549: p_initial_bases DBMS_SQL.VARCHAR2_TABLE;
550: p_bond_issues DBMS_SQL.VARCHAR2_TABLE;
551: p_coupon_actions DBMS_SQL.VARCHAR2_TABLE;
552: p_coupon_rates DBMS_SQL.NUMBER_TABLE;
553: p_margins DBMS_SQL.NUMBER_TABLE;
554: p_transaction_rates DBMS_SQL.NUMBER_TABLE;
555: p_coupon_freqs DBMS_SQL.NUMBER_TABLE;

Line 552: p_coupon_rates DBMS_SQL.NUMBER_TABLE;

548: p_start_dates DBMS_SQL.DATE_TABLE;
549: p_initial_bases DBMS_SQL.VARCHAR2_TABLE;
550: p_bond_issues DBMS_SQL.VARCHAR2_TABLE;
551: p_coupon_actions DBMS_SQL.VARCHAR2_TABLE;
552: p_coupon_rates DBMS_SQL.NUMBER_TABLE;
553: p_margins DBMS_SQL.NUMBER_TABLE;
554: p_transaction_rates DBMS_SQL.NUMBER_TABLE;
555: p_coupon_freqs DBMS_SQL.NUMBER_TABLE;
556: p_next_coupon_dates DBMS_SQL.DATE_TABLE;

Line 553: p_margins DBMS_SQL.NUMBER_TABLE;

549: p_initial_bases DBMS_SQL.VARCHAR2_TABLE;
550: p_bond_issues DBMS_SQL.VARCHAR2_TABLE;
551: p_coupon_actions DBMS_SQL.VARCHAR2_TABLE;
552: p_coupon_rates DBMS_SQL.NUMBER_TABLE;
553: p_margins DBMS_SQL.NUMBER_TABLE;
554: p_transaction_rates DBMS_SQL.NUMBER_TABLE;
555: p_coupon_freqs DBMS_SQL.NUMBER_TABLE;
556: p_next_coupon_dates DBMS_SQL.DATE_TABLE;
557: p_day_count_bases DBMS_SQL.VARCHAR2_TABLE;

Line 554: p_transaction_rates DBMS_SQL.NUMBER_TABLE;

550: p_bond_issues DBMS_SQL.VARCHAR2_TABLE;
551: p_coupon_actions DBMS_SQL.VARCHAR2_TABLE;
552: p_coupon_rates DBMS_SQL.NUMBER_TABLE;
553: p_margins DBMS_SQL.NUMBER_TABLE;
554: p_transaction_rates DBMS_SQL.NUMBER_TABLE;
555: p_coupon_freqs DBMS_SQL.NUMBER_TABLE;
556: p_next_coupon_dates DBMS_SQL.DATE_TABLE;
557: p_day_count_bases DBMS_SQL.VARCHAR2_TABLE;
558: -- QUANTITY OUTSTANDING

Line 555: p_coupon_freqs DBMS_SQL.NUMBER_TABLE;

551: p_coupon_actions DBMS_SQL.VARCHAR2_TABLE;
552: p_coupon_rates DBMS_SQL.NUMBER_TABLE;
553: p_margins DBMS_SQL.NUMBER_TABLE;
554: p_transaction_rates DBMS_SQL.NUMBER_TABLE;
555: p_coupon_freqs DBMS_SQL.NUMBER_TABLE;
556: p_next_coupon_dates DBMS_SQL.DATE_TABLE;
557: p_day_count_bases DBMS_SQL.VARCHAR2_TABLE;
558: -- QUANTITY OUTSTANDING
559: p_quantity_out DBMS_SQL.NUMBER_TABLE;

Line 556: p_next_coupon_dates DBMS_SQL.DATE_TABLE;

552: p_coupon_rates DBMS_SQL.NUMBER_TABLE;
553: p_margins DBMS_SQL.NUMBER_TABLE;
554: p_transaction_rates DBMS_SQL.NUMBER_TABLE;
555: p_coupon_freqs DBMS_SQL.NUMBER_TABLE;
556: p_next_coupon_dates DBMS_SQL.DATE_TABLE;
557: p_day_count_bases DBMS_SQL.VARCHAR2_TABLE;
558: -- QUANTITY OUTSTANDING
559: p_quantity_out DBMS_SQL.NUMBER_TABLE;
560: p_rounding_type DBMS_SQL.VARCHAR2_TABLE;

Line 557: p_day_count_bases DBMS_SQL.VARCHAR2_TABLE;

553: p_margins DBMS_SQL.NUMBER_TABLE;
554: p_transaction_rates DBMS_SQL.NUMBER_TABLE;
555: p_coupon_freqs DBMS_SQL.NUMBER_TABLE;
556: p_next_coupon_dates DBMS_SQL.DATE_TABLE;
557: p_day_count_bases DBMS_SQL.VARCHAR2_TABLE;
558: -- QUANTITY OUTSTANDING
559: p_quantity_out DBMS_SQL.NUMBER_TABLE;
560: p_rounding_type DBMS_SQL.VARCHAR2_TABLE;
561: p_day_count_type DBMS_SQL.VARCHAR2_TABLE;

Line 559: p_quantity_out DBMS_SQL.NUMBER_TABLE;

555: p_coupon_freqs DBMS_SQL.NUMBER_TABLE;
556: p_next_coupon_dates DBMS_SQL.DATE_TABLE;
557: p_day_count_bases DBMS_SQL.VARCHAR2_TABLE;
558: -- QUANTITY OUTSTANDING
559: p_quantity_out DBMS_SQL.NUMBER_TABLE;
560: p_rounding_type DBMS_SQL.VARCHAR2_TABLE;
561: p_day_count_type DBMS_SQL.VARCHAR2_TABLE;
562: p_prepaid_interests DBMS_SQL.VARCHAR2_TABLE;
563:

Line 560: p_rounding_type DBMS_SQL.VARCHAR2_TABLE;

556: p_next_coupon_dates DBMS_SQL.DATE_TABLE;
557: p_day_count_bases DBMS_SQL.VARCHAR2_TABLE;
558: -- QUANTITY OUTSTANDING
559: p_quantity_out DBMS_SQL.NUMBER_TABLE;
560: p_rounding_type DBMS_SQL.VARCHAR2_TABLE;
561: p_day_count_type DBMS_SQL.VARCHAR2_TABLE;
562: p_prepaid_interests DBMS_SQL.VARCHAR2_TABLE;
563:
564:

Line 561: p_day_count_type DBMS_SQL.VARCHAR2_TABLE;

557: p_day_count_bases DBMS_SQL.VARCHAR2_TABLE;
558: -- QUANTITY OUTSTANDING
559: p_quantity_out DBMS_SQL.NUMBER_TABLE;
560: p_rounding_type DBMS_SQL.VARCHAR2_TABLE;
561: p_day_count_type DBMS_SQL.VARCHAR2_TABLE;
562: p_prepaid_interests DBMS_SQL.VARCHAR2_TABLE;
563:
564:
565:

Line 562: p_prepaid_interests DBMS_SQL.VARCHAR2_TABLE;

558: -- QUANTITY OUTSTANDING
559: p_quantity_out DBMS_SQL.NUMBER_TABLE;
560: p_rounding_type DBMS_SQL.VARCHAR2_TABLE;
561: p_day_count_type DBMS_SQL.VARCHAR2_TABLE;
562: p_prepaid_interests DBMS_SQL.VARCHAR2_TABLE;
563:
564:
565:
566: -- storage for later insert/update

Line 1255: v_cursor := dbms_sql.open_cursor;

1251: XTR_RISK_DEBUG_PKG.dlog('DML','DELETED QRM_DEALS_ANALYSES',
1252: 'QRM_CALCULATION_P.RUN_ANALYSIS',g_event_level);
1253: END IF;
1254:
1255: v_cursor := dbms_sql.open_cursor;
1256:
1257: p_batch_fetch_size := fnd_profile.value('QRM_ANA_CALC_BATCH_SIZE');
1258:
1259: if (p_batch_fetch_size is null or p_batch_fetch_size < 1) then

Line 1280: dbms_sql.parse(v_cursor,p_select_stmt,dbms_sql.native);

1276:
1277: p_select_stmt := p_select_stmt||p_appended_where||p_filter_where_clause;
1278:
1279: -- BUG 2945198 - sql bind
1280: dbms_sql.parse(v_cursor,p_select_stmt,dbms_sql.native);
1281: dbms_sql.bind_variable(v_cursor,':from_date',p_from_date);
1282: dbms_sql.bind_variable(v_cursor,':p_ref_date',p_ref_date);
1283: dbms_sql.bind_variable(v_cursor,':to_date',p_to_date);
1284: /*

Line 1281: dbms_sql.bind_variable(v_cursor,':from_date',p_from_date);

1277: p_select_stmt := p_select_stmt||p_appended_where||p_filter_where_clause;
1278:
1279: -- BUG 2945198 - sql bind
1280: dbms_sql.parse(v_cursor,p_select_stmt,dbms_sql.native);
1281: dbms_sql.bind_variable(v_cursor,':from_date',p_from_date);
1282: dbms_sql.bind_variable(v_cursor,':p_ref_date',p_ref_date);
1283: dbms_sql.bind_variable(v_cursor,':to_date',p_to_date);
1284: /*
1285: p_select_stmt := 'BEGIN '||p_select_stmt||';END;';

Line 1282: dbms_sql.bind_variable(v_cursor,':p_ref_date',p_ref_date);

1278:
1279: -- BUG 2945198 - sql bind
1280: dbms_sql.parse(v_cursor,p_select_stmt,dbms_sql.native);
1281: dbms_sql.bind_variable(v_cursor,':from_date',p_from_date);
1282: dbms_sql.bind_variable(v_cursor,':p_ref_date',p_ref_date);
1283: dbms_sql.bind_variable(v_cursor,':to_date',p_to_date);
1284: /*
1285: p_select_stmt := 'BEGIN '||p_select_stmt||';END;';
1286:

Line 1283: dbms_sql.bind_variable(v_cursor,':to_date',p_to_date);

1279: -- BUG 2945198 - sql bind
1280: dbms_sql.parse(v_cursor,p_select_stmt,dbms_sql.native);
1281: dbms_sql.bind_variable(v_cursor,':from_date',p_from_date);
1282: dbms_sql.bind_variable(v_cursor,':p_ref_date',p_ref_date);
1283: dbms_sql.bind_variable(v_cursor,':to_date',p_to_date);
1284: /*
1285: p_select_stmt := 'BEGIN '||p_select_stmt||';END;';
1286:
1287: IF (g_proc_level>=g_debug_level) THEN

Line 1335: dbms_sql.parse(v_cursor,p_select_stmt,dbms_sql.native);

1331: OR end_date IS NULL)';
1332: p_select_stmt := p_select_stmt||p_appended_where
1333: ||p_filter_where_clause;
1334: -- BUG 2945198 - sql bind
1335: dbms_sql.parse(v_cursor,p_select_stmt,dbms_sql.native);
1336: dbms_sql.bind_variable(v_cursor,':to_date',p_to_date);
1337: dbms_sql.bind_variable(v_cursor,':from_date',p_from_date);
1338: /*
1339: p_select_stmt := 'BEGIN '||p_select_stmt||';END;';

Line 1336: dbms_sql.bind_variable(v_cursor,':to_date',p_to_date);

1332: p_select_stmt := p_select_stmt||p_appended_where
1333: ||p_filter_where_clause;
1334: -- BUG 2945198 - sql bind
1335: dbms_sql.parse(v_cursor,p_select_stmt,dbms_sql.native);
1336: dbms_sql.bind_variable(v_cursor,':to_date',p_to_date);
1337: dbms_sql.bind_variable(v_cursor,':from_date',p_from_date);
1338: /*
1339: p_select_stmt := 'BEGIN '||p_select_stmt||';END;';
1340:

Line 1337: dbms_sql.bind_variable(v_cursor,':from_date',p_from_date);

1333: ||p_filter_where_clause;
1334: -- BUG 2945198 - sql bind
1335: dbms_sql.parse(v_cursor,p_select_stmt,dbms_sql.native);
1336: dbms_sql.bind_variable(v_cursor,':to_date',p_to_date);
1337: dbms_sql.bind_variable(v_cursor,':from_date',p_from_date);
1338: /*
1339: p_select_stmt := 'BEGIN '||p_select_stmt||';END;';
1340:
1341: IF (g_proc_level>=g_debug_level) THEN

Line 1373: dbms_sql.parse(v_cursor,p_select_stmt,dbms_sql.native);

1369: OR end_date IS NULL)';
1370: p_select_stmt := p_select_stmt||p_appended_where
1371: ||p_filter_where_clause;
1372: -- BUG 2945198 - sql bind
1373: dbms_sql.parse(v_cursor,p_select_stmt,dbms_sql.native);
1374: dbms_sql.bind_variable(v_cursor,':to_date',p_to_date);
1375: /*
1376: p_select_stmt := 'BEGIN '||p_select_stmt||';END;';
1377:

Line 1374: dbms_sql.bind_variable(v_cursor,':to_date',p_to_date);

1370: p_select_stmt := p_select_stmt||p_appended_where
1371: ||p_filter_where_clause;
1372: -- BUG 2945198 - sql bind
1373: dbms_sql.parse(v_cursor,p_select_stmt,dbms_sql.native);
1374: dbms_sql.bind_variable(v_cursor,':to_date',p_to_date);
1375: /*
1376: p_select_stmt := 'BEGIN '||p_select_stmt||';END;';
1377:
1378: IF (g_proc_level>=g_debug_level) THEN

Line 1425: dbms_sql.parse(v_cursor,p_select_stmt,dbms_sql.native);

1421: -- cannot filter based on gap date, since haven't calculated yet
1422: p_appended_where := p_appended_where ||' AND DEAL_TYPE <> ''STOCK''';
1423: p_select_stmt := p_select_stmt||p_appended_where||p_filter_where_clause;
1424: -- BUG 2945198 - sql bind
1425: dbms_sql.parse(v_cursor,p_select_stmt,dbms_sql.native);
1426: /*
1427: p_select_stmt := 'BEGIN '||p_select_stmt||';END;';
1428:
1429: IF (g_proc_level>=g_debug_level) THEN

Line 1469: dbms_sql.bind_variable(v_cursor,':'||to_char(p_filter_bindings.row_number),p_filter_bindings.value);

1465: XTR_RISK_DEBUG_PKG.dlog('run_analysis: ' || 'select stmt: ', p_select_stmt);
1466: END IF;
1467:
1468: for p_filter_bindings in get_filter_bindings(p_settings.filter_name) loop
1469: dbms_sql.bind_variable(v_cursor,':'||to_char(p_filter_bindings.row_number),p_filter_bindings.value);
1470: end loop;
1471:
1472: n_num_rows_fetched := dbms_sql.execute(v_cursor);
1473:

Line 1472: n_num_rows_fetched := dbms_sql.execute(v_cursor);

1468: for p_filter_bindings in get_filter_bindings(p_settings.filter_name) loop
1469: dbms_sql.bind_variable(v_cursor,':'||to_char(p_filter_bindings.row_number),p_filter_bindings.value);
1470: end loop;
1471:
1472: n_num_rows_fetched := dbms_sql.execute(v_cursor);
1473:
1474: loop
1475:
1476: dbms_sql.define_array(v_cursor, 1, p_deal_nos, p_batch_fetch_size, p_batch_start_index);

Line 1476: dbms_sql.define_array(v_cursor, 1, p_deal_nos, p_batch_fetch_size, p_batch_start_index);

1472: n_num_rows_fetched := dbms_sql.execute(v_cursor);
1473:
1474: loop
1475:
1476: dbms_sql.define_array(v_cursor, 1, p_deal_nos, p_batch_fetch_size, p_batch_start_index);
1477: dbms_sql.define_array(v_cursor, 2, p_transaction_nos, p_batch_fetch_size, p_batch_start_index);
1478: dbms_sql.define_array(v_cursor, 3, p_market_data_sets, p_batch_fetch_size, p_batch_start_index);
1479: dbms_sql.define_array(v_cursor, 4, p_company_codes, p_batch_fetch_size, p_batch_start_index);
1480: dbms_sql.define_array(v_cursor, 5, p_calls_or_puts, p_batch_fetch_size, p_batch_start_index);

Line 1477: dbms_sql.define_array(v_cursor, 2, p_transaction_nos, p_batch_fetch_size, p_batch_start_index);

1473:
1474: loop
1475:
1476: dbms_sql.define_array(v_cursor, 1, p_deal_nos, p_batch_fetch_size, p_batch_start_index);
1477: dbms_sql.define_array(v_cursor, 2, p_transaction_nos, p_batch_fetch_size, p_batch_start_index);
1478: dbms_sql.define_array(v_cursor, 3, p_market_data_sets, p_batch_fetch_size, p_batch_start_index);
1479: dbms_sql.define_array(v_cursor, 4, p_company_codes, p_batch_fetch_size, p_batch_start_index);
1480: dbms_sql.define_array(v_cursor, 5, p_calls_or_puts, p_batch_fetch_size, p_batch_start_index);
1481: dbms_sql.define_array(v_cursor, 6, p_pricing_models, p_batch_fetch_size, p_batch_start_index);

Line 1478: dbms_sql.define_array(v_cursor, 3, p_market_data_sets, p_batch_fetch_size, p_batch_start_index);

1474: loop
1475:
1476: dbms_sql.define_array(v_cursor, 1, p_deal_nos, p_batch_fetch_size, p_batch_start_index);
1477: dbms_sql.define_array(v_cursor, 2, p_transaction_nos, p_batch_fetch_size, p_batch_start_index);
1478: dbms_sql.define_array(v_cursor, 3, p_market_data_sets, p_batch_fetch_size, p_batch_start_index);
1479: dbms_sql.define_array(v_cursor, 4, p_company_codes, p_batch_fetch_size, p_batch_start_index);
1480: dbms_sql.define_array(v_cursor, 5, p_calls_or_puts, p_batch_fetch_size, p_batch_start_index);
1481: dbms_sql.define_array(v_cursor, 6, p_pricing_models, p_batch_fetch_size, p_batch_start_index);
1482: dbms_sql.define_array(v_cursor, 7, p_deal_ccys, p_batch_fetch_size, p_batch_start_index);

Line 1479: dbms_sql.define_array(v_cursor, 4, p_company_codes, p_batch_fetch_size, p_batch_start_index);

1475:
1476: dbms_sql.define_array(v_cursor, 1, p_deal_nos, p_batch_fetch_size, p_batch_start_index);
1477: dbms_sql.define_array(v_cursor, 2, p_transaction_nos, p_batch_fetch_size, p_batch_start_index);
1478: dbms_sql.define_array(v_cursor, 3, p_market_data_sets, p_batch_fetch_size, p_batch_start_index);
1479: dbms_sql.define_array(v_cursor, 4, p_company_codes, p_batch_fetch_size, p_batch_start_index);
1480: dbms_sql.define_array(v_cursor, 5, p_calls_or_puts, p_batch_fetch_size, p_batch_start_index);
1481: dbms_sql.define_array(v_cursor, 6, p_pricing_models, p_batch_fetch_size, p_batch_start_index);
1482: dbms_sql.define_array(v_cursor, 7, p_deal_ccys, p_batch_fetch_size, p_batch_start_index);
1483: dbms_sql.define_array(v_cursor, 8, p_buy_ccys, p_batch_fetch_size, p_batch_start_index);

Line 1480: dbms_sql.define_array(v_cursor, 5, p_calls_or_puts, p_batch_fetch_size, p_batch_start_index);

1476: dbms_sql.define_array(v_cursor, 1, p_deal_nos, p_batch_fetch_size, p_batch_start_index);
1477: dbms_sql.define_array(v_cursor, 2, p_transaction_nos, p_batch_fetch_size, p_batch_start_index);
1478: dbms_sql.define_array(v_cursor, 3, p_market_data_sets, p_batch_fetch_size, p_batch_start_index);
1479: dbms_sql.define_array(v_cursor, 4, p_company_codes, p_batch_fetch_size, p_batch_start_index);
1480: dbms_sql.define_array(v_cursor, 5, p_calls_or_puts, p_batch_fetch_size, p_batch_start_index);
1481: dbms_sql.define_array(v_cursor, 6, p_pricing_models, p_batch_fetch_size, p_batch_start_index);
1482: dbms_sql.define_array(v_cursor, 7, p_deal_ccys, p_batch_fetch_size, p_batch_start_index);
1483: dbms_sql.define_array(v_cursor, 8, p_buy_ccys, p_batch_fetch_size, p_batch_start_index);
1484: dbms_sql.define_array(v_cursor, 9, p_sell_ccys, p_batch_fetch_size, p_batch_start_index);

Line 1481: dbms_sql.define_array(v_cursor, 6, p_pricing_models, p_batch_fetch_size, p_batch_start_index);

1477: dbms_sql.define_array(v_cursor, 2, p_transaction_nos, p_batch_fetch_size, p_batch_start_index);
1478: dbms_sql.define_array(v_cursor, 3, p_market_data_sets, p_batch_fetch_size, p_batch_start_index);
1479: dbms_sql.define_array(v_cursor, 4, p_company_codes, p_batch_fetch_size, p_batch_start_index);
1480: dbms_sql.define_array(v_cursor, 5, p_calls_or_puts, p_batch_fetch_size, p_batch_start_index);
1481: dbms_sql.define_array(v_cursor, 6, p_pricing_models, p_batch_fetch_size, p_batch_start_index);
1482: dbms_sql.define_array(v_cursor, 7, p_deal_ccys, p_batch_fetch_size, p_batch_start_index);
1483: dbms_sql.define_array(v_cursor, 8, p_buy_ccys, p_batch_fetch_size, p_batch_start_index);
1484: dbms_sql.define_array(v_cursor, 9, p_sell_ccys, p_batch_fetch_size, p_batch_start_index);
1485: dbms_sql.define_array(v_cursor, 10, p_foreign_ccys, p_batch_fetch_size, p_batch_start_index);

Line 1482: dbms_sql.define_array(v_cursor, 7, p_deal_ccys, p_batch_fetch_size, p_batch_start_index);

1478: dbms_sql.define_array(v_cursor, 3, p_market_data_sets, p_batch_fetch_size, p_batch_start_index);
1479: dbms_sql.define_array(v_cursor, 4, p_company_codes, p_batch_fetch_size, p_batch_start_index);
1480: dbms_sql.define_array(v_cursor, 5, p_calls_or_puts, p_batch_fetch_size, p_batch_start_index);
1481: dbms_sql.define_array(v_cursor, 6, p_pricing_models, p_batch_fetch_size, p_batch_start_index);
1482: dbms_sql.define_array(v_cursor, 7, p_deal_ccys, p_batch_fetch_size, p_batch_start_index);
1483: dbms_sql.define_array(v_cursor, 8, p_buy_ccys, p_batch_fetch_size, p_batch_start_index);
1484: dbms_sql.define_array(v_cursor, 9, p_sell_ccys, p_batch_fetch_size, p_batch_start_index);
1485: dbms_sql.define_array(v_cursor, 10, p_foreign_ccys, p_batch_fetch_size, p_batch_start_index);
1486: dbms_sql.define_array(v_cursor, 11, p_domestic_ccys, p_batch_fetch_size, p_batch_start_index);

Line 1483: dbms_sql.define_array(v_cursor, 8, p_buy_ccys, p_batch_fetch_size, p_batch_start_index);

1479: dbms_sql.define_array(v_cursor, 4, p_company_codes, p_batch_fetch_size, p_batch_start_index);
1480: dbms_sql.define_array(v_cursor, 5, p_calls_or_puts, p_batch_fetch_size, p_batch_start_index);
1481: dbms_sql.define_array(v_cursor, 6, p_pricing_models, p_batch_fetch_size, p_batch_start_index);
1482: dbms_sql.define_array(v_cursor, 7, p_deal_ccys, p_batch_fetch_size, p_batch_start_index);
1483: dbms_sql.define_array(v_cursor, 8, p_buy_ccys, p_batch_fetch_size, p_batch_start_index);
1484: dbms_sql.define_array(v_cursor, 9, p_sell_ccys, p_batch_fetch_size, p_batch_start_index);
1485: dbms_sql.define_array(v_cursor, 10, p_foreign_ccys, p_batch_fetch_size, p_batch_start_index);
1486: dbms_sql.define_array(v_cursor, 11, p_domestic_ccys, p_batch_fetch_size, p_batch_start_index);
1487: dbms_sql.define_array(v_cursor, 12, p_base_ccys, p_batch_fetch_size, p_batch_start_index);

Line 1484: dbms_sql.define_array(v_cursor, 9, p_sell_ccys, p_batch_fetch_size, p_batch_start_index);

1480: dbms_sql.define_array(v_cursor, 5, p_calls_or_puts, p_batch_fetch_size, p_batch_start_index);
1481: dbms_sql.define_array(v_cursor, 6, p_pricing_models, p_batch_fetch_size, p_batch_start_index);
1482: dbms_sql.define_array(v_cursor, 7, p_deal_ccys, p_batch_fetch_size, p_batch_start_index);
1483: dbms_sql.define_array(v_cursor, 8, p_buy_ccys, p_batch_fetch_size, p_batch_start_index);
1484: dbms_sql.define_array(v_cursor, 9, p_sell_ccys, p_batch_fetch_size, p_batch_start_index);
1485: dbms_sql.define_array(v_cursor, 10, p_foreign_ccys, p_batch_fetch_size, p_batch_start_index);
1486: dbms_sql.define_array(v_cursor, 11, p_domestic_ccys, p_batch_fetch_size, p_batch_start_index);
1487: dbms_sql.define_array(v_cursor, 12, p_base_ccys, p_batch_fetch_size, p_batch_start_index);
1488: dbms_sql.define_array(v_cursor, 13, p_contra_ccys, p_batch_fetch_size, p_batch_start_index);

Line 1485: dbms_sql.define_array(v_cursor, 10, p_foreign_ccys, p_batch_fetch_size, p_batch_start_index);

1481: dbms_sql.define_array(v_cursor, 6, p_pricing_models, p_batch_fetch_size, p_batch_start_index);
1482: dbms_sql.define_array(v_cursor, 7, p_deal_ccys, p_batch_fetch_size, p_batch_start_index);
1483: dbms_sql.define_array(v_cursor, 8, p_buy_ccys, p_batch_fetch_size, p_batch_start_index);
1484: dbms_sql.define_array(v_cursor, 9, p_sell_ccys, p_batch_fetch_size, p_batch_start_index);
1485: dbms_sql.define_array(v_cursor, 10, p_foreign_ccys, p_batch_fetch_size, p_batch_start_index);
1486: dbms_sql.define_array(v_cursor, 11, p_domestic_ccys, p_batch_fetch_size, p_batch_start_index);
1487: dbms_sql.define_array(v_cursor, 12, p_base_ccys, p_batch_fetch_size, p_batch_start_index);
1488: dbms_sql.define_array(v_cursor, 13, p_contra_ccys, p_batch_fetch_size, p_batch_start_index);
1489: dbms_sql.define_array(v_cursor, 14, p_premium_ccys, p_batch_fetch_size, p_batch_start_index);

Line 1486: dbms_sql.define_array(v_cursor, 11, p_domestic_ccys, p_batch_fetch_size, p_batch_start_index);

1482: dbms_sql.define_array(v_cursor, 7, p_deal_ccys, p_batch_fetch_size, p_batch_start_index);
1483: dbms_sql.define_array(v_cursor, 8, p_buy_ccys, p_batch_fetch_size, p_batch_start_index);
1484: dbms_sql.define_array(v_cursor, 9, p_sell_ccys, p_batch_fetch_size, p_batch_start_index);
1485: dbms_sql.define_array(v_cursor, 10, p_foreign_ccys, p_batch_fetch_size, p_batch_start_index);
1486: dbms_sql.define_array(v_cursor, 11, p_domestic_ccys, p_batch_fetch_size, p_batch_start_index);
1487: dbms_sql.define_array(v_cursor, 12, p_base_ccys, p_batch_fetch_size, p_batch_start_index);
1488: dbms_sql.define_array(v_cursor, 13, p_contra_ccys, p_batch_fetch_size, p_batch_start_index);
1489: dbms_sql.define_array(v_cursor, 14, p_premium_ccys, p_batch_fetch_size, p_batch_start_index);
1490: dbms_sql.define_array(v_cursor, 15, p_buy_amounts, p_batch_fetch_size, p_batch_start_index);

Line 1487: dbms_sql.define_array(v_cursor, 12, p_base_ccys, p_batch_fetch_size, p_batch_start_index);

1483: dbms_sql.define_array(v_cursor, 8, p_buy_ccys, p_batch_fetch_size, p_batch_start_index);
1484: dbms_sql.define_array(v_cursor, 9, p_sell_ccys, p_batch_fetch_size, p_batch_start_index);
1485: dbms_sql.define_array(v_cursor, 10, p_foreign_ccys, p_batch_fetch_size, p_batch_start_index);
1486: dbms_sql.define_array(v_cursor, 11, p_domestic_ccys, p_batch_fetch_size, p_batch_start_index);
1487: dbms_sql.define_array(v_cursor, 12, p_base_ccys, p_batch_fetch_size, p_batch_start_index);
1488: dbms_sql.define_array(v_cursor, 13, p_contra_ccys, p_batch_fetch_size, p_batch_start_index);
1489: dbms_sql.define_array(v_cursor, 14, p_premium_ccys, p_batch_fetch_size, p_batch_start_index);
1490: dbms_sql.define_array(v_cursor, 15, p_buy_amounts, p_batch_fetch_size, p_batch_start_index);
1491: dbms_sql.define_array(v_cursor, 16, p_sell_amounts, p_batch_fetch_size, p_batch_start_index);

Line 1488: dbms_sql.define_array(v_cursor, 13, p_contra_ccys, p_batch_fetch_size, p_batch_start_index);

1484: dbms_sql.define_array(v_cursor, 9, p_sell_ccys, p_batch_fetch_size, p_batch_start_index);
1485: dbms_sql.define_array(v_cursor, 10, p_foreign_ccys, p_batch_fetch_size, p_batch_start_index);
1486: dbms_sql.define_array(v_cursor, 11, p_domestic_ccys, p_batch_fetch_size, p_batch_start_index);
1487: dbms_sql.define_array(v_cursor, 12, p_base_ccys, p_batch_fetch_size, p_batch_start_index);
1488: dbms_sql.define_array(v_cursor, 13, p_contra_ccys, p_batch_fetch_size, p_batch_start_index);
1489: dbms_sql.define_array(v_cursor, 14, p_premium_ccys, p_batch_fetch_size, p_batch_start_index);
1490: dbms_sql.define_array(v_cursor, 15, p_buy_amounts, p_batch_fetch_size, p_batch_start_index);
1491: dbms_sql.define_array(v_cursor, 16, p_sell_amounts, p_batch_fetch_size, p_batch_start_index);
1492: dbms_sql.define_array(v_cursor, 17, p_foreign_amounts, p_batch_fetch_size, p_batch_start_index);

Line 1489: dbms_sql.define_array(v_cursor, 14, p_premium_ccys, p_batch_fetch_size, p_batch_start_index);

1485: dbms_sql.define_array(v_cursor, 10, p_foreign_ccys, p_batch_fetch_size, p_batch_start_index);
1486: dbms_sql.define_array(v_cursor, 11, p_domestic_ccys, p_batch_fetch_size, p_batch_start_index);
1487: dbms_sql.define_array(v_cursor, 12, p_base_ccys, p_batch_fetch_size, p_batch_start_index);
1488: dbms_sql.define_array(v_cursor, 13, p_contra_ccys, p_batch_fetch_size, p_batch_start_index);
1489: dbms_sql.define_array(v_cursor, 14, p_premium_ccys, p_batch_fetch_size, p_batch_start_index);
1490: dbms_sql.define_array(v_cursor, 15, p_buy_amounts, p_batch_fetch_size, p_batch_start_index);
1491: dbms_sql.define_array(v_cursor, 16, p_sell_amounts, p_batch_fetch_size, p_batch_start_index);
1492: dbms_sql.define_array(v_cursor, 17, p_foreign_amounts, p_batch_fetch_size, p_batch_start_index);
1493: dbms_sql.define_array(v_cursor, 18, p_domestic_amounts, p_batch_fetch_size, p_batch_start_index);

Line 1490: dbms_sql.define_array(v_cursor, 15, p_buy_amounts, p_batch_fetch_size, p_batch_start_index);

1486: dbms_sql.define_array(v_cursor, 11, p_domestic_ccys, p_batch_fetch_size, p_batch_start_index);
1487: dbms_sql.define_array(v_cursor, 12, p_base_ccys, p_batch_fetch_size, p_batch_start_index);
1488: dbms_sql.define_array(v_cursor, 13, p_contra_ccys, p_batch_fetch_size, p_batch_start_index);
1489: dbms_sql.define_array(v_cursor, 14, p_premium_ccys, p_batch_fetch_size, p_batch_start_index);
1490: dbms_sql.define_array(v_cursor, 15, p_buy_amounts, p_batch_fetch_size, p_batch_start_index);
1491: dbms_sql.define_array(v_cursor, 16, p_sell_amounts, p_batch_fetch_size, p_batch_start_index);
1492: dbms_sql.define_array(v_cursor, 17, p_foreign_amounts, p_batch_fetch_size, p_batch_start_index);
1493: dbms_sql.define_array(v_cursor, 18, p_domestic_amounts, p_batch_fetch_size, p_batch_start_index);
1494: dbms_sql.define_array(v_cursor, 19, p_base_amounts, p_batch_fetch_size, p_batch_start_index);

Line 1491: dbms_sql.define_array(v_cursor, 16, p_sell_amounts, p_batch_fetch_size, p_batch_start_index);

1487: dbms_sql.define_array(v_cursor, 12, p_base_ccys, p_batch_fetch_size, p_batch_start_index);
1488: dbms_sql.define_array(v_cursor, 13, p_contra_ccys, p_batch_fetch_size, p_batch_start_index);
1489: dbms_sql.define_array(v_cursor, 14, p_premium_ccys, p_batch_fetch_size, p_batch_start_index);
1490: dbms_sql.define_array(v_cursor, 15, p_buy_amounts, p_batch_fetch_size, p_batch_start_index);
1491: dbms_sql.define_array(v_cursor, 16, p_sell_amounts, p_batch_fetch_size, p_batch_start_index);
1492: dbms_sql.define_array(v_cursor, 17, p_foreign_amounts, p_batch_fetch_size, p_batch_start_index);
1493: dbms_sql.define_array(v_cursor, 18, p_domestic_amounts, p_batch_fetch_size, p_batch_start_index);
1494: dbms_sql.define_array(v_cursor, 19, p_base_amounts, p_batch_fetch_size, p_batch_start_index);
1495: dbms_sql.define_array(v_cursor, 20, p_contra_amounts, p_batch_fetch_size, p_batch_start_index);

Line 1492: dbms_sql.define_array(v_cursor, 17, p_foreign_amounts, p_batch_fetch_size, p_batch_start_index);

1488: dbms_sql.define_array(v_cursor, 13, p_contra_ccys, p_batch_fetch_size, p_batch_start_index);
1489: dbms_sql.define_array(v_cursor, 14, p_premium_ccys, p_batch_fetch_size, p_batch_start_index);
1490: dbms_sql.define_array(v_cursor, 15, p_buy_amounts, p_batch_fetch_size, p_batch_start_index);
1491: dbms_sql.define_array(v_cursor, 16, p_sell_amounts, p_batch_fetch_size, p_batch_start_index);
1492: dbms_sql.define_array(v_cursor, 17, p_foreign_amounts, p_batch_fetch_size, p_batch_start_index);
1493: dbms_sql.define_array(v_cursor, 18, p_domestic_amounts, p_batch_fetch_size, p_batch_start_index);
1494: dbms_sql.define_array(v_cursor, 19, p_base_amounts, p_batch_fetch_size, p_batch_start_index);
1495: dbms_sql.define_array(v_cursor, 20, p_contra_amounts, p_batch_fetch_size, p_batch_start_index);
1496: dbms_sql.define_array(v_cursor, 21, p_start_amounts, p_batch_fetch_size, p_batch_start_index);

Line 1493: dbms_sql.define_array(v_cursor, 18, p_domestic_amounts, p_batch_fetch_size, p_batch_start_index);

1489: dbms_sql.define_array(v_cursor, 14, p_premium_ccys, p_batch_fetch_size, p_batch_start_index);
1490: dbms_sql.define_array(v_cursor, 15, p_buy_amounts, p_batch_fetch_size, p_batch_start_index);
1491: dbms_sql.define_array(v_cursor, 16, p_sell_amounts, p_batch_fetch_size, p_batch_start_index);
1492: dbms_sql.define_array(v_cursor, 17, p_foreign_amounts, p_batch_fetch_size, p_batch_start_index);
1493: dbms_sql.define_array(v_cursor, 18, p_domestic_amounts, p_batch_fetch_size, p_batch_start_index);
1494: dbms_sql.define_array(v_cursor, 19, p_base_amounts, p_batch_fetch_size, p_batch_start_index);
1495: dbms_sql.define_array(v_cursor, 20, p_contra_amounts, p_batch_fetch_size, p_batch_start_index);
1496: dbms_sql.define_array(v_cursor, 21, p_start_amounts, p_batch_fetch_size, p_batch_start_index);
1497: dbms_sql.define_array(v_cursor, 22, p_face_values, p_batch_fetch_size, p_batch_start_index);

Line 1494: dbms_sql.define_array(v_cursor, 19, p_base_amounts, p_batch_fetch_size, p_batch_start_index);

1490: dbms_sql.define_array(v_cursor, 15, p_buy_amounts, p_batch_fetch_size, p_batch_start_index);
1491: dbms_sql.define_array(v_cursor, 16, p_sell_amounts, p_batch_fetch_size, p_batch_start_index);
1492: dbms_sql.define_array(v_cursor, 17, p_foreign_amounts, p_batch_fetch_size, p_batch_start_index);
1493: dbms_sql.define_array(v_cursor, 18, p_domestic_amounts, p_batch_fetch_size, p_batch_start_index);
1494: dbms_sql.define_array(v_cursor, 19, p_base_amounts, p_batch_fetch_size, p_batch_start_index);
1495: dbms_sql.define_array(v_cursor, 20, p_contra_amounts, p_batch_fetch_size, p_batch_start_index);
1496: dbms_sql.define_array(v_cursor, 21, p_start_amounts, p_batch_fetch_size, p_batch_start_index);
1497: dbms_sql.define_array(v_cursor, 22, p_face_values, p_batch_fetch_size, p_batch_start_index);
1498: dbms_sql.define_array(v_cursor, 23, p_interests, p_batch_fetch_size, p_batch_start_index);

Line 1495: dbms_sql.define_array(v_cursor, 20, p_contra_amounts, p_batch_fetch_size, p_batch_start_index);

1491: dbms_sql.define_array(v_cursor, 16, p_sell_amounts, p_batch_fetch_size, p_batch_start_index);
1492: dbms_sql.define_array(v_cursor, 17, p_foreign_amounts, p_batch_fetch_size, p_batch_start_index);
1493: dbms_sql.define_array(v_cursor, 18, p_domestic_amounts, p_batch_fetch_size, p_batch_start_index);
1494: dbms_sql.define_array(v_cursor, 19, p_base_amounts, p_batch_fetch_size, p_batch_start_index);
1495: dbms_sql.define_array(v_cursor, 20, p_contra_amounts, p_batch_fetch_size, p_batch_start_index);
1496: dbms_sql.define_array(v_cursor, 21, p_start_amounts, p_batch_fetch_size, p_batch_start_index);
1497: dbms_sql.define_array(v_cursor, 22, p_face_values, p_batch_fetch_size, p_batch_start_index);
1498: dbms_sql.define_array(v_cursor, 23, p_interests, p_batch_fetch_size, p_batch_start_index);
1499: dbms_sql.define_array(v_cursor, 24, p_accum_int_bfs, p_batch_fetch_size, p_batch_start_index);

Line 1496: dbms_sql.define_array(v_cursor, 21, p_start_amounts, p_batch_fetch_size, p_batch_start_index);

1492: dbms_sql.define_array(v_cursor, 17, p_foreign_amounts, p_batch_fetch_size, p_batch_start_index);
1493: dbms_sql.define_array(v_cursor, 18, p_domestic_amounts, p_batch_fetch_size, p_batch_start_index);
1494: dbms_sql.define_array(v_cursor, 19, p_base_amounts, p_batch_fetch_size, p_batch_start_index);
1495: dbms_sql.define_array(v_cursor, 20, p_contra_amounts, p_batch_fetch_size, p_batch_start_index);
1496: dbms_sql.define_array(v_cursor, 21, p_start_amounts, p_batch_fetch_size, p_batch_start_index);
1497: dbms_sql.define_array(v_cursor, 22, p_face_values, p_batch_fetch_size, p_batch_start_index);
1498: dbms_sql.define_array(v_cursor, 23, p_interests, p_batch_fetch_size, p_batch_start_index);
1499: dbms_sql.define_array(v_cursor, 24, p_accum_int_bfs, p_batch_fetch_size, p_batch_start_index);
1500: dbms_sql.define_array(v_cursor, 25, p_accum_int_actions, p_batch_fetch_size, p_batch_start_index);

Line 1497: dbms_sql.define_array(v_cursor, 22, p_face_values, p_batch_fetch_size, p_batch_start_index);

1493: dbms_sql.define_array(v_cursor, 18, p_domestic_amounts, p_batch_fetch_size, p_batch_start_index);
1494: dbms_sql.define_array(v_cursor, 19, p_base_amounts, p_batch_fetch_size, p_batch_start_index);
1495: dbms_sql.define_array(v_cursor, 20, p_contra_amounts, p_batch_fetch_size, p_batch_start_index);
1496: dbms_sql.define_array(v_cursor, 21, p_start_amounts, p_batch_fetch_size, p_batch_start_index);
1497: dbms_sql.define_array(v_cursor, 22, p_face_values, p_batch_fetch_size, p_batch_start_index);
1498: dbms_sql.define_array(v_cursor, 23, p_interests, p_batch_fetch_size, p_batch_start_index);
1499: dbms_sql.define_array(v_cursor, 24, p_accum_int_bfs, p_batch_fetch_size, p_batch_start_index);
1500: dbms_sql.define_array(v_cursor, 25, p_accum_int_actions, p_batch_fetch_size, p_batch_start_index);
1501: dbms_sql.define_array(v_cursor, 26, p_accrued_interests, p_batch_fetch_size, p_batch_start_index);

Line 1498: dbms_sql.define_array(v_cursor, 23, p_interests, p_batch_fetch_size, p_batch_start_index);

1494: dbms_sql.define_array(v_cursor, 19, p_base_amounts, p_batch_fetch_size, p_batch_start_index);
1495: dbms_sql.define_array(v_cursor, 20, p_contra_amounts, p_batch_fetch_size, p_batch_start_index);
1496: dbms_sql.define_array(v_cursor, 21, p_start_amounts, p_batch_fetch_size, p_batch_start_index);
1497: dbms_sql.define_array(v_cursor, 22, p_face_values, p_batch_fetch_size, p_batch_start_index);
1498: dbms_sql.define_array(v_cursor, 23, p_interests, p_batch_fetch_size, p_batch_start_index);
1499: dbms_sql.define_array(v_cursor, 24, p_accum_int_bfs, p_batch_fetch_size, p_batch_start_index);
1500: dbms_sql.define_array(v_cursor, 25, p_accum_int_actions, p_batch_fetch_size, p_batch_start_index);
1501: dbms_sql.define_array(v_cursor, 26, p_accrued_interests, p_batch_fetch_size, p_batch_start_index);
1502: dbms_sql.define_array(v_cursor, 27, p_interests_settled, p_batch_fetch_size, p_batch_start_index);

Line 1499: dbms_sql.define_array(v_cursor, 24, p_accum_int_bfs, p_batch_fetch_size, p_batch_start_index);

1495: dbms_sql.define_array(v_cursor, 20, p_contra_amounts, p_batch_fetch_size, p_batch_start_index);
1496: dbms_sql.define_array(v_cursor, 21, p_start_amounts, p_batch_fetch_size, p_batch_start_index);
1497: dbms_sql.define_array(v_cursor, 22, p_face_values, p_batch_fetch_size, p_batch_start_index);
1498: dbms_sql.define_array(v_cursor, 23, p_interests, p_batch_fetch_size, p_batch_start_index);
1499: dbms_sql.define_array(v_cursor, 24, p_accum_int_bfs, p_batch_fetch_size, p_batch_start_index);
1500: dbms_sql.define_array(v_cursor, 25, p_accum_int_actions, p_batch_fetch_size, p_batch_start_index);
1501: dbms_sql.define_array(v_cursor, 26, p_accrued_interests, p_batch_fetch_size, p_batch_start_index);
1502: dbms_sql.define_array(v_cursor, 27, p_interests_settled, p_batch_fetch_size, p_batch_start_index);
1503: dbms_sql.define_array(v_cursor, 28, p_deal_dates, p_batch_fetch_size, p_batch_start_index);

Line 1500: dbms_sql.define_array(v_cursor, 25, p_accum_int_actions, p_batch_fetch_size, p_batch_start_index);

1496: dbms_sql.define_array(v_cursor, 21, p_start_amounts, p_batch_fetch_size, p_batch_start_index);
1497: dbms_sql.define_array(v_cursor, 22, p_face_values, p_batch_fetch_size, p_batch_start_index);
1498: dbms_sql.define_array(v_cursor, 23, p_interests, p_batch_fetch_size, p_batch_start_index);
1499: dbms_sql.define_array(v_cursor, 24, p_accum_int_bfs, p_batch_fetch_size, p_batch_start_index);
1500: dbms_sql.define_array(v_cursor, 25, p_accum_int_actions, p_batch_fetch_size, p_batch_start_index);
1501: dbms_sql.define_array(v_cursor, 26, p_accrued_interests, p_batch_fetch_size, p_batch_start_index);
1502: dbms_sql.define_array(v_cursor, 27, p_interests_settled, p_batch_fetch_size, p_batch_start_index);
1503: dbms_sql.define_array(v_cursor, 28, p_deal_dates, p_batch_fetch_size, p_batch_start_index);
1504: dbms_sql.define_array(v_cursor, 29, p_end_dates, p_batch_fetch_size, p_batch_start_index);

Line 1501: dbms_sql.define_array(v_cursor, 26, p_accrued_interests, p_batch_fetch_size, p_batch_start_index);

1497: dbms_sql.define_array(v_cursor, 22, p_face_values, p_batch_fetch_size, p_batch_start_index);
1498: dbms_sql.define_array(v_cursor, 23, p_interests, p_batch_fetch_size, p_batch_start_index);
1499: dbms_sql.define_array(v_cursor, 24, p_accum_int_bfs, p_batch_fetch_size, p_batch_start_index);
1500: dbms_sql.define_array(v_cursor, 25, p_accum_int_actions, p_batch_fetch_size, p_batch_start_index);
1501: dbms_sql.define_array(v_cursor, 26, p_accrued_interests, p_batch_fetch_size, p_batch_start_index);
1502: dbms_sql.define_array(v_cursor, 27, p_interests_settled, p_batch_fetch_size, p_batch_start_index);
1503: dbms_sql.define_array(v_cursor, 28, p_deal_dates, p_batch_fetch_size, p_batch_start_index);
1504: dbms_sql.define_array(v_cursor, 29, p_end_dates, p_batch_fetch_size, p_batch_start_index);
1505: dbms_sql.define_array(v_cursor, 30, p_gap_dates, p_batch_fetch_size, p_batch_start_index);

Line 1502: dbms_sql.define_array(v_cursor, 27, p_interests_settled, p_batch_fetch_size, p_batch_start_index);

1498: dbms_sql.define_array(v_cursor, 23, p_interests, p_batch_fetch_size, p_batch_start_index);
1499: dbms_sql.define_array(v_cursor, 24, p_accum_int_bfs, p_batch_fetch_size, p_batch_start_index);
1500: dbms_sql.define_array(v_cursor, 25, p_accum_int_actions, p_batch_fetch_size, p_batch_start_index);
1501: dbms_sql.define_array(v_cursor, 26, p_accrued_interests, p_batch_fetch_size, p_batch_start_index);
1502: dbms_sql.define_array(v_cursor, 27, p_interests_settled, p_batch_fetch_size, p_batch_start_index);
1503: dbms_sql.define_array(v_cursor, 28, p_deal_dates, p_batch_fetch_size, p_batch_start_index);
1504: dbms_sql.define_array(v_cursor, 29, p_end_dates, p_batch_fetch_size, p_batch_start_index);
1505: dbms_sql.define_array(v_cursor, 30, p_gap_dates, p_batch_fetch_size, p_batch_start_index);
1506: dbms_sql.define_array(v_cursor, 31, p_deal_subtypes, p_batch_fetch_size, p_batch_start_index);

Line 1503: dbms_sql.define_array(v_cursor, 28, p_deal_dates, p_batch_fetch_size, p_batch_start_index);

1499: dbms_sql.define_array(v_cursor, 24, p_accum_int_bfs, p_batch_fetch_size, p_batch_start_index);
1500: dbms_sql.define_array(v_cursor, 25, p_accum_int_actions, p_batch_fetch_size, p_batch_start_index);
1501: dbms_sql.define_array(v_cursor, 26, p_accrued_interests, p_batch_fetch_size, p_batch_start_index);
1502: dbms_sql.define_array(v_cursor, 27, p_interests_settled, p_batch_fetch_size, p_batch_start_index);
1503: dbms_sql.define_array(v_cursor, 28, p_deal_dates, p_batch_fetch_size, p_batch_start_index);
1504: dbms_sql.define_array(v_cursor, 29, p_end_dates, p_batch_fetch_size, p_batch_start_index);
1505: dbms_sql.define_array(v_cursor, 30, p_gap_dates, p_batch_fetch_size, p_batch_start_index);
1506: dbms_sql.define_array(v_cursor, 31, p_deal_subtypes, p_batch_fetch_size, p_batch_start_index);
1507: dbms_sql.define_array(v_cursor, 32, p_deal_types, p_batch_fetch_size, p_batch_start_index);

Line 1504: dbms_sql.define_array(v_cursor, 29, p_end_dates, p_batch_fetch_size, p_batch_start_index);

1500: dbms_sql.define_array(v_cursor, 25, p_accum_int_actions, p_batch_fetch_size, p_batch_start_index);
1501: dbms_sql.define_array(v_cursor, 26, p_accrued_interests, p_batch_fetch_size, p_batch_start_index);
1502: dbms_sql.define_array(v_cursor, 27, p_interests_settled, p_batch_fetch_size, p_batch_start_index);
1503: dbms_sql.define_array(v_cursor, 28, p_deal_dates, p_batch_fetch_size, p_batch_start_index);
1504: dbms_sql.define_array(v_cursor, 29, p_end_dates, p_batch_fetch_size, p_batch_start_index);
1505: dbms_sql.define_array(v_cursor, 30, p_gap_dates, p_batch_fetch_size, p_batch_start_index);
1506: dbms_sql.define_array(v_cursor, 31, p_deal_subtypes, p_batch_fetch_size, p_batch_start_index);
1507: dbms_sql.define_array(v_cursor, 32, p_deal_types, p_batch_fetch_size, p_batch_start_index);
1508: dbms_sql.define_array(v_cursor, 33, p_discount_yields, p_batch_fetch_size, p_batch_start_index);

Line 1505: dbms_sql.define_array(v_cursor, 30, p_gap_dates, p_batch_fetch_size, p_batch_start_index);

1501: dbms_sql.define_array(v_cursor, 26, p_accrued_interests, p_batch_fetch_size, p_batch_start_index);
1502: dbms_sql.define_array(v_cursor, 27, p_interests_settled, p_batch_fetch_size, p_batch_start_index);
1503: dbms_sql.define_array(v_cursor, 28, p_deal_dates, p_batch_fetch_size, p_batch_start_index);
1504: dbms_sql.define_array(v_cursor, 29, p_end_dates, p_batch_fetch_size, p_batch_start_index);
1505: dbms_sql.define_array(v_cursor, 30, p_gap_dates, p_batch_fetch_size, p_batch_start_index);
1506: dbms_sql.define_array(v_cursor, 31, p_deal_subtypes, p_batch_fetch_size, p_batch_start_index);
1507: dbms_sql.define_array(v_cursor, 32, p_deal_types, p_batch_fetch_size, p_batch_start_index);
1508: dbms_sql.define_array(v_cursor, 33, p_discount_yields, p_batch_fetch_size, p_batch_start_index);
1509: dbms_sql.define_array(v_cursor, 34, p_maturity_dates, p_batch_fetch_size, p_batch_start_index);

Line 1506: dbms_sql.define_array(v_cursor, 31, p_deal_subtypes, p_batch_fetch_size, p_batch_start_index);

1502: dbms_sql.define_array(v_cursor, 27, p_interests_settled, p_batch_fetch_size, p_batch_start_index);
1503: dbms_sql.define_array(v_cursor, 28, p_deal_dates, p_batch_fetch_size, p_batch_start_index);
1504: dbms_sql.define_array(v_cursor, 29, p_end_dates, p_batch_fetch_size, p_batch_start_index);
1505: dbms_sql.define_array(v_cursor, 30, p_gap_dates, p_batch_fetch_size, p_batch_start_index);
1506: dbms_sql.define_array(v_cursor, 31, p_deal_subtypes, p_batch_fetch_size, p_batch_start_index);
1507: dbms_sql.define_array(v_cursor, 32, p_deal_types, p_batch_fetch_size, p_batch_start_index);
1508: dbms_sql.define_array(v_cursor, 33, p_discount_yields, p_batch_fetch_size, p_batch_start_index);
1509: dbms_sql.define_array(v_cursor, 34, p_maturity_dates, p_batch_fetch_size, p_batch_start_index);
1510: dbms_sql.define_array(v_cursor, 35, p_no_of_days, p_batch_fetch_size, p_batch_start_index);

Line 1507: dbms_sql.define_array(v_cursor, 32, p_deal_types, p_batch_fetch_size, p_batch_start_index);

1503: dbms_sql.define_array(v_cursor, 28, p_deal_dates, p_batch_fetch_size, p_batch_start_index);
1504: dbms_sql.define_array(v_cursor, 29, p_end_dates, p_batch_fetch_size, p_batch_start_index);
1505: dbms_sql.define_array(v_cursor, 30, p_gap_dates, p_batch_fetch_size, p_batch_start_index);
1506: dbms_sql.define_array(v_cursor, 31, p_deal_subtypes, p_batch_fetch_size, p_batch_start_index);
1507: dbms_sql.define_array(v_cursor, 32, p_deal_types, p_batch_fetch_size, p_batch_start_index);
1508: dbms_sql.define_array(v_cursor, 33, p_discount_yields, p_batch_fetch_size, p_batch_start_index);
1509: dbms_sql.define_array(v_cursor, 34, p_maturity_dates, p_batch_fetch_size, p_batch_start_index);
1510: dbms_sql.define_array(v_cursor, 35, p_no_of_days, p_batch_fetch_size, p_batch_start_index);
1511: dbms_sql.define_array(v_cursor, 36, p_settle_dates, p_batch_fetch_size, p_batch_start_index);

Line 1508: dbms_sql.define_array(v_cursor, 33, p_discount_yields, p_batch_fetch_size, p_batch_start_index);

1504: dbms_sql.define_array(v_cursor, 29, p_end_dates, p_batch_fetch_size, p_batch_start_index);
1505: dbms_sql.define_array(v_cursor, 30, p_gap_dates, p_batch_fetch_size, p_batch_start_index);
1506: dbms_sql.define_array(v_cursor, 31, p_deal_subtypes, p_batch_fetch_size, p_batch_start_index);
1507: dbms_sql.define_array(v_cursor, 32, p_deal_types, p_batch_fetch_size, p_batch_start_index);
1508: dbms_sql.define_array(v_cursor, 33, p_discount_yields, p_batch_fetch_size, p_batch_start_index);
1509: dbms_sql.define_array(v_cursor, 34, p_maturity_dates, p_batch_fetch_size, p_batch_start_index);
1510: dbms_sql.define_array(v_cursor, 35, p_no_of_days, p_batch_fetch_size, p_batch_start_index);
1511: dbms_sql.define_array(v_cursor, 36, p_settle_dates, p_batch_fetch_size, p_batch_start_index);
1512: dbms_sql.define_array(v_cursor, 37, p_premium_amounts, p_batch_fetch_size, p_batch_start_index);

Line 1509: dbms_sql.define_array(v_cursor, 34, p_maturity_dates, p_batch_fetch_size, p_batch_start_index);

1505: dbms_sql.define_array(v_cursor, 30, p_gap_dates, p_batch_fetch_size, p_batch_start_index);
1506: dbms_sql.define_array(v_cursor, 31, p_deal_subtypes, p_batch_fetch_size, p_batch_start_index);
1507: dbms_sql.define_array(v_cursor, 32, p_deal_types, p_batch_fetch_size, p_batch_start_index);
1508: dbms_sql.define_array(v_cursor, 33, p_discount_yields, p_batch_fetch_size, p_batch_start_index);
1509: dbms_sql.define_array(v_cursor, 34, p_maturity_dates, p_batch_fetch_size, p_batch_start_index);
1510: dbms_sql.define_array(v_cursor, 35, p_no_of_days, p_batch_fetch_size, p_batch_start_index);
1511: dbms_sql.define_array(v_cursor, 36, p_settle_dates, p_batch_fetch_size, p_batch_start_index);
1512: dbms_sql.define_array(v_cursor, 37, p_premium_amounts, p_batch_fetch_size, p_batch_start_index);
1513: dbms_sql.define_array(v_cursor, 38, p_start_dates, p_batch_fetch_size, p_batch_start_index);

Line 1510: dbms_sql.define_array(v_cursor, 35, p_no_of_days, p_batch_fetch_size, p_batch_start_index);

1506: dbms_sql.define_array(v_cursor, 31, p_deal_subtypes, p_batch_fetch_size, p_batch_start_index);
1507: dbms_sql.define_array(v_cursor, 32, p_deal_types, p_batch_fetch_size, p_batch_start_index);
1508: dbms_sql.define_array(v_cursor, 33, p_discount_yields, p_batch_fetch_size, p_batch_start_index);
1509: dbms_sql.define_array(v_cursor, 34, p_maturity_dates, p_batch_fetch_size, p_batch_start_index);
1510: dbms_sql.define_array(v_cursor, 35, p_no_of_days, p_batch_fetch_size, p_batch_start_index);
1511: dbms_sql.define_array(v_cursor, 36, p_settle_dates, p_batch_fetch_size, p_batch_start_index);
1512: dbms_sql.define_array(v_cursor, 37, p_premium_amounts, p_batch_fetch_size, p_batch_start_index);
1513: dbms_sql.define_array(v_cursor, 38, p_start_dates, p_batch_fetch_size, p_batch_start_index);
1514: dbms_sql.define_array(v_cursor, 39, p_initial_bases, p_batch_fetch_size, p_batch_start_index);

Line 1511: dbms_sql.define_array(v_cursor, 36, p_settle_dates, p_batch_fetch_size, p_batch_start_index);

1507: dbms_sql.define_array(v_cursor, 32, p_deal_types, p_batch_fetch_size, p_batch_start_index);
1508: dbms_sql.define_array(v_cursor, 33, p_discount_yields, p_batch_fetch_size, p_batch_start_index);
1509: dbms_sql.define_array(v_cursor, 34, p_maturity_dates, p_batch_fetch_size, p_batch_start_index);
1510: dbms_sql.define_array(v_cursor, 35, p_no_of_days, p_batch_fetch_size, p_batch_start_index);
1511: dbms_sql.define_array(v_cursor, 36, p_settle_dates, p_batch_fetch_size, p_batch_start_index);
1512: dbms_sql.define_array(v_cursor, 37, p_premium_amounts, p_batch_fetch_size, p_batch_start_index);
1513: dbms_sql.define_array(v_cursor, 38, p_start_dates, p_batch_fetch_size, p_batch_start_index);
1514: dbms_sql.define_array(v_cursor, 39, p_initial_bases, p_batch_fetch_size, p_batch_start_index);
1515: dbms_sql.define_array(v_cursor, 40, p_bond_issues, p_batch_fetch_size, p_batch_start_index);

Line 1512: dbms_sql.define_array(v_cursor, 37, p_premium_amounts, p_batch_fetch_size, p_batch_start_index);

1508: dbms_sql.define_array(v_cursor, 33, p_discount_yields, p_batch_fetch_size, p_batch_start_index);
1509: dbms_sql.define_array(v_cursor, 34, p_maturity_dates, p_batch_fetch_size, p_batch_start_index);
1510: dbms_sql.define_array(v_cursor, 35, p_no_of_days, p_batch_fetch_size, p_batch_start_index);
1511: dbms_sql.define_array(v_cursor, 36, p_settle_dates, p_batch_fetch_size, p_batch_start_index);
1512: dbms_sql.define_array(v_cursor, 37, p_premium_amounts, p_batch_fetch_size, p_batch_start_index);
1513: dbms_sql.define_array(v_cursor, 38, p_start_dates, p_batch_fetch_size, p_batch_start_index);
1514: dbms_sql.define_array(v_cursor, 39, p_initial_bases, p_batch_fetch_size, p_batch_start_index);
1515: dbms_sql.define_array(v_cursor, 40, p_bond_issues, p_batch_fetch_size, p_batch_start_index);
1516: dbms_sql.define_array(v_cursor, 41, p_coupon_actions, p_batch_fetch_size, p_batch_start_index);

Line 1513: dbms_sql.define_array(v_cursor, 38, p_start_dates, p_batch_fetch_size, p_batch_start_index);

1509: dbms_sql.define_array(v_cursor, 34, p_maturity_dates, p_batch_fetch_size, p_batch_start_index);
1510: dbms_sql.define_array(v_cursor, 35, p_no_of_days, p_batch_fetch_size, p_batch_start_index);
1511: dbms_sql.define_array(v_cursor, 36, p_settle_dates, p_batch_fetch_size, p_batch_start_index);
1512: dbms_sql.define_array(v_cursor, 37, p_premium_amounts, p_batch_fetch_size, p_batch_start_index);
1513: dbms_sql.define_array(v_cursor, 38, p_start_dates, p_batch_fetch_size, p_batch_start_index);
1514: dbms_sql.define_array(v_cursor, 39, p_initial_bases, p_batch_fetch_size, p_batch_start_index);
1515: dbms_sql.define_array(v_cursor, 40, p_bond_issues, p_batch_fetch_size, p_batch_start_index);
1516: dbms_sql.define_array(v_cursor, 41, p_coupon_actions, p_batch_fetch_size, p_batch_start_index);
1517: dbms_sql.define_array(v_cursor, 42, p_coupon_rates, p_batch_fetch_size, p_batch_start_index);

Line 1514: dbms_sql.define_array(v_cursor, 39, p_initial_bases, p_batch_fetch_size, p_batch_start_index);

1510: dbms_sql.define_array(v_cursor, 35, p_no_of_days, p_batch_fetch_size, p_batch_start_index);
1511: dbms_sql.define_array(v_cursor, 36, p_settle_dates, p_batch_fetch_size, p_batch_start_index);
1512: dbms_sql.define_array(v_cursor, 37, p_premium_amounts, p_batch_fetch_size, p_batch_start_index);
1513: dbms_sql.define_array(v_cursor, 38, p_start_dates, p_batch_fetch_size, p_batch_start_index);
1514: dbms_sql.define_array(v_cursor, 39, p_initial_bases, p_batch_fetch_size, p_batch_start_index);
1515: dbms_sql.define_array(v_cursor, 40, p_bond_issues, p_batch_fetch_size, p_batch_start_index);
1516: dbms_sql.define_array(v_cursor, 41, p_coupon_actions, p_batch_fetch_size, p_batch_start_index);
1517: dbms_sql.define_array(v_cursor, 42, p_coupon_rates, p_batch_fetch_size, p_batch_start_index);
1518: dbms_sql.define_array(v_cursor, 43, p_margins, p_batch_fetch_size, p_batch_start_index);

Line 1515: dbms_sql.define_array(v_cursor, 40, p_bond_issues, p_batch_fetch_size, p_batch_start_index);

1511: dbms_sql.define_array(v_cursor, 36, p_settle_dates, p_batch_fetch_size, p_batch_start_index);
1512: dbms_sql.define_array(v_cursor, 37, p_premium_amounts, p_batch_fetch_size, p_batch_start_index);
1513: dbms_sql.define_array(v_cursor, 38, p_start_dates, p_batch_fetch_size, p_batch_start_index);
1514: dbms_sql.define_array(v_cursor, 39, p_initial_bases, p_batch_fetch_size, p_batch_start_index);
1515: dbms_sql.define_array(v_cursor, 40, p_bond_issues, p_batch_fetch_size, p_batch_start_index);
1516: dbms_sql.define_array(v_cursor, 41, p_coupon_actions, p_batch_fetch_size, p_batch_start_index);
1517: dbms_sql.define_array(v_cursor, 42, p_coupon_rates, p_batch_fetch_size, p_batch_start_index);
1518: dbms_sql.define_array(v_cursor, 43, p_margins, p_batch_fetch_size, p_batch_start_index);
1519: dbms_sql.define_array(v_cursor, 44, p_transaction_rates, p_batch_fetch_size, p_batch_start_index);

Line 1516: dbms_sql.define_array(v_cursor, 41, p_coupon_actions, p_batch_fetch_size, p_batch_start_index);

1512: dbms_sql.define_array(v_cursor, 37, p_premium_amounts, p_batch_fetch_size, p_batch_start_index);
1513: dbms_sql.define_array(v_cursor, 38, p_start_dates, p_batch_fetch_size, p_batch_start_index);
1514: dbms_sql.define_array(v_cursor, 39, p_initial_bases, p_batch_fetch_size, p_batch_start_index);
1515: dbms_sql.define_array(v_cursor, 40, p_bond_issues, p_batch_fetch_size, p_batch_start_index);
1516: dbms_sql.define_array(v_cursor, 41, p_coupon_actions, p_batch_fetch_size, p_batch_start_index);
1517: dbms_sql.define_array(v_cursor, 42, p_coupon_rates, p_batch_fetch_size, p_batch_start_index);
1518: dbms_sql.define_array(v_cursor, 43, p_margins, p_batch_fetch_size, p_batch_start_index);
1519: dbms_sql.define_array(v_cursor, 44, p_transaction_rates, p_batch_fetch_size, p_batch_start_index);
1520: dbms_sql.define_array(v_cursor, 45, p_coupon_freqs, p_batch_fetch_size, p_batch_start_index);

Line 1517: dbms_sql.define_array(v_cursor, 42, p_coupon_rates, p_batch_fetch_size, p_batch_start_index);

1513: dbms_sql.define_array(v_cursor, 38, p_start_dates, p_batch_fetch_size, p_batch_start_index);
1514: dbms_sql.define_array(v_cursor, 39, p_initial_bases, p_batch_fetch_size, p_batch_start_index);
1515: dbms_sql.define_array(v_cursor, 40, p_bond_issues, p_batch_fetch_size, p_batch_start_index);
1516: dbms_sql.define_array(v_cursor, 41, p_coupon_actions, p_batch_fetch_size, p_batch_start_index);
1517: dbms_sql.define_array(v_cursor, 42, p_coupon_rates, p_batch_fetch_size, p_batch_start_index);
1518: dbms_sql.define_array(v_cursor, 43, p_margins, p_batch_fetch_size, p_batch_start_index);
1519: dbms_sql.define_array(v_cursor, 44, p_transaction_rates, p_batch_fetch_size, p_batch_start_index);
1520: dbms_sql.define_array(v_cursor, 45, p_coupon_freqs, p_batch_fetch_size, p_batch_start_index);
1521: dbms_sql.define_array(v_cursor, 46, p_next_coupon_dates, p_batch_fetch_size, p_batch_start_index);

Line 1518: dbms_sql.define_array(v_cursor, 43, p_margins, p_batch_fetch_size, p_batch_start_index);

1514: dbms_sql.define_array(v_cursor, 39, p_initial_bases, p_batch_fetch_size, p_batch_start_index);
1515: dbms_sql.define_array(v_cursor, 40, p_bond_issues, p_batch_fetch_size, p_batch_start_index);
1516: dbms_sql.define_array(v_cursor, 41, p_coupon_actions, p_batch_fetch_size, p_batch_start_index);
1517: dbms_sql.define_array(v_cursor, 42, p_coupon_rates, p_batch_fetch_size, p_batch_start_index);
1518: dbms_sql.define_array(v_cursor, 43, p_margins, p_batch_fetch_size, p_batch_start_index);
1519: dbms_sql.define_array(v_cursor, 44, p_transaction_rates, p_batch_fetch_size, p_batch_start_index);
1520: dbms_sql.define_array(v_cursor, 45, p_coupon_freqs, p_batch_fetch_size, p_batch_start_index);
1521: dbms_sql.define_array(v_cursor, 46, p_next_coupon_dates, p_batch_fetch_size, p_batch_start_index);
1522: dbms_sql.define_array(v_cursor, 47, p_day_count_bases, p_batch_fetch_size, p_batch_start_index);

Line 1519: dbms_sql.define_array(v_cursor, 44, p_transaction_rates, p_batch_fetch_size, p_batch_start_index);

1515: dbms_sql.define_array(v_cursor, 40, p_bond_issues, p_batch_fetch_size, p_batch_start_index);
1516: dbms_sql.define_array(v_cursor, 41, p_coupon_actions, p_batch_fetch_size, p_batch_start_index);
1517: dbms_sql.define_array(v_cursor, 42, p_coupon_rates, p_batch_fetch_size, p_batch_start_index);
1518: dbms_sql.define_array(v_cursor, 43, p_margins, p_batch_fetch_size, p_batch_start_index);
1519: dbms_sql.define_array(v_cursor, 44, p_transaction_rates, p_batch_fetch_size, p_batch_start_index);
1520: dbms_sql.define_array(v_cursor, 45, p_coupon_freqs, p_batch_fetch_size, p_batch_start_index);
1521: dbms_sql.define_array(v_cursor, 46, p_next_coupon_dates, p_batch_fetch_size, p_batch_start_index);
1522: dbms_sql.define_array(v_cursor, 47, p_day_count_bases, p_batch_fetch_size, p_batch_start_index);
1523: dbms_sql.define_array(v_cursor, 48, p_quantity_out, p_batch_fetch_size, p_batch_start_index);

Line 1520: dbms_sql.define_array(v_cursor, 45, p_coupon_freqs, p_batch_fetch_size, p_batch_start_index);

1516: dbms_sql.define_array(v_cursor, 41, p_coupon_actions, p_batch_fetch_size, p_batch_start_index);
1517: dbms_sql.define_array(v_cursor, 42, p_coupon_rates, p_batch_fetch_size, p_batch_start_index);
1518: dbms_sql.define_array(v_cursor, 43, p_margins, p_batch_fetch_size, p_batch_start_index);
1519: dbms_sql.define_array(v_cursor, 44, p_transaction_rates, p_batch_fetch_size, p_batch_start_index);
1520: dbms_sql.define_array(v_cursor, 45, p_coupon_freqs, p_batch_fetch_size, p_batch_start_index);
1521: dbms_sql.define_array(v_cursor, 46, p_next_coupon_dates, p_batch_fetch_size, p_batch_start_index);
1522: dbms_sql.define_array(v_cursor, 47, p_day_count_bases, p_batch_fetch_size, p_batch_start_index);
1523: dbms_sql.define_array(v_cursor, 48, p_quantity_out, p_batch_fetch_size, p_batch_start_index);
1524: dbms_sql.define_array(v_cursor, 49, p_rounding_type, p_batch_fetch_size, p_batch_start_index);

Line 1521: dbms_sql.define_array(v_cursor, 46, p_next_coupon_dates, p_batch_fetch_size, p_batch_start_index);

1517: dbms_sql.define_array(v_cursor, 42, p_coupon_rates, p_batch_fetch_size, p_batch_start_index);
1518: dbms_sql.define_array(v_cursor, 43, p_margins, p_batch_fetch_size, p_batch_start_index);
1519: dbms_sql.define_array(v_cursor, 44, p_transaction_rates, p_batch_fetch_size, p_batch_start_index);
1520: dbms_sql.define_array(v_cursor, 45, p_coupon_freqs, p_batch_fetch_size, p_batch_start_index);
1521: dbms_sql.define_array(v_cursor, 46, p_next_coupon_dates, p_batch_fetch_size, p_batch_start_index);
1522: dbms_sql.define_array(v_cursor, 47, p_day_count_bases, p_batch_fetch_size, p_batch_start_index);
1523: dbms_sql.define_array(v_cursor, 48, p_quantity_out, p_batch_fetch_size, p_batch_start_index);
1524: dbms_sql.define_array(v_cursor, 49, p_rounding_type, p_batch_fetch_size, p_batch_start_index);
1525: dbms_sql.define_array(v_cursor, 50, p_day_count_type, p_batch_fetch_size, p_batch_start_index);

Line 1522: dbms_sql.define_array(v_cursor, 47, p_day_count_bases, p_batch_fetch_size, p_batch_start_index);

1518: dbms_sql.define_array(v_cursor, 43, p_margins, p_batch_fetch_size, p_batch_start_index);
1519: dbms_sql.define_array(v_cursor, 44, p_transaction_rates, p_batch_fetch_size, p_batch_start_index);
1520: dbms_sql.define_array(v_cursor, 45, p_coupon_freqs, p_batch_fetch_size, p_batch_start_index);
1521: dbms_sql.define_array(v_cursor, 46, p_next_coupon_dates, p_batch_fetch_size, p_batch_start_index);
1522: dbms_sql.define_array(v_cursor, 47, p_day_count_bases, p_batch_fetch_size, p_batch_start_index);
1523: dbms_sql.define_array(v_cursor, 48, p_quantity_out, p_batch_fetch_size, p_batch_start_index);
1524: dbms_sql.define_array(v_cursor, 49, p_rounding_type, p_batch_fetch_size, p_batch_start_index);
1525: dbms_sql.define_array(v_cursor, 50, p_day_count_type, p_batch_fetch_size, p_batch_start_index);
1526: dbms_sql.define_array(v_cursor, 51, p_prepaid_interests, p_batch_fetch_size, p_batch_start_index);

Line 1523: dbms_sql.define_array(v_cursor, 48, p_quantity_out, p_batch_fetch_size, p_batch_start_index);

1519: dbms_sql.define_array(v_cursor, 44, p_transaction_rates, p_batch_fetch_size, p_batch_start_index);
1520: dbms_sql.define_array(v_cursor, 45, p_coupon_freqs, p_batch_fetch_size, p_batch_start_index);
1521: dbms_sql.define_array(v_cursor, 46, p_next_coupon_dates, p_batch_fetch_size, p_batch_start_index);
1522: dbms_sql.define_array(v_cursor, 47, p_day_count_bases, p_batch_fetch_size, p_batch_start_index);
1523: dbms_sql.define_array(v_cursor, 48, p_quantity_out, p_batch_fetch_size, p_batch_start_index);
1524: dbms_sql.define_array(v_cursor, 49, p_rounding_type, p_batch_fetch_size, p_batch_start_index);
1525: dbms_sql.define_array(v_cursor, 50, p_day_count_type, p_batch_fetch_size, p_batch_start_index);
1526: dbms_sql.define_array(v_cursor, 51, p_prepaid_interests, p_batch_fetch_size, p_batch_start_index);
1527:

Line 1524: dbms_sql.define_array(v_cursor, 49, p_rounding_type, p_batch_fetch_size, p_batch_start_index);

1520: dbms_sql.define_array(v_cursor, 45, p_coupon_freqs, p_batch_fetch_size, p_batch_start_index);
1521: dbms_sql.define_array(v_cursor, 46, p_next_coupon_dates, p_batch_fetch_size, p_batch_start_index);
1522: dbms_sql.define_array(v_cursor, 47, p_day_count_bases, p_batch_fetch_size, p_batch_start_index);
1523: dbms_sql.define_array(v_cursor, 48, p_quantity_out, p_batch_fetch_size, p_batch_start_index);
1524: dbms_sql.define_array(v_cursor, 49, p_rounding_type, p_batch_fetch_size, p_batch_start_index);
1525: dbms_sql.define_array(v_cursor, 50, p_day_count_type, p_batch_fetch_size, p_batch_start_index);
1526: dbms_sql.define_array(v_cursor, 51, p_prepaid_interests, p_batch_fetch_size, p_batch_start_index);
1527:
1528: n_num_rows_fetched := dbms_sql.fetch_rows(v_cursor);

Line 1525: dbms_sql.define_array(v_cursor, 50, p_day_count_type, p_batch_fetch_size, p_batch_start_index);

1521: dbms_sql.define_array(v_cursor, 46, p_next_coupon_dates, p_batch_fetch_size, p_batch_start_index);
1522: dbms_sql.define_array(v_cursor, 47, p_day_count_bases, p_batch_fetch_size, p_batch_start_index);
1523: dbms_sql.define_array(v_cursor, 48, p_quantity_out, p_batch_fetch_size, p_batch_start_index);
1524: dbms_sql.define_array(v_cursor, 49, p_rounding_type, p_batch_fetch_size, p_batch_start_index);
1525: dbms_sql.define_array(v_cursor, 50, p_day_count_type, p_batch_fetch_size, p_batch_start_index);
1526: dbms_sql.define_array(v_cursor, 51, p_prepaid_interests, p_batch_fetch_size, p_batch_start_index);
1527:
1528: n_num_rows_fetched := dbms_sql.fetch_rows(v_cursor);
1529:

Line 1526: dbms_sql.define_array(v_cursor, 51, p_prepaid_interests, p_batch_fetch_size, p_batch_start_index);

1522: dbms_sql.define_array(v_cursor, 47, p_day_count_bases, p_batch_fetch_size, p_batch_start_index);
1523: dbms_sql.define_array(v_cursor, 48, p_quantity_out, p_batch_fetch_size, p_batch_start_index);
1524: dbms_sql.define_array(v_cursor, 49, p_rounding_type, p_batch_fetch_size, p_batch_start_index);
1525: dbms_sql.define_array(v_cursor, 50, p_day_count_type, p_batch_fetch_size, p_batch_start_index);
1526: dbms_sql.define_array(v_cursor, 51, p_prepaid_interests, p_batch_fetch_size, p_batch_start_index);
1527:
1528: n_num_rows_fetched := dbms_sql.fetch_rows(v_cursor);
1529:
1530: dbms_sql.column_value(v_cursor, 1, p_deal_nos);

Line 1528: n_num_rows_fetched := dbms_sql.fetch_rows(v_cursor);

1524: dbms_sql.define_array(v_cursor, 49, p_rounding_type, p_batch_fetch_size, p_batch_start_index);
1525: dbms_sql.define_array(v_cursor, 50, p_day_count_type, p_batch_fetch_size, p_batch_start_index);
1526: dbms_sql.define_array(v_cursor, 51, p_prepaid_interests, p_batch_fetch_size, p_batch_start_index);
1527:
1528: n_num_rows_fetched := dbms_sql.fetch_rows(v_cursor);
1529:
1530: dbms_sql.column_value(v_cursor, 1, p_deal_nos);
1531: dbms_sql.column_value(v_cursor, 2, p_transaction_nos);
1532: dbms_sql.column_value(v_cursor, 3, p_market_data_sets);

Line 1530: dbms_sql.column_value(v_cursor, 1, p_deal_nos);

1526: dbms_sql.define_array(v_cursor, 51, p_prepaid_interests, p_batch_fetch_size, p_batch_start_index);
1527:
1528: n_num_rows_fetched := dbms_sql.fetch_rows(v_cursor);
1529:
1530: dbms_sql.column_value(v_cursor, 1, p_deal_nos);
1531: dbms_sql.column_value(v_cursor, 2, p_transaction_nos);
1532: dbms_sql.column_value(v_cursor, 3, p_market_data_sets);
1533: dbms_sql.column_value(v_cursor, 4, p_company_codes);
1534: dbms_sql.column_value(v_cursor, 5, p_calls_or_puts);

Line 1531: dbms_sql.column_value(v_cursor, 2, p_transaction_nos);

1527:
1528: n_num_rows_fetched := dbms_sql.fetch_rows(v_cursor);
1529:
1530: dbms_sql.column_value(v_cursor, 1, p_deal_nos);
1531: dbms_sql.column_value(v_cursor, 2, p_transaction_nos);
1532: dbms_sql.column_value(v_cursor, 3, p_market_data_sets);
1533: dbms_sql.column_value(v_cursor, 4, p_company_codes);
1534: dbms_sql.column_value(v_cursor, 5, p_calls_or_puts);
1535: dbms_sql.column_value(v_cursor, 6, p_pricing_models);

Line 1532: dbms_sql.column_value(v_cursor, 3, p_market_data_sets);

1528: n_num_rows_fetched := dbms_sql.fetch_rows(v_cursor);
1529:
1530: dbms_sql.column_value(v_cursor, 1, p_deal_nos);
1531: dbms_sql.column_value(v_cursor, 2, p_transaction_nos);
1532: dbms_sql.column_value(v_cursor, 3, p_market_data_sets);
1533: dbms_sql.column_value(v_cursor, 4, p_company_codes);
1534: dbms_sql.column_value(v_cursor, 5, p_calls_or_puts);
1535: dbms_sql.column_value(v_cursor, 6, p_pricing_models);
1536: dbms_sql.column_value(v_cursor, 7, p_deal_ccys);

Line 1533: dbms_sql.column_value(v_cursor, 4, p_company_codes);

1529:
1530: dbms_sql.column_value(v_cursor, 1, p_deal_nos);
1531: dbms_sql.column_value(v_cursor, 2, p_transaction_nos);
1532: dbms_sql.column_value(v_cursor, 3, p_market_data_sets);
1533: dbms_sql.column_value(v_cursor, 4, p_company_codes);
1534: dbms_sql.column_value(v_cursor, 5, p_calls_or_puts);
1535: dbms_sql.column_value(v_cursor, 6, p_pricing_models);
1536: dbms_sql.column_value(v_cursor, 7, p_deal_ccys);
1537: dbms_sql.column_value(v_cursor, 8, p_buy_ccys);

Line 1534: dbms_sql.column_value(v_cursor, 5, p_calls_or_puts);

1530: dbms_sql.column_value(v_cursor, 1, p_deal_nos);
1531: dbms_sql.column_value(v_cursor, 2, p_transaction_nos);
1532: dbms_sql.column_value(v_cursor, 3, p_market_data_sets);
1533: dbms_sql.column_value(v_cursor, 4, p_company_codes);
1534: dbms_sql.column_value(v_cursor, 5, p_calls_or_puts);
1535: dbms_sql.column_value(v_cursor, 6, p_pricing_models);
1536: dbms_sql.column_value(v_cursor, 7, p_deal_ccys);
1537: dbms_sql.column_value(v_cursor, 8, p_buy_ccys);
1538: dbms_sql.column_value(v_cursor, 9, p_sell_ccys);

Line 1535: dbms_sql.column_value(v_cursor, 6, p_pricing_models);

1531: dbms_sql.column_value(v_cursor, 2, p_transaction_nos);
1532: dbms_sql.column_value(v_cursor, 3, p_market_data_sets);
1533: dbms_sql.column_value(v_cursor, 4, p_company_codes);
1534: dbms_sql.column_value(v_cursor, 5, p_calls_or_puts);
1535: dbms_sql.column_value(v_cursor, 6, p_pricing_models);
1536: dbms_sql.column_value(v_cursor, 7, p_deal_ccys);
1537: dbms_sql.column_value(v_cursor, 8, p_buy_ccys);
1538: dbms_sql.column_value(v_cursor, 9, p_sell_ccys);
1539: dbms_sql.column_value(v_cursor, 10, p_foreign_ccys);

Line 1536: dbms_sql.column_value(v_cursor, 7, p_deal_ccys);

1532: dbms_sql.column_value(v_cursor, 3, p_market_data_sets);
1533: dbms_sql.column_value(v_cursor, 4, p_company_codes);
1534: dbms_sql.column_value(v_cursor, 5, p_calls_or_puts);
1535: dbms_sql.column_value(v_cursor, 6, p_pricing_models);
1536: dbms_sql.column_value(v_cursor, 7, p_deal_ccys);
1537: dbms_sql.column_value(v_cursor, 8, p_buy_ccys);
1538: dbms_sql.column_value(v_cursor, 9, p_sell_ccys);
1539: dbms_sql.column_value(v_cursor, 10, p_foreign_ccys);
1540: dbms_sql.column_value(v_cursor, 11, p_domestic_ccys);

Line 1537: dbms_sql.column_value(v_cursor, 8, p_buy_ccys);

1533: dbms_sql.column_value(v_cursor, 4, p_company_codes);
1534: dbms_sql.column_value(v_cursor, 5, p_calls_or_puts);
1535: dbms_sql.column_value(v_cursor, 6, p_pricing_models);
1536: dbms_sql.column_value(v_cursor, 7, p_deal_ccys);
1537: dbms_sql.column_value(v_cursor, 8, p_buy_ccys);
1538: dbms_sql.column_value(v_cursor, 9, p_sell_ccys);
1539: dbms_sql.column_value(v_cursor, 10, p_foreign_ccys);
1540: dbms_sql.column_value(v_cursor, 11, p_domestic_ccys);
1541: dbms_sql.column_value(v_cursor, 12, p_base_ccys);

Line 1538: dbms_sql.column_value(v_cursor, 9, p_sell_ccys);

1534: dbms_sql.column_value(v_cursor, 5, p_calls_or_puts);
1535: dbms_sql.column_value(v_cursor, 6, p_pricing_models);
1536: dbms_sql.column_value(v_cursor, 7, p_deal_ccys);
1537: dbms_sql.column_value(v_cursor, 8, p_buy_ccys);
1538: dbms_sql.column_value(v_cursor, 9, p_sell_ccys);
1539: dbms_sql.column_value(v_cursor, 10, p_foreign_ccys);
1540: dbms_sql.column_value(v_cursor, 11, p_domestic_ccys);
1541: dbms_sql.column_value(v_cursor, 12, p_base_ccys);
1542: dbms_sql.column_value(v_cursor, 13, p_contra_ccys);

Line 1539: dbms_sql.column_value(v_cursor, 10, p_foreign_ccys);

1535: dbms_sql.column_value(v_cursor, 6, p_pricing_models);
1536: dbms_sql.column_value(v_cursor, 7, p_deal_ccys);
1537: dbms_sql.column_value(v_cursor, 8, p_buy_ccys);
1538: dbms_sql.column_value(v_cursor, 9, p_sell_ccys);
1539: dbms_sql.column_value(v_cursor, 10, p_foreign_ccys);
1540: dbms_sql.column_value(v_cursor, 11, p_domestic_ccys);
1541: dbms_sql.column_value(v_cursor, 12, p_base_ccys);
1542: dbms_sql.column_value(v_cursor, 13, p_contra_ccys);
1543: dbms_sql.column_value(v_cursor, 14, p_premium_ccys);

Line 1540: dbms_sql.column_value(v_cursor, 11, p_domestic_ccys);

1536: dbms_sql.column_value(v_cursor, 7, p_deal_ccys);
1537: dbms_sql.column_value(v_cursor, 8, p_buy_ccys);
1538: dbms_sql.column_value(v_cursor, 9, p_sell_ccys);
1539: dbms_sql.column_value(v_cursor, 10, p_foreign_ccys);
1540: dbms_sql.column_value(v_cursor, 11, p_domestic_ccys);
1541: dbms_sql.column_value(v_cursor, 12, p_base_ccys);
1542: dbms_sql.column_value(v_cursor, 13, p_contra_ccys);
1543: dbms_sql.column_value(v_cursor, 14, p_premium_ccys);
1544: dbms_sql.column_value(v_cursor, 15, p_buy_amounts);

Line 1541: dbms_sql.column_value(v_cursor, 12, p_base_ccys);

1537: dbms_sql.column_value(v_cursor, 8, p_buy_ccys);
1538: dbms_sql.column_value(v_cursor, 9, p_sell_ccys);
1539: dbms_sql.column_value(v_cursor, 10, p_foreign_ccys);
1540: dbms_sql.column_value(v_cursor, 11, p_domestic_ccys);
1541: dbms_sql.column_value(v_cursor, 12, p_base_ccys);
1542: dbms_sql.column_value(v_cursor, 13, p_contra_ccys);
1543: dbms_sql.column_value(v_cursor, 14, p_premium_ccys);
1544: dbms_sql.column_value(v_cursor, 15, p_buy_amounts);
1545: dbms_sql.column_value(v_cursor, 16, p_sell_amounts);

Line 1542: dbms_sql.column_value(v_cursor, 13, p_contra_ccys);

1538: dbms_sql.column_value(v_cursor, 9, p_sell_ccys);
1539: dbms_sql.column_value(v_cursor, 10, p_foreign_ccys);
1540: dbms_sql.column_value(v_cursor, 11, p_domestic_ccys);
1541: dbms_sql.column_value(v_cursor, 12, p_base_ccys);
1542: dbms_sql.column_value(v_cursor, 13, p_contra_ccys);
1543: dbms_sql.column_value(v_cursor, 14, p_premium_ccys);
1544: dbms_sql.column_value(v_cursor, 15, p_buy_amounts);
1545: dbms_sql.column_value(v_cursor, 16, p_sell_amounts);
1546: dbms_sql.column_value(v_cursor, 17, p_foreign_amounts);

Line 1543: dbms_sql.column_value(v_cursor, 14, p_premium_ccys);

1539: dbms_sql.column_value(v_cursor, 10, p_foreign_ccys);
1540: dbms_sql.column_value(v_cursor, 11, p_domestic_ccys);
1541: dbms_sql.column_value(v_cursor, 12, p_base_ccys);
1542: dbms_sql.column_value(v_cursor, 13, p_contra_ccys);
1543: dbms_sql.column_value(v_cursor, 14, p_premium_ccys);
1544: dbms_sql.column_value(v_cursor, 15, p_buy_amounts);
1545: dbms_sql.column_value(v_cursor, 16, p_sell_amounts);
1546: dbms_sql.column_value(v_cursor, 17, p_foreign_amounts);
1547: dbms_sql.column_value(v_cursor, 18, p_domestic_amounts);

Line 1544: dbms_sql.column_value(v_cursor, 15, p_buy_amounts);

1540: dbms_sql.column_value(v_cursor, 11, p_domestic_ccys);
1541: dbms_sql.column_value(v_cursor, 12, p_base_ccys);
1542: dbms_sql.column_value(v_cursor, 13, p_contra_ccys);
1543: dbms_sql.column_value(v_cursor, 14, p_premium_ccys);
1544: dbms_sql.column_value(v_cursor, 15, p_buy_amounts);
1545: dbms_sql.column_value(v_cursor, 16, p_sell_amounts);
1546: dbms_sql.column_value(v_cursor, 17, p_foreign_amounts);
1547: dbms_sql.column_value(v_cursor, 18, p_domestic_amounts);
1548: dbms_sql.column_value(v_cursor, 19, p_base_amounts);

Line 1545: dbms_sql.column_value(v_cursor, 16, p_sell_amounts);

1541: dbms_sql.column_value(v_cursor, 12, p_base_ccys);
1542: dbms_sql.column_value(v_cursor, 13, p_contra_ccys);
1543: dbms_sql.column_value(v_cursor, 14, p_premium_ccys);
1544: dbms_sql.column_value(v_cursor, 15, p_buy_amounts);
1545: dbms_sql.column_value(v_cursor, 16, p_sell_amounts);
1546: dbms_sql.column_value(v_cursor, 17, p_foreign_amounts);
1547: dbms_sql.column_value(v_cursor, 18, p_domestic_amounts);
1548: dbms_sql.column_value(v_cursor, 19, p_base_amounts);
1549: dbms_sql.column_value(v_cursor, 20, p_contra_amounts);

Line 1546: dbms_sql.column_value(v_cursor, 17, p_foreign_amounts);

1542: dbms_sql.column_value(v_cursor, 13, p_contra_ccys);
1543: dbms_sql.column_value(v_cursor, 14, p_premium_ccys);
1544: dbms_sql.column_value(v_cursor, 15, p_buy_amounts);
1545: dbms_sql.column_value(v_cursor, 16, p_sell_amounts);
1546: dbms_sql.column_value(v_cursor, 17, p_foreign_amounts);
1547: dbms_sql.column_value(v_cursor, 18, p_domestic_amounts);
1548: dbms_sql.column_value(v_cursor, 19, p_base_amounts);
1549: dbms_sql.column_value(v_cursor, 20, p_contra_amounts);
1550: dbms_sql.column_value(v_cursor, 21, p_start_amounts);

Line 1547: dbms_sql.column_value(v_cursor, 18, p_domestic_amounts);

1543: dbms_sql.column_value(v_cursor, 14, p_premium_ccys);
1544: dbms_sql.column_value(v_cursor, 15, p_buy_amounts);
1545: dbms_sql.column_value(v_cursor, 16, p_sell_amounts);
1546: dbms_sql.column_value(v_cursor, 17, p_foreign_amounts);
1547: dbms_sql.column_value(v_cursor, 18, p_domestic_amounts);
1548: dbms_sql.column_value(v_cursor, 19, p_base_amounts);
1549: dbms_sql.column_value(v_cursor, 20, p_contra_amounts);
1550: dbms_sql.column_value(v_cursor, 21, p_start_amounts);
1551: dbms_sql.column_value(v_cursor, 22, p_face_values);

Line 1548: dbms_sql.column_value(v_cursor, 19, p_base_amounts);

1544: dbms_sql.column_value(v_cursor, 15, p_buy_amounts);
1545: dbms_sql.column_value(v_cursor, 16, p_sell_amounts);
1546: dbms_sql.column_value(v_cursor, 17, p_foreign_amounts);
1547: dbms_sql.column_value(v_cursor, 18, p_domestic_amounts);
1548: dbms_sql.column_value(v_cursor, 19, p_base_amounts);
1549: dbms_sql.column_value(v_cursor, 20, p_contra_amounts);
1550: dbms_sql.column_value(v_cursor, 21, p_start_amounts);
1551: dbms_sql.column_value(v_cursor, 22, p_face_values);
1552: dbms_sql.column_value(v_cursor, 23, p_interests);

Line 1549: dbms_sql.column_value(v_cursor, 20, p_contra_amounts);

1545: dbms_sql.column_value(v_cursor, 16, p_sell_amounts);
1546: dbms_sql.column_value(v_cursor, 17, p_foreign_amounts);
1547: dbms_sql.column_value(v_cursor, 18, p_domestic_amounts);
1548: dbms_sql.column_value(v_cursor, 19, p_base_amounts);
1549: dbms_sql.column_value(v_cursor, 20, p_contra_amounts);
1550: dbms_sql.column_value(v_cursor, 21, p_start_amounts);
1551: dbms_sql.column_value(v_cursor, 22, p_face_values);
1552: dbms_sql.column_value(v_cursor, 23, p_interests);
1553: dbms_sql.column_value(v_cursor, 24, p_accum_int_bfs);

Line 1550: dbms_sql.column_value(v_cursor, 21, p_start_amounts);

1546: dbms_sql.column_value(v_cursor, 17, p_foreign_amounts);
1547: dbms_sql.column_value(v_cursor, 18, p_domestic_amounts);
1548: dbms_sql.column_value(v_cursor, 19, p_base_amounts);
1549: dbms_sql.column_value(v_cursor, 20, p_contra_amounts);
1550: dbms_sql.column_value(v_cursor, 21, p_start_amounts);
1551: dbms_sql.column_value(v_cursor, 22, p_face_values);
1552: dbms_sql.column_value(v_cursor, 23, p_interests);
1553: dbms_sql.column_value(v_cursor, 24, p_accum_int_bfs);
1554: dbms_sql.column_value(v_cursor, 25, p_accum_int_actions);

Line 1551: dbms_sql.column_value(v_cursor, 22, p_face_values);

1547: dbms_sql.column_value(v_cursor, 18, p_domestic_amounts);
1548: dbms_sql.column_value(v_cursor, 19, p_base_amounts);
1549: dbms_sql.column_value(v_cursor, 20, p_contra_amounts);
1550: dbms_sql.column_value(v_cursor, 21, p_start_amounts);
1551: dbms_sql.column_value(v_cursor, 22, p_face_values);
1552: dbms_sql.column_value(v_cursor, 23, p_interests);
1553: dbms_sql.column_value(v_cursor, 24, p_accum_int_bfs);
1554: dbms_sql.column_value(v_cursor, 25, p_accum_int_actions);
1555: dbms_sql.column_value(v_cursor, 26, p_accrued_interests);

Line 1552: dbms_sql.column_value(v_cursor, 23, p_interests);

1548: dbms_sql.column_value(v_cursor, 19, p_base_amounts);
1549: dbms_sql.column_value(v_cursor, 20, p_contra_amounts);
1550: dbms_sql.column_value(v_cursor, 21, p_start_amounts);
1551: dbms_sql.column_value(v_cursor, 22, p_face_values);
1552: dbms_sql.column_value(v_cursor, 23, p_interests);
1553: dbms_sql.column_value(v_cursor, 24, p_accum_int_bfs);
1554: dbms_sql.column_value(v_cursor, 25, p_accum_int_actions);
1555: dbms_sql.column_value(v_cursor, 26, p_accrued_interests);
1556: dbms_sql.column_value(v_cursor, 27, p_interests_settled);

Line 1553: dbms_sql.column_value(v_cursor, 24, p_accum_int_bfs);

1549: dbms_sql.column_value(v_cursor, 20, p_contra_amounts);
1550: dbms_sql.column_value(v_cursor, 21, p_start_amounts);
1551: dbms_sql.column_value(v_cursor, 22, p_face_values);
1552: dbms_sql.column_value(v_cursor, 23, p_interests);
1553: dbms_sql.column_value(v_cursor, 24, p_accum_int_bfs);
1554: dbms_sql.column_value(v_cursor, 25, p_accum_int_actions);
1555: dbms_sql.column_value(v_cursor, 26, p_accrued_interests);
1556: dbms_sql.column_value(v_cursor, 27, p_interests_settled);
1557: dbms_sql.column_value(v_cursor, 28, p_deal_dates);

Line 1554: dbms_sql.column_value(v_cursor, 25, p_accum_int_actions);

1550: dbms_sql.column_value(v_cursor, 21, p_start_amounts);
1551: dbms_sql.column_value(v_cursor, 22, p_face_values);
1552: dbms_sql.column_value(v_cursor, 23, p_interests);
1553: dbms_sql.column_value(v_cursor, 24, p_accum_int_bfs);
1554: dbms_sql.column_value(v_cursor, 25, p_accum_int_actions);
1555: dbms_sql.column_value(v_cursor, 26, p_accrued_interests);
1556: dbms_sql.column_value(v_cursor, 27, p_interests_settled);
1557: dbms_sql.column_value(v_cursor, 28, p_deal_dates);
1558: dbms_sql.column_value(v_cursor, 29, p_end_dates);

Line 1555: dbms_sql.column_value(v_cursor, 26, p_accrued_interests);

1551: dbms_sql.column_value(v_cursor, 22, p_face_values);
1552: dbms_sql.column_value(v_cursor, 23, p_interests);
1553: dbms_sql.column_value(v_cursor, 24, p_accum_int_bfs);
1554: dbms_sql.column_value(v_cursor, 25, p_accum_int_actions);
1555: dbms_sql.column_value(v_cursor, 26, p_accrued_interests);
1556: dbms_sql.column_value(v_cursor, 27, p_interests_settled);
1557: dbms_sql.column_value(v_cursor, 28, p_deal_dates);
1558: dbms_sql.column_value(v_cursor, 29, p_end_dates);
1559: dbms_sql.column_value(v_cursor, 30, p_gap_dates);

Line 1556: dbms_sql.column_value(v_cursor, 27, p_interests_settled);

1552: dbms_sql.column_value(v_cursor, 23, p_interests);
1553: dbms_sql.column_value(v_cursor, 24, p_accum_int_bfs);
1554: dbms_sql.column_value(v_cursor, 25, p_accum_int_actions);
1555: dbms_sql.column_value(v_cursor, 26, p_accrued_interests);
1556: dbms_sql.column_value(v_cursor, 27, p_interests_settled);
1557: dbms_sql.column_value(v_cursor, 28, p_deal_dates);
1558: dbms_sql.column_value(v_cursor, 29, p_end_dates);
1559: dbms_sql.column_value(v_cursor, 30, p_gap_dates);
1560: dbms_sql.column_value(v_cursor, 31, p_deal_subtypes);

Line 1557: dbms_sql.column_value(v_cursor, 28, p_deal_dates);

1553: dbms_sql.column_value(v_cursor, 24, p_accum_int_bfs);
1554: dbms_sql.column_value(v_cursor, 25, p_accum_int_actions);
1555: dbms_sql.column_value(v_cursor, 26, p_accrued_interests);
1556: dbms_sql.column_value(v_cursor, 27, p_interests_settled);
1557: dbms_sql.column_value(v_cursor, 28, p_deal_dates);
1558: dbms_sql.column_value(v_cursor, 29, p_end_dates);
1559: dbms_sql.column_value(v_cursor, 30, p_gap_dates);
1560: dbms_sql.column_value(v_cursor, 31, p_deal_subtypes);
1561: dbms_sql.column_value(v_cursor, 32, p_deal_types);

Line 1558: dbms_sql.column_value(v_cursor, 29, p_end_dates);

1554: dbms_sql.column_value(v_cursor, 25, p_accum_int_actions);
1555: dbms_sql.column_value(v_cursor, 26, p_accrued_interests);
1556: dbms_sql.column_value(v_cursor, 27, p_interests_settled);
1557: dbms_sql.column_value(v_cursor, 28, p_deal_dates);
1558: dbms_sql.column_value(v_cursor, 29, p_end_dates);
1559: dbms_sql.column_value(v_cursor, 30, p_gap_dates);
1560: dbms_sql.column_value(v_cursor, 31, p_deal_subtypes);
1561: dbms_sql.column_value(v_cursor, 32, p_deal_types);
1562: dbms_sql.column_value(v_cursor, 33, p_discount_yields);

Line 1559: dbms_sql.column_value(v_cursor, 30, p_gap_dates);

1555: dbms_sql.column_value(v_cursor, 26, p_accrued_interests);
1556: dbms_sql.column_value(v_cursor, 27, p_interests_settled);
1557: dbms_sql.column_value(v_cursor, 28, p_deal_dates);
1558: dbms_sql.column_value(v_cursor, 29, p_end_dates);
1559: dbms_sql.column_value(v_cursor, 30, p_gap_dates);
1560: dbms_sql.column_value(v_cursor, 31, p_deal_subtypes);
1561: dbms_sql.column_value(v_cursor, 32, p_deal_types);
1562: dbms_sql.column_value(v_cursor, 33, p_discount_yields);
1563: dbms_sql.column_value(v_cursor, 34, p_maturity_dates);

Line 1560: dbms_sql.column_value(v_cursor, 31, p_deal_subtypes);

1556: dbms_sql.column_value(v_cursor, 27, p_interests_settled);
1557: dbms_sql.column_value(v_cursor, 28, p_deal_dates);
1558: dbms_sql.column_value(v_cursor, 29, p_end_dates);
1559: dbms_sql.column_value(v_cursor, 30, p_gap_dates);
1560: dbms_sql.column_value(v_cursor, 31, p_deal_subtypes);
1561: dbms_sql.column_value(v_cursor, 32, p_deal_types);
1562: dbms_sql.column_value(v_cursor, 33, p_discount_yields);
1563: dbms_sql.column_value(v_cursor, 34, p_maturity_dates);
1564: dbms_sql.column_value(v_cursor, 35, p_no_of_days);

Line 1561: dbms_sql.column_value(v_cursor, 32, p_deal_types);

1557: dbms_sql.column_value(v_cursor, 28, p_deal_dates);
1558: dbms_sql.column_value(v_cursor, 29, p_end_dates);
1559: dbms_sql.column_value(v_cursor, 30, p_gap_dates);
1560: dbms_sql.column_value(v_cursor, 31, p_deal_subtypes);
1561: dbms_sql.column_value(v_cursor, 32, p_deal_types);
1562: dbms_sql.column_value(v_cursor, 33, p_discount_yields);
1563: dbms_sql.column_value(v_cursor, 34, p_maturity_dates);
1564: dbms_sql.column_value(v_cursor, 35, p_no_of_days);
1565: dbms_sql.column_value(v_cursor, 36, p_settle_dates);

Line 1562: dbms_sql.column_value(v_cursor, 33, p_discount_yields);

1558: dbms_sql.column_value(v_cursor, 29, p_end_dates);
1559: dbms_sql.column_value(v_cursor, 30, p_gap_dates);
1560: dbms_sql.column_value(v_cursor, 31, p_deal_subtypes);
1561: dbms_sql.column_value(v_cursor, 32, p_deal_types);
1562: dbms_sql.column_value(v_cursor, 33, p_discount_yields);
1563: dbms_sql.column_value(v_cursor, 34, p_maturity_dates);
1564: dbms_sql.column_value(v_cursor, 35, p_no_of_days);
1565: dbms_sql.column_value(v_cursor, 36, p_settle_dates);
1566: dbms_sql.column_value(v_cursor, 37, p_premium_amounts);

Line 1563: dbms_sql.column_value(v_cursor, 34, p_maturity_dates);

1559: dbms_sql.column_value(v_cursor, 30, p_gap_dates);
1560: dbms_sql.column_value(v_cursor, 31, p_deal_subtypes);
1561: dbms_sql.column_value(v_cursor, 32, p_deal_types);
1562: dbms_sql.column_value(v_cursor, 33, p_discount_yields);
1563: dbms_sql.column_value(v_cursor, 34, p_maturity_dates);
1564: dbms_sql.column_value(v_cursor, 35, p_no_of_days);
1565: dbms_sql.column_value(v_cursor, 36, p_settle_dates);
1566: dbms_sql.column_value(v_cursor, 37, p_premium_amounts);
1567: dbms_sql.column_value(v_cursor, 38, p_start_dates);

Line 1564: dbms_sql.column_value(v_cursor, 35, p_no_of_days);

1560: dbms_sql.column_value(v_cursor, 31, p_deal_subtypes);
1561: dbms_sql.column_value(v_cursor, 32, p_deal_types);
1562: dbms_sql.column_value(v_cursor, 33, p_discount_yields);
1563: dbms_sql.column_value(v_cursor, 34, p_maturity_dates);
1564: dbms_sql.column_value(v_cursor, 35, p_no_of_days);
1565: dbms_sql.column_value(v_cursor, 36, p_settle_dates);
1566: dbms_sql.column_value(v_cursor, 37, p_premium_amounts);
1567: dbms_sql.column_value(v_cursor, 38, p_start_dates);
1568: dbms_sql.column_value(v_cursor, 39, p_initial_bases);

Line 1565: dbms_sql.column_value(v_cursor, 36, p_settle_dates);

1561: dbms_sql.column_value(v_cursor, 32, p_deal_types);
1562: dbms_sql.column_value(v_cursor, 33, p_discount_yields);
1563: dbms_sql.column_value(v_cursor, 34, p_maturity_dates);
1564: dbms_sql.column_value(v_cursor, 35, p_no_of_days);
1565: dbms_sql.column_value(v_cursor, 36, p_settle_dates);
1566: dbms_sql.column_value(v_cursor, 37, p_premium_amounts);
1567: dbms_sql.column_value(v_cursor, 38, p_start_dates);
1568: dbms_sql.column_value(v_cursor, 39, p_initial_bases);
1569: dbms_sql.column_value(v_cursor, 40, p_bond_issues);

Line 1566: dbms_sql.column_value(v_cursor, 37, p_premium_amounts);

1562: dbms_sql.column_value(v_cursor, 33, p_discount_yields);
1563: dbms_sql.column_value(v_cursor, 34, p_maturity_dates);
1564: dbms_sql.column_value(v_cursor, 35, p_no_of_days);
1565: dbms_sql.column_value(v_cursor, 36, p_settle_dates);
1566: dbms_sql.column_value(v_cursor, 37, p_premium_amounts);
1567: dbms_sql.column_value(v_cursor, 38, p_start_dates);
1568: dbms_sql.column_value(v_cursor, 39, p_initial_bases);
1569: dbms_sql.column_value(v_cursor, 40, p_bond_issues);
1570: dbms_sql.column_value(v_cursor, 41, p_coupon_actions);

Line 1567: dbms_sql.column_value(v_cursor, 38, p_start_dates);

1563: dbms_sql.column_value(v_cursor, 34, p_maturity_dates);
1564: dbms_sql.column_value(v_cursor, 35, p_no_of_days);
1565: dbms_sql.column_value(v_cursor, 36, p_settle_dates);
1566: dbms_sql.column_value(v_cursor, 37, p_premium_amounts);
1567: dbms_sql.column_value(v_cursor, 38, p_start_dates);
1568: dbms_sql.column_value(v_cursor, 39, p_initial_bases);
1569: dbms_sql.column_value(v_cursor, 40, p_bond_issues);
1570: dbms_sql.column_value(v_cursor, 41, p_coupon_actions);
1571: dbms_sql.column_value(v_cursor, 42, p_coupon_rates);

Line 1568: dbms_sql.column_value(v_cursor, 39, p_initial_bases);

1564: dbms_sql.column_value(v_cursor, 35, p_no_of_days);
1565: dbms_sql.column_value(v_cursor, 36, p_settle_dates);
1566: dbms_sql.column_value(v_cursor, 37, p_premium_amounts);
1567: dbms_sql.column_value(v_cursor, 38, p_start_dates);
1568: dbms_sql.column_value(v_cursor, 39, p_initial_bases);
1569: dbms_sql.column_value(v_cursor, 40, p_bond_issues);
1570: dbms_sql.column_value(v_cursor, 41, p_coupon_actions);
1571: dbms_sql.column_value(v_cursor, 42, p_coupon_rates);
1572: dbms_sql.column_value(v_cursor, 43, p_margins);

Line 1569: dbms_sql.column_value(v_cursor, 40, p_bond_issues);

1565: dbms_sql.column_value(v_cursor, 36, p_settle_dates);
1566: dbms_sql.column_value(v_cursor, 37, p_premium_amounts);
1567: dbms_sql.column_value(v_cursor, 38, p_start_dates);
1568: dbms_sql.column_value(v_cursor, 39, p_initial_bases);
1569: dbms_sql.column_value(v_cursor, 40, p_bond_issues);
1570: dbms_sql.column_value(v_cursor, 41, p_coupon_actions);
1571: dbms_sql.column_value(v_cursor, 42, p_coupon_rates);
1572: dbms_sql.column_value(v_cursor, 43, p_margins);
1573: dbms_sql.column_value(v_cursor, 44, p_transaction_rates);

Line 1570: dbms_sql.column_value(v_cursor, 41, p_coupon_actions);

1566: dbms_sql.column_value(v_cursor, 37, p_premium_amounts);
1567: dbms_sql.column_value(v_cursor, 38, p_start_dates);
1568: dbms_sql.column_value(v_cursor, 39, p_initial_bases);
1569: dbms_sql.column_value(v_cursor, 40, p_bond_issues);
1570: dbms_sql.column_value(v_cursor, 41, p_coupon_actions);
1571: dbms_sql.column_value(v_cursor, 42, p_coupon_rates);
1572: dbms_sql.column_value(v_cursor, 43, p_margins);
1573: dbms_sql.column_value(v_cursor, 44, p_transaction_rates);
1574: dbms_sql.column_value(v_cursor, 45, p_coupon_freqs);

Line 1571: dbms_sql.column_value(v_cursor, 42, p_coupon_rates);

1567: dbms_sql.column_value(v_cursor, 38, p_start_dates);
1568: dbms_sql.column_value(v_cursor, 39, p_initial_bases);
1569: dbms_sql.column_value(v_cursor, 40, p_bond_issues);
1570: dbms_sql.column_value(v_cursor, 41, p_coupon_actions);
1571: dbms_sql.column_value(v_cursor, 42, p_coupon_rates);
1572: dbms_sql.column_value(v_cursor, 43, p_margins);
1573: dbms_sql.column_value(v_cursor, 44, p_transaction_rates);
1574: dbms_sql.column_value(v_cursor, 45, p_coupon_freqs);
1575: dbms_sql.column_value(v_cursor, 46, p_next_coupon_dates);

Line 1572: dbms_sql.column_value(v_cursor, 43, p_margins);

1568: dbms_sql.column_value(v_cursor, 39, p_initial_bases);
1569: dbms_sql.column_value(v_cursor, 40, p_bond_issues);
1570: dbms_sql.column_value(v_cursor, 41, p_coupon_actions);
1571: dbms_sql.column_value(v_cursor, 42, p_coupon_rates);
1572: dbms_sql.column_value(v_cursor, 43, p_margins);
1573: dbms_sql.column_value(v_cursor, 44, p_transaction_rates);
1574: dbms_sql.column_value(v_cursor, 45, p_coupon_freqs);
1575: dbms_sql.column_value(v_cursor, 46, p_next_coupon_dates);
1576: dbms_sql.column_value(v_cursor, 47, p_day_count_bases);

Line 1573: dbms_sql.column_value(v_cursor, 44, p_transaction_rates);

1569: dbms_sql.column_value(v_cursor, 40, p_bond_issues);
1570: dbms_sql.column_value(v_cursor, 41, p_coupon_actions);
1571: dbms_sql.column_value(v_cursor, 42, p_coupon_rates);
1572: dbms_sql.column_value(v_cursor, 43, p_margins);
1573: dbms_sql.column_value(v_cursor, 44, p_transaction_rates);
1574: dbms_sql.column_value(v_cursor, 45, p_coupon_freqs);
1575: dbms_sql.column_value(v_cursor, 46, p_next_coupon_dates);
1576: dbms_sql.column_value(v_cursor, 47, p_day_count_bases);
1577: dbms_sql.column_value(v_cursor, 48, p_quantity_out);

Line 1574: dbms_sql.column_value(v_cursor, 45, p_coupon_freqs);

1570: dbms_sql.column_value(v_cursor, 41, p_coupon_actions);
1571: dbms_sql.column_value(v_cursor, 42, p_coupon_rates);
1572: dbms_sql.column_value(v_cursor, 43, p_margins);
1573: dbms_sql.column_value(v_cursor, 44, p_transaction_rates);
1574: dbms_sql.column_value(v_cursor, 45, p_coupon_freqs);
1575: dbms_sql.column_value(v_cursor, 46, p_next_coupon_dates);
1576: dbms_sql.column_value(v_cursor, 47, p_day_count_bases);
1577: dbms_sql.column_value(v_cursor, 48, p_quantity_out);
1578: dbms_sql.column_value(v_cursor, 49, p_rounding_type);

Line 1575: dbms_sql.column_value(v_cursor, 46, p_next_coupon_dates);

1571: dbms_sql.column_value(v_cursor, 42, p_coupon_rates);
1572: dbms_sql.column_value(v_cursor, 43, p_margins);
1573: dbms_sql.column_value(v_cursor, 44, p_transaction_rates);
1574: dbms_sql.column_value(v_cursor, 45, p_coupon_freqs);
1575: dbms_sql.column_value(v_cursor, 46, p_next_coupon_dates);
1576: dbms_sql.column_value(v_cursor, 47, p_day_count_bases);
1577: dbms_sql.column_value(v_cursor, 48, p_quantity_out);
1578: dbms_sql.column_value(v_cursor, 49, p_rounding_type);
1579: dbms_sql.column_value(v_cursor, 50, p_day_count_type);

Line 1576: dbms_sql.column_value(v_cursor, 47, p_day_count_bases);

1572: dbms_sql.column_value(v_cursor, 43, p_margins);
1573: dbms_sql.column_value(v_cursor, 44, p_transaction_rates);
1574: dbms_sql.column_value(v_cursor, 45, p_coupon_freqs);
1575: dbms_sql.column_value(v_cursor, 46, p_next_coupon_dates);
1576: dbms_sql.column_value(v_cursor, 47, p_day_count_bases);
1577: dbms_sql.column_value(v_cursor, 48, p_quantity_out);
1578: dbms_sql.column_value(v_cursor, 49, p_rounding_type);
1579: dbms_sql.column_value(v_cursor, 50, p_day_count_type);
1580: dbms_sql.column_value(v_cursor, 51, p_prepaid_interests);

Line 1577: dbms_sql.column_value(v_cursor, 48, p_quantity_out);

1573: dbms_sql.column_value(v_cursor, 44, p_transaction_rates);
1574: dbms_sql.column_value(v_cursor, 45, p_coupon_freqs);
1575: dbms_sql.column_value(v_cursor, 46, p_next_coupon_dates);
1576: dbms_sql.column_value(v_cursor, 47, p_day_count_bases);
1577: dbms_sql.column_value(v_cursor, 48, p_quantity_out);
1578: dbms_sql.column_value(v_cursor, 49, p_rounding_type);
1579: dbms_sql.column_value(v_cursor, 50, p_day_count_type);
1580: dbms_sql.column_value(v_cursor, 51, p_prepaid_interests);
1581:

Line 1578: dbms_sql.column_value(v_cursor, 49, p_rounding_type);

1574: dbms_sql.column_value(v_cursor, 45, p_coupon_freqs);
1575: dbms_sql.column_value(v_cursor, 46, p_next_coupon_dates);
1576: dbms_sql.column_value(v_cursor, 47, p_day_count_bases);
1577: dbms_sql.column_value(v_cursor, 48, p_quantity_out);
1578: dbms_sql.column_value(v_cursor, 49, p_rounding_type);
1579: dbms_sql.column_value(v_cursor, 50, p_day_count_type);
1580: dbms_sql.column_value(v_cursor, 51, p_prepaid_interests);
1581:
1582:

Line 1579: dbms_sql.column_value(v_cursor, 50, p_day_count_type);

1575: dbms_sql.column_value(v_cursor, 46, p_next_coupon_dates);
1576: dbms_sql.column_value(v_cursor, 47, p_day_count_bases);
1577: dbms_sql.column_value(v_cursor, 48, p_quantity_out);
1578: dbms_sql.column_value(v_cursor, 49, p_rounding_type);
1579: dbms_sql.column_value(v_cursor, 50, p_day_count_type);
1580: dbms_sql.column_value(v_cursor, 51, p_prepaid_interests);
1581:
1582:
1583: /*

Line 1580: dbms_sql.column_value(v_cursor, 51, p_prepaid_interests);

1576: dbms_sql.column_value(v_cursor, 47, p_day_count_bases);
1577: dbms_sql.column_value(v_cursor, 48, p_quantity_out);
1578: dbms_sql.column_value(v_cursor, 49, p_rounding_type);
1579: dbms_sql.column_value(v_cursor, 50, p_day_count_type);
1580: dbms_sql.column_value(v_cursor, 51, p_prepaid_interests);
1581:
1582:
1583: /*
1584: IF (g_proc_level>=g_debug_level) THEN

Line 6480: if dbms_sql.is_open(v_cursor) then

6476: end loop;
6477:
6478: EXCEPTION
6479: WHEN OTHERS THEN
6480: if dbms_sql.is_open(v_cursor) then
6481: dbms_sql.close_cursor(v_cursor);
6482: end if;
6483: IF (g_proc_level>=g_debug_level) THEN
6484: XTR_RISK_DEBUG_PKG.dlog('run_analysis: ' || 'unhandled exp during deal retrieval after DML');

Line 6481: dbms_sql.close_cursor(v_cursor);

6477:
6478: EXCEPTION
6479: WHEN OTHERS THEN
6480: if dbms_sql.is_open(v_cursor) then
6481: dbms_sql.close_cursor(v_cursor);
6482: end if;
6483: IF (g_proc_level>=g_debug_level) THEN
6484: XTR_RISK_DEBUG_PKG.dlog('run_analysis: ' || 'unhandled exp during deal retrieval after DML');
6485: END IF;