[Home] [Help]
PACKAGE: APPS.OKL_REV_LOSS_PROV_PUB
Source
1 package OKL_REV_LOSS_PROV_PUB AS
2 /* $Header: OKLPRPVS.pls 120.3 2005/10/30 03:34:28 appldev noship $ */
3
4 SUBTYPE lprv_rec_type IS okl_rev_loss_prov_pvt.lprv_rec_type;
5 SUBTYPE lprv_tbl_type IS okl_rev_loss_prov_pvt.lprv_tbl_type;
6
7 ------------------------------------------------------------------------------
8 -- Global Variables
9 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_REV_LOSS_PROV_PUB';
10 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
11 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
12 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
13
14 G_NO_DATA_FOUND CONSTANT VARCHAR2(200) := 'OKL_NOT_FOUND';
15 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
16 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
17 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
18 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
19 ------------------------------------------------------------------------------
20
21 -- this procedure reverses loss provision transactions
22 PROCEDURE REVERSE_LOSS_PROVISIONS (
23 p_api_version IN NUMBER
24 ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
25 ,x_msg_count OUT NOCOPY NUMBER
26 ,x_msg_data OUT NOCOPY VARCHAR2
27 ,x_return_status OUT NOCOPY VARCHAR2
28 ,p_lprv_rec IN lprv_rec_type);
29
30 PROCEDURE REVERSE_LOSS_PROVISIONS(
31 p_api_version IN NUMBER
32 ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
33 ,x_msg_count OUT NOCOPY NUMBER
34 ,x_msg_data OUT NOCOPY VARCHAR2
35 ,x_return_status OUT NOCOPY VARCHAR2
36 ,p_lprv_tbl IN lprv_tbl_type);
37
38 End OKL_REV_LOSS_PROV_PUB;