The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE update_ext_csh_txns( 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_xcrv_rec IN xcrv_rec_type
,p_xcav_tbl IN xcav_tbl_type
,x_xcrv_rec OUT NOCOPY xcrv_rec_type
,x_xcav_tbl OUT NOCOPY xcav_tbl_type
) IS
l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
update_ext_csh_txns( p_api_version
,p_init_msg_list
,x_return_status
,x_msg_count
,x_msg_data
,p_xcrv_rec
,x_xcrv_rec
);
update_ext_csh_txns( p_api_version
,p_init_msg_list
,x_return_status
,x_msg_count
,x_msg_data
,p_xcav_tbl
,x_xcav_tbl
);
END update_ext_csh_txns;
PROCEDURE delete_ext_csh_txns( 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_xcrv_rec IN xcrv_rec_type
,p_xcav_tbl IN xcav_tbl_type
,x_xcrv_rec OUT NOCOPY xcrv_rec_type
,x_xcav_tbl OUT NOCOPY xcav_tbl_type
) IS
l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
delete_ext_csh_txns( p_api_version
,p_init_msg_list
,x_return_status
,x_msg_count
,x_msg_data
,p_xcrv_rec
);
delete_ext_csh_txns( p_api_version
,p_init_msg_list
,x_return_status
,x_msg_count
,x_msg_data
,p_xcav_tbl
);
END delete_ext_csh_txns;
Okl_Xcr_Pvt.insert_row( p_api_version
,p_init_msg_list
,x_return_status
,x_msg_count
,x_msg_data
,p_xcrv_rec
,x_xcrv_rec
);
Okl_Xcr_Pvt.insert_row( p_api_version
,p_init_msg_list
,x_return_status
,x_msg_count
,x_msg_data
,p_xcrv_tbl
,x_xcrv_tbl
);
PROCEDURE update_ext_csh_txns( 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_xcrv_rec IN xcrv_rec_type
,x_xcrv_rec OUT NOCOPY xcrv_rec_type
) IS
BEGIN
Okl_Xcr_Pvt.update_row( p_api_version
,p_init_msg_list
,x_return_status
,x_msg_count
,x_msg_data
,p_xcrv_rec
,x_xcrv_rec
);
END update_ext_csh_txns;
PROCEDURE update_ext_csh_txns( 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_xcrv_tbl IN xcrv_tbl_type
,x_xcrv_tbl OUT NOCOPY xcrv_tbl_type
) IS
BEGIN
Okl_Xcr_Pvt.update_row( p_api_version
,p_init_msg_list
,x_return_status
,x_msg_count
,x_msg_data
,p_xcrv_tbl
,x_xcrv_tbl
);
END update_ext_csh_txns;
--Put custom code for cascade delete by developer
PROCEDURE delete_ext_csh_txns( 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_xcrv_rec IN xcrv_rec_type
) IS
i NUMBER :=0;
--Delete the Master
Okl_Xcr_Pvt.delete_row( p_api_version
,p_init_msg_list
,x_return_status
,x_msg_count
,x_msg_data
,p_xcrv_rec
);
END delete_ext_csh_txns;
PROCEDURE delete_ext_csh_txns( 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_xcrv_tbl IN xcrv_tbl_type
) IS
i NUMBER :=0;
delete_ext_csh_txns( p_api_version
,p_init_msg_list
,x_return_status
,x_msg_count
,x_msg_data
,p_xcrv_tbl(i)
);
END delete_ext_csh_txns;
Okl_Xca_Pvt.insert_row( p_api_version
,p_init_msg_list
,x_return_status
,x_msg_count
,x_msg_data
,p_xcav_rec
,x_xcav_rec
);
Okl_Xca_Pvt.insert_row( p_api_version
,p_init_msg_list
,x_return_status
,x_msg_count
,x_msg_data
,p_xcav_tbl
,x_xcav_tbl
);
PROCEDURE update_ext_csh_txns( 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_xcav_rec IN xcav_rec_type
,x_xcav_rec OUT NOCOPY xcav_rec_type
) IS
BEGIN
Okl_Xca_Pvt.update_row( p_api_version
,p_init_msg_list
,x_return_status
,x_msg_count
,x_msg_data
,p_xcav_rec
,x_xcav_rec
);
END update_ext_csh_txns;
PROCEDURE update_ext_csh_txns( 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_xcav_tbl IN xcav_tbl_type
,x_xcav_tbl OUT NOCOPY xcav_tbl_type
) IS
BEGIN
Okl_Xca_Pvt.update_row( p_api_version
,p_init_msg_list
,x_return_status
,x_msg_count
,x_msg_data
,p_xcav_tbl
,x_xcav_tbl
);
END update_ext_csh_txns;
--Put custom code for cascade delete by developer
PROCEDURE delete_ext_csh_txns( 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_xcav_rec IN xcav_rec_type
) IS
i NUMBER :=0;
--Delete the Master
Okl_Xca_Pvt.delete_row( p_api_version
,p_init_msg_list
,x_return_status
,x_msg_count
,x_msg_data
,p_xcav_rec
);
END delete_ext_csh_txns;
PROCEDURE delete_ext_csh_txns( 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_xcav_tbl IN xcav_tbl_type
) IS
i NUMBER :=0;
delete_ext_csh_txns( p_api_version
,p_init_msg_list
,x_return_status
,x_msg_count
,x_msg_data
,p_xcav_tbl(i)
);
END delete_ext_csh_txns;