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_copv_rec IN OKC_COP_PVT.copv_rec_type,
36: x_copv_rec OUT NOCOPY OKC_COP_PVT.copv_rec_type) IS
37:
38: l_copv_rec OKC_COP_PVT.copv_rec_type := p_copv_rec;
39: BEGIN
32: x_return_status OUT NOCOPY VARCHAR2,
33: x_msg_count OUT NOCOPY NUMBER,
34: x_msg_data OUT NOCOPY VARCHAR2,
35: p_copv_rec IN OKC_COP_PVT.copv_rec_type,
36: x_copv_rec OUT NOCOPY OKC_COP_PVT.copv_rec_type) IS
37:
38: l_copv_rec OKC_COP_PVT.copv_rec_type := p_copv_rec;
39: BEGIN
40: -- initialize return status
34: x_msg_data OUT NOCOPY VARCHAR2,
35: p_copv_rec IN OKC_COP_PVT.copv_rec_type,
36: x_copv_rec OUT NOCOPY OKC_COP_PVT.copv_rec_type) IS
37:
38: l_copv_rec OKC_COP_PVT.copv_rec_type := p_copv_rec;
39: BEGIN
40: -- initialize return status
41: x_return_status := OKC_API.G_RET_STS_SUCCESS;
42:
39: BEGIN
40: -- initialize return status
41: x_return_status := OKC_API.G_RET_STS_SUCCESS;
42:
43: OKC_COP_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,
56: p_init_msg_list IN VARCHAR2 ,
57: x_return_status OUT NOCOPY VARCHAR2,
58: x_msg_count OUT NOCOPY NUMBER,
59: x_msg_data OUT NOCOPY VARCHAR2,
60: p_copv_tbl IN OKC_COP_PVT.copv_tbl_type,
61: x_copv_tbl OUT NOCOPY OKC_COP_PVT.copv_tbl_type) IS
62:
63: BEGIN
64:
57: x_return_status OUT NOCOPY VARCHAR2,
58: x_msg_count OUT NOCOPY NUMBER,
59: x_msg_data OUT NOCOPY VARCHAR2,
60: p_copv_tbl IN OKC_COP_PVT.copv_tbl_type,
61: x_copv_tbl OUT NOCOPY OKC_COP_PVT.copv_tbl_type) IS
62:
63: BEGIN
64:
65: OKC_COP_PVT.Insert_Row(
61: x_copv_tbl OUT NOCOPY OKC_COP_PVT.copv_tbl_type) IS
62:
63: BEGIN
64:
65: OKC_COP_PVT.Insert_Row(
66: p_api_version => p_api_version,
67: p_init_msg_list => p_init_msg_list,
68: x_return_status => x_return_status,
69: x_msg_count => x_msg_count,
78: p_init_msg_list IN VARCHAR2 ,
79: x_return_status OUT NOCOPY VARCHAR2,
80: x_msg_count OUT NOCOPY NUMBER,
81: x_msg_data OUT NOCOPY VARCHAR2,
82: p_copv_rec IN OKC_COP_PVT.copv_rec_type,
83: x_copv_rec OUT NOCOPY OKC_COP_PVT.copv_rec_type) IS
84:
85: BEGIN
86:
79: x_return_status OUT NOCOPY VARCHAR2,
80: x_msg_count OUT NOCOPY NUMBER,
81: x_msg_data OUT NOCOPY VARCHAR2,
82: p_copv_rec IN OKC_COP_PVT.copv_rec_type,
83: x_copv_rec OUT NOCOPY OKC_COP_PVT.copv_rec_type) IS
84:
85: BEGIN
86:
87: OKC_COP_PVT.Update_Row(
83: x_copv_rec OUT NOCOPY OKC_COP_PVT.copv_rec_type) IS
84:
85: BEGIN
86:
87: OKC_COP_PVT.Update_Row(
88: p_api_version => p_api_version,
89: p_init_msg_list => p_init_msg_list,
90: x_return_status => x_return_status,
91: x_msg_count => x_msg_count,
100: p_init_msg_list IN VARCHAR2 ,
101: x_return_status OUT NOCOPY VARCHAR2,
102: x_msg_count OUT NOCOPY NUMBER,
103: x_msg_data OUT NOCOPY VARCHAR2,
104: p_copv_tbl IN OKC_COP_PVT.copv_tbl_type,
105: x_copv_tbl OUT NOCOPY OKC_COP_PVT.copv_tbl_type) IS
106:
107: BEGIN
108:
101: x_return_status OUT NOCOPY VARCHAR2,
102: x_msg_count OUT NOCOPY NUMBER,
103: x_msg_data OUT NOCOPY VARCHAR2,
104: p_copv_tbl IN OKC_COP_PVT.copv_tbl_type,
105: x_copv_tbl OUT NOCOPY OKC_COP_PVT.copv_tbl_type) IS
106:
107: BEGIN
108:
109: OKC_COP_PVT.Update_Row(
105: x_copv_tbl OUT NOCOPY OKC_COP_PVT.copv_tbl_type) IS
106:
107: BEGIN
108:
109: OKC_COP_PVT.Update_Row(
110: p_api_version => p_api_version,
111: p_init_msg_list => p_init_msg_list,
112: x_return_status => x_return_status,
113: x_msg_count => x_msg_count,
122: p_init_msg_list IN VARCHAR2 ,
123: x_return_status OUT NOCOPY VARCHAR2,
124: x_msg_count OUT NOCOPY NUMBER,
125: x_msg_data OUT NOCOPY VARCHAR2,
126: p_copv_rec IN OKC_COP_PVT.copv_rec_type) IS
127:
128: BEGIN
129: OKC_COP_PVT.Delete_Row(
130: p_api_version => p_api_version,
125: x_msg_data OUT NOCOPY VARCHAR2,
126: p_copv_rec IN OKC_COP_PVT.copv_rec_type) IS
127:
128: BEGIN
129: OKC_COP_PVT.Delete_Row(
130: p_api_version => p_api_version,
131: p_init_msg_list => p_init_msg_list,
132: x_return_status => x_return_status,
133: x_msg_count => x_msg_count,
141: p_init_msg_list IN VARCHAR2 ,
142: x_return_status OUT NOCOPY VARCHAR2,
143: x_msg_count OUT NOCOPY NUMBER,
144: x_msg_data OUT NOCOPY VARCHAR2,
145: p_copv_tbl IN OKC_COP_PVT.copv_tbl_type) IS
146:
147: BEGIN
148:
149: OKC_COP_PVT.Delete_Row(
145: p_copv_tbl IN OKC_COP_PVT.copv_tbl_type) IS
146:
147: BEGIN
148:
149: OKC_COP_PVT.Delete_Row(
150: p_api_version => p_api_version,
151: p_init_msg_list => p_init_msg_list,
152: x_return_status => x_return_status,
153: x_msg_count => x_msg_count,
161: p_init_msg_list IN VARCHAR2 ,
162: x_return_status OUT NOCOPY VARCHAR2,
163: x_msg_count OUT NOCOPY NUMBER,
164: x_msg_data OUT NOCOPY VARCHAR2,
165: p_copv_rec IN OKC_COP_PVT.copv_rec_type) IS
166:
167: BEGIN
168:
169: OKC_COP_PVT.Lock_Row(
165: p_copv_rec IN OKC_COP_PVT.copv_rec_type) IS
166:
167: BEGIN
168:
169: OKC_COP_PVT.Lock_Row(
170: p_api_version => p_api_version,
171: p_init_msg_list => p_init_msg_list,
172: x_return_status => x_return_status,
173: x_msg_count => x_msg_count,
181: p_init_msg_list IN VARCHAR2 ,
182: x_return_status OUT NOCOPY VARCHAR2,
183: x_msg_count OUT NOCOPY NUMBER,
184: x_msg_data OUT NOCOPY VARCHAR2,
185: p_copv_tbl IN OKC_COP_PVT.copv_tbl_type) IS
186:
187: BEGIN
188:
189: OKC_COP_PVT.Lock_Row(
185: p_copv_tbl IN OKC_COP_PVT.copv_tbl_type) IS
186:
187: BEGIN
188:
189: OKC_COP_PVT.Lock_Row(
190: p_api_version => p_api_version,
191: p_init_msg_list => p_init_msg_list,
192: x_return_status => x_return_status,
193: x_msg_count => x_msg_count,
201: p_init_msg_list IN VARCHAR2 ,
202: x_return_status OUT NOCOPY VARCHAR2,
203: x_msg_count OUT NOCOPY NUMBER,
204: x_msg_data OUT NOCOPY VARCHAR2,
205: p_copv_rec IN OKC_COP_PVT.copv_rec_type) IS
206:
207: BEGIN
208:
209: OKC_COP_PVT.Validate_Row(
205: p_copv_rec IN OKC_COP_PVT.copv_rec_type) IS
206:
207: BEGIN
208:
209: OKC_COP_PVT.Validate_Row(
210: p_api_version => p_api_version,
211: p_init_msg_list => p_init_msg_list,
212: x_return_status => x_return_status,
213: x_msg_count => x_msg_count,
221: p_init_msg_list IN VARCHAR2 ,
222: x_return_status OUT NOCOPY VARCHAR2,
223: x_msg_count OUT NOCOPY NUMBER,
224: x_msg_data OUT NOCOPY VARCHAR2,
225: p_copv_tbl IN OKC_COP_PVT.copv_tbl_type) IS
226:
227: BEGIN
228:
229: OKC_COP_PVT.Validate_Row(
225: p_copv_tbl IN OKC_COP_PVT.copv_tbl_type) IS
226:
227: BEGIN
228:
229: OKC_COP_PVT.Validate_Row(
230: p_api_version => p_api_version,
231: p_init_msg_list => p_init_msg_list,
232: x_return_status => x_return_status,
233: x_msg_count => x_msg_count,