DBA Data[Home] [Help]

APPS.CZ_IMP_IM_MAIN SQL Statements

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

Line: 13

                        SELECT DELETED_FLAG, SRC_APPLICATION_ID, SRC_TYPE_CODE, DECIMAL_QTY_FLAG, ROWID
                        FROM CZ_IMP_ITEM_MASTER
                        WHERE REC_STATUS IS NULL
                        AND RUN_ID = inRUN_ID;
Line: 41

	IF (p_imp_itemmaster.DELETED_FLAG IS NULL) THEN
 		 BEGIN
                   UPDATE CZ_IMP_ITEM_MASTER
                   SET DELETED_FLAG=DECODE(DELETED_FLAG,NULL,'0',DELETED_FLAG)
                   WHERE ROWID = p_imp_itemmaster.ROWID;
Line: 61

                   UPDATE CZ_IMP_ITEM_MASTER SET DECIMAL_QTY_FLAG = '0'
                   WHERE ROWID = p_imp_itemmaster.ROWID;
Line: 79

                   UPDATE CZ_IMP_ITEM_MASTER
                   SET DELETED_FLAG=DECODE(DELETED_FLAG,NULL,'0',DELETED_FLAG),
                       SRC_APPLICATION_ID = cnDefSrcAppId,
                       SRC_TYPE_CODE = cnDefSrcTypeCode
                   WHERE ROWID = p_imp_itemmaster.ROWID;
Line: 97

                   UPDATE CZ_IMP_ITEM_MASTER
                   SET DELETED_FLAG=DECODE(DELETED_FLAG,NULL,'0',DELETED_FLAG),
                       SRC_APPLICATION_ID = cnDefSrcAppId
                   WHERE ROWID = p_imp_itemmaster.ROWID;
Line: 114

                   UPDATE CZ_IMP_ITEM_MASTER
                   SET DELETED_FLAG=DECODE(DELETED_FLAG,NULL,'0',DELETED_FLAG),
                       SRC_TYPE_CODE = cnDefSrcTypeCode
                   WHERE ROWID = p_imp_itemmaster.ROWID;
Line: 151

        SELECT a.DELETED_FLAG,a.PROPERTY_VALUE,a.PROPERTY_NUM_VALUE,
        a.FSK_PROPERTY_1_1,a.FSK_PROPERTY_1_EXT,a.ORIG_SYS_REF,a.DISPOSITION,a.REC_STATUS,b.data_type
        FROM CZ_IMP_ITEM_PROPERTY_VALUE a, cz_properties b
        WHERE a.REC_STATUS IS NULL AND a.RUN_ID = inRUN_ID
        AND (b.orig_sys_ref = a.fsk_property_1_1 OR b.orig_sys_ref = a.fsk_property_1_ext)
        AND b.deleted_flag='0';
Line: 175

        TYPE tDeletedFlag      IS TABLE OF cz_imp_item_property_value.deleted_flag%TYPE INDEX BY BINARY_INTEGER;
Line: 187

        iDeletedFlag           tDeletedFlag;
Line: 193

        insert_end_time        NUMBER;
Line: 198

       iDeletedFlag.delete;               iFskProperty.delete;
Line: 199

       iPropertyValue.delete;             iRecStatus.delete;
Line: 200

       iPropertyNumValue.delete;          iDisposition.delete;
Line: 201

       iFskPropertyExt.delete;            iDataType.delete;
Line: 204

       iDeletedFlag,iPropertyValue,iPropertyNumValue,
       iFskProperty,iFskPropertyExt,iOrigSysRef,iDisposition,iRecStatus,iDataType
       LIMIT COMMIT_SIZE;
Line: 207

       EXIT WHEN iDeletedFlag.COUNT = 0 AND c_imp_itempropertyvalue%NOTFOUND;
Line: 209

       IF iDeletedFlag.COUNT > 0 THEN

            IF (FAILED >= MAX_ERR) THEN
              x_error:=CZ_UTILS.LOG_REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_MAXERR_REACHED'),1,
                                          'CZ_IMP_IM_MAIN.CND_ITEM_PROPERTY_VALUE:MAX',11276,inRun_Id);
Line: 216

            FOR i IN iDeletedFlag.FIRST..iDeletedFlag.LAST LOOP
                IF iDeletedFlag(i) IS NULL THEN
                  iDeletedFlag(i) := '0';
Line: 245

            FORALL i IN iDeletedFlag.FIRST..iDeletedFlag.LAST
                 UPDATE cz_imp_item_property_value
                    SET deleted_flag = iDeletedFlag(i),
                        property_value = iPropertyValue(i),
                        property_num_value = iPropertyNumValue(i),
                        disposition = iDisposition(i),
                        rec_status = iRecStatus(i)
                  WHERE orig_sys_ref = iOrigSysRef(i)
                    AND run_id = inRun_id
                    AND rec_status IS NULL;
