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_AGGREGATION_P dependencies on XTR_MD_NUM_TABLE

Line 43: p_order IN OUT NOCOPY XTR_MD_NUM_TABLE,

39: p_amount SYSTEM.QRM_VARCHAR_TABLE,
40: p_agg IN OUT NOCOPY SYSTEM.QRM_VARCHAR240_TABLE,
41: p_ccy_aggregate IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,
42: p_type IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,
43: p_order IN OUT NOCOPY XTR_MD_NUM_TABLE,
44: p_ccy_suffix OUT NOCOPY VARCHAR2,
45: p_ccy_multiplier OUT NOCOPY NUMBER,
46: p_ccy_agg_flag OUT NOCOPY NUMBER,
47: p_underlying_ccy OUT NOCOPY VARCHAR2,

Line 604: PROCEDURE get_col_ccy_multp(p_col_ccy_multp IN OUT NOCOPY XTR_MD_NUM_TABLE,

600: identical to the array used when inserting measures into
601: QRM_SAVED_ANALYSES_ROW.
602: Please refer to Bug 2566711.
603: ***************************************************************/
604: PROCEDURE get_col_ccy_multp(p_col_ccy_multp IN OUT NOCOPY XTR_MD_NUM_TABLE,
605: p_a1 IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,
606: p_default_ccy VARCHAR2,
607: p_row_agg_no NUMBER,
608: p_max_col_no NUMBER,

Line 691: FUNCTION calc_col_total(p_col_ccy_multp IN OUT NOCOPY XTR_MD_NUM_TABLE,

687: This function updates the columns' totals in the case of Crosstab
688: style with different underlying currencies for different columns.
689: Please refer to Bug 2566711.
690: ***************************************************************/
691: FUNCTION calc_col_total(p_col_ccy_multp IN OUT NOCOPY XTR_MD_NUM_TABLE,
692: p_measure IN OUT NOCOPY XTR_MD_NUM_TABLE,
693: p_max_col_no NUMBER,
694: p_ccy_case_flag NUMBER,
695: p_ccy_agg_flag NUMBER,

Line 692: p_measure IN OUT NOCOPY XTR_MD_NUM_TABLE,

688: style with different underlying currencies for different columns.
689: Please refer to Bug 2566711.
690: ***************************************************************/
691: FUNCTION calc_col_total(p_col_ccy_multp IN OUT NOCOPY XTR_MD_NUM_TABLE,
692: p_measure IN OUT NOCOPY XTR_MD_NUM_TABLE,
693: p_max_col_no NUMBER,
694: p_ccy_case_flag NUMBER,
695: p_ccy_agg_flag NUMBER,
696: p_max_col_agg_level NUMBER)

Line 700: v_temp_meas XTR_MD_NUM_TABLE := XTR_MD_NUM_TABLE();

696: p_max_col_agg_level NUMBER)
697: RETURN NUMBER IS
698:
699: v_total NUMBER := 0;
700: v_temp_meas XTR_MD_NUM_TABLE := XTR_MD_NUM_TABLE();
701: v_null BOOLEAN := TRUE;
702:
703: BEGIN
704:

Line 742: sm IN OUT NOCOPY XTR_MD_NUM_TABLE,

738: without initializing 100 arrays, thus, static insert per row basis
739: is the next viable option.
740: ***************************************************************/
741: FUNCTION insert_row(sh IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,
742: sm IN OUT NOCOPY XTR_MD_NUM_TABLE,
743: p_row_agg_no NUMBER,
744: p_max_col_no NUMBER,
745: p_name VARCHAR2,
746: p_row NUMBER,

Line 754: p_col_ccy_multp IN OUT NOCOPY XTR_MD_NUM_TABLE)

750: p_style VARCHAR2,
751: p_ref_date DATE,
752: p_ccy_case_flag NUMBER,
753: p_ccy_agg_flag NUMBER,
754: p_col_ccy_multp IN OUT NOCOPY XTR_MD_NUM_TABLE)
755: RETURN BOOLEAN IS
756:
757: v_tot_currency VARCHAR2(20);
758: v_tot_currency_label VARCHAR2(25);

Line 1408: v_col_seq_no xtr_md_num_table := xtr_md_num_table();

1404:
1405: v_start_date SYSTEM.QRM_DATE_TABLE := SYSTEM.QRM_DATE_TABLE();
1406: v_end_date SYSTEM.QRM_DATE_TABLE := SYSTEM.QRM_DATE_TABLE();
1407: v_col SYSTEM.QRM_VARCHAR_table;
1408: v_col_seq_no xtr_md_num_table := xtr_md_num_table();
1409: v_col_name_map SYSTEM.QRM_VARCHAR_table := SYSTEM.QRM_VARCHAR_table();
1410: v_percent_col_name_map SYSTEM.QRM_VARCHAR_table := SYSTEM.QRM_VARCHAR_table();
1411: v_a1 SYSTEM.QRM_VARCHAR_table := SYSTEM.QRM_VARCHAR_table();
1412: v_col_hidden SYSTEM.QRM_VARCHAR_table := SYSTEM.QRM_VARCHAR_table();

Line 1413: v_col_type xtr_md_num_table := xtr_md_num_table();

1409: v_col_name_map SYSTEM.QRM_VARCHAR_table := SYSTEM.QRM_VARCHAR_table();
1410: v_percent_col_name_map SYSTEM.QRM_VARCHAR_table := SYSTEM.QRM_VARCHAR_table();
1411: v_a1 SYSTEM.QRM_VARCHAR_table := SYSTEM.QRM_VARCHAR_table();
1412: v_col_hidden SYSTEM.QRM_VARCHAR_table := SYSTEM.QRM_VARCHAR_table();
1413: v_col_type xtr_md_num_table := xtr_md_num_table();
1414: v_col_seq_no_key SYSTEM.QRM_VARCHAR_table := SYSTEM.QRM_VARCHAR_table();
1415: v_col_order xtr_md_num_table;
1416: v_col_ccy_multp xtr_md_num_table := xtr_md_num_table();--Bug 2566711
1417:

Line 1415: v_col_order xtr_md_num_table;

1411: v_a1 SYSTEM.QRM_VARCHAR_table := SYSTEM.QRM_VARCHAR_table();
1412: v_col_hidden SYSTEM.QRM_VARCHAR_table := SYSTEM.QRM_VARCHAR_table();
1413: v_col_type xtr_md_num_table := xtr_md_num_table();
1414: v_col_seq_no_key SYSTEM.QRM_VARCHAR_table := SYSTEM.QRM_VARCHAR_table();
1415: v_col_order xtr_md_num_table;
1416: v_col_ccy_multp xtr_md_num_table := xtr_md_num_table();--Bug 2566711
1417:
1418: v_header SYSTEM.QRM_VARCHAR_table := SYSTEM.QRM_VARCHAR_table();
1419: v_measure xtr_md_num_table := xtr_md_num_table();

Line 1416: v_col_ccy_multp xtr_md_num_table := xtr_md_num_table();--Bug 2566711

1412: v_col_hidden SYSTEM.QRM_VARCHAR_table := SYSTEM.QRM_VARCHAR_table();
1413: v_col_type xtr_md_num_table := xtr_md_num_table();
1414: v_col_seq_no_key SYSTEM.QRM_VARCHAR_table := SYSTEM.QRM_VARCHAR_table();
1415: v_col_order xtr_md_num_table;
1416: v_col_ccy_multp xtr_md_num_table := xtr_md_num_table();--Bug 2566711
1417:
1418: v_header SYSTEM.QRM_VARCHAR_table := SYSTEM.QRM_VARCHAR_table();
1419: v_measure xtr_md_num_table := xtr_md_num_table();
1420: v_save_header SYSTEM.QRM_VARCHAR_table := SYSTEM.QRM_VARCHAR_table();

Line 1419: v_measure xtr_md_num_table := xtr_md_num_table();

1415: v_col_order xtr_md_num_table;
1416: v_col_ccy_multp xtr_md_num_table := xtr_md_num_table();--Bug 2566711
1417:
1418: v_header SYSTEM.QRM_VARCHAR_table := SYSTEM.QRM_VARCHAR_table();
1419: v_measure xtr_md_num_table := xtr_md_num_table();
1420: v_save_header SYSTEM.QRM_VARCHAR_table := SYSTEM.QRM_VARCHAR_table();
1421: v_save_measure xtr_md_num_table := xtr_md_num_table();
1422: v_nom xtr_md_num_table := xtr_md_num_table();
1423: v_denom xtr_md_num_table := xtr_md_num_table();

Line 1421: v_save_measure xtr_md_num_table := xtr_md_num_table();

1417:
1418: v_header SYSTEM.QRM_VARCHAR_table := SYSTEM.QRM_VARCHAR_table();
1419: v_measure xtr_md_num_table := xtr_md_num_table();
1420: v_save_header SYSTEM.QRM_VARCHAR_table := SYSTEM.QRM_VARCHAR_table();
1421: v_save_measure xtr_md_num_table := xtr_md_num_table();
1422: v_nom xtr_md_num_table := xtr_md_num_table();
1423: v_denom xtr_md_num_table := xtr_md_num_table();
1424: v_nom_usd xtr_md_num_table := xtr_md_num_table();
1425: v_denom_usd xtr_md_num_table := xtr_md_num_table();

Line 1422: v_nom xtr_md_num_table := xtr_md_num_table();

1418: v_header SYSTEM.QRM_VARCHAR_table := SYSTEM.QRM_VARCHAR_table();
1419: v_measure xtr_md_num_table := xtr_md_num_table();
1420: v_save_header SYSTEM.QRM_VARCHAR_table := SYSTEM.QRM_VARCHAR_table();
1421: v_save_measure xtr_md_num_table := xtr_md_num_table();
1422: v_nom xtr_md_num_table := xtr_md_num_table();
1423: v_denom xtr_md_num_table := xtr_md_num_table();
1424: v_nom_usd xtr_md_num_table := xtr_md_num_table();
1425: v_denom_usd xtr_md_num_table := xtr_md_num_table();
1426: v_origin SYSTEM.QRM_VARCHAR_table;

Line 1423: v_denom xtr_md_num_table := xtr_md_num_table();

1419: v_measure xtr_md_num_table := xtr_md_num_table();
1420: v_save_header SYSTEM.QRM_VARCHAR_table := SYSTEM.QRM_VARCHAR_table();
1421: v_save_measure xtr_md_num_table := xtr_md_num_table();
1422: v_nom xtr_md_num_table := xtr_md_num_table();
1423: v_denom xtr_md_num_table := xtr_md_num_table();
1424: v_nom_usd xtr_md_num_table := xtr_md_num_table();
1425: v_denom_usd xtr_md_num_table := xtr_md_num_table();
1426: v_origin SYSTEM.QRM_VARCHAR_table;
1427: v_tb_label_arr SYSTEM.QRM_VARCHAR_table := SYSTEM.QRM_VARCHAR_table();

Line 1424: v_nom_usd xtr_md_num_table := xtr_md_num_table();

1420: v_save_header SYSTEM.QRM_VARCHAR_table := SYSTEM.QRM_VARCHAR_table();
1421: v_save_measure xtr_md_num_table := xtr_md_num_table();
1422: v_nom xtr_md_num_table := xtr_md_num_table();
1423: v_denom xtr_md_num_table := xtr_md_num_table();
1424: v_nom_usd xtr_md_num_table := xtr_md_num_table();
1425: v_denom_usd xtr_md_num_table := xtr_md_num_table();
1426: v_origin SYSTEM.QRM_VARCHAR_table;
1427: v_tb_label_arr SYSTEM.QRM_VARCHAR_table := SYSTEM.QRM_VARCHAR_table();
1428: v_num_denom_origin SYSTEM.QRM_VARCHAR_TABLE;

Line 1425: v_denom_usd xtr_md_num_table := xtr_md_num_table();

1421: v_save_measure xtr_md_num_table := xtr_md_num_table();
1422: v_nom xtr_md_num_table := xtr_md_num_table();
1423: v_denom xtr_md_num_table := xtr_md_num_table();
1424: v_nom_usd xtr_md_num_table := xtr_md_num_table();
1425: v_denom_usd xtr_md_num_table := xtr_md_num_table();
1426: v_origin SYSTEM.QRM_VARCHAR_table;
1427: v_tb_label_arr SYSTEM.QRM_VARCHAR_table := SYSTEM.QRM_VARCHAR_table();
1428: v_num_denom_origin SYSTEM.QRM_VARCHAR_TABLE;
1429:

Line 1520: v_dummy1 xtr_md_num_table;

1516: v_nom_fl SYSTEM.QRM_VARCHAR240_TABLE;
1517: v_denom_fl SYSTEM.QRM_VARCHAR240_TABLE;
1518: v_tot_avg SYSTEM.QRM_VARCHAR_table;
1519: v_percent SYSTEM.QRM_VARCHAR_table;
1520: v_dummy1 xtr_md_num_table;
1521: v_amount SYSTEM.QRM_VARCHAR_table;
1522: v_ccy_aggregate SYSTEM.QRM_VARCHAR_table;
1523: v_sensitivity SYSTEM.QRM_VARCHAR_table;
1524:

Line 2898: p_col_seq_no IN OUT NOCOPY XTR_MD_NUM_TABLE,

2894: p_max_col_no OUT NOCOPY NUMBER,
2895: p_date_type VARCHAR2,
2896: p_calendar_id NUMBER,
2897: p_business_week VARCHAR2,
2898: p_col_seq_no IN OUT NOCOPY XTR_MD_NUM_TABLE,
2899: p_col_seq_no_key IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,
2900: p_col_name_map IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,
2901: p_percent_col_name_map IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,
2902: p_a1 IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,

Line 2903: p_col_type IN OUT NOCOPY XTR_MD_NUM_TABLE,

2899: p_col_seq_no_key IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,
2900: p_col_name_map IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,
2901: p_percent_col_name_map IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,
2902: p_a1 IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,
2903: p_col_type IN OUT NOCOPY XTR_MD_NUM_TABLE,
2904: p_col_hidden IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,
2905: p_start_date IN OUT NOCOPY SYSTEM.QRM_DATE_TABLE,
2906: p_end_date IN OUT NOCOPY SYSTEM.QRM_DATE_TABLE,
2907: p_tb_label_arr IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE) IS

Line 2917: v_int_length xtr_md_num_table;

2913: ORDER BY sequence_number;
2914: CURSOR v_find_tb IS
2915: SELECT COUNT(*) FROM qrm_time_buckets
2916: WHERE tb_name = p_tb_name;
2917: v_int_length xtr_md_num_table;
2918: v_int_type SYSTEM.QRM_VARCHAR_table;
2919: v_label SYSTEM.QRM_VARCHAR_table;
2920: v_date DATE;
2921: v_prev_end_date DATE;

Line 3061: v_col_seq_no XTR_MD_NUM_TABLE := XTR_MD_NUM_TABLE();

3057: p_start_date_offset IN OUT NOCOPY NUMBER,
3058: p_start_offset_type IN OUT NOCOPY VARCHAR2,
3059: p_analysis_type VARCHAR2) IS
3060:
3061: v_col_seq_no XTR_MD_NUM_TABLE := XTR_MD_NUM_TABLE();
3062: v_col_seq_no_key SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();
3063: v_col_name_map SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();
3064: v_percent_col_name_map SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();
3065: v_a1 SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();

