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.CZ_IMP_IM_MAIN dependencies on DBMS_UTILITY

Line 521: st_time := dbms_utility.get_time();

517: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IM_MAIN.MAIN_ITEM_MASTER',11276,inRun_ID);
518: END;
519:
520: if (CZ_IMP_ALL.get_time) then
521: st_time := dbms_utility.get_time();
522: end if;
523:
524: CZ_IMP_IM_MAIN.CND_ITEM_MASTER (inRun_ID,COMMIT_SIZE,MAX_ERR,FAILED);
525:

Line 527: end_time := dbms_utility.get_time();

523:
524: CZ_IMP_IM_MAIN.CND_ITEM_MASTER (inRun_ID,COMMIT_SIZE,MAX_ERR,FAILED);
525:
526: if (CZ_IMP_ALL.get_time) then
527: end_time := dbms_utility.get_time();
528: d_str := inRun_id || ' CND item master :' || (end_time-st_time)/100.00;
529: x_ERROR:=CZ_UTILS.LOG_REPORT(d_str,1,'CND',11299);
530: end if;
531:

Line 533: st_time := dbms_utility.get_time();

529: x_ERROR:=CZ_UTILS.LOG_REPORT(d_str,1,'CND',11299);
530: end if;
531:
532: if (CZ_IMP_ALL.get_time) then
533: st_time := dbms_utility.get_time();
534: end if;
535:
536: CZ_IMP_IM_KRS.KRS_ITEM_MASTER (inRUN_ID,COMMIT_SIZE,MAX_ERR,INSERTS,UPDATES,FAILED,DUPS,NOCHANGE,inXFR_GROUP);
537:

Line 539: end_time := dbms_utility.get_time();

535:
536: CZ_IMP_IM_KRS.KRS_ITEM_MASTER (inRUN_ID,COMMIT_SIZE,MAX_ERR,INSERTS,UPDATES,FAILED,DUPS,NOCHANGE,inXFR_GROUP);
537:
538: if (CZ_IMP_ALL.get_time) then
539: end_time := dbms_utility.get_time();
540: d_str := inRun_id || ' KRS item master :' || (end_time-st_time)/100.00;
541: x_ERROR:=CZ_UTILS.LOG_REPORT(d_str,1,'KRS',11299);
542: end if;
543:

Line 545: st_time := dbms_utility.get_time();

541: x_ERROR:=CZ_UTILS.LOG_REPORT(d_str,1,'KRS',11299);
542: end if;
543:
544: if (CZ_IMP_ALL.get_time) then
545: st_time := dbms_utility.get_time();
546: end if;
547:
548: CZ_IMP_IM_XFR.XFR_ITEM_MASTER (inRUN_ID,COMMIT_SIZE,MAX_ERR,nXfrInsertCount,nXfrUpdateCount,FAILED,nNoChangeCount,inXFR_GROUP);
549:

Line 551: end_time := dbms_utility.get_time();

547:
548: CZ_IMP_IM_XFR.XFR_ITEM_MASTER (inRUN_ID,COMMIT_SIZE,MAX_ERR,nXfrInsertCount,nXfrUpdateCount,FAILED,nNoChangeCount,inXFR_GROUP);
549:
550: if (CZ_IMP_ALL.get_time) then
551: end_time := dbms_utility.get_time();
552: d_str := inRun_id || ' XFR item master :' || (end_time-st_time)/100.00;
553: x_ERROR:=CZ_UTILS.LOG_REPORT(d_str,1,'XFR',11299);
554: end if;
555:

Line 625: st_time := dbms_utility.get_time();

621: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IM_MAIN.MAIN_ITEM_PROPERTY_VALUE',11276,inRun_ID);
622: END;
623:
624: if (CZ_IMP_ALL.get_time) then
625: st_time := dbms_utility.get_time();
626: end if;
627:
628: CZ_IMP_IM_MAIN.CND_ITEM_PROPERTY_VALUE (inRun_ID,COMMIT_SIZE,MAX_ERR,FAILED);
629:

Line 631: end_time := dbms_utility.get_time();

627:
628: CZ_IMP_IM_MAIN.CND_ITEM_PROPERTY_VALUE (inRun_ID,COMMIT_SIZE,MAX_ERR,FAILED);
629:
630: if (CZ_IMP_ALL.get_time) then
631: end_time := dbms_utility.get_time();
632: d_str := inRun_id || ' CND item prop val :' || (end_time-st_time)/100.00;
633: x_ERROR:=CZ_UTILS.LOG_REPORT(d_str,1,'CND',11299);
634: end if;
635:

