The following lines contain the word 'select', 'insert', 'update' or 'delete':
Okl_Stm_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_stmv_rec => p_stmv_rec
,x_stmv_rec => x_stmv_rec
);
Okl_Stm_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_stmv_tbl => p_stmv_tbl
,x_stmv_tbl => x_stmv_tbl
);
okl_stm_pvt.insert_row_perf(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_stmv_tbl,
x_stmv_tbl);
PROCEDURE update_streams(
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_stmv_rec IN stmv_rec_type,
p_selv_tbl IN selv_tbl_type,
x_stmv_rec OUT NOCOPY stmv_rec_type,
x_selv_tbl OUT NOCOPY selv_tbl_type) IS
l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
update_streams(
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_stmv_rec => p_stmv_rec
,x_stmv_rec => x_stmv_rec
);
update_stream_elements(
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_selv_tbl => p_selv_tbl
,x_selv_tbl => x_selv_tbl
);
END update_streams;
PROCEDURE update_streams(
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_stmv_rec IN stmv_rec_type
,x_stmv_rec OUT NOCOPY stmv_rec_type) IS
l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
Okl_Stm_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_stmv_rec => p_stmv_rec
,x_stmv_rec => x_stmv_rec
);
END update_streams;
PROCEDURE update_streams(
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_stmv_tbl IN stmv_tbl_type
,x_stmv_tbl OUT NOCOPY stmv_tbl_type) IS
l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
Okl_Stm_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_stmv_tbl => p_stmv_tbl
,x_stmv_tbl => x_stmv_tbl
);
END update_streams;
PROCEDURE delete_streams(
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_stmv_rec IN stmv_rec_type) IS
i NUMBER :=0;
SELECT sel.id
FROM OKL_STRM_ELEMENTS sel
WHERE sel.stm_id = p_stmv_rec.id;
delete_stream_elements(
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_selv_tbl => l_selv_tbl
);
Okl_Stm_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_stmv_rec => p_stmv_rec
);
END delete_streams;
PROCEDURE delete_streams(
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_stmv_tbl IN stmv_tbl_type) IS
i NUMBER :=0;
delete_streams(
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_stmv_rec => p_stmv_tbl(i)
);
END delete_streams;
Okl_Sel_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_selv_rec => p_selv_rec
,x_selv_rec => x_selv_rec
);
Okl_Sel_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_selv_tbl => p_selv_tbl
,x_selv_tbl => x_selv_tbl
);
PROCEDURE update_stream_elements(
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_selv_rec IN selv_rec_type
,x_selv_rec OUT NOCOPY selv_rec_type) IS
l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
Okl_Sel_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_selv_rec => p_selv_rec
,x_selv_rec => x_selv_rec
);
END update_stream_elements;
PROCEDURE update_stream_elements(
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_selv_tbl IN selv_tbl_type
,x_selv_tbl OUT NOCOPY selv_tbl_type) IS
l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
Okl_Sel_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_selv_tbl => p_selv_tbl
,x_selv_tbl => x_selv_tbl
);
END update_stream_elements;
PROCEDURE delete_stream_elements(
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_selv_rec IN selv_rec_type) IS
i NUMBER :=0;
Okl_Sel_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_selv_rec => p_selv_rec);
END delete_stream_elements;
PROCEDURE delete_stream_elements(
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_selv_tbl IN selv_tbl_type) IS
i NUMBER :=0;
delete_stream_elements(
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_selv_rec => p_selv_tbl(i));
END delete_stream_elements;
INSERT INTO OKL_STREAMS_H
(
major_version,
ID,
TRANSACTION_NUMBER,
OBJECT_VERSION_NUMBER,
SGN_CODE,
SAY_CODE,
STY_ID,
KLE_ID,
KHR_ID,
ACTIVE_YN,
PURPOSE_CODE,
DATE_CURRENT,
DATE_WORKING,
DATE_HISTORY,
COMMENTS,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
PROGRAM_ID,
REQUEST_ID,
PROGRAM_APPLICATION_ID,
PROGRAM_UPDATE_DATE,
LAST_UPDATE_LOGIN ,
STM_ID,
SOURCE_ID,
SOURCE_TABLE,
--HKPATEL changed for bug 4212626
TRX_ID,
LINK_HIST_STREAM_ID
)
SELECT
p_major_version,
ID,
TRANSACTION_NUMBER,
OBJECT_VERSION_NUMBER,
SGN_CODE,
SAY_CODE,
STY_ID,
KLE_ID,
KHR_ID,
ACTIVE_YN,
PURPOSE_CODE,
DATE_CURRENT,
DATE_WORKING,
DATE_HISTORY,
COMMENTS,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
PROGRAM_ID,
REQUEST_ID,
PROGRAM_APPLICATION_ID,
PROGRAM_UPDATE_DATE,
LAST_UPDATE_LOGIN ,
STM_ID,
SOURCE_ID,
SOURCE_TABLE,
--HKPATEL changed for bug 4212626
TRX_ID,
LINK_HIST_STREAM_ID
FROM OKL_STREAMS
WHERE
say_code = 'CURR' and
khr_id = p_khr_id;
INSERT INTO OKL_STRM_ELEMENTS_H
(
MAJOR_VERSION,
ID ,
SE_LINE_NUMBER ,
DATE_BILLED ,
STM_ID ,
OBJECT_VERSION_NUMBER ,
STREAM_ELEMENT_DATE ,
AMOUNT ,
COMMENTS ,
ACCRUED_YN ,
PROGRAM_ID ,
REQUEST_ID,
PROGRAM_APPLICATION_ID,
PROGRAM_UPDATE_DATE ,
CREATED_BY ,
CREATION_DATE ,
LAST_UPDATED_BY ,
LAST_UPDATE_DATE ,
LAST_UPDATE_LOGIN ,
SEL_ID ,
SOURCE_ID ,
SOURCE_TABLE,
--HKPATEL changed for bug 4212626
BILL_ADJ_FLAG,
ACCRUAL_ADJ_FLAG
)
SELECT
p_major_version,
ID ,
SE_LINE_NUMBER ,
DATE_BILLED ,
STM_ID ,
OBJECT_VERSION_NUMBER ,
STREAM_ELEMENT_DATE ,
AMOUNT ,
COMMENTS ,
ACCRUED_YN ,
PROGRAM_ID ,
REQUEST_ID,
PROGRAM_APPLICATION_ID,
PROGRAM_UPDATE_DATE ,
CREATED_BY ,
CREATION_DATE ,
LAST_UPDATED_BY ,
LAST_UPDATE_DATE ,
LAST_UPDATE_LOGIN ,
SEL_ID ,
SOURCE_ID,
SOURCE_TABLE,
--HKPATEL changed for bug 4212626
BILL_ADJ_FLAG,
ACCRUAL_ADJ_FLAG
FROM OKL_STRM_ELEMENTS
WHERE stm_id in (Select id from OKL_STREAMS where khr_id = p_khr_id and say_code ='CURR');
select 'x'
from OKL_K_HEADERS
where id = l_khr_id;
select 'x'
from OKL_STREAMS_H
where khr_id = l_khr_id and major_version = l_major_version ;