DBA Data[Home] [Help]

APPS.IGS_AV_STND_UNIT_LVL_PKG SQL Statements

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

Line: 39

    x_last_update_date      IN DATE,
    x_last_updated_by     IN NUMBER,
    x_last_update_login     IN NUMBER,
    x_org_id        IN NUMBER,
    X_DEG_AUD_DETAIL_ID     IN NUMBER,
    X_QUAL_DETS_ID      IN NUMBER,
    X_UNIT_LEVEL_MARK     IN NUMBER
    ) AS

    CURSOR cur_old_ref_values IS
      SELECT   *
      FROM     IGS_AV_STND_UNIT_LVL_ALL
      WHERE    rowid = x_rowid;
Line: 58

    IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
      Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
Line: 92

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

    new_references.last_update_date := x_last_update_date;
Line: 100

    new_references.last_updated_by := x_last_updated_by;
Line: 101

    new_references.last_update_login := x_last_update_login;
Line: 108

  PROCEDURE BeforeRowInsertUpdateDelete1(
    p_inserting IN BOOLEAN,
    p_updating IN BOOLEAN,
    p_deleting IN BOOLEAN,
    p_adv_stnd_trans IN VARCHAR2 -- This parameter has been added for Career Impact DLD.
    ) AS
    v_message_name   VARCHAR2(30);
Line: 121

    IF p_inserting THEN
      IF new_references.s_adv_stnd_type <> 'LEVEL' THEN
        Fnd_Message.Set_Name('IGS', 'IGS_AV_TYPE_MUSTBE_LEVEL');
Line: 135

    IF p_inserting OR p_updating THEN
      IF igs_av_val_asule.advp_val_ule_closed (
           new_references.UNIT_LEVEL,
           v_message_name) = FALSE THEN
        Fnd_Message.Set_Name('IGS', v_message_name);
