APPS.INV_DIAG_RCV_RMA dependencies on JTF_DIAGNOSTIC_COREAPI

Line 114: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;

110: l_receipt_num rcv_shipment_headers.receipt_num%TYPE;
111: BEGIN
112: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
113: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
114: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
115: -- accept input
116: l_rma_number := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('RMA Number',inputs));
117: l_operating_id := Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Operating Unit Id',inputs));--Bug#6828508
118: l_line_num :=Trim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('RMA Line Number',inputs));

Line 125: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('Some of the required inputs are missing');

121:
122: IF l_rma_number IS NULL THEN
123:
124: IF (l_receipt_num IS NULL OR l_org_id IS NULL) THEN
125: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('Some of the required inputs are missing');
126: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please refer to the parameters section for mandatory parameters for this
127: test');
128: statusStr := 'FAILURE';
129: --errStr := 'Some of the Required inputs are missing';

Line 126: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please refer to the parameters section for mandatory parameters for this

122: IF l_rma_number IS NULL THEN
123:
124: IF (l_receipt_num IS NULL OR l_org_id IS NULL) THEN
125: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('Some of the required inputs are missing');
126: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please refer to the parameters section for mandatory parameters for this
127: test');
128: statusStr := 'FAILURE';
129: --errStr := 'Some of the Required inputs are missing';
130: --fixInfo := 'Please rerun the Diagnostics using either Purchase order number or Receipt number ';

Line 139: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('Some of the required inputs are missing');

135: RETURN;
136: END IF;
137: ELSIF l_operating_id IS NULL THEN
138:
139: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('Some of the required inputs are missing');
140: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please refer to the parameters section for mandatory parameters for this
141: test');
142: statusStr := 'FAILURE';
143: --errStr := 'Some of the Required inputs are missing';

Line 140: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please refer to the parameters section for mandatory parameters for this

136: END IF;
137: ELSIF l_operating_id IS NULL THEN
138:
139: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('Some of the required inputs are missing');
140: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please refer to the parameters section for mandatory parameters for this
141: test');
142: statusStr := 'FAILURE';
143: --errStr := 'Some of the Required inputs are missing';
144: --fixInfo := 'Please rerun the Diagnostics using either Purchase order number or Receipt number ';

Line 153: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('Some of the required inputs are missing');

149: RETURN;
150:
151: ELSE
152: IF (l_receipt_num IS NOT NULL AND l_org_id IS NULL) THEN
153: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('Some of the required inputs are missing');
154: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please refer to the parameters section for mandatory parameters for this
155: test');
156: statusStr := 'FAILURE';
157: --errStr := 'Some of the Required inputs are missing';

Line 154: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please refer to the parameters section for mandatory parameters for this

150:
151: ELSE
152: IF (l_receipt_num IS NOT NULL AND l_org_id IS NULL) THEN
153: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('Some of the required inputs are missing');
154: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please refer to the parameters section for mandatory parameters for this
155: test');
156: statusStr := 'FAILURE';
157: --errStr := 'Some of the Required inputs are missing';
158: --fixInfo := 'Please rerun the Diagnostics using either Purchase order number or Receipt number ';

Line 179: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('No Data exists for the entered combination.');

175: and order_number = l_rma_number;
176: EXCEPTION
177: WHEN No_Data_Found THEN
178: statusStr := 'FAILURE';
179: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('No Data exists for the entered combination.');
180: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please enter valid RMA number and Operating unit id');
181: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
182: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
183: RETURN;

Line 180: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please enter valid RMA number and Operating unit id');

176: EXCEPTION
177: WHEN No_Data_Found THEN
178: statusStr := 'FAILURE';
179: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('No Data exists for the entered combination.');
180: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please enter valid RMA number and Operating unit id');
181: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
182: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
183: RETURN;
184: skip_execution := 1;

Line 198: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('No Data exists for the entered combination.');

194: and ship_to_org_id = l_org_id;
195: EXCEPTION
196: WHEN No_Data_Found THEN
197: statusStr := 'FAILURE';
198: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('No Data exists for the entered combination.');
199: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please enter valid Receipt number and Organization id');
200: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
201: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
202: RETURN;

Line 199: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please enter valid Receipt number and Organization id');

195: EXCEPTION
196: WHEN No_Data_Found THEN
197: statusStr := 'FAILURE';
198: JTF_DIAGNOSTIC_COREAPI.ErrorPrint('No Data exists for the entered combination.');
199: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please enter valid Receipt number and Organization id');
200: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
201: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
202: RETURN;
203: skip_execution := 1;

Line 240: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;

