The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE Update_Class_Operation(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 ,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_copv_rec IN copv_rec_type,
x_copv_rec OUT NOCOPY copv_rec_type) IS
l_copv_rec copv_rec_type;
l_api_name CONSTANT VARCHAR2(30) := 'Update_Class_Operation';
OKC_OPER_INST_PVT.Update_Class_Operation(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_copv_rec => l_copv_rec,
x_copv_rec => x_copv_rec);
END Update_Class_Operation;
PROCEDURE Update_Class_Operation(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 ,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_copv_tbl IN copv_tbl_type,
x_copv_tbl OUT NOCOPY copv_tbl_type) IS
l_api_name CONSTANT VARCHAR2(30) := 'Update_Class_Operation';
OKC_OPER_INST_PUB.Update_Class_Operation(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_copv_rec => p_copv_tbl(i),
x_copv_rec => x_copv_tbl(i));
END Update_Class_Operation;
PROCEDURE Delete_Class_Operation(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 ,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_copv_rec IN copv_rec_type) IS
l_copv_rec copv_rec_type;
l_api_name CONSTANT VARCHAR2(30) := 'Delete_Class_Operation';
OKC_OPER_INST_PVT.Delete_Class_Operation(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_copv_rec => l_copv_rec);
END Delete_Class_Operation;
PROCEDURE Delete_Class_Operation(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 ,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_copv_tbl IN copv_tbl_type) IS
l_api_name CONSTANT VARCHAR2(30) := 'Delete_Class_Operation';
OKC_OPER_INST_PUB.Delete_Class_Operation(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_copv_rec => p_copv_tbl(i));
END Delete_Class_Operation;
PROCEDURE Update_Operation_Instance(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 ,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_oiev_rec IN oiev_rec_type,
x_oiev_rec OUT NOCOPY oiev_rec_type) IS
l_oiev_rec oiev_rec_type;
l_api_name CONSTANT VARCHAR2(30) := 'Update_Operation_Instance';
OKC_OPER_INST_PVT.Update_Operation_Instance(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_oiev_rec => l_oiev_rec,
x_oiev_rec => x_oiev_rec);
END Update_Operation_Instance;
PROCEDURE Update_Operation_Instance(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 ,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_oiev_tbl IN oiev_tbl_type,
x_oiev_tbl OUT NOCOPY oiev_tbl_type) IS
l_api_name CONSTANT VARCHAR2(30) := 'Update_Operation_Instance';
OKC_OPER_INST_PUB.Update_Operation_Instance(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_oiev_rec => p_oiev_tbl(i),
x_oiev_rec => x_oiev_tbl(i));
END Update_Operation_Instance;
PROCEDURE Delete_Operation_Instance(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 ,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_oiev_rec IN oiev_rec_type) IS
l_oiev_rec oiev_rec_type;
l_api_name CONSTANT VARCHAR2(30) := 'Delete_Operation_Instance';
OKC_OPER_INST_PVT.Delete_Operation_Instance(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_oiev_rec => l_oiev_rec);
END Delete_Operation_Instance;
PROCEDURE Delete_Operation_Instance(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 ,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_oiev_tbl IN oiev_tbl_type) IS
l_api_name CONSTANT VARCHAR2(30) := 'Delete_Operation_Instance';
OKC_OPER_INST_PUB.Delete_Operation_Instance(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_oiev_rec => p_oiev_tbl(i));
END Delete_Operation_Instance;
PROCEDURE Update_Operation_Line(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 ,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_olev_rec IN olev_rec_type,
x_olev_rec OUT NOCOPY olev_rec_type) IS
l_olev_rec olev_rec_type;
l_api_name CONSTANT VARCHAR2(30) := 'Update_Operation_Line';
OKC_OPER_INST_PVT.Update_Operation_Line(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_olev_rec => l_olev_rec,
x_olev_rec => x_olev_rec);
END Update_Operation_Line;
PROCEDURE Update_Operation_Line(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 ,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_olev_tbl IN olev_tbl_type,
x_olev_tbl OUT NOCOPY olev_tbl_type) IS
l_api_name CONSTANT VARCHAR2(30) := 'Update_Operation_Line';
OKC_OPER_INST_PUB.Update_Operation_Line(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_olev_rec => p_olev_tbl(i),
x_olev_rec => x_olev_tbl(i));
END Update_Operation_Line;
PROCEDURE Delete_Operation_Line(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 ,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_olev_rec IN olev_rec_type) IS
l_olev_rec olev_rec_type;
l_api_name CONSTANT VARCHAR2(30) := 'Delete_Operation_Line';
OKC_OPER_INST_PVT.Delete_Operation_Line(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_olev_rec => l_olev_rec);
END Delete_Operation_Line;
PROCEDURE Delete_Operation_Line(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 ,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_olev_tbl IN olev_tbl_type) IS
l_api_name CONSTANT VARCHAR2(30) := 'Delete_Operation_Line';
OKC_OPER_INST_PUB.Delete_Operation_Line(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_olev_rec => p_olev_tbl(i));
END Delete_Operation_Line;
PROCEDURE Update_Masschange_Dtls(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 ,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_mrdv_rec IN mrdv_rec_type,
x_mrdv_rec OUT NOCOPY mrdv_rec_type) IS
l_mrdv_rec mrdv_rec_type;
l_api_name CONSTANT VARCHAR2(30) := 'Update_Masschange_Dtls';
OKC_OPER_INST_PVT.Update_Masschange_Dtls(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_mrdv_rec => l_mrdv_rec,
x_mrdv_rec => x_mrdv_rec);
END Update_Masschange_Dtls;
PROCEDURE Update_Masschange_Dtls(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 ,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_mrdv_tbl IN mrdv_tbl_type,
x_mrdv_tbl OUT NOCOPY mrdv_tbl_type) IS
l_api_name CONSTANT VARCHAR2(30) := 'Update_Masschange_Dtls';
OKC_OPER_INST_PUB.Update_Masschange_Dtls(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_mrdv_rec => p_mrdv_tbl(i),
x_mrdv_rec => x_mrdv_tbl(i));
END Update_Masschange_Dtls;
PROCEDURE Delete_Masschange_Dtls(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 ,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_mrdv_rec IN mrdv_rec_type) IS
l_mrdv_rec mrdv_rec_type;
l_api_name CONSTANT VARCHAR2(30) := 'Delete_Masschange_Dtls';
OKC_OPER_INST_PVT.Delete_Masschange_Dtls(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_mrdv_rec => l_mrdv_rec);
END Delete_Masschange_Dtls;
PROCEDURE Delete_Masschange_Dtls(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 ,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_mrdv_tbl IN mrdv_tbl_type) IS
l_api_name CONSTANT VARCHAR2(30) := 'Delete_Masschange_Dtls';
OKC_OPER_INST_PUB.Delete_Masschange_Dtls(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_mrdv_rec => p_mrdv_tbl(i));
END Delete_Masschange_Dtls;