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 QRM_DATE_TABLE

Line 379: p_att_creation_date SYSTEM.QRM_DATE_TABLE := SYSTEM.QRM_DATE_TABLE();

375: p_att_average SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();
376: p_att_ind SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();
377: p_att_percentage SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();
378: p_att_created_by XTR_MD_NUM_TABLE := XTR_MD_NUM_TABLE();
379: p_att_creation_date SYSTEM.QRM_DATE_TABLE := SYSTEM.QRM_DATE_TABLE();
380: p_att_updated_by XTR_MD_NUM_TABLE := XTR_MD_NUM_TABLE();
381: p_att_update_date SYSTEM.QRM_DATE_TABLE := SYSTEM.QRM_DATE_TABLE();
382: p_att_update_login XTR_MD_NUM_TABLE := XTR_MD_NUM_TABLE();
383:

Line 381: p_att_update_date SYSTEM.QRM_DATE_TABLE := SYSTEM.QRM_DATE_TABLE();

377: p_att_percentage SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();
378: p_att_created_by XTR_MD_NUM_TABLE := XTR_MD_NUM_TABLE();
379: p_att_creation_date SYSTEM.QRM_DATE_TABLE := SYSTEM.QRM_DATE_TABLE();
380: p_att_updated_by XTR_MD_NUM_TABLE := XTR_MD_NUM_TABLE();
381: p_att_update_date SYSTEM.QRM_DATE_TABLE := SYSTEM.QRM_DATE_TABLE();
382: p_att_update_login XTR_MD_NUM_TABLE := XTR_MD_NUM_TABLE();
383:
384: p_filter_where_clause VARCHAR2(3500);
385:

Line 432: p_trans_start_dates SYSTEM.QRM_DATE_TABLE := SYSTEM.QRM_DATE_TABLE();

428: p_last_trans_no NUMBER;
429: p_trans_trans_nos XTR_MD_NUM_TABLE := XTR_MD_NUM_TABLE();
430: p_trans_yield_rates XTR_MD_NUM_TABLE := XTR_MD_NUM_TABLE();
431: p_trans_disc_rates XTR_MD_NUM_TABLE := XTR_MD_NUM_TABLE();
432: p_trans_start_dates SYSTEM.QRM_DATE_TABLE := SYSTEM.QRM_DATE_TABLE();
433: p_trans_maturity_dates SYSTEM.QRM_DATE_TABLE := SYSTEM.QRM_DATE_TABLE();
434: p_trans_settle_dates SYSTEM.QRM_DATE_TABLE := SYSTEM.QRM_DATE_TABLE();
435: p_trans_due_on_dates SYSTEM.QRM_DATE_TABLE := SYSTEM.QRM_DATE_TABLE();
436: p_trans_interest_refunds XTR_MD_NUM_TABLE := XTR_MD_NUM_TABLE();

Line 433: p_trans_maturity_dates SYSTEM.QRM_DATE_TABLE := SYSTEM.QRM_DATE_TABLE();

429: p_trans_trans_nos XTR_MD_NUM_TABLE := XTR_MD_NUM_TABLE();
430: p_trans_yield_rates XTR_MD_NUM_TABLE := XTR_MD_NUM_TABLE();
431: p_trans_disc_rates XTR_MD_NUM_TABLE := XTR_MD_NUM_TABLE();
432: p_trans_start_dates SYSTEM.QRM_DATE_TABLE := SYSTEM.QRM_DATE_TABLE();
433: p_trans_maturity_dates SYSTEM.QRM_DATE_TABLE := SYSTEM.QRM_DATE_TABLE();
434: p_trans_settle_dates SYSTEM.QRM_DATE_TABLE := SYSTEM.QRM_DATE_TABLE();
435: p_trans_due_on_dates SYSTEM.QRM_DATE_TABLE := SYSTEM.QRM_DATE_TABLE();
436: p_trans_interest_refunds XTR_MD_NUM_TABLE := XTR_MD_NUM_TABLE();
437: p_trans_prin_actions SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();

