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 QRM_VARCHAR_TABLE

Line 39: p_amount SYSTEM.QRM_VARCHAR_TABLE,

35: p_style VARCHAR2,
36: p_md_set_code VARCHAR2,
37: p_currency_source VARCHAR2,
38: p_curr_reporting VARCHAR2,
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,

Line 41: p_ccy_aggregate IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,

37: p_currency_source VARCHAR2,
38: p_curr_reporting VARCHAR2,
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,

Line 42: p_type IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,

38: p_curr_reporting VARCHAR2,
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,

Line 52: p_table_col_curr IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,

48: p_ccy_case_flag OUT NOCOPY NUMBER,
49: p_measure VARCHAR2,
50: p_ccy_agg_level OUT NOCOPY NUMBER,
51: --only necessary for style='T'
52: p_table_col_curr IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,
53: p_agg_col_curr IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,
54: p_sensitivity SYSTEM.QRM_VARCHAR_TABLE)
55: IS
56:

Line 53: p_agg_col_curr IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,

49: p_measure VARCHAR2,
50: p_ccy_agg_level OUT NOCOPY NUMBER,
51: --only necessary for style='T'
52: p_table_col_curr IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,
53: p_agg_col_curr IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,
54: p_sensitivity SYSTEM.QRM_VARCHAR_TABLE)
55: IS
56:
57: v_amount_type BOOLEAN;

Line 54: p_sensitivity SYSTEM.QRM_VARCHAR_TABLE)

50: p_ccy_agg_level OUT NOCOPY NUMBER,
51: --only necessary for style='T'
52: p_table_col_curr IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,
53: p_agg_col_curr IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,
54: p_sensitivity SYSTEM.QRM_VARCHAR_TABLE)
55: IS
56:
57: v_amount_type BOOLEAN;
58: v_uniform_ccy BOOLEAN := TRUE;

Line 455: p_amount SYSTEM.QRM_VARCHAR_TABLE,

451: This procedure appends suffix '_USD' or '_SOB' to the actual
452: column name to be used in the dynamic SQL.
453: ***************************************************************/
454: PROCEDURE get_actual_column_name(p_name VARCHAR2,
455: p_amount SYSTEM.QRM_VARCHAR_TABLE,
456: p_agg IN OUT NOCOPY SYSTEM.QRM_VARCHAR240_TABLE,
457: p_actual_agg IN OUT NOCOPY SYSTEM.QRM_VARCHAR240_TABLE,
458: p_nom_fl IN OUT NOCOPY SYSTEM.QRM_VARCHAR240_TABLE,
459: p_denom_fl IN OUT NOCOPY SYSTEM.QRM_VARCHAR240_TABLE,

Line 466: p_origin IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,

462: p_denom_fl_usd IN OUT NOCOPY SYSTEM.QRM_VARCHAR240_TABLE,
463: p_ccy_suffix VARCHAR2,
464: p_ccy_multiplier NUMBER,
465: p_need_usd_arr BOOLEAN,
466: p_origin IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,
467: p_origin_usd IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,
468: p_num_denom_origin IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,
469: p_num_denom_origin_usd IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,
470: p_type IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,

Line 467: p_origin_usd IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,

463: p_ccy_suffix VARCHAR2,
464: p_ccy_multiplier NUMBER,
465: p_need_usd_arr BOOLEAN,
466: p_origin IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,
467: p_origin_usd IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,
468: p_num_denom_origin IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,
469: p_num_denom_origin_usd IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,
470: p_type IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,
471: p_sensitivity SYSTEM.QRM_VARCHAR_TABLE)

Line 468: p_num_denom_origin IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,

464: p_ccy_multiplier NUMBER,
465: p_need_usd_arr BOOLEAN,
466: p_origin IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,
467: p_origin_usd IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,
468: p_num_denom_origin IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,
469: p_num_denom_origin_usd IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,
470: p_type IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,
471: p_sensitivity SYSTEM.QRM_VARCHAR_TABLE)
472: IS

