DBA Data[Home] [Help]

APPS.CZ_IMP_PR_MAIN SQL Statements

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

Line: 13

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

		IF (p_imp_price.DELETED_FLAG IS NULL) THEN
			BEGIN
                                UPDATE CZ_IMP_PRICE SET DELETED_FLAG=DECODE(DELETED_FLAG,NULL,'0',DELETED_FLAG) WHERE ROWID = p_imp_price.ROWID;
Line: 70

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

		IF (p_imp_pricegroup.DELETED_FLAG IS NULL) THEN
			BEGIN
                                UPDATE CZ_IMP_PRICE_GROUP SET DELETED_FLAG=DECODE(DELETED_FLAG,NULL,'0',DELETED_FLAG) WHERE ROWID = p_imp_pricegroup.ROWID;
Line: 123

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

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

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

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

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

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

			INSERTS:=0;
Line: 163

			UPDATES:=0;
Line: 169

		CZ_IMP_PR_KRS.KRS_PRICE (inRUN_ID,COMMIT_SIZE,MAX_ERR,INSERTS,UPDATES,nFailed,DUPS,inXFR_GROUP);
Line: 173

			CZ_IMP_PR_XFR.XFR_PRICE (inRUN_ID,COMMIT_SIZE,MAX_ERR-nFailed,nXfrInsertCount,nXfrUpdateCount,FAILED,inXFR_GROUP);
Line: 174

			/* 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_PR_MAIN.MAIN_PRICE ',11276);
Line: 179

			/* 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_PR_MAIN.MAIN_PRICE',11276);
Line: 185

			INSERTS:=nXfrInsertCount;
Line: 186

			UPDATES:=nXfrUpdateCount;
Line: 201

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

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

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

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

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

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

			INSERTS:=0;
Line: 240

			UPDATES:=0;
Line: 246

		CZ_IMP_PR_KRS.KRS_PRICE_GROUP (inRUN_ID,COMMIT_SIZE,MAX_ERR,INSERTS,UPDATES,nFailed,DUPS,inXFR_GROUP);
Line: 250

			CZ_IMP_PR_XFR.XFR_PRICE_GROUP(inRUN_ID,COMMIT_SIZE,MAX_ERR-nFailed,nXfrInsertCount,nXfrUpdateCount,FAILED,inXFR_GROUP);
Line: 251

			/* 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_PR_MAIN.MAIN_PRICE_GROUP ',11276);
Line: 256

			/* 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_PR_MAIN.MAIN_PRICE_GROUP ',11276);
Line: 262

			INSERTS:=nXfrInsertCount;
Line: 263

			UPDATES:=nXfrUpdateCount;
Line: 278

         DELETE FROM CZ_XFR_RUN_RESULTS WHERE RUN_ID=inRUN_ID AND IMP_TABLE='CZ_PRICES';
Line: 286

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

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

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

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

         DELETE FROM CZ_XFR_RUN_RESULTS WHERE RUN_ID=inRUN_ID AND IMP_TABLE='CZ_PRICE_GROUPS';
Line: 351

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

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

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

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