The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT start_date,
end_date
FROM OKL_AE_TMPT_SETS_V
WHERE id = v_aes_id;
SELECT start_date,
end_date
FROM OKL_AE_TEMPLATES
WHERE NAME = v_name
AND aes_id = v_aes_id;
SELECT start_date,
end_date
FROM OKL_AE_TEMPLATES
WHERE nvl(sty_id,OKL_API.G_MISS_NUM)
= nvl(p_avlv_rec.sty_id,OKL_API.G_MISS_NUM) AND
nvl(try_id,OKL_API.G_MISS_NUM)
= nvl(p_avlv_rec.try_id,OKL_API.G_MISS_NUM) AND
nvl(aes_id,OKL_API.G_MISS_NUM)
= nvl(p_avlv_rec.aes_id,OKL_API.G_MISS_NUM) AND
nvl(syt_code,OKL_API.G_MISS_CHAR)
= nvl(p_avlv_rec.syt_code,OKL_API.G_MISS_CHAR) AND
-- Code Added by HKPATEL for Bug # 2943310
nvl(inv_code,OKL_API.G_MISS_CHAR)
= nvl(p_avlv_rec.inv_code,OKL_API.G_MISS_CHAR) AND
-- Added code ends here
nvl(fac_code,OKL_API.G_MISS_CHAR)
= nvl(p_avlv_rec.fac_code,OKL_API.G_MISS_CHAR) AND
nvl(memo_yn,OKL_API.G_MISS_CHAR)
= nvl(p_avlv_rec.memo_yn,OKL_API.G_MISS_CHAR) AND
nvl(factoring_synd_flag,OKL_API.G_MISS_CHAR)
= nvl(p_avlv_rec.factoring_synd_flag,OKL_API.G_MISS_CHAR) ;
PROCEDURE UNIQUE_VALIDATION_UPDATE(p_avlv_rec IN AVLV_REC_TYPE,
x_valid_flag OUT NOCOPY VARCHAR2)
IS
CURSOR avl_csr IS
SELECT start_date,
end_date
FROM OKL_AE_TEMPLATES
WHERE nvl(sty_id,OKL_API.G_MISS_NUM)
= nvl(p_avlv_rec.sty_id,OKL_API.G_MISS_NUM) AND
nvl(try_id,OKL_API.G_MISS_NUM)
= nvl(p_avlv_rec.try_id,OKL_API.G_MISS_NUM) AND
nvl(aes_id,OKL_API.G_MISS_NUM)
= nvl(p_avlv_rec.aes_id,OKL_API.G_MISS_NUM) AND
nvl(syt_code,OKL_API.G_MISS_CHAR)
= nvl(p_avlv_rec.syt_code,OKL_API.G_MISS_CHAR) AND
-- Code Added by HKPATEL for Bug # 2943310
nvl(inv_code,OKL_API.G_MISS_CHAR)
= nvl(p_avlv_rec.inv_code,OKL_API.G_MISS_CHAR) AND
-- Added code ends here
nvl(fac_code,OKL_API.G_MISS_CHAR)
= nvl(p_avlv_rec.fac_code,OKL_API.G_MISS_CHAR) AND
nvl(memo_yn,OKL_API.G_MISS_CHAR)
= nvl(p_avlv_rec.memo_yn,OKL_API.G_MISS_CHAR) AND
nvl(factoring_synd_flag,OKL_API.G_MISS_CHAR)
= nvl(p_avlv_rec.factoring_synd_flag,OKL_API.G_MISS_CHAR) AND
ID <> p_avlv_rec.ID;
END UNIQUE_VALIDATION_UPDATE;
SELECT
ID,
OBJECT_VERSION_NUMBER,
TRY_ID,
AES_ID,
STY_ID,
FMA_ID,
SET_OF_BOOKS_ID,
FAC_CODE,
SYT_CODE,
-- Added by HKPATEL for Bug# 2943310
INV_CODE,
-- Added code ends here
POST_TO_GL,
ADVANCE_ARREARS,
MEMO_YN,
PRIOR_YEAR_YN,
NAME,
DESCRIPTION,
VERSION,
FACTORING_SYND_FLAG,
START_DATE,
END_DATE,
ACCRUAL_YN,
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_AE_TEMPLATES
WHERE OKL_AE_TEMPLATES.id = p_id;
l_avlv_rec.LAST_UPDATED_BY,
l_avlv_rec.LAST_UPDATE_DATE,
l_avlv_rec.LAST_UPDATE_LOGIN;
IF (x_avlv_rec.last_updated_by = OKC_API.G_MISS_NUM) THEN
x_avlv_rec.last_updated_by := l_avlv_rec.last_updated_by;
IF (x_avlv_rec.last_update_date = OKC_API.G_MISS_DATE) THEN
x_avlv_rec.last_update_date := l_avlv_rec.last_update_date;
IF (x_avlv_rec.last_update_login = OKC_API.G_MISS_NUM) THEN
x_avlv_rec.last_update_login := l_avlv_rec.last_update_login;
SELECT ID,
OBJECT_VERSION_NUMBER,
AVL_ID,
CRD_CODE,
CODE_COMBINATION_ID,
AE_LINE_TYPE,
SEQUENCE_NUMBER,
DESCRIPTION,
PERCENTAGE,
ACCOUNT_BUILDER_YN,
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_AE_TMPT_LNES
WHERE OKL_AE_TMPT_LNES.id = p_id;
l_atlv_rec.LAST_UPDATED_BY,
l_atlv_rec.LAST_UPDATE_DATE,
l_atlv_rec.LAST_UPDATE_LOGIN;
IF (x_atlv_rec.last_updated_by = OKC_API.G_MISS_NUM)
THEN
x_atlv_rec.last_updated_by := l_atlv_rec.last_updated_by;
IF (x_atlv_rec.last_update_date = OKC_API.G_MISS_DATE)
THEN
x_atlv_rec.last_update_date := l_atlv_rec.last_update_date;
IF (x_atlv_rec.last_update_login = OKC_API.G_MISS_NUM)
THEN
x_atlv_rec.last_update_login := l_atlv_rec.last_update_login;
SELECT nvl(max(version),0)
FROM OKL_AE_TEMPLATES
WHERE name = v_name;
SELECT SEQUENCE_NUMBER,
CODE_COMBINATION_ID,
AE_LINE_TYPE,
CRD_CODE,
OBJECT_VERSION_NUMBER,
ACCOUNT_BUILDER_YN,
DESCRIPTION,
PERCENTAGE,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15
FROM OKL_AE_TMPT_LNES
WHERE avl_id = v_avl_id;
SELECT nvl(max(version),0)
FROM OKL_AE_TEMPLATES
WHERE name = v_name;
SELECT AVL_ID
FROM OKL_AE_TMPT_LNES
WHERE ID = v_id;
PROCEDURE update_tmpt_set(p_api_version IN NUMBER
,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
,x_return_status OUT NOCOPY VARCHAR2
,x_msg_count OUT NOCOPY NUMBER
,x_msg_data OUT NOCOPY VARCHAR2
,p_aesv_rec IN aesv_rec_type
,p_avlv_tbl IN avlv_tbl_type
,p_atlv_tbl IN atlv_tbl_type
,x_aesv_rec OUT NOCOPY aesv_rec_type
,x_avlv_tbl OUT NOCOPY avlv_tbl_type
,x_atlv_tbl OUT NOCOPY atlv_tbl_type )
IS
l_api_version NUMBER := 1.0;
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRTMSB.pls call OKL_TMPT_SET_PUB.update_tmpt_set ');
OKL_TMPT_SET_PUB.update_tmpt_set(
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_aesv_rec => p_aesv_rec,
p_avlv_tbl => p_avlv_tbl,
p_atlv_tbl => p_atlv_tbl,
x_aesv_rec => x_aesv_rec,
x_avlv_tbl => x_avlv_tbl,
x_atlv_tbl => x_atlv_tbl);
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRTMSB.pls call OKL_TMPT_SET_PUB.update_tmpt_set ');
END update_tmpt_set;
SELECT ID
FROM OKL_AE_TMPT_SETS_V
WHERE name = v_name;
PROCEDURE update_tmpt_set(p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_aesv_tbl IN aesv_tbl_type,
x_aesv_tbl OUT NOCOPY aesv_tbl_type)
IS
l_api_version NUMBER := 1.0;
update_tmpt_set(p_api_version => l_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => l_return_Status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_aesv_rec => p_aesv_tbl(i),
x_aesv_rec => x_aesv_tbl(i) );
END update_tmpt_set;
PROCEDURE update_tmpt_set(p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_aesv_rec IN aesv_rec_type,
x_aesv_rec OUT NOCOPY aesv_rec_type)
IS
l_api_version NUMBER := 1.0;
l_api_name VARCHAR2(30) := 'UPDATE_TMPT_SET';
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRTMSB.pls call OKL_TMPT_SET_PUB.update_tmpt_set ');
OKL_TMPT_SET_PUB.update_tmpt_set(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_aesv_rec => p_aesv_rec,
x_aesv_rec => x_aesv_rec);
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRTMSB.pls call OKL_TMPT_SET_PUB.update_tmpt_set ');
END update_tmpt_set;
PROCEDURE delete_tmpt_set(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_aesv_tbl IN aesv_tbl_type)
IS
l_api_version NUMBER := 1.0;
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRTMSB.pls call OKL_TMPT_SET_PUB.delete_tmpt_set ');
OKL_TMPT_SET_PUB.delete_tmpt_set(
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_aesv_tbl => p_aesv_tbl);
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRTMSB.pls call OKL_TMPT_SET_PUB.delete_tmpt_set ');
END delete_tmpt_set;
PROCEDURE delete_tmpt_set(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_aesv_rec IN aesv_rec_type)
IS
l_api_version NUMBER := 1.0;
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRTMSB.pls call OKL_TMPT_SET_PUB.delete_tmpt_set ');
OKL_TMPT_SET_PUB.delete_tmpt_set(
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_aesv_rec => p_aesv_rec);
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRTMSB.pls call OKL_TMPT_SET_PUB.delete_tmpt_set ');
END delete_tmpt_set;
SELECT nvl(max(version),0)
FROM OKL_AE_TEMPLATES
WHERE NAME = v_name AND
AES_ID = v_aes_id ;
PROCEDURE update_template(p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_avlv_rec IN avlv_rec_type,
x_avlv_rec OUT NOCOPY avlv_rec_type)
IS
CURSOR avl_csr(v_id NUMBER) IS
SELECT ID,
STY_ID,
TRY_ID,
AES_ID ,
FMA_ID,
OBJECT_VERSION_NUMBER,
NAME ,
SYT_CODE,
-- Added by HKPATEL for Bug# 2943310
INV_CODE,
-- Added code ends here
FAC_CODE,
ADVANCE_ARREARS,
POST_TO_GL,
VERSION,
START_DATE,
MEMO_YN ,
PRIOR_YEAR_YN,
DESCRIPTION,
FACTORING_SYND_FLAG,
END_DATE ,
ACCRUAL_YN,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15
FROM OKL_AE_TEMPLATES
WHERE ID = v_id;
SELECT ID
FROM OKL_TRNS_ACC_DSTRS
WHERE template_id = v_avl_id;
l_api_name VARCHAR2(30) := 'UPDATE_TEMPLATE';
UNIQUE_VALIDATION_UPDATE(p_avlv_rec => p_avlv_rec,
x_valid_flag => l_valid_flag);
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRTMSB.pls call OKL_TMPT_SET_PUB.update_template ');
OKL_TMPT_SET_PUB.update_template(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_avlv_rec => p_avlv_rec,
x_avlv_rec => x_avlv_rec);
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRTMSB.pls call OKL_TMPT_SET_PUB.update_template ');
END update_template;
PROCEDURE update_template(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_avlv_tbl IN avlv_tbl_type,
x_avlv_tbl OUT NOCOPY avlv_tbl_type)
IS
l_api_version NUMBER := 1.0;
update_template(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_avlv_rec => p_avlv_tbl(i),
x_avlv_rec => x_avlv_tbl(i));
END update_template;
PROCEDURE delete_template(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_avlv_tbl IN avlv_tbl_type)
IS
l_api_version NUMBER := 1.0;
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRTMSB.pls call OKL_TMPT_SET_PUB.delete_template ');
OKL_TMPT_SET_PUB.delete_template(
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_avlv_tbl => p_avlv_tbl);
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRTMSB.pls call OKL_TMPT_SET_PUB.delete_template ');
END delete_template;
PROCEDURE delete_template(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_avlv_rec IN avlv_rec_type)
IS
l_api_version NUMBER := 1.0;
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRTMSB.pls call OKL_TMPT_SET_PUB.delete_template ');
OKL_TMPT_SET_PUB.delete_template(
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_avlv_rec => p_avlv_rec);
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRTMSB.pls call OKL_TMPT_SET_PUB.delete_template ');
END delete_template;
PROCEDURE update_tmpt_lines(p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_atlv_tbl IN atlv_tbl_type,
x_atlv_tbl OUT NOCOPY atlv_tbl_type)
IS
l_api_version NUMBER := 1.0;
SELECT ID ,
SEQUENCE_NUMBER ,
AVL_ID ,
CODE_COMBINATION_ID ,
AE_LINE_TYPE ,
CRD_CODE ,
ACCOUNT_BUILDER_YN ,
DESCRIPTION,
PERCENTAGE ,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2 ,
ATTRIBUTE3 ,
ATTRIBUTE4 ,
ATTRIBUTE5 ,
ATTRIBUTE6 ,
ATTRIBUTE7 ,
ATTRIBUTE8 ,
ATTRIBUTE9 ,
ATTRIBUTE10 ,
ATTRIBUTE11 ,
ATTRIBUTE12 ,
ATTRIBUTE13 ,
ATTRIBUTE14 ,
ATTRIBUTE15
FROM OKL_AE_TMPT_LNES
WHERE ID = v_atl_id;
SELECT ID,
start_date,
end_date
FROM OKL_AE_TEMPLATES
WHERE ID = (SELECT avl_id FROM OKL_AE_TMPT_LNES
WHERE ID = v_atl_id);
SELECT ID
FROM OKL_TRNS_ACC_DSTRS
WHERE template_id = v_avl_id;
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRTMSB.pls call OKL_TMPT_SET_PUB.update_tmpt_lines ');
OKL_TMPT_SET_PUB.update_tmpt_lines(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_atlv_tbl => p_atlv_tbl,
x_atlv_tbl => x_atlv_tbl);
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRTMSB.pls call OKL_TMPT_SET_PUB.update_tmpt_lines ');
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRTMSB.pls call OKL_TMPT_SET_PUB.update_tmpt_lines ');
OKL_TMPT_SET_PUB.update_tmpt_lines(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_atlv_tbl => p_atlv_tbl,
x_atlv_tbl => x_atlv_tbl);
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRTMSB.pls call OKL_TMPT_SET_PUB.update_tmpt_lines ');
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRTMSB.pls call OKL_TMPT_SET_PUB.update_template ');
OKL_TMPT_SET_PUB.update_template(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_avlv_rec => l_avlv_rec,
x_avlv_rec => x_avlv_rec);
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRTMSB.pls call OKL_TMPT_SET_PUB.update_template ');
END update_tmpt_lines;
PROCEDURE update_tmpt_lines(p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_atlv_rec IN atlv_rec_type,
x_atlv_rec OUT NOCOPY atlv_rec_type)
IS
l_api_version NUMBER := 1.0;
l_api_name VARCHAR2(30) := 'UPDATE_TMPT_LINES';
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRTMSB.pls call OKL_TMPT_SET_PUB.update_tmpt_lines ');
OKL_TMPT_SET_PUB.update_tmpt_lines(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_atlv_rec => l_atlv_rec,
x_atlv_rec => x_atlv_rec);
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRTMSB.pls call OKL_TMPT_SET_PUB.update_tmpt_lines ');
END UPDATE_TMPT_LINES;
PROCEDURE delete_tmpt_lines(p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_atlv_tbl IN atlv_tbl_type)
IS
l_api_version NUMBER := 1.0;
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRTMSB.pls call OKL_TMPT_SET_PUB.delete_tmpt_lines ');
OKL_TMPT_SET_PUB.delete_tmpt_lines(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_atlv_tbl => p_atlv_tbl);
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRTMSB.pls call OKL_TMPT_SET_PUB.delete_tmpt_lines ');
END delete_tmpt_lines;
PROCEDURE delete_tmpt_lines(p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_atlv_rec IN atlv_rec_type)
IS
l_api_version NUMBER := 1.0;
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRTMSB.pls call OKL_TMPT_SET_PUB.delete_tmpt_lines ');
OKL_TMPT_SET_PUB.delete_tmpt_lines(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_atlv_rec => p_atlv_rec);
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRTMSB.pls call OKL_TMPT_SET_PUB.delete_tmpt_lines ');
END delete_tmpt_lines;
select ACCOUNT_DERIVATION from
okl_sys_acct_opts ;
SELECT id
,try_id
,sty_id
,fma_id
,fac_code
,syt_code
-- Added by HKPATEL for bug 2943310
,inv_code
-- Added code ends here
,post_to_gl
,advance_arrears
,memo_yn
,prior_year_yn
,name
,description
,version
,factoring_synd_flag
,start_date
,end_date
,accrual_yn
,attribute_category
,attribute1
,attribute2
,attribute3
,attribute4
,attribute5
,attribute6
,attribute7
,attribute8
,attribute9
,attribute10
,attribute11
,attribute12
,attribute13
,attribute14
,attribute15
FROM okl_ae_templates
WHERE aes_id = v_aes_id;
SELECT id
,sequence_number
,avl_id
,code_combination_id
,ae_line_type
,crd_code
,account_builder_yn
,description
,percentage
,attribute_category
,attribute1
,attribute2
,attribute3
,attribute4
,attribute5
,attribute6
,attribute7
,attribute8
,attribute9
,attribute10
,attribute11
,attribute12
,attribute13
,attribute14
,attribute15
FROM okl_ae_tmpt_lnes
WHERE avl_id = v_avl_id;
l_atlv_tbl_in.DELETE;
SELECT code_combination_id,
ae_line_type,
crd_code,
account_builder_yn,
description,
percentage,
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15
FROM OKL_AE_TMPT_LNES
WHERE avl_id = p_source_tmpl_id;
SELECT '1'
FROM OKL_ST_GEN_TMPT_SETS
WHERE OKL_ST_GEN_TMPT_SETS.ID = l_gts_id;