Line: 275

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

		IF (p_imp_itemtype.DELETED_FLAG IS NULL) THEN
			BEGIN
                                UPDATE CZ_IMP_ITEM_TYPE SET DELETED_FLAG=DECODE(DELETED_FLAG,NULL,'0',DELETED_FLAG) WHERE ROWID = p_imp_itemtype.ROWID;
Line: 337

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

		IF (p_imp_itemtypeprop.DELETED_FLAG IS NULL) THEN
			BEGIN
                                UPDATE CZ_IMP_ITEM_TYPE_PROPERTY SET DELETED_FLAG=DECODE(DELETED_FLAG,NULL,'0',DELETED_FLAG) WHERE ROWID = p_imp_itemtypeprop.ROWID;
Line: 401

                        SELECT DELETED_FLAG, DATA_TYPE, ROWID
                        FROM CZ_IMP_property WHERE REC_STATUS IS NULL AND RUN_ID = inRUN_ID;
Line: 427

		IF (p_imp_property.DELETED_FLAG IS NULL) THEN
 		 BEGIN
                  UPDATE CZ_IMP_property SET DELETED_FLAG=DECODE(DELETED_FLAG,NULL,'0',DELETED_FLAG) WHERE ROWID = p_imp_property.ROWID;
Line: 446

                  UPDATE CZ_IMP_property SET DATA_TYPE = 4 WHERE ROWID = p_imp_property.ROWID;
Line: 476

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

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

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

   insert_end_time  number;
Line: 504

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

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

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

		CZ_IMP_IM_KRS.KRS_ITEM_MASTER (inRUN_ID,COMMIT_SIZE,MAX_ERR,INSERTS,UPDATES,FAILED,DUPS,NOCHANGE,inXFR_GROUP);
Line: 548

			CZ_IMP_IM_XFR.XFR_ITEM_MASTER (inRUN_ID,COMMIT_SIZE,MAX_ERR,nXfrInsertCount,nXfrUpdateCount,FAILED,nNoChangeCount,inXFR_GROUP);
Line: 556

			/* Report Insert Errors */
			IF (nXfrInsertCount<> INSERTS) THEN
	 			x_error:=CZ_UTILS.LOG_REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_INSERTERRORS','RESOLVED',to_char(INSERTS),'ACTUAL',to_char(nXfrInsertCount)),1,'IMP_IM.MAIN_ITEM_MASTER ',11276,inRun_ID);
Line: 561

			/* Report Update Errors */
			IF (nXfrUpdateCount<> UPDATES) THEN
				x_error:=CZ_UTILS.LOG_REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_UPDATEERRORS','RESOLVED',to_char(UPDATES),'ACTUAL',to_char(nXfrUpdateCount)),1,'IMP_IM.MAIN_ITEM_MASTER ',11276,inRun_ID);
Line: 567

			INSERTS:=nXfrInsertCount;
Line: 568

			UPDATES:=nXfrUpdateCount;
Line: 580

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

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

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

   insert_end_time  number;
Line: 608

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

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

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

		CZ_IMP_IM_KRS.KRS_ITEM_PROPERTY_VALUE (inRUN_ID,COMMIT_SIZE,MAX_ERR,INSERTS,UPDATES,FAILED,DUPS,nNoChangeCount,inXFR_GROUP);
Line: 653

			CZ_IMP_IM_XFR.XFR_ITEM_PROPERTY_VALUE(inRUN_ID,COMMIT_SIZE,MAX_ERR,nXfrInsertCount,nXfrUpdateCount,FAILED,nNoChangeCount,inXFR_GROUP);
Line: 661

			/* Report Insert Errors */
			IF (nXfrInsertCount<> INSERTS) THEN
	 			x_error:=CZ_UTILS.LOG_REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_INSERTERRORS','RESOLVED',to_char(INSERTS),'ACTUAL',to_char(nXfrInsertCount)),1,'CZ_IM_MAIN.MAIN_ITEM_PROPERTY_VALUE',11276,inRun_ID);
Line: 666

			/* Report Update Errors */
			IF (nXfrUpdateCount<> UPDATES) THEN
				x_error:=CZ_UTILS.LOG_REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_UPDATEERRORS','RESOLVED',to_char(UPDATES),'ACTUAL',to_char(nXfrUpdateCount)),1,'CZ_IM_MAIN.MAIN_ITEM_PROPERTY_VALUE',11276,inRun_ID);
Line: 672

			INSERTS:=nXfrInsertCount;
