APPS.JTF_AM_SCREEN_SETUPS_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_SCREEN_SETUP_ID in NUMBER,
  X_ATTRIBUTE15 in VARCHAR2,
  X_ATTRIBUTE_CATEGORY in VARCHAR2,
  X_SECURITY_GROUP_ID in NUMBER,
  X_ATTRIBUTE11 in VARCHAR2,
  X_MODE_ASSIST in VARCHAR2,
  X_MODE_UNASSIST in VARCHAR2,
  X_CONTRACTS in VARCHAR2,
  X_INSTALLED_BASE in VARCHAR2,
  X_TERRITORY in VARCHAR2,
  X_AVAILABILITY in VARCHAR2,
  X_DOCUMENT_TYPE in VARCHAR2,
  X_ATTRIBUTE7 in VARCHAR2,
  X_ATTRIBUTE8 in VARCHAR2,
  X_ATTRIBUTE9 in VARCHAR2,
  X_ATTRIBUTE10 in VARCHAR2,
  X_ATTRIBUTE12 in VARCHAR2,
  X_ATTRIBUTE13 in VARCHAR2,
  X_ATTRIBUTE14 in VARCHAR2,
  X_WINDOW_WIDTH in NUMBER,
  X_WINDOW_HEIGHT in NUMBER,
  X_WINDOW_X_POSITION in NUMBER,
  X_WINDOW_Y_POSITION in NUMBER,
  X_DOC_DTLS_USER_VALUES in VARCHAR2,
  X_SHOW_SELECTED_TIME in VARCHAR2,
  X_OBJECT_VERSION_NUMBER in NUMBER,
  X_USER_ID in NUMBER,
  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_DOC_DETAILS in VARCHAR2,
  X_PREFERENCE_NAME 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 JTF_AM_SCREEN_SETUPS_B
    where SCREEN_SETUP_ID = X_SCREEN_SETUP_ID
    ;

Line: 50

  insert into JTF_AM_SCREEN_SETUPS_B (
    ATTRIBUTE15,
    ATTRIBUTE_CATEGORY,
    SECURITY_GROUP_ID,
    ATTRIBUTE11,
    MODE_ASSIST,
    MODE_UNASSIST,
    CONTRACTS,
    INSTALLED_BASE,
    TERRITORY,
    AVAILABILITY,
    DOCUMENT_TYPE,
    ATTRIBUTE7,
    ATTRIBUTE8,
    ATTRIBUTE9,
    ATTRIBUTE10,
    ATTRIBUTE12,
    ATTRIBUTE13,
    ATTRIBUTE14,
    SCREEN_SETUP_ID,
    WINDOW_WIDTH,
    WINDOW_HEIGHT,
    WINDOW_X_POSITION,
    WINDOW_Y_POSITION,
    DOC_DTLS_USER_VALUES,
    SHOW_SELECTED_TIME,
    OBJECT_VERSION_NUMBER,
    USER_ID,
    ATTRIBUTE1,
    ATTRIBUTE2,
    ATTRIBUTE3,
    ATTRIBUTE4,
    ATTRIBUTE5,
    ATTRIBUTE6,
    DOC_DETAILS,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN
  ) values (
    X_ATTRIBUTE15,
    X_ATTRIBUTE_CATEGORY,
    X_SECURITY_GROUP_ID,
    X_ATTRIBUTE11,
    X_MODE_ASSIST,
    X_MODE_UNASSIST,
    X_CONTRACTS,
    X_INSTALLED_BASE,
    X_TERRITORY,
    X_AVAILABILITY,
    X_DOCUMENT_TYPE,
    X_ATTRIBUTE7,
    X_ATTRIBUTE8,
    X_ATTRIBUTE9,
    X_ATTRIBUTE10,
    X_ATTRIBUTE12,
    X_ATTRIBUTE13,
    X_ATTRIBUTE14,
    X_SCREEN_SETUP_ID,
    X_WINDOW_WIDTH,
    X_WINDOW_HEIGHT,
    X_WINDOW_X_POSITION,
    X_WINDOW_Y_POSITION,
    X_DOC_DTLS_USER_VALUES,
    X_SHOW_SELECTED_TIME,
    X_OBJECT_VERSION_NUMBER,
    X_USER_ID,
    X_ATTRIBUTE1,
    X_ATTRIBUTE2,
    X_ATTRIBUTE3,
    X_ATTRIBUTE4,
    X_ATTRIBUTE5,
    X_ATTRIBUTE6,
    X_DOC_DETAILS,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN
  );

