33: l_patch varchar2(100);
34: l_conc_prg varchar2(30);
35:
36: BEGIN
37: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
38: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
39: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
40: -- accept input
41: l_script :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('CheckName',inputs);
34: l_conc_prg varchar2(30);
35:
36: BEGIN
37: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
38: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
39: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
40: -- accept input
41: l_script :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('CheckName',inputs);
42: l_app_id :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('ApplicationId',inputs);
37: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
38: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
39: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
40: -- accept input
41: l_script :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('CheckName',inputs);
42: l_app_id :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('ApplicationId',inputs);
43: l_pkg :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Package',inputs);
44: l_file :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('FileName',inputs);
45: l_patch :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('PatchNum',inputs);
38: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
39: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
40: -- accept input
41: l_script :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('CheckName',inputs);
42: l_app_id :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('ApplicationId',inputs);
43: l_pkg :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Package',inputs);
44: l_file :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('FileName',inputs);
45: l_patch :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('PatchNum',inputs);
46: l_conc_prg :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('ConcurrentProgram',inputs);
39: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
40: -- accept input
41: l_script :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('CheckName',inputs);
42: l_app_id :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('ApplicationId',inputs);
43: l_pkg :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Package',inputs);
44: l_file :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('FileName',inputs);
45: l_patch :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('PatchNum',inputs);
46: l_conc_prg :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('ConcurrentProgram',inputs);
47: row_limit :=INV_DIAG_GRP.g_max_row;
40: -- accept input
41: l_script :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('CheckName',inputs);
42: l_app_id :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('ApplicationId',inputs);
43: l_pkg :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Package',inputs);
44: l_file :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('FileName',inputs);
45: l_patch :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('PatchNum',inputs);
46: l_conc_prg :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('ConcurrentProgram',inputs);
47: row_limit :=INV_DIAG_GRP.g_max_row;
48:
41: l_script :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('CheckName',inputs);
42: l_app_id :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('ApplicationId',inputs);
43: l_pkg :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Package',inputs);
44: l_file :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('FileName',inputs);
45: l_patch :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('PatchNum',inputs);
46: l_conc_prg :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('ConcurrentProgram',inputs);
47: row_limit :=INV_DIAG_GRP.g_max_row;
48:
49: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(':'||l_org_id||' Check '||l_script||' appId '||l_app_id);
42: l_app_id :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('ApplicationId',inputs);
43: l_pkg :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Package',inputs);
44: l_file :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('FileName',inputs);
45: l_patch :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('PatchNum',inputs);
46: l_conc_prg :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('ConcurrentProgram',inputs);
47: row_limit :=INV_DIAG_GRP.g_max_row;
48:
49: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(':'||l_org_id||' Check '||l_script||' appId '||l_app_id);
50: JTF_DIAGNOSTIC_COREAPI.BRPrint;
45: l_patch :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('PatchNum',inputs);
46: l_conc_prg :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('ConcurrentProgram',inputs);
47: row_limit :=INV_DIAG_GRP.g_max_row;
48:
49: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(':'||l_org_id||' Check '||l_script||' appId '||l_app_id);
50: JTF_DIAGNOSTIC_COREAPI.BRPrint;
51:
52: if l_app_id is null then
53: select APPLICATION_ID
422: end if;
423: -- construct report
424: statusStr := 'SUCCESS';
425: isFatal := 'FALSE';
426: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
427: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
428:
429: END runTest;
430:
423: -- construct report
424: statusStr := 'SUCCESS';
425: isFatal := 'FALSE';
426: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
427: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
428:
429: END runTest;
430:
431: PROCEDURE getComponentName(name OUT NOCOPY VARCHAR2) IS
446: PROCEDURE getDependencies (package_names OUT NOCOPY JTF_DIAG_DEPENDTBL) IS
447: tempDependencies JTF_DIAG_DEPENDTBL;
448:
449: BEGIN
450: package_names := JTF_DIAGNOSTIC_ADAPTUTIL.initDependencyTable;
451: END getDependencies;
452:
453: PROCEDURE isDependencyPipelined (str OUT NOCOPY VARCHAR2) IS
454: BEGIN
458:
459: PROCEDURE getOutputValues(outputValues OUT NOCOPY JTF_DIAG_OUTPUTTBL) IS
460: tempOutput JTF_DIAG_OUTPUTTBL;
461: BEGIN
462: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
463: outputValues := tempOutput;
464: EXCEPTION
465: when others then
466: outputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
462: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
463: outputValues := tempOutput;
464: EXCEPTION
465: when others then
466: outputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
467: END getOutputValues;
468:
469:
470: PROCEDURE getDefaultTestParams(defaultInputValues OUT NOCOPY JTF_DIAG_INPUTTBL) IS
469:
470: PROCEDURE getDefaultTestParams(defaultInputValues OUT NOCOPY JTF_DIAG_INPUTTBL) IS
471: tempInput JTF_DIAG_INPUTTBL;
472: BEGIN
473: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
474: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'CheckName','LOV-oracle.apps.inv.diag.lov.EnvSetupLov');
475: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'ApplicationId','LOV-oracle.apps.inv.diag.lov.AppLov');
476: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Package','');
477: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'FileName','');
470: PROCEDURE getDefaultTestParams(defaultInputValues OUT NOCOPY JTF_DIAG_INPUTTBL) IS
471: tempInput JTF_DIAG_INPUTTBL;
472: BEGIN
473: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
474: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'CheckName','LOV-oracle.apps.inv.diag.lov.EnvSetupLov');
475: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'ApplicationId','LOV-oracle.apps.inv.diag.lov.AppLov');
476: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Package','');
477: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'FileName','');
478: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'PatchNum','');
471: tempInput JTF_DIAG_INPUTTBL;
472: BEGIN
473: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
474: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'CheckName','LOV-oracle.apps.inv.diag.lov.EnvSetupLov');
475: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'ApplicationId','LOV-oracle.apps.inv.diag.lov.AppLov');
476: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Package','');
477: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'FileName','');
478: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'PatchNum','');
479: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'ConcurrentProgram','');
472: BEGIN
473: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
474: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'CheckName','LOV-oracle.apps.inv.diag.lov.EnvSetupLov');
475: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'ApplicationId','LOV-oracle.apps.inv.diag.lov.AppLov');
476: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Package','');
477: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'FileName','');
478: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'PatchNum','');
479: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'ConcurrentProgram','');
480: defaultInputValues := tempInput;
473: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
474: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'CheckName','LOV-oracle.apps.inv.diag.lov.EnvSetupLov');
475: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'ApplicationId','LOV-oracle.apps.inv.diag.lov.AppLov');
476: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Package','');
477: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'FileName','');
478: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'PatchNum','');
479: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'ConcurrentProgram','');
480: defaultInputValues := tempInput;
481: EXCEPTION
474: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'CheckName','LOV-oracle.apps.inv.diag.lov.EnvSetupLov');
475: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'ApplicationId','LOV-oracle.apps.inv.diag.lov.AppLov');
476: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Package','');
477: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'FileName','');
478: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'PatchNum','');
479: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'ConcurrentProgram','');
480: defaultInputValues := tempInput;
481: EXCEPTION
482: when others then
475: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'ApplicationId','LOV-oracle.apps.inv.diag.lov.AppLov');
476: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Package','');
477: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'FileName','');
478: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'PatchNum','');
479: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'ConcurrentProgram','');
480: defaultInputValues := tempInput;
481: EXCEPTION
482: when others then
483: defaultInputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
479: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'ConcurrentProgram','');
480: defaultInputValues := tempInput;
481: EXCEPTION
482: when others then
483: defaultInputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
484: END getDefaultTestParams;
485:
486: Function getTestMode return INTEGER IS
487: BEGIN
484: END getDefaultTestParams;
485:
486: Function getTestMode return INTEGER IS
487: BEGIN
488: return JTF_DIAGNOSTIC_ADAPTUTIL.ADVANCED_MODE;
489:
490: END getTestMode;
491:
492: END;