[Home] [Help]
PACKAGE: APPS.OKL_SETUP_TRXPARAMS_PUB
Source
1 PACKAGE OKL_SETUP_TRXPARAMS_PUB AUTHID CURRENT_USER AS
2 /* $Header: OKLPTXRS.pls 115.1 2004/07/02 02:56:16 sgorantl noship $ */
3
4 ---------------------------------------------------------------------------
5 -- GLOBAL VARIABLES
6 ---------------------------------------------------------------------------
7 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
8
9 G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKL_SETUP_TRXPARAMS_PUB';
10
11 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
12 G_MISS_NUM CONSTANT NUMBER := OKL_API.G_MISS_NUM;
13 G_MISS_CHAR CONSTANT VARCHAR2(1) := OKL_API.G_MISS_CHAR;
14 G_MISS_DATE CONSTANT DATE := OKL_API.G_MISS_DATE;
15 G_TRUE CONSTANT VARCHAR2(1) := OKL_API.G_TRUE;
16 G_FALSE CONSTANT VARCHAR2(1) := OKL_API.G_FALSE;
17
18 G_EXC_NAME_ERROR CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_ERROR';
19 G_EXC_NAME_UNEXP_ERROR CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_UNEXP_ERROR';
20 G_EXC_NAME_OTHERS CONSTANT VARCHAR2(6) := 'OTHERS';
21 G_API_TYPE CONSTANT VARCHAR(4) := '_PUB';
22 G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
23 G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;
24 G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;
25
26 G_EXCEPTION_HALT_PROCESSING EXCEPTION;
27 G_EXCEPTION_ERROR EXCEPTION;
28 G_EXCEPTION_UNEXPECTED_ERROR EXCEPTION;
29
30 SUBTYPE sxpv_rec_type IS okl_sif_trx_parms_pub.sxpv_rec_type;
31 SUBTYPE sxpv_tbl_type IS okl_sif_trx_parms_pub.sxpv_tbl_type;
32
33 PROCEDURE create_trx_parm(
34 p_api_version IN NUMBER,
35 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
36 x_return_status OUT NOCOPY VARCHAR2,
37 x_msg_count OUT NOCOPY NUMBER,
38 x_msg_data OUT NOCOPY VARCHAR2,
39 p_sxpv_rec IN sxpv_rec_type,
40 x_sxpv_rec OUT NOCOPY sxpv_rec_type);
41
42
43 PROCEDURE update_trx_parm(
44 p_api_version IN NUMBER,
45 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
46 x_return_status OUT NOCOPY VARCHAR2,
47 x_msg_count OUT NOCOPY NUMBER,
48 x_msg_data OUT NOCOPY VARCHAR2,
49 p_sxpv_rec IN sxpv_rec_type,
50 x_sxpv_rec OUT NOCOPY sxpv_rec_type);
51
52 PROCEDURE create_trx_parm(
53 p_api_version IN NUMBER,
54 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
55 x_return_status OUT NOCOPY VARCHAR2,
56 x_msg_count OUT NOCOPY NUMBER,
57 x_msg_data OUT NOCOPY VARCHAR2,
58 p_sxpv_tbl IN sxpv_tbl_type,
59 x_sxpv_tbl OUT NOCOPY sxpv_tbl_type);
60
61
62 PROCEDURE update_trx_parm(
63 p_api_version IN NUMBER,
64 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
65 x_return_status OUT NOCOPY VARCHAR2,
66 x_msg_count OUT NOCOPY NUMBER,
67 x_msg_data OUT NOCOPY VARCHAR2,
68 p_sxpv_tbl IN sxpv_tbl_type,
69 x_sxpv_tbl OUT NOCOPY sxpv_tbl_type);
70
71 PROCEDURE delete_trx_parm(
72 p_api_version IN NUMBER,
73 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
74 x_return_status OUT NOCOPY VARCHAR2,
75 x_msg_count OUT NOCOPY NUMBER,
76 x_msg_data OUT NOCOPY VARCHAR2,
77 p_sxpv_rec IN sxpv_rec_type,
78 x_sxpv_rec OUT NOCOPY sxpv_rec_type);
79
80 PROCEDURE delete_trx_parm(
81 p_api_version IN NUMBER,
82 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
83 x_return_status OUT NOCOPY VARCHAR2,
84 x_msg_count OUT NOCOPY NUMBER,
85 x_msg_data OUT NOCOPY VARCHAR2,
86 p_sxpv_tbl IN sxpv_tbl_type,
87 x_sxpv_tbl OUT NOCOPY sxpv_tbl_type);
88
89 PROCEDURE create_trx_asset_parm(
90 p_api_version IN NUMBER,
91 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
92 x_return_status OUT NOCOPY VARCHAR2,
93 x_msg_count OUT NOCOPY NUMBER,
94 x_msg_data OUT NOCOPY VARCHAR2,
95 p_sxpv_rec IN sxpv_rec_type,
96 x_sxpv_rec OUT NOCOPY sxpv_rec_type);
97
98 PROCEDURE update_trx_asset_parm(
99 p_api_version IN NUMBER,
100 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
101 x_return_status OUT NOCOPY VARCHAR2,
102 x_msg_count OUT NOCOPY NUMBER,
103 x_msg_data OUT NOCOPY VARCHAR2,
104 p_sxpv_rec IN sxpv_rec_type,
105 x_sxpv_rec OUT NOCOPY sxpv_rec_type);
106
107 PROCEDURE create_trx_asset_parm(
108 p_api_version IN NUMBER,
109 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
110 x_return_status OUT NOCOPY VARCHAR2,
111 x_msg_count OUT NOCOPY NUMBER,
112 x_msg_data OUT NOCOPY VARCHAR2,
113 p_sxpv_tbl IN sxpv_tbl_type,
114 x_sxpv_tbl OUT NOCOPY sxpv_tbl_type);
115
116 PROCEDURE update_trx_asset_parm(
117 p_api_version IN NUMBER,
118 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
119 x_return_status OUT NOCOPY VARCHAR2,
120 x_msg_count OUT NOCOPY NUMBER,
121 x_msg_data OUT NOCOPY VARCHAR2,
122 p_sxpv_tbl IN sxpv_tbl_type,
123 x_sxpv_tbl OUT NOCOPY sxpv_tbl_type);
124
125 END OKL_SETUP_TRXPARAMS_PUB;