APPS.QRM_PA_CALCULATION_P dependencies on QRM_DEALS_ANALYSES

Line 1247: FROM qrm_deals_analyses

1243:
1244: -- BUG 2945198 - sql bind
1245: BEGIN
1246: DELETE
1247: FROM qrm_deals_analyses
1248: WHERE analysis_name=p_analysis_name;
1249:
1250: IF (g_event_level>=g_debug_level) THEN --bug 3236479
1251: XTR_RISK_DEBUG_PKG.dlog('DML','DELETED QRM_DEALS_ANALYSES',

Line 1251: XTR_RISK_DEBUG_PKG.dlog('DML','DELETED QRM_DEALS_ANALYSES',

1247: FROM qrm_deals_analyses
1248: WHERE analysis_name=p_analysis_name;
1249:
1250: IF (g_event_level>=g_debug_level) THEN --bug 3236479
1251: XTR_RISK_DEBUG_PKG.dlog('DML','DELETED QRM_DEALS_ANALYSES',
1252: 'QRM_CALCULATION_P.RUN_ANALYSIS',g_event_level);
1253: END IF;
1254:
1255: v_cursor := dbms_sql.open_cursor;

Line 6360: -- UPDATE QRM_DEALS_ANALYSES

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
6362: IF (g_proc_level>=g_debug_level) THEN
6363: XTR_RISK_DEBUG_PKG.dlog('run_analysis: ' || 'about to delete');
6364: END IF;

Line 6367: FROM qrm_deals_analyses

6363: XTR_RISK_DEBUG_PKG.dlog('run_analysis: ' || 'about to delete');
6364: END IF;
6365: /* BUG 2945198 - SQL BINDING
6366: DELETE
6367: FROM qrm_deals_analyses
6368: WHERE analysis_name=p_analysis_name;
6369: */
6370: -- add links for inserted deals
6371:

Line 6378: XTR_RISK_DEBUG_PKG.dlog('INSERT QRM_DEALS_ANALYSES',v_log,

6374: v_log := p_seq_nos(j)||','|| p_analysis_name||','|| p_company_code_insert(j)||','||
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);

Line 6383: 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,
6384: 'QRM_PA_CALCULATION_P.RUN_ANALYSIS',g_state_level);
6385: end loop;
6386: end if;
6387:

Line 6389: INSERT INTO qrm_deals_analyses (deal_calc_id, analysis_name,

6385: end loop;
6386: end if;
6387:
6388: FORALL j IN 1..p_insert_counter
6389: INSERT INTO qrm_deals_analyses (deal_calc_id, analysis_name,
6390: company_code, created_by, creation_date, last_updated_by,
6391: last_update_date, last_update_login, request_id,
6392: program_application_id, program_id, program_update_date)
6393: VALUES (p_seq_nos(j), p_analysis_name, p_company_code_insert(j),

Line 6399: INSERT INTO qrm_deals_analyses (deal_calc_id, analysis_name,

6395: p_ref_datetime, FND_GLOBAL.login_id, FND_GLOBAL.conc_request_id,
6396: FND_GLOBAL.prog_appl_id, FND_GLOBAL.conc_program_id,p_ref_datetime);
6397: -- add links for updated deals
6398: FORALL j IN 1..p_update_counter
6399: INSERT INTO qrm_deals_analyses (deal_calc_id, analysis_name,
6400: company_code, created_by, creation_date, last_updated_by,
6401: last_update_date, last_update_login, request_id,
6402: program_application_id, program_id, program_update_date)
6403: VALUES (p_deal_calc_id_update(j), p_analysis_name,

Line 7119: FROM qrm_deals_analyses

7115: /* -- don't want to delete rows of this table if analysis still exists
7116: -- because need all instances of company code
7117: FORALL i IN 1..p_deal_calc_ids.COUNT
7118: DELETE
7119: FROM qrm_deals_analyses
7120: WHERE deal_calc_id=p_deal_calc_ids(i);
7121: */
7122:
7123: FORALL i IN 1..p_deal_nos.COUNT