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.PSP_ELEMENT_TYPES_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_ELEMENT_TYPE_ID in NUMBER,
  X_START_DATE_ACTIVE in DATE,
  X_END_DATE_ACTIVE in DATE,
  X_COMMENTS in VARCHAR2,
  X_ADJUST in VARCHAR2,   -- 2634557
  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_ATTRIBUTE8 in VARCHAR2,
  X_ATTRIBUTE9 in VARCHAR2,
  X_ATTRIBUTE10 in VARCHAR2,
  X_ATTRIBUTE11 in VARCHAR2,
  X_ATTRIBUTE12 in VARCHAR2,
  X_ATTRIBUTE13 in VARCHAR2,
  X_ATTRIBUTE14 in VARCHAR2,
  X_ATTRIBUTE15 in VARCHAR2,
  X_MODE in VARCHAR2 default 'R',
  X_BUSINESS_GROUP_ID IN NUMBER,	-- Introduced for bug fix 3098050
  X_SET_OF_BOOKS_ID IN NUMBER		-- Introduced for bug fix 3098050
  ) is
    cursor C is select ROWID from PSP_ELEMENT_TYPES
      where ELEMENT_TYPE_ID = X_ELEMENT_TYPE_ID
      and START_DATE_ACTIVE = X_START_DATE_ACTIVE;

Line: 33


    X_LAST_UPDATE_DATE DATE;

Line: 34


    X_LAST_UPDATED_BY NUMBER;

Line: 35


    X_LAST_UPDATE_LOGIN NUMBER;

Line: 37


  X_LAST_UPDATE_DATE := SYSDATE;

Line: 39


    X_LAST_UPDATED_BY := 1;

Line: 40


    X_LAST_UPDATE_LOGIN := 0;

Line: 42


    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 43


    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 46


    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 47


    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 54


  insert into PSP_ELEMENT_TYPES (
    ELEMENT_TYPE_ID,
    START_DATE_ACTIVE,
    END_DATE_ACTIVE,
    COMMENTS,
    ADJUST,    --- 2634557
    ATTRIBUTE_CATEGORY,
    ATTRIBUTE1,
    ATTRIBUTE2,
    ATTRIBUTE3,
    ATTRIBUTE4,
    ATTRIBUTE5,
    ATTRIBUTE6,
    ATTRIBUTE7,
    ATTRIBUTE8,
    ATTRIBUTE9,
    ATTRIBUTE10,
    ATTRIBUTE11,
    ATTRIBUTE12,
    ATTRIBUTE13,
    ATTRIBUTE14,
    ATTRIBUTE15,
    BUSINESS_GROUP_ID,	-- Introduced for bug fix 3098050
    SET_OF_BOOKS_ID,	-- Introduced for bug fix 3098050
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN
  ) values (
    X_ELEMENT_TYPE_ID,
    X_START_DATE_ACTIVE,
    X_END_DATE_ACTIVE,
    X_COMMENTS,
    X_ADJUST,
    X_ATTRIBUTE_CATEGORY,
    X_ATTRIBUTE1,
    X_ATTRIBUTE2,
    X_ATTRIBUTE3,
    X_ATTRIBUTE4,
    X_ATTRIBUTE5,
    X_ATTRIBUTE6,
    X_ATTRIBUTE7,
    X_ATTRIBUTE8,
    X_ATTRIBUTE9,
    X_ATTRIBUTE10,
    X_ATTRIBUTE11,
    X_ATTRIBUTE12,
    X_ATTRIBUTE13,
    X_ATTRIBUTE14,
    X_ATTRIBUTE15,
    X_BUSINESS_GROUP_ID,	-- Introduced for bug fix 3098050
    X_SET_OF_BOOKS_ID,		-- Introduced for bug fix 3098050
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN
  );

Line: 122


end INSERT_ROW;

Line: 149


  cursor c1 is select
      END_DATE_ACTIVE,
      COMMENTS,
      ADJUST,
      ATTRIBUTE_CATEGORY,
      ATTRIBUTE1,
      ATTRIBUTE2,
      ATTRIBUTE3,
      ATTRIBUTE4,
      ATTRIBUTE5,
      ATTRIBUTE6,
      ATTRIBUTE7,
      ATTRIBUTE8,
      ATTRIBUTE9,
      ATTRIBUTE10,
      ATTRIBUTE11,
      ATTRIBUTE12,
      ATTRIBUTE13,
      ATTRIBUTE14,
      ATTRIBUTE15,
      BUSINESS_GROUP_ID,	-- Introduced for bug fix 3098050
      SET_OF_BOOKS_ID		-- Introduced for bug fix 3098050
    from PSP_ELEMENT_TYPES
    where ELEMENT_TYPE_ID = X_ELEMENT_TYPE_ID
    and START_DATE_ACTIVE = X_START_DATE_ACTIVE
--	Introduced BG/SOB check for bug fix 3098050
    AND	BUSINESS_GROUP_ID = X_BUSINESS_GROUP_ID
    AND	SET_OF_BOOKS_ID = X_SET_OF_BOOKS_ID
    for update of ELEMENT_TYPE_ID nowait;

Line: 257


