APPS.OKC_OCE_PVT dependencies on OKX_RESOURCES_V

Line 998: from okx_resources_v

994: x_return_status OUT NOCOPY VARCHAR2,
995: p_ocev_rec IN ocev_rec_type) IS
996: Cursor success_resource_id_cur(p_success_resource_id IN NUMBER) IS
997: select '1'
998: from okx_resources_v
999: where id1 = p_success_resource_id
1000: and resource_type = 'EMPLOYEE'
1001: and status = 'A';
1002: l_dummy VARCHAR2(1) := '?';

Line 1008: --Check if id exists in the okx_resources_v or not

1004: -- initialize return status
1005: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1006:
1007: IF p_ocev_rec.success_resource_id IS NOT NULL THEN
1008: --Check if id exists in the okx_resources_v or not
1009: OPEN success_resource_id_cur(p_ocev_rec.success_resource_id);
1010: FETCH success_resource_id_cur INTO l_dummy;
1011: CLOSE success_resource_id_cur ;
1012: IF l_dummy = '?' THEN

Line 1051: from okx_resources_v

1047: x_return_status OUT NOCOPY VARCHAR2,
1048: p_ocev_rec IN ocev_rec_type) IS
1049: Cursor failure_resource_id_cur(p_failure_resource_id IN NUMBER) IS
1050: select '1'
1051: from okx_resources_v
1052: where id1 = p_failure_resource_id
1053: and resource_type = 'EMPLOYEE'
1054: and status = 'A';
1055: l_dummy VARCHAR2(1) := '?';

Line 1061: --Check if id exists in the okx_resources_v or not

1057: -- initialize return status
1058: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1059:
1060: IF p_ocev_rec.failure_resource_id IS NOT NULL THEN
1061: --Check if id exists in the okx_resources_v or not
1062: OPEN failure_resource_id_cur(p_ocev_rec.failure_resource_id);
1063: FETCH failure_resource_id_cur INTO l_dummy;
1064: CLOSE failure_resource_id_cur ;
1065: IF l_dummy = '?' THEN