[Home] [Help]
PACKAGE: APPS.OKL_SYSTEM_PARAMS_ALL_PUB
Source
1 PACKAGE OKL_SYSTEM_PARAMS_ALL_PUB AS
2 /* $Header: OKLPSYPS.pls 120.3 2006/08/10 05:27:33 akrangan noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 SUBTYPE sypv_rec_type IS OKL_SYP_PVT.sypv_rec_type;
7 SUBTYPE sypv_tbl_type IS OKL_SYP_PVT.sypv_tbl_type;
8 ---------------------------------------------------------------------------
9 -- GLOBAL VARIABLES
10 ---------------------------------------------------------------------------
11 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_SYSTEM_PARAMS_ALL_PUB';
12 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
13 G_APP_NAME_1 CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
14 G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;
15 G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;
16 G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
17 G_ITEM_INV_ORG_ID CONSTANT VARCHAR2(50) := 'ITEM_INV_ORG_ID';
18 G_RPT_PROD_BOOK_TYPE_CODE CONSTANT VARCHAR2(50) := 'RPT_PROD_BOOK_TYPE_CODE';
19 G_ASST_ADD_BOOK_TYPE_CODE CONSTANT VARCHAR2(50) := 'ASST_ADD_BOOK_TYPE_CODE';
20 G_CCARD_REMITTANCE_ID CONSTANT VARCHAR2(50) := 'CCARD_REMITTANCE_ID';
21 ---------------------------------------------------------------------------
22 -- GLOBAL EXCEPTIONS
23 ---------------------------------------------------------------------------
24 G_EXCEPTION_UNEXPECTED_ERROR EXCEPTION;
25 G_EXCEPTION_ERROR EXCEPTION;
26 ---------------------------------------------------------------------------
27 -- Procedures and Functions
28 ---------------------------------------------------------------------------
29 PROCEDURE insert_system_parameters(
30 p_api_version IN NUMBER,
31 p_init_msg_list IN VARCHAR2,
32 x_return_status OUT NOCOPY VARCHAR2,
33 x_msg_count OUT NOCOPY NUMBER,
34 x_msg_data OUT NOCOPY VARCHAR2,
35 p_sypv_rec IN sypv_rec_type,
36 x_sypv_rec OUT NOCOPY sypv_rec_type);
37 PROCEDURE insert_system_parameters(
38 p_api_version IN NUMBER,
39 p_init_msg_list IN VARCHAR2,
40 x_return_status OUT NOCOPY VARCHAR2,
41 x_msg_count OUT NOCOPY NUMBER,
42 x_msg_data OUT NOCOPY VARCHAR2,
43 p_sypv_tbl IN sypv_tbl_type,
44 x_sypv_tbl OUT NOCOPY sypv_tbl_type);
45 PROCEDURE lock_system_parameters(
46 p_api_version IN NUMBER,
47 p_init_msg_list IN VARCHAR2,
48 x_return_status OUT NOCOPY VARCHAR2,
49 x_msg_count OUT NOCOPY NUMBER,
50 x_msg_data OUT NOCOPY VARCHAR2,
51 p_sypv_rec IN sypv_rec_type);
52 PROCEDURE lock_system_parameters(
53 p_api_version IN NUMBER,
54 p_init_msg_list IN VARCHAR2,
55 x_return_status OUT NOCOPY VARCHAR2,
56 x_msg_count OUT NOCOPY NUMBER,
57 x_msg_data OUT NOCOPY VARCHAR2,
58 p_sypv_tbl IN sypv_tbl_type);
59 PROCEDURE update_system_parameters(
60 p_api_version IN NUMBER,
61 p_init_msg_list IN VARCHAR2,
62 x_return_status OUT NOCOPY VARCHAR2,
63 x_msg_count OUT NOCOPY NUMBER,
64 x_msg_data OUT NOCOPY VARCHAR2,
65 p_sypv_rec IN sypv_rec_type,
66 x_sypv_rec OUT NOCOPY sypv_rec_type);
67 PROCEDURE update_system_parameters(
68 p_api_version IN NUMBER,
69 p_init_msg_list IN VARCHAR2,
70 x_return_status OUT NOCOPY VARCHAR2,
71 x_msg_count OUT NOCOPY NUMBER,
72 x_msg_data OUT NOCOPY VARCHAR2,
73 p_sypv_tbl IN sypv_tbl_type,
74 x_sypv_tbl OUT NOCOPY sypv_tbl_type);
75 PROCEDURE delete_system_parameters(
76 p_api_version IN NUMBER,
77 p_init_msg_list IN VARCHAR2,
78 x_return_status OUT NOCOPY VARCHAR2,
79 x_msg_count OUT NOCOPY NUMBER,
80 x_msg_data OUT NOCOPY VARCHAR2,
81 p_sypv_rec IN sypv_rec_type);
82 PROCEDURE delete_system_parameters(
83 p_api_version IN NUMBER,
84 p_init_msg_list IN VARCHAR2,
85 x_return_status OUT NOCOPY VARCHAR2,
86 x_msg_count OUT NOCOPY NUMBER,
87 x_msg_data OUT NOCOPY VARCHAR2,
88 p_sypv_tbl IN sypv_tbl_type);
89 PROCEDURE validate_system_parameters(
90 p_api_version IN NUMBER,
91 p_init_msg_list IN VARCHAR2,
92 x_return_status OUT NOCOPY VARCHAR2,
93 x_msg_count OUT NOCOPY NUMBER,
94 x_msg_data OUT NOCOPY VARCHAR2,
95 p_sypv_rec IN sypv_rec_type);
96 PROCEDURE validate_system_parameters(
97 p_api_version IN NUMBER,
98 p_init_msg_list IN VARCHAR2,
99 x_return_status OUT NOCOPY VARCHAR2,
100 x_msg_count OUT NOCOPY NUMBER,
101 x_msg_data OUT NOCOPY VARCHAR2,
102 p_sypv_tbl IN sypv_tbl_type);
103 FUNCTION get_system_param_value (
104 p_param_name IN VARCHAR2,
105 p_org_id IN NUMBER DEFAULT NULL
106 )
107 RETURN VARCHAR2;
108 END OKL_SYSTEM_PARAMS_ALL_PUB;