APPS.OKC_VERSION_PVT dependencies on OKC_PRICE_ADJ_ATTRIBS

Line 1527: delete FROM OKC_PRICE_ADJ_ATTRIBS_H

1523: or (p_called_from = 'RESTORE_VERSION'
1524: and (major_version > l_major_version
1525: or major_version = -1)));
1526: --
1527: delete FROM OKC_PRICE_ADJ_ATTRIBS_H
1528: WHERE pat_id IN
1529: ( SELECT pat_id
1530: FROM OKC_PRICE_ADJUSTMENTS
1531: WHERE chr_id = p_chr_id

Line 1963: delete from OKC_PRICE_ADJ_ATTRIBS

1959: WHERE pat_id_from in ( select pat_id
1960: from OKC_PRICE_ADJUSTMENTS
1961: where chr_id = p_chr_id);
1962:
1963: delete from OKC_PRICE_ADJ_ATTRIBS
1964: WHERE pat_id in ( select pat_id
1965: from OKC_PRICE_ADJUSTMENTS
1966: where chr_id = p_chr_id);
1967:

Line 2170: --Restore _OKC_PRICE_ADJ_ATTRIBS

2166: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2167: RAISE OKC_API.G_EXCEPTION_ERROR;
2168: END IF;
2169:
2170: --Restore _OKC_PRICE_ADJ_ATTRIBS
2171: l_return_status:=OKC_PAA_PVT.Restore_Version(l_chr_id,l_minus_version);
2172: --- If any errors happen abort API
2173: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2174: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;