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 424: DBMS_SQL.bind_variable( cursor_name, ':org_id', p_org_id) ;

420: | (Low) Print Date p_print_date_low |
421: --------------------------------------------------------------------------*/
422:
423: IF ( p_org_id IS NOT NULL ) THEN
424: DBMS_SQL.bind_variable( cursor_name, ':org_id', p_org_id) ;
425: END IF;
426:
427: IF ( p_customer_name_low IS NOT NULL AND p_customer_name_high IS NULL )THEN
428: DBMS_SQL.bind_variable( cursor_name, ':customer_name_low', p_customer_name_low);

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

424: DBMS_SQL.bind_variable( cursor_name, ':org_id', p_org_id) ;
425: END IF;
426:
427: IF ( p_customer_name_low IS NOT NULL AND p_customer_name_high IS NULL )THEN
428: DBMS_SQL.bind_variable( cursor_name, ':customer_name_low', p_customer_name_low);
429: ELSIF ( (p_customer_name_high IS NOT NULL) AND (p_customer_name_low IS NULL ) ) THEN
430: DBMS_SQL.bind_variable( cursor_name, ':customer_name_high', p_customer_name_high );
431: ELSIF ( (p_customer_name_high IS NOT NULL) AND (p_customer_name_low IS NOT NULL) ) THEN
432: DBMS_SQL.bind_variable( cursor_name, ':customer_name_low', p_customer_name_low);

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

426:
427: IF ( p_customer_name_low IS NOT NULL AND p_customer_name_high IS NULL )THEN
428: DBMS_SQL.bind_variable( cursor_name, ':customer_name_low', p_customer_name_low);
429: ELSIF ( (p_customer_name_high IS NOT NULL) AND (p_customer_name_low IS NULL ) ) THEN
430: DBMS_SQL.bind_variable( cursor_name, ':customer_name_high', p_customer_name_high );
431: ELSIF ( (p_customer_name_high IS NOT NULL) AND (p_customer_name_low IS NOT NULL) ) THEN
432: DBMS_SQL.bind_variable( cursor_name, ':customer_name_low', p_customer_name_low);
433: DBMS_SQL.bind_variable( cursor_name,':customer_name_high', p_customer_name_high);
434: END IF;

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

428: DBMS_SQL.bind_variable( cursor_name, ':customer_name_low', p_customer_name_low);
429: ELSIF ( (p_customer_name_high IS NOT NULL) AND (p_customer_name_low IS NULL ) ) THEN
430: DBMS_SQL.bind_variable( cursor_name, ':customer_name_high', p_customer_name_high );
431: ELSIF ( (p_customer_name_high IS NOT NULL) AND (p_customer_name_low IS NOT NULL) ) THEN
432: DBMS_SQL.bind_variable( cursor_name, ':customer_name_low', p_customer_name_low);
433: DBMS_SQL.bind_variable( cursor_name,':customer_name_high', p_customer_name_high);
434: END IF;
435:
436: IF ( (p_customer_no_low IS NOT NULL) AND (p_customer_no_high IS NULL) ) THEN

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

429: ELSIF ( (p_customer_name_high IS NOT NULL) AND (p_customer_name_low IS NULL ) ) THEN
430: DBMS_SQL.bind_variable( cursor_name, ':customer_name_high', p_customer_name_high );
431: ELSIF ( (p_customer_name_high IS NOT NULL) AND (p_customer_name_low IS NOT NULL) ) THEN
432: DBMS_SQL.bind_variable( cursor_name, ':customer_name_low', p_customer_name_low);
433: DBMS_SQL.bind_variable( cursor_name,':customer_name_high', p_customer_name_high);
434: END IF;
435:
436: IF ( (p_customer_no_low IS NOT NULL) AND (p_customer_no_high IS NULL) ) THEN
437: DBMS_SQL.bind_variable( cursor_name, ':customer_no_low', p_customer_no_low ) ;

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

433: DBMS_SQL.bind_variable( cursor_name,':customer_name_high', p_customer_name_high);
434: END IF;
435:
436: IF ( (p_customer_no_low IS NOT NULL) AND (p_customer_no_high IS NULL) ) THEN
437: DBMS_SQL.bind_variable( cursor_name, ':customer_no_low', p_customer_no_low ) ;
438: ELSIF ( (p_customer_no_high IS NOT NULL) AND (p_customer_no_low IS NULL) ) THEN
439: DBMS_SQL.bind_variable( cursor_name, ':customer_no_high', p_customer_no_high );
440: ELSIF ( (p_customer_no_high IS NOT NULL) AND (p_customer_no_low IS NOT NULL) ) THEN
441: DBMS_SQL.bind_variable( cursor_name, ':customer_no_low', p_customer_no_low ) ;

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

