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.AR_BPA_PRINT_TRX dependencies on DBMS_SQL

Line 393: DBMS_SQL.bind_variable( cursor_name, ':org_id', p_org_id) ;

389: | (Low) Print Date p_print_date_low |
390: --------------------------------------------------------------------------*/
391:
392: IF ( p_org_id IS NOT NULL ) THEN
393: DBMS_SQL.bind_variable( cursor_name, ':org_id', p_org_id) ;
394: END IF;
395:
396: IF ( p_customer_name_low IS NOT NULL AND p_customer_name_high IS NULL )THEN
397: DBMS_SQL.bind_variable( cursor_name, ':customer_name_low', p_customer_name_low);

Line 397: DBMS_SQL.bind_variable( cursor_name, ':customer_name_low', p_customer_name_low);

393: DBMS_SQL.bind_variable( cursor_name, ':org_id', p_org_id) ;
394: END IF;
395:
396: IF ( p_customer_name_low IS NOT NULL AND p_customer_name_high IS NULL )THEN
397: DBMS_SQL.bind_variable( cursor_name, ':customer_name_low', p_customer_name_low);
398: ELSIF ( (p_customer_name_high IS NOT NULL) AND (p_customer_name_low IS NULL ) ) THEN
399: DBMS_SQL.bind_variable( cursor_name, ':customer_name_high', p_customer_name_high );
400: ELSIF ( (p_customer_name_high IS NOT NULL) AND (p_customer_name_low IS NOT NULL) ) THEN
401: DBMS_SQL.bind_variable( cursor_name, ':customer_name_low', p_customer_name_low);

Line 399: DBMS_SQL.bind_variable( cursor_name, ':customer_name_high', p_customer_name_high );

395:
396: IF ( p_customer_name_low IS NOT NULL AND p_customer_name_high IS NULL )THEN
397: DBMS_SQL.bind_variable( cursor_name, ':customer_name_low', p_customer_name_low);
398: ELSIF ( (p_customer_name_high IS NOT NULL) AND (p_customer_name_low IS NULL ) ) THEN
399: DBMS_SQL.bind_variable( cursor_name, ':customer_name_high', p_customer_name_high );
400: ELSIF ( (p_customer_name_high IS NOT NULL) AND (p_customer_name_low IS NOT NULL) ) THEN
401: DBMS_SQL.bind_variable( cursor_name, ':customer_name_low', p_customer_name_low);
402: DBMS_SQL.bind_variable( cursor_name,':customer_name_high', p_customer_name_high);
403: END IF;

Line 401: DBMS_SQL.bind_variable( cursor_name, ':customer_name_low', p_customer_name_low);

397: DBMS_SQL.bind_variable( cursor_name, ':customer_name_low', p_customer_name_low);
398: ELSIF ( (p_customer_name_high IS NOT NULL) AND (p_customer_name_low IS NULL ) ) THEN
399: DBMS_SQL.bind_variable( cursor_name, ':customer_name_high', p_customer_name_high );
400: ELSIF ( (p_customer_name_high IS NOT NULL) AND (p_customer_name_low IS NOT NULL) ) THEN
401: DBMS_SQL.bind_variable( cursor_name, ':customer_name_low', p_customer_name_low);
402: DBMS_SQL.bind_variable( cursor_name,':customer_name_high', p_customer_name_high);
403: END IF;
404:
405: IF ( (p_customer_no_low IS NOT NULL) AND (p_customer_no_high IS NULL) ) THEN

Line 402: DBMS_SQL.bind_variable( cursor_name,':customer_name_high', p_customer_name_high);

398: ELSIF ( (p_customer_name_high IS NOT NULL) AND (p_customer_name_low IS NULL ) ) THEN
399: DBMS_SQL.bind_variable( cursor_name, ':customer_name_high', p_customer_name_high );
400: ELSIF ( (p_customer_name_high IS NOT NULL) AND (p_customer_name_low IS NOT NULL) ) THEN
401: DBMS_SQL.bind_variable( cursor_name, ':customer_name_low', p_customer_name_low);
402: DBMS_SQL.bind_variable( cursor_name,':customer_name_high', p_customer_name_high);
403: END IF;
404:
405: IF ( (p_customer_no_low IS NOT NULL) AND (p_customer_no_high IS NULL) ) THEN
406: DBMS_SQL.bind_variable( cursor_name, ':customer_no_low', p_customer_no_low ) ;

