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_APPL_LTR_PHR_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
  ) AS

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

Line: 39


    IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
      Close cur_old_ref_values;

Line: 41


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

Line: 58


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

Line: 65


    new_references.last_update_date := x_last_update_date;

Line: 66


    new_references.last_updated_by := x_last_updated_by;

Line: 67


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


	IF p_inserting OR
	(old_references.letter_parameter_type <> new_references.letter_parameter_type) THEN
		IF IGS_AD_VAL_AALP.corp_val_lpt_closed(new_references.letter_parameter_type,
						v_message_name) = FALSE THEN
			--raise_application_error(-20000,IGS_GE_GEN_002.GENP_GET_MESSAGE(v_message_num));

Line: 104


	IF p_inserting OR
	(old_references.phrase_cd <> new_references.phrase_cd) THEN
		IF IGS_AD_VAL_AALP.corp_val_ltp_closed(new_references.phrase_cd,
						v_message_name) = FALSE THEN
			--raise_application_error(-20000,IGS_GE_GEN_002.GENP_GET_MESSAGE(v_message_num));

Line: 132


  END BeforeRowInsertUpdate1;

Line: 155


        FND_MESSAGE.SET_NAME('FND','FORM_RECORD_DELETED');

Line: 168


        FND_MESSAGE.SET_NAME('FND','FORM_RECORD_DELETED');

Line: 181


        FND_MESSAGE.SET_NAME('FND','FORM_RECORD_DELETED');

Line: 199


      SELECT   rowid
      FROM     IGS_AD_APPL_LTR_PHR
      WHERE    person_id = x_person_id
      AND      admission_appl_number = x_admission_appl_number
      AND      correspondence_type = x_correspondence_type
      AND      aal_sequence_number = x_aal_sequence_number
      AND      sequence_number = x_sequence_number
      FOR UPDATE NOWAIT;

Line: 232


      SELECT   rowid
      FROM     IGS_AD_APPL_LTR_PHR
      WHERE    person_id = x_person_id
      AND      admission_appl_number = x_admission_appl_number
      AND      correspondence_type = x_correspondence_type
      AND      aal_sequence_number = x_sequence_number ;

Line: 261


      SELECT   rowid
      FROM     IGS_AD_APPL_LTR_PHR
      WHERE    letter_parameter_type = x_letter_parameter_type ;

Line: 287


      SELECT   rowid
      FROM     IGS_AD_APPL_LTR_PHR
      WHERE    phrase_cd = x_phrase_cd ;

Line: 381


    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_person_id,
      x_admission_appl_number,
      x_correspondence_type,
      x_aal_sequence_number,
      x_sequence_number,
      x_phrase_cd,
      x_phrase_order_number,
      x_letter_parameter_type,
      x_phrase_text,
      x_creation_date,
      x_created_by,
      x_last_update_date,
      x_last_updated_by,
      x_last_update_login
    );

Line: 405


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

Line: 421


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

Line: 426


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

Line: 429


    ELSIF (p_action = 'VALIDATE_INSERT') THEN
      -- Call all the procedures related to Before Delete.
      IF GET_PK_FOR_VALIDATION(
        new_references.person_id,
        new_references.admission_appl_number,
        new_references.correspondence_type,
        new_references.aal_sequence_number,
    	  new_references.sequence_number
       )THEN
        FND_MESSAGE.SET_NAME('IGS','IGS_GE_RECORD_ALREADY_EXISTS');

Line: 443


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

Line: 459


procedure INSERT_ROW (
  X_ROWID in out NOCOPY VARCHAR2,
  X_PERSON_ID in NUMBER,
  X_ADMISSION_APPL_NUMBER in NUMBER,
  X_CORRESPONDENCE_TYPE in VARCHAR2,
  X_AAL_SEQUENCE_NUMBER in NUMBER,
  X_SEQUENCE_NUMBER in NUMBER,
  X_PHRASE_CD in VARCHAR2,
  X_PHRASE_ORDER_NUMBER in NUMBER,
  X_LETTER_PARAMETER_TYPE in VARCHAR2,
  X_PHRASE_TEXT in VARCHAR2,
  X_MODE in VARCHAR2 default 'R'
  ) as

    cursor C is select ROWID from IGS_AD_APPL_LTR_PHR
      where PERSON_ID = X_PERSON_ID
      and ADMISSION_APPL_NUMBER = X_ADMISSION_APPL_NUMBER
      and CORRESPONDENCE_TYPE = X_CORRESPONDENCE_TYPE
      and AAL_SEQUENCE_NUMBER = X_AAL_SEQUENCE_NUMBER
      and SEQUENCE_NUMBER = X_SEQUENCE_NUMBER;

Line: 479


    X_LAST_UPDATE_DATE DATE;

Line: 480


    X_LAST_UPDATED_BY NUMBER;

Line: 481


    X_LAST_UPDATE_LOGIN NUMBER;

Line: 484


  X_LAST_UPDATE_DATE := SYSDATE;

Line: 486


    X_LAST_UPDATED_BY := 1;

Line: 487


    X_LAST_UPDATE_LOGIN := 0;

