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_AST_BKS_V

Line 965: p_book_type_code IN OKX_AST_BKS_V.BOOK_TYPE_CODE%TYPE,

961: x_msg_count OUT NOCOPY NUMBER,
962: x_msg_data OUT NOCOPY VARCHAR2,
963: p_chr_id IN NUMBER,
964: p_asset_id IN NUMBER,
965: p_book_type_code IN OKX_AST_BKS_V.BOOK_TYPE_CODE%TYPE,
966: p_adjust_cost IN NUMBER,
967: --Bug# 2657558
968: p_adj_salvage_value IN NUMBER,
969: --Bug# 2981308

Line 1011: l_book_type_code OKX_AST_BKS_V.BOOK_TYPE_CODE%TYPE;

1007: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
1008: l_group_recalss_option_rec FA_API_TYPES.group_reclass_options_rec_type;
1009:
1010: l_asset_id NUMBER;
1011: l_book_type_code OKX_AST_BKS_V.BOOK_TYPE_CODE%TYPE;
1012: l_adjust_cost NUMBER;
1013: --Bug # 2657558
1014: l_adj_salvage_value NUMBER;
1015: --Bug# 2981308

Line 1290: p_book_type_code IN OKX_AST_BKS_V.BOOK_TYPE_CODE%TYPE,

1286: x_msg_count OUT NOCOPY NUMBER,
1287: x_msg_data OUT NOCOPY VARCHAR2,
1288: p_chr_id IN NUMBER,
1289: p_asset_id IN NUMBER,
1290: p_book_type_code IN OKX_AST_BKS_V.BOOK_TYPE_CODE%TYPE,
1291: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
1292: --Bug Fix# 2925461
1293: p_adj_date IN DATE,
1294: --Bug# 3156924

Line 1330: l_book_type_code OKX_AST_BKS_V.BOOK_TYPE_CODE%TYPE;

1326: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
1327: l_group_recalss_option_rec FA_API_TYPES.group_reclass_options_rec_type;
1328:
1329: l_asset_id NUMBER;
1330: l_book_type_code OKX_AST_BKS_V.BOOK_TYPE_CODE%TYPE;
1331:
1332: l_mesg_len NUMBER;
1333: l_mesg Varchar2(2000);
1334:

Line 3069: FROM OKX_AST_BKS_V

3065: --Cursor to check if asset_id already exists in tax_book
3066: CURSOR chk_ast_bk_csr(p_book_type_code IN Varchar2,
3067: p_asset_id IN Number) is
3068: SELECT '!'
3069: FROM OKX_AST_BKS_V
3070: WHERE asset_id = p_asset_id
3071: AND book_type_code = p_book_type_code
3072: AND status = 'A';
3073:

Line 3094: from okx_ast_bks_v

3090: --Bug# 2657558
3091: salvage_value,
3092: --Bug# 2981308
3093: percent_salvage_value
3094: from okx_ast_bks_v
3095: where asset_id = p_Asset_id
3096: and book_class = p_book_class;
3097:
3098: l_book_type_code OKX_AST_BKS_V.BOOK_TYPE_CODE%TYPE;

Line 3098: l_book_type_code OKX_AST_BKS_V.BOOK_TYPE_CODE%TYPE;

3094: from okx_ast_bks_v
3095: where asset_id = p_Asset_id
3096: and book_class = p_book_class;
3097:
3098: l_book_type_code OKX_AST_BKS_V.BOOK_TYPE_CODE%TYPE;
3099: l_asset_cost NUMBER;
3100: l_adjust_cost NUMBER;
3101: --Bug# 2657558
3102: l_salvage_value NUMBER;

Line 3139: FROM okx_ast_bks_v okx

3135: okx.book_type_code book_type_code,
3136: okx.book_class book_class,
3137: okx.asset_number asset_number,
3138: okx.asset_id asset_id
3139: FROM okx_ast_bks_v okx
3140: WHERE okx.asset_id = p_asset_id
3141: AND okx.book_type_code = p_book_type_code;
3142:
3143: okx_ast_rec okx_ast_csr%RowType;

Line 3189: l_rep_pdt_book OKX_AST_BKS_V.book_type_code%TYPE;

3185: l_corp_salvage_value NUMBER;
3186: --Bug# 3156924 : corporate book salvage value should also be preserved for future use
3187: l_corp_percent_sv NUMBER;
3188: --bug # : 11.5.9 enhancements
3189: l_rep_pdt_book OKX_AST_BKS_V.book_type_code%TYPE;
3190: l_Multi_GAAP_YN Varchar2(1);
3191: l_rep_pdt_bk_done Varchar2(1) default 'N';
3192:
3193: l_chrv_rec okl_okc_migration_pvt.chrv_rec_type;

