[Home] [Help]
PACKAGE: APPS.OKL_SETUP_STRMS_TRANS_PUB
Source
1 PACKAGE OKL_SETUP_STRMS_TRANS_PUB AUTHID CURRENT_USER AS
2 /* $Header: OKLPSMNS.pls 115.2 2002/07/22 23:38:55 smahapat noship $ */
3
4 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
5 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLERRM';
6 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLCODE';
7 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_SETUP_STRMS_TRANS_PUB' ;
8 G_APP_NAME CONSTANT VARCHAR2(3) := Okl_Api.G_APP_NAME;
9 G_FALSE CONSTANT VARCHAR2(1) := OKL_API.G_FALSE;
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 G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
14 G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;
15 G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;
16
17 G_EXCEPTION_HALT_PROCESSING EXCEPTION;
18 G_EXCEPTION_ERROR EXCEPTION;
19 G_EXCEPTION_UNEXPECTED_ERROR EXCEPTION;
20 G_EXCEPTION_EXCEPTION_DATA EXCEPTION;
21
22 SUBTYPE sgnv_rec_type IS okl_sgt_pvt.sgnv_rec_type;
23 SUBTYPE sgnv_tbl_type IS okl_sgt_pvt.sgnv_tbl_type;
24
25 PROCEDURE insert_translations (p_api_version IN NUMBER
26 ,p_init_msg_list IN VARCHAR2
27 ,p_sgnv_tbl IN sgnv_tbl_type
28 ,x_sgnv_tbl OUT NOCOPY sgnv_tbl_type
29 ,x_return_status OUT NOCOPY VARCHAR2
30 ,x_msg_count OUT NOCOPY NUMBER
31 ,x_msg_data OUT NOCOPY VARCHAR2);
32
33 PROCEDURE update_translations (p_api_version IN NUMBER
34 ,p_init_msg_list IN VARCHAR2
35 ,p_sgnv_tbl IN sgnv_tbl_type
36 ,x_sgnv_tbl OUT NOCOPY sgnv_tbl_type
37 ,x_return_status OUT NOCOPY VARCHAR2
38 ,x_msg_count OUT NOCOPY NUMBER
39 ,x_msg_data OUT NOCOPY VARCHAR2);
40
41 PROCEDURE delete_translations (p_api_version IN NUMBER
42 ,p_init_msg_list IN VARCHAR2
43 ,p_sgnv_tbl IN sgnv_tbl_type
44 ,x_return_status OUT NOCOPY VARCHAR2
45 ,x_msg_count OUT NOCOPY NUMBER
46 ,x_msg_data OUT NOCOPY VARCHAR2);
47
48 END OKL_SETUP_STRMS_TRANS_PUB;