Line 434: p_trans_settle_dates SYSTEM.QRM_DATE_TABLE := SYSTEM.QRM_DATE_TABLE();

430: p_trans_yield_rates XTR_MD_NUM_TABLE := XTR_MD_NUM_TABLE();
431: p_trans_disc_rates XTR_MD_NUM_TABLE := XTR_MD_NUM_TABLE();
432: p_trans_start_dates SYSTEM.QRM_DATE_TABLE := SYSTEM.QRM_DATE_TABLE();
433: p_trans_maturity_dates SYSTEM.QRM_DATE_TABLE := SYSTEM.QRM_DATE_TABLE();
434: p_trans_settle_dates SYSTEM.QRM_DATE_TABLE := SYSTEM.QRM_DATE_TABLE();
435: p_trans_due_on_dates SYSTEM.QRM_DATE_TABLE := SYSTEM.QRM_DATE_TABLE();
436: p_trans_interest_refunds XTR_MD_NUM_TABLE := XTR_MD_NUM_TABLE();
437: p_trans_prin_actions SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();
438: p_trans_interest_settled XTR_MD_NUM_TABLE := XTR_MD_NUM_TABLE();

Line 435: p_trans_due_on_dates SYSTEM.QRM_DATE_TABLE := SYSTEM.QRM_DATE_TABLE();

431: p_trans_disc_rates XTR_MD_NUM_TABLE := XTR_MD_NUM_TABLE();
432: p_trans_start_dates SYSTEM.QRM_DATE_TABLE := SYSTEM.QRM_DATE_TABLE();
433: p_trans_maturity_dates SYSTEM.QRM_DATE_TABLE := SYSTEM.QRM_DATE_TABLE();
434: p_trans_settle_dates SYSTEM.QRM_DATE_TABLE := SYSTEM.QRM_DATE_TABLE();
435: p_trans_due_on_dates SYSTEM.QRM_DATE_TABLE := SYSTEM.QRM_DATE_TABLE();
436: p_trans_interest_refunds XTR_MD_NUM_TABLE := XTR_MD_NUM_TABLE();
437: p_trans_prin_actions SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();
438: p_trans_interest_settled XTR_MD_NUM_TABLE := XTR_MD_NUM_TABLE();
439: p_trans_prin_adjusts XTR_MD_NUM_TABLE := XTR_MD_NUM_TABLE();

Line 483: p_deal_dates SYSTEM.QRM_DATE_TABLE;

479: p_accum_int_bfs XTR_MD_NUM_TABLE;
480: p_accum_int_actions SYSTEM.QRM_VARCHAR_TABLE;
481: p_accrued_interests XTR_MD_NUM_TABLE;
482: p_interests_settled XTR_MD_NUM_TABLE;
483: p_deal_dates SYSTEM.QRM_DATE_TABLE;
484: p_end_dates SYSTEM.QRM_DATE_TABLE;
485: p_gap_dates SYSTEM.QRM_DATE_TABLE;
486: p_deal_subtypes SYSTEM.QRM_VARCHAR_TABLE;
487: p_deal_types SYSTEM.QRM_VARCHAR_TABLE;

Line 484: p_end_dates SYSTEM.QRM_DATE_TABLE;

480: p_accum_int_actions SYSTEM.QRM_VARCHAR_TABLE;
481: p_accrued_interests XTR_MD_NUM_TABLE;
482: p_interests_settled XTR_MD_NUM_TABLE;
483: p_deal_dates SYSTEM.QRM_DATE_TABLE;
484: p_end_dates SYSTEM.QRM_DATE_TABLE;
485: p_gap_dates SYSTEM.QRM_DATE_TABLE;
486: p_deal_subtypes SYSTEM.QRM_VARCHAR_TABLE;
487: p_deal_types SYSTEM.QRM_VARCHAR_TABLE;
488: p_discount_yields SYSTEM.QRM_VARCHAR_TABLE;

Line 485: p_gap_dates SYSTEM.QRM_DATE_TABLE;

