APPS.OKL_INV_FORMAT_DELETE_PVT SQL Statements

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

Line: 26

   		  SELECT id
		  FROM okl_invc_line_types_v
		  WHERE ity_id = p_ity_id;

Line: 31

		  SELECT id
		  FROM okl_invc_frmt_strms_v
		  WHERE (inf_id = p_inf_id OR
		         ilt_id = p_ilt_id);

Line: 58

  	  	  Okl_Ils_Pvt.delete_row(
      			p_api_version,
    			p_init_msg_list,
    			x_return_status,
    			x_msg_count,
    			x_msg_data,
    			p_ilsv_rec);

Line: 68

  	  Okl_Ilt_Pvt.delete_row(
      		p_api_version,
    		p_init_msg_list,
    		x_return_status,
    		x_msg_count,
    		x_msg_data,
    		p_iltv_rec);

Line: 79

  Okl_Ity_Pvt.delete_row(
        p_api_version,
    	p_init_msg_list,
    	x_return_status,
    	x_msg_count,
    	x_msg_data,
    	p_ityv_rec);

Line: 90

  Okl_Inf_Pvt.delete_row(
        p_api_version,
    	p_init_msg_list,
    	x_return_status,
    	x_msg_count,
    	x_msg_data,
    	p_infv_rec);

Line: 103

PROCEDURE delete_format(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_inf_del_tbl                  IN inf_del_tbl_type)
IS

p_inf_del_rec						  inf_del_rec_type;

Line: 118

	 	 delete_format(
     		  p_api_version,
    		  p_init_msg_list,
    		  x_return_status,
    		  x_msg_count,
    		  x_msg_data,
    		  p_inf_del_rec);