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_EN_SU_ATTEMPT_H_PKG SQL Statements

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

Line: 42


    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_grading_schema_code IN VARCHAR2 DEFAULT NULL,
    x_enr_method_type IN VARCHAR2 DEFAULT NULL,
    x_administrative_priority   IN NUMBER DEFAULT NULL,
    x_waitlist_dt               IN DATE DEFAULT NULL,
    x_request_id                IN NUMBER DEFAULT NULL,
    x_program_application_id    IN NUMBER DEFAULT NULL,
    x_program_id                IN NUMBER DEFAULT NULL,
    x_program_update_date       IN DATE DEFAULT NULL,
    x_cart                      IN VARCHAR2 DEFAULT NULL,
    x_org_unit_cd               IN VARCHAR2 DEFAULT NULL,
    x_rsv_seat_ext_id           IN NUMBER DEFAULT NULL,
    x_gs_version_number         IN NUMBER DEFAULT NULL,
    x_failed_unit_rule          IN VARCHAR2 DEFAULT NULL,
    x_deg_aud_detail_id         IN NUMBER DEFAULT NULL,
    x_uoo_id                IN NUMBER DEFAULT NULL,
    x_core_indicator_code            IN VARCHAR2 DEFAULT NULL
  ) AS
    CURSOR cur_old_ref_values IS
      SELECT   *
      FROM     IGS_EN_SU_ATTEMPT_H_ALL
      WHERE    rowid = x_rowid;

Line: 73


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

Line: 115


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

Line: 122


    new_references.last_update_date := x_last_update_date;

Line: 123


    new_references.last_updated_by := x_last_updated_by;

Line: 124


    new_references.last_update_login := x_last_update_login;

Line: 133


    new_references.program_update_date      :=  x_program_update_date;

Line: 155


            Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');

Line: 172


            Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');

Line: 191


      SELECT   rowid
      FROM     IGS_EN_SU_ATTEMPT_H_ALL
      WHERE    person_id = x_person_id
      AND      course_cd = x_course_cd
      AND      hist_start_dt = x_hist_start_dt
      AND      uoo_id = x_uoo_id
      FOR UPDATE NOWAIT;

Line: 215


      SELECT   rowid
      FROM     IGS_EN_SU_ATTEMPT_H_ALL
      WHERE    person_id = x_person_id
      AND      course_cd = x_course_cd ;

Line: 241


      SELECT   rowid
      FROM     IGS_EN_SU_ATTEMPT_H_ALL
      WHERE    person_id = x_person_id
      AND      course_cd = x_course_cd
      AND      uoo_id = x_uoo_id;

Line: 299


    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_grading_schema_code IN VARCHAR2 DEFAULT NULL,
    x_enr_method_type IN VARCHAR2 DEFAULT NULL,
    x_administrative_priority   IN NUMBER DEFAULT NULL,
    x_waitlist_dt               IN DATE DEFAULT NULL,
    x_request_id                IN NUMBER DEFAULT NULL,
    x_program_application_id    IN NUMBER DEFAULT NULL,
    x_program_id                IN NUMBER DEFAULT NULL,
    x_program_update_date       IN DATE DEFAULT NULL,
    x_cart                      IN VARCHAR2 DEFAULT NULL,
    x_org_unit_cd               IN VARCHAR2 DEFAULT NULL,
    x_rsv_seat_ext_id           IN NUMBER DEFAULT NULL,
    x_gs_version_number         IN NUMBER DEFAULT NULL,
    x_failed_unit_rule          IN VARCHAR2 DEFAULT NULL,
    x_deg_aud_detail_id         IN NUMBER DEFAULT NULL,
    x_uoo_id                IN NUMBER DEFAULT NULL,
    x_core_indicator_code IN VARCHAR2 DEFAULT NULL
  ) AS

  -------------------------------------------------------------------------------------------
  --Change History:
  --Who         When            What
  --bdeviset    22-Mar-2005  Whenver history record is created for waitlisted status the history start date
  --                         is set to the history end date of the history record having unit attempt status
  --                         as unconfirmed.Bug# 4253954
  --bdeviset    05-MAY-2006  Modified for bug# 5208930
  -------------------------------------------------------------------------------------------

  CURSOR c_hist_end_dt(cp_person_id IN NUMBER,
                       cp_course_cd IN VARCHAR2,
                       cp_uoo_id IN NUMBER) IS
    SELECT HIST_END_DT
    FROM IGS_EN_SU_ATTEMPT_H_ALL
    WHERE person_id = cp_person_id
    AND course_cd = cp_course_cd
    AND uoo_id = cp_uoo_id
    ORDER BY HIST_END_DT DESC
    FOR UPDATE;

