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 969: p_book_type_code IN OKX_AST_BKS_V.BOOK_TYPE_CODE%TYPE,

965: x_msg_count OUT NOCOPY NUMBER,
966: x_msg_data OUT NOCOPY VARCHAR2,
967: p_chr_id IN NUMBER,
968: p_asset_id IN NUMBER,
969: p_book_type_code IN OKX_AST_BKS_V.BOOK_TYPE_CODE%TYPE,
970: p_adjust_cost IN NUMBER,
971: --Bug# 2657558
972: p_adj_salvage_value IN NUMBER,
973: --Bug# 2981308

Line 1015: l_book_type_code OKX_AST_BKS_V.BOOK_TYPE_CODE%TYPE;

1011: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
1012: l_group_recalss_option_rec FA_API_TYPES.group_reclass_options_rec_type;
1013:
1014: l_asset_id NUMBER;
1015: l_book_type_code OKX_AST_BKS_V.BOOK_TYPE_CODE%TYPE;
1016: l_adjust_cost NUMBER;
1017: --Bug # 2657558
1018: l_adj_salvage_value NUMBER;
1019: --Bug# 2981308

Line 1294: p_book_type_code IN OKX_AST_BKS_V.BOOK_TYPE_CODE%TYPE,

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

Line 1334: l_book_type_code OKX_AST_BKS_V.BOOK_TYPE_CODE%TYPE;

1330: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
1331: l_group_recalss_option_rec FA_API_TYPES.group_reclass_options_rec_type;
1332:
1333: l_asset_id NUMBER;
1334: l_book_type_code OKX_AST_BKS_V.BOOK_TYPE_CODE%TYPE;
1335:
1336: l_mesg_len NUMBER;
1337: l_mesg Varchar2(2000);
1338:

Line 3078: FROM OKX_AST_BKS_V

3074: --Cursor to check if asset_id already exists in tax_book
3075: CURSOR chk_ast_bk_csr(p_book_type_code IN Varchar2,
3076: p_asset_id IN Number) is
3077: SELECT '!'
3078: FROM OKX_AST_BKS_V
3079: WHERE asset_id = p_asset_id
3080: AND book_type_code = p_book_type_code
3081: AND status = 'A';
3082:

Line 3103: from okx_ast_bks_v

3099: --Bug# 2657558
3100: salvage_value,
3101: --Bug# 2981308
3102: percent_salvage_value
3103: from okx_ast_bks_v
3104: where asset_id = p_Asset_id
3105: and book_class = p_book_class;
3106:
3107: l_book_type_code OKX_AST_BKS_V.BOOK_TYPE_CODE%TYPE;

Line 3107: l_book_type_code OKX_AST_BKS_V.BOOK_TYPE_CODE%TYPE;

3103: from okx_ast_bks_v
3104: where asset_id = p_Asset_id
3105: and book_class = p_book_class;
3106:
3107: l_book_type_code OKX_AST_BKS_V.BOOK_TYPE_CODE%TYPE;
3108: l_asset_cost NUMBER;
3109: l_adjust_cost NUMBER;
3110: --Bug# 2657558
3111: l_salvage_value NUMBER;

Line 3148: FROM okx_ast_bks_v okx

3144: okx.book_type_code book_type_code,
3145: okx.book_class book_class,
3146: okx.asset_number asset_number,
3147: okx.asset_id asset_id
3148: FROM okx_ast_bks_v okx
3149: WHERE okx.asset_id = p_asset_id
3150: AND okx.book_type_code = p_book_type_code;
3151:
3152: okx_ast_rec okx_ast_csr%RowType;

Line 3198: l_rep_pdt_book OKX_AST_BKS_V.book_type_code%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
3198: l_rep_pdt_book OKX_AST_BKS_V.book_type_code%TYPE;
3199: l_Multi_GAAP_YN Varchar2(1);
3200: l_rep_pdt_bk_done Varchar2(1) default 'N';
3201:
3202: l_chrv_rec okl_okc_migration_pvt.chrv_rec_type;

Line 4670: l_rep_pdt_book OKX_AST_BKS_V.Book_Type_Code%Type;

