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_CALCULATION_P dependencies on QRM_PA_CALCULATION_P

Line 1: PACKAGE BODY QRM_PA_CALCULATION_P AS

1: PACKAGE BODY QRM_PA_CALCULATION_P AS
2: /* $Header: qrmpacab.pls 120.39 2006/02/07 07:39:02 csutaria ship $ */
3:
4:
5: PROCEDURE run_analysis_cp (errbuf OUT NOCOPY VARCHAR2,

Line 1072: 'QRM_PA_CALCULATION_P.RUN_ANALYSIS',g_event_level);

1068: WHERE analysis_name = p_analysis_name and history_flag='S';
1069:
1070: IF (g_event_level>=g_debug_level) THEN --bug 3236479
1071: XTR_RISK_DEBUG_PKG.dlog('DML','Deleted analysis row with history_flag=S',
1072: 'QRM_PA_CALCULATION_P.RUN_ANALYSIS',g_event_level);
1073: END IF;
1074:
1075: -- delete attributes rows with history_flag='S'
1076: DELETE

Line 1082: 'QRM_PA_CALCULATION_P.RUN_ANALYSIS',g_event_level);

1078: WHERE analysis_name = p_analysis_name and history_flag='S';
1079:
1080: IF (g_event_level>=g_debug_level) THEN --bug 3236479
1081: XTR_RISK_DEBUG_PKG.dlog('DML','Deleted attributes rows with history_flag=S',
1082: 'QRM_PA_CALCULATION_P.RUN_ANALYSIS',g_event_level);
1083: END IF;
1084:
1085: IF (g_state_level>=g_debug_level) THEN --bug 3236479
1086: v_log := p_settings.analysis_name||','||p_settings.description||','||

Line 1104: 'QRM_PA_CALCULATION_P.RUN_ANALYSIS',g_state_level);

1100: p_settings.created_by||','||p_settings.creation_date||','||
1101: p_settings.last_updated_by||','||p_settings.last_update_date||','||
1102: p_settings.last_update_login;
1103: XTR_RISK_DEBUG_PKG.dlog('INSERT QRM_ANALYSIS_SETTINGS',v_log,
1104: 'QRM_PA_CALCULATION_P.RUN_ANALYSIS',g_state_level);
1105: END IF;
1106:
1107: -- make copy of row and set history flag to 'S';
1108: INSERT

Line 1173: 'QRM_PA_CALCULATION_P.RUN_ANALYSIS',g_state_level);

1169: v_log := p_att_name(i)||','||p_analysis_name||','||'S'||','||
1170: p_att_type(i)||','||p_att_order(i)||','||p_att_average(i)||','||
1171: p_att_ind(i)||','|| p_att_percentage(i);
1172: XTR_RISK_DEBUG_PKG.dlog('INSERT QRM_ANALYSIS_ATTS',v_log,
1173: 'QRM_PA_CALCULATION_P.RUN_ANALYSIS',g_state_level);
1174: end loop;
1175: END IF;
1176:
1177: -- bulk copy of attributes with history_flag='S'

Line 6082: 'QRM_PA_CALCULATION_P.RUN_ANALYSIS',g_state_level);

6078: p_domestic_amount_sob_insert(j)||';'|| p_buy_amount_usd_insert(j)||';'||
6079: p_buy_amount_sob_insert(j)||';'|| p_sell_amount_usd_insert(j)||';'||
6080: p_sell_amount_sob_insert(j)||';'|| p_days_insert(j);
6081: XTR_RISK_DEBUG_PKG.dlog('INSERT QRM_DEAL_CALCULATIONS Line 1',v_log,
6082: 'QRM_PA_CALCULATION_P.RUN_ANALYSIS',g_state_level);
6083: v_log := p_fx_reval_rate_insert(j)||';'||p_mm_reval_rate_insert(j)||';'||
6084: p_fx_trans_rate_insert(j)||';'|| p_mm_trans_rate_insert(j)||';'||
6085: p_fair_value_insert(j)||';'|| p_fair_value_usd_insert(j)||';'||
6086: p_fair_value_sob_insert(j)||';'|| p_gap_amount_insert(j)||';'||

Line 6093: 'QRM_PA_CALCULATION_P.RUN_ANALYSIS',g_state_level);