Line 406: DBMS_SQL.bind_variable( cursor_name, ':customer_no_low', p_customer_no_low ) ;

402: DBMS_SQL.bind_variable( cursor_name,':customer_name_high', p_customer_name_high);
403: END IF;
404:
405: IF ( (p_customer_no_low IS NOT NULL) AND (p_customer_no_high IS NULL) ) THEN
406: DBMS_SQL.bind_variable( cursor_name, ':customer_no_low', p_customer_no_low ) ;
407: ELSIF ( (p_customer_no_high IS NOT NULL) AND (p_customer_no_low IS NULL) ) THEN
408: DBMS_SQL.bind_variable( cursor_name, ':customer_no_high', p_customer_no_high );
409: ELSIF ( (p_customer_no_high IS NOT NULL) AND (p_customer_no_low IS NOT NULL) ) THEN
410: DBMS_SQL.bind_variable( cursor_name, ':customer_no_low', p_customer_no_low ) ;

Line 408: DBMS_SQL.bind_variable( cursor_name, ':customer_no_high', p_customer_no_high );

404:
405: IF ( (p_customer_no_low IS NOT NULL) AND (p_customer_no_high IS NULL) ) THEN
406: DBMS_SQL.bind_variable( cursor_name, ':customer_no_low', p_customer_no_low ) ;
407: ELSIF ( (p_customer_no_high IS NOT NULL) AND (p_customer_no_low IS NULL) ) THEN
408: DBMS_SQL.bind_variable( cursor_name, ':customer_no_high', p_customer_no_high );
409: ELSIF ( (p_customer_no_high IS NOT NULL) AND (p_customer_no_low IS NOT NULL) ) THEN
410: DBMS_SQL.bind_variable( cursor_name, ':customer_no_low', p_customer_no_low ) ;
411: DBMS_SQL.bind_variable( cursor_name, ':customer_no_high', p_customer_no_high ) ;
412: END IF;

Line 410: DBMS_SQL.bind_variable( cursor_name, ':customer_no_low', p_customer_no_low ) ;

406: DBMS_SQL.bind_variable( cursor_name, ':customer_no_low', p_customer_no_low ) ;
407: ELSIF ( (p_customer_no_high IS NOT NULL) AND (p_customer_no_low IS NULL) ) THEN
408: DBMS_SQL.bind_variable( cursor_name, ':customer_no_high', p_customer_no_high );
409: ELSIF ( (p_customer_no_high IS NOT NULL) AND (p_customer_no_low IS NOT NULL) ) THEN
410: DBMS_SQL.bind_variable( cursor_name, ':customer_no_low', p_customer_no_low ) ;
411: DBMS_SQL.bind_variable( cursor_name, ':customer_no_high', p_customer_no_high ) ;
412: END IF;
413:
414: IF ( p_cust_trx_class IS NOT NULL ) THEN

Line 411: DBMS_SQL.bind_variable( cursor_name, ':customer_no_high', p_customer_no_high ) ;

407: ELSIF ( (p_customer_no_high IS NOT NULL) AND (p_customer_no_low IS NULL) ) THEN
408: DBMS_SQL.bind_variable( cursor_name, ':customer_no_high', p_customer_no_high );
409: ELSIF ( (p_customer_no_high IS NOT NULL) AND (p_customer_no_low IS NOT NULL) ) THEN
410: DBMS_SQL.bind_variable( cursor_name, ':customer_no_low', p_customer_no_low ) ;
411: DBMS_SQL.bind_variable( cursor_name, ':customer_no_high', p_customer_no_high ) ;
412: END IF;
413:
414: IF ( p_cust_trx_class IS NOT NULL ) THEN
415: DBMS_SQL.bind_variable( cursor_name, ':cust_trx_class', p_cust_trx_class );

Line 415: DBMS_SQL.bind_variable( cursor_name, ':cust_trx_class', p_cust_trx_class );

411: DBMS_SQL.bind_variable( cursor_name, ':customer_no_high', p_customer_no_high ) ;
412: END IF;
413:
414: IF ( p_cust_trx_class IS NOT NULL ) THEN
415: DBMS_SQL.bind_variable( cursor_name, ':cust_trx_class', p_cust_trx_class );
416: END IF;
417:
418: IF ( p_trx_type_id IS NOT NULL ) THEN
419: DBMS_SQL.bind_variable( cursor_name, ':trx_type_id', p_trx_type_id ) ;

