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.IGS_AS_ENTRY_CONF_PKG SQL Statements

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

Line: 24


    x_last_update_date             IN     DATE,
    x_last_updated_by              IN     NUMBER,
    x_last_update_login            IN     NUMBER,
    x_key_prtl_sbmn_allowed_ind    IN     VARCHAR2,
    x_upld_ug_sbmtd_grade_exist    IN     VARCHAR2,
    x_upld_ug_saved_grade_exist    IN     VARCHAR2,
    x_upld_asmnt_item_not_exist    IN     VARCHAR2,
    x_upld_asmnt_item_grd_exist    IN     VARCHAR2,
    x_key_derive_unit_grade_flag   IN     VARCHAR2,
    x_key_allow_inst_finalize_flag IN     VARCHAR2,
    x_key_ai_collect_mark_flag     IN     VARCHAR2,
    x_key_ai_mark_mndtry_flag      IN     VARCHAR2,
    x_key_ai_grade_derive_flag     IN     VARCHAR2,
    x_key_ai_allow_invalid_flag    IN     VARCHAR2,
    x_key_ai_mark_entry_dec_points IN     NUMBER
  ) AS
    CURSOR cur_old_ref_values IS
      SELECT *
      FROM   igs_as_entry_conf
      WHERE  ROWID = x_rowid;

Line: 51


        AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT')) THEN
      fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');

Line: 84


    IF (p_action = 'UPDATE') THEN
      new_references.creation_date := old_references.creation_date;

Line: 91


    new_references.last_update_date := x_last_update_date;

Line: 92


    new_references.last_updated_by := x_last_updated_by;

Line: 93


    new_references.last_update_login := x_last_update_login;

Line: 99


      SELECT     ROWID
      FROM       igs_as_entry_conf
      WHERE      s_control_num = x_s_control_num
      FOR UPDATE NOWAIT;

Line: 391


    x_last_update_date             IN     DATE,
    x_last_updated_by              IN     NUMBER,
    x_last_update_login            IN     NUMBER,
    x_key_prtl_sbmn_allowed_ind    IN     VARCHAR2,
    x_upld_ug_sbmtd_grade_exist    IN     VARCHAR2,
    x_upld_ug_saved_grade_exist    IN     VARCHAR2,
    x_upld_asmnt_item_not_exist    IN     VARCHAR2,
    x_upld_asmnt_item_grd_exist    IN     VARCHAR2,
    x_key_derive_unit_grade_flag   IN     VARCHAR2,
    x_key_allow_inst_finalize_flag IN     VARCHAR2,
    x_key_ai_collect_mark_flag     IN     VARCHAR2,
    x_key_ai_mark_mndtry_flag      IN     VARCHAR2,
    x_key_ai_grade_derive_flag     IN     VARCHAR2,
    x_key_ai_allow_invalid_flag    IN     VARCHAR2,
    x_key_ai_mark_entry_dec_points IN     NUMBER
  ) AS
  BEGIN
    set_column_values (
      p_action,
      x_rowid,
      x_s_control_num,
      x_key_allow_invalid_ind,
      x_key_collect_mark_ind,
      x_key_grade_derive_ind,
      x_key_mark_mndtry_ind,
      x_upld_person_no_exist,
      x_upld_crs_not_enrolled,
      x_upld_unit_not_enrolled,
      x_upld_unit_discont,
      x_upld_grade_invalid,
      x_upld_mark_grade_invalid,
      x_key_mark_entry_dec_points,
      x_creation_date,
      x_created_by,
      x_last_update_date,
      x_last_updated_by,
      x_last_update_login,
      x_key_prtl_sbmn_allowed_ind,
      x_upld_ug_sbmtd_grade_exist,
      x_upld_ug_saved_grade_exist,
      x_upld_asmnt_item_not_exist,
      x_upld_asmnt_item_grd_exist,
      x_key_derive_unit_grade_flag,
      x_key_allow_inst_finalize_flag,
      x_key_ai_collect_mark_flag,
      x_key_ai_mark_mndtry_flag,
      x_key_ai_grade_derive_flag,
      x_key_ai_allow_invalid_flag,
      x_key_ai_mark_entry_dec_points
    );

