[Home] [Help]
PACKAGE: APPS.OKL_AM_SYSTEM_PARAMS_PUB
Source
1 PACKAGE OKL_AM_SYSTEM_PARAMS_PUB AUTHID CURRENT_USER AS
2 /* $Header: OKLPASAS.pls 115.0 2003/10/17 21:20:21 rmunjulu noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 SUBTYPE sypv_rec_type IS OKL_AM_SYSTEM_PARAMS_PVT.sypv_rec_type;
7 SUBTYPE sypv_tbl_type IS OKL_AM_SYSTEM_PARAMS_PVT.sypv_tbl_type;
8
9 ---------------------------------------------------------------------------
10 -- GLOBAL MESSAGE CONSTANTS
11 ---------------------------------------------------------------------------
12 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
13 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
14 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
15 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
16 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';
17
18 ---------------------------------------------------------------------------
19 -- GLOBAL VARIABLES
20 ---------------------------------------------------------------------------
21 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_AM_SYSTEM_PARAMS_PUB';
22 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
23 G_APP_NAME_1 CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
24 G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;
25 G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;
26 G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
27 G_API_VERSION CONSTANT NUMBER := 1;
28 G_MISS_CHAR CONSTANT VARCHAR2(1) := OKL_API.G_MISS_CHAR;
29 G_MISS_NUM CONSTANT NUMBER := OKL_API.G_MISS_NUM;
30 G_MISS_DATE CONSTANT DATE := OKL_API.G_MISS_DATE;
31 G_TRUE CONSTANT VARCHAR2(1) := OKL_API.G_TRUE;
32 G_FALSE CONSTANT VARCHAR2(1) := OKL_API.G_FALSE;
33
34 ---------------------------------------------------------------------------
35 -- GLOBAL EXCEPTIONS
36 ---------------------------------------------------------------------------
37 G_EXCEPTION_UNEXPECTED_ERROR EXCEPTION;
38 G_EXCEPTION_ERROR EXCEPTION;
39 G_EXCEPTION_HALT EXCEPTION;
40
41 ---------------------------------------------------------------------------
42 -- Procedures and Functions
43 ---------------------------------------------------------------------------
44 PROCEDURE process_system_params(
45 p_api_version IN NUMBER,
46 p_init_msg_list IN VARCHAR2,
47 x_return_status OUT NOCOPY VARCHAR2,
48 x_msg_count OUT NOCOPY NUMBER,
49 x_msg_data OUT NOCOPY VARCHAR2,
50 p_sypv_rec IN sypv_rec_type,
51 x_sypv_rec OUT NOCOPY sypv_rec_type);
52 END OKL_AM_SYSTEM_PARAMS_PUB;