Line 3066: v_col_type XTR_MD_NUM_TABLE := XTR_MD_NUM_TABLE();

3062: v_col_seq_no_key SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();
3063: v_col_name_map SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();
3064: v_percent_col_name_map SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();
3065: v_a1 SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();
3066: v_col_type XTR_MD_NUM_TABLE := XTR_MD_NUM_TABLE();
3067: v_col_hidden SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();
3068: v_start_date SYSTEM.QRM_DATE_TABLE := SYSTEM.QRM_DATE_TABLE();
3069: v_end_date SYSTEM.QRM_DATE_TABLE := SYSTEM.QRM_DATE_TABLE();
3070: v_tb_label_arr SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();

Line 3185: p_meas XTR_MD_NUM_TABLE)

3181: ***************************************************************/
3182: FUNCTION update_percent_cols(p_name VARCHAR2,
3183: p_row NUMBER,
3184: p_ref_date DATE,
3185: p_meas XTR_MD_NUM_TABLE)
3186: RETURN BOOLEAN IS
3187: BEGIN
3188:
3189: IF (g_proc_level>=g_debug_level) THEN

Line 3292: v_meas XTR_MD_NUM_TABLE := XTR_MD_NUM_TABLE();

3288: RETURN BOOLEAN IS
3289:
3290: v_level NUMBER;
3291: v_row NUMBER;
3292: v_meas XTR_MD_NUM_TABLE := XTR_MD_NUM_TABLE();
3293: v_ccy SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();
3294: v_fx_rate NUMBER;
3295: v_success BOOLEAN;
3296:

