DBA Data[Home] [Help]

APPS.IGS_AD_PS_APPL_PKG SQL Statements

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

Line: 25

    x_last_update_date IN DATE DEFAULT NULL,
    x_last_updated_by IN NUMBER DEFAULT NULL,
    x_last_update_login IN NUMBER DEFAULT NULL
  ) AS

    CURSOR cur_old_ref_values IS
      SELECT   *
      FROM     IGS_AD_PS_APPL_ALL
      WHERE    rowid = x_rowid;
Line: 43

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

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

    new_references.last_update_date := x_last_update_date;
Line: 72

    new_references.last_updated_by := x_last_updated_by;
Line: 73

    new_references.last_update_login := x_last_update_login;
Line: 77

PROCEDURE BeforeRowInsertUpdate1(
    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: 105

        SELECT  s_admission_step_type,
                step_type_restriction_num
        FROM    IGS_AD_PRCS_CAT_STEP
        WHERE   admission_cat = cp_admission_cat AND
                s_admission_process_type = cp_s_admission_process_type AND
                step_group_type <> 'TRACK'; --2402377
Line: 153

        IF p_inserting THEN
                --
                -- Validate preference limit.
                --
                IF IGS_AD_VAL_ACA.admp_val_pref_limit (
                                new_references.person_id,
                                new_references.admission_appl_number,
                                new_references.nominated_course_cd,
                                -1,     -- ACAI sequence number, not known yet.
                                v_s_admission_process_type,
                                v_pref_limit,
                                v_message_name) = FALSE THEN
                        --raise_application_error(-20000, IGS_GE_GEN_002.GENP_GET_MESSAGE(v_message_num));
Line: 257

        END IF; -- p_inserting
Line: 356

  END BeforeRowInsertUpdate1;
Line: 364

  PROCEDURE AfterRowUpdateDelete2(
    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: 381

      SELECT adm_appl_status
      FROM igs_ad_appl
      WHERE person_id = cp_person_id
      AND   admission_appl_number= cp_admission_appl_number;
Line: 407

                        new_references.last_updated_by,
                        old_references.last_updated_by,
                        new_references.last_update_date,
                        old_references.last_update_date);
Line: 435

                  UPDATE
                    IGS_AD_APPL
                  SET
                    adm_appl_status = v_derived_adm_appl_status
                  WHERE person_id = v_person_id AND
                        admission_appl_number = v_admission_appl_number;
Line: 460

  END AfterRowUpdateDelete2;
Line: 559

      SELECT   rowid
      FROM     IGS_AD_PS_APPL_ALL
      WHERE    person_id = x_person_id
      AND      admission_appl_number = x_admission_appl_number
      AND      nominated_course_cd = x_nominated_course_cd
      FOR UPDATE NOWAIT;
Line: 589

      SELECT   rowid
      FROM     IGS_AD_PS_APPL_ALL
      WHERE    person_id = x_person_id
      AND      admission_appl_number = x_admission_appl_number ;
Line: 616

      SELECT   rowid
      FROM     IGS_AD_PS_APPL_ALL
      WHERE    admission_cd = x_admission_cd ;
Line: 642

      SELECT   rowid
      FROM     IGS_AD_PS_APPL_ALL
      WHERE    basis_for_admission_type = x_basis_for_admission_type ;
Line: 668

      SELECT   rowid
      FROM     IGS_AD_PS_APPL_ALL
      WHERE    nominated_course_cd = x_course_cd ;
Line: 695

      SELECT   rowid
      FROM     IGS_AD_PS_APPL_ALL
      WHERE    person_id = x_person_id
      AND      transfer_course_cd = x_course_cd ;
Line: 809

    x_last_update_date IN DATE DEFAULT NULL,
    x_last_updated_by IN NUMBER DEFAULT NULL,
    x_last_update_login IN NUMBER DEFAULT NULL
  ) AS
  BEGIN

    Set_Column_Values (
      p_action,
      x_rowid,
                        x_org_id,
      x_person_id,
      x_admission_appl_number,
      x_nominated_course_cd,
      x_transfer_course_cd,
      x_basis_for_admission_type,
      x_admission_cd,
      x_course_rank_set,
      x_course_rank_schedule,
      x_req_for_reconsideration_ind,
      x_req_for_adv_standing_ind,
      x_creation_date,
      x_created_by,
      x_last_update_date,
      x_last_updated_by,
      x_last_update_login
    );
