DBA Data[Home] [Help]

APPS.IGS_AV_STND_UNIT_PKG SQL Statements

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

Line: 40

    x_last_update_date IN DATE DEFAULT NULL,
    x_last_updated_by IN NUMBER DEFAULT NULL,
    x_last_update_login IN NUMBER DEFAULT NULL ,
    x_org_id in NUMBER,
    X_DEG_AUD_DETAIL_ID    IN NUMBER DEFAULT NULL
  ) AS
    CURSOR cur_old_ref_values IS
      SELECT   *
      FROM     IGS_AV_STND_UNIT_ALL
      WHERE    rowid = x_rowid;
Line: 56

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

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

    new_references.last_update_date := x_last_update_date;
Line: 102

    new_references.last_updated_by := x_last_updated_by;
Line: 103

    new_references.last_update_login := x_last_update_login;
Line: 114

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

  IF p_inserting THEN
    IF new_references.s_adv_stnd_type <> 'UNIT' THEN
      Fnd_Message.Set_Name('IGS','IGS_AV_TYPE_MUSTBE_UNIT');
Line: 142

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

    (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: 191

     (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: 207

     (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: 222

     (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: 246

     (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: 269

  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: 329

    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: 363

  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: 373

  IF p_inserting OR p_updating THEN
    v_Person_id     :=  new_references.person_id;
Line: 398

  IF p_inserting AND
      (new_references.s_adv_stnd_recognition_type = 'CREDIT' and
       new_references.s_adv_stnd_granting_status = 'GRANTED') THEN
    v_return_val := igs_ge_gen_003.genp_ins_stdnt_todo(
                      new_references.person_id,
                      'UNIT-RULES',
                      NULL);
Line: 435

  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,
      new_references.s_adv_stnd_recognition_type,
      new_references.s_adv_stnd_recognition_type,
      new_references.s_adv_stnd_granting_status,
      new_references.s_adv_stnd_granting_status,
      new_references.achievable_credit_points,
      new_references.achievable_credit_points,
      NULL,
      NULL
    );
Line: 478

  END BeforeRowInsertUpdateDelete1;
Line: 489

  PROCEDURE AfterRowInsertUpdateDelete2(
    p_inserting IN BOOLEAN DEFAULT FALSE,
    p_updating IN BOOLEAN DEFAULT FALSE,
    p_deleting IN BOOLEAN DEFAULT FALSE
    ) AS
  v_message_name  varchar2(30);
Line: 497

          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: 520

  END AfterRowInsertUpdateDelete2;
Line: 684

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

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

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

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

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

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

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

      SELECT   rowid
      FROM     IGS_AV_STND_UNIT_ALL
      WHERE    av_stnd_unit_id = x_av_stnd_unit_id
      FOR UPDATE NOWAIT;
Line: 863

      SELECT   rowid
      FROM     igs_av_stnd_unit_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
       unit_cd           = x_unit_cd           AND
       as_course_cd      = x_as_course_cd      AND
       as_version_number = x_as_version_number AND
       version_number    = x_version_number    AND
       s_adv_stnd_type   = x_s_adv_stnd_type   AND
       ((l_rowid is null) or (rowid <> l_rowid));
Line: 895

      SELECT   rowid
      FROM     IGS_AV_STND_UNIT_ALL
      WHERE    s_adv_stnd_recognition_type = x_s_adv_stnd_recognition_type ;
Line: 919

      SELECT   rowid
      FROM     IGS_AV_STND_UNIT_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: 944

      SELECT   rowid
      FROM     IGS_AV_STND_UNIT_ALL
      WHERE    unit_details_id = x_unit_details_id;
Line: 965

      SELECT   rowid
      FROM     IGS_AV_STND_UNIT_ALL
      WHERE    tst_rslt_dtls_id = x_tst_rslt_dtls_id;
Line: 987

      SELECT   rowid
      FROM     IGS_AV_STND_UNIT_ALL
      WHERE    authorising_person_id = x_person_id ;
Line: 1008

      SELECT   rowid
      FROM     IGS_AV_STND_UNIT_ALL
      WHERE    s_adv_stnd_granting_status = x_s_adv_stnd_granting_status ;
Line: 1030

      SELECT   rowid
      FROM     IGS_AV_STND_UNIT_ALL
      WHERE    unit_cd = x_unit_cd
      AND      version_number = x_version_number ;
Line: 1054

      SELECT   rowid
      FROM     IGS_AV_STND_UNIT_ALL
      WHERE    cal_type = x_cal_type
      AND      ci_sequence_number = x_ci_sequence_number ;
Line: 1078

      SELECT   rowid
      FROM     IGS_AV_STND_UNIT_ALL
      WHERE    grading_schema_cd = x_grading_schema_cd
      AND      grd_sch_version_number = x_grd_sch_version_number
      AND      grade = x_grade;
Line: 1131

    x_last_update_date IN DATE DEFAULT NULL,
    x_last_updated_by IN NUMBER DEFAULT NULL,
    x_last_update_login IN NUMBER DEFAULT NULL,
    x_org_id IN NUMBER DEFAULT NULL,
    x_adv_stnd_trans IN VARCHAR2 DEFAULT 'N',  -- This parameter has been added for Career Impact DLD.
    X_DEG_AUD_DETAIL_ID    IN NUMBER DEFAULT NULL
  ) 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_cd,
      x_version_number,
      x_s_adv_stnd_granting_status,
      x_credit_percentage,
      x_s_adv_stnd_recognition_type,
      x_approved_dt,
      x_authorising_person_id,
      x_crs_group_ind,
      x_exemption_institution_cd,
      x_granted_dt,
      x_expiry_dt,
      x_cancelled_dt,
      x_revoked_dt,
      x_comments,
      X_AV_STND_UNIT_ID,
      X_CAL_TYPE,
      X_CI_SEQUENCE_NUMBER,
      X_INSTITUTION_CD,
      X_UNIT_DETAILS_ID,
      X_TST_RSLT_DTLS_ID,
      X_GRADING_SCHEMA_CD,
      X_GRD_SCH_VERSION_NUMBER,
      X_GRADE,
      X_ACHIEVABLE_CREDIT_POINTS,
      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
    );
Line: 1178

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

    ELSIF (p_action = 'UPDATE') THEN
      -- Call all the procedures related to Before Update.
      BeforeRowInsertUpdateDelete1 ( p_updating => TRUE );
Line: 1200

    ELSIF (p_action = 'DELETE') THEN
      -- Call all the procedures related to Before Delete.
      BeforeRowInsertUpdateDelete1 ( p_deleting => TRUE );
Line: 1204

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

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

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

    IF (p_action = 'INSERT') THEN
      -- Call all the procedures related to After Update.
      AfterRowInsertUpdateDelete2 ( p_inserting => TRUE );
Line: 1232

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

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

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_CD in VARCHAR2,
  X_VERSION_NUMBER in NUMBER,
  X_S_ADV_STND_GRANTING_STATUS in VARCHAR2,
  X_CREDIT_PERCENTAGE in NUMBER DEFAULT NULL,
  X_S_ADV_STND_RECOGNITION_TYPE in VARCHAR2,
  X_APPROVED_DT in DATE,
  X_AUTHORISING_PERSON_ID in NUMBER,
  X_CRS_GROUP_IND in VARCHAR2,
  X_EXEMPTION_INSTITUTION_CD in VARCHAR2,
  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_ID  IN OUT NOCOPY  NUMBER ,
  X_CAL_TYPE            IN VARCHAR2 DEFAULT NULL,
  X_CI_SEQUENCE_NUMBER  IN NUMBER DEFAULT NULL,
  X_INSTITUTION_CD      IN VARCHAR2 DEFAULT NULL,
  X_UNIT_DETAILS_ID     in NUMBER DEFAULT NULL,
  X_TST_RSLT_DTLS_ID    in NUMBER DEFAULT NULL,
  X_GRADING_SCHEMA_CD   In VARCHAR2 DEFAULT NULL,
  X_GRD_SCH_VERSION_NUMBER IN NUMBER DEFAULT NULL,
  X_GRADE               IN VARCHAR2 DEFAULT NULL,
  X_ACHIEVABLE_CREDIT_POINTS IN  NUMBER DEFAULT NULL,
  X_MODE in VARCHAR2 default 'R',
  X_ORG_ID in NUMBER,
  X_ADV_STND_TRANS IN VARCHAR2 DEFAULT 'N',  -- This parameter has been added for Career Impact DLD.
  X_DEG_AUD_DETAIL_ID    IN NUMBER DEFAULT NULL
  ) AS
    cursor C is select ROWID from IGS_AV_STND_UNIT_ALL
      where PERSON_ID = new_references.PERSON_ID
      and AS_COURSE_CD = new_references.AS_COURSE_CD
      and AS_VERSION_NUMBER =new_references.AS_VERSION_NUMBER
      and S_ADV_STND_TYPE = new_references.S_ADV_STND_TYPE
      and UNIT_CD = new_references.UNIT_CD
      and VERSION_NUMBER = new_references.VERSION_NUMBER;
Line: 1284

    X_LAST_UPDATE_DATE DATE;
Line: 1285

    X_LAST_UPDATED_BY NUMBER;
Line: 1286

    X_LAST_UPDATE_LOGIN NUMBER;
Line: 1290

    X_PROGRAM_UPDATE_DATE DATE ;
Line: 1292

   cursor c1 is select ROWID from IGS_AV_STND_UNIT_ALL
                      WHERE AV_STND_UNIT_ID = X_AV_STND_UNIT_ID;
Line: 1295

  X_LAST_UPDATE_DATE := SYSDATE;
Line: 1297

    X_LAST_UPDATED_BY := 1;
Line: 1298

    X_LAST_UPDATE_LOGIN := 0;
Line: 1300

    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 1301

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

    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
Line: 1305

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

       X_PROGRAM_UPDATE_DATE := NULL ;
Line: 1317

       X_PROGRAM_UPDATE_DATE := SYSDATE ;
Line: 1325

  SELECT IGS_AV_STND_UNIT_S.NEXTVAL INTO X_AV_STND_UNIT_ID FROM DUAL;
Line: 1328

 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_percentage=> NULL,
 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_recognition_type=>X_S_ADV_STND_RECOGNITION_TYPE,
 x_s_adv_stnd_type=>NVL(X_S_ADV_STND_TYPE,'UNIT'),
 x_unit_cd=>X_UNIT_CD,
 x_version_number=>X_VERSION_NUMBER,
 X_AV_STND_UNIT_ID => X_AV_STND_UNIT_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_GRADING_SCHEMA_CD =>X_GRADING_SCHEMA_CD,
 X_GRD_SCH_VERSION_NUMBER =>X_GRD_SCH_VERSION_NUMBER,
 X_GRADE =>X_GRADE,
 X_ACHIEVABLE_CREDIT_POINTS =>X_ACHIEVABLE_CREDIT_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_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
 );