Line: 673

			UPDATES:=nXfrUpdateCount;
Line: 684

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

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

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

   insert_end_time  number;
Line: 712

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

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

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

		CZ_IMP_IM_KRS.KRS_ITEM_TYPE (inRUN_ID,COMMIT_SIZE,MAX_ERR,INSERTS,UPDATES,FAILED,DUPS,NOCHANGE,inXFR_GROUP);
Line: 754

			CZ_IMP_IM_XFR.XFR_ITEM_TYPE  (inRUN_ID,COMMIT_SIZE,MAX_ERR,nXfrInsertCount,nXfrUpdateCount,FAILED,nNoChangeCount,inXFR_GROUP);
Line: 762

			/* Report Insert Errors */
			IF (nXfrInsertCount<> INSERTS) THEN
	 			x_error:=CZ_UTILS.LOG_REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_INSERTERRORS','RESOLVED',to_char(INSERTS),'ACTUAL',to_char(nXfrInsertCount)),1,'CZ_IM_MAIN.MAIN_ITEM_TYPE',11276,inRun_ID);
Line: 767

			/* Report Update Errors */
			IF (nXfrUpdateCount<> UPDATES) THEN
				x_error:=CZ_UTILS.LOG_REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_UPDATEERRORS','RESOLVED',to_char(UPDATES),'ACTUAL',to_char(nXfrUpdateCount)),1,'CZ_IM_MAIN.MAIN_ITEM_TYPE',11276,inRun_ID);
Line: 773

			INSERTS:=nXfrInsertCount;
Line: 774

			UPDATES:=nXfrUpdateCount;
Line: 786

					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: 797

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

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

   insert_end_time  number;
Line: 812

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

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

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

		CZ_IMP_IM_KRS.KRS_ITEM_TYPE_PROPERTY (inRUN_ID,COMMIT_SIZE,MAX_ERR,INSERTS,UPDATES,FAILED,DUPS,inXFR_GROUP);
Line: 856

			CZ_IMP_IM_XFR.XFR_ITEM_TYPE_PROPERTY (inRUN_ID,COMMIT_SIZE,MAX_ERR,nXfrInsertCount,nXfrUpdateCount,FAILED,inXFR_GROUP);
Line: 864

			/* Report Insert Errors */
			IF (nXfrInsertCount<> INSERTS) THEN
	 			x_error:=CZ_UTILS.LOG_REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_INSERTERRORS','RESOLVED',to_char(INSERTS),'ACTUAL',to_char(nXfrInsertCount)),1,'CZ_IM_MAIN.MAIN_ITEM_TYPE_PROPERTY',11276,inRun_ID);
Line: 869

			/* Report Update Errors */
			IF (nXfrUpdateCount<> UPDATES) THEN
				x_error:=CZ_UTILS.LOG_REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_UPDATEERRORS','RESOLVED',to_char(UPDATES),'ACTUAL',to_char(nXfrUpdateCount)),1,'CZ_IM_MAIN.MAIN_ITEM_TYPE_PROPERTY',11276,inRun_ID);
Line: 875

			INSERTS:=nXfrInsertCount;
Line: 876

			UPDATES:=nXfrUpdateCount;
Line: 889

					INSERTS		IN   OUT NOCOPY PLS_INTEGER,
					UPDATES		IN OUT NOCOPY 	PLS_INTEGER,
					FAILED		IN   OUT NOCOPY PLS_INTEGER,
					DUPS	        IN   OUT NOCOPY PLS_INTEGER,
                                        NOCHANGE IN   OUT NOCOPY PLS_INTEGER,
                              inXFR_GROUP       IN    VARCHAR2,
                                        p_rp_folder_id IN  NUMBER
					) IS
BEGIN
	DECLARE
		/* Interal vars */
		nCommitCount						PLS_INTEGER:=0;			/*COMMIT buffer index */
Line: 902

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

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

   insert_end_time  number;
Line: 918

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

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

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

		CZ_IMP_IM_KRS.KRS_PROPERTY (inRUN_ID,COMMIT_SIZE,MAX_ERR,INSERTS,UPDATES,FAILED,DUPS,NOCHANGE,inXFR_GROUP);
Line: 962

			CZ_IMP_IM_XFR.XFR_PROPERTY (inRUN_ID,COMMIT_SIZE,MAX_ERR,nXfrInsertCount,nXfrUpdateCount,FAILED,nNoChangeCount,inXFR_GROUP, p_rp_folder_id);
Line: 970

			/* Report Insert Errors */
			IF (nXfrInsertCount<> INSERTS) THEN
	 			x_error:=CZ_UTILS.LOG_REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_INSERTERRORS','RESOLVED',to_char(INSERTS),'ACTUAL',to_char(nXfrInsertCount)),1,'CZ_IM_MAIN.MAIN_PROPERTY',11276,inRun_ID);