Line: 441


    IF (p_action = 'INSERT') THEN
      -- Call all the procedures related to Before Insert.
      IF get_pk_for_validation (new_references.s_control_num) THEN
        fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');

Line: 449


    ELSIF (p_action = 'UPDATE') THEN
      -- Call all the procedures related to Before Update.
      check_constraints;

Line: 452


    ELSIF (p_action = 'DELETE') THEN
      -- Call all the procedures related to Before Delete.
      NULL;

Line: 455


    ELSIF (p_action = 'VALIDATE_INSERT') THEN
      IF get_pk_for_validation (new_references.s_control_num) THEN
        fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');

Line: 462


    ELSIF (p_action = 'VALIDATE_UPDATE') THEN
      check_constraints;

Line: 464


    ELSIF (p_action = 'VALIDATE_DELETE') THEN
      NULL;

Line: 469


  PROCEDURE insert_row (
    x_rowid                        IN OUT NOCOPY VARCHAR2,
    x_s_control_num                IN     NUMBER,
    x_key_allow_invalid_ind        IN     VARCHAR2,
    x_key_collect_mark_ind         IN     VARCHAR2,
    x_key_grade_derive_ind         IN     VARCHAR2,
    x_key_mark_mndtry_ind          IN     VARCHAR2,
    x_upld_person_no_exist         IN     VARCHAR2,
    x_upld_crs_not_enrolled        IN     VARCHAR2,
    x_upld_unit_not_enrolled       IN     VARCHAR2,
    x_upld_unit_discont            IN     VARCHAR2,
    x_upld_grade_invalid           IN     VARCHAR2,
    x_upld_mark_grade_invalid      IN     VARCHAR2,
    x_key_mark_entry_dec_points    IN     NUMBER,
    x_mode                         IN     VARCHAR2,
    x_key_prtl_sbmn_allowed_ind    IN     VARCHAR2,
    x_upld_ug_sbmtd_grade_exist    IN     VARCHAR2,
    x_upld_ug_saved_grade_exist    IN     VARCHAR2,
    x_upld_asmnt_item_not_exist    IN     VARCHAR2,
    x_upld_asmnt_item_grd_exist    IN     VARCHAR2,
    x_key_derive_unit_grade_flag   IN     VARCHAR2,
    x_key_allow_inst_finalize_flag IN     VARCHAR2,
    x_key_ai_collect_mark_flag     IN     VARCHAR2,
    x_key_ai_mark_mndtry_flag      IN     VARCHAR2,
    x_key_ai_grade_derive_flag     IN     VARCHAR2,
    x_key_ai_allow_invalid_flag    IN     VARCHAR2,
    x_key_ai_mark_entry_dec_points IN     NUMBER
  ) AS
    CURSOR c IS
      SELECT ROWID
      FROM   igs_as_entry_conf
      WHERE  s_control_num = x_s_control_num;

Line: 501


    x_last_update_date  DATE;

Line: 502


    x_last_updated_by   NUMBER;

Line: 503


    x_last_update_login NUMBER;

Line: 505


    x_last_update_date := SYSDATE;

Line: 507


      x_last_updated_by := 1;

Line: 508


      x_last_update_login := 0;

Line: 510


      x_last_updated_by := fnd_global.user_id;

Line: 511


      IF x_last_updated_by IS NULL THEN
        x_last_updated_by := -1;

Line: 514


      x_last_update_login := fnd_global.login_id;

Line: 515


      IF x_last_update_login IS NULL THEN
        x_last_update_login := -1;

