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

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

Line: 26


    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_HIST_ALL
      WHERE    rowid = x_rowid;

Line: 44


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

Line: 68


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

Line: 75


    new_references.last_update_date := x_last_update_date;

Line: 76


    new_references.last_updated_by := x_last_updated_by;

Line: 77


    new_references.last_update_login := x_last_update_login;

Line: 90


      SELECT   rowid
      FROM     IGS_AD_PS_APPL_HIST_ALL
      WHERE    person_id = x_person_id
      AND      admission_appl_number = x_admission_appl_number
      AND      nominated_course_cd = x_nominated_course_cd
      AND      hist_start_dt = x_hist_start_dt
      FOR UPDATE NOWAIT;

Line: 218


    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_admission_appl_number,
      x_nominated_course_cd,
      x_hist_start_dt,
      x_hist_end_dt,
      x_hist_who,
      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_person_id,
      x_creation_date,
      x_created_by,
      x_last_update_date,
      x_last_updated_by,
      x_last_update_login
    );

Line: 248


    IF (p_action = 'INSERT') THEN
      -- Call all the procedures related to Before Insert.
      Null;

Line: 262


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

Line: 266


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

Line: 269


    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,
        new_references.hist_start_dt
       )THEN
        FND_MESSAGE.SET_NAME('IGS','IGS_GE_MULTI_ORG_DUP_REC');

Line: 281


    ELSIF (p_action = 'VALIDATE_UPDATE') THEN
      Check_constraints;

Line: 283


    ELSIF (p_action = 'VALIDATE_DELETE') THEN
      null;

Line: 301


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_HIST_START_DT in DATE,
  X_HIST_END_DT in DATE,
  X_HIST_WHO in NUMBER,
  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_HIST_ALL
      where PERSON_ID = X_PERSON_ID
      and ADMISSION_APPL_NUMBER = X_ADMISSION_APPL_NUMBER
      and NOMINATED_COURSE_CD = X_NOMINATED_COURSE_CD
      and HIST_START_DT = X_HIST_START_DT;

Line: 324


    X_LAST_UPDATE_DATE DATE;

Line: 325


    X_LAST_UPDATED_BY NUMBER;

Line: 326


    X_LAST_UPDATE_LOGIN NUMBER;

Line: 328


  X_LAST_UPDATE_DATE := SYSDATE;

Line: 330


    X_LAST_UPDATED_BY := 1;

Line: 331


    X_LAST_UPDATE_LOGIN := 0;

Line: 333


    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 334


    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 337


    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 338


    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 347


  Before_DML(p_action =>'INSERT',
  x_rowid =>X_ROWID,
	x_org_id => igs_ge_gen_003.get_org_id,
  x_admission_appl_number => X_ADMISSION_APPL_NUMBER,
  x_nominated_course_cd => X_NOMINATED_COURSE_CD,
  x_hist_start_dt => X_HIST_START_DT,
  x_hist_end_dt => X_HIST_END_DT,
  x_hist_who => X_HIST_WHO,
  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_person_id => X_PERSON_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: 370


  insert into IGS_AD_PS_APPL_HIST_ALL (
		ORG_ID,
    PERSON_ID,
    ADMISSION_APPL_NUMBER,
    NOMINATED_COURSE_CD,
    HIST_START_DT,
    HIST_END_DT,
    HIST_WHO,
    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
  ) values (
    NEW_REFERENCES.ORG_ID,
    NEW_REFERENCES.PERSON_ID,
    NEW_REFERENCES.ADMISSION_APPL_NUMBER,
    NEW_REFERENCES.NOMINATED_COURSE_CD,
    NEW_REFERENCES.HIST_START_DT,
    NEW_REFERENCES.HIST_END_DT,
    NEW_REFERENCES.HIST_WHO,
    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
  );

Line: 421


   p_action =>'INSERT',
   x_rowid => X_ROWID
  );

Line: 441


end INSERT_ROW;

Line: 459


  cursor c1 is select
      HIST_END_DT,
      HIST_WHO,
      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_HIST_ALL
    where ROWID = X_ROWID for update nowait;

Line: 477


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

Line: 518


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_HIST_START_DT in DATE,
  X_HIST_END_DT in DATE,
  X_HIST_WHO in NUMBER,
  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: 536


    X_LAST_UPDATED_BY NUMBER;

Line: 537


    X_LAST_UPDATE_LOGIN NUMBER;

Line: 539


  X_LAST_UPDATE_DATE := SYSDATE;

Line: 541


    X_LAST_UPDATED_BY := 1;

Line: 542


    X_LAST_UPDATE_LOGIN := 0;

Line: 544


    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 545


    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 548


    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 549


    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 558


  Before_DML(p_action =>'UPDATE',
  x_rowid =>X_ROWID,
  x_admission_appl_number => X_ADMISSION_APPL_NUMBER,
  x_nominated_course_cd => X_NOMINATED_COURSE_CD,
  x_hist_start_dt => X_HIST_START_DT,
  x_hist_end_dt => X_HIST_END_DT,
  x_hist_who => X_HIST_WHO,
  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_person_id => X_PERSON_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: 580


  update IGS_AD_PS_APPL_HIST_ALL set
    HIST_END_DT = NEW_REFERENCES.HIST_END_DT,
    HIST_WHO = NEW_REFERENCES.HIST_WHO,
    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
  where ROWID = X_ROWID
  ;

Line: 602


   p_action =>'UPDATE',
   x_rowid => X_ROWID
  );

Line: 622


end UPDATE_ROW;

Line: 642


  cursor c1 is select rowid from IGS_AD_PS_APPL_HIST_ALL
     where PERSON_ID = X_PERSON_ID
     and ADMISSION_APPL_NUMBER = X_ADMISSION_APPL_NUMBER
     and NOMINATED_COURSE_CD = X_NOMINATED_COURSE_CD
     and HIST_START_DT = X_HIST_START_DT
  ;

Line: 653


    INSERT_ROW (
     X_ROWID,
		 X_ORG_ID,
     X_PERSON_ID,
     X_ADMISSION_APPL_NUMBER,
     X_NOMINATED_COURSE_CD,
     X_HIST_START_DT,
     X_HIST_END_DT,
     X_HIST_WHO,
     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: 673


  UPDATE_ROW (
   X_ROWID,
   X_PERSON_ID,
   X_ADMISSION_APPL_NUMBER,
   X_NOMINATED_COURSE_CD,
   X_HIST_START_DT,
   X_HIST_END_DT,
   X_HIST_WHO,
   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: 691


procedure DELETE_ROW (
  X_ROWID in VARCHAR2
) as
begin

 Before_DML(
 p_action =>'DELETE',
 x_rowid => X_ROWID
 );

Line: 702


  delete from IGS_AD_PS_APPL_HIST_ALL
  where ROWID = X_ROWID;

Line: 711


 p_action =>'DELETE',
 x_rowid => X_ROWID
 );

Line: 731


end DELETE_ROW;