The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT ID
,OBJECT_VERSION_NUMBER
,GTS_ID
,VERSION
,START_DATE
,END_DATE
,TMPT_STATUS
,ATTRIBUTE_CATEGORY
,ATTRIBUTE1
,ATTRIBUTE2
,ATTRIBUTE3
,ATTRIBUTE4
,ATTRIBUTE5
,ATTRIBUTE6
,ATTRIBUTE7
,ATTRIBUTE8
,ATTRIBUTE9
,ATTRIBUTE10
,ATTRIBUTE11
,ATTRIBUTE12
,ATTRIBUTE13
,ATTRIBUTE14
,ATTRIBUTE15
,ORG_ID
,CREATED_BY
,CREATION_DATE
,LAST_UPDATED_BY
,LAST_UPDATE_DATE
,LAST_UPDATE_LOGIN
FROM OKL_ST_GEN_TEMPLATES
WHERE OKL_ST_GEN_TEMPLATES.id = p_id;
,l_gtt_rec.last_updated_by
,l_gtt_rec.last_update_date
,l_gtt_rec.last_update_login;
SELECT ID
,OBJECT_VERSION_NUMBER
,GTS_ID
,VERSION
,START_DATE
,END_DATE
,TMPT_STATUS
,ATTRIBUTE_CATEGORY
,ATTRIBUTE1
,ATTRIBUTE2
,ATTRIBUTE3
,ATTRIBUTE4
,ATTRIBUTE5
,ATTRIBUTE6
,ATTRIBUTE7
,ATTRIBUTE8
,ATTRIBUTE9
,ATTRIBUTE10
,ATTRIBUTE11
,ATTRIBUTE12
,ATTRIBUTE13
,ATTRIBUTE14
,ATTRIBUTE15
,ORG_ID
,CREATED_BY
,CREATION_DATE
,LAST_UPDATED_BY
,LAST_UPDATE_DATE
,LAST_UPDATE_LOGIN
FROM OKL_ST_GEN_TEMPLATES
WHERE OKL_ST_GEN_TEMPLATES.ID = p_id;
,l_gttv_rec.last_updated_by
,l_gttv_rec.last_update_date
,l_gttv_rec.last_update_login;
SELECT '1'
FROM OKL_ST_GEN_TMPT_SETS
WHERE OKL_ST_GEN_TMPT_SETS.ID = p_gts_id;
IF (l_gttv_rec.last_updated_by = Okl_Api.G_MISS_NUM) THEN
l_gttv_rec.last_updated_by := NULL;
IF (l_gttv_rec.last_update_date = Okl_Api.G_MISS_DATE) THEN
l_gttv_rec.last_update_date := NULL;
IF (l_gttv_rec.last_update_login = Okl_Api.G_MISS_NUM) THEN
l_gttv_rec.last_update_login := NULL;
p_to.last_updated_by := p_from.last_updated_by;
p_to.last_update_date := p_from.last_update_date;
p_to.last_update_login := p_from.last_update_login;
p_to.last_updated_by := p_from.last_updated_by;
p_to.last_update_date := p_from.last_update_date;
p_to.last_update_login := p_from.last_update_login;
PROCEDURE insert_row(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_gtt_rec IN gtt_rec_type,
x_gtt_rec OUT NOCOPY gtt_rec_type ) AS
-- Local Variables within the function
l_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'insert_row';
INSERT INTO OKL_ST_GEN_TEMPLATES(
id
,object_version_number
,gts_id
,version
,start_date
,end_date
,tmpt_status
,attribute_category
,attribute1
,attribute2
,attribute3
,attribute4
,attribute5
,attribute6
,attribute7
,attribute8
,attribute9
,attribute10
,attribute11
,attribute12
,attribute13
,attribute14
,attribute15
,org_id
,created_by
,creation_date
,last_updated_by
,last_update_date
,last_update_login
)
VALUES (
l_gtt_rec.id
,l_gtt_rec.object_version_number
,l_gtt_rec.gts_id
,l_gtt_rec.version
,l_gtt_rec.start_date
,l_gtt_rec.end_date
,l_gtt_rec.tmpt_status
,l_gtt_rec.attribute_category
,l_gtt_rec.attribute1
,l_gtt_rec.attribute2
,l_gtt_rec.attribute3
,l_gtt_rec.attribute4
,l_gtt_rec.attribute5
,l_gtt_rec.attribute6
,l_gtt_rec.attribute7
,l_gtt_rec.attribute8
,l_gtt_rec.attribute9
,l_gtt_rec.attribute10
,l_gtt_rec.attribute11
,l_gtt_rec.attribute12
,l_gtt_rec.attribute13
,l_gtt_rec.attribute14
,l_gtt_rec.attribute15
,l_gtt_rec.org_id
,l_gtt_rec.created_by
,l_gtt_rec.creation_date
,l_gtt_rec.last_updated_by
,l_gtt_rec.last_update_date
,l_gtt_rec.last_update_login
);
END insert_row;
PROCEDURE insert_row(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_gttv_rec IN gttv_rec_type,
x_gttv_rec OUT NOCOPY gttv_rec_type ) IS
-- Local Variables within the function
l_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'V_insert_row';
l_gttv_rec.LAST_UPDATE_DATE := SYSDATE;
l_gttv_rec.LAST_UPDATED_BY := Fnd_Global.USER_ID;
l_gttv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
insert_row (
p_api_version => l_api_version
,p_init_msg_list => p_init_msg_list
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data
,p_gtt_rec => l_gtt_rec
,x_gtt_rec => lx_gtt_rec
);
END; -- insert_row
PROCEDURE insert_row(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_gttv_tbl IN gttv_tbl_type,
x_gttv_tbl OUT NOCOPY gttv_tbl_type) IS
l_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
insert_row (
p_api_version => p_api_version,
p_init_msg_list => Okl_Api.G_FALSE,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_gttv_rec => p_gttv_tbl(i),
x_gttv_rec => x_gttv_tbl(i));
END insert_row;
PROCEDURE update_row(
p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_gtt_rec IN gtt_rec_type,
x_gtt_rec OUT NOCOPY gtt_rec_type) IS
l_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'OPTS_update_row';
IF (x_gtt_rec.last_updated_by = Okl_Api.G_MISS_NUM)
THEN
x_gtt_rec.last_updated_by := l_gtt_rec.last_updated_by;
IF (x_gtt_rec.last_update_date = Okl_Api.G_MISS_DATE)
THEN
x_gtt_rec.last_update_date := l_gtt_rec.last_update_date;
IF (x_gtt_rec.last_update_login = Okl_Api.G_MISS_NUM)
THEN
x_gtt_rec.last_update_login := l_gtt_rec.last_update_login;
UPDATE OKL_ST_GEN_TEMPLATES
SET ID = l_def_gtt_rec.id
,OBJECT_VERSION_NUMBER = l_def_gtt_rec.object_version_number
,GTS_ID = l_def_gtt_rec.gts_id
,VERSION = l_def_gtt_rec.version
,START_DATE = l_def_gtt_rec.start_date
,END_DATE = l_def_gtt_rec.end_date
,TMPT_STATUS = l_def_gtt_rec.tmpt_status
,ATTRIBUTE_CATEGORY = l_def_gtt_rec.attribute_category
,ATTRIBUTE1 = l_def_gtt_rec.attribute1
,ATTRIBUTE2 = l_def_gtt_rec.attribute2
,ATTRIBUTE3 = l_def_gtt_rec.attribute3
,ATTRIBUTE4 = l_def_gtt_rec.attribute4
,ATTRIBUTE5 = l_def_gtt_rec.attribute5
,ATTRIBUTE6 = l_def_gtt_rec.attribute6
,ATTRIBUTE7 = l_def_gtt_rec.attribute7
,ATTRIBUTE8 = l_def_gtt_rec.attribute8
,ATTRIBUTE9 = l_def_gtt_rec.attribute9
,ATTRIBUTE10 = l_def_gtt_rec.attribute10
,ATTRIBUTE11 = l_def_gtt_rec.attribute11
,ATTRIBUTE12 = l_def_gtt_rec.attribute12
,ATTRIBUTE13 = l_def_gtt_rec.attribute13
,ATTRIBUTE14 = l_def_gtt_rec.attribute14
,ATTRIBUTE15 = l_def_gtt_rec.attribute15
,ORG_ID = l_def_gtt_rec.org_id
,CREATED_BY = l_def_gtt_rec.created_by
,CREATION_DATE = l_def_gtt_rec.creation_date
,LAST_UPDATED_BY = l_def_gtt_rec.last_updated_by
,LAST_UPDATE_DATE = l_def_gtt_rec.last_update_date
,LAST_UPDATE_LOGIN = l_def_gtt_rec.last_update_login
WHERE ID = l_def_gtt_rec.id;
END update_row;
PROCEDURE update_row(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_gttv_rec IN gttv_rec_type,
x_gttv_rec OUT NOCOPY gttv_rec_type) IS
l_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
l_gttv_rec.LAST_UPDATE_DATE := SYSDATE;
l_gttv_rec.LAST_UPDATED_BY := Fnd_Global.USER_ID;
l_gttv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
IF (x_gttv_rec.last_updated_by = Okl_Api.G_MISS_NUM)
THEN
x_gttv_rec.last_updated_by := l_gttv_rec.last_updated_by;
IF (x_gttv_rec.last_update_date = Okl_Api.G_MISS_DATE)
THEN
x_gttv_rec.last_update_date := l_gttv_rec.last_update_date;
IF (x_gttv_rec.last_update_login = Okl_Api.G_MISS_NUM)
THEN
x_gttv_rec.last_update_login := l_gttv_rec.last_update_login;
update_row(
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_gtt_rec => l_gtt_rec,
x_gtt_rec => lx_gtt_rec
);
PROCEDURE update_row(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_gttv_tbl IN gttv_tbl_type,
x_gttv_tbl OUT NOCOPY gttv_tbl_type) IS
l_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
update_row (
p_api_version => p_api_version,
p_init_msg_list => Okl_Api.G_FALSE,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_gttv_rec => p_gttv_tbl(i),
x_gttv_rec => x_gttv_tbl(i));
END update_row;
PROCEDURE delete_row(
p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_gtt_rec IN gtt_rec_type) IS
l_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'OPTS_delete_row';
DELETE FROM OKL_ST_GEN_TEMPLATES
WHERE ID = l_gtt_rec.id;
END delete_row;
PROCEDURE delete_row(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_gttv_rec IN gttv_rec_type) IS
l_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
delete_row(
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_gtt_rec => l_gtt_rec
);
END delete_row;
PROCEDURE delete_row(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_gttv_tbl IN gttv_tbl_type) IS
l_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';
delete_row (
p_api_version => p_api_version,
p_init_msg_list => Okl_Api.G_FALSE,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_gttv_rec => p_gttv_tbl(i));
END delete_row;