DBA Data[Home] [Help]

APPS.CZ_IMP_IM_XFR SQL Statements

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

Line: 10

					INSERTS		   OUT NOCOPY PLS_INTEGER,
					UPDATES		   OUT NOCOPY PLS_INTEGER,
                                        FAILED		IN OUT NOCOPY PLS_INTEGER,
                                        NOCHANGE  OUT NOCOPY PLS_INTEGER,
                                        inXFR_GROUP     IN     VARCHAR2
					) IS
BEGIN
		DECLARE CURSOR c_xfr_itemmaster IS
		 SELECT ITEM_ID,ITEM_TYPE_ID,DESC_TEXT,REF_PART_NBR,QUOTEABLE_FLAG,
                    LEAD_TIME,ITEM_STATUS,RUN_ID,REC_STATUS,DISPOSITION,DELETED_FLAG,
                    CHECKOUT_USER,USER_STR01,USER_STR02,
                    USER_STR03,USER_STR04,USER_NUM01,USER_NUM02,USER_NUM03,USER_NUM04,
                    ORIG_SYS_REF,PRIMARY_UOM_CODE,DECIMAL_QTY_FLAG,
                    SRC_APPLICATION_ID, SRC_TYPE_CODE
             FROM CZ_IMP_ITEM_MASTER
             WHERE CZ_IMP_ITEM_MASTER.RUN_ID = inRUN_ID AND REC_STATUS='PASS';
Line: 34

			nInsertCount		PLS_INTEGER:=0;			/*Inserts */
Line: 35

			nUpdateCount		PLS_INTEGER:=0;			/*Updates */
Line: 38

			NOUPDATE_DESC_TEXT               NUMBER;
Line: 39

			NOUPDATE_REF_PART_NBR            NUMBER;
Line: 40

			NOUPDATE_ORIG_SYS_REF            NUMBER;
Line: 41

			NOUPDATE_QUOTEABLE_FLAG          NUMBER;
Line: 42

			NOUPDATE_LEAD_TIME               NUMBER;
Line: 43

			NOUPDATE_ITEM_STATUS             NUMBER;
Line: 44

			NOUPDATE_DELETED_FLAG            NUMBER;
Line: 45

			NOUPDATE_USER_STR01              NUMBER;
Line: 46

			NOUPDATE_USER_STR02              NUMBER;
Line: 47

			NOUPDATE_USER_STR03              NUMBER;
Line: 48

			NOUPDATE_USER_STR04              NUMBER;
Line: 49

			NOUPDATE_USER_NUM01              NUMBER;
Line: 50

			NOUPDATE_USER_NUM02              NUMBER;
Line: 51

			NOUPDATE_USER_NUM03              NUMBER;
Line: 52

			NOUPDATE_USER_NUM04              NUMBER;
Line: 53

			NOUPDATE_CREATION_DATE                 NUMBER;
Line: 54

			NOUPDATE_LAST_UPDATE_DATE                NUMBER;
Line: 55

			NOUPDATE_CREATED_BY              NUMBER;
Line: 56

			NOUPDATE_LAST_UPDATED_BY             NUMBER;
Line: 57

			NOUPDATE_SECURITY_MASK           NUMBER;
Line: 58

                        NOUPDATE_CHECKOUT_USER           NUMBER;
Line: 59

                        NOUPDATE_PRIMARY_UOM_CODE        NUMBER;
Line: 60

                  NOUPDATE_ITEM_TYPE_ID                  NUMBER;
Line: 61

                  NOUPDATE_DECIMAL_QTY_FLAG              NUMBER;
Line: 66

		-- Get the Update Flags for each column
                        NOUPDATE_DESC_TEXT               := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ITEM_MASTERS','DESC_TEXT',inXFR_GROUP);
Line: 68

                        NOUPDATE_REF_PART_NBR            := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ITEM_MASTERS','REF_PART_NBR',inXFR_GROUP);
Line: 69

			NOUPDATE_ORIG_SYS_REF            := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ITEM_MASTERS','ORIG_SYS_REF',inXFR_GROUP);
Line: 70

                        NOUPDATE_QUOTEABLE_FLAG          := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ITEM_MASTERS','QUOTEABLE_FLAG',inXFR_GROUP);
Line: 71

                        NOUPDATE_LEAD_TIME               := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ITEM_MASTERS','LEAD_TIME',inXFR_GROUP);
Line: 72

			NOUPDATE_ITEM_STATUS             := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ITEM_MASTERS','ITEM_STATUS',inXFR_GROUP);
Line: 73

			NOUPDATE_DELETED_FLAG            := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ITEM_MASTERS','DELETED_FLAG',inXFR_GROUP);
Line: 74

			NOUPDATE_USER_STR01              := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ITEM_MASTERS','USER_STR01',inXFR_GROUP);
Line: 75

			NOUPDATE_USER_STR02              := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ITEM_MASTERS','USER_STR02',inXFR_GROUP);
Line: 76

			NOUPDATE_USER_STR03              := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ITEM_MASTERS','USER_STR03',inXFR_GROUP);
Line: 77

			NOUPDATE_USER_STR04              := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ITEM_MASTERS','USER_STR04',inXFR_GROUP);
Line: 78

			NOUPDATE_USER_NUM01              := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ITEM_MASTERS','USER_NUM01',inXFR_GROUP);
Line: 79

			NOUPDATE_USER_NUM02              := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ITEM_MASTERS','USER_NUM02',inXFR_GROUP);
Line: 80

			NOUPDATE_USER_NUM03              := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ITEM_MASTERS','USER_NUM03',inXFR_GROUP);
Line: 81

			NOUPDATE_USER_NUM04              := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ITEM_MASTERS','USER_NUM04',inXFR_GROUP);
Line: 82

			NOUPDATE_CREATION_DATE                 := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ITEM_MASTERS','CREATION_DATE',inXFR_GROUP);
Line: 83

			NOUPDATE_LAST_UPDATE_DATE                := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ITEM_MASTERS','LAST_UPDATE_DATE',inXFR_GROUP);
Line: 84

			NOUPDATE_CREATED_BY          	   := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ITEM_MASTERS','CREATED_BY',inXFR_GROUP);
Line: 85

			NOUPDATE_LAST_UPDATED_BY             := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ITEM_MASTERS','LAST_UPDATED_BY',inXFR_GROUP);
Line: 86

			NOUPDATE_SECURITY_MASK           := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ITEM_MASTERS','SECURITY_MASK',inXFR_GROUP);
Line: 87

			NOUPDATE_CHECKOUT_USER           := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ITEM_MASTERS','CHECKOUT_USER',inXFR_GROUP);
Line: 88

			NOUPDATE_PRIMARY_UOM_CODE        := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ITEM_MASTERS','PRIMARY_UOM_CODE',inXFR_GROUP);
Line: 89

			NOUPDATE_ITEM_TYPE_ID            := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ITEM_MASTERS','ITEM_TYPE_ID',inXFR_GROUP);
Line: 90

			NOUPDATE_DECIMAL_QTY_FLAG        := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ITEM_MASTERS','DECIMAL_QTY_FLAG',inXFR_GROUP);