Line: 1371

  INSERT INTO IGS_AV_STND_UNIT_ALL (
    PERSON_ID,
    AS_COURSE_CD,
    AS_VERSION_NUMBER,
    S_ADV_STND_TYPE,
    UNIT_CD,
    VERSION_NUMBER,
    S_ADV_STND_GRANTING_STATUS,
    CREDIT_PERCENTAGE,
    S_ADV_STND_RECOGNITION_TYPE,
    APPROVED_DT,
    AUTHORISING_PERSON_ID,
    CRS_GROUP_IND,
    EXEMPTION_INSTITUTION_CD,
    GRANTED_DT,
    EXPIRY_DT,
    CANCELLED_DT,
    REVOKED_DT,
    COMMENTS,
    AV_STND_UNIT_ID,
    CAL_TYPE,
    CI_SEQUENCE_NUMBER,
    INSTITUTION_CD,
    UNIT_DETAILS_ID,
    TST_RSLT_DTLS_ID,
    GRADING_SCHEMA_CD,
    GRD_SCH_VERSION_NUMBER,
    GRADE,
    ACHIEVABLE_CREDIT_POINTS,
    ORG_ID,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    REQUEST_ID,
    PROGRAM_ID,
    PROGRAM_APPLICATION_ID,
    PROGRAM_UPDATE_DATE,
    DEG_AUD_DETAIL_ID
  ) values (
    NEW_REFERENCES.PERSON_ID,
    NEW_REFERENCES.AS_COURSE_CD,
    NEW_REFERENCES.AS_VERSION_NUMBER,
    NEW_REFERENCES.S_ADV_STND_TYPE,
    NEW_REFERENCES.UNIT_CD,
    NEW_REFERENCES.VERSION_NUMBER,
    NEW_REFERENCES.S_ADV_STND_GRANTING_STATUS,
    NULL,
    NEW_REFERENCES.S_ADV_STND_RECOGNITION_TYPE,
    NEW_REFERENCES.APPROVED_DT,
    NEW_REFERENCES.AUTHORISING_PERSON_ID,
    NEW_REFERENCES.CRS_GROUP_IND,
    NEW_REFERENCES.EXEMPTION_INSTITUTION_CD,
    NEW_REFERENCES.GRANTED_DT,
    NEW_REFERENCES.EXPIRY_DT,
    NEW_REFERENCES.CANCELLED_DT,
    NEW_REFERENCES.REVOKED_DT,
    NEW_REFERENCES.COMMENTS,
    NEW_REFERENCES.AV_STND_UNIT_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,
    NEW_REFERENCES.GRADING_SCHEMA_CD,
    NEW_REFERENCES.GRD_SCH_VERSION_NUMBER,
    NEW_REFERENCES.GRADE,
    NEW_REFERENCES.ACHIEVABLE_CREDIT_POINTS,
    NEW_REFERENCES.ORG_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.DEG_AUD_DETAIL_ID
  );
