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_VARCHAR_TABLE

Line 33: PROCEDURE run_analysis_am (p_analysis_names IN SYSTEM.QRM_VARCHAR_TABLE,

29: END run_analysis_cp;
30:
31:
32:
33: PROCEDURE run_analysis_am (p_analysis_names IN SYSTEM.QRM_VARCHAR_TABLE,
34: p_ref_datetime IN DATE)
35:
36: IS
37:

Line 372: p_att_name SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();

368: p_settings get_settings%ROWTYPE;
369: p_deal_calculations deal_calculated%ROWTYPE;
370: -- for saving a copy of attributes
371: p_att_counter NUMBER := 0;
372: p_att_name SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();
373: p_att_type SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();
374: p_att_order XTR_MD_NUM_TABLE := XTR_MD_NUM_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();

Line 373: p_att_type SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();

369: p_deal_calculations deal_calculated%ROWTYPE;
370: -- for saving a copy of attributes
371: p_att_counter NUMBER := 0;
372: p_att_name SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();
373: p_att_type SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();
374: p_att_order XTR_MD_NUM_TABLE := XTR_MD_NUM_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();

Line 375: p_att_average SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();

371: p_att_counter NUMBER := 0;
372: p_att_name SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();
373: p_att_type SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();
374: p_att_order XTR_MD_NUM_TABLE := XTR_MD_NUM_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();

Line 376: p_att_ind SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();

372: p_att_name SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();
373: p_att_type SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();
374: p_att_order XTR_MD_NUM_TABLE := XTR_MD_NUM_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();

Line 377: p_att_percentage SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();

373: p_att_type SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();
374: p_att_order XTR_MD_NUM_TABLE := XTR_MD_NUM_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();

Line 437: p_trans_prin_actions SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_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();
440: p_trans_accum_interests XTR_MD_NUM_TABLE := XTR_MD_NUM_TABLE();
441: p_trans_accum_interests_bf XTR_MD_NUM_TABLE := XTR_MD_NUM_TABLE();

Line 443: p_trans_settle_term_interest SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();

439: p_trans_prin_adjusts XTR_MD_NUM_TABLE := XTR_MD_NUM_TABLE();
440: p_trans_accum_interests XTR_MD_NUM_TABLE := XTR_MD_NUM_TABLE();
441: p_trans_accum_interests_bf XTR_MD_NUM_TABLE := XTR_MD_NUM_TABLE();
442: p_trans_balance_outs XTR_MD_NUM_TABLE := XTR_MD_NUM_TABLE();
443: p_trans_settle_term_interest SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();
444: -- IRO --
445: p_spot_rate NUMBER;
446: p_days_start NUMBER;
447: p_days_mature NUMBER;

Line 458: p_market_data_sets SYSTEM.QRM_VARCHAR_TABLE;

454:
455: /*
456: p_deal_nos XTR_MD_NUM_TABLE;
457: p_transaction_nos XTR_MD_NUM_TABLE;
458: p_market_data_sets SYSTEM.QRM_VARCHAR_TABLE;
459: p_company_codes SYSTEM.QRM_VARCHAR_TABLE;
460: p_calls_or_puts SYSTEM.QRM_VARCHAR_TABLE;
461: p_pricing_models SYSTEM.QRM_VARCHAR_TABLE;
462: p_deal_ccys SYSTEM.QRM_VARCHAR_TABLE;

Line 459: p_company_codes SYSTEM.QRM_VARCHAR_TABLE;

455: /*
456: p_deal_nos XTR_MD_NUM_TABLE;
457: p_transaction_nos XTR_MD_NUM_TABLE;
458: p_market_data_sets SYSTEM.QRM_VARCHAR_TABLE;
459: p_company_codes SYSTEM.QRM_VARCHAR_TABLE;
460: p_calls_or_puts SYSTEM.QRM_VARCHAR_TABLE;
461: p_pricing_models SYSTEM.QRM_VARCHAR_TABLE;
462: p_deal_ccys SYSTEM.QRM_VARCHAR_TABLE;
463: p_buy_ccys SYSTEM.QRM_VARCHAR_TABLE;

Line 460: p_calls_or_puts SYSTEM.QRM_VARCHAR_TABLE;

456: p_deal_nos XTR_MD_NUM_TABLE;
457: p_transaction_nos XTR_MD_NUM_TABLE;
458: p_market_data_sets SYSTEM.QRM_VARCHAR_TABLE;
459: p_company_codes SYSTEM.QRM_VARCHAR_TABLE;
460: p_calls_or_puts SYSTEM.QRM_VARCHAR_TABLE;
461: p_pricing_models SYSTEM.QRM_VARCHAR_TABLE;
462: p_deal_ccys SYSTEM.QRM_VARCHAR_TABLE;
463: p_buy_ccys SYSTEM.QRM_VARCHAR_TABLE;
464: p_sell_ccys SYSTEM.QRM_VARCHAR_TABLE;

Line 461: p_pricing_models SYSTEM.QRM_VARCHAR_TABLE;

457: p_transaction_nos XTR_MD_NUM_TABLE;
458: p_market_data_sets SYSTEM.QRM_VARCHAR_TABLE;
459: p_company_codes SYSTEM.QRM_VARCHAR_TABLE;
460: p_calls_or_puts SYSTEM.QRM_VARCHAR_TABLE;
461: p_pricing_models SYSTEM.QRM_VARCHAR_TABLE;
462: p_deal_ccys SYSTEM.QRM_VARCHAR_TABLE;
463: p_buy_ccys SYSTEM.QRM_VARCHAR_TABLE;
464: p_sell_ccys SYSTEM.QRM_VARCHAR_TABLE;
465: p_foreign_ccys SYSTEM.QRM_VARCHAR_TABLE;

Line 462: p_deal_ccys SYSTEM.QRM_VARCHAR_TABLE;

458: p_market_data_sets SYSTEM.QRM_VARCHAR_TABLE;
459: p_company_codes SYSTEM.QRM_VARCHAR_TABLE;
460: p_calls_or_puts SYSTEM.QRM_VARCHAR_TABLE;
461: p_pricing_models SYSTEM.QRM_VARCHAR_TABLE;
462: p_deal_ccys SYSTEM.QRM_VARCHAR_TABLE;
463: p_buy_ccys SYSTEM.QRM_VARCHAR_TABLE;
464: p_sell_ccys SYSTEM.QRM_VARCHAR_TABLE;
465: p_foreign_ccys SYSTEM.QRM_VARCHAR_TABLE;
466: p_domestic_ccys SYSTEM.QRM_VARCHAR_TABLE;

Line 463: p_buy_ccys SYSTEM.QRM_VARCHAR_TABLE;

459: p_company_codes SYSTEM.QRM_VARCHAR_TABLE;
460: p_calls_or_puts SYSTEM.QRM_VARCHAR_TABLE;
461: p_pricing_models SYSTEM.QRM_VARCHAR_TABLE;
462: p_deal_ccys SYSTEM.QRM_VARCHAR_TABLE;
463: p_buy_ccys SYSTEM.QRM_VARCHAR_TABLE;
464: p_sell_ccys SYSTEM.QRM_VARCHAR_TABLE;
465: p_foreign_ccys SYSTEM.QRM_VARCHAR_TABLE;
466: p_domestic_ccys SYSTEM.QRM_VARCHAR_TABLE;
467: p_base_ccys SYSTEM.QRM_VARCHAR_TABLE;

Line 464: p_sell_ccys SYSTEM.QRM_VARCHAR_TABLE;

460: p_calls_or_puts SYSTEM.QRM_VARCHAR_TABLE;
461: p_pricing_models SYSTEM.QRM_VARCHAR_TABLE;
462: p_deal_ccys SYSTEM.QRM_VARCHAR_TABLE;
463: p_buy_ccys SYSTEM.QRM_VARCHAR_TABLE;
464: p_sell_ccys SYSTEM.QRM_VARCHAR_TABLE;
465: p_foreign_ccys SYSTEM.QRM_VARCHAR_TABLE;
466: p_domestic_ccys SYSTEM.QRM_VARCHAR_TABLE;
467: p_base_ccys SYSTEM.QRM_VARCHAR_TABLE;
468: p_contra_ccys SYSTEM.QRM_VARCHAR_TABLE;

Line 465: p_foreign_ccys SYSTEM.QRM_VARCHAR_TABLE;

461: p_pricing_models SYSTEM.QRM_VARCHAR_TABLE;
462: p_deal_ccys SYSTEM.QRM_VARCHAR_TABLE;
463: p_buy_ccys SYSTEM.QRM_VARCHAR_TABLE;
464: p_sell_ccys SYSTEM.QRM_VARCHAR_TABLE;
465: p_foreign_ccys SYSTEM.QRM_VARCHAR_TABLE;
466: p_domestic_ccys SYSTEM.QRM_VARCHAR_TABLE;
467: p_base_ccys SYSTEM.QRM_VARCHAR_TABLE;
468: p_contra_ccys SYSTEM.QRM_VARCHAR_TABLE;
469: p_premium_ccys SYSTEM.QRM_VARCHAR_TABLE;

Line 466: p_domestic_ccys SYSTEM.QRM_VARCHAR_TABLE;

462: p_deal_ccys SYSTEM.QRM_VARCHAR_TABLE;
463: p_buy_ccys SYSTEM.QRM_VARCHAR_TABLE;
464: p_sell_ccys SYSTEM.QRM_VARCHAR_TABLE;
465: p_foreign_ccys SYSTEM.QRM_VARCHAR_TABLE;
466: p_domestic_ccys SYSTEM.QRM_VARCHAR_TABLE;
467: p_base_ccys SYSTEM.QRM_VARCHAR_TABLE;
468: p_contra_ccys SYSTEM.QRM_VARCHAR_TABLE;
469: p_premium_ccys SYSTEM.QRM_VARCHAR_TABLE;
470: p_buy_amounts XTR_MD_NUM_TABLE;

Line 467: p_base_ccys SYSTEM.QRM_VARCHAR_TABLE;

463: p_buy_ccys SYSTEM.QRM_VARCHAR_TABLE;
464: p_sell_ccys SYSTEM.QRM_VARCHAR_TABLE;
465: p_foreign_ccys SYSTEM.QRM_VARCHAR_TABLE;
466: p_domestic_ccys SYSTEM.QRM_VARCHAR_TABLE;
467: p_base_ccys SYSTEM.QRM_VARCHAR_TABLE;
468: p_contra_ccys SYSTEM.QRM_VARCHAR_TABLE;
469: p_premium_ccys SYSTEM.QRM_VARCHAR_TABLE;
470: p_buy_amounts XTR_MD_NUM_TABLE;
471: p_sell_amounts XTR_MD_NUM_TABLE;

Line 468: p_contra_ccys SYSTEM.QRM_VARCHAR_TABLE;

464: p_sell_ccys SYSTEM.QRM_VARCHAR_TABLE;
465: p_foreign_ccys SYSTEM.QRM_VARCHAR_TABLE;
466: p_domestic_ccys SYSTEM.QRM_VARCHAR_TABLE;
467: p_base_ccys SYSTEM.QRM_VARCHAR_TABLE;
468: p_contra_ccys SYSTEM.QRM_VARCHAR_TABLE;
469: p_premium_ccys SYSTEM.QRM_VARCHAR_TABLE;
470: p_buy_amounts XTR_MD_NUM_TABLE;
471: p_sell_amounts XTR_MD_NUM_TABLE;
472: p_foreign_amounts XTR_MD_NUM_TABLE;

Line 469: p_premium_ccys SYSTEM.QRM_VARCHAR_TABLE;

465: p_foreign_ccys SYSTEM.QRM_VARCHAR_TABLE;
466: p_domestic_ccys SYSTEM.QRM_VARCHAR_TABLE;
467: p_base_ccys SYSTEM.QRM_VARCHAR_TABLE;
468: p_contra_ccys SYSTEM.QRM_VARCHAR_TABLE;
469: p_premium_ccys SYSTEM.QRM_VARCHAR_TABLE;
470: p_buy_amounts XTR_MD_NUM_TABLE;
471: p_sell_amounts XTR_MD_NUM_TABLE;
472: p_foreign_amounts XTR_MD_NUM_TABLE;
473: p_domestic_amounts XTR_MD_NUM_TABLE;

Line 480: p_accum_int_actions SYSTEM.QRM_VARCHAR_TABLE;

476: p_start_amounts XTR_MD_NUM_TABLE;
477: p_face_values XTR_MD_NUM_TABLE;
478: p_interests XTR_MD_NUM_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;

Line 486: p_deal_subtypes SYSTEM.QRM_VARCHAR_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;
490: p_no_of_days XTR_MD_NUM_TABLE;

Line 487: p_deal_types SYSTEM.QRM_VARCHAR_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;
490: p_no_of_days XTR_MD_NUM_TABLE;
491: p_settle_dates SYSTEM.QRM_DATE_TABLE;

Line 488: p_discount_yields SYSTEM.QRM_VARCHAR_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;
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;

Line 494: p_initial_bases SYSTEM.QRM_VARCHAR_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;
498: p_margins XTR_MD_NUM_TABLE;

Line 495: p_bond_issues SYSTEM.QRM_VARCHAR_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;
498: p_margins XTR_MD_NUM_TABLE;
499: p_transaction_rates XTR_MD_NUM_TABLE;

Line 496: p_coupon_actions SYSTEM.QRM_VARCHAR_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;
498: p_margins XTR_MD_NUM_TABLE;
499: p_transaction_rates XTR_MD_NUM_TABLE;
500: p_coupon_freqs XTR_MD_NUM_TABLE;

Line 502: p_day_count_bases SYSTEM.QRM_VARCHAR_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;
506: p_day_count_type SYSTEM.QRM_VARCHAR_TABLE;

Line 505: p_rounding_type SYSTEM.QRM_VARCHAR_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;
506: p_day_count_type SYSTEM.QRM_VARCHAR_TABLE;
507: p_prepaid_interests SYSTEM.QRM_VARCHAR_TABLE;
508: */
509:

Line 506: p_day_count_type SYSTEM.QRM_VARCHAR_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;
506: p_day_count_type SYSTEM.QRM_VARCHAR_TABLE;
507: p_prepaid_interests SYSTEM.QRM_VARCHAR_TABLE;
508: */
509:
510:

Line 507: p_prepaid_interests SYSTEM.QRM_VARCHAR_TABLE;

503: -- QUANTITY OUTSTANDING
504: p_quantity_out XTR_MD_NUM_TABLE;
505: p_rounding_type SYSTEM.QRM_VARCHAR_TABLE;
506: p_day_count_type SYSTEM.QRM_VARCHAR_TABLE;
507: p_prepaid_interests SYSTEM.QRM_VARCHAR_TABLE;
508: */
509:
510:
511: p_deal_nos DBMS_SQL.NUMBER_TABLE;

Line 575: p_company_code_insert SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();

571: p_seq_nos XTR_MD_NUM_TABLE := XTR_MD_NUM_TABLE();
572: p_deal_no_insert XTR_MD_NUM_TABLE := XTR_MD_NUM_TABLE();
573: p_deal_no_update XTR_MD_NUM_TABLE := XTR_MD_NUM_TABLE();
574: p_deal_no_temp XTR_MD_NUM_TABLE := XTR_MD_NUM_TABLE();
575: p_company_code_insert SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();
576: p_company_code_update SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();
577: p_company_code_temp SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();
578: p_transaction_no_insert XTR_MD_NUM_TABLE := XTR_MD_NUM_TABLE();
579: p_transaction_no_update XTR_MD_NUM_TABLE := XTR_MD_NUM_TABLE();

Line 576: p_company_code_update SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();

572: p_deal_no_insert XTR_MD_NUM_TABLE := XTR_MD_NUM_TABLE();
573: p_deal_no_update XTR_MD_NUM_TABLE := XTR_MD_NUM_TABLE();
574: p_deal_no_temp XTR_MD_NUM_TABLE := XTR_MD_NUM_TABLE();
575: p_company_code_insert SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();
576: p_company_code_update SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();
577: p_company_code_temp SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();
578: p_transaction_no_insert XTR_MD_NUM_TABLE := XTR_MD_NUM_TABLE();
579: p_transaction_no_update XTR_MD_NUM_TABLE := XTR_MD_NUM_TABLE();
580: p_transaction_no_temp XTR_MD_NUM_TABLE := XTR_MD_NUM_TABLE();

Line 577: p_company_code_temp SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();

573: p_deal_no_update XTR_MD_NUM_TABLE := XTR_MD_NUM_TABLE();
574: p_deal_no_temp XTR_MD_NUM_TABLE := XTR_MD_NUM_TABLE();
575: p_company_code_insert SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();
576: p_company_code_update SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();
577: p_company_code_temp SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();
578: p_transaction_no_insert XTR_MD_NUM_TABLE := XTR_MD_NUM_TABLE();
579: p_transaction_no_update XTR_MD_NUM_TABLE := XTR_MD_NUM_TABLE();
580: p_transaction_no_temp XTR_MD_NUM_TABLE := XTR_MD_NUM_TABLE();
581: p_market_data_set_insert SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();

Line 581: p_market_data_set_insert SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();

577: p_company_code_temp SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();
578: p_transaction_no_insert XTR_MD_NUM_TABLE := XTR_MD_NUM_TABLE();
579: p_transaction_no_update XTR_MD_NUM_TABLE := XTR_MD_NUM_TABLE();
580: p_transaction_no_temp XTR_MD_NUM_TABLE := XTR_MD_NUM_TABLE();
581: p_market_data_set_insert SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();
582: p_market_data_set_update SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();
583: p_market_data_set_temp SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();
584: p_deal_ccy_insert SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();
585: p_deal_ccy_update SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();

Line 582: p_market_data_set_update SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();

578: p_transaction_no_insert XTR_MD_NUM_TABLE := XTR_MD_NUM_TABLE();
579: p_transaction_no_update XTR_MD_NUM_TABLE := XTR_MD_NUM_TABLE();
580: p_transaction_no_temp XTR_MD_NUM_TABLE := XTR_MD_NUM_TABLE();
581: p_market_data_set_insert SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();
582: p_market_data_set_update SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();
583: p_market_data_set_temp SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();
584: p_deal_ccy_insert SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();
585: p_deal_ccy_update SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();
586: p_deal_ccy_temp SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();

Line 583: p_market_data_set_temp SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();

579: p_transaction_no_update XTR_MD_NUM_TABLE := XTR_MD_NUM_TABLE();
580: p_transaction_no_temp XTR_MD_NUM_TABLE := XTR_MD_NUM_TABLE();
581: p_market_data_set_insert SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();
582: p_market_data_set_update SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();
583: p_market_data_set_temp SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();
584: p_deal_ccy_insert SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();
585: p_deal_ccy_update SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();
586: p_deal_ccy_temp SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();
587: p_sob_ccy_insert SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();

Line 584: p_deal_ccy_insert SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();

580: p_transaction_no_temp XTR_MD_NUM_TABLE := XTR_MD_NUM_TABLE();
581: p_market_data_set_insert SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();
582: p_market_data_set_update SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();
583: p_market_data_set_temp SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();
584: p_deal_ccy_insert SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();
585: p_deal_ccy_update SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();
586: p_deal_ccy_temp SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();
587: p_sob_ccy_insert SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();
588: p_sob_ccy_update SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();

Line 585: p_deal_ccy_update SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();

581: p_market_data_set_insert SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();
582: p_market_data_set_update SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();
583: p_market_data_set_temp SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();
584: p_deal_ccy_insert SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();
585: p_deal_ccy_update SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();
586: p_deal_ccy_temp SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();
587: p_sob_ccy_insert SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();
588: p_sob_ccy_update SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();
589: p_sob_ccy_temp SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();

Line 586: p_deal_ccy_temp SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();

582: p_market_data_set_update SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();
583: p_market_data_set_temp SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();
584: p_deal_ccy_insert SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();
585: p_deal_ccy_update SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();
586: p_deal_ccy_temp SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();
587: p_sob_ccy_insert SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();
588: p_sob_ccy_update SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();
589: p_sob_ccy_temp SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();
590: p_base_ccy_amount_usd_insert XTR_MD_NUM_TABLE := XTR_MD_NUM_TABLE();

Line 587: p_sob_ccy_insert SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();

583: p_market_data_set_temp SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();
584: p_deal_ccy_insert SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();
585: p_deal_ccy_update SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();
586: p_deal_ccy_temp SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();
587: p_sob_ccy_insert SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();
588: p_sob_ccy_update SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();
589: p_sob_ccy_temp SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();
590: p_base_ccy_amount_usd_insert XTR_MD_NUM_TABLE := XTR_MD_NUM_TABLE();
591: p_base_ccy_amount_usd_update XTR_MD_NUM_TABLE := XTR_MD_NUM_TABLE();

Line 588: p_sob_ccy_update SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();

584: p_deal_ccy_insert SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();
585: p_deal_ccy_update SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();
586: p_deal_ccy_temp SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();
587: p_sob_ccy_insert SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();
588: p_sob_ccy_update SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();
589: p_sob_ccy_temp SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();
590: p_base_ccy_amount_usd_insert XTR_MD_NUM_TABLE := XTR_MD_NUM_TABLE();
591: p_base_ccy_amount_usd_update XTR_MD_NUM_TABLE := XTR_MD_NUM_TABLE();
592: p_base_ccy_amount_usd_temp XTR_MD_NUM_TABLE := XTR_MD_NUM_TABLE();

Line 589: p_sob_ccy_temp SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();

585: p_deal_ccy_update SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();
586: p_deal_ccy_temp SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();
587: p_sob_ccy_insert SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();
588: p_sob_ccy_update SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();
589: p_sob_ccy_temp SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();
590: p_base_ccy_amount_usd_insert XTR_MD_NUM_TABLE := XTR_MD_NUM_TABLE();
591: p_base_ccy_amount_usd_update XTR_MD_NUM_TABLE := XTR_MD_NUM_TABLE();
592: p_base_ccy_amount_usd_temp XTR_MD_NUM_TABLE := XTR_MD_NUM_TABLE();
593: p_base_ccy_amount_sob_insert XTR_MD_NUM_TABLE := XTR_MD_NUM_TABLE();

Line 849: p_tb_market_data_set SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();

845: p_tb_counter NUMBER := 0;
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();

Line 854: p_tb_interest_basis 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();
858: p_tb_amt_qty_out XTR_MD_NUM_TABLE := XTR_MD_NUM_TABLE();

Line 869: p_except_market_data_set SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();

865: p_error_type VARCHAR2(1) := 'W'; -- default to warning
866: p_except_counter NUMBER := 0;
867: p_except_deal_no XTR_MD_NUM_TABLE := XTR_MD_NUM_TABLE();
868: p_except_transaction_no XTR_MD_NUM_TABLE := XTR_MD_NUM_TABLE();
869: p_except_market_data_set SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();
870: p_except_error_type SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();
871: p_except_error_code SYSTEM.QRM_VARCHAR240_TABLE := SYSTEM.QRM_VARCHAR240_TABLE();
872: p_except_token_name SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();
873: p_except_token_value SYSTEM.QRM_VARCHAR240_TABLE := SYSTEM.QRM_VARCHAR240_TABLE();

Line 870: p_except_error_type SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();

866: p_except_counter NUMBER := 0;
867: p_except_deal_no XTR_MD_NUM_TABLE := XTR_MD_NUM_TABLE();
868: p_except_transaction_no XTR_MD_NUM_TABLE := XTR_MD_NUM_TABLE();
869: p_except_market_data_set SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();
870: p_except_error_type SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();
871: p_except_error_code SYSTEM.QRM_VARCHAR240_TABLE := SYSTEM.QRM_VARCHAR240_TABLE();
872: p_except_token_name SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();
873: p_except_token_value SYSTEM.QRM_VARCHAR240_TABLE := SYSTEM.QRM_VARCHAR240_TABLE();
874:

Line 872: p_except_token_name SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();

868: p_except_transaction_no XTR_MD_NUM_TABLE := XTR_MD_NUM_TABLE();
869: p_except_market_data_set SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();
870: p_except_error_type SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();
871: p_except_error_code SYSTEM.QRM_VARCHAR240_TABLE := SYSTEM.QRM_VARCHAR240_TABLE();
872: p_except_token_name SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();
873: p_except_token_value SYSTEM.QRM_VARCHAR240_TABLE := SYSTEM.QRM_VARCHAR240_TABLE();
874:
875:
876: p_request_id NUMBER;