DBA Data[Home] [Help]

APPS.OKL_OKC_MIGRATION_PVT dependencies on OKC_ROLE_SOURCES

Line 1655: FROM OKC_ROLE_SOURCES

1651: l_api_name CONSTANT VARCHAR2(30) := 'OKL_CREATE_K_PARTY_ROLE';
1652:
1653: CURSOR role_csr(p_rle_code VARCHAR2) IS
1654: SELECT access_level
1655: FROM OKC_ROLE_SOURCES
1656: WHERE rle_code = p_rle_code
1657: AND buy_or_sell = 'S';
1658:
1659: l_access_level OKC_ROLE_SOURCES.access_level%TYPE;

Line 1659: l_access_level OKC_ROLE_SOURCES.access_level%TYPE;

1655: FROM OKC_ROLE_SOURCES
1656: WHERE rle_code = p_rle_code
1657: AND buy_or_sell = 'S';
1658:
1659: l_access_level OKC_ROLE_SOURCES.access_level%TYPE;
1660:
1661: /*
1662: -- mvasudev, 09/09/2004
1663: -- Code change to enable Business Event

Line 1897: FROM OKC_ROLE_SOURCES

1893: l_api_name CONSTANT VARCHAR2(30) := 'OKL_UPDATE_K_PARTY_ROLE';
1894:
1895: CURSOR role_csr(p_rle_code VARCHAR2) IS
1896: SELECT access_level
1897: FROM OKC_ROLE_SOURCES
1898: WHERE rle_code = p_rle_code
1899: AND buy_or_sell = 'S';
1900:
1901: l_access_level OKC_ROLE_SOURCES.access_level%TYPE;

Line 1901: l_access_level OKC_ROLE_SOURCES.access_level%TYPE;

1897: FROM OKC_ROLE_SOURCES
1898: WHERE rle_code = p_rle_code
1899: AND buy_or_sell = 'S';
1900:
1901: l_access_level OKC_ROLE_SOURCES.access_level%TYPE;
1902:
1903: BEGIN
1904: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1905: -- Call start_activity to create savepoint, check compatibility