APPS.OKC_VERSION_PVT dependencies on OKC_PRICE_ADJUSTMENTS

Line 1506: delete FROM OKC_PRICE_ADJUSTMENTS_H

1502: and (major_version > l_major_version
1503: or major_version = -1)));
1504: --
1505:
1506: delete FROM OKC_PRICE_ADJUSTMENTS_H
1507: WHERE chr_id= p_chr_id
1508: and ((MAJOR_VERSION = -1
1509: and p_called_from = 'ERASE_SAVED_VERSION')
1510: or (p_called_from = 'RESTORE_VERSION'

Line 1518: FROM OKC_PRICE_ADJUSTMENTS

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
1520: )
1521: and ((MAJOR_VERSION = -1
1522: and p_called_from = 'ERASE_SAVED_VERSION')

Line 1530: FROM OKC_PRICE_ADJUSTMENTS

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
1532: )
1533: and ((MAJOR_VERSION = -1
1534: and p_called_from = 'ERASE_SAVED_VERSION')

Line 1955: delete from OKC_PRICE_ADJUSTMENTS

1951: */
1952: --Bug 3122962
1953: delete from OKC_TIMEVALUES where DNZ_CHR_ID = p_chr_id;
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

Line 1960: 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:
1963: delete from OKC_PRICE_ADJ_ATTRIBS
1964: WHERE pat_id in ( select pat_id

Line 1965: 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:
1968: -- Incorrect location for this delete statement below
1969: -- delete from OKC_PRICE_ATT_VALUES WHERE chr_id = p_chr_id or cle_id in (select id from okc_k_lines_b where dnz_chr_id=p_chr_id);

Line 2152: --Restore _OKC_PRICE_ADJUSTMENTS

2148: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2149: RAISE OKC_API.G_EXCEPTION_ERROR;
2150: END IF;
2151:
2152: --Restore _OKC_PRICE_ADJUSTMENTS
2153: l_return_status:=OKC_PAT_PVT.Restore_Version(l_chr_id,l_minus_version);
2154: --- If any errors happen abort API
2155: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2156: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;