Line 4661: l_rep_pdt_book OKX_AST_BKS_V.Book_Type_Code%Type;

4657: l_rep_pdt_id Number;
4658: l_tax_owner Varchar2(150);
4659: l_rep_deal_type Varchar2(150);
4660: l_Multi_GAAP_YN Varchar2(1);
4661: l_rep_pdt_book OKX_AST_BKS_V.Book_Type_Code%Type;
4662: --cursor to get tax owner rule
4663: Cursor town_rul_csr (pchrid number) is
4664: Select rule_information1 tax_owner,
4665: id

Line 5069: l_rep_pdt_book OKX_AST_BKS_V.Book_Type_Code%Type;

5065: l_rep_pdt_id Number;
5066: l_pdt_tax_owner Varchar2(150);
5067: l_rep_deal_type Varchar2(150);
5068: l_Multi_GAAP_YN Varchar2(1) := 'N';
5069: l_rep_pdt_book OKX_AST_BKS_V.Book_Type_Code%Type;
5070: --Bug# 3156924 :
5071: l_trx_number okl_trx_contracts.trx_number%TYPE;
5072: l_calling_interface varchar2(30) := 'OKL: Rebook';
5073:

Line 5253: FROM okx_ast_bks_v okx

5249: --Bug# 3950089
5250: okx.percent_salvage_value percent_salvage_value,
5251: --Bug# 5207066
5252: okx.current_units fa_current_units
5253: FROM okx_ast_bks_v okx
5254: WHERE okx.asset_number = p_asset_number
5255: AND okx.book_type_code = nvl(p_book_type_code,okx.book_type_code);
5256:
5257: okx_ast_rec okx_ast_csr%ROWTYPE;

Line 6514: l_rep_pdt_book OKX_AST_BKS_V.Book_Type_Code%Type;

6510: l_start_date Date;
6511: l_rep_pdt_id Number;
6512: l_rep_deal_type Varchar2(150);
6513: l_Multi_GAAP_YN Varchar2(1) := 'N';
6514: l_rep_pdt_book OKX_AST_BKS_V.Book_Type_Code%Type;
6515:
6516: l_dummy_amount NUMBER;
6517:
6518: --cursor to get the actual values from FA for the contract

Line 6533: FROM okx_ast_bks_v okx

6529: okx.book_type_code book_type_code,
6530: okx.book_class book_class,
6531: okx.asset_number asset_number,
6532: okx.asset_id asset_id
6533: FROM okx_ast_bks_v okx
6534: WHERE okx.asset_number = p_asset_number
6535: AND okx.book_type_code = nvl(p_book_type_code,okx.book_type_code);
6536:
6537: okx_ast_rec okx_ast_csr%ROWTYPE;

Line 7429: l_rep_pdt_book OKX_AST_BKS_V.Book_Type_Code%Type;

7425: l_start_date Date;
7426: l_rep_pdt_id Number;
7427: l_rep_deal_type Varchar2(150);
7428: l_Multi_GAAP_YN Varchar2(1) := 'N';
7429: l_rep_pdt_book OKX_AST_BKS_V.Book_Type_Code%Type;
7430: --Bug# 4631549
7431: l_orig_system_source_code okc_k_headers_b.orig_system_source_code%TYPE;
7432:
7433: ---------------- ---------------------------------------------------------------*/

Line 7614: FROM okx_ast_bks_v okx

7610: okx.book_type_code book_type_code,
7611: okx.book_class book_class,
7612: okx.asset_number asset_number,
7613: okx.asset_id asset_id
7614: FROM okx_ast_bks_v okx
7615: WHERE okx.asset_number = p_asset_number
7616: AND okx.book_type_code = nvl(p_book_type_code,okx.book_type_code);
7617:
7618: okx_ast_rec okx_ast_csr%ROWTYPE;

Line 7775: FROM OKX_AST_BKS_V

7771: --Cursor to check if asset_id already exists in tax_book
7772: CURSOR chk_ast_bk_csr(p_book_type_code IN Varchar2,
7773: p_asset_id IN Number) is
7774: SELECT '!'
7775: FROM OKX_AST_BKS_V
7776: WHERE asset_id = p_asset_id
7777: AND book_type_code = p_book_type_code
7778: AND status = 'A';
7779:

Line 7813: from okx_ast_bks_v

7809: select book_type_code,
7810: cost,
7811: salvage_value,
7812: percent_salvage_value
7813: from okx_ast_bks_v
7814: where asset_id = p_Asset_id
7815: and book_class = p_book_class;
7816:
7817: ast_corp_book_rec okx_ast_csr%ROWTYPE;