Line: 975

			/* Report Update Errors */
			IF (nXfrUpdateCount<> UPDATES) THEN
				x_error:=CZ_UTILS.LOG_REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_UPDATEERRORS','RESOLVED',to_char(UPDATES),'ACTUAL',to_char(nXfrUpdateCount)),1,'CZ_IM_MAIN.MAIN_PROPERTY',11276,inRun_ID);
Line: 981

			INSERTS:=nXfrInsertCount;
Line: 982

			UPDATES:=nXfrUpdateCount;
Line: 998

         DELETE FROM CZ_XFR_RUN_RESULTS WHERE RUN_ID=inRUN_ID AND IMP_TABLE=v_table_name;
Line: 1006

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

                     INSERT INTO CZ_XFR_RUN_RESULTS(RUN_ID,IMP_TABLE,DISPOSITION,REC_STATUS,RECORDS)
                     VALUES(inRUN_ID,v_table_name,ins_disposition,ins_rec_status,ins_rec_count);
Line: 1037

                SELECT SUM(NVL(RECORDS,0)) FROM CZ_XFR_RUN_RESULTS
                WHERE REC_STATUS<>v_ok AND RUN_ID=inRUN_ID
                AND IMP_TABLE=v_table_name;
Line: 1044

                UPDATE CZ_XFR_RUN_INFOS
                 SET TOTAL_ERRORS=NVL(TOTAL_ERRORS,0)+NVL(nErrors,0),
                     COMPLETED=v_completed
                WHERE RUN_ID=inRUN_ID;
Line: 1069

         DELETE FROM CZ_XFR_RUN_RESULTS WHERE RUN_ID=inRUN_ID AND IMP_TABLE=v_table_name;
Line: 1077

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

                     INSERT INTO CZ_XFR_RUN_RESULTS(RUN_ID,IMP_TABLE,DISPOSITION,REC_STATUS,RECORDS)
                     VALUES(inRUN_ID,v_table_name,ins_disposition,ins_rec_status,ins_rec_count);
Line: 1108

                SELECT SUM(NVL(RECORDS,0)) FROM CZ_XFR_RUN_RESULTS
                WHERE REC_STATUS<>v_ok AND RUN_ID=inRUN_ID
                AND IMP_TABLE=v_table_name;
Line: 1115

                UPDATE CZ_XFR_RUN_INFOS
                 SET TOTAL_ERRORS=NVL(TOTAL_ERRORS,0)+NVL(nErrors,0),
                     COMPLETED=v_completed
                WHERE RUN_ID=inRUN_ID;
Line: 1139

         DELETE FROM CZ_XFR_RUN_RESULTS WHERE RUN_ID=inRUN_ID AND IMP_TABLE=v_table_name;
Line: 1147

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

                     INSERT INTO CZ_XFR_RUN_RESULTS(RUN_ID,IMP_TABLE,DISPOSITION,REC_STATUS,RECORDS)
                     VALUES(inRUN_ID,v_table_name,ins_disposition,ins_rec_status,ins_rec_count);
Line: 1178

                SELECT SUM(NVL(RECORDS,0)) FROM CZ_XFR_RUN_RESULTS
                WHERE REC_STATUS<>v_ok AND RUN_ID=inRUN_ID
                AND IMP_TABLE=v_table_name;
Line: 1185

                UPDATE CZ_XFR_RUN_INFOS
                 SET TOTAL_ERRORS=NVL(TOTAL_ERRORS,0)+NVL(nErrors,0),
                     COMPLETED=v_completed
                WHERE RUN_ID=inRUN_ID;
Line: 1210

         DELETE FROM CZ_XFR_RUN_RESULTS WHERE RUN_ID=inRUN_ID AND IMP_TABLE=v_table_name;
Line: 1218

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

                     INSERT INTO CZ_XFR_RUN_RESULTS(RUN_ID,IMP_TABLE,DISPOSITION,REC_STATUS,RECORDS)
                     VALUES(inRUN_ID,v_table_name,ins_disposition,ins_rec_status,ins_rec_count);
Line: 1249

                SELECT SUM(NVL(RECORDS,0)) FROM CZ_XFR_RUN_RESULTS
                WHERE REC_STATUS<>v_ok AND RUN_ID=inRUN_ID
                AND IMP_TABLE=v_table_name;
Line: 1256

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

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

                                SELECT DISPOSITION,REC_STATUS,COUNT(*)
                                  FROM CZ_IMP_property
                                 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,v_table_name,ins_disposition,ins_rec_status,ins_rec_count);
Line: 1319

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

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