Line: 1465

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

end INSERT_ROW;
Line: 1516

  CURSOR c1 IS SELECT
      S_ADV_STND_GRANTING_STATUS,
      S_ADV_STND_RECOGNITION_TYPE,
      APPROVED_DT,
      AUTHORISING_PERSON_ID,
      CRS_GROUP_IND,
      EXEMPTION_INSTITUTION_CD,
      GRANTED_DT,
      EXPIRY_DT,
      CANCELLED_DT,
      REVOKED_DT,
      COMMENTS,
      AV_STND_UNIT_ID,
      CAL_TYPE,
      CI_SEQUENCE_NUMBER,
      INSTITUTION_CD,
      UNIT_DETAILS_ID,
      TST_RSLT_DTLS_ID,
      GRADING_SCHEMA_CD,
      GRD_SCH_VERSION_NUMBER,
      GRADE,
      ACHIEVABLE_CREDIT_POINTS,
      DEG_AUD_DETAIL_ID
    from IGS_AV_STND_UNIT_ALL
    where ROWID = X_ROWID
    for update nowait;
Line: 1547

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

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_CD in VARCHAR2,
  X_VERSION_NUMBER in NUMBER,
  X_S_ADV_STND_GRANTING_STATUS in VARCHAR2,
  X_CREDIT_PERCENTAGE in NUMBER DEFAULT NULL,
  X_S_ADV_STND_RECOGNITION_TYPE in VARCHAR2,
  X_APPROVED_DT in DATE,
  X_AUTHORISING_PERSON_ID in NUMBER,
  X_CRS_GROUP_IND in VARCHAR2,
  X_EXEMPTION_INSTITUTION_CD in VARCHAR2,
  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_ID     IN  NUMBER ,
  X_CAL_TYPE            IN VARCHAR2 DEFAULT NULL,
  X_CI_SEQUENCE_NUMBER  IN NUMBER DEFAULT NULL,
  X_INSTITUTION_CD      IN VARCHAR2 DEFAULT NULL,
  X_UNIT_DETAILS_ID     in NUMBER DEFAULT NULL,
  X_TST_RSLT_DTLS_ID    in NUMBER DEFAULT NULL,
  X_GRADING_SCHEMA_CD   In VARCHAR2 DEFAULT NULL,
  X_GRD_SCH_VERSION_NUMBER IN NUMBER DEFAULT NULL,
  X_GRADE               IN VARCHAR2 DEFAULT NULL,
  X_ACHIEVABLE_CREDIT_POINTS IN  NUMBER DEFAULT NULL,
  X_DEG_AUD_DETAIL_ID IN NUMBER DEFAULT NULL,
  X_MODE in VARCHAR2 default 'R'
  ) AS
    X_LAST_UPDATE_DATE DATE;
