APPS.FND_LOOKUP_VALUES_PKG SQL Statements

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

Line: 4

procedure INSERT_ROW (
  X_ROWID in out nocopy VARCHAR2,
  X_LOOKUP_TYPE in VARCHAR2,
  X_SECURITY_GROUP_ID in NUMBER default NULL,
  X_VIEW_APPLICATION_ID in NUMBER,
  X_LOOKUP_CODE in VARCHAR2,
  X_TAG in VARCHAR2,
  X_ATTRIBUTE_CATEGORY in VARCHAR2,
  X_ATTRIBUTE1 in VARCHAR2,
  X_ATTRIBUTE2 in VARCHAR2,
  X_ATTRIBUTE3 in VARCHAR2,
  X_ATTRIBUTE4 in VARCHAR2,
  X_ENABLED_FLAG in VARCHAR2,
  X_START_DATE_ACTIVE in DATE,
  X_END_DATE_ACTIVE in DATE,
  X_TERRITORY_CODE 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_MEANING 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
  sgid NUMBER;

Line: 42

  cursor C is select ROWID from FND_LOOKUP_VALUES
    where LOOKUP_TYPE = X_LOOKUP_TYPE
    and SECURITY_GROUP_ID = sgid
    and VIEW_APPLICATION_ID = X_VIEW_APPLICATION_ID
    and LOOKUP_CODE = X_LOOKUP_CODE
    and LANGUAGE = userenv('LANG');

Line: 56

  insert into FND_LOOKUP_VALUES (
    TAG,
    ATTRIBUTE_CATEGORY,
    ATTRIBUTE1,
    ATTRIBUTE2,
    ATTRIBUTE3,
    ATTRIBUTE4,
    LOOKUP_TYPE,
    LOOKUP_CODE,
    MEANING,
    DESCRIPTION,
    ENABLED_FLAG,
    START_DATE_ACTIVE,
    END_DATE_ACTIVE,
    CREATED_BY,
    CREATION_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    LAST_UPDATE_DATE,
    SECURITY_GROUP_ID,
    VIEW_APPLICATION_ID,
    TERRITORY_CODE,
    ATTRIBUTE5,
    ATTRIBUTE6,
    ATTRIBUTE7,
    ATTRIBUTE8,
    ATTRIBUTE9,
    ATTRIBUTE10,
    ATTRIBUTE11,
    ATTRIBUTE12,
    ATTRIBUTE13,
    ATTRIBUTE14,
    ATTRIBUTE15,
    LANGUAGE,
    SOURCE_LANG
  ) select
    X_TAG,
    X_ATTRIBUTE_CATEGORY,
    X_ATTRIBUTE1,
    X_ATTRIBUTE2,
    X_ATTRIBUTE3,
    X_ATTRIBUTE4,
    X_LOOKUP_TYPE,
    X_LOOKUP_CODE,
    X_MEANING,
    X_DESCRIPTION,
    X_ENABLED_FLAG,
    X_START_DATE_ACTIVE,
    X_END_DATE_ACTIVE,
    X_CREATED_BY,
    X_CREATION_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN,
    X_LAST_UPDATE_DATE,
    sgid,
    X_VIEW_APPLICATION_ID,
    X_TERRITORY_CODE,
    X_ATTRIBUTE5,
    X_ATTRIBUTE6,
    X_ATTRIBUTE7,
    X_ATTRIBUTE8,
    X_ATTRIBUTE9,
    X_ATTRIBUTE10,
    X_ATTRIBUTE11,
    X_ATTRIBUTE12,
    X_ATTRIBUTE13,
    X_ATTRIBUTE14,
    X_ATTRIBUTE15,
    L.LANGUAGE_CODE,
    userenv('LANG')
  from FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and not exists
    (select NULL
    from FND_LOOKUP_VALUES T
    where T.LOOKUP_TYPE = X_LOOKUP_TYPE
    and T.SECURITY_GROUP_ID = sgid
    and T.VIEW_APPLICATION_ID = X_VIEW_APPLICATION_ID
    and T.LOOKUP_CODE = X_LOOKUP_CODE
    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 151

  select userenv('LANG')
  into X_LANG
  from dual;

Line: 155

  wf_event.raise(p_event_name => 'oracle.apps.fnd.lookup.code.insert',
                 p_event_key => X_LOOKUP_TYPE||':'||X_VIEW_APPLICATION_ID||
                 ':'||X_SECURITY_GROUP_ID||':'||X_LANG||':'||X_LOOKUP_CODE,
                 p_event_data => NULL,
                 p_parameters => NULL,
                 p_send_date => Sysdate);

Line: 165

end INSERT_ROW;

Line: 197

  cursor c1 is select
      TAG,
      ATTRIBUTE_CATEGORY,
      ATTRIBUTE1,
      ATTRIBUTE2,
      ATTRIBUTE3,
      ATTRIBUTE4,
      ENABLED_FLAG,
      START_DATE_ACTIVE,
      END_DATE_ACTIVE,
      TERRITORY_CODE,
      ATTRIBUTE5,
      ATTRIBUTE6,
      ATTRIBUTE7,
      ATTRIBUTE8,
      ATTRIBUTE9,
      ATTRIBUTE10,
      ATTRIBUTE11,
      ATTRIBUTE12,
      ATTRIBUTE13,
      ATTRIBUTE14,
      ATTRIBUTE15,
      MEANING,
      DESCRIPTION,
      decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
    from FND_LOOKUP_VALUES
    where LOOKUP_TYPE = X_LOOKUP_TYPE
    and SECURITY_GROUP_ID = sgid
    and VIEW_APPLICATION_ID = X_VIEW_APPLICATION_ID
    and LOOKUP_CODE = X_LOOKUP_CODE
    for update of LOOKUP_TYPE nowait;

Line: 294

procedure UPDATE_ROW (
  X_LOOKUP_TYPE in VARCHAR2,
  X_SECURITY_GROUP_ID in NUMBER default NULL,
  X_VIEW_APPLICATION_ID in NUMBER,
  X_LOOKUP_CODE in VARCHAR2,
  X_TAG in VARCHAR2,
  X_ATTRIBUTE_CATEGORY in VARCHAR2,
  X_ATTRIBUTE1 in VARCHAR2,
  X_ATTRIBUTE2 in VARCHAR2,
  X_ATTRIBUTE3 in VARCHAR2,
  X_ATTRIBUTE4 in VARCHAR2,
  X_ENABLED_FLAG in VARCHAR2,
  X_START_DATE_ACTIVE in DATE,
  X_END_DATE_ACTIVE in DATE,
  X_TERRITORY_CODE 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_MEANING 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
  sgid NUMBER;

Line: 338

  update FND_LOOKUP_VALUES set
    TAG = X_TAG,
    ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
    ATTRIBUTE1 = X_ATTRIBUTE1,
    ATTRIBUTE2 = X_ATTRIBUTE2,
    ATTRIBUTE3 = X_ATTRIBUTE3,
    ATTRIBUTE4 = X_ATTRIBUTE4,
    ENABLED_FLAG = X_ENABLED_FLAG,
    START_DATE_ACTIVE = X_START_DATE_ACTIVE,
    END_DATE_ACTIVE = X_END_DATE_ACTIVE,
    TERRITORY_CODE = X_TERRITORY_CODE,
    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 LOOKUP_TYPE = X_LOOKUP_TYPE
  and SECURITY_GROUP_ID = sgid
  and VIEW_APPLICATION_ID = X_VIEW_APPLICATION_ID
  and LOOKUP_CODE = X_LOOKUP_CODE;

Line: 369

  update FND_LOOKUP_VALUES set
    MEANING = X_MEANING,
    DESCRIPTION = X_DESCRIPTION,
    SOURCE_LANG = userenv('LANG')
  where LOOKUP_TYPE = X_LOOKUP_TYPE
  and SECURITY_GROUP_ID = sgid
  and VIEW_APPLICATION_ID = X_VIEW_APPLICATION_ID
  and LOOKUP_CODE = X_LOOKUP_CODE
  and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line: 389

  select userenv('LANG')
  into X_LANG
  from dual;

Line: 393

  wf_event.raise(p_event_name => 'oracle.apps.fnd.lookup.code.update',
                 p_event_key => X_LOOKUP_TYPE||':'||X_VIEW_APPLICATION_ID||
                 ':'||X_SECURITY_GROUP_ID||':'||X_LANG||':'||X_LOOKUP_CODE,
                 p_event_data => NULL,
                 p_parameters => NULL,
                 p_send_date => Sysdate);

Line: 403

end UPDATE_ROW;

Line: 424

    X_LAST_UPDATE_DATE    => null,
    X_CUSTOM_MODE         => null);

Line: 437

  X_LAST_UPDATE_DATE    in VARCHAR2,
  X_CUSTOM_MODE         in VARCHAR2
) is
  sgid      NUMBER;  -- security group id, added for Bug 2103124

Line: 442

  f_ludate  date;    -- entity update date in file

Line: 444

  db_ludate date;    -- entity update date in db

Line: 459

  f_ludate := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);

