[Home] [Help]
PACKAGE: APPS.OKL_SETUP_STRMS_TRANS_PVT
Source
1 PACKAGE OKL_SETUP_STRMS_TRANS_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLRSMNS.pls 115.2 2002/07/22 23:39:00 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_PVT' ;
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
26 PROCEDURE insert_translations (p_api_version IN NUMBER
27 ,p_init_msg_list IN VARCHAR2
28 ,p_sgnv_tbl IN sgnv_tbl_type
29 ,x_sgnv_tbl OUT NOCOPY sgnv_tbl_type
30 ,x_return_status OUT NOCOPY VARCHAR2
31 ,x_msg_count OUT NOCOPY NUMBER
32 ,x_msg_data OUT NOCOPY VARCHAR2);
33
34 PROCEDURE update_translations (p_api_version IN NUMBER
35 ,p_init_msg_list IN VARCHAR2
36 ,p_sgnv_tbl IN sgnv_tbl_type
37 ,x_sgnv_tbl OUT NOCOPY sgnv_tbl_type
38 ,x_return_status OUT NOCOPY VARCHAR2
39 ,x_msg_count OUT NOCOPY NUMBER
40 ,x_msg_data OUT NOCOPY VARCHAR2);
41
42 PROCEDURE delete_translations (p_api_version IN NUMBER
43 ,p_init_msg_list IN VARCHAR2
44 ,p_sgnv_tbl IN sgnv_tbl_type
45 ,x_return_status OUT NOCOPY VARCHAR2
46 ,x_msg_count OUT NOCOPY NUMBER
47 ,x_msg_data OUT NOCOPY VARCHAR2);
48
49 END OKL_SETUP_STRMS_TRANS_PVT;