DBA Data[Home] [Help]

APPS.CZ_IMP_AC_MAIN SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 12

		SELECT DELETED_FLAG, ROWID FROM CZ_IMP_CONTACT WHERE REC_STATUS IS NULL
		AND RUN_ID = inRUN_ID;
Line: 34

		IF (p_imp_contact.DELETED_FLAG IS NULL) THEN
			BEGIN
				UPDATE CZ_IMP_CONTACT
				SET DELETED_FLAG=DECODE(DELETED_FLAG,NULL,'0',DELETED_FLAG)
				WHERE ROWID = p_imp_contact.ROWID;
Line: 73

		SELECT DELETED_FLAG, ROWID FROM CZ_IMP_CUSTOMER WHERE REC_STATUS IS NULL
		AND RUN_ID = inRUN_ID;
Line: 95

		IF (p_imp_customer.DELETED_FLAG IS NULL) THEN
			BEGIN
				UPDATE CZ_IMP_CUSTOMER
				SET DELETED_FLAG=DECODE(DELETED_FLAG,NULL,'0',DELETED_FLAG)
			WHERE ROWID = p_imp_customer.ROWID;
Line: 133

                        SELECT DELETED_FLAG, ROWID FROM CZ_IMP_ADDRESS WHERE REC_STATUS IS NULL AND RUN_ID = inRUN_ID;
Line: 154

		IF (p_imp_address.DELETED_FLAG IS NULL) THEN
			BEGIN
                                UPDATE CZ_IMP_ADDRESS SET DELETED_FLAG=DECODE(DELETED_FLAG,NULL,'0',DELETED_FLAG) WHERE ROWID = p_imp_address.ROWID;
Line: 189

      SELECT DELETED_FLAG, ROWID FROM CZ_IMP_ADDRESS_USE
      WHERE REC_STATUS IS NULL AND RUN_ID = inRUN_ID;
Line: 210

        IF(p_imp_address_uses.DELETED_FLAG IS NULL) THEN
          BEGIN
           UPDATE CZ_IMP_ADDRESS_USE
           SET DELETED_FLAG=DECODE(DELETED_FLAG,NULL,'0',DELETED_FLAG)
           WHERE ROWID = p_imp_address_uses.ROWID;
Line: 249

                        SELECT DELETED_FLAG, ROWID FROM CZ_IMP_CUSTOMER_END_USER WHERE REC_STATUS IS NULL AND RUN_ID = inRUN_ID;
Line: 270

		IF (p_imp_customerenduser.DELETED_FLAG IS NULL) THEN
			BEGIN
                                UPDATE CZ_IMP_CUSTOMER_END_USER SET DELETED_FLAG=DECODE(DELETED_FLAG,NULL,'0',DELETED_FLAG) WHERE ROWID = p_imp_customerenduser.ROWID;
Line: 306

                        SELECT DELETED_FLAG, ROWID FROM CZ_IMP_END_USER WHERE REC_STATUS IS NULL AND RUN_ID = inRUN_ID;
Line: 327

		IF (p_imp_enduser.DELETED_FLAG IS NULL) THEN
			BEGIN
                                UPDATE CZ_IMP_END_USER SET DELETED_FLAG=DECODE(DELETED_FLAG,NULL,'0',DELETED_FLAG) WHERE ROWID = p_imp_enduser.ROWID;
Line: 364

                        SELECT DELETED_FLAG, ROWID FROM CZ_IMP_END_USER_GROUP WHERE REC_STATUS IS NULL AND RUN_ID = inRUN_ID;
Line: 385

		IF (p_imp_endusergroup.DELETED_FLAG IS NULL) THEN
			BEGIN
                                UPDATE CZ_IMP_END_USER_GROUP SET DELETED_FLAG=DECODE(DELETED_FLAG,NULL,'0',DELETED_FLAG) WHERE ROWID = p_imp_endusergroup.ROWID;
Line: 423

                        SELECT DELETED_FLAG, ROWID FROM CZ_IMP_USER_GROUP WHERE REC_STATUS IS NULL AND RUN_ID = inRUN_ID;
Line: 444

		IF (p_imp_usergroup.DELETED_FLAG IS NULL) THEN
			BEGIN
                                UPDATE CZ_IMP_USER_GROUP SET DELETED_FLAG=DECODE(DELETED_FLAG,NULL,'0',DELETED_FLAG) WHERE ROWID = p_imp_usergroup.ROWID;
Line: 478

					INSERTS		IN   OUT NOCOPY PLS_INTEGER,
					UPDATES		IN OUT NOCOPY 	PLS_INTEGER,
					FAILED		IN   OUT NOCOPY PLS_INTEGER,
                                        DUPS            IN OUT NOCOPY  PLS_INTEGER,
                              inXFR_GROUP       IN    VARCHAR2
					) IS
