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_SAVED_ANALYSES_COL

Line 971: --whether qrm_saved_analyses_col is used or not

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);
970: v_aggregate_level NUMBER(5);
971: --whether qrm_saved_analyses_col is used or not
972: v_col_used BOOLEAN := FALSE;
973: --whether qrm_deal_calculations is used or not for p_sql_col
974: v_table_used_col BOOLEAN := FALSE;
975: v_origin VARCHAR2(1);

Line 1265: p_sql := p_sql||','||'qrm_saved_analyses_col c';

1261:
1262: --add FROM clause
1263: p_sql := p_sql||v_from;
1264: IF v_col_used THEN
1265: p_sql := p_sql||','||'qrm_saved_analyses_col c';
1266: END IF;
1267: IF p_tb_calc_used THEN
1268: p_sql := p_sql||','||'qrm_tb_calculations tb';
1269: END IF;

Line 1396: qrm_saved_analyses_row and qrm_saved_analyses_col tables.

1392:
1393: /***************************************************************
1394: This function is the main function that does aggregation,
1395: transformation of the data and saving them into the
1396: qrm_saved_analyses_row and qrm_saved_analyses_col tables.
1397: ***************************************************************/
1398: FUNCTION transform_and_save (p_name VARCHAR2,
1399: p_ref_date DATE,
1400: p_caller_flag VARCHAR2)

Line 1508: SELECT COUNT(*) FROM qrm_saved_analyses_col

1504: AND history_flag='S'
1505: ORDER BY 1,2;
1506:
1507: CURSOR count_max_col_no IS
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;

Line 1583: DELETE qrm_saved_analyses_col WHERE analysis_name=p_name;

1579:
1580: --DELETE existing saved data
1581: DELETE qrm_saved_analyses_row WHERE analysis_name=p_name;
1582: IF NOT (v_style='X' AND p_caller_flag='OA') THEN
1583: DELETE qrm_saved_analyses_col WHERE analysis_name=p_name;
1584: END IF;
1585: COMMIT;
1586: --xtr_risk_debug_pkg.dlog('v_analysis_type',v_analysis_type);
1587: --xtr_risk_debug_pkg.dlog('v_style',v_style);