Line 3498: v_tot XTR_MD_NUM_TABLE := XTR_MD_NUM_TABLE();

3494: p_ref_date DATE,
3495: p_md_set_code VARCHAR2)
3496: RETURN BOOLEAN IS
3497:
3498: v_tot XTR_MD_NUM_TABLE := XTR_MD_NUM_TABLE();
3499: v_type VARCHAR2(1);
3500: v_level VARCHAR2(1); --the order
3501: v_row NUMBER;
3502: v_previous_count NUMBER := 1;

Line 3781: p_col_order IN OUT NOCOPY XTR_MD_NUM_TABLE,

3777: is taken care in the dynamic cursor when aggregation is done.
3778: ***************************************************************/
3779: FUNCTION update_label(p_name VARCHAR2,
3780: p_agg IN OUT NOCOPY SYSTEM.QRM_VARCHAR240_TABLE,
3781: p_col_order IN OUT NOCOPY XTR_MD_NUM_TABLE,
3782: p_att_type IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,
3783: p_ref_date DATE)
3784: RETURN BOOLEAN IS
3785: v_col_name VARCHAR2(50);

Line 3844: p_total OUT NOCOPY XTR_MD_NUM_TABLE,--12

3840: p_end_date_fix DATE,--8
3841: p_tot_avg SYSTEM.QRM_VARCHAR_TABLE,--9
3842: p_ccy_multiplier OUT NOCOPY NUMBER,--10
3843: p_att_name IN OUT NOCOPY SYSTEM.QRM_VARCHAR240_TABLE,--11
3844: p_total OUT NOCOPY XTR_MD_NUM_TABLE,--12
3845: p_table_col_curr OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,--13
3846: p_sensitivity SYSTEM.QRM_VARCHAR_TABLE, --14
3847: p_analysis_type VARCHAR2, --15
3848: p_business_week VARCHAR2,--16