Line: 132

  insert into JTF_AM_SCREEN_SETUPS_TL (
    LAST_UPDATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATE_LOGIN,
    SECURITY_GROUP_ID,
    SCREEN_SETUP_ID,
    PREFERENCE_NAME,
    CREATED_BY,
    CREATION_DATE,
    LANGUAGE,
    SOURCE_LANG
  ) select
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATE_LOGIN,
    X_SECURITY_GROUP_ID,
    X_SCREEN_SETUP_ID,
    X_PREFERENCE_NAME,
    X_CREATED_BY,
    X_CREATION_DATE,
    L.LANGUAGE_CODE,
    userenv('LANG')
  from FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and not exists
    (select NULL
    from JTF_AM_SCREEN_SETUPS_TL T
    where T.SCREEN_SETUP_ID = X_SCREEN_SETUP_ID
    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 170

end INSERT_ROW;

Line: 197

  X_SHOW_SELECTED_TIME in VARCHAR2,
  X_OBJECT_VERSION_NUMBER in NUMBER,
  X_USER_ID in NUMBER,
  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_DOC_DETAILS in VARCHAR2,
  X_PREFERENCE_NAME in VARCHAR2
) is
  cursor c is select
      ATTRIBUTE15,
      ATTRIBUTE_CATEGORY,
      SECURITY_GROUP_ID,
      ATTRIBUTE11,
      MODE_ASSIST,
      MODE_UNASSIST,
      CONTRACTS,
      INSTALLED_BASE,
      TERRITORY,
      AVAILABILITY,
      DOCUMENT_TYPE,
      ATTRIBUTE7,
      ATTRIBUTE8,
      ATTRIBUTE9,
      ATTRIBUTE10,
      ATTRIBUTE12,
      ATTRIBUTE13,
      ATTRIBUTE14,
      WINDOW_WIDTH,
      WINDOW_HEIGHT,
      WINDOW_X_POSITION,
      WINDOW_Y_POSITION,
      DOC_DTLS_USER_VALUES,
      SHOW_SELECTED_TIME,
      OBJECT_VERSION_NUMBER,
      USER_ID,
      ATTRIBUTE1,
      ATTRIBUTE2,
      ATTRIBUTE3,
      ATTRIBUTE4,
      ATTRIBUTE5,
      ATTRIBUTE6,
      DOC_DETAILS
    from JTF_AM_SCREEN_SETUPS_B
    where SCREEN_SETUP_ID = X_SCREEN_SETUP_ID
    for update of SCREEN_SETUP_ID nowait;

Line: 248

  cursor c1 is select
      PREFERENCE_NAME,
      decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
    from JTF_AM_SCREEN_SETUPS_TL
    where SCREEN_SETUP_ID = X_SCREEN_SETUP_ID
    and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
    for update of SCREEN_SETUP_ID nowait;

Line: 260

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

Line: 310

      AND ((recinfo.SHOW_SELECTED_TIME = X_SHOW_SELECTED_TIME)
           OR ((recinfo.SHOW_SELECTED_TIME is null) AND (X_SHOW_SELECTED_TIME is null)))
      AND ((recinfo.OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER)
           OR ((recinfo.OBJECT_VERSION_NUMBER is null) AND (X_OBJECT_VERSION_NUMBER is null)))
      AND ((recinfo.USER_ID = X_USER_ID)
           OR ((recinfo.USER_ID is null) AND (X_USER_ID is null)))
      AND ((recinfo.ATTRIBUTE1 = X_ATTRIBUTE1)
           OR ((recinfo.ATTRIBUTE1 is null) AND (X_ATTRIBUTE1 is null)))
      AND ((recinfo.ATTRIBUTE2 = X_ATTRIBUTE2)
           OR ((recinfo.ATTRIBUTE2 is null) AND (X_ATTRIBUTE2 is null)))
      AND ((recinfo.ATTRIBUTE3 = X_ATTRIBUTE3)
           OR ((recinfo.ATTRIBUTE3 is null) AND (X_ATTRIBUTE3 is null)))
      AND ((recinfo.ATTRIBUTE4 = X_ATTRIBUTE4)
           OR ((recinfo.ATTRIBUTE4 is null) AND (X_ATTRIBUTE4 is null)))
      AND ((recinfo.ATTRIBUTE5 = X_ATTRIBUTE5)
           OR ((recinfo.ATTRIBUTE5 is null) AND (X_ATTRIBUTE5 is null)))
      AND ((recinfo.ATTRIBUTE6 = X_ATTRIBUTE6)
           OR ((recinfo.ATTRIBUTE6 is null) AND (X_ATTRIBUTE6 is null)))
      AND ((recinfo.DOC_DETAILS = X_DOC_DETAILS)
           OR ((recinfo.DOC_DETAILS is null) AND (X_DOC_DETAILS is null)))
  ) then
    null;