Line: 461

  select LAST_UPDATED_BY, LAST_UPDATE_DATE
  into db_luby, db_ludate
  from fnd_lookup_values
  where LOOKUP_TYPE       = X_LOOKUP_TYPE
  and SECURITY_GROUP_ID   = sgid
  and VIEW_APPLICATION_ID = X_VIEW_APPLICATION_ID
  and LOOKUP_CODE         = X_LOOKUP_CODE
  and LANGUAGE            = userenv('LANG');

Line: 472

    update FND_LOOKUP_VALUES set
      MEANING           = nvl(X_MEANING, meaning),
      DESCRIPTION       = nvl(X_DESCRIPTION, description),
      LAST_UPDATE_DATE  = f_ludate,
      LAST_UPDATED_BY   = f_luby,
      LAST_UPDATE_LOGIN = 0,
      SOURCE_LANG       = userenv('LANG')
    where LOOKUP_TYPE       = X_LOOKUP_TYPE
    and SECURITY_GROUP_ID   = sgid
    and VIEW_APPLICATION_ID = X_VIEW_APPLICATION_ID
    and LOOKUP_CODE         = X_LOOKUP_CODE
    and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line: 491

    select userenv('LANG')
    into X_LANG
    from dual;

Line: 495

    wf_event.raise(p_event_name => 'oracle.apps.fnd.lookup.code.update',
                   p_event_key => X_LOOKUP_TYPE||':'||X_VIEW_APPLICATION_ID||
                   ':'||X_SECURITY_GROUP_ID||':'||X_LANG||':'||X_LOOKUP_CODE,
                   p_event_data => NULL,
                   p_parameters => NULL,
                   p_send_date => Sysdate);