Line 3865: v_total_temp xtr_md_num_table := xtr_md_num_table();

3861: v_cursor INTEGER;
3862: v_rows_processed INTEGER;
3863: v_tb_calc_used BOOLEAN;
3864: v_temp VARCHAR2(240);
3865: v_total_temp xtr_md_num_table := xtr_md_num_table();
3866:
3867: --dummy variables required only for other styles
3868: v_tb_calc_used_col BOOLEAN;
3869: v_ccy_aggregate SYSTEM.QRM_VARCHAR_table := SYSTEM.QRM_VARCHAR_table();

Line 3871: v_order xtr_md_num_table := xtr_md_num_table();

3867: --dummy variables required only for other styles
3868: v_tb_calc_used_col BOOLEAN;
3869: v_ccy_aggregate SYSTEM.QRM_VARCHAR_table := SYSTEM.QRM_VARCHAR_table();
3870: v_type SYSTEM.QRM_VARCHAR_table := SYSTEM.QRM_VARCHAR_table();
3871: v_order xtr_md_num_table := xtr_md_num_table();
3872: v_ccy_agg_flag NUMBER;
3873: v_ccy_case_flag NUMBER;
3874: v_ccy_agg_level NUMBER;
3875: v_measure_no NUMBER(5);

Line 3911: p_total := xtr_md_num_table();

3907: v_att_type.EXTEND(p_att_name.COUNT);
3908: v_nom.EXTEND(p_att_name.COUNT);
3909: v_denom.EXTEND(p_att_name.COUNT);
3910: v_num_denom_origin.EXTEND(p_att_name.COUNT);
3911: p_total := xtr_md_num_table();
3912: p_total.EXTEND(p_att_name.COUNT);
3913:
3914: --xtr_risk_debug_pkg.dlog('p_table_col_curr.COUNT',p_table_col_curr.COUNT);
3915: --get the underlying currency for each column and modify the the