Line: 352

procedure UPDATE_ROW (
  X_SCREEN_SETUP_ID in NUMBER,
  X_ATTRIBUTE15 in VARCHAR2,
  X_ATTRIBUTE_CATEGORY in VARCHAR2,
  X_SECURITY_GROUP_ID in NUMBER,
  X_ATTRIBUTE11 in VARCHAR2,
  X_MODE_ASSIST in VARCHAR2,
  X_MODE_UNASSIST in VARCHAR2,
  X_CONTRACTS in VARCHAR2,
  X_INSTALLED_BASE in VARCHAR2,
  X_TERRITORY in VARCHAR2,
  X_AVAILABILITY in VARCHAR2,
  X_DOCUMENT_TYPE in VARCHAR2,
  X_ATTRIBUTE7 in VARCHAR2,
  X_ATTRIBUTE8 in VARCHAR2,
  X_ATTRIBUTE9 in VARCHAR2,
  X_ATTRIBUTE10 in VARCHAR2,
  X_ATTRIBUTE12 in VARCHAR2,
  X_ATTRIBUTE13 in VARCHAR2,
  X_ATTRIBUTE14 in VARCHAR2,
  X_WINDOW_WIDTH in NUMBER,
  X_WINDOW_HEIGHT in NUMBER,
  X_WINDOW_X_POSITION in NUMBER,
  X_WINDOW_Y_POSITION in NUMBER,
  X_DOC_DTLS_USER_VALUES in VARCHAR2,
  X_SHOW_SELECTED_TIME in VARCHAR2,
  X_OBJECT_VERSION_NUMBER in NUMBER,
  X_USER_ID in NUMBER,
  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_DOC_DETAILS in VARCHAR2,
  X_PREFERENCE_NAME in VARCHAR2,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER
) is
begin
  update JTF_AM_SCREEN_SETUPS_B set
    ATTRIBUTE15 = X_ATTRIBUTE15,
    ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
    SECURITY_GROUP_ID = X_SECURITY_GROUP_ID,
    ATTRIBUTE11 = X_ATTRIBUTE11,
    MODE_ASSIST = X_MODE_ASSIST,
    MODE_UNASSIST = X_MODE_UNASSIST,
    CONTRACTS = X_CONTRACTS,
    INSTALLED_BASE = X_INSTALLED_BASE,
    TERRITORY = X_TERRITORY,
    AVAILABILITY = X_AVAILABILITY,
    DOCUMENT_TYPE = X_DOCUMENT_TYPE,
    ATTRIBUTE7 = X_ATTRIBUTE7,
    ATTRIBUTE8 = X_ATTRIBUTE8,
    ATTRIBUTE9 = X_ATTRIBUTE9,
    ATTRIBUTE10 = X_ATTRIBUTE10,
    ATTRIBUTE12 = X_ATTRIBUTE12,
    ATTRIBUTE13 = X_ATTRIBUTE13,
    ATTRIBUTE14 = X_ATTRIBUTE14,
    WINDOW_WIDTH = X_WINDOW_WIDTH,
    WINDOW_HEIGHT = X_WINDOW_HEIGHT,
    WINDOW_X_POSITION = X_WINDOW_X_POSITION,
    WINDOW_Y_POSITION = X_WINDOW_Y_POSITION,
    DOC_DTLS_USER_VALUES = X_DOC_DTLS_USER_VALUES,
    SHOW_SELECTED_TIME = X_SHOW_SELECTED_TIME,
    OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
    USER_ID = X_USER_ID,
    ATTRIBUTE1 = X_ATTRIBUTE1,
    ATTRIBUTE2 = X_ATTRIBUTE2,
    ATTRIBUTE3 = X_ATTRIBUTE3,
    ATTRIBUTE4 = X_ATTRIBUTE4,
    ATTRIBUTE5 = X_ATTRIBUTE5,
    ATTRIBUTE6 = X_ATTRIBUTE6,
    DOC_DETAILS = X_DOC_DETAILS,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
  where SCREEN_SETUP_ID = X_SCREEN_SETUP_ID;