Line 469: p_num_denom_origin_usd IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,

465: p_need_usd_arr BOOLEAN,
466: p_origin IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,
467: p_origin_usd IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,
468: p_num_denom_origin IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,
469: p_num_denom_origin_usd IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,
470: p_type IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,
471: p_sensitivity SYSTEM.QRM_VARCHAR_TABLE)
472: IS
473:

Line 470: p_type IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,

466: p_origin IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,
467: p_origin_usd IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,
468: p_num_denom_origin IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,
469: p_num_denom_origin_usd IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,
470: p_type IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,
471: p_sensitivity SYSTEM.QRM_VARCHAR_TABLE)
472: IS
473:
474: i NUMBER(5);

Line 471: p_sensitivity SYSTEM.QRM_VARCHAR_TABLE)

467: p_origin_usd IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,
468: p_num_denom_origin IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,
469: p_num_denom_origin_usd IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,
470: p_type IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,
471: p_sensitivity SYSTEM.QRM_VARCHAR_TABLE)
472: IS
473:
474: i NUMBER(5);
475: v_col_name VARCHAR2(200);

Line 484: v_deal_type_arr SYSTEM.QRM_VARCHAR_table;

480: WHERE attribute_name=v_col_name;
481: CURSOR get_origin IS
482: SELECT origin FROM qrm_ana_atts_lookups
483: WHERE attribute_name=v_col_name;
484: v_deal_type_arr SYSTEM.QRM_VARCHAR_table;
485: v_market_type_arr SYSTEM.QRM_VARCHAR_table;
486: v_count NUMBER;
487:
488: BEGIN

Line 485: v_market_type_arr SYSTEM.QRM_VARCHAR_table;

481: CURSOR get_origin IS
482: SELECT origin FROM qrm_ana_atts_lookups
483: WHERE attribute_name=v_col_name;
484: v_deal_type_arr SYSTEM.QRM_VARCHAR_table;
485: v_market_type_arr SYSTEM.QRM_VARCHAR_table;
486: v_count NUMBER;
487:
488: BEGIN
489: IF (g_proc_level>=g_debug_level) THEN

Line 605: p_a1 IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,

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,
609: p_md_set_code VARCHAR2,

Line 741: FUNCTION insert_row(sh IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,

737: called when looping through the main cursor. Cannot do bulk insert
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,

Line 939: p_type IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,

935: PROCEDURE create_cursor (p_name VARCHAR2,
936: p_style VARCHAR2,
937: p_analysis_type VARCHAR2,
938: p_agg IN OUT NOCOPY SYSTEM.QRM_VARCHAR240_TABLE,
939: p_type IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,
940: p_nom IN OUT NOCOPY SYSTEM.QRM_VARCHAR240_TABLE,
941: p_denom IN OUT NOCOPY SYSTEM.QRM_VARCHAR240_TABLE,
942: p_tot_avg SYSTEM.QRM_VARCHAR_TABLE,
943: p_sql OUT NOCOPY VARCHAR2,

Line 942: p_tot_avg SYSTEM.QRM_VARCHAR_TABLE,

938: p_agg IN OUT NOCOPY SYSTEM.QRM_VARCHAR240_TABLE,
939: p_type IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,
940: p_nom IN OUT NOCOPY SYSTEM.QRM_VARCHAR240_TABLE,
941: p_denom IN OUT NOCOPY SYSTEM.QRM_VARCHAR240_TABLE,
942: p_tot_avg SYSTEM.QRM_VARCHAR_TABLE,
943: p_sql OUT NOCOPY VARCHAR2,
944: p_sql_col OUT NOCOPY VARCHAR2,
945: p_row_agg_no OUT NOCOPY NUMBER,
946: p_measure_no IN OUT NOCOPY NUMBER,

Line 947: p_origin IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,

943: p_sql OUT NOCOPY VARCHAR2,
944: p_sql_col OUT NOCOPY VARCHAR2,
945: p_row_agg_no OUT NOCOPY NUMBER,
946: p_measure_no IN OUT NOCOPY NUMBER,
947: p_origin IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,
948: p_tb_calc_used IN OUT NOCOPY BOOLEAN,
949: p_tb_calc_used_col IN OUT NOCOPY BOOLEAN,
950: p_need_usd_arr BOOLEAN,
951: p_ccy_suffix VARCHAR2,

Line 953: p_amount SYSTEM.QRM_VARCHAR_TABLE,

949: p_tb_calc_used_col IN OUT NOCOPY BOOLEAN,
950: p_need_usd_arr BOOLEAN,
951: p_ccy_suffix VARCHAR2,
952: p_ccy_multiplier NUMBER,
953: p_amount SYSTEM.QRM_VARCHAR_TABLE,
954: p_table_col_curr IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,
955: p_num_denom_origin IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,
956: p_curr_reporting VARCHAR2,
957: p_sensitivity SYSTEM.QRM_VARCHAR_TABLE) IS

Line 954: p_table_col_curr IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,

950: p_need_usd_arr BOOLEAN,
951: p_ccy_suffix VARCHAR2,
952: p_ccy_multiplier NUMBER,
953: p_amount SYSTEM.QRM_VARCHAR_TABLE,
954: p_table_col_curr IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,
955: p_num_denom_origin IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,
956: p_curr_reporting VARCHAR2,
957: p_sensitivity SYSTEM.QRM_VARCHAR_TABLE) IS
958:

