29: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
30: x_return_status OUT NOCOPY VARCHAR2,
31: x_msg_count OUT NOCOPY NUMBER,
32: x_msg_data OUT NOCOPY VARCHAR2,
33: p_chr_rec IN OKE_CHR_PVT.chr_rec_type,
34: x_chr_rec OUT NOCOPY OKE_CHR_PVT.chr_rec_type) IS
35:
36: l_chr_rec OKE_CHR_PVT.chr_rec_type := p_chr_rec;
37: BEGIN
30: x_return_status OUT NOCOPY VARCHAR2,
31: x_msg_count OUT NOCOPY NUMBER,
32: x_msg_data OUT NOCOPY VARCHAR2,
33: p_chr_rec IN OKE_CHR_PVT.chr_rec_type,
34: x_chr_rec OUT NOCOPY OKE_CHR_PVT.chr_rec_type) IS
35:
36: l_chr_rec OKE_CHR_PVT.chr_rec_type := p_chr_rec;
37: BEGIN
38: -- initialize return status
32: x_msg_data OUT NOCOPY VARCHAR2,
33: p_chr_rec IN OKE_CHR_PVT.chr_rec_type,
34: x_chr_rec OUT NOCOPY OKE_CHR_PVT.chr_rec_type) IS
35:
36: l_chr_rec OKE_CHR_PVT.chr_rec_type := p_chr_rec;
37: BEGIN
38: -- initialize return status
39: x_return_status := OKE_API.G_RET_STS_SUCCESS;
40:
39: x_return_status := OKE_API.G_RET_STS_SUCCESS;
40:
41:
42:
43: OKE_CHR_PVT.Insert_Row(
44: p_api_version => p_api_version,
45: p_init_msg_list => p_init_msg_list,
46: x_return_status => x_return_status,
47: x_msg_count => x_msg_count,
66: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
67: x_return_status OUT NOCOPY VARCHAR2,
68: x_msg_count OUT NOCOPY NUMBER,
69: x_msg_data OUT NOCOPY VARCHAR2,
70: p_chr_tbl IN OKE_CHR_PVT.chr_tbl_type,
71: x_chr_tbl OUT NOCOPY OKE_CHR_PVT.chr_tbl_type) IS
72:
73: BEGIN
74:
67: x_return_status OUT NOCOPY VARCHAR2,
68: x_msg_count OUT NOCOPY NUMBER,
69: x_msg_data OUT NOCOPY VARCHAR2,
70: p_chr_tbl IN OKE_CHR_PVT.chr_tbl_type,
71: x_chr_tbl OUT NOCOPY OKE_CHR_PVT.chr_tbl_type) IS
72:
73: BEGIN
74:
75: OKE_CHR_PVT.Insert_Row(
71: x_chr_tbl OUT NOCOPY OKE_CHR_PVT.chr_tbl_type) IS
72:
73: BEGIN
74:
75: OKE_CHR_PVT.Insert_Row(
76:
77: p_api_version => p_api_version,
78: p_init_msg_list => p_init_msg_list,
79: x_return_status => x_return_status,
89: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
90: x_return_status OUT NOCOPY VARCHAR2,
91: x_msg_count OUT NOCOPY NUMBER,
92: x_msg_data OUT NOCOPY VARCHAR2,
93: p_chr_rec IN OKE_CHR_PVT.chr_rec_type,
94: x_chr_rec OUT NOCOPY OKE_CHR_PVT.chr_rec_type) IS
95:
96: BEGIN
97:
90: x_return_status OUT NOCOPY VARCHAR2,
91: x_msg_count OUT NOCOPY NUMBER,
92: x_msg_data OUT NOCOPY VARCHAR2,
93: p_chr_rec IN OKE_CHR_PVT.chr_rec_type,
94: x_chr_rec OUT NOCOPY OKE_CHR_PVT.chr_rec_type) IS
95:
96: BEGIN
97:
98: OKE_CHR_PVT.Update_Row(
94: x_chr_rec OUT NOCOPY OKE_CHR_PVT.chr_rec_type) IS
95:
96: BEGIN
97:
98: OKE_CHR_PVT.Update_Row(
99: p_api_version => p_api_version,
100: p_init_msg_list => p_init_msg_list,
101: x_return_status => x_return_status,
102: x_msg_count => x_msg_count,
124: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
125: x_return_status OUT NOCOPY VARCHAR2,
126: x_msg_count OUT NOCOPY NUMBER,
127: x_msg_data OUT NOCOPY VARCHAR2,
128: p_chr_tbl IN OKE_CHR_PVT.chr_tbl_type,
129: x_chr_tbl OUT NOCOPY OKE_CHR_PVT.chr_tbl_type) IS
130:
131: BEGIN
132:
125: x_return_status OUT NOCOPY VARCHAR2,
126: x_msg_count OUT NOCOPY NUMBER,
127: x_msg_data OUT NOCOPY VARCHAR2,
128: p_chr_tbl IN OKE_CHR_PVT.chr_tbl_type,
129: x_chr_tbl OUT NOCOPY OKE_CHR_PVT.chr_tbl_type) IS
130:
131: BEGIN
132:
133: OKE_CHR_PVT.Update_Row(
129: x_chr_tbl OUT NOCOPY OKE_CHR_PVT.chr_tbl_type) IS
130:
131: BEGIN
132:
133: OKE_CHR_PVT.Update_Row(
134: p_api_version => p_api_version,
135: p_init_msg_list => p_init_msg_list,
136: x_return_status => x_return_status,
137: x_msg_count => x_msg_count,
145: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
146: x_return_status OUT NOCOPY VARCHAR2,
147: x_msg_count OUT NOCOPY NUMBER,
148: x_msg_data OUT NOCOPY VARCHAR2,
149: p_chr_rec IN OKE_CHR_PVT.chr_rec_type) IS
150:
151:
152:
153: BEGIN
151:
152:
153: BEGIN
154:
155: OKE_CHR_PVT.delete_row(
156: p_api_version => p_api_version,
157: p_init_msg_list => p_init_msg_list,
158: x_return_status => x_return_status,
159: x_msg_count => x_msg_count,
181: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
182: x_return_status OUT NOCOPY VARCHAR2,
183: x_msg_count OUT NOCOPY NUMBER,
184: x_msg_data OUT NOCOPY VARCHAR2,
185: p_chr_tbl IN OKE_CHR_PVT.chr_tbl_type) IS
186:
187: BEGIN
188: OKE_CHR_PVT.Delete_Row(
189: p_api_version => p_api_version,
184: x_msg_data OUT NOCOPY VARCHAR2,
185: p_chr_tbl IN OKE_CHR_PVT.chr_tbl_type) IS
186:
187: BEGIN
188: OKE_CHR_PVT.Delete_Row(
189: p_api_version => p_api_version,
190: p_init_msg_list => p_init_msg_list,
191: x_return_status => x_return_status,
192: x_msg_count => x_msg_count,
199: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
200: x_return_status OUT NOCOPY VARCHAR2,
201: x_msg_count OUT NOCOPY NUMBER,
202: x_msg_data OUT NOCOPY VARCHAR2,
203: p_chr_rec IN OKE_CHR_PVT.chr_rec_type) IS
204:
205: BEGIN
206: OKE_CHR_PVT.Validate_Row(
207: p_api_version => p_api_version,
202: x_msg_data OUT NOCOPY VARCHAR2,
203: p_chr_rec IN OKE_CHR_PVT.chr_rec_type) IS
204:
205: BEGIN
206: OKE_CHR_PVT.Validate_Row(
207: p_api_version => p_api_version,
208: p_init_msg_list => p_init_msg_list,
209: x_return_status => x_return_status,
210: x_msg_count => x_msg_count,
217: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
218: x_return_status OUT NOCOPY VARCHAR2,
219: x_msg_count OUT NOCOPY NUMBER,
220: x_msg_data OUT NOCOPY VARCHAR2,
221: p_chr_tbl IN OKE_CHR_PVT.chr_tbl_type) IS
222:
223: BEGIN
224: OKE_CHR_PVT.Validate_Row(
225: p_api_version => p_api_version,
220: x_msg_data OUT NOCOPY VARCHAR2,
221: p_chr_tbl IN OKE_CHR_PVT.chr_tbl_type) IS
222:
223: BEGIN
224: OKE_CHR_PVT.Validate_Row(
225: p_api_version => p_api_version,
226: p_init_msg_list => p_init_msg_list,
227: x_return_status => x_return_status,
228: x_msg_count => x_msg_count,