APPS.QRM_PA_CALCULATION_P dependencies on QRM_TB_CALCULATIONS

Line 324: -- determines whether to recalculate values for qrm_tb_calculations

320:
321: -- boolean returned by aggregation function
322: p_agg_ok VARCHAR2(1) := 'T';
323:
324: -- determines whether to recalculate values for qrm_tb_calculations
325: p_recalc_val_tb BOOLEAN := TRUE;
326:
327: p_side VARCHAR2(5);
328: p_int_rate_a NUMBER;

Line 5123: -- for QRM_TB_CALCULATIONS: calculate everytime for MM deals

5119: ----------- End: placing attributes into insert/update arrays -----
5120:
5121:
5122: ----- >>> ALWAYS RECALCULATE <<< -------
5123: -- for QRM_TB_CALCULATIONS: calculate everytime for MM deals
5124: -- for FX/FXO deals, simply save to table
5125: IF (g_proc_level>=g_debug_level) THEN
5126: XTR_RISK_DEBUG_PKG.dlog('run_analysis: ' || 'deal type is: '||p_deal_types(i));
5127: XTR_RISK_DEBUG_PKG.dlog('run_analysis: ' || 'deal no is : '||p_deal_nos(i));

Line 6414: -- UPDATE QRM_TB_CALCULATIONS

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
6416: FORALL j IN 1..p_tb_counter
6417: DELETE
6418: FROM qrm_tb_calculations

Line 6418: FROM qrm_tb_calculations

6414: -- UPDATE QRM_TB_CALCULATIONS
6415: -- first delete old data for deal no/trans no
6416: FORALL j IN 1..p_tb_counter
6417: DELETE
6418: FROM qrm_tb_calculations
6419: WHERE deal_no=p_tb_deal_no(j)
6420: AND transaction_no=p_tb_transaction_no(j)
6421: AND market_data_set=p_tb_market_data_set(j);
6422: -- then insert new ones

Line 6425: XTR_RISK_DEBUG_PKG.dlog('DML','DELETED QRM_TB_CALCULATIONS',

6421: AND market_data_set=p_tb_market_data_set(j);
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

Line 6440: XTR_RISK_DEBUG_PKG.dlog('INSERT QRM_TB_CALCULATIONS',v_log,

6436: p_tb_interest_basis(j)||','|| p_tb_outst_amount(j)||','||
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:

Line 6446: INSERT INTO qrm_tb_calculations (deal_no, transaction_no,

6442: end loop;
6443: end if;
6444:
6445: FORALL j IN 1..p_tb_counter
6446: INSERT INTO qrm_tb_calculations (deal_no, transaction_no,
6447: market_data_set, pos_start_date, pos_end_date, start_date,
6448: end_date, interest_basis, outstanding_amount,
6449: outstanding_amount_usd, outstanding_amount_sob, coupon_rate,
6450: next_coupon_date,amt_qty_out, amt_qty_out_usd, amt_qty_out_sob,

Line 6468: XTR_RISK_DEBUG_PKG.dlog('DML','INSERTED QRM_TB_CALCULATIONS',

6464: p_ref_datetime, FND_GLOBAL.login_id, FND_GLOBAL.conc_request_id,
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

Line 7112: FROM qrm_tb_calculations

7108: WHERE deal_calc_id=p_deal_calc_ids(i);
7109:
7110: FORALL i IN 1..p_deal_nos.COUNT
7111: DELETE
7112: FROM qrm_tb_calculations
7113: WHERE deal_no=p_deal_nos(i) AND transaction_no=p_transaction_nos(i);
7114:
7115: /* -- don't want to delete rows of this table if analysis still exists
7116: -- because need all instances of company code