Line: 524


      p_action                       => 'INSERT',
      x_rowid                        => x_rowid,
      x_key_allow_invalid_ind        => NVL (x_key_allow_invalid_ind, 'Y'),
      x_key_collect_mark_ind         => NVL (x_key_collect_mark_ind, 'Y'),
      x_key_grade_derive_ind         => NVL (x_key_grade_derive_ind, 'Y'),
      x_key_mark_mndtry_ind          => NVL (x_key_mark_mndtry_ind, 'N'),
      x_s_control_num                => x_s_control_num,
      x_upld_crs_not_enrolled        => NVL (x_upld_crs_not_enrolled, 'D'),
      x_upld_grade_invalid           => NVL (x_upld_grade_invalid, 'D'),
      x_upld_mark_grade_invalid      => NVL (x_upld_mark_grade_invalid, 'D'),
      x_upld_person_no_exist         => NVL (x_upld_person_no_exist, 'D'),
      x_upld_unit_discont            => NVL (x_upld_unit_discont, 'D'),
      x_upld_unit_not_enrolled       => NVL (x_upld_unit_not_enrolled, 'D'),
      x_key_mark_entry_dec_points    => x_key_mark_entry_dec_points,
      x_creation_date                => x_last_update_date,
      x_created_by                   => x_last_updated_by,
      x_last_update_date             => x_last_update_date,
      x_last_updated_by              => x_last_updated_by,
      x_last_update_login            => x_last_update_login,
      x_key_prtl_sbmn_allowed_ind    => x_key_prtl_sbmn_allowed_ind,
      x_upld_ug_sbmtd_grade_exist    => x_upld_ug_sbmtd_grade_exist,
      x_upld_ug_saved_grade_exist    => x_upld_ug_saved_grade_exist,
      x_upld_asmnt_item_not_exist    => x_upld_asmnt_item_not_exist,
      x_upld_asmnt_item_grd_exist    => x_upld_asmnt_item_grd_exist,
      x_key_derive_unit_grade_flag   => x_key_derive_unit_grade_flag,
      x_key_allow_inst_finalize_flag => x_key_allow_inst_finalize_flag,
      x_key_ai_collect_mark_flag     => x_key_ai_collect_mark_flag,
      x_key_ai_mark_mndtry_flag      => x_key_ai_mark_mndtry_flag,
      x_key_ai_grade_derive_flag     => x_key_ai_grade_derive_flag,
      x_key_ai_allow_invalid_flag    => x_key_ai_allow_invalid_flag,
      x_key_ai_mark_entry_dec_points => x_key_ai_mark_entry_dec_points
    );

Line: 556


    INSERT INTO igs_as_entry_conf
                (s_control_num,
                 key_allow_invalid_ind,
                 key_collect_mark_ind,
                 key_grade_derive_ind,
                 key_mark_mndtry_ind,
                 upld_person_no_exist,
                 upld_crs_not_enrolled,
                 upld_unit_not_enrolled,
                 upld_unit_discont,
                 upld_grade_invalid,
                 upld_mark_grade_invalid,
                 key_mark_entry_dec_points, creation_date,
                 created_by, last_update_date, last_updated_by,
                 last_update_login, key_prtl_sbmn_allowed_ind,
                 upld_ug_sbmtd_grade_exist,
                 upld_ug_saved_grade_exist,
                 upld_asmnt_item_not_exist,
                 upld_asmnt_item_grd_exist,
                 key_derive_unit_grade_flag,
                 key_allow_inst_finalize_flag,
                 key_ai_collect_mark_flag,
                 key_ai_mark_mndtry_flag,
                 key_ai_grade_derive_flag,
                 key_ai_allow_invalid_flag,
                 key_ai_mark_entry_dec_points
                 )
         VALUES (new_references.s_control_num,
                 new_references.key_allow_invalid_ind,
                 new_references.key_collect_mark_ind,
                 new_references.key_grade_derive_ind,
                 new_references.key_mark_mndtry_ind,
                 new_references.upld_person_no_exist,
                 new_references.upld_crs_not_enrolled,
                 new_references.upld_unit_not_enrolled,
                 new_references.upld_unit_discont,
                 new_references.upld_grade_invalid,
                 new_references.upld_mark_grade_invalid,
                 new_references.key_mark_entry_dec_points, x_last_update_date,
                 x_last_updated_by, x_last_update_date, x_last_updated_by,
                 x_last_update_login, new_references.key_prtl_sbmn_allowed_ind,
                 new_references.upld_ug_sbmtd_grade_exist,
                 new_references.upld_ug_saved_grade_exist,
                 new_references.upld_asmnt_item_not_exist,
                 new_references.upld_asmnt_item_grd_exist,
                 new_references.key_derive_unit_grade_flag,
                 new_references.key_allow_inst_finalize_flag,
                 new_references.key_ai_collect_mark_flag,
                 new_references.key_ai_mark_mndtry_flag,
                 new_references.key_ai_grade_derive_flag,
                 new_references.key_ai_allow_invalid_flag,
                 new_references.key_ai_mark_entry_dec_points);

