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

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

Line: 18


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

Line: 36


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

Line: 38


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

Line: 51


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

Line: 58


    new_references.last_update_date := x_last_update_date;

Line: 59


    new_references.last_updated_by := x_last_updated_by;

Line: 60


    new_references.last_update_login := x_last_update_login;

Line: 64


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


	IF p_inserting OR p_updating THEN
		v_cal_type := new_references.cal_type;

Line: 80


	-- Validate if insert, update or delete is allowed.
	IF IGS_EN_VAL_DLA.stap_val_ci_status (
			v_cal_type,
			v_ci_sequence_number,
			v_message_name) = FALSE THEN
			Fnd_Message.Set_Name('IGS',v_message_name);

Line: 89


	-- Validate that inserts/updates are allowed
	IF  p_inserting OR p_updating THEN
	    IF	IGS_EN_VAL_DLA.ENRP_VAL_DLA_CAT_LD(new_references.cal_type
						,v_message_name) = FALSE THEN
					Fnd_Message.Set_Name('IGS',v_message_name);

Line: 106


  END BeforeRowInsertUpdateDelete1;

Line: 179


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

Line: 194


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

Line: 233


      SELECT   rowid
      FROM     IGS_ST_DFT_LOAD_APPO
      WHERE    cal_type = x_cal_type
      AND      ci_sequence_number = x_ci_sequence_number
      AND      teach_cal_type = x_teach_cal_type
      FOR UPDATE NOWAIT;

Line: 261


      SELECT   rowid
      FROM     IGS_ST_DFT_LOAD_APPO
      WHERE    teach_cal_type = x_cal_type ;

Line: 288


      SELECT   rowid
      FROM     IGS_ST_DFT_LOAD_APPO
      WHERE    cal_type = x_cal_type
      AND      ci_sequence_number = x_sequence_number ;

Line: 320


    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_cal_type,
      x_ci_sequence_number,
      x_teach_cal_type,
      x_percentage,
      x_second_percentage,
      x_creation_date,
      x_created_by,
      x_last_update_date,
      x_last_updated_by,
      x_last_update_login
    );

Line: 341


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

Line: 355


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

Line: 360


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

Line: 364


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

Line: 375


	 ELSIF (p_action = 'VALIDATE_UPDATE') THEN
       Check_Constraints;

Line: 378


	 ELSIF (p_action = 'VALIDATE_DELETE') THEN
      Check_Child_Existance;

Line: 398


procedure INSERT_ROW (
  X_ROWID in out NOCOPY VARCHAR2,
  X_CAL_TYPE in VARCHAR2,
  X_CI_SEQUENCE_NUMBER in NUMBER,
  X_TEACH_CAL_TYPE in VARCHAR2,
  X_PERCENTAGE in NUMBER,
  X_SECOND_PERCENTAGE in NUMBER,
  X_MODE in VARCHAR2 default 'R'
  ) as
    cursor C is select ROWID from IGS_ST_DFT_LOAD_APPO
      where CAL_TYPE = X_CAL_TYPE
      and CI_SEQUENCE_NUMBER = X_CI_SEQUENCE_NUMBER
      and TEACH_CAL_TYPE = X_TEACH_CAL_TYPE;

Line: 411


    X_LAST_UPDATE_DATE DATE;

Line: 412


    X_LAST_UPDATED_BY NUMBER;

Line: 413


    X_LAST_UPDATE_LOGIN NUMBER;

Line: 415


  X_LAST_UPDATE_DATE := SYSDATE;

Line: 417


    X_LAST_UPDATED_BY := 1;

Line: 418


    X_LAST_UPDATE_LOGIN := 0;

