DBA Data[Home] [Help]

APPS.OKC_CHANGE_REQUEST_PUB SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 18

    g_crtv_rec.last_updated_by       := p_crtv_rec.last_updated_by;
Line: 19

    g_crtv_rec.last_update_date      := p_crtv_rec.last_update_date;
Line: 20

    g_crtv_rec.last_update_login     := p_crtv_rec.last_update_login;
Line: 29

    g_corv_rec.last_updated_by       := p_corv_rec.last_updated_by;
Line: 30

    g_corv_rec.last_update_date      := p_corv_rec.last_update_date;
Line: 31

    g_corv_rec.last_update_login     := p_corv_rec.last_update_login;
Line: 40

    g_cprv_rec.last_updated_by       := p_cprv_rec.last_updated_by;
Line: 41

    g_cprv_rec.last_update_date      := p_cprv_rec.last_update_date;
Line: 42

    g_cprv_rec.last_update_login     := p_cprv_rec.last_update_login;
Line: 199

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';
Line: 233

  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);
Line: 282

end update_change_request;
Line: 293

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;
Line: 308

	    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));
Line: 327

end update_change_request;
Line: 337

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';
Line: 369

	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
  	);
Line: 418

end delete_change_request;
Line: 428

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;
Line: 442

      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));
Line: 460

end delete_change_request;
Line: 896

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';
Line: 945

  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);
Line: 994

end update_change;
Line: 1005

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;
Line: 1020

	    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));
Line: 1039

end update_change;
Line: 1050

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';
Line: 1083

  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);
Line: 1130

end delete_change;
Line: 1141

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;
Line: 1155

	    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));
Line: 1173

end delete_change;
Line: 1606

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';
Line: 1640

  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);
Line: 1689

end update_change_party_role;
Line: 1700

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;
Line: 1715

	    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));
Line: 1734

end update_change_party_role;
Line: 1745

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';
Line: 1778

  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);
Line: 1825

end delete_change_party_role;
Line: 1836

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;
Line: 1850

	    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));
Line: 1868

end delete_change_party_role;