APPS.FTE_RATE_CHART_LOADER SQL Statements

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

Line: 17

  g_list_header_deleted	BOOLEAN := false;

Line: 167

      IF (l_action = 'DELETE') THEN
        FTE_RATE_CHART_PKG.DELETE_FROM_QP(p_list_header_id => g_qp_list_header_tbl(g_qp_list_header_tbl.COUNT).list_header_id,
					  p_name 	   => g_qp_list_header_tbl(g_qp_list_header_tbl.COUNT).name,
					  p_action	   => l_action,
					  p_line_number	   => p_line_number+i+1,
                          		  x_error_msg      => x_error_msg,
                           		  x_status         => x_status );

Line: 175

	g_list_header_deleted := true;

Line: 176

      ELSIF (l_action = 'UPDATE') THEN

	FTE_RATE_CHART_PKG.DELETE_FROM_QP(p_list_header_id => g_qp_list_header_tbl(g_qp_list_header_tbl.COUNT).list_header_id,
					  p_name 	   => g_qp_list_header_tbl(g_qp_list_header_tbl.COUNT).name,
					  p_action	   => l_action,
					  p_line_number	   => p_line_number+i+1,
            		  		  x_error_msg      => x_error_msg,
              				  x_status         => x_status );

Line: 186

        FTE_LANE_PKG.UPDATE_LANE_RATE_CHART(p_list_header_id => g_qp_list_header_tbl(g_qp_list_header_tbl.COUNT).list_header_id,
					    p_start_date => g_qp_list_header_tbl(g_qp_list_header_tbl.COUNT).start_date_active,
					    p_end_date => g_qp_list_header_tbl(g_qp_list_header_tbl.COUNT).end_date_active,
					    x_status => x_status,
					    x_error_msg => x_error_msg);

Line: 244

    IF (g_list_header_deleted) THEN
      FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);

Line: 324

    IF (g_list_header_deleted) THEN
      FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);

Line: 403

    IF (g_list_header_deleted) THEN
      FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);

Line: 517

      IF (l_action = 'DELETE') THEN
        FTE_RATE_CHART_PKG.DELETE_FROM_QP(p_list_header_id => g_qp_list_header_tbl(g_qp_list_header_tbl.COUNT).list_header_id,
					  p_name 	   => g_qp_list_header_tbl(g_qp_list_header_tbl.COUNT).name,
					  p_action	   => l_action,
					  p_line_number	   => p_line_number+i+1,
                          		  x_error_msg      => x_error_msg,
                           		  x_status         => x_status );

Line: 525

	g_list_header_deleted := true;

Line: 526

      ELSIF (l_action = 'UPDATE') THEN

	FTE_RATE_CHART_PKG.DELETE_FROM_QP(p_list_header_id => g_qp_list_header_tbl(g_qp_list_header_tbl.COUNT).list_header_id,
					  p_name 	   => g_qp_list_header_tbl(g_qp_list_header_tbl.COUNT).name,
					  p_action	   => l_action,
					  p_line_number	   => p_line_number+i+1,
            		  		  x_error_msg      => x_error_msg,
              				  x_status         => x_status );

Line: 588

    IF (g_list_header_deleted) THEN
      FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);

Line: 665

    IF (g_list_header_deleted) THEN
      FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);

Line: 824

    IF (g_list_header_deleted) THEN
      FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);

Line: 830

    FTE_RATE_CHART_PKG.INSERT_QP_INTERFACE_TABLES(p_qp_list_header_tbl		=> g_qp_list_header_tbl,
				    		  p_qp_list_line_tbl		=> g_qp_list_line_tbl,
				    		  p_qp_qualifier_tbl		=> g_qp_qualifier_tbl,
				    		  p_qp_pricing_attrib_tbl	=> g_qp_pricing_attrib_tbl,
						  p_qp_call			=> p_qp_call,
				 		  x_status			=> x_status,
				 		  x_error_msg			=> x_error_msg);

Line: 859

    g_qp_list_header_tbl.DELETE;

Line: 860

    g_qp_list_line_tbl.DELETE;

Line: 861

    g_qp_qualifier_tbl.DELETE;

Line: 862

    g_qp_pricing_attrib_tbl.DELETE;