435:
436: IF ( (p_customer_no_low IS NOT NULL) AND (p_customer_no_high IS NULL) ) THEN
437: DBMS_SQL.bind_variable( cursor_name, ':customer_no_low', p_customer_no_low ) ;
438: ELSIF ( (p_customer_no_high IS NOT NULL) AND (p_customer_no_low IS NULL) ) THEN
439: DBMS_SQL.bind_variable( cursor_name, ':customer_no_high', p_customer_no_high );
440: ELSIF ( (p_customer_no_high IS NOT NULL) AND (p_customer_no_low IS NOT NULL) ) THEN
441: DBMS_SQL.bind_variable( cursor_name, ':customer_no_low', p_customer_no_low ) ;
442: DBMS_SQL.bind_variable( cursor_name, ':customer_no_high', p_customer_no_high ) ;
443: END IF;

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

437: DBMS_SQL.bind_variable( cursor_name, ':customer_no_low', p_customer_no_low ) ;
438: ELSIF ( (p_customer_no_high IS NOT NULL) AND (p_customer_no_low IS NULL) ) THEN
439: DBMS_SQL.bind_variable( cursor_name, ':customer_no_high', p_customer_no_high );
440: ELSIF ( (p_customer_no_high IS NOT NULL) AND (p_customer_no_low IS NOT NULL) ) THEN
441: DBMS_SQL.bind_variable( cursor_name, ':customer_no_low', p_customer_no_low ) ;
442: DBMS_SQL.bind_variable( cursor_name, ':customer_no_high', p_customer_no_high ) ;
443: END IF;
444:
445: IF ( p_cust_trx_class IS NOT NULL ) THEN

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

438: ELSIF ( (p_customer_no_high IS NOT NULL) AND (p_customer_no_low IS NULL) ) THEN
439: DBMS_SQL.bind_variable( cursor_name, ':customer_no_high', p_customer_no_high );
440: ELSIF ( (p_customer_no_high IS NOT NULL) AND (p_customer_no_low IS NOT NULL) ) THEN
441: DBMS_SQL.bind_variable( cursor_name, ':customer_no_low', p_customer_no_low ) ;
442: DBMS_SQL.bind_variable( cursor_name, ':customer_no_high', p_customer_no_high ) ;
443: END IF;
444:
445: IF ( p_cust_trx_class IS NOT NULL ) THEN
446: DBMS_SQL.bind_variable( cursor_name, ':cust_trx_class', p_cust_trx_class );

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

442: DBMS_SQL.bind_variable( cursor_name, ':customer_no_high', p_customer_no_high ) ;
443: END IF;
444:
445: IF ( p_cust_trx_class IS NOT NULL ) THEN
446: DBMS_SQL.bind_variable( cursor_name, ':cust_trx_class', p_cust_trx_class );
447: END IF;
448:
449: IF ( p_trx_type_id IS NOT NULL ) THEN
450: DBMS_SQL.bind_variable( cursor_name, ':trx_type_id', p_trx_type_id ) ;

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

446: DBMS_SQL.bind_variable( cursor_name, ':cust_trx_class', p_cust_trx_class );
447: END IF;
448:
449: IF ( p_trx_type_id IS NOT NULL ) THEN
450: DBMS_SQL.bind_variable( cursor_name, ':trx_type_id', p_trx_type_id ) ;
451: END IF;
452:
453: IF ( (p_trx_number_low IS NOT NULL) AND (p_trx_number_high IS NULL )) THEN
454: DBMS_SQL.bind_variable( cursor_name, ':trx_number_low', p_trx_number_low);

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

450: DBMS_SQL.bind_variable( cursor_name, ':trx_type_id', p_trx_type_id ) ;
451: END IF;
452:
453: IF ( (p_trx_number_low IS NOT NULL) AND (p_trx_number_high IS NULL )) THEN
454: DBMS_SQL.bind_variable( cursor_name, ':trx_number_low', p_trx_number_low);
455: ELSIF ( (p_trx_number_high IS NOT NULL) AND (p_trx_number_low IS NULL) ) THEN
456: DBMS_SQL.bind_variable( cursor_name, ':trx_number_high', p_trx_number_high);
457: ELSIF ( (p_trx_number_high IS NOT NULL ) AND (p_trx_number_low IS NOT NULL) ) THEN
458: DBMS_SQL.bind_variable( cursor_name, ':trx_number_low' , p_trx_number_low);

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

