DBA Data[Home] [Help]

APPS.WIP_DIAG_REPETITIVE dependencies on JTF_DIAGNOSTIC_ADAPTUTIL

Line 20: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;

16: l_item_id NUMBER;
17: l_org_id NUMBER;
18: we_dyn_where_clause VARCHAR2(1000):= null;
19: BEGIN
20: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
21: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
22: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
23: row_limit := 1000;
24: -- accept input

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

17: l_org_id NUMBER;
18: we_dyn_where_clause VARCHAR2(1000):= null;
19: BEGIN
20: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
21: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
22: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
23: row_limit := 1000;
24: -- accept input
25: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrganizationId',inputs);

Line 25: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrganizationId',inputs);

21: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
22: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
23: row_limit := 1000;
24: -- accept input
25: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrganizationId',inputs);
26:
27: if (l_org_id IS NOT NULL) then
28: reportStr := ' Input Parameters :
';
29: reportStr := reportStr || 'Organization Id = ' || l_org_id || '
';

Line 30: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);

26:
27: if (l_org_id IS NOT NULL) then
28: reportStr := ' Input Parameters :
';
29: reportStr := reportStr || 'Organization Id = ' || l_org_id || '
';
30: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
31: end if;
32:
33: if (l_org_id IS NOT NULL) then
34: we_dyn_where_clause := 'AND we.organization_id = '|| l_org_id || ' ';

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

424: fixInfo := 'OK';
425: errStr :='No Error!';
426:
427: <>
428: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
429: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
430:
431: END Uncosted_mat_txn_rep;
432:

Line 429: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

425: errStr :='No Error!';
426:
427: <>
428: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
429: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
430:
431: END Uncosted_mat_txn_rep;
432:
433: END;