APPS.CN_PLAN_TEXTS_PKG SQL Statements

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

Line: 4

PROCEDURE Insert_Row (
  P_PLAN_TEXT_ID        IN NUMBER,
  P_ROLE_ID             IN NUMBER,
  P_SEQUENCE_ID         IN NUMBER,
  P_QUOTA_CATEGORY_ID   IN NUMBER,
  P_TEXT_TYPE           IN VARCHAR2,
  P_TEXT                IN VARCHAR2,
  P_TEXT2               IN VARCHAR2,
  P_ATTRIBUTE_CATEGORY  IN VARCHAR2 := NULL,
  P_ATTRIBUTE1          IN VARCHAR2 := NULL,
  P_ATTRIBUTE2          IN VARCHAR2 := NULL,
  P_ATTRIBUTE3          IN VARCHAR2 := NULL,
  P_ATTRIBUTE4          IN VARCHAR2 := NULL,
  P_ATTRIBUTE5          IN VARCHAR2 := NULL,
  P_ATTRIBUTE6          IN VARCHAR2 := NULL,
  P_ATTRIBUTE7          IN VARCHAR2 := NULL,
  P_ATTRIBUTE8          IN VARCHAR2 := NULL,
  P_ATTRIBUTE9          IN VARCHAR2 := NULL,
  P_ATTRIBUTE10         IN VARCHAR2 := NULL,
  P_ATTRIBUTE11         IN VARCHAR2 := NULL,
  P_ATTRIBUTE12         IN VARCHAR2 := NULL,
  P_ATTRIBUTE13         IN VARCHAR2 := NULL,
  P_ATTRIBUTE14         IN VARCHAR2 := NULL,
  P_ATTRIBUTE15         IN VARCHAR2 := NULL,
  P_CREATION_DATE       IN DATE,
  P_CREATED_BY          IN NUMBER,
  P_LAST_UPDATE_DATE    IN DATE,
  P_LAST_UPDATED_BY     IN NUMBER,
  P_LAST_UPDATE_LOGIN   IN NUMBER,
  P_OBJECT_VERSION_NUMBER    IN NUMBER,
  P_ROLE_MODEL_ID       IN NUMBER
) IS

BEGIN

  INSERT INTO cn_plan_texts (
    PLAN_TEXT_ID,
    ROLE_ID,
    SEQUENCE_ID,
    QUOTA_CATEGORY_ID,
    TEXT_TYPE,
    TEXT,
    TEXT2,
    ATTRIBUTE_CATEGORY,
    ATTRIBUTE1,
    ATTRIBUTE2,
    ATTRIBUTE3,
    ATTRIBUTE4,
    ATTRIBUTE5,
    ATTRIBUTE6,
    ATTRIBUTE7,
    ATTRIBUTE8,
    ATTRIBUTE9,
    ATTRIBUTE10,
    ATTRIBUTE11,
    ATTRIBUTE12,
    ATTRIBUTE13,
    ATTRIBUTE14,
    ATTRIBUTE15,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    OBJECT_VERSION_NUMBER,
    ROLE_MODEL_ID
  )
  VALUES (
    P_PLAN_TEXT_ID,
    P_ROLE_ID,
    P_SEQUENCE_ID,
    P_QUOTA_CATEGORY_ID,
    P_TEXT_TYPE,
    P_TEXT,
    P_TEXT2,
    P_ATTRIBUTE_CATEGORY,
    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_CREATION_DATE,
    P_CREATED_BY,
    P_LAST_UPDATE_DATE,
    P_LAST_UPDATED_BY,
    P_LAST_UPDATE_LOGIN,
    P_OBJECT_VERSION_NUMBER,
    P_ROLE_MODEL_ID
  );

Line: 104

END Insert_Row;

Line: 106

PROCEDURE Update_Row (
  P_PLAN_TEXT_ID        IN NUMBER,
  P_ROLE_ID        IN NUMBER,
  P_SEQUENCE_ID         IN NUMBER,
  P_QUOTA_CATEGORY_ID   IN NUMBER,
  P_TEXT_TYPE           IN VARCHAR2,
  P_TEXT                IN VARCHAR2,
  P_TEXT2               IN VARCHAR2,
  P_ATTRIBUTE_CATEGORY  IN VARCHAR2,
  P_ATTRIBUTE1          IN VARCHAR2,
  P_ATTRIBUTE2          IN VARCHAR2,
  P_ATTRIBUTE3          IN VARCHAR2,
  P_ATTRIBUTE4          IN VARCHAR2,
  P_ATTRIBUTE5          IN VARCHAR2,
  P_ATTRIBUTE6          IN VARCHAR2,
  P_ATTRIBUTE7          IN VARCHAR2,
  P_ATTRIBUTE8          IN VARCHAR2,
  P_ATTRIBUTE9          IN VARCHAR2,
  P_ATTRIBUTE10         IN VARCHAR2,
  P_ATTRIBUTE11         IN VARCHAR2,
  P_ATTRIBUTE12         IN VARCHAR2,
  P_ATTRIBUTE13         IN VARCHAR2,
  P_ATTRIBUTE14         IN VARCHAR2,
  P_ATTRIBUTE15         IN VARCHAR2,
  P_LAST_UPDATE_DATE    IN DATE,
  P_LAST_UPDATED_BY     IN NUMBER,
  P_LAST_UPDATE_LOGIN   IN NUMBER,
  P_OBJECT_VERSION_NUMBER   IN NUMBER,
  P_ROLE_MODEL_ID       IN NUMBER
) IS

BEGIN

  UPDATE cn_plan_texts SET
    PLAN_TEXT_ID = P_PLAN_TEXT_ID,
    ROLE_ID = P_ROLE_ID,
    SEQUENCE_ID = P_SEQUENCE_ID,
    QUOTA_CATEGORY_ID = P_QUOTA_CATEGORY_ID,
    TEXT_TYPE = P_TEXT_TYPE,
    TEXT = P_TEXT,
    TEXT2 = P_TEXT2,
    ATTRIBUTE_CATEGORY = P_ATTRIBUTE_CATEGORY,
    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,
    OBJECT_VERSION_NUMBER = P_OBJECT_VERSION_NUMBER,
    ROLE_MODEL_ID = P_ROLE_MODEL_ID
  WHERE PLAN_TEXT_ID = P_PLAN_TEXT_ID;

Line: 170

END Update_Row;

Line: 172

PROCEDURE Delete_Row (
  P_PLAN_TEXT_ID in NUMBER
) IS

BEGIN

  DELETE FROM cn_plan_texts
  WHERE
    PLAN_TEXT_ID = P_PLAN_TEXT_ID;

Line: 182

END Delete_Row;