APPS.IGC_CC_SEC_GROUP_USERS_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_USER_ID		                NUMBER,
                     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_GROUP_USERS
	            WHERE CC_GROUP_ID  = P_CC_GROUP_ID
		    and   USER_ID = P_USER_ID ;

Line: 49

  SAVEPOINT Insert_Row_Pvt ;

Line: 66

	INSERT INTO IGC_CC_GROUP_USERS(
		        CC_GROUP_ID,
			USER_ID,
			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_USER_ID,
			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: 134

    ROLLBACK TO Insert_Row_Pvt ;

Line: 141

    ROLLBACK TO Insert_Row_Pvt ;

Line: 148

    ROLLBACK TO Insert_Row_Pvt ;

Line: 159

END Insert_Row;

Line: 161

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_USER_ID			     NUMBER,
                  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: 200

  SAVEPOINT Update_Row_Pvt ;

Line: 217

 UPDATE IGC_CC_GROUP_USERS
 SET
	   	CC_GROUP_ID		= P_CC_GROUP_ID,
		USER_ID			= P_USER_ID,
		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: 258

    ROLLBACK TO Update_Row_Pvt ;

Line: 265

    ROLLBACK TO Update_Row_Pvt ;

Line: 272

    ROLLBACK TO Update_Row_Pvt ;

Line: 283

 END Update_Row;

Line: 321

		SELECT cc_group_id,
		     user_id,
		     context,
		     attribute1,
		     attribute2,
		     attribute3,
		     attribute4,
		     attribute5,
		     attribute6,
		     attribute7,
		     attribute8,
		     attribute9,
		     attribute10,
		     attribute11,
		     attribute12,
		     attribute13,
		     attribute14,
		     attribute15
	      from IGC_CC_GROUP_USERS
              where rowid = P_ROWID
	      for UPDATE OF CC_GROUP_ID NOWAIT;

Line: 368

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

Line: 482

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

  SAVEPOINT Delete_Row_Pvt ;

Line: 521

     SELECT cc_group_id, user_id
     INTO  x_cc_group_id, x_user_id
     FROM IGC_CC_GROUP_USERS
     WHERE rowid = P_rowid;

Line: 532

/* Delete IGC_CC_GROUP_USERS - Detail Record */
     DELETE FROM IGC_CC_GROUP_USERS
     WHERE cc_group_id  = x_cc_group_id
    and user_id = x_user_id;

Line: 552

    ROLLBACK TO Delete_Row_Pvt ;

Line: 559

    ROLLBACK TO Delete_Row_Pvt ;

Line: 566

    ROLLBACK TO Delete_Row_Pvt ;

Line: 577

END DELETE_ROW;