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_ANALYSIS_SETTINGS

Line 1494: FROM qrm_analysis_settings

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,
1492: end_date_ref, end_date_offset, end_offset_type, business_week,
1493: gl_calendar_id,currency_source,curr_reporting,md_set_code
1494: FROM qrm_analysis_settings
1495: WHERE analysis_name=p_name AND history_flag='S';
1496:
1497: CURSOR attribute_data IS
1498: SELECT DECODE(a.type,'R',1,'C',2,'M',3,4) seq, a.att_order,

Line 1649: --Update currency_used in qrm_analysis_settings

1645: FND_MESSAGE.SET_NAME('QRM','QRM_CALC_NO_DEFAULT_SPOT_ERR');
1646: FND_MESSAGE.SET_TOKEN('CCY',v_curr_reporting);
1647: raise e_pagg_no_fxrate_found;
1648: END IF;
1649: --Update currency_used in qrm_analysis_settings
1650: IF v_ccy_case_flag=0 AND v_ccy_agg_flag=0 THEN --use curr_reporting
1651: UPDATE qrm_analysis_settings
1652: SET currency_used='R', last_updated_by=FND_GLOBAL.user_id,
1653: last_update_date=p_ref_date, last_update_login=FND_GLOBAL.login_id

Line 1651: UPDATE qrm_analysis_settings

1647: raise e_pagg_no_fxrate_found;
1648: END IF;
1649: --Update currency_used in qrm_analysis_settings
1650: IF v_ccy_case_flag=0 AND v_ccy_agg_flag=0 THEN --use curr_reporting
1651: UPDATE qrm_analysis_settings
1652: SET currency_used='R', last_updated_by=FND_GLOBAL.user_id,
1653: last_update_date=p_ref_date, last_update_login=FND_GLOBAL.login_id
1654: WHERE analysis_name=p_name AND history_flag='S';
1655: ELSE --use whatever in currency_source

Line 1656: UPDATE qrm_analysis_settings

1652: SET currency_used='R', last_updated_by=FND_GLOBAL.user_id,
1653: last_update_date=p_ref_date, last_update_login=FND_GLOBAL.login_id
1654: WHERE analysis_name=p_name AND history_flag='S';
1655: ELSE --use whatever in currency_source
1656: UPDATE qrm_analysis_settings
1657: SET currency_used=currency_source, last_updated_by=FND_GLOBAL.user_id,
1658: last_update_date=p_ref_date, last_update_login=FND_GLOBAL.login_id
1659: WHERE analysis_name=p_name AND history_flag='S';
1660: END IF;