452:
453: IF ( (p_trx_number_low IS NOT NULL) AND (p_trx_number_high IS NULL )) THEN
454: DBMS_SQL.bind_variable( cursor_name, ':trx_number_low', p_trx_number_low);
455: ELSIF ( (p_trx_number_high IS NOT NULL) AND (p_trx_number_low IS NULL) ) THEN
456: DBMS_SQL.bind_variable( cursor_name, ':trx_number_high', p_trx_number_high);
457: ELSIF ( (p_trx_number_high IS NOT NULL ) AND (p_trx_number_low IS NOT NULL) ) THEN
458: DBMS_SQL.bind_variable( cursor_name, ':trx_number_low' , p_trx_number_low);
459: DBMS_SQL.bind_variable( cursor_name, ':trx_number_high', p_trx_number_high);
460: END IF;

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

454: DBMS_SQL.bind_variable( cursor_name, ':trx_number_low', p_trx_number_low);
455: ELSIF ( (p_trx_number_high IS NOT NULL) AND (p_trx_number_low IS NULL) ) THEN
456: DBMS_SQL.bind_variable( cursor_name, ':trx_number_high', p_trx_number_high);
457: ELSIF ( (p_trx_number_high IS NOT NULL ) AND (p_trx_number_low IS NOT NULL) ) THEN
458: DBMS_SQL.bind_variable( cursor_name, ':trx_number_low' , p_trx_number_low);
459: DBMS_SQL.bind_variable( cursor_name, ':trx_number_high', p_trx_number_high);
460: END IF;
461:
462: IF ( (p_doc_number_low IS NOT NULL) AND (p_doc_number_high IS NULL )) THEN

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

455: ELSIF ( (p_trx_number_high IS NOT NULL) AND (p_trx_number_low IS NULL) ) THEN
456: DBMS_SQL.bind_variable( cursor_name, ':trx_number_high', p_trx_number_high);
457: ELSIF ( (p_trx_number_high IS NOT NULL ) AND (p_trx_number_low IS NOT NULL) ) THEN
458: DBMS_SQL.bind_variable( cursor_name, ':trx_number_low' , p_trx_number_low);
459: DBMS_SQL.bind_variable( cursor_name, ':trx_number_high', p_trx_number_high);
460: END IF;
461:
462: IF ( (p_doc_number_low IS NOT NULL) AND (p_doc_number_high IS NULL )) THEN
463: DBMS_SQL.bind_variable( cursor_name, ':doc_number_low', p_doc_number_low);

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

459: DBMS_SQL.bind_variable( cursor_name, ':trx_number_high', p_trx_number_high);
460: END IF;
461:
462: IF ( (p_doc_number_low IS NOT NULL) AND (p_doc_number_high IS NULL )) THEN
463: DBMS_SQL.bind_variable( cursor_name, ':doc_number_low', p_doc_number_low);
464: ELSIF ( (p_doc_number_high IS NOT NULL) AND (p_doc_number_low IS NULL) ) THEN
465: DBMS_SQL.bind_variable( cursor_name, ':doc_number_high', p_doc_number_high);
466: ELSIF ( (p_doc_number_high IS NOT NULL ) AND (p_doc_number_low IS NOT NULL) ) THEN
467: DBMS_SQL.bind_variable( cursor_name, ':doc_number_low' , p_doc_number_low);

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

461:
462: IF ( (p_doc_number_low IS NOT NULL) AND (p_doc_number_high IS NULL )) THEN
463: DBMS_SQL.bind_variable( cursor_name, ':doc_number_low', p_doc_number_low);
464: ELSIF ( (p_doc_number_high IS NOT NULL) AND (p_doc_number_low IS NULL) ) THEN
465: DBMS_SQL.bind_variable( cursor_name, ':doc_number_high', p_doc_number_high);
466: ELSIF ( (p_doc_number_high IS NOT NULL ) AND (p_doc_number_low IS NOT NULL) ) THEN
467: DBMS_SQL.bind_variable( cursor_name, ':doc_number_low' , p_doc_number_low);
468: DBMS_SQL.bind_variable( cursor_name, ':doc_number_high', p_doc_number_high);
469: END IF;

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

