DBA Data[Home] [Help]

APPS.OKS_COVERAGE_UTIL_PVT dependencies on OKC_API

Line 105: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

101: x_return_status OUT NOCOPY VARCHAR2)
102: IS
103: -- Procedure Name ussed for loggin
104: l_api_name CONSTANT VARCHAR2(30) := 'process_new_coverage_times';
105: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
106: l_intervals_match_flag VARCHAR2(1) := 'N';
107:
108: BEGIN
109: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 211: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

207: x_return_status OUT NOCOPY VARCHAR2)
208: IS
209: -- Procedure Name ussed for loggin
210: l_api_name CONSTANT VARCHAR2(30) := 'init_coverage_times_view';
211: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
212:
213: CURSOR flattened_time_limits_cur IS
214: SELECT
215: to_number(START_HOUR||decode(LENGTH(START_MINUTE),1,'0'||START_MINUTE,START_MINUTE)) time,