BEGIN
	DECLARE
		/* Internal vars */
		nCommitCount						PLS_INTEGER:=0;			/*COMMIT buffer index */
Line: 489

		nXfrInsertCount						PLS_INTEGER:=0;			/*Inserts */
Line: 490

		nXfrUpdateCount						PLS_INTEGER:=0;			/*Updates */
Line: 499

           SELECT 'X' INTO dummy FROM CZ_XFR_RUN_INFOS WHERE RUN_ID=inRUN_ID;
Line: 501

           UPDATE CZ_XFR_RUN_INFOS SET
            STARTED=SYSDATE,
            LAST_ACTIVITY=SYSDATE
          WHERE RUN_ID=inRUN_ID;
Line: 508

           INSERT INTO CZ_XFR_RUN_INFOS (RUN_ID,STARTED,LAST_ACTIVITY)
           VALUES(inRUN_ID,SYSDATE,SYSDATE);
Line: 517

			INSERTS:=0;
Line: 518

			UPDATES:=0;
Line: 524

		CZ_IMP_AC_KRS.KRS_CONTACT (inRUN_ID,COMMIT_SIZE,MAX_ERR,INSERTS,UPDATES,nFailed,DUPS,inXFR_GROUP);
Line: 528

			CZ_IMP_AC_XFR.XFR_CONTACT (inRUN_ID,COMMIT_SIZE,MAX_ERR-nFailed,nXfrInsertCount,nXfrUpdateCount,FAILED,inXFR_GROUP);
Line: 529

			/* Report Insert Errors */
			IF (nXfrInsertCount<> INSERTS) THEN
	 			x_error:=CZ_IMP_ALL.REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_INSERTERRORS','RESOLVED',to_char(INSERTS),'ACTUAL',to_char(nXfrInsertCount)),1,'CZ_AC.MAIN_CONTACT',11276);
Line: 534

			/* Report Update Errors */
			IF (nXfrUpdateCount<> UPDATES) THEN
				x_error:=CZ_IMP_ALL.REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_UPDATEERRORS','RESOLVED',to_char(UPDATES),'ACTUAL',to_char(nXfrUpdateCount)),1,'CZ_AC.MAIN_CONTACT',11276);
Line: 540

			INSERTS:=nXfrInsertCount;
Line: 541

			UPDATES:=nXfrUpdateCount;
Line: 557

                                   INSERTS         IN OUT NOCOPY     PLS_INTEGER,
                                   UPDATES         IN OUT NOCOPY     PLS_INTEGER,
                                   FAILED          IN OUT NOCOPY     PLS_INTEGER,
                                   DUPS            IN OUT NOCOPY     PLS_INTEGER,
                              inXFR_GROUP       IN    VARCHAR2
                                   ) IS
BEGIN
   DECLARE
           /* Internal vars */
           nCommitCount                                            PLS_INTEGER:=0;                 /*COMMIT buffer index */
Line: 568

           nXfrInsertCount                                         PLS_INTEGER:=0;                 /*Inserts */
Line: 569

           nXfrUpdateCount                                         PLS_INTEGER:=0;                 /*Updates */
Line: 577

           SELECT 'X' INTO dummy FROM CZ_XFR_RUN_INFOS WHERE RUN_ID=inRUN_ID;
Line: 579

           UPDATE CZ_XFR_RUN_INFOS SET
            STARTED=SYSDATE,
            LAST_ACTIVITY=SYSDATE
          WHERE RUN_ID=inRUN_ID;
Line: 586

           INSERT INTO CZ_XFR_RUN_INFOS (RUN_ID,STARTED,LAST_ACTIVITY)
           VALUES(inRUN_ID,SYSDATE,SYSDATE);
Line: 595

                   INSERTS:=0;
Line: 596

                   UPDATES:=0;
Line: 601

           CZ_IMP_AC_KRS.KRS_CUSTOMER (inRUN_ID,COMMIT_SIZE,MAX_ERR,INSERTS,UPDATES,nFailed,DUPS,inXFR_GROUP);
Line: 604

                   CZ_IMP_AC_XFR.XFR_CUSTOMER (inRUN_ID,COMMIT_SIZE,MAX_ERR-nFailed,nXfrInsertCount,nXfrUpdateCount,FAILED,inXFR_GROUP);
Line: 605

                   /* Report Insert Errors */
                   IF (nXfrInsertCount<> INSERTS) THEN
                           x_error:=CZ_IMP_ALL.REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_INSERTERRORS','RESOLVED',to_char(INSERTS),'ACTUAL',to_char(nXfrInsertCount)),1,'CZ_IMP_AC.MAIN_CUSTOMER ',11276);