481: p_accrued_interests XTR_MD_NUM_TABLE;
482: p_interests_settled XTR_MD_NUM_TABLE;
483: p_deal_dates SYSTEM.QRM_DATE_TABLE;
484: p_end_dates SYSTEM.QRM_DATE_TABLE;
485: p_gap_dates SYSTEM.QRM_DATE_TABLE;
486: p_deal_subtypes SYSTEM.QRM_VARCHAR_TABLE;
487: p_deal_types SYSTEM.QRM_VARCHAR_TABLE;
488: p_discount_yields SYSTEM.QRM_VARCHAR_TABLE;
489: p_maturity_dates SYSTEM.QRM_DATE_TABLE;

Line 489: p_maturity_dates SYSTEM.QRM_DATE_TABLE;

485: p_gap_dates SYSTEM.QRM_DATE_TABLE;
486: p_deal_subtypes SYSTEM.QRM_VARCHAR_TABLE;
487: p_deal_types SYSTEM.QRM_VARCHAR_TABLE;
488: p_discount_yields SYSTEM.QRM_VARCHAR_TABLE;
489: p_maturity_dates SYSTEM.QRM_DATE_TABLE;
490: p_no_of_days XTR_MD_NUM_TABLE;
491: p_settle_dates SYSTEM.QRM_DATE_TABLE;
492: p_premium_amounts XTR_MD_NUM_TABLE;
493: p_start_dates SYSTEM.QRM_DATE_TABLE;

Line 491: p_settle_dates SYSTEM.QRM_DATE_TABLE;

487: p_deal_types SYSTEM.QRM_VARCHAR_TABLE;
488: p_discount_yields SYSTEM.QRM_VARCHAR_TABLE;
489: p_maturity_dates SYSTEM.QRM_DATE_TABLE;
490: p_no_of_days XTR_MD_NUM_TABLE;
491: p_settle_dates SYSTEM.QRM_DATE_TABLE;
492: p_premium_amounts XTR_MD_NUM_TABLE;
493: p_start_dates SYSTEM.QRM_DATE_TABLE;
494: p_initial_bases SYSTEM.QRM_VARCHAR_TABLE;
495: p_bond_issues SYSTEM.QRM_VARCHAR_TABLE;

Line 493: p_start_dates SYSTEM.QRM_DATE_TABLE;

489: p_maturity_dates SYSTEM.QRM_DATE_TABLE;
490: p_no_of_days XTR_MD_NUM_TABLE;
491: p_settle_dates SYSTEM.QRM_DATE_TABLE;
492: p_premium_amounts XTR_MD_NUM_TABLE;
493: p_start_dates SYSTEM.QRM_DATE_TABLE;
494: p_initial_bases SYSTEM.QRM_VARCHAR_TABLE;
495: p_bond_issues SYSTEM.QRM_VARCHAR_TABLE;
496: p_coupon_actions SYSTEM.QRM_VARCHAR_TABLE;
497: p_coupon_rates XTR_MD_NUM_TABLE;

Line 501: p_next_coupon_dates SYSTEM.QRM_DATE_TABLE;

497: p_coupon_rates XTR_MD_NUM_TABLE;
498: p_margins XTR_MD_NUM_TABLE;
499: p_transaction_rates XTR_MD_NUM_TABLE;
500: p_coupon_freqs XTR_MD_NUM_TABLE;
501: p_next_coupon_dates SYSTEM.QRM_DATE_TABLE;
502: p_day_count_bases SYSTEM.QRM_VARCHAR_TABLE;
503: -- QUANTITY OUTSTANDING
504: p_quantity_out XTR_MD_NUM_TABLE;
505: p_rounding_type SYSTEM.QRM_VARCHAR_TABLE;

Line 833: p_gap_date_insert SYSTEM.QRM_DATE_TABLE :=

