eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_ACTIVATE_ASSET_PVT dependencies on OKX_ASSETS_V

Line 693: l_book_type_code okx_assets_v.Corporate_Book%TYPE;

689: l_return_status VARCHAR2(1) default OKL_API.G_RET_STS_SUCCESS;
690: l_api_name CONSTANT varchar2(30) := 'CALC_NBV';
691: l_api_version CONSTANT NUMBER := 1.0;
692:
693: l_book_type_code okx_assets_v.Corporate_Book%TYPE;
694:
695:
696: Cursor asset_cost_csr (p_asset_id IN VARCHAR2) IS
697: Select cost,

Line 702: from OKX_ASSETS_V

698: corporate_book,
699: current_units,
700: name,
701: description
702: from OKX_ASSETS_V
703: where ID1 = p_asset_id
704: and status = 'A'
705: and nvl(start_date_active,sysdate) <= sysdate
706: and nvl(end_date_active,sysdate + 1) > sysdate;

Line 720: l_corporate_book OKX_ASSETS_V.Corporate_Book%Type;

716: and nvl(end_date_active,sysdate + 1) > sysdate;
717:
718: l_current_asset_cost Number;
719: l_current_units Number;
720: l_corporate_book OKX_ASSETS_V.Corporate_Book%Type;
721: l_total_deprn Number;
722: l_Nbv Number;
723: l_asset_number OKX_ASSETS_V.Name%Type;
724: l_asset_description OKX_ASSETS_V.Description%Type;

Line 723: l_asset_number OKX_ASSETS_V.Name%Type;

719: l_current_units Number;
720: l_corporate_book OKX_ASSETS_V.Corporate_Book%Type;
721: l_total_deprn Number;
722: l_Nbv Number;
723: l_asset_number OKX_ASSETS_V.Name%Type;
724: l_asset_description OKX_ASSETS_V.Description%Type;
725: Begin
726: -----
727: Open asset_cost_csr (p_asset_id);

Line 724: l_asset_description OKX_ASSETS_V.Description%Type;

720: l_corporate_book OKX_ASSETS_V.Corporate_Book%Type;
721: l_total_deprn Number;
722: l_Nbv Number;
723: l_asset_number OKX_ASSETS_V.Name%Type;
724: l_asset_description OKX_ASSETS_V.Description%Type;
725: Begin
726: -----
727: Open asset_cost_csr (p_asset_id);
728: Fetch asset_cost_csr into l_current_asset_cost,

Line 3166: l_asset_number OKX_ASSETS_V.NAME%Type;

3162: l_talv_rec talv_rec_type;
3163: l_cimv_rec cimv_rec_type;
3164: l_no_data_found BOOLEAN DEFAULT TRUE;
3165: l_current_units Number;
3166: l_asset_number OKX_ASSETS_V.NAME%Type;
3167: l_asset_description OKX_ASSETS_V.Description%Type;
3168: l_fa_line_id Number;
3169: l_fin_ast_line_id Number;
3170: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;

Line 3167: l_asset_description OKX_ASSETS_V.Description%Type;

3163: l_cimv_rec cimv_rec_type;
3164: l_no_data_found BOOLEAN DEFAULT TRUE;
3165: l_current_units Number;
3166: l_asset_number OKX_ASSETS_V.NAME%Type;
3167: l_asset_description OKX_ASSETS_V.Description%Type;
3168: l_fa_line_id Number;
3169: l_fin_ast_line_id Number;
3170: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
3171: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;

Line 3189: --l_book_type_code OKX_ASSETS_V.CORPORATE_BOOK%TYPE;

3185: l_start_date date;
3186: l_end_date date;
3187: l_org_id Number;
3188: l_inv_org_id Number;
3189: --l_book_type_code OKX_ASSETS_V.CORPORATE_BOOK%TYPE;
3190: l_select Varchar2(2000);
3191: --bug #2675391 : to store corporate book code for future
3192: l_corp_book OKX_ASSETS_V.CORPORATE_BOOK%TYPE;
3193: l_orig_cost OKX_ASSETS_V.ORIGINAL_COST%TYPE;

Line 3192: l_corp_book OKX_ASSETS_V.CORPORATE_BOOK%TYPE;

3188: l_inv_org_id Number;
3189: --l_book_type_code OKX_ASSETS_V.CORPORATE_BOOK%TYPE;
3190: l_select Varchar2(2000);
3191: --bug #2675391 : to store corporate book code for future
3192: l_corp_book OKX_ASSETS_V.CORPORATE_BOOK%TYPE;
3193: l_orig_cost OKX_ASSETS_V.ORIGINAL_COST%TYPE;
3194: l_corp_salvage_value NUMBER;
3195: --Bug# 3156924 : corporate book salvage value should also be preserved for future use
3196: l_corp_percent_sv NUMBER;

Line 3193: l_orig_cost OKX_ASSETS_V.ORIGINAL_COST%TYPE;

3189: --l_book_type_code OKX_ASSETS_V.CORPORATE_BOOK%TYPE;
3190: l_select Varchar2(2000);
3191: --bug #2675391 : to store corporate book code for future
3192: l_corp_book OKX_ASSETS_V.CORPORATE_BOOK%TYPE;
3193: l_orig_cost OKX_ASSETS_V.ORIGINAL_COST%TYPE;
3194: l_corp_salvage_value NUMBER;
3195: --Bug# 3156924 : corporate book salvage value should also be preserved for future use
3196: l_corp_percent_sv NUMBER;
3197: --bug # : 11.5.9 enhancements

Line 7553: l_current_asset_number OKX_ASSETS_V.Name%Type;

7549: l_adjust_cost NUMBER;
7550: l_adj_salvage_value NUMBER;
7551: l_adj_percent_sv NUMBER;
7552:
7553: l_current_asset_number OKX_ASSETS_V.Name%Type;
7554: l_asset_corp_book_cost NUMBER;
7555: ---------------------------------------------------
7556: --Bug# 3631094 : end
7557: ---------------------------------------------------