Line: 114

					INSERT INTO CZ_ITEM_MASTERS
                                     (ITEM_ID,ITEM_TYPE_ID,DESC_TEXT,REF_PART_NBR,
                                      QUOTEABLE_FLAG,LEAD_TIME,ITEM_STATUS,USER_NUM01,
                                      USER_NUM02,USER_NUM03,USER_NUM04,USER_STR01,
                                      USER_STR02,USER_STR03,USER_STR04,CREATION_DATE,LAST_UPDATE_DATE,
                                      DELETED_FLAG,CREATED_BY,LAST_UPDATED_BY,
                                      SECURITY_MASK,CHECKOUT_USER,ORIG_SYS_REF,
                                      PRIMARY_UOM_CODE,DECIMAL_QTY_FLAG,
                                      SRC_APPLICATION_ID, SRC_TYPE_CODE)
                                    VALUES
                                     (p_xfr_itemmaster.ITEM_ID,p_xfr_itemmaster.ITEM_TYPE_ID,
                                      p_xfr_itemmaster.DESC_TEXT,p_xfr_itemmaster.REF_PART_NBR,
                                      p_xfr_itemmaster.QUOTEABLE_FLAG,p_xfr_itemmaster.LEAD_TIME,
                                      p_xfr_itemmaster.ITEM_STATUS,p_xfr_itemmaster.USER_NUM01,
                                      p_xfr_itemmaster.USER_NUM02,p_xfr_itemmaster.USER_NUM03,
                                      p_xfr_itemmaster.USER_NUM04,p_xfr_itemmaster.USER_STR01,
                                      p_xfr_itemmaster.USER_STR02,p_xfr_itemmaster.USER_STR03,
                                      p_xfr_itemmaster.USER_STR04,SYSDATE,SYSDATE,
                                      p_xfr_itemmaster.DELETED_FLAG,
                                      1,1,NULL,
                                      p_xfr_itemmaster.CHECKOUT_USER,
                                      p_xfr_itemmaster.ORIG_SYS_REF,
                                      p_xfr_itemmaster.PRIMARY_UOM_CODE,
                                      NVL(p_xfr_itemmaster.DECIMAL_QTY_FLAG,'0'),
                                      NVL(p_xfr_itemmaster.SRC_APPLICATION_ID,cnDefSrcAppId),
                                      NVL(p_xfr_itemmaster.SRC_TYPE_CODE,cnDefSrcTypeCode));
Line: 140

					nInsertCount:=nInsertCount+1;
Line: 142

                                        UPDATE CZ_IMP_item_master
                                        SET REC_STATUS='OK'
                                        WHERE ITEM_ID=p_xfr_itemmaster.ITEM_ID AND RUN_ID=inRUN_ID
                                        AND DISPOSITION='I';
Line: 151

                                                UPDATE CZ_IMP_item_master
                                                SET REC_STATUS='ERR'
                                                WHERE ITEM_ID=p_xfr_itemmaster.ITEM_ID AND RUN_ID=inRUN_ID
                                                AND DISPOSITION='I';
Line: 160

				 UPDATE CZ_ITEM_MASTERS SET
                                 ITEM_TYPE_ID=DECODE(NOUPDATE_ITEM_TYPE_ID,0,p_xfr_itemmaster.ITEM_TYPE_ID,ITEM_TYPE_ID),
			         DESC_TEXT=DECODE(NOUPDATE_DESC_TEXT,0,p_xfr_itemmaster.DESC_TEXT,DESC_TEXT),
 				 REF_PART_NBR=DECODE(NOUPDATE_REF_PART_NBR,0, p_xfr_itemmaster.REF_PART_NBR,REF_PART_NBR),
 				 ORIG_SYS_REF=DECODE(NOUPDATE_ORIG_SYS_REF,0, p_xfr_itemmaster.ORIG_SYS_REF,ORIG_SYS_REF),
				 QUOTEABLE_FLAG=DECODE(NOUPDATE_QUOTEABLE_FLAG,0,p_xfr_itemmaster.QUOTEABLE_FLAG,QUOTEABLE_FLAG),
				 LEAD_TIME=DECODE(NOUPDATE_LEAD_TIME,0,p_xfr_itemmaster.LEAD_TIME,LEAD_TIME),
				 ITEM_STATUS=DECODE(NOUPDATE_ITEM_STATUS,0,p_xfr_itemmaster.ITEM_STATUS,ITEM_STATUS),
				 DELETED_FLAG=DECODE(NOUPDATE_DELETED_FLAG,0,p_xfr_itemmaster.DELETED_FLAG,DELETED_FLAG),
				 USER_NUM01=DECODE(NOUPDATE_USER_NUM01,0,p_xfr_itemmaster.USER_NUM01,USER_NUM01),
				 USER_NUM02=DECODE(NOUPDATE_USER_NUM02,0,p_xfr_itemmaster.USER_NUM02,USER_NUM02),
				 USER_NUM03=DECODE(NOUPDATE_USER_NUM03,0,p_xfr_itemmaster.USER_NUM03,USER_NUM03),
				 USER_NUM04=DECODE(NOUPDATE_USER_NUM04,0,p_xfr_itemmaster.USER_NUM04,USER_NUM04),
				 USER_STR01=DECODE(NOUPDATE_USER_STR01,0,p_xfr_itemmaster.USER_STR01,USER_STR01),
				 USER_STR02=DECODE(NOUPDATE_USER_STR02,0,p_xfr_itemmaster.USER_STR02,USER_STR02),
				 USER_STR03=DECODE(NOUPDATE_USER_STR03,0,p_xfr_itemmaster.USER_STR03,USER_STR03),
				 USER_STR04=DECODE(NOUPDATE_USER_STR04,0,p_xfr_itemmaster.USER_STR04,USER_STR04),
				 CREATION_DATE=DECODE(NOUPDATE_CREATION_DATE,0,SYSDATE,CREATION_DATE),
				 LAST_UPDATE_DATE=DECODE(NOUPDATE_LAST_UPDATE_DATE,0,SYSDATE,LAST_UPDATE_DATE),
				 CREATED_BY=DECODE(NOUPDATE_CREATED_BY,0,1,CREATED_BY),
				 LAST_UPDATED_BY=DECODE(NOUPDATE_LAST_UPDATED_BY,0,1,LAST_UPDATED_BY),
				 SECURITY_MASK=DECODE(NOUPDATE_SECURITY_MASK,0,NULL,SECURITY_MASK),
                                 CHECKOUT_USER=DECODE(NOUPDATE_CHECKOUT_USER,0,p_xfr_itemmaster.CHECKOUT_USER,CHECKOUT_USER),
                                 PRIMARY_UOM_CODE=DECODE(NOUPDATE_PRIMARY_UOM_CODE,0,p_xfr_itemmaster.PRIMARY_UOM_CODE,PRIMARY_UOM_CODE),
                                 SRC_APPLICATION_ID=NVL(p_xfr_itemmaster.SRC_APPLICATION_ID,cnDefSrcAppId),
                                 SRC_TYPE_CODE=NVL(p_xfr_itemmaster.SRC_TYPE_CODE,cnDefSrcTypeCode),
                                 DECIMAL_QTY_FLAG=DECODE(NOUPDATE_DECIMAL_QTY_FLAG,0,p_xfr_itemmaster.DECIMAL_QTY_FLAG,DECIMAL_QTY_FLAG)
				 WHERE ITEM_ID=p_xfr_itemmaster.ITEM_ID;
Line: 191

					nUpdateCount:=nUpdateCount+1;
Line: 193

                                          UPDATE CZ_IMP_item_master
                                          SET REC_STATUS='OK'
                                          WHERE ITEM_ID=p_xfr_itemmaster.ITEM_ID AND RUN_ID=inRUN_ID
                                          AND DISPOSITION='M';
Line: 203

                                          UPDATE CZ_IMP_item_master
                                          SET REC_STATUS='ERR'
                                          WHERE ITEM_ID=p_xfr_itemmaster.ITEM_ID AND RUN_ID=inRUN_ID
                                          AND DISPOSITION='M';
Line: 213

       	      UPDATE CZ_IMP_item_master
	      SET REC_STATUS='OK'
	      WHERE ITEM_ID=p_xfr_itemmaster.ITEM_ID AND RUN_ID=inRUN_ID
	      AND DISPOSITION='N';
Line: 224

			INSERTS:=nInsertCount;
Line: 225

			UPDATES:=nUpdateCount;