Line: 609

                   /* Report Update Errors */
                   IF (nXfrUpdateCount<> UPDATES) THEN
                           x_error:=CZ_IMP_ALL.REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_UPDATEERRORS','RESOLVED',to_char(UPDATES),'ACTUAL',to_char(nXfrUpdateCount)),1,'CZ_IMP_AC.MAIN_CUSTOMER ',11276);
Line: 614

                   INSERTS:=nXfrInsertCount;
Line: 615

                   UPDATES:=nXfrUpdateCount;
Line: 630

                                   INSERTS         IN OUT NOCOPY     PLS_INTEGER,
                                   UPDATES         IN OUT NOCOPY     PLS_INTEGER,
                                   FAILED          IN OUT NOCOPY     PLS_INTEGER,
                                   DUPS            IN OUT NOCOPY     PLS_INTEGER,
                              inXFR_GROUP       IN    VARCHAR2
                                   ) IS
BEGIN
   DECLARE
           /* Internal vars */
           nCommitCount                                            PLS_INTEGER:=0;                 /*COMMIT buffer index */
Line: 641

           nXfrInsertCount                                         PLS_INTEGER:=0;                 /*Inserts */
Line: 642

           nXfrUpdateCount                                         PLS_INTEGER:=0;                 /*Updates */
Line: 650

           SELECT 'X' INTO dummy FROM CZ_XFR_RUN_INFOS WHERE RUN_ID=inRUN_ID;
Line: 652

           UPDATE CZ_XFR_RUN_INFOS SET
            STARTED=SYSDATE,
            LAST_ACTIVITY=SYSDATE
          WHERE RUN_ID=inRUN_ID;
Line: 659

           INSERT INTO CZ_XFR_RUN_INFOS (RUN_ID,STARTED,LAST_ACTIVITY)
           VALUES(inRUN_ID,SYSDATE,SYSDATE);
Line: 668

                   INSERTS:=0;
Line: 669

                   UPDATES:=0;
Line: 674

           CZ_IMP_AC_KRS.KRS_ADDRESS (inRUN_ID,COMMIT_SIZE,MAX_ERR,INSERTS,UPDATES,nFailed,DUPS,inXFR_GROUP);
Line: 677

                   CZ_IMP_AC_XFR.XFR_ADDRESS (inRUN_ID,COMMIT_SIZE,MAX_ERR-nFailed,nXfrInsertCount,nXfrUpdateCount,FAILED,inXFR_GROUP);
Line: 678

                   /* Report Insert Errors */
                   IF (nXfrInsertCount<> INSERTS) THEN
                           x_error:=CZ_IMP_ALL.REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_INSERTERRORS','RESOLVED',to_char(INSERTS),'ACTUAL',to_char(nXfrInsertCount)),1,'CZ_IMP_AC.MAIN_ADDRESS ',11276);
Line: 682

                   /* Report Update Errors */
                   IF (nXfrUpdateCount<> UPDATES) THEN
                           x_error:=CZ_IMP_ALL.REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_UPDATEERRORS','RESOLVED',to_char(UPDATES),'ACTUAL',to_char(nXfrUpdateCount)),1,'CZ_IMP_AC.MAIN_ADDRESS ',11276);
Line: 687

                   INSERTS:=nXfrInsertCount;
Line: 688

                   UPDATES:=nXfrUpdateCount;
Line: 703

                            INSERTS     IN OUT NOCOPY PLS_INTEGER,
                            UPDATES     IN OUT NOCOPY PLS_INTEGER,
                            FAILED      IN OUT NOCOPY PLS_INTEGER,
                            DUPS        IN OUT NOCOPY PLS_INTEGER,
                              inXFR_GROUP       IN    VARCHAR2
                           ) IS
BEGIN
  DECLARE
    /* Internal vars */
    nCommitCount     PLS_INTEGER:=0; /* COMMIT buffer index */
Line: 714

    nXfrInsertCount  PLS_INTEGER:=0; /* Inserts */
Line: 715

    nXfrUpdateCount  PLS_INTEGER:=0; /* Updates */
Line: 723

           SELECT 'X' INTO dummy FROM CZ_XFR_RUN_INFOS WHERE RUN_ID=inRUN_ID;
Line: 725

           UPDATE CZ_XFR_RUN_INFOS SET
            STARTED=SYSDATE,
            LAST_ACTIVITY=SYSDATE
          WHERE RUN_ID=inRUN_ID;
