APPS.INV_DIAG_MSN dependencies on JTF_DIAGNOSTIC_COREAPI

Line 20: dummy_v2t JTF_DIAGNOSTIC_COREAPI.v2t;

16: reportClob OUT NOCOPY CLOB) IS
17:
18: reportStr LONG;
19: counter NUMBER;
20: dummy_v2t JTF_DIAGNOSTIC_COREAPI.v2t;
21: c_userid VARCHAR2(50);
22: statusStr VARCHAR2(50);
23: errStr VARCHAR2(4000);
24: fixInfo VARCHAR2(4000);

Line 39: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;

35: BEGIN
36:
37: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
38: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
39: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
40:
41: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrgId',inputs);
42: l_sn := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('SerialNum',inputs);
43: l_item_id :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('ItemId',inputs);

Line 85: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Serial Status');

81: 'ORDER BY msn.serial_number ';
82:
83: sqltxt := 'select * from ('||sqltxt||') WHERE ROWNUM <= '||row_limit;
84:
85: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Serial Status');
86:
87: delete from inv_diag_msn_temp;
88:
89: insert into inv_diag_msn_temp

Line 104: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint(' Parameter input is requred ');

100: statusStr := 'SUCCESS';
101:
102: ELSE
103:
104: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint(' Parameter input is requred ');
105: statusStr := 'FAILURE';
106: errStr := 'This test failed as: no input';
107: fixInfo := 'Please enter at least one of the following parameters: Serial or ItemId';
108: isFatal := 'SUCCESS';