Line: 436

  update JTF_AM_SCREEN_SETUPS_TL set
    PREFERENCE_NAME = X_PREFERENCE_NAME,
    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 SCREEN_SETUP_ID = X_SCREEN_SETUP_ID
  and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line: 448

end UPDATE_ROW;

Line: 450

procedure DELETE_ROW (
  X_SCREEN_SETUP_ID in NUMBER
) is
begin
  delete from JTF_AM_SCREEN_SETUPS_TL
  where SCREEN_SETUP_ID = X_SCREEN_SETUP_ID;

Line: 461

  delete from JTF_AM_SCREEN_SETUPS_B
  where SCREEN_SETUP_ID = X_SCREEN_SETUP_ID;

Line: 467

end DELETE_ROW;

Line: 472

  delete from JTF_AM_SCREEN_SETUPS_TL T
  where not exists
    (select NULL
    from JTF_AM_SCREEN_SETUPS_B B
    where B.SCREEN_SETUP_ID = T.SCREEN_SETUP_ID
    );

Line: 479

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

Line: 500

  insert into JTF_AM_SCREEN_SETUPS_TL (
    LAST_UPDATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATE_LOGIN,
    SECURITY_GROUP_ID,
    SCREEN_SETUP_ID,
    PREFERENCE_NAME,
    CREATED_BY,
    CREATION_DATE,
    LANGUAGE,
    SOURCE_LANG
  ) select
    B.LAST_UPDATED_BY,
    B.LAST_UPDATE_DATE,
    B.LAST_UPDATE_LOGIN,
    B.SECURITY_GROUP_ID,
    B.SCREEN_SETUP_ID,
    B.PREFERENCE_NAME,
    B.CREATED_BY,
    B.CREATION_DATE,
    L.LANGUAGE_CODE,
    B.SOURCE_LANG
  from JTF_AM_SCREEN_SETUPS_TL B, FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and B.LANGUAGE = userenv('LANG')
  and not exists
    (select NULL
    from JTF_AM_SCREEN_SETUPS_TL T
    where T.SCREEN_SETUP_ID = B.SCREEN_SETUP_ID
    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 547

  X_SHOW_SELECTED_TIME in VARCHAR2,
  X_OBJECT_VERSION_NUMBER in NUMBER,
  X_USER_ID in NUMBER,
  X_DOC_DETAILS 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_ATTRIBUTE_CATEGORY in VARCHAR2,
  X_SECURITY_GROUP_ID in NUMBER,
  X_PREFERENCE_NAME in VARCHAR2
) is
l_row_id rowid;

Line: 572

l_last_updated_by number := -1;

Line: 575

CURSOR c_last_updated IS
  SELECT last_updated_by,
         object_version_number
    from JTF_AM_SCREEN_SETUPS_VL
   WHERE screen_setup_id = x_screen_setup_id;

Line: 588

OPEN c_last_updated;

Line: 589

FETCH c_last_updated into l_last_updated_by, l_object_version_number ;

Line: 590

      IF c_last_updated%NOTFOUND THEN
         l_object_version_number := 1;