Line: 732

           INSERT INTO CZ_XFR_RUN_INFOS (RUN_ID,STARTED,LAST_ACTIVITY)
           VALUES(inRUN_ID,SYSDATE,SYSDATE);
Line: 741

      INSERTS:=0;
Line: 742

      UPDATES:=0;
Line: 747

    CZ_IMP_AC_KRS.KRS_ADDRESS_USES(inRUN_ID,COMMIT_SIZE,MAX_ERR,INSERTS,UPDATES,nFailed,DUPS,inXFR_GROUP);
Line: 750

      CZ_IMP_AC_XFR.XFR_ADDRESS_USES(inRUN_ID,COMMIT_SIZE,MAX_ERR-nFailed,nXfrInsertCount,nXfrUpdateCount,FAILED,inXFR_GROUP);
Line: 751

      /* Report Insert Errors */
      IF(nXfrInsertCount<> INSERTS) THEN
        x_error:=CZ_IMP_ALL.REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_INSERTERRORS','RESOLVED',to_char(INSERTS),'ACTUAL',to_char(nXfrInsertCount)),1,'CZ_IMP_AC.MAIN_ADDRESS_USES ',11276);
Line: 755

      /* Report Update Errors */
      IF(nXfrUpdateCount<> UPDATES) THEN
        x_error:=CZ_IMP_ALL.REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_UPDATEERRORS','RESOLVED',to_char(UPDATES),'ACTUAL',to_char(nXfrUpdateCount)),1,'CZ_IMP_AC.MAIN_ADDRESS_USES ',11276);
Line: 760

     INSERTS:=nXfrInsertCount;
Line: 761

     UPDATES:=nXfrUpdateCount;
Line: 776

                                   INSERTS         IN OUT NOCOPY     PLS_INTEGER,
                                   UPDATES         IN OUT NOCOPY     PLS_INTEGER,
                                   FAILED          IN OUT NOCOPY     PLS_INTEGER,
                                   DUPS            IN OUT NOCOPY     PLS_INTEGER,
                              inXFR_GROUP       IN    VARCHAR2
                                   ) IS
BEGIN
   DECLARE
           /* Internal vars */
           nCommitCount                                            PLS_INTEGER:=0;                 /*COMMIT buffer index */
Line: 787

           nXfrInsertCount                                         PLS_INTEGER:=0;                 /*Inserts */
Line: 788

           nXfrUpdateCount                                         PLS_INTEGER:=0;                 /*Updates */
Line: 796

           SELECT 'X' INTO dummy FROM CZ_XFR_RUN_INFOS WHERE RUN_ID=inRUN_ID;
Line: 798

           UPDATE CZ_XFR_RUN_INFOS SET
            STARTED=SYSDATE,
            LAST_ACTIVITY=SYSDATE
          WHERE RUN_ID=inRUN_ID;
Line: 805

           INSERT INTO CZ_XFR_RUN_INFOS (RUN_ID,STARTED,LAST_ACTIVITY)
           VALUES(inRUN_ID,SYSDATE,SYSDATE);
Line: 814

                   INSERTS:=0;
Line: 815

                   UPDATES:=0;
Line: 820

           CZ_IMP_AC_KRS.KRS_CUSTOMER_END_USER (inRUN_ID,COMMIT_SIZE,MAX_ERR,INSERTS,UPDATES,nFailed,DUPS,inXFR_GROUP);
Line: 823

                   CZ_IMP_AC_XFR.XFR_CUSTOMER_END_USER (inRUN_ID,COMMIT_SIZE,MAX_ERR-nFailed,nXfrInsertCount,nXfrUpdateCount,FAILED,inXFR_GROUP);
Line: 824

                   /* Report Insert Errors */
                   IF (nXfrInsertCount<> INSERTS) THEN
                           x_error:=CZ_IMP_ALL.REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_INSERTERRORS','RESOLVED',to_char(INSERTS),'ACTUAL',to_char(nXfrInsertCount)),1,'CZ_IMP_AC.MAIN_CUSTOMER_END_USER ',11276);
Line: 828

                   /* Report Update Errors */
                   IF (nXfrUpdateCount<> UPDATES) THEN
                           x_error:=CZ_IMP_ALL.REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_UPDATEERRORS','RESOLVED',to_char(UPDATES),'ACTUAL',to_char(nXfrUpdateCount)),1,'CZ_IMP_AC.MAIN_CUSTOMER_END_USER ',11276);
Line: 833

                   INSERTS:=nXfrInsertCount;
Line: 834

                   UPDATES:=nXfrUpdateCount;
