DBA Data[Home] [Help]

APPS.OKL_AM_ASSET_RETURN_PVT dependencies on FND_LOOKUPS

Line 1557: l_meaning fnd_lookups.meaning%TYPE := NULL;

1553: l_accepted_yn VARCHAR2(1);
1554: i NUMBER;
1555: l_total_quantity NUMBER;
1556: l_item_number VARCHAR2(40);
1557: l_meaning fnd_lookups.meaning%TYPE := NULL;
1558: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'update_asset_return';
1559: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1560: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1561: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);

Line 1614: FROM fnd_lookups

1610: --define the cursor to obtain meaning for a given lookup type and code
1611: CURSOR l_lookup_meaning_csr(p_lookup_type VARCHAR2, p_lookup_code VARCHAR2)
1612: IS
1613: SELECT meaning
1614: FROM fnd_lookups
1615: WHERE lookup_type = p_lookup_type
1616: AND lookup_code = p_lookup_code;
1617:
1618: l_asset_return_type fnd_lookups.meaning%TYPE;

Line 1618: l_asset_return_type fnd_lookups.meaning%TYPE;

1614: FROM fnd_lookups
1615: WHERE lookup_type = p_lookup_type
1616: AND lookup_code = p_lookup_code;
1617:
1618: l_asset_return_type fnd_lookups.meaning%TYPE;
1619: l_asset_return_status fnd_lookups.meaning%TYPE;
1620: --Bug 3918852 fix ends
1621:
1622: -- SECHAWLA 30-SEP-04 3924244 : New declarations begin

Line 1619: l_asset_return_status fnd_lookups.meaning%TYPE;

1615: WHERE lookup_type = p_lookup_type
1616: AND lookup_code = p_lookup_code;
1617:
1618: l_asset_return_type fnd_lookups.meaning%TYPE;
1619: l_asset_return_status fnd_lookups.meaning%TYPE;
1620: --Bug 3918852 fix ends
1621:
1622: -- SECHAWLA 30-SEP-04 3924244 : New declarations begin
1623: