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
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);
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 || '
';
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 || ' ';
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:
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;