Line: 850

					INSERTS		IN   OUT NOCOPY PLS_INTEGER,
					UPDATES		IN OUT NOCOPY 	PLS_INTEGER,
					FAILED		IN   OUT NOCOPY PLS_INTEGER,
					DUPS			IN   OUT NOCOPY PLS_INTEGER,
                              inXFR_GROUP       IN    VARCHAR2
					) IS
BEGIN
	DECLARE
		/* Internal vars */
		nCommitCount						PLS_INTEGER:=0;			/*COMMIT buffer index */
Line: 861

		nXfrInsertCount						PLS_INTEGER:=0;			/*Inserts */
Line: 862

		nXfrUpdateCount						PLS_INTEGER:=0;			/*Updates */
Line: 871

           SELECT 'X' INTO dummy FROM CZ_XFR_RUN_INFOS WHERE RUN_ID=inRUN_ID;
Line: 873

           UPDATE CZ_XFR_RUN_INFOS SET
            STARTED=SYSDATE,
            LAST_ACTIVITY=SYSDATE
          WHERE RUN_ID=inRUN_ID;
Line: 880

           INSERT INTO CZ_XFR_RUN_INFOS (RUN_ID,STARTED,LAST_ACTIVITY)
           VALUES(inRUN_ID,SYSDATE,SYSDATE);
Line: 889

			INSERTS:=0;
Line: 890

			UPDATES:=0;
Line: 896

		CZ_IMP_AC_KRS.KRS_END_USER(inRUN_ID,COMMIT_SIZE,MAX_ERR,INSERTS,UPDATES,nFailed,DUPS,inXFR_GROUP);
Line: 900

			CZ_IMP_AC_XFR.XFR_END_USER(inRUN_ID,COMMIT_SIZE,MAX_ERR-nFailed,nXfrInsertCount,nXfrUpdateCount,FAILED,inXFR_GROUP);
Line: 901

			/* Report Insert Errors */
			IF (nXfrInsertCount<> INSERTS) THEN
	 			x_error:=CZ_IMP_ALL.REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_INSERTERRORS','RESOLVED',to_char(INSERTS),'ACTUAL',to_char(nXfrInsertCount)),1,'CZ_AC.MAIN_END_USER ',11276);
Line: 906

			/* Report Update Errors */
			IF (nXfrUpdateCount<> UPDATES) THEN
				x_error:=CZ_IMP_ALL.REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_UPDATEERRORS','RESOLVED',to_char(UPDATES),'ACTUAL',to_char(nXfrUpdateCount)),1,'CZ_AC.MAIN_END_USER ',11276);
Line: 912

			INSERTS:=nXfrInsertCount;
Line: 913

			UPDATES:=nXfrUpdateCount;
Line: 928

					INSERTS		IN   OUT NOCOPY PLS_INTEGER,
					UPDATES		IN OUT NOCOPY 	PLS_INTEGER,
					FAILED		IN   OUT NOCOPY PLS_INTEGER,
                                        DUPS            IN OUT NOCOPY  PLS_INTEGER,
                              inXFR_GROUP       IN    VARCHAR2
					) IS
BEGIN
	DECLARE
		/* Internal vars */
		nCommitCount						PLS_INTEGER:=0;			/*COMMIT buffer index */
Line: 939

		nXfrInsertCount						PLS_INTEGER:=0;			/*Inserts */
Line: 940

		nXfrUpdateCount						PLS_INTEGER:=0;			/*Updates */
Line: 949

           SELECT 'X' INTO dummy FROM CZ_XFR_RUN_INFOS WHERE RUN_ID=inRUN_ID;
Line: 951

           UPDATE CZ_XFR_RUN_INFOS SET
            STARTED=SYSDATE,
            LAST_ACTIVITY=SYSDATE
          WHERE RUN_ID=inRUN_ID;
Line: 958

           INSERT INTO CZ_XFR_RUN_INFOS (RUN_ID,STARTED,LAST_ACTIVITY)
           VALUES(inRUN_ID,SYSDATE,SYSDATE);
Line: 967

			INSERTS:=0;
Line: 968

			UPDATES:=0;
Line: 974

		CZ_IMP_AC_KRS.KRS_END_USER_GROUP(inRUN_ID,COMMIT_SIZE,MAX_ERR,INSERTS,UPDATES,nFailed,DUPS,inXFR_GROUP);
Line: 978

			CZ_IMP_AC_XFR.XFR_END_USER_GROUP(inRUN_ID,COMMIT_SIZE,MAX_ERR-nFailed,nXfrInsertCount,nXfrUpdateCount,FAILED,inXFR_GROUP);
Line: 979

			/* Report Insert Errors */
			IF (nXfrInsertCount<> INSERTS) THEN
	 			x_error:=CZ_IMP_ALL.REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_INSERTERRORS','RESOLVED',to_char(INSERTS),'ACTUAL',to_char(nXfrInsertCount)),1,'CZ_AC.MAIN_END_USER_GROUP ',11276);
