APPS.CN_COMP_ANCHORS_PKG SQL Statements

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

Line: 4

procedure INSERT_ROW
  (X_ROWID              IN OUT NOCOPY VARCHAR2,
   X_COMP_ANCHOR_ID     IN OUT NOCOPY NUMBER,
   X_ROLE_QUOTA_CATE_ID IN     NUMBER,
   X_QUOTA_CATEGORY_ID  IN     NUMBER,
   X_ATTAINMENT         IN     NUMBER,
   X_TYPE               IN     VARCHAR2,
   X_COMMISSION         IN     NUMBER,
   X_ATTRIBUTE_CATEGORY IN     VARCHAR2,
   X_ATTRIBUTE1         IN     VARCHAR2,
   X_ATTRIBUTE2         IN     VARCHAR2,
   X_ATTRIBUTE3         IN     VARCHAR2,
   X_ATTRIBUTE4         IN     VARCHAR2,
   X_ATTRIBUTE5         IN     VARCHAR2,
   X_ATTRIBUTE6         IN     VARCHAR2,
   X_ATTRIBUTE7         IN     VARCHAR2,
   X_ATTRIBUTE8         IN     VARCHAR2,
   X_ATTRIBUTE9         IN     VARCHAR2,
   X_ATTRIBUTE10        IN     VARCHAR2,
   X_ATTRIBUTE11        IN     VARCHAR2,
   X_ATTRIBUTE12        IN     VARCHAR2,
   X_ATTRIBUTE13        IN     VARCHAR2,
   X_ATTRIBUTE14        IN     VARCHAR2,
   X_ATTRIBUTE15        IN     VARCHAR2,
   X_CREATION_DATE      IN     DATE,
   X_CREATED_BY         IN     NUMBER,
   X_LAST_UPDATE_DATE   IN     DATE,
   X_LAST_UPDATED_BY    IN     NUMBER,
   X_LAST_UPDATE_LOGIN  IN     NUMBER,
   X_OBJECT_VERSION_NUMBER  IN   NUMBER
  ) IS
     cursor C is select ROWID from cn_comp_anchors
       where COMP_ANCHOR_ID = x_comp_anchor_id;

Line: 38

     CURSOR id IS SELECT cn_comp_anchors_s.NEXTVAL FROM dual;

Line: 50

   insert into CN_COMP_ANCHORS
     (LAST_UPDATED_BY,
      LAST_UPDATE_LOGIN,
      CREATION_DATE,
      CREATED_BY,
      COMP_ANCHOR_ID,
      ROLE_QUOTA_CATE_ID,
      QUOTA_CATEGORY_ID,
      ATTAINMENT,
      TYPE,
      COMMISSION,
      ATTRIBUTE_CATEGORY,
      ATTRIBUTE1,
      ATTRIBUTE2,
      ATTRIBUTE3,
      ATTRIBUTE4,
      ATTRIBUTE5,
      ATTRIBUTE6,
      ATTRIBUTE7,
      ATTRIBUTE8,
      ATTRIBUTE9,
      ATTRIBUTE10,
      ATTRIBUTE11,
      ATTRIBUTE12,
      ATTRIBUTE13,
      ATTRIBUTE14,
      ATTRIBUTE15,
      LAST_UPDATE_DATE,
      OBJECT_VERSION_NUMBER
      )
     VALUES
     (X_LAST_UPDATED_BY,
      X_LAST_UPDATE_LOGIN,
      X_CREATION_DATE,
      X_CREATED_BY,
      X_COMP_ANCHOR_ID,
      X_ROLE_QUOTA_CATE_ID,
      X_QUOTA_CATEGORY_ID,
      X_ATTAINMENT,
      X_TYPE,
      X_COMMISSION,
      X_ATTRIBUTE_CATEGORY,
      X_ATTRIBUTE1,
      X_ATTRIBUTE2,
      X_ATTRIBUTE3,
      X_ATTRIBUTE4,
      X_ATTRIBUTE5,
      X_ATTRIBUTE6,
      X_ATTRIBUTE7,
      X_ATTRIBUTE8,
      X_ATTRIBUTE9,
      X_ATTRIBUTE10,
      X_ATTRIBUTE11,
      X_ATTRIBUTE12,
      X_ATTRIBUTE13,
      X_ATTRIBUTE14,
      X_ATTRIBUTE15,
      x_last_update_date,
      X_OBJECT_VERSION_NUMBER
  );

Line: 119

end INSERT_ROW;

