APPS.OKL_OPEN_INTERFACE_PVT dependencies on FND_CURRENCIES

Line 1510: -- It validates currency Code against database, FND_CURRENCIES

1506: END check_stream_type_code;
1507:
1508: ------------------------------------------------------------------------------
1509: -- FUNCTION validate_currency_code
1510: -- It validates currency Code against database, FND_CURRENCIES
1511: -- Returns OKL_API.G_RET_STS_ERROR for unknown currency code
1512: -- OKL_API.G_RET_STS_SUCCESS for valid currency code
1513: -- Calls:
1514: -- None

Line 1523: CURSOR currency_csr(p_curr_code FND_CURRENCIES.CURRENCY_CODE%TYPE) IS

1519: FUNCTION validate_currency_code (p_contract_number IN OKL_HEADER_INTERFACE.CONTRACT_NUMBER_OLD%TYPE,
1520: p_currency_code IN VARCHAR2)
1521: RETURN VARCHAR2 IS
1522:
1523: CURSOR currency_csr(p_curr_code FND_CURRENCIES.CURRENCY_CODE%TYPE) IS
1524: SELECT currency_code
1525: FROM FND_CURRENCIES
1526: WHERE currency_code = p_curr_code
1527: AND NVL(end_date_active,SYSDATE) >= SYSDATE;

Line 1525: FROM FND_CURRENCIES

1521: RETURN VARCHAR2 IS
1522:
1523: CURSOR currency_csr(p_curr_code FND_CURRENCIES.CURRENCY_CODE%TYPE) IS
1524: SELECT currency_code
1525: FROM FND_CURRENCIES
1526: WHERE currency_code = p_curr_code
1527: AND NVL(end_date_active,SYSDATE) >= SYSDATE;
1528:
1529: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;

Line 1530: l_currency_code FND_CURRENCIES.CURRENCY_CODE%TYPE;

1526: WHERE currency_code = p_curr_code
1527: AND NVL(end_date_active,SYSDATE) >= SYSDATE;
1528:
1529: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
1530: l_currency_code FND_CURRENCIES.CURRENCY_CODE%TYPE;
1531:
1532: BEGIN
1533:
1534: IF (p_currency_code IS NULL) THEN