236:
237: INV_DIAG_RCV_RCV_COMMON.build_lookup_codes(rma1_sql);
238: END IF;
239:
240: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
241:
242: JTF_DIAGNOSTIC_COREAPI.insert_html(''||'
243: '||'
244: '||'

Line 242: JTF_DIAGNOSTIC_COREAPI.insert_html('

INDEX OF QUERIES

'||'

238: END IF;
239:
240: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
241:
242: JTF_DIAGNOSTIC_COREAPI.insert_html('

'||'
243: '||'
244: '||'
245: '||'
246: '||'

Line 306: JTF_DIAGNOSTIC_COREAPI.insert_html('

RMA Information

');

302:
303:
304: IF skip_execution <> 1 THEN
305:
306: JTF_DIAGNOSTIC_COREAPI.insert_html('

RMA Information

');
307:
308: sql_text := rma1_sql(1);
309: JTF_DIAGNOSTIC_COREAPI.insert_html('');
310: JTF_DIAGNOSTIC_COREAPI.insert_html('OE_ORDER_HEADERS_ALL  [Top]');

Line 309: JTF_DIAGNOSTIC_COREAPI.insert_html('');

305:
306: JTF_DIAGNOSTIC_COREAPI.insert_html('

RMA Information

');
307:
308: sql_text := rma1_sql(1);
309: JTF_DIAGNOSTIC_COREAPI.insert_html('');
310: JTF_DIAGNOSTIC_COREAPI.insert_html('OE_ORDER_HEADERS_ALL  [Top]');
311: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
312: JTF_DIAGNOSTIC_COREAPI.BRPrint;
313:

Line 310: JTF_DIAGNOSTIC_COREAPI.insert_html('OE_ORDER_HEADERS_ALL  [Top]');

306: JTF_DIAGNOSTIC_COREAPI.insert_html('

RMA Information

');
307:
308: sql_text := rma1_sql(1);
309: JTF_DIAGNOSTIC_COREAPI.insert_html('');
310: JTF_DIAGNOSTIC_COREAPI.insert_html('OE_ORDER_HEADERS_ALL  [Top]');
311: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
312: JTF_DIAGNOSTIC_COREAPI.BRPrint;
313:
314: sql_text := rma1_sql(2);

Line 311: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');

307:
308: sql_text := rma1_sql(1);
309: JTF_DIAGNOSTIC_COREAPI.insert_html('');
310: JTF_DIAGNOSTIC_COREAPI.insert_html('OE_ORDER_HEADERS_ALL  [Top]');
311: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
312: JTF_DIAGNOSTIC_COREAPI.BRPrint;
313:
314: sql_text := rma1_sql(2);
315: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 312: JTF_DIAGNOSTIC_COREAPI.BRPrint;

308: sql_text := rma1_sql(1);
309: JTF_DIAGNOSTIC_COREAPI.insert_html('');
310: JTF_DIAGNOSTIC_COREAPI.insert_html('OE_ORDER_HEADERS_ALL  [Top]');
311: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
312: JTF_DIAGNOSTIC_COREAPI.BRPrint;
313:
314: sql_text := rma1_sql(2);
315: JTF_DIAGNOSTIC_COREAPI.insert_html('');
316: JTF_DIAGNOSTIC_COREAPI.insert_html('OE_ORDER_LINES_ALL  [Top]');

Line 315: JTF_DIAGNOSTIC_COREAPI.insert_html('');

311: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
312: JTF_DIAGNOSTIC_COREAPI.BRPrint;
313:
314: sql_text := rma1_sql(2);
315: JTF_DIAGNOSTIC_COREAPI.insert_html('');
316: JTF_DIAGNOSTIC_COREAPI.insert_html('OE_ORDER_LINES_ALL  [Top]');
317: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
318: JTF_DIAGNOSTIC_COREAPI.BRPrint;
319:

Line 316: JTF_DIAGNOSTIC_COREAPI.insert_html('OE_ORDER_LINES_ALL  [Top]');

312: JTF_DIAGNOSTIC_COREAPI.BRPrint;
313:
314: sql_text := rma1_sql(2);
315: JTF_DIAGNOSTIC_COREAPI.insert_html('');
316: JTF_DIAGNOSTIC_COREAPI.insert_html('OE_ORDER_LINES_ALL  [Top]');
317: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
318: JTF_DIAGNOSTIC_COREAPI.BRPrint;
319:
320:

Line 317: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');

313:
314: sql_text := rma1_sql(2);
315: JTF_DIAGNOSTIC_COREAPI.insert_html('');
316: JTF_DIAGNOSTIC_COREAPI.insert_html('OE_ORDER_LINES_ALL  [Top]');
317: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
318: JTF_DIAGNOSTIC_COREAPI.BRPrint;
319:
320:
321: sql_text := rma1_sql(3);

Line 318: JTF_DIAGNOSTIC_COREAPI.BRPrint;

314: sql_text := rma1_sql(2);
315: JTF_DIAGNOSTIC_COREAPI.insert_html('');
316: JTF_DIAGNOSTIC_COREAPI.insert_html('OE_ORDER_LINES_ALL  [Top]');
317: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
318: JTF_DIAGNOSTIC_COREAPI.BRPrint;
319:
320:
321: sql_text := rma1_sql(3);
322: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 322: JTF_DIAGNOSTIC_COREAPI.insert_html('');

318: JTF_DIAGNOSTIC_COREAPI.BRPrint;
319:
320:
321: sql_text := rma1_sql(3);
322: JTF_DIAGNOSTIC_COREAPI.insert_html('');
323: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SYSTEM_ITEMS  [Top]');
324: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
325: JTF_DIAGNOSTIC_COREAPI.BRPrint;
326:

Line 323: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SYSTEM_ITEMS  [Top]');

319:
320:
321: sql_text := rma1_sql(3);
322: JTF_DIAGNOSTIC_COREAPI.insert_html('');
323: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SYSTEM_ITEMS  [Top]');
324: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
325: JTF_DIAGNOSTIC_COREAPI.BRPrint;
326:
327: JTF_DIAGNOSTIC_COREAPI.insert_html('

Receipt Information

');

Line 324: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');

320:
321: sql_text := rma1_sql(3);
322: JTF_DIAGNOSTIC_COREAPI.insert_html('');
323: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SYSTEM_ITEMS  [Top]');
324: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
325: JTF_DIAGNOSTIC_COREAPI.BRPrint;
326:
327: JTF_DIAGNOSTIC_COREAPI.insert_html('

Receipt Information

');
328:

Line 325: JTF_DIAGNOSTIC_COREAPI.BRPrint;

321: sql_text := rma1_sql(3);
322: JTF_DIAGNOSTIC_COREAPI.insert_html('');
323: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SYSTEM_ITEMS  [Top]');
324: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
325: JTF_DIAGNOSTIC_COREAPI.BRPrint;
326:
327: JTF_DIAGNOSTIC_COREAPI.insert_html('

Receipt Information

');
328:
329: sql_text := rma1_sql(4);

Line 327: JTF_DIAGNOSTIC_COREAPI.insert_html('

Receipt Information

');

323: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SYSTEM_ITEMS  [Top]');
324: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
325: JTF_DIAGNOSTIC_COREAPI.BRPrint;
326:
327: JTF_DIAGNOSTIC_COREAPI.insert_html('

Receipt Information

');
328:
329: sql_text := rma1_sql(4);
330: JTF_DIAGNOSTIC_COREAPI.insert_html('');
331: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SHIPMENT_HEADERS  [Top]');

Line 330: JTF_DIAGNOSTIC_COREAPI.insert_html('');

326:
327: JTF_DIAGNOSTIC_COREAPI.insert_html('

Receipt Information

');
328:
329: sql_text := rma1_sql(4);
330: JTF_DIAGNOSTIC_COREAPI.insert_html('');
331: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SHIPMENT_HEADERS  [Top]');
332: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
333: JTF_DIAGNOSTIC_COREAPI.BRPrint;
334:

Line 331: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SHIPMENT_HEADERS  [Top]');

327: JTF_DIAGNOSTIC_COREAPI.insert_html('

Receipt Information

');
328:
329: sql_text := rma1_sql(4);
330: JTF_DIAGNOSTIC_COREAPI.insert_html('');
331: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SHIPMENT_HEADERS  [Top]');
332: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
333: JTF_DIAGNOSTIC_COREAPI.BRPrint;
334:
335: sql_text := rma1_sql(5);

Line 332: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');

328:
329: sql_text := rma1_sql(4);
330: JTF_DIAGNOSTIC_COREAPI.insert_html('');
331: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SHIPMENT_HEADERS  [Top]');
332: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
333: JTF_DIAGNOSTIC_COREAPI.BRPrint;
334:
335: sql_text := rma1_sql(5);
336: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 333: JTF_DIAGNOSTIC_COREAPI.BRPrint;

329: sql_text := rma1_sql(4);
330: JTF_DIAGNOSTIC_COREAPI.insert_html('');
331: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SHIPMENT_HEADERS  [Top]');
332: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
333: JTF_DIAGNOSTIC_COREAPI.BRPrint;
334:
335: sql_text := rma1_sql(5);
336: JTF_DIAGNOSTIC_COREAPI.insert_html('');
337: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SHIPMENT_LINES  [Top]');

Line 336: JTF_DIAGNOSTIC_COREAPI.insert_html('');

332: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
333: JTF_DIAGNOSTIC_COREAPI.BRPrint;
334:
335: sql_text := rma1_sql(5);
336: JTF_DIAGNOSTIC_COREAPI.insert_html('');
337: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SHIPMENT_LINES  [Top]');
338: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
339: JTF_DIAGNOSTIC_COREAPI.BRPrint;
340:

Line 337: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SHIPMENT_LINES  [Top]');

333: JTF_DIAGNOSTIC_COREAPI.BRPrint;
334:
335: sql_text := rma1_sql(5);
336: JTF_DIAGNOSTIC_COREAPI.insert_html('');
337: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SHIPMENT_LINES  [Top]');
338: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
339: JTF_DIAGNOSTIC_COREAPI.BRPrint;
340:
341: sql_text:= rma1_sql(6);

Line 338: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');

334:
335: sql_text := rma1_sql(5);
336: JTF_DIAGNOSTIC_COREAPI.insert_html('');
337: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SHIPMENT_LINES  [Top]');
338: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
339: JTF_DIAGNOSTIC_COREAPI.BRPrint;
340:
341: sql_text:= rma1_sql(6);
342: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 339: JTF_DIAGNOSTIC_COREAPI.BRPrint;

335: sql_text := rma1_sql(5);
336: JTF_DIAGNOSTIC_COREAPI.insert_html('');
337: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SHIPMENT_LINES  [Top]');
338: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
339: JTF_DIAGNOSTIC_COREAPI.BRPrint;
340:
341: sql_text:= rma1_sql(6);
342: JTF_DIAGNOSTIC_COREAPI.insert_html('');
343: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_TRANSACTIONS  [Top]');

Line 342: JTF_DIAGNOSTIC_COREAPI.insert_html('');

338: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
339: JTF_DIAGNOSTIC_COREAPI.BRPrint;
340:
341: sql_text:= rma1_sql(6);
342: JTF_DIAGNOSTIC_COREAPI.insert_html('');
343: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_TRANSACTIONS  [Top]');
344: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
345: JTF_DIAGNOSTIC_COREAPI.BRPrint;
346:

Line 343: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_TRANSACTIONS  [Top]');

339: JTF_DIAGNOSTIC_COREAPI.BRPrint;
340:
341: sql_text:= rma1_sql(6);
342: JTF_DIAGNOSTIC_COREAPI.insert_html('');
343: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_TRANSACTIONS  [Top]');
344: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
345: JTF_DIAGNOSTIC_COREAPI.BRPrint;
346:
347: sql_text := rma1_sql(7);

Line 344: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');

340:
341: sql_text:= rma1_sql(6);
342: JTF_DIAGNOSTIC_COREAPI.insert_html('');
343: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_TRANSACTIONS  [Top]');
344: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
345: JTF_DIAGNOSTIC_COREAPI.BRPrint;
346:
347: sql_text := rma1_sql(7);
348: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 345: JTF_DIAGNOSTIC_COREAPI.BRPrint;

341: sql_text:= rma1_sql(6);
342: JTF_DIAGNOSTIC_COREAPI.insert_html('');
343: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_TRANSACTIONS  [Top]');
344: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
345: JTF_DIAGNOSTIC_COREAPI.BRPrint;
346:
347: sql_text := rma1_sql(7);
348: JTF_DIAGNOSTIC_COREAPI.insert_html('');
349: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_HEADERS_INTERFACE  [Top]');

Line 348: JTF_DIAGNOSTIC_COREAPI.insert_html('');

344: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
345: JTF_DIAGNOSTIC_COREAPI.BRPrint;
346:
347: sql_text := rma1_sql(7);
348: JTF_DIAGNOSTIC_COREAPI.insert_html('');
349: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_HEADERS_INTERFACE  [Top]');
350: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
351: JTF_DIAGNOSTIC_COREAPI.BRPrint;
352:

Line 349: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_HEADERS_INTERFACE  [Top]');

345: JTF_DIAGNOSTIC_COREAPI.BRPrint;
346:
347: sql_text := rma1_sql(7);
348: JTF_DIAGNOSTIC_COREAPI.insert_html('');
349: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_HEADERS_INTERFACE  [Top]');
350: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
351: JTF_DIAGNOSTIC_COREAPI.BRPrint;
352:
353: sql_text := rma1_sql(8);

Line 350: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');

346:
347: sql_text := rma1_sql(7);
348: JTF_DIAGNOSTIC_COREAPI.insert_html('');
349: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_HEADERS_INTERFACE  [Top]');
350: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
351: JTF_DIAGNOSTIC_COREAPI.BRPrint;
352:
353: sql_text := rma1_sql(8);
354: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 351: JTF_DIAGNOSTIC_COREAPI.BRPrint;

347: sql_text := rma1_sql(7);
348: JTF_DIAGNOSTIC_COREAPI.insert_html('');
349: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_HEADERS_INTERFACE  [Top]');
350: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
351: JTF_DIAGNOSTIC_COREAPI.BRPrint;
352:
353: sql_text := rma1_sql(8);
354: JTF_DIAGNOSTIC_COREAPI.insert_html('');
355: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_TRANSACTIONS_INTERFACE  ');

350: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
351: JTF_DIAGNOSTIC_COREAPI.BRPrint;
352:
353: sql_text := rma1_sql(8);
354: JTF_DIAGNOSTIC_COREAPI.insert_html('');
355: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_TRANSACTIONS_INTERFACE  [Top]');
357: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
358: JTF_DIAGNOSTIC_COREAPI.BRPrint;

Line 355: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_TRANSACTIONS_INTERFACE  ');
355: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_TRANSACTIONS_INTERFACE  [Top]');
357: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
358: JTF_DIAGNOSTIC_COREAPI.BRPrint;
359:

Line 357: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');

353: sql_text := rma1_sql(8);
354: JTF_DIAGNOSTIC_COREAPI.insert_html('');
355: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_TRANSACTIONS_INTERFACE  [Top]');
357: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
358: JTF_DIAGNOSTIC_COREAPI.BRPrint;
359:
360: sql_text := rma1_sql(9);
361: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 358: JTF_DIAGNOSTIC_COREAPI.BRPrint;

354: JTF_DIAGNOSTIC_COREAPI.insert_html('');
355: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_TRANSACTIONS_INTERFACE  [Top]');
357: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
358: JTF_DIAGNOSTIC_COREAPI.BRPrint;
359:
360: sql_text := rma1_sql(9);
361: JTF_DIAGNOSTIC_COREAPI.insert_html('');
362: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_INTERFACE_ERRORS  [Top]');

Line 361: JTF_DIAGNOSTIC_COREAPI.insert_html('');

357: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
358: JTF_DIAGNOSTIC_COREAPI.BRPrint;
359:
360: sql_text := rma1_sql(9);
361: JTF_DIAGNOSTIC_COREAPI.insert_html('');
362: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_INTERFACE_ERRORS  [Top]');
363: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
364: JTF_DIAGNOSTIC_COREAPI.BRPrint;
365:

Line 362: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_INTERFACE_ERRORS  [Top]');

358: JTF_DIAGNOSTIC_COREAPI.BRPrint;
359:
360: sql_text := rma1_sql(9);
361: JTF_DIAGNOSTIC_COREAPI.insert_html('');
362: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_INTERFACE_ERRORS  [Top]');
363: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
364: JTF_DIAGNOSTIC_COREAPI.BRPrint;
365:
366: JTF_DIAGNOSTIC_COREAPI.insert_html('

Inventory Information

');

Line 363: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');

359:
360: sql_text := rma1_sql(9);
361: JTF_DIAGNOSTIC_COREAPI.insert_html('');
362: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_INTERFACE_ERRORS  [Top]');
363: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
364: JTF_DIAGNOSTIC_COREAPI.BRPrint;
365:
366: JTF_DIAGNOSTIC_COREAPI.insert_html('

Inventory Information

');
367:

Line 364: JTF_DIAGNOSTIC_COREAPI.BRPrint;

360: sql_text := rma1_sql(9);
361: JTF_DIAGNOSTIC_COREAPI.insert_html('');
362: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_INTERFACE_ERRORS  [Top]');
363: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
364: JTF_DIAGNOSTIC_COREAPI.BRPrint;
365:
366: JTF_DIAGNOSTIC_COREAPI.insert_html('

Inventory Information

');
367:
368: sql_text:= rma1_sql(10);

Line 366: JTF_DIAGNOSTIC_COREAPI.insert_html('

Inventory Information

');

362: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_INTERFACE_ERRORS  [Top]');
363: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
364: JTF_DIAGNOSTIC_COREAPI.BRPrint;
365:
366: JTF_DIAGNOSTIC_COREAPI.insert_html('

Inventory Information

');
367:
368: sql_text:= rma1_sql(10);
369: JTF_DIAGNOSTIC_COREAPI.insert_html('');
370: JTF_DIAGNOSTIC_COREAPI.insert_html('ORG_ORG_DEFINITIONS  [Top]');

Line 369: JTF_DIAGNOSTIC_COREAPI.insert_html('');

365:
366: JTF_DIAGNOSTIC_COREAPI.insert_html('

Inventory Information

');
367:
368: sql_text:= rma1_sql(10);
369: JTF_DIAGNOSTIC_COREAPI.insert_html('');
370: JTF_DIAGNOSTIC_COREAPI.insert_html('ORG_ORG_DEFINITIONS  [Top]');
371: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
372: JTF_DIAGNOSTIC_COREAPI.BRPrint;
373:

Line 370: JTF_DIAGNOSTIC_COREAPI.insert_html('ORG_ORG_DEFINITIONS  [Top]');

366: JTF_DIAGNOSTIC_COREAPI.insert_html('

Inventory Information

');
367:
368: sql_text:= rma1_sql(10);
369: JTF_DIAGNOSTIC_COREAPI.insert_html('');
370: JTF_DIAGNOSTIC_COREAPI.insert_html('ORG_ORG_DEFINITIONS  [Top]');
371: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
372: JTF_DIAGNOSTIC_COREAPI.BRPrint;
373:
374: sql_text:= rma1_sql(11);

Line 371: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');

367:
368: sql_text:= rma1_sql(10);
369: JTF_DIAGNOSTIC_COREAPI.insert_html('');
370: JTF_DIAGNOSTIC_COREAPI.insert_html('ORG_ORG_DEFINITIONS  [Top]');
371: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
372: JTF_DIAGNOSTIC_COREAPI.BRPrint;
373:
374: sql_text:= rma1_sql(11);
375: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 372: JTF_DIAGNOSTIC_COREAPI.BRPrint;

368: sql_text:= rma1_sql(10);
369: JTF_DIAGNOSTIC_COREAPI.insert_html('');
370: JTF_DIAGNOSTIC_COREAPI.insert_html('ORG_ORG_DEFINITIONS  [Top]');
371: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
372: JTF_DIAGNOSTIC_COREAPI.BRPrint;
373:
374: sql_text:= rma1_sql(11);
375: JTF_DIAGNOSTIC_COREAPI.insert_html('');
376: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_PARAMETERS  [Top]');

Line 375: JTF_DIAGNOSTIC_COREAPI.insert_html('');

371: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
372: JTF_DIAGNOSTIC_COREAPI.BRPrint;
373:
374: sql_text:= rma1_sql(11);
375: JTF_DIAGNOSTIC_COREAPI.insert_html('');
376: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_PARAMETERS  [Top]');
377: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
378: JTF_DIAGNOSTIC_COREAPI.BRPrint;
379:

Line 376: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_PARAMETERS  [Top]');

372: JTF_DIAGNOSTIC_COREAPI.BRPrint;
373:
374: sql_text:= rma1_sql(11);
375: JTF_DIAGNOSTIC_COREAPI.insert_html('');
376: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_PARAMETERS  [Top]');
377: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
378: JTF_DIAGNOSTIC_COREAPI.BRPrint;
379:
380: sql_text:= rma1_sql(12);

Line 377: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');

373:
374: sql_text:= rma1_sql(11);
375: JTF_DIAGNOSTIC_COREAPI.insert_html('');
376: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_PARAMETERS  [Top]');
377: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
378: JTF_DIAGNOSTIC_COREAPI.BRPrint;
379:
380: sql_text:= rma1_sql(12);
381: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 378: JTF_DIAGNOSTIC_COREAPI.BRPrint;

374: sql_text:= rma1_sql(11);
375: JTF_DIAGNOSTIC_COREAPI.insert_html('');
376: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_PARAMETERS  [Top]');
377: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
378: JTF_DIAGNOSTIC_COREAPI.BRPrint;
379:
380: sql_text:= rma1_sql(12);
381: JTF_DIAGNOSTIC_COREAPI.insert_html('');
382: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_MATERIAL_TRANSACTIONS  [Top]');

Line 381: JTF_DIAGNOSTIC_COREAPI.insert_html('');

377: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
378: JTF_DIAGNOSTIC_COREAPI.BRPrint;
379:
380: sql_text:= rma1_sql(12);
381: JTF_DIAGNOSTIC_COREAPI.insert_html('');
382: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_MATERIAL_TRANSACTIONS  [Top]');
383: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
384: JTF_DIAGNOSTIC_COREAPI.BRPrint;
385:

Line 382: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_MATERIAL_TRANSACTIONS  [Top]');

378: JTF_DIAGNOSTIC_COREAPI.BRPrint;
379:
380: sql_text:= rma1_sql(12);
381: JTF_DIAGNOSTIC_COREAPI.insert_html('');
382: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_MATERIAL_TRANSACTIONS  [Top]');
383: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
384: JTF_DIAGNOSTIC_COREAPI.BRPrint;
385:
386: sql_text:= rma1_sql(13);

Line 383: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');

379:
380: sql_text:= rma1_sql(12);
381: JTF_DIAGNOSTIC_COREAPI.insert_html('');
382: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_MATERIAL_TRANSACTIONS  [Top]');
383: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
384: JTF_DIAGNOSTIC_COREAPI.BRPrint;
385:
386: sql_text:= rma1_sql(13);
387: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 384: JTF_DIAGNOSTIC_COREAPI.BRPrint;

380: sql_text:= rma1_sql(12);
381: JTF_DIAGNOSTIC_COREAPI.insert_html('');
382: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_MATERIAL_TRANSACTIONS  [Top]');
383: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
384: JTF_DIAGNOSTIC_COREAPI.BRPrint;
385:
386: sql_text:= rma1_sql(13);
387: JTF_DIAGNOSTIC_COREAPI.insert_html('');
388: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_TYPES  [Top]');

Line 387: JTF_DIAGNOSTIC_COREAPI.insert_html('');

383: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
384: JTF_DIAGNOSTIC_COREAPI.BRPrint;
385:
386: sql_text:= rma1_sql(13);
387: JTF_DIAGNOSTIC_COREAPI.insert_html('');
388: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_TYPES  [Top]');
389: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
390: JTF_DIAGNOSTIC_COREAPI.BRPrint;
391:

Line 388: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_TYPES  [Top]');

384: JTF_DIAGNOSTIC_COREAPI.BRPrint;
385:
386: sql_text:= rma1_sql(13);
387: JTF_DIAGNOSTIC_COREAPI.insert_html('');
388: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_TYPES  [Top]');
389: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
390: JTF_DIAGNOSTIC_COREAPI.BRPrint;
391:
392: sql_text:= rma1_sql(14);

Line 389: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');

385:
386: sql_text:= rma1_sql(13);
387: JTF_DIAGNOSTIC_COREAPI.insert_html('');
388: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_TYPES  [Top]');
389: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
390: JTF_DIAGNOSTIC_COREAPI.BRPrint;
391:
392: sql_text:= rma1_sql(14);
393: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 390: JTF_DIAGNOSTIC_COREAPI.BRPrint;

386: sql_text:= rma1_sql(13);
387: JTF_DIAGNOSTIC_COREAPI.insert_html('');
388: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_TYPES  [Top]');
389: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
390: JTF_DIAGNOSTIC_COREAPI.BRPrint;
391:
392: sql_text:= rma1_sql(14);
393: JTF_DIAGNOSTIC_COREAPI.insert_html('');
394: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_REQUEST_LINES  ');

389: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
390: JTF_DIAGNOSTIC_COREAPI.BRPrint;
391:
392: sql_text:= rma1_sql(14);
393: JTF_DIAGNOSTIC_COREAPI.insert_html('');
394: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_REQUEST_LINES  [Top]');
396: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
397: JTF_DIAGNOSTIC_COREAPI.BRPrint;

Line 394: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_REQUEST_LINES  ');
394: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_REQUEST_LINES  [Top]');
396: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
397: JTF_DIAGNOSTIC_COREAPI.BRPrint;
398:

Line 396: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');

392: sql_text:= rma1_sql(14);
393: JTF_DIAGNOSTIC_COREAPI.insert_html('');
394: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_REQUEST_LINES  [Top]');
396: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
397: JTF_DIAGNOSTIC_COREAPI.BRPrint;
398:
399: sql_text:= rma1_sql(15);
400: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 397: JTF_DIAGNOSTIC_COREAPI.BRPrint;

393: JTF_DIAGNOSTIC_COREAPI.insert_html('');
394: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_REQUEST_LINES  [Top]');
396: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
397: JTF_DIAGNOSTIC_COREAPI.BRPrint;
398:
399: sql_text:= rma1_sql(15);
400: JTF_DIAGNOSTIC_COREAPI.insert_html('');
401: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_MATERIAL_TRANSACTIONS_TEMP  ');

396: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
397: JTF_DIAGNOSTIC_COREAPI.BRPrint;
398:
399: sql_text:= rma1_sql(15);
400: JTF_DIAGNOSTIC_COREAPI.insert_html('');
401: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_MATERIAL_TRANSACTIONS_TEMP  [Top]');
403: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
404: JTF_DIAGNOSTIC_COREAPI.BRPrint;

Line 401: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_MATERIAL_TRANSACTIONS_TEMP  ');
401: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_MATERIAL_TRANSACTIONS_TEMP  [Top]');
403: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
404: JTF_DIAGNOSTIC_COREAPI.BRPrint;
405:

Line 403: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');

399: sql_text:= rma1_sql(15);
400: JTF_DIAGNOSTIC_COREAPI.insert_html('');
401: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_MATERIAL_TRANSACTIONS_TEMP  [Top]');
403: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
404: JTF_DIAGNOSTIC_COREAPI.BRPrint;
405:
406: sql_text:= rma1_sql(16);
407: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 404: JTF_DIAGNOSTIC_COREAPI.BRPrint;

400: JTF_DIAGNOSTIC_COREAPI.insert_html('');
401: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_MATERIAL_TRANSACTIONS_TEMP  [Top]');
403: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
404: JTF_DIAGNOSTIC_COREAPI.BRPrint;
405:
406: sql_text:= rma1_sql(16);
407: JTF_DIAGNOSTIC_COREAPI.insert_html('');
408: JTF_DIAGNOSTIC_COREAPI.insert_html('OE_LOT_SERIAL_NUMBERS  [Top]');

Line 407: JTF_DIAGNOSTIC_COREAPI.insert_html('');

403: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
404: JTF_DIAGNOSTIC_COREAPI.BRPrint;
405:
406: sql_text:= rma1_sql(16);
407: JTF_DIAGNOSTIC_COREAPI.insert_html('');
408: JTF_DIAGNOSTIC_COREAPI.insert_html('OE_LOT_SERIAL_NUMBERS  [Top]');
409: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
410: JTF_DIAGNOSTIC_COREAPI.BRPrint;
411:

Line 408: JTF_DIAGNOSTIC_COREAPI.insert_html('OE_LOT_SERIAL_NUMBERS  [Top]');

404: JTF_DIAGNOSTIC_COREAPI.BRPrint;
405:
406: sql_text:= rma1_sql(16);
407: JTF_DIAGNOSTIC_COREAPI.insert_html('');
408: JTF_DIAGNOSTIC_COREAPI.insert_html('OE_LOT_SERIAL_NUMBERS  [Top]');
409: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
410: JTF_DIAGNOSTIC_COREAPI.BRPrint;
411:
412: sql_text:= rma1_sql(17);

Line 409: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');

405:
406: sql_text:= rma1_sql(16);
407: JTF_DIAGNOSTIC_COREAPI.insert_html('');
408: JTF_DIAGNOSTIC_COREAPI.insert_html('OE_LOT_SERIAL_NUMBERS  [Top]');
409: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
410: JTF_DIAGNOSTIC_COREAPI.BRPrint;
411:
412: sql_text:= rma1_sql(17);
413: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 410: JTF_DIAGNOSTIC_COREAPI.BRPrint;

406: sql_text:= rma1_sql(16);
407: JTF_DIAGNOSTIC_COREAPI.insert_html('');
408: JTF_DIAGNOSTIC_COREAPI.insert_html('OE_LOT_SERIAL_NUMBERS  [Top]');
409: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
410: JTF_DIAGNOSTIC_COREAPI.BRPrint;
411:
412: sql_text:= rma1_sql(17);
413: JTF_DIAGNOSTIC_COREAPI.insert_html('');
414: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SERIAL_NUMBERS  [Top]');

Line 413: JTF_DIAGNOSTIC_COREAPI.insert_html('');

409: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
410: JTF_DIAGNOSTIC_COREAPI.BRPrint;
411:
412: sql_text:= rma1_sql(17);
413: JTF_DIAGNOSTIC_COREAPI.insert_html('');
414: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SERIAL_NUMBERS  [Top]');
415: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
416: JTF_DIAGNOSTIC_COREAPI.BRPrint;
417:

Line 414: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SERIAL_NUMBERS  [Top]');

410: JTF_DIAGNOSTIC_COREAPI.BRPrint;
411:
412: sql_text:= rma1_sql(17);
413: JTF_DIAGNOSTIC_COREAPI.insert_html('');
414: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SERIAL_NUMBERS  [Top]');
415: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
416: JTF_DIAGNOSTIC_COREAPI.BRPrint;
417:
418: sql_text:= rma1_sql(18);

Line 415: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');

411:
412: sql_text:= rma1_sql(17);
413: JTF_DIAGNOSTIC_COREAPI.insert_html('');
414: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SERIAL_NUMBERS  [Top]');
415: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
416: JTF_DIAGNOSTIC_COREAPI.BRPrint;
417:
418: sql_text:= rma1_sql(18);
419: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 416: JTF_DIAGNOSTIC_COREAPI.BRPrint;

412: sql_text:= rma1_sql(17);
413: JTF_DIAGNOSTIC_COREAPI.insert_html('');
414: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SERIAL_NUMBERS  [Top]');
415: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
416: JTF_DIAGNOSTIC_COREAPI.BRPrint;
417:
418: sql_text:= rma1_sql(18);
419: JTF_DIAGNOSTIC_COREAPI.insert_html('');
420: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SERIAL_NUMBERS_TEMP  [Top]');

Line 419: JTF_DIAGNOSTIC_COREAPI.insert_html('');

415: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
416: JTF_DIAGNOSTIC_COREAPI.BRPrint;
417:
418: sql_text:= rma1_sql(18);
419: JTF_DIAGNOSTIC_COREAPI.insert_html('');
420: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SERIAL_NUMBERS_TEMP  [Top]');
421: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
422: JTF_DIAGNOSTIC_COREAPI.BRPrint;
423:

Line 420: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SERIAL_NUMBERS_TEMP  [Top]');

416: JTF_DIAGNOSTIC_COREAPI.BRPrint;
417:
418: sql_text:= rma1_sql(18);
419: JTF_DIAGNOSTIC_COREAPI.insert_html('');
420: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SERIAL_NUMBERS_TEMP  [Top]');
421: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
422: JTF_DIAGNOSTIC_COREAPI.BRPrint;
423:
424: sql_text:= rma1_sql(19);

Line 421: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');

417:
418: sql_text:= rma1_sql(18);
419: JTF_DIAGNOSTIC_COREAPI.insert_html('');
420: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SERIAL_NUMBERS_TEMP  [Top]');
421: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
422: JTF_DIAGNOSTIC_COREAPI.BRPrint;
423:
424: sql_text:= rma1_sql(19);
425: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 422: JTF_DIAGNOSTIC_COREAPI.BRPrint;

418: sql_text:= rma1_sql(18);
419: JTF_DIAGNOSTIC_COREAPI.insert_html('');
420: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SERIAL_NUMBERS_TEMP  [Top]');
421: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
422: JTF_DIAGNOSTIC_COREAPI.BRPrint;
423:
424: sql_text:= rma1_sql(19);
425: JTF_DIAGNOSTIC_COREAPI.insert_html('');
426: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SERIAL_NUMBERS_INTERFACE  ');

421: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
422: JTF_DIAGNOSTIC_COREAPI.BRPrint;
423:
424: sql_text:= rma1_sql(19);
425: JTF_DIAGNOSTIC_COREAPI.insert_html('');
426: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SERIAL_NUMBERS_INTERFACE  [Top]');
428: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
429: JTF_DIAGNOSTIC_COREAPI.BRPrint;

Line 426: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SERIAL_NUMBERS_INTERFACE  ');
426: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SERIAL_NUMBERS_INTERFACE  [Top]');
428: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
429: JTF_DIAGNOSTIC_COREAPI.BRPrint;
430:

Line 428: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');

424: sql_text:= rma1_sql(19);
425: JTF_DIAGNOSTIC_COREAPI.insert_html('');
426: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SERIAL_NUMBERS_INTERFACE  [Top]');
428: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
429: JTF_DIAGNOSTIC_COREAPI.BRPrint;
430:
431: sql_text:= rma1_sql(20);
432: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 429: JTF_DIAGNOSTIC_COREAPI.BRPrint;

425: JTF_DIAGNOSTIC_COREAPI.insert_html('');
426: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SERIAL_NUMBERS_INTERFACE  [Top]');
428: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
429: JTF_DIAGNOSTIC_COREAPI.BRPrint;
430:
431: sql_text:= rma1_sql(20);
432: JTF_DIAGNOSTIC_COREAPI.insert_html('');
433: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_UNIT_TRANSACTIONS  [Top]');

Line 432: JTF_DIAGNOSTIC_COREAPI.insert_html('');

428: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
429: JTF_DIAGNOSTIC_COREAPI.BRPrint;
430:
431: sql_text:= rma1_sql(20);
432: JTF_DIAGNOSTIC_COREAPI.insert_html('');
433: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_UNIT_TRANSACTIONS  [Top]');
434: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
435: JTF_DIAGNOSTIC_COREAPI.BRPrint;
436:

Line 433: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_UNIT_TRANSACTIONS  [Top]');

429: JTF_DIAGNOSTIC_COREAPI.BRPrint;
430:
431: sql_text:= rma1_sql(20);
432: JTF_DIAGNOSTIC_COREAPI.insert_html('');
433: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_UNIT_TRANSACTIONS  [Top]');
434: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
435: JTF_DIAGNOSTIC_COREAPI.BRPrint;
436:
437: sql_text:= rma1_sql(21);

Line 434: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');

430:
431: sql_text:= rma1_sql(20);
432: JTF_DIAGNOSTIC_COREAPI.insert_html('');
433: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_UNIT_TRANSACTIONS  [Top]');
434: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
435: JTF_DIAGNOSTIC_COREAPI.BRPrint;
436:
437: sql_text:= rma1_sql(21);
438: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 435: JTF_DIAGNOSTIC_COREAPI.BRPrint;

431: sql_text:= rma1_sql(20);
432: JTF_DIAGNOSTIC_COREAPI.insert_html('');
433: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_UNIT_TRANSACTIONS  [Top]');
434: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
435: JTF_DIAGNOSTIC_COREAPI.BRPrint;
436:
437: sql_text:= rma1_sql(21);
438: JTF_DIAGNOSTIC_COREAPI.insert_html('');
439: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SERIAL_TRANSACTIONS  [Top]');

Line 438: JTF_DIAGNOSTIC_COREAPI.insert_html('');

434: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
435: JTF_DIAGNOSTIC_COREAPI.BRPrint;
436:
437: sql_text:= rma1_sql(21);
438: JTF_DIAGNOSTIC_COREAPI.insert_html('');
439: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SERIAL_TRANSACTIONS  [Top]');
440: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
441: JTF_DIAGNOSTIC_COREAPI.BRPrint;
442:

Line 439: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SERIAL_TRANSACTIONS  [Top]');

435: JTF_DIAGNOSTIC_COREAPI.BRPrint;
436:
437: sql_text:= rma1_sql(21);
438: JTF_DIAGNOSTIC_COREAPI.insert_html('');
439: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SERIAL_TRANSACTIONS  [Top]');
440: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
441: JTF_DIAGNOSTIC_COREAPI.BRPrint;
442:
443: sql_text:= rma1_sql(22);

Line 440: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');

436:
437: sql_text:= rma1_sql(21);
438: JTF_DIAGNOSTIC_COREAPI.insert_html('');
439: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SERIAL_TRANSACTIONS  [Top]');
440: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
441: JTF_DIAGNOSTIC_COREAPI.BRPrint;
442:
443: sql_text:= rma1_sql(22);
444: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 441: JTF_DIAGNOSTIC_COREAPI.BRPrint;

437: sql_text:= rma1_sql(21);
438: JTF_DIAGNOSTIC_COREAPI.insert_html('');
439: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SERIAL_TRANSACTIONS  [Top]');
440: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
441: JTF_DIAGNOSTIC_COREAPI.BRPrint;
442:
443: sql_text:= rma1_sql(22);
444: JTF_DIAGNOSTIC_COREAPI.insert_html('');
445: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SERIAL_INTERFACE  [Top]');

Line 444: JTF_DIAGNOSTIC_COREAPI.insert_html('');

440: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
441: JTF_DIAGNOSTIC_COREAPI.BRPrint;
442:
443: sql_text:= rma1_sql(22);
444: JTF_DIAGNOSTIC_COREAPI.insert_html('');
445: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SERIAL_INTERFACE  [Top]');
446: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
447: JTF_DIAGNOSTIC_COREAPI.BRPrint;
448:

Line 445: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SERIAL_INTERFACE  [Top]');

441: JTF_DIAGNOSTIC_COREAPI.BRPrint;
442:
443: sql_text:= rma1_sql(22);
444: JTF_DIAGNOSTIC_COREAPI.insert_html('');
445: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SERIAL_INTERFACE  [Top]');
446: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
447: JTF_DIAGNOSTIC_COREAPI.BRPrint;
448:
449: sql_text:= rma1_sql(23);

Line 446: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');

442:
443: sql_text:= rma1_sql(22);
444: JTF_DIAGNOSTIC_COREAPI.insert_html('');
445: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SERIAL_INTERFACE  [Top]');
446: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
447: JTF_DIAGNOSTIC_COREAPI.BRPrint;
448:
449: sql_text:= rma1_sql(23);
450: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 447: JTF_DIAGNOSTIC_COREAPI.BRPrint;

443: sql_text:= rma1_sql(22);
444: JTF_DIAGNOSTIC_COREAPI.insert_html('');
445: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SERIAL_INTERFACE  [Top]');
446: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
447: JTF_DIAGNOSTIC_COREAPI.BRPrint;
448:
449: sql_text:= rma1_sql(23);
450: JTF_DIAGNOSTIC_COREAPI.insert_html('');
451: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_LOT_NUMBERS  [Top]');

Line 450: JTF_DIAGNOSTIC_COREAPI.insert_html('');

446: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
447: JTF_DIAGNOSTIC_COREAPI.BRPrint;
448:
449: sql_text:= rma1_sql(23);
450: JTF_DIAGNOSTIC_COREAPI.insert_html('');
451: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_LOT_NUMBERS  [Top]');
452: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
453: JTF_DIAGNOSTIC_COREAPI.BRPrint;
454:

Line 451: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_LOT_NUMBERS  [Top]');

447: JTF_DIAGNOSTIC_COREAPI.BRPrint;
448:
449: sql_text:= rma1_sql(23);
450: JTF_DIAGNOSTIC_COREAPI.insert_html('');
451: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_LOT_NUMBERS  [Top]');
452: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
453: JTF_DIAGNOSTIC_COREAPI.BRPrint;
454:
455: sql_text:= rma1_sql(24);

Line 452: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');

448:
449: sql_text:= rma1_sql(23);
450: JTF_DIAGNOSTIC_COREAPI.insert_html('');
451: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_LOT_NUMBERS  [Top]');
452: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
453: JTF_DIAGNOSTIC_COREAPI.BRPrint;
454:
455: sql_text:= rma1_sql(24);
456: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 453: JTF_DIAGNOSTIC_COREAPI.BRPrint;

449: sql_text:= rma1_sql(23);
450: JTF_DIAGNOSTIC_COREAPI.insert_html('');
451: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_LOT_NUMBERS  [Top]');
452: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
453: JTF_DIAGNOSTIC_COREAPI.BRPrint;
454:
455: sql_text:= rma1_sql(24);
456: JTF_DIAGNOSTIC_COREAPI.insert_html('');
457: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_LOT_NUMBERS  ');

452: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
453: JTF_DIAGNOSTIC_COREAPI.BRPrint;
454:
455: sql_text:= rma1_sql(24);
456: JTF_DIAGNOSTIC_COREAPI.insert_html('');
457: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_LOT_NUMBERS  [Top]');
459: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
460: JTF_DIAGNOSTIC_COREAPI.BRPrint;

Line 457: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_LOT_NUMBERS  ');
457: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_LOT_NUMBERS  [Top]');
459: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
460: JTF_DIAGNOSTIC_COREAPI.BRPrint;
461:

Line 459: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');

455: sql_text:= rma1_sql(24);
456: JTF_DIAGNOSTIC_COREAPI.insert_html('');
457: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_LOT_NUMBERS  [Top]');
459: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
460: JTF_DIAGNOSTIC_COREAPI.BRPrint;
461:
462: sql_text:= rma1_sql(25);
463: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 460: JTF_DIAGNOSTIC_COREAPI.BRPrint;

456: JTF_DIAGNOSTIC_COREAPI.insert_html('');
457: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_LOT_NUMBERS  [Top]');
459: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
460: JTF_DIAGNOSTIC_COREAPI.BRPrint;
461:
462: sql_text:= rma1_sql(25);
463: JTF_DIAGNOSTIC_COREAPI.insert_html('');
464: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_LOT_INTERFACE  ');

459: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
460: JTF_DIAGNOSTIC_COREAPI.BRPrint;
461:
462: sql_text:= rma1_sql(25);
463: JTF_DIAGNOSTIC_COREAPI.insert_html('');
464: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_LOT_INTERFACE  [Top]');
466: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
467: JTF_DIAGNOSTIC_COREAPI.BRPrint;

Line 464: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_LOT_INTERFACE  ');
464: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_LOT_INTERFACE  [Top]');
466: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
467: JTF_DIAGNOSTIC_COREAPI.BRPrint;
468:

Line 466: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');

462: sql_text:= rma1_sql(25);
463: JTF_DIAGNOSTIC_COREAPI.insert_html('');
464: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_LOT_INTERFACE  [Top]');
466: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
467: JTF_DIAGNOSTIC_COREAPI.BRPrint;
468:
469: sql_text:= rma1_sql(26);
470: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 467: JTF_DIAGNOSTIC_COREAPI.BRPrint;

463: JTF_DIAGNOSTIC_COREAPI.insert_html('');
464: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_LOT_INTERFACE  [Top]');
466: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
467: JTF_DIAGNOSTIC_COREAPI.BRPrint;
468:
469: sql_text:= rma1_sql(26);
470: JTF_DIAGNOSTIC_COREAPI.insert_html('');
471: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_LOTS_TEMP  [Top]');

Line 470: JTF_DIAGNOSTIC_COREAPI.insert_html('');

466: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
467: JTF_DIAGNOSTIC_COREAPI.BRPrint;
468:
469: sql_text:= rma1_sql(26);
470: JTF_DIAGNOSTIC_COREAPI.insert_html('');
471: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_LOTS_TEMP  [Top]');
472: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
473: JTF_DIAGNOSTIC_COREAPI.BRPrint;
474:

Line 471: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_LOTS_TEMP  [Top]');

467: JTF_DIAGNOSTIC_COREAPI.BRPrint;
468:
469: sql_text:= rma1_sql(26);
470: JTF_DIAGNOSTIC_COREAPI.insert_html('');
471: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_LOTS_TEMP  [Top]');
472: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
473: JTF_DIAGNOSTIC_COREAPI.BRPrint;
474:
475: sql_text:= rma1_sql(27);

Line 472: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');

468:
469: sql_text:= rma1_sql(26);
470: JTF_DIAGNOSTIC_COREAPI.insert_html('');
471: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_LOTS_TEMP  [Top]');
472: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
473: JTF_DIAGNOSTIC_COREAPI.BRPrint;
474:
475: sql_text:= rma1_sql(27);
476: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 473: JTF_DIAGNOSTIC_COREAPI.BRPrint;

469: sql_text:= rma1_sql(26);
470: JTF_DIAGNOSTIC_COREAPI.insert_html('');
471: JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_LOTS_TEMP  [Top]');
472: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
473: JTF_DIAGNOSTIC_COREAPI.BRPrint;
474:
475: sql_text:= rma1_sql(27);
476: JTF_DIAGNOSTIC_COREAPI.insert_html('');
477: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_LOT_TRANSACTIONS  [Top]');

Line 476: JTF_DIAGNOSTIC_COREAPI.insert_html('');

472: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
473: JTF_DIAGNOSTIC_COREAPI.BRPrint;
474:
475: sql_text:= rma1_sql(27);
476: JTF_DIAGNOSTIC_COREAPI.insert_html('');
477: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_LOT_TRANSACTIONS  [Top]');
478: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
479: JTF_DIAGNOSTIC_COREAPI.BRPrint;
480:

Line 477: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_LOT_TRANSACTIONS  [Top]');

473: JTF_DIAGNOSTIC_COREAPI.BRPrint;
474:
475: sql_text:= rma1_sql(27);
476: JTF_DIAGNOSTIC_COREAPI.insert_html('');
477: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_LOT_TRANSACTIONS  [Top]');
478: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
479: JTF_DIAGNOSTIC_COREAPI.BRPrint;
480:
481: sql_text:= rma1_sql(28);

Line 478: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');

474:
475: sql_text:= rma1_sql(27);
476: JTF_DIAGNOSTIC_COREAPI.insert_html('');
477: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_LOT_TRANSACTIONS  [Top]');
478: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
479: JTF_DIAGNOSTIC_COREAPI.BRPrint;
480:
481: sql_text:= rma1_sql(28);
482: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 479: JTF_DIAGNOSTIC_COREAPI.BRPrint;

475: sql_text:= rma1_sql(27);
476: JTF_DIAGNOSTIC_COREAPI.insert_html('');
477: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_LOT_TRANSACTIONS  [Top]');
478: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
479: JTF_DIAGNOSTIC_COREAPI.BRPrint;
480:
481: sql_text:= rma1_sql(28);
482: JTF_DIAGNOSTIC_COREAPI.insert_html('');
483: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_PARAMETERS  [Top]');

Line 482: JTF_DIAGNOSTIC_COREAPI.insert_html('');

478: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
479: JTF_DIAGNOSTIC_COREAPI.BRPrint;
480:
481: sql_text:= rma1_sql(28);
482: JTF_DIAGNOSTIC_COREAPI.insert_html('');
483: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_PARAMETERS  [Top]');
484: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
485: JTF_DIAGNOSTIC_COREAPI.BRPrint;
486:

Line 483: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_PARAMETERS  [Top]');

479: JTF_DIAGNOSTIC_COREAPI.BRPrint;
480:
481: sql_text:= rma1_sql(28);
482: JTF_DIAGNOSTIC_COREAPI.insert_html('');
483: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_PARAMETERS  [Top]');
484: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
485: JTF_DIAGNOSTIC_COREAPI.BRPrint;
486:
487: sql_text:= rma1_sql(29);

Line 484: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');

480:
481: sql_text:= rma1_sql(28);
482: JTF_DIAGNOSTIC_COREAPI.insert_html('');
483: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_PARAMETERS  [Top]');
484: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
485: JTF_DIAGNOSTIC_COREAPI.BRPrint;
486:
487: sql_text:= rma1_sql(29);
488: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 485: JTF_DIAGNOSTIC_COREAPI.BRPrint;

481: sql_text:= rma1_sql(28);
482: JTF_DIAGNOSTIC_COREAPI.insert_html('');
483: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_PARAMETERS  [Top]');
484: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
485: JTF_DIAGNOSTIC_COREAPI.BRPrint;
486:
487: sql_text:= rma1_sql(29);
488: JTF_DIAGNOSTIC_COREAPI.insert_html('');
489: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_SYSTEM_PARAMETERS_ALL  [Top]');

Line 488: JTF_DIAGNOSTIC_COREAPI.insert_html('');

484: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
485: JTF_DIAGNOSTIC_COREAPI.BRPrint;
486:
487: sql_text:= rma1_sql(29);
488: JTF_DIAGNOSTIC_COREAPI.insert_html('');
489: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_SYSTEM_PARAMETERS_ALL  [Top]');
490: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
491: JTF_DIAGNOSTIC_COREAPI.BRPrint;
492:

Line 489: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_SYSTEM_PARAMETERS_ALL  [Top]');

485: JTF_DIAGNOSTIC_COREAPI.BRPrint;
486:
487: sql_text:= rma1_sql(29);
488: JTF_DIAGNOSTIC_COREAPI.insert_html('');
489: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_SYSTEM_PARAMETERS_ALL  [Top]');
490: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
491: JTF_DIAGNOSTIC_COREAPI.BRPrint;
492:
493: sql_text:= rma1_sql(30);

Line 490: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');

486:
487: sql_text:= rma1_sql(29);
488: JTF_DIAGNOSTIC_COREAPI.insert_html('');
489: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_SYSTEM_PARAMETERS_ALL  [Top]');
490: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
491: JTF_DIAGNOSTIC_COREAPI.BRPrint;
492:
493: sql_text:= rma1_sql(30);
494: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 491: JTF_DIAGNOSTIC_COREAPI.BRPrint;

487: sql_text:= rma1_sql(29);
488: JTF_DIAGNOSTIC_COREAPI.insert_html('');
489: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_SYSTEM_PARAMETERS_ALL  [Top]');
490: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
491: JTF_DIAGNOSTIC_COREAPI.BRPrint;
492:
493: sql_text:= rma1_sql(30);
494: JTF_DIAGNOSTIC_COREAPI.insert_html('');
495: JTF_DIAGNOSTIC_COREAPI.insert_html('FINANCIAL_SYSTEM_PARAMETERS  ');

490: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
491: JTF_DIAGNOSTIC_COREAPI.BRPrint;
492:
493: sql_text:= rma1_sql(30);
494: JTF_DIAGNOSTIC_COREAPI.insert_html('');
495: JTF_DIAGNOSTIC_COREAPI.insert_html('FINANCIAL_SYSTEM_PARAMETERS  [Top]');
497: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
498: JTF_DIAGNOSTIC_COREAPI.BRPrint;

Line 495: JTF_DIAGNOSTIC_COREAPI.insert_html('FINANCIAL_SYSTEM_PARAMETERS  ');
495: JTF_DIAGNOSTIC_COREAPI.insert_html('FINANCIAL_SYSTEM_PARAMETERS  [Top]');
497: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
498: JTF_DIAGNOSTIC_COREAPI.BRPrint;
499:

Line 497: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');

493: sql_text:= rma1_sql(30);
494: JTF_DIAGNOSTIC_COREAPI.insert_html('');
495: JTF_DIAGNOSTIC_COREAPI.insert_html('FINANCIAL_SYSTEM_PARAMETERS  [Top]');
497: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
498: JTF_DIAGNOSTIC_COREAPI.BRPrint;
499:
500: JTF_DIAGNOSTIC_COREAPI.insert_html('');
501: JTF_DIAGNOSTIC_COREAPI.insert_html('

Lookup Codes

');

Line 498: JTF_DIAGNOSTIC_COREAPI.BRPrint;

494: JTF_DIAGNOSTIC_COREAPI.insert_html('');
495: JTF_DIAGNOSTIC_COREAPI.insert_html('FINANCIAL_SYSTEM_PARAMETERS  [Top]');
497: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
498: JTF_DIAGNOSTIC_COREAPI.BRPrint;
499:
500: JTF_DIAGNOSTIC_COREAPI.insert_html('');
501: JTF_DIAGNOSTIC_COREAPI.insert_html('

Lookup Codes

');
502: sql_text:= rma1_sql(100);

Line 500: JTF_DIAGNOSTIC_COREAPI.insert_html('');

496: QUERIES">[Top]');
497: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
498: JTF_DIAGNOSTIC_COREAPI.BRPrint;
499:
500: JTF_DIAGNOSTIC_COREAPI.insert_html('');
501: JTF_DIAGNOSTIC_COREAPI.insert_html('

Lookup Codes

');
502: sql_text:= rma1_sql(100);
503: JTF_DIAGNOSTIC_COREAPI.insert_html('');
504: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Control  [Top]');

Line 501: JTF_DIAGNOSTIC_COREAPI.insert_html('

Lookup Codes

');

497: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
498: JTF_DIAGNOSTIC_COREAPI.BRPrint;
499:
500: JTF_DIAGNOSTIC_COREAPI.insert_html('');
501: JTF_DIAGNOSTIC_COREAPI.insert_html('

Lookup Codes

');
502: sql_text:= rma1_sql(100);
503: JTF_DIAGNOSTIC_COREAPI.insert_html('');
504: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Control  [Top]');
505: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');

Line 503: JTF_DIAGNOSTIC_COREAPI.insert_html('');

499:
500: JTF_DIAGNOSTIC_COREAPI.insert_html('');
501: JTF_DIAGNOSTIC_COREAPI.insert_html('

Lookup Codes

');
502: sql_text:= rma1_sql(100);
503: JTF_DIAGNOSTIC_COREAPI.insert_html('');
504: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Control  [Top]');
505: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
506: JTF_DIAGNOSTIC_COREAPI.BRPrint;
507:

Line 504: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Control  [Top]');

500: JTF_DIAGNOSTIC_COREAPI.insert_html('');
501: JTF_DIAGNOSTIC_COREAPI.insert_html('

Lookup Codes

');
502: sql_text:= rma1_sql(100);
503: JTF_DIAGNOSTIC_COREAPI.insert_html('');
504: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Control  [Top]');
505: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
506: JTF_DIAGNOSTIC_COREAPI.BRPrint;
507:
508: sql_text:= rma1_sql(101);

Line 505: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');

501: JTF_DIAGNOSTIC_COREAPI.insert_html('

Lookup Codes

');
502: sql_text:= rma1_sql(100);
503: JTF_DIAGNOSTIC_COREAPI.insert_html('');
504: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Control  [Top]');
505: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
506: JTF_DIAGNOSTIC_COREAPI.BRPrint;
507:
508: sql_text:= rma1_sql(101);
509: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 506: JTF_DIAGNOSTIC_COREAPI.BRPrint;

502: sql_text:= rma1_sql(100);
503: JTF_DIAGNOSTIC_COREAPI.insert_html('');
504: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Control  [Top]');
505: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
506: JTF_DIAGNOSTIC_COREAPI.BRPrint;
507:
508: sql_text:= rma1_sql(101);
509: JTF_DIAGNOSTIC_COREAPI.insert_html('');
510: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Uniqueness  [Top]');

Line 509: JTF_DIAGNOSTIC_COREAPI.insert_html('');

505: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
506: JTF_DIAGNOSTIC_COREAPI.BRPrint;
507:
508: sql_text:= rma1_sql(101);
509: JTF_DIAGNOSTIC_COREAPI.insert_html('');
510: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Uniqueness  [Top]');
511: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
512: JTF_DIAGNOSTIC_COREAPI.BRPrint;
513:

Line 510: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Uniqueness  [Top]');

506: JTF_DIAGNOSTIC_COREAPI.BRPrint;
507:
508: sql_text:= rma1_sql(101);
509: JTF_DIAGNOSTIC_COREAPI.insert_html('');
510: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Uniqueness  [Top]');
511: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
512: JTF_DIAGNOSTIC_COREAPI.BRPrint;
513:
514: sql_text:= rma1_sql(102);

Line 511: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');

507:
508: sql_text:= rma1_sql(101);
509: JTF_DIAGNOSTIC_COREAPI.insert_html('');
510: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Uniqueness  [Top]');
511: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
512: JTF_DIAGNOSTIC_COREAPI.BRPrint;
513:
514: sql_text:= rma1_sql(102);
515: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 512: JTF_DIAGNOSTIC_COREAPI.BRPrint;

508: sql_text:= rma1_sql(101);
509: JTF_DIAGNOSTIC_COREAPI.insert_html('');
510: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Uniqueness  [Top]');
511: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
512: JTF_DIAGNOSTIC_COREAPI.BRPrint;
513:
514: sql_text:= rma1_sql(102);
515: JTF_DIAGNOSTIC_COREAPI.insert_html('');
516: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Generation  [Top]');

Line 515: JTF_DIAGNOSTIC_COREAPI.insert_html('');

511: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
512: JTF_DIAGNOSTIC_COREAPI.BRPrint;
513:
514: sql_text:= rma1_sql(102);
515: JTF_DIAGNOSTIC_COREAPI.insert_html('');
516: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Generation  [Top]');
517: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
518: JTF_DIAGNOSTIC_COREAPI.BRPrint;
519:

Line 516: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Generation  [Top]');

512: JTF_DIAGNOSTIC_COREAPI.BRPrint;
513:
514: sql_text:= rma1_sql(102);
515: JTF_DIAGNOSTIC_COREAPI.insert_html('');
516: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Generation  [Top]');
517: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
518: JTF_DIAGNOSTIC_COREAPI.BRPrint;
519:
520: sql_text:= rma1_sql(103);

Line 517: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');

513:
514: sql_text:= rma1_sql(102);
515: JTF_DIAGNOSTIC_COREAPI.insert_html('');
516: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Generation  [Top]');
517: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
518: JTF_DIAGNOSTIC_COREAPI.BRPrint;
519:
520: sql_text:= rma1_sql(103);
521: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 518: JTF_DIAGNOSTIC_COREAPI.BRPrint;

514: sql_text:= rma1_sql(102);
515: JTF_DIAGNOSTIC_COREAPI.insert_html('');
516: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Generation  [Top]');
517: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
518: JTF_DIAGNOSTIC_COREAPI.BRPrint;
519:
520: sql_text:= rma1_sql(103);
521: JTF_DIAGNOSTIC_COREAPI.insert_html('');
522: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Number Status  [Top]');

Line 521: JTF_DIAGNOSTIC_COREAPI.insert_html('');

517: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
518: JTF_DIAGNOSTIC_COREAPI.BRPrint;
519:
520: sql_text:= rma1_sql(103);
521: JTF_DIAGNOSTIC_COREAPI.insert_html('');
522: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Number Status  [Top]');
523: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
524: JTF_DIAGNOSTIC_COREAPI.BRPrint;
525:

Line 522: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Number Status  [Top]');

518: JTF_DIAGNOSTIC_COREAPI.BRPrint;
519:
520: sql_text:= rma1_sql(103);
521: JTF_DIAGNOSTIC_COREAPI.insert_html('');
522: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Number Status  [Top]');
523: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
524: JTF_DIAGNOSTIC_COREAPI.BRPrint;
525:
526: sql_text:= rma1_sql(104);

Line 523: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');

519:
520: sql_text:= rma1_sql(103);
521: JTF_DIAGNOSTIC_COREAPI.insert_html('');
522: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Number Status  [Top]');
523: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
524: JTF_DIAGNOSTIC_COREAPI.BRPrint;
525:
526: sql_text:= rma1_sql(104);
527: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 524: JTF_DIAGNOSTIC_COREAPI.BRPrint;

520: sql_text:= rma1_sql(103);
521: JTF_DIAGNOSTIC_COREAPI.insert_html('');
522: JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Number Status  [Top]');
523: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
524: JTF_DIAGNOSTIC_COREAPI.BRPrint;
525:
526: sql_text:= rma1_sql(104);
527: JTF_DIAGNOSTIC_COREAPI.insert_html('');
528: JTF_DIAGNOSTIC_COREAPI.insert_html('Lot Control  [Top]');

Line 527: JTF_DIAGNOSTIC_COREAPI.insert_html('');

523: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
524: JTF_DIAGNOSTIC_COREAPI.BRPrint;
525:
526: sql_text:= rma1_sql(104);
527: JTF_DIAGNOSTIC_COREAPI.insert_html('');
528: JTF_DIAGNOSTIC_COREAPI.insert_html('Lot Control  [Top]');
529: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
530: JTF_DIAGNOSTIC_COREAPI.BRPrint;
531:

Line 528: JTF_DIAGNOSTIC_COREAPI.insert_html('Lot Control  [Top]');

524: JTF_DIAGNOSTIC_COREAPI.BRPrint;
525:
526: sql_text:= rma1_sql(104);
527: JTF_DIAGNOSTIC_COREAPI.insert_html('');
528: JTF_DIAGNOSTIC_COREAPI.insert_html('Lot Control  [Top]');
529: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
530: JTF_DIAGNOSTIC_COREAPI.BRPrint;
531:
532: sql_text:= rma1_sql(105);

Line 529: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');

525:
526: sql_text:= rma1_sql(104);
527: JTF_DIAGNOSTIC_COREAPI.insert_html('');
528: JTF_DIAGNOSTIC_COREAPI.insert_html('Lot Control  [Top]');
529: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
530: JTF_DIAGNOSTIC_COREAPI.BRPrint;
531:
532: sql_text:= rma1_sql(105);
533: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 530: JTF_DIAGNOSTIC_COREAPI.BRPrint;

526: sql_text:= rma1_sql(104);
527: JTF_DIAGNOSTIC_COREAPI.insert_html('');
528: JTF_DIAGNOSTIC_COREAPI.insert_html('Lot Control  [Top]');
529: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
530: JTF_DIAGNOSTIC_COREAPI.BRPrint;
531:
532: sql_text:= rma1_sql(105);
533: JTF_DIAGNOSTIC_COREAPI.insert_html('');
534: JTF_DIAGNOSTIC_COREAPI.insert_html('Lot Generation  [Top]');

Line 533: JTF_DIAGNOSTIC_COREAPI.insert_html('');

529: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
530: JTF_DIAGNOSTIC_COREAPI.BRPrint;
531:
532: sql_text:= rma1_sql(105);
533: JTF_DIAGNOSTIC_COREAPI.insert_html('');
534: JTF_DIAGNOSTIC_COREAPI.insert_html('Lot Generation  [Top]');
535: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
536: JTF_DIAGNOSTIC_COREAPI.BRPrint;
537:

Line 534: JTF_DIAGNOSTIC_COREAPI.insert_html('Lot Generation  [Top]');

530: JTF_DIAGNOSTIC_COREAPI.BRPrint;
531:
532: sql_text:= rma1_sql(105);
533: JTF_DIAGNOSTIC_COREAPI.insert_html('');
534: JTF_DIAGNOSTIC_COREAPI.insert_html('Lot Generation  [Top]');
535: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
536: JTF_DIAGNOSTIC_COREAPI.BRPrint;
537:
538: sql_text:= rma1_sql(106);

Line 535: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');

531:
532: sql_text:= rma1_sql(105);
533: JTF_DIAGNOSTIC_COREAPI.insert_html('');
534: JTF_DIAGNOSTIC_COREAPI.insert_html('Lot Generation  [Top]');
535: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
536: JTF_DIAGNOSTIC_COREAPI.BRPrint;
537:
538: sql_text:= rma1_sql(106);
539: JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line 536: JTF_DIAGNOSTIC_COREAPI.BRPrint;

532: sql_text:= rma1_sql(105);
533: JTF_DIAGNOSTIC_COREAPI.insert_html('');
534: JTF_DIAGNOSTIC_COREAPI.insert_html('Lot Generation  [Top]');
535: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
536: JTF_DIAGNOSTIC_COREAPI.BRPrint;
537:
538: sql_text:= rma1_sql(106);
539: JTF_DIAGNOSTIC_COREAPI.insert_html('');
540: JTF_DIAGNOSTIC_COREAPI.insert_html('LOT Uniqueness  [Top]');

Line 539: JTF_DIAGNOSTIC_COREAPI.insert_html('');

535: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
536: JTF_DIAGNOSTIC_COREAPI.BRPrint;
537:
538: sql_text:= rma1_sql(106);
539: JTF_DIAGNOSTIC_COREAPI.insert_html('');
540: JTF_DIAGNOSTIC_COREAPI.insert_html('LOT Uniqueness  [Top]');
541: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
542: JTF_DIAGNOSTIC_COREAPI.BRPrint;
543:

Line 540: JTF_DIAGNOSTIC_COREAPI.insert_html('LOT Uniqueness  [Top]');

536: JTF_DIAGNOSTIC_COREAPI.BRPrint;
537:
538: sql_text:= rma1_sql(106);
539: JTF_DIAGNOSTIC_COREAPI.insert_html('');
540: JTF_DIAGNOSTIC_COREAPI.insert_html('LOT Uniqueness  [Top]');
541: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
542: JTF_DIAGNOSTIC_COREAPI.BRPrint;
543:
544:

Line 541: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');

537:
538: sql_text:= rma1_sql(106);
539: JTF_DIAGNOSTIC_COREAPI.insert_html('');
540: JTF_DIAGNOSTIC_COREAPI.insert_html('LOT Uniqueness  [Top]');
541: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
542: JTF_DIAGNOSTIC_COREAPI.BRPrint;
543:
544:
545: END IF;

Line 542: JTF_DIAGNOSTIC_COREAPI.BRPrint;

538: sql_text:= rma1_sql(106);
539: JTF_DIAGNOSTIC_COREAPI.insert_html('');
540: JTF_DIAGNOSTIC_COREAPI.insert_html('LOT Uniqueness  [Top]');
541: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
542: JTF_DIAGNOSTIC_COREAPI.BRPrint;
543:
544:
545: END IF;
546:

Line 557: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '||sqlerrm);

553: end if;
554:
555: EXCEPTION
556: when others then
557: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '||sqlerrm);
558: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('This is the exception handler');
559: statusStr := 'FAILURE';
560: errStr := sqlerrm ||' occurred in script Exception handled';
561: isFatal := 'FALSE';

Line 558: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('This is the exception handler');

554:
555: EXCEPTION
556: when others then
557: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '||sqlerrm);
558: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('This is the exception handler');
559: statusStr := 'FAILURE';
560: errStr := sqlerrm ||' occurred in script Exception handled';
561: isFatal := 'FALSE';
562: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);

INDEX OF QUERIES