Line 419: DBMS_SQL.bind_variable( cursor_name, ':trx_type_id', p_trx_type_id ) ;

415: DBMS_SQL.bind_variable( cursor_name, ':cust_trx_class', p_cust_trx_class );
416: END IF;
417:
418: IF ( p_trx_type_id IS NOT NULL ) THEN
419: DBMS_SQL.bind_variable( cursor_name, ':trx_type_id', p_trx_type_id ) ;
420: END IF;
421:
422: IF ( (p_trx_number_low IS NOT NULL) AND (p_trx_number_high IS NULL )) THEN
423: DBMS_SQL.bind_variable( cursor_name, ':trx_number_low', p_trx_number_low);

Line 423: DBMS_SQL.bind_variable( cursor_name, ':trx_number_low', p_trx_number_low);

419: DBMS_SQL.bind_variable( cursor_name, ':trx_type_id', p_trx_type_id ) ;
420: END IF;
421:
422: IF ( (p_trx_number_low IS NOT NULL) AND (p_trx_number_high IS NULL )) THEN
423: DBMS_SQL.bind_variable( cursor_name, ':trx_number_low', p_trx_number_low);
424: ELSIF ( (p_trx_number_high IS NOT NULL) AND (p_trx_number_low IS NULL) ) THEN
425: DBMS_SQL.bind_variable( cursor_name, ':trx_number_high', p_trx_number_high);
426: ELSIF ( (p_trx_number_high IS NOT NULL ) AND (p_trx_number_low IS NOT NULL) ) THEN
427: DBMS_SQL.bind_variable( cursor_name, ':trx_number_low' , p_trx_number_low);

Line 425: DBMS_SQL.bind_variable( cursor_name, ':trx_number_high', p_trx_number_high);

421:
422: IF ( (p_trx_number_low IS NOT NULL) AND (p_trx_number_high IS NULL )) THEN
423: DBMS_SQL.bind_variable( cursor_name, ':trx_number_low', p_trx_number_low);
424: ELSIF ( (p_trx_number_high IS NOT NULL) AND (p_trx_number_low IS NULL) ) THEN
425: DBMS_SQL.bind_variable( cursor_name, ':trx_number_high', p_trx_number_high);
426: ELSIF ( (p_trx_number_high IS NOT NULL ) AND (p_trx_number_low IS NOT NULL) ) THEN
427: DBMS_SQL.bind_variable( cursor_name, ':trx_number_low' , p_trx_number_low);
428: DBMS_SQL.bind_variable( cursor_name, ':trx_number_high', p_trx_number_high);
429: END IF;

Line 427: DBMS_SQL.bind_variable( cursor_name, ':trx_number_low' , p_trx_number_low);

423: DBMS_SQL.bind_variable( cursor_name, ':trx_number_low', p_trx_number_low);
424: ELSIF ( (p_trx_number_high IS NOT NULL) AND (p_trx_number_low IS NULL) ) THEN
425: DBMS_SQL.bind_variable( cursor_name, ':trx_number_high', p_trx_number_high);
426: ELSIF ( (p_trx_number_high IS NOT NULL ) AND (p_trx_number_low IS NOT NULL) ) THEN
427: DBMS_SQL.bind_variable( cursor_name, ':trx_number_low' , p_trx_number_low);
428: DBMS_SQL.bind_variable( cursor_name, ':trx_number_high', p_trx_number_high);
429: END IF;
430:
431: IF ( (p_doc_number_low IS NOT NULL) AND (p_doc_number_high IS NULL )) THEN

Line 428: DBMS_SQL.bind_variable( cursor_name, ':trx_number_high', p_trx_number_high);

