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.AHL_SPACE_UNAVAILABLE_PKG SQL Statements

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

Line: 3


procedure INSERT_ROW (
  X_ROWID in out NOCOPY VARCHAR2,
  X_SPACE_UNAVAILABILITY_ID in NUMBER,
  X_ATTRIBUTE13 in VARCHAR2,
  X_ATTRIBUTE14 in VARCHAR2,
  X_ATTRIBUTE15 in VARCHAR2,
  X_SPACE_ID in NUMBER,
  X_START_DATE in DATE,
  X_END_DATE in DATE,
  X_ATTRIBUTE_CATEGORY in VARCHAR2,
  X_ATTRIBUTE1 in VARCHAR2,
  X_ATTRIBUTE2 in VARCHAR2,
  X_ATTRIBUTE3 in VARCHAR2,
  X_ATTRIBUTE4 in VARCHAR2,
  X_ATTRIBUTE5 in VARCHAR2,
  X_ATTRIBUTE6 in VARCHAR2,
  X_ATTRIBUTE7 in VARCHAR2,
  X_ATTRIBUTE11 in VARCHAR2,
  X_ATTRIBUTE9 in VARCHAR2,
  X_OBJECT_VERSION_NUMBER in NUMBER,
  X_ATTRIBUTE12 in VARCHAR2,
  X_ATTRIBUTE8 in VARCHAR2,
  X_ATTRIBUTE10 in VARCHAR2,
  X_DESCRIPTION in VARCHAR2,
  X_CREATION_DATE in DATE,
  X_CREATED_BY in NUMBER,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER
) is
  cursor C is select ROWID from AHL_SPACE_UNAVAILABLE_B
    where SPACE_UNAVAILABILITY_ID = X_SPACE_UNAVAILABILITY_ID
    ;

Line: 37


  insert into AHL_SPACE_UNAVAILABLE_B (
    ATTRIBUTE13,
    ATTRIBUTE14,
    ATTRIBUTE15,
    SPACE_ID,
    START_DATE,
    END_DATE,
    ATTRIBUTE_CATEGORY,
    ATTRIBUTE1,
    ATTRIBUTE2,
    ATTRIBUTE3,
    ATTRIBUTE4,
    ATTRIBUTE5,
    ATTRIBUTE6,
    ATTRIBUTE7,
    ATTRIBUTE11,
    ATTRIBUTE9,
    OBJECT_VERSION_NUMBER,
    ATTRIBUTE12,
    ATTRIBUTE8,
    ATTRIBUTE10,
    SPACE_UNAVAILABILITY_ID,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN
  ) values (
    X_ATTRIBUTE13,
    X_ATTRIBUTE14,
    X_ATTRIBUTE15,
    X_SPACE_ID,
    X_START_DATE,
    X_END_DATE,
    X_ATTRIBUTE_CATEGORY,
    X_ATTRIBUTE1,
    X_ATTRIBUTE2,
    X_ATTRIBUTE3,
    X_ATTRIBUTE4,
    X_ATTRIBUTE5,
    X_ATTRIBUTE6,
    X_ATTRIBUTE7,
    X_ATTRIBUTE11,
    X_ATTRIBUTE9,
    X_OBJECT_VERSION_NUMBER,
    X_ATTRIBUTE12,
    X_ATTRIBUTE8,
    X_ATTRIBUTE10,
    X_SPACE_UNAVAILABILITY_ID,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN
  );