Line 955: p_num_denom_origin IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,

951: p_ccy_suffix VARCHAR2,
952: p_ccy_multiplier NUMBER,
953: p_amount SYSTEM.QRM_VARCHAR_TABLE,
954: p_table_col_curr IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,
955: p_num_denom_origin IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,
956: p_curr_reporting VARCHAR2,
957: p_sensitivity SYSTEM.QRM_VARCHAR_TABLE) IS
958:
959: --IMPORTANT: v_act_agg include multiplier

Line 957: p_sensitivity SYSTEM.QRM_VARCHAR_TABLE) IS

953: p_amount SYSTEM.QRM_VARCHAR_TABLE,
954: p_table_col_curr IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,
955: p_num_denom_origin IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,
956: p_curr_reporting VARCHAR2,
957: p_sensitivity SYSTEM.QRM_VARCHAR_TABLE) IS
958:
959: --IMPORTANT: v_act_agg include multiplier
960: v_act_agg SYSTEM.QRM_VARCHAR240_TABLE := SYSTEM.QRM_VARCHAR240_TABLE();
961: v_agg_usd SYSTEM.QRM_VARCHAR240_TABLE := SYSTEM.QRM_VARCHAR240_TABLE();

Line 962: v_origin_usd SYSTEM.QRM_VARCHAR_table := SYSTEM.QRM_VARCHAR_table();

958:
959: --IMPORTANT: v_act_agg include multiplier
960: v_act_agg SYSTEM.QRM_VARCHAR240_TABLE := SYSTEM.QRM_VARCHAR240_TABLE();
961: v_agg_usd SYSTEM.QRM_VARCHAR240_TABLE := SYSTEM.QRM_VARCHAR240_TABLE();
962: v_origin_usd SYSTEM.QRM_VARCHAR_table := SYSTEM.QRM_VARCHAR_table();
963: v_nom_fl_usd SYSTEM.QRM_VARCHAR240_TABLE := SYSTEM.QRM_VARCHAR240_TABLE();
964: v_denom_fl_usd SYSTEM.QRM_VARCHAR240_TABLE := SYSTEM.QRM_VARCHAR240_TABLE();
965: v_num_denom_origin_usd SYSTEM.QRM_VARCHAR_table := SYSTEM.QRM_VARCHAR_table();
966: v_from VARCHAR2(100):=' FROM qrm_deal_calculations dc,qrm_deals_analyses da,qrm_current_deals_v v';

