31: l_acct_period varchar2(15);
32: l_proc_flag varchar2(1);
33:
34: BEGIN
35: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
36: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
37: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
38: -- accept input
39: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrgId',inputs);
32: l_proc_flag varchar2(1);
33:
34: BEGIN
35: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
36: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
37: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
38: -- accept input
39: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrgId',inputs);
40: l_acct_period :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('AcctPeriod',inputs);
35: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
36: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
37: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
38: -- accept input
39: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrgId',inputs);
40: l_acct_period :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('AcctPeriod',inputs);
41: l_proc_flag :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('ErrorFlag',inputs);
42: row_limit :=INV_DIAG_GRP.g_max_row;
43:
36: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
37: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
38: -- accept input
39: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrgId',inputs);
40: l_acct_period :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('AcctPeriod',inputs);
41: l_proc_flag :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('ErrorFlag',inputs);
42: row_limit :=INV_DIAG_GRP.g_max_row;
43:
44: reportStr :='';
37: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
38: -- accept input
39: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrgId',inputs);
40: l_acct_period :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('AcctPeriod',inputs);
41: l_proc_flag :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('ErrorFlag',inputs);
42: row_limit :=INV_DIAG_GRP.g_max_row;
43:
44: reportStr :='';
45: if l_org_id is null and l_acct_period is null then
74: goto l_test_end;
75: end;
76: end if;
77:
78: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('OrgID input :'||l_org_id||' Account Period: '||l_acct_period||'('||l_acct_period_id||')');
79: JTF_DIAGNOSTIC_COREAPI.BRPrint;
80:
81: sqltxt := 'SELECT fa.application_name "Application Name" '||
82: ' , fa.application_short_name "Application|Shortname" '||
824: end if;
825: **/
826: -- construct report
827: <
828: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
829: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
830: END runTest;
831:
832: PROCEDURE getComponentName(name OUT NOCOPY VARCHAR2) IS
825: **/
826: -- construct report
827: <
828: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
829: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
830: END runTest;
831:
832: PROCEDURE getComponentName(name OUT NOCOPY VARCHAR2) IS
833: BEGIN
847: PROCEDURE getDependencies (package_names OUT NOCOPY JTF_DIAG_DEPENDTBL) IS
848: tempDependencies JTF_DIAG_DEPENDTBL;
849:
850: BEGIN
851: package_names := JTF_DIAGNOSTIC_ADAPTUTIL.initDependencyTable;
852: END getDependencies;
853:
854: PROCEDURE isDependencyPipelined (str OUT NOCOPY VARCHAR2) IS
855: BEGIN
859:
860: PROCEDURE getOutputValues(outputValues OUT NOCOPY JTF_DIAG_OUTPUTTBL) IS
861: tempOutput JTF_DIAG_OUTPUTTBL;
862: BEGIN
863: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
864: outputValues := tempOutput;
865: EXCEPTION
866: when others then
867: outputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
863: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
864: outputValues := tempOutput;
865: EXCEPTION
866: when others then
867: outputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
868: END getOutputValues;
869:
870:
871: PROCEDURE getDefaultTestParams(defaultInputValues OUT NOCOPY JTF_DIAG_INPUTTBL) IS
870:
871: PROCEDURE getDefaultTestParams(defaultInputValues OUT NOCOPY JTF_DIAG_INPUTTBL) IS
872: tempInput JTF_DIAG_INPUTTBL;
873: BEGIN
874: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
875: --tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'testout','');
876: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'OrgId','LOV-oracle.apps.inv.diag.lov.OrganizationLov');
877: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'AcctPeriod','LOV-oracle.apps.inv.diag.lov.PeriodLov');
878: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'ErrorFlag','LOV-oracle.apps.inv.diag.lov.MMTTErroredAllLov');
871: PROCEDURE getDefaultTestParams(defaultInputValues OUT NOCOPY JTF_DIAG_INPUTTBL) IS
872: tempInput JTF_DIAG_INPUTTBL;
873: BEGIN
874: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
875: --tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'testout','');
876: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'OrgId','LOV-oracle.apps.inv.diag.lov.OrganizationLov');
877: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'AcctPeriod','LOV-oracle.apps.inv.diag.lov.PeriodLov');
878: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'ErrorFlag','LOV-oracle.apps.inv.diag.lov.MMTTErroredAllLov');
879: defaultInputValues := tempInput;
872: tempInput JTF_DIAG_INPUTTBL;
873: BEGIN
874: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
875: --tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'testout','');
876: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'OrgId','LOV-oracle.apps.inv.diag.lov.OrganizationLov');
877: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'AcctPeriod','LOV-oracle.apps.inv.diag.lov.PeriodLov');
878: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'ErrorFlag','LOV-oracle.apps.inv.diag.lov.MMTTErroredAllLov');
879: defaultInputValues := tempInput;
880: EXCEPTION
873: BEGIN
874: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
875: --tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'testout','');
876: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'OrgId','LOV-oracle.apps.inv.diag.lov.OrganizationLov');
877: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'AcctPeriod','LOV-oracle.apps.inv.diag.lov.PeriodLov');
878: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'ErrorFlag','LOV-oracle.apps.inv.diag.lov.MMTTErroredAllLov');
879: defaultInputValues := tempInput;
880: EXCEPTION
881: when others then
874: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
875: --tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'testout','');
876: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'OrgId','LOV-oracle.apps.inv.diag.lov.OrganizationLov');
877: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'AcctPeriod','LOV-oracle.apps.inv.diag.lov.PeriodLov');
878: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'ErrorFlag','LOV-oracle.apps.inv.diag.lov.MMTTErroredAllLov');
879: defaultInputValues := tempInput;
880: EXCEPTION
881: when others then
882: defaultInputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
878: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'ErrorFlag','LOV-oracle.apps.inv.diag.lov.MMTTErroredAllLov');
879: defaultInputValues := tempInput;
880: EXCEPTION
881: when others then
882: defaultInputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
883: END getDefaultTestParams;
884:
885: Function getTestMode return INTEGER IS
886: BEGIN
883: END getDefaultTestParams;
884:
885: Function getTestMode return INTEGER IS
886: BEGIN
887: return JTF_DIAGNOSTIC_ADAPTUTIL.ADVANCED_MODE;
888:
889: END getTestMode;
890:
891: END;