APPS.OKL_TRANS_PRICING_PARAMS_PVT dependencies on OKL_SIF_PRICING_PARAMS

Line 33: l_sif_id okl_sif_pricing_params.sif_id%TYPE := p_sif_id;

29: ,p_sif_id IN NUMBER )
30: IS
31: l_tpp_tbl tpp_tbl_type;
32: l_spmv_tbl spmv_tbl_type;
33: l_sif_id okl_sif_pricing_params.sif_id%TYPE := p_sif_id;
34: l_gts_id okl_st_gen_tmpt_sets.id%TYPE := p_gts_id;
35: l_chr_id okc_k_headers_b.id%TYPE := p_chr_id;
36: i NUMBER := 0;
37: j NUMBER := 0;

Line 177: DELETE FROM OKL_SIF_PRICING_PARAMS

173: p_chr_id IN NUMBER
174: ,x_return_status OUT NOCOPY VARCHAR2)
175: IS
176: BEGIN
177: DELETE FROM OKL_SIF_PRICING_PARAMS
178: WHERE khr_ID = p_chr_id
179: AND sif_id IS NULL;
180:
181: x_return_status := OKC_API.G_RET_STS_SUCCESS;