Line 965: v_num_denom_origin_usd SYSTEM.QRM_VARCHAR_table := SYSTEM.QRM_VARCHAR_table();

961: v_agg_usd SYSTEM.QRM_VARCHAR240_TABLE := SYSTEM.QRM_VARCHAR240_TABLE();
962: v_origin_usd SYSTEM.QRM_VARCHAR_table := SYSTEM.QRM_VARCHAR_table();
963: v_nom_fl_usd SYSTEM.QRM_VARCHAR240_TABLE := SYSTEM.QRM_VARCHAR240_TABLE();
964: v_denom_fl_usd SYSTEM.QRM_VARCHAR240_TABLE := SYSTEM.QRM_VARCHAR240_TABLE();
965: v_num_denom_origin_usd SYSTEM.QRM_VARCHAR_table := SYSTEM.QRM_VARCHAR_table();
966: v_from VARCHAR2(100):=' FROM qrm_deal_calculations dc,qrm_deals_analyses da,qrm_current_deals_v v';
967: v_where VARCHAR2(255):=' WHERE da.deal_calc_id=dc.deal_calc_id AND da.analysis_name=:analysis_name AND dc.deal_no=v.deal_no AND dc.transaction_no=v.transaction_no';
968: i NUMBER(5);
969: j NUMBER(5);

Line 1407: v_col SYSTEM.QRM_VARCHAR_table;

1403: RETURN VARCHAR2 IS --'T' if success or 'F' for unsuccessful
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();

Line 1409: v_col_name_map SYSTEM.QRM_VARCHAR_table := SYSTEM.QRM_VARCHAR_table();

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();
1413: v_col_type xtr_md_num_table := xtr_md_num_table();

Line 1410: v_percent_col_name_map SYSTEM.QRM_VARCHAR_table := SYSTEM.QRM_VARCHAR_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();
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();

Line 1411: v_a1 SYSTEM.QRM_VARCHAR_table := SYSTEM.QRM_VARCHAR_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();
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;

Line 1412: v_col_hidden SYSTEM.QRM_VARCHAR_table := 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();
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

Line 1414: v_col_seq_no_key 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:
1418: v_header SYSTEM.QRM_VARCHAR_table := SYSTEM.QRM_VARCHAR_table();

Line 1418: v_header SYSTEM.QRM_VARCHAR_table := SYSTEM.QRM_VARCHAR_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();
1421: v_save_measure xtr_md_num_table := xtr_md_num_table();
1422: v_nom xtr_md_num_table := xtr_md_num_table();

Line 1420: v_save_header SYSTEM.QRM_VARCHAR_table := SYSTEM.QRM_VARCHAR_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();
1424: v_nom_usd xtr_md_num_table := xtr_md_num_table();

Line 1426: v_origin SYSTEM.QRM_VARCHAR_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:
1430: v_sql VARCHAR2(4000);

Line 1427: v_tb_label_arr SYSTEM.QRM_VARCHAR_table := SYSTEM.QRM_VARCHAR_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:
1430: v_sql VARCHAR2(4000);
1431: v_sql_col VARCHAR2(4000);

Line 1428: v_num_denom_origin SYSTEM.QRM_VARCHAR_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:
1430: v_sql VARCHAR2(4000);
1431: v_sql_col VARCHAR2(4000);
1432: v_max_col_no NUMBER(5):=0; --actual column span length excluding rowheader

Line 1486: v_table_col_curr SYSTEM.QRM_VARCHAR_table := SYSTEM.QRM_VARCHAR_table();

1482: v_need_usd_arr BOOLEAN;
1483: v_current_ccy VARCHAR2(15);--the current ccy when CCY is aggregate
1484: v_row_ccy VARCHAR2(15);--the ccy of the last row with v_header(ccy_agg_level)
1485: --dummy variable used for style='T' required for get_underlying_currency
1486: v_table_col_curr SYSTEM.QRM_VARCHAR_table := SYSTEM.QRM_VARCHAR_table();
1487: v_agg_col_curr SYSTEM.QRM_VARCHAR_table := SYSTEM.QRM_VARCHAR_table();
1488: ----------End CCY Variables--------
1489: CURSOR analysis_data IS
1490: SELECT analysis_type, style, tb_label, tb_name, date_type, start_date,