Line: 512

procedure DELETE_ROW (
  X_LOOKUP_TYPE in VARCHAR2,
  X_SECURITY_GROUP_ID in NUMBER default NULL,
  X_VIEW_APPLICATION_ID in NUMBER,
  X_LOOKUP_CODE in VARCHAR2
) is
  sgid NUMBER;

Line: 528

  delete from FND_LOOKUP_VALUES
  where LOOKUP_TYPE = X_LOOKUP_TYPE
  and SECURITY_GROUP_ID = sgid
  and VIEW_APPLICATION_ID = X_VIEW_APPLICATION_ID
  and LOOKUP_CODE = X_LOOKUP_CODE;

Line: 544

  select userenv('LANG')
  into X_LANG
  from dual;

Line: 548

  wf_event.raise(p_event_name => 'oracle.apps.fnd.lookup.code.delete',
                 p_event_key => X_LOOKUP_TYPE||':'||X_VIEW_APPLICATION_ID||
                 ':'||X_SECURITY_GROUP_ID||':'||X_LANG||':'||X_LOOKUP_CODE,
                 p_event_data => NULL,
                   p_parameters => NULL,
                   p_send_date => Sysdate);

Line: 558

end DELETE_ROW;

Line: 564

/* The following update statements are commented out */
/* as a quick workaround to fix the time-consuming table handler issue */
/* Eventually we'll need to turn them into a separate fix_language procedure */
/*

  update FND_LOOKUP_VALUES T set (
      MEANING,
      DESCRIPTION
    ) = (select
      B.MEANING,
      B.DESCRIPTION
    from FND_LOOKUP_VALUES B
    where B.LOOKUP_TYPE = T.LOOKUP_TYPE
    and B.SECURITY_GROUP_ID = T.SECURITY_GROUP_ID
    and B.VIEW_APPLICATION_ID = T.VIEW_APPLICATION_ID
    and B.LOOKUP_CODE = T.LOOKUP_CODE
    and B.LANGUAGE = T.SOURCE_LANG)
  where (
      T.LOOKUP_TYPE,
      T.SECURITY_GROUP_ID,
      T.VIEW_APPLICATION_ID,
      T.LOOKUP_CODE,
      T.LANGUAGE
  ) in (select
      SUBT.LOOKUP_TYPE,
      SUBT.SECURITY_GROUP_ID,
      SUBT.VIEW_APPLICATION_ID,
      SUBT.LOOKUP_CODE,
      SUBT.LANGUAGE
    from FND_LOOKUP_VALUES SUBB, FND_LOOKUP_VALUES SUBT
    where SUBB.LOOKUP_TYPE = SUBT.LOOKUP_TYPE
    and SUBB.SECURITY_GROUP_ID = SUBT.SECURITY_GROUP_ID
    and SUBB.VIEW_APPLICATION_ID = SUBT.VIEW_APPLICATION_ID
    and SUBB.LOOKUP_CODE = SUBT.LOOKUP_CODE
    and SUBB.LANGUAGE = SUBT.SOURCE_LANG
    and (SUBB.MEANING <> SUBT.MEANING
      or 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)
  ))
  -- ***** BEGIN NEW CLAUSE FOR UPDATE *****
  and not exists
    (select null
    from FND_LOOKUP_VALUES DUP
    where DUP.LOOKUP_TYPE = T.LOOKUP_TYPE
    and DUP.VIEW_APPLICATION_ID = T.VIEW_APPLICATION_ID
    and DUP.SECURITY_GROUP_ID = T.SECURITY_GROUP_ID
    and DUP.LANGUAGE = T.LANGUAGE
    and (DUP.MEANING) =
      (select
         B.MEANING
       from FND_LOOKUP_VALUES B
       where B.LOOKUP_TYPE = T.LOOKUP_TYPE
       and B.SECURITY_GROUP_ID = T.SECURITY_GROUP_ID
       and B.VIEW_APPLICATION_ID = T.VIEW_APPLICATION_ID
       and B.LOOKUP_CODE = T.LOOKUP_CODE
       and B.LANGUAGE = T.SOURCE_LANG));

Line: 625

    update FND_LOOKUP_VALUES set
      MEANING = '@'||MEANING
    where (
         LOOKUP_TYPE,
         VIEW_APPLICATION_ID,
	 MEANING,
	 SECURITY_GROUP_ID,
         LANGUAGE) in
      (select
         B.LOOKUP_TYPE,
         B.VIEW_APPLICATION_ID,
	 B.MEANING,
	 B.SECURITY_GROUP_ID,
         L.LANGUAGE_CODE
       from FND_LOOKUP_VALUES B, FND_LANGUAGES L
       where L.INSTALLED_FLAG in ('I', 'B')
       and B.LANGUAGE = userenv('LANG')
       and not exists
         (select NULL
          from FND_LOOKUP_VALUES T
          where T.LOOKUP_TYPE = B.LOOKUP_TYPE
          and T.SECURITY_GROUP_ID = B.SECURITY_GROUP_ID
          and T.VIEW_APPLICATION_ID = B.VIEW_APPLICATION_ID
          and T.LOOKUP_CODE = B.LOOKUP_CODE
          and T.LANGUAGE = L.LANGUAGE_CODE));

Line: 656

  insert into FND_LOOKUP_VALUES (
    TAG,
    ATTRIBUTE_CATEGORY,
    ATTRIBUTE1,
    ATTRIBUTE2,
    ATTRIBUTE3,
    ATTRIBUTE4,
    LOOKUP_TYPE,
    LOOKUP_CODE,
    MEANING,
    DESCRIPTION,
    ENABLED_FLAG,
    START_DATE_ACTIVE,
    END_DATE_ACTIVE,
    CREATED_BY,
    CREATION_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    LAST_UPDATE_DATE,
    SECURITY_GROUP_ID,
    VIEW_APPLICATION_ID,
    TERRITORY_CODE,
    ATTRIBUTE5,
    ATTRIBUTE6,
    ATTRIBUTE7,
    ATTRIBUTE8,
    ATTRIBUTE9,
    ATTRIBUTE10,
    ATTRIBUTE11,
    ATTRIBUTE12,
    ATTRIBUTE13,
    ATTRIBUTE14,
    ATTRIBUTE15,
    LANGUAGE,
    SOURCE_LANG
  ) select
    B.TAG,
    B.ATTRIBUTE_CATEGORY,
    B.ATTRIBUTE1,
    B.ATTRIBUTE2,
    B.ATTRIBUTE3,
    B.ATTRIBUTE4,
    B.LOOKUP_TYPE,
    B.LOOKUP_CODE,
    B.MEANING,
    B.DESCRIPTION,
    B.ENABLED_FLAG,
    B.START_DATE_ACTIVE,
    B.END_DATE_ACTIVE,
    B.CREATED_BY,
    B.CREATION_DATE,
    B.LAST_UPDATED_BY,
    B.LAST_UPDATE_LOGIN,
    B.LAST_UPDATE_DATE,
    B.SECURITY_GROUP_ID,
    B.VIEW_APPLICATION_ID,
    B.TERRITORY_CODE,
    B.ATTRIBUTE5,
    B.ATTRIBUTE6,
    B.ATTRIBUTE7,
    B.ATTRIBUTE8,
    B.ATTRIBUTE9,
    B.ATTRIBUTE10,
    B.ATTRIBUTE11,
    B.ATTRIBUTE12,
    B.ATTRIBUTE13,
    B.ATTRIBUTE14,
    B.ATTRIBUTE15,
    L.LANGUAGE_CODE,
    B.SOURCE_LANG
  from FND_LOOKUP_VALUES B, FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and B.LANGUAGE = userenv('LANG')
  and not exists
    (select NULL
    from FND_LOOKUP_VALUES T
    where T.LOOKUP_TYPE = B.LOOKUP_TYPE
    and T.SECURITY_GROUP_ID = B.SECURITY_GROUP_ID
    and T.VIEW_APPLICATION_ID = B.VIEW_APPLICATION_ID
    and T.LOOKUP_CODE = B.LOOKUP_CODE
    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 765

  x_last_update_date      in varchar2,
  x_owner                 in varchar2,
  x_meaning               in varchar2,
  x_description           in varchar2,
  x_security_group        in varchar2,
  x_custom_mode           in varchar2)
is
  view_appid number;

Line: 776

  f_ludate  date;    -- entity update date in file

Line: 778

  db_ludate date;    -- entity update date in db

Line: 781

    select SG.SECURITY_GROUP_ID
    from FND_LOOKUP_TYPES LT, FND_SECURITY_GROUPS SG
    where LT.LOOKUP_TYPE = x_lookup_type
    and LT.VIEW_APPLICATION_ID = view_appid
    and LT.SECURITY_GROUP_ID = SG.SECURITY_GROUP_ID
    and SG.SECURITY_GROUP_KEY like nvl(x_security_group, 'STANDARD');

Line: 790

  select APPLICATION_ID
  into view_appid
  from FND_APPLICATION
  where APPLICATION_SHORT_NAME = x_view_appsname;

Line: 799

  f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);

Line: 804

    select LAST_UPDATED_BY, LAST_UPDATE_DATE
    into db_luby, db_ludate
    from fnd_lookup_values_vl
    where LOOKUP_TYPE       = X_LOOKUP_TYPE
    and SECURITY_GROUP_ID   = secgrp.security_group_id
    and VIEW_APPLICATION_ID = view_appid
    and LOOKUP_CODE         = X_LOOKUP_CODE;

Line: 814

      Fnd_Lookup_Values_Pkg.Update_Row (
        X_LOOKUP_TYPE           => x_lookup_type,
        X_SECURITY_GROUP_ID     => secgrp.security_group_id,
        X_VIEW_APPLICATION_ID   => view_appid,
        X_LOOKUP_CODE           => x_lookup_code,
        X_TAG                   => x_tag,
        X_ATTRIBUTE_CATEGORY    => x_attribute_category,
        X_ATTRIBUTE1            => x_attribute1,
        X_ATTRIBUTE2            => x_attribute2,
        X_ATTRIBUTE3            => x_attribute3,
        X_ATTRIBUTE4            => x_attribute4,
        X_ENABLED_FLAG          => x_enabled_flag,
        X_START_DATE_ACTIVE     => to_date(x_start_date_active,
                                            'YYYY/MM/DD'),
        X_END_DATE_ACTIVE       => to_date(x_end_date_active,
                                            'YYYY/MM/DD'),
        X_TERRITORY_CODE        => x_territory_code,
        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_MEANING               => x_meaning,
        X_DESCRIPTION           => x_description,
        X_LAST_UPDATE_DATE      => f_ludate,
        X_LAST_UPDATED_BY       => f_luby,
        X_LAST_UPDATE_LOGIN     => 0);

Line: 851

        Fnd_Lookup_Values_Pkg.Insert_Row(
          X_ROWID               => row_id,
          X_LOOKUP_TYPE         => x_lookup_type,
          X_SECURITY_GROUP_ID   => secgrp.security_group_id,
          X_VIEW_APPLICATION_ID => view_appid,
          X_LOOKUP_CODE         => x_lookup_code,
          X_TAG                 => x_tag,
          X_ATTRIBUTE_CATEGORY  => x_attribute_category,
          X_ATTRIBUTE1          => x_attribute1,
          X_ATTRIBUTE2          => x_attribute2,
          X_ATTRIBUTE3          => x_attribute3,
          X_ATTRIBUTE4          => x_attribute4,
          X_ENABLED_FLAG        => x_enabled_flag,
          X_START_DATE_ACTIVE   => to_date(x_start_date_active,
                                            'YYYY/MM/DD'),
          X_END_DATE_ACTIVE     => to_date(x_end_date_active,
                                            'YYYY/MM/DD'),
          X_TERRITORY_CODE      => x_territory_code,
          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_MEANING             => x_meaning,
          X_DESCRIPTION         => x_description,
          X_CREATION_DATE       => f_ludate,
          X_CREATED_BY          => f_luby,
          X_LAST_UPDATE_DATE    => f_ludate,
          X_LAST_UPDATED_BY     => f_luby,
          X_LAST_UPDATE_LOGIN   => 0);