Line: 379


      x_last_update_date,
      x_last_updated_by,
      x_last_update_login,
      x_org_id ,
      x_grading_schema_code,
      x_enr_method_type,
      x_administrative_priority,
      x_waitlist_dt,
      x_request_id,
      x_program_application_id  ,
      x_program_id,
      x_program_update_date,
      x_cart,
      x_org_unit_cd,
      x_rsv_seat_ext_id ,
      x_gs_version_number,
      x_failed_unit_rule,
      x_deg_aud_detail_id,
      x_uoo_id,
      x_core_indicator_code
    );

Line: 400


    IF (p_action = 'INSERT') THEN


       OPEN c_hist_end_dt(NEW_REFERENCES.person_id,
                           NEW_REFERENCES.course_cd ,
                           NEW_REFERENCES.uoo_id);

Line: 431


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


     Check_Constraints;

Line: 438


        ELSIF (p_action = 'VALIDATE_INSERT') THEN
             IF  Get_PK_For_Validation (
                 NEW_REFERENCES.person_id,
    NEW_REFERENCES.course_cd,
    NEW_REFERENCES.hist_start_dt ,
    NEW_REFERENCES.uoo_id
   ) THEN
         Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');

Line: 451


        ELSIF (p_action = 'VALIDATE_UPDATE') THEN

              Check_Constraints;

Line: 459


procedure INSERT_ROW (
  X_ROWID in out NOCOPY VARCHAR2,
  X_PERSON_ID in NUMBER,
  X_COURSE_CD in VARCHAR2,
  X_UNIT_CD in VARCHAR2,
  X_CAL_TYPE in VARCHAR2,
  X_CI_SEQUENCE_NUMBER in NUMBER,
  X_HIST_START_DT in DATE,
  X_ELO_DESCRIPTION in VARCHAR2,
  X_SUP_UNIT_CD in VARCHAR2,
  X_SUP_VERSION_NUMBER in NUMBER,
  X_ALTERNATIVE_TITLE in VARCHAR2,
  X_OVERRIDE_ENROLLED_CP in NUMBER,
  X_OVERRIDE_EFTSU in NUMBER,
  X_OVERRIDE_ACHIEVABLE_CP in NUMBER,
  X_OVERRIDE_OUTCOME_DUE_DT in DATE,
  X_OVERRIDE_CREDIT_REASON in VARCHAR2,
  X_VERSION_NUMBER in NUMBER,
  X_HIST_END_DT in DATE,
  X_HIST_WHO in NUMBER,
  X_LOCATION_CD in VARCHAR2,
  X_UNIT_CLASS in VARCHAR2,
  X_ENROLLED_DT in DATE,
  X_UNIT_ATTEMPT_STATUS in VARCHAR2,
  X_ADMINISTRATIVE_UNIT_STATUS in VARCHAR2,
  X_AUS_DESCRIPTION in VARCHAR2,
  X_DISCONTINUED_DT in DATE,
  X_RULE_WAIVED_DT in DATE,
  X_RULE_WAIVED_PERSON_ID in NUMBER,
  X_NO_ASSESSMENT_IND in VARCHAR2,
  X_EXAM_LOCATION_CD in VARCHAR2,
  X_DCNT_REASON_CD in VARCHAR2,
  X_MODE in VARCHAR2 default 'R',
  X_ORG_ID IN NUMBER,
  X_GRADING_SCHEMA_CODE IN VARCHAR2 DEFAULT NULL,
  X_ENR_METHOD_TYPE IN VARCHAR2 DEFAULT NULL,
  X_ADMINISTRATIVE_PRIORITY     IN NUMBER DEFAULT NULL,
  X_WAITLIST_DT                 IN DATE DEFAULT NULL,
  X_REQUEST_ID                  IN NUMBER DEFAULT NULL,
  X_PROGRAM_APPLICATION_ID      IN NUMBER DEFAULT NULL,
  X_PROGRAM_ID                  IN NUMBER DEFAULT NULL,
  X_PROGRAM_UPDATE_DATE         IN DATE DEFAULT NULL,
  X_CART                        IN VARCHAR2 DEFAULT NULL,
  X_ORG_UNIT_CD                 IN VARCHAR2 DEFAULT NULL,
  X_RSV_SEAT_EXT_ID             IN NUMBER DEFAULT NULL,
  X_GS_VERSION_NUMBER           IN NUMBER DEFAULT NULL,
  X_FAILED_UNIT_RULE            IN VARCHAR2 DEFAULT NULL,
  X_DEG_AUD_DETAIL_ID           IN NUMBER DEFAULT NULL,
  X_UOO_ID                  IN NUMBER,
  X_CORE_INDICATOR_CODE IN VARCHAR2 DEFAULT NULL
  ) AS
    cursor C is select ROWID from IGS_EN_SU_ATTEMPT_H_ALL
      where PERSON_ID = X_PERSON_ID
      and COURSE_CD = X_COURSE_CD
      and HIST_START_DT = new_references.HIST_START_DT
      and UOO_ID = X_UOO_ID;