Line 1487: v_agg_col_curr SYSTEM.QRM_VARCHAR_table := SYSTEM.QRM_VARCHAR_table();

1483: v_current_ccy VARCHAR2(15);--the current ccy when CCY is aggregate
1484: v_row_ccy VARCHAR2(15);--the ccy of the last row with v_header(ccy_agg_level)
1485: --dummy variable used for style='T' required for get_underlying_currency
1486: v_table_col_curr SYSTEM.QRM_VARCHAR_table := SYSTEM.QRM_VARCHAR_table();
1487: v_agg_col_curr SYSTEM.QRM_VARCHAR_table := SYSTEM.QRM_VARCHAR_table();
1488: ----------End CCY Variables--------
1489: CURSOR analysis_data IS
1490: SELECT analysis_type, style, tb_label, tb_name, date_type, start_date,
1491: start_date_ref, start_date_offset, start_offset_type, end_date,

Line 1515: v_att_type SYSTEM.QRM_VARCHAR_table;

1511:
1512: v_agg SYSTEM.QRM_VARCHAR240_TABLE;
1513: --array of the actual column names including currency conversion
1514: --to be inserted into the DYNAMIC SQL
1515: v_att_type SYSTEM.QRM_VARCHAR_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;

Line 1518: v_tot_avg SYSTEM.QRM_VARCHAR_table;

1514: --to be inserted into the DYNAMIC SQL
1515: v_att_type SYSTEM.QRM_VARCHAR_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;

Line 1519: v_percent SYSTEM.QRM_VARCHAR_table;

1515: v_att_type SYSTEM.QRM_VARCHAR_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;

Line 1521: v_amount SYSTEM.QRM_VARCHAR_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:
1525: i NUMBER(5);

Line 1522: v_ccy_aggregate SYSTEM.QRM_VARCHAR_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:
1525: i NUMBER(5);
1526: j NUMBER(5);

Line 1523: v_sensitivity 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:
1525: i NUMBER(5);
1526: j NUMBER(5);
1527: k NUMBER(5);

Line 2603: v_week SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();

2599: RETURN DATE IS
2600: v_date_out DATE;
2601: v_move VARCHAR2(1); --'B' for backward,'F' for forward
2602: v_day VARCHAR2(3);
2603: v_week SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();
2604: v_day_no NUMBER;
2605: i NUMBER(1);
2606: j NUMBER(1);
2607: v_found BOOLEAN := FALSE;

Line 2693: v_day_table SYSTEM.QRM_VARCHAR_TABLE;

2689: thu_business_day_flag
2690: FROM gl_transaction_calendar
2691: WHERE transaction_calendar_id = p_gl_trans_calendar_id;
2692: --
2693: v_day_table SYSTEM.QRM_VARCHAR_TABLE;
2694: v_fri GL_TRANSACTION_CALENDAR.SAT_BUSINESS_DAY_FLAG%TYPE;
2695: v_sat GL_TRANSACTION_CALENDAR.SAT_BUSINESS_DAY_FLAG%TYPE;
2696: v_sun GL_TRANSACTION_CALENDAR.SAT_BUSINESS_DAY_FLAG%TYPE;
2697: v_mon GL_TRANSACTION_CALENDAR.SAT_BUSINESS_DAY_FLAG%TYPE;

