420: l_dummy_var VARCHAR2(1) := '?' ;
421:
422: CURSOR okl_cfov_oty_fk_csr (p_lookup_code IN VARCHAR2, p_lookup_type IN VARCHAR2) IS
423: SELECT 'x'
424: FROM Fnd_Lookup_Values
425: WHERE fnd_lookup_values.lookup_code = p_lookup_code
426: AND fnd_lookup_values.lookup_type = p_lookup_type;
427: BEGIN
428:
421:
422: CURSOR okl_cfov_oty_fk_csr (p_lookup_code IN VARCHAR2, p_lookup_type IN VARCHAR2) IS
423: SELECT 'x'
424: FROM Fnd_Lookup_Values
425: WHERE fnd_lookup_values.lookup_code = p_lookup_code
426: AND fnd_lookup_values.lookup_type = p_lookup_type;
427: BEGIN
428:
429: IF (p_cfov_rec.oty_code = OKL_API.G_MISS_CHAR OR p_cfov_rec.oty_code IS NULL)
422: CURSOR okl_cfov_oty_fk_csr (p_lookup_code IN VARCHAR2, p_lookup_type IN VARCHAR2) IS
423: SELECT 'x'
424: FROM Fnd_Lookup_Values
425: WHERE fnd_lookup_values.lookup_code = p_lookup_code
426: AND fnd_lookup_values.lookup_type = p_lookup_type;
427: BEGIN
428:
429: IF (p_cfov_rec.oty_code = OKL_API.G_MISS_CHAR OR p_cfov_rec.oty_code IS NULL)
430: THEN
443: 'oty_code',
444: g_child_table_token ,
445: 'OKL_CASH_FLOW_OBJECTS_V',
446: g_parent_table_token ,
447: 'FND_LOOKUP_VALUES');
448: l_return_status := OKC_API.G_RET_STS_ERROR;
449:
450: END IF;
451: END IF;
618: ) RETURN VARCHAR2 IS
619: item_not_found_error EXCEPTION;
620: CURSOR okl_cfov_oty_fk_csr (p_lookup_code IN VARCHAR2) IS
621: SELECT 'x'
622: FROM Fnd_Lookup_Values
623: WHERE fnd_lookup_values.lookup_code = p_lookup_code;
624: l_okl_cfov_oty_fk okl_cfov_oty_fk_csr%ROWTYPE;
625:
626: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
619: item_not_found_error EXCEPTION;
620: CURSOR okl_cfov_oty_fk_csr (p_lookup_code IN VARCHAR2) IS
621: SELECT 'x'
622: FROM Fnd_Lookup_Values
623: WHERE fnd_lookup_values.lookup_code = p_lookup_code;
624: l_okl_cfov_oty_fk okl_cfov_oty_fk_csr%ROWTYPE;
625:
626: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
627: l_row_notfound BOOLEAN := TRUE;