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