The following lines contain the word 'select', 'insert', 'update' or 'delete':
oks_sll_pvt.insert_row
(
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_sllv_rec => p_sllv_rec,
x_sllv_rec => x_sllv_rec
);
oks_sll_pvt.insert_row
(
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_sllv_tbl => p_sllv_tbl,
x_sllv_tbl => x_sllv_tbl,
px_error_tbl => px_error_tbl
);
oks_sll_pvt.insert_row
(
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_sllv_tbl => p_sllv_tbl,
x_sllv_tbl => x_sllv_tbl
);
PROCEDURE update_sll(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_sllv_rec IN sllv_rec_type,
x_sllv_rec OUT NOCOPY sllv_rec_type,
p_validate_yn IN VARCHAR2) IS
BEGIN
x_return_status := G_RET_STS_SUCCESS;
oks_sll_pvt.update_row
(
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_sllv_rec => p_sllv_rec,
x_sllv_rec => x_sllv_rec
);
END update_sll;
PROCEDURE update_sll(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_sllv_tbl IN sllv_tbl_type,
x_sllv_tbl OUT NOCOPY sllv_tbl_type,
px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE,
p_validate_yn IN VARCHAR2) IS
BEGIN
x_return_status := G_RET_STS_SUCCESS;
oks_sll_pvt.update_row
(
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_sllv_tbl => p_sllv_tbl,
x_sllv_tbl => x_sllv_tbl,
px_error_tbl => px_error_tbl
);
END update_sll;
PROCEDURE update_sll(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_sllv_tbl IN sllv_tbl_type,
x_sllv_tbl OUT NOCOPY sllv_tbl_type,
p_validate_yn IN VARCHAR2) IS
BEGIN
x_return_status := G_RET_STS_SUCCESS;
oks_sll_pvt.update_row
(
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_sllv_tbl => p_sllv_tbl,
x_sllv_tbl => x_sllv_tbl
);
END update_sll;
PROCEDURE delete_sll(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_sllv_rec IN sllv_rec_type) IS
BEGIN
oks_sll_pvt.delete_row
(
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_sllv_rec => p_sllv_rec
);
END delete_sll;
PROCEDURE delete_sll(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_sllv_tbl IN sllv_tbl_type,
px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS
BEGIN
oks_sll_pvt.delete_row
(
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_sllv_tbl => p_sllv_tbl,
px_error_tbl => px_error_tbl
);
END delete_sll;
PROCEDURE delete_sll(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_sllv_tbl IN sllv_tbl_type) IS
BEGIN
oks_sll_pvt.delete_row
(
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_sllv_tbl => p_sllv_tbl
);
END delete_sll;
PROCEDURE INSERT_ROW_UPG(x_return_status OUT NOCOPY VARCHAR2,
p_sllv_tbl IN sllv_tbl_type) IS
l_tabsize NUMBER := p_sllv_tbl.COUNT;
in_last_updated_by OKC_DATATYPES.Number15TabTyp;
in_last_update_date OKC_DATATYPES.DateTabTyp;
in_last_update_login OKC_DATATYPES.Number15TabTyp;
in_last_updated_by(j) := p_sllv_tbl(i).last_updated_by;
in_last_update_date(j) := p_sllv_tbl(i).last_update_date;
in_last_update_login (j) := p_sllv_tbl(i).last_update_login;
INSERT
INTO OKS_STREAM_LEVELS_B(
id,
chr_id,
cle_id,
dnz_chr_id,
sequence_no,
uom_code,
start_date,
end_date,
level_periods,
uom_per_period,
advance_periods,
level_amount,
invoice_offset_days,
interface_offset_days,
comments,
due_arr_yn,
amount,
lines_detailed_yn,
object_version_number,
request_id,
created_by,
creation_date,
last_updated_by,
last_update_date,
last_update_login
) VALUES (
in_id(i),
in_chr_id(i),
in_cle_id(i),
in_dnz_chr_id(i),
in_sequence_no(i),
in_uom_code(i),
in_start_date(i),
in_end_date(i),
in_level_periods(i),
in_uom_per_period(i),
in_advance_periods(i),
in_level_amount(i),
in_invoice_offset_days(i),
in_interface_offset_days(i),
in_comments(i),
in_due_arr_yn(i),
in_amount(i),
in_lines_detailed_yn(i),
in_object_version_number(i),
in_request_id(i),
in_created_by(i),
in_creation_date(i),
in_last_updated_by(i),
in_last_update_date(i),
in_last_update_login(i)
);
END INSERT_ROW_UPG;