463: DBMS_SQL.bind_variable( cursor_name, ':doc_number_low', p_doc_number_low);
464: ELSIF ( (p_doc_number_high IS NOT NULL) AND (p_doc_number_low IS NULL) ) THEN
465: DBMS_SQL.bind_variable( cursor_name, ':doc_number_high', p_doc_number_high);
466: ELSIF ( (p_doc_number_high IS NOT NULL ) AND (p_doc_number_low IS NOT NULL) ) THEN
467: DBMS_SQL.bind_variable( cursor_name, ':doc_number_low' , p_doc_number_low);
468: DBMS_SQL.bind_variable( cursor_name, ':doc_number_high', p_doc_number_high);
469: END IF;
470:
471: /**********************************************************************************

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

464: ELSIF ( (p_doc_number_high IS NOT NULL) AND (p_doc_number_low IS NULL) ) THEN
465: DBMS_SQL.bind_variable( cursor_name, ':doc_number_high', p_doc_number_high);
466: ELSIF ( (p_doc_number_high IS NOT NULL ) AND (p_doc_number_low IS NOT NULL) ) THEN
467: DBMS_SQL.bind_variable( cursor_name, ':doc_number_low' , p_doc_number_low);
468: DBMS_SQL.bind_variable( cursor_name, ':doc_number_high', p_doc_number_high);
469: END IF;
470:
471: /**********************************************************************************
472: Handle Print Lead Days IF date range is provided. IF the invoice you are printing

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

479:
480: IF ( (p_print_date_low IS NOT NULL) or (p_print_date_low IS NOT NULL) ) THEN
481: IF ( p_union_flag = 'N' ) THEN
482: IF ( p_print_date_low IS NOT NULL AND p_print_date_high IS NOT NULL ) THEN
483: DBMS_SQL.bind_variable( cursor_name, ':print_date_low' ,
484: TO_CHAR(p_print_date_low ,'DD-MM-YYYY-HH24:MI:SS'));
485: DBMS_SQL.bind_variable( cursor_name, ':print_date_high' ,
486: TO_CHAR(p_print_date_high ,'DD-MM-YYYY-HH24:MI:SS'));
487: ELSIF ( p_print_date_low IS NOT NULL AND p_print_date_high IS NULL) THEN

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

481: IF ( p_union_flag = 'N' ) THEN
482: IF ( p_print_date_low IS NOT NULL AND p_print_date_high IS NOT NULL ) THEN
483: DBMS_SQL.bind_variable( cursor_name, ':print_date_low' ,
484: TO_CHAR(p_print_date_low ,'DD-MM-YYYY-HH24:MI:SS'));
485: DBMS_SQL.bind_variable( cursor_name, ':print_date_high' ,
486: TO_CHAR(p_print_date_high ,'DD-MM-YYYY-HH24:MI:SS'));
487: ELSIF ( p_print_date_low IS NOT NULL AND p_print_date_high IS NULL) THEN
488: DBMS_SQL.bind_variable( cursor_name, ':print_date_low' ,
489: TO_CHAR(p_print_date_low ,'DD-MM-YYYY-HH24:MI:SS'));

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

484: TO_CHAR(p_print_date_low ,'DD-MM-YYYY-HH24:MI:SS'));
485: DBMS_SQL.bind_variable( cursor_name, ':print_date_high' ,
486: TO_CHAR(p_print_date_high ,'DD-MM-YYYY-HH24:MI:SS'));
487: ELSIF ( p_print_date_low IS NOT NULL AND p_print_date_high IS NULL) THEN
488: DBMS_SQL.bind_variable( cursor_name, ':print_date_low' ,
489: TO_CHAR(p_print_date_low ,'DD-MM-YYYY-HH24:MI:SS'));
490: ELSIF ( p_print_date_high IS NOT NULL AND p_print_date_low IS NULL ) THEN
491: DBMS_SQL.bind_variable( cursor_name, ':print_date_high' ,
492: TO_CHAR(p_print_date_high ,'DD-MM-YYYY-HH24:MI:SS'));

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

487: ELSIF ( p_print_date_low IS NOT NULL AND p_print_date_high IS NULL) THEN
488: DBMS_SQL.bind_variable( cursor_name, ':print_date_low' ,
489: TO_CHAR(p_print_date_low ,'DD-MM-YYYY-HH24:MI:SS'));
490: ELSIF ( p_print_date_high IS NOT NULL AND p_print_date_low IS NULL ) THEN
491: DBMS_SQL.bind_variable( cursor_name, ':print_date_high' ,
492: TO_CHAR(p_print_date_high ,'DD-MM-YYYY-HH24:MI:SS'));
493: END IF;
494: ELSE
495: IF ( p_print_date_low IS NOT NULL AND p_print_date_high IS NOT NULL ) THEN

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

492: TO_CHAR(p_print_date_high ,'DD-MM-YYYY-HH24:MI:SS'));
493: END IF;
494: ELSE
495: IF ( p_print_date_low IS NOT NULL AND p_print_date_high IS NOT NULL ) THEN
496: DBMS_SQL.bind_variable( cursor_name, ':print_date_low' ,
497: TO_CHAR(p_print_date_low ,'DD-MM-YYYY-HH24:MI:SS'));
498: DBMS_SQL.bind_variable( cursor_name, ':print_date_high' ,
499: TO_CHAR(p_print_date_high ,'DD-MM-YYYY-HH24:MI:SS'));
500: ELSIF ( p_print_date_low IS NOT NULL AND p_print_date_high IS NULL ) THEN

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

494: ELSE
495: IF ( p_print_date_low IS NOT NULL AND p_print_date_high IS NOT NULL ) THEN
496: DBMS_SQL.bind_variable( cursor_name, ':print_date_low' ,
497: TO_CHAR(p_print_date_low ,'DD-MM-YYYY-HH24:MI:SS'));
498: DBMS_SQL.bind_variable( cursor_name, ':print_date_high' ,
499: TO_CHAR(p_print_date_high ,'DD-MM-YYYY-HH24:MI:SS'));
500: ELSIF ( p_print_date_low IS NOT NULL AND p_print_date_high IS NULL ) THEN
501: DBMS_SQL.bind_variable( cursor_name, ':print_date_low' ,
502: TO_CHAR(p_print_date_low ,'DD-MM-YYYY-HH24:MI:SS'));

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

497: TO_CHAR(p_print_date_low ,'DD-MM-YYYY-HH24:MI:SS'));
498: DBMS_SQL.bind_variable( cursor_name, ':print_date_high' ,
499: TO_CHAR(p_print_date_high ,'DD-MM-YYYY-HH24:MI:SS'));
500: ELSIF ( p_print_date_low IS NOT NULL AND p_print_date_high IS NULL ) THEN
501: DBMS_SQL.bind_variable( cursor_name, ':print_date_low' ,
502: TO_CHAR(p_print_date_low ,'DD-MM-YYYY-HH24:MI:SS'));
503: ELSIF ( p_print_date_high IS NOT NULL AND p_print_date_low IS NULL ) THEN
504: DBMS_SQL.bind_variable( cursor_name, ':print_date_high' ,
505: TO_CHAR(p_print_date_high ,'DD-MM-YYYY-HH24:MI:SS'));

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

500: ELSIF ( p_print_date_low IS NOT NULL AND p_print_date_high IS NULL ) THEN
501: DBMS_SQL.bind_variable( cursor_name, ':print_date_low' ,
502: TO_CHAR(p_print_date_low ,'DD-MM-YYYY-HH24:MI:SS'));
503: ELSIF ( p_print_date_high IS NOT NULL AND p_print_date_low IS NULL ) THEN
504: DBMS_SQL.bind_variable( cursor_name, ':print_date_high' ,
505: TO_CHAR(p_print_date_high ,'DD-MM-YYYY-HH24:MI:SS'));
506: END IF;
507: END IF;
508: END IF;

Line 661: ln_sql_stmt_c:= DBMS_SQL.open_cursor;

657: ------------------------------------------------
658: -- Parse sql stmts
659: ------------------------------------------------
660:
661: ln_sql_stmt_c:= DBMS_SQL.open_cursor;
662: DBMS_SQL.parse( ln_sql_stmt_c, lc_sql_stmt , DBMS_SQL.v7 );
663: AR_BPA_PRINT_TRX.bind_variables(p_org_id
664: ,p_choice
665: ,p_cust_trx_class

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

658: -- Parse sql stmts
659: ------------------------------------------------
660:
661: ln_sql_stmt_c:= DBMS_SQL.open_cursor;
662: DBMS_SQL.parse( ln_sql_stmt_c, lc_sql_stmt , DBMS_SQL.v7 );
663: AR_BPA_PRINT_TRX.bind_variables(p_org_id
664: ,p_choice
665: ,p_cust_trx_class
666: ,p_trx_type_id

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

696: ,ln_sql_stmt_c );
697:
698: END IF;
699:
700: ln_inserted_row_counts := DBMS_SQL.execute(ln_sql_stmt_c);
701:
702: IF ln_inserted_row_counts > 0 THEN
703: ln_divided_worker_counts := ceil(ln_inserted_row_counts/ln_job_size);
704: ln_row_counts_perworker := ceil(ln_inserted_row_counts/ln_divided_worker_counts);