DBA Data[Home] [Help]

APPS.QRM_PA_CALCULATION_P dependencies on QRM_DEAL_CALC_ERRORS

Line 6784: FROM qrm_deal_calc_errors

6780:
6781: -- UPDATE ERRORS TABLE
6782: -- first remove all errors associated with this analysis
6783: DELETE
6784: FROM qrm_deal_calc_errors
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',

Line 6788: XTR_RISK_DEBUG_PKG.dlog('DML','Deleted qrm_deal_calc_errors',

6784: FROM qrm_deal_calc_errors
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

Line 6794: INSERT INTO qrm_deal_calc_errors (analysis_name, deal_no,

6790: END IF;
6791:
6792: -- now insert new errors into table
6793: FORALL j IN 1..p_except_counter
6794: INSERT INTO qrm_deal_calc_errors (analysis_name, deal_no,
6795: transaction_no, market_data_set, error_type, error_code,
6796: token_name, token_value, created_by, creation_date,
6797: last_updated_by, last_update_date, last_update_login,
6798: request_id, program_application_id, program_id, program_update_date)

Line 7125: FROM qrm_deal_calc_errors

7121: */
7122:
7123: FORALL i IN 1..p_deal_nos.COUNT
7124: DELETE
7125: FROM qrm_deal_calc_errors
7126: WHERE deal_no=p_deal_nos(i) AND transaction_no=p_transaction_nos(i);
7127:
7128: COMMIT;
7129: IF (g_proc_level>=g_debug_level) THEN