Line: 239

					INSERTS		  OUT NOCOPY PLS_INTEGER,
					UPDATES		  OUT NOCOPY PLS_INTEGER,

                                        FAILED		IN OUT NOCOPY PLS_INTEGER,
                                        NOCHANGE OUT NOCOPY PLS_INTEGER,/*VIGRAMAK*/
                              inXFR_GROUP       IN    VARCHAR2
					)IS
		CURSOR c_xfr_itempropertyvalue IS -- sselahi
                SELECT PROPERTY_ID,ITEM_ID,PROPERTY_VALUE,PROPERTY_NUM_VALUE,
                RUN_ID,REC_STATUS,DISPOSITION,DELETED_FLAG,
                CHECKOUT_USER,USER_STR01,USER_STR02,USER_STR03,USER_STR04,
                USER_NUM01,USER_NUM02,USER_NUM03,USER_NUM04,
                ORIG_SYS_REF, NVL(FSK_PROPERTY_1_1, FSK_PROPERTY_1_EXT) AS FSK_PROPERTY,
                NVL(FSK_ITEMMASTER_2_1, FSK_ITEMMASTER_2_EXT) AS FSK_ITEMMASTER,
                SRC_APPLICATION_ID
                FROM CZ_IMP_ITEM_PROPERTY_VALUE WHERE
                RUN_ID=inRUN_ID AND REC_STATUS IN ('PASS','F3X');
Line: 264

		nInsertCount		PLS_INTEGER:=0;			/*Inserts */
Line: 265

		nUpdateCount		PLS_INTEGER:=0;			/*Updates */
Line: 268

                NOUPDATE_PROPERTY_VALUE          NUMBER;
Line: 269

		NOUPDATE_DELETED_FLAG            NUMBER;
Line: 270

		NOUPDATE_CREATION_DATE           NUMBER;
Line: 271

		NOUPDATE_LAST_UPDATE_DATE        NUMBER;
Line: 272

                NOUPDATE_CREATED_BY              NUMBER;
Line: 273

		NOUPDATE_LAST_UPDATED_BY         NUMBER;
Line: 274

		NOUPDATE_SECURITY_MASK           NUMBER;
Line: 275

		NOUPDATE_CHECKOUT_USER           NUMBER;
Line: 276

                NOUPDATE_PROPERTY_NUM_VALUE      NUMBER;   -- sselahi
Line: 285

   NOUPDATE_PROPERTY_VALUE          := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ITEM_PROPERTY_VALUES','PROPERTY_VALUE',inXFR_GROUP);
Line: 286

   NOUPDATE_PROPERTY_NUM_VALUE          := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ITEM_PROPERTY_VALUES','PROPERTY_NUM_VALUE',inXFR_GROUP);
Line: 287

   NOUPDATE_DELETED_FLAG            := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ITEM_PROPERTY_VALUES','DELETED_FLAG',inXFR_GROUP);
Line: 288

   NOUPDATE_CREATION_DATE                 := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ITEM_PROPERTY_VALUES','CREATION_DATE',inXFR_GROUP);
Line: 289

   NOUPDATE_LAST_UPDATE_DATE                := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ITEM_PROPERTY_VALUES','LAST_UPDATE_DATE',inXFR_GROUP);
Line: 290

   NOUPDATE_CREATED_BY              := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ITEM_PROPERTY_VALUES','CREATED_BY',inXFR_GROUP);
Line: 291

   NOUPDATE_LAST_UPDATED_BY             := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ITEM_PROPERTY_VALUES','LAST_UPDATED_BY',inXFR_GROUP);
Line: 292

NOUPDATE_SECURITY_MASK           := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ITEM_PROPERTY_VALUES','SECURITY_MASK',inXFR_GROUP);
Line: 293

NOUPDATE_CHECKOUT_USER           := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ITEM_PROPERTY_VALUES','CHECKOUT_USER',inXFR_GROUP);
Line: 322

			INSERT INTO CZ_ITEM_PROPERTY_VALUES (PROPERTY_ID,ITEM_ID,
			PROPERTY_VALUE,PROPERTY_NUM_VALUE, --sselahi
			/* USER_NUM01,USER_NUM02, USER_NUM03,
			USER_NUM04,USER_STR01,USER_STR02,USER_STR03,USER_STR04,
			*/
			CREATION_DATE, LAST_UPDATE_DATE, DELETED_FLAG,
			CREATED_BY, LAST_UPDATED_BY, SECURITY_MASK,
			CHECKOUT_USER, ORIG_SYS_REF, SRC_APPLICATION_ID) VALUES
		        (p_xfr_itempropertyvalue.PROPERTY_ID,p_xfr_itempropertyvalue.ITEM_ID,
		        p_xfr_itempropertyvalue.PROPERTY_VALUE,
                        p_xfr_itempropertyvalue.PROPERTY_NUM_VALUE,
		        /*p_xfr_itempropertyvalue.USER_NUM01,p_xfr_itempropertyvalue.USER_NUM02,
		        p_xfr_itempropertyvalue.USER_NUM03,p_xfr_itempropertyvalue.USER_NUM04,
		        p_xfr_itempropertyvalue.USER_STR01,p_xfr_itempropertyvalue.USER_STR02,
		        p_xfr_itempropertyvalue.USER_STR03,p_xfr_itempropertyvalue.USER_STR04,*/
		        SYSDATE, SYSDATE, p_xfr_itempropertyvalue.DELETED_FLAG , 1, 1, NULL,
		        p_xfr_itempropertyvalue.CHECKOUT_USER, sOrigSysRef, p_xfr_itempropertyvalue.SRC_APPLICATION_ID);
Line: 340

 			nInsertCount:=nInsertCount+1;
Line: 342

                        UPDATE CZ_IMP_item_property_value
                        SET REC_STATUS='OK'
                        WHERE PROPERTY_ID=p_xfr_itempropertyvalue.PROPERTY_ID
                        AND ITEM_ID=p_xfr_itempropertyvalue.ITEM_ID AND RUN_ID=inRUN_ID
                        AND DISPOSITION='I' AND ORIG_SYS_REF=p_xfr_itempropertyvalue.ORIG_SYS_REF;
Line: 352

                                UPDATE CZ_IMP_item_property_value
                                SET REC_STATUS='ERR'
                                WHERE PROPERTY_ID=p_xfr_itempropertyvalue.PROPERTY_ID
                                AND ITEM_ID=p_xfr_itempropertyvalue.ITEM_ID AND RUN_ID=inRUN_ID
                                AND DISPOSITION='I' AND ORIG_SYS_REF=p_xfr_itempropertyvalue.ORIG_SYS_REF;
Line: 363

  	   UPDATE CZ_ITEM_PROPERTY_VALUES SET
           PROPERTY_VALUE=DECODE(NOUPDATE_PROPERTY_VALUE,0,p_xfr_itempropertyvalue.PROPERTY_VALUE,PROPERTY_VALUE),
           PROPERTY_NUM_VALUE=DECODE(NOUPDATE_PROPERTY_NUM_VALUE,0,p_xfr_itempropertyvalue.PROPERTY_NUM_VALUE,PROPERTY_NUM_VALUE),
           DELETED_FLAG=		        DECODE(NOUPDATE_DELETED_FLAG,0,p_xfr_itempropertyvalue.DELETED_FLAG ,DELETED_FLAG),
		CREATION_DATE=			DECODE(NOUPDATE_CREATION_DATE,0,SYSDATE,CREATION_DATE),
		LAST_UPDATE_DATE=			DECODE(NOUPDATE_LAST_UPDATE_DATE,0,SYSDATE,LAST_UPDATE_DATE),
		CREATED_BY=			DECODE(NOUPDATE_CREATED_BY,0,1,CREATED_BY),
		LAST_UPDATED_BY=		DECODE(NOUPDATE_LAST_UPDATED_BY,0,1,LAST_UPDATED_BY),
		SECURITY_MASK=		DECODE(NOUPDATE_SECURITY_MASK,0,NULL,SECURITY_MASK),
		CHECKOUT_USER=		DECODE(NOUPDATE_CHECKOUT_USER,0,NULL,CHECKOUT_USER),
                ORIG_SYS_REF = sOrigSysRef
		WHERE PROPERTY_ID=p_xfr_itempropertyvalue.PROPERTY_ID AND
		ITEM_ID=p_xfr_itempropertyvalue.ITEM_ID;