829: p_volatility_temp XTR_MD_NUM_TABLE := XTR_MD_NUM_TABLE();
830: p_ytm_temp XTR_MD_NUM_TABLE := XTR_MD_NUM_TABLE();
831: p_ytm_insert XTR_MD_NUM_TABLE := XTR_MD_NUM_TABLE();
832: p_ytm_update XTR_MD_NUM_TABLE := XTR_MD_NUM_TABLE();
833: p_gap_date_insert SYSTEM.QRM_DATE_TABLE :=
834: SYSTEM.QRM_DATE_TABLE();
835: p_gap_date_update SYSTEM.QRM_DATE_TABLE :=
836: SYSTEM.QRM_DATE_TABLE();
837: p_gap_date_temp SYSTEM.QRM_DATE_TABLE :=

Line 834: SYSTEM.QRM_DATE_TABLE();

830: p_ytm_temp XTR_MD_NUM_TABLE := XTR_MD_NUM_TABLE();
831: p_ytm_insert XTR_MD_NUM_TABLE := XTR_MD_NUM_TABLE();
832: p_ytm_update XTR_MD_NUM_TABLE := XTR_MD_NUM_TABLE();
833: p_gap_date_insert SYSTEM.QRM_DATE_TABLE :=
834: SYSTEM.QRM_DATE_TABLE();
835: p_gap_date_update SYSTEM.QRM_DATE_TABLE :=
836: SYSTEM.QRM_DATE_TABLE();
837: p_gap_date_temp SYSTEM.QRM_DATE_TABLE :=
838: SYSTEM.QRM_DATE_TABLE();

Line 835: p_gap_date_update SYSTEM.QRM_DATE_TABLE :=

831: p_ytm_insert XTR_MD_NUM_TABLE := XTR_MD_NUM_TABLE();
832: p_ytm_update XTR_MD_NUM_TABLE := XTR_MD_NUM_TABLE();
833: p_gap_date_insert SYSTEM.QRM_DATE_TABLE :=
834: SYSTEM.QRM_DATE_TABLE();
835: p_gap_date_update SYSTEM.QRM_DATE_TABLE :=
836: SYSTEM.QRM_DATE_TABLE();
837: p_gap_date_temp SYSTEM.QRM_DATE_TABLE :=
838: SYSTEM.QRM_DATE_TABLE();
839: p_upd_md_calc_date_temp SYSTEM.QRM_DATE_TABLE :=

Line 836: SYSTEM.QRM_DATE_TABLE();

832: p_ytm_update XTR_MD_NUM_TABLE := XTR_MD_NUM_TABLE();
833: p_gap_date_insert SYSTEM.QRM_DATE_TABLE :=
834: SYSTEM.QRM_DATE_TABLE();
835: p_gap_date_update SYSTEM.QRM_DATE_TABLE :=
836: SYSTEM.QRM_DATE_TABLE();
837: p_gap_date_temp SYSTEM.QRM_DATE_TABLE :=
838: SYSTEM.QRM_DATE_TABLE();
839: p_upd_md_calc_date_temp SYSTEM.QRM_DATE_TABLE :=
840: SYSTEM.QRM_DATE_TABLE();

Line 837: p_gap_date_temp SYSTEM.QRM_DATE_TABLE :=

833: p_gap_date_insert SYSTEM.QRM_DATE_TABLE :=
834: SYSTEM.QRM_DATE_TABLE();
835: p_gap_date_update SYSTEM.QRM_DATE_TABLE :=
836: SYSTEM.QRM_DATE_TABLE();
837: p_gap_date_temp SYSTEM.QRM_DATE_TABLE :=
838: SYSTEM.QRM_DATE_TABLE();
839: p_upd_md_calc_date_temp SYSTEM.QRM_DATE_TABLE :=
840: SYSTEM.QRM_DATE_TABLE();
841: p_upd_md_calc_date_update SYSTEM.QRM_DATE_TABLE :=

Line 838: SYSTEM.QRM_DATE_TABLE();

834: SYSTEM.QRM_DATE_TABLE();
835: p_gap_date_update SYSTEM.QRM_DATE_TABLE :=
836: SYSTEM.QRM_DATE_TABLE();
837: p_gap_date_temp SYSTEM.QRM_DATE_TABLE :=
838: SYSTEM.QRM_DATE_TABLE();
839: p_upd_md_calc_date_temp SYSTEM.QRM_DATE_TABLE :=
840: SYSTEM.QRM_DATE_TABLE();
841: p_upd_md_calc_date_update SYSTEM.QRM_DATE_TABLE :=
842: SYSTEM.QRM_DATE_TABLE();

