APPS.OKS_SALES_CREDIT_PUB SQL Statements

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

Line: 13

    g_scrv_rec.last_updated_by       := p_scrv_rec.last_updated_by;

Line: 14

    g_scrv_rec.last_update_date      := p_scrv_rec.last_update_date;

Line: 28

procedure Insert_Sales_Credit(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_scrv_rec	IN	scrv_rec_type,
                              x_scrv_rec	OUT NOCOPY	scrv_rec_type) is
l_api_name                     CONSTANT VARCHAR2(30) := 'Insert_Sales_Credit';

Line: 107

end Insert_Sales_Credit;

Line: 118

procedure Insert_Sales_Credit(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_scrv_tbl	IN	scrv_tbl_type,
                              x_scrv_tbl	OUT NOCOPY	scrv_tbl_type) is
i NUMBER;

Line: 133

	    Insert_Sales_Credit(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_scrv_rec=>p_scrv_tbl(i),
                              x_scrv_rec=>x_scrv_tbl(i));

Line: 152

end Insert_Sales_Credit;

Line: 154

procedure update_Sales_Credit(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_scrv_rec	IN	scrv_rec_type,
                              x_scrv_rec	OUT NOCOPY	scrv_rec_type) is
l_api_name                     CONSTANT VARCHAR2(30) := 'update_Sales_Credit';

Line: 185

  OKS_SALES_CREDIT_PVT.update_Sales_Credit(p_api_version,
                              p_init_msg_list,
                              x_return_status,
                              x_msg_count,
                              x_msg_data,
                              g_scrv_rec,
                              x_scrv_rec);

Line: 233

end update_Sales_Credit;

Line: 244

procedure update_Sales_Credit(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_scrv_tbl	IN	scrv_tbl_type,
                              x_scrv_tbl	OUT NOCOPY	scrv_tbl_type) is
i NUMBER;

Line: 259

	    update_Sales_Credit(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_scrv_rec=>p_scrv_tbl(i),
                              x_scrv_rec=>x_scrv_tbl(i));

Line: 278

end update_Sales_Credit;

Line: 289

procedure delete_Sales_Credit(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_scrv_rec	IN	scrv_rec_type) is
l_api_name                     CONSTANT VARCHAR2(30) := 'delete_Sales_Credit';

Line: 319

  OKS_SALES_CREDIT_PVT.delete_Sales_Credit(p_api_version,
                              p_init_msg_list,
                              x_return_status,
                              x_msg_count,
                              x_msg_data,
                              g_scrv_rec);

Line: 365

end delete_Sales_Credit;

Line: 376

procedure delete_Sales_Credit(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_scrv_tbl	IN	scrv_tbl_type) is
i NUMBER;

Line: 390

	    delete_Sales_Credit(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_scrv_rec=>p_scrv_tbl(i));

Line: 408

end delete_Sales_Credit;