Line: 984

			/* Report Update Errors */
			IF (nXfrUpdateCount<> UPDATES) THEN
				x_error:=CZ_IMP_ALL.REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_UPDATEERRORS','RESOLVED',to_char(UPDATES),'ACTUAL',to_char(nXfrUpdateCount)),1,'CZ_AC.MAIN_END_USER_GROUP ',11276);
Line: 990

			INSERTS:=nXfrInsertCount;
Line: 991

			UPDATES:=nXfrUpdateCount;
Line: 1008

					INSERTS		IN   OUT NOCOPY PLS_INTEGER,
					UPDATES		IN OUT NOCOPY 	PLS_INTEGER,
					FAILED		IN   OUT NOCOPY PLS_INTEGER,
					DUPS			IN   OUT NOCOPY PLS_INTEGER,
                              inXFR_GROUP       IN    VARCHAR2
					) IS
BEGIN
	DECLARE
		/* Internal vars */
		nCommitCount						PLS_INTEGER:=0;			/*COMMIT buffer index */
Line: 1019

		nXfrInsertCount						PLS_INTEGER:=0;			/*Inserts */
Line: 1020

		nXfrUpdateCount						PLS_INTEGER:=0;			/*Updates */
Line: 1029

           SELECT 'X' INTO dummy FROM CZ_XFR_RUN_INFOS WHERE RUN_ID=inRUN_ID;
Line: 1031

           UPDATE CZ_XFR_RUN_INFOS SET
            STARTED=SYSDATE,
            LAST_ACTIVITY=SYSDATE
          WHERE RUN_ID=inRUN_ID;
Line: 1038

           INSERT INTO CZ_XFR_RUN_INFOS (RUN_ID,STARTED,LAST_ACTIVITY)
           VALUES(inRUN_ID,SYSDATE,SYSDATE);
Line: 1047

			INSERTS:=0;
Line: 1048

			UPDATES:=0;
Line: 1054

		CZ_IMP_AC_KRS.KRS_USER_GROUP(inRUN_ID,COMMIT_SIZE,MAX_ERR,INSERTS,UPDATES,nFailed,DUPS,inXFR_GROUP);
Line: 1058

			CZ_IMP_AC_XFR.XFR_USER_GROUP (inRUN_ID,COMMIT_SIZE,MAX_ERR-nFailed,nXfrInsertCount,nXfrUpdateCount,FAILED,inXFR_GROUP);
Line: 1059

			/* Report Insert Errors */
			IF (nXfrInsertCount<> INSERTS) THEN
	 			x_error:=CZ_IMP_ALL.REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_INSERTERRORS','RESOLVED',to_char(INSERTS),'ACTUAL',to_char(nXfrInsertCount)),1,'CZ_AC.MAIN_USER_GROUP',11276);
Line: 1064

			/* Report Update Errors */
			IF (nXfrUpdateCount<> UPDATES) THEN
				x_error:=CZ_IMP_ALL.REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_UPDATEERRORS','RESOLVED',to_char(UPDATES),'ACTUAL',to_char(nXfrUpdateCount)),1,'CZ_AC.MAIN_USER_GROUP ',11276);
Line: 1070

			INSERTS:=nXfrInsertCount;
Line: 1071

			UPDATES:=nXfrUpdateCount;
Line: 1086

         DELETE FROM CZ_XFR_RUN_RESULTS WHERE RUN_ID=inRUN_ID AND IMP_TABLE='CZ_CONTACTS';
Line: 1094

                                SELECT DISPOSITION,REC_STATUS,COUNT(*)
                                  FROM cz_imp_contact
                                 WHERE RUN_ID = inRUN_ID
                              GROUP BY DISPOSITION,REC_STATUS;
Line: 1110

                     INSERT INTO CZ_XFR_RUN_RESULTS(RUN_ID,IMP_TABLE,DISPOSITION,REC_STATUS,RECORDS)
                     VALUES(inRUN_ID,'CZ_CONTACTS',ins_disposition,ins_rec_status,ins_rec_count);
Line: 1125

                SELECT SUM(NVL(RECORDS,0)) FROM CZ_XFR_RUN_RESULTS
                WHERE REC_STATUS<>'OK' AND RUN_ID=inRUN_ID
                AND IMP_TABLE='CZ_CONTACTS';
Line: 1132

                UPDATE CZ_XFR_RUN_INFOS
                 SET TOTAL_ERRORS=NVL(TOTAL_ERRORS,0)+NVL(nErrors,0),
                     COMPLETED='1'
                WHERE RUN_ID=inRUN_ID;
