26:
27:
28: PROCEDURE getDependencies (package_names OUT NOCOPY JTF_DIAG_DEPENDTBL) IS
29: BEGIN
30: package_names := JTF_DIAGNOSTIC_ADAPTUTIL.initDependencyTable;
31: -- str := 'null';
32: END getDependencies;
33:
34: PROCEDURE isDependencyPipelined (str OUT NOCOPY VARCHAR2) IS
39:
40: PROCEDURE getOutputValues(outputValues OUT NOCOPY JTF_DIAG_OUTPUTTBL) IS
41: tempOutput JTF_DIAG_OUTPUTTBL;
42: BEGIN
43: outputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
44: END getOutputValues;
45:
46:
47: ------------------------------------------------------------
49: ------------------------------------------------------------
50: PROCEDURE getDefaultTestParams(defaultInputValues OUT NOCOPY JTF_DIAG_INPUTTBL) IS
51: tempInput JTF_DIAG_INPUTTBL;
52: BEGIN
53: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
54: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'OrgId','LOV-oracle.apps.inv.diag.lov.OrganizationLov');
55: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'ItemId','LOV-oracle.apps.inv.diag.lov.ItemLov');
56: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'TableName','LOV-oracle.apps.inv.diag.lov.TxnTablesLov');
57: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'TransactionId','');
50: PROCEDURE getDefaultTestParams(defaultInputValues OUT NOCOPY JTF_DIAG_INPUTTBL) IS
51: tempInput JTF_DIAG_INPUTTBL;
52: BEGIN
53: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
54: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'OrgId','LOV-oracle.apps.inv.diag.lov.OrganizationLov');
55: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'ItemId','LOV-oracle.apps.inv.diag.lov.ItemLov');
56: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'TableName','LOV-oracle.apps.inv.diag.lov.TxnTablesLov');
57: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'TransactionId','');
58: defaultInputValues := tempInput;
51: tempInput JTF_DIAG_INPUTTBL;
52: BEGIN
53: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
54: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'OrgId','LOV-oracle.apps.inv.diag.lov.OrganizationLov');
55: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'ItemId','LOV-oracle.apps.inv.diag.lov.ItemLov');
56: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'TableName','LOV-oracle.apps.inv.diag.lov.TxnTablesLov');
57: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'TransactionId','');
58: defaultInputValues := tempInput;
59: --EXCEPTION
52: BEGIN
53: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
54: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'OrgId','LOV-oracle.apps.inv.diag.lov.OrganizationLov');
55: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'ItemId','LOV-oracle.apps.inv.diag.lov.ItemLov');
56: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'TableName','LOV-oracle.apps.inv.diag.lov.TxnTablesLov');
57: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'TransactionId','');
58: defaultInputValues := tempInput;
59: --EXCEPTION
60: --when others then
53: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
54: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'OrgId','LOV-oracle.apps.inv.diag.lov.OrganizationLov');
55: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'ItemId','LOV-oracle.apps.inv.diag.lov.ItemLov');
56: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'TableName','LOV-oracle.apps.inv.diag.lov.TxnTablesLov');
57: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'TransactionId','');
58: defaultInputValues := tempInput;
59: --EXCEPTION
60: --when others then
61: defaultInputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
57: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'TransactionId','');
58: defaultInputValues := tempInput;
59: --EXCEPTION
60: --when others then
61: defaultInputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
62: END getDefaultTestParams;
63:
64: ------------------------------------------------------------
65: -- procedure to report test mode back to the framework
112: l_lot VARCHAR2(30);
113: l_script varchar2(30);
114: l_proc_flag varchar2(1);
115: BEGIN
116: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
117: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
118: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
119: -- accept input
120: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrgId',inputs);
113: l_script varchar2(30);
114: l_proc_flag varchar2(1);
115: BEGIN
116: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
117: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
118: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
119: -- accept input
120: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrgId',inputs);
121: l_txn_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('TransactionId',inputs);
116: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
117: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
118: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
119: -- accept input
120: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrgId',inputs);
121: l_txn_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('TransactionId',inputs);
122: l_item_id :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('ItemId',inputs);
123: l_script :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('TableName',inputs);
124: l_proc_flag :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('ProcFlag',inputs);
117: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
118: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
119: -- accept input
120: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrgId',inputs);
121: l_txn_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('TransactionId',inputs);
122: l_item_id :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('ItemId',inputs);
123: l_script :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('TableName',inputs);
124: l_proc_flag :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('ProcFlag',inputs);
125: l_sn := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('SerialNum',inputs);
118: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
119: -- accept input
120: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrgId',inputs);
121: l_txn_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('TransactionId',inputs);
122: l_item_id :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('ItemId',inputs);
123: l_script :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('TableName',inputs);
124: l_proc_flag :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('ProcFlag',inputs);
125: l_sn := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('SerialNum',inputs);
126: l_lot := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('LotNum',inputs);
119: -- accept input
120: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrgId',inputs);
121: l_txn_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('TransactionId',inputs);
122: l_item_id :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('ItemId',inputs);
123: l_script :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('TableName',inputs);
124: l_proc_flag :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('ProcFlag',inputs);
125: l_sn := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('SerialNum',inputs);
126: l_lot := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('LotNum',inputs);
127:
120: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrgId',inputs);
121: l_txn_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('TransactionId',inputs);
122: l_item_id :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('ItemId',inputs);
123: l_script :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('TableName',inputs);
124: l_proc_flag :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('ProcFlag',inputs);
125: l_sn := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('SerialNum',inputs);
126: l_lot := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('LotNum',inputs);
127:
128: row_limit :=INV_DIAG_GRP.g_max_row;
121: l_txn_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('TransactionId',inputs);
122: l_item_id :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('ItemId',inputs);
123: l_script :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('TableName',inputs);
124: l_proc_flag :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('ProcFlag',inputs);
125: l_sn := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('SerialNum',inputs);
126: l_lot := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('LotNum',inputs);
127:
128: row_limit :=INV_DIAG_GRP.g_max_row;
129:
122: l_item_id :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('ItemId',inputs);
123: l_script :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('TableName',inputs);
124: l_proc_flag :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('ProcFlag',inputs);
125: l_sn := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('SerialNum',inputs);
126: l_lot := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('LotNum',inputs);
127:
128: row_limit :=INV_DIAG_GRP.g_max_row;
129:
130: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('OrgID input :'||l_org_id||' Table name '||l_script);
126: l_lot := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('LotNum',inputs);
127:
128: row_limit :=INV_DIAG_GRP.g_max_row;
129:
130: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('OrgID input :'||l_org_id||' Table name '||l_script);
131: JTF_DIAGNOSTIC_COREAPI.BRPrint;
132:
133: statusStr := 'SUCCESS';
134: isFatal := 'FALSE';
132:
133: statusStr := 'SUCCESS';
134: isFatal := 'FALSE';
135: -- construct report
136: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
137: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
138:
139: END runTest;
140:
133: statusStr := 'SUCCESS';
134: isFatal := 'FALSE';
135: -- construct report
136: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
137: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
138:
139: END runTest;
140:
141: END INV_DIAG_RCV;