Line: 93


  insert into AHL_SPACE_UNAVAILABLE_TL (
    DESCRIPTION,
    SPACE_UNAVAILABILITY_ID,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_LOGIN,
    LANGUAGE,
    SOURCE_LANG
  ) select
    X_DESCRIPTION,
    X_SPACE_UNAVAILABILITY_ID,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_LOGIN,
    L.LANGUAGE_CODE,
    userenv('LANG')
  from FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and not exists
    (select NULL
    from AHL_SPACE_UNAVAILABLE_TL T
    where T.SPACE_UNAVAILABILITY_ID = X_SPACE_UNAVAILABILITY_ID
    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 129


end INSERT_ROW;

Line: 155


  cursor c is select
      ATTRIBUTE13,
      ATTRIBUTE14,
      ATTRIBUTE15,
      SPACE_ID,
      START_DATE,
      END_DATE,
      ATTRIBUTE_CATEGORY,
      ATTRIBUTE1,
      ATTRIBUTE2,
      ATTRIBUTE3,
      ATTRIBUTE4,
      ATTRIBUTE5,
      ATTRIBUTE6,
      ATTRIBUTE7,
      ATTRIBUTE11,
      ATTRIBUTE9,
      OBJECT_VERSION_NUMBER,
      ATTRIBUTE12,
      ATTRIBUTE8,
      ATTRIBUTE10
    from AHL_SPACE_UNAVAILABLE_B
    where SPACE_UNAVAILABILITY_ID = X_SPACE_UNAVAILABILITY_ID
    for update of SPACE_UNAVAILABILITY_ID nowait;

Line: 181


  cursor c1 is select
      DESCRIPTION,
      decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
    from AHL_SPACE_UNAVAILABLE_TL
    where SPACE_UNAVAILABILITY_ID = X_SPACE_UNAVAILABILITY_ID
    and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
    for update of SPACE_UNAVAILABILITY_ID nowait;

Line: 193


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

Line: 257


procedure UPDATE_ROW (
  X_SPACE_UNAVAILABILITY_ID in NUMBER,
  X_ATTRIBUTE13 in VARCHAR2,
  X_ATTRIBUTE14 in VARCHAR2,
  X_ATTRIBUTE15 in VARCHAR2,
  X_SPACE_ID in NUMBER,
  X_START_DATE in DATE,
  X_END_DATE in DATE,
  X_ATTRIBUTE_CATEGORY in VARCHAR2,
  X_ATTRIBUTE1 in VARCHAR2,
  X_ATTRIBUTE2 in VARCHAR2,
  X_ATTRIBUTE3 in VARCHAR2,
  X_ATTRIBUTE4 in VARCHAR2,
  X_ATTRIBUTE5 in VARCHAR2,
  X_ATTRIBUTE6 in VARCHAR2,
  X_ATTRIBUTE7 in VARCHAR2,
  X_ATTRIBUTE11 in VARCHAR2,
  X_ATTRIBUTE9 in VARCHAR2,
  X_OBJECT_VERSION_NUMBER in NUMBER,
  X_ATTRIBUTE12 in VARCHAR2,
  X_ATTRIBUTE8 in VARCHAR2,
  X_ATTRIBUTE10 in VARCHAR2,
  X_DESCRIPTION in VARCHAR2,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER
) is
begin
  update AHL_SPACE_UNAVAILABLE_B set
    ATTRIBUTE13 = X_ATTRIBUTE13,
    ATTRIBUTE14 = X_ATTRIBUTE14,
    ATTRIBUTE15 = X_ATTRIBUTE15,
    SPACE_ID = X_SPACE_ID,
    START_DATE = X_START_DATE,
    END_DATE = X_END_DATE,
    ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
    ATTRIBUTE1 = X_ATTRIBUTE1,
    ATTRIBUTE2 = X_ATTRIBUTE2,
    ATTRIBUTE3 = X_ATTRIBUTE3,
    ATTRIBUTE4 = X_ATTRIBUTE4,
    ATTRIBUTE5 = X_ATTRIBUTE5,
    ATTRIBUTE6 = X_ATTRIBUTE6,
    ATTRIBUTE7 = X_ATTRIBUTE7,
    ATTRIBUTE11 = X_ATTRIBUTE11,
    ATTRIBUTE9 = X_ATTRIBUTE9,
    OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
    ATTRIBUTE12 = X_ATTRIBUTE12,
    ATTRIBUTE8 = X_ATTRIBUTE8,
    ATTRIBUTE10 = X_ATTRIBUTE10,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
  where SPACE_UNAVAILABILITY_ID = X_SPACE_UNAVAILABILITY_ID;

Line: 315


  update AHL_SPACE_UNAVAILABLE_TL set
    DESCRIPTION = X_DESCRIPTION,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
    SOURCE_LANG = userenv('LANG')
  where SPACE_UNAVAILABILITY_ID = X_SPACE_UNAVAILABILITY_ID
  and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line: 327


end UPDATE_ROW;

Line: 329


procedure DELETE_ROW (
  X_SPACE_UNAVAILABILITY_ID in NUMBER
) is
begin
  delete from AHL_SPACE_UNAVAILABLE_TL
  where SPACE_UNAVAILABILITY_ID = X_SPACE_UNAVAILABILITY_ID;

Line: 340


  delete from AHL_SPACE_UNAVAILABLE_B
  where SPACE_UNAVAILABILITY_ID = X_SPACE_UNAVAILABILITY_ID;

Line: 346


end DELETE_ROW;

Line: 351


  delete from AHL_SPACE_UNAVAILABLE_TL T
  where not exists
    (select NULL
    from AHL_SPACE_UNAVAILABLE_B B
    where B.SPACE_UNAVAILABILITY_ID = T.SPACE_UNAVAILABILITY_ID
    );

Line: 358


  update AHL_SPACE_UNAVAILABLE_TL T set (
      DESCRIPTION
    ) = (select
      B.DESCRIPTION
    from AHL_SPACE_UNAVAILABLE_TL B
    where B.SPACE_UNAVAILABILITY_ID = T.SPACE_UNAVAILABILITY_ID
    and B.LANGUAGE = T.SOURCE_LANG)
  where (
      T.SPACE_UNAVAILABILITY_ID,
      T.LANGUAGE
  ) in (select
      SUBT.SPACE_UNAVAILABILITY_ID,
      SUBT.LANGUAGE
    from AHL_SPACE_UNAVAILABLE_TL SUBB, AHL_SPACE_UNAVAILABLE_TL SUBT
    where SUBB.SPACE_UNAVAILABILITY_ID = SUBT.SPACE_UNAVAILABILITY_ID
    and SUBB.LANGUAGE = SUBT.SOURCE_LANG
    and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
      or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
      or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
  ));