Line: 615


  END insert_row;

Line: 645


      SELECT     key_allow_invalid_ind,
                 key_collect_mark_ind,
                 key_grade_derive_ind,
                 key_mark_mndtry_ind,
                 upld_person_no_exist,
                 upld_crs_not_enrolled,
                 upld_unit_not_enrolled,
                 upld_unit_discont,
                 upld_grade_invalid,
                 upld_mark_grade_invalid,
                 key_mark_entry_dec_points,
                 key_prtl_sbmn_allowed_ind,
                 upld_ug_sbmtd_grade_exist,
                 upld_ug_saved_grade_exist,
                 upld_asmnt_item_not_exist,
                 upld_asmnt_item_grd_exist,
                 key_derive_unit_grade_flag,
                 key_allow_inst_finalize_flag,
                 key_ai_collect_mark_flag,
                 key_ai_mark_mndtry_flag,
                 key_ai_grade_derive_flag,
                 key_ai_allow_invalid_flag,
                 key_ai_mark_entry_dec_points
      FROM       igs_as_entry_conf
      WHERE      ROWID = x_rowid
      FOR UPDATE NOWAIT;

Line: 676


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

Line: 768


  PROCEDURE update_row (
    x_rowid                        IN     VARCHAR2,
    x_s_control_num                IN     NUMBER,
    x_key_allow_invalid_ind        IN     VARCHAR2,
    x_key_collect_mark_ind         IN     VARCHAR2,
    x_key_grade_derive_ind         IN     VARCHAR2,
    x_key_mark_mndtry_ind          IN     VARCHAR2,
    x_upld_person_no_exist         IN     VARCHAR2,
    x_upld_crs_not_enrolled        IN     VARCHAR2,
    x_upld_unit_not_enrolled       IN     VARCHAR2,
    x_upld_unit_discont            IN     VARCHAR2,
    x_upld_grade_invalid           IN     VARCHAR2,
    x_upld_mark_grade_invalid      IN     VARCHAR2,
    x_key_mark_entry_dec_points    IN     NUMBER,
    x_mode                         IN     VARCHAR2,
    x_key_prtl_sbmn_allowed_ind    IN     VARCHAR2,
    x_upld_ug_sbmtd_grade_exist    IN     VARCHAR2,
    x_upld_ug_saved_grade_exist    IN     VARCHAR2,
    x_upld_asmnt_item_not_exist    IN     VARCHAR2,
    x_upld_asmnt_item_grd_exist    IN     VARCHAR2,
    x_key_derive_unit_grade_flag   IN     VARCHAR2,
    x_key_allow_inst_finalize_flag IN     VARCHAR2,
    x_key_ai_collect_mark_flag     IN     VARCHAR2,
    x_key_ai_mark_mndtry_flag      IN     VARCHAR2,
    x_key_ai_grade_derive_flag     IN     VARCHAR2,
    x_key_ai_allow_invalid_flag    IN     VARCHAR2,
    x_key_ai_mark_entry_dec_points IN     NUMBER
  ) AS
    x_last_update_date  DATE;

