DBA Data[Home] [Help]

APPS.WIP_DIAG_JOB_SCH_HC dependencies on JTF_DIAGNOSTIC_ADAPTUTIL

Line 40: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;

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

Line 41: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');

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);

Line 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

Line 46: l_job_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Job Id',inputs);

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 ';

Line 47: --l_cutoff_date := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('CutoffDate',inputs);

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 ';

Line 1195: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);

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:

Line 1196: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

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,

Line 1220: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;

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

Line 1221: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');

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);

Line 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

Line 1226: l_job_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Job Id',inputs);

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 ';

Line 1227: --l_cutoff_date := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('CutoffDate',inputs);

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 ';

Line 1404: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);

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:

Line 1405: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

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;