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_ROW

Line 601: QRM_SAVED_ANALYSES_ROW.

597: This procedure calculate the currency multipliers if there are
598: > 1 underlying currencies across the column aggregates.
599: The currency multipliers will then saved into an array that is
600: identical to the array used when inserting measures into
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,

Line 722: --QRM_SAVED_ANALYSES_ROW

718: END IF;
719: ELSE
720: NULL;
721: --put in similar totaling logic to the one for
722: --QRM_SAVED_ANALYSES_ROW
723: END IF;
724:
725: IF v_null THEN
726: v_total := NULL;

Line 736: This procedure insert 1 row at a time to qrm_saved_analyses_row

732:
733:
734:
735: /***************************************************************
736: This procedure insert 1 row at a time to qrm_saved_analyses_row
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: ***************************************************************/

Line 846: INSERT INTO qrm_saved_analyses_row(analysis_name,seq_no,type,hidden,

842: END IF;
843: IF sm.COUNT<20 THEN
844: sm.EXTEND(20-p_max_col_no);
845: END IF;
846: INSERT INTO qrm_saved_analyses_row(analysis_name,seq_no,type,hidden,
847: tot_currency,tot_currency_label,a1,a2,a3,a4,a5,m1,m2,m3,m4,m5,m6,m7,m8,m9,m10,m11,m12,m13,m14,m15,
848: m16,m17,m18,m19,m20,created_by,creation_date,last_updated_by,last_update_date,
849: last_update_login)
850: VALUES(p_name,p_row,p_type,p_hidden,v_tot_currency,v_tot_currency_label,

Line 864: INSERT INTO qrm_saved_analyses_row(analysis_name,seq_no,type,hidden,

860: END IF;
861: IF sm.COUNT<50 THEN
862: sm.EXTEND(50-p_max_col_no);
863: END IF;
864: INSERT INTO qrm_saved_analyses_row(analysis_name,seq_no,type,hidden,
865: tot_currency,tot_currency_label,a1,a2,a3,a4,a5,a6,a7,a8,a9,a10,m1,m2,m3,m4,
866: m5,m6,m7,m8,m9,m10,m11,
867: m12,m13,m14,m15,m16,m17,m18,m19,m20,m21,m22,m23,m24,m25,m26,m27,m28,m29,m30,
868: m31,m32,m33,m34,m35,m36,m37,m38,m39,m40,m41,m42,m43,m44,m45,m46,m47,m48,m49,

Line 888: INSERT INTO qrm_saved_analyses_row(analysis_name,seq_no,type,hidden,

884: END IF;
885: IF sm.COUNT<100 THEN
886: sm.EXTEND(100-p_max_col_no);
887: END IF;
888: INSERT INTO qrm_saved_analyses_row(analysis_name,seq_no,type,hidden,
889: tot_currency,tot_currency_label,a1,a2,a3,a4,a5,a6,a7,a8,a9,a10,a11,a12,a13,
890: a14,a15,a16,m1,m2,m3,
891: m4,m5,m6,m7,m8,m9,m10,m11,m12,m13,m14,m15,m16,m17,m18,m19,m20,m21,m22,m23,m24,
892: m25,m26,m27,m28,m29,m30,m31,m32,m33,m34,m35,m36,m37,m38,m39,m40,m41,m42,m43,

Line 914: XTR_RISK_DEBUG_PKG.dlog('DML','Inserted into QRM_SAVED_ANALYSES_ROW',

910: FND_GLOBAL.login_id);
911: END IF;
912:
913: IF (g_event_level>=g_debug_level) THEN --bug 3236479
914: XTR_RISK_DEBUG_PKG.dlog('DML','Inserted into QRM_SAVED_ANALYSES_ROW',
915: 'QRM_PA_AGGREGATION_P.INSERT_ROW',g_event_level);
916: xtr_risk_debug_pkg.dpush(null,'QRM_PA_AGGREGATION_P.INSERT_ROW');
917: END IF;
918:

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 1581: DELETE qrm_saved_analyses_row WHERE analysis_name=p_name;

1577: RAISE e_pagg_no_setting_found;
1578: END IF;
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;

Line 1929: --Parse the results (row: qrm_saved_analyses_row)

1925: END IF;
1926:
1927: --open dynamic cursor
1928: v_cursor := dbms_sql.open_cursor;
1929: --Parse the results (row: qrm_saved_analyses_row)
1930: dbms_sql.parse(v_cursor,v_sql,dbms_sql.native);
1931: dbms_sql.bind_variable(v_cursor,'analysis_name',p_name);
1932: --remember to add end_date as binding variable
1933: --for special cases

Line 3110: --update qrm_saved_analyses_row first

3106: BEGIN
3107: IF (g_proc_level>=g_debug_level) THEN
3108: xtr_risk_debug_pkg.dpush(null,'QRM_PA_AGGREGATION_P.UPDATE_TOTAL');--bug 3236479
3109: END IF;
3110: --update qrm_saved_analyses_row first
3111: --set all the total rows to be hidden
3112: UPDATE qrm_saved_analyses_row
3113: SET hidden='Y', last_updated_by=FND_GLOBAL.user_id, last_update_date=p_ref_date, last_update_login=FND_GLOBAL.login_id
3114: WHERE type>0 AND analysis_name=p_name;

Line 3112: UPDATE qrm_saved_analyses_row

3108: xtr_risk_debug_pkg.dpush(null,'QRM_PA_AGGREGATION_P.UPDATE_TOTAL');--bug 3236479
3109: END IF;
3110: --update qrm_saved_analyses_row first
3111: --set all the total rows to be hidden
3112: UPDATE qrm_saved_analyses_row
3113: SET hidden='Y', last_updated_by=FND_GLOBAL.user_id, last_update_date=p_ref_date, last_update_login=FND_GLOBAL.login_id
3114: WHERE type>0 AND analysis_name=p_name;
3115:
3116: IF (g_event_level>=g_debug_level) THEN --bug 3236479

Line 3122: UPDATE qrm_saved_analyses_row

3118: 'QRM_PA_AGGREGATION_P.UPDATE_TOTAL',g_event_level);
3119: END IF;
3120:
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

Line 3193: UPDATE qrm_saved_analyses_row

3189: IF (g_proc_level>=g_debug_level) THEN
3190: xtr_risk_debug_pkg.dpush(null,'QRM_PA_AGGREGATION_P.UPDATE_PERCENT_COLS');--bug 3236479
3191: END IF;
3192:
3193: UPDATE qrm_saved_analyses_row
3194: SET p1=p_meas(1),p2=p_meas(2),p3=p_meas(3),
3195: p4=p_meas(4),p5=p_meas(5),p6=p_meas(6),
3196: p7=p_meas(7),p8=p_meas(8),p9=p_meas(9),
3197: p10=p_meas(10),p11=p_meas(11),

Line 3317: FROM qrm_saved_analyses_row

3313: curr69,curr70,curr71,curr72,curr73,curr74,curr75,curr76,curr77,
3314: curr78,curr79,curr80,curr81,curr82,curr83,curr84,curr85,
3315: curr86,curr87,curr88,curr89,curr90,curr91,curr92,curr93,curr94,
3316: curr95,curr96,curr97,curr98,curr99,curr100
3317: FROM qrm_saved_analyses_row
3318: WHERE analysis_name=p_name
3319: ORDER BY seq_no;
3320:
3321: BEGIN

Line 3522: FROM qrm_saved_analyses_row

3518: m35,m36,m37,m38,m39,m40,m41,m42,m43,m44,m45,m46,m47,m48,m49,m50,m51,
3519: m52,m53,m54,m55,m56,m57,m58,m59,m60,m61,m62,m63,m64,m65,m66,m67,m68,
3520: m69,m70,m71,m72,m73,m74,m75,m76,m77,m78,m79,m80,m81,m82,m83,m84,m85,
3521: m86,m87,m88,m89,m90,m91,m92,m93,m94,m95,m96,m97,m98,m99,m100
3522: FROM qrm_saved_analyses_row
3523: WHERE analysis_name=p_name AND type=v_level ORDER BY seq_no;
3524: BEGIN
3525:
3526: IF (g_proc_level>=g_debug_level) THEN

Line 3580: UPDATE qrm_saved_analyses_row

3576: v_tot(88),v_tot(89),v_tot(90),
3577: v_tot(91),v_tot(92),v_tot(93),v_tot(94),v_tot(95),
3578: v_tot(96),v_tot(97),v_tot(98),v_tot(99),v_tot(100);
3579: --calculating the % while updating the rows in between
3580: UPDATE qrm_saved_analyses_row
3581: SET p1=100*p1/v_tot(1),p2=100*p2/v_tot(2),p3=100*p3/v_tot(3),
3582: p4=100*p4/v_tot(4),p5=100*p5/v_tot(5),p6=100*p6/v_tot(6),
3583: p7=100*p7/v_tot(7),p8=100*p8/v_tot(8),p9=100*p9/v_tot(9),
3584: p10=100*p10/v_tot(10),p11=100*p11/v_tot(11),

Line 3716: v_sql:='UPDATE qrm_saved_analyses_row SET '||v_sql||' , last_updated_by=FND_GLOBAL.user_id, last_update_date=:p_ref_date, last_update_login=FND_GLOBAL.login_id WHERE analysis_name=:p_name';

3712: v_sql := v_sql||'p'||j||'=100*p'||j||'/DECODE(p'||v_tot_segment||',0,TO_NUMBER('''||v_divisor||'''),p'||v_tot_segment||')';
3713: END IF;
3714:
3715: END LOOP;
3716: v_sql:='UPDATE qrm_saved_analyses_row SET '||v_sql||' , last_updated_by=FND_GLOBAL.user_id, last_update_date=:p_ref_date, last_update_login=FND_GLOBAL.login_id WHERE analysis_name=:p_name';
3717:
3718: IF (g_proc_level>=g_debug_level) THEN
3719: xtr_risk_debug_pkg.dlog('v_sql',v_sql);
3720: END IF;

Line 3771: The label of table qrm_saved_analyses_row will be updated at run

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
3775:

Line 4076: UPDATE qrm_saved_analyses_row

4072: IF (g_proc_level>=g_debug_level) THEN
4073: xtr_risk_debug_pkg.dpush('QRM_PA_AGGREGATION_P.UPDATE_CURR_COL');
4074: END IF;
4075: IF p_indicator=1 THEN
4076: UPDATE qrm_saved_analyses_row
4077: SET curr1=v_curr(1),curr2=v_curr(2),curr3=v_curr(3),
4078: curr4=v_curr(4),curr5=v_curr(5),curr6=v_curr(6),
4079: curr7=v_curr(7),curr8=v_curr(8),curr9=v_curr(9),
4080: curr10=v_curr(10),curr11=v_curr(11),curr12=v_curr(12),

Line 4119: XTR_RISK_DEBUG_PKG.dlog('DML','Updated QRM_SAVED_ANALYSES_ROW.CURR1..100 with p_indicator=1',

4115: last_update_login=FND_GLOBAL.login_id
4116: WHERE analysis_name=p_name;
4117:
4118: IF (g_event_level>=g_debug_level) THEN --bug 3236479
4119: XTR_RISK_DEBUG_PKG.dlog('DML','Updated QRM_SAVED_ANALYSES_ROW.CURR1..100 with p_indicator=1',
4120: 'QRM_PA_AGGREGATION_P.UPDATE_CURRENCY_COLUMNS',g_event_level);
4121: END IF;
4122:
4123: ELSE --p_indicator=2 where curr1 has the CCY for the row

Line 4124: UPDATE qrm_saved_analyses_row

4120: 'QRM_PA_AGGREGATION_P.UPDATE_CURRENCY_COLUMNS',g_event_level);
4121: END IF;
4122:
4123: ELSE --p_indicator=2 where curr1 has the CCY for the row
4124: UPDATE qrm_saved_analyses_row
4125: SET curr2=curr1,curr3=curr1,
4126: curr4=curr1,curr5=curr1,curr6=curr1,
4127: curr7=curr1,curr8=curr1,curr9=curr1,
4128: curr10=curr1,curr11=curr1,curr12=curr1,

Line 4167: XTR_RISK_DEBUG_PKG.dlog('DML','Updated QRM_SAVED_ANALYSES_ROW.CURR1..100 with p_indicator='||p_indicator,

4163: last_update_login=FND_GLOBAL.login_id
4164: WHERE analysis_name=p_name;
4165:
4166: IF (g_event_level>=g_debug_level) THEN --bug 3236479
4167: XTR_RISK_DEBUG_PKG.dlog('DML','Updated QRM_SAVED_ANALYSES_ROW.CURR1..100 with p_indicator='||p_indicator,
4168: 'QRM_PA_AGGREGATION_P.UPDATE_CURRENCY_COLUMNS',g_event_level);
4169: END IF;
4170:
4171: END IF;

Line 4240: v_sql := 'UPDATE qrm_saved_analyses_row SET curr1=DECODE(type,-1,a'||p_ccy_agg_level||',tot_currency) WHERE analysis_name=:analysis_name';

4236: END LOOP;
4237: v_success := update_currency_columns(1,p_name,p_ref_date,v_curr);
4238: ELSIF p_ccy_case_flag=0 THEN
4239: IF p_ccy_agg_flag=1 THEN
4240: v_sql := 'UPDATE qrm_saved_analyses_row SET curr1=DECODE(type,-1,a'||p_ccy_agg_level||',tot_currency) WHERE analysis_name=:analysis_name';
4241: IF (g_proc_level>=g_debug_level) THEN
4242: xtr_risk_debug_pkg.dlog('v_sql',v_sql);
4243: END IF;
4244: EXECUTE IMMEDIATE v_sql USING p_name;

Line 4247: XTR_RISK_DEBUG_PKG.dlog('DML','Updated QRM_SAVED_ANALYSES_ROW.CURR1',

4243: END IF;
4244: EXECUTE IMMEDIATE v_sql USING p_name;
4245:
4246: IF (g_event_level>=g_debug_level) THEN --bug 3236479
4247: XTR_RISK_DEBUG_PKG.dlog('DML','Updated QRM_SAVED_ANALYSES_ROW.CURR1',
4248: 'QRM_PA_AGGREGATION_P.UPDATE_AGGREGATE_CURR',g_event_level);
4249: END IF;
4250:
4251: v_success := update_currency_columns(2,p_name,p_ref_date,v_curr);