Line: 515


    X_LAST_UPDATE_DATE DATE;

Line: 516


    X_LAST_UPDATED_BY NUMBER;

Line: 517


    X_LAST_UPDATE_LOGIN NUMBER;

Line: 519


  X_LAST_UPDATE_DATE := SYSDATE;

Line: 521


    X_LAST_UPDATED_BY := 1;

Line: 522


    X_LAST_UPDATE_LOGIN := 0;

Line: 524


    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 525


    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 528


    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 529


    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 538


 p_action=>'INSERT',
x_rowid=>X_ROWID,
x_administrative_unit_status=>X_ADMINISTRATIVE_UNIT_STATUS,
x_alternative_title=>X_ALTERNATIVE_TITLE,
x_aus_description=>X_AUS_DESCRIPTION,
x_cal_type=>X_CAL_TYPE,
x_ci_sequence_number=>X_CI_SEQUENCE_NUMBER,
x_course_cd=>X_COURSE_CD,
x_discontinued_dt=>X_DISCONTINUED_DT,
x_elo_description=>X_ELO_DESCRIPTION,
x_enrolled_dt=>X_ENROLLED_DT,
x_exam_location_cd=>X_EXAM_LOCATION_CD,
x_hist_end_dt=>X_HIST_END_DT,
x_hist_start_dt=>X_HIST_START_DT,
x_hist_who=>X_HIST_WHO,
x_location_cd=>X_LOCATION_CD,
x_no_assessment_ind=>X_NO_ASSESSMENT_IND,
x_override_achievable_cp=>X_OVERRIDE_ACHIEVABLE_CP,
x_override_credit_reason=>X_OVERRIDE_CREDIT_REASON,
x_override_eftsu=>X_OVERRIDE_EFTSU,
x_override_enrolled_cp=>X_OVERRIDE_ENROLLED_CP,
x_override_outcome_due_dt=>X_OVERRIDE_OUTCOME_DUE_DT,
x_person_id=>X_PERSON_ID,
x_rule_waived_dt=>X_RULE_WAIVED_DT,
x_rule_waived_person_id=>X_RULE_WAIVED_PERSON_ID,
x_sup_unit_cd=>X_SUP_UNIT_CD,
x_sup_version_number=>X_SUP_VERSION_NUMBER,
x_unit_attempt_status=>X_UNIT_ATTEMPT_STATUS,
x_unit_cd=>X_UNIT_CD,
x_unit_class=>X_UNIT_CLASS,
x_version_number=>X_VERSION_NUMBER,
x_dcnt_reason_cd => X_DCNT_REASON_CD,
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_grading_schema_code =>X_GRADING_SCHEMA_CODE,
x_enr_method_type =>X_ENR_METHOD_TYPE ,
x_administrative_priority   =>  X_ADMINISTRATIVE_PRIORITY,
x_waitlist_dt               =>  X_WAITLIST_DT,
x_request_id                =>  X_REQUEST_ID,
x_program_application_id    =>  X_PROGRAM_APPLICATION_ID ,
x_program_id                =>  X_PROGRAM_ID,
x_program_update_date       =>  X_PROGRAM_UPDATE_DATE,
x_cart                      =>  X_CART,
x_org_unit_cd               =>  X_ORG_UNIT_CD,
x_rsv_seat_ext_id           =>  X_RSV_SEAT_EXT_ID,
x_gs_version_number         =>  X_GS_VERSION_NUMBER,
x_failed_unit_rule          =>  X_FAILED_UNIT_RULE,
x_deg_aud_detail_id         =>  X_DEG_AUD_DETAIL_ID,
x_uoo_id => X_UOO_ID,
x_core_indicator_code       =>  X_CORE_INDICATOR_CODE
);

