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

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

Line: 21


    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_positive_outcome_ind IN VARCHAR2 DEFAULT 'N'
  ) AS

    CURSOR cur_old_ref_values IS
      SELECT   *
      FROM     IGS_PR_OU_TYPE_ALL
      WHERE    rowid = x_rowid;

Line: 41


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

Line: 62


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

Line: 69


    new_references.last_update_date := x_last_update_date;

Line: 70


    new_references.last_updated_by := x_last_updated_by;

Line: 71


    new_references.last_update_login := x_last_update_login;

Line: 85


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

Line: 98


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

Line: 112


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

Line: 138


      SELECT   rowid
      FROM     IGS_PR_OU_TYPE_ALL
      WHERE    progression_outcome_type = x_progression_outcome_type ; 	  /* Removed for update of for the Locking issue. Bug 2784198  */

Line: 163


      SELECT   rowid
      FROM     IGS_PR_OU_TYPE_ALL
      WHERE    dflt_restricted_att_type = x_attendance_type ;

Line: 189


      SELECT   rowid
      FROM     IGS_PR_OU_TYPE_ALL
      WHERE    encumbrance_type = x_encumbrance_type ;

Line: 215


      SELECT   rowid
      FROM     IGS_PR_OU_TYPE_ALL
      WHERE    s_progression_outcome_type = x_s_progression_outcome_type ;

Line: 236


  PROCEDURE BeforeInsertUpdate(p_inserting BOOLEAN , p_updating BOOLEAN) AS
  p_message_name VARCHAR2(30);

Line: 239


   IF ( p_inserting = TRUE OR (p_updating = TRUE AND new_references.encumbrance_type <> old_references.encumbrance_type) ) THEN
     IF  NOT igs_en_val_etde.enrp_val_et_closed(new_references.encumbrance_type,p_message_name) THEN
        Fnd_Message.Set_Name('IGS', p_message_name);

Line: 246


  END BeforeInsertUpdate;

Line: 262


    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_positive_outcome_ind IN VARCHAR2 DEFAULT 'N'
  ) AS
  BEGIN

    Set_Column_Values (
      p_action,
      x_rowid,
      x_progression_outcome_type,
      x_s_progression_outcome_type,
      x_description,
      x_encumbrance_type,
      x_dflt_restricted_enrolment_cp,
      x_dflt_restricted_att_type,
      x_closed_ind,
      x_comments,
      x_creation_date,
      x_created_by,
      x_last_update_date,
      x_last_updated_by,
      x_last_update_login,
      x_org_id,
      x_positive_outcome_ind
    );

Line: 290


    IF (p_action = 'INSERT') THEN
       BeforeInsertUpdate(TRUE,FALSE);

Line: 303


    ELSIF (p_action = 'UPDATE') THEN
    BeforeInsertUpdate(FALSE,TRUE);

Line: 308


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

Line: 311


    ELSIF (p_action = 'VALIDATE_INSERT') THEN
      -- Call all the procedures related to Before Insert.
	IF Get_PK_For_Validation (
         new_references.progression_outcome_type
         ) THEN
        Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');

Line: 321


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

Line: 324


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

Line: 331


procedure INSERT_ROW (
  X_ROWID in out NOCOPY VARCHAR2,
  X_PROGRESSION_OUTCOME_TYPE in VARCHAR2,
  X_S_PROGRESSION_OUTCOME_TYPE in VARCHAR2,
  X_DESCRIPTION in VARCHAR2,
  X_ENCUMBRANCE_TYPE in VARCHAR2,
  X_DFLT_RESTRICTED_ENROLMENT_CP in NUMBER,
  X_DFLT_RESTRICTED_ATT_TYPE in VARCHAR2,
  X_CLOSED_IND in VARCHAR2,
  X_COMMENTS in VARCHAR2,
  X_MODE in VARCHAR2 default 'R',
  X_ORG_ID IN NUMBER,
  X_POSITIVE_OUTCOME_IND IN VARCHAR2 DEFAULT 'N'
  ) as
    cursor C is select ROWID from IGS_PR_OU_TYPE_ALL
      where PROGRESSION_OUTCOME_TYPE = X_PROGRESSION_OUTCOME_TYPE;

Line: 347


    X_LAST_UPDATE_DATE DATE;

Line: 348


    X_LAST_UPDATED_BY NUMBER;

Line: 349


    X_LAST_UPDATE_LOGIN NUMBER;

Line: 351


  X_LAST_UPDATE_DATE := SYSDATE;

Line: 353


    X_LAST_UPDATED_BY := 1;

Line: 354


    X_LAST_UPDATE_LOGIN := 0;

Line: 356


    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 357


    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 360


    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 361


    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 370


    p_action => 'INSERT',
    x_rowid => x_rowid,
    x_progression_outcome_type => x_progression_outcome_type,
    x_s_progression_outcome_type => x_s_progression_outcome_type,
    x_description => x_description,
    x_encumbrance_type => x_encumbrance_type,
    x_dflt_restricted_enrolment_cp => x_dflt_restricted_enrolment_cp,
    x_dflt_restricted_att_type => x_dflt_restricted_att_type,
    x_closed_ind => nvl( x_closed_ind,'N'),
    x_comments => x_comments,
    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_positive_outcome_ind => x_positive_outcome_ind
  );

