DBA Data[Home] [Help]

APPS.OKL_CFO_PVT dependencies on FND_LOOKUP_VALUES

Line 424: FROM Fnd_Lookup_Values

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:

Line 425: WHERE fnd_lookup_values.lookup_code = p_lookup_code

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)

Line 426: AND fnd_lookup_values.lookup_type = p_lookup_type;

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

Line 447: 'FND_LOOKUP_VALUES');

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;

Line 622: FROM Fnd_Lookup_Values

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;

Line 623: WHERE fnd_lookup_values.lookup_code = p_lookup_code;

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;