APPS.QRM_PA_CALCULATION_P dependencies on QRM_ANALYSIS_ATTS

Line 165: FROM qrm_analysis_atts

161: WHERE analysis_name = p_a_name and history_flag='C';
162:
163: CURSOR get_attributes (p_a_name VARCHAR2) IS
164: SELECT *
165: FROM qrm_analysis_atts
166: WHERE analysis_name= p_a_name and history_flag='C';
167:
168: CURSOR get_filter_where_clause(p_filter_name VARCHAR2) IS
169: SELECT where_clause

Line 1077: FROM qrm_analysis_atts

1073: END IF;
1074:
1075: -- delete attributes rows with history_flag='S'
1076: DELETE
1077: FROM qrm_analysis_atts
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',

Line 1172: XTR_RISK_DEBUG_PKG.dlog('INSERT QRM_ANALYSIS_ATTS',v_log,

1168: for i in 1..p_att_counter loop
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:

Line 1180: INTO qrm_analysis_atts (attribute_name, analysis_name, history_flag,

1176:
1177: -- bulk copy of attributes with history_flag='S'
1178: FORALL i IN 1..p_att_counter
1179: INSERT
1180: INTO qrm_analysis_atts (attribute_name, analysis_name, history_flag,
1181: type, att_order, total_average, total_ind, percentage, created_by,
1182: creation_date, last_updated_by, last_update_date, last_update_login)
1183: VALUES (p_att_name(i), p_analysis_name, 'S', p_att_type(i),
1184: p_att_order(i), p_att_average(i), p_att_ind(i), p_att_percentage(i),

Line 1189: XTR_RISK_DEBUG_PKG.dlog('DML','Inserted into QRM_ANALYSIS_ATTS attributes with history_flag=S',

1185: p_att_created_by(i), p_att_creation_date(i), p_att_updated_by(i),
1186: p_att_update_date(i), p_att_update_login(i));
1187:
1188: IF (g_event_level>=g_debug_level) THEN --bug 3236479
1189: XTR_RISK_DEBUG_PKG.dlog('DML','Inserted into QRM_ANALYSIS_ATTS attributes with history_flag=S',
1190: 'QRM_CALCULATION_P.RUN_ANALYSIS',g_event_level);
1191: END IF;
1192:
1193: -- update status column to "In Progress"

Line 7157: SELECT l.mm_fx FROM qrm_ana_atts_lookups l, qrm_analysis_atts a

7153: v_where VARCHAR2(240);
7154: v_mm_fx VARCHAR2(1);
7155: v_eq VARCHAR2(1);
7156: CURSOR get_mm_fx IS
7157: SELECT l.mm_fx FROM qrm_ana_atts_lookups l, qrm_analysis_atts a
7158: WHERE a.analysis_name=p_analysis_name
7159: AND a.history_flag='S'
7160: AND a.type='M'
7161: AND l.attribute_name=a.attribute_name;

Line 7164: SELECT l.applies_to_eqm FROM qrm_ana_atts_lookups l, qrm_analysis_atts a

7160: AND a.type='M'
7161: AND l.attribute_name=a.attribute_name;
7162:
7163: CURSOR get_eq IS
7164: SELECT l.applies_to_eqm FROM qrm_ana_atts_lookups l, qrm_analysis_atts a
7165: WHERE a.analysis_name = p_analysis_name
7166: AND a.history_flag= 'S'
7167: AND a.type='M'
7168: AND l.attribute_name = a.attribute_name;