Line: 388


  insert into IGS_PR_OU_TYPE_ALL (
    PROGRESSION_OUTCOME_TYPE,
    S_PROGRESSION_OUTCOME_TYPE,
    DESCRIPTION,
    ENCUMBRANCE_TYPE,
    DFLT_RESTRICTED_ENROLMENT_CP,
    DFLT_RESTRICTED_ATT_TYPE,
    CLOSED_IND,
    COMMENTS,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    ORG_ID,
    POSITIVE_OUTCOME_IND
  ) values (
    NEW_REFERENCES.PROGRESSION_OUTCOME_TYPE,
    NEW_REFERENCES.S_PROGRESSION_OUTCOME_TYPE,
    NEW_REFERENCES.DESCRIPTION,
    NEW_REFERENCES.ENCUMBRANCE_TYPE,
    NEW_REFERENCES.DFLT_RESTRICTED_ENROLMENT_CP,
    NEW_REFERENCES.DFLT_RESTRICTED_ATT_TYPE,
    NEW_REFERENCES.CLOSED_IND,
    NEW_REFERENCES.COMMENTS,
    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.POSITIVE_OUTCOME_IND
  );

Line: 429


end INSERT_ROW;

Line: 443


  cursor c1 is select
      S_PROGRESSION_OUTCOME_TYPE,
      DESCRIPTION,
      ENCUMBRANCE_TYPE,
      DFLT_RESTRICTED_ENROLMENT_CP,
      DFLT_RESTRICTED_ATT_TYPE,
      CLOSED_IND,
      COMMENTS
    from IGS_PR_OU_TYPE_ALL
    where ROWID = X_ROWID for update nowait;

Line: 459


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

Line: 492


procedure UPDATE_ROW (
  X_ROWID in VARCHAR2,
  X_PROGRESSION_OUTCOME_TYPE in VARCHAR2,
  X_S_PROGRESSION_OUTCOME_TYPE in VARCHAR2,
  X_DESCRIPTION in VARCHAR2,
  X_ENCUMBRANCE_TYPE in VARCHAR2,
  X_DFLT_RESTRICTED_ENROLMENT_CP in NUMBER,
  X_DFLT_RESTRICTED_ATT_TYPE in VARCHAR2,
  X_CLOSED_IND in VARCHAR2,
  X_COMMENTS in VARCHAR2,
  X_MODE in VARCHAR2 default 'R',
  X_POSITIVE_OUTCOME_IND IN VARCHAR2 DEFAULT 'N'
  ) as
    X_LAST_UPDATE_DATE DATE;

Line: 506


    X_LAST_UPDATED_BY NUMBER;

Line: 507


    X_LAST_UPDATE_LOGIN NUMBER;

Line: 509


  X_LAST_UPDATE_DATE := SYSDATE;

Line: 511


    X_LAST_UPDATED_BY := 1;

Line: 512


    X_LAST_UPDATE_LOGIN := 0;

Line: 514


    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 515


    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 518


    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 519


    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 528


    p_action => 'UPDATE',
    x_rowid => x_rowid,
    x_progression_outcome_type => x_progression_outcome_type,
    x_s_progression_outcome_type => x_s_progression_outcome_type,
    x_description => x_description,
    x_encumbrance_type => x_encumbrance_type,
    x_dflt_restricted_enrolment_cp => x_dflt_restricted_enrolment_cp,
    x_dflt_restricted_att_type => x_dflt_restricted_att_type,
    x_closed_ind => x_closed_ind,
    x_comments => x_comments,
    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_positive_outcome_ind => x_positive_outcome_ind
  );

Line: 546


  update IGS_PR_OU_TYPE_ALL set
    S_PROGRESSION_OUTCOME_TYPE = NEW_REFERENCES.S_PROGRESSION_OUTCOME_TYPE,
    DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
    ENCUMBRANCE_TYPE = NEW_REFERENCES.ENCUMBRANCE_TYPE,
    DFLT_RESTRICTED_ENROLMENT_CP = NEW_REFERENCES.DFLT_RESTRICTED_ENROLMENT_CP,
    DFLT_RESTRICTED_ATT_TYPE = NEW_REFERENCES.DFLT_RESTRICTED_ATT_TYPE,
    CLOSED_IND = NEW_REFERENCES.CLOSED_IND,
    COMMENTS = NEW_REFERENCES.COMMENTS,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
    POSITIVE_OUTCOME_IND = X_POSITIVE_OUTCOME_IND
  where ROWID = X_ROWID
  ;

Line: 563


end UPDATE_ROW;

Line: 579


  cursor c1 is select rowid from IGS_PR_OU_TYPE_ALL
     where PROGRESSION_OUTCOME_TYPE = X_PROGRESSION_OUTCOME_TYPE
  ;

Line: 587


    INSERT_ROW (
     X_ROWID,
     X_PROGRESSION_OUTCOME_TYPE,
     X_S_PROGRESSION_OUTCOME_TYPE,
     X_DESCRIPTION,
     X_ENCUMBRANCE_TYPE,
     X_DFLT_RESTRICTED_ENROLMENT_CP,
     X_DFLT_RESTRICTED_ATT_TYPE,
     X_CLOSED_IND,
     X_COMMENTS,
     X_MODE,
     X_ORG_ID,
     X_POSITIVE_OUTCOME_IND
     );

Line: 604


  UPDATE_ROW (
   X_ROWID,
   X_PROGRESSION_OUTCOME_TYPE,
   X_S_PROGRESSION_OUTCOME_TYPE,
   X_DESCRIPTION,
   X_ENCUMBRANCE_TYPE,
   X_DFLT_RESTRICTED_ENROLMENT_CP,
   X_DFLT_RESTRICTED_ATT_TYPE,
   X_CLOSED_IND,
   X_COMMENTS,
   X_MODE,
   X_POSITIVE_OUTCOME_IND);

Line: 618


/*Removed procedure Delete_row for Records Locking Bug 2784198 */

PROCEDURE  Check_Constraints (
    Column_Name IN VARCHAR2 DEFAULT NULL,
    Column_Value IN VARCHAR2 DEFAULT NULL
  ) AS

BEGIN
  IF Column_Name is null THEN
    NULL;