36: p_status varchar2(3);
37: p_industry varchar2(30);
38: p_table_owner varchar2(30);
39: BEGIN
40: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
41: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
42: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
43: row_limit := 1000;
44: -- accept input
37: p_industry varchar2(30);
38: p_table_owner varchar2(30);
39: BEGIN
40: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
41: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
42: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
43: row_limit := 1000;
44: -- accept input
45: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Organization Id',inputs);
41: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
42: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
43: row_limit := 1000;
44: -- accept input
45: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Organization Id',inputs);
46: l_job_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Job Id',inputs);
47: --l_cutoff_date := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('CutoffDate',inputs);
48:
49: if l_org_id is not null then
42: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
43: row_limit := 1000;
44: -- accept input
45: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Organization Id',inputs);
46: l_job_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Job Id',inputs);
47: --l_cutoff_date := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('CutoffDate',inputs);
48:
49: if l_org_id is not null then
50: we_dyn_where_clause := ' we.organization_id = '|| l_org_id || ' AND ';
43: row_limit := 1000;
44: -- accept input
45: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Organization Id',inputs);
46: l_job_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Job Id',inputs);
47: --l_cutoff_date := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('CutoffDate',inputs);
48:
49: if l_org_id is not null then
50: we_dyn_where_clause := ' we.organization_id = '|| l_org_id || ' AND ';
51: wdj_dyn_where_clause := ' wdj.organization_id = '|| l_org_id || ' AND ';
1191: fixInfo := 'OK';
1192: errStr :='No Error!';
1193:
1194: <
1195: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
1196: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
1197:
1198: END invalid_job_def_job;
1199:
1192: errStr :='No Error!';
1193:
1194: <
1195: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
1196: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
1197:
1198: END invalid_job_def_job;
1199:
1200: PROCEDURE failed_job_close_job(inputs IN JTF_DIAG_INPUTTBL,
1216: wg_dyn_where_clause VARCHAR2(1000) := null; -- where caluse for generic source
1217: wti_dyn_where_clause VARCHAR2(1000) := null; -- where caluse for imventory tables
1218: l_check_failed_close_jobs varchar2(2000);
1219: BEGIN
1220: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
1221: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
1222: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
1223: row_limit := 1000;
1224: -- accept input
1217: wti_dyn_where_clause VARCHAR2(1000) := null; -- where caluse for imventory tables
1218: l_check_failed_close_jobs varchar2(2000);
1219: BEGIN
1220: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
1221: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
1222: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
1223: row_limit := 1000;
1224: -- accept input
1225: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Organization Id',inputs);
1221: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
1222: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
1223: row_limit := 1000;
1224: -- accept input
1225: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Organization Id',inputs);
1226: l_job_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Job Id',inputs);
1227: --l_cutoff_date := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('CutoffDate',inputs);
1228:
1229: if l_org_id is not null then
1222: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
1223: row_limit := 1000;
1224: -- accept input
1225: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Organization Id',inputs);
1226: l_job_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Job Id',inputs);
1227: --l_cutoff_date := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('CutoffDate',inputs);
1228:
1229: if l_org_id is not null then
1230: we_dyn_where_clause := ' we.organization_id = '|| l_org_id || ' AND ';
1223: row_limit := 1000;
1224: -- accept input
1225: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Organization Id',inputs);
1226: l_job_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Job Id',inputs);
1227: --l_cutoff_date := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('CutoffDate',inputs);
1228:
1229: if l_org_id is not null then
1230: we_dyn_where_clause := ' we.organization_id = '|| l_org_id || ' AND ';
1231: wdj_dyn_where_clause := ' wdj.organization_id = '|| l_org_id || ' AND ';
1400: fixInfo := 'OK';
1401: errStr :='No Error!';
1402:
1403: <
1404: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
1405: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
1406:
1407: END failed_job_close_job;
1408:
1401: errStr :='No Error!';
1402:
1403: <
1404: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
1405: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
1406:
1407: END failed_job_close_job;
1408:
1409: END;