Line: 146

       (p_inserting OR
       (NVL(old_references.approved_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <>
        new_references.approved_dt)) THEN
      IF igs_av_val_asu.advp_val_as_dates (
           new_references.approved_dt,
           'APPROVED',
           v_message_name,
           p_adv_stnd_trans) = FALSE THEN
        Fnd_Message.Set_Name('IGS', v_message_name);
Line: 180

       (p_inserting OR
       (NVL(old_references.granted_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <>
        new_references.granted_dt)) THEN
      IF igs_av_val_asu.advp_val_as_dates (
           new_references.granted_dt,
           'GRANTED',
           v_message_name,
           p_adv_stnd_trans) = FALSE THEN
        Fnd_Message.Set_Name('IGS', v_message_name);
Line: 195

       (p_inserting OR
       (NVL(old_references.expiry_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <>
        new_references.expiry_dt)) THEN
      IF igs_av_val_asu.advp_val_expiry_dt (
          new_references.expiry_dt,
          v_message_name,
          p_adv_stnd_trans) = FALSE THEN
                           Fnd_Message.Set_Name('IGS', v_message_name);
Line: 209

       (p_inserting OR
       (NVL(old_references.cancelled_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <>
        new_references.cancelled_dt)) THEN
      IF igs_av_val_asu.advp_val_as_dates (
          new_references.cancelled_dt,
          'CANCELLED',
          v_message_name) = FALSE THEN
        Fnd_Message.Set_Name('IGS', v_message_name);
Line: 231

       (p_inserting OR
       (NVL(old_references.revoked_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <>
        new_references.revoked_dt)) THEN
      IF igs_av_val_asu.advp_val_as_dates (
          new_references.revoked_dt,
          'REVOKED',
          v_message_name) = FALSE THEN
        Fnd_Message.Set_Name('IGS', v_message_name);
Line: 252

    IF p_inserting OR (p_updating AND (new_references.s_adv_stnd_granting_status <>
        old_references.s_adv_stnd_granting_status)) THEN
      IF new_references.s_adv_stnd_granting_status = 'GRANTED' THEN
        IF igs_av_val_asu.advp_val_status_dts (
             'GRANTED',
             new_references.granted_dt,
             v_message_name,
             p_adv_stnd_trans
           ) = FALSE THEN
          Fnd_Message.Set_Name('IGS', v_message_name);
Line: 312

      IF p_inserting OR
         (p_updating AND (new_references.authorising_person_id <> old_references.authorising_person_id)) THEN
        IF igs_co_val_oc.genp_val_prsn_id (
             new_references.authorising_person_id,
             v_message_name) = FALSE THEN
          Fnd_Message.Set_Name('IGS', v_message_name);
Line: 347

    IF p_inserting OR (p_updating AND (new_references.exemption_institution_cd <>
        old_references.exemption_institution_cd)) THEN
      IF igs_av_val_asu.advp_val_asu_inst (
           new_references.exemption_institution_cd,
           v_message_name) = FALSE THEN
        Fnd_Message.Set_Name('IGS', v_message_name);
Line: 358

    IF p_inserting OR p_updating THEN
      v_person_id   :=  new_references.person_id;
Line: 380

    IF p_inserting THEN
      igs_pr_gen_003.igs_pr_ins_adv_todo (
        new_references.person_id,
        new_references.as_course_cd,
        new_references.as_version_number,
        'CREDIT',
        'CREDIT',
        new_references.s_adv_stnd_granting_status,
        new_references.s_adv_stnd_granting_status,
        new_references.credit_points,
        new_references.credit_points,
        NULL,
        NULL
      );
Line: 423

  END BeforeRowInsertUpdateDelete1;
Line: 431

  PROCEDURE AfterRowInsertUpdateDelete2(
    p_inserting IN BOOLEAN,
    p_updating IN BOOLEAN,
    p_deleting IN BOOLEAN
    ) AS
  v_rowid_saved   BOOLEAN := FALSE;
Line: 443

    IF (p_inserting) THEN
        IF IGS_AV_GEN_001.ADVP_UPD_AS_TOTALS (
      new_references.person_id,
      new_references.as_course_cd,
      new_references.as_version_number,
      v_message_name,
      new_references.exemption_institution_cd) = FALSE THEN
        Fnd_Message.Set_Name('IGS', v_message_name);
Line: 466

  END AfterRowInsertUpdateDelete2;
Line: 683

       Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
Line: 697

      SELECT 1
      FROM  user_objects
      WHERE object_name = 'IGS_UC_QUAL_DETS_PKG'
      AND   object_type='PACKAGE';
Line: 707

          'BEGIN IF NOT IGS_UC_QUAL_DETS_PKG.Get_PK_For_Validation(:1) THEN Fnd_Message.Set_Name (''FND'', ''FORM_RECORD_DELETED''); Igs_Ge_Msg_Stack.Add; App_Exception.Raise_Exception; END IF; END;'
Line: 722

       Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
Line: 735

       Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
Line: 747

       Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
Line: 762

         Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
Line: 782

      SELECT   rowid
      FROM     IGS_AV_STND_UNIT_LVL_ALL
      WHERE    av_stnd_unit_lvl_id = x_av_stnd_unit_lvl_id
      FOR UPDATE NOWAIT;
Line: 824

      SELECT   rowid
      FROM     igs_av_stnd_unit_lvl_all
      WHERE   person_id = x_person_id  AND
       exemption_institution_cd =  x_exemption_institution_cd AND
       ((unit_details_id = x_unit_details_id ) OR (unit_details_id IS NULL AND x_unit_details_id IS NULL))        AND
       ((tst_rslt_dtls_id = x_tst_rslt_dtls_id) OR ( tst_rslt_dtls_id IS NULL AND x_tst_rslt_dtls_id IS NULL))  AND
       ((qual_dets_id = x_qual_dets_id) OR ( qual_dets_id IS NULL AND x_qual_dets_id IS NULL))  AND /* Added as per bug#2423651 */
       unit_level        = x_unit_level        AND
       as_course_cd      = x_as_course_cd      AND
       as_version_number = x_as_version_number AND
       s_adv_stnd_type   = x_s_adv_stnd_type   AND
       crs_group_ind     = x_crs_group_ind     AND
       ((l_rowid is null) or (rowid <> l_rowid));
Line: 864

      SELECT   rowid
      FROM     IGS_AV_STND_UNIT_LVL_ALL
      WHERE    person_id = x_person_id
      AND      as_course_cd = x_course_cd
      AND      as_version_number = x_version_number
      AND      exemption_institution_cd=x_exemption_institution_cd ;
Line: 891

      SELECT   rowid
      FROM     IGS_AV_STND_UNIT_LVL_ALL
      WHERE    authorising_person_id = x_person_id ;
Line: 912

      SELECT   rowid
      FROM     IGS_AV_STND_UNIT_LVL_ALL
      WHERE    s_adv_stnd_granting_status = x_s_adv_stnd_granting_status ;
Line: 936

      SELECT   rowid
      FROM     IGS_AV_STND_UNIT_LVL_ALL
      WHERE    cal_type = x_cal_type
      AND      ci_sequence_number = x_ci_sequence_number ;
Line: 959

  SELECT   rowid
  FROM     IGS_AV_STND_UNIT_LVL_ALL
  WHERE    qual_dets_id = x_qual_dets_id;
Line: 981

      SELECT   rowid
      FROM     IGS_AV_STND_UNIT_LVL_ALL
      WHERE    unit_details_id = x_unit_details_id;
Line: 1002

      SELECT   rowid
      FROM     IGS_AV_STND_UNIT_LVL_ALL
      WHERE    tst_rslt_dtls_id = x_tst_rslt_dtls_id;
Line: 1049

    x_last_update_date IN DATE,
    x_last_updated_by IN NUMBER,
    x_last_update_login IN NUMBER,
    x_org_id IN NUMBER,
    x_adv_stnd_trans IN VARCHAR2, -- This parameter has been added for Career Impact DLD.
    X_DEG_AUD_DETAIL_ID  IN NUMBER,
    X_QUAL_DETS_ID  IN NUMBER,
    X_UNIT_LEVEL_MARK     IN NUMBER

  ) AS
  BEGIN
    Set_Column_Values (
      p_action,
      x_rowid,
      x_person_id,
      x_as_course_cd,
      x_as_version_number,
      x_s_adv_stnd_type,
      x_unit_level,
      x_crs_group_ind,
      x_exemption_institution_cd,
      x_s_adv_stnd_granting_status,
      x_credit_points,
      x_approved_dt,
      x_authorising_person_id,
      x_granted_dt,
      x_expiry_dt,
      x_cancelled_dt,
      x_revoked_dt,
      x_comments,
      X_AV_STND_UNIT_LVL_ID,
      X_CAL_TYPE,
      X_CI_SEQUENCE_NUMBER,
      X_INSTITUTION_CD,
      X_UNIT_DETAILS_ID,
      X_TST_RSLT_DTLS_ID,
      x_creation_date,
      x_created_by,
      x_last_update_date,
      x_last_updated_by,
      x_last_update_login,
      x_org_id,
      X_DEG_AUD_DETAIL_ID,
      X_QUAL_DETS_ID,
      X_UNIT_LEVEL_MARK
    );
Line: 1095

    IF (p_action = 'INSERT') THEN
      -- Call all the procedures related to Before Insert.
      BeforeRowInsertUpdateDelete1 ( p_inserting => TRUE,
                                     p_updating  => FALSE,
                                     p_deleting  => FALSE,
                                     p_adv_stnd_trans => x_adv_stnd_trans);
Line: 1111

    ELSIF (p_action = 'UPDATE') THEN
      -- Call all the procedures related to Before Update.
      BeforeRowInsertUpdateDelete1 ( p_inserting => FALSE,
                                     p_updating  => TRUE,
                                     p_deleting  => FALSE,
             p_adv_stnd_trans => 'N');
Line: 1120

    ELSIF (p_action = 'DELETE') THEN
      -- Call all the procedures related to Before Delete.
      BeforeRowInsertUpdateDelete1 ( p_inserting => FALSE,
                                     p_updating  => FALSE,
                                     p_deleting  => TRUE,
             p_adv_stnd_trans => 'N');
Line: 1128

  ELSIF (p_action = 'VALIDATE_INSERT') THEN
        IF  Get_PK_For_Validation (
                new_references.av_stnd_unit_lvl_id
       ) THEN
           Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
Line: 1138

  ELSIF (p_action = 'VALIDATE_UPDATE') THEN
               check_uniqueness;
Line: 1141

  ELSIF (p_action = 'VALIDATE_DELETE') THEN
        Check_Child_Existance;
Line: 1152

    IF (p_action = 'INSERT') THEN
      -- Call all the procedures related to After Insert.
      AfterRowInsertUpdateDelete2( p_inserting => TRUE,
                                     p_updating  => FALSE,
                                     p_deleting  => FALSE);
Line: 1157

    ELSIF (p_action = 'UPDATE') THEN
      -- Call all the procedures related to After Update.
      AfterRowInsertUpdateDelete2( p_inserting => FALSE,
                                     p_updating  => TRUE,
                                     p_deleting  => FALSE);
Line: 1162

    ELSIF (p_action = 'DELETE') THEN
      -- Call all the procedures related to After Delete.
      AfterRowInsertUpdateDelete2( p_inserting => FALSE,
                                     p_updating  => FALSE,
                                     p_deleting  => TRUE);
Line: 1170

procedure INSERT_ROW (
  X_ROWID in out NOCOPY VARCHAR2,
  X_PERSON_ID in NUMBER,
  X_AS_COURSE_CD in VARCHAR2,
  X_AS_VERSION_NUMBER in NUMBER,
  X_S_ADV_STND_TYPE in out NOCOPY VARCHAR2,
  X_UNIT_LEVEL in VARCHAR2,
  X_CRS_GROUP_IND in out NOCOPY VARCHAR2,
  X_EXEMPTION_INSTITUTION_CD in VARCHAR2,
  X_S_ADV_STND_GRANTING_STATUS in VARCHAR2,
  X_CREDIT_POINTS in NUMBER,
  X_APPROVED_DT in DATE,
  X_AUTHORISING_PERSON_ID in NUMBER,
  X_GRANTED_DT in DATE,
  X_EXPIRY_DT in DATE,
  X_CANCELLED_DT in DATE,
  X_REVOKED_DT in DATE,
  X_COMMENTS in VARCHAR2,
  X_AV_STND_UNIT_LVL_ID IN OUT NOCOPY NUMBER,
  X_CAL_TYPE            IN VARCHAR2,
  X_CI_SEQUENCE_NUMBER  IN NUMBER,
  X_INSTITUTION_CD      IN VARCHAR2,
  X_UNIT_DETAILS_ID     in NUMBER,
  X_TST_RSLT_DTLS_ID    in NUMBER,
  X_MODE    in VARCHAR2,
  X_ORG_ID    in NUMBER,
  X_ADV_STND_TRANS  IN VARCHAR2,  -- This parameter has been added for Career Impact DLD.
  X_DEG_AUD_DETAIL_ID IN NUMBER,
  X_QUAL_DETS_ID  IN NUMBER,
  X_UNIT_LEVEL_MARK     IN NUMBER
  ) AS
    cursor C is select ROWID from IGS_AV_STND_UNIT_LVL_ALL
      where av_stnd_unit_lvl_id = x_av_stnd_unit_lvl_id;
Line: 1204

    X_LAST_UPDATE_DATE    DATE;
Line: 1205

    X_LAST_UPDATED_BY   NUMBER;
Line: 1206

    X_LAST_UPDATE_LOGIN   NUMBER;
Line: 1210

    X_PROGRAM_UPDATE_DATE DATE;
Line: 1212

  X_LAST_UPDATE_DATE := SYSDATE;
Line: 1214

    X_LAST_UPDATED_BY := 1;
Line: 1215

    X_LAST_UPDATE_LOGIN := 0;
Line: 1217

    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 1218

    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;
Line: 1221

    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
Line: 1222

    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;
Line: 1232

        X_PROGRAM_UPDATE_DATE := NULL;
Line: 1234

        X_PROGRAM_UPDATE_DATE := SYSDATE ;
Line: 1241

  select IGS_AV_STND_UNIT_LVL_S.NEXTVAL INTO x_av_stnd_unit_lvl_id FROM DUAL;
Line: 1243

 p_action=>'INSERT',
 x_rowid=>X_ROWID,
 x_approved_dt=>X_APPROVED_DT,
 x_as_course_cd=>X_AS_COURSE_CD,
 x_as_version_number=>X_AS_VERSION_NUMBER,
 x_authorising_person_id=>X_AUTHORISING_PERSON_ID,
 x_cancelled_dt=>X_CANCELLED_DT,
 x_comments=>X_COMMENTS,
 x_credit_points=>X_CREDIT_POINTS,
 x_crs_group_ind=>NVL(X_CRS_GROUP_IND,'N'),
 x_exemption_institution_cd=>X_EXEMPTION_INSTITUTION_CD,
 x_expiry_dt=>X_EXPIRY_DT,
 x_granted_dt=>X_GRANTED_DT,
 x_person_id=>X_PERSON_ID,
 x_revoked_dt=>X_REVOKED_DT,
 x_s_adv_stnd_granting_status=>X_S_ADV_STND_GRANTING_STATUS,
 x_s_adv_stnd_type=>NVL(X_S_ADV_STND_TYPE,'LEVEL'),
 x_unit_level=>X_UNIT_LEVEL,
 X_AV_STND_UNIT_LVL_ID=>X_AV_STND_UNIT_LVL_ID,
 X_CAL_TYPE =>X_CAL_TYPE,
 X_CI_SEQUENCE_NUMBER =>X_CI_SEQUENCE_NUMBER,
 X_INSTITUTION_CD =>X_INSTITUTION_CD,
 X_UNIT_DETAILS_ID =>X_UNIT_DETAILS_ID,
 X_TST_RSLT_DTLS_ID =>X_TST_RSLT_DTLS_ID,
 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_org_id=>igs_ge_gen_003.get_org_id,
 x_adv_stnd_trans=>X_ADV_STND_TRANS,
 X_DEG_AUD_DETAIL_ID  => X_DEG_AUD_DETAIL_ID,
 X_QUAL_DETS_ID => X_QUAL_DETS_ID,
 X_UNIT_LEVEL_MARK => X_UNIT_LEVEL_MARK
 );
Line: 1282

  insert into IGS_AV_STND_UNIT_LVL_ALL (
    PERSON_ID,
    AS_COURSE_CD,
    AS_VERSION_NUMBER,
    S_ADV_STND_TYPE,
    UNIT_LEVEL,
    CRS_GROUP_IND,
    EXEMPTION_INSTITUTION_CD,
    S_ADV_STND_GRANTING_STATUS,
    CREDIT_POINTS,
    APPROVED_DT,
    AUTHORISING_PERSON_ID,
    GRANTED_DT,
    EXPIRY_DT,
    CANCELLED_DT,
    REVOKED_DT,
    COMMENTS,
    AV_STND_UNIT_LVL_ID,
    CAL_TYPE,
    CI_SEQUENCE_NUMBER,
    INSTITUTION_CD,
    UNIT_DETAILS_ID,
    TST_RSLT_DTLS_ID,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    REQUEST_ID,
    PROGRAM_ID,
    PROGRAM_APPLICATION_ID,
    PROGRAM_UPDATE_DATE,
    ORG_ID,
    DEG_AUD_DETAIL_ID,
    QUAL_DETS_ID,
    UNIT_LEVEL_MARK
  ) values (
    NEW_REFERENCES.PERSON_ID,
    NEW_REFERENCES.AS_COURSE_CD,
    NEW_REFERENCES.AS_VERSION_NUMBER,
    NEW_REFERENCES.S_ADV_STND_TYPE,
    NEW_REFERENCES.UNIT_LEVEL,
    NEW_REFERENCES.CRS_GROUP_IND,
    NEW_REFERENCES.EXEMPTION_INSTITUTION_CD,
    NEW_REFERENCES.S_ADV_STND_GRANTING_STATUS,
    NEW_REFERENCES.CREDIT_POINTS,
    NEW_REFERENCES.APPROVED_DT,
    NEW_REFERENCES.AUTHORISING_PERSON_ID,
    NEW_REFERENCES.GRANTED_DT,
    NEW_REFERENCES.EXPIRY_DT,
    NEW_REFERENCES.CANCELLED_DT,
    NEW_REFERENCES.REVOKED_DT,
    NEW_REFERENCES.COMMENTS,
    NEW_REFERENCES.AV_STND_UNIT_LVL_ID,
    NEW_REFERENCES.CAL_TYPE,
    NEW_REFERENCES.CI_SEQUENCE_NUMBER,
    NEW_REFERENCES.INSTITUTION_CD,
    NEW_REFERENCES.UNIT_DETAILS_ID,
    NEW_REFERENCES.TST_RSLT_DTLS_ID,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN,
    X_REQUEST_ID,
    X_PROGRAM_ID,
    X_PROGRAM_APPLICATION_ID,
    X_PROGRAM_UPDATE_DATE,
    NEW_REFERENCES.ORG_ID,
    NEW_REFERENCES.DEG_AUD_DETAIL_ID,
    NEW_REFERENCES.QUAL_DETS_ID,
    NEW_REFERENCES.UNIT_LEVEL_MARK
  );
Line: 1368

  p_action => 'INSERT',
  x_rowid => X_ROWID
  );
Line: 1384

end INSERT_ROW;
Line: 1414

  cursor c1 is select
      S_ADV_STND_GRANTING_STATUS,
      CREDIT_POINTS,
      APPROVED_DT,
      AUTHORISING_PERSON_ID,
      GRANTED_DT,
      EXPIRY_DT,
      CANCELLED_DT,
      REVOKED_DT,
      COMMENTS,
      AV_STND_UNIT_LVL_ID,
      CAL_TYPE,
      CI_SEQUENCE_NUMBER,
      INSTITUTION_CD,
      UNIT_DETAILS_ID,
      TST_RSLT_DTLS_ID,
      DEG_AUD_DETAIL_ID,
      QUAL_DETS_ID,
      UNIT_LEVEL_MARK
    from IGS_AV_STND_UNIT_LVL_ALL
    where ROWID = X_ROWID
    for update nowait;
Line: 1441

    fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
Line: 1501

procedure UPDATE_ROW (
  X_ROWID in VARCHAR2,
  X_PERSON_ID in NUMBER,
  X_AS_COURSE_CD in VARCHAR2,
  X_AS_VERSION_NUMBER in NUMBER,
  X_S_ADV_STND_TYPE in VARCHAR2,
  X_UNIT_LEVEL in VARCHAR2,
  X_CRS_GROUP_IND in VARCHAR2,
  X_EXEMPTION_INSTITUTION_CD in VARCHAR2,
  X_S_ADV_STND_GRANTING_STATUS in VARCHAR2,
  X_CREDIT_POINTS in NUMBER,
  X_APPROVED_DT in DATE,
  X_AUTHORISING_PERSON_ID in NUMBER,
  X_GRANTED_DT in DATE,
  X_EXPIRY_DT in DATE,
  X_CANCELLED_DT in DATE,
  X_REVOKED_DT in DATE,
  X_COMMENTS in VARCHAR2,
  X_AV_STND_UNIT_LVL_ID IN NUMBER,
  X_CAL_TYPE            IN VARCHAR2,
  X_CI_SEQUENCE_NUMBER  IN NUMBER,
  X_INSTITUTION_CD      IN VARCHAR2,
  X_UNIT_DETAILS_ID     in NUMBER,
  X_TST_RSLT_DTLS_ID    in NUMBER,
  X_DEG_AUD_DETAIL_ID   IN NUMBER,
  X_MODE    in VARCHAR2,
  X_QUAL_DETS_ID  IN NUMBER,
  X_UNIT_LEVEL_MARK     IN NUMBER
  ) AS

    X_LAST_UPDATE_DATE    DATE;
Line: 1532

    X_LAST_UPDATED_BY   NUMBER;
Line: 1533

    X_LAST_UPDATE_LOGIN   NUMBER;
Line: 1537

    X_PROGRAM_UPDATE_DATE DATE;
Line: 1539

  X_LAST_UPDATE_DATE := SYSDATE;
Line: 1541

    X_LAST_UPDATED_BY := 1;
Line: 1542

    X_LAST_UPDATE_LOGIN := 0;
Line: 1544

   X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 1545

    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;
Line: 1548

    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
Line: 1549

    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;
Line: 1559

 p_action=>'UPDATE',
 x_rowid=>X_ROWID,
 x_approved_dt=>X_APPROVED_DT,
 x_as_course_cd=>X_AS_COURSE_CD,
 x_as_version_number=>X_AS_VERSION_NUMBER,
 x_authorising_person_id=>X_AUTHORISING_PERSON_ID,
 x_cancelled_dt=>X_CANCELLED_DT,
 x_comments=>X_COMMENTS,
 x_credit_points=>X_CREDIT_POINTS,
 x_crs_group_ind=>X_CRS_GROUP_IND,
 x_exemption_institution_cd=>X_EXEMPTION_INSTITUTION_CD,
 x_expiry_dt=>X_EXPIRY_DT,
 x_granted_dt=>X_GRANTED_DT,
 x_person_id=>X_PERSON_ID,
 x_revoked_dt=>X_REVOKED_DT,
 x_s_adv_stnd_granting_status=>X_S_ADV_STND_GRANTING_STATUS,
 x_s_adv_stnd_type=>X_S_ADV_STND_TYPE,
 x_unit_level=>X_UNIT_LEVEL,
 X_AV_STND_UNIT_LVL_ID => X_AV_STND_UNIT_LVL_ID,
 X_CAL_TYPE =>X_CAL_TYPE,
 X_CI_SEQUENCE_NUMBER =>X_CI_SEQUENCE_NUMBER,
 X_INSTITUTION_CD =>X_INSTITUTION_CD,
 X_UNIT_DETAILS_ID =>X_UNIT_DETAILS_ID,
 X_TST_RSLT_DTLS_ID =>X_TST_RSLT_DTLS_ID,
 X_DEG_AUD_DETAIL_ID  =>   X_DEG_AUD_DETAIL_ID ,
 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_QUAL_DETS_ID => X_QUAL_DETS_ID,
 X_UNIT_LEVEL_MARK => X_UNIT_LEVEL_MARK
 );
Line: 1600

       X_PROGRAM_UPDATE_DATE := OLD_REFERENCES.PROGRAM_UPDATE_DATE ;
Line: 1602

       X_PROGRAM_UPDATE_DATE := SYSDATE ;
Line: 1609

  UPDATE IGS_AV_STND_UNIT_LVL_ALL SET
    S_ADV_STND_GRANTING_STATUS = NEW_REFERENCES.S_ADV_STND_GRANTING_STATUS,
    CREDIT_POINTS = NEW_REFERENCES.CREDIT_POINTS,
    APPROVED_DT = NEW_REFERENCES.APPROVED_DT,
    AUTHORISING_PERSON_ID = NEW_REFERENCES.AUTHORISING_PERSON_ID,
    GRANTED_DT = NEW_REFERENCES.GRANTED_DT,
    EXPIRY_DT = NEW_REFERENCES.EXPIRY_DT,
    CANCELLED_DT = NEW_REFERENCES.CANCELLED_DT,
    REVOKED_DT = NEW_REFERENCES.REVOKED_DT,
    COMMENTS = NEW_REFERENCES.COMMENTS,
    CAL_TYPE = NEW_REFERENCES.CAL_TYPE,
    CI_SEQUENCE_NUMBER = NEW_REFERENCES.CI_SEQUENCE_NUMBER,
    INSTITUTION_CD = NEW_REFERENCES.INSTITUTION_CD,
    UNIT_DETAILS_ID = NEW_REFERENCES.UNIT_DETAILS_ID,
    TST_RSLT_DTLS_ID = NEW_REFERENCES.TST_RSLT_DTLS_ID,
    DEG_AUD_DETAIL_ID   =  NEW_REFERENCES.DEG_AUD_DETAIL_ID ,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
    REQUEST_ID = X_REQUEST_ID,
    PROGRAM_ID = X_PROGRAM_ID,
    PROGRAM_APPLICATION_ID = X_PROGRAM_APPLICATION_ID,
    PROGRAM_UPDATE_DATE = X_PROGRAM_UPDATE_DATE,
    QUAL_DETS_ID = X_QUAL_DETS_ID,
    UNIT_LEVEL_MARK = X_UNIT_LEVEL_MARK
  where rowid = X_ROWID ;
Line: 1646

  p_action => 'UPDATE',
  x_rowid => X_ROWID
  );
