APPS.OKL_MASS_REBOOK_PVT dependencies on OKX_AST_BKS_V

Line 1377: CURSOR book_csr (p_asset_number okx_ast_bks_v.asset_number%TYPE,

1373: FROM okl_trx_types_tl
1374: WHERE language = 'US'
1375: AND name = p_trx_type;
1376:
1377: CURSOR book_csr (p_asset_number okx_ast_bks_v.asset_number%TYPE,
1378: p_book_type_code okx_ast_bks_v.book_type_code%TYPE,
1379: p_book_class okx_ast_bks_v.book_class%TYPE) IS
1380: SELECT id2,
1381: deprn_method_code,

Line 1378: p_book_type_code okx_ast_bks_v.book_type_code%TYPE,

1374: WHERE language = 'US'
1375: AND name = p_trx_type;
1376:
1377: CURSOR book_csr (p_asset_number okx_ast_bks_v.asset_number%TYPE,
1378: p_book_type_code okx_ast_bks_v.book_type_code%TYPE,
1379: p_book_class okx_ast_bks_v.book_class%TYPE) IS
1380: SELECT id2,
1381: deprn_method_code,
1382: life_in_months,

Line 1379: p_book_class okx_ast_bks_v.book_class%TYPE) IS

1375: AND name = p_trx_type;
1376:
1377: CURSOR book_csr (p_asset_number okx_ast_bks_v.asset_number%TYPE,
1378: p_book_type_code okx_ast_bks_v.book_type_code%TYPE,
1379: p_book_class okx_ast_bks_v.book_class%TYPE) IS
1380: SELECT id2,
1381: deprn_method_code,
1382: life_in_months,
1383: acquisition_date,

Line 1385: FROM okx_ast_bks_v

1381: deprn_method_code,
1382: life_in_months,
1383: acquisition_date,
1384: cost
1385: FROM okx_ast_bks_v
1386: WHERE book_class = p_book_class
1387: AND asset_number = p_asset_number
1388: AND book_type_code = NVL(p_book_type_code, book_type_code);
1389:

Line 1428: l_corp_book OKX_AST_BKS_V.ID2%TYPE;

1424:
1425: l_name OKL_K_LINES_FULL_V.NAME%TYPE;
1426: l_oec OKL_K_LINES_FULL_V.OEC%TYPE;
1427: l_no_of_items OKC_K_ITEMS.NUMBER_OF_ITEMS%TYPE;
1428: l_corp_book OKX_AST_BKS_V.ID2%TYPE;
1429:
1430: l_tax_count NUMBER;
1431: l_deprn_method_code OKX_AST_BKS_V.DEPRN_METHOD_CODE%TYPE;
1432: l_life_in_months OKX_AST_BKS_V.LIFE_IN_MONTHS%TYPE;

Line 1431: l_deprn_method_code OKX_AST_BKS_V.DEPRN_METHOD_CODE%TYPE;

1427: l_no_of_items OKC_K_ITEMS.NUMBER_OF_ITEMS%TYPE;
1428: l_corp_book OKX_AST_BKS_V.ID2%TYPE;
1429:
1430: l_tax_count NUMBER;
1431: l_deprn_method_code OKX_AST_BKS_V.DEPRN_METHOD_CODE%TYPE;
1432: l_life_in_months OKX_AST_BKS_V.LIFE_IN_MONTHS%TYPE;
1433: l_cost OKX_AST_BKS_V.COST%TYPE;
1434: l_acquisition_date DATE;
1435:

Line 1432: l_life_in_months OKX_AST_BKS_V.LIFE_IN_MONTHS%TYPE;

1428: l_corp_book OKX_AST_BKS_V.ID2%TYPE;
1429:
1430: l_tax_count NUMBER;
1431: l_deprn_method_code OKX_AST_BKS_V.DEPRN_METHOD_CODE%TYPE;
1432: l_life_in_months OKX_AST_BKS_V.LIFE_IN_MONTHS%TYPE;
1433: l_cost OKX_AST_BKS_V.COST%TYPE;
1434: l_acquisition_date DATE;
1435:
1436: asset_change_failed EXCEPTION;

Line 1433: l_cost OKX_AST_BKS_V.COST%TYPE;

1429:
1430: l_tax_count NUMBER;
1431: l_deprn_method_code OKX_AST_BKS_V.DEPRN_METHOD_CODE%TYPE;
1432: l_life_in_months OKX_AST_BKS_V.LIFE_IN_MONTHS%TYPE;
1433: l_cost OKX_AST_BKS_V.COST%TYPE;
1434: l_acquisition_date DATE;
1435:
1436: asset_change_failed EXCEPTION;
1437: --Added by dpsingh for LE uptake