APPS.OKC_SALES_CREDIT_PUB SQL Statements

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

Line: 14

    g_scrv_rec.last_updated_by       := p_scrv_rec.last_updated_by;

Line: 15

    g_scrv_rec.last_update_date      := p_scrv_rec.last_update_date;

Line: 29

procedure Insert_Sales_Credit(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_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: 108

end Insert_Sales_Credit;

Line: 119

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

Line: 134

	    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: 153

end Insert_Sales_Credit;

Line: 155

procedure update_Sales_Credit(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_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: 186

  OKC_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: 234

end update_Sales_Credit;

Line: 245

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

Line: 260

	    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: 279

end update_Sales_Credit;

Line: 290

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

Line: 320

  OKC_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: 366

end delete_Sales_Credit;

Line: 377

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

Line: 391

	    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: 409

end delete_Sales_Credit;