The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT ID
,OBJECT_VERSION_NUMBER
,NAME
,DESCRIPTION
,PRODUCT_TYPE
,TAX_OWNER
,DEAL_TYPE
,PRICING_ENGINE
,ORG_ID
,CREATED_BY
,CREATION_DATE
,LAST_UPDATED_BY
,LAST_UPDATE_DATE
,LAST_UPDATE_LOGIN
,INTEREST_CALC_METH_CODE
,REVENUE_RECOG_METH_CODE
,DAYS_IN_MONTH_CODE
,DAYS_IN_YR_CODE
,ISG_ARREARS_PAY_DATES_OPTION
FROM OKL_ST_GEN_TMPT_SETS
WHERE OKL_ST_GEN_TMPT_SETS.id = p_id;
,l_gts_rec.last_updated_by
,l_gts_rec.last_update_date
,l_gts_rec.last_update_login
,l_gts_rec.interest_calc_meth_code
,l_gts_rec.revenue_recog_meth_code
,l_gts_rec.days_in_month_code
,l_gts_rec.days_in_yr_code
,l_gts_rec.isg_arrears_pay_dates_option;
SELECT ID
,OBJECT_VERSION_NUMBER
,NAME
,DESCRIPTION
,PRODUCT_TYPE
,TAX_OWNER
,DEAL_TYPE
,PRICING_ENGINE
,ORG_ID
,CREATED_BY
,CREATION_DATE
,LAST_UPDATED_BY
,LAST_UPDATE_DATE
,LAST_UPDATE_LOGIN
,INTEREST_CALC_METH_CODE
,REVENUE_RECOG_METH_CODE
,DAYS_IN_MONTH_CODE
,DAYS_IN_YR_CODE
,ISG_ARREARS_PAY_DATES_OPTION
FROM OKL_ST_GEN_TMPT_SETS
WHERE OKL_ST_GEN_TMPT_SETS.ID = p_id;
,l_gtsv_rec.last_updated_by
,l_gtsv_rec.last_update_date
,l_gtsv_rec.last_update_login
,l_gtsv_rec.interest_calc_meth_code
,l_gtsv_rec.revenue_recog_meth_code
,l_gtsv_rec.days_in_month_code
,l_gtsv_rec.days_in_yr_code
,l_gtsv_rec.isg_arrears_pay_dates_option;
SELECT ID
,name tmpt_set_name
FROM OKL_ST_GEN_TMPT_SETS gts
WHERE UPPER(gts.name) = upper( p_name );
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;
IF (l_gtsv_rec.last_updated_by = okl_api.G_MISS_NUM) THEN
l_gtsv_rec.last_updated_by := NULL;
IF (l_gtsv_rec.last_update_date = okl_api.G_MISS_DATE) THEN
l_gtsv_rec.last_update_date := NULL;
IF (l_gtsv_rec.last_update_login = okl_api.G_MISS_NUM) THEN
l_gtsv_rec.last_update_login := NULL;
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_gts_rec IN gts_rec_type,
x_gts_rec OUT NOCOPY gts_rec_type ) IS
-- 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_SETS(
Id
,object_version_number
,name
,description
,product_type
,tax_owner
,deal_type
,pricing_engine
,org_id
,created_by
,creation_date
,last_updated_by
,last_update_date
,last_update_login
,interest_calc_meth_code
,revenue_recog_meth_code
,days_in_month_code
,days_in_yr_code
,isg_arrears_pay_dates_option
)
VALUES (
l_gts_rec.Id
,l_gts_rec.object_version_number
,l_gts_rec.name
,l_gts_rec.description
,l_gts_rec.product_type
,l_gts_rec.tax_owner
,l_gts_rec.deal_type
,l_gts_rec.pricing_engine
,l_gts_rec.org_id
,l_gts_rec.created_by
,l_gts_rec.creation_date
,l_gts_rec.last_updated_by
,l_gts_rec.last_update_date
,l_gts_rec.last_update_login
,l_gts_rec.interest_calc_meth_code
,l_gts_rec.revenue_recog_meth_code
,l_gts_rec.days_in_month_code
,l_gts_rec.days_in_yr_code
,l_gts_rec.isg_arrears_pay_dates_option
);
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_gtsv_rec IN gtsv_rec_type,
x_gtsv_rec OUT NOCOPY gtsv_rec_type ) IS
-- Local Variables within the function
l_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'V_insert_row';
l_gtsv_rec.LAST_UPDATE_DATE := SYSDATE;
l_gtsv_rec.LAST_UPDATED_BY := Fnd_Global.USER_ID;
l_gtsv_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_gts_rec => l_gts_rec,
x_gts_rec => lx_gts_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_gtsv_tbl IN gtsv_tbl_type,
x_gtsv_tbl OUT NOCOPY gtsv_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_gtsv_rec => p_gtsv_tbl(i),
x_gtsv_rec => x_gtsv_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_gts_rec IN gts_rec_type,
x_gts_rec OUT NOCOPY gts_rec_type) IS
l_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'OPTS_update_row';
IF (x_gts_rec.last_updated_by = okl_api.G_MISS_NUM)
THEN
x_gts_rec.last_updated_by := l_gts_rec.last_updated_by;
IF (x_gts_rec.last_update_date = okl_api.G_MISS_DATE)
THEN
x_gts_rec.last_update_date := l_gts_rec.last_update_date;
IF (x_gts_rec.last_update_login = okl_api.G_MISS_NUM)
THEN
x_gts_rec.last_update_login := l_gts_rec.last_update_login;
UPDATE OKL_ST_GEN_TMPT_SETS
SET ID = l_def_gts_rec.id
,OBJECT_VERSION_NUMBER = l_def_gts_rec.object_version_number
,NAME = l_def_gts_rec.name
,DESCRIPTION = l_def_gts_rec.description
,PRODUCT_TYPE = l_def_gts_rec.product_type
,TAX_OWNER = l_def_gts_rec.tax_owner
,DEAL_TYPE = l_def_gts_rec.deal_type
,PRICING_ENGINE = l_def_gts_rec.pricing_engine
,ORG_ID = l_def_gts_rec.org_id
,CREATED_BY = l_def_gts_rec.created_by
,CREATION_DATE = l_def_gts_rec.creation_date
,LAST_UPDATED_BY = l_def_gts_rec.last_updated_by
,LAST_UPDATE_DATE = l_def_gts_rec.last_update_date
,LAST_UPDATE_LOGIN = l_def_gts_rec.last_update_login
,INTEREST_CALC_METH_CODE = l_def_gts_rec.INTEREST_CALC_METH_CODE
,REVENUE_RECOG_METH_CODE = l_def_gts_rec.REVENUE_RECOG_METH_CODE
,DAYS_IN_MONTH_CODE = l_def_gts_rec.DAYS_IN_MONTH_CODE
,DAYS_IN_YR_CODE = l_def_gts_rec.DAYS_IN_YR_CODE
,ISG_ARREARS_PAY_DATES_OPTION = l_def_gts_rec.ISG_ARREARS_PAY_DATES_OPTION
WHERE ID = l_def_gts_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_gtsv_rec IN gtsv_rec_type,
x_gtsv_rec OUT NOCOPY gtsv_rec_type) IS
l_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
l_gtsv_rec.LAST_UPDATE_DATE := SYSDATE;
l_gtsv_rec.LAST_UPDATED_BY := Fnd_Global.USER_ID;
l_gtsv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
IF (x_gtsv_rec.last_updated_by = okl_api.G_MISS_NUM)
THEN
x_gtsv_rec.last_updated_by := l_gtsv_rec.last_updated_by;
IF (x_gtsv_rec.last_update_date = okl_api.G_MISS_DATE)
THEN
x_gtsv_rec.last_update_date := l_gtsv_rec.last_update_date;
IF (x_gtsv_rec.last_update_login = okl_api.G_MISS_NUM)
THEN
x_gtsv_rec.last_update_login := l_gtsv_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_gts_rec => l_gts_rec,
x_gts_rec => lx_gts_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_gtsv_tbl IN gtsv_tbl_type,
x_gtsv_tbl OUT NOCOPY gtsv_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_gtsv_rec => p_gtsv_tbl(i),
x_gtsv_rec => x_gtsv_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_gts_rec IN gts_rec_type) IS
l_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'OPTS_delete_row';
DELETE FROM OKL_ST_GEN_TMPT_SETS
WHERE ID = l_gts_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_gtsv_rec IN gtsv_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_gts_rec => l_gts_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_gtsv_tbl IN gtsv_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_gtsv_rec => p_gtsv_tbl(i));
END delete_row;