Line 2718: v_day_table := SYSTEM.QRM_VARCHAR_table(Nvl(v_fri, 'Y'), Nvl(v_sat, 'Y'),

2714: FETCH days_of_week_cursor INTO v_fri,v_sat,v_sun,v_mon,v_tue,v_wed,v_thu;
2715: CLOSE days_of_week_cursor;
2716:
2717: -- Put the days of the week in an array for code cleanliness.
2718: v_day_table := SYSTEM.QRM_VARCHAR_table(Nvl(v_fri, 'Y'), Nvl(v_sat, 'Y'),
2719: Nvl(v_sun, 'Y'), Nvl(v_mon, 'Y'), Nvl(v_tue, 'Y'),
2720: Nvl(v_wed, 'Y'), Nvl(v_thu, 'Y'));
2721:
2722: -- First go from top to bottom (Friday to Thursday)

Line 2899: p_col_seq_no_key IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,

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,
2903: p_col_type IN OUT NOCOPY XTR_MD_NUM_TABLE,

Line 2900: p_col_name_map IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,

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,
2903: p_col_type IN OUT NOCOPY XTR_MD_NUM_TABLE,
2904: p_col_hidden IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,

Line 2901: p_percent_col_name_map IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,

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,
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,

Line 2902: p_a1 IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,

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,
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,

Line 2904: p_col_hidden 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
2908:

Line 2907: p_tb_label_arr IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE) IS

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
2908:
2909: CURSOR v_tb_cursor IS
2910: SELECT interval_length, interval_type, label
2911: FROM qrm_time_intervals

Line 2918: v_int_type SYSTEM.QRM_VARCHAR_table;

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;
2922: v_dummy NUMBER;

Line 2919: v_label SYSTEM.QRM_VARCHAR_table;

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;
2922: v_dummy NUMBER;
2923: i NUMBER(5);

Line 3062: v_col_seq_no_key SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();

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();
3066: v_col_type XTR_MD_NUM_TABLE := XTR_MD_NUM_TABLE();

Line 3063: v_col_name_map SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();

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();
3066: v_col_type XTR_MD_NUM_TABLE := XTR_MD_NUM_TABLE();
3067: v_col_hidden SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();

Line 3064: v_percent_col_name_map SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();

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();
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();

Line 3065: v_a1 SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();

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();
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();

Line 3067: v_col_hidden 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();
3071: v_row_agg_no NUMBER := 0;

Line 3070: v_tb_label_arr 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();
3071: v_row_agg_no NUMBER := 0;
3072: v_max_col_no NUMBER;
3073:
3074: BEGIN

Line 3293: v_ccy SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();

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:
3297: CURSOR get_all_measures IS

Line 3782: p_att_type IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,

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);
3786: BEGIN

Line 3841: p_tot_avg SYSTEM.QRM_VARCHAR_TABLE,--9

3837: p_last_run_date DATE,--5
3838: p_md_set_code VARCHAR2,--6
3839: p_dirty VARCHAR2,--7
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

Line 3845: p_table_col_curr OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,--13

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
3849: p_amount SYSTEM.QRM_VARCHAR_TABLE)--17

Line 3846: p_sensitivity SYSTEM.QRM_VARCHAR_TABLE, --14

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
3849: p_amount SYSTEM.QRM_VARCHAR_TABLE)--17
3850: IS

Line 3849: p_amount SYSTEM.QRM_VARCHAR_TABLE)--17

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
3849: p_amount SYSTEM.QRM_VARCHAR_TABLE)--17
3850: IS
3851:
3852: v_ccy_suffix VARCHAR2(20);
3853: v_underlying_ccy VARCHAR2(20);

Line 3854: v_origin SYSTEM.QRM_VARCHAR_table := SYSTEM.QRM_VARCHAR_table();

3850: IS
3851:
3852: v_ccy_suffix VARCHAR2(20);
3853: v_underlying_ccy VARCHAR2(20);
3854: v_origin SYSTEM.QRM_VARCHAR_table := SYSTEM.QRM_VARCHAR_table();
3855: v_att_type SYSTEM.QRM_VARCHAR_table := SYSTEM.QRM_VARCHAR_table();
3856: v_nom SYSTEM.QRM_VARCHAR240_TABLE := SYSTEM.QRM_VARCHAR240_TABLE();
3857: v_denom SYSTEM.QRM_VARCHAR240_TABLE := SYSTEM.QRM_VARCHAR240_TABLE();
3858: v_num_denom_origin SYSTEM.QRM_VARCHAR_table := SYSTEM.QRM_VARCHAR_table();