Line: 836

    IF (p_action = 'INSERT') THEN
      -- Call all the procedures related to Before Insert.
      BeforeRowInsertUpdate1 ( p_inserting => TRUE );
Line: 850

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

    ELSIF (p_action = 'DELETE') THEN
      -- Call all the procedures related to Before Delete.
      Null;
Line: 860

    ELSIF ( p_action = 'VALIDATE_INSERT') THEN
     IF GET_PK_FOR_VALIDATION(
       new_references.person_id,
       new_references.admission_appl_number,
       new_references.nominated_course_cd
     )THEN
       FND_MESSAGE.SET_NAME('IGS','IGS_GE_MULTI_ORG_DUP_REC');
Line: 871

    ELSIF ( p_action = 'VALIDATE_UPDATE') THEN
      Check_Constraints;
Line: 873

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

   IF (p_action = 'UPDATE') THEN
      -- Call all the procedures related to After Update.
      AfterRowUpdateDelete2 ( p_updating => TRUE );
Line: 890

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

procedure INSERT_ROW (
  X_ROWID in out NOCOPY VARCHAR2,
        X_ORG_ID in NUMBER,
  X_PERSON_ID in NUMBER,
  X_ADMISSION_APPL_NUMBER in NUMBER,
  X_NOMINATED_COURSE_CD in VARCHAR2,
  X_TRANSFER_COURSE_CD in VARCHAR2,
  X_BASIS_FOR_ADMISSION_TYPE in VARCHAR2,
  X_ADMISSION_CD in VARCHAR2,
  X_COURSE_RANK_SET in VARCHAR2,
  X_COURSE_RANK_SCHEDULE in VARCHAR2,
  X_REQ_FOR_RECONSIDERATION_IND in VARCHAR2,
  X_REQ_FOR_ADV_STANDING_IND in VARCHAR2,
  X_MODE in VARCHAR2
  ) as
    cursor C is select ROWID from IGS_AD_PS_APPL_ALL
      where PERSON_ID = X_PERSON_ID
      and ADMISSION_APPL_NUMBER = X_ADMISSION_APPL_NUMBER
      and NOMINATED_COURSE_CD = X_NOMINATED_COURSE_CD;
Line: 916

    X_LAST_UPDATE_DATE DATE;
Line: 917

    X_LAST_UPDATED_BY NUMBER;
Line: 918

    X_LAST_UPDATE_LOGIN NUMBER;
Line: 922

    X_PROGRAM_UPDATE_DATE DATE;
Line: 924

  X_LAST_UPDATE_DATE := SYSDATE;
Line: 926

    X_LAST_UPDATED_BY := 1;
Line: 927

    X_LAST_UPDATE_LOGIN := 0;
Line: 929

    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 930

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

    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
Line: 934

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

      X_PROGRAM_UPDATE_DATE := NULL;
Line: 946

      X_PROGRAM_UPDATE_DATE := SYSDATE;