Line: 1621

    X_LAST_UPDATED_BY NUMBER;
Line: 1622

    X_LAST_UPDATE_LOGIN NUMBER;
Line: 1626

    X_PROGRAM_UPDATE_DATE     DATE ;
Line: 1628

  X_LAST_UPDATE_DATE := SYSDATE;
Line: 1630

    X_LAST_UPDATED_BY := 1;
Line: 1631

    X_LAST_UPDATE_LOGIN := 0;
Line: 1633

    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 1634

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

    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
Line: 1638

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

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_percentage=>NULL,
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_recognition_type=>X_S_ADV_STND_RECOGNITION_TYPE,
x_s_adv_stnd_type=>X_S_ADV_STND_TYPE,
x_unit_cd=>X_UNIT_CD,
x_version_number=>X_VERSION_NUMBER,
X_AV_STND_UNIT_ID=>X_AV_STND_UNIT_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_GRADING_SCHEMA_CD =>X_GRADING_SCHEMA_CD,
X_GRD_SCH_VERSION_NUMBER =>X_GRD_SCH_VERSION_NUMBER,
X_GRADE =>X_GRADE,
X_ACHIEVABLE_CREDIT_POINTS =>X_ACHIEVABLE_CREDIT_POINTS,
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
);
Line: 1692

         X_PROGRAM_UPDATE_DATE := OLD_REFERENCES.PROGRAM_UPDATE_DATE ;
Line: 1694

         X_PROGRAM_UPDATE_DATE := SYSDATE ;