Line: 379


  insert into AHL_SPACE_UNAVAILABLE_TL (
    DESCRIPTION,
    SPACE_UNAVAILABILITY_ID,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_LOGIN,
    LANGUAGE,
    SOURCE_LANG
  ) select /*+ ORDERED */
    B.DESCRIPTION,
    B.SPACE_UNAVAILABILITY_ID,
    B.LAST_UPDATE_DATE,
    B.LAST_UPDATED_BY,
    B.CREATION_DATE,
    B.CREATED_BY,
    B.LAST_UPDATE_LOGIN,
    L.LANGUAGE_CODE,
    B.SOURCE_LANG
  from AHL_SPACE_UNAVAILABLE_TL B, FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and B.LANGUAGE = userenv('LANG')
  and not exists
    (select NULL
    from AHL_SPACE_UNAVAILABLE_TL T
    where T.SPACE_UNAVAILABILITY_ID = B.SPACE_UNAVAILABILITY_ID
    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 444


  select  object_version_number
  from    AHL_SPACE_UNAVAILABLE_B
  where   SPACE_UNAVAILABILITY_ID =  X_SPACE_UNAVAILABILITY_ID;

Line: 449


  select 'x'
  from   AHL_SPACE_UNAVAILABLE_B
  where  SPACE_UNAVAILABILITY_ID = X_SPACE_UNAVAILABILITY_ID;

Line: 454


   select AHL_SPACE_UNAVAILABLE_B_S.NEXTVAL
   from DUAL;

Line: 479


AHL_SPACE_UNAVAILABLE_PKG.INSERT_ROW (
X_ROWID			=>	l_row_id	,
X_SPACE_UNAVAILABILITY_ID	=>	l_obj_id	,
X_OBJECT_VERSION_NUMBER	=>	l_obj_verno	,

X_ATTRIBUTE13		=>	X_ATTRIBUTE13	,
X_ATTRIBUTE14		=>	X_ATTRIBUTE14	,
X_ATTRIBUTE15		=>	X_ATTRIBUTE15	,
X_SPACE_ID		=>	X_SPACE_ID	,
X_START_DATE		=>	X_START_DATE	,
X_END_DATE		=>	X_END_DATE	,
X_ATTRIBUTE_CATEGORY	=>	X_ATTRIBUTE_CATEGORY	,
X_ATTRIBUTE1		=>	X_ATTRIBUTE1	,
X_ATTRIBUTE2		=>	X_ATTRIBUTE2	,
X_ATTRIBUTE3		=>	X_ATTRIBUTE3	,
X_ATTRIBUTE4		=>	X_ATTRIBUTE4	,
X_ATTRIBUTE5		=>	X_ATTRIBUTE5	,
X_ATTRIBUTE6		=>	X_ATTRIBUTE6	,
X_ATTRIBUTE7		=>	X_ATTRIBUTE7	,
X_ATTRIBUTE11		=>	X_ATTRIBUTE11	,
X_ATTRIBUTE9		=>	X_ATTRIBUTE9	,
X_ATTRIBUTE12		=>	X_ATTRIBUTE12	,
X_ATTRIBUTE8		=>	X_ATTRIBUTE8	,
X_ATTRIBUTE10		=>	X_ATTRIBUTE10	,
X_DESCRIPTION		=>	X_DESCRIPTION	,


X_CREATION_DATE 	=>      SYSDATE         ,
X_CREATED_BY            =>      l_user_id       ,
X_LAST_UPDATE_DATE      =>      SYSDATE         ,
X_LAST_UPDATED_BY       =>      l_user_id       ,
X_LAST_UPDATE_LOGIN     =>      0
);

Line: 521


AHL_SPACE_UNAVAILABLE_PKG.UPDATE_ROW (
X_SPACE_UNAVAILABILITY_ID	=>	X_SPACE_UNAVAILABILITY_ID	,
X_OBJECT_VERSION_NUMBER	=>	l_obj_verno	,

X_ATTRIBUTE13		=>	X_ATTRIBUTE13	,
X_ATTRIBUTE14		=>	X_ATTRIBUTE14	,
X_ATTRIBUTE15		=>	X_ATTRIBUTE15	,
X_SPACE_ID		=>	X_SPACE_ID	,
X_START_DATE		=>	X_START_DATE	,
X_END_DATE		=>	X_END_DATE	,
X_ATTRIBUTE_CATEGORY	=>	X_ATTRIBUTE_CATEGORY	,
X_ATTRIBUTE1		=>	X_ATTRIBUTE1	,
X_ATTRIBUTE2		=>	X_ATTRIBUTE2	,
X_ATTRIBUTE3		=>	X_ATTRIBUTE3	,
X_ATTRIBUTE4		=>	X_ATTRIBUTE4	,
X_ATTRIBUTE5		=>	X_ATTRIBUTE5	,
X_ATTRIBUTE6		=>	X_ATTRIBUTE6	,
X_ATTRIBUTE7		=>	X_ATTRIBUTE7	,
X_ATTRIBUTE11		=>	X_ATTRIBUTE11	,
X_ATTRIBUTE9		=>	X_ATTRIBUTE9	,
X_ATTRIBUTE12		=>	X_ATTRIBUTE12	,
X_ATTRIBUTE8		=>	X_ATTRIBUTE8	,
X_ATTRIBUTE10		=>	X_ATTRIBUTE10	,
X_DESCRIPTION		=>	X_DESCRIPTION	,

X_LAST_UPDATE_DATE      =>      SYSDATE         ,
X_LAST_UPDATED_BY       =>      l_user_id       ,
X_LAST_UPDATE_LOGIN     =>      0
	);

Line: 560


  update AHL_SPACE_UNAVAILABLE_TL set
    DESCRIPTION = NVL(X_DESCRIPTION,DESCRIPTION),
       source_lang = userenv('LANG'),
       last_update_date = sysdate,
       last_updated_by = decode(x_owner, 'SEED', 1, 0),
       last_update_login = 0
  where SPACE_UNAVAILABILITY_ID = X_SPACE_UNAVAILABILITY_ID
  and userenv('LANG') in (LANGUAGE, SOURCE_LANG);