Line 1663: XTR_RISK_DEBUG_PKG.dlog('DML','Updated QRM_ANALYSIS_SETTINGS.CURRENCY_USED',

1659: WHERE analysis_name=p_name AND history_flag='S';
1660: END IF;
1661:
1662: IF (g_event_level>=g_debug_level) THEN --bug 3236479
1663: XTR_RISK_DEBUG_PKG.dlog('DML','Updated QRM_ANALYSIS_SETTINGS.CURRENCY_USED',
1664: 'QRM_PA_AGGREGATION_P.TRANSFORM_AND_SAVE',g_event_level);
1665: END IF;
1666:
1667: --Fix end date to be used later, alrady calculated and saved by FHU engine

Line 2524: UPDATE qrm_analysis_settings SET dirty='N' WHERE analysis_name=p_name;

2520: END IF;
2521:
2522: --update dirty column if called from 'OA'
2523: IF p_caller_flag='OA' THEN
2524: UPDATE qrm_analysis_settings SET dirty='N' WHERE analysis_name=p_name;
2525:
2526: IF (g_event_level>=g_debug_level) THEN --bug 3236479
2527: XTR_RISK_DEBUG_PKG.dlog('DML','Updated QRM_ANALYSIS_SETTINGS.DIRTY=N',
2528: 'QRM_PA_AGGREGATION_P.TRANSFORM_AND_SAVE',g_event_level);

Line 2527: XTR_RISK_DEBUG_PKG.dlog('DML','Updated QRM_ANALYSIS_SETTINGS.DIRTY=N',

2523: IF p_caller_flag='OA' THEN
2524: UPDATE qrm_analysis_settings SET dirty='N' WHERE analysis_name=p_name;
2525:
2526: IF (g_event_level>=g_debug_level) THEN --bug 3236479
2527: XTR_RISK_DEBUG_PKG.dlog('DML','Updated QRM_ANALYSIS_SETTINGS.DIRTY=N',
2528: 'QRM_PA_AGGREGATION_P.TRANSFORM_AND_SAVE',g_event_level);
2529: END IF;
2530:
2531: END IF;

Line 3450: SELECT style,md_set_code FROM qrm_analysis_settings

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
3451: WHERE analysis_name=p_name AND history_flag='S';
3452: v_max_col_no NUMBER(5);
3453: v_row_agg_no NUMBER(5);
3454: v_style VARCHAR2(1);

Line 3456: v_md_set_code qrm_analysis_settings.md_set_code%TYPE;

3452: v_max_col_no NUMBER(5);
3453: v_row_agg_no NUMBER(5);
3454: v_style VARCHAR2(1);
3455: v_success BOOLEAN;
3456: v_md_set_code qrm_analysis_settings.md_set_code%TYPE;
3457:
3458: BEGIN
3459:
3460: IF (g_proc_level>=g_debug_level) THEN

Line 4033: UPDATE qrm_analysis_settings SET dirty='N' WHERE analysis_name=p_name;

4029: END IF;
4030:
4031: --update dirty flag if semi-dirty
4032: IF p_dirty IN ('C','S') THEN
4033: UPDATE qrm_analysis_settings SET dirty='N' WHERE analysis_name=p_name;
4034: END IF;
4035:
4036: IF (g_event_level>=g_debug_level) THEN
4037: xtr_risk_debug_pkg.dlog('DML','UPDATE QRM_ANALYSIS_SETTINGS.DIRTY=N',

Line 4037: xtr_risk_debug_pkg.dlog('DML','UPDATE QRM_ANALYSIS_SETTINGS.DIRTY=N',

4033: UPDATE qrm_analysis_settings SET dirty='N' WHERE analysis_name=p_name;
4034: END IF;
4035:
4036: IF (g_event_level>=g_debug_level) THEN
4037: xtr_risk_debug_pkg.dlog('DML','UPDATE QRM_ANALYSIS_SETTINGS.DIRTY=N',
4038: 'QRM_PA_AGGREGATION_P.CALC_TABLE_TOTAL',g_event_level);--bug 3236479
4039: END IF;
4040:
4041: IF (g_proc_level>=g_debug_level) THEN

Line 4313: SELECT tb_label FROM qrm_analysis_settings

4309: i NUMBER(5);
4310: v_row_agg_no NUMBER(5);
4311: v_dummy NUMBER;
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;

Line 4389: SELECT style FROM qrm_analysis_settings

4385:
4386: v_style VARCHAR2(1);
4387: v_success BOOLEAN := TRUE;
4388: CURSOR get_style IS
4389: SELECT style FROM qrm_analysis_settings
4390: WHERE analysis_name=p_name AND history_flag='S';
4391: BEGIN
4392: IF (g_proc_level>=g_debug_level) THEN
4393: xtr_risk_debug_pkg.dpush(null,'QRM_PA_AGGREGATION_P.UPDATE_SEMIDIRTY');

Line 4438: UPDATE qrm_analysis_settings SET dirty='N' WHERE analysis_name=p_name;

4434: END IF;
4435: END IF;
4436:
4437: --update dirty flag
4438: UPDATE qrm_analysis_settings SET dirty='N' WHERE analysis_name=p_name;
4439: COMMIT;
4440: IF (g_proc_level>=g_debug_level) THEN
4441: xtr_risk_debug_pkg.dpop(null,'QRM_PA_AGGREGATION_P.UPDATE_SEMIDIRTY');
4442: END IF;