Line: 955

  Before_DML(p_action =>'INSERT',
  x_rowid =>X_ROWID,
        x_org_id => igs_ge_gen_003.get_org_id,
  x_person_id => X_PERSON_ID,
  x_admission_appl_number => X_ADMISSION_APPL_NUMBER,
  x_nominated_course_cd => X_NOMINATED_COURSE_CD,
  x_transfer_course_cd => X_TRANSFER_COURSE_CD,
  x_basis_for_admission_type => X_BASIS_FOR_ADMISSION_TYPE,
  x_admission_cd  => X_ADMISSION_CD,
  x_course_rank_set  => X_COURSE_RANK_SET,
  x_course_rank_schedule  => X_COURSE_RANK_SCHEDULE,
  x_req_for_reconsideration_ind  => NVL(X_REQ_FOR_RECONSIDERATION_IND,'N'),
  x_req_for_adv_standing_ind  => NVL(X_REQ_FOR_ADV_STANDING_IND,'N'),
  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: 978

 insert into IGS_AD_PS_APPL_ALL (
                ORG_ID,
    PERSON_ID,
    ADMISSION_APPL_NUMBER,
    NOMINATED_COURSE_CD,
    TRANSFER_COURSE_CD,
    BASIS_FOR_ADMISSION_TYPE,
    ADMISSION_CD,
    COURSE_RANK_SET,
    COURSE_RANK_SCHEDULE,
    REQ_FOR_RECONSIDERATION_IND,
    REQ_FOR_ADV_STANDING_IND,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    REQUEST_ID,
    PROGRAM_ID,
    PROGRAM_APPLICATION_ID,
    PROGRAM_UPDATE_DATE
  ) values (
    NEW_REFERENCES.ORG_ID,
    NEW_REFERENCES.PERSON_ID,
    NEW_REFERENCES.ADMISSION_APPL_NUMBER,
    NEW_REFERENCES.NOMINATED_COURSE_CD,
    NEW_REFERENCES.TRANSFER_COURSE_CD,
    NEW_REFERENCES.BASIS_FOR_ADMISSION_TYPE,
    NEW_REFERENCES.ADMISSION_CD,
    NEW_REFERENCES.COURSE_RANK_SET,
    NEW_REFERENCES.COURSE_RANK_SCHEDULE,
    NEW_REFERENCES.REQ_FOR_RECONSIDERATION_IND,
    NEW_REFERENCES.REQ_FOR_ADV_STANDING_IND,
    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
  );
Line: 1035

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

end INSERT_ROW;
Line: 1072

  cursor c1 is select
      TRANSFER_COURSE_CD,
      BASIS_FOR_ADMISSION_TYPE,
      ADMISSION_CD,
      COURSE_RANK_SET,
      COURSE_RANK_SCHEDULE,
      REQ_FOR_RECONSIDERATION_IND,
      REQ_FOR_ADV_STANDING_IND
    from IGS_AD_PS_APPL_ALL
    where ROWID = X_ROWID
    for update nowait;
Line: 1089

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

procedure UPDATE_ROW (
  X_ROWID in VARCHAR2,
  X_PERSON_ID in NUMBER,
  X_ADMISSION_APPL_NUMBER in NUMBER,
  X_NOMINATED_COURSE_CD in VARCHAR2,
  X_TRANSFER_COURSE_CD in VARCHAR2,
  X_BASIS_FOR_ADMISSION_TYPE in VARCHAR2,
  X_ADMISSION_CD in VARCHAR2,
  X_COURSE_RANK_SET in VARCHAR2,
  X_COURSE_RANK_SCHEDULE in VARCHAR2,
  X_REQ_FOR_RECONSIDERATION_IND in VARCHAR2,
  X_REQ_FOR_ADV_STANDING_IND in VARCHAR2,
  X_MODE in VARCHAR2
  ) as
    X_LAST_UPDATE_DATE DATE;
Line: 1139

    X_LAST_UPDATED_BY NUMBER;
Line: 1140

    X_LAST_UPDATE_LOGIN NUMBER;
Line: 1144

    X_PROGRAM_UPDATE_DATE DATE;
Line: 1146

  X_LAST_UPDATE_DATE := SYSDATE;
Line: 1148

    X_LAST_UPDATED_BY := 1;
Line: 1149

    X_LAST_UPDATE_LOGIN := 0;
Line: 1151

    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 1152

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

    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
Line: 1156

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

  Before_DML(p_action =>'UPDATE',
  x_rowid =>X_ROWID,
  x_person_id => X_PERSON_ID,
  x_admission_appl_number => X_ADMISSION_APPL_NUMBER,
  x_nominated_course_cd => X_NOMINATED_COURSE_CD,
  x_transfer_course_cd => X_TRANSFER_COURSE_CD,
  x_basis_for_admission_type => X_BASIS_FOR_ADMISSION_TYPE,
  x_admission_cd  => X_ADMISSION_CD,
  x_course_rank_set  => X_COURSE_RANK_SET,
  x_course_rank_schedule  => X_COURSE_RANK_SCHEDULE,
  x_req_for_reconsideration_ind  => X_REQ_FOR_RECONSIDERATION_IND,
  x_req_for_adv_standing_ind  => X_REQ_FOR_ADV_STANDING_IND,
  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: 1193

    X_PROGRAM_UPDATE_DATE := OLD_REFERENCES.PROGRAM_UPDATE_DATE;
Line: 1195

    X_PROGRAM_UPDATE_DATE := SYSDATE;
Line: 1201

 update IGS_AD_PS_APPL_ALL set
    TRANSFER_COURSE_CD = NEW_REFERENCES.TRANSFER_COURSE_CD,
    BASIS_FOR_ADMISSION_TYPE = NEW_REFERENCES.BASIS_FOR_ADMISSION_TYPE,
    ADMISSION_CD = NEW_REFERENCES.ADMISSION_CD,
    COURSE_RANK_SET = NEW_REFERENCES.COURSE_RANK_SET,
    COURSE_RANK_SCHEDULE = NEW_REFERENCES.COURSE_RANK_SCHEDULE,
    REQ_FOR_RECONSIDERATION_IND = NEW_REFERENCES.REQ_FOR_RECONSIDERATION_IND,
    REQ_FOR_ADV_STANDING_IND = NEW_REFERENCES.REQ_FOR_ADV_STANDING_IND,
    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
  where ROWID = X_ROWID
  ;
Line: 1232

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

end UPDATE_ROW;
Line: 1271

  cursor c1 is select rowid from IGS_AD_PS_APPL_ALL
     where PERSON_ID = X_PERSON_ID
     and ADMISSION_APPL_NUMBER = X_ADMISSION_APPL_NUMBER
     and NOMINATED_COURSE_CD = X_NOMINATED_COURSE_CD
  ;
Line: 1281

    INSERT_ROW (
     X_ROWID,
                 X_ORG_ID,
     X_PERSON_ID,
     X_ADMISSION_APPL_NUMBER,
     X_NOMINATED_COURSE_CD,
     X_TRANSFER_COURSE_CD,
     X_BASIS_FOR_ADMISSION_TYPE,
     X_ADMISSION_CD,
     X_COURSE_RANK_SET,
     X_COURSE_RANK_SCHEDULE,
     X_REQ_FOR_RECONSIDERATION_IND,
     X_REQ_FOR_ADV_STANDING_IND,
     X_MODE);
Line: 1298

  UPDATE_ROW (
   X_ROWID,
   X_PERSON_ID,
   X_ADMISSION_APPL_NUMBER,
   X_NOMINATED_COURSE_CD,
   X_TRANSFER_COURSE_CD,
   X_BASIS_FOR_ADMISSION_TYPE,
   X_ADMISSION_CD,
   X_COURSE_RANK_SET,
   X_COURSE_RANK_SCHEDULE,
   X_REQ_FOR_RECONSIDERATION_IND,
   X_REQ_FOR_ADV_STANDING_IND,
   X_MODE);
Line: 1313

procedure DELETE_ROW (
  X_ROWID in VARCHAR2,
  x_mode IN VARCHAR2
) as
begin

  BEFORE_DML(
   p_action =>'DELETE',
   x_rowid => X_ROWID
  );
Line: 1327

 delete from IGS_AD_PS_APPL_ALL
  where ROWID = X_ROWID;
Line: 1343

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

end DELETE_ROW;