4666: l_rep_pdt_id Number;
4667: l_tax_owner Varchar2(150);
4668: l_rep_deal_type Varchar2(150);
4669: l_Multi_GAAP_YN Varchar2(1);
4670: l_rep_pdt_book OKX_AST_BKS_V.Book_Type_Code%Type;
4671: --cursor to get tax owner rule
4672: Cursor town_rul_csr (pchrid number) is
4673: Select rule_information1 tax_owner,
4674: id

Line 5078: l_rep_pdt_book OKX_AST_BKS_V.Book_Type_Code%Type;

5074: l_rep_pdt_id Number;
5075: l_pdt_tax_owner Varchar2(150);
5076: l_rep_deal_type Varchar2(150);
5077: l_Multi_GAAP_YN Varchar2(1) := 'N';
5078: l_rep_pdt_book OKX_AST_BKS_V.Book_Type_Code%Type;
5079: --Bug# 3156924 :
5080: l_trx_number okl_trx_contracts.trx_number%TYPE;
5081: l_calling_interface varchar2(30) := 'OKL: Rebook';
5082:

Line 5221: FROM okx_ast_bks_v okx

5217: --Bug# 3950089
5218: okx.percent_salvage_value percent_salvage_value,
5219: --Bug# 5207066
5220: okx.current_units fa_current_units
5221: FROM okx_ast_bks_v okx
5222: WHERE okx.asset_number = p_asset_number
5223: AND okx.book_type_code = nvl(p_book_type_code,okx.book_type_code);
5224:
5225: okx_ast_rec okx_ast_csr%ROWTYPE;

Line 6442: l_rep_pdt_book OKX_AST_BKS_V.Book_Type_Code%Type;

6438: l_start_date Date;
6439: l_rep_pdt_id Number;
6440: l_rep_deal_type Varchar2(150);
6441: l_Multi_GAAP_YN Varchar2(1) := 'N';
6442: l_rep_pdt_book OKX_AST_BKS_V.Book_Type_Code%Type;
6443:
6444: l_dummy_amount NUMBER;
6445:
6446: --cursor to get the actual values from FA for the contract

Line 6461: FROM okx_ast_bks_v okx

6457: okx.book_type_code book_type_code,
6458: okx.book_class book_class,
6459: okx.asset_number asset_number,
6460: okx.asset_id asset_id
6461: FROM okx_ast_bks_v okx
6462: WHERE okx.asset_number = p_asset_number
6463: AND okx.book_type_code = nvl(p_book_type_code,okx.book_type_code);
6464:
6465: okx_ast_rec okx_ast_csr%ROWTYPE;

Line 7154: l_rep_pdt_book OKX_AST_BKS_V.Book_Type_Code%Type;

7150: l_start_date Date;
7151: l_rep_pdt_id Number;
7152: l_rep_deal_type Varchar2(150);
7153: l_Multi_GAAP_YN Varchar2(1) := 'N';
7154: l_rep_pdt_book OKX_AST_BKS_V.Book_Type_Code%Type;
7155: --Bug# 4631549
7156: l_orig_system_source_code okc_k_headers_b.orig_system_source_code%TYPE;
7157:
7158: ---------------- ---------------------------------------------------------------*/

Line 7339: FROM okx_ast_bks_v okx

7335: okx.book_type_code book_type_code,
7336: okx.book_class book_class,
7337: okx.asset_number asset_number,
7338: okx.asset_id asset_id
7339: FROM okx_ast_bks_v okx
7340: WHERE okx.asset_number = p_asset_number
7341: AND okx.book_type_code = nvl(p_book_type_code,okx.book_type_code);
7342:
7343: okx_ast_rec okx_ast_csr%ROWTYPE;

Line 7500: FROM OKX_AST_BKS_V

7496: --Cursor to check if asset_id already exists in tax_book
7497: CURSOR chk_ast_bk_csr(p_book_type_code IN Varchar2,
7498: p_asset_id IN Number) is
7499: SELECT '!'
7500: FROM OKX_AST_BKS_V
7501: WHERE asset_id = p_asset_id
7502: AND book_type_code = p_book_type_code
7503: AND status = 'A';
7504:

Line 7538: from okx_ast_bks_v

7534: select book_type_code,
7535: cost,
7536: salvage_value,
7537: percent_salvage_value
7538: from okx_ast_bks_v
7539: where asset_id = p_Asset_id
7540: and book_class = p_book_class;
7541:
7542: ast_corp_book_rec okx_ast_csr%ROWTYPE;