APPS.FND_PRODUCT_INITIALIZATION_PKG SQL Statements

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

Line: 17

          x_last_update_date    => null,
          x_custom_mode         => null);

Line: 31

    delete from FND_PRODUCT_INITIALIZATION
    where APPLICATION_SHORT_NAME = upper(x_apps_name);

Line: 63

                  x_last_update_date       => null,
                  x_custom_mode            => null);

Line: 80

    delete from FND_PRODUCT_INIT_CONDITION
    where APPLICATION_SHORT_NAME = upper(x_apps_name)
    and   RE_INIT_CONDITION = upper(x_condition);

Line: 112

               x_last_update_date       => null,
               x_custom_mode            => null);

Line: 130

    delete from FND_PRODUCT_INIT_DEPENDENCY
    where APPLICATION_SHORT_NAME = upper(x_apps_name)
    and   PRODUCT_DEPENDENCY = upper(x_dependency);

Line: 172

  select distinct PRODUCT_DEPENDENCY, LEVEL
  from FND_PRODUCT_INIT_DEPENDENCY p1
  where LEVEL =
    (select max(LEVEL)
     from FND_PRODUCT_INIT_DEPENDENCY p2
     where p2.PRODUCT_DEPENDENCY = p1.PRODUCT_DEPENDENCY
     connect by prior p2.PRODUCT_DEPENDENCY = p2.APPLICATION_SHORT_NAME
     start with p2.APPLICATION_SHORT_NAME = upper(x_apps_name))
  connect by prior PRODUCT_DEPENDENCY = APPLICATION_SHORT_NAME
  start with APPLICATION_SHORT_NAME = upper(x_apps_name)
  order by LEVEL desc;

