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 FND_GLOBAL

Line 854: FND_GLOBAL.user_id,p_ref_date,FND_GLOBAL.user_id,p_ref_date,

850: VALUES(p_name,p_row,p_type,p_hidden,v_tot_currency,v_tot_currency_label,
851: sh(1),sh(2),sh(3),sh(4),
852: sh(5),sm(1),sm(2),sm(3),sm(4),sm(5),sm(6),sm(7),sm(8),sm(9),sm(10),sm(11),
853: sm(12),sm(13),sm(14),sm(15),sm(16),sm(17),sm(18),sm(19),sm(20),
854: FND_GLOBAL.user_id,p_ref_date,FND_GLOBAL.user_id,p_ref_date,
855: FND_GLOBAL.login_id);
856:
857: ELSIF p_row_agg_no<=10 AND p_max_col_no<=50 THEN
858: IF sh.COUNT<10 THEN

Line 855: FND_GLOBAL.login_id);

851: sh(1),sh(2),sh(3),sh(4),
852: sh(5),sm(1),sm(2),sm(3),sm(4),sm(5),sm(6),sm(7),sm(8),sm(9),sm(10),sm(11),
853: sm(12),sm(13),sm(14),sm(15),sm(16),sm(17),sm(18),sm(19),sm(20),
854: FND_GLOBAL.user_id,p_ref_date,FND_GLOBAL.user_id,p_ref_date,
855: FND_GLOBAL.login_id);
856:
857: ELSIF p_row_agg_no<=10 AND p_max_col_no<=50 THEN
858: IF sh.COUNT<10 THEN
859: sh.EXTEND(10-p_row_agg_no);

Line 878: FND_GLOBAL.user_id,p_ref_date,FND_GLOBAL.user_id,p_ref_date,

874: sm(8),sm(9),sm(10),sm(11),sm(12),sm(13),sm(14),sm(15),sm(16),sm(17),sm(18),
875: sm(19),sm(20),sm(21),sm(22),sm(23),sm(24),sm(25),sm(26),sm(27),sm(28),sm(29),
876: sm(30),sm(31),sm(32),sm(33),sm(34),sm(35),sm(36),sm(37),sm(38),sm(39),sm(40),
877: sm(41),sm(42),sm(43),sm(44),sm(45),sm(46),sm(47),sm(48),sm(49),sm(50),
878: FND_GLOBAL.user_id,p_ref_date,FND_GLOBAL.user_id,p_ref_date,
879: FND_GLOBAL.login_id);
880:
881: ELSE --p_row_agg_no<=16 AND p_max_col_no<=100
882: IF sh.COUNT<16 THEN

Line 879: FND_GLOBAL.login_id);

875: sm(19),sm(20),sm(21),sm(22),sm(23),sm(24),sm(25),sm(26),sm(27),sm(28),sm(29),
876: sm(30),sm(31),sm(32),sm(33),sm(34),sm(35),sm(36),sm(37),sm(38),sm(39),sm(40),
877: sm(41),sm(42),sm(43),sm(44),sm(45),sm(46),sm(47),sm(48),sm(49),sm(50),
878: FND_GLOBAL.user_id,p_ref_date,FND_GLOBAL.user_id,p_ref_date,
879: FND_GLOBAL.login_id);
880:
881: ELSE --p_row_agg_no<=16 AND p_max_col_no<=100
882: IF sh.COUNT<16 THEN
883: sh.EXTEND(16-p_row_agg_no);

Line 909: FND_GLOBAL.user_id,p_ref_date,FND_GLOBAL.user_id,p_ref_date,

905: sm(57),sm(58),sm(59),sm(60),sm(61),sm(62),sm(63),sm(64),sm(65),sm(66),sm(67),
906: sm(68),sm(69),sm(70),sm(71),sm(72),sm(73),sm(74),sm(75),sm(76),sm(77),sm(78),
907: sm(79),sm(80),sm(81),sm(82),sm(83),sm(84),sm(85),sm(86),sm(87),sm(88),sm(89),
908: sm(90),sm(91),sm(92),sm(93),sm(94),sm(95),sm(96),sm(97),sm(98),sm(99),sm(100),
909: FND_GLOBAL.user_id,p_ref_date,FND_GLOBAL.user_id,p_ref_date,
910: FND_GLOBAL.login_id);
911: END IF;
912:
913: IF (g_event_level>=g_debug_level) THEN --bug 3236479

Line 910: FND_GLOBAL.login_id);