Line: 593


  insert into IGS_EN_SU_ATTEMPT_H_ALL (
    ELO_DESCRIPTION,
    SUP_UNIT_CD,
    SUP_VERSION_NUMBER,
    ALTERNATIVE_TITLE,
    OVERRIDE_ENROLLED_CP,
    OVERRIDE_EFTSU,
    OVERRIDE_ACHIEVABLE_CP,
    OVERRIDE_OUTCOME_DUE_DT,
    OVERRIDE_CREDIT_REASON,
    PERSON_ID,
    COURSE_CD,
    UNIT_CD,
    VERSION_NUMBER,
    CAL_TYPE,
    CI_SEQUENCE_NUMBER,
    HIST_START_DT,
    HIST_END_DT,
    HIST_WHO,
    LOCATION_CD,
    UNIT_CLASS,
    ENROLLED_DT,
    UNIT_ATTEMPT_STATUS,
    ADMINISTRATIVE_UNIT_STATUS,
    AUS_DESCRIPTION,
    DISCONTINUED_DT,
    RULE_WAIVED_DT,
    RULE_WAIVED_PERSON_ID,
    NO_ASSESSMENT_IND,
    EXAM_LOCATION_CD,
    DCNT_REASON_CD,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    org_id,
    GRADING_SCHEMA_CODE,
    ENR_METHOD_TYPE,
    ADMINISTRATIVE_PRIORITY,
    WAITLIST_DT,
    REQUEST_ID,
    PROGRAM_APPLICATION_ID,
    PROGRAM_ID,
    PROGRAM_UPDATE_DATE ,
    CART,
    ORG_UNIT_CD,
    RSV_SEAT_EXT_ID,
    GS_VERSION_NUMBER,
    FAILED_UNIT_RULE,
    DEG_AUD_DETAIL_ID,
    UOO_ID,
    CORE_INDICATOR_CODE
  ) values (
    new_references.ELO_DESCRIPTION,
    new_references.SUP_UNIT_CD,
    new_references.SUP_VERSION_NUMBER,
    new_references.ALTERNATIVE_TITLE,
    new_references.OVERRIDE_ENROLLED_CP,
    new_references.OVERRIDE_EFTSU,
    new_references.OVERRIDE_ACHIEVABLE_CP,
    new_references.OVERRIDE_OUTCOME_DUE_DT,
    new_references.OVERRIDE_CREDIT_REASON,
    new_references.PERSON_ID,
    new_references.COURSE_CD,
    new_references.UNIT_CD,
    new_references.VERSION_NUMBER,
    new_references.CAL_TYPE,
    new_references.CI_SEQUENCE_NUMBER,
    new_references.HIST_START_DT,
    new_references.HIST_END_DT,
    new_references.HIST_WHO,
    new_references.LOCATION_CD,
    new_references.UNIT_CLASS,
    new_references.ENROLLED_DT,
    new_references.UNIT_ATTEMPT_STATUS,
    new_references.ADMINISTRATIVE_UNIT_STATUS,
    new_references.AUS_DESCRIPTION,
    new_references.DISCONTINUED_DT,
    new_references.RULE_WAIVED_DT,
    new_references.RULE_WAIVED_PERSON_ID,
    new_references.NO_ASSESSMENT_IND,
    new_references.EXAM_LOCATION_CD,
    new_references.DCNT_REASON_CD,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN,
    new_references.org_id,
    new_references.GRADING_SCHEMA_CODE,
    new_references.ENR_METHOD_TYPE,
    new_references.ADMINISTRATIVE_PRIORITY,
    new_references.WAITLIST_DT,
    new_references.REQUEST_ID,
    new_references.PROGRAM_APPLICATION_ID,
    new_references.PROGRAM_ID,
    new_references.PROGRAM_UPDATE_DATE,
    new_references.CART,
    new_references.ORG_UNIT_CD,
    new_references.RSV_SEAT_EXT_ID,
    new_references.GS_VERSION_NUMBER,
    new_references.FAILED_UNIT_RULE,
    new_references.DEG_AUD_DETAIL_ID,
    new_references.UOO_ID,
    new_references.CORE_INDICATOR_CODE
    );

Line: 708


end INSERT_ROW;

Line: 748


  X_PROGRAM_UPDATE_DATE         IN DATE DEFAULT NULL,
  X_CART                        IN VARCHAR2 DEFAULT NULL,
  X_ORG_UNIT_CD                 IN VARCHAR2 DEFAULT NULL,
  X_RSV_SEAT_EXT_ID             IN NUMBER DEFAULT NULL,
  X_GS_VERSION_NUMBER           IN NUMBER DEFAULT NULL,
  X_FAILED_UNIT_RULE            IN VARCHAR2 DEFAULT NULL,
  X_DEG_AUD_DETAIL_ID           IN NUMBER DEFAULT NULL,
  X_UOO_ID                  IN NUMBER,
  X_CORE_INDICATOR_CODE IN VARCHAR2 DEFAULT NULL
) AS
  cursor c1 is select
      ELO_DESCRIPTION,
      SUP_UNIT_CD,
      SUP_VERSION_NUMBER,
      ALTERNATIVE_TITLE,
      OVERRIDE_ENROLLED_CP,
      OVERRIDE_EFTSU,
      OVERRIDE_ACHIEVABLE_CP,
      OVERRIDE_OUTCOME_DUE_DT,
      OVERRIDE_CREDIT_REASON,
      VERSION_NUMBER,
      HIST_END_DT,
      HIST_WHO,
      LOCATION_CD,
      UNIT_CLASS,
      ENROLLED_DT,
      UNIT_ATTEMPT_STATUS,
      ADMINISTRATIVE_UNIT_STATUS,
      AUS_DESCRIPTION,
      DISCONTINUED_DT,
      RULE_WAIVED_DT,
      RULE_WAIVED_PERSON_ID,
      NO_ASSESSMENT_IND,
      EXAM_LOCATION_CD,
      dcnt_reason_cd,
      GRADING_SCHEMA_CODE,
      ENR_METHOD_TYPE,
      ADMINISTRATIVE_PRIORITY ,
      WAITLIST_DT,
      REQUEST_ID,
      PROGRAM_APPLICATION_ID,
      PROGRAM_ID,
      PROGRAM_UPDATE_DATE,
      CART,
      ORG_UNIT_CD,
      RSV_SEAT_EXT_ID,
      GS_VERSION_NUMBER,
      FAILED_UNIT_RULE,
      DEG_AUD_DETAIL_ID,
      UOO_ID,
      CORE_INDICATOR_CODE
    from IGS_EN_SU_ATTEMPT_H_ALL
    where PERSON_ID = X_PERSON_ID
    and COURSE_CD = X_COURSE_CD
    and HIST_START_DT = X_HIST_START_DT
    and UOO_ID = X_UOO_ID
    for update of PERSON_ID nowait;