6089: p_maturity_amount_sob_insert(j)||';'|| p_premium_amount_usd_insert(j)||';'||
6090: p_premium_amount_sob_insert(j)||';'|| p_accrued_interest_insert(j)||';'||
6091: p_accrued_interest_usd_insert(j)||';'|| p_accrued_interest_sob_insert(j);
6092: XTR_RISK_DEBUG_PKG.dlog('INSERT QRM_DEAL_CALCULATIONS Line 2',v_log,
6093: 'QRM_PA_CALCULATION_P.RUN_ANALYSIS',g_state_level);
6094: v_log := p_duration_insert(j)||';'|| p_mod_duration_insert(j)||';'||
6095: p_convexity_insert(j)||';'|| p_delta_insert(j)||';'|| p_gamma_insert(j)||';'||
6096: p_theta_insert(j)||';'|| p_rho_insert(j)||';'|| p_rho_base_insert(j)||';'||
6097: p_rho_contra_insert(j)||';'|| p_rho_for_insert(j)||';'|| p_rho_dom_insert(j)||';'||

Line 6109: 'QRM_PA_CALCULATION_P.RUN_ANALYSIS',g_state_level);

6105: p_pos_rho_sob_insert(j)||';'|| p_pos_rho_base_insert(j)||';'||
6106: p_pos_rho_base_usd_insert(j)||';'|| p_pos_rho_base_sob_insert(j)||';'||
6107: p_pos_rho_contra_insert(j)||';'|| p_pos_rho_contra_usd_insert(j);
6108: XTR_RISK_DEBUG_PKG.dlog('INSERT QRM_DEAL_CALCULATIONS Line 3',v_log,
6109: 'QRM_PA_CALCULATION_P.RUN_ANALYSIS',g_state_level);
6110: v_log := p_pos_rho_contra_sob_insert(j)||';'|| p_pos_rho_for_insert(j)||';'||
6111: p_pos_rho_for_usd_insert(j)||';'|| p_pos_rho_for_sob_insert(j)||';'||
6112: p_pos_rho_dom_insert(j)||';'|| p_pos_rho_dom_usd_insert(j)||';'||
6113: p_pos_rho_dom_sob_insert(j)||';'|| p_pos_vega_insert(j)||';'||

Line 6121: 'QRM_PA_CALCULATION_P.RUN_ANALYSIS',g_state_level);

6117: p_reval_price_usd_insert(j)||';'|| p_reval_price_sob_insert(j)||';'||
6118: p_trans_price_insert(j)||';'|| p_trans_price_usd_insert(j)||';'||
6119: p_trans_price_sob_insert(j)||';'|| p_ref_datetime;
6120: XTR_RISK_DEBUG_PKG.dlog('INSERT QRM_DEAL_CALCULATIONS Line 4',v_log,
6121: 'QRM_PA_CALCULATION_P.RUN_ANALYSIS',g_state_level);
6122: end loop;
6123: END IF;
6124:
6125: FORALL j IN 1..p_insert_counter

Line 6205: 'QRM_PA_CALCULATION_P.RUN_ANALYSIS',g_event_level);

6201: FND_GLOBAL.conc_program_id, p_ref_datetime);
6202:
6203: IF (g_event_level>=g_debug_level) THEN --bug 3236479
6204: XTR_RISK_DEBUG_PKG.dlog('DML','INSERTED QRM_DEAL_CALCULATIONS',
6205: 'QRM_PA_CALCULATION_P.RUN_ANALYSIS',g_event_level);
6206: END IF;
6207:
6208: --- UPDATE QRM_DEAL_CALCULATIONS
6209: IF (g_state_level>=g_debug_level) THEN --bug 3236479

Line 6222: 'QRM_PA_CALCULATION_P.RUN_ANALYSIS',g_state_level);

6218: p_domestic_amount_sob_update(j)||';'|| p_buy_amount_usd_update(j)||';'||
6219: p_buy_amount_sob_update(j)||';'|| p_sell_amount_usd_update(j)||';'||
6220: p_sell_amount_sob_update(j)||';'|| p_days_update(j);
6221: XTR_RISK_DEBUG_PKG.dlog('update QRM_DEAL_CALCULATIONS Line 1',v_log,
6222: 'QRM_PA_CALCULATION_P.RUN_ANALYSIS',g_state_level);
6223: v_log := p_fx_reval_rate_update(j)||';'||p_mm_reval_rate_update(j)||';'||
6224: p_fx_trans_rate_update(j)||';'|| p_mm_trans_rate_update(j)||';'||
6225: p_fair_value_update(j)||';'|| p_fair_value_usd_update(j)||';'||
6226: p_fair_value_sob_update(j)||';'|| p_gap_amount_update(j)||';'||

Line 6233: 'QRM_PA_CALCULATION_P.RUN_ANALYSIS',g_state_level);