Line: 272

      /* sqlbuf := 'select INIT_FUNCTION_NAME '||
      'from FND_PRODUCT_INITIALIZATION '||
      'where APPLICATION_SHORT_NAME = :v1 '||
      'and exists '||
      '(select 1 '||
      'from FND_PRODUCT_INIT_CONDITION C '||
      'where C.APPLICATION_SHORT_NAME = :v2 '||
      'and C.RE_INIT_CONDITION in ('||conditions||'))';

Line: 298

         select INIT_FUNCTION_NAME
         into init_function
         from FND_PRODUCT_INITIALIZATION
         where APPLICATION_SHORT_NAME = deparr(i)
         and exists
          (select 1
           from FND_PRODUCT_INIT_CONDITION C
           where C.APPLICATION_SHORT_NAME = deparr(i)
           and C.RE_INIT_CONDITION in (strings(1)));

Line: 308

         select INIT_FUNCTION_NAME
         into init_function
         from FND_PRODUCT_INITIALIZATION
         where APPLICATION_SHORT_NAME = deparr(i)
         and exists
          (select 1
           from FND_PRODUCT_INIT_CONDITION C
           where C.APPLICATION_SHORT_NAME = deparr(i)
           and C.RE_INIT_CONDITION in (strings(1), strings(2)));

Line: 318

         select INIT_FUNCTION_NAME
         into init_function
         from FND_PRODUCT_INITIALIZATION
         where APPLICATION_SHORT_NAME = deparr(i)
         and exists
          (select 1
           from FND_PRODUCT_INIT_CONDITION C
           where C.APPLICATION_SHORT_NAME = deparr(i)
           and C.RE_INIT_CONDITION in (strings(1), strings(2), strings(3)));

Line: 328

         select INIT_FUNCTION_NAME
         into init_function
         from FND_PRODUCT_INITIALIZATION
         where APPLICATION_SHORT_NAME = deparr(i)
         and exists
         (select 1
          from FND_PRODUCT_INIT_CONDITION C
          where C.APPLICATION_SHORT_NAME = deparr(i)
          and C.RE_INIT_CONDITION in (strings(1), strings(2), strings(3), strings(4)));

Line: 338

         select INIT_FUNCTION_NAME
         into init_function
         from FND_PRODUCT_INITIALIZATION
         where APPLICATION_SHORT_NAME = deparr(i)
         and exists
         (select 1
          from FND_PRODUCT_INIT_CONDITION C
          where C.APPLICATION_SHORT_NAME = deparr(i)
          and C.RE_INIT_CONDITION in (strings(1), strings(2), strings(3), strings(4), strings(5)));

Line: 348

         select INIT_FUNCTION_NAME
         into init_function
         from FND_PRODUCT_INITIALIZATION
         where APPLICATION_SHORT_NAME = deparr(i)
         and exists
         (select 1
          from FND_PRODUCT_INIT_CONDITION C
          where C.APPLICATION_SHORT_NAME = deparr(i)
          and C.RE_INIT_CONDITION in (strings(1), strings(2), strings(3), strings(4), strings(5), strings(6)));

Line: 358

         select INIT_FUNCTION_NAME
         into init_function
         from FND_PRODUCT_INITIALIZATION
         where APPLICATION_SHORT_NAME = deparr(i)
         and exists
         (select 1
          from FND_PRODUCT_INIT_CONDITION C
          where C.APPLICATION_SHORT_NAME = deparr(i)
          and C.RE_INIT_CONDITION in (strings(1), strings(2), strings(3), strings(4), strings(5), strings(6), strings(7)));

Line: 368

         select INIT_FUNCTION_NAME
         into init_function
         from FND_PRODUCT_INITIALIZATION
         where APPLICATION_SHORT_NAME = deparr(i)
         and exists
         (select 1
          from FND_PRODUCT_INIT_CONDITION C
          where C.APPLICATION_SHORT_NAME = deparr(i)
          and C.RE_INIT_CONDITION in (strings(1), strings(2), strings(3), strings(4), strings(5), strings(6), strings(7), strings(8)));

Line: 378

         select INIT_FUNCTION_NAME
         into init_function
         from FND_PRODUCT_INITIALIZATION
         where APPLICATION_SHORT_NAME = deparr(i)
         and exists
         (select 1
          from FND_PRODUCT_INIT_CONDITION C
          where C.APPLICATION_SHORT_NAME = deparr(i)
          and C.RE_INIT_CONDITION in (strings(1), strings(2), strings(3), strings(4), strings(5), strings(6), strings(7), strings(8), strings(9)));

Line: 388

         select INIT_FUNCTION_NAME
         into init_function
         from FND_PRODUCT_INITIALIZATION
         where APPLICATION_SHORT_NAME = deparr(i)
         and exists
         (select 1
          from FND_PRODUCT_INIT_CONDITION C
          where C.APPLICATION_SHORT_NAME = deparr(i)
          and C.RE_INIT_CONDITION in (strings(1), strings(2), strings(3), strings(4), strings(5), strings(6), strings(7), strings(8), strings(9), strings(10)));

Line: 473

                   x_last_update_date   in varchar2,
                   x_custom_mode        in varchar2) is
  f_luby    number;  -- entity owner in file

Line: 476

  f_ludate  date;    -- entity update date in file

Line: 478

  db_ludate date;    -- entity update date in db

Line: 485

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

Line: 488

    select LAST_UPDATED_BY, LAST_UPDATE_DATE
    into db_luby, db_ludate
    from FND_PRODUCT_INITIALIZATION
    where APPLICATION_SHORT_NAME = upper(x_apps_name);

Line: 496

     update FND_PRODUCT_INITIALIZATION
     set INIT_FUNCTION_NAME = upper(x_init_function),
        LAST_UPDATED_BY = f_luby,
        LAST_UPDATE_DATE = f_ludate,
        LAST_UPDATE_LOGIN = f_luby
     where APPLICATION_SHORT_NAME = upper(x_apps_name);

Line: 506

      insert into FND_PRODUCT_INITIALIZATION(
      APPLICATION_SHORT_NAME,
      INIT_FUNCTION_NAME,
      LAST_UPDATED_BY,
      LAST_UPDATE_DATE,
      LAST_UPDATE_LOGIN,
      CREATION_DATE,
      CREATED_BY)
      values(
      upper(x_apps_name),
      upper(x_init_function),
      f_luby,
      f_ludate,
      f_luby,
      f_ludate,
      f_luby);

Line: 544

                        x_last_update_date   in varchar2,
                        x_custom_mode        in varchar2) is

  f_luby    number;  -- entity owner in file

Line: 548

  f_ludate  date;    -- entity update date in file

Line: 555

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

Line: 558

    insert into FND_PRODUCT_INIT_DEPENDENCY(
    APPLICATION_SHORT_NAME,
    PRODUCT_DEPENDENCY,
    LAST_UPDATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATE_LOGIN,
    CREATION_DATE,
    CREATED_BY)
    values(
    upper(x_apps_name),
    upper(x_dependency),
    f_luby,
    f_ludate,
    f_luby,
    f_ludate,
    f_luby);

Line: 600

                           x_last_update_date   in varchar2,
                           x_custom_mode        in varchar2) is

  f_luby    number;  -- entity owner in file

Line: 604

  f_ludate  date;    -- entity update date in file

Line: 611

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

Line: 614

    insert into FND_PRODUCT_INIT_CONDITION(
    APPLICATION_SHORT_NAME,
    RE_INIT_CONDITION,
    LAST_UPDATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATE_LOGIN,
    CREATION_DATE,
    CREATED_BY)
    values(
    upper(x_apps_name),
    upper(x_condition),
    f_luby,
    f_ludate,
    f_luby,
    f_ludate,
    f_luby);

Line: 675

  delete from fnd_product_init_dependency
  where application_short_name = apps_short_name;

Line: 678

  delete from fnd_product_init_condition
  where application_short_name = apps_short_name;

Line: 681

  delete from fnd_product_initialization
  where application_short_name = apps_short_name;