Line: 912


      AND ((tlinfo.PROGRAM_UPDATE_DATE = X_PROGRAM_UPDATE_DATE)
           OR ((tlinfo.PROGRAM_UPDATE_DATE is null)
               AND (X_PROGRAM_UPDATE_DATE is null)))

      AND ((tlinfo.CART = X_CART)
           OR ((tlinfo.CART is null)
               AND (X_CART is null)))

      AND ((tlinfo.ORG_UNIT_CD = X_ORG_UNIT_CD)
           OR ((tlinfo.ORG_UNIT_CD is null)
               AND (X_ORG_UNIT_CD is null)))

      AND ((tlinfo.RSV_SEAT_EXT_ID = X_RSV_SEAT_EXT_ID)
           OR ((tlinfo.RSV_SEAT_EXT_ID is null)
               AND (X_RSV_SEAT_EXT_ID is null)))

      AND ((tlinfo.GS_VERSION_NUMBER = X_GS_VERSION_NUMBER)
           OR ((tlinfo.GS_VERSION_NUMBER is null)
               AND (X_GS_VERSION_NUMBER is null)))

      AND ((tlinfo.FAILED_UNIT_RULE = X_FAILED_UNIT_RULE)
           OR ((tlinfo.FAILED_UNIT_RULE is null)
               AND (X_FAILED_UNIT_RULE is null)))

      AND ((tlinfo.DEG_AUD_DETAIL_ID = X_DEG_AUD_DETAIL_ID)
           OR ((tlinfo.DEG_AUD_DETAIL_ID is null)
               AND (X_DEG_AUD_DETAIL_ID is null)))

      AND   ((tlinfo.CORE_INDICATOR_CODE = X_CORE_INDICATOR_CODE)
               OR (( tlinfo.CORE_INDICATOR_CODE is null)
               AND (X_CORE_INDICATOR_CODE is null)))

  ) then
    null;

Line: 953


procedure UPDATE_ROW (
  X_ROWID in VARCHAR2,
  X_PERSON_ID in NUMBER,
  X_COURSE_CD in VARCHAR2,
  X_UNIT_CD in VARCHAR2,
  X_CAL_TYPE in VARCHAR2,
  X_CI_SEQUENCE_NUMBER in NUMBER,
  X_HIST_START_DT in DATE,
  X_ELO_DESCRIPTION in VARCHAR2,
  X_SUP_UNIT_CD in VARCHAR2,
  X_SUP_VERSION_NUMBER in NUMBER,
  X_ALTERNATIVE_TITLE in VARCHAR2,
  X_OVERRIDE_ENROLLED_CP in NUMBER,
  X_OVERRIDE_EFTSU in NUMBER,
  X_OVERRIDE_ACHIEVABLE_CP in NUMBER,
  X_OVERRIDE_OUTCOME_DUE_DT in DATE,
  X_OVERRIDE_CREDIT_REASON in VARCHAR2,
  X_VERSION_NUMBER in NUMBER,
  X_HIST_END_DT in DATE,
  X_HIST_WHO in NUMBER,
  X_LOCATION_CD in VARCHAR2,
  X_UNIT_CLASS in VARCHAR2,
  X_ENROLLED_DT in DATE,
  X_UNIT_ATTEMPT_STATUS in VARCHAR2,
  X_ADMINISTRATIVE_UNIT_STATUS in VARCHAR2,
  X_AUS_DESCRIPTION in VARCHAR2,
  X_DISCONTINUED_DT in DATE,
  X_RULE_WAIVED_DT in DATE,
  X_RULE_WAIVED_PERSON_ID in NUMBER,
  X_NO_ASSESSMENT_IND in VARCHAR2,
  X_EXAM_LOCATION_CD in VARCHAR2,
  x_dcnt_reason_cd IN VARCHAR2,
  X_MODE in VARCHAR2 default 'R',
  X_GRADING_SCHEMA_CODE IN VARCHAR2 DEFAULT NULL,
  X_ENR_METHOD_TYPE IN VARCHAR2 DEFAULT NULL,
  X_ADMINISTRATIVE_PRIORITY     IN NUMBER DEFAULT NULL,
  X_WAITLIST_DT                 IN DATE DEFAULT NULL,
  X_REQUEST_ID                  IN NUMBER DEFAULT NULL,
  X_PROGRAM_APPLICATION_ID      IN NUMBER DEFAULT NULL,
  X_PROGRAM_ID                  IN NUMBER DEFAULT NULL,
  X_PROGRAM_UPDATE_DATE         IN DATE DEFAULT NULL,
  X_CART                        IN VARCHAR2 DEFAULT NULL,
  X_ORG_UNIT_CD                 IN VARCHAR2 DEFAULT NULL,
  X_RSV_SEAT_EXT_ID             IN NUMBER DEFAULT NULL,
  X_GS_VERSION_NUMBER           IN NUMBER DEFAULT NULL,
  X_FAILED_UNIT_RULE            IN VARCHAR2 DEFAULT NULL,
  X_DEG_AUD_DETAIL_ID           IN NUMBER DEFAULT NULL,
  X_UOO_ID                  IN NUMBER,
  X_CORE_INDICATOR_CODE IN VARCHAR2 DEFAULT NULL
  ) AS
    X_LAST_UPDATE_DATE DATE;

