APPS.IGC_CC_SEC_GROUP_PKG SQL Statements

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

Line: 6

PROCEDURE Insert_Row(  p_api_version        IN       NUMBER,
  		p_init_msg_list             IN       VARCHAR2 := FND_API.G_FALSE,
  		p_commit                    IN       VARCHAR2 := FND_API.G_FALSE,
  		p_validation_level          IN       NUMBER   := FND_API.G_VALID_LEVEL_FULL,
  		p_return_status             OUT NOCOPY      VARCHAR2,
  		p_msg_count                 OUT NOCOPY      NUMBER,
  		p_msg_data                  OUT NOCOPY      VARCHAR2,

		P_ROWID 			IN OUT NOCOPY VARCHAR2,
                P_CC_GROUP_ID              NUMBER,
                P_SET_OF_BOOKS_ID          NUMBER,
                P_CC_GROUP_NAME            VARCHAR2,
                P_CC_GROUP_DESC            VARCHAR2,
                P_CONTEXT	           VARCHAR2,
                P_ATTRIBUTE1               VARCHAR2,
                P_ATTRIBUTE2               VARCHAR2,
                P_ATTRIBUTE3               VARCHAR2,
                P_ATTRIBUTE4               VARCHAR2,
                P_ATTRIBUTE5               VARCHAR2,
                P_ATTRIBUTE6               VARCHAR2,
                P_ATTRIBUTE7               VARCHAR2,
                P_ATTRIBUTE8               VARCHAR2,
                P_ATTRIBUTE9               VARCHAR2,
                P_ATTRIBUTE10              VARCHAR2,
                P_ATTRIBUTE11              VARCHAR2,
                P_ATTRIBUTE12              VARCHAR2,
                P_ATTRIBUTE13              VARCHAR2,
                P_ATTRIBUTE14              VARCHAR2,
                P_ATTRIBUTE15              VARCHAR2,
                P_LAST_UPDATE_DATE         DATE,
                P_LAST_UPDATED_BY          NUMBER,
                P_CREATION_DATE   	   DATE,
                P_CREATED_BY               NUMBER,
                P_LAST_UPDATE_LOGIN        NUMBER
	    ) IS
  l_api_name            CONSTANT VARCHAR2(30)   := 'Insert_Row';

Line: 44

	CURSOR C IS SELECT ROWID FROM IGC_CC_GROUPS
		    WHERE CC_GROUP_ID = P_CC_GROUP_ID
		    AND SET_OF_BOOKS_ID = P_SET_OF_BOOKS_ID;

Line: 49

  SAVEPOINT Insert_Row_Pvt ;

Line: 67

	INSERT INTO IGC_CC_GROUPS(
			CC_GROUP_ID,
			SET_OF_BOOKS_ID,
			CC_GROUP_NAME,
			CC_GROUP_DESC,
			CONTEXT,
			ATTRIBUTE1,
			ATTRIBUTE2,
			ATTRIBUTE3,
			ATTRIBUTE4,
			ATTRIBUTE5,
			ATTRIBUTE6,
			ATTRIBUTE7,
			ATTRIBUTE8,
			ATTRIBUTE9,
			ATTRIBUTE10,
			ATTRIBUTE11,
			ATTRIBUTE12,
			ATTRIBUTE13,
			ATTRIBUTE14,
			ATTRIBUTE15,
			LAST_UPDATE_DATE,
			LAST_UPDATED_BY,
			CREATION_DATE,
			CREATED_BY,
			LAST_UPDATE_LOGIN) VALUES(
			P_CC_GROUP_ID,
			P_SET_OF_BOOKS_ID,
			P_CC_GROUP_NAME,
			P_CC_GROUP_DESC,
			P_CONTEXT,
			P_ATTRIBUTE1,
			P_ATTRIBUTE2,
			P_ATTRIBUTE3,
			P_ATTRIBUTE4,
			P_ATTRIBUTE5,
			P_ATTRIBUTE6,
			P_ATTRIBUTE7,
			P_ATTRIBUTE8,
			P_ATTRIBUTE9,
			P_ATTRIBUTE10,
			P_ATTRIBUTE11,
			P_ATTRIBUTE12,
			P_ATTRIBUTE13,
			P_ATTRIBUTE14,
			P_ATTRIBUTE15,
			P_LAST_UPDATE_DATE,
			P_LAST_UPDATED_BY,
			P_CREATION_DATE,
			P_CREATED_BY,
			P_LAST_UPDATE_LOGIN
			);

Line: 137

    ROLLBACK TO Insert_Row_Pvt ;

Line: 144

    ROLLBACK TO Insert_Row_Pvt ;

Line: 151

    ROLLBACK TO Insert_Row_Pvt ;

Line: 163

END Insert_Row;

Line: 165

