APPS.HZ_STYLE_FMT_LOCALES_PKG SQL Statements

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

Line: 6

procedure INSERT_ROW (
  X_ROWID in out NOCOPY VARCHAR2,
  X_STYLE_FMT_LOCALE_ID in out NOCOPY NUMBER,
  X_STYLE_FORMAT_CODE in VARCHAR2,
  X_LANGUAGE_CODE in VARCHAR2,
  X_TERRITORY_CODE in VARCHAR2,
  X_START_DATE_ACTIVE in DATE,
  X_END_DATE_ACTIVE   in DATE,
  X_OBJECT_VERSION_NUMBER in NUMBER
) is
  cursor C is select ROWID from HZ_STYLE_FMT_LOCALES
    where STYLE_FMT_LOCALE_ID = X_STYLE_FMT_LOCALE_ID
    ;

Line: 20

  insert into HZ_STYLE_FMT_LOCALES (
    STYLE_FMT_LOCALE_ID,
    STYLE_FORMAT_CODE,
    LANGUAGE_CODE,
    TERRITORY_CODE,
    START_DATE_ACTIVE,
    END_DATE_ACTIVE,
    CREATED_BY,
    CREATION_DATE,
    LAST_UPDATE_LOGIN,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    OBJECT_VERSION_NUMBER
  ) values (
    DECODE( X_STYLE_FMT_LOCALE_ID, FND_API.G_MISS_NUM, HZ_STYLE_FMT_LOCALES_S.NEXTVAL, NULL, HZ_STYLE_FMT_LOCALES_S.NEXTVAL, X_STYLE_FMT_LOCALE_ID ),
    DECODE( X_STYLE_FORMAT_CODE, FND_API.G_MISS_CHAR, NULL, X_STYLE_FORMAT_CODE ),
    DECODE( X_LANGUAGE_CODE, FND_API.G_MISS_CHAR, NULL, X_LANGUAGE_CODE ),
    DECODE( X_TERRITORY_CODE, FND_API.G_MISS_CHAR, NULL, X_TERRITORY_CODE ),
    DECODE( X_START_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, X_START_DATE_ACTIVE ),
    DECODE( X_END_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, X_END_DATE_ACTIVE ),
    NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.CREATED_BY),
    HZ_UTILITY_V2PUB.CREATION_DATE,
    NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN),
    HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
    NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.LAST_UPDATED_BY),
    DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER )
  ) RETURNING
    STYLE_FMT_LOCALE_ID
  INTO
    X_STYLE_FMT_LOCALE_ID;

Line: 59

end INSERT_ROW;

Line: 67

  cursor c is select
      STYLE_FORMAT_CODE,
      LANGUAGE_CODE,
      TERRITORY_CODE
    from HZ_STYLE_FMT_LOCALES
    where STYLE_FMT_LOCALE_ID = X_STYLE_FMT_LOCALE_ID
    for update of LANGUAGE_CODE nowait;

Line: 81

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

Line: 98

procedure UPDATE_ROW (
  X_STYLE_FMT_LOCALE_ID in NUMBER,
  X_STYLE_FORMAT_CODE in VARCHAR2,
  X_LANGUAGE_CODE in VARCHAR2,
  X_TERRITORY_CODE in VARCHAR2,
  X_START_DATE_ACTIVE in DATE,
  X_END_DATE_ACTIVE   in DATE,
  X_OBJECT_VERSION_NUMBER in NUMBER
) is
begin

  update HZ_STYLE_FMT_LOCALES set
    STYLE_FORMAT_CODE = DECODE( X_STYLE_FORMAT_CODE, NULL, STYLE_FORMAT_CODE, FND_API.G_MISS_CHAR, NULL, X_STYLE_FORMAT_CODE ),
    LANGUAGE_CODE = DECODE( X_LANGUAGE_CODE, NULL, LANGUAGE_CODE, FND_API.G_MISS_CHAR, NULL, X_LANGUAGE_CODE ),
    TERRITORY_CODE = DECODE( X_TERRITORY_CODE, NULL, TERRITORY_CODE, FND_API.G_MISS_CHAR, NULL, X_TERRITORY_CODE ),
    START_DATE_ACTIVE = DECODE( X_START_DATE_ACTIVE, NULL, START_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, X_START_DATE_ACTIVE ),
    END_DATE_ACTIVE = DECODE( X_END_DATE_ACTIVE, NULL, END_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, X_END_DATE_ACTIVE ),
    LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
    LAST_UPDATED_BY = NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.LAST_UPDATED_BY),
    LAST_UPDATE_LOGIN = NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN),
    OBJECT_VERSION_NUMBER = DECODE(X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER,
                                  FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER)
  where STYLE_FMT_LOCALE_ID = X_STYLE_FMT_LOCALE_ID;