Line 839: p_upd_md_calc_date_temp SYSTEM.QRM_DATE_TABLE :=

835: p_gap_date_update SYSTEM.QRM_DATE_TABLE :=
836: SYSTEM.QRM_DATE_TABLE();
837: p_gap_date_temp SYSTEM.QRM_DATE_TABLE :=
838: SYSTEM.QRM_DATE_TABLE();
839: p_upd_md_calc_date_temp SYSTEM.QRM_DATE_TABLE :=
840: SYSTEM.QRM_DATE_TABLE();
841: p_upd_md_calc_date_update SYSTEM.QRM_DATE_TABLE :=
842: SYSTEM.QRM_DATE_TABLE();
843:

Line 840: SYSTEM.QRM_DATE_TABLE();

836: SYSTEM.QRM_DATE_TABLE();
837: p_gap_date_temp SYSTEM.QRM_DATE_TABLE :=
838: SYSTEM.QRM_DATE_TABLE();
839: p_upd_md_calc_date_temp SYSTEM.QRM_DATE_TABLE :=
840: SYSTEM.QRM_DATE_TABLE();
841: p_upd_md_calc_date_update SYSTEM.QRM_DATE_TABLE :=
842: SYSTEM.QRM_DATE_TABLE();
843:
844: -- tb calculations

Line 841: p_upd_md_calc_date_update SYSTEM.QRM_DATE_TABLE :=

837: p_gap_date_temp SYSTEM.QRM_DATE_TABLE :=
838: SYSTEM.QRM_DATE_TABLE();
839: p_upd_md_calc_date_temp SYSTEM.QRM_DATE_TABLE :=
840: SYSTEM.QRM_DATE_TABLE();
841: p_upd_md_calc_date_update SYSTEM.QRM_DATE_TABLE :=
842: SYSTEM.QRM_DATE_TABLE();
843:
844: -- tb calculations
845: p_tb_counter NUMBER := 0;

Line 842: SYSTEM.QRM_DATE_TABLE();

838: SYSTEM.QRM_DATE_TABLE();
839: p_upd_md_calc_date_temp SYSTEM.QRM_DATE_TABLE :=
840: SYSTEM.QRM_DATE_TABLE();
841: p_upd_md_calc_date_update SYSTEM.QRM_DATE_TABLE :=
842: SYSTEM.QRM_DATE_TABLE();
843:
844: -- tb calculations
845: p_tb_counter NUMBER := 0;
846: p_tb_curr_deal_no NUMBER := -4; -- dummy

Line 850: p_tb_pos_start_date SYSTEM.QRM_DATE_TABLE := SYSTEM.QRM_DATE_TABLE();

846: p_tb_curr_deal_no NUMBER := -4; -- dummy
847: p_tb_deal_no XTR_MD_NUM_TABLE := XTR_MD_NUM_TABLE();
848: p_tb_transaction_no XTR_MD_NUM_TABLE := XTR_MD_NUM_TABLE();
849: p_tb_market_data_set SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();
850: p_tb_pos_start_date SYSTEM.QRM_DATE_TABLE := SYSTEM.QRM_DATE_TABLE();
851: p_tb_pos_end_date SYSTEM.QRM_DATE_TABLE := SYSTEM.QRM_DATE_TABLE();
852: p_tb_start_date SYSTEM.QRM_DATE_TABLE := SYSTEM.QRM_DATE_TABLE();
853: p_tb_end_date SYSTEM.QRM_DATE_TABLE := SYSTEM.QRM_DATE_TABLE();
854: p_tb_interest_basis SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();

Line 851: p_tb_pos_end_date SYSTEM.QRM_DATE_TABLE := SYSTEM.QRM_DATE_TABLE();

