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_VARCHAR240_TABLE

Line 40: p_agg IN OUT NOCOPY SYSTEM.QRM_VARCHAR240_TABLE,

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,
44: p_ccy_suffix OUT NOCOPY VARCHAR2,

Line 456: p_agg IN OUT NOCOPY SYSTEM.QRM_VARCHAR240_TABLE,

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,
460: p_actual_agg_usd IN OUT NOCOPY SYSTEM.QRM_VARCHAR240_TABLE,

Line 457: p_actual_agg IN OUT NOCOPY SYSTEM.QRM_VARCHAR240_TABLE,

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,
460: p_actual_agg_usd IN OUT NOCOPY SYSTEM.QRM_VARCHAR240_TABLE,
461: p_nom_fl_usd IN OUT NOCOPY SYSTEM.QRM_VARCHAR240_TABLE,

Line 458: p_nom_fl IN OUT NOCOPY SYSTEM.QRM_VARCHAR240_TABLE,

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,
460: p_actual_agg_usd IN OUT NOCOPY SYSTEM.QRM_VARCHAR240_TABLE,
461: p_nom_fl_usd IN OUT NOCOPY SYSTEM.QRM_VARCHAR240_TABLE,
462: p_denom_fl_usd IN OUT NOCOPY SYSTEM.QRM_VARCHAR240_TABLE,

Line 459: p_denom_fl IN OUT NOCOPY SYSTEM.QRM_VARCHAR240_TABLE,

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,
460: p_actual_agg_usd IN OUT NOCOPY SYSTEM.QRM_VARCHAR240_TABLE,
461: p_nom_fl_usd IN OUT NOCOPY SYSTEM.QRM_VARCHAR240_TABLE,
462: p_denom_fl_usd IN OUT NOCOPY SYSTEM.QRM_VARCHAR240_TABLE,
463: p_ccy_suffix VARCHAR2,

Line 460: p_actual_agg_usd IN OUT NOCOPY SYSTEM.QRM_VARCHAR240_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,
460: p_actual_agg_usd IN OUT NOCOPY SYSTEM.QRM_VARCHAR240_TABLE,
461: p_nom_fl_usd IN OUT NOCOPY SYSTEM.QRM_VARCHAR240_TABLE,
462: p_denom_fl_usd IN OUT NOCOPY SYSTEM.QRM_VARCHAR240_TABLE,
463: p_ccy_suffix VARCHAR2,
464: p_ccy_multiplier NUMBER,

Line 461: p_nom_fl_usd 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,
460: p_actual_agg_usd IN OUT NOCOPY SYSTEM.QRM_VARCHAR240_TABLE,
461: p_nom_fl_usd IN OUT NOCOPY SYSTEM.QRM_VARCHAR240_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,

Line 462: p_denom_fl_usd 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,
460: p_actual_agg_usd IN OUT NOCOPY SYSTEM.QRM_VARCHAR240_TABLE,
461: p_nom_fl_usd IN OUT NOCOPY SYSTEM.QRM_VARCHAR240_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,

Line 938: p_agg IN OUT NOCOPY SYSTEM.QRM_VARCHAR240_TABLE,

934: ***************************************************************/
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,

Line 940: p_nom IN OUT NOCOPY SYSTEM.QRM_VARCHAR240_TABLE,

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,
944: p_sql_col OUT NOCOPY VARCHAR2,

Line 941: p_denom IN OUT NOCOPY SYSTEM.QRM_VARCHAR240_TABLE,

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,
944: p_sql_col OUT NOCOPY VARCHAR2,
945: p_row_agg_no OUT NOCOPY NUMBER,

Line 960: v_act_agg SYSTEM.QRM_VARCHAR240_TABLE := SYSTEM.QRM_VARCHAR240_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();
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();

Line 961: v_agg_usd SYSTEM.QRM_VARCHAR240_TABLE := SYSTEM.QRM_VARCHAR240_TABLE();

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

Line 963: v_nom_fl_usd SYSTEM.QRM_VARCHAR240_TABLE := SYSTEM.QRM_VARCHAR240_TABLE();

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';
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';

Line 964: v_denom_fl_usd SYSTEM.QRM_VARCHAR240_TABLE := SYSTEM.QRM_VARCHAR240_TABLE();

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

Line 1512: v_agg SYSTEM.QRM_VARCHAR240_TABLE;

1508: SELECT COUNT(*) FROM qrm_saved_analyses_col
1509: WHERE analysis_name=p_name
1510: AND type>-2;
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;

Line 1516: v_nom_fl SYSTEM.QRM_VARCHAR240_TABLE;

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;
1520: v_dummy1 xtr_md_num_table;

Line 1517: v_denom_fl 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;
1520: v_dummy1 xtr_md_num_table;
1521: v_amount SYSTEM.QRM_VARCHAR_table;

Line 3780: p_agg IN OUT NOCOPY SYSTEM.QRM_VARCHAR240_TABLE,

3776: DEAL_SUBTYPE -> xtr_deal_subtypes.user_deal_subtype
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

Line 3843: p_att_name IN OUT NOCOPY SYSTEM.QRM_VARCHAR240_TABLE,--11

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
3846: p_sensitivity SYSTEM.QRM_VARCHAR_TABLE, --14
3847: p_analysis_type VARCHAR2, --15

Line 3856: v_nom SYSTEM.QRM_VARCHAR240_TABLE := SYSTEM.QRM_VARCHAR240_TABLE();

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);
3860: i NUMBER(5);

Line 3857: v_denom SYSTEM.QRM_VARCHAR240_TABLE := SYSTEM.QRM_VARCHAR240_TABLE();

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);
3860: i NUMBER(5);
3861: v_cursor INTEGER;