Line: 382

                           IF(p_xfr_itempropertyvalue.REC_STATUS<>'F3X')THEN nUpdateCount:=nUpdateCount+1; END IF;
Line: 384

                               UPDATE CZ_IMP_item_property_value
                               SET REC_STATUS=DECODE(p_xfr_itempropertyvalue.REC_STATUS,'PASS','OK',p_xfr_itempropertyvalue.REC_STATUS)
                               WHERE PROPERTY_ID=p_xfr_itempropertyvalue.PROPERTY_ID
                               AND ITEM_ID=p_xfr_itempropertyvalue.ITEM_ID AND RUN_ID=inRUN_ID
                               AND DISPOSITION='M' AND ORIG_SYS_REF=p_xfr_itempropertyvalue.ORIG_SYS_REF;
Line: 395

                         UPDATE CZ_IMP_item_property_value
                         SET REC_STATUS='ERR'
                         WHERE PROPERTY_ID=p_xfr_itempropertyvalue.PROPERTY_ID
                         AND ITEM_ID=p_xfr_itempropertyvalue.ITEM_ID AND RUN_ID=inRUN_ID
                         AND DISPOSITION='M' AND ORIG_SYS_REF=p_xfr_itempropertyvalue.ORIG_SYS_REF;
Line: 404

          UPDATE CZ_IMP_item_property_value
          SET REC_STATUS=DECODE(p_xfr_itempropertyvalue.REC_STATUS,'PASS','OK',p_xfr_itempropertyvalue.REC_STATUS)
          WHERE PROPERTY_ID=p_xfr_itempropertyvalue.PROPERTY_ID
           AND ITEM_ID=p_xfr_itempropertyvalue.ITEM_ID AND RUN_ID=inRUN_ID
          AND DISPOSITION='N' AND ORIG_SYS_REF=p_xfr_itempropertyvalue.ORIG_SYS_REF;
Line: 418

  INSERTS:=nInsertCount;
Line: 419

  UPDATES:=nUpdateCount;
Line: 433

					INSERTS		  OUT NOCOPY PLS_INTEGER,
					UPDATES		  OUT NOCOPY PLS_INTEGER,
					FAILED		IN OUT NOCOPY PLS_INTEGER,
                                        NOCHANGE OUT NOCOPY PLS_INTEGER,
                              inXFR_GROUP       IN    VARCHAR2
				)IS
BEGIN
		DECLARE CURSOR c_xfr_itemtype IS
                          SELECT  ITEM_TYPE_ID,DESC_TEXT,NAME,RUN_ID ,REC_STATUS ,DISPOSITION ,DELETED_FLAG ,
                           CHECKOUT_USER, USER_STR01,USER_STR02,USER_STR03,
                           USER_STR04,USER_NUM01,USER_NUM02, USER_NUM03, USER_NUM04,ORIG_SYS_REF,SRC_APPLICATION_ID
                          FROM CZ_IMP_ITEM_TYPE WHERE CZ_IMP_ITEM_TYPE.RUN_ID = inRUN_ID AND REC_STATUS='PASS';
Line: 452

			nInsertCount		PLS_INTEGER:=0;			/*Inserts */
Line: 453

			nUpdateCount		PLS_INTEGER:=0;			/*Updates */
Line: 456

			NOUPDATE_DESC_TEXT               NUMBER;
Line: 457

                        NOUPDATE_NAME                    NUMBER;
Line: 458

			NOUPDATE_DELETED_FLAG            NUMBER;
Line: 459

			NOUPDATE_USER_STR01              NUMBER;
Line: 460

			NOUPDATE_USER_STR02              NUMBER;
Line: 461

			NOUPDATE_USER_STR03              NUMBER;
Line: 462

			NOUPDATE_USER_STR04              NUMBER;
Line: 463

			NOUPDATE_USER_NUM01              NUMBER;
Line: 464

			NOUPDATE_USER_NUM02              NUMBER;
Line: 465

			NOUPDATE_USER_NUM03              NUMBER;
Line: 466

			NOUPDATE_USER_NUM04              NUMBER;
Line: 467

			NOUPDATE_CREATION_DATE                 NUMBER;
Line: 468

			NOUPDATE_LAST_UPDATE_DATE                NUMBER;
Line: 469

                        NOUPDATE_CREATED_BY              NUMBER;
Line: 470

			NOUPDATE_LAST_UPDATED_BY             NUMBER;
Line: 471

			NOUPDATE_SECURITY_MASK           NUMBER;
Line: 472

			NOUPDATE_CHECKOUT_USER           NUMBER;
Line: 476

		-- Get the Update Flags for each column
			NOUPDATE_DESC_TEXT    		   := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ITEM_TYPES','DESC_TEXT',inXFR_GROUP);
Line: 478

			NOUPDATE_NAME			   := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ITEM_TYPES','NAME',inXFR_GROUP);
Line: 479

			NOUPDATE_DELETED_FLAG            := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ITEM_TYPES','DELETED_FLAG',inXFR_GROUP);
Line: 480

			NOUPDATE_USER_STR01              := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ITEM_TYPES','USER_STR01',inXFR_GROUP);
Line: 481

			NOUPDATE_USER_STR02              := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ITEM_TYPES','USER_STR02',inXFR_GROUP);
Line: 482

			NOUPDATE_USER_STR03              := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ITEM_TYPES','USER_STR03',inXFR_GROUP);
Line: 483

			NOUPDATE_USER_STR04              := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ITEM_TYPES','USER_STR04',inXFR_GROUP);
Line: 484

			NOUPDATE_USER_NUM01              := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ITEM_TYPES','USER_NUM01',inXFR_GROUP);
Line: 485

			NOUPDATE_USER_NUM02              := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ITEM_TYPES','USER_NUM02',inXFR_GROUP);
Line: 486

			NOUPDATE_USER_NUM03              := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ITEM_TYPES','USER_NUM03',inXFR_GROUP);
Line: 487

			NOUPDATE_USER_NUM04              := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ITEM_TYPES','USER_NUM04',inXFR_GROUP);
Line: 488

			NOUPDATE_CREATION_DATE                 := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ITEM_TYPES','CREATION_DATE',inXFR_GROUP);
Line: 489

			NOUPDATE_LAST_UPDATE_DATE                := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ITEM_TYPES','LAST_UPDATE_DATE',inXFR_GROUP);
Line: 490

			NOUPDATE_CREATED_BY          	   := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ITEM_TYPES','CREATED_BY',inXFR_GROUP);
Line: 491

			NOUPDATE_LAST_UPDATED_BY             := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ITEM_TYPES','LAST_UPDATED_BY',inXFR_GROUP);
Line: 492

			NOUPDATE_SECURITY_MASK           := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ITEM_TYPES','SECURITY_MASK',inXFR_GROUP);
Line: 493

			NOUPDATE_CHECKOUT_USER           := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ITEM_TYPES','CHECKOUT_USER',inXFR_GROUP);
Line: 516

						INSERT INTO CZ_ITEM_TYPES (ITEM_TYPE_ID,DESC_TEXT,NAME,USER_NUM01,USER_NUM02,
                                     USER_NUM03,USER_NUM04,USER_STR01,USER_STR02,USER_STR03,USER_STR04,
                                     CREATION_DATE, LAST_UPDATE_DATE, DELETED_FLAG,
                                     CREATED_BY, LAST_UPDATED_BY, SECURITY_MASK,
                                     CHECKOUT_USER,ORIG_SYS_REF,SRC_APPLICATION_ID) VALUES
					      (p_xfr_itemtype.ITEM_TYPE_ID,p_xfr_itemtype.DESC_TEXT,p_xfr_itemtype.NAME,
                                     p_xfr_itemtype.USER_NUM01,p_xfr_itemtype.USER_NUM02,p_xfr_itemtype.USER_NUM03,
                                     p_xfr_itemtype.USER_NUM04, p_xfr_itemtype.USER_STR01,p_xfr_itemtype.USER_STR02,
                                     p_xfr_itemtype.USER_STR03,p_xfr_itemtype.USER_STR04, SYSDATE, SYSDATE,
                                     p_xfr_itemtype.DELETED_FLAG,
                                     1, 1, NULL, p_xfr_itemtype.CHECKOUT_USER,
                                     p_xfr_itemtype.ORIG_SYS_REF,p_xfr_itemtype.SRC_APPLICATION_ID);