Line: 1701

  UPDATE IGS_AV_STND_UNIT_ALL SET
    S_ADV_STND_GRANTING_STATUS = X_S_ADV_STND_GRANTING_STATUS,
    CREDIT_PERCENTAGE = NULL,
    S_ADV_STND_RECOGNITION_TYPE = X_S_ADV_STND_RECOGNITION_TYPE,
    APPROVED_DT = X_APPROVED_DT,
    AUTHORISING_PERSON_ID = X_AUTHORISING_PERSON_ID,
    CRS_GROUP_IND = X_CRS_GROUP_IND,
    EXEMPTION_INSTITUTION_CD = X_EXEMPTION_INSTITUTION_CD,
    GRANTED_DT = X_GRANTED_DT,
    EXPIRY_DT = X_EXPIRY_DT,
    CANCELLED_DT = X_CANCELLED_DT,
    REVOKED_DT = X_REVOKED_DT,
    COMMENTS = X_COMMENTS,
    CAL_TYPE = X_CAL_TYPE,
    CI_SEQUENCE_NUMBER = X_CI_SEQUENCE_NUMBER,
    INSTITUTION_CD = X_INSTITUTION_CD,
    UNIT_DETAILS_ID = X_UNIT_DETAILS_ID,
    TST_RSLT_DTLS_ID = X_TST_RSLT_DTLS_ID,
    GRADING_SCHEMA_CD = X_GRADING_SCHEMA_CD,
    GRD_SCH_VERSION_NUMBER = X_GRD_SCH_VERSION_NUMBER,
    GRADE = X_GRADE,
    ACHIEVABLE_CREDIT_POINTS = X_ACHIEVABLE_CREDIT_POINTS,
    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,
    DEG_AUD_DETAIL_ID = X_DEG_AUD_DETAIL_ID
  where ROWID = X_ROWID  ;
Line: 1743

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

end UPDATE_ROW;
Line: 1795

  cursor c1 is select rowid from IGS_AV_STND_UNIT_ALL
     where AV_STND_UNIT_ID =X_AV_STND_UNIT_ID
  ;
Line: 1803

    INSERT_ROW (
     X_ROWID,
     X_PERSON_ID,
     X_AS_COURSE_CD,
     X_AS_VERSION_NUMBER,
     X_S_ADV_STND_TYPE,
     X_UNIT_CD,
     X_VERSION_NUMBER,
     X_S_ADV_STND_GRANTING_STATUS,
     NULL,
     X_S_ADV_STND_RECOGNITION_TYPE,
     X_APPROVED_DT,
     X_AUTHORISING_PERSON_ID,
     X_CRS_GROUP_IND,
     X_EXEMPTION_INSTITUTION_CD,
     X_GRANTED_DT,
     X_EXPIRY_DT,
     X_CANCELLED_DT,
     X_REVOKED_DT,
     X_COMMENTS,
     X_AV_STND_UNIT_ID,
     X_CAL_TYPE,
     X_CI_SEQUENCE_NUMBER,
     X_INSTITUTION_CD,
     X_UNIT_DETAILS_ID,
     X_TST_RSLT_DTLS_ID,
     X_GRADING_SCHEMA_CD,
     X_GRD_SCH_VERSION_NUMBER,
     X_GRADE,
     X_ACHIEVABLE_CREDIT_POINTS,
     X_MODE,
     X_ORG_ID,
     X_DEG_AUD_DETAIL_ID);
Line: 1839

  UPDATE_ROW (
   X_ROWID ,
   X_PERSON_ID,
   X_AS_COURSE_CD,
   X_AS_VERSION_NUMBER,
   X_S_ADV_STND_TYPE,
   X_UNIT_CD,
   X_VERSION_NUMBER,
   X_S_ADV_STND_GRANTING_STATUS,
   NULL,
   X_S_ADV_STND_RECOGNITION_TYPE,
   X_APPROVED_DT,
   X_AUTHORISING_PERSON_ID,
   X_CRS_GROUP_IND,
   X_EXEMPTION_INSTITUTION_CD,
   X_GRANTED_DT,
   X_EXPIRY_DT,
   X_CANCELLED_DT,
   X_REVOKED_DT,
   X_COMMENTS,
   X_AV_STND_UNIT_ID,
   X_CAL_TYPE,
   X_CI_SEQUENCE_NUMBER,
   X_INSTITUTION_CD,
   X_UNIT_DETAILS_ID,
   X_TST_RSLT_DTLS_ID,
   X_GRADING_SCHEMA_CD,
   X_GRD_SCH_VERSION_NUMBER,
   X_GRADE,
   X_ACHIEVABLE_CREDIT_POINTS,
   X_MODE,
   X_DEG_AUD_DETAIL_ID);
Line: 1873

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

  delete from IGS_AV_STND_UNIT_ALL
  where ROWID = X_ROWID ;
Line: 1898

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

end DELETE_ROW;