The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE insert_row(
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_tmsv_rec IN tmsv_rec_type,
x_tmsv_rec OUT NOCOPY tmsv_rec_type) IS
l_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'V_insert_row';
OKS_TEMPLATE_SET_PVT.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_tmsv_rec => p_tmsv_rec,
x_tmsv_rec => x_tmsv_rec);
END insert_row;
PROCEDURE insert_row(
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_tmsv_tbl IN tmsv_tbl_type,
x_tmsv_tbl OUT NOCOPY tmsv_tbl_type,
px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS
l_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_insert_row';
OKS_TEMPLATE_SET_PVT.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_tmsv_tbl => p_tmsv_tbl,
x_tmsv_tbl => x_tmsv_tbl,
px_error_tbl => px_error_tbl);
END insert_row;
PROCEDURE insert_row(
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_tmsv_tbl IN tmsv_tbl_type,
x_tmsv_tbl OUT NOCOPY tmsv_tbl_type) IS
l_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
OKS_TEMPLATE_SET_PVT.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_tmsv_tbl => p_tmsv_tbl,
x_tmsv_tbl => x_tmsv_tbl);
END insert_row;
PROCEDURE update_row(
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_tmsv_rec IN tmsv_rec_type,
x_tmsv_rec OUT NOCOPY tmsv_rec_type) IS
l_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
OKS_TEMPLATE_SET_PVT.update_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_tmsv_rec => p_tmsv_rec,
x_tmsv_rec => x_tmsv_rec);
END update_row;
PROCEDURE update_row(
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_tmsv_tbl IN tmsv_tbl_type,
x_tmsv_tbl OUT NOCOPY tmsv_tbl_type,
px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS
l_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_update_row';
OKS_TEMPLATE_SET_PVT.update_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_tmsv_tbl => p_tmsv_tbl,
x_tmsv_tbl => x_tmsv_tbl,
px_error_tbl => px_error_tbl);
END update_row;
PROCEDURE update_row(
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_tmsv_tbl IN tmsv_tbl_type,
x_tmsv_tbl OUT NOCOPY tmsv_tbl_type) IS
l_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
OKS_TEMPLATE_SET_PVT.update_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_tmsv_tbl => p_tmsv_tbl,
x_tmsv_tbl => x_tmsv_tbl);
END update_row;
PROCEDURE delete_row(
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_tmsv_rec IN tmsv_rec_type) IS
l_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
OKS_TEMPLATE_SET_PVT.delete_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_tmsv_rec => p_tmsv_rec);
END delete_row;
PROCEDURE delete_row(
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_tmsv_tbl IN tmsv_tbl_type,
px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS
l_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_delete_row';
OKS_TEMPLATE_SET_PVT.delete_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_tmsv_tbl => p_tmsv_tbl,
px_error_tbl => px_error_tbl);
END delete_row;
PROCEDURE delete_row(
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_tmsv_tbl IN tmsv_tbl_type) IS
l_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';
OKS_TEMPLATE_SET_PVT.delete_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_tmsv_tbl => p_tmsv_tbl);
END delete_row;
x_contract_update_status OUT NOCOPY VARCHAR2,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_data OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER
) AS
l_api_name CONSTANT VARCHAR2(30) := 'get_template_set_dtls';
SELECT DECODE(renewal_type_used,NULL,'N','R')
FROM oks_k_headers_b
WHERE chr_id = p_contract_id;
SELECT r.report_id,
r.message_template_id,
r.sts_code,
r.attachment_name
FROM oks_report_templates r
WHERE r.template_set_id = p_template_set_id
AND r.template_set_type= p_document_type
AND ( DECODE(r.process_code,'B','B','X') = 'B' OR
r.process_code = p_process_code)
AND ( DECODE(r.applies_to,'B','B','X') = 'B' OR
r.applies_to = p_applies_to)
AND sysdate BETWEEN r.START_DATE AND NVL(r.end_date,SYSDATE+1)
AND NVL(r.report_period,'X') = NVL(p_report_period, NVL(r.report_period,'X'))
AND NVL(r.report_duration,-99) = NVL(p_report_duration, NVL(r.report_duration,-99)) ;
SELECT wf_item_key
FROM oks_k_headers_b
WHERE chr_id = p_contract_id;
SELECT template_name
FROM xdo_templates_vl
WHERE template_id=p_attachment_template_id;
x_contract_update_status,
x_attachment_name ;
'300: x_contract_update_status : '||x_contract_update_status);