Line: 528

						nInsertCount:=nInsertCount+1;
Line: 530

                                                  UPDATE CZ_IMP_item_type
                                                     SET REC_STATUS='OK'
                                                   WHERE ITEM_TYPE_ID=p_xfr_itemtype.ITEM_TYPE_ID AND RUN_ID=inRUN_ID
                                                           AND DISPOSITION='I';
Line: 539

                                                           UPDATE CZ_IMP_item_type
                                                              SET REC_STATUS='ERR'
                                                            WHERE ITEM_TYPE_ID=p_xfr_itemtype.ITEM_TYPE_ID AND RUN_ID=inRUN_ID
                                                           AND DISPOSITION='I';
Line: 548

						UPDATE CZ_ITEM_TYPES SET		DESC_TEXT=DECODE(NOUPDATE_DESC_TEXT,0,p_xfr_itemtype.DESC_TEXT, DESC_TEXT),
								NAME=DECODE(NOUPDATE_NAME,0,p_xfr_itemtype.NAME,NAME),
								DELETED_FLAG=		DECODE(NOUPDATE_DELETED_FLAG,0,p_xfr_itemtype.DELETED_FLAG ,DELETED_FLAG),
								USER_NUM01=			DECODE(NOUPDATE_USER_NUM01,  0,p_xfr_itemtype.USER_NUM01,USER_NUM01),
								USER_NUM02=			DECODE(NOUPDATE_USER_NUM02,  0,p_xfr_itemtype.USER_NUM02,USER_NUM02),
								USER_NUM03=			DECODE(NOUPDATE_USER_NUM03,  0,p_xfr_itemtype.USER_NUM03,USER_NUM03),
								USER_NUM04=			DECODE(NOUPDATE_USER_NUM04,  0,p_xfr_itemtype.USER_NUM04,USER_NUM04),
								USER_STR01=			DECODE(NOUPDATE_USER_STR01,  0,p_xfr_itemtype.USER_STR01,USER_STR01),
								USER_STR02=			DECODE(NOUPDATE_USER_STR02,  0,p_xfr_itemtype.USER_STR02,USER_STR02),
								USER_STR03=			DECODE(NOUPDATE_USER_STR03,  0,p_xfr_itemtype.USER_STR03,USER_STR03),
								USER_STR04=			DECODE(NOUPDATE_USER_STR04,  0,p_xfr_itemtype.USER_STR04,USER_STR04),
								CREATION_DATE=			DECODE(NOUPDATE_CREATION_DATE,0,SYSDATE,CREATION_DATE),
								LAST_UPDATE_DATE=			DECODE(NOUPDATE_LAST_UPDATE_DATE,0,SYSDATE,LAST_UPDATE_DATE),
								CREATED_BY=			DECODE(NOUPDATE_CREATED_BY,0,1,CREATED_BY),
								LAST_UPDATED_BY=		DECODE(NOUPDATE_LAST_UPDATED_BY,0,1,LAST_UPDATED_BY),
								SECURITY_MASK=		DECODE(NOUPDATE_SECURITY_MASK,0,NULL,SECURITY_MASK),
								CHECKOUT_USER=		DECODE(NOUPDATE_CHECKOUT_USER,0,NULL,CHECKOUT_USER)
								WHERE ITEM_TYPE_ID=p_xfr_itemtype.ITEM_TYPE_ID;
Line: 569

							nUpdateCount:=nUpdateCount+1;
Line: 571

                                                           UPDATE CZ_IMP_item_type
                                                              SET REC_STATUS='OK'
                                                            WHERE ITEM_TYPE_ID=p_xfr_itemtype.ITEM_TYPE_ID AND RUN_ID=inRUN_ID
                                                           AND DISPOSITION='M';
Line: 581

                                                           UPDATE CZ_IMP_item_type
                                                              SET REC_STATUS='ERR'
                                                            WHERE ITEM_TYPE_ID=p_xfr_itemtype.ITEM_TYPE_ID AND RUN_ID=inRUN_ID
                                                           AND DISPOSITION='M';
Line: 590

           UPDATE CZ_IMP_item_type
           SET REC_STATUS='OK'
           WHERE ITEM_TYPE_ID=p_xfr_itemtype.ITEM_TYPE_ID AND RUN_ID=inRUN_ID
           AND DISPOSITION='N';
Line: 604

			INSERTS:=nInsertCount;
Line: 605

 			UPDATES:=nUpdateCount;
Line: 620

					INSERTS		  OUT NOCOPY PLS_INTEGER,
					UPDATES		  OUT NOCOPY PLS_INTEGER,
					FAILED		IN OUT NOCOPY PLS_INTEGER,
                              inXFR_GROUP       IN    VARCHAR2
					)IS

BEGIN
  DECLARE CURSOR c_xfr_itemtypeprop IS
   SELECT ITEM_TYPE_ID,PROPERTY_ID,RUN_ID,REC_STATUS ,DISPOSITION ,DELETED_FLAG,
          CHECKOUT_USER, USER_STR01,USER_STR02,USER_STR03,USER_STR04,USER_NUM01,
          USER_NUM02,USER_NUM03, USER_NUM04, ORIG_SYS_REF,
          NVL(FSK_ITEMTYPE_1_1, FSK_ITEMTYPE_1_EXT) AS FSK_ITEMTYPE,
          NVL(FSK_PROPERTY_2_1, FSK_PROPERTY_2_EXT) AS FSK_PROPERTY,
          SRC_APPLICATION_ID
  FROM CZ_IMP_ITEM_TYPE_PROPERTY
WHERE CZ_IMP_ITEM_TYPE_PROPERTY.RUN_ID = inRUN_ID AND REC_STATUS='PASS';
Line: 643

			nInsertCount		PLS_INTEGER:=0;			/*Inserts */
Line: 644

			nUpdateCount		PLS_INTEGER:=0;			/*Updates */
Line: 645

			NOUPDATE_DELETED_FLAG            NUMBER;
Line: 646

			NOUPDATE_CREATION_DATE           NUMBER;
Line: 647

			NOUPDATE_LAST_UPDATE_DATE        NUMBER;
Line: 648

                  NOUPDATE_CREATED_BY              NUMBER;
Line: 649

			NOUPDATE_LAST_UPDATED_BY         NUMBER;
Line: 650

			NOUPDATE_SECURITY_MASK           NUMBER;
Line: 651

			NOUPDATE_CHECKOUT_USER           NUMBER;
Line: 657

		-- Get the Update Flags for each column
			NOUPDATE_DELETED_FLAG            := CZ_UTILS.GET_NOUPDATE_FLAG('ITEM_TYPE_PROPERTY','DELETED_FLAG',inXFR_GROUP);
Line: 659

			NOUPDATE_CREATION_DATE                 := CZ_UTILS.GET_NOUPDATE_FLAG('ITEM_TYPE_PROPERTY','CREATION_DATE',inXFR_GROUP);
Line: 660

			NOUPDATE_LAST_UPDATE_DATE                := CZ_UTILS.GET_NOUPDATE_FLAG('ITEM_TYPE_PROPERTY','LAST_UPDATE_DATE',inXFR_GROUP);
Line: 661

                        NOUPDATE_CREATED_BY              := CZ_UTILS.GET_NOUPDATE_FLAG('ITEM_TYPE_PROPERTY','CREATED_BY',inXFR_GROUP);
Line: 662

			NOUPDATE_LAST_UPDATED_BY             := CZ_UTILS.GET_NOUPDATE_FLAG('ITEM_TYPE_PROPERTY','LAST_UPDATED_BY',inXFR_GROUP);
