eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_KR_GRADE_AMOUNT_PKG SQL Statements

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

Line: 4


PROCEDURE insert_row
(p_row_id          IN OUT NOCOPY VARCHAR2
,p_grade_amount_id IN OUT NOCOPY NUMBER
,p_effective_start_date   DATE
,p_effective_end_date     DATE
,p_grade_id               NUMBER
,p_grade_amount           NUMBER
,p_object_version_number  NUMBER
,p_last_update_date       DATE
,p_last_updated_by        NUMBER
,p_last_update_login      NUMBER
,p_created_by             NUMBER
,p_creation_date          DATE
,p_attribute_category     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_attribute16            VARCHAR2
,p_attribute17            VARCHAR2
,p_attribute18            VARCHAR2
,p_attribute19            VARCHAR2
,p_attribute20            VARCHAR2
,p_attribute21            VARCHAR2
,p_attribute22            VARCHAR2
,p_attribute23            VARCHAR2
,p_attribute24            VARCHAR2
,p_attribute25            VARCHAR2
,p_attribute26            VARCHAR2
,p_attribute27            VARCHAR2
,p_attribute28            VARCHAR2
,p_attribute29            VARCHAR2
,p_attribute30            VARCHAR2
) IS
  --
  CURSOR c_s1 IS
    SELECT per_kr_grade_amount_s.NEXTVAL
    FROM   dual;

Line: 65


  INSERT INTO per_kr_grade_amount_f
    (grade_amount_id
    ,effective_start_date
    ,effective_end_date
    ,grade_id
    ,grade_amount
    ,object_version_number
    ,last_update_date
    ,last_updated_by
    ,last_update_login
    ,created_by
    ,creation_date
    ,attribute_category
    ,attribute1
    ,attribute2
    ,attribute3
    ,attribute4
    ,attribute5
    ,attribute6
    ,attribute7
    ,attribute8
    ,attribute9
    ,attribute10
    ,attribute11
    ,attribute12
    ,attribute13
    ,attribute14
    ,attribute15
    ,attribute16
    ,attribute17
    ,attribute18
    ,attribute19
    ,attribute20
    ,attribute21
    ,attribute22
    ,attribute23
    ,attribute24
    ,attribute25
    ,attribute26
    ,attribute27
    ,attribute28
    ,attribute29
    ,attribute30
    ) VALUES (
     p_grade_amount_id
    ,p_effective_start_date
    ,p_effective_end_date
    ,p_grade_id
    ,p_grade_amount
    ,p_object_version_number
    ,p_last_update_date
    ,p_last_updated_by
    ,p_last_update_login
    ,p_created_by
    ,p_creation_date
    ,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_attribute16
    ,p_attribute17
    ,p_attribute18
    ,p_attribute19
    ,p_attribute20
    ,p_attribute21
    ,p_attribute22
    ,p_attribute23
    ,p_attribute24
    ,p_attribute25
    ,p_attribute26
    ,p_attribute27
    ,p_attribute28
    ,p_attribute29
    ,p_attribute30
    )
    returning rowidtochar(rowid) into p_row_id;

Line: 154


END insert_row;

Line: 164


,p_last_update_date      DATE
,p_last_updated_by       NUMBER
,p_last_update_login     NUMBER
,p_created_by            NUMBER
,p_creation_date         DATE
,p_attribute_category    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_attribute16           VARCHAR2
,p_attribute17           VARCHAR2
,p_attribute18           VARCHAR2
,p_attribute19           VARCHAR2
,p_attribute20           VARCHAR2
,p_attribute21           VARCHAR2
,p_attribute22           VARCHAR2
,p_attribute23           VARCHAR2
,p_attribute24           VARCHAR2
,p_attribute25           VARCHAR2
,p_attribute26           VARCHAR2
,p_attribute27           VARCHAR2
,p_attribute28           VARCHAR2
,p_attribute29           VARCHAR2
,p_attribute30           VARCHAR2
) IS
  --
  CURSOR c1 IS
    SELECT grade_amount_id
          ,effective_start_date
          ,effective_end_date
          ,grade_id
          ,grade_amount
          ,object_version_number
          ,last_update_date
          ,last_updated_by
          ,last_update_login
          ,created_by
          ,creation_date
          ,attribute_category
          ,attribute1
          ,attribute2
          ,attribute3
          ,attribute4
          ,attribute5
          ,attribute6
          ,attribute7
          ,attribute8
          ,attribute9
          ,attribute10
          ,attribute11
          ,attribute12
          ,attribute13
          ,attribute14
          ,attribute15
          ,attribute16
          ,attribute17
          ,attribute18
          ,attribute19
          ,attribute20
          ,attribute21
          ,attribute22
          ,attribute23
          ,attribute24
          ,attribute25
          ,attribute26
          ,attribute27
          ,attribute28
          ,attribute29
          ,attribute30
    FROM per_kr_grade_amount
    WHERE rowid = chartorowid(p_row_id)
    FOR UPDATE OF grade_amount_id NOWAIT;

