The following lines contain the word 'select', 'insert', 'update' or 'delete':
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
;
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;
end INSERT_ROW;
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;
fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
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;
end UPDATE_ROW;
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 ;
END SELECT_ROW;
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;
end DELETE_ROW;
X_LAST_UPDATE_DATE in DATE,
X_CUSTOM_MODE in VARCHAR2
) is
l_id number;
l_f_ludate date; -- entity update date in file
l_db_ludate date; -- entity update date in db
l_f_ludate := nvl(x_last_update_date, sysdate);
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');
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
);
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
);