DBA Data[Home] [Help]

APPS.OKL_OKC_MIGRATION_PVT dependencies on OKC_ROLE_SOURCES

Line 1708: FROM OKC_ROLE_SOURCES

1704: l_api_name CONSTANT VARCHAR2(30) := 'OKL_CREATE_K_PARTY_ROLE';
1705:
1706: CURSOR role_csr(p_rle_code VARCHAR2) IS
1707: SELECT access_level
1708: FROM OKC_ROLE_SOURCES
1709: WHERE rle_code = p_rle_code
1710: AND buy_or_sell = 'S';
1711:
1712: l_access_level OKC_ROLE_SOURCES.access_level%TYPE;

Line 1712: l_access_level OKC_ROLE_SOURCES.access_level%TYPE;

1708: FROM OKC_ROLE_SOURCES
1709: WHERE rle_code = p_rle_code
1710: AND buy_or_sell = 'S';
1711:
1712: l_access_level OKC_ROLE_SOURCES.access_level%TYPE;
1713:
1714: /*
1715: -- mvasudev, 09/09/2004
1716: -- Code change to enable Business Event

Line 1950: FROM OKC_ROLE_SOURCES

1946: l_api_name CONSTANT VARCHAR2(30) := 'OKL_UPDATE_K_PARTY_ROLE';
1947:
1948: CURSOR role_csr(p_rle_code VARCHAR2) IS
1949: SELECT access_level
1950: FROM OKC_ROLE_SOURCES
1951: WHERE rle_code = p_rle_code
1952: AND buy_or_sell = 'S';
1953:
1954: l_access_level OKC_ROLE_SOURCES.access_level%TYPE;

Line 1954: l_access_level OKC_ROLE_SOURCES.access_level%TYPE;

1950: FROM OKC_ROLE_SOURCES
1951: WHERE rle_code = p_rle_code
1952: AND buy_or_sell = 'S';
1953:
1954: l_access_level OKC_ROLE_SOURCES.access_level%TYPE;
1955:
1956: BEGIN
1957: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1958: -- Call start_activity to create savepoint, check compatibility