Line: 489


    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 490


    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 493


    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 494


    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 504


    p_action => 'INSERT',
    x_rowid  => X_ROWID,
    x_person_id=> X_PERSON_ID,
    x_admission_appl_number=> X_ADMISSION_APPL_NUMBER,
    x_correspondence_type =>X_CORRESPONDENCE_TYPE,
    x_aal_sequence_number =>X_AAL_SEQUENCE_NUMBER,
    x_sequence_number =>X_SEQUENCE_NUMBER,
    x_phrase_cd =>X_PHRASE_CD,
    x_phrase_order_number =>X_PHRASE_ORDER_NUMBER,
    x_letter_parameter_type =>X_LETTER_PARAMETER_TYPE,
    x_phrase_text =>X_PHRASE_TEXT,
    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: 522


  insert into IGS_AD_APPL_LTR_PHR (
    PERSON_ID,
    ADMISSION_APPL_NUMBER,
    CORRESPONDENCE_TYPE,
    AAL_SEQUENCE_NUMBER,
    SEQUENCE_NUMBER,
    PHRASE_CD,
    PHRASE_ORDER_NUMBER,
    LETTER_PARAMETER_TYPE,
    PHRASE_TEXT,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN
  ) values (
    NEW_REFERENCES.PERSON_ID,
    NEW_REFERENCES.ADMISSION_APPL_NUMBER,
    NEW_REFERENCES.CORRESPONDENCE_TYPE,
    NEW_REFERENCES.AAL_SEQUENCE_NUMBER,
    NEW_REFERENCES.SEQUENCE_NUMBER,
    NEW_REFERENCES.PHRASE_CD,
    NEW_REFERENCES.PHRASE_ORDER_NUMBER,
    NEW_REFERENCES.LETTER_PARAMETER_TYPE,
    NEW_REFERENCES.PHRASE_TEXT,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN
  );

Line: 562


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

Line: 566


end INSERT_ROW;

Line: 580


  cursor c1 is select
      PHRASE_CD,
      PHRASE_ORDER_NUMBER,
      LETTER_PARAMETER_TYPE,
      PHRASE_TEXT
    from IGS_AD_APPL_LTR_PHR
    where ROWID = X_ROWID
    for update nowait;

Line: 595


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

Line: 622


procedure UPDATE_ROW (
  X_ROWID in VARCHAR2,
  X_PERSON_ID in NUMBER,
  X_ADMISSION_APPL_NUMBER in NUMBER,
  X_CORRESPONDENCE_TYPE in VARCHAR2,
  X_AAL_SEQUENCE_NUMBER in NUMBER,
  X_SEQUENCE_NUMBER in NUMBER,
  X_PHRASE_CD in VARCHAR2,
  X_PHRASE_ORDER_NUMBER in NUMBER,
  X_LETTER_PARAMETER_TYPE in VARCHAR2,
  X_PHRASE_TEXT in VARCHAR2,
  X_MODE in VARCHAR2 default 'R'
  ) as
    X_LAST_UPDATE_DATE DATE;

Line: 636


    X_LAST_UPDATED_BY NUMBER;

Line: 637


    X_LAST_UPDATE_LOGIN NUMBER;

Line: 639


  X_LAST_UPDATE_DATE := SYSDATE;

Line: 641


    X_LAST_UPDATED_BY := 1;

Line: 642


    X_LAST_UPDATE_LOGIN := 0;

Line: 644


    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 645


    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 648


    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 649


    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 658


    p_action => 'UPDATE',
    x_rowid  => X_ROWID,
    x_person_id=> X_PERSON_ID,
    x_admission_appl_number=> X_ADMISSION_APPL_NUMBER,
    x_correspondence_type =>X_CORRESPONDENCE_TYPE,
    x_aal_sequence_number =>X_AAL_SEQUENCE_NUMBER,
    x_sequence_number =>X_SEQUENCE_NUMBER,
    x_phrase_cd =>X_PHRASE_CD,
    x_phrase_order_number =>X_PHRASE_ORDER_NUMBER,
    x_letter_parameter_type =>X_LETTER_PARAMETER_TYPE,
    x_phrase_text =>X_PHRASE_TEXT,
    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: 677


  update IGS_AD_APPL_LTR_PHR set
    PHRASE_CD = NEW_REFERENCES.PHRASE_CD,
    PHRASE_ORDER_NUMBER = NEW_REFERENCES.PHRASE_ORDER_NUMBER,
    LETTER_PARAMETER_TYPE = NEW_REFERENCES.LETTER_PARAMETER_TYPE,
    PHRASE_TEXT = NEW_REFERENCES.PHRASE_TEXT,
    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: 691


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

Line: 694


end UPDATE_ROW;

Line: 709


  cursor c1 is select rowid from IGS_AD_APPL_LTR_PHR
     where PERSON_ID = X_PERSON_ID
     and ADMISSION_APPL_NUMBER = X_ADMISSION_APPL_NUMBER
     and CORRESPONDENCE_TYPE = X_CORRESPONDENCE_TYPE
     and AAL_SEQUENCE_NUMBER = X_AAL_SEQUENCE_NUMBER
     and SEQUENCE_NUMBER = X_SEQUENCE_NUMBER
  ;

Line: 721


    INSERT_ROW (
     X_ROWID,
     X_PERSON_ID,
     X_ADMISSION_APPL_NUMBER,
     X_CORRESPONDENCE_TYPE,
     X_AAL_SEQUENCE_NUMBER,
     X_SEQUENCE_NUMBER,
     X_PHRASE_CD,
     X_PHRASE_ORDER_NUMBER,
     X_LETTER_PARAMETER_TYPE,
     X_PHRASE_TEXT,
     X_MODE);

Line: 736


  UPDATE_ROW (
   X_ROWID,
   X_PERSON_ID,
   X_ADMISSION_APPL_NUMBER,
   X_CORRESPONDENCE_TYPE,
   X_AAL_SEQUENCE_NUMBER,
   X_SEQUENCE_NUMBER,
   X_PHRASE_CD,
   X_PHRASE_ORDER_NUMBER,
   X_LETTER_PARAMETER_TYPE,
   X_PHRASE_TEXT,
   X_MODE);

Line: 750


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

Line: 758


  delete from IGS_AD_APPL_LTR_PHR
  where ROWID = X_ROWID;

Line: 764


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

Line: 767


end delete_row;