Line: 258


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

Line: 274


     AND   (  (recinfo.last_update_date = p_last_update_date)
           OR (   (recinfo.last_update_date IS NULL)
              AND (p_last_update_date IS NULL)))
     AND   (  (recinfo.last_updated_by = p_last_updated_by)
           OR (   (recinfo.last_updated_by IS NULL)
              AND (p_last_updated_by IS NULL)))
     AND   (  (recinfo.last_update_login = p_last_update_login)
           OR (   (recinfo.last_update_login IS NULL)
              AND (p_last_update_login IS NULL)))
     AND   (  (recinfo.created_by = p_created_by)
           OR (   (recinfo.created_by IS NULL)
              AND (p_created_by IS NULL)))
     AND   (  (recinfo.creation_date = p_creation_date)
           OR (   (recinfo.creation_date IS NULL)
              AND (p_creation_date IS NULL)))
     AND   (  (recinfo.attribute_category = p_attribute_category)
           OR (   (recinfo.attribute_category IS NULL)
              AND (p_attribute_category IS NULL)))
     AND   (  (recinfo.attribute1 = p_attribute1)
           OR (   (recinfo.attribute1 IS NULL)
              AND (p_attribute1 IS NULL)))
     AND   (  (recinfo.attribute2 = p_attribute2)
           OR (   (recinfo.attribute2 IS NULL)
              AND (p_attribute2 IS NULL)))
     AND   (  (recinfo.attribute3 = p_attribute3)
           OR (   (recinfo.attribute3 IS NULL)
              AND (p_attribute3 IS NULL)))
     AND   (  (recinfo.attribute4 = p_attribute4)
           OR (   (recinfo.attribute4 IS NULL)
              AND (p_attribute4 IS NULL)))
     AND   (  (recinfo.attribute5 = p_attribute5)
           OR (   (recinfo.attribute5 IS NULL)
              AND (p_attribute5 IS NULL)))
     AND   (  (recinfo.attribute6 = p_attribute6)
           OR (   (recinfo.attribute6 IS NULL)
              AND (p_attribute6 IS NULL)))
     AND   (  (recinfo.attribute7 = p_attribute7)
           OR (   (recinfo.attribute7 IS NULL)
              AND (p_attribute7 IS NULL)))
     AND   (  (recinfo.attribute8 = p_attribute8)
           OR (   (recinfo.attribute8 IS NULL)
              AND (p_attribute8 IS NULL)))
     AND   (  (recinfo.attribute9 = p_attribute9)
           OR (   (recinfo.attribute9 IS NULL)
              AND (p_attribute9 IS NULL)))
     AND   (  (recinfo.attribute10 = p_attribute10)
           OR (   (recinfo.attribute10 IS NULL)
              AND (p_attribute10 IS NULL)))
     AND   (  (recinfo.attribute11 = p_attribute11)
           OR (   (recinfo.attribute11 IS NULL)
              AND (p_attribute11 IS NULL)))
     AND   (  (recinfo.attribute12 = p_attribute12)
           OR (   (recinfo.attribute12 IS NULL)
              AND (p_attribute12 IS NULL)))
     AND   (  (recinfo.attribute13 = p_attribute13)
           OR (   (recinfo.attribute13 IS NULL)
              AND (p_attribute13 IS NULL)))
     AND   (  (recinfo.attribute14 = p_attribute14)
           OR (   (recinfo.attribute14 IS NULL)
              AND (p_attribute14 IS NULL)))
     AND   (  (recinfo.attribute15 = p_attribute15)
           OR (   (recinfo.attribute15 IS NULL)
              AND (p_attribute15 IS NULL)))
     AND   (  (recinfo.attribute16 = p_attribute16)
           OR (   (recinfo.attribute16 IS NULL)
              AND (p_attribute16 IS NULL)))
     AND   (  (recinfo.attribute17 = p_attribute17)
           OR (   (recinfo.attribute17 IS NULL)
              AND (p_attribute17 IS NULL)))
     AND   (  (recinfo.attribute18 = p_attribute18)
           OR (   (recinfo.attribute18 IS NULL)
              AND (p_attribute18 IS NULL)))
     AND   (  (recinfo.attribute19 = p_attribute19)
           OR (   (recinfo.attribute19 IS NULL)
              AND (p_attribute19 IS NULL)))
     AND   (  (recinfo.attribute20 = p_attribute20)
           OR (   (recinfo.attribute20 IS NULL)
              AND (p_attribute20 IS NULL)))
     AND   (  (recinfo.attribute21 = p_attribute21)
           OR (   (recinfo.attribute21 IS NULL)
              AND (p_attribute21 IS NULL)))
     AND   (  (recinfo.attribute22 = p_attribute22)
           OR (   (recinfo.attribute22 IS NULL)
              AND (p_attribute22 IS NULL)))
     AND   (  (recinfo.attribute23 = p_attribute23)
           OR (   (recinfo.attribute23 IS NULL)
              AND (p_attribute23 IS NULL)))
     AND   (  (recinfo.attribute24 = p_attribute24)
           OR (   (recinfo.attribute24 IS NULL)
              AND (p_attribute24 IS NULL)))
     AND   (  (recinfo.attribute25 = p_attribute25)
           OR (   (recinfo.attribute25 IS NULL)
              AND (p_attribute25 IS NULL)))
     AND   (  (recinfo.attribute26 = p_attribute26)
           OR (   (recinfo.attribute26 IS NULL)
              AND (p_attribute26 IS NULL)))
     AND   (  (recinfo.attribute27 = p_attribute27)
           OR (   (recinfo.attribute27 IS NULL)
              AND (p_attribute27 IS NULL)))
     AND   (  (recinfo.attribute28 = p_attribute28)
           OR (   (recinfo.attribute28 IS NULL)
              AND (p_attribute28 IS NULL)))
     AND   (  (recinfo.attribute29 = p_attribute29)
           OR (   (recinfo.attribute29 IS NULL)
              AND (p_attribute29 IS NULL)))
     AND   (  (recinfo.attribute30 = p_attribute30)
           OR (   (recinfo.attribute30 IS NULL)
              AND (p_attribute30 IS NULL)))
     ) THEN
      RETURN;