Line: 420


    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 421


    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 424


    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 425


    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 436


    p_action=>'INSERT' ,
    x_rowid=>X_ROWID ,
    x_cal_type => X_CAL_TYPE,
    x_ci_sequence_number => X_CI_SEQUENCE_NUMBER ,
    x_teach_cal_type => X_TEACH_CAL_TYPE,
    x_percentage => NVL(X_PERCENTAGE,100) ,
    x_second_percentage => X_SECOND_PERCENTAGE ,
    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: 450


  insert into IGS_ST_DFT_LOAD_APPO (
    CAL_TYPE,
    CI_SEQUENCE_NUMBER,
    TEACH_CAL_TYPE,
    PERCENTAGE,
    SECOND_PERCENTAGE,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN
  ) values (
    NEW_REFERENCES.CAL_TYPE,
    NEW_REFERENCES.CI_SEQUENCE_NUMBER,
    NEW_REFERENCES.TEACH_CAL_TYPE,
    NEW_REFERENCES.PERCENTAGE,
    NEW_REFERENCES.SECOND_PERCENTAGE,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN
  );

Line: 483


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

Line: 487


end INSERT_ROW;

Line: 497


  cursor c1 is select
      PERCENTAGE,
      SECOND_PERCENTAGE
    from IGS_ST_DFT_LOAD_APPO
    where ROWID = X_ROWID for update nowait;

Line: 509


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

Line: 530


procedure UPDATE_ROW (
  X_ROWID in VARCHAR2,
  X_CAL_TYPE in VARCHAR2,
  X_CI_SEQUENCE_NUMBER in NUMBER,
  X_TEACH_CAL_TYPE in VARCHAR2,
  X_PERCENTAGE in NUMBER,
  X_SECOND_PERCENTAGE in NUMBER,
  X_MODE in VARCHAR2 default 'R'
  ) as
    X_LAST_UPDATE_DATE DATE;

Line: 540


    X_LAST_UPDATED_BY NUMBER;

Line: 541


    X_LAST_UPDATE_LOGIN NUMBER;

Line: 543


  X_LAST_UPDATE_DATE := SYSDATE;

Line: 545


    X_LAST_UPDATED_BY := 1;

Line: 546


    X_LAST_UPDATE_LOGIN := 0;

Line: 548


    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 549


    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 552


    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 553


    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 563


    p_action=>'UPDATE' ,
    x_rowid=>X_ROWID ,
    x_cal_type => X_CAL_TYPE,
    x_ci_sequence_number => X_CI_SEQUENCE_NUMBER ,
    x_teach_cal_type => X_TEACH_CAL_TYPE,
    x_percentage => X_PERCENTAGE ,
    x_second_percentage => X_SECOND_PERCENTAGE ,
    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: 578


  update IGS_ST_DFT_LOAD_APPO set
    PERCENTAGE = NEW_REFERENCES.PERCENTAGE,
    SECOND_PERCENTAGE = NEW_REFERENCES.SECOND_PERCENTAGE,
    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: 591


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

Line: 596


end UPDATE_ROW;

Line: 607


  cursor c1 is select rowid from IGS_ST_DFT_LOAD_APPO
     where CAL_TYPE = X_CAL_TYPE
     and CI_SEQUENCE_NUMBER = X_CI_SEQUENCE_NUMBER
     and TEACH_CAL_TYPE = X_TEACH_CAL_TYPE
  ;

Line: 618


    INSERT_ROW (
     X_ROWID,
     X_CAL_TYPE,
     X_CI_SEQUENCE_NUMBER,
     X_TEACH_CAL_TYPE,
     X_PERCENTAGE,
     X_SECOND_PERCENTAGE,
     X_MODE);

Line: 629


  UPDATE_ROW (
   X_ROWID,
   X_CAL_TYPE,
   X_CI_SEQUENCE_NUMBER,
   X_TEACH_CAL_TYPE,
   X_PERCENTAGE,
   X_SECOND_PERCENTAGE,
   X_MODE);

Line: 639


procedure DELETE_ROW (
   X_ROWID in VARCHAR2
) as
begin

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

Line: 649


  delete from IGS_ST_DFT_LOAD_APPO
  where ROWID = X_ROWID;

Line: 657


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

Line: 662


end DELETE_ROW;