Line: 1004


    X_LAST_UPDATED_BY NUMBER;

Line: 1005


    X_LAST_UPDATE_LOGIN NUMBER;

Line: 1007


  X_LAST_UPDATE_DATE := SYSDATE;

Line: 1009


    X_LAST_UPDATED_BY := 1;

Line: 1010


    X_LAST_UPDATE_LOGIN := 0;

Line: 1012


    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1013


    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 1016


    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 1017


    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 1026


 p_action=>'UPDATE',
x_rowid=>X_ROWID,
x_administrative_unit_status=>X_ADMINISTRATIVE_UNIT_STATUS,
x_alternative_title=>X_ALTERNATIVE_TITLE,
x_aus_description=>X_AUS_DESCRIPTION,
x_cal_type=>X_CAL_TYPE,
x_ci_sequence_number=>X_CI_SEQUENCE_NUMBER,
x_course_cd=>X_COURSE_CD,
x_discontinued_dt=>X_DISCONTINUED_DT,
x_elo_description=>X_ELO_DESCRIPTION,
x_enrolled_dt=>X_ENROLLED_DT,
x_exam_location_cd=>X_EXAM_LOCATION_CD,
x_hist_end_dt=>X_HIST_END_DT,
x_hist_start_dt=>X_HIST_START_DT,
x_hist_who=>X_HIST_WHO,
x_location_cd=>X_LOCATION_CD,
x_no_assessment_ind=>X_NO_ASSESSMENT_IND,
x_override_achievable_cp=>X_OVERRIDE_ACHIEVABLE_CP,
x_override_credit_reason=>X_OVERRIDE_CREDIT_REASON,
x_override_eftsu=>X_OVERRIDE_EFTSU,
x_override_enrolled_cp=>X_OVERRIDE_ENROLLED_CP,
x_override_outcome_due_dt=>X_OVERRIDE_OUTCOME_DUE_DT,
x_person_id=>X_PERSON_ID,
x_rule_waived_dt=>X_RULE_WAIVED_DT,
x_rule_waived_person_id=>X_RULE_WAIVED_PERSON_ID,
x_sup_unit_cd=>X_SUP_UNIT_CD,
x_sup_version_number=>X_SUP_VERSION_NUMBER,
x_unit_attempt_status=>X_UNIT_ATTEMPT_STATUS,
x_unit_cd=>X_UNIT_CD,
x_unit_class=>X_UNIT_CLASS,
x_version_number=>X_VERSION_NUMBER,
x_dcnt_reason_cd => x_dcnt_reason_cd,
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_grading_schema_code =>X_GRADING_SCHEMA_CODE,
x_enr_method_type =>X_ENR_METHOD_TYPE,
x_administrative_priority   =>  X_ADMINISTRATIVE_PRIORITY,
x_waitlist_dt               =>  X_WAITLIST_DT,
x_request_id                =>  X_REQUEST_ID,
x_program_application_id    =>  X_PROGRAM_APPLICATION_ID ,
x_program_id                =>  X_PROGRAM_ID,
x_program_update_date       =>  X_PROGRAM_UPDATE_DATE,
x_cart                      =>  X_CART,
x_org_unit_cd               =>  X_ORG_UNIT_CD,
x_rsv_seat_ext_id           =>  X_RSV_SEAT_EXT_ID,
x_gs_version_number         =>  X_GS_VERSION_NUMBER,
x_failed_unit_rule          =>  X_FAILED_UNIT_RULE,
x_deg_aud_detail_id         =>  X_DEG_AUD_DETAIL_ID,
x_uoo_id                => X_UOO_ID,
x_core_indicator_code            =>  X_CORE_INDICATOR_CODE
);

