DBA Data[Home] [Help]

APPS.OKL_CFP_PVT dependencies on FND_LOOKUP_VALUES

Line 483: FROM Fnd_Lookup_Values

479:
480:
481: CURSOR okl_cfpv_ptp_fk_csr (p_lookup_code IN VARCHAR2, p_lookup_type IN VARCHAR2) IS
482: SELECT 'x'
483: FROM Fnd_Lookup_Values
484: WHERE fnd_lookup_values.lookup_code = p_lookup_code
485: AND fnd_lookup_values.lookup_type = p_lookup_type;
486: BEGIN
487:

Line 484: WHERE fnd_lookup_values.lookup_code = p_lookup_code

480:
481: CURSOR okl_cfpv_ptp_fk_csr (p_lookup_code IN VARCHAR2, p_lookup_type IN VARCHAR2) IS
482: SELECT 'x'
483: FROM Fnd_Lookup_Values
484: WHERE fnd_lookup_values.lookup_code = p_lookup_code
485: AND fnd_lookup_values.lookup_type = p_lookup_type;
486: BEGIN
487:
488: IF (p_cfpv_rec.ptp_code = OKL_API.G_MISS_CHAR OR p_cfpv_rec.ptp_code IS NULL)

Line 485: AND fnd_lookup_values.lookup_type = p_lookup_type;

481: CURSOR okl_cfpv_ptp_fk_csr (p_lookup_code IN VARCHAR2, p_lookup_type IN VARCHAR2) IS
482: SELECT 'x'
483: FROM Fnd_Lookup_Values
484: WHERE fnd_lookup_values.lookup_code = p_lookup_code
485: AND fnd_lookup_values.lookup_type = p_lookup_type;
486: BEGIN
487:
488: IF (p_cfpv_rec.ptp_code = OKL_API.G_MISS_CHAR OR p_cfpv_rec.ptp_code IS NULL)
489: THEN

Line 507: 'FND_LOOKUP_VALUES');

503: 'ptp_code',
504: g_child_table_token ,
505: 'OKL_CF_OBJECT_PERIODS_V',
506: g_parent_table_token ,
507: 'FND_LOOKUP_VALUES');
508: l_return_status := OKC_API.G_RET_STS_ERROR;
509:
510: END IF;
511: END IF;

Line 660: FROM Fnd_Lookup_Values

656: l_okl_cfpv_cfov_fk okl_cfpv_cfov_fk_csr%ROWTYPE;
657:
658: CURSOR okl_cfpv_ptp_fk_csr (p_lookup_code IN VARCHAR2) IS
659: SELECT 'x'
660: FROM Fnd_Lookup_Values
661: WHERE fnd_lookup_values.lookup_code = p_lookup_code;
662: l_okl_cfpv_ptp_fk okl_cfpv_ptp_fk_csr%ROWTYPE;
663:
664: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 661: WHERE fnd_lookup_values.lookup_code = p_lookup_code;

657:
658: CURSOR okl_cfpv_ptp_fk_csr (p_lookup_code IN VARCHAR2) IS
659: SELECT 'x'
660: FROM Fnd_Lookup_Values
661: WHERE fnd_lookup_values.lookup_code = p_lookup_code;
662: l_okl_cfpv_ptp_fk okl_cfpv_ptp_fk_csr%ROWTYPE;
663:
664: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
665: l_row_notfound BOOLEAN := TRUE;