28: l_org_id NUMBER;
29: l_acct_period_id NUMBER;
30: l_proc_flag varchar2(1);
31: BEGIN
32: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
33: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
34: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
35: -- accept input
36: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrgId',inputs);
29: l_acct_period_id NUMBER;
30: l_proc_flag varchar2(1);
31: BEGIN
32: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
33: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
34: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
35: -- accept input
36: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrgId',inputs);
37: l_acct_period_id :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('AcctId',inputs);
32: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
33: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
34: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
35: -- accept input
36: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrgId',inputs);
37: l_acct_period_id :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('AcctId',inputs);
38: l_proc_flag :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('ProcFlag',inputs);
39:
40: -- l_txn_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('testout',inputs);
33: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
34: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
35: -- accept input
36: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrgId',inputs);
37: l_acct_period_id :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('AcctId',inputs);
38: l_proc_flag :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('ProcFlag',inputs);
39:
40: -- l_txn_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('testout',inputs);
41:
34: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
35: -- accept input
36: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrgId',inputs);
37: l_acct_period_id :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('AcctId',inputs);
38: l_proc_flag :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('ProcFlag',inputs);
39:
40: -- l_txn_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('testout',inputs);
41:
42: sqltxt :='SELECT DISTINCT period_name "Period|Name" '||
36: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrgId',inputs);
37: l_acct_period_id :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('AcctId',inputs);
38: l_proc_flag :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('ProcFlag',inputs);
39:
40: -- l_txn_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('testout',inputs);
41:
42: sqltxt :='SELECT DISTINCT period_name "Period|Name" '||
43: ' , oap.acct_period_id "Period|Id" '||
44: ' , mp.organization_code "Organization|Code" '||
131: isFatal := 'SUCCESS';
132: end if;
133: **/
134: -- construct report
135: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
136: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
137: END runTest;
138:
139: PROCEDURE getComponentName(name OUT NOCOPY VARCHAR2) IS
132: end if;
133: **/
134: -- construct report
135: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
136: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
137: END runTest;
138:
139: PROCEDURE getComponentName(name OUT NOCOPY VARCHAR2) IS
140: BEGIN
154: PROCEDURE getDependencies (package_names OUT NOCOPY JTF_DIAG_DEPENDTBL) IS
155: tempDependencies JTF_DIAG_DEPENDTBL;
156:
157: BEGIN
158: package_names := JTF_DIAGNOSTIC_ADAPTUTIL.initDependencyTable;
159: END getDependencies;
160:
161: PROCEDURE isDependencyPipelined (str OUT NOCOPY VARCHAR2) IS
162: BEGIN
166:
167: PROCEDURE getOutputValues(outputValues OUT NOCOPY JTF_DIAG_OUTPUTTBL) IS
168: tempOutput JTF_DIAG_OUTPUTTBL;
169: BEGIN
170: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
171: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.addOutput(tempOutput,'testout', test_out);
172: outputValues := tempOutput;
173: EXCEPTION
174: when others then
167: PROCEDURE getOutputValues(outputValues OUT NOCOPY JTF_DIAG_OUTPUTTBL) IS
168: tempOutput JTF_DIAG_OUTPUTTBL;
169: BEGIN
170: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
171: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.addOutput(tempOutput,'testout', test_out);
172: outputValues := tempOutput;
173: EXCEPTION
174: when others then
175: outputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
171: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.addOutput(tempOutput,'testout', test_out);
172: outputValues := tempOutput;
173: EXCEPTION
174: when others then
175: outputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
176: END getOutputValues;
177:
178:
179: PROCEDURE getDefaultTestParams(defaultInputValues OUT NOCOPY JTF_DIAG_INPUTTBL) IS
178:
179: PROCEDURE getDefaultTestParams(defaultInputValues OUT NOCOPY JTF_DIAG_INPUTTBL) IS
180: tempInput JTF_DIAG_INPUTTBL;
181: BEGIN
182: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
183: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'OrgId','LOV-oracle.apps.inv.diag.lov.OrganizationLov');
184: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'ItemId','LOV-oracle.apps.inv.diag.lov.ItemLov');
185: defaultInputValues := tempInput;
186: EXCEPTION
179: PROCEDURE getDefaultTestParams(defaultInputValues OUT NOCOPY JTF_DIAG_INPUTTBL) IS
180: tempInput JTF_DIAG_INPUTTBL;
181: BEGIN
182: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
183: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'OrgId','LOV-oracle.apps.inv.diag.lov.OrganizationLov');
184: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'ItemId','LOV-oracle.apps.inv.diag.lov.ItemLov');
185: defaultInputValues := tempInput;
186: EXCEPTION
187: when others then
180: tempInput JTF_DIAG_INPUTTBL;
181: BEGIN
182: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
183: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'OrgId','LOV-oracle.apps.inv.diag.lov.OrganizationLov');
184: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'ItemId','LOV-oracle.apps.inv.diag.lov.ItemLov');
185: defaultInputValues := tempInput;
186: EXCEPTION
187: when others then
188: defaultInputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
184: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'ItemId','LOV-oracle.apps.inv.diag.lov.ItemLov');
185: defaultInputValues := tempInput;
186: EXCEPTION
187: when others then
188: defaultInputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
189: END getDefaultTestParams;
190:
191: Function getTestMode return INTEGER IS
192: BEGIN
189: END getDefaultTestParams;
190:
191: Function getTestMode return INTEGER IS
192: BEGIN
193: return JTF_DIAGNOSTIC_ADAPTUTIL.ADVANCED_MODE;
194:
195: END getTestMode;
196:
197: END INV_DIAG_MO;