Line: 797


    x_last_updated_by   NUMBER;

Line: 798


    x_last_update_login NUMBER;

Line: 800


    x_last_update_date := SYSDATE;

Line: 802


      x_last_updated_by := 1;

Line: 803


      x_last_update_login := 0;

Line: 805


      x_last_updated_by := fnd_global.user_id;

Line: 806


      IF x_last_updated_by IS NULL THEN
        x_last_updated_by := -1;

Line: 809


      x_last_update_login := fnd_global.login_id;

Line: 810


      IF x_last_update_login IS NULL THEN
        x_last_update_login := -1;

Line: 819


      p_action                       => 'UPDATE',
      x_rowid                        => x_rowid,
      x_key_allow_invalid_ind        => x_key_allow_invalid_ind,
      x_key_collect_mark_ind         => x_key_collect_mark_ind,
      x_key_grade_derive_ind         => x_key_grade_derive_ind,
      x_key_mark_mndtry_ind          => x_key_mark_mndtry_ind,
      x_s_control_num                => x_s_control_num,
      x_upld_crs_not_enrolled        => x_upld_crs_not_enrolled,
      x_upld_grade_invalid           => x_upld_grade_invalid,
      x_upld_mark_grade_invalid      => x_upld_mark_grade_invalid,
      x_upld_person_no_exist         => x_upld_person_no_exist,
      x_upld_unit_discont            => x_upld_unit_discont,
      x_upld_unit_not_enrolled       => x_upld_unit_not_enrolled,
      x_key_mark_entry_dec_points    => x_key_mark_entry_dec_points,
      x_creation_date                => x_last_update_date,
      x_created_by                   => x_last_updated_by,
      x_last_update_date             => x_last_update_date,
      x_last_updated_by              => x_last_updated_by,
      x_last_update_login            => x_last_update_login,
      x_key_prtl_sbmn_allowed_ind    => x_key_prtl_sbmn_allowed_ind,
      x_upld_ug_sbmtd_grade_exist    => x_upld_ug_sbmtd_grade_exist,
      x_upld_ug_saved_grade_exist    => x_upld_ug_saved_grade_exist,
      x_upld_asmnt_item_not_exist    => x_upld_asmnt_item_not_exist,
      x_upld_asmnt_item_grd_exist    => x_upld_asmnt_item_grd_exist,
      x_key_derive_unit_grade_flag   => x_key_derive_unit_grade_flag,
      x_key_allow_inst_finalize_flag => x_key_allow_inst_finalize_flag,
      x_key_ai_collect_mark_flag     => x_key_ai_collect_mark_flag,
      x_key_ai_mark_mndtry_flag      => x_key_ai_mark_mndtry_flag,
      x_key_ai_grade_derive_flag     => x_key_ai_grade_derive_flag,
      x_key_ai_allow_invalid_flag    => x_key_ai_allow_invalid_flag,
      x_key_ai_mark_entry_dec_points => x_key_ai_mark_entry_dec_points
    );