424: ELSIF ( (p_trx_number_high IS NOT NULL) AND (p_trx_number_low IS NULL) ) THEN
425: DBMS_SQL.bind_variable( cursor_name, ':trx_number_high', p_trx_number_high);
426: ELSIF ( (p_trx_number_high IS NOT NULL ) AND (p_trx_number_low IS NOT NULL) ) THEN
427: DBMS_SQL.bind_variable( cursor_name, ':trx_number_low' , p_trx_number_low);
428: DBMS_SQL.bind_variable( cursor_name, ':trx_number_high', p_trx_number_high);
429: END IF;
430:
431: IF ( (p_doc_number_low IS NOT NULL) AND (p_doc_number_high IS NULL )) THEN
432: DBMS_SQL.bind_variable( cursor_name, ':doc_number_low', p_doc_number_low);

Line 432: DBMS_SQL.bind_variable( cursor_name, ':doc_number_low', p_doc_number_low);

428: DBMS_SQL.bind_variable( cursor_name, ':trx_number_high', p_trx_number_high);
429: END IF;
430:
431: IF ( (p_doc_number_low IS NOT NULL) AND (p_doc_number_high IS NULL )) THEN
432: DBMS_SQL.bind_variable( cursor_name, ':doc_number_low', p_doc_number_low);
433: ELSIF ( (p_doc_number_high IS NOT NULL) AND (p_doc_number_low IS NULL) ) THEN
434: DBMS_SQL.bind_variable( cursor_name, ':doc_number_high', p_doc_number_high);
435: ELSIF ( (p_doc_number_high IS NOT NULL ) AND (p_doc_number_low IS NOT NULL) ) THEN
436: DBMS_SQL.bind_variable( cursor_name, ':doc_number_low' , p_doc_number_low);

Line 434: DBMS_SQL.bind_variable( cursor_name, ':doc_number_high', p_doc_number_high);

430:
431: IF ( (p_doc_number_low IS NOT NULL) AND (p_doc_number_high IS NULL )) THEN
432: DBMS_SQL.bind_variable( cursor_name, ':doc_number_low', p_doc_number_low);
433: ELSIF ( (p_doc_number_high IS NOT NULL) AND (p_doc_number_low IS NULL) ) THEN
434: DBMS_SQL.bind_variable( cursor_name, ':doc_number_high', p_doc_number_high);
435: ELSIF ( (p_doc_number_high IS NOT NULL ) AND (p_doc_number_low IS NOT NULL) ) THEN
436: DBMS_SQL.bind_variable( cursor_name, ':doc_number_low' , p_doc_number_low);
437: DBMS_SQL.bind_variable( cursor_name, ':doc_number_high', p_doc_number_high);
438: END IF;

Line 436: DBMS_SQL.bind_variable( cursor_name, ':doc_number_low' , p_doc_number_low);

