APPS.CN_IMP_REV_CL_PVT SQL Statements

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

Line: 37

	 SELECT
	   imp_line_id,
	   imp_header_id,
	   status_code,
	   error_code,
	   name,
       description

	   FROM CN_REVENUE_CLASSES_IMP_V
	   WHERE imp_header_id = p_imp_header_id
	   AND status_code = l_status_code
	   ;

Line: 51

      select  count(1)
        from cn_revenue_classes
        where name = p_revenue_class_name and org_id=p_org_id;

Line: 85

   SELECT name, status_code,server_flag,imp_map_id, source_column_num,
     import_type_code
     INTO l_imp_header.name ,l_imp_header.status_code ,
     l_imp_header.server_flag, l_imp_header.imp_map_id,
     l_imp_header.source_column_num,l_imp_header.import_type_code
     FROM cn_imp_headers
     WHERE imp_header_id = p_imp_header_id;

Line: 145

      CN_IMPORT_PVT.update_imp_lines
	       (p_imp_line_id => l_rev_cl_imp.imp_line_id,
	       p_status_code => 'FAIL',
	       p_error_code  => l_loading_status);

Line: 149

	   CN_IMPORT_PVT.update_imp_headers
	       (p_imp_header_id => p_imp_header_id,
	       p_status_code => 'IMPORT_FAIL',
               p_processed_row => l_processed_row,
	       p_failed_row => l_failed_row);

Line: 172

        CN_IMPORT_PVT.update_imp_lines
	       (p_imp_line_id => l_rev_cl_imp.imp_line_id,
	        p_status_code => 'COMPLETE',
	        p_error_code  => l_error_code);

Line: 188

      CN_IMPORT_PVT.update_imp_headers
	(p_imp_header_id => p_imp_header_id,
	 p_status_code => 'COMPLETE',
	 p_processed_row => l_processed_row,
	 p_failed_row => l_failed_row);