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

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

Line: 16


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

Line: 34


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

Line: 36


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

Line: 47


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

Line: 54


    new_references.last_update_date := x_last_update_date;

Line: 55


    new_references.last_updated_by := x_last_updated_by;

Line: 56


    new_references.last_update_login := x_last_update_login;

Line: 60


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


	-- Validate that inserts are allowed
	IF  p_inserting OR p_updating THEN
		--
		-- Cannot make a campus (s_location_type = 'CAMPUS') a child of
		-- an exam centre (s_location_type = 'EXAM_CTR')
		IF  IGS_OR_VAL_LR.assp_val_lr_lr (
						new_references.location_cd,
						new_references.sub_location_cd,
						v_message_name) = FALSE THEN
			Fnd_Message.Set_Name('IGS',v_message_name);

Line: 83


  END BeforeRowInsertUpdate1;

Line: 85


  PROCEDURE AfterRowInsertUpdate2(
    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: 122


                                 /* only if the record has been inserted into the pl/sql table */
	-- Cannot call orgp_val_lr because trigger mayl be mutating.


  END AfterRowInsertUpdate2;

Line: 179


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

Line: 193


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

Line: 207


      SELECT   rowid
      FROM     IGS_AD_LOCATION_REL
      WHERE    location_cd = x_location_cd
      AND      sub_location_cd = x_sub_location_cd
      FOR UPDATE NOWAIT;

Line: 234


      SELECT   rowid
      FROM     IGS_AD_LOCATION_REL
      WHERE    location_cd = x_location_cd
         OR    sub_location_cd = x_location_cd ;

Line: 265


    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_location_cd,
      x_sub_location_cd,
      x_dflt_ind,
      x_creation_date,
      x_created_by,
      x_last_update_date,
      x_last_updated_by,
      x_last_update_login
    );

Line: 284


    IF (p_action = 'INSERT') THEN
      BeforeRowInsertUpdate1 ( p_inserting => TRUE );

Line: 296


    ELSIF (p_action = 'UPDATE') THEN
      BeforeRowInsertUpdate1 ( p_updating => TRUE );

Line: 300


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

Line: 310


    ELSIF (p_action = 'VALIDATE_UPDATE') THEN
	Check_Constraints;

Line: 324


    IF (p_action = 'INSERT') THEN
      AfterRowInsertUpdate2 ( p_inserting => TRUE );

Line: 326


    ELSIF (p_action = 'UPDATE') THEN
      AfterRowInsertUpdate2 ( p_updating => TRUE );

Line: 334


procedure INSERT_ROW (
  X_ROWID in out NOCOPY VARCHAR2,
  X_LOCATION_CD in VARCHAR2,
  X_SUB_LOCATION_CD in VARCHAR2,
  X_DFLT_IND in VARCHAR2,
  X_MODE in VARCHAR2 default 'R'
  ) AS
    cursor C is select ROWID from IGS_AD_LOCATION_REL
      where LOCATION_CD = X_LOCATION_CD
      and SUB_LOCATION_CD = X_SUB_LOCATION_CD;

Line: 344


    X_LAST_UPDATE_DATE DATE;

Line: 345


    X_LAST_UPDATED_BY NUMBER;

Line: 346


    X_LAST_UPDATE_LOGIN NUMBER;

Line: 348


  X_LAST_UPDATE_DATE := SYSDATE;

Line: 350


    X_LAST_UPDATED_BY := 1;

Line: 351


    X_LAST_UPDATE_LOGIN := 0;

Line: 353


    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 354


    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 357


    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 358


    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 368


    p_action=>'INSERT' ,
    x_rowid=>X_ROWID ,
    x_location_cd => X_LOCATION_CD ,
    x_sub_location_cd => X_SUB_LOCATION_CD ,
    x_dflt_ind => NVL(X_DFLT_IND,'N') ,
    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: 381


  insert into IGS_AD_LOCATION_REL (
    LOCATION_CD,
    SUB_LOCATION_CD,
    DFLT_IND,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN
  ) values (
    NEW_REFERENCES.LOCATION_CD,
    NEW_REFERENCES.SUB_LOCATION_CD,
    NEW_REFERENCES.DFLT_IND,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN
  );

Line: 410


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

Line: 414


end INSERT_ROW;

Line: 422


  cursor c1 is select
      DFLT_IND
    from IGS_AD_LOCATION_REL
    WHERE  ROWID = X_ROWID  for update nowait ;

Line: 433


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

Line: 451


procedure UPDATE_ROW (
  X_ROWID in VARCHAR2 ,
  X_LOCATION_CD in VARCHAR2,
  X_SUB_LOCATION_CD in VARCHAR2,
  X_DFLT_IND in VARCHAR2,
  X_MODE in VARCHAR2 default 'R'
  ) AS
    X_LAST_UPDATE_DATE DATE;

Line: 459


    X_LAST_UPDATED_BY NUMBER;

Line: 460


    X_LAST_UPDATE_LOGIN NUMBER;

Line: 462


  X_LAST_UPDATE_DATE := SYSDATE;

Line: 464


    X_LAST_UPDATED_BY := 1;

Line: 465


    X_LAST_UPDATE_LOGIN := 0;

Line: 467


    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 468


    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 471


    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 472


    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 482


    p_action=>'UPDATE' ,
    x_rowid=>X_ROWID ,
    x_location_cd => X_LOCATION_CD ,
    x_sub_location_cd => X_SUB_LOCATION_CD ,
    x_dflt_ind => X_DFLT_IND ,
    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: 495


  update IGS_AD_LOCATION_REL set
    DFLT_IND = NEW_REFERENCES.DFLT_IND,
    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: 507


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

Line: 511


end UPDATE_ROW;

Line: 520


  cursor c1 is select rowid from IGS_AD_LOCATION_REL
     where LOCATION_CD = X_LOCATION_CD
     and SUB_LOCATION_CD = X_SUB_LOCATION_CD
  ;

Line: 530


    INSERT_ROW (
     X_ROWID,
     X_LOCATION_CD,
     X_SUB_LOCATION_CD,
     X_DFLT_IND,
     X_MODE);

Line: 539


  UPDATE_ROW (
   X_ROWID  ,
   X_LOCATION_CD,
   X_SUB_LOCATION_CD,
   X_DFLT_IND,
   X_MODE);

Line: 547


procedure DELETE_ROW (
  X_ROWID in VARCHAR2
) AS
begin

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

Line: 557


  delete from IGS_AD_LOCATION_REL
  where  ROWID = X_ROWID;

Line: 565


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

Line: 569


end DELETE_ROW;