Line 638: st_time := dbms_utility.get_time();

634: end if;
635:
636:
637: if (CZ_IMP_ALL.get_time) then
638: st_time := dbms_utility.get_time();
639: end if;
640:
641: CZ_IMP_IM_KRS.KRS_ITEM_PROPERTY_VALUE (inRUN_ID,COMMIT_SIZE,MAX_ERR,INSERTS,UPDATES,FAILED,DUPS,nNoChangeCount,inXFR_GROUP);
642:

Line 644: end_time := dbms_utility.get_time();

640:
641: CZ_IMP_IM_KRS.KRS_ITEM_PROPERTY_VALUE (inRUN_ID,COMMIT_SIZE,MAX_ERR,INSERTS,UPDATES,FAILED,DUPS,nNoChangeCount,inXFR_GROUP);
642:
643: if (CZ_IMP_ALL.get_time) then
644: end_time := dbms_utility.get_time();
645: d_str := inRun_id || ' KRS item prop val :' || (end_time-st_time)/100.00;
646: x_ERROR:=CZ_UTILS.LOG_REPORT(d_str,1,'KRS',11299);
647: end if;
648:

Line 650: st_time := dbms_utility.get_time();

646: x_ERROR:=CZ_UTILS.LOG_REPORT(d_str,1,'KRS',11299);
647: end if;
648:
649: if (CZ_IMP_ALL.get_time) then
650: st_time := dbms_utility.get_time();
651: end if;
652:
653: CZ_IMP_IM_XFR.XFR_ITEM_PROPERTY_VALUE(inRUN_ID,COMMIT_SIZE,MAX_ERR,nXfrInsertCount,nXfrUpdateCount,FAILED,nNoChangeCount,inXFR_GROUP);
654:

Line 656: end_time := dbms_utility.get_time();

652:
653: CZ_IMP_IM_XFR.XFR_ITEM_PROPERTY_VALUE(inRUN_ID,COMMIT_SIZE,MAX_ERR,nXfrInsertCount,nXfrUpdateCount,FAILED,nNoChangeCount,inXFR_GROUP);
654:
655: if (CZ_IMP_ALL.get_time) then
656: end_time := dbms_utility.get_time();
657: d_str := inRun_id || ' XFR item prop val :' || (end_time-st_time)/100.00;
658: x_ERROR:=CZ_UTILS.LOG_REPORT(d_str,1,'XFR',11299);
659: end if;
660:

Line 729: st_time := dbms_utility.get_time();

725: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IM_MAIN.MAIN_ITEM_TYPE',11276,inRun_ID);
726: END;
727:
728: if (CZ_IMP_ALL.get_time) then
729: st_time := dbms_utility.get_time();
730: end if;
731: CZ_IMP_IM_MAIN.CND_ITEM_TYPE (inRun_ID,COMMIT_SIZE,MAX_ERR,FAILED);
732: if (CZ_IMP_ALL.get_time) then
733: end_time := dbms_utility.get_time();

Line 733: end_time := dbms_utility.get_time();

729: st_time := dbms_utility.get_time();
730: end if;
731: CZ_IMP_IM_MAIN.CND_ITEM_TYPE (inRun_ID,COMMIT_SIZE,MAX_ERR,FAILED);
732: if (CZ_IMP_ALL.get_time) then
733: end_time := dbms_utility.get_time();
734: d_str := inRun_id || ' CND item type :' || (end_time-st_time)/100.00;
735: x_ERROR:=CZ_UTILS.LOG_REPORT(d_str,1,'CND',11299);
736: end if;
737:

Line 739: st_time := dbms_utility.get_time();

735: x_ERROR:=CZ_UTILS.LOG_REPORT(d_str,1,'CND',11299);
736: end if;
737:
738: if (CZ_IMP_ALL.get_time) then
739: st_time := dbms_utility.get_time();
740: end if;
741:
742: CZ_IMP_IM_KRS.KRS_ITEM_TYPE (inRUN_ID,COMMIT_SIZE,MAX_ERR,INSERTS,UPDATES,FAILED,DUPS,NOCHANGE,inXFR_GROUP);
743:

Line 745: end_time := dbms_utility.get_time();

