APPS.OKL_TCN_PVT dependencies on FND_LOOKUPS

Line 1575: -- check in fnd_lookups for validity

1571: x_return_status := Okc_Api.G_RET_STS_ERROR;
1572: RAISE G_EXCEPTION_HALT_VALIDATION;
1573: END IF;
1574:
1575: -- check in fnd_lookups for validity
1576:
1577: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE
1578: (p_lookup_type => 'OKL_TCN_TYPE',
1579: p_lookup_code => p_tcnv_rec.tcn_type);

Line 1631: -- check in fnd_lookups for validity

1627: BEGIN
1628: -- initialize return status
1629: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
1630:
1631: -- check in fnd_lookups for validity
1632:
1633: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE
1634: (p_lookup_type => 'OKL_REJECTION_REASON',
1635: p_lookup_code => p_tcnv_rec.rjn_code);

Line 1754: -- check in fnd_lookups for validity

1750:
1751: -- check for data before processing
1752: IF (p_tcnv_rec.accrual_status_yn IS NOT NULL) AND
1753: (p_tcnv_rec.accrual_status_yn <> Okc_Api.G_MISS_CHAR) THEN
1754: -- check in fnd_lookups for validity
1755: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE
1756: (p_lookup_type => 'YES_NO',
1757: p_lookup_code => p_tcnv_rec.accrual_status_yn,
1758: p_app_id => l_app_id,

Line 1819: -- check in fnd_lookups for validity

1815:
1816: -- check for data before processing
1817: IF (p_tcnv_rec.update_status_yn IS NOT NULL) AND
1818: (p_tcnv_rec.update_status_yn <> Okc_Api.G_MISS_CHAR) THEN
1819: -- check in fnd_lookups for validity
1820: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE
1821: (p_lookup_type => 'YES_NO',
1822: p_lookup_code => p_tcnv_rec.update_status_yn,
1823: p_app_id => l_app_id,

Line 1888: -- check in fnd_lookups for validity

1884:
1885: -- check for data before processing
1886: IF (p_tcnv_rec.Accounting_Reversal_YN IS NOT NULL) AND
1887: (p_tcnv_rec.Accounting_Reversal_YN <> Okc_Api.G_MISS_CHAR) THEN
1888: -- check in fnd_lookups for validity
1889: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE
1890: (p_lookup_type => 'YES_NO',
1891: p_lookup_code => p_tcnv_rec.Accounting_Reversal_YN,
1892: p_app_id => l_app_id,

Line 2963: -- check in fnd_lookups for validity

2959: BEGIN
2960: -- initialize return status
2961: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
2962:
2963: -- check in fnd_lookups for validity
2964: IF p_tcnv_rec.accrual_activity IS NOT NULL THEN
2965: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE
2966: (p_lookup_type => 'OKL_ACCRUAL_ACTIVITY',
2967: p_lookup_code => p_tcnv_rec.accrual_activity);

Line 3345: -- check in fnd_lookups for validity

3341:
3342: -- check for data before processing
3343: IF (p_tcnv_rec.UPGRADE_STATUS_FLAG IS NOT NULL) AND
3344: (p_tcnv_rec.UPGRADE_STATUS_FLAG <> Okc_Api.G_MISS_CHAR) THEN
3345: -- check in fnd_lookups for validity
3346: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE
3347: (p_lookup_type => 'OKL_YES_NO',
3348: p_lookup_code => p_tcnv_rec.UPGRADE_STATUS_FLAG);
3349:

Line 3475: from fnd_lookups lkp

3471: item_not_found_error EXCEPTION;
3472:
3473: CURSOR rep_type_csr (p_rep_code IN VARCHAR2) IS
3474: SELECT '1'
3475: from fnd_lookups lkp
3476: where lkp.lookup_type = 'OKL_REPRESENTATION_TYPE'
3477: and lkp.lookup_code = p_rep_code;
3478: BEGIN
3479: