DBA Data[Home] [Help]

APPS.OKL_INS_QUOTE_PVT dependencies on OKL_STM_PVT

Line 5810: p_stmv_rec IN Okl_Stm_Pvt.stmv_rec_type,

5806: BEGIN
5807: NULL;
5808: END api_copy;
5809: FUNCTION get_stream_header (
5810: p_stmv_rec IN Okl_Stm_Pvt.stmv_rec_type,
5811: x_no_data_found OUT NOCOPY BOOLEAN
5812: ) RETURN Okl_Stm_Pvt.stmv_rec_type IS
5813: CURSOR okl_stmv_pk_csr (p_khr_id IN NUMBER,
5814: p_kle_id IN NUMBER,

Line 5812: ) RETURN Okl_Stm_Pvt.stmv_rec_type IS

5808: END api_copy;
5809: FUNCTION get_stream_header (
5810: p_stmv_rec IN Okl_Stm_Pvt.stmv_rec_type,
5811: x_no_data_found OUT NOCOPY BOOLEAN
5812: ) RETURN Okl_Stm_Pvt.stmv_rec_type IS
5813: CURSOR okl_stmv_pk_csr (p_khr_id IN NUMBER,
5814: p_kle_id IN NUMBER,
5815: p_sty_id IN NUMBER) IS
5816: SELECT ID,

Line 5842: l_stmv_rec Okl_Stm_Pvt.stmv_rec_type;

5838: WHERE okl_streams_v.khr_id = p_khr_id AND
5839: okl_streams_v.kle_id = p_kle_id
5840: AND okl_streams_v.sty_id = p_sty_id;
5841: l_okl_stmv_pk okl_stmv_pk_csr%ROWTYPE;
5842: l_stmv_rec Okl_Stm_Pvt.stmv_rec_type;
5843: BEGIN
5844: x_no_data_found := TRUE;
5845: -- Get current database values
5846: OPEN okl_stmv_pk_csr (p_stmv_rec.khr_id,p_stmv_rec.kle_id,p_stmv_rec.sty_id );