Line 3855: v_att_type SYSTEM.QRM_VARCHAR_table := SYSTEM.QRM_VARCHAR_table();

3851:
3852: v_ccy_suffix VARCHAR2(20);
3853: v_underlying_ccy VARCHAR2(20);
3854: v_origin SYSTEM.QRM_VARCHAR_table := SYSTEM.QRM_VARCHAR_table();
3855: v_att_type SYSTEM.QRM_VARCHAR_table := SYSTEM.QRM_VARCHAR_table();
3856: v_nom SYSTEM.QRM_VARCHAR240_TABLE := SYSTEM.QRM_VARCHAR240_TABLE();
3857: v_denom SYSTEM.QRM_VARCHAR240_TABLE := SYSTEM.QRM_VARCHAR240_TABLE();
3858: v_num_denom_origin SYSTEM.QRM_VARCHAR_table := SYSTEM.QRM_VARCHAR_table();
3859: v_sql VARCHAR2(4000);

Line 3858: v_num_denom_origin SYSTEM.QRM_VARCHAR_table := SYSTEM.QRM_VARCHAR_table();

3854: v_origin SYSTEM.QRM_VARCHAR_table := SYSTEM.QRM_VARCHAR_table();
3855: v_att_type SYSTEM.QRM_VARCHAR_table := SYSTEM.QRM_VARCHAR_table();
3856: v_nom SYSTEM.QRM_VARCHAR240_TABLE := SYSTEM.QRM_VARCHAR240_TABLE();
3857: v_denom SYSTEM.QRM_VARCHAR240_TABLE := SYSTEM.QRM_VARCHAR240_TABLE();
3858: v_num_denom_origin SYSTEM.QRM_VARCHAR_table := SYSTEM.QRM_VARCHAR_table();
3859: v_sql VARCHAR2(4000);
3860: i NUMBER(5);
3861: v_cursor INTEGER;
3862: v_rows_processed INTEGER;

Line 3869: v_ccy_aggregate SYSTEM.QRM_VARCHAR_table := SYSTEM.QRM_VARCHAR_table();

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();
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;

Line 3870: v_type SYSTEM.QRM_VARCHAR_table := SYSTEM.QRM_VARCHAR_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();
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;

Line 3879: v_agg_col_curr SYSTEM.QRM_VARCHAR_table := SYSTEM.QRM_VARCHAR_table();

3875: v_measure_no NUMBER(5);
3876: v_row_agg_no NUMBER(5);
3877: v_dummy VARCHAR2(1);
3878: v_sql_col VARCHAR2(1);
3879: v_agg_col_curr SYSTEM.QRM_VARCHAR_table := SYSTEM.QRM_VARCHAR_table();
3880:
3881: CURSOR get_lookup_prop IS
3882: SELECT origin,attribute_type,numerator,denominator,num_denom_origin
3883: FROM qrm_ana_atts_lookups

Line 3904: p_table_col_curr := SYSTEM.QRM_VARCHAR_table();

3900: --first extend v_table_col_curr
3901: IF (g_proc_level>=g_debug_level) THEN
3902: xtr_risk_debug_pkg.dlog('p_att_name.COUNT,p_att_name.LAST',p_att_name.COUNT||','||p_att_name.LAST);
3903: END IF;
3904: p_table_col_curr := SYSTEM.QRM_VARCHAR_table();
3905: p_table_col_curr.EXTEND(p_att_name.COUNT);
3906: v_origin.EXTEND(p_att_name.COUNT);
3907: v_att_type.EXTEND(p_att_name.COUNT);
3908: v_nom.EXTEND(p_att_name.COUNT);