Line: 1080


  update IGS_EN_SU_ATTEMPT_H_ALL set
    ELO_DESCRIPTION = new_references.ELO_DESCRIPTION,
    SUP_UNIT_CD = new_references.SUP_UNIT_CD,
    SUP_VERSION_NUMBER = new_references.SUP_VERSION_NUMBER,
    ALTERNATIVE_TITLE = new_references.ALTERNATIVE_TITLE,
    OVERRIDE_ENROLLED_CP = new_references.OVERRIDE_ENROLLED_CP,
    OVERRIDE_EFTSU = new_references.OVERRIDE_EFTSU,
    OVERRIDE_ACHIEVABLE_CP = new_references.OVERRIDE_ACHIEVABLE_CP,
    OVERRIDE_OUTCOME_DUE_DT = new_references.OVERRIDE_OUTCOME_DUE_DT,
    OVERRIDE_CREDIT_REASON = new_references.OVERRIDE_CREDIT_REASON,
    VERSION_NUMBER = new_references.VERSION_NUMBER,
    HIST_END_DT = new_references.HIST_END_DT,
    HIST_WHO = new_references.HIST_WHO,
    LOCATION_CD = new_references.LOCATION_CD,
    UNIT_CLASS = new_references.UNIT_CLASS,
    ENROLLED_DT = new_references.ENROLLED_DT,
    UNIT_ATTEMPT_STATUS = new_references.UNIT_ATTEMPT_STATUS,
    ADMINISTRATIVE_UNIT_STATUS = new_references.ADMINISTRATIVE_UNIT_STATUS,
    AUS_DESCRIPTION = new_references.AUS_DESCRIPTION,
    DISCONTINUED_DT = new_references.DISCONTINUED_DT,
    RULE_WAIVED_DT = new_references.RULE_WAIVED_DT,
    RULE_WAIVED_PERSON_ID = new_references.RULE_WAIVED_PERSON_ID,
    NO_ASSESSMENT_IND = new_references.NO_ASSESSMENT_IND,
    EXAM_LOCATION_CD = new_references.EXAM_LOCATION_CD,
    DCNT_REASON_CD = new_references.DCNT_REASON_CD,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
    GRADING_SCHEMA_CODE=new_references.GRADING_SCHEMA_CODE,
    ENR_METHOD_TYPE=new_references.ENR_METHOD_TYPE,
    ADMINISTRATIVE_PRIORITY =  new_references.ADMINISTRATIVE_PRIORITY,
    WAITLIST_DT             =   new_references.WAITLIST_DT,
    REQUEST_ID              =   new_references.REQUEST_ID,
    PROGRAM_APPLICATION_ID  =   new_references.PROGRAM_APPLICATION_ID ,
    PROGRAM_ID              =   new_references.PROGRAM_ID,
    PROGRAM_UPDATE_DATE     =   new_references.PROGRAM_UPDATE_DATE,
    CART                    =   new_references.CART,
    ORG_UNIT_CD             =   new_references.ORG_UNIT_CD,
    RSV_SEAT_EXT_ID         =   new_references.RSV_SEAT_EXT_ID,
    GS_VERSION_NUMBER       =   new_references.GS_VERSION_NUMBER,
    FAILED_UNIT_RULE        =   new_references.FAILED_UNIT_RULE,
    DEG_AUD_DETAIL_ID       =   new_references.DEG_AUD_DETAIL_ID,
    CORE_INDICATOR_CODE          =   new_references.CORE_INDICATOR_CODE
  where ROWID = X_ROWID
  ;

Line: 1129


end UPDATE_ROW;

Line: 1171


  X_PROGRAM_UPDATE_DATE         IN DATE DEFAULT NULL,
  X_CART                        IN VARCHAR2 DEFAULT NULL,
  X_ORG_UNIT_CD                 IN VARCHAR2 DEFAULT NULL,
  X_RSV_SEAT_EXT_ID             IN NUMBER DEFAULT NULL,
  X_GS_VERSION_NUMBER           IN NUMBER DEFAULT NULL,
  X_FAILED_UNIT_RULE            IN VARCHAR2 DEFAULT NULL,
  X_DEG_AUD_DETAIL_ID           IN NUMBER DEFAULT NULL,
  X_UOO_ID                  IN NUMBER,
  X_CORE_INDICATOR_CODE IN VARCHAR2 DEFAULT NULL
  ) as
  cursor c1 is select rowid from IGS_EN_SU_ATTEMPT_H_ALL
     where PERSON_ID = X_PERSON_ID
     and COURSE_CD = X_COURSE_CD
     and HIST_START_DT = X_HIST_START_DT
     and UOO_ID = X_UOO_ID;