Line: 592

	 jtf_am_screen_setups_pkg.insert_row(
                X_ROWID               => l_row_id ,
                X_SCREEN_SETUP_ID       => X_SCREEN_SETUP_ID,
                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_ATTRIBUTE8            => X_ATTRIBUTE8 ,
                X_ATTRIBUTE9            => X_ATTRIBUTE9 ,
                X_ATTRIBUTE10           => X_ATTRIBUTE10 ,
                X_ATTRIBUTE11           => X_ATTRIBUTE11 ,
                X_ATTRIBUTE12           => X_ATTRIBUTE12 ,
                X_ATTRIBUTE13           => X_ATTRIBUTE13 ,
                X_ATTRIBUTE14           => X_ATTRIBUTE14 ,
                X_ATTRIBUTE15           => X_ATTRIBUTE15 ,
                X_ATTRIBUTE_CATEGORY    => X_ATTRIBUTE_CATEGORY ,
                X_SECURITY_GROUP_ID     => X_SECURITY_GROUP_ID,
                X_MODE_ASSIST           => X_MODE_ASSIST,
                X_MODE_UNASSIST         => X_MODE_UNASSIST,
                X_CONTRACTS             => X_CONTRACTS,
                X_INSTALLED_BASE        => X_INSTALLED_BASE,
                X_TERRITORY             => X_TERRITORY,
                X_AVAILABILITY          => X_AVAILABILITY ,
                X_DOCUMENT_TYPE         => X_DOCUMENT_TYPE,
                X_WINDOW_WIDTH          => X_WINDOW_WIDTH,
                X_WINDOW_HEIGHT         => X_WINDOW_HEIGHT,
                X_WINDOW_X_POSITION     => X_WINDOW_X_POSITION,
                X_WINDOW_Y_POSITION     => X_WINDOW_Y_POSITION,
                X_DOC_DTLS_USER_VALUES  => X_DOC_DTLS_USER_VALUES ,
                X_SHOW_SELECTED_TIME    => X_SHOW_SELECTED_TIME,
                X_DOC_DETAILS           => X_DOC_DETAILS,
                X_OBJECT_VERSION_NUMBER => l_object_version_number ,
                X_USER_ID               => X_USER_ID,
                X_PREFERENCE_NAME       => X_PREFERENCE_NAME ,
                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: 634

      ELSIF c_last_updated%FOUND THEN
         IF l_last_updated_by IN (1,0) THEN
            l_object_version_number :=   l_object_version_number + 1;

Line: 637

	    jtf_am_screen_setups_pkg.update_row(
                X_SCREEN_SETUP_ID       => X_SCREEN_SETUP_ID,
                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_ATTRIBUTE8            => X_ATTRIBUTE8 ,
                X_ATTRIBUTE9            => X_ATTRIBUTE9 ,
                X_ATTRIBUTE10           => X_ATTRIBUTE10 ,
                X_ATTRIBUTE11           => X_ATTRIBUTE11 ,
                X_ATTRIBUTE12           => X_ATTRIBUTE12 ,
                X_ATTRIBUTE13           => X_ATTRIBUTE13 ,
                X_ATTRIBUTE14           => X_ATTRIBUTE14 ,
                X_ATTRIBUTE15           => X_ATTRIBUTE15 ,
                X_ATTRIBUTE_CATEGORY    => X_ATTRIBUTE_CATEGORY ,
                X_SECURITY_GROUP_ID     => X_SECURITY_GROUP_ID,
                X_MODE_ASSIST           => X_MODE_ASSIST,
                X_MODE_UNASSIST         => X_MODE_UNASSIST,
                X_CONTRACTS             => X_CONTRACTS,
                X_INSTALLED_BASE        => X_INSTALLED_BASE,
                X_TERRITORY             => X_TERRITORY,
                X_AVAILABILITY          => X_AVAILABILITY ,
                X_DOCUMENT_TYPE         => X_DOCUMENT_TYPE,
                X_WINDOW_WIDTH          => X_WINDOW_WIDTH,
                X_WINDOW_HEIGHT         => X_WINDOW_HEIGHT,
                X_WINDOW_X_POSITION     => X_WINDOW_X_POSITION,
                X_WINDOW_Y_POSITION     => X_WINDOW_Y_POSITION,
                X_DOC_DTLS_USER_VALUES  => X_DOC_DTLS_USER_VALUES ,
                X_SHOW_SELECTED_TIME    => X_SHOW_SELECTED_TIME,
                X_DOC_DETAILS           => X_DOC_DETAILS,
                X_OBJECT_VERSION_NUMBER => l_object_version_number,
                X_USER_ID               => X_USER_ID,
                X_PREFERENCE_NAME       => X_PREFERENCE_NAME ,
                X_LAST_UPDATE_DATE      => sysdate      ,
                X_LAST_UPDATED_BY       => l_user_id ,
                X_LAST_UPDATE_LOGIN     => 0 );

Line: 678

CLOSE c_last_updated;

Line: 684

 x_Last_update_date in date,
 x_last_updated_by in number,
 x_last_update_login in number)
is
begin
Update jtf_am_screen_setups_tl set
     preference_name        = nvl(x_preference_name,preference_name),
     last_update_date       = nvl(x_last_update_date,sysdate),
     last_updated_by        = x_last_updated_by,
     last_update_login      = 0,
     source_lang            = userenv('LANG')
where screen_setup_id       = x_screen_setup_id
  and userenv('LANG') in (LANGUAGE,SOURCE_LANG);