[Home] [Help]
PACKAGE: APPS.OKL_AM_AMORTIZE_PUB
Source
1 PACKAGE OKL_AM_AMORTIZE_PUB AUTHID CURRENT_USER AS
2 /* $Header: OKLPTATS.pls 120.6 2008/02/29 10:48:24 asawanka ship $ */
3
4
5 ---------------------------------------------------------------------------
6 -- GLOBAL CONSTANTS
7 ---------------------------------------------------------------------------
8 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := okc_api.G_REQUIRED_VALUE;
9 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := okc_api.G_COL_NAME_TOKEN;
10 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_AM_AMORTIZE_PUB';
11 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
12 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
13 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
14 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
15
16 SUBTYPE thpv_rec_type IS okl_am_amortize_pvt.thpv_rec_type;
17 SUBTYPE tlpv_rec_type IS okl_am_amortize_pvt.tlpv_rec_type;
18
19 SUBTYPE thpv_tbl_type IS okl_am_amortize_pvt.thpv_tbl_type;
20 SUBTYPE tlpv_tbl_type IS okl_am_amortize_pvt.tlpv_tbl_type;
21
22 -- The main body of okl_am_amortize_pvt
23 PROCEDURE create_offlease_asset_trx( p_api_version IN NUMBER,
24 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
25 x_return_status OUT NOCOPY VARCHAR2,
26 x_msg_count OUT NOCOPY NUMBER,
27 x_msg_data OUT NOCOPY VARCHAR2,
28 p_kle_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM,
29 p_early_termination_yn IN VARCHAR2,
30 p_quote_eff_date IN DATE DEFAULT NULL, -- rmunjulu EDAT Added parameter
31 p_quote_accpt_date IN DATE DEFAULT NULL); -- rmunjulu EDAT Added parameter
32
33 PROCEDURE create_offlease_asset_trx(
34 p_api_version IN NUMBER,
35 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
36 x_return_status OUT NOCOPY VARCHAR2,
37 x_msg_count OUT NOCOPY NUMBER,
38 x_msg_data OUT NOCOPY VARCHAR2,
39 p_contract_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM,
40 p_early_termination_yn IN VARCHAR2,
41 p_quote_eff_date IN DATE DEFAULT NULL, -- rmunjulu EDAT Added parameter
42 p_quote_accpt_date IN DATE DEFAULT NULL); -- rmunjulu EDAT Added parameter
43
44
45
46 PROCEDURE update_offlease_asset_trx( p_api_version IN NUMBER,
47 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
48 x_return_status OUT NOCOPY VARCHAR2,
49 x_msg_count OUT NOCOPY NUMBER,
50 x_msg_data OUT NOCOPY VARCHAR2,
51 p_header_rec IN thpv_rec_type,
52 p_lines_rec IN tlpv_rec_type);
53
54 PROCEDURE update_offlease_asset_trx( p_api_version IN NUMBER,
55 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
56 x_return_status OUT NOCOPY VARCHAR2,
57 x_msg_count OUT NOCOPY NUMBER,
58 x_msg_data OUT NOCOPY VARCHAR2,
59 p_header_tbl IN thpv_tbl_type,
60 p_lines_tbl IN tlpv_tbl_type,
61 x_record_status OUT NOCOPY VARCHAR2);
62
63 -- RMUNJULU 3608615
64 SUBTYPE deprn_rec_type IS OKL_AM_AMORTIZE_PVT.deprn_rec_type;
65
66 -- RMUNJULU 3608615
67
68
69 PROCEDURE update_depreciation(
70 p_api_version IN NUMBER,
71 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
72 x_return_status OUT NOCOPY VARCHAR2,
73 x_msg_count OUT NOCOPY NUMBER,
74 x_msg_data OUT NOCOPY VARCHAR2,
75 p_deprn_rec IN deprn_rec_type);
76
77 END OKL_AM_AMORTIZE_PUB;