Line: 1661

end UPDATE_ROW;
Line: 1694

  cursor c1 is select rowid from IGS_AV_STND_UNIT_LVL_ALL
     where AV_STND_UNIT_LVL_ID =X_AV_STND_UNIT_LVL_ID;
Line: 1701

    INSERT_ROW (
     X_ROWID,
     X_PERSON_ID,
     X_AS_COURSE_CD,
     X_AS_VERSION_NUMBER,
     X_S_ADV_STND_TYPE,
     X_UNIT_LEVEL,
     X_CRS_GROUP_IND,
     X_EXEMPTION_INSTITUTION_CD,
     X_S_ADV_STND_GRANTING_STATUS,
     X_CREDIT_POINTS,
     X_APPROVED_DT,
     X_AUTHORISING_PERSON_ID,
     X_GRANTED_DT,
     X_EXPIRY_DT,
     X_CANCELLED_DT,
     X_REVOKED_DT,
     X_COMMENTS,
     X_AV_STND_UNIT_LVL_ID,
     X_CAL_TYPE,
     X_CI_SEQUENCE_NUMBER,
     X_INSTITUTION_CD,
     X_UNIT_DETAILS_ID,
     X_TST_RSLT_DTLS_ID,
     X_MODE,
     X_ORG_ID,
     X_DEG_AUD_DETAIL_ID,
     X_QUAL_DETS_ID,
     X_UNIT_LEVEL_MARK
     );