6229: p_maturity_amount_sob_update(j)||';'|| p_premium_amount_usd_update(j)||';'||
6230: p_premium_amount_sob_update(j)||';'|| p_accrued_interest_update(j)||';'||
6231: p_accrued_interest_usd_update(j)||';'|| p_accrued_interest_sob_update(j);
6232: XTR_RISK_DEBUG_PKG.dlog('update QRM_DEAL_CALCULATIONS Line 2',v_log,
6233: 'QRM_PA_CALCULATION_P.RUN_ANALYSIS',g_state_level);
6234: v_log := p_duration_update(j)||';'|| p_mod_duration_update(j)||';'||
6235: p_convexity_update(j)||';'|| p_delta_update(j)||';'|| p_gamma_update(j)||';'||
6236: p_theta_update(j)||';'|| p_rho_update(j)||';'|| p_rho_base_update(j)||';'||
6237: p_rho_contra_update(j)||';'|| p_rho_for_update(j)||';'|| p_rho_dom_update(j)||';'||

Line 6249: 'QRM_PA_CALCULATION_P.RUN_ANALYSIS',g_state_level);

6245: p_pos_rho_sob_update(j)||';'|| p_pos_rho_base_update(j)||';'||
6246: p_pos_rho_base_usd_update(j)||';'|| p_pos_rho_base_sob_update(j)||';'||
6247: p_pos_rho_contra_update(j)||';'|| p_pos_rho_contra_usd_update(j);
6248: XTR_RISK_DEBUG_PKG.dlog('update QRM_DEAL_CALCULATIONS Line 3',v_log,
6249: 'QRM_PA_CALCULATION_P.RUN_ANALYSIS',g_state_level);
6250: v_log := p_pos_rho_contra_sob_update(j)||';'|| p_pos_rho_for_update(j)||';'||
6251: p_pos_rho_for_usd_update(j)||';'|| p_pos_rho_for_sob_update(j)||';'||
6252: p_pos_rho_dom_update(j)||';'|| p_pos_rho_dom_usd_update(j)||';'||
6253: p_pos_rho_dom_sob_update(j)||';'|| p_pos_vega_update(j)||';'||

Line 6261: 'QRM_PA_CALCULATION_P.RUN_ANALYSIS',g_state_level);

6257: p_reval_price_usd_update(j)||';'|| p_reval_price_sob_update(j)||';'||
6258: p_trans_price_update(j)||';'|| p_trans_price_usd_update(j)||';'||
6259: p_trans_price_sob_update(j)||';'|| p_ref_datetime;
6260: XTR_RISK_DEBUG_PKG.dlog('update QRM_DEAL_CALCULATIONS Line 4',v_log,
6261: 'QRM_PA_CALCULATION_P.RUN_ANALYSIS',g_state_level);
6262: end loop;
6263: END IF;
6264:
6265: FORALL j IN 1..p_update_counter

Line 6357: 'QRM_PA_CALCULATION_P.RUN_ANALYSIS',g_event_level);

6353: WHERE deal_calc_id = p_deal_calc_id_update(j);
6354:
6355: IF (g_event_level>=g_debug_level) THEN --bug 3236479
6356: XTR_RISK_DEBUG_PKG.dlog('DML','UPDATED QRM_DEAL_CALCULATIONS',
6357: 'QRM_PA_CALCULATION_P.RUN_ANALYSIS',g_event_level);
6358: END IF;
6359:
6360: -- UPDATE QRM_DEALS_ANALYSES
6361: -- first delete all old links

Line 6379: 'QRM_PA_CALCULATION_P.RUN_ANALYSIS',g_state_level);

6375: FND_GLOBAL.user_id||','|| p_ref_datetime||','|| FND_GLOBAL.user_id||','||
6376: p_ref_datetime||','|| FND_GLOBAL.login_id||','|| FND_GLOBAL.conc_request_id||','||
6377: FND_GLOBAL.prog_appl_id||','|| FND_GLOBAL.conc_program_id||','||p_ref_datetime;
6378: XTR_RISK_DEBUG_PKG.dlog('INSERT QRM_DEALS_ANALYSES',v_log,
6379: 'QRM_PA_CALCULATION_P.RUN_ANALYSIS',g_state_level);
6380: end loop;
6381: for j in 1..p_update_counter loop
6382: v_log := p_deal_calc_id_update(j)||','||p_analysis_name||','||p_company_code_update(j);
6383: XTR_RISK_DEBUG_PKG.dlog('INSERT QRM_DEALS_ANALYSES',v_log,

Line 6384: 'QRM_PA_CALCULATION_P.RUN_ANALYSIS',g_state_level);

6380: end loop;
6381: for j in 1..p_update_counter loop
6382: v_log := p_deal_calc_id_update(j)||','||p_analysis_name||','||p_company_code_update(j);
6383: XTR_RISK_DEBUG_PKG.dlog('INSERT QRM_DEALS_ANALYSES',v_log,
6384: 'QRM_PA_CALCULATION_P.RUN_ANALYSIS',g_state_level);
6385: end loop;
6386: end if;
6387:
6388: FORALL j IN 1..p_insert_counter