Line: 1151

         DELETE FROM CZ_XFR_RUN_RESULTS WHERE RUN_ID=inRUN_ID AND IMP_TABLE='CZ_CUSTOMERS';
Line: 1159

                                SELECT DISPOSITION,REC_STATUS,COUNT(*)
                                  FROM cz_imp_customer
                                 WHERE RUN_ID = inRUN_ID
                              GROUP BY DISPOSITION,REC_STATUS;
Line: 1175

                     INSERT INTO CZ_XFR_RUN_RESULTS(RUN_ID,IMP_TABLE,DISPOSITION,REC_STATUS,RECORDS)
                     VALUES(inRUN_ID,'CZ_CUSTOMERS',ins_disposition,ins_rec_status,ins_rec_count);
Line: 1190

                SELECT SUM(NVL(RECORDS,0)) FROM CZ_XFR_RUN_RESULTS
                WHERE REC_STATUS<>'OK' AND RUN_ID=inRUN_ID
                AND IMP_TABLE='CZ_CUSTOMERS';
Line: 1197

                UPDATE CZ_XFR_RUN_INFOS
                 SET TOTAL_ERRORS=NVL(TOTAL_ERRORS,0)+NVL(nErrors,0),
                     COMPLETED='1'
                WHERE RUN_ID=inRUN_ID;
Line: 1216

         DELETE FROM CZ_XFR_RUN_RESULTS WHERE RUN_ID=inRUN_ID AND IMP_TABLE='CZ_ADDRESSES';
Line: 1224

                                SELECT DISPOSITION,REC_STATUS,COUNT(*)
                                  FROM cz_imp_address
                                 WHERE RUN_ID = inRUN_ID
                              GROUP BY DISPOSITION,REC_STATUS;
Line: 1240

                     INSERT INTO CZ_XFR_RUN_RESULTS(RUN_ID,IMP_TABLE,DISPOSITION,REC_STATUS,RECORDS)
                     VALUES(inRUN_ID,'CZ_ADDRESSES',ins_disposition,ins_rec_status,ins_rec_count);
Line: 1255

                SELECT SUM(NVL(RECORDS,0)) FROM CZ_XFR_RUN_RESULTS
                WHERE REC_STATUS<>'OK' AND RUN_ID=inRUN_ID
                AND IMP_TABLE='CZ_ADDRESSES';
Line: 1262

                UPDATE CZ_XFR_RUN_INFOS
                 SET TOTAL_ERRORS=NVL(TOTAL_ERRORS,0)+NVL(nErrors,0),
                     COMPLETED='1'
                WHERE RUN_ID=inRUN_ID;
Line: 1280

         DELETE FROM CZ_XFR_RUN_RESULTS WHERE RUN_ID=inRUN_ID AND IMP_TABLE='CZ_ADDRESS_USES';
Line: 1288

                                SELECT DISPOSITION,REC_STATUS,COUNT(*)
                                  FROM cz_imp_address_use
                                 WHERE RUN_ID = inRUN_ID
                              GROUP BY DISPOSITION,REC_STATUS;
Line: 1304

                     INSERT INTO CZ_XFR_RUN_RESULTS(RUN_ID,IMP_TABLE,DISPOSITION,REC_STATUS,RECORDS)
                     VALUES(inRUN_ID,'CZ_ADDRESS_USES',ins_disposition,ins_rec_status,ins_rec_count);
Line: 1319

                SELECT SUM(NVL(RECORDS,0)) FROM CZ_XFR_RUN_RESULTS
                WHERE REC_STATUS<>'OK' AND RUN_ID=inRUN_ID
                AND IMP_TABLE='CZ_ADDRESS_USES';
Line: 1326

                UPDATE CZ_XFR_RUN_INFOS
                 SET TOTAL_ERRORS=NVL(TOTAL_ERRORS,0)+NVL(nErrors,0),
                     COMPLETED='1'
                WHERE RUN_ID=inRUN_ID;
Line: 1345

         DELETE FROM CZ_XFR_RUN_RESULTS WHERE RUN_ID=inRUN_ID AND IMP_TABLE='CZ_CUSTOMER_END_USERS';
Line: 1353

                                SELECT DISPOSITION,REC_STATUS,COUNT(*)
                                  FROM cz_imp_customer_end_user
                                 WHERE RUN_ID = inRUN_ID
                              GROUP BY DISPOSITION,REC_STATUS;
Line: 1369

                     INSERT INTO CZ_XFR_RUN_RESULTS(RUN_ID,IMP_TABLE,DISPOSITION,REC_STATUS,RECORDS)
                     VALUES(inRUN_ID,'CZ_CUSTOMER_END_USERS',ins_disposition,ins_rec_status,ins_rec_count);