Line: 1735

  UPDATE_ROW (
   X_ROWID,
   X_PERSON_ID,
   X_AS_COURSE_CD,
   X_AS_VERSION_NUMBER,
   X_S_ADV_STND_TYPE,
   X_UNIT_LEVEL,
   X_CRS_GROUP_IND,
   X_EXEMPTION_INSTITUTION_CD,
   X_S_ADV_STND_GRANTING_STATUS,
   X_CREDIT_POINTS,
   X_APPROVED_DT,
   X_AUTHORISING_PERSON_ID,
   X_GRANTED_DT,
   X_EXPIRY_DT,
   X_CANCELLED_DT,
   X_REVOKED_DT,
   X_COMMENTS,
   X_AV_STND_UNIT_LVL_ID,
   X_CAL_TYPE,
   X_CI_SEQUENCE_NUMBER,
   X_INSTITUTION_CD,
   X_UNIT_DETAILS_ID,
   X_TST_RSLT_DTLS_ID,
   X_MODE,
   X_DEG_AUD_DETAIL_ID,
   X_QUAL_DETS_ID,
   X_UNIT_LEVEL_MARK
   );
Line: 1768

procedure DELETE_ROW (
  X_ROWID in VARCHAR2,
  x_mode IN VARCHAR2
) AS
begin
 Before_DML(
  p_action => 'DELETE',
  x_rowid => X_ROWID
  );
Line: 1780

  delete from IGS_AV_STND_UNIT_LVL_ALL
  where ROWID = X_ROWID ;
Line: 1793

  p_action => 'DELETE',
  x_rowid => X_ROWID
  );
Line: 1796

end DELETE_ROW;