APPS.OKC_PARAMETERS_PUB SQL Statements

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

Line: 59

  OKC_PRM_PVT.insert_row(p_api_version,
                              p_init_msg_list,
                              x_return_status,
                              x_msg_count,
                              x_msg_data,
                              p_prmv_rec,
                              x_prmv_rec);

Line: 135

  procedure update_parameter(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_prmv_rec	IN	prmv_rec_type,
                              x_prmv_rec	OUT NOCOPY	prmv_rec_type) is
l_api_name                     CONSTANT VARCHAR2(30) := 'update_parameter';

Line: 158

  OKC_PRM_PVT.update_row(p_api_version,
                              p_init_msg_list,
                              x_return_status,
                              x_msg_count,
                              x_msg_data,
                              p_prmv_rec,
                              x_prmv_rec);

Line: 196

end update_parameter;

Line: 198

  procedure update_parameter(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_prmv_tbl	IN	prmv_tbl_type,
                              x_prmv_tbl	OUT NOCOPY	prmv_tbl_type) is
i NUMBER;

Line: 213

	    update_parameter(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_prmv_rec=>p_prmv_tbl(i),
                              x_prmv_rec=>x_prmv_tbl(i));

Line: 232

end update_parameter;

Line: 234

  procedure delete_parameter(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_prmv_rec	IN	prmv_rec_type) is
l_api_name                     CONSTANT VARCHAR2(30) := 'delete_parameter';

Line: 256

  OKC_PRM_PVT.delete_row(p_api_version,
                              p_init_msg_list,
                              x_return_status,
                              x_msg_count,
                              x_msg_data,
                              p_prmv_rec);

Line: 293

end delete_parameter;

Line: 295

  procedure delete_parameter(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_prmv_tbl	IN	prmv_tbl_type) is
i NUMBER;

Line: 309

	    delete_parameter(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_prmv_rec=>p_prmv_tbl(i));

Line: 327

end delete_parameter;

Line: 446

    G_Params_tbl.DELETE;

Line: 468

    G_Params_tbl.DELETE;