APPS.FND_MO_PRODUCT_INIT_PKG SQL Statements

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

Line: 30

    delete from FND_MO_PRODUCT_INIT
    where APPLICATION_SHORT_NAME = upper(p_appl_short_name);

Line: 75

                               p_last_update_date   in varchar2,
			       p_custom_mode        in varchar2) is
  f_luby    number;  -- entity owner in file

Line: 78

  f_ludate  date;    -- entity update date in file

Line: 80

  db_ludate date;    -- entity update date in db

Line: 83

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

Line: 86

         select LAST_UPDATED_BY, LAST_UPDATE_DATE
           into db_luby, db_ludate
           from FND_MO_PRODUCT_INIT
          where application_short_name = upper(p_appl_short_name);

Line: 93

      update FND_MO_PRODUCT_INIT
      set LAST_UPDATED_BY = f_luby,
          LAST_UPDATE_DATE = f_ludate,
          LAST_UPDATE_LOGIN = 0,
          STATUS = nvl(p_status,'N')
      where APPLICATION_SHORT_NAME = upper(p_appl_short_name);

Line: 104

      insert into FND_MO_PRODUCT_INIT(
            APPLICATION_SHORT_NAME,
            LAST_UPDATE_DATE,
            LAST_UPDATED_BY,
            CREATION_DATE,
            CREATED_BY,
            LAST_UPDATE_LOGIN,
            STATUS)
      values(
            upper(p_appl_short_name),
            f_ludate,
            f_luby,
            f_ludate,
            f_luby,
            0,
            nvl(upper(p_status),'N'));