9:
10: ---------------------------------------------------------------------------
11: -- GLOBAL CONSTANTS
12: ---------------------------------------------------------------------- -----
13: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := okc_api.G_REQUIRED_VALUE;
14: G_INVALID_VALUE CONSTANT VARCHAR2(200) := okc_api.G_INVALID_VALUE;
15: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := okc_api.G_COL_NAME_TOKEN;
16: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_AM_AMORTIZE_PVT';
17: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
10: ---------------------------------------------------------------------------
11: -- GLOBAL CONSTANTS
12: ---------------------------------------------------------------------- -----
13: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := okc_api.G_REQUIRED_VALUE;
14: G_INVALID_VALUE CONSTANT VARCHAR2(200) := okc_api.G_INVALID_VALUE;
15: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := okc_api.G_COL_NAME_TOKEN;
16: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_AM_AMORTIZE_PVT';
17: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
18: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
11: -- GLOBAL CONSTANTS
12: ---------------------------------------------------------------------- -----
13: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := okc_api.G_REQUIRED_VALUE;
14: G_INVALID_VALUE CONSTANT VARCHAR2(200) := okc_api.G_INVALID_VALUE;
15: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := okc_api.G_COL_NAME_TOKEN;
16: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_AM_AMORTIZE_PVT';
17: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
18: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
19: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
22:
23:
24: -- create off-lease transaction
25: PROCEDURE create_offlease_asset_trx( p_api_version IN NUMBER,
26: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
27: x_return_status OUT NOCOPY VARCHAR2,
28: x_msg_count OUT NOCOPY NUMBER,
29: x_msg_data OUT NOCOPY VARCHAR2,
30: p_kle_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM,
33: p_quote_accpt_date IN DATE DEFAULT NULL); -- rmunjulu EDAT Added parameter
34:
35: -- create off-lease transaction
36: PROCEDURE create_offlease_asset_trx( p_api_version IN NUMBER,
37: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
38: x_return_status OUT NOCOPY VARCHAR2,
39: x_msg_count OUT NOCOPY NUMBER,
40: x_msg_data OUT NOCOPY VARCHAR2,
41: p_contract_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM,
45:
46:
47: -- update off-lease transaction
48: PROCEDURE update_offlease_asset_trx( p_api_version IN NUMBER,
49: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
50: x_return_status OUT NOCOPY VARCHAR2,
51: x_msg_count OUT NOCOPY NUMBER,
52: x_msg_data OUT NOCOPY VARCHAR2,
53: p_header_rec IN thpv_rec_type,
54: p_lines_rec IN tlpv_rec_type);
55:
56: -- update off-lease transaction
57: PROCEDURE update_offlease_asset_trx( p_api_version IN NUMBER,
58: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
59: x_return_status OUT NOCOPY VARCHAR2,
60: x_msg_count OUT NOCOPY NUMBER,
61: x_msg_data OUT NOCOPY VARCHAR2,
62: p_header_tbl IN thpv_tbl_type,
78: -- RMUNJULU 3608615
79: -- update off-lease transaction
80: PROCEDURE update_depreciation(
81: p_api_version IN NUMBER,
82: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
83: x_return_status OUT NOCOPY VARCHAR2,
84: x_msg_count OUT NOCOPY NUMBER,
85: x_msg_data OUT NOCOPY VARCHAR2,
86: p_deprn_rec IN deprn_rec_type);