906: sm(68),sm(69),sm(70),sm(71),sm(72),sm(73),sm(74),sm(75),sm(76),sm(77),sm(78),
907: sm(79),sm(80),sm(81),sm(82),sm(83),sm(84),sm(85),sm(86),sm(87),sm(88),sm(89),
908: sm(90),sm(91),sm(92),sm(93),sm(94),sm(95),sm(96),sm(97),sm(98),sm(99),sm(100),
909: FND_GLOBAL.user_id,p_ref_date,FND_GLOBAL.user_id,p_ref_date,
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',

Line 1652: SET currency_used='R', last_updated_by=FND_GLOBAL.user_id,

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
1656: UPDATE qrm_analysis_settings

Line 1653: last_update_date=p_ref_date, last_update_login=FND_GLOBAL.login_id

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
1656: UPDATE qrm_analysis_settings
1657: SET currency_used=currency_source, last_updated_by=FND_GLOBAL.user_id,

Line 1657: SET currency_used=currency_source, 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;
1661:

Line 1658: 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;
1661:
1662: IF (g_event_level>=g_debug_level) THEN --bug 3236479

Line 1849: FND_GLOBAL.user_id,p_ref_date,FND_GLOBAL.user_id,p_ref_date,

1845: v_col_seq_no_key(i),v_col_type(i),v_col_hidden(i),
1846: v_col_name_map(i),
1847: v_a1(i),v_percent_col_name_map(i),v_start_date(i),v_end_date(i),
1848: v_tb_label_arr(i),
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,

Line 1850: FND_GLOBAL.login_id);

1846: v_col_name_map(i),
1847: v_a1(i),v_percent_col_name_map(i),v_start_date(i),v_end_date(i),
1848: v_tb_label_arr(i),
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,

Line 1860: FND_GLOBAL.user_id,p_ref_date,FND_GLOBAL.user_id,p_ref_date,

1856: last_update_login)
1857: VALUES(p_name,v_col_seq_no(i),v_col_seq_no_key(i),v_col_type(i),
1858: v_col_hidden(i),v_col_name_map(i),v_a1(i),
1859: v_percent_col_name_map(i),
1860: FND_GLOBAL.user_id,p_ref_date,FND_GLOBAL.user_id,p_ref_date,
1861: FND_GLOBAL.login_id);
1862: END IF;
1863: COMMIT;
1864:

Line 1861: FND_GLOBAL.login_id);

1857: VALUES(p_name,v_col_seq_no(i),v_col_seq_no_key(i),v_col_type(i),
1858: v_col_hidden(i),v_col_name_map(i),v_a1(i),
1859: v_percent_col_name_map(i),
1860: FND_GLOBAL.user_id,p_ref_date,FND_GLOBAL.user_id,p_ref_date,
1861: FND_GLOBAL.login_id);
1862: END IF;
1863: COMMIT;
1864:
1865: IF (g_event_level>=g_debug_level) THEN --bug 3236479

Line 1877: last_updated_by=FND_GLOBAL.user_id,

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,
1879: last_update_login=FND_GLOBAL.login_id
1880: WHERE type=1;
1881: ELSIF v_ccy_case_flag=1 THEN

Line 1879: last_update_login=FND_GLOBAL.login_id

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,
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,

Line 1885: last_updated_by=FND_GLOBAL.user_id, last_update_date=p_ref_date,

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
1887: WHERE type=1;
1888: ELSE
1889: UPDATE qrm_saved_analyses_col

Line 1886: last_update_login=FND_GLOBAL.login_id

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
1887: WHERE type=1;
1888: ELSE
1889: UPDATE qrm_saved_analyses_col
1890: SET tot_currency=NULL,

Line 1892: last_updated_by=FND_GLOBAL.user_id, last_update_date=p_ref_date,

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
1894: WHERE type=1;
1895: END IF;
1896: END IF;

Line 1893: last_update_login=FND_GLOBAL.login_id

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
1894: WHERE type=1;
1895: END IF;
1896: END IF;
1897: ----End Bug 2566711

