APPS.OKC_SRD_PVT dependencies on FND_LOOKUPS

Line 484: CURSOR fnd_lookups_pk_csr (p_lookup_code IN VARCHAR2) IS

480: CURSOR okc_scsv_pk_csr (p_code IN VARCHAR2) IS
481: SELECT 'x'
482: FROM Okc_Subclasses_V
483: WHERE okc_subclasses_v.code = p_code;
484: CURSOR fnd_lookups_pk_csr (p_lookup_code IN VARCHAR2) IS
485: SELECT 'x'
486: FROM Fnd_Lookups
487: WHERE fnd_lookups.lookup_code = p_lookup_code
488: AND fnd_lookups.lookup_type = 'OKC_RULE_GROUP_DEF';

Line 486: FROM Fnd_Lookups

482: FROM Okc_Subclasses_V
483: WHERE okc_subclasses_v.code = p_code;
484: CURSOR fnd_lookups_pk_csr (p_lookup_code IN VARCHAR2) IS
485: SELECT 'x'
486: FROM Fnd_Lookups
487: WHERE fnd_lookups.lookup_code = p_lookup_code
488: AND fnd_lookups.lookup_type = 'OKC_RULE_GROUP_DEF';
489: l_dummy VARCHAR2(1);
490: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 487: WHERE fnd_lookups.lookup_code = p_lookup_code

483: WHERE okc_subclasses_v.code = p_code;
484: CURSOR fnd_lookups_pk_csr (p_lookup_code IN VARCHAR2) IS
485: SELECT 'x'
486: FROM Fnd_Lookups
487: WHERE fnd_lookups.lookup_code = p_lookup_code
488: AND fnd_lookups.lookup_type = 'OKC_RULE_GROUP_DEF';
489: l_dummy VARCHAR2(1);
490: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
491: l_row_notfound BOOLEAN := TRUE;

Line 488: AND fnd_lookups.lookup_type = 'OKC_RULE_GROUP_DEF';

484: CURSOR fnd_lookups_pk_csr (p_lookup_code IN VARCHAR2) IS
485: SELECT 'x'
486: FROM Fnd_Lookups
487: WHERE fnd_lookups.lookup_code = p_lookup_code
488: AND fnd_lookups.lookup_type = 'OKC_RULE_GROUP_DEF';
489: l_dummy VARCHAR2(1);
490: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
491: l_row_notfound BOOLEAN := TRUE;
492: BEGIN

Line 506: OPEN fnd_lookups_pk_csr(p_srdv_rec.RGD_CODE);

502: END IF;
503: END IF;
504: IF (p_srdv_rec.RGD_CODE IS NOT NULL)
505: THEN
506: OPEN fnd_lookups_pk_csr(p_srdv_rec.RGD_CODE);
507: FETCH fnd_lookups_pk_csr INTO l_dummy;
508: l_row_notfound := fnd_lookups_pk_csr%NOTFOUND;
509: CLOSE fnd_lookups_pk_csr;
510: IF (l_row_notfound) THEN

Line 507: FETCH fnd_lookups_pk_csr INTO l_dummy;

503: END IF;
504: IF (p_srdv_rec.RGD_CODE IS NOT NULL)
505: THEN
506: OPEN fnd_lookups_pk_csr(p_srdv_rec.RGD_CODE);
507: FETCH fnd_lookups_pk_csr INTO l_dummy;
508: l_row_notfound := fnd_lookups_pk_csr%NOTFOUND;
509: CLOSE fnd_lookups_pk_csr;
510: IF (l_row_notfound) THEN
511: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'RGD_CODE');

Line 508: l_row_notfound := fnd_lookups_pk_csr%NOTFOUND;

504: IF (p_srdv_rec.RGD_CODE IS NOT NULL)
505: THEN
506: OPEN fnd_lookups_pk_csr(p_srdv_rec.RGD_CODE);
507: FETCH fnd_lookups_pk_csr INTO l_dummy;
508: l_row_notfound := fnd_lookups_pk_csr%NOTFOUND;
509: CLOSE fnd_lookups_pk_csr;
510: IF (l_row_notfound) THEN
511: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'RGD_CODE');
512: RAISE item_not_found_error;

Line 509: CLOSE fnd_lookups_pk_csr;

505: THEN
506: OPEN fnd_lookups_pk_csr(p_srdv_rec.RGD_CODE);
507: FETCH fnd_lookups_pk_csr INTO l_dummy;
508: l_row_notfound := fnd_lookups_pk_csr%NOTFOUND;
509: CLOSE fnd_lookups_pk_csr;
510: IF (l_row_notfound) THEN
511: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'RGD_CODE');
512: RAISE item_not_found_error;
513: END IF;