The following lines contain the word 'select', 'insert', 'update' or 'delete':
G_FORM_RECORD_DELETED CONSTANT VARCHAR2(30) := OKL_API.G_FORM_RECORD_DELETED;
G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(30) := OKL_API.G_RECORD_LOGICALLY_DELETED;
PROCEDURE update_funding_header(
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_tapv_rec IN tapv_rec_type
,x_tapv_rec OUT NOCOPY tapv_rec_type
)
IS
l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_FUNDING_HEADER';
SAVEPOINT UPDATE_FUNDING_HEADER_PUB;
OKL_FUNDING_PVT.update_funding_header(
p_api_version => p_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_tapv_rec => l_tapv_rec,
x_tapv_rec => x_tapv_rec);
ROLLBACK TO UPDATE_FUNDING_HEADER_PUB;
ROLLBACK TO UPDATE_FUNDING_HEADER_PUB;
ROLLBACK TO UPDATE_FUNDING_HEADER_PUB;
END update_funding_header;
PROCEDURE delete_funding_header(
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_tapv_rec IN tapv_rec_type
)
IS
l_api_name CONSTANT VARCHAR2(30) := 'DELETE_FUNDING_HEADER';
SAVEPOINT DELETE_FUNDING_HEADER_PUB;
OKL_TRX_AP_INVOICES_PUB.DELETE_TRX_AP_INVOICES(
p_api_version => p_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_tapv_rec => p_tapv_rec);
ROLLBACK TO DELETE_FUNDING_HEADER_PUB;
ROLLBACK TO DELETE_FUNDING_HEADER_PUB;
ROLLBACK TO DELETE_FUNDING_HEADER_PUB;
END delete_funding_header;
PROCEDURE update_funding_lines(
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_tplv_tbl IN tplv_tbl_type
,x_tplv_tbl OUT NOCOPY tplv_tbl_type
)
IS
l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_FUNDING_LINES';
SAVEPOINT UPDATE_FUNDING_LINES_PUB;
OKL_FUNDING_PVT.update_funding_lines(
p_api_version => p_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_tplv_tbl => l_tplv_tbl,
x_tplv_tbl => x_tplv_tbl);
ROLLBACK TO UPDATE_FUNDING_LINES_PUB;
ROLLBACK TO UPDATE_FUNDING_LINES_PUB;
ROLLBACK TO UPDATE_FUNDING_LINES_PUB;
END update_funding_lines;
PROCEDURE delete_funding_lines(
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_tplv_tbl IN tplv_tbl_type
)
IS
l_api_name CONSTANT VARCHAR2(30) := 'DELETE_FUNDING_LINES';
SELECT l.tap_id
FROM OKL_TXL_AP_INV_LNS_B l
WHERE l.id = p_line_id
;
SAVEPOINT DELETE_FUNDING_LINES_PUB;
OKL_TXL_AP_INV_LNS_PUB.DELETE_TXL_AP_INV_LNS(
p_api_version => p_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_tplv_tbl => p_tplv_tbl);
ROLLBACK TO DELETE_FUNDING_LINES_PUB;
ROLLBACK TO DELETE_FUNDING_LINES_PUB;
ROLLBACK TO DELETE_FUNDING_LINES_PUB;
END delete_funding_lines;