APPS.IGS_PE_LANGUAGE_CD_PKG SQL Statements

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

Line: 35

    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_PE_LANGUAGE_CD

      WHERE    rowid = x_rowid;

Line: 71

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

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

Line: 99

    IF (p_action = 'UPDATE') THEN

      new_references.creation_date := old_references.creation_date;

Line: 113

    new_references.last_update_date := x_last_update_date;

Line: 115

    new_references.last_updated_by := x_last_updated_by;

Line: 117

    new_references.last_update_login := x_last_update_login;

Line: 125

PROCEDURE BeforeRowInsertUpdateDelete1(

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

	IF p_inserting OR ((old_references.govt_language_cd <> new_references.govt_language_cd) OR

			 (old_references.closed_ind = 'Y' AND new_references.closed_ind = 'N')) THEN

		IF IGS_EN_VAL_LC.enrp_val_lang_govt (

				new_references.govt_language_cd,

				v_message_name) = FALSE THEN

			 Fnd_Message.Set_Name('IGS', v_message_name);

Line: 183

  END BeforeRowInsertUpdateDelete1;

Line: 239

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

Line: 265

      SELECT   rowid

      FROM     IGS_PE_LANGUAGE_CD

      WHERE    language_cd = x_language_cd

      FOR UPDATE NOWAIT;

Line: 301

      SELECT   rowid

      FROM     IGS_PE_LANGUAGE_CD

      WHERE    govt_language_cd = x_govt_language_cd ;

Line: 361

    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_language_cd,

      x_govt_language_cd,

      x_description,

      x_closed_ind,

      x_notes,

      x_creation_date,

      x_created_by,

      x_last_update_date,

      x_last_updated_by,

      x_last_update_login

    );  IF (p_action = 'INSERT') THEN

Line: 401

     BeforeRowInsertUpdateDelete1 ( p_inserting => TRUE );

Line: 411

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

Line: 418

 ELSIF (p_action = 'DELETE') THEN
       -- Call all the procedures related to Before Delete.
      BeforeRowInsertUpdateDelete1 ( p_deleting => TRUE );

Line: 422

 ELSIF (p_action = 'VALIDATE_INSERT') THEN
      IF  Get_PK_For_Validation (
           new_references.language_cd  ) THEN
         Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');

Line: 431

 ELSIF (p_action = 'VALIDATE_UPDATE') THEN

       Check_Constraints; -- if procedure present

Line: 435

ELSIF (p_action = 'VALIDATE_DELETE') THEN
      Check_Child_Existance; -- if procedure present

Line: 455

    IF (p_action = 'INSERT') THEN

      -- Call all the procedures related to After Insert.

      Null;

Line: 461

    ELSIF (p_action = 'UPDATE') THEN

      -- Call all the procedures related to After Update.

      Null;

Line: 467

    ELSIF (p_action = 'DELETE') THEN

      -- Call all the procedures related to After Delete.

      Null;

Line: 480

procedure INSERT_ROW (
  X_ROWID in out NOCOPY VARCHAR2,
  X_LANGUAGE_CD in VARCHAR2,
  X_GOVT_LANGUAGE_CD in NUMBER,
  X_DESCRIPTION in VARCHAR2,
  X_CLOSED_IND in VARCHAR2,
  X_NOTES in VARCHAR2,
  X_MODE in VARCHAR2 default 'R'
  ) AS
    cursor C is select ROWID from IGS_PE_LANGUAGE_CD
      where LANGUAGE_CD = X_LANGUAGE_CD;

Line: 491

    X_LAST_UPDATE_DATE DATE;

Line: 492

    X_LAST_UPDATED_BY NUMBER;

Line: 493

    X_LAST_UPDATE_LOGIN NUMBER;

Line: 495

  X_LAST_UPDATE_DATE := SYSDATE;

Line: 497

    X_LAST_UPDATED_BY := 1;

Line: 498

    X_LAST_UPDATE_LOGIN := 0;