847: p_tb_deal_no XTR_MD_NUM_TABLE := XTR_MD_NUM_TABLE();
848: p_tb_transaction_no XTR_MD_NUM_TABLE := XTR_MD_NUM_TABLE();
849: p_tb_market_data_set SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();
850: p_tb_pos_start_date SYSTEM.QRM_DATE_TABLE := SYSTEM.QRM_DATE_TABLE();
851: p_tb_pos_end_date SYSTEM.QRM_DATE_TABLE := SYSTEM.QRM_DATE_TABLE();
852: p_tb_start_date SYSTEM.QRM_DATE_TABLE := SYSTEM.QRM_DATE_TABLE();
853: p_tb_end_date SYSTEM.QRM_DATE_TABLE := SYSTEM.QRM_DATE_TABLE();
854: p_tb_interest_basis SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();
855: p_tb_outst_amount XTR_MD_NUM_TABLE := XTR_MD_NUM_TABLE();

Line 852: p_tb_start_date SYSTEM.QRM_DATE_TABLE := SYSTEM.QRM_DATE_TABLE();

848: p_tb_transaction_no XTR_MD_NUM_TABLE := XTR_MD_NUM_TABLE();
849: p_tb_market_data_set SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();
850: p_tb_pos_start_date SYSTEM.QRM_DATE_TABLE := SYSTEM.QRM_DATE_TABLE();
851: p_tb_pos_end_date SYSTEM.QRM_DATE_TABLE := SYSTEM.QRM_DATE_TABLE();
852: p_tb_start_date SYSTEM.QRM_DATE_TABLE := SYSTEM.QRM_DATE_TABLE();
853: p_tb_end_date SYSTEM.QRM_DATE_TABLE := SYSTEM.QRM_DATE_TABLE();
854: p_tb_interest_basis SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();
855: p_tb_outst_amount XTR_MD_NUM_TABLE := XTR_MD_NUM_TABLE();
856: p_tb_outst_amount_usd XTR_MD_NUM_TABLE := XTR_MD_NUM_TABLE();

Line 853: p_tb_end_date SYSTEM.QRM_DATE_TABLE := SYSTEM.QRM_DATE_TABLE();

849: p_tb_market_data_set SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();
850: p_tb_pos_start_date SYSTEM.QRM_DATE_TABLE := SYSTEM.QRM_DATE_TABLE();
851: p_tb_pos_end_date SYSTEM.QRM_DATE_TABLE := SYSTEM.QRM_DATE_TABLE();
852: p_tb_start_date SYSTEM.QRM_DATE_TABLE := SYSTEM.QRM_DATE_TABLE();
853: p_tb_end_date SYSTEM.QRM_DATE_TABLE := SYSTEM.QRM_DATE_TABLE();
854: p_tb_interest_basis SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();
855: p_tb_outst_amount XTR_MD_NUM_TABLE := XTR_MD_NUM_TABLE();
856: p_tb_outst_amount_usd XTR_MD_NUM_TABLE := XTR_MD_NUM_TABLE();
857: p_tb_outst_amount_sob XTR_MD_NUM_TABLE := XTR_MD_NUM_TABLE();

Line 862: p_tb_next_coupon_date SYSTEM.QRM_DATE_TABLE := SYSTEM.QRM_DATE_TABLE();

858: p_tb_amt_qty_out XTR_MD_NUM_TABLE := XTR_MD_NUM_TABLE();
859: p_tb_amt_qty_out_usd XTR_MD_NUM_TABLE := XTR_MD_NUM_TABLE();
860: p_tb_amt_qty_out_sob XTR_MD_NUM_TABLE := XTR_MD_NUM_TABLE();
861: p_tb_coupon_rate XTR_MD_NUM_TABLE := XTR_MD_NUM_TABLE();
862: p_tb_next_coupon_date SYSTEM.QRM_DATE_TABLE := SYSTEM.QRM_DATE_TABLE();
863:
864: -- exceptions
865: p_error_type VARCHAR2(1) := 'W'; -- default to warning
866: p_except_counter NUMBER := 0;