Line: 663

			NOUPDATE_SECURITY_MASK           := CZ_UTILS.GET_NOUPDATE_FLAG('ITEM_TYPE_PROPERTY','SECURITY_MASK',inXFR_GROUP);
Line: 664

			NOUPDATE_CHECKOUT_USER           := CZ_UTILS.GET_NOUPDATE_FLAG('ITEM_TYPE_PROPERTY','CHECKOUT_USER',inXFR_GROUP);
Line: 692

INSERT INTO CZ_ITEM_TYPE_PROPERTIES (ITEM_TYPE_ID,PROPERTY_ID,
/* USER_NUM01,USER_NUM02, USER_NUM03,USER_NUM04,USER_STR01,USER_STR02,USER_STR03,USER_STR04,*/
CREATION_DATE, LAST_UPDATE_DATE, DELETED_FLAG ,CREATED_BY, LAST_UPDATED_BY,
 SECURITY_MASK, ORIG_SYS_REF, SRC_APPLICATION_ID) VALUES
(p_xfr_itemtypeprop.ITEM_TYPE_ID,p_xfr_itemtypeprop.PROPERTY_ID,
/* p_xfr_itemtypeprop.USER_NUM01,p_xfr_itemtypeprop.USER_NUM02,p_xfr_itemtypeprop.USER_NUM03,p_xfr_itemtypeprop.USER_NUM04,
 p_xfr_itemtypeprop.USER_STR01,p_xfr_itemtypeprop.USER_STR02,p_xfr_itemtypeprop.USER_STR03,p_xfr_itemtypeprop.USER_STR04,
*/ SYSDATE, SYSDATE, p_xfr_itemtypeprop.DELETED_FLAG , 1, 1, NULL, sOrigSysRef, p_xfr_itemtypeprop.SRC_APPLICATION_ID);
Line: 700

						nInsertCount:=nInsertCount+1;
Line: 702

                                                  UPDATE CZ_IMP_item_type_property
                                                     SET REC_STATUS='OK'
                                                   WHERE ITEM_TYPE_ID=p_xfr_itemtypeprop.ITEM_TYPE_ID
                                                     AND PROPERTY_ID=p_xfr_itemtypeprop.PROPERTY_ID AND RUN_ID=inRUN_ID
                                                           AND DISPOSITION='I';
Line: 712

                                                           UPDATE CZ_IMP_item_type_property
                                                              SET REC_STATUS='ERR'
                                                            WHERE ITEM_TYPE_ID=p_xfr_itemtypeprop.ITEM_TYPE_ID
                                                              AND PROPERTY_ID=p_xfr_itemtypeprop.PROPERTY_ID AND RUN_ID=inRUN_ID
                                                           AND DISPOSITION='I';
Line: 722

						UPDATE CZ_ITEM_TYPE_PROPERTIES SET
												DELETED_FLAG=		DECODE(NOUPDATE_DELETED_FLAG,0,p_xfr_itemtypeprop.DELETED_FLAG ,DELETED_FLAG),
											/*	USER_NUM01=			DECODE(NOUPDATE_USER_NUM01,  0,p_xfr_itemtypeprop.USER_NUM01,USER_NUM01),
												USER_NUM02=			DECODE(NOUPDATE_USER_NUM02,  0,p_xfr_itemtypeprop.USER_NUM02,USER_NUM02),
												USER_NUM03=			DECODE(NOUPDATE_USER_NUM03,  0,p_xfr_itemtypeprop.USER_NUM03,USER_NUM03),
												USER_NUM04=			DECODE(NOUPDATE_USER_NUM04,  0,p_xfr_itemtypeprop.USER_NUM04,USER_NUM04),
												USER_STR01=			DECODE(NOUPDATE_USER_STR01,  0,p_xfr_itemtypeprop.USER_STR01,USER_STR01),
												USER_STR02=			DECODE(NOUPDATE_USER_STR02,  0,p_xfr_itemtypeprop.USER_STR02,USER_STR02),
												USER_STR03=			DECODE(NOUPDATE_USER_STR03,  0,p_xfr_itemtypeprop.USER_STR03,USER_STR03),
												USER_STR04=			DECODE(NOUPDATE_USER_STR04,  0,p_xfr_itemtypeprop.USER_STR04,USER_STR04),*/
												CREATION_DATE=			DECODE(NOUPDATE_CREATION_DATE,0,SYSDATE,CREATION_DATE),
												LAST_UPDATE_DATE=			DECODE(NOUPDATE_LAST_UPDATE_DATE,0,SYSDATE,LAST_UPDATE_DATE),
												CREATED_BY=			DECODE(NOUPDATE_CREATED_BY,0,1,CREATED_BY),
												LAST_UPDATED_BY=		DECODE(NOUPDATE_LAST_UPDATED_BY,0,1,LAST_UPDATED_BY),
												SECURITY_MASK=		DECODE(NOUPDATE_SECURITY_MASK,0,NULL,SECURITY_MASK),
												CHECKOUT_USER=		DECODE(NOUPDATE_CHECKOUT_USER,0,NULL,CHECKOUT_USER),
                                                                        ORIG_SYS_REF = sOrigSysRef
												WHERE ITEM_TYPE_ID=p_xfr_itemtypeprop.ITEM_TYPE_ID AND
												PROPERTY_ID=p_xfr_itemtypeprop.PROPERTY_ID;
Line: 744

							nUpdateCount:=nUpdateCount+1;
Line: 746

                                                           UPDATE CZ_IMP_item_type_property
                                                              SET REC_STATUS='OK'
                                                            WHERE ITEM_TYPE_ID=p_xfr_itemtypeprop.ITEM_TYPE_ID
                                                              AND PROPERTY_ID=p_xfr_itemtypeprop.PROPERTY_ID AND RUN_ID=inRUN_ID
                                                           AND DISPOSITION='M';
Line: 758

                                                           UPDATE CZ_IMP_item_type_property
                                                              SET REC_STATUS='ERR'
                                                            WHERE ITEM_TYPE_ID=p_xfr_itemtypeprop.ITEM_TYPE_ID
                                                              AND PROPERTY_ID=p_xfr_itemtypeprop.PROPERTY_ID AND RUN_ID=inRUN_ID
                                                           AND DISPOSITION='M';
Line: 772

			INSERTS:=nInsertCount;
Line: 773

			UPDATES:=nUpdateCount;
Line: 789

					INSERTS		  OUT NOCOPY PLS_INTEGER,
					UPDATES		  OUT NOCOPY PLS_INTEGER,
					FAILED		IN OUT NOCOPY PLS_INTEGER,
                                        NOCHANGE			OUT NOCOPY PLS_INTEGER,
                              inXFR_GROUP       IN    VARCHAR2,
                                        p_rp_folder_id IN  NUMBER
					) IS
BEGIN
		DECLARE CURSOR c_xfr_property IS
                          SELECT PROPERTY_ID,PROPERTY_UNIT,DESC_TEXT,NAME,DATA_TYPE,DEF_VALUE,DEF_NUM_VALUE,RUN_ID,
                           REC_STATUS,DISPOSITION,DELETED_FLAG,CHECKOUT_USER,
                           USER_STR01,USER_STR02,USER_STR03,USER_STR04,USER_NUM01,USER_NUM02,
                           USER_NUM03,USER_NUM04,ORIG_SYS_REF,SRC_APPLICATION_ID, rec_nbr
                          FROM CZ_IMP_property WHERE CZ_IMP_property.RUN_ID = inRUN_ID AND REC_STATUS='PASS';
Line: 810

			nInsertCount		PLS_INTEGER:=0;			/*Inserts */
Line: 811

			nUpdateCount		PLS_INTEGER:=0;			/*Updates */
Line: 816

            NOUPDATE_PROPERTY_UNIT           NUMBER;
Line: 817

			NOUPDATE_DESC_TEXT               NUMBER;
Line: 818

            NOUPDATE_NAME                    NUMBER;
Line: 819

			NOUPDATE_DATA_TYPE	             NUMBER;
Line: 820

            NOUPDATE_DEF_VALUE               NUMBER;