Line: 126

end UPDATE_ROW;

Line: 128

PROCEDURE SELECT_ROW (
  X_STYLE_FMT_LOCALE_ID		IN OUT NOCOPY NUMBER,
  X_STYLE_FORMAT_CODE		OUT    NOCOPY VARCHAR2,
  X_LANGUAGE_CODE 		OUT    NOCOPY VARCHAR2,
  X_TERRITORY_CODE		OUT    NOCOPY VARCHAR2,
  X_START_DATE_ACTIVE		OUT    NOCOPY DATE,
  X_END_DATE_ACTIVE		OUT    NOCOPY DATE
) IS
BEGIN
    SELECT
        NVL( STYLE_FMT_LOCALE_ID, FND_API.G_MISS_NUM ),
        NVL( STYLE_FORMAT_CODE, FND_API.G_MISS_CHAR ),
        NVL( LANGUAGE_CODE, FND_API.G_MISS_CHAR ),
        NVL( TERRITORY_CODE, FND_API.G_MISS_CHAR ),
        NVL( START_DATE_ACTIVE, FND_API.G_MISS_DATE ),
        NVL( END_DATE_ACTIVE, FND_API.G_MISS_DATE )
    INTO X_STYLE_FMT_LOCALE_ID,
         X_STYLE_FORMAT_CODE,
	 X_LANGUAGE_CODE,
	 X_TERRITORY_CODE,
         X_START_DATE_ACTIVE,
	 X_END_DATE_ACTIVE
    FROM HZ_STYLE_FMT_LOCALES
    WHERE STYLE_FMT_LOCALE_ID = X_STYLE_FMT_LOCALE_ID ;

Line: 161

END SELECT_ROW;

Line: 165

procedure DELETE_ROW (
  X_STYLE_FMT_LOCALE_ID in NUMBER
) is
begin
  delete from HZ_STYLE_FMT_LOCALES
  where STYLE_FMT_LOCALE_ID = X_STYLE_FMT_LOCALE_ID;

Line: 175

end DELETE_ROW;

Line: 190

  X_LAST_UPDATE_DATE in DATE,
  X_CUSTOM_MODE in VARCHAR2
) is
  l_id        number;

Line: 195

  l_f_ludate  date;    -- entity update date in file

Line: 197

  l_db_ludate date;    -- entity update date in db

Line: 211

  l_f_ludate := nvl(x_last_update_date, sysdate);

Line: 215

    select STYLE_FMT_LOCALE_ID, LAST_UPDATED_BY, LAST_UPDATE_DATE,  OBJECT_VERSION_NUMBER
         into l_id, l_db_luby, l_db_ludate, l_object_version_number
         from HZ_STYLE_FMT_LOCALES
         where STYLE_FORMAT_CODE = x_style_format_code
           and nvl(LANGUAGE_CODE,'XXXX') = nvl(x_language_code,'XXXX')
           and nvl(TERRITORY_CODE,'XX') = nvl(x_territory_code,'XX');

Line: 232

      hz_style_fmt_locales_pkg.update_row (
        X_STYLE_FMT_LOCALE_ID  => l_id,
        X_STYLE_FORMAT_CODE    => X_STYLE_FORMAT_CODE,
        X_LANGUAGE_CODE        => X_LANGUAGE_CODE,
        X_TERRITORY_CODE       => X_TERRITORY_CODE,
	X_START_DATE_ACTIVE    => X_START_DATE_ACTIVE,
	X_END_DATE_ACTIVE      => X_END_DATE_ACTIVE,
	X_OBJECT_VERSION_NUMBER => l_object_version_number
      );

Line: 246

      hz_style_fmt_locales_pkg.insert_row(
          x_rowid                => l_rowid,
          x_style_fmt_locale_id  => l_id, -- will be generated
          x_style_format_code    => X_STYLE_FORMAT_CODE,
          x_language_code        => X_LANGUAGE_CODE,
          x_territory_code       => X_TERRITORY_CODE,
          x_start_date_active    => X_START_DATE_ACTIVE,
	  x_end_date_active      => X_END_DATE_ACTIVE,
	  x_object_version_number => 1
      );