Line: 1384

                SELECT SUM(NVL(RECORDS,0)) FROM CZ_XFR_RUN_RESULTS
                WHERE REC_STATUS<>'OK' AND RUN_ID=inRUN_ID
                AND IMP_TABLE='CZ_CUSTOMER_END_USERS';
Line: 1391

                UPDATE CZ_XFR_RUN_INFOS
                 SET TOTAL_ERRORS=NVL(TOTAL_ERRORS,0)+NVL(nErrors,0),
                     COMPLETED='1'
                WHERE RUN_ID=inRUN_ID;
Line: 1410

         DELETE FROM CZ_XFR_RUN_RESULTS WHERE RUN_ID=inRUN_ID AND IMP_TABLE='CZ_END_USERS';
Line: 1418

                                SELECT DISPOSITION,REC_STATUS,COUNT(*)
                                  FROM cz_imp_end_user
                                 WHERE RUN_ID = inRUN_ID
                              GROUP BY DISPOSITION,REC_STATUS;
Line: 1434

                     INSERT INTO CZ_XFR_RUN_RESULTS(RUN_ID,IMP_TABLE,DISPOSITION,REC_STATUS,RECORDS)
                     VALUES(inRUN_ID,'CZ_END_USERS',ins_disposition,ins_rec_status,ins_rec_count);
Line: 1449

                SELECT SUM(NVL(RECORDS,0)) FROM CZ_XFR_RUN_RESULTS
                WHERE REC_STATUS<>'OK' AND RUN_ID=inRUN_ID
                AND IMP_TABLE='CZ_END_USERS';
Line: 1456

                UPDATE CZ_XFR_RUN_INFOS
                 SET TOTAL_ERRORS=NVL(TOTAL_ERRORS,0)+NVL(nErrors,0),
                     COMPLETED='1'
                WHERE RUN_ID=inRUN_ID;
Line: 1475

         DELETE FROM CZ_XFR_RUN_RESULTS WHERE RUN_ID=inRUN_ID AND IMP_TABLE='CZ_END_USER_GROUPS';
Line: 1483

                                SELECT DISPOSITION,REC_STATUS,COUNT(*)
                                  FROM cz_imp_end_user_group
                                 WHERE RUN_ID = inRUN_ID
                              GROUP BY DISPOSITION,REC_STATUS;
Line: 1499

                     INSERT INTO CZ_XFR_RUN_RESULTS(RUN_ID,IMP_TABLE,DISPOSITION,REC_STATUS,RECORDS)
                     VALUES(inRUN_ID,'CZ_END_USER_GROUPS',ins_disposition,ins_rec_status,ins_rec_count);
Line: 1514

                SELECT SUM(NVL(RECORDS,0)) FROM CZ_XFR_RUN_RESULTS
                WHERE REC_STATUS<>'OK' AND RUN_ID=inRUN_ID
                AND IMP_TABLE='CZ_END_USER_GROUPS';
Line: 1521

                UPDATE CZ_XFR_RUN_INFOS
                 SET TOTAL_ERRORS=NVL(TOTAL_ERRORS,0)+NVL(nErrors,0),
                     COMPLETED='1'
                WHERE RUN_ID=inRUN_ID;
Line: 1540

         DELETE FROM CZ_XFR_RUN_RESULTS WHERE RUN_ID=inRUN_ID AND IMP_TABLE='CZ_USER_GROUPS';
Line: 1548

                                SELECT DISPOSITION,REC_STATUS,COUNT(*)
                                  FROM cz_imp_user_group
                                 WHERE RUN_ID = inRUN_ID
                              GROUP BY DISPOSITION,REC_STATUS;
Line: 1564

                     INSERT INTO CZ_XFR_RUN_RESULTS(RUN_ID,IMP_TABLE,DISPOSITION,REC_STATUS,RECORDS)
                     VALUES(inRUN_ID,'CZ_USER_GROUPS',ins_disposition,ins_rec_status,ins_rec_count);
Line: 1579

                SELECT SUM(NVL(RECORDS,0)) FROM CZ_XFR_RUN_RESULTS
                WHERE REC_STATUS<>'OK' AND RUN_ID=inRUN_ID
                AND IMP_TABLE='CZ_USER_GROUPS';
Line: 1586

                UPDATE CZ_XFR_RUN_INFOS
                 SET TOTAL_ERRORS=NVL(TOTAL_ERRORS,0)+NVL(nErrors,0),
                     COMPLETED='1'
                WHERE RUN_ID=inRUN_ID;