[Home] [Help]
1538:
1539: -- bug 5679233
1540: -- decomposed the delete query into following two sub queries because of performance issues
1541:
1542: delete FROM OKC_PRICE_ATT_VALUES_H
1543: WHERE (chr_id= p_chr_id )
1544: and ((MAJOR_VERSION = -1
1545: and p_called_from = 'ERASE_SAVED_VERSION')
1546: or (p_called_from = 'RESTORE_VERSION'
1546: or (p_called_from = 'RESTORE_VERSION'
1547: and (major_version >= l_major_version
1548: or major_version = -1)));
1549:
1550: delete FROM OKC_PRICE_ATT_VALUES_H
1551: WHERE (CLE_ID IN (SELECT ID FROM OKC_K_LINES_B WHERE DNZ_CHR_ID=p_chr_id ) )
1552: and ((MAJOR_VERSION = -1
1553: and p_called_from = 'ERASE_SAVED_VERSION')
1554: or (p_called_from = 'RESTORE_VERSION'
1893: delete from OKC_K_HEADERS_B where ID = p_chr_id;
1894:
1895: delete from OKC_K_ITEMS where DNZ_CHR_ID = p_chr_id;
1896: --
1897: 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);
1898: --
1899:
1900: delete from OKC_PH_LINE_BREAKS WHERE cle_id IN
1901: (SELECT 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);
1970: --
1971:
1972:
1973: delete from OKC_K_SALES_CREDITS WHERE dnz_chr_id = p_chr_id;
2175: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2176: RAISE OKC_API.G_EXCEPTION_ERROR;
2177: END IF;
2178:
2179: --Restore _OKC_PRICE_ATT_VALUES
2180: l_return_status:=OKC_PAV_PVT.Restore_Version(l_chr_id,l_minus_version);
2181: --- If any errors happen abort API
2182: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2183: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;