APPS.OKS_ORDER_DETAILS_PUB SQL Statements

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

Line: 13

    g_codv_rec.last_updated_by       := p_codv_rec.last_updated_by;

Line: 14

    g_codv_rec.last_update_date      := p_codv_rec.last_update_date;

Line: 26

procedure Insert_Order_Detail(p_api_version	IN	NUMBER,
                              p_init_msg_list	IN	VARCHAR2 default OKC_API.G_FALSE,
                              x_return_status	OUT NOCOPY	VARCHAR2,
                              x_msg_count	OUT NOCOPY	NUMBER,
                              x_msg_data	OUT NOCOPY	VARCHAR2,
                              p_codv_rec	IN	codv_rec_type,
                              x_codv_rec	OUT NOCOPY	codv_rec_type) is
l_api_name                     CONSTANT VARCHAR2(30) := 'Insert_Order_Detail';

Line: 105

end Insert_Order_Detail;

Line: 116

procedure Insert_Order_Detail(p_api_version	IN	NUMBER,
                              p_init_msg_list	IN	VARCHAR2 default OKC_API.G_FALSE,
                              x_return_status	OUT NOCOPY	VARCHAR2,
                              x_msg_count	OUT NOCOPY	NUMBER,
                              x_msg_data	OUT NOCOPY	VARCHAR2,
                              p_codv_tbl	IN	codv_tbl_type,
                              x_codv_tbl	OUT NOCOPY	codv_tbl_type) is
i NUMBER;

Line: 131

	    Insert_Order_Detail(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_codv_rec=>p_codv_tbl(i),
                              x_codv_rec=>x_codv_tbl(i));

Line: 150

end Insert_Order_Detail;

Line: 152

procedure update_Order_Detail(p_api_version	IN	NUMBER,
                              p_init_msg_list	IN	VARCHAR2 default OKC_API.G_FALSE,
                              x_return_status	OUT NOCOPY	VARCHAR2,
                              x_msg_count	OUT NOCOPY	NUMBER,
                              x_msg_data	OUT NOCOPY	VARCHAR2,
                              p_codv_rec	IN	codv_rec_type,
                              x_codv_rec	OUT NOCOPY	codv_rec_type) is
l_api_name                     CONSTANT VARCHAR2(30) := 'update_Order_Detail';

Line: 183

  OKS_ORDER_DETAILs_PVT.update_Order_Detail(p_api_version,
                              p_init_msg_list,
                              x_return_status,
                              x_msg_count,
                              x_msg_data,
                              g_codv_rec,
                              x_codv_rec);

Line: 231

end update_Order_Detail;

Line: 242

procedure update_Order_Detail(p_api_version	IN	NUMBER,
                              p_init_msg_list	IN	VARCHAR2 default OKC_API.G_FALSE,
                              x_return_status	OUT NOCOPY	VARCHAR2,
                              x_msg_count	OUT NOCOPY	NUMBER,
                              x_msg_data	OUT NOCOPY	VARCHAR2,
                              p_codv_tbl	IN	codv_tbl_type,
                              x_codv_tbl	OUT NOCOPY	codv_tbl_type) is
i NUMBER;

Line: 257

	    update_Order_Detail(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_codv_rec=>p_codv_tbl(i),
                              x_codv_rec=>x_codv_tbl(i));

Line: 276

end update_Order_Detail;

Line: 287

procedure delete_Order_Detail(p_api_version	IN	NUMBER,
                              p_init_msg_list	IN	VARCHAR2 default OKC_API.G_FALSE,
                              x_return_status	OUT NOCOPY	VARCHAR2,
                              x_msg_count	OUT NOCOPY	NUMBER,
                              x_msg_data	OUT NOCOPY	VARCHAR2,
                              p_codv_rec	IN	codv_rec_type) is
l_api_name                     CONSTANT VARCHAR2(30) := 'delete_Order_Detail';

Line: 317

  OKS_ORDER_DETAILs_PVT.delete_Order_Detail(p_api_version,
                              p_init_msg_list,
                              x_return_status,
                              x_msg_count,
                              x_msg_data,
                              g_codv_rec);

Line: 363

end delete_Order_Detail;

Line: 374

procedure delete_Order_Detail(p_api_version	IN	NUMBER,
                              p_init_msg_list	IN	VARCHAR2 default OKC_API.G_FALSE,
                              x_return_status	OUT NOCOPY	VARCHAR2,
                              x_msg_count	OUT NOCOPY	NUMBER,
                              x_msg_data	OUT NOCOPY	VARCHAR2,
                              p_codv_tbl	IN	codv_tbl_type) is
i NUMBER;

Line: 388

	    delete_Order_Detail(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_codv_rec=>p_codv_tbl(i));

Line: 406

end delete_Order_Detail;