432: DBMS_SQL.bind_variable( cursor_name, ':doc_number_low', p_doc_number_low);
433: ELSIF ( (p_doc_number_high IS NOT NULL) AND (p_doc_number_low IS NULL) ) THEN
434: DBMS_SQL.bind_variable( cursor_name, ':doc_number_high', p_doc_number_high);
435: ELSIF ( (p_doc_number_high IS NOT NULL ) AND (p_doc_number_low IS NOT NULL) ) THEN
436: DBMS_SQL.bind_variable( cursor_name, ':doc_number_low' , p_doc_number_low);
437: DBMS_SQL.bind_variable( cursor_name, ':doc_number_high', p_doc_number_high);
438: END IF;
439:
440: /**********************************************************************************

Line 437: DBMS_SQL.bind_variable( cursor_name, ':doc_number_high', p_doc_number_high);

433: ELSIF ( (p_doc_number_high IS NOT NULL) AND (p_doc_number_low IS NULL) ) THEN
434: DBMS_SQL.bind_variable( cursor_name, ':doc_number_high', p_doc_number_high);
435: ELSIF ( (p_doc_number_high IS NOT NULL ) AND (p_doc_number_low IS NOT NULL) ) THEN
436: DBMS_SQL.bind_variable( cursor_name, ':doc_number_low' , p_doc_number_low);
437: DBMS_SQL.bind_variable( cursor_name, ':doc_number_high', p_doc_number_high);
438: END IF;
439:
440: /**********************************************************************************
441: Handle Print Lead Days IF date range is provided. IF the invoice you are printing

Line 452: DBMS_SQL.bind_variable( cursor_name, ':print_date_low' ,

448:
449: IF ( (p_print_date_low IS NOT NULL) or (p_print_date_low IS NOT NULL) ) THEN
450: IF ( p_union_flag = 'N' ) THEN
451: IF ( p_print_date_low IS NOT NULL AND p_print_date_high IS NOT NULL ) THEN
452: DBMS_SQL.bind_variable( cursor_name, ':print_date_low' ,
453: TO_CHAR(p_print_date_low ,'DD-MM-YYYY-HH24:MI:SS'));
454: DBMS_SQL.bind_variable( cursor_name, ':print_date_high' ,
455: TO_CHAR(p_print_date_high ,'DD-MM-YYYY-HH24:MI:SS'));
456: ELSIF ( p_print_date_low IS NOT NULL AND p_print_date_high IS NULL) THEN

Line 454: DBMS_SQL.bind_variable( cursor_name, ':print_date_high' ,

450: IF ( p_union_flag = 'N' ) THEN
451: IF ( p_print_date_low IS NOT NULL AND p_print_date_high IS NOT NULL ) THEN
452: DBMS_SQL.bind_variable( cursor_name, ':print_date_low' ,
453: TO_CHAR(p_print_date_low ,'DD-MM-YYYY-HH24:MI:SS'));
454: DBMS_SQL.bind_variable( cursor_name, ':print_date_high' ,
455: TO_CHAR(p_print_date_high ,'DD-MM-YYYY-HH24:MI:SS'));
456: ELSIF ( p_print_date_low IS NOT NULL AND p_print_date_high IS NULL) THEN
457: DBMS_SQL.bind_variable( cursor_name, ':print_date_low' ,
458: TO_CHAR(p_print_date_low ,'DD-MM-YYYY-HH24:MI:SS'));

Line 457: DBMS_SQL.bind_variable( cursor_name, ':print_date_low' ,

453: TO_CHAR(p_print_date_low ,'DD-MM-YYYY-HH24:MI:SS'));
454: DBMS_SQL.bind_variable( cursor_name, ':print_date_high' ,
455: TO_CHAR(p_print_date_high ,'DD-MM-YYYY-HH24:MI:SS'));
456: ELSIF ( p_print_date_low IS NOT NULL AND p_print_date_high IS NULL) THEN
457: DBMS_SQL.bind_variable( cursor_name, ':print_date_low' ,
458: TO_CHAR(p_print_date_low ,'DD-MM-YYYY-HH24:MI:SS'));
459: ELSIF ( p_print_date_high IS NOT NULL AND p_print_date_low IS NULL ) THEN
460: DBMS_SQL.bind_variable( cursor_name, ':print_date_high' ,
461: TO_CHAR(p_print_date_high ,'DD-MM-YYYY-HH24:MI:SS'));

Line 460: DBMS_SQL.bind_variable( cursor_name, ':print_date_high' ,

456: ELSIF ( p_print_date_low IS NOT NULL AND p_print_date_high IS NULL) THEN
457: DBMS_SQL.bind_variable( cursor_name, ':print_date_low' ,
458: TO_CHAR(p_print_date_low ,'DD-MM-YYYY-HH24:MI:SS'));
459: ELSIF ( p_print_date_high IS NOT NULL AND p_print_date_low IS NULL ) THEN
460: DBMS_SQL.bind_variable( cursor_name, ':print_date_high' ,
461: TO_CHAR(p_print_date_high ,'DD-MM-YYYY-HH24:MI:SS'));
462: END IF;
463: ELSE
464: IF ( p_print_date_low IS NOT NULL AND p_print_date_high IS NOT NULL ) THEN

Line 465: DBMS_SQL.bind_variable( cursor_name, ':print_date_low' ,

461: TO_CHAR(p_print_date_high ,'DD-MM-YYYY-HH24:MI:SS'));
462: END IF;
463: ELSE
464: IF ( p_print_date_low IS NOT NULL AND p_print_date_high IS NOT NULL ) THEN
465: DBMS_SQL.bind_variable( cursor_name, ':print_date_low' ,
466: TO_CHAR(p_print_date_low ,'DD-MM-YYYY-HH24:MI:SS'));
467: DBMS_SQL.bind_variable( cursor_name, ':print_date_high' ,
468: TO_CHAR(p_print_date_high ,'DD-MM-YYYY-HH24:MI:SS'));
469: ELSIF ( p_print_date_low IS NOT NULL AND p_print_date_high IS NULL ) THEN

Line 467: DBMS_SQL.bind_variable( cursor_name, ':print_date_high' ,

463: ELSE
464: IF ( p_print_date_low IS NOT NULL AND p_print_date_high IS NOT NULL ) THEN
465: DBMS_SQL.bind_variable( cursor_name, ':print_date_low' ,
466: TO_CHAR(p_print_date_low ,'DD-MM-YYYY-HH24:MI:SS'));
467: DBMS_SQL.bind_variable( cursor_name, ':print_date_high' ,
468: TO_CHAR(p_print_date_high ,'DD-MM-YYYY-HH24:MI:SS'));
469: ELSIF ( p_print_date_low IS NOT NULL AND p_print_date_high IS NULL ) THEN
470: DBMS_SQL.bind_variable( cursor_name, ':print_date_low' ,
471: TO_CHAR(p_print_date_low ,'DD-MM-YYYY-HH24:MI:SS'));

Line 470: DBMS_SQL.bind_variable( cursor_name, ':print_date_low' ,

466: TO_CHAR(p_print_date_low ,'DD-MM-YYYY-HH24:MI:SS'));
467: DBMS_SQL.bind_variable( cursor_name, ':print_date_high' ,
468: TO_CHAR(p_print_date_high ,'DD-MM-YYYY-HH24:MI:SS'));
469: ELSIF ( p_print_date_low IS NOT NULL AND p_print_date_high IS NULL ) THEN
470: DBMS_SQL.bind_variable( cursor_name, ':print_date_low' ,
471: TO_CHAR(p_print_date_low ,'DD-MM-YYYY-HH24:MI:SS'));
472: ELSIF ( p_print_date_high IS NOT NULL AND p_print_date_low IS NULL ) THEN
473: DBMS_SQL.bind_variable( cursor_name, ':print_date_high' ,
474: TO_CHAR(p_print_date_high ,'DD-MM-YYYY-HH24:MI:SS'));

Line 473: DBMS_SQL.bind_variable( cursor_name, ':print_date_high' ,

469: ELSIF ( p_print_date_low IS NOT NULL AND p_print_date_high IS NULL ) THEN
470: DBMS_SQL.bind_variable( cursor_name, ':print_date_low' ,
471: TO_CHAR(p_print_date_low ,'DD-MM-YYYY-HH24:MI:SS'));
472: ELSIF ( p_print_date_high IS NOT NULL AND p_print_date_low IS NULL ) THEN
473: DBMS_SQL.bind_variable( cursor_name, ':print_date_high' ,
474: TO_CHAR(p_print_date_high ,'DD-MM-YYYY-HH24:MI:SS'));
475: END IF;
476: END IF;
477: END IF;

Line 630: ln_sql_stmt_c:= DBMS_SQL.open_cursor;

626: ------------------------------------------------
627: -- Parse sql stmts
628: ------------------------------------------------
629:
630: ln_sql_stmt_c:= DBMS_SQL.open_cursor;
631: DBMS_SQL.parse( ln_sql_stmt_c, lc_sql_stmt , DBMS_SQL.v7 );
632: AR_BPA_PRINT_TRX.bind_variables(p_org_id
633: ,p_choice
634: ,p_cust_trx_class

Line 631: DBMS_SQL.parse( ln_sql_stmt_c, lc_sql_stmt , DBMS_SQL.v7 );

627: -- Parse sql stmts
628: ------------------------------------------------
629:
630: ln_sql_stmt_c:= DBMS_SQL.open_cursor;
631: DBMS_SQL.parse( ln_sql_stmt_c, lc_sql_stmt , DBMS_SQL.v7 );
632: AR_BPA_PRINT_TRX.bind_variables(p_org_id
633: ,p_choice
634: ,p_cust_trx_class
635: ,p_trx_type_id

Line 669: ln_inserted_row_counts := DBMS_SQL.execute(ln_sql_stmt_c);

665: ,ln_sql_stmt_c );
666:
667: END IF;
668:
669: ln_inserted_row_counts := DBMS_SQL.execute(ln_sql_stmt_c);
670:
671: IF ln_inserted_row_counts > 0 THEN
672: ln_divided_worker_counts := ceil(ln_inserted_row_counts/ln_job_size);
673: ln_row_counts_perworker := ceil(ln_inserted_row_counts/ln_divided_worker_counts);