Line 1840: INSERT INTO qrm_saved_analyses_col(analysis_name,seq_no,seq_no_key,

1836:
1837: --bulk insert
1838: IF v_style='X' THEN
1839: FORALL i IN 1..v_max_col_no+v_row_agg_no
1840: INSERT INTO qrm_saved_analyses_col(analysis_name,seq_no,seq_no_key,
1841: type,hidden,col_name_map,a1,percent_col_name_map,start_date,
1842: end_date,tb_label,created_by,creation_date,last_updated_by,
1843: last_update_date,
1844: last_update_login) VALUES(p_name,v_col_seq_no(i),

Line 1853: INSERT INTO qrm_saved_analyses_col(analysis_name,seq_no,seq_no_key,

1849: FND_GLOBAL.user_id,p_ref_date,FND_GLOBAL.user_id,p_ref_date,
1850: FND_GLOBAL.login_id);
1851: ELSE
1852: FORALL i IN 1..v_max_col_no+v_row_agg_no
1853: INSERT INTO qrm_saved_analyses_col(analysis_name,seq_no,seq_no_key,
1854: type,hidden,col_name_map,a1,percent_col_name_map,created_by,
1855: creation_date,last_updated_by,last_update_date,
1856: last_update_login)
1857: VALUES(p_name,v_col_seq_no(i),v_col_seq_no_key(i),v_col_type(i),

Line 1866: XTR_RISK_DEBUG_PKG.dlog('DML','Inserted into QRM_SAVED_ANALYSES_COL',

1862: END IF;
1863: COMMIT;
1864:
1865: IF (g_event_level>=g_debug_level) THEN --bug 3236479
1866: XTR_RISK_DEBUG_PKG.dlog('DML','Inserted into QRM_SAVED_ANALYSES_COL',
1867: 'QRM_PA_AGGREGATION_P.TRANSFORM_AND_SAVE',g_event_level);
1868: END IF;
1869:
1870: ----Start Bug 2566711

Line 1874: UPDATE qrm_saved_analyses_col

1870: ----Start Bug 2566711
1871: --update the tot_currency and tot_currency_label columns
1872: IF v_style IN ('C','X') THEN
1873: IF v_ccy_case_flag=0 AND v_ccy_agg_flag=2 THEN
1874: UPDATE qrm_saved_analyses_col
1875: SET tot_currency=v_curr_reporting,
1876: tot_currency_label=' ('||v_curr_reporting||')',
1877: last_updated_by=FND_GLOBAL.user_id,
1878: last_update_date=p_ref_date,

Line 1882: UPDATE qrm_saved_analyses_col

1878: last_update_date=p_ref_date,
1879: last_update_login=FND_GLOBAL.login_id
1880: WHERE type=1;
1881: ELSIF v_ccy_case_flag=1 THEN
1882: UPDATE qrm_saved_analyses_col
1883: SET tot_currency=v_underlying_ccy,
1884: tot_currency_label=' ('||v_underlying_ccy||')',
1885: last_updated_by=FND_GLOBAL.user_id, last_update_date=p_ref_date,
1886: last_update_login=FND_GLOBAL.login_id

Line 1889: UPDATE qrm_saved_analyses_col

1885: last_updated_by=FND_GLOBAL.user_id, last_update_date=p_ref_date,
1886: last_update_login=FND_GLOBAL.login_id
1887: WHERE type=1;
1888: ELSE
1889: UPDATE qrm_saved_analyses_col
1890: SET tot_currency=NULL,
1891: tot_currency_label=NULL,
1892: last_updated_by=FND_GLOBAL.user_id, last_update_date=p_ref_date,
1893: last_update_login=FND_GLOBAL.login_id

Line 1901: XTR_RISK_DEBUG_PKG.dlog('DML','Updated QRM_SAVED_ANALYSES_COL.TOT_CURRENCY',

1897: ----End Bug 2566711
1898: COMMIT;
1899:
1900: IF (g_event_level>=g_debug_level) THEN --bug 3236479
1901: XTR_RISK_DEBUG_PKG.dlog('DML','Updated QRM_SAVED_ANALYSES_COL.TOT_CURRENCY',
1902: 'QRM_PA_AGGREGATION_P.TRANSFORM_AND_SAVE',g_event_level);
1903: END IF;
1904:
1905: END IF;--for p_caller_flag='OA' and v_style='X'

Line 2883: dates and saved them intot qrm_saved_analyses_col

2879:
2880:
2881: /***************************************************************
2882: This procedure calculates the time-buckets interval actual
2883: dates and saved them intot qrm_saved_analyses_col
2884: ***************************************************************/
2885: PROCEDURE update_timebuckets (p_name VARCHAR2,
2886: p_ref_date DATE,
2887: p_tb_name VARCHAR2,

Line 3136: --update qrm_saved_analyses_col

3132: XTR_RISK_DEBUG_PKG.dlog('DML','Updated QRM_SET_ANALYSES_ROW.HIDDEN=N for those that need to be displayed',
3133: 'QRM_PA_AGGREGATION_P.UPDATE_TOTAL',g_event_level);
3134: END IF;
3135:
3136: --update qrm_saved_analyses_col
3137: --set all the total rows to be hidden
3138: UPDATE qrm_saved_analyses_col
3139: SET hidden='Y', last_updated_by=FND_GLOBAL.user_id, last_update_date=p_ref_date, last_update_login=FND_GLOBAL.login_id
3140: WHERE type>0 AND analysis_name=p_name;

Line 3138: UPDATE qrm_saved_analyses_col

3134: END IF;
3135:
3136: --update qrm_saved_analyses_col
3137: --set all the total rows to be hidden
3138: UPDATE qrm_saved_analyses_col
3139: SET hidden='Y', last_updated_by=FND_GLOBAL.user_id, last_update_date=p_ref_date, last_update_login=FND_GLOBAL.login_id
3140: WHERE type>0 AND analysis_name=p_name;
3141:
3142: IF (g_event_level>=g_debug_level) THEN --bug 3236479

Line 3148: UPDATE qrm_saved_analyses_col

3144: 'QRM_PA_AGGREGATION_P.UPDATE_TOTAL',g_event_level);
3145: END IF;
3146:
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

Line 3442: SELECT COUNT(*) FROM qrm_saved_analyses_col

3438: FUNCTION update_percent (p_name VARCHAR2,p_ref_date DATE)
3439: RETURN BOOLEAN IS
3440:
3441: CURSOR count_column IS
3442: SELECT COUNT(*) FROM qrm_saved_analyses_col
3443: WHERE analysis_name=p_name
3444: AND type>-2;
3445: CURSOR count_row_header IS
3446: SELECT COUNT(*) FROM qrm_saved_analyses_col

Line 3446: SELECT COUNT(*) FROM qrm_saved_analyses_col

3442: SELECT COUNT(*) FROM qrm_saved_analyses_col
3443: WHERE analysis_name=p_name
3444: AND type>-2;
3445: CURSOR count_row_header IS
3446: SELECT COUNT(*) FROM qrm_saved_analyses_col
3447: WHERE analysis_name=p_name
3448: AND type=-2;
3449: CURSOR get_style IS
3450: SELECT style,md_set_code FROM qrm_analysis_settings

Line 3513: SELECT seq_no FROM qrm_saved_analyses_col

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;
3515: CURSOR col_100 IS
3516: SELECT seq_no,m1,m2,m3,m4,m5,m6,m7,m8,m9,m10,m11,m12,m13,m14,m15,m16,m17,
3517: m18,m19,m20,m21,m22,m23,m24,m25,m26,m27,m28,m29,m30,m31,m32,m33,m34,

Line 3660: UPDATE qrm_saved_analyses_col

3656: END LOOP;
3657: CLOSE col_100;
3658:
3659: --update the column info, first null all the COL_PERCENT_LEVEL
3660: UPDATE qrm_saved_analyses_col
3661: SET col_percent_level=NULL, last_updated_by=FND_GLOBAL.user_id, last_update_date=p_ref_date, last_update_login=FND_GLOBAL.login_id
3662: WHERE analysis_name=p_name;
3663: --left null total columns,so it won't be displayed
3664: UPDATE qrm_saved_analyses_col

Line 3664: UPDATE qrm_saved_analyses_col

3660: UPDATE qrm_saved_analyses_col
3661: SET col_percent_level=NULL, last_updated_by=FND_GLOBAL.user_id, last_update_date=p_ref_date, last_update_login=FND_GLOBAL.login_id
3662: WHERE analysis_name=p_name;
3663: --left null total columns,so it won't be displayed
3664: UPDATE qrm_saved_analyses_col
3665: SET col_percent_level=v_level, last_updated_by=FND_GLOBAL.user_id, last_update_date=p_ref_date, last_update_login=FND_GLOBAL.login_id
3666: WHERE analysis_name=p_name AND type=-1;
3667:
3668: IF (g_event_level>=g_debug_level) THEN --bug 3236479

Line 3728: UPDATE qrm_saved_analyses_col

3724: IF (g_proc_level>=g_debug_level) THEN
3725: xtr_risk_debug_pkg.dlog('After EXECUTE IMMEDIATE');
3726: END IF;
3727: --update the column info, first null all the COL_PERCENT_LEVEL
3728: UPDATE qrm_saved_analyses_col
3729: SET col_percent_level=NULL, last_updated_by=FND_GLOBAL.user_id, last_update_date=p_ref_date, last_update_login=FND_GLOBAL.login_id
3730: WHERE analysis_name=p_name;
3731: --left null total columns,so it won't be displayed
3732: UPDATE qrm_saved_analyses_col

Line 3732: UPDATE qrm_saved_analyses_col

3728: UPDATE qrm_saved_analyses_col
3729: SET col_percent_level=NULL, last_updated_by=FND_GLOBAL.user_id, last_update_date=p_ref_date, last_update_login=FND_GLOBAL.login_id
3730: WHERE analysis_name=p_name;
3731: --left null total columns,so it won't be displayed
3732: UPDATE qrm_saved_analyses_col
3733: SET col_percent_level=-v_level, last_updated_by=FND_GLOBAL.user_id, last_update_date=p_ref_date, last_update_login=FND_GLOBAL.login_id
3734: WHERE analysis_name=p_name AND (type=-1 OR type>=v_level);
3735:
3736: IF (g_event_level>=g_debug_level) THEN --bug 3236479

Line 3770: from table qrm_saved_analyses_col.

3766:
3767: /***************************************************************
3768: This function updates the label of the DEAL_TYPE and
3769: DEAL_SUBTYPE aggregate attributes with the user defined ones
3770: from table qrm_saved_analyses_col.
3771: The label of table qrm_saved_analyses_row will be updated at run
3772: time in OA.
3773:
3774: DEAL_TYPE -> xtr_deal_types.user_deal_type

Line 3795: UPDATE qrm_saved_analyses_col

3791: --loop through all the aggregate to see whether DEAL_TYPE is there.
3792: FOR i IN 1..p_agg.COUNT LOOP
3793: IF p_agg(i)='DEAL_TYPE' AND p_att_type(i)='C' THEN
3794: --update the column header to reflect user defined DEAL_TYPE
3795: UPDATE qrm_saved_analyses_col
3796: SET a1=(SELECT DISTINCT user_deal_type FROM xtr_deal_types WHERE deal_type=a1), last_updated_by=FND_GLOBAL.user_id, last_update_date=p_ref_date, last_update_login=FND_GLOBAL.login_id
3797: WHERE analysis_name=p_name AND type=-1;
3798: COMMIT;
3799:

Line 4213: SELECT DECODE(type,-2,a1,-1,a1,tot_currency) FROM qrm_saved_analyses_col

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
4215: ORDER BY 1;
4216:
4217: BEGIN

Line 4274: UPDATE qrm_saved_analyses_col

4270: --insert the currency col name (CURR1, CURR2, ...)
4271: v_curr_col_name_map.EXTEND(p_max_col_no+p_row_agg_no);
4272: FOR i IN p_row_agg_no+1..p_row_agg_no+p_max_col_no LOOP
4273: v_curr_col_name_map(i) := 'CURR'||i;
4274: UPDATE qrm_saved_analyses_col
4275: SET curr_col_name_map=v_curr_col_name_map(i)
4276: WHERE analysis_name=p_name AND seq_no=i;
4277: END LOOP;
4278:

Line 4280: XTR_RISK_DEBUG_PKG.dlog('DML','Updated QRM_SAVED_ANALYSES_COL.CURR_COL_NAME',

4276: WHERE analysis_name=p_name AND seq_no=i;
4277: END LOOP;
4278:
4279: IF (g_event_level>=g_debug_level) THEN --bug 3236479
4280: XTR_RISK_DEBUG_PKG.dlog('DML','Updated QRM_SAVED_ANALYSES_COL.CURR_COL_NAME',
4281: 'QRM_PA_AGGREGATION_P.UPDATE_AGGREGATE_CURR',g_event_level);
4282: END IF;
4283:
4284: IF (g_proc_level>=g_debug_level) THEN

Line 4316: SELECT COUNT(*) FROM qrm_saved_analyses_col

4312: CURSOR get_tb_label IS
4313: SELECT tb_label FROM qrm_analysis_settings
4314: WHERE analysis_name=p_name AND history_flag='S';
4315: CURSOR get_row_agg_no IS
4316: SELECT COUNT(*) FROM qrm_saved_analyses_col
4317: WHERE analysis_name=p_name AND type=-2;
4318: BEGIN
4319: IF (g_proc_level>=g_debug_level) THEN
4320: xtr_risk_debug_pkg.dpush(null,'QRM_PA_AGGREGATION_P.UPDATE_TB_LABEL');

Line 4336: --update the qrm_saved_analyses_col by using the tb label

4332: FETCH get_row_agg_no INTO v_row_agg_no;
4333: CLOSE get_row_agg_no;
4334:
4335: IF v_tb_label='L' THEN
4336: --update the qrm_saved_analyses_col by using the tb label
4337: UPDATE qrm_saved_analyses_col SET a1=tb_label
4338: WHERE analysis_name=p_name AND seq_no>v_row_agg_no
4339: AND type<0;
4340: ELSE --v_tb_label='D'

Line 4337: UPDATE qrm_saved_analyses_col SET a1=tb_label

4333: CLOSE get_row_agg_no;
4334:
4335: IF v_tb_label='L' THEN
4336: --update the qrm_saved_analyses_col by using the tb label
4337: UPDATE qrm_saved_analyses_col SET a1=tb_label
4338: WHERE analysis_name=p_name AND seq_no>v_row_agg_no
4339: AND type<0;
4340: ELSE --v_tb_label='D'
4341: --update the qrm_saved_analyses_col by using the end date

Line 4341: --update the qrm_saved_analyses_col by using the end date

4337: UPDATE qrm_saved_analyses_col SET a1=tb_label
4338: WHERE analysis_name=p_name AND seq_no>v_row_agg_no
4339: AND type<0;
4340: ELSE --v_tb_label='D'
4341: --update the qrm_saved_analyses_col by using the end date
4342: UPDATE qrm_saved_analyses_col SET a1=TO_CHAR(end_date)
4343: WHERE analysis_name=p_name AND seq_no>v_row_agg_no
4344: AND type<0;
4345: END IF;

Line 4342: UPDATE qrm_saved_analyses_col SET a1=TO_CHAR(end_date)

4338: WHERE analysis_name=p_name AND seq_no>v_row_agg_no
4339: AND type<0;
4340: ELSE --v_tb_label='D'
4341: --update the qrm_saved_analyses_col by using the end date
4342: UPDATE qrm_saved_analyses_col SET a1=TO_CHAR(end_date)
4343: WHERE analysis_name=p_name AND seq_no>v_row_agg_no
4344: AND type<0;
4345: END IF;
4346: COMMIT;

Line 4349: XTR_RISK_DEBUG_PKG.dlog('DML','Updated QRM_SAVED_ANALYSES_COL.A1 with v_tb_label='||v_tb_label,

4345: END IF;
4346: COMMIT;
4347:
4348: IF (g_event_level>=g_debug_level) THEN --bug 3236479
4349: XTR_RISK_DEBUG_PKG.dlog('DML','Updated QRM_SAVED_ANALYSES_COL.A1 with v_tb_label='||v_tb_label,
4350: 'QRM_PA_AGGREGATION_P.UPDATE_TIMEBUCKETS_LABELS',g_event_level);
4351: END IF;
4352:
4353: IF (g_proc_level>=g_debug_level) THEN