Line: 851


    UPDATE igs_as_entry_conf
       SET key_allow_invalid_ind = new_references.key_allow_invalid_ind,
           key_collect_mark_ind = new_references.key_collect_mark_ind,
           key_grade_derive_ind = new_references.key_grade_derive_ind,
           key_mark_mndtry_ind = new_references.key_mark_mndtry_ind,
           upld_person_no_exist = new_references.upld_person_no_exist,
           upld_crs_not_enrolled = new_references.upld_crs_not_enrolled,
           upld_unit_not_enrolled = new_references.upld_unit_not_enrolled,
           upld_unit_discont = new_references.upld_unit_discont,
           upld_grade_invalid = new_references.upld_grade_invalid,
           upld_mark_grade_invalid = new_references.upld_mark_grade_invalid,
           key_mark_entry_dec_points = new_references.key_mark_entry_dec_points,
           last_update_date = x_last_update_date,
           last_updated_by = x_last_updated_by,
           last_update_login = x_last_update_login,
           key_prtl_sbmn_allowed_ind = x_key_prtl_sbmn_allowed_ind,
           upld_ug_sbmtd_grade_exist = x_upld_ug_sbmtd_grade_exist,
           upld_ug_saved_grade_exist = x_upld_ug_saved_grade_exist,
           upld_asmnt_item_not_exist = x_upld_asmnt_item_not_exist,
           upld_asmnt_item_grd_exist = x_upld_asmnt_item_grd_exist,
           key_derive_unit_grade_flag = x_key_derive_unit_grade_flag,
           key_allow_inst_finalize_flag = x_key_allow_inst_finalize_flag,
           key_ai_collect_mark_flag = x_key_ai_collect_mark_flag,
           key_ai_mark_mndtry_flag = x_key_ai_mark_mndtry_flag,
           key_ai_grade_derive_flag = x_key_ai_grade_derive_flag,
           key_ai_allow_invalid_flag = x_key_ai_allow_invalid_flag,
           key_ai_mark_entry_dec_points = x_key_ai_mark_entry_dec_points
     WHERE ROWID = x_rowid;

Line: 882


  END update_row;

Line: 913


      SELECT ROWID
      FROM   igs_as_entry_conf
      WHERE  s_control_num = x_s_control_num;

Line: 921


      insert_row (
        x_rowid,
        x_s_control_num,
        x_key_allow_invalid_ind,
        x_key_collect_mark_ind,
        x_key_grade_derive_ind,
        x_key_mark_mndtry_ind,
        x_upld_person_no_exist,
        x_upld_crs_not_enrolled,
        x_upld_unit_not_enrolled,
        x_upld_unit_discont,
        x_upld_grade_invalid,
        x_upld_mark_grade_invalid,
        x_key_mark_entry_dec_points,
        x_mode,
        x_key_prtl_sbmn_allowed_ind,
        x_upld_ug_sbmtd_grade_exist,
        x_upld_ug_saved_grade_exist,
        x_upld_asmnt_item_not_exist,
        x_upld_asmnt_item_grd_exist,
        x_key_derive_unit_grade_flag,
        x_key_allow_inst_finalize_flag,
        x_key_ai_collect_mark_flag,
        x_key_ai_mark_mndtry_flag,
        x_key_ai_grade_derive_flag,
        x_key_ai_allow_invalid_flag,
        x_key_ai_mark_entry_dec_points
      );

Line: 952


    update_row (
      x_rowid,
      x_s_control_num,
      x_key_allow_invalid_ind,
      x_key_collect_mark_ind,
      x_key_grade_derive_ind,
      x_key_mark_mndtry_ind,
      x_upld_person_no_exist,
      x_upld_crs_not_enrolled,
      x_upld_unit_not_enrolled,
      x_upld_unit_discont,
      x_upld_grade_invalid,
      x_upld_mark_grade_invalid,
      x_key_mark_entry_dec_points,
      x_mode,
      x_key_prtl_sbmn_allowed_ind,
      x_upld_ug_sbmtd_grade_exist,
      x_upld_ug_saved_grade_exist,
      x_upld_asmnt_item_not_exist,
      x_upld_asmnt_item_grd_exist,
      x_key_derive_unit_grade_flag,
      x_key_allow_inst_finalize_flag,
      x_key_ai_collect_mark_flag,
      x_key_ai_mark_mndtry_flag,
      x_key_ai_grade_derive_flag,
      x_key_ai_allow_invalid_flag,
      x_key_ai_mark_entry_dec_points
    );

Line: 982


  PROCEDURE delete_row (x_rowid IN VARCHAR2) AS
  BEGIN
    before_dml (
      p_action                       => 'DELETE',
      x_rowid                        => x_rowid
    );

Line: 988


    DELETE FROM igs_as_entry_conf
          WHERE ROWID = x_rowid;

Line: 994


  END delete_row;