DBA Data[Home] [Help]

APPS.WIP_DIAG_JOB_SCH_HC dependencies on JTF_DIAGNOSTIC_ADAPTUTIL

Line 37: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;

33: p_status varchar2(3);
34: p_industry varchar2(30);
35: p_table_owner varchar2(30);
36: BEGIN
37: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
38: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
39: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
40: row_limit := 1000;
41: -- accept input

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

34: p_industry varchar2(30);
35: p_table_owner varchar2(30);
36: BEGIN
37: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
38: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
39: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
40: row_limit := 1000;
41: -- accept input
42: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Organization Id',inputs);

Line 42: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Organization Id',inputs);

38: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
39: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
40: row_limit := 1000;
41: -- accept input
42: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Organization Id',inputs);
43: l_job_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Job Id',inputs);
44: --l_cutoff_date := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('CutoffDate',inputs);
45:
46: if l_org_id is not null then

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

39: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
40: row_limit := 1000;
41: -- accept input
42: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Organization Id',inputs);
43: l_job_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Job Id',inputs);
44: --l_cutoff_date := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('CutoffDate',inputs);
45:
46: if l_org_id is not null then
47: we_dyn_where_clause := ' we.organization_id = '|| l_org_id || ' AND ';

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

40: row_limit := 1000;
41: -- accept input
42: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Organization Id',inputs);
43: l_job_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Job Id',inputs);
44: --l_cutoff_date := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('CutoffDate',inputs);
45:
46: if l_org_id is not null then
47: we_dyn_where_clause := ' we.organization_id = '|| l_org_id || ' AND ';
48: wdj_dyn_where_clause := ' wdj.organization_id = '|| l_org_id || ' AND ';

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

1190: fixInfo := 'OK';
1191: errStr :='No Error!';
1192:
1193: <>
1194: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
1195: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
1196:
1197: END invalid_job_def_job;
1198:

Line 1195: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

1191: errStr :='No Error!';
1192:
1193: <>
1194: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
1195: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
1196:
1197: END invalid_job_def_job;
1198:
1199: PROCEDURE failed_job_close_job(inputs IN JTF_DIAG_INPUTTBL,

Line 1219: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;

1215: wg_dyn_where_clause VARCHAR2(1000) := null; -- where caluse for generic source
1216: wti_dyn_where_clause VARCHAR2(1000) := null; -- where caluse for imventory tables
1217: l_check_failed_close_jobs varchar2(2000);
1218: BEGIN
1219: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
1220: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
1221: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
1222: row_limit := 1000;
1223: -- accept input

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

1216: wti_dyn_where_clause VARCHAR2(1000) := null; -- where caluse for imventory tables
1217: l_check_failed_close_jobs varchar2(2000);
1218: BEGIN
1219: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
1220: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
1221: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
1222: row_limit := 1000;
1223: -- accept input
1224: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Organization Id',inputs);

Line 1224: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Organization Id',inputs);

1220: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
1221: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
1222: row_limit := 1000;
1223: -- accept input
1224: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Organization Id',inputs);
1225: l_job_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Job Id',inputs);
1226: --l_cutoff_date := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('CutoffDate',inputs);
1227:
1228: if l_org_id is not null then

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

1221: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
1222: row_limit := 1000;
1223: -- accept input
1224: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Organization Id',inputs);
1225: l_job_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Job Id',inputs);
1226: --l_cutoff_date := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('CutoffDate',inputs);
1227:
1228: if l_org_id is not null then
1229: we_dyn_where_clause := ' we.organization_id = '|| l_org_id || ' AND ';

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

1222: row_limit := 1000;
1223: -- accept input
1224: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Organization Id',inputs);
1225: l_job_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Job Id',inputs);
1226: --l_cutoff_date := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('CutoffDate',inputs);
1227:
1228: if l_org_id is not null then
1229: we_dyn_where_clause := ' we.organization_id = '|| l_org_id || ' AND ';
1230: wdj_dyn_where_clause := ' wdj.organization_id = '|| l_org_id || ' AND ';

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

1399: fixInfo := 'OK';
1400: errStr :='No Error!';
1401:
1402: <>
1403: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
1404: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
1405:
1406: END failed_job_close_job;
1407:

Line 1404: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

1400: errStr :='No Error!';
1401:
1402: <>
1403: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
1404: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
1405:
1406: END failed_job_close_job;
1407:
1408: END;