APPS.OKC_VERSION_PVT dependencies on OKC_PRICE_ADJ_ASSOCS

Line 1515: delete FROM OKC_PRICE_ADJ_ASSOCS_H

1511: and (major_version > l_major_version
1512: or major_version = -1)));
1513: --
1514:
1515: delete FROM OKC_PRICE_ADJ_ASSOCS_H
1516: WHERE pat_id IN
1517: ( SELECT pat_id
1518: FROM OKC_PRICE_ADJUSTMENTS
1519: WHERE chr_id = p_chr_id

Line 1958: delete from OKC_PRICE_ADJ_ASSOCS

1954:
1955: delete from OKC_PRICE_ADJUSTMENTS
1956: WHERE chr_id = p_chr_id;
1957:
1958: delete from OKC_PRICE_ADJ_ASSOCS
1959: WHERE pat_id_from in ( select pat_id
1960: from OKC_PRICE_ADJUSTMENTS
1961: where chr_id = p_chr_id);
1962:

Line 2161: --Restore _OKC_PRICE_ADJ_ASSOCS

2157: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2158: RAISE OKC_API.G_EXCEPTION_ERROR;
2159: END IF;
2160:
2161: --Restore _OKC_PRICE_ADJ_ASSOCS
2162: l_return_status:=OKC_PAC_PVT.Restore_Version(l_chr_id,l_minus_version);
2163: --- If any errors happen abort API
2164: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2165: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;