Line: 148

	SELECT
	  ROLE_QUOTA_CATE_ID,
	  QUOTA_CATEGORY_ID,
	  ATTAINMENT,
	  TYPE,
	  COMMISSION,
	  ATTRIBUTE_CATEGORY,
	  ATTRIBUTE1,
	  ATTRIBUTE2,
	  ATTRIBUTE3,
	  ATTRIBUTE4,
	  ATTRIBUTE5,
	  ATTRIBUTE6,
	  ATTRIBUTE7,
	  ATTRIBUTE8,
	  ATTRIBUTE9,
	  ATTRIBUTE10,
	  ATTRIBUTE11,
	  ATTRIBUTE12,
	  ATTRIBUTE13,
	  ATTRIBUTE14,
	  ATTRIBUTE15,
	  comp_anchor_id,
          OBJECT_VERSION_NUMBER
	  FROM cn_comp_anchors
	  WHERE COMP_ANCHOR_ID = x_comp_anchor_id
	  for update of COMP_ANCHOR_ID nowait;

Line: 184

      fnd_message.set_name('CN', 'CN_RECORD_DELETED');

Line: 237

procedure UPDATE_ROW
  (X_COMP_ANCHOR_ID     IN     NUMBER,
   X_ROLE_QUOTA_CATE_ID IN     NUMBER,
   X_QUOTA_CATEGORY_ID  IN     NUMBER,
   X_ATTAINMENT         IN     NUMBER,
   X_TYPE               IN     VARCHAR2,
   X_COMMISSION         IN     NUMBER,
   X_ATTRIBUTE_CATEGORY IN     VARCHAR2,
   X_ATTRIBUTE1         IN     VARCHAR2,
   X_ATTRIBUTE2         IN     VARCHAR2,
   X_ATTRIBUTE3         IN     VARCHAR2,
   X_ATTRIBUTE4         IN     VARCHAR2,
   X_ATTRIBUTE5         IN     VARCHAR2,
   X_ATTRIBUTE6         IN     VARCHAR2,
   X_ATTRIBUTE7         IN     VARCHAR2,
   X_ATTRIBUTE8         IN     VARCHAR2,
   X_ATTRIBUTE9         IN     VARCHAR2,
   X_ATTRIBUTE10        IN     VARCHAR2,
   X_ATTRIBUTE11        IN     VARCHAR2,
   X_ATTRIBUTE12        IN     VARCHAR2,
   X_ATTRIBUTE13        IN     VARCHAR2,
   X_ATTRIBUTE14        IN     VARCHAR2,
   X_ATTRIBUTE15        IN     VARCHAR2,
   X_LAST_UPDATE_DATE   IN     DATE,
   X_LAST_UPDATED_BY    IN     NUMBER,
   X_LAST_UPDATE_LOGIN  IN     NUMBER,
   X_OBJECT_VERSION_NUMBER  IN   NUMBER
  ) IS
BEGIN
   update CN_COMP_ANCHORS SET
     ROLE_QUOTA_CATE_ID = X_ROLE_QUOTA_CATE_ID,
     QUOTA_CATEGORY_ID = X_QUOTA_CATEGORY_ID,
     ATTAINMENT = X_ATTAINMENT,
     TYPE = X_TYPE,
     COMMISSION = X_COMMISSION,
     ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
     ATTRIBUTE1 = X_ATTRIBUTE1,
     ATTRIBUTE2 = X_ATTRIBUTE2,
     ATTRIBUTE3 = X_ATTRIBUTE3,
     ATTRIBUTE4 = X_ATTRIBUTE4,
     ATTRIBUTE5 = X_ATTRIBUTE5,
     ATTRIBUTE6 = X_ATTRIBUTE6,
     ATTRIBUTE7 = X_ATTRIBUTE7,
     ATTRIBUTE8 = X_ATTRIBUTE8,
     ATTRIBUTE9 = X_ATTRIBUTE9,
     ATTRIBUTE10 = X_ATTRIBUTE10,
     ATTRIBUTE11 = X_ATTRIBUTE11,
     ATTRIBUTE12 = X_ATTRIBUTE12,
     ATTRIBUTE13 = X_ATTRIBUTE13,
     ATTRIBUTE14 = X_ATTRIBUTE14,
     ATTRIBUTE15 = X_ATTRIBUTE15,
     COMP_ANCHOR_ID = X_COMP_ANCHOR_ID,
     LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
     LAST_UPDATED_BY = X_LAST_UPDATED_BY,
     LAST_UPDATE_LOGIN = x_last_update_login,
     OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER
     where COMP_ANCHOR_ID = x_comp_anchor_id;

Line: 298

end UPDATE_ROW;

Line: 301

procedure DELETE_ROW (
  X_COMP_ANCHOR_ID in NUMBER
) is
begin
  delete from CN_COMP_ANCHORS
  where COMP_ANCHOR_ID = X_COMP_ANCHOR_ID;

Line: 312

end DELETE_ROW;