Line: 1192


    INSERT_ROW (
     X_ROWID,
     X_PERSON_ID,
     X_COURSE_CD,
     X_UNIT_CD,
     X_CAL_TYPE,
     X_CI_SEQUENCE_NUMBER,
     X_HIST_START_DT,
     X_ELO_DESCRIPTION,
     X_SUP_UNIT_CD,
     X_SUP_VERSION_NUMBER,
     X_ALTERNATIVE_TITLE,
     X_OVERRIDE_ENROLLED_CP,
     X_OVERRIDE_EFTSU,
     X_OVERRIDE_ACHIEVABLE_CP,
     X_OVERRIDE_OUTCOME_DUE_DT,
     X_OVERRIDE_CREDIT_REASON,
     X_VERSION_NUMBER,
     X_HIST_END_DT,
     X_HIST_WHO,
     X_LOCATION_CD,
     X_UNIT_CLASS,
     X_ENROLLED_DT,
     X_UNIT_ATTEMPT_STATUS,
     X_ADMINISTRATIVE_UNIT_STATUS,
     X_AUS_DESCRIPTION,
     X_DISCONTINUED_DT,
     X_RULE_WAIVED_DT,
     X_RULE_WAIVED_PERSON_ID,
     X_NO_ASSESSMENT_IND,
     X_EXAM_LOCATION_CD,
     X_DCNT_REASON_CD,
     X_MODE,
     x_org_id,
     X_GRADING_SCHEMA_CODE,
     X_ENR_METHOD_TYPE,
     X_ADMINISTRATIVE_PRIORITY,
     X_WAITLIST_DT,
     X_REQUEST_ID,
     X_PROGRAM_APPLICATION_ID,
     X_PROGRAM_ID,
     X_PROGRAM_UPDATE_DATE,
     X_CART,
     X_ORG_UNIT_CD,
     X_RSV_SEAT_EXT_ID,
     X_GS_VERSION_NUMBER,
     X_FAILED_UNIT_RULE ,
     X_DEG_AUD_DETAIL_ID,
     X_UOO_ID,
     X_CORE_INDICATOR_CODE
  );

Line: 1246


  UPDATE_ROW (
   X_ROWID,
   X_PERSON_ID,
   X_COURSE_CD,
   X_UNIT_CD,
   X_CAL_TYPE,
   X_CI_SEQUENCE_NUMBER,
   X_HIST_START_DT,
   X_ELO_DESCRIPTION,
   X_SUP_UNIT_CD,
   X_SUP_VERSION_NUMBER,
   X_ALTERNATIVE_TITLE,
   X_OVERRIDE_ENROLLED_CP,
   X_OVERRIDE_EFTSU,
   X_OVERRIDE_ACHIEVABLE_CP,
   X_OVERRIDE_OUTCOME_DUE_DT,
   X_OVERRIDE_CREDIT_REASON,
   X_VERSION_NUMBER,
   X_HIST_END_DT,
   X_HIST_WHO,
   X_LOCATION_CD,
   X_UNIT_CLASS,
   X_ENROLLED_DT,
   X_UNIT_ATTEMPT_STATUS,
   X_ADMINISTRATIVE_UNIT_STATUS,
   X_AUS_DESCRIPTION,
   X_DISCONTINUED_DT,
   X_RULE_WAIVED_DT,
   X_RULE_WAIVED_PERSON_ID,
   X_NO_ASSESSMENT_IND,
   X_EXAM_LOCATION_CD,
   X_DCNT_REASON_CD,
   X_MODE,
   X_GRADING_SCHEMA_CODE,
   X_ENR_METHOD_TYPE,
   X_ADMINISTRATIVE_PRIORITY,
   X_WAITLIST_DT,
   X_REQUEST_ID,
   X_PROGRAM_APPLICATION_ID,
   X_PROGRAM_ID,
   X_PROGRAM_UPDATE_DATE,
   X_CART,
   X_ORG_UNIT_CD,
   X_RSV_SEAT_EXT_ID,
   X_GS_VERSION_NUMBER,
   X_FAILED_UNIT_RULE   ,
   X_DEG_AUD_DETAIL_ID,
   X_UOO_ID,
   X_CORE_INDICATOR_CODE
 );

Line: 1297


procedure DELETE_ROW (
  X_ROWID in VARCHAR2
) AS
begin
  Before_DML(
  p_action => 'DELETE',
  x_rowid => X_ROWID
  );

Line: 1305


  delete from IGS_EN_SU_ATTEMPT_H_ALL
  where ROWID=X_ROWID;

Line: 1311


end DELETE_ROW;