procedure UPDATE_ROW (
  X_ELEMENT_TYPE_ID in NUMBER,
  X_START_DATE_ACTIVE in DATE,
  X_END_DATE_ACTIVE in DATE,
  X_COMMENTS in VARCHAR2,
  X_ADJUST in VARCHAR2,
  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_ATTRIBUTE8 in VARCHAR2,
  X_ATTRIBUTE9 in VARCHAR2,
  X_ATTRIBUTE10 in VARCHAR2,
  X_ATTRIBUTE11 in VARCHAR2,
  X_ATTRIBUTE12 in VARCHAR2,
  X_ATTRIBUTE13 in VARCHAR2,
  X_ATTRIBUTE14 in VARCHAR2,
  X_ATTRIBUTE15 in VARCHAR2,
  X_MODE in VARCHAR2 default 'R',
  X_BUSINESS_GROUP_ID IN NUMBER,	-- Introduced for bug fix 3098050
  X_SET_OF_BOOKS_ID IN NUMBER		-- Introduced for bug fix 3098050
  ) is
    X_LAST_UPDATE_DATE DATE;

Line: 284


    X_LAST_UPDATED_BY NUMBER;

Line: 285


    X_LAST_UPDATE_LOGIN NUMBER;

Line: 287


  X_LAST_UPDATE_DATE := SYSDATE;

Line: 289


    X_LAST_UPDATED_BY := 1;

Line: 290


    X_LAST_UPDATE_LOGIN := 0;

Line: 292


    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 293


    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 296


    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 297


    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 304


  update PSP_ELEMENT_TYPES set
    END_DATE_ACTIVE = X_END_DATE_ACTIVE,
    COMMENTS = X_COMMENTS,
    ADJUST = X_ADJUST,
    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,
    ATTRIBUTE8 = X_ATTRIBUTE8,
    ATTRIBUTE9 = X_ATTRIBUTE9,
    ATTRIBUTE10 = X_ATTRIBUTE10,
    ATTRIBUTE11 = X_ATTRIBUTE11,
    ATTRIBUTE12 = X_ATTRIBUTE12,
    ATTRIBUTE13 = X_ATTRIBUTE13,
    ATTRIBUTE14 = X_ATTRIBUTE14,
    ATTRIBUTE15 = X_ATTRIBUTE15,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
  where ELEMENT_TYPE_ID = X_ELEMENT_TYPE_ID
  and START_DATE_ACTIVE = X_START_DATE_ACTIVE
--	Introduced BG/SOB check for bug fix 3098050
  AND	BUSINESS_GROUP_ID = X_BUSINESS_GROUP_ID
  AND	SET_OF_BOOKS_ID = X_SET_OF_BOOKS_ID
  ;

Line: 336


end UPDATE_ROW;

Line: 365


  cursor c1 is select rowid from PSP_ELEMENT_TYPES
     where ELEMENT_TYPE_ID = X_ELEMENT_TYPE_ID
     and START_DATE_ACTIVE = X_START_DATE_ACTIVE
  ;

Line: 375


    INSERT_ROW (
     X_ROWID,
     X_ELEMENT_TYPE_ID,
     X_START_DATE_ACTIVE,
     X_END_DATE_ACTIVE,
     X_COMMENTS,
     X_ADJUST,
     X_ATTRIBUTE_CATEGORY,
     X_ATTRIBUTE1,
     X_ATTRIBUTE2,
     X_ATTRIBUTE3,
     X_ATTRIBUTE4,
     X_ATTRIBUTE5,
     X_ATTRIBUTE6,
     X_ATTRIBUTE7,
     X_ATTRIBUTE8,
     X_ATTRIBUTE9,
     X_ATTRIBUTE10,
     X_ATTRIBUTE11,
     X_ATTRIBUTE12,
     X_ATTRIBUTE13,
     X_ATTRIBUTE14,
     X_ATTRIBUTE15,
     X_MODE,
     X_BUSINESS_GROUP_ID,	-- Introduced for bug fix 3098050
     X_SET_OF_BOOKS_ID);	-- Introduced for bug fix 3098050

Line: 404


  UPDATE_ROW (
   X_ELEMENT_TYPE_ID,
   X_START_DATE_ACTIVE,
   X_END_DATE_ACTIVE,
   X_COMMENTS,
   X_ADJUST,
   X_ATTRIBUTE_CATEGORY,
   X_ATTRIBUTE1,
   X_ATTRIBUTE2,
   X_ATTRIBUTE3,
   X_ATTRIBUTE4,
   X_ATTRIBUTE5,
   X_ATTRIBUTE6,
   X_ATTRIBUTE7,
   X_ATTRIBUTE8,
   X_ATTRIBUTE9,
   X_ATTRIBUTE10,
   X_ATTRIBUTE11,
   X_ATTRIBUTE12,
   X_ATTRIBUTE13,
   X_ATTRIBUTE14,
   X_ATTRIBUTE15,
   X_MODE,
   X_BUSINESS_GROUP_ID,	-- Introduced for bug fix 3098050
   X_SET_OF_BOOKS_ID);	-- Introduced for bug fix 3098050

Line: 431


procedure DELETE_ROW (
  X_ELEMENT_TYPE_ID in NUMBER,
  X_START_DATE_ACTIVE in DATE
) is
begin
  delete from PSP_ELEMENT_TYPES
  where ELEMENT_TYPE_ID = X_ELEMENT_TYPE_ID
  and START_DATE_ACTIVE = X_START_DATE_ACTIVE;

Line: 442


end DELETE_ROW;