Line: 500

    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 501

    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 504

    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 505

    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 516

  p_action=>'INSERT',

  x_rowid=>X_ROWID,

  x_closed_ind=> NVL(X_CLOSED_IND,'N'),

  x_description=>X_DESCRIPTION,

  x_govt_language_cd=>X_GOVT_LANGUAGE_CD,

  x_language_cd=>X_LANGUAGE_CD,

  x_notes=>X_NOTES,

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

  insert into IGS_PE_LANGUAGE_CD (
    LANGUAGE_CD,
    GOVT_LANGUAGE_CD,
    DESCRIPTION,
    CLOSED_IND,
    NOTES,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN
  ) values (
    NEW_REFERENCES.LANGUAGE_CD,
    NEW_REFERENCES.GOVT_LANGUAGE_CD,
    NEW_REFERENCES.DESCRIPTION,
    NEW_REFERENCES.CLOSED_IND,
    NEW_REFERENCES.NOTES,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN
  );

Line: 574

  p_action => 'INSERT',

  x_rowid => X_ROWID

  );

Line: 579

end INSERT_ROW;

Line: 590

  cursor c1 is select
      GOVT_LANGUAGE_CD,
      DESCRIPTION,
      CLOSED_IND,
      NOTES
    from IGS_PE_LANGUAGE_CD
    where ROWID = X_ROWID
    for update nowait;

Line: 604

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

Line: 627

procedure UPDATE_ROW (

  X_ROWID in VARCHAR2,
  X_LANGUAGE_CD in VARCHAR2,
  X_GOVT_LANGUAGE_CD in NUMBER,
  X_DESCRIPTION in VARCHAR2,
  X_CLOSED_IND in VARCHAR2,
  X_NOTES in VARCHAR2,
  X_MODE in VARCHAR2 default 'R'
  ) AS
    X_LAST_UPDATE_DATE DATE;

Line: 638

    X_LAST_UPDATED_BY NUMBER;

Line: 639

    X_LAST_UPDATE_LOGIN NUMBER;

Line: 641

  X_LAST_UPDATE_DATE := SYSDATE;

Line: 643

    X_LAST_UPDATED_BY := 1;

Line: 644

    X_LAST_UPDATE_LOGIN := 0;

Line: 646

    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 647

    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 650

    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 651

    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 662

  p_action=>'UPDATE',

  x_rowid=>X_ROWID,

  x_closed_ind=>X_CLOSED_IND,

  x_description=>X_DESCRIPTION,

  x_govt_language_cd=>X_GOVT_LANGUAGE_CD,

  x_language_cd=>X_LANGUAGE_CD,

  x_notes=>X_NOTES,

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

  update IGS_PE_LANGUAGE_CD set
    GOVT_LANGUAGE_CD = NEW_REFERENCES.GOVT_LANGUAGE_CD,
    DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
    CLOSED_IND = NEW_REFERENCES.CLOSED_IND,
    NOTES = NEW_REFERENCES.NOTES,
    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: 705

  p_action => 'UPDATE',

  x_rowid => X_ROWID

  );

Line: 710

end UPDATE_ROW;

Line: 721

  cursor c1 is select rowid from IGS_PE_LANGUAGE_CD
     where LANGUAGE_CD = X_LANGUAGE_CD
  ;

Line: 730

    INSERT_ROW (
     X_ROWID,
     X_LANGUAGE_CD,
     X_GOVT_LANGUAGE_CD,
     X_DESCRIPTION,
     X_CLOSED_IND,
     X_NOTES,
     X_MODE);

Line: 741

  UPDATE_ROW (

   X_ROWID,
   X_LANGUAGE_CD,
   X_GOVT_LANGUAGE_CD,
   X_DESCRIPTION,
   X_CLOSED_IND,
   X_NOTES,
   X_MODE);

Line: 752

procedure DELETE_ROW (
  X_ROWID in VARCHAR2
) AS
begin

Before_DML(

  p_action => 'DELETE',

  x_rowid => X_ROWID

  );

Line: 764

  delete from IGS_PE_LANGUAGE_CD
  where ROWID = X_ROWID;

Line: 772

  p_action => 'DELETE',

  x_rowid => X_ROWID

  );

Line: 779

end DELETE_ROW;