PROCEDURE Update_Row(  p_api_version        IN       NUMBER,
  		p_init_msg_list             IN       VARCHAR2 := FND_API.G_FALSE,
  		p_commit                    IN       VARCHAR2 := FND_API.G_FALSE,
  		p_validation_level          IN       NUMBER   := FND_API.G_VALID_LEVEL_FULL,
  		p_return_status             OUT NOCOPY      VARCHAR2,
  		p_msg_count                 OUT NOCOPY      NUMBER,
  		p_msg_data                  OUT NOCOPY      VARCHAR2,

	        P_ROWID			   VARCHAR2,
                P_CC_GROUP_ID              NUMBER,
                P_SET_OF_BOOKS_ID          NUMBER,
                P_CC_GROUP_NAME            VARCHAR2,
                P_CC_GROUP_DESC            VARCHAR2,
                P_CONTEXT	           VARCHAR2,
                P_ATTRIBUTE1               VARCHAR2,
                P_ATTRIBUTE2               VARCHAR2,
                P_ATTRIBUTE3               VARCHAR2,
                P_ATTRIBUTE4               VARCHAR2,
                P_ATTRIBUTE5               VARCHAR2,
                P_ATTRIBUTE6               VARCHAR2,
                P_ATTRIBUTE7               VARCHAR2,
                P_ATTRIBUTE8               VARCHAR2,
                P_ATTRIBUTE9               VARCHAR2,
                P_ATTRIBUTE10              VARCHAR2,
                P_ATTRIBUTE11              VARCHAR2,
                P_ATTRIBUTE12              VARCHAR2,
                P_ATTRIBUTE13              VARCHAR2,
                P_ATTRIBUTE14              VARCHAR2,
                P_ATTRIBUTE15              VARCHAR2,
                P_LAST_UPDATE_DATE         DATE,
                P_LAST_UPDATED_BY          NUMBER,
                P_LAST_UPDATE_LOGIN        NUMBER
	        ) IS
  l_api_name            CONSTANT VARCHAR2(30)   := 'Update_Row';

Line: 203

  SAVEPOINT Update_Row_Pvt ;

Line: 220

 UPDATE IGC_CC_GROUPS
 SET
	CC_GROUP_ID		= P_CC_GROUP_ID,
	SET_OF_BOOKS_ID		= P_SET_OF_BOOKS_ID,
	CC_GROUP_NAME		= P_CC_GROUP_NAME,
	CC_GROUP_DESC		= P_CC_GROUP_DESC,
	CONTEXT	        	= P_CONTEXT,
	ATTRIBUTE1		= P_ATTRIBUTE1,
	ATTRIBUTE2		= P_ATTRIBUTE2,
	ATTRIBUTE3		= P_ATTRIBUTE3,
	ATTRIBUTE4		= P_ATTRIBUTE4,
	ATTRIBUTE5		= P_ATTRIBUTE5,
	ATTRIBUTE6		= P_ATTRIBUTE6,
	ATTRIBUTE7		= P_ATTRIBUTE7,
	ATTRIBUTE8		= P_ATTRIBUTE8,
	ATTRIBUTE9		= P_ATTRIBUTE9,
	ATTRIBUTE10		= P_ATTRIBUTE10,
	ATTRIBUTE11		= P_ATTRIBUTE11,
	ATTRIBUTE12		= P_ATTRIBUTE12,
	ATTRIBUTE13		= P_ATTRIBUTE13,
	ATTRIBUTE14		= P_ATTRIBUTE14,
	ATTRIBUTE15		= P_ATTRIBUTE15,
	LAST_UPDATE_DATE	= P_LAST_UPDATE_DATE,
	LAST_UPDATED_BY		= P_LAST_UPDATED_BY,
	LAST_UPDATE_LOGIN	= P_LAST_UPDATE_LOGIN
 WHERE ROWID = P_ROWID;

Line: 262

    ROLLBACK TO Update_Row_Pvt ;

Line: 269

    ROLLBACK TO Update_Row_Pvt ;

Line: 276

    ROLLBACK TO Update_Row_Pvt ;

Line: 287

 END Update_Row;

Line: 327

		SELECT  cc_group_id,
			set_of_books_id,
			cc_group_name,
			cc_group_desc,
			context,
			attribute1,
			attribute2,
			attribute3,
			attribute4,
			attribute5,
			attribute6,
			attribute7,
			attribute8,
			attribute9,
			attribute10,
			attribute11,
			attribute12,
			attribute13,
			attribute14,
			attribute15
		FROM  IGC_CC_GROUPS
		WHERE ROWID = P_ROWID
		for UPDATE OF CC_GROUP_ID NOWAIT;

Line: 376

   fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

Line: 493

PROCEDURE Delete_Row(  p_api_version IN       NUMBER,
  	p_init_msg_list              IN       VARCHAR2 := FND_API.G_FALSE,
  	p_commit                     IN       VARCHAR2 := FND_API.G_FALSE,
  	p_validation_level           IN       NUMBER   := FND_API.G_VALID_LEVEL_FULL,
  	p_return_status              OUT NOCOPY      VARCHAR2,
  	p_msg_count                  OUT NOCOPY      NUMBER,
  	p_msg_data                   OUT NOCOPY      VARCHAR2,

	P_ROWID 			      VARCHAR2) IS

  l_api_name                CONSTANT VARCHAR2(30)   := 'Delete_Row';

Line: 514

  SAVEPOINT Delete_Row_Pvt ;

Line: 532

	SELECT cc_group_id
	INTO   x_cc_group_id
	FROM   IGC_CC_GROUPS
	WHERE  rowid = p_rowid;

Line: 542

/* Delete IGC_CC_GROUP_USERS - Master - Detail Record */
  DELETE FROM IGC_CC_GROUP_USERS
  WHERE cc_group_id = x_cc_group_id;

Line: 550

/* Delete IGC_CC_GROUPS - Master Record */
  DELETE FROM IGC_CC_GROUPS
  WHERE cc_group_id = x_cc_group_id;

Line: 570

    ROLLBACK TO Delete_Row_Pvt ;

Line: 577

    ROLLBACK TO Delete_Row_Pvt ;

Line: 584

    ROLLBACK TO Delete_Row_Pvt ;

Line: 596

END DELETE_ROW;

Line: 639

        SELECT COUNT(1)
         INTO DUMMY
         FROM IGC_CC_GROUPS
         WHERE CC_GROUP_NAME = P_GROUP_NAME AND
               SET_OF_BOOKS_ID = P_SOB_ID AND
             ((P_ROWID IS NULL) OR (ROWID <> P_ROWID));