Line 4069: v_curr IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE)

4065: ***************************************************************/
4066: FUNCTION update_currency_columns(p_indicator NUMBER,
4067: p_name VARCHAR2,
4068: p_ref_date DATE,
4069: v_curr IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE)
4070: RETURN BOOLEAN IS
4071: BEGIN
4072: IF (g_proc_level>=g_debug_level) THEN
4073: xtr_risk_debug_pkg.dpush('QRM_PA_AGGREGATION_P.UPDATE_CURR_COL');

Line 4203: p_agg_col_curr IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE)

4199: p_max_col_no NUMBER,
4200: p_underlying_ccy VARCHAR2,
4201: p_currency_source VARCHAR2,
4202: p_curr_reporting VARCHAR2,
4203: p_agg_col_curr IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE)
4204: RETURN BOOLEAN IS
4205:
4206: v_curr SYSTEM.QRM_VARCHAR_table;
4207: i NUMBER(3);

Line 4206: v_curr SYSTEM.QRM_VARCHAR_table;

4202: p_curr_reporting VARCHAR2,
4203: p_agg_col_curr IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE)
4204: RETURN BOOLEAN IS
4205:
4206: v_curr SYSTEM.QRM_VARCHAR_table;
4207: i NUMBER(3);
4208: v_success BOOLEAN;
4209: v_sql VARCHAR2(255);
4210: v_curr_col_name_map SYSTEM.QRM_VARCHAR_table := SYSTEM.QRM_VARCHAR_table();

Line 4210: v_curr_col_name_map SYSTEM.QRM_VARCHAR_table := SYSTEM.QRM_VARCHAR_table();

4206: v_curr SYSTEM.QRM_VARCHAR_table;
4207: i NUMBER(3);
4208: v_success BOOLEAN;
4209: v_sql VARCHAR2(255);
4210: v_curr_col_name_map SYSTEM.QRM_VARCHAR_table := SYSTEM.QRM_VARCHAR_table();
4211:
4212: CURSOR get_column_header IS
4213: SELECT DECODE(type,-2,a1,-1,a1,tot_currency) FROM qrm_saved_analyses_col
4214: WHERE analysis_name=p_name AND seq_no>p_row_agg_no

Line 4223: v_curr := SYSTEM.QRM_VARCHAR_table();

4219: xtr_risk_debug_pkg.dpush(null,'QRM_PA_AGGREGATION_P.UPDATE_AGG_CURR');--bug 3236479
4220: END IF;
4221:
4222: IF p_ccy_case_flag=1 THEN
4223: v_curr := SYSTEM.QRM_VARCHAR_table();
4224: v_curr.EXTEND(100);
4225: FOR i IN 1..v_curr.COUNT LOOP
4226: v_curr(i) := p_underlying_ccy;
4227: END LOOP;

Line 4230: v_curr := SYSTEM.QRM_VARCHAR_table();

4226: v_curr(i) := p_underlying_ccy;
4227: END LOOP;
4228: v_success := update_currency_columns(1,p_name,p_ref_date,v_curr);
4229: ELSIF p_ccy_case_flag=2 THEN
4230: v_curr := SYSTEM.QRM_VARCHAR_table();
4231: v_curr.EXTEND(100);
4232: --need to make it into array of size 100 bec. of the
4233: --update SQL
4234: FOR i IN 1..p_agg_col_curr.COUNT LOOP

Line 4261: v_curr := SYSTEM.QRM_VARCHAR_table();

4257: --update SQL
4258: v_curr.EXTEND(100-p_max_col_no);
4259: v_success := update_currency_columns(1,p_name,p_ref_date,v_curr);
4260: ELSE --p_ccy_agg_flag=0
4261: v_curr := SYSTEM.QRM_VARCHAR_table();
4262: v_curr.EXTEND(100);
4263: FOR i IN 1..v_curr.COUNT LOOP
4264: v_curr(i) := p_curr_reporting;
4265: END LOOP;