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_scnv_rec IN OKC_SCN_PVT.scnv_rec_type,
74: x_scnv_rec OUT NOCOPY OKC_SCN_PVT.scnv_rec_type) IS
75:
76: l_scnv_rec OKC_SCN_PVT.scnv_rec_type := p_scnv_rec;
77: BEGIN
70: x_return_status OUT NOCOPY VARCHAR2,
71: x_msg_count OUT NOCOPY NUMBER,
72: x_msg_data OUT NOCOPY VARCHAR2,
73: p_scnv_rec IN OKC_SCN_PVT.scnv_rec_type,
74: x_scnv_rec OUT NOCOPY OKC_SCN_PVT.scnv_rec_type) IS
75:
76: l_scnv_rec OKC_SCN_PVT.scnv_rec_type := p_scnv_rec;
77: BEGIN
78: -- initialize return status
72: x_msg_data OUT NOCOPY VARCHAR2,
73: p_scnv_rec IN OKC_SCN_PVT.scnv_rec_type,
74: x_scnv_rec OUT NOCOPY OKC_SCN_PVT.scnv_rec_type) IS
75:
76: l_scnv_rec OKC_SCN_PVT.scnv_rec_type := p_scnv_rec;
77: BEGIN
78: -- initialize return status
79: x_return_status := OKC_API.G_RET_STS_SUCCESS;
80:
77: BEGIN
78: -- initialize return status
79: x_return_status := OKC_API.G_RET_STS_SUCCESS;
80:
81: OKC_SCN_PVT.Insert_Row(
82: p_api_version => p_api_version,
83: p_init_msg_list => p_init_msg_list,
84: x_return_status => x_return_status,
85: x_msg_count => x_msg_count,
101: p_init_msg_list IN VARCHAR2 ,
102: x_return_status OUT NOCOPY VARCHAR2,
103: x_msg_count OUT NOCOPY NUMBER,
104: x_msg_data OUT NOCOPY VARCHAR2,
105: p_scnv_tbl IN OKC_SCN_PVT.scnv_tbl_type,
106: x_scnv_tbl OUT NOCOPY OKC_SCN_PVT.scnv_tbl_type) IS
107:
108: BEGIN
109: OKC_SCN_PVT.Insert_Row(
102: x_return_status OUT NOCOPY VARCHAR2,
103: x_msg_count OUT NOCOPY NUMBER,
104: x_msg_data OUT NOCOPY VARCHAR2,
105: p_scnv_tbl IN OKC_SCN_PVT.scnv_tbl_type,
106: x_scnv_tbl OUT NOCOPY OKC_SCN_PVT.scnv_tbl_type) IS
107:
108: BEGIN
109: OKC_SCN_PVT.Insert_Row(
110: p_api_version => p_api_version,
105: p_scnv_tbl IN OKC_SCN_PVT.scnv_tbl_type,
106: x_scnv_tbl OUT NOCOPY OKC_SCN_PVT.scnv_tbl_type) IS
107:
108: BEGIN
109: OKC_SCN_PVT.Insert_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,
121: p_init_msg_list IN VARCHAR2 ,
122: x_return_status OUT NOCOPY VARCHAR2,
123: x_msg_count OUT NOCOPY NUMBER,
124: x_msg_data OUT NOCOPY VARCHAR2,
125: p_scnv_rec IN OKC_SCN_PVT.scnv_rec_type,
126: x_scnv_rec OUT NOCOPY OKC_SCN_PVT.scnv_rec_type) IS
127:
128: BEGIN
129:
122: x_return_status OUT NOCOPY VARCHAR2,
123: x_msg_count OUT NOCOPY NUMBER,
124: x_msg_data OUT NOCOPY VARCHAR2,
125: p_scnv_rec IN OKC_SCN_PVT.scnv_rec_type,
126: x_scnv_rec OUT NOCOPY OKC_SCN_PVT.scnv_rec_type) IS
127:
128: BEGIN
129:
130: OKC_SCN_PVT.Update_Row(
126: x_scnv_rec OUT NOCOPY OKC_SCN_PVT.scnv_rec_type) IS
127:
128: BEGIN
129:
130: OKC_SCN_PVT.Update_Row(
131: p_api_version => p_api_version,
132: p_init_msg_list => p_init_msg_list,
133: x_return_status => x_return_status,
134: 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_scnv_tbl IN OKC_SCN_PVT.scnv_tbl_type,
166: x_scnv_tbl OUT NOCOPY OKC_SCN_PVT.scnv_tbl_type) IS
167:
168: BEGIN
169: OKC_SCN_PVT.Update_Row(
162: x_return_status OUT NOCOPY VARCHAR2,
163: x_msg_count OUT NOCOPY NUMBER,
164: x_msg_data OUT NOCOPY VARCHAR2,
165: p_scnv_tbl IN OKC_SCN_PVT.scnv_tbl_type,
166: x_scnv_tbl OUT NOCOPY OKC_SCN_PVT.scnv_tbl_type) IS
167:
168: BEGIN
169: OKC_SCN_PVT.Update_Row(
170: p_api_version => p_api_version,
165: p_scnv_tbl IN OKC_SCN_PVT.scnv_tbl_type,
166: x_scnv_tbl OUT NOCOPY OKC_SCN_PVT.scnv_tbl_type) IS
167:
168: BEGIN
169: OKC_SCN_PVT.Update_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_scnv_rec IN OKC_SCN_PVT.scnv_rec_type) IS
186:
187: l_chr_id NUMBER;
188: Cursor l_scn_csr IS
189: SELECT chr_id
194: open l_scn_csr;
195: fetch l_scn_csr into l_chr_id;
196: close l_scn_csr;
197:
198: OKC_SCN_PVT.Delete_Row(
199: p_api_version => p_api_version,
200: p_init_msg_list => p_init_msg_list,
201: x_return_status => x_return_status,
202: x_msg_count => x_msg_count,
229: p_init_msg_list IN VARCHAR2 ,
230: x_return_status OUT NOCOPY VARCHAR2,
231: x_msg_count OUT NOCOPY NUMBER,
232: x_msg_data OUT NOCOPY VARCHAR2,
233: p_scnv_tbl IN OKC_SCN_PVT.scnv_tbl_type) IS
234:
235: BEGIN
236: OKC_SCN_PVT.Delete_Row(
237: p_api_version => p_api_version,
232: x_msg_data OUT NOCOPY VARCHAR2,
233: p_scnv_tbl IN OKC_SCN_PVT.scnv_tbl_type) IS
234:
235: BEGIN
236: OKC_SCN_PVT.Delete_Row(
237: p_api_version => p_api_version,
238: p_init_msg_list => p_init_msg_list,
239: x_return_status => x_return_status,
240: x_msg_count => x_msg_count,
247: p_init_msg_list IN VARCHAR2 ,
248: x_return_status OUT NOCOPY VARCHAR2,
249: x_msg_count OUT NOCOPY NUMBER,
250: x_msg_data OUT NOCOPY VARCHAR2,
251: p_scnv_rec IN OKC_SCN_PVT.scnv_rec_type) IS
252:
253: BEGIN
254: OKC_SCN_PVT.Lock_Row(
255: p_api_version => p_api_version,
250: x_msg_data OUT NOCOPY VARCHAR2,
251: p_scnv_rec IN OKC_SCN_PVT.scnv_rec_type) IS
252:
253: BEGIN
254: OKC_SCN_PVT.Lock_Row(
255: p_api_version => p_api_version,
256: p_init_msg_list => p_init_msg_list,
257: x_return_status => x_return_status,
258: x_msg_count => x_msg_count,
265: p_init_msg_list IN VARCHAR2 ,
266: x_return_status OUT NOCOPY VARCHAR2,
267: x_msg_count OUT NOCOPY NUMBER,
268: x_msg_data OUT NOCOPY VARCHAR2,
269: p_scnv_tbl IN OKC_SCN_PVT.scnv_tbl_type) IS
270:
271: BEGIN
272: OKC_SCN_PVT.Lock_Row(
273: p_api_version => p_api_version,
268: x_msg_data OUT NOCOPY VARCHAR2,
269: p_scnv_tbl IN OKC_SCN_PVT.scnv_tbl_type) IS
270:
271: BEGIN
272: OKC_SCN_PVT.Lock_Row(
273: p_api_version => p_api_version,
274: p_init_msg_list => p_init_msg_list,
275: x_return_status => x_return_status,
276: x_msg_count => x_msg_count,
283: p_init_msg_list IN VARCHAR2 ,
284: x_return_status OUT NOCOPY VARCHAR2,
285: x_msg_count OUT NOCOPY NUMBER,
286: x_msg_data OUT NOCOPY VARCHAR2,
287: p_scnv_rec IN OKC_SCN_PVT.scnv_rec_type) IS
288:
289: BEGIN
290: OKC_SCN_PVT.Validate_Row(
291: p_api_version => p_api_version,
286: x_msg_data OUT NOCOPY VARCHAR2,
287: p_scnv_rec IN OKC_SCN_PVT.scnv_rec_type) IS
288:
289: BEGIN
290: OKC_SCN_PVT.Validate_Row(
291: p_api_version => p_api_version,
292: p_init_msg_list => p_init_msg_list,
293: x_return_status => x_return_status,
294: x_msg_count => x_msg_count,
301: p_init_msg_list IN VARCHAR2 ,
302: x_return_status OUT NOCOPY VARCHAR2,
303: x_msg_count OUT NOCOPY NUMBER,
304: x_msg_data OUT NOCOPY VARCHAR2,
305: p_scnv_tbl IN OKC_SCN_PVT.scnv_tbl_type) IS
306:
307: BEGIN
308: OKC_SCN_PVT.Validate_Row(
309: p_api_version => p_api_version,
304: x_msg_data OUT NOCOPY VARCHAR2,
305: p_scnv_tbl IN OKC_SCN_PVT.scnv_tbl_type) IS
306:
307: BEGIN
308: OKC_SCN_PVT.Validate_Row(
309: p_api_version => p_api_version,
310: p_init_msg_list => p_init_msg_list,
311: x_return_status => x_return_status,
312: x_msg_count => x_msg_count,
578: END validate_section_content;
579:
580: PROCEDURE add_language IS
581: BEGIN
582: OKC_SCN_PVT.add_language;
583: END add_language;
584:
585: END OKC_SECTIONS_PVT;