Line: 821

            NOUPDATE_DEF_NUM_VALUE           NUMBER;
Line: 822

			NOUPDATE_DELETED_FLAG            NUMBER;
Line: 823

			NOUPDATE_USER_STR01              NUMBER;
Line: 824

			NOUPDATE_USER_STR02              NUMBER;
Line: 825

			NOUPDATE_USER_STR03              NUMBER;
Line: 826

			NOUPDATE_USER_STR04              NUMBER;
Line: 827

			NOUPDATE_USER_NUM01              NUMBER;
Line: 828

			NOUPDATE_USER_NUM02              NUMBER;
Line: 829

			NOUPDATE_USER_NUM03              NUMBER;
Line: 830

			NOUPDATE_USER_NUM04              NUMBER;
Line: 831

			NOUPDATE_CREATION_DATE           NUMBER;
Line: 832

			NOUPDATE_LAST_UPDATE_DATE        NUMBER;
Line: 833

            NOUPDATE_CREATED_BY              NUMBER;
Line: 834

			NOUPDATE_LAST_UPDATED_BY         NUMBER;
Line: 835

			NOUPDATE_SECURITY_MASK           NUMBER;
Line: 836

			NOUPDATE_CHECKOUT_USER           NUMBER;
Line: 847

       SELECT ROWID FROM cz_item_property_values
        WHERE property_id = p_xfr_property.property_id;
Line: 851

       SELECT ROWID FROM cz_ps_prop_vals
        WHERE property_id = p_xfr_property.property_id;
Line: 857

		-- Get the Update Flags for each column
			NOUPDATE_PROPERTY_UNIT		   := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_PROPERTIES','PROPERTY_UNIT',inXFR_GROUP);
Line: 859

			NOUPDATE_DESC_TEXT    		   := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_PROPERTIES','DESC_TEXT',inXFR_GROUP);
Line: 860

			NOUPDATE_NAME			   := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_PROPERTIES','NAME',inXFR_GROUP);
Line: 861

			NOUPDATE_DATA_TYPE		   := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_PROPERTIES','DATA_TYPE',inXFR_GROUP);
Line: 862

			NOUPDATE_DEF_VALUE		   := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_PROPERTIES','DEF_VALUE',inXFR_GROUP);
Line: 863

			NOUPDATE_DEF_NUM_VALUE	   := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_PROPERTIES','DEF_NUM_VALUE',inXFR_GROUP);
Line: 864

			NOUPDATE_DELETED_FLAG            := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_PROPERTIES','DELETED_FLAG',inXFR_GROUP);
Line: 865

			NOUPDATE_USER_STR01              := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_PROPERTIES','USER_STR01',inXFR_GROUP);
Line: 866

			NOUPDATE_USER_STR02              := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_PROPERTIES','USER_STR02',inXFR_GROUP);
Line: 867

			NOUPDATE_USER_STR03              := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_PROPERTIES','USER_STR03',inXFR_GROUP);
Line: 868

			NOUPDATE_USER_STR04              := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_PROPERTIES','USER_STR04',inXFR_GROUP);
Line: 869

			NOUPDATE_USER_NUM01              := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_PROPERTIES','USER_NUM01',inXFR_GROUP);
Line: 870

			NOUPDATE_USER_NUM02              := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_PROPERTIES','USER_NUM02',inXFR_GROUP);
Line: 871

			NOUPDATE_USER_NUM03              := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_PROPERTIES','USER_NUM03',inXFR_GROUP);
Line: 872

			NOUPDATE_USER_NUM04              := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_PROPERTIES','USER_NUM04',inXFR_GROUP);
Line: 873

			NOUPDATE_CREATION_DATE                 := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_PROPERTIES','CREATION_DATE',inXFR_GROUP);
Line: 874

			NOUPDATE_LAST_UPDATE_DATE                := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_PROPERTIES','LAST_UPDATE_DATE',inXFR_GROUP);
Line: 875

                        NOUPDATE_CREATED_BY              := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_PROPERTIES','CREATED_BY',inXFR_GROUP);
Line: 876

			NOUPDATE_LAST_UPDATED_BY             := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_PROPERTIES','LAST_UPDATED_BY',inXFR_GROUP);
Line: 877

			NOUPDATE_SECURITY_MASK           := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_PROPERTIES','SECURITY_MASK',inXFR_GROUP);
Line: 878

			NOUPDATE_CHECKOUT_USER           := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_PROPERTIES','CHECKOUT_USER',inXFR_GROUP);
Line: 904

                                      SELECT CZ_INTL_TEXTS_S.NEXTVAL INTO l_def_num_value FROM dual;
Line: 905

                                      FOR i IN(SELECT language_code FROM FND_LANGUAGES
                                                WHERE installed_flag in( 'B', 'I'))
                                      LOOP
                                         INSERT INTO cz_localized_texts (intl_text_id, localized_str,
                                           language, source_lang, deleted_flag,
                                           creation_date, last_update_date, created_by,
                                           last_updated_by,orig_sys_ref, model_id)
                                         VALUES
                                           (l_def_num_value,
                                            p_xfr_property.DEF_VALUE,
                                            i.language_code,
                                            USERENV('LANG'),
                                            '0',
                                            SYSDATE, SYSDATE, -UID, -UID,p_xfr_property.ORIG_SYS_REF, 0);
Line: 924

						INSERT INTO CZ_PROPERTIES (PROPERTY_ID,PROPERTY_UNIT,DESC_TEXT,NAME,
                                     DATA_TYPE,DEF_VALUE,DEF_NUM_VALUE,USER_NUM01,USER_NUM02,USER_NUM03,USER_NUM04,
                                     USER_STR01,USER_STR02,USER_STR03,USER_STR04,CREATION_DATE,
                                     LAST_UPDATE_DATE,DELETED_FLAG,CHECKOUT_USER,
                                     CREATED_BY,LAST_UPDATED_BY,SECURITY_MASK,ORIG_SYS_REF,SRC_APPLICATION_ID) VALUES
                                    (p_xfr_property.PROPERTY_ID,p_xfr_property.PROPERTY_UNIT,
                                     p_xfr_property.DESC_TEXT,p_xfr_property.NAME,p_xfr_property.DATA_TYPE,
                                     p_xfr_property.DEF_VALUE,
                                                                 l_def_num_value,
                                     p_xfr_property.USER_NUM01,
                                     p_xfr_property.USER_NUM02,p_xfr_property.USER_NUM03,
                                     p_xfr_property.USER_NUM04,p_xfr_property.USER_STR01,
                                     p_xfr_property.USER_STR02,p_xfr_property.USER_STR03,
                                     p_xfr_property.USER_STR04, SYSDATE, SYSDATE,
                                     p_xfr_property.DELETED_FLAG,p_xfr_property.CHECKOUT_USER,
                                     1, 1, NULL, p_xfr_property.ORIG_SYS_REF,p_xfr_property.SRC_APPLICATION_ID);
Line: 940

						nInsertCount:=nInsertCount+1;
Line: 942

                                                   UPDATE CZ_IMP_property
                                                      SET REC_STATUS='OK'
                                                    WHERE PROPERTY_ID=p_xfr_property.PROPERTY_ID AND RUN_ID=inRUN_ID
                                                           AND DISPOSITION='I';
Line: 950

                    INSERT INTO cz_rp_entries
                           (object_id,object_type,enclosing_folder,name,description)
                    VALUES (p_xfr_property.property_id,
                            'PRP',
                            p_rp_folder_id,
                            p_xfr_property.name,
                            p_xfr_property.desc_text);
Line: 959

                         x_error:=CZ_UTILS.LOG_REPORT('Insert into cz_rp_entries FAILED. PROPERTY_ID:'|| p_xfr_property.property_id||'. '||SQLERRM,1,'CZ_IM_XFR.XFR_PROPERTY' ,11276,inRUN_ID);
