[Home] [Help]
PACKAGE: APPS.OKL_UBB_WF_PVT
Source
1 PACKAGE OKL_UBB_WF_PVT AS
2 /* $Header: OKLRUWFS.pls 120.1 2005/10/30 03:17:39 appldev noship $ */
3
4 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_UBB_WF_PVT';
5 G_API_TYPE CONSTANT VARCHAR(4) := '_PVT';
6
7 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
8 G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
9
10 G_EXC_NAME_ERROR CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_ERROR';
11 G_EXC_NAME_UNEXP_ERROR CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_UNEXP_ERROR';
12 G_EXC_NAME_OTHERS CONSTANT VARCHAR2(6) := 'OTHERS';
13
14 G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
15 G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;
16 G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;
17 G_EXCEPTION_ERROR EXCEPTION;
18 G_EXCEPTION_UNEXPECTED_ERROR EXCEPTION;
19
20 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(30) := 'OKL_UNEXPECTED_ERROR';
21 G_SQLERRM_TOKEN CONSTANT VARCHAR2(30) := 'OKL_SQLERRM';
22 G_SQLCODE_TOKEN CONSTANT VARCHAR2(30) := 'OKL_SQLCODE';
23
24 PROCEDURE raise_create_event (p_api_version IN NUMBER,
25 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
26 x_return_status OUT NOCOPY VARCHAR2,
27 x_msg_count OUT NOCOPY NUMBER,
28 x_msg_data OUT NOCOPY VARCHAR2,
29 p_chr_id IN NUMBER,
30 p_ubb_id IN NUMBER);
31
32 PROCEDURE raise_update_event (p_api_version IN NUMBER,
33 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
34 x_return_status OUT NOCOPY VARCHAR2,
35 x_msg_count OUT NOCOPY NUMBER,
36 x_msg_data OUT NOCOPY VARCHAR2,
37 p_chr_id IN NUMBER,
38 p_ubb_id IN NUMBER);
39
40 PROCEDURE raise_delete_event (p_api_version IN NUMBER,
41 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
42 x_return_status OUT NOCOPY VARCHAR2,
43 x_msg_count OUT NOCOPY NUMBER,
44 x_msg_data OUT NOCOPY VARCHAR2,
45 p_chr_id IN NUMBER,
46 p_ubb_id IN NUMBER);
47
48
49 PROCEDURE raise_add_asset_event (p_api_version IN NUMBER,
50 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
51 x_return_status OUT NOCOPY VARCHAR2,
52 x_msg_count OUT NOCOPY NUMBER,
53 x_msg_data OUT NOCOPY VARCHAR2,
54 p_chr_id IN NUMBER,
55 p_ubb_id IN NUMBER,
56 p_cle_id IN NUMBER);
57
58 PROCEDURE raise_delete_asset_event (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_chr_id IN NUMBER,
64 p_ubb_id IN NUMBER,
65 p_cle_id IN NUMBER);
66 END OKL_UBB_WF_PVT;