741:
742: CZ_IMP_IM_KRS.KRS_ITEM_TYPE (inRUN_ID,COMMIT_SIZE,MAX_ERR,INSERTS,UPDATES,FAILED,DUPS,NOCHANGE,inXFR_GROUP);
743:
744: if (CZ_IMP_ALL.get_time) then
745: end_time := dbms_utility.get_time();
746: d_str := inRun_id || ' KRS item type :' || (end_time-st_time)/100.00;
747: x_ERROR:=CZ_UTILS.LOG_REPORT(d_str,1,'KRS',11299);
748: end if;
749:

Line 751: st_time := dbms_utility.get_time();

747: x_ERROR:=CZ_UTILS.LOG_REPORT(d_str,1,'KRS',11299);
748: end if;
749:
750: if (CZ_IMP_ALL.get_time) then
751: st_time := dbms_utility.get_time();
752: end if;
753:
754: CZ_IMP_IM_XFR.XFR_ITEM_TYPE (inRUN_ID,COMMIT_SIZE,MAX_ERR,nXfrInsertCount,nXfrUpdateCount,FAILED,nNoChangeCount,inXFR_GROUP);
755:

Line 757: end_time := dbms_utility.get_time();

753:
754: CZ_IMP_IM_XFR.XFR_ITEM_TYPE (inRUN_ID,COMMIT_SIZE,MAX_ERR,nXfrInsertCount,nXfrUpdateCount,FAILED,nNoChangeCount,inXFR_GROUP);
755:
756: if (CZ_IMP_ALL.get_time) then
757: end_time := dbms_utility.get_time();
758: d_str := inRun_id || ' XFR item type :' || (end_time-st_time)/100.00;
759: x_ERROR:=CZ_UTILS.LOG_REPORT(d_str,1,'XFR',11299);
760: end if;
761:

Line 829: st_time := dbms_utility.get_time();

825: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IM_MAIN.MAIN_ITEM_TYPE_PROPERTY',11276,inRun_ID);
826: END;
827:
828: if (CZ_IMP_ALL.get_time) then
829: st_time := dbms_utility.get_time();
830: end if;
831:
832: CZ_IMP_IM_MAIN.CND_ITEM_TYPE_PROPERTY (inRun_ID,COMMIT_SIZE,MAX_ERR,FAILED);
833:

Line 835: end_time := dbms_utility.get_time();

831:
832: CZ_IMP_IM_MAIN.CND_ITEM_TYPE_PROPERTY (inRun_ID,COMMIT_SIZE,MAX_ERR,FAILED);
833:
834: if (CZ_IMP_ALL.get_time) then
835: end_time := dbms_utility.get_time();
836: d_str := inRun_id || ' CND item type prop :' || (end_time-st_time)/100.00;
837: x_ERROR:=CZ_UTILS.LOG_REPORT(d_str,1,'CND',11299);
838: end if;
839:

Line 841: st_time := dbms_utility.get_time();

837: x_ERROR:=CZ_UTILS.LOG_REPORT(d_str,1,'CND',11299);
838: end if;
839:
840: if (CZ_IMP_ALL.get_time) then
841: st_time := dbms_utility.get_time();
842: end if;
843:
844: CZ_IMP_IM_KRS.KRS_ITEM_TYPE_PROPERTY (inRUN_ID,COMMIT_SIZE,MAX_ERR,INSERTS,UPDATES,FAILED,DUPS,inXFR_GROUP);
845:

Line 847: end_time := dbms_utility.get_time();

843:
844: CZ_IMP_IM_KRS.KRS_ITEM_TYPE_PROPERTY (inRUN_ID,COMMIT_SIZE,MAX_ERR,INSERTS,UPDATES,FAILED,DUPS,inXFR_GROUP);
845:
846: if (CZ_IMP_ALL.get_time) then
847: end_time := dbms_utility.get_time();
848: d_str := inRun_id || ' KRS item type prop :' || (end_time-st_time)/100.00;
849: x_ERROR:=CZ_UTILS.LOG_REPORT(d_str,1,'KRS',11299);
850: end if;
851:

Line 853: st_time := dbms_utility.get_time();