Line 3113: SET hidden='Y', last_updated_by=FND_GLOBAL.user_id, last_update_date=p_ref_date, last_update_login=FND_GLOBAL.login_id

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
3117: XTR_RISK_DEBUG_PKG.dlog('DML','Updated QRM_SET_ANALYSES_ROW.HIDDEN=Y',

Line 3123: SET hidden='N', last_updated_by=FND_GLOBAL.user_id, last_update_date=p_ref_date, last_update_login=FND_GLOBAL.login_id

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
3127: AND total_ind<>'N'

Line 3139: SET hidden='Y', last_updated_by=FND_GLOBAL.user_id, last_update_date=p_ref_date, last_update_login=FND_GLOBAL.login_id

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
3143: XTR_RISK_DEBUG_PKG.dlog('DML','Updated QRM_SET_ANALYSES_COL.HIDDEN=Y',

Line 3149: SET hidden='N', last_updated_by=FND_GLOBAL.user_id, last_update_date=p_ref_date, last_update_login=FND_GLOBAL.login_id

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
3153: AND total_ind<>'N'

Line 3255: last_updated_by=FND_GLOBAL.user_id,

3251: p94=p_meas(94),p95=p_meas(95),
3252: p96=p_meas(96),
3253: p97=p_meas(97),p98=p_meas(98),
3254: p99=p_meas(99),p100=p_meas(100),
3255: last_updated_by=FND_GLOBAL.user_id,
3256: last_update_date=p_ref_date,
3257: last_update_login=FND_GLOBAL.login_id
3258: WHERE analysis_name=p_name
3259: AND seq_no=p_row;

Line 3257: last_update_login=FND_GLOBAL.login_id

3253: p97=p_meas(97),p98=p_meas(98),
3254: p99=p_meas(99),p100=p_meas(100),
3255: last_updated_by=FND_GLOBAL.user_id,
3256: last_update_date=p_ref_date,
3257: last_update_login=FND_GLOBAL.login_id
3258: WHERE analysis_name=p_name
3259: AND seq_no=p_row;
3260:
3261: IF (g_proc_level>=g_debug_level) THEN

Line 3642: last_updated_by=FND_GLOBAL.user_id,

3638: p94=100*p94/v_tot(94),p95=100*p95/v_tot(95),
3639: p96=100*p96/v_tot(96),
3640: p97=100*p97/v_tot(97),p98=100*p98/v_tot(98),
3641: p99=100*p99/v_tot(99),p100=100*p100/v_tot(100),
3642: last_updated_by=FND_GLOBAL.user_id,
3643: last_update_date=p_ref_date,
3644: last_update_login=FND_GLOBAL.login_id
3645: WHERE analysis_name=p_name AND seq_no>=v_previous_count
3646: AND seq_no<=v_row

Line 3644: last_update_login=FND_GLOBAL.login_id

3640: p97=100*p97/v_tot(97),p98=100*p98/v_tot(98),
3641: p99=100*p99/v_tot(99),p100=100*p100/v_tot(100),
3642: last_updated_by=FND_GLOBAL.user_id,
3643: last_update_date=p_ref_date,
3644: last_update_login=FND_GLOBAL.login_id
3645: WHERE analysis_name=p_name AND seq_no>=v_previous_count
3646: AND seq_no<=v_row
3647: AND (type=-1 OR type>=v_level);
3648:

Line 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

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

Line 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

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
3669: XTR_RISK_DEBUG_PKG.dlog('DML','Updated QRM_SET_ANALYSES_COL.COL_PERCENT_LEVEL to null then '||v_level,

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

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

Line 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

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
3737: XTR_RISK_DEBUG_PKG.dlog('DML','Updated QRM_SET_ANALYSES_COL.COL_PERCENT_LEVEL to null then '||v_level,

Line 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

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:
3800: IF (g_event_level>=g_debug_level) THEN --bug 3236479

Line 4113: last_updated_by=FND_GLOBAL.user_id,

4109: curr91=v_curr(91),curr92=v_curr(92),curr93=v_curr(93),
4110: curr94=v_curr(94),curr95=v_curr(95),curr96=v_curr(96),
4111: curr97=v_curr(97),curr98=v_curr(98),
4112: curr99=v_curr(99),curr100=v_curr(100),
4113: last_updated_by=FND_GLOBAL.user_id,
4114: last_update_date=p_ref_date,
4115: last_update_login=FND_GLOBAL.login_id
4116: WHERE analysis_name=p_name;
4117:

Line 4115: last_update_login=FND_GLOBAL.login_id

4111: curr97=v_curr(97),curr98=v_curr(98),
4112: curr99=v_curr(99),curr100=v_curr(100),
4113: last_updated_by=FND_GLOBAL.user_id,
4114: last_update_date=p_ref_date,
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',

Line 4161: last_updated_by=FND_GLOBAL.user_id,

4157: curr91=curr1,curr92=curr1,curr93=curr1,
4158: curr94=curr1,curr95=curr1,curr96=curr1,
4159: curr97=curr1,curr98=curr1,
4160: curr99=curr1,curr100=curr1,
4161: last_updated_by=FND_GLOBAL.user_id,
4162: last_update_date=p_ref_date,
4163: last_update_login=FND_GLOBAL.login_id
4164: WHERE analysis_name=p_name;
4165:

Line 4163: last_update_login=FND_GLOBAL.login_id

4159: curr97=curr1,curr98=curr1,
4160: curr99=curr1,curr100=curr1,
4161: last_updated_by=FND_GLOBAL.user_id,
4162: last_update_date=p_ref_date,
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,