APPS.QRM_PA_CALCULATION_P dependencies on QRM_ANALYSIS_SETTINGS

Line 40: FROM qrm_analysis_settings

36: IS
37:
38: CURSOR check_analysis (p_name VARCHAR2) IS
39: SELECT analysis_name, status, process_id
40: FROM qrm_analysis_settings
41: WHERE analysis_name=p_name and history_flag='C';
42:
43: p_request_id NUMBER;
44: p_source VARCHAR2(2) := 'AM';

Line 128: UPDATE qrm_analysis_settings

124: IF (g_proc_level>=g_debug_level) THEN
125: xtr_risk_debug_pkg.dlog('run_analysis_am: ' || 'request submitted: '||p_request_id);
126: END IF;
127: -- this updates the history_flag='C' row only!
128: UPDATE qrm_analysis_settings
129: SET status='3',
130: process_id=p_request_id,
131: last_run_date=p_ref_datetime,
132: dirty = 'N'

Line 160: FROM qrm_analysis_settings

156: p_ref_date DATE := TRUNC(p_ref_datetime);
157:
158: CURSOR get_settings(p_a_name VARCHAR2) IS
159: SELECT *
160: FROM qrm_analysis_settings
161: WHERE analysis_name = p_a_name and history_flag='C';
162:
163: CURSOR get_attributes (p_a_name VARCHAR2) IS
164: SELECT *

Line 1067: FROM qrm_analysis_settings

1063: -- if not called by Analysis Manager
1064:
1065: -- delete analysis row with history_flag='S';
1066: DELETE
1067: FROM qrm_analysis_settings
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',

Line 1103: XTR_RISK_DEBUG_PKG.dlog('INSERT QRM_ANALYSIS_SETTINGS',v_log,

1099: p_settings.gl_calendar_id||','||'S'||','||
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';

Line 1109: INTO qrm_analysis_settings(analysis_name, description, analysis_type,

1105: END IF;
1106:
1107: -- make copy of row and set history flag to 'S';
1108: INSERT
1109: INTO qrm_analysis_settings(analysis_name, description, analysis_type,
1110: style, filter_name, md_set_code, threshold_num, threshold_type,
1111: tb_label, tb_name, date_type, start_date, end_date,
1112: start_date_ref, end_date_ref, start_date_offset, end_date_offset,
1113: start_offset_type, end_offset_type, show_totals, currency_source,

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

1132: p_settings.last_updated_by, p_settings.last_update_date,
1133: p_settings.last_update_login);
1134:
1135: IF (g_event_level>=g_debug_level) THEN --bug 3236479
1136: XTR_RISK_DEBUG_PKG.dlog('DML','Inserted into QRM_ANALYSIS_SETTINGS attributes with history_flag=S',
1137: 'QRM_CALCULATION_P.RUN_ANALYSIS',g_event_level);
1138: END IF;
1139:
1140: -- store attributes rows for bulk copy

Line 1195: UPDATE qrm_analysis_settings

1191: END IF;
1192:
1193: -- update status column to "In Progress"
1194: -- updates both history_flag='C' and 'S' rows in analysis settings
1195: UPDATE qrm_analysis_settings
1196: SET status = '3',
1197: process_id = FND_GLOBAL.conc_request_id,
1198: last_run_date = p_ref_datetime,
1199: dirty = 'N'

Line 6772: UPDATE qrm_analysis_settings

6768: END;
6769:
6770:
6771: -- UPDATE LAST RUN DATE AND CALC STATUS IN SETTINGS TABLE
6772: UPDATE qrm_analysis_settings
6773: SET last_run_date = p_ref_datetime, status = retcode
6774: WHERE analysis_name = p_analysis_name;
6775:
6776: IF (g_event_level>=g_debug_level) THEN --bug 3236479