The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE insert_row(
x_rowid IN OUT NOCOPY VARCHAR2
, x_milcs_type_id NUMBER
, x_object_version_number NUMBER
, x_created_by NUMBER
, x_creation_date DATE
, x_last_updated_by NUMBER
, x_last_update_date DATE
, x_last_update_login NUMBER
, x_milcs_code VARCHAR2
, x_short_description VARCHAR2
) IS
CURSOR l_insert IS
SELECT ROWID
FROM jtf_ih_media_itm_lc_seg_tys
WHERE milcs_type_id = x_milcs_type_id;
INSERT INTO jtf_ih_media_itm_lc_seg_tys (
milcs_type_id
, object_version_number
, created_by
, creation_date
, last_updated_by
, last_update_date
, last_update_login
, milcs_code
, short_description
) VALUES (
x_milcs_type_id
, DECODE(x_object_version_number,FND_API.G_MISS_NUM,NULL,x_object_version_number)
, DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
, DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)
, DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
, DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
, DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
, DECODE(x_milcs_code,FND_API.G_MISS_CHAR,NULL,x_milcs_code)
, DECODE(x_short_description,FND_API.G_MISS_CHAR,NULL,x_short_description)
);
OPEN l_insert;
FETCH l_insert INTO x_rowid;
IF (l_insert%NOTFOUND) THEN
CLOSE l_insert;
END insert_row;
PROCEDURE delete_row(
x_milcs_type_id NUMBER
) IS
BEGIN
DELETE FROM jtf_ih_media_itm_lc_seg_tys
WHERE milcs_type_id = x_milcs_type_id;
END delete_row;
PROCEDURE update_row(
x_milcs_type_id NUMBER
, x_object_version_number NUMBER
, x_last_updated_by NUMBER
, x_last_update_date DATE
, x_last_update_login NUMBER
, x_milcs_code VARCHAR2
, x_short_description VARCHAR2
) IS
BEGIN
UPDATE jtf_ih_media_itm_lc_seg_tys
SET
milcs_type_id=DECODE(x_milcs_type_id,FND_API.G_MISS_NUM,NULL,x_milcs_type_id)
, object_version_number=DECODE(x_object_version_number,FND_API.G_MISS_NUM,NULL,x_object_version_number)
, last_updated_by=DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
, last_update_date=DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
, last_update_login=DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
, milcs_code=DECODE(x_milcs_code,FND_API.G_MISS_CHAR,NULL,x_milcs_code)
, short_description=DECODE(x_short_description,FND_API.G_MISS_CHAR,NULL,x_short_description)
WHERE milcs_type_id = x_milcs_type_id;
END update_row;
, x_last_updated_by NUMBER
, x_last_update_date DATE
, x_last_update_login NUMBER
, x_milcs_code VARCHAR2
, x_short_description VARCHAR2
) IS
CURSOR l_lock IS
SELECT *
FROM jtf_ih_media_itm_lc_seg_tys
WHERE rowid = x_rowid
FOR UPDATE OF milcs_type_id NOWAIT;
FND_MESSAGE.SET_NAME('FND','FORM_RECORD_DELETED');
AND ((l_table_rec.last_updated_by = x_last_updated_by)
OR ((l_table_rec.last_updated_by IS NULL)
AND ( x_last_updated_by IS NULL)))
AND ((l_table_rec.last_update_date = x_last_update_date)
OR ((l_table_rec.last_update_date IS NULL)
AND ( x_last_update_date IS NULL)))
AND ((l_table_rec.last_update_login = x_last_update_login)
OR ((l_table_rec.last_update_login IS NULL)
AND ( x_last_update_login IS NULL)))
AND ((l_table_rec.milcs_code = x_milcs_code)
OR ((l_table_rec.milcs_code IS NULL)
AND ( x_milcs_code IS NULL)))
AND ((l_table_rec.short_description = x_short_description)
OR ((l_table_rec.short_description IS NULL)
AND ( x_short_description IS NULL)))
) THEN
RETURN;
FND_MESSAGE.SET_NAME('FND','FORM_RECORD_DELETED');
l_last_update_date DATE;
l_last_updated_by NUMBER;
l_last_update_login NUMBER;
l_last_update_date := sysdate;
l_last_updated_by := user_id;
l_last_update_login := 0;
UPDATE_ROW(
X_MILCS_TYPE_ID => l_milcs_type_id,
X_OBJECT_VERSION_NUMBER => l_object_version_number,
X_MILCS_CODE => l_milcs_code,
X_SHORT_DESCRIPTION => l_short_description,
X_LAST_UPDATE_DATE => l_last_update_date,
X_LAST_UPDATED_BY => l_last_updated_by,
X_LAST_UPDATE_LOGIN => l_last_update_login);
INSERT_ROW(
row_id,
X_MILCS_TYPE_ID => l_milcs_type_id,
X_OBJECT_VERSION_NUMBER => l_object_version_number,
X_MILCS_CODE => l_milcs_code,
X_SHORT_DESCRIPTION => l_short_description,
X_CREATION_DATE => l_creation_date,
X_CREATED_BY => l_created_by,
X_LAST_UPDATE_DATE => l_last_update_date,
X_LAST_UPDATED_BY => l_last_updated_by,
X_LAST_UPDATE_LOGIN => l_last_update_login);