640: l_dummy_var VARCHAR2(1) := '?' ;
641:
642: CURSOR okl_cflv_fqy_fk_csr (p_lookup_code IN VARCHAR2, p_lookup_type IN VARCHAR2) IS
643: SELECT 'x'
644: FROM Fnd_Lookup_Values
645: WHERE fnd_lookup_values.lookup_code = p_lookup_code
646: AND fnd_lookup_values.lookup_type = p_lookup_type;
647: BEGIN
648:
641:
642: CURSOR okl_cflv_fqy_fk_csr (p_lookup_code IN VARCHAR2, p_lookup_type IN VARCHAR2) IS
643: SELECT 'x'
644: FROM Fnd_Lookup_Values
645: WHERE fnd_lookup_values.lookup_code = p_lookup_code
646: AND fnd_lookup_values.lookup_type = p_lookup_type;
647: BEGIN
648:
649: /* IF (p_cflv_rec.fqy_code = OKL_API.G_MISS_CHAR OR p_cflv_rec.fqy_code IS NULL)
642: CURSOR okl_cflv_fqy_fk_csr (p_lookup_code IN VARCHAR2, p_lookup_type IN VARCHAR2) IS
643: SELECT 'x'
644: FROM Fnd_Lookup_Values
645: WHERE fnd_lookup_values.lookup_code = p_lookup_code
646: AND fnd_lookup_values.lookup_type = p_lookup_type;
647: BEGIN
648:
649: /* IF (p_cflv_rec.fqy_code = OKL_API.G_MISS_CHAR OR p_cflv_rec.fqy_code IS NULL)
650: THEN
665: 'fqy_code',
666: g_child_table_token ,
667: 'OKL_CASH_FLOW_LEVELS_V',
668: g_parent_table_token ,
669: 'FND_LOOKUP_VALUES');
670: l_return_status := OKC_API.G_RET_STS_ERROR;
671:
672: END IF;
673: END IF;
924: l_okl_cflv_cafv_fk okl_cflv_cafv_fk_csr%ROWTYPE;
925:
926: CURSOR okl_cflv_fqy_fk_csr (p_lookup_code IN VARCHAR2) IS
927: SELECT 'x'
928: FROM Fnd_Lookup_Values
929: WHERE fnd_lookup_values.lookup_code = p_lookup_code;
930: l_okl_cflv_fqy_fk okl_cflv_fqy_fk_csr%ROWTYPE;
931:
932: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
925:
926: CURSOR okl_cflv_fqy_fk_csr (p_lookup_code IN VARCHAR2) IS
927: SELECT 'x'
928: FROM Fnd_Lookup_Values
929: WHERE fnd_lookup_values.lookup_code = p_lookup_code;
930: l_okl_cflv_fqy_fk okl_cflv_fqy_fk_csr%ROWTYPE;
931:
932: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
933: l_row_notfound BOOLEAN := TRUE;