eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_DIAG_TDUMP dependencies on JTF_DIAGNOSTIC_ADAPTUTIL

Line 35: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;

31: l_lot VARCHAR2(30);
32: l_script varchar2(30);
33: l_proc_flag varchar2(1);
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);

Line 36: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');

32: l_script varchar2(30);
33: l_proc_flag varchar2(1);
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_txn_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('TransactionId',inputs);

Line 39: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrgId',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_txn_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('TransactionId',inputs);
41: l_item_id :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('ItemId',inputs);
42: l_script :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('TableName',inputs);
43: l_proc_flag :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('ProcFlag',inputs);

Line 40: l_txn_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('TransactionId',inputs);

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_txn_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('TransactionId',inputs);
41: l_item_id :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('ItemId',inputs);
42: l_script :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('TableName',inputs);
43: l_proc_flag :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('ProcFlag',inputs);
44: l_sn := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('SerialNum',inputs);

Line 41: l_item_id :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('ItemId',inputs);

37: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
38: -- accept input
39: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrgId',inputs);
40: l_txn_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('TransactionId',inputs);
41: l_item_id :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('ItemId',inputs);
42: l_script :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('TableName',inputs);
43: l_proc_flag :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('ProcFlag',inputs);
44: l_sn := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('SerialNum',inputs);
45: l_lot := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('LotNum',inputs);

Line 42: l_script :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('TableName',inputs);

38: -- accept input
39: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrgId',inputs);
40: l_txn_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('TransactionId',inputs);
41: l_item_id :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('ItemId',inputs);
42: l_script :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('TableName',inputs);
43: l_proc_flag :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('ProcFlag',inputs);
44: l_sn := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('SerialNum',inputs);
45: l_lot := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('LotNum',inputs);
46:

Line 43: l_proc_flag :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('ProcFlag',inputs);

39: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrgId',inputs);
40: l_txn_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('TransactionId',inputs);
41: l_item_id :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('ItemId',inputs);
42: l_script :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('TableName',inputs);
43: l_proc_flag :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('ProcFlag',inputs);
44: l_sn := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('SerialNum',inputs);
45: l_lot := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('LotNum',inputs);
46:
47: row_limit :=INV_DIAG_GRP.g_max_row;

Line 44: l_sn := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('SerialNum',inputs);

40: l_txn_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('TransactionId',inputs);
41: l_item_id :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('ItemId',inputs);
42: l_script :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('TableName',inputs);
43: l_proc_flag :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('ProcFlag',inputs);
44: l_sn := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('SerialNum',inputs);
45: l_lot := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('LotNum',inputs);
46:
47: row_limit :=INV_DIAG_GRP.g_max_row;
48:

Line 45: l_lot := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('LotNum',inputs);

41: l_item_id :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('ItemId',inputs);
42: l_script :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('TableName',inputs);
43: l_proc_flag :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('ProcFlag',inputs);
44: l_sn := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('SerialNum',inputs);
45: l_lot := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('LotNum',inputs);
46:
47: row_limit :=INV_DIAG_GRP.g_max_row;
48:
49: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('OrgID input :'||l_org_id||' Table name '||l_script);

Line 49: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('OrgID input :'||l_org_id||' Table name '||l_script);

45: l_lot := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('LotNum',inputs);
46:
47: row_limit :=INV_DIAG_GRP.g_max_row;
48:
49: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('OrgID input :'||l_org_id||' Table name '||l_script);
50: JTF_DIAGNOSTIC_COREAPI.BRPrint;
51: if l_script = 'mmt' then
52: if l_txn_id is not null then
53: sqltxt := 'select * from MTL_MATERIAL_TRANSACTIONS where transaction_id ='||l_txn_id;

Line 236: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);

232: end if;
233: end if;
234:
235: -- construct report
236: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
237: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
238:
239: END runTest;
240:

Line 237: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

233: end if;
234:
235: -- construct report
236: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
237: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
238:
239: END runTest;
240:
241: PROCEDURE getComponentName(name OUT NOCOPY VARCHAR2) IS

Line 260: package_names := JTF_DIAGNOSTIC_ADAPTUTIL.initDependencyTable;

256: PROCEDURE getDependencies (package_names OUT NOCOPY JTF_DIAG_DEPENDTBL) IS
257: tempDependencies JTF_DIAG_DEPENDTBL;
258:
259: BEGIN
260: package_names := JTF_DIAGNOSTIC_ADAPTUTIL.initDependencyTable;
261: END getDependencies;
262:
263: PROCEDURE isDependencyPipelined (str OUT NOCOPY VARCHAR2) IS
264: BEGIN

Line 272: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;

268:
269: PROCEDURE getOutputValues(outputValues OUT NOCOPY JTF_DIAG_OUTPUTTBL) IS
270: tempOutput JTF_DIAG_OUTPUTTBL;
271: BEGIN
272: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
273: outputValues := tempOutput;
274: EXCEPTION
275: when others then
276: outputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;

Line 276: outputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;

272: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
273: outputValues := tempOutput;
274: EXCEPTION
275: when others then
276: outputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
277: END getOutputValues;
278:
279:
280: PROCEDURE getDefaultTestParams(defaultInputValues OUT NOCOPY JTF_DIAG_INPUTTBL) IS

Line 283: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;

279:
280: PROCEDURE getDefaultTestParams(defaultInputValues OUT NOCOPY JTF_DIAG_INPUTTBL) IS
281: tempInput JTF_DIAG_INPUTTBL;
282: BEGIN
283: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
284: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'OrgId','LOV-oracle.apps.inv.diag.lov.OrganizationLov');
285: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'TableName','LOV-oracle.apps.inv.diag.lov.TxnTablesLov');
286: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'TransactionId','');
287: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'ItemId','LOV-oracle.apps.inv.diag.lov.ItemLov');