Line: 391


PROCEDURE update_row
(p_row_id                VARCHAR2
,p_grade_amount_id       NUMBER
,p_effective_start_date  DATE
,p_effective_end_date    DATE
,p_grade_id              NUMBER
,p_grade_amount          NUMBER
,p_object_version_number NUMBER
,p_last_update_date      DATE
,p_last_updated_by       NUMBER
,p_last_update_login     NUMBER
,p_created_by            NUMBER
,p_creation_date         DATE
,p_attribute_category    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_attribute16           VARCHAR2
,p_attribute17           VARCHAR2
,p_attribute18           VARCHAR2
,p_attribute19           VARCHAR2
,p_attribute20           VARCHAR2
,p_attribute21           VARCHAR2
,p_attribute22           VARCHAR2
,p_attribute23           VARCHAR2
,p_attribute24           VARCHAR2
,p_attribute25           VARCHAR2
,p_attribute26           VARCHAR2
,p_attribute27           VARCHAR2
,p_attribute28           VARCHAR2
,p_attribute29           VARCHAR2
,p_attribute30           VARCHAR2
) IS
BEGIN
  UPDATE per_kr_grade_amount
  SET effective_start_date  = p_effective_start_date
     ,effective_end_date    = p_effective_end_date
     ,grade_amount          = p_grade_amount
     ,object_version_number = p_object_version_number
     ,last_update_date      = p_last_update_date
     ,last_updated_by       = p_last_updated_by
     ,last_update_login     = p_last_update_login
     ,created_by            = p_created_by
     ,creation_date         = p_creation_date
     ,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
     ,attribute16           = p_attribute16
     ,attribute17           = p_attribute17
     ,attribute18           = p_attribute18
     ,attribute19           = p_attribute19
     ,attribute20           = p_attribute20
     ,attribute21           = p_attribute21
     ,attribute22           = p_attribute22
     ,attribute23           = p_attribute23
     ,attribute24           = p_attribute24
     ,attribute25           = p_attribute25
     ,attribute26           = p_attribute26
     ,attribute27           = p_attribute27
     ,attribute28           = p_attribute28
     ,attribute29           = p_attribute29
     ,attribute30           = p_attribute30
  WHERE rowid = chartorowid(p_row_id);

Line: 484


END update_row;

Line: 486


PROCEDURE delete_row
(p_row_id VARCHAR2
) IS
BEGIN
  --
  DELETE FROM per_kr_grade_amount_f
  WHERE rowid = chartorowid(p_row_id);

Line: 498


END delete_row;