The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT ID
,OBJECT_VERSION_NUMBER
,GTT_ID
,PRIMARY_YN
,PRIMARY_STY_ID
,DEPENDENT_STY_ID
,PRICING_NAME
,ORG_ID
,CREATED_BY
,CREATION_DATE
,LAST_UPDATED_BY
,LAST_UPDATE_DATE
,LAST_UPDATE_LOGIN
FROM OKL_ST_GEN_TMPT_LNS
WHERE OKL_ST_GEN_TMPT_LNS.id = p_id;
,l_gtl_rec.last_updated_by
,l_gtl_rec.last_update_date
,l_gtl_rec.last_update_login;
SELECT ID
,OBJECT_VERSION_NUMBER
,GTT_ID
,PRIMARY_YN
,PRIMARY_STY_ID
,DEPENDENT_STY_ID
,PRICING_NAME
,ORG_ID
,CREATED_BY
,CREATION_DATE
,LAST_UPDATED_BY
,LAST_UPDATE_DATE
,LAST_UPDATE_LOGIN
FROM OKL_ST_GEN_TMPT_LNS
WHERE OKL_ST_GEN_TMPT_LNS.ID = p_id;
,l_gtlv_rec.last_updated_by
,l_gtlv_rec.last_update_date
,l_gtlv_rec.last_update_login;
SELECT NAME stream_name
FROM OKL_STRM_TYPE_V
WHERE ID IN
(
SELECT primary_Sty_id
FROM OKL_ST_GEN_TMPT_LNS GTL
WHERE GTL.GTT_ID = p_gtt_id
AND GTL.PRIMARY_YN = 'Y'
AND GTL.PRIMARY_STY_ID = p_pri_sty_id
AND GTL.ID <> p_id
);
SELECT NAME stream_name
FROM OKL_STRM_TYPE_V
WHERE ID IN
(
SELECT dependent_sty_id
FROM OKL_ST_GEN_TMPT_LNS GTL
WHERE GTL.GTT_ID = p_gtt_id
AND GTL.PRIMARY_YN = 'N'
AND GTL.PRIMARY_STY_ID = p_pri_sty_id
AND GTL.DEPENDENT_STY_ID = p_dep_sty_id
AND GTL.ID <> p_id
);
SELECT '1'
FROM OKL_ST_GEN_TEMPLATES
WHERE OKL_ST_GEN_TEMPLATES.ID = p_gtt_id;
IF (l_gtlv_rec.last_updated_by = Okl_Api.G_MISS_NUM) THEN
l_gtlv_rec.last_updated_by := NULL;
IF (l_gtlv_rec.last_update_date = Okl_Api.G_MISS_DATE) THEN
l_gtlv_rec.last_update_date := NULL;
IF (l_gtlv_rec.last_update_login = Okl_Api.G_MISS_NUM) THEN
l_gtlv_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_gtl_rec IN gtl_rec_type,
x_gtl_rec OUT NOCOPY gtl_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_TMPT_LNS(
ID
,OBJECT_VERSION_NUMBER
,GTT_ID
,PRIMARY_YN
,PRIMARY_STY_ID
,DEPENDENT_STY_ID
,PRICING_NAME
,ORG_ID
,CREATED_BY
,CREATION_DATE
,LAST_UPDATED_BY
,LAST_UPDATE_DATE
,LAST_UPDATE_LOGIN
)
VALUES (
l_gtl_rec.id
,l_gtl_rec.object_version_number
,l_gtl_rec.gtt_id
,l_gtl_rec.primary_yn
,l_gtl_rec.primary_sty_id
,l_gtl_rec.dependent_sty_id
,l_gtl_rec.pricing_name
,l_gtl_rec.org_id
,l_gtl_rec.created_by
,l_gtl_rec.creation_date
,l_gtl_rec.last_updated_by
,l_gtl_rec.last_update_date
,l_gtl_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_gtlv_rec IN gtlv_rec_type,
x_gtlv_rec OUT NOCOPY gtlv_rec_type ) IS
-- Local Variables within the function
l_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'V_insert_row';
l_gtlv_rec.LAST_UPDATE_DATE := SYSDATE;
l_gtlv_rec.LAST_UPDATED_BY := Fnd_Global.USER_ID;
l_gtlv_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_gtl_rec => l_gtl_rec
,x_gtl_rec => lx_gtl_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_gtlv_tbl IN gtlv_tbl_type,
x_gtlv_tbl OUT NOCOPY gtlv_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 => p_init_msg_list, -- Bug 4054596: Issue No. 3
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_gtlv_rec => p_gtlv_tbl(i),
x_gtlv_rec => x_gtlv_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_gtl_rec IN gtl_rec_type,
x_gtl_rec OUT NOCOPY gtl_rec_type) IS
l_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'OPTS_update_row';
IF (x_gtl_rec.last_updated_by = Okl_Api.G_MISS_NUM)
THEN
x_gtl_rec.last_updated_by := l_gtl_rec.last_updated_by;
IF (x_gtl_rec.last_update_date = Okl_Api.G_MISS_DATE)
THEN
x_gtl_rec.last_update_date := l_gtl_rec.last_update_date;
IF (x_gtl_rec.last_update_login = Okl_Api.G_MISS_NUM)
THEN
x_gtl_rec.last_update_login := l_gtl_rec.last_update_login;
UPDATE OKL_ST_GEN_TMPT_LNS
SET ID = l_def_gtl_rec.id
,OBJECT_VERSION_NUMBER = l_def_gtl_rec.object_version_number
,GTT_ID = l_def_gtl_rec.gtt_id
,PRIMARY_YN = l_def_gtl_rec.primary_yn
,PRIMARY_STY_ID = l_def_gtl_rec.primary_sty_id
,DEPENDENT_STY_ID = l_def_gtl_rec.dependent_sty_id
,PRICING_NAME = l_def_gtl_rec.pricing_name
,ORG_ID = l_def_gtl_rec.org_id
,CREATED_BY = l_def_gtl_rec.created_by
,CREATION_DATE = l_def_gtl_rec.creation_date
,LAST_UPDATED_BY = l_def_gtl_rec.last_updated_by
,LAST_UPDATE_DATE = l_def_gtl_rec.last_update_date
,LAST_UPDATE_LOGIN = l_def_gtl_rec.last_update_login
WHERE ID = l_def_gtl_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_gtlv_rec IN gtlv_rec_type,
x_gtlv_rec OUT NOCOPY gtlv_rec_type) IS
l_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
l_gtlv_rec.LAST_UPDATE_DATE := SYSDATE;
l_gtlv_rec.LAST_UPDATED_BY := Fnd_Global.USER_ID;
l_gtlv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
IF (x_gtlv_rec.last_updated_by = Okl_Api.G_MISS_NUM)
THEN
x_gtlv_rec.last_updated_by := l_gtlv_rec.last_updated_by;
IF (x_gtlv_rec.last_update_date = Okl_Api.G_MISS_DATE)
THEN
x_gtlv_rec.last_update_date := l_gtlv_rec.last_update_date;
IF (x_gtlv_rec.last_update_login = Okl_Api.G_MISS_NUM)
THEN
x_gtlv_rec.last_update_login := l_gtlv_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_gtl_rec => l_gtl_rec,
x_gtl_rec => lx_gtl_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_gtlv_tbl IN gtlv_tbl_type,
x_gtlv_tbl OUT NOCOPY gtlv_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 => p_init_msg_list, -- Bug 4054596: Issue No. 3
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_gtlv_rec => p_gtlv_tbl(i),
x_gtlv_rec => x_gtlv_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_gtl_rec IN gtl_rec_type) IS
l_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'delete_row';
DELETE FROM OKL_ST_GEN_TMPT_LNS
WHERE ID = l_gtl_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_gtlv_rec IN gtlv_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_gtl_rec => l_gtl_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_gtlv_tbl IN gtlv_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_gtlv_rec => p_gtlv_tbl(i));
END delete_row;