[Home] [Help]
1498: SELECT DECODE(a.type,'R',1,'C',2,'M',3,4) seq, a.att_order,
1499: a.attribute_name, a.type, a.total_average, a.percentage, l.numerator,
1500: l.denominator, l.origin, l.amount, l.ccy_aggregate, l.sensitivity,
1501: l.num_denom_origin
1502: FROM qrm_analysis_atts a, qrm_ana_atts_lookups l
1503: WHERE a.attribute_name=l.attribute_name AND a.analysis_name=p_name
1504: AND history_flag='S'
1505: ORDER BY 1,2;
1506:
1684: IF v_style='X' AND p_caller_flag='OA' THEN
1685: OPEN count_max_col_no;
1686: FETCH count_max_col_no INTO v_max_col_no;
1687: CLOSE count_max_col_no;
1688: --there is no agg for column in qrm_analysis_atts for style=X
1689: v_col_agg_no := 0;
1690: ELSE
1691: --loop over the col. header cursor and populate qrm_saved_analyses_table
1692: v_col_seq_no.EXTEND(v_row_agg_no);
1759: v_business_week,v_col_seq_no,v_col_seq_no_key,
1760: v_col_name_map,v_percent_col_name_map,v_a1,
1761: v_col_type,v_col_hidden,v_start_date,v_end_date,
1762: v_tb_label_arr);
1763: --there is no agg for column in qrm_analysis_atts for style=X
1764: v_col_agg_no := 0;
1765: ELSIF v_style='A' THEN
1766: --if need usd arr then v_measure will include additional '_usd'
1767: --amount columns
3121: --set selected total rows to be displayed
3122: UPDATE qrm_saved_analyses_row
3123: SET hidden='N', last_updated_by=FND_GLOBAL.user_id, last_update_date=p_ref_date, last_update_login=FND_GLOBAL.login_id
3124: WHERE analysis_name=p_name
3125: AND type IN (SELECT att_order FROM qrm_analysis_atts
3126: WHERE analysis_name=p_name
3127: AND total_ind<>'N'
3128: AND type='R'
3129: AND history_flag='S');
3147: --set selected total rows to be displayed
3148: UPDATE qrm_saved_analyses_col
3149: SET hidden='N', last_updated_by=FND_GLOBAL.user_id, last_update_date=p_ref_date, last_update_login=FND_GLOBAL.login_id
3150: WHERE analysis_name=p_name
3151: AND type IN (SELECT att_order FROM qrm_analysis_atts
3152: WHERE analysis_name=p_name
3153: AND total_ind<>'N'
3154: AND type='C'
3155: AND history_flag='S');
3506: v_divisor NUMBER := 0.000001; --bug 2393972
3507: v_success BOOLEAN;
3508:
3509: CURSOR percent_info IS
3510: SELECT type,att_order FROM qrm_analysis_atts
3511: WHERE analysis_name=p_name AND percentage='Y' AND history_flag='S';
3512: CURSOR get_col_tot_seq_no IS
3513: SELECT seq_no FROM qrm_saved_analyses_col
3514: WHERE analysis_name=p_name AND type=v_level;