849: x_ERROR:=CZ_UTILS.LOG_REPORT(d_str,1,'KRS',11299);
850: end if;
851:
852: if (CZ_IMP_ALL.get_time) then
853: st_time := dbms_utility.get_time();
854: end if;
855:
856: CZ_IMP_IM_XFR.XFR_ITEM_TYPE_PROPERTY (inRUN_ID,COMMIT_SIZE,MAX_ERR,nXfrInsertCount,nXfrUpdateCount,FAILED,inXFR_GROUP);
857:

Line 859: end_time := dbms_utility.get_time();

855:
856: CZ_IMP_IM_XFR.XFR_ITEM_TYPE_PROPERTY (inRUN_ID,COMMIT_SIZE,MAX_ERR,nXfrInsertCount,nXfrUpdateCount,FAILED,inXFR_GROUP);
857:
858: if (CZ_IMP_ALL.get_time) then
859: end_time := dbms_utility.get_time();
860: d_str := inRun_id || ' XFR item type prop :' || (end_time-st_time)/100.00;
861: x_ERROR:=CZ_UTILS.LOG_REPORT(d_str,1,'XFR',11299);
862: end if;
863:

Line 935: st_time := dbms_utility.get_time();

931: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IM_MAIN.MAIN_PROPERTY',11276,inRun_ID);
932: END;
933:
934: if (CZ_IMP_ALL.get_time) then
935: st_time := dbms_utility.get_time();
936: end if;
937:
938: CZ_IMP_IM_MAIN.CND_PROPERTY (inRun_ID,COMMIT_SIZE,MAX_ERR,FAILED);
939:

Line 941: end_time := dbms_utility.get_time();

937:
938: CZ_IMP_IM_MAIN.CND_PROPERTY (inRun_ID,COMMIT_SIZE,MAX_ERR,FAILED);
939:
940: if (CZ_IMP_ALL.get_time) then
941: end_time := dbms_utility.get_time();
942: d_str := inRun_id || ' CND property :' || (end_time-st_time)/100.00;
943: x_ERROR:=CZ_UTILS.LOG_REPORT(d_str,1,'CND',11299);
944: end if;
945:

Line 947: st_time := dbms_utility.get_time();

943: x_ERROR:=CZ_UTILS.LOG_REPORT(d_str,1,'CND',11299);
944: end if;
945:
946: if (CZ_IMP_ALL.get_time) then
947: st_time := dbms_utility.get_time();
948: end if;
949:
950: CZ_IMP_IM_KRS.KRS_PROPERTY (inRUN_ID,COMMIT_SIZE,MAX_ERR,INSERTS,UPDATES,FAILED,DUPS,NOCHANGE,inXFR_GROUP);
951:

Line 953: end_time := dbms_utility.get_time();

949:
950: CZ_IMP_IM_KRS.KRS_PROPERTY (inRUN_ID,COMMIT_SIZE,MAX_ERR,INSERTS,UPDATES,FAILED,DUPS,NOCHANGE,inXFR_GROUP);
951:
952: if (CZ_IMP_ALL.get_time) then
953: end_time := dbms_utility.get_time();
954: d_str := inRun_id || ' KRS property :' || (end_time-st_time)/100.00;
955: x_ERROR:=CZ_UTILS.LOG_REPORT(d_str,1,'KRS',11299);
956: end if;
957:

Line 959: st_time := dbms_utility.get_time();

955: x_ERROR:=CZ_UTILS.LOG_REPORT(d_str,1,'KRS',11299);
956: end if;
957:
958: if (CZ_IMP_ALL.get_time) then
959: st_time := dbms_utility.get_time();
960: end if;
961:
962: CZ_IMP_IM_XFR.XFR_PROPERTY (inRUN_ID,COMMIT_SIZE,MAX_ERR,nXfrInsertCount,nXfrUpdateCount,FAILED,nNoChangeCount,inXFR_GROUP, p_rp_folder_id);
963:

Line 965: end_time := dbms_utility.get_time();

961:
962: CZ_IMP_IM_XFR.XFR_PROPERTY (inRUN_ID,COMMIT_SIZE,MAX_ERR,nXfrInsertCount,nXfrUpdateCount,FAILED,nNoChangeCount,inXFR_GROUP, p_rp_folder_id);
963:
964: if (CZ_IMP_ALL.get_time) then
965: end_time := dbms_utility.get_time();
966: d_str := inRun_id || ' XFR property :' || (end_time-st_time)/100.00;
967: x_ERROR:=CZ_UTILS.LOG_REPORT(d_str,1,'XFR',11299);
968: end if;
969: