APPS.IGS_ST_GVT_SPSHT_CTL_PKG SQL Statements

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

Line: 17

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

Line: 35

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

Line: 50

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

Line: 57

    new_references.last_update_date := x_last_update_date;

Line: 58

    new_references.last_updated_by := x_last_updated_by;

Line: 59

    new_references.last_update_login := x_last_update_login;

Line: 63

PROCEDURE AfterRowInsertUpdate1(
    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: 90

  END AfterRowInsertUpdate1;

Line: 103

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

Line: 168

      SELECT   rowid
      FROM     IGS_ST_GVT_SPSHT_CTL_ALL
      WHERE    submission_yr = x_submission_yr
      AND      submission_number = x_submission_number
      FOR UPDATE NOWAIT;

Line: 195

      SELECT   rowid
      FROM     IGS_ST_GVT_SPSHT_CTL_ALL
      WHERE    ess_snapshot_dt_time = x_ess_snapshot_dt_time;

Line: 258

    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_submission_yr,
      x_submission_number,
      x_ess_snapshot_dt_time,
      x_completion_dt,
      x_org_id,
      x_creation_date,
      x_created_by,
      x_last_update_date,
      x_last_updated_by,
      x_last_update_login
    );

Line: 279

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

Line: 293

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

Line: 299

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

Line: 303

    ELSIF (p_action = 'VALIDATE_INSERT') THEN
      -- Call all the procedures related to Before Delete.
      IF GET_PK_FOR_VALIDATION(
        new_references.submission_yr,
        new_references.submission_number
       )THEN
        FND_MESSAGE.SET_NAME('IGS','IGS_GE_MULTI_ORG_DUP_REC');

Line: 314

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

Line: 317

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

Line: 332

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

Line: 335

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

Line: 343

procedure INSERT_ROW (
  X_ROWID in out NOCOPY VARCHAR2,
  X_SUBMISSION_YR in NUMBER,
  X_SUBMISSION_NUMBER in NUMBER,
  X_ESS_SNAPSHOT_DT_TIME in DATE,
  X_COMPLETION_DT in DATE,
  x_org_id IN NUMBER,
  X_MODE in VARCHAR2 default 'R'
  ) AS
    cursor C is select ROWID from IGS_ST_GVT_SPSHT_CTL_ALL
      where SUBMISSION_YR = X_SUBMISSION_YR
      and SUBMISSION_NUMBER = X_SUBMISSION_NUMBER;

Line: 355

    X_LAST_UPDATE_DATE DATE;

Line: 356

    X_LAST_UPDATED_BY NUMBER;

Line: 357

    X_LAST_UPDATE_LOGIN NUMBER;

Line: 361

    X_PROGRAM_UPDATE_DATE DATE;

Line: 363

  X_LAST_UPDATE_DATE := SYSDATE;

Line: 365

    X_LAST_UPDATED_BY := 1;

Line: 366

    X_LAST_UPDATE_LOGIN := 0;

Line: 368

    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 369

    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 372

    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 373

    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 383

      X_PROGRAM_UPDATE_DATE := NULL;

Line: 385

      X_PROGRAM_UPDATE_DATE := SYSDATE;

Line: 394

    p_action =>'INSERT',
    x_rowid =>X_ROWID,
    x_submission_yr => X_SUBMISSION_YR,
    x_submission_number => X_SUBMISSION_NUMBER,
    x_ess_snapshot_dt_time => X_ESS_SNAPSHOT_DT_TIME,
    x_completion_dt => X_COMPLETION_DT,
    x_org_id => igs_ge_gen_003.get_org_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: 408

  insert into IGS_ST_GVT_SPSHT_CTL_ALL (
    SUBMISSION_YR,
    SUBMISSION_NUMBER,
    ESS_SNAPSHOT_DT_TIME,
    COMPLETION_DT,
    ORG_ID,
    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.SUBMISSION_YR,
    NEW_REFERENCES.SUBMISSION_NUMBER,
    NEW_REFERENCES.ESS_SNAPSHOT_DT_TIME,
    NEW_REFERENCES.COMPLETION_DT,
    NEW_REFERENCES.ORG_ID,
    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: 449

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

Line: 453

end INSERT_ROW;

Line: 462

  cursor c1 is select
      ESS_SNAPSHOT_DT_TIME,
      COMPLETION_DT
    from IGS_ST_GVT_SPSHT_CTL_ALL
    where ROWID = X_ROWID
    for update nowait;

Line: 474

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

Line: 498

procedure UPDATE_ROW (
  X_ROWID in VARCHAR2,
  X_SUBMISSION_YR in NUMBER,
  X_SUBMISSION_NUMBER in NUMBER,
  X_ESS_SNAPSHOT_DT_TIME in DATE,
  X_COMPLETION_DT in DATE,
  X_MODE in VARCHAR2 default 'R'
  ) AS
    X_LAST_UPDATE_DATE DATE;

Line: 507

    X_LAST_UPDATED_BY NUMBER;

Line: 508

    X_LAST_UPDATE_LOGIN NUMBER;

Line: 512

    X_PROGRAM_UPDATE_DATE DATE;

Line: 514

  X_LAST_UPDATE_DATE := SYSDATE;

Line: 516

    X_LAST_UPDATED_BY := 1;

Line: 517

    X_LAST_UPDATE_LOGIN := 0;

Line: 519

    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 520

    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 523

    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 524

    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 534

    p_action =>'UPDATE',
    x_rowid =>X_ROWID,
    x_submission_yr => X_SUBMISSION_YR,
    x_submission_number => X_SUBMISSION_NUMBER,
    x_ess_snapshot_dt_time => X_ESS_SNAPSHOT_DT_TIME,
    x_completion_dt => X_COMPLETION_DT,
    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: 556

    X_PROGRAM_UPDATE_DATE := OLD_REFERENCES.PROGRAM_UPDATE_DATE;

Line: 558

    X_PROGRAM_UPDATE_DATE := SYSDATE;

Line: 561

  update IGS_ST_GVT_SPSHT_CTL_ALL set
    ESS_SNAPSHOT_DT_TIME = NEW_REFERENCES.ESS_SNAPSHOT_DT_TIME,
    COMPLETION_DT = NEW_REFERENCES.COMPLETION_DT,
    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: 578

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

Line: 582

end UPDATE_ROW;

Line: 593

  cursor c1 is select rowid from IGS_ST_GVT_SPSHT_CTL_ALL
     where SUBMISSION_YR = X_SUBMISSION_YR
     and SUBMISSION_NUMBER = X_SUBMISSION_NUMBER
  ;

Line: 602

    INSERT_ROW (
     X_ROWID,
     X_SUBMISSION_YR,
     X_SUBMISSION_NUMBER,
     X_ESS_SNAPSHOT_DT_TIME,
     X_COMPLETION_DT,
     X_ORG_ID,
     X_MODE);

Line: 613

  UPDATE_ROW (
   X_ROWID,
   X_SUBMISSION_YR,
   X_SUBMISSION_NUMBER,
   X_ESS_SNAPSHOT_DT_TIME,
   X_COMPLETION_DT,
   X_MODE);

Line: 622

procedure DELETE_ROW (
  X_ROWID in VARCHAR2
) AS
begin

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

Line: 632

  delete from IGS_ST_GVT_SPSHT_CTL_ALL
  where ROWID = X_ROWID;

Line: 639

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

Line: 643

end DELETE_ROW;