Line 6411: 'QRM_PA_CALCULATION_P.RUN_ANALYSIS',g_event_level);

6407: FND_GLOBAL.conc_program_id, p_ref_datetime);
6408:
6409: IF (g_event_level>=g_debug_level) THEN --bug 3236479
6410: XTR_RISK_DEBUG_PKG.dlog('DML','INSERTED QRM_DEAL_ANALYSES',
6411: 'QRM_PA_CALCULATION_P.RUN_ANALYSIS',g_event_level);
6412: END IF;
6413:
6414: -- UPDATE QRM_TB_CALCULATIONS
6415: -- first delete old data for deal no/trans no

Line 6426: 'QRM_PA_CALCULATION_P.RUN_ANALYSIS',g_event_level);

6422: -- then insert new ones
6423:
6424: IF (g_event_level>=g_debug_level) THEN --bug 3236479
6425: XTR_RISK_DEBUG_PKG.dlog('DML','DELETED QRM_TB_CALCULATIONS',
6426: 'QRM_PA_CALCULATION_P.RUN_ANALYSIS',g_event_level);
6427: END IF;
6428:
6429: IF (g_state_level>=g_debug_level) THEN --bug 3236479
6430: XTR_RISK_DEBUG_PKG.dlog('run_analysis: ' || 'p_tb_counter: ' || p_tb_counter);

Line 6441: 'QRM_PA_CALCULATION_P.RUN_ANALYSIS',g_state_level);

6437: p_tb_outst_amount_usd(j)||','|| p_tb_outst_amount_sob(j)||','||
6438: p_tb_coupon_rate(j)||','|| p_tb_next_coupon_date(j)||','|| p_tb_amt_qty_out(j)||','||
6439: p_tb_amt_qty_out_usd(j)||','|| p_tb_amt_qty_out_sob(j);
6440: XTR_RISK_DEBUG_PKG.dlog('INSERT QRM_TB_CALCULATIONS',v_log,
6441: 'QRM_PA_CALCULATION_P.RUN_ANALYSIS',g_state_level);
6442: end loop;
6443: end if;
6444:
6445: FORALL j IN 1..p_tb_counter

Line 6469: 'QRM_PA_CALCULATION_P.RUN_ANALYSIS',g_event_level);

6465: FND_GLOBAL.prog_appl_id,FND_GLOBAL.conc_program_id,p_ref_datetime);
6466:
6467: IF (g_event_level>=g_debug_level) THEN --bug 3236479
6468: XTR_RISK_DEBUG_PKG.dlog('DML','INSERTED QRM_TB_CALCULATIONS',
6469: 'QRM_PA_CALCULATION_P.RUN_ANALYSIS',g_event_level);
6470: END IF;
6471:
6472: -- BUG 2945198 - SQL BINDING
6473: END IF; -- end of if retcode<>'2'

Line 6778: 'QRM_PA_CALCULATION_P.RUN_ANALYSIS',g_event_level);

6774: WHERE analysis_name = p_analysis_name;
6775:
6776: IF (g_event_level>=g_debug_level) THEN --bug 3236479
6777: XTR_RISK_DEBUG_PKG.dlog('DML','UPDATED LAST RUN DATE AND CALC STATUS IN SETTINGS TABLE',
6778: 'QRM_PA_CALCULATION_P.RUN_ANALYSIS',g_event_level);
6779: END IF;
6780:
6781: -- UPDATE ERRORS TABLE
6782: -- first remove all errors associated with this analysis

Line 6789: 'QRM_PA_CALCULATION_P.RUN_ANALYSIS',g_event_level);

6785: WHERE analysis_name=p_analysis_name;
6786:
6787: IF (g_event_level>=g_debug_level) THEN --bug 3236479
6788: XTR_RISK_DEBUG_PKG.dlog('DML','Deleted qrm_deal_calc_errors',
6789: 'QRM_PA_CALCULATION_P.RUN_ANALYSIS',g_event_level);
6790: END IF;
6791:
6792: -- now insert new errors into table
6793: FORALL j IN 1..p_except_counter

Line 6811: 'QRM_PA_CALCULATION_P.RUN_ANALYSIS',g_event_level);

6807: COMMIT;
6808:
6809: IF (g_event_level>=g_debug_level) THEN --bug 3236479
6810: XTR_RISK_DEBUG_PKG.dlog('DML','Inserted new errors into table',
6811: 'QRM_PA_CALCULATION_P.RUN_ANALYSIS',g_event_level);
6812: END IF;
6813:
6814: -- if no rows returned, reset retcode to '1'
6815: -- FOR concurrent manager

Line 7253: END QRM_PA_CALCULATION_P;

7249: RETURN NULL;
7250: END filter_measure;
7251:
7252:
7253: END QRM_PA_CALCULATION_P;