66: and mp.primary_cost_method <> 1;
67:
68:
69: BEGIN
70: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
71: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
72: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
73: -- accept input
74: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrgId',inputs);
67:
68:
69: BEGIN
70: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
71: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
72: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
73: -- accept input
74: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrgId',inputs);
75: l_script :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('ScriptName',inputs);
70: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
71: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
72: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
73: -- accept input
74: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrgId',inputs);
75: l_script :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('ScriptName',inputs);
76: l_proc_flag :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('ProcFlag',inputs);
77: row_limit :=INV_DIAG_GRP.g_max_row;
78:
71: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
72: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
73: -- accept input
74: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrgId',inputs);
75: l_script :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('ScriptName',inputs);
76: l_proc_flag :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('ProcFlag',inputs);
77: row_limit :=INV_DIAG_GRP.g_max_row;
78:
79: if l_script = 'acct_period' then
72: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
73: -- accept input
74: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrgId',inputs);
75: l_script :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('ScriptName',inputs);
76: l_proc_flag :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('ProcFlag',inputs);
77: row_limit :=INV_DIAG_GRP.g_max_row;
78:
79: if l_script = 'acct_period' then
80:
606: statusStr := 'SUCCESS';
607: isFatal := 'FALSE';
608:
609: -- construct report
610: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
611: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
612: END runTest;
613:
614: PROCEDURE getComponentName(name OUT NOCOPY VARCHAR2) IS
607: isFatal := 'FALSE';
608:
609: -- construct report
610: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
611: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
612: END runTest;
613:
614: PROCEDURE getComponentName(name OUT NOCOPY VARCHAR2) IS
615: BEGIN
629: PROCEDURE getDependencies (package_names OUT NOCOPY JTF_DIAG_DEPENDTBL) IS
630: tempDependencies JTF_DIAG_DEPENDTBL;
631:
632: BEGIN
633: package_names := JTF_DIAGNOSTIC_ADAPTUTIL.initDependencyTable;
634: END getDependencies;
635:
636: PROCEDURE isDependencyPipelined (str OUT NOCOPY VARCHAR2) IS
637: BEGIN
641:
642: PROCEDURE getOutputValues(outputValues OUT NOCOPY JTF_DIAG_OUTPUTTBL) IS
643: tempOutput JTF_DIAG_OUTPUTTBL;
644: BEGIN
645: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
646: outputValues := tempOutput;
647: EXCEPTION
648: when others then
649: outputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
645: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
646: outputValues := tempOutput;
647: EXCEPTION
648: when others then
649: outputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
650: END getOutputValues;
651:
652:
653: PROCEDURE getDefaultTestParams(defaultInputValues OUT NOCOPY JTF_DIAG_INPUTTBL) IS
652:
653: PROCEDURE getDefaultTestParams(defaultInputValues OUT NOCOPY JTF_DIAG_INPUTTBL) IS
654: tempInput JTF_DIAG_INPUTTBL;
655: BEGIN
656: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
657: --tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'testout','');
658: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'OrgId','LOV-oracle.apps.inv.diag.lov.OrganizationLov');
659: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'ScriptName','LOV-oracle.apps.inv.diag.lov.TxnDiagScriptsLov');
660: defaultInputValues := tempInput;
653: PROCEDURE getDefaultTestParams(defaultInputValues OUT NOCOPY JTF_DIAG_INPUTTBL) IS
654: tempInput JTF_DIAG_INPUTTBL;
655: BEGIN
656: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
657: --tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'testout','');
658: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'OrgId','LOV-oracle.apps.inv.diag.lov.OrganizationLov');
659: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'ScriptName','LOV-oracle.apps.inv.diag.lov.TxnDiagScriptsLov');
660: defaultInputValues := tempInput;
661: EXCEPTION
654: tempInput JTF_DIAG_INPUTTBL;
655: BEGIN
656: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
657: --tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'testout','');
658: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'OrgId','LOV-oracle.apps.inv.diag.lov.OrganizationLov');
659: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'ScriptName','LOV-oracle.apps.inv.diag.lov.TxnDiagScriptsLov');
660: defaultInputValues := tempInput;
661: EXCEPTION
662: when others then
655: BEGIN
656: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
657: --tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'testout','');
658: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'OrgId','LOV-oracle.apps.inv.diag.lov.OrganizationLov');
659: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'ScriptName','LOV-oracle.apps.inv.diag.lov.TxnDiagScriptsLov');
660: defaultInputValues := tempInput;
661: EXCEPTION
662: when others then
663: defaultInputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
659: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'ScriptName','LOV-oracle.apps.inv.diag.lov.TxnDiagScriptsLov');
660: defaultInputValues := tempInput;
661: EXCEPTION
662: when others then
663: defaultInputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
664: END getDefaultTestParams;
665:
666: Function getTestMode return INTEGER IS
667: BEGIN
664: END getDefaultTestParams;
665:
666: Function getTestMode return INTEGER IS
667: BEGIN
668: return JTF_DIAGNOSTIC_ADAPTUTIL.ADVANCED_MODE;
669:
670: END getTestMode;
671: END;