[Home] [Help]
PACKAGE: APPS.OKL_ACTIVATE_ASSET_PVT
Source
1 Package OKL_ACTIVATE_ASSET_PVT As
2 /* $Header: OKLRACAS.pls 120.3 2006/02/10 18:40:53 rpillay noship $ */
3 G_APP_NAME VARCHAR2(30) := OKL_API.G_APP_NAME;
4 SUBTYPE cimv_rec_type is OKL_OKC_MIGRATION_PVT.cimv_rec_type;
5 SUBTYPE cimv_tbl_type is OKL_OKC_MIGRATION_PVT.cimv_tbl_type;
6 SUBTYPE talv_rec_type is OKL_TXL_ASSETS_PUB.tlpv_rec_type;
7 SUBTYPE tadv_rec_type is OKL_TXD_ASSETS_PUB.adpv_rec_type;
8
9 Cursor bk_dfs_csr( ctId okx_ast_bks_v.depreciation_category%TYPE,
10 effDat okx_ast_bks_v.acquisition_date%TYPE,
11 bk okx_ast_bks_v.book_type_code%TYPE) IS
12 select life_in_months,
13 deprn_method,
14 adjusted_rate
15 from okx_ast_ct_bk_dfs_v
16 where category_id = ctId
17 and nvl(start_dpis, effDat) <= effDat
18 and nvl(end_dpis, effDat+1) > effDat
19 and book_type_code = bk;
20
21 Cursor l_hdr_csr( chrId NUMBER ) is
22 select khr.orig_system_source_code,
23 khr.start_date,
24 khr.template_yn,
25 khr.deal_type,
26 pdt.id pid,
27 nvl(pdt.reporting_pdt_id, -1) report_pdt_id,
28 khr.currency_code currency_code,
29 khr.term_duration term,
30 khr.authoring_org_id
31 from okl_k_headers_full_v khr,
32 okl_products_v pdt
33 where khr.id = chrId
34 and khr.pdt_id = pdt.id(+);
35
36
37 PROCEDURE ACTIVATE_ASSET(p_api_version IN NUMBER,
38 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
39 x_return_status OUT NOCOPY VARCHAR2,
40 x_msg_count OUT NOCOPY NUMBER,
41 x_msg_data OUT NOCOPY VARCHAR2,
42 p_chrv_id IN NUMBER,
43 p_call_mode IN VARCHAR2,
44 x_cimv_tbl OUT NOCOPY cimv_tbl_type);
45 PROCEDURE REBOOK_ASSET (p_api_version IN NUMBER,
46 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
47 x_return_status OUT NOCOPY VARCHAR2,
48 x_msg_count OUT NOCOPY NUMBER,
49 x_msg_data OUT NOCOPY VARCHAR2,
50 p_rbk_chr_id IN NUMBER);
51 PROCEDURE MASS_REBOOK_ASSET (p_api_version IN NUMBER,
52 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
53 x_return_status OUT NOCOPY VARCHAR2,
54 x_msg_count OUT NOCOPY NUMBER,
55 x_msg_data OUT NOCOPY VARCHAR2,
56 p_rbk_chr_id IN NUMBER
57 );
58 PROCEDURE RELEASE_ASSET (p_api_version IN NUMBER,
59 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
60 x_return_status OUT NOCOPY VARCHAR2,
61 x_msg_count OUT NOCOPY NUMBER,
62 x_msg_data OUT NOCOPY VARCHAR2,
63 p_rel_chr_id IN NUMBER);
64 ---------------------------------------------------------------------
65 --Bug# : pricing parameters
66 --------------------------------------------------------------------
67 --Bug# :
68 TYPE AST_DTL_REC_TYPE is RECORD
69 (ASSET_NUMBER FA_ADDITIONS.ASSET_NUMBER%TYPE,
70 BOOK_TYPE_CODE FA_BOOKS.BOOK_TYPE_CODE%TYPE,
71 BOOK_CLASS FA_BOOK_CONTROLS.BOOK_CLASS%TYPE,
72 DEPRN_METHOD FA_BOOKS.DEPRN_METHOD_CODE%TYPE,
73 DEPRN_METHOD_ID FA_METHODS.METHOD_ID%TYPE,
74 IN_SERVICE_DATE FA_BOOKS.DATE_PLACED_IN_SERVICE%TYPE,
75 LIFE_IN_MONTHS FA_BOOKS.LIFE_IN_MONTHS%TYPE,
76 BASIC_RATE FA_BOOKS.BASIC_RATE%TYPE,
77 ADJUSTED_RATE FA_BOOKS.ADJUSTED_RATE%TYPE,
78 SALVAGE_VALUE FA_BOOKS.SALVAGE_VALUE%TYPE,
79 PERCENT_SALVAGE_VALUE FA_BOOKS.PERCENT_SALVAGE_VALUE%TYPE,
80 PRORATE_CONVENTION_CODE FA_BOOKS.PRORATE_CONVENTION_CODE%TYPE,
81 COST FA_BOOKS.COST%TYPE
82 );
83 TYPE ast_dtl_tbl_type IS TABLE OF ast_dtl_rec_type INDEX BY BINARY_INTEGER;
84
85 --Bug# 3621875
86 Procedure Get_pricing_Parameters ( p_api_version IN NUMBER,
87 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
88 x_return_status OUT NOCOPY VARCHAR2,
89 x_msg_count OUT NOCOPY NUMBER,
90 x_msg_data OUT NOCOPY VARCHAR2,
91 p_chr_id IN NUMBER,
92 p_cle_id IN NUMBER,
93 x_ast_dtl_tbl OUT NOCOPY ast_dtl_tbl_type);
94 --Bug# 4899328
95 Procedure recalculate_asset_cost ( p_api_version IN NUMBER,
96 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
97 x_return_status OUT NOCOPY VARCHAR2,
98 x_msg_count OUT NOCOPY NUMBER,
99 x_msg_data OUT NOCOPY VARCHAR2,
100 p_chr_id IN NUMBER,
101 p_cle_id IN NUMBER);
102
103 END OKL_ACTIVATE_ASSET_PVT;