APPS.OKL_INV_TYPE_DELETE_PVT SQL Statements

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

Line: 25

		  SELECT id
		  FROM okl_invc_frmt_strms_v
		  WHERE ilt_id = p_ilt_id;

Line: 49

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

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

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

PROCEDURE delete_type(
    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_ity_del_tbl                  IN ity_del_tbl_type)
IS

p_ity_del_rec						  ity_del_rec_type;

Line: 98

	 	 delete_type(
     		  p_api_version,
    		  p_init_msg_list,
    		  x_return_status,
    		  x_msg_count,
    		  x_msg_data,
    		  p_ity_del_rec);