Line 284: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'OrgId','LOV-oracle.apps.inv.diag.lov.OrganizationLov');

280: PROCEDURE getDefaultTestParams(defaultInputValues OUT NOCOPY JTF_DIAG_INPUTTBL) IS
281: tempInput JTF_DIAG_INPUTTBL;
282: BEGIN
283: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
284: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'OrgId','LOV-oracle.apps.inv.diag.lov.OrganizationLov');
285: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'TableName','LOV-oracle.apps.inv.diag.lov.TxnTablesLov');
286: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'TransactionId','');
287: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'ItemId','LOV-oracle.apps.inv.diag.lov.ItemLov');
288: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'ProcFlag','LOV-oracle.apps.inv.diag.lov.ErroredAllLov');

Line 285: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'TableName','LOV-oracle.apps.inv.diag.lov.TxnTablesLov');

281: tempInput JTF_DIAG_INPUTTBL;
282: BEGIN
283: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
284: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'OrgId','LOV-oracle.apps.inv.diag.lov.OrganizationLov');
285: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'TableName','LOV-oracle.apps.inv.diag.lov.TxnTablesLov');
286: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'TransactionId','');
287: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'ItemId','LOV-oracle.apps.inv.diag.lov.ItemLov');
288: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'ProcFlag','LOV-oracle.apps.inv.diag.lov.ErroredAllLov');
289: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'SerialNum','LOV-oracle.apps.inv.diag.lov.SerialLov');

Line 286: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'TransactionId','');

282: BEGIN
283: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
284: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'OrgId','LOV-oracle.apps.inv.diag.lov.OrganizationLov');
285: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'TableName','LOV-oracle.apps.inv.diag.lov.TxnTablesLov');
286: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'TransactionId','');
287: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'ItemId','LOV-oracle.apps.inv.diag.lov.ItemLov');
288: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'ProcFlag','LOV-oracle.apps.inv.diag.lov.ErroredAllLov');
289: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'SerialNum','LOV-oracle.apps.inv.diag.lov.SerialLov');
290: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'LotNum','LOV-oracle.apps.inv.diag.lov.LotLov');

Line 287: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'ItemId','LOV-oracle.apps.inv.diag.lov.ItemLov');

283: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
284: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'OrgId','LOV-oracle.apps.inv.diag.lov.OrganizationLov');
285: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'TableName','LOV-oracle.apps.inv.diag.lov.TxnTablesLov');
286: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'TransactionId','');
287: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'ItemId','LOV-oracle.apps.inv.diag.lov.ItemLov');
288: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'ProcFlag','LOV-oracle.apps.inv.diag.lov.ErroredAllLov');
289: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'SerialNum','LOV-oracle.apps.inv.diag.lov.SerialLov');
290: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'LotNum','LOV-oracle.apps.inv.diag.lov.LotLov');
291: defaultInputValues := tempInput;

Line 288: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'ProcFlag','LOV-oracle.apps.inv.diag.lov.ErroredAllLov');

284: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'OrgId','LOV-oracle.apps.inv.diag.lov.OrganizationLov');
285: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'TableName','LOV-oracle.apps.inv.diag.lov.TxnTablesLov');
286: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'TransactionId','');
287: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'ItemId','LOV-oracle.apps.inv.diag.lov.ItemLov');
288: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'ProcFlag','LOV-oracle.apps.inv.diag.lov.ErroredAllLov');
289: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'SerialNum','LOV-oracle.apps.inv.diag.lov.SerialLov');
290: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'LotNum','LOV-oracle.apps.inv.diag.lov.LotLov');
291: defaultInputValues := tempInput;
292: EXCEPTION

Line 289: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'SerialNum','LOV-oracle.apps.inv.diag.lov.SerialLov');

285: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'TableName','LOV-oracle.apps.inv.diag.lov.TxnTablesLov');
286: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'TransactionId','');
287: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'ItemId','LOV-oracle.apps.inv.diag.lov.ItemLov');
288: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'ProcFlag','LOV-oracle.apps.inv.diag.lov.ErroredAllLov');
289: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'SerialNum','LOV-oracle.apps.inv.diag.lov.SerialLov');
290: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'LotNum','LOV-oracle.apps.inv.diag.lov.LotLov');
291: defaultInputValues := tempInput;
292: EXCEPTION
293: when others then

Line 290: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'LotNum','LOV-oracle.apps.inv.diag.lov.LotLov');

286: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'TransactionId','');
287: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'ItemId','LOV-oracle.apps.inv.diag.lov.ItemLov');
288: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'ProcFlag','LOV-oracle.apps.inv.diag.lov.ErroredAllLov');
289: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'SerialNum','LOV-oracle.apps.inv.diag.lov.SerialLov');
290: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'LotNum','LOV-oracle.apps.inv.diag.lov.LotLov');
291: defaultInputValues := tempInput;
292: EXCEPTION
293: when others then
294: defaultInputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;

Line 294: defaultInputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;

290: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'LotNum','LOV-oracle.apps.inv.diag.lov.LotLov');
291: defaultInputValues := tempInput;
292: EXCEPTION
293: when others then
294: defaultInputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
295: END getDefaultTestParams;
296:
297: Function getTestMode return INTEGER IS
298: BEGIN

Line 299: return JTF_DIAGNOSTIC_ADAPTUTIL.ADVANCED_MODE;

295: END getDefaultTestParams;
296:
297: Function getTestMode return INTEGER IS
298: BEGIN
299: return JTF_DIAGNOSTIC_ADAPTUTIL.ADVANCED_MODE;
300:
301: END getTestMode;
302:
303: END;