The following lines contain the word 'select', 'insert', 'update' or 'delete':
g_crtv_rec.last_updated_by := p_crtv_rec.last_updated_by;
g_crtv_rec.last_update_date := p_crtv_rec.last_update_date;
g_crtv_rec.last_update_login := p_crtv_rec.last_update_login;
g_corv_rec.last_updated_by := p_corv_rec.last_updated_by;
g_corv_rec.last_update_date := p_corv_rec.last_update_date;
g_corv_rec.last_update_login := p_corv_rec.last_update_login;
g_cprv_rec.last_updated_by := p_cprv_rec.last_updated_by;
g_cprv_rec.last_update_date := p_cprv_rec.last_update_date;
g_cprv_rec.last_update_login := p_cprv_rec.last_update_login;
procedure update_change_request(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_crtv_rec IN crtv_rec_type,
x_crtv_rec OUT NOCOPY crtv_rec_type) is
l_api_name CONSTANT VARCHAR2(30) := 'update_change_request';
OKC_CHANGE_REQUEST_PVT.update_change_request(
p_api_version => p_api_version,
p_init_msg_list => OKC_API.G_FALSE,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_crtv_rec => g_crtv_rec,
x_crtv_rec => x_crtv_rec);
end update_change_request;
procedure update_change_request(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_crtv_tbl IN crtv_tbl_type,
x_crtv_tbl OUT NOCOPY crtv_tbl_type) is
i NUMBER;
update_change_request(p_api_version=>p_api_version,
p_init_msg_list=>OKC_API.G_FALSE,
x_return_status=>l_return_status,
x_msg_count=>x_msg_count,
x_msg_data=>x_msg_data,
p_crtv_rec=>p_crtv_tbl(i),
x_crtv_rec=>x_crtv_tbl(i));
end update_change_request;
procedure delete_change_request(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_crtv_rec IN crtv_rec_type) is
l_api_name CONSTANT VARCHAR2(30) := 'delete_change_request';
OKC_CHANGE_REQUEST_PVT.delete_change_request
(
p_api_version => p_api_version,
p_init_msg_list => OKC_API.G_FALSE,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_crtv_rec => g_crtv_rec
);
end delete_change_request;
procedure delete_change_request(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_crtv_tbl IN crtv_tbl_type) is
i NUMBER;
delete_change_request(p_api_version=>p_api_version,
p_init_msg_list=>OKC_API.G_FALSE,
x_return_status=>l_return_status,
x_msg_count=>x_msg_count,
x_msg_data=>x_msg_data,
p_crtv_rec=>p_crtv_tbl(i));
end delete_change_request;
procedure update_change(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_corv_rec IN corv_rec_type,
x_corv_rec OUT NOCOPY corv_rec_type) is
l_api_name CONSTANT VARCHAR2(30) := 'update_change';
OKC_CHANGE_REQUEST_PVT.update_change(
p_api_version => p_api_version,
p_init_msg_list => OKC_API.G_FALSE,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_corv_rec => g_corv_rec,
x_corv_rec => x_corv_rec);
end update_change;
procedure update_change(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_corv_tbl IN corv_tbl_type,
x_corv_tbl OUT NOCOPY corv_tbl_type) is
i NUMBER;
update_change(p_api_version=>p_api_version,
p_init_msg_list=>OKC_API.G_FALSE,
x_return_status=>l_return_status,
x_msg_count=>x_msg_count,
x_msg_data=>x_msg_data,
p_corv_rec=>p_corv_tbl(i),
x_corv_rec=>x_corv_tbl(i));
end update_change;
procedure delete_change(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_corv_rec IN corv_rec_type) is
l_api_name CONSTANT VARCHAR2(30) := 'delete_change';
OKC_CHANGE_REQUEST_PVT.delete_change(
p_api_version => p_api_version,
p_init_msg_list => OKC_API.G_FALSE,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_corv_rec => g_corv_rec);
end delete_change;
procedure delete_change(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_corv_tbl IN corv_tbl_type) is
i NUMBER;
delete_change(p_api_version=>p_api_version,
p_init_msg_list=>OKC_API.G_FALSE,
x_return_status=>l_return_status,
x_msg_count=>x_msg_count,
x_msg_data=>x_msg_data,
p_corv_rec=>p_corv_tbl(i));
end delete_change;
procedure update_change_party_role(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_cprv_rec IN cprv_rec_type,
x_cprv_rec OUT NOCOPY cprv_rec_type) is
l_api_name CONSTANT VARCHAR2(30) := 'update_change_party_role';
OKC_CHANGE_REQUEST_PVT.update_change_party_role(
p_api_version => p_api_version,
p_init_msg_list => OKC_API.G_FALSE,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_cprv_rec => g_cprv_rec,
x_cprv_rec => x_cprv_rec);
end update_change_party_role;
procedure update_change_party_role(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_cprv_tbl IN cprv_tbl_type,
x_cprv_tbl OUT NOCOPY cprv_tbl_type) is
i NUMBER;
update_change_party_role(p_api_version=>p_api_version,
p_init_msg_list=>OKC_API.G_FALSE,
x_return_status=>l_return_status,
x_msg_count=>x_msg_count,
x_msg_data=>x_msg_data,
p_cprv_rec=>p_cprv_tbl(i),
x_cprv_rec=>x_cprv_tbl(i));
end update_change_party_role;
procedure delete_change_party_role(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_cprv_rec IN cprv_rec_type) is
l_api_name CONSTANT VARCHAR2(30) := 'delete_change_party_role';
OKC_CHANGE_REQUEST_PVT.delete_change_party_role(
p_api_version => p_api_version,
p_init_msg_list => OKC_API.G_FALSE,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_cprv_rec => g_cprv_rec);
end delete_change_party_role;
procedure delete_change_party_role(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_cprv_tbl IN cprv_tbl_type) is
i NUMBER;
delete_change_party_role(p_api_version=>p_api_version,
p_init_msg_list=>OKC_API.G_FALSE,
x_return_status=>l_return_status,
x_msg_count=>x_msg_count,
x_msg_data=>x_msg_data,
p_cprv_rec=>p_cprv_tbl(i));
end delete_change_party_role;