Line: 966

                                                           UPDATE CZ_IMP_property
                                                              SET REC_STATUS='ERR'
                                                            WHERE PROPERTY_ID=p_xfr_property.PROPERTY_ID AND RUN_ID=inRUN_ID
                                                           AND DISPOSITION='I';
Line: 980

     IF(NOUPDATE_DATA_TYPE = 0 AND p_xfr_property.rec_nbr <> p_xfr_property.data_type)THEN

       IF(p_xfr_property.data_type = 4)THEN

        --The property was numeric and has just been made text.

        BEGIN
           OPEN c_item_prop;
Line: 990

              t_rowid.DELETE;
Line: 996

                 UPDATE cz_item_property_values SET
                    property_value = TO_CHAR(property_num_value),
                    property_num_value = NULL
                  WHERE ROWID = t_rowid(i);
Line: 1010

              t_rowid.DELETE;
Line: 1016

                 UPDATE cz_ps_prop_vals SET
                    data_value = TO_CHAR(data_num_value),
                    data_num_value = NULL
                  WHERE ROWID = t_rowid(i);
Line: 1045

           SELECT TO_NUMBER(property_value) BULK COLLECT INTO t_value
             FROM cz_item_property_values
            WHERE property_id = p_xfr_property.property_id;
Line: 1049

           SELECT TO_NUMBER(data_value) BULK COLLECT INTO t_value
             FROM cz_ps_prop_vals
            WHERE property_id = p_xfr_property.property_id;
Line: 1056

              t_rowid.DELETE;
Line: 1062

                 UPDATE cz_item_property_values SET
                    property_num_value = TO_NUMBER(property_value),
                    property_value = NULL
                  WHERE ROWID = t_rowid(i);
Line: 1076

              t_rowid.DELETE;
Line: 1082

                 UPDATE cz_ps_prop_vals SET
                    data_num_value = TO_NUMBER(data_value),
                    data_value = NULL
                  WHERE ROWID = t_rowid(i);
Line: 1110

                                        SELECT CZ_INTL_TEXTS_S.NEXTVAL INTO l_def_num_value FROM dual;
Line: 1111

                                        FOR i IN(SELECT language_code FROM FND_LANGUAGES
                                                  WHERE installed_flag in( 'B', 'I'))
                                        LOOP
                                           INSERT INTO cz_localized_texts (intl_text_id, localized_str,
                                             language, source_lang, deleted_flag,
                                             creation_date, last_update_date, created_by,
                                             last_updated_by,orig_sys_ref, model_id)
                                           VALUES
                                             (l_def_num_value,
                                              p_xfr_property.DEF_VALUE,
                                              i.language_code,
                                              USERENV('LANG'),
                                              '0',
                                              SYSDATE, SYSDATE, -UID, -UID,p_xfr_property.ORIG_SYS_REF, 0);
Line: 1127

                                        UPDATE cz_localized_texts
                                           SET localized_str=DECODE(NOUPDATE_DEF_VALUE,0,p_xfr_property.DEF_VALUE,localized_str)
                                         WHERE intl_text_id=p_xfr_property.DEF_NUM_VALUE;
Line: 1135

						UPDATE CZ_PROPERTIES SET
										 		PROPERTY_UNIT=DECODE(NOUPDATE_PROPERTY_UNIT,0,p_xfr_property.PROPERTY_UNIT, PROPERTY_UNIT),
												DESC_TEXT=DECODE(NOUPDATE_DESC_TEXT,0,p_xfr_property.DESC_TEXT,DESC_TEXT),
												NAME=DECODE(NOUPDATE_NAME,0,p_xfr_property.NAME,NAME),
												DATA_TYPE=DECODE(NOUPDATE_DATA_TYPE,0,p_xfr_property.DATA_TYPE,DATA_TYPE),
												DEF_VALUE=DECODE(NOUPDATE_DEF_VALUE,0,p_xfr_property.DEF_VALUE,DEF_VALUE),
												DEF_NUM_VALUE=DECODE(NOUPDATE_DEF_NUM_VALUE,0,l_def_num_value,DEF_NUM_VALUE),
												DELETED_FLAG=		DECODE(NOUPDATE_DELETED_FLAG,0,p_xfr_property.DELETED_FLAG ,DELETED_FLAG),
												USER_NUM01=			DECODE(NOUPDATE_USER_NUM01,  0,p_xfr_property.USER_NUM01,USER_NUM01),
												USER_NUM02=			DECODE(NOUPDATE_USER_NUM02,  0,p_xfr_property.USER_NUM02,USER_NUM02),
												USER_NUM03=			DECODE(NOUPDATE_USER_NUM03,  0,p_xfr_property.USER_NUM03,USER_NUM03),
												USER_NUM04=			DECODE(NOUPDATE_USER_NUM04,  0,p_xfr_property.USER_NUM04,USER_NUM04),
												USER_STR01=			DECODE(NOUPDATE_USER_STR01,  0,p_xfr_property.USER_STR01,USER_STR01),
												USER_STR02=			DECODE(NOUPDATE_USER_STR02,  0,p_xfr_property.USER_STR02,USER_STR02),
												USER_STR03=			DECODE(NOUPDATE_USER_STR03,  0,p_xfr_property.USER_STR03,USER_STR03),
												USER_STR04=			DECODE(NOUPDATE_USER_STR04,  0,p_xfr_property.USER_STR04,USER_STR04),
												CREATION_DATE=			DECODE(NOUPDATE_CREATION_DATE,0,SYSDATE,CREATION_DATE),
												LAST_UPDATE_DATE=			DECODE(NOUPDATE_LAST_UPDATE_DATE,0,SYSDATE,LAST_UPDATE_DATE),
												CREATED_BY=			DECODE(NOUPDATE_CREATED_BY,0,1,CREATED_BY),
												LAST_UPDATED_BY=		DECODE(NOUPDATE_LAST_UPDATED_BY,0,1,LAST_UPDATED_BY),
												SECURITY_MASK=		DECODE(NOUPDATE_SECURITY_MASK,0,NULL,SECURITY_MASK),
												CHECKOUT_USER=		DECODE(NOUPDATE_SECURITY_MASK,0,NULL,CHECKOUT_USER)
												WHERE PROPERTY_ID=p_xfr_property.PROPERTY_ID;
Line: 1162

							nUpdateCount:=nUpdateCount+1;
Line: 1164

                                                           UPDATE CZ_IMP_property
                                                              SET REC_STATUS='OK'
                                                            WHERE PROPERTY_ID=p_xfr_property.PROPERTY_ID AND RUN_ID=inRUN_ID
                                                           AND DISPOSITION='M';
Line: 1171

                                UPDATE cz_rp_entries
                                   SET name = p_xfr_property.name, description = p_xfr_property.desc_text
                                 WHERE object_id = p_xfr_property.property_id
                                   AND object_type = 'PRP';
Line: 1177

                                    x_error:=CZ_UTILS.LOG_REPORT('Update of PROPERTY_ID:'|| p_xfr_property.property_id||' in cz_rp_entries FAILED. '||SQLERRM,1,'CZ_IM_XFR.XFR_PROPERTY' ,11276,inRUN_ID);
Line: 1183

                                                           UPDATE CZ_IMP_property
                                                              SET REC_STATUS='ERR'
                                                            WHERE PROPERTY_ID=p_xfr_property.PROPERTY_ID AND RUN_ID=inRUN_ID
                                                           AND DISPOSITION='M';
Line: 1191

                                                           UPDATE CZ_IMP_property
                                                              SET REC_STATUS='ERR'
                                                            WHERE PROPERTY_ID=p_xfr_property.PROPERTY_ID AND RUN_ID=inRUN_ID
                                                           AND DISPOSITION='M';
Line: 1201

            UPDATE CZ_IMP_property
             SET REC_STATUS='OK'
             WHERE PROPERTY_ID=p_xfr_property.PROPERTY_ID AND RUN_ID=inRUN_ID
             AND DISPOSITION='N';
Line: 1215

			INSERTS:=nInsertCount;
Line: 1216

			UPDATES:=nUpdateCount;